enrollments
Data source: Big Local News · About: Big Local
14,749 rows where state = "WI" and year = 2019 sorted by hispanic_int
This data as json, CSV (advanced)
grade ✖
- pk_12_total 2,262
- grade_3 1,116
- grade_2 1,113
- grade_1 1,106
- grade_4 1,103
- kindergarten 1,101
- grade_5 1,050
- kindergarten_4_year_old 839
- grade_6 709
- grade_7 675
- grade_8 672
- grade_12 595
- grade_11 591
- grade_10 582
- pre_kindergarten 577
- grade_9 560
- kindergarten_3_year_old 98
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
3073958 | 3073958 | WI | Green | school | 5500120 | 63 | Public school | Albany | 550012000014 | 40 | Albany High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 92.0 | 2.0 | 1.0 | 1.0 | 39.0 | 57.0 | 32 | 19 | 96 | 92 | 2 | 1 | 1 | 39 | 57 | 32 | 19 | 96 | ||||||||||||||||||||||||||||||||||
3073991 | 3073991 | WI | Buffalo | school | 5500180 | 84 | Public school | Alma | 550018000018 | 40 | Alma High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 72.0 | 1.0 | 2.0 | 2.0 | 48.0 | 29.0 | 18 | 16 | 77 | 72 | 1 | 2 | 2 | 48 | 29 | 18 | 16 | 77 | ||||||||||||||||||||||||||||||||||
3074087 | 3074087 | WI | Langlade | school | 5500360 | 140 | Public school | Antigo Unified | 550036000039 | 100 | East Elementary | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 108.0 | 1.0 | 1.0 | 3.0 | 5.0 | 73.0 | 45.0 | 91 | 31 | 118 | 108 | 1 | 1 | 3 | 5 | 73 | 45 | 91 | 31 | 118 | ||||||||||||||||||||||||||||||||
3074169 | 3074169 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039003021 | 820 | Appleview | Special Education School | No | Other | PK | 12 | 2019 | pk_12_total | 31.0 | 1.0 | 1.0 | 1.0 | 2.0 | 22.0 | 14.0 | 5 | * | 36 | 31 | 1 | 1 | 1 | 2 | 22 | 14 | 5 | 36 | |||||||||||||||||||||||||||||||||
3074446 | 3074446 | WI | Ashland | school | 5500510 | 170 | Public school | Ashland | 550051003017 | 400 | Lake Superior High | charter | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 13.0 | 1.0 | 10.0 | 12.0 | 12.0 | * | 6 | 24 | 13 | 1 | 10 | 12 | 12 | 6 | 24 | ||||||||||||||||||||||||||||||||||||
3074693 | 3074693 | WI | Barron | school | 5500870 | 308 | Public school | Barron Area | 550087000117 | 120 | Ridgeland-Dallas Elementary | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 65.0 | 1.0 | 30.0 | 36.0 | 35 | 5 | 66 | 65 | 1 | 30 | 36 | 35 | 5 | 66 | ||||||||||||||||||||||||||||||||||||||
3074729 | 3074729 | WI | Bayfield | school | 5500900 | 315 | Public school | Bayfield | 550090002358 | 60 | La Pointe Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 12.0 | 1.0 | 3.0 | 1.0 | 5.0 | 12.0 | * | 17 | 12 | 1 | 3 | 1 | 5 | 12 | 17 | |||||||||||||||||||||||||||||||||||||
3075022 | 3075022 | WI | Washburn | school | 5501170 | 441 | Public school | Birchwood | 550117000169 | 40 | Birchwood High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 69.0 | 1.0 | 1.0 | 1.0 | 3.0 | 36.0 | 39.0 | 36 | 15 | 75 | 69 | 1 | 1 | 1 | 3 | 36 | 39 | 36 | 15 | 75 | ||||||||||||||||||||||||||||||||
3075322 | 3075322 | WI | Racine | school | 777 | Public Schools-Multidistrict Charters | Burlington Area | 9803 | JEDI Virtual K-12 | charter | 2019 | pk_12_total | 8.0 | 1.0 | 1.0 | 2.0 | 8.0 | 3 | 1 | 10 | 8 | 1 | 1 | 2 | 8 | 3 | 1 | 10 | ||||||||||||||||||||||||||||||||||||||||||
3075432 | 3075432 | WI | Barron | school | 5502130 | 903 | Public school | Cameron | 550213002851 | 800 | Cameron Academy of Virtual Education | charter | Alternative School | Yes | Other | PK | 12 | 2019 | pk_12_total | 83.0 | 1.0 | 8.0 | 35.0 | 57.0 | 32 | 2 | 92 | 83 | 1 | 8 | 35 | 57 | 32 | 2 | 92 | |||||||||||||||||||||||||||||||||||
3075618 | 3075618 | WI | Price | school | 5500058 | 1071 | Public school | Chequamegon | 550005802780 | 450 | Class ACT Charter | charter | Career and Technical School | Yes | High | 09 | 12 | 2019 | pk_12_total | 26.0 | 1.0 | 3.0 | 18.0 | 12.0 | 23 | 8 | 30 | 26 | 1 | 3 | 18 | 12 | 23 | 8 | 30 | |||||||||||||||||||||||||||||||||||
3075623 | 3075623 | WI | Price | school | 5500058 | 1071 | Public school | Chequamegon | 550005800590 | 100 | Glidden Elementary | Regular School | No | Elementary | PK | 03 | 2019 | pk_12_total | 30.0 | 2.0 | 1.0 | 21.0 | 12.0 | 24 | 5 | 33 | 30 | 2 | 1 | 21 | 12 | 24 | 5 | 33 | ||||||||||||||||||||||||||||||||||||
3075715 | 3075715 | WI | Chippewa | school | 5502550 | 1092 | Public school | Chippewa Falls Area Unified | 550255000286 | 140 | Jim Falls Elementary | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 133.0 | 1.0 | 1.0 | 1.0 | 4.0 | 75.0 | 65.0 | 39 | 12 | 140 | 133 | 1 | 1 | 1 | 4 | 75 | 65 | 39 | 12 | 140 | ||||||||||||||||||||||||||||||||
3075853 | 3075853 | WI | Clark | school | 1162 | Public Schools-Multidistrict Charters | Colby | 9100 | Rural Virtual Academy | charter | 2019 | pk_12_total | 9.0 | 1.0 | 2.0 | 8.0 | * | 10 | 9 | 1 | 2 | 8 | 10 | |||||||||||||||||||||||||||||||||||||||||||||||
3076427 | 3076427 | WI | Bayfield | school | 5503810 | 1491 | Public school | Drummond Area | 550381000397 | 50 | Drummond Junior High | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 50.0 | 1.0 | 1.0 | 2.0 | 4.0 | 24.0 | 34.0 | 27 | 4 | 58 | 50 | 1 | 1 | 2 | 4 | 24 | 34 | 27 | 4 | 58 | ||||||||||||||||||||||||||||||||
3076613 | 3076613 | WI | Marathon | school | 5504080 | 1561 | Public school | Edgar | 550408002391 | 23 | Edgar Middle | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 129.0 | 1.0 | 4.0 | 1.0 | 61.0 | 74.0 | 32 | 14 | 135 | 129 | 1 | 4 | 1 | 61 | 74 | 32 | 14 | 135 | ||||||||||||||||||||||||||||||||||
3076649 | 3076649 | WI | Langlade | school | 5504170 | 1582 | Public school | Elcho | 550417000448 | 40 | Elcho High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 71.0 | 1.0 | 6.0 | 4.0 | 41.0 | 41.0 | 38 | 10 | 82 | 71 | 1 | 6 | 4 | 41 | 41 | 38 | 10 | 82 | ||||||||||||||||||||||||||||||||||
3076963 | 3076963 | WI | Rusk | school | 5514970 | 5757 | Public school | Flambeau | 551497001951 | 40 | Flambeau High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 169.0 | 1.0 | 1.0 | 77.0 | 94.0 | 78 | 22 | 171 | 169 | 1 | 1 | 77 | 94 | 78 | 22 | 171 | ||||||||||||||||||||||||||||||||||||
3076972 | 3076972 | WI | Florence | school | 5504650 | 1855 | Public school | Florence County | 550465000489 | 40 | Florence Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 204.0 | 1.0 | 6.0 | 2.0 | 112.0 | 101.0 | 127 | 23 | 213 | 204 | 1 | 6 | 2 | 112 | 101 | 127 | 23 | 213 | ||||||||||||||||||||||||||||||||||
3076987 | 3076987 | WI | Florence | school | 5504650 | 1855 | Public school | Florence County | 550465002360 | 80 | Florence Middle | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 59.0 | 1.0 | 1.0 | 1.0 | 30.0 | 32.0 | 36 | 8 | 62 | 59 | 1 | 1 | 1 | 30 | 32 | 36 | 8 | 62 | ||||||||||||||||||||||||||||||||||
3077217 | 3077217 | WI | Polk | school | 5504860 | 1939 | Public school | Frederic | 550486000526 | 40 | Frederic 6-12 School | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 189.0 | 7.0 | 1.0 | 4.0 | 1.0 | 1.0 | 107.0 | 96.0 | 116 | 24 | 203 | 189 | 7 | 1 | 4 | 1 | 1 | 107 | 96 | 116 | 24 | 203 | ||||||||||||||||||||||||||||||
3077251 | 3077251 | WI | Trempealeau | school | 5504960 | 2009 | Public school | Galesville-Ettrick-Trempealeau | 550496000535 | 20 | Ettrick Elementary | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 108.0 | 1.0 | 4.0 | 57.0 | 56.0 | 31 | 12 | 113 | 108 | 1 | 4 | 57 | 56 | 31 | 12 | 113 | ||||||||||||||||||||||||||||||||||||
3077393 | 3077393 | WI | Taylor | school | 5505280 | 2135 | Public school | Gilman | 550528000568 | 60 | Gilman High | Regular School | No | High | 07 | 12 | 2019 | pk_12_total | 158.0 | 1.0 | 4.0 | 80.0 | 83.0 | 94 | 22 | 163 | 158 | 1 | 4 | 80 | 83 | 94 | 22 | 163 | ||||||||||||||||||||||||||||||||||||
3077401 | 3077401 | WI | Buffalo | school | 5505370 | 2142 | Public school | Gilmanton | 550537000573 | 40 | Gilmanton Elementary | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 55.0 | 1.0 | 24.0 | 32.0 | 33 | 8 | 56 | 55 | 1 | 24 | 32 | 33 | 8 | 56 | ||||||||||||||||||||||||||||||||||||||
3078136 | 3078136 | WI | Iowa | school | 5506420 | 2527 | Public school | Highland | 550642002829 | 250 | Highland Community Middle | charter | Regular School | Yes | Middle | 06 | 08 | 2019 | pk_12_total | 63.0 | 1.0 | 1.0 | 1.0 | 1.0 | 3.0 | 41.0 | 29.0 | 11 | 11 | 70 | 63 | 1 | 1 | 1 | 1 | 3 | 41 | 29 | 11 | 11 | 70 | |||||||||||||||||||||||||||||
3078487 | 3078487 | WI | Iowa | school | 5506870 | 2646 | Public school | Iowa-Grant | 550687000745 | 40 | Iowa-Grant High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 171.0 | 1.0 | 1.0 | 86.0 | 87.0 | 57 | 28 | 173 | 171 | 1 | 1 | 86 | 87 | 57 | 28 | 173 | ||||||||||||||||||||||||||||||||||||
3078628 | 3078628 | WI | Rock | school | 5507020 | 2695 | Public school | Janesville | 550702002952 | 450 | Rock University High | charter | Regular School | Yes | High | 10 | 12 | 2019 | pk_12_total | 22.0 | 1.0 | 1.0 | 8.0 | 16.0 | 9 | 2 | 24 | 22 | 1 | 1 | 8 | 16 | 9 | 2 | 24 | |||||||||||||||||||||||||||||||||||
3078938 | 3078938 | WI | Kenosha | school | 5507320 | 2793 | Public school | Kenosha | 550732002910 | 800 | Kenosha eSchool K-12 | charter | Regular School | Yes | Other | KG | 12 | 2019 | pk_12_total | 24.0 | 1.0 | 2.0 | 11.0 | 16.0 | 2 | 27 | 24 | 1 | 2 | 11 | 16 | 2 | 27 | |||||||||||||||||||||||||||||||||||||
3079473 | 3079473 | WI | Vernon | school | 5507560 | 2863 | Public school | La Farge | 550756000873 | 40 | La Farge High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 61.0 | 1.0 | 3.0 | 34.0 | 31.0 | 31 | 11 | 65 | 61 | 1 | 3 | 34 | 31 | 31 | 11 | 65 | ||||||||||||||||||||||||||||||||||||
3079615 | 3079615 | WI | Grant | school | 5507770 | 2912 | Public school | Lancaster Community | 550777000891 | 20 | Lancaster High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 249.0 | 7.0 | 1.0 | 3.0 | 7.0 | 139.0 | 128.0 | 85 | 34 | 267 | 249 | 7 | 1 | 3 | 7 | 139 | 128 | 85 | 34 | 267 | ||||||||||||||||||||||||||||||||
3079633 | 3079633 | WI | Forest | school | 5507830 | 2940 | Public school | Laona | 550783000893 | 20 | Laona High | Regular School | No | High | 07 | 12 | 2019 | pk_12_total | 86.0 | 1.0 | 10.0 | 1.0 | 49.0 | 49.0 | 44 | 9 | 98 | 86 | 1 | 10 | 1 | 49 | 49 | 44 | 9 | 98 | ||||||||||||||||||||||||||||||||||
3079690 | 3079690 | WI | Outagamie | school | 5508160 | 3129 | Public school | Little Chute Area | 550816002959 | 130 | Flex Academy | charter | Regular School | Yes | Elementary | KG | 08 | 2019 | pk_12_total | 90.0 | 4.0 | 1.0 | 4.0 | 41.0 | 58.0 | 27 | 11 | 99 | 90 | 4 | 1 | 4 | 41 | 58 | 27 | 11 | 99 | |||||||||||||||||||||||||||||||||
3080328 | 3080328 | WI | Waupaca | school | 5508730 | 3318 | Public school | Marion | 550873001005 | 100 | Marion High | Regular School | No | High | 07 | 12 | 2019 | pk_12_total | 167.0 | 2.0 | 1.0 | 4.0 | 3.0 | 94.0 | 83.0 | 67 | 22 | 177 | 167 | 2 | 1 | 4 | 3 | 94 | 83 | 67 | 22 | 177 | ||||||||||||||||||||||||||||||||
3080798 | 3080798 | WI | Ozaukee | school | 5509130 | 3479 | Public school | Mequon-Thiensville | 550913002992 | 150 | Range Line Early Childhood | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 12.0 | 1.0 | 1.0 | 10.0 | 4.0 | 14 | 12 | 1 | 1 | 10 | 4 | 14 | ||||||||||||||||||||||||||||||||||||||||
3080972 | 3080972 | WI | Rock | school | 5509570 | 3612 | Public school | Milton | 550957001115 | 40 | Consolidated Elementary | Regular School | No | Elementary | KG | 03 | 2019 | pk_12_total | 81.0 | 1.0 | 1.0 | 43.0 | 40.0 | 8 | 4 | 83 | 81 | 1 | 1 | 43 | 40 | 8 | 4 | 83 | ||||||||||||||||||||||||||||||||||||
3081090 | 3081090 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960002707 | 432 | Banner Preparatory School of Milwaukee | Alternative School | No | High | 09 | 12 | 2019 | pk_12_total | 55.0 | 1.0 | 2.0 | 35.0 | 23.0 | 51 | 19 | 58 | 55 | 1 | 2 | 35 | 23 | 51 | 19 | 58 | ||||||||||||||||||||||||||||||||||||
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 | ||||||||||||||||||||||||||||||||
3082391 | 3082391 | WI | Milwaukee | school | 5509600 | 3619 | Public school | Milwaukee | 550960003055 | 448 | Vincent Accelerated Academy | Alternative School | No | High | 09 | 12 | 2019 | pk_12_total | 33.0 | 1.0 | 1.0 | 19.0 | 16.0 | 28 | 14 | 35 | 33 | 1 | 1 | 19 | 16 | 28 | 14 | 35 | ||||||||||||||||||||||||||||||||||||
3082525 | 3082525 | WI | Oneida | school | 5509690 | 3640 | Public school | Minocqua J1 | 550969002873 | 100 | Creative Minds--Minocqua School of 21st Century Creativity and Design | charter | Regular School | Yes | Elementary | 03 | 05 | 2019 | pk_12_total | 38.0 | 1.0 | 1.0 | 1.0 | 1.0 | 16.0 | 26.0 | 21 | 4 | 42 | 38 | 1 | 1 | 1 | 1 | 16 | 26 | 21 | 4 | 42 | |||||||||||||||||||||||||||||||
3082626 | 3082626 | WI | Green | school | 3682 | Public Schools-Multidistrict Charters | Monroe | 9803 | JEDI Virtual K-12 | charter | 2019 | pk_12_total | 10.0 | 1.0 | 3.0 | 8.0 | 3 | 2 | 11 | 10 | 1 | 3 | 8 | 3 | 2 | 11 | ||||||||||||||||||||||||||||||||||||||||||||
3082668 | 3082668 | WI | Marquette | school | 5509870 | 3689 | Public school | Montello | 550987002821 | 420 | High Marq Environmental Charter School | charter | Regular School | Yes | High | 07 | 12 | 2019 | pk_12_total | 31.0 | 1.0 | 1.0 | 17.0 | 16.0 | 17 | 4 | 33 | 31 | 1 | 1 | 17 | 16 | 17 | 4 | 33 | |||||||||||||||||||||||||||||||||||
3082690 | 3082690 | WI | Green | school | 5509900 | 3696 | Public school | Monticello | 550990001304 | 20 | Monticello Elementary | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 138.0 | 1.0 | 1.0 | 5.0 | 77.0 | 68.0 | 57 | 21 | 145 | 138 | 1 | 1 | 5 | 77 | 68 | 57 | 21 | 145 | ||||||||||||||||||||||||||||||||||
3082704 | 3082704 | WI | Green | school | 5509900 | 3696 | Public school | Monticello | 550990000384 | 30 | Monticello Middle | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 76.0 | 2.0 | 1.0 | 1.0 | 37.0 | 43.0 | 30 | 10 | 80 | 76 | 2 | 1 | 1 | 37 | 43 | 30 | 10 | 80 | ||||||||||||||||||||||||||||||||||
3083176 | 3083176 | WI | Waupaca | school | 5510590 | 3955 | Public school | New London | 551059001386 | 100 | Readfield Elementary | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 150.0 | 1.0 | 1.0 | 1.0 | 75.0 | 78.0 | 27 | 19 | 153 | 150 | 1 | 1 | 1 | 75 | 78 | 27 | 19 | 153 | ||||||||||||||||||||||||||||||||||
3083226 | 3083226 | WI | Marinette | school | 5510680 | 3969 | Public school | Niagara | 551068001393 | 20 | Niagara Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 222.0 | 3.0 | 1.0 | 6.0 | 118.0 | 114.0 | 106 | 38 | 232 | 222 | 3 | 1 | 6 | 118 | 114 | 106 | 38 | 232 | ||||||||||||||||||||||||||||||||||
3083404 | 3083404 | WI | Vilas | school | 5503860 | 1526 | Public school | Northland Pines | 550386003013 | 410 | School of Options & Applied Research High | charter | Regular School | Yes | High | 08 | 12 | 2019 | pk_12_total | 22.0 | 1.0 | 1.0 | 2.0 | 9.0 | 17.0 | 14 | 2 | 26 | 22 | 1 | 1 | 2 | 9 | 17 | 14 | 2 | 26 | |||||||||||||||||||||||||||||||||
3083414 | 3083414 | WI | Washburn | school | 5509720 | 3654 | Public school | Northwood | 550972002877 | 200 | NorthStar Community Charter School | charter | Regular School | Yes | Middle | 04 | 08 | 2019 | pk_12_total | 19.0 | 1.0 | 14.0 | 6.0 | 7 | 2 | 20 | 19 | 1 | 14 | 6 | 7 | 2 | 20 | |||||||||||||||||||||||||||||||||||||
3083614 | 3083614 | WI | Oconto | school | 5510950 | 4074 | Public school | Oconto Falls Public | 551095001853 | 400 | Falls Alternative Learning Site (FALS) | charter | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 12.0 | 1.0 | 1.0 | 9.0 | 5.0 | * | 6 | 14 | 12 | 1 | 1 | 9 | 5 | 6 | 14 | ||||||||||||||||||||||||||||||||||||
3083793 | 3083793 | WI | Winnebago | school | 5511190 | 4179 | Public school | Oshkosh Area | 551119003364 | 170 | Accelerated Advanced Learning Program | charter | Regular School | Yes | Middle | 04 | 08 | 2019 | pk_12_total | 49.0 | 1.0 | 8.0 | 2.0 | 28.0 | 32.0 | 5 | 2 | 60 | 49 | 1 | 8 | 2 | 28 | 32 | 5 | 2 | 60 | |||||||||||||||||||||||||||||||||
3084066 | 3084066 | WI | Lafayette | school | 5501310 | 490 | Public school | Pecatonica Area | 550131000182 | 40 | Pecatonica High | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 203.0 | 1.0 | 1.0 | 117.0 | 88.0 | 77 | 24 | 205 | 203 | 1 | 1 | 117 | 88 | 77 | 24 | 205 | ||||||||||||||||||||||||||||||||||||
3084080 | 3084080 | WI | Pepin | school | 5511580 | 4270 | Public school | Pepin Area | 551158001531 | 20 | Pepin Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 126.0 | 1.0 | 2.0 | 74.0 | 55.0 | 26 | 24 | 129 | 126 | 1 | 2 | 74 | 55 | 26 | 24 | 129 | ||||||||||||||||||||||||||||||||||||
3084089 | 3084089 | WI | Pepin | school | 5511580 | 4270 | Public school | Pepin Area | 551158001532 | 40 | Pepin High | Regular School | No | High | 07 | 12 | 2019 | pk_12_total | 94.0 | 1.0 | 1.0 | 49.0 | 47.0 | 17 | 13 | 96 | 94 | 1 | 1 | 49 | 47 | 17 | 13 | 96 | ||||||||||||||||||||||||||||||||||||
3084330 | 3084330 | WI | Columbia | school | 5512060 | 4501 | Public school | Portage Community | 551206002174 | 400 | Portage Academy of Achievement | Alternative School | No | High | 09 | 12 | 2019 | pk_12_total | 19.0 | 1.0 | 9.0 | 11.0 | 2 | 3 | 20 | 19 | 1 | 9 | 11 | 2 | 3 | 20 | ||||||||||||||||||||||||||||||||||||||
3084363 | 3084363 | WI | Grant | school | 5512090 | 4529 | Public school | Potosi | 551209001576 | 40 | Potosi High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 111.0 | 1.0 | 1.0 | 68.0 | 45.0 | 25 | 24 | 113 | 111 | 1 | 1 | 68 | 45 | 25 | 24 | 113 | ||||||||||||||||||||||||||||||||||||
3084433 | 3084433 | WI | Barron | school | 5512180 | 4557 | Public school | Prairie Farm Public | 551218001586 | 40 | Prairie Farm High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 86.0 | 1.0 | 1.0 | 35.0 | 53.0 | 35 | 14 | 88 | 86 | 1 | 1 | 35 | 53 | 35 | 14 | 88 | ||||||||||||||||||||||||||||||||||||
3084442 | 3084442 | WI | Price | school | 5512210 | 4571 | Public school | Prentice | 551221001588 | 40 | Prentice Elementary | Regular School | No | Elementary | PK | 04 | 2019 | pk_12_total | 102.0 | 1.0 | 1.0 | 1.0 | 6.0 | 59.0 | 52.0 | 59 | 32 | 111 | 102 | 1 | 1 | 1 | 6 | 59 | 52 | 59 | 32 | 111 | ||||||||||||||||||||||||||||||||
3084837 | 3084837 | WI | Sauk | school | 5512660 | 4753 | Public school | Reedsburg | 551266001662 | 20 | Ironton-La Valle Elementary | Regular School | No | Elementary | PK | 03 | 2019 | pk_12_total | 65.0 | 1.0 | 1.0 | 2.0 | 30.0 | 39.0 | 34 | 7 | 69 | 65 | 1 | 1 | 2 | 30 | 39 | 34 | 7 | 69 | ||||||||||||||||||||||||||||||||||
3084842 | 3084842 | WI | Sauk | school | 5512660 | 4753 | Public school | Reedsburg | 551266001663 | 40 | Loganville Elementary | Regular School | No | Elementary | PK | 03 | 2019 | pk_12_total | 52.0 | 1.0 | 23.0 | 30.0 | 19 | 5 | 53 | 52 | 1 | 23 | 30 | 19 | 5 | 53 | ||||||||||||||||||||||||||||||||||||||
3084961 | 3084961 | WI | Barron | school | 5512810 | 4802 | Public school | Rice Lake Area | 551281002528 | 150 | Head Start | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 38.0 | 1.0 | 23.0 | 16.0 | 1 | 7 | 39 | 38 | 1 | 23 | 16 | 1 | 7 | 39 | ||||||||||||||||||||||||||||||||||||||
3084963 | 3084963 | WI | Barron | school | 5512810 | 4802 | Public school | Rice Lake Area | 551281002526 | 110 | Hilltop Day Care and Preschool | Regular School | No | Prekindergarten | PK | PK | 2019 | pk_12_total | 18.0 | 1.0 | 1.0 | 1.0 | 12.0 | 9.0 | 21 | 18 | 1 | 1 | 1 | 12 | 9 | 21 | ||||||||||||||||||||||||||||||||||||||
3084971 | 3084971 | WI | Barron | school | 5512810 | 4802 | Public school | Rice Lake Area | 551281002932 | 450 | Northern Lakes Regional Academy | charter | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 30.0 | 1.0 | 1.0 | 22.0 | 10.0 | 15 | 3 | 32 | 30 | 1 | 1 | 22 | 10 | 15 | 3 | 32 | |||||||||||||||||||||||||||||||||||
3085189 | 3085189 | WI | Grant | school | 5510140 | 3850 | Public school | Riverdale | 551014001328 | 120 | Riverdale High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 167.0 | 2.0 | 1.0 | 2.0 | 5.0 | 79.0 | 98.0 | 88 | 43 | 177 | 167 | 2 | 1 | 2 | 5 | 79 | 98 | 88 | 43 | 177 | ||||||||||||||||||||||||||||||||
3085223 | 3085223 | WI | Fond du Lac | school | 5513100 | 4956 | Public school | Rosendale-Brandon | 551310002970 | 400 | Cirrus Charter High | charter | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 7.0 | 1.0 | 3.0 | 5.0 | 8 | 7 | 1 | 3 | 5 | 8 | |||||||||||||||||||||||||||||||||||||||||
3085313 | 3085313 | WI | Polk | school | 5513230 | 5019 | Public school | Saint Croix Falls | 551323001744 | 40 | Dresser Elementary | Regular School | No | Elementary | PK | KG | 2019 | pk_12_total | 63.0 | 1.0 | 6.0 | 43.0 | 27.0 | 25 | 13 | 70 | 63 | 1 | 6 | 43 | 27 | 25 | 13 | 70 | ||||||||||||||||||||||||||||||||||||
3085434 | 3085434 | WI | Crawford | school | 5513470 | 5124 | Public school | Seneca Area | 551347001765 | 80 | Seneca High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 76.0 | 1.0 | 2.0 | 2.0 | 48.0 | 33.0 | 45 | 9 | 81 | 76 | 1 | 2 | 2 | 48 | 33 | 45 | 9 | 81 | ||||||||||||||||||||||||||||||||||
3085439 | 3085439 | WI | Crawford | school | 5513470 | 5124 | Public school | Seneca Area | 551347002399 | 28 | Seneca Junior High | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 79.0 | 1.0 | 1.0 | 1.0 | 43.0 | 39.0 | 48 | 7 | 82 | 79 | 1 | 1 | 1 | 43 | 39 | 48 | 7 | 82 | ||||||||||||||||||||||||||||||||||
3085857 | 3085857 | WI | Douglas | school | 5513980 | 5397 | Public school | Solon Springs | 551398001911 | 800 | Solon Springs School | Regular School | No | Other | PK | 12 | 2019 | pk_12_total | 257.0 | 1.0 | 1.0 | 3.0 | 1.0 | 10.0 | 148.0 | 125.0 | 127 | 38 | 273 | 257 | 1 | 1 | 3 | 1 | 10 | 148 | 125 | 127 | 38 | 273 | ||||||||||||||||||||||||||||||
3085966 | 3085966 | WI | Grant | school | 5506300 | 2485 | Public school | Southwestern Wisconsin | 550630003097 | 200 | Southwestern Wisconsin Community Middle | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 101.0 | 1.0 | 1.0 | 41.0 | 62.0 | 41 | 13 | 103 | 101 | 1 | 1 | 41 | 62 | 41 | 13 | 103 | ||||||||||||||||||||||||||||||||||||
3085979 | 3085979 | WI | Grant | school | 5506300 | 2485 | Public school | Southwestern Wisconsin | 550630000696 | 60 | Southwestern Wisconsin High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 170.0 | 1.0 | 1.0 | 84.0 | 88.0 | 53 | 10 | 172 | 170 | 1 | 1 | 84 | 88 | 53 | 10 | 172 | ||||||||||||||||||||||||||||||||||||
3086086 | 3086086 | WI | Pierce | school | 5514340 | 5586 | Public school | Spring Valley | 551434001862 | 60 | Spring Valley Elementary | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 373.0 | 1.0 | 1.0 | 1.0 | 2.0 | 214.0 | 164.0 | 123 | 34 | 378 | 373 | 1 | 1 | 1 | 2 | 214 | 164 | 123 | 34 | 378 | ||||||||||||||||||||||||||||||||
3086141 | 3086141 | WI | Portage | school | 5514490 | 5607 | Public school | Stevens Point Area Public | 551449002210 | 360 | CARE Concerned About Reaching Everyone | charter | Alternative School | Yes | Middle | 07 | 09 | 2019 | pk_12_total | 13.0 | 1.0 | 1.0 | 1.0 | 13.0 | 3.0 | 10 | 2 | 16 | 13 | 1 | 1 | 1 | 13 | 3 | 10 | 2 | 16 | |||||||||||||||||||||||||||||||||
3086232 | 3086232 | WI | Calumet | school | 5514520 | 5614 | Public school | Stockbridge | 551452001882 | 20 | Stockbridge Elementary | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 92.0 | 1.0 | 1.0 | 45.0 | 49.0 | 20 | 7 | 94 | 92 | 1 | 1 | 45 | 49 | 20 | 7 | 94 | ||||||||||||||||||||||||||||||||||||
3086240 | 3086240 | WI | Calumet | school | 5514520 | 5614 | Public school | Stockbridge | 551452001883 | 40 | Stockbridge High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 54.0 | 1.0 | 3.0 | 32.0 | 26.0 | 11 | 5 | 58 | 54 | 1 | 3 | 32 | 26 | 11 | 5 | 58 | ||||||||||||||||||||||||||||||||||||
3086245 | 3086245 | WI | Calumet | school | 5514520 | 5614 | Public school | Stockbridge | 551452002499 | 200 | Stockbridge Middle | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 47.0 | 1.0 | 1.0 | 27.0 | 22.0 | 15 | 11 | 49 | 47 | 1 | 1 | 27 | 22 | 15 | 11 | 49 | ||||||||||||||||||||||||||||||||||||
3086267 | 3086267 | WI | Dane | school | 5621 | Public Schools-Multidistrict Charters | Stoughton Area | 9803 | JEDI Virtual K-12 | charter | 2019 | pk_12_total | 17.0 | 1.0 | 7.0 | 11.0 | 5 | 1 | 18 | 17 | 1 | 7 | 11 | 5 | 1 | 18 | ||||||||||||||||||||||||||||||||||||||||||||
3086380 | 3086380 | WI | Dane | school | 5656 | Public Schools-Multidistrict Charters | Sun Prairie Area | 9803 | JEDI Virtual K-12 | charter | 2019 | pk_12_total | 16.0 | 1.0 | 1.0 | 1.0 | 6.0 | 13.0 | 6 | 2 | 19 | 16 | 1 | 1 | 1 | 6 | 13 | 6 | 2 | 19 | ||||||||||||||||||||||||||||||||||||||||
3086578 | 3086578 | WI | Oneida | school | 5514850 | 5733 | Public school | Three Lakes | 551485002954 | 300 | Three Lakes Junior High | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 78.0 | 1.0 | 1.0 | 1.0 | 44.0 | 37.0 | 27 | 20 | 81 | 78 | 1 | 1 | 1 | 44 | 37 | 27 | 20 | 81 | ||||||||||||||||||||||||||||||||||
3086590 | 3086590 | WI | Shawano | school | 5514880 | 5740 | Public school | Tigerton | 551488001932 | 40 | Tigerton High | Regular School | No | High | 06 | 12 | 2019 | pk_12_total | 99.0 | 1.0 | 5.0 | 5.0 | 55.0 | 55.0 | 71 | 19 | 110 | 99 | 1 | 5 | 5 | 55 | 55 | 71 | 19 | 110 | ||||||||||||||||||||||||||||||||||
3086627 | 3086627 | WI | Monroe | school | 5514910 | 5747 | Public school | Tomah Area | 551491001937 | 140 | Oakdale Elementary | Regular School | No | Elementary | PK | 01 | 2019 | pk_12_total | 73.0 | 1.0 | 2.0 | 2.0 | 42.0 | 36.0 | 43 | 31 | 78 | 73 | 1 | 2 | 2 | 42 | 36 | 43 | 31 | 78 | ||||||||||||||||||||||||||||||||||
3086636 | 3086636 | WI | Monroe | school | 5747 | Public Schools-Multidistrict Charters | Tomah Area | 9100 | Rural Virtual Academy | charter | 2019 | pk_12_total | 44.0 | 1.0 | 25.0 | 20.0 | 23 | 13 | 45 | 44 | 1 | 25 | 20 | 23 | 13 | 45 | ||||||||||||||||||||||||||||||||||||||||||||
3086667 | 3086667 | WI | Monroe | school | 5514910 | 5747 | Public school | Tomah Area | 551491001940 | 220 | Warrens Elementary | Regular School | No | Elementary | PK | 05 | 2019 | pk_12_total | 125.0 | 1.0 | 1.0 | 5.0 | 59.0 | 73.0 | 58 | 16 | 132 | 125 | 1 | 1 | 5 | 59 | 73 | 58 | 16 | 132 | ||||||||||||||||||||||||||||||||||
3086974 | 3086974 | WI | Vernon | school | 5515360 | 5985 | Public school | Viroqua Area | 551536001936 | 410 | Laurel High | charter | Regular School | Yes | High | 09 | 12 | 2019 | pk_12_total | 43.0 | 1.0 | 1.0 | 15.0 | 30.0 | 25 | 45 | 43 | 1 | 1 | 15 | 30 | 25 | 45 | |||||||||||||||||||||||||||||||||||||
3087038 | 3087038 | WI | Bayfield | school | 5515540 | 6027 | Public school | Washburn | 551554002453 | 10 | Washburn Elementary | Regular School | No | Elementary | PK | 06 | 2019 | pk_12_total | 252.0 | 4.0 | 1.0 | 37.0 | 4.0 | 160.0 | 138.0 | 122 | 47 | 298 | 252 | 4 | 1 | 37 | 4 | 160 | 138 | 122 | 47 | 298 | ||||||||||||||||||||||||||||||||
3087055 | 3087055 | WI | Door | school | 5515570 | 6069 | Public school | Washington | 551557001986 | 20 | Washington Island Elementary | Regular School | No | Elementary | PK | 08 | 2019 | pk_12_total | 51.0 | 1.0 | 1.0 | 30.0 | 23.0 | 3 | 53 | 51 | 1 | 1 | 30 | 23 | 3 | 53 | ||||||||||||||||||||||||||||||||||||||
3087065 | 3087065 | WI | Door | school | 5515570 | 6069 | Public school | Washington | 551557001987 | 40 | Washington Island High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 20.0 | 1.0 | 1.0 | 5.0 | 11.0 | 16.0 | 5 | 27 | 20 | 1 | 1 | 5 | 11 | 16 | 5 | 27 | ||||||||||||||||||||||||||||||||||||
3087151 | 3087151 | WI | Jefferson | school | 5515750 | 6125 | Public school | Watertown Unified | 551575001998 | 60 | Lebanon Elementary | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 52.0 | 1.0 | 6.0 | 33.0 | 26.0 | 20 | 4 | 59 | 52 | 1 | 6 | 33 | 26 | 20 | 4 | 59 | ||||||||||||||||||||||||||||||||||||
3087310 | 3087310 | WI | Waukesha | school | 5515780 | 6174 | Public school | Waukesha | 551578003070 | 800 | Riverview School | Alternative School | No | High | 06 | 12 | 2019 | pk_12_total | 3.0 | 9.0 | 1.0 | 12.0 | 1.0 | * | 4 | 13 | 3 | 9 | 1 | 12 | 1 | 4 | 13 | |||||||||||||||||||||||||||||||||||||
3087418 | 3087418 | WI | Waupaca | school | 5515840 | 6195 | Public school | Waupaca | 551584003091 | 180 | Chain Exploration Center | charter | Regular School | Yes | Elementary | KG | 08 | 2019 | pk_12_total | 54.0 | 4.0 | 1.0 | 30.0 | 29.0 | 20 | 3 | 59 | 54 | 4 | 1 | 30 | 29 | 20 | 3 | 59 | |||||||||||||||||||||||||||||||||||
3087517 | 3087517 | WI | Marathon | school | 5515900 | 6223 | Public school | Wausau | 551590002051 | 120 | Hewitt-Texas Elementary | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 119.0 | 1.0 | 11.0 | 62.0 | 69.0 | 40 | 18 | 131 | 119 | 1 | 11 | 62 | 69 | 40 | 18 | 131 | ||||||||||||||||||||||||||||||||||||
3087632 | 3087632 | WI | Marinette | school | 5515930 | 6230 | Public school | Wausaukee | 551593002069 | 120 | Wausaukee Junior High | Regular School | No | Middle | 07 | 08 | 2019 | pk_12_total | 53.0 | 1.0 | 1.0 | 28.0 | 27.0 | 28 | 8 | 55 | 53 | 1 | 1 | 28 | 27 | 28 | 8 | 55 | ||||||||||||||||||||||||||||||||||||
3087800 | 3087800 | WI | Crawford | school | 5516020 | 6251 | Public school | Wauzeka-Steuben | 551602002095 | 40 | Wauzeka High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 95.0 | 1.0 | 1.0 | 2.0 | 62.0 | 37.0 | 54 | 14 | 99 | 95 | 1 | 1 | 2 | 62 | 37 | 54 | 14 | 99 | ||||||||||||||||||||||||||||||||||
3087805 | 3087805 | WI | Crawford | school | 5516020 | 6251 | Public school | Wauzeka-Steuben | 551602002738 | 250 | Wauzeka Middle | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 50.0 | 1.0 | 1.0 | 1.0 | 28.0 | 25.0 | 33 | 7 | 53 | 50 | 1 | 1 | 1 | 28 | 25 | 33 | 7 | 53 | ||||||||||||||||||||||||||||||||||
3088023 | 3088023 | WI | Brown | school | 5516320 | 6328 | Public school | West De Pere | 551632002752 | 400 | Phantom Knight School of Opportunity | charter | Regular School | Yes | High | 07 | 12 | 2019 | pk_12_total | 16.0 | 1.0 | 2.0 | 2.0 | 9.0 | 12.0 | 6 | 5 | 21 | 16 | 1 | 2 | 2 | 9 | 12 | 6 | 5 | 21 | |||||||||||||||||||||||||||||||||
3088138 | 3088138 | WI | Sauk | school | 5516470 | 6354 | Public school | Weston | 551647002155 | 100 | Weston High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 82.0 | 1.0 | 5.0 | 1.0 | 47.0 | 42.0 | 45 | 11 | 89 | 82 | 1 | 5 | 1 | 47 | 42 | 45 | 11 | 89 | ||||||||||||||||||||||||||||||||||
3088143 | 3088143 | WI | Sauk | school | 5516470 | 6354 | Public school | Weston | 551647002156 | 120 | Weston Middle | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 53.0 | 1.0 | 2.0 | 2.0 | 31.0 | 27.0 | 29 | 5 | 58 | 53 | 1 | 2 | 2 | 31 | 27 | 29 | 5 | 58 | ||||||||||||||||||||||||||||||||||
3088396 | 3088396 | WI | Sauk | school | 5517040 | 6678 | Public school | Wisconsin Dells | 551704000551 | 50 | Neenah Creek Elementary | Regular School | No | Elementary | KG | 05 | 2019 | pk_12_total | 77.0 | 1.0 | 1.0 | 4.0 | 11.0 | 55.0 | 39.0 | 54 | 2 | 94 | 77 | 1 | 1 | 4 | 11 | 55 | 39 | 54 | 2 | 94 | ||||||||||||||||||||||||||||||||
3088567 | 3088567 | WI | Juneau | school | 5517130 | 6713 | Public school | Wonewoc-Union Center | 551713002226 | 100 | Wonewoc-Center Junior High | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 75.0 | 1.0 | 1.0 | 4.0 | 39.0 | 42.0 | 40 | 7 | 81 | 75 | 1 | 1 | 4 | 39 | 42 | 40 | 7 | 81 | ||||||||||||||||||||||||||||||||||
3074367 | 3074367 | WI | Outagamie | school | 5500390 | 147 | Public school | Appleton Area | 550039003341 | 460 | Valley New School | charter | Regular School | Yes | High | 07 | 12 | 2019 | pk_12_total | 62.0 | 2.0 | 2.0 | 21.0 | 45.0 | 11 | 3 | 66 | 62 | 2 | 2 | 21 | 45 | 11 | 3 | 66 | |||||||||||||||||||||||||||||||||||
3074423 | 3074423 | WI | Lafayette | school | 5500450 | 161 | Public school | Argyle | 550045000070 | 40 | Argyle High | Regular School | No | High | 09 | 12 | 2019 | pk_12_total | 91.0 | 2.0 | 2.0 | 1.0 | 46.0 | 50.0 | 31 | 7 | 96 | 91 | 2 | 2 | 1 | 46 | 50 | 31 | 7 | 96 | ||||||||||||||||||||||||||||||||||
3074428 | 3074428 | WI | Lafayette | school | 5500450 | 161 | Public school | Argyle | 550045003073 | 250 | Argyle Middle | Regular School | No | Middle | 06 | 08 | 2019 | pk_12_total | 52.0 | 2.0 | 1.0 | 33.0 | 22.0 | 28 | 9 | 55 | 52 | 2 | 1 | 33 | 22 | 28 | 9 | 55 |
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]);