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 = 4995 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
17726 ASTI R&D Indicators: ASTI-Expenditures 
{
    "link": "http://www.fao.org/faostat/en/?#data/",
    "retrievedDate": "13-Feb-2020",
    "additionalInfo": "Agricultural RD is defined to include research on crops, livestock, forestry, fisheries, natural resources, as well as on-farm postharvest research.ASTI collects actual spending data, not budgeted or projected data, in thousands of current local currency units. If the financial year differs from the calendar year, spending is reported in the calendar year that covers the majority of the financial year in question.ASTI collects all its financial timeseries data in local currency units and converts these into constant prices using official World Bank GDP deflators. Currently, ASTI expresses its financial data in 2011 prices.",
    "dataPublishedBy": "Food and Agriculture Organization of the United Nations (FAO) (2020)",
    "dataPublisherSource": "ASTI performs first-hand data collection on an institutional basis. It does not rely on already existing government datasets."
}
 2020-02-14 00:52:09 2020-02-14 00:52:09 ASTI R&D Indicators: ASTI-Expenditures 4995 Agricultural RD is defined to include research on crops, livestock, forestry, fisheries, natural resources, as well as on-farm postharvest research.ASTI collects actual spending data, not budgeted or projected data, in thousands of current local currency units. If the financial year differs from the calendar year, spending is reported in the calendar year that covers the majority of the financial year in question.ASTI collects all its financial timeseries data in local currency units and converts these into constant prices using official World Bank GDP deflators. Currently, ASTI expresses its financial data in 2011 prices. 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");