Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by female_int

View and edit SQL

grade

year

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
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
112378 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2015   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
113193 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes 3.0 09 12 2015   pk_12_total 4.0                       3.0 1.0             *     *   4 4                       3 1                 4
114104 WI Walworth   school   1380 Public Schools-Multidistrict Charters Delavan-Darien   9401 Walworth Co Educ Alt High charter           2015   pk_12_total 6.0   1.0     1.0             7.0 1.0             *     1   8 6   1     1             7 1             1   8
114761 WI Rusk   school 5514970 5757 Public school Flambeau 551497002684 410 Whitetail Academy charter Regular School Yes 3.0 09 12 2015   pk_12_total 5.0                       4.0 1.0             *     *   5 5                       4 1                 5
117035 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002554 405 Kiel eSchool charter Regular School Yes 3.0 07 12 2015   pk_12_total 5.0                       4.0 1.0             *     *   5 5                       4 1                 5
121406 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095002736 410 New Path charter Alternative Education School Yes 4.0 06 12 2015   pk_12_total 9.0                   1.0   9.0 1.0             *     *   10 9                   1   9 1                 10
122923 WI Pierce   school 5513050 4893 Public school River Falls 551305002999 430 River Falls eSchool charter Regular School Yes 4.0 06 12 2015   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
124045 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No 1.0 PK PK 2015   pk_12_total 1.0     1.0                 1.0 1.0             *     *   2 1     1                 1 1                 2
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
284019 WI Vernon   school 5503240 1421 Public school De Soto Area 550324003022 810 De Soto Virtual School charter Regular School Yes 4.0 PK 12 2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
284364 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002658 800 Second Avenue School   Alternative Education School No 4.0 04 12 2016   pk_12_total 4.0 3.0                 1.0   7.0 1.0             *     *   8 4 3                 1   7 1                 8
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
287377 WI Jefferson   school   2898 Public Schools-Multidistrict Charters Lake Mills Area   9803 JEDI Virtual K-12 charter           2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
287989 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2016   pk_12_total 3.0 1.0                 1.0   4.0 1.0             *     *   5 3 1                 1   4 1                 5
290005 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002555 825 St Charles Behav Reassign Success Acad   Alternative Education School No 4.0 06 12 2016   pk_12_total   5.0 1.0                   5.0 1.0             *     *   6   5 1                   5 1                 6
290622 WI Juneau   school   3871 Public Schools-Multidistrict Charters Necedah Area   9405 Juneau County Charter School charter           2016   pk_12_total 5.0   1.0                   5.0 1.0             *     *   6 5   1                   5 1                 6
293929 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001125 320 Juvenile Detention   Alternative Education School No 4.0 KG 12 2016   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
294497 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes 4.0 PK 12 2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
296243 WI Juneau   school   6713 Public Schools-Multidistrict Charters Wonewoc-Union Center   9405 Juneau County Charter School charter           2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
325625 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2017   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
325861 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2017   pk_12_total 1.0   1.0 1.0                 2.0 1.0             *     *   3 1   1 1                 2 1                 3
330352 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2017   pk_12_total 3.0 6.0                 1.0   9.0 1.0             *     *   10 3 6                 1   9 1                 10
330920 WI Vernon   school   5960 Public Schools-Multidistrict Charters Kickapoo Area   9407 Vernon County Area Better Futures High charter           2017   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
331601 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002909 220 Innovative & Alternative Middle   Alternative School No Middle 06 08 2017   pk_12_total   1.0                       1.0             *     *   1   1                       1                 1
334748 WI Juneau   school 5510560 3948 Public school New Lisbon 551056002517 9405 Juneau County Charter School charter Regular School Yes High 07 12 2017   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
338549 WI Dane   school 5515330 5901 Public school Verona Area 551533002285 110 Early Childhood   Regular School No Elementary PK PK 2017   pk_12_total 10.0   3.0               1.0   13.0 1.0                   *   14 10   3               1   13 1                 14
339619 WI Washington   school 5516290 6307 Public school West Bend 551629002666 400 Washington Street School   Alternative School No Other 06 12 2017   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
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
3090215 WI Barron   school 5502130 903 Public school Cameron 550213002500 9410 North Star Academy charter Alternative School Yes High 09 12 2018   pk_12_total 11.0 3.0                     13.0 1.0             8     2   14 11 3                     13 1         8   2   14
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
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 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
3093987 WI Vernon   school   5960 Public Schools-Multidistrict Charters Kickapoo Area   9407 Vernon County Area Better Futures High charter           2018   pk_12_total   1.0                       1.0             *     *   1   1                       1                 1
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
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
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
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
3102007 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003070 800 Riverview School   Alternative School No High 06 12 2018   pk_12_total   3.0                     2.0 1.0             *     *   3   3                     2 1                 3
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 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
3103032 WI Walworth   school   6482 Public Schools-Multidistrict Charters Williams Bay   9401 Walworth Co Educ Alt High charter           2018   pk_12_total 7.0                       6.0 1.0             1         7 7                       6 1         1       7
3076314 WI Walworth   school   1380 Public Schools-Multidistrict Charters Delavan-Darien   9401 Walworth Co Educ Alt High charter           2019   pk_12_total     2.0                   1.0 1.0             *     *   2     2                   1 1                 2
3077186 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483002685 400 Milwaukee County Correctional Facility South   Alternative School No High 09 12 2019   pk_12_total 2.0 32.0 8.0 2.0             1.0   44.0 1.0             4     32   45 2 32 8 2             1   44 1         4   32   45
3078991 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001714 405 Phoenix Project   Alternative School No High 09 12 2019   pk_12_total 3.0 11.0 3.0               1.0   17.0 1.0             3     7   18 3 11 3               1   17 1         3   7   18
3086157 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001125 320 Juvenile Detention   Alternative School No Other KG 12 2019   pk_12_total 3.0     1.0             1.0   4.0 1.0             *     *   5 3     1             1   4 1                 5
3086766 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes Other PK 12 2019   pk_12_total 3.0                       2.0 1.0             *     *   3 3                       2 1                 3
3086770 WI Barron   school   5810 Public Schools-Multidistrict Charters Turtle Lake   9410 North Star Academy charter           2019   pk_12_total 5.0                       4.0 1.0             *     *   5 5                       4 1                 5
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
3088003 WI Washington   school 5516290 6307 Public school West Bend 551629002666 400 Washington Street School   Alternative School No High 06 12 2019   pk_12_total 2.0   2.0                   3.0 1.0             *     *   4 2   2                   3 1                 4
3088184 WI Langlade   school   6440 Public Schools-Multidistrict Charters White Lake   9100 Rural Virtual Academy charter           2019   pk_12_total 3.0                       2.0 1.0             *     *   3 3                       2 1                 3
2318148 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2020   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
2319612 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2020   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
2320819 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002658 800 Second Avenue School   Alternative School No Other 04 12 2020   pk_12_total 10.0 1.0                     10.0 1.0             2     2   11 10 1                     10 1         2   2   11
2321623 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes High 09 12 2020   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
2323821 WI Walworth   school 5507650 2884 Public school Lake Geneva-Genoa City UHS 550765003109 410 New Visions Charter School charter Regular School Yes High 09 12 2020   pk_12_total     1.0                     1.0             *     *   1     1                     1                 1
2323826 WI Chippewa   school   2891 Public Schools-Multidistrict Charters Lake Holcombe   9419 eSucceed Charter School charter           2020   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
2324304 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative School No Other 04 12 2020   pk_12_total 2.0 10.0                 1.0   12.0 1.0             7     7   13 2 10                 1   12 1         7   7   13
2327880 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095002736 410 New Path charter Alternative School Yes High 06 12 2020   pk_12_total 5.0   1.0                   5.0 1.0             *     *   6 5   1                   5 1                 6
2330393 WI Chippewa   school   5593 Public Schools-Multidistrict Charters Stanley-Boyd Area   9419 eSucceed Charter School charter           2020   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
2331070 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes Other PK 12 2020   pk_12_total 2.0   1.0                   2.0 1.0             *     *   3 2   1                   2 1                 3
2331073 WI Barron   school   5810 Public Schools-Multidistrict Charters Turtle Lake   9410 North Star Academy charter           2020   pk_12_total 3.0                       2.0 1.0             *     *   3 3                       2 1                 3
2331608 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003070 800 Riverview School   Alternative School No High 06 12 2020   pk_12_total   4.0                     3.0 1.0             *     *   4   4                     3 1                 4
2332466 WI Langlade   school   6440 Public Schools-Multidistrict Charters White Lake   9100 Rural Virtual Academy charter           2020   pk_12_total 3.0                       2.0 1.0             *     *   3 3                       2 1                 3
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
2334169 WI Shawano   school   623 Public Schools-Multidistrict Charters Bowler   9100 Rural Virtual Academy charter           2021   pk_12_total 3.0     6.0                 8.0 1.0             *     2   9 3     6                 8 1             2   9
2334644 WI Price   school   1071 Public Schools-Multidistrict Charters Chequamegon   9100 Rural Virtual Academy charter           2021   pk_12_total 4.0                       3.0 1.0             *     *   4 4                       3 1                 4
2337545 WI Dodge   school   2625 Public Schools-Multidistrict Charters Hustisford   405 Kiel eSchool charter           2021   pk_12_total 4.0                       3.0 1.0             *     *   4 4                       3 1                 4
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
2341380 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003057 442 South Accelerated Academy   Alternative School No High 09 12 2021   pk_12_total   2.0 2.0                   3.0 1.0     1.0       *     *   4   2 2                   3 1     1           4
2342137 WI Chippewa   school   3920 Public Schools-Multidistrict Charters New Auburn   9419 eSucceed Charter School charter           2021   pk_12_total 3.0                       2.0 1.0             *     *   3 3                       2 1                 3
2343947 WI Dodge   school   4634 Public Schools-Multidistrict Charters Randolph   800 Between the Lakes Virtual Academy charter           2021   pk_12_total 2.0                       1.0 1.0             *     *   2 2                       1 1                 2
2346994 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002349 190 Vel R Phillips School   Alternative School No Other KG 12 2021   pk_12_total 3.0 42.0 4.0                   48.0 1.0     1.0       17     11   49 3 42 4                   48 1     1   17   11   49
2347257 WI Washington   school 5516290 6307 Public school West Bend 551629002666 400 Washington Street School   Alternative School No High 06 12 2021   pk_12_total 4.0 1.0                     4.0 1.0             *     *   5 4 1                     4 1                 5
2347606 WI Walworth   school   6482 Public Schools-Multidistrict Charters Williams Bay   9401 Career and College Academy charter           2021   pk_12_total 3.0                       2.0 1.0             *     *   3 3                       2 1                 3
116482 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2015   pk_12_total 3.0                       1.0 2.0             *     *   3 3                       1 2                 3
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
117016 WI Kewaunee   school 5507410 2814 Public school Kewaunee 550741002768 490 Lakeshore Alternative School   Regular School No 3.0 10 12 2015   pk_12_total 4.0   1.0                   3.0 2.0             *     *   5 4   1                   3 2                 5
118154 WI Dane   school 5508790 3332 Public school Marshall 550879001791 400 Marshall Charter charter Regular School Yes 3.0 10 12 2015   pk_12_total 5.0   2.0                   5.0 2.0             *     1   7 5   2                   5 2             1   7
119936 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002686 865 Project Excel   Alternative Education School No 4.0 06 12 2015   pk_12_total   8.0 1.0                   7.0 2.0             *     *   9   8 1                   7 2                 9
122236 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2015   pk_12_total 3.0                       1.0 2.0             *     *   3 3                       1 2                 3
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
125752 WI Washington   school 5516290 6307 Public school West Bend 551629002666 400 Washington Street School   Alternative Education School No 4.0 06 12 2015   pk_12_total 4.0 3.0                     5.0 2.0             *     1   7 4 3                     5 2             1   7
282516 WI Barron   school   308 Public Schools-Multidistrict Charters Barron Area   9410 North Star Academy charter           2016   pk_12_total 11.0   1.0                   10.0 2.0             *         12 11   1                   10 2                 12
282824 WI Walworth   school   6013 Public Schools-Multidistrict Charters Big Foot UHS   9401 Walworth Co Educ Alt High charter           2016   pk_12_total 8.0   2.0                   8.0 2.0             *         10 8   2                   8 2                 10
283642 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2016   pk_12_total 4.0                       2.0 2.0             *     *   4 4                       2 2                 4
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
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
286796 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001714 405 Phoenix Project   Alternative Education School No 3.0 09 12 2016   pk_12_total 6.0 14.0 3.0                   21.0 2.0             6     9   23 6 14 3                   21 2         6   9   23
288249 WI Juneau   school 5508850 3360 Public school Mauston 550885003030 110 Mauston Montessori Charter School charter Regular School Yes 1.0 PK 02 2016   pk_12_total 6.0                       4.0 2.0             *     *   6 6                       4 2                 6
291371 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095002736 410 New Path charter Alternative Education School Yes 4.0 06 12 2016   pk_12_total 12.0                   2.0   12.0 2.0             *     7   14 12                   2   12 2             7   14
294705 WI Vernon   school 5515360 5985 Public school Viroqua Area 551536002513 9407 Vernon County Area Better Futures High charter Regular School Yes 3.0 10 12 2016   pk_12_total 3.0                       1.0 2.0             *     *   3 3                       1 2                 3
295760 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9407 Vernon County Area Better Futures High charter           2016   pk_12_total 2.0                         2.0             *     *   2 2                         2                 2
327158 WI Barron   school 5502130 903 Public school Cameron 550213002500 9410 North Star Academy charter Alternative School Yes High 09 12 2017   pk_12_total 8.0 3.0 1.0                   10.0 2.0             *         12 8 3 1                   10 2                 12
327548 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2017   pk_12_total 2.0                         2.0             *     *   2 2                         2                 2
327939 WI Vernon   school 5503240 1421 Public school De Soto Area 550324003022 810 De Soto Virtual School charter Regular School Yes Other KG 12 2017   pk_12_total 6.0                       4.0 2.0             *         6 6                       4 2                 6
328860 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483002685 400 Milwaukee County Correctional Facility South   Alternative School No High 09 12 2017   pk_12_total   41.0 10.0 1.0             1.0   51.0 2.0             9     23   53   41 10 1             1   51 2         9   23   53
331682 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative School No Other 04 12 2017   pk_12_total 2.0 8.0 1.0 1.0                 10.0 2.0             3     5   12 2 8 1 1                 10 2         3   5   12
339686 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9407 Vernon County Area Better Futures High charter           2017   pk_12_total 3.0                       1.0 2.0             *     *   3 3                       1 2                 3
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

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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]);