Coronavirus update - Part V

Update 4: another week another uptick, more on health data trials&tribulations next
Update 3: the uptick smoothed... but "flatten the curve" certainly hasn't happened yet!
Update 2: and right on cue: UK coronavirus cases no longer falling, ONS figures show
Update 1: an uptick in ONS deaths reported a week behind matches last week's uptick in NHSx cases... flattening the curve? Not!  ]

Previously we reported on extending COVID-19 datasets down to Ward (MSOA) from County (UTLA) level. To recap, NHSx post cases and deaths from hospitals in a single dashboard, whereas ONS post death data across many systems with geo-socio-economics. And while we report on the highest geographic granularity publicly available, at the country level weekly reports are the common denominator across agencies. ONS posts data weekly 2-4 weeks behind depending on scale as discussed before, whereas NHSx posts daily 1-2 days behind also discussed before. Having calculated weekly data from NHSx to match ONS time stamps. they're graphed here (click images to enlarge).

Coronavirus update - Part IV

[Update: see next a wrap-up of COVID-19 cases & deaths data across NHSx & ONS]

The last update added ONS' COVID-related death data, which augment the cases and deaths posted by NHSx at the Local Authority level akin to Counties. The post ended with: Data will be added as found and/or made available: the goal is Parish-level data to mash up with our climate change maps. We already added in the second last update a map from Cambridgeshire Live, and we now see in Cambridgeshire Independent ONS "death data by ward and by villages".

Coronavirus daily update - Part III

[ Update: see further updates at higher granularity geography in a later post
Also ONS numbers updated weekly maintain the difference with NHSx below]

Following on Part II adding local data for East of England, let's add weekly deaths (two weeks out of date) from ONS here and here, including counts outside of daily hospital deaths (two days out of date) from NHSx. Here is a graph of the raw data collected from both sources, since end-January onset of the pandemic in the UK.

Coronavirus daily update - Part II

[ Update: see a follow-up post on how ONS data augment the NHSx death statistics ]

Daily updates brought you COVID-19 data for England in a dashboard that posted according to your desktop or mobile device (tablet coming soon). These statistics from NHSx show, however, only hospital data. It's been noted in the press that cases and especially deaths outside hospitals are not captured. ONS captures death data but not in a single dashboard like NHSx and two weeks behind.

Coronavirus time-enabled maps

[Update: thrilled to present at How to do Map Stuff: a Live Community Sharing Event
Update: The Times' Sam Joiner just cleared  England COVID map for London crowding using ridge map animation] 

Local dashboards updated daily from Public Heath England data are bolstered by other open data: As coronavirus affects most notably the eldest and youngest, Office for National Statistics age distribution is a welcome addition to case distribution maps. A static web map showed cases and age distribution side-by-side - a story map has the full back story on its derivation - Kenneth Field's "coxcombs"  post static time-series that helped identify here vulnerable groups of elder and younger populations, and to overlay them atop progressive case numbers over a set time period.

Coronavirus daily update

Issues with the mnemonic link below? Try one of these! Mobile, tablet or desktop
Final update: single URL for desktop, tablet and mobile: bit.ly/CamCOVIDinfo
15 Apr. 2020: NHSX provides now COVID-19 daily updates from their new site
Update 5: further maps adding date of  confirmation and provenance in next post
Update 4: tweak two dashboards to work better on desktop and on mobile (see final)
Update 3: added population by age group for comparison, see bottom of right panel
Update 2: streamlined with one map incorporating all data + complete instructions
Update 1: mobile version added, added Persons Recovered (removed by PHE later)
Correction: user feedback showed importance of symbology to convey information