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

13 rows where datasetId = 5791 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, timespan, 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
527903 Production-based CO₂ emissions (% of global total) %   2022-10-03 13:16:48 2023-10-27 12:25:39     1750-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     production_emissions_as_share_of_global grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#production_emissions_as_share_of_global   1                                  
527902 Production-based CO₂ per capita tonnes of CO₂ per capita   2022-10-03 13:16:48 2023-10-27 12:25:39     1750-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 t 
{
    "unit": "tonnes of CO\u2082 per capita",
    "shortUnit": "t"
}
 0     production_emissions_per_capita grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#production_emissions_per_capita   1                                  
527901 Production-based CO₂ emissions tonnes   2022-10-03 13:16:48 2023-10-27 12:25:39     1750-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 t 
{
    "unit": "tonnes",
    "shortUnit": "t"
}
 0     production_emissions grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#production_emissions   1                                  
527900 Share of global population %   2022-10-03 13:16:44 2023-10-27 12:25:39     1750-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     population_as_share_of_global grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#population_as_share_of_global   1                                  
527899 Population persons   2022-10-03 13:16:44 2023-10-27 12:25:39     1750-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 persons 
{
    "unit": "persons",
    "shortUnit": "persons"
}
 0     population grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#population   1                                  
527898 CO₂ emissions from fossil fuels and industry tonnes Global CO₂ emissions from fossil fuels and industry (which includes coal, oil, gas, cement and flaring). 2022-10-03 13:16:44 2023-10-27 12:25:39     1750-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 t 
{
    "unit": "tonnes",
    "shortUnit": "t"
}
 0     global_fossil_emissions grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#global_fossil_emissions   1                                  
527897 CO₂ emissions from fossil fuels and land use change tonnes Global CO₂ emissions from fossil fuels and industry (which includes coal, oil, gas, cement and flaring) plus land-use change. 2022-10-03 13:16:44 2023-10-27 12:25:39     1850-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 t 
{
    "unit": "tonnes",
    "shortUnit": "t"
}
 0     global_fossil_and_land_use_change_emissions grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#global_fossil_and_land_use_change_emissions   1                                  
527896 CO₂ emissions from land use change tonnes Global CO₂ emissions from land use change. 2022-10-03 13:16:44 2023-10-27 12:25:39     1850-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 t 
{
    "unit": "tonnes",
    "shortUnit": "t"
}
 0     global_land_use_change_emissions grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#global_land_use_change_emissions   1                                  
527895 Global population persons   2022-10-03 13:16:44 2023-10-27 12:25:39     1750-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 persons 
{
    "unit": "persons",
    "shortUnit": "persons"
}
 0     global_population grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#global_population   1                                  
527894 Global bunker emissions tonnes   2022-10-03 13:16:44 2023-10-27 12:25:39     1959-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 t 
{
    "unit": "tonnes",
    "shortUnit": "t"
}
 0     global_bunker_emissions grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#global_bunker_emissions   1                                  
527893 Consumption-based CO₂ per capita tonnes of CO₂ per capita   2022-10-03 13:16:44 2023-10-27 12:25:39     1750-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 t 
{
    "unit": "tonnes of CO\u2082 per capita",
    "shortUnit": "t"
}
 0     consumption_emissions_per_capita grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#consumption_emissions_per_capita   1                                  
527892 Consumption-based CO₂ emissions (% of global total) %   2022-10-03 13:16:44 2023-10-27 12:25:39     1750-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     consumption_emissions_as_share_of_global grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#consumption_emissions_as_share_of_global   1                                  
527891 Consumption-based CO₂ emissions tonnes   2022-10-03 13:16:44 2023-10-27 12:25:39     1750-2020 Global Carbon Budget (Global Carbon Project, v2021b) 5791 Global Carbon Project (2021) 27084 t 
{
    "unit": "tonnes",
    "shortUnit": "t"
}
 0     consumption_emissions grapher/gcp/2022-09-29/global_carbon_budget_additional/global_carbon_budget_additional#consumption_emissions   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");