Visualization by Colin Augustine
A Flourish visualization comparing the number of international airports to population size across countries. This analysis reveals which regions are over-served or under-served in terms of air travel infrastructure relative to their population.
| Platform | Flourish |
|---|---|
| Chart Type | Geographic Map / Scatter Plot |
| Public URL | View on Flourish |
| Airport Data | OpenFlights Database (airport_connectivity.csv) |
|---|---|
| Population Data | World Bank / UN Population Estimates |
| Processing | Merged airport counts with population by country using Vlook in Excel and appropriate calculations were done. |
| Metric | Description |
|---|---|
| Airport Count | Number of international airports per country |
| Population | Country population (latest available) |
| Ratio | Airports per million inhabitants |
| Created by | Colin Augustine |
|---|---|
| Course | Data Visualization, SUPSI |
| Date | December 2025 |