About this Dataset

Louisville Metro KY - OSHA Data (Historical)

** The data set is no longer being updated.

The Office of Performance Improvement strives to provide Metro Government and its partners with customized improvement support to create a world-class city.

Data Dictionary:

DEPT - The name of the department where the OSHA incident occurred
BIWEEKLY_PAY_PERIOD_END_DATE - The end date for the pay period when the OSHA incident occurred
LTI - YES if the OSHA incident lead to missed days or NO if not
DART - YES if the OSHA incident lead to missed days or restricted work time or NO if not
DESCRIPTION - The type of OSHA incident that occurred
Number_Of_Incidents - The number of OSHA incidents that occurred for the given department and pay period
HOURS_YOY - The total number of hours that were worked during the last 26 pay periods for the given department and pay period end date
LTI_YOY - The total number of OSHA incidents which lead to missed days that occurred during the last 26 pay periods for the given department and pay period end date
DART_YOY - The total number of OSHA incidents which lead to missed days or restricted work time that occurred during the last 26 pay periods for the given department and pay period end date
OSHA_YOY - The total number of OSHA incidents that occurred during the last 26 pay periods for the given department and pay period end date
LTI_Rate - The total number of OSHA incidents which lead to missed days that occurred during the last 26 pay periods for the given department and pay period end date (DEPT_LTI_YOY) times 200,000 divided by the total number of hours that were worked during the last 26 pay periods for the given department and pay period end date (DEPT_HOURS_YOY) (Formula provided by OSHA - Occupational Safety and Health Administration)
DART_Rate - The total number of OSHA incidents which lead to missed days or restricted work time that occurred during the last 26 pay periods for the given department and pay period end date (DEPT_DART_YOY) times 200,000 divided by the total number of hours that were worked during the last 26 pay periods for the given department and pay period end date (DEPT_HOURS_YOY) (Formula provided by OSHA - Occupational Safety and Health Administration)
OSHA_Rate - The total number of OSHA incidents that occurred during the last 26 pay periods for the given department and pay period end date (DEPT_OSHA_YOY) times 200,000 divided by the total number of hours that were worked during the last 26 pay periods for the given department and pay period end date (DEPT_HOURS_YOY) (Formula provided by OSHA - Occupational Safety and Health Administration)
Organization: Louisville Metro Government
Last updated: 2025-07-30T13:23:46.084009
Tags: historical, human-resources, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, office-of-performance-improvement, opi, osha

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_osha_data_20537.table_1

115.3 kB
2,854 rows
15 columns

CREATE TABLE table_1 (
  "incident_yr" BIGINT,
  "incident_mo" BIGINT,
  "deptid" BIGINT,
  "hours_by_dept" DOUBLE,
  "lti_by_deptid" BIGINT,
  "dart_by_deptid" BIGINT,
  "osha_by_deptid" BIGINT,
  "worked_last_12mo" DOUBLE,
  "lti_last_12mo" BIGINT,
  "dart_last_12mo" BIGINT,
  "osha_last_12mo" BIGINT,
  "lti_rate" DOUBLE,
  "dart_rate" DOUBLE,
  "osha_rate" DOUBLE,
  "objectid" BIGINT
);