THOR Full CSV Databases

THOR (WW1) (64 kb ZIP)

Unzipped, it's a 434 kb CSV; and is comprised of 743+ allied records from WWI. The US data in the collection is digitized from the Daily Raid Reports of the 1st Daylight Bomb Group of the American Air Service in World War 1. This includes records from the 96th, 20th, 11th, and 166th Aero Squadrons. These daily records span dates from June to November 1918, and are the most detailed records found to date. British records of the Royal Naval Air Service/Royal Flying Corps/Royal Air Force (RNAS/RFC/RAF) cover the period from 30 June 1916 to November 1918 for the No. 55, 97, 99, 10, 104, 110, 115, 215, and 216 Sqdns. Italian Front data covers the period from 1915 to October 1918, and contains data on Italian and American-piloted bombing missions. The Italian data is drawn largely from official bulletins released during the war, which understandably omit many of the operational details of the Italian missions (exact bomb load, exact number of aircraft, etc are often missing). French data from 1914-1918 is still being researched and is not included at this time. (No idea if they ever added it in)

THOR (WW2) (6.1~ MB ZIP)

Unzipped, it's a 83.5 MB CSV; and is drawn from the newly digitized records of the United States Strategic Bombing Survey and the US Army Air Forces Evaluation Board as well as individual unit records, the 178,000+ WWII records includes the following theaters of war:

European Theater (ETO): RAF and USAAF (8 AF, 9 AF, 15 AF, 1 TAC) Combined Bomber Offensive Sep 1939- May 1945 in Europe. Some strikes lack Numbered Air Force affiliation and unit information is not currently available for the records.

Mediterranean Theater (MTO): RAF 1940-1945 (partial records; known gaps Jan-Aug 1942, partial data 1942-1945 - exact aircraft numbers and bomb loads missing from some entries); USAAF (9 AF, 12 AF, 15 AF) June 1942- May 1945. It is believed that the records in THOR constitute of only a fraction of the RAF contributions in the war effort in this theater, and that more records are needed.

Pacific Theater (PTO): USAAF Dec 1941-Aug 1945 (5 AF, 7 AF, 11 AF, 13 AF, 14 AF , 20 AF); RAAF Dec 1941-Dec 1942; RNZAF Oct 1943-Aug 1945. It is believed that the records in THOR constitute of only a fraction of the RAAF and RNZAF contributions in the war effort in this theater, and that more records are needed. 11 AF Kiska and ATTU islands data complete from 1943-1945. Additional data on attacks on these islands in 1942 is being reviewed for completeness. US Navy and Marine Corps aircraft data is only available at monthly summary resolution.

China-Burma-India (CBI): USAAF Dec 1941-Aug 1945 (10 AF, 14 AF, 20 AF); RAF data 1942-1944 has significant gaps in coverage. It is believed that the records in THOR constitute of only a fraction of the RAF contributions in the war effort in this theater, and that more records are needed.

THOR (VIETNAM) (446.6 MB ZIP)

This is the huge one. It unzips to a 2.6~ GB CSV file (!!!). Per the THOR FAQ, this dataset is missing data prior to September 1965, and also the month of November 1967 is missing (due to water damage to its magnetic tape archive). The data here represents 4.3+ million airpower records from three Vietnam-era Joint Chiefs of Staff databases:

Combat Activities File (CACTA) 1965-1970
Southeast Asia Database (SEADAB) 1970-1975
Strategic Air Command Activities Database (SACCOACT) 1965-1975

THOR “Grab and Go” KML Files

Data that the THOR team set up for use in Google Earth (.kml files).

WWI – Western Front (51 kb)
WWI – Italian Front (23 kb)

WWII – European/Mediterranean Theaters (2.1 MB)
    WWII – European/Mediterranean Theaters USAAF Only (535~ kb)
    WWII – European/Mediterranean Theaters RAF Only (1.1 MB)
WWII – Pacific/CBI Theaters (1.5 MB)

Vietnam – 1965 (692 kb)
Vietnam – Jan - Mar 1966 (3.9 MB)
Vietnam – Apr - Jun 1966 (9.7 MB)
Vietnam – Jul - Sept 1966 (5.7 MB)
Vietnam – Oct - Dec 1966 (5.8 MB)
Vietnam – Jan - Mar 1967 (3.9 MB)
Vietnam – Apr - Jun 1967 (9.7 MB)