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

3 rows where datasetId = 5784 sorted by id descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: additionalInfo, createdAt (date), updatedAt (date)

id ▲ name description createdAt updatedAt datasetId additionalInfo link dataPublishedBy
30913 Gapminder (Systema Globalis); International Telecommunication Union (via World Bank); UN (2022); Gapminder (2019); HYDE (2017) 
{
    "link": "https://github.com/open-numbers/ddf--gapminder--systema_globalis ; https://datacatalog.worldbank.org/search/dataset/0037712/World-Development-Indicators ; https://population.un.org/wpp/Download/Standard/Population/ ; https://docs.google.com/spreadsheets/d/14_suWY8fCPEXV0MH7ZQMZ-KndzMVsSsA5HdR-7WqAC0/edit#gid=501532268 ; https://dataportaal.pbl.nl/downloads/HYDE/",
    "retrievedDate": "December 12, 2022",
    "additionalInfo": "The Internet dataset by Our World in Data contains different Internet-related metrics.",
    "dataPublishedBy": "Gapminder (Systema Globalis); World Development Indicators - World Bank (2022.05.26); UN, World Population Prospects (2022); Gapminder (v6); HYDE (v3.2)"
}
 2024-07-25 23:07:05   Internet (various sources) 5784 The Internet dataset by Our World in Data contains different Internet-related metrics. https://github.com/open-numbers/ddf--gapminder--systema_globalis ; https://datacatalog.worldbank.org/search/dataset/0037712/World-Development-Indicators ; https://population.un.org/wpp/Download/Standard/Population/ ; https://docs.google.com/spreadsheets/d/14_suWY8fCPEXV0MH7ZQMZ-KndzMVsSsA5HdR-7WqAC0/edit#gid=501532268 ; https://dataportaal.pbl.nl/downloads/HYDE/ Gapminder (Systema Globalis); World Development Indicators - World Bank (2022.05.26); UN, World Population Prospects (2022); Gapminder (v6); HYDE (v3.2)
27495 International Telecommunication Union (via World Bank); Gapminder (2019); UN (2022); HYDE (2017); Gapminder (Systema Globalis) 
{
    "link": "https://datacatalog.worldbank.org/search/dataset/0037712/World-Development-Indicators ; https://docs.google.com/spreadsheets/d/14_suWY8fCPEXV0MH7ZQMZ-KndzMVsSsA5HdR-7WqAC0/edit#gid=501532268 ; https://population.un.org/wpp/Download/Standard/Population/ ; https://dataportaal.pbl.nl/downloads/HYDE/ ; https://github.com/open-numbers/ddf--gapminder--systema_globalis",
    "retrievedDate": "2022-06-02",
    "additionalInfo": "Key user statistics related to Internet (e.g. number of individuals using the Internet).",
    "dataPublishedBy": "World Development Indicators - World Bank (2022.05.26); Gapminder (v6); UN, World Population Prospects (2022); HYDE (v3.2); Gapminder (Systema Globalis)"
}
 2023-04-04 20:30:57 2024-07-25 23:07:05 Internet (various sources) 5784 Key user statistics related to Internet (e.g. number of individuals using the Internet). https://datacatalog.worldbank.org/search/dataset/0037712/World-Development-Indicators ; https://docs.google.com/spreadsheets/d/14_suWY8fCPEXV0MH7ZQMZ-KndzMVsSsA5HdR-7WqAC0/edit#gid=501532268 ; https://population.un.org/wpp/Download/Standard/Population/ ; https://dataportaal.pbl.nl/downloads/HYDE/ ; https://github.com/open-numbers/ddf--gapminder--systema_globalis World Development Indicators - World Bank (2022.05.26); Gapminder (v6); UN, World Population Prospects (2022); HYDE (v3.2); Gapminder (Systema Globalis)
27076 International Telecommunication Union (via World Bank) 
{
    "link": "https://datacatalog.worldbank.org/search/dataset/0037712/World-Development-Indicators",
    "retrievedDate": "2022-06-02",
    "additionalInfo": "Key user statistics related to Internet (e.g. number of individuals using the Internet).",
    "dataPublishedBy": "World Development Indicators - World Bank (2022.05.26)"
}
 2022-09-27 14:07:54 2024-07-25 23:07:05 Internet (various sources) 5784 Key user statistics related to Internet (e.g. number of individuals using the Internet). https://datacatalog.worldbank.org/search/dataset/0037712/World-Development-Indicators World Development Indicators - World Bank (2022.05.26)

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