Database
API Playground
Get Started
Issues
ContributorsConnect to API
The Database Hub is home for developers who want to clone, connect, and share databases and build apps together. By connecting to a database, you can easily consume its data using an API (GraphQL or REST) or via SDK.
Connect to API
Dataset with all the cities of the world. Information includes the name, country, population, Latitude, Longitude, City ID, Admin Code, and inform if the City is a capital.
| name | country | isCapital | population | location | cityId | adminCode | altName |
|---|---|---|---|---|---|---|---|
Arab Republic of Egypt | Egypt | (undefined) | 98423595 | (27, 30) | 357994 | 00 | (undefined) |
Italian Republic | Italy | (undefined) | 60431283 | (42.83333, 12.83333) | 3175395 | 00 | (undefined) |
England | United Kingdom | (undefined) | 55268067 | (52.16045, -0.70312) | 6269131 | ENG | (undefined) |
São Paulo | Brazil | (undefined) | 41252160 | (-22, -49) | 3448433 | 27 | (undefined) |
Canada | Canada | (undefined) | 37058856 | (60.10867, -113.64258) | 6251999 | 00 | (undefined) |
Banan Qu | China | (undefined) | 29914000 | (29.37079, 106.73456) | 1909729 | 33 | (undefined) |
Kinki Chihō | Japan | (undefined) | 22757897 | (35, 135.5) | 1859449 | 00 | (undefined) |
Shanghai | China | (undefined) | 22315474 | (31.22222, 121.45806) | 1796236 | 23 | |
Madagascar | Madagascar | (undefined) | 22005222 | (-20.03085, 45.695) | 12036340 | 00 | (undefined) |
Southeast | Vietnam | (undefined) | 20070000 | (10.75053, 106.7505) | 11497301 | 00 | (undefined) |
Greater Cairo Area | Egypt | (undefined) | 20000000 | (30.01745, 31.21808) | 12070073 | (undefined) | |
New York | United States | (undefined) | 19274244 | (43.00035, -75.4999) | 5128638 | NY | (undefined) |
Red River Delta | Vietnam | (undefined) | 19000000 | (21.03498, 105.8455) | 11497250 | 00 | (undefined) |
Western Region | Vietnam | (undefined) | 17080000 | (10.01211, 105.83224) | 11497302 | 00 | (undefined) |
Rio de Janeiro | Brazil | (undefined) | 15993583 | (-22.25, -42.5) | 3451189 | 21 | (undefined) |
Somalia | Somalia | (undefined) | 15008154 | (6, 48) | 51537 | 00 | (undefined) |
Istanbul | Turkey | (undefined) | 14804116 | (41.01384, 28.94966) | 745044 | 34 | |
İstanbul | Turkey | (undefined) | 14160467 | (41.03508, 28.98331) | 745042 | 34 | (undefined) |
Kyūshū Chihō | Japan | (undefined) | 13231995 | (32.33546, 130.85082) | 1857891 | 00 | (undefined) |
Kyushu | Japan | (undefined) | 13231995 | (32.42944, 130.99099) | 1857892 | 21 | (undefined) |
© 2025 Back4App, Inc.