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 = 6246 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, 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
814478 Nitrous oxide tonnes of CO₂ equivalent   2023-09-28 14:42:24 2024-07-08 16:38:46     2015-2019 Global Plastics Outlook - Greenhouse gas emissions from primary plastics 6246   t 
{
    "unit": "tonnes of CO\u2082 equivalent",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     n2o grapher/oecd/2023-09-21/plastic_emissions/plastic_emissions#n2o   2                 
[]
         float 
[]
 51ca6d07dccbd392e650e57b7c540cce b7e3564651d6fef18225bbfdca7d1e07
814477 Carbon dioxide tonnes of CO₂ equivalent   2023-09-28 14:42:23 2024-07-08 16:38:46     2015-2019 Global Plastics Outlook - Greenhouse gas emissions from primary plastics 6246   t 
{
    "unit": "tonnes of CO\u2082 equivalent",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     co2 grapher/oecd/2023-09-21/plastic_emissions/plastic_emissions#co2   2                 
[]
         float 
[]
 96ba024ee7fc2ba59f77245a6479a396 f1313d5928416e18a72520b6dc79c984
814476 All greenhouse gases tonnes of CO₂ equivalent   2023-09-28 14:42:23 2024-07-08 16:38:46     2015-2019 Global Plastics Outlook - Greenhouse gas emissions from primary plastics 6246   t 
{
    "unit": "tonnes of CO\u2082 equivalent",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     all_greenhouse_gases grapher/oecd/2023-09-21/plastic_emissions/plastic_emissions#all_greenhouse_gases   2                 
[]
         float 
[]
 1d55a40408774b0851070359f0343173 fac249e4e824e66bc44f8aaa7d6451d4
814475 Methane tonnes of CO₂ equivalent   2023-09-28 14:42:23 2024-07-08 16:38:46     2015-2019 Global Plastics Outlook - Greenhouse gas emissions from primary plastics 6246   t 
{
    "unit": "tonnes of CO\u2082 equivalent",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     ch4 grapher/oecd/2023-09-21/plastic_emissions/plastic_emissions#ch4   2                 
[]
         float 
[]
 fd5b7e29b25cbfb8fd903310c1ea91e5 527ff5bcbe88b3442623824905586514

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