sources
Data license: CC-BY
1 row where datasetId = 1836 sorted by id descending
This data as json, CSV (advanced)
Suggested facets: createdAt (date), updatedAt (date)
id ▲ | name | description | createdAt | updatedAt | datasetId | additionalInfo | link | dataPublishedBy |
---|---|---|---|---|---|---|---|---|
13146 | Our World in Data (2017) | { "link": "Case and death counts: https://www.jstor.org/journal/publhealrepo1896 https://stacks.cdc.gov/welcome (select MMWR Series and limit the search to Annual publications) \u2028https://www.census.gov/library/publications/time-series/statistical_abstracts.html US Population estimates: https://www.census.gov/library/publications/time-series/statistical_abstracts.html https://esa.un.org/unpd/wpp/DVD/Files/1_Indicators%20(Standard)/EXCEL_FILES/1_Population/WPP2017_POP_F01_1_TOTAL_POPULATION_BOTH_SEXES.xlsx", "retrievedDate": "22 November 2017", "additionalInfo": "Cases: \n1921: Public Health Reports Vol. 37, No. 41 \"The Notifiable Diseases: Prevalence during 1921 in States. Anthrax, Cerebrospinal Meningitis, Dengue, Diphtheria, Gonorrhea, Influenza, Malaria, Measles, Pneumonia, Poliomyelitis, Rabies, Rocky Mountain Spotted Fever, Scarlet Fever, Septic Sore Throat, Smallpox, Syphilis, Tuberculosis (All Forms and Pulmonary), Typhoid Fever, and Typhus Fever\u201d \n1924: Public Health Reports Vol. 40, No. 51 \u201cThe notifiable diseases: Prevalence during 1924 in States\u201d\n1925: Public Health Reports Vol. 42, No. 1 \u201cThe notifiable diseases: Prevalence during 1924 in States\u201d\n1938-1943: US Census Bureau \u201cStatistical Abstract of the United States 1944-45\u201d available here: https://www.census.gov/library/publications/1945/compendia/statab/66ed.html\n1944-1993: Morbidity and Mortality Weekly Report Annual Supplement Summary 1993 Vol. 42, No. 53 by the US Public Health Service \n1994-1999: Morbidity and Mortality Weekly Report 2001 Vol. 48 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm4853a1.htm\n2000-2005: Morbidity and Mortality Weekly Report 2005 Vol. 54 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm5453a1.htm\n2006-2010: Morbidity and Mortality Weekly Report 2010 Vol. 59 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm5953a1.htm\n2011-2012: Morbidity and Mortality Weekly Report 2012 Vol. 61 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm6153a1.htm\n2013: Morbidity and Mortality Weekly Report 2015 Vol. 62 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm6253a1.htm\n2014: Morbidity and Mortality Weekly Report 2016 Vol. 63 Nr. 54 DOI: http://dx.doi.org/10.15585/mmwr.mm6354a1\n2015: Morbidity and Mortality Weekly Report 2017 Vol. 64 Nr. 53 DOI: http://dx.doi.org/10.15585/mmwr.mm6453a1\n\n\nDeaths: \n1921: Public Health Reports Vol. 37, No. 41 \"The Notifiable Diseases: Prevalence during 1921 in States. Anthrax, Cerebrospinal Meningitis, Dengue, Diphtheria, Gonorrhea, Influenza, Malaria, Measles, Pneumonia, Poliomyelitis, Rabies, Rocky Mountain Spotted Fever, Scarlet Fever, Septic Sore Throat, Smallpox, Syphilis, Tuberculosis (All Forms and Pulmonary), Typhoid Fever, and Typhus Fever\u201d \n1922-23: US Census Bureau \u201cStatistical Abstract of the United States: 1924\u201d available here: https://www.census.gov/library/publications/1925/compendia/statab/47ed.html\n1924: Public Health Reports Vol. 40, No. 51 \u201cThe notifiable diseases: Prevalence during 1924 in States\u201d\n1925: Public Health Reports Vol. 42, No. 1 \u201cThe notifiable diseases: Prevalence during 1924 in States\u201d\n1926: US Census Bureau \u201cStatistical Abstract of the United States: 1928\u201d available here: https://www.census.gov/library/publications/1928/compendia/statab/50ed.html\n1927: US Census Bureau \u201cStatistical Abstract of the United States: 1929\u201d available here: https://www.census.gov/library/publications/1929/compendia/statab/50ed.html\n1928: US Census Bureau \u201cStatistical Abstract of the United States: 1930\u201d available here: https://www.census.gov/library/publications/1930/compendia/statab/52ed.html\n1929: US Census Bureau \u201cStatistical Abstract of the United States: 1931\u201d available here: https://www.census.gov/library/publications/1931/compendia/statab/53ed.html\n1931: US Census Bureau \u201cStatistical Abstract of the United States: 1933\u201d available here: https://www.census.gov/library/publications/1933/compendia/statab/55ed.html\n1932: US Census Bureau \u201cStatistical Abstract of the United States: 1934\u201d available here:\nhttps://www.census.gov/library/publications/1934/compendia/statab/56ed.html\n1933: US Census Bureau \u201cStatistical Abstract of the United States: 1935\u201d available here:\nhttps://www.census.gov/library/publications/1935/compendia/statab/57ed.html\n1934: US Census Bureau \u201cStatistical Abstract of the United States: 1936\u201d available here:\nhttps://www.census.gov/library/publications/1936/compendia/statab/58ed.html\n1935: US Census Bureau \u201cStatistical Abstract of the United States: 1937\u201d available here:\nhttps://www.census.gov/library/publications/1938/compendia/statab/59ed.html\n1936: US Census Bureau \u201cStatistical Abstract of the United States: 1938\u201d available here:\nhttps://www.census.gov/library/publications/1939/compendia/statab/60ed.html\n1937: US Census Bureau \u201cStatistical Abstract of the United States: 1938\u201d available here:\nhttps://www.census.gov/library/publications/1940/compendia/statab/61ed.html\n1938: Public Health Reports Vol. 55 No. 7 Notifiable Diseases in the United States, 1938: Morbidity and Mortality Summaries for Certain Important Communicable Diseases\n1939: Public Health Reports Vol. 56 No. 7 Notifiable Diseases in the United States, 1939: Morbidity and Mortality Summaries for Certain Important Communicable Diseases\n1940: Public Health Reports Vol. 57 No. 7 Notifiable Diseases in the United States, 1940: Morbidity and Mortality Summaries for Certain Important Communicable Diseases\n1949: US Census Bureau \u201cStatistical Abstract of the United States: 1952\u201d available here:\nhttps://www.census.gov/library/publications/1952/compendia/statab/73ed.html\n1950-1959: Morbidity and Mortality Weekly Report Annual Supplement Summary Vol. 9, No. 53 by the US Public Health Service\n1960-1968: Morbidity and Mortality Weekly Report Annual Supplement Summary 1970 Vol. 19, No. 53 by the US Public Health Service \n1969: Morbidity and Mortality Weekly Report Annual Supplement Summary 1972 Vol. 21, No. 53 by the US Public Health Service \n1970-1978: Morbidity and Mortality Weekly Report Annual Supplement Summary 1980 Vol. 29, No. 54 by the US Public Health Service \n1982-1991: Morbidity and Mortality Weekly Report Annual Supplement Summary 1993 Vol. 42, No. 53 by the US Public Health Service \n1992-1998: Morbidity and Mortality Weekly Report 2001 Vol. 48 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm4853a1.htm\n1999-2001: Morbidity and Mortality Weekly Report 2003 Vol. 52 Nr. 54 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm5254a1.htm\n2002-2008: Morbidity and Mortality Weekly Report 2010 Vol. 59 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm5953a1.htm\n2009-2014: Morbidity and Mortality Weekly Report 2016 Vol. 63 Nr. 54 DOI: http://dx.doi.org/10.15585/mmwr.mm6354a1\n\n\nUS Population estimates: \n1921-1949: US Census Bureau \u201cStatistical Abstract of the United States: 1950\u201d available here:\nhttps://www.census.gov/library/publications/1950/compendia/statab/71ed.html\n1950-2015: United Nations DESA Population Division (2017) \u201cWorld Population Prospects Report\u201d available here: https://esa.un.org/unpd/wpp/DVD/Files/1_Indicators%20(Standard)/EXCEL_FILES/1_Population/WPP2017_POP_F01_1_TOTAL_POPULATION_BOTH_SEXES.xlsx", "dataPublishedBy": "Our World in Data (Compiled by Sophie Ochmann)", "dataPublisherSource": "Case and deaths counts: Several publications from the Public Health Reports (1896-1970) Series, the US Public Health Service's Morbidity and Mortality Weekly Report (MMWR) Annual Supplements and the US Census\u2019s Annual Statistical Abstracts of the United States Series (1878-2012) US Population estimates: US Census Bureau's Statistical Abstract of the United States from 1950 and the The United Nations DESA Population Division latest \"World Population Prospects\" Report from 2017" } |
2017-11-22 15:52:32 | 2017-11-22 15:52:32 | US Measles Cases and Deaths (OWID, 2017) 1836 | Cases: 1921: Public Health Reports Vol. 37, No. 41 "The Notifiable Diseases: Prevalence during 1921 in States. Anthrax, Cerebrospinal Meningitis, Dengue, Diphtheria, Gonorrhea, Influenza, Malaria, Measles, Pneumonia, Poliomyelitis, Rabies, Rocky Mountain Spotted Fever, Scarlet Fever, Septic Sore Throat, Smallpox, Syphilis, Tuberculosis (All Forms and Pulmonary), Typhoid Fever, and Typhus Fever” 1924: Public Health Reports Vol. 40, No. 51 “The notifiable diseases: Prevalence during 1924 in States” 1925: Public Health Reports Vol. 42, No. 1 “The notifiable diseases: Prevalence during 1924 in States” 1938-1943: US Census Bureau “Statistical Abstract of the United States 1944-45” available here: https://www.census.gov/library/publications/1945/compendia/statab/66ed.html 1944-1993: Morbidity and Mortality Weekly Report Annual Supplement Summary 1993 Vol. 42, No. 53 by the US Public Health Service 1994-1999: Morbidity and Mortality Weekly Report 2001 Vol. 48 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm4853a1.htm 2000-2005: Morbidity and Mortality Weekly Report 2005 Vol. 54 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm5453a1.htm 2006-2010: Morbidity and Mortality Weekly Report 2010 Vol. 59 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm5953a1.htm 2011-2012: Morbidity and Mortality Weekly Report 2012 Vol. 61 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm6153a1.htm 2013: Morbidity and Mortality Weekly Report 2015 Vol. 62 Nr. 53 https://www.cdc.gov/mmwr/preview/mmwrhtml/mm6253a1.htm 2014: Morbidity and Mortality Weekly Report 2016 Vol. 63 Nr. 54 DOI: http://dx.doi.org/10.15585/mmwr.mm6354a1 2015: Morbidity and Mortality Weekly Report 2017 Vol. 64 Nr. 53 DOI: http://dx.doi.org/10.15585/mmwr.mm6453a1 Deaths: 1921: Public Health Reports Vol. 37, No. 41 "The Notifiable Diseases: Prevalence during 1921 in States. Anthrax, Cerebrospinal Meningitis, Dengue, Diphtheria, Gonorrhea, Influenza, Malaria, Measles, Pneumonia, Poliomyelitis, Rabies, Rocky Mountain Spotted Fever, Scarlet Fever, Septic Sore Thro… | Case and death counts: https://www.jstor.org/journal/publhealrepo1896 https://stacks.cdc.gov/welcome (select MMWR Series and limit the search to Annual publications) https://www.census.gov/library/publications/time-series/statistical_abstracts.html US Population estimates: https://www.census.gov/library/publications/time-series/statistical_abstracts.html https://esa.un.org/unpd/wpp/DVD/Files/1_Indicators%20(Standard)/EXCEL_FILES/1_Population/WPP2017_POP_F01_1_TOTAL_POPULATION_BOTH_SEXES.xlsx | Our World in Data (Compiled by Sophie Ochmann) |
Advanced export
JSON shape: default, array, newline-delimited, object
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");