View table: worldcities

From WikiMD's Food, Medicine & Wellness Encyclopedia

Table structure:

  • city - Page
  • city_ascii - Text
  • lat - Latitude
  • lon - Longitude
  • coordinates - Coordinates
  • country - Page
  • iso2 - String
  • iso3 - String
  • admin_name - Page
  • population - Integer
  • id - String

This table has 31,011 rows altogether.

Recreate data.

Page city city ascii lat lon coordinates country iso2 iso3 admin name population id
World cities (data only) Aba Aba 5.1167 7.3667 5.1167, 7.3667 Nigeria NG NGA Abia 1,530,000 1566262000
World cities (data only) Abaeté Abaete -19.1583 -45.4522 -19.1583, -45.4522 Brazil BR BRA Minas Gerais 800,000 1076413528
World cities (data only) Abeokuta Abeokuta 7.15 3.35 7.15, 3.35 Nigeria NG NGA Ogun 888,924 1566979497
World cities (data only) Abidjan Abidjan 5.3364 -4.0267 5.3364, -4.0267 Côte d'Ivoire CI CIV Abidjan 4,980,000 1384207980
World cities (data only) Abu Dhabi Abu Dhabi 24.4511 54.3969 24.4511, 54.3969 United Arab Emirates AE ARE Abū Z̧aby 1,483,000 1784176710
World cities (data only) Abuja Abuja 9.0556 7.4914 9.0556, 7.4914 Nigeria NG NGA Federal Capital Territory 1,235,880 1566342270
World cities (data only) Accra Accra 5.6037 -0.187 5.6037, -0.187 Ghana GH GHA Greater Accra 2,291,352 1288299415
World cities (data only) Ad Dammām Ad Dammam 26.4333 50.1 26.4333, 50.1 Saudi Arabia SA SAU Ash Sharqīyah 903,312 1682452296
World cities (data only) Adamstown Adamstown -25.0667 -130.0833 -25.0667, -130.0833 Pitcairn Islands PN PCN 1612000000
World cities (data only) Addis Ababa Addis Ababa 9.0272 38.7369 9.0272, 38.7369 Ethiopia ET ETH Ādīs Ābeba 3,041,002 1231824991
World cities (data only) Adelaide Adelaide -34.9275 138.6 -34.9275, 138.6 Australia AU AUS South Australia 1,295,714 1036538171
World cities (data only) Āgra Agra 27.1724 78.0131 27.1724, 78.0131 India IN IND Uttar Pradesh 1,592,000 1356187395
World cities (data only) Aguascalientes Aguascalientes 21.876 -102.296 21.876, -102.296 Mexico MX MEX Aguascalientes 934,424 1484666646
World cities (data only) Ahmedabad Ahmedabad 23.03 72.58 23.03, 72.58 India IN IND Gujarāt 7,717,000 1356304381
World cities (data only) Ahvāz Ahvaz 31.3203 48.6692 31.3203, 48.6692 Iran IR IRN Khūzestān 1,184,788 1364350188
World cities (data only) Akure Akure 7.25 5.195 7.25, 5.195 Nigeria NG NGA Ondo 847,903 1566568277
World cities (data only) Al Başrah Al Basrah 30.515 47.81 30.515, 47.81 Iraq IQ IRQ Al Başrah 1,326,564 1368714645
World cities (data only) Al Manşūrah Al Mansurah 31.05 31.3833 31.05, 31.3833 Egypt EG EGY Ad Daqahlīyah 960,423 1818255319
World cities (data only) Al Quds Al Quds 31.7764 35.2269 31.7764, 35.2269 West Bank XW XWB 1934000006
World cities (data only) Aleppo Aleppo 36.2 37.15 36.2, 37.15 Syria SY SYR Ḩalab 1,916,781 1760366651
World cities (data only) Alexandria Alexandria 31.2 29.9167 31.2, 29.9167 Egypt EG EGY Al Iskandarīyah 4,870,000 1818695837
World cities (data only) Algiers Algiers 36.7764 3.0586 36.7764, 3.0586 Algeria DZ DZA Alger 3,415,811 1012973369
World cities (data only) Alīgarh Aligarh 27.88 78.08 27.88, 78.08 India IN IND Uttar Pradesh 1,131,160 1356076391
World cities (data only) Allahābād Allahabad 25.45 81.85 25.45, 81.85 India IN IND Uttar Pradesh 5,954,391 1356718332
World cities (data only) Almaty Almaty 43.25 76.9 43.25, 76.9 Kazakhstan KZ KAZ Almaty 1,916,822 1398351701
World cities (data only) Alofi Alofi -19.056 -169.921 -19.056, -169.921 Niue NU NIU 1,611 1570882835
World cities (data only) Amman Amman 31.95 35.9333 31.95, 35.9333 Jordan JO JOR Al ‘Āşimah 4,007,526 1400522593
World cities (data only) Amritsar Amritsar 31.6269 74.877 31.6269, 74.877 India IN IND Punjab 1,132,383 1356926507
World cities (data only) Amsterdam Amsterdam 52.3667 4.8833 52.3667, 4.8833 Netherlands NL NLD Noord-Holland 862,965 1528355309
World cities (data only) Andorra la Vella Andorra la Vella 42.5 1.5 42.5, 1.5 Andorra AD AND Andorra la Vella 22,615 1020828846
World cities (data only) Ankang Ankang 32.6877 109.0235 32.6877, 109.0235 China CN CHN Shaanxi 2,629,906 1156255711
World cities (data only) Ankara Ankara 39.93 32.85 39.93, 32.85 Turkey TR TUR Ankara 77,168 1792572891
World cities (data only) Anqing Anqing 30.5 117.0333 30.5, 117.0333 China CN CHN Anhui 4,723,000 1156238875
World cities (data only) Anqiu Anqiu 36.3619 119.1072 36.3619, 119.1072 China CN CHN Shandong 947,723 1156592047
World cities (data only) Anshan Anshan 41.1066 122.9895 41.1066, 122.9895 China CN CHN Liaoning 3,645,884 1156901825
World cities (data only) Anshun Anshun 26.2456 105.934 26.2456, 105.934 China CN CHN Guizhou 2,353,100 1156415948
World cities (data only) Antananarivo Antananarivo -18.9386 47.5214 -18.9386, 47.5214 Madagascar MG MDG Antananarivo 2,610,000 1450978461
World cities (data only) Antipolo Antipolo 14.5842 121.1763 14.5842, 121.1763 Philippines PH PHL Rizal 887,399 1608824345
World cities (data only) Apia Apia -13.8333 -171.8333 -13.8333, -171.8333 Samoa WS WSM Tuamasaga 37,708 1882489296
World cities (data only) Ar Ramādī Ar Ramadi 33.4258 43.2992 33.4258, 43.2992 Iraq IQ IRQ Al Anbār 874,543 1368838855
World cities (data only) Arequipa Arequipa -16.3988 -71.5369 -16.3988, -71.5369 Peru PE PER Arequipa 1,008,290 1604723954
World cities (data only) Ashgabat Ashgabat 37.95 58.3833 37.95, 58.3833 Turkmenistan TM TKM Ahal 19,426 1795049992
World cities (data only) Asmara Asmara 15.3333 38.9167 15.3333, 38.9167 Eritrea ER ERI Ma’ākel 963,000 1232791236
World cities (data only) Asunción Asuncion -25.3 -57.6333 -25.3, -57.6333 Paraguay PY PRY Asunción 524,190 1600057911
World cities (data only) Athens Athens 37.9842 23.7281 37.9842, 23.7281 Greece GR GRC Attikí 664,046 1300715560
World cities (data only) Atlanta Atlanta 33.7627 -84.4224 33.7627, -84.4224 United States US USA Georgia 5,449,398 1840013660
World cities (data only) Auckland Auckland -36.85 174.7833 -36.85, 174.7833 New Zealand NZ NZL Auckland 1,346,091 1554435911
World cities (data only) Aurangābād Aurangabad 19.88 75.32 19.88, 75.32 India IN IND Mahārāshtra 1,371,330 1356840670
World cities (data only) Austin Austin 30.3004 -97.7522 30.3004, -97.7522 United States US USA Texas 1,687,311 1840019590
World cities (data only) Avarua Avarua -21.207 -159.771 -21.207, -159.771 Cook Islands CK COK 5,445 1184217570
World cities (data only) Bagam Bagam 1.0678 104.0167 1.0678, 104.0167 Indonesia ID IDN Kepulauan Riau 1,029,808 1360405604
World cities (data only) Baghdad Baghdad 33.35 44.4167 33.35, 44.4167 Iraq IQ IRQ Baghdād 6,107,000 1368596238
World cities (data only) Baicheng Baicheng 23.901 106.6194 23.901, 106.6194 China CN CHN Guangxi 3,669,400 1156981113
World cities (data only) Baicheng Baicheng 45.6148 122.832 45.6148, 122.832 China CN CHN Jilin 2,032,356 1156435764
World cities (data only) Baishan Baishan 41.9377 126.4179 41.9377, 126.4179 China CN CHN Jilin 1,296,127 1156960624
World cities (data only) Baiyin Baiyin 36.5448 104.1766 36.5448, 104.1766 China CN CHN Gansu 1,708,751 1156140738
World cities (data only) Baku Baku 40.3667 49.8352 40.3667, 49.8352 Azerbaijan AZ AZE Bakı 2,181,800 1031946365
World cities (data only) Baltimore Baltimore 39.3051 -76.6144 39.3051, -76.6144 United States US USA Maryland 2,106,068 1840001592
World cities (data only) Bamako Bamako 12.6458 -7.9922 12.6458, -7.9922 Mali ML MLI Bamako 2,009,109 1466965925
World cities (data only) Bandar Lampung Bandar Lampung -5.4294 105.2625 -5.4294, 105.2625 Indonesia ID IDN Lampung 1,166,761 1360243491
World cities (data only) Bandar Seri Begawan Bandar Seri Begawan 4.9167 114.9167 4.9167, 114.9167 Brunei BN BRN Brunei and Muara 50,000 1096465895
World cities (data only) Bandung Bandung -6.95 107.5667 -6.95, 107.5667 Indonesia ID IDN Jawa Barat 2,875,673 1360313023
World cities (data only) Bangalore Bangalore 12.9791 77.5913 12.9791, 77.5913 India IN IND Karnātaka 13,999,000 1356410365
World cities (data only) Bangkok Bangkok 13.75 100.5167 13.75, 100.5167 Thailand TH THA Krung Thep Maha Nakhon 17,573,000 1764068610
World cities (data only) Bangui Bangui 4.3732 18.5628 4.3732, 18.5628 Central African Republic CF CAF Bangui 889,231 1140080881
World cities (data only) Banjul Banjul 13.4531 -16.5775 13.4531, -16.5775 The Gambia GM GMB Banjul 31,356 1270723713
World cities (data only) Baoding Baoding 38.8671 115.4845 38.8671, 115.4845 China CN CHN Hebei 11,860,000 1156256829
World cities (data only) Baojishi Baojishi 34.3609 107.1751 34.3609, 107.1751 China CN CHN Shaanxi 3,738,700 1156101096
World cities (data only) Baoshan Baoshan 25.1211 99.169 25.1211, 99.169 China CN CHN Yunnan 2,627,000 1156546994
World cities (data only) Baotou Baotou 40.6562 109.8345 40.6562, 109.8345 China CN CHN Inner Mongolia 2,650,364 1156032751
World cities (data only) Barcelona Barcelona 41.3825 2.1769 41.3825, 2.1769 Spain ES ESP Catalonia 4,735,000 1724594040
World cities (data only) Bareilly Bareilly 28.364 79.415 28.364, 79.415 India IN IND Uttar Pradesh 1,000,000 1356698199
World cities (data only) Barquisimeto Barquisimeto 10.0678 -69.3467 10.0678, -69.3467 Venezuela VE VEN Lara 1,059,092 1862860739
World cities (data only) Barranquilla Barranquilla 10.9639 -74.7964 10.9639, -74.7964 Colombia CO COL Atlántico 1,274,250 1170179113
World cities (data only) Basse-Terre Basse-Terre 16.0104 -61.7055 16.0104, -61.7055 Guadeloupe GP GLP 307 1312938008
World cities (data only) Basseterre Basseterre 17.2983 -62.7342 17.2983, -62.7342 Saint Kitts And Nevis KN KNA Saint George Basseterre 13,220 1659198919
World cities (data only) Bazhou Bazhou 31.8576 106.7559 31.8576, 106.7559 China CN CHN Sichuan 3,283,148 1156271365
World cities (data only) Beidao Beidao 34.602 105.918 34.602, 105.918 China CN CHN Gansu 1,225,000 1156137209
World cities (data only) Beihai Beihai 21.4667 109.1 21.4667, 109.1 China CN CHN Guangxi 1,680,000 1156421449
World cities (data only) Beijing Beijing 39.904 116.4075 39.904, 116.4075 China CN CHN Beijing 19,437,000 1156228865
World cities (data only) Beirut Beirut 33.8869 35.5131 33.8869, 35.5131 Lebanon LB LBN Beyrouth 361,366 1422847713
World cities (data only) Bekasi Bekasi -6.2333 107 -6.2333, 107 Indonesia ID IDN Jawa Barat 2,381,053 1360006015
World cities (data only) Belém Belem -1.4558 -48.5039 -1.4558, -48.5039 Brazil BR BRA Pará 1,499,641 1076646823
World cities (data only) Belgrade Belgrade 44.8167 20.4667 44.8167, 20.4667 Serbia RS SRB Beograd 1,378,682 1688374696
World cities (data only) Belmopan Belmopan 17.25 -88.7675 17.25, -88.7675 Belize BZ BLZ Cayo 17,222 1084586375
World cities (data only) Belo Horizonte Belo Horizonte -19.9281 -43.9419 -19.9281, -43.9419 Brazil BR BRA Minas Gerais 5,159,000 1076967355
World cities (data only) Bengbu Bengbu 32.9354 117.3531 32.9354, 117.3531 China CN CHN Anhui 3,164,467 1156440668
World cities (data only) Benin City Benin City 6.3176 5.6145 6.3176, 5.6145 Nigeria NG NGA Edo 1,147,188 1566080151
World cities (data only) Benxi Benxi 41.292 123.761 41.292, 123.761 China CN CHN Liaoning 1,709,538 1156097909
World cities (data only) Berlin Berlin 52.5167 13.3833 52.5167, 13.3833 Germany DE DEU Berlin 3,664,088 1276451290
World cities (data only) Bern Bern 46.948 7.4474 46.948, 7.4474 Switzerland CH CHE Bern 133,798 1756374318
World cities (data only) Bezwāda Bezwada 16.5167 80.6167 16.5167, 80.6167 India IN IND Andhra Pradesh 1,048,240 1356807575
World cities (data only) Bhilai Bhilai 21.2186 81.4314 21.2186, 81.4314 India IN IND Chhattīsgarh 1,097,000 1356071083
World cities (data only) Bhopāl Bhopal 23.25 77.4167 23.25, 77.4167 India IN IND Madhya Pradesh 1,798,218 1356734039
World cities (data only) Bhubaneshwar Bhubaneshwar 20.2644 85.8281 20.2644, 85.8281 India IN IND Odisha 837,737 1356140143
World cities (data only) Biên Hòa Bien Hoa 10.9508 106.8221 10.9508, 106.8221 Vietnam VN VNM Đồng Nai 1,104,000 1704863046
World cities (data only) Bijie Bijie 27.3019 105.2863 27.3019, 105.2863 China CN CHN Guizhou 6,686,100 1156018927
World cities (data only) Bilāspur Bilaspur 22.15 82.0167 22.15, 82.0167 India IN IND Chhattīsgarh 1,625,502 1356820491
World cities (data only) Binzhou Binzhou 37.3806 118.0125 37.3806, 118.0125 China CN CHN Shandong 3,748,474 1156564962
World cities (data only) Birmingham Birmingham 52.48 -1.9025 52.48, -1.9025 United Kingdom GB GBR Birmingham 1,137,100 1826423213

More...