enrollments

Data source: Big Local News · About: Big Local

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

✎ 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
111732 111732 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2015   grade_2                                                   54                                             54
281705 281705 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes 1.0 PK 08 2016   grade_2                                                   59                                             59
325599 325599 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2017   grade_2                                                   48                                             48
2318122 2318122 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2020   grade_2                                                   55                                             55
2332928 2332928 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2021   grade_2                                                   43                                             43
3073890 3073890 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2019   grade_2                                                   60                                             60
3088639 3088639 WI Racine   school 5500045 8110 Non District Charter Schools 21st Century Preparatory School 550004502575 100 21st Century Preparatory School charter Regular School Yes Elementary PK 08 2018   grade_2                                                   52                                             52
111743 111743 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   65                                             65
281716 281716 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   49                                             49
325610 325610 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   55                                             55
2318133 2318133 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   58                                             58
2332939 2332939 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   59                                             59
3073901 3073901 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   60                                             60
3088650 3088650 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   54                                             54
111759 111759 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   72                                             72
111777 111777 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   16                                             16
111785 111785 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_2                                                   16                                             16
281733 281733 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   75                                             75
281751 281751 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   26                                             26
281759 281759 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_2                                                   23                                             23
325629 325629 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   53                                             53
325648 325648 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   24                                             24
325657 325657 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   22                                             22
2318153 2318153 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   74                                             74
2318172 2318172 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   16                                             16
2332957 2332957 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   91                                             91
3073923 3073923 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   61                                             61
3073941 3073941 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 04 2019   grade_2                                                   14                                             14
3088671 3088671 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   63                                             63
3088689 3088689 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   24                                             24
3088697 3088697 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   26                                             26
111799 111799 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   grade_2                                                   21                                             21
281772 281772 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   grade_2                                                   21                                             21
325670 325670 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   18                                             18
2318183 2318183 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   grade_2                                                   34                                             34
2332980 2332980 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2021   grade_2                                                   23                                             23
3073952 3073952 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   18                                             18
3088709 3088709 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   26                                             26
111812 111812 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   43                                             43
281784 281784 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   55                                             55
325684 325684 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   49                                             49
2318195 2318195 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   45                                             45
2332993 2332993 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   47                                             47
3073965 3073965 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   47                                             47
3088723 3088723 WI Kewaunee   school 5500150 70 Public school Algoma 550015000015 20 Algoma Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   56                                             56
111829 111829 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2015   grade_2                                                   18                                             18
281801 281801 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2016   grade_2                                                   17                                             17
325702 325702 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2017   grade_2                                                   25                                             25
2318212 2318212 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_2                                                   16                                             16
2333010 2333010 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2021   grade_2                                                   17                                             17
3073982 3073982 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2019   grade_2                                                   18                                             18
3088740 3088740 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_2                                                   16                                             16
111845 111845 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   51                                             51
281817 281817 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   35                                             35
325718 325718 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   41                                             41
2318229 2318229 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   38                                             38
2333026 2333026 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_2                                                   40                                             40
3073998 3073998 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   44                                             44
3088757 3088757 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   49                                             49
111863 111863 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No 1.0 01 05 2015   grade_2                                                   30                                             30
281835 281835 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No 1.0 01 05 2016   grade_2                                                   24                                             24
325736 325736 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond Elementary   Regular School No Elementary 01 05 2017   grade_2                                                   34                                             34
2318247 2318247 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2020   grade_2                                                   31                                             31
2333043 2333043 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2021   grade_2                                                   19                                             19
3074016 3074016 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2019   grade_2                                                   31                                             31
3088775 3088775 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000023 20 Almond-Bancroft Elementary   Regular School No Elementary PK 05 2018   grade_2                                                   21                                             21
111892 111892 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Pedersen Elementary   Regular School No 1.0 PK 03 2015   grade_2                                                   128                                             128
281864 281864 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Pedersen Elementary   Regular School No 1.0 PK 03 2016   grade_2                                                   137                                             137
325754 325754 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2017   grade_2                                                   125                                             125
2318265 2318265 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2020   grade_2                                                   123                                             123
2333061 2333061 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2021   grade_2                                                   135                                             135
3074034 3074034 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2019   grade_2                                                   119                                             119
3088793 3088793 WI Eau Claire   school 5500270 112 Public school Altoona 550027000028 80 Altoona Elementary   Regular School No Elementary PK 03 2018   grade_2                                                   108                                             108
111912 111912 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No 1.0 PK 02 2015   grade_2                                                   126                                             126
281884 281884 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No 1.0 PK 02 2016   grade_2                                                   86                                             86
325786 325786 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2017   grade_2                                                   100                                             100
2318297 2318297 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2020   grade_2                                                   106                                             106
2333093 2333093 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 03 2021   grade_2                                                   78                                             78
3074066 3074066 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2019   grade_2                                                   100                                             100
3088825 3088825 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2018   grade_2                                                   100                                             100
111927 111927 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   16                                             16
111934 111934 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   31                                             31
111942 111942 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   10                                             10
111951 111951 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   32                                             32
111958 111958 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   19                                             19
111964 111964 WI Langlade   school   140 Public Schools-Multidistrict Charters Antigo Unified   9100 Rural Virtual Academy charter           2015   grade_2                                                   1                                             1
111969 111969 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   14                                             14
111977 111977 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No 1.0 PK 05 2015   grade_2                                                   36                                             36
281899 281899 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   22                                             22
281906 281906 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   15                                             15
281914 281914 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000041 160 Mattoon Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   15                                             15
281923 281923 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   33                                             33
281930 281930 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   14                                             14
281945 281945 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   22                                             22
281952 281952 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000046 280 West Elementary   Regular School No 1.0 PK 05 2016   grade_2                                                   34                                             34
325801 325801 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000038 80 Crestwood Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   19                                             19
325808 325808 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000039 100 East Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   20                                             20
325816 325816 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000042 180 North Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   26                                             26
325823 325823 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000043 200 Pleasant View Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   22                                             22
325839 325839 WI Langlade   school 5500360 140 Public school Antigo Unified 550036000045 260 Spring Valley Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   18                                             18

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