enrollments

Data source: Big Local News · About: Big Local

685 rows where grade = "grade_8", state = "WI" and year = 2020 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 685 ✖

grade ✖

  • grade_8 · 685 ✖
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
2318156 2318156 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_8                                                   1                                             1
2318169 2318169 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 05 08 2020   grade_8                                                   97                                             97
2318655 2318655 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2020   grade_8                                                   149                                             149
2318684 2318684 WI Ashland   school 5500510 170 Public school Ashland 550051002986 250 Oredocker Project School charter Regular School Yes Middle 06 08 2020   grade_8                                                   7                                             7
2318691 2318691 WI Ashland   school   170 Public Schools-Multidistrict Charters Ashland   9100 Rural Virtual Academy             2020   grade_8                                                   3                                             3
2319589 2319589 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No High 06 12 2020   grade_8                                                   14                                             14
2324875 2324875 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2020   grade_8                                                   15                                             15
2318896 2318896 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2020   grade_8                                                   5                                             5
2318928 2318928 WI Barron   school 5500870 308 Public school Barron Area 550087000118 140 Riverview Middle   Regular School No Middle 05 08 2020   grade_8                                                   87                                             87
2319665 2319665 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2020   grade_8                                                   3                                             3
2319686 2319686 WI Barron   school 5502130 903 Public school Cameron 550213002286 200 Cameron Middle   Regular School No Middle 05 08 2020   grade_8                                                   65                                             65
2319870 2319870 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102806 200 Chetek-Weyerhaeuser Middle   Regular School No Middle 06 08 2020   grade_8                                                   68                                             68
2319891 2319891 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2020   grade_8                                                   4                                             4
2320286 2320286 WI Barron   school 5503090 1260 Public school Cumberland 550309000304 50 Cumberland Middle   Regular School No Middle 05 08 2020   grade_8                                                   74                                             74
2320290 2320290 WI Barron   school 5503090 1260 Public school Cumberland 550309002962 420 Island City Academy charter Career and Technical School Yes High 07 12 2020   grade_8                                                   4                                             4
2320302 2320302 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2020   grade_8                                                   2                                             2
2328703 2328703 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218000445 30 Prairie Farm Middle   Regular School No Middle 06 08 2020   grade_8                                                   35                                             35
2329254 2329254 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001697 140 Rice Lake Middle   Regular School No Middle 05 08 2020   grade_8                                                   172                                             172
2331092 2331092 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003068 30 Turtle Lake Middle   Regular School No Middle 06 08 2020   grade_8                                                   26                                             26
2318953 2318953 WI Bayfield   school 5500900 315 Public school Bayfield 550090000082 30 Bayfield Middle   Regular School No Middle 06 08 2020   grade_8                                                   20                                             20
2320657 2320657 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000397 50 Drummond Junior High   Regular School No Middle 07 08 2020   grade_8                                                   27                                             27
2330228 2330228 WI Bayfield   school 5512030 4522 Public school South Shore 551203001574 100 South Shore Jr/Sr High   Regular School No High 07 12 2020   grade_8                                                   14                                             14
2331357 2331357 WI Bayfield   school 5515540 6027 Public school Washburn 551554001984 20 Washburn Middle   Regular School No Middle 07 08 2020   grade_8                                                   56                                             56
2318706 2318706 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000083 45 Parkview Middle   Regular School No Middle 06 08 2020   grade_8                                                   224                                             224
2320447 2320447 WI Brown   school 5503210 1414 Public school De Pere 550321000362 30 De Pere Middle   Regular School No Middle 07 08 2020   grade_8                                                   318                                             318
2320548 2320548 WI Brown   school 5503660 1407 Public school Denmark 550366002936 450 Denmark Community School charter Regular School Yes High 06 12 2020   grade_8                                                   9                                             9
2320567 2320567 WI Brown   school 5503660 1407 Public school Denmark 550366000389 100 Denmark Middle   Regular School No Middle 06 08 2020   grade_8                                                   106                                             106
2321784 2321784 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000610 20 Aldo Leopold Community School K-8   Regular School No Elementary PK 08 2020   grade_8                                                   58                                             58
2321803 2321803 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2020   grade_8                                                   3                                             3
2321852 2321852 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other KG 12 2020   grade_8                                                   17                                             17
2321862 2321862 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000619 190 Edison Middle   Regular School No Middle 06 08 2020   grade_8                                                   360                                             360
2321892 2321892 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000623 300 Franklin Middle   Regular School No Middle 06 08 2020   grade_8                                                   223                                             223
2321930 2321930 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 2020   grade_8                                                   10                                             10
2321976 2321976 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002955 150 Leonardo da Vinci School for Gifted Learners   Regular School No Elementary KG 08 2020   grade_8                                                   34                                             34
2321989 2321989 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000631 425 Lombardi Middle   Regular School No Middle 06 08 2020   grade_8                                                   278                                             278
2322025 2322025 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 2020   grade_8                                                   33                                             33
2322040 2322040 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582001672 160 Red Smith K-8   Regular School No Elementary PK 08 2020   grade_8                                                   172                                             172
2322068 2322068 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000641 660 Washington Middle   Regular School No Middle 06 08 2020   grade_8                                                   242                                             242
2322553 2322553 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000717 30 Bay View Middle   Regular School No Middle 07 08 2020   grade_8                                                   456                                             456
2328803 2328803 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001888 200 Pulaski Community Middle   Regular School No Middle 06 08 2020   grade_8                                                   257                                             257
2332318 2332318 WI Brown   school 5516320 6328 Public school West De Pere 551632000545 110 West De Pere Middle   Regular School No Middle 06 08 2020   grade_8                                                   294                                             294
2332914 2332914 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2020   grade_8                                                   100                                             100
2318218 2318218 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   12                                             12
2320057 2320057 WI Buffalo   school 5502700 1155 Public school Cochrane-Fountain City 550270000307 40 Cochrane-Fountain City High   Regular School No High 07 12 2020   grade_8                                                   47                                             47
2321657 2321657 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537002907 250 Gilmanton Middle   Regular School No Middle 05 08 2020   grade_8                                                   10                                             10
2326813 2326813 WI Buffalo   school 5509780 3668 Public school Mondovi 550978000383 120 Mondovi Middle   Regular School No Middle 06 08 2020   grade_8                                                   58                                             58
2321763 2321763 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000603 100 Grantsburg Middle   Regular School No Middle 04 08 2020   grade_8                                                   61                                             61
2321770 2321770 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes High 06 12 2020   grade_8                                                   56                                             56
2330087 2330087 WI Burnett   school 5513890 5376 Public school Siren 551389001817 40 Siren High   Regular School No High 06 12 2020   grade_8                                                   40                                             40
2332115 2332115 WI Burnett   school 5516230 6293 Public school Webster 551623002100 100 Webster Middle   Regular School No Middle 05 08 2020   grade_8                                                   55                                             55
2319441 2319441 WI Calumet   school 5501680 658 Public school Brillion 550168002384 21 Brillion Middle   Regular School No Middle 06 08 2020   grade_8                                                   73                                             73
2319915 2319915 WI Calumet   school 5502520 1085 Public school Chilton 550252002430 30 Chilton Middle   Regular School No Middle 05 08 2020   grade_8                                                   92                                             92
2322405 2322405 WI Calumet   school 5506450 2534 Public school Hilbert 550645001458 200 Hilbert Middle   Regular School No Middle 05 08 2020   grade_8                                                   25                                             25
2327374 2327374 WI Calumet   school 5510530 3941 Public school New Holstein 551053002550 200 New Holstein Middle   Regular School No Middle 06 08 2020   grade_8                                                   74                                             74
2330539 2330539 WI Calumet   school 5514520 5614 Public school Stockbridge 551452002499 200 Stockbridge Middle   Regular School No Middle 06 08 2020   grade_8                                                   15                                             15
2319332 2319332 WI Chippewa   school 5501350 497 Public school Bloomer 550135000185 60 Bloomer Middle   Regular School No Middle 05 08 2020   grade_8                                                   94                                             94
2319611 2319611 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000249 60 Cadott Junior High   Regular School No Middle 07 08 2020   grade_8                                                   75                                             75
2319924 2319924 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000281 40 Chippewa Falls Middle   Regular School No Middle 06 08 2020   grade_8                                                   353                                             353
2320162 2320162 WI Chippewa   school 5502880 1204 Public school Cornell 550288002896 300 Cornell Middle   Regular School No Middle 06 08 2020   grade_8                                                   38                                             38
2323836 2323836 WI Chippewa   school 5507680 2891 Public school Lake Holcombe 550768000885 20 Holcombe Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   23                                             23
2327288 2327288 WI Chippewa   school 5510440 3920 Public school New Auburn 551044003117 250 New Auburn Middle   Regular School No Middle 06 08 2020   grade_8                                                   15                                             15
2330411 2330411 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443001866 100 Stanley-Boyd Middle   Regular School No Middle 06 08 2020   grade_8                                                   83                                             83
2318146 2318146 WI Clark   school 5500030 7 Public school Abbotsford 550003000002 40 Abbotsford Middle/Senior High   Regular School No High 06 12 2020   grade_8                                                   59                                             59
2318149 2318149 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2020   grade_8                                                   1                                             1
2320074 2320074 WI Clark   school 5502730 1162 Public school Colby 550273001226 210 Colby Middle   Regular School No Middle 06 08 2020   grade_8                                                   68                                             68
2320085 2320085 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2020   grade_8                                                   1                                             1
2321747 2321747 WI Clark   school 5505640 2226 Public school Granton Area 550564000600 40 Granton High   Regular School No High 06 12 2020   grade_8                                                   18                                             18
2322205 2322205 WI Clark   school 5505970 2394 Public school Greenwood 550597000657 60 Greenwood High   Regular School No High 07 12 2020   grade_8                                                   18                                             18
2324061 2324061 WI Clark   school 5508250 3206 Public school Loyal 550825000913 40 Loyal Junior High   Regular School No Middle 07 08 2020   grade_8                                                   38                                             38
2327226 2327226 WI Clark   school 5510350 3899 Public school Neillsville 551035002326 30 Neillsville Middle   Regular School No Middle 06 08 2020   grade_8                                                   73                                             73
2328222 2328222 WI Clark   school 5511310 4207 Public school Owen-Withee 551131001511 40 Owen-Withee Junior High   Regular School No Middle 06 08 2020   grade_8                                                   25                                             25
2330838 2330838 WI Clark   school   5726 Public Schools-Multidistrict Charters Thorp   9100 Rural Virtual Academy charter           2020   grade_8                                                   2                                             2
2330848 2330848 WI Clark   school 5514820 5726 Public school Thorp 551482001925 20 Thorp Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   47                                             47
2319628 2319628 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000250 40 Cambria Friesland Middle/High   Regular School No High 06 12 2020   grade_8                                                   33                                             33
2320139 2320139 WI Columbia   school 5502820 1183 Public school Columbus 550282000319 20 Columbus Middle   Regular School No Middle 06 08 2020   grade_8                                                   85                                             85
2321172 2321172 WI Columbia   school 5504530 1736 Public school Fall River 550453000484 40 Fall River High   Regular School No High 06 12 2020   grade_8                                                   36                                             36
2324008 2324008 WI Columbia   school 5508190 3150 Public school Lodi 550819000906 100 Lodi Middle   Regular School No Middle 06 08 2020   grade_8                                                   108                                             108
2328271 2328271 WI Columbia   school 5511370 4228 Public school Pardeeville Area 551137001519 100 Pardeeville Middle   Regular School No Middle 05 08 2020   grade_8                                                   57                                             57
2328612 2328612 WI Columbia   school 5512060 4501 Public school Portage Community 551206002283 160 Wayne Bartels Middle   Regular School No Middle 06 08 2020   grade_8                                                   181                                             181
2328652 2328652 WI Columbia   school 5512120 4536 Public school Poynette 551212001581 100 Poynette Middle   Regular School No Middle 06 08 2020   grade_8                                                   82                                             82
2329322 2329322 WI Columbia   school 5512990 4865 Public school Rio Community 551299001713 40 Rio Middle/High   Regular School No High 06 12 2020   grade_8                                                   35                                             35
2327526 2327526 WI Crawford   school 5504980 2016 Public school North Crawford 550498002244 110 North Crawford Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   39                                             39
2328664 2328664 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002844 300 Bluff View Junior High   Regular School No Middle 07 08 2020   grade_8                                                   77                                             77
2328679 2328679 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 2020   grade_8                                                   3                                             3
2329713 2329713 WI Crawford   school 5513470 5124 Public school Seneca Area 551347002399 28 Seneca Junior High   Regular School No Middle 06 08 2020   grade_8                                                   26                                             26
2332097 2332097 WI Crawford   school 5516020 6251 Public school Wauzeka-Steuben 551602002738 250 Wauzeka Middle   Regular School No Middle 06 08 2020   grade_8                                                   18                                             18
2319053 2319053 WI Dane   school 5500990 350 Public school Belleville 550099000133 60 Belleville Middle   Regular School No Middle 07 08 2020   grade_8                                                   77                                             77
2319648 2319648 WI Dane   school 5502100 896 Public school Cambridge 550210003093 400 Koshkonong Trails School charter Regular School Yes High 07 12 2020   grade_8                                                   7                                             7
2319653 2319653 WI Dane   school 5502100 896 Public school Cambridge 550210000298 60 Nikolay Middle   Regular School No Middle 06 08 2020   grade_8                                                   60                                             60
2320418 2320418 WI Dane   school 5503180 1316 Public school De Forest Area 550318000356 50 De Forest Middle   Regular School No Middle 05 08 2020   grade_8                                                   259                                             259
2320522 2320522 WI Dane   school 5503270 1309 Public school Deerfield Community 550327000372 60 Deerfield Middle   Regular School No Middle 07 08 2020   grade_8                                                   45                                             45
2322751 2322751 WI Dane   school 5500082 8141 Non District Charter Schools Isthmus Montessori Academy Public 550008203085 8141 Isthmus Montessori Academy Public charter Regular School Yes Other PK 12 2020   grade_8                                                   11                                             11
2324117 2324117 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002866 200 Badger Rock Middle charter Regular School Yes Middle 06 08 2020   grade_8                                                   26                                             26
2324121 2324121 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000959 690 Black Hawk Middle   Regular School No Middle 06 08 2020   grade_8                                                   140                                             140
2324138 2324138 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000922 90 Cherokee Heights Middle   Regular School No Middle 06 08 2020   grade_8                                                   188                                             188
2324201 2324201 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000966 810 Hamilton Middle   Regular School No Middle 06 08 2020   grade_8                                                   254                                             254
2324227 2324227 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000373 440 James Wright Middle   Regular School No Middle 06 08 2020   grade_8                                                   79                                             79
2324231 2324231 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000938 370 Jefferson Middle   Regular School No Middle 06 08 2020   grade_8                                                   169                                             169
2324332 2324332 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000949 540 O'Keeffe Middle   Regular School No Middle 06 08 2020   grade_8                                                   149                                             149
2324371 2324371 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000955 665 Sennett Middle   Regular School No Middle 06 08 2020   grade_8                                                   201                                             201

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