Campaign Finance - FPPC Form 460 - Schedule G - Payments Made by an Agent or Independent Contractor
data.oaklandca.gov | Last Updated 8 Sep 2024This dataset includes all itemized payments made by an agent or independent contractor ($500 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "G" Payments Made by an Agent or Independent Contractor 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 | 1385180 1365384 1331137 1310647 1364564 view top 100 |
Filer_NamL | filer_naml | text | NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC Abel Guillen for Oakland City Council 2014 Officeholder Account Abel Guillen for Oakland City Council 2014 The Oakland Fund FAMILIES AND EDUCATORS FOR PUBLIC EDUCATION, SPONSORED BY GO PUBLIC SCHOOLS ADVOCATES view top 100 |
Report_Num | report_num | number | 0 1 2 3 4 view top 100 |
Committee_Type | committee_type | text | CTL BMC RCP CAO view top 100 |
Rpt_Date | rpt_date | calendar_date | 2016-12-28T00:00:00.000 2017-01-24T00:00:00.000 2019-06-11T00:00:00.000 2017-12-21T00:00:00.000 2016-09-25T00:00:00.000 view top 100 |
From_Date | from_date | calendar_date | 2016-09-25T00:00:00.000 2016-07-01T00:00:00.000 2020-09-20T00:00:00.000 2018-10-21T00:00:00.000 2016-10-23T00:00:00.000 view top 100 |
Thru_Date | thru_date | calendar_date | 2016-10-22T00:00:00.000 2016-09-24T00:00:00.000 2020-10-17T00:00:00.000 2016-12-31T00:00:00.000 2014-12-31T00:00:00.000 view top 100 |
Elect_Date | elect_date | calendar_date | 2016-11-08T00:00:00.000 2020-11-03T00:00:00.000 2018-11-06T00:00:00.000 2014-11-04T00:00:00.000 2012-11-06T00: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 | G view top 100 |
Tran_ID | tran_id | text | EDT2 EDT1 PDT1 EDT3 PDT3 view top 100 |
Entity_Cd | entity_cd | text | OTH IND COM view top 100 |
Payee_NamL | payee_naml | text | United States Postal Service NationBuilder PACIFIC PRINT RESOURCES Pacific Print Resources Facebook view top 100 |
Payee_NamF | payee_namf | text | DENISE Amy DEAN Anne MAZI 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 San Francisco Los Angeles Emeryville Sacramento view top 100 |
Payee_State | payee_state | text | CA DC NY GA TX view top 100 |
Payee_Zip4 | payee_zip4 | text | 94608 94612 94025 95814 94607 view top 100 |
Expn_Date | expn_date | calendar_date | 2016-10-14T00:00:00.000 2016-10-13T00:00:00.000 2016-06-30T00:00:00.000 2016-09-24T00:00:00.000 2016-11-01T00:00:00.000 view top 100 |
Amount | amount | number | 1000.0 5000.0 500.0 250.0 750.0 view top 100 |
Cum_YTD | cum_ytd | number | 0.0 12143.5 37275.0 170.3 222414.93 view top 100 |
Expn_ChkNo | expn_chkno | text | 1206 1067 1157 1212 1288 view top 100 |
Expn_Code | expn_code | text | LIT POS OFC WEB TEL view top 100 |
Expn_Dscr | expn_dscr | text | Sales Tax DIGITAL MEDIA Online Ads CANVASSING SEE SCHEDULE G view top 100 |
Agent_NamL | agent_naml | text | Card Service Center STOREFRONT POLITICAL MEDIA Autumn Press Telegraph 50+1 STRATEGIES view top 100 |
Agent_NamF | agent_namf | text | Michael Zach Aliza Jason Lia view top 100 |
Agent_NamT | agent_namt | text | Mr. view top 100 |
Agent_NamS | agent_nams | text | view top 100 |
Cmte_ID | cmte_id | text | 741941 1236496 1271673 1301157 1306869 view top 100 |
Tres_NamL | tres_naml | text | view top 100 |
Tres_NamF | tres_namf | text | 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 | view top 100 |
Tres_ST | tres_st | text | view top 100 |
Tres_ZIP4 | tres_zip4 | text | view top 100 |
Cand_NamL | cand_naml | text | Guillen Kaplan Kalb Gibson McElhaney Schaaf view top 100 |
Cand_NamF | cand_namf | text | Abel Dan Rebecca Lynette Libby view top 100 |
Cand_NamT | cand_namt | text | Mr. Ms. view top 100 |
Cand_NamS | cand_nams | text | view top 100 |
Office_Cd | office_cd | text | CCM MAY OTH CAT BED view top 100 |
Offic_Dscr | offic_dscr | text | City Council at Large City Council At-Large School Board Oakland City Council District 4 OAKLAND CITY COUNCIL DISTRICT 6 view top 100 |
Juris_Cd | juris_cd | text | OTH CIT SEN view top 100 |
Juris_Dscr | juris_dscr | text | City of Oakland City of Oakland, CA Oakland Oakland, CA 94612 Oakland, CA view top 100 |
Dist_No | dist_no | text | 2 1 3 7 5 view top 100 |
Off_S_H_Cd | off_s_h_cd | text | view top 100 |
Bal_Name | bal_name | text | MEASURE HH City of Oakland Soda Tax Proposed amendments to residental rent adjustments and evictions ordinance $30,000,000 Parcel Tax for 30 Years Children's Initiative of 2018 view top 100 |
Bal_Num | bal_num | text | HH JJ AA Z KK view top 100 |
Bal_Juris | bal_juris | text | CITY OF OAKLAND - NOVEMBER 2016 City of Oakland City of Oakland, CA CITY OF OAKLAND view top 100 |
Sup_Opp_Cd | sup_opp_cd | text | S O view top 100 |
Memo_Code | memo_code | text | view top 100 |
Memo_RefNo | memo_refno | text | EDT74 EDT96 PDT124 PDT125 PDT126 view top 100 |
BakRef_TID | bakref_tid | text | PAY876 PAY1606 PAY1611 EXP558 PAY882 view top 100 |
G_From_E_F | g_from_e_f | text | E F view top 100 |
XRef_SchNm | xref_schnm | text | view top 100 |
XRef_Match | xref_match | text | view top 100 |
Payee_Location | payee_location | point | view top 100 |
Tres_Location | tres_location | point | view top 100 |