Dataset: Historical Temperature In Canada

About this Dataset

Historical Temperature In Canada

This dataset includes daily temperatures in Canada from 1973 to 2023. The data was extracted from the Government of Canada's open dataset, which contains the Adjusted and Homogenized Canadian Climate Data.

Tables

Ca Temperature

@kaggle.tomasmayer73_historical_temperature_in_canada.ca_temperature

44.17 MB
11597154 rows
15 columns


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