mathie's tech+business bits: SQL World Cities Database

Some data sets about world cities we no longer use

-- Generation Time: Feb 13, 2007 at 02:12 AM

CREATE TABLE cities (
  ID int(11) NOT NULL auto_increment,
  Name char(35) NOT NULL default '',
  CountryCode char(3) NOT NULL default '',
  District char(20) NOT NULL default '',
  Population int(11) NOT NULL default '0',
  PRIMARY KEY  (ID)
) ENGINE=MyISAM  DEFAULT CHARSET=latin1;

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

Full file: cities.txt

Labels: database

mathie's tech+business bits

Monday, February 12, 2007

SQL World Cities Database

0 Comments:

Links

Source Code

Support This Blog

Previous Posts