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 = 6256 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
815652 Share of plastic waste by polymer in 2019 - Entity: Sub-Saharan Africa %   2023-10-24 13:45:29 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_sub_saharan_africa grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#share__entity_sub_saharan_africa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Sub-Saharan Africa"
        }
    ],
    "originalName": "Share of plastic waste by polymer in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 c3e8dac1caeebbb135b2f7f286e6e00f 76c3092e91d284384126ea92df8d6e76
815651 Plastic waste by polymer in 2019 - Entity: Sub-Saharan Africa tonnes   2023-10-24 13:45:29 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_sub_saharan_africa grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#plastic_waste__entity_sub_saharan_africa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Sub-Saharan Africa"
        }
    ],
    "originalName": "Plastic waste by polymer in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 176d38d52ce83b002c5414c855845481 a8d55f3ae1e8576bc4a43c1e96100ed7
815650 Share of plastic waste by polymer in 2019 - Entity: Oceania %   2023-10-24 13:45:29 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_oceania grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#share__entity_oceania 
{
    "filters": [
        {
            "name": "entity",
            "value": "Oceania"
        }
    ],
    "originalName": "Share of plastic waste by polymer in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 c703c6d8870d8ce11407cd4b223578b3 9433c935c0aa5e8101d5d9be7b46cdb0
815649 Plastic waste by polymer in 2019 - Entity: Oceania tonnes   2023-10-24 13:45:29 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_oceania grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#plastic_waste__entity_oceania 
{
    "filters": [
        {
            "name": "entity",
            "value": "Oceania"
        }
    ],
    "originalName": "Plastic waste by polymer in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 8a040db01b15601453898430faad9e60 82addacf17fb7bd4181b28555a5e91ad
815648 Share of plastic waste by polymer in 2019 - Entity: Europe %   2023-10-24 13:45:28 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_europe grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#share__entity_europe 
{
    "filters": [
        {
            "name": "entity",
            "value": "Europe"
        }
    ],
    "originalName": "Share of plastic waste by polymer in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 59c71baed251bea3039a72d7d431f65b d7ef985dd03f00b808dc8498f5d2627b
815647 Plastic waste by polymer in 2019 - Entity: Europe tonnes   2023-10-24 13:45:28 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_europe grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#plastic_waste__entity_europe 
{
    "filters": [
        {
            "name": "entity",
            "value": "Europe"
        }
    ],
    "originalName": "Plastic waste by polymer in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 1e3f446a15cb1bbb5b6008bb8572990c 467ee22a10f90e2bf70e0557312b1ba0
815646 Share of plastic waste by polymer in 2019 - Entity: Asia (excl. China and India) %   2023-10-24 13:45:27 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_asia__excl__china_and_india grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/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 polymer in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 72b8cc8feb15c1e17139457b2efebeb0 2d189bbc691f82e67a5348bc297aae5a
815645 Plastic waste by polymer in 2019 - Entity: Asia (excl. China and India) tonnes   2023-10-24 13:45:27 2024-07-08 18:05:39     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_asia__excl__china_and_india grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#plastic_waste__entity_asia__excl__china_and_india 
{
    "filters": [
        {
            "name": "entity",
            "value": "Asia (excl. China and India)"
        }
    ],
    "originalName": "Plastic waste by polymer in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 c1c597c9b6be336b4666bfb2f5823e49 b93582cb19a2e280b11b7e2fa70e89ce
815644 Share of plastic waste by polymer in 2019 - Entity: Americas (excl. USA) %   2023-10-24 13:45:27 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_americas__excl__usa grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#share__entity_americas__excl__usa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Americas (excl. USA)"
        }
    ],
    "originalName": "Share of plastic waste by polymer in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 4ac08801edc6ca12fa7d3be086bfa351 eace1a02c3ed4c8bbd5223649280f506
815643 Plastic waste by polymer in 2019 - Entity: Americas (excl. USA) tonnes   2023-10-24 13:45:26 2024-07-08 18:05:39     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_americas__excl__usa grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#plastic_waste__entity_americas__excl__usa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Americas (excl. USA)"
        }
    ],
    "originalName": "Plastic waste by polymer in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 36937015ac3366959a4c1367c5024fc3 327a65fa5839e84e261789e6ed79404d
814883 Share of plastic waste by polymer in 2019 - Entity: World %   2023-10-04 12:29:28 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_world grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#share__entity_world 
{
    "filters": [
        {
            "name": "entity",
            "value": "World"
        }
    ],
    "originalName": "Share of plastic waste by polymer in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 8adafca419650bb9b1c1f9018a03c24e c404f2fc511e9d449f512e369e3a4fdb
814882 Plastic waste by polymer in 2019 - Entity: World tonnes   2023-10-04 12:29:28 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_world grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#plastic_waste__entity_world 
{
    "filters": [
        {
            "name": "entity",
            "value": "World"
        }
    ],
    "originalName": "Plastic waste by polymer in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 f24d99d133e5e7140aee0f6e84487fc3 5352dd9ecd556447b1bf5e444f27e03e
814881 Share of plastic waste by polymer in 2019 - Entity: United States %   2023-10-04 12:29:28 2024-07-08 18:05:41     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_united_states grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#share__entity_united_states 
{
    "filters": [
        {
            "name": "entity",
            "value": "United States"
        }
    ],
    "originalName": "Share of plastic waste by polymer in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 cdfa4de955b0f88e737b186779efdd58 c5d4c8763bdf72409b45e00246fc2833
814880 Plastic waste by polymer in 2019 - Entity: United States tonnes   2023-10-04 12:29:28 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_united_states grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#plastic_waste__entity_united_states 
{
    "filters": [
        {
            "name": "entity",
            "value": "United States"
        }
    ],
    "originalName": "Plastic waste by polymer in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 88192b251ae751066d01313c1c0bcd63 cd12dc8086156eadb49e5a271c86aac3
814861 Share of plastic waste by polymer in 2019 - Entity: Middle East & North Africa %   2023-10-04 12:29:26 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_middle_east__and__north_africa grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#share__entity_middle_east__and__north_africa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Middle East & North Africa"
        }
    ],
    "originalName": "Share of plastic waste by polymer in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 3ea56905f187c6c37508c3b248e99a8a c0420fa47b11dad094aea4754f56999b
814860 Plastic waste by polymer in 2019 - Entity: Middle East & North Africa tonnes   2023-10-04 12:29:25 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_middle_east__and__north_africa grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#plastic_waste__entity_middle_east__and__north_africa 
{
    "filters": [
        {
            "name": "entity",
            "value": "Middle East & North Africa"
        }
    ],
    "originalName": "Plastic waste by polymer in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 5a927feed70c53259280fa3306a59bbe 35ca4a685fadcce98281581a5996fb5c
814857 Share of plastic waste by polymer in 2019 - Entity: India %   2023-10-04 12:29:25 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_india grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#share__entity_india 
{
    "filters": [
        {
            "name": "entity",
            "value": "India"
        }
    ],
    "originalName": "Share of plastic waste by polymer in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 2f08cdc060eeec697e3cf0420499b09d 5558aa63df7f1de8ba228ac30755b23c
814856 Plastic waste by polymer in 2019 - Entity: India tonnes   2023-10-04 12:29:25 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_india grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#plastic_waste__entity_india 
{
    "filters": [
        {
            "name": "entity",
            "value": "India"
        }
    ],
    "originalName": "Plastic waste by polymer in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 7a99ddbf3819f707d63fb436a9fe6b06 0f5cda1f41fb7912d290289f266e6479
814855 Share of plastic waste by polymer in 2019 - Entity: China %   2023-10-04 12:29:25 2024-07-08 18:05:40     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__entity_china grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#share__entity_china 
{
    "filters": [
        {
            "name": "entity",
            "value": "China"
        }
    ],
    "originalName": "Share of plastic waste by polymer in 2019",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 aee52fb17c70fb3844f750611821e476 0be745df57a8b9f2e6b23ee38b980e8a
814854 Plastic waste by polymer in 2019 - Entity: China tonnes   2023-10-04 12:29:24 2024-07-08 18:05:39     2019-2019 Global Plastics Outlook - Plastics waste in 2019 by region and polymer 6256   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     plastic_waste__entity_china grapher/oecd/2023-09-21/plastic_waste_2019_by_polymer/plastic_waste_2019#plastic_waste__entity_china 
{
    "filters": [
        {
            "name": "entity",
            "value": "China"
        }
    ],
    "originalName": "Plastic waste by polymer in 2019",
    "originalShortName": "plastic_waste"
}
 2                 
[]
         float 
[]
 390106eaa99470896e9ba07e09868ff9 1819ac9610a7f9f88581155bba8ea58d

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