US Enforcement and Compliance Screening Records

What’s in the listing

Civly compiles public records into analytics-ready datasets. This product bundles federal enforcement and compliance-screening records into five join-ready tables: exclusion and debarment lists across six federal 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. Entity names are normalized for matching, with NPI on medical exclusion records.

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

Five tables, one bundle

Column names are uppercase. The trial listing carries the complete EXCLUSIONS table; the full bundle adds the other four.

Data dictionary — ENFORCEMENT.EXCLUSIONS — exclusion and debarment records (trial table)

Data dictionary — ENFORCEMENT.DOJ_PRESS_RELEASES

Data dictionary — ENFORCEMENT.EPA_FACILITIES

Data dictionary — ENFORCEMENT.OSHA_INSPECTIONS

Data dictionary — ENFORCEMENT.OSHA_VIOLATIONS

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.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.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.EXCLUSIONS
WHERE NPI IS NOT NULL AND (END_DATE IS NULL OR END_DATE > CURRENT_DATE())
ORDER BY ACTION_DATE DESC LIMIT 100;

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 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.