Transportation Accidents, Deaths, and Injuries, by Mode of Transportation: 1970 to 2005 (Statistical Abstract 2008 Table 1040)

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.

Notes (pg 2)

1. Data on deaths are from U.S. National Highway Traffic Safety
   Administration and are based on deaths within 30 days of the accident.
   Includes only police reported crashes. For more details, see Table 1079.
2. Accidents which result in damages to railroad property.
   Grade crossing accidents are also included when classified as a train
   accident. Deaths exclude fatalities in railroad-highway grade crossing
   accidents.
3. Reporting criteria and source of data changed between 1989 and
   1990; these data from 1990 to present are not comparable to earlier
   years.
4. See footnote 1, Table 1045.
   Injuries classified as serious.

1. See footnote 2, Table 1045. Injuries classified as serious.

1. See footnote 3, Table 1045. Injuries classified as serious.

1. Accidents resulting in death, injury, or requiring medical treatment
   beyond first aid; damages exceeding $500; or a person’s disapperance.
2. Covers accidents involving commercial vessels which must be
   reported to U.S. Coast Guard if there is property damage exceeding
   $25,000; material damage affecting the seaworthiness or efficiency of a
   vessel; stranding or grounding; loss of life; or injury causing
   a person’s incapacity for more than 3 days.
3. Beginning 1990, pipeline accidents/incidents are credited to year of occurrence;
   prior data are credited to the year filed.
4. Other transit includes bus, light rail, commuter rail, demand response, van pool,
   and automated guideway. Excludes cable car, inclined plane, jitney, and ferry boat.
5. Incidents, deaths, and injuries involving hazardous materials cover all types
   of transport.exclude pipelines and bulk, nonpackaged water incidents.

[6,216 represents 6,216,000]

table: [43, 31]

Notes (pg 2)

• (NA) Not available. Z Less than 50.

1040

2008