SQL World Cities Database

Some data sets about world cities we no longer use
<br /> — Generation Time: Feb 13, 2007 at 02:12 AM</p> <p>CREATE TABLE cities (<br /> ID int(11) NOT NULL auto_increment,<br /> Name char(35) NOT NULL default ”,<br /> CountryCode char(3) NOT NULL default ”,<br /> District char(20) NOT NULL default ”,<br /> Population int(11) NOT NULL default ‘0’,<br /> PRIMARY KEY (ID)<br /> ) ENGINE=MyISAM DEFAULT CHARSET=latin1;</p> <p>INSERT INTO cities VALUES (1,’Kabul’,’AFG’,’Kabol’, 1780000);<br /> INSERT INTO cities VALUES (2,’Qandahar’,’AFG’,’Qandahar’, 237500);<br /> INSERT INTO cities VALUES (3,’Herat’,’AFG’,’Herat’, 186800);<br /> INSERT INTO cities VALUES (4,’Mazar-e-Sharif’,’AFG’,’Balkh’, 127800);<br /> INSERT INTO cities VALUES (5,’Amsterdam’,’NLD’,’Noord-Holland’, 731200);<br /> INSERT INTO cities VALUES (6,’Rotterdam’,’NLD’,’Zuid-Holland’, 593321);<br /> INSERT INTO cities VALUES (7,’Haag’,’NLD’,’Zuid-Holland’, 440900);<br /> INSERT INTO cities VALUES (8,’Utrecht’,’NLD’,’Utrecht’, 234323);<br /> INSERT INTO cities VALUES (9,’Eindhoven’,’NLD’,’Noord-Brabant’, 201843);<br /> INSERT INTO cities VALUES (10,’Tilburg’,’NLD’,’Noord-Brabant’, 193238);<br /> INSERT INTO cities VALUES (30,’Delft’,’NLD’,’Zuid-Holland’, 95268);<br /> INSERT INTO cities VALUES (31,’Heerlen’,’NLD’,’Limburg’, 95052);<br /> INSERT INTO cities VALUES (32,’Alkmaar’,’NLD’,’Noord-Holland’, 92713);<br /> INSERT INTO cities VALUES (33,’Willemstad’,’ANT’,’Curaçao’, 2345);<br /> INSERT INTO cities VALUES (50,’Tiaret’,’DZA’,’Tiaret’, 100118);<br /> INSERT INTO cities VALUES (51,’Ech-Chleff (el-Asnam)’,’DZA’,’Chlef’, 96794);<br /> INSERT INTO cities VALUES (52,’Ghardaïa’,’DZA’,’Ghardaïa’, 89415);<br /> INSERT INTO cities VALUES (53,’Tafuna’,’ASM’,’Tutuila’, 5200);<br /> INSERT INTO cities VALUES (54,’Fagatogo’,’ASM’,’Tutuila’, 2323);<br /> INSERT INTO cities VALUES (55,’Andorra la Vella’,’AND’,’Andorra la Vella’, 21189);<br /> INSERT INTO cities VALUES (56,’Luanda’,’AGO’,’Luanda’, 2022000);<br /> INSERT INTO cities VALUES (57,’Huambo’,’AGO’,’Huambo’, 163100);<br /> INSERT INTO cities VALUES (58,’Lobito’,’AGO’,’Benguela’, 130000);<br /> INSERT INTO cities VALUES (59,’Benguela’,’AGO’,’Benguela’, 128300);<br /> INSERT INTO cities VALUES (60,’Namibe’,’AGO’,’Namibe’, 118200);<br /> INSERT INTO cities VALUES (61,’South Hill’,’AIA’,’–’, 961);<br /> INSERT INTO cities VALUES (62,’The Valley’,’AIA’,’–’, 595);<br /> INSERT INTO cities VALUES (63,’Saint John´s’,’ATG’,’St John’, 24000);<br /> INSERT INTO cities VALUES (64,’Dubai’,’ARE’,’Dubai’, 669181);<br /> INSERT INTO cities VALUES (65,’Abu Dhabi’,’ARE’,’Abu Dhabi’, 398695);<br /> INSERT INTO cities VALUES (66,’Sharja’,’ARE’,’Sharja’, 320095);<br /> INSERT INTO cities VALUES (67,’al-Ayn’,’ARE’,’Abu Dhabi’, 225970);<br /> INSERT INTO cities VALUES (68,’Ajman’,’ARE’,’Ajman’, 114395);<br /> INSERT INTO cities VALUES (81,’General San Martín’,’ARG’,’Buenos Aires’, 422542);<br /> INSERT INTO cities VALUES (82,’Salta’,’ARG’,’Salta’, 367550);<br /> INSERT INTO cities VALUES (83,’Moreno’,’ARG’,’Buenos Aires’, 356993);<br /> INSERT INTO cities VALUES (84,’Santa Fé’,’ARG’,’Santa Fé’, 353063);<br /> INSERT INTO cities VALUES (85,’Avellaneda’,’ARG’,’Buenos Aires’, 353046);<br /> INSERT INTO cities VALUES (86,’Tres de Febrero’,’ARG’,’Buenos Aires’, 352311);<br /> INSERT INTO cities VALUES (87,’Morón’,’ARG’,’Buenos Aires’, 349246);<br /> INSERT INTO cities VALUES (88,’Florencio Varela’,’ARG’,’Buenos Aires’, 315432);<br /> INSERT INTO cities VALUES (89,’San Isidro’,’ARG’,’Buenos Aires’, 306341);<br /> INSERT INTO cities VALUES (90,’Tigre’,’ARG’,’Buenos Aires’, 296226);<br /> INSERT INTO cities VALUES (91,’Malvinas Argentinas’,’ARG’,’Buenos Aires’, 290335);<br /> INSERT INTO cities VALUES (92,’Vicente López’,’ARG’,’Buenos Aires’, 288341);<br /> INSERT INTO cities VALUES (93,’Berazategui’,’ARG’,’Buenos Aires’, 276916);<br /> INSERT INTO cities VALUES (94,’Corrientes’,’ARG’,’Corrientes’, 258103);<br /> INSERT INTO cities VALUES (95,’San Miguel’,’ARG’,’Buenos Aires’, 248700);<br /> INSERT INTO cities VALUES (96,’Bahía Blanca’,’ARG’,’Buenos Aires’, 239810);<br /> INSERT INTO cities VALUES (97,’Esteban Echeverría’,’ARG’,’Buenos Aires’, 235760);<br /> INSERT INTO cities VALUES (98,’Resistencia’,’ARG’,’Chaco’, 229212);<br /> INSERT INTO cities VALUES (99,’José C. Paz’,’ARG’,’Buenos Aires’, 221754);<br /> INSERT INTO cities VALUES (115,’Comodoro Rivadavia’,’ARG’,’Chubut’, 124104);<br /> INSERT INTO cities VALUES (116,’Mendoza’,’ARG’,’Mendoza’, 123027);<br /> INSERT INTO cities VALUES (117,’San Nicolás de los Arroyos’,’ARG’,’Buenos Aires’, 119302);<br /> INSERT INTO cities VALUES (118,’San Juan’,’ARG’,’San Juan’, 119152);<br /> INSERT INTO cities VALUES (119,’Escobar’,’ARG’,’Buenos Aires’, 116675);<br /> INSERT INTO cities VALUES (120,’Concordia’,’ARG’,’Entre Rios’, 116485);<br /> INSERT INTO cities VALUES (121,’Pilar’,’ARG’,’Buenos Aires’, 113428);<br /> INSERT INTO cities VALUES (122,’San Luis’,’ARG’,’San Luis’, 110136);<br /> INSERT INTO cities VALUES (123,’Ezeiza’,’ARG’,’Buenos Aires’, 99578);<br /> INSERT INTO cities VALUES (124,’San Rafael’,’ARG’,’Mendoza’, 94651);<br /> INSERT INTO cities VALUES (125,’Tandil’,’ARG’,’Buenos Aires’, 91101);<br /> INSERT INTO cities VALUES (126,’Yerevan’,’ARM’,’Yerevan’, 1248700);<br /> INSERT INTO cities VALUES (127,’Gjumri’,’ARM’,’Širak’, 211700);<br /> INSERT INTO cities VALUES (128,’Vanadzor’,’ARM’,’Lori’, 172700);<br /> INSERT INTO cities VALUES (129,’Oranjestad’,’ABW’,’–’, 29034);<br /> INSERT INTO cities VALUES (130,’Sydney’,’AUS’,’New South Wales’, 3276207);<br /> INSERT INTO cities VALUES (131,’Melbourne’,’AUS’,’Victoria’, 2865329);<br /> INSERT INTO cities VALUES (132,’Brisbane’,’AUS’,’Queensland’, 1291117);<br /> INSERT INTO cities VALUES (133,’Perth’,’AUS’,’West Australia’, 1096829);<br /> INSERT INTO cities VALUES (134,’Adelaide’,’AUS’,’South Australia’, 978100);<br /> INSERT INTO cities VALUES (135,’Canberra’,’AUS’,’Capital Region’, 322723);<br /> INSERT INTO cities VALUES (136,’Gold Coast’,’AUS’,’Queensland’, 311932);<br /> INSERT INTO cities VALUES (137,’Newcastle’,’AUS’,’New South Wales’, 270324);<br /> INSERT INTO cities VALUES (138,’Central Coast’,’AUS’,’New South Wales’, 227657);<br /> INSERT INTO cities VALUES (139,’Wollongong’,’AUS’,’New South Wales’, 219761);<br /> INSERT INTO cities VALUES (140,’Hobart’,’AUS’,’Tasmania’, 126118);<br /> INSERT INTO cities VALUES (141,’Geelong’,’AUS’,’Victoria’, 125382);<br /> INSERT INTO cities VALUES (142,’Townsville’,’AUS’,’Queensland’, 109914);<br /> INSERT INTO cities VALUES (143,’Cairns’,’AUS’,’Queensland’, 92273);<br /> INSERT INTO cities VALUES (144,’Baku’,’AZE’,’Baki’, 1787800);<br /> INSERT INTO cities VALUES (145,’Gäncä’,’AZE’,’Gäncä’, 299300);<br /> INSERT INTO cities VALUES (146,’Sumqayit’,’AZE’,’Sumqayit’, 283000);<br /> INSERT INTO cities VALUES (147,’Mingäçevir’,’AZE’,’Mingäçevir’, 93900);<br /> INSERT INTO cities VALUES (148,’Nassau’,’BHS’,’New Providence’, 172000);<br /> INSERT INTO cities VALUES (149,’al-Manama’,’BHR’,’al-Manama’, 148000);<br /> INSERT INTO cities VALUES (150,’Dhaka’,’BGD’,’Dhaka’, 3612850);<br /> INSERT INTO cities VALUES (151,’Chittagong’,’BGD’,’Chittagong’, 1392860);<br /> INSERT INTO cities VALUES (152,’Khulna’,’BGD’,’Khulna’, 663340);<br /> INSERT INTO cities VALUES (153,’Rajshahi’,’BGD’,’Rajshahi’, 294056);<br /> INSERT INTO cities VALUES (154,’Narayanganj’,’BGD’,’Dhaka’, 202134);<br /> INSERT INTO cities VALUES (155,’Rangpur’,’BGD’,’Rajshahi’, 191398);<br /> INSERT INTO cities VALUES (156,’Mymensingh’,’BGD’,’Dhaka’, 188713);<br /> INSERT INTO cities VALUES (157,’Barisal’,’BGD’,’Barisal’, 170232);<br /> INSERT INTO cities VALUES (158,’Tungi’,’BGD’,’Dhaka’, 168702);<br /> INSERT INTO cities VALUES (159,’Jessore’,’BGD’,’Khulna’, 139710);<br /> INSERT INTO cities VALUES (160,’Comilla’,’BGD’,’Chittagong’, 135313);<br /> INSERT INTO cities VALUES (161,’Nawabganj’,’BGD’,’Rajshahi’, 130577);<br /> INSERT INTO cities VALUES (162,’Dinajpur’,’BGD’,’Rajshahi’, 127815);<br /> INSERT INTO cities VALUES (163,’Bogra’,’BGD’,’Rajshahi’, 120170);<br /> INSERT INTO cities VALUES (164,’Sylhet’,’BGD’,’Sylhet’, 117396);<br /> INSERT INTO cities VALUES (165,’Brahmanbaria’,’BGD’,’Chittagong’, 109032);<br /> INSERT INTO cities VALUES (166,’Tangail’,’BGD’,’Dhaka’, 106004);<br /> INSERT INTO cities VALUES (167,’Jamalpur’,’BGD’,’Dhaka’, 103556);<br /> INSERT INTO cities VALUES (168,’Pabna’,’BGD’,’Rajshahi’, 103277);<br /> INSERT INTO cities VALUES (169,’Naogaon’,’BGD’,’Rajshahi’, 101266);<br /> INSERT INTO cities VALUES (170,’Sirajganj’,’BGD’,’Rajshahi’, 99669);<br /> INSERT INTO cities VALUES (171,’Narsinghdi’,’BGD’,’Dhaka’, 98342);<br /> INSERT INTO cities VALUES (172,’Saidpur’,’BGD’,’Rajshahi’, 96777);<br /> INSERT INTO cities VALUES (173,’Gazipur’,’BGD’,’Dhaka’, 96717);<br /> INSERT INTO cities VALUES (174,’Bridgetown’,’BRB’,’St Michael’, 6070);<br /> INSERT INTO cities VALUES (175,’Antwerpen’,’BEL’,’Antwerpen’, 446525);<br /> INSERT INTO cities VALUES (176,’Gent’,’BEL’,’East Flanderi’, 224180);<br /> INSERT INTO cities VALUES (177,’Charleroi’,’BEL’,’Hainaut’, 200827);<br /> INSERT INTO cities VALUES (178,’Liège’,’BEL’,’Liège’, 185639);<br /> INSERT INTO cities VALUES (179,’Bruxelles [Brussel]’,’BEL’,’Bryssel’, 133859);<br /> INSERT INTO cities VALUES (180,’Brugge’,’BEL’,’West Flanderi’, 116246);<br /> INSERT INTO cities VALUES (181,’Schaerbeek’,’BEL’,’Bryssel’, 105692);<br /> INSERT INTO cities VALUES (182,’Namur’,’BEL’,’Namur’, 105419);<br /> INSERT INTO cities VALUES (183,’Mons’,’BEL’,’Hainaut’, 90935);<br /> INSERT INTO cities VALUES (184,’Belize City’,’BLZ’,’Belize City’, 55810);<br /> INSERT INTO cities VALUES (185,’Belmopan’,’BLZ’,’Cayo’, 7105);<br /> INSERT INTO cities VALUES (186,’Cotonou’,’BEN’,’Atlantique’, 536827);<br /> INSERT INTO cities VALUES (187,’Porto-Novo’,’BEN’,’Ouémé’, 194000);<br /> INSERT INTO cities VALUES (188,’Djougou’,’BEN’,’Atacora’, 134099);<br /> INSERT INTO cities VALUES (189,’Parakou’,’BEN’,’Borgou’, 103577);<br /> INSERT INTO cities VALUES (190,’Saint George’,’BMU’,’Saint George´s’, 1800);<br /> INSERT INTO cities VALUES (191,’Hamilton’,’BMU’,’Hamilton’, 1200);<br /> INSERT INTO cities VALUES (192,’Thimphu’,’BTN’,’Thimphu’, 22000);<br /> INSERT INTO cities VALUES (193,’Santa Cruz de la Sierra’,’BOL’,’Santa Cruz’, 935361);<br /> INSERT INTO cities VALUES (194,’La Paz’,’BOL’,’La Paz’, 758141);<br /> INSERT INTO cities VALUES (195,’El Alto’,’BOL’,’La Paz’, 534466);<br /> INSERT INTO cities VALUES (196,’Cochabamba’,’BOL’,’Cochabamba’, 482800);<br /> INSERT INTO cities VALUES (197,’Oruro’,’BOL’,’Oruro’, 223553);<br /> INSERT INTO cities VALUES (198,’Sucre’,’BOL’,’Chuquisaca’, 178426);<br /> INSERT INTO cities VALUES (199,’Potosí’,’BOL’,’Potosí’, 140642);<br /> INSERT INTO cities VALUES (200,’Tarija’,’BOL’,’Tarija’, 125255);<br /> INSERT INTO cities VALUES (201,’Sarajevo’,’BIH’,’Federaatio’, 360000);<br /> INSERT INTO cities VALUES (202,’Banja Luka’,’BIH’,’Republika Srpska’, 143079);<br /> INSERT INTO cities VALUES (203,’Zenica’,’BIH’,’Federaatio’, 96027);<br /> INSERT INTO cities VALUES (204,’Gaborone’,’BWA’,’Gaborone’, 213017);<br /> INSERT INTO cities VALUES (205,’Francistown’,’BWA’,’Francistown’, 101805);<br /> INSERT INTO cities VALUES (206,’São Paulo’,’BRA’,’São Paulo’, 9968485);<br /> INSERT INTO cities VALUES (207,’Rio de Janeiro’,’BRA’,’Rio de Janeiro’, 5598953);<br /> INSERT INTO cities VALUES (208,’Salvador’,’BRA’,’Bahia’, 2302832);<br /> INSERT INTO cities VALUES (209,’Belo Horizonte’,’BRA’,’Minas Gerais’, 2139125);<br /> INSERT INTO cities VALUES (210,’Fortaleza’,’BRA’,’Ceará’, 2097757);<br /> INSERT INTO cities VALUES (211,’Brasília’,’BRA’,’Distrito Federal’, 1969868);<br /> INSERT INTO cities VALUES (212,’Curitiba’,’BRA’,’Paraná’, 1584232);<br /> INSERT INTO cities VALUES (213,’Recife’,’BRA’,’Pernambuco’, 1378087);<br /> INSERT INTO cities VALUES (214,’Porto Alegre’,’BRA’,’Rio Grande do Sul’, 1314032);<br /> INSERT INTO cities VALUES (215,’Manaus’,’BRA’,’Amazonas’, 1255049);<br /> INSERT INTO cities VALUES (216,’Belém’,’BRA’,’Pará’, 1186926);<br /> INSERT INTO cities VALUES (217,’Guarulhos’,’BRA’,’São Paulo’, 1095874);<br /> INSERT INTO cities VALUES (218,’Goiânia’,’BRA’,’Goiás’, 1056330);<br /> ….<br />

Full file: cities.txt