Form 700 Comments

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.sfgov.org
Id e9vv-n9ta
Name Form 700 Comments
Attribution Ethics Commission
Category City Management and Ethics
Tags ethics, form 700, schedules, sei, statement of economic interests
Created 2016-05-18T18:05:40Z
Publication Date 2016-06-13T22:37:38Z

Description

Comments about Form 700 schedules Link to Form 700 overview: http://www.fppc.ca.gov/Form700.html

Columns

| Included | Schema Type | Field Name       | Name             | Data Type | Render Type |
| ======== | =========== | ================ | ================ | ========= | =========== |
| Yes      | series tag  | filer_name       | Filer Name       | text      | text        |
| Yes      | series tag  | department_name  | Department Name  | text      | text        |
| Yes      | series tag  | position_name    | Position Name    | text      | text        |
| Yes      | series tag  | offices          | Offices          | text      | text        |
| Yes      | time        | period_start     | Period Start     | date      | date        |
| No       |             | period_end       | Period End       | date      | date        |
| No       |             | filing_date      | Filing Date      | date      | date        |
| Yes      | series tag  | filer_id         | Filer            | text      | text        |
| Yes      | series tag  | filing_id        | Filing           | text      | text        |
| No       |             | id               | Id               | text      | text        |
| Yes      | series tag  | transaction_type | Transaction Type | text      | text        |
| Yes      | series tag  | comment          | Comment          | text      | text        |

Time Field

Value = period_start
Format & Zone = seconds

Series Fields

Excluded Fields = period_end,filing_date,id

Data Commands

series e:e9vv-n9ta d:2016-01-01T08:00:00.000Z t:filer_name="Chu, Carmen" t:offices="leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Assessor-Recorder,filerDivisionBoardDistrict:Assessor-Recorder,electionDate:None|leavingDate:None,filerAgency:Committee on County Tax Collecting Procedures,assumingDate:None,filerPosition:Appointed Member,filerDivisionBoardDistrict:California Controller's Office,electionDate:None" t:transaction_type=CommentScheduleA1 t:filer_id=SFO-1104 t:comment="Dividends on individual stocks are reinvested automatically. Retirement and other investment funds invested in diversified mutual funds (indices or target funds)." t:department_name=EOBCDH_Assessor-Recorder t:position_name=Assessor-Recorder t:filing_id=164498366 m:row_number.e9vv-n9ta=1

series e:e9vv-n9ta d:2016-01-01T08:00:00.000Z t:filer_name="Chu, Carmen" t:offices="leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Assessor-Recorder,filerDivisionBoardDistrict:Assessor-Recorder,electionDate:None|leavingDate:None,filerAgency:Committee on County Tax Collecting Procedures,assumingDate:None,filerPosition:Appointed Member,filerDivisionBoardDistrict:California Controller's Office,electionDate:None" t:transaction_type=CommentScheduleD t:filer_id=SFO-1104 t:comment="Reported higher value of public ticket price for Lambda Alpha and AIPAC events because could not obtain actual cost information. GGRA reported at public ticket price because could not obtain actual cost information; note, part of the GGRA event proceeds benefited their 501c3 scholarship foundation. SF Super Bowl Host committee is no longer active and does not have a physical address to report, contact information reported is information found on SBHC website." t:department_name=EOBCDH_Assessor-Recorder t:position_name=Assessor-Recorder t:filing_id=164498366 m:row_number.e9vv-n9ta=2

series e:e9vv-n9ta d:2016-01-01T08:00:00.000Z t:filer_name="Chu, Carmen" t:offices="leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Assessor-Recorder,filerDivisionBoardDistrict:Assessor-Recorder,electionDate:None|leavingDate:None,filerAgency:Committee on County Tax Collecting Procedures,assumingDate:None,filerPosition:Appointed Member,filerDivisionBoardDistrict:California Controller's Office,electionDate:None" t:transaction_type=CommentScheduleE t:filer_id=SFO-1104 t:comment="Reimbursement for transportation within CA to speak at Occidental College and meet with students and staff about careers in public service." t:department_name=EOBCDH_Assessor-Recorder t:position_name=Assessor-Recorder t:filing_id=164498366 m:row_number.e9vv-n9ta=3

Meta Commands

metric m:row_number.e9vv-n9ta p:long l:"Row Number"

entity e:e9vv-n9ta l:"Form 700 Comments" t:attribution="Ethics Commission" t:url=https://data.sfgov.org/api/views/e9vv-n9ta

property e:e9vv-n9ta t:meta.view v:id=e9vv-n9ta v:category="City Management and Ethics" v:averageRating=0 v:name="Form 700 Comments" v:attribution="Ethics Commission"

property e:e9vv-n9ta t:meta.view.license v:name="Open Data Commons Public Domain Dedication and License" v:termsLink=http://opendatacommons.org/licenses/pddl/1.0/

property e:e9vv-n9ta t:meta.view.owner v:id=dbag-6qd9 v:screenName=OpenData v:displayName=OpenData

property e:e9vv-n9ta t:meta.view.tableauthor v:id=dbag-6qd9 v:screenName=OpenData v:roleName=publisher v:displayName=OpenData

Top Records

| filer_name                    | department_name                       | position_name     | offices                                                                                                                                                                                                                                                                                                                                                                                | period_start | period_end | filing_date | filer_id   | filing_id | id                               | transaction_type  | comment                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                    | 
| ============================= | ===================================== | ================= | ====================================================================================================================================================================================================================================================================================================================================================================================== | ============ | ========== | =========== | ========== | ========= | ================================ | ================= | ========================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================================== | 
| Chu, Carmen                   | EOBCDH_Assessor-Recorder              | Assessor-Recorder | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Assessor-Recorder,filerDivisionBoardDistrict:Assessor-Recorder,electionDate:None|leavingDate:None,filerAgency:Committee on County Tax Collecting Procedures,assumingDate:None,filerPosition:Appointed Member,filerDivisionBoardDistrict:California Controller's Office,electionDate:None | 1451635200   | 1483171200 | 1491204107  | SFO-1104   | 164498366 | cf931ba0a9384b37a11d6e39f5850c2e | CommentScheduleA1 | Dividends on individual stocks are reinvested automatically. Retirement and other investment funds invested in diversified mutual funds (indices or target funds).                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | 
| Chu, Carmen                   | EOBCDH_Assessor-Recorder              | Assessor-Recorder | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Assessor-Recorder,filerDivisionBoardDistrict:Assessor-Recorder,electionDate:None|leavingDate:None,filerAgency:Committee on County Tax Collecting Procedures,assumingDate:None,filerPosition:Appointed Member,filerDivisionBoardDistrict:California Controller's Office,electionDate:None | 1451635200   | 1483171200 | 1491204107  | SFO-1104   | 164498366 | ed88effa8e2140c1894da08d389fc377 | CommentScheduleD  | Reported higher value of public ticket price for Lambda Alpha and AIPAC events because could not obtain actual cost information. GGRA reported at public ticket price because could not obtain actual cost information; note, part of the GGRA event proceeds benefited their 501c3 scholarship foundation. SF Super Bowl Host committee is no longer active and does not have a physical address to report, contact information reported is information found on SBHC website.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| Chu, Carmen                   | EOBCDH_Assessor-Recorder              | Assessor-Recorder | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Assessor-Recorder,filerDivisionBoardDistrict:Assessor-Recorder,electionDate:None|leavingDate:None,filerAgency:Committee on County Tax Collecting Procedures,assumingDate:None,filerPosition:Appointed Member,filerDivisionBoardDistrict:California Controller's Office,electionDate:None | 1451635200   | 1483171200 | 1491204107  | SFO-1104   | 164498366 | a4bb228163cf474fae030acea3cb9a40 | CommentScheduleE  | Reimbursement for transportation within CA to speak at Occidental College and meet with students and staff about careers in public service.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                | 
| Chu, Carmen                   | EOBCDH_Assessor-Recorder              | Assessor-Recorder | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Assessor-Recorder,filerDivisionBoardDistrict:Assessor-Recorder,electionDate:None|leavingDate:None,filerAgency:Committee on County Tax Collecting Procedures,assumingDate:None,filerPosition:Appointed Member,filerDivisionBoardDistrict:California Controller's Office,electionDate:None | 1451635200   | 1483171200 | 1491204107  | SFO-1104   | 164498366 | ee14b7cd8b8440f29b13e661183a6fbd | CommentScheduleB  | Neither properties are rental properties. Both are used by self or family member.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                          | 
| Hennessy, Vicki               | EOBCDH_Sheriff's Department           | Sheriff           | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Sheriff,filerDivisionBoardDistrict:Sheriff's Department,electionDate:None                                                                                                                                                                                                                | 1452326400   | 1483171200 | 1490993020  | SFO-1640   | 164473689 | cc7a27aeb8094f9aa1c1f62ddc8aecf9 | CommentScheduleB  | I own 1/3rd of the property listed. My adult child, who also owns 1/3 lives in the property and does not pay rent.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                         | 
| Christian, Susan              | EOBCDH_Human Rights Commission        | Commissioner      | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Human Rights Commission,electionDate:None|leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Assistant District Attorney,filerDivisionBoardDistrict:District Attorneys Office,electionDate:None       | 1451635200   | 1483171200 | 1490919816  | SFO-152809 | 164452344 | 2d940482dd814bf185d99675c5ae1529 | CommentScheduleB  | The tenant rents space within the property reported at Schedule A-2 which cannot be sold separately from that property. As such, the space rented has no true market value apart from the property reported at Schedule A-2.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                               | 
| Konstin, John                 | EOBCDH_Building Inspection Commission | Commissioner      | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Building Inspection Commission,electionDate:None                                                                                                                                                                                                 | 1452412800   | 1483171200 | 1490905380  | SFO-154174 | 164431845 | e63c5735aeae49ddafbf7d46c705239f | CommentScheduleC  | Deleted loan information as it is not required under the terms.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                            | 
| Konstin, John                 | EOBCDH_Building Inspection Commission | Commissioner      | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Building Inspection Commission,electionDate:None                                                                                                                                                                                                 | 1452412800   | 1483171200 | 1490905380  | SFO-154174 | 164431845 | c59dd79fd2e746bc9ad7f4664a3c87df | CommentScheduleB  | Deleted personal residence and all loan information as it is not required under the terms. Sold one property so there are fewer.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                           | 
| Tsakopoulos Kounalakis, Eleni | EOBCDH_Port Commission                | Commissioner      | leavingDate:None,filerAgency:San Francisco Port Commission,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:None,electionDate:None                                                                                                                                                                                                                              | 1451635200   | 1483171200 | 1490295496  | SFO-1594   | 164204449 | 00c214aab194456da8ef258bc876b3b2 | CommentScheduleA2 | A) The filer is a member of the Switch Building Investors, LP. Switch Building Investors, LP has the following tenants which appear to have operations in the City and County of San Francisco and the filer receives more than $10, 000 in gross receipts annually:1) Ed Dudensing; and2)The California EndowmentB) The filer is a member of the 1415 Meridian Plaza Investors, LP. The 1415 Meridian Plaza Investors, LP has the following tenants which appear to have operations in the City and County of San Francisco and the filer receives more than $10,000 in gross receipts annually. The tenants are as follows: 1)American West Bank; 2) Microsoft Corporation; 3) California Beer and Beverage Distribution; 4) PG&E; 5) Kahn, Soares & Conway; 6) Wilson Miller Communications, Inc. and Stutzman Public Affairs, LLC; 7) Anton Development; 8) California Department of Public Health; 9) Western States Petroleum Association; 10) Aprea & Micheli; 11) JP Morgan Chase; 12) Property Casualty Insurers Association of America; 13) Accenture; 14) California Strawberry Commission; 15) Union Bank; 16) Brownstein, Hyatt, Farber and Schreck, LLP; 17) California Health Foundations; 18) California Health Plans; 19) AARP; 20) Shaw Yoder; 21) California Alliance for Jobs; 22) Aaron Read; 23) Altria; 24) Hawkins; 25) Alliance of Automobile Manufacturers; and 26) Nielsen, MerksamerC) The filer is a member of the AKT Meridian Plaza Investors, LLC. AKT Meridian Plaza Investors, LLC has the following tenants which appear to have operations in the City and County of San Francisco and the filer receives more than $10,000 in gross receipts annually. The tenants are as follows: 1)American West Bank; 2) Microsoft Corporation; 3) California Beer and Beverage Distribution; 4) PG&E; 5) Kahn, Soares & Conway; 6) Wilson Miller Communications, Inc. and Stutzman Public Affairs, LLC; 7) Anton Development; 8) California Department of Public Health; 9) Western States Petroleum Association; 10) Aprea & Micheli; 11) JP Morgan Chase; 12) Property Casualty Insurers Association of America; 13) Accenture; 14) California Strawberry Commission; 15) Union Bank; 16) Brownstein, Hyatt, Farber and Schreck, LLP; 17) California Health Foundations; 18) California Health Plans; 19) AARP; 20) Shaw Yoder; 21) California Alliance for Jobs; 22) Aaron Read; 23) Altria; 24) Hawkins; 25) Alliance of Automobile Manufacturers; and 26) Nielsen, Merksamer | 
| Tsakopoulos Kounalakis, Eleni | EOBCDH_Port Commission                | Commissioner      | leavingDate:None,filerAgency:San Francisco Port Commission,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:None,electionDate:None                                                                                                                                                                                                                              | 1451635200   | 1483171200 | 1490295496  | SFO-1594   | 164204449 | d2047b18fc634c66a3bd9c8fde1256e8 | CommentScheduleD  | No reportable income from gifts received.                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                                  |