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

28 rows where sourceId = 28855 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
472201 Waste (per capita) tonnes per capita Methane emissions from waste, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:46 2023-10-27 12:19:39     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Waste",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   waste__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#waste__per_capita   1                 
[]
                
472200 Waste tonnes Methane emissions from waste, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:44 2023-10-27 12:19:39     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Waste",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   waste grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#waste   1                 
[]
                
472199 Transport (per capita) tonnes per capita Methane emissions from transport, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:43 2023-10-27 12:19:39     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Transport",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   transport__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#transport__per_capita   1                 
[]
                
472198 Transport tonnes Methane emissions from transport, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:41 2023-10-27 12:19:39     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Transport",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   transport grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#transport   1                 
[]
                
472197 Total including LUCF (per capita) tonnes per capita Total methane emissions including land-use change and forestry, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:40 2023-10-27 12:19:39     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Total including LUCF",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   total_including_lucf__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#total_including_lucf__per_capita   1                 
[]
                
472196 Total including LUCF tonnes Total methane emissions including land-use change and forestry, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:38 2023-10-27 12:19:39     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Total including LUCF",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   total_including_lucf grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#total_including_lucf   1                 
[]
                
472195 Total excluding LUCF (per capita) tonnes per capita Total methane emissions excluding land-use change and forestry, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:37 2023-10-27 12:19:38     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Total excluding LUCF",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   total_excluding_lucf__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#total_excluding_lucf__per_capita   1                 
[]
                
472194 Total excluding LUCF tonnes Total methane emissions excluding land-use change and forestry, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:36 2023-10-27 12:19:38     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Total excluding LUCF",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   total_excluding_lucf grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#total_excluding_lucf   1                 
[]
                
472193 Other fuel combustion (per capita) tonnes per capita Methane emissions from other fuel combustion, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:34 2023-10-27 12:19:38     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Other fuel combustion",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   other_fuel_combustion__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#other_fuel_combustion__per_capita   1                 
[]
                
472192 Other fuel combustion tonnes Methane emissions from other fuel combustion, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:33 2023-10-27 12:19:38     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Other fuel combustion",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   other_fuel_combustion grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#other_fuel_combustion   1                 
[]
                
472191 Manufacturing and construction (per capita) tonnes per capita Methane emissions from manufacturing and construction, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:32 2023-10-27 12:19:38     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Manufacturing and construction",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   manufacturing_and_construction__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#manufacturing_and_construction__per_capita   1                 
[]
                
472190 Manufacturing and construction tonnes Methane emissions from manufacturing and construction, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:31 2023-10-27 12:19:38     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Manufacturing and construction",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   manufacturing_and_construction grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#manufacturing_and_construction   1                 
[]
                
472189 Land-use change and forestry (per capita) tonnes per capita Methane emissions from land use change and forestry, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:30 2023-10-27 12:19:37     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 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/ch4_emissions/methane_emissions_by_sector#land_use_change_and_forestry__per_capita   1                 
[]
                
472188 Land-use change and forestry tonnes Methane emissions from land use change and forestry, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:28 2023-10-27 12:19:37     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 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/ch4_emissions/methane_emissions_by_sector#land_use_change_and_forestry   1                 
[]
                
472187 Industry (per capita) tonnes per capita Methane emissions from industry, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:27 2023-10-27 12:19:37     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Industry",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   industry__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#industry__per_capita   1                 
[]
                
472186 Industry tonnes Methane emissions from industry, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:26 2023-10-27 12:19:37     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Industry",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   industry grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#industry   1                 
[]
                
472185 Fugitive emissions (per capita) tonnes per capita Fugitive emissions of methane from energy production, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:25 2023-10-27 12:19:37     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Fugitive emissions",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   fugitive_emissions__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#fugitive_emissions__per_capita   1                 
[]
                
472184 Fugitive emissions tonnes Fugitive emissions of methane from energy production, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:23 2023-10-27 12:19:36     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Fugitive emissions",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   fugitive_emissions grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#fugitive_emissions   1                 
[]
                
472183 Energy (per capita) tonnes per capita Methane emissions from energy, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:22 2023-10-27 12:19:36     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Energy",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   energy__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#energy__per_capita   1                 
[]
                
472182 Energy tonnes Methane emissions from energy, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:21 2023-10-27 12:19:36     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Energy",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   energy grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#energy   1                 
[]
                
472181 Electricity and heat (per capita) tonnes per capita Methane emissions from electricity and heat, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:20 2023-10-27 12:19:36     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Electricity and heat",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   electricity_and_heat__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#electricity_and_heat__per_capita   1                 
[]
                
472180 Electricity and heat tonnes Methane emissions from electricity and heat, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:18 2023-10-27 12:19:36     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Electricity and heat",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   electricity_and_heat grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#electricity_and_heat   1                 
[]
                
472179 Buildings (per capita) tonnes per capita Methane emissions from buildings, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:17 2023-10-27 12:19:36     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Buildings",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   buildings__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#buildings__per_capita   1                 
[]
                
472178 Buildings tonnes Methane emissions from buildings, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:16 2023-10-27 12:19:35     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Buildings",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   buildings grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#buildings   1                 
[]
                
472177 Aviation and shipping (per capita) tonnes per capita Methane emissions from bunker fuels, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:15 2023-10-27 12:19:35     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Aviation and shipping",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   aviation_and_shipping__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#aviation_and_shipping__per_capita   1                 
[]
                
472176 Aviation and shipping tonnes Methane emissions from bunker fuels, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:13 2023-10-27 12:19:35     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Aviation and shipping",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   aviation_and_shipping grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#aviation_and_shipping   1                 
[]
                
472175 Agriculture (per capita) tonnes per capita Methane emissions from agriculture, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:12 2023-10-27 12:19:34     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Agriculture",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   agriculture__per_capita grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#agriculture__per_capita   1                 
[]
                
472174 Agriculture tonnes Methane emissions from agriculture, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:11 2023-10-27 12:19:34     1990-2019 Methane emissions by sector (CAIT, 2022) 5686 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28855 t 
{
    "name": "Agriculture",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   agriculture grapher/cait/2022-08-10/ch4_emissions/methane_emissions_by_sector#agriculture   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");