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 = 3014 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
2820 OWID Disease Burden Variables (using WHO and UNPD) 
{
    "link": "http://apps.who.int/gho/data/node.home https://esa.un.org/unpd/wpp/Download/Standard/Population/",
    "retrievedDate": "03/08/2017",
    "additionalInfo": "Additional information on data sources: \nGlobal Health Observatory (GHO) used surveillance systems to publish data on the number of cases for different diseases. Only the confirmed cases are reported by GHO. \nTo calculate the number of cases and deaths relative to the size of population, estimates provided by World Population Prospects, UNPD were used. These population estimates, are consistent with countries\u2019 censuses, and subsequent trends in fertility, mortality and international migration.\nHandling data issues: \nUsing data on the number of cases and total population, standardized variables on disease burden (i.e. cases relative to the population) are created. One of the main challenges faced in constructing these variables was inconsistency in the definition of world regions. The data on disease burden (i.e. cases or deaths) is taken from GHO. It uniquely divides countries into six WHO regions. However, this is not the case in UNPD population dataset. To overcome this, we use the list of countries in each world region provided by WHO (http://www.who.int/about/regions/en/). Population figures are constructed by adding population estimates of countries in each WHO region. Since these estimates were originally in thousands, they are multiplied by 0.001 to get total population figures for countries and regions in millions. Finally, the ratio of the number of confirmed disease cases and population (in millions) is taken to report in this dataset.",
    "dataPublishedBy": "Our World In Data (dataset constructed by Ruby Mittal)",
    "dataPublisherSource": "Data on number of cases corresponds to WHO\u2019s Global Health Observatory. Data on population estimates (1950-2015) corresponds to World Population Prospects, Population Division, United Nations (UNPD)"
}
 2017-08-03 12:39:22 2017-11-02 13:04:39 Cases of tetanus per million population (WHO and UNPD 2017) (split) 3014 Additional information on data sources: Global Health Observatory (GHO) used surveillance systems to publish data on the number of cases for different diseases. Only the confirmed cases are reported by GHO. To calculate the number of cases and deaths relative to the size of population, estimates provided by World Population Prospects, UNPD were used. These population estimates, are consistent with countries’ censuses, and subsequent trends in fertility, mortality and international migration. Handling data issues: Using data on the number of cases and total population, standardized variables on disease burden (i.e. cases relative to the population) are created. One of the main challenges faced in constructing these variables was inconsistency in the definition of world regions. The data on disease burden (i.e. cases or deaths) is taken from GHO. It uniquely divides countries into six WHO regions. However, this is not the case in UNPD population dataset. To overcome this, we use the list of countries in each world region provided by WHO (http://www.who.int/about/regions/en/). Population figures are constructed by adding population estimates of countries in each WHO region. Since these estimates were originally in thousands, they are multiplied by 0.001 to get total population figures for countries and regions in millions. Finally, the ratio of the number of confirmed disease cases and population (in millions) is taken to report in this dataset. http://apps.who.int/gho/data/node.home https://esa.un.org/unpd/wpp/Download/Standard/Population/ Our World In Data (dataset constructed by Ruby Mittal)

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