monetary_contributions

FPPC Form 460, Schedule A

Data source: A_Contributions

53 rows where filer_id = 111 sorted by report_date descending

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: report_date, report_start_date, report_end_date, entity_type, city, state, zipcode, employer, occupation, transaction_date, transaction_amt, year_to_date, committee_id, report_date (date), report_start_date (date), report_end_date (date), election_date (date), transaction_date (date)

Link rowid filer_id filer_name report_date ▲ report_start_date report_end_date election_date transaction_id entity_type last_name first_name prefix city state zipcode employer occupation self_employed transaction_type transaction_date transaction_amt year_to_date transaction_description committee_id memo_reference_number
36663 36663 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2018-01-14 2017-07-01 2017-12-31 2018-11-06 EXP214 IND Chris Adair   San Carlos CA 94070 Textainer Group 5972 Vice President n R 2017-12-31 -800 0      
36664 36664 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2018-01-14 2017-07-01 2017-12-31 2018-11-06 INC168 IND Fisher Bruce   San Francisco CA 94127   Not Employed n   2017-07-17 150 150      
36665 36665 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2018-01-14 2017-07-01 2017-12-31 2018-11-06 INC169 COM International Federation of Professional and Technical Engineers Local 21 TJ Anthony PAC Fund     San Francisco CA 94103     n   2017-07-17 1500 1500   31.0  
36666 36666 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2018-01-14 2017-07-01 2017-12-31 2018-11-06 INC167 IND James Earl   San Francisco CA 94117 EKI Environment & Water, Inc. 5973 Vice President n   2017-07-17 800 800      
36667 36667 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2018-01-14 2017-07-01 2017-12-31 2018-11-06 INC171 SCC Peace Officers Research Association Of California PAC     Sacramento CA 95834     n   2017-07-27 500 500   223.0  
36668 36668 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2018-01-14 2017-07-01 2017-12-31 2018-11-06 INC179 OTH Schnitzer Steel Industries     Portland OR 97296     n   2017-08-22 800 800      
36669 36669 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2018-01-14 2017-07-01 2017-12-31 2018-11-06 INC190 IND Vennari Andrew   Oakland CA 94619 Sequoia Diner 5974 Proprietor n   2017-10-03 500 500      
38300 38300 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC140 IND Adair Todd   San Carlos CA 94070 BKF Engineers 1475 Civil Engineer n   2017-06-28 800 800      
38301 38301 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC80 IND Beros Elizabeth   Oakland CA 94618 Jordan Real Estate 6324 Chief Operating Officer n   2017-06-13 800 800      
38302 38302 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC63 IND Brisson Elizabeth   Oakland CA 94612 San Francisco Municipal Transportation Agency 4637 Transportation Planner n   2017-06-05 100 100      
38303 38303 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC148 IND Brown Stevens Amanda   Oakland CA 94610 Self Employed 90 Healthcare Consultant n   2017-06-22 400 400      
38304 38304 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC69 IND Bryce Herrington   Oakland CA 94610 Renew Financial Group 6325 Finance Consultant n   2017-06-05 500 500      
38305 38305 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC122 COM Build Jobs PAC     Walnut Creek CA 94597     n   2017-06-21 1500 1500   266.0  
38306 38306 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC147 IND Campbell Dave   Oakland CA 94612 Bike East Bay 2131 Advocacy Director n   2017-06-22 100 100      
38307 38307 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC146 IND Chris Adair   San Carlos CA 94070 Textainer Group 5972 Vice President n   2017-06-23 800 800      
38308 38308 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC131 IND Connell Raymond   Oakland CA 94611 Holland Partner Group 4579 Acquisition And Development Manager n   2017-06-21 250 250      
38309 38309 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC151 IND Devries Francisco   Piedmont CA 94611 Renew Financial 4755 Chief Executive Officer n   2017-06-22 800 800      
38310 38310 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC145 OTH DK Consulting     Walnut Creek CA 94596     n   2017-06-29 250 250      
38311 38311 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC130 IND DuBois Faith   Oakland CA 94611   Retired n   2017-06-21 100 100      
38312 38312 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC78 IND Gerber Ed   Oakland CA 94611   Retired n   2017-06-07 500 500      
38313 38313 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC143 IND Gooding John   Emeryville CA 94608 Principal 6326 Quadric Group, Inc. n   2017-06-29 800 800      
38314 38314 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC129 IND Guarino Tom   Pleasant Hill CA 94523 Pacific Gas & Electric 2353 Director n   2017-06-21 250 250      
38315 38315 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC121 IND Hood Heather   Oakland CA 94610 Enterprise Community Partners 2061 City Making n   2017-06-21 200 200      
38316 38316 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC87 COM International Association Of Firefighters Local 55     Oakland CA 94612     n   2017-06-12 800 800   59.0  
38317 38317 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC109 IND Johnson Eric   Los Angeles CA 90046 Oakland Housing Authority 3921 Executive Director n   2017-06-19 100 100      
38318 38318 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC152 IND Kidd Christopher   Oakland CA 94612 Arup 5311 Planner n   2017-06-22 100 100      
38319 38319 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC144 OTH KPW Structural Engineers     Oakland CA 94607     n   2017-06-29 250 250      
38320 38320 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC77 IND Linzer Juliette   Oakland CA 94610 Self Employed 90 Management Consultant n   2017-06-07 100 100      
38321 38321 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC76 IND Mailman Josh   Oakland CA 94610 Social Venture Network 6327 Executive n   2017-06-07 100 100      
38322 38322 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC149 IND Meyers James   Alameda CA 94501 Self Employed 90 Healthcare Consultant n   2017-06-22 300 300      
38323 38323 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC71 COM Oakland Police Officers Association PAC     Oakland CA 94607     n   2017-06-05 800 800   222.0  
38324 38324 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC67 IND Pelosi Alexis   Oakland CA 94610 Pelosi Law Group 5197 Attorney n   2017-06-05 800 800      
38325 38325 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC139 OTH PES Environmental, Inc.     Novato CA 94945     n   2017-06-27 250 250      
38326 38326 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC66 IND Renaud Mia   Los Angeles CA 90066 Law Offices Of Mia Renaud, Esq. 6328 Immigration Lawyer n   2017-06-05 100 100      
38327 38327 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC127 IND Rickles Rena   Oakland CA 94612 Rickles Law 6329 Attorney n   2017-06-21 250 250      
38328 38328 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC70 IND Rudney Eric   Alamo CA 94507 Rudney Associates 1755 Financial Advisor n   2017-06-02 500 500      
38329 38329 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC150 IND Saltzman Rebecca   Oakland CA 94611 California League Of Conservation Voters 2187 Government Affairs Manager n   2017-06-22 100 100      
38330 38330 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC124 IND Sharp Charlotte   Oakland CA 94611 Kaiser Permanente 137 Director n   2017-06-21 100 100      
38331 38331 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC108 IND Simpson Gail   Oakland CA 94610 Opera Frontier 6330 Founder n   2017-06-21 500 500      
38332 38332 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC100 OTH Smith LLP     Oakland CA 94612     n   2017-06-15 250 250      
38333 38333 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC123 IND Spees John   Oakland CA 94611 Granite Capital Management 6331 Principal n   2017-06-21 800 800      
38334 38334 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC132 IND Stevens Michael   Alameda CA 94501   Retired n   2017-06-21 250 250      
38335 38335 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC128 OTH The McConnell Group     Oakland CA 94612     n   2017-06-21 800 800      
38336 38336 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC126 IND Wayland John   Danville CA 94526 Holland Partner Group 4579 Real Estate n   2017-06-21 250 250      
38337 38337 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC125 OTH YHLA Architects     Oakland CA 94612     n   2017-06-21 800 800      
38338 38338 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC120 IND Zahas Eugene   Oakland CA 94602 Johnstone Supply 105 Executive n   2017-06-21 800 800      
38339 38339 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC48 IND Zweiback Margaret   Oakland CA 94610 Self Employed 90 Nurse Practitioner n   2017-05-30 250 250      
38340 38340 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2017-07-10 2017-01-01 2017-06-30 2018-11-06 INC45 IND Zweiback Robert   Oakland CA 94610 Wendel, Rosen, Black & Dean, LLP 6332 Attorney n   2017-05-30 250 250      
22818 22818 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2016-01-22 2015-07-01 2015-12-31 2018-11-06 INC13 COM Bay Area Citizens PAC     Emeryville CA 94608     n   2015-09-25 700 700   83.0  
22819 22819 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2016-01-22 2015-07-01 2015-12-31 2018-11-06 INC11 IND Cohen Victoria   San Francisco CA 94114 San Francisco Unified School District 2548 Teacher n   2015-09-25 700 700      
22820 22820 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2016-01-22 2015-07-01 2015-12-31 2018-11-06 INC14 IND Eagan Annie   Oakland CA 94607 Annie Eagan Consulting 3973 Owner n   2015-09-25 100 100      
22821 22821 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2016-01-22 2015-07-01 2015-12-31 2018-11-06 INC10 COM International Association Of Firefighters Local 55     Oakland CA 94612     n   2015-09-25 700 700   59.0  
22822 22822 1376660 111 Annie Campbell Washington for Oakland City Council 2018 120 2016-01-22 2015-07-01 2015-12-31 2018-11-06 INC12 COM Oakland Police Officers Association PAC     Oakland CA 94607     n   2015-09-25 700 700   222.0  

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "monetary_contributions" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "last_name" TEXT,
  "first_name" TEXT,
  "prefix" INTEGER,
  "city" TEXT,
  "state" TEXT,
  "zipcode" TEXT,
  "employer" INTEGER,
  "occupation" TEXT,
  "self_employed" TEXT,
  "transaction_type" INTEGER,
  "transaction_date" TEXT,
  "transaction_amt" INTEGER,
  "year_to_date" INTEGER,
  "transaction_description" INTEGER,
  "committee_id" TEXT,
  "memo_reference_number" INTEGER
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
    FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id),
    FOREIGN KEY ("employer") REFERENCES [businesses](id));
CREATE INDEX ["monetary_contributions_filer_id"] ON [monetary_contributions]("filer_id");
CREATE INDEX ["monetary_contributions_filer_name"] ON [monetary_contributions]("filer_name");
CREATE INDEX ["monetary_contributions_committee_id"] ON [monetary_contributions]("committee_id");
CREATE INDEX ["monetary_contributions_employer"] ON [monetary_contributions]("employer");