Calendar Year 2007 Establishment Specific Injury and Illness Rates.

Each year the Occupational Safety and Health Administration (OSHA) collects work-related injury and illness data from employers within specific industry and employment size specifications. This data collection is called the OSHA Data Initiative or ODI. The data provided is used by OSHA to calculate establishment specific injury and illness incidence rates. The file below contains a table with the name, address, industry, and associated Total Case Rate (TCR), Days Away, Restricted, and Transfer (DART) case rate, and the Days Away From Work (DAFWII) case rate for the establishments that provided OSHA with valid data through the 2008 data collection (collection of CY 2007 data). This database does not contain rates calculated by OSHA for establishments that submitted suspect or unreliable data.

Explanatory Notes

Scope of the data: For each data collection cycle, OSHA only collects data from a small portion of all private sector establishments in the United States (80,000 out of 7.5 million total establishments). Therefore, these data are not representative of all businesses and general conclusions pertaining to all US business should not be drawn.
Data quality: While OSHA takes multiple steps to ensure the data collected is accurate, problems and errors invariably exist for a small percentage of establishments. OSHA does not believe the data for the establishments with the highest rates on this file are accurate in absolute terms. Efforts were made during the collection cycle to correct submission errors, however some remain unresolved. It would be a mistake to say establishments with the highest rates on this file are the “most dangerous” or “worst” establishments in the Nation.
Rate Calculation: An incidence rate of injuries and illnesses is computed from the following formula: (Number of injuries and illnesses X 200,000) / Employee hours worked = Incidence rate. The TCR includes all cases recorded on the OSHA Form 300 (Column G + Column H + Column I + Column J). The Dart includes cases recorded in Column H + Column I. The DAFWII includes cases recorded in Column H.
State Participation: The following states did not participate in the 2008 ODI, establishment data is not available for these states: Alaska; Arizona; Oregon; South Carolina; Virginia; Washington; Wyoming.
The State of Minnesota has informed OSHA that disclosure of the most current data would have an adverse effect on its enforcement proceedings because of the way its enforcement targeting lists are prepared and administered. We are withholding the Minnesota data because it meets the criteria of Exemption 7(A) of the Freedom of Information Act.

Download this file

ODI2007.zip

The file is provided in Compressed Format in order to decrease download time. The compressed file is provided in plain .ZIP Archive format. In order to decompress the .ZIP file, you must have a ZIP Utility, such as PKZip® or WINZip®. If you do not have a Zip utility on your workstation, please contact your local network support group, or your internet service provider.

Viewing this file

You may use virtually any spreadsheet or database program to load this file. Simply select "Text" or ".txt" as the type when loading the file into your application.

Depending upon your application, you may need to install an additional .txt file import filter - check with the software vendor if you have any questions.

Here are a few examples of the more common applications you can use:

Lotus Approach Database or 1-2-3 Spreadsheet
Microsoft Access Database or Excel Spreadsheet
WordPerfect Paradox or Quattro Pro Databases
IBM dBASE III or any other compatible RDBMS application which can import "dBASE" files, such as Informix, Oracle, Unify, etc.