Intended to provide our own search engines and external engines with highly rich, chapter-representative searchable text on the opening pages of each chapter. Because it is UNCORRECTED material, please consider the following text as a useful but insufficient proxy for the authoritative book pages.
Do not use for reproduction, copying, pasting, or reading; exclusively for search engines.
OCR for page 33
Database Analysis 33 electronically transferred to FMCSA or manually entered by the state agency for MCMIS Crash file inclusion. The MCMIS dataset records are at the vehicle level, as opposed to the accident level. There- fore, if multiple trucks or buses are involved in the same crash, there will be one MCMIS crash record for each truck and bus. The vehicle focus means that there will always be more records than accidents. Information coded into the MCMIS Crash file and obtainable from the PAR includes the date, time, and location of the accident; a description of the vehicle; the name and address of the carrier; personal information, including driver licensure; parameters that describe the roadway at the accident location; and the accident impacts. Because the database contains driver information--name, address, sex, and birth date--the full MCMIS Crash file is publicly available but only after data that can identify individuals have been stripped out. However, since driver information was used in this project for various purposes, the project team signed a con- fidentiality agreement and obtained a version of the file that included the driver fields. 4.1.2 Location and Ownership of Data The MCMIS Registration and Crash files are maintained by FMCSA and available only to authorized governmental users on a routine basis. 4.1.3 Database Format Initially, the MCMIS Crash file contained only one table, but recently it has been divided into the four tables (CRASH_MASTER, CRASH_CARRIER, CRASH_DRIVER, and CRASH_EVENT) shown in Figure 4-1. Figure 4-1. Tabular relationship in MCMIS Crash file.