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
Urbanization refers to the population shift from rural to urban areas, the corresponding decrease in the proportion of people living in rural areas, and the ways in which societies adapt to this change. Wikipedia
CREATE TABLE capital_city_population (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"capital_city_population_un_urbanization_prospects_2018" BIGINT -- Capital City Population (UN Urbanization Prospects, 2018)
);CREATE TABLE city_populations_to_2035 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"city_population_un_urbanization_prospects_2018" DOUBLE -- City Population (UN Urbanization Prospects, 2018),
"projected_city_population_un_urbanization_prospects_2018" DOUBLE -- Projected City Population (UN Urbanization Prospects, 2018)
);CREATE TABLE employment_in_agri_vs_urban_pop (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"share_employed_agri" DOUBLE,
"urban_population_of_total_population" DOUBLE -- Urban Population (% Of Total Population),
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"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 -- Historical Urban Fraction Estimate Per Region (HYDE 3.1 (2010))
);CREATE TABLE population_in_the_largest_city (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"population_in_the_largest_city_of_urban_population" DOUBLE -- Population In The Largest City (% Of Urban Population)
);CREATE TABLE population_threshold_for_urban_area (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"minimum_population_threshold_for_urban_area_un_2018" BIGINT -- Minimum Population Threshold For Urban Area (UN; 2018)
);CREATE TABLE population_threshold_for_urban_area_1 (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"minimum_population_threshold_for_urban_area_un_2018" BIGINT -- Minimum Population Threshold For Urban Area (UN; 2018)
);CREATE TABLE share_of_population_urban (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_of_total_population" DOUBLE -- Urban Population (% Of Total Population)
);CREATE TABLE share_of_urban_population_living_in_slums (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"population_living_in_slums_of_urban_population" DOUBLE -- Population Living In Slums (% Of Urban Population)
);CREATE TABLE urban_agglomerations_1_million_percent (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"population_in_urban_agglomerations_of_more_than_1_mill_ac591a7c" DOUBLE -- Population In Urban Agglomerations Of More Than 1 Million (% Of Total Population)
);CREATE TABLE urban_and_rural_population (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population" BIGINT,
"rural_population" BIGINT
);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 -- Urban Population Long-run With 2050 Projections (OWID),
"rural_population_long_run_with_2050_projections_owid" DOUBLE -- Rural Population Long-run With 2050 Projections (OWID)
);CREATE TABLE urbanization_last_500_years (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_long_run_to_2016_owid" DOUBLE -- Urban Population (%) Long-run To 2016 (OWID)
);CREATE TABLE urbanization_vs_gdp (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_long_run_to_2016_owid" DOUBLE -- Urban Population (%) Long-run To 2016 (OWID),
"gdp_per_capita" DOUBLE,
"n_417485_annotations" VARCHAR -- 417485-annotations,
"population_historical_estimates" DOUBLE -- Population (historical Estimates),
"continent" VARCHAR
);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 -- Urban Population (%) Long-run With 2050 Projections (OWID)
);CREATE TABLE urban_share_european_commission (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"degree_of_urbanization_of_population" DOUBLE -- Degree Of Urbanization (% Of Population)
);CREATE TABLE urban_vs_rural_majority (
"entity" VARCHAR,
"code" VARCHAR,
"year" BIGINT,
"urban_population_long_run_with_2050_projections_owid" DOUBLE -- Urban Population (%) Long-run With 2050 Projections (OWID),
"rural_population_long_run_with_2050_projections_owid" DOUBLE -- Rural Population (%) Long-run With 2050 Projections (OWID)
);Anyone who has the link will be able to view this.