enrollments
Data source: Big Local News · About: Big Local
530 rows where grade = "pre_kindergarten", state = "MA" and year = 2021 sorted by female
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1674696 | 1674696 | MA | Essex | school | 2505220 | 105 | Georgetown | 250522000766 | 1050005 | Georgetown - Perley Elementary | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 16 | 0 | 0 | 0 | 0 | 0 | 1 | 13 | * | * | 17.0 | 16 | 0 | 0 | 0 | 0 | 0 | 1 | 13 | 17 | |||||||||||||||||||||||||||||||||
1674750 | 1674750 | MA | Dukes | school | 2505340 | 109 | Gosnold | 250534000725 | 1090005 | Gosnold - Cuttyhunk Elementary | Regular School | No | Middle | 07 | 07 | 2021 | pre_kindergarten | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1675698 | 1675698 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Lunenburg - Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2021 | pre_kindergarten | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1672637 | 1672637 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000227 | 350088 | Boston - Edward Everett | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 2 | 4 | 3 | 0 | 1 | 0 | 0 | 9 | 1 | * | 10.0 | 2 | 4 | 3 | 0 | 1 | 0 | 0 | 9 | 1 | 10 | ||||||||||||||||||||||||||||||||
1672846 | 1672846 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000292 | 350231 | Boston - Michael J Perkins | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | * | * | * | * | * | * | * | 3 | 1 | * | 4.0 | 3 | 1 | 4 | |||||||||||||||||||||||||||||||||||||||
1674324 | 1674324 | MA | Bristol | school | 2504800 | 94 | Fairhaven | 250480000640 | 940010 | Fairhaven - East Fairhaven | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 7 | 0 | 0 | 0 | 1 | 0 | 1 | 8 | 1 | * | 9.0 | 7 | 0 | 0 | 0 | 1 | 0 | 1 | 8 | 1 | 9 | ||||||||||||||||||||||||||||||||
1675726 | 1675726 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001062 | 1630016 | Lynn - A Drewicz Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | * | * | * | * | * | * | * | 2 | 1 | * | 3.0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||||||||
1677033 | 1677033 | MA | Dukes | school | 2504650 | 221 | Oak Bluffs | 250465000625 | 2210005 | Oak Bluffs - Oak Bluffs Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 5 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 1 | * | 7.0 | 5 | 0 | 2 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | ||||||||||||||||||||||||||||||||
1679132 | 1679132 | MA | Norfolk | school | 2512810 | 335 | Westwood | 251281002096 | 3350012 | Westwood - Downey | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | * | * | * | * | * | * | * | 2 | 1 | * | 3.0 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||||||||
1679681 | 1679681 | MA | Hampshire | school | 2513260 | 349 | Worthington | 251326002850 | 3490010 | Worthington - R. H. Conwell | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | * | * | * | * | * | * | * | 1 | 1 | * | 2.0 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||||||||
1680393 | 1680393 | MA | Worcester | school | 2502580 | 620 | Berlin-Boylston | 250258002901 | 6200005 | Berlin-Boylston - Berlin Memorial School | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 8 | 0 | 2 | 0 | 0 | 0 | 1 | 10 | 1 | * | 11.0 | 8 | 0 | 2 | 0 | 0 | 0 | 1 | 10 | 1 | 11 | ||||||||||||||||||||||||||||||||
1680815 | 1680815 | MA | Barnstable | school | 2500544 | 712 | Monomoy Regional School District | 250054400469 | 7120001 | Monomoy Regional School District - Chatham Elementary School | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | * | * | * | * | * | * | * | 3 | 1 | * | 4.0 | 3 | 1 | 4 | |||||||||||||||||||||||||||||||||||||||
1672672 | 1672672 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000241 | 350122 | Boston - George H Conley | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 6 | 10 | 3 | 0 | 0 | 0 | 0 | 9 | 10 | * | 19.0 | 6 | 10 | 3 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||
1672680 | 1672680 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000247 | 350135 | Boston - Henry Grew | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 5 | 8 | 4 | 0 | 0 | 0 | 3 | 10 | 10 | * | 20.0 | 5 | 8 | 4 | 0 | 0 | 0 | 3 | 10 | 10 | 20 | ||||||||||||||||||||||||||||||||
1672767 | 1672767 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000275 | 350181 | Boston - Joseph P Tynan | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 9 | 10 | 7 | 0 | 2 | 0 | 1 | 19 | 10 | * | 29.0 | 9 | 10 | 7 | 0 | 2 | 0 | 1 | 19 | 10 | 29 | ||||||||||||||||||||||||||||||||
1672932 | 1672932 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000308 | 350278 | Boston - Phineas Bates | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 10 | 5 | 6 | 0 | 0 | 0 | 0 | 11 | 10 | * | 21.0 | 10 | 5 | 6 | 0 | 0 | 0 | 0 | 11 | 10 | 21 | ||||||||||||||||||||||||||||||||
1672989 | 1672989 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000332 | 350328 | Boston - Thomas J Kenny | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 14 | 8 | 3 | 0 | 2 | 0 | 0 | 17 | 10 | * | 27.0 | 14 | 8 | 3 | 0 | 2 | 0 | 0 | 17 | 10 | 27 | ||||||||||||||||||||||||||||||||
1673050 | 1673050 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002689 | 350375 | Boston - Edison K-8 | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 1 | 1 | 14 | 0 | 2 | 0 | 1 | 9 | 10 | * | 19.0 | 1 | 1 | 14 | 0 | 2 | 0 | 1 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||
1673509 | 1673509 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000417 | 460015 | Brookline - Florida Ruffin Ridley School | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 7 | 1 | 1 | 0 | 8 | 0 | 2 | 9 | 10 | * | 19.0 | 7 | 1 | 1 | 0 | 8 | 0 | 2 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||
1673620 | 1673620 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327001621 | 490006 | Cambridge - Amigos School | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 12 | 0 | 10 | 0 | 2 | 0 | 3 | 17 | 10 | * | 27.0 | 12 | 0 | 10 | 0 | 2 | 0 | 3 | 17 | 10 | 27 | ||||||||||||||||||||||||||||||||
1674143 | 1674143 | MA | Plymouth | school | 2504410 | 82 | Duxbury | 250441000593 | 820006 | Duxbury - Chandler Elementary | Regular School | No | Elementary | PK | 02 | 2021 | pre_kindergarten | 26 | 0 | 1 | 0 | 0 | 0 | 2 | 19 | 10 | * | 29.0 | 26 | 0 | 1 | 0 | 0 | 0 | 2 | 19 | 10 | 29 | ||||||||||||||||||||||||||||||||
1674400 | 1674400 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483000679 | 950130 | Fall River - Spencer Borden | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 11 | 2 | 6 | 0 | 0 | 0 | 4 | 13 | 10 | * | 23.0 | 11 | 2 | 6 | 0 | 0 | 0 | 4 | 13 | 10 | 23 | ||||||||||||||||||||||||||||||||
1674479 | 1674479 | MA | Worcester | school | 2504890 | 97 | Fitchburg | 250489000696 | 970016 | Fitchburg - Crocker Elementary | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 6 | 2 | 14 | 0 | 0 | 0 | 1 | 13 | 10 | * | 23.0 | 6 | 2 | 14 | 0 | 0 | 0 | 1 | 13 | 10 | 23 | ||||||||||||||||||||||||||||||||
1674825 | 1674825 | MA | Hampshire | school | 2505580 | 117 | Hadley | 250558000879 | 1170015 | Hadley - Hadley Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 15 | 0 | 3 | 0 | 0 | 0 | 0 | 8 | 10 | * | 18.0 | 15 | 0 | 3 | 0 | 0 | 0 | 0 | 8 | 10 | 18 | ||||||||||||||||||||||||||||||||
1674965 | 1674965 | MA | Plymouth | school | 2506090 | 131 | Hingham | 250609002671 | 1310005 | Hingham - East Elementary School | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 23 | 1 | 3 | 0 | 0 | 0 | 0 | 17 | 10 | * | 27.0 | 23 | 1 | 3 | 0 | 0 | 0 | 0 | 17 | 10 | 27 | ||||||||||||||||||||||||||||||||
1675359 | 1675359 | MA | Worcester | school | 2506780 | 153 | Leominster | 250678001947 | 1530005 | Leominster - Lincoln School | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 8 | 3 | 11 | 0 | 0 | 0 | 2 | 14 | 10 | * | 24.0 | 8 | 3 | 11 | 0 | 0 | 0 | 2 | 14 | 10 | 24 | ||||||||||||||||||||||||||||||||
1675463 | 1675463 | MA | Middlesex | school | 2506900 | 157 | Lincoln | 250690001183 | 1570025 | Lincoln - Lincoln School | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 9 | 0 | 1 | 0 | 7 | 0 | 3 | 10 | 10 | * | 20.0 | 9 | 0 | 1 | 0 | 7 | 0 | 3 | 10 | 10 | 20 | ||||||||||||||||||||||||||||||||
1675576 | 1675576 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001044 | 1600036 | Lowell - Pawtucketville Memorial | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 9 | 2 | 6 | 0 | 8 | 0 | 2 | 17 | 10 | * | 27.0 | 9 | 2 | 6 | 0 | 8 | 0 | 2 | 17 | 10 | 27 | ||||||||||||||||||||||||||||||||
1676740 | 1676740 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001388 | 2090008 | North Adams - Colegrove Park Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 20 | 0 | 1 | 0 | 0 | 0 | 2 | 13 | 10 | * | 23.0 | 20 | 0 | 1 | 0 | 0 | 0 | 2 | 13 | 10 | 23 | ||||||||||||||||||||||||||||||||
1676770 | 1676770 | MA | Hampshire | school | 2508850 | 210 | Northampton | 250885001425 | 2100005 | Northampton - Bridge Street | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 10 | 1 | 8 | 0 | 1 | 0 | 2 | 12 | 10 | * | 22.0 | 10 | 1 | 8 | 0 | 1 | 0 | 2 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||
1676983 | 1676983 | MA | Plymouth | school | 2509030 | 219 | Norwell | 250903001458 | 2190020 | Norwell - William G Vinal | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 17 | 0 | 0 | 0 | 0 | 0 | 1 | 8 | 10 | * | 18.0 | 17 | 0 | 0 | 0 | 0 | 0 | 1 | 8 | 10 | 18 | ||||||||||||||||||||||||||||||||
1677132 | 1677132 | MA | Essex | school | 2509360 | 229 | Peabody | 250936001505 | 2290045 | Peabody - West Memorial | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 14 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 10 | * | 15.0 | 14 | 0 | 0 | 0 | 0 | 0 | 1 | 5 | 10 | 15 | ||||||||||||||||||||||||||||||||
1677970 | 1677970 | MA | Hampshire | school | 2510950 | 275 | Southampton | 251095001758 | 2750005 | Southampton - William E Norris | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 10 | * | 26.0 | 26 | 0 | 0 | 0 | 0 | 0 | 0 | 16 | 10 | 26 | ||||||||||||||||||||||||||||||||
1679628 | 1679628 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002422 | 3480280 | Worcester - Vernon Hill School | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 2 | 8 | 13 | 0 | 0 | 0 | 0 | 13 | 10 | * | 23.0 | 2 | 8 | 13 | 0 | 0 | 0 | 0 | 13 | 10 | 23 | ||||||||||||||||||||||||||||||||
1680322 | 1680322 | MA | Worcester | school | 2502040 | 610 | Ashburnham-Westminster | 250204002368 | 6100025 | Ashburnham-Westminster - Briggs Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 24 | 1 | 1 | 0 | 0 | 0 | 3 | 19 | 10 | * | 29.0 | 24 | 1 | 1 | 0 | 0 | 0 | 3 | 19 | 10 | 29 | ||||||||||||||||||||||||||||||||
1680873 | 1680873 | MA | Franklin | school | 2507990 | 717 | Mohawk Trail | 250799001636 | 7170020 | Mohawk Trail - Sanderson Academy | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | * | 20.0 | 20 | 0 | 0 | 0 | 0 | 0 | 0 | 10 | 10 | 20 | ||||||||||||||||||||||||||||||||
1681001 | 1681001 | MA | Essex | school | 2509450 | 745 | Pentucket | 250945000408 | 7450015 | Pentucket - Dr John C Page School | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 10 | * | 19.0 | 19 | 0 | 0 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||
1681041 | 1681041 | MA | Worcester | school | 2500001 | 753 | Quabbin | 250000102398 | 7530005 | Quabbin - Hardwick Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 27 | 0 | 4 | 0 | 1 | 0 | 1 | 23 | 10 | * | 33.0 | 27 | 0 | 4 | 0 | 1 | 0 | 1 | 23 | 10 | 33 | ||||||||||||||||||||||||||||||||
1672627 | 1672627 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000224 | 350080 | Boston - Donald Mckay | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 2 | 1 | 17 | 0 | 0 | 0 | 1 | 10 | 11 | * | 21.0 | 2 | 1 | 17 | 0 | 0 | 0 | 1 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||
1672736 | 1672736 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000265 | 350166 | Boston - John F Kennedy | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 6 | 7 | 10 | 0 | 2 | 0 | 1 | 15 | 11 | * | 26.0 | 6 | 7 | 10 | 0 | 2 | 0 | 1 | 15 | 11 | 26 | ||||||||||||||||||||||||||||||||
1672854 | 1672854 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000294 | 350237 | Boston - Mozart | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 12 | 8 | 5 | 0 | 0 | 0 | 3 | 17 | 11 | * | 28.0 | 12 | 8 | 5 | 0 | 0 | 0 | 3 | 17 | 11 | 28 | ||||||||||||||||||||||||||||||||
1672962 | 1672962 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000322 | 350304 | Boston - Samuel W Mason | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 2 | 14 | 6 | 0 | 0 | 0 | 0 | 11 | 11 | * | 22.0 | 2 | 14 | 6 | 0 | 0 | 0 | 0 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||
1672979 | 1672979 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000331 | 350326 | Boston - Gardner Pilot Academy | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 2 | 2 | 12 | 0 | 2 | 0 | 3 | 10 | 11 | * | 21.0 | 2 | 2 | 12 | 0 | 2 | 0 | 3 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||
1673637 | 1673637 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327000441 | 490020 | Cambridge - Haggerty | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 11 | 5 | 0 | 0 | 5 | 0 | 0 | 10 | 11 | * | 21.0 | 11 | 5 | 0 | 0 | 5 | 0 | 0 | 10 | 11 | 21 | ||||||||||||||||||||||||||||||||
1674168 | 1674168 | MA | Barnstable | school | 2504530 | 85 | Eastham | 250453000607 | 850005 | Eastham - Eastham Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 12 | 2 | 3 | 0 | 0 | 0 | 5 | 11 | 11 | * | 22.0 | 12 | 2 | 3 | 0 | 0 | 0 | 5 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||
1674373 | 1674373 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002811 | 950017 | Fall River - Henry Lord Community School | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 18 | 1 | 8 | 0 | 2 | 0 | 6 | 24 | 11 | * | 35.0 | 18 | 1 | 8 | 0 | 2 | 0 | 6 | 24 | 11 | 35 | ||||||||||||||||||||||||||||||||
1675078 | 1675078 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000907 | 1370055 | Holyoke - Lt Clayre Sullivan Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 4 | 0 | 18 | 0 | 1 | 0 | 0 | 12 | 11 | * | 23.0 | 4 | 0 | 18 | 0 | 1 | 0 | 0 | 12 | 11 | 23 | ||||||||||||||||||||||||||||||||
1675522 | 1675522 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702000067 | 1600002 | Lowell - Dr Gertrude Bailey | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 5 | 2 | 3 | 0 | 9 | 0 | 1 | 9 | 11 | * | 20.0 | 5 | 2 | 3 | 0 | 9 | 0 | 1 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||
1675559 | 1675559 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001023 | 1600020 | Lowell - Abraham Lincoln | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 1 | 4 | 5 | 0 | 13 | 0 | 4 | 16 | 11 | * | 27.0 | 1 | 4 | 5 | 0 | 13 | 0 | 4 | 16 | 11 | 27 | ||||||||||||||||||||||||||||||||
1675582 | 1675582 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001045 | 1600040 | Lowell - Peter W Reilly | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 14 | 2 | 8 | 0 | 3 | 0 | 1 | 17 | 11 | * | 28.0 | 14 | 2 | 8 | 0 | 3 | 0 | 1 | 17 | 11 | 28 | ||||||||||||||||||||||||||||||||
1675670 | 1675670 | MA | Hampden | school | 2507050 | 161 | Ludlow | 250705002663 | 1610010 | Ludlow - East Street Elementary School | Regular School | No | Elementary | PK | 01 | 2021 | pre_kindergarten | 35 | 0 | 8 | 0 | 3 | 1 | 2 | 38 | 11 | * | 49.0 | 35 | 0 | 8 | 0 | 3 | 1 | 2 | 38 | 11 | 49 | ||||||||||||||||||||||||||||||||
1676478 | 1676478 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001341 | 2010045 | New Bedford - Sgt Wm H Carney Academy | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 24 | 4 | 12 | 0 | 2 | 0 | 2 | 33 | 11 | * | 44.0 | 24 | 4 | 12 | 0 | 2 | 0 | 2 | 33 | 11 | 44 | ||||||||||||||||||||||||||||||||
1677522 | 1677522 | MA | Suffolk | school | 2510050 | 248 | Revere | 251005001962 | 2480013 | Revere - Beachmont Veterans Memorial School | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 16 | 1 | 10 | 0 | 0 | 0 | 0 | 16 | 11 | * | 27.0 | 16 | 1 | 10 | 0 | 0 | 0 | 0 | 16 | 11 | 27 | ||||||||||||||||||||||||||||||||
1678343 | 1678343 | MA | Middlesex | school | 2511220 | 284 | Stoneham | 251122001851 | 2840005 | Stoneham - Colonial Park | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 15 | 0 | 3 | 0 | 4 | 0 | 3 | 14 | 11 | * | 25.0 | 15 | 0 | 3 | 0 | 4 | 0 | 3 | 14 | 11 | 25 | ||||||||||||||||||||||||||||||||
1678527 | 1678527 | MA | Bristol | school | 2511520 | 293 | Taunton | 251152002697 | 2930015 | Taunton - Mulcahey Elementary School | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 11 | 7 | 3 | 0 | 0 | 0 | 1 | 11 | 11 | * | 22.0 | 11 | 7 | 3 | 0 | 0 | 0 | 1 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||
1679033 | 1679033 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266001740 | 3260055 | Westford - Rita E. Miller Elementary School | Regular School | No | Elementary | PK | 02 | 2021 | pre_kindergarten | 9 | 0 | 4 | 0 | 8 | 0 | 1 | 11 | 11 | * | 22.0 | 9 | 0 | 4 | 0 | 8 | 0 | 1 | 11 | 11 | 22 | ||||||||||||||||||||||||||||||||
1679282 | 1679282 | MA | Middlesex | school | 2513110 | 344 | Winchester | 251311002166 | 3440020 | Winchester - Lynch Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 25 | 0 | 3 | 0 | 8 | 0 | 0 | 25 | 11 | * | 36.0 | 25 | 0 | 3 | 0 | 8 | 0 | 0 | 25 | 11 | 36 | ||||||||||||||||||||||||||||||||
1679567 | 1679567 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002241 | 3480210 | Worcester - Quinsigamond | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 6 | 5 | 6 | 0 | 1 | 0 | 1 | 8 | 11 | * | 19.0 | 6 | 5 | 6 | 0 | 1 | 0 | 1 | 8 | 11 | 19 | ||||||||||||||||||||||||||||||||
1680590 | 1680590 | MA | Berkshire | school | 2513321 | 662 | Farmington River Reg | 251332100402 | 6620020 | Farmington River Reg - Farmington River Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 17 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 11 | * | 18.0 | 17 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 11 | 18 | ||||||||||||||||||||||||||||||||
1680857 | 1680857 | MA | Franklin | school | 2507990 | 717 | Mohawk Trail | 250799000424 | 7170005 | Mohawk Trail - Buckland-Shelburne Regional | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 18 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 11 | * | 20.0 | 18 | 0 | 0 | 0 | 0 | 0 | 2 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||
1680902 | 1680902 | MA | Worcester | school | 2508310 | 725 | Nashoba | 250831000948 | 7250010 | Nashoba - Mary Rowlandson Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 19 | 1 | 3 | 0 | 2 | 0 | 0 | 14 | 11 | * | 25.0 | 19 | 1 | 3 | 0 | 2 | 0 | 0 | 14 | 11 | 25 | ||||||||||||||||||||||||||||||||
1680949 | 1680949 | MA | Middlesex | school | 2508790 | 735 | North Middlesex | 250879002686 | 7350002 | North Middlesex - Squannacook Early Childhood Center | Regular School | No | Elementary | 02 | 04 | 2021 | pre_kindergarten | 33 | 1 | 1 | 0 | 1 | 0 | 0 | 25 | 11 | * | 36.0 | 33 | 1 | 1 | 0 | 1 | 0 | 0 | 25 | 11 | 36 | ||||||||||||||||||||||||||||||||
1672024 | 1672024 | MA | Bristol | school | 2501740 | 3 | Acushnet | 250174000014 | 30025 | Acushnet - Acushnet Elementary School | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 25 | 1 | 1 | 0 | 0 | 0 | 1 | 16 | 12 | * | 28.0 | 25 | 1 | 1 | 0 | 0 | 0 | 1 | 16 | 12 | 28 | ||||||||||||||||||||||||||||||||
1672914 | 1672914 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000302 | 350264 | Boston - Patrick J Kennedy | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 1 | 0 | 25 | 0 | 0 | 0 | 0 | 14 | 12 | * | 26.0 | 1 | 0 | 25 | 0 | 0 | 0 | 0 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||
1673309 | 1673309 | MA | Essex | school | 2502880 | 38 | Boxford | 250288000357 | 380005 | Boxford - Harry Lee Cole | Regular School | No | Elementary | PK | 02 | 2021 | pre_kindergarten | 24 | 0 | 2 | 0 | 1 | 0 | 0 | 15 | 12 | * | 27.0 | 24 | 0 | 2 | 0 | 1 | 0 | 0 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||
1673496 | 1673496 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315002776 | 460001 | Brookline - Brookline Early Education Program at Beacon | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 11 | 1 | 0 | 0 | 9 | 0 | 5 | 14 | 12 | * | 26.0 | 11 | 1 | 0 | 0 | 9 | 0 | 5 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||
1673574 | 1673574 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315002027 | 460060 | Brookline - The Lynch Center | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 9 | 6 | 5 | 0 | 8 | 0 | 2 | 18 | 12 | * | 30.0 | 9 | 6 | 5 | 0 | 8 | 0 | 2 | 18 | 12 | 30 | ||||||||||||||||||||||||||||||||
1673644 | 1673644 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327000443 | 490030 | Cambridge - Martin Luther King Jr. | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 5 | 3 | 1 | 0 | 10 | 0 | 5 | 12 | 12 | * | 24.0 | 5 | 3 | 1 | 0 | 10 | 0 | 5 | 12 | 12 | 24 | ||||||||||||||||||||||||||||||||
1673686 | 1673686 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327000437 | 490080 | Cambridge - Graham and Parks | Alternative School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 9 | 8 | 2 | 0 | 3 | 0 | 1 | 11 | 12 | * | 23.0 | 9 | 8 | 2 | 0 | 3 | 0 | 1 | 11 | 12 | 23 | ||||||||||||||||||||||||||||||||
1675478 | 1675478 | MA | Middlesex | school | 2506960 | 158 | Littleton | 250696001014 | 1580005 | Littleton - Shaker Lane Elementary | Regular School | No | Elementary | PK | 02 | 2021 | pre_kindergarten | 26 | 0 | 1 | 0 | 6 | 1 | 0 | 22 | 12 | * | 34.0 | 26 | 0 | 1 | 0 | 6 | 1 | 0 | 22 | 12 | 34 | ||||||||||||||||||||||||||||||||
1675684 | 1675684 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708001957 | 1620010 | Lunenburg - Lunenburg Primary School | Regular School | No | Elementary | PK | 02 | 2021 | pre_kindergarten | 25 | 0 | 5 | 0 | 1 | 0 | 2 | 21 | 12 | * | 33.0 | 25 | 0 | 5 | 0 | 1 | 0 | 2 | 21 | 12 | 33 | ||||||||||||||||||||||||||||||||
1675739 | 1675739 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001077 | 1630030 | Lynn - Julia F Callahan | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 7 | 0 | 20 | 0 | 3 | 0 | 2 | 20 | 12 | * | 32.0 | 7 | 0 | 20 | 0 | 3 | 0 | 2 | 20 | 12 | 32 | ||||||||||||||||||||||||||||||||
1675771 | 1675771 | MA | Essex | school | 2507110 | 163 | Lynn | 250711001074 | 1630055 | Lynn - Hood | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 5 | 6 | 16 | 0 | 2 | 0 | 0 | 17 | 12 | * | 29.0 | 5 | 6 | 16 | 0 | 2 | 0 | 0 | 17 | 12 | 29 | ||||||||||||||||||||||||||||||||
1676504 | 1676504 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001323 | 2010075 | New Bedford - Ellen R Hathaway | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 9 | 5 | 11 | 0 | 0 | 0 | 0 | 13 | 12 | * | 25.0 | 9 | 5 | 11 | 0 | 0 | 0 | 0 | 13 | 12 | 25 | ||||||||||||||||||||||||||||||||
1676538 | 1676538 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001320 | 2010123 | New Bedford - Casimir Pulaski | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 24 | 3 | 8 | 0 | 0 | 0 | 2 | 25 | 12 | * | 37.0 | 24 | 3 | 8 | 0 | 0 | 0 | 2 | 25 | 12 | 37 | ||||||||||||||||||||||||||||||||
1677636 | 1677636 | MA | Essex | school | 2510380 | 258 | Salem | 251038000127 | 2580001 | Salem - Salem Early Childhood | Regular School | No | Elementary | PK | KG | 2021 | pre_kindergarten | 23 | 5 | 17 | 0 | 0 | 0 | 3 | 36 | 12 | * | 48.0 | 23 | 5 | 17 | 0 | 0 | 0 | 3 | 36 | 12 | 48 | ||||||||||||||||||||||||||||||||
1678183 | 1678183 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001819 | 2810145 | Springfield - Mary O Pottenger | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 5 | 3 | 20 | 0 | 0 | 0 | 2 | 18 | 12 | * | 30.0 | 5 | 3 | 20 | 0 | 0 | 0 | 2 | 18 | 12 | 30 | ||||||||||||||||||||||||||||||||
1678216 | 1678216 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001835 | 2810180 | Springfield - Warner | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 8 | 8 | 20 | 0 | 0 | 0 | 1 | 25 | 12 | * | 37.0 | 8 | 8 | 20 | 0 | 0 | 0 | 1 | 25 | 12 | 37 | ||||||||||||||||||||||||||||||||
1678944 | 1678944 | MA | Worcester | school | 2512390 | 322 | West Boylston | 251239002034 | 3220005 | West Boylston - Major Edwards Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 20 | 2 | 4 | 0 | 0 | 0 | 0 | 14 | 12 | * | 26.0 | 20 | 2 | 4 | 0 | 0 | 0 | 0 | 14 | 12 | 26 | ||||||||||||||||||||||||||||||||
1679289 | 1679289 | MA | Middlesex | school | 2513110 | 344 | Winchester | 251311002172 | 3440025 | Winchester - Vinson-Owen Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 10 | 1 | 0 | 0 | 3 | 0 | 0 | 2 | 12 | * | 14.0 | 10 | 1 | 0 | 0 | 3 | 0 | 0 | 2 | 12 | 14 | ||||||||||||||||||||||||||||||||
1679447 | 1679447 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002206 | 3480055 | Worcester - Clark St Community | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 3 | 8 | 4 | 0 | 5 | 0 | 4 | 12 | 12 | * | 24.0 | 3 | 8 | 4 | 0 | 5 | 0 | 4 | 12 | 12 | 24 | ||||||||||||||||||||||||||||||||
1680501 | 1680501 | MA | Barnstable | school | 2504140 | 645 | Dennis-Yarmouth | 250414000559 | 6450005 | Dennis-Yarmouth - Ezra H Baker Innovation School | Regular School | No | Elementary | PK | 03 | 2021 | pre_kindergarten | 23 | 1 | 2 | 2 | 3 | 0 | 1 | 20 | 12 | * | 32.0 | 23 | 1 | 2 | 2 | 3 | 0 | 1 | 20 | 12 | 32 | ||||||||||||||||||||||||||||||||
1681019 | 1681019 | MA | Franklin | school | 2509600 | 750 | Pioneer Valley | 250960002612 | 7500006 | Pioneer Valley - Bernardston Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 12 | * | 15.0 | 15 | 0 | 0 | 0 | 0 | 0 | 0 | 3 | 12 | 15 | ||||||||||||||||||||||||||||||||
1681060 | 1681060 | MA | Worcester | school | 2500001 | 753 | Quabbin | 250000102403 | 7530030 | Quabbin - Ruggles Lane | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 32 | 0 | 2 | 0 | 1 | 0 | 1 | 24 | 12 | * | 36.0 | 32 | 0 | 2 | 0 | 1 | 0 | 1 | 24 | 12 | 36 | ||||||||||||||||||||||||||||||||
1681168 | 1681168 | MA | Essex | school | 2511740 | 773 | Triton | 251174001348 | 7730020 | Triton - Newbury Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 25 | 1 | 1 | 0 | 0 | 0 | 0 | 15 | 12 | * | 27.0 | 25 | 1 | 1 | 0 | 0 | 0 | 0 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||
1672520 | 1672520 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002687 | 350012 | Boston - Boston Teachers Union School | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 12 | 2 | 12 | 0 | 0 | 0 | 1 | 14 | 13 | * | 27.0 | 12 | 2 | 12 | 0 | 0 | 0 | 1 | 14 | 13 | 27 | ||||||||||||||||||||||||||||||||
1672655 | 1672655 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000232 | 350100 | Boston - Ellis Mendell | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 8 | 4 | 11 | 0 | 0 | 0 | 1 | 11 | 13 | * | 24.0 | 8 | 4 | 11 | 0 | 0 | 0 | 1 | 11 | 13 | 24 | ||||||||||||||||||||||||||||||||
1673033 | 1673033 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000343 | 350370 | Boston - William Monroe Trotter | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 1 | 18 | 16 | 0 | 3 | 0 | 1 | 26 | 13 | * | 39.0 | 1 | 18 | 16 | 0 | 3 | 0 | 1 | 26 | 13 | 39 | ||||||||||||||||||||||||||||||||
1673248 | 1673248 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002721 | 350656 | Boston - Mario Umana Academy | Regular School | No | Elementary | PK | 08 | 2021 | pre_kindergarten | 3 | 1 | 21 | 0 | 1 | 0 | 0 | 13 | 13 | * | 26.0 | 3 | 1 | 21 | 0 | 1 | 0 | 0 | 13 | 13 | 26 | ||||||||||||||||||||||||||||||||
1673498 | 1673498 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315002904 | 460003 | Brookline - Brookline Early Education Program at Clark Road | Regular School | No | Prekindergarten | PK | PK | 2021 | pre_kindergarten | 17 | 1 | 2 | 0 | 5 | 0 | 6 | 18 | 13 | * | 31.0 | 17 | 1 | 2 | 0 | 5 | 0 | 6 | 18 | 13 | 31 | ||||||||||||||||||||||||||||||||
1673630 | 1673630 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327000020 | 490007 | Cambridge - Cambridgeport | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 14 | 2 | 0 | 0 | 5 | 0 | 1 | 9 | 13 | * | 22.0 | 14 | 2 | 0 | 0 | 5 | 0 | 1 | 9 | 13 | 22 | ||||||||||||||||||||||||||||||||
1674086 | 1674086 | MA | Worcester | school | 2504230 | 77 | Douglas | 250423002798 | 770005 | Douglas - Douglas Primary School | Regular School | No | Elementary | PK | 01 | 2021 | pre_kindergarten | 28 | 1 | 1 | 0 | 0 | 0 | 1 | 18 | 13 | * | 31.0 | 28 | 1 | 1 | 0 | 0 | 0 | 1 | 18 | 13 | 31 | ||||||||||||||||||||||||||||||||
1674220 | 1674220 | MA | Bristol | school | 2504620 | 88 | Easton | 250462000624 | 880015 | Easton - Parkview Elementary | Regular School | No | Elementary | PK | 02 | 2021 | pre_kindergarten | 27 | 4 | 7 | 0 | 5 | 0 | 3 | 33 | 13 | * | 46.0 | 27 | 4 | 7 | 0 | 5 | 0 | 3 | 33 | 13 | 46 | ||||||||||||||||||||||||||||||||
1675537 | 1675537 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702000477 | 1600010 | Lowell - Joseph McAvinnue | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 6 | 4 | 6 | 0 | 7 | 0 | 0 | 10 | 13 | * | 23.0 | 6 | 4 | 6 | 0 | 7 | 0 | 0 | 10 | 13 | 23 | ||||||||||||||||||||||||||||||||
1675543 | 1675543 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001033 | 1600015 | Lowell - Greenhalge | Regular School | No | Elementary | PK | 04 | 2021 | pre_kindergarten | 9 | 2 | 13 | 0 | 7 | 0 | 2 | 20 | 13 | * | 33.0 | 9 | 2 | 13 | 0 | 7 | 0 | 2 | 20 | 13 | 33 | ||||||||||||||||||||||||||||||||
1675848 | 1675848 | MA | Essex | school | 2507110 | 163 | Lynn | 250711002277 | 1630605 | Lynn - Lynn Vocational Technical Institute | Career and Technical School | No | Other | PK | 12 | 2021 | pre_kindergarten | 4 | 0 | 28 | 0 | 0 | 0 | 2 | 21 | 13 | * | 34.0 | 4 | 0 | 28 | 0 | 0 | 0 | 2 | 21 | 13 | 34 | ||||||||||||||||||||||||||||||||
1676079 | 1676079 | MA | Norfolk | school | 2507530 | 175 | Medfield | 250753000114 | 1750003 | Medfield - Memorial School | Regular School | No | Elementary | PK | 01 | 2021 | pre_kindergarten | 30 | 0 | 1 | 0 | 1 | 0 | 4 | 23 | 13 | * | 36.0 | 30 | 0 | 1 | 0 | 1 | 0 | 4 | 23 | 13 | 36 | ||||||||||||||||||||||||||||||||
1676465 | 1676465 | MA | Bristol | school | 2508430 | 201 | New Bedford | 250843001324 | 2010020 | New Bedford - Elwyn G Campbell | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 19 | 7 | 9 | 0 | 0 | 0 | 2 | 24 | 13 | * | 37.0 | 19 | 7 | 9 | 0 | 0 | 0 | 2 | 24 | 13 | 37 | ||||||||||||||||||||||||||||||||
1676916 | 1676916 | MA | Worcester | school | 2508760 | 215 | North Brookfield | 250876001410 | 2150015 | North Brookfield - North Brookfield Elementary | Regular School | No | Elementary | PK | 06 | 2021 | pre_kindergarten | 20 | 0 | 2 | 0 | 0 | 0 | 1 | 10 | 13 | * | 23.0 | 20 | 0 | 2 | 0 | 0 | 0 | 1 | 10 | 13 | 23 | ||||||||||||||||||||||||||||||||
1677118 | 1677118 | MA | Essex | school | 2509360 | 229 | Peabody | 250936001506 | 2290027 | Peabody - William A Welch Sr | Regular School | No | Elementary | PK | 05 | 2021 | pre_kindergarten | 11 | 2 | 5 | 0 | 0 | 0 | 1 | 6 | 13 | * | 19.0 | 11 | 2 | 5 | 0 | 0 | 0 | 1 | 6 | 13 | 19 |
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]);