on_behalf_of_expenditures

FPPC Form 460, Schedule G

Data source: G_Expenditure

138 rows where filer_id = 147 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_date, year_to_date, expenditure_type, expenditure_description, committee_id, 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
3525 3525 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-07-23 2019-01-01 2019-06-30   PDT28 OTH NationBuilder       Los Angeles CA 90013 2019-01-17 218 2132 OFC     Guillen Abel     CCM City of Oakland 2.0            
2864 2864 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-04-15 2018-01-01 2018-06-30   PDT32 OTH Drake's Dealership       Oakland CA 94612 2018-06-30 500.61 500.61 FND 3/1/18, Fundraising Event, 15, including Candidate   Guillen Abel     CCM City of Oakland 2.0            
2865 2865 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-04-15 2018-01-01 2018-06-30   PDT31 OTH Oeste, LLC       Oakland CA 94607 2018-06-30 492.45 492.45 FND Appetizers Only   Guillen Abel     CCM City of Oakland 2.0            
2883 2883 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PDT5 OTH Best Buy       Oakland CA 94608 2018-09-04 8.73 826.81 OFC     Guillen Abel     CCM City of Oakland 2.0            
2884 2884 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PDT6 OTH Best Buy       Oakland CA 94608 2018-09-04 10.91 826.81 OFC     Guillen Abel     CCM City of Oakland 2.0            
2885 2885 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PDT7 OTH Best Buy       Oakland CA 94608 2018-09-04 17.47 826.81 OFC     Guillen Abel     CCM City of Oakland 2.0            
2886 2886 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PDT8 OTH Best Buy       Oakland CA 94608 2018-09-04 157.94 826.81 OFC     Guillen Abel     CCM City of Oakland 2.0            
2887 2887 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PDT9 OTH Best Buy       Oakland CA 94608 2018-09-04 157.94 826.81 OFC     Guillen Abel     CCM City of Oakland 2.0            
2888 2888 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PDT10 OTH Best Buy       Oakland CA 94608 2018-09-04 157.94 826.81 OFC     Guillen Abel     CCM City of Oakland 2.0            
2889 2889 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PDT11 OTH Best Buy       Oakland CA 94608 2018-09-04 157.94 826.81 OFC     Guillen Abel     CCM City of Oakland 2.0            
2890 2890 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PDT12 OTH Best Buy       Oakland CA 94608 2018-09-04 157.94 826.81 OFC     Guillen Abel     CCM City of Oakland 2.0            
2891 2891 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PDT15 OTH Fruitvale Wireless       Oakland CA 94601 2018-09-10 303.59 303.59 OFC     Guillen Abel     CCM City of Oakland 2.0            
2892 2892 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 EDT1 OTH Gill Studios       Lenexa KS 66219 2018-07-23 1763.21 1763.21 LIT     Guillen Abel     CCM City of Oakland 2.0            
2982 2982 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 EDT3 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-02 2795.33 11626.82 POS     Guillen Abel     CCM City of Oakland 2.0            
2983 2983 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 EDT17 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-17 2795.33 11626.82 POS     Guillen Abel     CCM City of Oakland 2.0            
2984 2984 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 EDT18 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-18 4036.16 11626.82 POS     Guillen Abel     CCM City of Oakland 2.0            
2985 2985 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 EDT2 OTH Athletics       Oakland CA 94621 2018-09-28 631 631 FND     Guillen Abel     CCM City of Oakland 2.0            
2986 2986 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PDT2 OTH East Bay Asian Youth Center       Oakland CA 94606 2018-09-28 500 500 CVC     Guillen Abel     CCM City of Oakland 2.0            
2987 2987 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PDT1 COM Shawn Kumagai for Dublin City Council 2018       Dublin CA 94568 2018-09-30 100 100 CTB   1.40676e+06 639 Guillen Abel     CCM City of Oakland 2.0            
3086 3086 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT45 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-23 2095.12 25263.12 POS     Guillen Abel     CCM City of Oakland 2.0            
3087 3087 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT20 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-30 10996.18 25263.12 POS     Guillen Abel     CCM City of Oakland 2.0            
3088 3088 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PDT26 OTH Asmara Restaurant       Oakland CA 94609 2018-12-20 104.61 104.61 MTG     Guillen Abel     CCM City of Oakland 2.0            
3089 3089 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PDT23 OTH Champa Garden       Oakland Ca 94606 2018-12-17 112.15 112.15 MTG     Guillen Abel     CCM City of Oakland 2.0            
3090 3090 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PDT18 OTH Din Tai Fung       Santa Clara CA 95050 2018-12-07 137.88 137.88 MTG     Guillen Abel     CCM City of Oakland 2.0            
3091 3091 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PDT22 OTH Lukas Taproom & Lounge       Oakland CA 94612 2018-12-15 317.77 3102.33 MTG     Guillen Abel     CCM City of Oakland 2.0            
3092 3092 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PDT17 OTH NationBuilder       Los Angeles CA 90013 2018-11-17 155.34 4201.34 OFC     Guillen Abel     CCM City of Oakland 2.0            
3093 3093 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PDT24 OTH NationBuilder       Los Angeles CA 90013 2018-12-17 218 4201.34 OFC     Guillen Abel     CCM City of Oakland 2.0            
3094 3094 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PDT25 OTH Oeste, LLC       Oakland CA 94607 2018-12-20 100 592.45 MTG     Guillen Abel     CCM City of Oakland 2.0            
3095 3095 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT21 OTH La Estrellita       Oakland CA 94606 2018-11-16 500 671.29   Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3096 3096 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT36 OTH Cana Cuban Parlor & Cafe       Oakland CA 94610 2018-11-06 323.59 323.59   11/6/18, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3097 3097 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT28 OTH Chabot Space & Science Center       Oakland CA 94619 2018-10-29 250 250 CVC     Guillen Abel     CCM City of Oakland 2.0            
3098 3098 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT40 OTH Costco Wholesale       Issaquah WA 98027 2018-11-28 1097.49 1097.49 OFC     Guillen Abel     CCM City of Oakland 2.0            
3099 3099 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT41 COM Friends of Bill Riley for Peralta Community College Board of Trustees       Oakland CA 94611 2018-11-29 250 250 CTB   1.36133e+06 640 Guillen Abel     CCM City of Oakland 2.0            
3100 3100 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT34 OTH Intertribal Friend House       Oakland CA 94606 2018-11-05 350 350 CVC     Guillen Abel     CCM City of Oakland 2.0            
3101 3101 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT31 OTH La Estrellita       Oakland CA 94606 2018-11-02 171.29 671.29   11/2/18, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3102 3102 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PDT29 OTH Lukas Taproom & Lounge       Oakland CA 94612 2018-12-14 2784.56 3102.33 MTG     Guillen Abel     CCM City of Oakland 2.0            
3103 3103 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT27 OTH Mi Grullense Restaruant       Oakland CA 94601 2018-10-29 117.42 117.42   10/29/18, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3104 3104 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT24 OTH Office Depot       Emeryville CA 94608 2018-10-25 234.63 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3105 3105 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT25 OTH Office Depot       Emeryville CA 94608 2018-10-26 20.92 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3106 3106 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT32 OTH Office Depot       Emeryville CA 94608 2018-11-05 36.96 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3107 3107 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT33 OTH Office Depot       Emeryville CA 94608 2018-11-05 406.3 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3108 3108 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT44 OTH Office Depot       Emeryville CA 94608 2018-12-07 -24.42 748.97   (Credit)   Guillen Abel     CCM City of Oakland 2.0            
3109 3109 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT42 OTH Paypal, Inc.       San Jose CA 95131 2018-11-29 100 100 OFC     Guillen Abel     CCM City of Oakland 2.0            
3110 3110 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT43 OTH Social Good Fund       Richmond CA 94805 2018-11-29 500 550 CVC     Guillen Abel     CCM City of Oakland 2.0            
3111 3111 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT38 OTH The Rare Barrel       Berkeley CA 94710 2018-11-26 147.96 147.96 MTG 11/26/18, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3112 3112 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   EDT23 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-24 545 25263.12 POS     Guillen Abel     CCM City of Oakland 2.0            
3113 3113 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT45 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-23 2095.12 25263.12 POS     Guillen Abel     CCM City of Oakland 2.0            
3114 3114 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT20 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-30 10996.18 25263.12 POS     Guillen Abel     CCM City of Oakland 2.0            
3115 3115 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PDT26 OTH Asmara Restaurant       Oakland CA 94609 2018-12-20 104.61 104.61 MTG     Guillen Abel     CCM City of Oakland 2.0            
3116 3116 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PDT23 OTH Champa Garden       Oakland Ca 94606 2018-12-17 112.15 112.15 MTG     Guillen Abel     CCM City of Oakland 2.0            
3117 3117 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PDT18 OTH Din Tai Fung       Santa Clara CA 95050 2018-12-07 137.88 137.88 MTG     Guillen Abel     CCM City of Oakland 2.0            
3118 3118 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PDT22 OTH Lukas Taproom & Lounge       Oakland CA 94612 2018-12-15 317.77 3102.33 MTG     Guillen Abel     CCM City of Oakland 2.0            
3119 3119 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PDT17 OTH NationBuilder       Los Angeles CA 90013 2018-11-17 155.34 4201.34 OFC     Guillen Abel     CCM City of Oakland 2.0            
3120 3120 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PDT24 OTH NationBuilder       Los Angeles CA 90013 2018-12-17 218 4201.34 OFC     Guillen Abel     CCM City of Oakland 2.0            
3121 3121 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PDT25 OTH Oeste, LLC       Oakland CA 94607 2018-12-20 100 100 MTG     Guillen Abel     CCM City of Oakland 2.0            
3122 3122 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT21 OTH La Estrellita       Oakland CA 94606 2018-11-16 500 671.29   Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3123 3123 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT36 OTH Cana Cuban Parlor & Cafe       Oakland CA 94610 2018-11-06 323.59 323.59   11/6/18, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3124 3124 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT28 OTH Chabot Space & Science Center       Oakland CA 94619 2018-10-29 250 250 CVC     Guillen Abel     CCM City of Oakland 2.0            
3125 3125 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT40 OTH Costco Wholesale       Issaquah WA 98027 2018-11-28 1097.49 1097.49 OFC     Guillen Abel     CCM City of Oakland 2.0            
3126 3126 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT41 COM Friends of Bill Riley for Peralta Community College Board of Trustees       Oakland CA 94611 2018-11-29 250 250 CTB   1.36133e+06 640 Guillen Abel     CCM City of Oakland 2.0            
3127 3127 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT34 OTH Intertribal Friend House       Oakland CA 94606 2018-11-05 350 350 CVC     Guillen Abel     CCM City of Oakland 2.0            
3128 3128 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT31 OTH La Estrellita       Oakland CA 94606 2018-11-02 171.29 671.29   11/2/18, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3129 3129 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PDT29 OTH Lukas Taproom & Lounge       Oakland CA 94612 2018-12-14 2784.56 3102.33 MTG     Guillen Abel     CCM City of Oakland 2.0            
3130 3130 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT27 OTH Mi Grullense Restaruant       Oakland CA 94601 2018-10-29 117.42 117.42   10/29/18, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3131 3131 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT24 OTH Office Depot       Emeryville CA 94608 2018-10-25 234.63 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3132 3132 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT25 OTH Office Depot       Emeryville CA 94608 2018-10-26 20.92 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3133 3133 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT32 OTH Office Depot       Emeryville CA 94608 2018-11-05 36.96 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3134 3134 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT33 OTH Office Depot       Emeryville CA 94608 2018-11-05 406.3 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3135 3135 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT44 OTH Office Depot       Emeryville CA 94608 2018-12-07 -24.42 748.97   (Credit)   Guillen Abel     CCM City of Oakland 2.0            
3136 3136 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT42 OTH Paypal, Inc.       San Jose CA 95131 2018-11-29 100 100 OFC     Guillen Abel     CCM City of Oakland 2.0            
3137 3137 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT43 OTH Social Good Fund       Richmond CA 94805 2018-11-29 500 550 CVC     Guillen Abel     CCM City of Oakland 2.0            
3138 3138 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT38 OTH The Rare Barrel       Berkeley CA 94710 2018-11-26 147.96 147.96 MTG 11/26/18, Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3139 3139 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   EDT23 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-24 545 25263.12 POS     Guillen Abel     CCM City of Oakland 2.0            
2988 2988 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 EDT3 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-02 2795.33 11626.82 POS     Guillen Abel     CCM City of Oakland 2.0            
2989 2989 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 EDT17 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-17 2795.33 11626.82 POS     Guillen Abel     CCM City of Oakland 2.0            
2990 2990 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 EDT18 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-18 4036.16 11626.82 POS     Guillen Abel     CCM City of Oakland 2.0            
2991 2991 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 EDT2 OTH Athletics       Oakland CA 94621 2018-09-28 631 631 FND     Guillen Abel     CCM City of Oakland 2.0            
2992 2992 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PDT2 OTH East Bay Asian Youth Center       Oakland CA 94606 2018-09-28 500 500 CVC     Guillen Abel     CCM City of Oakland 2.0            
2993 2993 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PDT1 COM Shawn Kumagai for Dublin City Council 2018       Dublin CA 94568 2018-09-30 100 100 CTB   1.40676e+06 639 Guillen Abel     CCM City of Oakland 2.0            
3140 3140 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT45 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-23 2095.12 25263.12 POS     Guillen Abel     CCM City of Oakland 2.0            
3141 3141 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT20 OTH U.S. Postmaster       Sacramento CA 95814 2018-10-30 10996.18 25263.12 POS     Guillen Abel     CCM City of Oakland 2.0            
3142 3142 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PDT26 OTH Asmara Restaurant       Oakland CA 94609 2018-12-20 104.61 104.61 MTG     Guillen Abel     CCM City of Oakland 2.0            
3143 3143 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PDT23 OTH Champa Garden       Oakland Ca 94606 2018-12-17 112.15 112.15 MTG     Guillen Abel     CCM City of Oakland 2.0            
3144 3144 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PDT18 OTH Din Tai Fung       Santa Clara CA 95050 2018-12-07 137.88 137.88 MTG     Guillen Abel     CCM City of Oakland 2.0            
3145 3145 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PDT22 OTH Lukas Taproom & Lounge       Oakland CA 94612 2018-12-15 317.77 317.77 MTG     Guillen Abel     CCM City of Oakland 2.0            
3146 3146 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PDT17 OTH NationBuilder       Los Angeles CA 90013 2018-11-17 155.34 4201.34 OFC     Guillen Abel     CCM City of Oakland 2.0            
3147 3147 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PDT24 OTH NationBuilder       Los Angeles CA 90013 2018-12-17 218 4201.34 OFC     Guillen Abel     CCM City of Oakland 2.0            
3148 3148 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PDT25 OTH Oeste, LLC       Oakland CA 94607 2018-12-20 100 100 MTG     Guillen Abel     CCM City of Oakland 2.0            
3149 3149 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT21 OTH La Estrellita       Oakland CA 94606 2018-11-16 500 671.29   Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3150 3150 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT36 OTH Cana Cuban Parlor & Cafe       Oakland CA 94610 2018-11-06 323.59 323.59   Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3151 3151 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT28 OTH Chabot Space & Science Center       Oakland CA 94619 2018-10-29 250 250 CVC     Guillen Abel     CCM City of Oakland 2.0            
3152 3152 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT40 OTH Costco Wholesale       Issaquah WA 98027 2018-11-28 1097.49 1097.49 OFC     Guillen Abel     CCM City of Oakland 2.0            
3153 3153 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT41 COM Friends of Bill Riley for Peralta Community College Board of Trustees       Oakland CA 94611 2018-11-29 250 250 CTB   1.36133e+06 640 Guillen Abel     CCM City of Oakland 2.0            
3154 3154 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT34 OTH Intertribal Friend House       Oakland CA 94606 2018-11-05 350 350 CVC     Guillen Abel     CCM City of Oakland 2.0            
3155 3155 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT31 OTH La Estrellita       Oakland CA 94606 2018-11-02 171.29 671.29   Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3156 3156 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT27 OTH Mi Grullense Restaruant       Oakland CA 94601 2018-10-29 117.42 117.42   Food for Volunteers   Guillen Abel     CCM City of Oakland 2.0            
3157 3157 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT24 OTH Office Depot       Emeryville CA 94608 2018-10-25 234.63 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3158 3158 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT25 OTH Office Depot       Emeryville CA 94608 2018-10-26 20.92 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3159 3159 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT32 OTH Office Depot       Emeryville CA 94608 2018-11-05 36.96 748.97 OFC     Guillen Abel     CCM City of Oakland 2.0            
3160 3160 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   EDT33 OTH Office Depot       Emeryville CA 94608 2018-11-05 406.3 748.97 OFC     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");