enrollments

Data source: Big Local News · About: Big Local

704 rows where grade = "grade_8", state = "WI" and year = 2021 sorted by county descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2021 · 704 ✖

grade ✖

  • grade_8 · 704 ✖
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
2333536 2333536 WI Wood   school 5500600 203 Public school Auburndale 550060000091 60 Auburndale High   Regular School No High 06 12 2021   grade_8                                                   53                                             53
2333547 2333547 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_8                                                   1                                             1
2339573 2339573 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001020 110 Marshfield Middle   Regular School No Middle 07 08 2021   grade_8                                                   299                                             299
2339593 2339593 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_8                                                   7                                             7
2342102 2342102 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2021   grade_8                                                   75                                             75
2342106 2342106 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes Middle 06 08 2021   grade_8                                                   7                                             7
2342134 2342134 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2021   grade_8                                                   4                                             4
2343328 2343328 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   45                                             45
2343343 2343343 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2021   grade_8                                                   1                                             1
2343422 2343422 WI Wood   school 5511970 4508 Public school Port Edwards 551197000580 80 John Edwards Middle   Regular School No Middle 05 08 2021   grade_8                                                   31                                             31
2347728 2347728 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003088 190 Central Oaks Academy   Regular School No Elementary PK 08 2021   grade_8                                                   51                                             51
2347791 2347791 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2021   grade_8                                                   306                                             306
2339823 2339823 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903001053 20 Maplewood Middle   Regular School No Middle 06 08 2021   grade_8                                                   255                                             255
2342047 2342047 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032002308 210 Shattuck Middle   Regular School No Middle 07 08 2021   grade_8                                                   485                                             485
2342826 2342826 WI Winnebago   school 5510980 4088 Public school Omro 551098001443 80 Omro Middle   Regular School No Middle 06 08 2021   grade_8                                                   74                                             74
2342957 2342957 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes Middle 04 08 2021   grade_8                                                   12                                             12
2342996 2342996 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119001492 240 Merrill Middle   Regular School No Middle 06 08 2021   grade_8                                                   165                                             165
2343043 2343043 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119001501 440 South Park Middle   Regular School No Middle 06 08 2021   grade_8                                                   139                                             139
2343047 2343047 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119001497 320 Tipler Middle   Regular School No Middle 06 08 2021   grade_8                                                   105                                             105
2343058 2343058 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119001368 250 Traeger Middle   Regular School No Middle 06 08 2021   grade_8                                                   157                                             157
2343076 2343076 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119001504 500 Webster Stanley Middle   Regular School No Middle 06 08 2021   grade_8                                                   129                                             129
2347649 2347649 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2021   grade_8                                                   123                                             123
2345986 2345986 WI Waushara   school 5511820 4375 Public school Tri-County Area 551182002620 80 Tri-County Middle   Regular School No Middle 05 08 2021   grade_8                                                   49                                             49
2346901 2346901 WI Waushara   school 5515960 6237 Public school Wautoma Area 551596002071 30 Parkside School   Regular School No Middle 04 08 2021   grade_8                                                   102                                             102
2347604 2347604 WI Waushara   school 5516710 6475 Public school Wild Rose 551671002185 60 Wild Rose High   Regular School No High 06 12 2021   grade_8                                                   43                                             43
2334817 2334817 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000301 20 Clintonville Middle   Regular School No Middle 05 08 2021   grade_8                                                   82                                             82
2337581 2337581 WI Waupaca   school 5506840 2639 Public school Iola-Scandinavia 550684000742 40 Iola-Scandinavia High   Regular School No High 07 12 2021   grade_8                                                   45                                             45
2339316 2339316 WI Waupaca   school 5508550 3276 Public school Manawa 550855000970 80 Manawa Middle   Regular School No Middle 06 08 2021   grade_8                                                   40                                             40
2339479 2339479 WI Waupaca   school 5508730 3318 Public school Marion 550873001005 100 Marion High   Regular School No High 07 12 2021   grade_8                                                   41                                             41
2339487 2339487 WI Waupaca   school   3318 Public Schools-Multidistrict Charters Marion   9100 Rural Virtual Academy charter           2021   grade_8                                                   2                                             2
2342285 2342285 WI Waupaca   school 5510590 3955 Public school New London 551059001388 140 New London Middle   Regular School No Middle 05 08 2021   grade_8                                                   180                                             180
2346704 2346704 WI Waupaca   school 5515840 6195 Public school Waupaca 551584002036 150 Waupaca Middle   Regular School No Middle 05 08 2021   grade_8                                                   159                                             159
2347433 2347433 WI Waupaca   school 5516500 6384 Public school Weyauwega-Fremont 551650002160 120 Weyauwega Middle   Regular School No Middle 06 08 2021   grade_8                                                   68                                             68
2335880 2335880 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000221 160 Fairview South   Special Education School No High 05 12 2021   grade_8                                                   2                                             2
2335884 2335884 WI Waukesha   school 5501770 714 Public school Elmbrook 550177002331 150 Pilgrim Park Middle   Regular School No Middle 06 08 2021   grade_8                                                   261                                             261
2335902 2335902 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000228 270 Wisconsin Hills Middle   Regular School No Middle 06 08 2021   grade_8                                                   273                                             273
2337092 2337092 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000669 130 Templeton Middle   Regular School No Middle 07 08 2021   grade_8                                                   413                                             413
2337137 2337137 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614001282 100 North Shore Middle   Regular School No Middle 06 08 2021   grade_8                                                   111                                             111
2338266 2338266 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351000377 140 Kettle Moraine Middle   Regular School No Middle 06 08 2021   grade_8                                                   275                                             275
2338656 2338656 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2021   grade_8                                                   60                                             60
2339865 2339865 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906001068 220 North Middle   Regular School No Middle 06 08 2021   grade_8                                                   298                                             298
2340046 2340046 WI Waukesha   school 5509360 3528 Public school Merton Community 550936002269 20 Merton Intermediate   Regular School No Middle 05 08 2021   grade_8                                                   111                                             111
2341901 2341901 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006001320 65 Park View Middle   Regular School No Middle 07 08 2021   grade_8                                                   403                                             403
2341940 2341940 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001850 200 Lake Denoon Middle   Regular School No Middle 05 08 2021   grade_8                                                   185                                             185
2341962 2341962 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2021   grade_8                                                   176                                             176
2342164 2342164 WI Waukesha   school 5510470 3925 Public school New Berlin 551047001366 50 Eisenhower Middle/High   Regular School No High 07 12 2021   grade_8                                                   177                                             177
2342180 2342180 WI Waukesha   school 5510470 3925 Public school New Berlin 551047001372 140 New Berlin Middle/High   Regular School No High 07 12 2021   grade_8                                                   168                                             168
2342371 2342371 WI Waukesha   school 5510710 3976 Public school Norris 551071001395 20 Norris Academy   Regular School No Other KG 12 2021   grade_8                                                   1                                             1
2342379 2342379 WI Waukesha   school 5510710 3976 Public school Norris 551071003072 800 Norris Academy Virtual School charter Alternative School Yes Other KG 12 2021   grade_8                                                   2                                             2
2342445 2342445 WI Waukesha   school 5509300 3514 Public school North Lake 550930002268 20 North Lake Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   28                                             28
2342734 2342734 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089002795 200 Nature Hill Intermediate   Regular School No Middle 05 08 2021   grade_8                                                   223                                             223
2342752 2342752 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001422 135 Silver Lake Intermediate   Regular School No Middle 05 08 2021   grade_8                                                   157                                             157
2343257 2343257 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164001538 100 Asa Clark Middle   Regular School No Middle 06 08 2021   grade_8                                                   218                                             218
2344199 2344199 WI Waukesha   school 5508130 3122 Public school Richmond 550813002262 20 Richmond Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   47                                             47
2345455 2345455 WI Waukesha   school 5509390 3542 Public school Stone Bank 550939002270 20 Stone Bank Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   42                                             42
2345739 2345739 WI Waukesha   school 5509240 3510 Public school Swallow 550924002267 20 Swallow Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   66                                             66
2346472 2346472 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002008 100 Butler Middle   Regular School No Middle 06 08 2021   grade_8                                                   307                                             307
2346479 2346479 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003380 470 eAchieve Academy - Wisconsin charter Regular School Yes High 06 12 2021   grade_8                                                   109                                             109
2346527 2346527 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002015 210 Horning Middle   Regular School No Middle 06 08 2021   grade_8                                                   201                                             201
2346531 2346531 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002009 120 Les Paul Middle   Regular School No Middle 06 08 2021   grade_8                                                   202                                             202
2346598 2346598 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002502 490 Waukesha East Alternative School charter Alternative School Yes High 06 12 2021   grade_8                                                   2                                             2
2346613 2346613 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002023 400 Waukesha STEM Academy charter Regular School Yes Elementary PK 08 2021   grade_8                                                   111                                             111
2346633 2346633 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002027 520 White Rock School   Regular School No Elementary PK 08 2021   grade_8                                                   4                                             4
2335937 2335937 WI Washington   school 5504410 1687 Public school Erin 550441000476 20 Erin Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   47                                             47
2336402 2336402 WI Washington   school 5505160 2058 Public school Germantown 550516000554 110 Kennedy Middle   Regular School No Middle 06 08 2021   grade_8                                                   315                                             315
2337105 2337105 WI Washington   school 5506090 2443 Public school Hartford J1 550609000674 20 Central Middle   Regular School No Middle 06 08 2021   grade_8                                                   175                                             175
2337302 2337302 WI Washington   school 5500080 2570 Public school Holy Hill Area 550008003078 290 Richfield Middle   Regular School No Middle 05 08 2021   grade_8                                                   63                                             63
2338323 2338323 WI Washington   school 5507380 2800 Public school Kewaskum 550738000838 90 Kewaskum Middle   Regular School No Middle 06 08 2021   grade_8                                                   129                                             129
2345021 2345021 WI Washington   school 5513950 5390 Public school Slinger 551395001820 60 Slinger Middle   Regular School No Middle 06 08 2021   grade_8                                                   253                                             253
2347215 2347215 WI Washington   school 5516290 6307 Public school West Bend 551629002125 10 Badger Middle   Regular School No Middle 07 08 2021   grade_8                                                   461                                             461
2334003 2334003 WI Washburn   school 5501170 441 Public school Birchwood 550117002800 450 Birchwood Blue Hills Charter School charter Regular School Yes High 07 12 2021   grade_8                                                   1                                             1
2334021 2334021 WI Washburn   school 5501170 441 Public school Birchwood 550117003374 210 Birchwood Middle   Regular School No Middle 06 08 2021   grade_8                                                   16                                             16
2334042 2334042 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other KG 12 2021   grade_8                                                   5                                             5
2342556 2342556 WI Washburn   school 5509720 3654 Public school Northwood 550972002877 200 NorthStar Community Charter School charter Regular School Yes Middle 04 08 2021   grade_8                                                   3                                             3
2342570 2342570 WI Washburn   school 5509720 3654 Public school Northwood 550972002934 410 Northwood High/Middle charter Regular School Yes High 06 12 2021   grade_8                                                   21                                             21
2342583 2342583 WI Washburn   school 5509720 3654 Public school Northwood 550972003018 800 Northwood Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_8                                                   5                                             5
2344882 2344882 WI Washburn   school 5513710 5306 Public school Shell Lake 551371001805 40 Shell Lake Junior/Senior High   Regular School No High 07 12 2021   grade_8                                                   54                                             54
2345268 2345268 WI Washburn   school 5514220 5474 Public school Spooner Area 551422001849 100 Spooner Middle   Regular School No Middle 05 08 2021   grade_8                                                   88                                             88
2335335 2335335 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002241 60 Phoenix Middle   Regular School No Middle 05 08 2021   grade_8                                                   139                                             139
2335483 2335483 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000411 60 East Troy Middle   Regular School No Middle 06 08 2021   grade_8                                                   116                                             116
2335783 2335783 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429000460 60 Elkhorn Area Middle   Regular School No Middle 06 08 2021   grade_8                                                   247                                             247
2335795 2335795 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429003038 800 Elkhorn Options Virtual School charter Regular School Yes Other PK 12 2021   grade_8                                                   51                                             51
2336171 2336171 WI Walworth   school 5504720 1870 Public school Fontana J8 550472000508 20 Fontana Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   27                                             27
2336362 2336362 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   13                                             13
2336377 2336377 WI Walworth   school 5505130 2051 Public school Genoa City J2 550513002327 200 Brookwood Middle   Regular School No Middle 04 08 2021   grade_8                                                   55                                             55
2338672 2338672 WI Walworth   school 5507620 2885 Public school Lake Geneva J1 550762000881 60 Lake Geneva Middle   Regular School No Middle 06 08 2021   grade_8                                                   224                                             224
2338681 2338681 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_8                                                   8                                             8
2338816 2338816 WI Walworth   school 5508040 3087 Public school Linn J4 550804000898 20 Traver Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   10                                             10
2338827 2338827 WI Walworth   school 5508070 3094 Public school Linn J6 550807000899 20 Reek Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   11                                             11
2344670 2344670 WI Walworth   school 5513560 5258 Public school Sharon J11 551356001774 20 Sharon Community   Regular School No Elementary PK 08 2021   grade_8                                                   28                                             28
2346260 2346260 WI Walworth   school 5515450 6022 Public school Walworth J1 551545001981 20 Walworth Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   54                                             54
2347523 2347523 WI Walworth   school   6461 Public Schools-Multidistrict Charters Whitewater Unified   9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter           2021   grade_8                                                   2                                             2
2347561 2347561 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002178 20 Whitewater Middle   Regular School No Middle 06 08 2021   grade_8                                                   136                                             136
2347626 2347626 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No Middle 06 08 2021   grade_8                                                   52                                             52
2338625 2338625 WI Vilas   school 5504620 1848 Public school Lac du Flambeau #1 550462000488 20 Lac du Flambeau Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   49                                             49
2342457 2342457 WI Vilas   school 5501530 616 Public school North Lakeland 550153000198 50 North Lakeland Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   16                                             16
2342532 2342532 WI Vilas   school 5503860 1526 Public school Northland Pines 550386000407 95 Northland Pines Middle   Regular School No Middle 07 08 2021   grade_8                                                   120                                             120
2342544 2342544 WI Vilas   school 5503860 1526 Public school Northland Pines 550386003013 410 School of Options & Applied Research High charter Regular School Yes High 08 12 2021   grade_8                                                   1                                             1
2342550 2342550 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_8                                                   11                                             11
2343281 2343281 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   5                                             5

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