enrollments

Data source: Big Local News · About: Big Local

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

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

grade ✖

  • grade_1 · 7,719 ✖
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
2345845 2345845 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001937 140 Oakdale Elementary   Regular School No Elementary PK 01 2021   grade_1                                                   15                                             15
2346706 2346706 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002044 160 Meadow View Primary   Regular School No Elementary PK 01 2021   grade_1                                                   97                                             97
3075076 3075076 WI Jackson   school 5501260 476 Public school Black River Falls 550126000176 80 Forrest Street Early Learning Center   Regular School No Elementary PK 01 2019   grade_1                                                   112                                             112
3078751 3078751 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002433 50 Dr H B Tanner Elementary   Regular School No Elementary PK 01 2019   grade_1                                                   123                                             123
3082603 3082603 WI Dane   school 5509810 3675 Public school Monona Grove 550981000682 120 Taylor Prairie Elementary   Regular School No Elementary PK 01 2019   grade_1                                                   146                                             146
3083681 3083681 WI Winnebago   school 5510980 4088 Public school Omro 551098001440 40 Patch Elementary   Regular School No Elementary PK 01 2019   grade_1                                                   63                                             63
3084352 3084352 WI Columbia   school 5512060 4501 Public school Portage Community 551206002711 110 Woodridge Elementary   Regular School No Elementary KG 01 2019   grade_1                                                   75                                             75
3084392 3084392 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2019   grade_1                                                   74                                             74
3086628 3086628 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001937 140 Oakdale Elementary   Regular School No Elementary PK 01 2019   grade_1                                                   17                                             17
3087446 3087446 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002044 160 Meadow View Primary   Regular School No Elementary PK 01 2019   grade_1                                                   114                                             114
3089567 3089567 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No Elementary PK 01 2018   grade_1                                                   55                                             55
3089836 3089836 WI Jackson   school 5501260 476 Public school Black River Falls 550126000176 80 Forrest Street Early Learning Center   Regular School No Elementary PK 01 2018   grade_1                                                   113                                             113
3093494 3093494 WI Outagamie   school 5507290 2758 Public school Kaukauna Area 550729002433 50 Dr H B Tanner Elementary   Regular School No Elementary PK 01 2018   grade_1                                                   127                                             127
3097306 3097306 WI Dane   school 5509810 3675 Public school Monona Grove 550981000682 120 Taylor Prairie Elementary   Regular School No Elementary PK 01 2018   grade_1                                                   150                                             150
3098383 3098383 WI Winnebago   school 5510980 4088 Public school Omro 551098001440 40 Patch Elementary   Regular School No Elementary PK 01 2018   grade_1                                                   89                                             89
3099047 3099047 WI Columbia   school 5512060 4501 Public school Portage Community 551206002711 110 Woodridge Elementary   Regular School No Elementary KG 01 2018   grade_1                                                   80                                             80
3099086 3099086 WI Crawford   school 5512150 4543 Public school Prairie du Chien Area 551215002508 10 BA Kennedy School   Regular School No Elementary PK 01 2018   grade_1                                                   75                                             75
3102139 3102139 WI Fond du Lac   school 5515870 6216 Public school Waupun 551587002044 160 Meadow View Primary   Regular School No Elementary PK 01 2018   grade_1                                                   136                                             136
111911 111911 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   83                                             83
112303 112303 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2015   grade_1                                                   140                                             140
112788 112788 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   86                                             86
113435 113435 WI Price   school 5500058 1071 Public school Chequamegon 550005800590 100 Glidden Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   12                                             12
114684 114684 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   95                                             95
115862 115862 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002913 130 Hartland Fine Arts Leadership Academy charter Regular School Yes 1.0 KG 02 2015   grade_1                                                   23                                             23
115874 115874 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   91                                             91
115918 115918 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627000689 20 Hayward Primary   Regular School No 1.0 PK 02 2015   grade_1                                                   138                                             138
117050 117050 WI Manitowoc   school 5507440 2828 Public school Kiel Area 550744002593 110 Meeme LEADS Charter charter Regular School Yes 1.0 PK 02 2015   grade_1                                                   10                                             10
117614 117614 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834002525 110 Luxemburg-Casco Primary   Regular School No 1.0 PK 02 2015   grade_1                                                   121                                             121
117688 117688 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000930 240 Franklin Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   111                                             111
117765 117765 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002412 53 Lapham Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   74                                             74
117824 117824 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000951 570 Midvale Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   157                                             157
118058 118058 WI Milwaukee   school 5504770 1897 Public school Maple Dale-Indian Hill 550477000515 20 Indian Hill Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   31                                             31
118158 118158 WI Dane   school 5508790 3332 Public school Marshall 550879000569 80 Marshall Early Learning Center   Regular School No 1.0 PK 02 2015   grade_1                                                   78                                             78
118262 118262 WI Juneau   school 5508850 3360 Public school Mauston 550885001027 80 West Side Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   79                                             79
118280 118280 WI Dodge   school 5508880 3367 Public school Mayville 550888001031 90 Parkview Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   70                                             70
118300 118300 WI Dane   school 5508910 3381 Public school McFarland 550891001034 20 McFarland Primary School   Regular School No 1.0 01 02 2015   grade_1                                                   170                                             170
118422 118422 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903001056 80 Jefferson Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   43                                             43
120546 120546 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999001313 130 Mount Horeb Primary Center   Regular School No 1.0 01 02 2015   grade_1                                                   193                                             193
121446 121446 WI Oconto   school 5510920 4067 Public school Oconto Unified 551092002710 170 Oconto Literacy Charter School charter Regular School Yes 1.0 PK 02 2015   grade_1                                                   17                                             17
121562 121562 WI Polk   school 5511160 4165 Public school Osceola 551116001479 40 Osceola Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   134                                             134
121838 121838 WI Rock   school 5511130 4151 Public school Parkview 551113001473 20 Parkview Primary   Regular School No 1.0 PK 02 2015   grade_1                                                   68                                             68
122798 122798 WI Washington   school 5512900 4820 Public school Richfield J1 551290000467 40 Plat Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   38                                             38
122870 122870 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302001893 110 Barlow Park Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   55                                             55
122880 122880 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302002978 130 Journey charter Regular School Yes 1.0 KG 02 2015   grade_1                                                   39                                             39
123201 123201 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001755 20 Black Hawk Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   33                                             33
123228 123228 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001761 150 Spruce Street Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   146                                             146
123238 123238 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes 1.0 PK 02 2015   grade_1                                                   8                                             8
123335 123335 WI Shawano   school 5513620 5264 Public school Shawano 551362002819 150 Hillcrest Primary School   Regular School No 1.0 PK 02 2015   grade_1                                                   143                                             143
123341 123341 WI Shawano   school 5513620 5264 Public school Shawano 551362002908 110 LEADS Primary Charter School charter Regular School Yes 1.0 PK 02 2015   grade_1                                                   15                                             15
123550 123550 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No 1.0 PK 02 2015   grade_1                                                   48                                             48
124159 124159 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001392 120 Sawyer Elementary   Regular School No 1.0 01 02 2015   grade_1                                                   81                                             81
124446 124446 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001937 140 Oakdale Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   21                                             21
124944 124944 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575001999 80 Lincoln Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   58                                             58
125168 125168 WI Waupaca   school 5515840 6195 Public school Waupaca 551584002033 60 Chain O Lakes Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   35                                             35
126176 126176 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000170 20 Black Earth Elementary   Regular School No 1.0 PK 02 2015   grade_1                                                   57                                             57
281883 281883 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   97                                             97
282282 282282 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No 1.0 PK 02 2016   grade_1                                                   127                                             127
282767 282767 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   105                                             105
284681 284681 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   131                                             131
285865 285865 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002913 130 Hartland Fine Arts Leadership Academy charter Regular School Yes 1.0 KG 02 2016   grade_1                                                   23                                             23
285877 285877 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   80                                             80
285921 285921 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627000689 20 Hayward Primary   Regular School No 1.0 PK 02 2016   grade_1                                                   124                                             124
287610 287610 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834002525 110 Luxemburg-Casco Primary   Regular School No 1.0 PK 02 2016   grade_1                                                   135                                             135
287685 287685 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000930 240 Franklin Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   117                                             117
287761 287761 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002412 53 Lapham Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   64                                             64
287820 287820 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000951 570 Midvale Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   147                                             147
288050 288050 WI Milwaukee   school 5504770 1897 Public school Maple Dale-Indian Hill 550477000515 20 Indian Hill Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   34                                             34
288148 288148 WI Dane   school 5508790 3332 Public school Marshall 550879000569 80 Marshall Early Learning Center   Regular School No 1.0 PK 02 2016   grade_1                                                   69                                             69
288257 288257 WI Juneau   school 5508850 3360 Public school Mauston 550885001027 80 West Side Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   77                                             77
288275 288275 WI Dodge   school 5508880 3367 Public school Mayville 550888001031 90 Parkview Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   76                                             76
288295 288295 WI Dane   school 5508910 3381 Public school McFarland 550891001034 20 McFarland Primary School   Regular School No 1.0 01 02 2016   grade_1                                                   154                                             154
288390 288390 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903000659 160 Banta School   Regular School No 1.0 KG 02 2016   grade_1                                                   45                                             45
288419 288419 WI Winnebago   school 5509030 3430 Public school Menasha Joint 550903001056 80 Jefferson Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   61                                             61
289435 289435 WI Milwaukee   school 5509600 3619 Public school Milwaukee 550960002911 112 Howard Avenue Montessori School   Regular School No 1.0 PK 02 2016   grade_1                                                   54                                             54
290506 290506 WI Dane   school 5509990 3794 Public school Mount Horeb Area 550999001313 130 Mount Horeb Primary Center   Regular School No 1.0 01 02 2016   grade_1                                                   172                                             172
291525 291525 WI Polk   school 5511160 4165 Public school Osceola 551116001479 40 Osceola Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   111                                             111
292761 292761 WI Washington   school 5512900 4820 Public school Richfield J1 551290000467 40 Plat Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   53                                             53
292834 292834 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302001893 110 Barlow Park Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   61                                             61
292844 292844 WI Fond du Lac   school 5513020 4872 Public school Ripon Area 551302002978 130 Journey charter Regular School Yes 1.0 KG 02 2016   grade_1                                                   43                                             43
293157 293157 WI Sauk   school 5513410 5100 Public school Sauk Prairie 551341001761 150 Bridges Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   140                                             140
293191 293191 WI Milwaukee   school 5500043 8107 Non District Charter Schools School for Early Development and 550004302497 1279 School for Early Development and Achievement (SEDA) charter Regular School Yes 1.0 PK 02 2016   grade_1                                                   23                                             23
293290 293290 WI Shawano   school 5513620 5264 Public school Shawano 551362002819 150 Hillcrest Primary School   Regular School No 1.0 PK 02 2016   grade_1                                                   165                                             165
293296 293296 WI Shawano   school 5513620 5264 Public school Shawano 551362002908 110 LEADS Primary Charter School charter Regular School Yes 1.0 PK 02 2016   grade_1                                                   18                                             18
293504 293504 WI Washburn   school 5513710 5306 Public school Shell Lake 551371000507 10 Shell Lake Primary (K-2)   Regular School No 1.0 PK 02 2016   grade_1                                                   51                                             51
294093 294093 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001392 120 Sawyer Elementary   Regular School No 1.0 01 02 2016   grade_1                                                   72                                             72
294382 294382 WI Monroe   school 5514910 5747 Public school Tomah Area 551491001937 140 Oakdale Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   13                                             13
294880 294880 WI Jefferson   school 5515750 6125 Public school Watertown Unified 551575001999 80 Lincoln Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   62                                             62
295104 295104 WI Waupaca   school 5515840 6195 Public school Waupaca 551584002033 60 Chain O Lakes Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   31                                             31
296114 296114 WI Dane   school 5501230 469 Public school Wisconsin Heights 550123000170 20 Black Earth Elementary   Regular School No 1.0 PK 02 2016   grade_1                                                   57                                             57
325785 325785 WI Polk   school 5500300 119 Public school Amery 550030000029 20 Lien Elementary   Regular School No Elementary PK 02 2017   grade_1                                                   98                                             98
326181 326181 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2017   grade_1                                                   106                                             106
326669 326669 WI Rock   school 5501080 422 Public school Beloit Turner 550108000157 60 Powers Elementary   Regular School No Elementary PK 02 2017   grade_1                                                   106                                             106
328570 328570 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No Elementary PK 02 2017   grade_1                                                   104                                             104
329744 329744 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002913 130 Hartland Fine Arts Leadership Academy charter Regular School Yes Elementary KG 02 2017   grade_1                                                   17                                             17
329756 329756 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No Elementary PK 02 2017   grade_1                                                   79                                             79
329800 329800 WI Sawyer   school 5506270 2478 Public school Hayward Community 550627000689 20 Hayward Primary   Regular School No Elementary PK 02 2017   grade_1                                                   118                                             118
331481 331481 WI Kewaunee   school 5508340 3220 Public school Luxemburg-Casco 550834002525 110 Luxemburg-Casco Primary   Regular School No Elementary PK 02 2017   grade_1                                                   129                                             129
331556 331556 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000930 240 Franklin Elementary   Regular School No Elementary PK 02 2017   grade_1                                                   104                                             104
331631 331631 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852002412 53 Lapham Elementary   Regular School No Elementary PK 02 2017   grade_1                                                   62                                             62
331686 331686 WI Dane   school 5508520 3269 Public school Madison Metropolitan 550852000951 570 Midvale Elementary   Regular School No Elementary PK 02 2017   grade_1                                                   156                                             156

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