Data source: Big Local News · About: Big Local

15,006 rows where state = "WI" and year = 2021 sorted by school descending

View and edit SQL

year

  • 2021 · 15,006
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
2339609 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2021   pk_12_total 64.0 1.0 16.0 2.0             4.0   47.0 40.0             54     14   87 64 1 16 2             4   47 40         54   14   87
2339610 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2021   grade_10                                                   6                                             6
2339611 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2021   grade_11                                                   20                                             20
2339612 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2021   grade_12                                                   41                                             41
2339613 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2021   grade_7                                                   4                                             4
2339614 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2021   grade_8                                                   7                                             7
2339615 WI Juneau   school 5508850 3360 Public school Mauston 550885002863 410 iLEAD Individualized Leadership and Entrepreneurship Academic Discovery charter Regular School Yes High 07 12 2021   grade_9                                                   9                                             9
2336606 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   pk_12_total 788.0 71.0 74.0 32.0   14.0         1.0   377.0 603.0     6.0       571     93   980 788 71 74 32   14         1   377 603     6   571   93   980
2336607 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_1                                                   7                                             7
2336608 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_10                                                   168                                             168
2336609 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_11                                                   209                                             209
2336610 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_12                                                   213                                             213
2336611 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_2                                                   4                                             4
2336612 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_3                                                   6                                             6
2336613 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_4                                                   13                                             13
2336614 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_5                                                   14                                             14
2336615 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_6                                                   55                                             55
2336616 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_7                                                   78                                             78
2336617 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_8                                                   104                                             104
2336618 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   grade_9                                                   101                                             101
2336619 WI Burnett   school 5505670 2233 Public school Grantsburg 550567002704 400 iForward charter Regular School Yes Other KG 12 2021   kindergarten                                                   8                                             8
2338298 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School   Regular School No Elementary PK 05 2021   pk_12_total 118.0   3.0 1.0                 59.0 63.0             26     14   122 118   3 1                 59 63         26   14   122
2338299 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School   Regular School No Elementary PK 05 2021   grade_1                                                   19                                             19
2338300 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School   Regular School No Elementary PK 05 2021   grade_2                                                   17                                             17
2338301 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School   Regular School No Elementary PK 05 2021   grade_3                                                   25                                             25
2338302 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School   Regular School No Elementary PK 05 2021   grade_4                                                   21                                             21
2338303 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School   Regular School No Elementary PK 05 2021   grade_5                                                   19                                             19
2338304 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School   Regular School No Elementary PK 05 2021   kindergarten_4_year_old                                                   1                                             1
2338305 WI Washington   school 5507380 2800 Public school Kewaskum 550738000839 100 i4Learning Community School   Regular School No Elementary PK 05 2021   kindergarten                                                   20                                             20
2334285 WI Rusk   school   735 Public Schools-Multidistrict Charters Bruce   9419 eSucceed Charter School charter           2021   pk_12_total                                                   0                                             0
2334391 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   pk_12_total 57.0   3.0               2.0   35.0 27.0             45     1   62 57   3               2   35 27         45   1   62
2334392 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_1                                                   4                                             4
2334393 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_10                                                   7                                             7
2334394 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_11                                                   8                                             8
2334395 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_12                                                   5                                             5
2334396 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_2                                                   3                                             3
2334397 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_3                                                   4                                             4
2334398 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_4                                                   6                                             6
2334399 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_5                                                   5                                             5
2334400 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_6                                                   3                                             3
2334401 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_7                                                   2                                             2
2334402 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_8                                                   8                                             8
2334403 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_9                                                   4                                             4
2334404 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   kindergarten                                                   3                                             3
2334946 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   pk_12_total 39.0         1.0         1.0   21.0 20.0             33     11   41 39         1         1   21 20         33   11   41
2334947 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_1                                                   2                                             2
2334948 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_10                                                   3                                             3
2334949 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_11                                                   2                                             2
2334950 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_12                                                   3                                             3
2334951 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_2                                                   2                                             2
2334952 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_3                                                   6                                             6
2334953 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_4                                                   2                                             2
2334954 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_5                                                   4                                             4
2334955 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_6                                                   1                                             1
2334956 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_7                                                   2                                             2
2334957 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_8                                                   3                                             3
2334958 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   grade_9                                                   4                                             4
2334959 WI Chippewa   school   1204 Public Schools-Multidistrict Charters Cornell   9419 eSucceed Charter School charter           2021   kindergarten                                                   7                                             7
2336454 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   pk_12_total 49.0 1.0                     15.0 35.0             15     3   50 49 1                     15 35         15   3   50
2336455 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_1                                                   5                                             5
2336456 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_10                                                   3                                             3
2336457 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_11                                                   8                                             8
2336458 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_12                                                   3                                             3
2336459 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_2                                                   1                                             1
2336460 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_3                                                   4                                             4
2336461 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_4                                                   2                                             2
2336462 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_5                                                   5                                             5
2336463 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_6                                                   5                                             5
2336464 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_7                                                   3                                             3
2336465 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_8                                                   6                                             6
2336466 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   grade_9                                                   4                                             4
2336467 WI Taylor   school 5505280 2135 Public school Gilman 550528003114 9419 eSucceed Charter School charter Regular School Yes Other KG 12 2021   kindergarten                                                   1                                             1
2338703 WI Chippewa   school   2891 Public Schools-Multidistrict Charters Lake Holcombe   9419 eSucceed Charter School charter           2021   pk_12_total                                                   0                                             0
2342137 WI Chippewa   school   3920 Public Schools-Multidistrict Charters New Auburn   9419 eSucceed Charter School charter           2021   pk_12_total 3.0                       2.0 1.0             *     *   3 3                       2 1                 3
2342138 WI Chippewa   school   3920 Public Schools-Multidistrict Charters New Auburn   9419 eSucceed Charter School charter           2021   grade_10                                                   1                                             1
2342139 WI Chippewa   school   3920 Public Schools-Multidistrict Charters New Auburn   9419 eSucceed Charter School charter           2021   grade_8                                                   1                                             1
2342140 WI Chippewa   school   3920 Public Schools-Multidistrict Charters New Auburn   9419 eSucceed Charter School charter           2021   kindergarten                                                   1                                             1
2345290 WI Chippewa   school   5593 Public Schools-Multidistrict Charters Stanley-Boyd Area   9419 eSucceed Charter School charter           2021   pk_12_total                                                   0                                             0
2346391 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   pk_12_total 95.0 1.0 15.0 1.0             4.0   59.0 57.0     2.0       51     5   116 95 1 15 1             4   59 57     2   51   5   116
2346392 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_1                                                   4                                             4
2346393 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_10                                                   10                                             10
2346394 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_11                                                   13                                             13
2346395 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_12                                                   11                                             11
2346396 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_2                                                   9                                             9
2346397 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_3                                                   8                                             8
2346398 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_4                                                   5                                             5
2346399 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_5                                                   9                                             9
2346400 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_6                                                   4                                             4
2346401 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_7                                                   6                                             6
2346402 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_8                                                   13                                             13
2346403 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   grade_9                                                   10                                             10
2346404 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   kindergarten_4_year_old                                                   3                                             3
2346405 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575003127 800 eCampus Academy Charter School charter Regular School Yes Other PK 12 2021   kindergarten                                                   11                                             11
2346481 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2021   pk_12_total 165.0 20.0 46.0     5.0         24.0   135.0 125.0     5.0       101     28   260 165 20 46     5         24   135 125     5   101   28   260
2346482 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2021   grade_1                                                   46                                             46
2346483 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2021   grade_2                                                   40                                             40
2346484 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2021   grade_3                                                   34                                             34
2346485 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2021   grade_4                                                   51                                             51
2346486 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2021   grade_5                                                   48                                             48
2346487 WI Waukesha   school 5515780 6174 Public school Waukesha 551578003003 150 eAchieve Elementary charter Regular School Yes Elementary KG 05 2021   kindergarten                                                   41                                             41

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