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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: unit, createdAt, display, licenses, 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
812310 Estimated number of farmed fish per capita fish per person   2023-09-19 12:50:05 2024-07-25 23:11:52     2015-2017 Number of farmed fish killed for food (Fishcount, 2018) 6186     
{
    "unit": "fish per person",
    "numDecimalPlaces": 2
}
 0     n_farmed_fish_per_capita grapher/animal_welfare/2023-08-14/number_of_farmed_fish/number_of_farmed_fish#n_farmed_fish_per_capita   2 major         Fishcount (2018) Midpoint estimate of the annual number of farmed fish slaughtered for food per person.   
[
    "This indicator uses data on aquaculture production tonnages and mean weights estimated from available fish size data.",
    "Note that this study does not include:\n- Non-fish species, e.g. lobsters.\n- Fish deaths arising in fish farms prior to harvest, in the capture of wild fish for feed or re-stocking, or from environmental impacts on surrounding wildlife.\n- Fish farmed for use as bait, whose small production tonnages may comprise large numbers of fish due to their very small size of just a few grams.\n- Species without an estimated mean weight (which were an additional 17% of reported global fish production).\n"
]
   
[
    {
        "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": "This data does not include lobsters, farmed fish used as bait, and species without an estimated mean weight (which were an additional 17% of reported global fish production)."
}
 float 
[]
 09ca5653c5768b2be977c076a625aafe 3303622022653ed694bb1175504c9a7a
812309 Estimated number of farmed fish per capita (lower bound) fish per person   2023-09-19 12:50:04 2024-07-25 23:11:52     2015-2017 Number of farmed fish killed for food (Fishcount, 2018) 6186     
{
    "unit": "fish per person",
    "numDecimalPlaces": 2
}
 0     n_farmed_fish_low_per_capita grapher/animal_welfare/2023-08-14/number_of_farmed_fish/number_of_farmed_fish#n_farmed_fish_low_per_capita   2 major         Fishcount (2018) Lower bound estimate of the annual number of farmed fish slaughtered for food per person.   
[
    "This indicator uses data on aquaculture production tonnages and mean weights estimated from available fish size data.",
    "Note that this study does not include:\n- Non-fish species, e.g. lobsters.\n- Fish deaths arising in fish farms prior to harvest, in the capture of wild fish for feed or re-stocking, or from environmental impacts on surrounding wildlife.\n- Fish farmed for use as bait, whose small production tonnages may comprise large numbers of fish due to their very small size of just a few grams.\n- Species without an estimated mean weight (which were an additional 17% of reported global fish production).\n"
]
   
[
    {
        "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"
    }
]
     float 
[]
 b22748788856f8d8d5fa18add652bfb7 1717d7a57c168ac7e2dd019498054eec
812308 Estimated number of farmed fish per capita (upper bound) fish per person   2023-09-19 12:50:04 2024-07-25 23:11:52     2015-2017 Number of farmed fish killed for food (Fishcount, 2018) 6186     
{
    "unit": "fish per person",
    "numDecimalPlaces": 2
}
 0     n_farmed_fish_high_per_capita grapher/animal_welfare/2023-08-14/number_of_farmed_fish/number_of_farmed_fish#n_farmed_fish_high_per_capita   2 major         Fishcount (2018) Upper bound estimate of the annual number of farmed fish slaughtered for food per person.   
[
    "This indicator uses data on aquaculture production tonnages and mean weights estimated from available fish size data.",
    "Note that this study does not include:\n- Non-fish species, e.g. lobsters.\n- Fish deaths arising in fish farms prior to harvest, in the capture of wild fish for feed or re-stocking, or from environmental impacts on surrounding wildlife.\n- Fish farmed for use as bait, whose small production tonnages may comprise large numbers of fish due to their very small size of just a few grams.\n- Species without an estimated mean weight (which were an additional 17% of reported global fish production).\n"
]
   
[
    {
        "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"
    }
]
     float 
[]
 d8349fa38516491a189923a1733485f6 e0aeeff88fb581b7283b6555c4603f1a
791806 Estimated number of farmed fish (lower bound) fish   2023-08-15 15:20:03 2024-07-25 23:11:52     2015-2017 Number of farmed fish killed for food (Fishcount, 2018) 6186     
{
    "unit": "fish",
    "numDecimalPlaces": 0
}
 0     n_farmed_fish_low grapher/animal_welfare/2023-08-14/number_of_farmed_fish/number_of_farmed_fish#n_farmed_fish_low   2           Fishcount (2018) Lower bound estimate of the annual number of farmed fish slaughtered for food.   
[
    "This indicator uses data on aquaculture production tonnages and mean weights estimated from available fish size data.",
    "Note that this study does not include:\n- Non-fish species, e.g. lobsters.\n- Fish deaths arising in fish farms prior to harvest, in the capture of wild fish for feed or re-stocking, or from environmental impacts on surrounding wildlife.\n- Fish farmed for use as bait, whose small production tonnages may comprise large numbers of fish due to their very small size of just a few grams.\n- Species without an estimated mean weight (which were an additional 17% of reported global fish production).\n"
]
   
[
    {
        "name": "CC BY"
    }
]
     float 
[]
 30e64bf2921dad54e2546235a1650a1e 6c30c80986f4c336118af7bced3d1ec7
791805 Estimated number of farmed fish (upper bound) fish   2023-08-15 15:20:03 2024-07-25 23:11:52     2015-2017 Number of farmed fish killed for food (Fishcount, 2018) 6186     
{
    "unit": "fish",
    "numDecimalPlaces": 0
}
 0     n_farmed_fish_high grapher/animal_welfare/2023-08-14/number_of_farmed_fish/number_of_farmed_fish#n_farmed_fish_high   2           Fishcount (2018) Upper bound estimate of the annual number of farmed fish slaughtered for food.   
[
    "This indicator uses data on aquaculture production tonnages and mean weights estimated from available fish size data.",
    "Note that this study does not include:\n- Non-fish species, e.g. lobsters.\n- Fish deaths arising in fish farms prior to harvest, in the capture of wild fish for feed or re-stocking, or from environmental impacts on surrounding wildlife.\n- Fish farmed for use as bait, whose small production tonnages may comprise large numbers of fish due to their very small size of just a few grams.\n- Species without an estimated mean weight (which were an additional 17% of reported global fish production).\n"
]
   
[
    {
        "name": "CC BY"
    }
]
     float 
[]
 0f88ebe96af55edc2349b323e84fa37a 35574d152819bcc8518a132686a5d491
791804 Estimated number of farmed fish fish   2023-08-15 15:20:03 2024-07-25 23:11:52     2015-2017 Number of farmed fish killed for food (Fishcount, 2018) 6186     
{
    "unit": "fish",
    "numDecimalPlaces": 0
}
 0     n_farmed_fish grapher/animal_welfare/2023-08-14/number_of_farmed_fish/number_of_farmed_fish#n_farmed_fish   2           Fishcount (2018) Midpoint estimate of the annual number of farmed fish slaughtered for food, calculated as the average between the lower and upper estimates.   
[
    "This indicator uses data on aquaculture production tonnages and mean weights estimated from available fish size data.",
    "Note that this study does not include:\n- Non-fish species, e.g. lobsters.\n- Fish deaths arising in fish farms prior to harvest, in the capture of wild fish for feed or re-stocking, or from environmental impacts on surrounding wildlife.\n- Fish farmed for use as bait, whose small production tonnages may comprise large numbers of fish due to their very small size of just a few grams.\n- Species without an estimated mean weight (which were an additional 17% of reported global fish production).\n"
]
   
[
    {
        "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": "This data does not include lobsters, farmed fish used as bait, and species without an estimated mean weight (which were an additional 17% of reported global fish production)."
}
 float 
[]
 400d265dc4f19a43d086d83cb5e78cc6 22908bc2e22cbcade0c7bb1a2524f59f

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