Engage

T
Logo
T
Logo
T
Logo
T
Logo
F
Logo
T
Logo
T
Logo
F
Logo
T
Logo
T
Logo
T
Logo
T
Logo
T
Logo
T
Logo
F
Logo
T
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
F
Logo
Facebook
2,041,805
Like Us
Twitter
388,709
Follow Us
YouTube Google+ Blog RSS Instagram

Historic airpower database now online

MAXWELL AIR FORCE BASE, Ala. (AFNS) -- More than eight years in the making, a new database containing information from U.S. military and coalition aerial bombing campaigns over the last century is now publicly available online.

An historical data collection project developed and researched by Lt. Col. Jenns Robertson, the Theater History of Operations Reports database, or THOR, has evolved into a full-scale research tool available online at http://afri.au.af.mil/thor/index.asp.

The database combines digitized paper mission reports starting with World War I to create a central source of bombing history around the globe. The database can be searched by date, conflict or even aircraft-specific criteria, and organized into spreadsheets, charts or onto maps, forming a live-action sequence of events.

The THOR database is useful not only for current and future military commanders, Robertson said, but also for academic researchers, historians and government agencies involved in unexploded ordnance cleanup efforts.

"The most exciting part is that I can't envision all the ways this can be used," Robertson said. "This is a data trove that allows us to look over the last 70-100 years of bombing data, how we've conducted wars for the last century using airpower, and if we can't pull lessons out of that, then we're not doing our job."

Currently, the public can access data, including 58 different aircraft, bomb information, and even altitude, from World Wars I and II and Vietnam. The records from World War II and Vietnam are the most complete, he said, and include U.S. and Royal Air Force data, as well as some Australian, New Zealand and South African air force missions.

"We've tried to have all air forces, to make sure that it is an airpower view versus just a (U.S.) Air Force view, so joint, coalition data is our goal," explained Robertson.

Korea, he added, will be included on THOR, but record keeping during that time was done by hand due to changing technology.

"Everything was done free-text, not punch-card text or digitally, so we have to read the reports to pull the context out in order to get the data," he said.

Robertson began the project in 2006 when his military duties required him to create weekly briefings of current bombing activity. Realizing that it was taking longer than necessary to gather information from multiple resources, Robertson wanted to create a centralized source of information for military commanders to use. The need for a single information pool on current missions expanded into Robertson's goal of building an entire airpower collection dating back to World War I. During his off-duty time, Robertson spent the next five years decoding almost four million Vietnam War entries gathered from the National Archives in Washington, D.C.

When he was assigned to the Air Force Research Institute here to work exclusively on THOR, Robertson was able to locate strategic bombing information from WWII and battlefield raid reports from WWI, further adding to the database.

"We're still hunting for some of the data, and I don't know if we'll ever find it. You ask and you hunt and oftentimes we get lucky and find a trove like in the halls of the Air Force Historical Research Agency where I ran across the bombing survey books that had been untouched for 70 years," Robertson said.

Although the THOR website is just now publicly available, the database has already proved helpful, most recently by the Vietnamese government, which is using the Vietnam conflict data to assess post-war bomb and mine contamination in the Southeast Asia region.

"We can show that they have actually been able to save lives and prevent casualties since they originally got the data back in 2010, and the data that we've been able to give them has been even better, so hopefully we'll improve their chances of lowering exposure to explosives," Robertson said. "To be told, and to find out from the folks that are doing the demining in the field, that the data that was sent to them made them more effective. It's an incredible feeling to get that feedback that what you're doing is important."

From the time the Minnesota native arrived at the Air Force Research Institute, he and THOR team members John Conway and computer programmer Billy Barth have been working to get the data online for public use. Robertson said part of the goal of putting THOR on a public website is to have the best and brightest academics and historians fill in the gaps in official documents and correct inaccurate data whenever necessary.

"The professors at the various universities who teach and are writing books and doing research, we want to provide them access to this resource so they can give us the feedback of whether or not we've got it right," Robertson said. "I suspect there are errors still uncovered within the system that I cannot discover because I don't have the knowledge base myself, but, if I put it out there for the experts to examine, we can make it a better resource faster than relying on me working by myself or just a small crowd of us within the (Department of Defense). I look forward to seeing the response and see how we can make the database better for them."
USAF Comments Policy
If you wish to comment, use the text box below. AF reserves the right to modify this policy at any time.

This is a moderated forum. That means all comments will be reviewed before posting. In addition, we expect that participants will treat each other, as well as our agency and our employees, with respect. We will not post comments that contain abusive or vulgar language, spam, hate speech, personal attacks, violate EEO policy, are offensive to other or similar content. We will not post comments that are spam, are clearly "off topic", promote services or products, infringe copyright protected material, or contain any links that don't contribute to the discussion. Comments that make unsupported accusations will also not be posted. The AF and the AF alone will make a determination as to which comments will be posted. Any references to commercial entities, products, services, or other non-governmental organizations or individuals that remain on the site are provided solely for the information of individuals using this page. These references are not intended to reflect the opinion of the AF, DoD, the United States, or its officers or employees concerning the significance, priority, or importance to be given the referenced entity, product, service, or organization. Such references are not an official or personal endorsement of any product, person, or service, and may not be quoted or reproduced for the purpose of stating or implying AF endorsement or approval of any product, person, or service.

Any comments that report criminal activity including: suicidal behaviour or sexual assault will be reported to appropriate authorities including OSI. This forum is not:

  • This forum is not to be used to report criminal activity. If you have information for law enforcement, please contact OSI or your local police agency.
  • Do not submit unsolicited proposals, or other business ideas or inquiries to this forum. This site is not to be used for contracting or commercial business.
  • This forum may not be used for the submission of any claim, demand, informal or formal complaint, or any other form of legal and/or administrative notice or process, or for the exhaustion of any legal and/or administrative remedy.

AF does not guarantee or warrant that any information posted by individuals on this forum is correct, and disclaims any liability for any loss or damage resulting from reliance on any such information. AF may not be able to verify, does not warrant or guarantee, and assumes no liability for anything posted on this website by any other person. AF does not endorse, support or otherwise promote any private or commercial entity or the information, products or services contained on those websites that may be reached through links on our website.

Members of the media are asked to send questions to the public affairs through their normal channels and to refrain from submitting questions here as comments. Reporter questions will not be posted. We recognize that the Web is a 24/7 medium, and your comments are welcome at any time. However, given the need to manage federal resources, moderating and posting of comments will occur during regular business hours Monday through Friday. Comments submitted after hours or on weekends will be read and posted as early as possible; in most cases, this means the next business day.

For the benefit of robust discussion, we ask that comments remain "on-topic." This means that comments will be posted only as it relates to the topic that is being discussed within the blog post. The views expressed on the site by non-federal commentators do not necessarily reflect the official views of the AF or the Federal Government.

To protect your own privacy and the privacy of others, please do not include personally identifiable information, such as name, Social Security number, DoD ID number, OSI Case number, phone numbers or email addresses in the body of your comment. If you do voluntarily include personally identifiable information in your comment, such as your name, that comment may or may not be posted on the page. If your comment is posted, your name will not be redacted or removed. In no circumstances will comments be posted that contain Social Security numbers, DoD ID numbers, OSI case numbers, addresses, email address or phone numbers. The default for the posting of comments is "anonymous", but if you opt not to, any information, including your login name, may be displayed on our site.

Thank you for taking the time to read this comment policy. We encourage your participation in our discussion and look forward to an active exchange of ideas.
comments powered by Disqus