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 = 6384 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
30065 United Nations (2023) 
{
    "link": "https://unstats.un.org/sdgs/dataportal/database",
    "retrievedDate": "2023-08-16",
    "additionalInfo": "\nThe United Nations Sustainable Development Goal (SDG) dataset is the primary collection of data tracking progress towards the SDG indicators,\ncompiled from officially-recognized international sources.",
    "dataPublishedBy": "SDG Indicators Database, United Nations, Department of Economic and Social Affairs (2023)"
}
 2024-02-15 12:38:01 2024-07-08 15:18:14 United Nations Sustainable Development Goals (2023-Q2) - Urbanization 6384 The United Nations Sustainable Development Goal (SDG) dataset is the primary collection of data tracking progress towards the SDG indicators, compiled from officially-recognized international sources. https://unstats.un.org/sdgs/dataportal/database SDG Indicators Database, United Nations, Department of Economic and Social Affairs (2023)
30064 United Nations (2023) 
{
    "link": "https://unstats.un.org/sdgs/dataportal/database",
    "retrievedDate": "2023-08-16",
    "additionalInfo": "The United Nations Sustainable Development Goal (SDG) dataset is the primary collection of data tracking progress towards the SDG indicators,\ncompiled from officially-recognized international sources.",
    "dataPublishedBy": "SDG Indicators Database, United Nations, Department of Economic and Social Affairs (2023)"
}
 2024-02-15 12:38:01 2024-07-08 15:18:14 United Nations Sustainable Development Goals (2023-Q2) - Urbanization 6384 The United Nations Sustainable Development Goal (SDG) dataset is the primary collection of data tracking progress towards the SDG indicators, compiled from officially-recognized international sources. https://unstats.un.org/sdgs/dataportal/database SDG Indicators Database, United Nations, Department of Economic and Social Affairs (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");