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

4 rows where datasetId = 6634 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, 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
954561 production_or_consumption_co2   Indicates whether consumption-based CO2 emissions are available, or whether production-based emissions are used as a substitute. 2024-07-28 12:50:15 2024-07-28 12:50:15     1990-2022 HDI per capita CO2 (UNDP Project) 6634     
{}
 0     production_or_consumption_co2 grapher/fasttrack/latest/hdi_per_co2/hdi_per_co2#production_or_consumption_co2   2                 
[]
         string 
[]
 04c314a772d4b65171640f3e8bfb121c f36522205259ac9d094bb74c735578ce
954560 hdi_per_co2_production   Human Development Index divided by per capita production-based CO2 emissions. 2024-07-28 12:50:15 2024-07-28 12:50:15     1990-2022 HDI per capita CO2 (UNDP Project) 6634     
{}
 0     hdi_per_co2_production grapher/fasttrack/latest/hdi_per_co2/hdi_per_co2#hdi_per_co2_production   2                 
[]
         float 
[]
 cd141426a9d9d531e3d59392e7aa62a4 81f860b928bdc0257a6ed44fc9dd9699
954559 hdi_per_co2_consumption   Human Development Index divided by per capita consumption-based CO2 emissions. 2024-07-28 12:50:14 2024-07-28 12:50:15     1990-2022 HDI per capita CO2 (UNDP Project) 6634     
{}
 0     hdi_per_co2_consumption grapher/fasttrack/latest/hdi_per_co2/hdi_per_co2#hdi_per_co2_consumption   2                 
[]
         float 
[]
 99adae148ad3d346712641ce7f50f007 dddcf3ed0566f53ff840071cc526ecce
954466 hdi_per_co2   Human Development Index divided by per capita consumption-based CO2 emissions, if they are available. Otherwise, production-based emissions are used. 2024-07-26 14:02:23 2024-07-28 12:50:15     1990-2022 HDI per capita CO2 (UNDP Project) 6634     
{}
 0     hdi_per_co2 grapher/fasttrack/latest/hdi_per_co2/hdi_per_co2#hdi_per_co2   2                 
[]
         float 
[]
 de63cb10a0d09f2fd0e30aa6eacd53e5 c4c3394e7f95ab4fe9e3b21cd5838c4e

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