Aerial Bombing Operations In World War II

Target, aircraft used, and bombs deployed for every mission in WWII

@kaggle.usaf_world_war_ii

Table List

1 table(4.8 MB)

Operations

@kaggle.usaf_world_war_ii.operations

4.8 MB
178281 rows
46 columns

mission_id Mission ID	mission_date Mission Date	theater_of_operations Theater Of Operations	country Country	air_force Air Force	unit_id Unit ID	aircraft_series Aircraft Series	callsign Callsign	mission_type Mission Type	takeoff_base Takeoff Base	takeoff_location Takeoff Location	takeoff_latitude Takeoff Latitude	takeoff_longitude Takeoff Longitude	target_id Target ID	target_country Target Country	target_city Target City	target_type Target Type	target_industry Target Industry	target_priority Target Priority	target_latitude Target Latitude	target_longitude Target Longitude	altitude_hundreds_of_feet Altitude (Hundreds Of Feet)	airborne_aircraft Airborne Aircraft	attacking_aircraft Attacking Aircraft	bombing_aircraft Bombing Aircraft	aircraft_failed Aircraft Failed	high_explosives High Explosives	high_explosives_type High Explosives Type	high_explosives_weight_pounds High Explosives Weight (Pounds)	high_explosives_weight_tons High Explosives Weight (Tons)	incendiary_devices_type Incendiary Devices Type	fragmentation_devices_type Fragmentation Devices Type	total_weight_tons Total Weight (Tons)	time_over_target Time Over Target	bomb_damage_assessment Bomb Damage Assessment	source_id Source ID
1	Sun Aug 15 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	MTO	USA	12 AF	27 FBG/86 FBG	A36	nan	nan	PONTE OLIVO AIRFIELD	SICILY	37.131022	14.321464	40675	ITALY	SPADAFORA	nan	nan	nan	38.22	15.37		20		20		40	500 LB GP (GP-M43/M64)	nan	10	nan	nan	10	nan	nan
2	Sun Aug 15 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	PTO	USA	5 AF	400 BS	B24	nan	1	nan	nan	nan		nan	NEW GUINEA	KOMIATUM	RIDGE	nan	1	-7.166666667	147	44		6			40	1000 LB GP (GP-M44/M65)	nan	20	nan	nan	20	nan	nan	9366
3	Sun Aug 15 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	MTO	USA	12 AF	27 FBG/86 FBG	A36	nan	nan	PONTE OLIVO AIRFIELD	SICILY	37.131022	14.321464	9630	ITALY	COSENZA	nan	nan	nan	39.27	16.25		18		36		36	500 LB GP (GP-M43/M64)	nan	9	nan	nan	9	nan	nan
4	Sun Aug 15 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	MTO	USA	12 AF	27 FBG/86 FBG	A36	nan	nan	PONTE OLIVO AIRFIELD	SICILY	37.131022	14.321464	16140	ITALY	GIOJA TAURO	nan	nan	nan	38.43	15.9		15		15	1	30	500 LB GP (GP-M43/M64)	nan	7.5	nan	nan	7.5	nan	nan
5	Sun Aug 15 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	PTO	USA	5 AF	321 BS	B24	nan	1	nan	nan	nan		nan	SUMATRA	KILA	VILLAGE	nan	1	-1.116666667	103.8833333	60		6			16	1000 LB GP (GP-M44/M65)	nan	8	nan	nan	8	nan	nan	22585
6	Sun Aug 15 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	PTO	USA	5 AF	319 BS	B24	nan	1	nan	nan	nan		nan	NEW GUINEA	KDMIATUM	UNIDENTIFIED TARGET	nan	1	-7.166666667	147	35		6			8	1000 LB GP (GP-M44/M65)	nan	4	nan	nan	4	nan	nan	9349
7	Sun Aug 15 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	PTO	USA	5 AF	400 BS	B24	nan	12	nan	nan	nan		nan	NEW GUINEA	SALAMAUA	UNIDENTIFIED TARGET	nan	1	-7.016666667	147.1166667	70		1			4	500 LB GP (GP-M43/M64)	nan	1	nan	nan	1	nan	nan	11287
8	Sun Aug 15 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	PTO	USA	5 AF	65 BS	B17	nan	1	nan	nan	nan		nan	NEW GUINEA	SALAMAUA	AIRDROME	nan	1	-7.016666667	147.1166667	40		8			4	1000 LB GP (GP-M44/M65)	nan	2	nan	nan	2	nan	nan	11326
9	Sun Aug 15 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	MTO	USA	12 AF	27 FBG/86 FBG	A36	nan	nan	PONTE OLIVO AIRFIELD	SICILY	37.131022	14.321464	39469	ITALY	SCILLA	nan	nan	nan	38.23	15.72							500 LB GP (GP-M43/M64)	nan		nan	nan		nan	nan
10	Sun Aug 15 1943 00:00:00 GMT+0000 (Coordinated Universal Time)	MTO	USA	12 AF	27 FBG/86 FBG	A36	nan	nan	PONTE OLIVO AIRFIELD	SICILY	37.131022	14.321464	16140	ITALY	GIOJA TAURO	nan	ARMAMENT AND ORDNANCE PLANTS	nan	38.43	15.9							500 LB GP (GP-M43/M64)	nan		nan	nan		nan	nan


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,
  "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_tons" DOUBLE,
  "incendiary_devices" DOUBLE,
  "incendiary_devices_type" VARCHAR,
  "incendiary_devices_weight_pounds" DOUBLE,
  "incendiary_devices_weight_tons" DOUBLE,
  "fragmentation_devices" DOUBLE,
  "fragmentation_devices_type" VARCHAR,
  "fragmentation_devices_weight_pounds" DOUBLE,
  "fragmentation_devices_weight_tons" DOUBLE,
  "total_weight_pounds" DOUBLE,
  "total_weight_tons" DOUBLE,
  "time_over_target" VARCHAR,
  "bomb_damage_assessment" VARCHAR,
  "source_id" DOUBLE
);