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 datasetId = 5687 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
472229 Waste (per capita) tonnes per capita Nitrous oxide emissions from waste, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:31 2023-10-27 12:19:55     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Waste",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   waste__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#waste__per_capita   1                 
[]
                
472228 Waste tonnes Nitrous oxide emissions from waste, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:30 2023-10-27 12:19:55     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Waste",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   waste grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#waste   1                 
[]
                
472227 Transport (per capita) tonnes per capita Nitrous oxide emissions from transport, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:29 2023-10-27 12:19:55     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Transport",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   transport__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#transport__per_capita   1                 
[]
                
472226 Transport tonnes Nitrous oxide emissions from transport, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:28 2023-10-27 12:19:55     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Transport",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   transport grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#transport   1                 
[]
                
472225 Total including LUCF (per capita) tonnes per capita Total nitrous oxide emissions including land-use change and forestry, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:26 2023-10-27 12:19:54     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Total including LUCF",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   total_including_lucf__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#total_including_lucf__per_capita   1                 
[]
                
472224 Total including LUCF tonnes Total nitrous oxide emissions including land-use change and forestry, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:25 2023-10-27 12:19:54     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Total including LUCF",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   total_including_lucf grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#total_including_lucf   1                 
[]
                
472223 Total excluding LUCF (per capita) tonnes per capita Total nitrous oxide emissions excluding land-use change and forestry, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:24 2023-10-27 12:19:54     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Total excluding LUCF",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   total_excluding_lucf__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#total_excluding_lucf__per_capita   1                 
[]
                
472222 Total excluding LUCF tonnes Total nitrous oxide emissions excluding land-use change and forestry, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:22 2023-10-27 12:19:54     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Total excluding LUCF",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   total_excluding_lucf grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#total_excluding_lucf   1                 
[]
                
472221 Other fuel combustion (per capita) tonnes per capita Nitrous oxide emissions from other fuel combustion, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:21 2023-10-27 12:19:54     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Other fuel combustion",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   other_fuel_combustion__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#other_fuel_combustion__per_capita   1                 
[]
                
472220 Other fuel combustion tonnes Nitrous oxide emissions from other fuel combustion, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:20 2023-10-27 12:19:54     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Other fuel combustion",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   other_fuel_combustion grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#other_fuel_combustion   1                 
[]
                
472219 Manufacturing and construction (per capita) tonnes per capita Nitrous oxide emissions from manufacturing and construction, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:19 2023-10-27 12:19:54     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Manufacturing and construction",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   manufacturing_and_construction__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#manufacturing_and_construction__per_capita   1                 
[]
                
472218 Manufacturing and construction tonnes Nitrous oxide emissions from manufacturing and construction, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:17 2023-10-27 12:19:53     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Manufacturing and construction",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   manufacturing_and_construction grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#manufacturing_and_construction   1                 
[]
                
472217 Land-use change and forestry (per capita) tonnes per capita Nitrous oxide emissions from land use change and forestry, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:16 2023-10-27 12:19:53     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 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/n2o_emissions/nitrous_oxide_emissions_by_sector#land_use_change_and_forestry__per_capita   1                 
[]
                
472216 Land-use change and forestry tonnes Nitrous oxide emissions from land use change and forestry, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:15 2023-10-27 12:19:53     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 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/n2o_emissions/nitrous_oxide_emissions_by_sector#land_use_change_and_forestry   1                 
[]
                
472215 Industry (per capita) tonnes per capita Nitrous oxide emissions from industry, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:14 2023-10-27 12:19:53     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Industry",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   industry__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#industry__per_capita   1                 
[]
                
472214 Industry tonnes Nitrous oxide emissions from industry, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:12 2023-10-27 12:19:53     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Industry",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   industry grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#industry   1                 
[]
                
472213 Fugitive emissions (per capita) tonnes per capita Fugitive emissions of nitrous oxide from energy production, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:11 2023-10-27 12:19:53     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Fugitive emissions",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   fugitive_emissions__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#fugitive_emissions__per_capita   1                 
[]
                
472212 Fugitive emissions tonnes Fugitive emissions of nitrous oxide from energy production, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:10 2023-10-27 12:19:52     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Fugitive emissions",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   fugitive_emissions grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#fugitive_emissions   1                 
[]
                
472211 Energy (per capita) tonnes per capita Nitrous oxide emissions from energy, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:09 2023-10-27 12:19:52     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Energy",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   energy__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#energy__per_capita   1                 
[]
                
472210 Energy tonnes Nitrous oxide emissions from energy, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:07 2023-10-27 12:19:52     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Energy",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   energy grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#energy   1                 
[]
                
472209 Electricity and heat (per capita) tonnes per capita Nitrous oxide emissions from electricity and heat, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:06 2023-10-27 12:19:52     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Electricity and heat",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   electricity_and_heat__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#electricity_and_heat__per_capita   1                 
[]
                
472208 Electricity and heat tonnes Nitrous oxide emissions from electricity and heat, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:05 2023-10-27 12:19:52     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Electricity and heat",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   electricity_and_heat grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#electricity_and_heat   1                 
[]
                
472207 Buildings (per capita) tonnes per capita Nitrous oxide emissions from buildings, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:04 2023-10-27 12:19:52     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Buildings",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   buildings__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#buildings__per_capita   1                 
[]
                
472206 Buildings tonnes Nitrous oxide emissions from buildings, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:02 2023-10-27 12:19:51     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Buildings",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   buildings grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#buildings   1                 
[]
                
472205 Aviation and shipping (per capita) tonnes per capita Nitrous oxide emissions from bunker fuels, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:50:01 2023-10-27 12:19:51     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Aviation and shipping",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   aviation_and_shipping__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#aviation_and_shipping__per_capita   1                 
[]
                
472204 Aviation and shipping tonnes Nitrous oxide emissions from bunker fuels, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:50:00 2023-10-27 12:19:51     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Aviation and shipping",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   aviation_and_shipping grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#aviation_and_shipping   1                 
[]
                
472203 Agriculture (per capita) tonnes per capita Nitrous oxide emissions from agriculture, measured in tonnes of carbon dioxide-equivalents per capita. 2022-08-12 08:49:58 2023-10-27 12:19:50     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Agriculture",
    "unit": "tonnes per capita",
    "shortUnit": "t"
}
 0 
{}
   agriculture__per_capita grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_emissions_by_sector#agriculture__per_capita   1                 
[]
                
472202 Agriculture tonnes Nitrous oxide emissions from agriculture, measured in tonnes of carbon dioxide-equivalents. 2022-08-12 08:49:57 2023-10-27 12:19:50     1990-2019 Nitrous oxide emissions by sector (CAIT, 2022) 5687 Our World in Data based on Climate Analysis Indicators Tool (CAIT). 28859 t 
{
    "name": "Agriculture",
    "unit": "tonnes",
    "shortUnit": "t",
    "conversionFactor": 1000000.0,
    "numDecimalPlaces": 0
}
 0 
{}
   agriculture grapher/cait/2022-08-10/n2o_emissions/nitrous_oxide_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");