โ๏ธ Civic Data Tools
FEC Contributions ยท Lobbying Disclosures ยท Industry Analysis
25,853
FEC Contribution Records
$1.42M
Total Contributions Tracked
4
Industries Detected
26,853
All-Source Records (incl. ActBlue/WinRed)
Overview
The Civic Data Tools pipeline collects and analyzes U.S. campaign finance and lobbying disclosure data from public government sources. It fetches records from the FEC Open API, ActBlue, WinRed, and the U.S. Senate Lobbying Disclosure Archive, then normalizes, cleans, and enriches the data with industry classification before presenting it in an interactive Dash dashboard.
Contributions by Industry (2024)
Top 10 Employers by Contribution Amount
Industry Summary
| Industry | Donors | Total Contributions |
|---|---|---|
| Finance | 25,200 | $1,155,157 |
| Healthcare | 650 | $145,300 |
| Technology | 3 | $32,423 |
| Unknown / Unclassified | โ | $88,888 |
Top Employers โ Full List
| # | Employer | Total Amount |
|---|---|---|
| 1 | American Bankers Association | $851,218 |
| 2 | Applied Materials, Inc. | $67,234 |
| 3 | Bankers Association Senior | $64,260 |
| 4 | Self-Employed (Medical/MD) | $52,625 |
| 5 | Bankers Association Sr. | $50,400 |
| 6 | Bankers Association Manager Grassroots | $50,400 |
| 7 | Bankers Association Director | $37,800 |
| 8 | Self-Employed Doctor | $34,000 |
| 9 | Bankers Association Relationship | $31,500 |
| 10 | Bankers Association Executive Director | $31,500 |
Data Sources
-
FEC Open API โ
api.open.fec.gov
Schedule A contributions to tracked PAC committees (Morgan Stanley, Goldman Sachs, BlackRock, American Bankers Association) - ActBlue & WinRed (via FEC) โ Bundled small-dollar contributions from intermediary committees; 1,000 records
-
U.S. Senate LDA Archive โ
lda.senate.gov
Lobbying Disclosure Act filings; fetched with GovInfo and Wayback Machine fallbacks
Pipeline
- Fetch โ Pull raw records from FEC API, ActBlue/WinRed, Senate LDA
- Clean โ Repair malformed CSV (quote normalization, column alignment, donor name splits)
- Enrich โ Classify employers into industries using keyword + RapidFuzz fuzzy matching
- Merge โ Combine FEC direct contributions with intermediated ActBlue/WinRed records
- Visualize โ Interactive Dash dashboard with industry filter, bar charts, and paginated data table
Run the Interactive Dashboard
The full interactive dashboard (Plotly Dash, filter by industry, paginated table) runs locally:
# Install dependencies
cd civic_resilience_suite/data_collect
pip install -r requirements.txt
# Run pipeline to refresh data (requires FEC_API_KEY)
python pipeline.py
# Launch dashboard
cd dashboard
python app.py
# โ http://localhost:5050