Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by disability_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
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
335799 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2017   pk_12_total 5.0                       2.0 3.0             *     *   5 5                       2 3                 5
337831 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001125 320 Juvenile Detention   Alternative School No Other KG 12 2017   pk_12_total 3.0                       3.0               *     *   3 3                       3                   3
337885 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No Elementary PK PK 2017   pk_12_total 23.0   4.0     2.0             17.0 12.0             14     *   29 23   4     2             17 12         14       29
337975 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2017   pk_12_total 5.0                       1.0 4.0             *     *   5 5                       1 4                 5
338395 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes Other PK 12 2017   pk_12_total 7.0                       3.0 4.0             *     *   7 7                       3 4                 7
338402 WI Barron   school   5810 Public Schools-Multidistrict Charters Turtle Lake   9410 North Star Academy charter           2017   pk_12_total 3.0   1.0               1.0   2.0 3.0             *     *   5 3   1               1   2 3                 5
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
338607 WI Vernon   school 5515360 5985 Public school Viroqua Area 551536002513 9407 Vernon County Area Better Futures High charter Regular School Yes High 10 12 2017   pk_12_total 7.0                       1.0 6.0             *     *   7 7                       1 6                 7
338978 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002960 415 Waukesha Transition Academy   Special Education School No High 12 12 2017   pk_12_total 30.0 1.0 3.0     3.0             24.0 13.0             10     *   37 30 1 3     3             24 13         10       37
339037 WI Waupaca   school   6195 Public Schools-Multidistrict Charters Waupaca   9408 Waupaca County Charter charter           2017   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
339610 WI Washington   school 5516290 6307 Public school West Bend 551629002912 110 Rolf's Early Childhood Center   Special Education School No Elementary PK PK 2017   pk_12_total 32.0 1.0 6.0               3.0   31.0 11.0             1     *   42 32 1 6               3   31 11         1       42
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
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
339769 WI Waupaca   school 5516500 6384 Public school Weyauwega-Fremont 551650002523 9408 Waupaca County Charter charter Regular School Yes Other 06 12 2017   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
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
2318357 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2020   pk_12_total 4.0 1.0   1.0                 4.0 2.0             *     *   6 4 1   1                 4 2                 6
2318379 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2020   pk_12_total 18.0 2.0 2.0 1.0   1.0         1.0   18.0 7.0             9     *   25 18 2 2 1   1         1   18 7         9       25
2319159 WI Rock   school   422 Public Schools-Multidistrict Charters Beloit Turner   9803 JEDI Virtual K-12 charter           2020   pk_12_total 2.0   1.0                   1.0 2.0             *     *   3 2   1                   1 2                 3
2319222 WI Walworth   school   6013 Public Schools-Multidistrict Charters Big Foot UHS   9401 Walworth Co Educ Alt High charter           2020   pk_12_total 1.0   1.0                   2.0               *     *   2 1   1                   2                   2
2319591 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2020   pk_12_total 1.0   1.0                   2.0               *     *   2 1   1                   2                   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
2319687 WI Barron   school 5502130 903 Public school Cameron 550213002500 9410 North Star Academy charter Alternative School Yes High 09 12 2020   pk_12_total 7.0     1.0                 6.0 2.0             *     *   8 7     1                 6 2                 8
2319784 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total 20.0                       15.0 5.0             2     *   20 20                       15 5         2       20
2320895 WI Langlade   school   1582 Public Schools-Multidistrict Charters Elcho   9100 Rural Virtual Academy charter           2020   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
2321055 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000221 160 Fairview South   Special Education School No High 05 12 2020   pk_12_total 14.0                       7.0 7.0             3     *   14 14                       7 7         3       14
2321127 WI Rock   school   1694 Public Schools-Multidistrict Charters Evansville Community   9803 JEDI Virtual K-12 charter           2020   pk_12_total 3.0                       1.0 2.0             *     *   3 3                       1 2                 3
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
2322923 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2020   pk_12_total 6.0 3.0 1.0                   8.0 2.0             *     *   10 6 3 1                   8 2                 10
2322937 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2020   pk_12_total 4.0                       4.0               *     *   4 4                       4                   4
2323194 WI Kenosha   school 5507320 2793 Public school Kenosha 550732003051 810 Kenosha Pike School   Special Education School No Other PK 12 2020   pk_12_total 23.0 1.0 6.0     1.0         4.0   25.0 10.0             3     *   35 23 1 6     1         4   25 10         3       35
2323735 WI Vernon   school   2863 Public Schools-Multidistrict Charters La Farge   9407 Vernon County Area Better Futures High charter           2020   pk_12_total 2.0                       2.0               *     *   2 2                       2                   2
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
2323880 WI Oneida   school 5509630 3647 Public school Lakeland UHS 550963003090 400 Lakeland STAR Academy--Strong Talented Adventurous Remarkable charter Regular School Yes High 09 12 2020   pk_12_total 17.0     9.0           1.0     15.0 12.0             *     *   27 17     9           1     15 12                 27
2324728 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2020   pk_12_total 3.0                   1.0     4.0             *     *   4 3                   1     4                 4
2325171 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2020   pk_12_total 3.0   1.0                   2.0 2.0             *     *   4 3   1                   2 2                 4
2326759 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969003083 9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter Regular School Yes Middle 07 08 2020   pk_12_total   1.0 1.0 1.0                 1.0 2.0             *     *   3   1 1 1                 1 2                 3
2326860 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2020   pk_12_total 6.0                       1.0 5.0             *     *   6 6                       1 5                 6
2327269 WI Chippewa   school   3920 Public Schools-Multidistrict Charters New Auburn   9419 eSucceed Charter School charter           2020   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
2327436 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062003079 180 New Richmond Early Childhood Special Education   Special Education School No Prekindergarten PK PK 2020   pk_12_total 16.0                       11.0 5.0             4     *   16 16                       11 5         4       16
2327499 WI Waukesha   school 5510710 3976 Public school Norris 551071003072 800 Norris Academy Virtual School charter Alternative School Yes Other KG 12 2020   pk_12_total 4.0 5.0 1.0                   10.0               *     *   10 4 5 1                   10                   10
2327877 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001853 400 Falls Alternative Learning Site (FALS) charter Regular School Yes High 09 12 2020   pk_12_total 5.0                       5.0               *     *   5 5                       5                   5
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
2328223 WI Clark   school   4207 Public Schools-Multidistrict Charters Owen-Withee   9100 Rural Virtual Academy charter           2020   pk_12_total 3.0                       1.0 2.0             *     *   3 3                       1 2                 3
2330030 WI Milwaukee   school 5513800 5355 Public school Shorewood 551380002623 400 New Horizons for Learning charter Alternative School Yes High 09 12 2020   pk_12_total 5.0 5.0 2.0 1.0                 10.0 3.0             6     *   13 5 5 2 1                 10 3         6       13
2330133 WI Douglas   school 5513980 5397 Public school Solon Springs 551398003092 850 Eagles' Wings Virtual Charter School charter Regular School Yes Other PK 12 2020   pk_12_total 7.0                       2.0 5.0             *     *   7 7                       2 5                 7
2330230 WI Door   school   5457 Public Schools-Multidistrict Charters Southern Door County   9100 Rural Virtual Academy charter           2020   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
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
2330446 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001125 320 Juvenile Detention   Alternative School No Other KG 12 2020   pk_12_total 3.0 2.0 1.0               1.0   7.0               *     *   7 3 2 1               1   7                   7
2330501 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No Prekindergarten PK PK 2020   pk_12_total 26.0   1.0     3.0         2.0   26.0 6.0             14     *   32 26   1     3         2   26 6         14       32
2330594 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2020   pk_12_total 7.0                       3.0 4.0             1     *   7 7                       3 4         1       7
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
2331223 WI Dane   school 5515330 5901 Public school Verona Area 551533002285 110 Early Childhood   Regular School No Prekindergarten PK PK 2020   pk_12_total 4.0 1.0 8.0     1.0         2.0   10.0 6.0                   *   16 4 1 8     1         2   10 6                 16
2331420 WI Jefferson   school   6118 Public Schools-Multidistrict Charters Waterloo   9803 JEDI Virtual K-12 charter           2020   pk_12_total 2.0                   1.0   3.0               *     *   3 2                   1   3                   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
2331659 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002960 415 Waukesha Transition Academy   Special Education School No High 12 12 2020   pk_12_total 24.0   4.0     1.0             19.0 10.0             7     *   29 24   4     1             19 10         7       29
2331903 WI Marathon   school 5515900 6223 Public school Wausau 551590003027 800 Wausau Area Virtual Education charter Regular School Yes High 06 12 2020   pk_12_total 3.0   1.0                     4.0             *     *   4 3   1                     4                 4
2332217 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002918 410 Shared Journeys charter Alternative School Yes High 07 12 2020   pk_12_total 3.0   2.0                     5.0             *     *   5 3   2                     5                 5
2332280 WI Washington   school 5516290 6307 Public school West Bend 551629002912 110 Rolf's Early Childhood Center   Special Education School No Prekindergarten PK PK 2020   pk_12_total 28.0   2.0               2.0   21.0 11.0             1     *   32 28   2               2   21 11         1       32
2332286 WI Washington   school 5516290 6307 Public school West Bend 551629002666 400 Washington Street School   Alternative School No High 06 12 2020   pk_12_total 3.0 3.0                     4.0 2.0             *     *   6 3 3                     4 2                 6
2332354 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9407 Vernon County Area Better Futures High charter           2020   pk_12_total 5.0                       3.0 2.0             *     *   5 5                       3 2                 5
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
2333152 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2021   pk_12_total     1.0                   1.0               *     *   1     1                   1                   1
2333173 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2021   pk_12_total 24.0 1.0 3.0     1.0         1.0   21.0 9.0             3     *   30 24 1 3     1         1   21 9         3       30
2333938 WI Rock   school   422 Public Schools-Multidistrict Charters Beloit Turner   9803 JEDI Virtual K-12 charter           2021   pk_12_total 2.0                         2.0             *     *   2 2                         2                 2
2334000 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2021   pk_12_total 4.0 1.0                     3.0 2.0             *     *   5 4 1                     3 2                 5
2334480 WI Barron   school 5502130 903 Public school Cameron 550213002500 9410 North Star Academy charter Alternative School Yes High 09 12 2021   pk_12_total 4.0   1.0 1.0                 4.0 2.0             *     *   6 4   1 1                 4 2                 6
2334566 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2021   pk_12_total 10.0 1.0 1.0                   8.0 4.0                   *   12 10 1 1                   8 4                 12
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
2335875 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000221 160 Fairview South   Special Education School No High 05 12 2021   pk_12_total 10.0                       7.0 3.0             1     *   10 10                       7 3         1       10
2337468 WI Saint Croix   school 5506690 2611 Public school Hudson 550669003129 400 Hudson Virtual Charter School charter Regular School Yes High 09 12 2021   pk_12_total 2.0                         2.0             *     *   2 2                         2                 2
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
2337851 WI Green   school   2737 Public Schools-Multidistrict Charters Juda   800 Between the Lakes Virtual Academy charter           2021   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
2337870 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
2338068 WI Kenosha   school 5507320 2793 Public school Kenosha 550732003051 810 Kenosha Pike School   Special Education School No Other PK 12 2021   pk_12_total 14.0 2.0 3.0               2.0   13.0 8.0             2     *   21 14 2 3               2   13 8         2       21
2338116 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001714 405 Phoenix Project   Alternative School No High 09 12 2021   pk_12_total 1.0 7.0 1.0                   9.0       1.0       1     *   9 1 7 1                   9       1   1       9
2338461 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High charter Regular School Yes High 12 12 2021   pk_12_total 5.0                       2.0 3.0             *     *   5 5                       2 3                 5
2338615 WI Vernon   school   2863 Public Schools-Multidistrict Charters La Farge   9407 Vernon County Area Better Futures High charter           2021   pk_12_total 2.0                       2.0               *     *   2 2                       2                   2
2338701 WI Walworth   school 5507650 2884 Public school Lake Geneva-Genoa City UHS 550765003109 410 New Visions Charter School charter Regular School Yes High 09 12 2021   pk_12_total 2.0                         2.0             *     *   2 2                         2                 2
2338948 WI Kewaunee   school   3220 Public Schools-Multidistrict Charters Luxemburg-Casco   9803 JEDI Virtual K-12 charter           2021   pk_12_total 5.0                       2.0 3.0             *     *   5 5                       2 3                 5
2339616 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2021   pk_12_total 3.0                         3.0             *     *   3 3                         3                 3
2341116 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001306 315 Milwaukee County Youth Education Center   Alternative School No High 06 12 2021   pk_12_total   4.0 1.0                   5.0               *     *   5   4 1                   5                   5
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
2341628 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969003083 9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter Regular School Yes Middle 07 08 2021   pk_12_total   1.0                     1.0               *     *   1   1                     1                   1
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
2342310 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062003079 180 New Richmond Early Childhood Special Education   Special Education School No Prekindergarten PK PK 2021   pk_12_total 16.0   1.0                   14.0 3.0             5     *   17 16   1                   14 3         5       17
2342685 WI Fond du Lac   school   4025 Public Schools-Multidistrict Charters Oakfield   800 Between the Lakes Virtual Academy charter           2021   pk_12_total 5.0 1.0 1.0                   3.0 4.0             1     *   7 5 1 1                   3 4         1       7
2343118 WI Clark   school   4207 Public Schools-Multidistrict Charters Owen-Withee   9100 Rural Virtual Academy charter           2021   pk_12_total 5.0                       3.0 2.0             *     *   5 5                       3 2                 5
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
2345338 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001125 320 Juvenile Detention   Alternative School No Other KG 12 2021   pk_12_total 4.0 2.0   3.0                 7.0 2.0             *     *   9 4 2   3                 7 2                 9
2345396 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001145 350 Preschool Options   Special Education School No Prekindergarten PK PK 2021   pk_12_total 18.0 1.0 6.0     2.0             21.0 6.0             11     *   27 18 1 6     2             21 6         11       27
2346000 WI Barron   school   5810 Public Schools-Multidistrict Charters Turtle Lake   9410 North Star Academy charter           2021   pk_12_total 1.0     1.0                   2.0             *     *   2 1     1                   2                 2
2346150 WI Dane   school 5515330 5901 Public school Verona Area 551533002285 110 Early Childhood   Regular School No Prekindergarten PK PK 2021   pk_12_total 8.0 4.0 6.0                   12.0 6.0                   *   18 8 4 6                   12 6                 18
2346152 WI Dane   school 5515330 5901 Public school Verona Area 551533002919 410 Exploration Academy charter Regular School Yes High 09 12 2021   pk_12_total 3.0   2.0               1.0   4.0 2.0             *     *   6 3   2               1   4 2                 6
2346564 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003070 800 Riverview School   Alternative School No High 06 12 2021   pk_12_total 1.0   1.0               1.0   3.0       1.0       *     *   3 1   1               1   3       1           3
2346615 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002960 415 Waukesha Transition Academy   Special Education School No High 12 12 2021   pk_12_total 22.0 2.0 6.0     1.0         2.0   23.0 10.0     2.0       8     *   33 22 2 6     1         2   23 10     2   8       33
2347188 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002918 410 Shared Journeys charter Alternative School Yes High 07 12 2021   pk_12_total 1.0   1.0                     2.0             *     *   2 1   1                     2                 2

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