DBEA55AED16C0C92252A6554BC1553B2 Clicky DBEA55AED16C0C92252A6554BC1553B2 Clicky
October 30, 2024
Care to share?

The US DoT has a plethora of data sets, and as we model more of them, it becomes clear that these databases offering tremendous insight into the market.  The sheer size of the datasets has been a hurdle for most people to get at the information they contain.

The DB1B (as the Airline Origin and Destination Survey is known) consists of three different datasets.  The one we will share with you here is the DB1B Market.  DoT defines it this way: “This table contains directional market characteristics of each domestic itinerary of the Origin and Destination Survey, such as the reporting carrier, origin and destination airport, prorated market fare, number of market coupons, market miles flown, and carrier change indicators.”

Suffice to say the model below that summarizes data from 1Q16 through 3Q19 is large.  But the joy is that there is so much to glean from the data.   The first page of the model is a summary with no selection criteria. But the other pages offer this ability to select by airline, allowing the reader to delve into great detail about the market from that airline’s perspective.  If you are into this sort of thing, you are likely to get lost here for hours.

author avatar
Addison Schonland
Co-Founder AirInsight. My previous life includes stints at Shell South Africa, CIC Research, and PA Consulting. Got bitten by the aviation bug and ended up an Avgeek. Then the data bug got me, making me a curious Avgeek seeking data-driven logic. Also, I appreciate conversations with smart people from whom I learn so much. Summary: I am very fortunate to work with and converse with great people.

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.