Infectious Disease Summary Data

Annual summary of mandatory reportable infectious diseases provided by the Minnesota Department of Health (MDH). The dataset includes counts of reportable infectious diseases confirmed for residents of the designated geographic area (e.g. Ramsey County, Minnesota, or Metro Region).

The Metro Region includes the following counties: Anoka, Carver, Dakota, Hennepin, Ramsey, Scott and Washington

Data notes:

1. Beginning in 2010, typhoid fever cases are included in the Salmonellosis category

2. Human Ehrlichiosis E. muris-like was renamed to E. muriseauclairensis in 2018. Reports prior to 2018 use E. muris-like

3. Due to staff being redeployed to the COVID response, no vectorborne disease data is available and only some zoonotic disease data is available for 2020. This includes: Anaplasmosis-Ehrlichiosis, undetermined, Babesiosis, Chikungunya, Dengue, Human Anaplasmosis, Human Ehrlichiosis (2 species), Jamestown Canyon, La Crosse, Lyme Disease, Malaria, Novel Influenza A, Powassan, Rocky Mountain Spotted Fever, Toxoplasmosis, West Nile Virus, Zika Virus

4. Hospitalized influenza cases reported by flu season. For example, 2017 count is from the 2016-17 flu season.

Querying over HTTP

Splitgraph serves as an HTTP API that lets you run SQL queries directly on this data to power Web applications. For example:

curl https://data.splitgraph.com/sql/query/ddn \
    -H "Content-Type: application/json" \
    -d@-<<EOF
{"sql": "
    SELECT *
    FROM \"ramseycounty-us/infectious-disease-summary-data-iw4p-s622\".\"infectious_disease_summary_data\"
    LIMIT 100 
"}
EOF

See the Splitgraph documentation for more information.