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

8 rows where datasetId = 6242 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
814645 Share of plastic leakage to aquatic envrionment - Leakage type: Transport to oceans %   2023-09-29 14:17:07 2024-07-08 17:02:47     2000-2019 Global Plastics Outlook - Plastic leakage to aquatic environments 6242   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__leakage_type_transport_to_oceans grapher/oecd/2023-09-21/plastic_aquatic_leakage/plastic_aquatic_leakage#share__leakage_type_transport_to_oceans 
{
    "filters": [
        {
            "name": "leakage_type",
            "value": "Transport to oceans"
        }
    ],
    "originalName": "Share of plastic leakage to aquatic envrionment",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 f024480786760e77068cb8255d549465 f68cdb79d6b70fdfc7a52265cfa7a21a
814644 Share of plastic leakage to aquatic envrionment - Leakage type: Plastic leakage to water from mismanaged waste and litter %   2023-09-29 14:17:07 2024-07-08 17:02:47     2000-2019 Global Plastics Outlook - Plastic leakage to aquatic environments 6242   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__leakage_type_plastic_leakage_to_water_from_mismanaged_waste_and_litter grapher/oecd/2023-09-21/plastic_aquatic_leakage/plastic_aquatic_leakage#share__leakage_type_plastic_leakage_to_water_from_mismanaged_waste_and_litter 
{
    "filters": [
        {
            "name": "leakage_type",
            "value": "Plastic leakage to water from mismanaged waste and litter"
        }
    ],
    "originalName": "Share of plastic leakage to aquatic envrionment",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 b127bebb3897c05b41ca7466ea748d21 558f5a59594c3dea0d42dfd646314d64
814643 Share of plastic leakage to aquatic envrionment - Leakage type: Accumulated stock in rivers and lakes %   2023-09-29 14:17:07 2024-07-08 17:02:46     2000-2019 Global Plastics Outlook - Plastic leakage to aquatic environments 6242   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__leakage_type_accumulated_stock_in_rivers_and_lakes grapher/oecd/2023-09-21/plastic_aquatic_leakage/plastic_aquatic_leakage#share__leakage_type_accumulated_stock_in_rivers_and_lakes 
{
    "filters": [
        {
            "name": "leakage_type",
            "value": "Accumulated stock in rivers and lakes"
        }
    ],
    "originalName": "Share of plastic leakage to aquatic envrionment",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 6d68d195b7a215301c5c7bab4507df0d bebb602309f2534a673e4f34fce0e9eb
814642 Share of plastic leakage to aquatic envrionment - Leakage type: Accumulated stock in oceans %   2023-09-29 14:17:06 2024-07-08 17:02:46     2000-2019 Global Plastics Outlook - Plastic leakage to aquatic environments 6242   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__leakage_type_accumulated_stock_in_oceans grapher/oecd/2023-09-21/plastic_aquatic_leakage/plastic_aquatic_leakage#share__leakage_type_accumulated_stock_in_oceans 
{
    "filters": [
        {
            "name": "leakage_type",
            "value": "Accumulated stock in oceans"
        }
    ],
    "originalName": "Share of plastic leakage to aquatic envrionment",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 e403072e469b30b861e977f81930814d c6cf661b01702c8cbed0741f2ea3af1d
814465 Plastic leakage to aquatic envrionment - Leakage type: Transport to oceans tonnes   2023-09-28 14:42:09 2024-07-08 17:02:47     2000-2019 Global Plastics Outlook - Plastic leakage to aquatic environments 6242   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     value__leakage_type_transport_to_oceans grapher/oecd/2023-09-21/plastic_aquatic_leakage/plastic_aquatic_leakage#value__leakage_type_transport_to_oceans 
{
    "filters": [
        {
            "name": "leakage_type",
            "value": "Transport to oceans"
        }
    ],
    "originalName": "Plastic leakage to aquatic envrionment",
    "originalShortName": "value"
}
 2                 
[]
         float 
[]
 8df953f10a0cb144ac25ab984e74301b 49d38187ba7d289e2a1af71a2a03fe57
814464 Plastic leakage to aquatic envrionment - Leakage type: Plastic leakage to water from mismanaged waste and litter tonnes   2023-09-28 14:42:09 2024-07-08 17:02:46     2000-2019 Global Plastics Outlook - Plastic leakage to aquatic environments 6242   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     value__leakage_type_plastic_leakage_to_water_from_mismanaged_waste_and_litter grapher/oecd/2023-09-21/plastic_aquatic_leakage/plastic_aquatic_leakage#value__leakage_type_plastic_leakage_to_water_from_mismanaged_waste_and_litter 
{
    "filters": [
        {
            "name": "leakage_type",
            "value": "Plastic leakage to water from mismanaged waste and litter"
        }
    ],
    "originalName": "Plastic leakage to aquatic envrionment",
    "originalShortName": "value"
}
 2                 
[]
         float 
[]
 fe73abfdbfaefd4b15e3ac459920570c b7c164303ba935e9827c5ecd77e0938e
814463 Plastic leakage to aquatic envrionment - Leakage type: Accumulated stock in rivers and lakes tonnes   2023-09-28 14:42:09 2024-07-08 17:02:46     2000-2019 Global Plastics Outlook - Plastic leakage to aquatic environments 6242   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     value__leakage_type_accumulated_stock_in_rivers_and_lakes grapher/oecd/2023-09-21/plastic_aquatic_leakage/plastic_aquatic_leakage#value__leakage_type_accumulated_stock_in_rivers_and_lakes 
{
    "filters": [
        {
            "name": "leakage_type",
            "value": "Accumulated stock in rivers and lakes"
        }
    ],
    "originalName": "Plastic leakage to aquatic envrionment",
    "originalShortName": "value"
}
 2                 
[]
         float 
[]
 7428fb73af0196b8738e3872ff2f8c48 7cbac64727faca9813bcfb7ef1e7d045
814462 Plastic leakage to aquatic envrionment - Leakage type: Accumulated stock in oceans tonnes   2023-09-28 14:42:08 2024-07-08 17:02:46     2000-2019 Global Plastics Outlook - Plastic leakage to aquatic environments 6242   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     value__leakage_type_accumulated_stock_in_oceans grapher/oecd/2023-09-21/plastic_aquatic_leakage/plastic_aquatic_leakage#value__leakage_type_accumulated_stock_in_oceans 
{
    "filters": [
        {
            "name": "leakage_type",
            "value": "Accumulated stock in oceans"
        }
    ],
    "originalName": "Plastic leakage to aquatic envrionment",
    "originalShortName": "value"
}
 2                 
[]
         float 
[]
 5e8c1dd84ee7fccb0940c115035993b4 aa96e2c81165fd16e59fc7bd1bf1254d

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