# Data, graphs, etc

**URL:** <https://community.goactuary.com/t/data-graphs-etc/197>\
**Category:** Covid19\
**Created:** [September 18, 2020, 1:25pm UTC](https://community.goactuary.com/t/data-graphs-etc/197 "2020-09-18T13:25:07Z")\
**Posts on this page:** 20\
**Page:** 1

<div class="post-metadata">

**Author:** ![Lucy](https://community.goactuary.com/user_avatar/community.goactuary.com/lucy/32/8802_2.png) [@Lucy](https://community.goactuary.com/u/Lucy)\
**Post date:** [September 18, 2020, 1:25pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/1 "2020-09-18T13:25:07Z")

</div>

I’ll try to scrape some stuff to put here.

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [September 18, 2020, 1:26pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/2 "2020-09-18T13:26:30Z")

</div>

Financial Times has great stuff:  
[https://www.ft.com/content/a2901ce8-5eb7-4633-b89c-cbdf5b386938](https://www.ft.com/content/a2901ce8-5eb7-4633-b89c-cbdf5b386938)

---

<div class="post-metadata">

**Author:** ![Lucy](https://community.goactuary.com/user_avatar/community.goactuary.com/lucy/32/8802_2.png) [@Lucy](https://community.goactuary.com/u/Lucy)\
**Post date:** [September 18, 2020, 1:58pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/3 "2020-09-18T13:58:50Z")

</div>

So does The Economist

[https://www.economist.com/graphic-detail/2020/07/15/tracking-covid-19-excess-deaths-across-countries?utm\_campaign=coronavirus-special-edition&utm\_medium=newsletter&utm\_source=salesforce-marketing-cloud](https://www.economist.com/graphic-detail/2020/07/15/tracking-covid-19-excess-deaths-across-countries?utm_campaign=coronavirus-special-edition&utm_medium=newsletter&utm_source=salesforce-marketing-cloud)

---

<div class="post-metadata">

**Author:** ![Lucy](https://community.goactuary.com/user_avatar/community.goactuary.com/lucy/32/8802_2.png) [@Lucy](https://community.goactuary.com/u/Lucy)\
**Post date:** [September 18, 2020, 1:59pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/4 "2020-09-18T13:59:23Z")

</div>

RT-live has interesting stuff

[https://rt.live/](https://rt.live/)

---

<div class="post-metadata">

**Author:** ![Lucy](https://community.goactuary.com/user_avatar/community.goactuary.com/lucy/32/8802_2.png) [@Lucy](https://community.goactuary.com/u/Lucy)\
**Post date:** [September 18, 2020, 2:00pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/5 "2020-09-18T14:00:37Z")

</div>

I like 91-divoc for visualiztions:

[http://91-divoc.com/pages/covid-visualization/](http://91-divoc.com/pages/covid-visualization/)

---

<div class="post-metadata">

**Author:** ![SpaceLobster](https://community.goactuary.com/user_avatar/community.goactuary.com/spacelobster/32/38216_2.png) [@SpaceLobster](https://community.goactuary.com/u/SpaceLobster)\
**Post date:** [September 18, 2020, 8:12pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/6 "2020-09-18T20:12:25Z")

</div>

provinces vs states graph over time:  
[https://www.ctvnews.ca/health/coronavirus/covid-19-in-the-u-s-how-do-canada-s-provinces-rank-against-american-states-1.5051033](https://www.ctvnews.ca/health/coronavirus/covid-19-in-the-u-s-how-do-canada-s-provinces-rank-against-american-states-1.5051033)

Pretty cool visual representation.

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [October 16, 2020, 2:28pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/7 "2020-10-16T14:28:06Z")

</div>

Trying something out:  
[https://public.tableau.com/profile/mary.pat.campbell7228#!/vizhome/COVID\_excess\_mortality\_through20201010\_MPC/WithAndWithoutCOVID](https://public.tableau.com/profile/mary.pat.campbell7228#!/vizhome/COVID_excess_mortality_through20201010_MPC/WithAndWithoutCOVID)

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [October 16, 2020, 2:29pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/8 "2020-10-16T14:29:34Z")

</div>

harrumph

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [January 3, 2021, 2:22pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/9 "2021-01-03T14:22:04Z")

</div>

Data issues

[https://triblive.com/news/pennsylvania/errors-in-covid-data-reveal-unreliable-tracking-system-for-nursing-homes/](https://triblive.com/news/pennsylvania/errors-in-covid-data-reveal-unreliable-tracking-system-for-nursing-homes/)

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [January 3, 2021, 7:38pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/10 "2021-01-03T19:38:21Z")

</div>

Interesting method to estimate COVID deaths in Khartoum, Sudan when there is poor official data collection:  
[https://www.imperial.ac.uk/mrc-global-infectious-disease-analysis/covid-19/report-39-sudan/](https://www.imperial.ac.uk/mrc-global-infectious-disease-analysis/covid-19/report-39-sudan/)

> ## Summary
> 
> - A mitigated COVID-19 epidemic (slowing but not stopping epidemic spread) occurred in Khartoum between April and September 2020.
> - In order to predict the trajectory of the emerging second wave, we estimate the level of mortality detected during the first wave and subsequently infer levels of immunity.
> - Between April and September 2020, we estimate that 2% (sensitivity range 2% - 5%) of deaths due to COVID-19 were reported in official reported mortality numbers.
> - We estimate there were 16,090 (95% CI: 14,300 - 17,990) undetected COVID-19 deaths up to 20 November.
> - We estimate high levels of immunity after the end of the first wave of COVID-19 in Khartoum with 38.0% (95% CI: 35.0% - 41.1%) infected by 20 November 2020.
> - Reductions in COVID-19 incidence during the first wave were due to both the implemented interventions and increasing immunity in the population.
> - Interventions lead to a reduction in R from 3.5 to 1 by 20 April.
> - The effective reproduction number continued to fall after 20 April, falling to 0.8 at the beginning of July due to increasing immunity.
> - The ending of stringent suppression measures in July resulted in transmission increasing, with continued increases in mobility resulting in R rising above 1 during September.
> - In the absence of further increases in transmission, we predict that the second wave will peak before the beginning of 2021.
> - We project the second wave to be similar in size to the first wave sustained in the summer if transmission is maintained at current levels.
> - If instead mortality under-ascertainment is at the upper end of our range (5%), then we estimate a smaller first wave. This means that fewer people will be immune and hence we would project a larger second wave.
> - In the absence of implementing new suppressive measures, continued shielding of high-risk individuals is important to help reduce mortality during the second wave.
> - Historic mortality investigations are needed to help confirm the level of mortality missed and to inform the trajectory of the second wave and how long shielding should be maintained.

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [January 8, 2021, 6:17pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/11 "2021-01-08T18:17:49Z")

</div>

[https://jamanetwork.com/journals/jamanetworkopen/fullarticle/2774707](https://jamanetwork.com/journals/jamanetworkopen/fullarticle/2774707)

> Key Points
> 
> **Question** What proportion of coronavirus disease 2019 (COVID-19) spread is associated with transmission of severe acute respiratory syndrome coronavirus 2 (SARS-CoV-2) from persons with no symptoms?
> 
> **Findings** In this decision analytical model assessing multiple scenarios for the infectious period and the proportion of transmission from individuals who never have COVID-19 symptoms, transmission from asymptomatic individuals was estimated to account for more than half of all transmission.
> 
> **Meaning** The findings of this study suggest that the identification and isolation of persons with symptomatic COVID-19 alone will not control the ongoing spread of SARS-CoV-2.

---

<div class="post-metadata">

**Author:** ![dr\_t\_non-fan](https://community.goactuary.com/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dr\_t\_non-fan](https://community.goactuary.com/u/dr_t_non-fan)\
**Post date:** [January 8, 2021, 6:51pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/12 "2021-01-08T18:51:46Z")

</div>

> [@meep](#):
>
> transmission from asymptomatic individuals was estimated to account for more than half of all transmission.

Wholly Shit!

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [February 4, 2021, 12:52pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/13 "2021-02-04T12:52:38Z")

</div>

[https://www.economist.com/graphic-detail/2021/02/03/israels-vaccine-programme-gives-hope-to-the-world?utm\_campaign=the-economist-today&utm\_medium=newsletter&utm\_source=salesforce-marketing-cloud&utm\_term=2021-02-03&utm\_content=article-link-4&etear=nl\_today\_4](https://www.economist.com/graphic-detail/2021/02/03/israels-vaccine-programme-gives-hope-to-the-world?utm_campaign=the-economist-today&utm_medium=newsletter&utm_source=salesforce-marketing-cloud&utm_term=2021-02-03&utm_content=article-link-4&etear=nl_today_4)

 ![image](https://community.goactuary.com/uploads/default/original/2X/0/01225946081801a4f42f0021b354cd26303ebd09.jpeg)

---

<div class="post-metadata">

**Author:** ![dr\_t\_non-fan](https://community.goactuary.com/letter_avatar_proxy/v4/letter/d/a8b319/32.png) [@dr\_t\_non-fan](https://community.goactuary.com/u/dr_t_non-fan)\
**Post date:** [February 4, 2021, 5:32pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/14 "2021-02-04T17:32:13Z")

</div>

I think we might need a few more months on those graphs.  
Any other pro-active edicts (enforcing “must wear mask” “lockdowns,” etc.) going on in Israel to make the drop after the peak?

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [February 9, 2021, 6:22pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/15 "2021-02-09T18:22:02Z")

</div>

More on Israel:  
[https://www.ft.com/content/0cdc8563-1e6d-4089-bedb-b0f675c0d683](https://www.ft.com/content/0cdc8563-1e6d-4089-bedb-b0f675c0d683)

 ![image](https://community.goactuary.com/uploads/default/original/2X/a/a9f856eb932d23fabb48831a79e2d21dacb005c3.jpeg)  
 ![image](https://community.goactuary.com/uploads/default/original/2X/8/86170d5482468890e4959fdf6a6ff28f8e816de6.jpeg)

Hmmm, trying:

> **[Israel provides first signs of mass vaccination driving down virus cases –...](https://www.actuarial.news/2021/02/09/israel-provides-first-signs-of-mass-vaccination-driving-down-virus-cases/)**

---

<div class="post-metadata">

**Author:** ![greenman](https://community.goactuary.com/user_avatar/community.goactuary.com/greenman/32/1904_2.png) [@greenman](https://community.goactuary.com/u/greenman)\
**Post date:** [February 12, 2021, 3:55pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/16 "2021-02-12T15:55:40Z")

</div>

I see that the Covid Tracking Project is shutting down 3/7

[The COVID Tracking Project | The COVID Tracking Project](https://covidtracking.com/)

I have been using that site for work as well as my own personal “enjoyment” tracking Covid and creating graphs for my state and others that interest me.

Does anyone have a good replacement site that lists test, cases, hospitalizations by day by state?

---

<div class="post-metadata">

**Author:** ![SteveGrondin](https://community.goactuary.com/user_avatar/community.goactuary.com/stevegrondin/32/3257_2.png) [@SteveGrondin](https://community.goactuary.com/u/SteveGrondin)\
**Post date:** [February 21, 2021, 1:07pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/17 "2021-02-21T13:07:28Z")

</div>

WTH Iowa? 27K cases on Friday vs daily numbers running less than 1K for a while? I can’t find any explanation for this data bomb. Anyone closer got any insight? The daily totals on the IA DPH don’t add to the total cases reported.

---

<div class="post-metadata">

**Author:** ![dothemath](https://community.goactuary.com/user_avatar/community.goactuary.com/dothemath/32/651_2.png) [@dothemath](https://community.goactuary.com/u/dothemath)\
**Post date:** [February 21, 2021, 2:23pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/18 "2021-02-21T14:23:55Z")

</div>

On thing to keep in mind, daily cases are generally on a “paid” basis, not an “incurred” basis. So there just could have been a reporting backlog. Was Iowa affected by the winter weather? Or it could just be garden variety government incompetency.

---

<div class="post-metadata">

**Author:** ![SteveGrondin](https://community.goactuary.com/user_avatar/community.goactuary.com/stevegrondin/32/3257_2.png) [@SteveGrondin](https://community.goactuary.com/u/SteveGrondin)\
**Post date:** [February 22, 2021, 1:48pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/19 "2021-02-22T13:48:59Z")

</div>

What I am saying is the sum of the daily claims “paid” doesn’t equal the total claims “paid”. Someone is pocketing the $ 😉 (except in this case the sum daily is much higher than total).

Reporting lags happen, but when they have been substantial in my state the DPH has noted receiving a backlog.

I think they made changes to their website (they noted adjusting positivity rate comps to match CDC this past week), but broke something. I didn’t visit IA’s site before, so I am not sure.

---

<div class="post-metadata">

**Author:** ![meep](https://community.goactuary.com/user_avatar/community.goactuary.com/meep/32/44_2.png) [@meep](https://community.goactuary.com/u/meep)\
**Post date:** [February 25, 2021, 12:41pm UTC](https://community.goactuary.com/t/data-graphs-etc/197/20 "2021-02-25T12:41:47Z")

</div>

[https://www.economist.com/graphic-detail/2021/02/22/evidence-from-britain-shows-covid-19-vaccines-are-very-effective](https://www.economist.com/graphic-detail/2021/02/22/evidence-from-britain-shows-covid-19-vaccines-are-very-effective)

 ![image](https://community.goactuary.com/uploads/default/original/2X/d/d36c4ef5e1660512b9827c89b5c7bd53b69435fe.jpeg)

[Next page](https://community.goactuary.com/t/data-graphs-etc/197.md?page=2)
