Data source: Big Local News · About: Big Local

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

View and edit SQL

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 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 WI Green   school 5500120 63 Public school Albany 550012000013 20 Albany Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 WI Lafayette   school 5500450 161 Public school Argyle 550045000069 20 Argyle Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 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 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 WI Dane   school 5500990 350 Public school Belleville 550099000131 20 Belleville Elementary   Regular School No Elementary PK 01 2017   pre_kindergarten                                                   1                                             1
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 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 WI Polk   school 5502580 1120 Public school Clayton 550258000289 20 Clayton Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 WI Milwaukee   school 5503060 1253 Public school Cudahy 550306000340 80 Lincoln Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 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 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 WI Langlade   school 5504170 1582 Public school Elcho 550417000447 20 Elcho Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 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 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 WI Buffalo   school 5505370 2142 Public school Gilmanton 550537000573 40 Gilmanton Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   1                                             1
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 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 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 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 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 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 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 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000650 60 Edgewood Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 WI Green   school 5507230 2737 Public school Juda 550723000784 20 Juda Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
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 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000810 240 Harvey Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 WI Kenosha   school 5507320 2793 Public school Kenosha 550732000825 520 Southport Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 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 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 WI Polk   school 5508280 3213 Public school Luck 550828000914 40 Luck Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   1                                             1
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 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 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 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 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 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 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 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 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 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 WI Price   school 5512210 4571 Public school Prentice 551221001587 20 Ogema Elementary   Regular School No Elementary PK 04 2017   pre_kindergarten                                                   1                                             1
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 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 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 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 WI Waukesha   school 5508130 3122 Public school Richmond 550813002262 20 Richmond Elementary   Regular School No Elementary PK 08 2017   pre_kindergarten                                                   1                                             1
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 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 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 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 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 WI Washington   school 5513950 5390 Public school Slinger 551395001818 10 Allenton Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 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 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 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 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 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 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002004 20 Banting Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 WI Waukesha   school 5515780 6174 Public school Waukesha 551578002014 200 Hillcrest Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 WI Milwaukee   school 5515990 6244 Public school Wauwatosa 551599002082 120 Lincoln Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   1                                             1
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 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 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 WI Marquette   school 5516440 6335 Public school Westfield 551644002147 20 Coloma Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   1                                             1
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 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 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 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
325654 WI Adams   school 5500060 14 Public school Adams-Friendship Area 550006000010 140 Grand Marsh Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
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
326564 WI Lafayette   school 5501020 364 Public school Belmont Community 550102000134 20 Belmont Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
326911 WI Dunn   school 5501590 637 Public school Boyceville Community 550159000201 20 Tiffany Creek Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   2                                             2
326994 WI Rusk   school 5501830 735 Public school Bruce 550183000234 20 Bruce Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
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
327207 WI Monroe   school 5502340 980 Public school Cashton 550234000262 20 Cashton Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
327225 WI Grant   school 5502400 994 Public school Cassville 550240000264 20 Cassville Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   2                                             2
327591 WI Columbia   school 5502820 1183 Public school Columbus 550282000321 80 Columbus Elementary   Regular School No Elementary PK 03 2017   pre_kindergarten                                                   2                                             2
327803 WI Marathon   school 5513170 4970 Public school D C Everest Area 551317001738 60 Hatley Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
328289 WI Marathon   school 5504080 1561 Public school Edgar 550408000440 20 Edgar Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
328445 WI Walworth   school 5504290 1638 Public school Elkhorn Area 550429000462 100 West Side Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
328574 WI Rock   school 5504440 1694 Public school Evansville Community 550444000477 20 Levi Leonard Elementary   Regular School No Elementary PK 02 2017   pre_kindergarten                                                   2                                             2
328872 WI Milwaukee   school 5504830 1900 Public school Franklin Public 550483000523 80 Pleasant View Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   2                                             2
329043 WI Door   school 5505220 2114 Public school Gibraltar Area 550522002245 100 Gibraltar Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   2                                             2
329295 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000617 175 Doty Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
329328 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000620 200 Eisenhower Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
329506 WI Brown   school 5505820 2289 Public school Green Bay Area Public 550582000639 590 Sullivan Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2
329558 WI Green Lake   school 5505880 2310 Public school Green Lake 550588000646 20 Green Lake Elementary   Regular School No Elementary PK 06 2017   pre_kindergarten                                                   2                                             2
329642 WI Milwaukee   school 5505940 2303 Public school Greenfield 550594000655 160 Maple Grove Elementary   Regular School No Elementary PK 05 2017   pre_kindergarten                                                   2                                             2

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