enrollments

Data source: Big Local News · About: Big Local

565 rows where grade = "pre_kindergarten", state = "WI" and year = 2017 sorted by total

✎ View and edit SQL

This data as json, CSV (advanced)

year ✖

  • 2017 · 565 ✖

grade ✖

  • pre_kindergarten · 565 ✖
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
325663 325663 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000012 200 Roche-A-Cri Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
325676 325676 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
325751 325751 WI Portage   school 5500240 105 Public school Almond-Bancroft 550024000025 60 Bancroft Elementary   Regular School No Elementary PK KG 2017   pre_kindergarten                                                   1                                             1
326144 326144 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
326184 326184 WI Ashland   school 5500510 170 Public school Ashland 550051000077 80 Lake Superior Primary   Regular School No Elementary PK 02 2017   pre_kindergarten                                                   1                                             1
326403 326403 WI Barron   school 5500870 308 Public school Barron Area 550087000113 20 Almena Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   1                                             1
326528 326528 WI Marinette   school 5511550 4263 Public school Beecher-Dunbar-Pembine 551155001529 40 Pembine Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   1                                             1
326540 326540 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No Elementary PK 01 2017   pre_kindergarten                                                   1                                             1
326695 326695 WI Lafayette   school 5501110 427 Public school Benton 550111000160 20 Benton Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   1                                             1
326771 326771 WI Lafayette   school 5505730 2240 Public school Black Hawk 550573000608 160 Black Hawk Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
327448 327448 WI Polk   school 5502580 1120 Public school Clayton 550258000289 20 Clayton Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
327704 327704 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306001228 140 Kosciuszko Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
327713 327713 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
327722 327722 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000338 50 Mitchell Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
327848 327848 WI Lafayette   school 5503150 1295 Public school Darlington Community 550315000704 160 Darlington Elementary/Middle   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
328104 328104 WI Bayfield   school 5503810 1491 Public school Drummond Area 550381000398 20 Drummond Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   1                                             1
328331 328331 WI Langlade   school 5504170 1582 Public school Elcho 550417000447 20 Elcho Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
328658 328658 WI Florence   school 5504650 1855 Public school Florence County 550465000489 40 Florence Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   1                                             1
328707 328707 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000499 200 Lakeshore Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
328780 328780 WI Walworth   school 5504720 1870 Public school Fontana J8 550472000508 20 Fontana Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
329093 329093 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000573 40 Gilmanton Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   1                                             1
329188 329188 WI Ozaukee   school 5505610 2217 Public school Grafton 550561002250 100 Woodview Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
329243 329243 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000610 20 Aldo Leopold Community School K-8   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
329337 329337 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000621 220 Elmore Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
329412 329412 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000166 390 King Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
329453 329453 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000632 430 MacArthur Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
329535 329535 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000643 700 Wequiock Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
329548 329548 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582002406 730 Wilder Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
329607 329607 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000650 60 Edgewood Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
330001 330001 WI Brown   school 5506630 2604 Public school Howard-Suamico 550663002814 130 Howard and Suamico 4K Collaborative   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   1                                             1
330422 330422 WI Green   school 5507230 2737 Public school Juda 550723000784 20 Juda Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
330557 330557 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000808 180 Grant Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
330583 330583 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000810 240 Harvey Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
330613 330613 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000814 310 Jeffery Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
330728 330728 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000825 520 Southport Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
331052 331052 WI La Crosse   school 5507530 2849 Public school La Crosse 550753000862 120 Hintgen Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
331150 331150 WI Vernon   school 5507560 2863 Public school La Farge 550756000872 20 La Farge Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
331203 331203 WI Waukesha   school 5500013 3862 Public school Lake Country 550001300578 30 Lake Country School   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
331459 331459 WI Polk   school 5508280 3213 Public school Luck 550828000914 40 Luck Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   1                                             1
331971 331971 WI Marinette   school 5508700 3311 Public school Marinette 550870000999 140 Park Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   1                                             1
334126 334126 WI Milwaukee   school 5500067 8128 Non District Charter Schools Milwaukee Math and Science Academy 550006702898 800 Milwaukee Math and Science Academy charter Regular School Yes Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
334247 334247 WI Dane   school 5509810 3675 Public school Monona Grove 550981002343 80 Winnequah School   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
334819 334819 WI Waupaca   school 5510590 3955 Public school New London 551059001387 120 Sugar Bush Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   1                                             1
334891 334891 WI Racine   school 5512510 4690 Public school North Cape 551251001657 20 North Cape Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
334951 334951 WI Vilas   school 5501530 616 Public school North Lakeland 550153000198 50 North Lakeland Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
335154 335154 WI Milwaukee   school 5510830 4018 Public school Oak Creek-Franklin Joint 551083001413 200 Shepard Hills Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
335212 335212 WI Waukesha   school 5510890 4060 Public school Oconomowoc Area 551089001424 160 Park Lawn Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   1                                             1
335571 335571 WI Trempealeau   school 5511220 4186 Public school Osseo-Fairchild 551122001507 60 Osseo Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
335915 335915 WI Ozaukee   school 5512000 4515 Public school Port Washington-Saukville 551200001569 120 Saukville Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   1                                             1
336058 336058 WI Price   school 5512210 4571 Public school Prentice 551221001587 20 Ogema Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   1                                             1
336116 336116 WI Green Lake   school 5512300 4606 Public school Princeton 551230001595 40 Princeton School   Regular School No Other PK 12 2017   pre_kindergarten                                                   1                                             1
336265 336265 WI Racine   school 5512360 4620 Public school Racine Unified 551236001626 136 Johnson Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
336274 336274 WI Racine   school 5512360 4620 Public school Racine Unified 551236001627 111 Jones Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
336652 336652 WI Washington   school 5512900 4820 Public school Richfield J1 551290000467 40 Plat Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten                                                   1                                             1
336704 336704 WI Waukesha   school 5508130 3122 Public school Richmond 550813002262 20 Richmond Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
336834 336834 WI Sauk   school 5514250 5523 Public school River Valley 551425001854 80 River Valley Elementary Lone Rock   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
336850 336850 WI Sauk   school 5514250 5523 Public school River Valley 551425002346 120 River Valley Elementary Spring Green   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
336920 336920 WI Fond du Lac   school 5513100 4956 Public school Rosendale-Brandon 551310001730 60 Rosendale Primary   Regular School No Elementary PK 03 2017   pre_kindergarten                                                   1                                             1
337213 337213 WI Sheboygan   school 5513650 5271 Public school Sheboygan Area 551365001781 20 Cleveland Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
337477 337477 WI Kenosha   school 5513860 5369 Public school Silver Lake J1 551386001815 20 Riverview Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
337512 337512 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
337521 337521 WI Washington   school 5513950 5390 Public school Slinger 551395001819 20 Slinger Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
338125 338125 WI Douglas   school 5514670 5663 Public school Superior 551467002347 110 Four Corners Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
338142 338142 WI Douglas   school 5514670 5663 Public school Superior 551467002348 120 Lake Superior Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
338175 338175 WI Oconto   school 5514700 5670 Public school Suring Public 551470001921 60 Suring Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
338416 338416 WI Barron   school 5515060 5810 Public school Turtle Lake 551506001955 20 Turtle Lake Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
338433 338433 WI Kenosha   school 5515090 5817 Public school Twin Lakes #4 551509001957 20 Lakewood Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
338819 338819 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002004 20 Banting Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
338828 338828 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002006 60 Bethesda Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
338891 338891 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002014 200 Hillcrest Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
338998 338998 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002028 540 Whittier Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
339301 339301 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002082 120 Lincoln Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
339357 339357 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002089 240 Washington Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
339463 339463 WI Milwaukee   school 5516260 6300 Public school West Allis-West Milwaukee 551626002105 100 Hoover Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
339695 339695 WI Vernon   school 5516410 6321 Public school Westby Area 551641002145 180 Westby Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   1                                             1
339715 339715 WI Marquette   school 5516440 6335 Public school Westfield 551644002147 20 Coloma Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   1                                             1
339851 339851 WI Trempealeau   school 5516650 6426 Public school Whitehall 551665002175 80 Whitehall Memorial Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   1                                             1
339968 339968 WI Walworth   school 5516740 6482 Public school Williams Bay 551674002186 20 Williams Bay Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
339991 339991 WI Winnebago   school 5516830 6608 Public school Winneconne Community 551683002190 40 Winneconne Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
340191 340191 WI Juneau   school 5517130 6713 Public school Wonewoc-Union Center 551713002224 60 Wonewoc-Center Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
326050 326050 WI Outagamie   school 5500390 147 Public school Appleton Area 550039000061 320 McKinley Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   10                                             10
326300 326300 WI Saint Croix   school 5500720 231 Public school Baldwin-Woodville Area 550072000095 70 Greenfield Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
326344 326344 WI Sauk   school 5500810 280 Public school Baraboo 550081000104 60 East Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
327819 327819 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317002288 70 Riverside Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
328723 328723 WI Fond du Lac   school 5504680 1862 Public school Fond du Lac 550468000501 240 Pier Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
329009 329009 WI Washington   school 5505160 2058 Public school Germantown 550516000550 40 County Line Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
329116 329116 WI Milwaukee   school 5505460 2184 Public school Glendale-River Hills 550546000577 60 Parkway Elementary   Regular School No Elementary PK 03 2017   pre_kindergarten                                                   10                                             10
329372 329372 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000625 340 Jackson Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
329760 329760 WI Waukesha   school 5506140 2460 Public school Hartland-Lakeside J3 550614002257 20 North Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten                                                   10                                             10
329894 329894 WI La Crosse   school 5506540 2562 Public school Holmen 550654000709 80 Holmen Public Preschool   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   10                                             10
330273 330273 WI Rock   school 5507020 2695 Public school Janesville 550702000766 200 Lincoln Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
330836 330836 WI Waukesha   school 5503510 1376 Public school Kettle Moraine 550351000378 160 Magee Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
335746 335746 WI Waukesha   school 5511640 4312 Public school Pewaukee 551164001536 60 Pewaukee Lake Elementary   Regular School No Elementary PK 03 2017   pre_kindergarten                                                   10                                             10
336501 336501 WI Sauk   school 5512660 4753 Public school Reedsburg 551266001604 180 Pineview Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
336676 336676 WI Richland   school 5512960 4851 Public school Richland 551296001706 260 Lincoln Elementary   Regular School No Elementary PK KG 2017   pre_kindergarten                                                   10                                             10
337035 337035 WI Kenosha   school 5513350 5068 Public school Salem 551335001753 20 Salem Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   10                                             10
337371 337371 WI Sheboygan   school 5513680 5278 Public school Sheboygan Falls 551368001801 20 Sheboygan Falls Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   10                                             10
337734 337734 WI Marathon   school 5514190 5467 Public school Spencer 551419001844 20 Spencer Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   10                                             10
337745 337745 WI Washburn   school 5514220 5474 Public school Spooner Area 551422002956 120 Little Rails Early Learning   Regular School No Elementary PK PK 2017   pre_kindergarten                                                   10                                             10
338013 338013 WI Door   school 5514610 5642 Public school Sturgeon Bay 551461001896 70 Sunset Elementary   Regular School No Elementary PK KG 2017   pre_kindergarten                                                   10                                             10

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