enrollments

Data source: Big Local News · About: Big Local

7,819 rows where grade = "grade_1" and state = "WI" sorted by district_state_id descending

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 7,819 ✖
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
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
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
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
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
2334528 2334528 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   10                                             10
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
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
113323 113323 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   37                                             37
283305 283305 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   40                                             40
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
2319729 2319729 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   35                                             35
2334511 2334511 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   35                                             35
3075507 3075507 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   43                                             43
3090257 3090257 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   38                                             38
113285 113285 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   71                                             71
113303 113303 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   35                                             35
283267 283267 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   57                                             57
283285 283285 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   45                                             45
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
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
2319691 2319691 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   55                                             55
2319709 2319709 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   33                                             33
2334484 2334484 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   41                                             41
2334502 2334502 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   30                                             30
3075469 3075469 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   49                                             49
3075487 3075487 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   26                                             26
3090219 3090219 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000258 20 Campbellsport Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   40                                             40
3090237 3090237 WI Fond du Lac   school 5502160 910 Public school Campbellsport 550216000260 80 Eden Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   29                                             29
111844 111844 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   37                                             37
281816 281816 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No 1.0 PK 06 2016   grade_1                                                   42                                             42
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
2318228 2318228 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   40                                             40
2333025 2333025 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   41                                             41
3073997 3073997 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2019   grade_1                                                   42                                             42
3088756 3088756 WI Jackson   school 5500210 91 Public school Alma Center 550021000022 80 Lincoln Elementary   Regular School No Elementary PK 06 2018   grade_1                                                   45                                             45
113250 113250 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative Education School Yes 4.0 KG 12 2015   grade_1                                                   10                                             10
113264 113264 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No 1.0 PK 04 2015   grade_1                                                   82                                             82
283232 283232 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative Education School Yes 4.0 KG 12 2016   grade_1                                                   6                                             6
283246 283246 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No 1.0 PK 04 2016   grade_1                                                   81                                             81
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
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
2319655 2319655 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2020   grade_1                                                   2                                             2
2319670 2319670 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2020   grade_1                                                   56                                             56
2334448 2334448 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2021   grade_1                                                   9                                             9
2334463 2334463 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2021   grade_1                                                   61                                             61
3075433 3075433 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2019   grade_1                                                   6                                             6
3075448 3075448 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2019   grade_1                                                   78                                             78
3090184 3090184 WI Barron   school 5502130 903 Public school Cameron 550213002851 800 Cameron Academy of Virtual Education charter Alternative School Yes Other PK 12 2018   grade_1                                                   5                                             5
3090198 3090198 WI Barron   school 5502130 903 Public school Cameron 550213000256 20 Cameron Elementary   Regular School No Elementary PK 04 2018   grade_1                                                   90                                             90
113232 113232 WI Dane   school 5502100 896 Public school Cambridge 550210000254 20 Cambridge Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   66                                             66
283214 283214 WI Dane   school 5502100 896 Public school Cambridge 550210000254 20 Cambridge Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   59                                             59
327110 327110 WI Dane   school 5502100 896 Public school Cambridge 550210000254 20 Cambridge Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   58                                             58
2319631 2319631 WI Dane   school 5502100 896 Public school Cambridge 550210000254 20 Cambridge Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   59                                             59
2334423 2334423 WI Dane   school 5502100 896 Public school Cambridge 550210000254 20 Cambridge Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   55                                             55
3075411 3075411 WI Dane   school 5502100 896 Public school Cambridge 550210000254 20 Cambridge Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   71                                             71
3090166 3090166 WI Dane   school 5502100 896 Public school Cambridge 550210000254 20 Cambridge Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   55                                             55
113215 113215 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000253 60 Cambria Friesland Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   29                                             29
283197 283197 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000253 60 Cambria Friesland Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   31                                             31
327093 327093 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000253 60 Cambria Friesland Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   27                                             27
2319615 2319615 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000253 60 Cambria Friesland Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   23                                             23
2334406 2334406 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000253 60 Cambria Friesland Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   27                                             27
3075394 3075394 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000253 60 Cambria Friesland Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   17                                             17
3090149 3090149 WI Columbia   school 5502070 882 Public school Cambria-Friesland 550207000253 60 Cambria Friesland Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   19                                             19
113197 113197 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No 1.0 PK 06 2015   grade_1                                                   58                                             58
283179 283179 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No 1.0 PK 06 2016   grade_1                                                   52                                             52
327075 327075 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No Elementary PK 06 2017   grade_1                                                   44                                             44
2319595 2319595 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No Elementary PK 06 2020   grade_1                                                   49                                             49
2334374 2334374 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No Elementary PK 06 2021   grade_1                                                   47                                             47
2334392 2334392 WI Chippewa   school   870 Public Schools-Multidistrict Charters Cadott Community   9419 eSucceed Charter School charter           2021   grade_1                                                   4                                             4
3075376 3075376 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No Elementary PK 06 2019   grade_1                                                   66                                             66
3090131 3090131 WI Chippewa   school 5502040 870 Public school Cadott Community 550204000247 20 Cadott Elementary   Regular School No Elementary PK 06 2018   grade_1                                                   59                                             59
113178 113178 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2015   grade_1                                                   13                                             13
283160 283160 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No 1.0 PK 05 2016   grade_1                                                   10                                             10
327058 327058 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2017   grade_1                                                   13                                             13
2319575 2319575 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2020   grade_1                                                   9                                             9
2334356 2334356 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2021   grade_1                                                   12                                             12
3075356 3075356 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2019   grade_1                                                   15                                             15
3090111 3090111 WI Ashland   school 5501920 840 Public school Butternut 550192000245 20 Butternut Elementary   Regular School No Elementary PK 05 2018   grade_1                                                   10                                             10
111828 111828 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2015   grade_1                                                   15                                             15
281800 281800 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No 1.0 PK 08 2016   grade_1                                                   24                                             24
325701 325701 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2017   grade_1                                                   17                                             17
2318211 2318211 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2020   grade_1                                                   16                                             16
2333009 2333009 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2021   grade_1                                                   19                                             19
3073981 3073981 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2019   grade_1                                                   18                                             18
3088739 3088739 WI Buffalo   school 5500180 84 Public school Alma 550018000017 20 Alma Elementary   Regular School No Elementary PK 08 2018   grade_1                                                   15                                             15
2327984 2327984 WI Dane   school 5500083 8142 Non District Charter Schools One City Expeditionary Elementary School 550008303087 8142 One City Expeditionary Elementary School charter Regular School Yes Elementary PK 01 2020   grade_1                                                   22                                             22
2342870 2342870 WI Dane   school 5500083 8142 Non District Charter Schools One City Expeditionary Elementary School 550008303087 8142 One City Expeditionary Elementary School charter Regular School Yes Elementary PK 02 2021   grade_1                                                   32                                             32
2322743 2322743 WI Dane   school 5500082 8141 Non District Charter Schools Isthmus Montessori Academy Public 550008203085 8141 Isthmus Montessori Academy Public charter Regular School Yes Other PK 12 2020   grade_1                                                   19                                             19
2337601 2337601 WI Dane   school 5500082 8141 Non District Charter Schools Isthmus Montessori Academy Public 550008203085 8141 Isthmus Montessori Academy Public charter Regular School Yes Other PK 11 2021   grade_1                                                   24                                             24
3078493 3078493 WI Dane   school 5500082 8141 Non District Charter Schools Isthmus Montessori Academy Public 550008203085 8141 Isthmus Montessori Academy Public charter Regular School Yes Other PK 12 2019   grade_1                                                   28                                             28
2328323 2328323 WI Milwaukee   school 5500078 8138 Non District Charter Schools Penfield Montessori Academy 550007803048 8138 Penfield Montessori Academy charter Regular School Yes Elementary PK 08 2020   grade_1                                                   18                                             18
2343213 2343213 WI Milwaukee   school 5500078 8138 Non District Charter Schools Penfield Montessori Academy 550007803048 8138 Penfield Montessori Academy charter Regular School Yes Elementary PK 04 2021   grade_1                                                   22                                             22
3084075 3084075 WI Milwaukee   school 5500078 8138 Non District Charter Schools Penfield Montessori Academy 550007803048 8138 Penfield Montessori Academy charter Regular School Yes Elementary PK 08 2019   grade_1                                                   17                                             17
3098772 3098772 WI Milwaukee   school 5500078 8138 Non District Charter Schools Penfield Montessori Academy 550007803048 8138 Penfield Montessori Academy charter Regular School Yes Elementary PK 08 2018   grade_1                                                   18                                             18
337800 337800 WI Milwaukee   school 5500076 8136 Non District Charter Schools Stellar Collegiate Charter School 550007603046 8136 Stellar Collegiate Charter School charter Regular School Yes Elementary PK 05 2017   grade_1                                                   28                                             28
2330413 2330413 WI Milwaukee   school 5500076 8136 Non District Charter Schools Stellar Collegiate Charter School 550007603046 8136 Stellar Collegiate Charter School charter Regular School Yes Elementary PK 05 2020   grade_1                                                   36                                             36
2345308 2345308 WI Milwaukee   school 5500076 8136 Non District Charter Schools Stellar Collegiate Charter School 550007603046 8136 Stellar Collegiate Charter School charter Regular School Yes Elementary PK 05 2021   grade_1                                                   31                                             31
3086124 3086124 WI Milwaukee   school 5500076 8136 Non District Charter Schools Stellar Collegiate Charter School 550007603046 8136 Stellar Collegiate Charter School charter Regular School Yes Elementary PK 05 2019   grade_1                                                   41                                             41
3100856 3100856 WI Milwaukee   school 5500076 8136 Non District Charter Schools Stellar Collegiate Charter School 550007603046 8136 Stellar Collegiate Charter School charter Regular School Yes Elementary PK 05 2018   grade_1                                                   26                                             26
331002 331002 WI Waukesha   school 5500073 8135 Non District Charter Schools La Casa de Esperanza Charter School 550007303031 100 La Casa de Esperanza Charter School charter Regular School Yes Elementary PK 08 2017   grade_1                                                   33                                             33

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