Weather Data

Synthetic Dataset: Explore Weather Patterns & Predictions in 10 Locations.

@kaggle.prasad22_weather_data

Table List

1 table(39.98 MB)

Weather Data

@kaggle.prasad22_weather_data.weather_data

39.98 MB
1000000 rows
6 columns

location Location	date_time Date Time	temperature_c Temperature C	humidity_pct Humidity Pct	precipitation_mm Precipitation Mm	wind_speed_kmh Wind Speed Kmh
San Diego	Sun Jan 14 2024 21:12:46 GMT+0000 (Coordinated Universal Time)	10.683001094715388	41.19575356694448	4.02011871570867	8.233540246873023
San Diego	Fri May 17 2024 15:22:10 GMT+0000 (Coordinated Universal Time)	8.734139782353598	58.31910739552024	9.111623448229375	27.71516125689249
San Diego	Sat May 11 2024 09:30:59 GMT+0000 (Coordinated Universal Time)	11.632436312930883	38.82017526915946	4.607511377146035	28.732951288236187
Philadelphia	Mon Feb 26 2024 17:32:39 GMT+0000 (Coordinated Universal Time)	-8.62897589569391	54.07447397596174	3.183719747807655	26.367302672536635
San Antonio	Mon Apr 29 2024 13:23:51 GMT+0000 (Coordinated Universal Time)	39.8082129746316	72.89990795294305	9.598282136749663	29.89862166929609
San Diego	Sun Jan 21 2024 08:54:56 GMT+0000 (Coordinated Universal Time)	27.341054869123997	49.02323606834762	9.166543302732745	27.47389608451584
San Jose	Sat Jan 13 2024 02:10:54 GMT+0000 (Coordinated Universal Time)	1.881883367968177	65.74232453691016	0.2217090431972102	1.0731117811228597
New York	Thu Jan 25 2024 19:04:34 GMT+0000 (Coordinated Universal Time)	-6.894765540954558	30.80489400823282	8.027623514181629	16.84833686516356
New York	Fri Mar 29 2024 05:20:30 GMT+0000 (Coordinated Universal Time)	0.9635448943544382	38.81915764095648	3.640129168740153	7.989023971699378
San Jose	Sat May 18 2024 09:14:02 GMT+0000 (Coordinated Universal Time)	-1.6070880384255215	82.19870131323366	4.101492971518511	25.647282070436543


CREATE TABLE weather_data (
  "location" VARCHAR,
  "date_time" TIMESTAMP,
  "temperature_c" DOUBLE,
  "humidity_pct" DOUBLE,
  "precipitation_mm" DOUBLE,
  "wind_speed_kmh" DOUBLE
);