Weather Data

Live weather data which keeps updating daily

@kaggle.bishop36_weather_data

Table List

1 table(43.21 KB)

Weather

@kaggle.bishop36_weather_data.weather

43.21 KB
227 rows
48 columns

time Time	city City	state State	temperaturec TemperatureC	temperaturef TemperatureF	temperaturek TemperatureK	day_date Day Date	max_temp Max Temp	min_temp Min Temp	air_quality Air Quality	wind Wind	humidity Humidity	visibility Visibility	pressure Pressure	dew_point Dew Point	uv_index UV Index	status Status	moon_phase Moon Phase	sunrise Sunrise	sunset Sunset	moonrise Moonrise	moonset Moonset	sunny Sunny	rainsnow Rainsnow	rainday Rainday	avgrainday AvgRainDay	avgsnowday AvgSnowDay	umbrella Umbrella	outdoors Outdoors	driving Driving	clothing Clothing	heat_stroke Heat Stroke	wind_chill Wind Chill	date_taken Date Taken	weekday WeekDay	umbrella_needed Umbrella Needed	outdoors_needed Outdoors Needed	driving_needed Driving Needed	clothing_needed Clothing Needed	heat_stroke_needed Heat Stroke Needed	wind_chill_needed Wind Chill Needed	umbrella_rank Umbrella Rank	outdoors_rank Outdoors Rank	driving_needed_rank Driving Needed Rank	clothing_rank Clothing Rank	heat_stroke_rank Heat Stroke Rank	wind_chill_rank Wind Chill Rank	date Date
3:04 PM	Bengaluru South	Karnataka	33	91.4	306	Sat 9	35	23	80	5	0.24	6	1016	10	9	Very High	Waning Crescent	6:31 AM	6:29 PM	4:34 PM	4:46 AM	31		2	0.04		Umbrella No need	Outdoors Good	Driving safety Great	Clothing Shorts	Heat stroke Caution	Wind chill Safe	2024-03-08 15:04:53	W6	No need	Good	Great	Shorts	Caution	Safe	1	2	2	S	C	S	Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
3:04 PM	Mumbai	Maharashtra	30	86	303	Sat 9	31	23	118	20	0.26	3	1012	9	10	Very High	Waning Crescent	6:52 AM	6:46 PM	4:45 PM	5:17 AM	31			0.01		Umbrella No need	Outdoors Good	Driving safety Very poor	Clothing Shorts	Heat stroke Caution	Wind chill Safe	2024-03-08 15:05:23	W6	No need	Good	Very poor	Shorts	Caution	Safe	1	2	2	S	C	S	Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
3:05 PM	Mandya	Karnataka	35	95	308	Sat 9	37	23	80	5	0.22	10	1012	10	10	Very High	Waning Crescent	6:33 AM	6:32 PM	4:38 PM	4:49 AM	31			0.04		Umbrella No need	Outdoors Good	Driving safety Great	Clothing Shorts	Heat stroke Extreme caution	Wind chill Safe	2024-03-08 15:05:58	W6	No need	Good	Great	Shorts	Extreme caution	Safe	1	2	2	S	EC	S	Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
3:06 PM	Thane	Maharashtra	36	96.8	309	Sat 9	37	21	95	14	0.15	4	1011	6	10	Very High	Waning Crescent	6:51 AM	6:46 PM	4:44 PM	5:17 AM	31			0.01		Umbrella No need	Outdoors Good	Driving safety Very poor	Clothing Shorts	Heat stroke Extreme caution	Wind chill Safe	2024-03-08 15:06:30	W6	No need	Good	Very poor	Shorts	Extreme caution	Safe	1	2	2	S	EC	S	Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
3:06 PM	Chennai	Tamil Nadu	34	93.2	307	Sat 9	34	25	132	10	0.59	6	1009	24	8	Very High	Waning Crescent	6:20 AM	6:18 PM	4:23 PM	4:35 AM	30		2	0.05		Umbrella No need	Outdoors Good	Driving safety Great	Clothing Shorts	Heat stroke Danger	Wind chill Safe	2024-03-08 15:07:04	W6	No need	Good	Great	Shorts	Danger	Safe	1	2	2	S	D	S	Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
3:07 PM	Delhi	India	26	78.8	299	Sat 9	27	12	233	10	0.3	5	1017	7	6	High	Waning Crescent	6:38 AM	6:25 PM	4:10 PM	5:17 AM	29		7	0.09		Umbrella No need	Outdoors Very poor	Driving safety Very poor	Clothing Breathable clothing	Heat stroke Safe	Wind chill Safe	2024-03-08 15:07:37	W6	No need	Very poor	Very poor	Breathable clothing	Safe	Safe	1	3	5	B	S	S	Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
3:07 PM	Meghalaya Tourism Development Corporation	Shillong	20	68	293	Sat 9	21	9	89	4	0.25	4	1012		8	Very High	Waning Crescent	5:38 AM	5:28 PM	3:15 PM	4:10 AM	18	13	26	0.25		Umbrella No need	Outdoors Great	Driving safety Very poor	Clothing Light jacket	Heat stroke Safe	Wind chill Safe	2024-03-08 15:08:11	W6	No need	Great	Very poor	Light jacket	Safe	Safe	1	1	1	LJ	S	S	Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
3:08 PM	Srinagar	Jammu & Kashmir	14	57.2	287	Sat 9	16	2	169	3	0.61	4	1020	7	6	High	Waning Crescent	6:50 AM	6:33 PM	4:10 PM	5:40 AM	11	16	32	0.55	0.22	Umbrella No need	Outdoors Very poor	Driving safety Great	Clothing Light jacket	Heat stroke Safe	Wind chill Safe	2024-03-08 15:08:42	W6	No need	Very poor	Great	Light jacket	Safe	Safe	1	3	5	LJ	S	S	Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
3:13 PM	Bengaluru South	Karnataka	33	91.4	306	Sat 9	35	23	80	5	0.24	6	1016	10	9	Very High	Waning Crescent	6:31 AM	6:29 PM	4:34 PM	4:46 AM	31		2	0.04		Umbrella No need	Outdoors Good	Driving safety Great	Clothing Shorts	Heat stroke Caution	Wind chill Safe	2024-03-08 15:14:08	W6	No need	Good	Great	Shorts	Caution	Safe	1	2	2	S	C	S	Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)
3:14 PM	Mumbai	Maharashtra	30	86	303	Sat 9	31	23	118	20	0.26	3	1012	9	10	Very High	Waning Crescent	6:52 AM	6:46 PM	4:45 PM	5:17 AM	31			0.01		Umbrella No need	Outdoors Good	Driving safety Very poor	Clothing Shorts	Heat stroke Caution	Wind chill Safe	2024-03-08 15:14:35	W6	No need	Good	Very poor	Shorts	Caution	Safe	1	2	2	S	C	S	Fri Mar 08 2024 00:00:00 GMT+0000 (Coordinated Universal Time)


CREATE TABLE weather (
  "time" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "temperaturec" BIGINT,
  "temperaturef" DOUBLE,
  "temperaturek" BIGINT,
  "day_date" VARCHAR,
  "max_temp" BIGINT,
  "min_temp" BIGINT,
  "air_quality" BIGINT,
  "wind" BIGINT,
  "humidity" DOUBLE,
  "visibility" DOUBLE,
  "pressure" BIGINT,
  "dew_point" BIGINT,
  "uv_index" BIGINT,
  "status" VARCHAR,
  "moon_phase" VARCHAR,
  "sunrise" VARCHAR,
  "sunset" VARCHAR,
  "moonrise" VARCHAR,
  "moonset" VARCHAR,
  "sunny" BIGINT,
  "rainsnow" BIGINT,
  "rainday" BIGINT,
  "avgrainday" DOUBLE,
  "avgsnowday" DOUBLE,
  "umbrella" VARCHAR,
  "outdoors" VARCHAR,
  "driving" VARCHAR,
  "clothing" VARCHAR,
  "heat_stroke" VARCHAR,
  "wind_chill" VARCHAR,
  "date_taken" VARCHAR,
  "weekday" VARCHAR,
  "umbrella_needed" VARCHAR,
  "outdoors_needed" VARCHAR,
  "driving_needed" VARCHAR,
  "clothing_needed" VARCHAR,
  "heat_stroke_needed" VARCHAR,
  "wind_chill_needed" VARCHAR,
  "umbrella_rank" BIGINT,
  "outdoors_rank" BIGINT,
  "driving_needed_rank" BIGINT,
  "clothing_rank" VARCHAR,
  "heat_stroke_rank" VARCHAR,
  "wind_chill_rank" VARCHAR,
  "date" TIMESTAMP
);