Campaign Finance - FPPC Form 460 - Schedule F - Accrued Expenses (Unpaid Bills)
data.oaklandca.gov | Last Updated 23 May 2024This dataset includes all itemized accrued expenses ($100 or more) e-filed on Fair Political Practices Commission (FPPC) Form 460 Schedule "F" Accrued Expenses (Unpaid Bills) 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 46 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Filer_ID | filer_id | text | 1331137 1364278 1426780 1367270 1385180 view top 100 |
| Filer_NamL | filer_naml | text | Families and Educators for Public Education, Sponsored by GO Public Schools Advocates Courtney Ruby for Oakland Mayor 2014 Derreck Johnson for Oakland City Council 2020 Kaplan for Oakland Mayor 2014 NO ON HH: NO OAKLAND GROCERY TAX, WITH MAJOR FUNDING BY AMERICAN BEVERAGE ASSOCIATION CALIFORNIA PAC view top 100 |
| Report_Num | report_num | number | 0 1 2 3 4 view top 100 |
| Committee_Type | committee_type | text | CTL RCP BMC CAO view top 100 |
| Rpt_Date | rpt_date | calendar_date | 2021-01-19T00:00:00.000 2021-01-18T00:00:00.000 2017-01-24T00:00:00.000 2014-10-23T00:00:00.000 2015-01-26T00:00:00.000 view top 100 |
| From_Date | from_date | calendar_date | 2020-09-20T00:00:00.000 2014-10-01T00:00:00.000 2020-10-18T00:00:00.000 2016-07-01T00:00:00.000 2018-07-01T00:00:00.000 view top 100 |
| Thru_Date | thru_date | calendar_date | 2020-10-17T00:00:00.000 2020-12-31T00:00:00.000 2016-12-31T00:00:00.000 2016-10-22T00:00:00.000 2014-10-18T00: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 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 | DEBT view top 100 |
| Form_Type | form_type | text | F view top 100 |
| Tran_ID | tran_id | text | PAY839 F-15-V PAY110 PAY841 PAY289 view top 100 |
| Entity_Cd | entity_cd | text | OTH IND COM view top 100 |
| Payee_NamL | payee_naml | text | The Henry Levy Group GO PUBLIC SCHOOLS ADVOCATES Deane & Company Sutton Law Firm Uribe view top 100 |
| Payee_NamF | payee_namf | text | Carlos Darin R. Aliza Jacie Brad view top 100 |
| Payee_NamT | payee_namt | text | Ms. 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 OAKLAND Sacramento Los Angeles view top 100 |
| Payee_State | payee_state | text | CA OH TX DC NY view top 100 |
| Payee_Zip4 | payee_zip4 | text | 94618 94607 94612 94108 95815 view top 100 |
| Beg_Bal | beg_bal | number | 0.0 4500.0 1000.0 250.0 1500.0 view top 100 |
| Amt_Incur | amt_incur | number | 0.0 1000.0 500.0 1500.0 250.0 view top 100 |
| Amt_Paid | amt_paid | number | 0.0 1000.0 1500.0 5000.0 250.0 view top 100 |
| End_Bal | end_bal | number | 0.0 4500.0 1000.0 250.0 1500.0 view top 100 |
| Expn_Code | expn_code | text | PRO CNS OFC IND LIT view top 100 |
| Expn_Dscr | expn_dscr | text | SEE SCHEDULE G Credit Card Payment IND OF LIT Reimbursed expense under the $500 Schedule G threshold. REIMBURSED EXPENSES view top 100 |
| Cmte_ID | cmte_id | text | 595002 1427826 747153 1405491 599010 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 |
| Memo_Code | memo_code | text | view top 100 |
| Memo_RefNo | memo_refno | text | PAY516 PAY42 PAY102 PAY104 PAY1 view top 100 |
| BakRef_TID | bakref_tid | text | 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 |