UK Daily COVID Data - Countries And Regions

Dataset description

Daily official UK Covid data. The data is available per country (England, Scotland, Wales and Northern Ireland) and for different regions in England. The different regions are split into two different files as part of the data is directly gathered by the NHS (National Health Service). The files that contain the word 'nhsregion' in their name, include data related to hospitals only, such as number of admissions or number of people in respirators. The files containing the word 'region' in their name, include the rest of the data, such as number of cases, number of vaccinated people or number of tests performed per day. The next paragraphs describe the columns for the different file types.

Region files

Files related to regions (word 'region' included in the file name) have the following columns:

• "date": date in YYYY-MM-DD format
• "area type": type of area covered in the file (region or nation)
• "area name": name of area covered in the file (region or nation name)
• "daily cases": new cases on a given date
• "cum cases": cumulative cases
• "new deaths 28days": new deaths within 28 days of a positive test
• "cum deaths 28days": cumulative deaths within 28 days of a positive test
• "new deaths_60days": new deaths within 60 days of a positive test
• "cum deaths 60days": cumulative deaths within 60 days of a positive test
• "new_first_episode": new first episodes by date
• "cum_first_episode": cumulative first episodes by date
• "new_reinfections": new reinfections by specimen data
• "cum_reinfections": cumualtive reinfections by specimen data
• "new_virus_test": new virus tests by date
• "cum_virus_test": cumulative virus tests by date
• "new_pcr_test": new PCR tests by date
• "cum_pcr_test": cumulative PCR tests by date
• "new_lfd_test": new LFD tests by date
• "cum_lfd_test": cumulative LFD tests by date
• "test_roll_pos_pct": percentage of unique case positivity by date rolling sum
• "test_roll_people": unique people tested by date rolling sum
• "new first dose": new people vaccinated with a first dose
• "cum first dose": cumulative people vaccinated with a first dose
• "new second dose": new people vaccinated with a first dose
• "cum second dose": cumulative people vaccinated with a first dose
• "new third dose": new people vaccinated with a booster or third dose
• "cum third dose": cumulative people vaccinated with a booster or third dose

Country files

Files related to countries (England, Northern Ireland, Scotland and Wales) have the above columns and also:

• "new admissions": new admissions,
• "cum admissions": cumulative admissions,
• "hospital cases": patients in hospitals,
• "ventilator beds": COVID occupied mechanical ventilator beds
• "trans_rate_min": minimum transmission rate (R)
• "trans_rate_max": maximum transmission rate (R)
• "trans_growth_min": transmission rate growth min
• "trans_growth_max": transmission rate growth max

NHS Region files

Files related to nhsregion (word 'nhsregion' included in the file name) have the following columns:

• "new admissions": new admissions,
• "cum admissions": cumulative admissions,
• "hospital cases": patients in hospitals,
• "ventilator beds": COVID occupied mechanical ventilator beds
• "trans_rate_min": minimum transmission rate (R)
• "trans_rate_max": maximum transmission rate (R)
• "trans_growth_min": transmission rate growth min
• "trans_growth_max": transmission rate growth max

It's worth noting that the dataset hasn't been cleaned and it needs cleaning. Also, different files have different null columns. This isn't an error in the dataset but the way different countries and regions report the data.