Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 1,109

grade

  • grade_4 · 1,109
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ccd_school_high_grade ▼ year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2318333 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2020   grade_4                                                   2                                             2
2318761 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2020   grade_4                                                   1                                             1
2324701 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2020   grade_4                                                   5                                             5
2326863 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2020   grade_4                                                   1                                             1
2326965 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2020   grade_4                                                   1                                             1
2328422 WI Price   school   4347 Public Schools-Multidistrict Charters Phillips   9100 Rural Virtual Academy             2020   grade_4                                                   3                                             3
2328449 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2020   grade_4                                                   1                                             1
2329221 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2020   grade_4                                                   1                                             1
2330331 WI Marathon   school   5467 Public Schools-Multidistrict Charters Spencer   9100 Rural Virtual Academy charter           2020   grade_4                                                   1                                             1
2330563 WI Dane   school   5621 Public Schools-Multidistrict Charters Stoughton Area   9803 JEDI Virtual K-12 charter           2020   grade_4                                                   1                                             1
2330595 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2020   grade_4                                                   1                                             1
2318299 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2020   grade_4                                                   1                                             1
2323784 WI Walworth   school 5507620 2885 Public school Lake Geneva J1 550762000879 20 Central - Denison Elementary   Regular School No Elementary PK 03 2020   grade_4                                                   4                                             4
2318155 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   91                                             91
2318174 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   13                                             13
2318185 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   24                                             24
2318611 WI Trempealeau   school 5500420 154 Public school Arcadia 550042003040 190 Arcadia Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   80                                             80
2318901 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary 02 04 2020   grade_4                                                   13                                             13
2318921 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   13                                             13
2318933 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   59                                             59
2319319 WI Chippewa   school 5501350 497 Public school Bloomer 550135000183 20 Bloomer Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   88                                             88
2319529 WI Racine   school 5501890 777 Public school Burlington Area 550189000239 60 Cooper Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   57                                             57
2319549 WI Racine   school 5501890 777 Public school Burlington Area 550189000635 120 Lyons Center   Regular School No Elementary PK 04 2020   grade_4                                                   18                                             18
2319562 WI Racine   school 5501890 777 Public school Burlington Area 550189000243 140 Waller Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   80                                             80
2319570 WI Racine   school 5501890 777 Public school Burlington Area 550189000244 160 Winkler Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   24                                             24
2319673 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   76                                             76
2319765 WI Sheboygan   school 5502430 1029 Public school Cedar Grove-Belgium Area 550243000266 20 Cedar Grove-Belgium Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   58                                             58
2319902 WI Calumet   school 5502520 1085 Public school Chilton 550252000278 20 Chilton Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   91                                             91
2320009 WI Rock   school 5502640 1134 Public school Clinton Community 550264000295 40 Clinton Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   78                                             78
2320040 WI Waupaca   school 5502670 1141 Public school Clintonville 550267000305 100 Longfellow Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   77                                             77
2320273 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   54                                             54
2320423 WI Dane   school 5503180 1316 Public school De Forest Area 550318000354 20 Eagle Point Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   91                                             91
2320432 WI Dane   school 5503180 1316 Public school De Forest Area 550318000360 140 Windsor Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   116                                             116
2320438 WI Dane   school 5503180 1316 Public school De Forest Area 550318000108 160 Yahara Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   85                                             85
2320452 WI Brown   school 5503210 1414 Public school De Pere 550321000363 40 Dickinson Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   106                                             106
2320462 WI Brown   school 5503210 1414 Public school De Pere 550321001254 50 Heritage Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   96                                             96
2320470 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   111                                             111
2320525 WI Walworth   school 5503640 1380 Public school Delavan-Darien 550364002239 10 Darien Elementary   Regular School No Elementary 03 04 2020   grade_4                                                   119                                             119
2320929 WI Dunn   school 5504230 1645 Public school Elk Mound Area 550423000454 60 Mound View Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   78                                             78
2321087 WI Pierce   school 5504350 1666 Public school Elmwood 550435000470 20 Elmwood Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   10                                             10
2321396 WI Milwaukee   school 5504800 1890 Public school Fox Point J2 550480000518 40 Stormonth Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   85                                             85
2321645 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000573 40 Gilmanton Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   10                                             10
2322233 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000665 60 Lannon Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   59                                             59
2322239 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000666 100 Maple Avenue Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   73                                             73
2322245 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000667 120 Marcy Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   117                                             117
2322260 WI Waukesha   school 5506030 2420 Public school Hamilton 550603001676 150 Woodside Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   116                                             116
2322361 WI Dodge   school 5500075 2525 Public school Herman-Neosho-Rubicon 550007503033 100 Honor Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   30                                             30
2322392 WI Calumet   school 5506450 2534 Public school Hilbert 550645000700 20 Hilbert Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   29                                             29
2322467 WI Washington   school 5500080 2570 Public school Holy Hill Area 550008003077 100 Friess Lake Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   40                                             40
2322502 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002407 10 Greenville Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   114                                             114
2322516 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660000714 20 Hortonville Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   101                                             101
2322534 WI Outagamie   school 5506600 2583 Public school Hortonville Area 550660002958 160 North Greenville Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   78                                             78
2322542 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002709 120 Bay Harbor Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   76                                             76
2322558 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002409 40 Forest Glen Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   99                                             99
2322566 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000719 60 Howard Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   61                                             61
2322575 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000718 50 Meadowbrook Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   115                                             115
2322581 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000720 100 Suamico Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   55                                             55
2322597 WI Sheboygan   school 5506660 2605 Public school Howards Grove 550666000723 110 Northview Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   69                                             69
2322971 WI Jefferson   school 5507170 2730 Public school Johnson Creek 550717000782 20 Johnson Creek Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   44                                             44
2323010 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000797 120 Haen Elementary   Regular School No Elementary 01 04 2020   grade_4                                                   59                                             59
2323020 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002878 110 New Directions Learning Community charter Regular School Yes Elementary PK 04 2020   grade_4                                                   36                                             36
2323027 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000795 80 Park Community Charter School charter Regular School Yes Elementary KG 04 2020   grade_4                                                   39                                             39
2323032 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000796 100 Quinney Elementary   Regular School No Elementary 02 04 2020   grade_4                                                   100                                             100
2323507 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002333 100 Zielanis Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   77                                             77
2323521 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000847 20 Janssen Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   81                                             81
2323535 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000732 60 Sunrise Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   73                                             73
2323541 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000851 110 Westside Elementary   Regular School No Elementary KG 04 2020   grade_4                                                   91                                             91
2323550 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747002641 130 Woodland School   Regular School No Elementary KG 04 2020   grade_4                                                   116                                             116
2323861 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771000889 100 Lake Mills Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   96                                             96
2323981 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816000900 20 Little Chute Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   90                                             90
2324570 WI Marinette   school 5508700 3311 Public school Marinette 550870002335 40 Garfield Elementary   Regular School No Elementary 01 04 2020   grade_4                                                   44                                             44
2324585 WI Marinette   school 5508700 3311 Public school Marinette 550870000998 120 Merryman Elementary   Regular School No Elementary 01 04 2020   grade_4                                                   39                                             39
2324590 WI Marinette   school 5508700 3311 Public school Marinette 550870000999 140 Park Elementary   Regular School No Elementary 01 04 2020   grade_4                                                   50                                             50
2324736 WI Juneau   school 5508850 3360 Public school Mauston 550885001024 40 Lyndon Station Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   9                                             9
2324748 WI Juneau   school 5508850 3360 Public school Mauston 550885003030 110 Mauston Montessori Charter School charter Regular School Yes Elementary PK 04 2020   grade_4                                                   3                                             3
2324827 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894002361 180 Medford Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   122                                             122
2324860 WI Taylor   school 5508940 3409 Public school Medford Area Public 550894001047 320 Stetsonville Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   39                                             39
2325167 WI Waukesha   school 5509360 3528 Public school Merton Community 550936000750 40 Merton Primary   Regular School No Elementary PK 04 2020   grade_4                                                   87                                             87
2325185 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001105 40 Elm Lawn Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   99                                             99
2325209 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001109 90 Northside Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   90                                             90
2325216 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001110 100 Park Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   69                                             69
2325223 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001111 120 Sauk Trail Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   73                                             73
2325230 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951000755 150 Sunset Ridge Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   102                                             102
2325237 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951001113 160 West Middleton Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   96                                             96
2326817 WI Dane   school 5509810 3675 Public school Monona Grove 550981001289 20 Cottage Grove Elementary   Regular School No Elementary 02 04 2020   grade_4                                                   153                                             153
2327059 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001336 220 Bay Lane Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   158                                             158
2327072 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001332 80 Lakeview Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   69                                             69
2327079 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001333 100 Mill Valley Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   95                                             95
2327399 WI Waupaca   school 5510590 3955 Public school New London 551059001383 40 Lincoln Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   45                                             45
2327417 WI Waupaca   school 5510590 3955 Public school New London 551059001385 90 Parkview Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   63                                             63
2327425 WI Waupaca   school 5510590 3955 Public school New London 551059001386 100 Readfield Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   29                                             29
2327433 WI Waupaca   school 5510590 3955 Public school New London 551059001387 120 Sugar Bush Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   18                                             18
2327610 WI Ozaukee   school 5504890 1945 Public school Northern Ozaukee 550489003106 120 Riveredge Outdoor Learning Elementary charter Regular School Yes Elementary KG 04 2020   grade_4                                                   8                                             8
2327641 WI Vilas   school 5503860 1526 Public school Northland Pines 550386000405 80 Northland Pines Elementary-Land O' Lakes   Regular School No Elementary PK 04 2020   grade_4                                                   6                                             6
2327649 WI Vilas   school 5503860 1526 Public school Northland Pines 550386000408 100 Northland Pines Elementary-St Germain   Regular School No Elementary PK 04 2020   grade_4                                                   10                                             10
2327664 WI Vilas   school 5503860 1526 Public school Northland Pines 550386003008 110 Northland Pines Montessori Learning Center (NPMLC) charter Regular School Yes Elementary PK 04 2020   grade_4                                                   11                                             11
2327821 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001418 60 Greenland Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   64                                             64
2327829 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001419 80 Ixonia Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   45                                             45
2327836 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001420 90 Meadow View Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   105                                             105
2327853 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001424 160 Park Lawn Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   85                                             85

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