Cambridgeshire COVID Info Portal 1¼ years later

Almost 1½ years from the onset of COVID, here a video of the info portal created using ESRI dashboard, inspired from the Johns Hopkins University pioneering hit - same tech with more data and expertise - our own info portal is a handy  bit.ly/CamCOVIDinfo.

East Anglia sea level rise timelines update

Community Engagement  1, ... 12, 13, 14 & 15

[ Update 3: the next installment updates the infrastructure aspects of this for East Anglia

Update 2: Cambridge could be completely underwater by 2100, warns Emoov report

Update 1: added slide deck at bottom, to summarize the last two years of work on this ]

After a hiatus focusing on Coronavirus and story maps on East Anglia and other mapping topics, let's revisit that moving target of sea level rise timing. 

Coronavirus update - Part XII

[ Update: ONS deaths still rise slightly, NHSx cases resurgence continues topping 6.5M ]

Since our previous update, a third national lockdown resulted from the numbers that just keep increasing, as well as a second strain of the virus appearing but not split out in NHSx stats. That is patent in the comparative graphs below, updated as per above:

Digital Nomads and Digital Divide

 Here is the Parliament   f i n a l l y    addressing the challenges posed by the pandemic, with a fairly comprehensive review of the facts they gathered.

Coronavirus update - Part XI

[ Update 1: Still no sign of the second wave abating and deaths on the increase again
  Update 2 : next installment shows how the second wave numbers just keep growing ]

Further to our last blogpost, the second lockdown resulted from / is reflected in both sharp increases in cases passing 1.5M, and marked ones in deaths passing 70,000 and on the increase again. 

Cornavirus update - Part X

[ Update: MSOA data only rolling weekly on NHSx site here or via the PHE API here
Update 2: next installment shows further marked increases in the second lockdown ]

 ... A lot has happened since the last update: not only may we have a second wave as seen in the bottom left-hand panel below, but also NHSx posted new Ward-level data in a format ready-to-use for coxcomb maps.

Coronavirus update - Part IX

[ Update 2: part X expands on the evolving spread of cased and access to ward-level data
Update1: Cases keep growing, not a second wave but a concern nonetheless as reported ]

After changes in NHSx reporting posted previously, we continue with NHSx case and ONS death data for England, and to  update our CamCOVIDinfo:

Coronavirus update - Part VIII

 Last update showed progress in Coronavirus (COVID-19) in the UK especially in higher geographic resolution: Ward down from County but not yet Postcode levels. In this ever-evolving scene however:

• NHSx no longer posts death data in its legacy stream (scroll all the way to the bottom), 
• and cases are no longer posted daily (check "Last updated" date at the very bottom)

Fortunately Office of National Statistics (ONS) death data had already been tapped as in Part III. So our dashboard below CamCOVIDinfo is still on offer... do keep coming back for weekly updates!

Coronavirus update - Part VII

 Since the last update, NHSx has significantly upgraded Coronavirus (COVID-19) in the UK:

• In addition to Cases and Death, Testing and Healthcare are on offer in various subdivisions. 
• On the downside, we still don't have Release / Recovery data, which appeared briefly mid-March under PHE tenure, then no more under NHSx. 
• On the upside we get Middle layer Super Output Area (MSOA) or Ward-level equivalent, a vast improvement over Upper Tier Local Authority (UTLA) or County-level equivalent data. 

Coronavirus update - Part VI

[Update: on 28 July both cases and deaths appear to be flattening at last, stay tuned!

Update: NHSx cases pass the ¼M mark with uptick and without "flattening the curve"  ]

The previous post and its updates showed the progress of NHSx and ONS daily and cumulative numbers of COVID19 cases and deaths, ending with some internal consistencies in NHSx reporting. Those appear to have been remedied now.

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

Coronavirus backgrounder

[Update: more dashboards local to Cambridgeshire shown in next blogpost]

This pandemic affects us all. You might be reading this from home. And while social distancing may become the norm, social isolation needn't be: Use social media, ye olde telephone, reach out! Here are some local resources gleaned from group meetings, the twitterverse and simple curiosity.