Court Case Data Extraction & Lead Enrichment
Overview
An automated system that scrapes court case records from US county websites, identifies commercial contract cases via keyword and category filters, and enriches them with verified mobile and email contacts using AccurateAppend and Enformion APIs. Output is delivered as clean Excel datasets for compliant SMS and email outreach. Outcome: Reduced manual case review time by over 80% and improved contact accuracy for downstream SMS campaigns.
Architecture & Pipeline
flowchart LR
n0["Scheduler (EST)Timezone-aware"]
n1["County Court SitesUS jurisdictions"]
n2["ScrapeSelenium · BeautifulSoup"]
n3["Keyword & Category FilterCommercial contracts"]
n4["AccurateAppend / EnformionPhone + email enrichment"]
n5["Excel DatasetCompliant outreach data"]
n0 --> n1
n1 --> n2
n2 --> n3
n3 --> n4
n4 --> n5
classDef step0 fill:#f1f5f9,stroke:#64748b,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step1 fill:#ecfeff,stroke:#06b6d4,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step2 fill:#f0fdfa,stroke:#0d9488,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step3 fill:#ecfdf5,stroke:#10b981,color:#1e293b,stroke-width:2px,rx:10,ry:10;
classDef step4 fill:#fffbeb,stroke:#f59e0b,color:#1e293b,stroke-width:2px,rx:10,ry:10;
class n0 step0;
class n1 step1;
class n2 step2;
class n3 step2;
class n4 step3;
class n5 step4;
End-to-end flow derived from this project's scope and tech stack. Tap View Fullscreen for a larger view, or scroll horizontally on small screens.
Key Features
- Automated scraping of county court databases
- Keyword- and category-based case filtering
- Phone and email enrichment via third-party APIs
- Validation and consistency checks for data integrity
- Timezone-aware (EST) scheduled execution
- Clean Excel datasets ready for analysis
- Tech Stack:** Python, Selenium, BeautifulSoup, Requests, Pandas, FastAPI