Name: UK Daily COVID Data - Countries And Regions
Creator: Kaggle
License: https://creativecommons.org/licenses/by/4.0/

About this Dataset

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.

Tables

England Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_covid

230.24 KB
1441 rows
35 columns


CREATE TABLE england_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" DOUBLE,
  "cum_deaths_60days" DOUBLE,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" DOUBLE,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" DOUBLE,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" DOUBLE,
  "test_roll_people" DOUBLE,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE,
  "new_admissions" DOUBLE,
  "cum_admissions" DOUBLE,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);

England Nhsregion East Of England Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_nhsregion_east_of_england_covid

24.71 KB
1360 rows
8 columns


CREATE TABLE england_nhsregion_east_of_england_covid (
  "new_admissions" BIGINT,
  "cum_admissions" BIGINT,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);

England Nhsregion London Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_nhsregion_london_covid

26.44 KB
1360 rows
8 columns


CREATE TABLE england_nhsregion_london_covid (
  "new_admissions" BIGINT,
  "cum_admissions" BIGINT,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);

England Nhsregion Midlands Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_nhsregion_midlands_covid

27.07 KB
1360 rows
8 columns


CREATE TABLE england_nhsregion_midlands_covid (
  "new_admissions" BIGINT,
  "cum_admissions" BIGINT,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);

England Nhsregion North East And Yorkshire Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_nhsregion_north_east_and_yorkshire_covid

26.32 KB
1360 rows
8 columns


CREATE TABLE england_nhsregion_north_east_and_yorkshire_covid (
  "new_admissions" BIGINT,
  "cum_admissions" BIGINT,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);

England Nhsregion North West Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_nhsregion_north_west_covid

26.07 KB
1360 rows
8 columns


CREATE TABLE england_nhsregion_north_west_covid (
  "new_admissions" BIGINT,
  "cum_admissions" BIGINT,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);

England Nhsregion South East Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_nhsregion_south_east_covid

25.52 KB
1360 rows
8 columns


CREATE TABLE england_nhsregion_south_east_covid (
  "new_admissions" BIGINT,
  "cum_admissions" BIGINT,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);

England Nhsregion South West Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_nhsregion_south_west_covid

23.68 KB
1360 rows
8 columns


CREATE TABLE england_nhsregion_south_west_covid (
  "new_admissions" BIGINT,
  "cum_admissions" BIGINT,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);

England Region East Midlands Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_region_east_midlands_covid

173.49 KB
1441 rows
27 columns


CREATE TABLE england_region_east_midlands_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" DOUBLE,
  "cum_deaths_60days" DOUBLE,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" DOUBLE,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" DOUBLE,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" DOUBLE,
  "test_roll_people" DOUBLE,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE
);

England Region East Of England Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_region_east_of_england_covid

176.26 KB
1441 rows
27 columns


CREATE TABLE england_region_east_of_england_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" DOUBLE,
  "cum_deaths_60days" DOUBLE,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" DOUBLE,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" DOUBLE,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" DOUBLE,
  "test_roll_people" DOUBLE,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE
);

England Region London Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_region_london_covid

179.75 KB
1441 rows
27 columns


CREATE TABLE england_region_london_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" DOUBLE,
  "cum_deaths_60days" DOUBLE,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" DOUBLE,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" DOUBLE,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" DOUBLE,
  "test_roll_people" DOUBLE,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE
);

England Region North East Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_region_north_east_covid

166.18 KB
1440 rows
27 columns


CREATE TABLE england_region_north_east_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" DOUBLE,
  "cum_deaths_60days" DOUBLE,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" DOUBLE,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" DOUBLE,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" DOUBLE,
  "test_roll_people" DOUBLE,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE
);

England Region North West Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_region_north_west_covid

179.92 KB
1441 rows
27 columns


CREATE TABLE england_region_north_west_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" DOUBLE,
  "cum_deaths_60days" DOUBLE,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" DOUBLE,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" DOUBLE,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" DOUBLE,
  "test_roll_people" DOUBLE,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE
);

England Region South East Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_region_south_east_covid

180.87 KB
1441 rows
27 columns


CREATE TABLE england_region_south_east_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" DOUBLE,
  "cum_deaths_60days" DOUBLE,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" DOUBLE,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" DOUBLE,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" DOUBLE,
  "test_roll_people" DOUBLE,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE
);

England Region South West Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_region_south_west_covid

173.96 KB
1441 rows
27 columns


CREATE TABLE england_region_south_west_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" DOUBLE,
  "cum_deaths_60days" DOUBLE,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" DOUBLE,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" DOUBLE,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" DOUBLE,
  "test_roll_people" DOUBLE,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE
);

England Region West Midlands Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_region_west_midlands_covid

176.15 KB
1441 rows
27 columns


CREATE TABLE england_region_west_midlands_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" DOUBLE,
  "cum_deaths_60days" DOUBLE,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" DOUBLE,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" DOUBLE,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" DOUBLE,
  "test_roll_people" DOUBLE,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE
);

England Region Yorkshire And The Humber Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.england_region_yorkshire_and_the_humber_covid

175.4 KB
1441 rows
27 columns


CREATE TABLE england_region_yorkshire_and_the_humber_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" DOUBLE,
  "cum_deaths_60days" DOUBLE,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" DOUBLE,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" DOUBLE,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" DOUBLE,
  "test_roll_people" DOUBLE,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE
);

Northern Ireland Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.northern_ireland_covid

89.29 KB
1385 rows
35 columns


CREATE TABLE northern_ireland_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" VARCHAR,
  "cum_deaths_60days" VARCHAR,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" VARCHAR,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" VARCHAR,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" VARCHAR,
  "test_roll_people" VARCHAR,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" VARCHAR,
  "cum_third_dose" VARCHAR,
  "new_admissions" DOUBLE,
  "cum_admissions" DOUBLE,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);

Scotland Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.scotland_covid

111.19 KB
1313 rows
35 columns


CREATE TABLE scotland_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" VARCHAR,
  "cum_deaths_60days" VARCHAR,
  "new_first_episode" DOUBLE,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" VARCHAR,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" VARCHAR,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" VARCHAR,
  "test_roll_people" VARCHAR,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" DOUBLE,
  "cum_third_dose" DOUBLE,
  "new_admissions" DOUBLE,
  "cum_admissions" DOUBLE,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);

Wales Covid

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions.wales_covid

109.57 KB
1387 rows
35 columns


CREATE TABLE wales_covid (
  "date" TIMESTAMP,
  "area_type" VARCHAR,
  "area_name" VARCHAR,
  "daily_cases" DOUBLE,
  "cum_cases" DOUBLE,
  "new_deaths_28days" DOUBLE,
  "cum_deaths_28days" DOUBLE,
  "new_deaths_60days" VARCHAR,
  "cum_deaths_60days" VARCHAR,
  "new_first_episode" BIGINT,
  "cum_first_episode" DOUBLE,
  "new_reinfections" DOUBLE,
  "cum_reinfections" DOUBLE,
  "new_virus_test" DOUBLE,
  "cum_virus_test" VARCHAR,
  "new_pcr_test" DOUBLE,
  "cum_pcr_test" VARCHAR,
  "new_lfd_test" DOUBLE,
  "cum_lfd_test" DOUBLE,
  "test_roll_pos_pct" VARCHAR,
  "test_roll_people" VARCHAR,
  "new_first_dose" DOUBLE,
  "cum_first_dose" DOUBLE,
  "new_second_dose" DOUBLE,
  "cum_second_dose" DOUBLE,
  "new_third_dose" VARCHAR,
  "cum_third_dose" VARCHAR,
  "new_admissions" DOUBLE,
  "cum_admissions" DOUBLE,
  "hospital_cases" DOUBLE,
  "ventilator_beds" DOUBLE,
  "trans_rate_min" DOUBLE,
  "trans_rate_max" DOUBLE,
  "trans_growth_min" DOUBLE,
  "trans_growth_max" DOUBLE
);