Case study / 05
Congress.gov Data Pipeline
The data backbone behind LegiKit. A Python pipeline that pulls bills, sponsors, committee actions, and full text into Postgres so legislative analysis starts with current context.
Notes
The data backbone behind LegiKit. A Python pipeline that pulls bills, sponsors, cosponsors, committee actions, and full text from the Congress.gov API, normalizes it into a clean Postgres schema, and keeps it current with incremental updates. The payoff is latency — a staffer generating a vote rec 30 minutes before a floor vote gets bill data as a millisecond database lookup instead of a slow, rate-limited API call.