Dataset: World Population Prospects

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.33 MB
957293 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.28 MB
3981874 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.14 MB
2450810 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

3.98 MB
880128 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

12.52 MB
4239306 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.84 MB
957293 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

723.11 KB
143360 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

166.06 KB
77165 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.34 MB
575322 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

161.92 KB
77165 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

311.36 KB
77165 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

514.92 KB
440410 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

458.69 KB
77165 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

23.36 MB
11665512 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

511.09 KB
154330 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

313.24 KB
77165 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

80.01 MB
24152847 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

80.93 MB
12321792 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

124.68 MB
39815008 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.22 MB
1369088 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

123.15 MB
43649697 rows
7 columns


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