sources
Data license: CC-BY
1 row where datasetId = 1914 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 |
---|---|---|---|---|---|---|---|---|
13923 | Share of arable land which is organic - OWID based on FAO | { "link": "http://www.fao.org/faostat/en/#home", "retrievedDate": "25th January 2018", "additionalInfo": "Share of arable land which is organic is derived by Our World in Data based on UN Food and Agriculture Organization (FAO) Statistics on total arable land area, and organic arable land area. The share is calculated as: total arable area (ha) / organic arable land area (ha).\n\nOrganic arable land area is the sum of the area certified as organic by official standards, and land area in the conversion process to organic (which is assumed by the FAO as a two-year period prior to certification). ", "dataPublishedBy": "Our World in Data based on UN FAO Statistics", "dataPublisherSource": null } |
2018-01-25 09:43:35 | 2018-01-25 09:43:35 | Share of arable land which is organic - OWID based on FAO 1914 | Share of arable land which is organic is derived by Our World in Data based on UN Food and Agriculture Organization (FAO) Statistics on total arable land area, and organic arable land area. The share is calculated as: total arable area (ha) / organic arable land area (ha). Organic arable land area is the sum of the area certified as organic by official standards, and land area in the conversion process to organic (which is assumed by the FAO as a two-year period prior to certification). | http://www.fao.org/faostat/en/#home | Our World in Data based on UN FAO Statistics |
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");