enrollments

Data source: Big Local News · About: Big Local

569 rows where grade = "grade_9", state = "WI" and year = 2020 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 569 ✖

grade ✖

  • grade_9 · 569 ✖
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
2318364 2318364 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes High 07 12 2020   grade_9                                                   1                                             1
2318692 2318692 WI Ashland   school   170 Public Schools-Multidistrict Charters Ashland   9100 Rural Virtual Academy             2020   grade_9                                                   1                                             1
2318765 2318765 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2020   grade_9                                                   1                                             1
2319161 2319161 WI Rock   school   422 Public Schools-Multidistrict Charters Beloit Turner   9803 JEDI Virtual K-12 charter           2020   grade_9                                                   1                                             1
2319544 2319544 WI Racine   school   777 Public Schools-Multidistrict Charters Burlington Area   9803 JEDI Virtual K-12 charter           2020   grade_9                                                   1                                             1
2319613 2319613 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2020   grade_9                                                   1                                             1
2320303 2320303 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2020   grade_9                                                   1                                             1
2321804 2321804 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2020   grade_9                                                   1                                             1
2322876 2322876 WI Rock   school 5507020 2695 Public school Janesville 550702001698 400 Rock River Charter School charter Regular School Yes High 06 12 2020   grade_9                                                   1                                             1
2322927 2322927 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2020   grade_9                                                   1                                             1
2322941 2322941 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2020   grade_9                                                   1                                             1
2323492 2323492 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002554 405 Kiel eSchool charter Regular School Yes High 07 12 2020   grade_9                                                   1                                             1
2323827 2323827 WI Chippewa   school   2891 Public Schools-Multidistrict Charters Lake Holcombe   9419 eSucceed Charter School charter           2020   grade_9                                                   1                                             1
2324222 2324222 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852003349 460 Innovative & Alternative High   Alternative School No High 09 12 2020   grade_9                                                   1                                             1
2326510 2326510 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003057 442 South Accelerated Academy   Alternative School No High 09 12 2020   grade_9                                                   1                                             1
2327270 2327270 WI Chippewa   school   3920 Public Schools-Multidistrict Charters New Auburn   9419 eSucceed Charter School charter           2020   grade_9                                                   1                                             1
2327909 2327909 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092003060 800 Northeast Wisconsin Learning Academy   Alternative School No High 05 12 2020   grade_9                                                   1                                             1
2328453 2328453 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2020   grade_9                                                   1                                             1
2329386 2329386 WI Pierce   school 5513050 4893 Public school River Falls 551305001910 410 Renaissance Charter Academy charter Regular School Yes High 09 12 2020   grade_9                                                   1                                             1
2330599 2330599 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2020   grade_9                                                   1                                             1
2331423 2331423 WI Jefferson   school   6118 Public Schools-Multidistrict Charters Waterloo   9803 JEDI Virtual K-12 charter           2020   grade_9                                                   1                                             1
2332163 2332163 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002490 490 James E Dottke Alternative School   Alternative School No High 09 12 2020   grade_9                                                   1                                             1
2332219 2332219 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002918 410 Shared Journeys charter Alternative School Yes High 07 12 2020   grade_9                                                   1                                             1
2318619 2318619 WI Trempealeau   school 5500420 154 Public school Arcadia 550042000068 40 Arcadia High   Regular School No High 09 12 2020   grade_9                                                   100                                             100
2320639 2320639 WI Milwaukee   school 5500066 8127 Non District Charter Schools Dr Howard Fuller Collegiate Academy 550006602865 400 Dr Howard Fuller Collegiate Academy charter Regular School Yes High 09 12 2020   grade_9                                                   100                                             100
2323211 2323211 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001462 480 Lakeview Technology Academy   Career and Technical School No High 09 12 2020   grade_9                                                   100                                             100
2324530 2324530 WI Douglas   school 5508640 3297 Public school Maple 550864000987 160 Northwestern High   Regular School No High 09 12 2020   grade_9                                                   100                                             100
2329448 2329448 WI Sauk   school 5514250 5523 Public school River Valley 551425001855 110 River Valley High   Regular School No High 09 12 2020   grade_9                                                   100                                             100
2323869 2323869 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771000887 40 Lake Mills High   Regular School No High 09 12 2020   grade_9                                                   103                                             103
2325470 2325470 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002755 407 Carmen High School of Science and Technology South Campus charter Regular School Yes High 09 12 2020   grade_9                                                   103                                             103
2326712 2326712 WI Milwaukee   school 5500042 8106 Non District Charter Schools Milwaukee Academy of Science 550004202234 1251 Milwaukee Academy of Science charter Regular School Yes Other PK 12 2020   grade_9                                                   103                                             103
2319283 2319283 WI Jackson   school 5501260 476 Public school Black River Falls 550126000175 40 Black River Falls High   Regular School No High 09 12 2020   grade_9                                                   105                                             105
2330407 2330407 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001867 80 Stanley-Boyd High   Regular School No High 09 12 2020   grade_9                                                   105                                             105
2329032 2329032 WI Racine   school 5512360 4620 Public school Racine Unified 551236001644 499 Walden III High   Alternative School No High 06 12 2020   grade_9                                                   106                                             106
2329619 2329619 WI Milwaukee   school 5513260 5026 Public school Saint Francis 551326001748 40 Saint Francis High   Regular School No High 09 12 2020   grade_9                                                   106                                             106
2320027 2320027 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000302 40 Clintonville High   Regular School No High 09 12 2020   grade_9                                                   108                                             108
2321511 2321511 WI Trempealeau   school 5504960 2009 Public school Galesville-Ettrick-Trempealeau 550496000536 40 Galesville-Ettrick-Trempealeau High   Regular School No High 09 12 2020   grade_9                                                   108                                             108
2325338 2325338 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002782 434 Audubon Technology and Communication High   Regular School No High 09 12 2020   grade_9                                                   108                                             108
2325835 2325835 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong American Peace Academy K3-12 charter Regular School Yes Other PK 12 2020   grade_9                                                   108                                             108
2327656 2327656 WI Vilas   school 5503860 1526 Public school Northland Pines 550386000406 90 Northland Pines High   Regular School No High 09 12 2020   grade_9                                                   108                                             108
2328746 2328746 WI Pierce   school 5512240 4578 Public school Prescott 551224001592 60 Prescott High   Regular School No High 09 12 2020   grade_9                                                   108                                             108
2332909 2332909 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002229 40 Wrightstown High   Regular School No High 09 12 2020   grade_9                                                   108                                             108
2318444 2318444 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002724 450 Fox Cities Leadership Academy charter Regular School Yes High 09 12 2020   grade_9                                                   11                                             11
2318669 2318669 WI Ashland   school 5500510 170 Public school Ashland 550051003017 400 Lake Superior High charter Regular School Yes High 09 12 2020   grade_9                                                   11                                             11
2320319 2320319 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 2020   grade_9                                                   11                                             11
2322790 2322790 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_9                                                   11                                             11
2326243 2326243 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001306 315 Milwaukee County Youth Education Center   Alternative School No High 06 12 2020   grade_9                                                   11                                             11
2329354 2329354 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302003102 800 Odyssey Academy of Virtual Learning charter Regular School Yes Other PK 12 2020   grade_9                                                   11                                             11
2331278 2331278 WI Vernon   school 5515360 5985 Public school Viroqua Area 551536001936 410 Laurel High charter Regular School Yes High 09 12 2020   grade_9                                                   11                                             11
2323146 2323146 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002754 490 Harborside Academy charter Regular School Yes High 06 12 2020   grade_9                                                   110                                             110
2319221 2319221 WI Walworth   school 5515480 6013 Public school Big Foot UHS 551548001982 20 Big Foot High   Regular School No High 09 12 2020   grade_9                                                   111                                             111
2329283 2329283 WI Richland   school 5512960 4851 Public school Richland 551296001707 320 Richland Center High   Regular School No High 09 12 2020   grade_9                                                   111                                             111
2329570 2329570 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606000672 60 Saint Croix Central High   Regular School No High 09 12 2020   grade_9                                                   111                                             111
2324743 2324743 WI Juneau   school 5508850 3360 Public school Mauston 550885001025 60 Mauston High   Regular School No High 09 12 2020   grade_9                                                   112                                             112
2319203 2319203 WI Green Lake   school 5501140 434 Public school Berlin Area 550114000162 40 Berlin High   Regular School No High 09 12 2020   grade_9                                                   113                                             113
2319327 2319327 WI Chippewa   school 5501350 497 Public school Bloomer 550135000184 40 Bloomer High   Regular School No High 09 12 2020   grade_9                                                   114                                             114
2318164 2318164 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000005 40 Adams-Friendship High   Regular School No High 09 12 2020   grade_9                                                   115                                             115
2327553 2327553 WI Fond du Lac   school 5510740 3983 Public school North Fond du Lac 551074001399 60 Horace Mann High   Regular School No High 09 12 2020   grade_9                                                   115                                             115
2327896 2327896 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001435 200 Oconto Falls High   Regular School No High 09 12 2020   grade_9                                                   115                                             115
2330165 2330165 WI Saint Croix   school 5514010 5432 Public school Somerset 551401001825 40 Somerset High   Regular School No High 09 12 2020   grade_9                                                   115                                             115
2324004 2324004 WI Columbia   school 5508190 3150 Public school Lodi 550819000905 80 Lodi High   Regular School No High 09 12 2020   grade_9                                                   116                                             116
2329971 2329971 WI Sheboygan   school 5513680 5278 Public school Sheboygan Falls 551368001802 40 Sheboygan Falls High   Regular School No High 09 12 2020   grade_9                                                   116                                             116
2326259 2326259 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003036 885 Milwaukee Excellence Charter School charter Regular School Yes Middle 06 09 2020   grade_9                                                   117                                             117
2320131 2320131 WI Columbia   school 5502820 1183 Public school Columbus 550282000318 40 Columbus High   Regular School No High 09 12 2020   grade_9                                                   119                                             119
2320971 2320971 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2020   grade_9                                                   12                                             12
2321652 2321652 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000574 60 Gilmanton High   Regular School No High 09 12 2020   grade_9                                                   12                                             12
2324376 2324376 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002265 400 Shabazz-City High   Alternative School No High 09 12 2020   grade_9                                                   12                                             12
2325095 2325095 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2020   grade_9                                                   12                                             12
2325333 2325333 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2020   grade_9                                                   12                                             12
2331455 2331455 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575002981 430 Endeavor Charter School charter Regular School Yes High 09 12 2020   grade_9                                                   12                                             12
2331788 2331788 WI Marathon   school 5515900 6223 Public school Wausau 551590002747 400 Enrich Excel Achieve Learning Academy charter Alternative School Yes High 06 12 2020   grade_9                                                   12                                             12
2326951 2326951 WI Marathon   school 5509960 3787 Public school Mosinee 550996001308 100 Mosinee High   Regular School No High 09 12 2020   grade_9                                                   121                                             121
2319487 2319487 WI Milwaukee   school 5501800 721 Public school Brown Deer 550180000230 40 Brown Deer Middle/High   Regular School No High 06 12 2020   grade_9                                                   122                                             122
2322334 2322334 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627000690 40 Hayward High   Regular School No High 09 12 2020   grade_9                                                   122                                             122
2318286 2318286 WI Polk   school 5500300 119 Public school Amery 550030000030 40 Amery High   Regular School No High 09 12 2020   grade_9                                                   125                                             125
2318796 2318796 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000094 40 Baldwin-Woodville High   Regular School No High 09 12 2020   grade_9                                                   125                                             125
2320867 2320867 WI Rock   school 5504110 1568 Public school Edgerton 550411000443 80 Edgerton High   Regular School No High 09 12 2020   grade_9                                                   125                                             125
2326375 2326375 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002730 419 North Division High 0419   Regular School No High 09 12 2020   grade_9                                                   126                                             126
2319176 2319176 WI Rock   school 5501080 422 Public school Beloit Turner 550108000156 20 Turner High   Regular School No High 09 12 2020   grade_9                                                   127                                             127
2324089 2324089 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834000918 140 Luxemburg-Casco High   Regular School No High 09 12 2020   grade_9                                                   128                                             128
2318274 2318274 WI Eau Claire   school 5500270 112 Public school Altoona 550027000026 40 Altoona High   Regular School No High 09 12 2020   grade_9                                                   129                                             129
2320563 2320563 WI Brown   school 5503660 1407 Public school Denmark 550366000388 80 Denmark High   Regular School No High 09 12 2020   grade_9                                                   129                                             129
2328458 2328458 WI Grant   school 5511850 4389 Public school Platteville 551185001553 60 Platteville High   Regular School No High 09 12 2020   grade_9                                                   129                                             129
2318791 2318791 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2020   grade_9                                                   13                                             13
2322896 2322896 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 2020   grade_9                                                   13                                             13
2323909 2323909 WI Forest   school 5507830 2940 Public school Laona 550783000893 20 Laona High   Regular School No High 07 12 2020   grade_9                                                   13                                             13
2329365 2329365 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302001718 120 Ripon High   Regular School No High 09 12 2020   grade_9                                                   130                                             130
2332655 2332655 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002191 60 Winneconne High   Regular School No High 09 12 2020   grade_9                                                   132                                             132
2321018 2321018 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000464 40 Ellsworth High   Regular School No High 09 12 2020   grade_9                                                   133                                             133
2321122 2321122 WI Rock   school 5504440 1694 Public school Evansville Community 550444000478 40 Evansville High   Regular School No High 09 12 2020   grade_9                                                   133                                             133
2331144 2331144 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512001962 80 Two Rivers High   Regular School No High 09 12 2020   grade_9                                                   133                                             133
2326393 2326393 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002993 840 Obama School of Career and Technical Education   Regular School No Other PK 12 2020   grade_9                                                   136                                             136
2323449 2323449 WI Washington   school 5507380 2800 Public school Kewaskum 550738000837 80 Kewaskum High   Regular School No High 09 12 2020   grade_9                                                   138                                             138
2319590 2319590 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2020   grade_9                                                   14                                             14
2330535 2330535 WI Calumet   school 5514520 5614 Public school Stockbridge 551452001883 40 Stockbridge High   Regular School No High 09 12 2020   grade_9                                                   14                                             14
2330900 2330900 WI Shawano   school 5514880 5740 Public school Tigerton 551488001932 40 Tigerton High   Regular School No High 06 12 2020   grade_9                                                   14                                             14
2332062 2332062 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002921 430 Wauwatosa Virtual Academy charter Regular School Yes High 06 12 2020   grade_9                                                   14                                             14
2320679 2320679 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000410 40 East Troy High   Regular School No High 09 12 2020   grade_9                                                   140                                             140
2331776 2331776 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002045 200 Waupun Area Senior High   Regular School No High 09 12 2020   grade_9                                                   140                                             140
2322946 2322946 WI Jefferson   school 5507050 2702 Public school Jefferson 550705000778 80 Jefferson High   Regular School No High 09 12 2020   grade_9                                                   142                                             142

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