Name: Population
Creator: Our World In Data
License: https://creativecommons.org/publicdomain/

About this Dataset

Population

Our World in Data builds and maintains a long-run dataset on population by country, region, and for the world, based on various sources.

You can find more information on these sources and how our time series is constructed on this page: https://ourworldindata.org/population-sources

Tables

Land, Inputs And Sustainability: Land Use

@owid.population.owid_historical

1.28 MB
58,824 rows
6 columns


CREATE TABLE owid_historical (
  "country" VARCHAR,
  "year" INTEGER,
  "population_historical" BIGINT,
  "world_pop_share_historical" FLOAT,
  "population_density_historical" FLOAT,
  "growth_rate_historical" FLOAT
);

Total Population V6

@owid.population.owid_population_1

356.12 kB
59,297 rows
3 columns


CREATE TABLE owid_population_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "population" UINTEGER
);

Population (various Sources)

@owid.population.owid_population_2

626.91 kB
78,265 rows
5 columns


CREATE TABLE owid_population_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "population" BIGINT,
  "world_pop_share" FLOAT,
  "source" VARCHAR
);

Population

@owid.population.owid_population_3

1.06 MB
78,318 rows
5 columns


CREATE TABLE owid_population_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "population" BIGINT,
  "world_pop_share" FLOAT,
  "source" VARCHAR
);

Population

@owid.population.owid_population_4

355.61 kB
59,297 rows
3 columns


CREATE TABLE owid_population_4 (
  "country" VARCHAR,
  "year" INTEGER,
  "population" UINTEGER
);

Population

@owid.population.owid_population_5

887.96 kB
78,594 rows
5 columns


CREATE TABLE owid_population_5 (
  "country" VARCHAR,
  "year" INTEGER,
  "population" UBIGINT,
  "source" VARCHAR,
  "world_pop_share" FLOAT
);

Population

@owid.population.owid_population_6

1.06 MB
78,536 rows
5 columns


CREATE TABLE owid_population_6 (
  "country" VARCHAR,
  "year" INTEGER,
  "population" BIGINT,
  "source" VARCHAR,
  "world_pop_share" FLOAT
);

Land, Inputs And Sustainability: Land Use

@owid.population.owid_population_density

476.16 kB
76,576 rows
3 columns


CREATE TABLE owid_population_density (
  "country" VARCHAR,
  "year" INTEGER,
  "population_density" FLOAT
);

Population Growth Rate

@owid.population.owid_population_growth_rate

312.76 kB
50,636 rows
3 columns


CREATE TABLE owid_population_growth_rate (
  "country" VARCHAR,
  "year" INTEGER,
  "growth_rate" FLOAT
);

Population

@owid.population.owid_population_original_1

1.06 MB
78,318 rows
5 columns


CREATE TABLE owid_population_original_1 (
  "country" VARCHAR,
  "year" INTEGER,
  "population" BIGINT,
  "world_pop_share" FLOAT,
  "source" VARCHAR
);

Population

@owid.population.owid_population_original_2

887.96 kB
78,594 rows
5 columns


CREATE TABLE owid_population_original_2 (
  "country" VARCHAR,
  "year" INTEGER,
  "population" UBIGINT,
  "source" VARCHAR,
  "world_pop_share" FLOAT
);

Population Original 3

@owid.population.owid_population_original_3

503.13 kB
69,513 rows
4 columns


CREATE TABLE owid_population_original_3 (
  "country" VARCHAR,
  "year" INTEGER,
  "population" UBIGINT,
  "source" VARCHAR
);

Population

@owid.population.owid_population_original_4

1.06 MB
78,536 rows
5 columns


CREATE TABLE owid_population_original_4 (
  "country" VARCHAR,
  "year" INTEGER,
  "population" BIGINT,
  "source" VARCHAR,
  "world_pop_share" FLOAT
);

Land, Inputs And Sustainability: Land Use

@owid.population.owid_projections

496.71 kB
19,712 rows
6 columns


CREATE TABLE owid_projections (
  "country" VARCHAR,
  "year" INTEGER,
  "population_projection" BIGINT,
  "world_pop_share_projection" FLOAT,
  "population_density_projection" FLOAT,
  "growth_rate_projection" FLOAT
);