Data source: Big Local News · About: Big Local

4,704 rows where grade = "grade_7" and state = "WI" sorted by total

View and edit SQL

year

grade

  • grade_7 · 4,604
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
3075178 WI Shawano   school   623 Public Schools-Multidistrict Charters Bowler   9100 Rural Virtual Academy charter           2019   grade_7                                                   1                                             1
3075327 WI Racine   school   777 Public Schools-Multidistrict Charters Burlington Area   9803 JEDI Virtual K-12 charter           2019   grade_7                                                   1                                             1
3076076 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2019   grade_7                                                   1                                             1
3077683 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002857 445 John Dewey Academy of Learning charter Regular School Yes High 06 12 2019   grade_7                                                   1                                             1
3078676 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2019   grade_7                                                   1                                             1
3078942 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002910 800 Kenosha eSchool K-12 charter Regular School Yes Other KG 12 2019   grade_7                                                   1                                             1
3080458 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2019   grade_7                                                   1                                             1
3080906 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   grade_7                                                   1                                             1
3081144 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No High 09 12 2019   grade_7                                                   1                                             1
3082530 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969003083 9418 Lakeland STAR School--Strong Talented Adventurous Remarkable charter Regular School Yes Middle 07 08 2019   grade_7                                                   1                                             1
3082631 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2019   grade_7                                                   1                                             1
3082734 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2019   grade_7                                                   1                                             1
3086142 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE Concerned About Reaching Everyone charter Alternative School Yes Middle 07 09 2019   grade_7                                                   1                                             1
3086304 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2019   grade_7                                                   1                                             1
3086733 WI Portage   school 5500330 126 Public school Tomorrow River 550033003063 140 Tomorrow River Virtual Charter School (TRVCS) charter Regular School Yes Elementary PK 08 2019   grade_7                                                   1                                             1
3087314 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003070 800 Riverview School   Alternative School No High 06 12 2019   grade_7                                                   1                                             1
3088186 WI Langlade   school   6440 Public Schools-Multidistrict Charters White Lake   9100 Rural Virtual Academy charter           2019   grade_7                                                   1                                             1
3089770 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2018   grade_7                                                   1                                             1
3089944 WI Shawano   school   623 Public Schools-Multidistrict Charters Bowler   9100 Rural Virtual Academy charter           2018   grade_7                                                   1                                             1
3091005 WI Vernon   school 5503240 1421 Public school De Soto Area 550324003022 810 De Soto Virtual School charter Regular School Yes Other KG 12 2018   grade_7                                                   1                                             1
3091273 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000705 580 McKinley Charter School charter Alternative School Yes High 06 12 2018   grade_7                                                   1                                             1
3091642 WI Rock   school   1694 Public Schools-Multidistrict Charters Evansville Community   9803 JEDI Virtual K-12 charter           2018   grade_7                                                   1                                             1
3095171 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2018   grade_7                                                   1                                             1
3097870 WI Waupaca   school 5510590 3955 Public school New London 551059002943 410 Next Generation Academy charter Regular School Yes High 07 12 2018   grade_7                                                   1                                             1
3099164 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2018   grade_7                                                   1                                             1
3099672 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2018   grade_7                                                   1                                             1
3101030 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2018   grade_7                                                   1                                             1
3102296 WI Marathon   school 5515900 6223 Public school Wausau 551590003027 800 Wausau Area Virtual Education   Regular School No High 06 12 2018   grade_7                                                   1                                             1
3102409 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002349 190 Plank Road Complex   Alternative School No Other KG 12 2018   grade_7                                                   1                                             1
112777 WI Rock   school 5501050 413 Public school Beloit 550105002705 410 Roy Chapman Andrews Academy charter Regular School Yes 4.0 06 12 2015   grade_7                                                   10                                             10
113475 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2015   grade_7                                                   10                                             10
114212 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes 1.0 PK 08 2015   grade_7                                                   10                                             10
120049 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_7                                                   10                                             10
124417 WI Shawano   school 5514880 5740 Public school Tigerton 551488001932 40 Tigerton High   Regular School No 4.0 06 12 2015   grade_7                                                   10                                             10
125947 WI Langlade   school 5516590 6440 Public school White Lake 551659002165 40 White Lake High   Regular School No 3.0 07 12 2015   grade_7                                                   10                                             10
282195 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes 3.0 07 12 2016   grade_7                                                   10                                             10
287147 WI La Crosse   school 5507530 2849 Public school La Crosse 550753001463 140 Coulee Montessori Charter School charter Regular School Yes 1.0 PK 08 2016   grade_7                                                   10                                             10
287461 WI Walworth   school 5508040 3087 Public school Linn J4 550804000898 20 Traver Elementary   Regular School No 1.0 PK 08 2016   grade_7                                                   10                                             10
294785 WI Door   school 5515570 6069 Public school Washington 551557001986 20 Washington Island Elementary   Regular School No 1.0 PK 08 2016   grade_7                                                   10                                             10
295147 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002903 150 School for Agricultural and Environmental Studies charter Regular School Yes 1.0 PK 08 2016   grade_7                                                   10                                             10
328079 WI Racine   school 5503750 1449 Public school Dover #1 550375000394 20 Kansasville Elementary   Regular School No Elementary PK 08 2017   grade_7                                                   10                                             10
331022 WI La Crosse   school 5507530 2849 Public school La Crosse 550753001463 140 Coulee Montessori Charter School charter Regular School Yes Elementary PK 08 2017   grade_7                                                   10                                             10
331334 WI Walworth   school 5508040 3087 Public school Linn J4 550804000898 20 Traver Elementary   Regular School No Elementary PK 08 2017   grade_7                                                   10                                             10
335080 WI Racine   school 5510800 4011 Public school Norway J7 551080001405 20 Drought Elementary   Regular School No Elementary PK 08 2017   grade_7                                                   10                                             10
339812 WI Langlade   school 5516590 6440 Public school White Lake 551659002165 40 White Lake High   Regular School No High 07 12 2017   grade_7                                                   10                                             10
2319588 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2020   grade_7                                                   10                                             10
2322788 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_7                                                   10                                             10
2327098 WI Juneau   school 5510230 3871 Public school Necedah Area 551023003116 410 N-Gage Academy charter Regular School Yes High 06 12 2020   grade_7                                                   10                                             10
2329352 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_7                                                   10                                             10
2330432 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002210 360 CARE Concerned About Reaching Everyone charter Regular School Yes Middle 07 09 2020   grade_7                                                   10                                             10
2331380 WI Racine   school 5515700 6104 Public school Washington-Caldwell 551570001993 20 Washington Elementary   Regular School No Elementary PK 08 2020   grade_7                                                   10                                             10
2333679 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2021   grade_7                                                   10                                             10
2342549 WI Vilas   school 5503860 1526 Public school Northland Pines 550386002938 250 School of Options & Applied Research Middle charter Regular School Yes Middle 05 08 2021   grade_7                                                   10                                             10
2343280 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_7                                                   10                                             10
3076092 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 2019   grade_7                                                   10                                             10
3077417 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537002907 250 Gilmanton Middle   Regular School No Middle 05 08 2019   grade_7                                                   10                                             10
3080823 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2019   grade_7                                                   10                                             10
3083019 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2019   grade_7                                                   10                                             10
3094411 WI Walworth   school 5508040 3087 Public school Linn J4 550804000898 20 Traver Elementary   Regular School No Elementary PK 08 2018   grade_7                                                   10                                             10
3098836 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_7                                                   10                                             10
111888 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No 2.0 06 08 2015   grade_7                                                   100                                             100
114138 WI Brown   school 5503660 1407 Public school Denmark 550366000389 100 Denmark Middle   Regular School No 2.0 06 08 2015   grade_7                                                   100                                             100
118055 WI Douglas   school 5508640 3297 Public school Maple 550864000988 170 Northwestern Middle   Regular School No 2.0 06 08 2015   grade_7                                                   100                                             100
119699 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001164 176 Meir School   Regular School No 4.0 03 09 2015   grade_7                                                   100                                             100
123015 WI Sauk   school 5514250 5523 Public school River Valley 551425001856 100 River Valley Middle   Regular School No 2.0 06 08 2015   grade_7                                                   100                                             100
123149 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606000673 80 Saint Croix Central Middle   Regular School No 2.0 05 08 2015   grade_7                                                   100                                             100
283114 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes 1.0 PK 08 2016   grade_7                                                   100                                             100
333201 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong American Peace Academy K3-12 charter Regular School Yes Other PK 12 2017   grade_7                                                   100                                             100
338481 WI Racine   school 5515180 5859 Public school Union Grove J1 551518001964 20 Union Grove Elementary   Regular School No Elementary PK 08 2017   grade_7                                                   100                                             100
339250 WI Waushara   school 5515960 6237 Public school Wautoma Area 551596002071 30 Parkside School   Regular School No Elementary 04 08 2017   grade_7                                                   100                                             100
2319914 WI Calumet   school 5502520 1085 Public school Chilton 550252002430 30 Chilton Middle   Regular School No Middle 05 08 2020   grade_7                                                   100                                             100
2336219 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000517 20 Bayside Middle   Regular School No Middle 05 08 2021   grade_7                                                   100                                             100
2336344 WI Trempealeau   school 5504960 2009 Public school Galesville-Ettrick-Trempealeau 550496000537 50 Galesville-Ettrick-Trempealeau Middle   Regular School No Middle 06 08 2021   grade_7                                                   100                                             100
3087639 WI Waushara   school 5515960 6237 Public school Wautoma Area 551596002071 30 Parkside School   Regular School No Middle 04 08 2019   grade_7                                                   100                                             100
3092034 WI Trempealeau   school 5504960 2009 Public school Galesville-Ettrick-Trempealeau 550496000537 50 Galesville-Ettrick-Trempealeau Middle   Regular School No Middle 06 08 2018   grade_7                                                   100                                             100
3101403 WI Lincoln   school 5514940 5754 Public school Tomahawk 551494001948 220 Tomahawk Middle   Regular School No Middle 06 08 2018   grade_7                                                   100                                             100
335726 WI Marinette   school 5511610 4305 Public school Peshtigo 551161003026 200 Peshtigo Middle   Regular School No Middle 07 08 2017   grade_7                                                   101                                             101
2318623 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003041 290 Arcadia Middle   Regular School No Middle 05 08 2020   grade_7                                                   101                                             101
2329634 WI Kenosha   school 5513350 5068 Public school Salem 551335001753 20 Salem Elementary   Regular School No Elementary PK 08 2020   grade_7                                                   101                                             101
3079735 WI Columbia   school 5508190 3150 Public school Lodi 550819000906 100 Lodi Middle   Regular School No Middle 06 08 2019   grade_7                                                   101                                             101
3082239 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001238 59 Roosevelt Middle   Regular School No Middle 06 08 2019   grade_7                                                   101                                             101
3089168 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003041 290 Arcadia Middle   Regular School No Middle 05 08 2018   grade_7                                                   101                                             101
114184 WI Iowa   school 5503690 1428 Public school Dodgeville 550369000391 50 Dodgeville Middle   Regular School No 2.0 06 08 2015   grade_7                                                   102                                             102
121971 WI Grant   school 5511850 4389 Public school Platteville 551185001554 80 Platteville Middle   Regular School No 2.0 04 08 2015   grade_7                                                   102                                             102
122257 WI Pierce   school 5512240 4578 Public school Prescott 551224001593 80 Prescott Middle   Regular School No 2.0 06 08 2015   grade_7                                                   102                                             102
123195 WI Kenosha   school 5513350 5068 Public school Salem 551335001753 20 Salem Elementary   Regular School No 1.0 PK 08 2015   grade_7                                                   102                                             102
124632 WI Racine   school 5515180 5859 Public school Union Grove J1 551518001964 20 Union Grove Elementary   Regular School No 1.0 PK 08 2015   grade_7                                                   102                                             102
282675 WI Rock   school 5501050 413 Public school Beloit 550105000137 20 Aldrich Intermediate   Regular School No 2.0 04 08 2016   grade_7                                                   102                                             102
329763 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614001282 100 North Shore Middle   Regular School No Middle 06 08 2017   grade_7                                                   102                                             102
331065 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000863 180 Lincoln Middle   Regular School No Middle 06 08 2017   grade_7                                                   102                                             102
2329286 WI Richland   school 5512960 4851 Public school Richland 551296001708 280 Richland Middle   Regular School No Middle 06 08 2020   grade_7                                                   102                                             102
2338862 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000902 60 Little Chute Middle   Regular School No Middle 07 08 2021   grade_7                                                   102                                             102
3080256 WI Douglas   school 5508640 3297 Public school Maple 550864000988 170 Northwestern Middle   Regular School No Middle 06 08 2019   grade_7                                                   102                                             102
3086343 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461002322 80 Walker Middle   Regular School No Middle 06 08 2019   grade_7                                                   102                                             102
3090063 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2018   grade_7                                                   102                                             102
117047 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744000845 60 Kiel Middle   Regular School No 2.0 05 08 2015   grade_7                                                   103                                             103
121467 WI Winnebago   school 5510980 4088 Public school Omro 551098001443 80 Omro Middle   Regular School No 2.0 06 08 2015   grade_7                                                   103                                             103
284466 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000452 20 Elk Mound Middle   Regular School No 2.0 05 08 2016   grade_7                                                   103                                             103
327502 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000301 20 Clintonville Middle   Regular School No Middle 05 08 2017   grade_7                                                   103                                             103
332122 WI Juneau   school 5508850 3360 Public school Mauston 550885001026 20 Olson Middle   Regular School No Middle 06 08 2017   grade_7                                                   103                                             103

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