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 sourceId = 29483 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, description, createdAt, updatedAt, shortUnit, display, 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
804392 9.4.1 - Carbon dioxide emissions per unit of manufacturing value added (kilogrammes of CO2 per constant 2015 United States dollars) - EN_ATM_CO2MVA kilograms per constant usd Carbon dioxide emissions per unit of manufacturing value added (kilogrammes of CO2 per constant 2015 United States dollars) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-09-04-01.pdf 2023-08-17 17:27:59 2024-07-08 16:18:58     2000-2020 United Nations Sustainable Development Goals (2023-Q2) 6193 International Energy Agency 29483 kg 
{
    "unit": "kilograms per constant usd",
    "shortUnit": "kg"
}
 0     _9_4_1__en_atm_co2mva grapher/un/2023-08-16/un_sdg/_9_4_1__en_atm_co2mva#_9_4_1__en_atm_co2mva   1                 
[]
         float 
[]
 63da2264605db7077be38f341683f8c4 63834f3912e93822381873f4539f69fc
804391 9.4.1 - Carbon dioxide emissions per unit of GDP PPP (kilogrammes of CO2 per constant 2017 United States dollars) - EN_ATM_CO2GDP kilograms per constant usd Carbon dioxide emissions per unit of GDP PPP (kilogrammes of CO2 per constant 2017 United States dollars) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-09-04-01.pdf 2023-08-17 17:27:59 2024-07-08 16:18:58     2000-2020 United Nations Sustainable Development Goals (2023-Q2) 6193 International Energy Agency 29483 kg 
{
    "unit": "kilograms per constant usd",
    "shortUnit": "kg"
}
 0     _9_4_1__en_atm_co2gdp grapher/un/2023-08-16/un_sdg/_9_4_1__en_atm_co2gdp#_9_4_1__en_atm_co2gdp   1                 
[]
         float 
[]
 5fe7ea886058a4267ae9e0474567ad36 be402540b12ed82f5daa63487bdd20c3
804390 9.4.1 - Carbon dioxide emissions from fuel combustion (millions of tonnes) - EN_ATM_CO2 - No breakdown millions of tonnes Carbon dioxide emissions from fuel combustion (millions of tonnes) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-09-04-01.pdf 2023-08-17 17:27:58 2024-07-08 16:18:58     2000-2020 United Nations Sustainable Development Goals (2023-Q2) 6193 International Energy Agency 29483   
{
    "unit": "millions of tonnes"
}
 0     _9_4_1__en_atm_co2__no_breakdown grapher/un/2023-08-16/un_sdg/_9_4_1__en_atm_co2__no_breakdown#_9_4_1__en_atm_co2__no_breakdown   1                 
[]
         float 
[]
 723d83e2d1e04798a82fb35f1221bcdb 98474a2ea7f329a0654a096a9abffce1
804389 9.4.1 - Carbon dioxide emissions from fuel combustion (millions of tonnes) - EN_ATM_CO2 - Manufacturing excl. coke and refined petroleum products and repair and installation of machinery and equipment millions of tonnes Carbon dioxide emissions from fuel combustion (millions of tonnes) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-09-04-01.pdf 2023-08-17 17:27:58 2024-07-08 16:18:57     2000-2020 United Nations Sustainable Development Goals (2023-Q2) 6193 International Energy Agency 29483   
{
    "unit": "millions of tonnes"
}
 0     _9_4_1__en_atm_co2__manufacturing_excl__coke_and_refined_petroleum_products_and_repair_and_installation_of_machinery_and_equipment grapher/un/2023-08-16/un_sdg/_9_4_1__en_atm_co2__manufacturing_excl__coke_and_refined_petroleum_products_and_repair_and_installation_of_machinery_and_equipment#_9_4_1__en_atm_co2__manufacturing_excl__coke_and_refined_petroleum_products_and_repair_and_installation_of_machinery_and_equipment   1                 
[]
         float 
[]
 c12ef8f0ac260aacdf26b3236b847220 983b9e39783e14032479499bc21e89b6

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