Created
June 1, 2014 21:53
-
-
Save techieshark/7c9c47e271b76f20366b to your computer and use it in GitHub Desktop.
Oregon Campaign Finance Exploration
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| campaign_finance=# SELECT filer, ceil(SUM(amount))::text::money as total FROM raw_committee_transactions WHERE tran_date >= '2013-01-01' AND tran_date <= '2013-11-05' AND sub_type LIKE 'Cash Contribution' GROUP BY filer ORDER BY total; | |
| filer | total | |
| -------------------------------------------------------------------------------------+------------- | |
| Friends of LaVonne Griffin-Valade | $2.00 | |
| Voter Approval of Urban Renewal | $5.00 | |
| Limit City Debt | $5.00 | |
| Jeremy Ferguson for Mayor | $5.00 | |
| Friends of Sal Peralta | $9.00 | |
| New Covenant PAC | $10.00 | |
| Steve Thoroughman for Canby Fire Board | $25.00 | |
| Friends of Andrew Decker | $30.00 | |
| Committee to Elect Tim Bishop Coos County Commissioner Position #2 | $50.00 | |
| Coos County Republican Central Committee | $58.00 | |
| Bill Dant For Mayor Committee | $60.00 | |
| Common Sense for Oregon PAC | $82.00 | |
| Morrisette for Senate Committee | $100.00 | |
| Central Oregon Tea Party PAC / DBA Bend Tea Party | $100.00 | |
| Friends of Shawn Lindsay | $100.00 | |
| Sherwood Committee for Responsible Growth | $100.00 | |
| Cherryl Walker for BCC3 | $100.00 | |
| Oregon Right to Life Issues PAC | $100.00 | |
| Pacific NW Paint Council Pac | $100.00 | |
| Committee to Elect Bruce Altizer | $100.00 | |
| Committee to Elect Ed Truax | $100.00 | |
| Friends of Clackamas Community College | $100.00 | |
| ChamberPAC | $100.00 | |
| School Employees Exercising Democracy | $117.00 | |
| Friends of John Nelsen | $125.00 | |
| Clackamas Leadership Fund | $125.00 | |
| Friends of Glenn Miller | $140.00 | |
| Supporters of Katherine Schacht | $150.00 | |
| Kate Brown Committee | $150.00 | |
| Friends of Jenni Tan | $164.00 | |
| Harrington For Metro | $200.00 | |
| Friends of Roger Nyquist | $250.00 | |
| Dan Clem for Polk County | $250.00 | |
| Friends of Regan Molatore | $250.00 | |
| Jefferson County Republican Central Committee | $250.00 | |
| Registered Dental Hygienists' Political Action Committee | $250.00 | |
| Matheson for Tigard Tualatin Schools | $250.00 | |
| Washington County Business Council PAC | $250.00 | |
| Keep Lake Oswego Great | $250.00 | |
| Linn County Republican Central Committee | $280.00 | |
| The Committee to Elect Judge Vance Day | $300.00 | |
| SEED PAC | $300.00 | |
| Elect Mary Walston | $323.00 | |
| Alliance for Oregon's Elders | $450.00 | |
| Redmond Firefighters Association | $450.00 | |
| Citizens for Good Government | $500.00 | |
| Willamette Women Democrats PAC | $500.00 | |
| Keep Sheriff Turner | $500.00 | |
| Rick Kimball for School Board | $510.00 | |
| Oregon Association of Independent Accountants PAC | $525.00 | |
| Friends of Martha Schrader | $550.00 | |
| International Union of Operating Engineers Local 701 PAC | $557.00 | |
| Oregon Professional Fire Fighters PAC | $563.00 | |
| Oregon Anglers | $600.00 | |
| Hood River County Republican Central Committee | $625.00 | |
| People for Oregon Libraries Political Action Committee | $700.00 | |
| Oregon Trail Democrats | $730.00 | |
| susiejonesformhccboard | $747.00 | |
| Constitution Party of Oregon | $810.00 | |
| Basic Rights Oregon Measure PAC | $860.00 | |
| Neighbor Helping Neighbor | $870.00 | |
| ASK Damascus | $900.00 | |
| Asian American Coalition | $950.00 | |
| Friends of Sam Chase | $960.00 | |
| Citizens Alliance for Responsible Education | $996.00 | |
| Oregon School Employees Assoc. - Voice of Involved Classified Employees | $1,009.00 | |
| Delaney for LOSD | $1,010.00 | |
| Fire Fighters Political Acton Committee | $1,072.00 | |
| Friends of Linda Degman | $1,090.00 | |
| Cemetery Association of Oregon PAC | $1,100.00 | |
| Oregon Small Business Association PAC | $1,100.00 | |
| Citizens for Tony DeBone | $1,120.00 | |
| Workers' Compensation PAC | $1,125.00 | |
| Oregon Hunters Alliance | $1,125.00 | |
| ESP For County Commissioner | $1,150.00 | |
| Concerned Citizens of District 9 | $1,200.00 | |
| ABC Merit Shop Contractor PAC | $1,423.00 | |
| Polk County Democratic Central Committee | $1,425.00 | |
| Progressive Party | $1,472.00 | |
| Friends of Rich Vial | $1,475.00 | |
| Friends of Jackie Dingfelder | $1,520.00 | |
| Oregon Association of Defense Counsel State PAC | $1,565.00 | |
| Independent Oregon | $1,612.00 | |
| Oregon Manufactured Housing Political Support Committee | $1,775.00 | |
| Friends of Jeremy Ferguson | $1,835.00 | |
| Vote Greg Cody | $1,875.00 | |
| Oregon WheatPAC | $1,920.00 | |
| Friends of Michael P. Spasaro | $2,000.00 | |
| Wildfire Suppression PAC | $2,000.00 | |
| Lisa Christon for 4J School Board | $2,000.00 | |
| Committee To Elect Jill Halliburton | $2,049.00 | |
| Jay Bengel for BSD School Board | $2,055.00 | |
| Oregon Funeral Directors Association PAC | $2,066.00 | |
| Oregon Landscape Contractors Association PAC | $2,135.00 | |
| Citizens for OC Water | $2,215.00 | |
| Friends of Sherrie Sprenger | $2,250.00 | |
| The Need To Achieve | $2,270.00 | |
| Citizens For Open Honest Government | $2,300.00 | |
| Friends of Keith Steele | $2,306.00 | |
| Committee to Elect Don Chance | $2,320.00 | |
| Friends of Monmouth Police | $2,367.00 | |
| Curry County Republican Central Committee | $2,391.00 | |
| Central Oregonians for Affordable Housing | $2,400.00 | |
| Support Our Schools | $2,400.00 | |
| Gresham Professional Firefighters PAC | $2,450.00 | |
| IAFF #3564 PAC Fund | $2,500.00 | |
| Friends of Kim Thatcher | $2,500.00 | |
| Gail Whitsett for Oregon | $2,500.00 | |
| Friends of Greg Evans | $2,501.00 | |
| Oregon Rental Housing Key PAC | $2,545.00 | |
| Friends for Floyd Prozanski | $2,550.00 | |
| Oregon Association of Broadcasters Political Action Committee | $2,550.00 | |
| Oregon Sportsmens Association PAC | $2,587.00 | |
| Citizens for Corbett Schools | $2,825.00 | |
| Bend Business Political Action Committee | $2,900.00 | |
| Friends of Donna Tyner | $2,940.00 | |
| Oregon Pulp and Paper Political Action Committee | $3,000.00 | |
| Professional Insurance Agents of Oregon PAC | $3,130.00 | |
| PAC 483 | $3,153.00 | |
| Friends of Jim Campbell | $3,230.00 | |
| Friends of Fred Girod | $3,250.00 | |
| YES KCC | $3,250.00 | |
| Wayne Krieger for State Representative | $3,300.00 | |
| Committee to Re-elect Beth Gerot | $3,355.00 | |
| People for Libraries | $3,375.00 | |
| Oregon PA (Physician Assistants) PAC | $3,400.00 | |
| Citizens for a Safer Albany | $3,450.00 | |
| Friends of Angi Dilkes Perry | $3,450.00 | |
| Oregon Podiatry Political Action Committee | $3,525.00 | |
| Friends of Janet Carlson | $3,545.00 | |
| Strong Schools-Strong Community Bond Committee | $3,550.00 | |
| MAC PAC | $3,625.00 | |
| Friends of Faye | $3,650.00 | |
| Boone for State Representative | $3,750.00 | |
| Yamhill County Democratic Central Committee | $3,796.00 | |
| Fulton for Port Commission | $3,798.00 | |
| Northwest Sportfishing Industry Association PAC | $3,910.00 | |
| Yes for Cornelius Library | $3,980.00 | |
| Douglas County FireFighters PAC | $4,000.00 | |
| Committee to Elect Tim Josi | $4,000.00 | |
| Oregon Propane PAC | $4,000.00 | |
| Committee to Re-Elect Greg Smith | $4,000.00 | |
| Planned Parenthood PAC of Oregon | $4,070.00 | |
| Benton County Republican Central Committee | $4,080.00 | |
| North Marion 4 KIDS | $4,094.00 | |
| Susan Greenberg for Beaverton Schools | $4,106.00 | |
| Oregon Pharmacists Fund | $4,196.00 | |
| Oregon Insurance Political Action Committee | $4,230.00 | |
| Citizens for West Linn Pool and Rec Center | $4,308.00 | |
| Friends of Janeen Sollman | $4,390.00 | |
| Citizens for Continued Support of Schools | $4,400.00 | |
| Friends of Rod Monroe | $4,400.00 | |
| Friends of Silver Falls School District | $4,444.00 | |
| Oregon Dealer Political Action Committee | $4,450.00 | |
| Crown Political Action Committee | $4,456.00 | |
| Committee to re-elect Sharon Stiles LCC Board Zone 1 | $4,515.00 | |
| Oregon Association of Health Underwriters PAC | $4,596.00 | |
| Friends of Rich Cunningham | $4,643.00 | |
| Jerry Baker for Commissioner | $4,655.00 | |
| American Federation of State, County and Municipal Employees Local 3580 PAC | $5,000.00 | |
| American Federation of Teachers-Oregon Issue PAC | $5,000.00 | |
| North Clackamas Teacher's Politcal Action Committee | $5,006.00 | |
| Friends of Vivian Scott | $5,029.00 | |
| Committee to Elect Judge James C. Egan | $5,066.00 | |
| Committee to Elect Doug Whitsett | $5,109.00 | |
| Psychologists of Oregon PAC | $5,130.00 | |
| Linn County Democratic Central Committee | $5,131.00 | |
| Oregon Faculties Political Action Committee | $5,146.00 | |
| Eugene Education Association - PAC | $5,146.00 | |
| Friends of Erik Seligman | $5,185.00 | |
| Multnomah County Republican Central Committee | $5,266.00 | |
| Retain Dan Staton for Multnomah County Sheriff | $5,350.00 | |
| Citizens for Safe and Sound Schools | $5,391.00 | |
| Reardon for Oregon | $5,400.00 | |
| SMACNA PAC | $5,427.00 | |
| Committee to Elect Anne Bryan | $5,430.00 | |
| Clackamas County Republican Party | $5,630.00 | |
| Friends for Thuy Tran | $5,660.00 | |
| NWOregon Labor Council, Comm on Pol Ed Dept | $5,698.00 | |
| Springfield Professional Firefighters Association PAC | $5,700.00 | |
| Kevin Robertson for School Board | $5,780.00 | |
| Friends of Jim Bernard | $5,985.00 | |
| Pam Knowles for Schools | $6,085.00 | |
| The Committee To Elect Rick Dyer | $6,100.00 | |
| Josephine County Republican Central Committee | $6,332.00 | |
| build a pool newport | $6,450.00 | |
| Larry George for State Senate | $6,500.00 | |
| Friends of Bill Kennemer | $6,500.00 | |
| Low Income Dental Political Action Committee | $6,512.00 | |
| NAIFA-Oregon PAC | $6,549.00 | |
| Douglas County Democratic Central Committee | $6,653.00 | |
| Strong Schools for Springfield PAC | $6,705.00 | |
| Protect Marriage Oregon | $6,949.00 | |
| Citizens for Truth, Justice, and the American Way | $7,070.00 | |
| Michael T. Clarke Campaign | $7,168.00 | |
| Oregon Telecommunications Association PAC | $7,200.00 | |
| Albany's Right to Vote | $7,356.00 | |
| American Federation of Teachers-Oregon Candidate PAC | $7,379.00 | |
| Citizens for 911 | $7,450.00 | |
| Oregon Family Farm Association PAC | $7,470.00 | |
| Friends of Bill Bradbury | $7,500.00 | |
| Our Heritage PAC | $7,522.00 | |
| Benton County Democratic Central Committee | $7,670.00 | |
| Friends of Jaime Rodriguez | $7,690.00 | |
| Committee to Elect Gene Whisnant | $7,725.00 | |
| Support A Future for Education | $7,825.00 | |
| Taxpayers for a Better Grants Pass | $7,875.00 | |
| Take Back Damascus | $8,170.00 | |
| IEC Oregon Merit Shop Electrical PAC | $8,200.00 | |
| Committee to Elect Terry Fife | $8,284.00 | |
| Veterinarians Organized to Elect | $8,350.00 | |
| Carolyn Tomei for State Representative | $8,399.00 | |
| Friends of Jay Bozievich | $8,400.00 | |
| Boquist Leadership Fund | $8,500.00 | |
| National Federation of Independent Business\OR Save America's Free Enterprise Trust | $8,705.00 | |
| Fire Fighters Political Action Committee | $8,810.00 | |
| Paul Holvey for State Representative | $8,970.00 | |
| Friends of Chris Gorsek | $9,075.00 | |
| Committee for Enhanced Public Safety | $9,100.00 | |
| Committee to Elect John E. Huffman | $9,113.00 | |
| Make the Change | $9,300.00 | |
| Eugene Firefighters Fire PAC | $9,542.00 | |
| Friends of Vic Gilliam | $9,625.00 | |
| Oregon Financial Services Association PAC | $9,665.00 | |
| Oregon State Farm Agents and Associates PAC | $9,770.00 | |
| Beaverton Area Chamber of Commerce Political Action Committee | $10,000.00 | |
| Firmground for Kids | $10,090.00 | |
| Sisters Local Option Levy PAC | $10,230.00 | |
| Sarah Howell for School Board | $10,240.00 | |
| Friends Who Care and Love Albany | $10,296.00 | |
| Friends of Curry General Hospital | $10,332.00 | |
| Keep Portland Safe PAC | $10,384.00 | |
| YES for JC Schools | $10,388.00 | |
| Pacific Green Party of Oregon | $10,515.00 | |
| Gonzalez for School Board | $10,547.00 | |
| Eugene Cares for Neighbors and Community PAC | $10,705.00 | |
| Oregon Orthopedic Political Action Committee | $10,800.00 | |
| Curry PAC | $10,980.00 | |
| Restore | $11,368.00 | |
| Oregon Council of Police Associations - PAC | $11,876.00 | |
| Cliff Bentz for State Representative Committee | $11,950.00 | |
| SEIU Local 503, OPEU PAC | $12,067.00 | |
| Committee to Elect George Murdock | $12,475.00 | |
| Friends of Vicki Berger | $12,534.00 | |
| Oregon for Matt Keating | $12,559.00 | |
| American Council of Engineering Companies - Oregon PAC | $12,633.00 | |
| Oregon Firearms Federation PAC | $12,709.00 | |
| Oregon Leadership Initiative | $12,755.00 | |
| People for Pendleton Schools | $12,805.00 | |
| Friends of Corvallis | $13,130.00 | |
| Friends of Laurie Monnes Anderson | $13,250.00 | |
| Thomas Colett for Beaverton School Board | $13,380.00 | |
| Beaverton Teachers Political Action Committee | $13,486.00 | |
| Yes for Polk County Public Safety | $13,545.00 | |
| Friends of Joe Gallegos | $13,550.00 | |
| Friends of Huma Pierce | $14,031.00 | |
| Keep Prisoners in Jail | $14,279.00 | |
| Buel for School Board | $14,450.00 | |
| Friends of Kali | $14,611.00 | |
| Teachers Voice in Politics | $14,771.00 | |
| Citizens for School Support | $15,000.00 | |
| Nick Fish for City Council | $15,050.00 | |
| Friends of Jeff Barker | $15,200.00 | |
| Tillamook County Citizens For Sustainable Roads | $15,385.00 | |
| Bend Tourism, Arts, and Public Safety Initiative | $15,411.00 | |
| Friends of Keizer Fire District PAC | $15,550.00 | |
| Portlanders for Schools | $15,925.00 | |
| Committee to Elect Sal Esquivel | $16,032.00 | |
| Portland Metropolitan Association of Realtors PAC | $16,632.00 | |
| Oregon Forest Industries Council Political Action Committee | $17,000.00 | |
| Fair Deal PAC | $17,000.00 | |
| Freedom and Responsibility PAC | $17,092.00 | |
| Committee to Elect John Lively for State Representative, Dist. 12 | $17,133.00 | |
| Oregon Petroleum Association PAC | $17,215.00 | |
| Oregon Family Council PAC | $17,694.00 | |
| Rosenbaum for Senate (Diane) | $18,000.00 | |
| Brad Witt for State Representative | $18,400.00 | |
| Friends of Ginny Burdick | $18,580.00 | |
| Northwest Grocery Assoc. PAC | $18,851.00 | |
| Professional Firefighters PAC #3219 | $18,878.00 | |
| Friends of Nancy Nathanson | $19,083.00 | |
| Oregonians for Clem | $19,250.00 | |
| ParkPAC | $19,326.00 | |
| Citizens for Klamath County Schools | $19,510.00 | |
| Committee to Elect Shemia Fagan | $19,885.00 | |
| Oregon Truck PAC | $20,350.00 | |
| Oregon League of Conservation Voters PAC | $20,376.00 | |
| Friends of Chris Garrett | $20,560.00 | |
| Jerry Jones For THPRD | $20,565.00 | |
| Friends of Jennifer Williamson | $20,575.00 | |
| Friends of Julie Parrish | $21,350.00 | |
| Friends of Chris Edwards | $21,900.00 | |
| Friends of Blue Mountain Community College | $22,465.00 | |
| Yes For Schools | $23,227.00 | |
| Corrections Political Action Committee | $23,261.00 | |
| Police Officers Lobbying in Common Effort | $23,381.00 | |
| Friends of Tim Freeman | $23,445.00 | |
| Oregon Medical PAC | $23,452.00 | |
| Portland Metro Fire Fighters PAC | $23,771.00 | |
| Ben Unger for Oregon | $23,810.00 | |
| Friends of Brent Barton | $24,153.00 | |
| Friends of Michael Dembrow | $24,255.00 | |
| Friends of Ted Wheeler | $25,011.00 | |
| Oregon Concrete & Aggregate Producers Association PAC | $25,352.00 | |
| Local #1159 FirePAC | $26,290.00 | |
| Oregon Transformation Project PAC | $26,300.00 | |
| Friends of Mark Hass | $26,375.00 | |
| Friends of Tobias Read | $27,340.00 | |
| Caddy McKeown for Representative | $27,375.00 | |
| Citizens Committee for Disincorporation | $27,626.00 | |
| Shirley Craddick for METRO Councilor | $27,655.00 | |
| Friends of Dan Saltzman | $28,200.00 | |
| Courtney, Peter, for State Senate | $29,150.00 | |
| Friends of Andy Duyck | $30,100.00 | |
| Oregon Opportunity Initiative PAC | $30,350.00 | |
| Foresight Ophthalmology Political Action Committee | $32,538.00 | |
| Alliance - PAC | $32,764.00 | |
| Committee to Re-Elect Peter Buckley | $32,982.00 | |
| Friends of Ted Ferrioli | $33,000.00 | |
| Oregon Automobile Dealers Association - Political Action Committee | $33,720.00 | |
| Building a Better Oregon | $35,000.00 | |
| Tom Koehler for School Board | $35,445.00 | |
| AG-PAC | $36,300.00 | |
| Parent's Education Association P.A.C. | $37,628.00 | |
| Oregon Family Council Issues PAC | $38,227.00 | |
| Friends of Lee Beyer | $38,750.00 | |
| Friends of Lake Oswego Schools | $39,045.00 | |
| Amalgamated Transit Union 757 Political Fund | $40,000.00 | |
| Oregonians in Action PAC | $40,311.00 | |
| International Brotherhood of Electrical Workers Local 280 PAC | $40,665.00 | |
| Create Jobs PAC | $41,925.00 | |
| Citizens for Hillsboro Schools | $42,105.00 | |
| The Doctors Company Oregon Political Action Committee | $42,477.00 | |
| Plumbers & Steamfitters PAC | $42,738.00 | |
| Orloggers PAC | $43,037.00 | |
| Bruce Starr for State Senate Committee | $43,110.00 | |
| Oregon Optometric Public Affairs Council | $43,534.00 | |
| Friends of Mark Johnson | $43,560.00 | |
| Committee to Elect Dr. Alan Bates | $43,972.00 | |
| CenturyLink Oregon Employees' Political Action Committee | $44,911.00 | |
| Peter Courtney for State Senate | $47,150.00 | |
| Joint Council of Teamsters No. 37 Political Fund | $47,499.00 | |
| Oregon Neighborhood Store Association Political Action Committee | $50,125.00 | |
| Friends of Arnie Roblan | $52,000.00 | |
| Friends of Richard Devlin | $52,613.00 | |
| Committee to Elect Brad Avakian | $53,217.00 | |
| Oregon Republican Party | $53,537.00 | |
| Stand for Children Oregon PAC | $53,875.00 | |
| Oregon Action Committee for Rural Electrification | $54,642.00 | |
| Farmer's Employee and Agent PAC of Oregon | $55,178.00 | |
| Yes on 26-152 To Restore Our Natural Areas, a project of The Conservation Campaign | $61,200.00 | |
| Professional Adjusters Interested In Democracy | $62,588.00 | |
| Taxpayers Association of Oregon PAC | $63,052.00 | |
| Oregonians for Affordable Housing | $65,280.00 | |
| The Leadership Fund | $67,960.00 | |
| Oregon Farm Bureau Political Action Committee | $69,600.00 | |
| Oregon Bankers PAC | $74,563.00 | |
| Oregonians to Maintain Community Standards | $75,783.00 | |
| Regence Oregon Political Action Committee | $80,000.00 | |
| Friends of Tom Hughes | $83,450.00 | |
| Citizens for Schools | $85,117.00 | |
| Yes on 20-213 | $92,177.00 | |
| Friends of Val Hoyle | $95,961.00 | |
| Natural Gas Political Action Committee | $100,000.00 | |
| Friends of Jules | $100,206.00 | |
| Libraries Yes! Committee | $100,500.00 | |
| Friends of Tina Kotek | $104,691.00 | |
| Working Families Party of Oregon | $120,267.00 | |
| Promote Oregon Leadership PAC | $133,471.00 | |
| Associated Oregon Industries PAC | $142,565.00 | |
| Portland General Electric Employee Candidate Assistance Fund | $145,000.00 | |
| Oregon Right to Life PAC | $147,394.00 | |
| Doctors for Healthy Communities | $150,000.00 | |
| Democratic Party of Oregon | $151,697.00 | |
| Nurses United Political Action Committee | $155,491.00 | |
| Senate Democratic Leadership Fund | $163,602.00 | |
| Service Employees Int'L Union Local 49 Committee on Political Education | $185,741.00 | |
| ORLAPAC | $203,438.00 | |
| Dentists of Oregon PAC | $211,835.00 | |
| Yes for Beaverton Schools | $215,036.00 | |
| Clean Water Portland | $230,578.00 | |
| Future PAC, House Builders | $252,120.00 | |
| Restore Our Natural Areas | $278,476.00 | |
| Oregon PERS Retirees PAC | $307,201.00 | |
| Committee for Safe and Successful Children | $389,425.00 | |
| Local 48 Electricians PAC | $417,814.00 | |
| Healthy Kids, Healthy Portland | $797,461.00 | |
| (387 rows) |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
@meli-lewis sweet!