enrollments
Data source: Big Local News · About: Big Local
15,006 rows where state = "WI" and year = 2021 sorted by white_int
This data as json, CSV (advanced)
grade ✖
- pk_12_total 2,279
- grade_2 1,136
- grade_3 1,136
- grade_4 1,131
- grade_1 1,130
- kindergarten 1,126
- grade_5 1,074
- kindergarten_4_year_old 839
- grade_6 730
- grade_8 704
- grade_7 696
- grade_12 614
- grade_11 605
- grade_10 596
- grade_9 586
- pre_kindergarten 560
- kindergarten_3_year_old 64
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2335436 | 2335436 | WI | Milwaukee | school | 5500066 | 8127 | Non District Charter Schools | Dr Howard Fuller Collegiate Academy | 550006602865 | 400 | Dr Howard Fuller Collegiate Academy | charter | Regular School | Yes | High | 09 | 12 | 2021 | pk_12_total | 1.0 | 308.0 | 2.0 | 1.0 | 155.0 | 157.0 | 65 | 50 | 312 | 1 | 308 | 2 | 1 | 155 | 157 | 65 | 50 | 312 | |||||||||||||||||||||||||||||||||
2337851 | 2337851 | WI | Green | school | 2737 | Public Schools-Multidistrict Charters | Juda | 800 | Between the Lakes Virtual Academy | charter | 2021 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337870 | 2337870 | WI | Green | school | 2737 | Public Schools-Multidistrict Charters | Juda | 405 | Kiel eSchool | charter | 2021 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338116 | 2338116 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732001714 | 405 | Phoenix Project | Alternative School | No | High | 09 | 12 | 2021 | pk_12_total | 1.0 | 7.0 | 1.0 | 9.0 | 1.0 | 1 | * | 9 | 1 | 7 | 1 | 9 | 1 | 1 | 9 | |||||||||||||||||||||||||||||||||||||
2339173 | 2339173 | WI | Dane | school | 5508520 | 3269 | Public school | Madison Metropolitan | 550852002670 | 820 | Metro School | Alternative School | No | Other | 04 | 12 | 2021 | pk_12_total | 1.0 | 13.0 | 2.0 | 1.0 | 15.0 | 2.0 | * | 11 | 17 | 1 | 13 | 2 | 1 | 15 | 2 | 11 | 17 | |||||||||||||||||||||||||||||||||||
2340236 | 2340236 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001124 | 77 | Auer Avenue Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 1.0 | 155.0 | 4.0 | 1.0 | 6.0 | 91.0 | 76.0 | * | 30 | 167 | 1 | 155 | 4 | 1 | 6 | 91 | 76 | 30 | 167 | |||||||||||||||||||||||||||||||||
2340301 | 2340301 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002395 | 89 | Brown Street Academy | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 1.0 | 238.0 | 4.0 | 1.0 | 8.0 | 131.0 | 121.0 | * | 65 | 252 | 1 | 238 | 4 | 1 | 8 | 131 | 121 | 65 | 252 | |||||||||||||||||||||||||||||||||
2340413 | 2340413 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001140 | 110 | Clarke Street Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 1.0 | 249.0 | 7.0 | 8.0 | 150.0 | 115.0 | * | 74 | 265 | 1 | 249 | 7 | 8 | 150 | 115 | 74 | 265 | |||||||||||||||||||||||||||||||||||
2340424 | 2340424 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001141 | 114 | Clemens Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 1.0 | 288.0 | 10.0 | 1.0 | 1.0 | 8.0 | 177.0 | 132.0 | * | 56 | 309 | 1 | 288 | 10 | 1 | 1 | 8 | 177 | 132 | 56 | 309 | |||||||||||||||||||||||||||||||
2340589 | 2340589 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001165 | 179 | Franklin Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 1.0 | 348.0 | 5.0 | 1.0 | 1.0 | 11.0 | 213.0 | 154.0 | 361 | 103 | 367 | 1 | 348 | 5 | 1 | 1 | 11 | 213 | 154 | 361 | 103 | 367 | ||||||||||||||||||||||||||||||
2340754 | 2340754 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001185 | 212 | Hawthorne Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 1.0 | 236.0 | 17.0 | 2.0 | 11.0 | 147.0 | 120.0 | 1.0 | 261 | 57 | 267 | 1 | 236 | 17 | 2 | 11 | 147 | 120 | 1 | 261 | 57 | 267 | ||||||||||||||||||||||||||||||
2340850 | 2340850 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001261 | 377 | Jackson Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 1.0 | 233.0 | 6.0 | 5.0 | 2.0 | 121.0 | 126.0 | * | 65 | 247 | 1 | 233 | 6 | 5 | 2 | 121 | 126 | 65 | 247 | |||||||||||||||||||||||||||||||||
2340920 | 2340920 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001317 | 1121 | La Causa Charter School | charter | Regular School | Yes | Elementary | PK | 08 | 2021 | pk_12_total | 1.0 | 9.0 | 680.0 | 1.0 | 1.0 | 344.0 | 348.0 | 403.0 | 613 | 97 | 692 | 1 | 9 | 680 | 1 | 1 | 344 | 348 | 403 | 613 | 97 | 692 | |||||||||||||||||||||||||||||
2341094 | 2341094 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002860 | 145 | Milwaukee College Preparatory School -- Lloyd Street | charter | Regular School | Yes | Elementary | PK | 08 | 2021 | pk_12_total | 1.0 | 468.0 | 25.0 | 1.0 | 10.0 | 263.0 | 242.0 | 462 | 69 | 505 | 1 | 468 | 25 | 1 | 10 | 263 | 242 | 462 | 69 | 505 | |||||||||||||||||||||||||||||||
2341371 | 2341371 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002744 | 107 | Siefert Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 1.0 | 262.0 | 9.0 | 4.0 | 1.0 | 6.0 | 152.0 | 131.0 | 3.0 | * | 54 | 283 | 1 | 262 | 9 | 4 | 1 | 6 | 152 | 131 | 3 | 54 | 283 | |||||||||||||||||||||||||||||
2341388 | 2341388 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000936 | 1086 | Southeastern | Alternative School | No | Middle | 06 | 08 | 2021 | pk_12_total | 1.0 | 15.0 | 9.0 | 7.0 | * | 1 | 16 | 1 | 15 | 9 | 7 | 1 | 16 | |||||||||||||||||||||||||||||||||||||||
2341460 | 2341460 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002760 | 433 | Transition High | Alternative School | No | High | 09 | 12 | 2021 | pk_12_total | 1.0 | 92.0 | 5.0 | 1.0 | 37.0 | 62.0 | 3.0 | 93 | 13 | 99 | 1 | 92 | 5 | 1 | 37 | 62 | 3 | 93 | 13 | 99 | ||||||||||||||||||||||||||||||||
2346000 | 2346000 | WI | Barron | school | 5810 | Public Schools-Multidistrict Charters | Turtle Lake | 9410 | North Star Academy | charter | 2021 | pk_12_total | 1.0 | 1.0 | 2.0 | * | * | 2 | 1 | 1 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||
2346564 | 2346564 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578003070 | 800 | Riverview School | Alternative School | No | High | 06 | 12 | 2021 | pk_12_total | 1.0 | 1.0 | 1.0 | 3.0 | 1.0 | * | * | 3 | 1 | 1 | 1 | 3 | 1 | 3 | ||||||||||||||||||||||||||||||||||||||
2347188 | 2347188 | WI | Milwaukee | school | 5516260 | 6300 | Public school | West Allis-West Milwaukee | 551626002918 | 410 | Shared Journeys | charter | Alternative School | Yes | High | 07 | 12 | 2021 | pk_12_total | 1.0 | 1.0 | 2.0 | * | * | 2 | 1 | 1 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||
2333938 | 2333938 | WI | Rock | school | 422 | Public Schools-Multidistrict Charters | Beloit Turner | 9803 | JEDI Virtual K-12 | charter | 2021 | pk_12_total | 2.0 | 2.0 | * | * | 2 | 2 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2337468 | 2337468 | WI | Saint Croix | school | 5506690 | 2611 | Public school | Hudson | 550669003129 | 400 | Hudson Virtual Charter School | charter | Regular School | Yes | High | 09 | 12 | 2021 | pk_12_total | 2.0 | 2.0 | * | * | 2 | 2 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||
2338615 | 2338615 | WI | Vernon | school | 2863 | Public Schools-Multidistrict Charters | La Farge | 9407 | Vernon County Area Better Futures High | charter | 2021 | pk_12_total | 2.0 | 2.0 | * | * | 2 | 2 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2338701 | 2338701 | WI | Walworth | school | 5507650 | 2884 | Public school | Lake Geneva-Genoa City UHS | 550765003109 | 410 | New Visions Charter School | charter | Regular School | Yes | High | 09 | 12 | 2021 | pk_12_total | 2.0 | 2.0 | * | * | 2 | 2 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||
2340182 | 2340182 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003371 | 162 | ALBA - Academia de Lenguaje y Bellas Artes | charter | Regular School | Yes | Elementary | PK | 07 | 2021 | pk_12_total | 2.0 | 560.0 | 1.0 | 2.0 | 297.0 | 268.0 | 378.0 | 531 | 94 | 565 | 2 | 560 | 1 | 2 | 297 | 268 | 378 | 531 | 94 | 565 | |||||||||||||||||||||||||||||||
2340284 | 2340284 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001256 | 356 | Bethune Academy | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 2.0 | 366.0 | 14.0 | 218.0 | 10.0 | 335.0 | 275.0 | 207.0 | * | 116 | 610 | 2 | 366 | 14 | 218 | 10 | 335 | 275 | 207 | 116 | 610 | |||||||||||||||||||||||||||||||
2340357 | 2340357 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002755 | 407 | Carmen High School of Science and Technology South Campus | charter | Regular School | Yes | High | 09 | 12 | 2021 | pk_12_total | 2.0 | 9.0 | 396.0 | 2.0 | 195.0 | 214.0 | 110.0 | 399 | 37 | 409 | 2 | 9 | 396 | 2 | 195 | 214 | 110 | 399 | 37 | 409 | |||||||||||||||||||||||||||||||
2340379 | 2340379 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001829 | 108 | Carson Academy | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 2.0 | 391.0 | 6.0 | 2.0 | 2.0 | 1.0 | 9.0 | 217.0 | 196.0 | 395 | 66 | 413 | 2 | 391 | 6 | 2 | 2 | 1 | 9 | 217 | 196 | 395 | 66 | 413 | ||||||||||||||||||||||||||||
2340521 | 2340521 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002438 | 148 | Elm Creative Arts Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 2.0 | 222.0 | 13.0 | 3.0 | 1.0 | 12.0 | 134.0 | 119.0 | * | 43 | 253 | 2 | 222 | 13 | 3 | 1 | 12 | 134 | 119 | 43 | 253 | |||||||||||||||||||||||||||||||
2340529 | 2340529 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001157 | 150 | Emerson Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 2.0 | 182.0 | 6.0 | 18.0 | 1.0 | 8.0 | 114.0 | 103.0 | 3.0 | 204 | 55 | 217 | 2 | 182 | 6 | 18 | 1 | 8 | 114 | 103 | 3 | 204 | 55 | 217 | ||||||||||||||||||||||||||||
2340700 | 2340700 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000963 | 236 | Groppi High | Alternative School | No | High | 09 | 12 | 2021 | pk_12_total | 2.0 | 90.0 | 11.0 | 2.0 | 59.0 | 46.0 | 5.0 | * | 17 | 105 | 2 | 90 | 11 | 2 | 59 | 46 | 5 | 17 | 105 | |||||||||||||||||||||||||||||||||
2340881 | 2340881 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001197 | 237 | Kilbourn Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 2.0 | 228.0 | 9.0 | 10.0 | 6.0 | 150.0 | 105.0 | 235 | 55 | 255 | 2 | 228 | 9 | 10 | 6 | 150 | 105 | 235 | 55 | 255 | ||||||||||||||||||||||||||||||||
2340899 | 2340899 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001178 | 199 | King Jr Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 2.0 | 285.0 | 10.0 | 1.0 | 4.0 | 162.0 | 140.0 | * | 57 | 302 | 2 | 285 | 10 | 1 | 4 | 162 | 140 | 57 | 302 | |||||||||||||||||||||||||||||||||
2340950 | 2340950 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001204 | 241 | Lancaster Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 2.0 | 290.0 | 10.0 | 13.0 | 8.0 | 163.0 | 160.0 | 1.0 | * | 59 | 323 | 2 | 290 | 10 | 13 | 8 | 163 | 160 | 1 | 59 | 323 | |||||||||||||||||||||||||||||||
2341251 | 2341251 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000843 | 1072 | NOVA-Northwest Opportunities Vocational Academy | Alternative School | No | High | 09 | 12 | 2021 | pk_12_total | 2.0 | 80.0 | 5.0 | 1.0 | 1.0 | 6.0 | 47.0 | 48.0 | * | 22 | 95 | 2 | 80 | 5 | 1 | 1 | 6 | 47 | 48 | 22 | 95 | |||||||||||||||||||||||||||||||
2341392 | 2341392 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002442 | 312 | Starms Discovery | Regular School | No | Elementary | 01 | 08 | 2021 | pk_12_total | 2.0 | 264.0 | 10.0 | 2.0 | 9.0 | 145.0 | 142.0 | * | 81 | 287 | 2 | 264 | 10 | 2 | 9 | 145 | 142 | 81 | 287 | |||||||||||||||||||||||||||||||||
2343947 | 2343947 | WI | Dodge | school | 4634 | Public Schools-Multidistrict Charters | Randolph | 800 | Between the Lakes Virtual Academy | charter | 2021 | pk_12_total | 2.0 | 1.0 | 1.0 | * | * | 2 | 2 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||
2344383 | 2344383 | WI | Milwaukee | school | 5500081 | 8002 | Non District Charter Schools | Rocketship Education Wisconsin Inc | 550008103086 | 8140 | Rocketship Transformation Prep | charter | Regular School | Yes | Elementary | PK | 05 | 2021 | pk_12_total | 2.0 | 172.0 | 25.0 | 2.0 | 2.0 | 5.0 | 109.0 | 99.0 | 3.0 | 193 | 19 | 208 | 2 | 172 | 25 | 2 | 2 | 5 | 109 | 99 | 3 | 193 | 19 | 208 | |||||||||||||||||||||||||||
2334169 | 2334169 | WI | Shawano | school | 623 | Public Schools-Multidistrict Charters | Bowler | 9100 | Rural Virtual Academy | charter | 2021 | pk_12_total | 3.0 | 6.0 | 8.0 | 1.0 | * | 2 | 9 | 3 | 6 | 8 | 1 | 2 | 9 | |||||||||||||||||||||||||||||||||||||||||||||
2339616 | 2339616 | WI | Juneau | school | 3360 | Public Schools-Multidistrict Charters | Mauston | 9803 | JEDI Virtual K-12 | charter | 2021 | pk_12_total | 3.0 | 3.0 | * | * | 3 | 3 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2340391 | 2340391 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002602 | 178 | Carver Academy | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 3.0 | 383.0 | 14.0 | 2.0 | 7.0 | 228.0 | 181.0 | * | 93 | 409 | 3 | 383 | 14 | 2 | 7 | 228 | 181 | 93 | 409 | |||||||||||||||||||||||||||||||||
2340710 | 2340710 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001181 | 205 | Hampton Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 3.0 | 151.0 | 7.0 | 12.0 | 16.0 | 117.0 | 72.0 | 1.0 | * | 51 | 189 | 3 | 151 | 7 | 12 | 16 | 117 | 72 | 1 | 51 | 189 | |||||||||||||||||||||||||||||||
2340895 | 2340895 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002961 | 210 | King International Baccalaureate Middle | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 3.0 | 380.0 | 9.0 | 2.0 | 3.0 | 17.0 | 231.0 | 183.0 | 1.0 | 396 | 62 | 414 | 3 | 380 | 9 | 2 | 3 | 17 | 231 | 183 | 1 | 396 | 62 | 414 | ||||||||||||||||||||||||||||
2340931 | 2340931 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002567 | 296 | Lad Lake Synergy School | Alternative School | No | High | 06 | 12 | 2021 | pk_12_total | 3.0 | 26.0 | 15.0 | 1.0 | 24.0 | 21.0 | 4.0 | * | 12 | 45 | 3 | 26 | 15 | 1 | 24 | 21 | 4 | 12 | 45 | |||||||||||||||||||||||||||||||||
2341060 | 2341060 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002720 | 103 | Milwaukee Academy of Chinese Language | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 3.0 | 303.0 | 16.0 | 3.0 | 110.0 | 21.0 | 248.0 | 208.0 | 141.0 | 448 | 53 | 456 | 3 | 303 | 16 | 3 | 110 | 21 | 248 | 208 | 141 | 448 | 53 | 456 | ||||||||||||||||||||||||||||
2341354 | 2341354 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000856 | 1074 | Shalom High | Alternative School | No | High | 09 | 12 | 2021 | pk_12_total | 3.0 | 96.0 | 2.0 | 1.0 | 47.0 | 55.0 | 96 | 25 | 102 | 3 | 96 | 2 | 1 | 47 | 55 | 96 | 25 | 102 | ||||||||||||||||||||||||||||||||||
2341512 | 2341512 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001512 | 130 | Westside Academy | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 3.0 | 178.0 | 6.0 | 1.0 | 4.0 | 4.0 | 106.0 | 90.0 | 1.0 | * | 48 | 196 | 3 | 178 | 6 | 1 | 4 | 4 | 106 | 90 | 1 | 48 | 196 | |||||||||||||||||||||||||||||
2341569 | 2341569 | WI | Milwaukee | school | 5500042 | 8106 | Non District Charter Schools | Milwaukee Academy of Science | 550004202234 | 1251 | Milwaukee Academy of Science | charter | Regular School | Yes | Other | PK | 12 | 2021 | pk_12_total | 3.0 | 1237.0 | 23.0 | 1.0 | 2.0 | 601.0 | 665.0 | 1233 | 99 | 1266 | 3 | 1237 | 23 | 1 | 2 | 601 | 665 | 1233 | 99 | 1266 | |||||||||||||||||||||||||||||||
2342137 | 2342137 | WI | Chippewa | school | 3920 | Public Schools-Multidistrict Charters | New Auburn | 9419 | eSucceed Charter School | charter | 2021 | pk_12_total | 3.0 | 2.0 | 1.0 | * | * | 3 | 3 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||
2346152 | 2346152 | WI | Dane | school | 5515330 | 5901 | Public school | Verona Area | 551533002919 | 410 | Exploration Academy | charter | Regular School | Yes | High | 09 | 12 | 2021 | pk_12_total | 3.0 | 2.0 | 1.0 | 4.0 | 2.0 | * | * | 6 | 3 | 2 | 1 | 4 | 2 | 6 | |||||||||||||||||||||||||||||||||||||
2346994 | 2346994 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002349 | 190 | Vel R Phillips School | Alternative School | No | Other | KG | 12 | 2021 | pk_12_total | 3.0 | 42.0 | 4.0 | 48.0 | 1.0 | 1.0 | 17 | 11 | 49 | 3 | 42 | 4 | 48 | 1 | 1 | 17 | 11 | 49 | ||||||||||||||||||||||||||||||||||
2347606 | 2347606 | WI | Walworth | school | 6482 | Public Schools-Multidistrict Charters | Williams Bay | 9401 | Career and College Academy | charter | 2021 | pk_12_total | 3.0 | 2.0 | 1.0 | * | * | 3 | 3 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||
2333468 | 2333468 | WI | Ashland | school | 170 | Public Schools-Multidistrict Charters | Ashland | 9100 | Rural Virtual Academy | 2021 | pk_12_total | 4.0 | 4.0 | 1.0 | 4.0 | 5.0 | * | 9 | 4 | 4 | 1 | 4 | 5 | 9 | ||||||||||||||||||||||||||||||||||||||||||||||
2334000 | 2334000 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117002800 | 450 | Birchwood Blue Hills Charter School | charter | Regular School | Yes | High | 07 | 12 | 2021 | pk_12_total | 4.0 | 1.0 | 3.0 | 2.0 | * | * | 5 | 4 | 1 | 3 | 2 | 5 | |||||||||||||||||||||||||||||||||||||||
2334480 | 2334480 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002500 | 9410 | North Star Academy | charter | Alternative School | Yes | High | 09 | 12 | 2021 | pk_12_total | 4.0 | 1.0 | 1.0 | 4.0 | 2.0 | * | * | 6 | 4 | 1 | 1 | 4 | 2 | 6 | |||||||||||||||||||||||||||||||||||||
2334644 | 2334644 | WI | Price | school | 1071 | Public Schools-Multidistrict Charters | Chequamegon | 9100 | Rural Virtual Academy | charter | 2021 | pk_12_total | 4.0 | 3.0 | 1.0 | * | * | 4 | 4 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||
2337545 | 2337545 | WI | Dodge | school | 2625 | Public Schools-Multidistrict Charters | Hustisford | 405 | Kiel eSchool | charter | 2021 | pk_12_total | 4.0 | 3.0 | 1.0 | * | * | 4 | 4 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||
2340125 | 2340125 | WI | Dane | school | 5500085 | 8145 | Non District Charter Schools | Milestone Democratic School | 550008503136 | 8145 | Milestone Democratic School | charter | Regular School | Yes | High | 07 | 12 | 2021 | pk_12_total | 4.0 | 10.0 | 2.0 | 5.0 | 14.0 | 7.0 | 11 | 6 | 21 | 4 | 10 | 2 | 5 | 14 | 7 | 11 | 6 | 21 | |||||||||||||||||||||||||||||||||
2340218 | 2340218 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003123 | 215 | Andrew S Douglas Middle | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 4.0 | 282.0 | 8.0 | 2.0 | 3.0 | 10.0 | 172.0 | 137.0 | * | 81 | 309 | 4 | 282 | 8 | 2 | 3 | 10 | 172 | 137 | 81 | 309 | |||||||||||||||||||||||||||||||
2340443 | 2340443 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001143 | 116 | Congress Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 4.0 | 669.0 | 15.0 | 3.0 | 6.0 | 11.0 | 391.0 | 317.0 | 2.0 | 655 | 137 | 708 | 4 | 669 | 15 | 3 | 6 | 11 | 391 | 317 | 2 | 655 | 137 | 708 | ||||||||||||||||||||||||||||
2341022 | 2341022 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001214 | 267 | Maple Tree Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 4.0 | 194.0 | 13.0 | 2.0 | 14.0 | 2.0 | 7.0 | 127.0 | 109.0 | 1.0 | 221 | 35 | 236 | 4 | 194 | 13 | 2 | 14 | 2 | 7 | 127 | 109 | 1 | 221 | 35 | 236 | ||||||||||||||||||||||||||
2341121 | 2341121 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002949 | 118 | Milwaukee Environmental Science Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2021 | pk_12_total | 4.0 | 297.0 | 29.0 | 1.0 | 6.0 | 6.0 | 161.0 | 182.0 | 1.0 | 324 | 34 | 343 | 4 | 297 | 29 | 1 | 6 | 6 | 161 | 182 | 1 | 324 | 34 | 343 | |||||||||||||||||||||||||||
2341132 | 2341132 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003036 | 885 | Milwaukee Excellence Charter School | charter | Regular School | Yes | Middle | 06 | 10 | 2021 | pk_12_total | 4.0 | 486.0 | 4.0 | 1.0 | 4.0 | 10.0 | 222.0 | 287.0 | 469 | 69 | 509 | 4 | 486 | 4 | 1 | 4 | 10 | 222 | 287 | 469 | 69 | 509 | |||||||||||||||||||||||||||||
2341289 | 2341289 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001007 | 458 | Project STAY-Supporting Teachers and Youth | Alternative School | No | High | 09 | 12 | 2021 | pk_12_total | 4.0 | 112.0 | 12.0 | 2.0 | 7.0 | 71.0 | 66.0 | 1.0 | 121 | 30 | 137 | 4 | 112 | 12 | 2 | 7 | 71 | 66 | 1 | 121 | 30 | 137 | ||||||||||||||||||||||||||||||
2341401 | 2341401 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001156 | 149 | Starms Early Childhood | Regular School | No | Elementary | PK | KG | 2021 | pk_12_total | 4.0 | 225.0 | 19.0 | 1.0 | 11.0 | 138.0 | 122.0 | 246 | 43 | 260 | 4 | 225 | 19 | 1 | 11 | 138 | 122 | 246 | 43 | 260 | ||||||||||||||||||||||||||||||||
2341425 | 2341425 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001255 | 360 | Thoreau Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 4.0 | 353.0 | 31.0 | 2.0 | 9.0 | 16.0 | 224.0 | 191.0 | 5.0 | 394 | 72 | 415 | 4 | 353 | 31 | 2 | 9 | 16 | 224 | 191 | 5 | 394 | 72 | 415 | ||||||||||||||||||||||||||||
2341437 | 2341437 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002439 | 154 | Thurston Woods Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 4.0 | 362.0 | 20.0 | 2.0 | 1.0 | 6.0 | 219.0 | 176.0 | 375 | 82 | 395 | 4 | 362 | 20 | 2 | 1 | 6 | 219 | 176 | 375 | 82 | 395 | ||||||||||||||||||||||||||||||
2341595 | 2341595 | WI | Milwaukee | school | 5500065 | 8129 | Non District Charter Schools | Milwaukee Scholars Charter School | 550006502894 | 100 | Milwaukee Scholars Charter School | charter | Regular School | Yes | Elementary | PK | 08 | 2021 | pk_12_total | 4.0 | 641.0 | 32.0 | 2.0 | 8.0 | 1.0 | 44.0 | 358.0 | 374.0 | 10.0 | 658 | 66 | 732 | 4 | 641 | 32 | 2 | 8 | 1 | 44 | 358 | 374 | 10 | 658 | 66 | 732 | |||||||||||||||||||||||||
2345338 | 2345338 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449001125 | 320 | Juvenile Detention | Alternative School | No | Other | KG | 12 | 2021 | pk_12_total | 4.0 | 2.0 | 3.0 | 7.0 | 2.0 | * | * | 9 | 4 | 2 | 3 | 7 | 2 | 9 | ||||||||||||||||||||||||||||||||||||||
2347257 | 2347257 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002666 | 400 | Washington Street School | Alternative School | No | High | 06 | 12 | 2021 | pk_12_total | 4.0 | 1.0 | 4.0 | 1.0 | * | * | 5 | 4 | 1 | 4 | 1 | 5 | ||||||||||||||||||||||||||||||||||||||||
2338461 | 2338461 | WI | La Crosse | school | 5507530 | 2849 | Public school | La Crosse | 550753002950 | 440 | 7 Rivers Community High | charter | Regular School | Yes | High | 12 | 12 | 2021 | pk_12_total | 5.0 | 2.0 | 3.0 | * | * | 5 | 5 | 2 | 3 | 5 | |||||||||||||||||||||||||||||||||||||||||
2338948 | 2338948 | WI | Kewaunee | school | 3220 | Public Schools-Multidistrict Charters | Luxemburg-Casco | 9803 | JEDI Virtual K-12 | charter | 2021 | pk_12_total | 5.0 | 2.0 | 3.0 | * | * | 5 | 5 | 2 | 3 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||
2340798 | 2340798 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001188 | 218 | Holmes Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 5.0 | 251.0 | 23.0 | 1.0 | 1.0 | 8.0 | 162.0 | 127.0 | 2.0 | * | 99 | 289 | 5 | 251 | 23 | 1 | 1 | 8 | 162 | 127 | 2 | 99 | 289 | |||||||||||||||||||||||||||||
2341417 | 2341417 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001250 | 344 | Stuart Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 5.0 | 180.0 | 8.0 | 61.0 | 25.0 | 153.0 | 126.0 | 31.0 | 254 | 59 | 279 | 5 | 180 | 8 | 61 | 25 | 153 | 126 | 31 | 254 | 59 | 279 | ||||||||||||||||||||||||||||||
2342685 | 2342685 | WI | Fond du Lac | school | 4025 | Public Schools-Multidistrict Charters | Oakfield | 800 | Between the Lakes Virtual Academy | charter | 2021 | pk_12_total | 5.0 | 1.0 | 1.0 | 3.0 | 4.0 | 1 | * | 7 | 5 | 1 | 1 | 3 | 4 | 1 | 7 | |||||||||||||||||||||||||||||||||||||||||||
2343118 | 2343118 | WI | Clark | school | 4207 | Public Schools-Multidistrict Charters | Owen-Withee | 9100 | Rural Virtual Academy | charter | 2021 | pk_12_total | 5.0 | 3.0 | 2.0 | * | * | 5 | 5 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||
2347335 | 2347335 | WI | Vernon | school | 6321 | Public Schools-Multidistrict Charters | Westby Area | 9407 | Vernon County Area Better Futures High | charter | 2021 | pk_12_total | 5.0 | 3.0 | 2.0 | * | * | 5 | 5 | 3 | 2 | 5 | ||||||||||||||||||||||||||||||||||||||||||||||||
2335955 | 2335955 | WI | Rock | school | 1694 | Public Schools-Multidistrict Charters | Evansville Community | 9803 | JEDI Virtual K-12 | charter | 2021 | pk_12_total | 6.0 | 6.0 | * | 6 | 6 | 6 | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||||
2340260 | 2340260 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001126 | 81 | Barton Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 6.0 | 205.0 | 10.0 | 1.0 | 15.0 | 13.0 | 136.0 | 114.0 | 1.0 | 235 | 46 | 250 | 6 | 205 | 10 | 1 | 15 | 13 | 136 | 114 | 1 | 235 | 46 | 250 | ||||||||||||||||||||||||||||
2340309 | 2340309 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001132 | 92 | Browning Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 6.0 | 248.0 | 9.0 | 7.0 | 1.0 | 9.0 | 154.0 | 126.0 | 271 | 68 | 280 | 6 | 248 | 9 | 7 | 1 | 9 | 154 | 126 | 271 | 68 | 280 | ||||||||||||||||||||||||||||||
2340367 | 2340367 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003071 | 213 | Carmen Middle School of Science and Technology South Campus | charter | Regular School | Yes | Middle | 06 | 08 | 2021 | pk_12_total | 6.0 | 14.0 | 175.0 | 1.0 | 3.0 | 93.0 | 106.0 | 80.0 | 186 | 17 | 199 | 6 | 14 | 175 | 1 | 3 | 93 | 106 | 80 | 186 | 17 | 199 | |||||||||||||||||||||||||||||
2340719 | 2340719 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002979 | 880 | HAPA-Hmong American Peace Academy K3-12 | charter | Regular School | Yes | Other | PK | 12 | 2021 | pk_12_total | 6.0 | 7.0 | 19.0 | 1775.0 | 10.0 | 900.0 | 917.0 | 252.0 | 1590 | 81 | 1817 | 6 | 7 | 19 | 1775 | 10 | 900 | 917 | 252 | 1590 | 81 | 1817 | |||||||||||||||||||||||||||||
2341256 | 2341256 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002993 | 840 | Obama School of Career and Technical Education | Regular School | No | Other | PK | 12 | 2021 | pk_12_total | 6.0 | 604.0 | 16.0 | 1.0 | 12.0 | 336.0 | 303.0 | 4.0 | 605 | 181 | 639 | 6 | 604 | 16 | 1 | 12 | 336 | 303 | 4 | 605 | 181 | 639 | ||||||||||||||||||||||||||||||
2341313 | 2341313 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001174 | 194 | River Trail Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 6.0 | 275.0 | 22.0 | 2.0 | 30.0 | 16.0 | 188.0 | 163.0 | 10.0 | * | 60 | 351 | 6 | 275 | 22 | 2 | 30 | 16 | 188 | 163 | 10 | 60 | 351 | |||||||||||||||||||||||||||||
2341350 | 2341350 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001238 | 59 | Roosevelt Middle | Regular School | No | Middle | 06 | 08 | 2021 | pk_12_total | 6.0 | 315.0 | 12.0 | 3.0 | 8.0 | 153.0 | 191.0 | 1.0 | 330 | 82 | 344 | 6 | 315 | 12 | 3 | 8 | 153 | 191 | 1 | 330 | 82 | 344 | ||||||||||||||||||||||||||||||
2341727 | 2341727 | WI | Green | school | 3682 | Public Schools-Multidistrict Charters | Monroe | 9803 | JEDI Virtual K-12 | charter | 2021 | pk_12_total | 6.0 | 2.0 | 4.0 | * | 6 | 6 | 2 | 4 | 6 | |||||||||||||||||||||||||||||||||||||||||||||||||
2342373 | 2342373 | WI | Waukesha | school | 5510710 | 3976 | Public school | Norris | 551071003072 | 800 | Norris Academy Virtual School | charter | Alternative School | Yes | Other | KG | 12 | 2021 | pk_12_total | 6.0 | 7.0 | 4.0 | 17.0 | 5 | 8 | 17 | 6 | 7 | 4 | 17 | 5 | 8 | 17 | |||||||||||||||||||||||||||||||||||||
2335710 | 2335710 | WI | Langlade | school | 1582 | Public Schools-Multidistrict Charters | Elcho | 9100 | Rural Virtual Academy | charter | 2021 | pk_12_total | 7.0 | 1.0 | 2.0 | 6.0 | * | 2 | 8 | 7 | 1 | 2 | 6 | 2 | 8 | |||||||||||||||||||||||||||||||||||||||||||||
2337786 | 2337786 | WI | Rock | school | 5507020 | 2695 | Public school | Janesville | 550702002948 | 850 | Youth Services Center | Alternative School | No | Other | 04 | 12 | 2021 | pk_12_total | 7.0 | 3.0 | 1.0 | 2.0 | 11.0 | 2.0 | * | 1 | 13 | 7 | 3 | 1 | 2 | 11 | 2 | 1 | 13 | |||||||||||||||||||||||||||||||||||
2338027 | 2338027 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732002317 | 280 | Hillcrest School | Alternative School | No | High | 06 | 12 | 2021 | pk_12_total | 7.0 | 34.0 | 13.0 | 1.0 | 42.0 | 13.0 | 4.0 | * | 20 | 55 | 7 | 34 | 13 | 1 | 42 | 13 | 4 | 20 | 55 | |||||||||||||||||||||||||||||||||
2339481 | 2339481 | WI | Waupaca | school | 3318 | Public Schools-Multidistrict Charters | Marion | 9100 | Rural Virtual Academy | charter | 2021 | pk_12_total | 7.0 | 1.0 | 3.0 | 5.0 | * | 2 | 8 | 7 | 1 | 3 | 5 | 2 | 8 | |||||||||||||||||||||||||||||||||||||||||||||
2340318 | 2340318 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001133 | 93 | Bruce Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 7.0 | 219.0 | 11.0 | 13.0 | 1.0 | 23.0 | 144.0 | 130.0 | 1.0 | 266 | 52 | 274 | 7 | 219 | 11 | 13 | 1 | 23 | 144 | 130 | 1 | 266 | 52 | 274 | ||||||||||||||||||||||||||||
2340568 | 2340568 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001162 | 170 | Fifty-Third Street Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 7.0 | 322.0 | 11.0 | 2.0 | 1.0 | 15.0 | 175.0 | 183.0 | 341 | 78 | 358 | 7 | 322 | 11 | 2 | 1 | 15 | 175 | 183 | 341 | 78 | 358 | ||||||||||||||||||||||||||||||
2340682 | 2340682 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003111 | 454 | Green Tree Preparatory Academy | charter | Regular School | Yes | Middle | 06 | 10 | 2021 | pk_12_total | 7.0 | 219.0 | 9.0 | 2.0 | 5.0 | 10.0 | 131.0 | 121.0 | 4.0 | 245 | 44 | 252 | 7 | 219 | 9 | 2 | 5 | 10 | 131 | 121 | 4 | 245 | 44 | 252 | |||||||||||||||||||||||||||
2340864 | 2340864 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001195 | 232 | Kagel Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 7.0 | 30.0 | 170.0 | 2.0 | 3.0 | 119.0 | 93.0 | 103.0 | * | 51 | 212 | 7 | 30 | 170 | 2 | 3 | 119 | 93 | 103 | 51 | 212 | |||||||||||||||||||||||||||||||
2340911 | 2340911 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001200 | 337 | Kluge Elementary | Regular School | No | Elementary | PK | 05 | 2021 | pk_12_total | 7.0 | 271.0 | 16.0 | 1.0 | 31.0 | 15.0 | 184.0 | 157.0 | 25.0 | 325 | 111 | 341 | 7 | 271 | 16 | 1 | 31 | 15 | 184 | 157 | 25 | 325 | 111 | 341 | ||||||||||||||||||||||||||||
2341048 | 2341048 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002464 | 525 | Metcalfe Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 7.0 | 267.0 | 10.0 | 11.0 | 156.0 | 139.0 | 289 | 63 | 295 | 7 | 267 | 10 | 11 | 156 | 139 | 289 | 63 | 295 | ||||||||||||||||||||||||||||||||||
2341359 | 2341359 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001240 | 319 | Sherman Elementary | Regular School | No | Elementary | PK | 08 | 2021 | pk_12_total | 7.0 | 235.0 | 5.0 | 4.0 | 128.0 | 123.0 | * | 50 | 251 | 7 | 235 | 5 | 4 | 128 | 123 | 50 | 251 | |||||||||||||||||||||||||||||||||||
2345227 | 2345227 | WI | Marathon | school | 5467 | Public Schools-Multidistrict Charters | Spencer | 9100 | Rural Virtual Academy | charter | 2021 | pk_12_total | 7.0 | 5.0 | 2.0 | 1 | 1 | 7 | 7 | 5 | 2 | 1 | 1 | 7 | ||||||||||||||||||||||||||||||||||||||||||||||
2346206 | 2346206 | WI | Vernon | school | 5515360 | 5985 | Public school | Viroqua Area | 551536002513 | 9407 | Vernon County Area Better Futures High | charter | Regular School | Yes | High | 10 | 12 | 2021 | pk_12_total | 7.0 | 5.0 | 2.0 | * | 7 | 7 | 5 | 2 | 7 |
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]);