enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
112366 112366 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   55                                             55
118180 118180 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   grade_4                                                   101                                             101
118188 118188 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2015   grade_4                                                   49                                             49
118196 118196 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2015   grade_4                                                   46                                             46
118214 118214 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2015   grade_4                                                   29                                             29
118222 118222 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   49                                             49
120781 120781 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No 2.0 04 08 2015   grade_4                                                   56                                             56
120787 120787 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes 2.0 04 08 2015   grade_4                                                   10                                             10
121950 121950 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No 1.0 PK 08 2015   grade_4                                                   43                                             43
122045 122045 WI Wood   school 5511970 4508 Public school Port Edwards 551197001565 60 Port Edwards Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   28                                             28
126201 126201 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   44                                             44
126209 126209 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   45                                             45
126217 126217 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No 1.0 KG 05 2015   grade_4                                                   67                                             67
126228 126228 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes 1.0 PK 05 2015   grade_4                                                   55                                             55
126241 126241 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy charter Regular School Yes 1.0 PK 05 2015   grade_4                                                   19                                             19
126249 126249 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No 1.0 PK 05 2015   grade_4                                                   16                                             16
126258 126258 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   51                                             51
126269 126269 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No 1.0 PK 05 2015   grade_4                                                   61                                             61
282346 282346 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   63                                             63
288170 288170 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2016   grade_4                                                   102                                             102
288178 288178 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2016   grade_4                                                   51                                             51
288186 288186 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2016   grade_4                                                   52                                             52
288204 288204 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2016   grade_4                                                   41                                             41
288212 288212 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2016   grade_4                                                   52                                             52
290744 290744 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No 2.0 04 08 2016   grade_4                                                   64                                             64
290750 290750 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes 2.0 04 08 2016   grade_4                                                   7                                             7
291911 291911 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No 1.0 PK 08 2016   grade_4                                                   43                                             43
292005 292005 WI Wood   school 5511970 4508 Public school Port Edwards 551197001565 60 Port Edwards Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   27                                             27
296139 296139 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   43                                             43
296147 296147 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   43                                             43
296155 296155 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No 1.0 KG 05 2016   grade_4                                                   69                                             69
296166 296166 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes 1.0 PK 05 2016   grade_4                                                   78                                             78
296180 296180 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy charter Regular School Yes 1.0 PK 05 2016   grade_4                                                   22                                             22
296188 296188 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No 1.0 PK 05 2016   grade_4                                                   11                                             11
296197 296197 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   48                                             48
296207 296207 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No 1.0 PK 05 2016   grade_4                                                   61                                             61
326244 326244 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   62                                             62
326258 326258 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2017   grade_4                                                   1                                             1
332036 332036 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary KG 06 2017   grade_4                                                   101                                             101
332044 332044 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2017   grade_4                                                   47                                             47
332052 332052 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2017   grade_4                                                   49                                             49
332070 332070 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2017   grade_4                                                   51                                             51
332078 332078 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2017   grade_4                                                   53                                             53
334618 334618 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Elementary 04 08 2017   grade_4                                                   74                                             74
334624 334624 WI Wood   school 5510380 3906 Public school Nekoosa 551038002957 100 Central Wisconsin STEM Academy charter Regular School Yes Elementary 04 08 2017   grade_4                                                   12                                             12
335785 335785 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2017   grade_4                                                   45                                             45
335801 335801 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2017   grade_4                                                   1                                             1
335886 335886 WI Wood   school 5511970 4508 Public school Port Edwards 551197001565 60 Port Edwards Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   25                                             25
340078 340078 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   42                                             42
340086 340086 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   53                                             53
340095 340095 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2017   grade_4                                                   60                                             60
340106 340106 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2017   grade_4                                                   64                                             64
340120 340120 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2017   grade_4                                                   25                                             25
340128 340128 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2017   grade_4                                                   18                                             18
340137 340137 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   51                                             51
340147 340147 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   53                                             53
2318742 2318742 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   56                                             56
2318761 2318761 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2020   grade_4                                                   1                                             1
2324655 2324655 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   89                                             89
2324664 2324664 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   44                                             44
2324672 2324672 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   51                                             51
2324690 2324690 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2020   grade_4                                                   42                                             42
2324701 2324701 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2020   grade_4                                                   5                                             5
2324712 2324712 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   47                                             47
2327228 2327228 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2020   grade_4                                                   69                                             69
2327261 2327261 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2020   grade_4                                                   14                                             14
2328431 2328431 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2020   grade_4                                                   43                                             43
2328449 2328449 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2020   grade_4                                                   1                                             1
2328534 2328534 WI Wood   school 5511970 4508 Public school Port Edwards 551197001565 60 Port Edwards Elementary   Regular School No Elementary PK 04 2020   grade_4                                                   33                                             33
2332733 2332733 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003088 190 Central Oaks Academy   Regular School No Elementary PK 08 2020   grade_4                                                   22                                             22
2332744 2332744 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   34                                             34
2332753 2332753 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   24                                             24
2332762 2332762 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2020   grade_4                                                   54                                             54
2332774 2332774 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   65                                             65
2332787 2332787 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2020   grade_4                                                   36                                             36
2332795 2332795 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   56                                             56
2332806 2332806 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2020   grade_4                                                   52                                             52
2333525 2333525 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   50                                             50
2333543 2333543 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_4                                                   2                                             2
2339544 2339544 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   92                                             92
2339552 2339552 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   39                                             39
2339560 2339560 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   45                                             45
2339578 2339578 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2021   grade_4                                                   44                                             44
2339589 2339589 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_4                                                   5                                             5
2339600 2339600 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   grade_4                                                   49                                             49
2342098 2342098 WI Wood   school 5510380 3906 Public school Nekoosa 551038001358 20 Alexander Middle   Regular School No Middle 04 08 2021   grade_4                                                   70                                             70
2342130 2342130 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2021   grade_4                                                   15                                             15
2343324 2343324 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2021   grade_4                                                   41                                             41
2343427 2343427 WI Wood   school 5511970 4508 Public school Port Edwards 551197001565 60 Port Edwards Ed Heuer Elementary School   Regular School No Elementary PK 04 2021   grade_4                                                   32                                             32
2347724 2347724 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003088 190 Central Oaks Academy   Regular School No Elementary PK 08 2021   grade_4                                                   37                                             37
2347735 2347735 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   40                                             40
2347744 2347744 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   40                                             40
2347752 2347752 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2021   grade_4                                                   59                                             59
2347764 2347764 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   47                                             47
2347777 2347777 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy-Together Helping INspire Kids   Regular School No Elementary PK 05 2021   grade_4                                                   24                                             24
2347785 2347785 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   53                                             53
2347796 2347796 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   grade_4                                                   65                                             65
3074524 3074524 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   grade_4                                                   63                                             63
3080381 3080381 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_4                                                   97                                             97
3080390 3080390 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   grade_4                                                   45                                             45

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