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 = 591 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
2229 WHO Global Database on Vitamin A Deficiency 
{
    "link": "http://apps.who.int/iris/bitstream/10665/44110/1/9789241598019_eng.pdf",
    "retrievedDate": "23/07/2017",
    "additionalInfo": "Data on vitamin-A deficiency is based on the reported prevalence of risk by the World Health Organization, which has collated national and household level survey data on indicators extending the period 1995-2005. Note that data on vitamin-A deficiency is typically not measured on an annual basis, therefore the year of measurement will vary by country, but lie within the period 1995-2005.\n\nAll countries with a GDP per capita \u2265US$15,000 were assumed by the WHO to be free from vitamin-A deficiency of a public health significance and were therefore excluded.. None of these 37 countries had retinol or night blindness data reported for either preschool-age children or pregnant women.\n\nTwo sets of indicators of VAD are commonly used for population surveys: clinically assessed eye signs and biochemically determined concentrations of retinol in plasma or serum. The incidence of night blindness in individuals indicates moderate-to-severe systemic VAD. VAD can also be identified when serum retinol concentrations fall below below a cut-off value of 0.70 \u00b5mol/l.\n\nVitamin A deficiency (VAD) is a major nutritional concern in poor societies, especially in lower income countries. Its presence as a public health problem is assessed by measuring the prevalence of deficiency in a population, represented by specific biochemical and clinical indicators of status. The main underlying cause of VAD as a public health problem is a diet that is chronically insufficient in vitamin A that can lead to lower body stores and fail to meet physiologic needs (e.g. support tissue growth, normal metabolism, resistance to infection). Deficiency of sufficient duration or severity can lead to disorders that are common in vitamin A deficient populations such as xerophthalmia (xeros = dryness; -ophthalmia = pertaining to the eye), the leading cause of preventable childhood blindness, anaemia, and weakened host resistance to infection, which can increase the severity of infectious diseases and risk of death.",
    "dataPublishedBy": "WHO. Global prevalence of vitamin A deficiency in populations at risk 1995\u20132005. WHO Global Database on Vitamin A Deficiency. Geneva, World Health Organization, 2009.",
    "dataPublisherSource": "National and household survey data extending 1995-2005."
}
 2017-07-23 20:00:04 2017-11-02 13:04:39 Prevalence of vitamin-A deficiency in pregnant women - WHO (2009) 591 Data on vitamin-A deficiency is based on the reported prevalence of risk by the World Health Organization, which has collated national and household level survey data on indicators extending the period 1995-2005. Note that data on vitamin-A deficiency is typically not measured on an annual basis, therefore the year of measurement will vary by country, but lie within the period 1995-2005. All countries with a GDP per capita ≥US$15,000 were assumed by the WHO to be free from vitamin-A deficiency of a public health significance and were therefore excluded.. None of these 37 countries had retinol or night blindness data reported for either preschool-age children or pregnant women. Two sets of indicators of VAD are commonly used for population surveys: clinically assessed eye signs and biochemically determined concentrations of retinol in plasma or serum. The incidence of night blindness in individuals indicates moderate-to-severe systemic VAD. VAD can also be identified when serum retinol concentrations fall below below a cut-off value of 0.70 µmol/l. Vitamin A deficiency (VAD) is a major nutritional concern in poor societies, especially in lower income countries. Its presence as a public health problem is assessed by measuring the prevalence of deficiency in a population, represented by specific biochemical and clinical indicators of status. The main underlying cause of VAD as a public health problem is a diet that is chronically insufficient in vitamin A that can lead to lower body stores and fail to meet physiologic needs (e.g. support tissue growth, normal metabolism, resistance to infection). Deficiency of sufficient duration or severity can lead to disorders that are common in vitamin A deficient populations such as xerophthalmia (xeros = dryness; -ophthalmia = pertaining to the eye), the leading cause of preventable childhood blindness, anaemia, and weakened host resistance to infection, which can increase the severity of infectious diseases and risk of death. http://apps.who.int/iris/bitstream/10665/44110/1/9789241598019_eng.pdf WHO. Global prevalence of vitamin A deficiency in populations at risk 1995–2005. WHO Global Database on Vitamin A Deficiency. Geneva, World Health Organization, 2009.

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