enrollments

Data source: Big Local News · About: Big Local

103,197 rows where state = "WI" sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

grade ✖

year ✖

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
113339 113339 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2015   pk_12_total 86.0                       46.0 40.0             54     11   86 86                       46 40         54   11   86
113340 113340 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   10                                             10
113341 113341 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2015   grade_2                                                   7                                             7
113342 113342 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2015   grade_3                                                   10                                             10
113343 113343 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2015   grade_4                                                   14                                             14
113344 113344 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2015   grade_5                                                   12                                             12
113345 113345 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2015   grade_6                                                   13                                             13
113346 113346 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2015   kindergarten_4_year_old                                                   12                                             12
113347 113347 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2015   kindergarten                                                   8                                             8
113348 113348 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2015   pk_12_total 106.0     1.0   4.0             63.0 48.0             38     7   111 106     1   4             63 48         38   7   111
113349 113349 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2015   grade_10                                                   14                                             14
113350 113350 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2015   grade_11                                                   28                                             28
113351 113351 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2015   grade_12                                                   21                                             21
113352 113352 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2015   grade_7                                                   19                                             19
113353 113353 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2015   grade_8                                                   14                                             14
113354 113354 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2015   grade_9                                                   15                                             15
283321 283321 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2016   pk_12_total 88.0                   1.0   50.0 39.0             49     9   89 88                   1   50 39         49   9   89
283322 283322 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2016   grade_1                                                   10                                             10
283323 283323 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2016   grade_2                                                   11                                             11
283324 283324 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2016   grade_3                                                   8                                             8
283325 283325 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2016   grade_4                                                   9                                             9
283326 283326 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2016   grade_5                                                   14                                             14
283327 283327 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2016   grade_6                                                   13                                             13
283328 283328 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2016   kindergarten_4_year_old                                                   13                                             13
283329 283329 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No 1.0 PK 06 2016   kindergarten                                                   11                                             11
283330 283330 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2016   pk_12_total 107.0         1.0         2.0   56.0 54.0             38     8   110 107         1         2   56 54         38   8   110
283331 283331 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2016   grade_10                                                   16                                             16
283332 283332 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2016   grade_11                                                   12                                             12
283333 283333 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2016   grade_12                                                   30                                             30
283334 283334 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2016   grade_7                                                   15                                             15
283335 283335 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2016   grade_8                                                   20                                             20
283336 283336 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No 3.0 07 12 2016   grade_9                                                   17                                             17
327216 327216 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   pk_12_total 96.0                       51.0 45.0             54     10   96 96                       51 45         54   10   96
327217 327217 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   grade_1                                                   12                                             12
327218 327218 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   11                                             11
327219 327219 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   grade_3                                                   13                                             13
327220 327220 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   grade_4                                                   11                                             11
327221 327221 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   11                                             11
327222 327222 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   14                                             14
327223 327223 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   kindergarten_4_year_old                                                   10                                             10
327224 327224 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   kindergarten                                                   12                                             12
327225 327225 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   2                                             2
327226 327226 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2017   pk_12_total 93.0                       44.0 49.0             40     9   93 93                       44 49         40   9   93
327227 327227 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2017   grade_10                                                   17                                             17
327228 327228 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2017   grade_11                                                   16                                             16
327229 327229 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2017   grade_12                                                   13                                             13
327230 327230 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2017   grade_7                                                   12                                             12
327231 327231 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2017   grade_8                                                   14                                             14
327232 327232 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2017   grade_9                                                   21                                             21
3090273 3090273 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2018   pk_12_total 105.0                       50.0 55.0             46     17   105 105                       50 55         46   17   105
3090274 3090274 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2018   grade_1                                                   12                                             12
3090275 3090275 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2018   grade_2                                                   13                                             13
3090276 3090276 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2018   grade_3                                                   16                                             16
3090277 3090277 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2018   grade_4                                                   12                                             12
3090278 3090278 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2018   grade_5                                                   13                                             13
3090279 3090279 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2018   grade_6                                                   13                                             13
3090280 3090280 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2018   kindergarten_4_year_old                                                   16                                             16
3090281 3090281 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2018   kindergarten                                                   8                                             8
3090282 3090282 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2018   pre_kindergarten                                                   2                                             2
3090283 3090283 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2018   pk_12_total 97.0 1.0       1.0             50.0 49.0             40     11   99 97 1       1             50 49         40   11   99
3090284 3090284 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2018   grade_10                                                   23                                             23
3090285 3090285 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2018   grade_11                                                   17                                             17
3090286 3090286 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2018   grade_12                                                   16                                             16
3090287 3090287 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2018   grade_7                                                   13                                             13
3090288 3090288 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2018   grade_8                                                   13                                             13
3090289 3090289 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2018   grade_9                                                   17                                             17
3075523 3075523 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   pk_12_total 95.0                       43.0 52.0             57     17   95 95                       43 52         57   17   95
3075524 3075524 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   grade_1                                                   9                                             9
3075525 3075525 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   grade_2                                                   11                                             11
3075526 3075526 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   grade_3                                                   12                                             12
3075527 3075527 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   grade_4                                                   14                                             14
3075528 3075528 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   grade_5                                                   11                                             11
3075529 3075529 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   grade_6                                                   12                                             12
3075530 3075530 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   kindergarten_4_year_old                                                   11                                             11
3075531 3075531 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   kindergarten                                                   14                                             14
3075532 3075532 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2019   pre_kindergarten                                                   1                                             1
3075533 3075533 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2019   pk_12_total 98.0 1.0       1.0             52.0 48.0             57     12   100 98 1       1             52 48         57   12   100
3075534 3075534 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2019   grade_10                                                   17                                             17
3075535 3075535 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2019   grade_11                                                   20                                             20
3075536 3075536 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2019   grade_12                                                   20                                             20
3075537 3075537 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2019   grade_7                                                   11                                             11
3075538 3075538 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2019   grade_8                                                   13                                             13
3075539 3075539 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2019   grade_9                                                   19                                             19
2319745 2319745 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2020   pk_12_total 98.0                       46.0 52.0             55     17   98 98                       46 52         55   17   98
2319746 2319746 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   11                                             11
2319747 2319747 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2020   grade_2                                                   9                                             9
2319748 2319748 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2020   grade_3                                                   11                                             11
2319749 2319749 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2020   grade_4                                                   13                                             13
2319750 2319750 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2020   grade_5                                                   14                                             14
2319751 2319751 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2020   grade_6                                                   12                                             12
2319752 2319752 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2020   kindergarten_4_year_old                                                   16                                             16
2319753 2319753 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2020   kindergarten                                                   12                                             12
2319754 2319754 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2020   pk_12_total 97.0 2.0 2.0 1.0   1.0         3.0   55.0 51.0             66     16   106 97 2 2 1   1         3   55 51         66   16   106
2319755 2319755 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2020   grade_10                                                   19                                             19
2319756 2319756 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2020   grade_11                                                   19                                             19
2319757 2319757 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2020   grade_12                                                   24                                             24
2319758 2319758 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2020   grade_7                                                   14                                             14
2319759 2319759 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2020   grade_8                                                   14                                             14
2319760 2319760 WI Grant   school 5502400 994 Public school Cassville 550240000265 40 Cassville High   Regular School No High 07 12 2020   grade_9                                                   16                                             16
2334527 2334527 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2021   pk_12_total 96.0                 2.0     48.0 50.0             62     16   98 96                 2     48 50         62   16   98

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