Federal PAC money into one state (try: LA, then filter by committee)

Complete committee-to-candidate contributions from the FEC bulk files, all cycles 2010-2026, no row cap. This is the full denominator, which is what makes an ABSENCE here meaningful. Keyed on the FEC committee id rather than the name, because committees get renamed: Meta's PAC (C00502906) filed as FACEBOOK INC PAC before 2022. `txn_type` distinguishes direct contributions from independent expenditures, which are legally different and must not be summed together. `office` shows the recipient's seat as H-LA-01 or S-LA. The `state` column here is the recipient's OFFICE state, not a donor address.

SELECT filer_name AS pac, filer_id AS committee_id,
       counterparty_name AS recipient, office, amount, txn_date, txn_type
FROM cf_transactions
WHERE source = 'fec_bulk_pas2'
  AND state = upper(:state)
ORDER BY amount DESC NULLS LAST
LIMIT 500