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

20 rows where datasetId = 6238 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, 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
815662 Share of plastic waste by application in 2019 - Entity: Sub-Saharan Africa %   2023-10-24 13:45:35 2024-07-08 16:49:51     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_sub_saharan_africa grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#share__entity_sub_saharan_africa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Sub-Saharan Africa"
        }
    ],
    "originalName": "Share of plastic waste by application in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 1db308413d1a60e69361386ea88ecb32 435d3428db29ba3009e4d34d9009ef03
815661 Plastic waste by application in 2019 - Entity: Sub-Saharan Africa tonnes   2023-10-24 13:45:35 2024-07-08 16:49:51     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_sub_saharan_africa grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#plastic_waste__entity_sub_saharan_africa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Sub-Saharan Africa"
        }
    ],
    "originalName": "Plastic waste by application in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 6d29b3e1f7a87031182fc26785a43a05 dc93c569fb78c2449363e88dc5c9dfa3
815660 Share of plastic waste by application in 2019 - Entity: Oceania %   2023-10-24 13:45:35 2024-07-08 16:49:51     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_oceania grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#share__entity_oceania 
{
    "filters": [
        {
            "name": "entity",
            "value": "Oceania"
        }
    ],
    "originalName": "Share of plastic waste by application in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 2ab049f46d65141b1c68371d61b94963 5226c5112f0e7a29207545e4fd6ca92f
815659 Plastic waste by application in 2019 - Entity: Oceania tonnes   2023-10-24 13:45:35 2024-07-08 16:49:51     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_oceania grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#plastic_waste__entity_oceania 
{
    "filters": [
        {
            "name": "entity",
            "value": "Oceania"
        }
    ],
    "originalName": "Plastic waste by application in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 2932fdc2475b60e5c1a0a341629bca46 4695792b18891f72f121f4cf59578d51
815658 Share of plastic waste by application in 2019 - Entity: Europe %   2023-10-24 13:45:34 2024-07-08 16:49:50     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_europe grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#share__entity_europe 
{
    "filters": [
        {
            "name": "entity",
            "value": "Europe"
        }
    ],
    "originalName": "Share of plastic waste by application in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 d73c79e39f7845c92d3a21450332da16 c4a4e0fc0e12d58b541bebcc6bbd008f
815657 Plastic waste by application in 2019 - Entity: Europe tonnes   2023-10-24 13:45:34 2024-07-08 16:49:50     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_europe grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#plastic_waste__entity_europe 
{
    "filters": [
        {
            "name": "entity",
            "value": "Europe"
        }
    ],
    "originalName": "Plastic waste by application in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 cadaae9b689f24fc3070938d72841240 020b9ae07ae1050b31c9b6b2d7db757e
815656 Share of plastic waste by application in 2019 - Entity: Asia (excl. China and India) %   2023-10-24 13:45:33 2024-07-08 16:49:50     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_asia__excl__china_and_india grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#share__entity_asia__excl__china_and_india 
{
    "filters": [
        {
            "name": "entity",
            "value": "Asia (excl. China and India)"
        }
    ],
    "originalName": "Share of plastic waste by application in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 c4a9bec6fbe538d34c2fcf2b463e59fa 0ffed8941a47eea1875b83fcd54ee2f7
815655 Plastic waste by application in 2019 - Entity: Asia (excl. China and India) tonnes   2023-10-24 13:45:33 2024-07-08 16:49:50     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_asia__excl__china_and_india grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#plastic_waste__entity_asia__excl__china_and_india 
{
    "filters": [
        {
            "name": "entity",
            "value": "Asia (excl. China and India)"
        }
    ],
    "originalName": "Plastic waste by application in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 b250ee0d1fc48fa8315bf7baebd85c01 bfc03e44da2dc172353a097653a5c7a1
815654 Share of plastic waste by application in 2019 - Entity: Americas (excl. USA) %   2023-10-24 13:45:33 2024-07-08 16:49:50     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_americas__excl__usa grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#share__entity_americas__excl__usa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Americas (excl. USA)"
        }
    ],
    "originalName": "Share of plastic waste by application in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 ac1331999a2ab41bffc36e9d6c5cac10 29edb4a0b2049eb7e4b41215ac4ec10f
815653 Plastic waste by application in 2019 - Entity: Americas (excl. USA) tonnes   2023-10-24 13:45:33 2024-07-08 16:49:50     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_americas__excl__usa grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#plastic_waste__entity_americas__excl__usa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Americas (excl. USA)"
        }
    ],
    "originalName": "Plastic waste by application in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 b227d8516ac202d4820ca67539560823 a3a6102b4355151890e4c8ccc323ab08
814641 Share of plastic waste by application in 2019 - Entity: World %   2023-09-29 14:17:02 2024-07-08 16:49:51     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_world grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#share__entity_world 
{
    "filters": [
        {
            "name": "entity",
            "value": "World"
        }
    ],
    "originalName": "Share of plastic waste by application in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 ee7c114b9733fb870c674ef64246808c a33e15d1156fedd5baa34571265bb533
814640 Plastic waste by application in 2019 - Entity: World tonnes   2023-09-29 14:17:02 2024-07-08 16:49:51     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_world grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#plastic_waste__entity_world 
{
    "filters": [
        {
            "name": "entity",
            "value": "World"
        }
    ],
    "originalName": "Plastic waste by application in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 2f1496e8ebd39b78aee50c78c7f4c025 decce030b819553ca6155f69d009366e
814639 Share of plastic waste by application in 2019 - Entity: United States %   2023-09-29 14:17:02 2024-07-08 16:49:51     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_united_states grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#share__entity_united_states 
{
    "filters": [
        {
            "name": "entity",
            "value": "United States"
        }
    ],
    "originalName": "Share of plastic waste by application in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 dee61832d14611fe3f586fbf8994ef7d fc732f532f4041abf35c8959cab76513
814638 Plastic waste by application in 2019 - Entity: United States tonnes   2023-09-29 14:17:02 2024-07-08 16:49:51     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_united_states grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#plastic_waste__entity_united_states 
{
    "filters": [
        {
            "name": "entity",
            "value": "United States"
        }
    ],
    "originalName": "Plastic waste by application in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 f94f5a426fd8ca8e9301faf1183a1cad 029e0f53d6c72cd8176683dc8ca71ee2
814619 Share of plastic waste by application in 2019 - Entity: Middle East & North Africa %   2023-09-29 14:17:00 2024-07-08 16:49:51     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_middle_east__and__north_africa grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#share__entity_middle_east__and__north_africa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Middle East & North Africa"
        }
    ],
    "originalName": "Share of plastic waste by application in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 5de622c7a8c2b770c5929dbfb9df0a19 e743ba63f7a4a20d01676283867310c3
814618 Plastic waste by application in 2019 - Entity: Middle East & North Africa tonnes   2023-09-29 14:17:00 2024-07-08 16:49:50     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_middle_east__and__north_africa grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#plastic_waste__entity_middle_east__and__north_africa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Middle East & North Africa"
        }
    ],
    "originalName": "Plastic waste by application in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 cc7b693e02152e4a75c30650ea4942f3 3ce1ed63611cee70eba9415ca75e760e
814615 Share of plastic waste by application in 2019 - Entity: India %   2023-09-29 14:16:59 2024-07-08 16:49:50     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_india grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#share__entity_india 
{
    "filters": [
        {
            "name": "entity",
            "value": "India"
        }
    ],
    "originalName": "Share of plastic waste by application in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 ebb29baba13b5b3c633ffb7909c312cb 133cf78ab6bdc0cd24efb9fa2870ccde
814614 Plastic waste by application in 2019 - Entity: India tonnes   2023-09-29 14:16:59 2024-07-08 16:49:51     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_india grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#plastic_waste__entity_india 
{
    "filters": [
        {
            "name": "entity",
            "value": "India"
        }
    ],
    "originalName": "Plastic waste by application in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 63db3020a55ebaedefb0fca1c2e484e6 411b48c205fa882e8dcba568f697cf0b
814613 Share of plastic waste by application in 2019 - Entity: China %   2023-09-29 14:16:59 2024-07-08 16:49:50     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_china grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#share__entity_china 
{
    "filters": [
        {
            "name": "entity",
            "value": "China"
        }
    ],
    "originalName": "Share of plastic waste by application in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 f5c1ad771ad73fe6637e3d6c2d6dd46b c28b32946e8cf38c191033e8995e1601
814612 Plastic waste by application in 2019 - Entity: China tonnes   2023-09-29 14:16:58 2024-07-08 16:49:50     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and application 6238   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_china grapher/oecd/2023-09-21/plastic_waste_2019/plastic_waste_2019#plastic_waste__entity_china 
{
    "filters": [
        {
            "name": "entity",
            "value": "China"
        }
    ],
    "originalName": "Plastic waste by application in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 53b9eee8ca21848ba949cbf521514f99 5e78793c65b0bfddd9d41a54d9055733

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