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 = 5006 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
17737 Agri-Environmental Indicators: Land use indicators 
{
    "link": "http://www.fao.org/faostat/en/?#data/",
    "retrievedDate": "13-Feb-2020",
    "additionalInfo": "Data of the Agri-environmental indicator \u2013 Land Use domain are based on country statistics from the FAOSTAT domain Inputs/Land Use (http://www.fao.org/faostat/en/#data/RL). The indicator describes the shares of different land use types at national, regional and global levels over time for the following elements (in %): i) Share in Land area; ii) Share in Agricultural land and iii) Share in Forest land.Time series vary by the underlying data availability of each land use type.Data of \u201cAgricultural land\u201d and its sub-categories: \u201cArable land\u201d; \u201cLand under permanent crops\u201d; \u201cLand under permanent meadows and pastures\u201d; and \u201cLand area equipped for irrigation\u201d are available from 1961 onward. Data of \u201cAgriculture area actually irrigated\u201d are available since 2001 to present. Data for the component \u201cAgriculture area under organic agriculture\u201d are available from 2004 onward. Data of \u201cForest land\u201d and of its sub-components \u201cPrimary Forest\u201d, \u201cOther naturally regenerated forest\u201d and \u201cPlanted Forest\u201d are available since 1990. Last available year is 2016.",
    "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)",
    "dataPublisherSource": "Data from FAOSTAT Agri-environmental Indicators Land Use http://www.fao.org/faostat/en/#data/EL."
}
 2020-02-14 01:35:17 2020-02-14 01:35:17 Agri-Environmental Indicators: Land use indicators 5006 Data of the Agri-environmental indicator – Land Use domain are based on country statistics from the FAOSTAT domain Inputs/Land Use (http://www.fao.org/faostat/en/#data/RL). The indicator describes the shares of different land use types at national, regional and global levels over time for the following elements (in %): i) Share in Land area; ii) Share in Agricultural land and iii) Share in Forest land.Time series vary by the underlying data availability of each land use type.Data of “Agricultural land” and its sub-categories: “Arable land”; “Land under permanent crops”; “Land under permanent meadows and pastures”; and “Land area equipped for irrigation” are available from 1961 onward. Data of “Agriculture area actually irrigated” are available since 2001 to present. Data for the component “Agriculture area under organic agriculture” are available from 2004 onward. Data of “Forest land” and of its sub-components “Primary Forest”, “Other naturally regenerated forest” and “Planted Forest” are available since 1990. Last available year is 2016. 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

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