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

5 rows where sourceId = 29445 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, shortUnit, display, type, 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
801082 14.1.1 - Beach litter originating from national land-based sources that ends in the ocean (Tonnes) - EN_MAR_BEALIT_OV tonnes Beach litter originating from national land-based sources that ends in the ocean (Tonnes) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-14-01-01.pdf 2023-08-17 17:02:26 2024-07-08 16:15:05     2017-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 Centre for Ocean-Atmospheric Prediction Studies 29445   
{
    "unit": "tonnes"
}
 0     _14_1_1__en_mar_bealit_ov grapher/un/2023-08-16/un_sdg/_14_1_1__en_mar_bealit_ov#_14_1_1__en_mar_bealit_ov   1                 
[]
         int 
[]
 2a90c48e882484369d7e9dd74a1a8939 c76d806d954e0ae0c730536073f3a943
801081 14.1.1 - Beach litter originating from national land-based sources that ends in the ocean (%) - EN_MAR_BEALIT_OP % Beach litter originating from national land-based sources that ends in the ocean (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-14-01-01.pdf 2023-08-17 17:02:26 2024-07-08 16:15:05     2017-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 Centre for Ocean-Atmospheric Prediction Studies 29445 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _14_1_1__en_mar_bealit_op grapher/un/2023-08-16/un_sdg/_14_1_1__en_mar_bealit_op#_14_1_1__en_mar_bealit_op   1                 
[]
         float 
[]
 c54167fbbcd674275abbb7340262dbd8 90d65f3d0454461e7bdacb65cda15873
801080 14.1.1 - Exported beach litter originating from national land-based sources (Tonnes) - EN_MAR_BEALIT_EXP tonnes Exported beach litter originating from national land-based sources (Tonnes) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-14-01-01.pdf 2023-08-17 17:02:25 2024-07-08 16:15:05     2017-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 Centre for Ocean-Atmospheric Prediction Studies 29445   
{
    "unit": "tonnes"
}
 0     _14_1_1__en_mar_bealit_exp grapher/un/2023-08-16/un_sdg/_14_1_1__en_mar_bealit_exp#_14_1_1__en_mar_bealit_exp   1                 
[]
         int 
[]
 63a99da81c563d72e2d756131e35b9e0 45aba8a4287ecb3b42b0c0d9ba0e95c9
801079 14.1.1 - Beach litter originating from national land-based sources that ends in the beach (Tonnes) - EN_MAR_BEALIT_BV tonnes Beach litter originating from national land-based sources that ends in the beach (Tonnes) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-14-01-01.pdf 2023-08-17 17:02:25 2024-07-08 16:15:05     2017-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 Centre for Ocean-Atmospheric Prediction Studies 29445   
{
    "unit": "tonnes"
}
 0     _14_1_1__en_mar_bealit_bv grapher/un/2023-08-16/un_sdg/_14_1_1__en_mar_bealit_bv#_14_1_1__en_mar_bealit_bv   1                 
[]
         int 
[]
 3888f6d8c556637a0d38107faf333791 db4d3d650d88f12520c086440f03270b
801078 14.1.1 - Beach litter originating from national land-based sources that ends in the beach (%) - EN_MAR_BEALIT_BP % Beach litter originating from national land-based sources that ends in the beach (%) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-14-01-01.pdf 2023-08-17 17:02:24 2024-07-08 16:15:04     2017-2021 United Nations Sustainable Development Goals (2023-Q2) 6193 Centre for Ocean-Atmospheric Prediction Studies 29445 % 
{
    "unit": "%",
    "shortUnit": "%"
}
 0     _14_1_1__en_mar_bealit_bp grapher/un/2023-08-16/un_sdg/_14_1_1__en_mar_bealit_bp#_14_1_1__en_mar_bealit_bp   1                 
[]
         float 
[]
 dace099517a8ad35a4bebc8cd35c0a3e 1daecce6ad87dea1afa4ef598afc7dd9

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