-- MySQL dump 10.13  Distrib 5.5.38, for debian-linux-gnu (x86_64)
--
-- Host: localhost    Database: csa
-- ------------------------------------------------------
-- Server version	5.5.38-0ubuntu0.14.04.1

/*!40101 SET @OLD_CHARACTER_SET_CLIENT=@@CHARACTER_SET_CLIENT */;
/*!40101 SET @OLD_CHARACTER_SET_RESULTS=@@CHARACTER_SET_RESULTS */;
/*!40101 SET @OLD_COLLATION_CONNECTION=@@COLLATION_CONNECTION */;
/*!40101 SET NAMES utf8 */;
/*!40103 SET @OLD_TIME_ZONE=@@TIME_ZONE */;
/*!40103 SET TIME_ZONE='+00:00' */;
/*!40014 SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0 */;
/*!40014 SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0 */;
/*!40101 SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */;
/*!40111 SET @OLD_SQL_NOTES=@@SQL_NOTES, SQL_NOTES=0 */;

--
-- Table structure for table `building`
--

DROP TABLE IF EXISTS `building`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `building` (
  `bldgID` int(11) NOT NULL AUTO_INCREMENT,
  `acceptednameID` int(11) DEFAULT NULL,
  `address` int(11) DEFAULT NULL,
  `street` varchar(50) DEFAULT NULL,
  `completion` int(11) DEFAULT NULL,
  `firm` varchar(75) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `earlydemol` int(11) DEFAULT NULL,
  `latedemol` int(11) DEFAULT NULL,
  `paragraphs` int(11) DEFAULT NULL,
  `sentences` int(11) DEFAULT NULL,
  `pages` int(11) DEFAULT NULL,
  `location` varchar(75) DEFAULT NULL,
  `area` varchar(75) DEFAULT NULL,
  `comment` text,
  PRIMARY KEY (`bldgID`)
) ENGINE=MyISAM AUTO_INCREMENT=314 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `building`
--

LOCK TABLES `building` WRITE;
/*!40000 ALTER TABLE `building` DISABLE KEYS */;
INSERT INTO `building` VALUES (1,23,542,'Rush',1891,'Edmund R. Krause','demolished',1965,1990,0,1,0,'Chicago','Illinois','overtly stated to be standing with original name'),(2,24,NULL,'',1946,'Mies van der Rohe','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(3,25,1301,'State',1919,'Schmidt, Garden, & Martin','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(4,27,-21,'Monroe',1873,'H.H. Richardson','demolished',1930,1930,1,0,0,'Chicago','Illinois',''),(5,28,33,'La Salle',1928,'Graham, Anderson, Probst, & White','extant',NULL,NULL,0,0,0,'Chicago','Illinois','Info. from Randall'),(6,29,3,'Spruce',1895,'R.H. Robertson','extant',NULL,NULL,0,0,1,'New York','USA',''),(7,30,-90,'Monroe',1906,'Hunt','demolished',1969,1969,0,0,0,'Chicago','Illinois','Info. from Randall'),(8,31,-3301,'Indiana',1890,'Adler & Sullivan','demolished',2006,2006,0,0,0,'Chicago','Illinois','Text has minimal info. but uses present tense; Wikipedia has address, history, description of fire that destroyed all but walls in 2006'),(9,32,-501,'Lee',1922,'Laurence G. Hallberg','extant',NULL,NULL,0,3,0,'Evanston','Illinois','Comparing Google photo with description in text'),(10,33,80,'Jackson',1887,'Burnham & Root','demolished',1887,1904,0,0,0,'Chicago','Illinois',''),(11,34,-101,'Michigan',1893,'Shepley, Rutan & Coolidge','extant',NULL,NULL,0,0,0,'Chicago','Illinois',''),(12,35,161,'Clark',1892,'Burnham & Root','demolished',1949,1949,0,0,1,'Chicago','Illinois',''),(13,37,50,'Congress',1889,'Adler & Sullivan','extant',NULL,NULL,0,0,9,'Chicago','Illinois',''),(14,38,-111,'Jackson',1886,'Burnham & Root','demolished',1959,1959,0,5,0,'Chicago','Illinois',''),(15,39,NULL,'',1915,'Purcell, Feick, & Elmslie',NULL,NULL,NULL,0,0,0,'Riverside','Illinois',''),(16,40,NULL,'',1907,'Sullivan',NULL,NULL,NULL,0,0,0,'Riverside','Illinois',''),(17,41,-529,'Franklin',1898,'Holabird & Roche ','demolished',1953,1953,0,1,0,'Chicago','Illinois',''),(18,42,NULL,'',1853,'Hoxie',NULL,NULL,NULL,0,1,0,'Philadelphia','USA',''),(19,43,-2500,'Dearborn',1907,'Holabird & Roche ','demolished',1962,1962,0,2,0,'Chicago','Illinois',''),(20,44,65,'Bleecker',1897,'Sullivan','extant',NULL,NULL,0,1,0,'New York','USA',''),(21,45,1120,'MIchigan',1914,'Van Bergen','extant',NULL,NULL,0,2,0,'Wilmette','Illinois',''),(22,46,NULL,'',1858,'Labrouste',NULL,NULL,NULL,0,0,0,'Paris','foreign',''),(23,47,-141,'Jackson',1885,'Boyington','demolished',1929,1929,0,0,0,'Chicago','Illinois',''),(24,48,-141,'Jackson',1930,'Holabird & Root','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(25,49,NULL,'',1858,'Greene',NULL,NULL,NULL,0,1,0,'Sheerness, England','foreign',''),(26,50,-1140,'Michigan ',1891,'Baumann & Cady ','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(27,51,150,'Dearborn',1879,'Adler & Sullivan','demolished',1916,1916,1,0,0,'Chicago','Illinois',''),(28,52,-200,'Michigan',1958,'','extant',NULL,NULL,0,0,0,'Chicago','Illinois',''),(29,53,-540,'Wells',1908,'Holabird & Roche ','demolished',1953,1953,0,0,0,'Chicago','Illinois',''),(30,54,2,'State',1905,'Holabird & Roche ','extant',NULL,NULL,0,4,0,'Chicago','Illinois',''),(31,55,NULL,'',1911,'Elmslie',NULL,NULL,NULL,0,0,0,'Woods Hole, MA','USA',''),(32,56,2800,'Pine Grove',1893,'R.H. Turnock','extant',NULL,NULL,0,0,1,'Chicago','Illinois',''),(33,57,-223,'Jackson',1910,'Holabird & Roche ','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(34,59,700,'Orleans',1883,'Adler & Sullivan','demolished',1989,1989,0,0,0,'Chicago','Illinois','Burned in 1989'),(35,60,-3301,'Frankin',1921,'Schmidt, Garden, & Martin','demolished',2008,2008,1,0,0,'Chicago','Illinois','Wikipedia and online photos prove it came down in 2008'),(36,61,-301,'Wabash',1899,'Holabird & Roche ','demolished',1960,1960,0,0,1,'Chicago','Illinois',''),(37,62,NULL,'',1792,'Strutt',NULL,NULL,NULL,0,1,0,'Derby','foreign',''),(38,63,-200,'La Salle',1883,'Burnham & Root','demolished',1913,1913,1,0,0,'Chicago','Illinois',''),(39,67,-1,'State',1903,'Sullivan','extant',NULL,NULL,0,0,4,'Chicago','Illinois',''),(40,65,44,'Wabash',1926,'Hubert & Daniel Burnham','extant',NULL,NULL,0,0,1,'Chicago','Illinois',''),(41,68,-300,'Adams',1875,'Van Osdel','demolished',1926,1926,1,0,0,'Chicago','Illinois','Demolition date from Randall'),(42,69,1024,'Judson',1910,'Griffin','extant',NULL,NULL,0,3,0,'Evanston','Illinois',''),(43,70,-508,'Dearborn',1889,'Holabird & Roche ','demolished',1947,1947,1,0,0,'Chicago','Illinois',''),(44,71,1,'Randolph',1879,'Adler','demolished',1901,1901,0,0,2,'Chicago','Illinois',''),(45,72,-19,'La Salle',1892,'Jenney','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(46,73,-202,'State',1914,'Holabird & Roche ','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(47,74,33,'La Salle',1888,'Baumann & Huehl','demolished',1928,1928,0,0,2,'Chicago','Illinois',''),(48,75,1,'State',1894,'Holabird & Roche ','demolished',1916,1916,1,0,0,'Chicago','Illinois',''),(49,76,-37,'Wabash',1903,'Holabird & Roche ','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(50,77,63,'Adams',1904,'Schmidt','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(51,78,NULL,'',1912,'Byrne',NULL,NULL,NULL,0,1,0,'Luban, Poland','foreign',''),(52,79,NULL,'',1822,'Strickland',NULL,NULL,NULL,0,1,0,'Philadelphia','USA',''),(53,81,-7,'Madison',1904,'Holabird & Roche ','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(54,80,-5101,'Cornell',1890,'Starrett and Fuller','demolished',1946,1950,0,3,0,'Chicago','Illinois','architects not known with certainty; online sites suggest this was demolished in the late 1940s, but CWC says still standing in 1963'),(55,82,-207,'Wabash',1910,'Burnham, D.H., & Co.','demolished',1995,1995,1,0,0,'Chicago','Illinois',''),(56,83,-400,'Michigan',1882,'Burnham & Root','demolished',1929,1929,0,2,0,'Chicago','Illinois',''),(57,84,-300,'Lake',1891,'Sullivan','demolished',1902,1902,1,0,0,'Chicago','Illinois',''),(58,85,-339,'Franklin',1904,'Jenney','demolished',1975,1975,1,0,0,'Chicago','Illinois','Info. from Randall'),(59,86,-161,'Washington',1891,'Burnham & Root','demolished',1936,1936,0,0,0,'Chicago','Illinois','Info. from Randall'),(60,89,132,'Clark',1884,'Cobb & Frost','demolished',1912,1912,0,0,1,'Chicago','Illinois',''),(61,93,-32,'Wabash',1903,'Hill & Woltersdorf','extant',NULL,NULL,0,0,0,'Chicago','Illinois',''),(62,94,-50,'Washington',1963,'C.F. Murphy Associates','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(63,95,20,'Wacker',1928,'Grahm, Anderson, Probst & White','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(64,96,3850,'Albany',1911,'Perkins','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(65,98,1632,'Ashland',1912,'Griffin','extant',NULL,NULL,1,0,0,'Evanston','Illinois',''),(66,100,-5701,'Midway Park',1908,'Drummond','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(67,101,-520,'Michigan ',1892,'Warren; Holabird & Roche','extant',NULL,NULL,0,0,2,'Chicago','Illinois',''),(68,103,55,'Jackson',1961,'C.F. Murphy Associates','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(69,106,281,'Bloomingbank Rd',1908,'Wright','extant',NULL,NULL,0,1,0,'Riverside','Illinois',''),(70,105,NULL,'',1910,'Wright','extant',NULL,NULL,0,1,0,'Riverside','Illinois',''),(71,107,NULL,'',1859,'',NULL,NULL,NULL,0,0,0,'New York','USA',''),(72,108,-230,'La Salle',1884,'Burnham & Root','demolished',1920,1920,0,2,0,'Chicago','Illinois',''),(73,109,-1201,'Canal',1903,'Sullivan','demolished',1912,1912,0,2,0,'Chicago','Illinois',''),(74,110,-836,'Michigan ',1912,'Holabird & Roche ','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(75,111,150,'Michigan',1920,'Holabird & Roche ','demolished',1981,1981,0,1,0,'Chicago','Illinois',''),(76,113,-3360,'State',1955,'Mies van der Rohe','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(77,114,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'London','foreign',''),(78,115,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'New York','USA',''),(79,116,-400,'Madison',1929,'Holabird & Root','extant',NULL,NULL,0,1,0,'Chicago','Illinois','Info. from Randall, though Randall has architects Holabird & Roche, appearing to be a typo'),(80,117,NULL,'',NULL,'Hood',NULL,NULL,NULL,0,0,0,'New York','USA',''),(81,120,-39,'Adams',1883,'Warren; Burnham & Root','demolished',1961,1961,1,0,0,'Chicago','Illinois',''),(82,121,-630,'Wabash',1887,'Adler & Sullivan','demolished',2006,2006,1,0,0,'Chicago','Illinois','Burned accidently in 2006'),(83,123,-411,'Wells',1908,'Nimmons & Fellows','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(84,124,-626,'Clark',1911,'Schmidt, Garden, & Martin','extant',NULL,NULL,0,3,0,'Chicago','Illinois',''),(85,125,-229,'Wabash',1912,'Purcell, Feick, & Elmslie','demolished',1967,1967,0,0,1,'Chicago','Illinois','Demolition date from Randall'),(86,127,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'Paris','foreign',''),(87,20,870,'Lake Shore Drive',1952,'Mies van der Rohe','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(88,129,58,'Oak',1938,'Pereira','extant',NULL,NULL,0,0,0,'Chicago','Illinois',''),(89,130,-3005,'Carroll',1905,'Wright','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(90,131,-16,'Adams',1890,'Jenney','demolished',1984,1984,2,0,0,'Chicago','Illinois',''),(91,132,171,'Wabash',1864,'Van Osdel','demolished',1872,1872,0,1,0,'Chicago','Illinois',''),(92,133,-350,'Monroe??',1882,'Van Osdel','demolished',1954,1954,0,1,0,'Chicago','Illinois','An earlier Farwell block is in one diagram; info. from Randall'),(93,134,-219,'Dearborn',1961,'Mies van der Rohe','extant',NULL,NULL,0,0,0,'Chicago','Illinois',''),(94,135,701,'Forty-seventh',1905,'Sullivan','demolished',1982,1982,0,2,0,'Chicago','Illinois',''),(95,136,-135,'La Salle',1934,'Graham, Anderson, Probst, & White','extant',NULL,NULL,0,0,0,'Chicago','Illinois',''),(96,139,111,'State',1901,'Burnham','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(97,140,-200,'Wells',1885,'Richardson','demolished',1930,1930,0,0,2,'Chicago','Illinois',''),(98,137,103,'State',1878,'??','demolished',1902,1902,0,0,0,'Chicago','Illinois','3 STORES OCCUPIED THIS SITE PRIOR TO THE LAST; FIRST 2 BURNED'),(99,138,-330,'Madison',1872,'??','demolished',1885,1885,0,0,0,'Chicago','Illinois',''),(100,16,5730,'Sheridan',1914,'Van Bergen','demolished',1960,1960,0,2,0,'Chicago','Illinois',''),(101,142,-5700,'Lake Shore Drive',1892,'Atwood','extant',NULL,NULL,0,1,0,'Chicago','Illinois','Reconstructed in 1932'),(102,143,-80,'Monroe',1896,'Burnham, D.H., & Co.','demolished',1969,1969,0,3,0,'Chicago','Illinois',''),(103,144,-343,'Dearborn',1896,'Burnham, D.H., & Co.','extant',NULL,NULL,2,0,0,'Chicago','Illinois',''),(104,145,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'New York','USA',''),(105,148,-4304,'Forrestville',1895,'Wright','demolished',1971,1971,0,3,0,'Chicago','Illinois',''),(106,149,-141,'Wells',1882,'Adler & Sullivan','demolished',1882,1950,0,1,0,'Chicago','Illinois',''),(107,150,-18,'Michigan',1899,'Sullivan','extant',NULL,NULL,3,0,0,'Chicago','Illinois','3 GAGE BLDS APPEAR AS 1 ENTRY IN INDEX'),(108,151,-24,'Michigan',1898,'Holabird & Roche ','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(109,152,-30,'Michigan',1898,'Holabird & Roche ','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(110,153,20,'Monroe',1940,'Kroman','extant',NULL,NULL,0,3,0,'Chicago','Illinois','Former garage was merged with the Carson Pirie Scott Annex in 1950'),(111,154,NULL,'Tallmadge & Ogden',1910,'Schmidt, Garden, & Martin',NULL,NULL,NULL,0,3,0,'Chicago','Illinois','Described in present tense, but address unknown so current status uncertain'),(112,155,-320,'Jackson',1880,'Smith, M. Randolph','demolished',1965,1965,0,1,0,'Chicago','Illinois','Info. from Randall'),(113,156,-64,'Randolph',1891,'Adler & Sullivan','demolished',1961,1961,0,0,5,'Chicago','Illinois',''),(114,157,NULL,'Rush',1884,'Adler & Sullivan','demolished',1884,1963,0,1,0,'Chicago','Illinois',NULL),(115,158,-1800,'Prarie',1886,'Richardson','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(116,160,180,'Wacker',1912,'Holabird & Roche ','extant',NULL,NULL,0,1,0,'Chicago','Illinois','I asked at artefaqs.com and got a reply saying yes, the current structure at the site is the Great Lakes Bldg'),(117,161,-237,'Dearborn',1890,'Burnham & Root','demolished',1940,1940,0,0,1,'Chicago','Illinois',''),(118,162,-20,'Jackson',1896,'Burnham & Root','demolished',1961,1961,1,0,0,'Chicago','Illinois',''),(119,163,-108,'Illinois',1901,'Schmidt','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(120,164,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'Buffalo','USA',''),(121,165,44,'Ashland',1882,'Burnham & Root','demolished',1963,1963,0,0,0,'Chicago','Illinois',''),(122,166,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'New York','USA',''),(123,167,-100,'Wacker',1961,'Skidmore, Owings, & Merrill','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(124,168,NULL,'',1926,'Elmslie','extant',NULL,NULL,0,3,0,'Aurora','Illinois',''),(125,169,-111,'Oak',1906,'Schmidt','demolished',1933,1933,1,0,0,'Chicago','Illinois','Tribune article is about later building (Randall precise on both)'),(126,170,29,'Madison',1905,'Burnham, D.H., & Co.','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(127,172,5701,'Sheridan',1962,'Solomon and Cordwell','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(128,174,-135,'La Salle',1885,'Jenney','demolished',1931,1931,0,0,7,'Chicago','Illinois',''),(129,176,NULL,'',1853,'Hoxie',NULL,NULL,NULL,0,1,0,'Philadelphia','USA',''),(130,177,NULL,'Jackson Park (Exposition)',1893,'Jenney','demolished',1894,1894,0,0,0,'Chicago','Illinois',''),(131,178,NULL,'??',1868,'??',NULL,NULL,NULL,0,1,0,'Chicago','Illinois','No information given about location or architect'),(132,179,-800,'Halsted',1856,'??','extant',NULL,NULL,0,0,2,'Chicago','Illinois',''),(133,180,-800,'Halsted',1890,'Pond brothers','demolished',1961,1963,0,0,2,'Chicago','Illinois','10 bldgs built over 1890-1908; 1 of 10 preserved and moved a short distance. I set latedemol to 1963 because text suggests it was gone by publication'),(134,181,1355,'Sacramento',1907,'Garden','extant',NULL,NULL,0,3,0,'Chicago','Illinois',''),(135,182,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'London','foreign',''),(136,183,-337,'Madison',1908,'Eckstrom','demolished',1978,1978,1,0,0,'Chicago','Illinois',''),(137,184,1520,'Hyde Park Blvd',1888,'Starrett','demolished',1963,1963,0,0,2,'Chicago','Illinois',''),(138,185,21,'Dearborn',1886,'Burnham & Root','demolished',1933,1933,0,3,0,'Chicago','Illinois','CWC says on La Salle, without address; seems likely this is really 21 N. Dearborn, since Randall says Illinois Bank was previous name for Union Bank on Dearborn, and year and architects match'),(139,188,-640,'Irving Park',1922,'Byrne','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(140,189,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'Tokyo','foreign',''),(141,190,-30,'Monroe',1957,'Skidmore, Owings, & Merrill','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(142,191,-208,'La Salle',1885,'Burnham & Root','demolished',1912,1912,1,0,0,'Chicago','Illinois',''),(143,192,NULL,'??',1918,'Purcell & Elmslie',NULL,NULL,NULL,2,0,0,'Chicago','Illinois','No location given'),(144,193,21,'Van Buren',1893,'Jenney','demolished',2003,2013,1,0,0,'Chicago','Illinois','Randall does not give demolition date, and preservation document from 2003, a parking lot in 2013'),(145,194,NULL,'',1850,'Johnston & Walter',NULL,NULL,NULL,0,0,0,'Philadelphia','USA',''),(146,195,-15,'Wabash',1882,'Adler & Sullivan','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(147,196,NULL,'',1950,'Wright',NULL,NULL,NULL,0,0,0,'Racine','USA',''),(148,198,-405,'Lake',1903,'Hunt','demolished',1965,1990,0,0,1,'Chicago','Illinois','Evidently still standing in 1963, but gone in 2013; Randall gives demolition over 1950-1990'),(149,199,40,'Dearborn',1871,'Van Osdel','demolished',1940,1940,1,0,0,'Chicago','Illinois',''),(150,200,410,'Kenilworth',1906,'Maher','extant',NULL,NULL,1,0,0,'Kenilworth','Illinois',''),(151,201,27,'Des Plaines',1884,'Adler & Sullivan','demolished',1972,1972,0,2,0,'Chicago','Illinois',''),(152,202,-415,'Franklin',1903,'Pond brothers','demolished',1950,1953,0,0,0,'Chicago','Illinois','Demolition date from Randall'),(153,203,-551,'Monroe',1884,'Adler & Sullivan','demolished',1956,1959,0,3,0,'Chicago','Illinois','Demolition date from Randall'),(154,204,4611,'Lincoln',1922,'Sullivan','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(155,212,-111,'Jackson',1961,'Epstein & Sons','extant',NULL,NULL,0,0,0,'Chicago','Illinois','No information given about this building, only that it replaced the Phoenix'),(156,213,-37,'La Salle',1894,'Jenney & Mundie ','extant',NULL,NULL,0,0,0,'Chicago','Illinois','Little given about this building, only that it replaced the Nixon'),(157,206,NULL,'Dearborn',1887,'??','demolished',1887,1963,0,1,0,'Chicago','Illinois',NULL),(158,207,850,'Lake Shore Drive',1924,'Hunt','extant',NULL,NULL,0,0,0,'Chicago','Illinois',''),(159,208,-111,'Adams',1873,'Jenney','demolished',1926,1926,0,2,0,'Chicago','Illinois','Demolition date from Randall'),(160,209,-3001,'Michigan',1893,'Warren?','demolished',1959,1959,0,3,0,'Chicago','Illinois',''),(161,210,NULL,'Des Plaines',1903,'Perkins',NULL,NULL,NULL,0,3,0,'Chicago','Illinois',''),(162,211,NULL,'',1905,'Wright','demolished',1950,1950,0,0,0,'Buffalo','USA',''),(163,215,-200,'Monroe',1879,'Jenney','demolished',1972,1972,0,0,1,'Chicago','Illinois',''),(164,216,-401,'State',1891,'Jenney','extant',NULL,NULL,0,0,2,'Chicago','Illinois',''),(165,217,NULL,'',1855,'',NULL,NULL,NULL,0,0,0,'Philadelphia','USA',''),(166,218,180,'Wabash',1915,'Mundie, Jensen, and McClurg','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(167,223,-700,'Oakwood',1903,'Perkins; Wright','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(168,224,-225,'Fullerton',1936,'Chicago Park District; Alfred Caldwell','extant',NULL,NULL,0,5,0,'Chicago','Illinois',''),(169,225,-350,'Randolph',1852,'??','demolished',1963,1963,0,2,0,'Chicago','Illinois',''),(170,226,1315,'Forest',1908,'Tallmadge and Watson','extant',NULL,NULL,0,1,0,'Evanston','Illinois',''),(171,227,-200,'Randolph',1855,'??','demolished',1871,1871,0,2,0,'Chicago','Illinois','destroyed in fire'),(172,229,625,'Davis',1906,'Walter','demolished',1965,1969,0,2,0,'Evanston','Illinois','Described in present tense; see citation about removal'),(173,230,-7291,'St. Laurance',1914,'Drummond','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(174,231,-1104,'Wabash',1891,'Jenney','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(175,239,-218,'Wabash',1900,'Holabird & Roche ','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(176,241,-2300,'Lake Shore Drive',1960,'Shaw, Metz & Dolio','demolished',1967,1967,0,0,0,'Chicago','Illinois','burned 1967'),(177,242,NULL,'',1855,'Bogardus',NULL,NULL,NULL,0,0,0,'New York','USA',''),(178,243,NULL,'',1930,'Root','demolished',1998,1998,0,0,0,'New York','USA',''),(179,244,-25,'Madison',1885,'Adler & Sullivan','demolished',1922,1922,2,0,0,'Chicago','Illinois',''),(180,232,NULL,'',1933,'Le Corbusier','extant',NULL,NULL,0,0,0,'Geneva','foreign',''),(181,233,189,'Madison',1893,'Burnham','demolished',1961,1961,2,0,0,'Chicago','Illinois',''),(182,234,2,'Wabash',1900,'Holabird & Roche ','extant',NULL,NULL,1,0,0,'Chicago','Illinois','2 sections mentioned which appear to be 2 buildings as described by Randall'),(183,235,-431,'Dearborn',1891,'Jenney & Mundie ','extant',NULL,NULL,0,0,2,'Chicago','Illinois',''),(184,236,300,'Dearborn',1963,'Goldberg','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(185,237,-140,'Dearborn',1894,'Holabird & Roche ','extant',NULL,NULL,0,0,2,'Chicago','Illinois',''),(186,238,151,'State',1892,'Burnham & Root','demolished',1939,1939,0,0,3,'Chicago','Illinois',''),(187,245,-3401,'State',1892,'Edbrooke & Burnham','demolished',1952,1952,0,4,0,'Chicago','Illinois',''),(188,246,-176,'Jackson',1893,'Beers, Clay & Dutton','demolished',1969,1969,0,1,0,'Chicago','Illinois',''),(189,248,NULL,'',1872,'Saulnier','extant',NULL,NULL,0,2,0,'Noisiel, France','foreign',''),(190,249,-502,'Sixth',1912,'Drummond','extant',NULL,NULL,0,2,0,'Maywood','Illinois',''),(191,250,-2281,'Michigan',1891,'Warren','demolished',1994,1994,1,0,0,'Chicago','Illinois',''),(192,252,-301,'Van Buren',1893,'Adler & Sullivan','demolished',1968,1968,1,0,0,'Chicago','Illinois',''),(193,253,-2135,'Michigan',1892,'Warren','demolished',1995,1995,1,0,0,'Chicago','Illinois',''),(194,254,535,'Michigan',1963,'Raggie & Malitz','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(195,255,-6000,'Cottage Grove',1914,'Wright','demolished',1929,1929,0,0,0,'Chicago','Illinois',''),(196,256,220,'Montgomery',1882,'Burnham & Root','extant',NULL,NULL,0,0,0,'San Francisco','USA',''),(197,258,-53,'Jackson',1891,'Burnham & Root','extant',NULL,NULL,0,0,4,'Chicago','Illinois',''),(198,259,-332,'Dearborn',1893,'Holabird & Roche ','extant',NULL,NULL,2,0,0,'Chicago','Illinois',''),(199,262,-64,'Monroe',1882,'Burnham & Root','demolished',1902,1902,0,0,5,'Chicago','Illinois',''),(200,263,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'Virginia','USA',''),(201,264,810,'La Salle',1876,'Sullivan','demolished',1939,1939,2,0,0,'Chicago','Illinois','Sullivan did interior design; building not described'),(202,265,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'Salt Lake City','USA',''),(203,268,-538,'Dearborn',1896,'Jenney & Mundie ','extant',NULL,NULL,0,3,0,'Chicago','Illinois',''),(204,269,-1800,'Michigan',1889,'??','demolished',1889,1963,0,1,0,'Chicago','Illinois','Described in present tense but no address so I cannot confirm present status'),(205,270,-200,'Jackson',1912,'??','demolished',1965,1968,0,1,0,'Chicago','Illinois','present tense used but questionable; Emporis says current building started in 1968'),(206,271,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'Virginia','USA',''),(207,272,-1400,'Lake Shore Drive',1911,'Graham, Anderson, Probst, & White','extant',NULL,NULL,0,0,0,'Chicago','Illinois',''),(208,275,-60,'Walton',1892,'Cobb','extant',NULL,NULL,0,1,0,'Chicago','Illinois','Info. from Randall'),(209,21,900,'Michigan',1927,'Hunt','demolished',1984,1984,0,0,0,'Chicago','Illinois','Info. from Randall'),(210,276,-128,'Monroe',1871,'Matz','demolished',1889,1889,1,0,0,'Chicago','Illinois',''),(211,277,2145,'Sheridan',1941,'Holabird & Root','extant',NULL,NULL,0,0,0,'Evanston','Illinois',''),(212,278,-407,'Dearborn',1894,'Holabird & Roche ','extant',NULL,NULL,0,0,2,'Chicago','Illinois',''),(213,279,NULL,'??',1893,'Pond brothers','demolished',1893,1963,0,4,0,'Chicago','Illinois','Described in past tense'),(214,5,1,'La Salle',1930,'Vitzhum & Burns','extant',NULL,NULL,0,0,0,'Chicago','Illinois','Info. from Randall'),(215,2,-120,'La Salle',1928,'Graham, Anderson, Probst, & White','extant',NULL,NULL,0,0,0,'Chicago','Illinois','Info. from Randall'),(216,281,1,'Monroe',1875,'Van Osdel','demolished',1925,1925,0,1,0,'Chicago','Illinois',''),(217,283,919,'Michigan',1929,'Holabird & Root','extant',NULL,NULL,0,1,0,'Chicago','Illinois','Info. from Randall'),(218,285,NULL,'Fifty-ninth',1892,'Flanders & Zimmerman','demolished',1910,1963,0,3,0,'Chicago','Illinois','Described in past tense, only evidence of when it was demolished'),(219,284,-3100,'Cottage Grove',1889,'??','demolished',1889,1963,0,0,0,'Chicago','Illinois','Described in past tense'),(220,287,NULL,'',NULL,'','extant',NULL,NULL,0,0,0,'Athens, Greece','foreign',''),(221,288,2145,'Sheridan',1909,'Maher','demolished',1940,1940,1,0,0,'Evanston','Illinois',''),(222,289,NULL,'??',1902,'Maher',NULL,NULL,NULL,0,0,0,'Evanston','Illinois',''),(223,290,NULL,'',1862,'Johnson, George A.',NULL,NULL,NULL,0,1,0,'Philadelphia','USA',''),(224,292,-200,'Adams',1882,'Burling & Whitehouse','demolished',1965,1985,1,0,0,'Chicago','Illinois','evidently still standing in 1963; Randall gives demolition < 1985'),(225,294,NULL,'Michigan',1887,'Burnham & Root','demolished',1887,1963,0,1,0,'Chicago','Illinois',NULL),(226,295,-5514,'University',1960,'Weese','demolished',2013,2013,0,1,0,'Chicago','Illinois','demolition to start 19 Aug 2013!'),(227,296,1553,'Clark',1892,'Warren','demolished',1965,1965,1,0,0,'Chicago','Illinois','Demolition date from Randall'),(228,298,-542,'Dearborn',1891,'Holabird & Roche ','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(229,299,33,'Dearborn',1872,'Jenney','demolished',1933,1933,1,0,0,'Chicago','Illinois',''),(230,300,-50,'Monroe',1855,'Van Osdel','demolished',1871,1871,0,2,0,'Chicago','Illinois','Address, destruction from Randall'),(231,302,-5530,'Lake Shore Drive',1949,'Mies van der Rohe','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(232,303,130,'Randolph',1955,'Naess & Murphy','extant',NULL,NULL,0,1,0,'Chicago','Illinois','Info. from Randall'),(233,305,78,'Washington',1897,'Shepley, Rutan & Coolidge','extant',NULL,NULL,0,1,0,'Chicago','Illinois','Info. from Randall'),(234,306,-200,'Michigan',1885,'Beman','demolished',1950,1950,0,0,0,'Chicago','Illinois',''),(235,307,80,'Jackson',1904,'Burnham, D.H., & Co.','extant',NULL,NULL,0,0,1,'Chicago','Illinois',''),(236,308,-160,'Adams',1890,'Burnham & Root','demolished',1911,1911,0,0,2,'Chicago','Illinois',''),(237,310,-2889,'Ellis',1906,'Schmidt','demolished',2010,2010,2,0,0,'Chicago','Illinois',''),(238,312,325,'La Salle',1913,'Nimmons & Fellows','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(239,311,-2013,'Prarie',1894,'Beers, Clay & Dutton','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(240,313,32,'State',1895,'Atwood','extant',NULL,NULL,0,0,2,'Chicago','Illinois',''),(241,314,-209,'State',1905,'Holabird & Roche ','demolished',1961,1961,0,0,1,'Chicago','Illinois',''),(242,315,50,'Adams',1883,'Sullivan','demolished',1968,1968,0,5,0,'Chicago','Illinois',''),(243,316,-5757,'Woodlawn',1908,'Wright','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(244,317,-201,'La Salle',1886,'Burnham & Root','extant',NULL,NULL,0,0,2,'Chicago','Illinois',''),(245,318,-743,'Washington',1882,'Adler & Sullivan','demolished',1958,1958,0,1,0,'Chicago','Illinois',''),(246,319,-210,'Monroe',1881,'Sullivan','demolished',1972,1972,0,0,1,'Chicago','Illinois',''),(247,320,16,'Randolph',1884,'Sullivan','demolished',1939,1939,0,3,0,'Chicago','Illinois',''),(248,339,NULL,'',NULL,'',NULL,NULL,NULL,0,0,0,'Liverpool','foreign',''),(249,340,-4950,'Thomas',1903,'Schmidt','extant',NULL,NULL,0,1,0,'Chicago','Illinois','Finally found old drawing and discussion confirming current residence hall is the original hospital, though with changes'),(250,344,200,'State',1833,'Taylor','demolished',1833,1871,0,1,0,'Chicago','Illinois','Approx. address from Randall; no destruction given, but presumably gone in fire or earlier'),(251,345,-901,'Wabash',1868,'Randall','demolished',1970,1970,0,1,0,'Chicago','Illinois','Info. from Randall'),(252,346,-2044,'Grenshaw',1924,'Byrne','demolished',1977,1977,0,0,0,'Chicago','Illinois','Now empty lot U of I campus'),(253,348,NULL,'',1866,'Fontaine',NULL,NULL,NULL,0,0,0,'Paris','foreign',''),(254,349,-5472,'Kimbark',1924,'Byrne','extant',NULL,NULL,0,0,0,'Chicago','Illinois',''),(255,324,-500,'Eighteenth',1902,'Schmidt','extant',NULL,NULL,2,0,0,'Chicago','Illinois',''),(256,325,3601,'Milwaukee',1908,'Perkins','extant',NULL,NULL,0,0,1,'Chicago','Illinois',''),(257,326,-619,'Washington',1885,'Adler & Sullivan','demolished',1970,1974,0,1,0,'Chicago','Illinois','demolition date from Randall in “early 1970s”'),(258,327,542,'Abbotsford',1912,'Maher','extant',NULL,NULL,1,0,0,'Kenilworth','Illinois','Must be same building standing, but description not a sure match'),(259,328,-924,'Homan',1906,'Nimmons & Fellows','demolished',1978,1978,0,0,1,'Chicago','Illinois','main building demolished but tower preserved, standing alone in a field and under renovation in Google photo'),(260,330,1616,'Wells',1961,'Goldstein','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(261,331,NULL,'Superior',1887,'Adler & Sullivan',NULL,NULL,NULL,0,4,0,'Chicago','Illinois','Described in present tense, but in footnote and no address given; very unlikely this Adler-Sullivan still stands'),(262,19,7415,'Sheridan',1915,'Wright','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(263,332,505,'Michigan',1929,'Alschlager','extant',NULL,NULL,0,1,0,'Chicago','Illinois','Info. from Randall'),(264,333,310,'Church',1911,'Maher','extant',NULL,NULL,1,0,0,'Evanston','Illinois',''),(265,334,NULL,'',1877,'McLaughlin',NULL,NULL,NULL,0,2,0,'Cincinnati','USA',''),(266,335,315,'Clark',1883,'Edbrooke','demolished',1980,1989,1,0,0,'Chicago','Illinois','Demolition date from Randall as “1980s”'),(267,17,608,'Davis',1910,'Tallmadge and Watson','extant',NULL,NULL,0,4,0,'Evanston','Illinois','facade substantially changed'),(268,337,-416,'Franklin',1912,'Graham, Burnham, and Co.','demolished',1965,1990,0,3,0,'Chicago','Illinois','seems it was standing at writing in 1964; Randall gives demolition over 1950-1990'),(269,338,-2400,'Michigan',1888,'Sullivan','demolished',1910,1910,1,0,0,'Chicago','Illinois',''),(270,343,64,'Van Buren',1896,'Perkins','demolished',1965,1969,0,3,0,'Chicago','Illinois','evidently still standing in 1963; Randall gives demolition in 1960s'),(271,347,30,'La Salle',1894,'Sullivan','demolished',1972,1972,0,0,2,'Chicago','Illinois','Demolition date from Randall'),(272,350,-629,'Wabash',1895,'Beman','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(273,351,NULL,'',1929,'Pond brothers',NULL,NULL,NULL,0,0,0,'West Lafayette, Indiana','USA',''),(274,352,NULL,'',1917,'Pond brothers',NULL,NULL,NULL,0,0,0,'Ann Arbor, Michigan','USA',''),(275,354,2029,'Sheridan',1909,'Maher','extant',NULL,NULL,0,0,1,'Evanston','Illinois',''),(276,355,1,'La Salle',1889,'Holabird & Roche ','demolished',1929,1929,0,0,2,'Chicago','Illinois',''),(277,1,1014,'Davis',1905,'Blake','demolished',1965,1969,0,1,0,'Chicago','Illinois','Described in present tense; see citation about removal'),(278,14,-320,'Frankin',1898,'Holabird & Roche ','demolished',1950,1963,0,1,0,'Chicago','Illinois','Destroyed by 1963; Randall gives 1950-1990'),(279,15,-325,'Jackson',1904,'Holabird & Roche ','demolished',1965,1990,0,1,0,'Chicago','Illinois','Demolition date from Randall'),(280,13,-3200,'Prarie',1882,'Adler & Sullivan','demolished',1882,1963,0,1,0,'Chicago','Illinois','Described in past tense'),(281,356,111,'Franklin',1908,'Pond brothers','demolished',1967,1967,1,0,0,'Chicago','Illinois','Demolition date from Randall'),(282,358,-6200,'Stoney Island',1893,'Sullivan','demolished',1894,1895,2,0,0,'Chicago','Illinois','Fair buildings were temporary, but I can\'t find a demolition date'),(283,360,435,'Michigan',1925,'Howells & Hood','extant',NULL,NULL,0,0,0,'Chicago','Illinois','Only a comment about ridicule from Sullivan'),(284,361,-15,'Wacker',1884,'Adler & Sullivan','demolished',1978,1978,1,0,0,'Chicago','Illinois',''),(285,362,5200,'Ashland',1909,'Perkins','extant',NULL,NULL,1,0,0,'Chicago','Illinois',''),(286,10,NULL,'',1852,'Button',NULL,NULL,NULL,0,1,0,'Philadelphia','USA',''),(287,363,155,'Clark',1949,'??','demolished',1985,1985,0,0,0,'Chicago','Illinois','appears to have been replaced by Thompson Center'),(288,366,1300,'Chicago',1904,'Mahoney','demolished',1960,1960,1,0,0,'Evanston','Illinois','architect a woman!'),(289,367,NULL,'',1860,'Johnson, George A.',NULL,NULL,NULL,0,3,0,'Brooklyn','USA',''),(290,368,127,'Dearborn',1892,'Warren','demolished',1990,1990,1,0,0,'Chicago','Illinois','Demolition date from Randall as ca. 1990'),(291,369,875,'Lake',1906,'Wright','extant',NULL,NULL,0,1,0,'Oak Park','Illinois',''),(292,370,1604,'Chicago',1906,'Maher','extant',NULL,NULL,1,0,0,'Evanston','Illinois',''),(293,371,1450,'Fifty-fifth',1961,'Pei and Weese','extant',NULL,NULL,0,4,0,'Chicago','Illinois','Not enough information to locate; perhaps pair of large condos'),(294,372,NULL,'',1931,'van der Vlugt','extant',NULL,NULL,0,0,0,'Netherlands','foreign',''),(295,373,69,'Illinois',1893,'Adler & Sullivan','demolished',1961,1961,2,0,0,'Chicago Heights','Illinois',''),(296,374,600,'Rush',1890,'Warren','demolished',1929,1929,2,0,0,'Chicago','Illinois','No exact address; Ohio and Rush corner'),(297,375,709,'Chestnut',1891,'Adler & Sullivan','extant',NULL,NULL,0,0,2,'St. Louis','USA',''),(298,376,-210,'Wacker',1889,'Adler & Sullivan','demolished',1953,1953,1,0,0,'Chicago','Illinois',''),(299,377,14,'Michigan',1885,'Beers, Clay & Dutton','extant',NULL,NULL,0,1,0,'Chicago','Illinois',''),(300,378,758,'Larrabee',1929,'Schmidt, Garden, & Martin','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(301,379,6,'Michigan',1899,'Schmidt','extant',NULL,NULL,0,4,0,'Chicago','Illinois',''),(302,380,-618,'Chicago',1908,'Schmidt, Garden, & Martin','extant',NULL,NULL,2,0,0,'Chicago','Illinois',''),(303,381,806,'Michigan',1869,'Boyington','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(304,382,800,'Michigan',1961,'Hausner and Macsai','demolished',1997,1997,0,2,0,'Chicago','Illinois',''),(305,385,-205,'Monroe',1898,'Holabird & Roche ','extant',NULL,NULL,0,2,0,'Chicago','Illinois',''),(306,386,-234,'Franklin',1887,'Buffington','demolished',1964,1964,1,0,0,'Chicago','Illinois',''),(307,387,-1255,'Michigan',1904,'Rogers','demolished',1999,2013,0,4,0,'Chicago','Illinois','Not there now, but Randall suggests it was as of 1999'),(308,388,621,'Davis',1906,'Edbrooke','demolished',1965,1969,0,2,0,'Evanston','Illinois','Described in present tense; see citation about removal'),(309,389,-102,'La Salle',1892,'Burnham & Root','demolished',1926,1926,2,0,0,'Chicago','Illinois',''),(310,390,NULL,'',1917,'Elmslie',NULL,NULL,NULL,0,0,0,'Sioux City','USA',''),(311,391,-50,'Randolph',1917,'Marshall & Fox','demolished',1989,1989,0,0,0,'Chicago','Illinois','Info. from Randall'),(312,392,NULL,'',1913,'Gilbert','extant',NULL,NULL,0,1,0,'New York','USA',''),(313,393,-225,'Wacker',1893,'Flanders & Zimmerman','demolished',1968,1968,1,0,0,'Chicago','Illinois','Yondorf built in 1874; the relevant part was an extension of 1893');
/*!40000 ALTER TABLE `building` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `cite`
--

DROP TABLE IF EXISTS `cite`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `cite` (
  `citeID` int(11) NOT NULL AUTO_INCREMENT,
  `bldgID` int(11) DEFAULT NULL,
  `citation` varchar(250) DEFAULT NULL,
  PRIMARY KEY (`citeID`)
) ENGINE=MyISAM AUTO_INCREMENT=73 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `cite`
--

LOCK TABLES `cite` WRITE;
/*!40000 ALTER TABLE `cite` DISABLE KEYS */;
INSERT INTO `cite` VALUES (1,4,'Oschner 1985'),(2,10,'p 259 Randall'),(3,28,'http://www.chicagoarchitecture.info/Building/1130/Borg-Warner-Building.php'),(4,34,'http://www.chicagolife.net/content/art/The_Great_Gallery_Fire'),(5,45,'http://en.wikipedia.org/wiki/19_South_LaSalle_Street'),(6,46,'http://www.gsa.gov/portal/ext/html/site/hb/category/25431/actionParameter/exploreByBuilding/buildingId/1204'),(7,49,'http://designslinger.com/2011/01/20/champlain-building.aspx'),(8,54,'http://en.wikipedia.org/wiki/Chicago_Beach_Hotel'),(9,55,'http://digital-libraries.saic.edu/cdm/search/collection/mqc/searchterm/Adams-Wabash%20Building/mode/exact'),(10,61,'http://www.emporis.com/building/sullivan-center-east-annex-chicago-il-usa'),(11,69,'http://en.wikipedia.org/wiki/Coonley_House'),(12,70,'http://en.wikipedia.org/wiki/The_Avery_Coonley_School#Founding_and_Cottage_School_.281906.E2.80.931916.29'),(13,71,'http://en.wikipedia.org/wiki/Cooper_Union'),(14,74,'http://www.chicagoarchitecture.info/Building/2340/Crane-Company-Building.php'),(15,75,'http://www.lib.uchicago.edu/e/crerar/corpmem/pdf/Crerar%20L.pdf'),(16,75,'http://www.emporis.com/building/johncrerarlibrary-chicago-il-usa'),(17,82,'http://en.wikipedia.org/wiki/Dexter_Building'),(18,83,'http://www.chicagoarchitecture.info/Building/3087/Dixon-Building.php'),(19,85,'http://www.loc.gov/pictures/item/il0111/'),(20,87,'http://en.wikipedia.org/wiki/860%E2%80%93880_Lake_Shore_Drive_Apartments'),(21,89,'http://en.wikipedia.org/wiki/E-Z_Polish_Factory'),(22,90,'tigger.uic.edu/depts/ahaa/imagebase/intranet/chiviews/1984'),(23,91,'Frank Alfred and John Randall 1999'),(24,92,'http://tigger.uic.edu/depts/ahaa/imagebase/intranet/chiviews/page187.html'),(25,92,'http://www.encyclopedia.chicagohistory.org/pages/2660.html'),(26,94,'http://www.artic.edu/aic/resources/resource/2054?search_id=1&index=0'),(27,106,'Richard Cahan 1994'),(28,112,'http://www.loc.gov/pictures/item/il0104/'),(29,119,'http://dimbeautyofchicago.blogspot.com/2010/01/grommes-and-ullrich.html'),(30,121,'http://www.loc.gov/pictures/item/il0115/'),(31,124,'http://en.wikipedia.org/wiki/Healy_Chapel'),(32,125,'http://articles.chicagotribune.com/1986-10-02/news/8603140315_1_fourth-hospital-general-community-hospital-facility'),(33,134,'http://www.bauerlatozastudio.com/portfolio/historic-preservation/humboldt-park-boat-house/'),(34,136,'Frank A. and John Randall 1999, p. 269'),(35,141,'http://www.emporis.com/building/inlandsteelbuilding-chicago-il-usa'),(36,144,'http://www.preservationchicago.org/userfiles/file/2004-Chicago-7-Isabella-Building.pdf'),(37,151,'Randall & Randall, 1999, The History of Development of Building Construction in Chicago, p. 109'),(38,153,'http://digital-libraries.saic.edu/cdm/singleitem/collection/mqc/id/28933/rec/33'),(39,155,'http://www.emporis.com/building/transunionbuilding-chicago-il-usa'),(40,156,'http://www.emporis.com/building/lasallemonroebuilding-chicago-il-usa'),(41,158,'http://www.chicagoarchitecture.info/Building/3106/Lake-Shore-Athletic-Club.php'),(42,159,'http://www.davidrumsey.com/maps3374.html'),(43,160,'http://forgottenchicago.com/forum/5/3593/lewis_memorial_maternity_hospital'),(44,167,'http://www.thefranklloydwrighttour.com/apps/blog/show/5620904-abraham-lincoln-center-frank-lloyd-wright-dwight-perkins-1905'),(45,171,'J.W. Sheahan (1871) The great conflagration...Chicago'),(46,187,'http://www.wbez.org/blogs/lee-bey/2012-06/storied-mecca-apartments-live-again-thanks-life-magazine-archives-100301'),(47,189,'http://en.wikipedia.org/wiki/Menier_Chocolate'),(48,189,'http://www.greatbuildings.com/buildings/Menier_Factory.html'),(49,190,'http://www.flickr.com/photos/chicagogeek/sets/72157632852890837/detail/'),(50,193,'http://www.encyclopedia.chicagohistory.org/pages/738.html'),(51,195,'http://en.wikipedia.org/wiki/Midway_Gardens'),(52,211,'http://en.wikipedia.org/wiki/Northwestern_Technological_Institute'),(53,226,'http://chicagomaroon.com/2013/07/25/old-pierce-versus-new-hall/'),(54,234,'http://www.chicagoarchitecture.info/Building/1130/Borg-Warner-Building.php'),(55,239,'http://en.wikipedia.org/wiki/Reid_House_(Chicago,_Illinois)'),(56,252,'http://www.illinoishsglorydays.com/id791.html'),(57,259,'http://www.loc.gov/pictures/item/il0737/'),(58,259,'http://www.homansquare.org/sears-roebuck-and-co'),(59,261,'http://digital-libraries.saic.edu/cdm/singleitem/collection/mqc/id/14592/rec/122'),(60,268,'http://www.emporis.com/building/societybrandbuilding-chicago-il-usa'),(61,268,'Sally Chappell 1992'),(62,293,'http://tours.architecture.org/ppt/Weese_master.pdf'),(63,304,'http://www.flickr.com/photos/mss2400/5632776639/'),(64,35,'http://en.wikipedia.org/wiki/George_Westinghouse_College_Prep'),(65,35,'https://www.flickr.com/photos/jerkinhead/2405836017/in/photostream/'),(66,172,'http://www.designevanston.org/documents/downtownevanstonrevitalized07.pdf'),(67,277,'http://www.designevanston.org/documents/downtownevanstonrevitalized07.pdf'),(68,308,'http://www.designevanston.org/documents/downtownevanstonrevitalized07.pdf'),(69,218,'http://chuckmancollectionvolume11.blogspot.com/2011/01/postcard-chicago-park-gate-hotel-63rd.html'),(70,8,'http://en.wikipedia.org/wiki/Pilgrim_Baptist_Church'),(71,249,'http://www.prairieschooltraveler.com/notes/2009/0901notes.html'),(72,205,'http://www.emporis.com/building/200westjackson-chicago-il-usa');
/*!40000 ALTER TABLE `cite` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `figure`
--

DROP TABLE IF EXISTS `figure`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `figure` (
  `figureID` int(11) NOT NULL AUTO_INCREMENT,
  `bldgID` int(11) DEFAULT NULL,
  `figure` int(11) DEFAULT NULL,
  PRIMARY KEY (`figureID`)
) ENGINE=MyISAM AUTO_INCREMENT=194 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `figure`
--

LOCK TABLES `figure` WRITE;
/*!40000 ALTER TABLE `figure` DISABLE KEYS */;
INSERT INTO `figure` VALUES (1,210,3),(2,44,4),(3,113,5),(4,246,6),(5,146,7),(6,242,8),(7,242,9),(8,179,10),(9,82,12),(10,269,13),(11,298,14),(12,199,15),(13,266,16),(14,81,17),(15,60,18),(16,115,19),(17,97,20),(18,244,21),(19,244,22),(20,244,23),(21,244,24),(22,244,25),(23,244,26),(24,244,27),(25,197,28),(26,197,29),(27,197,30),(28,13,31),(29,13,32),(30,13,33),(31,13,34),(32,13,35),(33,13,36),(34,13,37),(35,13,38),(36,13,39),(37,163,40),(38,163,41),(39,284,42),(40,306,43),(41,128,44),(42,128,45),(43,47,46),(44,47,47),(45,164,48),(46,90,49),(47,90,50),(48,90,51),(49,183,52),(50,183,53),(51,183,54),(52,290,55),(53,174,56),(54,203,57),(55,142,58),(56,236,58),(57,236,59),(58,117,60),(59,118,60),(60,12,61),(61,12,62),(62,309,63),(63,186,64),(64,186,65),(65,113,65),(66,181,66),(67,240,67),(68,103,68),(69,235,69),(70,276,70),(71,43,71),(72,198,72),(73,228,73),(74,185,74),(75,185,75),(76,212,76),(77,212,77),(78,212,78),(79,212,79),(80,107,80),(81,108,80),(82,109,80),(83,107,81),(84,108,81),(85,109,81),(86,305,82),(87,36,83),(88,36,84),(89,175,85),(90,297,86),(91,113,87),(92,113,88),(93,113,89),(94,113,90),(95,295,91),(96,192,92),(97,282,93),(98,282,94),(99,271,95),(100,271,96),(101,271,97),(102,271,98),(103,271,99),(104,120,100),(105,272,105),(106,272,106),(107,224,107),(108,313,108),(109,137,109),(110,137,110),(111,137,111),(112,296,112),(113,191,113),(114,193,114),(115,227,115),(116,67,116),(117,67,117),(118,160,118),(119,32,119),(120,32,120),(121,32,121),(122,105,122),(123,39,123),(124,39,124),(125,39,125),(126,39,126),(127,39,127),(128,39,128),(129,39,129),(130,154,130),(131,49,131),(132,17,132),(133,279,133),(134,29,134),(135,53,135),(136,241,136),(137,241,137),(138,182,138),(139,33,139),(140,136,140),(141,55,141),(142,268,142),(143,166,143),(144,238,144),(145,85,145),(146,143,146),(147,172,147),(148,50,148),(149,255,149),(150,237,150),(151,302,151),(152,302,152),(153,134,153),(154,84,154),(155,35,155),(156,150,156),(157,292,157),(158,221,158),(159,221,159),(160,275,160),(161,264,161),(162,258,162),(163,64,163),(164,285,164),(165,256,165),(166,256,166),(167,139,167),(168,139,168),(169,281,169),(170,133,170),(171,170,171),(172,267,172),(173,66,173),(174,173,174),(175,288,175),(176,42,176),(177,65,177),(178,65,178),(179,21,180),(180,100,181),(181,40,184),(182,110,185),(183,40,185),(184,168,186),(185,168,187),(186,2,189),(187,76,190),(188,231,191),(189,141,192),(190,123,193),(191,68,194),(192,62,195),(193,226,196);
/*!40000 ALTER TABLE `figure` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `indexentry`
--

DROP TABLE IF EXISTS `indexentry`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `indexentry` (
  `indexID` int(11) NOT NULL AUTO_INCREMENT,
  `entry` varchar(55) DEFAULT NULL,
  `page` int(11) DEFAULT NULL,
  `bldgID` int(11) DEFAULT NULL,
  `nameID` int(11) DEFAULT NULL,
  `comment` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`indexID`)
) ENGINE=MyISAM AUTO_INCREMENT=374 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `indexentry`
--

LOCK TABLES `indexentry` WRITE;
/*!40000 ALTER TABLE `indexentry` DISABLE KEYS */;
INSERT INTO `indexentry` VALUES (1,'Adams and Wabash',NULL,55,22,''),(2,'Alexandria Hotel',156,1,23,'Randall gives demolition over 1950-1990'),(3,'Alumni Memorial Hall (IIT)',218,2,24,''),(4,'Ambassador Hotel',194,3,25,''),(5,'American Express Company',22,4,27,''),(6,'American National Bank',87,5,28,'Info. from Randall'),(7,'American Tract Society',140,6,29,''),(8,'American Trust and Savings Bank',189,7,30,'Info. from Randall'),(9,'Anshe Ma\'ariv Synagogue',208,8,31,''),(10,'apartments, Hinman Avenue and Lee Street, Evanston',159,9,394,''),(11,'Argyle Apartments',101,10,33,''),(12,'Art Institute',96,11,34,''),(13,'Ashland',102,12,35,''),(14,'Auditorium',69,13,37,''),(15,'Austin',57,14,38,''),(16,'Babson Farm',184,15,39,''),(17,'Babson House',183,16,40,''),(18,'Bailey',174,17,41,''),(19,'Baker Factory, Cornelius',39,18,395,''),(20,'Bauer and Black',175,19,43,''),(21,'Bauhaus',147,NULL,NULL,'not a building: comment about the school'),(22,'Bayard',130,20,44,''),(23,'Berbach House',211,21,45,''),(24,'Bibliotheque National',87,22,46,''),(25,'Board of Trade 1',137,23,47,''),(26,'Board of Trade 2',177,24,48,''),(27,'Boat Store, Sheerness',67,25,49,''),(28,'Bordeaux Apartments',156,26,50,''),(29,'Borden Block',37,27,51,''),(30,'Borg-Warner',43,28,52,''),(31,'Born',174,29,53,''),(32,'Boston Store',174,30,54,''),(33,'Bradley House',183,31,55,''),(34,'Brewster Apartments',157,32,56,''),(35,'Brooks',176,33,57,''),(36,'Brunswick',NULL,272,58,''),(37,'Brunswick and Balke Factory',42,34,59,'Burned in 1989'),(38,'Bunte Brothers Candy Company',194,35,60,'address is parking lot'),(39,'Cable',125,36,61,''),(40,'Calico Mill',6,37,62,''),(41,'Calumet',57,38,63,''),(42,'Capitol',NULL,186,64,''),(43,'Carson Pirie Scott Store',162,39,67,''),(44,'Carson Pirie Scott Annex',213,40,65,''),(45,'Carson Pirie Scott Wholesale Store',162,41,68,'Demolition date from Randall'),(46,'Carter House',210,42,69,''),(47,'Caxton',118,43,70,''),(48,'Centenniel Exposition Tower',67,NULL,NULL,'not a building: Never built'),(49,'Central Music Hall',31,44,71,''),(50,'Central YMCA',93,45,72,''),(51,'Century',177,46,73,''),(52,'Chamber of Commerce',87,47,74,''),(53,'Champlain, first',124,48,75,''),(54,'Champlain, second',174,49,76,''),(55,'Chapin and Gore',187,50,77,''),(56,'Charleston, SC',NULL,NULL,NULL,'Not a building'),(57,'Chemical Works',204,51,78,''),(58,'Chestnut Street Theater',NULL,52,79,''),(59,'Chicago Building',175,53,81,''),(60,'Chicago, University of',60,NULL,NULL,'not a building: the first group of buildings by Cobb, none specified'),(61,'Chicago Beach Hotel',156,54,80,'architects not known with certainty; online sites suggest this was demolished in the late 1940s, but CWC says still standing in 1963'),(62,'Chicago Business College',178,55,82,''),(63,'Chicago Club',56,56,83,''),(64,'Chicago Cold Storage Exchange',135,57,84,''),(65,'Chicago Garment Center',94,58,85,'Info. from Randall'),(66,'Chicago Herald',137,59,86,'Info. from Randall'),(67,'Chicago Joint Board',NULL,284,87,''),(68,'Chicago Journal',NULL,284,88,''),(69,'Chicago Opera House',59,60,89,''),(70,'Church, Thomas Building',213,61,396,''),(71,'Civic Center',219,62,94,''),(72,'Civic Opera',75,63,95,''),(73,'Cleveland, Grover Elementary School',201,64,397,''),(74,'Columbus Park Boathouse',211,NULL,NULL,'Not a building: design never built'),(75,'Comstock Houses',210,65,98,''),(76,'Condict',NULL,20,99,''),(77,'Congregational, First Church of Austin',209,66,398,''),(78,'Congress Hotel',154,67,101,''),(79,'Continental Bank',NULL,142,102,''),(80,'Continental Center',219,68,103,''),(81,'Coonley house',184,69,106,''),(82,'Coonley, Avery, Kindergarten',203,70,399,''),(83,'Cooper Union',20,71,107,''),(84,'Counselman',57,72,108,''),(85,'Crane, first',166,73,109,''),(86,'Crane, second',177,74,110,''),(87,'Crerar Library',96,75,111,''),(88,'Crown',NULL,175,112,''),(89,'Crown Hall',218,76,113,''),(90,'Crystal Palace, London',NULL,77,114,''),(91,'Crystal Palace, New York',NULL,78,115,''),(92,'Daily News, Chicago',177,79,400,'Info. from Randall, though Randall has architects Holabird & Roche, appearing to be a typo'),(93,'Daily News, New York',192,80,117,''),(94,'Decker, Alfred and Cohn',NULL,268,119,''),(95,'Dexter',58,81,120,''),(96,'Dexter, Wirt',41,82,401,'Burned accidently in 2006'),(97,'Dixon, Arthur',180,83,402,''),(98,'Dwight',194,84,124,''),(99,'Edison',183,85,125,'Demolition date from Randall'),(100,'Eiffel Tower',NULL,86,127,''),(101,'860-880 North Lake Shore Drive',214,87,20,''),(102,'Equitable',NULL,149,128,''),(103,'Esquire Theater',129,88,129,''),(104,'E-Z Polish Company Factory',192,89,130,''),(105,'factories, built by Boulton and Watt',6,NULL,NULL,'Not a building; several factories at unspecified locations'),(106,'Fair Store',NULL,90,131,''),(107,'Farwell, Charles B., Store',21,91,403,''),(108,'Farwell, J.V., warehouse',24,92,404,'An earlier Farwell block is in one diagram; info. from Randall'),(109,'Federal Office',59,93,134,''),(110,'Felsenthal Store',166,94,135,''),(111,'Field',214,95,136,''),(112,'Field, Marshall, Store',178,96,405,''),(113,'Field, Marshall, Wholesale Store',60,97,406,''),(114,'Field and Leiter Store',89,98,137,'3 STORES OCCUPIED THIS SITE PRIOR TO THE LAST; FIRST 2 BURNED'),(115,'Field and Leiter Wholesale Store',61,99,138,''),(116,'Field Museum',NULL,207,141,''),(117,'5730 Sheridan Road house',211,100,16,''),(118,'Fine Arts, World\'s Columbian Exposition',96,101,407,'Reconstructed in 1932'),(119,'First National Bank',112,102,143,''),(120,'Fisher',113,103,144,''),(121,'Flatiron',108,104,145,''),(122,'Florida Southern College',197,NULL,NULL,'Not a building: campus plan by Wright'),(123,'Francis Apartments',158,105,148,''),(124,'Frankenthal',42,106,149,''),(125,'Gage',141,107,NULL,'3 GAGE BLDS APPEAR AS 1 ENTRY IN INDEX'),(126,'garage, Monroe Street',213,110,408,'Former garage was merged with the Carson Pirie Scott Annex in 1950'),(127,'Garden City Plating and Manufacturing Company factory',194,111,154,'CAN\'T FIND; NO TALLMADGE NOR TALMADGE IN CHICAGO'),(128,'Garden City Warehouse',58,112,155,'Info. from Randall'),(129,'Garrick Theater',128,113,156,''),(130,'Geneva Apartments',149,114,157,''),(131,'Glessner House',60,115,158,''),(132,'Graham Paper Company',NULL,148,159,''),(133,'Great Lakes',177,116,160,'I asked at artefaqs.com and got a reply saying yes, the current structure at the site is the Great Lakes Bldg'),(134,'Great Northern Hotel',101,117,161,''),(135,'Great Northern Theater',109,118,162,''),(136,'Grommes and Ulrich Company Warehouse',187,119,163,''),(137,'Guaranty',138,120,164,''),(138,'Hammond Library',42,121,165,''),(139,'Harper and Brothers',20,122,166,''),(140,'Hartford Fire Insurance',218,123,167,''),(141,'Healy Chapel',185,124,168,''),(142,'Henrotin Hospital',191,125,169,'Tribune article is about later building (Randall precise on both)'),(143,'Heyworth',114,126,170,''),(144,'Hollywood Towers',219,127,172,''),(145,'Home Federal Savings and Loan',175,241,173,''),(146,'Home Insurance',80,128,174,''),(147,'Hoops',NULL,36,175,''),(148,'Horstman. William H. and Sons factory',39,129,176,''),(149,'Horticultural, World Columbian Exposition',29,130,409,''),(150,'Horton house',23,131,178,'No information given about location or architect'),(151,'Hull, Charles, house',206,132,410,''),(152,'Hull House group',206,133,180,'10 bldgs built over 1890-1908; 1 of 10 preserved and moved a short distance'),(153,'Humboldt Park boathouse',193,134,181,''),(154,'Hungerford Fish Market',67,135,182,''),(155,'Hunter',177,136,183,''),(156,'Hyde Park Hotel',150,137,184,''),(157,'Illinois Bank',57,138,185,'CWC says on La Salle, without address; seems likely this is really 21 N. Dearborn, since Randall says Illinois Bank was previous name for Union Bank on Dearborn, and year and architects match'),(158,'Illinois Institute of Technology',218,NULL,NULL,'not a building: general reference to the overall campus designs'),(159,'Immaculata High School',204,139,188,''),(160,'Imperial Hotel',210,140,189,''),(161,'Inland Steel',218,141,190,''),(162,'Insurance Exchange',57,142,191,''),(163,'International Leather and Belting Company factory',184,143,192,'No location given'),(164,'Isabella',93,144,193,'Randall does not give demolition date, and preservation document from 2003, a parking lot in 2013'),(165,'Jayne',38,145,194,''),(166,'Jeweler\'s',39,146,195,''),(167,'Johnson, S.C., and Company research tower',219,147,411,''),(168,'Katahdin',NULL,198,197,''),(169,'Kelley, Maus and Company warehouse',189,148,198,'Evidently still standing in 1963, but gone in 2013; Randall gives demolition over 1950-1990'),(170,'Kendall',24,149,199,''),(171,'Kenilworth Club',195,150,200,''),(172,'Kennedy Bakery',39,151,201,''),(173,'Kent',205,152,202,'Demolition date from Randall'),(174,'Knisely',40,153,203,'Demolition date from Randall'),(175,'Krause Music Store',166,154,204,''),(176,'Kuppenheimer',NULL,152,205,''),(177,'La Salle-Jackson',57,155,212,'No information given about this building, only that it replaced the Phoenix'),(178,'La Salle-Monroe',24,156,213,'Little given about this building, only that it replaced the Nixon'),(179,'Lafayette Apartments',149,157,206,'Not enough information to locate'),(180,'Lake Shore Club',189,158,207,''),(181,'Lakeside',31,159,208,'Demolition date from Randall'),(182,'Lakota Hotel',157,160,209,''),(183,'Langdon Apartments',159,161,210,''),(184,'Larkin',165,162,211,''),(185,'Leiter, first',79,163,215,''),(186,'Leiter, second',89,164,216,''),(187,'Leland',38,165,217,''),(188,'Lemoyne',178,166,218,''),(189,'Lexington Hotel',NULL,193,220,''),(190,'Liberty Mutual',NULL,136,221,''),(191,'Lincoln, Abraham, Center',200,167,412,''),(192,'Lincoln Park Zoo Pavilions',214,168,224,''),(193,'Lind',20,169,225,''),(194,'Linthicum house',208,170,226,''),(195,'Lloyd',20,171,227,'destroyed in fire'),(196,'Long, W.H., Company',NULL,119,228,''),(197,'Lord\'s Store',186,172,229,'part of Lord\'s store, along with Witkower'),(198,'Lorimer Baptist Church',209,173,230,''),(199,'Ludington',92,174,231,''),(200,'McClurg',126,175,239,''),(201,'McCormick, Leander, Apartments',NULL,296,240,''),(202,'McCormick Place',156,176,241,'burned 1967'),(203,'McCullough Shot and Lead Co. Tower',81,177,242,''),(204,'McGraw Hill',190,178,243,''),(205,'McVickers Theater',40,179,244,''),(206,'Maison Clarté, Geneva',147,180,232,''),(207,'Majestic Hotel',108,181,233,''),(208,'Mandel Store Annex',176,182,234,'2 sections mentioned which appear to be 2 buildings as described by Randall'),(209,'Manhattan',91,183,235,''),(210,'Marina City',219,184,236,''),(211,'Marquette',120,185,237,''),(212,'Masonic Temple',104,186,238,''),(213,'Mecca Apartments',156,187,245,''),(214,'Medinah',111,188,246,''),(215,'Menier Chocolate Works',7,189,248,''),(216,'Methodist Episcopal Church of Maywood',209,190,249,''),(217,'Metropole Hotel',153,191,250,''),(218,'Metropolitan Fair and Exposition',78,176,251,''),(219,'Meyer',135,192,252,''),(220,'Michigan Ave-Wacker Drive group',216,NULL,NULL,'Not a building; the group along the river, none specified or described'),(221,'Michigan, New, Hotel',153,193,413,''),(222,'Michigan Terrace Apts',219,194,254,''),(223,'Midway Gardens',205,195,255,''),(224,'Mills',140,196,256,''),(225,'Monadnock',65,197,258,''),(226,'Monadnock addition',118,198,259,''),(227,'Monadnock and Kearsage',NULL,197,260,''),(228,'Monarch Foods Company',NULL,238,261,''),(229,'Montauk',51,199,262,''),(230,'Monticello',133,200,263,''),(231,'Moody\'s Tabernacle',35,201,264,'Sullivan did interior fresco so this is not really a building; building not described'),(232,'Mormon Tabernacle',33,202,265,''),(233,'Morningstar-Paisley Company',NULL,255,266,''),(234,'Morris',NULL,163,267,''),(235,'Morton',93,203,268,''),(236,'Morton Apartments',149,204,269,''),(237,'Moses',146,205,270,''),(238,'Mount Vernon',133,206,271,''),(239,'Museum of Natural History',96,207,272,''),(240,'Nepeenauk',NULL,50,274,''),(241,'Newberry Library',59,208,275,'Info. from Randall'),(242,'900 N Michigan Ave',189,209,21,'Info. from Randall'),(243,'Nixon',23,210,276,''),(244,'Northwestern Technological Institute',198,211,277,''),(245,'Northwestern University campus plan',198,NULL,NULL,'Not a building'),(246,'Old Colony',122,212,278,''),(247,'Omaha Apartments',157,213,279,'No location given'),(248,'1 North La Salle',117,214,5,'Info. from Randall'),(249,'120 South La Salle',104,215,2,'Info. from Randall'),(250,'Palmer House',149,216,281,''),(251,'Palmolive',177,217,283,'Info. from Randall'),(252,'Park Gate Hotel',156,218,285,'no sign of it in 2013; no exact address'),(253,'Parker Apartments',150,219,284,'lots and schools currently'),(254,'Parthenon',10,220,287,''),(255,'Patten Gymnasium',196,221,288,''),(256,'Patten House',196,222,289,''),(257,'Pennsylvania Railroad grain elevator',82,223,290,''),(258,'Pettibone Printing Company',NULL,151,291,''),(259,'Phelps, Dodge and Palmer',145,224,292,'evidently still standing in 1963; Randall gives demolition < 1985'),(260,'Phoenix',23,14,293,''),(261,'Pickwick Apartments',101,225,294,''),(262,'Pierce, Stanley R., Hall',219,226,414,'demolition to start 19 Aug 2013!'),(263,'Plaza Hotel',154,227,296,'Demolition date from Randall'),(264,'Pontiac',119,228,298,''),(265,'Portland',30,229,299,''),(266,'Post Office and Customs House',208,230,300,'Address, destruction from Randall'),(267,'Powers',NULL,49,301,''),(268,'Prarie Shores',191,NULL,NULL,'not a building: entire project of urban renewal'),(269,'Proctor and Gamble',143,NULL,NULL,'not a building: group of buildings, none specified'),(270,'Promontory Apartments',218,231,302,''),(271,'Prudential (Buffalo)',NULL,120,304,''),(272,'Prudential',214,232,303,'Info. from Randall'),(273,'Public Library',96,233,305,'Info. from Randall'),(274,'Pullman',143,234,306,''),(275,'Pullman Company factory and houses',143,NULL,NULL,'not a building: refers to the company town and an unspecified number of buildings with no info. on any'),(276,'Railway Exchange',113,235,307,''),(277,'Rand McNally',99,236,308,''),(278,'Real Estate Exchange',24,149,309,''),(279,'Reese, Michael, Hospital',191,237,415,''),(280,'Reid, Murdoch and Company',180,238,312,''),(281,'Reid house',111,239,311,''),(282,'Reliance',109,240,313,''),(283,'Republic',175,241,314,''),(284,'Revell',39,242,315,''),(285,'Robie house',193,243,316,''),(286,'Rookery',63,244,317,''),(287,'Rosenfeld',42,245,318,''),(288,'Rothschild Store',38,246,319,''),(289,'Ryerson',40,247,320,''),(290,'St. Anne\'s Church, Liverpool',6,248,339,''),(291,'St. Anne\'s Hospital',191,249,340,'Hospital closed 1988; building may now be Beth-Anne Residence'),(292,'St. Mary\'s Church (1833)',8,250,344,'Approx. address from Randall; no destruction given, but presumably gone in fire or earlier'),(293,'St. Mary\'s Church (1868)',20,251,345,'Info. from Randall'),(294,'St. Mary\'s High School',204,252,346,'Now empty lot U of I campus'),(295,'St. Ouen docks warehouse, Paris',7,253,348,''),(296,'St. Thomas the Apostle, Church of',204,254,420,''),(297,'Sandburg Village',154,NULL,NULL,'not a building: complex of many buildings over several blocks'),(298,'Schiller',NULL,113,322,''),(299,'Schlesinger and Mayer Store',162,39,323,''),(300,'Schoenhofen Brewery powerhouse',188,255,324,''),(301,'Schurz, Carl High School',202,256,416,''),(302,'Scoville',42,257,326,'demolition date from Randall in “early 1970s”'),(303,'Sears, Joseph, Elementary School',200,258,417,'Must be same building standing, but description not a sure match'),(304,'Sears Roebuck merchandise plant',179,259,328,'main building demolished but tower preserved, standing alone in a field and under renovation in Google photo'),(305,'Sears Roebuck Store',NULL,164,329,''),(306,'Second City night club',133,260,330,''),(307,'Selz, Schwab and Company factory',39,261,331,'location given as Superior & Roberts; this citation says Superior & Larabee ? and no demolition date'),(308,'7415 Sheridan Road',210,262,19,''),(309,'Sheraton Hotel',154,263,332,'Info. from Randall'),(310,'Sheridan House',199,264,333,''),(311,'Shillito, John, Store',6,265,418,''),(312,'Sibley, Hiram, and Company Warehouse',58,266,419,'Demolition date from Randall as “1980s”'),(313,'Siegel, Cooper and Company',NULL,164,336,''),(314,'608 Davis Street',208,267,17,'facade substantially changed'),(315,'skyscraper, Gothic',216,NULL,NULL,'not a building: the style'),(316,'Society Brand',178,268,337,'seems it was standing at writing in 1964; Randall gives demolition over 1950-1990'),(317,'Standard Club',41,269,338,''),(318,'State-Madison',NULL,30,342,''),(319,'Steinway Hall',200,270,343,'evidently still standing in 1963; Randall gives demolition in 1960s'),(320,'Stock Exchange',136,271,347,'Demolition date from Randall'),(321,'Studebaker',145,272,350,''),(322,'Student Union, Purdue University',207,273,351,''),(323,'Student Union, University of Michigan',207,274,352,''),(324,'Sullivan',NULL,284,353,''),(325,'Swift Hall',197,275,354,''),(326,'Tacoma',117,276,355,''),(327,'1014 Davis Street',186,277,1,'Current building at site does not fit description'),(328,'320 South Franklin Street',125,278,14,'Destroyed by 1963; Randall gives 1950-1990'),(329,'325 West Jackson Boulevard',174,279,15,'Demolition date from Randall'),(330,'3200 South Prarie Avenue (apartments)',149,280,13,'Brick apartments at site may be it??'),(331,'Toll, Illinois Bell Telephone Company',205,281,421,'Demolition date from Randall'),(332,'Tower',NULL,301,357,''),(333,'Transportation, World\'s Columbian Exposition',136,282,422,'Fair buildings were temporary, but I can\'t find a demolition date'),(334,'Tribune',161,283,360,'Only a comment about ridicule from Sullivan'),(335,'Tribune, Drummond project',209,NULL,NULL,'not a building: unsuccessful entry by Drummond'),(336,'Tribune, Griffin project',211,NULL,NULL,'not a building: unsuccessful entry by Griffin'),(337,'Tribune, Gropius and Meyer Project',217,NULL,NULL,'not a building: unsuccessful entry by Gropius and Meyer'),(338,'Tribune, Schmidt, Garden and Martin project',195,NULL,NULL,'not a building: unsuccessful entry by Schmidt et al'),(339,'Troescher',80,284,361,''),(340,'Trumball, Lyman Elementary School',201,285,423,''),(341,'241 Chestnut Street, Philadelphia',38,286,10,''),(342,'Union Bus Terminal',103,287,363,'appears to have been replaced by Thompson Center'),(343,'Union Life',NULL,50,364,''),(344,'Unitarian Church of Evanston',210,288,366,'architect a woman!'),(345,'United States Warehousing Company grain elevator',81,289,367,''),(346,'Unity',151,290,368,'Demolition date from Randall as ca. 1990'),(347,'Unity Church',208,291,369,''),(348,'University',196,292,370,''),(349,'University Apartments',190,293,371,'Not enough information to locate; perhaps pair of large condos'),(350,'Van Nelle Tobacco Company factory',147,294,372,''),(351,'Victoria Hotel',135,295,373,''),(352,'Vieux Carré, New Orleans',133,NULL,NULL,'Not a building'),(353,'Virginia Hotel',152,296,374,'No exact address; Ohio and Rush corner'),(354,'Wainright',127,297,375,''),(355,'Walker Warehouse',41,298,376,''),(356,'Ward',111,299,377,''),(357,'Ward, Montgomery, Chicago Avenue',192,300,424,''),(358,'Ward, Montgomery, Michigan Avenue',186,301,425,''),(359,'Ward, Montgomery, warehouse',192,302,426,''),(360,'Water Tower',134,303,381,''),(361,'Water Tower Inn',190,304,382,''),(362,'Western Union',NULL,14,384,''),(363,'Williams',125,305,385,''),(364,'Williamsburg, Va.',133,NULL,NULL,'Not a building'),(365,'Willoughby',80,306,386,''),(366,'Winton',191,307,387,'Not there now, but Randall suggests it was as of 1999'),(367,'Witkower',186,308,388,'part of Lord\'s store'),(368,'Woman\'s Temple',104,309,389,''),(369,'Woodbury County Courthouse',183,310,390,''),(370,'Woods Theater',38,311,391,'Info. from Randall'),(371,'Woolworth',123,312,392,''),(372,'World\'s Columbian Exposition tower (project)',96,NULL,NULL,'Not a building: design only'),(373,'Yondorf',147,313,393,'Yondorf built in 1874; the relevant part was an extension of 1893');
/*!40000 ALTER TABLE `indexentry` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `name`
--

DROP TABLE IF EXISTS `name`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `name` (
  `nameID` int(11) NOT NULL AUTO_INCREMENT,
  `name` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`nameID`)
) ENGINE=MyISAM AUTO_INCREMENT=431 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `name`
--

LOCK TABLES `name` WRITE;
/*!40000 ALTER TABLE `name` DISABLE KEYS */;
INSERT INTO `name` VALUES (1,'1014 Davis Street'),(2,'120 South La Salle'),(3,'14 N. Michigan Avenue'),(4,'180 N. Wacker Drive'),(5,'1 North La Salle'),(6,'225-29 S. Market Street'),(7,'225 S. Wacker'),(8,'229 South Wabash'),(9,'234 S. Franklin Street'),(10,'241 Chestnut Street, Philadelphia'),(11,'2 N. Riverside Plaza'),(12,'30 N. LaSalle Street'),(13,'3200 South Prarie Avenue (apartments)'),(14,'320 South Franklin Street'),(15,'325 West Jackson Boulevard'),(16,'5730 Sheridan Road house'),(17,'608 Davis Street'),(18,'625 Davis Street'),(19,'7415 Sheridan Road'),(20,'860-880 North Lake Shore Drive'),(21,'900 N Michigan Ave'),(22,'Adams and Wabash'),(23,'Alexandria Hotel'),(24,'Alumni Memorial Hall (IIT)'),(25,'Ambassador Hotel'),(26,'Ambassador West'),(27,'American Express Company'),(28,'American National Bank'),(29,'American Tract Society'),(30,'American Trust and Savings Bank'),(31,'Anshe Ma\'ariv Synagogue'),(394,'apartments, Hinman Avenue and Lee Street, Evanston'),(33,'Argyle Apartments'),(34,'Art Institute'),(35,'Ashland'),(36,'Association'),(37,'Auditorium'),(38,'Austin'),(39,'Babson Farm'),(40,'Babson House'),(41,'Bailey'),(395,'Baker Factory, Cornelius'),(43,'Bauer and Black'),(44,'Bayard'),(45,'Berbach House'),(46,'Bibliotheque National'),(47,'Board of Trade 1'),(48,'Board of Trade 2'),(49,'Boat Store, Sheerness'),(50,'Bordeaux Apartments'),(51,'Borden Block'),(52,'Borg-Warner'),(53,'Born'),(54,'Boston Store'),(55,'Bradley House'),(56,'Brewster Apartments'),(57,'Brooks'),(58,'Brunswick'),(59,'Brunswick and Balke Factory'),(60,'Bunte Brothers Candy Company'),(61,'Cable'),(62,'Calico Mill'),(63,'Calumet'),(64,'Capitol'),(65,'Carson Pirie Scott Annex'),(66,'Carson Pirie Scott Men\'s Store'),(67,'Carson Pirie Scott Store'),(68,'Carson Pirie Scott Wholesale Store'),(69,'Carter House'),(70,'Caxton'),(71,'Central Music Hall'),(72,'Central YMCA'),(73,'Century'),(74,'Chamber of Commerce'),(75,'Champlain, first'),(76,'Champlain, second'),(77,'Chapin and Gore'),(78,'Chemical Works'),(79,'Chestnut Street Theater'),(80,'Chicago Beach Hotel'),(81,'Chicago Building'),(82,'Chicago Business College'),(83,'Chicago Club'),(84,'Chicago Cold Storage Exchange'),(85,'Chicago Garment Center'),(86,'Chicago Herald'),(87,'Chicago Joint Board'),(88,'Chicago Journal'),(89,'Chicago Opera House'),(90,'Chicago Saving Bank'),(91,'Chicago Towers'),(92,'Christ Temple Church of the Apostolic Faith'),(396,'Church, Thomas Building'),(94,'Civic Center'),(95,'Civic Opera'),(397,'Cleveland, Grover Elementary School'),(97,'CNA Plaza'),(98,'Comstock Houses'),(99,'Condict'),(398,'Congregational, First Church of Austin'),(101,'Congress Hotel'),(102,'Continental Bank'),(103,'Continental Center'),(104,'Continental Hotel'),(399,'Coonley, Avery, Kindergarten'),(106,'Coonley house'),(107,'Cooper Union'),(108,'Counselman'),(109,'Crane, first'),(110,'Crane, second'),(111,'Crerar Library'),(112,'Crown'),(113,'Crown Hall'),(114,'Crystal Palace, London'),(115,'Crystal Palace, New York'),(400,'Daily News, Chicago'),(117,'Daily News, New York'),(118,'Daily Times'),(119,'Decker, Alfred and Cohn'),(120,'Dexter'),(401,'Dexter, Wirt'),(122,'Dirksen Federal'),(402,'Dixon, Arthur'),(124,'Dwight'),(125,'Edison'),(126,'Edison Phonograph Shop'),(127,'Eiffel Tower'),(128,'Equitable'),(129,'Esquire Theater'),(130,'E-Z Polish Company Factory'),(131,'Fair Store'),(403,'Farwell, Charles B., Store'),(404,'Farwell, J.V., warehouse'),(134,'Federal Office'),(135,'Felsenthal Store'),(136,'Field'),(137,'Field and Leiter Store'),(138,'Field and Leiter Wholesale Store'),(405,'Field, Marshall, Store'),(406,'Field, Marshall, Wholesale Store'),(141,'Field Museum'),(407,'Fine Arts, World\'s Columbian Exposition'),(143,'First National Bank'),(144,'Fisher'),(145,'Flatiron'),(146,'Foreman National Bank'),(147,'Fort Dearborn Bank'),(148,'Francis Apartments'),(149,'Frankenthal'),(150,'Gage Group North'),(151,'Gage Group South 1'),(152,'Gage Group South 2'),(408,'garage, Monroe Street'),(154,'Garden City Plating and Manufacturing Company factory'),(155,'Garden City Warehouse'),(156,'Garrick Theater'),(157,'Geneva Apartments'),(158,'Glessner House'),(159,'Graham Paper Company'),(160,'Great Lakes'),(161,'Great Northern Hotel'),(162,'Great Northern Theater'),(163,'Grommes and Ulrich Company Warehouse'),(164,'Guaranty'),(165,'Hammond Library'),(166,'Harper and Brothers'),(167,'Hartford Fire Insurance'),(168,'Healy Chapel'),(169,'Henrotin Hospital'),(170,'Heyworth'),(171,'Hirsch-Wickwire'),(172,'Hollywood Towers'),(173,'Home Federal Savings and Loan'),(174,'Home Insurance'),(175,'Hoops'),(176,'Horstman. William H. and Sons factory'),(409,'Horticultural, World Columbian Exposition'),(178,'Horton house'),(410,'Hull, Charles, house'),(180,'Hull House group'),(181,'Humboldt Park boathouse'),(182,'Hungerford Fish Market'),(183,'Hunter'),(184,'Hyde Park Hotel'),(185,'Illinois Bank'),(186,'Illinois Bell'),(187,'Illinois State Medical Society'),(188,'Immaculata High School'),(189,'Imperial Hotel'),(190,'Inland Steel'),(191,'Insurance Exchange'),(192,'International Leather and Belting Company factory'),(193,'Isabella'),(194,'Jayne'),(195,'Jeweler\'s'),(411,'Johnson, S.C., and Company research tower'),(197,'Katahdin'),(198,'Kelley, Maus and Company warehouse'),(199,'Kendall'),(200,'Kenilworth Club'),(201,'Kennedy Bakery'),(202,'Kent'),(203,'Knisely'),(204,'Krause Music Store'),(205,'Kuppenheimer'),(206,'Lafayette Apartments'),(207,'Lake Shore Club'),(208,'Lakeside'),(209,'Lakota Hotel'),(210,'Langdon Apartments'),(211,'Larkin'),(212,'Union Tank Car'),(213,'La Salle-Monroe'),(214,'LaSalle Bank'),(215,'Leiter, first'),(216,'Leiter, second'),(217,'Leland'),(218,'Lemoyne'),(219,'Lewis Memorial Hospital'),(220,'Lexington Hotel'),(221,'Liberty Mutual'),(222,'Liberty Mutual Insurance'),(412,'Lincoln, Abraham, Center'),(224,'Lincoln Park Zoo Pavilions'),(225,'Lind'),(226,'Linthicum house'),(227,'Lloyd'),(228,'Long, W.H., Company'),(229,'Lord\'s Store'),(230,'Lorimer Baptist Church'),(231,'Ludington'),(232,'Maison Clarté, Geneva'),(233,'Majestic Hotel'),(234,'Mandel Store Annex'),(235,'Manhattan'),(236,'Marina City'),(237,'Marquette'),(238,'Masonic Temple'),(239,'McClurg'),(240,'McCormick, Leander, Apartments'),(241,'McCormick Place'),(242,'McCullough Shot and Lead Co. Tower'),(243,'McGraw Hill'),(244,'McVickers Theater'),(245,'Mecca Apartments'),(246,'Medinah'),(247,'Medinah Club'),(248,'Menier Chocolate Works'),(249,'Methodist Episcopal Church of Maywood'),(250,'Metropole Hotel'),(251,'Metropolitan Fair and Exposition'),(252,'Meyer'),(413,'Michigan, New, Hotel'),(254,'Michigan Terrace Apts'),(255,'Midway Gardens'),(256,'Mills'),(257,'Milton F. Goodman'),(258,'Monadnock'),(259,'Monadnock addition'),(260,'Monadnock and Kearsage'),(261,'Monarch Foods Company'),(262,'Montauk'),(263,'Monticello'),(264,'Moody\'s Tabernacle'),(265,'Mormon Tabernacle'),(266,'Morningstar-Paisley Company'),(267,'Morris'),(268,'Morton'),(269,'Morton Apartments'),(270,'Moses'),(271,'Mount Vernon'),(272,'Museum of Natural History'),(273,'Museum of Science and Industry'),(274,'Nepeenauk'),(275,'Newberry Library'),(276,'Nixon'),(277,'Northwestern Technological Institute'),(278,'Old Colony'),(279,'Omaha Apartments'),(280,'One Prudential Plaza'),(281,'Palmer House'),(282,'Palmer House 3'),(283,'Palmolive'),(284,'Parker Apartments'),(285,'Park Gate Hotel'),(286,'Park Hyatt Hotel'),(287,'Parthenon'),(288,'Patten Gymnasium'),(289,'Patten House'),(290,'Pennsylvania Railroad grain elevator'),(291,'Pettibone Printing Company'),(292,'Phelps, Dodge and Palmer'),(293,'Phoenix'),(294,'Pickwick Apartments'),(414,'Pierce, Stanley R., Hall'),(296,'Plaza Hotel'),(297,'Plymouth Congregational Church'),(298,'Pontiac'),(299,'Portland'),(300,'Post Office and Customs House'),(301,'Powers'),(302,'Promontory Apartments'),(303,'Prudential'),(304,'Prudential (Buffalo)'),(305,'Public Library'),(306,'Pullman'),(307,'Railway Exchange'),(308,'Rand McNally'),(309,'Real Estate Exchange'),(415,'Reese, Michael, Hospital'),(311,'Reid house'),(312,'Reid, Murdoch and Company'),(313,'Reliance'),(314,'Republic'),(315,'Revell'),(316,'Robie house'),(317,'Rookery'),(318,'Rosenfeld'),(319,'Rothschild Store'),(320,'Ryerson'),(321,'Santa Fe Center'),(322,'Schiller'),(323,'Schlesinger and Mayer Store'),(324,'Schoenhofen Brewery powerhouse'),(416,'Schurz, Carl High School'),(326,'Scoville'),(417,'Sears, Joseph, Elementary School'),(328,'Sears Roebuck merchandise plant'),(329,'Sears Roebuck Store'),(330,'Second City night club'),(331,'Selz, Schwab and Company factory'),(332,'Sheraton Hotel'),(333,'Sheridan House'),(418,'Shillito, John, Store'),(419,'Sibley, Hiram, and Company Warehouse'),(336,'Siegel, Cooper and Company'),(337,'Society Brand'),(338,'Standard Club'),(339,'St. Anne\'s Church, Liverpool'),(340,'St. Anne\'s Hospital'),(341,'State Bank'),(342,'State-Madison'),(343,'Steinway Hall'),(344,'St. Mary\'s Church (1833)'),(345,'St. Mary\'s Church (1868)'),(346,'St. Mary\'s High School'),(347,'Stock Exchange'),(348,'St. Ouen docks warehouse, Paris'),(420,'St. Thomas the Apostle, Church of'),(350,'Studebaker'),(351,'Student Union, Purdue University'),(352,'Student Union, University of Michigan'),(353,'Sullivan'),(354,'Swift Hall'),(355,'Tacoma'),(421,'Toll, Illinois Bell Telephone Company'),(357,'Tower'),(422,'Transportation, World\'s Columbian Exposition'),(359,'Transunion'),(360,'Tribune'),(361,'Troescher'),(423,'Trumball, Lyman Elementary School'),(363,'Union Bus Terminal'),(364,'Union Life'),(365,'Union Theological College'),(366,'Unitarian Church of Evanston'),(367,'United States Warehousing Company grain elevator'),(368,'Unity'),(369,'Unity Church'),(370,'University'),(371,'University Apartments'),(372,'Van Nelle Tobacco Company factory'),(373,'Victoria Hotel'),(374,'Virginia Hotel'),(375,'Wainright'),(376,'Walker Warehouse'),(377,'Ward'),(424,'Ward, Montgomery, Chicago Avenue'),(425,'Ward, Montgomery, Michigan Avenue'),(426,'Ward, Montgomery, warehouse'),(381,'Water Tower'),(382,'Water Tower Inn'),(383,'West Central Church'),(384,'Western Union'),(385,'Williams'),(386,'Willoughby'),(387,'Winton'),(388,'Witkower'),(389,'Woman\'s Temple'),(390,'Woodbury County Courthouse'),(391,'Woods Theater'),(392,'Woolworth'),(393,'Yondorf'),(32,'Hinman and Lee Apartments'),(93,'Thomas Church Building'),(96,'Grover Cleveland Elementary School'),(100,'First Congregational Church of Austin'),(105,'Avery Coonley Kindergarten'),(116,'Chicago Daily News'),(121,'Wirt Dexter'),(123,'Arthur Dixon'),(132,'Charles B. Farwell Store'),(133,'J.V. Farwell warehouse'),(139,'Marshall Field Store'),(140,'Marshall Field Wholesale Store'),(142,'World\'s Columbian Exposition Fine Arts Building'),(153,'Monroe Street garage'),(177,'World Columbian Exposition Horticultural Building'),(179,'Charles Hull house'),(223,'Abraham Lincoln Center'),(253,'New Michigan Hotel'),(295,'Stanley R. Pierce Hall'),(310,'Michael Reese Hospital'),(325,'Carl Schurz High School'),(327,'Joseph Sears Elementary School'),(335,'Hiram Sibley and Company Warehouse'),(349,'Church of St. Thomas the Apostle'),(356,'Illinois Bell Telephone Company Toll Building'),(358,'World\'s Columbian Exposition Transportation Building'),(362,'Lyman Trumball Elementary School'),(378,'Montgomery Ward (Chicago Avenue)'),(379,'Montgomery Ward (Michigan Avenue)'),(380,'Montgomery Ward warehouse'),(196,'S.C. Johnson Company research tower'),(42,'Cornelius Baker Company factory'),(334,'John Shillito Store'),(427,'Alfred Decker and Cohn'),(428,'W.H. Long Company'),(429,'Leander McCormick Apartments'),(430,'Grant Park Arms Apartments');
/*!40000 ALTER TABLE `name` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `namebldg`
--

DROP TABLE IF EXISTS `namebldg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `namebldg` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `nameID` int(11) DEFAULT NULL,
  `bldgID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=431 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `namebldg`
--

LOCK TABLES `namebldg` WRITE;
/*!40000 ALTER TABLE `namebldg` DISABLE KEYS */;
INSERT INTO `namebldg` VALUES (1,1,277),(2,2,215),(3,3,299),(4,4,116),(5,5,214),(6,6,313),(7,7,313),(8,8,85),(9,9,306),(10,10,286),(11,11,79),(12,12,271),(13,13,280),(14,14,278),(15,15,279),(16,16,100),(17,17,267),(18,18,172),(19,19,262),(20,20,87),(21,21,209),(22,22,55),(23,23,1),(24,24,2),(25,25,3),(26,26,3),(27,27,4),(28,28,5),(29,29,6),(30,30,7),(31,31,8),(32,394,9),(33,33,10),(34,34,11),(35,35,12),(36,36,45),(37,37,13),(38,38,14),(39,39,15),(40,40,16),(41,41,17),(42,395,18),(43,43,19),(44,44,20),(45,45,21),(46,46,22),(47,47,23),(48,48,24),(49,49,25),(50,50,26),(51,51,27),(52,52,28),(53,53,29),(54,54,30),(55,55,31),(56,56,32),(57,57,33),(58,58,272),(59,59,34),(60,60,35),(61,61,36),(62,62,37),(63,63,38),(64,64,186),(65,65,40),(66,66,40),(67,67,39),(68,68,41),(69,69,42),(70,70,43),(71,71,44),(72,72,45),(73,73,46),(74,74,47),(75,75,48),(76,76,49),(77,77,50),(78,78,51),(79,79,52),(80,80,54),(81,81,53),(82,82,55),(83,83,56),(84,84,57),(85,85,58),(86,86,59),(87,87,284),(88,88,284),(89,89,60),(90,90,53),(91,91,263),(92,92,190),(93,396,61),(94,94,62),(95,95,63),(96,397,64),(97,97,68),(98,98,65),(99,99,20),(100,398,66),(101,101,67),(102,102,142),(103,103,68),(104,104,263),(105,399,70),(106,106,69),(107,107,71),(108,108,72),(109,109,73),(110,110,74),(111,111,75),(112,112,175),(113,113,76),(114,114,77),(115,115,78),(116,400,79),(117,117,80),(118,118,284),(119,119,268),(120,120,81),(121,401,82),(122,122,93),(123,402,83),(124,124,84),(125,125,85),(126,126,85),(127,127,86),(128,128,149),(129,129,88),(130,130,89),(131,131,90),(132,403,91),(133,404,92),(134,134,93),(135,135,94),(136,136,95),(137,137,98),(138,138,99),(139,405,96),(140,406,97),(141,141,207),(142,407,101),(143,143,102),(144,144,103),(145,145,104),(146,146,5),(147,147,7),(148,148,105),(149,149,106),(150,150,107),(151,151,108),(152,152,109),(153,408,110),(154,154,111),(155,155,112),(156,156,113),(157,157,114),(158,158,115),(159,159,148),(160,160,116),(161,161,117),(162,162,118),(163,163,119),(164,164,120),(165,165,121),(166,166,122),(167,167,123),(168,168,124),(169,169,125),(170,170,126),(171,171,58),(172,172,127),(173,173,241),(174,174,128),(175,175,36),(176,176,129),(177,409,130),(178,178,131),(179,410,132),(180,180,133),(181,181,134),(182,182,135),(183,183,136),(184,184,137),(185,185,138),(186,186,281),(187,187,299),(188,188,139),(189,189,140),(190,190,141),(191,191,142),(192,192,143),(193,193,144),(194,194,145),(195,195,146),(196,411,147),(197,197,198),(198,198,148),(199,199,149),(200,200,150),(201,201,151),(202,202,152),(203,203,153),(204,204,154),(205,205,152),(206,206,157),(207,207,158),(208,208,159),(209,209,160),(210,210,161),(211,211,162),(212,212,155),(213,213,156),(214,214,95),(215,215,163),(216,216,164),(217,217,165),(218,218,166),(219,219,160),(220,220,193),(221,221,136),(222,222,136),(223,412,167),(224,224,168),(225,225,169),(226,226,170),(227,227,171),(228,228,119),(229,229,172),(230,230,173),(231,231,174),(232,232,180),(233,233,181),(234,234,182),(235,235,183),(236,236,184),(237,237,185),(238,238,186),(239,239,175),(240,240,296),(241,241,176),(242,242,177),(243,243,178),(244,244,179),(245,245,187),(246,246,188),(247,247,263),(248,248,189),(249,249,190),(250,250,191),(251,251,176),(252,252,192),(253,413,193),(254,254,194),(255,255,195),(256,256,196),(257,257,246),(258,258,197),(259,259,198),(260,260,197),(261,261,238),(262,262,199),(263,263,200),(264,264,201),(265,265,202),(266,266,255),(267,267,163),(268,268,203),(269,269,204),(270,270,205),(271,271,206),(272,272,207),(273,273,101),(274,274,50),(275,275,208),(276,276,210),(277,277,211),(278,278,212),(279,279,213),(280,280,232),(281,281,216),(282,282,216),(283,283,217),(284,284,219),(285,285,218),(286,286,304),(287,287,220),(288,288,221),(289,289,222),(290,290,223),(291,291,151),(292,292,224),(293,293,14),(294,294,225),(295,414,226),(296,296,227),(297,297,251),(298,298,228),(299,299,229),(300,300,230),(301,301,49),(302,302,231),(303,303,232),(304,304,120),(305,305,233),(306,306,234),(307,307,235),(308,308,236),(309,309,149),(310,415,237),(311,311,239),(312,312,238),(313,313,240),(314,314,241),(315,315,242),(316,316,243),(317,317,244),(318,318,245),(319,319,246),(320,320,247),(321,321,235),(322,322,113),(323,323,39),(324,324,255),(325,416,256),(326,326,257),(327,417,258),(328,328,259),(329,329,164),(330,330,260),(331,331,261),(332,332,263),(333,333,264),(334,418,265),(335,419,266),(336,336,164),(337,337,268),(338,338,269),(339,339,248),(340,340,249),(341,341,215),(342,342,30),(343,343,270),(344,344,250),(345,345,251),(346,346,252),(347,347,271),(348,348,253),(349,420,254),(350,350,272),(351,351,273),(352,352,274),(353,353,284),(354,354,275),(355,355,276),(356,421,281),(357,357,301),(358,422,282),(359,359,155),(360,360,283),(361,361,284),(362,423,285),(363,363,287),(364,364,50),(365,365,121),(366,366,288),(367,367,289),(368,368,290),(369,369,291),(370,370,292),(371,371,293),(372,372,294),(373,373,295),(374,374,296),(375,375,297),(376,376,298),(377,377,299),(378,424,300),(379,425,301),(380,426,302),(381,381,303),(382,382,304),(383,383,66),(384,384,14),(385,385,305),(386,386,306),(387,387,307),(388,388,308),(389,389,309),(390,390,310),(391,391,311),(392,392,312),(393,393,313),(394,32,9),(395,93,61),(396,96,64),(397,100,66),(398,105,70),(399,116,79),(400,121,82),(401,123,83),(402,132,91),(403,133,92),(404,139,96),(405,140,97),(406,142,101),(407,153,110),(408,177,130),(409,179,132),(410,223,167),(411,253,193),(412,295,226),(413,310,237),(414,325,256),(415,327,258),(416,335,266),(417,349,254),(418,356,281),(419,358,282),(420,362,285),(421,378,300),(422,379,301),(423,380,302),(424,196,147),(425,42,18),(426,334,265),(427,427,268),(428,428,119),(429,429,296),(430,430,26);
/*!40000 ALTER TABLE `namebldg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `nameorigin`
--

DROP TABLE IF EXISTS `nameorigin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `nameorigin` (
  `ID` int(11) NOT NULL AUTO_INCREMENT,
  `nameID` int(11) DEFAULT NULL,
  `sourceID` int(11) DEFAULT NULL,
  PRIMARY KEY (`ID`)
) ENGINE=MyISAM AUTO_INCREMENT=431 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `nameorigin`
--

LOCK TABLES `nameorigin` WRITE;
/*!40000 ALTER TABLE `nameorigin` DISABLE KEYS */;
INSERT INTO `nameorigin` VALUES (1,1,1),(2,2,1),(3,3,4),(4,4,4),(5,5,1),(6,6,4),(7,7,2),(8,8,2),(9,9,4),(10,10,1),(11,11,4),(12,12,4),(13,13,1),(14,14,1),(15,15,1),(16,16,1),(17,17,1),(18,18,2),(19,19,1),(20,20,1),(21,21,1),(22,22,2),(23,23,1),(24,24,1),(25,25,1),(26,26,2),(27,27,1),(28,28,1),(29,29,1),(30,30,1),(31,31,1),(32,394,3),(33,33,1),(34,34,1),(35,35,1),(36,36,2),(37,37,1),(38,38,1),(39,39,1),(40,40,1),(41,41,1),(42,395,3),(43,43,1),(44,44,1),(45,45,1),(46,46,1),(47,47,1),(48,48,1),(49,49,1),(50,50,1),(51,51,1),(52,52,1),(53,53,1),(54,54,1),(55,55,1),(56,56,1),(57,57,1),(58,58,2),(59,59,1),(60,60,1),(61,61,1),(62,62,1),(63,63,1),(64,64,2),(65,65,1),(66,66,2),(67,67,1),(68,68,1),(69,69,1),(70,70,1),(71,71,1),(72,72,1),(73,73,1),(74,74,1),(75,75,1),(76,76,1),(77,77,1),(78,78,1),(79,79,1),(80,80,1),(81,81,1),(82,82,1),(83,83,1),(84,84,1),(85,85,1),(86,86,1),(87,87,2),(88,88,2),(89,89,1),(90,90,2),(91,91,4),(92,92,2),(93,396,3),(94,94,1),(95,95,1),(96,397,3),(97,97,4),(98,98,1),(99,99,2),(100,398,3),(101,101,1),(102,102,2),(103,103,1),(104,104,4),(105,399,3),(106,106,1),(107,107,1),(108,108,1),(109,109,1),(110,110,1),(111,111,1),(112,112,2),(113,113,1),(114,114,1),(115,115,1),(116,400,3),(117,117,1),(118,118,4),(119,119,3),(120,120,1),(121,401,3),(122,122,7),(123,402,3),(124,124,1),(125,125,1),(126,126,4),(127,127,1),(128,128,2),(129,129,1),(130,130,1),(131,131,1),(132,403,3),(133,404,3),(134,134,1),(135,135,1),(136,136,1),(137,137,1),(138,138,1),(139,405,3),(140,406,3),(141,141,2),(142,407,3),(143,143,1),(144,144,1),(145,145,1),(146,146,2),(147,147,2),(148,148,1),(149,149,1),(150,150,1),(151,151,1),(152,152,1),(153,408,3),(154,154,1),(155,155,1),(156,156,1),(157,157,1),(158,158,1),(159,159,2),(160,160,1),(161,161,1),(162,162,1),(163,163,1),(164,164,1),(165,165,1),(166,166,1),(167,167,1),(168,168,1),(169,169,1),(170,170,1),(171,171,4),(172,172,1),(173,173,2),(174,174,1),(175,175,2),(176,176,1),(177,409,3),(178,178,1),(179,410,3),(180,180,1),(181,181,1),(182,182,1),(183,183,1),(184,184,1),(185,185,1),(186,186,4),(187,187,4),(188,188,1),(189,189,1),(190,190,1),(191,191,1),(192,192,1),(193,193,1),(194,194,1),(195,195,1),(196,411,3),(197,197,2),(198,198,1),(199,199,1),(200,200,1),(201,201,1),(202,202,1),(203,203,1),(204,204,1),(205,205,2),(206,206,1),(207,207,1),(208,208,1),(209,209,1),(210,210,1),(211,211,1),(212,212,1),(213,213,1),(214,214,4),(215,215,1),(216,216,1),(217,217,1),(218,218,1),(219,219,6),(220,220,2),(221,221,2),(222,222,2),(223,412,3),(224,224,1),(225,225,1),(226,226,1),(227,227,1),(228,228,3),(229,229,1),(230,230,1),(231,231,1),(232,232,1),(233,233,1),(234,234,1),(235,235,1),(236,236,1),(237,237,1),(238,238,1),(239,239,1),(240,240,3),(241,241,1),(242,242,1),(243,243,1),(244,244,1),(245,245,1),(246,246,1),(247,247,4),(248,248,1),(249,249,1),(250,250,1),(251,251,2),(252,252,1),(253,413,3),(254,254,1),(255,255,1),(256,256,1),(257,257,4),(258,258,1),(259,259,1),(260,260,2),(261,261,2),(262,262,1),(263,263,1),(264,264,1),(265,265,1),(266,266,2),(267,267,2),(268,268,1),(269,269,1),(270,270,1),(271,271,1),(272,272,1),(273,273,2),(274,274,2),(275,275,1),(276,276,1),(277,277,1),(278,278,1),(279,279,1),(280,280,4),(281,281,1),(282,282,4),(283,283,1),(284,284,1),(285,285,1),(286,286,4),(287,287,1),(288,288,1),(289,289,1),(290,290,1),(291,291,2),(292,292,1),(293,293,2),(294,294,1),(295,414,3),(296,296,1),(297,297,2),(298,298,1),(299,299,1),(300,300,1),(301,301,2),(302,302,1),(303,303,1),(304,304,2),(305,305,1),(306,306,1),(307,307,1),(308,308,1),(309,309,2),(310,415,3),(311,311,1),(312,312,1),(313,313,1),(314,314,1),(315,315,1),(316,316,1),(317,317,1),(318,318,1),(319,319,1),(320,320,1),(321,321,4),(322,322,2),(323,323,2),(324,324,1),(325,416,3),(326,326,1),(327,417,3),(328,328,1),(329,329,2),(330,330,1),(331,331,1),(332,332,1),(333,333,1),(334,418,3),(335,419,3),(336,336,2),(337,337,1),(338,338,1),(339,339,1),(340,340,1),(341,341,4),(342,342,2),(343,343,1),(344,344,1),(345,345,1),(346,346,1),(347,347,1),(348,348,1),(349,420,3),(350,350,1),(351,351,1),(352,352,1),(353,353,2),(354,354,1),(355,355,1),(356,421,3),(357,357,2),(358,422,3),(359,359,7),(360,360,1),(361,361,1),(362,423,3),(363,363,1),(364,364,2),(365,365,2),(366,366,1),(367,367,1),(368,368,1),(369,369,1),(370,370,1),(371,371,1),(372,372,1),(373,373,1),(374,374,1),(375,375,1),(376,376,1),(377,377,1),(378,424,3),(379,425,3),(380,426,3),(381,381,1),(382,382,1),(383,383,2),(384,384,2),(385,385,1),(386,386,1),(387,387,1),(388,388,1),(389,389,1),(390,390,1),(391,391,1),(392,392,1),(393,393,1),(394,32,1),(395,93,1),(396,96,1),(397,100,1),(398,105,1),(399,116,1),(400,121,1),(401,123,1),(402,132,1),(403,133,1),(404,139,1),(405,140,1),(406,142,1),(407,153,1),(408,177,1),(409,179,1),(410,223,1),(411,253,1),(412,295,1),(413,310,1),(414,325,1),(415,327,1),(416,335,1),(417,349,1),(418,356,1),(419,358,1),(420,362,1),(421,378,1),(422,379,1),(423,380,1),(424,196,1),(425,42,1),(426,334,1),(427,427,2),(428,428,2),(429,429,2),(430,430,4);
/*!40000 ALTER TABLE `nameorigin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `origin`
--

DROP TABLE IF EXISTS `origin`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `origin` (
  `sourceID` int(11) NOT NULL AUTO_INCREMENT,
  `source` varchar(25) DEFAULT NULL,
  PRIMARY KEY (`sourceID`)
) ENGINE=MyISAM AUTO_INCREMENT=8 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `origin`
--

LOCK TABLES `origin` WRITE;
/*!40000 ALTER TABLE `origin` DISABLE KEYS */;
INSERT INTO `origin` VALUES (1,'Condit main'),(2,'Condit alternate'),(3,'Condit original spelling'),(4,'Randall'),(6,'Other'),(7,'Emporis');
/*!40000 ALTER TABLE `origin` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `photo`
--

DROP TABLE IF EXISTS `photo`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `photo` (
  `photoID` int(11) NOT NULL AUTO_INCREMENT,
  `bldgID` int(11) DEFAULT NULL,
  `file` varchar(55) DEFAULT NULL,
  `display` tinyint(1) DEFAULT NULL,
  PRIMARY KEY (`photoID`)
) ENGINE=MyISAM AUTO_INCREMENT=178 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `photo`
--

LOCK TABLES `photo` WRITE;
/*!40000 ALTER TABLE `photo` DISABLE KEYS */;
INSERT INTO `photo` VALUES (1,13,'AuditoriumTower.jpg',1),(2,13,'AuditoriumCongressElev.jpg',1),(3,13,'AuditoriumMichiganElev.jpg',1),(4,30,'BostonStore.jpg',1),(6,67,'CongressHotel.jpg',1),(7,103,'Fisher.jpg',1),(8,103,'OldColonyFisherMonadnock.jpg',1),(9,146,'Jewelers(BadQuality).jpg',0),(10,164,'LeiterII.jpg',1),(11,175,'McClurg.jpg',1),(12,183,'Manhattan.jpg',1),(13,185,'Marquette.jpg',1),(14,185,'MarquetteReflection.jpg',1),(15,185,'MarquetteLobby.jpg',1),(16,197,'Monadnock.jpg',1),(17,197,'OldColonyFisherMonadnock.jpg',1),(18,203,'Morton.jpg',1),(19,212,'OldColonyGap.jpg',1),(20,212,'OldColonyFisherMonadnock.jpg',1),(21,228,'Pontiac.jpg',1),(22,244,'RookeryLobby1.jpg',1),(23,244,'RookeryLobby2.jpg',1),(24,244,'Rookery.jpg',1),(25,244,'RookeryCrows.jpg',1),(26,83,'ArthurDixon.jpg',1),(27,13,'Auditorium.jpg',1),(177,255,'Schoenhofen.jpg',1),(29,26,'Bordeaux1.jpg',1),(30,26,'Bordeaux2.jpg',0),(31,32,'BrewsterApts1.jpg',1),(32,32,'BrewsterApts2.jpg',1),(33,33,'Brooks.jpg',1),(34,46,'Century1.jpg',1),(35,46,'Century2.jpg',1),(37,50,'ChapinGore1.jpg',1),(39,53,'ChicagoBldg1.jpg',1),(40,53,'ChicagoBldg2.jpg',1),(41,53,'ChicagoBldg3.jpg',1),(176,166,'Lemoyne.jpg',1),(43,84,'Dwight.jpg',1),(44,107,'GageGroup.jpg',1),(45,108,'GageGroup.jpg',1),(46,109,'GageGroup.jpg',1),(47,126,'Heyworth1.jpg',1),(48,126,'Heyworth2.jpg',1),(49,132,'HullHouse2.jpg',1),(50,132,'HullHouse3.jpg',1),(51,133,'HullHouseDining2.jpg',1),(52,139,'ImmaculataHS1.jpg',1),(53,141,'InlandSteel.jpg',1),(54,146,'Jewelers2.jpg',0),(55,146,'Jewelers3.jpg',1),(56,164,'LeiterII-1.jpg',1),(57,164,'LeiterII-2.jpg',0),(58,167,'LincolnCenter.jpg',1),(59,174,'Ludington1.jpg',1),(60,174,'Ludington2.jpg',1),(61,184,'MarinaCity.jpg',1),(62,237,'MichaelReese(Singer).jpg',1),(63,110,'MonroeStGarage1.jpg',1),(64,110,'MonroeStGarage2.jpg',0),(65,301,'MontgomeryWard(Michigan).jpg',1),(66,300,'MontgomeryWardWarehouse-Office.jpg',1),(67,302,'MontgomeryWardWarehouse-Office.jpg',1),(68,156,'NewYorkLife(La Salle-Monroe).jpg',1),(69,235,'RailwayExchange.jpg',1),(70,239,'ReidHouse1.jpg',1),(71,239,'ReidHouse2.jpg',1),(72,238,'ReidMurdoch.jpg',1),(73,240,'Reliance.jpg',1),(175,45,'CentralYMCA.jpg',1),(75,255,'SchoenhofenEntrance.jpg',1),(76,272,'Studebaker.jpg',1),(77,40,'CarsonPirieAnnex.jpg',1),(78,39,'CarsonPirie.jpg',1),(79,49,'Champlain.jpg',1),(80,133,'HullHouseDining1.jpg',0),(81,283,'TribuneTower.jpg',1),(82,154,'KrauseMusic.jpg',1),(83,119,'GrommesUlrich.jpg',1),(84,62,'CivicCenter.jpg',1),(85,305,'WilliamsBldg.jpg',1),(86,139,'ImmaculataHS.jpg',1),(87,132,'HullHouse1.jpg',1),(88,275,'SwiftHall.jpg',1),(89,292,'UniversityBuilding1.jpg',1),(90,292,'UniversityBuilding2.jpg',1),(91,65,'ComstockHouse1.jpg',1),(92,65,'ComstockHouse2.jpg',1),(93,267,'608DavisStreet.jpg',1),(94,170,'LinthicumHouse.jpg',1),(95,264,'SheridanHouse.jpg',1),(96,42,'CarterHouse.jpg',1),(172,150,'KenilworthClub1.jpg',1),(173,150,'KenilworthClub2.jpg',1),(174,150,'KenilworthClub3.jpg',1);
/*!40000 ALTER TABLE `photo` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `stage`
--

DROP TABLE IF EXISTS `stage`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `stage` (
  `stageID` int(11) NOT NULL AUTO_INCREMENT,
  `building` varchar(200) DEFAULT NULL,
  `page` varchar(200) DEFAULT NULL,
  `figures` varchar(200) DEFAULT NULL,
  `address` varchar(200) DEFAULT NULL,
  `street` varchar(200) DEFAULT NULL,
  `year` varchar(200) DEFAULT NULL,
  `firm` varchar(200) DEFAULT NULL,
  `demolished` varchar(200) DEFAULT NULL,
  `paragraphs` varchar(200) DEFAULT NULL,
  `sentences` varchar(200) DEFAULT NULL,
  `pages` varchar(200) DEFAULT NULL,
  `photo` varchar(200) DEFAULT NULL,
  `valid` varchar(200) DEFAULT NULL,
  `alternate` varchar(200) DEFAULT NULL,
  `location` varchar(200) DEFAULT NULL,
  `citation` varchar(200) DEFAULT NULL,
  `comment` varchar(200) DEFAULT NULL,
  `indexorder` varchar(200) DEFAULT NULL,
  `area` varchar(200) DEFAULT NULL,
  `standing` varchar(200) DEFAULT NULL,
  `demyr1` varchar(200) DEFAULT NULL,
  `demyr2` varchar(200) DEFAULT NULL,
  `nameID` varchar(200) DEFAULT NULL,
  PRIMARY KEY (`stageID`)
) ENGINE=MyISAM AUTO_INCREMENT=747 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `stage`
--

LOCK TABLES `stage` WRITE;
/*!40000 ALTER TABLE `stage` DISABLE KEYS */;
INSERT INTO `stage` VALUES (1,'Adams and Wabash','','','','',NULL,'','',NULL,NULL,NULL,'','Chicago Business College','','Chicago','','','1','Illinois','demolished',NULL,NULL,'22'),(2,'Alexandria Hotel','156','','542','Rush','1891','Edmund R. Krause','1950-1990',NULL,'1',NULL,'','','','Chicago','','Randall gives demolition over 1950-1990','2','Illinois','demolished','1950','1990','23'),(3,'Alumni Memorial Hall (IIT)','218','189','','','1946','Mies van der Rohe',NULL,NULL,'1',NULL,'','','','Chicago','','','3','Illinois','extant',NULL,NULL,'24'),(4,'Ambassador Hotel','194','','1301','State','1919','Schmidt, Garden, & Martin',NULL,NULL,'1',NULL,'','','Ambassador West','Chicago','','','4','Illinois','extant',NULL,NULL,'25'),(5,'American Express Company','22','','-21','Monroe','1873','H.H. Richardson','1930','1',NULL,NULL,'','','','Chicago','Oschner 1985','','5','Illinois','demolished','1930','1930','27'),(6,'American National Bank','87','','33','La Salle','1928','Graham, Anderson, Probst, & White',NULL,NULL,'0',NULL,'','','Foreman National Bank','Chicago','','Info. from Randall','6','Illinois','extant',NULL,NULL,'28'),(7,'American Tract Society','140','','3','Spruce','1895','R.H. Robertson',NULL,NULL,NULL,'1','','','','New York','','','7','USA','extant',NULL,NULL,'29'),(8,'American Trust and Savings Bank','189','','-90','Monroe','1906','Hunt','1969',NULL,'0',NULL,'','','Fort Dearborn Bank','Chicago','','Info. from Randall','8','Illinois','demolished','1969','1969','30'),(9,'Anshe Ma\'ariv Synagogue','208','','','','1890','Adler & Sullivan','?',NULL,'0',NULL,'','','','Chicago','','','9','Illinois',NULL,NULL,NULL,'31'),(10,'apartments, Hinman Avenue and Lee Street, Evanston','159','','','','1922','Laurence G. Hallberg','?',NULL,'3',NULL,'','','','Evanston','','','10','Illinois',NULL,NULL,NULL,'32'),(11,'Argyle Apartments','101','','80','Jackson','1887','Burnham & Root','<1904',NULL,'0',NULL,'','','','Chicago','p 259 Randall','','11','Illinois','demolished','1887','1904','33'),(12,'Art Institute','96','','-101','Michigan',NULL,'Shepley, Rutan & Coolidge',NULL,NULL,'0',NULL,'','','','Chicago','','','12','Illinois','extant',NULL,NULL,'34'),(13,'Ashland','102','61-62','161','Clark','1892','Burnham & Root','1949',NULL,NULL,'1','','','','Chicago','','','13','Illinois','demolished','1949','1949','35'),(14,'Auditorium','69','31-39','50','Congress','1889','Adler & Sullivan',NULL,NULL,NULL,'9','AuditoriumTower.JPG;AuditoriumCongressElev.JPG;AuditoriumMichigan.JPG','','','Chicago','','','14','Illinois','extant',NULL,NULL,'37'),(15,'Austin','57','','-111','Jackson','1886','Burnham & Root','1959',NULL,'5',NULL,'','','Phoenix; Western Union','Chicago','','','15','Illinois','demolished','1959','1959','38'),(16,'Babson Farm','184','','','','1915','Purcell, Feick, & Elmslie','?',NULL,'0',NULL,'','','','Riverside','','','16','Illinois',NULL,NULL,NULL,'39'),(17,'Babson House','183','','','','1907','Sullivan','?',NULL,'0',NULL,'','','','Riverside','','','17','Illinois',NULL,NULL,NULL,'40'),(18,'Bailey','174','132','-529','Franklin','1898','Holabird & Roche ','1953',NULL,'1',NULL,'','','','Chicago','','','18','Illinois','demolished','1953','1953','41'),(19,'Baker Factory, Cornelius','39','','','','1853','Hoxie','?',NULL,'1',NULL,'','','','Philadelphia','','','19','USA',NULL,NULL,NULL,'42'),(20,'Bauer and Black','174','','-2500','Dearborn','1907','Holabird & Roche ','1962',NULL,'2',NULL,'','','','Chicago','','','20','Illinois','demolished','1962','1962','43'),(21,'Bauhaus','147','','','',NULL,'','',NULL,'0',NULL,'','','','Chicago','','not a building: comment about the school','21','Illinois','demolished',NULL,NULL,NULL),(22,'Bayard','130','','65','Bleecker','1897','Sullivan',NULL,NULL,'1',NULL,'','','','New York','','','22','USA','extant',NULL,NULL,'44'),(23,'Berbach House','211','180','','','1914','Van Bergen','?',NULL,'2',NULL,'','','','Wilmette','','','23','Illinois',NULL,NULL,NULL,'45'),(24,'Bibliotheque National','87','','','','1858','Labrouste','?',NULL,'0',NULL,'','','','Paris','','','24','foreign',NULL,NULL,NULL,'46'),(25,'Board of Trade 1','137','','-141','Jackson','1885','Boyington','1929',NULL,'0',NULL,'','','','Chicago','','','25','Illinois','demolished','1929','1929','47'),(26,'Board of Trade 2','177','','-141','Jackson','1930','Holabird & Root',NULL,NULL,'1',NULL,'','','','Chicago','','','26','Illinois','extant',NULL,NULL,'48'),(27,'Boat Store, Sheerness','67','','','','1858','Greene','?',NULL,'1',NULL,'','','','Sheerness, England','','','27','foreign',NULL,NULL,NULL,'49'),(28,'Bordeaux Apartments','156','','-1140','Michigan ','1891','Baumann & Cady ',NULL,NULL,'2',NULL,'','','','Chicago','','','28','Illinois','extant',NULL,NULL,'50'),(29,'Borden Block','37','','150','Dearborn','1879','Adler & Sullivan','1916','1',NULL,NULL,'','','','Chicago','','','29','Illinois','demolished','1916','1916','51'),(30,'Borg-Warner','43','','-200','Michigan','1958','',NULL,NULL,'0',NULL,'','','','Chicago','http://www.chicagoarchitecture.info/Building/1130/Borg-Warner-Building.php','','30','Illinois','extant',NULL,NULL,'52'),(31,'Born','174','134','-540','Wells','1908','Holabird & Roche ','1953',NULL,'0',NULL,'','','','Chicago','','','31','Illinois','demolished','1953','1953','53'),(32,'Boston Store','174','','2','State','1905','Holabird & Roche ',NULL,NULL,'4',NULL,'BostonStore.jpg','','','Chicago','','','32','Illinois','extant',NULL,NULL,'54'),(33,'Bradley House','183','','','','1911','Elmslie','?',NULL,'0',NULL,'','','','Woods Hole, MA','','','33','USA',NULL,NULL,NULL,'55'),(34,'Brewster Apartments','157','119-121','2800','Pine Grove','1893','R.H. Turnock',NULL,NULL,NULL,'1','','','','Chicago','','','34','Illinois','extant',NULL,NULL,'56'),(35,'Brooks','176','139','-223','Jackson','1910','Holabird & Roche ',NULL,NULL,'2',NULL,'','','','Chicago','','','35','Illinois','extant',NULL,NULL,'57'),(36,'Brunswick','','','','',NULL,'','',NULL,NULL,NULL,'','Studebaker','','Chicago','','','36','Illinois','demolished',NULL,NULL,'58'),(37,'Brunswick and Balke Factory','42','','700','Orleans','1883','Adler & Sullivan','1989',NULL,'0',NULL,'','','','Chicago','http://www.chicagolife.net/content/art/The_Great_Gallery_Fire','Burned in 1989','37','Illinois','demolished','1989','1989','59'),(38,'Bunte Brothers Candy Company','194','155','-3301','Frankin','1921','Schmidt, Garden, & Martin','<2013','1',NULL,NULL,'','','','Chicago','','address is parking lot','38','Illinois','demolished','1921','2013','60'),(39,'Cable','125','83-84','-301','Wabash','1899','Holabird & Roche ','1960',NULL,NULL,'1','','','','Chicago','','','39','Illinois','demolished','1960','1960','61'),(40,'Calico Mill','6','','','','1792','Strutt','?',NULL,'1',NULL,'','','','Derby','','','40','foreign',NULL,NULL,NULL,'62'),(41,'Calumet','57','','-200','La Salle','1883','Burnham & Root','1913','1',NULL,NULL,'','','','Chicago','','','41','Illinois','demolished','1913','1913','63'),(42,'Capitol','','','','',NULL,'','',NULL,NULL,NULL,'','Masonic Temple','','Chicago','','','42','Illinois','demolished',NULL,NULL,'64'),(43,'Carson Pirie Scott Store','162','123-129','-1','State','1903','Sullivan',NULL,NULL,NULL,'4','','','','Chicago','','','43','Illinois','extant',NULL,NULL,'67'),(44,'Carson Pirie Scott Annex','213','184-185','44','Wabash','1926','Hubert & Daniel Burnham',NULL,NULL,NULL,'1','','','Carson Pirie Scott Men\'s Store','Chicago','','','44','Illinois','extant',NULL,NULL,'65'),(45,'Carson Pirie Scott Wholesale Store','162','','-300','Adams','1875','Van Osdel','1926','1',NULL,NULL,'','','','Chicago','','Demolition date from Randall','45','Illinois','demolished','1926','1926','68'),(46,'Carter House','210','176','1024','Judson','1910','Griffin',NULL,NULL,'3',NULL,'','','','Evanston','','','46','Illinois','extant',NULL,NULL,'69'),(47,'Caxton','118','71','-508','Dearborn','1889','Holabird & Roche ','1947','1',NULL,NULL,'','','','Chicago','','','47','Illinois','demolished','1947','1947','70'),(48,'Centenniel Exposition Tower','67','','','','1876','Clark & Reeves','?',NULL,'1',NULL,'','','','Philadelphia','','not a building: Never built','48','USA',NULL,NULL,NULL,NULL),(49,'Central Music Hall','31','4','1','Randolph','1879','Adler','1901',NULL,NULL,'2','','','','Chicago','','','49','Illinois','demolished','1901','1901','71'),(50,'Central YMCA','93','','-19','La Salle','1892','Jenney',NULL,'1',NULL,NULL,'','','Association','Chicago','http://en.wikipedia.org/wiki/19_South_LaSalle_Street','','50','Illinois','extant',NULL,NULL,'72'),(51,'Century','177','','-202','State','1914','Holabird & Roche ',NULL,NULL,'2',NULL,'','','','Chicago','http://www.gsa.gov/portal/ext/html/site/hb/category/25431/actionParameter/exploreByBuilding/buildingId/1204','','51','Illinois','extant',NULL,NULL,'73'),(52,'Chamber of Commerce','87','46-47','33','La Salle','1888','Baumann & Huehl','1928',NULL,NULL,'2','','','','Chicago','','','52','Illinois','demolished','1928','1928','74'),(53,'Champlain, first','124','','1','State','1894','Holabird & Roche ','1916','1',NULL,NULL,'','','','Chicago','','','53','Illinois','demolished','1916','1916','75'),(54,'Champlain, second','174','131','-37','Wabash','1903','Holabird & Roche ',NULL,'1',NULL,NULL,'','','','Chicago','http://designslinger.com/2011/01/20/champlain-building.aspx','','54','Illinois','extant',NULL,NULL,'76'),(55,'Chapin and Gore','187','148','63','Adams','1904','Schmidt',NULL,'1',NULL,NULL,'','','','Chicago','','','55','Illinois','extant',NULL,NULL,'77'),(56,'Charleston, SC','','','','',NULL,'','',NULL,NULL,NULL,'','','','Chicago','','Not a building','56','Illinois','demolished',NULL,NULL,NULL),(57,'Chemical Works','204','','','','1912','Byrne','?',NULL,'1',NULL,'','','','Luban, Poland','','','57','foreign',NULL,NULL,NULL,'78'),(58,'Chestnut Street Theater','','','','','1822','Strickland','?',NULL,'1',NULL,'','','','Philadelphia','','','58','USA',NULL,NULL,NULL,'79'),(59,'Chicago Building','175','135','-7','Madison','1904','Holabird & Roche ',NULL,'1',NULL,NULL,'ChicagoBldg.jpg','','Chicago Saving Bank','Chicago','','','59','Illinois','extant',NULL,NULL,'81'),(60,'Chicago, University of','60','','','',NULL,'','',NULL,NULL,NULL,'','','','Chicago','','not a building: the first group of buildings by Cobb, none specified','60','Illinois','demolished',NULL,NULL,NULL),(61,'Chicago Beach Hotel','156','','-5101','Cornell','1890','Starrett and Fuller','1946-1950',NULL,'3',NULL,'','','','Chicago','http://en.wikipedia.org/wiki/Chicago_Beach_Hotel','architects not known with certainty; online sites suggest this was demolished in the late 1940s, but CWC says still standing in 1963','61','Illinois','demolished','1946','1950','80'),(62,'Chicago Business College','178','141','-207','Wabash','1910','Burnham, D.H., & Co.','1995','1',NULL,NULL,'','','','Chicago','http://digital-libraries.saic.edu/cdm/search/collection/mqc/searchterm/Adams-Wabash%20Building/mode/exact','','62','Illinois','demolished','1995','1995','82'),(63,'Chicago Club','56','','-400','Michigan','1882','Burnham & Root','1929',NULL,'2',NULL,'','','','Chicago','','','63','Illinois','demolished','1929','1929','83'),(64,'Chicago Cold Storage Exchange','135','','-300','Lake','1891','Sullivan','1902','1',NULL,NULL,'','','','Chicago','','','64','Illinois','demolished','1902','1902','84'),(65,'Chicago Garment Center','94','','-339','Franklin','1904','Jenney','1975','1',NULL,NULL,'','','Hirsch-Wickwire','Chicago','','Info. from Randall','65','Illinois','demolished','1975','1975','85'),(66,'Chicago Herald','137','','-161','Washington','1891','Burnham & Root','1936',NULL,'0',NULL,'','','','Chicago','','Info. from Randall','66','Illinois','demolished','1936','1936','86'),(67,'Chicago Joint Board','','','','',NULL,'','',NULL,NULL,NULL,'','Troescher','','Chicago','','','67','Illinois','demolished',NULL,NULL,'87'),(68,'Chicago Journal','','','','',NULL,'','',NULL,NULL,NULL,'','Troescher','','Chicago','','','68','Illinois','demolished',NULL,NULL,'88'),(69,'Chicago Opera House','59','18','132','Clark','1884','Cobb & Frost','1912',NULL,NULL,'1','','','','Chicago','','','69','Illinois','demolished','1912','1912','89'),(70,'Church, Thomas Building','213','','-32','Wabash','1903','Hill & Woltersdorf',NULL,NULL,'0',NULL,'','','','Chicago','http://www.emporis.com/building/sullivan-center-east-annex-chicago-il-usa','','70','Illinois','extant',NULL,NULL,'93'),(71,'Civic Center','219','195','-50','Washington','1963','C.F. Murphy Associates',NULL,NULL,'1',NULL,'','','','Chicago','','','71','Illinois','extant',NULL,NULL,'94'),(72,'Civic Opera','75','','20','Wacker','1928','Grahm, Anderson, Probst & White',NULL,NULL,'1',NULL,'','','','Chicago','','','72','Illinois','extant',NULL,NULL,'95'),(73,'Cleveland, Grover Elementary School','201','163','3850','Albany','1911','Perkins',NULL,'1',NULL,NULL,'','','','Chicago','','','73','Illinois','extant',NULL,NULL,'96'),(74,'Columbus Park Boathouse','211','182','','','1920','Van Bergen','',NULL,'2',NULL,'','','','Chicago','','Not a building: design never built','74','Illinois','demolished',NULL,NULL,NULL),(75,'Comstock Houses','210','177-178','1632','Ashland','1912','Griffin',NULL,'1',NULL,NULL,'','','','Evanston','','','75','Illinois','extant',NULL,NULL,'98'),(76,'Condict','','','','',NULL,'','',NULL,NULL,NULL,'','Bayard','','New York','','','76','USA','demolished',NULL,NULL,'99'),(77,'Congregational, First Church of Austin','209','173','-5701','Midway Park','1908','Drummond',NULL,'1',NULL,NULL,'','','West Central Church','Chicago','','','77','Illinois','extant',NULL,NULL,'100'),(78,'Congress Hotel','154','116-117','-520','Michigan ','1892','Warren; Holabird & Roche',NULL,NULL,NULL,'2','CongressHotel.jpg','','','Chicago','','','78','Illinois','extant',NULL,NULL,'101'),(79,'Continental Bank','','','','',NULL,'','',NULL,NULL,NULL,'','Insurance Exchange','','Chicago','','','79','Illinois','demolished',NULL,NULL,'102'),(80,'Continental Center','219','194','55','Jackson','1961','C.F. Murphy Associates',NULL,NULL,'1',NULL,'','','CNA Plaza','Chicago','','','80','Illinois','extant',NULL,NULL,'103'),(81,'Coonley house','184','','281','Bloomingbank Rd','1908','Wright',NULL,NULL,'1',NULL,'','','','Riverside','http://en.wikipedia.org/wiki/Coonley_House','','81','Illinois','extant',NULL,NULL,'106'),(82,'Coonley, Avery, Kindergarten','203','','','','1910','Wright',NULL,NULL,'1',NULL,'','','','Riverside','http://en.wikipedia.org/wiki/The_Avery_Coonley_School#Founding_and_Cottage_School_.281906.E2.80.931916.29','','82','Illinois','extant',NULL,NULL,'105'),(83,'Cooper Union','20','','','','1859','','?',NULL,NULL,NULL,'','','','New York','http://en.wikipedia.org/wiki/Cooper_Union','','83','USA',NULL,NULL,NULL,'107'),(84,'Counselman','57','','-230','La Salle','1884','Burnham & Root','1920',NULL,'2',NULL,'','','','Chicago','','','84','Illinois','demolished','1920','1920','108'),(85,'Crane, first','166','','-1201','Canal','1903','Sullivan','1912',NULL,'2',NULL,'','','','Chicago','','','85','Illinois','demolished','1912','1912','109'),(86,'Crane, second','177','','-836','Michigan ','1912','Holabird & Roche ',NULL,NULL,'1',NULL,'','','','Chicago','http://www.chicagoarchitecture.info/Building/2340/Crane-Company-Building.php','','86','Illinois','extant',NULL,NULL,'110'),(87,'Crerar Library','96','','150','Michigan','1920','Holabird & Roche ','1981',NULL,'1',NULL,'','','','Chicago','http://www.lib.uchicago.edu/e/crerar/corpmem/pdf/Crerar%20L.pdf;http://www.emporis.com/building/johncrerarlibrary-chicago-il-usa','','87','Illinois','demolished','1981','1981','111'),(88,'Crown','','','','',NULL,'','',NULL,NULL,NULL,'','McClurg','','Chicago','','','88','Illinois','demolished',NULL,NULL,'112'),(89,'Crown Hall','218','190','-3360','State','1955','Mies van der Rohe',NULL,NULL,'1',NULL,'','','','Chicago','','','89','Illinois','extant',NULL,NULL,'113'),(90,'Crystal Palace, London','','','','',NULL,'','?',NULL,NULL,NULL,'','','','London','','','90','foreign',NULL,NULL,NULL,'114'),(91,'Crystal Palace, New York','','','','',NULL,'','?',NULL,NULL,NULL,'','','','New York','','','91','USA',NULL,NULL,NULL,'115'),(92,'Daily News, Chicago','177','','-400','Madison','1929','Holabird & Root',NULL,NULL,'1',NULL,'','','2 N. Riverside Plaza','Chicago','','Info. from Randall, though Randall has architects Holabird & Roche, appearing to be a typo','92','Illinois','extant',NULL,NULL,'116'),(93,'Daily News, New York','192','','','',NULL,'Hood','?',NULL,NULL,NULL,'','','','New York','','','93','USA',NULL,NULL,NULL,'117'),(94,'Decker, Alfred and Cohn','','','','',NULL,'','',NULL,NULL,NULL,'','Society Brand','','Chicago','','','94','Illinois','demolished',NULL,NULL,'119'),(95,'Dexter','58','17','-39','Adams','1883','Warren; Burnham & Root','1961','1',NULL,NULL,'','','','Chicago','','','95','Illinois','demolished','1961','1961','120'),(96,'Dexter, Wirt','41','12','-630','Wabash','1887','Adler & Sullivan','2006','1',NULL,NULL,'','','','Chicago','http://en.wikipedia.org/wiki/Dexter_Building','Burned accidently in 2006','96','Illinois','demolished','2006','2006','121'),(97,'Dixon, Arthur','180','','-411','Wells','1908','Nimmons & Fellows',NULL,'1',NULL,NULL,'','','','Chicago','http://www.chicagoarchitecture.info/Building/3087/Dixon-Building.php','','97','Illinois','extant',NULL,NULL,'123'),(98,'Dwight','194','154','-626','Clark','1911','Schmidt, Garden, & Martin',NULL,NULL,'3',NULL,'','','','Chicago','','','98','Illinois','extant',NULL,NULL,'124'),(99,'Edison','183','145','-229','Wabash','1912','Purcell, Feick, & Elmslie','1967',NULL,NULL,'1','','','229 South Wabash; Edison Phonograph Shop','Chicago','http://www.loc.gov/pictures/item/il0111/','Demolition date from Randall','99','Illinois','demolished','1967','1967','125'),(100,'Eiffel Tower','','','','',NULL,'','?',NULL,NULL,NULL,'','','','Paris','','','100','foreign',NULL,NULL,NULL,'127'),(101,'860-880 North Lake Shore Drive','214','','870','Lake Shore Drive','1952','Mies van der Rohe',NULL,NULL,'1',NULL,'','','','Chicago','http://en.wikipedia.org/wiki/860%E2%80%93880_Lake_Shore_Drive_Apartments','','101','Illinois','extant',NULL,NULL,'20'),(102,'Equitable','','','','',NULL,'','',NULL,NULL,NULL,'','Kendall','','Chicago','','','102','Illinois','demolished',NULL,NULL,'128'),(103,'Esquire Theater','129','','58','Oak','1938','Pereira',NULL,NULL,'0',NULL,'','','','Chicago','','','103','Illinois','extant',NULL,NULL,'129'),(104,'E-Z Polish Company Factory','192','','-3005','Carroll','1905','Wright',NULL,NULL,'1',NULL,'','','','Chicago','http://en.wikipedia.org/wiki/E-Z_Polish_Factory','','104','Illinois','extant',NULL,NULL,'130'),(105,'factories, built by Boulton and Watt','6','','','',NULL,'','?',NULL,NULL,NULL,'','','','England','','Not a building; several factories at unspecified locations','105','foreign',NULL,NULL,NULL,NULL),(106,'Fair Store','','49-51','-16','Adams','1890','Jenney','1984','2',NULL,NULL,'','','','Chicago','tigger.uic.edu/depts/ahaa/imagebase/intranet/chiviews/1984','','106','Illinois','demolished','1984','1984','131'),(107,'Farwell, Charles B., Store','21','','171','Wabash','1864','Van Osdel','1872',NULL,'1',NULL,'','','','Chicago','Frank Alfred and John Randall 1999','','107','Illinois','demolished','1872','1872','132'),(108,'Farwell, J.V., warehouse','24','','-350','Monroe??','1882','Van Osdel','1954',NULL,'1',NULL,'','','','Chicago','http://tigger.uic.edu/depts/ahaa/imagebase/intranet/chiviews/page187.html;http://www.encyclopedia.chicagohistory.org/pages/2660.html','An earlier Farwell block is in one diagram; info. from Randall','108','Illinois','demolished','1954','1954','133'),(109,'Federal Office','59','','-219','Dearborn','1961','Mies van der Rohe',NULL,NULL,'0',NULL,'','','Dirksen Federal Office','Chicago','','','109','Illinois','extant',NULL,NULL,'134'),(110,'Felsenthal Store','166','','701','Forth-seventh','1905','Sullivan','1982',NULL,'2',NULL,'','','','Chicago','http://www.artic.edu/aic/resources/resource/2054?search_id=1&index=0','','110','Illinois','demolished','1982','1982','135'),(111,'Field','214','','-135','La Salle','1934','Graham, Anderson, Probst, & White',NULL,NULL,'0',NULL,'','','LaSalle National Bank','Chicago','','','111','Illinois','extant',NULL,NULL,'136'),(112,'Field, Marshall, Store','114; also 178','','-137','State','1901','Burnham',NULL,NULL,'2',NULL,'','','','Chicago','','','112','Illinois','extant',NULL,NULL,'139'),(113,'Field, Marshall, Wholesale Store','60','20','-200','Wells','1885','Richardson','1930',NULL,NULL,'2','','','','Chicago','','','113','Illinois','demolished','1930','1930','140'),(114,'Field and Leiter Store','89','','103','State','1878','??','1902',NULL,'0',NULL,'','','','Chicago','','3 STORES OCCUPIED THIS SITE PRIOR TO THE LAST; FIRST 2 BURNED','114','Illinois','demolished','1902','1902','137'),(115,'Field and Leiter Wholesale Store','61','','-330','Madison','1872','??','1885',NULL,'0',NULL,'','','','Chicago','','','115','Illinois','demolished','1885','1885','138'),(116,'Field Museum','','','','',NULL,'','',NULL,NULL,NULL,'','Museum of Natural History','','Chicago','','','116','Illinois','demolished',NULL,NULL,'141'),(117,'5730 Sheridan Road house','211','181','5730','Sheridan','1914','Van Bergen','1960',NULL,'2',NULL,'','','','Chicago','','','117','Illinois','demolished','1960','1960','16'),(118,'Fine Arts, World\'s Columbian Exposition','96','','-5700','Lake Shore Drive','1892','Atwood',NULL,NULL,'1',NULL,'','','Museum of Science and Industry','Chicago','','Reconstructed in 1932','118','Illinois','extant',NULL,NULL,'142'),(119,'First National Bank','112','','-80','Monroe','1896','Burnham, D.H., & Co.','1969',NULL,'3',NULL,'','','','Chicago','','','119','Illinois','demolished','1969','1969','143'),(120,'Fisher','113','68','-343','Dearborn','1896','Burnham, D.H., & Co.',NULL,'2',NULL,NULL,'Fisher.JPG;OldColonyFisherMonadnock.JPG','','','Chicago','','','120','Illinois','extant',NULL,NULL,'144'),(121,'Flatiron','108','','','',NULL,'','?',NULL,NULL,NULL,'','','','New York','','','121','USA',NULL,NULL,NULL,'145'),(122,'Florida Southern College','197','','','',NULL,'','',NULL,NULL,NULL,'','','','Lakeland, FL','','Not a building: campus plan by Wright','122','USA','demolished',NULL,NULL,NULL),(123,'Francis Apartments','158','122','-4304','Forrestville','1895','Wright','1971',NULL,'3',NULL,'','','','Chicago','','','123','Illinois','demolished','1971','1971','148'),(124,'Frankenthal','42','','-141','Wells','1882','Adler & Sullivan','<1950',NULL,'1',NULL,'','','','Chicago','Richard Cahan 1994','','124','Illinois','demolished','1882','1950','149'),(125,'Gage','141','80-81','-18','Michigan','1898','Holabird & Roche; Sullivan',NULL,'3',NULL,NULL,'GageGroup.JPG','','','Chicago','','3 GAGE BLDS APPEAR AS 1 ENTRY IN INDEX','125','Illinois','extant',NULL,NULL,'150'),(126,'garage, Monroe Street','213','185','20','Monroe','1940','Kroman',NULL,NULL,'3',NULL,'','','','Chicago','','Former garage was merged with the Carson Pirie Scott Annex in 1950','128','Illinois','extant',NULL,NULL,'153'),(127,'Garden City Plating and Manufacturing Company factory','194','','','Tallmadge & Ogden','1910','Schmidt, Garden, & Martin','?',NULL,'3',NULL,'','','','Chicago','','CAN\'T FIND; NO TALLMADGE NOR TALMADGE IN CHICAGO','129','Illinois',NULL,NULL,NULL,'154'),(128,'Garden City Warehouse','58','','-320','Jackson','1880','Smith, M. Randolph','1965',NULL,'1',NULL,'','','','Chicago','http://www.loc.gov/pictures/item/il0104/','Info. from Randall','130','Illinois','demolished','1965','1965','155'),(129,'Garrick Theater','128','5,65,87-90','-64','Randolph','1891','Adler & Sullivan','1961',NULL,NULL,'5','','','','Chicago','','','131','Illinois','demolished','1961','1961','156'),(130,'Geneva Apartments','149','','??','Rush','1884','Adler & Sullivan','?',NULL,'1',NULL,'','','','Chicago','','','132','Illinois',NULL,NULL,NULL,'157'),(131,'Glessner House','60','19','-1800','Prarie','1886','Richardson',NULL,NULL,'1',NULL,'','','','Chicago','','','133','Illinois','extant',NULL,NULL,'158'),(132,'Graham Paper Company','','','','',NULL,'','',NULL,NULL,NULL,'','Kelley, Maus and Company warehouse','','Chicago','','','134','Illinois','demolished',NULL,NULL,'159'),(133,'Great Lakes','177','','180','Wacker','1912','Holabird & Roche ',NULL,NULL,'1',NULL,'','','180 N Wacker','Chicago','','I asked at artefaqs.com and got a reply saying yes, the current structure at the site is the Great Lakes Bldg','135','Illinois','extant',NULL,NULL,'160'),(134,'Great Northern Hotel','101','60','-237','Dearborn','1890','Burnham & Root','1940',NULL,NULL,'1','','','','Chicago','','','136','Illinois','demolished','1940','1940','161'),(135,'Great Northern Theater','109','60','-20','Jackson','1896','Burnham & Root','1961','1',NULL,NULL,'','','','Chicago','','','137','Illinois','demolished','1961','1961','162'),(136,'Grommes and Ulrich Company Warehouse','187','','-108','Illinois','1901','Schmidt',NULL,'1',NULL,NULL,'','','Long, W.H., Company','Chicago','http://dimbeautyofchicago.blogspot.com/2010/01/grommes-and-ullrich.html','','138','Illinois','extant',NULL,NULL,'163'),(137,'Guaranty','138','100','','',NULL,'','?',NULL,NULL,NULL,'','','Prudential (Buffalo)','Buffalo','','','139','USA',NULL,NULL,NULL,'164'),(138,'Hammond Library','42','','44','Ashland','1882','Burnham & Root','1963',NULL,'0',NULL,'','','Union Theological College','Chicago','http://www.loc.gov/pictures/item/il0115/','','140','Illinois','demolished','1963','1963','165'),(139,'Harper and Brothers','20','','','',NULL,'','?',NULL,NULL,NULL,'','','','New York','','','141','USA',NULL,NULL,NULL,'166'),(140,'Hartford Fire Insurance','218','193','-100','Wacker','1961','Skidmore, Owings, & Merrill',NULL,NULL,'2',NULL,'','','','Chicago','','','142','Illinois','extant',NULL,NULL,'167'),(141,'Healy Chapel','185','','','','1926','Elmslie',NULL,NULL,'3',NULL,'','','','Aurora','http://en.wikipedia.org/wiki/Healy_Chapel','','143','Illinois','extant',NULL,NULL,'168'),(142,'Henrotin Hospital','191','','-111','Oak','1906','Schmidt','1933','1',NULL,NULL,'','','','Chicago','http://articles.chicagotribune.com/1986-10-02/news/8603140315_1_fourth-hospital-general-community-hospital-facility','Tribune article is about later building (Randall precise on both)','144','Illinois','demolished','1933','1933','169'),(143,'Heyworth','114','','29','Madison','1905','Burnham, D.H., & Co.',NULL,'1',NULL,NULL,'','','','Chicago','','','145','Illinois','extant',NULL,NULL,'170'),(144,'Hollywood Towers','219','','5701','Sheridan','1962','Solomon and Cordwell',NULL,NULL,'1',NULL,'','','','Chicago','','','146','Illinois','extant',NULL,NULL,'172'),(145,'Home Federal Savings and Loan','175','','','',NULL,'','',NULL,NULL,NULL,'','Republic','','Chicago','','','147','Illinois','demolished',NULL,NULL,'173'),(146,'Home Insurance','80','44-45','-135','La Salle','1885','Jenney','1931',NULL,NULL,'7','','','','Chicago','','','148','Illinois','demolished','1931','1931','174'),(147,'Hoops','','','','',NULL,'','',NULL,NULL,NULL,'','Cable','','Chicago','','','149','Illinois','demolished',NULL,NULL,'175'),(148,'Horstman. William H. and Sons factory','39','','','','1853','Hoxie','?',NULL,'1',NULL,'','','','Philadelphia','','','150','USA',NULL,NULL,NULL,'176'),(149,'Horticultural, World Columbian Exposition','29','','','Jackson Park (Exposition)','1893','Jenney','1894',NULL,'0',NULL,'','','','Chicago','','','151','Illinois','demolished','1894','1894','177'),(150,'Horton house','23','','','??','1868','??','?',NULL,'1',NULL,'','','','Chicago','','No information given about location or architect','152','Illinois',NULL,NULL,NULL,'178'),(151,'Hull, Charles, house','206','','-800','Halsted','1856','??',NULL,NULL,NULL,'2','','','','Chicago','','','153','Illinois','extant',NULL,NULL,'179'),(152,'Hull House group','206','170','-800','Halsted','1890','Pond brothers','1964',NULL,NULL,'2','','','','Chicago','','10 bldgs built over 1890-1908; 1 of 10 preserved and moved a short distance','154','Illinois','demolished','1964','1964','180'),(153,'Humboldt Park boathouse','193','153','1355','Sacramento','1907','Garden',NULL,NULL,'3',NULL,'','','','Chicago','http://www.bauerlatozastudio.com/portfolio/historic-preservation/humboldt-park-boat-house/','','155','Illinois','extant',NULL,NULL,'181'),(154,'Hungerford Fish Market','67','','','',NULL,'','?',NULL,NULL,NULL,'','','','London','','','156','foreign',NULL,NULL,NULL,'182'),(155,'Hunter','177','140','-337','Madison','1908','Eckstrom','1978','1',NULL,NULL,'','','Liberty Mutual Insurance','Chicago','Frank A. and John Randall 1999, p. 269','','157','Illinois','demolished','1978','1978','183'),(156,'Hyde Park Hotel','150','109-111','1520','Hyde Park Blvd','1888','Starrett','1963',NULL,NULL,'2','','','','Chicago','','','158','Illinois','demolished','1963','1963','184'),(157,'Illinois Bank','57','','21','Dearborn','1886','Burnham & Root','1933',NULL,'3',NULL,'','','','Chicago','','CWC says on La Salle, without address; seems likely this is really 21 N. Dearborn, since Randall says Illinois Bank was previous name for Union Bank on Dearborn, and year and architects match','159','Illinois','demolished','1933','1933','185'),(158,'Illinois Institute of Technology','218','','','',NULL,'','',NULL,NULL,NULL,'','','','Chicago','','not a building: general reference to the overall campus designs','160','Illinois','demolished',NULL,NULL,NULL),(159,'Immaculata High School','204','167-168','-640','Irving Park','1922','Byrne',NULL,'1',NULL,NULL,'','','','Chicago','','','161','Illinois','extant',NULL,NULL,'188'),(160,'Imperial Hotel','210','','','',NULL,'','?',NULL,NULL,NULL,'','','','Tokyo','','','162','foreign',NULL,NULL,NULL,'189'),(161,'Inland Steel','218','192','-30','Monroe','1957','Skidmore, Owings, & Merrill',NULL,NULL,'2',NULL,'','','','Chicago','http://www.emporis.com/building/inlandsteelbuilding-chicago-il-usa','','163','Illinois','extant',NULL,NULL,'190'),(162,'Insurance Exchange','57','58','-208','La Salle','1885','Burnham & Root','1912','1',NULL,NULL,'','','Continental Bank','Chicago','','','164','Illinois','demolished','1912','1912','191'),(163,'International Leather and Belting Company factory','184','146','','??','1918','Purcell & Elmslie','?','2',NULL,NULL,'','','','Chicago','','No location given','165','Illinois',NULL,NULL,NULL,'192'),(164,'Isabella','93','','21','Van Buren','1893','Jenney','2003-2013','1',NULL,NULL,'','','','Chicago','http://www.preservationchicago.org/userfiles/file/2004-Chicago-7-Isabella-Building.pdf','Randall does not give demolition date, and preservation document from 2003, a parking lot in 2013','166','Illinois','demolished','2003','2013','193'),(165,'Jayne','38','','','','1850','Johnston & Walter','?',NULL,NULL,NULL,'','','','Philadelphia','','','167','USA',NULL,NULL,NULL,'194'),(166,'Jeweler\'s','39','7','-15','Wabash','1882','Adler & Sullivan',NULL,NULL,'2',NULL,'Jewelers(BadQuality).JPG','','','Chicago','','','168','Illinois','extant',NULL,NULL,'195'),(167,'Johnson, S.C., and Company research tower','219','','','','1950','Wright','?',NULL,NULL,NULL,'','','','Racine','','','169','USA',NULL,NULL,NULL,'196'),(168,'Katahdin','','','','',NULL,'','',NULL,NULL,NULL,'','Monadnock addition','','Chicago','','','170','Illinois','demolished',NULL,NULL,'197'),(169,'Kelley, Maus and Company warehouse','189','','-405','Lake','1903','Hunt','1963-1990',NULL,NULL,'1','','','','Chicago','','Evidently still standing in 1963, but gone in 2013; Randall gives demolition over 1950-1990','171','Illinois','demolished','1963','1990','198'),(170,'Kendall','24','','40','Dearborn','1871','Van Osdel','1940','1',NULL,NULL,'','','','Chicago','','','172','Illinois','demolished','1940','1940','199'),(171,'Kenilworth Club','195','156','410','Kenilworth','1906','Maher',NULL,'1',NULL,NULL,'','','','Kenilworth','','','173','Illinois','extant',NULL,NULL,'200'),(172,'Kennedy Bakery','39','','27','Des Plaines','1884','Adler & Sullivan','1972',NULL,'2',NULL,'','','Pettibone Printing Company','Chicago','Randall & Randall, 1999, The History of Development of Building Construction in Chicago, p. 109','','174','Illinois','demolished','1972','1972','201'),(173,'Kent','205','','-415','Franklin','1903','Pond brothers','1950-1953',NULL,'0',NULL,'','','','Chicago','','Demolition date from Randall','175','Illinois','demolished','1950','1953','202'),(174,'Knisely','40','','-551','Monroe','1884','Adler & Sullivan','1956-1959',NULL,'3',NULL,'','','','Chicago','http://digital-libraries.saic.edu/cdm/singleitem/collection/mqc/id/28933/rec/33','Demolition date from Randall','176','Illinois','demolished','1956','1959','203'),(175,'Krause Music Store','166','130','4611','Lincoln','1922','Sullivan',NULL,NULL,'2',NULL,'','','','Chicago','','','177','Illinois','extant',NULL,NULL,'204'),(176,'Kuppenheimer','','','','',NULL,'','',NULL,NULL,NULL,'','Kent','','Chicago','','','178','Illinois','demolished',NULL,NULL,'205'),(177,'La Salle-Jackson','57','','-111','Jackson','1961','Epstein & Sons',NULL,NULL,'0',NULL,'','','Transunion','Chicago','http://www.emporis.com/building/transunionbuilding-chicago-il-usa','No information given about this building, only that it replaced the Phoenix','179','Illinois','extant',NULL,NULL,'212'),(178,'La Salle-Monroe','24','','-37','La Salle','1894','Jenney & Mundie ',NULL,NULL,'0',NULL,'','','','Chicago','http://www.emporis.com/building/lasallemonroebuilding-chicago-il-usa','Little given about this building, only that it replaced the Nixon','180','Illinois','extant',NULL,NULL,'213'),(179,'Lafayette Apartments','149','','??','Dearborn','1887','??','?',NULL,'1',NULL,'','','','Chicago','','Not enough information to locate','181','Illinois',NULL,NULL,NULL,'206'),(180,'Lake Shore Club','189','','850','Lake Shore Drive','1924','Hunt',NULL,NULL,'0',NULL,'','','','Chicago','http://www.chicagoarchitecture.info/Building/3106/Lake-Shore-Athletic-Club.php','','182','Illinois','extant',NULL,NULL,'207'),(181,'Lakeside','31','','-111','Adams','1873','Jenney','1926',NULL,'2',NULL,'','','','Chicago','http://www.davidrumsey.com/maps3374.html','Demolition date from Randall','183','Illinois','demolished','1926','1926','208'),(182,'Lakota Hotel','157','118','-3001','Michigan','1893','Warren?','1959',NULL,'3',NULL,'','','Lewis Memorial Hospital','Chicago','http://forgottenchicago.com/forum/5/3593/lewis_memorial_maternity_hospital','','184','Illinois','demolished','1959','1959','209'),(183,'Langdon Apartments','159','','??','Des Plaines','1903','Perkins','?',NULL,'3',NULL,'','','','Chicago','','','185','Illinois',NULL,NULL,NULL,'210'),(184,'Larkin','165','','','','1905','Wright','1950',NULL,NULL,NULL,'','','','Buffalo','','','186','USA','demolished','1950','1950','211'),(185,'Leiter, first','79','40-41','-200','Monroe','1879','Jenney','1972',NULL,NULL,'1','','','','Chicago','','','187','Illinois','demolished','1972','1972','215'),(186,'Leiter, second','89','48','-401','State','1891','Jenney',NULL,NULL,NULL,'2','LeiterII.jpg','','Sears Roebuck Store','Chicago','','','188','Illinois','extant',NULL,NULL,'216'),(187,'Leland','38','','','','1855','','?',NULL,NULL,NULL,'','','','Philadelphia','','','189','USA',NULL,NULL,NULL,'217'),(188,'Lemoyne','178','143','180','Wabash','1915','Mundie, Jensen, and McClurg',NULL,'1',NULL,NULL,'','','','Chicago','','','190','Illinois','extant',NULL,NULL,'218'),(189,'Lexington Hotel','','','','',NULL,'','',NULL,NULL,NULL,'','Michigan, New, Hotel','','Chicago','','','191','Illinois','demolished',NULL,NULL,'220'),(190,'Liberty Mutual','','','','',NULL,'','',NULL,NULL,NULL,'','Hunter','','Chicago','','','192','Illinois','demolished',NULL,NULL,'221'),(191,'Lincoln, Abraham, Center','200','','-700','Oakwood','1903','Perkins; Wright',NULL,'1',NULL,NULL,'','','','Chicago','http://www.thefranklloydwrighttour.com/apps/blog/show/5620904-abraham-lincoln-center-frank-lloyd-wright-dwight-perkins-1905','','193','Illinois','extant',NULL,NULL,'223'),(192,'Lincoln Park Zoo Pavilions','214','186-187','-225','Fullerton','1936','Chicago Park District; Alfred Caldwell',NULL,NULL,'5',NULL,'','','','Chicago','','','194','Illinois','extant',NULL,NULL,'224'),(193,'Lind','20','','-350','Randolph','1852','??','1963',NULL,'2',NULL,'','','','Chicago','','','195','Illinois','demolished','1963','1963','225'),(194,'Linthicum house','208','171','1315','Forest','1908','Tallmadge and Watson',NULL,NULL,'1',NULL,'','','','Evanston','','','196','Illinois','extant',NULL,NULL,'226'),(195,'Lloyd','20','','-200','Randolph','1855','??','1871',NULL,'2',NULL,'','','','Chicago','J.W. Sheahan (1871) The great conflagration...Chicago','destroyed in fire','197','Illinois','demolished','1871','1871','227'),(196,'Long, W.H., Company','','','','',NULL,'','',NULL,NULL,NULL,'','Grommes and Ulrich Company Warehouse','','Chicago','','','198','Illinois','demolished',NULL,NULL,'228'),(197,'Lord\'s Store','186','147','625','Davis','1906','Walter','<2013',NULL,'2',NULL,'','','625 Davis Street','Evanston','','part of Lord\'s store, along with Witkower','199','Illinois','demolished','1906','2013','229'),(198,'Lorimer Baptist Church','209','174','-7291','St. Laurance','1914','Drummond',NULL,NULL,'2',NULL,'','','','Chicago','','','200','Illinois','extant',NULL,NULL,'230'),(199,'Ludington','92','56','-1104','Wabash','1891','Jenney',NULL,'1',NULL,NULL,'','','','Chicago','','','201','Illinois','extant',NULL,NULL,'231'),(200,'McClurg','126','85','-218','Wabash','1900','Holabird & Roche ',NULL,'1',NULL,NULL,'McClurg.JPG','','','Chicago','','','202','Illinois','extant',NULL,NULL,'239'),(201,'McCormick, Leander, Apartments','','','','',NULL,'','',NULL,NULL,NULL,'','Virginia Hotel','','Chicago','','','203','Illinois','demolished',NULL,NULL,'240'),(202,'McCormick Place','156','','-2300','Lake Shore Drive','1960','Shaw, Metz & Dolio','1967',NULL,'0',NULL,'','','','Chicago','','burned 1967','204','Illinois','demolished','1967','1967','241'),(203,'McCullough Shot and Lead Co. Tower','81','','','','1855','Bogardus','?',NULL,NULL,NULL,'','','','New York','','','205','USA',NULL,NULL,NULL,'242'),(204,'McGraw Hill','190','','','','1930','Root','1998',NULL,NULL,NULL,'','','','New York','','','206','USA','demolished','1998','1998','243'),(205,'McVickers Theater','40','10','-25','Madison','1885','Adler & Sullivan','1922','2',NULL,NULL,'','','','Chicago','','','207','Illinois','demolished','1922','1922','244'),(206,'Maison Clarté, Geneva','147','','','','1933','Le Corbusier',NULL,NULL,NULL,NULL,'','','','Geneva','','','208','foreign','extant',NULL,NULL,'232'),(207,'Majestic Hotel','108','66','189','Madison','1893','Burnham','1961','2',NULL,NULL,'','','','Chicago','','','209','Illinois','demolished','1961','1961','233'),(208,'Mandel Store Annex','176','138','2','Wabash','1900','Holabird & Roche ',NULL,'1',NULL,NULL,'','','','Chicago','','2 sections mentioned which appear to be 2 buildings as described by Randall','210','Illinois','extant',NULL,NULL,'234'),(209,'Manhattan','91','52-54','-431','Dearborn','1891','Jenney & Mundie ',NULL,NULL,NULL,'2','Manhattan.JPG','','','Chicago','','','211','Illinois','extant',NULL,NULL,'235'),(210,'Marina City','219','','300','Dearborn','1963','Goldberg',NULL,NULL,'2',NULL,'','','','Chicago','','','212','Illinois','extant',NULL,NULL,'236'),(211,'Marquette','120','74-75','-140','Dearborn','1894','Holabird & Roche ',NULL,NULL,NULL,'2','Marquette.JPG;MarquetteReflection.JPG;MarquetteLobby.JPG','','','Chicago','','','213','Illinois','extant',NULL,NULL,'237'),(212,'Masonic Temple','104','64-65','151','State','1892','Burnham & Root','1939',NULL,NULL,'3','','','Capitol','Chicago','','','214','Illinois','demolished','1939','1939','238'),(213,'Mecca Apartments','156','','-3401','State','1892','Edbrooke & Burnham','1952',NULL,'4',NULL,'','','','Chicago','http://www.wbez.org/blogs/lee-bey/2012-06/storied-mecca-apartments-live-again-thanks-life-magazine-archives-100301','','215','Illinois','demolished','1952','1952','245'),(214,'Medinah','111','','-176','Jackson','1893','Beers, Clay & Dutton','1969',NULL,'1',NULL,'','','','Chicago','','','216','Illinois','demolished','1969','1969','246'),(215,'Menier Chocolate Works','7','','','','1872','Saulnier',NULL,NULL,'2',NULL,'','','','Noisiel, France','http://en.wikipedia.org/wiki/Menier_Chocolate;http://www.greatbuildings.com/buildings/Menier_Factory.html','','217','foreign','extant',NULL,NULL,'248'),(216,'Methodist Episcopal Church of Maywood','209','','-502','Sixth','1912','Drummond',NULL,NULL,'2',NULL,'','','Christ Temple Church of the Apostolic Faith','Maywood','http://www.flickr.com/photos/chicagogeek/sets/72157632852890837/detail/','','218','Illinois','extant',NULL,NULL,'249'),(217,'Metropole Hotel','153','113','-2281','Michigan','1891','Warren','1994','1',NULL,NULL,'','','','Chicago','','','219','Illinois','demolished','1994','1994','250'),(218,'Metropolitan Fair and Exposition','78','','','',NULL,'','',NULL,NULL,NULL,'','McCormick Place','','Chicago','','','220','Illinois','demolished',NULL,NULL,'251'),(219,'Meyer','135','92','-301','Van Buren','1893','Adler & Sullivan','1968','1',NULL,NULL,'','','','Chicago','','','221','Illinois','demolished','1968','1968','252'),(220,'Michigan Ave-Wacker Drive group','216','','','',NULL,'','',NULL,NULL,NULL,'','','','Chicago','','Not a building; the group along the river, none specified or described','222','Illinois','demolished',NULL,NULL,NULL),(221,'Michigan, New, Hotel','153','114','-2135','Michigan','1892','Warren','1995','1',NULL,NULL,'','','Lexington Hotel','Chicago','http://www.encyclopedia.chicagohistory.org/pages/738.html','','223','Illinois','demolished','1995','1995','253'),(222,'Michigan Terrace Apts','219','','535','Michigan','1963','Raggie & Malitz',NULL,NULL,'1',NULL,'','','','Chicago','','','224','Illinois','extant',NULL,NULL,'254'),(223,'Midway Gardens','205','','-6000','Cottage Grove','1914','Wright','1929',NULL,'0',NULL,'','','','Chicago','http://en.wikipedia.org/wiki/Midway_Gardens','','225','Illinois','demolished','1929','1929','255'),(224,'Mills','140','','220','Montgomery','1882','Burnham & Root',NULL,NULL,'0',NULL,'','','','San Francisco','','','226','USA','extant',NULL,NULL,'256'),(225,'Monadnock','65','28-30','-53','Jackson','1891','Burnham & Root',NULL,NULL,NULL,'4','Monadnock.JPG;OldColonyFisherMonadnock.JPG','','','Chicago','','','227','Illinois','extant',NULL,NULL,'258'),(226,'Monadnock addition','118','72','-332','Dearborn','1893','Holabird & Roche ',NULL,'2',NULL,NULL,'','','Katahdin','Chicago','','','228','Illinois','extant',NULL,NULL,'259'),(227,'Monadnock and Kearsage','','','','',NULL,'','',NULL,NULL,NULL,'','Monadnock','','Chicago','','','229','Illinois','demolished',NULL,NULL,'260'),(228,'Monarch Foods Company','','','','',NULL,'','',NULL,NULL,NULL,'','Reid, Murdoch and Company','','Chicago','','','230','Illinois','demolished',NULL,NULL,'261'),(229,'Montauk','51','15','-64','Monroe','1882','Burnham & Root','1902',NULL,NULL,'5','','','','Chicago','','','231','Illinois','demolished','1902','1902','262'),(230,'Monticello','133','','','',NULL,'','?',NULL,'0',NULL,'','','','Virginia','','','232','USA',NULL,NULL,NULL,'263'),(231,'Moody\'s Tabernacle','35','','810','La Salle','1876','Sullivan','>1940','2',NULL,NULL,'','','','Chicago','','Sullivan did interior design; building not described','233','Illinois','demolished','1940','2013','264'),(232,'Mormon Tabernacle','33','','','',NULL,'','?',NULL,'0',NULL,'','','','Salt Lake City','','','234','USA',NULL,NULL,NULL,'265'),(233,'Morningstar-Paisley Company','','','','',NULL,'','',NULL,NULL,NULL,'','Schoenhofen Brewery powerhouse','','Chicago','','','235','Illinois','demolished',NULL,NULL,'266'),(234,'Morris','','','','',NULL,'','',NULL,NULL,NULL,'','Leiter, first','','Chicago','','','236','Illinois','demolished',NULL,NULL,'267'),(235,'Morton','93','57','-538','Dearborn','1896','Jenney & Mundie ',NULL,NULL,'3',NULL,'Morton.jpg','','','Chicago','','','237','Illinois','extant',NULL,NULL,'268'),(236,'Morton Apartments','149','','-1800','Michigan','1889','??','?',NULL,'1',NULL,'','','','Chicago','','','238','Illinois',NULL,NULL,NULL,'269'),(237,'Moses','146','','-200','Jackson','1912','??','<1985',NULL,'1',NULL,'','','','Chicago','','','239','Illinois','demolished','1912','1985','270'),(238,'Mount Vernon','133','','','',NULL,'','?',NULL,'0',NULL,'','','','Virginia','','','240','USA',NULL,NULL,NULL,'271'),(239,'Museum of Natural History','96','','-1400','Lake Shore Drive','1911','Graham, Anderson, Probst, & White',NULL,NULL,'0',NULL,'','','Field Museum','Chicago','','','241','Illinois','extant',NULL,NULL,'272'),(240,'Nepeenauk','','','','',NULL,'','',NULL,NULL,NULL,'','Chapin and Gore','','Chicago','','','242','Illinois','demolished',NULL,NULL,'274'),(241,'Newberry Library','59','','-60','Walton','1892','Cobb',NULL,NULL,'1',NULL,'','','','Chicago','','Info. from Randall','243','Illinois','extant',NULL,NULL,'275'),(242,'900 N Michigan Ave','189','','900','Michigan','1927','Hunt','1984',NULL,'0',NULL,'','','','Chicago','','Info. from Randall','244','Illinois','demolished','1984','1984','21'),(243,'Nixon','23','3','-128','Monroe','1871','Matz','1889','1',NULL,NULL,'','','','Chicago','','','245','Illinois','demolished','1889','1889','276'),(244,'Northwestern Technological Institute','198','','2145','Sheridan','1941','Holabird & Root',NULL,NULL,'0',NULL,'','','','Evanston','http://en.wikipedia.org/wiki/Northwestern_Technological_Institute','','246','Illinois','extant',NULL,NULL,'277'),(245,'Northwestern University campus plan','198','','','',NULL,'','',NULL,NULL,NULL,'','','','Chicago','','Not a building','247','Illinois','demolished',NULL,NULL,NULL),(246,'Old Colony','122','76-79','-407','Dearborn','1894','Holabird & Roche ',NULL,NULL,NULL,'2','OldColonyGap.JPG;OldColonyFisherMonadnock.JPG','','','Chicago','','','248','Illinois','extant',NULL,NULL,'278'),(247,'Omaha Apartments','157','','','??','1893','Pond brothers','?',NULL,'4',NULL,'','','','Chicago','','No location given','249','Illinois',NULL,NULL,NULL,'279'),(248,'1 North La Salle','117','','1','La Salle','1930','Vitzhum & Burns',NULL,NULL,'0',NULL,'','','','Chicago','','Info. from Randall','250','Illinois','extant',NULL,NULL,'5'),(249,'120 South La Salle','104','','-120','La Salle','1928','Graham, Anderson, Probst, & White',NULL,NULL,'0',NULL,'','','State Bank','Chicago','','Info. from Randall','251','Illinois','extant',NULL,NULL,'2'),(250,'Palmer House','149','','1','Monroe','1875','Van Osdel','1925',NULL,'1',NULL,'','','Palmer House 3','Chicago','','','252','Illinois','demolished','1925','1925','281'),(251,'Palmolive','177','','919','Michigan','1929','Holabird & Root',NULL,NULL,'1',NULL,'','','','Chicago','','Info. from Randall','253','Illinois','extant',NULL,NULL,'283'),(252,'Park Gate Hotel','156','','','Fifty-ninth','1892','Flanders & Zimmerman','<2013',NULL,'3',NULL,'','','','Chicago','','no sign of it in 2013; no exact address','254','Illinois','demolished','1892','2013','285'),(253,'Parker Apartments','150','','-3100','Cottage Grove','1889','??','<2013',NULL,'0',NULL,'','','','Chicago','','lots and schools currently','255','Illinois','demolished','1889','2013','284'),(254,'Parthenon','10','','','',NULL,'',NULL,NULL,'0',NULL,'','','','Athens, Greece','','','256','foreign','extant',NULL,NULL,'287'),(255,'Patten Gymnasium','196','158-159','2145','Sheridan','1909','Maher','1940','1',NULL,NULL,'','','','Evanston','','','257','Illinois','demolished','1940','1940','288'),(256,'Patten House','196','','??','??','1902','Maher','?',NULL,'0',NULL,'','','','Evanston','','','258','Illinois',NULL,NULL,NULL,'289'),(257,'Pennsylvania Railroad grain elevator','82','','','','1862','Johnson, George A.','?',NULL,'1',NULL,'','','','Philadelphia','','','259','USA',NULL,NULL,NULL,'290'),(258,'Pettibone Printing Company','','','','',NULL,'','',NULL,NULL,NULL,'','Kennedy Bakery','','Chicago','','','260','Illinois','demolished',NULL,NULL,'291'),(259,'Phelps, Dodge and Palmer','145','107','-200','Adams','1882','Burling & Whitehouse','1963-1985','1',NULL,NULL,'','','','Chicago','','evidently still standing in 1963; Randall gives demolition < 1985','261','Illinois','demolished','1963','1985','292'),(260,'Phoenix','23','','','',NULL,'','',NULL,NULL,NULL,'','Austin','','Chicago','','','262','Illinois','demolished',NULL,NULL,'293'),(261,'Pickwick Apartments','101','','??','Michigan','1887','Burnham & Root','?',NULL,'1',NULL,'','','','Chicago','','','263','Illinois',NULL,NULL,NULL,'294'),(262,'Pierce, Stanley R., Hall','219','196','-5514','University','1960','Weese','2013',NULL,'1',NULL,'','','','Chicago','http://chicagomaroon.com/2013/07/25/old-pierce-versus-new-hall/','demolition to start 19 Aug 2013!','264','Illinois','demolished','2013','2013','295'),(263,'Plaza Hotel','154','115','1553','Clark','1892','Warren','1965','1',NULL,NULL,'','','','Chicago','','Demolition date from Randall','265','Illinois','demolished','1965','1965','296'),(264,'Pontiac','119','73','-542','Dearborn','1891','Holabird & Roche ',NULL,'1',NULL,NULL,'Pontiac.JPG','','','Chicago','','','266','Illinois','extant',NULL,NULL,'298'),(265,'Portland','30','','33','Dearborn','1872','Jenney','1933','1',NULL,NULL,'','','','Chicago','','','267','Illinois','demolished','1933','1933','299'),(266,'Post Office and Customs House','208','','-50','Monroe','1855','Van Osdel','1871',NULL,'2',NULL,'','','','Chicago','','Address, destruction from Randall','268','Illinois','demolished','1871','1871','300'),(267,'Powers','','','','',NULL,'','',NULL,NULL,NULL,'','Champlain, second','','Chicago','','','269','Illinois','demolished',NULL,NULL,'301'),(268,'Prarie Shores','191','','','',NULL,'','',NULL,NULL,NULL,'','','','Chicago','','not a building: entire project of urban renewal','270','Illinois','demolished',NULL,NULL,NULL),(269,'Proctor and Gamble','143','','','',NULL,'','',NULL,NULL,NULL,'','','','Cincinnati','','not a building: group of buildings, none specified','271','USA','demolished',NULL,NULL,NULL),(270,'Promontory Apartments','218','191','-5530','Lake Shore Drive','1949','Mies van der Rohe',NULL,NULL,'1',NULL,'','','','Chicago','','','272','Illinois','extant',NULL,NULL,'302'),(271,'Prudential (Buffalo)','','','','',NULL,'','?',NULL,NULL,NULL,'','Guaranty','','Buffalo','','','273','USA',NULL,NULL,NULL,'304'),(272,'Prudential','214','','130','Randolph','1955','Naess & Murphy',NULL,NULL,'1',NULL,'','','One Prudential Plaza','Chicago','','Info. from Randall','274','Illinois','extant',NULL,NULL,'303'),(273,'Public Library','96','','78','Washington','1897','Shepley, Rutan & Coolidge',NULL,NULL,'1',NULL,'','','','Chicago','','Info. from Randall','275','Illinois','extant',NULL,NULL,'305'),(274,'Pullman','43','','-200','Michigan','1885','Beman','1950',NULL,'0',NULL,'','','','Chicago','http://www.chicagoarchitecture.info/Building/1130/Borg-Warner-Building.php','','276','Illinois','demolished','1950','1950','306'),(275,'Pullman Company factory and houses','143','','','',NULL,'Beman','',NULL,NULL,NULL,'','','','Pullman','','not a building: refers to the company town and an unspecified number of buildings with no info. on any','277','Illinois','demolished',NULL,NULL,NULL),(276,'Railway Exchange','113','69','80','Jackson','1904','Burnham, D.H., & Co.',NULL,NULL,NULL,'1','','','Santa Fe Center','Chicago','','','278','Illinois','extant',NULL,NULL,'307'),(277,'Rand McNally','99','58-59','-160','Adams','1890','Burnham & Root','1911',NULL,NULL,'2','','','','Chicago','','','279','Illinois','demolished','1911','1911','308'),(278,'Real Estate Exchange','24','','','',NULL,'','',NULL,NULL,NULL,'','Kendall','','Chicago','','','280','Illinois','demolished',NULL,NULL,'309'),(279,'Reese, Michael, Hospital','191','150','-2889','Ellis','1906','Schmidt',NULL,'2',NULL,NULL,'','','','Chicago','','','281','Illinois','extant',NULL,NULL,'310'),(280,'Reid, Murdoch and Company','180','144','325','La Salle','1913','Nimmons & Fellows',NULL,'1',NULL,NULL,'','','','Chicago','','','282','Illinois','extant',NULL,NULL,'312'),(281,'Reid house','111','','-2013','Prarie','1894','Beers, Clay & Dutton',NULL,'1',NULL,NULL,'','','','Chicago','http://en.wikipedia.org/wiki/Reid_House_(Chicago,_Illinois)','','283','Illinois','extant',NULL,NULL,'311'),(282,'Reliance','109','67','32','State','1895','Atwood',NULL,NULL,NULL,'2','','','','Chicago','','','284','Illinois','extant',NULL,NULL,'313'),(283,'Republic','175','136-137','-209','State','1905','Holabird & Roche ','1961',NULL,NULL,'1','','','','Chicago','','','285','Illinois','demolished','1961','1961','314'),(284,'Revell','39','8-9','50','Adams','1883','Sullivan','1968',NULL,'5',NULL,'','','','Chicago','','','286','Illinois','demolished','1968','1968','315'),(285,'Robie house','193','','-5757','Woodlawn','1908','Wright',NULL,NULL,'1',NULL,'','','','Chicago','','','287','Illinois','extant',NULL,NULL,'316'),(286,'Rookery','63','21-27','-201','La Salle','1886','Burnham & Root',NULL,NULL,NULL,'2','RookeryLobby1.JPG;RookeryLobby2.JPG;Rookery.JPG;RookeryCrows.JPG','','','Chicago','','','288','Illinois','extant',NULL,NULL,'317'),(287,'Rosenfeld','42','','-743','Washington','1882','Adler & Sullivan','1958',NULL,'1',NULL,'','','','Chicago','','','289','Illinois','demolished','1958','1958','318'),(288,'Rothschild Store','38','6','-210','Monroe','1881','Sullivan','1972',NULL,NULL,'1','','','Milton F. Goodman','Chicago','','','290','Illinois','demolished','1972','1972','319'),(289,'Ryerson','40','','16','Randolph','1884','Sullivan','1939',NULL,'3',NULL,'','','','Chicago','','','291','Illinois','demolished','1939','1939','320'),(290,'St. Anne\'s Church, Liverpool','6','','','',NULL,'','?',NULL,NULL,NULL,'','','','Liverpool','','','292','foreign',NULL,NULL,NULL,'339'),(291,'St. Anne\'s Hospital','191','','-4950','Thomas','1903','Schmidt','?',NULL,'1',NULL,'','','','Chicago','','Hospital closed 1988; building may now be Beth-Anne Residence','293','Illinois',NULL,NULL,NULL,'340'),(292,'St. Mary\'s Church (1833)','8','','200','State','1833','Taylor','<1871',NULL,'1',NULL,'','','','Chicago','','Approx. address from Randall; no destruction given, but presumably gone in fire or earlier','294','Illinois','demolished','1833','1871','344'),(293,'St. Mary\'s Church (1868)','20','','-901','Wabash','1868','Randall','1970',NULL,'1',NULL,'','','Plymouth Congregational Church','Chicago','','Info. from Randall','295','Illinois','demolished','1970','1970','345'),(294,'St. Mary\'s High School','204','','-2044','Grenshaw','1924','Byrne','1977',NULL,'0',NULL,'','','','Chicago','http://www.illinoishsglorydays.com/id791.html','Now empty lot U of I campus','296','Illinois','demolished','1977','1977','346'),(295,'St. Ouen docks warehouse, Paris','7','','','','1866','Fontaine','?',NULL,NULL,NULL,'','','','Paris','','','297','foreign',NULL,NULL,NULL,'348'),(296,'St. Thomas the Apostle, Church of','204','','-5472','Kimbark','1924','Byrne',NULL,NULL,'0',NULL,'','','','Chicago','','','298','Illinois','extant',NULL,NULL,'349'),(297,'Sandburg Village','154','','1355','Sandburg','1964','Solomon and Cordwell',NULL,NULL,'1',NULL,'','','','Chicago','','not a building: complex of many buildings over several blocks','299','Illinois','extant',NULL,NULL,NULL),(298,'Schiller','','','','',NULL,'','',NULL,NULL,NULL,'','Garrick Theater','','Chicago','','','300','Illinois','demolished',NULL,NULL,'322'),(299,'Schlesinger and Mayer Store','162','','','',NULL,'','',NULL,NULL,NULL,'','Carson Pirie Scott Store','','Chicago','','','301','Illinois','demolished',NULL,NULL,'323'),(300,'Schoenhofen Brewery powerhouse','188','149','-500','Eighteenth','1902','Schmidt',NULL,'2',NULL,NULL,'','','','Chicago','','','302','Illinois','extant',NULL,NULL,'324'),(301,'Schurz, Carl High School','202','165-166','3601','Milwaukee','1908','Perkins',NULL,NULL,NULL,'1','','','','Chicago','','','303','Illinois','extant',NULL,NULL,'325'),(302,'Scoville','42','','-619','Washington','1885','Adler & Sullivan','1970-1974',NULL,'1',NULL,'','','','Chicago','','demolition date from Randall in “early 1970s”','304','Illinois','demolished','1970','1974','326'),(303,'Sears, Joseph, Elementary School','200','162','542','Abbotsford','1912','Maher',NULL,'1',NULL,NULL,'','','','Kenilworth','','Must be same building standing, but description not a sure match','305','Illinois','extant',NULL,NULL,'327'),(304,'Sears Roebuck merchandise plant','179','','-924','Homan','1906','Nimmons & Fellows','1978',NULL,NULL,'1','','','','Chicago','http://www.loc.gov/pictures/item/il0737/;http://www.homansquare.org/sears-roebuck-and-co','main building demolished but tower preserved, standing alone in a field and under renovation in Google photo','306','Illinois','demolished','1978','1978','328'),(305,'Sears Roebuck Store','','','','',NULL,'','',NULL,NULL,NULL,'','Leiter, second','','Chicago','','','307','Illinois','demolished',NULL,NULL,'329'),(306,'Second City night club','133','','1616','Wells','1961','Goldstein',NULL,NULL,'1',NULL,'','','','Chicago','','','308','Illinois','extant',NULL,NULL,'330'),(307,'Selz, Schwab and Company factory','39','','','Superior','1887','Adler','<2013',NULL,'2',NULL,'','','','Chicago','http://digital-libraries.saic.edu/cdm/singleitem/collection/mqc/id/14592/rec/122','location given as Superior & Roberts; this citation says Superior & Larabee ? and no demolition date','309','Illinois','demolished','1887','2013','331'),(308,'7415 Sheridan Road','210','','7415','Sheridan','1915','Wright',NULL,NULL,'1',NULL,'','','','Chicago','','','310','Illinois','extant',NULL,NULL,'19'),(309,'Sheraton Hotel','154','','505','Michigan','1929','Alschlager',NULL,NULL,'1',NULL,'','','Medinah Club; Chicago Towers; Continental Hotel','Chicago','','Info. from Randall','311','Illinois','extant',NULL,NULL,'332'),(310,'Sheridan House','199','161','310','Church','1911','Maher',NULL,'1',NULL,NULL,'','','','Evanston','','','312','Illinois','extant',NULL,NULL,'333'),(311,'Shillito, John, Store','6','','','','1877','McLaughlin','?',NULL,'2',NULL,'','','','Cincinnati','','','313','USA',NULL,NULL,NULL,'334'),(312,'Sibley, Hiram, and Company Warehouse','58','16','315','Clark','1883','Edbrooke','1980-1989','1',NULL,NULL,'','','','Chicago','','Demolition date from Randall as “1980s”','314','Illinois','demolished','1980','1989','335'),(313,'Siegel, Cooper and Company','','','','',NULL,'','',NULL,NULL,NULL,'','Leiter, second','','Chicago','','','315','Illinois','demolished',NULL,NULL,'336'),(314,'608 Davis Street','208','172','608','Davis','1910','Tallmadge and Watson',NULL,NULL,'4',NULL,'','','','Evanston','','facade substantially changed','316','Illinois','extant',NULL,NULL,'17'),(315,'skyscraper, Gothic','216','','','',NULL,'','',NULL,NULL,NULL,'','','','Chicago','','not a building: the style','317','Illinois','demolished',NULL,NULL,NULL),(316,'Society Brand','178','142','-416','Franklin','1912','Graham, Burnham, and Co.','1963-1990',NULL,'3',NULL,'','','Decker, Alfred and Cohn','Chicago','http://www.emporis.com/building/societybrandbuilding-chicago-il-usa; Sally Chappell 1992','seems it was standing at writing in 1964; Randall gives demolition over 1950-1990','318','Illinois','demolished','1963','1990','337'),(317,'Standard Club','41','13','-2400','Michigan','1888','Sullivan','1910','1',NULL,NULL,'','','','Chicago','','','319','Illinois','demolished','1910','1910','338'),(318,'State-Madison','','','','',NULL,'','',NULL,NULL,NULL,'','Boston Store','','Chicago','','','320','Illinois','demolished',NULL,NULL,'342'),(319,'Steinway Hall','200','','64','Van Buren','1896','Perkins','1963-1970',NULL,'3',NULL,'','','','Chicago','','evidently still standing in 1963; Randall gives demolition in 1960s','321','Illinois','demolished','1963','1970','343'),(320,'Stock Exchange','136','95-99','30','La Salle','1894','Sullivan','1972',NULL,NULL,'2','','','30 N. La Salle','Chicago','','Demolition date from Randall','322','Illinois','demolished','1972','1972','347'),(321,'Studebaker','145','105-106','-629','Wabash','1895','Beman',NULL,'1',NULL,NULL,'','','Brunswick','Chicago','','','323','Illinois','extant',NULL,NULL,'350'),(322,'Student Union, Purdue University','207','','','','1929','Pond brothers','?',NULL,NULL,NULL,'','','','West Lafayette, Indiana','','','324','USA',NULL,NULL,NULL,'351'),(323,'Student Union, University of Michigan','207','','','','1917','Pond brothers','?',NULL,NULL,NULL,'','','','Ann Arbor, Michigan','','','325','USA',NULL,NULL,NULL,'352'),(324,'Sullivan','','','','',NULL,'','',NULL,NULL,NULL,'','Troescher','','Chicago','','','326','Illinois','demolished',NULL,NULL,'353'),(325,'Swift Hall','197','160','2029','Sheridan','1909','Maher',NULL,NULL,NULL,'1','','','','Evanston','','','327','Illinois','extant',NULL,NULL,'354'),(326,'Tacoma','117','70','1','La Salle','1889','Holabird & Roche ','1929',NULL,NULL,'2','','','','Chicago','','','328','Illinois','demolished','1929','1929','355'),(327,'1014 Davis Street','186','','1014','Davis','1905','Blake','<2013',NULL,'1',NULL,'','','','Chicago','','Current building at site does not fit description','329','Illinois','demolished','1905','2013','1'),(328,'320 South Franklin Street','125','','-320','Frankin','1898','Holabird & Roche ','1950-1963',NULL,'1',NULL,'','','','Chicago','','Destroyed by 1963; Randall gives 1950-1990','330','Illinois','demolished','1950','1963','14'),(329,'325 West Jackson Boulevard','174','133','-325','Jackson','1904','Holabird & Roche ','1950-1990',NULL,'1',NULL,'','','','Chicago','','Demolition date from Randall','331','Illinois','demolished','1950','1990','15'),(330,'3200 South Prarie Avenue (apartments)','149','','-3200','Prarie','1882','Adler & Sullivan','?',NULL,'1',NULL,'','','','Chicago','','Brick apartments at site may be it??','332','Illinois',NULL,NULL,NULL,'13'),(331,'Toll, Illinois Bell Telephone Company','205','169','111','Franklin','1908','Pond brothers','1967','1',NULL,NULL,'','','Illinois Bell','Chicago','','Demolition date from Randall','333','Illinois','demolished','1967','1967','356'),(332,'Tower','','','','',NULL,'','',NULL,NULL,NULL,'','Ward, Montgomery, Michigan Avenue','','Chicago','','','334','Illinois','demolished',NULL,NULL,'357'),(333,'Transportation, World\'s Columbian Exposition','136','93-94','-6200','Stoney Island','1893','Sullivan','1894-1895','2',NULL,NULL,'','','','Chicago','','Fair buildings were temporary, but I can\'t find a demolition date','335','Illinois','demolished','1894','1895','358'),(334,'Tribune','161','','435','Michigan','1925','Howells & Hood',NULL,NULL,'0',NULL,'','','','Chicago','','Only a comment about ridicule from Sullivan','336','Illinois','extant',NULL,NULL,'360'),(335,'Tribune, Drummond project','209','','','',NULL,'','','1',NULL,NULL,'','','','Chicago','','not a building: unsuccessful entry by Drummond','337','Illinois','demolished',NULL,NULL,NULL),(336,'Tribune, Griffin project','211','179','','',NULL,'','','1',NULL,NULL,'','','','Chicago','','not a building: unsuccessful entry by Griffin','338','Illinois','demolished',NULL,NULL,NULL),(337,'Tribune, Gropius and Meyer Project','217','188','','',NULL,'','','1',NULL,NULL,'','','','Chicago','','not a building: unsuccessful entry by Gropius and Meyer','339','Illinois','demolished',NULL,NULL,NULL),(338,'Tribune, Schmidt, Garden and Martin project','195','','','',NULL,'','',NULL,'1',NULL,'','','','Chicago','','not a building: unsuccessful entry by Schmidt et al','340','Illinois','demolished',NULL,NULL,NULL),(339,'Troescher','80','42','-15','Wacker','1884','Adler & Sullivan','1978','1',NULL,NULL,'','','Sullivan; Daily Times; Chicago Joint Board','Chicago','','','341','Illinois','demolished','1978','1978','361'),(340,'Trumball, Lyman Elementary School','201','164','5200','Ashland','1909','Perkins',NULL,'1',NULL,NULL,'','','','Chicago','','','342','Illinois','extant',NULL,NULL,'362'),(341,'241 Chestnut Street, Philadelphia','38','','','','1852','Button','?',NULL,'1',NULL,'','','','Philadelphia','','','343','USA',NULL,NULL,NULL,'10'),(342,'Union Bus Terminal','103','','155','Clark','1949','??','1985',NULL,'0',NULL,'','','','Chicago','','appears to have been replaced by Thompson Center','344','Illinois','demolished','1985','1985','363'),(343,'Union Life','','','','',NULL,'','',NULL,NULL,NULL,'','Chapin and Gore','','Chicago','','','345','Illinois','demolished',NULL,NULL,'364'),(344,'Unitarian Church of Evanston','210','175','1300','Chicago','1904','Mahoney','1960','1',NULL,NULL,'','','','Evanston','','architect a woman!','346','Illinois','demolished','1960','1960','366'),(345,'United States Warehousing Company grain elevator','81','','','','1860','Johnson, George A.','?',NULL,'3',NULL,'','','','Brooklyn','','','347','USA',NULL,NULL,NULL,'367'),(346,'Unity','151','55','127','Dearborn','1892','Warren','1990','1',NULL,NULL,'','','','Chicago','','Demolition date from Randall as ca. 1990','348','Illinois','demolished','1990','1990','368'),(347,'Unity Church','208','','875','Lake','1906','Wright',NULL,NULL,'1',NULL,'','','','Oak Park','','','349','Illinois','extant',NULL,NULL,'369'),(348,'University','196','157','1604','Chicago','1906','Maher',NULL,'1',NULL,NULL,'','','','Evanston','','','350','Illinois','extant',NULL,NULL,'370'),(349,'University Apartments','190','','1450','Fifty-fifth','1961','Pei and Weese',NULL,NULL,'4',NULL,'','','','Chicago','http://tours.architecture.org/ppt/Weese_master.pdf','Not enough information to locate; perhaps pair of large condos','351','Illinois','extant',NULL,NULL,'371'),(350,'Van Nelle Tobacco Company factory','147','','','','1931','van der Vlugt',NULL,NULL,'0',NULL,'','','','Netherlands','','','352','foreign','extant',NULL,NULL,'372'),(351,'Victoria Hotel','135','91','69','Illinois','1893','Adler & Sullivan','1961','2',NULL,NULL,'','','','Chicago Heights','','','353','Illinois','demolished','1961','1961','373'),(352,'Vieux Carré, New Orleans','133','','','',NULL,'','',NULL,NULL,NULL,'','','','New Orleans','','Not a building','354','USA','demolished',NULL,NULL,NULL),(353,'Virginia Hotel','152','112','600','Rush','1890','Warren','1929','2',NULL,NULL,'','','McCormick, Leander, Apartments','Chicago','','No exact address; Ohio and Rush corner','355','Illinois','demolished','1929','1929','374'),(354,'Wainright','127','86','709','Chestnut','1891','Adler & Sullivan',NULL,NULL,NULL,'2','','','','St. Louis','','','356','USA','extant',NULL,NULL,'375'),(355,'Walker Warehouse','41','14','-210','Wacker','1889','Adler & Sullivan','1953','1',NULL,NULL,'','','','Chicago','','','357','Illinois','demolished','1953','1953','376'),(356,'Ward','111','','14','Michigan','1885','Beers, Clay & Dutton',NULL,NULL,'1',NULL,'','','14 N. Michigan;Illinois State Medical Society','Chicago','','','358','Illinois','extant',NULL,NULL,'377'),(357,'Ward, Montgomery, Chicago Avenue','192','','758','Larrabee','1907','Schmidt, Garden, & Martin',NULL,NULL,'2',NULL,'','','','Chicago','','','359','Illinois','extant',NULL,NULL,'378'),(358,'Ward, Montgomery, Michigan Avenue','186','','6','Michigan','1899','Schmidt',NULL,NULL,'4',NULL,'','','Tower','Chicago','','','360','Illinois','extant',NULL,NULL,'379'),(359,'Ward, Montgomery, warehouse','192','151-152','-618','Chicago','1908','Schmidt, Garden, & Martin',NULL,'2',NULL,NULL,'','','','Chicago','','','361','Illinois','extant',NULL,NULL,'380'),(360,'Water Tower','134','','806','Michigan','1869','Boyington',NULL,NULL,'2',NULL,'','','','Chicago','','','362','Illinois','extant',NULL,NULL,'381'),(361,'Water Tower Inn','190','','800','Michigan','1961','Hausner and Macsai','1997',NULL,'2',NULL,'','','Park Hyatt Hotel','Chicago','http://www.flickr.com/photos/mss2400/5632776639/','','363','Illinois','demolished','1997','1997','382'),(362,'Western Union','','','','',NULL,'','',NULL,NULL,NULL,'','Austin','','Chicago','','','364','Illinois','demolished',NULL,NULL,'384'),(363,'Williams','125','82','-205','Monroe','1898','Holabird & Roche ',NULL,NULL,'2',NULL,'','','','Chicago','','','365','Illinois','extant',NULL,NULL,'385'),(364,'Williamsburg, Va.','133','','','',NULL,'','',NULL,NULL,NULL,'','','','Chicago','','Not a building','366','Illinois','demolished',NULL,NULL,NULL),(365,'Willoughby','80','43','-234','Franklin','1887','Buffington','1964','1',NULL,NULL,'','','234 S. Franklin','Chicago','','','367','Illinois','demolished','1964','1964','386'),(366,'Winton','191','','-1255','Michigan','1904','Rogers','>1999',NULL,'4',NULL,'','','','Chicago','','Not there now, but Randall suggests it was as of 1999','368','Illinois','demolished','1999','2013','387'),(367,'Witkower','186','','621','Davis','1906','Edbrooke','<2013',NULL,'2',NULL,'','','','Evanston','','part of Lord\'s store','369','Illinois','demolished','1906','2013','388'),(368,'Woman\'s Temple','104','63','-102','La Salle','1892','Burnham & Root','1926','2',NULL,NULL,'','','','Chicago','','','370','Illinois','demolished','1926','1926','389'),(369,'Woodbury County Courthouse','183','','','','1917','Elmslie','?',NULL,NULL,NULL,'','','','Sioux City','','','371','USA',NULL,NULL,NULL,'390'),(370,'Woods Theater','38','','-50','Randolph','1917','Marshall & Fox','1989',NULL,'0',NULL,'','','','Chicago','','Info. from Randall','372','Illinois','demolished','1989','1989','391'),(371,'Woolworth','123','','','','1913','Gilbert',NULL,NULL,'1',NULL,'','','','New York','','','373','USA','extant',NULL,NULL,'392'),(372,'World\'s Columbian Exposition tower (project)','96','','','',NULL,'Morrison','',NULL,'2',NULL,'','','','Chicago','','Not a building: design only','374','Illinois','demolished',NULL,NULL,NULL),(373,'Yondorf','147','108','-225','Wacker','1893','Flanders & Zimmerman','1968','1',NULL,NULL,'','','225 S. Market; 225 S. Wacker','Chicago','','Yondorf built in 1874; the relevant part was an extension of 1893','375','Illinois','demolished','1968','1968','393');
/*!40000 ALTER TABLE `stage` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `url`
--

DROP TABLE IF EXISTS `url`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `url` (
  `urlID` int(11) NOT NULL AUTO_INCREMENT,
  `url` varchar(55) DEFAULT NULL,
  `type` enum('photo') DEFAULT NULL,
  PRIMARY KEY (`urlID`)
) ENGINE=MyISAM AUTO_INCREMENT=2 DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `url`
--

LOCK TABLES `url` WRITE;
/*!40000 ALTER TABLE `url` DISABLE KEYS */;
INSERT INTO `url` VALUES (1,'/athome/ChicagoSchool/buildingphoto/','photo');
/*!40000 ALTER TABLE `url` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `viewBldg`
--

DROP TABLE IF EXISTS `viewBldg`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `viewBldg` (
  `bldgID` int(11) NOT NULL DEFAULT '0',
  `name` varchar(150) DEFAULT NULL,
  `address` int(11) DEFAULT NULL,
  `street` varchar(50) DEFAULT NULL,
  `location` varchar(75) DEFAULT NULL,
  `area` varchar(75) DEFAULT NULL,
  `firm` varchar(75) DEFAULT NULL,
  `completion` int(11) DEFAULT NULL,
  `status` varchar(20) DEFAULT NULL,
  `earlydemol` int(11) DEFAULT NULL,
  `latedemol` int(11) DEFAULT NULL,
  `pages` int(11) DEFAULT NULL,
  `paragraphs` int(11) DEFAULT NULL,
  `sentences` int(11) DEFAULT NULL,
  `treatment` decimal(10,2) DEFAULT NULL,
  `figures` int(11) DEFAULT '0',
  `page` int(11) DEFAULT NULL,
  `photo` varchar(250) DEFAULT NULL,
  `altname` varchar(150) DEFAULT NULL,
  `altspelling` varchar(150) DEFAULT NULL,
  `aka` varchar(150) DEFAULT NULL,
  PRIMARY KEY (`bldgID`)
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `viewBldg`
--

LOCK TABLES `viewBldg` WRITE;
/*!40000 ALTER TABLE `viewBldg` DISABLE KEYS */;
INSERT INTO `viewBldg` VALUES (1,'Alexandria Hotel',542,'Rush','Chicago','Illinois','Edmund R. Krause',1891,'demolished',1965,1990,0,0,1,0.05,0,156,NULL,NULL,NULL,NULL),(2,'Alumni Memorial Hall (IIT)',NULL,'','Chicago','Illinois','Mies van der Rohe',1946,'extant',NULL,NULL,0,0,1,0.05,1,218,NULL,NULL,NULL,NULL),(3,'Ambassador Hotel',1301,'State','Chicago','Illinois','Schmidt, Garden, & Martin',1919,'extant',NULL,NULL,0,0,1,0.05,0,194,NULL,'Ambassador West',NULL,NULL),(4,'American Express Company',-21,'Monroe','Chicago','Illinois','H.H. Richardson',1873,'demolished',1930,1930,0,1,0,0.25,0,22,NULL,NULL,NULL,NULL),(5,'American National Bank',33,'La Salle','Chicago','Illinois','Graham, Anderson, Probst, & White',1928,'extant',NULL,NULL,0,0,0,0.01,0,87,NULL,'Foreman National Bank',NULL,NULL),(6,'American Tract Society',3,'Spruce','New York','USA','R.H. Robertson',1895,'extant',NULL,NULL,1,0,0,1.00,0,140,NULL,NULL,NULL,NULL),(7,'American Trust and Savings Bank',-90,'Monroe','Chicago','Illinois','Hunt',1906,'demolished',1969,1969,0,0,0,0.01,0,189,NULL,'Fort Dearborn Bank',NULL,NULL),(8,'Anshe Ma\'ariv Synagogue',-3301,'Indiana','Chicago','Illinois','Adler & Sullivan',1890,'demolished',2006,2006,0,0,0,0.01,0,208,NULL,NULL,NULL,NULL),(9,'Hinman and Lee Apartments',-501,'Lee','Evanston','Illinois','Laurence G. Hallberg',1922,'extant',NULL,NULL,0,0,3,0.15,0,159,NULL,NULL,'apartments, Hinman Avenue and Lee Street, Evanston',NULL),(10,'Argyle Apartments',80,'Jackson','Chicago','Illinois','Burnham & Root',1887,'demolished',1887,1904,0,0,0,0.01,0,101,NULL,NULL,NULL,NULL),(11,'Art Institute',-101,'Michigan','Chicago','Illinois','Shepley, Rutan & Coolidge',1893,'extant',NULL,NULL,0,0,0,0.01,0,96,NULL,NULL,NULL,NULL),(12,'Ashland',161,'Clark','Chicago','Illinois','Burnham & Root',1892,'demolished',1949,1949,1,0,0,1.00,2,102,NULL,NULL,NULL,NULL),(13,'Auditorium',50,'Congress','Chicago','Illinois','Adler & Sullivan',1889,'extant',NULL,NULL,9,0,0,9.00,9,69,'AuditoriumTower.jpg;AuditoriumCongressElev.jpg;AuditoriumMichiganElev.jpg;Auditorium.jpg',NULL,NULL,NULL),(14,'Austin',-111,'Jackson','Chicago','Illinois','Burnham & Root',1886,'demolished',1959,1959,0,0,5,0.25,0,57,NULL,'Phoenix;Western Union',NULL,NULL),(15,'Babson Farm',NULL,'','Riverside','Illinois','Purcell, Feick, & Elmslie',1915,NULL,NULL,NULL,0,0,0,0.01,0,184,NULL,NULL,NULL,NULL),(16,'Babson House',NULL,'','Riverside','Illinois','Sullivan',1907,NULL,NULL,NULL,0,0,0,0.01,0,183,NULL,NULL,NULL,NULL),(17,'Bailey',-529,'Franklin','Chicago','Illinois','Holabird & Roche ',1898,'demolished',1953,1953,0,0,1,0.05,1,174,NULL,NULL,NULL,NULL),(18,'Cornelius Baker Company factory',NULL,'','Philadelphia','USA','Hoxie',1853,NULL,NULL,NULL,0,0,1,0.05,0,39,NULL,NULL,'Baker Factory, Cornelius',NULL),(19,'Bauer and Black',-2500,'Dearborn','Chicago','Illinois','Holabird & Roche ',1907,'demolished',1962,1962,0,0,2,0.10,0,175,NULL,NULL,NULL,NULL),(20,'Bayard',65,'Bleecker','New York','USA','Sullivan',1897,'extant',NULL,NULL,0,0,1,0.05,0,130,NULL,'Condict',NULL,NULL),(21,'Berbach House',1120,'MIchigan','Wilmette','Illinois','Van Bergen',1914,'extant',NULL,NULL,0,0,2,0.10,1,211,NULL,NULL,NULL,NULL),(22,'Bibliotheque National',NULL,'','Paris','foreign','Labrouste',1858,NULL,NULL,NULL,0,0,0,0.01,0,87,NULL,NULL,NULL,NULL),(23,'Board of Trade 1',-141,'Jackson','Chicago','Illinois','Boyington',1885,'demolished',1929,1929,0,0,0,0.01,0,137,NULL,NULL,NULL,NULL),(24,'Board of Trade 2',-141,'Jackson','Chicago','Illinois','Holabird & Root',1930,'extant',NULL,NULL,0,0,1,0.05,0,177,NULL,NULL,NULL,NULL),(25,'Boat Store, Sheerness',NULL,'','Sheerness, England','foreign','Greene',1858,NULL,NULL,NULL,0,0,1,0.05,0,67,NULL,NULL,NULL,NULL),(26,'Bordeaux Apartments',-1140,'Michigan ','Chicago','Illinois','Baumann & Cady ',1891,'extant',NULL,NULL,0,0,2,0.10,0,156,'Bordeaux1.jpg',NULL,NULL,'Grant Park Arms Apartments'),(27,'Borden Block',150,'Dearborn','Chicago','Illinois','Adler & Sullivan',1879,'demolished',1916,1916,0,1,0,0.25,0,37,NULL,NULL,NULL,NULL),(28,'Borg-Warner',-200,'Michigan','Chicago','Illinois','',1958,'extant',NULL,NULL,0,0,0,0.01,0,43,NULL,NULL,NULL,NULL),(29,'Born',-540,'Wells','Chicago','Illinois','Holabird & Roche ',1908,'demolished',1953,1953,0,0,0,0.01,1,174,NULL,NULL,NULL,NULL),(30,'Boston Store',2,'State','Chicago','Illinois','Holabird & Roche ',1905,'extant',NULL,NULL,0,0,4,0.20,0,174,'BostonStore.jpg','State-Madison',NULL,NULL),(31,'Bradley House',NULL,'','Woods Hole, MA','USA','Elmslie',1911,NULL,NULL,NULL,0,0,0,0.01,0,183,NULL,NULL,NULL,NULL),(32,'Brewster Apartments',2800,'Pine Grove','Chicago','Illinois','R.H. Turnock',1893,'extant',NULL,NULL,1,0,0,1.00,3,157,'BrewsterApts1.jpg;BrewsterApts2.jpg',NULL,NULL,NULL),(33,'Brooks',-223,'Jackson','Chicago','Illinois','Holabird & Roche ',1910,'extant',NULL,NULL,0,0,2,0.10,1,176,'Brooks.jpg',NULL,NULL,NULL),(34,'Brunswick and Balke Factory',700,'Orleans','Chicago','Illinois','Adler & Sullivan',1883,'demolished',1989,1989,0,0,0,0.01,0,42,NULL,NULL,NULL,NULL),(35,'Bunte Brothers Candy Company',-3301,'Frankin','Chicago','Illinois','Schmidt, Garden, & Martin',1921,'demolished',2008,2008,0,1,0,0.25,1,194,NULL,NULL,NULL,NULL),(36,'Cable',-301,'Wabash','Chicago','Illinois','Holabird & Roche ',1899,'demolished',1960,1960,1,0,0,1.00,2,125,NULL,'Hoops',NULL,NULL),(37,'Calico Mill',NULL,'','Derby','foreign','Strutt',1792,NULL,NULL,NULL,0,0,1,0.05,0,6,NULL,NULL,NULL,NULL),(38,'Calumet',-200,'La Salle','Chicago','Illinois','Burnham & Root',1883,'demolished',1913,1913,0,1,0,0.25,0,57,NULL,NULL,NULL,NULL),(39,'Carson Pirie Scott Store',-1,'State','Chicago','Illinois','Sullivan',1903,'extant',NULL,NULL,4,0,0,4.00,7,162,'CarsonPirie.jpg','Schlesinger and Mayer Store',NULL,NULL),(40,'Carson Pirie Scott Annex',44,'Wabash','Chicago','Illinois','Hubert & Daniel Burnham',1926,'extant',NULL,NULL,1,0,0,1.00,2,213,'CarsonPirieAnnex.jpg','Carson Pirie Scott Men\'s Store',NULL,NULL),(41,'Carson Pirie Scott Wholesale Store',-300,'Adams','Chicago','Illinois','Van Osdel',1875,'demolished',1926,1926,0,1,0,0.25,0,162,NULL,NULL,NULL,NULL),(42,'Carter House',1024,'Judson','Evanston','Illinois','Griffin',1910,'extant',NULL,NULL,0,0,3,0.15,1,210,'CarterHouse.jpg',NULL,NULL,NULL),(43,'Caxton',-508,'Dearborn','Chicago','Illinois','Holabird & Roche ',1889,'demolished',1947,1947,0,1,0,0.25,1,118,NULL,NULL,NULL,NULL),(44,'Central Music Hall',1,'Randolph','Chicago','Illinois','Adler',1879,'demolished',1901,1901,2,0,0,2.00,1,31,NULL,NULL,NULL,NULL),(45,'Central YMCA',-19,'La Salle','Chicago','Illinois','Jenney',1892,'extant',NULL,NULL,0,1,0,0.25,0,93,'CentralYMCA.jpg','Association',NULL,NULL),(46,'Century',-202,'State','Chicago','Illinois','Holabird & Roche ',1914,'extant',NULL,NULL,0,0,2,0.10,0,177,'Century1.jpg;Century2.jpg',NULL,NULL,NULL),(47,'Chamber of Commerce',33,'La Salle','Chicago','Illinois','Baumann & Huehl',1888,'demolished',1928,1928,2,0,0,2.00,2,87,NULL,NULL,NULL,NULL),(48,'Champlain, first',1,'State','Chicago','Illinois','Holabird & Roche ',1894,'demolished',1916,1916,0,1,0,0.25,0,124,NULL,NULL,NULL,NULL),(49,'Champlain, second',-37,'Wabash','Chicago','Illinois','Holabird & Roche ',1903,'extant',NULL,NULL,0,1,0,0.25,1,174,'Champlain.jpg','Powers',NULL,NULL),(50,'Chapin and Gore',63,'Adams','Chicago','Illinois','Schmidt',1904,'extant',NULL,NULL,0,1,0,0.25,1,187,'ChapinGore1.jpg','Union Life;Nepeenauk',NULL,NULL),(51,'Chemical Works',NULL,'','Luban, Poland','foreign','Byrne',1912,NULL,NULL,NULL,0,0,1,0.05,0,204,NULL,NULL,NULL,NULL),(52,'Chestnut Street Theater',NULL,'','Philadelphia','USA','Strickland',1822,NULL,NULL,NULL,0,0,1,0.05,0,NULL,NULL,NULL,NULL,NULL),(53,'Chicago Building',-7,'Madison','Chicago','Illinois','Holabird & Roche ',1904,'extant',NULL,NULL,0,1,0,0.25,1,175,'ChicagoBldg1.jpg;ChicagoBldg2.jpg;ChicagoBldg3.jpg','Chicago Saving Bank',NULL,NULL),(54,'Chicago Beach Hotel',-5101,'Cornell','Chicago','Illinois','Starrett and Fuller',1890,'demolished',1946,1950,0,0,3,0.15,0,156,NULL,NULL,NULL,NULL),(55,'Chicago Business College',-207,'Wabash','Chicago','Illinois','Burnham, D.H., & Co.',1910,'demolished',1995,1995,0,1,0,0.25,1,178,NULL,'Adams and Wabash',NULL,NULL),(56,'Chicago Club',-400,'Michigan','Chicago','Illinois','Burnham & Root',1882,'demolished',1929,1929,0,0,2,0.10,0,56,NULL,NULL,NULL,NULL),(57,'Chicago Cold Storage Exchange',-300,'Lake','Chicago','Illinois','Sullivan',1891,'demolished',1902,1902,0,1,0,0.25,0,135,NULL,NULL,NULL,NULL),(58,'Chicago Garment Center',-339,'Franklin','Chicago','Illinois','Jenney',1904,'demolished',1975,1975,0,1,0,0.25,0,94,NULL,NULL,NULL,'Hirsch-Wickwire'),(59,'Chicago Herald',-161,'Washington','Chicago','Illinois','Burnham & Root',1891,'demolished',1936,1936,0,0,0,0.01,0,137,NULL,NULL,NULL,NULL),(60,'Chicago Opera House',132,'Clark','Chicago','Illinois','Cobb & Frost',1884,'demolished',1912,1912,1,0,0,1.00,1,59,NULL,NULL,NULL,NULL),(61,'Thomas Church Building',-32,'Wabash','Chicago','Illinois','Hill & Woltersdorf',1903,'extant',NULL,NULL,0,0,0,0.01,0,213,NULL,NULL,'Church, Thomas Building',NULL),(62,'Civic Center',-50,'Washington','Chicago','Illinois','C.F. Murphy Associates',1963,'extant',NULL,NULL,0,0,1,0.05,1,219,'CivicCenter.jpg',NULL,NULL,NULL),(63,'Civic Opera',20,'Wacker','Chicago','Illinois','Grahm, Anderson, Probst & White',1928,'extant',NULL,NULL,0,0,1,0.05,0,75,NULL,NULL,NULL,NULL),(64,'Grover Cleveland Elementary School',3850,'Albany','Chicago','Illinois','Perkins',1911,'extant',NULL,NULL,0,1,0,0.25,1,201,NULL,NULL,'Cleveland, Grover Elementary School',NULL),(65,'Comstock Houses',1632,'Ashland','Evanston','Illinois','Griffin',1912,'extant',NULL,NULL,0,1,0,0.25,2,210,'ComstockHouse1.jpg;ComstockHouse2.jpg',NULL,NULL,NULL),(66,'First Congregational Church of Austin',-5701,'Midway Park','Chicago','Illinois','Drummond',1908,'extant',NULL,NULL,0,1,0,0.25,1,209,NULL,'West Central Church','Congregational, First Church of Austin',NULL),(67,'Congress Hotel',-520,'Michigan ','Chicago','Illinois','Warren; Holabird & Roche',1892,'extant',NULL,NULL,2,0,0,2.00,2,154,'CongressHotel.jpg',NULL,NULL,NULL),(68,'Continental Center',55,'Jackson','Chicago','Illinois','C.F. Murphy Associates',1961,'extant',NULL,NULL,0,0,1,0.05,1,219,NULL,NULL,NULL,'CNA Plaza'),(69,'Coonley house',281,'Bloomingbank Rd','Riverside','Illinois','Wright',1908,'extant',NULL,NULL,0,0,1,0.05,0,184,NULL,NULL,NULL,NULL),(70,'Avery Coonley Kindergarten',NULL,'','Riverside','Illinois','Wright',1910,'extant',NULL,NULL,0,0,1,0.05,0,203,NULL,NULL,'Coonley, Avery, Kindergarten',NULL),(71,'Cooper Union',NULL,'','New York','USA','',1859,NULL,NULL,NULL,0,0,0,0.01,0,20,NULL,NULL,NULL,NULL),(72,'Counselman',-230,'La Salle','Chicago','Illinois','Burnham & Root',1884,'demolished',1920,1920,0,0,2,0.10,0,57,NULL,NULL,NULL,NULL),(73,'Crane, first',-1201,'Canal','Chicago','Illinois','Sullivan',1903,'demolished',1912,1912,0,0,2,0.10,0,166,NULL,NULL,NULL,NULL),(74,'Crane, second',-836,'Michigan ','Chicago','Illinois','Holabird & Roche ',1912,'extant',NULL,NULL,0,0,1,0.05,0,177,NULL,NULL,NULL,NULL),(75,'Crerar Library',150,'Michigan','Chicago','Illinois','Holabird & Roche ',1920,'demolished',1981,1981,0,0,1,0.05,0,96,NULL,NULL,NULL,NULL),(76,'Crown Hall',-3360,'State','Chicago','Illinois','Mies van der Rohe',1955,'extant',NULL,NULL,0,0,1,0.05,1,218,NULL,NULL,NULL,NULL),(77,'Crystal Palace, London',NULL,'','London','foreign','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,NULL,NULL,NULL,NULL,NULL),(78,'Crystal Palace, New York',NULL,'','New York','USA','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,NULL,NULL,NULL,NULL,NULL),(79,'Chicago Daily News',-400,'Madison','Chicago','Illinois','Holabird & Root',1929,'extant',NULL,NULL,0,0,1,0.05,0,177,NULL,NULL,'Daily News, Chicago','2 N. Riverside Plaza'),(80,'Daily News, New York',NULL,'','New York','USA','Hood',NULL,NULL,NULL,NULL,0,0,0,0.01,0,192,NULL,NULL,NULL,NULL),(81,'Dexter',-39,'Adams','Chicago','Illinois','Warren; Burnham & Root',1883,'demolished',1961,1961,0,1,0,0.25,1,58,NULL,NULL,NULL,NULL),(82,'Wirt Dexter',-630,'Wabash','Chicago','Illinois','Adler & Sullivan',1887,'demolished',2006,2006,0,1,0,0.25,1,41,NULL,NULL,'Dexter, Wirt',NULL),(83,'Arthur Dixon',-411,'Wells','Chicago','Illinois','Nimmons & Fellows',1908,'extant',NULL,NULL,0,1,0,0.25,0,180,'ArthurDixon.jpg',NULL,'Dixon, Arthur',NULL),(84,'Dwight',-626,'Clark','Chicago','Illinois','Schmidt, Garden, & Martin',1911,'extant',NULL,NULL,0,0,3,0.15,1,194,'Dwight.jpg',NULL,NULL,NULL),(85,'Edison',-229,'Wabash','Chicago','Illinois','Purcell, Feick, & Elmslie',1912,'demolished',1967,1967,1,0,0,1.00,1,183,NULL,'229 South Wabash',NULL,'Edison Phonograph Shop'),(86,'Eiffel Tower',NULL,'','Paris','foreign','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,NULL,NULL,NULL,NULL,NULL),(87,'860-880 North Lake Shore Drive',870,'Lake Shore Drive','Chicago','Illinois','Mies van der Rohe',1952,'extant',NULL,NULL,0,0,1,0.05,0,214,NULL,NULL,NULL,NULL),(88,'Esquire Theater',58,'Oak','Chicago','Illinois','Pereira',1938,'extant',NULL,NULL,0,0,0,0.01,0,129,NULL,NULL,NULL,NULL),(89,'E-Z Polish Company Factory',-3005,'Carroll','Chicago','Illinois','Wright',1905,'extant',NULL,NULL,0,0,1,0.05,0,192,NULL,NULL,NULL,NULL),(90,'Fair Store',-16,'Adams','Chicago','Illinois','Jenney',1890,'demolished',1984,1984,0,2,0,0.50,3,NULL,NULL,NULL,NULL,NULL),(91,'Charles B. Farwell Store',171,'Wabash','Chicago','Illinois','Van Osdel',1864,'demolished',1872,1872,0,0,1,0.05,0,21,NULL,NULL,'Farwell, Charles B., Store',NULL),(92,'J.V. Farwell warehouse',-350,'Monroe??','Chicago','Illinois','Van Osdel',1882,'demolished',1954,1954,0,0,1,0.05,0,24,NULL,NULL,'Farwell, J.V., warehouse',NULL),(93,'Federal Office',-219,'Dearborn','Chicago','Illinois','Mies van der Rohe',1961,'extant',NULL,NULL,0,0,0,0.01,0,59,NULL,NULL,NULL,'Dirksen Federal'),(94,'Felsenthal Store',701,'Forty-seventh','Chicago','Illinois','Sullivan',1905,'demolished',1982,1982,0,0,2,0.10,0,166,NULL,NULL,NULL,NULL),(95,'Field',-135,'La Salle','Chicago','Illinois','Graham, Anderson, Probst, & White',1934,'extant',NULL,NULL,0,0,0,0.01,0,214,NULL,NULL,NULL,'LaSalle Bank'),(96,'Marshall Field Store',111,'State','Chicago','Illinois','Burnham',1901,'extant',NULL,NULL,0,0,2,0.10,0,178,NULL,NULL,'Field, Marshall, Store',NULL),(97,'Marshall Field Wholesale Store',-200,'Wells','Chicago','Illinois','Richardson',1885,'demolished',1930,1930,2,0,0,2.00,1,60,NULL,NULL,'Field, Marshall, Wholesale Store',NULL),(98,'Field and Leiter Store',103,'State','Chicago','Illinois','??',1878,'demolished',1902,1902,0,0,0,0.01,0,89,NULL,NULL,NULL,NULL),(99,'Field and Leiter Wholesale Store',-330,'Madison','Chicago','Illinois','??',1872,'demolished',1885,1885,0,0,0,0.01,0,61,NULL,NULL,NULL,NULL),(100,'5730 Sheridan Road house',5730,'Sheridan','Chicago','Illinois','Van Bergen',1914,'demolished',1960,1960,0,0,2,0.10,1,211,NULL,NULL,NULL,NULL),(101,'World\'s Columbian Exposition Fine Arts Building',-5700,'Lake Shore Drive','Chicago','Illinois','Atwood',1892,'extant',NULL,NULL,0,0,1,0.05,0,96,NULL,'Museum of Science and Industry','Fine Arts, World\'s Columbian Exposition',NULL),(102,'First National Bank',-80,'Monroe','Chicago','Illinois','Burnham, D.H., & Co.',1896,'demolished',1969,1969,0,0,3,0.15,0,112,NULL,NULL,NULL,NULL),(103,'Fisher',-343,'Dearborn','Chicago','Illinois','Burnham, D.H., & Co.',1896,'extant',NULL,NULL,0,2,0,0.50,1,113,'Fisher.jpg;OldColonyFisherMonadnock.jpg',NULL,NULL,NULL),(104,'Flatiron',NULL,'','New York','USA','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,108,NULL,NULL,NULL,NULL),(105,'Francis Apartments',-4304,'Forrestville','Chicago','Illinois','Wright',1895,'demolished',1971,1971,0,0,3,0.15,1,158,NULL,NULL,NULL,NULL),(106,'Frankenthal',-141,'Wells','Chicago','Illinois','Adler & Sullivan',1882,'demolished',1882,1950,0,0,1,0.05,0,42,NULL,NULL,NULL,NULL),(107,'Gage Group North',-18,'Michigan','Chicago','Illinois','Sullivan',1899,'extant',NULL,NULL,0,3,0,0.75,2,141,'GageGroup.jpg',NULL,NULL,NULL),(108,'Gage Group South 1',-24,'Michigan','Chicago','Illinois','Holabird & Roche ',1898,'extant',NULL,NULL,0,1,0,0.25,2,NULL,'GageGroup.jpg',NULL,NULL,NULL),(109,'Gage Group South 2',-30,'Michigan','Chicago','Illinois','Holabird & Roche ',1898,'extant',NULL,NULL,0,1,0,0.25,2,NULL,'GageGroup.jpg',NULL,NULL,NULL),(110,'Monroe Street garage',20,'Monroe','Chicago','Illinois','Kroman',1940,'extant',NULL,NULL,0,0,3,0.15,1,213,'MonroeStGarage1.jpg',NULL,'garage, Monroe Street',NULL),(111,'Garden City Plating and Manufacturing Company factory',NULL,'Tallmadge & Ogden','Chicago','Illinois','Schmidt, Garden, & Martin',1910,NULL,NULL,NULL,0,0,3,0.15,0,194,NULL,NULL,NULL,NULL),(112,'Garden City Warehouse',-320,'Jackson','Chicago','Illinois','Smith, M. Randolph',1880,'demolished',1965,1965,0,0,1,0.05,0,58,NULL,NULL,NULL,NULL),(113,'Garrick Theater',-64,'Randolph','Chicago','Illinois','Adler & Sullivan',1891,'demolished',1961,1961,5,0,0,5.00,6,128,NULL,'Schiller',NULL,NULL),(114,'Geneva Apartments',NULL,'Rush','Chicago','Illinois','Adler & Sullivan',1884,'demolished',1884,1963,0,0,1,0.05,0,149,NULL,NULL,NULL,NULL),(115,'Glessner House',-1800,'Prarie','Chicago','Illinois','Richardson',1886,'extant',NULL,NULL,0,0,1,0.05,1,60,NULL,NULL,NULL,NULL),(116,'Great Lakes',180,'Wacker','Chicago','Illinois','Holabird & Roche ',1912,'extant',NULL,NULL,0,0,1,0.05,0,177,NULL,NULL,NULL,'180 N. Wacker Drive'),(117,'Great Northern Hotel',-237,'Dearborn','Chicago','Illinois','Burnham & Root',1890,'demolished',1940,1940,1,0,0,1.00,1,101,NULL,NULL,NULL,NULL),(118,'Great Northern Theater',-20,'Jackson','Chicago','Illinois','Burnham & Root',1896,'demolished',1961,1961,0,1,0,0.25,1,109,NULL,NULL,NULL,NULL),(119,'Grommes and Ulrich Company Warehouse',-108,'Illinois','Chicago','Illinois','Schmidt',1901,'extant',NULL,NULL,0,1,0,0.25,0,187,'GrommesUlrich.jpg','W.H. Long Company','Long, W.H., Company',NULL),(120,'Guaranty',NULL,'','Buffalo','USA','',NULL,NULL,NULL,NULL,0,0,0,0.01,1,138,NULL,'Prudential (Buffalo)',NULL,NULL),(121,'Hammond Library',44,'Ashland','Chicago','Illinois','Burnham & Root',1882,'demolished',1963,1963,0,0,0,0.01,0,42,NULL,'Union Theological College',NULL,NULL),(122,'Harper and Brothers',NULL,'','New York','USA','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,20,NULL,NULL,NULL,NULL),(123,'Hartford Fire Insurance',-100,'Wacker','Chicago','Illinois','Skidmore, Owings, & Merrill',1961,'extant',NULL,NULL,0,0,2,0.10,1,218,NULL,NULL,NULL,NULL),(124,'Healy Chapel',NULL,'','Aurora','Illinois','Elmslie',1926,'extant',NULL,NULL,0,0,3,0.15,0,185,NULL,NULL,NULL,NULL),(125,'Henrotin Hospital',-111,'Oak','Chicago','Illinois','Schmidt',1906,'demolished',1933,1933,0,1,0,0.25,0,191,NULL,NULL,NULL,NULL),(126,'Heyworth',29,'Madison','Chicago','Illinois','Burnham, D.H., & Co.',1905,'extant',NULL,NULL,0,1,0,0.25,0,114,'Heyworth1.jpg;Heyworth2.jpg',NULL,NULL,NULL),(127,'Hollywood Towers',5701,'Sheridan','Chicago','Illinois','Solomon and Cordwell',1962,'extant',NULL,NULL,0,0,1,0.05,0,219,NULL,NULL,NULL,NULL),(128,'Home Insurance',-135,'La Salle','Chicago','Illinois','Jenney',1885,'demolished',1931,1931,7,0,0,7.00,2,80,NULL,NULL,NULL,NULL),(129,'Horstman. William H. and Sons factory',NULL,'','Philadelphia','USA','Hoxie',1853,NULL,NULL,NULL,0,0,1,0.05,0,39,NULL,NULL,NULL,NULL),(130,'World Columbian Exposition Horticultural Building',NULL,'Jackson Park (Exposition)','Chicago','Illinois','Jenney',1893,'demolished',1894,1894,0,0,0,0.01,0,29,NULL,NULL,'Horticultural, World Columbian Exposition',NULL),(131,'Horton house',NULL,'??','Chicago','Illinois','??',1868,NULL,NULL,NULL,0,0,1,0.05,0,23,NULL,NULL,NULL,NULL),(132,'Charles Hull house',-800,'Halsted','Chicago','Illinois','??',1856,'extant',NULL,NULL,2,0,0,2.00,0,206,'HullHouse2.jpg;HullHouse3.jpg;HullHouse1.jpg',NULL,'Hull, Charles, house',NULL),(133,'Hull House group',-800,'Halsted','Chicago','Illinois','Pond brothers',1890,'demolished',1961,1963,2,0,0,2.00,1,206,'HullHouseDining2.jpg',NULL,NULL,NULL),(134,'Humboldt Park boathouse',1355,'Sacramento','Chicago','Illinois','Garden',1907,'extant',NULL,NULL,0,0,3,0.15,1,193,NULL,NULL,NULL,NULL),(135,'Hungerford Fish Market',NULL,'','London','foreign','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,67,NULL,NULL,NULL,NULL),(136,'Hunter',-337,'Madison','Chicago','Illinois','Eckstrom',1908,'demolished',1978,1978,0,1,0,0.25,1,177,NULL,'Liberty Mutual;Liberty Mutual Insurance',NULL,NULL),(137,'Hyde Park Hotel',1520,'Hyde Park Blvd','Chicago','Illinois','Starrett',1888,'demolished',1963,1963,2,0,0,2.00,3,150,NULL,NULL,NULL,NULL),(138,'Illinois Bank',21,'Dearborn','Chicago','Illinois','Burnham & Root',1886,'demolished',1933,1933,0,0,3,0.15,0,57,NULL,NULL,NULL,NULL),(139,'Immaculata High School',-640,'Irving Park','Chicago','Illinois','Byrne',1922,'extant',NULL,NULL,0,1,0,0.25,2,204,'ImmaculataHS1.jpg;ImmaculataHS.jpg',NULL,NULL,NULL),(140,'Imperial Hotel',NULL,'','Tokyo','foreign','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,210,NULL,NULL,NULL,NULL),(141,'Inland Steel',-30,'Monroe','Chicago','Illinois','Skidmore, Owings, & Merrill',1957,'extant',NULL,NULL,0,0,2,0.10,1,218,'InlandSteel.jpg',NULL,NULL,NULL),(142,'Insurance Exchange',-208,'La Salle','Chicago','Illinois','Burnham & Root',1885,'demolished',1912,1912,0,1,0,0.25,1,57,NULL,'Continental Bank',NULL,NULL),(143,'International Leather and Belting Company factory',NULL,'??','Chicago','Illinois','Purcell & Elmslie',1918,NULL,NULL,NULL,0,2,0,0.50,1,184,NULL,NULL,NULL,NULL),(144,'Isabella',21,'Van Buren','Chicago','Illinois','Jenney',1893,'demolished',2003,2013,0,1,0,0.25,0,93,NULL,NULL,NULL,NULL),(145,'Jayne',NULL,'','Philadelphia','USA','Johnston & Walter',1850,NULL,NULL,NULL,0,0,0,0.01,0,38,NULL,NULL,NULL,NULL),(146,'Jeweler\'s',-15,'Wabash','Chicago','Illinois','Adler & Sullivan',1882,'extant',NULL,NULL,0,0,2,0.10,1,39,'Jewelers3.jpg',NULL,NULL,NULL),(147,'S.C. Johnson Company research tower',NULL,'','Racine','USA','Wright',1950,NULL,NULL,NULL,0,0,0,0.01,0,219,NULL,NULL,'Johnson, S.C., and Company research tower',NULL),(148,'Kelley, Maus and Company warehouse',-405,'Lake','Chicago','Illinois','Hunt',1903,'demolished',1965,1990,1,0,0,1.00,0,189,NULL,'Graham Paper Company',NULL,NULL),(149,'Kendall',40,'Dearborn','Chicago','Illinois','Van Osdel',1871,'demolished',1940,1940,0,1,0,0.25,0,24,NULL,'Equitable;Real Estate Exchange',NULL,NULL),(150,'Kenilworth Club',410,'Kenilworth','Kenilworth','Illinois','Maher',1906,'extant',NULL,NULL,0,1,0,0.25,1,195,'KenilworthClub1.jpg;KenilworthClub2.jpg;KenilworthClub3.jpg',NULL,NULL,NULL),(151,'Kennedy Bakery',27,'Des Plaines','Chicago','Illinois','Adler & Sullivan',1884,'demolished',1972,1972,0,0,2,0.10,0,39,NULL,'Pettibone Printing Company',NULL,NULL),(152,'Kent',-415,'Franklin','Chicago','Illinois','Pond brothers',1903,'demolished',1950,1953,0,0,0,0.01,0,205,NULL,'Kuppenheimer',NULL,NULL),(153,'Knisely',-551,'Monroe','Chicago','Illinois','Adler & Sullivan',1884,'demolished',1956,1959,0,0,3,0.15,0,40,NULL,NULL,NULL,NULL),(154,'Krause Music Store',4611,'Lincoln','Chicago','Illinois','Sullivan',1922,'extant',NULL,NULL,0,0,2,0.10,1,166,'KrauseMusic.jpg',NULL,NULL,NULL),(155,'Union Tank Car',-111,'Jackson','Chicago','Illinois','Epstein & Sons',1961,'extant',NULL,NULL,0,0,0,0.01,0,57,NULL,NULL,NULL,'Transunion'),(156,'La Salle-Monroe',-37,'La Salle','Chicago','Illinois','Jenney & Mundie ',1894,'extant',NULL,NULL,0,0,0,0.01,0,24,'NewYorkLife(La Salle-Monroe).jpg',NULL,NULL,NULL),(157,'Lafayette Apartments',NULL,'Dearborn','Chicago','Illinois','??',1887,'demolished',1887,1963,0,0,1,0.05,0,149,NULL,NULL,NULL,NULL),(158,'Lake Shore Club',850,'Lake Shore Drive','Chicago','Illinois','Hunt',1924,'extant',NULL,NULL,0,0,0,0.01,0,189,NULL,NULL,NULL,NULL),(159,'Lakeside',-111,'Adams','Chicago','Illinois','Jenney',1873,'demolished',1926,1926,0,0,2,0.10,0,31,NULL,NULL,NULL,NULL),(160,'Lakota Hotel',-3001,'Michigan','Chicago','Illinois','Warren?',1893,'demolished',1959,1959,0,0,3,0.15,1,157,NULL,NULL,NULL,'Lewis Memorial Hospital'),(161,'Langdon Apartments',NULL,'Des Plaines','Chicago','Illinois','Perkins',1903,NULL,NULL,NULL,0,0,3,0.15,0,159,NULL,NULL,NULL,NULL),(162,'Larkin',NULL,'','Buffalo','USA','Wright',1905,'demolished',1950,1950,0,0,0,0.01,0,165,NULL,NULL,NULL,NULL),(163,'Leiter, first',-200,'Monroe','Chicago','Illinois','Jenney',1879,'demolished',1972,1972,1,0,0,1.00,2,79,NULL,'Morris',NULL,NULL),(164,'Leiter, second',-401,'State','Chicago','Illinois','Jenney',1891,'extant',NULL,NULL,2,0,0,2.00,1,89,'LeiterII.jpg;LeiterII-1.jpg','Siegel, Cooper and Company;Sears Roebuck Store',NULL,NULL),(165,'Leland',NULL,'','Philadelphia','USA','',1855,NULL,NULL,NULL,0,0,0,0.01,0,38,NULL,NULL,NULL,NULL),(166,'Lemoyne',180,'Wabash','Chicago','Illinois','Mundie, Jensen, and McClurg',1915,'extant',NULL,NULL,0,1,0,0.25,1,178,'Lemoyne.jpg',NULL,NULL,NULL),(167,'Abraham Lincoln Center',-700,'Oakwood','Chicago','Illinois','Perkins; Wright',1903,'extant',NULL,NULL,0,1,0,0.25,0,200,'LincolnCenter.jpg',NULL,'Lincoln, Abraham, Center',NULL),(168,'Lincoln Park Zoo Pavilions',-225,'Fullerton','Chicago','Illinois','Chicago Park District; Alfred Caldwell',1936,'extant',NULL,NULL,0,0,5,0.25,2,214,NULL,NULL,NULL,NULL),(169,'Lind',-350,'Randolph','Chicago','Illinois','??',1852,'demolished',1963,1963,0,0,2,0.10,0,20,NULL,NULL,NULL,NULL),(170,'Linthicum house',1315,'Forest','Evanston','Illinois','Tallmadge and Watson',1908,'extant',NULL,NULL,0,0,1,0.05,1,208,'LinthicumHouse.jpg',NULL,NULL,NULL),(171,'Lloyd',-200,'Randolph','Chicago','Illinois','??',1855,'demolished',1871,1871,0,0,2,0.10,0,20,NULL,NULL,NULL,NULL),(172,'Lord\'s Store',625,'Davis','Evanston','Illinois','Walter',1906,'demolished',1965,1969,0,0,2,0.10,1,186,NULL,'625 Davis Street',NULL,NULL),(173,'Lorimer Baptist Church',-7291,'St. Laurance','Chicago','Illinois','Drummond',1914,'extant',NULL,NULL,0,0,2,0.10,1,209,NULL,NULL,NULL,NULL),(174,'Ludington',-1104,'Wabash','Chicago','Illinois','Jenney',1891,'extant',NULL,NULL,0,1,0,0.25,1,92,'Ludington1.jpg;Ludington2.jpg',NULL,NULL,NULL),(175,'McClurg',-218,'Wabash','Chicago','Illinois','Holabird & Roche ',1900,'extant',NULL,NULL,0,1,0,0.25,1,126,'McClurg.jpg','Crown',NULL,NULL),(176,'McCormick Place',-2300,'Lake Shore Drive','Chicago','Illinois','Shaw, Metz & Dolio',1960,'demolished',1967,1967,0,0,0,0.01,0,156,NULL,'Metropolitan Fair and Exposition',NULL,NULL),(177,'McCullough Shot and Lead Co. Tower',NULL,'','New York','USA','Bogardus',1855,NULL,NULL,NULL,0,0,0,0.01,0,81,NULL,NULL,NULL,NULL),(178,'McGraw Hill',NULL,'','New York','USA','Root',1930,'demolished',1998,1998,0,0,0,0.01,0,190,NULL,NULL,NULL,NULL),(179,'McVickers Theater',-25,'Madison','Chicago','Illinois','Adler & Sullivan',1885,'demolished',1922,1922,0,2,0,0.50,1,40,NULL,NULL,NULL,NULL),(180,'Maison Clarté, Geneva',NULL,'','Geneva','foreign','Le Corbusier',1933,'extant',NULL,NULL,0,0,0,0.01,0,147,NULL,NULL,NULL,NULL),(181,'Majestic Hotel',189,'Madison','Chicago','Illinois','Burnham',1893,'demolished',1961,1961,0,2,0,0.50,1,108,NULL,NULL,NULL,NULL),(182,'Mandel Store Annex',2,'Wabash','Chicago','Illinois','Holabird & Roche ',1900,'extant',NULL,NULL,0,1,0,0.25,1,176,NULL,NULL,NULL,NULL),(183,'Manhattan',-431,'Dearborn','Chicago','Illinois','Jenney & Mundie ',1891,'extant',NULL,NULL,2,0,0,2.00,3,91,'Manhattan.jpg',NULL,NULL,NULL),(184,'Marina City',300,'Dearborn','Chicago','Illinois','Goldberg',1963,'extant',NULL,NULL,0,0,2,0.10,0,219,'MarinaCity.jpg',NULL,NULL,NULL),(185,'Marquette',-140,'Dearborn','Chicago','Illinois','Holabird & Roche ',1894,'extant',NULL,NULL,2,0,0,2.00,2,120,'Marquette.jpg;MarquetteReflection.jpg;MarquetteLobby.jpg',NULL,NULL,NULL),(186,'Masonic Temple',151,'State','Chicago','Illinois','Burnham & Root',1892,'demolished',1939,1939,3,0,0,3.00,2,104,NULL,'Capitol',NULL,NULL),(187,'Mecca Apartments',-3401,'State','Chicago','Illinois','Edbrooke & Burnham',1892,'demolished',1952,1952,0,0,4,0.20,0,156,NULL,NULL,NULL,NULL),(188,'Medinah',-176,'Jackson','Chicago','Illinois','Beers, Clay & Dutton',1893,'demolished',1969,1969,0,0,1,0.05,0,111,NULL,NULL,NULL,NULL),(189,'Menier Chocolate Works',NULL,'','Noisiel, France','foreign','Saulnier',1872,'extant',NULL,NULL,0,0,2,0.10,0,7,NULL,NULL,NULL,NULL),(190,'Methodist Episcopal Church of Maywood',-502,'Sixth','Maywood','Illinois','Drummond',1912,'extant',NULL,NULL,0,0,2,0.10,0,209,NULL,'Christ Temple Church of the Apostolic Faith',NULL,NULL),(191,'Metropole Hotel',-2281,'Michigan','Chicago','Illinois','Warren',1891,'demolished',1994,1994,0,1,0,0.25,1,153,NULL,NULL,NULL,NULL),(192,'Meyer',-301,'Van Buren','Chicago','Illinois','Adler & Sullivan',1893,'demolished',1968,1968,0,1,0,0.25,1,135,NULL,NULL,NULL,NULL),(193,'New Michigan Hotel',-2135,'Michigan','Chicago','Illinois','Warren',1892,'demolished',1995,1995,0,1,0,0.25,1,153,NULL,'Lexington Hotel','Michigan, New, Hotel',NULL),(194,'Michigan Terrace Apts',535,'Michigan','Chicago','Illinois','Raggie & Malitz',1963,'extant',NULL,NULL,0,0,1,0.05,0,219,NULL,NULL,NULL,NULL),(195,'Midway Gardens',-6000,'Cottage Grove','Chicago','Illinois','Wright',1914,'demolished',1929,1929,0,0,0,0.01,0,205,NULL,NULL,NULL,NULL),(196,'Mills',220,'Montgomery','San Francisco','USA','Burnham & Root',1882,'extant',NULL,NULL,0,0,0,0.01,0,140,NULL,NULL,NULL,NULL),(197,'Monadnock',-53,'Jackson','Chicago','Illinois','Burnham & Root',1891,'extant',NULL,NULL,4,0,0,4.00,3,65,'Monadnock.jpg;OldColonyFisherMonadnock.jpg','Monadnock and Kearsage',NULL,NULL),(198,'Monadnock addition',-332,'Dearborn','Chicago','Illinois','Holabird & Roche ',1893,'extant',NULL,NULL,0,2,0,0.50,1,118,NULL,'Katahdin',NULL,NULL),(199,'Montauk',-64,'Monroe','Chicago','Illinois','Burnham & Root',1882,'demolished',1902,1902,5,0,0,5.00,1,51,NULL,NULL,NULL,NULL),(200,'Monticello',NULL,'','Virginia','USA','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,133,NULL,NULL,NULL,NULL),(201,'Moody\'s Tabernacle',810,'La Salle','Chicago','Illinois','Sullivan',1876,'demolished',1939,1939,0,2,0,0.50,0,35,NULL,NULL,NULL,NULL),(202,'Mormon Tabernacle',NULL,'','Salt Lake City','USA','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,33,NULL,NULL,NULL,NULL),(203,'Morton',-538,'Dearborn','Chicago','Illinois','Jenney & Mundie ',1896,'extant',NULL,NULL,0,0,3,0.15,1,93,'Morton.jpg',NULL,NULL,NULL),(204,'Morton Apartments',-1800,'Michigan','Chicago','Illinois','??',1889,'demolished',1889,1963,0,0,1,0.05,0,149,NULL,NULL,NULL,NULL),(205,'Moses',-200,'Jackson','Chicago','Illinois','??',1912,'demolished',1965,1968,0,0,1,0.05,0,146,NULL,NULL,NULL,NULL),(206,'Mount Vernon',NULL,'','Virginia','USA','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,133,NULL,NULL,NULL,NULL),(207,'Museum of Natural History',-1400,'Lake Shore Drive','Chicago','Illinois','Graham, Anderson, Probst, & White',1911,'extant',NULL,NULL,0,0,0,0.01,0,96,NULL,'Field Museum',NULL,NULL),(208,'Newberry Library',-60,'Walton','Chicago','Illinois','Cobb',1892,'extant',NULL,NULL,0,0,1,0.05,0,59,NULL,NULL,NULL,NULL),(209,'900 N Michigan Ave',900,'Michigan','Chicago','Illinois','Hunt',1927,'demolished',1984,1984,0,0,0,0.01,0,189,NULL,NULL,NULL,NULL),(210,'Nixon',-128,'Monroe','Chicago','Illinois','Matz',1871,'demolished',1889,1889,0,1,0,0.25,1,23,NULL,NULL,NULL,NULL),(211,'Northwestern Technological Institute',2145,'Sheridan','Evanston','Illinois','Holabird & Root',1941,'extant',NULL,NULL,0,0,0,0.01,0,198,NULL,NULL,NULL,NULL),(212,'Old Colony',-407,'Dearborn','Chicago','Illinois','Holabird & Roche ',1894,'extant',NULL,NULL,2,0,0,2.00,4,122,'OldColonyGap.jpg;OldColonyFisherMonadnock.jpg',NULL,NULL,NULL),(213,'Omaha Apartments',NULL,'??','Chicago','Illinois','Pond brothers',1893,'demolished',1893,1963,0,0,4,0.20,0,157,NULL,NULL,NULL,NULL),(214,'1 North La Salle',1,'La Salle','Chicago','Illinois','Vitzhum & Burns',1930,'extant',NULL,NULL,0,0,0,0.01,0,117,NULL,NULL,NULL,NULL),(215,'120 South La Salle',-120,'La Salle','Chicago','Illinois','Graham, Anderson, Probst, & White',1928,'extant',NULL,NULL,0,0,0,0.01,0,104,NULL,NULL,NULL,'State Bank'),(216,'Palmer House',1,'Monroe','Chicago','Illinois','Van Osdel',1875,'demolished',1925,1925,0,0,1,0.05,0,149,NULL,NULL,NULL,'Palmer House 3'),(217,'Palmolive',919,'Michigan','Chicago','Illinois','Holabird & Root',1929,'extant',NULL,NULL,0,0,1,0.05,0,177,NULL,NULL,NULL,NULL),(218,'Park Gate Hotel',NULL,'Fifty-ninth','Chicago','Illinois','Flanders & Zimmerman',1892,'demolished',1910,1963,0,0,3,0.15,0,156,NULL,NULL,NULL,NULL),(219,'Parker Apartments',-3100,'Cottage Grove','Chicago','Illinois','??',1889,'demolished',1889,1963,0,0,0,0.01,0,150,NULL,NULL,NULL,NULL),(220,'Parthenon',NULL,'','Athens, Greece','foreign','',NULL,'extant',NULL,NULL,0,0,0,0.01,0,10,NULL,NULL,NULL,NULL),(221,'Patten Gymnasium',2145,'Sheridan','Evanston','Illinois','Maher',1909,'demolished',1940,1940,0,1,0,0.25,2,196,NULL,NULL,NULL,NULL),(222,'Patten House',NULL,'??','Evanston','Illinois','Maher',1902,NULL,NULL,NULL,0,0,0,0.01,0,196,NULL,NULL,NULL,NULL),(223,'Pennsylvania Railroad grain elevator',NULL,'','Philadelphia','USA','Johnson, George A.',1862,NULL,NULL,NULL,0,0,1,0.05,0,82,NULL,NULL,NULL,NULL),(224,'Phelps, Dodge and Palmer',-200,'Adams','Chicago','Illinois','Burling & Whitehouse',1882,'demolished',1965,1985,0,1,0,0.25,1,145,NULL,NULL,NULL,NULL),(225,'Pickwick Apartments',NULL,'Michigan','Chicago','Illinois','Burnham & Root',1887,'demolished',1887,1963,0,0,1,0.05,0,101,NULL,NULL,NULL,NULL),(226,'Stanley R. Pierce Hall',-5514,'University','Chicago','Illinois','Weese',1960,'demolished',2013,2013,0,0,1,0.05,1,219,NULL,NULL,'Pierce, Stanley R., Hall',NULL),(227,'Plaza Hotel',1553,'Clark','Chicago','Illinois','Warren',1892,'demolished',1965,1965,0,1,0,0.25,1,154,NULL,NULL,NULL,NULL),(228,'Pontiac',-542,'Dearborn','Chicago','Illinois','Holabird & Roche ',1891,'extant',NULL,NULL,0,1,0,0.25,1,119,'Pontiac.jpg',NULL,NULL,NULL),(229,'Portland',33,'Dearborn','Chicago','Illinois','Jenney',1872,'demolished',1933,1933,0,1,0,0.25,0,30,NULL,NULL,NULL,NULL),(230,'Post Office and Customs House',-50,'Monroe','Chicago','Illinois','Van Osdel',1855,'demolished',1871,1871,0,0,2,0.10,0,208,NULL,NULL,NULL,NULL),(231,'Promontory Apartments',-5530,'Lake Shore Drive','Chicago','Illinois','Mies van der Rohe',1949,'extant',NULL,NULL,0,0,1,0.05,1,218,NULL,NULL,NULL,NULL),(232,'Prudential',130,'Randolph','Chicago','Illinois','Naess & Murphy',1955,'extant',NULL,NULL,0,0,1,0.05,0,214,NULL,NULL,NULL,'One Prudential Plaza'),(233,'Public Library',78,'Washington','Chicago','Illinois','Shepley, Rutan & Coolidge',1897,'extant',NULL,NULL,0,0,1,0.05,0,96,NULL,NULL,NULL,NULL),(234,'Pullman',-200,'Michigan','Chicago','Illinois','Beman',1885,'demolished',1950,1950,0,0,0,0.01,0,143,NULL,NULL,NULL,NULL),(235,'Railway Exchange',80,'Jackson','Chicago','Illinois','Burnham, D.H., & Co.',1904,'extant',NULL,NULL,1,0,0,1.00,1,113,'RailwayExchange.jpg',NULL,NULL,'Santa Fe Center'),(236,'Rand McNally',-160,'Adams','Chicago','Illinois','Burnham & Root',1890,'demolished',1911,1911,2,0,0,2.00,2,99,NULL,NULL,NULL,NULL),(237,'Michael Reese Hospital',-2889,'Ellis','Chicago','Illinois','Schmidt',1906,'demolished',2010,2010,0,2,0,0.50,1,191,'MichaelReese(Singer).jpg',NULL,'Reese, Michael, Hospital',NULL),(238,'Reid, Murdoch and Company',325,'La Salle','Chicago','Illinois','Nimmons & Fellows',1913,'extant',NULL,NULL,0,1,0,0.25,1,180,'ReidMurdoch.jpg','Monarch Foods Company',NULL,NULL),(239,'Reid house',-2013,'Prarie','Chicago','Illinois','Beers, Clay & Dutton',1894,'extant',NULL,NULL,0,1,0,0.25,0,111,'ReidHouse1.jpg;ReidHouse2.jpg',NULL,NULL,NULL),(240,'Reliance',32,'State','Chicago','Illinois','Atwood',1895,'extant',NULL,NULL,2,0,0,2.00,1,109,'Reliance.jpg',NULL,NULL,NULL),(241,'Republic',-209,'State','Chicago','Illinois','Holabird & Roche ',1905,'demolished',1961,1961,1,0,0,1.00,2,175,NULL,'Home Federal Savings and Loan',NULL,NULL),(242,'Revell',50,'Adams','Chicago','Illinois','Sullivan',1883,'demolished',1968,1968,0,0,5,0.25,2,39,NULL,NULL,NULL,NULL),(243,'Robie house',-5757,'Woodlawn','Chicago','Illinois','Wright',1908,'extant',NULL,NULL,0,0,1,0.05,0,193,NULL,NULL,NULL,NULL),(244,'Rookery',-201,'La Salle','Chicago','Illinois','Burnham & Root',1886,'extant',NULL,NULL,2,0,0,2.00,7,63,'RookeryLobby1.jpg;RookeryLobby2.jpg;Rookery.jpg;RookeryCrows.jpg',NULL,NULL,NULL),(245,'Rosenfeld',-743,'Washington','Chicago','Illinois','Adler & Sullivan',1882,'demolished',1958,1958,0,0,1,0.05,0,42,NULL,NULL,NULL,NULL),(246,'Rothschild Store',-210,'Monroe','Chicago','Illinois','Sullivan',1881,'demolished',1972,1972,1,0,0,1.00,1,38,NULL,NULL,NULL,'Milton F. Goodman'),(247,'Ryerson',16,'Randolph','Chicago','Illinois','Sullivan',1884,'demolished',1939,1939,0,0,3,0.15,0,40,NULL,NULL,NULL,NULL),(248,'St. Anne\'s Church, Liverpool',NULL,'','Liverpool','foreign','',NULL,NULL,NULL,NULL,0,0,0,0.01,0,6,NULL,NULL,NULL,NULL),(249,'St. Anne\'s Hospital',-4950,'Thomas','Chicago','Illinois','Schmidt',1903,'extant',NULL,NULL,0,0,1,0.05,0,191,NULL,NULL,NULL,NULL),(250,'St. Mary\'s Church (1833)',200,'State','Chicago','Illinois','Taylor',1833,'demolished',1833,1871,0,0,1,0.05,0,8,NULL,NULL,NULL,NULL),(251,'St. Mary\'s Church (1868)',-901,'Wabash','Chicago','Illinois','Randall',1868,'demolished',1970,1970,0,0,1,0.05,0,20,NULL,'Plymouth Congregational Church',NULL,NULL),(252,'St. Mary\'s High School',-2044,'Grenshaw','Chicago','Illinois','Byrne',1924,'demolished',1977,1977,0,0,0,0.01,0,204,NULL,NULL,NULL,NULL),(253,'St. Ouen docks warehouse, Paris',NULL,'','Paris','foreign','Fontaine',1866,NULL,NULL,NULL,0,0,0,0.01,0,7,NULL,NULL,NULL,NULL),(254,'Church of St. Thomas the Apostle',-5472,'Kimbark','Chicago','Illinois','Byrne',1924,'extant',NULL,NULL,0,0,0,0.01,0,204,NULL,NULL,'St. Thomas the Apostle, Church of',NULL),(255,'Schoenhofen Brewery powerhouse',-500,'Eighteenth','Chicago','Illinois','Schmidt',1902,'extant',NULL,NULL,0,2,0,0.50,1,188,'Schoenhofen.jpg;SchoenhofenEntrance.jpg','Morningstar-Paisley Company',NULL,NULL),(256,'Carl Schurz High School',3601,'Milwaukee','Chicago','Illinois','Perkins',1908,'extant',NULL,NULL,1,0,0,1.00,2,202,NULL,NULL,'Schurz, Carl High School',NULL),(257,'Scoville',-619,'Washington','Chicago','Illinois','Adler & Sullivan',1885,'demolished',1970,1974,0,0,1,0.05,0,42,NULL,NULL,NULL,NULL),(258,'Joseph Sears Elementary School',542,'Abbotsford','Kenilworth','Illinois','Maher',1912,'extant',NULL,NULL,0,1,0,0.25,1,200,NULL,NULL,'Sears, Joseph, Elementary School',NULL),(259,'Sears Roebuck merchandise plant',-924,'Homan','Chicago','Illinois','Nimmons & Fellows',1906,'demolished',1978,1978,1,0,0,1.00,0,179,NULL,NULL,NULL,NULL),(260,'Second City night club',1616,'Wells','Chicago','Illinois','Goldstein',1961,'extant',NULL,NULL,0,0,1,0.05,0,133,NULL,NULL,NULL,NULL),(261,'Selz, Schwab and Company factory',NULL,'Superior','Chicago','Illinois','Adler & Sullivan',1887,NULL,NULL,NULL,0,0,4,0.20,0,39,NULL,NULL,NULL,NULL),(262,'7415 Sheridan Road',7415,'Sheridan','Chicago','Illinois','Wright',1915,'extant',NULL,NULL,0,0,1,0.05,0,210,NULL,NULL,NULL,NULL),(263,'Sheraton Hotel',505,'Michigan','Chicago','Illinois','Alschlager',1929,'extant',NULL,NULL,0,0,1,0.05,0,154,NULL,NULL,NULL,'Continental Hotel;Medinah Club;Chicago Towers'),(264,'Sheridan House',310,'Church','Evanston','Illinois','Maher',1911,'extant',NULL,NULL,0,1,0,0.25,1,199,'SheridanHouse.jpg',NULL,NULL,NULL),(265,'John Shillito Store',NULL,'','Cincinnati','USA','McLaughlin',1877,NULL,NULL,NULL,0,0,2,0.10,0,6,NULL,NULL,'Shillito, John, Store',NULL),(266,'Hiram Sibley and Company Warehouse',315,'Clark','Chicago','Illinois','Edbrooke',1883,'demolished',1980,1989,0,1,0,0.25,1,58,NULL,NULL,'Sibley, Hiram, and Company Warehouse',NULL),(267,'608 Davis Street',608,'Davis','Evanston','Illinois','Tallmadge and Watson',1910,'extant',NULL,NULL,0,0,4,0.20,1,208,'608DavisStreet.jpg',NULL,NULL,NULL),(268,'Society Brand',-416,'Franklin','Chicago','Illinois','Graham, Burnham, and Co.',1912,'demolished',1965,1990,0,0,3,0.15,1,178,NULL,'Alfred Decker and Cohn','Decker, Alfred and Cohn',NULL),(269,'Standard Club',-2400,'Michigan','Chicago','Illinois','Sullivan',1888,'demolished',1910,1910,0,1,0,0.25,1,41,NULL,NULL,NULL,NULL),(270,'Steinway Hall',64,'Van Buren','Chicago','Illinois','Perkins',1896,'demolished',1965,1969,0,0,3,0.15,0,200,NULL,NULL,NULL,NULL),(271,'Stock Exchange',30,'La Salle','Chicago','Illinois','Sullivan',1894,'demolished',1972,1972,2,0,0,2.00,5,136,NULL,NULL,NULL,'30 N. LaSalle Street'),(272,'Studebaker',-629,'Wabash','Chicago','Illinois','Beman',1895,'extant',NULL,NULL,0,1,0,0.25,2,145,'Studebaker.jpg','Brunswick',NULL,NULL),(273,'Student Union, Purdue University',NULL,'','West Lafayette, Indiana','USA','Pond brothers',1929,NULL,NULL,NULL,0,0,0,0.01,0,207,NULL,NULL,NULL,NULL),(274,'Student Union, University of Michigan',NULL,'','Ann Arbor, Michigan','USA','Pond brothers',1917,NULL,NULL,NULL,0,0,0,0.01,0,207,NULL,NULL,NULL,NULL),(275,'Swift Hall',2029,'Sheridan','Evanston','Illinois','Maher',1909,'extant',NULL,NULL,1,0,0,1.00,1,197,'SwiftHall.jpg',NULL,NULL,NULL),(276,'Tacoma',1,'La Salle','Chicago','Illinois','Holabird & Roche ',1889,'demolished',1929,1929,2,0,0,2.00,1,117,NULL,NULL,NULL,NULL),(277,'1014 Davis Street',1014,'Davis','Chicago','Illinois','Blake',1905,'demolished',1965,1969,0,0,1,0.05,0,186,NULL,NULL,NULL,NULL),(278,'320 South Franklin Street',-320,'Frankin','Chicago','Illinois','Holabird & Roche ',1898,'demolished',1950,1963,0,0,1,0.05,0,125,NULL,NULL,NULL,NULL),(279,'325 West Jackson Boulevard',-325,'Jackson','Chicago','Illinois','Holabird & Roche ',1904,'demolished',1965,1990,0,0,1,0.05,1,174,NULL,NULL,NULL,NULL),(280,'3200 South Prarie Avenue (apartments)',-3200,'Prarie','Chicago','Illinois','Adler & Sullivan',1882,'demolished',1882,1963,0,0,1,0.05,0,149,NULL,NULL,NULL,NULL),(281,'Illinois Bell Telephone Company Toll Building',111,'Franklin','Chicago','Illinois','Pond brothers',1908,'demolished',1967,1967,0,1,0,0.25,1,205,NULL,NULL,'Toll, Illinois Bell Telephone Company','Illinois Bell'),(282,'World\'s Columbian Exposition Transportation Building',-6200,'Stoney Island','Chicago','Illinois','Sullivan',1893,'demolished',1894,1895,0,2,0,0.50,2,136,NULL,NULL,'Transportation, World\'s Columbian Exposition',NULL),(283,'Tribune',435,'Michigan','Chicago','Illinois','Howells & Hood',1925,'extant',NULL,NULL,0,0,0,0.01,0,161,'TribuneTower.jpg',NULL,NULL,NULL),(284,'Troescher',-15,'Wacker','Chicago','Illinois','Adler & Sullivan',1884,'demolished',1978,1978,0,1,0,0.25,1,80,NULL,'Chicago Joint Board;Chicago Journal;Sullivan',NULL,'Daily Times'),(285,'Lyman Trumball Elementary School',5200,'Ashland','Chicago','Illinois','Perkins',1909,'extant',NULL,NULL,0,1,0,0.25,1,201,NULL,NULL,'Trumball, Lyman Elementary School',NULL),(286,'241 Chestnut Street, Philadelphia',NULL,'','Philadelphia','USA','Button',1852,NULL,NULL,NULL,0,0,1,0.05,0,38,NULL,NULL,NULL,NULL),(287,'Union Bus Terminal',155,'Clark','Chicago','Illinois','??',1949,'demolished',1985,1985,0,0,0,0.01,0,103,NULL,NULL,NULL,NULL),(288,'Unitarian Church of Evanston',1300,'Chicago','Evanston','Illinois','Mahoney',1904,'demolished',1960,1960,0,1,0,0.25,1,210,NULL,NULL,NULL,NULL),(289,'United States Warehousing Company grain elevator',NULL,'','Brooklyn','USA','Johnson, George A.',1860,NULL,NULL,NULL,0,0,3,0.15,0,81,NULL,NULL,NULL,NULL),(290,'Unity',127,'Dearborn','Chicago','Illinois','Warren',1892,'demolished',1990,1990,0,1,0,0.25,1,151,NULL,NULL,NULL,NULL),(291,'Unity Church',875,'Lake','Oak Park','Illinois','Wright',1906,'extant',NULL,NULL,0,0,1,0.05,0,208,NULL,NULL,NULL,NULL),(292,'University',1604,'Chicago','Evanston','Illinois','Maher',1906,'extant',NULL,NULL,0,1,0,0.25,1,196,'UniversityBuilding1.jpg;UniversityBuilding2.jpg',NULL,NULL,NULL),(293,'University Apartments',1450,'Fifty-fifth','Chicago','Illinois','Pei and Weese',1961,'extant',NULL,NULL,0,0,4,0.20,0,190,NULL,NULL,NULL,NULL),(294,'Van Nelle Tobacco Company factory',NULL,'','Netherlands','foreign','van der Vlugt',1931,'extant',NULL,NULL,0,0,0,0.01,0,147,NULL,NULL,NULL,NULL),(295,'Victoria Hotel',69,'Illinois','Chicago Heights','Illinois','Adler & Sullivan',1893,'demolished',1961,1961,0,2,0,0.50,1,135,NULL,NULL,NULL,NULL),(296,'Virginia Hotel',600,'Rush','Chicago','Illinois','Warren',1890,'demolished',1929,1929,0,2,0,0.50,1,152,NULL,'Leander McCormick Apartments','McCormick, Leander, Apartments',NULL),(297,'Wainright',709,'Chestnut','St. Louis','USA','Adler & Sullivan',1891,'extant',NULL,NULL,2,0,0,2.00,1,127,NULL,NULL,NULL,NULL),(298,'Walker Warehouse',-210,'Wacker','Chicago','Illinois','Adler & Sullivan',1889,'demolished',1953,1953,0,1,0,0.25,1,41,NULL,NULL,NULL,NULL),(299,'Ward',14,'Michigan','Chicago','Illinois','Beers, Clay & Dutton',1885,'extant',NULL,NULL,0,0,1,0.05,0,111,NULL,NULL,NULL,'14 N. Michigan Avenue;Illinois State Medical Society'),(300,'Montgomery Ward (Chicago Avenue)',758,'Larrabee','Chicago','Illinois','Schmidt, Garden, & Martin',1929,'extant',NULL,NULL,0,0,2,0.10,0,192,'MontgomeryWardWarehouse-Office.jpg',NULL,'Ward, Montgomery, Chicago Avenue',NULL),(301,'Montgomery Ward (Michigan Avenue)',6,'Michigan','Chicago','Illinois','Schmidt',1899,'extant',NULL,NULL,0,0,4,0.20,0,186,'MontgomeryWard(Michigan).jpg','Tower','Ward, Montgomery, Michigan Avenue',NULL),(302,'Montgomery Ward warehouse',-618,'Chicago','Chicago','Illinois','Schmidt, Garden, & Martin',1908,'extant',NULL,NULL,0,2,0,0.50,2,192,'MontgomeryWardWarehouse-Office.jpg',NULL,'Ward, Montgomery, warehouse',NULL),(303,'Water Tower',806,'Michigan','Chicago','Illinois','Boyington',1869,'extant',NULL,NULL,0,0,2,0.10,0,134,NULL,NULL,NULL,NULL),(304,'Water Tower Inn',800,'Michigan','Chicago','Illinois','Hausner and Macsai',1961,'demolished',1997,1997,0,0,2,0.10,0,190,NULL,NULL,NULL,'Park Hyatt Hotel'),(305,'Williams',-205,'Monroe','Chicago','Illinois','Holabird & Roche ',1898,'extant',NULL,NULL,0,0,2,0.10,1,125,'WilliamsBldg.jpg',NULL,NULL,NULL),(306,'Willoughby',-234,'Franklin','Chicago','Illinois','Buffington',1887,'demolished',1964,1964,0,1,0,0.25,1,80,NULL,NULL,NULL,'234 S. Franklin Street'),(307,'Winton',-1255,'Michigan','Chicago','Illinois','Rogers',1904,'demolished',1999,2013,0,0,4,0.20,0,191,NULL,NULL,NULL,NULL),(308,'Witkower',621,'Davis','Evanston','Illinois','Edbrooke',1906,'demolished',1965,1969,0,0,2,0.10,0,186,NULL,NULL,NULL,NULL),(309,'Woman\'s Temple',-102,'La Salle','Chicago','Illinois','Burnham & Root',1892,'demolished',1926,1926,0,2,0,0.50,1,104,NULL,NULL,NULL,NULL),(310,'Woodbury County Courthouse',NULL,'','Sioux City','USA','Elmslie',1917,NULL,NULL,NULL,0,0,0,0.01,0,183,NULL,NULL,NULL,NULL),(311,'Woods Theater',-50,'Randolph','Chicago','Illinois','Marshall & Fox',1917,'demolished',1989,1989,0,0,0,0.01,0,38,NULL,NULL,NULL,NULL),(312,'Woolworth',NULL,'','New York','USA','Gilbert',1913,'extant',NULL,NULL,0,0,1,0.05,0,123,NULL,NULL,NULL,NULL),(313,'Yondorf',-225,'Wacker','Chicago','Illinois','Flanders & Zimmerman',1893,'demolished',1968,1968,0,1,0,0.25,1,147,NULL,'225 S. Wacker',NULL,'225-29 S. Market Street');
/*!40000 ALTER TABLE `viewBldg` ENABLE KEYS */;
UNLOCK TABLES;

--
-- Table structure for table `viewName`
--

DROP TABLE IF EXISTS `viewName`;
/*!40101 SET @saved_cs_client     = @@character_set_client */;
/*!40101 SET character_set_client = utf8 */;
CREATE TABLE `viewName` (
  `bldgID` int(11) NOT NULL DEFAULT '0',
  `acceptednameID` int(11) DEFAULT NULL,
  `validname` varchar(150) DEFAULT NULL,
  `allnames` varchar(150) DEFAULT NULL,
  `allnameID` int(11) NOT NULL DEFAULT '0',
  `source` varchar(25) DEFAULT NULL
) ENGINE=InnoDB DEFAULT CHARSET=latin1;
/*!40101 SET character_set_client = @saved_cs_client */;

--
-- Dumping data for table `viewName`
--

LOCK TABLES `viewName` WRITE;
/*!40000 ALTER TABLE `viewName` DISABLE KEYS */;
INSERT INTO `viewName` VALUES (1,23,'Alexandria Hotel','Alexandria Hotel',23,'Condit main'),(2,24,'Alumni Memorial Hall (IIT)','Alumni Memorial Hall (IIT)',24,'Condit main'),(3,25,'Ambassador Hotel','Ambassador Hotel',25,'Condit main'),(3,25,'Ambassador Hotel','Ambassador West',26,'Condit alternate'),(4,27,'American Express Company','American Express Company',27,'Condit main'),(5,28,'American National Bank','American National Bank',28,'Condit main'),(5,28,'American National Bank','Foreman National Bank',146,'Condit alternate'),(6,29,'American Tract Society','American Tract Society',29,'Condit main'),(7,30,'American Trust and Savings Bank','Fort Dearborn Bank',147,'Condit alternate'),(7,30,'American Trust and Savings Bank','American Trust and Savings Bank',30,'Condit main'),(8,31,'Anshe Ma\'ariv Synagogue','Anshe Ma\'ariv Synagogue',31,'Condit main'),(9,32,'Hinman and Lee Apartments','Hinman and Lee Apartments',32,'Condit main'),(9,32,'Hinman and Lee Apartments','apartments, Hinman Avenue and Lee Street, Evanston',394,'Condit original spelling'),(10,33,'Argyle Apartments','Argyle Apartments',33,'Condit main'),(11,34,'Art Institute','Art Institute',34,'Condit main'),(12,35,'Ashland','Ashland',35,'Condit main'),(13,37,'Auditorium','Auditorium',37,'Condit main'),(14,38,'Austin','Phoenix',293,'Condit alternate'),(14,38,'Austin','Western Union',384,'Condit alternate'),(14,38,'Austin','Austin',38,'Condit main'),(15,39,'Babson Farm','Babson Farm',39,'Condit main'),(16,40,'Babson House','Babson House',40,'Condit main'),(17,41,'Bailey','Bailey',41,'Condit main'),(18,42,'Cornelius Baker Company factory','Baker Factory, Cornelius',395,'Condit original spelling'),(18,42,'Cornelius Baker Company factory','Cornelius Baker Company factory',42,'Condit main'),(19,43,'Bauer and Black','Bauer and Black',43,'Condit main'),(20,44,'Bayard','Condict',99,'Condit alternate'),(20,44,'Bayard','Bayard',44,'Condit main'),(21,45,'Berbach House','Berbach House',45,'Condit main'),(22,46,'Bibliotheque National','Bibliotheque National',46,'Condit main'),(23,47,'Board of Trade 1','Board of Trade 1',47,'Condit main'),(24,48,'Board of Trade 2','Board of Trade 2',48,'Condit main'),(25,49,'Boat Store, Sheerness','Boat Store, Sheerness',49,'Condit main'),(26,50,'Bordeaux Apartments','Grant Park Arms Apartments',430,'Randall'),(26,50,'Bordeaux Apartments','Bordeaux Apartments',50,'Condit main'),(27,51,'Borden Block','Borden Block',51,'Condit main'),(28,52,'Borg-Warner','Borg-Warner',52,'Condit main'),(29,53,'Born','Born',53,'Condit main'),(30,54,'Boston Store','State-Madison',342,'Condit alternate'),(30,54,'Boston Store','Boston Store',54,'Condit main'),(31,55,'Bradley House','Bradley House',55,'Condit main'),(32,56,'Brewster Apartments','Brewster Apartments',56,'Condit main'),(33,57,'Brooks','Brooks',57,'Condit main'),(34,59,'Brunswick and Balke Factory','Brunswick and Balke Factory',59,'Condit main'),(35,60,'Bunte Brothers Candy Company','Bunte Brothers Candy Company',60,'Condit main'),(36,61,'Cable','Cable',61,'Condit main'),(36,61,'Cable','Hoops',175,'Condit alternate'),(37,62,'Calico Mill','Calico Mill',62,'Condit main'),(38,63,'Calumet','Calumet',63,'Condit main'),(39,67,'Carson Pirie Scott Store','Schlesinger and Mayer Store',323,'Condit alternate'),(39,67,'Carson Pirie Scott Store','Carson Pirie Scott Store',67,'Condit main'),(40,65,'Carson Pirie Scott Annex','Carson Pirie Scott Men\'s Store',66,'Condit alternate'),(40,65,'Carson Pirie Scott Annex','Carson Pirie Scott Annex',65,'Condit main'),(41,68,'Carson Pirie Scott Wholesale Store','Carson Pirie Scott Wholesale Store',68,'Condit main'),(42,69,'Carter House','Carter House',69,'Condit main'),(43,70,'Caxton','Caxton',70,'Condit main'),(44,71,'Central Music Hall','Central Music Hall',71,'Condit main'),(45,72,'Central YMCA','Central YMCA',72,'Condit main'),(45,72,'Central YMCA','Association',36,'Condit alternate'),(46,73,'Century','Century',73,'Condit main'),(47,74,'Chamber of Commerce','Chamber of Commerce',74,'Condit main'),(48,75,'Champlain, first','Champlain, first',75,'Condit main'),(49,76,'Champlain, second','Powers',301,'Condit alternate'),(49,76,'Champlain, second','Champlain, second',76,'Condit main'),(50,77,'Chapin and Gore','Chapin and Gore',77,'Condit main'),(50,77,'Chapin and Gore','Union Life',364,'Condit alternate'),(50,77,'Chapin and Gore','Nepeenauk',274,'Condit alternate'),(51,78,'Chemical Works','Chemical Works',78,'Condit main'),(52,79,'Chestnut Street Theater','Chestnut Street Theater',79,'Condit main'),(53,81,'Chicago Building','Chicago Building',81,'Condit main'),(53,81,'Chicago Building','Chicago Saving Bank',90,'Condit alternate'),(54,80,'Chicago Beach Hotel','Chicago Beach Hotel',80,'Condit main'),(55,82,'Chicago Business College','Adams and Wabash',22,'Condit alternate'),(55,82,'Chicago Business College','Chicago Business College',82,'Condit main'),(56,83,'Chicago Club','Chicago Club',83,'Condit main'),(57,84,'Chicago Cold Storage Exchange','Chicago Cold Storage Exchange',84,'Condit main'),(58,85,'Chicago Garment Center','Hirsch-Wickwire',171,'Randall'),(58,85,'Chicago Garment Center','Chicago Garment Center',85,'Condit main'),(59,86,'Chicago Herald','Chicago Herald',86,'Condit main'),(60,89,'Chicago Opera House','Chicago Opera House',89,'Condit main'),(61,93,'Thomas Church Building','Thomas Church Building',93,'Condit main'),(61,93,'Thomas Church Building','Church, Thomas Building',396,'Condit original spelling'),(62,94,'Civic Center','Civic Center',94,'Condit main'),(63,95,'Civic Opera','Civic Opera',95,'Condit main'),(64,96,'Grover Cleveland Elementary School','Cleveland, Grover Elementary School',397,'Condit original spelling'),(64,96,'Grover Cleveland Elementary School','Grover Cleveland Elementary School',96,'Condit main'),(65,98,'Comstock Houses','Comstock Houses',98,'Condit main'),(66,100,'First Congregational Church of Austin','First Congregational Church of Austin',100,'Condit main'),(66,100,'First Congregational Church of Austin','West Central Church',383,'Condit alternate'),(66,100,'First Congregational Church of Austin','Congregational, First Church of Austin',398,'Condit original spelling'),(67,101,'Congress Hotel','Congress Hotel',101,'Condit main'),(68,103,'Continental Center','Continental Center',103,'Condit main'),(68,103,'Continental Center','CNA Plaza',97,'Randall'),(69,106,'Coonley house','Coonley house',106,'Condit main'),(70,105,'Avery Coonley Kindergarten','Avery Coonley Kindergarten',105,'Condit main'),(70,105,'Avery Coonley Kindergarten','Coonley, Avery, Kindergarten',399,'Condit original spelling'),(71,107,'Cooper Union','Cooper Union',107,'Condit main'),(72,108,'Counselman','Counselman',108,'Condit main'),(73,109,'Crane, first','Crane, first',109,'Condit main'),(74,110,'Crane, second','Crane, second',110,'Condit main'),(75,111,'Crerar Library','Crerar Library',111,'Condit main'),(76,113,'Crown Hall','Crown Hall',113,'Condit main'),(77,114,'Crystal Palace, London','Crystal Palace, London',114,'Condit main'),(78,115,'Crystal Palace, New York','Crystal Palace, New York',115,'Condit main'),(79,116,'Chicago Daily News','2 N. Riverside Plaza',11,'Randall'),(79,116,'Chicago Daily News','Daily News, Chicago',400,'Condit original spelling'),(79,116,'Chicago Daily News','Chicago Daily News',116,'Condit main'),(80,117,'Daily News, New York','Daily News, New York',117,'Condit main'),(81,120,'Dexter','Dexter',120,'Condit main'),(82,121,'Wirt Dexter','Wirt Dexter',121,'Condit main'),(82,121,'Wirt Dexter','Dexter, Wirt',401,'Condit original spelling'),(83,123,'Arthur Dixon','Arthur Dixon',123,'Condit main'),(83,123,'Arthur Dixon','Dixon, Arthur',402,'Condit original spelling'),(84,124,'Dwight','Dwight',124,'Condit main'),(85,125,'Edison','229 South Wabash',8,'Condit alternate'),(85,125,'Edison','Edison',125,'Condit main'),(85,125,'Edison','Edison Phonograph Shop',126,'Randall'),(86,127,'Eiffel Tower','Eiffel Tower',127,'Condit main'),(87,20,'860-880 North Lake Shore Drive','860-880 North Lake Shore Drive',20,'Condit main'),(88,129,'Esquire Theater','Esquire Theater',129,'Condit main'),(89,130,'E-Z Polish Company Factory','E-Z Polish Company Factory',130,'Condit main'),(90,131,'Fair Store','Fair Store',131,'Condit main'),(91,132,'Charles B. Farwell Store','Charles B. Farwell Store',132,'Condit main'),(91,132,'Charles B. Farwell Store','Farwell, Charles B., Store',403,'Condit original spelling'),(92,133,'J.V. Farwell warehouse','J.V. Farwell warehouse',133,'Condit main'),(92,133,'J.V. Farwell warehouse','Farwell, J.V., warehouse',404,'Condit original spelling'),(93,134,'Federal Office','Dirksen Federal',122,'Emporis'),(93,134,'Federal Office','Federal Office',134,'Condit main'),(94,135,'Felsenthal Store','Felsenthal Store',135,'Condit main'),(95,136,'Field','LaSalle Bank',214,'Randall'),(95,136,'Field','Field',136,'Condit main'),(96,139,'Marshall Field Store','Field, Marshall, Store',405,'Condit original spelling'),(96,139,'Marshall Field Store','Marshall Field Store',139,'Condit main'),(97,140,'Marshall Field Wholesale Store','Field, Marshall, Wholesale Store',406,'Condit original spelling'),(97,140,'Marshall Field Wholesale Store','Marshall Field Wholesale Store',140,'Condit main'),(98,137,'Field and Leiter Store','Field and Leiter Store',137,'Condit main'),(99,138,'Field and Leiter Wholesale Store','Field and Leiter Wholesale Store',138,'Condit main'),(100,16,'5730 Sheridan Road house','5730 Sheridan Road house',16,'Condit main'),(101,142,'World\'s Columbian Exposition Fine Arts Building','World\'s Columbian Exposition Fine Arts Building',142,'Condit main'),(101,142,'World\'s Columbian Exposition Fine Arts Building','Fine Arts, World\'s Columbian Exposition',407,'Condit original spelling'),(101,142,'World\'s Columbian Exposition Fine Arts Building','Museum of Science and Industry',273,'Condit alternate'),(102,143,'First National Bank','First National Bank',143,'Condit main'),(103,144,'Fisher','Fisher',144,'Condit main'),(104,145,'Flatiron','Flatiron',145,'Condit main'),(105,148,'Francis Apartments','Francis Apartments',148,'Condit main'),(106,149,'Frankenthal','Frankenthal',149,'Condit main'),(107,150,'Gage Group North','Gage Group North',150,'Condit main'),(108,151,'Gage Group South 1','Gage Group South 1',151,'Condit main'),(109,152,'Gage Group South 2','Gage Group South 2',152,'Condit main'),(110,153,'Monroe Street garage','garage, Monroe Street',408,'Condit original spelling'),(110,153,'Monroe Street garage','Monroe Street garage',153,'Condit main'),(111,154,'Garden City Plating and Manufacturing Company factory','Garden City Plating and Manufacturing Company factory',154,'Condit main'),(112,155,'Garden City Warehouse','Garden City Warehouse',155,'Condit main'),(113,156,'Garrick Theater','Garrick Theater',156,'Condit main'),(113,156,'Garrick Theater','Schiller',322,'Condit alternate'),(114,157,'Geneva Apartments','Geneva Apartments',157,'Condit main'),(115,158,'Glessner House','Glessner House',158,'Condit main'),(116,160,'Great Lakes','Great Lakes',160,'Condit main'),(116,160,'Great Lakes','180 N. Wacker Drive',4,'Randall'),(117,161,'Great Northern Hotel','Great Northern Hotel',161,'Condit main'),(118,162,'Great Northern Theater','Great Northern Theater',162,'Condit main'),(119,163,'Grommes and Ulrich Company Warehouse','Grommes and Ulrich Company Warehouse',163,'Condit main'),(119,163,'Grommes and Ulrich Company Warehouse','W.H. Long Company',428,'Condit alternate'),(119,163,'Grommes and Ulrich Company Warehouse','Long, W.H., Company',228,'Condit original spelling'),(120,164,'Guaranty','Prudential (Buffalo)',304,'Condit alternate'),(120,164,'Guaranty','Guaranty',164,'Condit main'),(121,165,'Hammond Library','Union Theological College',365,'Condit alternate'),(121,165,'Hammond Library','Hammond Library',165,'Condit main'),(122,166,'Harper and Brothers','Harper and Brothers',166,'Condit main'),(123,167,'Hartford Fire Insurance','Hartford Fire Insurance',167,'Condit main'),(124,168,'Healy Chapel','Healy Chapel',168,'Condit main'),(125,169,'Henrotin Hospital','Henrotin Hospital',169,'Condit main'),(126,170,'Heyworth','Heyworth',170,'Condit main'),(127,172,'Hollywood Towers','Hollywood Towers',172,'Condit main'),(128,174,'Home Insurance','Home Insurance',174,'Condit main'),(129,176,'Horstman. William H. and Sons factory','Horstman. William H. and Sons factory',176,'Condit main'),(130,177,'World Columbian Exposition Horticultural Building','Horticultural, World Columbian Exposition',409,'Condit original spelling'),(130,177,'World Columbian Exposition Horticultural Building','World Columbian Exposition Horticultural Building',177,'Condit main'),(131,178,'Horton house','Horton house',178,'Condit main'),(132,179,'Charles Hull house','Hull, Charles, house',410,'Condit original spelling'),(132,179,'Charles Hull house','Charles Hull house',179,'Condit main'),(133,180,'Hull House group','Hull House group',180,'Condit main'),(134,181,'Humboldt Park boathouse','Humboldt Park boathouse',181,'Condit main'),(135,182,'Hungerford Fish Market','Hungerford Fish Market',182,'Condit main'),(136,183,'Hunter','Hunter',183,'Condit main'),(136,183,'Hunter','Liberty Mutual',221,'Condit alternate'),(136,183,'Hunter','Liberty Mutual Insurance',222,'Condit alternate'),(137,184,'Hyde Park Hotel','Hyde Park Hotel',184,'Condit main'),(138,185,'Illinois Bank','Illinois Bank',185,'Condit main'),(139,188,'Immaculata High School','Immaculata High School',188,'Condit main'),(140,189,'Imperial Hotel','Imperial Hotel',189,'Condit main'),(141,190,'Inland Steel','Inland Steel',190,'Condit main'),(142,191,'Insurance Exchange','Insurance Exchange',191,'Condit main'),(142,191,'Insurance Exchange','Continental Bank',102,'Condit alternate'),(143,192,'International Leather and Belting Company factory','International Leather and Belting Company factory',192,'Condit main'),(144,193,'Isabella','Isabella',193,'Condit main'),(145,194,'Jayne','Jayne',194,'Condit main'),(146,195,'Jeweler\'s','Jeweler\'s',195,'Condit main'),(147,196,'S.C. Johnson Company research tower','S.C. Johnson Company research tower',196,'Condit main'),(147,196,'S.C. Johnson Company research tower','Johnson, S.C., and Company research tower',411,'Condit original spelling'),(148,198,'Kelley, Maus and Company warehouse','Graham Paper Company',159,'Condit alternate'),(148,198,'Kelley, Maus and Company warehouse','Kelley, Maus and Company warehouse',198,'Condit main'),(149,199,'Kendall','Kendall',199,'Condit main'),(149,199,'Kendall','Equitable',128,'Condit alternate'),(149,199,'Kendall','Real Estate Exchange',309,'Condit alternate'),(150,200,'Kenilworth Club','Kenilworth Club',200,'Condit main'),(151,201,'Kennedy Bakery','Pettibone Printing Company',291,'Condit alternate'),(151,201,'Kennedy Bakery','Kennedy Bakery',201,'Condit main'),(152,202,'Kent','Kent',202,'Condit main'),(152,202,'Kent','Kuppenheimer',205,'Condit alternate'),(153,203,'Knisely','Knisely',203,'Condit main'),(154,204,'Krause Music Store','Krause Music Store',204,'Condit main'),(155,212,'Union Tank Car','Transunion',359,'Emporis'),(155,212,'Union Tank Car','Union Tank Car',212,'Condit main'),(156,213,'La Salle-Monroe','La Salle-Monroe',213,'Condit main'),(157,206,'Lafayette Apartments','Lafayette Apartments',206,'Condit main'),(158,207,'Lake Shore Club','Lake Shore Club',207,'Condit main'),(159,208,'Lakeside','Lakeside',208,'Condit main'),(160,209,'Lakota Hotel','Lakota Hotel',209,'Condit main'),(160,209,'Lakota Hotel','Lewis Memorial Hospital',219,'Other'),(161,210,'Langdon Apartments','Langdon Apartments',210,'Condit main'),(162,211,'Larkin','Larkin',211,'Condit main'),(163,215,'Leiter, first','Morris',267,'Condit alternate'),(163,215,'Leiter, first','Leiter, first',215,'Condit main'),(164,216,'Leiter, second','Siegel, Cooper and Company',336,'Condit alternate'),(164,216,'Leiter, second','Sears Roebuck Store',329,'Condit alternate'),(164,216,'Leiter, second','Leiter, second',216,'Condit main'),(165,217,'Leland','Leland',217,'Condit main'),(166,218,'Lemoyne','Lemoyne',218,'Condit main'),(167,223,'Abraham Lincoln Center','Lincoln, Abraham, Center',412,'Condit original spelling'),(167,223,'Abraham Lincoln Center','Abraham Lincoln Center',223,'Condit main'),(168,224,'Lincoln Park Zoo Pavilions','Lincoln Park Zoo Pavilions',224,'Condit main'),(169,225,'Lind','Lind',225,'Condit main'),(170,226,'Linthicum house','Linthicum house',226,'Condit main'),(171,227,'Lloyd','Lloyd',227,'Condit main'),(172,229,'Lord\'s Store','Lord\'s Store',229,'Condit main'),(172,229,'Lord\'s Store','625 Davis Street',18,'Condit alternate'),(173,230,'Lorimer Baptist Church','Lorimer Baptist Church',230,'Condit main'),(174,231,'Ludington','Ludington',231,'Condit main'),(175,239,'McClurg','Crown',112,'Condit alternate'),(175,239,'McClurg','McClurg',239,'Condit main'),(176,241,'McCormick Place','McCormick Place',241,'Condit main'),(176,241,'McCormick Place','Metropolitan Fair and Exposition',251,'Condit alternate'),(177,242,'McCullough Shot and Lead Co. Tower','McCullough Shot and Lead Co. Tower',242,'Condit main'),(178,243,'McGraw Hill','McGraw Hill',243,'Condit main'),(179,244,'McVickers Theater','McVickers Theater',244,'Condit main'),(180,232,'Maison Clarté, Geneva','Maison Clarté, Geneva',232,'Condit main'),(181,233,'Majestic Hotel','Majestic Hotel',233,'Condit main'),(182,234,'Mandel Store Annex','Mandel Store Annex',234,'Condit main'),(183,235,'Manhattan','Manhattan',235,'Condit main'),(184,236,'Marina City','Marina City',236,'Condit main'),(185,237,'Marquette','Marquette',237,'Condit main'),(186,238,'Masonic Temple','Masonic Temple',238,'Condit main'),(186,238,'Masonic Temple','Capitol',64,'Condit alternate'),(187,245,'Mecca Apartments','Mecca Apartments',245,'Condit main'),(188,246,'Medinah','Medinah',246,'Condit main'),(189,248,'Menier Chocolate Works','Menier Chocolate Works',248,'Condit main'),(190,249,'Methodist Episcopal Church of Maywood','Methodist Episcopal Church of Maywood',249,'Condit main'),(190,249,'Methodist Episcopal Church of Maywood','Christ Temple Church of the Apostolic Faith',92,'Condit alternate'),(191,250,'Metropole Hotel','Metropole Hotel',250,'Condit main'),(192,252,'Meyer','Meyer',252,'Condit main'),(193,253,'New Michigan Hotel','Lexington Hotel',220,'Condit alternate'),(193,253,'New Michigan Hotel','Michigan, New, Hotel',413,'Condit original spelling'),(193,253,'New Michigan Hotel','New Michigan Hotel',253,'Condit main'),(194,254,'Michigan Terrace Apts','Michigan Terrace Apts',254,'Condit main'),(195,255,'Midway Gardens','Midway Gardens',255,'Condit main'),(196,256,'Mills','Mills',256,'Condit main'),(197,258,'Monadnock','Monadnock',258,'Condit main'),(197,258,'Monadnock','Monadnock and Kearsage',260,'Condit alternate'),(198,259,'Monadnock addition','Katahdin',197,'Condit alternate'),(198,259,'Monadnock addition','Monadnock addition',259,'Condit main'),(199,262,'Montauk','Montauk',262,'Condit main'),(200,263,'Monticello','Monticello',263,'Condit main'),(201,264,'Moody\'s Tabernacle','Moody\'s Tabernacle',264,'Condit main'),(202,265,'Mormon Tabernacle','Mormon Tabernacle',265,'Condit main'),(203,268,'Morton','Morton',268,'Condit main'),(204,269,'Morton Apartments','Morton Apartments',269,'Condit main'),(205,270,'Moses','Moses',270,'Condit main'),(206,271,'Mount Vernon','Mount Vernon',271,'Condit main'),(207,272,'Museum of Natural History','Field Museum',141,'Condit alternate'),(207,272,'Museum of Natural History','Museum of Natural History',272,'Condit main'),(208,275,'Newberry Library','Newberry Library',275,'Condit main'),(209,21,'900 N Michigan Ave','900 N Michigan Ave',21,'Condit main'),(210,276,'Nixon','Nixon',276,'Condit main'),(211,277,'Northwestern Technological Institute','Northwestern Technological Institute',277,'Condit main'),(212,278,'Old Colony','Old Colony',278,'Condit main'),(213,279,'Omaha Apartments','Omaha Apartments',279,'Condit main'),(214,5,'1 North La Salle','1 North La Salle',5,'Condit main'),(215,2,'120 South La Salle','120 South La Salle',2,'Condit main'),(215,2,'120 South La Salle','State Bank',341,'Randall'),(216,281,'Palmer House','Palmer House',281,'Condit main'),(216,281,'Palmer House','Palmer House 3',282,'Randall'),(217,283,'Palmolive','Palmolive',283,'Condit main'),(218,285,'Park Gate Hotel','Park Gate Hotel',285,'Condit main'),(219,284,'Parker Apartments','Parker Apartments',284,'Condit main'),(220,287,'Parthenon','Parthenon',287,'Condit main'),(221,288,'Patten Gymnasium','Patten Gymnasium',288,'Condit main'),(222,289,'Patten House','Patten House',289,'Condit main'),(223,290,'Pennsylvania Railroad grain elevator','Pennsylvania Railroad grain elevator',290,'Condit main'),(224,292,'Phelps, Dodge and Palmer','Phelps, Dodge and Palmer',292,'Condit main'),(225,294,'Pickwick Apartments','Pickwick Apartments',294,'Condit main'),(226,295,'Stanley R. Pierce Hall','Pierce, Stanley R., Hall',414,'Condit original spelling'),(226,295,'Stanley R. Pierce Hall','Stanley R. Pierce Hall',295,'Condit main'),(227,296,'Plaza Hotel','Plaza Hotel',296,'Condit main'),(228,298,'Pontiac','Pontiac',298,'Condit main'),(229,299,'Portland','Portland',299,'Condit main'),(230,300,'Post Office and Customs House','Post Office and Customs House',300,'Condit main'),(231,302,'Promontory Apartments','Promontory Apartments',302,'Condit main'),(232,303,'Prudential','Prudential',303,'Condit main'),(232,303,'Prudential','One Prudential Plaza',280,'Randall'),(233,305,'Public Library','Public Library',305,'Condit main'),(234,306,'Pullman','Pullman',306,'Condit main'),(235,307,'Railway Exchange','Railway Exchange',307,'Condit main'),(235,307,'Railway Exchange','Santa Fe Center',321,'Randall'),(236,308,'Rand McNally','Rand McNally',308,'Condit main'),(237,310,'Michael Reese Hospital','Reese, Michael, Hospital',415,'Condit original spelling'),(237,310,'Michael Reese Hospital','Michael Reese Hospital',310,'Condit main'),(238,312,'Reid, Murdoch and Company','Monarch Foods Company',261,'Condit alternate'),(238,312,'Reid, Murdoch and Company','Reid, Murdoch and Company',312,'Condit main'),(239,311,'Reid house','Reid house',311,'Condit main'),(240,313,'Reliance','Reliance',313,'Condit main'),(241,314,'Republic','Home Federal Savings and Loan',173,'Condit alternate'),(241,314,'Republic','Republic',314,'Condit main'),(242,315,'Revell','Revell',315,'Condit main'),(243,316,'Robie house','Robie house',316,'Condit main'),(244,317,'Rookery','Rookery',317,'Condit main'),(245,318,'Rosenfeld','Rosenfeld',318,'Condit main'),(246,319,'Rothschild Store','Rothschild Store',319,'Condit main'),(246,319,'Rothschild Store','Milton F. Goodman',257,'Randall'),(247,320,'Ryerson','Ryerson',320,'Condit main'),(248,339,'St. Anne\'s Church, Liverpool','St. Anne\'s Church, Liverpool',339,'Condit main'),(249,340,'St. Anne\'s Hospital','St. Anne\'s Hospital',340,'Condit main'),(250,344,'St. Mary\'s Church (1833)','St. Mary\'s Church (1833)',344,'Condit main'),(251,345,'St. Mary\'s Church (1868)','St. Mary\'s Church (1868)',345,'Condit main'),(251,345,'St. Mary\'s Church (1868)','Plymouth Congregational Church',297,'Condit alternate'),(252,346,'St. Mary\'s High School','St. Mary\'s High School',346,'Condit main'),(253,348,'St. Ouen docks warehouse, Paris','St. Ouen docks warehouse, Paris',348,'Condit main'),(254,349,'Church of St. Thomas the Apostle','Church of St. Thomas the Apostle',349,'Condit main'),(254,349,'Church of St. Thomas the Apostle','St. Thomas the Apostle, Church of',420,'Condit original spelling'),(255,324,'Schoenhofen Brewery powerhouse','Morningstar-Paisley Company',266,'Condit alternate'),(255,324,'Schoenhofen Brewery powerhouse','Schoenhofen Brewery powerhouse',324,'Condit main'),(256,325,'Carl Schurz High School','Schurz, Carl High School',416,'Condit original spelling'),(256,325,'Carl Schurz High School','Carl Schurz High School',325,'Condit main'),(257,326,'Scoville','Scoville',326,'Condit main'),(258,327,'Joseph Sears Elementary School','Sears, Joseph, Elementary School',417,'Condit original spelling'),(258,327,'Joseph Sears Elementary School','Joseph Sears Elementary School',327,'Condit main'),(259,328,'Sears Roebuck merchandise plant','Sears Roebuck merchandise plant',328,'Condit main'),(260,330,'Second City night club','Second City night club',330,'Condit main'),(261,331,'Selz, Schwab and Company factory','Selz, Schwab and Company factory',331,'Condit main'),(262,19,'7415 Sheridan Road','7415 Sheridan Road',19,'Condit main'),(263,332,'Sheraton Hotel','Continental Hotel',104,'Randall'),(263,332,'Sheraton Hotel','Medinah Club',247,'Randall'),(263,332,'Sheraton Hotel','Sheraton Hotel',332,'Condit main'),(263,332,'Sheraton Hotel','Chicago Towers',91,'Randall'),(264,333,'Sheridan House','Sheridan House',333,'Condit main'),(265,334,'John Shillito Store','John Shillito Store',334,'Condit main'),(265,334,'John Shillito Store','Shillito, John, Store',418,'Condit original spelling'),(266,335,'Hiram Sibley and Company Warehouse','Hiram Sibley and Company Warehouse',335,'Condit main'),(266,335,'Hiram Sibley and Company Warehouse','Sibley, Hiram, and Company Warehouse',419,'Condit original spelling'),(267,17,'608 Davis Street','608 Davis Street',17,'Condit main'),(268,337,'Society Brand','Society Brand',337,'Condit main'),(268,337,'Society Brand','Alfred Decker and Cohn',427,'Condit alternate'),(268,337,'Society Brand','Decker, Alfred and Cohn',119,'Condit original spelling'),(269,338,'Standard Club','Standard Club',338,'Condit main'),(270,343,'Steinway Hall','Steinway Hall',343,'Condit main'),(271,347,'Stock Exchange','30 N. LaSalle Street',12,'Randall'),(271,347,'Stock Exchange','Stock Exchange',347,'Condit main'),(272,350,'Studebaker','Brunswick',58,'Condit alternate'),(272,350,'Studebaker','Studebaker',350,'Condit main'),(273,351,'Student Union, Purdue University','Student Union, Purdue University',351,'Condit main'),(274,352,'Student Union, University of Michigan','Student Union, University of Michigan',352,'Condit main'),(275,354,'Swift Hall','Swift Hall',354,'Condit main'),(276,355,'Tacoma','Tacoma',355,'Condit main'),(277,1,'1014 Davis Street','1014 Davis Street',1,'Condit main'),(278,14,'320 South Franklin Street','320 South Franklin Street',14,'Condit main'),(279,15,'325 West Jackson Boulevard','325 West Jackson Boulevard',15,'Condit main'),(280,13,'3200 South Prarie Avenue (apartments)','3200 South Prarie Avenue (apartments)',13,'Condit main'),(281,356,'Illinois Bell Telephone Company Toll Building','Illinois Bell Telephone Company Toll Building',356,'Condit main'),(281,356,'Illinois Bell Telephone Company Toll Building','Illinois Bell',186,'Randall'),(281,356,'Illinois Bell Telephone Company Toll Building','Toll, Illinois Bell Telephone Company',421,'Condit original spelling'),(282,358,'World\'s Columbian Exposition Transportation Building','Transportation, World\'s Columbian Exposition',422,'Condit original spelling'),(282,358,'World\'s Columbian Exposition Transportation Building','World\'s Columbian Exposition Transportation Building',358,'Condit main'),(283,360,'Tribune','Tribune',360,'Condit main'),(284,361,'Troescher','Daily Times',118,'Randall'),(284,361,'Troescher','Chicago Joint Board',87,'Condit alternate'),(284,361,'Troescher','Troescher',361,'Condit main'),(284,361,'Troescher','Chicago Journal',88,'Condit alternate'),(284,361,'Troescher','Sullivan',353,'Condit alternate'),(285,362,'Lyman Trumball Elementary School','Trumball, Lyman Elementary School',423,'Condit original spelling'),(285,362,'Lyman Trumball Elementary School','Lyman Trumball Elementary School',362,'Condit main'),(286,10,'241 Chestnut Street, Philadelphia','241 Chestnut Street, Philadelphia',10,'Condit main'),(287,363,'Union Bus Terminal','Union Bus Terminal',363,'Condit main'),(288,366,'Unitarian Church of Evanston','Unitarian Church of Evanston',366,'Condit main'),(289,367,'United States Warehousing Company grain elevator','United States Warehousing Company grain elevator',367,'Condit main'),(290,368,'Unity','Unity',368,'Condit main'),(291,369,'Unity Church','Unity Church',369,'Condit main'),(292,370,'University','University',370,'Condit main'),(293,371,'University Apartments','University Apartments',371,'Condit main'),(294,372,'Van Nelle Tobacco Company factory','Van Nelle Tobacco Company factory',372,'Condit main'),(295,373,'Victoria Hotel','Victoria Hotel',373,'Condit main'),(296,374,'Virginia Hotel','McCormick, Leander, Apartments',240,'Condit original spelling'),(296,374,'Virginia Hotel','Leander McCormick Apartments',429,'Condit alternate'),(296,374,'Virginia Hotel','Virginia Hotel',374,'Condit main'),(297,375,'Wainright','Wainright',375,'Condit main'),(298,376,'Walker Warehouse','Walker Warehouse',376,'Condit main'),(299,377,'Ward','Ward',377,'Condit main'),(299,377,'Ward','14 N. Michigan Avenue',3,'Randall'),(299,377,'Ward','Illinois State Medical Society',187,'Randall'),(300,378,'Montgomery Ward (Chicago Avenue)','Montgomery Ward (Chicago Avenue)',378,'Condit main'),(300,378,'Montgomery Ward (Chicago Avenue)','Ward, Montgomery, Chicago Avenue',424,'Condit original spelling'),(301,379,'Montgomery Ward (Michigan Avenue)','Tower',357,'Condit alternate'),(301,379,'Montgomery Ward (Michigan Avenue)','Montgomery Ward (Michigan Avenue)',379,'Condit main'),(301,379,'Montgomery Ward (Michigan Avenue)','Ward, Montgomery, Michigan Avenue',425,'Condit original spelling'),(302,380,'Montgomery Ward warehouse','Montgomery Ward warehouse',380,'Condit main'),(302,380,'Montgomery Ward warehouse','Ward, Montgomery, warehouse',426,'Condit original spelling'),(303,381,'Water Tower','Water Tower',381,'Condit main'),(304,382,'Water Tower Inn','Park Hyatt Hotel',286,'Randall'),(304,382,'Water Tower Inn','Water Tower Inn',382,'Condit main'),(305,385,'Williams','Williams',385,'Condit main'),(306,386,'Willoughby','Willoughby',386,'Condit main'),(306,386,'Willoughby','234 S. Franklin Street',9,'Randall'),(307,387,'Winton','Winton',387,'Condit main'),(308,388,'Witkower','Witkower',388,'Condit main'),(309,389,'Woman\'s Temple','Woman\'s Temple',389,'Condit main'),(310,390,'Woodbury County Courthouse','Woodbury County Courthouse',390,'Condit main'),(311,391,'Woods Theater','Woods Theater',391,'Condit main'),(312,392,'Woolworth','Woolworth',392,'Condit main'),(313,393,'Yondorf','225 S. Wacker',7,'Condit alternate'),(313,393,'Yondorf','225-29 S. Market Street',6,'Randall'),(313,393,'Yondorf','Yondorf',393,'Condit main');
/*!40000 ALTER TABLE `viewName` ENABLE KEYS */;
UNLOCK TABLES;
/*!40103 SET TIME_ZONE=@OLD_TIME_ZONE */;

/*!40101 SET SQL_MODE=@OLD_SQL_MODE */;
/*!40014 SET FOREIGN_KEY_CHECKS=@OLD_FOREIGN_KEY_CHECKS */;
/*!40014 SET UNIQUE_CHECKS=@OLD_UNIQUE_CHECKS */;
/*!40101 SET CHARACTER_SET_CLIENT=@OLD_CHARACTER_SET_CLIENT */;
/*!40101 SET CHARACTER_SET_RESULTS=@OLD_CHARACTER_SET_RESULTS */;
/*!40101 SET COLLATION_CONNECTION=@OLD_COLLATION_CONNECTION */;
/*!40111 SET SQL_NOTES=@OLD_SQL_NOTES */;

-- Dump completed on 2014-09-29 23:15:47
