Skip to content

Latest commit

 

History

History
82 lines (52 loc) · 4.68 KB

combining-datasets.md

File metadata and controls

82 lines (52 loc) · 4.68 KB

Examples of Combining Datasets in Visualizations

These are a couple nice examples of combining datasets in visualizations.

US COVID Case Rates and US County Demographics

I saw this visualization through a tweet by @agsciencewriter (account no longer exists). It was based on data from the CDC when they were reporting COVID data regularly.

Data combinations:

Missouri Mask Mandates and COVID Case Rates

This visualization comes from an article in the Missouri Independent news, "Missouri health department found mask mandates work, but didn’t make findings public" (larger version w/tooltips)

It splits out the case rates in St. Louis, St. Louis County, Kansas City and Jackson County (all with mask mandates) from the rest of the state. They found that "jurisdictions with mask mandates averaged 15.8 cases per day for every 100,000 residents, compared to 21.7 in unmasked communities."

Data combinations:

  • COVID case data by county
  • Set of counties that had mask mandates
  • Dates of significant events around Delta, case surges, and mask mandates

California Spending on Universities and Dept of Corrections

"This shocking graph is from a new @SREJournal article by Hamilton, Nielsen, and Larma. Over the past 50 years, California state budget priorities for university and incarceration have dramatically reversed. As HE funding declines, minority students suffer."
Source: https://twitter.com/nathanihoff/status/1465454549385105410

Data combinations:

  • Amount of state funding for University of California and California State University systems
  • Amount of state funding for corrections (jails and prisons)

Note that the raw amounts aren't used, but rather the share of the state budget those amounts represent. This allows the lines to be drawn on the same chart with the same scale.

Louisiana COVID Cases, Deaths, Vaccinations

This visualization comes from an article in The Times-Picayune | The New Orleans Advocate, "Louisiana COVID numbers: Data on cases, deaths, hospitalizations, vaccines" (archived version, Sep 2021)

Data combinations:

  • COVID cases, 7-day average
  • COVID hospitalizations
  • COVID deaths
  • COVID vaccination percentages
  • key dates related to mask mandates, Delta variant, and vaccine availability

US Poverty Rate, IRS Auditing Rate, and 2016 Political Affiliation

This visualization comes from "Geographic Distribution of IRS Auditing Rates" in PolicyViz.com.

Data combinations:

Florida vs. US Covid Deaths in 2021

This has two charts as examples and comes from a New York Times article, "The Steep Cost of Ron DeSantis' Vaccine Turnabout", July 2023. These are good examples of adding context to charts to aid in understanding.

Data combinations:

  • COVID death rates in Florida
  • COVID death rates in US, average
  • context of when vaccines were eligible and when the Delta wave began

Data combinations:

  • Vaccination rates in Florida, split by "under 65" and "65 and older"
  • Vaccination rates in US, split by "under 65" and "65 and older"

In particular, this chart adds context to help the viewer understand what's being shown in the chart, explaining specific data points. This also shows how data from a single dataset can be split based on a categorical grouping to highlight differences between groups.