UK Daily COVID Data - Countries And Regions

date Date	area_type Area Type	area_name Area Name	daily_cases Daily Cases	cum_cases Cum Cases	new_first_episode New First Episode	cum_first_episode Cum First Episode	new_reinfections New Reinfections	cum_reinfections Cum Reinfections	new_virus_test New Virus Test	cum_virus_test Cum Virus Test	new_pcr_test New Pcr Test	cum_pcr_test Cum Pcr Test	cum_lfd_test Cum Lfd Test	test_roll_pos_pct Test Roll Pos Pct	test_roll_people Test Roll People	cum_first_dose Cum First Dose	cum_second_dose Cum Second Dose	new_third_dose New Third Dose	cum_third_dose Cum Third Dose	new_admissions New Admissions	cum_admissions Cum Admissions	hospital_cases Hospital Cases
Wed Dec 13 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nation	England	583	21024823	294	19384397	289	1640426								43786439	41773077	434	33258442
Tue Dec 12 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nation	England	1040	21024240	600	19384103	440	1640137	1707	544681241	1707	223510795	321170446			43786439	41773077	490	33258008
Mon Dec 11 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nation	England	1183	21023200	703	19383503	480	1639697	5884	544679534	5884	223509088	321170446			43786439	41773077	549	33257518
Sun Dec 10 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nation	England	947	21022017	538	19382800	409	1639217	5514	544673650	5514	223503204	321170446			43786439	41773077	102	33256969
Sat Dec 09 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nation	England	771	21021070	480	19382262	291	1638808	6001	544668136	6001	223497690	321170446			43786439	41773077	450	33256867
Fri Dec 08 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nation	England	882	21020299	532	19381782	350	1638517	7840	544662135	7840	223491689	321170446			43786439	41773077	580	33256417	308	1101585	2913
Thu Dec 07 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nation	England	807	21019417	480	19381250	327	1638167	8333	544654295	8333	223483849	321170446			43786439	41773077	574	33255837	364	1101277	2775
Wed Dec 06 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nation	England	945	21018610	564	19380770	381	1637840	8946	544645962	8946	223475516	321170446			43786439	41773077	601	33255263	455	1100913	2629
Tue Dec 05 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nation	England	933	21017665	571	19380206	362	1637459	10139	544637016	10139	223466570	321170446			43786439	41773077	687	33254662	420	1100458	2576
Mon Dec 04 2023 00:00:00 GMT+0000 (Coordinated Universal Time)	nation	England	950	21016732	544	19379635	406	1637097	9805	544626877	9805	223456431	321170446	8.7	28259	43786439	41773077	620	33253975	432	1100038	2475


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
);