Name: Aerial Bombing Operations In World War II
Creator: Kaggle
License: https://creativecommons.org/publicdomain/zero/1.0/

About this Dataset

Aerial Bombing Operations In World War II

Content

This dataset consists of digitized paper mission reports from WWII. Each record includes the date, conflict, geographic location, and other data elements to form a live-action sequence of air warfare from 1939 to 1945. The records include U.S. and Royal Air Force data, in addition to some Australian, New Zealand and South African air force missions.

Acknowledgements

Lt Col Jenns Robertson of the US Air Force developed the Theater History of Operations Reports (THOR) and posted them online after receiving Department of Defense approval.

Tables

Operations

@kaggle.usaf_world_war_ii.operations

5.03 MB
178,281 rows
46 columns

CREATE TABLE operations (
  "mission_id" BIGINT,
  "mission_date" TIMESTAMP,
  "theater_of_operations" VARCHAR,
  "country" VARCHAR,
  "air_force" VARCHAR,
  "unit_id" VARCHAR,
  "aircraft_series" VARCHAR,
  "callsign" VARCHAR,
  "mission_type" VARCHAR,
  "takeoff_base" VARCHAR,
  "takeoff_location" VARCHAR,
  "takeoff_latitude" VARCHAR,
  "takeoff_longitude" DOUBLE,
  "target_id" VARCHAR,
  "target_country" VARCHAR,
  "target_city" VARCHAR,
  "target_type" VARCHAR,
  "target_industry" VARCHAR,
  "target_priority" VARCHAR,
  "target_latitude" DOUBLE,
  "target_longitude" DOUBLE,
  "altitude_hundreds_of_feet" DOUBLE  -- Altitude (Hundreds Of Feet),
  "airborne_aircraft" DOUBLE,
  "attacking_aircraft" DOUBLE,
  "bombing_aircraft" DOUBLE,
  "aircraft_returned" DOUBLE,
  "aircraft_failed" DOUBLE,
  "aircraft_damaged" DOUBLE,
  "aircraft_lost" DOUBLE,
  "high_explosives" DOUBLE,
  "high_explosives_type" VARCHAR,
  "high_explosives_weight_pounds" VARCHAR  -- High Explosives Weight (Pounds),
  "high_explosives_weight_tons" DOUBLE  -- High Explosives Weight (Tons),
  "incendiary_devices" DOUBLE,
  "incendiary_devices_type" VARCHAR,
  "incendiary_devices_weight_pounds" DOUBLE  -- Incendiary Devices Weight (Pounds),
  "incendiary_devices_weight_tons" DOUBLE  -- Incendiary Devices Weight (Tons),
  "fragmentation_devices" DOUBLE,
  "fragmentation_devices_type" VARCHAR,
  "fragmentation_devices_weight_pounds" DOUBLE  -- Fragmentation Devices Weight (Pounds),
  "fragmentation_devices_weight_tons" DOUBLE  -- Fragmentation Devices Weight (Tons),
  "total_weight_pounds" DOUBLE  -- Total Weight (Pounds),
  "total_weight_tons" DOUBLE  -- Total Weight (Tons),
  "time_over_target" VARCHAR,
  "bomb_damage_assessment" VARCHAR,
  "source_id" DOUBLE
);