View table: worldcities

Jump to navigation Jump to search

Table structure:

  1. city - Page
  2. city_ascii - Text
  3. lat - Latitude
  4. lon - Longitude
  5. coordinates - Coordinates
  6. country - Page
  7. iso2 - String
  8. iso3 - String
  9. admin_name - Page
  10. population - Integer
  11. id - String

This table has 41,906 rows altogether.

Recreate data.

Page city city ascii lat lon coordinates country iso2 iso3 admin name population id
Cities of the world (edit) Aba Aba 5.1167 7.3667 5.1167, 7.3667 Nigeria NG NGA Abia 1,530,000 1566262000
Cities of the world (edit) Abidjan Abidjan 5.3364 -4.0267 5.3364, -4.0267 Côte d'Ivoire CI CIV Abidjan 4,980,000 1384207980
Cities of the world (edit) Abu Dhabi Abu Dhabi 24.4511 54.3969 24.4511, 54.3969 United Arab Emirates AE ARE Abū Z̧aby 1,483,000 1784176710
Cities of the world (edit) Accra Accra 5.6037 -0.187 5.6037, -0.187 Ghana GH GHA Greater Accra 2,291,352 1288299415
Cities of the world (edit) Addis Ababa Addis Ababa 9.0272 38.7369 9.0272, 38.7369 Ethiopia ET ETH Ādīs Ābeba 3,041,002 1231824991
Cities of the world (edit) Āgra Agra 27.1724 78.0131 27.1724, 78.0131 India IN IND Uttar Pradesh 1,592,000 1356187395
Cities of the world (edit) Ahmedabad Ahmedabad 23.03 72.58 23.03, 72.58 India IN IND Gujarāt 7,717,000 1356304381
Cities of the world (edit) Aleppo Aleppo 36.2 37.15 36.2, 37.15 Syria SY SYR Ḩalab 1,916,781 1760366651
Cities of the world (edit) Alexandria Alexandria 31.2 29.9167 31.2, 29.9167 Egypt EG EGY Al Iskandarīyah 4,870,000 1818695837
Cities of the world (edit) Algiers Algiers 36.7764 3.0586 36.7764, 3.0586 Algeria DZ DZA Alger 3,415,811 1012973369
Cities of the world (edit) Allahābād Allahabad 25.45 81.85 25.45, 81.85 India IN IND Uttar Pradesh 5,954,391 1356718332
Cities of the world (edit) Almaty Almaty 43.25 76.9 43.25, 76.9 Kazakhstan KZ KAZ Almaty 1,916,822 1398351701
Cities of the world (edit) Amman Amman 31.95 35.9333 31.95, 35.9333 Jordan JO JOR Al ‘Āşimah 4,007,526 1400522593
Cities of the world (edit) Ankang Ankang 32.6877 109.0235 32.6877, 109.0235 China CN CHN Shaanxi 2,629,906 1156255711
Cities of the world (edit) Anqing Anqing 30.5 117.0333 30.5, 117.0333 China CN CHN Anhui 4,723,000 1156238875
Cities of the world (edit) Anshan Anshan 41.1066 122.9895 41.1066, 122.9895 China CN CHN Liaoning 3,645,884 1156901825
Cities of the world (edit) Anshun Anshun 26.2456 105.934 26.2456, 105.934 China CN CHN Guizhou 2,353,100 1156415948
Cities of the world (edit) Antananarivo Antananarivo -18.9386 47.5214 -18.9386, 47.5214 Madagascar MG MDG Antananarivo 2,610,000 1450978461
Cities of the world (edit) Atlanta Atlanta 33.7627 -84.4224 33.7627, -84.4224 United States US USA Georgia 5,449,398 1840013660
Cities of the world (edit) Austin Austin 30.3004 -97.7522 30.3004, -97.7522 United States US USA Texas 1,687,311 1840019590
Cities of the world (edit) Baghdad Baghdad 33.35 44.4167 33.35, 44.4167 Iraq IQ IRQ Baghdād 6,107,000 1368596238
Cities of the world (edit) Baicheng Baicheng 23.901 106.6194 23.901, 106.6194 China CN CHN Guangxi 3,669,400 1156981113
Cities of the world (edit) Baicheng Baicheng 45.6148 122.832 45.6148, 122.832 China CN CHN Jilin 2,032,356 1156435764
Cities of the world (edit) Baiyin Baiyin 36.5448 104.1766 36.5448, 104.1766 China CN CHN Gansu 1,708,751 1156140738
Cities of the world (edit) Baku Baku 40.3667 49.8352 40.3667, 49.8352 Azerbaijan AZ AZE Bakı 2,181,800 1031946365
Cities of the world (edit) Baltimore Baltimore 39.3051 -76.6144 39.3051, -76.6144 United States US USA Maryland 2,106,068 1840001592
Cities of the world (edit) Bamako Bamako 12.6458 -7.9922 12.6458, -7.9922 Mali ML MLI Bamako 2,009,109 1466965925
Cities of the world (edit) Bandung Bandung -6.95 107.5667 -6.95, 107.5667 Indonesia ID IDN Jawa Barat 2,875,673 1360313023
Cities of the world (edit) Bangalore Bangalore 12.9791 77.5913 12.9791, 77.5913 India IN IND Karnātaka 13,999,000 1356410365
Cities of the world (edit) Bangkok Bangkok 13.75 100.5167 13.75, 100.5167 Thailand TH THA Krung Thep Maha Nakhon 17,573,000 1764068610
Cities of the world (edit) Baoding Baoding 38.8671 115.4845 38.8671, 115.4845 China CN CHN Hebei 11,860,000 1156256829
Cities of the world (edit) Baojishi Baojishi 34.3609 107.1751 34.3609, 107.1751 China CN CHN Shaanxi 3,738,700 1156101096
Cities of the world (edit) Baoshan Baoshan 25.1211 99.169 25.1211, 99.169 China CN CHN Yunnan 2,627,000 1156546994
Cities of the world (edit) Baotou Baotou 40.6562 109.8345 40.6562, 109.8345 China CN CHN Inner Mongolia 2,650,364 1156032751
Cities of the world (edit) Barcelona Barcelona 41.3825 2.1769 41.3825, 2.1769 Spain ES ESP Catalonia 4,735,000 1724594040
Cities of the world (edit) Bazhou Bazhou 31.8576 106.7559 31.8576, 106.7559 China CN CHN Sichuan 3,283,148 1156271365
Cities of the world (edit) Beihai Beihai 21.4667 109.1 21.4667, 109.1 China CN CHN Guangxi 1,680,000 1156421449
Cities of the world (edit) Beijing Beijing 39.904 116.4075 39.904, 116.4075 China CN CHN Beijing 19,437,000 1156228865
Cities of the world (edit) Bekasi Bekasi -6.2333 107 -6.2333, 107 Indonesia ID IDN Jawa Barat 2,381,053 1360006015
Cities of the world (edit) Belém Belem -1.4558 -48.5039 -1.4558, -48.5039 Brazil BR BRA Pará 1,499,641 1076646823
Cities of the world (edit) Belo Horizonte Belo Horizonte -19.9281 -43.9419 -19.9281, -43.9419 Brazil BR BRA Minas Gerais 5,159,000 1076967355
Cities of the world (edit) Bengbu Bengbu 32.9354 117.3531 32.9354, 117.3531 China CN CHN Anhui 3,164,467 1156440668
Cities of the world (edit) Benxi Benxi 41.292 123.761 41.292, 123.761 China CN CHN Liaoning 1,709,538 1156097909
Cities of the world (edit) Berlin Berlin 52.5167 13.3833 52.5167, 13.3833 Germany DE DEU Berlin 3,664,088 1276451290
Cities of the world (edit) Bhopāl Bhopal 23.25 77.4167 23.25, 77.4167 India IN IND Madhya Pradesh 1,798,218 1356734039
Cities of the world (edit) Bijie Bijie 27.3019 105.2863 27.3019, 105.2863 China CN CHN Guizhou 6,686,100 1156018927
Cities of the world (edit) Bilāspur Bilaspur 22.15 82.0167 22.15, 82.0167 India IN IND Chhattīsgarh 1,625,502 1356820491
Cities of the world (edit) Binzhou Binzhou 37.3806 118.0125 37.3806, 118.0125 China CN CHN Shandong 3,748,474 1156564962
Cities of the world (edit) Blantyre Blantyre -15.7861 35.0058 -15.7861, 35.0058 Malawi MW MWI Blantyre 1,895,973 1454145012
Cities of the world (edit) Bogotá Bogota 4.6126 -74.0705 4.6126, -74.0705 Colombia CO COL Bogotá 7,743,955 1170483426
Cities of the world (edit) Boston Boston 42.3188 -71.0846 42.3188, -71.0846 United States US USA Massachusetts 4,688,346 1840000455
Cities of the world (edit) Bozhou Bozhou 33.8626 115.7742 33.8626, 115.7742 China CN CHN Anhui 4,850,657 1156356860
Cities of the world (edit) Brasília Brasilia -15.7939 -47.8828 -15.7939, -47.8828 Brazil BR BRA Distrito Federal 3,015,268 1076144436
Cities of the world (edit) Brazzaville Brazzaville -4.2667 15.2833 -4.2667, 15.2833 Congo (Brazzaville) CG COG Brazzaville 1,827,000 1178340306
Cities of the world (edit) Brisbane Brisbane -27.4678 153.0281 -27.4678, 153.0281 Australia AU AUS Queensland 2,360,241 1036192929
Cities of the world (edit) Brooklyn Brooklyn 40.6501 -73.9496 40.6501, -73.9496 United States US USA New York 2,559,903 1840034030
Cities of the world (edit) Brussels Brussels 50.8353 4.3314 50.8353, 4.3314 Belgium BE BEL Brussels-Capital Region 1,743,000 1056469830
Cities of the world (edit) Bucharest Bucharest 44.4 26.0833 44.4, 26.0833 Romania RO ROU Bucureşti 1,883,425 1642414442
Cities of the world (edit) Budapest Budapest 47.4983 19.0408 47.4983, 19.0408 Hungary HU HUN Budapest 1,723,836 1348611435
Cities of the world (edit) Buenos Aires Buenos Aires -34.5997 -58.3819 -34.5997, -58.3819 Argentina AR ARG Buenos Aires, Ciudad Autónoma de 16,216,000 1032717330
Cities of the world (edit) Busan Busan 35.1 129.0403 35.1, 129.0403 South Korea KR KOR Busan 3,453,198 1410601465
Cities of the world (edit) Cairo Cairo 30.0444 31.2358 30.0444, 31.2358 Egypt EG EGY Al Qāhirah 19,787,000 1818253931
Cities of the world (edit) Cali Cali 3.44 -76.5197 3.44, -76.5197 Colombia CO COL Valle del Cauca 2,471,474 1170417589
Cities of the world (edit) Caloocan City Caloocan City 14.65 120.9667 14.65, 120.9667 Philippines PH PHL Caloocan 1,661,584 1608897690
Cities of the world (edit) Cangzhou Cangzhou 38.3037 116.8452 38.3037, 116.8452 China CN CHN Hebei 7,544,300 1156698069
Cities of the world (edit) Caracas Caracas 10.5 -66.9333 10.5, -66.9333 Venezuela VE VEN Distrito Capital 1,943,901 1862748204
Cities of the world (edit) Casablanca Casablanca 33.5992 -7.62 33.5992, -7.62 Morocco MA MAR Casablanca-Settat 4,370,000 1504175315
Cities of the world (edit) Cawnpore Cawnpore 26.4725 80.3311 26.4725, 80.3311 India IN IND Uttar Pradesh 2,701,324 1356575238
Cities of the world (edit) Changchun Changchun 43.9 125.2 43.9, 125.2 China CN CHN Jilin 7,674,439 1156078103
Cities of the world (edit) Changde Changde 29.0397 111.6839 29.0397, 111.6839 China CN CHN Hunan 5,827,200 1156449091
Cities of the world (edit) Changsha Changsha 28.1987 112.9709 28.1987, 112.9709 China CN CHN Hunan 8,154,700 1156961497
Cities of the world (edit) Changshu Changshu 31.65 120.7333 31.65, 120.7333 China CN CHN Jiangsu 1,510,100 1156901538
Cities of the world (edit) Changzhi Changzhi 36.1953 113.097 36.1953, 113.097 China CN CHN Shanxi 3,334,565 1156057944
Cities of the world (edit) Changzhou Changzhou 31.8122 119.9692 31.8122, 119.9692 China CN CHN Jiangsu 5,278,121 1156185511
Cities of the world (edit) Chaoyang Chaoyang 41.5757 120.4486 41.5757, 120.4486 China CN CHN Liaoning 3,044,641 1156706927
Cities of the world (edit) Chaozhou Chaozhou 23.67 116.63 23.67, 116.63 China CN CHN Guangdong 2,656,600 1156549118
Cities of the world (edit) Charlotte Charlotte 35.208 -80.8304 35.208, -80.8304 United States US USA North Carolina 1,512,923 1840014557
Cities of the world (edit) Chattogram Chattogram 22.335 91.8325 22.335, 91.8325 Bangladesh BD BGD Chittagong 2,581,643 1050830722
Cities of the world (edit) Chengde Chengde 40.9739 117.9322 40.9739, 117.9322 China CN CHN Hebei 3,473,201 1156197800
Cities of the world (edit) Chengdu Chengdu 30.66 104.0633 30.66, 104.0633 China CN CHN Sichuan 11,920,000 1156421555
Cities of the world (edit) Chengtangcun Chengtangcun 35.0833 117.15 35.0833, 117.15 China CN CHN Shandong 1,603,659 1156883901
Cities of the world (edit) Chennai Chennai 13.0825 80.275 13.0825, 80.275 India IN IND Tamil Nādu 11,564,000 1356374944
Cities of the world (edit) Chenzhou Chenzhou 25.7989 113.0267 25.7989, 113.0267 China CN CHN Hunan 4,744,500 1156291915
Cities of the world (edit) Chicago Chicago 41.8373 -87.6862 41.8373, -87.6862 United States US USA Illinois 8,604,203 1840000494
Cities of the world (edit) Chifeng Chifeng 42.2663 118.9223 42.2663, 118.9223 China CN CHN Inner Mongolia 4,341,245 1156277458
Cities of the world (edit) Chongqing Chongqing 29.55 106.5069 29.55, 106.5069 China CN CHN Chongqing 8,261,000 1156936556
Cities of the world (edit) Chongzuo Chongzuo 22.4167 107.3667 22.4167, 107.3667 China CN CHN Guangxi 2,099,400 1156438670
Cities of the world (edit) Chuzhou Chuzhou 32.3062 118.3115 32.3062, 118.3115 China CN CHN Anhui 3,937,868 1156036420
Cities of the world (edit) Cincinnati Cincinnati 39.1413 -84.5061 39.1413, -84.5061 United States US USA Ohio 1,662,691 1840003814
Cities of the world (edit) Cleveland Cleveland 41.4767 -81.6804 41.4767, -81.6804 United States US USA Ohio 1,710,093 1840000596
Cities of the world (edit) Columbus Columbus 39.9862 -82.985 39.9862, -82.985 United States US USA Ohio 1,562,009 1840003760
Cities of the world (edit) Conakry Conakry 9.538 -13.6773 9.538, -13.6773 Guinea GN GIN Conakry 1,667,864 1324568159
Cities of the world (edit) Curitiba Curitiba -25.4297 -49.2719 -25.4297, -49.2719 Brazil BR BRA Paraná 1,879,355 1076701712
Cities of the world (edit) Daegu Daegu 35.8667 128.6 35.8667, 128.6 South Korea KR KOR Daegu 2,461,002 1410095252
Cities of the world (edit) Daejeon Daejeon 36.351 127.385 36.351, 127.385 South Korea KR KOR Daejeon 1,475,221 1410993875
Cities of the world (edit) Dalian Dalian 38.9 121.6 38.9, 121.6 China CN CHN Liaoning 4,480,000 1156175472
Cities of the world (edit) Dallas Dallas 32.7936 -96.7662 32.7936, -96.7662 United States US USA Texas 5,743,938 1840019440
Cities of the world (edit) Damascus Damascus 33.5131 36.2919 33.5131, 36.2919 Syria SY SYR Dimashq 1,754,000 1760685964
Cities of the world (edit) Dandong Dandong 40.1167 124.3833 40.1167, 124.3833 China CN CHN Liaoning 2,444,697 1156178316
Cities of the world (edit) Daqing Daqing 46.5979 125.008 46.5979, 125.008 China CN CHN Heilongjiang 2,904,532 1156403962

More...

Retrieved from "https://wikimd.org/wiki/Special:CargoTables/worldcities"