enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_8 · 4,744 ✖
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
126380 126380 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   74                                             74
296317 296317 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No 1.0 PK 08 2016   grade_8                                                   68                                             68
340258 340258 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2017   grade_8                                                   70                                             70
2332923 2332923 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   55                                             55
2347929 2347929 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   64                                             64
3088634 3088634 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   74                                             74
3103336 3103336 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   69                                             69
126371 126371 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2015   grade_8                                                   108                                             108
296308 296308 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No 2.0 05 08 2016   grade_8                                                   108                                             108
340249 340249 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2017   grade_8                                                   102                                             102
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
2347920 2347920 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2021   grade_8                                                   88                                             88
3088625 3088625 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2019   grade_8                                                   92                                             92
3103327 3103327 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2018   grade_8                                                   94                                             94
126350 126350 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   64                                             64
296288 296288 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No 1.0 PK 08 2016   grade_8                                                   56                                             56
340228 340228 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2017   grade_8                                                   56                                             56
2332892 2332892 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   55                                             55
2347899 2347899 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   54                                             54
3088603 3088603 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   58                                             58
3103306 3103306 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   59                                             59
2332881 2332881 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2020   grade_8                                                   24                                             24
2347888 2347888 WI Milwaukee   school 5500070 8132 Non District Charter Schools Woodlands School - State Street Campus 550007002942 100 Woodlands School - State Street Campus charter Regular School Yes Elementary PK 08 2021   grade_8                                                   35                                             35
126333 126333 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2015   grade_8                                                   32                                             32
296270 296270 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes 1.0 PK 08 2016   grade_8                                                   34                                             34
340209 340209 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2017   grade_8                                                   33                                             33
2332870 2332870 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2020   grade_8                                                   37                                             37
2347877 2347877 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2021   grade_8                                                   34                                             34
3088582 3088582 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2019   grade_8                                                   35                                             35
3103286 3103286 WI Milwaukee   school 5500113 8113 Non District Charter Schools Woodlands School 550011303353 8728 Woodlands School charter Regular School Yes Elementary PK 08 2018   grade_8                                                   36                                             36
126324 126324 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No 2.0 06 08 2015   grade_8                                                   28                                             28
296261 296261 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No 2.0 06 08 2016   grade_8                                                   17                                             17
340200 340200 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2017   grade_8                                                   30                                             30
2332859 2332859 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2020   grade_8                                                   30                                             30
2347854 2347854 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2021   grade_8                                                   26                                             26
2347866 2347866 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_8                                                   3                                             3
3088570 3088570 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2019   grade_8                                                   18                                             18
3103275 3103275 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002226 100 Wonewoc-Center Junior High   Regular School No Middle 06 08 2018   grade_8                                                   23                                             23
126285 126285 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   28                                             28
126296 126296 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2015   grade_8                                                   47                                             47
296223 296223 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No 1.0 PK 08 2016   grade_8                                                   37                                             37
296234 296234 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No 1.0 PK 08 2016   grade_8                                                   41                                             41
340163 340163 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2017   grade_8                                                   43                                             43
340174 340174 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2017   grade_8                                                   43                                             43
2332822 2332822 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   30                                             30
2332833 2332833 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   48                                             48
2347812 2347812 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   42                                             42
2347823 2347823 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2021   grade_8                                                   43                                             43
3088532 3088532 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   33                                             33
3088543 3088543 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2019   grade_8                                                   45                                             45
3103237 3103237 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   39                                             39
3103248 3103248 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002223 120 Wittenberg Elementary   Regular School No Elementary PK 08 2018   grade_8                                                   50                                             50
126195 126195 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No 4.0 08 09 2015   grade_8                                                   374                                             374
296133 296133 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No 4.0 08 09 2016   grade_8                                                   362                                             362
340072 340072 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No Other 08 09 2017   grade_8                                                   343                                             343
2332737 2332737 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003088 190 Central Oaks Academy   Regular School No Elementary PK 08 2020   grade_8                                                   12                                             12
2332801 2332801 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2020   grade_8                                                   355                                             355
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
3088448 3088448 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003088 190 Central Oaks Academy   Regular School No Elementary PK 08 2019   grade_8                                                   12                                             12
3088511 3088511 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002216 290 Wisconsin Rapids Area Middle   Regular School No Middle 06 08 2019   grade_8                                                   333                                             333
3103146 3103146 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002291 50 East Junior High   Regular School No Secondary 08 09 2018   grade_8                                                   366                                             366
126193 126193 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No 2.0 06 08 2015   grade_8                                                   70                                             70
296131 296131 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No 2.0 06 08 2016   grade_8                                                   54                                             54
340070 340070 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2017   grade_8                                                   59                                             59
2332728 2332728 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2020   grade_8                                                   45                                             45
2347719 2347719 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2021   grade_8                                                   45                                             45
3088439 3088439 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2019   grade_8                                                   51                                             51
3103144 3103144 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000609 80 Wisconsin Heights Middle   Regular School No Middle 06 08 2018   grade_8                                                   47                                             47
126169 126169 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No 2.0 06 08 2015   grade_8                                                   106                                             106
296107 296107 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No 2.0 06 08 2016   grade_8                                                   131                                             131
340046 340046 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No Middle 06 08 2017   grade_8                                                   119                                             119
2332704 2332704 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No Middle 06 08 2020   grade_8                                                   155                                             155
2347700 2347700 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Wisconsin Dells Middle School   Regular School No Middle 06 08 2021   grade_8                                                   136                                             136
3088415 3088415 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No Middle 06 08 2019   grade_8                                                   146                                             146
3103120 3103120 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No Middle 06 08 2018   grade_8                                                   139                                             139
126141 126141 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No 2.0 06 08 2015   grade_8                                                   21                                             21
296079 296079 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No 2.0 06 08 2016   grade_8                                                   22                                             22
340018 340018 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No Middle 06 08 2017   grade_8                                                   18                                             18
2332676 2332676 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No Middle 06 08 2020   grade_8                                                   19                                             19
2347667 2347667 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No Middle 06 08 2021   grade_8                                                   23                                             23
3088387 3088387 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No Middle 06 08 2019   grade_8                                                   18                                             18
3103092 3103092 WI Sawyer   school 5516860 6615 Public school Winter 551686002315 100 Winter Middle   Regular School No Middle 06 08 2018   grade_8                                                   13                                             13
126123 126123 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No 2.0 06 08 2015   grade_8                                                   117                                             117
296061 296061 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No 2.0 06 08 2016   grade_8                                                   131                                             131
340000 340000 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2017   grade_8                                                   130                                             130
2332659 2332659 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2020   grade_8                                                   130                                             130
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
3088370 3088370 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2019   grade_8                                                   132                                             132
3103075 3103075 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2018   grade_8                                                   119                                             119
126101 126101 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Junior High   Regular School No 2.0 07 08 2015   grade_8                                                   45                                             45
296038 296038 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No 2.0 06 08 2016   grade_8                                                   52                                             52
339977 339977 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No Middle 06 08 2017   grade_8                                                   56                                             56
2332636 2332636 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No Middle 06 08 2020   grade_8                                                   53                                             53
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
3088347 3088347 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No Middle 06 08 2019   grade_8                                                   54                                             54
3103052 3103052 WI Walworth   school 5516740 6482 Public school Williams Bay 551674000277 30 Williams Bay Middle   Regular School No Middle 06 08 2018   grade_8                                                   56                                             56
126083 126083 WI Waushara   school 5516710 6475 Public school Wild Rose 551671002185 60 Wild Rose High   Regular School No 4.0 06 12 2015   grade_8                                                   33                                             33
296018 296018 WI Waushara   school 5516710 6475 Public school Wild Rose 551671002185 60 Wild Rose High   Regular School No 4.0 06 12 2016   grade_8                                                   59                                             59
339958 339958 WI Waushara   school 5516710 6475 Public school Wild Rose 551671002185 60 Wild Rose High   Regular School No Other 06 12 2017   grade_8                                                   38                                             38

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