enrollments
Data source: Big Local News · About: Big Local
3,471 rows where grade = "grade_7" and state = "MA" sorted by white_int descending
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2235071 | 2235071 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972002531 | 2390405 | Plymouth: Plymouth Commun Intermediate | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 277 | 9 | 16 | 1 | 10 | 0 | 8 | 181 | 139 | 321.0 | 277 | 9 | 16 | 1 | 10 | 0 | 8 | 181 | 139 | 321 | |||||||||||||||||||||||||||||||||
735708 | 735708 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000025 | 50405 | Agawam Junior High | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 276 | 3 | 12 | 0 | 5 | 0 | 4 | 153 | 147 | 300 | 276 | 3 | 12 | 0 | 5 | 0 | 4 | 153 | 147 | 300 | |||||||||||||||||||||||||||||||||
1365095 | 1365095 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002678 | 200315 | Barnstable Intermediate School | Regular School | No | Middle | 06 | 07 | 2020 | grade_7 | 274 | 28 | 53 | 0 | 9 | 2 | 15 | 190 | 191 | * | 381.0 | 274 | 28 | 53 | 0 | 9 | 2 | 15 | 190 | 191 | 381 | ||||||||||||||||||||||||||||||||
1366812 | 1366812 | MA | Bristol | school | 2504020 | 72 | Dartmouth | 250402000541 | 720050 | Dartmouth Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 274 | 3 | 11 | 0 | 2 | 1 | 16 | 173 | 134 | * | 307.0 | 274 | 3 | 11 | 0 | 2 | 1 | 16 | 173 | 134 | 307 | ||||||||||||||||||||||||||||||||
1680788 | 1680788 | MA | Essex | school | 2507410 | 705 | Masconomet | 250741001097 | 7050405 | Masconomet - Masconomet Regional Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 274 | 3 | 11 | 0 | 9 | 1 | 16 | 149 | 165 | * | 314.0 | 274 | 3 | 11 | 0 | 9 | 1 | 16 | 149 | 165 | 314 | ||||||||||||||||||||||||||||||||
2238571 | 2238571 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000013 | 6000405 | Acton-Boxborough: Raymond J Grey Junior High | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 273 | 14 | 15 | 0 | 173 | 0 | 11 | 257 | 229 | 486.0 | 273 | 14 | 15 | 0 | 173 | 0 | 11 | 257 | 229 | 486 | |||||||||||||||||||||||||||||||||
1679308 | 1679308 | MA | Middlesex | school | 2513110 | 344 | Winchester | 251311002167 | 3440305 | Winchester - McCall Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 272 | 7 | 9 | 0 | 71 | 0 | 29 | 205 | 183 | * | 388.0 | 272 | 7 | 9 | 0 | 71 | 0 | 29 | 205 | 183 | 388 | ||||||||||||||||||||||||||||||||
2046730 | 2046730 | MA | Norfolk | school | 2512270 | 317 | Wellesley | 251227002029 | 3170305 | Wellesley Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 272 | 13 | 32 | 1 | 46 | 0 | 15 | 184 | 195 | 379.0 | 272 | 13 | 32 | 1 | 46 | 0 | 15 | 184 | 195 | 379 | |||||||||||||||||||||||||||||||||
932586 | 932586 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000025 | 50405 | Agawam Junior High | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 271 | 2 | 23 | 0 | 1 | 0 | 8 | 141 | 164 | 305 | 271 | 2 | 23 | 0 | 1 | 0 | 8 | 141 | 164 | 305 | |||||||||||||||||||||||||||||||||
735850 | 735850 | MA | Middlesex | school | 2501980 | 10 | Arlington | 250198000063 | 100410 | Ottoson Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 269 | 11 | 17 | 0 | 33 | 1 | 10 | 183 | 158 | 341 | 269 | 11 | 17 | 0 | 33 | 1 | 10 | 183 | 158 | 341 | |||||||||||||||||||||||||||||||||
2229296 | 2229296 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000165 | 300305 | Beverly: Briscoe Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 269 | 10 | 32 | 0 | 6 | 0 | 12 | 170 | 159 | 329.0 | 269 | 10 | 32 | 0 | 6 | 0 | 12 | 170 | 159 | 329 | |||||||||||||||||||||||||||||||||
737702 | 737702 | MA | Essex | school | 2503990 | 71 | Danvers | 250399002517 | 710305 | Holten Richmond Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 268 | 3 | 13 | 0 | 9 | 0 | 3 | 155 | 141 | 296 | 268 | 3 | 13 | 0 | 9 | 0 | 3 | 155 | 141 | 296 | |||||||||||||||||||||||||||||||||
1367745 | 1367745 | MA | Plymouth | school | 2506090 | 131 | Hingham | 250609000875 | 1310410 | Hingham Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 268 | 5 | 9 | 0 | 12 | 0 | 13 | 152 | 155 | * | 307.0 | 268 | 5 | 9 | 0 | 12 | 0 | 13 | 152 | 155 | 307 | ||||||||||||||||||||||||||||||||
1369583 | 1369583 | MA | Essex | school | 2508700 | 211 | North Andover | 250870001398 | 2110305 | North Andover Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 268 | 12 | 42 | 2 | 28 | 0 | 13 | 182 | 183 | * | 365.0 | 268 | 12 | 42 | 2 | 28 | 0 | 13 | 182 | 183 | 365 | ||||||||||||||||||||||||||||||||
2231174 | 2231174 | MA | Bristol | school | 2504020 | 72 | Dartmouth | 250402000541 | 720050 | Dartmouth: Dartmouth Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 268 | 6 | 12 | 0 | 0 | 0 | 19 | 178 | 127 | 305.0 | 268 | 6 | 12 | 0 | 0 | 0 | 19 | 178 | 127 | 305 | |||||||||||||||||||||||||||||||||
939080 | 939080 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158000366 | 2950305 | John W. Wynn Middle | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 267 | 9 | 7 | 0 | 10 | 0 | 4 | 145 | 152 | 297 | 267 | 9 | 7 | 0 | 10 | 0 | 4 | 145 | 152 | 297 | |||||||||||||||||||||||||||||||||
1126609 | 1126609 | MA | Bristol | school | 2507230 | 167 | Mansfield | 250723001112 | 1670035 | Harold L Qualters Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 267 | 9 | 10 | 0 | 18 | 0 | 14 | 162 | 156 | 318 | 267 | 9 | 10 | 0 | 18 | 0 | 14 | 162 | 156 | 318 | |||||||||||||||||||||||||||||||||
1130564 | 1130564 | MA | Middlesex | school | 2513050 | 342 | Wilmington | 251305001578 | 3420330 | Wilmington Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 267 | 5 | 16 | 1 | 11 | 0 | 8 | 161 | 147 | 308 | 267 | 5 | 16 | 1 | 11 | 0 | 8 | 161 | 147 | 308 | |||||||||||||||||||||||||||||||||
932982 | 932982 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000165 | 300305 | Briscoe Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 266 | 11 | 33 | 0 | 9 | 0 | 9 | 173 | 155 | 328 | 266 | 11 | 33 | 0 | 9 | 0 | 9 | 173 | 155 | 328 | |||||||||||||||||||||||||||||||||
935652 | 935652 | MA | Middlesex | school | 2506330 | 139 | Hopkinton | 250633000468 | 1390305 | Hopkinton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 266 | 3 | 2 | 1 | 34 | 0 | 2 | 149 | 159 | 308 | 266 | 3 | 2 | 1 | 34 | 0 | 2 | 149 | 159 | 308 | |||||||||||||||||||||||||||||||||
1130124 | 1130124 | MA | Norfolk | school | 2512270 | 317 | Wellesley | 251227002029 | 3170305 | Wellesley Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 266 | 17 | 18 | 0 | 29 | 0 | 20 | 169 | 181 | 350 | 266 | 17 | 18 | 0 | 29 | 0 | 20 | 169 | 181 | 350 | |||||||||||||||||||||||||||||||||
1678907 | 1678907 | MA | Norfolk | school | 2512270 | 317 | Wellesley | 251227002029 | 3170305 | Wellesley - Wellesley Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 265 | 15 | 22 | 0 | 57 | 0 | 23 | 174 | 208 | * | 382.0 | 265 | 15 | 22 | 0 | 57 | 0 | 23 | 174 | 208 | 382 | ||||||||||||||||||||||||||||||||
2048974 | 2048974 | MA | Worcester | school | 2511490 | 770 | Tantasqua | 251149001899 | 7700405 | Tantasqua Regional Jr High | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 265 | 4 | 17 | 0 | 2 | 0 | 7 | 159 | 136 | 295.0 | 265 | 4 | 17 | 0 | 2 | 0 | 7 | 159 | 136 | 295 | |||||||||||||||||||||||||||||||||
743018 | 743018 | MA | Middlesex | school | 2513110 | 344 | Winchester | 251311002167 | 3440305 | McCall Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 264 | 6 | 13 | 1 | 66 | 0 | 15 | 172 | 193 | 365 | 264 | 6 | 13 | 1 | 66 | 0 | 15 | 172 | 193 | 365 | |||||||||||||||||||||||||||||||||
932845 | 932845 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002678 | 200315 | Barnstable Intermediate School | Regular School | No | 2 | 06 | 07 | 2016 | grade_7 | 264 | 27 | 42 | 1 | 3 | 2 | 13 | 203 | 149 | 352 | 264 | 27 | 42 | 1 | 3 | 2 | 13 | 203 | 149 | 352 | |||||||||||||||||||||||||||||||||
1130633 | 1130633 | MA | Middlesex | school | 2513110 | 344 | Winchester | 251311002167 | 3440305 | McCall Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 264 | 0 | 14 | 1 | 66 | 1 | 19 | 178 | 187 | 365 | 264 | 0 | 14 | 1 | 66 | 1 | 19 | 178 | 187 | 365 | |||||||||||||||||||||||||||||||||
2040121 | 2040121 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002678 | 200315 | Barnstable Intermediate School | Regular School | No | Middle | 06 | 07 | 2019 | grade_7 | 264 | 27 | 65 | 0 | 8 | 0 | 18 | 207 | 175 | 382.0 | 264 | 27 | 65 | 0 | 8 | 0 | 18 | 207 | 175 | 382 | |||||||||||||||||||||||||||||||||
2231405 | 2231405 | MA | Bristol | school | 2504620 | 88 | Easton | 250462000618 | 880405 | Easton: Easton Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 264 | 18 | 10 | 0 | 10 | 0 | 3 | 157 | 148 | 305.0 | 264 | 18 | 10 | 0 | 10 | 0 | 3 | 157 | 148 | 305 | |||||||||||||||||||||||||||||||||
939163 | 939163 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191000776 | 3050310 | Galvin Middle School | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 263 | 10 | 15 | 1 | 3 | 1 | 2 | 150 | 145 | 295 | 263 | 10 | 15 | 1 | 3 | 1 | 2 | 150 | 145 | 295 | |||||||||||||||||||||||||||||||||
941675 | 941675 | MA | Worcester | school | 2511490 | 770 | Tantasqua | 251149001899 | 7700405 | Tantasqua Regional Jr High | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 263 | 1 | 12 | 0 | 2 | 0 | 3 | 128 | 153 | 281 | 263 | 1 | 12 | 0 | 2 | 0 | 3 | 128 | 153 | 281 | |||||||||||||||||||||||||||||||||
742355 | 742355 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191000776 | 3050310 | Galvin Middle School | Regular School | No | 2 | 05 | 08 | 2015 | grade_7 | 262 | 3 | 11 | 1 | 10 | 0 | 9 | 150 | 146 | 296 | 262 | 3 | 11 | 1 | 10 | 0 | 9 | 150 | 146 | 296 | |||||||||||||||||||||||||||||||||
743965 | 743965 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000013 | 6000405 | Raymond J Grey Junior High | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 262 | 7 | 10 | 2 | 131 | 0 | 16 | 220 | 208 | 428 | 262 | 7 | 10 | 2 | 131 | 0 | 16 | 220 | 208 | 428 | |||||||||||||||||||||||||||||||||
1132769 | 1132769 | MA | Worcester | school | 2511490 | 770 | Tantasqua | 251149001899 | 7700405 | Tantasqua Regional Jr High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 262 | 2 | 12 | 0 | 5 | 0 | 12 | 142 | 151 | 293 | 262 | 2 | 12 | 0 | 5 | 0 | 12 | 142 | 151 | 293 | |||||||||||||||||||||||||||||||||
2043856 | 2043856 | MA | Plymouth | school | 2507350 | 171 | Marshfield | 250735001143 | 1710310 | Furnace Brook Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 262 | 0 | 9 | 0 | 3 | 0 | 6 | 141 | 139 | 280.0 | 262 | 0 | 9 | 0 | 3 | 0 | 6 | 141 | 139 | 280 | |||||||||||||||||||||||||||||||||
2229129 | 2229129 | MA | Barnstable | school | 2502310 | 20 | Barnstable | 250231002678 | 200315 | Barnstable: Barnstable Intermediate School | Regular School | No | Middle | 06 | 07 | 2018 | grade_7 | 262 | 27 | 38 | 2 | 5 | 0 | 25 | 160 | 199 | 359.0 | 262 | 27 | 38 | 2 | 5 | 0 | 25 | 160 | 199 | 359 | |||||||||||||||||||||||||||||||||
2239584 | 2239584 | MA | Worcester | school | 2511490 | 770 | Tantasqua | 251149001899 | 7700405 | Tantasqua: Tantasqua Regional Jr High | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 262 | 1 | 13 | 1 | 3 | 0 | 13 | 149 | 144 | 293.0 | 262 | 1 | 13 | 1 | 3 | 0 | 13 | 149 | 144 | 293 | |||||||||||||||||||||||||||||||||
1373900 | 1373900 | MA | Worcester | school | 2511490 | 770 | Tantasqua | 251149001899 | 7700405 | Tantasqua Regional Jr High | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 261 | 3 | 16 | 1 | 1 | 1 | 10 | 154 | 139 | * | 293.0 | 261 | 3 | 16 | 1 | 1 | 1 | 10 | 154 | 139 | 293 | ||||||||||||||||||||||||||||||||
1681149 | 1681149 | MA | Worcester | school | 2511490 | 770 | Tantasqua | 251149001899 | 7700405 | Tantasqua - Tantasqua Regional Jr High | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 261 | 7 | 18 | 1 | 4 | 0 | 8 | 156 | 143 | * | 299.0 | 261 | 7 | 18 | 1 | 4 | 0 | 8 | 156 | 143 | 299 | ||||||||||||||||||||||||||||||||
2239505 | 2239505 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001721 | 7600405 | Silver Lake: Silver Lake Regional Middle School | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 261 | 3 | 4 | 0 | 2 | 0 | 1 | 144 | 127 | 271.0 | 261 | 3 | 4 | 0 | 2 | 0 | 1 | 144 | 127 | 271 | |||||||||||||||||||||||||||||||||
939770 | 939770 | MA | Middlesex | school | 2513050 | 342 | Wilmington | 251305001578 | 3420330 | Wilmington Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 260 | 4 | 9 | 0 | 15 | 0 | 10 | 146 | 152 | 298 | 260 | 4 | 9 | 0 | 15 | 0 | 10 | 146 | 152 | 298 | |||||||||||||||||||||||||||||||||
1131734 | 1131734 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000013 | 6000405 | Raymond J Grey Junior High | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 260 | 8 | 22 | 0 | 151 | 0 | 28 | 236 | 233 | 469 | 260 | 8 | 22 | 0 | 151 | 0 | 28 | 236 | 233 | 469 | |||||||||||||||||||||||||||||||||
1371182 | 1371182 | MA | Middlesex | school | 2511340 | 288 | Sudbury | 251134001872 | 2880305 | Ephraim Curtis Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 260 | 12 | 18 | 0 | 31 | 1 | 22 | 158 | 186 | * | 344.0 | 260 | 12 | 18 | 0 | 31 | 1 | 22 | 158 | 186 | 344 | ||||||||||||||||||||||||||||||||
1676035 | 1676035 | MA | Plymouth | school | 2507350 | 171 | Marshfield | 250735001143 | 1710310 | Marshfield - Furnace Brook Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 260 | 2 | 15 | 0 | 5 | 1 | 3 | 145 | 141 | * | 286.0 | 260 | 2 | 15 | 0 | 5 | 1 | 3 | 145 | 141 | 286 | ||||||||||||||||||||||||||||||||
1132680 | 1132680 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001721 | 7600405 | Silver Lake Regional Middle School | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 259 | 4 | 3 | 0 | 3 | 0 | 2 | 148 | 123 | 271 | 259 | 4 | 3 | 0 | 3 | 0 | 2 | 148 | 123 | 271 | |||||||||||||||||||||||||||||||||
737839 | 737839 | MA | Plymouth | school | 2504410 | 82 | Duxbury | 250441000975 | 820305 | Duxbury Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 258 | 1 | 4 | 0 | 1 | 0 | 3 | 136 | 131 | 267 | 258 | 1 | 4 | 0 | 1 | 0 | 3 | 136 | 131 | 267 | |||||||||||||||||||||||||||||||||
934678 | 934678 | MA | Middlesex | school | 2504320 | 79 | Dracut | 250432001625 | 790410 | Justus C. Richardson Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 258 | 19 | 23 | 0 | 16 | 0 | 4 | 167 | 153 | 320 | 258 | 19 | 23 | 0 | 16 | 0 | 4 | 167 | 153 | 320 | |||||||||||||||||||||||||||||||||
1371657 | 1371657 | MA | Norfolk | school | 2512270 | 317 | Wellesley | 251227002029 | 3170305 | Wellesley Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 258 | 20 | 12 | 0 | 65 | 0 | 27 | 168 | 213 | * | 382.0 | 258 | 20 | 12 | 0 | 65 | 0 | 27 | 168 | 213 | 382 | ||||||||||||||||||||||||||||||||
2228814 | 2228814 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000025 | 50405 | Agawam: Agawam Junior High | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 257 | 7 | 26 | 0 | 13 | 0 | 8 | 164 | 147 | 311.0 | 257 | 7 | 26 | 0 | 13 | 0 | 8 | 164 | 147 | 311 | |||||||||||||||||||||||||||||||||
2231686 | 2231686 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000687 | 960405 | Falmouth: Lawrence | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 257 | 17 | 16 | 1 | 5 | 1 | 15 | 151 | 161 | 312.0 | 257 | 17 | 16 | 1 | 5 | 1 | 15 | 151 | 161 | 312 | |||||||||||||||||||||||||||||||||
940798 | 940798 | MA | Middlesex | school | 2501710 | 600 | Acton-Boxborough | 250171000013 | 6000405 | Raymond J Grey Junior High | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 256 | 12 | 11 | 1 | 142 | 0 | 23 | 247 | 198 | 445 | 256 | 12 | 11 | 1 | 142 | 0 | 23 | 247 | 198 | 445 | |||||||||||||||||||||||||||||||||
1676830 | 1676830 | MA | Essex | school | 2508700 | 211 | North Andover | 250870001398 | 2110305 | North Andover - North Andover Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 255 | 9 | 56 | 1 | 33 | 0 | 18 | 166 | 206 | * | 372.0 | 255 | 9 | 56 | 1 | 33 | 0 | 18 | 166 | 206 | 372 | ||||||||||||||||||||||||||||||||
1373524 | 1373524 | MA | Essex | school | 2507410 | 705 | Masconomet | 250741001097 | 7050405 | Masconomet Regional Middle School | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 254 | 2 | 4 | 0 | 5 | 0 | 0 | 137 | 128 | * | 265.0 | 254 | 2 | 4 | 0 | 5 | 0 | 0 | 137 | 128 | 265 | ||||||||||||||||||||||||||||||||
1676868 | 1676868 | MA | Bristol | school | 2508730 | 212 | North Attleborough | 250873001207 | 2120305 | North Attleborough - North Attleborough Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 254 | 13 | 19 | 1 | 24 | 0 | 14 | 152 | 173 | * | 325.0 | 254 | 13 | 19 | 1 | 24 | 0 | 14 | 152 | 173 | 325 | ||||||||||||||||||||||||||||||||
744854 | 744854 | MA | Worcester | school | 2511490 | 770 | Tantasqua | 251149001899 | 7700405 | Tantasqua Regional Jr High | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 252 | 2 | 16 | 1 | 3 | 0 | 8 | 132 | 150 | 282 | 252 | 2 | 16 | 1 | 3 | 0 | 8 | 132 | 150 | 282 | |||||||||||||||||||||||||||||||||
1129834 | 1129834 | MA | Middlesex | school | 2511910 | 305 | Wakefield | 251191000776 | 3050310 | Galvin Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 252 | 9 | 12 | 0 | 11 | 0 | 6 | 140 | 150 | 290 | 252 | 9 | 12 | 0 | 11 | 0 | 6 | 140 | 150 | 290 | |||||||||||||||||||||||||||||||||
2048408 | 2048408 | MA | Plymouth | school | 2505070 | 665 | Freetown-Lakeville | 250507000748 | 6650305 | Freetown-Lakeville Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 252 | 2 | 5 | 1 | 0 | 0 | 4 | 129 | 135 | 264.0 | 252 | 2 | 5 | 1 | 0 | 0 | 4 | 129 | 135 | 264 | |||||||||||||||||||||||||||||||||
1677846 | 1677846 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001825 | 2710030 | Shrewsbury - Oak Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 251 | 13 | 41 | 2 | 172 | 0 | 23 | 248 | 254 | * | 502.0 | 251 | 13 | 41 | 2 | 172 | 0 | 23 | 248 | 254 | 502 | ||||||||||||||||||||||||||||||||
1373187 | 1373187 | MA | Bristol | school | 2503030 | 625 | Bridgewater-Raynham | 250303002659 | 6250320 | Bridgewater Middle School | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 249 | 17 | 6 | 1 | 4 | 1 | 23 | 144 | 157 | * | 301.0 | 249 | 17 | 6 | 1 | 4 | 1 | 23 | 144 | 157 | 301 | ||||||||||||||||||||||||||||||||
1677321 | 1677321 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972002531 | 2390405 | Plymouth - Plymouth Commun Intermediate | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 249 | 11 | 39 | 0 | 3 | 0 | 19 | 158 | 163 | * | 321.0 | 249 | 11 | 39 | 0 | 3 | 0 | 19 | 158 | 163 | 321 | ||||||||||||||||||||||||||||||||
2049080 | 2049080 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188000888 | 7750305 | Mountview Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 249 | 3 | 15 | 1 | 10 | 0 | 5 | 132 | 151 | 283.0 | 249 | 3 | 15 | 1 | 10 | 0 | 5 | 132 | 151 | 283 | |||||||||||||||||||||||||||||||||
736113 | 736113 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000165 | 300305 | Briscoe Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 248 | 4 | 46 | 0 | 6 | 0 | 10 | 168 | 146 | 314 | 248 | 4 | 46 | 0 | 6 | 0 | 10 | 168 | 146 | 314 | |||||||||||||||||||||||||||||||||
744288 | 744288 | MA | Bristol | school | 2505070 | 665 | Freetown-Lakeville | 250507000748 | 6650305 | Freetown-Lakeville Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 248 | 3 | 1 | 0 | 3 | 1 | 2 | 151 | 107 | 258 | 248 | 3 | 1 | 0 | 3 | 1 | 2 | 151 | 107 | 258 | |||||||||||||||||||||||||||||||||
738151 | 738151 | MA | Barnstable | school | 2504860 | 96 | Falmouth | 250486000687 | 960405 | Lawrence | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 247 | 14 | 9 | 1 | 7 | 0 | 18 | 152 | 144 | 296 | 247 | 14 | 9 | 1 | 7 | 0 | 18 | 152 | 144 | 296 | |||||||||||||||||||||||||||||||||
738803 | 738803 | MA | Middlesex | school | 2506330 | 139 | Hopkinton | 250633000468 | 1390305 | Hopkinton Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 247 | 1 | 1 | 1 | 18 | 0 | 3 | 139 | 132 | 271 | 247 | 1 | 1 | 1 | 18 | 0 | 3 | 139 | 132 | 271 | |||||||||||||||||||||||||||||||||
934778 | 934778 | MA | Bristol | school | 2504620 | 88 | Easton | 250462000618 | 880405 | Easton Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 247 | 18 | 11 | 0 | 9 | 0 | 6 | 134 | 157 | 291 | 247 | 18 | 11 | 0 | 9 | 0 | 6 | 134 | 157 | 291 | |||||||||||||||||||||||||||||||||
1674041 | 1674041 | MA | Bristol | school | 2504020 | 72 | Dartmouth | 250402000541 | 720050 | Dartmouth - Dartmouth Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_7 | 247 | 3 | 17 | 0 | 1 | 0 | 12 | 125 | 155 | * | 280.0 | 247 | 3 | 17 | 0 | 1 | 0 | 12 | 125 | 155 | 280 | ||||||||||||||||||||||||||||||||
2236546 | 2236546 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158000366 | 2950305 | Tewksbury: John W. Wynn Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_7 | 247 | 7 | 5 | 1 | 7 | 0 | 2 | 143 | 126 | 269.0 | 247 | 7 | 5 | 1 | 7 | 0 | 2 | 143 | 126 | 269 | |||||||||||||||||||||||||||||||||
936773 | 936773 | MA | Plymouth | school | 2507770 | 182 | Middleborough | 250777001378 | 1820305 | John T. Nichols Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 246 | 4 | 9 | 0 | 2 | 0 | 5 | 139 | 127 | 266 | 246 | 4 | 9 | 0 | 2 | 0 | 5 | 139 | 127 | 266 | |||||||||||||||||||||||||||||||||
1128083 | 1128083 | MA | Plymouth | school | 2509420 | 231 | Pembroke | 250942001823 | 2310305 | Pembroke Community Middle School | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 246 | 0 | 3 | 0 | 4 | 0 | 3 | 118 | 138 | 256 | 246 | 0 | 3 | 0 | 4 | 0 | 3 | 118 | 138 | 256 | |||||||||||||||||||||||||||||||||
1367002 | 1367002 | MA | Bristol | school | 2504620 | 88 | Easton | 250462000618 | 880405 | Easton Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 246 | 28 | 17 | 0 | 7 | 0 | 9 | 150 | 157 | * | 307.0 | 246 | 28 | 17 | 0 | 7 | 0 | 9 | 150 | 157 | 307 | ||||||||||||||||||||||||||||||||
1681080 | 1681080 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001721 | 7600405 | Silver Lake - Silver Lake Regional Middle School | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 246 | 0 | 9 | 2 | 3 | 0 | 4 | 128 | 135 | * | 264.0 | 246 | 0 | 9 | 2 | 3 | 0 | 4 | 128 | 135 | 264 | ||||||||||||||||||||||||||||||||
941114 | 941114 | MA | Bristol | school | 2505070 | 665 | Freetown-Lakeville | 250507000748 | 6650305 | Freetown-Lakeville Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 245 | 1 | 2 | 0 | 2 | 0 | 3 | 130 | 123 | 253 | 245 | 1 | 2 | 0 | 2 | 0 | 3 | 130 | 123 | 253 | |||||||||||||||||||||||||||||||||
2040203 | 2040203 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000149 | 260305 | Winthrop L Chenery Middle | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 245 | 14 | 24 | 1 | 52 | 0 | 24 | 174 | 186 | 360.0 | 245 | 14 | 24 | 1 | 52 | 0 | 24 | 174 | 186 | 360 | |||||||||||||||||||||||||||||||||
2042074 | 2042074 | MA | Bristol | school | 2504620 | 88 | Easton | 250462000618 | 880405 | Easton Middle School | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 245 | 9 | 14 | 0 | 10 | 0 | 7 | 151 | 134 | 285.0 | 245 | 9 | 14 | 0 | 10 | 0 | 7 | 151 | 134 | 285 | |||||||||||||||||||||||||||||||||
744685 | 744685 | MA | Essex | school | 2509450 | 745 | Pentucket | 250945001512 | 7450405 | Pentucket Regional Middle | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 243 | 0 | 5 | 0 | 2 | 0 | 1 | 143 | 108 | 251 | 243 | 0 | 5 | 0 | 2 | 0 | 1 | 143 | 108 | 251 | |||||||||||||||||||||||||||||||||
934561 | 934561 | MA | Essex | school | 2503990 | 71 | Danvers | 250399002517 | 710305 | Holten Richmond Middle School | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 243 | 5 | 21 | 0 | 5 | 0 | 8 | 146 | 136 | 282 | 243 | 5 | 21 | 0 | 5 | 0 | 8 | 146 | 136 | 282 | |||||||||||||||||||||||||||||||||
938292 | 938292 | MA | Plymouth | school | 2510560 | 264 | Scituate | 251056001690 | 2640305 | Gates Intermediate School | Regular School | No | 2 | 07 | 08 | 2016 | grade_7 | 243 | 7 | 1 | 0 | 2 | 0 | 3 | 126 | 130 | 256 | 243 | 7 | 1 | 0 | 2 | 0 | 3 | 126 | 130 | 256 | |||||||||||||||||||||||||||||||||
1122422 | 1122422 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000149 | 260305 | Winthrop L Chenery Middle | Regular School | No | Middle | 05 | 08 | 2017 | grade_7 | 243 | 13 | 17 | 0 | 51 | 0 | 19 | 169 | 174 | 343 | 243 | 13 | 17 | 0 | 51 | 0 | 19 | 169 | 174 | 343 | |||||||||||||||||||||||||||||||||
1128788 | 1128788 | MA | Plymouth | school | 2510560 | 264 | Scituate | 251056001690 | 2640305 | Gates Intermediate School | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 243 | 9 | 0 | 0 | 6 | 0 | 3 | 126 | 135 | 261 | 243 | 9 | 0 | 0 | 6 | 0 | 3 | 126 | 135 | 261 | |||||||||||||||||||||||||||||||||
2040254 | 2040254 | MA | Essex | school | 2502640 | 30 | Beverly | 250264000165 | 300305 | Beverly Middle School | Regular School | No | Middle | 05 | 08 | 2019 | grade_7 | 243 | 9 | 50 | 0 | 9 | 0 | 9 | 172 | 148 | 320.0 | 243 | 9 | 50 | 0 | 9 | 0 | 9 | 172 | 148 | 320 | |||||||||||||||||||||||||||||||||
2046396 | 2046396 | MA | Middlesex | school | 2511580 | 295 | Tewksbury | 251158000366 | 2950305 | John W. Wynn Middle | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 243 | 9 | 9 | 0 | 12 | 0 | 2 | 149 | 126 | 275.0 | 243 | 9 | 9 | 0 | 12 | 0 | 2 | 149 | 126 | 275 | |||||||||||||||||||||||||||||||||
934693 | 934693 | MA | Plymouth | school | 2504410 | 82 | Duxbury | 250441000975 | 820305 | Duxbury Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 242 | 1 | 7 | 0 | 5 | 0 | 5 | 135 | 125 | 260 | 242 | 1 | 7 | 0 | 5 | 0 | 5 | 135 | 125 | 260 | |||||||||||||||||||||||||||||||||
1370595 | 1370595 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001825 | 2710030 | Oak Middle School | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 242 | 14 | 50 | 1 | 154 | 0 | 19 | 251 | 229 | * | 480.0 | 242 | 14 | 50 | 1 | 154 | 0 | 19 | 251 | 229 | 480 | ||||||||||||||||||||||||||||||||
1373832 | 1373832 | MA | Plymouth | school | 2510830 | 760 | Silver Lake | 251083001721 | 7600405 | Silver Lake Regional Middle School | Regular School | No | Middle | 07 | 08 | 2020 | grade_7 | 242 | 4 | 10 | 1 | 1 | 0 | 4 | 133 | 129 | * | 262.0 | 242 | 4 | 10 | 1 | 1 | 0 | 4 | 133 | 129 | 262 | ||||||||||||||||||||||||||||||||
2238941 | 2238941 | MA | Bristol | school | 2505070 | 665 | Freetown-Lakeville | 250507000748 | 6650305 | Freetown-Lakeville: Freetown-Lakeville Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 242 | 2 | 3 | 0 | 2 | 0 | 2 | 130 | 121 | 251.0 | 242 | 2 | 3 | 0 | 2 | 0 | 2 | 130 | 121 | 251 | |||||||||||||||||||||||||||||||||
741411 | 741411 | MA | Barnstable | school | 2510470 | 261 | Sandwich | 251047002824 | 2610305 | Sandwich STEM Academy | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 241 | 5 | 4 | 1 | 7 | 0 | 1 | 133 | 126 | 259 | 241 | 5 | 4 | 1 | 7 | 0 | 1 | 133 | 126 | 259 | |||||||||||||||||||||||||||||||||
743365 | 743365 | MA | Worcester | school | 2513230 | 348 | Worcester | 251323002213 | 3480415 | Forest Grove Middle | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 241 | 52 | 143 | 0 | 24 | 0 | 28 | 267 | 221 | 488 | 241 | 52 | 143 | 0 | 24 | 0 | 28 | 267 | 221 | 488 | |||||||||||||||||||||||||||||||||
937844 | 937844 | MA | Plymouth | school | 2509720 | 239 | Plymouth | 250972001380 | 2390305 | Plymouth South Middle | Regular School | No | 2 | 05 | 08 | 2016 | grade_7 | 241 | 2 | 2 | 1 | 4 | 0 | 5 | 138 | 117 | 255 | 241 | 2 | 2 | 1 | 4 | 0 | 5 | 138 | 117 | 255 | |||||||||||||||||||||||||||||||||
1366903 | 1366903 | MA | Middlesex | school | 2504320 | 79 | Dracut | 250432001625 | 790410 | Justus C. Richardson Middle School | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 241 | 22 | 49 | 0 | 20 | 0 | 3 | 175 | 160 | * | 335.0 | 241 | 22 | 49 | 0 | 20 | 0 | 3 | 175 | 160 | 335 | ||||||||||||||||||||||||||||||||
1366917 | 1366917 | MA | Plymouth | school | 2504410 | 82 | Duxbury | 250441000975 | 820305 | Duxbury Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_7 | 241 | 0 | 6 | 1 | 3 | 0 | 7 | 114 | 144 | * | 258.0 | 241 | 0 | 6 | 1 | 3 | 0 | 7 | 114 | 144 | 258 | ||||||||||||||||||||||||||||||||
1672056 | 1672056 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000025 | 50405 | Agawam - Agawam Junior High | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 241 | 4 | 39 | 0 | 12 | 0 | 11 | 145 | 162 | * | 307.0 | 241 | 4 | 39 | 0 | 12 | 0 | 11 | 145 | 162 | 307 | ||||||||||||||||||||||||||||||||
2039858 | 2039858 | MA | Hampden | school | 2501800 | 5 | Agawam | 250180000025 | 50405 | Agawam Junior High | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 241 | 10 | 18 | 0 | 13 | 0 | 9 | 165 | 126 | 291.0 | 241 | 10 | 18 | 0 | 13 | 0 | 9 | 165 | 126 | 291 | |||||||||||||||||||||||||||||||||
737925 | 737925 | MA | Bristol | school | 2504620 | 88 | Easton | 250462000618 | 880405 | Easton Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 240 | 11 | 12 | 1 | 5 | 0 | 6 | 142 | 133 | 275 | 240 | 11 | 12 | 1 | 5 | 0 | 6 | 142 | 133 | 275 | |||||||||||||||||||||||||||||||||
740876 | 740876 | MA | Plymouth | school | 2509420 | 231 | Pembroke | 250942001823 | 2310305 | Pembroke Community Middle School | Regular School | No | 2 | 07 | 08 | 2015 | grade_7 | 240 | 2 | 0 | 1 | 4 | 1 | 2 | 129 | 121 | 250 | 240 | 2 | 0 | 1 | 4 | 1 | 2 | 129 | 121 | 250 | |||||||||||||||||||||||||||||||||
742965 | 742965 | MA | Middlesex | school | 2513050 | 342 | Wilmington | 251305001578 | 3420330 | Wilmington Middle School | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 240 | 4 | 9 | 0 | 9 | 0 | 3 | 139 | 126 | 265 | 240 | 4 | 9 | 0 | 9 | 0 | 3 | 139 | 126 | 265 | |||||||||||||||||||||||||||||||||
941782 | 941782 | MA | Worcester | school | 2511880 | 775 | Wachusett | 251188000888 | 7750305 | Mountview Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 240 | 4 | 14 | 1 | 17 | 0 | 9 | 131 | 154 | 285 | 240 | 4 | 14 | 1 | 17 | 0 | 9 | 131 | 154 | 285 | |||||||||||||||||||||||||||||||||
2046258 | 2046258 | MA | Middlesex | school | 2511340 | 288 | Sudbury | 251134001872 | 2880305 | Ephraim Curtis Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 240 | 14 | 9 | 0 | 23 | 0 | 24 | 150 | 160 | 310.0 | 240 | 14 | 9 | 0 | 23 | 0 | 24 | 150 | 160 | 310 | |||||||||||||||||||||||||||||||||
2231141 | 2231141 | MA | Essex | school | 2503990 | 71 | Danvers | 250399002517 | 710305 | Danvers: Holten Richmond Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 240 | 5 | 20 | 0 | 7 | 0 | 9 | 136 | 145 | 281.0 | 240 | 5 | 20 | 0 | 7 | 0 | 9 | 136 | 145 | 281 | |||||||||||||||||||||||||||||||||
1124588 | 1124588 | MA | Bristol | school | 2504620 | 88 | Easton | 250462000618 | 880405 | Easton Middle School | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 239 | 17 | 13 | 1 | 11 | 0 | 13 | 147 | 147 | 294 | 239 | 17 | 13 | 1 | 11 | 0 | 13 | 147 | 147 | 294 | |||||||||||||||||||||||||||||||||
2232474 | 2232474 | MA | Middlesex | school | 2506330 | 139 | Hopkinton | 250633000468 | 1390305 | Hopkinton: Hopkinton Middle School | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 239 | 3 | 9 | 0 | 36 | 0 | 7 | 142 | 152 | 294.0 | 239 | 3 | 9 | 0 | 36 | 0 | 7 | 142 | 152 | 294 |
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]);