variables
Data license: CC-BY
5 rows where datasetId = 5334 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: description, createdAt, 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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
147412 | Change in pollinator dependence vulnerability index | The dependency vulnerability index measures the vulnerability of a country's agriculture to changes in pollinator populations. A country is more vulnerable to pollinator decline if a lot of its crop output is pollinator-dependent crops and it has low levels of crop diversity. This makes its food system dependent on the growth of only a few crops. | 2021-06-24 19:18:29 | 2023-06-15 05:05:42 | Pollinator dependency of agriculture (Aizen et al. 2019) 5334 | Aizen et al. (2019). Global agricultural productivity is threatened by increasing pollinator dependence without a parallel increase in crop diversification. Global Change Biology. 18054 | { "name": "Change in dependency vulnerability to pollinators", "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||||||
147410 | Annual change in crop richness (%) | Crop richness is measured as the number of different crops grown. | 2021-06-23 19:43:58 | 2023-06-15 05:05:42 | Pollinator dependency of agriculture (Aizen et al. 2019) 5334 | Aizen et al. (2019). Global agricultural productivity is threatened by increasing pollinator dependence without a parallel increase in crop diversification. Global Change Biology. 18054 | { "name": "Annual change in crop richness: the number of crops grown", "unit": "%", "shortUnit": "%", "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||||||
147409 | Crop richness (no. of crops) | Crop richness is measured as the number of different crops grown. | 2021-06-23 19:43:58 | 2023-06-15 05:05:42 | Pollinator dependency of agriculture (Aizen et al. 2019) 5334 | Aizen et al. (2019). Global agricultural productivity is threatened by increasing pollinator dependence without a parallel increase in crop diversification. Global Change Biology. 18054 | { "name": "Number of crops grown", "unit": "crops", "includeInTable": true, "numDecimalPlaces": 0 } |
0 | 1 | |||||||||||||||||||||||||||
147408 | Annual change in share of cropland used for pollinator dependent crops | The average annual rate of change in the share of cropland used to grow pollinator-dependent crops between 1961 and 2016. Crops were characterized according to the extent to which biotic pollination contributes to their yield. A crop is considered to be pollinator-dependent if animal pollination is required to increase the quantity and/or the quality of fruits or seeds directly consumed by humans. This means that in the absence of pollination these crops would have lower yields, but most would still continue to grow. | 2021-06-23 19:43:58 | 2023-06-15 05:05:42 | Pollinator dependency of agriculture (Aizen et al. 2019) 5334 | Aizen et al. (2019). Global agricultural productivity is threatened by increasing pollinator dependence without a parallel increase in crop diversification. Global Change Biology. 18054 | { "name": "Annual change in the share of cropland used for pollinator dependent crops", "unit": "%", "shortUnit": "%", "includeInTable": true } |
0 | 1 | |||||||||||||||||||||||||||
147407 | Share of cropland used for pollinator dependent crops | Crops were characterized according to the extent to which biotic pollination contributes to their yield. A crop is considered to be pollinator-dependent if animal pollination is required to increase the quantity and/or the quality of fruits or seeds directly consumed by humans. This means that in the absence of pollination these crops would have lower yields, but most would still continue to grow. | 2021-06-23 19:43:58 | 2023-06-15 05:05:42 | Pollinator dependency of agriculture (Aizen et al. 2019) 5334 | Aizen et al. (2019). Global agricultural productivity is threatened by increasing pollinator dependence without a parallel increase in crop diversification. Global Change Biology. 18054 | { "name": "Share of cropland used to grow pollinator dependent crops", "unit": "%", "shortUnit": "%", "includeInTable": true } |
0 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");