Name: Napa Valley Weather Data
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Napa Valley Weather Data

This dataset has monthly temperature and precipitation data from Napa Valley, California from 1893 to 2022.

All measurements are in metric units

STATION - The station ID used by NOAA
NAME - The name of the station
LATITUDE - Latitude of the station
LONGITUDE - Longitude of the station
ELEVATION - elevation of the station
DATE - month of observation
DP01 - Number of days with >= 0.01 inch/0.254 millimeter in the month
DP10 - Number of days with >= 0.1 inch/2.54 millimeters in the month
DT32 - Number of days with minimum temperature <= 32 degrees Fahrenheit/0 degrees Celsius
DX32 - Number of days with maximum temperature <= 32 degrees Fahrenheit/0 degrees Celsius
DX90 - Number of days with maximum temperature >= 90 degrees Fahrenheit/32.2 degrees Celsius
PRCP - Precipitation in mm
SNOW - Snow in mm
TAVG - Average Temperature in Celsius
TMAX - Maximum Temperature in Celsius
TMIN - Minimum Temperature in Celsius

Tables

Napa Weather

@kaggle.jarredpriester_napa_valley_weather_data.napa_weather

33.72 kB
1,481 rows
16 columns

CREATE TABLE napa_weather (
  "station" VARCHAR,
  "name" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "elevation" DOUBLE,
  "date" VARCHAR,
  "dp01" DOUBLE,
  "dp10" DOUBLE,
  "dt32" DOUBLE,
  "dx32" DOUBLE,
  "dx90" DOUBLE,
  "prcp" DOUBLE,
  "snow" DOUBLE,
  "tavg" DOUBLE,
  "tmax" DOUBLE,
  "tmin" DOUBLE
);