Contributions

amount

Contribution amount in dollars.

campaign_id

Recipient campaign id (within this store).

candidate_name

Recipient candidate.

canon_id

Canonical donor id (a merged donor keeps one id across aliases).

city

Donor city (public).

date

Date of the contribution as disclosed (may be null).

designated_election_phase

primary / general, when the filer designated one.

donor_name

Donor name as normalized for matching (UPPER-case).

election_cycle_year

Cycle year of the recipient campaign.

employer

Donor's employer as disclosed (individuals only).

is_inkind

1 = in-kind contribution, 0 = monetary.

is_organization

1 = organization/PAC (no floor), 0 = individual ($200 floor).

occupation

Donor's occupation as disclosed (individuals only).

office_name

Office the recipient is running for.

party

Recipient candidate's party.

reporting_period

The filing's reporting period.

state

Donor state (public).

zip

Donor ZIP (public disclosed data; never a street address).

>10,000 rows count all sorted by amount descending

✎ View and edit SQL

This data as json, CSV (advanced)

Next page

CREATE TABLE public_contributions ("canon_id", "donor_name", "employer", "occupation", "is_organization", "entity_type", "entity_subtype", "city", "state", "zip", "amount", "date", "is_inkind", "designated_election_phase", "campaign_id", "reporting_period", "party", "election_cycle_year", "candidate_name", "office_name");
CREATE INDEX idx_pc_pair ON public_contributions(canon_id, campaign_id);
CREATE INDEX idx_pc_campaign ON public_contributions(campaign_id);