US Enforcement and Compliance Screening Records

About this dataset

What’s in the listing

Civly compiles public records into analytics-ready datasets. This product bundles federal enforcement and compliance-screening records into six views: exclusion and debarment lists across six sources (HHS-OIG LEIE, FDA debarment, federal enforcement, UN consolidated, FBI wanted, fac single audit); DOJ press releases with full text; EPA-regulated facilities with compliance status and penalties; OSHA inspections; and OSHA violations with citations and penalties; and Department of Labor wage-hour cases with back wages, penalties and findings by labor law. Entity names are normalized for matching, with NPI on medical exclusion records.

Row counts checked October 27, 2026.

Common uses: compliance screening, third-party risk, due diligence, and investigative work. Every record carries source attribution and a refresh date. Data refreshes weekly.

Schemas

Six views, one bundle

The same six views serve the trial and the subscription. During the free trial, the exclusions view returns every record from all six sources. The other five views return no rows during the trial. A subscription unlocks them. Column names are uppercase.

Schema

Data dictionary : ENFORCEMENT_SCREENING.EXCLUSIONS

Schema

Data dictionary : ENFORCEMENT_SCREENING.DOJ_PRESS_RELEASES

Schema

Data dictionary : ENFORCEMENT_SCREENING.EPA_FACILITIES

Schema

Data dictionary : ENFORCEMENT_SCREENING.OSHA_INSPECTIONS

Schema

Data dictionary : ENFORCEMENT_SCREENING.OSHA_VIOLATIONS

Schema

Data dictionary: ENFORCEMENT_SCREENING.WAGE_HOUR_CASES

370,964 concluded cases from the Department of Labor Wage and Hour Division, whose published series starts in fiscal 2005. Each row is a case, including cases where no violation was found. 114 columns. This view returns no rows during the free trial. FINDINGS_START_DATE and FINDINGS_END_DATE describe the findings period, not case-open or case-close dates. Source dates include apparent errors and remain as published. Violation counts loaded by DOL from October 1, 2025 are not directly comparable with earlier counts because DOL changed its collection procedures.

Getting started

Sample queries

After installing, set your worksheet’s database selector to the installed database and these run as written.

-- Exclusion records by source
SELECT SOURCE, COUNT(*) AS RECORDS, MIN(ACTION_DATE) AS EARLIEST, MAX(ACTION_DATE) AS LATEST
FROM ENFORCEMENT_SCREENING.EXCLUSIONS
GROUP BY SOURCE ORDER BY RECORDS DESC;

-- Screen a person or organization by normalized name
SELECT SOURCE, FULL_NAME, ORG_NAME, CATEGORY, ACTION_DATE, END_DATE, DETAIL_URL
FROM ENFORCEMENT_SCREENING.EXCLUSIONS
WHERE NORM_FULL = UPPER('Jane Q Public') OR NORM_ORG = UPPER('Acme Health Inc');

-- Excluded providers with an NPI (medical screening)
SELECT SOURCE, FULL_NAME, NPI, ACTION_DATE, END_DATE
FROM ENFORCEMENT_SCREENING.EXCLUSIONS
WHERE NPI IS NOT NULL AND (END_DATE IS NULL OR END_DATE > CURRENT_DATE())
ORDER BY ACTION_DATE DESC LIMIT 100;

-- Back wages and penalties by state, subscription only
SELECT ST_CD, COUNT(*) AS CASES,
       SUM(BW_ATP_AMT) AS BACK_WAGES_AGREED_USD,
       SUM(CMP_ASSD) AS CIVIL_PENALTIES_ASSESSED_USD
FROM ENFORCEMENT_SCREENING.WAGE_HOUR_CASES
GROUP BY ST_CD
ORDER BY BACK_WAGES_AGREED_USD DESC NULLS LAST;

Sourcing

Sourcing and attribution

Source data is published by the United States Department of Health and Human Services Office of Inspector General, the Food and Drug Administration, the Department of Justice, the Environmental Protection Agency, the Occupational Safety and Health Administration, the Department of Labor Wage and Hour Division, the United Nations, and the Federal Bureau of Investigation. Civly cleans, normalizes, and standardizes entity names and stamps every record with source attribution and a refresh date. When you publish analysis based on this dataset, credit the agencies and Civly as compiler. Wage-hour cases come from the DOL enforcement-data export. SOURCE_URL, SOURCE_RELEASE_DATE and IMPORTED_AT identify the file and when Civly imported it.