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

2 rows where datasetId = 6014 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
29559 UNWTO and OECD 
{
    "link": "https://www.unwto.org/tourism-statistics/economic-contribution-SDG",
    "retrievedDate": "2023-05-09",
    "additionalInfo": "\nUNWTO Department of Statistics data on the Sustainable Development Goals indicators 8.9.1 and 12.b.1, included in the Global Indicator Framework. Data collection started in 2019 and provides data from 2008 onwards, the latest update took place on 15 March 2023. Indicator 8.9.1 on Tourism Direct GDP helps to monitor Target 8.9 which calls on countries \u201cto promote sustainable tourism\u201d under Goal 8 on decent Work and Economic Growth. The data collection is done in cooperation with the OECD.\n\nThe United Nations World Tourism Organization (UNWTO) collects data from countries through annual questionnaires that follow the International Recommendations for Tourism Statistics (IRTS 2008) standard, a framework approved by the United Nations.\n",
    "dataPublishedBy": "World Tourism Organization, 2023"
}
 2023-12-14 12:03:14 2024-07-08 16:20:12 UNWTO GDP from Tourism 6014 UNWTO Department of Statistics data on the Sustainable Development Goals indicators 8.9.1 and 12.b.1, included in the Global Indicator Framework. Data collection started in 2019 and provides data from 2008 onwards, the latest update took place on 15 March 2023. Indicator 8.9.1 on Tourism Direct GDP helps to monitor Target 8.9 which calls on countries “to promote sustainable tourism” under Goal 8 on decent Work and Economic Growth. The data collection is done in cooperation with the OECD. The United Nations World Tourism Organization (UNWTO) collects data from countries through annual questionnaires that follow the International Recommendations for Tourism Statistics (IRTS 2008) standard, a framework approved by the United Nations. https://www.unwto.org/tourism-statistics/economic-contribution-SDG World Tourism Organization, 2023
27627 UNWTO and OECD 
{
    "link": "https://www.unwto.org/tourism-statistics/economic-contribution-SDG",
    "retrievedDate": "2023-05-09",
    "additionalInfo": "UNWTO Department of Statistics data on the Sustainable Development Goals indicators 8.9.1 and 12.b.1, included in the Global Indicator Framework. Data collection started in 2019 and provides data from 2008 onwards, the latest update took place on 15 March 2023. Indicator 8.9.1 on Tourism Direct GDP helps to monitor Target 8.9 which calls on countries \u201cto promote sustainable tourism\u201d under Goal 8 on decent Work and Economic Growth. The data collection is done in cooperation with the OECD.\n\nThe United Nations World Tourism Organization (UNWTO) collects data from countries through annual questionnaires that follow the International Recommendations for Tourism Statistics (IRTS 2008) standard, a framework approved by the United Nations.\n",
    "dataPublishedBy": "World Tourism Organization, 2023"
}
 2023-05-26 09:30:47 2024-07-08 16:20:12 UNWTO GDP from Tourism 6014 UNWTO Department of Statistics data on the Sustainable Development Goals indicators 8.9.1 and 12.b.1, included in the Global Indicator Framework. Data collection started in 2019 and provides data from 2008 onwards, the latest update took place on 15 March 2023. Indicator 8.9.1 on Tourism Direct GDP helps to monitor Target 8.9 which calls on countries “to promote sustainable tourism” under Goal 8 on decent Work and Economic Growth. The data collection is done in cooperation with the OECD. The United Nations World Tourism Organization (UNWTO) collects data from countries through annual questionnaires that follow the International Recommendations for Tourism Statistics (IRTS 2008) standard, a framework approved by the United Nations. https://www.unwto.org/tourism-statistics/economic-contribution-SDG World Tourism Organization, 2023

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