on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

261 rows where filer_name = 87 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, payee_last_name, payee_city, payee_state, payee_zipcode, expenditure_type, expenditure_description, report_date (date), report_start_date (date), report_end_date (date), election_date (date), expenditure_date (date)

Link rowid filer_id filer_name committee_type report_date ▲ report_start_date report_end_date election_date transaction_id entity_type payee_last_name payee_first_name payee_prefix payee_suffix payee_city payee_state payee_zipcode expenditure_date expenditure_amt year_to_date expenditure_type expenditure_description committee_id candidate_last_name candidate_first_name candidate_prefix candidate_suffix office_sought office_jurisdiction district_number incumbent ballot_measure_name ballot_measure_number ballot_measure_jurisdiction support_or_oppose memo_reference_number
903 903 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   PDT141 OTH Kingston 11 Cuisine       Oakland CA 94612 2015-01-03 350.75 350.75 MTG 1/3/15, Fundraising Event, 15, Candidate   Guillen Abel     CCM City of Oakland 2.0            
904 904 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   PDT149 OTH Naleo Educational Fund       Los Angeles CA 90015 2015-05-24 600 600 CVC     Guillen Abel     CCM City of Oakland 2.0            
905 905 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   PDT143 OTH NationBuilder       Los Angeles CA 90013 2015-01-17 557 632 WEB     Guillen Abel     CCM City of Oakland 2.0            
906 906 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   EDT43 OTH NationBuilder       Los Angeles CA 90013 2015-02-17 557 632 WEB     Guillen Abel     CCM City of Oakland 2.0            
907 907 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   PDT145 OTH NationBuilder       Los Angeles CA 90013 2015-02-25 -557 632 WEB Refund   Guillen Abel     CCM City of Oakland 2.0            
908 908 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   PDT146 OTH NationBuilder       Los Angeles CA 90013 2015-02-25 -557 632 WEB Refund   Guillen Abel     CCM City of Oakland 2.0            
909 909 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   EDT44 OTH NationBuilder       Los Angeles CA 90013 2015-03-17 158 632 WEB     Guillen Abel     CCM City of Oakland 2.0            
910 910 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   PDT147 OTH NationBuilder       Los Angeles CA 90013 2015-04-17 158 632 WEB     Guillen Abel     CCM City of Oakland 2.0            
911 911 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   PDT148 OTH NationBuilder       Los Angeles CA 90013 2015-05-17 158 632 WEB     Guillen Abel     CCM City of Oakland 2.0            
912 912 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   PDT152 OTH NationBuilder       Los Angeles CA 90013 2015-06-30 158 632 WEB     Guillen Abel     CCM City of Oakland 2.0            
913 913 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-07-21 2015-01-01 2015-06-30   EDT47 IND Fearn Jeffrey     Oakland CA 94610 2015-05-22 350 350   Refund of Contribution   Guillen Abel     CCM City of Oakland 2.0            
376 376 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   EDT36 OTH U.S. Postmaster       Oakland CA 94615 2014-10-23 3483.07 14401.78 POS     Guillen Abel     CCM City of Oakland 2.0            
377 377 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   EDT40 OTH Cam Huong Restaurant       Oakland CA 94606 2014-10-20 21.8 425.7 OFC     Guillen Abel     CCM City of Oakland 2.0            
378 378 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT104 OTH Cam Huong Restaurant       Oakland CA 94606 2014-11-04 74.75 425.7 OFC     Guillen Abel     CCM City of Oakland 2.0            
379 379 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT87 OTH Cana Cuban Parlor and Cafe       Oakland CA 94610 2014-10-31 241.73 241.73 FND Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
380 380 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT125 OTH Chai Thai Noodles       Oakland CA 94606 2014-11-18 45.83 372.11 OFC     Guillen Abel     CCM City of Oakland 2.0            
381 381 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT81 OTH Comcast       Seattle WA 98124 2014-10-30 363.88 1364.46 OFC     Guillen Abel     CCM City of Oakland 2.0            
382 382 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT134 OTH Comcast       Seattle WA 98124 2014-12-16 594.4 1364.46 OFC     Guillen Abel     CCM City of Oakland 2.0            
383 383 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   EDT41 OTH Domino's Pizza       Oakland CA 94610 2014-10-20 54.13 251.63 OFC 10/20/14, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
384 384 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT80 OTH Domino's Pizza       Oakland CA 94610 2014-10-28 57 251.63 OFC 10/28/14, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
385 385 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT103 OTH Domino's Pizza       Oakland CA 94610 2014-11-04 100.75 251.63 OFC 11/04/14, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
386 386 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT94 OTH Facebook, Inc       Menlo Park CA 94025 2014-11-03 50.33 295.8 WEB     Guillen Abel     CCM City of Oakland 2.0            
387 387 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT131 OTH Facebook, Inc       Menlo Park CA 94025 2014-11-30 213.3 295.8 WEB     Guillen Abel     CCM City of Oakland 2.0            
388 388 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT74 OTH FedEx       Oakland CA 94621 2014-10-27 40 187.43 OFC     Guillen Abel     CCM City of Oakland 2.0            
389 389 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT90 OTH FedEx       Oakland CA 94621 2014-11-02 21.25 187.43 OFC     Guillen Abel     CCM City of Oakland 2.0            
390 390 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT109 OTH FedEx       Oakland CA 94621 2014-11-05 41.89 187.43 OFC     Guillen Abel     CCM City of Oakland 2.0            
391 391 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT121 OTH FedEx       Oakland CA 94621 2014-11-14 40.29 187.43 OFC     Guillen Abel     CCM City of Oakland 2.0            
392 392 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT128 OTH FedEx       Oakland CA 94621 2014-11-22 25 187.43 OFC     Guillen Abel     CCM City of Oakland 2.0            
393 393 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT72 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-10-23 32.19 978.93 OFC     Guillen Abel     CCM City of Oakland 2.0            
394 394 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT73 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-10-25 27.34 978.93 OFC     Guillen Abel     CCM City of Oakland 2.0            
395 395 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT84 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-10-31 30.17 978.93 OFC     Guillen Abel     CCM City of Oakland 2.0            
396 396 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT85 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-10-31 19.04 978.93 OFC     Guillen Abel     CCM City of Oakland 2.0            
397 397 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT105 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-11-04 4.63 978.93 OFC     Guillen Abel     CCM City of Oakland 2.0            
398 398 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT110 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-11-05 613.79 978.93 MTG Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
399 399 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT111 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-11-05 53.5 978.93 MTG Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
400 400 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT118 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-11-05 23.37 978.93 MTG Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
401 401 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT119 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-11-11 40 978.93 MTG Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
402 402 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT124 OTH NationBuilder       Los Angeles CA 90013 2014-11-17 557 1630 WEB     Guillen Abel     CCM City of Oakland 2.0            
403 403 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT138 OTH NationBuilder       Los Angeles CA 90013 2014-12-17 557 1630 WEB     Guillen Abel     CCM City of Oakland 2.0            
404 404 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT79 OTH Office Depot       Oakland CA 94601 2014-10-27 204.76 1893.13 OFC     Guillen Abel     CCM City of Oakland 2.0            
405 405 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT132 OTH Office Depot       Oakland CA 94601 2014-11-06 -487.58 1893.13 OFC     Guillen Abel     CCM City of Oakland 2.0            
406 406 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT135 OTH PG&E       Sacramento CA 95899 2014-12-16 183.95 1319.18 OFC     Guillen Abel     CCM City of Oakland 2.0            
407 407 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT136 OTH PG&E       Sacramento CA 95899 2014-12-16 165.94 1319.18 OFC     Guillen Abel     CCM City of Oakland 2.0            
408 408 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT99 OTH PoliticalCalling.com       Davis CA 95616 2014-11-03 289.68 289.68 PHO     Guillen Abel     CCM City of Oakland 2.0            
409 409 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT82 OTH Safeway       Oakland CA 94611 2014-10-29 22.97 114.02 OFC     Guillen Abel     CCM City of Oakland 2.0            
410 410 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT114 OTH Safeway       Oakland CA 94611 2014-11-06 30 114.02 OFC     Guillen Abel     CCM City of Oakland 2.0            
411 411 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT115 OTH Saigon Printing       Oakland CA 94606 2014-11-08 40.33 588.1 LIT     Guillen Abel     CCM City of Oakland 2.0            
412 412 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   EDT38 OTH Shell Oil       Gonzales LA 70737 2014-10-21 25 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            
413 413 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT66 OTH Shell Oil       Gonzales LA 70737 2014-10-24 15 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            
414 414 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT67 OTH Shell Oil       Gonzales LA 70737 2014-10-24 13.04 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            
415 415 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT68 OTH Shell Oil       Gonzales LA 70737 2014-10-24 30 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            
416 416 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT78 OTH Shell Oil       Gonzales LA 70737 2014-10-27 7.18 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            
417 417 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT83 OTH Shell Oil       Gonzales LA 70737 2014-10-29 10.11 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            
418 418 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT86 OTH Shell Oil       Gonzales LA 70737 2014-10-31 12.59 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            
419 419 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT100 OTH Shell Oil       Gonzales LA 70737 2014-11-03 25 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            
420 420 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT88 OTH Smart & Final       Oakland CA 94607 2014-11-01 23.36 217.22 OFC     Guillen Abel     CCM City of Oakland 2.0            
421 421 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT102 OTH Smart & Final       Oakland CA 94607 2014-11-04 131.47 217.22 OFC     Guillen Abel     CCM City of Oakland 2.0            
422 422 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT133 OTH The Grand Tavern       Oakland CA 94610 2014-12-06 821 821 MTG Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
423 423 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT112 OTH Verizon Wireless       Sacramento CA 95825 2014-11-05 97.19 311.19 OFC     Guillen Abel     CCM City of Oakland 2.0            
424 424 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   PDT137 OTH Verizon Wireless       Sacramento CA 95825 2014-12-16 214 311.19 OFC     Guillen Abel     CCM City of Oakland 2.0            
425 425 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-06-26 2014-10-19 2014-12-31   EDT42 OTH Harbor House Ministries       Oakland CA 94606 2014-12-03 500 500 CVC     Guillen Abel     CCM City of Oakland 2.0            
591 591 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   EDT36 OTH U.S. Postmaster       Oakland CA 94615 2014-10-23 3483.07 14401.78 POS     Guillen Abel     CCM City of Oakland 2.0            
592 592 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   EDT40 OTH Cam Huong Restaurant       Oakland CA 94606 2014-10-20 21.8 425.7 OFC     Guillen Abel     CCM City of Oakland 2.0            
593 593 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT104 OTH Cam Huong Restaurant       Oakland CA 94606 2014-11-04 74.75 425.7 OFC     Guillen Abel     CCM City of Oakland 2.0            
594 594 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT87 OTH Cana Cuban Parlor and Cafe       Oakland CA 94610 2014-10-31 241.73 241.73 FND Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
595 595 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT125 OTH Chai Thai Noodles       Oakland CA 94606 2014-11-18 45.83 372.11 OFC     Guillen Abel     CCM City of Oakland 2.0            
596 596 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT81 OTH Comcast       Seattle WA 98124 2014-10-30 363.88 1364.46 OFC     Guillen Abel     CCM City of Oakland 2.0            
597 597 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT134 OTH Comcast       Seattle WA 98124 2014-12-16 594.4 1364.46 OFC     Guillen Abel     CCM City of Oakland 2.0            
598 598 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   EDT41 OTH Domino's Pizza       Oakland CA 94610 2014-10-20 54.13 251.63 OFC 10/20/14, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
599 599 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT80 OTH Domino's Pizza       Oakland CA 94610 2014-10-28 57 251.63 OFC 10/28/14, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
600 600 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT103 OTH Domino's Pizza       Oakland CA 94610 2014-11-04 100.75 251.63 OFC 11/04/14, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
601 601 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT94 OTH Facebook, Inc       Menlo Park CA 94025 2014-11-03 50.33 295.8 WEB     Guillen Abel     CCM City of Oakland 2.0            
602 602 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT131 OTH Facebook, Inc       Menlo Park CA 94025 2014-11-30 213.3 295.8 WEB     Guillen Abel     CCM City of Oakland 2.0            
603 603 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT74 OTH FedEx       Oakland CA 94621 2014-10-27 40 187.43 OFC     Guillen Abel     CCM City of Oakland 2.0            
604 604 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT90 OTH FedEx       Oakland CA 94621 2014-11-02 21.25 187.43 OFC     Guillen Abel     CCM City of Oakland 2.0            
605 605 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT109 OTH FedEx       Oakland CA 94621 2014-11-05 41.89 187.43 OFC     Guillen Abel     CCM City of Oakland 2.0            
606 606 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT121 OTH FedEx       Oakland CA 94621 2014-11-14 40.29 187.43 OFC     Guillen Abel     CCM City of Oakland 2.0            
607 607 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT128 OTH FedEx       Oakland CA 94621 2014-11-22 25 187.43 OFC     Guillen Abel     CCM City of Oakland 2.0            
608 608 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT72 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-10-23 32.19 978.93 OFC     Guillen Abel     CCM City of Oakland 2.0            
609 609 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT73 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-10-25 27.34 978.93 OFC     Guillen Abel     CCM City of Oakland 2.0            
610 610 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT84 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-10-31 30.17 978.93 OFC     Guillen Abel     CCM City of Oakland 2.0            
611 611 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT85 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-10-31 19.04 978.93 OFC     Guillen Abel     CCM City of Oakland 2.0            
612 612 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT105 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-11-04 4.63 978.93 OFC     Guillen Abel     CCM City of Oakland 2.0            
613 613 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT110 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-11-05 613.79 978.93 MTG Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
614 614 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT111 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-11-05 53.5 978.93 MTG Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
615 615 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT118 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-11-05 23.37 978.93 MTG Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
616 616 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT119 OTH La Estrellita Cafe & Bar       Oakland CA 94606 2014-11-11 40 978.93 MTG Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
617 617 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT124 OTH NationBuilder       Los Angeles CA 90013 2014-11-17 557 1630 WEB     Guillen Abel     CCM City of Oakland 2.0            
618 618 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT138 OTH NationBuilder       Los Angeles CA 90013 2014-12-17 557 1630 WEB     Guillen Abel     CCM City of Oakland 2.0            
619 619 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT79 OTH Office Depot       Oakland CA 94601 2014-10-27 204.76 1893.13 OFC     Guillen Abel     CCM City of Oakland 2.0            
620 620 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT132 OTH Office Depot       Oakland CA 94601 2014-11-06 -487.58 1893.13 OFC     Guillen Abel     CCM City of Oakland 2.0            
621 621 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT135 OTH PG&E       Sacramento CA 95899 2014-12-16 183.95 1319.18 OFC     Guillen Abel     CCM City of Oakland 2.0            
622 622 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT136 OTH PG&E       Sacramento CA 95899 2014-12-16 165.94 1319.18 OFC     Guillen Abel     CCM City of Oakland 2.0            
623 623 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT99 OTH PoliticalCalling.com       Davis CA 95616 2014-11-03 289.68 289.68 PHO     Guillen Abel     CCM City of Oakland 2.0            
624 624 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT82 OTH Safeway       Oakland CA 94611 2014-10-29 22.97 114.02 OFC     Guillen Abel     CCM City of Oakland 2.0            
625 625 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT114 OTH Safeway       Oakland CA 94611 2014-11-06 30 114.02 OFC     Guillen Abel     CCM City of Oakland 2.0            
626 626 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT115 OTH Saigon Printing       Oakland CA 94606 2014-11-08 40.33 588.1 LIT     Guillen Abel     CCM City of Oakland 2.0            
627 627 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   EDT38 OTH Shell Oil       Gonzales LA 70737 2014-10-21 25 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            
628 628 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT66 OTH Shell Oil       Gonzales LA 70737 2014-10-24 15 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            
629 629 1365384 87 Abel Guillen for Oakland City Council 2014 87 CTL 2015-01-31 2014-10-19 2014-12-31   PDT67 OTH Shell Oil       Gonzales LA 70737 2014-10-24 13.04 157.92 TRC     Guillen Abel     CCM City of Oakland 2.0            

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "on_behalf_of_expenditures" (
"filer_id" INTEGER,
  "filer_name" INTEGER,
  "committee_type" TEXT,
  "report_date" TEXT,
  "report_start_date" TEXT,
  "report_end_date" TEXT,
  "election_date" TEXT,
  "transaction_id" TEXT,
  "entity_type" TEXT,
  "payee_last_name" TEXT,
  "payee_first_name" TEXT,
  "payee_prefix" TEXT,
  "payee_suffix" TEXT,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "payee_zipcode" TEXT,
  "expenditure_date" TEXT,
  "expenditure_amt" NUMERIC,
  "year_to_date" NUMERIC,
  "expenditure_type" TEXT,
  "expenditure_description" TEXT,
  "committee_id" INTEGER,
  "candidate_last_name" TEXT,
  "candidate_first_name" TEXT,
  "candidate_prefix" TEXT,
  "candidate_suffix" TEXT,
  "office_sought" TEXT,
  "office_jurisdiction" TEXT,
  "district_number" TEXT,
  "incumbent" TEXT,
  "ballot_measure_name" TEXT,
  "ballot_measure_number" TEXT,
  "ballot_measure_jurisdiction" TEXT,
  "support_or_oppose" TEXT,
  "memo_reference_number" TEXT
,
FOREIGN KEY ("filer_id") REFERENCES [filer_ids](id),
    FOREIGN KEY ("filer_name") REFERENCES [filer_names](id),
    FOREIGN KEY ("committee_id") REFERENCES [committee_ids](id));
CREATE INDEX ["on_behalf_of_expenditures_filer_id"] ON [on_behalf_of_expenditures]("filer_id");
CREATE INDEX ["on_behalf_of_expenditures_filer_name"] ON [on_behalf_of_expenditures]("filer_name");
CREATE INDEX ["on_behalf_of_expenditures_committee_id"] ON [on_behalf_of_expenditures]("committee_id");