wisc_ratings17.sql

CREATE TABLE IF NOT EXISTS wisc_ratings17 (
    `dist_code` INT,
    `dist_name` VARCHAR(31),
    `score` NUMERIC(3, 1),
    `rating` VARCHAR(40),
    `enrollment` FLOAT,
    `eco_dis` NUMERIC(3, 1)
);
INSERT INTO wisc_ratings17 VALUES
    (7,'Abbotsford',76.3,'Exceeds Expectations',747,68.5),
    (14,'Adams-Friendship Area',60.2,'Meets Few Expectations',1534,62.3),
    (63,'Albany',65.1,'Meets Expectations',332,37.3),
    (70,'Algoma',72.8,'Meets Expectations',715,41.3),
    (84,'Alma',71,'Meets Expectations',242,31.4),
    (91,'Alma Center',71.2,'Meets Expectations',608,53.6),
    (105,'Almond-Bancroft',65.9,'Meets Expectations',397,47.1),
    (112,'Altoona',81.4,'Exceeds Expectations',1622,38.2),
    (119,'Amery',76.4,'Exceeds Expectations',1526,33.6),
    (140,'Antigo Unified',66.2,'Meets Expectations',2274,50.4),
    (147,'Appleton Area',68.5,'Meets Expectations',15775,35.8),
    (6720,'Arbor Vitae-Woodruff Elementary',83.2,'Significantly Exceeds Expectations',533,44.5),
    (154,'Arcadia',71.7,'Meets Expectations',1305,67.2),
    (161,'Argyle',69.3,'Meets Expectations',302,31.1),
    (2450,'Arrowhead High',82.8,'Exceeds Expectations',2174,5.7),
    (170,'Ashland',63.2,'Meets Expectations',2110,59.7),
    (182,'Ashwaubenon',72.1,'Meets Expectations',3301,31.8),
    (196,'Athens',68.2,'Meets Expectations',417,30),
    (203,'Auburndale',72.6,'Meets Expectations',856,22.7),
    (217,'Augusta',64.1,'Meets Expectations',627,40.7),
    (2884,'Badger High',66.5,'Meets Expectations',1471,29.1),
    (231,'Baldwin-Woodville Area',78.5,'Exceeds Expectations',1727,18.8),
    (245,'Bangor',74.7,'Exceeds Expectations',597,27.3),
    (280,'Baraboo',68.7,'Meets Expectations',2995,39.4),
    (287,'Barneveld',84.5,'Significantly Exceeds Expectations^',450,11.3),
    (308,'Barron Area',68.5,'Meets Expectations',1256,52.9),
    (315,'Bayfield',60.7,'Meets Few Expectations',367,57.8),
    (336,'Beaver Dam Unified',64.9,'Meets Expectations',3518,44.1),
    (4263,'Beecher-Dunbar-Pembine',84.4,'Significantly Exceeds Expectations',240,60),
    (350,'Belleville',76.5,'Exceeds Expectations',907,14.7),
    (364,'Belmont Community',63.9,'Meets Expectations',388,31.2),
    (413,'Beloit',60.1,'Meets Few Expectations',6823,71.6),
    (422,'Beloit Turner',78.4,'Exceeds Expectations',1538,39.9),
    (427,'Benton',76.7,'Exceeds Expectations',206,23.3),
    (434,'Berlin Area',65.2,'Meets Expectations',1640,44.1),
    (6013,'Big Foot High',67.1,'Meets Expectations',481,39.1),
    (441,'Birchwood',78.4,'Exceeds Expectations',303,49.5),
    (2240,'Black Hawk',64.9,'Meets Expectations',374,41.7),
    (476,'Black River Falls',65.3,'Meets Expectations',1710,51.4),
    (485,'Blair-Taylor',72.4,'Meets Expectations',627,36.8),
    (497,'Bloomer',66.4,'Meets Expectations',1266,29.2),
    (602,'Bonduel',73.6,'Exceeds Expectations',769,35.4),
    (609,'Boscobel Area',77.5,'Exceeds Expectations',820,55.1),
    (623,'Bowler',65.2,'Meets Expectations',328,52.4),
    (637,'Boyceville Community',83.2,'Significantly Exceeds Expectations',734,40.3),
    (657,'Brighton Elementary',92.2,'Significantly Exceeds Expectations',209,11.5),
    (658,'Brillion',83,'Significantly Exceeds Expectations',981,26.6),
    (665,'Bristol Elementary',76.5,'Exceeds Expectations',839,17.2),
    (700,'Brodhead',76.6,'Exceeds Expectations',1004,40.2),
    (721,'Brown Deer',73.2,'Exceeds Expectations',1548,43.6),
    (735,'Bruce',83.4,'Significantly Exceeds Expectations',438,64.4),
    (777,'Burlington Area',77.4,'Exceeds Expectations',3082,31.2),
    (840,'Butternut',69.1,'Meets Expectations',186,49.5),
    (870,'Cadott Community',65.1,'Meets Expectations',843,41.3),
    (882,'Cambria-Friesland',63.9,'Meets Expectations',383,45.2),
    (896,'Cambridge',71.9,'Meets Expectations',894,24.6),
    (903,'Cameron',73.2,'Exceeds Expectations',1048,39.6),
    (910,'Campbellsport',75,'Exceeds Expectations',1355,19.1),
    (980,'Cashton',78.2,'Exceeds Expectations',605,33.1),
    (994,'Cassville',81.8,'Exceeds Expectations',204,42.2),
    (1029,'Cedar Grove-Belgium Area',80.6,'Exceeds Expectations',997,14.8),
    (1015,'Cedarburg',81.8,'Exceeds Expectations',3098,6.4),
    (5054,'Central High',66.9,'Meets Expectations',1081,15.7),
    (1071,'Chequamegon',72.6,'Meets Expectations',761,52),
    (1080,'Chetek-Weyerhaeuser Area',83.8,'Significantly Exceeds Expectations',933,43.1),
    (1085,'Chilton',73.9,'Exceeds Expectations',1168,31.4),
    (1092,'Chippewa Falls Area Unified',68.8,'Meets Expectations',5111,34.1),
    (1120,'Clayton',66.7,'Meets Expectations',350,51.4),
    (1127,'Clear Lake',65.6,'Meets Expectations',609,33.2),
    (1134,'Clinton Community',73.6,'Exceeds Expectations',1105,34.2),
    (1141,'Clintonville',74,'Exceeds Expectations',1287,47.3),
    (1155,'Cochrane-Fountain City',70.1,'Meets Expectations',660,30.8),
    (1162,'Colby',73.5,'Exceeds Expectations',925,53),
    (1169,'Coleman',69.3,'Meets Expectations',700,39.6),
    (1176,'Colfax',74.2,'Exceeds Expectations',834,43),
    (1183,'Columbus',75.2,'Exceeds Expectations',1355,23.3),
    (1204,'Cornell',76.3,'Exceeds Expectations',392,59.7),
    (1218,'Crandon',64.7,'Meets Expectations',889,42.5),
    (1232,'Crivitz',76.9,'Exceeds Expectations',791,43),
    (1246,'Cuba City',84.5,'Significantly Exceeds Expectations',680,34),
    (1253,'Cudahy',63.1,'Meets Expectations',2322,57.9),
    (1260,'Cumberland',73.4,'Exceeds Expectations',971,38.3),
    (4970,'D C Everest Area',73.6,'Exceeds Expectations',6003,30.1),
    (1295,'Darlington Community',82.8,'Exceeds Expectations^',818,35),
    (1316,'De Forest Area',76.1,'Exceeds Expectations',3762,16.4),
    (1414,'De Pere',80.2,'Exceeds Expectations',4491,16.8),
    (1421,'De Soto Area',76.4,'Exceeds Expectations',486,42.4),
    (1309,'Deerfield Community',72,'Meets Expectations',757,13.5),
    (1380,'Delavan-Darien',83.6,'Significantly Exceeds Expectations',2149,64),
    (1407,'Denmark',81.4,'Exceeds Expectations',1566,17.8),
    (2744,'Dodgeland',71.5,'Meets Expectations',787,39.8),
    (1428,'Dodgeville',79.8,'Exceeds Expectations',1253,35),
    (4011,'Drought Elementary',82.6,'Exceeds Expectations',107,13.1),
    (1491,'Drummond Area',70,'Meets Expectations',360,51.7),
    (1499,'Durand-Arkansaw',80.1,'Exceeds Expectations^',942,33.9),
    (1540,'East Troy Community',76.1,'Exceeds Expectations',1645,21.3),
    (1554,'Eau Claire Area',72.6,'Meets Expectations',11367,34.4),
    (1561,'Edgar',70.6,'Meets Expectations',599,26),
    (1568,'Edgerton',74.6,'Exceeds Expectations',1826,28.6),
    (1582,'Elcho',63.1,'Meets Expectations',301,44.9),
    (1600,'Eleva-Strum',74.4,'Exceeds Expectations',617,32.6),
    (1645,'Elk Mound Area',77.2,'Exceeds Expectations',1206,28.8),
    (1631,'Elkhart Lake-Glenbeulah',82,'Exceeds Expectations',424,23.8),
    (1638,'Elkhorn Area',75.8,'Exceeds Expectations',3284,31.1),
    (1659,'Ellsworth Community',74.9,'Exceeds Expectations',1649,23.8),
    (714,'Elmbrook',88.4,'Significantly Exceeds Expectations',7239,6.8),
    (1666,'Elmwood',66.4,'Meets Expectations',298,31.2),
    (1687,'Erin Elementary',83.8,'Significantly Exceeds Expectations',392,11),
    (1694,'Evansville Community',76.7,'Exceeds Expectations',1808,22.2),
    (1729,'Fall Creek',74,'Exceeds Expectations',844,26.9),
    (1736,'Fall River',75,'Exceeds Expectations',471,33.3),
    (1813,'Fennimore Community',79.5,'Exceeds Expectations',825,39.9),
    (5757,'Flambeau',71.3,'Meets Expectations',571,48.2),
    (1855,'Florence County',67.4,'Meets Expectations',383,53.8),
    (1862,'Fond du Lac',71.9,'Meets Expectations',7204,41.9),
    (1870,'Fontana Elementary',83.1,'Significantly Exceeds Expectations',247,24.7),
    (1883,'Fort Atkinson',74.2,'Exceeds Expectations',2812,31.9),
    (1890,'Fox Point J2',91.8,'Significantly Exceeds Expectations',818,8.3),
    (1900,'Franklin Public',80.3,'Exceeds Expectations',4622,11.5),
    (1939,'Frederic',65.9,'Meets Expectations',438,52.7),
    (1953,'Freedom Area',78.3,'Exceeds Expectations',1620,17),
    (4843,'Friess Lake School',83.5,'Significantly Exceeds Expectations',174,2.3),
    (2009,'Galesville-Ettrick-Trempealeau',76.1,'Exceeds Expectations',1399,21.3),
    (2051,'Genoa City J2',72.3,'Meets Expectations',549,35.3),
    (2058,'Germantown',79,'Exceeds Expectations',3888,14.8),
    (2114,'Gibraltar Area',82.9,'Exceeds Expectations',541,29),
    (2128,'Gillett',79.9,'Exceeds Expectations',525,51),
    (2135,'Gilman',68.8,'Meets Expectations',347,53.3),
    (2142,'Gilmanton',74.3,'Exceeds Expectations',151,51.7),
    (2184,'Glendale-River Hills',70.8,'Meets Expectations',1055,29.9),
    (2198,'Glenwood City',70.8,'Meets Expectations',697,36.2),
    (2212,'Goodman-Armstrong Creek',64.9,'Meets Expectations',113,47.8),
    (2217,'Grafton',83.6,'Significantly Exceeds Expectations',2128,13.9),
    (2226,'Granton Area',70.2,'Meets Expectations',230,62.2),
    (2233,'Grantsburg',74.7,'Exceeds Expectations',898,43),
    (2289,'Green Bay Area Public',63,'Meets Expectations',20663,56.4),
    (2310,'Green Lake',75.8,'Exceeds Expectations',297,25.3),
    (2296,'Greendale',83.8,'Significantly Exceeds Expectations',2628,22.2),
    (2303,'Greenfield',68.9,'Meets Expectations',3499,42.2),
    (2394,'Greenwood',78.6,'Exceeds Expectations',390,52.1),
    (2415,'Gresham',65.9,'Meets Expectations',300,56.7),
    (2420,'Hamilton',89.3,'Significantly Exceeds Expectations',4881,11.9),
    (2436,'Hartford High',67,'Meets Expectations',1359,20.6),
    (2443,'Hartford J1',80.6,'Exceeds Expectations',1723,33.7),
    (2460,'Hartland-Lakeside J3',96.6,'Significantly Exceeds Expectations',1161,14.4),
    (2478,'Hayward Community',73.8,'Exceeds Expectations',1823,55.9),
    (2525,'Herman-Neosho-Rubicon',75.1,'Exceeds Expectations',347,26.5),
    (2527,'Highland',67.2,'Meets Expectations',311,23.8),
    (2534,'Hilbert',73.5,'Exceeds Expectations',442,27.8),
    (2541,'Hillsboro',61.1,'Meets Few Expectations',535,47.5),
    (2562,'Holmen',78.5,'Exceeds Expectations',3937,24.1),
    (2576,'Horicon',73.2,'Exceeds Expectations',700,31.6),
    (2583,'Hortonville Area',81,'Exceeds Expectations',3924,11.8),
    (2604,'Howard-Suamico',72,'Meets Expectations',6151,15),
    (2605,'Howards Grove',82.8,'Exceeds Expectations',885,13.7),
    (2611,'Hudson',82.2,'Exceeds Expectations',5620,13.1),
    (2618,'Hurley',77.1,'Exceeds Expectations',562,42.9),
    (2625,'Hustisford',70.3,'Meets Expectations',426,29.3),
    (2632,'Independence',79.3,'Exceeds Expectations',373,64.6),
    (2639,'Iola-Scandinavia',73.5,'Exceeds Expectations',671,32.6),
    (2646,'Iowa-Grant',72.1,'Meets Expectations',746,38.3),
    (2660,'Ithaca',70.4,'Meets Expectations',467,40.5),
    (2695,'Janesville',68.4,'Meets Expectations',10182,46.3),
    (2702,'Jefferson',72.6,'Meets Expectations',1932,37.2),
    (2730,'Johnson Creek',70.1,'Meets Expectations',631,20.3),
    (2737,'Juda',82.6,'Exceeds Expectations^',318,55),
    (1449,'Kansasville Elementary',77.5,'Exceeds Expectations',102,17.6),
    (2758,'Kaukauna Area',74.6,'Exceeds Expectations',3923,20.9),
    (2793,'Kenosha',71.2,'Meets Expectations',21636,53.4),
    (1376,'Kettle Moraine',81.9,'Exceeds Expectations',3898,10.2),
    (2800,'Kewaskum',81.8,'Exceeds Expectations',1825,17.8),
    (2814,'Kewaunee',75.1,'Exceeds Expectations',990,32.5),
    (5960,'Kickapoo Area',69.1,'Meets Expectations',541,50.1),
    (2828,'Kiel Area',75.1,'Exceeds Expectations',1247,17.4),
    (2835,'Kimberly Area',88.2,'Significantly Exceeds Expectations',5204,12.7),
    (2842,'Kohler',86,'Significantly Exceeds Expectations',712,0.6),
    (2849,'La Crosse',67.5,'Meets Expectations',6632,44.2),
    (2863,'La Farge',65.7,'Meets Expectations',226,52.2),
    (1848,'Lac du Flambeau Elementary',73.6,'Exceeds Expectations',517,95.2),
    (2856,'Ladysmith',71.7,'Meets Expectations',786,53.2),
    (3862,'Lake Country School',93,'Significantly Exceeds Expectations',515,5.8),
    (2885,'Lake Geneva J1',83.2,'Significantly Exceeds Expectations',1948,42.2),
    (2891,'Lake Holcombe',65.2,'Meets Expectations',323,43),
    (2898,'Lake Mills Area',78.7,'Exceeds Expectations',1581,22.4),
    (3647,'Lakeland High',69.8,'Meets Expectations',698,37.8),
    (5817,'Lakewood Elementary',75.7,'Exceeds Expectations',335,48.1),
    (2912,'Lancaster Community',76.8,'Exceeds Expectations',960,34.6),
    (2940,'Laona',74.6,'Exceeds Expectations',253,44.7),
    (2961,'Lena',72.6,'Meets Expectations',392,35.5),
    (3129,'Little Chute Area',76.5,'Exceeds Expectations',1585,27.6),
    (3150,'Lodi',74.6,'Exceeds Expectations',1520,15.4),
    (3171,'Lomira',74.7,'Exceeds Expectations',1055,24.1),
    (3206,'Loyal',70.9,'Meets Expectations',514,46.7),
    (3213,'Luck',66.8,'Meets Expectations',447,39.8),
    (3220,'Luxemburg-Casco',82.4,'Exceeds Expectations',1899,15),
    (3269,'Madison Metropolitan',68,'Meets Expectations',26968,46),
    (3276,'Manawa',69.1,'Meets Expectations',671,32),
    (3290,'Manitowoc',65.7,'Meets Expectations',5044,40.9),
    (3297,'Maple',81.3,'Exceeds Expectations',1319,35.9),
    (1897,'Maple Dale-Indian Hill',78.9,'Exceeds Expectations',484,9.5),
    (3304,'Marathon City',73.7,'Exceeds Expectations',324,22.5),
    (3311,'Marinette',69.4,'Meets Expectations',2015,49.5),
    (3318,'Marion',70.4,'Meets Expectations',480,55.6),
    (3325,'Markesan',86.6,'Significantly Exceeds Expectations',782,33),
    (3332,'Marshall',66.9,'Meets Expectations',1052,35.9),
    (3339,'Marshfield Unified',75,'Exceeds Expectations',3995,27.9),
    (3360,'Mauston',71.1,'Meets Expectations',1476,52.2),
    (3367,'Mayville',67.5,'Meets Expectations',1113,29.8),
    (3381,'McFarland',78.1,'Exceeds Expectations',2452,12.8),
    (3409,'Medford Area Public',68.8,'Meets Expectations',2165,35.6),
    (3427,'Mellen Public School',79.8,'Exceeds Expectations',298,61.1),
    (3428,'Melrose-Mindoro',71.1,'Meets Expectations',567,39.3),
    (3430,'Menasha Joint',73.4,'Exceeds Expectations',3542,56.5),
    (3434,'Menominee Indian',56.8,'Meets Few Expectations',887,91.5),
    (3437,'Menomonee Falls',81.2,'Exceeds Expectations',3992,14.9),
    (3444,'Menomonie Area',74.6,'Exceeds Expectations',3372,35.2),
    (3479,'Mequon-Thiensville',87.9,'Significantly Exceeds Expectations',3709,8.9),
    (3484,'Mercer School',55.9,'Meets Few Expectations',151,50.3),
    (3500,'Merrill Area',67.2,'Meets Expectations',2552,40.8),
    (3528,'Merton Community',91.3,'Significantly Exceeds Expectations',845,4.5),
    (3549,'Middleton-Cross Plains Area',80.1,'Exceeds Expectations',7325,17.1),
    (3612,'Milton',74.7,'Exceeds Expectations',3497,18),
    (3619,'Milwaukee',57,'Meets Few Expectations',75539,85.6),
    (3633,'Mineral Point Unified',87.1,'Significantly Exceeds Expectations',725,24.3),
    (3640,'Minocqua J1',86.1,'Significantly Exceeds Expectations',597,35.7),
    (3661,'Mishicot',72.9,'Meets Expectations',852,22.5),
    (3668,'Mondovi',73.7,'Exceeds Expectations',976,35.7),
    (3675,'Monona Grove',73.6,'Exceeds Expectations',3456,15.5),
    (3682,'Monroe',75.8,'Exceeds Expectations',2383,36),
    (3689,'Montello',64.4,'Meets Expectations',689,41.5),
    (3696,'Monticello',74.3,'Exceeds Expectations',337,34.7),
    (3787,'Mosinee',76.9,'Exceeds Expectations',1970,26.4),
    (3794,'Mount Horeb Area',77,'Exceeds Expectations',2532,11.5),
    (3822,'Mukwonago',83.1,'Significantly Exceeds Expectations',4938,11.1),
    (3857,'Muskego-Norway',84.3,'Significantly Exceeds Expectations',4894,8.7),
    (3871,'Necedah Area',61.3,'Meets Few Expectations',705,53.3),
    (3892,'Neenah Joint',75.5,'Exceeds Expectations',6699,25.7),
    (3899,'Neillsville',73.8,'Exceeds Expectations',935,39.8),
    (3906,'Nekoosa',73.2,'Exceeds Expectations',1167,41.6),
    (3920,'New Auburn',57.6,'Meets Few Expectations',328,41.8),
    (3925,'New Berlin',85.7,'Significantly Exceeds Expectations',4390,9.9),
    (3934,'New Glarus',75.2,'Exceeds Expectations',985,16.5),
    (3941,'New Holstein',74.2,'Exceeds Expectations',1080,18),
    (3948,'New Lisbon',64.3,'Meets Expectations^',668,44.2),
    (3955,'New London',80.9,'Exceeds Expectations',2318,34),
    (3962,'New Richmond',80.3,'Exceeds Expectations',3419,22.4),
    (3969,'Niagara',74.4,'Exceeds Expectations',441,41.7),
    (2177,'Nicolet High',81.5,'Exceeds Expectations',1098,15.2),
    (3976,'Norris High',NULL,'Alternate Rating - Satisfactory Progress',20,30),
    (4690,'North Cape Elementary',80,'Exceeds Expectations',186,8.6);
INSERT INTO wisc_ratings17 VALUES
    (2016,'North Crawford',74.5,'Exceeds Expectations',453,54.1),
    (3983,'North Fond du Lac',73.3,'Exceeds Expectations',1419,53.1),
    (3514,'North Lake Elementary',87.1,'Significantly Exceeds Expectations',347,0),
    (616,'North Lakeland Elementary',85.1,'Significantly Exceeds Expectations',151,41.1),
    (1945,'Northern Ozaukee',76.6,'Exceeds Expectations',741,24),
    (1526,'Northland Pines',75.7,'Exceeds Expectations',1299,37.2),
    (3654,'Northwood',75,'Exceeds Expectations',341,46.3),
    (3990,'Norwalk-Ontario-Wilton',66.7,'Meets Expectations',666,60.4),
    (4018,'Oak Creek-Franklin Joint',79.9,'Exceeds Expectations',6584,22),
    (4025,'Oakfield',84.5,'Significantly Exceeds Expectations',538,18.4),
    (4060,'Oconomowoc Area',79.2,'Exceeds Expectations',5304,13.5),
    (4074,'Oconto Falls Public',66.7,'Meets Expectations',1738,33),
    (4067,'Oconto Unified',75.3,'Exceeds Expectations',1033,41.3),
    (4088,'Omro',69.2,'Meets Expectations',1173,26.8),
    (4095,'Onalaska',80.9,'Exceeds Expectations',3178,25.2),
    (4137,'Oostburg',78.3,'Exceeds Expectations',1006,17.6),
    (4144,'Oregon',78.7,'Exceeds Expectations',4038,14.9),
    (4165,'Osceola',85.2,'Significantly Exceeds Expectations',1695,22.2),
    (4179,'Oshkosh Area',74,'Exceeds Expectations',9951,41.1),
    (4186,'Osseo-Fairchild',75,'Exceeds Expectations',828,38.2),
    (4207,'Owen-Withee',62.1,'Meets Few Expectations',493,48.1),
    (4221,'Palmyra-Eagle Area',73.2,'Exceeds Expectations',805,26.7),
    (4228,'Pardeeville Area',80.1,'Exceeds Expectations',811,30.7),
    (4235,'Paris Elementary',79.7,'Exceeds Expectations',283,19.1),
    (4151,'Parkview',78.5,'Exceeds Expectations',746,35.4),
    (490,'Pecatonica Area',78.4,'Exceeds Expectations',240,37.5),
    (4270,'Pepin Area',71.7,'Meets Expectations',224,26.8),
    (4305,'Peshtigo',71.6,'Meets Expectations',1232,34),
    (4312,'Pewaukee',82.2,'Exceeds Expectations',2987,9.1),
    (4330,'Phelps',64.1,'Meets Expectations',139,54.7),
    (4347,'Phillips',70,'Meets Expectations',774,41.7),
    (4368,'Pittsville',73.8,'Exceeds Expectations',573,36.5),
    (4389,'Platteville',78.4,'Exceeds Expectations',1526,33.2),
    (4459,'Plum City',73.1,'Exceeds Expectations',299,38.5),
    (4473,'Plymouth Joint',66.7,'Meets Expectations',2265,21.5),
    (4508,'Port Edwards',77.2,'Exceeds Expectations',407,35.9),
    (4515,'Port Washington-Saukville',80.2,'Exceeds Expectations',2630,19.4),
    (4501,'Portage Community',67.6,'Meets Expectations',2420,33.3),
    (4529,'Potosi',68.6,'Meets Expectations',335,34.6),
    (4536,'Poynette',75.8,'Exceeds Expectations',1084,19.9),
    (4543,'Prairie du Chien Area',82,'Exceeds Expectations',1106,56.9),
    (4557,'Prairie Farm Public',74.4,'Exceeds Expectations',403,33.7),
    (4571,'Prentice',69.4,'Meets Expectations',369,41.7),
    (4578,'Prescott',75,'Exceeds Expectations',1362,15.9),
    (4606,'Princeton School',69.9,'Meets Expectations',352,34.9),
    (4613,'Pulaski Community',77.9,'Exceeds Expectations',3706,18.2),
    (4620,'Racine Unified',58,'Meets Few Expectations',18128,64.7),
    (4627,'Randall Consolidated School',82.5,'Exceeds Expectations',693,23.1),
    (4634,'Randolph',78.8,'Exceeds Expectations',547,31.6),
    (4641,'Random Lake',75.1,'Exceeds Expectations',782,27.6),
    (4686,'Raymond Elementary',87.4,'Significantly Exceeds Expectations',412,7.8),
    (4753,'Reedsburg',75.4,'Exceeds Expectations',2806,39.5),
    (4760,'Reedsville',74.4,'Exceeds Expectations',566,23.7),
    (3094,'Reek Elementary',89.3,'Significantly Exceeds Expectations',143,23.1),
    (4781,'Rhinelander',66.3,'Meets Expectations',2377,42.7),
    (4795,'Rib Lake',78.2,'Exceeds Expectations',483,36.4),
    (4802,'Rice Lake Area',76.2,'Exceeds Expectations',2280,37.2),
    (4820,'Richfield J1',81.8,'Exceeds Expectations',389,6.9),
    (4851,'Richland',69.3,'Meets Expectations',1333,56.8),
    (3122,'Richmond Elementary',90.2,'Significantly Exceeds Expectations',431,1.6),
    (4865,'Rio Community',75.3,'Exceeds Expectations',409,39.4),
    (4872,'Ripon Area',79.9,'Exceeds Expectations',1631,31.5),
    (4893,'River Falls',77.7,'Exceeds Expectations',3397,19),
    (4904,'River Ridge',78.4,'Exceeds Expectations',545,41.8),
    (5523,'River Valley',79.9,'Exceeds Expectations',1244,29.3),
    (3850,'Riverdale',74.7,'Exceeds Expectations',660,47.6),
    (5369,'Riverview Elementary',85.4,'Significantly Exceeds Expectations',480,37.3),
    (4956,'Rosendale-Brandon',82.4,'Exceeds Expectations',1054,15.5),
    (4963,'Rosholt',63.8,'Meets Expectations',555,21.1),
    (1673,'Royall',68.9,'Meets Expectations',555,53.7),
    (2422,'Saint Croix Central',79.9,'Exceeds Expectations',1591,13.3),
    (5019,'Saint Croix Falls',74.5,'Exceeds Expectations',1105,31),
    (5026,'Saint Francis',74.7,'Exceeds Expectations',1148,43),
    (5068,'Salem Elementary',78.5,'Exceeds Expectations',968,34.2),
    (5100,'Sauk Prairie',74.6,'Exceeds Expectations',2810,27.8),
    (5124,'Seneca Area',76.9,'Exceeds Expectations',302,54.6),
    (5130,'Sevastopol',89.2,'Significantly Exceeds Expectations',602,24.6),
    (5138,'Seymour Community',69.6,'Meets Expectations',2219,28.3),
    (5258,'Sharon Community',68.2,'Meets Expectations',278,55),
    (5264,'Shawano',68.8,'Meets Expectations',1936,43.1),
    (5271,'Sheboygan Area',71.2,'Meets Expectations',10188,52.1),
    (5278,'Sheboygan Falls',73.2,'Exceeds Expectations',1681,25.6),
    (5306,'Shell Lake',71.6,'Meets Expectations',698,52.9),
    (5348,'Shiocton',75.7,'Exceeds Expectations',718,29.9),
    (5355,'Shorewood',85.5,'Significantly Exceeds Expectations',2106,14.7),
    (5362,'Shullsburg',67.2,'Meets Expectations',367,33.8),
    (5376,'Siren',68,'Meets Expectations',479,60.8),
    (5390,'Slinger',87.1,'Significantly Exceeds Expectations',3286,11.2),
    (5397,'Solon Springs School',68.5,'Meets Expectations',269,44.2),
    (5432,'Somerset',78.4,'Exceeds Expectations',1537,19.4),
    (5439,'South Milwaukee',72.8,'Meets Expectations',3165,49.8),
    (4522,'South Shore',71.2,'Meets Expectations',164,51.2),
    (5457,'Southern Door County',75.8,'Exceeds Expectations',1032,36.2),
    (2485,'Southwestern Wisconsin',78.3,'Exceeds Expectations',508,39.8),
    (5460,'Sparta Area',67.7,'Meets Expectations',2974,43.6),
    (5467,'Spencer',73.8,'Exceeds Expectations',707,39),
    (5474,'Spooner Area',71.5,'Meets Expectations',1149,55),
    (5586,'Spring Valley',68.5,'Meets Expectations',775,24.6),
    (5593,'Stanley-Boyd Area',82.5,'Exceeds Expectations',1082,51.5),
    (5607,'Stevens Point Area Public',72.1,'Meets Expectations',7095,35.6),
    (5614,'Stockbridge',70.2,'Meets Expectations',208,20.7),
    (3542,'Stone Bank Elementary',84.5,'Significantly Exceeds Expectations',389,9.5),
    (5621,'Stoughton Area',71.8,'Meets Expectations',3050,24),
    (5628,'Stratford',80.2,'Exceeds Expectations',925,14.9),
    (5642,'Sturgeon Bay',79.8,'Exceeds Expectations',1148,40.9),
    (5656,'Sun Prairie Area',73.1,'Exceeds Expectations',8428,23.8),
    (5663,'Superior',68.6,'Meets Expectations',4705,44.8),
    (5670,'Suring Public',74.3,'Exceeds Expectations',367,56.1),
    (3510,'Swallow Elementary',89.1,'Significantly Exceeds Expectations',521,1.9),
    (5726,'Thorp',64.6,'Meets Expectations',614,43),
    (5733,'Three Lakes',78.2,'Exceeds Expectations',512,35.4),
    (5740,'Tigerton',64.9,'Meets Expectations',227,57.3),
    (5747,'Tomah Area',69,'Meets Expectations',2991,39.6),
    (5754,'Tomahawk',80.5,'Exceeds Expectations',1248,31.6),
    (126,'Tomorrow River',75.4,'Exceeds Expectations',1197,21.6),
    (3087,'Traver Elementary',69.9,'Meets Expectations',94,40.4),
    (5780,'Trevor-Wilmot Grade',81.5,'Exceeds Expectations',535,33.1),
    (4375,'Tri-County Area',76.5,'Exceeds Expectations',610,64.9),
    (5810,'Turtle Lake',73.5,'Exceeds Expectations',445,52.1),
    (5824,'Two Rivers Public',64.5,'Meets Expectations',1673,45.5),
    (5859,'Union Grove Elementary',78.7,'Exceeds Expectations',796,24.7),
    (5852,'Union Grove High',73.7,'Exceeds Expectations',1004,12.4),
    (238,'Unity',76.5,'Exceeds Expectations',936,55.7),
    (5866,'Valders Area',71.1,'Meets Expectations',994,16.3),
    (5901,'Verona Area',68.7,'Meets Expectations',5543,26.3),
    (5985,'Viroqua Area',67.7,'Meets Expectations',1180,38.5),
    (5992,'Wabeno Area',58.9,'Meets Few Expectations^',402,56.7),
    (6022,'Walworth Elementary',72.1,'Meets Expectations',488,53.9),
    (6027,'Washburn',80.8,'Exceeds Expectations',553,35.8),
    (6069,'Washington',65.2,'Meets Expectations',69,36.2),
    (6104,'Washington Elementary',86.5,'Significantly Exceeds Expectations',180,12.8),
    (6113,'Waterford Graded J1',75.6,'Exceeds Expectations',1506,15.8),
    (6083,'Waterford High',69.1,'Meets Expectations',1100,8.9),
    (6118,'Waterloo',71.4,'Meets Expectations',804,35.4),
    (6125,'Watertown Unified',67.3,'Meets Expectations',3670,36.7),
    (6174,'Waukesha',70.1,'Meets Expectations',12108,29.9),
    (6181,'Waunakee Community',84.6,'Significantly Exceeds Expectations',4252,6.5),
    (6195,'Waupaca',78.8,'Exceeds Expectations',2152,39.7),
    (6216,'Waupun',70.8,'Meets Expectations',1945,34.2),
    (6223,'Wausau',75.3,'Exceeds Expectations',8388,42),
    (6230,'Wausaukee',69.8,'Meets Expectations',451,52.5),
    (6237,'Wautoma Area',66.5,'Meets Expectations',1365,57.3),
    (6244,'Wauwatosa',80.1,'Exceeds Expectations',7008,20.5),
    (6251,'Wauzeka-Steuben',71.1,'Meets Expectations',282,55.7),
    (6293,'Webster',65.2,'Meets Expectations',676,55.2),
    (6300,'West Allis-West Milwaukee',72.2,'Meets Expectations',8714,53.1),
    (6307,'West Bend',75.4,'Exceeds Expectations',6687,28.4),
    (6328,'West De Pere',76.5,'Exceeds Expectations',3511,19.5),
    (6370,'West Salem',76.6,'Exceeds Expectations',1823,23.6),
    (6321,'Westby Area',78.5,'Exceeds Expectations',1113,30.1),
    (6335,'Westfield',68,'Meets Expectations',1070,50.7),
    (6354,'Weston',62.9,'Meets Few Expectations',260,45),
    (6384,'Weyauwega-Fremont',76.8,'Exceeds Expectations',824,32.3),
    (6412,'Wheatland Center Elementary',69,'Meets Expectations',497,40.2),
    (6440,'White Lake',66.5,'Meets Expectations',156,58.3),
    (6419,'Whitefish Bay',90.1,'Significantly Exceeds Expectations',2971,1.9),
    (6426,'Whitehall',75.9,'Exceeds Expectations',783,41.4),
    (6461,'Whitewater Unified',72.3,'Meets Expectations',1927,38.3),
    (6470,'Whitnall',80.3,'Exceeds Expectations',2524,19.9),
    (6475,'Wild Rose',76,'Exceeds Expectations',601,40.6),
    (6482,'Williams Bay',73.5,'Exceeds Expectations',721,24.8),
    (6545,'Wilmot High',62.4,'Meets Few Expectations',1076,27.5),
    (6608,'Winneconne Community',89.6,'Significantly Exceeds Expectations',1667,18),
    (6615,'Winter',74.5,'Exceeds Expectations',246,55.7),
    (6678,'Wisconsin Dells',70.1,'Meets Expectations',1711,48.2),
    (469,'Wisconsin Heights',76.6,'Exceeds Expectations',781,19.7),
    (6685,'Wisconsin Rapids',70.8,'Meets Expectations',5101,43.4),
    (6692,'Wittenberg-Birnamwood',77.6,'Exceeds Expectations',1164,37.6),
    (6713,'Wonewoc-Union Center',67.8,'Meets Expectations',341,50.4),
    (2044,'Woods Elementary',75.9,'Exceeds Expectations',206,0),
    (6734,'Wrightstown Community',84.2,'Significantly Exceeds Expectations',1348,20),
    (6748,'Yorkville Elementary',78.5,'Exceeds Expectations',463,9.5);