Skip to content

Instantly share code, notes, and snippets.

@techieshark
Created June 2, 2014 02:08
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save techieshark/873cf67120414723ee7d to your computer and use it in GitHub Desktop.
Save techieshark/873cf67120414723ee7d to your computer and use it in GitHub Desktop.
2013 Oregon Political Spenders
# Biggest spenders in Oregon Politics, in 2013.
# spender: the candidate or PAC
# freq: the number of times they gave to another candidate or PAC
# total: the sum of all contributions the spender made to another candidate or PAC
# using the database found here: https://github.com/hackoregon/backend
campaign_finance=# SELECT contributor_payee AS spender, COUNT(amount) as Freq, ceil(SUM(amount))::text::money as Total FROM raw_committee_transactions WHERE sub_type LIKE 'Cash Contribution' AND contributor_payee_committee_id IS NOT NULL AND tran_date >= '2013-01-01' AND tran_date <= '2013-12-31' GROUP BY spender ORDER BY total DESC;
spender | freq | total
---------------------------------------------------------------------------------+------+-------------
Dentists of Oregon PAC (54) | 17 | $118,462.00
Local 48 Electricians PAC (4572) | 51 | $106,064.00
Oregon Health Care Association PAC (275) | 43 | $88,971.00
Friends of Tina Kotek (4792) | 8 | $87,750.00
Friends of Val Hoyle (13967) | 11 | $66,450.00
AGC Committee for Action (4) | 26 | $65,500.00
Doctors for Healthy Communities (5493) | 40 | $53,901.00
Oregon Hospital Political Action Committee (161) | 25 | $52,951.00
Friends of Laurie Monnes Anderson (3584) | 5 | $47,625.00
Douglas County Physicians PAC (12848) | 36 | $47,401.00
Citizens for Good Government (15334) | 1 | $37,625.00
Oregon Medical PAC (171) | 29 | $36,136.00
Committee to Re-Elect Peter Buckley (4824) | 5 | $31,250.00
Oregon Optometric Public Affairs Council (176) | 47 | $28,209.00
Natural Gas Political Action Committee (102) | 34 | $27,165.00
Portland General Electric Employee Candidate Assistance Fund (2480) | 22 | $26,600.00
Tonkon Torp State PAC (11748) | 25 | $26,424.00
Rosenbaum for Senate (Diane) (1430) | 3 | $25,500.00
Courtney, Peter, for State Senate (470) | 2 | $25,000.00
Beaverton Teachers Political Action Committee (17) | 4 | $24,920.00
Credit Union Legislative Action Fund (51) | 44 | $24,633.00
Foresight Ophthalmology Political Action Committee (66) | 43 | $24,564.00
Regence Oregon Political Action Committee (73) | 19 | $23,709.00
Oregon Action Committee for Rural Electrification (117) | 21 | $23,250.00
Senate Democratic Leadership Fund (1471) | 3 | $22,900.00
Coalition for a Healthy Oregon PAC (15808) | 23 | $22,446.00
Oregon Realtors Political Action Committee (191) | 17 | $21,000.00
Friends of Chris Garrett (12511) | 5 | $20,750.00
Oregon Soft Drink PAC (197) | 26 | $18,212.00
Service Employees Int'L Union Local 49 Committee on Political Education (4213) | 8 | $18,000.00
Oregonians for Clem (5133) | 3 | $17,700.00
Friends of Arnie Roblan (4726) | 6 | $16,975.00
Future PAC, House Builders (1524) | 7 | $16,245.00
Orloggers PAC (11) | 9 | $16,000.00
Caddy McKeown for Representative (15298) | 4 | $15,600.00
ORLAPAC (193) | 10 | $15,577.00
Oregonians in Action PAC (2793) | 4 | $15,500.00
Owner-Operators of Oregon PAC (4507) | 11 | $15,462.00
Oregon Bankers PAC (125) | 15 | $15,250.00
Committee to Elect Mike McLane (13635) | 2 | $15,000.00
Friends of Chip Shields (4741) | 2 | $15,000.00
Nathanson, Nancy, Friends of (5152) | 2 | $15,000.00
Read, Tobias, Friends of (5208) | 2 | $15,000.00
Oregon Association of Broadcasters Political Action Committee (3100) | 26 | $14,000.00
Friends of Shawn Lindsay (13866) | 3 | $13,655.00
Metro Multifamily Housing Association PAC (14041) | 12 | $13,000.00
Cable Operators Political Action Committee (26) | 27 | $12,694.00
Teachers Voice in Politics (260) | 1 | $12,000.00
Oregon Trial Lawyers Association PAC (39) | 4 | $12,000.00
International Brotherhood of Electrical Workers Local 280 PAC (5214) | 13 | $11,792.00
Northwest Grocery Assoc. PAC (152) | 12 | $11,500.00
Oregon Forest Industries Council Political Action Committee (154) | 6 | $11,500.00
Friends of Katie Eyre (14349) | 4 | $11,250.00
Oregon Farm Bureau Political Action Committee (147) | 10 | $11,000.00
Hillsboro Chamber of Commerce PAC (15577) | 3 | $10,000.00
Oregon Beverage PAC (126) | 16 | $9,850.00
Oregon Refuse and Recycling Association PAC (2829) | 17 | $8,750.00
Building Trades PAC (12845) | 20 | $8,712.00
Coalition for a Healthy Oregon (4749) | 9 | $8,455.00
Committee to Elect Brad Avakian (4152) | 4 | $8,350.00
Stand for Children Oregon PAC (5207) | 8 | $8,250.00
Friends of Patrick Sheehan (14052) | 4 | $8,000.00
Oregon Neighborhood Store Association Political Action Committee (3428) | 7 | $8,000.00
American Council of Engineering Companies - Oregon PAC (4016) | 27 | $7,962.00
Amalgamated Transit Union 757 Political Fund (3094) | 13 | $7,732.00
Oregon Business Association PAC (3073) | 14 | $7,727.00
Nurses United Political Action Committee (12987) | 2 | $7,500.00
Ben Unger for Oregon (15238) | 6 | $7,051.00
Friends of Bruce Hanna (4752) | 3 | $7,000.00
Oregon Nurses Political Action Committee (12986) | 12 | $6,970.00
Davis Wright Tremaine Client PAC (Oregon) (5425) | 9 | $6,674.00
Friends of Elizabeth Steiner Hayward (15255) | 4 | $6,550.00
FirstVote PAC (4311) | 14 | $6,500.00
Friends of Jeff Barker (4270) | 5 | $6,500.00
Friends of Jules (12498) | 4 | $6,500.00
Oregon Winegrowers PAC (3161) | 14 | $6,500.00
Professional Adjusters Interested In Democracy (228) | 12 | $6,201.00
Oregon Transformation Project PAC (12633) | 2 | $6,000.00
Oregon Truck PAC (266) | 5 | $6,000.00
Eugene Firefighters Fire PAC (60) | 4 | $6,000.00
Building a Better Oregon (1948) | 2 | $6,000.00
Low Income Dental Political Action Committee (3598) | 2 | $5,989.00
Veterinarians Organized to Elect (274) | 13 | $5,932.00
Friends of Mark Hass (11487) | 3 | $5,750.00
Oregon School Employees Association Chapter 1 | 1 | $5,500.00
Multifamily NW PAC (14041) | 9 | $5,482.00
Elect Betty Komp (4241) | 2 | $5,250.00
Friends of Richard Devlin (1670) | 2 | $5,250.00
Oregon Council of National Electrical Contractors Association Chapter PAC (135) | 13 | $5,250.00
Elect Ellen Rosenblum for Attorney General (15406) | 6 | $5,125.00
Cliff Bentz for State Representative Committee (11508) | 1 | $5,000.00
Oregonians to Maintain Community Standards (1579) | 1 | $5,000.00
Friends of Ginny Burdick (5434) | 1 | $5,000.00
Committee to Elect Gene Whisnant (4653) | 1 | $5,000.00
Oregonians for Affordable Housing (2069) | 5 | $5,000.00
Greenlick, Mitch, for State Legislature (3362) | 2 | $5,000.00
Friends of Greg Matthews (12891) | 2 | $5,000.00
Associated Oregon Industries PAC (10) | 6 | $5,000.00
Healthy Teeth for a Lifetime (6485) | 1 | $5,000.00
Friends of Vicki Berger (4112) | 1 | $5,000.00
Kitzhaber 2010 (13920) | 1 | $5,000.00
BOMA Oregon (4554) | 8 | $5,000.00
Alliance - PAC (4797) | 7 | $5,000.00
Friends of Margaret Doherty (13907) | 2 | $5,000.00
Committee to Elect John E. Huffman (11708) | 1 | $5,000.00
American Federation of Teachers-Oregon Candidate PAC (113) | 3 | $4,500.00
Beaverton Area Chamber of Commerce Political Action Committee (15103) | 2 | $4,500.00
Oregon Orthopedic Political Action Committee (2963) | 9 | $4,450.00
Oregon Education Association - People for Improvement of Education (142) | 3 | $4,400.00
CenturyLink Oregon Employees' Political Action Committee (273) | 9 | $4,300.00
Friends of Jackie Dingfelder (4090) | 5 | $4,250.00
Friends of Alissa Keny-Guyer (15237) | 2 | $4,150.00
Oregon Telecommunications Association PAC (163) | 10 | $4,000.00
John Davis For Oregon (15858) | 3 | $4,000.00
Qwest Oregon Employees' Political Action Committee (273) | 4 | $4,000.00
Friends of Bill Kennemer (5885) | 3 | $4,000.00
Oregon Criminal Defense Lawyers Assn PAC (138) | 4 | $4,000.00
Friends of Bob Stacey (13836) | 5 | $3,800.00
Oregon Petroleum Association PAC (2717) | 9 | $3,700.00
Friends of Michael Dembrow (10967) | 3 | $3,500.00
Oregon Winegrowers' PAC (3161) | 4 | $3,500.00
Friends of Ted Wheeler (5591) | 3 | $3,500.00
Oregon Pharmacists Fund (3781) | 5 | $3,470.00
Friends of Tobias Read (5208) | 10 | $3,425.00
Oregon Dealer Political Action Committee (12943) | 15 | $3,300.00
Oregon Technology PAC (14490) | 5 | $3,250.00
Oregon Financial Services Association PAC (5115) | 2 | $3,250.00
Oregon Certified Public Accountants Legislative Action Committee (130) | 3 | $3,000.00
Iron Workers District Council of the Pacific Northwest (3816) | 2 | $3,000.00
Friends of Tom Hughes (14060) | 2 | $3,000.00
Friends of Sherrie Sprenger (12916) | 1 | $3,000.00
Oregon Cattle PAC (5410) | 1 | $3,000.00
Oregon Restaurant PAC (193) | 4 | $2,817.00
Friends of Rod Park (5715) | 2 | $2,750.00
ParkPAC (217) | 6 | $2,750.00
Oregon Right to Life PAC (416) | 2 | $2,750.00
Plumbing & Mechanical Contractors Assoc. Political Action Fund (3137) | 6 | $2,732.00
Springfield Professional Firefighters Association PAC (4937) | 2 | $2,645.00
Kevin Cameron for Oregon (5089) | 1 | $2,500.00
Oregon Ambulatory Surgery Center Association (13571) | 7 | $2,500.00
Oregon Nurse Anesthetists PAC (3099) | 1 | $2,500.00
Dentists of Oregon PAC (54) | 1 | $2,500.00
Citizens for Jim Thompson (4681) | 1 | $2,500.00
Oregon Ambulatory Surgery Center Association PAC (13571) | 4 | $2,500.00
Oregon Podiatry Political Action Committee (182) | 5 | $2,470.00
Committee to Elect John Lively for State Representative, Dist. 12 (15519) | 6 | $2,200.00
Committee to Elect Jason Conger (13926) | 1 | $2,000.00
Oregon Family Council Issues PAC (5446) | 1 | $2,000.00
Friends of Julie Parrish (14592) | 1 | $2,000.00
Friends of Mark Johnson (14277) | 1 | $2,000.00
Tomei, Carolyn, for State Representative (3545) | 1 | $2,000.00
Oregon Council of Police Associations - PAC (136) | 5 | $1,800.00
Mitch Greenlick for State Legislature (3362) | 3 | $1,750.00
Friends to Re-elect Mayor Denny Doyle (12631) | 2 | $1,750.00
IEC Oregon Merit Shop Electrical PAC (14942) | 2 | $1,750.00
Friends of Joe Gallegos (15859) | 3 | $1,700.00
Friends of Jennifer Williamson (15145) | 3 | $1,600.00
Friends of Scott Hansen (15396) | 1 | $1,500.00
Taxpayers for a Better Grants Pass (12475) | 1 | $1,500.00
Oregon Local Grocery Committee (152) | 2 | $1,500.00
Keep Sheriff Turner (15221) | 1 | $1,500.00
Oregon Nurseries Political Action Committee (175) | 3 | $1,500.00
Eugene Education Association - PAC (59) | 1 | $1,500.00
Oregon Pulp and Paper Political Action Committee (3936) | 1 | $1,500.00
ChiroPAC (14575) | 3 | $1,500.00
Alex Gardner for DA (10767) | 1 | $1,500.00
Coalition Against the Costly Labeling Law (4460) | 1 | $1,500.00
Linn County Republican Central Committee (329) | 2 | $1,500.00
Oregon Leadership Initiative (16230) | 2 | $1,500.00
Oregon Family Farm Association PAC (3597) | 1 | $1,500.00
Osteopathic Political Action Committee (212) | 2 | $1,459.00
Oregon Aging & Disability Services Political Action Committee (13619) | 5 | $1,400.00
Oregon for Matt Keating (16192) | 2 | $1,375.00
Communities for Oregonians With Disabilities (944) | 5 | $1,289.00
Pam Knowles for Schools (13648) | 3 | $1,250.00
Surplus Line Insurance PAC (4556) | 4 | $1,250.00
SMACNA PAC (3917) | 3 | $1,250.00
Friends of Brent Barton (12493) | 2 | $1,250.00
Oregon Hunters Alliance (4014) | 3 | $1,250.00
Mid-Valley Affordable Housing Coalition (2070) | 1 | $1,250.00
Oregon Psychiatrists Political Action Committee (190) | 4 | $1,189.00
Taxpayers Association of Oregon PAC (3889) | 2 | $1,100.00
Friends of Chris Edwards (5158) | 2 | $1,000.00
Joint Council of Teamsters No. 37 Political Fund (80) | 1 | $1,000.00
Portland Metropolitan Association of Building Owners and Managers PAC (4554) | 2 | $1,000.00
Oregon Certified Public Accountants Legislative Action Committee (130) | 1 | $1,000.00
Friends of Donna Tyner (16242) | 1 | $1,000.00
Friends of Lew Barnes (15610) | 1 | $1,000.00
Kate Brown Committee (931) | 1 | $1,000.00
Commercial Association of Brokers PAC (5576) | 1 | $1,000.00
Susan Greenberg for Beaverton Schools (16219) | 1 | $1,000.00
Oregon Landscape Contractors Association PAC (2894) | 3 | $1,000.00
Oregon Coast Electrical PAC (16073) | 1 | $1,000.00
Standard Insurance Company Political Action Committee (State) (257) | 2 | $1,000.00
SEIU Local 503, OPEU PAC (2102) | 1 | $1,000.00
ABC Merit Shop Contractor PAC (14944) | 2 | $1,000.00
Coastal Conservation Oregon PAC (13873) | 1 | $1,000.00
Re-Elect John Wendland (16336) | 1 | $944.00
Alliance for Oregon's Elders (5203) | 4 | $932.00
Committee to Elect Floyd W. Collins (13313) | 2 | $929.00
Washington County Business Council PAC (15611) | 3 | $900.00
Friends of Sam Chase (15293) | 5 | $825.00
Verizon Employees Good Government Club of Oregon (261) | 1 | $809.00
Holton for Oregon (15425) | 2 | $800.00
Plumbers and Steamfitters PAC (221) | 2 | $750.00
Oregon Concrete & Aggregate Producers Association PAC (134) | 2 | $750.00
Friends of Naturopathic Medicine (69) | 2 | $750.00
Gomberg for State Rep (15348) | 2 | $750.00
Jaramillo for Commissioner Committee (9686) | 2 | $725.00
Wallowa County Democratic Central Committee (4825) | 1 | $642.00
Multnomah County Democratic Central Committee (335) | 2 | $585.00
Friends for Floyd Prozanski (1686) | 2 | $532.00
Friends of Rod Underhill (14943) | 1 | $500.00
Conkling Fiskum & Mccormick Political Action Committee (2731) | 1 | $500.00
Oregon Concrete & Aggregate Producers Assn PAC (134) | 2 | $500.00
Friends of Vic Gilliam (5690) | 1 | $500.00
Natural Gas Political Action Committee (102) | 1 | $500.00
Stand for Children PAC (5207) | 1 | $500.00
Committee to Elect Shemia Fagan (14993) | 1 | $500.00
Friends of Joe Pishioneri (15658) | 1 | $500.00
Friends of Jay Bozievich (13965) | 1 | $500.00
Housing Alliance PAC (12545) | 2 | $500.00
Credit Union Legislative Action Fund (51) | 1 | $500.00
Conkling Fiskum & McCormick Inc. (2731) | 1 | $500.00
Plumbers & Steamfitters PAC (221) | 2 | $500.00
Committee to Re-Elect Greg Smith (3420) | 1 | $500.00
Portland Metropolitan Association of Realtors PAC (6165) | 1 | $500.00
Cable Operators Political Action Committee (26) | 1 | $500.00
Oregon Outdoor Advertising Political Action Committee (15388) | 2 | $500.00
PAC 483 (1869) | 1 | $500.00
Portland Metro Fire Fighters PAC (223) | 1 | $500.00
Oregon Bankers PAC (125) | 1 | $500.00
Professional Adjusters Interested In Democracy (228) | 1 | $500.00
NWOregon Labor Council, Comm on Pol Ed Dept (108) | 3 | $500.00
Friends of Naturopathic Medicine (69) | 1 | $500.00
Committee to Elect Anne Bryan (16220) | 1 | $500.00
National Utility Contractors Association of Oregon & SW Washington PAC (4747) | 1 | $500.00
Friends of Lee Beyer (14049) | 2 | $450.00
Pacific NW Paint Council Pac (3614) | 2 | $450.00
Friends of Don Arbuckle (16035) | 1 | $437.00
Polk County Democratic Central Committee (337) | 2 | $412.00
Wasco County Republican Central Committee (347) | 1 | $405.00
Baker County Republican Central Committee (290) | 1 | $405.00
Crook County Republican Central Committee (14679) | 1 | $405.00
Friends of Chris Gorsek (14515) | 2 | $400.00
Friends of Ted Ferrioli (3215) | 1 | $400.00
Tootie Smith for Clackamas County Commissioner (15207) | 2 | $385.00
Friends of Lew Frederick (13997) | 2 | $375.00
Reardon for Oregon (15621) | 2 | $375.00
Kitty Piercy for Mayor (6031) | 1 | $355.00
Friends of Jessica Vega Pederson (15330) | 1 | $350.00
Committee to Elect Tim Josi (5786) | 2 | $350.00
Yes on 82 & 83 (15892) | 1 | $350.00
Daniels for Oregon (15125) | 2 | $300.00
Committee to Re-elect Beth Gerot (16261) | 1 | $282.00
Local #1159 FirePAC (229) | 2 | $275.00
Northwest Sportfishing Industry Association PAC (5192) | 1 | $250.00
Friends of Randy Uchytil (12873) | 1 | $250.00
Friends of Ryan Deckert (2423) | 1 | $250.00
Oregon Council of NECA Chapters (135) | 1 | $250.00
Oregon Mortgage Broker PAC (2549) | 1 | $250.00
Oregon Liberty PAC (16342) | 1 | $250.00
Monroe, Rod, Friends of (5319) | 1 | $250.00
Friends of Katie Eyre (14349) | 1 | $250.00
Oregon Propane PAC (2803) | 1 | $250.00
International Brotherhood of Electrical Workers Local 280 PAC (5214) | 1 | $250.00
Tim Knapp for Mayor (13037) | 1 | $250.00
Oregon Refuse and Recycling Association PAC (2829) | 1 | $250.00
Friends of Greg Macpherson (15485) | 1 | $250.00
Oregon Faculties Political Action Committee (145) | 1 | $250.00
Oregon Medical PAC (171) | 1 | $250.00
Alliance 4 Kids (13628) | 1 | $213.00
Friends of Nancy Nathanson (5152) | 1 | $200.00
Matt Morton for Portland Schools (14940) | 1 | $200.00
Greg for Schools (14933) | 1 | $200.00
Richardson, Dennis, Citizens to Elect (4155) | 1 | $170.00
Friends of Jenni Tan (14552) | 1 | $164.00
Coburn for Councilor (15957) | 1 | $154.00
Democratic Party of Lane County (324) | 1 | $150.00
People for Oregon Libraries Political Action Committee (167) | 1 | $150.00
Columbia County Republican Central Committee (298) | 1 | $135.00
Yamhill County Republicans (351) | 1 | $135.00
Claire Syrett for Eugene City Council (15938) | 1 | $125.00
Clean Water Portland Referendum Committee (16027) | 1 | $122.00
Bill Wehr for Damascus City Council (15908) | 1 | $120.00
Clackamas County Democratic Central Committee (293) | 1 | $112.00
Columbia County Democratic Central Committee (297) | 1 | $112.00
Friends of Herman Baertschiger (15469) | 1 | $40.00
(288 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment