About this Dataset

Historical Weather Data Of 194 Country Capitals

Content

This dataset contains the daily weather data recorded in the capital location (based on lat, long values) of 194 countries in the world. The data contains the following information:

date - weather data recorded date
country - name of the country
city - name of the city
Latitude - latitude value of the city location
Longitude - longitude value of the city location
tavg - The average air temperature in °C
tmin - The minimum air temperature in °C
tmax - The maximum air temperature in °C
wdir - The average wind direction in degrees (°)
wspd - The average wind speed in km/h
pres - The average sea-level air pressure in hPa

The data is extracted using Meteostat API

Tables

Daily Weather Data

@kaggle.balabaskar_historical_weather_data_of_all_country_capitals.daily_weather_data

2.59 MB
324647 rows
11 columns


CREATE TABLE daily_weather_data (
  "date" VARCHAR,
  "country" VARCHAR,
  "city" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "tavg" DOUBLE,
  "tmin" DOUBLE,
  "tmax" DOUBLE,
  "wdir" DOUBLE,
  "wspd" DOUBLE,
  "pres" DOUBLE
);