enrollments

Data source: Big Local News · About: Big Local

1,114 rows where grade = "grade_2", state = "WI" and year = 2018 sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 1,114 ✖

grade ✖

  • grade_2 · 1,114 ✖
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
3088671 3088671 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   63                                             63
3088689 3088689 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   24                                             24
3088697 3088697 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   26                                             26
3089217 3089217 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2018   grade_2                                                   107                                             107
3089223 3089223 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   27                                             27
3090112 3090112 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   11                                             11
3095313 3095313 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2018   grade_2                                                   15                                             15
3089431 3089431 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary KG 04 2018   grade_2                                                   15                                             15
3089437 3089437 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2018   grade_2                                                   8                                             8
3089450 3089450 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   12                                             12
3089462 3089462 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   54                                             54
3090188 3090188 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2018   grade_2                                                   7                                             7
3090199 3090199 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   69                                             69
3090400 3090400 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   64                                             64
3090412 3090412 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2018   grade_2                                                   2                                             2
3090790 3090790 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   57                                             57
3090816 3090816 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2018   grade_2                                                   1                                             1
3099121 3099121 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   22                                             22
3099677 3099677 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001693 60 Haugen Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   16                                             16
3099688 3099688 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001694 80 Hilltop Elementary   Regular School No Elementary KG 04 2018   grade_2                                                   53                                             53
3099709 3099709 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281000581 25 Tainter Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   76                                             76
3101477 3101477 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   34                                             34
3089470 3089470 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   29                                             29
3089486 3089486 WI Bayfield   school 5500900 315 Public school Bayfield 550090002358 60 La Pointe Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   2                                             2
3091161 3091161 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   19                                             19
3100664 3100664 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   9                                             9
3101737 3101737 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   34                                             34
3089247 3089247 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000084 50 Pioneer Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   91                                             91
3089254 3089254 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   122                                             122
3090968 3090968 WI Brown   school 5503210 1414 Public school De Pere 550321000363 40 Dickinson Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   102                                             102
3090978 3090978 WI Brown   school 5503210 1414 Public school De Pere 550321001254 50 Heritage Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   97                                             97
3090985 3090985 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   104                                             104
3091079 3091079 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No Elementary 01 05 2018   grade_2                                                   110                                             110
3092310 3092310 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 2018   grade_2                                                   61                                             61
3092322 3092322 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000611 30 Baird Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   75                                             75
3092332 3092332 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2018   grade_2                                                   1                                             1
3092340 3092340 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000613 60 Beaumont Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   35                                             35
3092349 3092349 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000614 100 Chappell Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   53                                             53
3092357 3092357 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000616 140 Danz Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   70                                             70
3092365 3092365 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000617 175 Doty Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   49                                             49
3092376 3092376 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other PK 12 2018   grade_2                                                   2                                             2
3092399 3092399 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000620 200 Eisenhower Elementary   Regular School No Elementary 01 05 2018   grade_2                                                   77                                             77
3092405 3092405 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000621 220 Elmore Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   45                                             45
3092414 3092414 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000622 280 Fort Howard Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   34                                             34
3092431 3092431 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000624 320 Howe Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   61                                             61
3092440 3092440 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000625 340 Jackson Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   62                                             62
3092449 3092449 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000626 360 Jefferson Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   21                                             21
3092463 3092463 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000627 370 Keller Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   33                                             33
3092472 3092472 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000628 380 Kennedy Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   36                                             36
3092481 3092481 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000166 390 King Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   63                                             63
3092490 3092490 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000629 400 Langlade Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   61                                             61
3092499 3092499 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002955 150 Leonardo da Vinci School for Gifted Learners   Regular School No Elementary KG 08 2018   grade_2                                                   50                                             50
3092509 3092509 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000562 420 Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   35                                             35
3092521 3092521 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000632 430 MacArthur Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   43                                             43
3092530 3092530 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000633 435 Martin Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   49                                             49
3092538 3092538 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002431 437 McAuliffe Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   72                                             72
3092547 3092547 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000634 440 Nicolet Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   68                                             68
3092559 3092559 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582001672 160 Red Smith K-8   Regular School No Elementary PK 08 2018   grade_2                                                   64                                             64
3092576 3092576 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000639 590 Sullivan Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   110                                             110
3092584 3092584 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000640 640 Tank Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   36                                             36
3092595 3092595 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000642 680 Webster Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   64                                             64
3092604 3092604 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000643 700 Wequiock Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   23                                             23
3092617 3092617 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002406 730 Wilder Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   76                                             76
3093050 3093050 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002709 120 Bay Harbor Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   72                                             72
3093065 3093065 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002409 40 Forest Glen Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   103                                             103
3093073 3093073 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000719 60 Howard Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   63                                             63
3093082 3093082 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000718 50 Meadowbrook Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   116                                             116
3093088 3093088 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000720 100 Suamico Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   56                                             56
3099202 3099202 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001596 20 Fairview Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   20                                             20
3099210 3099210 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001597 40 Glenbrook Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   84                                             84
3099219 3099219 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001598 50 Hillcrest Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   45                                             45
3099227 3099227 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001599 60 Lannoye Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   35                                             35
3099245 3099245 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001601 120 Sunnyside Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   77                                             77
3102706 3102706 WI Brown   school 5516320 6328 Public school West De Pere 551632002726 150 Hemlock Creek Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   130                                             130
3102731 3102731 WI Brown   school 5516320 6328 Public school West De Pere 551632002139 140 Westwood Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   115                                             115
3103312 3103312 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719002228 20 Wrightstown Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   86                                             86
3088740 3088740 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_2                                                   16                                             16
3090571 3090571 WI Buffalo   school 5502700 1155 Public school Cochrane-Fountain City 550270000306 20 Cochrane-Fountain City Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   43                                             43
3092166 3092166 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000573 40 Gilmanton Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   9                                             9
3097271 3097271 WI Buffalo   school 5509780 3668 Public school Mondovi 550978001286 80 Mondovi Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   67                                             67
3092283 3092283 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000601 60 Grantsburg Elementary   Regular School No Elementary 01 03 2018   grade_2                                                   74                                             74
3100535 3100535 WI Burnett   school 5513890 5376 Public school Siren 551389001816 20 Siren Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   43                                             43
3102501 3102501 WI Burnett   school 5516230 6293 Public school Webster 551623002098 60 Webster Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   48                                             48
3089976 3089976 WI Calumet   school 5501680 658 Public school Brillion 550168000206 20 Brillion Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   71                                             71
3090426 3090426 WI Calumet   school 5502520 1085 Public school Chilton 550252000278 20 Chilton Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   87                                             87
3092915 3092915 WI Calumet   school 5506450 2534 Public school Hilbert 550645000700 20 Hilbert Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   24                                             24
3097808 3097808 WI Calumet   school 5510530 3941 Public school New Holstein 551053001378 60 New Holstein Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   62                                             62
3100963 3100963 WI Calumet   school 5514520 5614 Public school Stockbridge 551452001882 20 Stockbridge Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   16                                             16
3089871 3089871 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   84                                             84
3090132 3090132 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   50                                             50
3090453 3090453 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000284 110 Halmstad Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   77                                             77
3090460 3090460 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000285 120 Hillcrest Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   73                                             73
3090467 3090467 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000286 140 Jim Falls Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   21                                             21
3090477 3090477 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000637 220 Parkview Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   65                                             65
3090484 3090484 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002295 160 Southview Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   69                                             69
3090491 3090491 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000288 200 Stillson Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   58                                             58
3090668 3090668 WI Chippewa   school 5502880 1204 Public school Cornell 550288000323 20 Cornell Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   24                                             24
3094305 3094305 WI Chippewa   school 5507680 2891 Public school Lake Holcombe 550768000885 20 Holcombe Elementary   Regular School No Elementary PK 08 2018   grade_2                                                   23                                             23
3097723 3097723 WI Chippewa   school 5510440 3920 Public school New Auburn 551044001362 20 New Auburn Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   23                                             23
3100841 3100841 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443002363 120 Stanley Elementary   Regular School No Elementary KG 05 2018   grade_2                                                   93                                             93

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