The crash file export is created from the Crash Database as maintained within
the Ohio Integrated Traffic Records System at the Ohio Department of Public
Safety. The export documentation provides a detailed listing of each of the
major data tables: CRASHES, UNITS and PEOPLE, as well as the codes found within
those tables. It also contains information on the standard export format for
those tables. The crash file export consists of three flat files: CRASHES,
UNITS and PEOPLE.
The CRASHES table is the primary data table within the ORACLE database, and there is one unique record in the CRASHES table for each traffic crash that is entered into the system. Each crash is identifiable by a unique DOCNO. When exported, the CRASHES table will yield about 350,000 to 400,000 records per year if the entire state is exported.
The UNITS table contains one record for each unit (motorist, non-motorist, including pedestrian) that is involved in a traffic crash. In a normal year there will be about 700,000 entries in this table. Records within this table are joined with their associated CRASHES record through the common key of DOCNO.
The PEOPLE table contains one record for each person that is involved in a traffic crash, except in some cases of hit/skip crashes where the information is not available. In a normal year there will be about 900,000 entries in this table. The DOCNO-UNITNO fields can be used to join PEOPLE data with their associated UNITS record. The DOCNO field in the PEOPLE table can be used to join with the associated CRASHES record.