enrollments

Data source: Big Local News · About: Big Local

3,931 rows where grade = "grade_9" and state = "WI" sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 3,931 ✖
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 ▼
111966 111966 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2015   grade_9                                                   1                                             1
112595 112595 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096002815 850 Don Smith Learning Academy   Alternative Education School No 4.0 06 12 2015   grade_9                                                   1                                             1
116472 116472 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative Education School No 4.0 04 12 2015   grade_9                                                   1                                             1
116485 116485 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2015   grade_9                                                   1                                             1
117733 117733 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852003349 460 Innovative & Alternative High   Alternative Education School No 3.0 09 12 2015   grade_9                                                   1                                             1
118245 118245 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2015   grade_9                                                   1                                             1
120402 120402 WI Dane   school 5509810 3675 Public school Monona Grove 550981002828 450 Monona Grove Liberal Arts Charter School for the 21st Century charter Regular School Yes 3.0 09 12 2015   grade_9                                                   1                                             1
120482 120482 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes 4.0 KG 12 2015   grade_9                                                   1                                             1
122840 122840 WI Richland   school 5512960 4851 Public school Richland 551296002998 450 Richland Online Academy charter Regular School Yes 4.0 06 12 2015   grade_9                                                   1                                             1
123060 123060 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310002970 400 Cirrus Charter High charter Regular School Yes 3.0 09 12 2015   grade_9                                                   1                                             1
123132 123132 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606002989 850 Saint Croix Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2015   grade_9                                                   1                                             1
123879 123879 WI Marathon   school   5467 Public Schools-Multidistrict Charters Spencer   9100 Rural Virtual Academy charter           2015   grade_9                                                   1                                             1
124223 124223 WI Dane   school   5656 Public Schools-Multidistrict Charters Sun Prairie Area   9803 JEDI Virtual K-12 charter           2015   grade_9                                                   1                                             1
124240 124240 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002625 410 Prairie Phoenix Academy   Alternative Education School No 4.0 06 12 2015   grade_9                                                   1                                             1
124526 124526 WI Portage   school 5500330 126 Public school Tomorrow River 550033002984 850 Central Wisconsin Virtual School charter Regular School Yes 4.0 06 12 2015   grade_9                                                   1                                             1
125022 125022 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002502 490 Harvey Philip Alternative Charter School charter Alternative Education School Yes 3.0 09 12 2015   grade_9                                                   1                                             1
125290 125290 WI Marathon   school 5515900 6223 Public school Wausau 551590002054 200 John Muir Middle   Regular School No 2.0 06 09 2015   grade_9                                                   1                                             1
125757 125757 WI Washington   school 5516290 6307 Public school West Bend 551629002666 400 Washington Street School   Alternative Education School No 4.0 06 12 2015   grade_9                                                   1                                             1
281942 281942 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2016   grade_9                                                   1                                             1
281980 281980 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002549 440 Appleton eSchool charter Regular School Yes 3.0 07 12 2016   grade_9                                                   1                                             1
282573 282573 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096002815 850 Don Smith Learning Academy   Alternative Education School No 4.0 06 12 2016   grade_9                                                   1                                             1
282861 282861 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes 4.0 PK 12 2016   grade_9                                                   1                                             1
284368 284368 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002658 800 Second Avenue School   Alternative Education School No 4.0 04 12 2016   grade_9                                                   1                                             1
284514 284514 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes 4.0 PK 12 2016   grade_9                                                   1                                             1
284610 284610 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000221 160 Fairview South   Special Education School No 4.0 02 12 2016   grade_9                                                   1                                             1
285388 285388 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative Education School No 4.0 PK 12 2016   grade_9                                                   1                                             1
286490 286490 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2016   grade_9                                                   1                                             1
287818 287818 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative Education School No 4.0 04 12 2016   grade_9                                                   1                                             1
290485 290485 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2016   grade_9                                                   1                                             1
291376 291376 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095002736 410 New Path charter Alternative Education School Yes 4.0 06 12 2016   grade_9                                                   1                                             1
292149 292149 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_9                                                   1                                             1
292718 292718 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2016   grade_9                                                   1                                             1
292803 292803 WI Richland   school 5512960 4851 Public school Richland 551296002998 450 Richland Online Academy charter Regular School Yes 4.0 06 12 2016   grade_9                                                   1                                             1
293088 293088 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606002989 850 Saint Croix Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_9                                                   1                                             1
293550 293550 WI Milwaukee   school 5513800 5355 Public school Shorewood 551380002623 400 New Horizons for Learning charter Alternative Education School Yes 3.0 09 12 2016   grade_9                                                   1                                             1
293931 293931 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001125 320 Juvenile Detention   Alternative Education School No 4.0 KG 12 2016   grade_9                                                   1                                             1
294044 294044 WI Dane   school   5621 Public Schools-Multidistrict Charters Stoughton Area   9803 JEDI Virtual K-12 charter           2016   grade_9                                                   1                                             1
294156 294156 WI Dane   school   5656 Public Schools-Multidistrict Charters Sun Prairie Area   9803 JEDI Virtual K-12 charter           2016   grade_9                                                   1                                             1
295291 295291 WI Marathon   school 5515900 6223 Public school Wausau 551590003027 800 Wausau Area Virtual Education   Regular School No 4.0 06 12 2016   grade_9                                                   1                                             1
295625 295625 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002490 490 West Allis-West Milwaukee Learning Center   Alternative Education School No 3.0 09 12 2016   grade_9                                                   1                                             1
325890 325890 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003021 820 Appleview   Special Education School No Other PK 12 2017   grade_9                                                   1                                             1
326260 326260 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2017   grade_9                                                   1                                             1
326735 326735 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2017   grade_9                                                   1                                             1
327944 327944 WI Vernon   school 5503240 1421 Public school De Soto Area 550324003022 810 De Soto Virtual School charter Regular School Yes Other KG 12 2017   grade_9                                                   1                                             1
330246 330246 WI Rock   school 5507020 2695 Public school Janesville 550702000763 140 Jackson Elementary   Regular School No Elementary PK 05 2017   grade_9                                                   1                                             1
330307 330307 WI Rock   school 5507020 2695 Public school Janesville 550702001698 400 Rock River Charter School charter Regular School Yes Other 06 12 2017   grade_9                                                   1                                             1
331758 331758 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002435 710 Sherman Middle   Regular School No Middle 06 08 2017   grade_9                                                   1                                             1
331851 331851 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000976 140 Lincoln High   Regular School No High 10 12 2017   grade_9                                                   1                                             1
334357 334357 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2017   grade_9                                                   1                                             1
336605 336605 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2017   grade_9                                                   1                                             1
336692 336692 WI Richland   school 5512960 4851 Public school Richland 551296002998 450 Richland Online Academy charter Regular School Yes Other 06 12 2017   grade_9                                                   1                                             1
336902 336902 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310002970 400 Cirrus Charter High charter Regular School Yes High 09 12 2017   grade_9                                                   1                                             1
336967 336967 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606002989 850 Saint Croix Academy of Virtual Education charter Regular School Yes Other KG 12 2017   grade_9                                                   1                                             1
337439 337439 WI Milwaukee   school 5513800 5355 Public school Shorewood 551380002623 400 New Horizons for Learning charter Alternative School Yes High 09 12 2017   grade_9                                                   1                                             1
338400 338400 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes Other PK 12 2017   grade_9                                                   1                                             1
339217 339217 WI Marathon   school 5515900 6223 Public school Wausau 551590003027 800 Wausau Area Virtual Education   Regular School No Other 06 12 2017   grade_9                                                   1                                             1
339620 339620 WI Washington   school 5516290 6307 Public school West Bend 551629002666 400 Washington Street School   Alternative School No Other 06 12 2017   grade_9                                                   1                                             1
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
2334870 2334870 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2021   grade_9                                                   1                                             1
2335087 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 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 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 2335683 WI Rock   school   1568 Public Schools-Multidistrict Charters Edgerton   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   1                                             1
2335774 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 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 2337808 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   1                                             1
2337871 2337871 WI Green   school   2737 Public Schools-Multidistrict Charters Juda   405 Kiel eSchool charter           2021   grade_9                                                   1                                             1
2338727 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 2339618 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   1                                             1
2341120 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 2341732 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2021   grade_9                                                   1                                             1
2341844 2341844 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2021   grade_9                                                   1                                             1
2342267 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 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 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 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 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 2345141 WI Door   school   5457 Public Schools-Multidistrict Charters Southern Door County   9100 Rural Virtual Academy charter           2021   grade_9                                                   1                                             1

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