enrollments

Data source: Big Local News · About: Big Local

675 rows where grade = "grade_7", state = "WI" and year = 2019 sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2019 · 675 ✖

grade ✖

  • grade_7 · 675 ✖
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
3081833 3081833 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2019   grade_7                                                   216                                             216
3077423 3077423 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2019   grade_7                                                   123                                             123
3082860 3082860 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2019   grade_7                                                   190                                             190
3084140 3084140 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   9                                             9
3086138 3086138 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449001868 10 Benjamin Franklin Junior High   Regular School No Middle 07 09 2019   grade_7                                                   267                                             267
3087092 3087092 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566001989 10 Fox River Middle   Regular School No Middle 07 08 2019   grade_7                                                   184                                             184
3087954 3087954 WI Washington   school 5516290 6307 Public school West Bend 551629002125 10 Badger Middle   Regular School No Middle 07 08 2019   grade_7                                                   454                                             454
3075099 3075099 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602378 11 Blair-Taylor Middle/High   Regular School No High 07 12 2019   grade_7                                                   42                                             42
3081144 3081144 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001218 14 Bradley Technology High   Regular School No High 09 12 2019   grade_7                                                   1                                             1
3073987 3073987 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   13                                             13
3074626 3074626 WI Sauk   school 5500810 280 Public school Baraboo 550081000102 20 Jack Young Middle   Regular School No Middle 06 08 2019   grade_7                                                   238                                             238
3074746 3074746 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000122 20 Beaver Dam Middle   Regular School No Middle 06 08 2019   grade_7                                                   237                                             237
3074852 3074852 WI Rock   school 5501050 413 Public school Beloit 550105000137 20 Aldrich Intermediate   Regular School No Middle 04 08 2019   grade_7                                                   108                                             108
3075206 3075206 WI Kenosha   school 5501650 657 Public school Brighton #1 550165000205 20 Brighton Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   22                                             22
3075235 3075235 WI Kenosha   school 5501710 665 Public school Bristol #1 550171000209 20 Bristol Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   99                                             99
3075808 3075808 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000301 20 Clintonville Middle   Regular School No Middle 05 08 2019   grade_7                                                   64                                             64
3075910 3075910 WI Columbia   school 5502820 1183 Public school Columbus 550282000319 20 Columbus Middle   Regular School No Middle 06 08 2019   grade_7                                                   88                                             88
3076396 3076396 WI Racine   school 5503750 1449 Public school Dover #1 550375000394 20 Kansasville Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   9                                             9
3076684 3076684 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000452 20 Elk Mound Middle   Regular School No Middle 05 08 2019   grade_7                                                   113                                             113
3076701 3076701 WI Sheboygan   school 5504260 1631 Public school Elkhart Lake-Glenbeulah 550426000455 20 Elkhart Lake Elementary/Middle   Regular School No Elementary PK 08 2019   grade_7                                                   36                                             36
3076782 3076782 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000463 20 Ellsworth Middle   Regular School No Middle 06 08 2019   grade_7                                                   123                                             123
3076868 3076868 WI Washington   school 5504410 1687 Public school Erin 550441000476 20 Erin Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   41                                             41
3077102 3077102 WI Walworth   school 5504720 1870 Public school Fontana J8 550472000508 20 Fontana Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   30                                             30
3077151 3077151 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000517 20 Bayside Middle   Regular School No Middle 05 08 2019   grade_7                                                   83                                             83
3077292 3077292 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   17                                             17
3077544 3077544 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 2019   grade_7                                                   64                                             64
3078015 3078015 WI Washington   school 5506090 2443 Public school Hartford J1 550609000674 20 Central Middle   Regular School No Middle 06 08 2019   grade_7                                                   177                                             177
3078482 3078482 WI Iowa   school 5506870 2646 Public school Iowa-Grant 550687000744 20 Iowa-Grant Elementary/Middle   Regular School No Elementary PK 08 2019   grade_7                                                   49                                             49
3078740 3078740 WI Green   school 5507230 2737 Public school Juda 550723000784 20 Juda Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   24                                             24
3079235 3079235 WI Vernon   school 5512540 5960 Public school Kickapoo Area 551254001658 20 Kickapoo High   Regular School No High 06 12 2019   grade_7                                                   43                                             43
3079491 3079491 WI Vilas   school 5504620 1848 Public school Lac du Flambeau #1 550462000488 20 Lac du Flambeau Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   49                                             49
3079566 3079566 WI Chippewa   school 5507680 2891 Public school Lake Holcombe 550768000885 20 Holcombe Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   22                                             22
3079637 3079637 WI Forest   school 5507830 2940 Public school Laona 550783000893 20 Laona High   Regular School No High 07 12 2019   grade_7                                                   20                                             20
3079674 3079674 WI Walworth   school 5508040 3087 Public school Linn J4 550804000898 20 Traver Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   7                                             7
3079686 3079686 WI Walworth   school 5508070 3094 Public school Linn J6 550807000899 20 Reek Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   17                                             17
3080367 3080367 WI Dane   school 5508790 3332 Public school Marshall 550879001012 20 Marshall Elementary   Regular School No Elementary 03 06 2019   grade_7                                                   6                                             6
3080481 3080481 WI Juneau   school 5508850 3360 Public school Mauston 550885001026 20 Olson Middle   Regular School No Middle 06 08 2019   grade_7                                                   107                                             107
3080664 3080664 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903001053 20 Maplewood Middle   Regular School No Middle 06 08 2019   grade_7                                                   242                                             242
3080889 3080889 WI Waukesha   school 5509360 3528 Public school Merton Community 550936002269 20 Merton Intermediate   Regular School No Middle 05 08 2019   grade_7                                                   106                                             106
3082539 3082539 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969001278 20 Minocqua Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   46                                             46
3082986 3082986 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2019   grade_7                                                   57                                             57
3083254 3083254 WI Waukesha   school 5510710 3976 Public school Norris 551071001395 20 Norris Academy   Regular School No Other 03 12 2019   grade_7                                                   2                                             2
3083267 3083267 WI Racine   school 5512510 4690 Public school North Cape 551251001657 20 North Cape Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   14                                             14
3083290 3083290 WI Fond du Lac   school 5510740 3983 Public school North Fond du Lac 551074001396 20 Bessie Allen Middle   Regular School No Middle 06 08 2019   grade_7                                                   109                                             109
3083314 3083314 WI Waukesha   school 5509300 3514 Public school North Lake 550930002268 20 North Lake Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   44                                             44
3083442 3083442 WI Monroe   school 5510770 3990 Public school Norwalk-Ontario-Wilton 551077001402 20 Brookwood High   Regular School No High 07 12 2019   grade_7                                                   45                                             45
3083462 3083462 WI Racine   school 5510800 4011 Public school Norway J7 551080001405 20 Drought Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   9                                             9
3084030 3084030 WI Kenosha   school 5511400 4235 Public school Paris J1 551140001520 20 Paris Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   28                                             28
3084174 3084174 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   42                                             42
3084784 3084784 WI Kenosha   school 5512390 4627 Public school Randall J1 551239001649 20 Randall Consolidated School   Regular School No Elementary PK 08 2019   grade_7                                                   87                                             87
3084796 3084796 WI Dodge   school 5512420 4634 Public school Randolph 551242001650 20 Randolph Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   47                                             47
3084822 3084822 WI Sheboygan   school 5512450 4641 Public school Random Lake 551245002421 20 Random Lake Middle   Regular School No Middle 05 08 2019   grade_7                                                   59                                             59
3084831 3084831 WI Racine   school 5512480 4686 Public school Raymond #14 551248001656 20 Raymond Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   46                                             46
3085032 3085032 WI Waukesha   school 5508130 3122 Public school Richmond 550813002262 20 Richmond Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   51                                             51
3085336 3085336 WI Milwaukee   school 5513260 5026 Public school Saint Francis 551326001747 20 Deer Creek Intermediate   Regular School No Middle 04 08 2019   grade_7                                                   83                                             83
3085357 3085357 WI Kenosha   school 5513350 5068 Public school Salem 551335001753 20 Salem Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   119                                             119
3085469 3085469 WI Outagamie   school 5513530 5138 Public school Seymour Community 551353001769 20 Black Creek Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   36                                             36
3085498 3085498 WI Walworth   school 5513560 5258 Public school Sharon J11 551356001774 20 Sharon Community   Regular School No Elementary PK 08 2019   grade_7                                                   29                                             29
3085732 3085732 WI Outagamie   school 5513770 5348 Public school Shiocton 551377001807 20 Shiocton Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   56                                             56
3085799 3085799 WI Kenosha   school 5513860 5369 Public school Silver Lake J1 551386001815 20 Riverview Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   52                                             52
3086256 3086256 WI Waukesha   school 5509390 3542 Public school Stone Bank 550939002270 20 Stone Bank Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   36                                             36
3086533 3086533 WI Waukesha   school 5509240 3510 Public school Swallow 550924002267 20 Swallow Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   58                                             58
3086544 3086544 WI Clark   school 5514820 5726 Public school Thorp 551482001925 20 Thorp Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   47                                             47
3086743 3086743 WI Kenosha   school 5500052 5780 Public school Trevor-Wilmot Consolidated 550005202644 20 Trevor-Wilmot Grade   Regular School No Elementary PK 08 2019   grade_7                                                   58                                             58
3086798 3086798 WI Kenosha   school 5515090 5817 Public school Twin Lakes #4 551509001957 20 Lakewood Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   31                                             31
3086851 3086851 WI Racine   school 5515180 5859 Public school Union Grove J1 551518001964 20 Union Grove Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   76                                             76
3087033 3087033 WI Walworth   school 5515450 6022 Public school Walworth J1 551545001981 20 Walworth Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   38                                             38
3087053 3087053 WI Bayfield   school 5515540 6027 Public school Washburn 551554001984 20 Washburn Middle   Regular School No Middle 07 08 2019   grade_7                                                   53                                             53
3087077 3087077 WI Racine   school 5515700 6104 Public school Washington-Caldwell 551570001993 20 Washington Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   15                                             15
3088179 3088179 WI Kenosha   school 5516560 6412 Public school Wheatland J1 551656002163 20 Wheatland Center Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   52                                             52
3088283 3088283 WI Walworth   school 5516680 6461 Public school Whitewater Unified 551668002178 20 Whitewater Middle   Regular School No Middle 06 08 2019   grade_7                                                   120                                             120
3088531 3088531 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   33                                             33
3088602 3088602 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   54                                             54
3088633 3088633 WI Racine   school 5517220 6748 Public school Yorkville J2 551722002230 20 Yorkville Elementary   Regular School No Elementary PK 08 2019   grade_7                                                   52                                             52
3075136 3075136 WI Shawano   school 5501470 602 Public school Bonduel 550147002383 21 Bonduel Middle   Regular School No Middle 07 08 2019   grade_7                                                   45                                             45
3075226 3075226 WI Calumet   school 5501680 658 Public school Brillion 550168002384 21 Brillion Middle   Regular School No Middle 06 08 2019   grade_7                                                   73                                             73
3075951 3075951 WI Forest   school 5502910 1218 Public school Crandon 550291002388 22 Crandon Middle   Regular School No Middle 06 08 2019   grade_7                                                   71                                             71
3075996 3075996 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306002389 22 Cudahy Middle   Regular School No Middle 06 08 2019   grade_7                                                   165                                             165
3076615 3076615 WI Marathon   school 5504080 1561 Public school Edgar 550408002391 23 Edgar Middle   Regular School No Middle 06 08 2019   grade_7                                                   44                                             44
3076362 3076362 WI Dodge   school 5507260 2744 Public school Dodgeland 550726002983 25 Dodgeland Middle   Regular School No Middle 06 08 2019   grade_7                                                   60                                             60
3080345 3080345 WI Green Lake   school 5508760 3325 Public school Markesan 550876002414 25 Markesan Middle   Regular School No Middle 06 08 2019   grade_7                                                   62                                             62
3083955 3083955 WI Trempealeau   school 5511220 4186 Public school Osseo-Fairchild 551122002398 26 Osseo-Fairchild Middle   Regular School No Middle 06 08 2019   grade_7                                                   64                                             64
3085441 3085441 WI Crawford   school 5513470 5124 Public school Seneca Area 551347002399 28 Seneca Junior High   Regular School No Middle 06 08 2019   grade_7                                                   25                                             25
3085790 3085790 WI Lafayette   school 5513830 5362 Public school Shullsburg 551383002400 28 Shullsburg Junior High   Regular School No Middle 06 08 2019   grade_7                                                   34                                             34
3088229 3088229 WI Milwaukee   school 5516620 6419 Public school Whitefish Bay 551662002402 29 Whitefish Bay Middle   Regular School No Middle 06 08 2019   grade_7                                                   217                                             217
3074444 3074444 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2019   grade_7                                                   152                                             152
3074727 3074727 WI Bayfield   school 5500900 315 Public school Bayfield 550090000082 30 Bayfield Middle   Regular School No Middle 06 08 2019   grade_7                                                   18                                             18
3075690 3075690 WI Calumet   school 5502520 1085 Public school Chilton 550252002430 30 Chilton Middle   Regular School No Middle 05 08 2019   grade_7                                                   93                                             93
3075987 3075987 WI Grant   school 5503030 1246 Public school Cuba City 550303003103 30 Cuba City Middle   Regular School No Middle 06 08 2019   grade_7                                                   41                                             41
3076222 3076222 WI Brown   school 5503210 1414 Public school De Pere 550321000362 30 De Pere Middle   Regular School No Middle 07 08 2019   grade_7                                                   326                                             326
3076859 3076859 WI Pierce   school 5504350 1666 Public school Elmwood 550435000347 30 Elmwood Middle   Regular School No Middle 05 08 2019   grade_7                                                   25                                             25
3078279 3078279 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002408 30 Hortonville Middle   Regular School No Middle 05 08 2019   grade_7                                                   129                                             129
3078302 3078302 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000717 30 Bay View Middle   Regular School No Middle 07 08 2019   grade_7                                                   458                                             458
3079522 3079522 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2019   grade_7                                                   60                                             60
3080928 3080928 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001104 30 Kromrey Middle   Regular School No Middle 05 08 2019   grade_7                                                   291                                             291
3082706 3082706 WI Green   school 5509900 3696 Public school Monticello 550990000384 30 Monticello Middle   Regular School No Middle 06 08 2019   grade_7                                                   23                                             23
3084004 3084004 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135002418 30 Palmyra-Eagle Middle   Regular School No Middle 07 08 2019   grade_7                                                   58                                             58
3084440 3084440 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218000445 30 Prairie Farm Middle   Regular School No Middle 06 08 2019   grade_7                                                   37                                             37
3085221 3085221 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310001728 30 Brandon Middle   Regular School No Middle 06 08 2019   grade_7                                                   27                                             27
3085457 3085457 WI Door   school 5513500 5130 Public school Sevastopol 551350000496 30 Sevastopol Middle   Regular School No Middle 06 08 2019   grade_7                                                   42                                             42

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