enrollments

Data source: Big Local News · About: Big Local

14,664 rows where state = "WI" and year = 2017 sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 14,664 ✖
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
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
327199 327199 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2017   pk_12_total 260.0 1.0 38.0               3.0   152.0 150.0             126     46   302 260 1 38               3   152 150         126   46   302
327200 327200 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   44                                             44
327201 327201 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   42                                             42
327202 327202 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   45                                             45
327203 327203 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   44                                             44
327204 327204 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   49                                             49
327205 327205 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   39                                             39
327206 327206 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   37                                             37
327207 327207 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
327208 327208 WI Monroe   school 5502340 980 Public school Cashton 550234000263 40 Cashton Middle/High   Regular School No Other 06 12 2017   pk_12_total 265.0 3.0 35.0 2.0           1.0 4.0   142.0 168.0             111     46   310 265 3 35 2           1 4   142 168         111   46   310
327209 327209 WI Monroe   school 5502340 980 Public school Cashton 550234000263 40 Cashton Middle/High   Regular School No Other 06 12 2017   grade_10                                                   30                                             30
327210 327210 WI Monroe   school 5502340 980 Public school Cashton 550234000263 40 Cashton Middle/High   Regular School No Other 06 12 2017   grade_11                                                   41                                             41
327211 327211 WI Monroe   school 5502340 980 Public school Cashton 550234000263 40 Cashton Middle/High   Regular School No Other 06 12 2017   grade_12                                                   38                                             38
327212 327212 WI Monroe   school 5502340 980 Public school Cashton 550234000263 40 Cashton Middle/High   Regular School No Other 06 12 2017   grade_6                                                   44                                             44
327213 327213 WI Monroe   school 5502340 980 Public school Cashton 550234000263 40 Cashton Middle/High   Regular School No Other 06 12 2017   grade_7                                                   41                                             41
327214 327214 WI Monroe   school 5502340 980 Public school Cashton 550234000263 40 Cashton Middle/High   Regular School No Other 06 12 2017   grade_8                                                   63                                             63
327215 327215 WI Monroe   school 5502340 980 Public school Cashton 550234000263 40 Cashton Middle/High   Regular School No Other 06 12 2017   grade_9                                                   53                                             53
327161 327161 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2017   pk_12_total 343.0 3.0 12.0     4.0         5.0   205.0 162.0             91     69   367 343 3 12     4         5   205 162         91   69   367
327162 327162 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   41                                             41
327163 327163 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   56                                             56
327164 327164 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   67                                             67
327165 327165 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   68                                             68
327166 327166 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   60                                             60
327167 327167 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   38                                             38
327168 327168 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   35                                             35
327169 327169 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
327170 327170 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000259 40 Campbellsport High   Regular School No High 09 12 2017   pk_12_total 398.0 2.0 18.0     1.0       1.0 6.0   212.0 214.0             78     59   426 398 2 18     1       1 6   212 214         78   59   426
327171 327171 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000259 40 Campbellsport High   Regular School No High 09 12 2017   grade_10                                                   114                                             114
327172 327172 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000259 40 Campbellsport High   Regular School No High 09 12 2017   grade_11                                                   99                                             99
327173 327173 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000259 40 Campbellsport High   Regular School No High 09 12 2017   grade_12                                                   99                                             99
327174 327174 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000259 40 Campbellsport High   Regular School No High 09 12 2017   grade_9                                                   114                                             114
327175 327175 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216002484 300 Campbellsport Middle   Regular School No Middle 06 08 2017   pk_12_total 263.0 4.0 18.0     2.0         7.0   151.0 143.0             62     45   294 263 4 18     2         7   151 143         62   45   294
327176 327176 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216002484 300 Campbellsport Middle   Regular School No Middle 06 08 2017   grade_6                                                   93                                             93
327177 327177 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216002484 300 Campbellsport Middle   Regular School No Middle 06 08 2017   grade_7                                                   119                                             119
327178 327178 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216002484 300 Campbellsport Middle   Regular School No Middle 06 08 2017   grade_8                                                   82                                             82
327179 327179 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2017   pk_12_total 202.0 1.0 24.0 1.0   1.0         10.0   131.0 108.0             78     54   239 202 1 24 1   1         10   131 108         78   54   239
327180 327180 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   36                                             36
327181 327181 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2017   grade_2                                                   44                                             44
327182 327182 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2017   grade_3                                                   40                                             40
327183 327183 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2017   grade_4                                                   33                                             33
327184 327184 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2017   grade_5                                                   29                                             29
327185 327185 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2017   kindergarten_4_year_old                                                   22                                             22
327186 327186 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2017   kindergarten                                                   27                                             27
327187 327187 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   8                                             8
325716 325716 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   pk_12_total 280.0 4.0 58.0 5.0           2.0 4.0   172.0 181.0             218     60   353 280 4 58 5           2 4   172 181         218   60   353
325717 325717 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   grade_1                                                   47                                             47
325718 325718 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   grade_2                                                   41                                             41
325719 325719 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   grade_3                                                   35                                             35
325720 325720 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   grade_4                                                   48                                             48
325721 325721 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   grade_5                                                   53                                             53
325722 325722 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   grade_6                                                   45                                             45
325723 325723 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   kindergarten_4_year_old                                                   39                                             39
325724 325724 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   kindergarten                                                   43                                             43
325725 325725 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   2                                             2
325726 325726 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2017   pk_12_total 143.0 2.0 22.0 4.0                 98.0 73.0             80     24   171 143 2 22 4                 98 73         80   24   171
325727 325727 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2017   grade_10                                                   43                                             43
325728 325728 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2017   grade_11                                                   47                                             47
325729 325729 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2017   grade_12                                                   40                                             40
325730 325730 WI Jackson   school 5500210 91 Public school Alma Center 550021000020 60 Lincoln High   Regular School No High 09 12 2017   grade_9                                                   41                                             41
325731 325731 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2017   pk_12_total 64.0   15.0     2.0         1.0   42.0 40.0             48     7   82 64   15     2         1   42 40         48   7   82
325732 325732 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2017   grade_7                                                   38                                             38
325733 325733 WI Jackson   school 5500210 91 Public school Alma Center 550021000021 70 Lincoln Junior High   Regular School No Middle 07 08 2017   grade_8                                                   44                                             44
327127 327127 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   pk_12_total 61.0 1.0                     27.0 35.0             5     2   62 61 1                     27 35         5   2   62
327128 327128 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_1                                                   6                                             6
327129 327129 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_10                                                   4                                             4
327130 327130 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_11                                                   4                                             4
327131 327131 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_12                                                   9                                             9
327132 327132 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_2                                                   5                                             5
327133 327133 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_3                                                   7                                             7
327134 327134 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_4                                                   6                                             6
327135 327135 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_5                                                   3                                             3
327136 327136 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_6                                                   1                                             1
327137 327137 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_7                                                   5                                             5
327138 327138 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_8                                                   5                                             5
327139 327139 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   grade_9                                                   4                                             4
327140 327140 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other KG 12 2017   kindergarten                                                   3                                             3
327141 327141 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2017   pk_12_total 470.0 8.0 4.0 4.0   3.0         2.0   244.0 247.0             183     52   491 470 8 4 4   3         2   244 247         183   52   491
327142 327142 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2017   grade_1                                                   70                                             70
327143 327143 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2017   grade_2                                                   82                                             82
327144 327144 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2017   grade_3                                                   82                                             82
327145 327145 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2017   grade_4                                                   91                                             91
327146 327146 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2017   kindergarten_4_year_old                                                   73                                             73
327147 327147 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2017   kindergarten                                                   93                                             93

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