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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt, 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
815668 Ban effective year     2023-10-24 14:45:49 2024-07-08 17:11:11     2023-2023 Fur banning 6280     
{}
 0     ban_effective_year grapher/animal_welfare/2023-10-24/fur_laws/fur_laws#ban_effective_year   2 minor           Year when the ban becomes effective. If the year is in the future, the ban is enacted but not yet in effect.   
[]
         int 
[]
 5b10e1593d14d1b4b84d8913528e2285 0e203511c9281deeab167ec8d98a85af
815667 Active fur farms     2023-10-24 14:45:48 2024-07-08 17:11:11     2023-2023 Fur banning 6280     
{}
 0     fur_farms_active grapher/animal_welfare/2023-10-24/fur_laws/fur_laws#fur_farms_active   2 minor           Countries that have operating fur farms.   
[]
       
{
    "map": {
        "hideTimeline": true
    },
    "title": "Which countries have active fur farms?"
}
 string 
[]
 99b1d1c6afb57c1fe4c66cfdae108fb0 c73eee062fb62598fc74a3c8e35d9c15
815666 Fur trade status     2023-10-24 14:45:48 2024-07-08 17:11:11     2023-2023 Fur banning 6280     
{}
 0     fur_trading_status grapher/animal_welfare/2023-10-24/fur_laws/fur_laws#fur_trading_status   2 minor           Countries that have banned fur trading at a national level.   
[]
       
{
    "map": {
        "hideTimeline": true
    },
    "note": "Partially banned means that there are bans at sub-national level or that only certain species are banned.",
    "title": "Which countries have banned fur trading?"
}
 string 
[]
 fa5f378cb574a22a90b9a3270dfff240 bfbb4a861a51ed68fd8181f1308c4ddc
815665 Fur farming status     2023-10-24 14:45:48 2024-07-08 17:11:11     2023-2023 Fur banning 6280     
{}
 0     fur_farming_status grapher/animal_welfare/2023-10-24/fur_laws/fur_laws#fur_farming_status   2 minor           Countries that have banned fur farming at a national level.   
[]
       
{
    "map": {
        "hideTimeline": true
    },
    "note": "Partially banned means that farming is phasing out due to strong regulation, that there are bans at sub-national level, or that only certain species are banned.",
    "title": "Which countries have banned fur farming?"
}
 string 
[]
 bfde86db3bf4306e2829e986f1f15631 606fa031af1feb13816ad7f9c3c8ae36

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