variables
Data license: CC-BY
8 rows where datasetId = 5164 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 143548 | RPKs | The number of revenue passengers carried multiplied by the distance flown. | 2020-09-07 12:54:22 | 2023-06-15 05:05:42 | Global airline traffic and capacity (ICAO) 5164 | International Civil Aviation Organization via Airlines for America (2023) 17894 | {
"name": "Airline revenue passenger kilometers",
"unit": "kilometers",
"shortUnit": "km",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 143547 | PLF | The passenger load factor (PLF) measures the ratio of actual passengers to the available seats. It effectively measures the percentage of available seats that are taken by actual passengers. | 2020-09-07 12:54:22 | 2023-06-15 05:05:42 | Global airline traffic and capacity (ICAO) 5164 | International Civil Aviation Organization via Airlines for America (2023) 17894 | {
"name": "Global airline passenger load factor",
"unit": "%",
"shortUnit": "%",
"includeInTable": true,
"conversionFactor": 100,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 143546 | Passengers | 2020-09-07 12:54:22 | 2023-06-15 05:05:42 | Global airline traffic and capacity (ICAO) 5164 | International Civil Aviation Organization via Airlines for America (2023) 17894 | {
"name": "Global number of airline passengers",
"unit": "passengers",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | ||||||||||||||||||||||||||||
| 143544 | Freight Tonnes | The number of revenue tonnes of freight transported by air. | 2020-09-07 12:54:22 | 2023-06-15 05:05:42 | Global airline traffic and capacity (ICAO) 5164 | International Civil Aviation Organization via Airlines for America (2023) 17894 | {
"name": "Freight tonnes",
"unit": "tonnes",
"shortUnit": "t",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 143542 | Cargo RTKs | The number of revenue tonnes of cargo (freight and mail) carried multiplied by the distance flown. | 2020-09-07 12:54:22 | 2023-06-15 05:05:42 | Global airline traffic and capacity (ICAO) 5164 | International Civil Aviation Organization via Airlines for America (2023) 17894 | {
"name": "Cargo revenue tonne kilometers",
"unit": "tonne kilometers",
"shortUnit": "t-km",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 143541 | ASKs | In the airline industry available kilometers is a measure of passenger carrying capacity. It is equal to the number of seats available multiplied by the number of kilometers flown. An available seat km is the fundamental unit of production for a passenger-carrying airline. | 2020-09-07 12:54:22 | 2023-06-15 05:05:42 | Global airline traffic and capacity (ICAO) 5164 | International Civil Aviation Organization via Airlines for America (2023) 17894 | {
"name": "Available seat kilometers",
"unit": "available seat kilometers",
"shortUnit": "km",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | |||||||||||||||||||||||||||
| 143540 | Aircraft KMs | 2020-09-07 12:54:22 | 2023-06-15 05:05:42 | Global airline traffic and capacity (ICAO) 5164 | International Civil Aviation Organization via Airlines for America (2023) 17894 | {
"name": "Aircraft travel distance",
"unit": "kilometers",
"shortUnit": "km",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 | ||||||||||||||||||||||||||||
| 143539 | Aircraft Departures | 2020-09-07 12:54:22 | 2023-06-15 05:05:42 | Global airline traffic and capacity (ICAO) 5164 | International Civil Aviation Organization via Airlines for America (2023) 17894 | {
"name": "Global aircraft departures",
"unit": "departures",
"includeInTable": true,
"numDecimalPlaces": 0
} |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");