Each zip file contains a ‘flat’ comma delimited data file and a ‘Readme’ file that describes the data file. This includes an identifier linking the violation to the inspection in which it was cited, the violation code, violation description, and information related to the SMS methodology.
The violation file contains details on each violation that was used in SMS calculations. It also includes information about the relationship of each inspection to SMS BASIC information, and violation counts by BASIC. DOT#, Report Number, Inspection Date, State, and Vehicle Information. The inspection file contains identifying information for the inspection such as the U.S. The two files available for download contain the publicly available inspection and violation data used for the current month’s SMS calculations. In a relational database, a key can be assigned to each table and linked together by that key.ĭOWNLOAD MOTOR CARRIER INSPECTION INFORMATION | Top
If the key from a record in one table matches the key from a record in another, the records are part of the inspection. To relate the records between each table, each has a common and consistent field: a key. It is assumed that users are familiar with importing a delimited flat file and setting up the structure following the record layouts.Įach of the 8 tables in the Inspection File has its own distinct layout. Carrier information in the "carrier" table may not match the carrier information contained in the FMCSA Census file.įor the Inspection File, the user must understand the concept of normalization and must be familiar with using the database application they have available. Violations of the Federal Motor Carrier Safety Regulations severe enough may result in a vehicle and/or driver being placed "out-of-service." The data collected from inspection activity is collected and stored in the FMCSA Motor Carrier Management Information System (MCMIS) Inspection Data Files.ĭue to privacy restrictions, driver information is not included in any inspection files released to the public. The majority of the inspections were conducted at the roadside by State personnel under the Motor Carrier Safety Assistance Program (MCSAP).įederal and State field enforcement staff performs Inspections on Interstate and Intrastate Motor Carriers and Shippers and Transporters of Hazardous Materials. The FMCSA Inspection File contains data from State and Federal inspection actions involving Motor Carriers, Shippers of Hazardous Materials, and Transporters of Hazardous Materials operating in the U.S. Department of Transportation (USDOT) responsible for monitoring and developing safety standards for commercial motor vehicles operating in interstate commerce. The Federal Motor Carrier Safety Administration (FMCSA) is the agency of the U.S.
0 kommentar(er)
