About this Dataset

World Population Prospects

World Population Prospects 2024 is the 28th edition of the official estimates and projections of the global population that have been published by the United Nations since 1951. The estimates are based on all available sources of data on population size and levels of fertility, mortality and international migration for 237 countries or areas. More details at https://population.un.org/wpp/Publications/.

Tables

World Population Prospects

@owid.un_wpp.owid_births_2

3.49 MB
957,293 rows
7 columns


CREATE TABLE owid_births_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "births" FLOAT,
  "birth_rate" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_deaths_2

11.82 MB
3,981,874 rows
7 columns


CREATE TABLE owid_deaths_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "deaths" FLOAT,
  "death_rate" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_demographic

4.34 MB
2,450,810 rows
7 columns


CREATE TABLE owid_demographic (
  "location" VARCHAR,
  "year" INTEGER,
  "metric" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "value" FLOAT
);

Dependency Ratio 2

@owid.un_wpp.owid_dependency_ratio_2

4.17 MB
880,128 rows
6 columns


CREATE TABLE owid_dependency_ratio_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "dependency_ratio" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_fertility

13.13 MB
4,239,306 rows
7 columns


CREATE TABLE owid_fertility (
  "location" VARCHAR,
  "year" INTEGER,
  "metric" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "value" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_fertility_rate_2

2.98 MB
957,293 rows
6 columns


CREATE TABLE owid_fertility_rate_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "fertility_rate" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_fertility_single

740.46 kB
143,360 rows
4 columns


CREATE TABLE owid_fertility_single (
  "country" VARCHAR,
  "age" INTEGER,
  "year_as_dimension" INTEGER,
  "fertility_rate" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_growth_rate_2

170.05 kB
77,165 rows
6 columns


CREATE TABLE owid_growth_rate_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "growth_rate" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_life_expectancy_2

1.41 MB
575,322 rows
6 columns


CREATE TABLE owid_life_expectancy_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" INTEGER,
  "variant" VARCHAR,
  "life_expectancy" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_mean_age_childbearing

165.81 kB
77,165 rows
6 columns


CREATE TABLE owid_mean_age_childbearing (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "mean_age_childbearing" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_median_age_2

318.83 kB
77,165 rows
6 columns


CREATE TABLE owid_median_age_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "median_age" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_migration_1

527.27 kB
440,410 rows
7 columns


CREATE TABLE owid_migration_1 (
  "location" VARCHAR,
  "year" INTEGER,
  "metric" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "value" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_migration_3

469.7 kB
77,165 rows
7 columns


CREATE TABLE owid_migration_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "net_migration" FLOAT,
  "net_migration_rate" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_mortality

24.5 MB
11,665,512 rows
7 columns


CREATE TABLE owid_mortality (
  "location" VARCHAR,
  "year" INTEGER,
  "metric" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "value" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_mortality_rate_2

523.36 kB
154,330 rows
6 columns


CREATE TABLE owid_mortality_rate_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "mortality_rate" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_natural_change_rate_2

320.75 kB
77,165 rows
6 columns


CREATE TABLE owid_natural_change_rate_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "natural_change_rate" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_population_1

83.9 MB
24,152,847 rows
7 columns


CREATE TABLE owid_population_1 (
  "location" VARCHAR,
  "year" INTEGER,
  "metric" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "value" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_population_3

84.86 MB
12,321,792 rows
8 columns


CREATE TABLE owid_population_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "population" BIGINT,
  "population_change" INTEGER,
  "population_density" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_population_granular

130.74 MB
39,815,008 rows
7 columns


CREATE TABLE owid_population_granular (
  "location" VARCHAR,
  "year" INTEGER,
  "metric" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "value" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_sex_ratio_2

5.47 MB
1,369,088 rows
6 columns


CREATE TABLE owid_sex_ratio_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "sex_ratio" FLOAT
);

World Population Prospects

@owid.un_wpp.owid_un_wpp

129.13 MB
43,649,697 rows
7 columns


CREATE TABLE owid_un_wpp (
  "location" VARCHAR,
  "year" INTEGER,
  "metric" VARCHAR,
  "sex" VARCHAR,
  "age" VARCHAR,
  "variant" VARCHAR,
  "value" FLOAT
);