Name: Sierra Nevada Mountains Dataset
Creator: Kaggle
License: https://opendatacommons.org/licenses/pddl/1.0/

About this Dataset

Sierra Nevada Mountains Dataset

For decades, UC Berkeley’s Central Sierra Snow Lab has been collecting daily temperature, snowfall, snowpack, and related measurements at its field station near Donner Pass. Until recently, the records were available only upon request. That changed last year, when the lab published a fully-public dataset of the daily measurements for October 1970 to September 2019.

Source: https://datadryad.org/stash/dataset/doi:10.6078%2FD1941T

Tables

Donner Pass

@kaggle.michaelbryantds_sierra_nevada_mountains_dataset.donner_pass

351.41 kB
17,897 rows
12 columns

CREATE TABLE donner_pass (
  "date" TIMESTAMP,
  "air_temp_max_c" VARCHAR  -- Air Temp Max (C),
  "air_temp_min_c" VARCHAR  -- Air Temp Min (C),
  "n_24_hour_total_precip_mm" VARCHAR  -- 24-hour Total Precip (mm),
  "season_total_precip_mm" DOUBLE  -- Season Total Precip (mm),
  "n__of_precip_as_snow" VARCHAR  -- % Of Precip As Snow,
  "n__of_precip_as_rain" VARCHAR  -- % Of Precip As Rain,
  "new_snow_cm" VARCHAR  -- New Snow (cm),
  "season_total_snow_cm" VARCHAR  -- Season Total Snow (cm),
  "snowpack_depth_cm" VARCHAR  -- Snowpack Depth (cm),
  "snow_water_equivalent_cm" VARCHAR  -- Snow Water Equivalent (cm),
  "remarks" VARCHAR
);