Data source: Big Local News · About: Big Local

586 rows where grade = "grade_9", state = "WI" and year = 2021 sorted by total_int

View and edit SQL

year

  • 2021 · 586

grade

  • grade_9 · 586
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 ▼
2334870 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2021   grade_9                                                   1                                             1
2335087 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Career and Technical School Yes High 07 12 2021   grade_9                                                   1                                             1
2335525 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405003115 810 Eau Claire Virtual School charter Regular School Yes Other 04 12 2021   grade_9                                                   1                                             1
2335624 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002658 800 Second Avenue School   Alternative School No Other 04 12 2021   grade_9                                                   1                                             1
2335683 WI Rock   school   1568 Public Schools-Multidistrict Charters Edgerton   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   1                                             1
2335774 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429002520 9401 Career and College Academy charter Regular School Yes High 09 12 2021   grade_9                                                   1                                             1
2337739 WI Rock   school 5507020 2695 Public school Janesville 550702001698 400 Rock River Charter School charter Regular School Yes High 06 12 2021   grade_9                                                   1                                             1
2337808 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   1                                             1
2337871 WI Green   school   2737 Public Schools-Multidistrict Charters Juda   405 Kiel eSchool charter           2021   grade_9                                                   1                                             1
2338727 WI Jefferson   school   2898 Public Schools-Multidistrict Charters Lake Mills Area   9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter           2021   grade_9                                                   1                                             1
2339618 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   1                                             1
2341120 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001306 315 Milwaukee County Youth Education Center   Alternative School No High 06 12 2021   grade_9                                                   1                                             1
2341732 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   1                                             1
2341844 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2021   grade_9                                                   1                                             1
2342267 WI Waupaca   school 5510590 3955 Public school New London 551059002996 430 Catalyst Academy charter Alternative School Yes High 09 12 2021   grade_9                                                   1                                             1
2342372 WI Waukesha   school 5510710 3976 Public school Norris 551071001395 20 Norris Academy   Regular School No Other KG 12 2021   grade_9                                                   1                                             1
2344356 WI Grant   school 5510140 3850 Public school Riverdale 551014003084 430 Riverdale Academy   Alternative School No High 06 12 2021   grade_9                                                   1                                             1
2344931 WI Milwaukee   school 5513800 5355 Public school Shorewood 551380002623 400 New Horizons for Learning charter Alternative School Yes High 09 12 2021   grade_9                                                   1                                             1
2345040 WI Douglas   school 5513980 5397 Public school Solon Springs 551398003092 850 Eagles' Wings Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_9                                                   1                                             1
2345141 WI Door   school   5457 Public Schools-Multidistrict Charters Southern Door County   9100 Rural Virtual Academy charter           2021   grade_9                                                   1                                             1
2345343 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001125 320 Juvenile Detention   Alternative School No Other KG 12 2021   grade_9                                                   1                                             1
2345510 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2021   grade_9                                                   1                                             1
2345753 WI Clark   school   5726 Public Schools-Multidistrict Charters Thorp   9100 Rural Virtual Academy charter           2021   grade_9                                                   1                                             1
2346599 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002502 490 Waukesha East Alternative School charter Alternative School Yes High 06 12 2021   grade_9                                                   1                                             1
2347333 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9100 Rural Virtual Academy charter           2021   grade_9                                                   1                                             1
2333475 WI Ashland   school   170 Public Schools-Multidistrict Charters Ashland   9100 Rural Virtual Academy             2021   grade_9                                                   2                                             2
2334004 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2021   grade_9                                                   2                                             2
2334628 WI Price   school 5500058 1071 Public school Chequamegon 550005802780 450 Class ACT Charter charter Career and Technical School Yes High 09 12 2021   grade_9                                                   2                                             2
2339091 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852003349 460 Innovative & Alternative High   Alternative School No High 09 12 2021   grade_9                                                   2                                             2
2339177 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative School No Other 04 12 2021   grade_9                                                   2                                             2
2342380 WI Waukesha   school 5510710 3976 Public school Norris 551071003072 800 Norris Academy Virtual School charter Alternative School Yes Other KG 12 2021   grade_9                                                   2                                             2
2343344 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2021   grade_9                                                   2                                             2
2345212 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002542 410 Sparta High Point School charter Regular School Yes High 07 12 2021   grade_9                                                   2                                             2
2345592 WI Dane   school   5656 Public Schools-Multidistrict Charters Sun Prairie Area   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   2                                             2
2346364 WI Jefferson   school   6118 Public Schools-Multidistrict Charters Waterloo   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   2                                             2
2346566 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003070 800 Riverview School   Alternative School No High 06 12 2021   grade_9                                                   2                                             2
2333548 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_9                                                   3                                             3
2337183 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002867 250 Northern Waters Environmental School charter Regular School Yes High 06 12 2021   grade_9                                                   3                                             3
2338066 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002910 800 Kenosha eSchool K-12 charter Regular School Yes Other KG 12 2021   grade_9                                                   3                                             3
2339519 WI Dane   school 5508790 3332 Public school Marshall 550879002901 9803 JEDI Virtual K-12 charter Alternative School Yes Other PK 12 2021   grade_9                                                   3                                             3
2339594 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_9                                                   3                                             3
2340131 WI Dane   school 5500085 8145 Non District Charter Schools Milestone Democratic School 550008503136 8145 Milestone Democratic School charter Regular School Yes High 07 12 2021   grade_9                                                   3                                             3
2342545 WI Vilas   school 5503860 1526 Public school Northland Pines 550386003013 410 School of Options & Applied Research High charter Regular School Yes High 08 12 2021   grade_9                                                   3                                             3
2342584 WI Washburn   school 5509720 3654 Public school Northwood 550972003018 800 Northwood Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_9                                                   3                                             3
2344102 WI Oneida   school   4781 Public Schools-Multidistrict Charters Rhinelander   9100 Rural Virtual Academy charter           2021   grade_9                                                   3                                             3
2345998 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes Other PK 12 2021   grade_9                                                   3                                             3
2347280 WI Brown   school 5516320 6328 Public school West De Pere 551632002752 400 Phantom Knight School of Opportunity charter Regular School Yes High 07 12 2021   grade_9                                                   3                                             3
2347836 WI Sawyer   school 5500086 8146 Non District Charter Schools WOLI/Akii'gikinoo'amaading Environmental 550008603137 8146 WOLI/Akii'gikinoo'amaading Environmental School charter Regular School Yes High 06 12 2021   grade_9                                                   3                                             3
2334403 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_9                                                   4                                             4
2334958 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_9                                                   4                                             4
2335566 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000705 580 McKinley Charter School charter Alternative School Yes High 06 12 2021   grade_9                                                   4                                             4
2336466 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_9                                                   4                                             4
2336538 WI Marinette   school 5505580 2212 Public school Goodman-Armstrong Creek 550558000592 40 Goodman High   Regular School No High 07 12 2021   grade_9                                                   4                                             4
2337790 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2021   grade_9                                                   4                                             4
2338033 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002317 280 Hillcrest School   Alternative School No High 06 12 2021   grade_9                                                   4                                             4
2344190 WI Richland   school 5512960 4851 Public school Richland 551296002998 450 Richland Online Academy charter Regular School Yes High 06 12 2021   grade_9                                                   4                                             4
2345473 WI Dane   school   5621 Public Schools-Multidistrict Charters Stoughton Area   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   4                                             4
2347135 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002490 490 James E Dottke Alternative School   Alternative School No High 09 12 2021   grade_9                                                   4                                             4
2347867 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713003059 850 Wonewoc-Center Virtual Academy charter Regular School Yes Other KG 12 2021   grade_9                                                   4                                             4
2334442 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes High 07 12 2021   grade_9                                                   5                                             5
2334678 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_9                                                   5                                             5
2341773 WI Marquette   school 5509870 3689 Public school Montello 550987002821 420 High Marq Environmental Charter School charter Regular School Yes High 06 12 2021   grade_9                                                   5                                             5
2343570 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes Other KG 12 2021   grade_9                                                   5                                             5
2345864 WI Monroe   school   5747 Public Schools-Multidistrict Charters Tomah Area   9100 Rural Virtual Academy charter           2021   grade_9                                                   5                                             5
2335349 WI Brown   school 5503660 1407 Public school Denmark 550366002936 450 Denmark Community School charter Regular School Yes High 06 12 2021   grade_9                                                   6                                             6
2335928 WI Pierce   school 5504350 1666 Public school Elmwood 550435003121 800 Western Wisconsin Virtual Charter School (WWVC) charter Regular School Yes Other PK 12 2021   grade_9                                                   6                                             6
2338376 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002554 405 Kiel eSchool charter Regular School Yes High 07 12 2021   grade_9                                                   6                                             6
2339354 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002701 400 McKinley Academy charter Alternative School Yes High 09 12 2021   grade_9                                                   6                                             6
2341502 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003055 448 Vincent Accelerated Academy   Alternative School No High 09 12 2021   grade_9                                                   6                                             6
2341794 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_9                                                   6                                             6
2345415 WI Portage   school   5607 Public Schools-Multidistrict Charters Stevens Point Area Public   9100 Rural Virtual Academy charter           2021   grade_9                                                   6                                             6
2334043 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other KG 12 2021   grade_9                                                   7                                             7
2334459 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2021   grade_9                                                   7                                             7
2337611 WI Dane   school 5500082 8141 Non District Charter Schools Isthmus Montessori Academy Public 550008203085 8141 Isthmus Montessori Academy Public charter Regular School Yes Other PK 11 2021   grade_9                                                   7                                             7
2337759 WI Rock   school 5507020 2695 Public school Janesville 550702002691 430 TAGOS Leadership Academy-Tailoring Academics to Guide our Students charter Regular School Yes High 07 12 2021   grade_9                                                   7                                             7
2338755 WI Oneida   school 5509630 3647 Public school Lakeland UHS 550963003090 400 Lakeland STAR Academy--Strong Talented Adventurous Remarkable charter Regular School Yes High 09 12 2021   grade_9                                                   7                                             7
2339980 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2021   grade_9                                                   7                                             7
2347524 WI Walworth   school   6461 Public Schools-Multidistrict Charters Whitewater Unified   9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter           2021   grade_9                                                   7                                             7
2333860 WI Rock   school 5501050 413 Public school Beloit 550105002974 421 Beloit Learning Academy   Alternative School No High 06 12 2021   grade_9                                                   8                                             8
2343289 WI Vilas   school 5511710 4330 Public school Phelps 551171001540 20 Phelps High   Regular School No High 09 12 2021   grade_9                                                   8                                             8
2346410 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575002981 430 Endeavor Charter School charter Regular School Yes High 09 12 2021   grade_9                                                   8                                             8
2333377 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2021   grade_9                                                   9                                             9
2333873 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2021   grade_9                                                   9                                             9
2339246 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002265 400 Shabazz-City High   Alternative School No High 09 12 2021   grade_9                                                   9                                             9
2339615 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2021   grade_9                                                   9                                             9
2344702 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002879 450 Central High charter Regular School Yes High 09 12 2021   grade_9                                                   9                                             9
2346744 WI Marathon   school 5515900 6223 Public school Wausau 551590002747 400 Enrich Excel Achieve Learning Academy charter Alternative School Yes High 06 12 2021   grade_9                                                   9                                             9
2335100 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2021   grade_9                                                   10                                             10
2340937 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002567 296 Lad Lake Synergy School   Alternative School No High 06 12 2021   grade_9                                                   10                                             10
2341293 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001007 458 Project STAY-Supporting Teachers and Youth   Alternative School No High 09 12 2021   grade_9                                                   10                                             10
2346403 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_9                                                   10                                             10
2333158 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2021   grade_9                                                   11                                             11
2336495 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000574 60 Gilmanton High   Regular School No High 09 12 2021   grade_9                                                   11                                             11
2337335 WI Dodge   school   2576 Public Schools-Multidistrict Charters Horicon   405 Kiel eSchool charter           2021   grade_9                                                   11                                             11
2340704 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000963 236 Groppi High   Alternative School No High 09 12 2021   grade_9                                                   11                                             11
2345815 WI Shawano   school 5514880 5740 Public school Tigerton 551488001932 40 Tigerton High   Regular School No High 06 12 2021   grade_9                                                   11                                             11
2346057 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512003037 810 Lighthouse Learning Academy charter Regular School Yes Other PK 12 2021   grade_9                                                   11                                             11
2346202 WI Vernon   school 5515360 5985 Public school Viroqua Area 551536001936 410 Laurel High charter Regular School Yes High 09 12 2021   grade_9                                                   11                                             11
2333023 WI Buffalo   school 5500180 84 Public school Alma 550018000018 40 Alma High   Regular School No High 09 12 2021   grade_9                                                   12                                             12
2335116 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 2021   grade_9                                                   12                                             12

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