enrollments
Data source: Big Local News · About: Big Local
14,702 rows where state = "WI" and year = 2018 sorted by white_int
This data as json, CSV (advanced)
grade ✖
- pk_12_total 2,264
- grade_3 1,119
- grade_1 1,114
- grade_2 1,114
- kindergarten 1,105
- grade_4 1,103
- grade_5 1,051
- kindergarten_4_year_old 828
- grade_6 703
- grade_8 673
- grade_7 657
- grade_12 591
- grade_11 587
- grade_10 576
- grade_9 561
- pre_kindergarten 558
- kindergarten_3_year_old 96
- grade_unknown 2
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
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 | |||||||||||||||||||||||||||||||||||
3090915 | 3090915 | WI | Milwaukee | school | 5500047 | 8109 | Non District Charter Schools | Darrell Lynn Hines Academy | 550004702536 | 100 | Darrell Lynn Hines Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2018 | pk_12_total | 2.0 | 249.0 | 5.0 | 22.0 | 8.0 | 130.0 | 156.0 | 268 | 29 | 286 | 2 | 249 | 5 | 22 | 8 | 130 | 156 | 268 | 29 | 286 | |||||||||||||||||||||||||||||||
3091935 | 3091935 | WI | Milwaukee | school | 5504830 | 1900 | Public school | Franklin Public | 550483002685 | 400 | Milwaukee County Correctional Facility South | Alternative School | No | High | 09 | 12 | 2018 | pk_12_total | 2.0 | 39.0 | 8.0 | 2.0 | 51.0 | 4 | 32 | 51 | 2 | 39 | 8 | 2 | 51 | 4 | 32 | 51 | ||||||||||||||||||||||||||||||||||||
3093691 | 3093691 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732003051 | 810 | Kenosha Pike School | Special Education School | No | Other | PK | 12 | 2018 | pk_12_total | 2.0 | 1.0 | 3.0 | * | * | 3 | 2 | 1 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||
3095793 | 3095793 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001124 | 77 | Auer Avenue Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 2.0 | 248.0 | 8.0 | 1.0 | 1.0 | 1.0 | 154.0 | 107.0 | 250 | 61 | 261 | 2 | 248 | 8 | 1 | 1 | 1 | 154 | 107 | 250 | 61 | 261 | ||||||||||||||||||||||||||||||
3095981 | 3095981 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001141 | 114 | Clemens Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 2.0 | 272.0 | 8.0 | 1.0 | 2.0 | 8.0 | 164.0 | 129.0 | * | 54 | 293 | 2 | 272 | 8 | 1 | 2 | 8 | 164 | 129 | 54 | 293 | |||||||||||||||||||||||||||||||
3096943 | 3096943 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001238 | 59 | Roosevelt Middle | Regular School | No | Middle | 06 | 08 | 2018 | pk_12_total | 2.0 | 363.0 | 10.0 | 1.0 | 9.0 | 194.0 | 191.0 | 334 | 90 | 385 | 2 | 363 | 10 | 1 | 9 | 194 | 191 | 334 | 90 | 385 | ||||||||||||||||||||||||||||||||
3097057 | 3097057 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002760 | 433 | Transition High | Alternative School | No | High | 09 | 12 | 2018 | pk_12_total | 2.0 | 173.0 | 6.0 | 2.0 | 86.0 | 97.0 | 148 | 27 | 183 | 2 | 173 | 6 | 2 | 86 | 97 | 148 | 27 | 183 | ||||||||||||||||||||||||||||||||||
3097112 | 3097112 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001512 | 130 | Westside Academy | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 2.0 | 263.0 | 10.0 | 3.0 | 1.0 | 6.0 | 149.0 | 136.0 | 278 | 35 | 285 | 2 | 263 | 10 | 3 | 1 | 6 | 149 | 136 | 278 | 35 | 285 | ||||||||||||||||||||||||||||||
3097824 | 3097824 | WI | Juneau | school | 5510560 | 3948 | Public school | New Lisbon | 551056002517 | 9405 | Juneau County Charter School | charter | Regular School | Yes | High | 07 | 12 | 2018 | pk_12_total | 2.0 | 1.0 | 1.0 | 2.0 | * | * | 3 | 2 | 1 | 1 | 2 | 3 | |||||||||||||||||||||||||||||||||||||||
3102763 | 3102763 | WI | Vernon | school | 6321 | Public Schools-Multidistrict Charters | Westby Area | 9407 | Vernon County Area Better Futures High | charter | 2018 | pk_12_total | 2.0 | 2.0 | * | * | 2 | 2 | 2 | 2 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3088665 | 3088665 | WI | Clark | school | 7 | Public Schools-Multidistrict Charters | Abbotsford | 9100 | Rural Virtual Academy | charter | 2018 | pk_12_total | 3.0 | 3.0 | * | * | 3 | 3 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3089292 | 3089292 | WI | Wood | school | 203 | Public Schools-Multidistrict Charters | Auburndale | 9100 | Rural Virtual Academy | charter | 2018 | pk_12_total | 3.0 | 3.0 | * | * | 3 | 3 | 3 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||||
3090605 | 3090605 | WI | Clark | school | 1162 | Public Schools-Multidistrict Charters | Colby | 9100 | Rural Virtual Academy | charter | 2018 | pk_12_total | 3.0 | 1.0 | 2.0 | * | * | 3 | 3 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||
3092160 | 3092160 | WI | Taylor | school | 2135 | Public Schools-Multidistrict Charters | Gilman | 9100 | Rural Virtual Academy | charter | 2018 | pk_12_total | 3.0 | 1.0 | 2.0 | * | * | 3 | 3 | 1 | 2 | 3 | ||||||||||||||||||||||||||||||||||||||||||||||||
3095768 | 3095768 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003056 | 124 | Andrew Douglas School | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 3.0 | 225.0 | 3.0 | 1.0 | 2.0 | 110.0 | 124.0 | * | 16 | 234 | 3 | 225 | 3 | 1 | 2 | 110 | 124 | 16 | 234 | |||||||||||||||||||||||||||||||||
3095842 | 3095842 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001256 | 356 | Bethune Academy | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 3.0 | 344.0 | 10.0 | 198.0 | 7.0 | 294.0 | 268.0 | 549 | 116 | 562 | 3 | 344 | 10 | 198 | 7 | 294 | 268 | 549 | 116 | 562 | ||||||||||||||||||||||||||||||||
3095886 | 3095886 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001134 | 94 | Bryant Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 3.0 | 204.0 | 6.0 | 7.0 | 1.0 | 4.0 | 119.0 | 106.0 | 215 | 51 | 225 | 3 | 204 | 6 | 7 | 1 | 4 | 119 | 106 | 215 | 51 | 225 | ||||||||||||||||||||||||||||||
3095934 | 3095934 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001829 | 108 | Carson Academy | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 3.0 | 455.0 | 9.0 | 2.0 | 6.0 | 8.0 | 263.0 | 220.0 | 430 | 96 | 483 | 3 | 455 | 9 | 2 | 6 | 8 | 263 | 220 | 430 | 96 | 483 | ||||||||||||||||||||||||||||||
3095946 | 3095946 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002602 | 178 | Carver Academy | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 3.0 | 388.0 | 13.0 | 2.0 | 1.0 | 8.0 | 212.0 | 203.0 | * | 81 | 415 | 3 | 388 | 13 | 2 | 1 | 8 | 212 | 203 | 81 | 415 | |||||||||||||||||||||||||||||||
3096258 | 3096258 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000963 | 236 | Groppi High | Alternative School | No | High | 09 | 12 | 2018 | pk_12_total | 3.0 | 122.0 | 10.0 | 2.0 | 3.0 | 76.0 | 64.0 | 134 | 37 | 140 | 3 | 122 | 10 | 2 | 3 | 76 | 64 | 134 | 37 | 140 | ||||||||||||||||||||||||||||||||
3096268 | 3096268 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001181 | 205 | Hampton Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 3.0 | 193.0 | 7.0 | 13.0 | 11.0 | 138.0 | 89.0 | * | 57 | 227 | 3 | 193 | 7 | 13 | 11 | 138 | 89 | 57 | 227 | |||||||||||||||||||||||||||||||||
3096357 | 3096357 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001188 | 218 | Holmes Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 3.0 | 294.0 | 8.0 | 1.0 | 4.0 | 171.0 | 139.0 | 300 | 90 | 310 | 3 | 294 | 8 | 1 | 4 | 171 | 139 | 300 | 90 | 310 | ||||||||||||||||||||||||||||||||
3096412 | 3096412 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001261 | 377 | Jackson Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 3.0 | 282.0 | 1.0 | 1.0 | 3.0 | 1.0 | 1.0 | 159.0 | 133.0 | 285 | 78 | 292 | 3 | 282 | 1 | 1 | 3 | 1 | 1 | 159 | 133 | 285 | 78 | 292 | ||||||||||||||||||||||||||||
3096435 | 3096435 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001196 | 235 | Keefe Avenue Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 3.0 | 234.0 | 8.0 | 1.0 | 1.0 | 133.0 | 114.0 | 224 | 60 | 247 | 3 | 234 | 8 | 1 | 1 | 133 | 114 | 224 | 60 | 247 | ||||||||||||||||||||||||||||||||
3096497 | 3096497 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002567 | 296 | Lad Lake Synergy School | Alternative School | No | High | 06 | 12 | 2018 | pk_12_total | 3.0 | 40.0 | 13.0 | 2.0 | 1.0 | 30.0 | 29.0 | * | 19 | 59 | 3 | 40 | 13 | 2 | 1 | 30 | 29 | 19 | 59 | |||||||||||||||||||||||||||||||||
3096504 | 3096504 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001202 | 238 | LaFollette Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 3.0 | 241.0 | 4.0 | 3.0 | 3.0 | 11.0 | 165.0 | 100.0 | 253 | 70 | 265 | 3 | 241 | 4 | 3 | 3 | 11 | 165 | 100 | 253 | 70 | 265 | ||||||||||||||||||||||||||||||
3096821 | 3096821 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001341 | 1141 | Next Door Charter | charter | Regular School | Yes | Elementary | PK | KG | 2018 | pk_12_total | 3.0 | 291.0 | 4.0 | 3.0 | 3.0 | 155.0 | 149.0 | 277 | 49 | 304 | 3 | 291 | 4 | 3 | 3 | 155 | 149 | 277 | 49 | 304 | |||||||||||||||||||||||||||||||
3097045 | 3097045 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001258 | 365 | Townsend Street Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 3.0 | 317.0 | 7.0 | 6.0 | 179.0 | 154.0 | 323 | 80 | 333 | 3 | 317 | 7 | 6 | 179 | 154 | 323 | 80 | 333 | ||||||||||||||||||||||||||||||||||
3097171 | 3097171 | 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 | 2018 | pk_12_total | 3.0 | 1037.0 | 17.0 | 2.0 | 5.0 | 518.0 | 546.0 | 982 | 105 | 1064 | 3 | 1037 | 17 | 2 | 5 | 518 | 546 | 982 | 105 | 1064 | |||||||||||||||||||||||||||||||
3097202 | 3097202 | 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 | 2018 | pk_12_total | 3.0 | 611.0 | 3.0 | 3.0 | 11.0 | 11.0 | 329.0 | 313.0 | 585 | 51 | 642 | 3 | 611 | 3 | 3 | 11 | 11 | 329 | 313 | 585 | 51 | 642 | |||||||||||||||||||||||||||||
3097329 | 3097329 | WI | Green | school | 3682 | Public Schools-Multidistrict Charters | Monroe | 9803 | JEDI Virtual K-12 | charter | 2018 | pk_12_total | 3.0 | 1.0 | 3.0 | 1.0 | * | * | 4 | 3 | 1 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||
3099251 | 3099251 | WI | Racine | school | 5512360 | 4620 | Public school | Racine Unified | 551236002657 | 113 | All District 4 Year Old Kindergarten | Regular School | No | Prekindergarten | PK | PK | 2018 | pk_12_total | 3.0 | 8.0 | 5.0 | 4.0 | 9.0 | 11.0 | 11 | 3 | 20 | 3 | 8 | 5 | 4 | 9 | 11 | 11 | 3 | 20 | ||||||||||||||||||||||||||||||||||
3102118 | 3102118 | WI | Waupaca | school | 6195 | Public Schools-Multidistrict Charters | Waupaca | 9408 | Waupaca County Charter | charter | 2018 | pk_12_total | 3.0 | 1.0 | 3.0 | 1.0 | * | * | 4 | 3 | 1 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||
3102846 | 3102846 | WI | Waupaca | school | 5516500 | 6384 | Public school | Weyauwega-Fremont | 551650002523 | 9408 | Waupaca County Charter | charter | Regular School | Yes | High | 05 | 12 | 2018 | pk_12_total | 3.0 | 2.0 | 1.0 | * | * | 3 | 3 | 2 | 1 | 3 | |||||||||||||||||||||||||||||||||||||||||
3089940 | 3089940 | WI | Shawano | school | 623 | Public Schools-Multidistrict Charters | Bowler | 9100 | Rural Virtual Academy | charter | 2018 | pk_12_total | 4.0 | 4.0 | 2.0 | 8.0 | 2.0 | 1 | 1 | 10 | 4 | 4 | 2 | 8 | 2 | 1 | 1 | 10 | ||||||||||||||||||||||||||||||||||||||||||
3091059 | 3091059 | WI | Walworth | school | 1380 | Public Schools-Multidistrict Charters | Delavan-Darien | 9401 | Walworth Co Educ Alt High | charter | 2018 | pk_12_total | 4.0 | 3.0 | 2.0 | 5.0 | * | 1 | 7 | 4 | 3 | 2 | 5 | 1 | 7 | |||||||||||||||||||||||||||||||||||||||||||||
3093418 | 3093418 | WI | Rock | school | 5507020 | 2695 | Public school | Janesville | 550702002948 | 850 | Youth Services Center | Alternative School | No | Other | 04 | 12 | 2018 | pk_12_total | 4.0 | 6.0 | 1.0 | 10.0 | 1.0 | * | 5 | 11 | 4 | 6 | 1 | 10 | 1 | 5 | 11 | |||||||||||||||||||||||||||||||||||||
3093431 | 3093431 | WI | Jefferson | school | 2702 | Public Schools-Multidistrict Charters | Jefferson | 9803 | JEDI Virtual K-12 | charter | 2018 | pk_12_total | 4.0 | 3.0 | 1.0 | * | * | 4 | 4 | 3 | 1 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||
3093840 | 3093840 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732000833 | 700 | Wilson Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 4.0 | 87.0 | 67.0 | 11.0 | 90.0 | 79.0 | 141 | 28 | 169 | 4 | 87 | 67 | 11 | 90 | 79 | 141 | 28 | 169 | ||||||||||||||||||||||||||||||||||
3095392 | 3095392 | WI | Menominee | school | 5509070 | 3434 | Public school | Menominee Indian | 550907001069 | 20 | Keshena Primary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 4.0 | 18.0 | 423.0 | 1.0 | 238.0 | 208.0 | 413 | 90 | 446 | 4 | 18 | 423 | 1 | 238 | 208 | 413 | 90 | 446 | ||||||||||||||||||||||||||||||||||
3095733 | 3095733 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003371 | 162 | ALBA - Academia de Lenguaje y Bellas Artes | charter | Regular School | Yes | Elementary | PK | 05 | 2018 | pk_12_total | 4.0 | 488.0 | 2.0 | 269.0 | 225.0 | 446 | 91 | 494 | 4 | 488 | 2 | 269 | 225 | 446 | 91 | 494 | |||||||||||||||||||||||||||||||||||
3095859 | 3095859 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002395 | 89 | Brown Street Academy | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 4.0 | 308.0 | 3.0 | 1.0 | 6.0 | 162.0 | 160.0 | 311 | 70 | 322 | 4 | 308 | 3 | 1 | 6 | 162 | 160 | 311 | 70 | 322 | ||||||||||||||||||||||||||||||||
3096156 | 3096156 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001165 | 179 | Franklin Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 4.0 | 317.0 | 2.0 | 3.0 | 2.0 | 189.0 | 139.0 | 318 | 114 | 328 | 4 | 317 | 2 | 3 | 2 | 189 | 139 | 318 | 114 | 328 | ||||||||||||||||||||||||||||||||
3096239 | 3096239 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003050 | 120 | Green Bay Avenue School | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 4.0 | 238.0 | 3.0 | 1.0 | 5.0 | 133.0 | 118.0 | 243 | 27 | 251 | 4 | 238 | 3 | 1 | 5 | 133 | 118 | 243 | 27 | 251 | ||||||||||||||||||||||||||||||||
3096313 | 3096313 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001185 | 212 | Hawthorne Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 4.0 | 274.0 | 22.0 | 16.0 | 163.0 | 153.0 | 279 | 68 | 316 | 4 | 274 | 22 | 16 | 163 | 153 | 279 | 68 | 316 | ||||||||||||||||||||||||||||||||||
3096334 | 3096334 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001187 | 217 | Hi-Mount Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 4.0 | 211.0 | 13.0 | 1.0 | 13.0 | 117.0 | 125.0 | 225 | 38 | 242 | 4 | 211 | 13 | 1 | 13 | 117 | 125 | 225 | 38 | 242 | ||||||||||||||||||||||||||||||||
3096378 | 3096378 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001208 | 253 | Hopkins Lloyd Community School | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 4.0 | 255.0 | 5.0 | 2.0 | 4.0 | 4.0 | 153.0 | 121.0 | 245 | 77 | 274 | 4 | 255 | 5 | 2 | 4 | 4 | 153 | 121 | 245 | 77 | 274 | ||||||||||||||||||||||||||||||
3096461 | 3096461 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002961 | 210 | King International Baccalaureate Middle | Regular School | No | Middle | 06 | 08 | 2018 | pk_12_total | 4.0 | 423.0 | 22.0 | 4.0 | 14.0 | 16.0 | 243.0 | 240.0 | 381 | 73 | 483 | 4 | 423 | 22 | 4 | 14 | 16 | 243 | 240 | 381 | 73 | 483 | ||||||||||||||||||||||||||||||
3096465 | 3096465 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001178 | 199 | King Jr Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 4.0 | 277.0 | 5.0 | 1.0 | 157.0 | 130.0 | 269 | 76 | 287 | 4 | 277 | 5 | 1 | 157 | 130 | 269 | 76 | 287 | ||||||||||||||||||||||||||||||||||
3096663 | 3096663 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002853 | 111 | Milwaukee College Preparatory School -- 38th Street | charter | Regular School | Yes | Elementary | PK | 08 | 2018 | pk_12_total | 4.0 | 475.0 | 10.0 | 15.0 | 245.0 | 259.0 | 405 | 69 | 504 | 4 | 475 | 10 | 15 | 245 | 259 | 405 | 69 | 504 | |||||||||||||||||||||||||||||||||
3096717 | 3096717 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003036 | 885 | Milwaukee Excellence Charter School | charter | Regular School | Yes | High | 06 | 12 | 2018 | pk_12_total | 4.0 | 228.0 | 3.0 | 1.0 | 1.0 | 2.0 | 117.0 | 122.0 | 186 | 41 | 239 | 4 | 228 | 3 | 1 | 1 | 2 | 117 | 122 | 186 | 41 | 239 | |||||||||||||||||||||||||||||
3096832 | 3096832 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002730 | 419 | North Division High 0419 | Regular School | No | High | 09 | 12 | 2018 | pk_12_total | 4.0 | 343.0 | 2.0 | 2.0 | 4.0 | 188.0 | 167.0 | 304 | 147 | 355 | 4 | 343 | 2 | 2 | 4 | 188 | 167 | 304 | 147 | 355 | ||||||||||||||||||||||||||||||||
3096973 | 3096973 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003057 | 442 | South Accelerated Academy | Alternative School | No | High | 09 | 12 | 2018 | pk_12_total | 4.0 | 25.0 | 31.0 | 8.0 | 39.0 | 29.0 | * | 8 | 68 | 4 | 25 | 31 | 8 | 39 | 29 | 8 | 68 | |||||||||||||||||||||||||||||||||||
3097033 | 3097033 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002439 | 154 | Thurston Woods Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 4.0 | 392.0 | 15.0 | 2.0 | 8.0 | 215.0 | 206.0 | 353 | 57 | 421 | 4 | 392 | 15 | 2 | 8 | 215 | 206 | 353 | 57 | 421 | ||||||||||||||||||||||||||||||||
3101027 | 3101027 | WI | Marathon | school | 5628 | Public Schools-Multidistrict Charters | Stratford | 9100 | Rural Virtual Academy | charter | 2018 | pk_12_total | 4.0 | 1.0 | 3.0 | * | * | 4 | 4 | 1 | 3 | 4 | ||||||||||||||||||||||||||||||||||||||||||||||||
3101678 | 3101678 | WI | Vernon | school | 5515360 | 5985 | Public school | Viroqua Area | 551536002513 | 9407 | Vernon County Area Better Futures High | charter | Regular School | Yes | High | 10 | 12 | 2018 | pk_12_total | 4.0 | 2.0 | 2.0 | * | * | 4 | 4 | 2 | 2 | 4 | |||||||||||||||||||||||||||||||||||||||||
3102405 | 3102405 | WI | Milwaukee | school | 5515990 | 6244 | Public school | Wauwatosa | 551599002349 | 190 | Plank Road Complex | Alternative School | No | Other | KG | 12 | 2018 | pk_12_total | 4.0 | 57.0 | 3.0 | 60.0 | 4.0 | 58 | 18 | 64 | 4 | 57 | 3 | 60 | 4 | 58 | 18 | 64 | ||||||||||||||||||||||||||||||||||||
3102693 | 3102693 | WI | Washington | school | 5516290 | 6307 | Public school | West Bend | 551629002666 | 400 | Washington Street School | Alternative School | No | High | 06 | 12 | 2018 | pk_12_total | 4.0 | 2.0 | 3.0 | 3.0 | * | 6 | 4 | 2 | 3 | 3 | 6 | |||||||||||||||||||||||||||||||||||||||||
3090245 | 3090245 | WI | Milwaukee | school | 5500114 | 8114 | Non District Charter Schools | Capitol West Academy | 550011403355 | 100 | Capitol West Academy | charter | Regular School | Yes | Elementary | PK | 08 | 2018 | pk_12_total | 5.0 | 231.0 | 3.0 | 1.0 | 5.0 | 8.0 | 127.0 | 126.0 | * | 28 | 253 | 5 | 231 | 3 | 1 | 5 | 8 | 127 | 126 | 28 | 253 | ||||||||||||||||||||||||||||||
3091329 | 3091329 | WI | Eau Claire | school | 5504050 | 1554 | Public school | Eau Claire Area | 550405002658 | 800 | Second Avenue School | Alternative School | No | Other | 04 | 12 | 2018 | pk_12_total | 5.0 | 2.0 | 1.0 | 1.0 | 7.0 | 2.0 | * | * | 9 | 5 | 2 | 1 | 1 | 7 | 2 | 9 | ||||||||||||||||||||||||||||||||||||
3093989 | 3093989 | WI | Manitowoc | school | 5507440 | 2828 | Public school | Kiel Area | 550744002554 | 405 | Kiel eSchool | charter | Regular School | Yes | High | 07 | 12 | 2018 | pk_12_total | 5.0 | 2.0 | 3.0 | * | * | 5 | 5 | 2 | 3 | 5 | |||||||||||||||||||||||||||||||||||||||||
3095078 | 3095078 | WI | Dane | school | 5508790 | 3332 | Public school | Marshall | 550879001791 | 400 | Marshall Charter | charter | Regular School | Yes | High | 10 | 12 | 2018 | pk_12_total | 5.0 | 4.0 | 3.0 | 6.0 | * | 1 | 9 | 5 | 4 | 3 | 6 | 1 | 9 | ||||||||||||||||||||||||||||||||||||||
3096000 | 3096000 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001143 | 116 | Congress Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 5.0 | 703.0 | 17.0 | 4.0 | 5.0 | 3.0 | 372.0 | 365.0 | 613 | 137 | 737 | 5 | 703 | 17 | 4 | 5 | 3 | 372 | 365 | 613 | 137 | 737 | ||||||||||||||||||||||||||||||
3096084 | 3096084 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002438 | 148 | Elm Creative Arts Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 5.0 | 365.0 | 12.0 | 4.0 | 1.0 | 7.0 | 194.0 | 200.0 | 381 | 70 | 394 | 5 | 365 | 12 | 4 | 1 | 7 | 194 | 200 | 381 | 70 | 394 | ||||||||||||||||||||||||||||||
3096426 | 3096426 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001195 | 232 | Kagel Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 5.0 | 35.0 | 226.0 | 7.0 | 139.0 | 134.0 | * | 48 | 273 | 5 | 35 | 226 | 7 | 139 | 134 | 48 | 273 | |||||||||||||||||||||||||||||||||||
3096447 | 3096447 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001197 | 237 | Kilbourn Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 5.0 | 267.0 | 11.0 | 7.0 | 4.0 | 2.0 | 155.0 | 141.0 | 269 | 49 | 296 | 5 | 267 | 11 | 7 | 4 | 2 | 155 | 141 | 269 | 49 | 296 | ||||||||||||||||||||||||||||||
3096628 | 3096628 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002464 | 525 | Metcalfe Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 5.0 | 257.0 | 14.0 | 4.0 | 6.0 | 157.0 | 129.0 | 277 | 70 | 286 | 5 | 257 | 14 | 4 | 6 | 157 | 129 | 277 | 70 | 286 | ||||||||||||||||||||||||||||||||
3096947 | 3096947 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000856 | 1074 | Shalom High | Alternative School | No | High | 09 | 12 | 2018 | pk_12_total | 5.0 | 110.0 | 2.0 | 2.0 | 38.0 | 81.0 | 94 | 18 | 119 | 5 | 110 | 2 | 2 | 38 | 81 | 94 | 18 | 119 | ||||||||||||||||||||||||||||||||||
3096952 | 3096952 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001240 | 319 | Sherman Elementary | Regular School | No | Elementary | PK | 08 | 2018 | pk_12_total | 5.0 | 319.0 | 7.0 | 1.0 | 10.0 | 177.0 | 165.0 | 329 | 69 | 342 | 5 | 319 | 7 | 1 | 10 | 177 | 165 | 329 | 69 | 342 | ||||||||||||||||||||||||||||||||
3097191 | 3097191 | 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 | 2018 | pk_12_total | 5.0 | 292.0 | 8.0 | 1.0 | 1.0 | 147.0 | 160.0 | 47 | 307 | 5 | 292 | 8 | 1 | 1 | 147 | 160 | 47 | 307 | |||||||||||||||||||||||||||||||||
3101620 | 3101620 | WI | Dane | school | 5515330 | 5901 | Public school | Verona Area | 551533002285 | 110 | Early Childhood | Regular School | No | Prekindergarten | PK | PK | 2018 | pk_12_total | 5.0 | 4.0 | 1.0 | 1.0 | 4.0 | 7.0 | * | 11 | 5 | 4 | 1 | 1 | 4 | 7 | 11 | |||||||||||||||||||||||||||||||||||||
3102878 | 3102878 | WI | Langlade | school | 6440 | Public Schools-Multidistrict Charters | White Lake | 9100 | Rural Virtual Academy | charter | 2018 | pk_12_total | 5.0 | 1.0 | 4.0 | 2.0 | * | * | 6 | 5 | 1 | 4 | 2 | 6 | ||||||||||||||||||||||||||||||||||||||||||||||
3089766 | 3089766 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117002800 | 450 | Birchwood Blue Hills Charter School | charter | Regular School | Yes | High | 07 | 12 | 2018 | pk_12_total | 6.0 | 1.0 | 3.0 | 5.0 | 5.0 | 4 | * | 10 | 6 | 1 | 3 | 5 | 5 | 4 | 10 | ||||||||||||||||||||||||||||||||||||
3090421 | 3090421 | WI | Barron | school | 1080 | Public Schools-Multidistrict Charters | Chetek-Weyerhaeuser Area | 9410 | North Star Academy | charter | 2018 | pk_12_total | 6.0 | 1.0 | 2.0 | 5.0 | * | 1 | 7 | 6 | 1 | 2 | 5 | 1 | 7 | |||||||||||||||||||||||||||||||||||||||||||||
3095868 | 3095868 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960001132 | 92 | Browning Elementary | Regular School | No | Elementary | PK | 05 | 2018 | pk_12_total | 6.0 | 259.0 | 17.0 | 2.0 | 1.0 | 1.0 | 8.0 | 162.0 | 132.0 | 272 | 76 | 294 | 6 | 259 | 17 | 2 | 1 | 1 | 8 | 162 | 132 | 272 | 76 | 294 | ||||||||||||||||||||||||||||
3096277 | 3096277 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002979 | 880 | HAPA-Hmong American Peace Academy K3-12 | charter | Regular School | Yes | Other | PK | 12 | 2018 | pk_12_total | 6.0 | 9.0 | 10.0 | 1558.0 | 3.0 | 8.0 | 805.0 | 789.0 | 1433 | 72 | 1594 | 6 | 9 | 10 | 1558 | 3 | 8 | 805 | 789 | 1433 | 72 | 1594 | |||||||||||||||||||||||||||||
3097146 | 3097146 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960000681 | 399 | Wisconsin Conservatory of Lifelong Learning | Regular School | No | Other | PK | 12 | 2018 | pk_12_total | 6.0 | 563.0 | 20.0 | 8.0 | 18.0 | 16.0 | 328.0 | 303.0 | 581 | 191 | 631 | 6 | 563 | 20 | 8 | 18 | 16 | 328 | 303 | 581 | 191 | 631 | ||||||||||||||||||||||||||||||
3100130 | 3100130 | WI | Milwaukee | school | 5500043 | 8107 | Non District Charter Schools | School for Early Development and | 550004302497 | 1279 | School for Early Development and Achievement (SEDA) | charter | Regular School | Yes | Elementary | PK | 02 | 2018 | pk_12_total | 6.0 | 68.0 | 4.0 | 1.0 | 2.0 | 42.0 | 39.0 | 1 | 31 | 81 | 6 | 68 | 4 | 1 | 2 | 42 | 39 | 1 | 31 | 81 | |||||||||||||||||||||||||||||||
3100855 | 3100855 | WI | Milwaukee | school | 5500076 | 8136 | Non District Charter Schools | Stellar Collegiate Charter School | 550007603046 | 8136 | Stellar Collegiate Charter School | charter | Regular School | Yes | Elementary | PK | 05 | 2018 | pk_12_total | 6.0 | 23.0 | 89.0 | 1.0 | 1.0 | 73.0 | 47.0 | 88 | 20 | 120 | 6 | 23 | 89 | 1 | 1 | 73 | 47 | 88 | 20 | 120 |
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]);