Urbanization
To all those who said I couldn't make jokes about blind people...watch me.
@kaggle.programmerrdai_urbanization
To all those who said I couldn't make jokes about blind people...watch me.
@kaggle.programmerrdai_urbanization
CREATE TABLE capital_city_population (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"capital_city_population_un_urbanization_prospects_2018" BIGINT
);
CREATE TABLE city_populations_to_2035 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"city_population_un_urbanization_prospects_2018" DOUBLE,
"projected_city_population_un_urbanization_prospects_2018" DOUBLE
);
CREATE TABLE employment_in_agri_vs_urban_pop (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_employed_agri" DOUBLE,
"urban_population_of_total_population" DOUBLE,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
CREATE TABLE long_term_urban_population_region (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"historical_urban_fraction_estimate_per_region_hyde_3_1_2010" DOUBLE
);
CREATE TABLE population_in_the_largest_city (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"population_in_the_largest_city_of_urban_population" DOUBLE
);
CREATE TABLE population_threshold_for_urban_area_1 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"minimum_population_threshold_for_urban_area_un_2018" BIGINT
);
CREATE TABLE population_threshold_for_urban_area (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"minimum_population_threshold_for_urban_area_un_2018" BIGINT
);
CREATE TABLE share_of_population_urban (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_of_total_population" DOUBLE
);
CREATE TABLE share_of_urban_population_living_in_slums (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"population_living_in_slums_of_urban_population" DOUBLE
);
CREATE TABLE urban_agglomerations_1_million_percent (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"population_in_urban_agglomerations_of_more_than_1_mill_ac591a7c" DOUBLE
);
CREATE TABLE urban_and_rural_population_1 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population" BIGINT,
"rural_population" BIGINT
);
CREATE TABLE urban_and_rural_population_2050 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_long_run_with_2050_projections_owid" DOUBLE,
"rural_population_long_run_with_2050_projections_owid" DOUBLE
);
CREATE TABLE urban_and_rural_population (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population" BIGINT,
"rural_population" BIGINT
);
CREATE TABLE urban_pop_in_out_of_slums (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_living_in_slums" BIGINT,
"urban_population_not_living_in_slums" BIGINT
);
CREATE TABLE urban_population_share_2050 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_long_run_with_2050_projections_owid" DOUBLE
);
CREATE TABLE urban_share_european_commission (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"degree_of_urbanization_of_population" DOUBLE
);
CREATE TABLE urban_vs_rural_majority (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_long_run_with_2050_projections_owid" DOUBLE,
"rural_population_long_run_with_2050_projections_owid" DOUBLE
);
CREATE TABLE urbanization_last_500_years (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_long_run_to_2016_owid" DOUBLE
);
CREATE TABLE urbanization_vs_gdp (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_long_run_to_2016_owid" DOUBLE,
"gdp_per_capita" DOUBLE,
"n_417485_annotations" VARCHAR,
"population_historical_estimates" DOUBLE,
"continent" VARCHAR
);
Anyone who has the link will be able to view this.