enrollments

Data source: Big Local News · About: Big Local

1,113 rows where grade = "grade_2", state = "WI" and year = 2020 sorted by school

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2020 · 1,113 ✖

grade ✖

  • grade_2 · 1,113 ✖
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
2318122 2318122 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_2                                                   55                                             55
2327127 2327127 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2020   grade_2                                                   21                                             21
2325291 2325291 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_2                                                   77                                             77
2322785 2322785 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_2                                                   1                                             1
2318133 2318133 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   58                                             58
2326854 2326854 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   33                                             33
2327870 2327870 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   33                                             33
2325282 2325282 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2020   grade_2                                                   95                                             95
2322774 2322774 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   44                                             44
2318153 2318153 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   74                                             74
2330091 2330091 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   70                                             70
2318830 2318830 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   55                                             55
2318183 2318183 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   34                                             34
2325301 2325301 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   32                                             32
2321778 2321778 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_2                                                   55                                             55
2318195 2318195 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   45                                             45
2325313 2325313 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001122 73 Allen-Field Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   87                                             87
2330100 2330100 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   59                                             59
2324108 2324108 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000929 225 Allis Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   70                                             70
2318212 2318212 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   16                                             16
2318899 2318899 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary 02 04 2020   grade_2                                                   14                                             14
2318247 2318247 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   31                                             31
2318265 2318265 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2020   grade_2                                                   123                                             123
2331005 2331005 WI Portage   school 5500330 126 Public school Tomorrow River 550033000032 20 Amherst Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   57                                             57
2321549 2321549 WI Washington   school 5505160 2058 Public school Germantown 550516000549 20 Amy Belle Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   57                                             57
2318349 2318349 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2020   grade_2                                                   25                                             25
2318367 2318367 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2020   grade_2                                                   20                                             20
2332886 2332886 WI Vilas   school 5517160 6720 Public school Woodruff J1 551716002227 20 Arbor Vitae-Woodruff Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   66                                             66
2331691 2331691 WI Dane   school 5515810 6181 Public school Waunakee Community 551581002648 110 Arboretum Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   88                                             88
2318609 2318609 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   81                                             81
2318627 2318627 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   17                                             17
2318723 2318723 WI Marathon   school 5500570 196 Public school Athens 550057000086 20 Athens Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   28                                             28
2330014 2330014 WI Milwaukee   school 5513800 5355 Public school Shorewood 551380001809 20 Atwater Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   79                                             79
2318740 2318740 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   54                                             54
2325345 2325345 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001124 77 Auer Avenue Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   24                                             24
2318769 2318769 WI Eau Claire   school 5500630 217 Public school Augusta 550063000092 20 Augusta Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   37                                             37
2318383 2318383 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   60                                             60
2321790 2321790 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000611 30 Baird Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   78                                             78
2318812 2318812 WI La Crosse   school 5500780 245 Public school Bangor 550078000100 20 Bangor Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   34                                             34
2330421 2330421 WI Portage   school 5514490 5607 Public school Stevens Point Area Public 551449002452 50 Bannach Elementary   Regular School No Elementary KG 06 2020   grade_2                                                   68                                             68
2324898 2324898 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903000659 160 Banta School   Regular School No Elementary KG 05 2020   grade_2                                                   39                                             39
2331498 2331498 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002004 20 Banting Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   73                                             73
2325359 2325359 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001170 188 Barbee Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   38                                             38
2329326 2329326 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302001893 110 Barlow Park Elementary   Regular School No Elementary PK 02 2020   grade_2                                                   65                                             65
2318875 2318875 WI Iowa   school 5500840 287 Public school Barneveld 550084000111 20 Barneveld Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   22                                             22
2321347 2321347 WI Jefferson   school 5504740 1883 Public school Fort Atkinson 550474000509 20 Barrie Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   41                                             41
2318904 2318904 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2020   grade_2                                                   9                                             9
2325369 2325369 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001126 81 Barton Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   40                                             40
2322540 2322540 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002709 120 Bay Harbor Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   87                                             87
2327057 2327057 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001336 220 Bay Lane Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   155                                             155
2325382 2325382 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Bay View Montessori School   Regular School No Elementary PK 06 2020   grade_2                                                   43                                             43
2318939 2318939 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   30                                             30
2321808 2321808 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000613 60 Beaumont Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   34                                             34
2319038 2319038 WI Dane   school 5500990 350 Public school Belleville 550099001211 100 Belleville Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   47                                             47
2319056 2319056 WI Lafayette   school 5501020 364 Public school Belmont Community 550102000134 20 Belmont Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   27                                             27
2321401 2321401 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000519 20 Ben Franklin Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   49                                             49
2324966 2324966 WI Waukesha   school 5509060 3437 Public school Menomonee Falls 550906001061 40 Benjamin Franklin Elementary and Early Learning Center   Regular School No Elementary PK 02 2020   grade_2                                                   131                                             131
2319183 2319183 WI Lafayette   school 5501110 427 Public school Benton 550111000160 20 Benton Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   14                                             14
2318391 2318391 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   71                                             71
2331507 2331507 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002006 60 Bethesda Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   69                                             69
2325392 2325392 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001256 356 Bethune Academy   Regular School No Elementary PK 08 2020   grade_2                                                   62                                             62
2326994 2326994 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006001315 20 Big Bend Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   71                                             71
2319232 2319232 WI Washburn   school 5501170 441 Public school Birchwood 550117000168 20 Birchwood Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   13                                             13
2319250 2319250 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2020   grade_2                                                   9                                             9
2332816 2332816 WI Shawano   school 5517100 6692 Public school Wittenberg-Birnamwood 551710002218 20 Birnamwood Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   39                                             39
2329735 2329735 WI Outagamie   school 5513530 5138 Public school Seymour Community 551353001769 20 Black Creek Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   46                                             46
2332712 2332712 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000170 20 Black Earth Elementary   Regular School No Elementary PK 02 2020   grade_2                                                   60                                             60
2319263 2319263 WI Lafayette   school 5505730 2240 Public school Black Hawk 550573000608 160 Black Hawk Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   27                                             27
2319300 2319300 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   41                                             41
2330173 2330173 WI Milwaukee   school 5514040 5439 Public school South Milwaukee 551404001826 10 Blakewood Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   47                                             47
2319317 2319317 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   82                                             82
2328659 2328659 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002830 150 Bluff View Elementary   Regular School No Elementary 02 04 2020   grade_2                                                   75                                             75
2319335 2319335 WI Shawano   school 5501470 602 Public school Bonduel 550147000188 20 Bonduel Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   41                                             41
2319353 2319353 WI Grant   school 5501500 609 Public school Boscobel Area 550150000192 20 Boscobel Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   45                                             45
2323040 2323040 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000800 50 Bose Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   38                                             38
2319371 2319371 WI Shawano   school 5501560 623 Public school Bowler 550156000199 20 Bowler Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   26                                             26
2329495 2329495 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310001727 25 Brandon Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   15                                             15
2323054 2323054 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000816 340 Brass Community School   Regular School No Elementary PK 05 2020   grade_2                                                   66                                             66
2329641 2329641 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001761 150 Bridges Elementary   Regular School No Elementary PK 02 2020   grade_2                                                   130                                             130
2325104 2325104 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002927 800 Bridges Virtual Academy charter Regular School Yes Other PK 12 2020   grade_2                                                   69                                             69
2319415 2319415 WI Kenosha   school 5501650 657 Public school Brighton #1 550165000205 20 Brighton Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   16                                             16
2319426 2319426 WI Calumet   school 5501680 658 Public school Brillion 550168000206 20 Brillion Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   67                                             67
2319444 2319444 WI Kenosha   school 5501710 665 Public school Bristol #1 550171000209 20 Bristol Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   80                                             80
2323063 2323063 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001285 65 Brompton School charter Regular School Yes Elementary KG 08 2020   grade_2                                                   22                                             22
2321025 2321025 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000216 40 Brookfield Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   85                                             85
2328007 2328007 WI Dane   school 5511100 4144 Public school Oregon 551110001468 20 Brooklyn Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   99                                             99
2321536 2321536 WI Walworth   school 5505130 2051 Public school Genoa City J2 550513000547 20 Brookwood Elementary   Regular School No Elementary PK 03 2020   grade_2                                                   40                                             40
2319473 2319473 WI Milwaukee   school 5501800 721 Public school Brown Deer 550180000232 80 Brown Deer Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   115                                             115
2325409 2325409 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002395 89 Brown Street Academy   Regular School No Elementary PK 05 2020   grade_2                                                   42                                             42
2325418 2325418 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001132 92 Browning Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   43                                             43
2319490 2319490 WI Rusk   school 5501830 735 Public school Bruce 550183000234 20 Bruce Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   27                                             27
2325427 2325427 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001133 93 Bruce Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   25                                             25
2319509 2319509 WI Milwaukee   school 5500059 8123 Non District Charter Schools Bruce Guadalupe 550005900772 100 Bruce Guadalupe charter Regular School Yes Elementary PK 08 2020   grade_2                                                   136                                             136
2325436 2325436 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001134 94 Bryant Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   29                                             29
2330741 2330741 WI Douglas   school 5514670 5663 Public school Superior 551467001906 40 Bryant Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   50                                             50
2325445 2325445 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001135 95 Burbank Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   61                                             61
2325457 2325457 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001136 98 Burdick Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   59                                             59
2321032 2321032 WI Waukesha   school 5501770 714 Public school Elmbrook 550177000218 80 Burleigh Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   128                                             128
2324905 2324905 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903001054 40 Butte des Morts Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   54                                             54
2319576 2319576 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   14                                             14

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