Data source: Big Local News · About: Big Local

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

View and edit SQL

year

  • 2020 · 1,113

grade

  • grade_2 · 1,113
Link rowid state county county_state_id admin_level district_nces_id district_state_id district_state_type district school_nces_id school_state_id school school_state_type ccd_school_type ccd_charter_school ccd_school_lvl ccd_school_low_grade ▼ ccd_school_high_grade year term grade white black hispanic native_american native_american_alaskan_native asian native_hawaiian asian_pacific_islander native_hawaiian_pacific_islander pacific_islander multiracial unknown_race male female non_binary unknown_gender ell ell_percent homeless homeless_percent low_income free_and_reduced free_and_reduced_percent disability section_504 total white_int black_int hispanic_int native_american_int native_american_alaskan_native_int asian_int native_hawaiian_int asian_pacific_islander_int native_hawaiian_pacific_islander_int pacific_islander_int multiracial_int unknown_race_int male_int female_int non_binary_int unknown_gender_int ell_int homeless_int low_income_int free_and_reduced_int disability_int section_504_int total_int
2318331 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2020   grade_2                                                   5                                             5
2320081 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2020   grade_2                                                   1                                             1
2320896 WI Langlade   school   1582 Public Schools-Multidistrict Charters Elcho   9100 Rural Virtual Academy charter           2020   grade_2                                                   1                                             1
2322940 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2020   grade_2                                                   1                                             1
2324699 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2020   grade_2                                                   1                                             1
2326963 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2020   grade_2                                                   3                                             3
2328421 WI Price   school   4347 Public Schools-Multidistrict Charters Phillips   9100 Rural Virtual Academy             2020   grade_2                                                   2                                             2
2328725 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2020   grade_2                                                   2                                             2
2330835 WI Clark   school   5726 Public Schools-Multidistrict Charters Thorp   9100 Rural Virtual Academy charter           2020   grade_2                                                   1                                             1
2330944 WI Monroe   school   5747 Public Schools-Multidistrict Charters Tomah Area   9100 Rural Virtual Academy charter           2020   grade_2                                                   4                                             4
2320555 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No Elementary 01 05 2020   grade_2                                                   110                                             110
2320874 WI Rock   school 5504110 1568 Public school Edgerton 550411000446 160 Yahara Elementary   Regular School No Elementary 01 05 2020   grade_2                                                   22                                             22
2321751 WI Burnett   school 5505670 2233 Public school Grantsburg 550567000601 60 Grantsburg Elementary   Regular School No Elementary 01 03 2020   grade_2                                                   65                                             65
2323008 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000797 120 Haen Elementary   Regular School No Elementary 01 04 2020   grade_2                                                   68                                             68
2324568 WI Marinette   school 5508700 3311 Public school Marinette 550870002335 40 Garfield Elementary   Regular School No Elementary 01 04 2020   grade_2                                                   44                                             44
2324583 WI Marinette   school 5508700 3311 Public school Marinette 550870000998 120 Merryman Elementary   Regular School No Elementary 01 04 2020   grade_2                                                   52                                             52
2324588 WI Marinette   school 5508700 3311 Public school Marinette 550870000999 140 Park Elementary   Regular School No Elementary 01 04 2020   grade_2                                                   57                                             57
2326521 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002442 312 Starms Discovery   Regular School No Elementary 01 08 2020   grade_2                                                   35                                             35
2326991 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999001313 130 Mount Horeb Primary Center   Regular School No Elementary 01 02 2020   grade_2                                                   156                                             156
2327103 WI Juneau   school 5510230 3871 Public school Necedah Area 551023003112 100 N-Vision Learning Center charter Regular School Yes Elementary 01 05 2020   grade_2                                                   15                                             15
2328466 WI Grant   school 5511850 4389 Public school Platteville 551185001555 120 Westview Elementary   Regular School No Elementary 01 04 2020   grade_2                                                   109                                             109
2329272 WI Richland   school 5512960 4851 Public school Richland 551296001705 240 Jefferson Elementary   Regular School No Elementary 01 05 2020   grade_2                                                   29                                             29
2329441 WI Sauk   school 5514250 5523 Public school River Valley 551425002346 120 River Valley Elementary   Regular School No Elementary 01 04 2020   grade_2                                                   68                                             68
2329915 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365002712 170 Northeast Wisconsin Montessori Charter School charter Regular School Yes Elementary 01 06 2020   grade_2                                                   4                                             4
2330621 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001392 120 Sawyer Elementary   Regular School No Elementary 01 02 2020   grade_2                                                   65                                             65
2318544 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002277 210 Odyssey-Magellan   Regular School No Middle 02 08 2020   grade_2                                                   20                                             20
2318899 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary 02 04 2020   grade_2                                                   14                                             14
2319294 WI Jackson   school 5501260 476 Public school Black River Falls 550126002428 130 Red Creek Elementary   Regular School No Elementary 02 05 2020   grade_2                                                   110                                             110
2323030 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000796 100 Quinney Elementary   Regular School No Elementary 02 04 2020   grade_2                                                   119                                             119
2326815 WI Dane   school 5509810 3675 Public school Monona Grove 550981001289 20 Cottage Grove Elementary   Regular School No Elementary 02 04 2020   grade_2                                                   151                                             151
2327929 WI Winnebago   school 5510980 4088 Public school Omro 551098002261 110 Omro Elementary   Regular School No Elementary 02 05 2020   grade_2                                                   60                                             60
2328587 WI Columbia   school 5512060 4501 Public school Portage Community 551206002310 90 Muir Elementary   Regular School No Elementary 02 05 2020   grade_2                                                   72                                             72
2328659 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002830 150 Bluff View Elementary   Regular School No Elementary 02 04 2020   grade_2                                                   75                                             75
2330902 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001933 20 Camp Douglas Elementary   Regular School No Elementary 02 05 2020   grade_2                                                   21                                             21
2331722 WI Waupaca   school 5515840 6195 Public school Waupaca 551584003091 180 Chain Exploration Center charter Regular School Yes Elementary 02 06 2020   grade_2                                                   15                                             15
2331755 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002809 110 Rock River Intermediate   Regular School No Elementary 02 06 2020   grade_2                                                   110                                             110
2318349 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2020   grade_2                                                   25                                             25
2318399 WI Outagamie   school 5500390 147 Public school Appleton Area 550039001619 110 Classical School charter Regular School Yes Elementary KG 08 2020   grade_2                                                   52                                             52
2318447 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002582 135 Fox River Academy charter Regular School Yes Elementary KG 08 2020   grade_2                                                   10                                             10
2318709 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000084 50 Pioneer Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   94                                             94
2318716 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   139                                             139
2318830 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   55                                             55
2318858 WI Sauk   school 5500810 280 Public school Baraboo 550081000107 140 North Freedom Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   20                                             20
2318868 WI Sauk   school 5500810 280 Public school Baraboo 550081000106 110 Willson Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   57                                             57
2318978 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000125 80 Jefferson Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   39                                             39
2318985 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000126 100 Lincoln Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   34                                             34
2319000 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000127 120 South Beaver Dam Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   12                                             12
2319007 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000129 160 Washington Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   32                                             32
2319014 WI Dodge   school 5500960 336 Public school Beaver Dam Unified 550096000130 180 Wilson Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   20                                             20
2319927 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000284 110 Halmstad Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   53                                             53
2319934 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000285 120 Hillcrest Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   64                                             64
2319941 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000286 140 Jim Falls Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   22                                             22
2319951 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000637 220 Parkview Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   85                                             85
2319965 WI Chippewa   school 5502550 1092 Public school Chippewa Falls Area Unified 550255000288 200 Stillson Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   64                                             64
2320061 WI Clark   school 5502730 1162 Public school Colby 550273000308 20 Colby Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   66                                             66
2320142 WI Columbia   school 5502820 1183 Public school Columbus 550282002734 110 Discovery Charter School charter Regular School Yes Elementary KG 03 2020   grade_2                                                   20                                             20
2320351 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317003065 140 Odyssey Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   11                                             11
2320421 WI Dane   school 5503180 1316 Public school De Forest Area 550318000354 20 Eagle Point Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   103                                             103
2320430 WI Dane   school 5503180 1316 Public school De Forest Area 550318000360 140 Windsor Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   118                                             118
2320436 WI Dane   school 5503180 1316 Public school De Forest Area 550318000108 160 Yahara Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   85                                             85
2320704 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000438 500 Davey Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   50                                             50
2320726 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000417 100 Flynn Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   37                                             37
2320733 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000708 590 Lakeshore Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   73                                             73
2320740 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000424 220 Locust Lane Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   35                                             35
2320747 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000425 240 Longfellow Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   46                                             46
2320754 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000427 280 Manz Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   77                                             77
2320768 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405002405 350 Meadowview Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   80                                             80
2320789 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000559 422 Northwoods Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   62                                             62
2320800 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000433 420 Putnam Heights Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   72                                             72
2320807 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000436 460 Robbins Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   77                                             77
2320814 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000437 480 Roosevelt Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   43                                             43
2320827 WI Eau Claire   school 5504050 1554 Public school Eau Claire Area 550405000439 520 Sherman Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   71                                             71
2321846 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other KG 12 2020   grade_2                                                   1                                             1
2321970 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 2020   grade_2                                                   42                                             42
2322125 WI Milwaukee   school 5505910 2296 Public school Greendale 550591002253 50 College Park Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   47                                             47
2322231 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000665 60 Lannon Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   67                                             67
2322237 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000666 100 Maple Avenue Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   73                                             73
2322243 WI Waukesha   school 5506030 2420 Public school Hamilton 550603000667 120 Marcy Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   112                                             112
2322258 WI Waukesha   school 5506030 2420 Public school Hamilton 550603001676 150 Woodside Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   117                                             117
2322291 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002913 130 Hartland Fine Arts Leadership Academy   Regular School No Elementary KG 02 2020   grade_2                                                   24                                             24
2322425 WI La Crosse   school 5506540 2562 Public school Holmen 550654002259 10 Evergreen Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   59                                             59
2322451 WI La Crosse   school 5506540 2562 Public school Holmen 550654001678 160 Sand Lake Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   68                                             68
2322556 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002409 40 Forest Glen Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   105                                             105
2322564 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000719 60 Howard Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   53                                             53
2322573 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000718 50 Meadowbrook Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   90                                             90
2322579 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663000720 100 Suamico Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   62                                             62
2322603 WI Saint Croix   school 5506690 2611 Public school Hudson 550669000725 20 Houlton Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   41                                             41
2322621 WI Saint Croix   school 5506690 2611 Public school Hudson 550669001460 140 Hudson Prairie Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   73                                             73
2322628 WI Saint Croix   school 5506690 2611 Public school Hudson 550669000730 100 North Hudson Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   45                                             45
2322644 WI Saint Croix   school 5506690 2611 Public school Hudson 550669000731 120 Rock Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   66                                             66
2322785 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2020   grade_2                                                   1                                             1
2322962 WI Jefferson   school 5507050 2702 Public school Jefferson 550705000780 85 West Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   38                                             38
2323025 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729000795 80 Park Community Charter School charter Regular School Yes Elementary KG 04 2020   grade_2                                                   44                                             44
2323063 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001285 65 Brompton School charter Regular School Yes Elementary KG 08 2020   grade_2                                                   22                                             22
2323080 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002457 130 Dimensions of Learning Academy charter Regular School Yes Elementary KG 08 2020   grade_2                                                   25                                             25
2323099 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002923 125 Edward Bain School - Dual Language   Regular School No Elementary KG 05 2020   grade_2                                                   67                                             67
2323376 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351002914 180 Kettle Moraine Explore charter Regular School Yes Elementary KG 05 2020   grade_2                                                   22                                             22
2323519 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000847 20 Janssen Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   88                                             88
2323533 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000732 60 Sunrise Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   83                                             83
2323539 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747000851 110 Westside Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   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]);