On-Time Flight Arrivals and Departures at Major U.S. Airports: 2006 (Statistical Abstract 2008 Table 1047)

The Statistical Abstract files are distributed by the census department as excel files. These files have data mixed with notes and references, multiple tables per sheet, and worst of all the table headers aren’t easily matched to their rows and columns.
The excel files in this collection are unmolested copies of the census originals, with the following exceptions:

1. A few files had extraneous characters in the title. These were
   corrected to be consistent. A few files have a sheet of crufty
   gibberish in the first slot. The sheet order was shuffled but no
   data were changed.

1. The first four files have been restructured to allow full
   comprehension of the table. If you’d like to help clean up the data
   follow along with what’s there.

The CSV files, and the payload portions of the yaml files, have not been processed beyond extracting an array (excel sheets) of 2-D arrays (each sheet’s cells).

Some metadata (title, footnotes, symbols, and sources) has been copied (without molesting the imported stream) into the appropriate slot in this schema. This metadata identification was purposefully done to be strict and simple, and the original files are somewhat irregular, so it’s possible that some metadata fields were missed

These files have been tagged by hand and received cursory inspection, but you’re advised to check against the originals before you go lauching any Mars rovers.

[In percent. Quarterly, based on gate arrival and departure times
for domestic scheduled operations of U.S. major airlines.
All U.S. airlines with 1 percent or more of total U.S.
domestic scheduled airline passenger revenues are required to
report on-time data. A flight is considered on time if it operated
less than 15 minutes after the scheduled time shown in the
carrier’s computerized reservation system.
See source for data on individual
airlines]

table: [51, 9]

1047

2008