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

23 rows where sourceId = 17893 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: updatedAt, 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
143538 Per capita aviation CO2 - adjusted     2020-09-01 15:43:23 2023-07-07 10:08:18       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{
    "name": "Per capita CO\u2082 emissions from aviation, tourism-adjusted",
    "unit": "kilograms",
    "shortUnit": "kg",
    "includeInTable": true,
    "conversionFactor": 1000,
    "numDecimalPlaces": 0
}
 0           1                                  
143537 Per capita total RPKs - adjusted     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143536 Per capita international CO2 - adjusted     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{
    "unit": "kilograms ",
    "shortUnit": "kg",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "conversionFactor": 1000,
    "numDecimalPlaces": 0
}
 0           1                                  
143535 Per capita international RPKs - adjusted     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143534 Inbound-outbound flight ratio     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143533 Per capita international aviation CO2     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143532 Per capita domestic aviation CO2     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{
    "name": "Per capita  CO\u2082 emissions from domestic aviation",
    "unit": "kilograms",
    "shortUnit": "kg",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "conversionFactor": 1000
}
 0           1                                  
143531 Per capita aviation CO2   Average per capita emissions of CO₂ from domestic and international passenger flights. International aviation emissions are allocated to the country of departure. 2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{
    "name": "Per capita CO\u2082 emissions from aviation",
    "unit": "kilograms",
    "shortUnit": "kg",
    "includeInTable": true,
    "conversionFactor": 1000
}
 0           1                                  
143530 Per capita international RPKs     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143529 Per capita domestic RPKs     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{
    "unit": "passenger kilometers",
    "shortUnit": "km",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "numDecimalPlaces": 0
}
 0           1                                  
143528 Per capita total RPKs     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143527 Total aviation CO2 (Mt)     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143526 Total RPKs (billions)     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143525 International aviation CO2 (Mt)     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{
    "name": "CO\u2082 emissions from international aviation",
    "unit": "tonnes",
    "shortUnit": "t",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
143524 International RPKs (billions)     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143523 Domestic aviation CO2 (Mt)     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{
    "name": "CO\u2082 emissions from domestic air travel",
    "unit": "tonnes",
    "shortUnit": "t",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "conversionFactor": 1000000,
    "numDecimalPlaces": 0
}
 0           1                                  
143522 Domestic RPKs (billions)     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143521 % global total RPKs     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143520 % global total CO2     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143519 % global international RPKs     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143518 % global international CO2     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143517 % global domestic RPKs     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{}
 0           1                                  
143516 % global domestic CO2     2020-09-01 15:43:23 2023-06-15 05:05:42       Aviation passenger kilometres and CO2 emissions (ICCT) 5163 Graver, Zhang & Rutherford (2019). International Council of Clean Transportation (ICCT). 17893   
{
    "name": "Share of global CO\u2082 emissions from domestic air travel",
    "unit": "%",
    "shortUnit": "%",
    "tableDisplay": {
        "hideAbsoluteChange": false,
        "hideRelativeChange": false
    },
    "includeInTable": true,
    "conversionFactor": 100,
    "numDecimalPlaces": 1
}
 0           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");