enrollments

Data source: Big Local News · About: Big Local

698 rows where grade = "grade_6", state = "WI" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 698 ✖

grade ✖

  • grade_6 · 698 ✖
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
326553 326553 WI Dane   school 5500990 350 Public school Belleville 550099000133 60 Belleville Middle   Regular School No Middle 07 08 2017   grade_6                                                   1                                             1
326594 326594 WI Rock   school 5501050 413 Public school Beloit 550105002799 850 Beloit Virtual School   Regular School No Other PK 12 2017   grade_6                                                   1                                             1
327136 327136 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_6                                                   1                                             1
327762 327762 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2017   grade_6                                                   1                                             1
329305 329305 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other PK 12 2017   grade_6                                                   1                                             1
333831 333831 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001236 313 Riley Elementary   Regular School No Elementary PK 05 2017   grade_6                                                   1                                             1
336027 336027 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 2017   grade_6                                                   1                                             1
336078 336078 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2017   grade_6                                                   1                                             1
336964 336964 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606002989 850 Saint Croix Academy of Virtual Education charter Regular School Yes Other KG 12 2017   grade_6                                                   1                                             1
339094 339094 WI Marathon   school 5515900 6223 Public school Wausau 551590002747 400 Enrich Excel Achieve Learning Academy charter Alternative School Yes Other 06 12 2017   grade_6                                                   1                                             1
339327 339327 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002349 190 Plank Road Complex   Alternative School No Other KG 12 2017   grade_6                                                   1                                             1
328078 328078 WI Racine   school 5503750 1449 Public school Dover #1 550375000394 20 Kansasville Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   10                                             10
329101 329101 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537002907 250 Gilmanton Middle   Regular School No Middle 05 08 2017   grade_6                                                   10                                             10
331333 331333 WI Walworth   school 5508040 3087 Public school Linn J4 550804000898 20 Traver Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   10                                             10
335053 335053 WI Washburn   school 5509720 3654 Public school Northwood 550972002934 410 Northwood High/Middle charter Regular School Yes Other 06 12 2017   grade_6                                                   10                                             10
335753 335753 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   10                                             10
336786 336786 WI Pierce   school 5513050 4893 Public school River Falls 551305002562 110 River Falls Public Montessori Academy charter Regular School Yes Elementary PK 06 2017   grade_6                                                   10                                             10
328959 328959 WI Trempealeau   school 5504960 2009 Public school Galesville-Ettrick-Trempealeau 550496000537 50 Galesville-Ettrick-Trempealeau Middle   Regular School No Middle 06 08 2017   grade_6                                                   101                                             101
325643 325643 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2017   grade_6                                                   102                                             102
332185 332185 WI Dane   school 5508910 3381 Public school McFarland 550891002973 160 Wisconsin Virtual Academy K-8 (WIVA) charter Regular School Yes Elementary KG 08 2017   grade_6                                                   102                                             102
329762 329762 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614001282 100 North Shore Middle   Regular School No Middle 06 08 2017   grade_6                                                   103                                             103
334709 334709 WI Waukesha   school 5510470 3925 Public school New Berlin 551047002667 100 Ronald Reagan Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   103                                             103
338336 338336 WI Lincoln   school 5514940 5754 Public school Tomahawk 551494001948 220 Tomahawk Middle   Regular School No Middle 06 08 2017   grade_6                                                   103                                             103
339554 339554 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002106 120 West Milwaukee Intermediate   Regular School No Middle 06 08 2017   grade_6                                                   103                                             103
326576 326576 WI Rock   school 5501050 413 Public school Beloit 550105000137 20 Aldrich Intermediate   Regular School No Elementary 04 08 2017   grade_6                                                   105                                             105
327600 327600 WI Columbia   school 5502820 1183 Public school Columbus 550282000319 20 Columbus Middle   Regular School No Elementary 04 08 2017   grade_6                                                   105                                             105
336683 336683 WI Richland   school 5512960 4851 Public school Richland 551296001708 280 Richland Middle   Regular School No Middle 06 08 2017   grade_6                                                   105                                             105
331395 331395 WI Columbia   school 5508190 3150 Public school Lodi 550819000906 100 Lodi Middle   Regular School No Middle 06 08 2017   grade_6                                                   106                                             106
327010 327010 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2017   grade_6                                                   107                                             107
329107 329107 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Elementary 04 08 2017   grade_6                                                   107                                             107
333200 333200 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong American Peace Academy K3-12 charter Regular School Yes Other PK 12 2017   grade_6                                                   108                                             108
331379 331379 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816002858 100 Little Chute Intermediate   Regular School No Middle 05 06 2017   grade_6                                                   109                                             109
325973 325973 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000054 160 Franklin Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   11                                             11
326823 326823 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001603359 120 SoSET Charter School charter Regular School Yes Elementary KG 06 2017   grade_6                                                   11                                             11
328089 328089 WI Milwaukee   school 5500039 8101 Non District Charter Schools Downtown Montessori 550003902153 1056 Downtown Montessori charter Regular School Yes Elementary PK 08 2017   grade_6                                                   11                                             11
335079 335079 WI Racine   school 5510800 4011 Public school Norway J7 551080001405 20 Drought Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   11                                             11
325781 325781 WI Polk   school 5500300 119 Public school Amery 550030000031 60 Amery Middle   Regular School No Middle 06 08 2017   grade_6                                                   110                                             110
326613 326613 WI Rock   school 5501050 413 Public school Beloit 550105003011 170 Fran Fruzen Intermediate   Regular School No Elementary 04 08 2017   grade_6                                                   110                                             110
331268 331268 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771000888 60 Lake Mills Middle   Regular School No Middle 05 08 2017   grade_6                                                   110                                             110
337561 337561 WI Saint Croix   school 5514010 5432 Public school Somerset 551401001108 60 Somerset Middle   Regular School No Middle 05 08 2017   grade_6                                                   110                                             110
338480 338480 WI Racine   school 5515180 5859 Public school Union Grove J1 551518001964 20 Union Grove Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   110                                             110
326787 326787 WI Jackson   school 5501260 476 Public school Black River Falls 550126000174 60 Black River Falls Middle   Regular School No Middle 06 08 2017   grade_6                                                   111                                             111
331064 331064 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000863 180 Lincoln Middle   Regular School No Middle 06 08 2017   grade_6                                                   111                                             111
328141 328141 WI Walworth   school 5504020 1540 Public school East Troy Community 550402000411 60 East Troy Middle   Regular School No Middle 06 08 2017   grade_6                                                   112                                             112
336984 336984 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606000673 80 Saint Croix Central Middle   Regular School No Middle 05 08 2017   grade_6                                                   112                                             112
333384 333384 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002961 210 King International Baccalaureate Middle   Regular School No Middle 06 08 2017   grade_6                                                   113                                             113
326975 326975 WI Milwaukee   school 5501800 721 Public school Brown Deer 550180000232 80 Brown Deer Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   115                                             115
333726 333726 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001221 52 Morse Mid   Regular School No Other 06 09 2017   grade_6                                                   115                                             115
326683 326683 WI Rock   school 5501080 422 Public school Beloit Turner 550108000159 120 Turner Middle   Regular School No Middle 06 08 2017   grade_6                                                   118                                             118
331476 331476 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834000916 100 Luxemburg-Casco Intermediate   Regular School No Elementary 03 06 2017   grade_6                                                   118                                             118
337379 337379 WI Sheboygan   school 5513680 5278 Public school Sheboygan Falls 551368002289 60 Sheboygan Falls Middle   Regular School No Middle 05 08 2017   grade_6                                                   118                                             118
330882 330882 WI Washington   school 5507380 2800 Public school Kewaskum 550738000838 90 Kewaskum Middle   Regular School No Middle 06 08 2017   grade_6                                                   119                                             119
327070 327070 WI Ashland   school 5501920 840 Public school Butternut 550192000246 40 Butternut High   Regular School No Other 06 12 2017   grade_6                                                   12                                             12
331105 331105 WI La Crosse   school 5507530 2849 Public school La Crosse 550753001295 204 School of Technology and Arts II charter Regular School Yes Middle 06 08 2017   grade_6                                                   12                                             12
331344 331344 WI Walworth   school 5508070 3094 Public school Linn J6 550807000899 20 Reek Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   12                                             12
334626 334626 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes Elementary 04 08 2017   grade_6                                                   12                                             12
337674 337674 WI Monroe   school 5514160 5460 Public school Sparta Area 551416003358 170 Lakeview Montessori School charter Regular School Yes Elementary PK 06 2017   grade_6                                                   12                                             12
339066 339066 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002809 110 Rock River Intermediate   Regular School No Elementary 02 06 2017   grade_6                                                   121                                             121
339998 339998 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002192 80 Winneconne Middle   Regular School No Middle 06 08 2017   grade_6                                                   121                                             121
329947 329947 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002573 210 Greenville Middle   Regular School No Middle 05 08 2017   grade_6                                                   122                                             122
335547 335547 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119001504 500 Webster Stanley Middle   Regular School No Middle 06 08 2017   grade_6                                                   122                                             122
326302 326302 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000096 90 Viking Middle   Regular School No Middle 06 08 2017   grade_6                                                   123                                             123
328314 328314 WI Rock   school 5504110 1568 Public school Edgerton 550411000444 60 Edgerton Middle   Regular School No Middle 06 08 2017   grade_6                                                   123                                             123
334348 334348 WI Marathon   school 5509960 3787 Public school Mosinee 550996001309 120 Mosinee Middle   Regular School No Elementary 04 08 2017   grade_6                                                   123                                             123
328025 328025 WI Brown   school 5503660 1407 Public school Denmark 550366000389 100 Denmark Middle   Regular School No Middle 06 08 2017   grade_6                                                   125                                             125
329796 329796 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627000691 60 Hayward Middle   Regular School No Middle 06 08 2017   grade_6                                                   125                                             125
330376 330376 WI Jefferson   school 5507050 2702 Public school Jefferson 550705000779 60 Jefferson Middle   Regular School No Middle 06 08 2017   grade_6                                                   125                                             125
333542 333542 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001164 176 Meir School   Regular School No Other 03 11 2017   grade_6                                                   126                                             126
335812 335812 WI Grant   school 5511850 4389 Public school Platteville 551185001554 80 Platteville Middle   Regular School No Middle 05 08 2017   grade_6                                                   126                                             126
325768 325768 WI Eau Claire   school 5500270 112 Public school Altoona 550027000027 60 Altoona Middle   Regular School No Middle 06 08 2017   grade_6                                                   127                                             127
328566 328566 WI Rock   school 5504440 1694 Public school Evansville Community 550444000479 60 J C McKenna Middle   Regular School No Middle 06 08 2017   grade_6                                                   129                                             129
326751 326751 WI Washburn   school 5501170 441 Public school Birchwood 550117003374 210 Birchwood Middle   Regular School No Middle 06 08 2017   grade_6                                                   13                                             13
328976 328976 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No Elementary PK 08 2017   grade_6                                                   13                                             13
332464 332464 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2017   grade_6                                                   13                                             13
336350 336350 WI Racine   school 5512360 4620 Public school Racine Unified 551236002997 100 Racine Civil Leaders Academy charter Regular School Yes Elementary PK 07 2017   grade_6                                                   13                                             13
326173 326173 WI Ashland   school 5500510 170 Public school Ashland 550051000074 30 Ashland Middle   Regular School No Middle 06 08 2017   grade_6                                                   130                                             130
335256 335256 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001438 260 Washington Middle   Regular School No Middle 06 08 2017   grade_6                                                   131                                             131
326607 326607 WI Rock   school 5501050 413 Public school Beloit 550105000140 80 Cunningham Intermediate   Regular School No Elementary 04 08 2017   grade_6                                                   133                                             133
335509 335509 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119001501 440 South Park Middle   Regular School No Middle 06 08 2017   grade_6                                                   134                                             134
335870 335870 WI Sheboygan   school 5511940 4473 Public school Plymouth Joint 551194001563 120 Riverview Middle   Regular School No Middle 05 08 2017   grade_6                                                   136                                             136
338436 338436 WI Manitowoc   school 5515120 5824 Public school Two Rivers Public 551512001960 50 Clarke Middle   Regular School No Middle 05 08 2017   grade_6                                                   136                                             136
326633 326633 WI Rock   school 5501050 413 Public school Beloit 550105002330 180 McNeel Intermediate   Regular School No Elementary 04 08 2017   grade_6                                                   139                                             139
327222 327222 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   14                                             14
329224 329224 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other 06 12 2017   grade_6                                                   14                                             14
335411 335411 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes Elementary 04 08 2017   grade_6                                                   14                                             14
337613 337613 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   14                                             14
338214 338214 WI Oneida   school 5514850 5733 Public school Three Lakes 551485001927 40 Sugar Camp Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   14                                             14
339073 339073 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002903 150 School for Agricultural and Environmental Studies charter Regular School Yes Elementary PK 08 2017   grade_6                                                   14                                             14
339722 339722 WI Marquette   school 5516440 6335 Public school Westfield 551644002149 60 Oxford Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   14                                             14
328453 328453 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000463 20 Ellsworth Middle   Regular School No Middle 05 08 2017   grade_6                                                   140                                             140
340044 340044 WI Sauk   school 5517040 6678 Public school Wisconsin Dells 551704002271 200 Spring Hill Middle   Regular School No Middle 06 08 2017   grade_6                                                   140                                             140
328922 328922 WI Outagamie   school 5504920 1953 Public school Freedom Area 550492000534 40 Freedom Middle   Regular School No Middle 06 08 2017   grade_6                                                   141                                             141
335405 335405 WI Polk   school 5511160 4165 Public school Osceola 551116002319 80 Osceola Middle   Regular School No Middle 06 08 2017   grade_6                                                   141                                             141
331073 331073 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000864 200 Logan Middle   Regular School No Middle 06 08 2017   grade_6                                                   144                                             144
331502 331502 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000959 690 Black Hawk Middle   Regular School No Middle 06 08 2017   grade_6                                                   144                                             144
328750 328750 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000504 300 Sabish Middle   Regular School No Middle 06 08 2017   grade_6                                                   145                                             145
339053 339053 WI Waupaca   school 5515840 6195 Public school Waupaca 551584002036 150 Waupaca Middle   Regular School No Middle 05 08 2017   grade_6                                                   145                                             145
339675 339675 WI La Crosse   school 5516350 6370 Public school West Salem 551635002324 100 West Salem Middle   Regular School No Middle 06 08 2017   grade_6                                                   145                                             145
329169 329169 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002249 60 John Long Middle   Regular School No Middle 06 08 2017   grade_6                                                   146                                             146
332429 332429 WI Ozaukee   school 5509130 3479 Public school Mequon-Thiensville 550913001086 80 Lake Shore Middle   Regular School No Middle 06 08 2017   grade_6                                                   148                                             148

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