Weather Conditions In World War Two

Daily Weather Summaries from 1940-1945

@kaggle.smid80_weatherww2

Table List

2 tables(937.29 KB)

Summary Of Weather

@kaggle.smid80_weatherww2.summary_of_weather

923.59 KB
119040 rows
31 columns

sta STA	date Date	precip Precip	maxtemp MaxTemp	mintemp MinTemp	meantemp MeanTemp	poorweather PoorWeather	yr YR	mo MO	da DA	prcp PRCP	max MAX	min MIN	mea MEA	tshdsbrsgf TSHDSBRSGF
10001	Wed Jul 01 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	1.016	25.55555556	22.22222222	23.88888889	nan	42	7	1	0.04	78	72	75	nan
10001	Thu Jul 02 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	0	28.88888889	21.66666667	25.55555556	nan	42	7	2	0	84	71	78	nan
10001	Fri Jul 03 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	2.54	26.11111111	22.22222222	24.44444444	nan	42	7	3	0.1	79	72	76	nan
10001	Sat Jul 04 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	2.54	26.66666667	22.22222222	24.44444444	nan	42	7	4	0.1	80	72	76	nan
10001	Sun Jul 05 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	0	26.66666667	21.66666667	24.44444444	nan	42	7	5	0	80	71	76	nan
10001	Mon Jul 06 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	0	26.66666667	21.66666667	24.44444444	nan	42	7	6	0	80	71	76	nan
10001	Tue Jul 07 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	T	28.33333333	22.77777778	25.55555556	nan	42	7	7	T	83	73	78	nan
10001	Wed Jul 08 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	3.556	26.66666667	22.22222222	24.44444444	nan	42	7	8	0.14	80	72	76	nan
10001	Thu Jul 09 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	T	27.22222222	22.77777778	25	nan	42	7	9	T	81	73	77	nan
10001	Fri Jul 10 1942 00:00:00 GMT+0000 (Coordinated Universal Time)	3.556	25.55555556	21.66666667	23.33333333	nan	42	7	10	0.14	78	71	74	nan


CREATE TABLE summary_of_weather (
  "sta" BIGINT,
  "date" TIMESTAMP,
  "precip" VARCHAR,
  "windgustspd" DOUBLE,
  "maxtemp" DOUBLE,
  "mintemp" DOUBLE,
  "meantemp" DOUBLE,
  "snowfall" VARCHAR,
  "poorweather" VARCHAR,
  "yr" BIGINT,
  "mo" BIGINT,
  "da" BIGINT,
  "prcp" VARCHAR,
  "dr" DOUBLE,
  "spd" DOUBLE,
  "max" DOUBLE,
  "min" DOUBLE,
  "mea" DOUBLE,
  "snf" VARCHAR,
  "snd" DOUBLE,
  "ft" VARCHAR,
  "fb" VARCHAR,
  "fti" VARCHAR,
  "ith" VARCHAR,
  "pgt" DOUBLE,
  "tshdsbrsgf" VARCHAR,
  "sd3" VARCHAR,
  "rhx" VARCHAR,
  "rhn" VARCHAR,
  "rvg" VARCHAR,
  "wte" VARCHAR
);