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 = 4241 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
17069 NCD RisC (2017) 
{
    "link": "http://ncdrisc.org/data-downloads-blood-pressure.html, https://www.thelancet.com/journals/lancet/article/PIIS0140-6736(16)31919-5/fulltext",
    "retrievedDate": "30/10/19",
    "additionalInfo": "This dataset presents crude and age-standardised estimates of the prevalence of raised blood pressure by country, region, and globally for men and women.\n\nRaised blood pressure (BP) is defined as systolic BP \u2265140 mmHg, or diastolic BP \u226590 mmHg.\n\nThe data was pooled from 1,479 studies that had measured the blood pressures of 19.1 million adults.",
    "dataPublishedBy": "Zhou, B., Bentham, J., Di Cesare, M., Bixby, H., Danaei, G., Cowan, M. J., ... & Taddei, C. (2017). Worldwide trends in blood pressure from 1975 to 2015: a pooled analysis of 1479 population-based measurement studies with 19.1 million participants. The Lancet, 389(10064), 37-55.",
    "dataPublisherSource": "Studies"
}
 2019-10-30 16:07:02 2019-10-30 16:07:02 Raised Blood Pressure Prevalence - NCD RisC (2017) 4241 This dataset presents crude and age-standardised estimates of the prevalence of raised blood pressure by country, region, and globally for men and women. Raised blood pressure (BP) is defined as systolic BP ≥140 mmHg, or diastolic BP ≥90 mmHg. The data was pooled from 1,479 studies that had measured the blood pressures of 19.1 million adults. http://ncdrisc.org/data-downloads-blood-pressure.html, https://www.thelancet.com/journals/lancet/article/PIIS0140-6736(16)31919-5/fulltext Zhou, B., Bentham, J., Di Cesare, M., Bixby, H., Danaei, G., Cowan, M. J., ... & Taddei, C. (2017). Worldwide trends in blood pressure from 1975 to 2015: a pooled analysis of 1479 population-based measurement studies with 19.1 million participants. The Lancet, 389(10064), 37-55.

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