Campaign Finance - FPPC Form 460 - Schedule D - Summary of Expenditures Supporting/Opposing Other Candidates, Measures and Committees
data.oaklandca.gov | Last Updated 27 May 2024This dataset includes all itemized expenditures supporting/opposing other candidates, measures and committees ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "D" Expenditures Supporting/Opposing Other Candidates, Measures and Committees from 2011 to the present. The data is current as of the last modified date on this dataset. See the data key for column definitions: https://data.sfgov.org/Ethics/Campaign-Finance-Data-Key/wygs-cc76
This dataset has the following 65 columns:
Column Name | API Column Name | Data Type | Sample Values |
---|---|---|---|
Filer_ID | filer_id | text | 1331137 1332115 1345259 1294190 983545 view top 100 |
Filer_NamL | filer_naml | text | Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund Families and Educators for Public Education, Sponsored by GO Public Schools Advocates FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES Oakland Education Association Political Action Committee Oakland Police Officer's Association - Political Action Committee view top 100 |
Report_Num | report_num | number | 0 1 2 3 4 view top 100 |
Committee_Type | committee_type | text | RCP CTL BMC CAO view top 100 |
Rpt_Date | rpt_date | calendar_date | 2020-10-22T00:00:00.000 2021-02-01T00:00:00.000 2018-10-25T00:00:00.000 2017-12-21T00:00:00.000 2014-10-06T00:00:00.000 view top 100 |
From_Date | from_date | calendar_date | 2020-07-01T00:00:00.000 2022-10-23T00:00:00.000 2020-09-20T00:00:00.000 2014-07-01T00:00:00.000 2020-10-18T00:00:00.000 view top 100 |
Thru_Date | thru_date | calendar_date | 2020-10-17T00:00:00.000 2022-12-31T00:00:00.000 2014-12-31T00:00:00.000 2020-12-31T00:00:00.000 2018-10-20T00:00:00.000 view top 100 |
Elect_Date | elect_date | calendar_date | 2020-11-03T00:00:00.000 2014-11-04T00:00:00.000 2018-11-06T00:00:00.000 2016-11-08T00:00:00.000 2022-11-08T00:00:00.000 view top 100 |
tblCover_Office_Cd | tblcover_office_cd | text | view top 100 |
tblCover_Offic_Dscr | tblcover_offic_dscr | text | view top 100 |
Rec_Type | rec_type | text | EXPN view top 100 |
Form_Type | form_type | text | D view top 100 |
Tran_ID | tran_id | text | PDT9 PDT3 PDT21 PDT1 PDT10 view top 100 |
Entity_Cd | entity_cd | text | COM OTH IND PTY SCC view top 100 |
Payee_NamL | payee_naml | text | East Bay Express JAMES HARRIS NOVEMBER 2016 IE HUBER TRENADO NOVEMBER 2016 IE Committee to Protect Oakland Renters Ignacio De La Fuente (IE) view top 100 |
Payee_NamF | payee_namf | text | DESLEY Sasha Austin Jennifer Mike view top 100 |
Payee_NamT | payee_namt | text | view top 100 |
Payee_NamS | payee_nams | text | view top 100 |
Payee_Adr1 | payee_adr1 | text | view top 100 |
Payee_Adr2 | payee_adr2 | text | view top 100 |
Payee_City | payee_city | text | Oakland Sacramento OAKLAND San Francisco SACRAMENTO view top 100 |
Payee_State | payee_state | text | CA NY MA OH Ca view top 100 |
Payee_Zip4 | payee_zip4 | text | 95815 94612 94607 95814 94618 view top 100 |
Expn_Date | expn_date | calendar_date | 2020-10-08T00:00:00.000 2022-10-25T00:00:00.000 2018-10-15T00:00:00.000 2020-10-19T00:00:00.000 2016-11-08T00:00:00.000 view top 100 |
Amount | amount | number | 500.0 1000.0 250.0 700.0 5000.0 view top 100 |
Cum_YTD | cum_ytd | number | 500.0 1000.0 250.0 216.9 700.0 view top 100 |
Expn_ChkNo | expn_chkno | text | 1023 1005 1003 1010 1004 view top 100 |
Expn_Code | expn_code | text | IND MON IKD view top 100 |
Expn_Dscr | expn_dscr | text | Mailer LIT Print ad mentioning support for candidate WEB IND EXP OF CAMPAIGN LITERATURE view top 100 |
Agent_NamL | agent_naml | text | view top 100 |
Agent_NamF | agent_namf | text | view top 100 |
Agent_NamT | agent_namt | text | view top 100 |
Agent_NamS | agent_nams | text | view top 100 |
Cmte_ID | cmte_id | text | 1365454 1430558 1427679 1365733 1368416 view top 100 |
Tres_NamL | tres_naml | text | Aroyan Political Reporting view top 100 |
Tres_NamF | tres_namf | text | Albany Plus view top 100 |
Tres_NamT | tres_namt | text | view top 100 |
Tres_NamS | tres_nams | text | view top 100 |
Tres_Adr1 | tres_adr1 | text | view top 100 |
Tres_Adr2 | tres_adr2 | text | view top 100 |
Tres_City | tres_city | text | Inglewood view top 100 |
Tres_ST | tres_st | text | CA view top 100 |
Tres_ZIP4 | tres_zip4 | text | 90301 view top 100 |
Cand_NamL | cand_naml | text | Kaplan Ignacio De La Fuente DESLEY BROOKS JAMES HARRIS HUBER TRENADO view top 100 |
Cand_NamF | cand_namf | text | Rebecca Carroll Desley Libby Clarissa view top 100 |
Cand_NamT | cand_namt | text | view top 100 |
Cand_NamS | cand_nams | text | view top 100 |
Office_Cd | office_cd | text | OTH CCM MAY BED ASM view top 100 |
Offic_Dscr | offic_dscr | text | SCHOOL BOARD School Board SCHOOL DIRECTOR Oakland USD School Board CITY OF OAKLAND view top 100 |
Juris_Cd | juris_cd | text | OTH CIT CTY ASM STW view top 100 |
Juris_Dscr | juris_dscr | text | OAKLAND UNIFIED SCHOOL DISTRICT City of Oakland Oakland Oakland Unified School District Oakland, CA view top 100 |
Dist_No | dist_no | text | 4 3 5 6 7 view top 100 |
Off_S_H_Cd | off_s_h_cd | text | S H view top 100 |
Bal_Name | bal_name | text | City of Oakland Renters Upgrade Act Progressive Business Tax III Maintain a Parcel Tax and a Parking Tax Surcharge For a Period of Ten Years To Improve Police, Fire and Emergency Services Campaign Finance Reform MEASURE N view top 100 |
Bal_Num | bal_num | text | W Z V T Q view top 100 |
Bal_Juris | bal_juris | text | City of Oakland Statewide Alameda County County of Alameda City of Oakland, CA view top 100 |
Sup_Opp_Cd | sup_opp_cd | text | S O view top 100 |
Memo_Code | memo_code | text | X view top 100 |
Memo_RefNo | memo_refno | text | 500299502 500299503 500299504 500299505 500299506 view top 100 |
BakRef_TID | bakref_tid | text | view top 100 |
G_From_E_F | g_from_e_f | text | view top 100 |
XRef_SchNm | xref_schnm | text | view top 100 |
XRef_Match | xref_match | text | X view top 100 |
Payee_Location | payee_location | point | view top 100 |
Tres_Location | tres_location | point | view top 100 |