enrollments

Data source: Big Local News · About: Big Local

14,617 rows where state = "WI" and year = 2016 sorted by total_int

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2016 · 14,517 ✖
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 ▼
286388 286388 WI Rock   school 5507020 2695 Public school Janesville 550702001686 180 Kennedy Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
286405 286405 WI Rock   school 5507020 2695 Public school Janesville 550702000767 220 Madison Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
286472 286472 WI Rock   school 5507020 2695 Public school Janesville 550702000776 360 Wilson Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
286473 286473 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative Education School No 4.0 04 12 2016   pk_12_total     1.0                   1.0               *     *   1     1                   1                   1
286474 286474 WI Rock   school 5507020 2695 Public school Janesville 550702002948 850 Youth Services Center   Alternative Education School No 4.0 04 12 2016   grade_10                                                   1                                             1
286485 286485 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2016   grade_10                                                   1                                             1
286487 286487 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2016   grade_12                                                   1                                             1
286488 286488 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2016   grade_7                                                   1                                             1
286489 286489 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2016   grade_8                                                   1                                             1
286490 286490 WI Jefferson   school   2702 Public Schools-Multidistrict Charters Jefferson   9803 JEDI Virtual K-12 charter           2016   grade_9                                                   1                                             1
286515 286515 WI Jefferson   school 5507050 2702 Public school Jefferson 550705000780 85 West Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
286744 286744 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002910 800 Kenosha eSchool K-12 charter Regular School Yes 4.0 KG 12 2016   grade_5                                                   1                                             1
286745 286745 WI Kenosha   school 5507320 2793 Public school Kenosha 550732002910 800 Kenosha eSchool K-12 charter Regular School Yes 4.0 KG 12 2016   grade_6                                                   1                                             1
286797 286797 WI Kenosha   school 5507320 2793 Public school Kenosha 550732001714 405 Phoenix Project   Alternative Education School No 3.0 09 12 2016   grade_11                                                   1                                             1
287023 287023 WI Kewaunee   school 5507410 2814 Public school Kewaunee 550741002768 490 Lakeshore Alternative School   Regular School No 3.0 10 12 2016   pk_12_total     1.0                   1.0               *     *   1     1                   1                   1
287024 287024 WI Kewaunee   school 5507410 2814 Public school Kewaunee 550741002768 490 Lakeshore Alternative School   Regular School No 3.0 10 12 2016   grade_12                                                   1                                             1
287159 287159 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000855 60 Emerson Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
287239 287239 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000195 110 Southern Bluffs Elementary   Regular School No 1.0 PK 05 2016   kindergarten_4_year_old                                                   1                                             1
287329 287329 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   1                                             1
287377 287377 WI Jefferson   school   2898 Public Schools-Multidistrict Charters Lake Mills Area   9803 JEDI Virtual K-12 charter           2016   pk_12_total 1.0                         1.0             *     *   1 1                         1                 1
287378 287378 WI Jefferson   school   2898 Public Schools-Multidistrict Charters Lake Mills Area   9803 JEDI Virtual K-12 charter           2016   grade_4                                                   1                                             1
287542 287542 WI Dodge   school 5508220 3171 Public school Lomira 550822000907 40 Lomira Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
287588 287588 WI Polk   school 5508280 3213 Public school Luck 550828000914 40 Luck Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   1                                             1
287731 287731 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002909 220 Innovative & Alternative Middle   Alternative Education School No 2.0 06 08 2016   grade_7                                                   1                                             1
287786 287786 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000921 65 Lindbergh Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
287817 287817 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative Education School No 4.0 04 12 2016   grade_7                                                   1                                             1
287818 287818 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002670 820 Metro School   Alternative Education School No 4.0 04 12 2016   grade_9                                                   1                                             1
287990 287990 WI Manitowoc   school 5508610 3290 Public school Manitowoc 550861002714 9120 Manitowoc County Comprehensive Charter School charter Special Education School Yes 1.0 01 08 2016   grade_3                                                   1                                             1
288105 288105 WI Marinette   school 5508700 3311 Public school Marinette 550870000999 140 Park Elementary   Regular School No 1.0 PK 04 2016   kindergarten                                                   1                                             1
288146 288146 WI Dane   school 5508790 3332 Public school Marshall 550879001791 400 Marshall Charter charter Regular School Yes 3.0 10 12 2016   grade_12                                                   1                                             1
288230 288230 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2016   grade_1                                                   1                                             1
288236 288236 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2016   kindergarten                                                   1                                             1
288237 288237 WI Juneau   school   3360 Public Schools-Multidistrict Charters Mauston   9803 JEDI Virtual K-12 charter           2016   pre_kindergarten                                                   1                                             1
288242 288242 WI Juneau   school 5508850 3360 Public school Mauston 550885001024 40 Lyndon Station Elementary   Regular School No 1.0 KG 05 2016   grade_4                                                   1                                             1
288636 288636 WI Lincoln   school 5509210 3500 Public school Merrill Area 550921002743 400 Merrill Adult Diploma Academy charter Alternative Education School Yes 3.0 10 12 2016   grade_11                                                   1                                             1
288669 288669 WI Waukesha   school 5509360 3528 Public school Merton Community 550936000750 40 Merton Primary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   1                                             1
288921 288921 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001133 93 Bruce Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
289032 289032 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001141 114 Clemens Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
289098 289098 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001146 122 Curtin Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   1                                             1
289131 289131 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001154 143 Eighty-First Street Elementary   Regular School No 1.0 PK 08 2016   grade_7                                                   1                                             1
289136 289136 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001154 143 Eighty-First Street Elementary   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   1                                             1
289196 289196 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001162 170 Fifty-Third Street Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   1                                             1
289386 289386 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001187 217 Hi-Mount Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   1                                             1
289486 289486 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001195 232 Kagel Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
289575 289575 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001204 241 Lancaster Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   1                                             1
289661 289661 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001216 268 Maryland Montessori   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   1                                             1
289853 289853 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001225 289 Ninety-Fifth Street Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
290007 290007 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002555 825 St Charles Behav Reassign Success Acad   Alternative Education School No 4.0 06 12 2016   grade_11                                                   1                                             1
290040 290040 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001250 344 Stuart Elementary   Regular School No 1.0 PK 05 2016   kindergarten_3_year_old                                                   1                                             1
290092 290092 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960001259 368 Trowbridge Street Elementary   Regular School No 1.0 PK 08 2016   kindergarten_3_year_old                                                   1                                             1
290385 290385 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2016   pk_12_total     1.0                   1.0               *     *   1     1                   1                   1
290386 290386 WI Green   school   3682 Public Schools-Multidistrict Charters Monroe   9803 JEDI Virtual K-12 charter           2016   grade_10                                                   1                                             1
290438 290438 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes 4.0 KG 12 2016   grade_7                                                   1                                             1
290439 290439 WI Marquette   school 5509870 3689 Public school Montello 550987003016 800 Montello Virtual Charter School charter Regular School Yes 4.0 KG 12 2016   grade_8                                                   1                                             1
290478 290478 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2016   grade_1                                                   1                                             1
290479 290479 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2016   grade_10                                                   1                                             1
290482 290482 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2016   grade_6                                                   1                                             1
290483 290483 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2016   grade_7                                                   1                                             1
290484 290484 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2016   grade_8                                                   1                                             1
290485 290485 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2016   grade_9                                                   1                                             1
290486 290486 WI Marathon   school   3787 Public Schools-Multidistrict Charters Mosinee   9100 Rural Virtual Academy charter           2016   kindergarten_4_year_old                                                   1                                             1
290609 290609 WI Waukesha   school 5510170 3857 Public school Muskego-Norway 551017001334 140 Muskego Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   1                                             1
290623 290623 WI Juneau   school   3871 Public Schools-Multidistrict Charters Necedah Area   9405 Juneau County Charter School charter           2016   grade_10                                                   1                                             1
290886 290886 WI Juneau   school 5510560 3948 Public school New Lisbon 551056002517 9405 Juneau County Charter School charter Regular School Yes 3.0 07 12 2016   grade_12                                                   1                                             1
290896 290896 WI Juneau   school 5510560 3948 Public school New Lisbon 551056001381 40 New Lisbon Elementary   Regular School No 1.0 PK 06 2016   pre_kindergarten                                                   1                                             1
290948 290948 WI Waupaca   school 5510590 3955 Public school New London 551059001386 100 Readfield Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   1                                             1
291015 291015 WI Waukesha   school 5510710 3976 Public school Norris 551071001395 20 Norris High   Regular School No 4.0 06 12 2016   grade_7                                                   1                                             1
291076 291076 WI Waukesha   school 5509300 3514 Public school North Lake 550930002268 20 North Lake Elementary   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   1                                             1
291172 291172 WI Vilas   school 5503860 1526 Public school Northland Pines 550386003013 410 School of Options & Applied Research High charter Regular School Yes 3.0 08 12 2016   grade_10                                                   1                                             1
291372 291372 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095002736 410 New Path charter Alternative Education School Yes 4.0 06 12 2016   grade_10                                                   1                                             1
291376 291376 WI Oconto   school 5510950 4074 Public school Oconto Falls Public 551095002736 410 New Path charter Alternative Education School Yes 4.0 06 12 2016   grade_9                                                   1                                             1
291501 291501 WI Dane   school 5511100 4144 Public school Oregon 551110001469 40 Netherwood Knoll Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   1                                             1
291811 291811 WI Lafayette   school 5501310 490 Public school Pecatonica Area 550131000181 20 Pecatonica Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
291965 291965 WI Sheboygan   school 5511940 4473 Public school Plymouth Joint 551194001559 40 Fairview Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   1                                             1
291981 291981 WI Sheboygan   school 5511940 4473 Public school Plymouth Joint 551194001560 60 Parkview Elementary   Regular School No 1.0 PK 04 2016   pre_kindergarten                                                   1                                             1
292049 292049 WI Columbia   school 5512060 4501 Public school Portage Community 551206002419 120 Endeavor Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292071 292071 WI Columbia   school 5512060 4501 Public school Portage Community 551206002945 190 Portage Partnering Preschool   Regular School No 1.0 PK 04 2016   grade_1                                                   1                                             1
292141 292141 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_1                                                   1                                             1
292142 292142 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_10                                                   1                                             1
292144 292144 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_12                                                   1                                             1
292145 292145 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_2                                                   1                                             1
292146 292146 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_4                                                   1                                             1
292147 292147 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_5                                                   1                                             1
292149 292149 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   grade_9                                                   1                                             1
292150 292150 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002944 800 Mighty River Academy of Virtual Education charter Regular School Yes 4.0 KG 12 2016   kindergarten                                                   1                                             1
292164 292164 WI Barron   school 5512180 4557 Public school Prairie Farm Public 551218001585 20 Prairie Farm Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292199 292199 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2016   grade_1                                                   1                                             1
292201 292201 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2016   grade_6                                                   1                                             1
292202 292202 WI Price   school   4571 Public Schools-Multidistrict Charters Prentice   9100 Rural Virtual Academy charter           2016   kindergarten_4_year_old                                                   1                                             1
292237 292237 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No 4.0 PK 12 2016   pre_kindergarten                                                   1                                             1
292263 292263 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001598 50 Hillcrest Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292290 292290 WI Brown   school 5512330 4613 Public school Pulaski Community 551233001601 120 Sunnyside Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292323 292323 WI Racine   school 5512360 4620 Public school Racine Unified 551236001614 121 Giese Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292374 292374 WI Racine   school 5512360 4620 Public school Racine Unified 551236001624 134 Jerstad-Agerholm Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292414 292414 WI Racine   school 5512360 4620 Public school Racine Unified 551236001628 138 Knapp Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292451 292451 WI Racine   school 5512360 4620 Public school Racine Unified 551236000458 172 P-COC   Regular School No 1.0 PK PK 2016   kindergarten_4_year_old                                                   1                                             1
292467 292467 WI Racine   school 5512360 4620 Public school Racine Unified 551236002997 100 Racine Civil Leaders Academy charter Regular School Yes 1.0 PK 06 2016   pre_kindergarten                                                   1                                             1
292497 292497 WI Racine   school 5512360 4620 Public school Racine Unified 551236001638 166 Schulte Elementary   Regular School No 1.0 PK 05 2016   pre_kindergarten                                                   1                                             1
292595 292595 WI Racine   school 5512480 4686 Public school Raymond #14 551248001656 20 Raymond Elementary   Regular School No 1.0 PK 08 2016   pre_kindergarten                                                   1                                             1
292715 292715 WI Taylor   school   4795 Public Schools-Multidistrict Charters Rib Lake   9100 Rural Virtual Academy charter           2016   grade_2                                                   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]);