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 494):

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 58 rows and 5 columns.

(In millions of dollars ($141,018 represents $141,018,000,000); For year ending September 30. Payroll outlays include the gross earnings of civilian and active duty military personnel for services rendered to the government and for cash allowances for benefits. Excludes employer’s share of employee benefits, accrued military retirement benefits and most permanent change of station costs. Contracts, refer to awards made in year specified; expenditures relating to awards may extend over several years. Military awards for supplies, services, and construction. Net value of contracts of over $25,000 for work in each state and DC. Figures reflect impact of prime contracting on state distribution of defense work. Often the State in which a prime contractor is located in is not the state where the subcontracted. work is done. Undistributed civilians and military personnel, their payrolls, and prime contract awards for performance in classified locations are excluded

Application Gallery