5 Filters

For the techies reading: A UK Gov covid data API

Covid
#1

Just in case anyone is interested in grabbing the latest covid data directly from the UK gov. There is a web based data API here:

https://coronavirus.data.gov.uk/developers-guide

To use it in a very basic way, you need to set a simple filter to determine the region (whole UK, Nation, NHS region etc). Then specify which piece of data you want to look at, out of the list at the end of this message. for example, if I want to know how the number of deaths have evolved since the pandemic began, you simply paste this link into your browser:

https://api.coronavirus.data.gov.uk/v1/data?filters=areaType=overview&structure={"date":"date","deaths":"newDeaths28DaysByDeathDate"}

I’ve specified the filter areaType=overview to grab data for the whole UK, and I’m interested in daily deaths, by specifying newDeaths28DaysByDeathDate in the structure field.

To get other bits of info, just replace this bit of the URL "deaths":"newDeaths28DaysByDeathDate"

by whatever you want to see, for example to see cases (newCasesBypublishDate from the list below), you would change it to

https://api.coronavirus.data.gov.uk/v1/data?filters=areaType=overview&structure={"date":"date","newCases":"newCasesByPublishDate"}

This gives back a page of results that you can scroll through. I’m using Firefox, and it handily formats that in a nice easy way for me. Don’t know what other browsers will do. You can also ask for multiple bits of data at once (for example cases and deaths and hospital admissions etc).

Hope some of you find that useful.

Cheers
PP

List of some interesting data fields

  • date: Date as string [ YYYY-MM-DD ]
  • newCasesByPublishDate: New cases by publish date
  • cumCasesByPublishDate: Cumulative cases by publish date
  • cumCasesBySpecimenDateRate: Rate of cumulative cases by publish date per 100k resident population
  • newCasesBySpecimenDate: New cases by specimen date
  • cumCasesBySpecimenDateRate: Rate of cumulative cases by specimen date per 100k resident population
  • cumCasesBySpecimenDate: Cumulative cases by specimen date
  • maleCases: Male cases (by age):
  • femaleCases: Female cases (by age)
  • newAdmissions: New admissions
  • cumAdmissions: Cumulative number of admissions
  • cumAdmissionsByAge: Cumulative admissions by age
  • cumTestsByPublishDate: Cumulative tests by publish date
  • newTestsByPublishDate: New tests by publish date
  • covidOccupiedMVBeds: COVID-19 occupied beds with mechanical ventilators
  • hospitalCases: Hospital cases
  • plannedCapacityByPublishDate: Planned capacity by publish date
  • newDeaths28DaysByPublishDate: Deaths within 28 days of positive test
  • cumDeaths28DaysByPublishDate: Cumulative deaths within 28 days of positive test
  • cumDeaths28DaysByPublishDateRate: Rate of cumulative deaths within 28 days of positive test per 100k resident population
  • newDeaths28DaysByDeathDate: Deaths within 28 days of positive test by death date
  • cumDeaths28DaysByDeathDate: Cumulative deaths within 28 days of positive test by death date
  • cumDeaths28DaysByDeathDateRate: Rate of cumulative deaths within 28 days of positive test by death date per 100k resident population