enrollments

Data source: Big Local News · About: Big Local

4,960 rows where grade = "grade_6" and state = "WI" sorted by school_state_id

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_6 · 4,960 ✖
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
119618 119618 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2015   grade_6                                                   194                                             194
289588 289588 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle School   Regular School No 2.0 06 08 2016   grade_6                                                   216                                             216
333458 333458 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2017   grade_6                                                   216                                             216
2326077 2326077 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2020   grade_6                                                   189                                             189
2340971 2340971 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2021   grade_6                                                   154                                             154
3081832 3081832 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2019   grade_6                                                   216                                             216
3096539 3096539 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002302 6 Lincoln Middle   Regular School No Middle 06 08 2018   grade_6                                                   187                                             187
115229 115229 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2015   grade_6                                                   120                                             120
120458 120458 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2015   grade_6                                                   47                                             47
120610 120610 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2015   grade_6                                                   194                                             194
121774 121774 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   21                                             21
121918 121918 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   9                                             9
285235 285235 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2016   grade_6                                                   112                                             112
290417 290417 WI Marquette   school 5509870 3689 Public school Montello 550987001302 10 Forest Lane Community School charter Regular School Yes 1.0 PK 06 2016   grade_6                                                   50                                             50
290571 290571 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No 2.0 05 08 2016   grade_6                                                   174                                             174
291736 291736 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No 1.0 PK 06 2016   grade_6                                                   22                                             22
291879 291879 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No 1.0 PK 08 2016   grade_6                                                   5                                             5
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
334445 334445 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2017   grade_6                                                   195                                             195
335605 335605 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   31                                             31
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
2321661 2321661 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2020   grade_6                                                   126                                             126
2327090 2327090 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2020   grade_6                                                   173                                             173
2328233 2328233 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2020   grade_6                                                   18                                             18
2328389 2328389 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2020   grade_6                                                   11                                             11
2331347 2331347 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 06 2020   grade_6                                                   48                                             48
2336504 2336504 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2021   grade_6                                                   108                                             108
2341960 2341960 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2021   grade_6                                                   163                                             163
2343279 2343279 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2021   grade_6                                                   6                                             6
2346270 2346270 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 06 2021   grade_6                                                   38                                             38
2346317 2346317 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566001989 10 Fox River Middle   Regular School No Middle 06 08 2021   grade_6                                                   145                                             145
3077422 3077422 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2019   grade_6                                                   92                                             92
3082859 3082859 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Muskego Lakes Middle   Regular School No Middle 05 08 2019   grade_6                                                   164                                             164
3083984 3083984 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   21                                             21
3084139 3084139 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2019   grade_6                                                   7                                             7
3087044 3087044 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   38                                             38
3092184 3092184 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No Middle 04 08 2018   grade_6                                                   122                                             122
3097523 3097523 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001330 10 Bay Lane Middle   Regular School No Middle 05 08 2018   grade_6                                                   183                                             183
3098682 3098682 WI Jefferson   school 5511350 4221 Public school Palmyra-Eagle Area 551135001513 10 Eagle Elementary   Regular School No Elementary PK 06 2018   grade_6                                                   17                                             17
3098835 3098835 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   grade_6                                                   7                                             7
3101741 3101741 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 06 2018   grade_6                                                   49                                             49
124878 124878 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   77                                             77
294811 294811 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No 1.0 PK 06 2016   grade_6                                                   57                                             57
338714 338714 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   59                                             59
2331391 2331391 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2020   grade_6                                                   53                                             53
3087088 3087088 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   61                                             61
3101785 3101785 WI Racine   school 5515660 6113 Public school Waterford Graded J1 551566002454 15 Evergreen Elementary   Regular School No Elementary PK 06 2018   grade_6                                                   62                                             62
111816 111816 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   38                                             38
111833 111833 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   19                                             19
112252 112252 WI Trempealeau   school 5500420 154 Public school Arcadia 550042000067 20 Arcadia El   Regular School No 1.0 PK 08 2015   grade_6                                                   72                                             72
112466 112466 WI Sauk   school 5500810 280 Public school Baraboo 550081000102 20 Jack Young Middle School   Regular School No 2.0 06 08 2015   grade_6                                                   193                                             193
112587 112587 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000122 20 Beaver Dam Middle   Regular School No 2.0 06 08 2015   grade_6                                                   248                                             248
112695 112695 WI Rock   school 5501050 413 Public school Beloit 550105000137 20 Aldrich Middle   Regular School No 2.0 06 08 2015   grade_6                                                   215                                             215
112812 112812 WI Lafayette   school 5501110 427 Public school Benton 550111000160 20 Benton Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   13                                             13
112985 112985 WI Grant   school 5501500 609 Public school Boscobel Area 550150000192 20 Boscobel Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   62                                             62
113003 113003 WI Shawano   school 5501560 623 Public school Bowler 550156000199 20 Bowler Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   25                                             25
113028 113028 WI Dunn   school 5501590 637 Public school Boyceville Community 550159000201 20 Tiffany Creek Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   52                                             52
113038 113038 WI Kenosha   school 5501650 657 Public school Brighton #1 550165000205 20 Brighton Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   27                                             27
113066 113066 WI Kenosha   school 5501710 665 Public school Bristol #1 550171000209 20 Bristol Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   69                                             69
113202 113202 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   63                                             63
113345 113345 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   13                                             13
113587 113587 WI Polk   school 5502610 1127 Public school Clear Lake 550261000291 20 Gaylord A Nelson Educ Center   Regular School No 1.0 PK 06 2015   grade_6                                                   47                                             47
113616 113616 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000301 20 Clintonville Middle   Regular School No 2.0 05 08 2015   grade_6                                                   80                                             80
113634 113634 WI Buffalo   school 5502700 1155 Public school Cochrane-Fountain City 550270000306 20 Cochrane-Fountain City Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   53                                             53
113691 113691 WI Dunn   school 5502790 1176 Public school Colfax 550279000315 20 Colfax Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   62                                             62
113717 113717 WI Columbia   school 5502820 1183 Public school Columbus 550282000319 20 Columbus Middle   Regular School No 2.0 04 08 2015   grade_6                                                   79                                             79
113766 113766 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   47                                             47
113784 113784 WI Grant   school 5503030 1246 Public school Cuba City 550303000332 20 Cuba City Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   35                                             35
114065 114065 WI Dane   school 5503270 1309 Public school Deerfield Community 550327000370 20 Deerfield Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   71                                             71
114200 114200 WI Racine   school 5503750 1449 Public school Dover #1 550375000394 20 Kansasville Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   9                                             9
114222 114222 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   32                                             32
114482 114482 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000452 20 Elk Mound Middle   Regular School No 2.0 05 08 2015   grade_6                                                   97                                             97
114499 114499 WI Sheboygan   school 5504260 1631 Public school Elkhart Lake-Glenbeulah 550426000455 20 Elkhart Lake Elementary/Middle   Regular School No 1.0 PK 08 2015   grade_6                                                   35                                             35
114554 114554 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000463 20 Ellsworth Middle   Regular School No 2.0 05 08 2015   grade_6                                                   120                                             120
114661 114661 WI Washington   school 5504410 1687 Public school Erin 550441000476 20 Erin Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   34                                             34
114733 114733 WI Grant   school 5504590 1813 Public school Fennimore Community 550459000485 20 Fennimore Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   53                                             53
114891 114891 WI Walworth   school 5504720 1870 Public school Fontana J8 550472000508 20 Fontana Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   34                                             34
114938 114938 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000517 20 Bayside Middle   Regular School No 2.0 05 08 2015   grade_6                                                   100                                             100
114955 114955 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000519 20 Ben Franklin Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   67                                             67
115044 115044 WI Washington   school 5512880 4843 Public school Friess Lake 551288001701 20 Friess Lake School   Regular School No 1.0 PK 08 2015   grade_6                                                   20                                             20
115090 115090 WI Walworth   school 5505100 2044 Public school Geneva J4 550510000546 20 Woods Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   24                                             24
115362 115362 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000610 20 Aldo Leopold Community School K-8   Regular School No 1.0 PK 08 2015   grade_6                                                   42                                             42
115673 115673 WI Green Lake   school 5505880 2310 Public school Green Lake 550588000646 20 Green Lake Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   17                                             17
115835 115835 WI Washington   school 5506090 2443 Public school Hartford J1 550609000674 20 Central Middle   Regular School No 2.0 06 08 2015   grade_6                                                   182                                             182
115942 115942 WI Dodge   school 5506390 2523 Public school Herman #22 550639000697 20 Herman Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   8                                             8
116275 116275 WI Waupaca   school 5506840 2639 Public school Iola-Scandinavia 550684000741 20 Iola-Scandinavia Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   53                                             53
116294 116294 WI Iowa   school 5506870 2646 Public school Iowa-Grant 550687000744 20 Iowa-Grant Elementary/Middle   Regular School No 1.0 PK 08 2015   grade_6                                                   39                                             39
116534 116534 WI Green   school 5507230 2737 Public school Juda 550723000784 20 Juda Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   21                                             21
117031 117031 WI Vernon   school 5512540 5960 Public school Kickapoo Area 551254001658 20 Kickapoo High   Regular School No 4.0 06 12 2015   grade_6                                                   39                                             39
117299 117299 WI Vilas   school 5504620 1848 Public school Lac du Flambeau #1 550462000488 20 Lac du Flambeau Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   41                                             41
117375 117375 WI Chippewa   school 5507680 2891 Public school Lake Holcombe 550768000885 20 Holcombe Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   23                                             23
117466 117466 WI Walworth   school 5508040 3087 Public school Linn J4 550804000898 20 Traver Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   10                                             10
117477 117477 WI Walworth   school 5508070 3094 Public school Linn J6 550807000899 20 Reek Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   8                                             8
117571 117571 WI Clark   school 5508250 3206 Public school Loyal 550825000911 20 Loyal Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   29                                             29
118167 118167 WI Dane   school 5508790 3332 Public school Marshall 550879001012 20 Marshall Elementary   Regular School No 1.0 03 06 2015   grade_6                                                   78                                             78
118258 118258 WI Juneau   school 5508850 3360 Public school Mauston 550885001026 20 Olson Middle   Regular School No 2.0 06 08 2015   grade_6                                                   101                                             101
118376 118376 WI Jackson   school 5509000 3428 Public school Melrose-Mindoro 550900001050 20 Melrose Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   48                                             48
118427 118427 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903001053 20 Maplewood Middle   Regular School No 2.0 06 08 2015   grade_6                                                   229                                             229
118659 118659 WI Waukesha   school 5509360 3528 Public school Merton Community 550936002269 20 Merton Intermediate   Regular School No 2.0 05 08 2015   grade_6                                                   102                                             102
120338 120338 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969001278 20 Minocqua Elementary   Regular School No 1.0 PK 08 2015   grade_6                                                   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]);