Name: Historical Temperature In Canada
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

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

46.31 MB
11,597,154 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  -- %Miss,
  "lat_deg" DOUBLE  -- Lat(deg),
  "long_deg" DOUBLE  -- Long(deg),
  "elev_m" DOUBLE  -- Elev(m)
);