$ $ $ Who FundsTennessee
Races PACs Donors Vendors Starting Points What's New Bulk Data About
Memphis
Races PACs Donors Vendors Starting Points What's New Bulk Data About Memphis

Contributions

Table actions Table actions
  • Query this table with AI assistance

    Ask a question to build a SQL query

One row per published contribution (monetary or in-kind). Rows are already past the privacy floor — every individual here cleared $200 cumulatively to that candidate; organizations appear at any amount.
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)

Link rowid 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
20412 20412 26129 FRIENDS OF FLOYD BONNER SHERIFF CAMPAIGN     1 organization   Memphis TN 38120 80433.68 2022-10-31 0 general 929 Year-End   2023 Floyd Bonner, Jr. Memphis Mayor
4637 4637 2771 FRIENDS OF HEIDI KUHN   Candidate Campaign Committee 1 organization   Cordova TN   39000.0 2025-07-16 0   12 Year-End Democratic 2026 Heidi Kuhn Shelby County Mayor
17943 17943 22696 FRIENDS OF CODY FLETCHER POSITION 1     1 organization   Memphis TN 38120 36033.72 2019-06-26 0 general 579 Q2   2019 Cody Fletcher Memphis City Council, Dist. 9, Pos. 3
21116 21116 27231 ESA DAVIS Retired Retired military 0 individual   Memphis TN 38106 33000.0 2022-09-01 0 general 850 Q4   2023 Latrena Davis Ingram Memphis Municipal Judge, Div. 2
23141 23141 35057 FRIENDS OF KAREN CAMPER N/A N/A 1 organization   Memphis TN 38116 33000.0 2023-03-31 0   802 Q1   2023 Karen Camper Memphis Mayor
1583 1583 1332 CHARLES INGRAM Medical Anesthesia Group Anesthesiologist 0 individual   Collierville TN 38017 29000.0   0 general 850 Q4   2023 Latrena Davis Ingram Memphis Municipal Judge, Div. 2
31143 31143 110983 JIM KYLE GOVERNOR     0 individual   MEMPHIS TN 38173 17000.0 2014-04-21 0 general 1071 Q2   2014 Jim Kyle Chancellor, Part II
18959 18959 24153 FRIENDS OF MARVIN WHITE DIST 9 POS 2 N/A N/A 1 organization   MEMPHIS TN 38120 13672.8 2019-07-19 0 general 591 Pre-General   2019 Marvin White Memphis City Council, Dist. 2
24703 24703 39605 FRIENDS OF MICHAEL WHALEY N/A N/A 1 organization   Memphis TN 38111 12079.0 2026-02-21 0 primary 947 Q1 Democratic 2026 Michael Whaley County Trustee
14181 14181 12400 LEE HARRIS STATE SENATE N/A N/A 1 organization   Memphis TN 38104 10530.95 2018-08-13 0   428 Q3 Democratic 2018 Lee Harris Shelby County Mayor
649 649 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 10100.0 2026-04-29 0 general 52 Q2 Democratic 2026 Amber Huett-Garcia Shelby County Commissioner, Dist. 13
650 650 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 10100.0 2026-04-23 0 primary 57 Pre-Primary Democratic 2026 Jevonte Porter Shelby County Commissioner, Dist. 12
4301 4301 2480 AFSCME LOCAL 1733   Labor Union (Public Workers) 1 organization   Memphis TN 38103 10100.0 2025-12-17 0   17 Year-End Democratic 2026 JB Smiley Shelby County Mayor
26642 26642 106910 MFA PAC Not Employed Not Employed 1 organization   Memphis TN 38120 10100.0 2026-06-22 0 primary 14 Q2 Democratic 2026 Mickell Lowery Shelby County Mayor
20012 20012 25699 JOSEPH OZMENT Law Office of Joseph S Attorney 0 individual   Memphis TN 38103 9791.53 2026-06-15 0 general 1013 Q2   2026 Joseph Ozment Criminal Court Judge, Div. VIII
9555 9555 7649 MEMPHIS FIRE FIGHTERS ASSOCIATION PAC Memphis Fire Fighters Association PAC 1 organization   Memphis TN 38134 9500.0 2025-11-17 0 general 332 Year-End   2027 Paul Young Memphis Mayor
9581 9581 7649 MEMPHIS FIRE FIGHTERS ASSOCIATION PAC Memphis Fire Fighters Association PAC 1 organization   Memphis TN 38134 9400.0 2023-07-25 0 general 929 Pre-General   2023 Floyd Bonner, Jr. Memphis Mayor
13056 13056 10564 EDUCATION REFORM NOW ADVOCACY     1 organization   Nashville TN 37212 9400.0 2023-09-19 0 general 331 Year-End   2023 Paul Young Memphis Mayor
22833 22833 34647 M PAC NA NA 1 organization   Memphis TN 38105 9400.0 2023-08-07 0 general 929 Pre-General   2023 Floyd Bonner, Jr. Memphis Mayor
24070 24070 37324 AMERICAN FEDERATION OF STATE COUNTY MUNICIPAL EMPLOYED     1 organization   Washington DC 20036 9400.0 2023-09-25 0   888 Pre-General   2023 Van Turner Memphis Mayor
24581 24581 39267 TENNESSEEANS FOR CLEAN ENERGY     1 organization   Knoxville TN 37921 9400.0 2023-08-29 0   888 Pre-General   2023 Van Turner Memphis Mayor
25376 25376 103242 THE CRUMP PAC     1 organization   Washington DC 20004 9400.0 2023-09-25 0   888 Pre-General   2023 Van Turner Memphis Mayor
646 646 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 9100.0 2026-05-05 0 primary 14 Q2 Democratic 2026 Mickell Lowery Shelby County Mayor
23996 23996 37242 LEGACY PAC Same PAC 1 organization   Memphis TN 38103 9100.0 2026-07-09 0 primary 14 Pre-General Democratic 2026 Mickell Lowery Shelby County Mayor
25402 25402 103302 FLORENCE HERVERY     0 individual   Memphis TN 38131 9000.0   1   21 Q1 Democratic 2026 Reginald Hubbard Sheriff
34869 34869 115366 CASE MANAGEMENT     1 organization   MEMPHIS TN 38131 9000.0 2025-06-30 1   21 Mid-Year Democratic 2026 Reginald Hubbard Sheriff
34870 34870 115366 CASE MANAGEMENT     1 organization   MEMPHIS TN 38131 9000.0 2025-12-30 1   21 Year-End Democratic 2026 Reginald Hubbard Sheriff
29572 29572 109919 TENNESSEE LEGISLATIVE CAMPAIGN COMMITTEE     1 organization   NASHVILLE TN 37212 8700.0 2012-05-21 1 general 1056 Q2   2012 Amy Weirich District Attorney General
25400 25400 103301 DARREN JACKSON   Owner 0 individual   Memphis TN 38114 8500.0 2025-06-30 1   21 Mid-Year Democratic 2026 Reginald Hubbard Sheriff
25401 25401 103301 DARREN JACKSON   Owner 0 individual   Memphis TN 38114 8500.0 2026-02-10 1   21 Q1 Democratic 2026 Reginald Hubbard Sheriff
34872 34872 115368 PRO SIGNS PRINT   Owner 0 individual   Memphis TN 38114 8500.0 2025-10-07 1   21 Year-End Democratic 2026 Reginald Hubbard Sheriff
23294 23294 35219 MEMPHIS POLICE ASSOC M PAC NA NA 1 organization   Memphis TN 38105 8400.0 2023-10-17 0   909 Pre-Runoff   2023 Jimmy Hassan Memphis City Council, Dist. 7
23514 23514 35654 MOVEMENT FOR JUSTICE Justice PAC PAC 1 organization   Memphis TN 38120 8400.0 2023-11-03 0   783 Pre-Runoff   2023 Jerri Green Memphis City Council, Dist. 2
23515 23515 35654 MOVEMENT FOR JUSTICE Justice PAC PAC 1 organization   Memphis TN 38120 8400.0 2023-11-02 0   851 Pre-Runoff   2023 Pearl Walker Memphis City Council, Dist. 3
23516 23516 35654 MOVEMENT FOR JUSTICE Justice PAC PAC 1 organization   Memphis TN 38120 8400.0 2023-11-02 0   915 Pre-Runoff   2023 Michalyn Easter-Thomas Memphis City Council, Dist. 7
653 653 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 8300.0 2022-06-24 0   295 Q2 Democratic 2022 Lee Harris Shelby County Mayor
657 657 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 8300.0 2022-04-08 0 primary 307 Pre-Primary Democratic 2022 Charlie A. Caswell, Jr. Shelby County Commissioner, Dist. 6
659 659 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 8300.0 2022-03-31 0 primary 310 Q1 Democratic 2022 Michael Whaley Shelby County Commissioner, Dist. 13
664 664 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 8300.0 2022-04-11 0 primary 338 Pre-Primary Democratic 2022 Britney Thornton Shelby County Commissioner, Dist. 10
665 665 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 8300.0 2022-05-16 0 general 504 Q2 Republican 2022 Amber Mills Shelby County Commissioner, Dist. 1
666 666 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 8300.0 2022-04-08 0 primary 512 Pre-Primary Republican 2022 Brandon Morrison Shelby County Commissioner, Dist. 4
667 667 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 8300.0 2022-04-08 0 primary 514 Pre-Primary Republican 2022 Mick Wright Shelby County Commissioner, Dist. 3
669 669 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 8300.0 2022-04-11 0   548 Pre-Primary Democratic 2022 Edmund Ford, Jr. Shelby County Commissioner, Dist. 9
675 675 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 8300.0 2022-06-24 0 general 813 Q2   2022 Amber Huett-Garcia County School Bd., Dist. 8
678 678 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 8300.0 2022-07-04 0 general 858 Pre-General   2022 Rachael Spriggs County School Bd., Dist. 1
9378 9378 7575 METROPOLITAN MEMPHIS HOTEL LODGING ASSOCIATION Metropolitan Memphis Hotel Association 1 organization   Memphis TN 38103 8300.0 2023-01-13 0 general 929 Year-End   2023 Floyd Bonner, Jr. Memphis Mayor
11973 11973 8938 LEADERSHIP FOR EDUCATIONAL EQUITY N/A NA 1 organization   New York NY 10004 8300.0 2022-07-11 0 general 338 Pre-General Democratic 2022 Britney Thornton Shelby County Commissioner, Dist. 10
13381 13381 11046 LEADERS IN EDUCATION FUND Leaders in Education Fund Education 1 organization   Washington DC 20001 8300.0 2022-07-11 0 general 310 Pre-General Democratic 2022 Michael Whaley Shelby County Commissioner, Dist. 13
13440 13440 11172 MML PAC N/A N/A 1 organization   Memphis TN 38125 8300.0 2023-01-15 0   888 Year-End   2023 Van Turner Memphis Mayor
17562 17562 22289 THE MEMPHIS INITIATIVE N/A N/A 1 organization   Memphis TN 38120 8300.0 2023-01-15 0 general 929 Year-End   2023 Floyd Bonner, Jr. Memphis Mayor
18809 18809 23863 BUILD PAC N/A N/A 1 organization   Memphis TN 38119 8300.0 2022-04-20 0 general 764 Q2   2022 David Parsons Bartlett Mayor
20950 20950 26814 TENNESSEE PROPERTY PAC     1 organization   Memphis TN 38134 8300.0 2022-04-07 0   883 Pre-Primary   2022 Althea Greene Shelby County Commissioner, Dist. 7
21145 21145 27272 TN USED CAR DEALERS PAC     1 organization   Franklin TN 37067 8300.0 2022-07-14 0   930 Pre-General   2022 Jeff Jacobs County Clerk
23280 23280 35219 MEMPHIS POLICE ASSOC M PAC NA NA 1 organization   Memphis TN 38105 8100.0 2019-10-16 0   584 Pre-Runoff   2019 Rhonda Logan Memphis City Council, Dist. 1
8810 8810 7007 STAND PAC OF TENNESSEE PAC PAC 1 organization   PORTLAND OR 97201 8000.0 2022-07-29 0   295 Q3 Democratic 2022 Lee Harris Shelby County Mayor
8811 8811 7007 STAND PAC OF TENNESSEE PAC PAC 1 organization   PORTLAND OR 97201 8000.0 2022-08-03 0 general 303 Q3 Democratic 2022 Shante Avant Shelby County Commissioner, Dist. 5
8817 8817 7007 STAND PAC OF TENNESSEE PAC PAC 1 organization   PORTLAND OR 97201 8000.0 2022-07-28 0 general 310 Q3 Democratic 2022 Michael Whaley Shelby County Commissioner, Dist. 13
8835 8835 7007 STAND PAC OF TENNESSEE PAC PAC 1 organization   PORTLAND OR 97201 8000.0 2022-07-27 0 general 1150 Pre-General   2022 Steven J. Mulroy District Attorney General
20947 20947 26804 STAND FOR CHILDREN TN Stand for Children Advocacy group 1 organization   Memphis TN 38104 8000.0 2022-08-02 0 general 277 Q3   2022 Timothy Green, Jr. County School Bd., Dist. 6
13389 13389 11046 LEADERS IN EDUCATION FUND Leaders in Education Fund Education 1 organization   Washington DC 20001 7800.0 2018-05-31 0 general 1053 Q2 Democratic 2018 Michael Whaley Shelby County Commissioner, Dist. 5
18145 18145 22990 MMHLAPAC N/A PAC 1 organization   MILLINGTON TN 38053 7800.0 2018-07-11 0 general 498 Pre-General Republican 2018 David Lenoir Shelby County Mayor
9565 9565 7649 MEMPHIS FIRE FIGHTERS ASSOCIATION PAC Memphis Fire Fighters Association PAC 1 organization   Memphis TN 38134 7600.0 2019-09-13 0 general 582 Pre-General   2019 Willie Herenton Memphis Mayor
26551 26551 106660 IAFF     0 individual   Memphis TN 38133 7600.0 2015-08-11 0 general 541 Pre-General   2015 Harold Collins Memphis Mayor
26559 26559 106670 INTN IAFF     0 individual   Washington DC 20006 7600.0 2015-09-14 0 general 541 Pre-General   2015 Harold Collins Memphis Mayor
19317 19317 24514 TENNESSEE REALTORS PAC N/A N/A 1 organization   Nashville TN 37212 7500.0 2019-09-11 0 general 590 Pre-General   2019 Jim Strickland Memphis Mayor
17560 17560 22289 THE MEMPHIS INITIATIVE N/A N/A 1 organization   Memphis TN 38120 7400.0   1   578 Pre-General   2019 Gerre Currie Memphis City Council, Dist. 8, Pos. 1
11972 11972 8938 LEADERSHIP FOR EDUCATIONAL EQUITY N/A NA 1 organization   New York NY 10004 7300.0 2022-03-24 0   338 Q1 Democratic 2022 Britney Thornton Shelby County Commissioner, Dist. 10
13380 13380 11046 LEADERS IN EDUCATION FUND Leaders in Education Fund Education 1 organization   Washington DC 20001 7300.0 2022-03-24 0 primary 310 Q1 Democratic 2022 Michael Whaley Shelby County Commissioner, Dist. 13
13386 13386 11046 LEADERS IN EDUCATION FUND Leaders in Education Fund Education 1 organization   Washington DC 20001 7300.0 2022-03-31 0 general 858 Q1   2022 Rachael Spriggs County School Bd., Dist. 1
3632 3632 2125 BELZ ENTERPRISES   Commercial Real Estate Developer 1 organization   Memphis TN 38173 7200.0 2025-11-17 0 general 332 Year-End   2027 Paul Young Memphis Mayor
31144 31144 110983 JIM KYLE GOVERNOR     0 individual   MEMPHIS TN 38173 7172.58 2014-08-28 0 general 1071 Q3   2014 Jim Kyle Chancellor, Part II
6991 6991 4553 OPTIMUM STUDIOS Friendship Church Pastor 0 individual   Memphis TN 38105 7100.0 2020-10-10 1   21 Year-End Democratic 2026 Reginald Hubbard Sheriff
6993 6993 4553 OPTIMUM STUDIOS Friendship Church Pastor 0 individual   Memphis TN 38105 7100.0 2025-06-30 1   21 Mid-Year Democratic 2026 Reginald Hubbard Sheriff
6994 6994 4553 OPTIMUM STUDIOS Friendship Church Pastor 0 individual   Memphis TN 38105 7100.0 2026-02-01 1   21 Q1 Democratic 2026 Reginald Hubbard Sheriff
13382 13382 11046 LEADERS IN EDUCATION FUND Leaders in Education Fund Education 1 organization   Washington DC 20001 7000.0 2022-04-12 0 primary 336 Year-End Democratic 2022 Miska Clay Bibbs Shelby County Commissioner, Dist. 11
17559 17559 22289 THE MEMPHIS INITIATIVE N/A N/A 1 organization   Memphis TN 38120 7000.0 2019-10-09 0 general 562 Q4   2019 Jeff Warren Memphis City Council, Dist. 9, Pos. 3
662 662 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 6900.0 2023-09-25 0 general 331 Year-End   2023 Paul Young Memphis Mayor
13388 13388 11046 LEADERS IN EDUCATION FUND Leaders in Education Fund Education 1 organization   Washington DC 20001 6800.0 2018-03-20 0 primary 1053 Q1 Democratic 2018 Michael Whaley Shelby County Commissioner, Dist. 5
24075 24075 37362 HBAT     0 individual   Nashville TN 37219 6800.0 2023-02-21 0   113 Mid-Year   2026 David Parsons Bartlett Mayor
26119 26119 105208 TALL CYPRESS LLC NA NA 1 organization   Germantown TN 38138 6800.0 2026-05-04 0 general 175 Q2 Democratic 2026 LaSonya Hall County Clerk
31096 31096 110960 TENNESSEE KEEP YOUR LEGISLATURE EFFICIENT PAC     1 organization   NASHVILLE TN 37204 6800.0 2014-07-18 0 general 1071 Pre-General   2014 Jim Kyle Chancellor, Part II
13220 13220 10882 COMMITTEE TO ELECT JESSE CHISM State of Tennessee Tennessee State Rep 1 organization   Memphis TN 38109 6650.0 2022-06-30 0   506 Q2 Democratic 2022 Regina Newman County Trustee
8819 8819 7007 STAND PAC OF TENNESSEE PAC PAC 1 organization   PORTLAND OR 97201 6600.0 2018-07-06 0   428 Pre-General Democratic 2018 Lee Harris Shelby County Mayor
19570 19570 24766 OUR CHOICE TN OUR CHILDREN PAC PAC 0 individual   New York City NY 10038 6400.0 2020-06-30 0 general 793 Q2   2022 Kristy Sullivan County School Bd., Dist. 4
8831 8831 7007 STAND PAC OF TENNESSEE PAC PAC 1 organization   PORTLAND OR 97201 6000.0 2018-04-18 0 primary 1053 Pre-Primary Democratic 2018 Michael Whaley Shelby County Commissioner, Dist. 5
8833 8833 7007 STAND PAC OF TENNESSEE PAC PAC 1 organization   PORTLAND OR 97201 6000.0 2018-07-06 0 primary 1053 Pre-General Democratic 2018 Michael Whaley Shelby County Commissioner, Dist. 5
11961 11961 8938 LEADERSHIP FOR EDUCATIONAL EQUITY N/A NA 1 organization   New York NY 10004 6000.0   0   1 Q1 Democratic 2026 John Luke Bradley Shelby County Commissioner, Dist. 10
25403 25403 103303 BEVERLY ROBERTSON Trust Marketing Owner 0 individual   Memphis TN 38103 5500.0   1   21 Q1 Democratic 2026 Reginald Hubbard Sheriff
34871 34871 115367 TRUST MARKETING COMMUNICATIONS INCORPORATED     1 organization   MEMPHIS TN 38103 5500.0 2025-06-30 1   21 Mid-Year Democratic 2026 Reginald Hubbard Sheriff
34873 34873 115370 TRUST MARKETING     1 organization   Memphis TN 38103 5500.0 2025-12-01 1   21 Year-End Democratic 2026 Reginald Hubbard Sheriff
8818 8818 7007 STAND PAC OF TENNESSEE PAC PAC 1 organization   PORTLAND OR 97201 5363.29 2019-09-23 0 general 345 Pre-General   2019 Darrick Dee Harris Memphis City Council, Dist. 8, Pos. 1
689 689 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 5100.0 2026-04-23 0 primary 947 Pre-Primary Democratic 2026 Michael Whaley County Trustee
671 671 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 5000.0 2023-09-01 0 general 783 Pre-General   2023 Jerri Green Memphis City Council, Dist. 2
672 672 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 5000.0 2023-11-03 0   783 Pre-Runoff   2023 Jerri Green Memphis City Council, Dist. 2
686 686 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 5000.0 2023-10-30 0   915 Pre-Runoff   2023 Michalyn Easter-Thomas Memphis City Council, Dist. 7
688 688 1186 TENNESSEE PROSPERITY PAC NA NA 1 organization   Memphis TN 38103 5000.0 2026-04-10 0 primary 947 Pre-Primary Democratic 2026 Michael Whaley County Trustee
2155 2155 1509 TENNESSEE HOSPITALITY TOURISM PAC NA NA 1 organization   Nashville TN 37214 5000.0 2025-05-28 0 primary 14 Mid-Year Democratic 2026 Mickell Lowery Shelby County Mayor
2301 2301 1533 COMCAST NA NA 1 organization   Philadelphia PA 19103 5000.0 2026-06-11 0 primary 14 Q2 Democratic 2026 Mickell Lowery Shelby County Mayor
5284 5284 3564 SOGIV FOUNDATION Not Employed Not Employed 1 organization   Memphis TN 38111 5000.0 2025-10-24 0 primary 14 Year-End Democratic 2026 Mickell Lowery Shelby County Mayor
8276 8276 6512 BCBS OF TN STATE PAC NA NA 1 organization   Chattanooga TN 37402 5000.0 2023-09-25 0 general 331 Year-End   2023 Paul Young Memphis Mayor

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

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. 'Memphis Mayor', 'Shelby County Mayor', 'District Attorney General', 'Sheriff'; names include the district, so match a whole chamber with LIKE 'Circuit Court Judge%', never =
);
CREATE INDEX idx_pc_pair ON public_contributions(canon_id, campaign_id);
CREATE INDEX idx_pc_campaign ON public_contributions(campaign_id);
Powered by Datasette · Queries took 1.2ms