Data source: Big Local News · About: Big Local

7,833 rows where grade = "grade_2" and state = "WI" sorted by county

View and edit SQL

year

grade

  • grade_2 · 7,733
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
2319885 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2020   grade_2                                                   3                                             3
2320271 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   58                                             58
2320297 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2020   grade_2                                                   1                                             1
2328688 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   25                                             25
2329230 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001693 60 Haugen Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   17                                             17
2329241 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001694 80 Hilltop Elementary   Regular School No Elementary KG 04 2020   grade_2                                                   50                                             50
2329257 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281000581 25 Tainter Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   103                                             103
2331077 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   43                                             43
2333674 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2021   grade_2                                                   4                                             4
2333688 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 04 2021   grade_2                                                   1                                             1
2333703 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   9                                             9
2333715 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   52                                             52
2334452 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2021   grade_2                                                   7                                             7
2334464 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   53                                             53
2334659 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   73                                             73
2334671 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2021   grade_2                                                   4                                             4
2335066 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   57                                             57
2335093 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2021   grade_2                                                   8                                             8
2343579 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   30                                             30
2344125 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001693 60 Haugen Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   20                                             20
2344136 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001694 80 Hilltop Elementary   Regular School No Elementary KG 04 2021   grade_2                                                   59                                             59
2344152 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281000581 25 Tainter Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   80                                             80
2345991 WI Barron   school 5515060 5810 Public school Turtle Lake 551506003032 810 Laker Online charter Regular School Yes Other PK 12 2021   grade_2                                                   3                                             3
2346005 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   23                                             23
3074666 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2019   grade_2                                                   1                                             1
3074675 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary KG 04 2019   grade_2                                                   12                                             12
3074680 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2019   grade_2                                                   6                                             6
3074695 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   15                                             15
3074707 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   40                                             40
3075437 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   grade_2                                                   7                                             7
3075449 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   94                                             94
3075649 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   71                                             71
3075661 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2019   grade_2                                                   3                                             3
3076043 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   68                                             68
3076071 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2019   grade_2                                                   2                                             2
3084426 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   27                                             27
3084956 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001693 60 Haugen Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   11                                             11
3084967 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001694 80 Hilltop Elementary   Regular School No Elementary KG 04 2019   grade_2                                                   52                                             52
3084987 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281000581 25 Tainter Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   69                                             69
3086775 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   28                                             28
3089431 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary KG 04 2018   grade_2                                                   15                                             15
3089437 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes Elementary PK 03 2018   grade_2                                                   8                                             8
3089450 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   12                                             12
3089462 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   54                                             54
3090188 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2018   grade_2                                                   7                                             7
3090199 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   69                                             69
3090400 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   64                                             64
3090412 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2018   grade_2                                                   2                                             2
3090790 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   57                                             57
3090816 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2018   grade_2                                                   1                                             1
3099121 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   22                                             22
3099677 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001693 60 Haugen Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   16                                             16
3099688 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001694 80 Hilltop Elementary   Regular School No Elementary KG 04 2018   grade_2                                                   53                                             53
3099709 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281000581 25 Tainter Elementary   Regular School No Elementary PK 04 2018   grade_2                                                   76                                             76
3101477 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   34                                             34
112561 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   27                                             27
112578 WI Bayfield   school 5500900 315 Public school Bayfield 550090002358 60 La Pointe Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   4                                             4
114218 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   22                                             22
123764 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   7                                             7
124830 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   30                                             30
282542 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   28                                             28
282558 WI Bayfield   school 5500900 315 Public school Bayfield 550090002358 60 La Pointe Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   3                                             3
284199 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   27                                             27
293717 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   7                                             7
294764 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   39                                             39
326440 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   20                                             20
326457 WI Bayfield   school 5500900 315 Public school Bayfield 550090002358 60 La Pointe Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   2                                             2
328097 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   25                                             25
337609 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   10                                             10
338667 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   44                                             44
2318939 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   30                                             30
2320642 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   25                                             25
2330215 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   9                                             9
2331343 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   29                                             29
2333723 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   31                                             31
2333741 WI Bayfield   school 5500900 315 Public school Bayfield 550090002358 60 La Pointe Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   2                                             2
2335443 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   16                                             16
2345119 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   7                                             7
2346266 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   36                                             36
3074715 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   28                                             28
3074731 WI Bayfield   school 5500900 315 Public school Bayfield 550090002358 60 La Pointe Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   4                                             4
3076414 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   28                                             28
3085934 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   15                                             15
3087040 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   39                                             39
3089470 WI Bayfield   school 5500900 315 Public school Bayfield 550090000120 20 Bayfield Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   29                                             29
3089486 WI Bayfield   school 5500900 315 Public school Bayfield 550090002358 60 La Pointe Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   2                                             2
3091161 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   19                                             19
3100664 WI Bayfield   school 5512030 4522 Public school South Shore 551203001571 40 South Shore Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   9                                             9
3101737 WI Bayfield   school 5515540 6027 Public school Washburn 551554002453 10 Washburn Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   34                                             34
112333 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000084 50 Pioneer Elementary   Regular School No 1.0 KG 05 2015   grade_2                                                   94                                             94
112340 WI Brown   school 5500540 182 Public school Ashwaubenon 550054000085 60 Valley View Elementary   Regular School No 1.0 01 05 2015   grade_2                                                   151                                             151
114009 WI Brown   school 5503210 1414 Public school De Pere 550321000363 40 Dickinson Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   92                                             92
114019 WI Brown   school 5503210 1414 Public school De Pere 550321001254 50 Heritage Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   91                                             91
114026 WI Brown   school 5503210 1414 Public school De Pere 550321002668 100 Susie C Altmayer Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   92                                             92
114127 WI Brown   school 5503660 1407 Public school Denmark 550366000387 60 Denmark Elementary   Regular School No 1.0 01 05 2015   grade_2                                                   103                                             103
115358 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000610 20 Aldo Leopold Community School K-8   Regular School No 1.0 PK 08 2015   grade_2                                                   62                                             62
115369 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000611 30 Baird Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   68                                             68
115378 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000612 40 Bay View   Alternative Education School No 4.0 PK 12 2015   grade_2                                                   3                                             3
115388 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000613 60 Beaumont Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   58                                             58
115396 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000614 100 Chappell Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   69                                             69

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