enrollments

Data source: Big Local News · About: Big Local

7,769 rows where grade = "grade_4" and state = "WI" sorted by county

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_4 · 7,769 ✖
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
111761 111761 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   78                                             78
111779 111779 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   14                                             14
111787 111787 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   18                                             18
281735 281735 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   67                                             67
281753 281753 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   21                                             21
281761 281761 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   16                                             16
325631 325631 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   81                                             81
325642 325642 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001454 210 Adams-Friendship Middle   Regular School No Middle 06 08 2017   grade_4                                                   1                                             1
325650 325650 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   18                                             18
325659 325659 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   17                                             17
2318155 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 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
2332959 2332959 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2021   grade_4                                                   80                                             80
3073925 3073925 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   76                                             76
3073943 3073943 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2019   grade_4                                                   22                                             22
3088673 3088673 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   74                                             74
3088691 3088691 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   24                                             24
3088699 3088699 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   31                                             31
112287 112287 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes 1.0 03 05 2015   grade_4                                                   36                                             36
112300 112300 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No 1.0 03 05 2015   grade_4                                                   89                                             89
112311 112311 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   31                                             31
113181 113181 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   17                                             17
118365 118365 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2015   grade_4                                                   28                                             28
282266 282266 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes 1.0 03 05 2016   grade_4                                                   24                                             24
282279 282279 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No 1.0 03 05 2016   grade_4                                                   103                                             103
282290 282290 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   25                                             25
283163 283163 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   13                                             13
288361 288361 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No 4.0 PK 12 2016   grade_4                                                   17                                             17
326165 326165 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Ashland Elementary Charter School charter Regular School Yes Elementary 03 05 2017   grade_4                                                   26                                             26
326178 326178 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2017   grade_4                                                   105                                             105
326189 326189 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   34                                             34
327061 327061 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   12                                             12
332235 332235 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2017   grade_4                                                   19                                             19
2318660 2318660 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   97                                             97
2318672 2318672 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2020   grade_4                                                   15                                             15
2318679 2318679 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   25                                             25
2319578 2319578 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   11                                             11
2324871 2324871 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2020   grade_4                                                   14                                             14
2333455 2333455 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   99                                             99
2333464 2333464 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   23                                             23
2334359 2334359 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   10                                             10
2339759 2339759 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other KG 12 2021   grade_4                                                   16                                             16
3074453 3074453 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2019   grade_4                                                   118                                             118
3074457 3074457 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 06 2019   grade_4                                                   14                                             14
3074470 3074470 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   37                                             37
3075359 3075359 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   11                                             11
3080599 3080599 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2019   grade_4                                                   27                                             27
3089209 3089209 WI Ashland   school 5500510 170 Public school Ashland 550051000076 60 Lake Superior Intermediate   Regular School No Elementary 03 05 2018   grade_4                                                   113                                             113
3089213 3089213 WI Ashland   school 5500510 170 Public school Ashland 550051002928 130 Lake Superior Learning Community charter Regular School Yes Elementary 03 05 2018   grade_4                                                   24                                             24
3089225 3089225 WI Ashland   school 5500510 170 Public school Ashland 550051000079 120 Marengo Valley Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   34                                             34
3090114 3090114 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   grade_4                                                   17                                             17
3095315 3095315 WI Ashland   school 5508970 3427 Public school Mellen 550897002941 800 Mellen Public School   Regular School No Other PK 12 2018   grade_4                                                   19                                             19
112510 112510 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2015   grade_4                                                   3                                             3
112521 112521 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   14                                             14
112528 112528 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes 1.0 PK 04 2015   grade_4                                                   4                                             4
112543 112543 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   10                                             10
112555 112555 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   58                                             58
113256 113256 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative Education School Yes 4.0 KG 12 2015   grade_4                                                   5                                             5
113267 113267 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   76                                             76
113460 113460 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   61                                             61
113472 113472 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2015   grade_4                                                   8                                             8
113855 113855 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   60                                             60
122200 122200 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   26                                             26
122751 122751 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001693 60 Haugen Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   18                                             18
122762 122762 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001694 80 Hilltop Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   51                                             51
122769 122769 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001695 100 Jefferson Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   22                                             22
122794 122794 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281000581 25 Tainter Elementary   Regular School No 1.0 PK 04 2015   grade_4                                                   42                                             42
124572 124572 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No 1.0 PK 08 2015   grade_4                                                   31                                             31
282490 282490 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes 4.0 KG 12 2016   grade_4                                                   2                                             2
282501 282501 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   16                                             16
282508 282508 WI Barron   school 5500870 308 Public school Barron Area 550087002717 100 Barron Area Montessori School charter Regular School Yes 1.0 PK 04 2016   grade_4                                                   3                                             3
282524 282524 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   17                                             17
282536 282536 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   60                                             60
283238 283238 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative Education School Yes 4.0 KG 12 2016   grade_4                                                   4                                             4
283249 283249 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   63                                             63
283439 283439 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   68                                             68
283450 283450 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes 4.0 PK 12 2016   grade_4                                                   6                                             6
283832 283832 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   66                                             66
283855 283855 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes 4.0 PK 12 2016   grade_4                                                   1                                             1
292160 292160 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   34                                             34
292724 292724 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001693 60 Haugen Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   19                                             19
292735 292735 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001694 80 Hilltop Elementary   Regular School No 1.0 KG 04 2016   grade_4                                                   72                                             72
292756 292756 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281000581 25 Tainter Elementary   Regular School No 1.0 PK 04 2016   grade_4                                                   90                                             90
294506 294506 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No 1.0 PK 08 2016   grade_4                                                   27                                             27
326389 326389 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2017   grade_4                                                   3                                             3
326400 326400 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   17                                             17
326422 326422 WI Barron   school 5500870 308 Public school Barron Area 550087000117 120 Ridgeland-Dallas Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   12                                             12
326434 326434 WI Barron   school 5500870 308 Public school Barron Area 550087000119 160 Woodland Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   67                                             67
327134 327134 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_4                                                   6                                             6
327145 327145 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   91                                             91
327344 327344 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102805 100 Chetek-Weyerhaeuser Roselawn Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   73                                             73
327356 327356 WI Barron   school 5500061 1080 Public school Chetek-Weyerhaeuser Area 550006102897 800 Link2Learn Virtual Charter School charter Regular School Yes Other PK 12 2017   grade_4                                                   4                                             4
327735 327735 WI Barron   school 5503090 1260 Public school Cumberland 550309000343 40 Cumberland Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   67                                             67
327760 327760 WI Barron   school 5503090 1260 Public school Cumberland 550309002871 800 Island City Virtual Academy charter Regular School Yes Other PK 12 2017   grade_4                                                   2                                             2
336038 336038 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   42                                             42
336611 336611 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001693 60 Haugen Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   17                                             17
336622 336622 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281001694 80 Hilltop Elementary   Regular School No Elementary KG 04 2017   grade_4                                                   58                                             58
336643 336643 WI Barron   school 5512810 4802 Public school Rice Lake Area 551281000581 25 Tainter Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   87                                             87
338409 338409 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No Elementary PK 08 2017   grade_4                                                   27                                             27
2318901 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

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