on_behalf_of_expenditures: 418
Data source: G_Expenditure
This data as json
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 418 | 87 | 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 |