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.
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 |