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

1 row where datasetId = 5411 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
21246 Ericson et al. (2021). Blood lead levels in low-income and middle-income countries: a systematic review. The Lancet Planetary Health. 
{
    "link": "https://www.thelancet.com/journals/lanplh/article/PIIS2542-5196%2820%2930278-3/fulltext",
    "additionalInfo": "Ericson et al. (2021) collated studies measuring lead blood concentrations in children and adults between 2010 and 2019. This analysis yielded 520 studies covering 1100 sampled populations with a total population of 1,003,455 people from 49 countries.\n\nChildren are defined as those aged 0 to 14 years.\n\nBlood level concentrations are measured in \u00b5g/dL. There is no defined 'safe' level for lead blood concentrations. The WHO adopts a threshold of 5 \u00b5g/dL as an achievable maximum level in children.",
    "dataPublishedBy": "Ericson, B., Hu, H., Nash, E., Ferraro, G., Sinitsky, J., & Taylor, M. P. (2021). Blood lead levels in low-income and middle-income countries: a systematic review. The Lancet Planetary Health, 5(3), e145-e153."
}
 2021-11-17 21:07:52 2021-11-17 21:07:52 Lead blood concentrations in LMIC (Ericson et al. 2021) 5411 Ericson et al. (2021) collated studies measuring lead blood concentrations in children and adults between 2010 and 2019. This analysis yielded 520 studies covering 1100 sampled populations with a total population of 1,003,455 people from 49 countries. Children are defined as those aged 0 to 14 years. Blood level concentrations are measured in µg/dL. There is no defined 'safe' level for lead blood concentrations. The WHO adopts a threshold of 5 µg/dL as an achievable maximum level in children. https://www.thelancet.com/journals/lanplh/article/PIIS2542-5196%2820%2930278-3/fulltext Ericson, B., Hu, H., Nash, E., Ferraro, G., Sinitsky, J., & Taylor, M. P. (2021). Blood lead levels in low-income and middle-income countries: a systematic review. The Lancet Planetary Health, 5(3), e145-e153.

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