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

12 rows where datasetId = 4193 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
104655 Bowhead whale (Rocha et al. & IWC)   The number of bowhead whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 11:56:29 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "Bowhead whales",
    "unit": "whales killed",
    "numDecimalPlaces": 0
}
 0           1                                  
104653 All species (Rocha et al. & IWC)   The total number of whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "All whale species",
    "unit": "whales caught",
    "numDecimalPlaces": 0
}
 0           1                                  
104652 Unspecified/Other (Rocha et al. & IWC)   The number of unspecified/other whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "Unspecified/Other",
    "unit": "whales caught",
    "numDecimalPlaces": 0
}
 0           1                                  
104651 Right whale (Rocha et al. & IWC)   The number of right whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "Right whale",
    "unit": "whales caught",
    "numDecimalPlaces": 0
}
 0           1                                  
104650 Gray whale (Rocha et al. & IWC)   The number of gray whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "Gray whale",
    "unit": "whales caught",
    "numDecimalPlaces": 0
}
 0           1                                  
104649 Minke whale (Rocha et al. & IWC)   The number of Minke whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "Minke whale",
    "unit": "whales caught",
    "numDecimalPlaces": 0
}
 0           1                                  
104648 Bryde's whale (Rocha et al. & IWC)   The number of Bryde's whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "Bryde's whale",
    "unit": "whales caught",
    "numDecimalPlaces": 0
}
 0           1                                  
104647 Sei whale (Rocha et al. & IWC)     2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{}
 0           1                                  
104646 Humpback whale (Rocha et al. & IWC)   The number of humpback whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "Humpback whale",
    "unit": "whales caught",
    "numDecimalPlaces": 0
}
 0           1                                  
104645 Sperm whale (Rocha et al. & IWC)   The number of sperm whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "Sperm whale",
    "unit": "whales caught",
    "numDecimalPlaces": 0
}
 0           1                                  
104644 Fin whale (Rocha et al. & IWC)   The number of fin whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "Fin whale",
    "unit": "whales caught",
    "numDecimalPlaces": 0
}
 0           1                                  
104643 Blue whale (Rocha et al. & IWC)   The number of blue whales caught by decade, where '1900' is the total from 1900 to 1909; '1910' is the total from 1910 to 1919 etc. 2019-08-28 09:27:09 2023-06-15 05:05:42       Whale catch by decade (Rocha et al. & IWC) 4193 Whale catch by decade (Rocha et al. & IWC) 17021   
{
    "name": "Blue whale",
    "unit": "whales caught",
    "numDecimalPlaces": 0
}
 0           1                                  

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