enrollments
Data source: Big Local News · About: Big Local
3,471 rows where grade = "grade_7" and state = "MA" sorted by female_int
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
933515 | 933515 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000331 | 350326 | Gardner Pilot Academy | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 7 | 5 | 20 | 0 | 1 | 0 | 1 | 24 | 10 | 34 | 7 | 5 | 20 | 0 | 1 | 0 | 1 | 24 | 10 | 34 | |||||||||||||||||||||||||||||||||
935412 | 935412 | MA | Hampshire | school | 2505940 | 127 | Hatfield | 250594000845 | 1270505 | Smith Academy | Regular School | No | 3 | 07 | 12 | 2016 | grade_7 | 35 | 0 | 1 | 0 | 0 | 0 | 0 | 26 | 10 | 36 | 35 | 0 | 1 | 0 | 0 | 0 | 0 | 26 | 10 | 36 | |||||||||||||||||||||||||||||||||
937286 | 937286 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001390 | 2090035 | Brayton | Regular School | No | 1 | PK | 07 | 2016 | grade_7 | 26 | 1 | 1 | 0 | 0 | 0 | 3 | 21 | 10 | 31 | 26 | 1 | 1 | 0 | 0 | 0 | 3 | 21 | 10 | 31 | |||||||||||||||||||||||||||||||||
1122597 | 1122597 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002687 | 350012 | Boston Teachers Union School | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 1 | 10 | 20 | 0 | 1 | 0 | 3 | 25 | 10 | 35 | 1 | 10 | 20 | 0 | 1 | 0 | 3 | 25 | 10 | 35 | |||||||||||||||||||||||||||||||||
1122903 | 1122903 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000278 | 350190 | Joyce Kilmer | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 7 | 8 | 7 | 0 | 0 | 0 | 0 | 12 | 10 | 22 | 7 | 8 | 7 | 0 | 0 | 0 | 0 | 12 | 10 | 22 | |||||||||||||||||||||||||||||||||
1131298 | 1131298 | MA | Essex | school | 2500027 | 440 | Community Day Charter Public School - Prospect (District) | 250002700535 | 4400205 | Community Day Charter Public School - Prospect | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 2 | 0 | 19 | 0 | 1 | 0 | 0 | 12 | 10 | 22 | 2 | 0 | 19 | 0 | 1 | 0 | 0 | 12 | 10 | 22 | |||||||||||||||||||||||||||||||||
1366689 | 1366689 | MA | Berkshire | school | 2503720 | 63 | Clarksburg | 250372000510 | 630010 | Clarksburg Elementary | Regular School | No | Elementary | KG | 08 | 2020 | grade_7 | 20 | 0 | 0 | 0 | 0 | 0 | 2 | 12 | 10 | * | 22.0 | 20 | 0 | 0 | 0 | 0 | 0 | 2 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||
1370332 | 1370332 | MA | Berkshire | school | 2510080 | 249 | Richmond | 251008001635 | 2490005 | Richmond Consolidated | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 16 | 1 | 2 | 0 | 0 | 0 | 0 | 9 | 10 | * | 19.0 | 16 | 1 | 2 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||
1372607 | 1372607 | 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_7 | 0 | 18 | 1 | 0 | 0 | 0 | 0 | 9 | 10 | * | 19.0 | 0 | 18 | 1 | 0 | 0 | 0 | 0 | 9 | 10 | 19 | ||||||||||||||||||||||||||||||||
1373455 | 1373455 | MA | Hampden | school | 2505730 | 680 | Hampden-Wilbraham | 250573000822 | 6800005 | Green Meadows Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 10 | 1 | 4 | 0 | 0 | 0 | 0 | 5 | 10 | * | 15.0 | 10 | 1 | 4 | 0 | 0 | 0 | 0 | 5 | 10 | 15 | ||||||||||||||||||||||||||||||||
1679870 | 1679870 | 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_7 | 0 | 18 | 4 | 0 | 0 | 0 | 0 | 12 | 10 | * | 22.0 | 0 | 18 | 4 | 0 | 0 | 0 | 0 | 12 | 10 | 22 | ||||||||||||||||||||||||||||||||
1680042 | 1680042 | MA | Dukes | school | 2500035 | 466 | Martha's Vineyard Charter (District) | 250003500569 | 4660550 | Martha's Vineyard Charter (District) - Martha's Vineyard Charter School | Regular School | Yes | Other | KG | 12 | 2021 | grade_7 | 11 | 0 | 2 | 0 | 0 | 0 | 1 | 4 | 10 | * | 14.0 | 11 | 0 | 2 | 0 | 0 | 0 | 1 | 4 | 10 | 14 | ||||||||||||||||||||||||||||||||
2040348 | 2040348 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002687 | 350012 | Boston Teachers Union School | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 1 | 8 | 8 | 0 | 0 | 0 | 1 | 8 | 10 | 18.0 | 1 | 8 | 8 | 0 | 0 | 0 | 1 | 8 | 10 | 18 | |||||||||||||||||||||||||||||||||
2042278 | 2042278 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002873 | 950525 | Resiliency Preparatory Academy | Alternative School | No | High | 07 | 12 | 2019 | grade_7 | 9 | 1 | 5 | 0 | 0 | 0 | 2 | 7 | 10 | 17.0 | 9 | 1 | 5 | 0 | 0 | 0 | 2 | 7 | 10 | 17 | |||||||||||||||||||||||||||||||||
2047679 | 2047679 | 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_7 | 0 | 15 | 3 | 0 | 0 | 0 | 0 | 8 | 10 | 18.0 | 0 | 15 | 3 | 0 | 0 | 0 | 0 | 8 | 10 | 18 | |||||||||||||||||||||||||||||||||
2048518 | 2048518 | MA | Hampden | school | 2505730 | 680 | Hampden-Wilbraham | 250573000822 | 6800005 | Green Meadows Elementary | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 14 | 1 | 2 | 0 | 0 | 0 | 1 | 8 | 10 | 18.0 | 14 | 1 | 2 | 0 | 0 | 0 | 1 | 8 | 10 | 18 | |||||||||||||||||||||||||||||||||
736468 | 736468 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000278 | 350190 | Joyce Kilmer | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 8 | 4 | 8 | 0 | 1 | 0 | 0 | 10 | 11 | 21 | 8 | 4 | 8 | 0 | 1 | 0 | 0 | 10 | 11 | 21 | |||||||||||||||||||||||||||||||||
736664 | 736664 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000333 | 350346 | Warren-Prescott | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 7 | 6 | 8 | 0 | 0 | 0 | 0 | 10 | 11 | 21 | 7 | 6 | 8 | 0 | 0 | 0 | 0 | 10 | 11 | 21 | |||||||||||||||||||||||||||||||||
736725 | 736725 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002669 | 350376 | King K-8 | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 1 | 14 | 7 | 0 | 0 | 0 | 1 | 12 | 11 | 23 | 1 | 14 | 7 | 0 | 0 | 0 | 1 | 12 | 11 | 23 | |||||||||||||||||||||||||||||||||
743907 | 743907 | MA | Hampshire | school | 2500517 | 497 | Pioneer Valley Chinese Immersion Charter(District) | 250051702619 | 4970205 | Pioneer Valley Chinese Immersion Charter School | Regular School | Yes | 4 | KG | 10 | 2015 | grade_7 | 6 | 1 | 0 | 0 | 7 | 0 | 1 | 4 | 11 | 15 | 6 | 1 | 0 | 0 | 7 | 0 | 1 | 4 | 11 | 15 | |||||||||||||||||||||||||||||||||
934467 | 934467 | MA | Berkshire | school | 2503720 | 63 | Clarksburg | 250372000510 | 630010 | Clarksburg Elementary | Regular School | No | 1 | KG | 08 | 2016 | grade_7 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 11 | 16 | 16 | 0 | 0 | 0 | 0 | 0 | 0 | 5 | 11 | 16 | |||||||||||||||||||||||||||||||||
1123161 | 1123161 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000343 | 350370 | William Monroe Trotter | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 0 | 15 | 11 | 0 | 0 | 1 | 1 | 17 | 11 | 28 | 0 | 15 | 11 | 0 | 0 | 1 | 1 | 17 | 11 | 28 | |||||||||||||||||||||||||||||||||
1124604 | 1124604 | MA | Dukes | school | 2509090 | 89 | Edgartown | 250909001469 | 890005 | Edgartown Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 27 | 1 | 6 | 0 | 0 | 0 | 0 | 23 | 11 | 34 | 27 | 1 | 6 | 0 | 0 | 0 | 0 | 23 | 11 | 34 | |||||||||||||||||||||||||||||||||
1365652 | 1365652 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000297 | 350255 | Oliver Hazard Perry | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 6 | 5 | 5 | 0 | 2 | 0 | 2 | 9 | 11 | * | 20.0 | 6 | 5 | 5 | 0 | 2 | 0 | 2 | 9 | 11 | 20 | ||||||||||||||||||||||||||||||||
1365740 | 1365740 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Sarah Greenwood | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 2 | 9 | 17 | 0 | 0 | 0 | 0 | 17 | 11 | * | 28.0 | 2 | 9 | 17 | 0 | 0 | 0 | 0 | 17 | 11 | 28 | ||||||||||||||||||||||||||||||||
1372504 | 1372504 | MA | Suffolk | school | 2500527 | 417 | Bridge Boston Charter School (District) | 250052702710 | 4170205 | Bridge Boston Charter School | Regular School | Yes | Elementary | PK | 08 | 2020 | grade_7 | 0 | 13 | 6 | 0 | 0 | 0 | 4 | 12 | 11 | * | 23.0 | 0 | 13 | 6 | 0 | 0 | 0 | 4 | 12 | 11 | 23 | ||||||||||||||||||||||||||||||||
1672537 | 1672537 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000251 | 350013 | Boston - Jackson Mann | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 3 | 13 | 10 | 0 | 1 | 0 | 1 | 17 | 11 | * | 28.0 | 3 | 13 | 10 | 0 | 1 | 0 | 1 | 17 | 11 | 28 | ||||||||||||||||||||||||||||||||
1672624 | 1672624 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000223 | 350077 | Boston - Dennis C Haley | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 2 | 12 | 7 | 0 | 0 | 0 | 3 | 13 | 11 | * | 24.0 | 2 | 12 | 7 | 0 | 0 | 0 | 3 | 13 | 11 | 24 | ||||||||||||||||||||||||||||||||
2045405 | 2045405 | MA | Berkshire | school | 2510080 | 249 | Richmond | 251008001635 | 2490005 | Richmond Consolidated | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 21 | 0 | 2 | 0 | 0 | 0 | 1 | 13 | 11 | 24.0 | 21 | 0 | 2 | 0 | 0 | 0 | 1 | 13 | 11 | 24 | |||||||||||||||||||||||||||||||||
2229687 | 2229687 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000272 | 350182 | Boston: Joseph J Hurley | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 0 | 0 | 17 | 0 | 0 | 0 | 0 | 6 | 11 | 17.0 | 0 | 0 | 17 | 0 | 0 | 0 | 0 | 6 | 11 | 17 | |||||||||||||||||||||||||||||||||
2231651 | 2231651 | MA | Bristol | school | 2504830 | 95 | Fall River | 250483002873 | 950525 | Fall River: Resiliency Preparatory Academy | Alternative School | No | High | 07 | 12 | 2018 | grade_7 | 12 | 3 | 3 | 0 | 0 | 0 | 5 | 12 | 11 | 23.0 | 12 | 3 | 3 | 0 | 0 | 0 | 5 | 12 | 11 | 23 | |||||||||||||||||||||||||||||||||
2238279 | 2238279 | MA | Essex | school | 2500034 | 464 | Marblehead Community Charter Public (District) | 250003400567 | 4640305 | Marblehead Community Charter Public (District): Marblehead Community Charter Public School | Regular School | Yes | Middle | 04 | 08 | 2018 | grade_7 | 35 | 2 | 1 | 1 | 2 | 0 | 0 | 30 | 11 | 41.0 | 35 | 2 | 1 | 1 | 2 | 0 | 0 | 30 | 11 | 41 | |||||||||||||||||||||||||||||||||
933310 | 933310 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000272 | 350182 | Joseph J Hurley | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 0 | 0 | 17 | 0 | 0 | 0 | 0 | 5 | 12 | 17 | 0 | 0 | 17 | 0 | 0 | 0 | 0 | 5 | 12 | 17 | |||||||||||||||||||||||||||||||||
933602 | 933602 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Higginson/Lewis K-8 | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 1 | 16 | 10 | 0 | 1 | 0 | 0 | 16 | 12 | 28 | 1 | 16 | 10 | 0 | 1 | 0 | 0 | 16 | 12 | 28 | |||||||||||||||||||||||||||||||||
940475 | 940475 | MA | Hampshire | school | 2500031 | 450 | Hilltown Cooperative Charter Public (District) | 250003100549 | 4500105 | Hilltown Cooperative Charter Public School | Regular School | Yes | 1 | KG | 08 | 2016 | grade_7 | 29 | 0 | 2 | 0 | 0 | 0 | 0 | 19 | 12 | 31 | 29 | 0 | 2 | 0 | 0 | 0 | 0 | 19 | 12 | 31 | |||||||||||||||||||||||||||||||||
1123871 | 1123871 | MA | Middlesex | school | 2503270 | 49 | Cambridge | 250327001621 | 490006 | Amigos School | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 8 | 1 | 11 | 0 | 1 | 0 | 4 | 13 | 12 | 25 | 8 | 1 | 11 | 0 | 1 | 0 | 4 | 13 | 12 | 25 | |||||||||||||||||||||||||||||||||
1127587 | 1127587 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001390 | 2090035 | Brayton | Regular School | No | Elementary | PK | 07 | 2017 | grade_7 | 24 | 0 | 2 | 0 | 0 | 0 | 2 | 16 | 12 | 28 | 24 | 0 | 2 | 0 | 0 | 0 | 2 | 16 | 12 | 28 | |||||||||||||||||||||||||||||||||
1131272 | 1131272 | MA | Suffolk | school | 2500070 | 438 | Codman Academy Charter Public (District) | 250007001667 | 4380505 | Codman Academy Charter Public School | Regular School | Yes | Other | PK | 12 | 2017 | grade_7 | 0 | 15 | 4 | 0 | 0 | 0 | 1 | 8 | 12 | 20 | 0 | 15 | 4 | 0 | 0 | 0 | 1 | 8 | 12 | 20 | |||||||||||||||||||||||||||||||||
1371335 | 1371335 | MA | Dukes | school | 2512570 | 296 | Tisbury | 251257002054 | 2960005 | Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 20 | 3 | 8 | 1 | 0 | 0 | 2 | 22 | 12 | * | 34.0 | 20 | 3 | 8 | 1 | 0 | 0 | 2 | 22 | 12 | 34 | ||||||||||||||||||||||||||||||||
1677580 | 1677580 | MA | Berkshire | school | 2510080 | 249 | Richmond | 251008001635 | 2490005 | Richmond - Richmond Consolidated | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 15 | 0 | 1 | 0 | 0 | 0 | 1 | 5 | 12 | * | 17.0 | 15 | 0 | 1 | 0 | 0 | 0 | 1 | 5 | 12 | 17 | ||||||||||||||||||||||||||||||||
1679795 | 1679795 | 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_7 | 0 | 1 | 34 | 0 | 0 | 0 | 0 | 23 | 12 | * | 35.0 | 0 | 1 | 34 | 0 | 0 | 0 | 0 | 23 | 12 | 35 | ||||||||||||||||||||||||||||||||
1680033 | 1680033 | MA | Essex | school | 2500034 | 464 | Marblehead Community Charter Public (District) | 250003400567 | 4640305 | Marblehead Community Charter Public (District) - Marblehead Community Charter Public School | Regular School | Yes | Middle | 04 | 08 | 2021 | grade_7 | 25 | 1 | 5 | 0 | 0 | 0 | 1 | 20 | 12 | * | 32.0 | 25 | 1 | 5 | 0 | 0 | 0 | 1 | 20 | 12 | 32 | ||||||||||||||||||||||||||||||||
2040470 | 2040470 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000230 | 350096 | Eliot Elementary | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 6 | 3 | 12 | 0 | 2 | 0 | 1 | 12 | 12 | 24.0 | 6 | 3 | 12 | 0 | 2 | 0 | 1 | 12 | 12 | 24 | |||||||||||||||||||||||||||||||||
2041093 | 2041093 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000312 | 350691 | Rafael Hernandez | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 4 | 12 | 16.0 | 0 | 0 | 16 | 0 | 0 | 0 | 0 | 4 | 12 | 16 | |||||||||||||||||||||||||||||||||
2047577 | 2047577 | MA | Suffolk | school | 2500527 | 417 | Bridge Boston Charter School (District) | 250052702710 | 4170205 | Bridge Boston Charter School | Regular School | Yes | Elementary | PK | 07 | 2019 | grade_7 | 0 | 16 | 7 | 0 | 0 | 0 | 1 | 12 | 12 | 24.0 | 0 | 16 | 7 | 0 | 0 | 0 | 1 | 12 | 12 | 24 | |||||||||||||||||||||||||||||||||
2047849 | 2047849 | MA | Dukes | school | 2500035 | 466 | Martha's Vineyard Charter (District) | 250003500569 | 4660550 | Martha's Vineyard Charter School | Regular School | Yes | Other | KG | 12 | 2019 | grade_7 | 17 | 1 | 1 | 1 | 0 | 0 | 0 | 8 | 12 | 20.0 | 17 | 1 | 1 | 1 | 0 | 0 | 0 | 8 | 12 | 20 | |||||||||||||||||||||||||||||||||
2229563 | 2229563 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000239 | 350116 | Boston: Franklin D Roosevelt | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 3 | 15 | 18 | 1 | 0 | 0 | 0 | 25 | 12 | 37.0 | 3 | 15 | 18 | 1 | 0 | 0 | 0 | 25 | 12 | 37 | |||||||||||||||||||||||||||||||||
2229896 | 2229896 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Boston: Sarah Greenwood | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 0 | 9 | 18 | 0 | 0 | 0 | 1 | 16 | 12 | 28.0 | 0 | 9 | 18 | 0 | 0 | 0 | 1 | 16 | 12 | 28 | |||||||||||||||||||||||||||||||||
2229926 | 2229926 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000333 | 350346 | Boston: Warren-Prescott | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 6 | 6 | 13 | 0 | 1 | 1 | 1 | 16 | 12 | 28.0 | 6 | 6 | 13 | 0 | 1 | 1 | 1 | 16 | 12 | 28 | |||||||||||||||||||||||||||||||||
2230003 | 2230003 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Boston: Higginson/Lewis K-8 | Regular School | No | Elementary | 01 | 08 | 2018 | grade_7 | 0 | 12 | 11 | 0 | 0 | 0 | 2 | 13 | 12 | 25.0 | 0 | 12 | 11 | 0 | 0 | 0 | 2 | 13 | 12 | 25 | |||||||||||||||||||||||||||||||||
2236562 | 2236562 | MA | Dukes | school | 2512570 | 296 | Tisbury | 251257002054 | 2960005 | Tisbury: Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 20 | 0 | 9 | 0 | 0 | 0 | 0 | 17 | 12 | 29.0 | 20 | 0 | 9 | 0 | 0 | 0 | 0 | 17 | 12 | 29 | |||||||||||||||||||||||||||||||||
738562 | 738562 | MA | Hampshire | school | 2505940 | 127 | Hatfield | 250594000845 | 1270505 | Smith Academy | Regular School | No | 3 | 07 | 12 | 2015 | grade_7 | 28 | 0 | 1 | 0 | 0 | 0 | 2 | 18 | 13 | 31 | 28 | 0 | 1 | 0 | 0 | 0 | 2 | 18 | 13 | 31 | |||||||||||||||||||||||||||||||||
740434 | 740434 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001388 | 2090008 | J S Sullivan | Regular School | No | 1 | KG | 07 | 2015 | grade_7 | 23 | 3 | 2 | 0 | 0 | 0 | 1 | 16 | 13 | 29 | 23 | 3 | 2 | 0 | 0 | 0 | 1 | 16 | 13 | 29 | |||||||||||||||||||||||||||||||||
743558 | 743558 | MA | Suffolk | school | 2500060 | 439 | Conservatory Lab Charter (District) | 250006001439 | 4390050 | Conservatory Lab Charter School | Regular School | Yes | 1 | PK | 08 | 2015 | grade_7 | 0 | 8 | 10 | 0 | 0 | 0 | 1 | 6 | 13 | 19 | 0 | 8 | 10 | 0 | 0 | 0 | 1 | 6 | 13 | 19 | |||||||||||||||||||||||||||||||||
933074 | 933074 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002687 | 350012 | Boston Teachers Union School | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 2 | 10 | 14 | 0 | 1 | 0 | 2 | 16 | 13 | 29 | 2 | 10 | 14 | 0 | 1 | 0 | 2 | 16 | 13 | 29 | |||||||||||||||||||||||||||||||||
933809 | 933809 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000312 | 350691 | Rafael Hernandez | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 0 | 1 | 24 | 0 | 0 | 0 | 0 | 12 | 13 | 25 | 0 | 1 | 24 | 0 | 0 | 0 | 0 | 12 | 13 | 25 | |||||||||||||||||||||||||||||||||
938656 | 938656 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001809 | 2810095 | Alfred G. Zanetti Montessori Magnet School | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 8 | 8 | 8 | 0 | 1 | 0 | 1 | 13 | 13 | 26 | 8 | 8 | 8 | 0 | 1 | 0 | 1 | 13 | 13 | 26 | |||||||||||||||||||||||||||||||||
941731 | 941731 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | West Tisbury Elementary | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 16 | 1 | 1 | 1 | 0 | 0 | 0 | 6 | 13 | 19 | 16 | 1 | 1 | 1 | 0 | 0 | 0 | 6 | 13 | 19 | |||||||||||||||||||||||||||||||||
1122946 | 1122946 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000291 | 350229 | Maurice J Tobin | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 0 | 8 | 19 | 0 | 0 | 0 | 1 | 15 | 13 | 28 | 0 | 8 | 19 | 0 | 0 | 0 | 1 | 15 | 13 | 28 | |||||||||||||||||||||||||||||||||
1132832 | 1132832 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | West Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 38 | 1 | 1 | 3 | 1 | 0 | 2 | 33 | 13 | 46 | 38 | 1 | 1 | 3 | 1 | 0 | 2 | 33 | 13 | 46 | |||||||||||||||||||||||||||||||||
1365580 | 1365580 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000278 | 350190 | Joyce Kilmer | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 10 | 1 | 11 | 0 | 2 | 0 | 1 | 12 | 13 | * | 25.0 | 10 | 1 | 11 | 0 | 2 | 0 | 1 | 12 | 13 | 25 | ||||||||||||||||||||||||||||||||
1366040 | 1366040 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000312 | 350691 | Rafael Hernandez | Regular School | No | Elementary | PK | 08 | 2020 | grade_7 | 2 | 0 | 23 | 0 | 0 | 0 | 0 | 12 | 13 | * | 25.0 | 2 | 0 | 23 | 0 | 0 | 0 | 0 | 12 | 13 | 25 | ||||||||||||||||||||||||||||||||
1681107 | 1681107 | MA | Berkshire | school | 2511040 | 765 | Southern Berkshire | 251104001774 | 7650505 | Southern Berkshire - Mt Everett Regional | Regular School | No | High | 06 | 12 | 2021 | grade_7 | 31 | 0 | 2 | 0 | 0 | 0 | 2 | 22 | 13 | * | 35.0 | 31 | 0 | 2 | 0 | 0 | 0 | 2 | 22 | 13 | 35 | ||||||||||||||||||||||||||||||||
2040721 | 2040721 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000692 | 350262 | Lyndon | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 4 | 11 | 18 | 0 | 0 | 0 | 2 | 22 | 13 | 35.0 | 4 | 11 | 18 | 0 | 0 | 0 | 2 | 22 | 13 | 35 | |||||||||||||||||||||||||||||||||
2042896 | 2042896 | MA | Hampden | school | 2506270 | 137 | Holyoke | 250627002645 | 1370030 | William R. Peck School | Regular School | No | Middle | 04 | 08 | 2019 | grade_7 | 2 | 3 | 40 | 0 | 0 | 0 | 0 | 32 | 13 | 45.0 | 2 | 3 | 40 | 0 | 0 | 0 | 0 | 32 | 13 | 45 | |||||||||||||||||||||||||||||||||
2229544 | 2229544 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000230 | 350096 | Boston: Eliot Elementary | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 11 | 2 | 12 | 0 | 2 | 0 | 2 | 16 | 13 | 29.0 | 11 | 2 | 12 | 0 | 2 | 0 | 2 | 16 | 13 | 29 | |||||||||||||||||||||||||||||||||
2229907 | 2229907 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000331 | 350326 | Boston: Gardner Pilot Academy | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 6 | 6 | 23 | 0 | 2 | 0 | 0 | 24 | 13 | 37.0 | 6 | 6 | 23 | 0 | 2 | 0 | 0 | 24 | 13 | 37 | |||||||||||||||||||||||||||||||||
2229995 | 2229995 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002669 | 350376 | Boston: King K-8 | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 1 | 17 | 10 | 0 | 0 | 0 | 0 | 15 | 13 | 28.0 | 1 | 17 | 10 | 0 | 0 | 0 | 0 | 15 | 13 | 28 | |||||||||||||||||||||||||||||||||
2230025 | 2230025 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000693 | 350380 | Boston: Young Achievers | Alternative School | No | Elementary | PK | 08 | 2018 | grade_7 | 1 | 29 | 13 | 0 | 0 | 0 | 0 | 30 | 13 | 43.0 | 1 | 29 | 13 | 0 | 0 | 0 | 0 | 30 | 13 | 43 | |||||||||||||||||||||||||||||||||
2238212 | 2238212 | MA | Hampshire | school | 2500031 | 450 | Hilltown Cooperative Charter Public (District) | 250003100549 | 4500105 | Hilltown Cooperative Charter Public (District): Hilltown Cooperative Charter Public School | Regular School | Yes | Elementary | KG | 08 | 2018 | grade_7 | 26 | 0 | 1 | 0 | 0 | 0 | 3 | 17 | 13 | 30.0 | 26 | 0 | 1 | 0 | 0 | 0 | 3 | 17 | 13 | 30 | |||||||||||||||||||||||||||||||||
736506 | 736506 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000291 | 350229 | Maurice J Tobin | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 0 | 7 | 16 | 0 | 0 | 0 | 0 | 9 | 14 | 23 | 0 | 7 | 16 | 0 | 0 | 0 | 0 | 9 | 14 | 23 | |||||||||||||||||||||||||||||||||
736647 | 736647 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000331 | 350326 | Gardner Pilot Academy | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 3 | 6 | 24 | 0 | 3 | 0 | 1 | 23 | 14 | 37 | 3 | 6 | 24 | 0 | 3 | 0 | 1 | 23 | 14 | 37 | |||||||||||||||||||||||||||||||||
744910 | 744910 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | West Tisbury Elementary | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 35 | 0 | 0 | 1 | 1 | 0 | 1 | 24 | 14 | 38 | 35 | 0 | 0 | 1 | 1 | 0 | 1 | 24 | 14 | 38 | |||||||||||||||||||||||||||||||||
745193 | 745193 | MA | Norfolk | school | 2500556 | 3902 | TEC Connections Academy Commonwealth Virtual School District | 250055602817 | 39020900 | TEC Connections Academy Commonwealth Virtual School | Regular School | No | 4 | KG | 12 | 2015 | grade_7 | 21 | 2 | 4 | 0 | 0 | 0 | 3 | 16 | 14 | 30 | 21 | 2 | 4 | 0 | 0 | 0 | 3 | 16 | 14 | 30 | |||||||||||||||||||||||||||||||||
933532 | 933532 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000333 | 350346 | Warren-Prescott | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 11 | 11 | 10 | 1 | 1 | 0 | 0 | 20 | 14 | 34 | 11 | 11 | 10 | 1 | 1 | 0 | 0 | 20 | 14 | 34 | |||||||||||||||||||||||||||||||||
940423 | 940423 | MA | Suffolk | school | 2500029 | 444 | Neighborhood House Charter (District) | 250002900545 | 4440205 | Neighborhood House Charter School | Regular School | Yes | 1 | PK | 08 | 2016 | grade_7 | 5 | 17 | 7 | 0 | 2 | 0 | 0 | 17 | 14 | 31 | 5 | 17 | 7 | 0 | 2 | 0 | 0 | 17 | 14 | 31 | |||||||||||||||||||||||||||||||||
1122731 | 1122731 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000230 | 350096 | Eliot Elementary | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 7 | 7 | 9 | 1 | 1 | 0 | 1 | 12 | 14 | 26 | 7 | 7 | 9 | 1 | 1 | 0 | 1 | 12 | 14 | 26 | |||||||||||||||||||||||||||||||||
1123092 | 1123092 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000323 | 350308 | Sarah Greenwood | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 0 | 8 | 14 | 0 | 0 | 0 | 0 | 8 | 14 | 22 | 0 | 8 | 14 | 0 | 0 | 0 | 0 | 8 | 14 | 22 | |||||||||||||||||||||||||||||||||
1127568 | 1127568 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001388 | 2090008 | Colegrove Park Elementary | Regular School | No | Elementary | KG | 07 | 2017 | grade_7 | 24 | 0 | 0 | 0 | 0 | 0 | 1 | 11 | 14 | 25 | 24 | 0 | 0 | 0 | 0 | 0 | 1 | 11 | 14 | 25 | |||||||||||||||||||||||||||||||||
1128555 | 1128555 | MA | Berkshire | school | 2510080 | 249 | Richmond | 251008001635 | 2490005 | Richmond Consolidated | Regular School | No | Elementary | PK | 08 | 2017 | grade_7 | 20 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 14 | 21 | 20 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 14 | 21 | |||||||||||||||||||||||||||||||||
1365836 | 1365836 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279002677 | 350377 | Higginson/Lewis K-8 | Regular School | No | Middle | 03 | 08 | 2020 | grade_7 | 2 | 22 | 20 | 0 | 0 | 0 | 1 | 31 | 14 | * | 45.0 | 2 | 22 | 20 | 0 | 0 | 0 | 1 | 31 | 14 | 45 | ||||||||||||||||||||||||||||||||
1673040 | 1673040 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000343 | 350370 | Boston - William Monroe Trotter | Regular School | No | Elementary | PK | 08 | 2021 | grade_7 | 0 | 14 | 12 | 0 | 0 | 0 | 0 | 12 | 14 | * | 26.0 | 0 | 14 | 12 | 0 | 0 | 0 | 0 | 12 | 14 | 26 | ||||||||||||||||||||||||||||||||
1676923 | 1676923 | MA | Worcester | school | 2508760 | 215 | North Brookfield | 250876001411 | 2150505 | North Brookfield - North Brookfield High | Regular School | No | High | 07 | 12 | 2021 | grade_7 | 36 | 1 | 2 | 0 | 0 | 0 | 4 | 29 | 14 | * | 43.0 | 36 | 1 | 2 | 0 | 0 | 0 | 4 | 29 | 14 | 43 | ||||||||||||||||||||||||||||||||
2040846 | 2040846 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000343 | 350370 | William Monroe Trotter | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 0 | 12 | 11 | 0 | 0 | 0 | 4 | 13 | 14 | 27.0 | 0 | 12 | 11 | 0 | 0 | 0 | 4 | 13 | 14 | 27 | |||||||||||||||||||||||||||||||||
2045769 | 2045769 | MA | Middlesex | school | 2510890 | 274 | Somerville | 251089000891 | 2740115 | West Somerville Neighborhood | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 18 | 4 | 6 | 0 | 1 | 0 | 1 | 16 | 14 | 30.0 | 18 | 4 | 6 | 0 | 1 | 0 | 1 | 16 | 14 | 30 | |||||||||||||||||||||||||||||||||
2047648 | 2047648 | 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 | 07 | 2019 | grade_7 | 1 | 0 | 31 | 0 | 0 | 0 | 0 | 18 | 14 | 32.0 | 1 | 0 | 31 | 0 | 0 | 0 | 0 | 18 | 14 | 32 | |||||||||||||||||||||||||||||||||
2047780 | 2047780 | MA | Hampshire | school | 2500031 | 450 | Hilltown Cooperative Charter Public (District) | 250003100549 | 4500105 | Hilltown Cooperative Charter Public School | Regular School | Yes | Elementary | KG | 08 | 2019 | grade_7 | 21 | 2 | 3 | 0 | 0 | 0 | 4 | 16 | 14 | 30.0 | 21 | 2 | 3 | 0 | 0 | 0 | 4 | 16 | 14 | 30 | |||||||||||||||||||||||||||||||||
2230259 | 2230259 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000312 | 350691 | Boston: Rafael Hernandez | Regular School | No | Elementary | PK | 08 | 2018 | grade_7 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 8 | 14 | 22.0 | 0 | 0 | 22 | 0 | 0 | 0 | 0 | 8 | 14 | 22 | |||||||||||||||||||||||||||||||||
736751 | 736751 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000693 | 350380 | Young Achievers | Alternative Education School | No | 1 | PK | 08 | 2015 | grade_7 | 0 | 33 | 15 | 0 | 0 | 0 | 0 | 33 | 15 | 48 | 0 | 33 | 15 | 0 | 0 | 0 | 0 | 33 | 15 | 48 | |||||||||||||||||||||||||||||||||
741850 | 741850 | MA | Hampden | school | 2511130 | 281 | Springfield | 251113001809 | 2810095 | Alfred G. Zanetti Montessori Magnet School | Regular School | No | 1 | PK | 08 | 2015 | grade_7 | 4 | 8 | 9 | 0 | 0 | 0 | 0 | 6 | 15 | 21 | 4 | 8 | 9 | 0 | 0 | 0 | 0 | 6 | 15 | 21 | |||||||||||||||||||||||||||||||||
933337 | 933337 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000278 | 350190 | Joyce Kilmer | Regular School | No | 1 | PK | 08 | 2016 | grade_7 | 10 | 4 | 6 | 1 | 1 | 0 | 3 | 10 | 15 | 25 | 10 | 4 | 6 | 1 | 1 | 0 | 3 | 10 | 15 | 25 | |||||||||||||||||||||||||||||||||
937277 | 937277 | MA | Berkshire | school | 2508670 | 209 | North Adams | 250867001389 | 2090015 | Greylock | Regular School | No | 1 | KG | 07 | 2016 | grade_7 | 27 | 1 | 3 | 0 | 1 | 1 | 1 | 19 | 15 | 34 | 27 | 1 | 3 | 0 | 1 | 1 | 1 | 19 | 15 | 34 | |||||||||||||||||||||||||||||||||
937452 | 937452 | MA | Worcester | school | 2508760 | 215 | North Brookfield | 250876001411 | 2150505 | North Brookfield High | Regular School | No | 3 | 07 | 12 | 2016 | grade_7 | 24 | 0 | 2 | 0 | 0 | 0 | 3 | 14 | 15 | 29 | 24 | 0 | 2 | 0 | 0 | 0 | 3 | 14 | 15 | 29 | |||||||||||||||||||||||||||||||||
940368 | 940368 | MA | Suffolk | school | 2500070 | 438 | Codman Academy Charter Public (District) | 250007001667 | 4380505 | Codman Academy Charter Public School | Regular School | Yes | 4 | PK | 12 | 2016 | grade_7 | 1 | 17 | 5 | 0 | 0 | 0 | 0 | 8 | 15 | 23 | 1 | 17 | 5 | 0 | 0 | 0 | 0 | 8 | 15 | 23 | |||||||||||||||||||||||||||||||||
940413 | 940413 | MA | Suffolk | school | 2500528 | 443 | Brooke Charter School Mattapan (District) | 250052802711 | 4430205 | Brooke Charter School Mattapan | Regular School | Yes | 1 | KG | 08 | 2016 | grade_7 | 0 | 19 | 9 | 0 | 0 | 0 | 2 | 15 | 15 | 30 | 0 | 19 | 9 | 0 | 0 | 0 | 2 | 15 | 15 | 30 | |||||||||||||||||||||||||||||||||
1131323 | 1131323 | MA | Suffolk | school | 2500029 | 444 | Neighborhood House Charter (District) | 250002900545 | 4440205 | Neighborhood House Charter School | Regular School | Yes | Elementary | PK | 08 | 2017 | grade_7 | 8 | 23 | 4 | 2 | 1 | 0 | 0 | 23 | 15 | 38 | 8 | 23 | 4 | 2 | 1 | 0 | 0 | 23 | 15 | 38 | |||||||||||||||||||||||||||||||||
1679767 | 1679767 | 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_7 | 0 | 17 | 10 | 0 | 0 | 0 | 0 | 12 | 15 | * | 27.0 | 0 | 17 | 10 | 0 | 0 | 0 | 0 | 12 | 15 | 27 | ||||||||||||||||||||||||||||||||
2040358 | 2040358 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000251 | 350013 | Jackson Mann | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 3 | 18 | 19 | 0 | 2 | 0 | 3 | 30 | 15 | 45.0 | 3 | 18 | 19 | 0 | 2 | 0 | 3 | 30 | 15 | 45 | |||||||||||||||||||||||||||||||||
2040443 | 2040443 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000223 | 350077 | Dennis C Haley | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 2 | 13 | 10 | 0 | 0 | 0 | 3 | 13 | 15 | 28.0 | 2 | 13 | 10 | 0 | 0 | 0 | 3 | 13 | 15 | 28 | |||||||||||||||||||||||||||||||||
2049029 | 2049029 | MA | Dukes | school | 2500043 | 774 | Up-Island Regional | 250004301927 | 7740020 | West Tisbury Elementary | Regular School | No | Elementary | PK | 08 | 2019 | grade_7 | 37 | 0 | 1 | 1 | 1 | 0 | 3 | 28 | 15 | 43.0 | 37 | 0 | 1 | 1 | 1 | 0 | 3 | 28 | 15 | 43 |
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]);