Historical Temperature In Canada

Historical Temperature across Canada Weather Stations

@kaggle.tomasmayer73_historical_temperature_in_canada

Table List

1 table(44.17 MB)

Ca Temperature

@kaggle.tomasmayer73_historical_temperature_in_canada.ca_temperature

44.17 MB
11597154 rows
15 columns

station Station	province Province	year Year	month Month	day Day	mintemp MinTemp	flagmin FlagMin	meantemp MeanTemp	flagmean FlagMean	maxtemp MaxTemp	flagmax FlagMax	n__miss %Miss	lat_deg Lat(deg)	long_deg Long(deg)	elev_m Elev(m)
ABBEY	SASK	1976	12	1	-3.9	nan	0.9	nan	5.6	nan	14.3	50.7	-108.78	695
ABBEY	SASK	1976	12	2	-2.2	nan	1.7	nan	5.6	nan	14.3	50.7	-108.78	695
ABBEY	SASK	1976	12	3	-14.4	nan	-8.9	nan	-3.3	nan	14.3	50.7	-108.78	695
ABBEY	SASK	1976	12	4	-7.8	nan	-6.1	nan	-4.4	nan	14.3	50.7	-108.78	695
ABBEY	SASK	1976	12	5	-23.3	nan	-20.3	nan	-17.2	nan	14.3	50.7	-108.78	695
ABBEY	SASK	1976	12	6	-25.6	nan	-18.9	nan	-12.2	nan	14.3	50.7	-108.78	695
ABBEY	SASK	1976	12	7	-23.9	nan	-18.6	nan	-13.3	nan	14.3	50.7	-108.78	695
ABBEY	SASK	1976	12	8	-16.1	nan	-14.7	nan	-13.3	nan	14.3	50.7	-108.78	695
ABBEY	SASK	1976	12	9	-25.6	nan	-20	nan	-14.4	nan	14.3	50.7	-108.78	695
ABBEY	SASK	1976	12	10	-28.3	nan	-13.1	nan	2.2	nan	14.3	50.7	-108.78	695


CREATE TABLE ca_temperature (
  "station" VARCHAR,
  "province" VARCHAR,
  "year" BIGINT,
  "month" BIGINT,
  "day" BIGINT,
  "mintemp" DOUBLE,
  "flagmin" VARCHAR,
  "meantemp" DOUBLE,
  "flagmean" VARCHAR,
  "maxtemp" DOUBLE,
  "flagmax" VARCHAR,
  "n__miss" DOUBLE,
  "lat_deg" DOUBLE,
  "long_deg" DOUBLE,
  "elev_m" DOUBLE
);