Data source: Big Local News · About: Big Local

604 rows where grade = "grade_12", state = "WI" and year = 2020 sorted by ccd_charter_school

View and edit SQL

year

  • 2020 · 504

grade

  • grade_12 · 504
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
2319990 WI Polk   school 5502610 1127 Public school Clear Lake 550261000292 40 Clear Lake High   Regular School No High 09 12 2020   grade_12                                                   47                                             47
2320016 WI Rock   school 5502640 1134 Public school Clinton Community 550264000296 60 Clinton High   Regular School No High 09 12 2020   grade_12                                                   85                                             85
2320026 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000302 40 Clintonville High   Regular School No High 09 12 2020   grade_12                                                   133                                             133
2320055 WI Buffalo   school 5502700 1155 Public school Cochrane-Fountain City 550270000307 40 Cochrane-Fountain City High   Regular School No High 07 12 2020   grade_12                                                   50                                             50
2320069 WI Clark   school 5502730 1162 Public school Colby 550273000309 40 Colby High   Regular School No High 09 12 2020   grade_12                                                   64                                             64
2320098 WI Marinette   school 5502760 1169 Public school Coleman 550276000314 60 Coleman High   Regular School No High 09 12 2020   grade_12                                                   61                                             61
2320117 WI Dunn   school 5502790 1176 Public school Colfax 550279000316 40 Colfax High   Regular School No High 07 12 2020   grade_12                                                   78                                             78
2320130 WI Columbia   school 5502820 1183 Public school Columbus 550282000318 40 Columbus High   Regular School No High 09 12 2020   grade_12                                                   92                                             92
2320157 WI Chippewa   school 5502880 1204 Public school Cornell 550288000324 40 Cornell High   Regular School No High 09 12 2020   grade_12                                                   27                                             27
2320175 WI Forest   school 5502910 1218 Public school Crandon 550291000327 60 Crandon High   Regular School No High 09 12 2020   grade_12                                                   58                                             58
2320194 WI Marinette   school 5502970 1232 Public school Crivitz 550297000330 40 Crivitz High   Regular School No High 09 12 2020   grade_12                                                   58                                             58
2320211 WI Grant   school 5503030 1246 Public school Cuba City 550303000333 40 Cuba City High   Regular School No High 09 12 2020   grade_12                                                   59                                             59
2320220 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000336 40 Cudahy High   Regular School No High 09 12 2020   grade_12                                                   200                                             200
2320280 WI Barron   school 5503090 1260 Public school Cumberland 550309000344 60 Cumberland High   Regular School No High 09 12 2020   grade_12                                                   65                                             65
2320311 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001734 35 D C Everest High   Regular School No High 10 12 2020   grade_12                                                   396                                             396
2320396 WI Lafayette   school 5503150 1295 Public school Darlington Community 550315000348 40 Darlington High   Regular School No High 09 12 2020   grade_12                                                   51                                             51
2320412 WI Dane   school 5503180 1316 Public school De Forest Area 550318000355 40 De Forest High   Regular School No High 09 12 2020   grade_12                                                   274                                             274
2320443 WI Brown   school 5503210 1414 Public school De Pere 550321000361 20 De Pere High   Regular School No High 09 12 2020   grade_12                                                   350                                             350
2320477 WI Vernon   school 5503240 1421 Public school De Soto Area 550324000365 40 De Soto High   Regular School No High 09 12 2020   grade_12                                                   26                                             26
2320518 WI Dane   school 5503270 1309 Public school Deerfield Community 550327000371 40 Deerfield High   Regular School No High 09 12 2020   grade_12                                                   40                                             40
2320529 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364000386 20 Delavan-Darien High   Regular School No High 09 12 2020   grade_12                                                   162                                             162
2320562 WI Brown   school 5503660 1407 Public school Denmark 550366000388 80 Denmark High   Regular School No High 09 12 2020   grade_12                                                   118                                             118
2320580 WI Dodge   school 5507260 2744 Public school Dodgeland 550726000787 22 Dodgeland High   Regular School No High 09 12 2020   grade_12                                                   68                                             68
2320598 WI Iowa   school 5503690 1428 Public school Dodgeville 550369000392 40 Dodgeville High   Regular School No High 09 12 2020   grade_12                                                   119                                             119
2320653 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000396 40 Drummond High   Regular School No High 09 12 2020   grade_12                                                   26                                             26
2320670 WI Pepin   school 5503840 1499 Public school Durand-Arkansaw 550384000136 40 Durand Middle/High   Regular School No High 06 12 2020   grade_12                                                   53                                             53
2320678 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000410 40 East Troy High   Regular School No High 09 12 2020   grade_12                                                   147                                             147
2320776 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000429 340 Memorial High   Regular School No High 09 12 2020   grade_12                                                   404                                             404
2320781 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000431 400 North High   Regular School No High 09 12 2020   grade_12                                                   371                                             371
2320822 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002658 800 Second Avenue School   Alternative School No Other 04 12 2020   grade_12                                                   2                                             2
2320848 WI Marathon   school 5504080 1561 Public school Edgar 550408000441 40 Edgar High   Regular School No High 09 12 2020   grade_12                                                   53                                             53
2320866 WI Rock   school 5504110 1568 Public school Edgerton 550411000443 80 Edgerton High   Regular School No High 09 12 2020   grade_12                                                   123                                             123
2320889 WI Langlade   school 5504170 1582 Public school Elcho 550417000448 40 Elcho High   Regular School No High 09 12 2020   grade_12                                                   23                                             23
2320909 WI Trempealeau   school 5504200 1600 Public school Eleva-Strum 550420000450 60 Eleva-Strum High   Regular School No High 09 12 2020   grade_12                                                   43                                             43
2320918 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000453 40 Elk Mound High   Regular School No High 09 12 2020   grade_12                                                   76                                             76
2320948 WI Sheboygan   school 5504260 1631 Public school Elkhart Lake-Glenbeulah 550426000456 40 Elkhart Lake High   Regular School No High 09 12 2020   grade_12                                                   38                                             38
2320953 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429000459 40 Elkhorn Area High   Regular School No High 09 12 2020   grade_12                                                   230                                             230
2321017 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000464 40 Ellsworth High   Regular School No High 09 12 2020   grade_12                                                   123                                             123
2321041 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000214 20 Central High   Regular School No High 09 12 2020   grade_12                                                   324                                             324
2321053 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000215 60 East High   Regular School No High 09 12 2020   grade_12                                                   305                                             305
2321058 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000221 160 Fairview South   Special Education School No High 05 12 2020   grade_12                                                   8                                             8
2321093 WI Pierce   school 5504350 1666 Public school Elmwood 550435000471 40 Elmwood High   Regular School No High 09 12 2020   grade_12                                                   25                                             25
2321121 WI Rock   school 5504440 1694 Public school Evansville Community 550444000478 40 Evansville High   Regular School No High 09 12 2020   grade_12                                                   143                                             143
2321152 WI Eau Claire   school 5504500 1729 Public school Fall Creek 550450000481 40 Fall Creek High   Regular School No High 09 12 2020   grade_12                                                   56                                             56
2321169 WI Columbia   school 5504530 1736 Public school Fall River 550453000484 40 Fall River High   Regular School No High 06 12 2020   grade_12                                                   40                                             40
2321186 WI Grant   school 5504590 1813 Public school Fennimore Community 550459000486 40 Fennimore High   Regular School No High 09 12 2020   grade_12                                                   71                                             71
2321204 WI Rusk   school 5514970 5757 Public school Flambeau 551497001951 40 Flambeau High   Regular School No High 09 12 2020   grade_12                                                   38                                             38
2321223 WI Florence   school 5504650 1855 Public school Florence County 550465000490 60 Florence High   Regular School No High 09 12 2020   grade_12                                                   29                                             29
2321252 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000498 140 Fond du Lac High   Regular School No High 09 12 2020   grade_12                                                   515                                             515
2321357 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474000510 80 Fort Atkinson High   Regular School No High 09 12 2020   grade_12                                                   241                                             241
2321424 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000522 60 Franklin High   Regular School No High 09 12 2020   grade_12                                                   357                                             357
2321428 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483002685 400 Milwaukee County Correctional Facility South   Alternative School No High 09 12 2020   grade_12                                                   31                                             31
2321459 WI Polk   school 5504860 1939 Public school Frederic 550486000526 40 Frederic 6-12 School   Regular School No High 06 12 2020   grade_12                                                   30                                             30
2321484 WI Outagamie   school 5504920 1953 Public school Freedom Area 550492000533 60 Freedom High   Regular School No High 09 12 2020   grade_12                                                   120                                             120
2321510 WI Trempealeau   school 5504960 2009 Public school Galesville-Ettrick-Trempealeau 550496000536 40 Galesville-Ettrick-Trempealeau High   Regular School No High 09 12 2020   grade_12                                                   100                                             100
2321566 WI Washington   school 5505160 2058 Public school Germantown 550516000557 180 Germantown High   Regular School No High 09 12 2020   grade_12                                                   335                                             335
2321600 WI Door   school 5505220 2114 Public school Gibraltar Area 550522000561 120 Gibraltar High   Regular School No High 09 12 2020   grade_12                                                   47                                             47
2321617 WI Oconto   school 5505250 2128 Public school Gillett 550525000564 20 Gillett High   Regular School No High 09 12 2020   grade_12                                                   34                                             34
2321637 WI Taylor   school 5505280 2135 Public school Gilman 550528000568 60 Gilman High   Regular School No High 07 12 2020   grade_12                                                   35                                             35
2321651 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000574 60 Gilmanton High   Regular School No High 09 12 2020   grade_12                                                   14                                             14
2321683 WI Saint Croix   school 5505520 2198 Public school Glenwood City 550552000587 80 Glenwood City High   Regular School No High 09 12 2020   grade_12                                                   55                                             55
2321692 WI Marinette   school 5505580 2212 Public school Goodman-Armstrong Creek 550558000592 40 Goodman High   Regular School No High 07 12 2020   grade_12                                                   5                                             5
2321708 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002248 40 Grafton High   Regular School No High 09 12 2020   grade_12                                                   185                                             185
2321744 WI Clark   school 5505640 2226 Public school Granton Area 550564000600 40 Granton High   Regular School No High 06 12 2020   grade_12                                                   16                                             16
2321756 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000602 80 Grantsburg High   Regular School No High 09 12 2020   grade_12                                                   68                                             68
2321800 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2020   grade_12                                                   15                                             15
2321845 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other KG 12 2020   grade_12                                                   14                                             14
2321857 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000618 180 East High   Regular School No High 09 12 2020   grade_12                                                   273                                             273
2322030 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000636 540 Preble High   Regular School No High 09 12 2020   grade_12                                                   511                                             511
2322047 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000638 600 Southwest High   Regular School No High 09 12 2020   grade_12                                                   293                                             293
2322089 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000644 720 West High   Regular School No High 09 12 2020   grade_12                                                   208                                             208
2322112 WI Green Lake   school 5505880 2310 Public school Green Lake 550588000647 40 Green Lake High   Regular School No High 07 12 2020   grade_12                                                   15                                             15
2322133 WI Milwaukee   school 5505910 2296 Public school Greendale 550591002254 60 Greendale High   Regular School No High 09 12 2020   grade_12                                                   226                                             226
2322177 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000653 120 Greenfield High   Regular School No High 09 12 2020   grade_12                                                   300                                             300
2322203 WI Clark   school 5505970 2394 Public school Greenwood 550597000657 60 Greenwood High   Regular School No High 07 12 2020   grade_12                                                   30                                             30
2322219 WI Shawano   school 5500056 2415 Public school Gresham 550005602740 400 Gresham High   Regular School No High 06 12 2020   grade_12                                                   26                                             26
2322227 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000664 40 Hamilton High   Regular School No High 09 12 2020   grade_12                                                   343                                             343
2322287 WI Washington   school 5506120 2436 Public school Hartford UHS 550612000677 20 Hartford High   Regular School No High 09 12 2020   grade_12                                                   327                                             327
2322333 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627000690 40 Hayward High   Regular School No High 09 12 2020   grade_12                                                   133                                             133
2322399 WI Calumet   school 5506450 2534 Public school Hilbert 550645000701 40 Hilbert High   Regular School No High 09 12 2020   grade_12                                                   43                                             43
2322418 WI Vernon   school 5506480 2541 Public school Hillsboro 550648000703 60 Hillsboro High   Regular School No High 06 12 2020   grade_12                                                   36                                             36
2322433 WI La Crosse   school 5506540 2562 Public school Holmen 550654000706 40 Holmen High   Regular School No High 09 12 2020   grade_12                                                   279                                             279
2322479 WI Dodge   school 5506570 2576 Public school Horicon 550657000712 60 Horicon High   Regular School No High 09 12 2020   grade_12                                                   63                                             63
2322523 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660000715 40 Hortonville High   Regular School No High 09 12 2020   grade_12                                                   271                                             271
2322549 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000716 20 Bay Port High   Regular School No High 09 12 2020   grade_12                                                   487                                             487
2322586 WI Sheboygan   school 5506660 2605 Public school Howards Grove 550666000721 60 Howards Grove High   Regular School No High 09 12 2020   grade_12                                                   70                                             70
2322613 WI Saint Croix   school 5506690 2611 Public school Hudson 550669000729 80 Hudson High   Regular School No High 09 12 2020   grade_12                                                   459                                             459
2322668 WI Iron   school 5506750 2618 Public school Hurley 550675000733 60 Hurley High   Regular School No High 06 12 2020   grade_12                                                   45                                             45
2322676 WI Dodge   school 5506780 2625 Public school Hustisford 550678000738 40 Hustisford High   Regular School No High 06 12 2020   grade_12                                                   37                                             37
2322702 WI Trempealeau   school 5506810 2632 Public school Independence 550681000740 40 Independence High   Regular School No High 09 12 2020   grade_12                                                   25                                             25
2322721 WI Waupaca   school 5506840 2639 Public school Iola-Scandinavia 550684000742 40 Iola-Scandinavia High   Regular School No High 07 12 2020   grade_12                                                   48                                             48
2322740 WI Iowa   school 5506870 2646 Public school Iowa-Grant 550687000745 40 Iowa-Grant High   Regular School No High 09 12 2020   grade_12                                                   46                                             46
2322766 WI Richland   school 5506960 2660 Public school Ithaca 550696000752 60 Ithaca High   Regular School No High 09 12 2020   grade_12                                                   32                                             32
2322794 WI Rock   school 5507020 2695 Public school Janesville 550702000757 60 Craig High   Regular School No High 09 12 2020   grade_12                                                   381                                             381
2322868 WI Rock   school 5507020 2695 Public school Janesville 550702000770 280 Parker High   Regular School No High 09 12 2020   grade_12                                                   300                                             300
2322926 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2020   grade_12                                                   3                                             3
2322945 WI Jefferson   school 5507050 2702 Public school Jefferson 550705000778 80 Jefferson High   Regular School No High 09 12 2020   grade_12                                                   179                                             179
2322978 WI Jefferson   school 5507170 2730 Public school Johnson Creek 550717000783 40 Johnson Creek Middle and High   Regular School No High 05 12 2020   grade_12                                                   50                                             50
2322999 WI Green   school 5507230 2737 Public school Juda 550723000785 40 Juda High   Regular School No High 09 12 2020   grade_12                                                   37                                             37
2323014 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000793 40 Kaukauna High   Regular School No High 09 12 2020   grade_12                                                   307                                             307

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