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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: 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
176303 Freshwater use (m3 / kg edible weight)   Freshwater use per kilogram of seafood production. This is measured by edible weight. 2021-09-16 09:14:24 2023-06-15 05:05:42       Environmental impacts of seafood (Gephart et al. 2021) 5373 Gephart et al. (2021). Environmental performance of blue foods. Nature. 20617   
{
    "name": "Freshwater use per kilogram of seafood production",
    "unit": "m\u00b3 per kilogram",
    "shortUnit": "m\u00b3",
    "includeInTable": true
}
 0           1                                  
176302 Phosphorous (kgP / t edible weight)   The amount of phosphorous pollution generated per tonne of seafood production. This is measured by edible weight. 2021-09-16 09:14:24 2023-06-15 05:05:42       Environmental impacts of seafood (Gephart et al. 2021) 5373 Gephart et al. (2021). Environmental performance of blue foods. Nature. 20617   
{
    "name": "Phosphorous emissions per tonne of seafood",
    "unit": "kilograms of phosphorous per tonne",
    "shortUnit": "kg",
    "includeInTable": true
}
 0           1                                  
176301 Nitrogen (kgN / t edible weight)   The amount of nitrogen pollution generated per tonne of seafood production. This is measured by edible weight. 2021-09-16 09:14:24 2023-06-15 05:05:42       Environmental impacts of seafood (Gephart et al. 2021) 5373 Gephart et al. (2021). Environmental performance of blue foods. Nature. 20617   
{
    "name": "Nitrogen emissions per tonne of seafood",
    "unit": "kilograms of nitrogen per tonne",
    "shortUnit": "kg",
    "includeInTable": true
}
 0           1                                  
176300 Land use (m2 / kg edible weight)   Land use includes land used for aquaculture farms plus land for feed production. This is given per kilogram of fish or seafood by edible weight. 2021-09-16 09:14:24 2023-06-15 05:05:42       Environmental impacts of seafood (Gephart et al. 2021) 5373 Gephart et al. (2021). Environmental performance of blue foods. Nature. 20617   
{
    "name": "Land use per kilogram of seafood",
    "unit": "m\u00b2 per kg",
    "shortUnit": "m\u00b2",
    "includeInTable": true
}
 0           1                                  
176299 Greenhouse gas emissions (kg / kg edible weight)   Emissions are given per kilogram of fish or seafood by edible weight. 2021-09-16 09:14:24 2023-06-15 05:05:42       Environmental impacts of seafood (Gephart et al. 2021) 5373 Gephart et al. (2021). Environmental performance of blue foods. Nature. 20617   
{
    "name": "Greenhouse gas emissions per kilogram of seafood",
    "unit": "kg CO\u2082e per kg",
    "shortUnit": "kg",
    "includeInTable": true
}
 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");