variables
Data license: CC-BY
8 rows where datasetId = 5774 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: unit, updatedAt, timespan, sourceId, shortUnit, display, type, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
525715 | Population density | people per km² | Population density by country, available from 10,000 BCE to 2100 based on Gapminder data, HYDE, and UN Population Division (2022) estimates. Estimated by dividing a country's population by its land area (from FAO via World Bank). * 10,000 BCE - 1799: Historical estimates by HYDE (v3.2). Includes some datapoints from Gapminder (Systema Globalis). * 1800-1949: Historical estimates by Gapminder. Includes some datapoints from HYDE (v3.2) and Gapminder (Systema Globalis). * 1950-2021: Population records by the United Nations - Population Division (2022). Includes some datapoints from HYDE (v3.2), Gapminder (Systema Globalis) and Gapminder (v6). * 2022-2100: Projections based on Medium variant by the United Nations - Population Division (2022). | 2022-09-20 12:16:46 | 2024-07-25 22:54:57 | -10000-2100 | Key Indicators 5774 | Gapminder (2019); UN (2022); HYDE (2017); Gapminder (Systema Globalis); Food and Agriculture Organization of the United Nations 28846 | { "name": "Population density", "unit": "people per km\u00b2", "includeInTable": true } |
0 | population_density | grapher/owid/latest/key_indicators/population_density#population_density | 1 | [] |
float | [] |
a135018f46ac474a7219a98c708ac057 | e57cb6b9182c30c7bfb292bc1a70e038 | ||||||||||||||||||
525714 | Share of world population (future projections) | % | Share of the world's population by country, available from 2022 to 2100 2022-2100: Projections based on Medium variant by the United Nations - Population Division (2022). | 2022-09-20 12:16:38 | 2024-07-25 22:54:57 | 2022-2100 | Key Indicators 5774 | Gapminder (2019); UN (2022); HYDE (2017); Gapminder (Systema Globalis) 28845 | % | { "name": "Share of world population (future projections)", "unit": "%", "shortUnit": "%", "includeInTable": true } |
0 | world_pop_share_projection | grapher/owid/latest/key_indicators/population#world_pop_share_projection | 1 | [] |
float | [] |
1fc786819a47c7b55f02f6d32db7ea12 | 62a9eae4e8db423d64469b4fb1e8f5d6 | |||||||||||||||||
525713 | Share of world population (historical estimates) | % | Share of the world's population by country, available from 10,000 BCE to 2021 10,000 BCE - 1799: Historical estimates by HYDE (v3.2). 1800-1949: Historical estimates by Gapminder. 1950-2022: Population records by the United Nations - Population Division (2022). | 2022-09-20 12:16:36 | 2024-07-25 22:54:56 | -10000-2021 | Key Indicators 5774 | Gapminder (2019); UN (2022); HYDE (2017); Gapminder (Systema Globalis) 28845 | % | { "name": "Share of world population", "unit": "%", "shortUnit": "%", "includeInTable": true } |
0 | world_pop_share_historical | grapher/owid/latest/key_indicators/population#world_pop_share_historical | 1 | [] |
float | [] |
0ea1e9659618f877513c028d7f40e88c | 7540f4d2177bbb6ed68ba7b66240335f | |||||||||||||||||
525712 | Population (future projections) | persons | Population by country, available from 2022 to 2100 2022-2100: Projections based on Medium variant by the United Nations - Population Division (2022). | 2022-09-20 12:16:35 | 2024-07-25 22:54:56 | 2022-2100 | Key Indicators 5774 | Gapminder (2019); UN (2022); HYDE (2017); Gapminder (Systema Globalis) 28845 | { "name": "Population (future projections)", "unit": "persons", "includeInTable": true } |
0 | population_projection | grapher/owid/latest/key_indicators/population#population_projection | 1 | [] |
int | [] |
830c58fe256dabe38185dc6cba19a54a | 29baf9220cb183d86e68ee9f00e63d94 | ||||||||||||||||||
525711 | Population (historical estimates) | persons | Population by country, available from 10,000 BCE to 2021 10,000 BCE - 1799: Historical estimates by HYDE (v3.2). 1800-1949: Historical estimates by Gapminder. 1950-2022: Population records by the United Nations - Population Division (2022). | 2022-09-20 12:16:33 | 2024-07-25 22:54:56 | -10000-2021 | Key Indicators 5774 | Gapminder (2019); UN (2022); HYDE (2017); Gapminder (Systema Globalis) 28845 | { "name": "Population", "unit": "persons", "includeInTable": true } |
0 | population_historical | grapher/owid/latest/key_indicators/population#population_historical | 1 | [] |
int | [] |
86c1f5a83713086066e0e0bd0af54f68 | 53556c323c18fadf87fbf87d7766ee16 | ||||||||||||||||||
525710 | Share of world population | % | Share of the world's population by country, available from 10,000 BCE to 2100 based on Gapminder data, HYDE, and UN Population Division (2022) estimates. * 10,000 BCE - 1799: Historical estimates by HYDE (v3.2). Includes some datapoints Gapminder (Systema Globalis). * 1800-1949: Historical estimates by Gapminder. Includes some datapoints from HYDE (v3.2) and Gapminder (Systema Globalis). * 1950-2021: Population records by the United Nations - Population Division (2022). Includes some datapoints from HYDE (v3.2), Gapminder (Systema Globalis) and Gapminder (v6). * 2022-2100: Projections based on Medium variant by the United Nations - Population Division (2022). | 2022-09-20 12:16:31 | 2024-07-25 22:54:56 | -10000-2100 | Key Indicators 5774 | Gapminder (2019); UN (2022); HYDE (2017); Gapminder (Systema Globalis) 28845 | % | { "name": "Share of world population", "unit": "%", "shortUnit": "%", "includeInTable": true } |
0 | world_pop_share | grapher/owid/latest/key_indicators/population#world_pop_share | 1 | [] |
float | [] |
e131777dba39581c859d8aef27840673 | fe50eb6b5fd9e4f4e90ad74377c56856 | |||||||||||||||||
525709 | Population | persons | Population by country, available from 10,000 BCE to 2100 based on Gapminder data, HYDE, and UN Population Division (2022) estimates. * 10,000 BCE - 1799: Historical estimates by HYDE (v3.2). Includes some datapoints from Gapminder (Systema Globalis). * 1800-1949: Historical estimates by Gapminder. Includes some datapoints from HYDE (v3.2) and Gapminder (Systema Globalis). * 1950-2021: Population records by the United Nations - Population Division (2022). Includes some datapoints from HYDE (v3.2), Gapminder (Systema Globalis) and Gapminder (v6). * 2022-2100: Projections based on Medium variant by the United Nations - Population Division (2022). | 2022-09-20 12:16:30 | 2024-07-25 22:54:56 | -10000-2100 | Key Indicators 5774 | Gapminder (2019); UN (2022); HYDE (2017); Gapminder (Systema Globalis) 28845 | { "name": "Population", "unit": "persons", "includeInTable": true } |
0 | population | grapher/owid/latest/key_indicators/population#population | 1 | [] |
int | [] |
b4f6a5e32a6e5d749900979b7203a92a | d9178a690bd94ad0daff183c637f19e0 | ||||||||||||||||||
525708 | Land area (sq. km) | sq. km | Land area is a country's total area, excluding area under inland water bodies, national claims to continental shelf, and exclusive economic zones. In most cases the definition of inland water bodies includes major rivers and lakes. Limitations and exceptions: The data are collected by the Food and Agriculture Organization (FAO) of the United Nations through annual questionnaires. The FAO tries to impose standard definitions and reporting methods, but complete consistency across countries and over time is not possible. The data collected from official national sources through the questionnaire are supplemented with information from official secondary data sources. The secondary sources cover official country data from websites of national ministries, national publications and related country data reported by various international organizations. Statistical concept and methodology: Total land area does not include inland water bodies such as major rivers and lakes. Variations from year to year may be due to updated or revised data rather than to change in area. | 2022-09-20 12:16:23 | 2024-07-25 22:54:56 | 1961-2021 | Key Indicators 5774 | Food and Agriculture Organization of the United Nations 27585 | sq. km | { "unit": "%", "shortUnit": "sq. km" } |
0 | land_area | grapher/owid/latest/key_indicators/land_area#land_area | 1 | [] |
float | [] |
5b1063c75437e5a8241c1a2225d7dd81 | cd3cfcfab96a3178aabfcf5db3a84cbb |
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");