Data source: Big Local News · About: Big Local

1,111 rows where grade = "grade_4", state = "WI" and year = 2017 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2017 · 1,111

grade

  • grade_4 · 1,111
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
325626 WI Clark   school   7 Public Schools-Multidistrict Charters Abbotsford   9100 Rural Virtual Academy charter           2017   grade_4                                                   1                                             1
325832 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2017   grade_4                                                   1                                             1
326258 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2017   grade_4                                                   1                                             1
335801 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2017   grade_4                                                   1                                             1
336077 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2017   grade_4                                                   3                                             3
336603 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2017   grade_4                                                   1                                             1
337723 WI Marathon   school   5467 Public Schools-Multidistrict Charters Spencer   9100 Rural Virtual Academy charter           2017   grade_4                                                   2                                             2
338056 WI Dane   school   5656 Public Schools-Multidistrict Charters Sun Prairie Area   9803 JEDI Virtual K-12 charter           2017   grade_4                                                   1                                             1
326122 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   105                                             105
326400 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   17                                             17
326422 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   12                                             12
326434 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   67                                             67
326828 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   93                                             93
327026 WI Racine   school 5501890 777 Public school Burlington Area 550189000239 60 Cooper Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   58                                             58
327037 WI Racine   school 5501890 777 Public school Burlington Area 550189000635 120 Lyons Center   Regular School No Elementary PK 04 2017   grade_4                                                   21                                             21
327046 WI Racine   school 5501890 777 Public school Burlington Area 550189000243 140 Waller Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   84                                             84
327054 WI Racine   school 5501890 777 Public school Burlington Area 550189000244 160 Winkler Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   26                                             26
327145 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   91                                             91
327237 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   82                                             82
327372 WI Calumet   school 5502520 1085 Public school Chilton 550252000278 20 Chilton Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   94                                             94
327480 WI Rock   school 5502640 1134 Public school Clinton Community 550264000295 40 Clinton Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   73                                             73
327511 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000305 100 Longfellow Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   92                                             92
327735 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   67                                             67
327879 WI Dane   school 5503180 1316 Public school De Forest Area 550318000354 20 Eagle Point Elementary   Regular School No Elementary KG 04 2017   grade_4                                                   67                                             67
327888 WI Dane   school 5503180 1316 Public school De Forest Area 550318000360 140 Windsor Elementary   Regular School No Elementary KG 04 2017   grade_4                                                   118                                             118
327894 WI Dane   school 5503180 1316 Public school De Forest Area 550318000108 160 Yahara Elementary   Regular School No Elementary KG 04 2017   grade_4                                                   93                                             93
327909 WI Brown   school 5503210 1414 Public school De Pere 550321000363 40 Dickinson Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
327919 WI Brown   school 5503210 1414 Public school De Pere 550321001254 50 Heritage Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   91                                             91
327926 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   99                                             99
328372 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000454 60 Mound View Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   79                                             79
328460 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000465 60 Hillcrest Elementary   Regular School No Elementary KG 04 2017   grade_4                                                   83                                             83
328469 WI Pierce   school 5504320 1659 Public school Ellsworth Community 550432000468 120 Prairie View Elementary   Regular School No Elementary KG 04 2017   grade_4                                                   44                                             44
328831 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000518 40 Stormonth Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
329090 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000573 40 Gilmanton Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   8                                             8
329815 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503033 100 Honor Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   38                                             38
329845 WI Calumet   school 5506450 2534 Public school Hilbert 550645000700 20 Hilbert Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   27                                             27
329942 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   127                                             127
329956 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660000714 20 Hortonville Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   102                                             102
329974 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002958 160 North Greenville Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   70                                             70
329981 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002709 120 Bay Harbor Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   100                                             100
329997 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002409 40 Forest Glen Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   105                                             105
330006 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000719 60 Howard Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   58                                             58
330015 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000718 50 Meadowbrook Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   99                                             99
330021 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000720 100 Suamico Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   84                                             84
330037 WI Sheboygan   school 5506660 2605 Public school Howards Grove 550666000723 110 Northview Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   55                                             55
330437 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000797 120 Haen Elementary   Regular School No Elementary 01 04 2017   grade_4                                                   63                                             63
330447 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002878 110 New Directions Learning Community charter Regular School Yes Elementary PK 04 2017   grade_4                                                   43                                             43
330454 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000795 80 Park Community Charter School charter Regular School Yes Elementary KG 04 2017   grade_4                                                   46                                             46
330459 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000796 100 Quinney Elementary   Regular School No Elementary 02 04 2017   grade_4                                                   147                                             147
330938 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   89                                             89
330952 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000847 20 Janssen Elementary   Regular School No Elementary KG 04 2017   grade_4                                                   71                                             71
330966 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000732 60 Sunrise Elementary   Regular School No Elementary KG 04 2017   grade_4                                                   93                                             93
330972 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000851 110 Westside Elementary   Regular School No Elementary KG 04 2017   grade_4                                                   93                                             93
330981 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747002641 130 Woodland School   Regular School No Elementary KG 04 2017   grade_4                                                   124                                             124
331257 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771000889 100 Lake Mills Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   119                                             119
331368 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000900 20 Little Chute Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   104                                             104
331949 WI Marinette   school 5508700 3311 Public school Marinette 550870002335 40 Garfield Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   55                                             55
331965 WI Marinette   school 5508700 3311 Public school Marinette 550870000998 120 Merryman Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   50                                             50
331970 WI Marinette   school 5508700 3311 Public school Marinette 550870000999 140 Park Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   53                                             53
332106 WI Juneau   school 5508850 3360 Public school Mauston 550885001024 40 Lyndon Station Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   17                                             17
332193 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002361 180 Medford Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   117                                             117
332225 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894001047 320 Stetsonville Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   36                                             36
332537 WI Waukesha   school 5509360 3528 Public school Merton Community 550936000750 40 Merton Primary   Regular School No Elementary PK 04 2017   grade_4                                                   99                                             99
332561 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001105 40 Elm Lawn Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   109                                             109
332584 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001109 90 Northside Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   88                                             88
332591 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001110 100 Park Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   56                                             56
332598 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001111 120 Sauk Trail Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   65                                             65
332606 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951000755 150 Sunset Ridge Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   92                                             92
332613 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001113 160 West Middleton Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   98                                             98
334216 WI Dane   school 5509810 3675 Public school Monona Grove 550981001289 20 Cottage Grove Elementary   Regular School No Elementary 02 04 2017   grade_4                                                   150                                             150
334452 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017002372 20 Country Meadows Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   62                                             62
334465 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001332 80 Lakeview Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   71                                             71
334472 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001333 100 Mill Valley Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   66                                             66
334480 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001334 140 Muskego Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   49                                             49
334492 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001336 220 Tess Corners Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   75                                             75
334716 WI Green   school 5510500 3934 Public school New Glarus 551050001375 20 New Glarus Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   79                                             79
334775 WI Waupaca   school 5510590 3955 Public school New London 551059001383 40 Lincoln Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   62                                             62
334800 WI Waupaca   school 5510590 3955 Public school New London 551059001385 90 Parkview Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   60                                             60
334808 WI Waupaca   school 5510590 3955 Public school New London 551059001386 100 Readfield Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   24                                             24
334816 WI Waupaca   school 5510590 3955 Public school New London 551059001387 120 Sugar Bush Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   20                                             20
335021 WI Vilas   school 5503860 1526 Public school Northland Pines 550386003008 110 Northland Pines Montessori Learning Center (NPMLC) charter Regular School Yes Elementary PK 04 2017   grade_4                                                   9                                             9
335177 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001418 60 Greenland Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   78                                             78
335185 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001419 80 Ixonia Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   50                                             50
335192 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001420 90 Meadow View Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   88                                             88
335209 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001424 160 Park Lawn Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   71                                             71
335222 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001425 180 Summit Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   88                                             88
335268 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092001429 160 Oconto Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   73                                             73
335358 WI Dane   school 5511100 4144 Public school Oregon 551110001468 20 Brooklyn Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   90                                             90
335365 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   97                                             97
335382 WI Dane   school 5511100 4144 Public school Oregon 551110001472 50 Prairie View Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   96                                             96
335630 WI Columbia   school 5511370 4228 Public school Pardeeville Area 551137001517 60 Pardeeville Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   77                                             77
335819 WI Grant   school 5511850 4389 Public school Platteville 551185001555 120 Westview Elementary   Regular School No Elementary 01 04 2017   grade_4                                                   111                                             111
335843 WI Sheboygan   school 5511940 4473 Public school Plymouth Joint 551194001559 40 Fairview Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   50                                             50
335851 WI Sheboygan   school 5511940 4473 Public school Plymouth Joint 551194002445 50 Horizon Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   51                                             51
335859 WI Sheboygan   school 5511940 4473 Public school Plymouth Joint 551194001560 60 Parkview Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   67                                             67
335894 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200002320 40 Dunwiddie Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   50                                             50
335901 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200001567 60 Lincoln Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   66                                             66
335913 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200001569 120 Saukville Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   55                                             55
336012 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002830 150 Bluff View Elementary   Regular School No Elementary 02 04 2017   grade_4                                                   81                                             81
336063 WI Price   school 5512210 4571 Public school Prentice 551221001588 40 Prentice Elementary   Regular School No Elementary KG 04 2017   grade_4                                                   21                                             21

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