sources

Data license: CC-BY

1 row where datasetId = 4248 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

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

{
    "link": "http://www.fao.org/faostat/en/#data",
    "retrievedDate": "7th November 2019",
    "additionalInfo": "This metric measures the index of arable land needed to produce a fixed quantity of crops (where values in 1961 are equal to 1.0). \n\nThis is calculated as arable land divided by the crop production index (PIN). The crop production index (PIN) here is the sum of crop commodities produced (after deductions of quantities used as seed and feed). It is weighted by the commodity prices. \n\nValues for arable land use and the crop production index (PIN) is sourced from the UN Food and Agriculture Organization (FAO). ",
    "dataPublishedBy": "Calculated by Our World in Data based on the UN Food and Agriculture Organization (FAO)"
}

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