enrollments

Data source: Big Local News · About: Big Local

970 rows where grade = "grade_2", state = "MA" and year = 2021 sorted by ccd_school_high_grade

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 970 ✖

grade ✖

  • grade_2 · 970 ✖
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
1672013 1672013 MA Plymouth   school 2501650 1   Abington 250165000434 10020 Abington - Beaver Brook Elementary   Regular School No Elementary KG 02 2021   grade_2 128 8 13 4   5     0   3   85 76 *                     161.0 128 8 13 4   5     0   3   85 76                 161
1672206 1672206 MA Middlesex   school 2502100 14   Ashland 250210000072 140010 Ashland - Henry E Warren Elementary   Regular School No Elementary KG 02 2021   grade_2 121 7 28 1   37     0   8   112 90 *                     202.0 121 7 28 1   37     0   8   112 90                 202
1672265 1672265 MA Worcester   school 2502220 17   Auburn 250222000101 170010 Auburn - Bryn Mawr   Regular School No Elementary KG 02 2021   grade_2 65 0 9 0   6     0   3   49 34 *                     83.0 65 0 9 0   6     0   3   49 34                 83
1672268 1672268 MA Worcester   school 2502220 17   Auburn 250222000103 170025 Auburn - Pakachoag School   Regular School No Elementary PK 02 2021   grade_2 85 3 11 0   3     0   2   58 46 *                     104.0 85 3 11 0   3     0   2   58 46                 104
1672329 1672329 MA Middlesex   school 2502400 23   Bedford 250240000131 230010 Bedford - Lt Elezer Davis   Regular School No Elementary PK 02 2021   grade_2 109 12 10 0   54     0   16   115 86 *                     201.0 109 12 10 0   54     0   16   115 86                 201
1672547 1672547 MA Suffolk   school 2502790 35   Boston 250279002806 350015 Boston - Higginson   Regular School No Elementary PK 02 2021   grade_2 0 18 21 0   0     0   0   22 17 *                     39.0 0 18 21 0   0     0   0   22 17                 39
1672567 1672567 MA Suffolk   school 2502790 35   Boston 250279000198 350021 Boston - Beethoven   Regular School No Elementary PK 02 2021   grade_2 32 24 24 0   4     0   4   38 50 *                     88.0 32 24 24 0   4     0   4   38 50                 88
1673296 1673296 MA Barnstable   school 2502820 36   Bourne 250282002664 360005 Bourne - Bournedale Elementary School   Regular School No Elementary PK 02 2021   grade_2 91 1 4 1   3     0   3   45 58 *                     103.0 91 1 4 1   3     0   3   45 58                 103
1673311 1673311 MA Essex   school 2502880 38   Boxford 250288000357 380005 Boxford - Harry Lee Cole   Regular School No Elementary PK 02 2021   grade_2 67 0 5 0   0     0   8   42 38 *                     80.0 67 0 5 0   0     0   8   42 38                 80
1673363 1673363 MA Barnstable   school 2502970 41   Brewster 250297000374 410005 Brewster - Stony Brook Elementary   Regular School No Elementary PK 02 2021   grade_2 51 1 8 0   0     0   2   23 39 *                     62.0 51 1 8 0   0     0   2   23 39                 62
1673850 1673850 MA Hampden   school 2503660 61   Chicopee 250366000490 610010 Chicopee - Belcher   Regular School No Elementary KG 02 2021   grade_2 31 8 22 0   1     0   1   33 30 *                     63.0 31 8 22 0   1     0   1   33 30                 63
1673940 1673940 MA Norfolk   school 2503780 65   Cohasset 250378000520 650010 Cohasset - Joseph Osgood   Regular School No Elementary PK 02 2021   grade_2 97 4 1 0   1     0   0   47 56 *                     103.0 97 4 1 0   1     0   0   47 56                 103
1674145 1674145 MA Plymouth   school 2504410 82   Duxbury 250441000593 820006 Duxbury - Chandler Elementary   Regular School No Elementary PK 02 2021   grade_2 166 1 3 0   1     0   4   94 81 *                     175.0 166 1 3 0   1     0   4   94 81                 175
1674156 1674156 MA Plymouth   school 2504440 83   East Bridgewater 250444000596 830005 East Bridgewater - Central   Regular School No Elementary PK 02 2021   grade_2 121 8 4 0   1     0   5   64 75 *                     139.0 121 8 4 0   1     0   5   64 75                 139
1674205 1674205 MA Hampden   school 2504500 87   East Longmeadow 250450000605 870013 East Longmeadow - Meadow Brook   Regular School No Elementary PK 02 2021   grade_2 113 8 19 0   7     0   6   72 81 *                     153.0 113 8 19 0   7     0   6   72 81                 153
1674218 1674218 MA Bristol   school 2504620 88   Easton 250462000980 880003 Easton - Center School   Regular School No Elementary PK 02 2021   grade_2 46 8 3 0   4     0   2   26 37 *                     63.0 46 8 3 0   4     0   2   26 37                 63
1674222 1674222 MA Bristol   school 2504620 88   Easton 250462000624 880015 Easton - Parkview Elementary   Regular School No Elementary PK 02 2021   grade_2 77 5 5 0   1     0   4   47 45 *                     92.0 77 5 5 0   1     0   4   47 45                 92
1674226 1674226 MA Bristol   school 2504620 88   Easton 250462002381 880020 Easton - Moreau Hall   Regular School No Elementary PK 02 2021   grade_2 54 4 4 1   5     1   4   35 38 *                     73.0 54 4 4 1   5     1   4   35 38                 73
1674944 1674944 MA Essex   school 2505970 128   Haverhill 250597000867 1280080 Haverhill - Walnut Square   Regular School No Elementary KG 02 2021   grade_2 29 2 11 0   0     0   1   21 22 *                     43.0 29 2 11 0   0     0   1   21 22                 43
1675026 1675026 MA Middlesex   school 2506240 136   Holliston 250624001172 1360010 Holliston - Placentino Elementary   Regular School No Elementary PK 02 2021   grade_2 141 3 9 0   12     1   3   96 72 *                     169.0 141 3 9 0   12     1   3   96 72                 169
1675200 1675200 MA Plymouth   school 2506540 145   Kingston 250654000943 1450005 Kingston - Kingston Elementary   Regular School No Elementary KG 02 2021   grade_2 144 0 2 0   0     0   4   75 75 *                     150.0 144 0 2 0   0     0   4   75 75                 150
1675240 1675240 MA Essex   school 2506660 149   Lawrence 250666000958 1490020 Lawrence - James F Hennessey   Regular School No Elementary PK 02 2021   grade_2 7 2 68 0   1     0   0   39 38 *                     78.0 7 2 68 0   1     0   0   39 38                 78
1675480 1675480 MA Middlesex   school 2506960 158   Littleton 250696001014 1580005 Littleton - Shaker Lane Elementary   Regular School No Elementary PK 02 2021   grade_2 89 1 1 0   16     0   2   62 47 *                     109.0 89 1 1 0   16     0   2   62 47                 109
1675686 1675686 MA Worcester   school 2507080 162   Lunenburg 250708001957 1620010 Lunenburg - Lunenburg Primary School   Regular School No Elementary PK 02 2021   grade_2 120 7 10 0   0     1   3   73 68 *                     141.0 120 7 10 0   0     1   3   73 68                 141
1675930 1675930 MA Bristol   school 2507230 167   Mansfield 250723001111 1670007 Mansfield - Everett W Robinson   Regular School No Elementary KG 02 2021   grade_2 172 9 16 0   12     0   14   115 108 *                     223.0 172 9 16 0   12     0   14   115 108                 223
1675943 1675943 MA Essex   school 2507260 168   Marblehead 250726001122 1680010 Marblehead - L H Coffin   Regular School No Elementary 01 02 2021   grade_2 87 3 6 0   3     0   4   53 50 *                     103.0 87 3 6 0   3     0   4   53 50                 103
1676044 1676044 MA Barnstable   school 2507440 172   Mashpee 250744002528 1720005 Mashpee - Kenneth Coombs School   Regular School No Elementary PK 02 2021   grade_2 56 4 12 4   1     0   14   49 42 *                     91.0 56 4 12 4   1     0   14   49 42                 91
1676253 1676253 MA Essex   school 2507830 184   Middleton 250783002588 1840003 Middleton - Fuller Meadow   Regular School No Elementary KG 02 2021   grade_2 80 1 8 1   5     0   6   51 50 *                     101.0 80 1 8 1   5     0   6   51 50                 101
1676261 1676261 MA Worcester   school 2507860 185   Milford 250786001238 1850010 Milford - Memorial   Regular School No Elementary KG 02 2021   grade_2 72 4 61 2   1     0   2   76 66 *                     142.0 72 4 61 2   1     0   2   76 66                 142
1676264 1676264 MA Worcester   school 2507860 185   Milford 250786001237 1850065 Milford - Brookside   Regular School No Elementary KG 02 2021   grade_2 88 8 45 0   3     0   2   76 70 *                     146.0 88 8 45 0   3     0   2   76 70                 146
1676365 1676365 MA Nantucket   school 2508250 197   Nantucket 250825001278 1970005 Nantucket - Nantucket Elementary   Regular School No Elementary PK 02 2021   grade_2 55 8 42 0   4     0   5   54 60 *                     114.0 55 8 42 0   4     0   5   54 60                 114
1676738 1676738 MA Norfolk   school 2508640 208   Norfolk 250864000317 2080015 Norfolk - H Olive Day   Regular School No Elementary PK 02 2021   grade_2 118 2 6 0   3     0   4   65 68 *                     133.0 118 2 6 0   3     0   4   65 68                 133
1677049 1677049 MA Franklin   school 2509180 223   Orange 250918002593 2230015 Orange - Fisher Hill   Regular School No Elementary PK 02 2021   grade_2 62 1 4 1   0     0   3   33 38 *                     71.0 62 1 4 1   0     0   3   33 38                 71
1677693 1677693 MA Barnstable   school 2510470 261   Sandwich 251047002857 2610002 Sandwich - Forestdale School   Regular School No Elementary PK 02 2021   grade_2 167 5 6 0   7     0   0   90 95 *                     185.0 167 5 6 0   7     0   0   90 95                 185
1678454 1678454 MA Worcester   school 2511400 290   Sutton 251140001661 2900003 Sutton - Sutton Early Learning   Regular School No Elementary PK 02 2021   grade_2 95 2 4 0   1     0   3   62 43 *                     105.0 95 2 4 0   1     0   3   62 43                 105
1678494 1678494 MA Bristol   school 2511460 292   Swansea 251146001892 2920015 Swansea - Gardner   Regular School No Elementary KG 02 2021   grade_2 75 0 5 0   1     0   2   42 41 *                     83.0 75 0 5 0   1     0   2   42 41                 83
1678498 1678498 MA Bristol   school 2511460 292   Swansea 251146000129 2920017 Swansea - Mark G Hoyle Elementary   Regular School No Elementary PK 02 2021   grade_2 50 2 2 0   2     0   3   26 33 *                     59.0 50 2 2 0   2     0   3   26 33                 59
1678562 1678562 MA Middlesex   school 2511580 295   Tewksbury 251158001922 2950001 Tewksbury - L F Dewing   Regular School No Elementary PK 02 2021   grade_2 112 8 12 0   8     0   1   75 66 *                     141.0 112 8 12 0   8     0   1   75 66                 141
1678565 1678565 MA Middlesex   school 2511580 295   Tewksbury 251158001921 2950010 Tewksbury - Heath-Brook   Regular School No Elementary KG 02 2021   grade_2 86 6 8 0   3     0   2   49 56 *                     105.0 86 6 8 0   3     0   2   49 56                 105
1678780 1678780 MA Plymouth   school 2512060 310   Wareham 251206001988 3100003 Wareham - John William Decas   Regular School No Elementary PK 02 2021   grade_2 91 10 15 2   2     0   21   73 68 *                     141.0 91 10 15 2   2     0   21   73 68                 141
1679024 1679024 MA Middlesex   school 2512660 326   Westford 251266002078 3260015 Westford - Nabnasset   Regular School No Elementary KG 02 2021   grade_2 89 0 1 0   16     0   1   46 61 *                     107.0 89 0 1 0   16     0   1   46 61                 107
1679028 1679028 MA Middlesex   school 2512660 326   Westford 251266002077 3260025 Westford - Col John Robinson   Regular School No Elementary KG 02 2021   grade_2 56 2 1 0   34     0   7   54 46 *                     100.0 56 2 1 0   34     0   7   54 46                 100
1679035 1679035 MA Middlesex   school 2512660 326   Westford 251266001740 3260055 Westford - Rita E. Miller Elementary School   Regular School No Elementary PK 02 2021   grade_2 57 4 5 0   31     0   3   58 42 *                     100.0 57 4 5 0   31     0   3   58 42                 100
1679077 1679077 MA Bristol   school 2512780 331   Westport 251278002090 3310015 Westport - Alice A Macomber   Regular School No Elementary PK 02 2021   grade_2 97 1 6 0   0     0   3   47 60 *                     107.0 97 1 6 0   0     0   3   47 60                 107
1679260 1679260 MA Worcester   school 2513080 343   Winchendon 251308002161 3430040 Winchendon - Memorial   Regular School No Elementary KG 02 2021   grade_2 82 1 2 0   3     0   2   46 44 *                     90.0 82 1 2 0   3     0   2   46 44                 90
1679317 1679317 MA Suffolk   school 2513170 346   Winthrop 251317001665 3460015 Winthrop - William P. Gorman/Fort Banks Elementary   Regular School No Elementary PK 02 2021   grade_2 124 2 22 0   0     0   1   59 90 *                     149.0 124 2 22 0   0     0   1   59 90                 149
1680415 1680415 MA Worcester   school 2502715 622   Blackstone-Millville 250271502372 6220008 Blackstone-Millville - John F Kennedy Elementary   Regular School No Elementary KG 02 2021   grade_2 76 3 9 0   0     0   3   43 48 *                     91.0 76 3 9 0   0     0   3   43 48                 91
1681011 1681011 MA Essex   school 2509450 745   Pentucket 250945000414 7450020 Pentucket - Dr Frederick N Sweetsir   Regular School No Elementary PK 02 2021   grade_2 54 0 6 0   0     0   4   36 28 *                     64.0 54 0 6 0   0     0   4   36 28                 64
1681116 1681116 MA Hampden   school 2500013 766   Southwick-Tolland-Granville Regional School District 250001301783 7660010 Southwick-Tolland-Granville Regional School District - Woodland School   Regular School No Elementary PK 02 2021   grade_2 88 2 9 0   0     0   3   48 54 *                     102.0 88 2 9 0   0     0   3   48 54                 102
1681208 1681208 MA Worcester   school 2511880 775   Wachusett 251188002693 7750005 Wachusett - Naquag Elementary School   Regular School No Elementary KG 02 2021   grade_2 93 1 4 0   2     0   2   52 50 *                     102.0 93 1 4 0   2     0   2   52 50                 102
1672298 1672298 MA Barnstable   school 2502310 20   Barnstable 250231000125 200005 Barnstable - West Barnstable Elementary   Regular School No Elementary KG 03 2021   grade_2 35 1 4 0   2     0   8   22 28 *                     50.0 35 1 4 0   2     0   8   22 28                 50
1672302 1672302 MA Barnstable   school 2502310 20   Barnstable 250231000118 200010 Barnstable - Centerville Elementary   Regular School No Elementary KG 03 2021   grade_2 43 5 12 0   0     0   4   38 26 *                     64.0 43 5 12 0   0     0   4   38 26                 64
1672306 1672306 MA Barnstable   school 2502310 20   Barnstable 250231002908 200012 Barnstable - Barnstable Community Innovation School   Regular School No Elementary KG 03 2021   grade_2 36 7 24 0   5     0   6   38 39 *                     78.0 36 7 24 0   5     0   6   38 39                 78
1672310 1672310 MA Barnstable   school 2502310 20   Barnstable 250231000121 200025 Barnstable - Hyannis West Elementary   Regular School No Elementary KG 03 2021   grade_2 16 10 38 1   1     0   5   35 36 *                     71.0 16 10 38 1   1     0   5   35 36                 71
1672314 1672314 MA Barnstable   school 2502310 20   Barnstable 250231002679 200045 Barnstable - West Villages Elementary School   Regular School No Elementary KG 03 2021   grade_2 77 1 8 0   3     0   7   51 45 *                     96.0 77 1 8 0   3     0   7   51 45                 96
1672346 1672346 MA Hampshire   school 2502430 24   Belchertown 250243000836 240018 Belchertown - Swift River Elementary   Regular School No Elementary 01 03 2021   grade_2 120 2 11 0   2     0   11   68 78 *                     146.0 120 2 11 0   2     0   11   68 78                 146
1672357 1672357 MA Norfolk   school 2502460 25   Bellingham 250246000142 250020 Bellingham - Joseph F DiPietro Elementary School   Regular School No Elementary KG 03 2021   grade_2 71 3 5 0   3     0   3   42 43 *                     85.0 71 3 5 0   3     0   3   42 43                 85
1672361 1672361 MA Norfolk   school 2502460 25   Bellingham 250246000141 250025 Bellingham - Stall Brook   Regular School No Elementary KG 03 2021   grade_2 45 1 5 0   0     1   2   22 32 *                     54.0 45 1 5 0   0     1   2   22 32                 54
1672491 1672491 MA Suffolk   school 2502790 35   Boston 250279001768 350001 Boston - Lee Academy   Regular School No Elementary PK 03 2021   grade_2 1 19 7 0   1     0   4   15 17 *                     32.0 1 19 7 0   1     0   4   15 17                 32
1672511 1672511 MA Suffolk   school 2502790 35   Boston 250279001115 350008 Boston - Dr. Catherine Ellison-Rosa Parks Early Ed School   Regular School No Elementary PK 03 2021   grade_2 0 17 15 0   0     0   1   20 13 *                     33.0 0 17 15 0   0     0   1   20 13                 33
1672542 1672542 MA Suffolk   school 2502790 35   Boston 250279002839 350014 Boston - Pauline Agassiz Shaw Elementary School   Regular School No Elementary PK 03 2021   grade_2 1 25 7 1   0     0   1   13 22 *                     35.0 1 25 7 1   0     0   1   13 22                 35
1674940 1674940 MA Essex   school 2505970 128   Haverhill 250597000866 1280075 Haverhill - Tilton   Regular School No Elementary KG 03 2021   grade_2 44 5 64 0   0     0   3   62 54 *                     116.0 44 5 64 0   0     0   3   62 54                 116
1675098 1675098 MA Hampden   school 2506270 137   Holyoke 250627002795 1370070 Holyoke - H.B. Lawrence School   Regular School No Elementary KG 03 2021   grade_2 2 3 39 0   0     0   1   26 19 *                     45.0 2 3 39 0   0     0   1   26 19                 45
1675127 1675127 MA Middlesex   school 2506330 139   Hopkinton 250633000919 1390010 Hopkinton - Elmwood   Regular School No Elementary 02 03 2021   grade_2 183 0 17 1   87     0   20   155 153 *                     308.0 183 0 17 1   87     0   20   155 153                 308
1675460 1675460 MA Middlesex   school 2506900 157   Lincoln 250690001009 1570006 Lincoln - Hanscom Primary   Regular School No Elementary PK 03 2021   grade_2 36 3 15 0   3     0   9   25 41 *                     66.0 36 3 15 0   3     0   9   25 41                 66
1675672 1675672 MA Hampden   school 2507050 161   Ludlow 250705002665 1610020 Ludlow - Chapin Street Elementary School   Regular School No Elementary 02 03 2021   grade_2 118 4 23 0   2     0   4   71 80 *                     151.0 118 4 23 0   2     0   4   71 80                 151
1675951 1675951 MA Essex   school 2507260 168   Marblehead 250726001121 1680020 Marblehead - Glover   Regular School No Elementary PK 03 2021   grade_2 64 4 3 0   1     0   5   44 33 *                     77.0 64 4 3 0   1     0   5   44 33                 77
1676058 1676058 MA Plymouth   school 2507470 173   Mattapoisett 250747001148 1730005 Mattapoisett - Center   Regular School No Elementary PK 03 2021   grade_2 54 0 5 0   0     0   4   37 26 *                     63.0 54 0 5 0   0     0   4   37 26                 63
1676066 1676066 MA Middlesex   school 2507500 174   Maynard 250750001152 1740010 Maynard - Green Meadow   Regular School No Elementary PK 03 2021   grade_2 70 3 13 0   0     0   1   48 39 *                     87.0 70 3 13 0   0     0   1   48 39                 87
1676083 1676083 MA Norfolk   school 2507530 175   Medfield 250753001159 1750007 Medfield - Ralph Wheelock School   Regular School No Elementary 02 03 2021   grade_2 170 1 4 1   11     0   5   102 90 *                     192.0 170 1 4 1   11     0   5   102 90                 192
1676280 1676280 MA Worcester   school 2507890 186   Millbury 250789001248 1860017 Millbury - Elmwood Street   Regular School No Elementary PK 03 2021   grade_2 93 8 4 0   5     0   8   58 60 *                     118.0 93 8 4 0   5     0   8   58 60                 118
1676607 1676607 MA Essex   school 2508580 204   Newburyport 250858001350 2040005 Newburyport - Francis T Bresnahan Elementary   Regular School No Elementary PK 03 2021   grade_2 126 0 6 0   2     0   3   59 78 *                     137.0 126 0 6 0   2     0   3   59 78                 137
1676958 1676958 MA Bristol   school 2509000 218   Norton 250900001450 2180010 Norton - L G Nourse Elementary   Regular School No Elementary KG 03 2021   grade_2 51 4 6 0   1     0   1   31 32 *                     63.0 51 4 6 0   1     0   1   31 32                 63
1676963 1676963 MA Bristol   school 2509000 218   Norton 250900001449 2180015 Norton - J C Solmonese   Regular School No Elementary PK 03 2021   grade_2 73 2 4 0   1     0   6   38 48 *                     86.0 73 2 4 0   1     0   6   38 48                 86
1677266 1677266 MA Norfolk   school 2509690 238   Plainville 250969001537 2380010 Plainville - Anna Ware Jackson   Regular School No Elementary PK 03 2021   grade_2 65 4 9 0   2     0   2   42 40 *                     82.0 65 4 9 0   2     0   2   42 40                 82
1677982 1677982 MA Worcester   school 2510980 276   Southborough 251098001827 2760050 Southborough - Albert S. Woodward Memorial School   Regular School No Elementary 02 03 2021   grade_2 93 1 4 0   14     0   8   59 61 *                     120.0 93 1 4 0   14     0   8   59 61                 120
1678595 1678595 MA Essex   school 2511670 298   Topsfield 251167001929 2980010 Topsfield - Steward Elementary   Regular School No Elementary PK 03 2021   grade_2 67 0 2 1   0     0   2   36 36 *                     72.0 67 0 2 1   0     0   2   36 36                 72
1678621 1678621 MA Worcester   school 2511850 304   Uxbridge 251185001936 3040005 Uxbridge - Taft Early Learning Center   Regular School No Elementary PK 03 2021   grade_2 98 0 5 0   2     1   2   60 48 *                     108.0 98 0 5 0   2     1   2   60 48                 108
1678765 1678765 MA Hampshire   school 2512030 309   Ware 251203001982 3090020 Ware - Stanley M Koziol Elementary School   Regular School No Elementary PK 03 2021   grade_2 81 1 3 0   0     0   0   43 42 *                     85.0 81 1 3 0   0     0   0   43 42                 85
1678922 1678922 MA Worcester   school 2512600 321   Westborough 251260002056 3210005 Westborough - J Harding Armstrong   Regular School No Elementary KG 03 2021   grade_2 42 1 11 0   26     0   0   40 40 *                     80.0 42 1 11 0   26     0   0   40 40                 80
1678926 1678926 MA Worcester   school 2512600 321   Westborough 251260002055 3210010 Westborough - Annie E Fales   Regular School No Elementary KG 03 2021   grade_2 47 1 2 0   48     1   0   49 50 *                     99.0 47 1 2 0   48     1   0   49 50                 99
1678931 1678931 MA Worcester   school 2512600 321   Westborough 251260002058 3210025 Westborough - Elsie A Hastings Elementary   Regular School No Elementary PK 03 2021   grade_2 35 3 14 0   41     0   2   49 46 *                     95.0 35 3 14 0   41     0   2   49 46                 95
1678958 1678958 MA Plymouth   school 2512420 323   West Bridgewater 251242002037 3230003 West Bridgewater - Rose L Macdonald   Regular School No Elementary 01 03 2021   grade_2 94 6 8 0   0     0   4   56 56 *                     112.0 94 6 8 0   0     0   4   56 56                 112
1679058 1679058 MA Middlesex   school 2512750 330   Weston 251275002085 3300010 Weston - Country   Regular School No Elementary PK 03 2021   grade_2 58 8 3 0   13     0   8   43 47 *                     90.0 58 8 3 0   13     0   8   43 47                 90
1679065 1679065 MA Middlesex   school 2512750 330   Weston 251275002089 3300015 Weston - Woodland   Regular School No Elementary PK 03 2021   grade_2 34 4 3 0   6     0   0   25 22 *                     47.0 34 4 3 0   6     0   0   25 22                 47
1679241 1679241 MA Middlesex   school 2513050 342   Wilmington 251305002159 3420020 Wilmington - Woburn Street   Regular School No Elementary 01 03 2021   grade_2 88 1 5 0   7     0   6   62 45 *                     107.0 88 1 5 0   7     0   6   62 45                 107
1679244 1679244 MA Middlesex   school 2513050 342   Wilmington 251305002153 3420025 Wilmington - Shawsheen Elementary   Regular School No Elementary 01 03 2021   grade_2 89 1 2 0   7     1   5   59 46 *                     105.0 89 1 2 0   7     1   5   59 46                 105
1679691 1679691 MA Norfolk   school 2513290 350   Wrentham 251329002255 3500003 Wrentham - Delaney   Regular School No Elementary PK 03 2021   grade_2 90 0 6 0   4     0   3   52 51 *                     103.0 90 0 6 0   4     0   3   52 51                 103
1680297 1680297 MA Berkshire   school 2501780 603   Adams-Cheshire 250178000023 6030020 Hoosac Valley Regional - Hoosac Valley Elementary School   Regular School No Elementary PK 03 2021   grade_2 67 1 1 0   0     0   3   30 42 *                     72.0 67 1 1 0   0     0   3   30 42                 72
1680436 1680436 MA Bristol   school 2503030 625   Bridgewater-Raynham 250303002643 6250002 Bridgewater-Raynham - Mitchell Elementary School   Regular School No Elementary PK 03 2021   grade_2 197 17 18 0   5     1   13   133 118 *                     251.0 197 17 18 0   5     1   13   133 118                 251
1680503 1680503 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000559 6450005 Dennis-Yarmouth - Ezra H Baker Innovation School   Regular School No Elementary PK 03 2021   grade_2 45 5 11 1   0     0   6   33 35 *                     68.0 45 5 11 1   0     0   6   33 35                 68
1680508 1680508 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000561 6450015 Dennis-Yarmouth - Marguerite E Small Elementary   Regular School No Elementary PK 03 2021   grade_2 39 8 6 2   3     0   3   36 25 *                     61.0 39 8 6 2   3     0   3   36 25                 61
1680512 1680512 MA Barnstable   school 2504140 645   Dennis-Yarmouth 250414000834 6450025 Dennis-Yarmouth - Station Avenue Elementary   Regular School No Elementary KG 03 2021   grade_2 84 8 10 0   4     0   11   59 58 *                     117.0 84 8 10 0   4     0   11   59 58                 117
1680600 1680600 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002735 6650001 Freetown-Lakeville - Freetown Elementary School   Regular School No Elementary PK 03 2021   grade_2 83 2 4 0   1     0   3   55 38 *                     93.0 83 2 4 0   1     0   3   55 38                 93
1680604 1680604 MA Bristol   school 2505070 665   Freetown-Lakeville 250507002739 6650002 Freetown-Lakeville - Assawompset Elementary School   Regular School No Elementary KG 03 2021   grade_2 102 0 3 0   1     0   9   61 54 *                     115.0 102 0 3 0   1     0   9   61 54                 115
1680727 1680727 MA Hampden   school 2505730 680   Hampden-Wilbraham 250573001464 6800050 Hampden-Wilbraham - Stony Hill School   Regular School No Elementary 02 03 2021   grade_2 114 3 17 0   3     2   8   80 67 *                     147.0 114 3 17 0   3     2   8   80 67                 147
1672026 1672026 MA Bristol   school 2501740 3   Acushnet 250174000014 30025 Acushnet - Acushnet Elementary School   Regular School No Elementary PK 04 2021   grade_2 107 1 2 0   2     0   5   62 55 *                     117.0 107 1 2 0   2     0   5   62 55                 117
1672036 1672036 MA Hampden   school 2501800 5   Agawam 250180000028 50010 Agawam - Clifford M Granger   Regular School No Elementary KG 04 2021   grade_2 27 1 8 0   5     0   0   21 20 *                     41.0 27 1 8 0   5     0   0   21 20                 41
1672041 1672041 MA Hampden   school 2501800 5   Agawam 250180000027 50020 Agawam - Benjamin J Phelps   Regular School No Elementary KG 04 2021   grade_2 60 1 2 0   2     0   0   39 26 *                     65.0 60 1 2 0   2     0   0   39 26                 65
1672046 1672046 MA Hampden   school 2501800 5   Agawam 250180000032 50025 Agawam - Robinson Park   Regular School No Elementary KG 04 2021   grade_2 66 2 10 0   2     0   5   44 41 *                     85.0 66 2 10 0   2     0   5   44 41                 85

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