PRIMARY DEMOCRATS: DATA DOWNLOAD
Pro-Israel PAC money and Democrats in Congress
https://primarydemocrats.com/data.html

FEC data through August 31, 2026. Files generated October 7, 2026.

Covers every Democrat serving in the House and Senate, the two independents
who caucus with them (Sens. Bernie Sanders and Angus King), and all Democratic
governors. Money from AIPAC PAC, its super PAC United Democracy Project (UDP)
and allied pro-Israel PACs, 2016 through 2026 election cycles (January 2015
through August 31, 2026), plus a voting scorecard, AIPAC-funded trips and 2026
primary results.

LICENSE
Data compiled from public records, licensed under Creative Commons Attribution
4.0 (CC BY 4.0, https://creativecommons.org/licenses/by/4.0/): free to share
and adapt, with credit to Primary Democrats (primarydemocrats.com).

SUGGESTED CITATION
Primary Democrats, 'Pro-Israel PAC money and Democrats in Congress,'
primarydemocrats.com, data through August 31, 2026.

FILES
  people.csv (288 rows)
    One row per person: money totals by source and cycle, separate
    (not-totaled) money, voting scores, trips, positions and a profile link.
  votes.csv (7160 rows)
    One row per person per scored roll-call vote, with how they voted and a
    link to the official roll call.
  races_2026.csv (42 rows)
    One row per candidate in each 2026 Democratic primary on the 2026 page (18
    scored races and 6 where the tracked groups only gave contributions), with
    tracked money for and against.
  trips.csv (119 rows)
    One row per AIPAC-affiliated (AIEF) trip reported on House and Senate
    gift-travel filings (2017 on), linked to the filing or an archived copy of
    it.
  money_ledger.csv (68984 rows)
    One row per FEC-filed line behind the money totals (filing and transaction
    IDs, how each line was counted, and any correction). Adds up to the totals
    in people.csv (which are rounded to whole dollars, so within $1). No donor
    names.
  primarydemocrats-data.zip
    All of the above plus this README in one file.

FORMAT
Comma-separated, UTF-8 (with a byte-order mark so Excel reads accented names),
first row is the header. Money is in whole US dollars (money_ledger.csv:
dollars and cents as filed), net of refunds the groups reported. Lists inside
a cell are separated by semicolons. yes/no columns are blank where they do not
apply. Join files on person_id, which every file has and is never blank for a
tracked person. Do not join on bioguide: it is blank for governors who never
served in Congress.

SOURCES
  - Money: each PAC's own reports to the Federal Election Commission (latest
  amendment only): Schedule B contributions (including earmarks; memo items
  excluded) and Schedule E independent expenditures. JACPAC, U.S. Israel PAC
  and the regional PACs from FEC bulk files plus the FEC's itemized Schedule B
  rows the bulk files leave out (direct contributions only; credited to the
  candidate whose committee received the money). Donor network, crypto, AI and
  weapons-PAC money from the same FEC filings.
  - Votes: Voteview roll-call data, checked against the official House Clerk
  and Senate roll calls.
  - Co-sponsorships: congress.gov (119th Congress).
  - Trips and stock-trade reports: House Clerk disclosures (gift-travel
  filings and periodic transaction reports). Senate trips 2022 on from Senate
  gift-travel forms (Office of Public Records). 2017-2019 trip filings from
  House scans archived by the University of Maryland Howard Center. Senate
  stock-trade figures are report counts from efdsearch.senate.gov (Beyond
  AIPAC page and people.csv only).
  - 2026 primary results: official state results and news reports linked in
  races_2026.csv.
  - Full method: https://primarydemocrats.com/about.html

TRACKED COMMITTEES
AIPAC PAC (C00797670), United Democracy Project (C00799031), DMFI PAC
(C00710848), NORPAC (C00247403), Pro-Israel America PAC (C00699470),
Pro-Israel America PAC Action Fund (C00740936), JACPAC (C00139659), U.S.
Israel PAC (C00127811), and the regional pro-Israel PAC network: Washington
PAC, Desert Caucus, Heartland PAC, Maryland Association for Concerned
Citizens, Citizens Organized PAC, To Protect Our Heritage PAC, Mid Manhattan
PAC, Friends of Israel PAC, Bi-County PAC, Grand Canyon State Caucus and
Committee for Israel PAC. AIPAC PAC was created in December 2021 and UDP in
2022, so their money starts then.

CAVEATS (read before publishing)
  - Totals include only money tied to one candidate: contributions to the
  campaign (direct and earmarked) and independent spending supporting them.
  Spending AGAINST a person is shown separately and never added to their
  total. Money to party committees (like the DCCC) is not counted.
  - Columns marked SEPARATE are never included in total_pro_israel_pac:
  indirect UDP money (spending by super PACs UDP funded), the AIPAC donor
  network, money to affiliated committees (joint fundraising and leadership
  PACs), weapons makers' PACs, and crypto and AI super PAC money. Do not add
  them to the totals.
  - Donor network: individuals who gave to AIPAC PAC or UDP are matched to
  direct campaign donations by name and ZIP code, so a few matches may be
  different people with the same name. Earmarks already counted and duplicate
  entries from amended reports are excluded. Only totals and donor counts are
  published; no donor names or donor-level data are in these files.
  - The split between AIPAC PAC earmarked and direct money is approximate;
  aipac_pac_total is exact.
  - Amounts are rounded to whole dollars separately, so the per-cycle columns
  (or aipac_pac_total + udp_support) can differ from the matching total by $1.
  - Voting scores: "present" counts as half; missed votes are excluded. Scores
  based on fewer than 3 scored Israel votes are flagged in
  voting_limited_record. Scores cover only the votes in votes.csv. Scores are
  category-weighted: the share for each area is averaged equally, so a score
  is not the share of all listed votes; voting_score_areas says which areas
  count.
  - money_ledger.csv lists every filed line behind the totals, so each total
  can be rebuilt from FEC filings: sum amount where counted_in_total = yes, by
  person_id. In a few cases a void with no usable election code leaves a
  negative cycle; the site nets it against an earlier cycle of the same PAC,
  so per-cycle sums from the ledger can differ slightly from the
  pro_israel_<cycle> columns, while the totals match to within $1 (totals are
  rounded to whole dollars). The code that builds the totals is
  pipeline/agg2.py; corrections to filed lines are listed in the ledger's
  adjustment column and on the methodology page.
  - Governors appear because they are Democratic officeholders; these PACs
  give only to federal candidates, so a governor has money only from an
  earlier run for Congress.

COLUMNS
  people.csv
    person_id: Stable ID for the person (name + state, e.g.
    abigail-spanberger-va). Never blank. Use this to join the files; it is
    also the profile page name.
    name: Full name as listed by Congress (or the governor's office).
    party: Democrat or Independent (Sens. Sanders and King caucus with
    Democrats).
    office: House, Senate or Governor.
    state: Two-letter state or territory code.
    district: House district number; 0 = at-large or non-voting delegate;
    blank for senators and governors.
    bioguide: Congressional Bioguide ID, including for governors who served in
    Congress (Mikie Sherrill, Abigail Spanberger). Blank only for governors
    who never served in Congress, so do not join on it; use person_id.
    fec_ids: FEC candidate IDs for this person, separated by semicolons.
    up_for_election_2028: yes if the seat is on the ballot in 2028 (every
    House seat, senators whose terms end January 2029, governors elected in
    2028).
    former_member: yes if the person has left office since the site launched
    (their record is kept); left_office gives the date.
    left_office: Date the person left office (blank for current
    officeholders).
    status_2026: Status after the 2026 primaries (for example retiring, lost
    the primary, running for another office). Blank = running for re-election
    or no change.
    total_pro_israel_pac: Total pro-Israel PAC money, 2016-2026 cycles: AIPAC
    PAC direct + earmarked contributions, United Democracy Project supporting
    spending, and all other tracked pro-Israel PACs. Whole US dollars.
    aipac_plus_udp: AIPAC PAC (direct + earmarked) plus United Democracy
    Project supporting spending.
    aipac_pac_total: AIPAC PAC money: direct + earmarked contributions.
    aipac_pac_earmarked: Contributions from individuals that AIPAC PAC
    collected and passed on to the campaign (approximate split; see caveats).
    aipac_pac_direct: AIPAC PAC's own contributions to the campaign
    (approximate split; see caveats).
    udp_support: United Democracy Project (AIPAC's super PAC) independent
    spending supporting this person.
    other_pro_israel_pacs_total: Contributions and supporting spending from
    the other tracked pro-Israel PACs (DMFI PAC, NORPAC, Pro-Israel America
    PAC and Action Fund, JACPAC, U.S. Israel PAC and the regional network).
    pro_israel_2016: Total pro-Israel PAC money in the 2016 election cycle
    (2015-2016).
    pro_israel_2018: Total pro-Israel PAC money in the 2018 election cycle
    (2017-2018).
    pro_israel_2020: Total pro-Israel PAC money in the 2020 election cycle
    (2019-2020).
    pro_israel_2022: Total pro-Israel PAC money in the 2022 election cycle
    (2021-2022).
    pro_israel_2024: Total pro-Israel PAC money in the 2024 election cycle
    (2023-2024).
    pro_israel_2026: Total pro-Israel PAC money in the 2026 election cycle
    (2025-2026).
    donor_network_total: SEPARATE, NOT IN TOTALS. What people who gave to
    AIPAC PAC or UDP gave directly to this person's campaign, 2021-2026,
    excluding earmarks already counted above. Matched by name + ZIP.
    donor_network_donors: SEPARATE. Number of matched donors behind
    donor_network_total (a count only; no names are published). Counts under 5
    are shown as <5.
    state_donor_network_total: GOVERNORS ONLY, SEPARATE, NOT IN TOTALS. What
    people who gave to AIPAC PAC or UDP gave to the governor's own state
    campaign committees, from state campaign-finance records (itemized
    individual contributions). Blank where the state is not covered yet.
    state_donor_network_donors: GOVERNORS ONLY. Number of matched donors
    behind state_donor_network_total. Counts under 5 are shown as <5.
    affiliated_committees_total: SEPARATE, NOT IN TOTALS. Tracked-PAC money
    sent to this person's joint fundraising committees or leadership PAC.
    weapons_pacs_total: SEPARATE, NOT IN TOTALS. Contributions from weapons
    makers' PACs (Lockheed Martin, RTX, Boeing, General Dynamics, Northrop
    Grumman, L3Harris, BAE Systems, Elbit Systems of America).
    crypto_superpac_support: SEPARATE. Crypto super PAC spending supporting
    this person (Fairshake, Protect Progress, Defend American Jobs and
    allies).
    crypto_superpac_oppose: SEPARATE. Crypto super PAC spending against this
    person.
    ai_superpac_support: SEPARATE. AI-industry super PAC spending supporting
    this person (Leading the Future, Think Big, American Mission).
    ai_superpac_oppose: SEPARATE. AI-industry super PAC spending against this
    person.
    voting_score: 0-100: share of scored votes on Israel, war powers and civil
    liberties cast for the scored position, averaged across categories (see
    the scorecard page). Higher = cast the scored vote more often. Blank = no
    scored votes (non-voting delegates, members sworn in after the last scored
    vote, governors who never served in Congress).
    voting_score_areas: Areas the score covers. An area counts only with at
    least 2 votes cast, and areas are averaged equally, so a score covering
    one area (e.g. "War powers") says nothing about the others. "all" = Israel
    & Gaza, war powers and speech & civil liberties.
    voting_limited_record: yes if the score rests on fewer than 3 scored
    Israel votes (a thin record; treat with care). Blank when there is no
    score.
    other_issues_score: 0-100 score on the votes listed on the Beyond AIPAC
    page (crypto and Wall Street, immigration, Trump nominees), scored the
    same way. Shown separately.
    aipac_funded_trips: Number of AIPAC-affiliated (AIEF) trips reported on
    House and Senate gift-travel filings (see trips.csv).
    medicare_for_all_cosponsor: yes if co-sponsoring the Medicare for All Act
    in the 119th Congress (H.R. 3069 / S. 1506). Blank for governors.
    stock_ban_cosponsor: yes if co-sponsoring a congressional stock-trading
    ban in the 119th Congress. Blank for governors.
    stock_trade_reports_2023_2026: Number of periodic transaction (stock
    trade) reports filed, 2023-2026. House: from the House Clerk. Senate:
    counted by hand from efdsearch.senate.gov (see senate_ptr_collected).
    Blank for governors, and for senators if the Senate count has not been
    collected.
    senate_ptr_collected: SENATORS ONLY. Date the Senate report count was
    collected from efdsearch.senate.gov.
    stock_trades_2023_2026: Individual trades listed in those reports
    (electronically filed reports only; paper filings are scanned images and
    not counted). Includes spouse and dependent-child trades. Blank for
    senators and governors.
    profile_url: This person's page on primarydemocrats.com (blank if no
    page).

  votes.csv
    person_id: Stable ID for the person; joins to people.csv person_id. Never
    blank.
    name: Member name.
    bioguide: Congressional Bioguide ID. Never blank in this file.
    vote_id: Chamber + Congress + roll-call number, as numbered by Voteview
    (H118-523 = House, 118th Congress, roll 523). Clerk/Senate roll numbers
    can differ; use official_record_url.
    chamber: House or Senate.
    date: Date of the vote (YYYY-MM-DD).
    title: Short description of the measure.
    category: Scoring category.
    scoring_group: voting = counts toward voting_score; other = counts toward
    other_issues_score.
    scored_position: The scored position: Y or N.
    member_vote: Y = yes, N = no, P = present (counts as half), - = did not
    vote (excluded from the score).
    official_record_url: Official House Clerk or Senate roll call.

  races_2026.csv
    race: 2026 Democratic primary where the tracked groups spent or gave:
    every race on the 2026 page, scored or not (see scored).
    date: Primary date.
    winner: Winner of the primary.
    result: Vote shares as reported.
    scored: yes = counted in AIPAC's 2026 record on the 2026 page (see
    ad_spending for the rule); no = the tracked groups only gave
    contributions, with no ad spending of $100,000 or more, so the race is
    listed but not scored.
    outcome: won = AIPAC's side won, lost = AIPAC's side lost, mixed = mixed
    result (same scoring as the 2026 page). The same value repeats on each
    candidate row of a race. Blank when scored = no.
    candidate: Candidate in that race (one row each; "(incumbent)" marks a
    sitting member).
    person_id: person_id in people.csv when the candidate is a tracked member
    or governor; blank for other candidates.
    tracked_support: Tracked pro-Israel PAC money for this candidate in the
    2026 cycle (contributions + supporting spending).
    tracked_oppose: Independent spending against this candidate by United
    Democracy Project and DMFI PAC, 2025-2026. Never added to totals.
    indirect_support: SEPARATE. Supporting spending by other super PACs that
    UDP funded (at least 10% of their itemized receipts). DMFI-funded PACs are
    listed on profiles but not in this column.
    indirect_oppose: SEPARATE. Opposing spending by those UDP-funded super
    PACs.
    ad_spending: Ads for or against this candidate, 2025-26: the tracked
    groups' independent expenditures plus indirect spending by UDP-funded
    super PACs (contributions excluded). A race is scored when its candidates'
    ad_spending adds up to $100,000 or more and another Democrat got 10%+ of
    the vote.
    sources: Results sources, separated by semicolons.

  trips.csv
    person_id: Stable ID for the person; joins to people.csv person_id.
    bioguide: Congressional Bioguide ID.
    name: Member who reported the trip.
    state: Two-letter state code.
    start: Trip start date.
    end: Trip end date.
    destination: Destination as reported.
    source: Link to the gift-travel filing.
    source_type: official = House Clerk or Senate Office of Public Records
    filing; secondary = archived copy of the official filing: House scans
    hosted by the University of Maryland Howard Center (2017-2019), or
    Internet Archive copies of Senate gift-travel forms (2017-2021).

  money_ledger.csv
    person_id: Joins to people.csv person_id.
    name: Person the line is attributed to.
    committee_id: FEC ID of the tracked PAC that filed the line.
    committee: Name of that PAC.
    source: Where the line comes from: the PAC's own e-filed report (Schedule
    B line 23 = contribution, Schedule E = independent expenditure) or the FEC
    bulk pas2 file (with its sub_id).
    filing_id: FEC filing (report) number. Only the latest amendment of each
    report is used.
    transaction_id: The filer's transaction ID for the line (stable across
    amendments).
    image_number: FEC image number (bulk-file lines only).
    date: Contribution or expenditure date.
    amount: US dollars and cents as filed (negative = refund or void).
    candidate_fec_id: FEC candidate ID the line names.
    kind: direct or earmark = contribution to the campaign; support =
    independent spending for them; oppose = spending against them (never in
    totals); excluded = removed by a documented correction.
    counted_in_total: yes if the line is part of total_pro_israel_pac in
    people.csv.
    cycle: Election cycle the line is assigned to (from its election code, not
    the date).
    election_code: Election code as filed (e.g. P2024 = 2024 primary).
    adjustment: Blank unless a documented correction changed how the line is
    counted (see the methodology page, "Corrections to filed data").
    fec_filing_url: The filing on fec.gov.

CORRECTIONS
Every number links back to a public record. Report errors at
https://primarydemocrats.com/about.html#contact. Fixes are logged at
https://primarydemocrats.com/changes.html.
