Deaths--Life Years Lost and Mortality Costs, by Age, Sex, and Cause: 2000 and 2003

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

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 136 rows and 6 columns.

2,403 represents 2,403,000. Life years lost: Number of years person would have lived in absence of death. Mortality cost: value of lifetime earnings lost by persons who die prematurely

Footnotes

1. Based on life expectancy at year of death.
2. Cost estimates based on the person’s age, sex, life expectancy at the
   time of death, labor force participation rates, annual earnings, value
   of homemaking services, and a 3 percent discount rate by which to
   convert to present worth the potential aggregate earnings lost over the
   years.