enrollments
Data source: Big Local News · About: Big Local
70,226 rows where state = "MA" sorted by asian descending
This data as json, CSV (advanced)
grade ✖
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
938351 | 938351 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077002496 | 2710005 | Beal School | Regular School | No | 1 | KG | 01 | 2016 | kindergarten | 103 | 5 | 21 | 2 | 99 | 0 | 6 | 126 | 110 | 236 | 103 | 5 | 21 | 2 | 99 | 0 | 6 | 126 | 110 | 236 | |||||||||||||||||||||||||||||||||
941889 | 941889 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Gr Lowell Regional Vocational Technical | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_10 | 247 | 12 | 169 | 2 | 99 | 0 | 13 | 307 | 235 | 542 | 247 | 12 | 169 | 2 | 99 | 0 | 13 | 307 | 235 | 542 | |||||||||||||||||||||||||||||||||
1126058 | 1126058 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002551 | 1550305 | Jonas Clarke Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_8 | 133 | 13 | 10 | 1 | 99 | 0 | 15 | 129 | 142 | 271 | 133 | 13 | 10 | 1 | 99 | 0 | 15 | 129 | 142 | 271 | |||||||||||||||||||||||||||||||||
1364927 | 1364927 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | High | 09 | 12 | 2020 | grade_11 | 313 | 8 | 25 | 0 | 99 | 0 | 10 | 202 | 252 | * | 455.0 | 313 | 8 | 25 | 0 | 99 | 0 | 10 | 202 | 252 | 455 | ||||||||||||||||||||||||||||||||
1370565 | 1370565 | MA | Norfolk | school | 2510620 | 266 | Sharon | 251062002560 | 2660305 | Sharon Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_6 | 148 | 14 | 17 | 0 | 99 | 0 | 19 | 156 | 141 | * | 297.0 | 148 | 14 | 17 | 0 | 99 | 0 | 19 | 156 | 141 | 297 | ||||||||||||||||||||||||||||||||
936453 | 936453 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001106 | 1650505 | Malden High | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 113 | 95 | 90 | 2 | 98 | 1 | 20 | 201 | 218 | 419 | 113 | 95 | 90 | 2 | 98 | 1 | 20 | 201 | 218 | 419 | |||||||||||||||||||||||||||||||||
2228925 | 2228925 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover: Andover High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 333 | 10 | 21 | 0 | 98 | 0 | 10 | 209 | 262 | 472.0 | 333 | 10 | 21 | 0 | 98 | 0 | 10 | 209 | 262 | 472 | |||||||||||||||||||||||||||||||||
2239837 | 2239837 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2018 | grade_9 | 277 | 29 | 195 | 1 | 98 | 0 | 20 | 335 | 285 | 620.0 | 277 | 29 | 195 | 1 | 98 | 0 | 20 | 335 | 285 | 620 | |||||||||||||||||||||||||||||||||
1368682 | 1368682 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717001106 | 1650505 | Malden High | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 103 | 103 | 133 | 4 | 98 | 0 | 13 | 225 | 229 | * | 454.0 | 103 | 103 | 133 | 4 | 98 | 0 | 13 | 225 | 229 | 454 | ||||||||||||||||||||||||||||||||
1678936 | 1678936 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002604 | 3210305 | Westborough - Sarah W Gibbons Middle | Regular School | No | Middle | 07 | 08 | 2021 | grade_7 | 153 | 15 | 14 | 0 | 98 | 0 | 9 | 134 | 155 | * | 289.0 | 153 | 15 | 14 | 0 | 98 | 0 | 9 | 134 | 155 | 289 | ||||||||||||||||||||||||||||||||
936008 | 936008 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002552 | 1550310 | Wm Diamond Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_8 | 123 | 13 | 5 | 1 | 97 | 0 | 14 | 130 | 123 | 253 | 123 | 13 | 5 | 1 | 97 | 0 | 14 | 130 | 123 | 253 | |||||||||||||||||||||||||||||||||
1130306 | 1130306 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266002081 | 3260505 | Westford Academy | Regular School | No | High | 09 | 12 | 2017 | grade_10 | 337 | 3 | 5 | 0 | 97 | 0 | 13 | 243 | 212 | 455 | 337 | 3 | 5 | 0 | 97 | 0 | 13 | 243 | 212 | 455 | |||||||||||||||||||||||||||||||||
1370602 | 1370602 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001559 | 2710040 | Parker Road Preschool | Regular School | No | Prekindergarten | PK | PK | 2020 | pre_kindergarten | 104 | 9 | 11 | 2 | 97 | 0 | 7 | 131 | 99 | * | 230.0 | 104 | 9 | 11 | 2 | 97 | 0 | 7 | 131 | 99 | 230 | ||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
1673219 | 1673219 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000203 | 350560 | Boston - Boston Latin | Regular School | No | High | 07 | 12 | 2021 | grade_9 | 197 | 38 | 72 | 0 | 97 | 0 | 20 | 209 | 215 | * | 424.0 | 197 | 38 | 72 | 0 | 97 | 0 | 20 | 209 | 215 | 424 | ||||||||||||||||||||||||||||||||
1678934 | 1678934 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260001734 | 3210045 | Westborough - Mill Pond School | Regular School | No | Middle | 04 | 06 | 2021 | grade_5 | 162 | 5 | 16 | 0 | 97 | 0 | 7 | 154 | 133 | * | 287.0 | 162 | 5 | 16 | 0 | 97 | 0 | 7 | 154 | 133 | 287 | ||||||||||||||||||||||||||||||||
939559 | 939559 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266002081 | 3260505 | Westford Academy | Regular School | No | 3 | 09 | 12 | 2016 | grade_9 | 341 | 4 | 6 | 0 | 96 | 0 | 10 | 246 | 211 | 457 | 341 | 4 | 6 | 0 | 96 | 0 | 10 | 246 | 211 | 457 | |||||||||||||||||||||||||||||||||
941888 | 941888 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Gr Lowell Regional Vocational Technical | Vocational Education School | No | 3 | 09 | 12 | 2016 | grade_9 | 227 | 21 | 190 | 3 | 96 | 0 | 25 | 327 | 235 | 562 | 227 | 21 | 190 | 3 | 96 | 0 | 25 | 327 | 235 | 562 | |||||||||||||||||||||||||||||||||
1128894 | 1128894 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001717 | 2710505 | Shrewsbury Sr High | Regular School | No | High | 09 | 12 | 2017 | grade_10 | 282 | 7 | 33 | 0 | 96 | 1 | 9 | 186 | 242 | 428 | 282 | 7 | 33 | 0 | 96 | 1 | 9 | 186 | 242 | 428 | |||||||||||||||||||||||||||||||||
2039953 | 2039953 | MA | Essex | school | 2501950 | 9 | Andover | 250195000045 | 90505 | Andover High | Regular School | No | High | 09 | 12 | 2019 | grade_10 | 324 | 9 | 21 | 0 | 96 | 0 | 10 | 209 | 250 | 460.0 | 324 | 9 | 21 | 0 | 96 | 0 | 10 | 209 | 250 | 460 | |||||||||||||||||||||||||||||||||
2044553 | 2044553 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton South High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 313 | 31 | 30 | 0 | 96 | 0 | 20 | 261 | 229 | 490.0 | 313 | 31 | 30 | 0 | 96 | 0 | 20 | 261 | 229 | 490 | |||||||||||||||||||||||||||||||||
2045654 | 2045654 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077002496 | 2710005 | Beal School | Regular School | No | Elementary | KG | 01 | 2019 | kindergarten | 87 | 8 | 18 | 4 | 96 | 0 | 8 | 122 | 99 | 221.0 | 87 | 8 | 18 | 4 | 96 | 0 | 8 | 122 | 99 | 221 | |||||||||||||||||||||||||||||||||
2045664 | 2045664 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001047 | 2710020 | Floral Street School | Regular School | No | Elementary | 01 | 04 | 2019 | grade_4 | 72 | 6 | 11 | 2 | 96 | 0 | 10 | 99 | 98 | 197.0 | 72 | 6 | 11 | 2 | 96 | 0 | 10 | 99 | 98 | 197 | |||||||||||||||||||||||||||||||||
2049188 | 2049188 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2019 | grade_9 | 210 | 31 | 230 | 2 | 96 | 0 | 29 | 300 | 295 | 598.0 | 210 | 31 | 230 | 2 | 96 | 0 | 29 | 300 | 295 | 598 | |||||||||||||||||||||||||||||||||
1365176 | 1365176 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000149 | 260305 | Winthrop L Chenery Middle | Regular School | No | Middle | 05 | 08 | 2020 | grade_6 | 225 | 12 | 23 | 1 | 96 | 1 | 27 | 193 | 192 | * | 385.0 | 225 | 12 | 23 | 1 | 96 | 1 | 27 | 193 | 192 | 385 | ||||||||||||||||||||||||||||||||
1370168 | 1370168 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001561 | 2430305 | Atlantic Middle | Regular School | No | Middle | 06 | 08 | 2020 | grade_8 | 74 | 9 | 4 | 0 | 96 | 2 | 8 | 105 | 88 | * | 193.0 | 74 | 9 | 4 | 0 | 96 | 2 | 8 | 105 | 88 | 193 | ||||||||||||||||||||||||||||||||
1371683 | 1371683 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260001734 | 3210045 | Mill Pond School | Regular School | No | Middle | 04 | 06 | 2020 | grade_4 | 161 | 5 | 15 | 0 | 96 | 0 | 7 | 152 | 132 | * | 284.0 | 161 | 5 | 15 | 0 | 96 | 0 | 7 | 152 | 132 | 284 | ||||||||||||||||||||||||||||||||
1374113 | 1374113 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2020 | grade_10 | 208 | 29 | 221 | 2 | 96 | 0 | 28 | 287 | 294 | 3 | 584.0 | 208 | 29 | 221 | 2 | 96 | 0 | 28 | 287 | 294 | 3 | 584 | |||||||||||||||||||||||||||||||
1677435 | 1677435 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001579 | 2430505 | Quincy - Quincy High | Regular School | No | High | 09 | 12 | 2021 | grade_12 | 201 | 37 | 48 | 3 | 96 | 1 | 12 | 190 | 208 | * | 398.0 | 201 | 37 | 48 | 3 | 96 | 1 | 12 | 190 | 208 | 398 | ||||||||||||||||||||||||||||||||
936004 | 936004 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002551 | 1550305 | Jonas Clarke Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_7 | 130 | 14 | 10 | 1 | 95 | 0 | 14 | 130 | 134 | 264 | 130 | 14 | 10 | 1 | 95 | 0 | 14 | 130 | 134 | 264 | |||||||||||||||||||||||||||||||||
938361 | 938361 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001047 | 2710020 | Floral Street School | Regular School | No | 1 | 01 | 04 | 2016 | grade_4 | 91 | 10 | 15 | 1 | 95 | 0 | 7 | 113 | 106 | 219 | 91 | 10 | 15 | 1 | 95 | 0 | 7 | 113 | 106 | 219 | |||||||||||||||||||||||||||||||||
1123812 | 1123812 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000415 | 460505 | Brookline High | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 272 | 38 | 47 | 0 | 95 | 0 | 48 | 266 | 234 | 500 | 272 | 38 | 47 | 0 | 95 | 0 | 48 | 266 | 234 | 500 | |||||||||||||||||||||||||||||||||
1126061 | 1126061 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002552 | 1550310 | Wm Diamond Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_7 | 150 | 13 | 4 | 0 | 95 | 0 | 19 | 129 | 152 | 281 | 150 | 13 | 4 | 0 | 95 | 0 | 19 | 129 | 152 | 281 | |||||||||||||||||||||||||||||||||
1128869 | 1128869 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001047 | 2710020 | Floral Street School | Regular School | No | Elementary | 01 | 04 | 2017 | grade_2 | 65 | 5 | 13 | 2 | 95 | 0 | 10 | 98 | 92 | 190 | 65 | 5 | 13 | 2 | 95 | 0 | 10 | 98 | 92 | 190 | |||||||||||||||||||||||||||||||||
2235680 | 2235680 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077002496 | 2710005 | Shrewsbury: Beal School | Regular School | No | Elementary | KG | 01 | 2018 | kindergarten | 108 | 11 | 22 | 5 | 95 | 0 | 13 | 128 | 126 | 254.0 | 108 | 11 | 22 | 5 | 95 | 0 | 13 | 128 | 126 | 254 | |||||||||||||||||||||||||||||||||
2235692 | 2235692 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001047 | 2710020 | Shrewsbury: Floral Street School | Regular School | No | Elementary | 01 | 04 | 2018 | grade_4 | 93 | 2 | 16 | 1 | 95 | 0 | 8 | 106 | 109 | 215.0 | 93 | 2 | 16 | 1 | 95 | 0 | 8 | 106 | 109 | 215 | |||||||||||||||||||||||||||||||||
2235709 | 2235709 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001559 | 2710040 | Shrewsbury: Parker Road Preschool | Regular School | No | Prekindergarten | PK | PK | 2018 | pre_kindergarten | 101 | 8 | 19 | 2 | 95 | 0 | 10 | 118 | 117 | 235.0 | 101 | 8 | 19 | 2 | 95 | 0 | 10 | 118 | 117 | 235 | |||||||||||||||||||||||||||||||||
1370187 | 1370187 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001579 | 2430505 | Quincy High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 196 | 43 | 24 | 0 | 95 | 1 | 9 | 189 | 179 | * | 368.0 | 196 | 43 | 24 | 0 | 95 | 1 | 9 | 189 | 179 | 368 | ||||||||||||||||||||||||||||||||
739161 | 739161 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002552 | 1550310 | Wm Diamond Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_7 | 128 | 14 | 6 | 0 | 94 | 0 | 15 | 128 | 129 | 257 | 128 | 14 | 6 | 0 | 94 | 0 | 15 | 128 | 129 | 257 | |||||||||||||||||||||||||||||||||
1133024 | 1133024 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2017 | grade_11 | 243 | 14 | 162 | 2 | 94 | 0 | 14 | 305 | 224 | 529 | 243 | 14 | 162 | 2 | 94 | 0 | 14 | 305 | 224 | 529 | |||||||||||||||||||||||||||||||||
2233114 | 2233114 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001955 | 1600360 | Lowell: Kathryn P. Stoklosa Middle School | Regular School | No | Middle | 05 | 08 | 2018 | grade_6 | 21 | 6 | 50 | 0 | 94 | 0 | 4 | 86 | 89 | 175.0 | 21 | 6 | 50 | 0 | 94 | 0 | 4 | 86 | 89 | 175 | |||||||||||||||||||||||||||||||||
2234371 | 2234371 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton: Newton South High | Regular School | No | High | 09 | 12 | 2018 | grade_12 | 307 | 19 | 28 | 0 | 94 | 0 | 19 | 233 | 234 | 467.0 | 307 | 19 | 28 | 0 | 94 | 0 | 19 | 233 | 234 | 467 | |||||||||||||||||||||||||||||||||
1676727 | 1676727 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton - Newton South High | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 252 | 17 | 25 | 1 | 94 | 1 | 23 | 219 | 194 | * | 413.0 | 252 | 17 | 25 | 1 | 94 | 1 | 23 | 219 | 194 | 413 | ||||||||||||||||||||||||||||||||
739596 | 739596 | MA | Middlesex | school | 2507170 | 165 | Malden | 250717002046 | 1650049 | Malden Early Learning Center | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 138 | 57 | 18 | 0 | 93 | 2 | 9 | 175 | 142 | 317 | 138 | 57 | 18 | 0 | 93 | 2 | 9 | 175 | 142 | 317 | |||||||||||||||||||||||||||||||||
740417 | 740417 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton South High | Regular School | No | 3 | 09 | 12 | 2015 | grade_12 | 290 | 18 | 26 | 0 | 93 | 3 | 14 | 209 | 235 | 444 | 290 | 18 | 26 | 0 | 93 | 3 | 14 | 209 | 235 | 444 | |||||||||||||||||||||||||||||||||
741555 | 741555 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001047 | 2710020 | Floral Street School | Regular School | No | 1 | 01 | 04 | 2015 | grade_3 | 94 | 9 | 12 | 1 | 93 | 0 | 8 | 112 | 105 | 217 | 94 | 9 | 12 | 1 | 93 | 0 | 8 | 112 | 105 | 217 | |||||||||||||||||||||||||||||||||
741563 | 741563 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001825 | 2710030 | Oak Middle School | Regular School | No | 2 | 07 | 08 | 2015 | grade_8 | 337 | 4 | 31 | 0 | 93 | 1 | 12 | 247 | 231 | 478 | 337 | 4 | 31 | 0 | 93 | 1 | 12 | 247 | 231 | 478 | |||||||||||||||||||||||||||||||||
937252 | 937252 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton South High | Regular School | No | 3 | 09 | 12 | 2016 | grade_11 | 280 | 26 | 37 | 0 | 93 | 0 | 21 | 229 | 228 | 457 | 280 | 26 | 37 | 0 | 93 | 0 | 21 | 229 | 228 | 457 | |||||||||||||||||||||||||||||||||
937942 | 937942 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001561 | 2430305 | Atlantic Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_8 | 50 | 2 | 3 | 0 | 93 | 0 | 1 | 79 | 70 | 149 | 50 | 2 | 3 | 0 | 93 | 0 | 1 | 79 | 70 | 149 | |||||||||||||||||||||||||||||||||
1128870 | 1128870 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001047 | 2710020 | Floral Street School | Regular School | No | Elementary | 01 | 04 | 2017 | grade_3 | 96 | 1 | 11 | 1 | 93 | 0 | 7 | 100 | 109 | 209 | 96 | 1 | 11 | 1 | 93 | 0 | 7 | 100 | 109 | 209 | |||||||||||||||||||||||||||||||||
1130305 | 1130305 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266002081 | 3260505 | Westford Academy | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 317 | 2 | 5 | 0 | 93 | 0 | 13 | 228 | 202 | 430 | 317 | 2 | 5 | 0 | 93 | 0 | 13 | 228 | 202 | 430 | |||||||||||||||||||||||||||||||||
2232876 | 2232876 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002552 | 1550310 | Lexington: Wm Diamond Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 123 | 13 | 11 | 0 | 93 | 0 | 25 | 128 | 137 | 265.0 | 123 | 13 | 11 | 0 | 93 | 0 | 25 | 128 | 137 | 265 | |||||||||||||||||||||||||||||||||
2235190 | 2235190 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Quincy: Central Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_7 | 105 | 6 | 7 | 0 | 93 | 0 | 5 | 109 | 107 | 216.0 | 105 | 6 | 7 | 0 | 93 | 0 | 5 | 109 | 107 | 216 | |||||||||||||||||||||||||||||||||
2235204 | 2235204 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001579 | 2430505 | Quincy: Quincy High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 210 | 47 | 22 | 0 | 93 | 2 | 10 | 195 | 189 | 384.0 | 210 | 47 | 22 | 0 | 93 | 2 | 10 | 195 | 189 | 384 | |||||||||||||||||||||||||||||||||
2235691 | 2235691 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001047 | 2710020 | Shrewsbury: Floral Street School | Regular School | No | Elementary | 01 | 04 | 2018 | grade_3 | 71 | 7 | 11 | 2 | 93 | 0 | 8 | 103 | 89 | 192.0 | 71 | 7 | 11 | 2 | 93 | 0 | 8 | 103 | 89 | 192 | |||||||||||||||||||||||||||||||||
2046762 | 2046762 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002059 | 3210505 | Westborough High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 169 | 3 | 28 | 0 | 93 | 0 | 15 | 146 | 162 | 308.0 | 169 | 3 | 28 | 0 | 93 | 0 | 15 | 146 | 162 | 308 | |||||||||||||||||||||||||||||||||
1677838 | 1677838 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001047 | 2710020 | Shrewsbury - Floral Street School | Regular School | No | Elementary | 01 | 04 | 2021 | grade_2 | 57 | 6 | 10 | 5 | 93 | 0 | 9 | 93 | 87 | * | 180.0 | 57 | 6 | 10 | 5 | 93 | 0 | 9 | 93 | 87 | 180 | ||||||||||||||||||||||||||||||||
1678938 | 1678938 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002059 | 3210505 | Westborough - Westborough High | Regular School | No | High | 09 | 12 | 2021 | grade_9 | 167 | 7 | 19 | 0 | 93 | 1 | 11 | 145 | 153 | * | 298.0 | 167 | 7 | 19 | 0 | 93 | 1 | 11 | 145 | 153 | 298 | ||||||||||||||||||||||||||||||||
739159 | 739159 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002551 | 1550305 | Jonas Clarke Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_8 | 170 | 8 | 11 | 0 | 92 | 0 | 13 | 158 | 136 | 294 | 170 | 8 | 11 | 0 | 92 | 0 | 13 | 158 | 136 | 294 | |||||||||||||||||||||||||||||||||
938377 | 938377 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001717 | 2710505 | Shrewsbury Sr High | Regular School | No | 3 | 09 | 12 | 2016 | grade_9 | 276 | 5 | 29 | 0 | 92 | 1 | 10 | 177 | 236 | 413 | 276 | 5 | 29 | 0 | 92 | 1 | 10 | 177 | 236 | 413 | |||||||||||||||||||||||||||||||||
1127548 | 1127548 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton South High | Regular School | No | High | 09 | 12 | 2017 | grade_11 | 297 | 20 | 31 | 0 | 92 | 0 | 19 | 224 | 235 | 459 | 297 | 20 | 31 | 0 | 92 | 0 | 19 | 224 | 235 | 459 | |||||||||||||||||||||||||||||||||
1130160 | 1130160 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002604 | 3210305 | Sarah W Gibbons Middle | Regular School | No | Middle | 07 | 08 | 2017 | grade_7 | 180 | 4 | 21 | 0 | 92 | 0 | 18 | 157 | 158 | 315 | 180 | 4 | 21 | 0 | 92 | 0 | 18 | 157 | 158 | 315 | |||||||||||||||||||||||||||||||||
2235203 | 2235203 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001579 | 2430505 | Quincy: Quincy High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 225 | 40 | 24 | 1 | 92 | 1 | 14 | 203 | 194 | 397.0 | 225 | 40 | 24 | 1 | 92 | 1 | 14 | 203 | 194 | 397 | |||||||||||||||||||||||||||||||||
2236976 | 2236976 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002604 | 3210305 | Westborough: Sarah W Gibbons Middle | Regular School | No | Middle | 07 | 08 | 2018 | grade_8 | 183 | 5 | 22 | 0 | 92 | 0 | 16 | 155 | 163 | 318.0 | 183 | 5 | 22 | 0 | 92 | 0 | 16 | 155 | 163 | 318 | |||||||||||||||||||||||||||||||||
2239840 | 2239840 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Greater Lowell Regional Vocational Technical: Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2018 | grade_12 | 236 | 12 | 157 | 2 | 92 | 0 | 14 | 294 | 219 | 513.0 | 236 | 12 | 157 | 2 | 92 | 0 | 14 | 294 | 219 | 513 | |||||||||||||||||||||||||||||||||
2041024 | 2041024 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000203 | 350560 | Boston Latin | Regular School | No | High | 07 | 12 | 2019 | grade_7 | 195 | 34 | 71 | 0 | 92 | 0 | 18 | 202 | 208 | 410.0 | 195 | 34 | 71 | 0 | 92 | 0 | 18 | 202 | 208 | 410 | |||||||||||||||||||||||||||||||||
2044546 | 2044546 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001374 | 2070505 | Newton North High | Regular School | No | High | 09 | 12 | 2019 | grade_9 | 328 | 32 | 52 | 2 | 92 | 0 | 35 | 283 | 258 | 541.0 | 328 | 32 | 52 | 2 | 92 | 0 | 35 | 283 | 258 | 541 | |||||||||||||||||||||||||||||||||
2045241 | 2045241 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001561 | 2430305 | Atlantic Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_7 | 73 | 7 | 4 | 0 | 92 | 2 | 9 | 100 | 87 | 187.0 | 73 | 7 | 4 | 0 | 92 | 2 | 9 | 100 | 87 | 187 | |||||||||||||||||||||||||||||||||
2045248 | 2045248 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Central Middle | Regular School | No | Middle | 06 | 08 | 2019 | grade_8 | 106 | 8 | 7 | 0 | 92 | 0 | 5 | 113 | 105 | 218.0 | 106 | 8 | 7 | 0 | 92 | 0 | 5 | 113 | 105 | 218 | |||||||||||||||||||||||||||||||||
2046760 | 2046760 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002604 | 3210305 | Sarah W Gibbons Middle | Regular School | No | Middle | 07 | 08 | 2019 | grade_7 | 180 | 4 | 25 | 0 | 92 | 1 | 10 | 153 | 159 | 312.0 | 180 | 4 | 25 | 0 | 92 | 1 | 10 | 153 | 159 | 312 | |||||||||||||||||||||||||||||||||
1365981 | 1365981 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279000203 | 350560 | Boston Latin | Regular School | No | High | 07 | 12 | 2020 | grade_8 | 194 | 32 | 69 | 0 | 92 | 0 | 17 | 197 | 207 | * | 404.0 | 194 | 32 | 69 | 0 | 92 | 0 | 17 | 197 | 207 | 404 | ||||||||||||||||||||||||||||||||
1369481 | 1369481 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton South High | Regular School | No | High | 09 | 12 | 2020 | grade_12 | 313 | 34 | 31 | 0 | 92 | 0 | 21 | 262 | 229 | * | 491.0 | 313 | 34 | 31 | 0 | 92 | 0 | 21 | 262 | 229 | 491 | ||||||||||||||||||||||||||||||||
1371687 | 1371687 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002604 | 3210305 | Sarah W Gibbons Middle | Regular School | No | Middle | 07 | 08 | 2020 | grade_8 | 182 | 4 | 25 | 0 | 92 | 1 | 12 | 160 | 156 | * | 316.0 | 182 | 4 | 25 | 0 | 92 | 1 | 12 | 160 | 156 | 316 | ||||||||||||||||||||||||||||||||
1672399 | 1672399 | MA | Middlesex | school | 2502490 | 26 | Belmont | 250249000149 | 260305 | Belmont - Winthrop L Chenery Middle | Regular School | No | Middle | 05 | 08 | 2021 | grade_7 | 211 | 13 | 20 | 1 | 92 | 2 | 28 | 189 | 178 | * | 367.0 | 211 | 13 | 20 | 1 | 92 | 2 | 28 | 189 | 178 | 367 | ||||||||||||||||||||||||||||||||
740415 | 740415 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton South High | Regular School | No | 3 | 09 | 12 | 2015 | grade_10 | 281 | 26 | 33 | 0 | 91 | 0 | 23 | 227 | 227 | 454 | 281 | 26 | 33 | 0 | 91 | 0 | 23 | 227 | 227 | 454 | |||||||||||||||||||||||||||||||||
933744 | 933744 | MA | Suffolk | school | 2502790 | 35 | Boston | 250279001296 | 350565 | Quincy Upper School | Regular School | No | 4 | 06 | 12 | 2016 | grade_6 | 6 | 18 | 24 | 1 | 91 | 0 | 4 | 73 | 71 | 144 | 6 | 18 | 24 | 1 | 91 | 0 | 4 | 73 | 71 | 144 | |||||||||||||||||||||||||||||||||
936006 | 936006 | MA | Middlesex | school | 2506840 | 155 | Lexington | 250684002552 | 1550310 | Wm Diamond Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_6 | 143 | 13 | 4 | 0 | 91 | 0 | 20 | 128 | 143 | 271 | 143 | 13 | 4 | 0 | 91 | 0 | 20 | 128 | 143 | 271 | |||||||||||||||||||||||||||||||||
1127549 | 1127549 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton South High | Regular School | No | High | 09 | 12 | 2017 | grade_12 | 276 | 28 | 34 | 0 | 91 | 0 | 22 | 226 | 225 | 451 | 276 | 28 | 34 | 0 | 91 | 0 | 22 | 226 | 225 | 451 | |||||||||||||||||||||||||||||||||
1130157 | 1130157 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260001734 | 3210045 | Mill Pond School | Regular School | No | Elementary | 04 | 06 | 2017 | grade_5 | 178 | 3 | 19 | 0 | 91 | 1 | 10 | 153 | 149 | 302 | 178 | 3 | 19 | 0 | 91 | 1 | 10 | 153 | 149 | 302 | |||||||||||||||||||||||||||||||||
2234369 | 2234369 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton: Newton South High | Regular School | No | High | 09 | 12 | 2018 | grade_10 | 314 | 31 | 29 | 0 | 91 | 0 | 23 | 265 | 223 | 488.0 | 314 | 31 | 29 | 0 | 91 | 0 | 23 | 265 | 223 | 488 | |||||||||||||||||||||||||||||||||
2235181 | 2235181 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001561 | 2430305 | Quincy: Atlantic Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_6 | 73 | 6 | 4 | 0 | 91 | 1 | 9 | 100 | 84 | 184.0 | 73 | 6 | 4 | 0 | 91 | 1 | 9 | 100 | 84 | 184 | |||||||||||||||||||||||||||||||||
2235716 | 2235716 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001717 | 2710505 | Shrewsbury: Shrewsbury Sr High | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 285 | 9 | 34 | 0 | 91 | 1 | 9 | 191 | 237 | 429.0 | 285 | 9 | 34 | 0 | 91 | 1 | 9 | 191 | 237 | 429 | |||||||||||||||||||||||||||||||||
2236973 | 2236973 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260001734 | 3210045 | Westborough: Mill Pond School | Regular School | No | Middle | 04 | 06 | 2018 | grade_6 | 182 | 4 | 21 | 0 | 91 | 1 | 10 | 154 | 155 | 309.0 | 182 | 4 | 21 | 0 | 91 | 1 | 10 | 154 | 155 | 309 | |||||||||||||||||||||||||||||||||
2044554 | 2044554 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton South High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 286 | 29 | 23 | 1 | 91 | 0 | 16 | 224 | 221 | 446.0 | 286 | 29 | 23 | 1 | 91 | 0 | 16 | 224 | 221 | 446 | |||||||||||||||||||||||||||||||||
2045260 | 2045260 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001579 | 2430505 | Quincy High | Regular School | No | High | 09 | 12 | 2019 | grade_11 | 208 | 48 | 27 | 0 | 91 | 2 | 13 | 191 | 198 | 389.0 | 208 | 48 | 27 | 0 | 91 | 2 | 13 | 191 | 198 | 389 | |||||||||||||||||||||||||||||||||
2045683 | 2045683 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001717 | 2710505 | Shrewsbury Sr High | Regular School | No | High | 09 | 12 | 2019 | grade_12 | 286 | 13 | 29 | 0 | 91 | 1 | 8 | 189 | 238 | 428.0 | 286 | 13 | 29 | 0 | 91 | 1 | 8 | 189 | 238 | 428 | |||||||||||||||||||||||||||||||||
2049189 | 2049189 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2019 | grade_10 | 263 | 24 | 188 | 1 | 91 | 0 | 19 | 316 | 270 | 586.0 | 263 | 24 | 188 | 1 | 91 | 0 | 19 | 316 | 270 | 586 | |||||||||||||||||||||||||||||||||
1371689 | 1371689 | MA | Worcester | school | 2512600 | 321 | Westborough | 251260002059 | 3210505 | Westborough High | Regular School | No | High | 09 | 12 | 2020 | grade_10 | 168 | 2 | 26 | 0 | 91 | 0 | 15 | 147 | 155 | * | 302.0 | 168 | 2 | 26 | 0 | 91 | 0 | 15 | 147 | 155 | 302 | ||||||||||||||||||||||||||||||||
1676724 | 1676724 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001374 | 2070505 | Newton - Newton North High | Regular School | No | High | 09 | 12 | 2021 | grade_11 | 316 | 31 | 60 | 0 | 91 | 0 | 40 | 279 | 259 | * | 538.0 | 316 | 31 | 60 | 0 | 91 | 0 | 40 | 279 | 259 | 538 | ||||||||||||||||||||||||||||||||
1677816 | 1677816 | MA | Norfolk | school | 2510620 | 266 | Sharon | 251062002560 | 2660305 | Sharon - Sharon Middle | Regular School | No | Middle | 06 | 08 | 2021 | grade_6 | 136 | 16 | 19 | 1 | 91 | 1 | 28 | 143 | 148 | * | 292.0 | 136 | 16 | 19 | 1 | 91 | 1 | 28 | 143 | 148 | 292 | ||||||||||||||||||||||||||||||||
741117 | 741117 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Central Middle | Regular School | No | 2 | 06 | 08 | 2015 | grade_6 | 121 | 6 | 6 | 0 | 90 | 1 | 6 | 117 | 113 | 230 | 121 | 6 | 6 | 0 | 90 | 1 | 6 | 117 | 113 | 230 | |||||||||||||||||||||||||||||||||
741569 | 741569 | MA | Worcester | school | 2510770 | 271 | Shrewsbury | 251077001559 | 2710040 | Parker Road Preschool | Regular School | No | 1 | PK | PK | 2015 | pre_kindergarten | 113 | 5 | 13 | 2 | 90 | 0 | 11 | 126 | 108 | 234 | 113 | 5 | 13 | 2 | 90 | 0 | 11 | 126 | 108 | 234 | |||||||||||||||||||||||||||||||||
937946 | 937946 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Central Middle | Regular School | No | 2 | 06 | 08 | 2016 | grade_6 | 108 | 5 | 5 | 0 | 90 | 2 | 5 | 120 | 95 | 215 | 108 | 5 | 5 | 0 | 90 | 2 | 5 | 120 | 95 | 215 | |||||||||||||||||||||||||||||||||
1126295 | 1126295 | MA | Middlesex | school | 2507020 | 160 | Lowell | 250702001955 | 1600360 | Kathryn P. Stoklosa Middle School | Regular School | No | Middle | 05 | 08 | 2017 | grade_5 | 21 | 6 | 45 | 0 | 90 | 0 | 4 | 85 | 81 | 166 | 21 | 6 | 45 | 0 | 90 | 0 | 4 | 85 | 81 | 166 | |||||||||||||||||||||||||||||||||
1127546 | 1127546 | MA | Middlesex | school | 2508610 | 207 | Newton | 250861001375 | 2070510 | Newton South High | Regular School | No | High | 09 | 12 | 2017 | grade_9 | 312 | 32 | 27 | 0 | 90 | 0 | 22 | 256 | 227 | 483 | 312 | 32 | 27 | 0 | 90 | 0 | 22 | 256 | 227 | 483 | |||||||||||||||||||||||||||||||||
1128370 | 1128370 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Central Middle | Regular School | No | Middle | 06 | 08 | 2017 | grade_8 | 112 | 6 | 6 | 0 | 90 | 1 | 6 | 117 | 104 | 221 | 112 | 6 | 6 | 0 | 90 | 1 | 6 | 117 | 104 | 221 | |||||||||||||||||||||||||||||||||
1133023 | 1133023 | MA | Middlesex | school | 2505480 | 828 | Greater Lowell Regional Vocational Technical | 250548002268 | 8280605 | Gr Lowell Regional Vocational Technical | Career and Technical School | No | High | 09 | 12 | 2017 | grade_10 | 235 | 22 | 193 | 3 | 90 | 0 | 24 | 332 | 235 | 567 | 235 | 22 | 193 | 3 | 90 | 0 | 24 | 332 | 235 | 567 | |||||||||||||||||||||||||||||||||
2230626 | 2230626 | MA | Norfolk | school | 2503150 | 46 | Brookline | 250315000415 | 460505 | Brookline: Brookline High | Regular School | No | High | 09 | 12 | 2018 | grade_9 | 288 | 40 | 68 | 0 | 90 | 1 | 44 | 252 | 278 | 531.0 | 288 | 40 | 68 | 0 | 90 | 1 | 44 | 252 | 278 | 531 | |||||||||||||||||||||||||||||||||
2235191 | 2235191 | MA | Norfolk | school | 2509870 | 243 | Quincy | 250987001564 | 2430315 | Quincy: Central Middle | Regular School | No | Middle | 06 | 08 | 2018 | grade_8 | 103 | 5 | 7 | 0 | 90 | 1 | 6 | 116 | 96 | 212.0 | 103 | 5 | 7 | 0 | 90 | 1 | 6 | 116 | 96 | 212 | |||||||||||||||||||||||||||||||||
2237122 | 2237122 | MA | Middlesex | school | 2512660 | 326 | Westford | 251266002081 | 3260505 | Westford: Westford Academy | Regular School | No | High | 09 | 12 | 2018 | grade_11 | 331 | 3 | 5 | 0 | 90 | 0 | 14 | 235 | 208 | 443.0 | 331 | 3 | 5 | 0 | 90 | 0 | 14 | 235 | 208 | 443 |
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]);