Global Population Trends(2016-2022)

This dataset contains almost 215 countries demographics insights (2016 to 2022)

@kaggle.alitaqi000_global_population_trends2016_2022

Table List

1 table(60.09 KB)

Global Population Trends 2016–2022

Global Population Trends 2016–2022

@kaggle.alitaqi000_global_population_trends2016_2022.global_population_trends_2016_2022

60.09 KB
1073 rows
12 columns

country Country	year Year	total_population Total Population	urban_population Urban Population	rural_population Rural Population	population_density Population Density	life_expectancy Life Expectancy	birth_rate Birth Rate	death_rate Death Rate	fertility_rate Fertility Rate	infant_mortality_rate Infant Mortality Rate	growth_rate Growth Rate
Afghanistan	2017	-	-	-	55	63.0	37.342	7.027	5.129	49.4	-
Afghanistan	2018	36,686,784	9,353,296	27,333,488	56	63.0	36.927	6.981	5.002	47.8	3.0
Afghanistan	2019	37,769,499	9,727,157	28,042,342	58	64.0	36.466	6.791	4.87	46.3	3.0
Afghanistan	2020	38,972,230	10,142,913	28,829,317	60	63.0	36.051	7.113	4.75	44.8	3.0
Afghanistan	2021	40,099,462	10,551,772	29,547,690	-	62.0	35.842	7.344	4.643	43.4	3.0
Albania	2017	-	-	-	105	79.0	10.87	8.15	1.491	8.3	-
Albania	2018	2,866,376	1,728,969	1,137,407	105	79.0	10.517	8.308	1.44	8.3	0.0
Albania	2019	2,854,191	1,747,593	1,106,598	104	79.0	10.343	8.48	1.414	8.4	0.0
Albania	2020	2,837,849	1,762,645	1,075,204	104	77.0	10.285	10.785	1.4	8.4	-1.0
Albania	2021	2,811,666	1,770,478	1,041,188	-	76.0	10.24	11.325	1.39	8.4	-1.0


CREATE TABLE global_population_trends_2016_2022 (
  "country" VARCHAR,
  "year" BIGINT,
  "total_population" VARCHAR,
  "urban_population" VARCHAR,
  "rural_population" VARCHAR,
  "population_density" VARCHAR,
  "life_expectancy" VARCHAR,
  "birth_rate" DOUBLE,
  "death_rate" DOUBLE,
  "fertility_rate" VARCHAR,
  "infant_mortality_rate" VARCHAR,
  "growth_rate" VARCHAR
);