Name: Population
Creator: Our World In Data
License: https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing

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.07 MB
59177 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

347.77 KB
59297 rows
3 columns


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

Population (various Sources)

@owid.population.owid_population_2

612.22 KB
78265 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.01 MB
78318 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

347.28 KB
59297 rows
3 columns


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

Population

@owid.population.owid_population_5

867.14 KB
78594 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

871.34 KB
78889 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

463.55 KB
76672 rows
3 columns


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

Population Growth Rate

@owid.population.owid_population_growth_rate

306.86 KB
50873 rows
3 columns


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

Population

@owid.population.owid_population_original_1

1.01 MB
78318 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

867.14 KB
78594 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

491.34 KB
69513 rows
4 columns


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

Population

@owid.population.owid_population_original_4

871.34 KB
78889 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

485.3 KB
19712 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
);