PRAGMA foreign_keys=OFF;
BEGIN TRANSACTION;
CREATE TABLE cities(
  "name" TEXT,
  "population" TEXT
);
INSERT INTO "cities" VALUES('Abilene','115930');
INSERT INTO "cities" VALUES('Akron','217074');
INSERT INTO "cities" VALUES('Albany','93994');
INSERT INTO "cities" VALUES('Albuquerque','448607');
INSERT INTO "cities" VALUES('Alexandria','128283');
INSERT INTO "cities" VALUES('Allentown','106632');
INSERT INTO "cities" VALUES('Amarillo','173627');
INSERT INTO "cities" VALUES('Anaheim','328014');
INSERT INTO "cities" VALUES('Anchorage','260283');
INSERT INTO "cities" VALUES('Ann Arbor','114024');
INSERT INTO "cities" VALUES('Arden-Arcade','92040');
INSERT INTO "cities" VALUES('Arlington','332969');
INSERT INTO "cities" VALUES('Arlington','174838');
INSERT INTO "cities" VALUES('Arvada','102153');
INSERT INTO "cities" VALUES('Athens-Clarke County','101489');
INSERT INTO "cities" VALUES('Atlanta','416474');
INSERT INTO "cities" VALUES('Augusta-Richmond County','199775');
INSERT INTO "cities" VALUES('Aurora','276393');
INSERT INTO "cities" VALUES('Aurora','142990');
INSERT INTO "cities" VALUES('Austin','656562');
INSERT INTO "cities" VALUES('Bakersfield','247057');
INSERT INTO "cities" VALUES('Baltimore','651154');
INSERT INTO "cities" VALUES('Baton Rouge','227818');
INSERT INTO "cities" VALUES('Beaumont','113866');
INSERT INTO "cities" VALUES('Bellevue','109569');
INSERT INTO "cities" VALUES('Berkeley','102743');
INSERT INTO "cities" VALUES('Billings','92988');
INSERT INTO "cities" VALUES('Birmingham','242820');
INSERT INTO "cities" VALUES('Boise City','185787');
INSERT INTO "cities" VALUES('Boston','589141');
INSERT INTO "cities" VALUES('Boulder','91238');
INSERT INTO "cities" VALUES('Bridgeport','139529');
INSERT INTO "cities" VALUES('Brockton','93653');
INSERT INTO "cities" VALUES('Brownsville','139722');
INSERT INTO "cities" VALUES('Buffalo','292648');
INSERT INTO "cities" VALUES('Burbank','100316');
INSERT INTO "cities" VALUES('Cambridge','101355');
INSERT INTO "cities" VALUES('Cape Coral','102286');
INSERT INTO "cities" VALUES('Carrollton','109576');
INSERT INTO "cities" VALUES('Carson','89089');
INSERT INTO "cities" VALUES('Cary','91213');
INSERT INTO "cities" VALUES('Cedar Rapids','120758');
INSERT INTO "cities" VALUES('Chandler','176581');
INSERT INTO "cities" VALUES('Charleston','89063');
INSERT INTO "cities" VALUES('Charlotte','540828');
INSERT INTO "cities" VALUES('Chattanooga','155554');
INSERT INTO "cities" VALUES('Chesapeake','199184');
INSERT INTO "cities" VALUES('Chicago','2896016');
INSERT INTO "cities" VALUES('Chula Vista','173556');
INSERT INTO "cities" VALUES('Cincinnati','331285');
INSERT INTO "cities" VALUES('Citrus Heights','103455');
INSERT INTO "cities" VALUES('Clarksville','108787');
INSERT INTO "cities" VALUES('Clearwater','99936');
INSERT INTO "cities" VALUES('Cleveland','478403');
INSERT INTO "cities" VALUES('Colorado Springs','360890');
INSERT INTO "cities" VALUES('Columbia','116278');
INSERT INTO "cities" VALUES('Columbus','711470');
INSERT INTO "cities" VALUES('Columbus','186291');
INSERT INTO "cities" VALUES('Compton','92864');
INSERT INTO "cities" VALUES('Concord','121780');
INSERT INTO "cities" VALUES('Coral Springs','117549');
INSERT INTO "cities" VALUES('Corona','124966');
INSERT INTO "cities" VALUES('Corpus Christi','277454');
INSERT INTO "cities" VALUES('Costa Mesa','108724');
INSERT INTO "cities" VALUES('Dallas','1188580');
INSERT INTO "cities" VALUES('Daly City','103621');
INSERT INTO "cities" VALUES('Davenport','98256');
INSERT INTO "cities" VALUES('Dayton','166179');
INSERT INTO "cities" VALUES('Denver','554636');
INSERT INTO "cities" VALUES('Des Moines','198682');
INSERT INTO "cities" VALUES('Detroit','951270');
INSERT INTO "cities" VALUES('Downey','107323');
INSERT INTO "cities" VALUES('Durham','187035');
INSERT INTO "cities" VALUES('East Los Angeles','126379');
INSERT INTO "cities" VALUES('El Cajon','94578');
INSERT INTO "cities" VALUES('El Monte','115965');
INSERT INTO "cities" VALUES('El Paso','563662');
INSERT INTO "cities" VALUES('Elgin','89408');
INSERT INTO "cities" VALUES('Elizabeth','120568');
INSERT INTO "cities" VALUES('Erie','103717');
INSERT INTO "cities" VALUES('Escondido','133559');
INSERT INTO "cities" VALUES('Eugene','137893');
INSERT INTO "cities" VALUES('Evansville','121582');
INSERT INTO "cities" VALUES('Fairfield','92256');
INSERT INTO "cities" VALUES('Fall River','90555');
INSERT INTO "cities" VALUES('Fayetteville','121015');
INSERT INTO "cities" VALUES('Flint','124943');
INSERT INTO "cities" VALUES('Fontana','128929');
INSERT INTO "cities" VALUES('Fort Collins','118652');
INSERT INTO "cities" VALUES('Fort Lauderdale','152397');
INSERT INTO "cities" VALUES('Fort Wayne','205727');
INSERT INTO "cities" VALUES('Fort Worth','534694');
INSERT INTO "cities" VALUES('Fremont','203413');
INSERT INTO "cities" VALUES('Fresno','427652');
INSERT INTO "cities" VALUES('Fullerton','126003');
INSERT INTO "cities" VALUES('Gainesville','92291');
INSERT INTO "cities" VALUES('Garden Grove','165196');
INSERT INTO "cities" VALUES('Garland','215768');
INSERT INTO "cities" VALUES('Gary','102746');
INSERT INTO "cities" VALUES('Gilbert','109697');
INSERT INTO "cities" VALUES('Glendale','218812');
INSERT INTO "cities" VALUES('Glendale','194973');
INSERT INTO "cities" VALUES('Grand Prairie','127427');
INSERT INTO "cities" VALUES('Grand Rapids','197800');
INSERT INTO "cities" VALUES('Green Bay','102313');
INSERT INTO "cities" VALUES('Greensboro','223891');
INSERT INTO "cities" VALUES('Hampton','146437');
INSERT INTO "cities" VALUES('Hartford','121578');
INSERT INTO "cities" VALUES('Hayward','140030');
INSERT INTO "cities" VALUES('Henderson','175381');
INSERT INTO "cities" VALUES('Hialeah','226419');
INSERT INTO "cities" VALUES('Hollywood','139357');
INSERT INTO "cities" VALUES('Honolulu','371657');
INSERT INTO "cities" VALUES('Houston','1953631');
INSERT INTO "cities" VALUES('Huntington Beach','189594');
INSERT INTO "cities" VALUES('Huntsville','158216');
INSERT INTO "cities" VALUES('Independence','113288');
INSERT INTO "cities" VALUES('Indianapolis','791926');
INSERT INTO "cities" VALUES('Inglewood','112580');
INSERT INTO "cities" VALUES('Irvine','143072');
INSERT INTO "cities" VALUES('Irving','191615');
INSERT INTO "cities" VALUES('Jackson','184256');
INSERT INTO "cities" VALUES('Jacksonville','735167');
INSERT INTO "cities" VALUES('Jersey City','240055');
INSERT INTO "cities" VALUES('Joliet','106221');
INSERT INTO "cities" VALUES('Kansas City','441545');
INSERT INTO "cities" VALUES('Kansas City','146866');
INSERT INTO "cities" VALUES('Kenosha','89447');
INSERT INTO "cities" VALUES('Knoxville','173890');
INSERT INTO "cities" VALUES('Lafayette','110257');
INSERT INTO "cities" VALUES('Lakewood','144126');
INSERT INTO "cities" VALUES('Lancaster','118718');
INSERT INTO "cities" VALUES('Lansing','119128');
INSERT INTO "cities" VALUES('Laredo','176576');
INSERT INTO "cities" VALUES('Las Vegas','478434');
INSERT INTO "cities" VALUES('Lexington-Fayette','260512');
INSERT INTO "cities" VALUES('Lincoln','225581');
INSERT INTO "cities" VALUES('Little Rock','183133');
INSERT INTO "cities" VALUES('Livonia','100545');
INSERT INTO "cities" VALUES('Long Beach','461522');
INSERT INTO "cities" VALUES('Los Angeles','3694820');
INSERT INTO "cities" VALUES('Louisville','256231');
INSERT INTO "cities" VALUES('Lowell','105167');
INSERT INTO "cities" VALUES('Lubbock','199564');
INSERT INTO "cities" VALUES('Macon','113336');
INSERT INTO "cities" VALUES('Madison','208054');
INSERT INTO "cities" VALUES('Manchester','107006');
INSERT INTO "cities" VALUES('McAllen','106414');
INSERT INTO "cities" VALUES('Memphis','650100');
INSERT INTO "cities" VALUES('Mesa','396375');
INSERT INTO "cities" VALUES('Mesquite','124523');
INSERT INTO "cities" VALUES('Metairie','149428');
INSERT INTO "cities" VALUES('Miami','362470');
INSERT INTO "cities" VALUES('Miami Beach','97855');
INSERT INTO "cities" VALUES('Midland','98293');
INSERT INTO "cities" VALUES('Milwaukee','596974');
INSERT INTO "cities" VALUES('Minneapolis','382618');
INSERT INTO "cities" VALUES('Mission Viejo','98049');
INSERT INTO "cities" VALUES('Mobile','198915');
INSERT INTO "cities" VALUES('Modesto','188856');
INSERT INTO "cities" VALUES('Montgomery','201568');
INSERT INTO "cities" VALUES('Moreno Valley','142381');
INSERT INTO "cities" VALUES('Naperville','128358');
INSERT INTO "cities" VALUES('Nashville-Davidson','569891');
INSERT INTO "cities" VALUES('New Bedford','94780');
INSERT INTO "cities" VALUES('New Haven','123626');
INSERT INTO "cities" VALUES('New Orleans','484674');
INSERT INTO "cities" VALUES('New York','8008278');
INSERT INTO "cities" VALUES('Newark','273546');
INSERT INTO "cities" VALUES('Newport News','180150');
INSERT INTO "cities" VALUES('Norfolk','234403');
INSERT INTO "cities" VALUES('Norman','94193');
INSERT INTO "cities" VALUES('North Las Vegas','115488');
INSERT INTO "cities" VALUES('Norwalk','103298');
INSERT INTO "cities" VALUES('Oakland','399484');
INSERT INTO "cities" VALUES('Oceanside','161029');
INSERT INTO "cities" VALUES('Odessa','89293');
INSERT INTO "cities" VALUES('Oklahoma City','506132');
INSERT INTO "cities" VALUES('Omaha','390007');
INSERT INTO "cities" VALUES('Ontario','158007');
INSERT INTO "cities" VALUES('Orange','128821');
INSERT INTO "cities" VALUES('Orlando','185951');
INSERT INTO "cities" VALUES('Overland Park','149080');
INSERT INTO "cities" VALUES('Oxnard','170358');
INSERT INTO "cities" VALUES('Palmdale','116670');
INSERT INTO "cities" VALUES('Paradise','124682');
INSERT INTO "cities" VALUES('Pasadena','141674');
INSERT INTO "cities" VALUES('Pasadena','133936');
INSERT INTO "cities" VALUES('Paterson','149222');
INSERT INTO "cities" VALUES('Pembroke Pines','137427');
INSERT INTO "cities" VALUES('Peoria','112936');
INSERT INTO "cities" VALUES('Peoria','108364');
INSERT INTO "cities" VALUES('Philadelphia','1517550');
INSERT INTO "cities" VALUES('Phoenix','1321045');
INSERT INTO "cities" VALUES('Pittsburgh','334563');
INSERT INTO "cities" VALUES('Plano','222030');
INSERT INTO "cities" VALUES('Pomona','149473');
INSERT INTO "cities" VALUES('Portland','529121');
INSERT INTO "cities" VALUES('Portsmouth','100565');
INSERT INTO "cities" VALUES('Providence','173618');
INSERT INTO "cities" VALUES('Provo','105166');
INSERT INTO "cities" VALUES('Pueblo','102121');
INSERT INTO "cities" VALUES('Raleigh','276093');
INSERT INTO "cities" VALUES('Rancho Cucamonga','127743');
INSERT INTO "cities" VALUES('Reno','180480');
INSERT INTO "cities" VALUES('Richmond','197790');
INSERT INTO "cities" VALUES('Richmond','94100');
INSERT INTO "cities" VALUES('Riverside','255166');
INSERT INTO "cities" VALUES('Roanoke','93357');
INSERT INTO "cities" VALUES('Rochester','219773');
INSERT INTO "cities" VALUES('Rockford','150115');
INSERT INTO "cities" VALUES('Sacramento','407018');
INSERT INTO "cities" VALUES('Saint Louis','348189');
INSERT INTO "cities" VALUES('Saint Paul','287151');
INSERT INTO "cities" VALUES('Saint Petersburg','248232');
INSERT INTO "cities" VALUES('Salem','136924');
INSERT INTO "cities" VALUES('Salinas','151060');
INSERT INTO "cities" VALUES('Salt Lake City','181743');
INSERT INTO "cities" VALUES('San Antonio','1144646');
INSERT INTO "cities" VALUES('San Bernardino','185401');
INSERT INTO "cities" VALUES('San Buenaventura','100916');
INSERT INTO "cities" VALUES('San Diego','1223400');
INSERT INTO "cities" VALUES('San Francisco','776733');
INSERT INTO "cities" VALUES('San Jose','894943');
INSERT INTO "cities" VALUES('San Mateo','91799');
INSERT INTO "cities" VALUES('Sandy','101853');
INSERT INTO "cities" VALUES('Santa Ana','337977');
INSERT INTO "cities" VALUES('Santa Clara','102361');
INSERT INTO "cities" VALUES('Santa Clarita','151088');
INSERT INTO "cities" VALUES('Santa Monica','91084');
INSERT INTO "cities" VALUES('Santa Rosa','147595');
INSERT INTO "cities" VALUES('Savannah','131510');
INSERT INTO "cities" VALUES('Scottsdale','202705');
INSERT INTO "cities" VALUES('Seattle','563374');
INSERT INTO "cities" VALUES('Shreveport','200145');
INSERT INTO "cities" VALUES('Simi Valley','111351');
INSERT INTO "cities" VALUES('Sioux Falls','123975');
INSERT INTO "cities" VALUES('South Bend','107789');
INSERT INTO "cities" VALUES('Spokane','195629');
INSERT INTO "cities" VALUES('Springfield','152082');
INSERT INTO "cities" VALUES('Springfield','151580');
INSERT INTO "cities" VALUES('Springfield','111454');
INSERT INTO "cities" VALUES('Stamford','117083');
INSERT INTO "cities" VALUES('Sterling Heights','124471');
INSERT INTO "cities" VALUES('Stockton','243771');
INSERT INTO "cities" VALUES('Sunnyvale','131760');
INSERT INTO "cities" VALUES('Sunrise Manor','95362');
INSERT INTO "cities" VALUES('Syracuse','147306');
INSERT INTO "cities" VALUES('Tacoma','193556');
INSERT INTO "cities" VALUES('Tallahassee','150624');
INSERT INTO "cities" VALUES('Tampa','303447');
INSERT INTO "cities" VALUES('Tempe','158625');
INSERT INTO "cities" VALUES('Thousand Oaks','117005');
INSERT INTO "cities" VALUES('Toledo','313619');
INSERT INTO "cities" VALUES('Topeka','122377');
INSERT INTO "cities" VALUES('Torrance','137946');
INSERT INTO "cities" VALUES('Tucson','486699');
INSERT INTO "cities" VALUES('Tulsa','393049');
INSERT INTO "cities" VALUES('Vallejo','116760');
INSERT INTO "cities" VALUES('Vancouver','143560');
INSERT INTO "cities" VALUES('Virginia Beach','425257');
INSERT INTO "cities" VALUES('Visalia','91762');
INSERT INTO "cities" VALUES('Waco','113726');
INSERT INTO "cities" VALUES('Warren','138247');
INSERT INTO "cities" VALUES('Washington','572059');
INSERT INTO "cities" VALUES('Waterbury','107271');
INSERT INTO "cities" VALUES('West Covina','105080');
INSERT INTO "cities" VALUES('West Valley City','108896');
INSERT INTO "cities" VALUES('Westminster','100940');
INSERT INTO "cities" VALUES('Wichita','344284');
INSERT INTO "cities" VALUES('Wichita Falls','104197');
INSERT INTO "cities" VALUES('Winston-Salem','185776');
INSERT INTO "cities" VALUES('Worcester','172648');
INSERT INTO "cities" VALUES('Yonkers','196086');
COMMIT;
