enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_2 · 7,833 ✖
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
112364 112364 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   60                                             60
118178 118178 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2015   grade_2                                                   104                                             104
118186 118186 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2015   grade_2                                                   50                                             50
118194 118194 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2015   grade_2                                                   52                                             52
118212 118212 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2015   grade_2                                                   52                                             52
118220 118220 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   53                                             53
120793 120793 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No 1.0 PK 03 2015   grade_2                                                   91                                             91
121948 121948 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No 1.0 PK 08 2015   grade_2                                                   43                                             43
122043 122043 WI Wood   school 5511970 4508 Public school Port Edwards 551197001565 60 Port Edwards Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   18                                             18
126199 126199 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   38                                             38
126207 126207 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   52                                             52
126215 126215 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No 1.0 KG 05 2015   grade_2                                                   65                                             65
126226 126226 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_2                                                   76                                             76
126239 126239 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy charter Regular School Yes 1.0 PK 05 2015   grade_2                                                   28                                             28
126247 126247 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No 1.0 PK 05 2015   grade_2                                                   21                                             21
126256 126256 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   55                                             55
126267 126267 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   49                                             49
282344 282344 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   57                                             57
288168 288168 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No 1.0 KG 06 2016   grade_2                                                   99                                             99
288176 288176 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No 1.0 KG 06 2016   grade_2                                                   50                                             50
288184 288184 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No 1.0 KG 06 2016   grade_2                                                   58                                             58
288202 288202 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No 1.0 KG 06 2016   grade_2                                                   47                                             47
288210 288210 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   54                                             54
290757 290757 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No 1.0 PK 03 2016   grade_2                                                   77                                             77
291909 291909 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No 1.0 PK 08 2016   grade_2                                                   25                                             25
292003 292003 WI Wood   school 5511970 4508 Public school Port Edwards 551197001565 60 Port Edwards Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   30                                             30
296137 296137 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   45                                             45
296145 296145 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   40                                             40
296153 296153 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No 1.0 KG 05 2016   grade_2                                                   55                                             55
296164 296164 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_2                                                   71                                             71
296178 296178 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002212 220 THINK Academy charter Regular School Yes 1.0 PK 05 2016   grade_2                                                   23                                             23
296186 296186 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No 1.0 PK 05 2016   grade_2                                                   12                                             12
296195 296195 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   62                                             62
296205 296205 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   59                                             59
326242 326242 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   60                                             60
332034 332034 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary KG 06 2017   grade_2                                                   87                                             87
332042 332042 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2017   grade_2                                                   46                                             46
332050 332050 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2017   grade_2                                                   50                                             50
332068 332068 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2017   grade_2                                                   38                                             38
332076 332076 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   50                                             50
334631 334631 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No Elementary PK 03 2017   grade_2                                                   95                                             95
335783 335783 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2017   grade_2                                                   48                                             48
335884 335884 WI Wood   school 5511970 4508 Public school Port Edwards 551197001565 60 Port Edwards Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   25                                             25
340076 340076 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   57                                             57
340084 340084 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   43                                             43
340093 340093 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2017   grade_2                                                   55                                             55
340104 340104 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary Charter School charter Regular School Yes Elementary PK 05 2017   grade_2                                                   61                                             61
340118 340118 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_2                                                   23                                             23
340126 340126 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002791 180 Vesper Community Academy   Regular School No Elementary PK 05 2017   grade_2                                                   15                                             15
340135 340135 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   54                                             54
340145 340145 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   57                                             57
2318740 2318740 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   54                                             54
2324653 2324653 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   80                                             80
2324662 2324662 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   48                                             48
2324670 2324670 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   43                                             43
2324688 2324688 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2020   grade_2                                                   49                                             49
2324699 2324699 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2020   grade_2                                                   1                                             1
2324710 2324710 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   44                                             44
2327239 2327239 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No Elementary PK 03 2020   grade_2                                                   74                                             74
2327259 2327259 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2020   grade_2                                                   17                                             17
2328429 2328429 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   33                                             33
2328532 2328532 WI Wood   school 5511970 4508 Public school Port Edwards 551197001565 60 Port Edwards Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   39                                             39
2332731 2332731 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003088 190 Central Oaks Academy   Regular School No Elementary PK 08 2020   grade_2                                                   20                                             20
2332742 2332742 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   53                                             53
2332751 2332751 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   31                                             31
2332760 2332760 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2020   grade_2                                                   47                                             47
2332772 2332772 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   51                                             51
2332785 2332785 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_2                                                   25                                             25
2332793 2332793 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   50                                             50
2332804 2332804 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   63                                             63
2333523 2333523 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   49                                             49
2333542 2333542 WI Wood   school   203 Public Schools-Multidistrict Charters Auburndale   9100 Rural Virtual Academy charter           2021   grade_2                                                   1                                             1
2339542 2339542 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   97                                             97
2339550 2339550 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   45                                             45
2339558 2339558 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   40                                             40
2339576 2339576 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2021   grade_2                                                   43                                             43
2339587 2339587 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2021   grade_2                                                   4                                             4
2339598 2339598 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   48                                             48
2342109 2342109 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No Elementary PK 03 2021   grade_2                                                   75                                             75
2342128 2342128 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2021   grade_2                                                   11                                             11
2343322 2343322 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2021   grade_2                                                   29                                             29
2343425 2343425 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_2                                                   23                                             23
2347722 2347722 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707003088 190 Central Oaks Academy   Regular School No Elementary PK 08 2021   grade_2                                                   40                                             40
2347733 2347733 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002205 60 Grant Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   44                                             44
2347742 2347742 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002206 80 Grove Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   42                                             42
2347750 2347750 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002207 120 Howe Elementary   Regular School No Elementary KG 05 2021   grade_2                                                   46                                             46
2347762 2347762 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002781 170 Mead Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   58                                             58
2347775 2347775 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_2                                                   40                                             40
2347783 2347783 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002215 280 Washington Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   55                                             55
2347794 2347794 WI Wood   school 5517070 6685 Public school Wisconsin Rapids 551707002217 300 Woodside Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   52                                             52
3074522 3074522 WI Wood   school 5500600 203 Public school Auburndale 550060000090 40 Auburndale Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   52                                             52
3080379 3080379 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001016 40 Grant Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   97                                             97
3080388 3080388 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001018 80 Lincoln Elementary   Regular School No Elementary KG 06 2019   grade_2                                                   47                                             47
3080396 3080396 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001019 100 Madison Elementary   Regular School No Elementary KG 06 2019   grade_2                                                   42                                             42
3080414 3080414 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001022 140 Nasonville Elementary   Regular School No Elementary KG 06 2019   grade_2                                                   46                                             46
3080425 3080425 WI Wood   school   3339 Public Schools-Multidistrict Charters Marshfield Unified   9100 Rural Virtual Academy charter           2019   grade_2                                                   4                                             4
3080437 3080437 WI Wood   school 5508820 3339 Public school Marshfield Unified 550882001023 180 Washington Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   47                                             47
3082994 3082994 WI Wood   school 5510380 3906 Public school Nekoosa 551038002344 40 Humke Elementary   Regular School No Elementary PK 03 2019   grade_2                                                   77                                             77
3083014 3083014 WI Wood   school 5510380 3906 Public school Nekoosa 551038003089 800 WISE Academy charter Regular School Yes Other PK 12 2019   grade_2                                                   10                                             10
3084169 3084169 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2019   grade_2                                                   34                                             34

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