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

6 rows where datasetId = 6187 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, updatedAt, display, descriptionKey, licenses, grapherConfigETL, createdAt (date), updatedAt (date), descriptionKey (array)

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
812304 Estimated number of farmed decapod crustaceans per capita decapods per person   2023-09-19 12:49:56 2024-07-25 23:11:53     2015-2017 Number of farmed decapod crustaceans killed for food (Fishcount, 2018) 6187     
{
    "unit": "decapods per person",
    "numDecimalPlaces": 2
}
 0     n_farmed_decapod_crustaceans_per_capita grapher/animal_welfare/2023-08-15/number_of_farmed_decapod_crustaceans/number_of_farmed_decapod_crustaceans#n_farmed_decapod_crustaceans_per_capita   2 major         Fishcount (2018) Midpoint estimate of the number of farmed decapod crustaceans slaughtered for food per person.   
[
    "Decapods are an order of crustaceans that includes crabs, lobsters, crayfish, shrimp and prawns.",
    "This indicator is estimated using data on aquaculture production tonnages and mean weights from crustaceans size data. For species categories where no estimated mean weight was obtained, a generic mean weight was used.",
    "The midpoint estimate of the number of farmed decapod crustaceans is calculated as the average between the lower and upper estimates."
]
   
[
    {
        "name": "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"
    }
]
   
{
    "note": "Due to large uncertainties, the chart shows upper and lower bounds, and midpoint values (also shown in the map), which are the average of those bounds.",
    "subtitle": "Decapod crustaceans are animals such as shrimps, crabs, lobsters, prawns, and crayfish. This data does not include species without an estimated mean weight (which were an additional 6% of reported global production)."
}
 float 
[]
 aa0adea33b04669472bc4566e89b9525 50db3b327af53e1b7e40af727acd08dc
812303 Estimated number of decapod crustaceans per capita (lower bound) decapods per person   2023-09-19 12:49:56 2024-07-25 23:11:53     2015-2017 Number of farmed decapod crustaceans killed for food (Fishcount, 2018) 6187     
{
    "unit": "decapods per person",
    "numDecimalPlaces": 2
}
 0     n_farmed_decapod_crustaceans_low_per_capita grapher/animal_welfare/2023-08-15/number_of_farmed_decapod_crustaceans/number_of_farmed_decapod_crustaceans#n_farmed_decapod_crustaceans_low_per_capita   2 major         Fishcount (2018) Lower bound estimate of the annual number of farmed decapod crustaceans slaughtered for food per person.   
[
    "Decapods are an order of crustaceans that includes crabs, lobsters, crayfish, shrimp and prawns.",
    "This indicator is estimated using data on aquaculture production tonnages and mean weights from crustaceans size data. For species categories where no estimated mean weight was obtained, a generic mean weight was used."
]
   
[
    {
        "name": "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"
    }
]
   
{
    "note": "Upper and lower-bound estimates are shown due to large uncertainties. The map shows midpoint values.",
    "subtitle": "Decapod crustaceans are animals such as shrimps, crabs, lobsters, prawns, and crayfish. This data does not include species without an estimated mean weight (which were an additional 6% of reported global production)."
}
 float 
[]
 abef61000f1c4d7113809bb2fdc72704 d5c2d7506c7fb99f136bb155610a2812
812302 Estimated number of farmed decapod crustaceans per capita (upper bound) decapods per person   2023-09-19 12:49:56 2024-07-25 23:11:53     2015-2017 Number of farmed decapod crustaceans killed for food (Fishcount, 2018) 6187     
{
    "unit": "decapods per person",
    "numDecimalPlaces": 2
}
 0     n_farmed_decapod_crustaceans_high_per_capita grapher/animal_welfare/2023-08-15/number_of_farmed_decapod_crustaceans/number_of_farmed_decapod_crustaceans#n_farmed_decapod_crustaceans_high_per_capita   2 major         Fishcount (2018) Upper bound estimate of the annual number of farmed decapod crustaceans slaughtered for food per person.   
[
    "Decapods are an order of crustaceans that includes crabs, lobsters, crayfish, shrimp and prawns.",
    "This indicator is estimated using data on aquaculture production tonnages and mean weights from crustaceans size data. For species categories where no estimated mean weight was obtained, a generic mean weight was used."
]
   
[
    {
        "name": "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"
    }
]
   
{
    "note": "Upper and lower-bound estimates are shown due to large uncertainties. The map shows midpoint values."
}
 float 
[]
 c02d11fc3aade3c464d4e0598e2d2e84 c201cfc5a06d3a82a65b0bc232615d1c
791809 Estimated number of decapod crustaceans (lower bound) decapods   2023-08-15 15:20:08 2024-07-25 23:11:52     2015-2017 Number of farmed decapod crustaceans killed for food (Fishcount, 2018) 6187     
{
    "unit": "decapods",
    "numDecimalPlaces": 0
}
 0     n_farmed_decapod_crustaceans_low grapher/animal_welfare/2023-08-15/number_of_farmed_decapod_crustaceans/number_of_farmed_decapod_crustaceans#n_farmed_decapod_crustaceans_low   2           Fishcount (2018) Lower bound estimate of the annual number of farmed decapod crustaceans slaughtered for food.   
[
    "Decapods are an order of crustaceans that includes crabs, lobsters, crayfish, shrimp and prawns.",
    "This indicator is estimated using data on aquaculture production tonnages and mean weights from crustaceans size data. For species categories where no estimated mean weight was obtained, a generic mean weight was used."
]
   
[
    {
        "name": "CC BY"
    }
]
   
{
    "note": "Upper and lower-bound estimates are shown due to large uncertainties. The map shows midpoint values.",
    "subtitle": "Decapod crustaceans are animals such as shrimps, crabs, lobsters, prawns, and crayfish. This data does not include species without an estimated mean weight (which were an additional 6% of reported global production)."
}
 float 
[]
 86559a4e8d94fe1fb68278053d34f011 94fee33d2003bf30b5fdd68cd8b1420b
791808 Estimated number of farmed decapod crustaceans (upper bound) decapods   2023-08-15 15:20:08 2024-07-25 23:11:52     2015-2017 Number of farmed decapod crustaceans killed for food (Fishcount, 2018) 6187     
{
    "unit": "decapods",
    "numDecimalPlaces": 0
}
 0     n_farmed_decapod_crustaceans_high grapher/animal_welfare/2023-08-15/number_of_farmed_decapod_crustaceans/number_of_farmed_decapod_crustaceans#n_farmed_decapod_crustaceans_high   2           Fishcount (2018) Upper bound estimate of the annual number of farmed decapod crustaceans slaughtered for food.   
[
    "Decapods are an order of crustaceans that includes crabs, lobsters, crayfish, shrimp and prawns.",
    "This indicator is estimated using data on aquaculture production tonnages and mean weights from crustaceans size data. For species categories where no estimated mean weight was obtained, a generic mean weight was used."
]
   
[
    {
        "name": "CC BY"
    }
]
   
{
    "note": "Upper and lower-bound estimates are shown due to large uncertainties. The map shows midpoint values."
}
 float 
[]
 4daf671ebe493305e68dc98418393cbf 78d7b3b953efaafb41addb665387e8ac
791807 Estimated number of farmed decapod crustaceans decapods   2023-08-15 15:20:08 2024-07-25 23:11:52     2015-2017 Number of farmed decapod crustaceans killed for food (Fishcount, 2018) 6187     
{
    "unit": "decapods",
    "numDecimalPlaces": 0
}
 0     n_farmed_decapod_crustaceans grapher/animal_welfare/2023-08-15/number_of_farmed_decapod_crustaceans/number_of_farmed_decapod_crustaceans#n_farmed_decapod_crustaceans   2           Fishcount (2018) Midpoint estimate of the number of farmed decapod crustaceans slaughtered for food.   
[
    "Decapods are an order of crustaceans that includes crabs, lobsters, crayfish, shrimp and prawns.",
    "This indicator is estimated using data on aquaculture production tonnages and mean weights from crustaceans size data. For species categories where no estimated mean weight was obtained, a generic mean weight was used.",
    "The midpoint estimate of the number of farmed decapod crustaceans is calculated as the average between the lower and upper estimates."
]
   
[
    {
        "name": "CC BY"
    }
]
   
{
    "note": "Due to large uncertainties, the chart shows upper and lower bounds, and midpoint values (also shown in the map), which are the average of those bounds.",
    "subtitle": "Decapod crustaceans are animals such as shrimps, crabs, lobsters, prawns, and crayfish. This data does not include species without an estimated mean weight (which were an additional 6% of reported global production)."
}
 float 
[]
 df3a9cd127ef4fb922be564df502b45d 14d34995e56a0b1e9b5db6ae9eac9fc1

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