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

9 rows where datasetId = 6175 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, shortUnit, display, licenses, 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
812573 Estimated number of farmed finfish killed for food per person (upper bound) fish per person   2023-09-21 14:50:51 2024-07-25 23:11:52     1990-2019 Number of farmed fish killed for food worldwide 6175     
{
    "unit": "fish per person",
    "numDecimalPlaces": 2
}
 0     n_fish_high_per_capita grapher/animal_welfare/2023-08-08/farmed_finfishes_used_for_food/farmed_finfishes_used_for_food#n_fish_high_per_capita   2 major               
[]
   
[
    {
        "url": "https://s100.copyright.com/AppDispatchServlet?publisherName=CUP&publication=AWF&title=Estimating%20global%20numbers%20of%20farmed%20fishes%20killed%20for%20food%20annually%20from%201990%20to%202019&publicationDate=06%20February%202023&author=Alison%20Mood%2C%20Elena%20Lara%2C%20Natasha%20K%20Boyland%2C%20Phil%20Brooke&copyright=%C2%A9%20The%20Author(s)%2C%202023.%20Published%20by%20Cambridge%20University%20Press%20on%20behalf%20of%20The%20Universities%20Federation%20for%20Animal%20Welfare&contentID=10.1017%2Fawf.2023.4&startPage=&endPage=&orderBeanReset=True&volumeNum=32&issueNum=&oa=CC-BY",
        "name": "Creative Commons CC BY"
    },
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
   
{
    "hasMapTab": false
}
 float 
[]
 cdbb685083e10b4dbced92979aa8fa93 675c2368f5acd568792711709c3b337a
812572 Estimated number of farmed finfish killed for food per person fish per person   2023-09-21 14:50:51 2024-07-25 23:11:52     1990-2019 Number of farmed fish killed for food worldwide 6175     
{
    "unit": "fish per person",
    "numDecimalPlaces": 2
}
 0     n_fish_per_capita grapher/animal_welfare/2023-08-08/farmed_finfishes_used_for_food/farmed_finfishes_used_for_food#n_fish_per_capita   2 major           Finfish refers to any fish with fins, as opposed to shellfish.   
[]
   
[
    {
        "url": "https://s100.copyright.com/AppDispatchServlet?publisherName=CUP&publication=AWF&title=Estimating%20global%20numbers%20of%20farmed%20fishes%20killed%20for%20food%20annually%20from%201990%20to%202019&publicationDate=06%20February%202023&author=Alison%20Mood%2C%20Elena%20Lara%2C%20Natasha%20K%20Boyland%2C%20Phil%20Brooke&copyright=%C2%A9%20The%20Author(s)%2C%202023.%20Published%20by%20Cambridge%20University%20Press%20on%20behalf%20of%20The%20Universities%20Federation%20for%20Animal%20Welfare&contentID=10.1017%2Fawf.2023.4&startPage=&endPage=&orderBeanReset=True&volumeNum=32&issueNum=&oa=CC-BY",
        "name": "Creative Commons CC BY"
    },
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
   
{
    "hasMapTab": false
}
 float 
[]
 ae2465c50b2da3f5b418d34e1da6f9db 434ea91a8294d0dd5124b81e8b062c98
812571 Estimated number of farmed finfish killed for food per person (lower bound) fish per person   2023-09-21 14:50:51 2024-07-25 23:11:52     1990-2019 Number of farmed fish killed for food worldwide 6175     
{
    "unit": "fish per person",
    "numDecimalPlaces": 2
}
 0     n_fish_low_per_capita grapher/animal_welfare/2023-08-08/farmed_finfishes_used_for_food/farmed_finfishes_used_for_food#n_fish_low_per_capita   2 major               
[]
   
[
    {
        "url": "https://s100.copyright.com/AppDispatchServlet?publisherName=CUP&publication=AWF&title=Estimating%20global%20numbers%20of%20farmed%20fishes%20killed%20for%20food%20annually%20from%201990%20to%202019&publicationDate=06%20February%202023&author=Alison%20Mood%2C%20Elena%20Lara%2C%20Natasha%20K%20Boyland%2C%20Phil%20Brooke&copyright=%C2%A9%20The%20Author(s)%2C%202023.%20Published%20by%20Cambridge%20University%20Press%20on%20behalf%20of%20The%20Universities%20Federation%20for%20Animal%20Welfare&contentID=10.1017%2Fawf.2023.4&startPage=&endPage=&orderBeanReset=True&volumeNum=32&issueNum=&oa=CC-BY",
        "name": "Creative Commons CC BY"
    },
    {
        "url": "https://docs.google.com/document/d/1-RmthhS2EPMK_HIpnPctcXpB0n7ADSWnXa5Hb3PxNq4/edit?usp=sharing",
        "name": "Creative Commons BY 4.0"
    },
    {
        "url": "https://dataportaal.pbl.nl/downloads/HYDE/HYDE3.2/readme_release_HYDE3.2.1.txt",
        "name": "CC BY 3.0"
    },
    {
        "url": "http://creativecommons.org/licenses/by/3.0/igo/",
        "name": "CC BY 3.0 IGO"
    }
]
   
{
    "hasMapTab": false
}
 float 
[]
 c5ef3503d4443d04cc2c6cbc1a762623 3d324278da63094f46f79e2dc2a197a5
789700 Estimated number of farmed finfish relative to 1990 %   2023-08-09 15:06:42 2024-07-25 23:11:52     1990-2019 Number of farmed fish killed for food worldwide 6175   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 0
}
 0     n_fish_relative_to_1990 grapher/animal_welfare/2023-08-08/farmed_finfishes_used_for_food/farmed_finfishes_used_for_food#n_fish_relative_to_1990   2                 
[]
   
[
    {
        "url": "https://s100.copyright.com/AppDispatchServlet?publisherName=CUP&publication=AWF&title=Estimating%20global%20numbers%20of%20farmed%20fishes%20killed%20for%20food%20annually%20from%201990%20to%202019&publicationDate=06%20February%202023&author=Alison%20Mood%2C%20Elena%20Lara%2C%20Natasha%20K%20Boyland%2C%20Phil%20Brooke&copyright=%C2%A9%20The%20Author(s)%2C%202023.%20Published%20by%20Cambridge%20University%20Press%20on%20behalf%20of%20The%20Universities%20Federation%20for%20Animal%20Welfare&contentID=10.1017%2Fawf.2023.4&startPage=&endPage=&orderBeanReset=True&volumeNum=32&issueNum=&oa=CC-BY",
        "name": "Creative Commons CC BY"
    }
]
     int 
[]
 a4d83d52cedc05a5119bc20851564332 71b4b4d75d92a0680266cc009dc82593
789699 Production of farmed finfish relative to 1990 %   2023-08-09 15:06:42 2024-07-25 23:11:52     1990-2019 Number of farmed fish killed for food worldwide 6175   % 
{
    "unit": "%",
    "shortUnit": "%",
    "numDecimalPlaces": 0
}
 0     production_relative_to_1990 grapher/animal_welfare/2023-08-08/farmed_finfishes_used_for_food/farmed_finfishes_used_for_food#production_relative_to_1990   2                 
[]
   
[
    {
        "url": "https://s100.copyright.com/AppDispatchServlet?publisherName=CUP&publication=AWF&title=Estimating%20global%20numbers%20of%20farmed%20fishes%20killed%20for%20food%20annually%20from%201990%20to%202019&publicationDate=06%20February%202023&author=Alison%20Mood%2C%20Elena%20Lara%2C%20Natasha%20K%20Boyland%2C%20Phil%20Brooke&copyright=%C2%A9%20The%20Author(s)%2C%202023.%20Published%20by%20Cambridge%20University%20Press%20on%20behalf%20of%20The%20Universities%20Federation%20for%20Animal%20Welfare&contentID=10.1017%2Fawf.2023.4&startPage=&endPage=&orderBeanReset=True&volumeNum=32&issueNum=&oa=CC-BY",
        "name": "Creative Commons CC BY"
    }
]
     int 
[]
 71ea026178048d217c8b4f8122c57fc4 5cec8f1880a4d3f7e23227c0f210656e
789698 Production of farmed finfish tonnes   2023-08-09 15:06:42 2024-07-25 23:11:52     1990-2019 Number of farmed fish killed for food worldwide 6175   t 
{
    "unit": "tonnes",
    "shortUnit": "t",
    "numDecimalPlaces": 0
}
 0     production grapher/animal_welfare/2023-08-08/farmed_finfishes_used_for_food/farmed_finfishes_used_for_food#production   2                 
[]
   
[
    {
        "url": "https://s100.copyright.com/AppDispatchServlet?publisherName=CUP&publication=AWF&title=Estimating%20global%20numbers%20of%20farmed%20fishes%20killed%20for%20food%20annually%20from%201990%20to%202019&publicationDate=06%20February%202023&author=Alison%20Mood%2C%20Elena%20Lara%2C%20Natasha%20K%20Boyland%2C%20Phil%20Brooke&copyright=%C2%A9%20The%20Author(s)%2C%202023.%20Published%20by%20Cambridge%20University%20Press%20on%20behalf%20of%20The%20Universities%20Federation%20for%20Animal%20Welfare&contentID=10.1017%2Fawf.2023.4&startPage=&endPage=&orderBeanReset=True&volumeNum=32&issueNum=&oa=CC-BY",
        "name": "Creative Commons CC BY"
    }
]
     int 
[]
 ab70027471c001310d4a85ec8537f1ff d2ebc8a4467ebb19776395f5b831ab76
789697 Estimated number of farmed finfish killed for food (upper bound) fish   2023-08-09 15:06:42 2024-07-25 23:11:52     1990-2019 Number of farmed fish killed for food worldwide 6175     
{
    "unit": "fish",
    "numDecimalPlaces": 0
}
 0     n_fish_high grapher/animal_welfare/2023-08-08/farmed_finfishes_used_for_food/farmed_finfishes_used_for_food#n_fish_high   2                 
[]
   
[
    {
        "url": "https://s100.copyright.com/AppDispatchServlet?publisherName=CUP&publication=AWF&title=Estimating%20global%20numbers%20of%20farmed%20fishes%20killed%20for%20food%20annually%20from%201990%20to%202019&publicationDate=06%20February%202023&author=Alison%20Mood%2C%20Elena%20Lara%2C%20Natasha%20K%20Boyland%2C%20Phil%20Brooke&copyright=%C2%A9%20The%20Author(s)%2C%202023.%20Published%20by%20Cambridge%20University%20Press%20on%20behalf%20of%20The%20Universities%20Federation%20for%20Animal%20Welfare&contentID=10.1017%2Fawf.2023.4&startPage=&endPage=&orderBeanReset=True&volumeNum=32&issueNum=&oa=CC-BY",
        "name": "Creative Commons CC BY"
    }
]
   
{
    "hasMapTab": false
}
 int 
[]
 d9e1fdeba11bb6fdadfddcb30cc803af 6ad57f6ed4e951a6d70e878795b90a2f
789696 Estimated number of farmed finfish killed for food fish   2023-08-09 15:06:41 2024-07-25 23:11:52     1990-2019 Number of farmed fish killed for food worldwide 6175     
{
    "unit": "fish",
    "numDecimalPlaces": 0
}
 0     n_fish grapher/animal_welfare/2023-08-08/farmed_finfishes_used_for_food/farmed_finfishes_used_for_food#n_fish   2             Finfish refers to any fish with fins, as opposed to shellfish.   
[]
   
[
    {
        "url": "https://s100.copyright.com/AppDispatchServlet?publisherName=CUP&publication=AWF&title=Estimating%20global%20numbers%20of%20farmed%20fishes%20killed%20for%20food%20annually%20from%201990%20to%202019&publicationDate=06%20February%202023&author=Alison%20Mood%2C%20Elena%20Lara%2C%20Natasha%20K%20Boyland%2C%20Phil%20Brooke&copyright=%C2%A9%20The%20Author(s)%2C%202023.%20Published%20by%20Cambridge%20University%20Press%20on%20behalf%20of%20The%20Universities%20Federation%20for%20Animal%20Welfare&contentID=10.1017%2Fawf.2023.4&startPage=&endPage=&orderBeanReset=True&volumeNum=32&issueNum=&oa=CC-BY",
        "name": "Creative Commons CC BY"
    }
]
   
{
    "hasMapTab": false
}
 int 
[]
 8bb19299bf7dcfb6a15cb778ff4202d3 44fe7c63efbb36f084f67742f4ec3fe2
789695 Estimated number of farmed finfish killed for food (lower bound) fish   2023-08-09 15:06:41 2024-07-25 23:11:51     1990-2019 Number of farmed fish killed for food worldwide 6175     
{
    "unit": "fish",
    "numDecimalPlaces": 0
}
 0     n_fish_low grapher/animal_welfare/2023-08-08/farmed_finfishes_used_for_food/farmed_finfishes_used_for_food#n_fish_low   2                 
[]
   
[
    {
        "url": "https://s100.copyright.com/AppDispatchServlet?publisherName=CUP&publication=AWF&title=Estimating%20global%20numbers%20of%20farmed%20fishes%20killed%20for%20food%20annually%20from%201990%20to%202019&publicationDate=06%20February%202023&author=Alison%20Mood%2C%20Elena%20Lara%2C%20Natasha%20K%20Boyland%2C%20Phil%20Brooke&copyright=%C2%A9%20The%20Author(s)%2C%202023.%20Published%20by%20Cambridge%20University%20Press%20on%20behalf%20of%20The%20Universities%20Federation%20for%20Animal%20Welfare&contentID=10.1017%2Fawf.2023.4&startPage=&endPage=&orderBeanReset=True&volumeNum=32&issueNum=&oa=CC-BY",
        "name": "Creative Commons CC BY"
    }
]
   
{
    "hasMapTab": false
}
 int 
[]
 be9ec1426aae202936dd9c7797480b89 fcc0fa8445f9bf7e46e9ed34141af6ab

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