enrollments

Data source: Big Local News · About: Big Local

1,109 rows where grade = "grade_4", state = "WI" and year = 2020 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,109 ✖

grade ✖

  • grade_4 · 1,109 ✖
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
2318124 2318124 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_4                                                   57                                             57
2327129 2327129 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2020   grade_4                                                   24                                             24
2325293 2325293 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   grade_4                                                   74                                             74
2318135 2318135 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   50                                             50
2326856 2326856 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   35                                             35
2327872 2327872 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   33                                             33
2325284 2325284 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2020   grade_4                                                   93                                             93
2328058 2328058 WI Winnebago   school 5511190 4179 Public school Oshkosh Area 551119003364 170 Accelerated Advanced Learning Program charter Regular School Yes Middle 04 08 2020   grade_4                                                   11                                             11
2322776 2322776 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   30                                             30
2318155 2318155 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   91                                             91
2330093 2330093 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   69                                             69
2318832 2318832 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   54                                             54
2318185 2318185 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   24                                             24
2325303 2325303 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   30                                             30
2321780 2321780 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000610 20 Aldo Leopold Community School K-8   Regular School No Elementary PK 08 2020   grade_4                                                   60                                             60
2319072 2319072 WI Rock   school 5501050 413 Public school Beloit 550105000137 20 Aldrich Intermediate   Regular School No Middle 04 08 2020   grade_4                                                   93                                             93
2327228 2327228 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2020   grade_4                                                   69                                             69
2318197 2318197 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   59                                             59
2325315 2325315 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   85                                             85
2330102 2330102 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   74                                             74
2324110 2324110 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000929 225 Allis Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   63                                             63
2318214 2318214 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   14                                             14
2318901 2318901 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary 02 04 2020   grade_4                                                   13                                             13
2318249 2318249 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   19                                             19
2318276 2318276 WI Eau Claire   school 5500270 112 Public school Altoona 550027002925 100 Altoona Intermediate   Regular School No Elementary 04 05 2020   grade_4                                                   115                                             115
2318289 2318289 WI Polk   school 5500300 119 Public school Amery 550030000075 50 Amery Intermediate   Regular School No Elementary 03 05 2020   grade_4                                                   101                                             101
2331007 2331007 WI Portage   school 5500330 126 Public school Tomorrow River 550033000032 20 Amherst Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   85                                             85
2321551 2321551 WI Washington   school 5505160 2058 Public school Germantown 550516000549 20 Amy Belle Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   66                                             66
2318310 2318310 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000036 50 Antigo Middle   Regular School No Middle 04 07 2020   grade_4                                                   130                                             130
2318351 2318351 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2020   grade_4                                                   27                                             27
2318369 2318369 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2020   grade_4                                                   20                                             20
2332888 2332888 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   45                                             45
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
2318611 2318611 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   80                                             80
2318629 2318629 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   16                                             16
2318725 2318725 WI Marathon   school 5500570 196 Public school Athens 550057000086 20 Athens Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   17                                             17
2330016 2330016 WI Milwaukee   school 5513800 5355 Public school Shorewood 551380001809 20 Atwater Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   62                                             62
2318742 2318742 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   56                                             56
2325347 2325347 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001124 77 Auer Avenue Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   18                                             18
2318771 2318771 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   31                                             31
2318385 2318385 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   52                                             52
2321792 2321792 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000611 30 Baird Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   95                                             95
2318814 2318814 WI La Crosse   school 5500780 245 Public school Bangor 550078000100 20 Bangor Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   40                                             40
2330423 2330423 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002452 50 Bannach Elementary   Regular School No Elementary KG 06 2020   grade_4                                                   75                                             75
2324900 2324900 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903000659 160 Banta School   Regular School No Elementary KG 05 2020   grade_4                                                   20                                             20
2331500 2331500 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002004 20 Banting Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   70                                             70
2325361 2325361 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001170 188 Barbee Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   19                                             19
2318877 2318877 WI Iowa   school 5500840 287 Public school Barneveld 550084000111 20 Barneveld Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   27                                             27
2321349 2321349 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474000509 20 Barrie Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   48                                             48
2325371 2325371 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001126 81 Barton Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   35                                             35
2322542 2322542 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002709 120 Bay Harbor Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   76                                             76
2327059 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
2325384 2325384 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Bay View Montessori School   Regular School No Elementary PK 06 2020   grade_4                                                   35                                             35
2318941 2318941 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   30                                             30
2321810 2321810 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000613 60 Beaumont Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   32                                             32
2319040 2319040 WI Dane   school 5500990 350 Public school Belleville 550099001211 100 Belleville Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   60                                             60
2319058 2319058 WI Lafayette   school 5501020 364 Public school Belmont Community 550102000134 20 Belmont Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   29                                             29
2321403 2321403 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000519 20 Ben Franklin Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   45                                             45
2319185 2319185 WI Lafayette   school 5501110 427 Public school Benton 550111000160 20 Benton Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   18                                             18
2318393 2318393 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   50                                             50
2331509 2331509 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002006 60 Bethesda Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   65                                             65
2325394 2325394 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001256 356 Bethune Academy   Regular School No Elementary PK 08 2020   grade_4                                                   59                                             59
2326996 2326996 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006001315 20 Big Bend Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   55                                             55
2319234 2319234 WI Washburn   school 5501170 441 Public school Birchwood 550117000168 20 Birchwood Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   19                                             19
2319251 2319251 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2020   grade_4                                                   2                                             2
2332818 2332818 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   46                                             46
2329737 2329737 WI Outagamie   school 5513530 5138 Public school Seymour Community 551353001769 20 Black Creek Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   45                                             45
2319265 2319265 WI Lafayette   school 5505730 2240 Public school Black Hawk 550573000608 160 Black Hawk Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   26                                             26
2319302 2319302 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   42                                             42
2330175 2330175 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   49                                             49
2319319 2319319 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   88                                             88
2328661 2328661 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002830 150 Bluff View Elementary   Regular School No Elementary 02 04 2020   grade_4                                                   77                                             77
2319258 2319258 WI Washburn   school 5501170 441 Public school Birchwood 550117003020 800 Bobcat Virtual Academy charter Regular School Yes Other PK 12 2020   grade_4                                                   1                                             1
2319337 2319337 WI Shawano   school 5501470 602 Public school Bonduel 550147000188 20 Bonduel Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   55                                             55
2319355 2319355 WI Grant   school 5501500 609 Public school Boscobel Area 550150000192 20 Boscobel Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   56                                             56
2323042 2323042 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000800 50 Bose Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   32                                             32
2319373 2319373 WI Shawano   school 5501560 623 Public school Bowler 550156000199 20 Bowler Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   25                                             25
2329497 2329497 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310001727 25 Brandon Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   24                                             24
2323056 2323056 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000816 340 Brass Community School   Regular School No Elementary PK 05 2020   grade_4                                                   71                                             71
2329776 2329776 WI Shawano   school 5513620 5264 Public school Shawano 551362001779 230 Brener Elementary   Regular School No Elementary 03 05 2020   grade_4                                                   147                                             147
2325106 2325106 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2020   grade_4                                                   49                                             49
2319417 2319417 WI Kenosha   school 5501650 657 Public school Brighton #1 550165000205 20 Brighton Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   19                                             19
2319428 2319428 WI Calumet   school 5501680 658 Public school Brillion 550168000206 20 Brillion Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   69                                             69
2319446 2319446 WI Kenosha   school 5501710 665 Public school Bristol #1 550171000209 20 Bristol Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   81                                             81
2323065 2323065 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001285 65 Brompton School charter Regular School Yes Elementary KG 08 2020   grade_4                                                   24                                             24
2321027 2321027 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000216 40 Brookfield Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   124                                             124
2328009 2328009 WI Dane   school 5511100 4144 Public school Oregon 551110001468 20 Brooklyn Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   94                                             94
2321542 2321542 WI Walworth   school 5505130 2051 Public school Genoa City J2 550513002327 200 Brookwood Middle   Regular School No Middle 04 08 2020   grade_4                                                   55                                             55
2319475 2319475 WI Milwaukee   school 5501800 721 Public school Brown Deer 550180000232 80 Brown Deer Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   110                                             110
2325411 2325411 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002395 89 Brown Street Academy   Regular School No Elementary PK 05 2020   grade_4                                                   47                                             47
2325420 2325420 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001132 92 Browning Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   45                                             45
2319492 2319492 WI Rusk   school 5501830 735 Public school Bruce 550183000234 20 Bruce Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   33                                             33
2325429 2325429 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001133 93 Bruce Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   24                                             24
2319511 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
2325438 2325438 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001134 94 Bryant Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   23                                             23
2330743 2330743 WI Douglas   school 5514670 5663 Public school Superior 551467001906 40 Bryant Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   56                                             56
2325447 2325447 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001135 95 Burbank Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   62                                             62
2325459 2325459 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001136 98 Burdick Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   63                                             63
2321034 2321034 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000218 80 Burleigh Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   129                                             129
2324907 2324907 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903001054 40 Butte des Morts Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   65                                             65

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