sources
Data license: CC-BY
1 row where datasetId = 5030 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
17761 | Emissions - Agriculture: Cultivation of Organic Soils | { "link": "http://www.fao.org/faostat/en/?#data/", "retrievedDate": "13-Feb-2020", "additionalInfo": "Greenhouse gas (GHG) emissions data from Cultivation of Organic soils are those associated with nitrous oxide gas emissions from drained organic soils (histosols) under cropland and grassland.", "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)", "dataPublisherSource": "FAOSTAT Emissions data are computed based on Activity Data, calculated from the following spatial data:The Harmonized World Soil Database (FAO et al., 2012): http://www.fao.org/soils-portal/soil-survey/soil-maps-and-databases/harmonized-world-soil-database-v12/it/ Land Cover CCI Product User Guide Version 2.0, 2017. UCL Geomatic (Universit\u00e9 catholique de Louvain; Friederich-Schille-Universit\u00e4t Jena; Wageningen University; Max-Planck-Institut f\u00fcr Meteorologie; JRC European Commission; Met Office. Deliverable ref: D3.3. Belgium. Available from: http://maps.elie.ucl.ac.be/CCI/viewer/download/ESACCI-LC-Ph2-PUGv2_2.0.pdf; The Gridded Livestock of the World for cattle, sheep and goats (Robinson et al., 2014) for the identification of the world organic soils under cropland and grassland. Available at: https://journals.plos.org/plosone/article?id=10.1371/journal.pone.0096084" } |
2020-02-14 02:51:00 | 2020-02-14 02:51:00 | Emissions - Agriculture: Cultivation of Organic Soils 5030 | Greenhouse gas (GHG) emissions data from Cultivation of Organic soils are those associated with nitrous oxide gas emissions from drained organic soils (histosols) under cropland and grassland. | http://www.fao.org/faostat/en/?#data/ | Food and Agriculture Organization of the United Nations (FAO) (2020) |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "sources" ( "id" INTEGER PRIMARY KEY AUTOINCREMENT, "name" VARCHAR(512) NULL , "description" TEXT NOT NULL , "createdAt" DATETIME NOT NULL DEFAULT CURRENT_TIMESTAMP , "updatedAt" DATETIME NULL , "datasetId" INTEGER NULL, additionalInfo TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.additionalInfo')) VIRTUAL, link TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.link')) VIRTUAL, dataPublishedBy TEXT GENERATED ALWAYS as (JSON_EXTRACT(description, '$.dataPublishedBy')) VIRTUAL, FOREIGN KEY("datasetId") REFERENCES "datasets" ("id") ON UPDATE RESTRICT ON DELETE RESTRICT ); CREATE INDEX "sources_datasetId" ON "sources" ("datasetId");