enrollments
Data source: Big Local News · About: Big Local
2,748 rows where grade = "grade_12" and state = "MA" sorted by school
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2230215 | 2230215 | MA | Suffolk | school | 35 | Boston | 350652 | 2018 | grade_12 | * | * | * | * | * | * | * | * | * | 0.0 | 0 | ||||||||||||||||||||||||||||||||||||||||||||||||||
742837 | 742837 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251002790 | 3320515 | 21st Century Skills Academy | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 3 | 0 | 7 | 0 | 0 | 0 | 0 | 7 | * | 10 | 3 | 0 | 7 | 0 | 0 | 0 | 0 | 7 | 10 | ||||||||||||||||||||||||||||||||||
939642 | 939642 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251002790 | 3320515 | 21st Century Skills Academy | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 9 | 2 | 2 | 0 | 0 | 0 | 0 | 9 | * | 13 | 9 | 2 | 2 | 0 | 0 | 0 | 0 | 9 | 13 | ||||||||||||||||||||||||||||||||||
1130405 | 1130405 | MA | Hampden | school | 2512510 | 332 | West Springfield | 251251002790 | 3320515 | 21st Century Skills Academy | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 10 | 1 | 2 | 0 | 0 | 0 | 0 | 11 | * | 13 | 10 | 1 | 2 | 0 | 0 | 0 | 0 | 11 | 13 | ||||||||||||||||||||||||||||||||||
2047889 | 2047889 | MA | Worcester | school | 2500073 | 474 | Sizer School | 250007301750 | 4740505 | A North Central Charter Essential (District): Sizer School: A North Central Charter Essential School | Regular School | Yes | High | 07 | 12 | 2019 | grade_12 | 31 | 0 | 6 | 0 | 0 | 0 | 0 | 22 | 15 | 37.0 | 31 | 0 | 6 | 0 | 0 | 0 | 0 | 22 | 15 | 37 | |||||||||||||||||||||||||||||||||
1369817 | 1369817 | MA | Worcester | school | 2509270 | 226 | Oxford | 250927002810 | 2260305 | ACE Program | Special Education School | No | High | 10 | 12 | 2020 | grade_12 | * | * | * | * | * | * | * | 4 | * | * | 4.0 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||
1679935 | 1679935 | MA | Worcester | school | 2500051 | 445 | Abby Kelley Foster Charter Public (District) | 250005101247 | 4450105 | Abby Kelley Foster Charter Public (District) - Abby Kelley Foster Charter Public School | Regular School | Yes | Other | KG | 12 | 2021 | grade_12 | 16 | 43 | 20 | 0 | 6 | 0 | 1 | 33 | 53 | * | 86.0 | 16 | 43 | 20 | 0 | 6 | 0 | 1 | 33 | 53 | 86 | ||||||||||||||||||||||||||||||||
2238170 | 2238170 | MA | Worcester | school | 2500051 | 445 | Abby Kelley Foster Charter Public (District) | 250005101247 | 4450105 | Abby Kelley Foster Charter Public (District): Abby Kelley Foster Charter Public School | Regular School | Yes | Other | KG | 12 | 2018 | grade_12 | 23 | 35 | 25 | 0 | 6 | 0 | 2 | 30 | 61 | 91.0 | 23 | 35 | 25 | 0 | 6 | 0 | 2 | 30 | 61 | 91 | |||||||||||||||||||||||||||||||||
743614 | 743614 | MA | Worcester | school | 2500051 | 445 | Abby Kelley Foster Charter Public (District) | 250005101247 | 4450105 | Abby Kelley Foster Charter Public School | Regular School | Yes | 4 | KG | 12 | 2015 | grade_12 | 23 | 25 | 17 | 0 | 5 | 0 | 9 | 31 | 48 | 79 | 23 | 25 | 17 | 0 | 5 | 0 | 9 | 31 | 48 | 79 | |||||||||||||||||||||||||||||||||
940437 | 940437 | MA | Worcester | school | 2500051 | 445 | Abby Kelley Foster Charter Public (District) | 250005101247 | 4450105 | Abby Kelley Foster Charter Public School | Regular School | Yes | 4 | KG | 12 | 2016 | grade_12 | 19 | 23 | 28 | 0 | 3 | 0 | 6 | 36 | 43 | 79 | 19 | 23 | 28 | 0 | 3 | 0 | 6 | 36 | 43 | 79 | |||||||||||||||||||||||||||||||||
1131338 | 1131338 | MA | Worcester | school | 2500051 | 445 | Abby Kelley Foster Charter Public (District) | 250005101247 | 4450105 | Abby Kelley Foster Charter Public School | Regular School | Yes | Other | KG | 12 | 2017 | grade_12 | 31 | 29 | 15 | 0 | 4 | 0 | 2 | 33 | 48 | 81 | 31 | 29 | 15 | 0 | 4 | 0 | 2 | 33 | 48 | 81 | |||||||||||||||||||||||||||||||||
1372671 | 1372671 | MA | Worcester | school | 2500051 | 445 | Abby Kelley Foster Charter Public (District) | 250005101247 | 4450105 | Abby Kelley Foster Charter Public School | Regular School | Yes | Other | KG | 12 | 2020 | grade_12 | 23 | 35 | 19 | 0 | 5 | 0 | 2 | 38 | 46 | * | 84.0 | 23 | 35 | 19 | 0 | 5 | 0 | 2 | 38 | 46 | 84 | ||||||||||||||||||||||||||||||||
2047742 | 2047742 | MA | Worcester | school | 2500051 | 445 | Abby Kelley Foster Charter Public (District) | 250005101247 | 4450105 | Abby Kelley Foster Charter Public School | Regular School | Yes | Other | KG | 12 | 2019 | grade_12 | 23 | 35 | 16 | 0 | 5 | 1 | 3 | 48 | 35 | 83.0 | 23 | 35 | 16 | 0 | 5 | 1 | 3 | 48 | 35 | 83 | |||||||||||||||||||||||||||||||||
1672021 | 1672021 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000001 | 10505 | Abington - Abington High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 125 | 8 | 14 | 0 | 3 | 0 | 2 | 75 | 77 | * | 152.0 | 125 | 8 | 14 | 0 | 3 | 0 | 2 | 75 | 77 | 152 | ||||||||||||||||||||||||||||||||
735671 | 735671 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000001 | 10505 | Abington High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 117 | 1 | 8 | 0 | 2 | 0 | 0 | 57 | 71 | 128 | 117 | 1 | 8 | 0 | 2 | 0 | 0 | 57 | 71 | 128 | |||||||||||||||||||||||||||||||||
932549 | 932549 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000001 | 10505 | Abington High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 100 | 7 | 2 | 0 | 0 | 0 | 5 | 55 | 59 | 114 | 100 | 7 | 2 | 0 | 0 | 0 | 5 | 55 | 59 | 114 | |||||||||||||||||||||||||||||||||
1121963 | 1121963 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000001 | 10505 | Abington High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 82 | 2 | 8 | 0 | 0 | 0 | 0 | 41 | 51 | 92 | 82 | 2 | 8 | 0 | 0 | 0 | 0 | 41 | 51 | 92 | |||||||||||||||||||||||||||||||||
1364797 | 1364797 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000001 | 10505 | Abington High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 102 | 3 | 6 | 0 | 4 | 0 | 2 | 55 | 62 | * | 117.0 | 102 | 3 | 6 | 0 | 4 | 0 | 2 | 55 | 62 | 117 | ||||||||||||||||||||||||||||||||
2039823 | 2039823 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000001 | 10505 | Abington High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 90 | 4 | 9 | 0 | 3 | 1 | 0 | 48 | 59 | 107.0 | 90 | 4 | 9 | 0 | 3 | 1 | 0 | 48 | 59 | 107 | |||||||||||||||||||||||||||||||||
2228771 | 2228771 | MA | Plymouth | school | 2501650 | 1 | Abington | 250165000001 | 10505 | Abington: Abington High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 105 | 2 | 14 | 0 | 0 | 0 | 2 | 59 | 64 | 123.0 | 105 | 2 | 14 | 0 | 0 | 0 | 2 | 59 | 64 | 123 | |||||||||||||||||||||||||||||||||
1679738 | 1679738 | MA | Suffolk | school | 2500021 | 412 | Academy Of the Pacific Rim Charter Public (District) | 250002100511 | 4120530 | Academy Of the Pacific Rim Charter Public (District) - Academy Of the Pacific Rim Charter Public School | Regular School | Yes | High | 05 | 12 | 2021 | grade_12 | 3 | 40 | 14 | 0 | 1 | 0 | 0 | 25 | 33 | * | 58.0 | 3 | 40 | 14 | 0 | 1 | 0 | 0 | 25 | 33 | 58 | ||||||||||||||||||||||||||||||||
2237959 | 2237959 | MA | Suffolk | school | 2500021 | 412 | Academy Of the Pacific Rim Charter Public (District) | 250002100511 | 4120530 | Academy Of the Pacific Rim Charter Public (District): Academy Of the Pacific Rim Charter Public School | Regular School | Yes | High | 05 | 12 | 2018 | grade_12 | 4 | 22 | 11 | 0 | 0 | 0 | 1 | 15 | 23 | 38.0 | 4 | 22 | 11 | 0 | 0 | 0 | 1 | 15 | 23 | 38 | |||||||||||||||||||||||||||||||||
743433 | 743433 | MA | Suffolk | school | 2500021 | 412 | Academy Of the Pacific Rim Charter Public (District) | 250002100511 | 4120530 | Academy Of the Pacific Rim Charter Public School | Regular School | Yes | 4 | 05 | 12 | 2015 | grade_12 | 9 | 27 | 8 | 0 | 2 | 0 | 1 | 17 | 30 | 47 | 9 | 27 | 8 | 0 | 2 | 0 | 1 | 17 | 30 | 47 | |||||||||||||||||||||||||||||||||
940254 | 940254 | MA | Suffolk | school | 2500021 | 412 | Academy Of the Pacific Rim Charter Public (District) | 250002100511 | 4120530 | Academy Of the Pacific Rim Charter Public School | Regular School | Yes | 4 | 05 | 12 | 2016 | grade_12 | 13 | 35 | 4 | 0 | 0 | 0 | 2 | 24 | 30 | 54 | 13 | 35 | 4 | 0 | 0 | 0 | 2 | 24 | 30 | 54 | |||||||||||||||||||||||||||||||||
1131132 | 1131132 | MA | Suffolk | school | 2500021 | 412 | Academy Of the Pacific Rim Charter Public (District) | 250002100511 | 4120530 | Academy Of the Pacific Rim Charter Public School | Regular School | Yes | Other | 05 | 12 | 2017 | grade_12 | 12 | 25 | 10 | 0 | 0 | 0 | 2 | 18 | 31 | 49 | 12 | 25 | 10 | 0 | 0 | 0 | 2 | 18 | 31 | 49 | |||||||||||||||||||||||||||||||||
1372475 | 1372475 | MA | Suffolk | school | 2500021 | 412 | Academy Of the Pacific Rim Charter Public (District) | 250002100511 | 4120530 | Academy Of the Pacific Rim Charter Public School | Regular School | Yes | High | 05 | 12 | 2020 | grade_12 | 4 | 22 | 12 | 0 | 1 | 0 | 1 | 20 | 20 | * | 40.0 | 4 | 22 | 12 | 0 | 1 | 0 | 1 | 20 | 20 | 40 | ||||||||||||||||||||||||||||||||
2047548 | 2047548 | MA | Suffolk | school | 2500021 | 412 | Academy Of the Pacific Rim Charter Public (District) | 250002100511 | 4120530 | Academy Of the Pacific Rim Charter Public School | Regular School | Yes | High | 05 | 12 | 2019 | grade_12 | 2 | 21 | 10 | 0 | 1 | 1 | 3 | 19 | 19 | 38.0 | 2 | 21 | 10 | 0 | 1 | 1 | 3 | 19 | 19 | 38 | |||||||||||||||||||||||||||||||||
1680292 | 1680292 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000012 | 6000505 | Acton-Boxborough - Acton-Boxborough Regional High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 229 | 13 | 18 | 1 | 144 | 0 | 21 | 223 | 203 | * | 426.0 | 229 | 13 | 18 | 1 | 144 | 0 | 21 | 223 | 203 | 426 | ||||||||||||||||||||||||||||||||
743970 | 743970 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000012 | 6000505 | Acton-Boxborough Regional High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 344 | 2 | 16 | 1 | 112 | 0 | 6 | 235 | 246 | 481 | 344 | 2 | 16 | 1 | 112 | 0 | 6 | 235 | 246 | 481 | |||||||||||||||||||||||||||||||||
940803 | 940803 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000012 | 6000505 | Acton-Boxborough Regional High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 334 | 8 | 14 | 1 | 111 | 0 | 12 | 250 | 230 | 480 | 334 | 8 | 14 | 1 | 111 | 0 | 12 | 250 | 230 | 480 | |||||||||||||||||||||||||||||||||
1131740 | 1131740 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000012 | 6000505 | Acton-Boxborough Regional High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 316 | 4 | 21 | 0 | 117 | 0 | 9 | 236 | 231 | 467 | 316 | 4 | 21 | 0 | 117 | 0 | 9 | 236 | 231 | 467 | |||||||||||||||||||||||||||||||||
1373028 | 1373028 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000012 | 6000505 | Acton-Boxborough Regional High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 259 | 10 | 18 | 2 | 141 | 0 | 19 | 227 | 222 | * | 449.0 | 259 | 10 | 18 | 2 | 141 | 0 | 19 | 227 | 222 | 449 | ||||||||||||||||||||||||||||||||
2048100 | 2048100 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000012 | 6000505 | Acton-Boxborough Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 294 | 9 | 21 | 0 | 159 | 0 | 17 | 271 | 229 | 500.0 | 294 | 9 | 21 | 0 | 159 | 0 | 17 | 271 | 229 | 500 | |||||||||||||||||||||||||||||||||
2238577 | 2238577 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000012 | 6000505 | Acton-Boxborough: Acton-Boxborough Regional High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 282 | 11 | 17 | 1 | 117 | 0 | 24 | 224 | 228 | 452.0 | 282 | 11 | 17 | 1 | 117 | 0 | 24 | 224 | 228 | 452 | |||||||||||||||||||||||||||||||||
2238594 | 2238594 | MA | Berkshire | school | 2501780 | 603 | Adams-Cheshire | 250178000021 | 6030505 | Adams-Cheshire: Hoosac Valley High School | Regular School | No | High | 08 | 12 | 2018 | grade_12 | 81 | 3 | 1 | 0 | 0 | 0 | 0 | 45 | 40 | 85.0 | 81 | 3 | 1 | 0 | 0 | 0 | 0 | 45 | 40 | 85 | |||||||||||||||||||||||||||||||||
1368469 | 1368469 | MA | Worcester | school | 2507080 | 162 | Lunenburg | 250708002882 | 1620605 | Advanced Community Experience Program | Special Education School | No | Ungraded | UG | UG | 2020 | grade_12 | * | * | * | * | * | * | * | * | * | * | 0.0 | 0 | |||||||||||||||||||||||||||||||||||||||||
1679829 | 1679829 | MA | Middlesex | school | 2500085 | 430 | Advanced Math and Science Academy Charter (District) | 250008501984 | 4300305 | Advanced Math and Science Academy Charter (District) - Advanced Math and Science Academy Charter School | Regular School | Yes | High | 06 | 12 | 2021 | grade_12 | 87 | 1 | 10 | 0 | 40 | 0 | 3 | 70 | 71 | * | 141.0 | 87 | 1 | 10 | 0 | 40 | 0 | 3 | 70 | 71 | 141 | ||||||||||||||||||||||||||||||||
2238058 | 2238058 | MA | Middlesex | school | 2500085 | 430 | Advanced Math and Science Academy Charter (District) | 250008501984 | 4300305 | Advanced Math and Science Academy Charter (District): Advanced Math and Science Academy Charter School | Regular School | Yes | High | 06 | 12 | 2018 | grade_12 | 72 | 3 | 6 | 0 | 18 | 0 | 5 | 63 | 41 | 104.0 | 72 | 3 | 6 | 0 | 18 | 0 | 5 | 63 | 41 | 104 | |||||||||||||||||||||||||||||||||
743512 | 743512 | MA | Middlesex | school | 2500085 | 430 | Advanced Math and Science Academy Charter (District) | 250008501984 | 4300305 | Advanced Math and Science Academy Charter School | Regular School | Yes | 4 | 06 | 12 | 2015 | grade_12 | 73 | 3 | 8 | 3 | 41 | 1 | 0 | 74 | 55 | 129 | 73 | 3 | 8 | 3 | 41 | 1 | 0 | 74 | 55 | 129 | |||||||||||||||||||||||||||||||||
940332 | 940332 | MA | Middlesex | school | 2500085 | 430 | Advanced Math and Science Academy Charter (District) | 250008501984 | 4300305 | Advanced Math and Science Academy Charter School | Regular School | Yes | 4 | 06 | 12 | 2016 | grade_12 | 102 | 9 | 12 | 0 | 54 | 0 | 5 | 97 | 85 | 182 | 102 | 9 | 12 | 0 | 54 | 0 | 5 | 97 | 85 | 182 | |||||||||||||||||||||||||||||||||
1131228 | 1131228 | MA | Middlesex | school | 2500085 | 430 | Advanced Math and Science Academy Charter (District) | 250008501984 | 4300305 | Advanced Math and Science Academy Charter School | Regular School | Yes | Other | 06 | 12 | 2017 | grade_12 | 71 | 3 | 12 | 1 | 38 | 0 | 0 | 62 | 63 | 125 | 71 | 3 | 12 | 1 | 38 | 0 | 0 | 62 | 63 | 125 | |||||||||||||||||||||||||||||||||
1372566 | 1372566 | MA | Middlesex | school | 2500085 | 430 | Advanced Math and Science Academy Charter (District) | 250008501984 | 4300305 | Advanced Math and Science Academy Charter School | Regular School | Yes | High | 06 | 12 | 2020 | grade_12 | 93 | 5 | 3 | 1 | 23 | 0 | 10 | 78 | 57 | * | 135.0 | 93 | 5 | 3 | 1 | 23 | 0 | 10 | 78 | 57 | 135 | ||||||||||||||||||||||||||||||||
2047639 | 2047639 | MA | Middlesex | school | 2500085 | 430 | Advanced Math and Science Academy Charter (District) | 250008501984 | 4300305 | Advanced Math and Science Academy Charter School | Regular School | Yes | High | 06 | 12 | 2019 | grade_12 | 82 | 4 | 3 | 1 | 20 | 0 | 9 | 50 | 69 | 119.0 | 82 | 4 | 3 | 1 | 20 | 0 | 9 | 50 | 69 | 119 | |||||||||||||||||||||||||||||||||
1672061 | 1672061 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000024 | 50505 | Agawam - Agawam High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 236 | 4 | 23 | 0 | 2 | 0 | 6 | 129 | 142 | * | 271.0 | 236 | 4 | 23 | 0 | 2 | 0 | 6 | 129 | 142 | 271 | ||||||||||||||||||||||||||||||||
735713 | 735713 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000024 | 50505 | Agawam High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 267 | 6 | 8 | 2 | 7 | 2 | 3 | 153 | 142 | 295 | 267 | 6 | 8 | 2 | 7 | 2 | 3 | 153 | 142 | 295 | |||||||||||||||||||||||||||||||||
932591 | 932591 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000024 | 50505 | Agawam High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 273 | 6 | 18 | 1 | 6 | 1 | 7 | 158 | 154 | 312 | 273 | 6 | 18 | 1 | 6 | 1 | 7 | 158 | 154 | 312 | |||||||||||||||||||||||||||||||||
1122014 | 1122014 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000024 | 50505 | Agawam High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 280 | 1 | 21 | 0 | 8 | 0 | 5 | 158 | 157 | 315 | 280 | 1 | 21 | 0 | 8 | 0 | 5 | 158 | 157 | 315 | |||||||||||||||||||||||||||||||||
1364837 | 1364837 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000024 | 50505 | Agawam High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 238 | 3 | 14 | 0 | 8 | 0 | 2 | 135 | 130 | * | 265.0 | 238 | 3 | 14 | 0 | 8 | 0 | 2 | 135 | 130 | 265 | ||||||||||||||||||||||||||||||||
2039863 | 2039863 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000024 | 50505 | Agawam High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 243 | 4 | 18 | 0 | 8 | 0 | 4 | 145 | 132 | 277.0 | 243 | 4 | 18 | 0 | 8 | 0 | 4 | 145 | 132 | 277 | |||||||||||||||||||||||||||||||||
2228820 | 2228820 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000024 | 50505 | Agawam: Agawam High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 245 | 5 | 13 | 0 | 6 | 1 | 7 | 155 | 122 | 277.0 | 245 | 5 | 13 | 0 | 6 | 1 | 7 | 155 | 122 | 277 | |||||||||||||||||||||||||||||||||
744623 | 744623 | MA | Worcester | school | 2508910 | 730 | Northboro-Southboro | 250891001441 | 7300505 | Algonquin Regional High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 317 | 2 | 8 | 0 | 22 | 3 | 2 | 164 | 190 | 354 | 317 | 2 | 8 | 0 | 22 | 3 | 2 | 164 | 190 | 354 | |||||||||||||||||||||||||||||||||
941447 | 941447 | MA | Worcester | school | 2508910 | 730 | Northboro-Southboro | 250891001441 | 7300505 | Algonquin Regional High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 316 | 4 | 12 | 0 | 31 | 3 | 7 | 178 | 195 | 373 | 316 | 4 | 12 | 0 | 31 | 3 | 7 | 178 | 195 | 373 | |||||||||||||||||||||||||||||||||
1132499 | 1132499 | MA | Worcester | school | 2508910 | 730 | Northboro-Southboro | 250891001441 | 7300505 | Algonquin Regional High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 295 | 5 | 14 | 0 | 34 | 2 | 7 | 174 | 183 | 357 | 295 | 5 | 14 | 0 | 34 | 2 | 7 | 174 | 183 | 357 | |||||||||||||||||||||||||||||||||
1373692 | 1373692 | MA | Worcester | school | 2508910 | 730 | Northboro-Southboro | 250891001441 | 7300505 | Algonquin Regional High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 266 | 4 | 23 | 0 | 33 | 2 | 12 | 170 | 170 | * | 340.0 | 266 | 4 | 23 | 0 | 33 | 2 | 12 | 170 | 170 | 340 | ||||||||||||||||||||||||||||||||
2048753 | 2048753 | MA | Worcester | school | 2508910 | 730 | Northboro-Southboro | 250891001441 | 7300505 | Algonquin Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 301 | 4 | 14 | 2 | 37 | 0 | 10 | 172 | 196 | 368.0 | 301 | 4 | 14 | 2 | 37 | 0 | 10 | 172 | 196 | 368 | |||||||||||||||||||||||||||||||||
1672081 | 1672081 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000034 | 70505 | Amesbury - Amesbury High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 116 | 4 | 11 | 0 | 3 | 0 | 6 | 70 | 70 | * | 140.0 | 116 | 4 | 11 | 0 | 3 | 0 | 6 | 70 | 70 | 140 | ||||||||||||||||||||||||||||||||
1672085 | 1672085 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186002841 | 70515 | Amesbury - Amesbury Innovation High School | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 14 | 0 | 1 | 0 | 0 | 0 | 2 | 11 | 6 | * | 17.0 | 14 | 0 | 1 | 0 | 0 | 0 | 2 | 11 | 6 | 17 | ||||||||||||||||||||||||||||||||
743450 | 743450 | MA | Essex | school | 2500069 | 415 | Amesbury Academy Charter Public (District) | 250006901666 | 4150505 | Amesbury Academy Charter Public School | Regular School | Yes | 3 | 09 | 12 | 2015 | grade_12 | 10 | 0 | 1 | 0 | 1 | 0 | 1 | 6 | 7 | 13 | 10 | 0 | 1 | 0 | 1 | 0 | 1 | 6 | 7 | 13 | |||||||||||||||||||||||||||||||||
735733 | 735733 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000034 | 70505 | Amesbury High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 128 | 0 | 4 | 0 | 2 | 0 | 2 | 73 | 63 | 136 | 128 | 0 | 4 | 0 | 2 | 0 | 2 | 73 | 63 | 136 | |||||||||||||||||||||||||||||||||
932611 | 932611 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000034 | 70505 | Amesbury High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 145 | 1 | 9 | 0 | 2 | 0 | 7 | 85 | 79 | 164 | 145 | 1 | 9 | 0 | 2 | 0 | 7 | 85 | 79 | 164 | |||||||||||||||||||||||||||||||||
1122038 | 1122038 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000034 | 70505 | Amesbury High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 152 | 2 | 7 | 0 | 1 | 0 | 1 | 83 | 80 | 163 | 152 | 2 | 7 | 0 | 1 | 0 | 1 | 83 | 80 | 163 | |||||||||||||||||||||||||||||||||
1364857 | 1364857 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000034 | 70505 | Amesbury High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 132 | 0 | 6 | 0 | 2 | 0 | 2 | 71 | 71 | * | 142.0 | 132 | 0 | 6 | 0 | 2 | 0 | 2 | 71 | 71 | 142 | ||||||||||||||||||||||||||||||||
2039884 | 2039884 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000034 | 70505 | Amesbury High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 114 | 3 | 11 | 0 | 3 | 0 | 7 | 76 | 62 | 138.0 | 114 | 3 | 11 | 0 | 3 | 0 | 7 | 76 | 62 | 138 | |||||||||||||||||||||||||||||||||
932614 | 932614 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186002841 | 70515 | Amesbury Innovation High School | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | 7 | 0 | 1 | 0 | 0 | 0 | 0 | 4 | 4 | 8 | |||||||||||||||||||||||||||||||||
1122043 | 1122043 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186002841 | 70515 | Amesbury Innovation High School | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | 10 | 0 | 1 | 0 | 0 | 0 | 0 | 7 | 4 | 11 | |||||||||||||||||||||||||||||||||
1364862 | 1364862 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186002841 | 70515 | Amesbury Innovation High School | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 15 | 2 | 1 | 0 | 0 | 0 | 1 | 8 | 11 | * | 19.0 | 15 | 2 | 1 | 0 | 0 | 0 | 1 | 8 | 11 | 19 | ||||||||||||||||||||||||||||||||
2039889 | 2039889 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186002841 | 70515 | Amesbury Innovation High School | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 13 | 1 | 1 | 0 | 0 | 0 | 0 | 11 | 4 | 15.0 | 13 | 1 | 1 | 0 | 0 | 0 | 0 | 11 | 4 | 15 | |||||||||||||||||||||||||||||||||
2228844 | 2228844 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186000034 | 70505 | Amesbury: Amesbury High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 136 | 1 | 6 | 0 | 2 | 0 | 2 | 86 | 61 | 147.0 | 136 | 1 | 6 | 0 | 2 | 0 | 2 | 86 | 61 | 147 | |||||||||||||||||||||||||||||||||
2228849 | 2228849 | MA | Essex | school | 2501860 | 7 | Amesbury | 250186002841 | 70515 | Amesbury: Amesbury Innovation High School | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 10 | 0 | 0 | 0 | 0 | 0 | 3 | 9 | 4 | 13.0 | 10 | 0 | 0 | 0 | 0 | 0 | 3 | 9 | 4 | 13 | |||||||||||||||||||||||||||||||||
743996 | 743996 | MA | Hampshire | school | 2501920 | 605 | Amherst-Pelham | 250192000042 | 6050505 | Amherst Regional High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 152 | 27 | 43 | 0 | 20 | 0 | 21 | 138 | 125 | 263 | 152 | 27 | 43 | 0 | 20 | 0 | 21 | 138 | 125 | 263 | |||||||||||||||||||||||||||||||||
940830 | 940830 | MA | Hampshire | school | 2501920 | 605 | Amherst-Pelham | 250192000042 | 6050505 | Amherst Regional High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 144 | 20 | 33 | 0 | 21 | 0 | 19 | 128 | 109 | 237 | 144 | 20 | 33 | 0 | 21 | 0 | 19 | 128 | 109 | 237 | |||||||||||||||||||||||||||||||||
1131771 | 1131771 | MA | Hampshire | school | 2501920 | 605 | Amherst-Pelham | 250192000042 | 6050505 | Amherst Regional High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 142 | 14 | 26 | 0 | 23 | 0 | 23 | 113 | 115 | 228 | 142 | 14 | 26 | 0 | 23 | 0 | 23 | 113 | 115 | 228 | |||||||||||||||||||||||||||||||||
1373049 | 1373049 | MA | Hampshire | school | 2501920 | 605 | Amherst-Pelham | 250192000042 | 6050505 | Amherst Regional High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 132 | 17 | 40 | 1 | 21 | 0 | 20 | 120 | 109 | * | 231.0 | 132 | 17 | 40 | 1 | 21 | 0 | 20 | 120 | 109 | 231 | ||||||||||||||||||||||||||||||||
2048122 | 2048122 | MA | Hampshire | school | 2501920 | 605 | Amherst-Pelham | 250192000042 | 6050505 | Amherst Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 128 | 16 | 40 | 0 | 20 | 0 | 21 | 119 | 105 | 225.0 | 128 | 16 | 40 | 0 | 20 | 0 | 21 | 119 | 105 | 225 | |||||||||||||||||||||||||||||||||
1680313 | 1680313 | MA | Hampshire | school | 2501920 | 605 | Amherst-Pelham | 250192000042 | 6050505 | Amherst-Pelham - Amherst Regional High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 121 | 13 | 40 | 0 | 23 | 0 | 27 | 104 | 119 | * | 224.0 | 121 | 13 | 40 | 0 | 23 | 0 | 27 | 104 | 119 | 224 | ||||||||||||||||||||||||||||||||
2238602 | 2238602 | MA | Hampshire | school | 2501920 | 605 | Amherst-Pelham | 250192000042 | 6050505 | Amherst-Pelham: Amherst Regional High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 131 | 22 | 29 | 0 | 25 | 0 | 21 | 126 | 102 | 228.0 | 131 | 22 | 29 | 0 | 25 | 0 | 21 | 126 | 102 | 228 | |||||||||||||||||||||||||||||||||
1672151 | 1672151 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover - Andover High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 304 | 9 | 25 | 0 | 97 | 0 | 11 | 196 | 249 | * | 446.0 | 304 | 9 | 25 | 0 | 97 | 0 | 11 | 196 | 249 | 446 | ||||||||||||||||||||||||||||||||
735804 | 735804 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 326 | 5 | 20 | 1 | 53 | 0 | 10 | 199 | 216 | 415 | 326 | 5 | 20 | 1 | 53 | 0 | 10 | 199 | 216 | 415 | |||||||||||||||||||||||||||||||||
932680 | 932680 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 329 | 5 | 16 | 2 | 65 | 0 | 12 | 210 | 219 | 429 | 329 | 5 | 16 | 2 | 65 | 0 | 12 | 210 | 219 | 429 | |||||||||||||||||||||||||||||||||
1122122 | 1122122 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 354 | 11 | 25 | 0 | 61 | 0 | 11 | 239 | 223 | 462 | 354 | 11 | 25 | 0 | 61 | 0 | 11 | 239 | 223 | 462 | |||||||||||||||||||||||||||||||||
1364928 | 1364928 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 314 | 10 | 23 | 0 | 67 | 0 | 10 | 210 | 214 | * | 424.0 | 314 | 10 | 23 | 0 | 67 | 0 | 10 | 210 | 214 | 424 | ||||||||||||||||||||||||||||||||
2039955 | 2039955 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 338 | 11 | 19 | 0 | 66 | 0 | 11 | 195 | 250 | 445.0 | 338 | 11 | 19 | 0 | 66 | 0 | 11 | 195 | 250 | 445 | |||||||||||||||||||||||||||||||||
2228928 | 2228928 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover: Andover High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 311 | 9 | 19 | 0 | 64 | 0 | 8 | 197 | 213 | 411.0 | 311 | 9 | 19 | 0 | 64 | 0 | 8 | 197 | 213 | 411 | |||||||||||||||||||||||||||||||||
736844 | 736844 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000698 | 350541 | Another Course To College | Alternative Education School | No | 3 | 09 | 12 | 2015 | grade_12 | 5 | 29 | 20 | 0 | 1 | 0 | 0 | 30 | 25 | 55 | 5 | 29 | 20 | 0 | 1 | 0 | 0 | 30 | 25 | 55 | |||||||||||||||||||||||||||||||||
933709 | 933709 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000698 | 350541 | Another Course To College | Alternative Education School | No | 3 | 09 | 12 | 2016 | grade_12 | 3 | 26 | 24 | 0 | 5 | 0 | 1 | 20 | 39 | 59 | 3 | 26 | 24 | 0 | 5 | 0 | 1 | 20 | 39 | 59 | |||||||||||||||||||||||||||||||||
1123323 | 1123323 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000698 | 350541 | Another Course To College | Alternative School | No | High | 09 | 12 | 2017 | grade_12 | 4 | 23 | 20 | 1 | 6 | 0 | 3 | 23 | 34 | 57 | 4 | 23 | 20 | 1 | 6 | 0 | 3 | 23 | 34 | 57 | |||||||||||||||||||||||||||||||||
1365947 | 1365947 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000698 | 350541 | Another Course To College | Alternative School | No | High | 09 | 12 | 2020 | grade_12 | 8 | 24 | 21 | 0 | 0 | 0 | 2 | 24 | 31 | * | 55.0 | 8 | 24 | 21 | 0 | 0 | 0 | 2 | 24 | 31 | 55 | ||||||||||||||||||||||||||||||||
2040991 | 2040991 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000698 | 350541 | Another Course To College | Alternative School | No | High | 09 | 12 | 2019 | grade_12 | 6 | 25 | 23 | 0 | 2 | 0 | 1 | 29 | 28 | 57.0 | 6 | 25 | 23 | 0 | 2 | 0 | 1 | 29 | 28 | 57 | |||||||||||||||||||||||||||||||||
744293 | 744293 | MA | Bristol | school | 2505070 | 665 | Freetown-Lakeville | 250507000746 | 6650505 | Apponequet Regional High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 191 | 0 | 4 | 1 | 1 | 0 | 4 | 95 | 106 | 201 | 191 | 0 | 4 | 1 | 1 | 0 | 4 | 95 | 106 | 201 | |||||||||||||||||||||||||||||||||
941119 | 941119 | MA | Bristol | school | 2505070 | 665 | Freetown-Lakeville | 250507000746 | 6650505 | Apponequet Regional High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 181 | 2 | 2 | 0 | 1 | 0 | 4 | 81 | 109 | 190 | 181 | 2 | 2 | 0 | 1 | 0 | 4 | 81 | 109 | 190 | |||||||||||||||||||||||||||||||||
1132116 | 1132116 | MA | Bristol | school | 2505070 | 665 | Freetown-Lakeville | 250507000746 | 6650505 | Apponequet Regional High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 146 | 1 | 3 | 1 | 1 | 0 | 1 | 67 | 86 | 153 | 146 | 1 | 3 | 1 | 1 | 0 | 1 | 67 | 86 | 153 | |||||||||||||||||||||||||||||||||
1373349 | 1373349 | MA | Bristol | school | 2505070 | 665 | Freetown-Lakeville | 250507000746 | 6650505 | Apponequet Regional High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 169 | 2 | 2 | 0 | 1 | 1 | 0 | 91 | 84 | * | 175.0 | 169 | 2 | 2 | 0 | 1 | 1 | 0 | 91 | 84 | 175 | ||||||||||||||||||||||||||||||||
2048413 | 2048413 | MA | Plymouth | school | 2505070 | 665 | Freetown-Lakeville | 250507000746 | 6650505 | Apponequet Regional High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 174 | 3 | 4 | 1 | 2 | 0 | 8 | 97 | 95 | 192.0 | 174 | 3 | 4 | 1 | 2 | 0 | 8 | 97 | 95 | 192 | |||||||||||||||||||||||||||||||||
1681480 | 1681480 | MA | Bristol | school | 2500552 | 3509 | Argosy Collegiate Charter School (District) | 250055202827 | 35090305 | Argosy Collegiate Charter School (District) - Argosy Collegiate Charter School | Regular School | Yes | Secondary | 06 | 11 | 2021 | grade_12 | 15 | 7 | 7 | 0 | 1 | 0 | 1 | 15 | 16 | * | 31.0 | 15 | 7 | 7 | 0 | 1 | 0 | 1 | 15 | 16 | 31 | ||||||||||||||||||||||||||||||||
1672202 | 1672202 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington - Arlington High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 246 | 11 | 20 | 0 | 42 | 0 | 16 | 165 | 168 | * | 335.0 | 246 | 11 | 20 | 0 | 42 | 0 | 16 | 165 | 168 | 335 | ||||||||||||||||||||||||||||||||
735855 | 735855 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 244 | 10 | 16 | 0 | 33 | 1 | 8 | 158 | 154 | 312 | 244 | 10 | 16 | 0 | 33 | 1 | 8 | 158 | 154 | 312 | |||||||||||||||||||||||||||||||||
932731 | 932731 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington High | Regular School | No | 3 | 09 | 12 | 2016 | grade_12 | 246 | 14 | 14 | 1 | 40 | 0 | 3 | 146 | 172 | 318 | 246 | 14 | 14 | 1 | 40 | 0 | 3 | 146 | 172 | 318 | |||||||||||||||||||||||||||||||||
1122182 | 1122182 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 226 | 7 | 13 | 0 | 36 | 1 | 12 | 142 | 153 | 295 | 226 | 7 | 13 | 0 | 36 | 1 | 12 | 142 | 153 | 295 | |||||||||||||||||||||||||||||||||
1364979 | 1364979 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 260 | 13 | 22 | 0 | 33 | 1 | 8 | 182 | 153 | * | 337.0 | 260 | 13 | 22 | 0 | 33 | 1 | 8 | 182 | 153 | 337 | ||||||||||||||||||||||||||||||||
2040006 | 2040006 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000053 | 100505 | Arlington High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 245 | 13 | 21 | 0 | 46 | 0 | 19 | 156 | 188 | 344.0 | 245 | 13 | 21 | 0 | 46 | 0 | 19 | 156 | 188 | 344 |
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]);