variables
Data license: CC-BY
2 rows where datasetId = 805 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 28192 | Energy: Energy used in agriculture and forestry - Agriculture and forestry energy use as a % of total energy use (FAO (2017)) | % | ENERGY USE: Agriculture consumes energy directly for crop and livestock production (machinery, etc) but also indirectly through fertilizers and pesticides. Agriculture also produces energy as biofuels and biomass production. As an energy user, Agriculture contributes to global warming (mainly through CO2 emissions, but also CH4 and N2O emissions), air pollution (mainly through NOx and SO2 emissions) and to the depletion of fossil energy resources. Important energy users are glasshouse horticulture, floriculture and dairy production. Agriculture can make a contribution to the mitigation of climate change and air pollution effects through more efficient energy use and through the production of renewable energy (bio-energy production). Indicator: Agriculture and forestry energy used as a % of total energy use, measured as Agr.Energy use/Total Energy Use)*100. BIOENERGY: Bioenergy refers to energy derived from the biological carbon fixation of plants or from biological tissues. Examples are biodiesel, derived from vegetable oils and animal fats, and bioethanol, produced by the fermentation of carbohydrates of crops like corn. The production of biomass for energy production has important effects on rural development, international policy and economy, and on the environment: it supports the rural economy creating jobs and gives farmers a source of income complementary to food production. Biofuels have also an impact on economy and trade, since they reduce the dependence on oil-producing countries. Being derived from plants, their production contributes to carbon sequestration. Biofuels production presents also some issues, such as the increased pressure on water resources, deforestation (to clear land to cultivate fuel crops), and the change in use of land originally intended for food production. Indicator: Bioenergy production as a % of total energy production. Methodology: Sum of different bioenergy (e.g. biodiesel, biogases). Share of bioenergy on renewable energy prod. = (Biofuels prod/Total renewable producti… | 2017-08-28 18:51:04 | 2023-06-15 05:05:42 | 6741 - 72040 | Agri-Environmental Indicators: Energy - FAO (2017) 805 | Energy - FAO (2017) 2965 | % | {} |
0 | 1 | ||||||||||||||||||||||||
| 28191 | Energy: Bioenergy production - Bioenergy production as a % of total renewable energy production (FAO (2017)) | % | ENERGY USE: Agriculture consumes energy directly for crop and livestock production (machinery, etc) but also indirectly through fertilizers and pesticides. Agriculture also produces energy as biofuels and biomass production. As an energy user, Agriculture contributes to global warming (mainly through CO2 emissions, but also CH4 and N2O emissions), air pollution (mainly through NOx and SO2 emissions) and to the depletion of fossil energy resources. Important energy users are glasshouse horticulture, floriculture and dairy production. Agriculture can make a contribution to the mitigation of climate change and air pollution effects through more efficient energy use and through the production of renewable energy (bio-energy production). Indicator: Agriculture and forestry energy used as a % of total energy use, measured as Agr.Energy use/Total Energy Use)*100. BIOENERGY: Bioenergy refers to energy derived from the biological carbon fixation of plants or from biological tissues. Examples are biodiesel, derived from vegetable oils and animal fats, and bioethanol, produced by the fermentation of carbohydrates of crops like corn. The production of biomass for energy production has important effects on rural development, international policy and economy, and on the environment: it supports the rural economy creating jobs and gives farmers a source of income complementary to food production. Biofuels have also an impact on economy and trade, since they reduce the dependence on oil-producing countries. Being derived from plants, their production contributes to carbon sequestration. Biofuels production presents also some issues, such as the increased pressure on water resources, deforestation (to clear land to cultivate fuel crops), and the change in use of land originally intended for food production. Indicator: Bioenergy production as a % of total energy production. Methodology: Sum of different bioenergy (e.g. biodiesel, biogases). Share of bioenergy on renewable energy prod. = (Biofuels prod/Total renewable producti… | 2017-08-28 18:51:04 | 2023-06-15 05:05:42 | 6740 - 72041 | Agri-Environmental Indicators: Energy - FAO (2017) 805 | Energy - FAO (2017) 2965 | {} |
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");