Data source: Big Local News · About: Big Local

696 rows where grade = "grade_7", state = "WI" and year = 2021 sorted by total_int

View and edit SQL

year

  • 2021 · 696

grade

  • grade_7 · 696
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 ▼
2333474 WI Ashland   school   170 Public Schools-Multidistrict Charters Ashland   9100 Rural Virtual Academy             2021   grade_7                                                   1                                             1
2333546 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_7                                                   1                                             1
2334002 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2021   grade_7                                                   1                                             1
2334041 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other KG 12 2021   grade_7                                                   1                                             1
2334174 WI Shawano   school   623 Public Schools-Multidistrict Charters Bowler   9100 Rural Virtual Academy charter           2021   grade_7                                                   1                                             1
2334868 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2021   grade_7                                                   1                                             1
2335086 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Career and Technical School Yes High 07 12 2021   grade_7                                                   1                                             1
2335681 WI Rock   school   1568 Public Schools-Multidistrict Charters Edgerton   9803 JEDI Virtual K-12 charter           2021   grade_7                                                   1                                             1
2335716 WI Langlade   school   1582 Public Schools-Multidistrict Charters Elcho   9100 Rural Virtual Academy charter           2021   grade_7                                                   1                                             1
2335879 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000221 160 Fairview South   Special Education School No High 05 12 2021   grade_7                                                   1                                             1
2337181 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002867 250 Northern Waters Environmental School charter Regular School Yes High 06 12 2021   grade_7                                                   1                                             1
2340935 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002567 296 Lad Lake Synergy School   Alternative School No High 06 12 2021   grade_7                                                   1                                             1
2341731 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2021   grade_7                                                   1                                             1
2341968 WI Juneau   school 5510230 3871 Public school Necedah Area 551023003116 410 N-Gage Academy charter Regular School Yes High 06 12 2021   grade_7                                                   1                                             1
2342252 WI Juneau   school 5510560 3948 Public school New Lisbon 551056001381 40 New Lisbon Elementary   Regular School No Elementary PK 06 2021   grade_7                                                   1                                             1
2343316 WI Price   school   4347 Public Schools-Multidistrict Charters Phillips   9100 Rural Virtual Academy             2021   grade_7                                                   1                                             1
2344354 WI Grant   school 5510140 3850 Public school Riverdale 551014003084 430 Riverdale Academy   Alternative School No High 06 12 2021   grade_7                                                   1                                             1
2345471 WI Dane   school   5621 Public Schools-Multidistrict Charters Stoughton Area   9803 JEDI Virtual K-12 charter           2021   grade_7                                                   1                                             1
2345508 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2021   grade_7                                                   1                                             1
2347522 WI Walworth   school   6461 Public Schools-Multidistrict Charters Whitewater Unified   9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter           2021   grade_7                                                   1                                             1
2347865 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713003059 850 Wonewoc-Center Virtual Academy charter Regular School Yes Other KG 12 2021   grade_7                                                   1                                             1
2334401 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_7                                                   2                                             2
2334956 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_7                                                   2                                             2
2335926 WI Pierce   school 5504350 1666 Public school Elmwood 550435003121 800 Western Wisconsin Virtual Charter School (WWVC) charter Regular School Yes Other PK 12 2021   grade_7                                                   2                                             2
2337806 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2021   grade_7                                                   2                                             2
2338031 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002317 280 Hillcrest School   Alternative School No High 06 12 2021   grade_7                                                   2                                             2
2341792 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_7                                                   2                                             2
2343342 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2021   grade_7                                                   2                                             2
2343568 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes Other KG 12 2021   grade_7                                                   2                                             2
2343620 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2021   grade_7                                                   2                                             2
2345231 WI Marathon   school   5467 Public Schools-Multidistrict Charters Spencer   9100 Rural Virtual Academy charter           2021   grade_7                                                   2                                             2
2345751 WI Clark   school   5726 Public Schools-Multidistrict Charters Thorp   9100 Rural Virtual Academy charter           2021   grade_7                                                   2                                             2
2333871 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2021   grade_7                                                   3                                             3
2334676 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_7                                                   3                                             3
2336464 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_7                                                   3                                             3
2336536 WI Marinette   school 5505580 2212 Public school Goodman-Armstrong Creek 550558000592 40 Goodman High   Regular School No High 07 12 2021   grade_7                                                   3                                             3
2337525 WI Dodge   school   2625 Public Schools-Multidistrict Charters Hustisford   800 Between the Lakes Virtual Academy charter           2021   grade_7                                                   3                                             3
2337757 WI Rock   school 5507020 2695 Public school Janesville 550702002691 430 TAGOS Leadership Academy-Tailoring Academics to Guide our Students charter Regular School Yes High 07 12 2021   grade_7                                                   3                                             3
2344100 WI Oneida   school   4781 Public Schools-Multidistrict Charters Rhinelander   9100 Rural Virtual Academy charter           2021   grade_7                                                   3                                             3
2345210 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002542 410 Sparta High Point School charter Regular School Yes High 07 12 2021   grade_7                                                   3                                             3
2347331 WI Vernon   school   6321 Public Schools-Multidistrict Charters Westby Area   9100 Rural Virtual Academy charter           2021   grade_7                                                   3                                             3
2347835 WI Sawyer   school 5500086 8146 Non District Charter Schools WOLI/Akii'gikinoo'amaading Environmental 550008603137 8146 WOLI/Akii'gikinoo'amaading Environmental School charter Regular School Yes High 06 12 2021   grade_7                                                   3                                             3
2333132 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2021   grade_7                                                   4                                             4
2333858 WI Rock   school 5501050 413 Public school Beloit 550105002974 421 Beloit Learning Academy   Alternative School No High 06 12 2021   grade_7                                                   4                                             4
2336860 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003105 450 Northeast Wisconsin School of Innovation charter Regular School Yes High 07 12 2021   grade_7                                                   4                                             4
2338680 WI Walworth   school 5507620 2885 Public school Lake Geneva J1 550762003107 150 Maple Park Charter School charter Regular School Yes Elementary PK 08 2021   grade_7                                                   4                                             4
2339517 WI Dane   school 5508790 3332 Public school Marshall 550879002901 9803 JEDI Virtual K-12 charter Alternative School Yes Other PK 12 2021   grade_7                                                   4                                             4
2339613 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2021   grade_7                                                   4                                             4
2340129 WI Dane   school 5500085 8145 Non District Charter Schools Milestone Democratic School 550008503136 8145 Milestone Democratic School charter Regular School Yes High 07 12 2021   grade_7                                                   4                                             4
2341390 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000936 1086 Southeastern   Alternative School No Middle 06 08 2021   grade_7                                                   4                                             4
2342555 WI Washburn   school 5509720 3654 Public school Northwood 550972002877 200 NorthStar Community Charter School charter Regular School Yes Middle 04 08 2021   grade_7                                                   4                                             4
2344188 WI Richland   school 5512960 4851 Public school Richland 551296002998 450 Richland Online Academy charter Regular School Yes High 06 12 2021   grade_7                                                   4                                             4
2345038 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_7                                                   4                                             4
2345954 WI Portage   school 5500330 126 Public school Tomorrow River 550033003063 140 Tomorrow River Virtual Charter School (TRVCS) charter Regular School Yes Elementary PK 08 2021   grade_7                                                   4                                             4
2346287 WI Door   school 5515570 6069 Public school Washington 551557001986 20 Washington Island Elementary   Regular School No Elementary PK 08 2021   grade_7                                                   4                                             4
2346742 WI Marathon   school 5515900 6223 Public school Wausau 551590002747 400 Enrich Excel Achieve Learning Academy charter Alternative School Yes High 06 12 2021   grade_7                                                   4                                             4
2334440 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes High 07 12 2021   grade_7                                                   5                                             5
2335523 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_7                                                   5                                             5
2337310 WI Dodge   school   2576 Public Schools-Multidistrict Charters Horicon   800 Between the Lakes Virtual Academy charter           2021   grade_7                                                   5                                             5
2341771 WI Marquette   school 5509870 3689 Public school Montello 550987002821 420 High Marq Environmental Charter School charter Regular School Yes High 06 12 2021   grade_7                                                   5                                             5
2345445 WI Calumet   school 5514520 5614 Public school Stockbridge 551452002499 200 Stockbridge Middle   Regular School No Middle 06 08 2021   grade_7                                                   5                                             5
2345996 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes Other PK 12 2021   grade_7                                                   5                                             5
2346204 WI Vernon   school 5515360 5985 Public school Viroqua Area 551536003122 240 Trillium Middle charter Regular School Yes Middle 07 08 2021   grade_7                                                   5                                             5
2335114 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002885 400 D C Everest Idea School charter Regular School Yes High 06 12 2021   grade_7                                                   6                                             6
2339592 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_7                                                   6                                             6
2339978 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2021   grade_7                                                   6                                             6
2342435 WI Fond du Lac   school 5510740 3983 Public school North Fond du Lac 551074003125 800 Treffert Way for the Exceptional Mind charter Regular School Yes Elementary KG 07 2021   grade_7                                                   6                                             6
2345862 WI Monroe   school   5747 Public Schools-Multidistrict Charters Tomah Area   9100 Rural Virtual Academy charter           2021   grade_7                                                   6                                             6
2346401 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_7                                                   6                                             6
2335098 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2021   grade_7                                                   7                                             7
2336693 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other KG 12 2021   grade_7                                                   7                                             7
2338475 WI La Crosse   school 5507530 2849 Public school La Crosse 550753001463 140 Coulee Montessori Charter School charter Regular School Yes Elementary PK 08 2021   grade_7                                                   7                                             7
2341700 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 High 06 12 2021   grade_7                                                   7                                             7
2342105 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes Middle 06 08 2021   grade_7                                                   7                                             7
2342582 WI Washburn   school 5509720 3654 Public school Northwood 550972003018 800 Northwood Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_7                                                   7                                             7
2346632 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002027 520 White Rock School   Regular School No Elementary PK 08 2021   grade_7                                                   7                                             7
2347470 WI Langlade   school 5516590 6440 Public school White Lake 551659003108 250 White Lake Middle   Regular School No Middle 07 08 2021   grade_7                                                   7                                             7
2333375 WI Outagamie   school 5500390 147 Public school Appleton Area 550039003341 460 Valley New School charter Regular School Yes High 07 12 2021   grade_7                                                   8                                             8
2335347 WI Brown   school 5503660 1407 Public school Denmark 550366002936 450 Denmark Community School charter Regular School Yes High 06 12 2021   grade_7                                                   8                                             8
2343863 WI Racine   school 5512360 4620 Public school Racine Unified 551236003045 801 Racine Alternative Learning   Alternative School No Other KG 12 2021   grade_7                                                   8                                             8
2345130 WI Bayfield   school 5512030 4522 Public school South Shore 551203001574 100 South Shore Jr/Sr High   Regular School No High 07 12 2021   grade_7                                                   8                                             8
2338837 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816002959 130 Flex Academy charter Regular School Yes Elementary KG 08 2021   grade_7                                                   9                                             9
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
2333808 WI Marinette   school 5511550 4263 Public school Beecher-Dunbar-Pembine 551155001530 60 Pembine High   Regular School No High 07 12 2021   grade_7                                                   11                                             11
2334540 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2021   grade_7                                                   11                                             11
2335420 WI Racine   school 5503750 1449 Public school Dover #1 550375000394 20 Kansasville Elementary   Regular School No Elementary PK 08 2021   grade_7                                                   11                                             11
2346055 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512003037 810 Lighthouse Learning Academy charter Regular School Yes Other PK 12 2021   grade_7                                                   11                                             11
2333571 WI Eau Claire   school 5500630 217 Public school Augusta 550063002586 410 Wildlands Charter School charter Regular School Yes High 07 12 2021   grade_7                                                   12                                             12
2336763 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 2021   grade_7                                                   12                                             12
2338560 WI La Crosse   school 5507530 2849 Public school La Crosse 550753001295 204 School of Technology and Arts II charter Regular School Yes Middle 06 08 2021   grade_7                                                   12                                             12
2340189 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 07 2021   grade_7                                                   12                                             12
2336499 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537002907 250 Gilmanton Middle   Regular School No Middle 05 08 2021   grade_7                                                   13                                             13
2342133 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2021   grade_7                                                   13                                             13
2346327 WI Racine   school   6113 Public Schools-Multidistrict Charters Waterford Graded J1   9803 JEDI Virtual K-12 charter           2021   grade_7                                                   13                                             13
2346684 WI Waupaca   school 5515840 6195 Public school Waupaca 551584003091 180 Chain Exploration Center charter Regular School Yes Elementary PK 07 2021   grade_7                                                   13                                             13
2333246 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2021   grade_7                                                   14                                             14
2338369 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744003130 800 Between the Lakes Virtual Academy charter Regular School Yes Elementary KG 08 2021   grade_7                                                   14                                             14
2338711 WI Chippewa   school 5507680 2891 Public school Lake Holcombe 550768000885 20 Holcombe Elementary   Regular School No Elementary PK 08 2021   grade_7                                                   14                                             14

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