Data source: Big Local News · About: Big Local

4,744 rows where grade = "grade_8" and state = "WI" sorted by rowid descending

View and edit SQL

year

grade

  • grade_8 · 4,644
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
3100817 WI Washburn   school 5514220 5474 Public school Spooner Area 551422001849 100 Spooner Middle   Regular School No Middle 05 08 2018   grade_8                                                   85                                             85
3100797 WI Marathon   school 5514190 5467 Public school Spencer 551419001845 40 Spencer Junior High/High   Regular School No High 06 12 2018   grade_8                                                   48                                             48
3100781 WI Marathon   school   5467 Public Schools-Multidistrict Charters Spencer   9100 Rural Virtual Academy charter           2018   grade_8                                                   2                                             2
3100772 WI Monroe   school 5514160 5460 Public school Sparta Area 551416001842 140 Sparta Meadowview Middle   Regular School No Middle 06 08 2018   grade_8                                                   164                                             164
3100764 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002542 410 Sparta High Point School charter Regular School Yes High 07 12 2018   grade_8                                                   8                                             8
3100723 WI Monroe   school 5514160 5460 Public school Sparta Area 551416003001 200 Innovations STEM Academy charter Regular School Yes Middle 06 08 2018   grade_8                                                   20                                             20
3100705 WI Grant   school 5506300 2485 Public school Southwestern Wisconsin 550630000695 40 Southwestern Wisconsin Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   32                                             32
3100696 WI Door   school 5514130 5457 Public school Southern Door County 551413001835 40 Southern Door Middle   Regular School No Middle 06 08 2018   grade_8                                                   71                                             71
3100677 WI Bayfield   school 5512030 4522 Public school South Shore 551203001574 100 South Shore Jr/Sr High   Regular School No High 07 12 2018   grade_8                                                   13                                             13
3100661 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001831 100 South Milwaukee Middle   Regular School No Middle 06 08 2018   grade_8                                                   225                                             225
3100617 WI Saint Croix   school 5514010 5432 Public school Somerset 551401001108 60 Somerset Middle   Regular School No Middle 05 08 2018   grade_8                                                   114                                             114
3100596 WI Douglas   school 5513980 5397 Public school Solon Springs 551398001911 800 Solon Springs School   Regular School No Other PK 12 2018   grade_8                                                   15                                             15
3100584 WI Washington   school 5513950 5390 Public school Slinger 551395001820 60 Slinger Middle   Regular School No Middle 06 08 2018   grade_8                                                   236                                             236
3100548 WI Burnett   school 5513890 5376 Public school Siren 551389001817 40 Siren High   Regular School No High 06 12 2018   grade_8                                                   38                                             38
3100530 WI Kenosha   school 5513860 5369 Public school Silver Lake J1 551386001815 20 Riverview Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   55                                             55
3100521 WI Lafayette   school 5513830 5362 Public school Shullsburg 551383002400 28 Shullsburg Junior High   Regular School No Middle 06 08 2018   grade_8                                                   24                                             24
3100503 WI Milwaukee   school 5513800 5355 Public school Shorewood 551380001812 60 Shorewood Intermediate   Regular School No Middle 07 08 2018   grade_8                                                   158                                             158
3100464 WI Outagamie   school 5513770 5348 Public school Shiocton 551377001807 20 Shiocton Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   47                                             47
3100448 WI Washburn   school 5513710 5306 Public school Shell Lake 551371001805 40 Shell Lake Junior/Senior High   Regular School No High 07 12 2018   grade_8                                                   40                                             40
3100437 WI Sheboygan   school 5513680 5278 Public school Sheboygan Falls 551368002289 60 Sheboygan Falls Middle   Regular School No Middle 05 08 2018   grade_8                                                   125                                             125
3100412 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365001798 360 Urban Middle   Regular School No Middle 06 08 2018   grade_8                                                   227                                             227
3100394 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002872 105 Sheboygan Leadership Academy charter Regular School Yes Elementary PK 08 2018   grade_8                                                   21                                             21
3100350 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002733 150 Lake Country Academy - Charter charter Regular School Yes Elementary PK 08 2018   grade_8                                                   24                                             24
3100320 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365001785 110 Horace Mann Middle   Regular School No Middle 06 08 2018   grade_8                                                   206                                             206
3100309 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002900 220 George D Warriner Middle charter Regular School Yes Middle 06 08 2018   grade_8                                                   30                                             30
3100300 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365001783 60 Farnsworth Middle   Regular School No Middle 06 08 2018   grade_8                                                   164                                             164
3100296 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002899 250 Etude Middle charter Regular School Yes Middle 06 08 2018   grade_8                                                   33                                             33
3100252 WI Shawano   school 5513620 5264 Public school Shawano 551362001775 70 Shawano Community Middle   Regular School No Middle 06 08 2018   grade_8                                                   105                                             105
3100231 WI Walworth   school 5513560 5258 Public school Sharon J11 551356001774 20 Sharon Community   Regular School No Elementary PK 08 2018   grade_8                                                   30                                             30
3100222 WI Outagamie   school 5513530 5138 Public school Seymour Community 551353001772 80 Seymour Middle   Regular School No Middle 06 08 2018   grade_8                                                   136                                             136
3100202 WI Outagamie   school 5513530 5138 Public school Seymour Community 551353001769 20 Black Creek Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   32                                             32
3100190 WI Door   school 5513500 5130 Public school Sevastopol 551350000496 30 Sevastopol Middle   Regular School No Middle 06 08 2018   grade_8                                                   50                                             50
3100174 WI Crawford   school 5513470 5124 Public school Seneca Area 551347002399 28 Seneca Junior High   Regular School No Middle 06 08 2018   grade_8                                                   15                                             15
3100144 WI Milwaukee   school 5500074 8001 Non District Charter Schools Seeds of Health Inc 550007402692 8121 Seeds of Health Elementary Program charter Regular School Yes Elementary PK 08 2018   grade_8                                                   45                                             45
3100121 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001760 140 Sauk Prairie Middle   Regular School No Middle 06 08 2018   grade_8                                                   213                                             213
3100092 WI Kenosha   school 5513350 5068 Public school Salem 551335001753 20 Salem Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   122                                             122
3100071 WI Milwaukee   school 5513260 5026 Public school Saint Francis 551326001747 20 Deer Creek Intermediate   Regular School No Middle 04 08 2018   grade_8                                                   64                                             64
3100065 WI Polk   school 5513230 5019 Public school Saint Croix Falls 551323002314 70 Saint Croix Falls Middle   Regular School No Middle 05 08 2018   grade_8                                                   85                                             85
3100046 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606000673 80 Saint Croix Central Middle   Regular School No Middle 05 08 2018   grade_8                                                   127                                             127
3100025 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606002989 850 Saint Croix Academy of Virtual Education charter Regular School Yes Other PK 12 2018   grade_8                                                   3                                             3
3100013 WI Juneau   school 5504380 1673 Public school Royall 550438000473 40 Royall Intermediate   Regular School No Middle 04 06 2018   grade_8                                                   1                                             1
3100007 WI Juneau   school 5504380 1673 Public school Royall 550438000474 60 Royall High   Regular School No High 07 12 2018   grade_8                                                   39                                             39
3099994 WI Portage   school 5513140 4963 Public school Rosholt 551314002449 60 Rosholt Middle   Regular School No Middle 06 08 2018   grade_8                                                   45                                             45
3099969 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310001731 80 Rosendale Intermediate   Regular School No Middle 04 08 2018   grade_8                                                   46                                             46
3099953 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310001728 30 Brandon Middle   Regular School No Middle 06 08 2018   grade_8                                                   27                                             27
3099933 WI Grant   school 5510140 3850 Public school Riverdale 551014001064 160 Riverdale Junior High   Regular School No Middle 07 08 2018   grade_8                                                   57                                             57
3099915 WI Sauk   school 5514250 5523 Public school River Valley 551425001856 100 River Valley Middle   Regular School No Middle 06 08 2018   grade_8                                                   100                                             100
3099889 WI Grant   school 5500017 4904 Public school River Ridge 550001700685 40 River Ridge Middle   Regular School No Middle 05 08 2018   grade_8                                                   51                                             51
3099836 WI Pierce   school 5513050 4893 Public school River Falls 551305001723 60 Meyer Middle   Regular School No Middle 06 08 2018   grade_8                                                   270                                             270
3099825 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302001719 140 Ripon Middle   Regular School No Middle 06 08 2018   grade_8                                                   82                                             82
3099799 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302002930 200 Catalyst Charter Middle charter Regular School Yes Middle 06 08 2018   grade_8                                                   40                                             40
3099789 WI Columbia   school 5512990 4865 Public school Rio Community 551299001713 40 Rio Middle/High   Regular School No High 06 12 2018   grade_8                                                   31                                             31
3099770 WI Waukesha   school 5508130 3122 Public school Richmond 550813002262 20 Richmond Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   60                                             60
3099760 WI Richland   school 5512960 4851 Public school Richland 551296002998 450 Richland Online Academy charter Regular School Yes High 06 12 2018   grade_8                                                   5                                             5
3099753 WI Richland   school 5512960 4851 Public school Richland 551296001708 280 Richland Middle   Regular School No Middle 06 08 2018   grade_8                                                   116                                             116
3099727 WI Washington   school 5512900 4820 Public school Richfield J1 551290001703 20 Richfield Elementary   Regular School No Middle 03 08 2018   grade_8                                                   42                                             42
3099706 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001697 140 Rice Lake Middle   Regular School No Middle 05 08 2018   grade_8                                                   152                                             152
3099664 WI Taylor   school 5512780 4795 Public school Rib Lake 551278001688 80 Rib Lake Middle   Regular School No Middle 06 08 2018   grade_8                                                   35                                             35
3099627 WI Oneida   school 5512720 4781 Public school Rhinelander 551272001677 90 James Williams Middle   Regular School No Middle 06 08 2018   grade_8                                                   166                                             166
3099613 WI Manitowoc   school 5512690 4760 Public school Reedsville 551269001671 60 Reedsville Middle   Regular School No Middle 05 08 2018   grade_8                                                   42                                             42
3099589 WI Sauk   school 5512660 4753 Public school Reedsburg 551266001665 100 Webb Middle   Regular School No Middle 06 08 2018   grade_8                                                   206                                             206
3099551 WI Racine   school 5512480 4686 Public school Raymond #14 551248001656 20 Raymond Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   41                                             41
3099542 WI Sheboygan   school 5512450 4641 Public school Random Lake 551245002421 20 Random Lake Middle   Regular School No Middle 05 08 2018   grade_8                                                   56                                             56
3099516 WI Dodge   school 5512420 4634 Public school Randolph 551242001650 20 Randolph Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   36                                             36
3099504 WI Kenosha   school 5512390 4627 Public school Randall J1 551239001649 20 Randall Consolidated School   Regular School No Elementary PK 08 2018   grade_8                                                   67                                             67
3099485 WI Racine   school 5512360 4620 Public school Racine Unified 551236001644 499 Walden III High   Alternative School No High 06 12 2018   grade_8                                                   80                                             80
3099468 WI Racine   school 5512360 4620 Public school Racine Unified 551236002471 800 The REAL School-Racine Educational Alternative Learning Experience   Regular School No High 06 12 2018   grade_8                                                   50                                             50
3099461 WI Racine   school 5512360 4620 Public school Racine Unified 551236001639 288 Starbuck Middle   Regular School No Middle 06 08 2018   grade_8                                                   195                                             195
3099423 WI Racine   school 5512360 4620 Public school Racine Unified 551236003066 390 Racine Alternative Learning 6-12   Alternative School No High 06 12 2018   grade_8                                                   11                                             11
3099393 WI Racine   school 5512360 4620 Public school Racine Unified 551236001633 286 Mitchell Middle   Regular School No Middle 06 08 2018   grade_8                                                   195                                             195
3099379 WI Racine   school 5512360 4620 Public school Racine Unified 551236001631 284 McKinley Middle   Regular School No Middle 06 08 2018   grade_8                                                   193                                             193
3099340 WI Racine   school 5512360 4620 Public school Racine Unified 551236001625 282 Jerstad-Agerholm Middle   Regular School No Middle 06 08 2018   grade_8                                                   193                                             193
3099298 WI Racine   school 5512360 4620 Public school Racine Unified 551236001616 280 Gilmore Middle   Regular School No Middle 06 08 2018   grade_8                                                   173                                             173
3099291 WI Racine   school 5512360 4620 Public school Racine Unified 551236002311 119 Gifford Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   112                                             112
3099237 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001888 200 Pulaski Community Middle   Regular School No Middle 06 08 2018   grade_8                                                   285                                             285
3099196 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2018   grade_8                                                   33                                             33
3099184 WI Pierce   school 5512240 4578 Public school Prescott 551224001593 80 Prescott Middle   Regular School No Middle 06 08 2018   grade_8                                                   123                                             123
3099165 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2018   grade_8                                                   1                                             1
3099157 WI Price   school 5512210 4571 Public school Prentice 551221002767 200 Prentice Middle   Regular School No Middle 05 08 2018   grade_8                                                   27                                             27
3099136 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218000445 30 Prairie Farm Middle   Regular School No Middle 06 08 2018   grade_8                                                   26                                             26
3099111 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 2018   grade_8                                                   3                                             3
3099096 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002844 300 Bluff View Junior High   Regular School No Middle 07 08 2018   grade_8                                                   85                                             85
3099084 WI Columbia   school 5512120 4536 Public school Poynette 551212001581 100 Poynette Middle   Regular School No Middle 06 08 2018   grade_8                                                   82                                             82
3099066 WI Grant   school 5512090 4529 Public school Potosi 551209001603 200 Potosi Middle   Regular School No Middle 06 08 2018   grade_8                                                   22                                             22
3099045 WI Columbia   school 5512060 4501 Public school Portage Community 551206002283 160 Wayne Bartels Middle   Regular School No Middle 06 08 2018   grade_8                                                   203                                             203
3099004 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200001570 140 Thomas Jefferson Middle   Regular School No Middle 05 08 2018   grade_8                                                   186                                             186
3098964 WI Wood   school 5511970 4508 Public school Port Edwards 551197000580 80 John Edwards Middle   Regular School No Middle 05 08 2018   grade_8                                                   28                                             28
3098954 WI Sheboygan   school 5511940 4473 Public school Plymouth Joint 551194001563 120 Riverview Middle   Regular School No Middle 05 08 2018   grade_8                                                   147                                             147
3098921 WI Pierce   school 5511880 4459 Public school Plum City 551188001557 40 Plum City High   Regular School No High 06 12 2018   grade_8                                                   23                                             23
3098896 WI Grant   school 5511850 4389 Public school Platteville 551185001554 80 Platteville Middle   Regular School No Middle 05 08 2018   grade_8                                                   88                                             88
3098886 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2018   grade_8                                                   2                                             2
3098872 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   41                                             41
3098863 WI Price   school 5511730 4347 Public school Phillips 551173001545 130 Phillips Middle   Regular School No Middle 06 08 2018   grade_8                                                   51                                             51
3098837 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   5                                             5
3098812 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164001538 100 Asa Clark Middle   Regular School No Middle 07 08 2018   grade_8                                                   204                                             204
3098809 WI Marinette   school 5511610 4305 Public school Peshtigo 551161003026 200 Peshtigo Middle   Regular School No Middle 07 08 2018   grade_8                                                   99                                             99
3098790 WI Pepin   school 5511580 4270 Public school Pepin Area 551158001532 40 Pepin High   Regular School No High 07 12 2018   grade_8                                                   17                                             17
3098769 WI Lafayette   school 5501310 490 Public school Pecatonica Area 550131000182 40 Pecatonica High   Regular School No High 06 12 2018   grade_8                                                   15                                             15
3098750 WI Rock   school 5511130 4151 Public school Parkview 551113001477 120 Parkview Junior High   Regular School No Middle 07 08 2018   grade_8                                                   51                                             51
3098730 WI Kenosha   school 5511400 4235 Public school Paris J1 551140001520 20 Paris Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   36                                             36

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