Selected Europe And Americas COVID-19 Cases Data

Epidemiological Data

@kaggle.tavoglc_selected_europe_and_americas_covid_19_cases_data

Table List

1 table(417.8 MB)

Selecteddata

@kaggle.tavoglc_selected_europe_and_americas_covid_19_cases_data.selecteddata

417.8 MB
3684838 rows
42 columns

date Date	cases Cases	country Country	qry Qry	lat Lat	long Long	dayofyear Dayofyear	year Year	lengthofday Lengthofday	refdate Refdate	days_since_initialcase Days Since Initialcase	uva UVA	uvb UVB	uvc UVC	vis Vis	nir NIR	swir SWIR	normuva NormUVA	normuvb NormUVB	normuvc NormUVC	normvis NormVis	normnir NormNIR	normswir NormSWIR	frac_scale Frac Scale	frac_scale_norm Frac Scale Norm	frac_value Frac Value	surfpres_forecast_a SurfPres Forecast A	surfskintemp_a SurfSkinTemp A	surfairtemp_a SurfAirTemp A	cloudfrc_a CloudFrc A	toto3_a TotO3 A	olr_a OLR A	clrolr_a ClrOLR A	surfpres_forecast_d SurfPres Forecast D	surfskintemp_d SurfSkinTemp D	surfairtemp_d SurfAirTemp D	cloudfrc_d CloudFrc D	toto3_d TotO3 D	olr_d OLR D	clrolr_d ClrOLR D
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)	1	mexico	lat==19.5600234 & long==-99.1312722	19.5600234	-99.1312722	50	2020	12.27473650548294	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	80	0.0747143584594861	0.5956349865578231	0.9948208057615658	1.823977374537037	1.0561066794190477	0.2904767362667883	0.0060868401065971	0.0485252767985497	0.0810462045614742	0.1485960512245858	0.0860390509358225	0.0236646005506543	5.947346942338903	0.7466606343309715	0.75	1016.0759640309356	295.0977784193421	294.417290715317	0.4597231564848977	263.18422161169883	274.333167823394	284.7485257587982	1014.9979276514184	294.6046529767696	294.1309630116765	0.6356748344686243	270.65257397343265	275.98508592433745	287.74058535599704
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		usa	lat==32.53952745 & long==-86.64408227	32.53952745	-86.64408227	50	2020	11.90470278431492	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	80	0.0747143584594861	0.5956349865578231	0.9948208057615658	1.823977374537037	1.0561066794190477	0.2904767362667883	0.0062760372781356	0.0500335873435331	0.0835653626793854	0.1532148603441175	0.0887134016323804	0.0244001670205078	8.288620166393173	0.7929832474472374	0.8	1022.028460815266	290.41618024837965	288.83293127862817	1.0305353252037597	307.54428616918534	255.7197180793522	266.6538868263803	1021.165138922379	290.0859419203567	284.6957360447369	0.7762340735595876	309.6453984796666	259.51096511754224	270.23667729073605
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		usa	lat==30.72774991 & long==-87.72207058	30.72774991	-87.72207058	50	2020	11.958844478455978	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	80	0.0747143584594861	0.5956349865578231	0.9948208057615658	1.823977374537037	1.0561066794190477	0.2904767362667883	0.0062476235554434	0.049807068536669	0.0831870342953074	0.152521205357504	0.0883117663518108	0.024289699292443	7.724752232614534	0.7578219733480626	0.75	1021.0550088595407	292.1371072834044	288.9562950359337	0.9341187965445494	302.8968050174395	252.10021839900503	272.6987263600664	1020.8223987618854	290.07383075102445	283.16687250543094	0.9624536585282868	302.8668642195852	256.3090872931889	266.72011440030155
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		usa	lat==31.868263 & long==-85.3871286	31.868263	-85.3871286	50	2020	11.92489745718142	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	80	0.0747143584594861	0.5956349865578231	0.9948208057615658	1.823977374537037	1.0561066794190477	0.2904767362667883	0.006265408883201	0.0499488560548685	0.0834238457256053	0.1529553927894449	0.088563166535494	0.0243588456261195	7.928006063384222	0.7582378436565654	0.75	1021.6086679318936	291.8038609599234	287.6124759797676	0.9643709310033904	308.12265943432675	257.8818049462685	271.6778287312966	1020.6926675362336	290.2495467371874	286.45290183567005	0.9034184693984608	304.68481633895306	233.43696689120424	267.8589564224276
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		usa	lat==32.99642064 & long==-87.12511459999996	32.99642064	-87.12511459999996	50	2020	11.890860403074662	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	80	0.0747143584594861	0.5956349865578231	0.9948208057615658	1.823977374537037	1.0561066794190477	0.2904767362667883	0.0062833433348664	0.0500918324130529	0.0836626427389839	0.1533932207349272	0.0888166746239798	0.0244285717282223	8.134244667701921	0.7585530208959301	0.75	1021.9864216602778	289.46789693516587	288.0335305022331	0.9842972948213002	305.8379900886594	252.50710243635783	262.08582997731867	1021.48107806033	289.4316946693289	285.4654581353704	0.8614563620320336	308.4341047520377	256.6697644217703	269.8825680774704
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		usa	lat==33.98210918 & long==-86.56790593	33.98210918	-86.56790593	50	2020	11.860713664951277	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	80	0.0747143584594861	0.5956349865578231	0.9948208057615658	1.823977374537037	1.0561066794190477	0.2904767362667883	0.0062993139005006	0.0502191523531961	0.0838752906329142	0.1537831049683746	0.0890424226781455	0.024490662574981	8.14028892212407	0.7229493197444664	0.7	1022.1172179717367	288.91598859169017	286.6517698760986	0.8726438125365573	303.0364721522652	233.5903791222796	264.16193753377286	1021.5014145934932	287.6167437962141	286.7680555368491	0.7148872286843023	309.6094557168496	254.25221228740995	265.80288048297126
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		usa	lat==32.10030533 & long==-85.71265535	32.10030533	-85.71265535	50	2020	11.917935271008997	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	80	0.0747143584594861	0.5956349865578231	0.9948208057615658	1.823977374537037	1.0561066794190477	0.2904767362667883	0.0062690689922802	0.0499780350382281	0.0834725800350266	0.1530447458440186	0.088614903119006	0.0243730755085898	7.969992154703798	0.7583103388948726	0.75	1021.8683667940418	291.4424659040885	287.79047655878253	0.9942555591551652	308.04628171211914	256.2615576861877	270.7207659963847	1020.8999738366632	290.2868396357646	285.14505253571303	0.8931173627923049	308.9272641349547	246.0405291077272	268.93064283358945
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		usa	lat==31.75300095 & long==-86.68057478	31.75300095	-86.68057478	50	2020	11.928348591025175	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	80	0.0747143584594861	0.5956349865578231	0.9948208057615658	1.823977374537037	1.0561066794190477	0.2904767362667883	0.0062635961624814	0.0499344047512139	0.0833997093705044	0.1529111394270777	0.0885375432617434	0.0243517980758326	8.115673050443224	0.7927241888696205	0.8	1021.8830754455472	291.4370019019943	288.6055076259895	1.0067138304186334	305.38086584503384	257.01369577266286	272.11626645698993	1020.7977011218156	290.18802800792525	284.6389198707285	0.6717776543468137	308.9765705698058	257.95913461669244	270.6707274352672
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		usa	lat==33.77483727 & long==-85.82630386	33.77483727	-85.82630386	50	2020	11.867086233915062	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	80	0.0747143584594861	0.5956349865578231	0.9948208057615658	1.823977374537037	1.0561066794190477	0.2904767362667883	0.0062959311988446	0.0501921849068183	0.0838302500000764	0.1537005241711545	0.0889946073199325	0.0244775112054576	8.108459087264187	0.7229214668304537	0.7	1022.2328974531232	288.9778268716262	286.75387727288586	0.8995031116790563	306.7971529818611	239.89609157330048	264.68566703388086	1021.303383592074	287.9087631113011	287.090201668342	0.913915977615935	309.5883109154048	252.75476166399287	265.5870389752828
Wed Feb 19 2020 00:00:00 GMT+0000 (Coordinated Universal Time)		usa	lat==32.91360079 & long==-85.39072749	32.91360079	-85.39072749	50	2020	11.893375574482256	Sun Dec 01 2019 00:00:00 GMT+0000 (Coordinated Universal Time)	80	0.0747143584594861	0.5956349865578231	0.9948208057615658	1.823977374537037	1.0561066794190477	0.2904767362667883	0.0062820145543699	0.0500812391593672	0.0836449500422736	0.1533607816481015	0.0887978919697927	0.0244234056553312	8.371968163475634	0.7930909027468207	0.8	1021.960632223114	290.0209559673107	287.8691393613462	1.0086161604323125	308.59968255999013	253.49811539391536	266.8298074774564	1020.8928270401548	289.4041570013128	284.53382483224425	0.9956863615968083	306.3222243428747	248.06267393594143	270.31674719335456


CREATE TABLE selecteddata (
  "date" TIMESTAMP,
  "cases" DOUBLE,
  "country" VARCHAR,
  "qry" VARCHAR,
  "lat" DOUBLE,
  "long" DOUBLE,
  "dayofyear" BIGINT,
  "year" BIGINT,
  "lengthofday" DOUBLE,
  "spots" DOUBLE,
  "refdate" TIMESTAMP,
  "days_since_initialcase" BIGINT,
  "normspots" DOUBLE,
  "uva" DOUBLE,
  "uvb" DOUBLE,
  "uvc" DOUBLE,
  "vis" DOUBLE,
  "nir" DOUBLE,
  "swir" DOUBLE,
  "normuva" DOUBLE,
  "normuvb" DOUBLE,
  "normuvc" DOUBLE,
  "normvis" DOUBLE,
  "normnir" DOUBLE,
  "normswir" DOUBLE,
  "frac_scale" DOUBLE,
  "frac_scale_norm" DOUBLE,
  "frac_value" DOUBLE,
  "surfpres_forecast_a" DOUBLE,
  "surfskintemp_a" DOUBLE,
  "surfairtemp_a" DOUBLE,
  "cloudfrc_a" DOUBLE,
  "toto3_a" DOUBLE,
  "olr_a" DOUBLE,
  "clrolr_a" DOUBLE,
  "surfpres_forecast_d" DOUBLE,
  "surfskintemp_d" DOUBLE,
  "surfairtemp_d" DOUBLE,
  "cloudfrc_d" DOUBLE,
  "toto3_d" DOUBLE,
  "olr_d" DOUBLE,
  "clrolr_d" DOUBLE
);