Top 100 Cities Weather Dataset

Unlock Insights with Extensive Weather Data for 100 Major Cities

@kaggle.danishammar_top_100_cities_weather_dataset

Table List

1 table(9.87 KB)

Top100cities Weather Data

@kaggle.danishammar_top_100_cities_weather_dataset.top100cities_weather_data

9.87 KB
100 rows
7 columns

city City	temperature_celsius Temperature (Celsius)	wind_speed_m_s Wind Speed (m/s)	latitude Latitude	longitude Longitude	description Description	country Country
Paris	10.460000000000036	2.06	48.8534	2.3488	clear sky	France
Dubai	29.32000000000005	3.09	25.2582	55.3047	clear sky	United Arab Emirates
Madrid	9.970000000000027	3.6	40.4165	-3.7026	clear sky	Spain
Tokyo	21.58000000000004	2.06	35.6895	139.6917	broken clouds	Japan
Amsterdam	8	3.58	52.374	4.8897	clear sky	Netherlands
Berlin	15.660000000000023	2.68	52.5244	13.4105	clear sky	Germany
Rome	26.090000000000032	3.6	34.257	-85.1647	broken clouds	Italy
New York City	21.79000000000002	4.63	40.7143	-74.006	clear sky	United States
Barcelona	14.230000000000018	4.12	41.3888	2.159	shower rain	Spain
London	7.670000000000016	2.57	51.5085	-0.1257	scattered clouds	United Kingdom


CREATE TABLE top100cities_weather_data (
  "city" VARCHAR,
  "temperature_celsius" DOUBLE,
  "wind_speed_m_s" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "description" VARCHAR,
  "country" VARCHAR
);