Name: Weather Conditions In World War Two
Creator: Kaggle
License: https://www.usa.gov/government-works

About this Dataset

Weather Conditions In World War Two

Context

While exploring the Aerial Bombing Operations of World War Two dataset (https://www.kaggle.com/usaf/world-war-ii), and recalling that the D-Day landings were nearly postponed due to poor weather, I sought out weather reports from the period to compare with missions in the bombing operations dataset.

Content

The dataset contains information on weather conditions recorded on each day at various weather stations around the world. Information includes precipitation, snowfall, temperatures, wind speed and whether the day included thunder storms or other poor weather conditions.

Acknowledgements

The data are taken from the United States National Oceanic and Atmospheric Administration (https://www.kaggle.com/noaa) National Centres for Environmental Information website: https://www.ncdc.noaa.gov/data-access/land-based-station-data/land-based-datasets/world-war-ii-era-data

Inspiration

This dataset is mostly to assist with the analysis of the Aerial Bombing Operations dataset, also hosted on Kaggle.

Tables

Summary Of Weather

@kaggle.smid80_weatherww2.summary_of_weather

923.59 KB
119040 rows
31 columns


CREATE TABLE summary_of_weather (
  "sta" BIGINT,
  "date" TIMESTAMP,
  "precip" VARCHAR,
  "windgustspd" DOUBLE,
  "maxtemp" DOUBLE,
  "mintemp" DOUBLE,
  "meantemp" DOUBLE,
  "snowfall" VARCHAR,
  "poorweather" VARCHAR,
  "yr" BIGINT,
  "mo" BIGINT,
  "da" BIGINT,
  "prcp" VARCHAR,
  "dr" DOUBLE,
  "spd" DOUBLE,
  "max" DOUBLE,
  "min" DOUBLE,
  "mea" DOUBLE,
  "snf" VARCHAR,
  "snd" DOUBLE,
  "ft" VARCHAR,
  "fb" VARCHAR,
  "fti" VARCHAR,
  "ith" VARCHAR,
  "pgt" DOUBLE,
  "tshdsbrsgf" VARCHAR,
  "sd3" VARCHAR,
  "rhx" VARCHAR,
  "rhn" VARCHAR,
  "rvg" VARCHAR,
  "wte" VARCHAR
);

Weather Station Locations

@kaggle.smid80_weatherww2.weather_station_locations

13.7 KB
161 rows
8 columns


CREATE TABLE weather_station_locations (
  "wban" BIGINT,
  "name" VARCHAR,
  "state_country_id" VARCHAR,
  "lat" VARCHAR,
  "lon" VARCHAR,
  "elev" BIGINT,
  "latitude" DOUBLE,
  "longitude" DOUBLE
);