📊 Dashboard
Bane Business Analytics Platform
Analyzing 51 global cities across 6 continents — population, geography, and capital classification insights.
Total Cities
51
Across 6 continents
🏙️
Countries
Nations represented
🌍
Largest City
Tokyo
37.7M residents
🗼
Megacities (>10M)
Urban superclusters
🌆
🏆 Top 10 Cities by Population
🌐 Cities by Continent
💡 Key Insights
🏙️
Asian Dominance
Asia hosts 22 of the 51 tracked cities, the most of any continent, reflecting rapid regional urbanization.
22 / 51 cities
📈
Megacity Count
13 cities exceed 10M residents. 8 of those are in Asia, driven by China, India, Japan, and Bangladesh.
13 megacities
🌎
Americas Urban Giants
São Paulo and Mexico City both exceed 21M residents, making Latin America home to two of the world's top 3 cities.
>21M each
🏛️
Capital Cities
33 of 51 cities are national or regional capitals, confirming that political centrality correlates strongly with urban density.
65% are capitals
🌍
Africa's Rising Cities
Cairo (20M), Lagos (14.9M), and Kinshasa (14.3M) signal Africa's rapid urban growth trajectory.
3 top-15 global cities
📊
Average City Population
The mean population across all 51 cities is approximately 11.4 million, well above typical urban centers.
~11.4M avg
Structure and sample data for the embedded world_cities dataset.
🗂️ Columns 12
ColumnType
cityTEXT
city_asciiTEXT
latREAL
lngREAL
countryTEXT
iso2TEXT
iso3TEXT
admin_nameTEXT
capitalTEXT
population KEYINTEGER
continentTEXT
id PKINTEGER
📋 Sample Data first 10 rows
Select a pre-built query to explore the world_cities dataset. Results display instantly — no backend required.
Choose a query above to see results
Pre-generated executive report for the world_cities dataset.
⚠️ Demo Mode: Report download is disabled. This is a read-only preview.

World Cities Analytics Report

📅 April 2025 🗄️ Dataset: world_cities 🏙️ 51 Cities · 35 Countries 🌍 6 Continents

Overview

This report analyzes a curated dataset of 51 major world cities spanning all six inhabited continents and 35 countries. The dataset captures the world's most significant urban centers by population, ranging from Asia's densely packed megacities to Europe's historically established capitals. Each record includes geographic coordinates, administrative classification, national identity, and population estimates, enabling a multi-dimensional view of global urbanization.

Key Findings

Tokyo remains the world's most populous city with approximately 37.7 million residents — nearly double the population of the second-ranked city. Asia disproportionately dominates the dataset, contributing 22 of the 51 cities tracked and hosting 8 of the 13 global megacities (cities exceeding 10 million residents). Latin America contributes two of the top three largest cities globally: São Paulo (21.7M) and Mexico City (21.8M).

RankCityCountryPopulationContinent
1TokyoJapan37,732,000Asia
2DelhiIndia32,226,000Asia
3ShanghaiChina28,517,000Asia
4DhakaBangladesh23,210,000Asia
5São PauloBrazil21,650,000South America

Business Implications

The concentration of population in Asian megacities has direct implications for global commerce, supply chain planning, and market entry strategy. Companies seeking scale should prioritize Southeast and South Asian markets given their extraordinary urban population density. Africa's three top-15 cities (Cairo, Lagos, Kinshasa) signal an accelerating urbanization wave that represents a significant long-term growth opportunity for consumer-facing industries. Europe's relatively smaller cities in this dataset (~3–12M) suggest a more dispersed urban structure, favouring regional rather than city-centric strategies.

Continental Distribution

ContinentCity CountLargest CityLargest Population
Asia22Tokyo37,732,000
Africa8Cairo20,076,000
Europe10Moscow12,506,000
North America4Mexico City21,804,000
South America5São Paulo21,650,000
Oceania3Sydney5,312,000

Conclusion

The world_cities dataset provides a clear picture of a world whose urban gravity is shifting eastward and southward. Asia and Africa are home to the fastest-growing and most populous urban clusters, while established Western cities maintain influence through economic output and institutional stability. For strategic planning, the data underscores the importance of prioritising Asia-Pacific and African markets in any globally-oriented growth roadmap.