enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_9 · 3,831 ✖
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
114385 114385 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002658 800 Second Avenue School   Alternative Education School No 4.0 04 12 2015   grade_9                                                   4                                             4
115383 115383 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative Education School No 4.0 PK 12 2015   grade_9                                                   5                                             5
115429 115429 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative Education School No 4.0 PK 12 2015   grade_9                                                   7                                             7
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
116705 116705 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002317 280 Hillcrest School   Alternative Education School No 4.0 06 12 2015   grade_9                                                   8                                             8
116814 116814 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000822 450 Reuther Central High   Alternative Education School No 3.0 09 12 2015   grade_9                                                   49                                             49
117142 117142 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High School charter Alternative Education School Yes 4.0 09 10 2015   grade_9                                                   26                                             26
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
117822 117822 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative Education School No 4.0 04 12 2015   grade_9                                                   2                                             2
117891 117891 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002265 400 Shabazz-City High   Alternative Education School No 3.0 09 12 2015   grade_9                                                   4                                             4
118005 118005 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002701 400 McKinley Academy charter Alternative Education School Yes 3.0 09 12 2015   grade_9                                                   11                                             11
118796 118796 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002935 447 Achievement Center   Alternative Education School No 4.0 06 12 2015   grade_9                                                   24                                             24
118837 118837 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2015   grade_9                                                   34                                             34
118863 118863 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002707 432 Banner Preparatory School of Milwaukee   Alternative Education School No 3.0 09 12 2015   grade_9                                                   8                                             8
119282 119282 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002577 410 Grandview High   Alternative Education School No 3.0 09 12 2015   grade_9                                                   57                                             57
119324 119324 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000963 236 Groppi High   Alternative Education School No 4.0 06 12 2015   grade_9                                                   58                                             58
119578 119578 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002567 296 Lad Lake Synergy School   Alternative Education School No 4.0 06 12 2015   grade_9                                                   15                                             15
119582 119582 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000874 1078 Lad Lake Ultra   Alternative Education School No 4.0 06 12 2015   grade_9                                                   4                                             4
119755 119755 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001306 315 Milwaukee County Youth Education Center   Alternative Education School No 4.0 06 12 2015   grade_9                                                   6                                             6
119896 119896 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000843 1072 NOVA   Alternative Education School No 3.0 07 12 2015   grade_9                                                   37                                             37
119939 119939 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002686 865 Project Excel   Alternative Education School No 4.0 06 12 2015   grade_9                                                   4                                             4
119944 119944 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001007 458 Project STAY   Alternative Education School No 3.0 09 12 2015   grade_9                                                   22                                             22
120002 120002 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000856 1074 Shalom High   Alternative Education School No 3.0 09 12 2015   grade_9                                                   10                                             10
120051 120051 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002578 805 St Charles Intensive Day Treatment   Alternative Education School No 3.0 07 12 2015   grade_9                                                   5                                             5
120127 120127 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002760 433 Transition High   Alternative Education School No 3.0 09 12 2015   grade_9                                                   29                                             29
120947 120947 WI Waupaca   school 5510590 3955 Public school New London 551059002996 430 Catalyst Academy charter Alternative Education School Yes 3.0 07 12 2015   grade_9                                                   2                                             2
122551 122551 WI Racine   school 5512360 4620 Public school Racine Unified 551236001644 499 Walden III High   Alternative Education School No 3.0 09 12 2015   grade_9                                                   83                                             83
123594 123594 WI Milwaukee   school 5513800 5355 Public school Shorewood 551380002623 400 New Horizons for Learning charter Alternative Education School Yes 3.0 09 12 2015   grade_9                                                   2                                             2
123983 123983 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE charter Alternative Education School Yes 2.0 07 09 2015   grade_9                                                   11                                             11
123988 123988 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001116 310 Charles F Fernandez Center Alt Learning   Alternative Education School No 3.0 07 12 2015   grade_9                                                   3                                             3
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
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
125236 125236 WI Marathon   school 5515900 6223 Public school Wausau 551590002747 400 Enrich Excel Achieve Learning Academy charter Alternative Education School Yes 4.0 06 12 2015   grade_9                                                   10                                             10
125465 125465 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002349 190 Plank Road Complex   Alternative Education School No 4.0 KG 12 2015   grade_9                                                   56                                             56
125674 125674 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002918 410 Shared Journeys charter Alternative Education School Yes 3.0 07 12 2015   grade_9                                                   2                                             2
125688 125688 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 2015   grade_9                                                   8                                             8
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
126000 126000 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002901 9803 JEDI Virtual K-12 charter Alternative Education School Yes 4.0 KG 12 2015   grade_9                                                   4                                             4
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
282687 282687 WI Rock   school 5501050 413 Public school Beloit 550105002974 421 Beloit Learning Academy   Alternative Education School No 4.0 06 12 2016   grade_9                                                   11                                             11
283243 283243 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative Education School Yes 4.0 KG 12 2016   grade_9                                                   6                                             6
284312 284312 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000705 580 McKinley Charter School charter Alternative Education School Yes 4.0 06 12 2016   grade_9                                                   2                                             2
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
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
285434 285434 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative Education School No 4.0 PK 12 2016   grade_9                                                   3                                             3
286711 286711 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002317 280 Hillcrest School   Alternative Education School No 4.0 06 12 2016   grade_9                                                   6                                             6
286821 286821 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000822 450 Reuther Central High   Alternative Education School No 3.0 09 12 2016   grade_9                                                   58                                             58
287134 287134 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High School charter Alternative Education School Yes 4.0 09 11 2016   grade_9                                                   11                                             11
287729 287729 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852003349 460 Innovative & Alternative High   Alternative Education School No 3.0 09 12 2016   grade_9                                                   2                                             2
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
287887 287887 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002265 400 Shabazz-City High   Alternative Education School No 3.0 09 12 2016   grade_9                                                   2                                             2
287997 287997 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002701 400 McKinley Academy charter Alternative Education School Yes 3.0 09 12 2016   grade_9                                                   7                                             7
288829 288829 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA   Alternative Education School No 3.0 09 12 2016   grade_9                                                   34                                             34
288855 288855 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002707 432 Banner Preparatory School of Milwaukee   Alternative Education School No 3.0 09 12 2016   grade_9                                                   31                                             31
289266 289266 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002577 410 Grandview High   Alternative Education School No 3.0 09 12 2016   grade_9                                                   55                                             55
289307 289307 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000963 236 Groppi High   Alternative Education School No 4.0 06 12 2016   grade_9                                                   39                                             39
289553 289553 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002567 296 Lad Lake Synergy School   Alternative Education School No 4.0 06 12 2016   grade_9                                                   23                                             23
289725 289725 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001306 315 Milwaukee County Youth Education Center   Alternative Education School No 4.0 06 12 2016   grade_9                                                   8                                             8
289865 289865 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000843 1072 NOVA   Alternative Education School No 3.0 07 12 2016   grade_9                                                   40                                             40
289909 289909 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001007 458 Project STAY   Alternative Education School No 3.0 09 12 2016   grade_9                                                   26                                             26
289966 289966 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000856 1074 Shalom High   Alternative Education School No 3.0 09 12 2016   grade_9                                                   23                                             23
290082 290082 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002760 433 Transition High   Alternative Education School No 3.0 09 12 2016   grade_9                                                   31                                             31
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
292523 292523 WI Racine   school 5512360 4620 Public school Racine Unified 551236001644 499 Walden III High   Alternative Education School No 3.0 09 12 2016   grade_9                                                   76                                             76
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
293916 293916 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE charter Alternative Education School Yes 2.0 07 09 2016   grade_9                                                   13                                             13
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
295173 295173 WI Marathon   school 5515900 6223 Public school Wausau 551590002747 400 Enrich Excel Achieve Learning Academy charter Alternative Education School Yes 4.0 06 12 2016   grade_9                                                   12                                             12
295405 295405 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002349 190 Plank Road Complex   Alternative Education School No 4.0 KG 12 2016   grade_9                                                   33                                             33
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
296175 296175 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003365 430 River Cities High   Alternative Education School No 3.0 09 12 2016   grade_9                                                   5                                             5
326588 326588 WI Rock   school 5501050 413 Public school Beloit 550105002974 421 Beloit Learning Academy   Alternative School No Other 06 12 2017   grade_9                                                   5                                             5
327139 327139 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_9                                                   4                                             4
328211 328211 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000705 580 McKinley Charter School charter Alternative School Yes Other 06 12 2017   grade_9                                                   3                                             3
328269 328269 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002658 800 Second Avenue School   Alternative School No Other 04 12 2017   grade_9                                                   3                                             3
329260 329260 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2017   grade_9                                                   4                                             4
329308 329308 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other PK 12 2017   grade_9                                                   5                                             5
330357 330357 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2017   grade_9                                                   2                                             2
330590 330590 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002317 280 Hillcrest School   Alternative School No Other 06 12 2017   grade_9                                                   2                                             2
330701 330701 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000822 450 Reuther Central High   Alternative School No High 09 12 2017   grade_9                                                   49                                             49
331009 331009 WI La Crosse   school 5507530 2849 Public school La Crosse 550753002950 440 7 Rivers Community High School charter Alternative School Yes High 09 12 2017   grade_9                                                   11                                             11
331600 331600 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852003349 460 Innovative & Alternative High   Alternative School No High 09 12 2017   grade_9                                                   16                                             16
331753 331753 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002265 400 Shabazz-City High   Alternative School No High 09 12 2017   grade_9                                                   5                                             5
331863 331863 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002701 400 McKinley Academy charter Alternative School Yes High 09 12 2017   grade_9                                                   9                                             9
332700 332700 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000792 1063 ASSATA High   Alternative School No High 09 12 2017   grade_9                                                   30                                             30
332726 332726 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002707 432 Banner Preparatory School of Milwaukee   Alternative School No High 09 12 2017   grade_9                                                   17                                             17
333138 333138 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002577 410 Grandview High   Alternative School No High 09 12 2017   grade_9                                                   52                                             52
333177 333177 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000963 236 Groppi High   Alternative School No Other 06 12 2017   grade_9                                                   15                                             15
333424 333424 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002567 296 Lad Lake Synergy School   Alternative School No Other 06 12 2017   grade_9                                                   20                                             20
333622 333622 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001306 315 Milwaukee County Youth Education Center   Alternative School No Other 06 12 2017   grade_9                                                   15                                             15
333766 333766 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000843 1072 NOVA-Northwest Opportunities Vocational Academy   Alternative School No High 07 12 2017   grade_9                                                   21                                             21
333814 333814 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001007 458 Project STAY-Supporting Teachers and Youth   Alternative School No High 09 12 2017   grade_9                                                   43                                             43
333871 333871 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000856 1074 Shalom High   Alternative School No High 09 12 2017   grade_9                                                   25                                             25
333973 333973 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002760 433 Transition High   Alternative School No High 09 12 2017   grade_9                                                   18                                             18
335240 335240 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095002736 410 New Path charter Alternative School Yes Other 06 12 2017   grade_9                                                   3                                             3
336343 336343 WI Racine   school 5512360 4620 Public school Racine Unified 551236003045 801 Racine Alternative Learning   Alternative School No Other KG 12 2017   grade_9                                                   12                                             12
336409 336409 WI Racine   school 5512360 4620 Public school Racine Unified 551236001644 499 Walden III High   Alternative School No High 09 12 2017   grade_9                                                   76                                             76
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
337818 337818 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE Concerned About Reaching Everyone charter Alternative School Yes Other 07 09 2017   grade_9                                                   12                                             12
339097 339097 WI Marathon   school 5515900 6223 Public school Wausau 551590002747 400 Enrich Excel Achieve Learning Academy charter Alternative School Yes Other 06 12 2017   grade_9                                                   7                                             7

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