World Urbanization Prospects Dataset - Urban Agglomerations By Size Class
@owid.urban_agglomerations_size_class
@owid.urban_agglomerations_size_class
CREATE TABLE owid_urban_agglomerations_size_class (
"country" VARCHAR,
"year" INTEGER,
"n__1_to_5_million_number_of_agglomerations_estimates" FLOAT,
"n__1_to_5_million_percentage_of_urban_population_estimates" FLOAT,
"n__1_to_5_million_population_estimates" FLOAT,
"n__10_million_or_more_number_of_agglomerations_estimates" FLOAT,
"n__10_million_or_more_percentage_of_urban_population_estimates" FLOAT,
"n__10_million_or_more_population_estimates" FLOAT,
"n__300_000_to_500_000_number_of_agglomerations_estimates" FLOAT,
"n__300_000_to_500_000_percentage_of_urban_population_estimates" FLOAT,
"n__300_000_to_500_000_population_estimates" FLOAT,
"n__5_to_10_million_number_of_agglomerations_estimates" FLOAT,
"n__5_to_10_million_percentage_of_urban_population_estimates" FLOAT,
"n__5_to_10_million_population_estimates" FLOAT,
"n__500_000_to_1_million_number_of_agglomerations_estimates" FLOAT,
"n__500_000_to_1_million_percentage_of_urban_population_74f1e11c" FLOAT,
"n__500_000_to_1_million_population_estimates" FLOAT,
"fewer_than_300_000_percentage_of_urban_population_estimates" FLOAT,
"fewer_than_300_000_population_estimates" FLOAT,
"n__1_to_5_million_number_of_agglomerations_projections" FLOAT,
"n__1_to_5_million_percentage_of_urban_population_projections" FLOAT,
"n__1_to_5_million_population_projections" FLOAT,
"n__10_million_or_more_number_of_agglomerations_projections" FLOAT,
"n__10_million_or_more_percentage_of_urban_population_p_c6120ff0" FLOAT,
"n__10_million_or_more_population_projections" FLOAT,
"n__300_000_to_500_000_number_of_agglomerations_projections" FLOAT,
"n__300_000_to_500_000_percentage_of_urban_population_p_5e354191" FLOAT,
"n__300_000_to_500_000_population_projections" FLOAT,
"n__5_to_10_million_number_of_agglomerations_projections" FLOAT,
"n__5_to_10_million_percentage_of_urban_population_projections" FLOAT,
"n__5_to_10_million_population_projections" FLOAT,
"n__500_000_to_1_million_number_of_agglomerations_projections" FLOAT,
"n__500_000_to_1_million_percentage_of_urban_population_ca1ab43c" FLOAT,
"n__500_000_to_1_million_population_projections" FLOAT,
"fewer_than_300_000_percentage_of_urban_population_projections" FLOAT,
"fewer_than_300_000_population_projections" FLOAT
);
Anyone who has the link will be able to view this.