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" INTEGER,  -- donor id; one id per donor across name variants
  "donor_name" TEXT,  -- the DONOR (who gave)
  "employer" TEXT,  -- the donor's employer
  "occupation" TEXT,  -- the donor's occupation
  "is_organization" INTEGER,
  "entity_type" TEXT,
  "entity_subtype" TEXT,
  "city" TEXT,  -- the DONOR's city, not the candidate's
  "state" TEXT,  -- the DONOR's state, not the candidate's
  "zip" TEXT,  -- the DONOR's ZIP, not the candidate's
  "amount" REAL,  -- dollars
  "date" TEXT,
  "is_inkind" INTEGER,
  "designated_election_phase" TEXT,
  "campaign_id" INTEGER,  -- the RECIPIENT campaign
  "reporting_period" TEXT,
  "party" TEXT,  -- the recipient candidate's party
  "election_cycle_year" INTEGER,  -- election year of the recipient campaign
  "candidate_name" TEXT,  -- the RECIPIENT candidate
  "office_name" TEXT,  -- the office the recipient ran for, e.g. 'Tennessee PAC', 'Governor', 'Tennessee Senate, District 27', 'Tennessee Senate, District 20'; names include the district, so match a whole chamber with LIKE 'Tennessee Senate%', never =
  "floor_cycle_key" TEXT
);
CREATE INDEX idx_pc_pair ON public_contributions(canon_id, campaign_id);
CREATE INDEX idx_pc_campaign ON public_contributions(campaign_id);