enrollments
Data source: Big Local News · About: Big Local
3,459 rows where grade = "grade_8" and state = "MA" sorted by white
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1365306 | 1365306 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002687 | 350012 | Boston Teachers Union School | Regular School | No | Elementary | PK | 08 | 2020 | grade_8 | 0 | 8 | 14 | 0 | 0 | 0 | 1 | 10 | 13 | * | 23.0 | 0 | 8 | 14 | 0 | 0 | 0 | 1 | 10 | 13 | 23 | ||||||||||||||||||||||||||||||||
1365554 | 1365554 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000272 | 350182 | Joseph J Hurley | Regular School | No | Elementary | PK | 08 | 2020 | grade_8 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 9 | 6 | * | 15.0 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 9 | 6 | 15 | ||||||||||||||||||||||||||||||||
1365612 | 1365612 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000291 | 350229 | Maurice J Tobin | Regular School | No | Elementary | PK | 08 | 2020 | grade_8 | 0 | 9 | 21 | 0 | 3 | 0 | 0 | 19 | 14 | * | 33.0 | 0 | 9 | 21 | 0 | 3 | 0 | 0 | 19 | 14 | 33 | ||||||||||||||||||||||||||||||||
1365741 | 1365741 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Sarah Greenwood | Regular School | No | Elementary | PK | 08 | 2020 | grade_8 | 0 | 10 | 13 | 0 | 0 | 0 | 0 | 16 | 7 | * | 23.0 | 0 | 10 | 13 | 0 | 0 | 0 | 0 | 16 | 7 | 23 | ||||||||||||||||||||||||||||||||
1365804 | 1365804 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000343 | 350370 | William Monroe Trotter | Regular School | No | Elementary | PK | 08 | 2020 | grade_8 | 0 | 10 | 12 | 0 | 0 | 0 | 5 | 15 | 12 | * | 27.0 | 0 | 10 | 12 | 0 | 0 | 0 | 5 | 15 | 12 | 27 | ||||||||||||||||||||||||||||||||
1365831 | 1365831 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002669 | 350376 | King K-8 | Regular School | No | Elementary | PK | 08 | 2020 | grade_8 | 0 | 21 | 16 | 0 | 0 | 0 | 3 | 17 | 23 | * | 40.0 | 0 | 21 | 16 | 0 | 0 | 0 | 3 | 17 | 23 | 40 | ||||||||||||||||||||||||||||||||
1365837 | 1365837 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Higginson/Lewis K-8 | Regular School | No | Middle | 03 | 08 | 2020 | grade_8 | 0 | 20 | 12 | 0 | 0 | 0 | 4 | 21 | 15 | * | 36.0 | 0 | 20 | 12 | 0 | 0 | 0 | 4 | 21 | 15 | 36 | ||||||||||||||||||||||||||||||||
1365857 | 1365857 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000693 | 350380 | Young Achievers | Alternative School | No | Elementary | PK | 08 | 2020 | grade_8 | 0 | 19 | 18 | 0 | 0 | 0 | 1 | 23 | 15 | * | 38.0 | 0 | 19 | 18 | 0 | 0 | 0 | 1 | 23 | 15 | 38 | ||||||||||||||||||||||||||||||||
1365867 | 1365867 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000946 | 350382 | Mission Hill School | Regular School | No | Elementary | PK | 08 | 2020 | grade_8 | 0 | 3 | 9 | 0 | 0 | 0 | 2 | 10 | 4 | * | 14.0 | 0 | 3 | 9 | 0 | 0 | 0 | 2 | 10 | 4 | 14 | ||||||||||||||||||||||||||||||||
1366041 | 1366041 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000312 | 350691 | Rafael Hernandez | Regular School | No | Elementary | PK | 08 | 2020 | grade_8 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 4 | 11 | * | 15.0 | 0 | 0 | 15 | 0 | 0 | 0 | 0 | 4 | 11 | 15 | ||||||||||||||||||||||||||||||||
1367824 | 1367824 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000904 | 1370040 | Kelly Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_8 | 0 | 2 | 37 | 0 | 0 | 0 | 0 | 24 | 15 | * | 39.0 | 0 | 2 | 37 | 0 | 0 | 0 | 0 | 24 | 15 | 39 | ||||||||||||||||||||||||||||||||
1368003 | 1368003 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002630 | 1490025 | Guilmette Middle School | Regular School | No | Middle | 05 | 08 | 2020 | grade_8 | 0 | 3 | 105 | 0 | 1 | 0 | 0 | 50 | 59 | * | 109.0 | 0 | 3 | 105 | 0 | 1 | 0 | 0 | 50 | 59 | 109 | ||||||||||||||||||||||||||||||||
1368039 | 1368039 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666000955 | 1490080 | Emily G Wetherbee | Regular School | No | Elementary | KG | 08 | 2020 | grade_8 | 0 | 1 | 65 | 0 | 2 | 0 | 0 | 31 | 37 | * | 68.0 | 0 | 1 | 65 | 0 | 2 | 0 | 0 | 31 | 37 | 68 | ||||||||||||||||||||||||||||||||
1368045 | 1368045 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002766 | 1490090 | UP Academy Leonard Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 0 | 1 | 102 | 0 | 1 | 0 | 0 | 60 | 44 | * | 104.0 | 0 | 1 | 102 | 0 | 1 | 0 | 0 | 60 | 44 | 104 | ||||||||||||||||||||||||||||||||
1370707 | 1370707 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089002498 | 2740410 | Next Wave Junior High | Alternative School | No | Middle | 06 | 08 | 2020 | grade_8 | 0 | 2 | 7 | 0 | 1 | 0 | 0 | 8 | * | * | 10.0 | 0 | 2 | 7 | 0 | 1 | 0 | 0 | 8 | 10 | |||||||||||||||||||||||||||||||||
1371019 | 1371019 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002733 | 2810355 | South End Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 0 | 8 | 58 | 0 | 0 | 0 | 2 | 36 | 32 | * | 68.0 | 0 | 8 | 58 | 0 | 0 | 0 | 2 | 36 | 32 | 68 | ||||||||||||||||||||||||||||||||
1372505 | 1372505 | MA | Suffolk | school | 2500527 | 417 | Bridge Boston Charter School (District) | 250052702710 | 4170205 | Bridge Boston Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_8 | 0 | 15 | 6 | 0 | 0 | 0 | 1 | 10 | 12 | * | 22.0 | 0 | 15 | 6 | 0 | 0 | 0 | 1 | 10 | 12 | 22 | ||||||||||||||||||||||||||||||||
1372533 | 1372533 | MA | Essex | school | 2500538 | 426 | Community Day Charter Public School - Gateway (District) | 250053802717 | 4260205 | Community Day Charter Public School - Gateway | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_8 | 0 | 0 | 32 | 0 | 1 | 0 | 0 | 14 | 19 | * | 33.0 | 0 | 0 | 32 | 0 | 1 | 0 | 0 | 14 | 19 | 33 | ||||||||||||||||||||||||||||||||
1372576 | 1372576 | 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 | Elementary | PK | 08 | 2020 | grade_8 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 18 | 12 | * | 30.0 | 0 | 0 | 30 | 0 | 0 | 0 | 0 | 18 | 12 | 30 | ||||||||||||||||||||||||||||||||
1372608 | 1372608 | MA | Suffolk | school | 2500070 | 438 | Codman Academy Charter Public (District) | 250007001667 | 4380505 | Codman Academy Charter Public School | Regular School | Yes | Other | PK | 12 | 2020 | grade_8 | 0 | 15 | 4 | 0 | 0 | 0 | 0 | 10 | 9 | * | 19.0 | 0 | 15 | 4 | 0 | 0 | 0 | 0 | 10 | 9 | 19 | ||||||||||||||||||||||||||||||||
1372622 | 1372622 | MA | Suffolk | school | 2500060 | 439 | Conservatory Lab Charter (District) | 250006001439 | 4390050 | Conservatory Lab Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_8 | 0 | 15 | 9 | 0 | 0 | 0 | 0 | 7 | 17 | * | 24.0 | 0 | 15 | 9 | 0 | 0 | 0 | 0 | 7 | 17 | 24 | ||||||||||||||||||||||||||||||||
1372765 | 1372765 | MA | Suffolk | school | 2500537 | 463 | KIPP Academy Boston Charter School (District) | 250053702716 | 4630205 | KIPP Academy Boston Charter School | Regular School | Yes | Elementary | KG | 08 | 2020 | grade_8 | 0 | 39 | 18 | 0 | 0 | 0 | 1 | 24 | 34 | * | 58.0 | 0 | 39 | 18 | 0 | 0 | 0 | 1 | 24 | 34 | 58 | ||||||||||||||||||||||||||||||||
1672783 | 1672783 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000272 | 350182 | Boston - Joseph J Hurley | Regular School | No | Elementary | PK | 08 | 2021 | grade_8 | 0 | 1 | 19 | 0 | 0 | 0 | 0 | 13 | 7 | * | 20.0 | 0 | 1 | 19 | 0 | 0 | 0 | 0 | 13 | 7 | 20 | ||||||||||||||||||||||||||||||||
1673284 | 1673284 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002374 | 350750 | Boston - Horace Mann School for the Deaf | Special Education School | No | Other | 01 | 12 | 2021 | grade_8 | 0 | 3 | 6 | 0 | 0 | 0 | 0 | 7 | 2 | * | 9.0 | 0 | 3 | 6 | 0 | 0 | 0 | 0 | 7 | 2 | 9 | ||||||||||||||||||||||||||||||||
1678285 | 1678285 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002744 | 2810360 | Springfield - Balliet Middle School | Regular School | No | Middle | 06 | 08 | 2021 | grade_8 | 0 | 4 | 6 | 0 | 0 | 0 | 0 | 8 | * | * | 10.0 | 0 | 4 | 6 | 0 | 0 | 0 | 0 | 8 | 10 | |||||||||||||||||||||||||||||||||
1679768 | 1679768 | MA | Suffolk | school | 2500527 | 417 | Bridge Boston Charter School (District) | 250052702710 | 4170205 | Bridge Boston Charter School (District) - Bridge Boston Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_8 | 0 | 12 | 5 | 0 | 0 | 0 | 3 | 11 | 9 | * | 20.0 | 0 | 12 | 5 | 0 | 0 | 0 | 3 | 11 | 9 | 20 | ||||||||||||||||||||||||||||||||
1679774 | 1679774 | MA | Suffolk | school | 2500077 | 419 | Helen Y. Davis Leadership Academy Charter Public (District) | 250007702091 | 4190305 | Helen Y. Davis Leadership Academy Charter Public (District) - Helen Y. Davis Leadership Academy Charter Public School | Regular School | Yes | Middle | 06 | 08 | 2021 | grade_8 | 0 | 61 | 19 | 0 | 0 | 0 | 0 | 44 | 36 | * | 80.0 | 0 | 61 | 19 | 0 | 0 | 0 | 0 | 44 | 36 | 80 | ||||||||||||||||||||||||||||||||
1679796 | 1679796 | MA | Essex | school | 2500538 | 426 | Community Day Charter Public School - Gateway (District) | 250053802717 | 4260205 | Community Day Charter Public School - Gateway (District) - Community Day Charter Public School - Gateway | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_8 | 0 | 0 | 38 | 0 | 0 | 0 | 0 | 20 | 18 | * | 38.0 | 0 | 0 | 38 | 0 | 0 | 0 | 0 | 20 | 18 | 38 | ||||||||||||||||||||||||||||||||
1679871 | 1679871 | MA | Suffolk | school | 2500070 | 438 | Codman Academy Charter Public (District) | 250007001667 | 4380505 | Codman Academy Charter Public (District) - Codman Academy Charter Public School | Regular School | Yes | Other | PK | 12 | 2021 | grade_8 | 0 | 19 | 2 | 0 | 0 | 0 | 0 | 9 | 12 | * | 21.0 | 0 | 19 | 2 | 0 | 0 | 0 | 0 | 9 | 12 | 21 | ||||||||||||||||||||||||||||||||
1679885 | 1679885 | MA | Suffolk | school | 2500060 | 439 | Conservatory Lab Charter (District) | 250006001439 | 4390050 | Conservatory Lab Charter (District) - Conservatory Lab Charter School | Regular School | Yes | Elementary | PK | 08 | 2021 | grade_8 | 0 | 17 | 12 | 0 | 0 | 0 | 1 | 16 | 14 | * | 30.0 | 0 | 17 | 12 | 0 | 0 | 0 | 1 | 16 | 14 | 30 | ||||||||||||||||||||||||||||||||
1680029 | 1680029 | MA | Suffolk | school | 2500537 | 463 | KIPP Academy Boston Charter School (District) | 250053702716 | 4630205 | KIPP Academy Boston Charter School (District) - KIPP Academy Boston Charter School | Regular School | Yes | Elementary | KG | 08 | 2021 | grade_8 | 0 | 33 | 26 | 0 | 0 | 0 | 0 | 37 | 22 | * | 59.0 | 0 | 33 | 26 | 0 | 0 | 0 | 0 | 37 | 22 | 59 | ||||||||||||||||||||||||||||||||
2040430 | 2040430 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000222 | 350074 | Dearborn | Regular School | No | High | 06 | 12 | 2019 | grade_8 | 0 | 42 | 17 | 0 | 0 | 0 | 2 | 32 | 29 | 61.0 | 0 | 42 | 17 | 0 | 0 | 0 | 2 | 32 | 29 | 61 | |||||||||||||||||||||||||||||||||
2040597 | 2040597 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000272 | 350182 | Joseph J Hurley | Regular School | No | Elementary | PK | 08 | 2019 | grade_8 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 6 | 10 | 16.0 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 6 | 10 | 16 | |||||||||||||||||||||||||||||||||
2040655 | 2040655 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000291 | 350229 | Maurice J Tobin | Regular School | No | Elementary | PK | 08 | 2019 | grade_8 | 0 | 6 | 20 | 0 | 0 | 0 | 0 | 11 | 15 | 26.0 | 0 | 6 | 20 | 0 | 0 | 0 | 0 | 11 | 15 | 26 | |||||||||||||||||||||||||||||||||
2040784 | 2040784 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Sarah Greenwood | Regular School | No | Elementary | PK | 08 | 2019 | grade_8 | 0 | 6 | 18 | 0 | 0 | 0 | 1 | 13 | 12 | 25.0 | 0 | 6 | 18 | 0 | 0 | 0 | 1 | 13 | 12 | 25 | |||||||||||||||||||||||||||||||||
2040874 | 2040874 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002669 | 350376 | King K-8 | Regular School | No | Elementary | PK | 08 | 2019 | grade_8 | 0 | 16 | 10 | 0 | 0 | 0 | 0 | 16 | 10 | 26.0 | 0 | 16 | 10 | 0 | 0 | 0 | 0 | 16 | 10 | 26 | |||||||||||||||||||||||||||||||||
2040901 | 2040901 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000693 | 350380 | Young Achievers | Alternative School | No | Elementary | PK | 08 | 2019 | grade_8 | 0 | 22 | 11 | 0 | 0 | 0 | 0 | 23 | 10 | 33.0 | 0 | 22 | 11 | 0 | 0 | 0 | 0 | 23 | 10 | 33 | |||||||||||||||||||||||||||||||||
2040914 | 2040914 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002013 | 350383 | Lilla G. Frederick Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 0 | 74 | 72 | 0 | 16 | 1 | 4 | 99 | 68 | 167.0 | 0 | 74 | 72 | 0 | 16 | 1 | 4 | 99 | 68 | 167 | |||||||||||||||||||||||||||||||||
2041094 | 2041094 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000312 | 350691 | Rafael Hernandez | Regular School | No | Elementary | PK | 08 | 2019 | grade_8 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 9 | 13 | 22.0 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 9 | 13 | 22 | |||||||||||||||||||||||||||||||||
2041101 | 2041101 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002374 | 350750 | Horace Mann School for the Deaf | Special Education School | No | Other | PK | 12 | 2019 | grade_8 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 2 | 4 | 6.0 | 0 | 3 | 3 | 0 | 0 | 0 | 0 | 2 | 4 | 6 | |||||||||||||||||||||||||||||||||
2041275 | 2041275 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000966 | 440080 | Frederick Douglass Academy | Regular School | No | Secondary | 07 | 11 | 2019 | grade_8 | 0 | 1 | 3 | 1 | 0 | 0 | 1 | 4 | * | 6.0 | 0 | 1 | 3 | 1 | 0 | 0 | 1 | 4 | 6 | ||||||||||||||||||||||||||||||||||
2046088 | 2046088 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002740 | 2810345 | Springfield Public Day Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 0 | 6 | 11 | 0 | 0 | 0 | 0 | 15 | 2 | 17.0 | 0 | 6 | 11 | 0 | 0 | 0 | 0 | 15 | 2 | 17 | |||||||||||||||||||||||||||||||||
2046096 | 2046096 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002744 | 2810360 | Balliet Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 0 | 3 | 17 | 0 | 0 | 0 | 2 | 11 | 11 | 22.0 | 0 | 3 | 17 | 0 | 0 | 0 | 2 | 11 | 11 | 22 | |||||||||||||||||||||||||||||||||
2046099 | 2046099 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002830 | 2810365 | Chestnut Academy | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 0 | 7 | 78 | 0 | 0 | 0 | 0 | 43 | 42 | 85.0 | 0 | 7 | 78 | 0 | 0 | 0 | 0 | 43 | 42 | 85 | |||||||||||||||||||||||||||||||||
2047564 | 2047564 | MA | Suffolk | school | 2500080 | 416 | Boston Preparatory Charter Public (District) | 250008001843 | 4160305 | Boston Preparatory Charter Public School | Regular School | Yes | High | 06 | 12 | 2019 | grade_8 | 0 | 42 | 14 | 0 | 2 | 1 | 3 | 27 | 35 | 62.0 | 0 | 42 | 14 | 0 | 2 | 1 | 3 | 27 | 35 | 62 | |||||||||||||||||||||||||||||||||
2047583 | 2047583 | MA | Suffolk | school | 2500077 | 419 | Helen Y. Davis Leadership Academy Charter Public (District) | 250007702091 | 4190305 | Helen Y. Davis Leadership Academy Charter Public School | Regular School | Yes | Middle | 06 | 08 | 2019 | grade_8 | 0 | 39 | 17 | 1 | 1 | 1 | 0 | 31 | 28 | 59.0 | 0 | 39 | 17 | 1 | 1 | 1 | 0 | 31 | 28 | 59 | |||||||||||||||||||||||||||||||||
2047680 | 2047680 | MA | Suffolk | school | 2500070 | 438 | Codman Academy Charter Public (District) | 250007001667 | 4380505 | Codman Academy Charter Public School | Regular School | Yes | Other | PK | 12 | 2019 | grade_8 | 0 | 17 | 1 | 0 | 0 | 0 | 0 | 10 | 8 | 18.0 | 0 | 17 | 1 | 0 | 0 | 0 | 0 | 10 | 8 | 18 | |||||||||||||||||||||||||||||||||
2047804 | 2047804 | MA | Essex | school | 2500032 | 454 | Lawrence Family Development Charter (District) | 250003200553 | 4540205 | Lawrence Family Development Charter School | Regular School | Yes | Elementary | PK | 08 | 2019 | grade_8 | 0 | 0 | 49 | 0 | 0 | 0 | 0 | 20 | 29 | 49.0 | 0 | 0 | 49 | 0 | 0 | 0 | 0 | 20 | 29 | 49 | |||||||||||||||||||||||||||||||||
2047836 | 2047836 | MA | Suffolk | school | 2500537 | 463 | KIPP Academy Boston Charter School (District) | 250053702716 | 4630205 | KIPP Academy Boston Charter School | Regular School | Yes | Elementary | KG | 08 | 2019 | grade_8 | 0 | 37 | 26 | 0 | 1 | 0 | 1 | 35 | 30 | 65.0 | 0 | 37 | 26 | 0 | 1 | 0 | 1 | 35 | 30 | 65 | |||||||||||||||||||||||||||||||||
2047866 | 2047866 | MA | Suffolk | school | 2500066 | 469 | MATCH Charter Public School (District) | 250006601586 | 4690505 | MATCH Charter Public School | Regular School | Yes | Other | PK | 12 | 2019 | grade_8 | 0 | 42 | 50 | 0 | 1 | 0 | 2 | 50 | 45 | 95.0 | 0 | 42 | 50 | 0 | 1 | 0 | 2 | 50 | 45 | 95 | |||||||||||||||||||||||||||||||||
2049294 | 2049294 | MA | Suffolk | school | 2500549 | 3505 | UP Academy Charter School of Dorchester (District) | 250054902783 | 35050405 | UP Academy Charter School of Dorchester | Regular School | Yes | Elementary | PK | 08 | 2019 | grade_8 | 0 | 33 | 23 | 0 | 1 | 0 | 1 | 27 | 31 | 58.0 | 0 | 33 | 23 | 0 | 1 | 0 | 1 | 27 | 31 | 58 | |||||||||||||||||||||||||||||||||
2229617 | 2229617 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000259 | 350153 | Boston: James W Hennigan | Regular School | No | Elementary | KG | 08 | 2018 | grade_8 | 0 | 12 | 34 | 0 | 0 | 0 | 0 | 24 | 22 | 46.0 | 0 | 12 | 34 | 0 | 0 | 0 | 0 | 24 | 22 | 46 | |||||||||||||||||||||||||||||||||
2229688 | 2229688 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000272 | 350182 | Boston: Joseph J Hurley | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 7 | 9 | 16.0 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 7 | 9 | 16 | |||||||||||||||||||||||||||||||||
2229753 | 2229753 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000291 | 350229 | Boston: Maurice J Tobin | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 0 | 8 | 18 | 0 | 0 | 0 | 1 | 12 | 15 | 27.0 | 0 | 8 | 18 | 0 | 0 | 0 | 1 | 12 | 15 | 27 | |||||||||||||||||||||||||||||||||
2229808 | 2229808 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002006 | 350257 | Boston: Orchard Gardens | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 0 | 40 | 39 | 1 | 0 | 0 | 4 | 41 | 43 | 84.0 | 0 | 40 | 39 | 1 | 0 | 0 | 4 | 41 | 43 | 84 | |||||||||||||||||||||||||||||||||
2229897 | 2229897 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Boston: Sarah Greenwood | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 0 | 10 | 12 | 0 | 0 | 0 | 0 | 9 | 13 | 22.0 | 0 | 10 | 12 | 0 | 0 | 0 | 0 | 9 | 13 | 22 | |||||||||||||||||||||||||||||||||
2229966 | 2229966 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000343 | 350370 | Boston: William Monroe Trotter | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 0 | 13 | 9 | 0 | 0 | 0 | 1 | 11 | 12 | 23.0 | 0 | 13 | 9 | 0 | 0 | 0 | 1 | 11 | 12 | 23 | |||||||||||||||||||||||||||||||||
2230004 | 2230004 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Boston: Higginson/Lewis K-8 | Regular School | No | Elementary | 01 | 08 | 2018 | grade_8 | 0 | 15 | 18 | 0 | 0 | 0 | 2 | 18 | 17 | 35.0 | 0 | 15 | 18 | 0 | 0 | 0 | 2 | 18 | 17 | 35 | |||||||||||||||||||||||||||||||||
2230174 | 2230174 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001296 | 350565 | Boston: Quincy Upper School | Regular School | No | High | 06 | 12 | 2018 | grade_8 | 0 | 12 | 14 | 1 | 40 | 0 | 1 | 35 | 33 | 68.0 | 0 | 12 | 14 | 1 | 40 | 0 | 1 | 35 | 33 | 68 | |||||||||||||||||||||||||||||||||
2232380 | 2232380 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000910 | 1370025 | Holyoke: Morgan Full Service Community School | Regular School | No | Elementary | PK | 08 | 2018 | grade_8 | 0 | 1 | 34 | 0 | 1 | 0 | 1 | 15 | 22 | 37.0 | 0 | 1 | 34 | 0 | 1 | 0 | 1 | 15 | 22 | 37 | |||||||||||||||||||||||||||||||||
2237978 | 2237978 | MA | Suffolk | school | 2500080 | 416 | Boston Preparatory Charter Public (District) | 250008001843 | 4160305 | Boston Preparatory Charter Public (District): Boston Preparatory Charter Public School | Regular School | Yes | High | 06 | 12 | 2018 | grade_8 | 0 | 40 | 20 | 0 | 1 | 0 | 0 | 31 | 30 | 61.0 | 0 | 40 | 20 | 0 | 1 | 0 | 0 | 31 | 30 | 61 | |||||||||||||||||||||||||||||||||
2237999 | 2237999 | MA | Suffolk | school | 2500077 | 419 | Helen Y. Davis Leadership Academy Charter Public (District) | 250007702091 | 4190305 | Helen Y. Davis Leadership Academy Charter Public (District): Helen Y. Davis Leadership Academy Charter Public School | Regular School | Yes | Middle | 06 | 08 | 2018 | grade_8 | 0 | 71 | 10 | 0 | 0 | 0 | 0 | 45 | 36 | 81.0 | 0 | 71 | 10 | 0 | 0 | 0 | 0 | 45 | 36 | 81 | |||||||||||||||||||||||||||||||||
2238104 | 2238104 | MA | Suffolk | school | 2500070 | 438 | Codman Academy Charter Public (District) | 250007001667 | 4380505 | Codman Academy Charter Public (District): Codman Academy Charter Public School | Regular School | Yes | Other | PK | 12 | 2018 | grade_8 | 0 | 15 | 4 | 0 | 0 | 0 | 1 | 10 | 10 | 20.0 | 0 | 15 | 4 | 0 | 0 | 0 | 1 | 10 | 10 | 20 | |||||||||||||||||||||||||||||||||
2238239 | 2238239 | MA | Essex | school | 2500032 | 454 | Lawrence Family Development Charter (District) | 250003200553 | 4540205 | Lawrence Family Development Charter (District): Lawrence Family Development Charter School | Regular School | Yes | Elementary | PK | 08 | 2018 | grade_8 | 0 | 1 | 47 | 0 | 0 | 0 | 0 | 17 | 31 | 48.0 | 0 | 1 | 47 | 0 | 0 | 0 | 0 | 17 | 31 | 48 | |||||||||||||||||||||||||||||||||
2238274 | 2238274 | MA | Suffolk | school | 2500537 | 463 | KIPP Academy Boston Charter School (District) | 250053702716 | 4630205 | KIPP Academy Boston Charter School (District): KIPP Academy Boston Charter School | Regular School | Yes | Elementary | KG | 08 | 2018 | grade_8 | 0 | 42 | 25 | 0 | 0 | 0 | 1 | 33 | 35 | 68.0 | 0 | 42 | 25 | 0 | 0 | 0 | 1 | 33 | 35 | 68 | |||||||||||||||||||||||||||||||||
2239962 | 2239962 | MA | Suffolk | school | 2500549 | 3505 | UP Academy Charter School of Dorchester (District) | 250054902783 | 35050405 | UP Academy Charter School of Dorchester (District): UP Academy Charter School of Dorchester | Regular School | Yes | Elementary | PK | 08 | 2018 | grade_8 | 0 | 41 | 21 | 1 | 0 | 0 | 0 | 25 | 38 | 63.0 | 0 | 41 | 21 | 1 | 0 | 0 | 0 | 25 | 38 | 63 | |||||||||||||||||||||||||||||||||
736232 | 736232 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002622 | 350020 | Curley K-8 School | Regular School | No | 1 | PK | 08 | 2015 | grade_8 | 1 | 31 | 78 | 1 | 1 | 0 | 2 | 62 | 52 | 114 | 1 | 31 | 78 | 1 | 1 | 0 | 2 | 62 | 52 | 114 | |||||||||||||||||||||||||||||||||
736279 | 736279 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000222 | 350074 | Dearborn | Regular School | No | 4 | 06 | 10 | 2015 | grade_8 | 1 | 43 | 24 | 0 | 0 | 0 | 2 | 33 | 37 | 70 | 1 | 43 | 24 | 0 | 0 | 0 | 2 | 33 | 37 | 70 | |||||||||||||||||||||||||||||||||
736452 | 736452 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000273 | 350183 | Joseph Lee | Regular School | No | 1 | PK | 08 | 2015 | grade_8 | 1 | 50 | 9 | 0 | 3 | 0 | 0 | 40 | 23 | 63 | 1 | 50 | 9 | 0 | 3 | 0 | 0 | 40 | 23 | 63 | |||||||||||||||||||||||||||||||||
736638 | 736638 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Sarah Greenwood | Regular School | No | 1 | PK | 08 | 2015 | grade_8 | 1 | 10 | 18 | 0 | 0 | 0 | 1 | 14 | 16 | 30 | 1 | 10 | 18 | 0 | 0 | 0 | 1 | 14 | 16 | 30 | |||||||||||||||||||||||||||||||||
736736 | 736736 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Higginson/Lewis K-8 | Regular School | No | 1 | PK | 08 | 2015 | grade_8 | 1 | 15 | 11 | 0 | 0 | 0 | 2 | 13 | 16 | 29 | 1 | 15 | 11 | 0 | 0 | 0 | 2 | 13 | 16 | 29 | |||||||||||||||||||||||||||||||||
736742 | 736742 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002670 | 350378 | Mildred Avenue K-8 | Regular School | No | 2 | 04 | 08 | 2015 | grade_8 | 1 | 76 | 25 | 1 | 2 | 0 | 1 | 68 | 38 | 106 | 1 | 76 | 25 | 1 | 2 | 0 | 1 | 68 | 38 | 106 | |||||||||||||||||||||||||||||||||
736752 | 736752 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000693 | 350380 | Young Achievers | Alternative Education School | No | 1 | PK | 08 | 2015 | grade_8 | 1 | 25 | 23 | 1 | 2 | 0 | 1 | 24 | 29 | 53 | 1 | 25 | 23 | 1 | 2 | 0 | 1 | 24 | 29 | 53 | |||||||||||||||||||||||||||||||||
736762 | 736762 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000946 | 350382 | Mission Hill School | Regular School | No | 1 | PK | 08 | 2015 | grade_8 | 1 | 10 | 10 | 0 | 0 | 0 | 0 | 12 | 9 | 21 | 1 | 10 | 10 | 0 | 0 | 0 | 0 | 12 | 9 | 21 | |||||||||||||||||||||||||||||||||
736959 | 736959 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002374 | 350750 | Horace Mann School for the Deaf | Special Education School | No | 4 | PK | 12 | 2015 | grade_8 | 1 | 2 | 3 | 0 | 1 | 0 | 0 | 2 | 5 | 7 | 1 | 2 | 3 | 0 | 1 | 0 | 0 | 2 | 5 | 7 | |||||||||||||||||||||||||||||||||
738727 | 738727 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627000910 | 1370025 | Morgan Full Service Community School | Regular School | No | 1 | PK | 08 | 2015 | grade_8 | 1 | 1 | 30 | 0 | 0 | 0 | 1 | 21 | 12 | 33 | 1 | 1 | 30 | 0 | 0 | 0 | 1 | 21 | 12 | 33 | |||||||||||||||||||||||||||||||||
739016 | 739016 | MA | Essex | school | 2506660 | 149 | Lawrence | 250666002625 | 1490537 | School for Exceptional Studies | Regular School | No | 4 | 01 | 12 | 2015 | grade_8 | 1 | 0 | 18 | 0 | 0 | 0 | 0 | 17 | 2 | 19 | 1 | 0 | 18 | 0 | 0 | 0 | 0 | 17 | 2 | 19 | |||||||||||||||||||||||||||||||||
739339 | 739339 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702002732 | 1600320 | Leblanc Therapeutic Day School | Regular School | No | 3 | 08 | 12 | 2015 | grade_8 | 1 | 1 | 5 | 0 | 0 | 0 | 0 | 7 | * | 7 | 1 | 1 | 5 | 0 | 0 | 0 | 0 | 7 | 7 | ||||||||||||||||||||||||||||||||||
741973 | 741973 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002740 | 2810345 | Springfield Public Day Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_8 | 1 | 5 | 19 | 0 | 0 | 0 | 0 | 19 | 6 | 25 | 1 | 5 | 19 | 0 | 0 | 0 | 0 | 19 | 6 | 25 | |||||||||||||||||||||||||||||||||
743559 | 743559 | MA | Suffolk | school | 2500060 | 439 | Conservatory Lab Charter (District) | 250006001439 | 4390050 | Conservatory Lab Charter School | Regular School | Yes | 1 | PK | 08 | 2015 | grade_8 | 1 | 8 | 2 | 0 | 1 | 0 | 0 | 5 | 7 | 12 | 1 | 8 | 2 | 0 | 1 | 0 | 0 | 5 | 7 | 12 | |||||||||||||||||||||||||||||||||
743601 | 743601 | MA | Suffolk | school | 2500029 | 444 | Neighborhood House Charter (District) | 250002900545 | 4440205 | Neighborhood House Charter School | Regular School | Yes | 1 | PK | 08 | 2015 | grade_8 | 1 | 18 | 7 | 1 | 3 | 0 | 1 | 17 | 14 | 31 | 1 | 18 | 7 | 1 | 3 | 0 | 1 | 17 | 14 | 31 | |||||||||||||||||||||||||||||||||
933075 | 933075 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002687 | 350012 | Boston Teachers Union School | Regular School | No | 1 | PK | 08 | 2016 | grade_8 | 1 | 20 | 29 | 0 | 1 | 1 | 2 | 22 | 32 | 54 | 1 | 20 | 29 | 0 | 1 | 1 | 2 | 22 | 32 | 54 | |||||||||||||||||||||||||||||||||
933149 | 933149 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000222 | 350074 | Dearborn | Regular School | No | 4 | 06 | 11 | 2016 | grade_8 | 1 | 32 | 10 | 0 | 0 | 0 | 3 | 24 | 22 | 46 | 1 | 32 | 10 | 0 | 0 | 0 | 3 | 24 | 22 | 46 | |||||||||||||||||||||||||||||||||
933171 | 933171 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000224 | 350080 | Donald Mckay | Regular School | No | 1 | KG | 08 | 2016 | grade_8 | 1 | 3 | 54 | 0 | 0 | 0 | 0 | 31 | 27 | 58 | 1 | 3 | 54 | 0 | 0 | 0 | 0 | 31 | 27 | 58 | |||||||||||||||||||||||||||||||||
933311 | 933311 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000272 | 350182 | Joseph J Hurley | Regular School | No | 1 | PK | 08 | 2016 | grade_8 | 1 | 0 | 16 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | 1 | 0 | 16 | 0 | 0 | 0 | 0 | 10 | 7 | 17 | |||||||||||||||||||||||||||||||||
933321 | 933321 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000273 | 350183 | Joseph Lee | Regular School | No | 1 | PK | 08 | 2016 | grade_8 | 1 | 42 | 16 | 0 | 2 | 0 | 4 | 42 | 23 | 65 | 1 | 42 | 16 | 0 | 2 | 0 | 4 | 42 | 23 | 65 | |||||||||||||||||||||||||||||||||
933426 | 933426 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002006 | 350257 | Orchard Gardens | Regular School | No | 1 | PK | 08 | 2016 | grade_8 | 1 | 32 | 46 | 0 | 1 | 1 | 2 | 30 | 53 | 83 | 1 | 32 | 46 | 0 | 1 | 1 | 2 | 30 | 53 | 83 | |||||||||||||||||||||||||||||||||
933506 | 933506 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Sarah Greenwood | Regular School | No | 1 | PK | 08 | 2016 | grade_8 | 1 | 9 | 15 | 1 | 0 | 0 | 0 | 18 | 8 | 26 | 1 | 9 | 15 | 1 | 0 | 0 | 0 | 18 | 8 | 26 | |||||||||||||||||||||||||||||||||
933594 | 933594 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002669 | 350376 | King K-8 | Regular School | No | 1 | PK | 08 | 2016 | grade_8 | 1 | 13 | 7 | 0 | 0 | 0 | 2 | 10 | 13 | 23 | 1 | 13 | 7 | 0 | 0 | 0 | 2 | 10 | 13 | 23 | |||||||||||||||||||||||||||||||||
933603 | 933603 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Higginson/Lewis K-8 | Regular School | No | 1 | PK | 08 | 2016 | grade_8 | 1 | 20 | 8 | 1 | 0 | 0 | 0 | 16 | 14 | 30 | 1 | 20 | 8 | 1 | 0 | 0 | 0 | 16 | 14 | 30 | |||||||||||||||||||||||||||||||||
933992 | 933992 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309000966 | 440080 | B B Russell Alternative School | Regular School | No | 4 | 06 | 12 | 2016 | grade_8 | 1 | 5 | 1 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | 1 | 5 | 1 | 0 | 0 | 0 | 0 | 5 | 2 | 7 | |||||||||||||||||||||||||||||||||
934002 | 934002 | MA | Plymouth | school | 2503090 | 44 | Brockton | 250309002544 | 440400 | Goddard Alternative School | Alternative Education School | No | 4 | 04 | 12 | 2016 | grade_8 | 1 | 5 | 1 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | 1 | 5 | 1 | 0 | 0 | 0 | 0 | 6 | 1 | 7 | |||||||||||||||||||||||||||||||||
936186 | 936186 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702002732 | 1600320 | Leblanc Therapeutic Day School | Regular School | No | 3 | 08 | 12 | 2016 | grade_8 | 1 | 1 | 4 | 0 | 1 | 0 | 0 | 6 | 1 | 7 | 1 | 1 | 4 | 0 | 1 | 0 | 0 | 6 | 1 | 7 | |||||||||||||||||||||||||||||||||
938787 | 938787 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113002744 | 2810360 | Balliet Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_8 | 1 | 9 | 15 | 0 | 0 | 0 | 0 | 15 | 10 | 25 | 1 | 9 | 15 | 0 | 0 | 0 | 0 | 15 | 10 | 25 | |||||||||||||||||||||||||||||||||
940352 | 940352 | MA | Middlesex | school | 2500086 | 436 | Community Charter School of Cambridge (District) | 250008601996 | 4360305 | Community Charter School of Cambridge | Regular School | Yes | 4 | 06 | 12 | 2016 | grade_8 | 1 | 44 | 17 | 1 | 2 | 1 | 5 | 30 | 41 | 71 | 1 | 44 | 17 | 1 | 2 | 1 | 5 | 30 | 41 | 71 | |||||||||||||||||||||||||||||||||
940746 | 940746 | MA | Hampden | school | 2500536 | 498 | Veritas Preparatory Charter School (District) | 250053602714 | 4980405 | Veritas Preparatory Charter School | Regular School | Yes | 2 | 05 | 08 | 2016 | grade_8 | 1 | 14 | 41 | 0 | 1 | 0 | 5 | 31 | 31 | 62 | 1 | 14 | 41 | 0 | 1 | 0 | 5 | 31 | 31 | 62 | |||||||||||||||||||||||||||||||||
1122687 | 1122687 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000222 | 350074 | Dearborn | Regular School | No | Other | 06 | 12 | 2017 | grade_8 | 1 | 33 | 17 | 0 | 0 | 0 | 2 | 28 | 25 | 53 | 1 | 33 | 17 | 0 | 0 | 0 | 2 | 28 | 25 | 53 | |||||||||||||||||||||||||||||||||
1123093 | 1123093 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Sarah Greenwood | Regular School | No | Elementary | PK | 08 | 2017 | grade_8 | 1 | 9 | 24 | 0 | 0 | 0 | 0 | 16 | 18 | 34 | 1 | 9 | 24 | 0 | 0 | 0 | 0 | 16 | 18 | 34 | |||||||||||||||||||||||||||||||||
1123139 | 1123139 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000342 | 350363 | William McKinley | Regular School | No | Other | 01 | 12 | 2017 | grade_8 | 1 | 17 | 15 | 0 | 0 | 0 | 0 | 23 | 10 | 33 | 1 | 17 | 15 | 0 | 0 | 0 | 0 | 23 | 10 | 33 | |||||||||||||||||||||||||||||||||
1123162 | 1123162 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000343 | 350370 | William Monroe Trotter | Regular School | No | Elementary | PK | 08 | 2017 | grade_8 | 1 | 19 | 6 | 0 | 0 | 0 | 0 | 9 | 17 | 26 | 1 | 19 | 6 | 0 | 0 | 0 | 0 | 9 | 17 | 26 |
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]);