accrued_expenses

FPPC Form 460, Schedule F

Data source: F_Expenses

96 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, transaction_id, entity_type, payee_last_name, payee_first_name, payee_city, payee_state, payee_zipcode, beginning_balance, amount_incurred, amount_paid, ending_balance, expenditure_description, report_date (date), report_start_date (date), report_end_date (date), election_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 beginning_balance amount_incurred amount_paid ending_balance expenditure_description committee_id memo_reference_number
4057 4057 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-12-23 2019-07-01 2019-12-16   PAY997 OTH Elan Financial Services       Saint Louis MO 63132 14.99 0 14.99 0 To be credited    
4133 4133 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-07-23 2019-01-01 2019-06-30   PAY965 OTH Annie Eagan Consulting       Oakland CA 94612 492.45 0 492.45 0 Appetizers Only    
4134 4134 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-07-23 2019-01-01 2019-06-30   PAY966 OTH Annie Eagan Consulting       Oakland CA 94612 500.61 0 500.61 0 3/1/18, Fundraising Event, 15, including Candidate    
4135 4135 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-07-23 2019-01-01 2019-06-30   PAY956 OTH Telegraph Media, Inc.       Oakland CA 94607 781.25 0 781.25 0      
4136 4136 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-07-23 2019-01-01 2019-06-30   PAY929 OTH Olson Hagel & Fishburn, LLP       Sacramento CA 95814 432.5 0 432.5 0      
4137 4137 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-07-23 2019-01-01 2019-06-30   PAY935 OTH Card Service Center       Dallas TX 75356 1328.72 0 1328.72 0 Credit Card Payment    
4138 4138 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-07-23 2019-01-01 2019-06-30   PAY944 OTH Elan Financial Services       Saint Louis MO 63132 2784.89 0 2784.89 0 Credit Card Payment    
4139 4139 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-07-23 2019-01-01 2019-06-30   PAY997 OTH Elan Financial Services       Saint Louis MO 63132 0 14.99 0 14.99 To be Credited    
3015 3015 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-04-15 2018-01-01 2018-06-30   PAY965 OTH Annie Eagan Consulting       Oakland CA 94612 0 492.45 0 492.45 Appetizers Only    
3016 3016 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-04-15 2018-01-01 2018-06-30   PAY966 OTH Annie Eagan Consulting       Oakland CA 94612 0 500.61 0 500.61 3/1/18, Fundraising Event, 15, including Candidate    
3017 3017 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-04-15 2018-01-01 2018-06-30   PAY474 IND Taylor Lawrence     Berkeley CA 94704 0 300 0 300      
3089 3089 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PAY965 OTH Annie Eagan Consulting       Oakland CA 94612 492.45 0 0 492.45 Appetizers Only    
3090 3090 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PAY966 OTH Annie Eagan Consulting       Oakland CA 94612 500.61 0 0 500.61 3/1/18, Fundraising Event, 15, including Candidate    
3091 3091 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PAY718 OTH Political Data, Inc.       Norwalk CA 90650 0 148.36 0 148.36      
3092 3092 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PAY746 OTH East Bay Blue Print and Supply Company       Oakland CA 94606 0 33.69 0 33.69      
3093 3093 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PAY817 OTH Elan Financial Services       Saint Louis MO 63132 0 1352.47 0 1352.47 Credit Card Payment    
3094 3094 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PAY910 IND Chen Chiao-Lun     Milpitas CA 95035 0 51.27 0 51.27      
3095 3095 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PAY474 IND Taylor Lawrence     Berkeley CA 94704 300 0 300 0      
3096 3096 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PAY711 IND Rugeley Parker     Hayward CA 94544 0 700 0 700 Administrative Services    
3097 3097 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-07-01 2018-09-22 2018-11-06 PAY710 IND Flores Victor     Oakland CA 94609 0 1000 0 1000 Administrative Services    
3198 3198 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY965 OTH Annie Eagan Consulting       Oakland CA 94612 492.45 0 0 492.45 Appetizers Only    
3199 3199 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY966 OTH Annie Eagan Consulting       Oakland CA 94612 500.61 0 0 500.61 3/1/18, Fundraising Event, 15, including Candidate    
3200 3200 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY718 OTH Political Data, Inc.       Norwalk CA 90650 148.36 0 148.36 0      
3201 3201 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY746 OTH East Bay Blue Print and Supply Company       Oakland CA 94606 33.69 0 33.69 0      
3202 3202 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY817 OTH Elan Financial Services       Saint Louis MO 63132 1352.47 0 1352.47 0 Credit Card Payment    
3203 3203 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY800 OTH Elan Financial Services       Saint Louis MO 63132 0 679.11 0 679.11 Credit Card Payment    
3204 3204 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY846 OTH Lithograph Reproductions, Inc.       Oakland CA 94609 0 576.19 0 576.19      
3205 3205 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY956 OTH Telegraph Media, Inc.       Oakland CA 94607 0 781.25 0 781.25      
3206 3206 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY910 IND Chen Chiao-Lun     Milpitas CA 95035 51.27 0 0 51.27      
3207 3207 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY711 IND Rugeley Parker     Hayward CA 94544 700 0 700 0 Administrative Services    
3208 3208 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-09-23 2018-10-20 2018-11-06 PAY710 IND Flores Victor     Oakland CA 94609 1000 0 1000 0 Administrative Services    
3246 3246 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PAY965 OTH Annie Eagan Consulting       Oakland CA 94612 492.45 0 0 492.45 Appetizers Only    
3247 3247 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PAY966 OTH Annie Eagan Consulting       Oakland CA 94612 500.61 0 0 500.61 3/1/18, Fundraising Event, 15, including Candidate    
3248 3248 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PAY800 OTH Elan Financial Services       Saint Louis MO 63132 679.11 0 679.11 0 Credit Card Payment    
3249 3249 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PAY846 OTH Lithograph Reproductions, Inc.       Oakland CA 94609 576.19 0 576.19 0      
3250 3250 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PAY956 OTH Telegraph Media, Inc.       Oakland CA 94607 781.25 0 0 781.25      
3251 3251 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PAY929 OTH Olson Hagel & Fishburn, LLP       Sacramento CA 95814 0 432.5 0 432.5      
3252 3252 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PAY935 OTH Card Service Center       Dallas TX 75356 0 1328.72 0 1328.72 Credit Card Payment    
3253 3253 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PAY944 OTH Elan Financial Services       Saint Louis MO 63132 0 2784.89 0 2784.89 Credit Card Payment    
3254 3254 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-15 2018-10-21 2018-12-31   PAY910 IND Chen Chiao-Lun     Milpitas CA 95035 51.27 0 51.27 0      
3255 3255 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PAY800 OTH Elan Financial Services       Saint Louis MO 63132 679.11 0 679.11 0 Credit Card Payment    
3256 3256 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PAY846 OTH Lithograph Reproductions, Inc.       Oakland CA 94609 576.19 0 576.19 0      
3257 3257 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PAY956 OTH Telegraph Media, Inc.       Oakland CA 94607 781.25 0 0 781.25      
3258 3258 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PAY929 OTH Olson Hagel & Fishburn, LLP       Sacramento CA 95814 0 432.5 0 432.5      
3259 3259 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PAY935 OTH Card Service Center       Dallas TX 75356 0 1328.72 0 1328.72 Credit Card Payment    
3260 3260 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PAY944 OTH Elan Financial Services       Saint Louis MO 63132 0 2784.89 0 2784.89 Credit Card Payment    
3261 3261 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-03-07 2018-10-21 2018-12-31   PAY910 IND Chen Chiao-Lun     Milpitas CA 95035 51.27 0 51.27 0      
3209 3209 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PAY718 OTH Political Data, Inc.       Norwalk CA 90650 148.36 0 148.36 0      
3210 3210 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PAY746 OTH East Bay Blue Print and Supply Company       Oakland CA 94606 33.69 0 33.69 0      
3211 3211 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PAY817 OTH Elan Financial Services       Saint Louis MO 63132 1352.47 0 1352.47 0 Credit Card Payment    
3212 3212 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PAY800 OTH Elan Financial Services       Saint Louis MO 63132 0 679.11 0 679.11 Credit Card Payment    
3213 3213 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PAY846 OTH Lithograph Reproductions, Inc.       Oakland CA 94609 0 576.19 0 576.19      
3214 3214 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PAY956 OTH Telegraph Media, Inc.       Oakland CA 94607 0 781.25 0 781.25      
3215 3215 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PAY910 IND Chen Chiao-Lun     Milpitas CA 95035 51.27 0 0 51.27      
3216 3216 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PAY711 IND Rugeley Parker     Hayward CA 94544 700 0 700 0 Administrative Services    
3217 3217 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-02-26 2018-09-23 2018-10-20 2018-11-06 PAY710 IND Flores Victor     Oakland CA 94609 1000 0 1000 0 Administrative Services    
3264 3264 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PAY800 OTH Elan Financial Services       Saint Louis MO 63132 679.11 0 679.11 0 Credit Card Payment    
3265 3265 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PAY846 OTH Lithograph Reproductions, Inc.       Oakland CA 94609 576.19 0 576.19 0      
3266 3266 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PAY929 OTH Olson Hagel & Fishburn, LLP       Sacramento CA 95814 0 432.5 0 432.5      
3267 3267 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PAY935 OTH Card Service Center       Dallas TX 75356 0 1328.72 0 1328.72 Credit Card Payment    
3268 3268 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-31 2018-10-21 2018-12-31   PAY910 IND Chen Chiao-Lun     Milpitas CA 95035 51.27 0 51.27 0      
3218 3218 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-09 2018-09-23 2018-10-20 2018-11-06 PAY718 OTH Political Data, Inc.       Norwalk CA 90650 148.36 0 148.36 0      
3219 3219 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-09 2018-09-23 2018-10-20 2018-11-06 PAY746 OTH East Bay Blue Print and Supply Company       Oakland CA 94606 33.69 0 33.69 0      
3220 3220 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-09 2018-09-23 2018-10-20 2018-11-06 PAY817 OTH Elan Financial Services       Saint Louis MO 63132 1352.47 0 1352.47 0 Credit Card Payment    
3221 3221 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-09 2018-09-23 2018-10-20 2018-11-06 PAY800 OTH Elan Financial Services       Saint Louis MO 63132 0 679.11 0 679.11 Credit Card Payment    
3222 3222 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-09 2018-09-23 2018-10-20 2018-11-06 PAY846 OTH Lithograph Reproductions, Inc.       Oakland CA 94609 0 576.19 0 576.19      
3223 3223 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-09 2018-09-23 2018-10-20 2018-11-06 PAY910 IND Chen Chiao-Lun     Milpitas CA 95035 51.27 0 0 51.27      
3224 3224 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-09 2018-09-23 2018-10-20 2018-11-06 PAY711 IND Rugeley Parker     Hayward CA 94544 700 0 700 0 Administrative Services    
3225 3225 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-09 2018-09-23 2018-10-20 2018-11-06 PAY710 IND Flores Victor     Oakland CA 94609 1000 0 1000 0 Administrative Services    
3098 3098 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-04 2018-07-01 2018-09-22 2018-11-06 PAY718 OTH Political Data, Inc.       Norwalk CA 90650 0 148.36 0 148.36      
3099 3099 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-04 2018-07-01 2018-09-22 2018-11-06 PAY746 OTH East Bay Blue Print and Supply Company       Oakland CA 94606 0 33.69 0 33.69      
3100 3100 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-04 2018-07-01 2018-09-22 2018-11-06 PAY817 OTH Elan Financial Services       Saint Louis MO 63132 0 1352.47 0 1352.47 Credit Card Payment    
3101 3101 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-04 2018-07-01 2018-09-22 2018-11-06 PAY910 IND Chen Chiao-Lun     Milpitas CA 95035 0 51.27 0 51.27      
3102 3102 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-04 2018-07-01 2018-09-22 2018-11-06 PAY474 IND Taylor Lawrence     Berkeley CA 94704 300 0 300 0      
3103 3103 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-04 2018-07-01 2018-09-22 2018-11-06 PAY711 IND Rugeley Parker     Hayward CA 94544 0 700 0 700 Administrative Services    
3104 3104 1395580 147 Abel Guillen for City Council 2018 184 CTL 2019-01-04 2018-07-01 2018-09-22 2018-11-06 PAY710 IND Flores Victor     Oakland CA 94609 0 1000 0 1000 Administrative Services    
3105 3105 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-07-01 2018-09-22 2018-11-06 PAY718 OTH Political Data, Inc.       Norwalk CA 90650 0 148.36 0 148.36      
3106 3106 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-07-01 2018-09-22 2018-11-06 PAY746 OTH East Bay Blue Print and Supply Company       Oakland CA 94606 0 33.69 0 33.69      
3107 3107 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-07-01 2018-09-22 2018-11-06 PAY817 OTH Elan Financial Services       Saint Louis MO 63132 0 1352.47 0 1352.47 Credit Card Payment    
3108 3108 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-07-01 2018-09-22 2018-11-06 PAY474 IND Taylor Lawrence     Berkeley CA 94704 300 0 300 0      
3109 3109 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-07-01 2018-09-22 2018-11-06 PAY711 IND Rugeley Parker     Hayward CA 94544 0 700 0 700 Administrative Services    
3110 3110 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-07-01 2018-09-22 2018-11-06 PAY710 IND Flores Victor     Oakland CA 94601 0 1000 0 1000 Administrative Services    
3483 3483 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-09-23 2018-10-20 2018-11-06 PAY718 OTH Political Data, Inc.       Norwalk CA 90650 148.36 0 148.36 0      
3484 3484 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-09-23 2018-10-20 2018-11-06 PAY746 OTH East Bay Blue Print and Supply Company       Oakland CA 94606 33.69 0 33.69 0      
3485 3485 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-09-23 2018-10-20 2018-11-06 PAY817 OTH Elan Financial Services       Saint Louis MO 63132 1352.47 0 1352.47 0 Credit Card Payment    
3486 3486 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-09-23 2018-10-20 2018-11-06 PAY800 OTH Elan Financial Services       Saint Louis MO 63132 0 679.11 0 679.11 Credit Card Payment    
3487 3487 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-09-23 2018-10-20 2018-11-06 PAY711 IND Rugeley Parker     Hayward CA 94544 700 0 700 0 Administrative Services    
3488 3488 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-10-25 2018-09-23 2018-10-20 2018-11-06 PAY710 IND Flores Victor     Oakland CA 94601 1000 0 1000 0 Administrative Services    
3666 3666 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-09-27 2018-07-01 2018-09-22 2018-11-06 PAY474 IND Taylor Lawrence     Berkeley CA 94704 300 0 300 0      
3667 3667 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-09-27 2018-07-01 2018-09-22 2018-11-06 PAY711 IND Rugeley Parker     Hayward CA 94544 0 700 0 700 Administrative Services    
3668 3668 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-09-27 2018-07-01 2018-09-22 2018-11-06 PAY710 IND Flores Victor     Oakland CA 94601 0 1000 0 1000 Administrative Services    
3812 3812 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-07-31 2018-01-01 2018-06-30   PAY474 IND Taylor Lawrence     Berkeley CA 94704 0 300 0 300      
2768 2768 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-01-30 2017-07-01 2017-12-31   PAY23 OTH Deane & Company       Sacramento CA 95815 266.2 0 266.2 0      
2769 2769 1395580 147 Abel Guillen for City Council 2018 184 CTL 2018-01-30 2017-07-01 2017-12-31   PAY31 OTH Annie Eagan Consulting       Oakland CA 94612 1500 0 1500 0      
2886 2886 1395580 147 Abel Guillen for City Council 2018 184 CTL 2017-07-22 2017-01-01 2017-06-30   PAY23 OTH Deane & Company       Sacramento CA 95815 0 266.2 0 266.2      
2887 2887 1395580 147 Abel Guillen for City Council 2018 184 CTL 2017-07-22 2017-01-01 2017-06-30   PAY31 OTH Annie Eagan Consulting       Oakland CA 94612 0 1500 0 1500      

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "accrued_expenses" (
"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" INTEGER,
  "payee_prefix" INTEGER,
  "payee_suffix" INTEGER,
  "payee_city" TEXT,
  "payee_state" TEXT,
  "payee_zipcode" TEXT,
  "beginning_balance" INTEGER,
  "amount_incurred" INTEGER,
  "amount_paid" INTEGER,
  "ending_balance" INTEGER,
  "expenditure_description" TEXT,
  "committee_id" INTEGER,
  "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));
CREATE INDEX ["accrued_expenses_filer_id"] ON [accrued_expenses]("filer_id");
CREATE INDEX ["accrued_expenses_filer_name"] ON [accrued_expenses]("filer_name");
CREATE INDEX ["accrued_expenses_committee_id"] ON [accrued_expenses]("committee_id");