enrollments

Data source: Big Local News · About: Big Local

7,769 rows where grade = "grade_4" and state = "WI" sorted by total descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 7,769 ✖
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
115817 115817 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000667 120 Marcy Elementary   Regular School No 1.0 KG 05 2015   grade_4                                                   99                                             99
117389 117389 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771000889 100 Lake Mills Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   99                                             99
118736 118736 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951000755 150 Sunset Ridge Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   99                                             99
121006 121006 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002789 170 New Richmond Hillside Elementary   Regular School No 1.0 KG 05 2015   grade_4                                                   99                                             99
125726 125726 WI Washington   school 5516290 6307 Public school West Bend 551629002130 70 Green Tree Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   99                                             99
285834 285834 WI Waukesha   school 5506030 2420 Public school Hamilton 550603001676 150 Woodside Elementary   Regular School No 1.0 KG 05 2016   grade_4                                                   99                                             99
291499 291499 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   99                                             99
326213 326213 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000084 50 Pioneer Elementary   Regular School No Elementary KG 05 2017   grade_4                                                   99                                             99
327926 327926 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   99                                             99
330015 330015 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000718 50 Meadowbrook Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   99                                             99
332451 332451 WI Ozaukee   school 5509130 3479 Public school Mequon-Thiensville 550913001090 160 Wilson Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   99                                             99
332537 332537 WI Waukesha   school 5509360 3528 Public school Merton Community 550936000750 40 Merton Primary   Regular School No Elementary PK 04 2017   grade_4                                                   99                                             99
332686 332686 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   99                                             99
336242 336242 WI Racine   school 5512360 4620 Public school Racine Unified 551236001623 132 Jefferson Lighthouse Elementary   Regular School No Elementary KG 05 2017   grade_4                                                   99                                             99
339923 339923 WI Milwaukee   school 5506000 6470 Public school Whitnall 550600000658 40 Hales Corners Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   99                                             99
2322558 2322558 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002409 40 Forest Glen Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   99                                             99
2325185 2325185 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001105 40 Elm Lawn Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   99                                             99
2333455 2333455 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   99                                             99
2340088 2340088 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001109 90 Northside Elementary   Regular School No Elementary PK 04 2021   grade_4                                                   99                                             99
2342896 2342896 WI Dane   school 5511100 4144 Public school Oregon 551110001468 20 Brooklyn Elementary   Regular School No Elementary PK 04 2021   grade_4                                                   99                                             99
3078211 3078211 WI La Crosse   school 5506540 2562 Public school Holmen 550654002298 100 Viking Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   99                                             99
3083203 3083203 WI Saint Croix   school 5510620 3962 Public school New Richmond 551062002789 170 New Richmond Hillside Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   99                                             99
3083574 3083574 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001420 90 Meadow View Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   99                                             99
3085843 3085843 WI Washington   school 5513950 5390 Public school Slinger 551395001819 20 Slinger Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   99                                             99
3097570 3097570 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001336 220 Tess Corners Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   99                                             99
3098452 3098452 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   99                                             99
114419 114419 WI Rock   school 5504110 1568 Public school Edgerton 550411000442 40 Edgerton Community Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   98                                             98
115851 115851 WI Washington   school 5506090 2443 Public school Hartford J1 550609000676 50 Rossman Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   98                                             98
117749 117749 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000939 375 Kennedy Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   98                                             98
121536 121536 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   98                                             98
286205 286205 WI Saint Croix   school 5506690 2611 Public school Hudson 550669000731 120 Rock Elementary   Regular School No 1.0 KG 05 2016   grade_4                                                   98                                             98
288458 288458 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906001061 40 Benjamin Franklin Elementary and Early Learning Center   Regular School No 1.0 PK 05 2016   grade_4                                                   98                                             98
327909 327909 WI Brown   school 5503210 1414 Public school De Pere 550321000363 40 Dickinson Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
328831 328831 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000518 40 Stormonth Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
329733 329733 WI Washington   school 5506090 2443 Public school Hartford J1 550609000676 50 Rossman Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   98                                             98
332613 332613 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001113 160 West Middleton Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
338048 338048 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002624 150 Horizon Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
2320692 2320692 WI Walworth   school 5504020 1540 Public school East Troy Community 550402001640 100 Prairie View Elementary   Regular School No Elementary 03 05 2020   grade_4                                                   98                                             98
2331693 2331693 WI Dane   school 5515810 6181 Public school Waunakee Community 551581002648 110 Arboretum Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   98                                             98
2335357 2335357 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No Elementary 01 05 2021   grade_4                                                   98                                             98
2342757 2342757 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001425 180 Summit Elementary   Regular School No Elementary PK 04 2021   grade_4                                                   98                                             98
2347485 2347485 WI Milwaukee   school 5516620 6419 Public school Whitefish Bay 551662002169 80 Richards Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   98                                             98
3076199 3076199 WI Dane   school 5503180 1316 Public school De Forest Area 550318000354 20 Eagle Point Elementary   Regular School No Elementary KG 04 2019   grade_4                                                   98                                             98
3087143 3087143 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575001997 40 Douglas Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   98                                             98
3089873 3089873 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   98                                             98
3099474 3099474 WI Racine   school 5512360 4620 Public school Racine Unified 551236001642 162 Wadewitz Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   98                                             98
113094 113094 WI Milwaukee   school 5501800 721 Public school Brown Deer 550180000232 80 Brown Deer Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   97                                             97
114028 114028 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   97                                             97
114576 114576 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000216 40 Brookfield Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   97                                             97
115227 115227 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000575 10 Glen Hills Middle   Regular School No 2.0 04 08 2015   grade_4                                                   97                                             97
116065 116065 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   97                                             97
116207 116207 WI Saint Croix   school 5506690 2611 Public school Hudson 550669000731 120 Rock Elementary   Regular School No 1.0 KG 05 2015   grade_4                                                   97                                             97
117090 117090 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000732 60 Sunrise Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   97                                             97
118716 118716 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001109 90 Northside Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   97                                             97
119696 119696 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001164 176 Meir School   Regular School No 4.0 03 09 2015   grade_4                                                   97                                             97
126358 126358 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   97                                             97
283924 283924 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001741 120 Weston Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   97                                             97
284109 284109 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No 1.0 01 05 2016   grade_4                                                   97                                             97
284402 284402 WI Rock   school 5504110 1568 Public school Edgerton 550411000442 40 Edgerton Community Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   97                                             97
286803 286803 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000820 420 Pleasant Prairie Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   97                                             97
287496 287496 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000900 20 Little Chute Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   97                                             97
291441 291441 WI La Crosse   school 5511010 4095 Public school Onalaska 551101001445 20 Eagle Bluff Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   97                                             97
295075 295075 WI Dane   school 5515810 6181 Public school Waunakee Community 551581002648 110 Arboretum Elementary School   Regular School No 1.0 PK 04 2016   grade_4                                                   97                                             97
295984 295984 WI Milwaukee   school 5506000 6470 Public school Whitnall 550600000658 40 Hales Corners Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   97                                             97
326716 326716 WI Green Lake   school 5501140 434 Public school Berlin Area 550114000163 60 Clay Lamberton Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   97                                             97
333540 333540 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001164 176 Meir School   Regular School No Other 03 11 2017   grade_4                                                   97                                             97
335365 335365 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   97                                             97
337550 337550 WI Saint Croix   school 5514010 5432 Public school Somerset 551401001824 20 Somerset Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   97                                             97
338949 338949 WI Waukesha   school 5515780 6174 Public school Waukesha 551578000261 480 Summit View Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   97                                             97
2318660 2318660 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   97                                             97
2333889 2333889 WI Rock   school 5501050 413 Public school Beloit 550105003011 170 Fran Fruzen Intermediate   Regular School No Middle 04 08 2021   grade_4                                                   97                                             97
2335492 2335492 WI Walworth   school 5504020 1540 Public school East Troy Community 550402001640 100 Prairie View Elementary   Regular School No Elementary 03 05 2021   grade_4                                                   97                                             97
2345061 2345061 WI Saint Croix   school 5514010 5432 Public school Somerset 551401001824 20 Somerset Elementary   Regular School No Elementary PK 04 2021   grade_4                                                   97                                             97
2347476 2347476 WI Milwaukee   school 5516620 6419 Public school Whitefish Bay 551662002166 20 Cumberland Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   97                                             97
3074493 3074493 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000084 50 Pioneer Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   97                                             97
3076208 3076208 WI Dane   school 5503180 1316 Public school De Forest Area 550318000360 140 Windsor Elementary   Regular School No Elementary KG 04 2019   grade_4                                                   97                                             97
3080381 3080381 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_4                                                   97                                             97
3083751 3083751 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   97                                             97
3092839 3092839 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002258 40 South Elementary   Regular School No Elementary 03 05 2018   grade_4                                                   97                                             97
3095272 3095272 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002361 180 Medford Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   97                                             97
122100 122100 WI Columbia   school 5512060 4501 Public school Portage Community 551206002310 90 Muir Elementary School   Regular School No 1.0 02 05 2015   grade_4                                                   96                                             96
122942 122942 WI Pierce   school 5513050 4893 Public school River Falls 551305002448 40 Rocky Branch Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   96                                             96
123401 123401 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365001784 100 Grant Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   96                                             96
125709 125709 WI Washington   school 5516290 6307 Public school West Bend 551629002127 40 Decorah Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   96                                             96
282053 282053 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002426 130 Ferber Elementary   Regular School No 1.0 PK 06 2016   grade_4                                                   96                                             96
283999 283999 WI Brown   school 5503210 1414 Public school De Pere 550321001254 50 Heritage Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   96                                             96
284006 284006 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   96                                             96
285030 285030 WI Outagamie   school 5504920 1953 Public school Freedom Area 550492000532 20 Freedom Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   96                                             96
287638 287638 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002483 110 Cesar Chavez Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   96                                             96
288736 288736 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951000755 150 Sunset Ridge Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   96                                             96
288815 288815 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   96                                             96
294102 294102 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001895 50 Sunrise Elementary   Regular School No 1.0 03 05 2016   grade_4                                                   96                                             96
294143 294143 WI Dane   school 5514640 5656 Public school Sun Prairie Area 551464002624 150 Horizon Elementary School   Regular School No 1.0 PK 05 2016   grade_4                                                   96                                             96
295027 295027 WI Waukesha   school 5515780 6174 Public school Waukesha 551578000261 480 Summit View Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   96                                             96
327816 327816 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002288 70 Riverside Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   96                                             96
328420 328420 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429002529 120 Jackson Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   96                                             96
330671 330671 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002653 170 Nash Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   96                                             96
335382 335382 WI Dane   school 5511100 4144 Public school Oregon 551110001472 50 Prairie View Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   96                                             96
337517 337517 WI Washington   school 5513950 5390 Public school Slinger 551395001819 20 Slinger Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   96                                             96
339029 339029 WI Dane   school 5515810 6181 Public school Waunakee Community 551581001198 100 Waunakee Prairie Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   96                                             96

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