USA Contagious Disease Data

This public data is published by the US Department of Health and Human Services and includes all weekly surveillance reports of nationally notifiable diseases for all U.S. cities and states published between 1888 and 2013. The data set consists of eight important vaccine-preventable contagious diseases: diphtheria, hepatitis A, measles, mumps, pertussis, polio, rubella and smallpox.

You can start exploring this data in the BigQuery console:

Go to the USA Contagious Disease Dataset

Sample queries

Here are some examples of SQL queries you can run on this data in BigQuery.

These samples use BigQuery’s legacy SQL by setting the #legacySQL prefix. For more information, see Setting a query prefix.

Diseases by year

Comparing Mumps outbreak in California and Connecticut

Mumps shows the same seasonal pattern coast to coast, in both California and Connecticut, during the 1970 outbreak.

About the data

Dataset Source: Data.gov

Category: Health

Use: This dataset is publicly available for anyone to use under the following terms provided by the Dataset Source — http://www.data.gov/privacy-policy#data_policy — and is provided "AS IS" without any warranty, express or implied, from Google. Google disclaims all liability for any damages, direct or indirect, resulting from the use of the dataset.

View in BigQuery: Go to the USA Contagious Diseasae Dataset

Send feedback about...

BigQuery Documentation