Data Quality Center

Clean up and enrich your database — admin only.

0
Duplicate companies
0
Missing logos
0
Layoffs missing location

Run All Tasks

Merge duplicates → fill logos → fix geocoding in one go.

Merge Duplicate Companies

Clean

Finds companies with the same name, keeps the most complete record, re-points all layoffs, and deletes the duplicates.

Auto-fill Missing Logos

Clean

Uses Clearbit logo API to fill in missing company logos (up to 50 per run). Falls back to Google favicon.

Fix Layoff Geocoding

Clean

Fills missing location data on layoffs using company HQ, then uses AI to find HQ for unknown companies (up to 100 per run).

Fetch State WARN Notices

Clean

Pulls live WARN Act filings directly from 15 state labor department websites (CA, NY, TX, FL, IL, WA, PA, NJ, GA, MI, OH, NC, CO, AZ, MA). Skips duplicates.

Backfill Historical Layoffs (1980–Present)

Clean

Pulls major corporate layoffs across the web from 1980 onward via batched LLM+web search. 47 batches total — run a range (e.g. 0–5) per click to avoid timeouts.

Batches:to(of 0–46)

Backfill Historical WARN Filings (1989–Present)

Clean

Pulls US WARN Act filings year-by-year from 1989 (when WARN took effect) to today. Run a range (e.g. 0–5) per click.

Batches:to(of 0–37)