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 = 4242 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
17070 NCD RisC (2017) 
{
    "link": "http://www.ncdrisc.org/data-downloads-adiposity.html, http://www.thelancet.com/journals/lancet/article/PIIS0140-6736(17)32129-3/fulltext",
    "retrievedDate": "26/09/2019",
    "additionalInfo": "This dataset presents the mean Body Mass Index (BMI) by country, region, and globally for men and women.\n\nBody Mass Index (BMI) is a person's weight in kilograms (kg) divided by his or her height in meters squared (m2). The WHO define a BMI <=18.5 as 'underweight'; 18.5 to <25 as 'normal/healthy'; 25.0 to <30 as 'overweight'; and >30.0 as 'obese'.\n\nThe data was sourced from 2,416 population-based studies with measurements of height and weight on 97.4 million participants aged 20 years and older.\n\nNCD Risk Factor Collaboration (NCD-RisC) is a network of health scientists around the world that provides rigorous and timely data on risk factors for non-communicable diseases (NCDs) for 200 countries and territories. The group works closely with the World Health Organisation (WHO), through the WHO Collaborating Centre on NCD Surveillance and Epidemiology at Imperial College London. NCD-RisC pools high-quality population-based data using advanced statistical methods, designed specifically for analysing NCD risk factors. The Collaboration currently has data from over 2,000 population-based surveys from 189 countries since 1957, with nearly 25 million participants whose risk factor levels have been measured.",
    "dataPublishedBy": "Abarca-G\u00f3mez, L., Abdeen, Z. A., Hamid, Z. A., Abu-Rmeileh, N. M., Acosta-Cazares, B., Acuin, C., ... & Agyemang, C. (2017). Worldwide trends in body-mass index, underweight, overweight, and obesity from 1975 to 2016: a pooled analysis of 2416 population-based measurement studies in 128.9 million children, adolescents, and adults. The Lancet, 390(10113), 2627-2642.",
    "dataPublisherSource": "Surveys and studies "
}
 2019-10-30 16:22:26 2019-10-30 16:22:26 Mean BMI - NCD RisC (2017) 4242 This dataset presents the mean Body Mass Index (BMI) by country, region, and globally for men and women. Body Mass Index (BMI) is a person's weight in kilograms (kg) divided by his or her height in meters squared (m2). The WHO define a BMI <=18.5 as 'underweight'; 18.5 to <25 as 'normal/healthy'; 25.0 to <30 as 'overweight'; and >30.0 as 'obese'. The data was sourced from 2,416 population-based studies with measurements of height and weight on 97.4 million participants aged 20 years and older. NCD Risk Factor Collaboration (NCD-RisC) is a network of health scientists around the world that provides rigorous and timely data on risk factors for non-communicable diseases (NCDs) for 200 countries and territories. The group works closely with the World Health Organisation (WHO), through the WHO Collaborating Centre on NCD Surveillance and Epidemiology at Imperial College London. NCD-RisC pools high-quality population-based data using advanced statistical methods, designed specifically for analysing NCD risk factors. The Collaboration currently has data from over 2,000 population-based surveys from 189 countries since 1957, with nearly 25 million participants whose risk factor levels have been measured. http://www.ncdrisc.org/data-downloads-adiposity.html, http://www.thelancet.com/journals/lancet/article/PIIS0140-6736(17)32129-3/fulltext Abarca-Gómez, L., Abdeen, Z. A., Hamid, Z. A., Abu-Rmeileh, N. M., Acosta-Cazares, B., Acuin, C., ... & Agyemang, C. (2017). Worldwide trends in body-mass index, underweight, overweight, and obesity from 1975 to 2016: a pooled analysis of 2416 population-based measurement studies in 128.9 million children, adolescents, and adults. The Lancet, 390(10113), 2627-2642.

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