Data source: Big Local News · About: Big Local

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

View and edit SQL

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 ▲
332642 WI Rock   school 5509570 3612 Public school Milton 550957000382 130 Northside Intermediate   Regular School No Elementary 04 06 2017   grade_4                                                   246                                             246
288772 WI Rock   school 5509570 3612 Public school Milton 550957000382 130 Northside Intermediate   Regular School No 2.0 04 06 2016   grade_4                                                   245                                             245
2325270 WI Rock   school 5509570 3612 Public school Milton 550957000382 130 Northside Intermediate   Regular School No Middle 04 06 2020   grade_4                                                   238                                             238
3080999 WI Rock   school 5509570 3612 Public school Milton 550957000382 130 Northside Intermediate   Regular School No Middle 04 06 2019   grade_4                                                   231                                             231
118772 WI Rock   school 5509570 3612 Public school Milton 550957000382 130 Northside Intermediate   Regular School No 2.0 04 06 2015   grade_4                                                   229                                             229
337712 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002485 150 Sparta Meadowview Intermediate   Regular School No Elementary 04 05 2017   grade_4                                                   229                                             229
2328368 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164000226 40 Horizon School   Regular School No Middle 04 06 2020   grade_4                                                   229                                             229
2339705 WI Dane   school 5508910 3381 Public school McFarland 550891002973 160 Wisconsin Virtual Academy K-8 (WIVA) charter Regular School Yes Elementary KG 08 2021   grade_4                                                   227                                             227
3095714 WI Rock   school 5509570 3612 Public school Milton 550957000382 130 Northside Intermediate   Regular School No Middle 04 06 2018   grade_4                                                   222                                             222
3100767 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002485 150 Sparta Meadowview Intermediate   Regular School No Elementary 04 05 2018   grade_4                                                   222                                             222
2340163 WI Rock   school 5509570 3612 Public school Milton 550957000382 130 Northside Intermediate   Regular School No Middle 04 06 2021   grade_4                                                   221                                             221
121897 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164000226 40 Horizon School   Regular School No 2.0 04 06 2015   grade_4                                                   218                                             218
2329121 WI Sauk   school 5512660 4753 Public school Reedsburg 551266003098 190 Prairie Ridge Intermediate   Regular School No Elementary 03 05 2020   grade_4                                                   213                                             213
3084118 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164000226 40 Horizon School   Regular School No Middle 04 06 2019   grade_4                                                   213                                             213
3098814 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164000226 40 Horizon School   Regular School No Middle 04 06 2018   grade_4                                                   212                                             212
335732 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164000226 40 Horizon School   Regular School No Elementary 04 06 2017   grade_4                                                   208                                             208
3097449 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999001311 100 Mount Horeb Intermediate   Regular School No Elementary 03 05 2018   grade_4                                                   207                                             207
3099571 WI Sauk   school 5512660 4753 Public school Reedsburg 551266001604 180 Pineview Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   207                                             207
290499 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999001311 100 Mount Horeb Intermediate   Regular School No 1.0 03 05 2016   grade_4                                                   196                                             196
291858 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164000226 40 Horizon School   Regular School No 2.0 04 06 2016   grade_4                                                   196                                             196
337178 WI Shawano   school 5513620 5264 Public school Shawano 551362001779 230 Brener Elementary   Regular School No Elementary 03 05 2017   grade_4                                                   196                                             196
2343260 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164000226 40 Horizon School   Regular School No Elementary 03 05 2021   grade_4                                                   195                                             195
3086038 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002485 150 Sparta Meadowview Intermediate   Regular School No Elementary 04 05 2019   grade_4                                                   195                                             195
2324806 WI Dane   school 5508910 3381 Public school McFarland 550891002172 40 Waubesa Intermediate   Regular School No Elementary 03 05 2020   grade_4                                                   190                                             190
120539 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999001311 100 Mount Horeb Intermediate   Regular School No 1.0 03 05 2015   grade_4                                                   188                                             188
293287 WI Shawano   school 5513620 5264 Public school Shawano 551362001779 230 Brener Elementary   Regular School No 1.0 03 05 2016   grade_4                                                   188                                             188
2345189 WI Monroe   school 5514160 5460 Public school Sparta Area 551416003110 190 Herrman Elementary   Regular School No Elementary 01 04 2021   grade_4                                                   187                                             187
293820 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002485 150 Sparta Meadowview Intermediate   Regular School No 2.0 04 05 2016   grade_4                                                   186                                             186
3084573 WI Racine   school 5512360 4620 Public school Racine Unified 551236002311 119 Gifford Elementary   Regular School No Elementary PK 08 2019   grade_4                                                   186                                             186
3095251 WI Dane   school 5508910 3381 Public school McFarland 550891002172 40 Waubesa Intermediate   Regular School No Elementary 03 05 2018   grade_4                                                   185                                             185
122639 WI Sauk   school 5512660 4753 Public school Reedsburg 551266001604 180 Pineview Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   182                                             182
336497 WI Sauk   school 5512660 4753 Public school Reedsburg 551266001604 180 Pineview Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   182                                             182
2344016 WI Sauk   school 5512660 4753 Public school Reedsburg 551266003098 190 Prairie Ridge Intermediate   Regular School No Elementary 03 05 2021   grade_4                                                   182                                             182
3085505 WI Shawano   school 5513620 5264 Public school Shawano 551362001779 230 Brener Elementary   Regular School No Elementary 03 05 2019   grade_4                                                   182                                             182
2326983 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999001311 100 Mount Horeb Intermediate   Regular School No Elementary 03 05 2020   grade_4                                                   181                                             181
332172 WI Dane   school 5508910 3381 Public school McFarland 550891002172 40 Waubesa Intermediate   Regular School No Elementary 03 05 2017   grade_4                                                   178                                             178
2330322 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002485 150 Sparta Meadowview Intermediate   Regular School No Elementary 04 05 2020   grade_4                                                   178                                             178
123867 WI Monroe   school 5514160 5460 Public school Sparta Area 551416002485 150 Sparta Meadowview Intermediate   Regular School No 2.0 04 05 2015   grade_4                                                   177                                             177
3084851 WI Sauk   school 5512660 4753 Public school Reedsburg 551266001604 180 Pineview Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   177                                             177
288299 WI Dane   school 5508910 3381 Public school McFarland 550891002172 40 Waubesa Intermediate School   Regular School No 1.0 03 05 2016   grade_4                                                   176                                             176
292612 WI Sauk   school 5512660 4753 Public school Reedsburg 551266001604 180 Pineview Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   176                                             176
3080535 WI Dane   school 5508910 3381 Public school McFarland 550891002172 40 Waubesa Intermediate   Regular School No Elementary 03 05 2019   grade_4                                                   174                                             174
334371 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999001311 100 Mount Horeb Intermediate   Regular School No Elementary 03 05 2017   grade_4                                                   173                                             173
118304 WI Dane   school 5508910 3381 Public school McFarland 550891002172 40 Waubesa Intermediate School   Regular School No 1.0 03 05 2015   grade_4                                                   171                                             171
339048 WI Waupaca   school 5515840 6195 Public school Waupaca 551584001203 70 Waupaca Learning Center Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   171                                             171
336203 WI Racine   school 5512360 4620 Public school Racine Unified 551236002311 119 Gifford Elementary   Regular School No Elementary PK 08 2017   grade_4                                                   170                                             170
3082750 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999001311 100 Mount Horeb Intermediate   Regular School No Elementary 03 05 2019   grade_4                                                   168                                             168
123332 WI Shawano   school 5513620 5264 Public school Shawano 551362001779 230 Brener Elementary   Regular School No 1.0 03 05 2015   grade_4                                                   166                                             166
2341932 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001336 220 Bay Lane Elementary   Regular School No Elementary PK 04 2021   grade_4                                                   165                                             165
290472 WI Marathon   school 5509960 3787 Public school Mosinee 550996001309 120 Mosinee Middle   Regular School No 2.0 04 08 2016   grade_4                                                   163                                             163
3099287 WI Racine   school 5512360 4620 Public school Racine Unified 551236002311 119 Gifford Elementary   Regular School No Elementary PK 08 2018   grade_4                                                   163                                             163
3102130 WI Waupaca   school 5515840 6195 Public school Waupaca 551584001203 70 Waupaca Learning Center Elementary   Regular School No Elementary PK 04 2018   grade_4                                                   163                                             163
2347271 WI Brown   school 5516320 6328 Public school West De Pere 551632002726 150 Hemlock Creek Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   162                                             162
3097289 WI Dane   school 5509810 3675 Public school Monona Grove 550981001289 20 Cottage Grove Elementary   Regular School No Elementary 02 04 2018   grade_4                                                   161                                             161
329793 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002417 110 Hayward Intermediate   Regular School No Elementary 03 05 2017   grade_4                                                   160                                             160
3082586 WI Dane   school 5509810 3675 Public school Monona Grove 550981001289 20 Cottage Grove Elementary   Regular School No Elementary 02 04 2019   grade_4                                                   160                                             160
2328849 WI Racine   school 5512360 4620 Public school Racine Unified 551236002311 119 Gifford Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   159                                             159
326220 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No Elementary KG 05 2017   grade_4                                                   158                                             158
331211 WI Walworth   school 5507620 2885 Public school Lake Geneva J1 550762000882 80 Eastview Elementary   Regular School No Elementary 04 05 2017   grade_4                                                   158                                             158
2327059 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001336 220 Bay Lane Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   158                                             158
112725 WI Rock   school 5501050 413 Public school Beloit 550105000140 80 Cunningham Intermediate   Regular School No 2.0 04 08 2015   grade_4                                                   156                                             156
337044 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001756 30 Grand Avenue Elementary   Regular School No Elementary 03 05 2017   grade_4                                                   156                                             156
2339694 WI Dane   school 5508910 3381 Public school McFarland 550891002172 40 Waubesa Intermediate   Regular School No Elementary 03 05 2021   grade_4                                                   154                                             154
3099615 WI Oneida   school 5512720 4781 Public school Rhinelander 551272001674 40 Central Elementary   Regular School No Elementary 04 05 2018   grade_4                                                   154                                             154
2326817 WI Dane   school 5509810 3675 Public school Monona Grove 550981001289 20 Cottage Grove Elementary   Regular School No Elementary 02 04 2020   grade_4                                                   153                                             153
328577 WI Rock   school 5504440 1694 Public school Evansville Community 550444002552 100 Theodore Robinson Intermediate School   Regular School No Elementary 03 05 2017   grade_4                                                   151                                             151
3082827 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001336 220 Bay Lane Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   151                                             151
3095426 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906000660 65 Riverside Elementary   Regular School No Elementary 03 05 2018   grade_4                                                   151                                             151
334216 WI Dane   school 5509810 3675 Public school Monona Grove 550981001289 20 Cottage Grove Elementary   Regular School No Elementary 02 04 2017   grade_4                                                   150                                             150
3100104 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001756 30 Grand Avenue Elementary   Regular School No Elementary 03 05 2018   grade_4                                                   150                                             150
3079814 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834000916 100 Luxemburg-Casco Intermediate   Regular School No Elementary 03 06 2019   grade_4                                                   149                                             149
3084896 WI Oneida   school 5512720 4781 Public school Rhinelander 551272001674 40 Central Elementary   Regular School No Elementary 04 05 2019   grade_4                                                   149                                             149
3102708 WI Brown   school 5516320 6328 Public school West De Pere 551632002726 150 Hemlock Creek Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   149                                             149
326631 WI Rock   school 5501050 413 Public school Beloit 550105002330 180 McNeel Intermediate   Regular School No Elementary 04 08 2017   grade_4                                                   148                                             148
3074500 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No Elementary KG 05 2019   grade_4                                                   148                                             148
295707 WI Brown   school 5516320 6328 Public school West De Pere 551632002726 150 Hemlock Creek Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   147                                             147
330459 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000796 100 Quinney Elementary   Regular School No Elementary 02 04 2017   grade_4                                                   147                                             147
2324981 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906000660 65 Riverside Elementary   Regular School No Elementary 03 05 2020   grade_4                                                   147                                             147
2329776 WI Shawano   school 5513620 5264 Public school Shawano 551362001779 230 Brener Elementary   Regular School No Elementary 03 05 2020   grade_4                                                   147                                             147
3094722 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002263 15 Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   147                                             147
2337344 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2021   grade_4                                                   146                                             146
3089256 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No Elementary KG 05 2018   grade_4                                                   146                                             146
282704 WI Rock   school 5501050 413 Public school Beloit 550105000140 80 Cunningham Intermediate   Regular School No 2.0 04 08 2016   grade_4                                                   145                                             145
3080710 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906000660 65 Riverside Elementary   Regular School No Elementary 03 05 2019   grade_4                                                   145                                             145
123305 WI Outagamie   school 5513530 5138 Public school Seymour Community 551353001771 60 Rock Ledge Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   144                                             144
336973 WI Saint Croix   school 5506060 2422 Public school Saint Croix Central 550606000671 40 Saint Croix Central Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   144                                             144
339664 WI La Crosse   school 5516350 6370 Public school West Salem 551635002140 60 West Salem Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   144                                             144
3091044 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 04 05 2018   grade_4                                                   144                                             144
290345 WI Dane   school 5509810 3675 Public school Monona Grove 550981001289 20 Cottage Grove Elementary   Regular School No 1.0 02 04 2016   grade_4                                                   143                                             143
328511 WI Waukesha   school 5501770 714 Public school Elmbrook 550177001217 190 Swanson Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   143                                             143
2324092 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834000916 100 Luxemburg-Casco Intermediate   Regular School No Elementary 03 06 2020   grade_4                                                   143                                             143
3085370 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001756 30 Grand Avenue Elementary   Regular School No Elementary 03 05 2019   grade_4                                                   143                                             143
120387 WI Dane   school 5509810 3675 Public school Monona Grove 550981001289 20 Cottage Grove Elementary   Regular School No 1.0 02 04 2015   grade_4                                                   142                                             142
326605 WI Rock   school 5501050 413 Public school Beloit 550105000140 80 Cunningham Intermediate   Regular School No Elementary 04 08 2017   grade_4                                                   142                                             142
2321069 WI Waukesha   school 5501770 714 Public school Elmbrook 550177001217 190 Swanson Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   142                                             142
2325830 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002979 880 HAPA-Hmong American Peace Academy K3-12 charter Regular School Yes Other PK 12 2020   grade_4                                                   142                                             142
3092865 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627002417 110 Hayward Intermediate   Regular School No Elementary 03 05 2018   grade_4                                                   142                                             142
112342 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No 1.0 01 05 2015   grade_4                                                   141                                             141
121573 WI Polk   school 5511160 4165 Public school Osceola 551116001073 50 Osceola Intermediate   Regular School No 1.0 03 05 2015   grade_4                                                   141                                             141
2319511 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2020   grade_4                                                   141                                             141

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