enrollments

Data source: Big Local News · About: Big Local

11,284 rows where state = "MA" and year = 2018 sorted by ccd_school_low_grade descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 11,284 ✖
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ▲ ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2233170 2233170 MA Worcester   school 2507080 162   Lunenburg 250708002882 1620605 Lunenburg: Advanced Community Experience Program   Special Education School No Ungraded UG UG 2018   sped_beyond_grade_12 8 0 0 0   0     0   1                             9.0 8 0 0 0   0     0   1                       9
2236260 2236260 MA Hampden   school 2511130 281   Springfield 251113002875 2810675 Springfield: Springfield Vocational Academy   Special Education School No Ungraded UG UG 2018   sped_beyond_grade_12 12 15 63 0   2     0   0                             92.0 12 15 63 0   2     0   0                       92
2239361 2239361 MA Middlesex   school 2508790 735   North Middlesex 250879002705 7350515 North Middlesex: Peter Fitzpatrick School   Regular School No Ungraded UG UG 2018   sped_beyond_grade_12 17 0 0 0   0     0   1                             18.0 17 0 0 0   0     0   1                       18
2228754 2228754 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 70 9 1 0   4     0   0   45 39                       84.0 70 9 1 0   4     0   0   45 39                 84
2228755 2228755 MA Plymouth   school 2501650 1   Abington 250165002727 10001 Abington: Abington Early Education Program   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228773 2228773 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   kindergarten 96 3 6 0   1     0   2   55 53                       108.0 96 3 6 0   1     0   2   55 53                 108
2228774 2228774 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   pre_kindergarten 48 0 2 0   0     0   1   30 21                       51.0 48 0 2 0   0     0   1   30 21                 51
2228775 2228775 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_1 72 0 5 1   0     0   3   39 42                       81.0 72 0 5 1   0     0   3   39 42                 81
2228776 2228776 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_2 89 0 4 0   0     0   6   53 46                       99.0 89 0 4 0   0     0   6   53 46                 99
2228777 2228777 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_3 96 0 7 0   0     0   2   46 59                       105.0 96 0 7 0   0     0   2   46 59                 105
2228778 2228778 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   grade_4 105 1 0 0   0     0   0   63 43                       106.0 105 1 0 0   0     0   0   63 43                 106
2228779 2228779 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet: Acushnet Elementary School   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228785 2228785 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam: Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 121 3 22 0   14     0   3   88 75                       163.0 121 3 22 0   14     0   3   88 75                 163
2228786 2228786 MA Hampden   school 2501800 5   Agawam 250180001499 50003 Agawam: Agawam Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228822 2228822 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   kindergarten 61 0 8 0   0     0   5   45 29                       74.0 61 0 8 0   0     0   5   45 29                 74
2228823 2228823 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten 23 0 1 0   0     1   0   14 11                       25.0 23 0 1 0   0     1   0   14 11                 25
2228824 2228824 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   grade_1 52 4 6 0   1     0   2   41 24                       65.0 52 4 6 0   1     0   2   41 24                 65
2228825 2228825 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   grade_2 62 2 4 1   0     0   4   30 43                       73.0 62 2 4 1   0     0   4   30 43                 73
2228826 2228826 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   grade_3 71 1 7 0   2     0   5   46 40                       86.0 71 1 7 0   2     0   5   46 40                 86
2228827 2228827 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   grade_4 64 1 3 0   0     0   4   45 27                       72.0 64 1 3 0   0     0   4   45 27                 72
2228828 2228828 MA Essex   school 2501860 7   Amesbury 250186000033 70005 Amesbury: Amesbury Elementary   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228829 2228829 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury: Charles C Cashman Elementary   Regular School No Elementary PK 04 2018   kindergarten 62 0 7 0   1     0   1   40 31                       71.0 62 0 7 0   1     0   1   40 31                 71
2228830 2228830 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury: Charles C Cashman Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten 26 0 2 0   0     0   0   17 11                       28.0 26 0 2 0   0     0   0   17 11                 28
2228831 2228831 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury: Charles C Cashman Elementary   Regular School No Elementary PK 04 2018   grade_1 62 4 4 0   1     0   1   36 36                       72.0 62 4 4 0   1     0   1   36 36                 72
2228832 2228832 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury: Charles C Cashman Elementary   Regular School No Elementary PK 04 2018   grade_2 78 1 10 0   2     0   1   55 37                       92.0 78 1 10 0   2     0   1   55 37                 92
2228833 2228833 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury: Charles C Cashman Elementary   Regular School No Elementary PK 04 2018   grade_3 79 1 6 1   2     0   2   47 44                       91.0 79 1 6 1   2     0   2   47 44                 91
2228834 2228834 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury: Charles C Cashman Elementary   Regular School No Elementary PK 04 2018   grade_4 73 2 9 0   2     0   3   51 38                       89.0 73 2 9 0   2     0   3   51 38                 89
2228835 2228835 MA Essex   school 2501860 7   Amesbury 250186000036 70010 Amesbury: Charles C Cashman Elementary   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228851 2228851 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   kindergarten 16 2 5 2   6     0   5   16 19                       36.0 16 2 5 2   6     0   5   16 19                 36
2228852 2228852 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten 23 5 15 0   14     0   8   36 29                       65.0 23 5 15 0   14     0   8   36 29                 65
2228853 2228853 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_1 18 3 7 0   8     0   5   23 18                       41.0 18 3 7 0   8     0   5   23 18                 41
2228854 2228854 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_2 25 5 11 0   10     0   0   29 22                       51.0 25 5 11 0   10     0   0   29 22                 51
2228855 2228855 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_3 22 2 16 0   9     0   4   27 26                       53.0 22 2 16 0   9     0   4   27 26                 53
2228856 2228856 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_4 21 2 19 0   10     0   6   34 24                       58.0 21 2 19 0   10     0   6   34 24                 58
2228857 2228857 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_5 15 7 8 0   7     0   2   19 20                       39.0 15 7 8 0   7     0   2   19 20                 39
2228858 2228858 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   grade_6 29 5 17 0   5     0   9   29 36                       65.0 29 5 17 0   5     0   9   29 36                 65
2228859 2228859 MA Hampshire   school 2501890 8   Amherst 250189000038 80009 Amherst: Crocker Farm Elementary   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228890 2228890 MA Essex   school 2501950 9   Andover 250195002366 90005 Andover: Shawsheen School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 47 2 7 0   27     0   2   61 24                       85.0 47 2 7 0   27     0   2   61 24                 85
2228891 2228891 MA Essex   school 2501950 9   Andover 250195002366 90005 Andover: Shawsheen School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228958 2228958 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington: Menotomy Preschool   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 48 4 8 0   18     0   7   58 27                       85.0 48 4 8 0   18     0   7   58 27                 85
2228959 2228959 MA Middlesex   school 2501980 10   Arlington 250198001681 100038 Arlington: Menotomy Preschool   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2228990 2228990 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 Ashland: William Pittaway Elementary   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 95 3 0 1   28     0   0   72 55                       127.0 95 3 0 1   28     0   0   72 55                 127
2228991 2228991 MA Middlesex   school 2502100 14   Ashland 250210002455 140005 Ashland: William Pittaway Elementary   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229015 2229015 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Attleboro: Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 134 10 20 0   7     0   13   110 74                       184.0 134 10 20 0   7     0   13   110 74                 184
2229016 2229016 MA Bristol   school 2502190 16   Attleboro 250219001610 160008 Attleboro: Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229068 2229068 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn: Pakachoag School   Regular School No Elementary PK 02 2018   kindergarten 60 0 5 0   2     0   4   36 35                       71.0 60 0 5 0   2     0   4   36 35                 71
2229069 2229069 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn: Pakachoag School   Regular School No Elementary PK 02 2018   pre_kindergarten 29 1 7 0   2     0   2   23 18                       41.0 29 1 7 0   2     0   2   23 18                 41
2229070 2229070 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn: Pakachoag School   Regular School No Elementary PK 02 2018   grade_1 78 4 5 0   5     0   5   49 48                       97.0 78 4 5 0   5     0   5   49 48                 97
2229071 2229071 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn: Pakachoag School   Regular School No Elementary PK 02 2018   grade_2 77 2 7 0   4     0   2   54 38                       92.0 77 2 7 0   4     0   2   54 38                 92
2229072 2229072 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn: Pakachoag School   Regular School No Elementary PK 02 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229087 2229087 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   kindergarten 27 11 7 0   1     0   2   26 22                       48.0 27 11 7 0   1     0   2   26 22                 48
2229088 2229088 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   pre_kindergarten 15 2 1 0   1     0   0   11 8                       19.0 15 2 1 0   1     0   0   11 8                 19
2229089 2229089 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_1 32 8 8 0   3     0   4   32 23                       55.0 32 8 8 0   3     0   4   32 23                 55
2229090 2229090 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_2 36 13 6 1   3     0   2   36 25                       61.0 36 13 6 1   3     0   2   36 25                 61
2229091 2229091 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_3 31 16 6 0   0     0   0   26 27                       53.0 31 16 6 0   0     0   0   26 27                 53
2229092 2229092 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_4 30 15 1 2   4     0   4   30 26                       56.0 30 15 1 2   4     0   4   30 26                 56
2229093 2229093 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_5 36 15 4 0   4     0   4   31 32                       63.0 36 15 4 0   4     0   4   31 32                 63
2229094 2229094 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   grade_6 32 17 4 1   2     0   3   33 26                       59.0 32 17 4 1   2     0   3   33 26                 59
2229095 2229095 MA Norfolk   school 2502250 18   Avon 250225000108 180010 Avon: Ralph D Butler   Regular School No Elementary PK 06 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229103 2229103 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 85 11 26 2   1     0   10   75 60                       135.0 85 11 26 2   1     0   10   75 60                 135
2229104 2229104 MA Barnstable   school 2502310 20   Barnstable 250231002851 200001 Barnstable: Enoch Cobb Early Learning Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229155 2229155 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Belchertown: Cold Spring   Regular School No Elementary PK KG 2018   kindergarten 136 0 14 0   3     0   5   79 79                       158.0 136 0 14 0   3     0   5   79 79                 158
2229156 2229156 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Belchertown: Cold Spring   Regular School No Elementary PK KG 2018   pre_kindergarten 29 1 2 0   1     0   2   16 19                       35.0 29 1 2 0   1     0   2   16 19                 35
2229157 2229157 MA Hampshire   school 2502430 24   Belchertown 250243000136 240005 Belchertown: Cold Spring   Regular School No Elementary PK KG 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229174 2229174 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham: Bellingham Early Childhood Center   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 98 3 2 0   3     1   3   59 51                       110.0 98 3 2 0   3     1   3   59 51                 110
2229175 2229175 MA Norfolk   school 2502460 25   Bellingham 250246000670 250003 Bellingham: Bellingham Early Childhood Center   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229221 2229221 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont: Roger E Wellington   Regular School No Elementary PK 04 2018   kindergarten 68 1 2 0   13     0   7   48 43                       91.0 68 1 2 0   13     0   7   48 43                 91
2229222 2229222 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont: Roger E Wellington   Regular School No Elementary PK 04 2018   pre_kindergarten 45 0 7 0   9     0   4   35 30                       65.0 45 0 7 0   9     0   4   35 30                 65
2229223 2229223 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont: Roger E Wellington   Regular School No Elementary PK 04 2018   grade_1 80 2 2 0   19     0   14   62 55                       117.0 80 2 2 0   19     0   14   62 55                 117
2229224 2229224 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont: Roger E Wellington   Regular School No Elementary PK 04 2018   grade_2 80 2 3 0   13     0   16   62 52                       114.0 80 2 3 0   13     0   16   62 52                 114
2229225 2229225 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont: Roger E Wellington   Regular School No Elementary PK 04 2018   grade_3 93 3 1 0   14     0   7   61 57                       118.0 93 3 1 0   14     0   7   61 57                 118
2229226 2229226 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont: Roger E Wellington   Regular School No Elementary PK 04 2018   grade_4 71 4 5 0   29     0   11   67 53                       120.0 71 4 5 0   29     0   11   67 53                 120
2229227 2229227 MA Middlesex   school 2502490 26   Belmont 250249000147 260035 Belmont: Roger E Wellington   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229238 2229238 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley: Berkley Community School   Regular School No Elementary PK 04 2018   kindergarten 72 2 0 0   0     0   3   37 40                       77.0 72 2 0 0   0     0   3   37 40                 77
2229239 2229239 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley: Berkley Community School   Regular School No Elementary PK 04 2018   pre_kindergarten 63 0 0 1   0     0   2   32 34                       66.0 63 0 0 1   0     0   2   32 34                 66
2229240 2229240 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley: Berkley Community School   Regular School No Elementary PK 04 2018   grade_1 87 0 1 0   0     0   1   48 41                       89.0 87 0 1 0   0     0   1   48 41                 89
2229241 2229241 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley: Berkley Community School   Regular School No Elementary PK 04 2018   grade_2 88 0 2 0   0     0   3   39 54                       93.0 88 0 2 0   0     0   3   39 54                 93
2229242 2229242 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley: Berkley Community School   Regular School No Elementary PK 04 2018   grade_3 83 0 1 0   0     0   4   44 44                       88.0 83 0 1 0   0     0   4   44 44                 88
2229243 2229243 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley: Berkley Community School   Regular School No Elementary PK 04 2018   grade_4 110 0 1 0   1     0   4   57 59                       116.0 110 0 1 0   1     0   4   57 59                 116
2229244 2229244 MA Bristol   school 2502520 27   Berkley 250252002513 270010 Berkley: Berkley Community School   Regular School No Elementary PK 04 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229250 2229250 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   kindergarten 25 0 1 0   0     0   1   11 16                       27.0 25 0 1 0   0     0   1   11 16                 27
2229251 2229251 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   pre_kindergarten 12 0 2 0   1     0   0   8 7                       15.0 12 0 2 0   1     0   0   8 7                 15
2229252 2229252 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_1 25 0 1 0   1     0   1   17 11                       28.0 25 0 1 0   1     0   1   17 11                 28
2229253 2229253 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_2 27 0 2 0   0     0   2   18 13                       31.0 27 0 2 0   0     0   2   18 13                 31
2229254 2229254 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_3 21 0 0 0   0     0   0   15 6                       21.0 21 0 0 0   0     0   0   15 6                 21
2229255 2229255 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_4 26 0 2 0   1     0   0   18 11                       29.0 26 0 2 0   1     0   0   18 11                 29
2229256 2229256 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   grade_5 30 0 1 0   0     0   1   16 16                       32.0 30 0 1 0   0     0   1   16 16                 32
2229257 2229257 MA Worcester   school 2502550 28   Berlin 250255000159 280005 Berlin: Berlin Memorial   Regular School No Elementary PK 05 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229258 2229258 MA Essex   school 2502640 30   Beverly 250264002854 300002 Beverly: McKeown School   Regular School No Prekindergarten PK PK 2018   pre_kindergarten 82 4 15 0   6     0   7   70 44                       114.0 82 4 15 0   6     0   7   70 44                 114
2229259 2229259 MA Essex   school 2502640 30   Beverly 250264002854 300002 Beverly: McKeown School   Regular School No Prekindergarten PK PK 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229360 2229360 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston: Lee Academy   Regular School No Elementary PK 03 2018   kindergarten 4 16 13 0   3     0   0   18 18                       36.0 4 16 13 0   3     0   0   18 18                 36
2229361 2229361 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston: Lee Academy   Regular School No Elementary PK 03 2018   pre_kindergarten 4 19 11 0   6     0   5   24 21                       45.0 4 19 11 0   6     0   5   24 21                 45
2229362 2229362 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston: Lee Academy   Regular School No Elementary PK 03 2018   grade_1 2 16 13 1   3     0   1   20 16                       36.0 2 16 13 1   3     0   1   20 16                 36
2229363 2229363 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston: Lee Academy   Regular School No Elementary PK 03 2018   grade_2 2 30 15 0   4     1   0   27 25                       52.0 2 30 15 0   4     1   0   27 25                 52
2229364 2229364 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston: Lee Academy   Regular School No Elementary PK 03 2018   grade_3 2 36 10 1   1     0   4   31 23                       54.0 2 36 10 1   1     0   4   31 23                 54
2229365 2229365 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston: Lee Academy   Regular School No Elementary PK 03 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0
2229366 2229366 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Boston: Baldwin Early Learning Center   Regular School No Elementary PK 01 2018   kindergarten 9 5 18 0   20     0   5   35 22                       57.0 9 5 18 0   20     0   5   35 22                 57
2229367 2229367 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Boston: Baldwin Early Learning Center   Regular School No Elementary PK 01 2018   pre_kindergarten 29 5 23 0   23     0   3   48 35                       83.0 29 5 23 0   23     0   3   48 35                 83
2229368 2229368 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Boston: Baldwin Early Learning Center   Regular School No Elementary PK 01 2018   grade_1 6 6 13 0   7     0   1   21 12                       33.0 6 6 13 0   7     0   1   21 12                 33
2229369 2229369 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Boston: Baldwin Early Learning Center   Regular School No Elementary PK 01 2018   sped_beyond_grade_12 * * * *   *     *   *                             0.0                                             0

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "enrollments" (
   [state] TEXT,
   [county] TEXT,
   [county_state_id] INTEGER,
   [admin_level] TEXT,
   [district_nces_id] INTEGER,
   [district_state_id] TEXT,
   [district_state_type] TEXT,
   [district] TEXT,
   [school_nces_id] INTEGER,
   [school_state_id] INTEGER,
   [school] TEXT,
   [school_state_type] TEXT,
   [ccd_school_type] TEXT,
   [ccd_charter_school] TEXT,
   [ccd_school_lvl] TEXT,
   [ccd_school_low_grade] TEXT,
   [ccd_school_high_grade] TEXT,
   [year] INTEGER,
   [term] TEXT,
   [grade] TEXT,
   [white] TEXT,
   [black] TEXT,
   [hispanic] TEXT,
   [native_american] TEXT,
   [native_american_alaskan_native] TEXT,
   [asian] TEXT,
   [native_hawaiian] TEXT,
   [asian_pacific_islander] TEXT,
   [native_hawaiian_pacific_islander] TEXT,
   [pacific_islander] TEXT,
   [multiracial] TEXT,
   [unknown_race] TEXT,
   [male] TEXT,
   [female] TEXT,
   [non_binary] TEXT,
   [unknown_gender] TEXT,
   [ell] TEXT,
   [ell_percent] TEXT,
   [homeless] TEXT,
   [homeless_percent] TEXT,
   [low_income] TEXT,
   [free_and_reduced] TEXT,
   [free_and_reduced_percent] TEXT,
   [disability] TEXT,
   [section_504] TEXT,
   [total] TEXT
, [white_int] INTEGER, [black_int] INTEGER, [hispanic_int] INTEGER, [native_american_int] INTEGER, [native_american_alaskan_native_int] INTEGER, [asian_int] INTEGER, [native_hawaiian_int] INTEGER, [asian_pacific_islander_int] INTEGER, [native_hawaiian_pacific_islander_int] INTEGER, [pacific_islander_int] INTEGER, [multiracial_int] INTEGER, [unknown_race_int] INTEGER, [male_int] INTEGER, [female_int] INTEGER, [non_binary_int] INTEGER, [unknown_gender_int] INTEGER, [ell_int] INTEGER, [homeless_int] INTEGER, [low_income_int] INTEGER, [free_and_reduced_int] INTEGER, [disability_int] INTEGER, [section_504_int] INTEGER, [total_int] INTEGER);
CREATE INDEX [idx_enrollments_state_grade]
    ON [enrollments] ([state], [grade]);
CREATE INDEX [idx_enrollments_grade]
    ON [enrollments] ([grade]);
CREATE INDEX [idx_enrollments_year]
    ON [enrollments] ([year]);
CREATE INDEX [idx_enrollments_state_year]
    ON [enrollments] ([state], [year]);
CREATE INDEX [idx_enrollments_school_nces_id]
    ON [enrollments] ([school_nces_id]);
CREATE INDEX [idx_enrollments_district_nces_id]
    ON [enrollments] ([district_nces_id]);