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

4 rows where datasetId = 6237 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, 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
814609 Share of plastic leakage accumulated - projections - Water source: Ocean %   2023-09-29 14:16:54 2024-07-08 17:10:09     2019-2060 Global Plastics Outlook - Plastic leakage to aquatic environments - projections 6237   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__water_source_ocean grapher/oecd/2023-09-21/plastic_aquatic_leakage_projections/plastic_aquatic_leakage_projections#share__water_source_ocean 
{
    "filters": [
        {
            "name": "water_source",
            "value": "Ocean"
        }
    ],
    "originalName": "Share of plastic leakage accumulated - projections",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 6928eb1296d935a6c14df31d06c5a275 5edf6996db8c3321d9fd8bf042543898
814608 Share of plastic leakage accumulated - projections - Water source: Freshwater %   2023-09-29 14:16:54 2024-07-08 17:10:09     2019-2060 Global Plastics Outlook - Plastic leakage to aquatic environments - projections 6237   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 2
}
 0     share__water_source_freshwater grapher/oecd/2023-09-21/plastic_aquatic_leakage_projections/plastic_aquatic_leakage_projections#share__water_source_freshwater 
{
    "filters": [
        {
            "name": "water_source",
            "value": "Freshwater"
        }
    ],
    "originalName": "Share of plastic leakage accumulated - projections",
    "originalShortName": "share"
}
 2                 
[]
         float 
[]
 066dfe32a1650196007e99e174fa7eeb 3ea7ff667e474bcaf9d1d3254a749aef
814338 Plastic leakage accumulated - projections - Water source: Ocean tonnes   2023-09-28 14:41:37 2024-07-08 17:10:09     2019-2060 Global Plastics Outlook - Plastic leakage to aquatic environments - projections 6237   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "isProjection": true,
    "numDecimalPlaces": 0
}
 0     value__water_source_ocean grapher/oecd/2023-09-21/plastic_aquatic_leakage_projections/plastic_aquatic_leakage_projections#value__water_source_ocean 
{
    "filters": [
        {
            "name": "water_source",
            "value": "Ocean"
        }
    ],
    "originalName": "Plastic leakage accumulated - projections",
    "originalShortName": "value"
}
 2                 
[]
         float 
[]
 1e40e4eb8daa6f7ce9e819b831343695 58f9d21f3f237ca9a5fa81c39e272668
814337 Plastic leakage accumulated - projections - Water source: Freshwater tonnes   2023-09-28 14:41:36 2024-07-08 17:10:09     2019-2060 Global Plastics Outlook - Plastic leakage to aquatic environments - projections 6237   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "isProjection": true,
    "numDecimalPlaces": 0
}
 0     value__water_source_freshwater grapher/oecd/2023-09-21/plastic_aquatic_leakage_projections/plastic_aquatic_leakage_projections#value__water_source_freshwater 
{
    "filters": [
        {
            "name": "water_source",
            "value": "Freshwater"
        }
    ],
    "originalName": "Plastic leakage accumulated - projections",
    "originalShortName": "value"
}
 2                 
[]
         float 
[]
 2c8aef2424d03d3af9b1a18982cb6770 11e87aeb0126090e136c564cdb98ae65

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