enrollments
Data source: Big Local News · About: Big Local
103,197 rows where state = "WI" sorted by white_int
This data as json, CSV (advanced)
grade ✖
- pk_12_total 15,723
- grade_3 7,846
- grade_2 7,833
- grade_1 7,819
- kindergarten 7,775
- grade_4 7,769
- grade_5 7,374
- kindergarten_4_year_old 5,797
- grade_6 4,960
- grade_8 4,744
- grade_7 4,704
- grade_12 4,121
- grade_11 4,091
- grade_10 4,017
- pre_kindergarten 3,996
- grade_9 3,931
- kindergarten_3_year_old 627
- grade_unknown 7
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2324955 | 2324955 | WI | Menominee | school | 5509070 | 3434 | Public school | Menominee Indian | 550907001070 | 40 | Menominee Indian High | Regular School | No | High | 09 | 12 | 2020 | pk_12_total | 1.0 | 33.0 | 273.0 | 5.0 | 162.0 | 150.0 | 271 | 68 | 312 | 1 | 33 | 273 | 5 | 162 | 150 | 271 | 68 | 312 | ||||||||||||||||||||||||||||||||||
2325343 | 2325343 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001124 | 77 | Auer Avenue Elementary | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 1.0 | 179.0 | 1.0 | 1.0 | 1.0 | 97.0 | 86.0 | * | 41 | 183 | 1 | 179 | 1 | 1 | 1 | 97 | 86 | 41 | 183 | |||||||||||||||||||||||||||||||||
2325434 | 2325434 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001134 | 94 | Bryant Elementary | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 1.0 | 179.0 | 7.0 | 2.0 | 11.0 | 6.0 | 114.0 | 92.0 | * | 55 | 206 | 1 | 179 | 7 | 2 | 11 | 6 | 114 | 92 | 55 | 206 | |||||||||||||||||||||||||||||||
2325522 | 2325522 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001140 | 110 | Clarke Street Elementary | Regular School | No | Elementary | PK | 08 | 2020 | pk_12_total | 1.0 | 247.0 | 5.0 | 12.0 | 154.0 | 111.0 | * | 76 | 265 | 1 | 247 | 5 | 12 | 154 | 111 | 76 | 265 | |||||||||||||||||||||||||||||||||||
2325533 | 2325533 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001141 | 114 | Clemens Elementary | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 1.0 | 313.0 | 11.0 | 4.0 | 1.0 | 1.0 | 9.0 | 199.0 | 141.0 | * | 67 | 340 | 1 | 313 | 11 | 4 | 1 | 1 | 9 | 199 | 141 | 67 | 340 | |||||||||||||||||||||||||||||
2325601 | 2325601 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002870 | 820 | Daniels University Preparatory Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2020 | pk_12_total | 1.0 | 179.0 | 10.0 | 2.0 | 95.0 | 97.0 | 181 | 31 | 192 | 1 | 179 | 10 | 2 | 95 | 97 | 181 | 31 | 192 | |||||||||||||||||||||||||||||||||
2325804 | 2325804 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000963 | 236 | Groppi High | Alternative School | No | High | 09 | 12 | 2020 | pk_12_total | 1.0 | 124.0 | 7.0 | 2.0 | 1.0 | 73.0 | 62.0 | 126 | 31 | 135 | 1 | 124 | 7 | 2 | 1 | 73 | 62 | 126 | 31 | 135 | ||||||||||||||||||||||||||||||||
2325955 | 2325955 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001261 | 377 | Jackson Elementary | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 1.0 | 283.0 | 7.0 | 5.0 | 1.0 | 160.0 | 137.0 | 286 | 80 | 297 | 1 | 283 | 7 | 5 | 1 | 160 | 137 | 286 | 80 | 297 | ||||||||||||||||||||||||||||||||
2326359 | 2326359 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001341 | 1141 | Next Door Charter | charter | Regular School | Yes | Elementary | PK | KG | 2020 | pk_12_total | 1.0 | 211.0 | 5.0 | 1.0 | 3.0 | 107.0 | 114.0 | 215 | 33 | 221 | 1 | 211 | 5 | 1 | 3 | 107 | 114 | 215 | 33 | 221 | |||||||||||||||||||||||||||||||
2326497 | 2326497 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002744 | 107 | Siefert Elementary | Regular School | No | Elementary | PK | 05 | 2020 | pk_12_total | 1.0 | 286.0 | 10.0 | 1.0 | 1.0 | 3.0 | 164.0 | 138.0 | * | 45 | 302 | 1 | 286 | 10 | 1 | 1 | 3 | 164 | 138 | 45 | 302 | |||||||||||||||||||||||||||||||
2326506 | 2326506 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003057 | 442 | South Accelerated Academy | Alternative School | No | High | 09 | 12 | 2020 | pk_12_total | 1.0 | 24.0 | 9.0 | 2.0 | 25.0 | 11.0 | * | 9 | 36 | 1 | 24 | 9 | 2 | 25 | 11 | 9 | 36 | |||||||||||||||||||||||||||||||||||
2326519 | 2326519 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002442 | 312 | Starms Discovery | Regular School | No | Elementary | 01 | 08 | 2020 | pk_12_total | 1.0 | 263.0 | 12.0 | 1.0 | 5.0 | 141.0 | 141.0 | * | 83 | 282 | 1 | 263 | 12 | 1 | 5 | 141 | 141 | 83 | 282 | |||||||||||||||||||||||||||||||||
2326588 | 2326588 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002760 | 433 | Transition High | Alternative School | No | High | 09 | 12 | 2020 | pk_12_total | 1.0 | 161.0 | 5.0 | 1.0 | 1.0 | 67.0 | 102.0 | 147 | 37 | 169 | 1 | 161 | 5 | 1 | 1 | 67 | 102 | 147 | 37 | 169 | ||||||||||||||||||||||||||||||||
2326627 | 2326627 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003055 | 448 | Vincent Accelerated Academy | Alternative School | No | High | 09 | 12 | 2020 | pk_12_total | 1.0 | 57.0 | 1.0 | 1.0 | 3.0 | 42.0 | 21.0 | 52 | 17 | 63 | 1 | 57 | 1 | 1 | 3 | 42 | 21 | 52 | 17 | 63 | ||||||||||||||||||||||||||||||||
2327269 | 2327269 | WI | Chippewa | school | 3920 | Public Schools-Multidistrict Charters | New Auburn | 9419 | eSucceed Charter School | charter | 2020 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2330230 | 2330230 | WI | Door | school | 5457 | Public Schools-Multidistrict Charters | Southern Door County | 9100 | Rural Virtual Academy | charter | 2020 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
2332860 | 2332860 | WI | Juneau | school | 5517130 | 6713 | Public school | Wonewoc-Union Center | 551713003059 | 850 | Wonewoc-Center Virtual Academy | charter | Regular School | Yes | Other | KG | 12 | 2020 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||
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 | |||||||||||||||||||||||||||||||||||||||||
3074148 | 3074148 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002679 | 800 | Appleton Cooperative Educational Center | Alternative School | No | Other | 04 | 12 | 2019 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||
3075005 | 3075005 | WI | Walworth | school | 6013 | Public Schools-Multidistrict Charters | Big Foot UHS | 9401 | Walworth Co Educ Alt High | charter | 2019 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3075372 | 3075372 | WI | Ashland | school | 5501920 | 840 | Public school | Butternut | 550192002751 | 450 | Promethean Charter School | charter | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 1.0 | 1.0 | 2.0 | * | * | 2 | 1 | 1 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||
3079482 | 3079482 | WI | Vernon | school | 2863 | Public Schools-Multidistrict Charters | La Farge | 9407 | Vernon County Area Better Futures High | charter | 2019 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3081260 | 3081260 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001140 | 110 | Clarke Street Elementary | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 1.0 | 284.0 | 5.0 | 1.0 | 1.0 | 7.0 | 173.0 | 126.0 | 293 | 77 | 299 | 1 | 284 | 5 | 1 | 1 | 7 | 173 | 126 | 293 | 77 | 299 | ||||||||||||||||||||||||||||||
3081343 | 3081343 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002870 | 820 | Daniels University Preparatory Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2019 | pk_12_total | 1.0 | 167.0 | 5.0 | 2.0 | 3.0 | 81.0 | 97.0 | 159 | 35 | 178 | 1 | 167 | 5 | 2 | 3 | 81 | 97 | 159 | 35 | 178 | |||||||||||||||||||||||||||||||
3081705 | 3081705 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001261 | 377 | Jackson Elementary | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 1.0 | 297.0 | 4.0 | 1.0 | 2.0 | 1.0 | 2.0 | 169.0 | 139.0 | * | 85 | 308 | 1 | 297 | 4 | 1 | 2 | 1 | 2 | 169 | 139 | 85 | 308 | |||||||||||||||||||||||||||||
3081754 | 3081754 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002961 | 210 | King International Baccalaureate Middle | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 1.0 | 399.0 | 15.0 | 1.0 | 13.0 | 11.0 | 217.0 | 223.0 | 379 | 71 | 440 | 1 | 399 | 15 | 1 | 13 | 11 | 217 | 223 | 379 | 71 | 440 | ||||||||||||||||||||||||||||||
3081977 | 3081977 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003006 | 121 | Milwaukee College Preparatory School: Lola Rowe North Campus | charter | Regular School | Yes | Elementary | PK | 08 | 2019 | pk_12_total | 1.0 | 465.0 | 14.0 | 9.0 | 225.0 | 264.0 | 444 | 55 | 489 | 1 | 465 | 14 | 9 | 225 | 264 | 444 | 55 | 489 | |||||||||||||||||||||||||||||||||
3082136 | 3082136 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000843 | 1072 | NOVA-Northwest Opportunities Vocational Academy | Alternative School | No | High | 09 | 12 | 2019 | pk_12_total | 1.0 | 107.0 | 1.0 | 1.0 | 2.0 | 54.0 | 58.0 | 100 | 44 | 112 | 1 | 107 | 1 | 1 | 2 | 54 | 58 | 100 | 44 | 112 | ||||||||||||||||||||||||||||||||
3082246 | 3082246 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001240 | 319 | Sherman Elementary | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 1.0 | 333.0 | 12.0 | 1.0 | 9.0 | 189.0 | 167.0 | 350 | 71 | 356 | 1 | 333 | 12 | 1 | 9 | 189 | 167 | 350 | 71 | 356 | ||||||||||||||||||||||||||||||||
3082405 | 3082405 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001512 | 130 | Westside Academy | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 1.0 | 193.0 | 6.0 | 6.0 | 8.0 | 107.0 | 107.0 | * | 34 | 214 | 1 | 193 | 6 | 6 | 8 | 107 | 107 | 34 | 214 | |||||||||||||||||||||||||||||||||
3082480 | 3082480 | WI | Milwaukee | school | 5500066 | 8127 | Non District Charter Schools | Milwaukee Collegiate Academy | 550006602865 | 400 | Milwaukee Collegiate Academy | charter | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 1.0 | 314.0 | 4.0 | 1.0 | 163.0 | 157.0 | 312 | 51 | 320 | 1 | 314 | 4 | 1 | 163 | 157 | 312 | 51 | 320 | |||||||||||||||||||||||||||||||||
3082485 | 3082485 | WI | Milwaukee | school | 5500067 | 8128 | Non District Charter Schools | Milwaukee Math and Science Academy | 550006702898 | 800 | Milwaukee Math and Science Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2019 | pk_12_total | 1.0 | 287.0 | 5.0 | 1.0 | 141.0 | 153.0 | 236 | 37 | 294 | 1 | 287 | 5 | 1 | 141 | 153 | 236 | 37 | 294 | |||||||||||||||||||||||||||||||||
3086861 | 3086861 | WI | Milwaukee | school | 5500077 | 8137 | Non District Charter Schools | United Community Center Acosta Middle | 550007703047 | 8137 | United Community Center Acosta Middle School | charter | Regular School | Yes | Middle | 06 | 08 | 2019 | pk_12_total | 1.0 | 4.0 | 163.0 | 92.0 | 76.0 | 5 | 12 | 168 | 1 | 4 | 163 | 92 | 76 | 5 | 12 | 168 | |||||||||||||||||||||||||||||||||||
3087117 | 3087117 | WI | Jefferson | school | 6118 | Public Schools-Multidistrict Charters | Waterloo | 9803 | JEDI Virtual K-12 | charter | 2019 | pk_12_total | 1.0 | 1.0 | 2.0 | * | * | 2 | 1 | 1 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||
3088904 | 3088904 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039002679 | 800 | Appleton Cooperative Educational Center | Alternative School | No | Other | 04 | 12 | 2018 | pk_12_total | 1.0 | 1.0 | 2.0 | 4.0 | * | * | 4 | 1 | 1 | 2 | 4 | 4 | ||||||||||||||||||||||||||||||||||||||||
3089701 | 3089701 | WI | Rock | school | 422 | Public Schools-Multidistrict Charters | Beloit Turner | 9803 | JEDI Virtual K-12 | charter | 2018 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090127 | 3090127 | WI | Ashland | school | 5501920 | 840 | Public school | Butternut | 550192002751 | 450 | Promethean Charter School | charter | Regular School | Yes | High | 09 | 12 | 2018 | pk_12_total | 1.0 | 1.0 | 2.0 | * | * | 2 | 1 | 1 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||
3092212 | 3092212 | WI | Saint Croix | school | 5505520 | 2198 | Public school | Glenwood City | 550552002469 | 400 | Transitional Skills Center | charter | Regular School | Yes | High | 10 | 12 | 2018 | pk_12_total | 1.0 | 1.0 | 1.0 | 2.0 | 1.0 | * | * | 3 | 1 | 1 | 1 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||||||
3095174 | 3095174 | WI | Juneau | school | 3360 | Public Schools-Multidistrict Charters | Mauston | 9405 | Juneau County Charter School | charter | 2018 | pk_12_total | 1.0 | 1.0 | 1.0 | 1.0 | * | * | 2 | 1 | 1 | 1 | 1 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||
3095969 | 3095969 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001140 | 110 | Clarke Street Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 1.0 | 282.0 | 5.0 | 3.0 | 6.0 | 172.0 | 125.0 | * | 99 | 297 | 1 | 282 | 5 | 3 | 6 | 172 | 125 | 99 | 297 | |||||||||||||||||||||||||||||||||
3096048 | 3096048 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003053 | 850 | Daniel Webster Secondary School | Regular School | No | Secondary | 06 | 11 | 2018 | pk_12_total | 1.0 | 83.0 | 2.0 | 1.0 | 47.0 | 40.0 | 75 | 7 | 87 | 1 | 83 | 2 | 1 | 47 | 40 | 75 | 7 | 87 | ||||||||||||||||||||||||||||||||||
3096052 | 3096052 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002870 | 820 | Daniels University Preparatory Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2018 | pk_12_total | 1.0 | 196.0 | 7.0 | 6.0 | 103.0 | 107.0 | 187 | 34 | 210 | 1 | 196 | 7 | 6 | 103 | 107 | 187 | 34 | 210 | |||||||||||||||||||||||||||||||||
3096527 | 3096527 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003058 | 115 | Lee Learning Center | Regular School | No | Elementary | PK | KG | 2018 | pk_12_total | 1.0 | 72.0 | 1.0 | 3.0 | 31.0 | 46.0 | * | 4 | 77 | 1 | 72 | 1 | 3 | 31 | 46 | 4 | 77 | |||||||||||||||||||||||||||||||||||
3096652 | 3096652 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002537 | 123 | Milwaukee College Preparatory School -- 36th Street Campus | charter | Regular School | Yes | Elementary | PK | 08 | 2018 | pk_12_total | 1.0 | 483.0 | 1.0 | 23.0 | 237.0 | 271.0 | 367 | 53 | 508 | 1 | 483 | 1 | 23 | 237 | 271 | 367 | 53 | 508 | |||||||||||||||||||||||||||||||||
3096685 | 3096685 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003006 | 121 | Milwaukee College Preparatory School: Lola Rowe North Campus | charter | Regular School | Yes | Elementary | PK | 08 | 2018 | pk_12_total | 1.0 | 478.0 | 10.0 | 11.0 | 237.0 | 263.0 | 490 | 52 | 500 | 1 | 478 | 10 | 11 | 237 | 263 | 490 | 52 | 500 | |||||||||||||||||||||||||||||||||
3096837 | 3096837 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003010 | 474 | NOVA Tech-Northwest Opportunities Vocational Academy Technical High | charter | Career and Technical School | Yes | High | 09 | 12 | 2018 | pk_12_total | 1.0 | 88.0 | 4.0 | 6.0 | 52.0 | 47.0 | 79 | 24 | 99 | 1 | 88 | 4 | 6 | 52 | 47 | 79 | 24 | 99 | |||||||||||||||||||||||||||||||||
3096842 | 3096842 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000843 | 1072 | NOVA-Northwest Opportunities Vocational Academy | Alternative School | No | High | 09 | 12 | 2018 | pk_12_total | 1.0 | 114.0 | 2.0 | 49.0 | 68.0 | 100 | 35 | 117 | 1 | 114 | 2 | 49 | 68 | 100 | 35 | 117 | ||||||||||||||||||||||||||||||||||||
3096881 | 3096881 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001243 | 325 | Pratt Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 1.0 | 257.0 | 8.0 | 1.0 | 9.0 | 122.0 | 154.0 | 269 | 43 | 276 | 1 | 257 | 8 | 1 | 9 | 122 | 154 | 269 | 43 | 276 | ||||||||||||||||||||||||||||||||
3096983 | 3096983 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000936 | 1086 | Southeastern | Alternative School | No | Middle | 06 | 08 | 2018 | pk_12_total | 1.0 | 21.0 | 5.0 | 19.0 | 8.0 | * | 16 | 27 | 1 | 21 | 5 | 19 | 8 | 16 | 27 | |||||||||||||||||||||||||||||||||||||
3096987 | 3096987 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002442 | 312 | Starms Discovery | Regular School | No | Elementary | 01 | 08 | 2018 | pk_12_total | 1.0 | 334.0 | 10.0 | 2.0 | 180.0 | 167.0 | * | 93 | 347 | 1 | 334 | 10 | 2 | 180 | 167 | 93 | 347 | |||||||||||||||||||||||||||||||||||
3096996 | 3096996 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001156 | 149 | Starms Early Childhood | Regular School | No | Elementary | PK | KG | 2018 | pk_12_total | 1.0 | 270.0 | 14.0 | 2.0 | 5.0 | 6.0 | 156.0 | 142.0 | 279 | 30 | 298 | 1 | 270 | 14 | 2 | 5 | 6 | 156 | 142 | 279 | 30 | 298 | ||||||||||||||||||||||||||||||
3098136 | 3098136 | WI | Washburn | school | 5509720 | 3654 | Public school | Northwood | 550972003018 | 800 | Northwood Virtual Charter School | charter | Regular School | Yes | Other | PK | 12 | 2018 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||
3100886 | 3100886 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449001125 | 320 | Juvenile Detention | Alternative School | No | Other | KG | 12 | 2018 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | ||||||||||||||||||||||||||||||||||||||||||||
3101470 | 3101470 | WI | Barron | school | 5515060 | 5810 | Public school | Turtle Lake | 551506003032 | 810 | Laker Online | charter | Regular School | Yes | Other | PK | 12 | 2018 | pk_12_total | 1.0 | 1.0 | * | * | 1 | 1 | 1 | 1 | |||||||||||||||||||||||||||||||||||||||||||
3101560 | 3101560 | WI | Milwaukee | school | 5500077 | 8137 | Non District Charter Schools | United Community Center Acosta Middle | 550007703047 | 8137 | United Community Center Acosta Middle School | charter | Regular School | Yes | Middle | 06 | 08 | 2018 | pk_12_total | 1.0 | 1.0 | 111.0 | 62.0 | 51.0 | 1 | 10 | 113 | 1 | 1 | 111 | 62 | 51 | 1 | 10 | 113 | |||||||||||||||||||||||||||||||||||
111963 | 111963 | WI | Langlade | school | 140 | Public Schools-Multidistrict Charters | Antigo Unified | 9100 | Rural Virtual Academy | charter | 2015 | pk_12_total | 2.0 | 1.0 | 2.0 | 1.0 | * | * | 3 | 2 | 1 | 2 | 1 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||
113664 | 113664 | WI | Clark | school | 1162 | Public Schools-Multidistrict Charters | Colby | 9100 | Rural Virtual Academy | charter | 2015 | pk_12_total | 2.0 | 1.0 | 3.0 | * | * | 3 | 2 | 1 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||
116789 | 116789 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732001714 | 405 | Phoenix Project | Alternative Education School | No | 3.0 | 09 | 12 | 2015 | pk_12_total | 2.0 | 18.0 | 4.0 | 22.0 | 2.0 | 13 | 12 | 24 | 2 | 18 | 4 | 22 | 2 | 13 | 12 | 24 | ||||||||||||||||||||||||||||||||||||
118439 | 118439 | WI | Menominee | school | 5509070 | 3434 | Public school | Menominee Indian | 550907001069 | 20 | Keshena Primary | Regular School | No | 1.0 | PK | 05 | 2015 | pk_12_total | 2.0 | 29.0 | 414.0 | 4.0 | 236.0 | 213.0 | 410 | 72 | 449 | 2 | 29 | 414 | 4 | 236 | 213 | 410 | 72 | 449 | ||||||||||||||||||||||||||||||||||
118790 | 118790 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002935 | 447 | Achievement Center | Alternative Education School | No | 4.0 | 06 | 12 | 2015 | pk_12_total | 2.0 | 46.0 | 2.0 | 1.0 | 28.0 | 23.0 | 45 | 26 | 51 | 2 | 46 | 2 | 1 | 28 | 23 | 45 | 26 | 51 | ||||||||||||||||||||||||||||||||||
119572 | 119572 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002567 | 296 | Lad Lake Synergy School | Alternative Education School | No | 4.0 | 06 | 12 | 2015 | pk_12_total | 2.0 | 18.0 | 11.0 | 1.0 | 22.0 | 10.0 | 22 | 8 | 32 | 2 | 18 | 11 | 1 | 22 | 10 | 22 | 8 | 32 | ||||||||||||||||||||||||||||||||||
119873 | 119873 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001341 | 1141 | Next Door Charter | charter | Regular School | Yes | 1.0 | PK | KG | 2015 | pk_12_total | 2.0 | 301.0 | 12.0 | 3.0 | 163.0 | 155.0 | 271 | 31 | 318 | 2 | 301 | 12 | 3 | 163 | 155 | 271 | 31 | 318 | |||||||||||||||||||||||||||||||||
119998 | 119998 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000856 | 1074 | Shalom High | Alternative Education School | No | 3.0 | 09 | 12 | 2015 | pk_12_total | 2.0 | 102.0 | 1.0 | 44.0 | 61.0 | 89 | 24 | 105 | 2 | 102 | 1 | 44 | 61 | 89 | 24 | 105 | ||||||||||||||||||||||||||||||||||||
120026 | 120026 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001243 | 325 | Silver Spring Elementary | Regular School | No | 1.0 | PK | 05 | 2015 | pk_12_total | 2.0 | 291.0 | 7.0 | 1.0 | 1.0 | 2.0 | 157.0 | 147.0 | 279 | 44 | 304 | 2 | 291 | 7 | 1 | 1 | 2 | 157 | 147 | 279 | 44 | 304 | ||||||||||||||||||||||||||||||
120045 | 120045 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002578 | 805 | St Charles Intensive Day Treatment | Alternative Education School | No | 3.0 | 07 | 12 | 2015 | pk_12_total | 2.0 | 33.0 | 1.0 | 1.0 | 28.0 | 9.0 | * | * | 37 | 2 | 33 | 1 | 1 | 28 | 9 | 37 | ||||||||||||||||||||||||||||||||||||
120261 | 120261 | WI | Milwaukee | school | 5500048 | 8103 | Non District Charter Schools | Milwaukee College Preparatory School -- | 550004802537 | 100 | Milwaukee College Preparatory School -- 36th Street | charter | Regular School | Yes | 1.0 | PK | 08 | 2015 | pk_12_total | 2.0 | 473.0 | 4.0 | 18.0 | 230.0 | 267.0 | 360 | 47 | 497 | 2 | 473 | 4 | 18 | 230 | 267 | 360 | 47 | 497 | |||||||||||||||||||||||||||||||||
120272 | 120272 | WI | Milwaukee | school | 5500072 | 8134 | Non District Charter Schools | Milwaukee College Preparatory School: | 550007203006 | 100 | Milwaukee College Preparatory School: Lola Rowe North Campus | charter | Regular School | Yes | 1.0 | PK | 08 | 2015 | pk_12_total | 2.0 | 432.0 | 9.0 | 1.0 | 2.0 | 4.0 | 229.0 | 221.0 | 309 | 37 | 450 | 2 | 432 | 9 | 1 | 2 | 4 | 229 | 221 | 309 | 37 | 450 | |||||||||||||||||||||||||||||
120283 | 120283 | WI | Milwaukee | school | 5500066 | 8127 | Non District Charter Schools | Milwaukee Collegiate Academy | 550006602865 | 400 | Milwaukee Collegiate Academy | charter | Regular School | Yes | 3.0 | 09 | 12 | 2015 | pk_12_total | 2.0 | 259.0 | 1.0 | 116.0 | 146.0 | * | 25 | 262 | 2 | 259 | 1 | 116 | 146 | 25 | 262 | ||||||||||||||||||||||||||||||||||||
124524 | 124524 | WI | Portage | school | 5500330 | 126 | Public school | Tomorrow River | 550033002984 | 850 | Central Wisconsin Virtual School | charter | Regular School | Yes | 4.0 | 06 | 12 | 2015 | pk_12_total | 2.0 | 2.0 | * | * | 2 | 2 | 2 | 2 | |||||||||||||||||||||||||||||||||||||||||||
125173 | 125173 | WI | Waupaca | school | 6195 | Public Schools-Multidistrict Charters | Waupaca | 9408 | Waupaca County Charter | charter | 2015 | pk_12_total | 2.0 | 2.0 | * | * | 2 | 2 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||
282859 | 282859 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117003020 | 800 | Bobcat Virtual Academy | charter | Regular School | Yes | 4.0 | PK | 12 | 2016 | pk_12_total | 2.0 | 1.0 | 1.0 | * | * | 2 | 2 | 1 | 1 | 2 | |||||||||||||||||||||||||||||||||||||||||
284082 | 284082 | WI | Walworth | school | 1380 | Public Schools-Multidistrict Charters | Delavan-Darien | 9401 | Walworth Co Educ Alt High | charter | 2016 | pk_12_total | 2.0 | 1.0 | 1.0 | 2.0 | * | * | 3 | 2 | 1 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||
284979 | 284979 | WI | Milwaukee | school | 5504830 | 1900 | Public school | Franklin Public | 550483002685 | 400 | Milwaukee County Correctional Facility South | Alternative Education School | No | 3.0 | 10 | 12 | 2016 | pk_12_total | 2.0 | 41.0 | 4.0 | 46.0 | 1.0 | 13 | 47 | 2 | 41 | 4 | 46 | 1 | 13 | 47 | ||||||||||||||||||||||||||||||||||||||
285171 | 285171 | WI | Oconto | school | 5505250 | 2128 | Public school | Gillett | 550525002892 | 100 | CRE8 Charter School | charter | Regular School | Yes | 1.0 | PK | 05 | 2016 | pk_12_total | 2.0 | 1.0 | 1.0 | 2.0 | * | * | 3 | 2 | 1 | 1 | 2 | 3 | |||||||||||||||||||||||||||||||||||||||
287100 | 287100 | WI | Milwaukee | school | 5500062 | 8126 | Non District Charter Schools | King's Academy | 550006202850 | 100 | King's Academy | charter | Regular School | Yes | 1.0 | PK | 08 | 2016 | pk_12_total | 2.0 | 197.0 | 10.0 | 2.0 | 103.0 | 108.0 | 197 | 19 | 211 | 2 | 197 | 10 | 2 | 103 | 108 | 197 | 19 | 211 | |||||||||||||||||||||||||||||||||
288825 | 288825 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000792 | 1063 | ASSATA | Alternative Education School | No | 3.0 | 09 | 12 | 2016 | pk_12_total | 2.0 | 110.0 | 3.0 | 5.0 | 53.0 | 67.0 | 102 | 18 | 120 | 2 | 110 | 3 | 5 | 53 | 67 | 102 | 18 | 120 | ||||||||||||||||||||||||||||||||||
289026 | 289026 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001141 | 114 | Clemens Elementary | Regular School | No | 1.0 | PK | 05 | 2016 | pk_12_total | 2.0 | 273.0 | 10.0 | 4.0 | 3.0 | 1.0 | 165.0 | 128.0 | 240 | 47 | 293 | 2 | 273 | 10 | 4 | 3 | 1 | 165 | 128 | 240 | 47 | 293 | ||||||||||||||||||||||||||||||
289208 | 289208 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001165 | 179 | Franklin Elementary | Regular School | No | 1.0 | PK | 08 | 2016 | pk_12_total | 2.0 | 275.0 | 4.0 | 146.0 | 135.0 | 231 | 108 | 281 | 2 | 275 | 4 | 146 | 135 | 231 | 108 | 281 | ||||||||||||||||||||||||||||||||||||
289401 | 289401 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001188 | 218 | Holmes Elementary | Regular School | No | 1.0 | PK | 08 | 2016 | pk_12_total | 2.0 | 304.0 | 6.0 | 1.0 | 1.0 | 165.0 | 149.0 | 261 | 102 | 314 | 2 | 304 | 6 | 1 | 1 | 165 | 149 | 261 | 102 | 314 | ||||||||||||||||||||||||||||||||
289549 | 289549 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002567 | 296 | Lad Lake Synergy School | Alternative Education School | No | 4.0 | 06 | 12 | 2016 | pk_12_total | 2.0 | 32.0 | 4.0 | 28.0 | 10.0 | 25 | 5 | 38 | 2 | 32 | 4 | 28 | 10 | 25 | 5 | 38 | ||||||||||||||||||||||||||||||||||||
289721 | 289721 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001306 | 315 | Milwaukee County Youth Education Center | Alternative Education School | No | 4.0 | 06 | 12 | 2016 | pk_12_total | 2.0 | 18.0 | 3.0 | 20.0 | 3.0 | 12 | 13 | 23 | 2 | 18 | 3 | 20 | 3 | 12 | 13 | 23 |
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]);