Baselight
Sign In

UK Daily COVID Data - Countries And Regions

Daily UK Covid data from the different countries & different regions in England

@kaggle.albertovidalrod_uk_daily_covid_data_countries_and_regions

Loading...
Loading...

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
  • 235.77 kB
  • 1,441 rows
  • 35 columns
Loading... 
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
  • 25.3 kB
  • 1,360 rows
  • 8 columns
Loading... 
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
  • 27.08 kB
  • 1,360 rows
  • 8 columns
Loading... 
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.71 kB
  • 1,360 rows
  • 8 columns
Loading... 
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.95 kB
  • 1,360 rows
  • 8 columns
Loading... 
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.7 kB
  • 1,360 rows
  • 8 columns
Loading... 
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
  • 26.13 kB
  • 1,360 rows
  • 8 columns
Loading... 
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
  • 24.25 kB
  • 1,360 rows
  • 8 columns
Loading... 
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
  • 177.65 kB
  • 1,441 rows
  • 27 columns
Loading... 
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
  • 180.5 kB
  • 1,441 rows
  • 27 columns
Loading... 
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
  • 184.07 kB
  • 1,441 rows
  • 27 columns
Loading... 
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
  • 170.17 kB
  • 1,440 rows
  • 27 columns
Loading... 
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
  • 184.24 kB
  • 1,441 rows
  • 27 columns
Loading... 
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
  • 185.21 kB
  • 1,441 rows
  • 27 columns
Loading... 
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
  • 178.14 kB
  • 1,441 rows
  • 27 columns
Loading... 
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
  • 180.38 kB
  • 1,441 rows
  • 27 columns
Loading... 
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
  • 179.61 kB
  • 1,441 rows
  • 27 columns
Loading... 
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
  • 91.43 kB
  • 1,385 rows
  • 35 columns
Loading... 
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
  • 113.86 kB
  • 1,313 rows
  • 35 columns
Loading... 
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
  • 112.2 kB
  • 1,387 rows
  • 35 columns
Loading... 
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
);

Share link

Anyone who has the link will be able to view this.