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 = 6022 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
30132 Lead paint regulations (WHO, 2023) 
{
    "link": "https://www.who.int/data/gho/data/themes/topics/indicator-groups/legally-binding-controls-on-lead-paint",
    "retrievedDate": null,
    "additionalInfo": "",
    "dataPublishedBy": "World Health Organization (WHO)"
}
 2024-02-26 22:53:07 2024-05-05 18:45:15 Lead paint regulations (WHO, 2023) 6022   https://www.who.int/data/gho/data/themes/topics/indicator-groups/legally-binding-controls-on-lead-paint World Health Organization (WHO)
27637 Lead paint regulations (WHO, 2023) 
{
    "link": "https://www.who.int/data/gho/data/themes/topics/indicator-groups/legally-binding-controls-on-lead-paint",
    "retrievedDate": null,
    "additionalInfo": "The WHO collects data on which countries have legally-binding controls on lead paint. It sources this data from surveys conducted by WHO and UNEP of national authorities. The World Health Organization (WHO) tracks the introduction of legally-binding controls on lead concentrations in paint. Paint is a main contributor to harmful lead exposure.\n\nThe stringency of controls on lead paint can vary by country. Maximum concentrations of lead can differ, and may only apply to particular types of paint (for example, products used in households).",
    "dataPublishedBy": "World Health Organization (WHO)"
}
 2023-05-31 05:28:53 2024-05-05 18:45:15 Lead paint regulations (WHO, 2023) 6022 The WHO collects data on which countries have legally-binding controls on lead paint. It sources this data from surveys conducted by WHO and UNEP of national authorities. The World Health Organization (WHO) tracks the introduction of legally-binding controls on lead concentrations in paint. Paint is a main contributor to harmful lead exposure. The stringency of controls on lead paint can vary by country. Maximum concentrations of lead can differ, and may only apply to particular types of paint (for example, products used in households). https://www.who.int/data/gho/data/themes/topics/indicator-groups/legally-binding-controls-on-lead-paint World Health Organization (WHO)

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