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

15 rows where datasetId = 6239 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, updatedAt, 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
814447 Total tonnes   2023-09-28 14:41:57 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     total grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#total   2                 
[]
         float 
[]
 efe08bce74ee996cbac33093072bbac6 2e8d41bd39dfcd672c99a31ba95b6b31
814446 Road marking coatings tonnes   2023-09-28 14:41:57 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     road_marking_coatings grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#road_marking_coatings   2             Road marking coatings are specialized paints or materials used to create road markings, such as lanes and pedestrian crossings, essential for road safety and traffic regulation. These coatings are designed to be highly durable, visible, and resistant to weather, abrasion, and chemicals, with some incorporating reflective elements to enhance visibility at night.   
[]
         float 
[]
 4fbfcf1efc4a35d906a592a441cf4c34 0ecfd48f37fe6127286048d3900445d8
814445 PVC tonnes   2023-09-28 14:41:57 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     pvc grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#pvc   2             Polyvinyl Chloride (PVC) is a durable, versatile plastic used in construction materials like pipes and cables, clothing, and inflatable structures due to its resistance to environmental conditions and chemicals. Its recycling is less common due to the presence of chlorine, but some specialized recycling facilities can handle PVC products.   
[]
         float 
[]
 3f70bf68e2f6a5b83a75125c6a16e1af fa08dd6c3065b700e2b9bce3821a3186
814444 PUR tonnes   2023-09-28 14:41:57 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     pur grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#pur   2             Polyurethane (PUR) is a versatile polymer known for its elasticity, durability, and resistance to abrasion, and it is commonly used in foam seating, insulation materials, elastomeric wheels and tires, and adhesives. Its recycling is less common due to challenges in breaking down its complex polymers, but some specialized facilities do recycle polyurethane products.   
[]
         float 
[]
 076718880f47e84bf1dd9cfd3254b486 85faa15b3a65a4f26523fbe759e862f2
814443 PS tonnes   2023-09-28 14:41:56 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     ps grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#ps   2             Polystyrene (PS) is a versatile plastic known for its rigidity, clarity, and heat resistance, and it is commonly used in food packaging, like disposable cups and trays, insulation, and consumer goods. While it is technically recyclable, the actual recycling rate is quite low due to economic and environmental issues associated with its recycling process.   
[]
         float 
[]
 dc0a70c890e4a81d3f745c88792e89de d884856cb9c13feb2030a35de07e20d1
814442 PP tonnes   2023-09-28 14:41:56 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     pp grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#pp   2             Polypropylene (PP) is a versatile, heat-resistant, and chemical-resistant plastic, commonly used in packaging, automotive components, textiles, and consumer goods.   
[]
         float 
[]
 36a1ced80a973fa468ee1c37e0a820a2 5d5112f28c0e3ee3dbcff22e982dda6d
814441 PET tonnes   2023-09-28 14:41:56 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     pet grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#pet   2             Polyethylene Terephthalate (PET) is a strong, lightweight, and recyclable plastic, often used to make containers like bottles and food packaging due to its clarity and ability to act as a barrier to moisture and gases. It is one of the most commonly recycled plastics, often used to create polyester fibers for textiles after recycling.   
[]
         float 
[]
 f7ae96e91165022d9f8194db4b9e07dd ee83be8a01f53de25439f07ce30a8038
814440 Other tonnes   2023-09-28 14:41:56 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     other grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#other   2                 
[]
         float 
[]
 ac258984fc6218bc17f2417a7f870c33 78ba3a7614fabce651158a5bb9b73d86
814439 Marine coatings tonnes   2023-09-28 14:41:56 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     marine_coatings grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#marine_coatings   2             Marine coatings are specialized protective coatings applied to ships, boats, and other marine structures to protect them from corrosion, fouling, and the harsh marine environment. These coatings are designed to be durable, resistant to saltwater, ultraviolet light, and harsh weather conditions, and are critical for extending the life of marine vessels and structures, improving their performance, and reducing maintenance costs.   
[]
         float 
[]
 05957c004c1b2ef32f2e432b8cb9fd7e 6e23b3f50aa3e47706a7586f7fc67f51
814438 LLDPE, LLDPE tonnes   2023-09-28 14:41:56 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     ldpe__lldpe grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#ldpe__lldpe   2             LLDPE (Linear Low-Density Polyethylene) is a type of polyethylene plastic that is known for its flexibility, toughness, and relative transparency. It's widely used in applications like plastic bags, films, containers, and tubing due to its high impact and puncture resistance.   
[]
         float 
[]
 97ade9e885f011fd6b6c7c0012d929ab a29fc5283f2813e6c00d2e4ab99e36d4
814437 HDPE tonnes   2023-09-28 14:41:55 2024-07-08 16:05:58     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     hdpe grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#hdpe   2             HDPE (High-Density Polyethylene) is a durable, chemical-resistant thermoplastic, widely used in containers, pipes, and outdoor furniture. It is lightweight, has high tensile strength, and is recyclable,   
[]
         float 
[]
 bbb46ca6db6bd35813dbda35a1722a29 f0dfb7a17941ad669ef813ef01ff9407
814436 Fibres tonnes   2023-09-28 14:41:55 2024-07-08 16:05:59     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     fibres grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#fibres   2             Fibres are elongated pieces or threads, having a length many times their diameter. They can be spun into yarn or made into fabric.   
[]
         float 
[]
 e05ef227ad626810aee4964cb7df3b8a e9a75467f31a32fb3d434f5a166bf199
814435 Elastomers tyres tonnes   2023-09-28 14:41:55 2024-07-08 16:05:58     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     elastomers__tyres grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#elastomers__tyres   2             Elastomers, known for their elasticity and resilience, are utilized in a diverse range of applications including tires, medical devices, footwear, seals and gaskets, sporting goods, adhesives, industrial hoses and belts, and various consumer products.   
[]
         float 
[]
 5adf8676279f65cccf423bbc732b3da7 97db5a8536baeedc32dbd2fa6239298e
814434 Bioplastics tonnes   2023-09-28 14:41:55 2024-07-08 16:05:58     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     bioplastics grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#bioplastics   2             Bioplastics, derived from renewable resources like corn starch and plant oils, offer an eco-friendly alternative to conventional plastics and are used in various applications including packaging, agriculture, and medical implants, with some being biodegradable and others non-biodegradable.   
[]
         float 
[]
 45d043249f93855d47957e97caf8d271 500733fc833fc98a81321d73646f01bb
814433 AB, ASA, SAN tonnes   2023-09-28 14:41:54 2024-07-08 16:05:58     1990-2019 Global Plastics Outlook - Plastics use by polymer 6239   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     abs__asa__san grapher/oecd/2023-09-21/plastic_use_polymer/plastic_use_polymer#abs__asa__san   2             AB (Acrylonitrile and Butadiene) specializes in oil-resistant applications like gaskets and hoses; ASA (Acrylonitrile, Styrene, and Acrylate) is valued for outdoor applications like siding and furniture due to its weather resistance and strength; and SAN (Styrene and Acrylonitrile) is prevalent in consumer goods like food packaging and kitchenware for its transparency and durability.   
[]
         float 
[]
 9e32073a6fc43c4869757d340a791b9b aa5d14b0aa814d099edff1cf9a433b90

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