variables

Data license: CC-BY

6 rows where datasetId = 6190 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)

{
    "unit": "fish per person",
    "numDecimalPlaces": 2
}

[
    "This indicator uses data on fisheries capture tonnages for 2007-2016 and estimated mean weights for fish species.",
    "Note that this estimate does not include unrecorded fish capture, such as fish caught illegally and those caught as bycatch and discarded."
]

[
    {
        "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 is calculated based on annual catch figures from 2007 to 2016 in tonnes, and estimated mean weights for fish species. It does not include unrecorded fish capture, such as fish caught illegally and those caught as bycatch and discards."
}

[]

{
    "unit": "fish per person",
    "numDecimalPlaces": 2
}

[
    "This indicator uses data on fisheries capture tonnages for 2007-2016 and estimated mean weights for fish species.",
    "Note that this estimate does not include unrecorded fish capture, such as fish caught illegally and those caught as bycatch and discarded."
]

[
    {
        "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"
    }
]

[]

{
    "unit": "fish per person",
    "numDecimalPlaces": 2
}

[
    "This indicator uses data on fisheries capture tonnages for 2007-2016 and estimated mean weights for fish species.",
    "Note that this estimate does not include unrecorded fish capture, such as fish caught illegally and those caught as bycatch and discarded."
]

[
    {
        "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"
    }
]

[]

{
    "unit": "fish",
    "numDecimalPlaces": 0
}

[
    "This indicator uses data on fisheries capture tonnages for 2007-2016 and estimated mean weights for fish species.",
    "Note that this estimate does not include unrecorded fish capture, such as fish caught illegally and those caught as bycatch and discarded."
]

[
    {
        "name": "CC BY"
    }
]

[]

{
    "unit": "fish",
    "numDecimalPlaces": 0
}

[
    "This indicator uses data on fisheries capture tonnages for 2007-2016 and estimated mean weights for fish species.",
    "Note that this estimate does not include unrecorded fish capture, such as fish caught illegally and those caught as bycatch and discarded."
]

[
    {
        "name": "CC BY"
    }
]

[]

{
    "unit": "fish",
    "numDecimalPlaces": 0
}

[
    "This indicator uses data on fisheries capture tonnages for 2007-2016 and estimated mean weights for fish species.",
    "Note that this estimate does not include unrecorded fish capture, such as fish caught illegally and those caught as bycatch and discarded."
]

[
    {
        "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 is based on the average tonnage of annual catch from 2007 to 2016, and estimated mean weights for fish species. It does not include unrecorded fish capture, such as fish caught illegally and those caught as bycatch and discards."
}

[]

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