owid: sources: 2 rows where datasetId = 6002 sorted by id descending

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 = 6002 sorted by id descending

descending

✎ View and edit SQL

This data as json, CSV (advanced)

id ▲	name	description	createdAt	updatedAt	datasetId	additionalInfo	link	dataPublishedBy
29552	Institute of Health Metrics and Evaluation (2022)	{ "link": "https://api.healthdata.org/sdg/v1/docs & https://api.healthdata.org/sdg/v1/docs", "retrievedDate": "2023-05-05", "additionalInfo": "\nIHME produced estimates and forecasts for 13 of the SDG indicators included in the Goalkeepers Report.\n\nIHME provides estimated data for the years 1990-2021 and projections for three different scenarios for the years 2021-2023.\n\nThe scenarios provided are: a reference case, best case and worst case.\n\nThe full description of the methods used to produce the data can be found here: https://www.gatesfoundation.org/goalkeepers/report/2022-report/data-sources/#ExploretheIndicatorPages\n", "dataPublishedBy": "Institute for Health Metrics and Evaluation (IHME). Health-related SDGs. Seattle, WA: IHME, University of Washington, 2022. Available from https://api.healthdata.org/sdg/v1/docs" }	2023-12-14 12:02:41	2024-05-05 18:56:05	Sustainable Development Goals (IHME, 2022) 6002	IHME produced estimates and forecasts for 13 of the SDG indicators included in the Goalkeepers Report. IHME provides estimated data for the years 1990-2021 and projections for three different scenarios for the years 2021-2023. The scenarios provided are: a reference case, best case and worst case. The full description of the methods used to produce the data can be found here: https://www.gatesfoundation.org/goalkeepers/report/2022-report/data-sources/#ExploretheIndicatorPages	https://api.healthdata.org/sdg/v1/docs & https://api.healthdata.org/sdg/v1/docs	Institute for Health Metrics and Evaluation (IHME). Health-related SDGs. Seattle, WA: IHME, University of Washington, 2022. Available from https://api.healthdata.org/sdg/v1/docs
27595	Institute of Health Metrics and Evaluation (2022)	{ "link": "https://api.healthdata.org/sdg/v1/docs & https://api.healthdata.org/sdg/v1/docs", "retrievedDate": "2023-05-05", "additionalInfo": "IHME produced estimates and forecasts for 13 of the SDG indicators included in the Goalkeepers Report.\n\nIHME provides estimated data for the years 1990-2021 and projections for three different scenarios for the years 2021-2023.\n\nThe scenarios provided are: a reference case, best case and worst case.\n\nThe full description of the methods used to produce the data can be found here: https://www.gatesfoundation.org/goalkeepers/report/2022-report/data-sources/#ExploretheIndicatorPages\n", "dataPublishedBy": "Institute for Health Metrics and Evaluation (IHME). Health-related SDGs. Seattle, WA: IHME, University of Washington, 2022. Available from https://api.healthdata.org/sdg/v1/docs" }	2023-05-09 20:38:38	2024-05-05 18:55:53	Sustainable Development Goals (IHME, 2022) 6002	IHME produced estimates and forecasts for 13 of the SDG indicators included in the Goalkeepers Report. IHME provides estimated data for the years 1990-2021 and projections for three different scenarios for the years 2021-2023. The scenarios provided are: a reference case, best case and worst case. The full description of the methods used to produce the data can be found here: https://www.gatesfoundation.org/goalkeepers/report/2022-report/data-sources/#ExploretheIndicatorPages	https://api.healthdata.org/sdg/v1/docs & https://api.healthdata.org/sdg/v1/docs	Institute for Health Metrics and Evaluation (IHME). Health-related SDGs. Seattle, WA: IHME, University of Washington, 2022. Available from https://api.healthdata.org/sdg/v1/docs

Advanced export

JSON shape: default, array, newline-delimited, object

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