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_low_grade

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
2320553 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No Elementary 01 05 2020   pk_12_total 459.0   17.0 1.0   6.0         14.0   255.0 242.0             134     85   497 459   17 1   6         14   255 242         134   85   497
2320872 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No Elementary 01 05 2020   pk_12_total 80.0   6.0               13.0   48.0 51.0             33     16   99 80   6               13   48 51         33   16   99
2321749 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000601 60 Grantsburg Elementary   Regular School No Elementary 01 03 2020   pk_12_total 150.0 1.0 4.0 1.0             15.0   81.0 90.0             84     34   171 150 1 4 1             15   81 90         84   34   171
2323006 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000797 120 Haen Elementary   Regular School No Elementary 01 04 2020   pk_12_total 225.0 15.0 14.0 1.0             19.0   141.0 133.0             141     58   274 225 15 14 1             19   141 133         141   58   274
2324566 WI Marinette   school 5508700 3311 Public school Marinette 550870002335 40 Garfield Elementary   Regular School No Elementary 01 04 2020   pk_12_total 151.0 6.0 5.0 3.0             4.0   90.0 79.0             101     27   169 151 6 5 3             4   90 79         101   27   169
2324581 WI Marinette   school 5508700 3311 Public school Marinette 550870000998 120 Merryman Elementary   Regular School No Elementary 01 04 2020   pk_12_total 147.0   10.0 2.0                 91.0 68.0             77     23   159 147   10 2                 91 68         77   23   159
2324586 WI Marinette   school 5508700 3311 Public school Marinette 550870000999 140 Park Elementary   Regular School No Elementary 01 04 2020   pk_12_total 171.0 9.0 13.0 2.0             7.0   108.0 94.0             119     39   202 171 9 13 2             7   108 94         119   39   202
2326519 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002442 312 Starms Discovery   Regular School No Elementary 01 08 2020   pk_12_total 1.0 263.0 12.0     1.0         5.0   141.0 141.0             *     83   282 1 263 12     1         5   141 141             83   282
2326989 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999001313 130 Mount Horeb Primary Center   Regular School No Elementary 01 02 2020   pk_12_total 298.0 1.0 15.0     3.0         12.0   167.0 162.0             51     29   329 298 1 15     3         12   167 162         51   29   329
2327101 WI Juneau   school 5510230 3871 Public school Necedah Area 551023003112 100 N-Vision Learning Center charter Regular School Yes Elementary 01 05 2020   pk_12_total 66.0   2.0               1.0   33.0 36.0             25     9   69 66   2               1   33 36         25   9   69
2328464 WI Grant   school 5511850 4389 Public school Platteville 551185001555 120 Westview Elementary   Regular School No Elementary 01 04 2020   pk_12_total 352.0 23.0 12.0     19.0         16.0   211.0 211.0             169     49   422 352 23 12     19         16   211 211         169   49   422
2329270 WI Richland   school 5512960 4851 Public school Richland 551296001705 240 Jefferson Elementary   Regular School No Elementary 01 05 2020   pk_12_total 115.0 5.0 22.0               16.0   86.0 72.0             122     27   158 115 5 22               16   86 72         122   27   158
2329439 WI Sauk   school 5514250 5523 Public school River Valley 551425002346 120 River Valley Elementary   Regular School No Elementary 01 04 2020   pk_12_total 257.0 2.0 13.0     2.0         3.0   146.0 131.0             107     39   277 257 2 13     2         3   146 131         107   39   277
2329913 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002712 170 Northeast Wisconsin Montessori Charter School charter Regular School Yes Elementary 01 06 2020   pk_12_total 5.0   2.0               1.0   6.0 2.0             1         8 5   2               1   6 2         1       8
2330619 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001392 120 Sawyer Elementary   Regular School No Elementary 01 02 2020   pk_12_total 99.0 3.0 13.0 1.0   2.0         9.0   68.0 59.0             75     21   127 99 3 13 1   2         9   68 59         75   21   127
2318543 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan   Regular School No Middle 02 08 2020   pk_12_total 149.0   5.0     19.0         4.0   98.0 79.0             26     14   177 149   5     19         4   98 79         26   14   177
2318898 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary 02 04 2020   pk_12_total 27.0 6.0 4.0     1.0         1.0   24.0 15.0             27         39 27 6 4     1         1   24 15         27       39
2319293 WI Jackson   school 5501260 476 Public school Black River Falls 550126002428 130 Red Creek Elementary   Regular School No Elementary 02 05 2020   pk_12_total 309.0 6.0 20.0 115.0   2.0         24.0   250.0 226.0             305     79   476 309 6 20 115   2         24   250 226         305   79   476
2323029 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000796 100 Quinney Elementary   Regular School No Elementary 02 04 2020   pk_12_total 272.0 1.0 27.0     15.0         17.0   169.0 163.0             86     53   332 272 1 27     15         17   169 163         86   53   332
2326814 WI Dane   school 5509810 3675 Public school Monona Grove 550981001289 20 Cottage Grove Elementary   Regular School No Elementary 02 04 2020   pk_12_total 362.0 14.0 25.0 2.0   15.0         28.0   229.0 217.0             92     30   446 362 14 25 2   15         28   229 217         92   30   446
2327928 WI Winnebago   school 5510980 4088 Public school Omro 551098002261 110 Omro Elementary   Regular School No Elementary 02 05 2020   pk_12_total 287.0 3.0 15.0     1.0         3.0   147.0 162.0             112     43   309 287 3 15     1         3   147 162         112   43   309
2328586 WI Columbia   school 5512060 4501 Public school Portage Community 551206002310 90 Muir Elementary   Regular School No Elementary 02 05 2020   pk_12_total 249.0 8.0 26.0 3.0   4.0         8.0   155.0 143.0             146     43   298 249 8 26 3   4         8   155 143         146   43   298
2328658 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002830 150 Bluff View Elementary   Regular School No Elementary 02 04 2020   pk_12_total 207.0 2.0 4.0 1.0   2.0         5.0   118.0 103.0             131     32   221 207 2 4 1   2         5   118 103         131   32   221
2330901 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001933 20 Camp Douglas Elementary   Regular School No Elementary 02 05 2020   pk_12_total 53.0 2.0 1.0 1.0             1.0   29.0 29.0             35         58 53 2 1 1             1   29 29         35       58
2331721 WI Waupaca   school 5515840 6195 Public school Waupaca 551584003091 180 Chain Exploration Center charter Regular School Yes Elementary 02 06 2020   pk_12_total 84.0 3.0 1.0                   52.0 36.0             30     8   88 84 3 1                   52 36         30   8   88
2331754 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002809 110 Rock River Intermediate   Regular School No Elementary 02 06 2020   pk_12_total 547.0 5.0 47.0 1.0   1.0       1.0 17.0   326.0 293.0             261     90   619 547 5 47 1   1       1 17   326 293         261   90   619
2318287 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2020   pk_12_total 261.0 2.0 11.0 2.0   3.0         10.0   156.0 133.0             123     45   289 261 2 11 2   3         10   156 133         123   45   289
2318670 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2020   pk_12_total 33.0 2.0 5.0 8.0             7.0   27.0 28.0             39     4   55 33 2 5 8             7   27 28         39   4   55
2319168 WI Rock   school 5501080 422 Public school Beloit Turner 550108000158 100 Townview Elementary   Regular School No Elementary 03 05 2020   pk_12_total 288.0 7.0 37.0     1.0         20.0   171.0 182.0             162     44   353 288 7 37     1         20   171 182         162   44   353
2320132 WI Columbia   school 5502820 1183 Public school Columbus 550282003100 150 Columbus Intermediate   Regular School No Elementary 03 05 2020   pk_12_total 202.0 7.0 24.0     1.0         9.0   131.0 112.0             81     43   243 202 7 24     1         9   131 112         81   43   243
2320523 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 03 04 2020   pk_12_total 85.0 2.0 127.0 1.0   2.0         5.0   120.0 102.0             164     33   222 85 2 127 1   2         5   120 102         164   33   222
2320690 WI Walworth   school 5504020 1540 Public school East Troy Community 550402001640 100 Prairie View Elementary   Regular School No Elementary 03 05 2020   pk_12_total 272.0 3.0 22.0 1.0           2.0 9.0   171.0 138.0             96     40   309 272 3 22 1           2 9   171 138         96   40   309
2321136 WI Rock   school 5504440 1694 Public school Evansville Community 550444002552 100 Theodore Robinson Intermediate School   Regular School No Elementary 03 05 2020   pk_12_total 341.0 9.0 32.0     1.0         12.0   196.0 199.0             104     37   395 341 9 32     1         12   196 199         104   37   395
2321254 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468002862 150 Fond du Lac STEM Academy charter Regular School Yes Elementary 03 05 2020   pk_12_total 42.0 1.0 3.0     4.0         7.0   33.0 24.0             23     8   57 42 1 3     4         7   33 24         23   8   57
2322293 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002845 110 Hartland School of Community Learning   Regular School No Elementary 03 05 2020   pk_12_total 51.0   6.0     1.0         4.0   34.0 28.0             15     6   62 51   6     1         4   34 28         15   6   62
2322311 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002258 40 South Elementary   Regular School No Elementary 03 05 2020   pk_12_total 233.0 1.0 14.0 2.0   4.0       1.0 11.0   133.0 133.0             46     30   266 233 1 14 2   4       1 11   133 133         46   30   266
2322335 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002417 110 Hayward Intermediate   Regular School No Elementary 03 05 2020   pk_12_total 234.0 4.0 17.0 107.0   2.0         15.0   198.0 181.0             233     63   379 234 4 17 107   2         15   198 181         233   63   379
2323996 WI Columbia   school 5508190 3150 Public school Lodi 550819000904 40 Lodi Elementary   Regular School No Elementary 03 05 2020   pk_12_total 215.0 1.0 11.0     7.0         3.0   123.0 114.0             59     35   237 215 1 11     7         3   123 114         59   35   237
2324015 WI Columbia   school 5508190 3150 Public school Lodi 550819002915 110 Ouisconsing School of Collaboration charter Regular School Yes Elementary 03 05 2020   pk_12_total 73.0   4.0               3.0   47.0 33.0             11     20   80 73   4               3   47 33         11   20   80
2324090 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834000916 100 Luxemburg-Casco Intermediate   Regular School No Elementary 03 06 2020   pk_12_total 490.0 3.0 42.0     2.0         11.0   262.0 286.0             99     70   548 490 3 42     2         11   262 286         99   70   548
2324287 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000948 525 Marquette Elementary   Regular School No Elementary 03 05 2020   pk_12_total 99.0 36.0 19.0 3.0   3.0         24.0   89.0 95.0             71     35   184 99 36 19 3   3         24   89 95         71   35   184
2324349 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000954 645 Randall Elementary   Regular School No Elementary 03 05 2020   pk_12_total 242.0 32.0 33.0     23.0         31.0   181.0 180.0             95     32   361 242 32 33     23         31   181 180         95   32   361
2324638 WI Dane   school 5508790 3332 Public school Marshall 550879001012 20 Marshall Elementary   Regular School No Elementary 03 06 2020   pk_12_total 164.0 14.0 64.0 2.0   4.0         15.0   124.0 139.0             124     32   263 164 14 64 2   4         15   124 139         124   32   263
2324717 WI Juneau   school 5508850 3360 Public school Mauston 550885002574 100 Grayside Elementary   Regular School No Elementary 03 05 2020   pk_12_total 205.0 4.0 23.0 1.0   3.0         10.0   131.0 115.0             150     27   246 205 4 23 1   3         10   131 115         150   27   246
2324766 WI Dodge   school 5508880 3367 Public school Mayville 550888001029 60 Mayville Middle   Regular School No Middle 03 08 2020   pk_12_total 376.0 4.0 28.0     7.0         14.0   230.0 199.0             168     46   429 376 4 28     7         14   230 199         168   46   429
2324804 WI Dane   school 5508910 3381 Public school McFarland 550891002172 40 Waubesa Intermediate   Regular School No Elementary 03 05 2020   pk_12_total 450.0 6.0 21.0 1.0   13.0         34.0   288.0 237.0             78     64   525 450 6 21 1   13         34   288 237         78   64   525

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