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

9 rows where datasetId = 6018 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, description, createdAt, updatedAt, 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
737190 Monthly CO₂ total emissions from aviation tonnes Includes emissions from both domestic and international aviation. International aviation emissions are assigned to the country of departure. CO₂ emissions from commercial passenger flights only. 2023-07-11 10:26:31 2024-07-30 06:11:40       Air Transport CO2 Emissions 6018 Clarke et al. (2022) via OECD (2023) 28608 t 
{
    "unit": "tonnes",
    "zeroDay": "2019-01-01",
    "shortUnit": "t",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     total_monthly_emissions grapher/oecd/2023-05-19/co2_air_transport/co2_air_transport#total_monthly_emissions   1                 
[]
         float 
[]
 f595c3564b1b77ce00127507301d3f75 d86baf0e64af665893574d5ed9e7d10c
700434 CO₂ emissions from international flights, international tourism-adjusted kilograms   2023-06-02 13:33:39 2024-07-30 06:11:39     2015-2021 Air Transport CO2 Emissions 6018 Clarke et al. (2022) via OECD (2023) 28608 kg 
{
    "unit": "kilograms",
    "shortUnit": "kg",
    "numDecimalPlaces": 0
}
 0     int_inb_out_tot grapher/oecd/2023-05-19/co2_air_transport/co2_air_transport#int_inb_out_tot   1                 
[]
         float 
[]
 a03ce6c3d5f8a3b76428a5a400afa53b 54ed09aaf6b59154c050696d603f4065
700031 Monthly CO₂ emissions from international aviation tonnes International aviation emissions are assigned to the country of departure. CO₂ emissions from commercial passenger flights only. 2023-05-26 09:31:12 2024-07-30 06:11:40       Air Transport CO2 Emissions 6018 Clarke et al. (2022) via OECD (2023) 28608 t 
{
    "unit": "tonnes",
    "zeroDay": "2019-01-01",
    "shortUnit": "t",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     ter_int_m grapher/oecd/2023-05-19/co2_air_transport/co2_air_transport#ter_int_m   1                 
[]
         float 
[]
 a7276472eb36448f3ba5be93f36eede3 e508d51e9e6cbca8a3b9e02b7dd4f304
700021 Monthly CO₂ emissions from domestic aviation tonnes Domestic aviation represents flights which depart and arrive within the same country. CO₂ emissions from commercial passenger flights only. 2023-05-26 09:31:12 2024-07-30 06:11:40       Air Transport CO2 Emissions 6018 Clarke et al. (2022) via OECD (2023) 28608 t 
{
    "unit": "tonnes",
    "zeroDay": "2019-01-01",
    "shortUnit": "t",
    "yearIsDay": true,
    "numDecimalPlaces": 0
}
 0     ter_dom_m grapher/oecd/2023-05-19/co2_air_transport/co2_air_transport#ter_dom_m   1                 
[]
         float 
[]
 17732e13bc9714a729092e62aac5b12e 12ff8f648e3dde9a1ddbb96e1aeed4ee
700017 Per capita CO₂ emissions from international flights, international tourism-adjusted. kilograms International aviation emissions are assigned to the country of departure. The term "per capita" indicates that the emissions are calculated on a per-person basis, taking into account the total population of the country. By using this measurement, we can understand the average amount of CO₂ emissions attributed to each individual as a result of domestic air travel. Data on carbon dioxide emissions from aviation are sourced from the OECD Air Transport CO₂ Emissions database. Our World in Data has calculated per capita aviation emissions by dividing these values by population figures for each country. These per capita footprints do not necessarily reflect the amount of travel by locals in a given location. This is especially true if a country has high tourist volumes: much of the departures will result from travellers rather than local residents. We have therefore also calculated 'adjusted' aviation footprints by multiplying per capita international CO₂ emissions by an adjustment factor. This adjustment factor is taken as the ratio between outbound and inbound tourist trips sourced from United Nations World Tourism Organization (UNWTO, 2023). A high ratio of outbound-to-inbound tourist trips indicates that a country receives less visitors than its residents travel abroad. This results in a relatively lower burden of emissions from international flights being allocated to the country whose residents don't travel internationally as frequently. Note that when an individual visits/leaves a country multiple times within a year, each visit is counted as a separate trip. CO₂ emissions from commercial passenger flights only. 2023-05-26 09:31:12 2024-07-30 06:11:39     2015-2021 Air Transport CO2 Emissions 6018 Clarke et al. (2022) via OECD (2023) 28608 kg 
{
    "unit": "kilograms",
    "shortUnit": "kg",
    "numDecimalPlaces": 0
}
 0     int_inb_out_per_capita grapher/oecd/2023-05-19/co2_air_transport/co2_air_transport#int_inb_out_per_capita   1                 
[]
         float 
[]
 f0a1b08d6069f5673c5194f94f8dd8c1 66e56408c87cfa6cae40c105f077892d
700016 Per capita CO₂ emissions from international aviation. kilograms   2023-05-26 09:31:12 2024-07-30 06:11:39     2015-2021 Air Transport CO2 Emissions 6018 Clarke et al. (2022) via OECD (2023) 28608 kg 
{
    "unit": "kilograms",
    "shortUnit": "kg",
    "numDecimalPlaces": 0
}
 0     per_capita_ter_int_a grapher/oecd/2023-05-19/co2_air_transport/co2_air_transport#per_capita_ter_int_a   1                 
[]
         float 
[]
 cc7686f193c5461d6a3939c27ab90d09 3f5a01e615a62d76d5891295308d05d8
700015 Per capita CO₂ emissions from domestic aviation kilograms Domestic aviation represents flights which depart and arrive within the same country. The term "per capita" indicates that the emissions are calculated on a per-person basis, taking into account the total population of the country. By using this measurement, we can understand the average amount of CO₂ emissions attributed to each individual as a result of domestic air travel. CO₂ emissions from commercial passenger flights only. 2023-05-26 09:31:12 2024-07-30 06:11:39     2015-2021 Air Transport CO2 Emissions 6018 Clarke et al. (2022) via OECD (2023) 28608 kg 
{
    "unit": "kilograms",
    "shortUnit": "kg",
    "numDecimalPlaces": 0
}
 0     per_capita_ter_dom_a grapher/oecd/2023-05-19/co2_air_transport/co2_air_transport#per_capita_ter_dom_a   1                 
[]
         float 
[]
 04d50152188ae7e57d69f668056d52b4 a3dfe9aa4261ae2c3d333ca7fac2e112
700013 Annual CO₂ emissions from international aviation tonnes International aviation emissions are assigned to the country of departure. CO₂ emissions from commercial passenger flights only. 2023-05-26 09:31:12 2024-07-30 06:11:39     2015-2021 Air Transport CO2 Emissions 6018 Clarke et al. (2022) via OECD (2023) 28608 t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     ter_int_a grapher/oecd/2023-05-19/co2_air_transport/co2_air_transport#ter_int_a   1                 
[]
         float 
[]
 c7708de07d4399d7e636a1b0bb5953b0 025b4a29932bea718933c46ce28f7af5
700012 Annual CO₂ emissions from domestic aviation tonnes Domestic aviation represents flights which depart and arrive within the same country. CO₂ emissions from commercial passenger flights only. 2023-05-26 09:31:12 2024-07-30 06:11:39     2015-2021 Air Transport CO2 Emissions 6018 Clarke et al. (2022) via OECD (2023) 28608 t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     ter_dom_a grapher/oecd/2023-05-19/co2_air_transport/co2_air_transport#ter_dom_a   1                 
[]
         float 
[]
 346a7012df7259ee9f69978bc7ad20f6 a795a051abf193972f16c45f188b3b14

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