on_behalf_of_expenditures: 628
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 628 | 87 | 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 |