Skip to page content
Secretary of Labor Hilda L. Solis
DOL Home > OPEN > Developer Community > DOL WHD Compliance Dataset

DOL WHD Compliance Dataset

List of Tables

Description

The dataset contains all concluded WHD compliance actions since FY 2008. The dataset includes whether any violations were found and the back wage amount, number of employees due back wages, and civil money penalties assessed. More information and details about the data provided can be found at http://www.dol.gov/whd/

This complete dataset can be found on the DOL Data Enforcement application at http://enforcedata.dol.gov

If you are using this data as part of the DOL informACTION App Challenge, please be aware of this:
From this dataset, make sure your solution presents these elements to the user:

  • Trade Name
  • Address (Address, City, State, Zip)
  • NAIC Description
  • Period of Findings (Findings Date Start, Findings Date End)
  • FLSA Violations Indicator
    1. FLSA Violations
    2. FLSA Repeat Violator
    3. FLSA BW ATP
    4. FLSA EE's ATP
    5. FLSA MW BW ATP
    6. FLSA OT BW ATP
    7. FLSA 15(a)(3) BW ATP
    8. FLSA CMP Assessed
  • Child Labor Findings Indicator
    1. FLSA- CL Violations
    2. FLSA- CL Minors
    3. FLSA- CL CMP Assessed

Frequency

Monthly

Dataset Location

http://api.dol.gov/V1/Compliance/WHD

Dataset Metadata

http://api.dol.gov/V1/Compliance/WHD/$metadata

Dataset Sample

Sample this dataset.


full Table

Column Name

Column Description

Data Type

trade_nm

Employer Name

varchar(75)

street_addr_1_txt

Employer Street Address

varchar(255)

city_nm

City Name

varchar(75)

st_cd

Employer State

varchar(8)

zip_cd

Employer Zip Code

varchar(8)

naic_cd

NAICS Code - Industry Code

varchar(8)

naics_code_description

Industry Code Description

varchar

findings_start_date

The date where WHD determined that findings first occurred. Findings are defined as either a Violation or No Violation found.

date

findings_end_date

The date where WHD determined that findings last occurred. Findings are defined as either a Violation or No Violation found.

date

flsa_violtn_cnt

FLSA Violation Count - Violations found under FLSA (Fair Labor Standards Act)

integer

flsa_repeat_violator

FLSA Repeat/Willful violator. R=Repeat; W=Willful; RW=Repeat and Willful.

varchar

flsa_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act)

decimal(24,2)

flsa_ee_atp_cnt

EE's Agreed to under FLSA (Fair Labor Standards Act)

integer

flsa_mw_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act) Minimum Wages

decimal(24,2)

flsa_ot_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act) Overtime

decimal(24,2)

flsa_15a3_bw_atp_amt

BW Agreed under FLSA (Fair Labor Standards Act) 15 (a)(3)

decimal(24,2)

flsa_cmp_assd_amt

CMP's assessed under FLSA (Fair Labor Standards Act)

decimal(24,2)

flsa_cl_violtn_cnt

Violations found under FLSA - CL (Fair Labor Standards Act - Child Labor)

integer

flsa_cl_minor_cnt

Minors found employed in violation of FLSA - CL (Fair Labor Standards Act - Child Labor)

integer

flsa_cl_cmp_assd_amt

CMP's assessed under FLSA - CL (Fair Labor Standards Act - Child Labor)

deciaml(24,2)
Back to Top   Back to Top

foodService Table

Column Name

Column Description

Data Type

trade_nm

Employer Name

varchar(75)

street_addr_1_txt

Employer Street Address

varchar(255)

city_nm

City Name

varchar(75)

st_cd

Employer State

varchar(8)

zip_cd

Employer Zip Code

varchar(8)

naic_cd

NAICS Code - Industry Code

varchar(8)

naics_code_description

Industry Code Description

varchar

findings_start_date

The date where WHD determined that findings first occurred. Findings are defined as either a Violation or No Violation found.

date

findings_end_date

The date where WHD determined that findings last occurred. Findings are defined as either a Violation or No Violation found.

date

flsa_violtn_cnt

FLSA Violation Count - Violations found under FLSA (Fair Labor Standards Act)

integer

flsa_repeat_violator

FLSA Repeat/Willful violator. R=Repeat; W=Willful; RW=Repeat and Willful.

varchar

flsa_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act)

decimal(24,2)

flsa_ee_atp_cnt

EE's Agreed to under FLSA (Fair Labor Standards Act)

integer

flsa_mw_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act) Minimum Wages

decimal(24,2)

flsa_ot_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act) Overtime

decimal(24,2)

flsa_15a3_bw_atp_amt

BW Agreed under FLSA (Fair Labor Standards Act) 15 (a)(3)

decimal(24,2)

flsa_cmp_assd_amt

CMP's assessed under FLSA (Fair Labor Standards Act)

decimal(24,2)

flsa_cl_violtn_cnt

Violations found under FLSA - CL (Fair Labor Standards Act - Child Labor)

integer

flsa_cl_minor_cnt

Minors found employed in violation of FLSA - CL (Fair Labor Standards Act - Child Labor)

integer

flsa_cl_cmp_assd_amt

CMP's assessed under FLSA - CL (Fair Labor Standards Act - Child Labor)

deciaml(24,2)
Back to Top   Back to Top

hospitality Table

Column Name

Column Description

Data Type

trade_nm

Employer Name

varchar(75)

street_addr_1_txt

Employer Street Address

varchar(255)

city_nm

City Name

varchar(75)

st_cd

Employer State

varchar(8)

zip_cd

Employer Zip Code

varchar(8)

naic_cd

NAICS Code - Industry Code

varchar(8)

naics_code_description

Industry Code Description

varchar

findings_start_date

The date where WHD determined that findings first occurred. Findings are defined as either a Violation or No Violation found.

date

findings_end_date

The date where WHD determined that findings last occurred. Findings are defined as either a Violation or No Violation found.

date

flsa_violtn_cnt

FLSA Violation Count - Violations found under FLSA (Fair Labor Standards Act)

integer

flsa_repeat_violator

FLSA Repeat/Willful violator. R=Repeat; W=Willful; RW=Repeat and Willful.

varchar

flsa_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act)

decimal(24,2)

flsa_ee_atp_cnt

EE's Agreed to under FLSA (Fair Labor Standards Act)

integer

flsa_mw_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act) Minimum Wages

decimal(24,2)

flsa_ot_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act) Overtime

decimal(24,2)

flsa_15a3_bw_atp_amt

BW Agreed under FLSA (Fair Labor Standards Act) 15 (a)(3)

decimal(24,2)

flsa_cmp_assd_amt

CMP's assessed under FLSA (Fair Labor Standards Act)

decimal(24,2)

flsa_cl_violtn_cnt

Violations found under FLSA - CL (Fair Labor Standards Act - Child Labor)

integer

flsa_cl_minor_cnt

Minors found employed in violation of FLSA - CL (Fair Labor Standards Act - Child Labor)

integer

flsa_cl_cmp_assd_amt

CMP's assessed under FLSA - CL (Fair Labor Standards Act - Child Labor)

deciaml(24,2)
Back to Top   Back to Top

retail Table

Column Name

Column Description

Data Type

trade_nm

Employer Name

varchar(75)

street_addr_1_txt

Employer Street Address

varchar(255)

city_nm

City Name

varchar(75)

st_cd

Employer State

varchar(8)

zip_cd

Employer Zip Code

varchar(8)

naic_cd

NAICS Code - Industry Code

varchar(8)

naics_code_description

Industry Code Description

varchar

findings_start_date

The date where WHD determined that findings first occurred. Findings are defined as either a Violation or No Violation found.

date

findings_end_date

The date where WHD determined that findings last occurred. Findings are defined as either a Violation or No Violation found.

date

flsa_violtn_cnt

FLSA Violation Count - Violations found under FLSA (Fair Labor Standards Act)

integer

flsa_repeat_violator

FLSA Repeat/Willful violator. R=Repeat; W=Willful; RW=Repeat and Willful.

varchar

flsa_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act)

decimal(24,2)

flsa_ee_atp_cnt

EE's Agreed to under FLSA (Fair Labor Standards Act)

integer

flsa_mw_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act) Minimum Wages

decimal(24,2)

flsa_ot_bw_atp_amt

BW Agreed to under FLSA (Fair Labor Standards Act) Overtime

decimal(24,2)

flsa_15a3_bw_atp_amt

BW Agreed under FLSA (Fair Labor Standards Act) 15 (a)(3)

decimal(24,2)

flsa_cmp_assd_amt

CMP's assessed under FLSA (Fair Labor Standards Act)

decimal(24,2)

flsa_cl_violtn_cnt

Violations found under FLSA - CL (Fair Labor Standards Act - Child Labor)

integer

flsa_cl_minor_cnt

Minors found employed in violation of FLSA - CL (Fair Labor Standards Act - Child Labor)

integer

flsa_cl_cmp_assd_amt

CMP's assessed under FLSA - CL (Fair Labor Standards Act - Child Labor)

deciaml(24,2)