enrollments
Data source: Big Local News · About: Big Local
3,669 rows where grade = "pre_kindergarten" and state = "MA" sorted by black
This data as json, CSV (advanced)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
738851 | 738851 | MA | Essex | school | 2506480 | 144 | Ipswich | 250648000936 | 1440007 | Paul F Doyon Memorial | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 24 | 0 | 0 | 0 | 1 | 0 | 0 | 16 | 9 | 25 | 24 | 0 | 0 | 0 | 1 | 0 | 0 | 16 | 9 | 25 | |||||||||||||||||||||||||||||||||
738858 | 738858 | MA | Essex | school | 2506480 | 144 | Ipswich | 250648000939 | 1440015 | Winthrop | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 14 | 0 | 6 | 1 | 1 | 0 | 0 | 12 | 10 | 22 | 14 | 0 | 6 | 1 | 1 | 0 | 0 | 12 | 10 | 22 | |||||||||||||||||||||||||||||||||
738880 | 738880 | MA | Berkshire | school | 2506630 | 148 | Lanesborough | 250663000949 | 1480005 | Lanesborough Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 21 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 16 | 22 | 21 | 0 | 0 | 0 | 0 | 0 | 1 | 6 | 16 | 22 | |||||||||||||||||||||||||||||||||
738897 | 738897 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002777 | 1490009 | Community Day Arlington | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 24 | 16 | 40 | 0 | 0 | 40 | 0 | 0 | 0 | 0 | 24 | 16 | 40 | |||||||||||||||||||||||||||||||||
739027 | 739027 | MA | Berkshire | school | 2506690 | 150 | Lee | 250669000969 | 1500025 | Lee Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 15 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 7 | 18 | 15 | 0 | 2 | 0 | 0 | 0 | 1 | 11 | 7 | 18 | |||||||||||||||||||||||||||||||||
739044 | 739044 | MA | Worcester | school | 2506720 | 151 | Leicester | 250672000974 | 1510010 | Leicester Primary School | Regular School | No | 1 | PK | 02 | 2015 | pre_kindergarten | 65 | 0 | 2 | 1 | 1 | 0 | 0 | 44 | 25 | 69 | 65 | 0 | 2 | 1 | 1 | 0 | 0 | 44 | 25 | 69 | |||||||||||||||||||||||||||||||||
739113 | 739113 | MA | Franklin | school | 2506810 | 154 | Leverett | 250681000992 | 1540005 | Leverett Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 15 | 0 | 0 | 0 | 0 | 0 | 3 | 10 | 8 | 18 | 15 | 0 | 0 | 0 | 0 | 0 | 3 | 10 | 8 | 18 | |||||||||||||||||||||||||||||||||
739208 | 739208 | MA | Hampden | school | 2506990 | 159 | Longmeadow | 250699001017 | 1590010 | Center | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 34 | 0 | 5 | 0 | 4 | 0 | 4 | 27 | 20 | 47 | 34 | 0 | 5 | 0 | 4 | 0 | 4 | 27 | 20 | 47 | |||||||||||||||||||||||||||||||||
739231 | 739231 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702000067 | 1600002 | Dr Gertrude Bailey | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 10 | 0 | 3 | 0 | 15 | 0 | 0 | 16 | 12 | 28 | 10 | 0 | 3 | 0 | 15 | 0 | 0 | 16 | 12 | 28 | |||||||||||||||||||||||||||||||||
739366 | 739366 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705002663 | 1610010 | East Street Elementary School | Regular School | No | 1 | PK | 01 | 2015 | pre_kindergarten | 51 | 0 | 6 | 0 | 1 | 0 | 3 | 37 | 24 | 61 | 51 | 0 | 6 | 0 | 1 | 0 | 3 | 37 | 24 | 61 | |||||||||||||||||||||||||||||||||
739541 | 739541 | MA | Essex | school | 2507140 | 164 | Lynnfield | 250714002617 | 1640005 | Lynnfield Preschool | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 46 | 0 | 3 | 0 | 1 | 0 | 0 | 32 | 18 | 50 | 46 | 0 | 3 | 0 | 1 | 0 | 0 | 32 | 18 | 50 | |||||||||||||||||||||||||||||||||
739610 | 739610 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001004 | 1670003 | Roland Green School | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 77 | 0 | 5 | 0 | 8 | 0 | 2 | 59 | 33 | 92 | 77 | 0 | 5 | 0 | 8 | 0 | 2 | 59 | 33 | 92 | |||||||||||||||||||||||||||||||||
739650 | 739650 | MA | Plymouth | school | 2507290 | 169 | Marion | 250729001127 | 1690005 | Sippican | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 22 | 0 | 0 | 0 | 0 | 0 | 2 | 15 | 9 | 24 | 22 | 0 | 0 | 0 | 0 | 0 | 2 | 15 | 9 | 24 | |||||||||||||||||||||||||||||||||
739695 | 739695 | MA | Plymouth | school | 2507350 | 171 | Marshfield | 250735001137 | 1710015 | Daniel Webster | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 67 | 0 | 3 | 0 | 0 | 0 | 6 | 44 | 32 | 76 | 67 | 0 | 3 | 0 | 0 | 0 | 6 | 44 | 32 | 76 | |||||||||||||||||||||||||||||||||
739708 | 739708 | MA | Plymouth | school | 2507350 | 171 | Marshfield | 250735001139 | 1710025 | Martinson Elementary | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 28 | 0 | 5 | 0 | 0 | 0 | 20 | 31 | 22 | 53 | 28 | 0 | 5 | 0 | 0 | 0 | 20 | 31 | 22 | 53 | |||||||||||||||||||||||||||||||||
739744 | 739744 | MA | Middlesex | school | 2507500 | 174 | Maynard | 250750001152 | 1740010 | Green Meadow | Regular School | No | 1 | PK | 03 | 2015 | pre_kindergarten | 37 | 0 | 7 | 0 | 3 | 0 | 3 | 31 | 19 | 50 | 37 | 0 | 7 | 0 | 3 | 0 | 3 | 31 | 19 | 50 | |||||||||||||||||||||||||||||||||
739758 | 739758 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753000114 | 1750003 | Memorial School | Regular School | No | 1 | PK | 01 | 2015 | pre_kindergarten | 56 | 0 | 1 | 0 | 1 | 0 | 1 | 32 | 27 | 59 | 56 | 0 | 1 | 0 | 1 | 0 | 1 | 32 | 27 | 59 | |||||||||||||||||||||||||||||||||
739793 | 739793 | MA | Middlesex | school | 2507560 | 176 | Medford | 250756002062 | 1760150 | Milton Fuller Roberts | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 10 | 0 | 2 | 0 | 2 | 0 | 0 | 7 | 7 | 14 | 10 | 0 | 2 | 0 | 2 | 0 | 0 | 7 | 7 | 14 | |||||||||||||||||||||||||||||||||
739819 | 739819 | MA | Norfolk | school | 2507590 | 177 | Medway | 250759001185 | 1770013 | John D Mc Govern Elementary | Regular School | No | 1 | PK | 01 | 2015 | pre_kindergarten | 42 | 0 | 1 | 0 | 1 | 0 | 0 | 33 | 11 | 44 | 42 | 0 | 1 | 0 | 1 | 0 | 0 | 33 | 11 | 44 | |||||||||||||||||||||||||||||||||
739871 | 739871 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001211 | 1810030 | Marsh Grammar School | Regular School | No | 1 | PK | 08 | 2015 | pre_kindergarten | 24 | 0 | 11 | 0 | 0 | 0 | 1 | 20 | 16 | 36 | 24 | 0 | 11 | 0 | 0 | 0 | 1 | 20 | 16 | 36 | |||||||||||||||||||||||||||||||||
739881 | 739881 | MA | Essex | school | 2507740 | 181 | Methuen | 250774002558 | 1810050 | Comprehensive Grammar School | Regular School | No | 1 | PK | 08 | 2015 | pre_kindergarten | 13 | 0 | 6 | 0 | 1 | 0 | 1 | 12 | 9 | 21 | 13 | 0 | 6 | 0 | 1 | 0 | 1 | 12 | 9 | 21 | |||||||||||||||||||||||||||||||||
739891 | 739891 | MA | Essex | school | 2507740 | 181 | Methuen | 250774001556 | 1810055 | Tenney Grammar School | Regular School | No | 1 | PK | 08 | 2015 | pre_kindergarten | 16 | 0 | 10 | 0 | 2 | 0 | 1 | 13 | 16 | 29 | 16 | 0 | 10 | 0 | 2 | 0 | 1 | 13 | 16 | 29 | |||||||||||||||||||||||||||||||||
739938 | 739938 | MA | Essex | school | 2507830 | 184 | Middleton | 250783001236 | 1840005 | Howe-Manning | Regular School | No | 1 | 03 | 06 | 2015 | pre_kindergarten | 55 | 0 | 2 | 0 | 4 | 0 | 2 | 33 | 30 | 63 | 55 | 0 | 2 | 0 | 4 | 0 | 2 | 33 | 30 | 63 | |||||||||||||||||||||||||||||||||
739977 | 739977 | MA | Norfolk | school | 2507920 | 187 | Millis | 250792001252 | 1870005 | Clyde F Brown | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 69 | 0 | 0 | 0 | 0 | 0 | 2 | 30 | 41 | 71 | 69 | 0 | 0 | 0 | 0 | 0 | 2 | 30 | 41 | 71 | |||||||||||||||||||||||||||||||||
740025 | 740025 | MA | Hampden | school | 2508040 | 191 | Monson | 250804002589 | 1910025 | Quarry Hill Community School | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 40 | 0 | 1 | 0 | 0 | 0 | 0 | 18 | 23 | 41 | 40 | 0 | 1 | 0 | 0 | 0 | 0 | 18 | 23 | 41 | |||||||||||||||||||||||||||||||||
740153 | 740153 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001324 | 2010020 | Elwyn G Campbell | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 14 | 0 | 5 | 0 | 3 | 0 | 2 | 13 | 11 | 24 | 14 | 0 | 5 | 0 | 3 | 0 | 2 | 13 | 11 | 24 | |||||||||||||||||||||||||||||||||
740223 | 740223 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001331 | 2010115 | John Avery Parker | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 9 | 0 | 6 | 0 | 0 | 0 | 1 | 9 | 7 | 16 | 9 | 0 | 6 | 0 | 0 | 0 | 1 | 9 | 7 | 16 | |||||||||||||||||||||||||||||||||
740424 | 740424 | MA | Norfolk | school | 2508640 | 208 | Norfolk | 250864000317 | 2080015 | H Olive Day | Regular School | No | 1 | PK | 02 | 2015 | pre_kindergarten | 57 | 0 | 6 | 0 | 2 | 0 | 1 | 38 | 28 | 66 | 57 | 0 | 6 | 0 | 2 | 0 | 1 | 38 | 28 | 66 | |||||||||||||||||||||||||||||||||
740604 | 740604 | MA | Worcester | school | 2508940 | 214 | Northbridge | 250894002682 | 2140005 | Northbridge Elementary | Regular School | No | 1 | PK | 01 | 2015 | pre_kindergarten | 89 | 0 | 3 | 0 | 1 | 0 | 5 | 55 | 43 | 98 | 89 | 0 | 3 | 0 | 1 | 0 | 5 | 55 | 43 | 98 | |||||||||||||||||||||||||||||||||
740616 | 740616 | MA | Worcester | school | 2508760 | 215 | North Brookfield | 250876001410 | 2150015 | North Brookfield Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 19 | 0 | 1 | 0 | 0 | 0 | 1 | 14 | 7 | 21 | 19 | 0 | 1 | 0 | 0 | 0 | 1 | 14 | 7 | 21 | |||||||||||||||||||||||||||||||||
740681 | 740681 | MA | Plymouth | school | 2509030 | 219 | Norwell | 250903001458 | 2190020 | William G Vinal | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 18 | 0 | 0 | 0 | 1 | 0 | 0 | 11 | 8 | 19 | 18 | 0 | 0 | 0 | 1 | 0 | 0 | 11 | 8 | 19 | |||||||||||||||||||||||||||||||||
740730 | 740730 | MA | Dukes | school | 2504650 | 221 | Oak Bluffs | 250465000625 | 2210005 | Oak Bluffs Elementary | Regular School | No | 1 | PK | 08 | 2015 | pre_kindergarten | 7 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 6 | 8 | 7 | 0 | 0 | 0 | 0 | 0 | 1 | 2 | 6 | 8 | |||||||||||||||||||||||||||||||||
740753 | 740753 | MA | Worcester | school | 2509270 | 226 | Oxford | 250927001481 | 2260005 | Clara Barton | Regular School | No | 1 | 03 | 04 | 2015 | pre_kindergarten | 57 | 0 | 4 | 0 | 0 | 0 | 2 | 39 | 24 | 63 | 57 | 0 | 4 | 0 | 0 | 0 | 2 | 39 | 24 | 63 | |||||||||||||||||||||||||||||||||
740820 | 740820 | MA | Essex | school | 2509360 | 229 | Peabody | 250936001506 | 2290027 | William A Welch Sr | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 25 | 0 | 7 | 0 | 0 | 0 | 0 | 15 | 17 | 32 | 25 | 0 | 7 | 0 | 0 | 0 | 0 | 15 | 17 | 32 | |||||||||||||||||||||||||||||||||
740869 | 740869 | MA | Plymouth | school | 2509420 | 231 | Pembroke | 250942001510 | 2310015 | North Pembroke Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 57 | 0 | 0 | 1 | 0 | 0 | 1 | 35 | 24 | 59 | 57 | 0 | 0 | 1 | 0 | 0 | 1 | 35 | 24 | 59 | |||||||||||||||||||||||||||||||||
741002 | 741002 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972001547 | 2390046 | South Elementary | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 46 | 0 | 2 | 1 | 0 | 0 | 1 | 26 | 24 | 50 | 46 | 0 | 2 | 1 | 0 | 0 | 1 | 26 | 24 | 50 | |||||||||||||||||||||||||||||||||
741218 | 741218 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001962 | 2480013 | Beachmont Veterans Memorial School | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 21 | 0 | 8 | 0 | 1 | 0 | 1 | 22 | 9 | 31 | 21 | 0 | 8 | 0 | 1 | 0 | 1 | 22 | 9 | 31 | |||||||||||||||||||||||||||||||||
741269 | 741269 | MA | Berkshire | school | 2510080 | 249 | Richmond | 251008001635 | 2490005 | Richmond Consolidated | Regular School | No | 1 | PK | 08 | 2015 | pre_kindergarten | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 8 | 13 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 8 | 13 | |||||||||||||||||||||||||||||||||
741279 | 741279 | MA | Plymouth | school | 2510140 | 250 | Rochester | 251014001637 | 2500005 | Rochester Memorial | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 12 | 26 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 14 | 12 | 26 | |||||||||||||||||||||||||||||||||
741310 | 741310 | MA | Essex | school | 2510200 | 252 | Rockport | 251020002533 | 2520005 | Rockport Elementary | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 8 | 15 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 7 | 8 | 15 | |||||||||||||||||||||||||||||||||
741324 | 741324 | MA | Franklin | school | 2510230 | 253 | Rowe | 251023001649 | 2530005 | Rowe Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 12 | 0 | 1 | 0 | 0 | 0 | 1 | 8 | 6 | 14 | 12 | 0 | 1 | 0 | 0 | 0 | 1 | 8 | 6 | 14 | |||||||||||||||||||||||||||||||||
741390 | 741390 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047001672 | 2610005 | Henry T Wing | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 57 | 0 | 0 | 1 | 2 | 0 | 1 | 38 | 23 | 61 | 57 | 0 | 0 | 1 | 2 | 0 | 1 | 38 | 23 | 61 | |||||||||||||||||||||||||||||||||
741500 | 741500 | MA | Bristol | school | 2510590 | 265 | Seekonk | 251059001696 | 2650015 | Mildred Aitken School | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 16 | 0 | 1 | 0 | 2 | 0 | 1 | 10 | 10 | 20 | 16 | 0 | 1 | 0 | 2 | 0 | 1 | 10 | 10 | 20 | |||||||||||||||||||||||||||||||||
741531 | 741531 | MA | Norfolk | school | 2510620 | 266 | Sharon | 251062002560 | 2660305 | Sharon Middle | Regular School | No | 2 | 06 | 08 | 2015 | pre_kindergarten | 29 | 0 | 4 | 0 | 15 | 0 | 1 | 23 | 26 | 49 | 29 | 0 | 4 | 0 | 15 | 0 | 1 | 23 | 26 | 49 | |||||||||||||||||||||||||||||||||
741540 | 741540 | MA | Middlesex | school | 2510710 | 269 | Sherborn | 251071001709 | 2690010 | Pine Hill | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 20 | 0 | 1 | 0 | 1 | 0 | 0 | 12 | 10 | 22 | 20 | 0 | 1 | 0 | 1 | 0 | 0 | 12 | 10 | 22 | |||||||||||||||||||||||||||||||||
741578 | 741578 | MA | Franklin | school | 2510800 | 272 | Shutesbury | 251080001720 | 2720005 | Shutesbury Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 14 | 0 | 1 | 1 | 1 | 0 | 3 | 8 | 12 | 20 | 14 | 0 | 1 | 1 | 1 | 0 | 3 | 8 | 12 | 20 | |||||||||||||||||||||||||||||||||
741637 | 741637 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089001739 | 2740087 | Albert F. Argenziano School at Lincoln Park | Regular School | No | 1 | PK | 08 | 2015 | pre_kindergarten | 13 | 0 | 3 | 0 | 1 | 0 | 1 | 13 | 5 | 18 | 13 | 0 | 3 | 0 | 1 | 0 | 1 | 13 | 5 | 18 | |||||||||||||||||||||||||||||||||
741688 | 741688 | MA | Hampshire | school | 2510950 | 275 | Southampton | 251095001758 | 2750005 | William E Norris | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 38 | 0 | 3 | 0 | 3 | 0 | 1 | 26 | 19 | 45 | 38 | 0 | 3 | 0 | 3 | 0 | 1 | 26 | 19 | 45 | |||||||||||||||||||||||||||||||||
741696 | 741696 | MA | Worcester | school | 2510980 | 276 | Southborough | 251098001761 | 2760008 | Mary E Finn School | Regular School | No | 1 | PK | 01 | 2015 | pre_kindergarten | 24 | 0 | 4 | 0 | 8 | 0 | 4 | 26 | 14 | 40 | 24 | 0 | 4 | 0 | 8 | 0 | 4 | 26 | 14 | 40 | |||||||||||||||||||||||||||||||||
741725 | 741725 | MA | Hampshire | school | 2510920 | 278 | South Hadley | 251092001753 | 2780015 | Plains Elementary | Regular School | No | 1 | PK | 01 | 2015 | pre_kindergarten | 52 | 0 | 6 | 0 | 1 | 0 | 6 | 36 | 29 | 65 | 52 | 0 | 6 | 0 | 1 | 0 | 6 | 36 | 29 | 65 | |||||||||||||||||||||||||||||||||
742035 | 742035 | MA | Middlesex | school | 2511220 | 284 | Stoneham | 251122001851 | 2840005 | Colonial Park | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 42 | 0 | 2 | 0 | 3 | 0 | 2 | 29 | 20 | 49 | 42 | 0 | 2 | 0 | 3 | 0 | 2 | 29 | 20 | 49 | |||||||||||||||||||||||||||||||||
742101 | 742101 | MA | Worcester | school | 2511310 | 287 | Sturbridge | 251131001870 | 2870005 | Burgess Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 70 | 0 | 3 | 0 | 0 | 0 | 1 | 39 | 35 | 74 | 70 | 0 | 3 | 0 | 0 | 0 | 1 | 39 | 35 | 74 | |||||||||||||||||||||||||||||||||
742127 | 742127 | MA | Middlesex | school | 2511340 | 288 | Sudbury | 251134001877 | 2880030 | Peter Noyes | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 44 | 0 | 4 | 0 | 7 | 0 | 4 | 35 | 24 | 59 | 44 | 0 | 4 | 0 | 7 | 0 | 4 | 35 | 24 | 59 | |||||||||||||||||||||||||||||||||
742137 | 742137 | MA | Franklin | school | 2511370 | 289 | Sunderland | 251137001878 | 2890005 | Sunderland Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 10 | 0 | 3 | 0 | 4 | 0 | 1 | 8 | 10 | 18 | 10 | 0 | 3 | 0 | 4 | 0 | 1 | 8 | 10 | 18 | |||||||||||||||||||||||||||||||||
742145 | 742145 | MA | Worcester | school | 2511400 | 290 | Sutton | 251140001661 | 2900003 | Sutton Early Learning | Regular School | No | 1 | PK | 02 | 2015 | pre_kindergarten | 35 | 0 | 0 | 0 | 0 | 0 | 2 | 26 | 11 | 37 | 35 | 0 | 0 | 0 | 0 | 0 | 2 | 26 | 11 | 37 | |||||||||||||||||||||||||||||||||
742190 | 742190 | MA | Bristol | school | 2511460 | 292 | Swansea | 251146000129 | 2920017 | Mark G Hoyle Elementary | Regular School | No | 1 | PK | 02 | 2015 | pre_kindergarten | 57 | 0 | 1 | 0 | 0 | 0 | 1 | 29 | 30 | 59 | 57 | 0 | 1 | 0 | 0 | 0 | 1 | 29 | 30 | 59 | |||||||||||||||||||||||||||||||||
742292 | 742292 | MA | Essex | school | 2511670 | 298 | Topsfield | 251167001929 | 2980010 | Steward Elementary | Regular School | No | 1 | PK | 03 | 2015 | pre_kindergarten | 37 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 15 | 37 | 37 | 0 | 0 | 0 | 0 | 0 | 0 | 22 | 15 | 37 | |||||||||||||||||||||||||||||||||
742318 | 742318 | MA | Worcester | school | 2511850 | 304 | Uxbridge | 251185001936 | 3040005 | Taft Early Learning Center | Regular School | No | 1 | PK | 02 | 2015 | pre_kindergarten | 102 | 0 | 5 | 0 | 3 | 0 | 5 | 65 | 50 | 115 | 102 | 0 | 5 | 0 | 3 | 0 | 5 | 65 | 50 | 115 | |||||||||||||||||||||||||||||||||
742333 | 742333 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191002826 | 3050001 | Early Childhood Center at the Doyle School | Regular School | No | 1 | PK | KG | 2015 | pre_kindergarten | 75 | 0 | 9 | 0 | 8 | 1 | 5 | 61 | 37 | 98 | 75 | 0 | 9 | 0 | 8 | 1 | 5 | 61 | 37 | 98 | |||||||||||||||||||||||||||||||||
742363 | 742363 | MA | Hampden | school | 2511940 | 306 | Wales | 251194001956 | 3060005 | Wales Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 12 | 21 | 21 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 12 | 21 | |||||||||||||||||||||||||||||||||
742456 | 742456 | MA | Hampshire | school | 2512030 | 309 | Ware | 251203001982 | 3090020 | Stanley M Koziol Elementary School | Regular School | No | 1 | PK | 03 | 2015 | pre_kindergarten | 50 | 0 | 2 | 0 | 0 | 0 | 0 | 34 | 18 | 52 | 50 | 0 | 2 | 0 | 0 | 0 | 0 | 34 | 18 | 52 | |||||||||||||||||||||||||||||||||
742501 | 742501 | MA | Middlesex | school | 2512180 | 314 | Watertown | 251218002001 | 3140020 | Hosmer | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 34 | 0 | 7 | 0 | 7 | 0 | 1 | 34 | 15 | 49 | 34 | 0 | 7 | 0 | 7 | 0 | 1 | 34 | 15 | 49 | |||||||||||||||||||||||||||||||||
742546 | 742546 | MA | Worcester | school | 2512240 | 316 | Webster | 251224002018 | 3160015 | Park Avenue Elementary | Regular School | No | 1 | PK | 02 | 2015 | pre_kindergarten | 41 | 0 | 12 | 0 | 1 | 0 | 2 | 40 | 16 | 56 | 41 | 0 | 12 | 0 | 1 | 0 | 2 | 40 | 16 | 56 | |||||||||||||||||||||||||||||||||
742758 | 742758 | MA | Hampshire | school | 2512690 | 327 | Westhampton | 251269002083 | 3270005 | Westhampton Elementary School | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 15 | 0 | 2 | 0 | 0 | 0 | 1 | 10 | 8 | 18 | 15 | 0 | 2 | 0 | 0 | 0 | 1 | 10 | 8 | 18 | |||||||||||||||||||||||||||||||||
742766 | 742766 | MA | Middlesex | school | 2512750 | 330 | Weston | 251275002085 | 3300010 | Country | Regular School | No | 1 | PK | 03 | 2015 | pre_kindergarten | 14 | 0 | 2 | 0 | 6 | 0 | 1 | 14 | 9 | 23 | 14 | 0 | 2 | 0 | 6 | 0 | 1 | 14 | 9 | 23 | |||||||||||||||||||||||||||||||||
742773 | 742773 | MA | Middlesex | school | 2512750 | 330 | Weston | 251275002089 | 3300015 | Woodland | Regular School | No | 1 | PK | 03 | 2015 | pre_kindergarten | 14 | 0 | 1 | 0 | 7 | 0 | 0 | 12 | 10 | 22 | 14 | 0 | 1 | 0 | 7 | 0 | 0 | 12 | 10 | 22 | |||||||||||||||||||||||||||||||||
742786 | 742786 | MA | Bristol | school | 2512780 | 331 | Westport | 251278002090 | 3310015 | Alice A Macomber | Regular School | No | 1 | PK | 01 | 2015 | pre_kindergarten | 70 | 0 | 1 | 0 | 0 | 0 | 2 | 41 | 32 | 73 | 70 | 0 | 1 | 0 | 0 | 0 | 2 | 41 | 32 | 73 | |||||||||||||||||||||||||||||||||
742868 | 742868 | MA | Norfolk | school | 2512810 | 335 | Westwood | 251281002115 | 3350050 | Westwood Integrated Preschool | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 39 | 0 | 2 | 0 | 2 | 0 | 1 | 30 | 14 | 44 | 39 | 0 | 2 | 0 | 2 | 0 | 1 | 30 | 14 | 44 | |||||||||||||||||||||||||||||||||
742927 | 742927 | MA | Franklin | school | 2512870 | 337 | Whately | 251287002126 | 3370005 | Whately Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 4 | 10 | |||||||||||||||||||||||||||||||||
742935 | 742935 | MA | Hampshire | school | 2512990 | 340 | Williamsburg | 251299002767 | 3400020 | Williamsburg Schools | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 10 | 13 | 12 | 0 | 1 | 0 | 0 | 0 | 0 | 3 | 10 | 13 | |||||||||||||||||||||||||||||||||
742943 | 742943 | MA | Berkshire | school | 2513020 | 341 | Williamstown | 251302002146 | 3410010 | Williamstown Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 29 | 0 | 2 | 0 | 0 | 0 | 0 | 18 | 13 | 31 | 29 | 0 | 2 | 0 | 0 | 0 | 0 | 18 | 13 | 31 | |||||||||||||||||||||||||||||||||
742951 | 742951 | MA | Middlesex | school | 2513050 | 342 | Wilmington | 251305000802 | 3420005 | Boutwell | Regular School | No | 1 | PK | KG | 2015 | pre_kindergarten | 21 | 0 | 2 | 0 | 3 | 0 | 0 | 15 | 11 | 26 | 21 | 0 | 2 | 0 | 3 | 0 | 0 | 15 | 11 | 26 | |||||||||||||||||||||||||||||||||
743481 | 743481 | MA | Essex | school | 2500538 | 426 | Community Day Charter Public School - Gateway (District) | 250053802717 | 4260205 | Community Day Charter Public School - Gateway | Regular School | Yes | 1 | PK | 03 | 2015 | pre_kindergarten | 3 | 0 | 38 | 0 | 0 | 0 | 0 | 20 | 21 | 41 | 3 | 0 | 38 | 0 | 0 | 0 | 0 | 20 | 21 | 41 | |||||||||||||||||||||||||||||||||
743514 | 743514 | MA | Essex | school | 2500535 | 431 | Community Day Charter Public School - R. Kingman Webster (District) | 250053502719 | 4310205 | Community Day Charter Public School - R. Kingman Webster | Regular School | Yes | 1 | PK | 03 | 2015 | pre_kindergarten | 0 | 0 | 41 | 0 | 1 | 0 | 0 | 25 | 17 | 42 | 0 | 0 | 41 | 0 | 1 | 0 | 0 | 25 | 17 | 42 | |||||||||||||||||||||||||||||||||
743922 | 743922 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000356 | 6000005 | Blanchard Memorial School | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 11 | 0 | 1 | 0 | 8 | 0 | 1 | 15 | 6 | 21 | 11 | 0 | 1 | 0 | 8 | 0 | 1 | 15 | 6 | 21 | |||||||||||||||||||||||||||||||||
744005 | 744005 | MA | Worcester | school | 2502040 | 610 | Ashburnham-Westminster | 250204002368 | 6100025 | Briggs Elementary | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 55 | 0 | 4 | 0 | 0 | 0 | 0 | 32 | 27 | 59 | 55 | 0 | 4 | 0 | 0 | 0 | 0 | 32 | 27 | 59 | |||||||||||||||||||||||||||||||||
744020 | 744020 | MA | Worcester | school | 2502160 | 615 | Athol-Royalston | 250216000078 | 6150016 | Pleasant Street | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 45 | 0 | 3 | 0 | 1 | 0 | 0 | 26 | 23 | 49 | 45 | 0 | 3 | 0 | 1 | 0 | 0 | 26 | 23 | 49 | |||||||||||||||||||||||||||||||||
744047 | 744047 | MA | Middlesex | school | 2500542 | 616 | Ayer Shirley School District | 250054202731 | 6160001 | Lura A. White Elementary School | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 15 | 0 | 4 | 0 | 3 | 1 | 3 | 17 | 9 | 26 | 15 | 0 | 4 | 0 | 3 | 1 | 3 | 17 | 9 | 26 | |||||||||||||||||||||||||||||||||
744054 | 744054 | MA | Middlesex | school | 2500542 | 616 | Ayer Shirley School District | 250054202736 | 6160002 | Page Hilltop Elementary School | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 24 | 0 | 5 | 0 | 0 | 0 | 0 | 17 | 12 | 29 | 24 | 0 | 5 | 0 | 0 | 0 | 0 | 17 | 12 | 29 | |||||||||||||||||||||||||||||||||
744068 | 744068 | MA | Berkshire | school | 2502530 | 618 | Berkshire Hills | 250253001999 | 6180035 | Muddy Brook Regional Elementary School | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 11 | 0 | 3 | 0 | 1 | 0 | 1 | 8 | 8 | 16 | 11 | 0 | 3 | 0 | 1 | 0 | 1 | 8 | 8 | 16 | |||||||||||||||||||||||||||||||||
744135 | 744135 | MA | Hampshire | school | 2500014 | 632 | Chesterfield-Goshen | 250001401275 | 6320025 | New Hingham Regional Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | 13 | 0 | 0 | 0 | 0 | 0 | 0 | 8 | 5 | 13 | |||||||||||||||||||||||||||||||||
744143 | 744143 | MA | Berkshire | school | 2503390 | 635 | Central Berkshire | 250339000459 | 6350005 | Becket Washington School | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 10 | 23 | 23 | 0 | 0 | 0 | 0 | 0 | 0 | 13 | 10 | 23 | |||||||||||||||||||||||||||||||||
744150 | 744150 | MA | Berkshire | school | 2503390 | 635 | Central Berkshire | 250339002545 | 6350010 | Berkshire Trail Elementary | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 10 | 12 | 11 | 0 | 1 | 0 | 0 | 0 | 0 | 2 | 10 | 12 | |||||||||||||||||||||||||||||||||
744157 | 744157 | MA | Berkshire | school | 2503390 | 635 | Central Berkshire | 250339000462 | 6350025 | Craneville | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 12 | 0 | 1 | 0 | 0 | 0 | 1 | 8 | 6 | 14 | 12 | 0 | 1 | 0 | 0 | 0 | 1 | 8 | 6 | 14 | |||||||||||||||||||||||||||||||||
744223 | 744223 | MA | Bristol | school | 2504200 | 650 | Dighton-Rehoboth | 250420000568 | 6500505 | Dighton-Rehoboth Regional High School | Regular School | No | 3 | 09 | 12 | 2015 | pre_kindergarten | 53 | 0 | 0 | 0 | 0 | 0 | 3 | 34 | 22 | 56 | 53 | 0 | 0 | 0 | 0 | 0 | 3 | 34 | 22 | 56 | |||||||||||||||||||||||||||||||||
744268 | 744268 | MA | Berkshire | school | 2513321 | 662 | Farmington River Reg | 251332100402 | 6620020 | Farmington River Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 10 | 25 | 25 | 0 | 0 | 0 | 0 | 0 | 0 | 15 | 10 | 25 | |||||||||||||||||||||||||||||||||
744276 | 744276 | MA | Bristol | school | 2505070 | 665 | Freetown-Lakeville | 250507002735 | 6650001 | Freetown Elementary School | Regular School | No | 1 | PK | 03 | 2015 | pre_kindergarten | 44 | 0 | 0 | 0 | 1 | 0 | 0 | 26 | 19 | 45 | 44 | 0 | 0 | 0 | 1 | 0 | 0 | 26 | 19 | 45 | |||||||||||||||||||||||||||||||||
744302 | 744302 | MA | Hampden | school | 2505160 | 672 | Gateway | 250516000757 | 6720059 | Chester Elementary | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 33 | 0 | 2 | 0 | 0 | 0 | 0 | 19 | 16 | 35 | 33 | 0 | 2 | 0 | 0 | 0 | 0 | 19 | 16 | 35 | |||||||||||||||||||||||||||||||||
744308 | 744308 | MA | Hampshire | school | 2505160 | 672 | Gateway | 250516000761 | 6720143 | Littleville Elementary School | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 8 | 10 | 10 | 0 | 0 | 0 | 0 | 0 | 0 | 2 | 8 | 10 | |||||||||||||||||||||||||||||||||
744377 | 744377 | MA | Essex | school | 2505670 | 675 | Hamilton-Wenham | 250567000821 | 6750015 | Winthrop School | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 18 | 0 | 0 | 1 | 1 | 0 | 0 | 10 | 10 | 20 | 18 | 0 | 0 | 1 | 1 | 0 | 0 | 10 | 10 | 20 | |||||||||||||||||||||||||||||||||
744422 | 744422 | MA | Franklin | school | 2506000 | 685 | Hawlemont | 250600000869 | 6850005 | Hawlemont Regional | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 19 | 0 | 4 | 0 | 0 | 0 | 2 | 11 | 14 | 25 | 19 | 0 | 4 | 0 | 0 | 0 | 2 | 11 | 14 | 25 | |||||||||||||||||||||||||||||||||
744442 | 744442 | MA | Essex | school | 2500067 | 698 | Manchester Essex Regional | 250006701110 | 6980010 | Manchester Memorial Elementary | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | |||||||||||||||||||||||||||||||||
744474 | 744474 | MA | Worcester | school | 2507680 | 710 | Mendon-Upton | 250768001277 | 7100001 | Memorial School | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 18 | 0 | 0 | 0 | 2 | 0 | 1 | 9 | 12 | 21 | 18 | 0 | 0 | 0 | 2 | 0 | 1 | 9 | 12 | 21 | |||||||||||||||||||||||||||||||||
744484 | 744484 | MA | Worcester | school | 2507680 | 710 | Mendon-Upton | 250768001200 | 7100179 | Henry P Clough | Regular School | No | 1 | PK | 04 | 2015 | pre_kindergarten | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 12 | 30 | 30 | 0 | 0 | 0 | 0 | 0 | 0 | 18 | 12 | 30 | |||||||||||||||||||||||||||||||||
744523 | 744523 | MA | Franklin | school | 2507990 | 717 | Mohawk Trail | 250799000424 | 7170005 | Buckland-Shelburne Regional | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 30 | 0 | 1 | 0 | 0 | 0 | 0 | 18 | 13 | 31 | 30 | 0 | 1 | 0 | 0 | 0 | 0 | 18 | 13 | 31 | |||||||||||||||||||||||||||||||||
744531 | 744531 | MA | Franklin | school | 2507990 | 717 | Mohawk Trail | 250799000425 | 7170010 | Colrain Central | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 10 | 16 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 6 | 10 | 16 | |||||||||||||||||||||||||||||||||
744539 | 744539 | MA | Franklin | school | 2507990 | 717 | Mohawk Trail | 250799000934 | 7170015 | Heath Elementary | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 12 | 0 | 1 | 0 | 0 | 0 | 1 | 9 | 5 | 14 | 12 | 0 | 1 | 0 | 0 | 0 | 1 | 9 | 5 | 14 | |||||||||||||||||||||||||||||||||
744578 | 744578 | MA | Worcester | school | 2508310 | 725 | Nashoba | 250831000948 | 7250010 | Mary Rowlandson Elementary | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 36 | 0 | 4 | 0 | 0 | 0 | 1 | 28 | 13 | 41 | 36 | 0 | 4 | 0 | 0 | 0 | 1 | 28 | 13 | 41 | |||||||||||||||||||||||||||||||||
744585 | 744585 | MA | Worcester | school | 2508310 | 725 | Nashoba | 250831000362 | 7250020 | Center School | Regular School | No | 1 | PK | 05 | 2015 | pre_kindergarten | 34 | 0 | 3 | 0 | 1 | 0 | 1 | 19 | 20 | 39 | 34 | 0 | 3 | 0 | 1 | 0 | 1 | 19 | 20 | 39 | |||||||||||||||||||||||||||||||||
744613 | 744613 | MA | Franklin | school | 2508530 | 728 | New Salem-Wendell | 250853001346 | 7280015 | Swift River | Regular School | No | 1 | PK | 06 | 2015 | pre_kindergarten | 18 | 0 | 1 | 0 | 0 | 0 | 1 | 6 | 14 | 20 | 18 | 0 | 1 | 0 | 0 | 0 | 1 | 6 | 14 | 20 |
Advanced export
JSON shape: default, array, newline-delimited
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]);