enrollments

Data source: Big Local News · About: Big Local

979 rows where grade = "grade_1", state = "MA" and year = 2019 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 979 ✖

grade ✖

  • grade_1 · 979 ✖
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
2040316 2040316 MA Suffolk   school 2502790 35   Boston 250279000011 350003 Baldwin Early Learning Center   Regular School No Elementary PK 01 2019   grade_1 5 4 14 0   9     0   3   24 11                       35.0 5 4 14 0   9     0   3   24 11                 35
2040328 2040328 MA Suffolk   school 2502790 35   Boston 250279002514 350006 ELC - West Zone   Regular School No Elementary PK 01 2019   grade_1 4 11 16 0   1     0   0   20 12                       32.0 4 11 16 0   1     0   0   20 12                 32
2040336 2040336 MA Suffolk   school 2502790 35   Boston 250279001118 350009 East Boston Early Childhood Center   Regular School No Elementary PK 01 2019   grade_1 11 7 31 0   0     0   0   21 28                       49.0 11 7 31 0   0     0   0   21 28                 49
2040339 2040339 MA Suffolk   school 2502790 35   Boston 250279001126 350010 Haynes Early Education Center   Regular School No Elementary PK 01 2019   grade_1 1 39 28 0   1     0   1   38 32                       70.0 1 39 28 0   1     0   1   38 32                 70
2040732 2040732 MA Suffolk   school 2502790 35   Boston 250279000303 350266 Dr. William Henderson Lower   Regular School No Elementary PK 01 2019   grade_1 27 12 14 0   15     0   2   32 38                       70.0 27 12 14 0   15     0   2   32 38                 70
2041641 2041641 MA Suffolk   school 2503540 57   Chelsea 250354000235 570003 Shurtleff Early Childhood   Regular School No Elementary PK 01 2019   grade_1 11 5 85 0   1     0   1   45 58                       103.0 11 5 85 0   1     0   1   45 58                 103
2041927 2041927 MA Worcester   school 2504230 77   Douglas 250423002798 770005 Douglas Primary School   Regular School No Elementary PK 01 2019   grade_1 71 0 4 0   0     0   6   40 41                       81.0 71 0 4 0   0     0   6   40 41                 81
2042519 2042519 MA Worcester   school 2505130 103   Gardner 250513000755 1030020 Waterford Street   Regular School No Elementary PK 01 2019   grade_1 121 7 45 0   7     0   10   97 93                       190.0 121 7 45 0   7     0   10   97 93                 190
2042588 2042588 MA Worcester   school 2505370 110   Grafton 250537000788 1100005 South Grafton Elementary   Regular School No Elementary PK 01 2019   grade_1 96 0 5 0   23     0   3   71 56                       127.0 96 0 5 0   23     0   3   71 56                 127
2042591 2042591 MA Worcester   school 2505370 110   Grafton 250537000787 1100025 North Grafton Elementary   Regular School No Elementary PK 01 2019   grade_1 86 1 3 0   9     0   5   53 51                       104.0 86 1 3 0   9     0   5   53 51                 104
2042961 2042961 MA Middlesex   school 2506330 139   Hopkinton 250633000918 1390005 Marathon Elementary School   Regular School No Elementary KG 01 2019   grade_1 144 2 6 0   62     0   12   111 115                       226.0 144 2 6 0   62     0   12   111 115                 226
2043512 2043512 MA Hampden   school 2507050 161   Ludlow 250705002663 1610010 East Street Elementary School   Regular School No Elementary PK 01 2019   grade_1 125 1 24 1   1     0   3   77 78                       155.0 125 1 24 1   1     0   3   77 78                 155
2043900 2043900 MA Norfolk   school 2507530 175   Medfield 250753000114 1750003 Memorial School   Regular School No Elementary PK 01 2019   grade_1 164 4 6 0   4     0   9   82 105                       187.0 164 4 6 0   4     0   9   82 105                 187
2043957 2043957 MA Norfolk   school 2507590 177   Medway 250759001185 1770013 John D Mc Govern Elementary   Regular School No Elementary PK 01 2019   grade_1 140 0 4 0   3     1   2   72 78                       150.0 140 0 4 0   3     1   2   72 78                 150
2044732 2044732 MA Worcester   school 2508940 214   Northbridge 250894002682 2140005 Northbridge Elementary   Regular School No Elementary PK 01 2019   grade_1 125 0 21 0   0     0   7   90 63                       153.0 125 0 21 0   0     0   7   90 63                 153
2044887 2044887 MA Worcester   school 2509270 226   Oxford 250927001479 2260010 Alfred M Chaffee   Regular School No Elementary PK 01 2019   grade_1 85 2 9 0   1     0   3   51 49                       100.0 85 2 9 0   1     0   3   51 49                 100
2045655 2045655 MA Worcester   school 2510770 271   Shrewsbury 251077002496 2710005 Beal School   Regular School No Elementary KG 01 2019   grade_1 29 5 6 1   27     0   5   46 27                       73.0 29 5 6 1   27     0   5   46 27                 73
2045803 2045803 MA Worcester   school 2510980 276   Southborough 251098001761 2760008 Mary E Finn School   Regular School No Elementary PK 01 2019   grade_1 88 0 7 0   30     0   8   67 66                       133.0 88 0 7 0   30     0   8   67 66                 133
2045817 2045817 MA Worcester   school 2511010 277   Southbridge 251101001764 2770010 Eastford Road   Regular School No Elementary PK 01 2019   grade_1 62 4 97 0   0     0   2   77 88                       165.0 62 4 97 0   0     0   2   77 88                 165
2045835 2045835 MA Hampshire   school 2510920 278   South Hadley 251092001753 2780015 Plains Elementary   Regular School No Elementary PK 01 2019   grade_1 103 3 28 0   2     0   3   67 72                       139.0 103 3 28 0   2     0   3   67 72                 139
2045920 2045920 MA Hampden   school 2511130 281   Springfield 251113001817 2810060 Margaret C Ells   Regular School No Elementary PK 01 2019   grade_1 3 5 31 0   0     0   0   29 10                       39.0 3 5 31 0   0     0   0   29 10                 39
2048129 2048129 MA Worcester   school 2502040 610   Ashburnham-Westminster 250204000397 6100010 Meetinghouse School   Regular School No Elementary KG 01 2019   grade_1 75 1 4 0   1     0   1   37 45                       82.0 75 1 4 0   1     0   1   37 45                 82
2048237 2048237 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002102 6250020 Merrill Elementary School   Regular School No Elementary KG 01 2019   grade_1 144 7 1 0   1     0   3   82 74                       156.0 144 7 1 0   1     0   3   82 74                 156
2048359 2048359 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000590 6580010 Mason Road School   Regular School No Elementary PK 01 2019   grade_1 103 2 18 0   1     0   4   67 61                       128.0 103 2 18 0   1     0   4   67 61                 128
2048362 2048362 MA Worcester   school 2504360 658   Dudley-Charlton Reg 250436000585 6580020 Charlton Elementary   Regular School No Elementary PK 01 2019   grade_1 119 0 12 1   0     0   7   74 65                       139.0 119 0 12 1   0     0   7   74 65                 139
2048472 2048472 MA Franklin   school 2505270 674   Gill-Montague 250527002816 6740015 Hillcrest Elementary School   Regular School No Elementary PK 01 2019   grade_1 51 0 10 0   0     0   4   37 28                       65.0 51 0 10 0   0     0   4   37 28                 65
2048522 2048522 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001598 6800025 Mile Tree Elementary   Regular School No Elementary PK 01 2019   grade_1 130 3 9 0   3     0   4   68 81                       149.0 130 3 9 0   3     0   4   68 81                 149
2048697 2048697 MA Worcester   school 2508280 720   Narragansett 250828001288 7200020 Templeton Center   Regular School No Elementary KG 01 2019   grade_1 78 0 7 0   0     0   3   46 42                       88.0 78 0 7 0   0     0   3   46 42                 88
2048871 2048871 MA Worcester   school 2500001 753   Quabbin 250000102401 7530020 New Braintree Grade   Regular School No Elementary KG 01 2019   grade_1 33 0 4 0   0     0   1   22 16                       38.0 33 0 4 0   0     0   1   22 16                 38
2039814 2039814 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Beaver Brook Elementary   Regular School No Elementary KG 02 2019   grade_1 119 7 9 3   3     0   1   66 76                       142.0 119 7 9 3   3     0   1   66 76                 142
2040009 2040009 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Henry E Warren Elementary   Regular School No Elementary KG 02 2019   grade_1 123 9 25 1   36     0   10   100 104                       204.0 123 9 25 1   36     0   10   100 104                 204
2040068 2040068 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Bryn Mawr   Regular School No Elementary KG 02 2019   grade_1 79 1 11 0   3     0   2   52 44                       96.0 79 1 11 0   3     0   2   52 44                 96
2040072 2040072 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Pakachoag School   Regular School No Elementary PK 02 2019   grade_1 62 0 7 0   2     0   4   37 38                       75.0 62 0 7 0   2     0   4   37 38                 75
2040129 2040129 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Lt Elezer Davis   Regular School No Elementary KG 02 2019   grade_1 121 13 8 0   50     0   19   92 119                       211.0 121 13 8 0   50     0   19   92 119                 211
2040367 2040367 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Higginson   Regular School No Elementary PK 02 2019   grade_1 1 17 26 0   0     0   2   24 22                       46.0 1 17 26 0   0     0   2   24 22                 46
2040371 2040371 MA Suffolk   school 2502790 35   Boston 250279002874 350016 Mattahunt Elementary School   Regular School No Elementary PK 02 2019   grade_1 5 69 25 0   0     0   3   62 40                       102.0 5 69 25 0   0     0   3   62 40                 102
2040385 2040385 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Beethoven   Regular School No Elementary PK 02 2019   grade_1 28 27 28 0   1     0   3   35 52                       87.0 28 27 28 0   1     0   3   35 52                 87
2041133 2041133 MA Essex   school 2502880 38   Boxford 250288000357 380005 Harry Lee Cole   Regular School No Elementary PK 02 2019   grade_1 77 0 0 0   2     0   6   43 42                       85.0 77 0 0 0   2     0   6   43 42                 85
2041196 2041196 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Stony Brook Elementary   Regular School No Elementary PK 02 2019   grade_1 53 0 1 0   0     0   1   34 21                       55.0 53 0 1 0   0     0   1   34 21                 55
2041688 2041688 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Belcher   Regular School No Elementary KG 02 2019   grade_1 47 9 38 0   1     0   2   52 45                       97.0 47 9 38 0   1     0   2   52 45                 97
2041781 2041781 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Joseph Osgood   Regular School No Elementary PK 02 2019   grade_1 100 3 2 0   1     0   0   46 60                       106.0 100 3 2 0   1     0   0   46 60                 106
2041984 2041984 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Chandler Elementary   Regular School No Elementary PK 02 2019   grade_1 175 2 5 0   0     0   8   98 92                       190.0 175 2 5 0   0     0   8   98 92                 190
2041996 2041996 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 Central   Regular School No Elementary PK 02 2019   grade_1 146 3 9 0   1     0   3   74 88                       162.0 146 3 9 0   1     0   3   74 88                 162
2042045 2042045 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 Meadow Brook   Regular School No Elementary PK 02 2019   grade_1 153 1 26 0   5     0   7   99 93                       192.0 153 1 26 0   5     0   7   99 93                 192
2042060 2042060 MA Bristol   school 2504620 88   Easton 250462000980 880003 Center School   Regular School No Elementary PK 02 2019   grade_1 72 4 5 0   1     0   3   51 34                       85.0 72 4 5 0   1     0   3   51 34                 85
2042064 2042064 MA Bristol   school 2504620 88   Easton 250462000624 880015 Parkview Elementary   Regular School No Elementary PK 02 2019   grade_1 73 2 8 2   1     0   5   38 53                       91.0 73 2 8 2   1     0   5   38 53                 91
2042068 2042068 MA Bristol   school 2504620 88   Easton 250462002381 880020 Moreau Hall   Regular School No Elementary PK 02 2019   grade_1 45 7 5 0   4     0   0   41 20                       61.0 45 7 5 0   4     0   0   41 20                 61
2042682 2042682 MA Plymouth   school 2505790 122   Hanover 250579000828 1220005 Center Elementary   Regular School No Elementary KG 02 2019   grade_1 95 0 7 0   0     0   3   61 44                       105.0 95 0 7 0   0     0   3   61 44                 105
2042724 2042724 MA Essex   school 2505970 128   Haverhill 250597002769 1280005 Consentino Annex at Bartlett School   Regular School No Elementary KG 02 2019   grade_1 18 4 20 0   0     0   1   16 27                       43.0 18 4 20 0   0     0   1   16 27                 43
2042784 2042784 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Walnut Square   Regular School No Elementary KG 02 2019   grade_1 25 2 14 0   1     0   1   17 26                       43.0 25 2 14 0   1     0   1   17 26                 43
2042861 2042861 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Placentino Elementary   Regular School No Elementary PK 02 2019   grade_1 160 1 13 0   19     0   13   107 99                       206.0 160 1 13 0   19     0   13   107 99                 206
2043038 2043038 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston Elementary   Regular School No Elementary KG 02 2019   grade_1 139 0 5 1   2     0   0   77 70                       147.0 139 0 5 1   2     0   0   77 70                 147
2043078 2043078 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 James F Hennessey   Regular School No Elementary PK 02 2019   grade_1 1 2 95 0   1     0   0   55 44                       99.0 1 2 95 0   1     0   0   55 44                 99
2043173 2043173 MA Worcester   school 2506720 151   Leicester 250672000974 1510010 Leicester Primary School   Regular School No Elementary PK 02 2019   grade_1 92 6 11 0   2     0   1   58 54                       112.0 92 6 11 0   2     0   1   58 54                 112
2043318 2043318 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Shaker Lane Elementary   Regular School No Elementary PK 02 2019   grade_1 112 0 3 0   20     0   1   60 76                       136.0 112 0 3 0   20     0   1   60 76                 136
2043527 2043527 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg Primary School   Regular School No Elementary PK 02 2019   grade_1 93 3 12 0   4     0   2   58 56                       114.0 93 3 12 0   4     0   2   58 56                 114
2043754 2043754 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Everett W Robinson   Regular School No Elementary KG 02 2019   grade_1 183 7 9 1   20     0   14   128 106                       234.0 183 7 9 1   20     0   14   128 106                 234
2043864 2043864 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Kenneth Coombs School   Regular School No Elementary PK 02 2019   grade_1 85 2 4 6   3     0   14   66 48                       114.0 85 2 4 6   3     0   14   66 48                 114
2044075 2044075 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Fuller Meadow   Regular School No Elementary KG 02 2019   grade_1 69 2 1 0   5     0   1   36 42                       78.0 69 2 1 0   5     0   1   36 42                 78
2044083 2044083 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Memorial   Regular School No Elementary KG 02 2019   grade_1 95 3 47 0   1     0   7   80 73                       153.0 95 3 47 0   1     0   7   80 73                 153
2044086 2044086 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Brookside   Regular School No Elementary KG 02 2019   grade_1 96 8 44 1   0     0   7   87 69                       156.0 96 8 44 1   0     0   7   87 69                 156
2044188 2044188 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket Elementary   Regular School No Elementary PK 02 2019   grade_1 55 8 54 0   1     0   5   61 62                       123.0 55 8 54 0   1     0   5   61 62                 123
2044561 2044561 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 H Olive Day   Regular School No Elementary PK 02 2019   grade_1 114 1 1 0   3     0   0   68 51                       119.0 114 1 1 0   3     0   0   68 51                 119
2044874 2044874 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Fisher Hill   Regular School No Elementary PK 02 2019   grade_1 57 1 7 0   0     0   3   39 29                       68.0 57 1 7 0   0     0   3   39 29                 68
2045515 2045515 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Forestdale School   Regular School No Elementary PK 02 2019   grade_1 156 2 12 0   5     0   3   89 89                       178.0 156 2 12 0   5     0   3   89 89                 178
2046270 2046270 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton Early Learning   Regular School No Elementary PK 02 2019   grade_1 79 0 4 1   1     0   0   40 45                       85.0 79 0 4 1   1     0   0   40 45                 85
2046311 2046311 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Gardner   Regular School No Elementary KG 02 2019   grade_1 82 1 0 0   1     0   2   48 38                       86.0 82 1 0 0   1     0   2   48 38                 86
2046315 2046315 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Mark G Hoyle Elementary   Regular School No Elementary PK 02 2019   grade_1 67 0 1 0   1     0   1   33 37                       70.0 67 0 1 0   1     0   1   33 37                 70
2046385 2046385 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 L F Dewing   Regular School No Elementary PK 02 2019   grade_1 99 5 7 0   7     0   0   60 58                       118.0 99 5 7 0   7     0   0   60 58                 118
2046388 2046388 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Heath-Brook   Regular School No Elementary KG 02 2019   grade_1 110 1 1 0   1     0   2   54 61                       115.0 110 1 1 0   1     0   2   54 61                 115
2046533 2046533 MA Middlesex   school 2512000 308   Waltham 251200002863 3080001 Waltham Public Schools Dual Language Program   Regular School No Elementary KG 02 2019   grade_1 8 1 29 0   0     0   0   27 11                       38.0 8 1 29 0   0     0   0   27 11                 38
2046601 2046601 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 John William Decas   Regular School No Elementary PK 02 2019   grade_1 136 17 21 3   1     0   21   107 92                       199.0 136 17 21 3   1     0   21   107 92                 199
2046846 2046846 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Nabnasset   Regular School No Elementary KG 02 2019   grade_1 97 1 1 0   22     0   6   77 50                       127.0 97 1 1 0   22     0   6   77 50                 127
2046849 2046849 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Col John Robinson   Regular School No Elementary KG 02 2019   grade_1 73 0 3 0   38     0   4   59 59                       118.0 73 0 3 0   38     0   4   59 59                 118
2046855 2046855 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Rita E. Miller Elementary School   Regular School No Elementary KG 02 2019   grade_1 69 1 3 0   42     0   4   59 60                       119.0 69 1 3 0   42     0   4   59 60                 119
2046897 2046897 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Alice A Macomber   Regular School No Elementary PK 02 2019   grade_1 100 1 2 0   0     0   4   54 53                       107.0 100 1 2 0   0     0   4   54 53                 107
2047073 2047073 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Memorial   Regular School No Elementary KG 02 2019   grade_1 90 0 5 0   2     0   5   55 47                       102.0 90 0 5 0   2     0   5   55 47                 102
2047130 2047130 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2019   grade_1 108 2 23 0   3     0   3   67 72                       139.0 108 2 23 0   3     0   3   67 72                 139
2048211 2048211 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 John F Kennedy Elementary   Regular School No Elementary KG 02 2019   grade_1 67 0 10 0   0     0   6   44 39                       83.0 67 0 10 0   0     0   6   44 39                 83
2048813 2048813 MA Essex   school 2509450 745   Pentucket 250945000414 7450020 Dr Frederick N Sweetsir   Regular School No Elementary PK 02 2019   grade_1 52 0 7 0   0     0   0   29 30                       59.0 52 0 7 0   0     0   0   29 30                 59
2048939 2048939 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Woodland School   Regular School No Elementary PK 02 2019   grade_1 77 1 6 1   3     0   1   53 36                       89.0 77 1 6 1   3     0   1   53 36                 89
2049033 2049033 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Naquag Elementary School   Regular School No Elementary KG 02 2019   grade_1 89 1 7 0   2     0   2   46 55                       101.0 89 1 7 0   2     0   2   46 55                 101
2040103 2040103 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 West Barnstable Elementary   Regular School No Elementary KG 03 2019   grade_1 51 3 6 0   0     0   7   39 28                       67.0 51 3 6 0   0     0   7   39 28                 67
2040107 2040107 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Centerville Elementary   Regular School No Elementary KG 03 2019   grade_1 45 4 7 0   1     0   6   34 29                       63.0 45 4 7 0   1     0   6   34 29                 63
2040111 2040111 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Hyannis West Elementary   Regular School No Elementary KG 03 2019   grade_1 32 9 21 0   2     0   13   35 42                       77.0 32 9 21 0   2     0   13   35 42                 77
2040115 2040115 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 West Villages Elementary School   Regular School No Elementary KG 03 2019   grade_1 88 2 12 0   0     0   10   57 55                       112.0 88 2 12 0   0     0   10   57 55                 112
2040147 2040147 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Swift River Elementary   Regular School No Elementary 01 03 2019   grade_1 144 0 12 0   3     0   6   79 86                       165.0 144 0 12 0   3     0   6   79 86                 165
2040159 2040159 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2019   grade_1 67 2 6 0   2     2   2   39 42                       81.0 67 2 6 0   2     2   2   39 42                 81
2040163 2040163 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Stall Brook   Regular School No Elementary KG 03 2019   grade_1 71 1 4 0   1     2   3   46 36                       82.0 71 1 4 0   1     2   3   46 36                 82
2040311 2040311 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Lee Academy   Regular School No Elementary PK 03 2019   grade_1 2 16 12 0   3     0   1   15 19                       34.0 2 16 12 0   3     0   1   15 19                 34
2040331 2040331 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2019   grade_1 1 21 12 1   1     0   0   19 17                       36.0 1 21 12 1   1     0   0   19 17                 36
2040362 2040362 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2019   grade_1 0 26 16 0   1     0   0   18 25                       43.0 0 26 16 0   1     0   0   18 25                 43
2042934 2042934 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 H.B. Lawrence School   Regular School No Elementary KG 03 2019   grade_1 9 1 37 0   1     0   2   26 24                       50.0 9 1 37 0   1     0   2   26 24                 50
2043298 2043298 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Hanscom Primary   Regular School No Elementary PK 03 2019   grade_1 39 3 16 0   0     0   12   37 33                       70.0 39 3 16 0   0     0   12   37 33                 70
2043768 2043768 MA Essex   school 2507260 168   Marblehead 250726001123 1680005 Malcolm L Bell   Regular School No Elementary KG 03 2019   grade_1 48 1 3 0   1     0   2   29 26                       55.0 48 1 3 0   1     0   2   29 26                 55
2043771 2043771 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 L H Coffin   Regular School No Elementary 01 03 2019   grade_1 52 0 6 0   0     0   3   31 30                       61.0 52 0 6 0   0     0   3   31 30                 61
2043779 2043779 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Glover   Regular School No Elementary PK 03 2019   grade_1 80 3 2 0   0     0   2   39 48                       87.0 80 3 2 0   0     0   2   39 48                 87
2043878 2043878 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Center   Regular School No Elementary PK 03 2019   grade_1 51 0 4 0   2     0   3   26 34                       60.0 51 0 4 0   2     0   3   26 34                 60
2043886 2043886 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Green Meadow   Regular School No Elementary PK 03 2019   grade_1 90 1 15 0   2     0   7   60 55                       115.0 90 1 15 0   2     0   7   60 55                 115
2044102 2044102 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Elmwood Street   Regular School No Elementary PK 03 2019   grade_1 109 3 10 0   2     0   6   59 71                       130.0 109 3 10 0   2     0   6   59 71                 130

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]);