enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
2326079 2326079 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2020   grade_8                                                   216                                             216
2321663 2321663 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2020   grade_8                                                   131                                             131
2327092 2327092 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2020   grade_8                                                   191                                             191
2328391 2328391 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   8                                             8
2330429 2330429 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Middle 07 09 2020   grade_8                                                   263                                             263
2331396 2331396 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566001989 10 Fox River Middle   Regular School No Middle 07 08 2020   grade_8                                                   195                                             195
2332244 2332244 WI Washington   school 5516290 6307 Public school West Bend 551629002125 10 Badger Middle   Regular School No Middle 07 08 2020   grade_8                                                   454                                             454
2319313 2319313 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2020   grade_8                                                   44                                             44
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
2318855 2318855 WI Sauk   school 5500810 280 Public school Baraboo 550081000102 20 Jack Young Middle   Regular School No Middle 06 08 2020   grade_8                                                   239                                             239
2318971 2318971 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000122 20 Beaver Dam Middle   Regular School No Middle 06 08 2020   grade_8                                                   233                                             233
2319076 2319076 WI Rock   school 5501050 413 Public school Beloit 550105000137 20 Aldrich Intermediate   Regular School No Middle 04 08 2020   grade_8                                                   108                                             108
2319421 2319421 WI Kenosha   school 5501650 657 Public school Brighton #1 550165000205 20 Brighton Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   24                                             24
2319450 2319450 WI Kenosha   school 5501710 665 Public school Bristol #1 550171000209 20 Bristol Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   97                                             97
2320032 2320032 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000301 20 Clintonville Middle   Regular School No Middle 05 08 2020   grade_8                                                   63                                             63
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
2320620 2320620 WI Racine   school 5503750 1449 Public school Dover #1 550375000394 20 Kansasville Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   11                                             11
2320924 2320924 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000452 20 Elk Mound Middle   Regular School No Middle 05 08 2020   grade_8                                                   109                                             109
2320941 2320941 WI Sheboygan   school 5504260 1631 Public school Elkhart Lake-Glenbeulah 550426000455 20 Elkhart Lake Elementary/Middle   Regular School No Elementary PK 08 2020   grade_8                                                   37                                             37
2321022 2321022 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000463 20 Ellsworth Middle   Regular School No Middle 06 08 2020   grade_8                                                   123                                             123
2321109 2321109 WI Washington   school 5504410 1687 Public school Erin 550441000476 20 Erin Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   41                                             41
2321342 2321342 WI Walworth   school 5504720 1870 Public school Fontana J8 550472000508 20 Fontana Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   28                                             28
2321391 2321391 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000517 20 Bayside Middle   Regular School No Middle 05 08 2020   grade_8                                                   82                                             82
2321532 2321532 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   14                                             14
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
2322265 2322265 WI Washington   school 5506090 2443 Public school Hartford J1 550609000674 20 Central Middle   Regular School No Middle 06 08 2020   grade_8                                                   177                                             177
2322733 2322733 WI Iowa   school 5506870 2646 Public school Iowa-Grant 550687000744 20 Iowa-Grant Elementary/Middle   Regular School No Elementary PK 08 2020   grade_8                                                   47                                             47
2322992 2322992 WI Green   school 5507230 2737 Public school Juda 550723000784 20 Juda Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   24                                             24
2323486 2323486 WI Vernon   school 5512540 5960 Public school Kickapoo Area 551254001658 20 Kickapoo High   Regular School No High 06 12 2020   grade_8                                                   43                                             43
2323746 2323746 WI Vilas   school 5504620 1848 Public school Lac du Flambeau #1 550462000488 20 Lac du Flambeau Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   52                                             52
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
2323908 2323908 WI Forest   school 5507830 2940 Public school Laona 550783000893 20 Laona High   Regular School No High 07 12 2020   grade_8                                                   23                                             23
2323946 2323946 WI Walworth   school 5508040 3087 Public school Linn J4 550804000898 20 Traver Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   7                                             7
2323958 2323958 WI Walworth   school 5508070 3094 Public school Linn J6 550807000899 20 Reek Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   15                                             15
2324754 2324754 WI Juneau   school 5508850 3360 Public school Mauston 550885001026 20 Olson Middle   Regular School No Middle 06 08 2020   grade_8                                                   103                                             103
2324936 2324936 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903001053 20 Maplewood Middle   Regular School No Middle 06 08 2020   grade_8                                                   228                                             228
2325162 2325162 WI Waukesha   school 5509360 3528 Public school Merton Community 550936002269 20 Merton Intermediate   Regular School No Middle 05 08 2020   grade_8                                                   106                                             106
2326770 2326770 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969001278 20 Minocqua Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   47                                             47
2327232 2327232 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2020   grade_8                                                   67                                             67
2327497 2327497 WI Waukesha   school 5510710 3976 Public school Norris 551071001395 20 Norris Academy   Regular School No Other KG 12 2020   grade_8                                                   1                                             1
2327514 2327514 WI Racine   school 5512510 4690 Public school North Cape 551251001657 20 North Cape Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   14                                             14
2327538 2327538 WI Fond du Lac   school 5510740 3983 Public school North Fond du Lac 551074001396 20 Bessie Allen Middle   Regular School No Middle 06 08 2020   grade_8                                                   114                                             114
2327571 2327571 WI Waukesha   school 5509300 3514 Public school North Lake 550930002268 20 North Lake Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   46                                             46
2327705 2327705 WI Monroe   school 5510770 3990 Public school Norwalk-Ontario-Wilton 551077001402 20 Brookwood High   Regular School No High 07 12 2020   grade_8                                                   42                                             42
2327725 2327725 WI Racine   school 5510800 4011 Public school Norway J7 551080001405 20 Drought Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   9                                             9
2328280 2328280 WI Kenosha   school 5511400 4235 Public school Paris J1 551140001520 20 Paris Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   29                                             29
2328435 2328435 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   41                                             41
2329050 2329050 WI Kenosha   school 5512390 4627 Public school Randall J1 551239001649 20 Randall Consolidated School   Regular School No Elementary PK 08 2020   grade_8                                                   82                                             82
2329062 2329062 WI Dodge   school 5512420 4634 Public school Randolph 551242001650 20 Randolph Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   49                                             49
2329088 2329088 WI Sheboygan   school 5512450 4641 Public school Random Lake 551245002421 20 Random Lake Middle   Regular School No Middle 05 08 2020   grade_8                                                   58                                             58
2329097 2329097 WI Racine   school 5512480 4686 Public school Raymond #14 551248001656 20 Raymond Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   50                                             50
2329303 2329303 WI Waukesha   school 5508130 3122 Public school Richmond 550813002262 20 Richmond Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   51                                             51
2329614 2329614 WI Milwaukee   school 5513260 5026 Public school Saint Francis 551326001747 20 Deer Creek Intermediate   Regular School No Middle 04 08 2020   grade_8                                                   80                                             80
2329635 2329635 WI Kenosha   school 5513350 5068 Public school Salem 551335001753 20 Salem Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   124                                             124
2329741 2329741 WI Outagamie   school 5513530 5138 Public school Seymour Community 551353001769 20 Black Creek Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   35                                             35
2329770 2329770 WI Walworth   school 5513560 5258 Public school Sharon J11 551356001774 20 Sharon Community   Regular School No Elementary PK 08 2020   grade_8                                                   29                                             29
2330003 2330003 WI Outagamie   school 5513770 5348 Public school Shiocton 551377001807 20 Shiocton Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   58                                             58
2330068 2330068 WI Kenosha   school 5513860 5369 Public school Silver Lake J1 551386001815 20 Riverview Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   54                                             54
2330548 2330548 WI Waukesha   school 5509390 3542 Public school Stone Bank 550939002270 20 Stone Bank Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   38                                             38
2330829 2330829 WI Waukesha   school 5509240 3510 Public school Swallow 550924002267 20 Swallow Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   60                                             60
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
2331048 2331048 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2020   grade_8                                                   55                                             55
2331101 2331101 WI Kenosha   school 5515090 5817 Public school Twin Lakes #4 551509001957 20 Lakewood Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   35                                             35
2331153 2331153 WI Racine   school 5515180 5859 Public school Union Grove J1 551518001964 20 Union Grove Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   80                                             80
2331337 2331337 WI Walworth   school 5515450 6022 Public school Walworth J1 551545001981 20 Walworth Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   32                                             32
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
2331381 2331381 WI Racine   school 5515700 6104 Public school Washington-Caldwell 551570001993 20 Washington Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   16                                             16
2332462 2332462 WI Kenosha   school 5516560 6412 Public school Wheatland J1 551656002163 20 Wheatland Center Elementary   Regular School No Elementary PK 08 2020   grade_8                                                   61                                             61
2332573 2332573 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002178 20 Whitewater Middle   Regular School No Middle 06 08 2020   grade_8                                                   118                                             118
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
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
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
2319350 2319350 WI Shawano   school 5501470 602 Public school Bonduel 550147002383 21 Bonduel Middle   Regular School No Middle 07 08 2020   grade_8                                                   44                                             44
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
2320180 2320180 WI Forest   school 5502910 1218 Public school Crandon 550291002388 22 Crandon Middle   Regular School No Middle 06 08 2020   grade_8                                                   65                                             65
2320225 2320225 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306002389 22 Cudahy Middle   Regular School No Middle 06 08 2020   grade_8                                                   172                                             172
2320853 2320853 WI Marathon   school 5504080 1561 Public school Edgar 550408002391 23 Edgar Middle   Regular School No Middle 06 08 2020   grade_8                                                   49                                             49
2320585 2320585 WI Dodge   school 5507260 2744 Public school Dodgeland 550726002983 25 Dodgeland Middle   Regular School No Middle 06 08 2020   grade_8                                                   59                                             59
2324623 2324623 WI Green Lake   school 5508760 3325 Public school Markesan 550876002414 25 Markesan Middle   Regular School No Middle 06 08 2020   grade_8                                                   60                                             60
2328204 2328204 WI Trempealeau   school 5511220 4186 Public school Osseo-Fairchild 551122002398 26 Osseo-Fairchild Middle   Regular School No Middle 06 08 2020   grade_8                                                   66                                             66
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
2330059 2330059 WI Lafayette   school 5513830 5362 Public school Shullsburg 551383002400 28 Shullsburg Junior High   Regular School No Middle 06 08 2020   grade_8                                                   33                                             33
2332513 2332513 WI Milwaukee   school 5516620 6419 Public school Whitefish Bay 551662002402 29 Whitefish Bay Middle   Regular School No Middle 06 08 2020   grade_8                                                   217                                             217
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
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
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
2320216 2320216 WI Grant   school 5503030 1246 Public school Cuba City 550303003103 30 Cuba City Middle   Regular School No Middle 06 08 2020   grade_8                                                   41                                             41
2320321 2320321 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001735 30 D C Everest Junior High   Regular School No Secondary 08 09 2020   grade_8                                                   429                                             429
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
2321099 2321099 WI Pierce   school 5504350 1666 Public school Elmwood 550435000347 30 Elmwood Middle   Regular School No Middle 05 08 2020   grade_8                                                   26                                             26
2322529 2322529 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002408 30 Hortonville Middle   Regular School No Middle 05 08 2020   grade_8                                                   137                                             137
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
2323776 2323776 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2020   grade_8                                                   59                                             59
2325197 2325197 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001104 30 Kromrey Middle   Regular School No Middle 05 08 2020   grade_8                                                   294                                             294
2326939 2326939 WI Green   school 5509900 3696 Public school Monticello 550990000384 30 Monticello Middle   Regular School No Middle 06 08 2020   grade_8                                                   23                                             23
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
2328253 2328253 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002418 30 Palmyra-Eagle Middle   Regular School No Middle 07 08 2020   grade_8                                                   57                                             57
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
2329504 2329504 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310001728 30 Brandon Middle   Regular School No Middle 06 08 2020   grade_8                                                   28                                             28
2329729 2329729 WI Door   school 5513500 5130 Public school Sevastopol 551350000496 30 Sevastopol Middle   Regular School No Middle 06 08 2020   grade_8                                                   40                                             40

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