---

name: CA Lobby BigQuery Integration description: BigQuery integration patterns for CA Lobby lobby data with BLN API schema. Use when working with CA Lobby backend, database queries, or data service. Provides CA-specific BigQuery patterns and Flask integration guidance. extends: generic-skills/database-integration version: 1.0.0

CA Lobby BigQuery Integration

CA Lobby Configuration

Database Type: BigQuery Backend Location: webapp/backend/ Data Service: webapp/backend/data_service.py Schema Source: Big Local News (BLN) API ORM: SQLAlchemy

CA Lobby BigQuery Specifics

Key Files

• webapp/backend/app.py - Flask application
• webapp/backend/data_service.py - Data access layer
• webapp/backend/database.py - Database connections

BLN API Schema

• Organizations
• Lobbyists
• Lobbying Activities
• Expenditures
• Payments

Demo Mode

IMPORTANT: Project has demo mode flag

• REACT_APP_USE_BACKEND_API=true - Use backend
• REACT_APP_USE_BACKEND_API=false - Use demo data (default)

Common Query Patterns

• Organization search
• Expenditure aggregations
• Lobbyist network queries
• Date-range filtering
• Activity timelines

---

Changelog

Version 1.0.0 (2025-10-20)

• Initial CA Lobby implementation
• BigQuery specific patterns
• BLN API schema integration

---

End of Skill