Baselight
Sign In

Population

@owid.population

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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

Population

@owid.population.owid_population_5
  • 867.14 KB
  • 78594 rows
  • 5 columns
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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
Loading...
 

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