World Population Data

World Population Dataset: 1970 to 2023

@kaggle.sazidthe1_world_population_data

Table List

1 table(35.22 KB)

World Population Data

@kaggle.sazidthe1_world_population_data.world_population_data

35.22 KB
234 rows
17 columns

rank Rank	cca3 Cca3	country Country	continent Continent	n_2023_population 2023 Population	n_2022_population 2022 Population	n_2020_population 2020 Population	n_2015_population 2015 Population	n_2010_population 2010 Population	n_2000_population 2000 Population	n_1990_population 1990 Population	n_1980_population 1980 Population	n_1970_population 1970 Population	area_km Area (km²)	density_km Density (km²)	growth_rate Growth Rate	world_percentage World Percentage
1	IND	India	Asia	1428627663	1417173173	1396387127	1322866505	1240613620	1059633675	870452165	696828385	557501301	3287590	481	0.81%	17.85%
2	CHN	China	Asia	1425671352	1425887337	1424929781	1393715448	1348191368	1264099069	1153704252	982372466	822534450	9706961	151	-0.02%	17.81%
3	USA	United States	North America	339996563	338289857	335942003	324607776	311182845	282398554	248083732	223140018	200328340	9372610	37	0.50%	4.25%
4	IDN	Indonesia	Asia	277534122	275501339	271857970	259091970	244016173	214072421	182159874	148177096	115228394	1904569	148	0.74%	3.47%
5	PAK	Pakistan	Asia	240485658	235824862	227196741	210969298	194454498	154369924	115414069	80624057	59290872	881912	312	1.98%	3.00%
6	NGA	Nigeria	Africa	223804632	218541212	208327405	183995785	160952853	122851984	95214257	72951439	55569264	923768	246	2.41%	2.80%
7	BRA	Brazil	South America	216422446	215313498	213196304	205188205	196353492	175873720	150706446	122288383	96369875	8515767	26	0.52%	2.70%
8	BGD	Bangladesh	Asia	172954319	171186372	167420951	157830000	148391139	129193327	107147651	83929765	67541860	147570	1329	1.03%	2.16%
9	RUS	Russia	Europe	144444359	144713314	145617329	144668389	143242599	146844839	148005704	138257420	130093010	17098242	9	-0.19%	1.80%
10	MEX	Mexico	North America	128455567	127504125	125998302	120149897	112532401	97873442	81720428	67705186	50289306	1964375	66	0.75%	1.60%


CREATE TABLE world_population_data (
  "rank" BIGINT,
  "cca3" VARCHAR,
  "country" VARCHAR,
  "continent" VARCHAR,
  "n_2023_population" BIGINT,
  "n_2022_population" BIGINT,
  "n_2020_population" BIGINT,
  "n_2015_population" BIGINT,
  "n_2010_population" BIGINT,
  "n_2000_population" BIGINT,
  "n_1990_population" BIGINT,
  "n_1980_population" BIGINT,
  "n_1970_population" BIGINT,
  "area_km" DOUBLE,
  "density_km" BIGINT,
  "growth_rate" VARCHAR,
  "world_percentage" VARCHAR
);