Skip to end of metadata
Go to start of metadata

For any other Californians out there, we uses these queries to help with our FPPC Form 460s. They return name, address, employer, job title, and contribution amount for all individuals and organization name, FEC / FPPC ID, and address for all organizations whose total contributions in an election cycle meet or exceed $100. I plan on integrating this into CiviCRM as a custom report soon.

Replace date placeholders with dates formatted as "MM-DD-YY 00:00:00".

For individuals:

For organizations (we store FEC / FPPC IDs for committees in the SIC Code field):

Labels
  • None