🏛️ Apify Congress Financial Disclosures Actor 🇺🇸

The most comprehensive and reliable Congressional financial disclosure data scraper

Access detailed financial disclosure data from members of Congress, including stock transactions, asset holdings, and trading activities with enterprise-grade reliability and precision.

🌟 Why Choose This Actor?

"Transparency in government starts with accessible financial data" 🇺🇸

The Congress Financial Disclosures Actor delivers comprehensive access to congressional financial data with these advanced capabilities:

Comprehensive Data Access: Query detailed financial disclosure records from members of Congress, including stock transactions, asset holdings, and trading activities.

Advanced Filtering & Search: Powerful search capabilities with filters for member names, date ranges, stock symbols, and transaction types.

Real-Time Database Integration: Direct connection to Supabase database containing up-to-date congressional financial disclosure data.

Structured Data Output: Clean, structured JSON output with comprehensive metadata for easy integration and analysis.

Enterprise-Grade Performance: Built for reliability with robust error handling, comprehensive logging, and optimized database queries.

Cost-Effective: Pay-per-transaction model with transparent pricing - only pay for the data you actually retrieve.

🚀 Features

Core Capabilities

• Member Search: Find financial disclosures by congressional member name (first and last name)
• Date Range Filtering: Search transactions within specific date ranges or exact dates
• Stock Symbol Lookup: Find all transactions involving specific stock ticker symbols
• Transaction Type Analysis: Filter by transaction types (purchases, sales, exchanges)
• Comprehensive Metadata: Rich metadata including filing IDs, document quality, and timestamps

Data Quality

• Clean Output: Structured JSON data with consistent field formatting
• Comprehensive Fields: Transaction details, amounts, dates, member information, and filing metadata
• Search Metadata: Track search parameters and execution details for audit trails
• Database Integration: Direct connection to Supabase for real-time data access
• Error Handling: Robust error handling with detailed logging and graceful failure recovery

📖 Usage Examples

Basic Member Search

Search for financial disclosures by a specific congressional member.

{
  "First_Name": "Nancy",
  "Last_Name": "Pelosi",
  "Max_Results": 50
}

Date Range Search

Find all transactions within a specific date range.

{
  "First_Name": "Nancy",
  "Last_Name": "Pelosi",
  "Start_Date": "2024-01-01",
  "End_Date": "2024-12-31",
  "Max_Results": 100
}

Stock Symbol Search

Find all transactions involving a specific stock symbol across all members.

{
  "Stock_Symbol": "AAPL",
  "Max_Results": 200
}

Advanced Filtered Search

Combine multiple filters for precise data retrieval.

{
  "First_Name": "Nancy",
  "Last_Name": "Pelosi",
  "Start_Date": "2024-01-01",
  "End_Date": "2024-06-30",
  "Stock_Symbol": "MSFT",
  "Max_Results": 25
}

🔍 Input Parameters

Parameter	Type	Required	Default	Description
First_Name	string	❌	None	First name of the congressional member
Last_Name	string	❌	None	Last name of the congressional member
Date_Reported	string	❌	None	Exact date when disclosure was reported (YYYY-MM-DD)
Start_Date	string	❌	None	Start date for date range search (YYYY-MM-DD)
End_Date	string	❌	None	End date for date range search (YYYY-MM-DD)
Stock_Symbol	string	❌	None	Stock ticker symbol to search for (e.g., 'AAPL', 'MSFT')
Max_Results	integer	❌	100	Maximum number of results to return (1-1000)

📊 Output Format

Financial Disclosure Record Structure

{
  "id": "unique-transaction-id",
  "Owner": "Asset Owner Name",
  "Asset": "Apple Inc. Common Stock",
  "Ticker": "AAPL",
  "Asset_Type_Code": "STOCK",
  "Transaction_Type": "Purchase",
  "Date": "2024-01-15",
  "Notification_Date": "2024-01-20",
  "Amount_Range": "$1,001-$15,000",
  "Capital_Gains_Over_200": "No",
  "Details": "Additional transaction details",
  "First_Name": "Nancy",
  "Last_Name": "Pelosi",
  "State_District": "CA-11",
  "House": "House",
  "Filing_ID": "PTS-2024-001234",
  "DocID": "DOC-2024-567890",
  "Year": "2024",
  "PDF_Quality": "High",
  "created_at": "2024-01-20T10:30:00Z",
  "search_metadata": {
    "first_name": "Nancy",
    "last_name": "Pelosi",
    "start_date": "2024-01-01",
    "end_date": "2024-12-31",
    "stock_symbol": "AAPL",
    "max_results": 100,
    "search_timestamp": "2024-01-20T10:30:00Z",
    "total_results_found": 15,
    "query_execution_time": 0.245
  }
}

Search Result Metadata

Each result includes comprehensive search metadata:

• Search Parameters: Original search criteria used
• Execution Details: Timestamp and query execution time
• Result Statistics: Total results found and returned
• Database Information: Source and quality indicators

🏗️ Technical Architecture

Database Integration

• Supabase Connection: Direct PostgreSQL connection via SQLAlchemy
• Connection Pooling: Optimized connection management with NullPool
• Driver Support: Automatic fallback between psycopg and psycopg2 drivers
• SSL Security: Secure connections with SSL mode requirement

Data Models

• CongressDataQuery Class: Comprehensive query interface with filtering capabilities
• Type Safety: Strong typing with Python type hints throughout
• Error Handling: Robust error handling with graceful degradation
• Performance Optimization: Efficient queries with proper indexing and limits

Apify Integration

• Actor Framework: Built on Apify's Python Actor template
• Dataset Storage: Results stored in Apify datasets for easy access
• Charging Model: Pay-per-transaction pricing with setup fees
• Logging: Comprehensive logging for monitoring and debugging

🔧 Development

Prerequisites

• Python 3.8+
• Apify SDK
• SQLAlchemy
• psycopg or psycopg2
• python-dotenv

Environment Variables

SUPABASE_USER=your_username
SUPABASE_PASSWORD=your_password
SUPABASE_HOST=your_host
SUPABASE_PORT=5432
SUPABASE_DBNAME=your_database

Local Development

# Install dependencies
pip install -r requirements.txt

# Set up environment variables
cp .env.example .env
# Edit .env with your database credentials

# Run the actor locally
python src/main.py

📈 Use Cases

Financial Research

• Track congressional stock trading patterns
• Analyze potential conflicts of interest
• Monitor investment trends among lawmakers

Transparency & Accountability

• Investigate financial relationships
• Track asset holdings over time
• Identify unusual trading activities

Data Analysis

• Build financial disclosure dashboards
• Create trading pattern visualizations
• Generate compliance reports

News & Media

• Research for investigative journalism
• Fact-checking financial claims
• Building comprehensive member profiles

🛡️ Data Privacy & Compliance

• Public Records: All data is from publicly available financial disclosure forms
• No Personal Data: Only official financial disclosure information is accessed
• Compliance: Follows all applicable data access regulations
• Transparency: Full audit trail of all data access and queries

📞 Support

For technical support, feature requests, or questions about the Congressional Financial Disclosures Actor:

• Documentation: Comprehensive inline documentation and type hints
• Error Handling: Detailed error messages and logging for troubleshooting
• Performance: Optimized queries and connection management
• Scalability: Built to handle large datasets and high-volume queries

Made with ❤️ for transparency and accountability

Access comprehensive congressional financial data with the most reliable and efficient disclosure scraper available.

Last Updated: 2025.01.27