Data source: Big Local News · About: Big Local

1,048 rows where grade = "grade_5", state = "WI" and year = 2017 sorted by county

View and edit SQL

year

  • 2017 · 1,048

grade

  • grade_5 · 1,048
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
325632 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   62                                             62
325651 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   22                                             22
325660 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   16                                             16
326166 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   grade_5                                                   23                                             23
326179 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2017   grade_5                                                   112                                             112
326190 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   24                                             24
327062 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   12                                             12
332236 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_5                                                   18                                             18
326390 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_5                                                   1                                             1
326426 WI Barron   school 5500870 308 Public school Barron Area 550087000118 140 Riverview Middle   Regular School No Middle 05 08 2017   grade_5                                                   89                                             89
327135 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_5                                                   3                                             3
327154 WI Barron   school 5502130 903 Public school Cameron 550213002286 200 Cameron Middle   Regular School No Middle 05 08 2017   grade_5                                                   66                                             66
327345 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   71                                             71
327357 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2017   grade_5                                                   7                                             7
327745 WI Barron   school 5503090 1260 Public school Cumberland 550309000304 50 Cumberland Middle   Regular School No Middle 05 08 2017   grade_5                                                   72                                             72
327761 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2017   grade_5                                                   1                                             1
336039 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   41                                             41
336635 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001697 140 Rice Lake Middle   Regular School No Middle 05 08 2017   grade_5                                                   177                                             177
338410 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No Elementary PK 08 2017   grade_5                                                   26                                             26
326443 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   19                                             19
328100 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   30                                             30
337612 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   13                                             13
338670 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   47                                             47
326214 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000084 50 Pioneer Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   74                                             74
326221 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   124                                             124
327913 WI Brown   school 5503210 1414 Public school De Pere 550321002488 200 Foxview Intermediate   Regular School No Middle 05 06 2017   grade_5                                                   302                                             302
328018 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No Elementary 01 05 2017   grade_5                                                   102                                             102
329237 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 2017   grade_5                                                   62                                             62
329249 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000611 30 Baird Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   69                                             69
329258 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative School No Other PK 12 2017   grade_5                                                   1                                             1
329268 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000613 60 Beaumont Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   48                                             48
329276 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000614 100 Chappell Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   51                                             51
329285 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000616 140 Danz Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   90                                             90
329292 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000617 175 Doty Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   47                                             47
329304 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other PK 12 2017   grade_5                                                   1                                             1
329327 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000620 200 Eisenhower Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   72                                             72
329334 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000621 220 Elmore Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   53                                             53
329343 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000622 280 Fort Howard Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   37                                             37
329360 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000624 320 Howe Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   76                                             76
329369 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000625 340 Jackson Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   49                                             49
329378 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000626 360 Jefferson Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   26                                             26
329391 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000627 370 Keller Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   47                                             47
329400 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000628 380 Kennedy Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   41                                             41
329409 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000166 390 King Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   68                                             68
329418 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000629 400 Langlade Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   38                                             38
329427 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 2017   grade_5                                                   43                                             43
329437 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000562 420 Lincoln Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   34                                             34
329450 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000632 430 MacArthur Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   33                                             33
329459 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000633 435 Martin Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   54                                             54
329467 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002431 437 McAuliffe Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   79                                             79
329475 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000634 440 Nicolet Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   82                                             82
329487 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582001672 160 Red Smith K-8   Regular School No Elementary PK 08 2017   grade_5                                                   90                                             90
329504 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000639 590 Sullivan Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   100                                             100
329512 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000640 640 Tank Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   43                                             43
329523 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000642 680 Webster Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   39                                             39
329532 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000643 700 Wequiock Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   17                                             17
329546 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002406 730 Wilder Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   63                                             63
330009 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002456 110 Lineville Intermediate   Regular School No Middle 05 06 2017   grade_5                                                   448                                             448
336122 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001596 20 Fairview Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   13                                             13
336130 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001597 40 Glenbrook Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   86                                             86
336139 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001598 50 Hillcrest Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   43                                             43
336147 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001599 60 Lannoye Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   21                                             21
336165 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001601 120 Sunnyside Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   71                                             71
339633 WI Brown   school 5516320 6328 Public school West De Pere 551632002726 150 Hemlock Creek Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   145                                             145
339656 WI Brown   school 5516320 6328 Public school West De Pere 551632002139 140 Westwood Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   130                                             130
340246 WI Brown   school 5517190 6734 Public school Wrightstown Community 551719000280 30 Wrightstown Middle   Regular School No Middle 05 08 2017   grade_5                                                   92                                             92
325705 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2017   grade_5                                                   16                                             16
327518 WI Buffalo   school 5502700 1155 Public school Cochrane-Fountain City 550270000306 20 Cochrane-Fountain City Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   44                                             44
329100 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537002907 250 Gilmanton Middle   Regular School No Middle 05 08 2017   grade_5                                                   10                                             10
334202 WI Buffalo   school 5509780 3668 Public school Mondovi 550978001286 80 Mondovi Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   62                                             62
329216 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000603 100 Grantsburg Middle   Regular School No Elementary 04 08 2017   grade_5                                                   56                                             56
337483 WI Burnett   school 5513890 5376 Public school Siren 551389001816 20 Siren Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   37                                             37
339433 WI Burnett   school 5516230 6293 Public school Webster 551623002100 100 Webster Middle   Regular School No Middle 05 08 2017   grade_5                                                   51                                             51
326927 WI Calumet   school 5501680 658 Public school Brillion 550168000206 20 Brillion Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   63                                             63
327382 WI Calumet   school 5502520 1085 Public school Chilton 550252002430 30 Chilton Middle   Regular School No Middle 05 08 2017   grade_5                                                   91                                             91
329854 WI Calumet   school 5506450 2534 Public school Hilbert 550645001458 200 Hilbert Middle   Regular School No Middle 05 08 2017   grade_5                                                   21                                             21
334735 WI Calumet   school 5510530 3941 Public school New Holstein 551053001378 60 New Holstein Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   67                                             67
337912 WI Calumet   school 5514520 5614 Public school Stockbridge 551452001882 20 Stockbridge Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   18                                             18
326838 WI Chippewa   school 5501350 497 Public school Bloomer 550135000185 60 Bloomer Middle   Regular School No Middle 05 08 2017   grade_5                                                   83                                             83
327079 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   69                                             69
327400 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000284 110 Halmstad Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   59                                             59
327407 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000285 120 Hillcrest Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   85                                             85
327414 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000286 140 Jim Falls Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   27                                             27
327424 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000637 220 Parkview Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   81                                             81
327431 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255002295 160 Southview Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   50                                             50
327438 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000288 200 Stillson Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   57                                             57
327613 WI Chippewa   school 5502880 1204 Public school Cornell 550288000323 20 Cornell Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   32                                             32
331239 WI Chippewa   school 5507680 2891 Public school Lake Holcombe 550768000885 20 Holcombe Elementary   Regular School No Elementary PK 08 2017   grade_5                                                   20                                             20
334650 WI Chippewa   school 5510440 3920 Public school New Auburn 551044001362 20 New Auburn Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   18                                             18
337788 WI Chippewa   school 5514430 5593 Public school Stanley-Boyd Area 551443002363 120 Stanley Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   78                                             78
325613 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   53                                             53
327534 WI Clark   school 5502730 1162 Public school Colby 550273000308 20 Colby Elementary   Regular School No Elementary KG 05 2017   grade_5                                                   71                                             71
329194 WI Clark   school 5505640 2226 Public school Granton Area 550564000599 20 Granton Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   20                                             20
329648 WI Clark   school 5505970 2394 Public school Greenwood 550597000656 40 Greenwood Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   14                                             14
331438 WI Clark   school 5508250 3206 Public school Loyal 550825000911 20 Loyal Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   31                                             31
334605 WI Clark   school 5510350 3899 Public school Neillsville 551035001356 20 Neillsville Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   67                                             67
335586 WI Clark   school 5511310 4207 Public school Owen-Withee 551131001509 20 Owen-Withee Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   29                                             29
338197 WI Clark   school 5514820 5726 Public school Thorp 551482001925 20 Thorp Elementary   Regular School No Elementary PK 08 2017   grade_5                                                   45                                             45
327097 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000253 60 Cambria Friesland Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   31                                             31
327599 WI Columbia   school 5502820 1183 Public school Columbus 550282000319 20 Columbus Middle   Regular School No Elementary 04 08 2017   grade_5                                                   92                                             92

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