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 = 4161 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
16989 World Bank, World Development Indicators (2019) 
{
    "link": "https://data.worldbank.org/indicator/ST.INT.DPRT and https://databank.worldbank.org/indicator/SP.POP.TOTL/1ff4a498/Popular-Indicators",
    "retrievedDate": "08/07/19",
    "additionalInfo": "Number of tourist departures per 1000 was derived based on the number of departures per year, divided by population figures from the World Bank's World Development Indicators (WDI).\n\nNumber of tourist departures sourced from the World Bank's World Development Indicators (WDI). Available at: https://data.worldbank.org/indicator/ST.INT.DPRT.\n\nPopulation data sourced from the World Bank's World Development Indicators (WDI); figures were divided by 1000. Available at: https://databank.worldbank.org/indicator/SP.POP.TOTL/1ff4a498/Popular-Indicators.",
    "dataPublishedBy": "World Bank",
    "dataPublisherSource": "World Tourism Organization, Yearbook of Tourism Statistics, Compendium of Tourism Statistics, United Nations Population Division. World Population Prospects: 2019 Revision. Census reports and other statistical publications from national statistical offices, Eurostat: Demographic Statistics, United Nations Statistical Division. Population and Vital Statistics Reprot (various years), U.S. Census Bureau: International Database, and Secretariat of the Pacific Community: Statistics and Demography Programme."
}
 2019-07-08 10:25:45 2019-07-08 10:25:45 Number of tourist departures per 1000 - World Bank & UN (2019) 4161 Number of tourist departures per 1000 was derived based on the number of departures per year, divided by population figures from the World Bank's World Development Indicators (WDI). Number of tourist departures sourced from the World Bank's World Development Indicators (WDI). Available at: https://data.worldbank.org/indicator/ST.INT.DPRT. Population data sourced from the World Bank's World Development Indicators (WDI); figures were divided by 1000. Available at: https://databank.worldbank.org/indicator/SP.POP.TOTL/1ff4a498/Popular-Indicators. https://data.worldbank.org/indicator/ST.INT.DPRT and https://databank.worldbank.org/indicator/SP.POP.TOTL/1ff4a498/Popular-Indicators World Bank

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