Data source: Big Local News · About: Big Local

7,819 rows where grade = "grade_1" and state = "WI" sorted by school

View and edit SQL

year

grade

  • grade_1 · 7,819
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
111731 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_1                                                   56                                             56
281704 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_1                                                   50                                             50
325598 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_1                                                   60                                             60
2318121 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_1                                                   47                                             47
2332927 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_1                                                   58                                             58
3073889 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_1                                                   59                                             59
3088638 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_1                                                   59                                             59
118670 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes 4.0 KG 12 2015   grade_1                                                   1                                             1
3080900 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2019   grade_1                                                   1                                             1
3095614 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   grade_1                                                   1                                             1
334516 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2017   grade_1                                                   23                                             23
2327126 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2020   grade_1                                                   23                                             23
2341995 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2021   grade_1                                                   20                                             20
3082881 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2019   grade_1                                                   22                                             22
3097592 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Alliance Charter Elementary charter Regular School Yes Elementary KG 05 2018   grade_1                                                   24                                             24
120682 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2015   grade_1                                                   23                                             23
290644 WI Winnebago   school 5510320 3892 Public school Neenah Joint 551032003366 125 ACE Charter School charter Regular School Yes 1.0 KG 05 2016   grade_1                                                   17                                             17
118798 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2015   grade_1                                                   52                                             52
288792 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes 1.0 PK 05 2016   grade_1                                                   69                                             69
332662 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2017   grade_1                                                   80                                             80
2325290 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 06 2020   grade_1                                                   75                                             75
2340183 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 07 2021   grade_1                                                   81                                             81
3081019 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2019   grade_1                                                   81                                             81
3095734 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003371 162 ALBA - Academia de Lenguaje y Bellas Artes charter Regular School Yes Elementary PK 05 2018   grade_1                                                   82                                             82
116332 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes 4.0 KG 12 2015   grade_1                                                   1                                             1
330205 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2017   grade_1                                                   1                                             1
2337641 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2021   grade_1                                                   4                                             4
3078530 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2019   grade_1                                                   2                                             2
3093277 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_1                                                   4                                             4
111742 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   45                                             45
281715 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   50                                             50
325609 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   50                                             50
2318132 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   55                                             55
2332938 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   42                                             42
3073900 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   55                                             55
3088649 WI Clark   school 5500030 7 Public school Abbotsford 550003000001 20 Abbotsford Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   58                                             58
120420 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   43                                             43
290378 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   38                                             38
334249 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   40                                             40
2326853 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   39                                             39
2341720 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   30                                             30
3082619 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   29                                             29
3097322 WI Green   school 5509840 3682 Public school Monroe 550984002771 10 Abraham Lincoln Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   35                                             35
121395 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   35                                             35
291359 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   37                                             37
335226 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   35                                             35
2327869 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   45                                             45
2342761 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   33                                             33
3083607 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   35                                             35
3098306 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   38                                             38
118782 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2015   grade_1                                                   89                                             89
288783 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No 1.0 PK 05 2016   grade_1                                                   101                                             101
332653 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2017   grade_1                                                   94                                             94
2325281 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2020   grade_1                                                   88                                             88
2340174 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2021   grade_1                                                   89                                             89
3081010 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2019   grade_1                                                   94                                             94
3095725 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001239 316 Academy of Accelerated Learning   Regular School No Elementary PK 05 2018   grade_1                                                   92                                             92
116323 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   68                                             68
286322 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   60                                             60
330196 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   44                                             44
2322773 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   56                                             56
2337632 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   54                                             54
3078522 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   44                                             44
3093268 WI Rock   school 5507020 2695 Public school Janesville 550702000756 20 Adams Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   41                                             41
111758 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   72                                             72
281732 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   50                                             50
325628 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   63                                             63
2318152 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2020   grade_1                                                   75                                             75
2332956 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2021   grade_1                                                   79                                             79
3073922 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 04 2019   grade_1                                                   69                                             69
3088670 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006001433 130 Adams-Friendship Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   46                                             46
123651 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   64                                             64
293606 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   68                                             68
337496 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   68                                             68
2330090 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   61                                             61
2344987 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   66                                             66
3085822 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   72                                             72
3100551 WI Washington   school 5513950 5390 Public school Slinger 551395002540 100 Addison Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   65                                             65
112504 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_1                                                   1                                             1
282484 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_1                                                   1                                             1
326383 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_1                                                   1                                             1
2333670 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2021   grade_1                                                   2                                             2
3089419 WI Barron   school 5500870 308 Public school Barron Area 550087002864 810 Advanced Learning Academy of Wisconsin charter Regular School Yes Other KG 12 2018   grade_1                                                   1                                             1
112441 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   58                                             58
282421 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   56                                             56
326322 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   56                                             56
2318829 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary KG 05 2020   grade_1                                                   56                                             56
2333610 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary KG 05 2021   grade_1                                                   51                                             51
3074601 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   54                                             54
3089357 WI Sauk   school 5500810 280 Public school Baraboo 550081000109 180 Al Behrman Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   64                                             64
111798 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2015   grade_1                                                   23                                             23
281771 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No 1.0 PK 04 2016   grade_1                                                   14                                             14
325669 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   26                                             26
2318182 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2020   grade_1                                                   25                                             25
2332979 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 04 2021   grade_1                                                   30                                             30
3073951 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   32                                             32
3088708 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   16                                             16
118808 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No 1.0 PK 08 2015   grade_1                                                   30                                             30
288801 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No 1.0 PK 08 2016   grade_1                                                   45                                             45
332671 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001121 75 Alcott Elementary   Regular School No Elementary PK 08 2017   grade_1                                                   37                                             37

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