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