Campaign Finance - FPPC Form 460 - Schedule E - Payments Made
data.oaklandca.gov | Last Updated 8 Sep 2024This dataset includes all itemized payments made ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "E" Payments Made 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 | Description | Sample Values |
---|---|---|---|---|
Filer_ID | filer_id | text | ID number of Filer | 1331137 1444317 1332115 1357609 960997 view top 100 |
Filer_NamL | filer_naml | text | Name of Filer | Seneca Scott for Oakland Mayor 2022 Parker for Oakland Mayor 2014 Sheng Thao for Oakland Mayor 2022 Rebecca Kaplan for Supervisor 2022 Oakland Rising Committee Sponsored by Movement Strategy Center Action Fund view top 100 |
Report_Num | report_num | number | Report Number 000 - Original Report 001-999 - Amended Report #1-999 | 0 1 2 3 4 view top 100 |
Committee_Type | committee_type | text | Committee Type | CTL RCP BMC CAO view top 100 |
Rpt_Date | rpt_date | calendar_date | Date this Report is Filed | 2023-01-31T00:00:00.000 2014-10-06T00:00:00.000 2015-02-02T00:00:00.000 2019-01-31T00:00:00.000 2020-10-22T00:00:00.000 view top 100 |
From_Date | from_date | calendar_date | Reporting Period From Date | 2014-07-01T00:00:00.000 2018-07-01T00:00:00.000 2022-01-01T00:00:00.000 2022-07-01T00:00:00.000 2020-10-18T00:00:00.000 view top 100 |
Thru_Date | thru_date | calendar_date | Reporting Date Thru Period | 2018-12-31T00:00:00.000 2020-12-31T00:00:00.000 2014-12-31T00:00:00.000 2014-09-30T00:00:00.000 2016-12-31T00:00:00.000 view top 100 |
Elect_Date | elect_date | calendar_date | Date of General Election | 2022-11-08T00:00:00.000 2020-11-03T00:00:00.000 2018-11-06T00:00:00.000 2014-11-04T00:00:00.000 2016-11-08T00:00:00.000 view top 100 |
tblCover_Office_Cd | tblcover_office_cd | text | Office Sought Code | view top 100 |
tblCover_Offic_Dscr | tblcover_offic_dscr | text | Office Sought Description; required if Office_Cd=OTH | view top 100 |
Rec_Type | rec_type | text | Record Type | EXPN view top 100 |
Form_Type | form_type | text | Type of Filing or Form set | E view top 100 |
Tran_ID | tran_id | text | Transaction ID - permanent value unique to this item | EXP29 EXP75 EXP71 EXP62 EXP44 view top 100 |
Entity_Cd | entity_cd | text | Entity Code | OTH IND COM view top 100 |
Payee_NamL | payee_naml | text | Payee Last Name | Stripe S.E. Owens & Company eFundraising Connections Democracy Engine NationBuilder view top 100 |
Payee_NamF | payee_namf | text | Payee First Name | Dan Julie Carlos Shereda Lauren view top 100 |
Payee_NamT | payee_namt | text | Payee Prefix or Title | Mr. Ms. view top 100 |
Payee_NamS | payee_nams | text | Payee Suffix | Jr. III view top 100 |
Payee_Adr1 | payee_adr1 | text | Payee Address | view top 100 |
Payee_Adr2 | payee_adr2 | text | Payee Address | view top 100 |
Payee_City | payee_city | text | Payee City | Oakland San Francisco Sacramento Washington Los Angeles view top 100 |
Payee_State | payee_state | text | Payee State | CA DC MA TX NY view top 100 |
Payee_Zip4 | payee_zip4 | text | Payee Zipcode | 94612 94607 94103 94618 94611 view top 100 |
Expn_Date | expn_date | calendar_date | Date of Expenditure | 2018-10-10T00:00:00.000 2020-10-05T00:00:00.000 2020-10-28T00:00:00.000 2018-11-06T00:00:00.000 2020-10-01T00:00:00.000 view top 100 |
Amount | amount | number | Amount Paid | 500.0 1000.0 100.0 250.0 1500.0 view top 100 |
Cum_YTD | cum_ytd | number | Cumulative Amount Year to Date | 0.0 500.0 1000.0 100.0 250.0 view top 100 |
Expn_ChkNo | expn_chkno | text | Check Number | 0 1043 1031 1023 ACH view top 100 |
Expn_Code | expn_code | text | Expenditure Code | OFC PRO WEB LIT FND view top 100 |
Expn_Dscr | expn_dscr | text | Purpose of Expense and/or Description | Refund of Contribution Stripe Fees Campaign Worker SEE SCHEDULE G Credit Card Payment view top 100 |
Agent_NamL | agent_naml | text | Agent or Ind. Contrator's Last Name | view top 100 |
Agent_NamF | agent_namf | text | Agent or Ind. Contrator's First Name | view top 100 |
Agent_NamT | agent_namt | text | Agent or Ind. Contrator's Prefix or Title | view top 100 |
Agent_NamS | agent_nams | text | Agent or Ind. Contrator's Suffix | view top 100 |
Cmte_ID | cmte_id | text | Committee ID | 747153 1332115 1306869 1385949 1345303 view top 100 |
Tres_NamL | tres_naml | text | Treasurer or Responsible Officer's Last Name | Ash Aroyan Political Reporting view top 100 |
Tres_NamF | tres_namf | text | Treasurer or Responsible Officer's First Name | Wil Albany Plus view top 100 |
Tres_NamT | tres_namt | text | Treasurer or Responsible Officer's Prefix or Title | view top 100 |
Tres_NamS | tres_nams | text | Treasurer or Responsible Officer's Suffix | view top 100 |
Tres_Adr1 | tres_adr1 | text | Treasurer or Responsible Officer's Address | view top 100 |
Tres_Adr2 | tres_adr2 | text | Treasurer or Responsible Officer's Address | view top 100 |
Tres_City | tres_city | text | Treasurer or Responsible Officer's City | Oakland view top 100 |
Tres_ST | tres_st | text | Treasurer or Responsible Officer's State | CA view top 100 |
Tres_ZIP4 | tres_zip4 | text | Treasurer or Responsible Officer's Zipcode | 94610 view top 100 |
Cand_NamL | cand_naml | text | Candidate's Last Name | Kaplan Reid Schaaf na Gibson McElhaney view top 100 |
Cand_NamF | cand_namf | text | Candidate's First Name | Rebecca Dan Libby Lynette na view top 100 |
Cand_NamT | cand_namt | text | Candidate's Prefix or Title | Mr. Ms. Dr. view top 100 |
Cand_NamS | cand_nams | text | Candidate's Suffix | view top 100 |
Office_Cd | office_cd | text | Office Sought Code | CCM MAY OTH BED CSU view top 100 |
Offic_Dscr | offic_dscr | text | Office Sought Description; required if Office_Cd=OTH | City Council at Large City Council School Board Mayor, City of Oakland Director Oakland Unified School District view top 100 |
Juris_Cd | juris_cd | text | Office Jursidiction Code | CIT OTH CTY LOC SEN view top 100 |
Juris_Dscr | juris_dscr | text | Office Jursidiction Description | City of Oakland City of Oakland, CA Oakland Oakland Unified School District Oakland, CA view top 100 |
Dist_No | dist_no | text | Office District Number | 4 3 2 6 7 view top 100 |
Off_S_H_Cd | off_s_h_cd | text | Office Sought/Held Code H=Held; S=Sought | view top 100 |
Bal_Name | bal_name | text | Ballot Measure Name | City of Oakland Soda Tax MEASURE HH Recall of District Attorney Pamela Price Fund police, fire and violence prevention services Investing in Oakland?s Infrastructure and Affordable Housing view top 100 |
Bal_Num | bal_num | text | Ballot Number or Letter | HH Z KK T TBD view top 100 |
Bal_Juris | bal_juris | text | Ballot Jurisdiction | City of Oakland City of Oakland, CA CITY OF OAKLAND - NOVEMBER 2016 Alameda County CITY OF OAKLAND view top 100 |
Sup_Opp_Cd | sup_opp_cd | text | Support/Oppose? S=Support O=Oppose | S O view top 100 |
Memo_Code | memo_code | text | Memo Amount | view top 100 |
Memo_RefNo | memo_refno | text | Memo Reference Number | EXP307 EXP524 EXP1647 EXP1456 EXP1152 view top 100 |
BakRef_TID | bakref_tid | text | Tran_ID of parent transaction of this child transaction. Generally used on intermediary types of transactions. | VSGCM9VQT99 view top 100 |
G_From_E_F | g_from_e_f | text | Schedule G transaction coming from a schedule E or F of form 460. | view top 100 |
XRef_SchNm | xref_schnm | text | Referenced schedule where parent transaction can be found (Schedule name). | view top 100 |
XRef_Match | xref_match | text | Related item on other Schedule has same Tran_ID. X=Yes, blank=No. | HDR view top 100 |
Payee_Location | payee_location | point | view top 100 | |
Tres_Location | tres_location | point | view top 100 |