variables

This table contains all the variables of all the datasets we have at Our World In Data. Note that this includes only the information about the variables like name and default display settings, not the data itself.

Data license: CC-BY

5 rows where sourceId = 29465 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, timespan, 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
804122 8.1.1 - Annual growth rate of real GDP per capita (%) - NY_GDP_PCAP % Annual growth rate of real GDP per capita (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-08-01-01.pdf 2023-08-17 17:25:54 2024-07-08 16:18:39     2000-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Department of Economic and Social Affairs 29465 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _8_1_1__ny_gdp_pcap grapher/un/2023-08-16/un_sdg/_8_1_1__ny_gdp_pcap#_8_1_1__ny_gdp_pcap   1                 
[]
         float 
[]
 3f4ae92c998a94c6cfcd5c8fd9b27835 4834409a4dace223c6805312518261e9
802588 17.19.2 - Proportion of countries with death registration data that are at least 75 percent complete (%) - SG_REG_DETH75 % Proportion of countries with death registration data that are at least 75 percent complete (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-19-02a.pdf and https://unstats.un.org/sdgs/metadata/files/Metadata-17-19-02b.pdf 2023-08-17 17:14:03 2024-07-08 16:16:47     2015-2020 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Department of Economic and Social Affairs 29465 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _17_19_2__sg_reg_deth75 grapher/un/2023-08-16/un_sdg/_17_19_2__sg_reg_deth75#_17_19_2__sg_reg_deth75   1                 
[]
         float 
[]
 0e2f57dffec12367e357077ff3f1cbe0 f385249857ca75a8fad48975bd58cccf
802587 17.19.2 - Countries that have conducted at least one population and housing census in the last 10 years (1 = YES; 0 = NO) - SG_REG_CENSUSN number Countries that have conducted at least one population and housing census in the last 10 years (1 = YES; 0 = NO) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-19-02a.pdf and https://unstats.un.org/sdgs/metadata/files/Metadata-17-19-02b.pdf 2023-08-17 17:14:02 2024-07-08 16:16:46     2015-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Department of Economic and Social Affairs 29465   
{
    "unit": "number"
}
 0     _17_19_2__sg_reg_censusn grapher/un/2023-08-16/un_sdg/_17_19_2__sg_reg_censusn#_17_19_2__sg_reg_censusn   1                 
[]
         int 
[]
 19c02aa50a01c33bf0c0360bd6ef64fd aa328fda1a558e7eb64fe61c1a34dad2
802586 17.19.2 - Proportion of countries that have conducted at least one population and housing census in the last 10 years (%) - SG_REG_CENSUS % Proportion of countries that have conducted at least one population and housing census in the last 10 years (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-19-02a.pdf and https://unstats.un.org/sdgs/metadata/files/Metadata-17-19-02b.pdf 2023-08-17 17:14:02 2024-07-08 16:16:46     2019-2019 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Department of Economic and Social Affairs 29465 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _17_19_2__sg_reg_census grapher/un/2023-08-16/un_sdg/_17_19_2__sg_reg_census#_17_19_2__sg_reg_census   1                 
[]
         float 
[]
 b29c69353f7f92eeea3f467acb467796 d676bf2a067a8216e6139956a9e131bc
802584 17.19.2 - Proportion of countries with birth registration data that are at least 90 percent complete (%) - SG_REG_BRTH90 % Proportion of countries with birth registration data that are at least 90 percent complete (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-17-19-02a.pdf and https://unstats.un.org/sdgs/metadata/files/Metadata-17-19-02b.pdf 2023-08-17 17:14:01 2024-07-08 16:16:46     2015-2020 United Nations Sustainable Development Goals (2023-Q2) 6193 UN Department of Economic and Social Affairs 29465 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _17_19_2__sg_reg_brth90 grapher/un/2023-08-16/un_sdg/_17_19_2__sg_reg_brth90#_17_19_2__sg_reg_brth90   1                 
[]
         float 
[]
 ebac0a042bbe0ae5fc713cfab40fa816 34bb6419d487dbac882484c20d750c2c

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");