Start

Open devcontainer in VSCode - Here is a quick start guide
Start influx and Chronograf. Inside the Vscode devcontainer. Open an terminal and run: ./serviceConfig/start.sh
Do the same for the data loader to populate the influxdb with the PHE dataset. Run dataloader cd ./dataloader && dotnet run
Go to the data explorer: "http://localhost:9999/orgs/05d0f71967e52000/data-explorer" username: admin pw: admin
Try out some queries like:

from(bucket: "pheCovidData")
  |> range(start: -120d)
  |> filter(fn: (r) => r._field == "daily100k")
  |> movingAverage(n: 7)

from(bucket: "pheCovidData")
  |> range(start: -120d)
  |> filter(fn: (r) => r._field == "daily100k")
  |> group(columns: ["_field"])
  |> aggregateWindow(every: 1d, fn: mean)
  |> movingAverage(n: 7)
  |> yield(name: "Average Local Authory 7 day moving average per 100k people")

from(bucket: "pheCovidData")
  |> range(start: -120d)
  |> filter(fn: (r) => r._field == "daily" and r.localAuth == "Leeds")

Learn how to write Flux queries here: Getting Started with Flux.

The fields are as follows:

daily100k is number of lab confirmed cases that day per 100k people.
daily is number of lab confirmed cases that day.
total100k is number of lab confirmed cases total per 100k people.
total100k is number of lab confirmed cases total.
localAuth is the local authority name
localAuthCode is the local authority code

Added Hospital Data

This data tracks the number of new admissions to hospital, cases in hospital and mv beds used by cases.

The following data is set on each point.

var point = PointData.Measurement("trustData")
                        .Tag("localAuth", record.ltlaName) // Lower Tier Local Authority like "Reading"
                        .Tag("trust", record.areaName) // Trust organisation like "Royal Berkshire trust"
                        .Field("newAdmissions", record.newAdmissions ?? 0)
                        .Field("cases", record.hospitalCases ?? 0) // Cases in the hospital
                        .Field("mvBeds", record.covidOccupiedMVBeds ?? 0)
                        .Timestamp(record.date.ToUniversalTime(), WritePrecision.S);

Now you can query both the admissions and case data for a local authority

from(bucket: "pheCovidData")
  |> range(start: -100d)
  |> filter(fn: (r) => 
    r.localAuth == "Reading" and 
    (r._field == "daily" or r._field == "newAdmissions")
  )
  |> movingAverage(n: 7)

Quoting or using these figures

This is an experimental project, figures to be quoted or used should be independantly validated. This can be done using Excel and the PHE Dataset CSV file available here: https://coronavirus.data.gov.uk/

Notes:

This is intended for local development/experimentation, no thought has gone to configuring the InfluxDB instance for public hosting.
Currently the influxdb config boltdb is committed to allow easy startup, in future I'd like to do this better.
The auth token for communicating with influxdb is hard coded in the C# Dataloader. This should be configured via environment variables.

Contributions

I'd welcome input and contributions although this is a personal hack so my response may be slow.

Next steps

I'd like to: