Wrong statesFixed
18 metro areas spanning two or more states were filed under the last state in their name e.g. "Tallahassee FL-Thomasville GA" under Georgia so Washington DC, Rhode Island and Vermont were missing.
Google Trends lets us see what people search for at a very local level. This project tracks searches for nine common health issues from cancer to diabetes in every US metro area from 2004 to 2017, and compares them with the CDC's leading causes of death to understand how search data reflects life for millions of Americans.
Interactive map
Pick a health topic and a year. Darker states search more for it; each dot is one metro area (a city and its surrounding region) at its real location bigger dot, more interest. Scores run from 0 to 100 (see how to read them).
Results
Each finding in plain words first, with the statistics behind it underneath. Everything is calculated live in your browser from the search data and CDC surveys.
State profile
Average interest in each condition for one state's metro areas, against the average of all metro areas. Tip: click a state on the map.
Go deeper
Search interest validated against CDC disease prevalence, the north–south structure of health searching, co-occurring conditions, stability over time and mortality trends.
Profile any of the 210 metro areas: percentile ranks, change over time and the metros that search most alike.
Filter, sort and export all 2,940 metro × year records and the CDC table.
Twelve JSON endpoints the original Flask API, now always available as static files.
Data quality
An audit of the original database found errors that affected the map and charts. All fixes are scripted in tools/clean_data.py.
18 metro areas spanning two or more states were filed under the last state in their name e.g. "Tallahassee FL-Thomasville GA" under Georgia so Washington DC, Rhode Island and Vermont were missing.
23 metros sat outside their own state after geocoding by bare city name: Victoria TX was placed in Australia, Lima OH in Peru, Albany GA in New York. All 210 now sit inside their state on the map.
The 2017 cancer death rate read 52.5 instead of the CDC's 152.5 per 100,000 which showed cancer deaths falling by two-thirds in one year.
Summing scores across conditions and years made the first version conclude "cancer is most searched" and "+120% growth". Google scales each separately, so these are revised on the Analytics page.
How it was done
Research question: How have the most searched diseases changed over the years in the US and how does that compare with the real-life leading causes of death?
Google Trends health searches by US metro area, 2004–2017 (Kaggle / Google News Lab) and CDC leading causes of death (CDC FastStats).
Reshaped and cleaned in Python/Jupyter (Health_Analysis.ipynb); geocoded each metro area.
Loaded into PostgreSQL (loadData.ipynb) and served through a Flask REST API now pre-built as static JSON so it's always available.
Interactive maps and charts; every statistic on this site is recomputed in your browser from the data.
Team Eagle
Built as a group project in the University of Toronto Data Analytics & Visualization program.

Data scientist & researcher · project lead

Economics & analytics

Data journalism & storytelling

Chartered accountant & data analyst

Project manager & data analyst
Online
Answers come from this project's data and a data-science knowledge base.