Napa Valley Weather Data

Monthly Napa Valley Weather Data from 1893 to 2022

@kaggle.jarredpriester_napa_valley_weather_data

Table List

1 table(32.93 KB)

Napa Weather

@kaggle.jarredpriester_napa_valley_weather_data.napa_weather

32.93 KB
1481 rows
16 columns

station STATION	name NAME	latitude LATITUDE	longitude LONGITUDE	elevation ELEVATION	date DATE	dp01 DP01	dp10 DP10	dt32 DT32	dx90 DX90	prcp PRCP	tavg TAVG	tmax TMAX	tmin TMIN
USC00046074	NAPA STATE HOSPITAL, CA US	38.2777	-122.2647	10.7	1893-01	11	7	2		108.6	8.3	12.1	4.4
USC00046074	NAPA STATE HOSPITAL, CA US	38.2777	-122.2647	10.7	1893-02	9	6			55.7	11.3	16.1	6.5
USC00046074	NAPA STATE HOSPITAL, CA US	38.2777	-122.2647	10.7	1893-03						11.5	15.8	7.2
USC00046074	NAPA STATE HOSPITAL, CA US	38.2777	-122.2647	10.7	1893-04	7	2			26.7	12.9	18.6	7.2
USC00046074	NAPA STATE HOSPITAL, CA US	38.2777	-122.2647	10.7	1893-05	3	3			12.5	16.2	22.9	9.5
USC00046074	NAPA STATE HOSPITAL, CA US	38.2777	-122.2647	10.7	1893-06				1		17.9	25.2	10.5
USC00046074	NAPA STATE HOSPITAL, CA US	38.2777	-122.2647	10.7	1893-07				1		19.4	26.3	12.5
USC00046074	NAPA STATE HOSPITAL, CA US	38.2777	-122.2647	10.7	1893-08						18.8	25.1	12.4
USC00046074	NAPA STATE HOSPITAL, CA US	38.2777	-122.2647	10.7	1893-09	2	1			4.9	17	23	11.1
USC00046074	NAPA STATE HOSPITAL, CA US	38.2777	-122.2647	10.7	1893-10	1	1			4.3	14.6	20.9	8.1


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