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

14 rows where sourceId = 21228 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, 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
179870 Annual CO2 emissions from other industry (zero filled) tonnes Annual production-based emissions of carbon dioxide (CO2) from other industry sources, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from other industry"
}
 0 
{}
         1                                  
179867 Annual CO2 emissions from other industry tonnes Annual production-based emissions of carbon dioxide (CO2) from other industry sources, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from other industry"
}
 0 
{}
         1                                  
179866 Annual CO2 emissions from oil (zero filled) tonnes Annual production-based emissions of carbon dioxide (CO2) from oil, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from oil"
}
 0 
{}
         1                                  
179863 Annual CO2 emissions from oil tonnes Annual production-based emissions of carbon dioxide (CO2) from oil, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from oil"
}
 0 
{}
         1                                  
179862 Annual CO2 emissions from gas (zero filled) tonnes Annual production-based emissions of carbon dioxide (CO2) from gas, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from gas"
}
 0 
{}
         1                                  
179859 Annual CO2 emissions from gas tonnes Annual production-based emissions of carbon dioxide (CO2) from gas, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from gas"
}
 0 
{}
         1                                  
179858 Annual CO2 emissions from flaring (zero filled) tonnes Annual production-based emissions of carbon dioxide (CO2) from flaring, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from flaring"
}
 0 
{}
         1                                  
179855 Annual CO2 emissions from flaring tonnes Annual production-based emissions of carbon dioxide (CO2) from flaring, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from flaring"
}
 0 
{}
         1                                  
179854 Annual CO2 emissions from coal (zero filled) tonnes Annual production-based emissions of carbon dioxide (CO2) from coal, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from coal"
}
 0 
{}
         1                                  
179851 Annual CO2 emissions from coal tonnes Annual production-based emissions of carbon dioxide (CO2) from coal, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from coal"
}
 0 
{}
         1                                  
179850 Annual CO2 emissions from cement (zero filled) tonnes Annual production-based emissions of carbon dioxide (CO2) from cement, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from cement"
}
 0 
{}
         1                                  
179847 Annual CO2 emissions from cement tonnes Annual production-based emissions of carbon dioxide (CO2) from cement, measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions from cement"
}
 0 
{}
         1                                  
179844 Annual CO2 emissions (zero filled) tonnes Annual production-based emissions of carbon dioxide (CO2), measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions"
}
 0 
{}
         1                                  
179841 Annual CO2 emissions tonnes Annual production-based emissions of carbon dioxide (CO2), measured in tonnes. This is based on territorial emissions, which do not account for emissions embedded in traded goods. 2021-11-03 21:06:06 2023-06-15 05:05:42       Global Carbon Budget - Global Carbon Project (2021) 5397 Global Carbon Project 21228 t 
{
    "name": "Annual CO\u2082 emissions"
}
 0 
{}
         1                                  

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