World Population 1960-2018
Population each country / region from 1960 to 2018
@kaggle.imdevskp_world_population_19602018
Population each country / region from 1960 to 2018
@kaggle.imdevskp_world_population_19602018
CREATE TABLE population_above_age_65_percentage_long (
"country_name" VARCHAR,
"year" BIGINT,
"count" BIGINT
);
CREATE TABLE population_below_age_14_percentage_long (
"country_name" VARCHAR,
"year" BIGINT,
"count" BIGINT
);
CREATE TABLE population_density_long (
"country_name" VARCHAR,
"year" BIGINT,
"count" BIGINT
);
CREATE TABLE population_female_percentage_long (
"country_name" VARCHAR,
"year" BIGINT,
"count" BIGINT
);
CREATE TABLE population_total_long (
"country_name" VARCHAR,
"year" BIGINT,
"count" BIGINT
);
CREATE TABLE pop_worldometer_data (
"country_or_dependency" VARCHAR -- Country (or Dependency),
"population_2020" BIGINT -- Population (2020),
"yearly_change" DOUBLE -- Yearly Change %,
"net_change" BIGINT,
"density_p_km" DOUBLE -- Density (P/Km²),
"land_area_km" DOUBLE -- Land Area (Km²),
"migrants_net" DOUBLE -- Migrants (net),
"fert_rate" DOUBLE -- Fert. Rate,
"med_age" DOUBLE -- Med. Age,
"urban_pop" DOUBLE -- Urban Pop %,
"world_share" DOUBLE -- World Share %
);
Anyone who has the link will be able to view this.