variables
Data license: CC-BY
16 rows where datasetId = 6621 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, createdAt, updatedAt, timespan, shortUnit, display, attribution, descriptionShort, descriptionProcessing, type, dataChecksum, createdAt (date), updatedAt (date)
| id ▲ | name | unit | description | createdAt | updatedAt | code | coverage | timespan | datasetId | sourceId | shortUnit | display | columnOrder | originalMetadata | grapherConfigAdmin | shortName | catalogPath | dimensions | schemaVersion | processingLevel | processingLog | titlePublic | titleVariant | attributionShort | attribution | descriptionShort | descriptionFromProducer | descriptionKey | descriptionProcessing | licenses | license | grapherConfigETL | type | sort | dataChecksum | metadataChecksum |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 953969 | Population growth rate (smoothed) (projections) | % | Population by country and year. | 2024-07-23 10:29:45 | 2024-07-30 06:18:03 | 2024-2100 | Population 6621 | % | {
"unit": "%",
"shortUnit": "%"
} |
0 | growth_rate_smoothed_projection | grapher/demography/2024-07-15/population/projections#growth_rate_smoothed_projection | 2 | major | UN WPP (2024) | Average exponential rate of growth of the population over a given period. It is calculated as ln(P2/P1) where P1 and P2 are the populations on subsequent years. Available from 2024 to 2100, based on UN medium scenario projections. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
97580c20781abcce9f9e25884c1b1b3d | 518d0d6c81c1572dedb8de91606bf92a | |||||||||||||
| 953968 | Population growth rate (smoothed) | % | Population by country and year. | 2024-07-23 10:29:44 | 2024-07-30 06:18:02 | 1710-2100 | Population 6621 | % | {
"unit": "%",
"shortUnit": "%"
} |
0 | growth_rate_smoothed | grapher/demography/2024-07-15/population/population_growth_rate#growth_rate_smoothed | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024) | Average exponential rate of growth of the population over a given period. It is calculated as ln(P2/P1) where P1 and P2 are the populations on subsequent years. Available from 1700 to 2100, based on data and estimates from different sources. | [] |
The data is constructed by combining data from multiple sources: - 1700 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). Data before 1900 has been smoothed using a 50-year moving average to reduce noise in the data. | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
b24fc29c34bb5fe6bdb6170713d7332c | e3db3ef072152849efc604224ca0bfb4 | |||||||||||||
| 953967 | Population growth rate (smoothed) (historical) | % | Population by country and year. | 2024-07-23 10:29:41 | 2024-07-30 06:18:00 | 1710-2023 | Population 6621 | % | {
"unit": "%",
"shortUnit": "%"
} |
0 | growth_rate_smoothed_historical | grapher/demography/2024-07-15/population/historical#growth_rate_smoothed_historical | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024) | Average exponential rate of growth of the population over a given period. It is calculated as ln(P2/P1) where P1 and P2 are the populations on subsequent years. Available from 1700 to 2023, based on data and estimates from different sources. | [] |
The data is constructed by combining data from multiple sources: - 1700 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). Data before 1900 has been smoothed using a 50-year moving average to reduce noise in the data. | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
b9431e3bef5a279624e04762ab56dc38 | b4e11856da735e8fa6362390aa88059c | |||||||||||||
| 953921 | Population growth rate (projections) | % | Population by country and year. | 2024-07-18 13:58:27 | 2024-07-30 06:18:03 | 2024-2100 | Population 6621 | % | {
"unit": "%",
"shortUnit": "%"
} |
0 | growth_rate_projection | grapher/demography/2024-07-15/population/projections#growth_rate_projection | 2 | major | UN WPP (2024) | Average exponential rate of growth of the population over a given period. It is calculated as ln(P2/P1) where P1 and P2 are the populations on subsequent years. Available from 2024 to 2100, based on UN medium scenario projections. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
97580c20781abcce9f9e25884c1b1b3d | d3db22e3b31e34c43703f93786a75118 | |||||||||||||
| 953920 | Population density (projections) | people per km² | Population by country and year. | 2024-07-18 13:58:27 | 2024-07-30 06:18:03 | 2024-2100 | Population 6621 | {
"unit": "people per km\u00b2"
} |
0 | population_density_projection | grapher/demography/2024-07-15/population/projections#population_density_projection | 2 | major | UN WPP (2024) | Population per square kilometer by country, available from 10,000 BCE to 2023, based on data and estimates from different sources. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
fec64c021c7a42f87c96da45487018f6 | 41689301fdf6cc2fbfccc303379e5ed8 | ||||||||||||||
| 953919 | Population growth rate | % | Population by country and year. | 2024-07-18 13:58:26 | 2024-07-30 06:18:02 | 1710-2100 | Population 6621 | % | {
"unit": "%",
"shortUnit": "%"
} |
0 | growth_rate | grapher/demography/2024-07-15/population/population_growth_rate#growth_rate | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024) | Average exponential rate of growth of the population over a given period. It is calculated as ln(P2/P1) where P1 and P2 are the populations on subsequent years. Available from 1700 to 2100, based on data and estimates from different sources. | [] |
The data is constructed by combining data from multiple sources: - 1700 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
83d4f7f17697c8f9f9a4024a780d4794 | ad718b5f66b8b2cc45c3aae34ae40031 | |||||||||||||
| 953918 | Population growth rate (historical) | % | Population by country and year. | 2024-07-18 13:58:24 | 2024-07-30 06:18:00 | 1710-2023 | Population 6621 | % | {
"unit": "%",
"shortUnit": "%"
} |
0 | growth_rate_historical | grapher/demography/2024-07-15/population/historical#growth_rate_historical | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024) | Average exponential rate of growth of the population over a given period. It is calculated as ln(P2/P1) where P1 and P2 are the populations on subsequent years. Available from 1700 to 2023, based on data and estimates from different sources. | [] |
The data is constructed by combining data from multiple sources: - 1700 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
f0b96e02471fc7f54cc8c92cc71bee0c | ba25532a2c7b3c710a3ef567f5c3831a | |||||||||||||
| 953917 | Population density (historical) | people per km² | Population by country and year. | 2024-07-18 13:58:24 | 2024-07-30 06:18:00 | -10000-2023 | Population 6621 | {
"unit": "people per km\u00b2"
} |
0 | population_density_historical | grapher/demography/2024-07-15/population/historical#population_density_historical | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024) | Population per square kilometer by country, available from 10,000 BCE to 2023, based on data and estimates from different sources. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
cfe4e3858ce290fa4f62a4f987347b8b | 3002e370ba845a51173973e94c25bfec | ||||||||||||||
| 953906 | Population density | people per km² | Population by country and year. | 2024-07-17 14:09:21 | 2024-07-30 06:18:01 | -10000-2100 | Population 6621 | {
"unit": "people per km\u00b2"
} |
0 | population_density | grapher/demography/2024-07-15/population/population_density#population_density | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024); UN FAO (2024) | Population per square kilometer by country, available from 10,000 BCE to 2100, based on data and estimates from different sources. | [] |
We have estimated the population density by using population estimates from multiple sources and land area estimates by the Food and Agriculture Organization of the United Nations. We obtain it by dividing the population estimates by the land area estimates. The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
a68362362b36c1b0a11c6f73b838ab6a | a1a03f819ba961cab69c8e3b1eb45a19 | ||||||||||||||
| 953905 | Share of world population (projections) | % | Population by country and year. | 2024-07-17 09:27:11 | 2024-07-30 06:18:03 | 2024-2100 | Population 6621 | % | {
"unit": "%",
"shortUnit": "%"
} |
0 | world_pop_share_projection | grapher/demography/2024-07-15/population/projections#world_pop_share_projection | 2 | major | UN WPP (2024) | Share of the world's population by country, available from 10,000 BCE to 2023, based on data and estimates from different sources. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
5bb9820f60457c81dc8cf40c3628ef69 | e76738c02438b9e40e8ba56ad94a10d4 | |||||||||||||
| 953904 | Share of world population (historical) | % | Population by country and year. | 2024-07-17 09:27:10 | 2024-07-30 06:17:59 | -10000-2023 | Population 6621 | % | {
"unit": "%",
"shortUnit": "%"
} |
0 | world_pop_share_historical | grapher/demography/2024-07-15/population/historical#world_pop_share_historical | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024) | Share of the world's population by country, available from 10,000 BCE to 2023, based on data and estimates from different sources. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
03a317f7676879e12c92cad3f48f9d82 | bc040f5d0775dbe50d14c2b7817b3b4f | |||||||||||||
| 953903 | Population (historical) | people | Population by country and year. | 2024-07-17 09:27:09 | 2024-07-30 06:17:59 | -10000-2023 | Population 6621 | {
"unit": "people",
"numDecimalPlaces": 0
} |
0 | population_historical | grapher/demography/2024-07-15/population/historical#population_historical | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024) | Population by country, available from 10,000 BCE to 2023, based on data and estimates from different sources. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
int | [] |
e394e151816f570e2838f28aab58bbcc | 7849d8345b79a1863fa5746af9420b37 | ||||||||||||||
| 953902 | Population (projections) | people | Population by country and year. | 2024-07-17 09:27:09 | 2024-07-30 06:18:02 | 2024-2100 | Population 6621 | {
"unit": "people",
"numDecimalPlaces": 0
} |
0 | population_projection | grapher/demography/2024-07-15/population/projections#population_projection | 2 | major | UN WPP (2024) | Population by country, available from 10,000 BCE to 2023, based on data and estimates from different sources. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
int | [] |
6385f9a9ccc62c4481d9a0f45086e4df | 6d13744fc7bf65afbbab0e4e00724a88 | ||||||||||||||
| 953901 | Share of world population | % | Population by country and year. | 2024-07-17 09:27:09 | 2024-07-30 06:18:01 | -10000-2100 | Population 6621 | % | {
"unit": "%",
"shortUnit": "%"
} |
0 | world_pop_share | grapher/demography/2024-07-15/population/population#world_pop_share | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024) | Share of the world's population by country, available from 10,000 BCE to 2100, based on data and estimates from different sources. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
float | [] |
64e26adf197103f529aa9c8a9a9eb493 | 24e9789ddec0f89faef5b06645551478 | |||||||||||||
| 953900 | Source | 2024-07-17 09:27:08 | 2024-07-30 06:18:01 | -10000-2100 | Population 6621 | {} |
0 | source | grapher/demography/2024-07-15/population/population#source | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024) | Name of the source for a specific data point. The name includes a short name for the source and a link. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). | string | [] |
bf89cd85ed99a65d3410149168f253ff | a27b1aceaa65dbbe453587d7b5e04be2 | |||||||||||||||||
| 953899 | Population | people | Population by country and year. | 2024-07-17 09:27:08 | 2024-07-30 06:18:01 | -10000-2100 | Population 6621 | {
"unit": "people",
"numDecimalPlaces": 0
} |
0 | population | grapher/demography/2024-07-15/population/population#population | 2 | major | HYDE (2023); Gapminder (2022); UN WPP (2024) | Population by country, available from 10,000 BCE to 2100, based on data and estimates from different sources. | [] |
The population data is constructed by combining data from multiple sources: - 10,000 BCE - 1799: Historical estimates by HYDE (v3.3). - 1800 - 1949: Historical estimates by Gapminder (v7). - 1950-2023: Population records by the UN World Population Prospects (2024 revision). - 2024-2100: Projections based on Medium variant by the UN World Population Prospects (2024 revision). | [
{
"url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
"name": "Creative Commons BY 4.0"
}
] |
int | [] |
cf29ca7ed8251750baf1902f8b6e7c88 | 678f5ca30b4119c10ba995ac0918baf0 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "variables" (
"id" INTEGER PRIMARY KEY AUTOINCREMENT,
"name" VARCHAR(750) NULL ,
"unit" VARCHAR(255) NOT NULL ,
"description" TEXT NULL ,
"createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP ,
"updatedAt" DATETIME NULL ,
"code" VARCHAR(255) NULL ,
"coverage" VARCHAR(255) NOT NULL ,
"timespan" VARCHAR(255) NOT NULL ,
"datasetId" INTEGER NOT NULL ,
"sourceId" INTEGER NULL ,
"shortUnit" VARCHAR(255) NULL ,
"display" TEXT NOT NULL ,
"columnOrder" INTEGER NOT NULL DEFAULT '0' ,
"originalMetadata" TEXT NULL ,
"grapherConfigAdmin" TEXT NULL ,
"shortName" VARCHAR(255) NULL ,
"catalogPath" VARCHAR(767) NULL ,
"dimensions" TEXT NULL ,
"schemaVersion" INTEGER NOT NULL DEFAULT '1' ,
"processingLevel" VARCHAR(30) NULL ,
"processingLog" TEXT NULL ,
"titlePublic" VARCHAR(512) NULL ,
"titleVariant" VARCHAR(255) NULL ,
"attributionShort" VARCHAR(512) NULL ,
"attribution" TEXT NULL ,
"descriptionShort" TEXT NULL ,
"descriptionFromProducer" TEXT NULL ,
"descriptionKey" TEXT NULL ,
"descriptionProcessing" TEXT NULL ,
"licenses" TEXT NULL ,
"license" TEXT NULL ,
"grapherConfigETL" TEXT NULL ,
"type" TEXT NULL ,
"sort" TEXT NULL ,
"dataChecksum" VARCHAR(64) NULL ,
"metadataChecksum" VARCHAR(64) NULL,
FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT,
FOREIGN KEY("sourceId") REFERENCES "sources" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT
);
CREATE UNIQUE INDEX "idx_catalogPath" ON "variables" ("catalogPath");
CREATE UNIQUE INDEX "unique_short_name_per_dataset" ON "variables" ("shortName", "datasetId");
CREATE UNIQUE INDEX "variables_code_fk_dst_id_7bde8c2a_uniq" ON "variables" ("code", "datasetId");
CREATE INDEX "variables_datasetId_50a98bfd_fk_datasets_id" ON "variables" ("datasetId");
CREATE UNIQUE INDEX "variables_name_fk_dst_id_f7453c33_uniq" ON "variables" ("name", "datasetId");
CREATE INDEX "variables_sourceId_31fce80a_fk_sources_id" ON "variables" ("sourceId");