$ $ $ Who FundsMemphis
Races Donors Vendors Starting Points What's New Bulk Data About
Tennessee
Races Donors Vendors Starting Points What's New Bulk Data About Tennessee

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
20245 20245 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
4627 4627 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
17789 17789 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
20947 20947 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
22964 22964 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
1579 1579 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
30961 30961 110983 JIM KYLE GOVERNOR     0 individual   MEMPHIS TN 38173 17000.0 2014-04-21 0 general 1071 Q2   2014 Jim Kyle Chancellor, Part II
18803 18803 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
24526 24526 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
14030 14030 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
646 646 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
647 647 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
4291 4291 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
26463 26463 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
19847 19847 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
9528 9528 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
9554 9554 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
12907 12907 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
22656 22656 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
23894 23894 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
24404 24404 39267 TENNESSEEANS FOR CLEAN ENERGY     1 organization   Knoxville TN 37921 9400.0 2023-08-29 0   888 Pre-General   2023 Van Turner Memphis Mayor
25199 25199 103242 THE CRUMP PAC     1 organization   Washington DC 20004 9400.0 2023-09-25 0   888 Pre-General   2023 Van Turner Memphis Mayor
643 643 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
23820 23820 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
25225 25225 103302 FLORENCE HERVERY     0 individual   Memphis TN 38131 9000.0   1   21 Q1 Democratic 2026 Reginald Hubbard Sheriff
34685 34685 115366 CASE MANAGEMENT     1 organization   MEMPHIS TN 38131 9000.0 2025-06-30 1   21 Mid-Year Democratic 2026 Reginald Hubbard Sheriff
34686 34686 115366 CASE MANAGEMENT     1 organization   MEMPHIS TN 38131 9000.0 2025-12-30 1   21 Year-End Democratic 2026 Reginald Hubbard Sheriff
29390 29390 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
25223 25223 103301 DARREN JACKSON   Owner 0 individual   Memphis TN 38114 8500.0 2025-06-30 1   21 Mid-Year Democratic 2026 Reginald Hubbard Sheriff
25224 25224 103301 DARREN JACKSON   Owner 0 individual   Memphis TN 38114 8500.0 2026-02-10 1   21 Q1 Democratic 2026 Reginald Hubbard Sheriff
34688 34688 115368 PRO SIGNS PRINT   Owner 0 individual   Memphis TN 38114 8500.0 2025-10-07 1   21 Year-End Democratic 2026 Reginald Hubbard Sheriff
23118 23118 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
23338 23338 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
23339 23339 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
23340 23340 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
650 650 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
654 654 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
656 656 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
661 661 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
662 662 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
663 663 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
664 664 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
666 666 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
672 672 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
675 675 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
9351 9351 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
11850 11850 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
13231 13231 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
13290 13290 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
17407 17407 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
18653 18653 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
20781 20781 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
20976 20976 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
23104 23104 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
8782 8782 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
8783 8783 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
8789 8789 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
8807 8807 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
20778 20778 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
13239 13239 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
17991 17991 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
9538 9538 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
26372 26372 106660 IAFF     0 individual   Memphis TN 38133 7600.0 2015-08-11 0 general 541 Pre-General   2015 Harold Collins Memphis Mayor
26380 26380 106670 INTN IAFF     0 individual   Washington DC 20006 7600.0 2015-09-14 0 general 541 Pre-General   2015 Harold Collins Memphis Mayor
19157 19157 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
17405 17405 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
11849 11849 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
13230 13230 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
13236 13236 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
3623 3623 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
30962 30962 110983 JIM KYLE GOVERNOR     0 individual   MEMPHIS TN 38173 7172.58 2014-08-28 0 general 1071 Q3   2014 Jim Kyle Chancellor, Part II
6974 6974 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
6976 6976 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
6977 6977 4553 OPTIMUM STUDIOS Friendship Church Pastor 0 individual   Memphis TN 38105 7100.0 2026-02-01 1   21 Q1 Democratic 2026 Reginald Hubbard Sheriff
13232 13232 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
17404 17404 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
659 659 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
13238 13238 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
23899 23899 37362 HBAT     0 individual   Nashville TN 37219 6800.0 2023-02-21 0   113 Mid-Year   2026 David Parsons Bartlett Mayor
25940 25940 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
30914 30914 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
13070 13070 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
8791 8791 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
19405 19405 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
8803 8803 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
8805 8805 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
11838 11838 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
25226 25226 103303 BEVERLY ROBERTSON Trust Marketing Owner 0 individual   Memphis TN 38103 5500.0   1   21 Q1 Democratic 2026 Reginald Hubbard Sheriff
34687 34687 115367 TRUST MARKETING COMMUNICATIONS INCORPORATED     1 organization   MEMPHIS TN 38103 5500.0 2025-06-30 1   21 Mid-Year Democratic 2026 Reginald Hubbard Sheriff
34689 34689 115370 TRUST MARKETING     1 organization   Memphis TN 38103 5500.0 2025-12-01 1   21 Year-End Democratic 2026 Reginald Hubbard Sheriff
8790 8790 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
686 686 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
668 668 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
669 669 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
683 683 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
685 685 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
2149 2149 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
2295 2295 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
5270 5270 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
8249 8249 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