Click Back Arrow When Done.

table_namecolumn_nameattribute_namedefinitioncolumn_datatypedisplay_name
whd_whisardh2b_violtn_cntH2B Violation CountViolations found under H2B (Work Visa - Temporary Non-Agricultural Work)NumericH2B Violations
whd_whisardh2b_bw_atp_amtH2B BW ATP AmountBW Agreed to under H2B (Work Visa - Temporary Non-Agricultural Work)NumericH2B BW ATP
whd_whisardh2b_ee_atp_cntH2B EE ATP CountEE's Agreed to under H2B (Work Visa - Temporary Non-Agricultural Work)NumericH2B EE ATP
whd_whisardsraw_violtn_cntSRAW Violation CountViolations found under SRAW (Spec. Agri. Workers/Replenishment Agri. Workers)NumericSRAW Violations
whd_whisardsraw_bw_atp_amtSRAW BW ATP AmountBW Agreed to under SRAW (Spec. Agri. Workers/Replenishment Agri. Workers)NumericSRAW BW ATP
whd_whisardsraw_ee_atp_cntSRAW EE ATP CountEE's Agreed to under SRAW (Spec. Agri. Workers/Replenishment Agri. Workers)NumericSRAW EE ATP
whd_whisardld_dtLoad Date TimestampLoad Date TimestampDateNo Label
whd_whisardfindings_start_dateFindings Start DateThe date where WHD determined that findings first occurred. Findings are defined as either a Violation or No Violation found.
NOTE: Findings Start Date is not equal to Case Open Date which is not included in the dataset.
DateFindings Start Date
whd_whisardfindings_end_dateFindings End DateThe date where WHD determined that findings last occurred. Findings are defined as either a Violation or No Violation found.
NOTE: Findings End Date is not equal to Case Close Date which is not included in the dataset.
DateFindings End Date
whd_whisardcase_idCase IDUnique Case IdentifierNumericCase ID
whd_whisardtrade_nmTrade NameEmployer NameCharTrade Name
whd_whisardlegal_nameLegal NameEmployer Legal Name.CharEmployer Legal Name
whd_whisardstreet_addr_1_txtEmployer Street AddressThe street addressCharAddress
whd_whisardcty_nmCity NameEmployer CityCharCity
whd_whisardst_cdState CodeEmployer StateCharState
whd_whisardzip_cdZip CodeEmployer Zip CodeCharZip Code
whd_whisardnaic_cdNAICS CodeIndustry CodeCharNAICS
whd_whisardnaics_code_descriptionNAICS Code Description.Industry Code Description.CharIndustry Code Description
whd_whisardcase_violtn_cntCase Violation CountTotal Case ViolationsNumericCase Violation
whd_whisardcmp_assd_cntTotal CMP AssessmentsTotal CMP (Civil Monetary Penalties) assessmentsNumericCMP Assessed
whd_whisardee_violtd_cntEE's in ViolationTotal EE's employed in ViolationNumericEEs Employed in Violation
whd_whisardbw_atp_amtBW ATP AmountTotal Backwages Agreed To PayNumericBW ATP
whd_whisardee_atp_cntEE ATP AmountTotal Employees Agreed toNumericEE ATP Amount
whd_whisardflsa_violtn_cntFLSA Violation CountViolations found under FLSA (Fair Labor Standards Act)NumericFLSA Violations
whd_whisardflsa_repeat_violatorFLSA Repeat ViolatorFLSA Repeat/Willful violator. R=Repeat; W=Willful; RW=Repeat and Willful.CharFLSA Repeat Violator
whd_whisardflsa_bw_atp_amtFLSA BW ATP AmountBW Agreed to under FLSA (Fair Labor Standards Act)NumericFLSA BW ATP
whd_whisardflsa_ee_atp_cntFLSA EE ATP CountEE's Agreed to under FLSA (Fair Labor Standards Act)NumericFLSA EE ATP
whd_whisardflsa_mw_bw_atp_amtFLSA MW BW ATP AmountBW Agreed to under FLSA (Fair Labor Standards Act) Minimum WagesNumericFLSA MW BW ATP
whd_whisardflsa_ot_bw_atp_amtFLSA OT BW ATP AmountBW Agreed to under FLSA (Fair Labor Standards Act) OvertimeNumericFLSA OT BW ATP
whd_whisardflsa_15a3_bw_atp_amtFLSA 15a3 BW ATP AmountBW Agreed under FLSA (Fair Labor Standards Act) 15 (a)(3)NumericFLSA 15(a)(3) BW ATP
whd_whisardflsa_cmp_assd_amtFLSA CMP Assessed AmountCMP's assessed under FLSA (Fair Labor Standards Act)NumericFLSA CMP Assessed
whd_whisardsca_violtn_cntSCA Violation CountViolations found under SCA (Service Contract Act)NumericSCA Violations
whd_whisardsca_bw_atp_amtSCA BW ATP AmountBW Agreed to under SCA (Service Contract Act)NumericSCA BW ATP
whd_whisardsca_ee_atp_cntSCA EE ATP CountEE's Agreed to under SCA (Service Contract Act)NumericSCA EE ATP
whd_whisardmspa_violtn_cntMSPA Violation CountViolations found under MSPA (Migrant and Seasonal Agricultural Worker Protection Act)NumericMSPA Violations
whd_whisardmspa_bw_atp_amtMSPA BW ATP AmountBW Agreed to under MSPA (Migrant and Seasonal Agricultural Worker Protection Act)NumericMSPA BW ATP
whd_whisardmspa_ee_atp_cntMSPA EE ATP CountEE's Agreed to under MSPA (Migrant and Seasonal Agricultural Worker Protection Act)NumericMSPA EE ATP
whd_whisardmspa_cmp_assd_amtMSPA CMP Assessed AmountCMP's assessed under MSPA (Migrant and Seasonal Agricultural Worker Protection Act)NumericMSPA CMP Assessed
whd_whisardh1b_violtn_cntH1B Violation CountViolations found under H1B (Work Visa - Speciality Occupations)NumericH1B Violations
whd_whisardh1b_bw_atp_amtH1B BW ATP AmountBW Agreed to under H1B (Work Visa - Speciality Occupations)NumericH1B BW ATP
whd_whisardh1b_ee_atp_cntH1B EE ATP CountEE's Agreed to under H1B (Work Visa - Speciality Occupations)NumericH1B EE ATP
whd_whisardh1b_cmp_assd_amtH1B CMP Assessed AmountCMP's assessed under H1B (Work Visa - Speciality Occupations)NumericH1B CMP Assessed
whd_whisardfmla_violtn_cntFMLA Violation CountViolations found under FMLA (Family and Medical Leave Act)NumericFMLA Violations
whd_whisardfmla_bw_atp_amtFMLA BW ATP AmountBW Agreed to under FMLA (Family and Medical Leave Act)NumericFMLA BW ATP
whd_whisardfmla_ee_atp_cntFMLA EE ATP CountEE's Agreed to under FMLA (Family and Medical Leave Act)NumericFMLA EE ATP
whd_whisardfmla_cmp_assd_amtFMLA CMP Assessed AmountCMP's assessed under FMLA (Family and Medical Leave Act)NumericFMLA CMP Assessed
whd_whisardflsa_cl_violtn_cntFLSA CL Violation CountViolations found under FLSA - CL (Fair Labor Standards Act - Child Labor)NumericFLSA CL Violations
whd_whisardflsa_cl_minor_cntFLSA CL Minor CountMinors found employed in violation of FLSA - CL (Fair Labor Standards Act - Child Labor)NumericFLSA CL Minors
whd_whisardflsa_cl_cmp_assd_amtFLSA CL CMP Assessed AmountCMP's assessed under FLSA - CL (Fair Labor Standards Act - Child Labor)NumericFLSA CL CMP Assessed
whd_whisarddbra_cl_violtn_cntDBRA Violation CountViolations found under DBRA (Davis-Bacon and Related Act)NumericDBRA Violations
whd_whisarddbra_bw_atp_amtDBRA BW ATP AmountBW Agreed to under DBRA (Davis-Bacon and Related Act)NumericDBRA BW ATP
whd_whisarddbra_ee_atp_cntDBRA EE ATP CountEE's Agreed to under DBRA (Davis-Bacon and Related Act)NumericDBRA EE ATP
whd_whisardh2a_violtn_cntH2A Violation CountViolations found under H2A (Work Visa - Seasonal Agricultural Workers)NumericH2A Violations
whd_whisardh2a_bw_atp_amtH2A BW ATP AmountBW Agreed to under H2A (Work Visa - Seasonal Agricultural Workers)NumericH2A BW ATP
whd_whisardh2a_ee_atp_cntH2A EE ATP CountEE's Agreed to under H2A (Work Visa - Seasonal Agricultural Workers)NumericH2A EE ATP
whd_whisardh2a_cmp_assd_amtH2A CMP Assessed AmountCMP's assessed under H2A (Work Visa - Seasonal Agricultural Workers)NumericH2A CMP Assessed
whd_whisardflsa_smw14_violtn_cntFLSA SMW14 Violation CountViolations found under FLSA - SMW14 (Fair Labor Standards Act - Special Minimum Wages under Section 14(c))NumericFLSA SMW14 Violations
whd_whisardflsa_smw14_bw_amtFLSA SMW14 BW ATP AmountBW Agreed to under FLSA - SMW14 (Fair Labor Standards Act - Special Minimum Wages under Section 14(c))NumericFLSA SMW14 BW ATP
whd_whisardflsa_smw14_ee_atp_cntFLSA SMW14 EE ATP CountEE's Agreed to under FLSA - SMW14 (Fair Labor Standards Act - Special Minimum Wages under Section 14(c))NumericFLSA SMW14 EE ATP
whd_whisardcwhssa_violtn_cntCWHSSA Violation CountViolations found under CWHSSA (Contract Work Hours and Safety Standards Act)NumericCWHSSA Violations
whd_whisardcwhssa_bw_amtCWHSSA BW ATP AmountBW Agreed to under CWHSSA (Contract Work Hours and Safety Standards Act)NumericCWHSSA BW ATP
whd_whisardcwhssa_ee_cntCWHSSA EE ATP CountEE's Agreed to under CWHSSA (Contract Work Hours and Safety Standards Act)NumericCWHSSA EE ATP
whd_whisardosha_violtn_cntOSHA Violation CountViolations found under OSHA (Occupational Safety and Health Standards)NumericOSHA Violations
whd_whisardosha_bw_atp_amtOSHA BW ATP AmountBW Agreed to under OSHA (Occupational Safety and Health Standards)NumericOSHA BW ATP
whd_whisardosha_ee_atp_cntOSHA EE ATP CountEE's Agreed to under OSHA (Occupational Safety and Health Standards)NumericOSHA EE ATP
whd_whisardosha_cmp_assd_amtOSHA CMP Assessed AmountCMP's assessed under OSHA (Occupational Safety and Health Standards)NumericOSHA CMP Assessed
whd_whisardeppa_violtn_cntEPPA Violation CountViolations found under EPPA (Employee Polygraph Protection Act)NumericEPPA Violations
whd_whisardeppa_bw_atp_amtEPPA BW ATP AmountBW Agreed to under EPPA (Employee Polygraph Protection Act)NumericEPPA BW ATP
whd_whisardeppa_ee_cntEPPA EE ATP CountEE's Agreed to under EPPA (Employee Polygraph Protection Act)NumericEPPA EE ATP
whd_whisardeppa_cmp_assd_amtEPPA CMP Assessed AmountCMP's assessed under EPPA (Employee Polygraph Protection Act)NumericEPPA CMP Assessed
whd_whisardh1a_violtn_cntH1A Violation CountViolations found under H1A (Work Visa - Registered nurses for temporary employment)NumericH1A Violations
whd_whisardh1a_bw_atp_amtH1A BW ATP AmountBW Agreed to under H1A (Work Visa - Registered nurses for temporary employment)NumericH1A BW ATP
whd_whisardh1a_ee_atp_cntH1A EE ATP CountEE's Agreed to under H1A (Work Visa - Registered nurses for temporary employment)NumericH1A EE ATP
whd_whisardh1a_cmp_assd_amtH1A CMP Assessed AmountCMP's assessed under H1A (Work Visa - Registered nurses for temporary employment)NumericH1A CMP Assessed
whd_whisardcrew_violtn_cntCREW Violation CountViolations found under CREW (Longshoremen (D1))NumericCREW Violations
whd_whisardcrew_bw_atp_amtCREW BW ATP AmountBW Agreed to under CREW (Longshoremen (D1))NumericCREW BW ATP
whd_whisardcrew_ee_atp_cntCREW EE ATP CountEE's Agreed to under CREW (Longshoremen (D1))NumericCREW EE ATP
whd_whisardcrew_cmp_assd_amtCREW CMP AssessedCMP's assessed under CREW (Longshoremen (D1))NumericCREW CMP Assessed
whd_whisardccpa_violtn_cntCCPA Violation CountViolations found under CCPA (Consumer Credit Protection Act - Wage Garnishment)NumericCCPA Violations
whd_whisardccpa_bw_atp_amtCCPA BW ATP AmountBW Agreed to under CCPA (Consumer Credit Protection Act - Wage Garnishment)NumericCCPA BW ATP
whd_whisardccpa_ee_atp_cntCCPA EE ATP CountEE's Agreed to under CCPA (Consumer Credit Protection Act - Wage Garnishment)NumericCCPA EE ATP
whd_whisardflsa_smwpw_violtn_cntFLSA SMWPW Violation CountViolations found under FLSA - SMWPW (Fair Labor Standards Act - Special Minimum Wages - Patient worker)NumericFLSA SMWPW Violations
whd_whisardflsa_smwpw_bw_atp_amtFLSA SMWPW BW ATP AmountBW Agreed to under FLSA - SMWPW (Fair Labor Standards Act - Special Minimum Wages - Patient worker)NumericFLSA SMWPW BW ATP
whd_whisardflsa_smwpw_ee_atp_cntFLSA SMWPW EE ATP CountEE's Agreed to under FLSA - SMWPW (Fair Labor Standards Act - Special Minimum Wages - Patient worker)NumericFLSA SMWPW EE ATP
whd_whisardflsa_hmwkr_violtn_cntFLSA HMWKR Violation CountViolations found under FLSA - HMWKR (Fair Labor Standards Act - industrial homework)NumericFLSA HMWKR Violations
whd_whisardflsa_hmwkr_bw_atp_amtFLSA HMWKR BW ATP AmountBW Agreed to under FLSA - HMWKR (Fair Labor Standards Act - industrial homework)NumericFLSA HMWKR BW ATP
whd_whisardflsa_hmwkr_ee_atp_cntFLSA HMWKR EE ATP CountEE's Agreed to under FLSA - HMWKR (Fair Labor Standards Act - industrial homework)NumericFLSA HMWKR EE ATP
whd_whisardflsa_hmwkr_cmp_assd_amtFLSA HMWKR CMP Assessed AmountCMP's assessed under FLSA - HMWKR (Fair Labor Standards Act - industrial homework)NumericFLSA HMWKR CMP Assessed
whd_whisardca_violtn_cntCA Violation CountViolations found under CA (Copeland Anti-kickbact Act)NumericCA Violations
whd_whisardca_bw_atp_amtCA BW ATP AmountBack Wages Agreed to under CA (Copeland Anti-kickbact Act)NumericCA BW ATP
whd_whisardca_ee_atp_cntCA EE ATP CountEE's Agreed to under CA (Copeland Anti-kickbact Act)NumericCA EE ATP
whd_whisardpca_violtn_cntPCA Violation CountViolations found under PCA (Public Contracts Act)NumericPCA Violations
whd_whisardpca_bw_atp_amtPCA BW ATP AmountBW Agreed to under PCA (Public Contracts Act)NumericPCA BW ATP
whd_whisardpca_ee_atp_cntPCA EE ATP CountEE's Agreed to under PCA (Public Contracts Act)NumericPCA EE ATP
whd_whisardflsa_smwap_violtn_cntFLSA SMWAP Violation CountViolations found under FLSA - SMWAP (Fair Labor Standards Act - Special Minimum Wages - Apprentices)NumericFLSA SMWAP Violations
whd_whisardflsa_smwap_bw_atp_amtFLSA SMWAP BW ATP AmountBW Agreed to under FLSA - SMWAP (Fair Labor Standards Act - Special Minimum Wages - Apprentices)NumericFLSA SMWAP BW ATP
whd_whisardflsa_smwap_ee_atp_cntFLSA SMWAP EE ATP CountEE's Agreed to under FLSA - SMWAP (Fair Labor Standards Act - Special Minimum Wages - Apprentices)NumericFLSA SMWAP EE ATP
whd_whisardflsa_smwft_violtn_cntFLSA SMWFT Violation CountViolations found under FLSA - SMWFT (Fair Labor Standards Act - Special Minimum Wages - Full Time)NumericFLSA SMWFT Violations
whd_whisardflsa_smwft_bw_atp_amtFLSA SMWFT BW ATP AmountBW Agreed to under FLSA - SMWFT (Fair Labor Standards Act - Special Minimum Wages - Full Time)NumericFLSA SMWFT BW ATP
whd_whisardflsa_smwft_ee_atp_cntFLSA SMWFT EE ATP CountEE's Agreed to under FLSA - SMWFT (Fair Labor Standards Act - Special Minimum Wages - Full Time)NumericFLSA SMWFT EE ATP
whd_whisardflsa_smwl_violtn_cntFLSA SMWL Violation CountViolations found under FLSA - SMWL (Fair Labor Standards Act - Special Minimum Wages - Learners)NumericFLSA SMWL Violations
whd_whisardflsa_smwl_bw_atp_amtFLSA SMWL BW ATP AmountBW Agreed to under FLSA - SMWL (Fair Labor Standards Act - Special Minimum Wages - Learners)NumericFLSA SMWL BW ATP
whd_whisardflsa_smwl_ee_atp_cntFLSA SMWL EE ATP CountEE's Agreed to under FLSA - SMWL (Fair Labor Standards Act - Special Minimum Wages - Learners)NumericFLSA SMWL EE ATP
whd_whisardflsa_smwmg_violtn_cntFLSA SMWMG Violation CountViolations found under FLSA - SMWMG (Fair Labor Standards Act - Special Minimum Wages - Messengers)NumericFLSA SMWMG Violations
whd_whisardflsa_smwmg_bw_atp_amtFLSA SMWMG BW ATP AmountBW Agreed to under FLSA - SMWMG (Fair Labor Standards Act - Special Minimum Wages - Messengers)NumericFLSA SMWMG BW ATP
whd_whisardflsa_smwmg_ee_atp_cntFLSA SMWMG EE ATP CountEE's Agreed to under FLSA - SMWMG (Fair Labor Standards Act - Special Minimum Wages - Messengers)NumericFLSA SMWMG EE ATP
whd_whisardflsa_smwsl_violtn_cntFLSA SMWSL Violation CountViolations found under FLSA - SMWSL (Fair Labor Standards Act - Special Minimum Wages - Student Learners)NumericFLSA SMWSL Violations
whd_whisardflsa_smwsl_bw_atp_amtFLSA SMWSL BW ATP AmountBW Agreed to under FLSA - SMWSL (Fair Labor Standards Act - Special Minimum Wages - Student Learners)NumericFLSA SMWSL BW ATP
whd_whisardflsa_smwsl_ee_atp_cntFLSA SMWSL EE ATP CountEE's Agreed to under FLSA - SMWSL (Fair Labor Standards Act - Special Minimum Wages - Student Learners)NumericFLSA SMWSL EE ATP
whd_whisardeev_violtn_cntEEV Violation CountViolations found under EEV (ESA 91)NumericEEV Violations