Global Human Settlement Layer Dataset
@owid.ghsl_degree_of_urbanisation
@owid.ghsl_degree_of_urbanisation
CREATE TABLE owid_ghsl_degree_of_urbanisation_1 (
"country" VARCHAR,
"year" INTEGER,
"average_area_km2_estimates" FLOAT,
"degurba_l1_population_city_estimates" FLOAT,
"degurba_l1_population_rural_area_estimates" FLOAT,
"degurba_l1_population_town_and_suburbs_estimates" FLOAT,
"degurba_l1_units_city_estimates" FLOAT,
"degurba_l1_units_rural_area_estimates" FLOAT,
"degurba_l1_units_town_and_suburbs_estimates" FLOAT,
"degurba_l2_population_city_estimates" FLOAT,
"degurba_l2_population_dense_town_estimates" FLOAT,
"degurba_l2_population_mostly_uninhabited_area_estimates" FLOAT,
"degurba_l2_population_rural_dispersed_area_estimates" FLOAT,
"degurba_l2_population_semi_dense_town_estimates" FLOAT,
"degurba_l2_population_suburbs_or_peri_urban_area_estimates" FLOAT,
"degurba_l2_population_village_estimates" FLOAT,
"degurba_l2_units_city_estimates" FLOAT,
"degurba_l2_units_dense_town_estimates" FLOAT,
"degurba_l2_units_mostly_uninhabited_area_estimates" FLOAT,
"degurba_l2_units_rural_dispersed_area_estimates" FLOAT,
"degurba_l2_units_semi_dense_town_estimates" FLOAT,
"degurba_l2_units_suburbs_or_peri_urban_area_estimates" FLOAT,
"degurba_l2_units_village_estimates" FLOAT,
"total_area_km2_estimates" FLOAT,
"total_pop_estimates" FLOAT,
"total_units_estimates" FLOAT,
"share_of_urban_population_owid_estimates" FLOAT,
"degurba_l1_population_city_share_estimates" FLOAT,
"degurba_l1_population_rural_area_share_estimates" FLOAT,
"degurba_l1_population_town_and_suburbs_share_estimates" FLOAT,
"degurba_l2_population_city_share_estimates" FLOAT,
"degurba_l2_population_dense_town_share_estimates" FLOAT,
"degurba_l2_population_mostly_uninhabited_area_share_estimates" FLOAT,
"degurba_l2_population_rural_dispersed_area_share_estimates" FLOAT,
"degurba_l2_population_semi_dense_town_share_estimates" FLOAT,
"degurba_l2_population_suburbs_or_peri_urban_area_share_d833babb" FLOAT,
"degurba_l2_population_village_share_estimates" FLOAT,
"average_area_km2_projections" FLOAT,
"degurba_l1_population_city_projections" FLOAT,
"degurba_l1_population_rural_area_projections" FLOAT,
"degurba_l1_population_town_and_suburbs_projections" FLOAT,
"degurba_l1_units_city_projections" FLOAT,
"degurba_l1_units_rural_area_projections" FLOAT,
"degurba_l1_units_town_and_suburbs_projections" FLOAT,
"degurba_l2_population_city_projections" FLOAT,
"degurba_l2_population_dense_town_projections" FLOAT,
"degurba_l2_population_mostly_uninhabited_area_projections" FLOAT,
"degurba_l2_population_rural_dispersed_area_projections" FLOAT,
"degurba_l2_population_semi_dense_town_projections" FLOAT,
"degurba_l2_population_suburbs_or_peri_urban_area_projections" FLOAT,
"degurba_l2_population_village_projections" FLOAT,
"degurba_l2_units_city_projections" FLOAT,
"degurba_l2_units_dense_town_projections" FLOAT,
"degurba_l2_units_mostly_uninhabited_area_projections" FLOAT,
"degurba_l2_units_rural_dispersed_area_projections" FLOAT,
"degurba_l2_units_semi_dense_town_projections" FLOAT,
"degurba_l2_units_suburbs_or_peri_urban_area_projections" FLOAT,
"degurba_l2_units_village_projections" FLOAT,
"total_area_km2_projections" FLOAT,
"total_pop_projections" FLOAT,
"total_units_projections" FLOAT,
"share_of_urban_population_owid_projections" FLOAT,
"degurba_l1_population_city_share_projections" FLOAT,
"degurba_l1_population_rural_area_share_projections" FLOAT,
"degurba_l1_population_town_and_suburbs_share_projections" FLOAT,
"degurba_l2_population_city_share_projections" FLOAT,
"degurba_l2_population_dense_town_share_projections" FLOAT,
"degurba_l2_population_mostly_uninhabited_area_share_projections" FLOAT,
"degurba_l2_population_rural_dispersed_area_share_projections" FLOAT,
"degurba_l2_population_semi_dense_town_share_projections" FLOAT,
"degurba_l2_population_suburbs_or_peri_urban_area_share_9915f9a5" FLOAT,
"degurba_l2_population_village_share_projections" FLOAT
);
CREATE TABLE owid_ghsl_degree_of_urbanisation_2 (
"country" VARCHAR,
"year" INTEGER,
"location_type" VARCHAR,
"attribute" VARCHAR,
"type" VARCHAR,
"value" FLOAT
);
Anyone who has the link will be able to view this.