Data source: Big Local News · About: Big Local

2,262 rows where grade = "pk_12_total", state = "WI" and year = 2019 sorted by black

View and edit SQL

year

  • 2019 · 2,262

grade

  • pk_12_total · 2,262
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
3073916 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2019   pk_12_total 3.0                   1.0   1.0 3.0             *     *   4 3                   1   1 3                 4
3073980 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2019   pk_12_total 154.0   12.0     1.0         2.0   81.0 88.0             71     26   169 154   12     1         2   81 88         71   26   169
3073991 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2019   pk_12_total 72.0   1.0     2.0         2.0   48.0 29.0             18     16   77 72   1     2         2   48 29         18   16   77
3074006 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2019   pk_12_total 126.0   25.0 5.0   1.0       1.0 2.0   87.0 73.0             85     20   160 126   25 5   1       1 2   87 73         85   20   160
3074011 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2019   pk_12_total 69.0   13.0 4.0           2.0 4.0   36.0 56.0             56     18   92 69   13 4           2 4   36 56         56   18   92
3074023 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000024 40 Almond-Bancroft High   Regular School No High 09 12 2019   pk_12_total 98.0   28.0                   77.0 49.0             60     16   126 98   28                   77 49         60   16   126
3074028 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024003076 250 Almond-Bancroft Middle   Regular School No Middle 06 08 2019   pk_12_total 60.0   25.0                   49.0 36.0             44     15   85 60   25                   49 36         44   15   85
3074079 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2019   pk_12_total 99.0   11.0 1.0   1.0         1.0   59.0 54.0             57     24   113 99   11 1   1         1   59 54         57   24   113
3074124 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2019   pk_12_total 108.0   7.0               1.0   59.0 57.0             58     16   116 108   7               1   59 57         58   16   116
3074148 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002679 800 Appleton Cooperative Educational Center   Alternative School No Other 04 12 2019   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
3074150 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2019   pk_12_total 12.0   5.0                   4.0 13.0             8     1   17 12   5                   4 13         8   1   17
3074155 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2019   pk_12_total 136.0   12.0     3.0         4.0   73.0 82.0             29     10   155 136   12     3         4   73 82         29   10   155
3074235 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2019   pk_12_total 99.0   5.0     2.0         4.0   63.0 47.0             24     7   110 99   5     2         4   63 47         24   7   110
3074367 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2019   pk_12_total 62.0   2.0 2.0                 21.0 45.0             11     3   66 62   2 2                 21 45         11   3   66
3074423 WI Lafayette   school 5500450 161 Public school Argyle 550045000070 40 Argyle High   Regular School No High 09 12 2019   pk_12_total 91.0   2.0     2.0         1.0   46.0 50.0             31     7   96 91   2     2         1   46 50         31   7   96
3074428 WI Lafayette   school 5500450 161 Public school Argyle 550045003073 250 Argyle Middle   Regular School No Middle 06 08 2019   pk_12_total 52.0   2.0               1.0   33.0 22.0             28     9   55 52   2               1   33 22         28   9   55
3074446 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2019   pk_12_total 13.0   1.0 10.0                 12.0 12.0             *     6   24 13   1 10                 12 12             6   24
3074466 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2019   pk_12_total 186.0                       108.0 78.0             153     7   186 186                       108 78         153   7   186
3074473 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2019   pk_12_total 14.0     6.0             3.0   14.0 9.0             *     8   23 14     6             3   14 9             8   23
3074503 WI Marathon   school 5500570 196 Public school Athens 550057000086 20 Athens Elementary   Regular School No Elementary PK 05 2019   pk_12_total 159.0   17.0               2.0   92.0 86.0             78     22   178 159   17               2   92 86         78   22   178
3074511 WI Marathon   school 5500570 196 Public school Athens 550057000087 40 Athens High   Regular School No High 09 12 2019   pk_12_total 148.0   9.0     1.0         3.0   88.0 73.0             39     21   161 148   9     1         3   88 73         39   21   161
3074516 WI Marathon   school 5500570 196 Public school Athens 550057000088 60 Athens Middle   Regular School No Middle 06 08 2019   pk_12_total 67.0   8.0               1.0   34.0 42.0             30     9   76 67   8               1   34 42         30   9   76
3074520 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   pk_12_total 364.0   14.0               8.0   205.0 181.0             128     40   386 364   14               8   205 181         128   40   386
3074537 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2019   pk_12_total 4.0                       1.0 3.0             *     *   4 4                       1 3                 4
3074541 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No Elementary PK 05 2019   pk_12_total 243.0   10.0 1.0             13.0   138.0 129.0             149     60   267 243   10 1             13   138 129         149   60   267
3074559 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2019   pk_12_total 70.0                   1.0   34.0 37.0             22     3   71 70                   1   34 37         22   3   71
3074693 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No Elementary PK 04 2019   pk_12_total 65.0   1.0                   30.0 36.0             35     5   66 65   1                   30 36         35   5   66
3074713 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2019   pk_12_total 18.0   7.0 140.0   2.0         1.0   84.0 84.0             130     29   168 18   7 140   2         1   84 84         130   29   168
3074729 WI Bayfield   school 5500900 315 Public school Bayfield 550090002358 60 La Pointe Elementary   Regular School No Elementary PK 06 2019   pk_12_total 12.0   1.0 3.0             1.0   5.0 12.0             *         17 12   1 3             1   5 12                 17
3074775 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000127 120 South Beaver Dam Elementary   Regular School No Elementary KG 05 2019   pk_12_total 67.0   47.0               7.0   72.0 49.0             76     12   121 67   47               7   72 49         76   12   121
3074782 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000129 160 Washington Elementary   Regular School No Elementary KG 05 2019   pk_12_total 193.0   24.0     2.0         11.0   123.0 107.0             92     29   230 193   24     2         11   123 107         92   29   230
3074806 WI Marinette   school 5511550 4263 Public school Beecher-Dunbar-Pembine 551155001530 60 Pembine High   Regular School No High 07 12 2019   pk_12_total 102.0     1.0                 50.0 53.0             56     20   103 102     1                 50 53         56   20   103
3074823 WI Dane   school 5500990 350 Public school Belleville 550099000132 40 Belleville High   Regular School No High 09 12 2019   pk_12_total 242.0   19.0     1.0         16.0   139.0 139.0             41     28   278 242   19     1         16   139 139         41   28   278
3074831 WI Lafayette   school 5501020 364 Public school Belmont Community 550102000134 20 Belmont Elementary   Regular School No Elementary PK 05 2019   pk_12_total 163.0   15.0               2.0   93.0 87.0             38     24   180 163   15               2   93 87         38   24   180
3074840 WI Lafayette   school 5501020 364 Public school Belmont Community 550102000135 40 Belmont High   Regular School No High 06 12 2019   pk_12_total 189.0   9.0               6.0   96.0 108.0             77     22   204 189   9               6   96 108         77   22   204
3074945 WI Rock   school   422 Public Schools-Multidistrict Charters Beloit Turner   9803 JEDI Virtual K-12 charter           2019   pk_12_total                                                   0                                             0
3074964 WI Lafayette   school 5501110 427 Public school Benton 550111000160 20 Benton Elementary   Regular School No Elementary PK 06 2019   pk_12_total 97.0   2.0 2.0             2.0   54.0 49.0             43     17   103 97   2 2             2   54 49         43   17   103
3074974 WI Lafayette   school 5501110 427 Public school Benton 550111000161 40 Benton High   Regular School No High 09 12 2019   pk_12_total 61.0   2.0     3.0         4.0   41.0 29.0             17     8   70 61   2     3         4   41 29         17   8   70
3074979 WI Lafayette   school 5501110 427 Public school Benton 550111003061 250 Benton Middle   Regular School No Middle 07 08 2019   pk_12_total 27.0                       13.0 14.0             5     2   27 27                       13 14         5   2   27
3075005 WI Walworth   school   6013 Public Schools-Multidistrict Charters Big Foot UHS   9401 Walworth Co Educ Alt High charter           2019   pk_12_total 1.0                       1.0               *     *   1 1                       1                   1
3075014 WI Washburn   school 5501170 441 Public school Birchwood 550117000168 20 Birchwood Elementary   Regular School No Elementary PK 05 2019   pk_12_total 85.0   4.0 2.0             4.0   39.0 56.0             54     18   95 85   4 2             4   39 56         54   18   95
3075027 WI Washburn   school 5501170 441 Public school Birchwood 550117003374 210 Birchwood Middle   Regular School No Middle 06 08 2019   pk_12_total 54.0   5.0 3.0             3.0   31.0 34.0             35     9   65 54   5 3             3   31 34         35   9   65
3075031 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   pk_12_total 33.0   2.0                   18.0 17.0             15     4   35 33   2                   18 17         15   4   35
3075040 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2019   pk_12_total 11.0                       5.0 6.0             *     3   11 11                       5 6             3   11
3075130 WI Shawano   school 5501470 602 Public school Bonduel 550147000189 40 Bonduel High   Regular School No High 09 12 2019   pk_12_total 247.0   16.0 9.0   1.0         4.0   166.0 111.0             97     29   277 247   16 9   1         4   166 111         97   29   277
3075153 WI Grant   school 5501500 609 Public school Boscobel Area 550150000194 60 Boscobel Junior High   Regular School No Middle 07 08 2019   pk_12_total 107.0   2.0     1.0             60.0 50.0             68     20   110 107   2     1             60 50         68   20   110
3075156 WI Shawano   school 5501560 623 Public school Bowler 550156000199 20 Bowler Elementary   Regular School No Elementary PK 06 2019   pk_12_total 73.0   13.0 62.0             25.0   81.0 92.0             112     22   173 73   13 62             25   81 92         112   22   173
3075165 WI Shawano   school 5501560 623 Public school Bowler 550156000200 40 Bowler High   Regular School No High 07 12 2019   pk_12_total 69.0   5.0 50.0             17.0   82.0 59.0             71     25   141 69   5 50             17   82 59         71   25   141
3075172 WI Shawano   school   623 Public Schools-Multidistrict Charters Bowler   9100 Rural Virtual Academy charter           2019   pk_12_total 4.0     12.0             1.0   14.0 3.0             10     3   17 4     12             1   14 3         10   3   17
3075274 WI Rusk   school 5501830 735 Public school Bruce 550183000234 20 Bruce Elementary   Regular School No Elementary PK 05 2019   pk_12_total 183.0   8.0 2.0           1.0 6.0   110.0 90.0             120     26   200 183   8 2           1 6   110 90         120   26   200
3075283 WI Rusk   school 5501830 735 Public school Bruce 550183000235 40 Bruce High   Regular School No High 09 12 2019   pk_12_total 120.0   7.0 4.0             3.0   65.0 69.0             62     16   134 120   7 4             3   65 69         62   16   134
3075322 WI Racine   school   777 Public Schools-Multidistrict Charters Burlington Area   9803 JEDI Virtual K-12 charter           2019   pk_12_total 8.0   1.0               1.0   2.0 8.0             3     1   10 8   1               1   2 8         3   1   10
3075330 WI Racine   school 5501890 777 Public school Burlington Area 550189000635 120 Lyons Center   Regular School No Elementary PK 04 2019   pk_12_total 56.0   6.0               4.0   36.0 30.0             14     6   66 56   6               4   36 30         14   6   66
3075355 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   pk_12_total 102.0     2.0                 41.0 63.0             47     18   104 102     2                 41 63         47   18   104
3075364 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2019   pk_12_total 96.0     1.0             3.0   52.0 48.0             40     30   100 96     1             3   52 48         40   30   100
3075372 WI Ashland   school 5501920 840 Public school Butternut 550192002751 450 Promethean Charter School charter Regular School Yes High 09 12 2019   pk_12_total 1.0         1.0             2.0               *     *   2 1         1             2                   2
3075390 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000249 60 Cadott Junior High   Regular School No Middle 07 08 2019   pk_12_total 128.0   3.0               1.0   76.0 56.0             52     25   132 128   3               1   76 56         52   25   132
3075424 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes Secondary 07 10 2019   pk_12_total 12.0                       7.0 5.0             4     3   12 12                       7 5         4   3   12
3075432 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   pk_12_total 83.0   1.0               8.0   35.0 57.0             32     2   92 83   1               8   35 57         32   2   92
3075465 WI Barron   school 5502130 903 Public school Cameron 550213002500 9410 North Star Academy charter Alternative School Yes High 09 12 2019   pk_12_total 11.0                       8.0 3.0             *     2   11 11                       8 3             2   11
3075523 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   pk_12_total 95.0                       43.0 52.0             57     17   95 95                       43 52         57   17   95
3075563 WI Ozaukee   school 5502460 1015 Public school Cedarburg 550246002772 110 Early Learning Center   Special Education School No Prekindergarten PK PK 2019   pk_12_total 8.0                       4.0 4.0                   *   8 8                       4 4                 8
3075618 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2019   pk_12_total 26.0   1.0             3.0     18.0 12.0             23     8   30 26   1             3     18 12         23   8   30
3075656 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2019   pk_12_total 40.0   2.0 4.0   1.0         1.0   28.0 20.0             27         48 40   2 4   1         1   28 20         27       48
3075671 WI Barron   school   1080 Public Schools-Multidistrict Charters Chetek-Weyerhaeuser Area   9410 North Star Academy charter           2019   pk_12_total 7.0                       5.0 2.0             *     *   7 7                       5 2                 7
3075755 WI Polk   school 5502580 1120 Public school Clayton 550258000290 40 Clayton High   Regular School No High 09 12 2019   pk_12_total 112.0         1.0         2.0   57.0 58.0             59     25   115 112         1         2   57 58         59   25   115
3075760 WI Polk   school 5502580 1120 Public school Clayton 550258000558 60 Clayton Middle   Regular School No Middle 06 08 2019   pk_12_total 80.0                   1.0   40.0 41.0             50     9   81 80                   1   40 41         50   9   81
3075764 WI Polk   school 5502610 1127 Public school Clear Lake 550261000292 40 Clear Lake High   Regular School No High 09 12 2019   pk_12_total 166.0   5.0 3.0             2.0   87.0 89.0             59     24   176 166   5 3             2   87 89         59   24   176
3075769 WI Polk   school 5502610 1127 Public school Clear Lake 550261000293 60 Clear Lake Junior High   Regular School No Middle 07 08 2019   pk_12_total 70.0   4.0     1.0         1.0   40.0 36.0             36     9   76 70   4     1         1   40 36         36   9   76
3075851 WI Clark   school 5502730 1162 Public school Colby 550273000312 120 Little Stars Pre-School   Regular School No Prekindergarten PK PK 2019   pk_12_total 37.0   9.0                   22.0 24.0             24     6   46 37   9                   22 24         24   6   46
3075853 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2019   pk_12_total 9.0   1.0                   2.0 8.0             *         10 9   1                   2 8                 10
3075859 WI Marinette   school 5502760 1169 Public school Coleman 550276000313 40 Coleman Elementary   Regular School No Elementary PK 05 2019   pk_12_total 306.0   34.0 2.0             10.0   192.0 160.0             169     45   352 306   34 2             10   192 160         169   45   352
3075867 WI Marinette   school 5502760 1169 Public school Coleman 550276000314 60 Coleman High   Regular School No High 09 12 2019   pk_12_total 206.0   6.0     1.0         7.0   118.0 102.0             80     33   220 206   6     1         7   118 102         80   33   220
3075872 WI Marinette   school 5502760 1169 Public school Coleman 550276002847 200 Coleman Middle   Regular School No Middle 06 08 2019   pk_12_total 141.0   11.0               5.0   65.0 92.0             69     16   157 141   11               5   65 92         69   16   157
3075931 WI Chippewa   school 5502880 1204 Public school Cornell 550288002896 300 Cornell Middle   Regular School No Middle 06 08 2019   pk_12_total 85.0   2.0 1.0             2.0   38.0 52.0             53     17   90 85   2 1             2   38 52         53   17   90
3075935 WI Forest   school 5502910 1218 Public school Crandon 550291000326 40 Crandon Elementary   Regular School No Elementary PK 05 2019   pk_12_total 240.0   15.0 154.0           1.0 51.0   243.0 218.0             23     76   461 240   15 154           1 51   243 218         23   76   461
3075949 WI Forest   school 5502910 1218 Public school Crandon 550291002388 22 Crandon Middle   Regular School No Middle 06 08 2019   pk_12_total 112.0   6.0 45.0             15.0   98.0 80.0             45     27   178 112   6 45             15   98 80         45   27   178
3075953 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No Elementary PK 06 2019   pk_12_total 433.0   15.0     2.0         11.0   231.0 230.0             222     66   461 433   15     2         11   231 230         222   66   461
3075963 WI Marinette   school 5502970 1232 Public school Crivitz 550297000330 40 Crivitz High   Regular School No High 09 12 2019   pk_12_total 184.0   10.0             1.0 11.0   109.0 97.0             106     33   206 184   10             1 11   109 97         106   33   206
3075968 WI Marinette   school 5502970 1232 Public school Crivitz 550297000331 80 Crivitz Middle   Regular School No Middle 07 08 2019   pk_12_total 114.0   5.0               5.0   71.0 53.0             54     16   124 114   5               5   71 53         54   16   124
3075980 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No High 09 12 2019   pk_12_total 244.0   6.0               1.0   124.0 127.0             60     36   251 244   6               1   124 127         60   36   251
3075985 WI Grant   school 5503030 1246 Public school Cuba City 550303003103 30 Cuba City Middle   Regular School No Middle 06 08 2019   pk_12_total 128.0   5.0     2.0         1.0   68.0 68.0             39     25   136 128   5     2         1   68 68         39   25   136
3076041 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2019   pk_12_total 320.0   34.0 23.0   1.0         7.0   206.0 179.0             181     89   385 320   34 23   1         7   206 179         181   89   385
3076059 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Career and Technical School Yes High 07 12 2019   pk_12_total 35.0     1.0                 20.0 16.0             11     5   36 35     1                 20 16         11   5   36
3076066 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2019   pk_12_total 25.0   2.0                   15.0 12.0             10     1   27 25   2                   15 12         10   1   27
3076087 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002885 400 D C Everest Idea School charter Regular School Yes High 06 12 2019   pk_12_total 65.0   4.0                   42.0 27.0             9     5   69 65   4                   42 27         9   5   69
3076258 WI Vernon   school 5503240 1421 Public school De Soto Area 550324003022 810 De Soto Virtual School charter Regular School Yes Other KG 12 2019   pk_12_total 6.0                       4.0 2.0             *         6 6                       4 2                 6
3076314 WI Walworth   school   1380 Public Schools-Multidistrict Charters Delavan-Darien   9401 Walworth Co Educ Alt High charter           2019   pk_12_total     2.0                   1.0 1.0             *     *   2     2                   1 1                 2
3076320 WI Brown   school 5503660 1407 Public school Denmark 550366002936 450 Denmark Community School charter Regular School Yes High 07 12 2019   pk_12_total 36.0                       17.0 19.0             7     4   36 36                       17 19         7   4   36
3076327 WI Brown   school 5503660 1407 Public school Denmark 550366000346 40 Denmark Early Childhood Ctr   Regular School No Elementary PK KG 2019   pk_12_total 173.0   10.0     3.0         4.0   95.0 95.0             43     36   190 173   10     3         4   95 95         43   36   190
3076389 WI Racine   school 5503750 1449 Public school Dover #1 550375000394 20 Kansasville Elementary   Regular School No Elementary PK 08 2019   pk_12_total 74.0   7.0               11.0   43.0 49.0             22     12   92 74   7               11   43 49         22   12   92
3076412 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2019   pk_12_total 152.0   6.0 11.0             10.0   97.0 82.0             99     18   179 152   6 11             10   97 82         99   18   179
3076430 WI Pepin   school 5503840 1499 Public school Durand-Arkansaw 550384000116 20 Caddie Woodlawn Elementary   Regular School No Elementary PK 05 2019   pk_12_total 430.0   27.0 3.0   2.0         12.0   259.0 215.0             198     67   474 430   27 3   2         12   259 215         198   67   474
3076502 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000424 220 Locust Lane Elementary   Regular School No Elementary KG 05 2019   pk_12_total 173.0   8.0 1.0   54.0         12.0   134.0 114.0             139     45   248 173   8 1   54         12   134 114         139   45   248
3076558 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002675 430 Oxford Avenue School   Alternative School No High 10 12 2019   pk_12_total                                                   0                                             0
3076613 WI Marathon   school 5504080 1561 Public school Edgar 550408002391 23 Edgar Middle   Regular School No Middle 06 08 2019   pk_12_total 129.0   1.0 4.0   1.0             61.0 74.0             32     14   135 129   1 4   1             61 74         32   14   135
3076635 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No Elementary 01 05 2019   pk_12_total 76.0   9.0               12.0   46.0 51.0             33     12   97 76   9               12   46 51         33   12   97
3076641 WI Langlade   school 5504170 1582 Public school Elcho 550417000447 20 Elcho Elementary   Regular School No Elementary PK 05 2019   pk_12_total 116.0   2.0 2.0               1.0 62.0 59.0             75     20   121 116   2 2               1 62 59         75   20   121
3076649 WI Langlade   school 5504170 1582 Public school Elcho 550417000448 40 Elcho High   Regular School No High 09 12 2019   pk_12_total 71.0   1.0 6.0             4.0   41.0 41.0             38     10   82 71   1 6             4   41 41         38   10   82
3076654 WI Langlade   school 5504170 1582 Public school Elcho 550417002947 250 Elcho Middle   Regular School No Middle 06 08 2019   pk_12_total 62.0   3.0 3.0             1.0 1.0 42.0 28.0             38     6   70 62   3 3             1 1 42 28         38   6   70

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