Organization & PAC donors

Organizational givers only (no individual floor applies to them).

Custom SQL query returning 100 rows (hide) 

select donor_name, sum(amount) as total_given,
       count(distinct campaign_id) as recipients
from public_contributions
where is_organization = 1
group by canon_id
order by total_given desc
limit 100

Edit SQL

This data as json, CSV

donor_nametotal_givenrecipients
TENNESSEE PROSPERITY PAC 159730.0 31
TENNESSEE REALTORS PAC 94500.0 43
FRIENDS OF FLOYD BONNER SHERIFF CAMPAIGN 80433.68 1
MEMPHIS FIRE FIGHTERS ASSOCIATION PAC 72750.0 30
BELZ ENTERPRISES 71950.0 49
STAND PAC OF TENNESSEE 58411.61 12
MEMPHIS POLICE ASSOC M PAC 53900.0 23
JOBS PAC 48500.0 14
LEADERS IN EDUCATION FUND 40500.0 4
MMHLAPAC 39800.0 13
FARRIS BOBANGO PLC PAC 30200.0 43
METROPOLITAN MEMPHIS HOTEL LODGING ASSOCIATION 28300.0 15
LEADERSHIP FOR EDUCATIONAL EQUITY 23364.91 5
EVANS PETREE PAC 23300.0 30
LEGACY PAC 21000.0 6
RETIREMENT COMPANIES OF AMERICA 20600.0 27
DRIVE COMMITTEE 20500.0 11
FEDEX CORPORATION PAC 19000.0 9
TENNESSEE REALTORS POLITICAL ACTION 19000.0 7
BUILD PAC 18550.0 11
MEMPHIS RESTAURANT ASSOCIATION PAC 18500.0 12
M PAC 18400.0 4
CIGNA PAC 18200.0 13
CIGNA GROUP EMPLOYEE PAC 17400.0 14
BUILD PAC 17000.0 15
BCBS OF TN STATE PAC 15000.0 10
West TN Chapter Associated Builders & Contractors PAC 13750.0 25
LEADERSHIP FOR EDUCATIONAL EQUITY 12750.0 3
METROPOLITAN MEM HOTEL LODGING PAC 12300.0 3
HEDGEPETH FOR COUNCIL 12250.0 8
MAKOWSKY RINGEL GREENBERG LLC 12050.0 11
IBEW PAC EDUCATIONAL FUND 11500.0 4
AFSCME LOCAL 1733 10100.0 1
COMCAST PAC 10000.0 2
TEAMSTERS LOCAL 667 10000.0 5
CAMP PAC 9900.0 2
TENNESSEE HOSPITALITY TOURISM PAC 9500.0 2
EDUCATION REFORM NOW ADVOCACY 9400.0 1
BCBS OF TN STATE PAC 9000.0 11
AUTOZONE INC COMMITTEE FOR A BETTER GOV 8750.0 9
FRIENDS OF JIM STRICKLAND 8500.0 18
MOVEMENT FOR JUSTICE 8400.0 1
TENNESSEE PROPERTY PAC 8300.0 1
TN USED CAR DEALERS PAC 8300.0 1
MML PAC 8300.0 1
COMCAST CORPORATION 8000.0 7
VALERO PAC 8000.0 4
STAND FOR CHILDREN TN 8000.0 1
LEE FUND 8000.0 3
METAPROJECT RESOURCES LLC 7300.0 6
BLUECROSS BLUESHIELD OF TENNESSEE PAC 7250.0 7
TENNESSEANS FOR PUTTING STUDENTS FIRST 7000.0 3
LEADERSHIP FOR EDUCATIONAL EQUITY LEADERS IN EDUCATION FUND 7000.0 1
MERAMAC SPECIALTY COMPANY 7000.0 14
FRIENDS OF A C WHARTON 6800.0 12
WELLS AND ASSOCIATES PLLC 6650.0 2
COMMERCIAL ADVISORS LLC 6600.0 8
THE AC WHARTON GROUP LLC 6450.0 14
CAPITOL CITY RESIDENTIAL HEALTH CARE 6400.0 3
S R CONSULTING LLC 6300.0 12
MDM INVESTMENTS OF MEMPHIS LLC 6000.0 5
ASIAN AMERICAN HOTEL/MOTEL ASSOCIATION OF SHELBY COUNTY 6000.0 2
MEMPHIS ARES ASSOCIATION OF REALTORS 6000.0 2
SAMMONS HOLDING COMPANY LLC 6000.0 5
SCRWC PAC 5700.0 6
COUCH REALTY INVESTMENTS LLC 5600.0 2
STEAMFITTERS LOCAL UNION 614 5500.0 2
CANALE FOR COUNCIL 5350.0 7
WRIGHT GRAY LLC 5300.0 6
901 PEOPLE POWER PAC 5250.0 3
RESTAURANT CONSULTING LLC 5100.0 3
CURRIE FOR COUNCIL 5000.0 12
SOGIV FOUNDATION 5000.0 1
FRIENDS OF KEMP CONRAD 5000.0 10
BUTLER SNOW GOOD TO GREAT PAC 5000.0 1
MARSHA PAC 5000.0 1
COMMUNICATION WORKERS OF AMERICA POLITICAL ACTION 5000.0 1
SERVICE EMPLOYEES INTERNATIONAL UNION LOCAL 205 5000.0 1
1199 SEIU NEW YORK STATE PAC 5000.0 1
TN FOR PUTTING STUDENT FIRST 5000.0 1
EDUCATION REFORM NOW ADVOCACY INC 5000.0 1
TN PROSPER PAC 5000.0 1
AFSCME UNION 5000.0 1
TENNESSEE PROSPERITY PAC 5000.0 1
CRISP REAL ESTATE LLC 4900.0 3
KIMERY WEALTH MANAGEMENT LLC 4900.0 2
NGP VAN INC 4746.75 1
LEADERSHIP IN EDUCATION FUND 4500.0 1
FARNSWORTH INVESTMENT COMPANY 4350.0 4
UNIVERSAL COMMERCIAL REAL ESTATE 4300.0 3
HARRIS FOR COUNTY MAYOR 4250.0 7
REEDY COMPANY REALTORS LLC 4250.0 4
THE REDWIG GROUP LLC 4250.0 5
ASHAUN LLC 4050.0 9
THE PROSPER PAC 4000.0 1
INTERNATIONAL BROTHERHOOD OF TEAMSTERS DRIVE COMMITTEE 4000.0 1
HOWARD FRANKIE ALPER FOUNDATION 4000.0 1
FEDEX PAC 4000.0 4
UNITED FOR PROGRESS 4000.0 2
PAUL ROSE FOR SENATE 4000.0 5