Data source: Big Local News · About: Big Local

709 rows where grade = "grade_6", state = "WI" and year = 2019 sorted by ccd_school_high_grade

View and edit SQL

year

  • 2019 · 709

grade

  • grade_6 · 709
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
3074119 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2019   grade_6                                                   2                                             2
3075177 WI Shawano   school   623 Public Schools-Multidistrict Charters Bowler   9100 Rural Virtual Academy charter           2019   grade_6                                                   3                                             3
3075857 WI Clark   school   1162 Public Schools-Multidistrict Charters Colby   9100 Rural Virtual Academy charter           2019   grade_6                                                   2                                             2
3076889 WI Rock   school   1694 Public Schools-Multidistrict Charters Evansville Community   9803 JEDI Virtual K-12 charter           2019   grade_6                                                   1                                             1
3078689 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2019   grade_6                                                   1                                             1
3080429 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_6                                                   4                                             4
3082733 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2019   grade_6                                                   1                                             1
3084187 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2019   grade_6                                                   2                                             2
3084950 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2019   grade_6                                                   5                                             5
3086048 WI Marathon   school   5467 Public Schools-Multidistrict Charters Spencer   9100 Rural Virtual Academy charter           2019   grade_6                                                   1                                             1
3086303 WI Marathon   school   5628 Public Schools-Multidistrict Charters Stratford   9100 Rural Virtual Academy charter           2019   grade_6                                                   1                                             1
3086385 WI Dane   school   5656 Public Schools-Multidistrict Charters Sun Prairie Area   9803 JEDI Virtual K-12 charter           2019   grade_6                                                   3                                             3
3086644 WI Monroe   school   5747 Public Schools-Multidistrict Charters Tomah Area   9100 Rural Virtual Academy charter           2019   grade_6                                                   3                                             3
3073969 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   52                                             52
3074002 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   51                                             51
3074144 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002880 155 Appleton Bilingual School charter Regular School Yes Elementary KG 06 2019   grade_6                                                   15                                             15
3074161 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002583 145 Appleton Public Montessori charter Regular School Yes Elementary PK 06 2019   grade_6                                                   14                                             14
3074177 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000049 60 Badger Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   44                                             44
3074185 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002427 220 Berry Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   59                                             59
3074216 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000051 100 Edison Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   28                                             28
3074228 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002426 130 Ferber Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   89                                             89
3074251 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000054 160 Franklin Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   15                                             15
3074260 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000055 180 Highlands Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   75                                             75
3074269 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002350 190 Horizons Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   35                                             35
3074277 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002366 195 Houdini Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   89                                             89
3074285 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000056 200 Huntley Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   100                                             100
3074293 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000057 240 Jefferson Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   46                                             46
3074301 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000058 260 Johnston Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   63                                             63
3074314 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000059 280 Lincoln Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   43                                             43
3074326 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000061 320 McKinley Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   90                                             90
3074352 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000062 340 Richmond Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   43                                             43
3074360 WI Outagamie   school 5500390 147 Public school Appleton Area 550039002639 150 Stephen Foster Elementary Charter charter Regular School Yes Elementary PK 06 2019   grade_6                                                   47                                             47
3074459 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   grade_6                                                   11                                             11
3074735 WI Bayfield   school 5500900 315 Public school Bayfield 550090002358 60 La Pointe Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   2                                             2
3074802 WI Marinette   school 5511550 4263 Public school Beecher-Dunbar-Pembine 551155001529 40 Pembine Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   21                                             21
3074819 WI Dane   school 5500990 350 Public school Belleville 550099001211 100 Belleville Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   65                                             65
3074970 WI Lafayette   school 5501110 427 Public school Benton 550111000160 20 Benton Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   10                                             10
3075037 WI Washburn   school 5501170 441 Public school Birchwood 550117002937 130 Birchwood Public Montessori charter Regular School Yes Elementary PK 06 2019   grade_6                                                   2                                             2
3075091 WI Trempealeau   school 5500016 485 Public school Blair-Taylor 550001602380 34 Blair-Taylor Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   54                                             54
3075126 WI Shawano   school 5501470 602 Public school Bonduel 550147000188 20 Bonduel Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   64                                             64
3075144 WI Grant   school 5501500 609 Public school Boscobel Area 550150000192 20 Boscobel Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   55                                             55
3075162 WI Shawano   school 5501560 623 Public school Bowler 550156000199 20 Bowler Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   29                                             29
3075195 WI Dunn   school 5501590 637 Public school Boyceville Community 550159000201 20 Tiffany Creek Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   44                                             44
3075263 WI Milwaukee   school 5501800 721 Public school Brown Deer 550180000232 80 Brown Deer Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   130                                             130
3075321 WI Racine   school 5501890 777 Public school Burlington Area 550189002462 110 Dr Edward G Dyer School   Regular School No Middle 04 06 2019   grade_6                                                   226                                             226
3075381 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   71                                             71
3075529 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   12                                             12
3075778 WI Polk   school 5502610 1127 Public school Clear Lake 550261000291 20 Gaylord A Nelson Educational Center   Regular School No Elementary PK 06 2019   grade_6                                                   50                                             50
3075825 WI Buffalo   school 5502700 1155 Public school Cochrane-Fountain City 550270000306 20 Cochrane-Fountain City Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   45                                             45
3075882 WI Dunn   school 5502790 1176 Public school Colfax 550279000315 20 Colfax Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   66                                             66
3075959 WI Marinette   school 5502970 1232 Public school Crivitz 550297000329 20 Crivitz Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   58                                             58
3076233 WI Brown   school 5503210 1414 Public school De Pere 550321002488 200 Foxview Intermediate   Regular School No Middle 05 06 2019   grade_6                                                   327                                             327
3076286 WI Dane   school 5503270 1309 Public school Deerfield Community 550327000370 20 Deerfield Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   63                                             63
3076418 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   23                                             23
3076978 WI Florence   school 5504650 1855 Public school Florence County 550465000489 40 Florence Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   25                                             25
3077166 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000519 20 Ben Franklin Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   60                                             60
3077175 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000520 40 Country Dale Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   78                                             78
3077196 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000523 80 Pleasant View Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   83                                             83
3077205 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000524 100 Robinwood Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   94                                             94
3077214 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000151 120 Southwood Glen Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   64                                             64
3077356 WI Door   school 5505220 2114 Public school Gibraltar Area 550522002245 100 Gibraltar Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   48                                             48
3077390 WI Taylor   school 5505280 2135 Public school Gilman 550528000567 40 Gilman Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   24                                             24
3077463 WI Marinette   school 5505580 2212 Public school Goodman-Armstrong Creek 550558000593 20 Goodman-Armstrong Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   14                                             14
3077854 WI Green Lake   school 5505880 2310 Public school Green Lake 550588000646 20 Green Lake Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   21                                             21
3077947 WI Clark   school 5505970 2394 Public school Greenwood 550597000656 40 Greenwood Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   23                                             23
3078241 WI Dodge   school 5506570 2576 Public school Horicon 550657000711 40 Van Brunt Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   50                                             50
3078321 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002456 110 Lineville Intermediate   Regular School No Middle 05 06 2019   grade_6                                                   469                                             469
3078465 WI Waupaca   school 5506840 2639 Public school Iola-Scandinavia 550684000741 20 Iola-Scandinavia Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   46                                             46
3079280 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747002642 140 Mapleview Intermediate   Regular School No Middle 05 06 2019   grade_6                                                   189                                             189
3079295 WI Outagamie   school 5507470 2835 Public school Kimberly Area 550747002824 100 Woodland Intermediate   Regular School No Middle 05 06 2019   grade_6                                                   192                                             192
3079646 WI Forest   school 5507830 2940 Public school Laona 550783000894 40 Robinson Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   16                                             16
3079720 WI Outagamie   school 5508160 3129 Public school Little Chute Area 550816002858 100 Little Chute Intermediate   Regular School No Middle 05 06 2019   grade_6                                                   115                                             115
3079778 WI Clark   school 5508250 3206 Public school Loyal 550825000911 20 Loyal Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   36                                             36
3079796 WI Polk   school 5508280 3213 Public school Luck 550828000914 40 Luck Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   30                                             30
3079816 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834000916 100 Luxemburg-Casco Intermediate   Regular School No Elementary 03 06 2019   grade_6                                                   129                                             129
3080165 WI Waupaca   school 5508550 3276 Public school Manawa 550855000969 60 Manawa Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   39                                             39
3080175 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000973 60 Franklin Elementary   Regular School No Elementary 01 06 2019   grade_6                                                   68                                             68
3080182 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000974 100 Jackson Elementary   Regular School No Elementary 01 06 2019   grade_6                                                   49                                             49
3080189 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000975 120 Jefferson Elementary   Regular School No Elementary 01 06 2019   grade_6                                                   73                                             73
3080200 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000977 160 Madison Elementary   Regular School No Elementary 01 06 2019   grade_6                                                   41                                             41
3080212 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000978 220 Monroe Elementary   Regular School No Elementary 01 06 2019   grade_6                                                   71                                             71
3080223 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861000979 260 Stangel Elementary   Regular School No Elementary 01 06 2019   grade_6                                                   64                                             64
3080324 WI Waupaca   school 5508730 3318 Public school Marion 550873001004 80 Marion Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   41                                             41
3080366 WI Dane   school 5508790 3332 Public school Marshall 550879001012 20 Marshall Elementary   Regular School No Elementary 03 06 2019   grade_6                                                   74                                             74
3080383 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   103                                             103
3080392 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   grade_6                                                   47                                             47
3080400 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2019   grade_6                                                   50                                             50
3080418 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2019   grade_6                                                   52                                             52
3080441 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   51                                             51
3080614 WI Jackson   school 5509000 3428 Public school Melrose-Mindoro 550900001050 20 Melrose-Mindoro Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   69                                             69
3081001 WI Rock   school 5509570 3612 Public school Milton 550957000382 130 Northside Intermediate   Regular School No Middle 04 06 2019   grade_6                                                   257                                             257
3081101 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001170 188 Barbee Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   24                                             24
3082765 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006001315 20 Big Bend Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   54                                             54
3082774 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006001316 30 Clarendon Avenue Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   84                                             84
3082785 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006003354 110 Eagleville Charter School charter Regular School Yes Elementary KG 06 2019   grade_6                                                   13                                             13
3082802 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006001321 70 Prairie View Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   59                                             59
3082811 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006002251 100 Rolling Hills Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   79                                             79
3082820 WI Waukesha   school 5510060 3822 Public school Mukwonago 551006002307 80 Section Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   91                                             91
3082911 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032000579 215 Horace Mann Middle   Regular School No Middle 04 06 2019   grade_6                                                   501                                             501
3082971 WI Clark   school 5510350 3899 Public school Neillsville 551035001356 20 Neillsville Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   59                                             59

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