Data source: Big Local News · About: Big Local

2,237 rows where grade = "pk_12_total", state = "WI" and year = 2017 sorted by multiracial

View and edit SQL

year

  • 2017 · 2,237

grade

  • pk_12_total · 2,237
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
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
325655 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   pk_12_total 129.0   6.0 1.0                 65.0 71.0             100     29   136 129   6 1                 65 71         100   29   136
325726 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2017   pk_12_total 143.0 2.0 22.0 4.0                 98.0 73.0             80     24   171 143 2 22 4                 98 73         80   24   171
325740 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond High   Regular School No Other 06 12 2017   pk_12_total 162.0 1.0 46.0 1.0                 123.0 87.0             89     33   210 162 1 46 1                 123 87         89   33   210
325748 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000025 60 Bancroft Elementary   Regular School No Elementary PK KG 2017   pk_12_total 46.0   13.0 1.0                 32.0 28.0             22     6   60 46   13 1                 32 28         22   6   60
325829 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2017   pk_12_total 13.0 1.0                     8.0 6.0             6     3   14 13 1                     8 6         6   3   14
325837 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2017   pk_12_total 113.0 2.0 5.0 1.0                 64.0 57.0             67     13   121 113 2 5 1                 64 57         67   13   121
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
325863 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2017   pk_12_total 15.0                       5.0 10.0             5         15 15                       5 10         5       15
326084 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002547 430 Tesla Engineering Charter School charter Regular School Yes High 09 12 2017   pk_12_total 114.0   5.0     6.0             107.0 18.0             21     3   125 114   5     6             107 18         21   3   125
326131 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003041 290 Arcadia Middle   Regular School No Middle 05 08 2017   pk_12_total 144.0 3.0 203.0                   184.0 166.0             232     42   350 144 3 203                   184 166         232   42   350
326158 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Ashland Charter High School charter Regular School Yes High 09 12 2017   pk_12_total 20.0     4.0                 13.0 11.0             10     4   24 20     4                 13 11         10   4   24
326236 WI Marathon   school 5500570 196 Public school Athens 550057000088 60 Athens Middle   Regular School No Middle 06 08 2017   pk_12_total 60.0   1.0                   35.0 26.0             22     14   61 60   1                   35 26         22   14   61
326256 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2017   pk_12_total 5.0                       2.0 3.0             *     *   5 5                       2 3                 5
326396 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary PK 04 2017   pk_12_total 67.0   5.0                   42.0 30.0             45     3   72 67   5                   42 30         45   3   72
326415 WI Barron   school   308 Public Schools-Multidistrict Charters Barron Area   9410 North Star Academy charter           2017   pk_12_total 14.0   1.0                   10.0 5.0             2     2   15 14   1                   10 5         2   2   15
326418 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No Elementary PK 04 2017   pk_12_total 69.0   1.0 1.0                 26.0 45.0             38     2   71 69   1 1                 26 45         38   2   71
326451 WI Bayfield   school 5500900 315 Public school Bayfield 550090000082 30 Bayfield Middle   Regular School No Middle 06 08 2017   pk_12_total 13.0 3.0 1.0 60.0                 48.0 29.0             51     20   77 13 3 1 60                 48 29         51   20   77
326529 WI Marinette   school 5511550 4263 Public school Beecher-Dunbar-Pembine 551155001530 60 Pembine High   Regular School No High 07 12 2017   pk_12_total 110.0 1.0   1.0                 62.0 50.0             59     16   112 110 1   1                 62 50         59   16   112
326565 WI Lafayette   school 5501020 364 Public school Belmont Community 550102000135 40 Belmont High   Regular School No Other 06 12 2017   pk_12_total 180.0 1.0 8.0     1.0             96.0 94.0             69     17   190 180 1 8     1             96 94         69   17   190
326686 WI Lafayette   school 5501110 427 Public school Benton 550111000160 20 Benton Elementary   Regular School No Elementary PK 06 2017   pk_12_total 113.0 3.0 1.0 2.0                 61.0 58.0             39     16   119 113 3 1 2                 61 58         39   16   119
326726 WI Walworth   school   6013 Public Schools-Multidistrict Charters Big Foot UHS   9401 Walworth Co Educ Alt High charter           2017   pk_12_total 4.0   2.0                   2.0 4.0             *     *   6 4   2                   2 4                 6
326777 WI Lafayette   school 5505730 2240 Public school Black Hawk 550573000606 40 Black Hawk Middle   Regular School No Middle 06 08 2017   pk_12_total 64.0 4.0                     35.0 33.0             28     8   68 64 4                     35 33         28   8   68
326817 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes Elementary KG 06 2017   pk_12_total 57.0                       34.0 23.0             14     4   57 57                       34 23         14   4   57
326870 WI Grant   school 5501500 609 Public school Boscobel Area 550150000193 40 Boscobel High   Regular School No High 09 12 2017   pk_12_total 230.0 1.0 7.0 1.0   2.0             129.0 112.0             112     47   241 230 1 7 1   2             129 112         112   47   241
326875 WI Grant   school 5501500 609 Public school Boscobel Area 550150000194 60 Boscobel Junior High   Regular School No Middle 07 08 2017   pk_12_total 109.0 1.0 6.0     1.0             60.0 57.0             56     22   117 109 1 6     1             60 57         56   22   117
327034 WI Racine   school 5501890 777 Public school Burlington Area 550189000635 120 Lyons Center   Regular School No Elementary PK 04 2017   pk_12_total 60.0   11.0 1.0                 32.0 40.0             23     6   72 60   11 1                 32 40         23   6   72
327057 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   pk_12_total 85.0     1.0                 34.0 52.0             55     12   86 85     1                 34 52         55   12   86
327066 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No Other 06 12 2017   pk_12_total 93.0     1.0                 50.0 44.0             46     21   94 93     1                 50 44         46   21   94
327127 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   pk_12_total 61.0 1.0                     27.0 35.0             5     2   62 61 1                     27 35         5   2   62
327153 WI Barron   school 5502130 903 Public school Cameron 550213002286 200 Cameron Middle   Regular School No Middle 05 08 2017   pk_12_total 264.0 2.0 7.0                   136.0 137.0             88     25   273 264 2 7                   136 137         88   25   273
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
327216 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   pk_12_total 96.0                       51.0 45.0             54     10   96 96                       51 45         54   10   96
327226 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2017   pk_12_total 93.0                       44.0 49.0             40     9   93 93                       44 49         40   9   93
327256 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Elementary PK PK 2017   pk_12_total 10.0         1.0             7.0 4.0             1     *   11 10         1             7 4         1       11
327316 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No Elementary PK 03 2017   pk_12_total 35.0 1.0   2.0                 29.0 9.0             *     4   38 35 1   2                 29 9             4   38
327364 WI Barron   school   1080 Public Schools-Multidistrict Charters Chetek-Weyerhaeuser Area   9410 North Star Academy charter           2017   pk_12_total 10.0                       6.0 4.0             *     1   10 10                       6 4             1   10
327449 WI Polk   school 5502580 1120 Public school Clayton 550258000290 40 Clayton High   Regular School No High 09 12 2017   pk_12_total 109.0         1.0             53.0 57.0             48     19   110 109         1             53 57         48   19   110
327463 WI Polk   school 5502610 1127 Public school Clear Lake 550261000293 60 Clear Lake Junior High   Regular School No Middle 07 08 2017   pk_12_total 90.0   2.0                   48.0 44.0             38     12   92 90   2                   48 44         38   12   92
327504 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000303 60 Dellwood Early Learning Center   Regular School No Elementary PK PK 2017   pk_12_total 64.0 1.0 7.0 4.0                 43.0 33.0             37     17   76 64 1 7 4                 43 33         37   17   76
327536 WI Clark   school 5502730 1162 Public school Colby 550273000309 40 Colby High   Regular School No High 09 12 2017   pk_12_total 232.0 1.0 50.0 4.0   2.0             140.0 149.0             121     24   289 232 1 50 4   2             140 149         121   24   289
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
327608 WI Chippewa   school 5502880 1204 Public school Cornell 550288000323 20 Cornell Elementary   Regular School No Elementary PK 05 2017   pk_12_total 189.0 3.0 5.0 1.0   1.0             88.0 111.0             134     39   199 189 3 5 1   1             88 111         134   39   199
327756 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2017   pk_12_total 18.0 1.0 3.0                   12.0 10.0             8         22 18 1 3                   12 10         8       22
327774 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002885 400 D C Everest Idea School charter Regular School Yes Other 06 12 2017   pk_12_total 71.0 2.0 1.0                   41.0 33.0             10     6   74 71 2 1                   41 33         10   6   74
327849 WI Lafayette   school 5503150 1295 Public school Darlington Community 550315000348 40 Darlington High   Regular School No High 09 12 2017   pk_12_total 197.0 1.0 20.0     1.0             110.0 109.0             59     16   219 197 1 20     1             110 109         59   16   219
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
327995 WI Walworth   school   1380 Public Schools-Multidistrict Charters Delavan-Darien   9401 Walworth Co Educ Alt High charter           2017   pk_12_total 4.0   2.0                   2.0 4.0             *     *   6 4   2                   2 4                 6
328110 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000397 50 Drummond Junior High   Regular School No Middle 07 08 2017   pk_12_total 52.0   1.0 4.0                 32.0 25.0             28     17   57 52   1 4                 32 25         28   17   57
328281 WI Marathon   school 5504080 1561 Public school Edgar 550408000440 20 Edgar Elementary   Regular School No Elementary PK 05 2017   pk_12_total 289.0   7.0 2.0   2.0       1.0     163.0 138.0             83     36   301 289   7 2   2       1     163 138         83   36   301
328290 WI Marathon   school 5504080 1561 Public school Edgar 550408000441 40 Edgar High   Regular School No High 09 12 2017   pk_12_total 184.0 3.0 1.0 2.0   1.0             105.0 86.0             42     20   191 184 3 1 2   1             105 86         42   20   191
328295 WI Marathon   school 5504080 1561 Public school Edgar 550408002391 23 Edgar Middle   Regular School No Middle 06 08 2017   pk_12_total 120.0   1.0 2.0   1.0       1.0     60.0 65.0             35     17   125 120   1 2   1       1     60 65         35   17   125
328358 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000453 40 Elk Mound High   Regular School No High 09 12 2017   pk_12_total 294.0 1.0 5.0     17.0             161.0 156.0             55     31   317 294 1 5     17             161 156         55   31   317
328525 WI Pierce   school 5504350 1666 Public school Elmwood 550435000470 20 Elmwood Elementary   Regular School No Elementary PK 05 2017   pk_12_total 143.0 1.0 6.0 1.0                 86.0 65.0             54     12   151 143 1 6 1                 86 65         54   12   151
328533 WI Pierce   school 5504350 1666 Public school Elmwood 550435000471 40 Elmwood High   Regular School No High 09 12 2017   pk_12_total 89.0   3.0     1.0             40.0 53.0             18     6   93 89   3     1             40 53         18   6   93
328538 WI Pierce   school 5504350 1666 Public school Elmwood 550435000347 30 Elmwood Middle   Regular School No Middle 06 08 2017   pk_12_total 70.0   7.0                   38.0 39.0             28     7   77 70   7                   38 39         28   7   77
328592 WI Eau Claire   school 5504500 1729 Public school Fall Creek 550450000482 50 Fall Creek Middle   Regular School No Middle 06 08 2017   pk_12_total 175.0 1.0       2.0             91.0 87.0             32     16   178 175 1       2             91 87         32   16   178
328622 WI Grant   school 5504590 1813 Public school Fennimore Community 550459000486 40 Fennimore High   Regular School No High 09 12 2017   pk_12_total 233.0 2.0 10.0     4.0             137.0 112.0             95     40   249 233 2 10     4             137 112         95   40   249
328640 WI Rusk   school 5514970 5757 Public school Flambeau 551497001951 40 Flambeau High   Regular School No High 09 12 2017   pk_12_total 163.0 1.0 3.0 1.0                 89.0 79.0             84     33   168 163 1 3 1                 89 79         84   33   168
328645 WI Rusk   school 5514970 5757 Public school Flambeau 551497001952 50 Flambeau Middle   Regular School No Middle 06 08 2017   pk_12_total 123.0   1.0                   54.0 70.0             58     12   124 123   1                   54 70         58   12   124
328659 WI Florence   school 5504650 1855 Public school Florence County 550465000490 60 Florence High   Regular School No High 09 12 2017   pk_12_total 100.0 3.0 1.0 2.0                 64.0 42.0             *     18   106 100 3 1 2                 64 42             18   106
328664 WI Florence   school 5504650 1855 Public school Florence County 550465002360 80 Florence Middle   Regular School No Middle 07 08 2017   pk_12_total 48.0 1.0 1.0                   25.0 25.0             *     7   50 48 1 1                   25 25             7   50
328781 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474000509 20 Barrie Elementary   Regular School No Elementary PK 05 2017   pk_12_total 239.0 11.0 18.0 1.0   4.0             153.0 120.0             83     19   273 239 11 18 1   4             153 120         83   19   273
328788 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474002749 130 Fort Atkinson 4K   Regular School No Elementary PK PK 2017   pk_12_total 103.0 1.0 12.0     1.0             66.0 51.0             2     2   117 103 1 12     1             66 51         2   2   117
328790 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474000510 80 Fort Atkinson High   Regular School No High 09 12 2017   pk_12_total 771.0 12.0 114.0 2.0   11.0             447.0 463.0             253     51   910 771 12 114 2   11             447 463         253   51   910
328988 WI Walworth   school 5505130 2051 Public school Genoa City J2 550513002327 200 Brookwood Middle   Regular School No Elementary 04 08 2017   pk_12_total 246.0 3.0 29.0 2.0                 149.0 131.0             110     22   280 246 3 29 2                 149 131         110   22   280
329079 WI Taylor   school 5505280 2135 Public school Gilman 550528000568 60 Gilman High   Regular School No High 07 12 2017   pk_12_total 167.0   2.0 1.0                 93.0 77.0             87     23   170 167   2 1                 93 77         87   23   170
329086 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000573 40 Gilmanton Elementary   Regular School No Elementary PK 04 2017   pk_12_total 53.0                       29.0 24.0             26     6   53 53                       29 24         26   6   53
329117 WI Saint Croix   school 5505520 2198 Public school Glenwood City 550552000586 60 Glenwood City Elementary   Regular School No Elementary PK 05 2017   pk_12_total 327.0 5.0 13.0 3.0   5.0       1.0     183.0 171.0             126     51   354 327 5 13 3   5       1     183 171         126   51   354
329135 WI Saint Croix   school 5505520 2198 Public school Glenwood City 550552002469 400 Transitional Skills Center charter Regular School Yes High 10 12 2017   pk_12_total 9.0 1.0 1.0                   6.0 5.0             *     3   11 9 1 1                   6 5             3   11
329138 WI Marinette   school 5505580 2212 Public school Goodman-Armstrong Creek 550558000592 40 Goodman High   Regular School No High 07 12 2017   pk_12_total 52.0 1.0   1.0                 30.0 24.0             18     9   54 52 1   1                 30 24         18   9   54
329145 WI Marinette   school 5505580 2212 Public school Goodman-Armstrong Creek 550558000593 20 Goodman-Armstrong Elementary   Regular School No Elementary PK 06 2017   pk_12_total 53.0 1.0               3.0     26.0 31.0             20     6   57 53 1               3     26 31         20   6   57
329751 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002837 200 LIFE-Learning Innovating Fueling Excelling Entrepreneur Magnet School   Regular School No Middle 06 08 2017   pk_12_total 67.0   2.0     1.0             39.0 31.0             11     13   70 67   2     1             39 31         11   13   70
329934 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002854 220 Fox West Academy charter Regular School Yes Middle 06 08 2017   pk_12_total 56.0   1.0 1.0   2.0             35.0 25.0             4     6   60 56   1 1   2             35 25         4   6   60
330191 WI Richland   school 5506960 2660 Public school Ithaca 550696000753 80 Ithaca Middle   Regular School No Middle 06 08 2017   pk_12_total 91.0 2.0       1.0             58.0 36.0             37     18   94 91 2       1             58 36         37   18   94
330367 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2017   pk_12_total 5.0                       2.0 3.0             *     *   5 5                       2 3                 5
330676 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001714 405 Phoenix Project   Alternative School No High 09 12 2017   pk_12_total 6.0 15.0 3.0                   20.0 4.0             9     12   24 6 15 3                   20 4         9   12   24
330828 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351000378 160 Magee Elementary   Regular School No Elementary PK 05 2017   pk_12_total 234.0 1.0 26.0 1.0   4.0             136.0 130.0             46     36   266 234 1 26 1   4             136 130         46   36   266
330894 WI Kewaunee   school 5507410 2814 Public school Kewaunee 550741000841 100 Kewaunee High   Regular School No High 09 12 2017   pk_12_total 286.0 2.0 17.0     4.0             150.0 159.0             84     41   309 286 2 17     4             150 159         84   41   309
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
330922 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002554 405 Kiel eSchool charter Regular School Yes High 07 12 2017   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
331160 WI Vernon   school   2863 Public Schools-Multidistrict Charters La Farge   9407 Vernon County Area Better Futures High charter           2017   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
331251 WI Jefferson   school   2898 Public Schools-Multidistrict Charters Lake Mills Area   9803 JEDI Virtual K-12 charter           2017   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
331294 WI Forest   school 5507830 2940 Public school Laona 550783000893 20 Laona High   Regular School No High 07 12 2017   pk_12_total 88.0     5.0           1.0     49.0 45.0             33     13   94 88     5           1     49 45         33   13   94
331349 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816002959 130 Flex Academy charter Regular School Yes Elementary KG 08 2017   pk_12_total 70.0   4.0             1.0     39.0 36.0             12         75 70   4             1     39 36         12       75
331359 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816002905 410 Little Chute Career Pathways Academy charter Regular School Yes High 09 12 2017   pk_12_total 114.0 2.0 4.0                   51.0 69.0             12     1   120 114 2 4                   51 69         12   1   120
331372 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000901 40 Little Chute High   Regular School No High 09 12 2017   pk_12_total 328.0 6.0 22.0 5.0   8.0             205.0 164.0             98     18   369 328 6 22 5   8             205 164         98   18   369
331401 WI Columbia   school 5508190 3150 Public school Lodi 550819002846 130 Lodi-4-Kids   Regular School No Elementary PK PK 2017   pk_12_total 73.0 1.0 5.0     1.0             42.0 38.0             1     5   80 73 1 5     1             42 38         1   5   80
331477 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834000917 120 Luxemburg-Casco Middle   Regular School No Middle 07 08 2017   pk_12_total 292.0 1.0 24.0 2.0                 171.0 148.0             61     32   319 292 1 24 2                 171 148         61   32   319
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
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
331824 WI Waupaca   school   3276 Public Schools-Multidistrict Charters Manawa   9408 Waupaca County Charter charter           2017   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
331941 WI Marathon   school 5508670 3304 Public school Marathon City 550867002893 210 Marathon Venture Academy charter Regular School Yes Middle 06 08 2017   pk_12_total 125.0   3.0     5.0             67.0 66.0             19     16   133 125   3     5             67 66         19   16   133
331945 WI Marinette   school 5508700 3311 Public school Marinette 550870002335 40 Garfield Elementary   Regular School No Elementary PK 04 2017   pk_12_total 171.0 5.0 8.0 3.0                 99.0 88.0             106     38   187 171 5 8 3                 99 88         106   38   187
331961 WI Marinette   school 5508700 3311 Public school Marinette 550870000998 120 Merryman Elementary   Regular School No Elementary PK 04 2017   pk_12_total 161.0 2.0 3.0             1.0     91.0 76.0             82     43   167 161 2 3             1     91 76         82   43   167
331966 WI Marinette   school 5508700 3311 Public school Marinette 550870000999 140 Park Elementary   Regular School No Elementary PK 04 2017   pk_12_total 197.0 4.0 1.0 5.0   2.0             112.0 97.0             117     37   209 197 4 1 5   2             112 97         117   37   209
331984 WI Waupaca   school 5508730 3318 Public school Marion 550873001005 100 Marion High   Regular School No High 07 12 2017   pk_12_total 186.0 2.0 1.0 5.0   4.0             103.0 95.0             89     32   198 186 2 1 5   4             103 95         89   32   198
332010 WI Dane   school 5508790 3332 Public school Marshall 550879001791 400 Marshall Charter charter Regular School Yes High 10 12 2017   pk_12_total 5.0   2.0                   4.0 3.0             *         7 5   2                   4 3                 7
332066 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2017   pk_12_total 280.0 1.0 14.0 1.0   1.0             156.0 141.0             71     23   297 280 1 14 1   1             156 141         71   23   297
332088 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2017   pk_12_total 33.0   5.0 2.0                 14.0 26.0             21     2   40 33   5 2                 14 26         21   2   40

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