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

3 rows where sourceId = 29449 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, timespan, 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
801242 15.6.1 - Total reported number of Standard Material Transfer Agreements (SMTAs) transferring plant genetic resources for food and agriculture to the country (number) - ER_CBD_SMTA number Total reported number of Standard Material Transfer Agreements (SMTAs) transferring plant genetic resources for food and agriculture to the country (number) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-15-06-01.pdf 2023-08-17 17:03:41 2024-07-08 16:15:14     2012-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 International Treaty on Plant Genetic Resources for Food and Agriculture Secretariat 29449   
{
    "unit": "number"
}
 0     _15_6_1__er_cbd_smta grapher/un/2023-08-16/un_sdg/_15_6_1__er_cbd_smta#_15_6_1__er_cbd_smta   1                 
[]
         int 
[]
 499ffa8c7bce8a581dcbc5923315ce9f e92fd8ab1ee34ccbb043214d43929d0f
801241 15.6.1 - Countries that are contracting Parties to the International Treaty on Plant Genetic Resources for Food and Agriculture (PGRFA) (1 = YES; 0 = NO) - ER_CBD_PTYPGRFA number Countries that are contracting Parties to the International Treaty on Plant Genetic Resources for Food and Agriculture (PGRFA) (1 = YES; 0 = NO) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-15-06-01.pdf 2023-08-17 17:03:40 2024-07-08 16:15:14     2012-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 International Treaty on Plant Genetic Resources for Food and Agriculture Secretariat 29449   
{
    "unit": "number"
}
 0     _15_6_1__er_cbd_ptypgrfa grapher/un/2023-08-16/un_sdg/_15_6_1__er_cbd_ptypgrfa#_15_6_1__er_cbd_ptypgrfa   1                 
[]
         int 
[]
 fee682f9911db68fc2871992d0568868 d5840c2d1bf580dbf9d3397f89494c48
801240 15.6.1 - Countries that have legislative, administrative and policy framework or measures reported through the Online Reporting System on Compliance of the International Treaty on Plant Genetic Resources for Food and Agriculture (PGRFA) (1 = YES; 0 = NO) - ER_CBD_ORSPGRFA number Countries that have legislative, administrative and policy framework or measures reported through the Online Reporting System on Compliance of the International Treaty on Plant Genetic Resources for Food and Agriculture (PGRFA) (1 = YES; 0 = NO) Further information available at: https://unstats.un.org/sdgs/metadata/files/Metadata-15-06-01.pdf 2023-08-17 17:03:40 2024-07-08 16:15:14     2016-2022 United Nations Sustainable Development Goals (2023-Q2) 6193 International Treaty on Plant Genetic Resources for Food and Agriculture Secretariat 29449   
{
    "unit": "number"
}
 0     _15_6_1__er_cbd_orspgrfa grapher/un/2023-08-16/un_sdg/_15_6_1__er_cbd_orspgrfa#_15_6_1__er_cbd_orspgrfa   1                 
[]
         int 
[]
 3bb09f0e116e84fa1800beecb3e84b89 d84078f3574afaf1f42ad84bdc9e5332

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