enrollments

Data source: Big Local News · About: Big Local

14,702 rows where state = "WI" and year = 2018 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2018 · 14,602 ✖
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
3092346 3092346 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000613 60 Beaumont Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092371 3092371 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000617 175 Doty Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092377 3092377 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other PK 12 2018   grade_3                                                   1                                             1
3092378 3092378 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582003009 800 Dr Rosa Minoka-Hill School   Alternative School No Other PK 12 2018   grade_4                                                   1                                             1
3092454 3092454 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000626 360 Jefferson Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092527 3092527 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000632 430 MacArthur Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092544 3092544 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002431 437 McAuliffe Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3092632 3092632 WI Green Lake   school 5505880 2310 Public school Green Lake 550588000646 20 Green Lake Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   1                                             1
3093281 3093281 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_2                                                   1                                             1
3093283 3093283 WI Rock   school 5507020 2695 Public school Janesville 550702002991 860 ARISE Virtual Academy charter Regular School Yes Other KG 12 2018   grade_4                                                   1                                             1
3093421 3093421 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative School No Other 04 12 2018   grade_9                                                   1                                             1
3093432 3093432 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2018   grade_10                                                   1                                             1
3093434 3093434 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2018   grade_8                                                   1                                             1
3093487 3093487 WI Green   school 5507230 2737 Public school Juda 550723000784 20 Juda Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3093678 3093678 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000814 310 Jeffery Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3093685 3093685 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002910 800 Kenosha eSchool K-12 charter Regular School Yes Other KG 12 2018   grade_2                                                   1                                             1
3093690 3093690 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002910 800 Kenosha eSchool K-12 charter Regular School Yes Other KG 12 2018   kindergarten                                                   1                                             1
3093692 3093692 WI Kenosha   school 5507320 2793 Public school Kenosha 550732003051 810 Kenosha Pike School   Special Education School No Other PK 12 2018   grade_10                                                   1                                             1
3093693 3093693 WI Kenosha   school 5507320 2793 Public school Kenosha 550732003051 810 Kenosha Pike School   Special Education School No Other PK 12 2018   grade_11                                                   1                                             1
3093694 3093694 WI Kenosha   school 5507320 2793 Public school Kenosha 550732003051 810 Kenosha Pike School   Special Education School No Other PK 12 2018   grade_8                                                   1                                             1
3093857 3093857 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351000374 40 Cushing Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3093925 3093925 WI Washington   school 5507380 2800 Public school Kewaskum 550738000835 40 Farmington Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3093987 3093987 WI Vernon   school   5960 Public Schools-Multidistrict Charters Kickapoo Area   9407 Vernon County Area Better Futures High charter           2018   pk_12_total   1.0                       1.0             *     *   1   1                       1                 1
3093988 3093988 WI Vernon   school   5960 Public Schools-Multidistrict Charters Kickapoo Area   9407 Vernon County Area Better Futures High charter           2018   grade_11                                                   1                                             1
3093990 3093990 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002554 405 Kiel eSchool charter Regular School Yes High 07 12 2018   grade_11                                                   1                                             1
3094059 3094059 WI Sheboygan   school 5507500 2842 Public school Kohler 550750000852 20 Kohler Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3094103 3094103 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000855 60 Emerson Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3094165 3094165 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000857 80 Northside Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3094329 3094329 WI Jefferson   school 5507710 2898 Public school Lake Mills Area 550771002901 9803 JEDI Virtual K-12 - Jefferson and Eastern Dane County Interactive charter Alternative School Yes Other PK 12 2018   kindergarten_4_year_old                                                   1                                             1
3094426 3094426 WI Walworth   school 5508070 3094 Public school Linn J6 550807000899 20 Reek Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3094519 3094519 WI Clark   school 5508250 3206 Public school Loyal 550825000911 20 Loyal Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   1                                             1
3094759 3094759 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative School No Other 04 12 2018   grade_11                                                   1                                             1
3094761 3094761 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative School No Other 04 12 2018   grade_9                                                   1                                             1
3095079 3095079 WI Dane   school 5508790 3332 Public school Marshall 550879001791 400 Marshall Charter charter Regular School Yes High 10 12 2018   grade_10                                                   1                                             1
3095164 3095164 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2018   grade_1                                                   1                                             1
3095166 3095166 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2018   grade_11                                                   1                                             1
3095167 3095167 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2018   grade_12                                                   1                                             1
3095168 3095168 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2018   grade_3                                                   1                                             1
3095169 3095169 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2018   grade_5                                                   1                                             1
3095170 3095170 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2018   grade_6                                                   1                                             1
3095171 3095171 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2018   grade_7                                                   1                                             1
3095173 3095173 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2018   grade_9                                                   1                                             1
3095175 3095175 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9405 Juneau County Charter School charter           2018   grade_11                                                   1                                             1
3095176 3095176 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9405 Juneau County Charter School charter           2018   grade_12                                                   1                                             1
3095475 3095475 WI Dunn   school 5509090 3444 Public school Menomonie Area 550909001082 220 River Heights Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3095541 3095541 WI Iron   school 5509150 3484 Public school Mercer 550915001092 40 Mercer School   Regular School No Other PK 12 2018   pre_kindergarten                                                   1                                             1
3095614 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
3095618 3095618 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_2                                                   1                                             1
3095619 3095619 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_4                                                   1                                             1
3095623 3095623 WI Dane   school 5509510 3549 Public school Middleton-Cross Plains Area 550951002818 800 21st Century eSchool charter Regular School Yes Other KG 12 2018   kindergarten                                                   1                                             1
3095865 3095865 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002395 89 Brown Street Academy   Regular School No Elementary PK 05 2018   kindergarten_3_year_old                                                   1                                             1
3095892 3095892 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001134 94 Bryant Elementary   Regular School No Elementary PK 05 2018   kindergarten_3_year_old                                                   1                                             1
3095978 3095978 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001140 110 Clarke Street Elementary   Regular School No Elementary PK 08 2018   kindergarten_3_year_old                                                   1                                             1
3096174 3096174 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001166 182 Fratney Elementary   Regular School No Elementary PK 05 2018   kindergarten_3_year_old                                                   1                                             1
3096224 3096224 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001175 193 Grant Elementary   Regular School No Elementary PK 08 2018   kindergarten_3_year_old                                                   1                                             1
3096366 3096366 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001188 218 Holmes Elementary   Regular School No Elementary PK 08 2018   kindergarten_3_year_old                                                   1                                             1
3096375 3096375 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001246 334 Honey Creek Elementary charter Regular School Yes Elementary PK 05 2018   kindergarten_3_year_old                                                   1                                             1
3096444 3096444 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001196 235 Keefe Avenue Elementary   Regular School No Elementary PK 08 2018   kindergarten_3_year_old                                                   1                                             1
3096502 3096502 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002567 296 Lad Lake Synergy School   Alternative School No High 06 12 2018   grade_8                                                   1                                             1
3096588 3096588 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001213 265 Manitoba Elementary   Regular School No Elementary PK 08 2018   kindergarten_3_year_old                                                   1                                             1
3096649 3096649 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002720 103 Milwaukee Academy of Chinese Language   Regular School No Elementary PK 08 2018   kindergarten_3_year_old                                                   1                                             1
3096923 3096923 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001174 194 River Trail Elementary   Regular School No Elementary PK 08 2018   kindergarten_3_year_old                                                   1                                             1
3096976 3096976 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960003057 442 South Accelerated Academy   Alternative School No High 09 12 2018   grade_12                                                   1                                             1
3097030 3097030 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001255 360 Thoreau Elementary   Regular School No Elementary PK 08 2018   kindergarten_3_year_old                                                   1                                             1
3097071 3097071 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001259 368 Trowbridge Street School of Great Lakes Studies   Regular School No Elementary PK 08 2018   kindergarten_3_year_old                                                   1                                             1
3097130 3097130 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001270 397 Whitman Elementary   Regular School No Elementary PK 08 2018   kindergarten_3_year_old                                                   1                                             1
3097159 3097159 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960000681 399 Wisconsin Conservatory of Lifelong Learning   Regular School No Other PK 12 2018   kindergarten_3_year_old                                                   1                                             1
3097246 3097246 WI Oneida   school 5509690 3640 Public school Minocqua J1 550969001278 20 Minocqua Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3097330 3097330 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2018   grade_10                                                   1                                             1
3097332 3097332 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2018   grade_8                                                   1                                             1
3097382 3097382 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes Other KG 12 2018   grade_1                                                   1                                             1
3097386 3097386 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes Other KG 12 2018   grade_3                                                   1                                             1
3097387 3097387 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes Other KG 12 2018   grade_4                                                   1                                             1
3097390 3097390 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes Other KG 12 2018   grade_8                                                   1                                             1
3097428 3097428 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2018   grade_1                                                   1                                             1
3097432 3097432 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2018   grade_3                                                   1                                             1
3097433 3097433 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2018   grade_4                                                   1                                             1
3097436 3097436 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2018   kindergarten_4_year_old                                                   1                                             1
3097582 3097582 WI Juneau   school 5510230 3871 Public school Necedah Area 551023001337 20 Necedah Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3097713 3097713 WI Wood   school 5510380 3906 Public school Nekoosa 551038002617 400 Nekoosa Academy   Alternative School No High 09 12 2018   grade_10                                                   1                                             1
3097825 3097825 WI Juneau   school 5510560 3948 Public school New Lisbon 551056002517 9405 Juneau County Charter School charter Regular School Yes High 07 12 2018   grade_11                                                   1                                             1
3097870 3097870 WI Waupaca   school 5510590 3955 Public school New London 551059002943 410 Next Generation Academy charter Regular School Yes High 07 12 2018   grade_7                                                   1                                             1
3097894 3097894 WI Waupaca   school 5510590 3955 Public school New London 551059001387 120 Sugar Bush Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
3097969 3097969 WI Racine   school 5512510 4690 Public school North Cape 551251001657 20 North Cape Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098017 3098017 WI Waukesha   school 5509300 3514 Public school North Lake 550930002268 20 North Lake Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098029 3098029 WI Vilas   school 5501530 616 Public school North Lakeland 550153000198 50 North Lakeland Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098106 3098106 WI Vilas   school 5503860 1526 Public school Northland Pines 550386003013 410 School of Options & Applied Research High charter Regular School Yes High 08 12 2018   grade_8                                                   1                                             1
3098136 3098136 WI Washburn   school 5509720 3654 Public school Northwood 550972003018 800 Northwood Virtual Charter School charter Regular School Yes Other PK 12 2018   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
3098137 3098137 WI Washburn   school 5509720 3654 Public school Northwood 550972003018 800 Northwood Virtual Charter School charter Regular School Yes Other PK 12 2018   grade_12                                                   1                                             1
3098166 3098166 WI Racine   school 5510800 4011 Public school Norway J7 551080001405 20 Drought Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098200 3098200 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001408 40 Edgewood Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3098313 3098313 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001431 20 Abrams Elementary   Regular School No Elementary PK 05 2018   pre_kindergarten                                                   1                                             1
3098315 3098315 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001853 400 Falls Alternative Learning Site (FALS) charter Regular School Yes High 09 12 2018   grade_10                                                   1                                             1
3098318 3098318 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095001853 400 Falls Alternative Learning Site (FALS) charter Regular School Yes High 09 12 2018   grade_9                                                   1                                             1
3098350 3098350 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092003060 800 Northeast Wisconsin Learning Academy   Alternative School No High 05 12 2018   grade_9                                                   1                                             1
3098711 3098711 WI Columbia   school 5511370 4228 Public school Pardeeville Area 551137001517 60 Pardeeville Elementary   Regular School No Elementary PK 04 2018   pre_kindergarten                                                   1                                             1
3098840 3098840 WI Vilas   school 5511710 4330 Public school Phelps 551171001539 10 Phelps Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098875 3098875 WI Wood   school 5511790 4368 Public school Pittsville 551179001546 20 Pittsville Elementary   Regular School No Elementary PK 08 2018   pre_kindergarten                                                   1                                             1
3098882 3098882 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2018   grade_11                                                   1                                             1
3098883 3098883 WI Wood   school   4368 Public Schools-Multidistrict Charters Pittsville   9100 Rural Virtual Academy charter           2018   grade_3                                                   1                                             1

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