The Statistical Abstract files are distributed by the US Census Department as Microsoft Excel files. These files have data mixed with notes and references, multiple tables per sheet, and, worst of all, the table headers are not easily matched to their rows and columns.

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.

The tables that were changed (this is table 1007):

0166 0257 0362 0429 0445 0446 0459 0461 0462 0464 0465 0466 0467
0469 0479 0480 0481 0482 0483 0484 0485 0486 0487 0559 0628 0629
1144 1227 1231

This dataset consists of a table of 40 rows and 10 columns.

In billions of dollars (134.4 represents $134,400,000,000)

Footnotes

1. Preliminary.
2. Estimate.
3. Based on Aerospace Industry Association’s aerospace composite price deflator.
4. All civil sales of aircraft (domestic and export sales of jet
   transports, commuters, business, and personal aircraft and helicopters).
5. Electronics, software, and ground support equipment, plus sales of
   non-aerospace products which are produced by aerospace-manufacturing
   use technology, processes, and materials derived from aerospace
   products.
6. Department of Defense.
7. National Aeronautics and Space Administration.
8. Includes civil aircraft sales (see footnote 4), commercial space
   sales, all exports of military aircraft and missiles and
   related propulsion and parts.
9. Preliminary.
10. Estimate.
11. Based on Aerospace Industry Association’s aerospace composite price deflator.
12. All civil sales of aircraft (domestic and export sales of jet
    transports, commuters, business, and personal aircraft and helicopters).
13. Electronics, software, and ground support equipment, plus sales of
    non-aerospace products which are produced by aerospace-manufacturing
    use technology, processes, and materials derived from aerospace
    products.
14. Department of Defense.
15. National Aeronautics and Space Administration.
16. Includes civil aircraft sales (see footnote 4), commercial space
    sales, all exports of military aircraft and missiles and
    related propulsion and parts.

Application Gallery