# CA Lobby BigQuery Integration

> 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.

- Skill: `majiayu000/ca-lobby-bigquery-integration` (Agent Skill, multi-file: 2 files)
- Install (CLI): `npx skillmds add majiayu000/ca-lobby-bigquery-integration`
- Raw SKILL.md: https://api.skillmd.com/api/skills/majiayu000/ca-lobby-bigquery-integration/raw
- Safety review: pending
- Works with: Claude Code, Claude.ai, OpenAI Codex
- Category: Integrations & APIs
- Author: majiayu000 (https://skillmd.com/u/majiayu000)
- Updated: 2026-09-09
- Page: https://skillmd.com/skills/majiayu000/ca-lobby-bigquery-integration

---


# 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**