# Apologies if Redundant; Graph of Raw Case Rates per State by Calendar Date

**URL:** <https://boards.straightdope.com/t/apologies-if-redundant-graph-of-raw-case-rates-per-state-by-calendar-date/914915>\
**Category:** The Quarantine Zone\
**Tags:** covid-quarantine\
**Created:** [July 10, 2020, 5:33am UTC](https://boards.straightdope.com/t/apologies-if-redundant-graph-of-raw-case-rates-per-state-by-calendar-date/914915 "2020-07-10T05:33:19Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![AHunter3](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/ahunter3/32/368_2.png) [@AHunter3](https://boards.straightdope.com/u/AHunter3)\
**Post date:** [July 10, 2020, 5:33am UTC](https://boards.straightdope.com/t/apologies-if-redundant-graph-of-raw-case-rates-per-state-by-calendar-date/914915/1 "2020-07-10T05:33:19Z")

</div>

I keep looking for the same kind of graph every day and only sometimes find one, and when I do it’s not one of the URLs that refreshes their data daily so it’s not useful to go back to.

I want one that shows all the US states with their own curve, the X axis NOT “since first 100 cases” or whatever but actual calendar date, the Y axis NOT “per 100K population” or whatever but actual raw numbers of infected individuals. It would be nice if it would break out each state separately, reconfiguring the Y axis proportionally so that you can see the shape of each state’s outbreak, but that’s a bonus feature.

Come to think of it, an international version of the same would be nice.

---

<div class="post-metadata">

**Author:** ![biqu](https://avatars.discourse-cdn.com/v4/letter/b/7feea3/32.png) [@biqu](https://boards.straightdope.com/u/biqu)\
**Post date:** [July 10, 2020, 11:04am UTC](https://boards.straightdope.com/t/apologies-if-redundant-graph-of-raw-case-rates-per-state-by-calendar-date/914915/2 "2020-07-10T11:04:24Z")

</div>

[https://data.covid.umd.edu](https://data.covid.umd.edu) almost has what you’re looking for, except the curve for each state appears as a separate row in the table. You have to select a date range, and the default table presentation has all rows collapsed. Expanding a row will give the time series for that state.

---

<div class="post-metadata">

**Author:** ![Trom](https://avatars.discourse-cdn.com/v4/letter/t/958977/32.png) [@Trom](https://boards.straightdope.com/u/Trom)\
**Post date:** [July 10, 2020, 12:56pm UTC](https://boards.straightdope.com/t/apologies-if-redundant-graph-of-raw-case-rates-per-state-by-calendar-date/914915/3 "2020-07-10T12:56:39Z")

</div>

> **[Coronavirus Bell Curve | Daily COVID-19 Statistics for the United States](https://coronavirusbellcurve.com/)**
>
> Coronavirus Bell Curve was created to visualize the day-by-day progression of the Coronavirus in the United States.

---

<div class="post-metadata">

**Author:** ![DMC](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/dmc/32/18049_2.png) [@DMC](https://boards.straightdope.com/u/DMC)\
**Post date:** [July 10, 2020, 5:45pm UTC](https://boards.straightdope.com/t/apologies-if-redundant-graph-of-raw-case-rates-per-state-by-calendar-date/914915/4 "2020-07-10T17:45:00Z")

</div>

If cumulative numbers are okay, then [this](https://public.tableau.com/profile/dmc7541#!/vizhome/USCOVID-19Viz/CumulativeByStateByDate) should work for you. It includes cases and deaths as selectable options and has multi-select functionality for state selection. It also adjusts the y-axis based on which states are selected as they all get pretty flatted by a few states, such as New York and California, by default.

I don’t plan on updating this frequently, if ever, but if you see something you’d like for me to tweak, or if I misunderstood your request, let me know.

---

<div class="post-metadata">

**Author:** ![AHunter3](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/ahunter3/32/368_2.png) [@AHunter3](https://boards.straightdope.com/u/AHunter3)\
**Post date:** [July 10, 2020, 5:46pm UTC](https://boards.straightdope.com/t/apologies-if-redundant-graph-of-raw-case-rates-per-state-by-calendar-date/914915/5 "2020-07-10T17:46:26Z")

</div>

I like that Coronavirus Bell Curve site, thanks! The one thing I’m still wishing for is a superimposed bell curve graph, all the states with real dates on Y axis, raw cases on the X. It’s useful to have each state separately (I specifically wanted that as well) but it makes it difficult to visualize the complete picture.

ETA: DMC, yes!! OK between that public tableau site and the Coronavirus bell curve site I’ve got what I wanted!

---

<div class="post-metadata">

**Author:** ![DMC](https://sea3.discourse-cdn.com/straightdope/user_avatar/boards.straightdope.com/dmc/32/18049_2.png) [@DMC](https://boards.straightdope.com/u/DMC)\
**Post date:** [July 10, 2020, 6:03pm UTC](https://boards.straightdope.com/t/apologies-if-redundant-graph-of-raw-case-rates-per-state-by-calendar-date/914915/6 "2020-07-10T18:03:03Z")

</div>

I did some final tweaking, but I need to stop as I’m getting OCD now. 🙂

The tooltip is now larger and shows both cases and deaths no matter which one you have selected, so you don’t have to jump back and forth. It also now shows CFR (Case Fatality Rate), but be aware that that is considered a horrible measure, as it depends on accurate case counts, and we really just don’t know how many people truly have had the virus.

Source of the data is the [NY Times github repository](https://github.com/nytimes/covid-19-data), which had data up through yesterday, 07/09/2020.
