Data source: Big Local News · About: Big Local

2,269 rows where grade = "pk_12_total", state = "WI" and year = 2020 sorted by ccd_school_type

View and edit SQL

year

  • 2020 · 2,269

grade

  • pk_12_total · 2,269
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
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
2318326 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2020   pk_12_total 62.0   3.0               3.0   23.0 45.0             39     9   68 62   3               3   23 45         39   9   68
2318685 WI Ashland   school   170 Public Schools-Multidistrict Charters Ashland   9100 Rural Virtual Academy             2020   pk_12_total 6.0     4.0             2.0   4.0 8.0             *     1   12 6     4             2   4 8             1   12
2318755 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2020   pk_12_total 14.0         2.0             7.0 9.0             6         16 14         2             7 9         6       16
2318913 WI Barron   school   308 Public Schools-Multidistrict Charters Barron Area   9410 North Star Academy charter           2020   pk_12_total 10.0                       4.0 6.0             *     2   10 10                       4 6             2   10
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
2319386 WI Shawano   school   623 Public Schools-Multidistrict Charters Bowler   9100 Rural Virtual Academy charter           2020   pk_12_total 3.0     12.0             3.0   11.0 7.0             10     4   18 3     12             3   11 7         10   4   18
2319506 WI Rusk   school   735 Public Schools-Multidistrict Charters Bruce   9419 eSucceed Charter School charter           2020   pk_12_total                                                   0                                             0
2319537 WI Racine   school   777 Public Schools-Multidistrict Charters Burlington Area   9803 JEDI Virtual K-12 charter           2020   pk_12_total 10.0 1.0 5.0               1.0   6.0 11.0             9     2   17 10 1 5               1   6 11         9   2   17
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
2319861 WI Price   school   1071 Public Schools-Multidistrict Charters Chequamegon   9100 Rural Virtual Academy charter           2020   pk_12_total                                                   0                                             0
2319895 WI Barron   school   1080 Public Schools-Multidistrict Charters Chetek-Weyerhaeuser Area   9410 North Star Academy charter           2020   pk_12_total 9.0                   1.0   5.0 5.0             *     3   10 9                   1   5 5             3   10
2320078 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2020   pk_12_total 9.0 2.0 3.0 1.0                 6.0 9.0             8     3   15 9 2 3 1                 6 9         8   3   15
2320163 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2020   pk_12_total                                                   0                                             0
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
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
2321363 WI Jefferson   school   1883 Public Schools-Multidistrict Charters Fort Atkinson   9803 JEDI Virtual K-12 charter           2020   pk_12_total                                                   0                                             0
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
2323488 WI Vernon   school   5960 Public Schools-Multidistrict Charters Kickapoo Area   9407 Vernon County Area Better Futures High charter           2020   pk_12_total                                                   0                                             0
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
2323749 WI Vilas   school   1848 Public Schools-Multidistrict Charters Lac du Flambeau #1   9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter           2020   pk_12_total                                                   0                                             0
2323823 WI Walworth   school   2884 Public Schools-Multidistrict Charters Lake Geneva-Genoa City UHS   9401 Walworth Co Educ Alt High charter           2020   pk_12_total 20.0   3.0     1.0             9.0 15.0                   1   24 20   3     1             9 15             1   24
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
2324080 WI Kewaunee   school   3220 Public Schools-Multidistrict Charters Luxemburg-Casco   9803 JEDI Virtual K-12 charter           2020   pk_12_total 6.0   1.0                   2.0 5.0             1         7 6   1                   2 5         1       7
2324631 WI Dane   school   3332 Public Schools-Multidistrict Charters Marshall   9803 JEDI Virtual K-12 charter           2020   pk_12_total                                                   0                                             0
2324694 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2020   pk_12_total 47.0 1.0                 3.0   26.0 25.0             19     13   51 47 1                 3   26 25         19   13   51
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
2325257 WI Rock   school   3612 Public Schools-Multidistrict Charters Milton   9803 JEDI Virtual K-12 charter           2020   pk_12_total 8.0   1.0                   2.0 7.0             *         9 8   1                   2 7                 9
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
2326958 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2020   pk_12_total 34.0   1.0             1.0 2.0   22.0 16.0             6     8   38 34   1             1 2   22 16         6   8   38
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
2327575 WI Vilas   school   616 Public Schools-Multidistrict Charters North Lakeland   9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter           2020   pk_12_total                                                   0                                             0
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
2328417 WI Price   school   4347 Public Schools-Multidistrict Charters Phillips   9100 Rural Virtual Academy             2020   pk_12_total 13.0                 1.0     10.0 4.0             8     1   14 13                 1     10 4         8   1   14
2328444 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2020   pk_12_total 15.0                       6.0 9.0             4     1   15 15                       6 9         4   1   15
2328722 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2020   pk_12_total 21.0                       10.0 11.0             5     1   21 21                       10 11         5   1   21
2329216 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2020   pk_12_total 23.0 1.0                     12.0 12.0             5         24 23 1                     12 12         5       24
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
2330328 WI Marathon   school   5467 Public Schools-Multidistrict Charters Spencer   9100 Rural Virtual Academy charter           2020   pk_12_total 8.0                       6.0 2.0             *     2   8 8                       6 2             2   8
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
2330558 WI Dane   school   5621 Public Schools-Multidistrict Charters Stoughton Area   9803 JEDI Virtual K-12 charter           2020   pk_12_total 24.0 1.0 1.0               1.0   10.0 17.0             12     2   27 24 1 1               1   10 17         12   2   27
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
2330674 WI Dane   school   5656 Public Schools-Multidistrict Charters Sun Prairie Area   9803 JEDI Virtual K-12 charter           2020   pk_12_total 24.0 4.0 1.0     1.0             15.0 15.0             9     3   30 24 4 1     1             15 15         9   3   30
2330832 WI Clark   school   5726 Public Schools-Multidistrict Charters Thorp   9100 Rural Virtual Academy charter           2020   pk_12_total 9.0                       4.0 5.0             *         9 9                       4 5                 9
2330939 WI Monroe   school   5747 Public Schools-Multidistrict Charters Tomah Area   9100 Rural Virtual Academy charter           2020   pk_12_total 52.0   1.0                   29.0 24.0             25         53 52   1                   29 24         25       53
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
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
2332353 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9100 Rural Virtual Academy charter           2020   pk_12_total                                                   0                                             0
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
2332531 WI Walworth   school   6461 Public Schools-Multidistrict Charters Whitewater Unified   9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter           2020   pk_12_total 8.0                   1.0   3.0 6.0             *         9 8                   1   3 6                 9
2332618 WI Walworth   school   6482 Public Schools-Multidistrict Charters Williams Bay   9401 Walworth Co Educ Alt High charter           2020   pk_12_total                                                   0                                             0
2332896 WI Vilas   school   6720 Public Schools-Multidistrict Charters Woodruff J1   9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter           2020   pk_12_total                                                   0                                             0
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
2318972 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096002815 850 Don Smith Learning Academy   Alternative School No High 09 12 2020   pk_12_total 43.0 1.0 13.0 1.0             3.0   34.0 27.0             41     8   61 43 1 13 1             3   34 27         41   8   61
2319080 WI Rock   school 5501050 413 Public school Beloit 550105002974 421 Beloit Learning Academy   Alternative School No High 06 12 2020   pk_12_total 74.0 64.0 38.0               15.0   120.0 71.0             151     51   191 74 64 38               15   120 71         151   51   191
2319554 WI Racine   school 5501890 777 Public school Burlington Area 550189003120 400 Southern Lakes Alternative High   Alternative School No High 10 12 2020   pk_12_total 19.0 1.0 2.0               2.0   13.0 11.0             13     8   24 19 1 2               2   13 11         13   8   24
2319654 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2020   pk_12_total 76.0 1.0 3.0     1.0         6.0   30.0 57.0             46     1   87 76 1 3     1         6   30 57         46   1   87
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
2320759 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000705 580 McKinley Charter School charter Alternative School Yes High 06 12 2020   pk_12_total 131.0 6.0 11.0 2.0   2.0         25.0   104.0 73.0             115     26   177 131 6 11 2   2         25   104 73         115   26   177
2320794 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002675 430 Oxford Avenue School   Alternative School No High 10 12 2020   pk_12_total                                                   0                                             0
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
2321426 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483002685 400 Milwaukee County Correctional Facility South   Alternative School No High 09 12 2020   pk_12_total 2.0 28.0 3.0 1.0                 34.0                     18   34 2 28 3 1                 34               18   34
2321797 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2020   pk_12_total 22.0 4.0 10.0 7.0   1.0         1.0   35.0 10.0             26     25   45 22 4 10 7   1         1   35 10         26   25   45
2321842 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other KG 12 2020   pk_12_total 19.0 22.0 26.0 5.0   1.0         9.0   66.0 16.0             75     49   82 19 22 26 5   1         9   66 16         75   49   82
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
2323156 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002317 280 Hillcrest School   Alternative School No High 06 12 2020   pk_12_total 5.0 36.0 9.0               3.0   31.0 22.0             46     24   53 5 36 9               3   31 22         46   24   53
2323242 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001714 405 Phoenix Project   Alternative School No High 09 12 2020   pk_12_total 4.0 15.0 2.0                   21.0               8     9   21 4 15 2                   21           8   9   21
2323263 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000822 450 Reuther Central High   Alternative School No High 09 12 2020   pk_12_total 137.0 92.0 101.0     1.0         25.0   178.0 178.0             305     42   356 137 92 101     1         25   178 178         305   42   356
2323845 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771002901 9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter Alternative School Yes Other PK 12 2020   pk_12_total 42.0 2.0 4.0     1.0       1.0 2.0   20.0 32.0             4     1   52 42 2 4     1       1 2   20 32         4   1   52
2324122 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852003095 410 Capital High   Alternative School No High 09 12 2020   pk_12_total 20.0 53.0 37.0     1.0         18.0   62.0 67.0             105     27   129 20 53 37     1         18   62 67         105   27   129
2324218 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852003349 460 Innovative & Alternative High   Alternative School No High 09 12 2020   pk_12_total 29.0 32.0 37.0 1.0   3.0         13.0   68.0 47.0             69     30   115 29 32 37 1   3         13   68 47         69   30   115
2324223 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002909 220 Innovative & Alternative Middle   Alternative School No Middle 06 08 2020   pk_12_total                                                   0                                             0
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
2324372 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002265 400 Shabazz-City High   Alternative School No High 09 12 2020   pk_12_total 72.0 12.0 13.0 1.0   1.0         11.0   41.0 69.0             41     28   110 72 12 13 1   1         11   41 69         41   28   110
2324480 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002701 400 McKinley Academy charter Alternative School Yes High 09 12 2020   pk_12_total 26.0   5.0 1.0                 14.0 18.0             24     9   32 26   5 1                 14 18         24   9   32
2324795 WI Dane   school 5508910 3381 Public school McFarland 550891003067 470 Insight School of Wisconsin High charter Alternative School Yes High 09 12 2020   pk_12_total 115.0 31.0 30.0 5.0             21.0   92.0 110.0             129     41   202 115 31 30 5             21   92 110         129   41   202
2325135 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002743 400 Merrill Adult Diploma Academy charter Alternative School Yes High 10 12 2020   pk_12_total 17.0   1.0                   8.0 10.0             12         18 17   1                   8 10         12       18
2325329 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2020   pk_12_total   88.0 2.0               2.0   43.0 49.0             *     22   92   88 2               2   43 49             22   92
2325352 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002707 432 Banner Preparatory School of Milwaukee   Alternative School No High 09 12 2020   pk_12_total   59.0                 1.0   31.0 29.0             *     21   60   59                 1   31 29             21   60
2325756 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002577 410 Grandview High   Alternative School No High 09 12 2020   pk_12_total 17.0 28.0 158.0 7.0   4.0         3.0   105.0 112.0             194     33   217 17 28 158 7   4         3   105 112         194   33   217
2325804 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000963 236 Groppi High   Alternative School No High 09 12 2020   pk_12_total 1.0 124.0 7.0 2.0             1.0   73.0 62.0             126     31   135 1 124 7 2             1   73 62         126   31   135
2326037 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002567 296 Lad Lake Synergy School   Alternative School No High 06 12 2020   pk_12_total 6.0 14.0 16.0 1.0             2.0   26.0 13.0             *     11   39 6 14 16 1             2   26 13             11   39
2326239 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001306 315 Milwaukee County Youth Education Center   Alternative School No High 06 12 2020   pk_12_total 2.0 14.0 4.0 1.0                 21.0               *     10   21 2 14 4 1                 21               10   21
2326376 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000843 1072 NOVA-Northwest Opportunities Vocational Academy   Alternative School No High 09 12 2020   pk_12_total 3.0 81.0 5.0     1.0       1.0 1.0   48.0 44.0             *     33   92 3 81 5     1       1 1   48 44             33   92
2326414 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001007 458 Project STAY-Supporting Teachers and Youth   Alternative School No High 09 12 2020   pk_12_total 7.0 199.0 29.0 2.0   4.0         5.0   135.0 111.0             196     49   246 7 199 29 2   4         5   135 111         196   49   246
2326480 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000856 1074 Shalom High   Alternative School No High 09 12 2020   pk_12_total 2.0 71.0 2.0                   37.0 38.0             68     19   75 2 71 2                   37 38         68   19   75
2326506 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003057 442 South Accelerated Academy   Alternative School No High 09 12 2020   pk_12_total 1.0 24.0 9.0               2.0   25.0 11.0             *     9   36 1 24 9               2   25 11             9   36
2326516 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000936 1086 Southeastern   Alternative School No Middle 06 08 2020   pk_12_total   16.0 1.0                   13.0 4.0             *     3   17   16 1                   13 4             3   17
2326588 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002760 433 Transition High   Alternative School No High 09 12 2020   pk_12_total 1.0 161.0 5.0             1.0 1.0   67.0 102.0             147     37   169 1 161 5             1 1   67 102         147   37   169
2326627 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003055 448 Vincent Accelerated Academy   Alternative School No High 09 12 2020   pk_12_total 1.0 57.0 1.0     1.0         3.0   42.0 21.0             52     17   63 1 57 1     1         3   42 21         52   17   63
2327245 WI Wood   school 5510380 3906 Public school Nekoosa 551038002617 400 Nekoosa Academy   Alternative School No High 09 12 2020   pk_12_total 15.0   6.0 2.0             1.0   14.0 10.0             *     5   24 15   6 2             1   14 10             5   24
2327392 WI Waupaca   school 5510590 3955 Public school New London 551059002996 430 Catalyst Academy charter Alternative School Yes High 09 12 2020   pk_12_total 29.0   2.0                   22.0 9.0             13     5   31 29   2                   22 9         13   5   31
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
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
2327906 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092003060 800 Northeast Wisconsin Learning Academy   Alternative School No High 05 12 2020   pk_12_total 15.0   2.0                   11.0 6.0             *     5   17 15   2                   11 6             5   17
2328591 WI Columbia   school 5512060 4501 Public school Portage Community 551206002174 400 Portage Academy of Achievement   Alternative School No High 09 12 2020   pk_12_total 20.0   1.0                   14.0 7.0             11     4   21 20   1                   14 7         11   4   21
2328963 WI Racine   school 5512360 4620 Public school Racine Unified 551236003045 801 Racine Alternative Learning   Alternative School No Other KG 12 2020   pk_12_total 50.0 151.0 57.0     2.0         8.0   149.0 119.0             227     104   268 50 151 57     2         8   149 119         227   104   268
2329025 WI Racine   school 5512360 4620 Public school Racine Unified 551236001644 499 Walden III High   Alternative School No High 06 12 2020   pk_12_total 403.0 64.0 131.0 2.0   20.0       1.0 30.0   295.0 356.0             267     53   651 403 64 131 2   20       1 30   295 356         267   53   651

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