Rome Italy Weather Data

Monthly Rome Italy Weather Data from 1951 to 2022

@kaggle.jarredpriester_rome_italy_weather_data

Table List

1 table(23.96 KB)

Roma Weather

@kaggle.jarredpriester_rome_italy_weather_data.roma_weather

23.96 KB
804 rows
15 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
IT000016239	ROMA CIAMPINO, IT	41.7831	12.5831	105	1951-01	12	7			87.1	9.7	13.6	5.8
IT000016239	ROMA CIAMPINO, IT	41.7831	12.5831	105	1951-02	15	3			27.4	10.5	14.2	6.7
IT000016239	ROMA CIAMPINO, IT	41.7831	12.5831	105	1951-03	12	5	4		43.5	10.6	15.4	5.9
IT000016239	ROMA CIAMPINO, IT	41.7831	12.5831	105	1951-04	7	3			27.1	13.6	18.9	8.2
IT000016239	ROMA CIAMPINO, IT	41.7831	12.5831	105	1951-05	9	5			40.7	16.6	21.6	11.6
IT000016239	ROMA CIAMPINO, IT	41.7831	12.5831	105	1951-06	2	1		2	8.7	21.1	27	15.2
IT000016239	ROMA CIAMPINO, IT	41.7831	12.5831	105	1951-07	1			5	1	23.6	29.8	17.4
IT000016239	ROMA CIAMPINO, IT	41.7831	12.5831	105	1951-08	2	2		9	15.9	24.5	31.1	17.9
IT000016239	ROMA CIAMPINO, IT	41.7831	12.5831	105	1951-09	11	6			212.4	22.1	27.8	16.4
IT000016239	ROMA CIAMPINO, IT	41.7831	12.5831	105	1951-10	8	7			69.4	15.3	20.8	9.9


CREATE TABLE roma_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,
  "tavg" DOUBLE,
  "tmax" DOUBLE,
  "tmin" DOUBLE
);