sources

This table contains all the sources for our datasets. The description column contains JSON encoded as text that contains useful additional fields like a longer descriptive text "additionalInfo".

Data license: CC-BY

1 row where datasetId = 924 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
6734 Fertilizer use per hectare of land - FAO (2017) & Federico (2008) 
{
    "link": null,
    "retrievedDate": null,
    "additionalInfo": "This data on fertilizer consumption rates combines two data sources. Data for all countries from 2002 onwards is sourced from the World Bank World Development Indicators (WDI). Available at: https://data.worldbank.org/ [accessed 13th September 2017]. \n\nLong-term data for select countries from 1880 is taken from Table 6.3 in Giovanni Federico (2008) \u2013 Feeding the World: An Economic History of Agriculture, 1800-2000. Princeton University Press. The original data sources cited by the author are: 1890-1957: Germany: (1880, 1910, 1920, 1940, and I960) Historical Statistics 1975, series K193 and J53 (assuming an average content of nutrients 17.5%); Japan: (1898-1902, 1908-12, 1918-22, 1933-37, and 1958-62) Hayami and Yamada 1991, table A5. Belgium: (1895,1910, 1929, and 1960-61) Blomme 1992, table 48. Year 1937 is referred to as 1937-38 in the original source; likewise 1957 refers to 1957-58, and 1999 to 1998-00.\n\nAll data is measured in kilograms of nutrient per hecatre of arable land.",
    "dataPublishedBy": "Fertilizer use per hectare of land - FAO (2017) & Federico (2008)",
    "dataPublisherSource": null
}
 2017-09-13 05:07:59 2017-11-02 13:04:39 Fertilizer use per hectare of land -FAO & Federico 924 This data on fertilizer consumption rates combines two data sources. Data for all countries from 2002 onwards is sourced from the World Bank World Development Indicators (WDI). Available at: https://data.worldbank.org/ [accessed 13th September 2017]. Long-term data for select countries from 1880 is taken from Table 6.3 in Giovanni Federico (2008) – Feeding the World: An Economic History of Agriculture, 1800-2000. Princeton University Press. The original data sources cited by the author are: 1890-1957: Germany: (1880, 1910, 1920, 1940, and I960) Historical Statistics 1975, series K193 and J53 (assuming an average content of nutrients 17.5%); Japan: (1898-1902, 1908-12, 1918-22, 1933-37, and 1958-62) Hayami and Yamada 1991, table A5. Belgium: (1895,1910, 1929, and 1960-61) Blomme 1992, table 48. Year 1937 is referred to as 1937-38 in the original source; likewise 1957 refers to 1957-58, and 1999 to 1998-00. All data is measured in kilograms of nutrient per hecatre of arable land.   Fertilizer use per hectare of land - FAO (2017) & Federico (2008)

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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