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

24 rows where sourceId = 28857 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, updatedAt, 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
472173 Transport (per capita) tonnes per capita Carbon dioxide emissions from transport, measured in tonnes per capita. 2022-08-12 08:48:57 2023-10-27 12:19:47     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Transport",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   transport__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#transport__per_capita   1                 
[]
                
472172 Transport tonnes Carbon dioxide emissions from transport, measured in tonnes. 2022-08-12 08:48:55 2023-10-27 12:19:47     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Transport",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   transport grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#transport   1                 
[]
                
472171 Total including LUCF (per capita) tonnes per capita Total carbon dioxide emissions including land-use change and forestry, measured in tonnes per capita. 2022-08-12 08:48:54 2023-10-27 12:19:47     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Total including LUCF",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   total_including_lucf__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#total_including_lucf__per_capita   1                 
[]
                
472170 Total including LUCF tonnes Total carbon dioxide emissions including land-use change and forestry, measured in tonnes. 2022-08-12 08:48:53 2023-10-27 12:19:47     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Total including LUCF",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   total_including_lucf grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#total_including_lucf   1                 
[]
                
472169 Total excluding LUCF (per capita) tonnes per capita Total carbon dioxide emissions excluding land-use change and forestry, measured in tonnes per capita. 2022-08-12 08:48:51 2023-10-27 12:19:46     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Total excluding LUCF",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   total_excluding_lucf__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#total_excluding_lucf__per_capita   1                 
[]
                
472168 Total excluding LUCF tonnes Total carbon dioxide emissions excluding land-use change and forestry, measured in tonnes. 2022-08-12 08:48:50 2023-10-27 12:19:46     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Total excluding LUCF",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   total_excluding_lucf grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#total_excluding_lucf   1                 
[]
                
472167 Other fuel combustion (per capita) tonnes per capita Carbon dioxide emissions from other fuel combustion, measured in tonnes per capita. 2022-08-12 08:48:49 2023-10-27 12:19:46     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Other fuel combustion",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   other_fuel_combustion__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#other_fuel_combustion__per_capita   1                 
[]
                
472166 Other fuel combustion tonnes Carbon dioxide emissions from other fuel combustion, measured in tonnes. 2022-08-12 08:48:48 2023-10-27 12:19:46     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Other fuel combustion",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   other_fuel_combustion grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#other_fuel_combustion   1                 
[]
                
472165 Manufacturing and construction (per capita) tonnes per capita Carbon dioxide emissions from manufacturing and construction, measured in tonnes per capita. 2022-08-12 08:48:46 2023-10-27 12:19:46     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Manufacturing and construction",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   manufacturing_and_construction__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#manufacturing_and_construction__per_capita   1                 
[]
                
472164 Manufacturing and construction tonnes Carbon dioxide emissions from manufacturing and construction, measured in tonnes. 2022-08-12 08:48:45 2023-10-27 12:19:46     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Manufacturing and construction",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   manufacturing_and_construction grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#manufacturing_and_construction   1                 
[]
                
472163 Land-use change and forestry (per capita) tonnes per capita Carbon dioxide emissions from land use change and forestry, measured in tonnes per capita. 2022-08-12 08:48:44 2023-10-27 12:19:45     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Land-use change and forestry",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   land_use_change_and_forestry__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#land_use_change_and_forestry__per_capita   1                 
[]
                
472162 Land-use change and forestry tonnes Carbon dioxide emissions from land use change and forestry, measured in tonnes. 2022-08-12 08:48:42 2023-10-27 12:19:45     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Land-use change and forestry",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   land_use_change_and_forestry grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#land_use_change_and_forestry   1                 
[]
                
472161 Industry (per capita) tonnes per capita Carbon dioxide emissions from industry, measured in tonnes per capita. 2022-08-12 08:48:41 2023-10-27 12:19:45     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Industry",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   industry__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#industry__per_capita   1                 
[]
                
472160 Industry tonnes Carbon dioxide emissions from industry, measured in tonnes. 2022-08-12 08:48:40 2023-10-27 12:19:45     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Industry",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   industry grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#industry   1                 
[]
                
472159 Fugitive emissions (per capita) tonnes per capita Fugitive emissions of carbon dioxide from energy production, measured in tonnes per capita. 2022-08-12 08:48:39 2023-10-27 12:19:45     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Fugitive emissions",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   fugitive_emissions__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#fugitive_emissions__per_capita   1                 
[]
                
472158 Fugitive emissions tonnes Fugitive emissions of carbon dioxide from energy production, measured in tonnes. 2022-08-12 08:48:38 2023-10-27 12:19:45     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Fugitive emissions",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   fugitive_emissions grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#fugitive_emissions   1                 
[]
                
472157 Energy (per capita) tonnes per capita Carbon dioxide emissions from energy, measured in tonnes per capita. 2022-08-12 08:48:37 2023-10-27 12:19:44     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Energy",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   energy__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#energy__per_capita   1                 
[]
                
472156 Energy tonnes Carbon dioxide emissions from energy, measured in tonnes. 2022-08-12 08:48:36 2023-10-27 12:19:44     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Energy",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   energy grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#energy   1                 
[]
                
472155 Electricity and heat (per capita) tonnes per capita Carbon dioxide emissions from electricity and heat, measured in tonnes per capita. 2022-08-12 08:48:34 2023-10-27 12:19:44     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Electricity and heat",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   electricity_and_heat__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#electricity_and_heat__per_capita   1                 
[]
                
472154 Electricity and heat tonnes Carbon dioxide emissions from electricity and heat, measured in tonnes. 2022-08-12 08:48:33 2023-10-27 12:19:44     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Electricity and heat",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   electricity_and_heat grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#electricity_and_heat   1                 
[]
                
472153 Buildings (per capita) tonnes per capita Carbon dioxide emissions from buildings, measured in tonnes per capita. 2022-08-12 08:48:32 2023-10-27 12:19:43     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Buildings",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   buildings__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#buildings__per_capita   1                 
[]
                
472152 Buildings tonnes Carbon dioxide emissions from buildings, measured in tonnes. 2022-08-12 08:48:30 2023-10-27 12:19:43     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Buildings",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   buildings grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#buildings   1                 
[]
                
472151 Aviation and shipping (per capita) tonnes per capita Carbon dioxide emissions from bunker fuels, measured in tonnes per capita. 2022-08-12 08:48:29 2023-10-27 12:19:43     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Aviation and shipping",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   aviation_and_shipping__per_capita grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#aviation_and_shipping__per_capita   1                 
[]
                
472150 Aviation and shipping tonnes Carbon dioxide emissions from bunker fuels, measured in tonnes. 2022-08-12 08:48:28 2023-10-27 12:19:43     1990-2019 Carbon dioxide emissions by sector (CAIT, 2022) 5685 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28857 t 
{
    "name": "Aviation and shipping",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   aviation_and_shipping grapher/cait/2022-08-10/co2_emissions/carbon_dioxide_emissions_by_sector#aviation_and_shipping   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");