Form 700 Schedule A2

Dataset

Name Value
Catalog Link
Metadata Link
Data: JSON 100 Rows
Data: CSV 100 Rows
Host data.sfgov.org
Id j82c-uj4d
Name Form 700 Schedule A2
Attribution Ethics Commission
Category City Management and Ethics
Tags ethics, form 700, schedules, sei, statement of economic interests
Created 2016-05-18T18:12:49Z
Publication Date 2016-06-13T22:36:41Z

Description

Business entities (including certain independent contracting) sole proprietorships, partnerships, LLCs, corportaitons, and trusts 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     | entity_name                                            | Entity Name                                            | text      | text        |
| No       |                | address                                                | Address                                                | text      | text        |
| Yes      | series tag     | city                                                   | City                                                   | text      | text        |
| Yes      | series tag     | state                                                  | State                                                  | text      | text        |
| Yes      | series tag     | zip                                                    | Zipcode                                                | text      | text        |
| Yes      | series tag     | business_type                                          | Business Type                                          | text      | text        |
| Yes      | series tag     | description                                            | Description                                            | text      | text        |
| Yes      | numeric metric | fair_market_value_schedule_a2                          | Fair Market Value Schedule A2                          | money     | money       |
| Yes      | series tag     | fair_market_value_schedule_a2_as_range                 | Fair Market Value Schedule A2 As Range                 | text      | text        |
| No       |                | date_acquired                                          | Date Acquired                                          | date      | date        |
| No       |                | date_disposed                                          | Date Disposed                                          | date      | date        |
| Yes      | series tag     | nature_of_investment                                   | Nature Of Investment                                   | text      | text        |
| Yes      | series tag     | nature_of_investment_other_description                 | Nature Of Investment Other Description                 | text      | text        |
| Yes      | series tag     | business_position                                      | Business Position                                      | text      | text        |
| Yes      | numeric metric | gross_income_received                                  | Gross Income Received                                  | money     | money       |
| Yes      | series tag     | gross_income_received_as_range                         | Gross Income Received As Range                         | text      | text        |
| Yes      | series tag     | income_sources                                         | Income Sources                                         | text      | text        |
| Yes      | series tag     | real_property_investment_type                          | Real Property Investment Type                          | text      | text        |
| Yes      | series tag     | real_property_business_name                            | Real Property Business Name                            | text      | text        |
| No       |                | real_property_parcel_address                           | Real Property Parcel Address                           | text      | text        |
| Yes      | series tag     | real_property_description_or_city_or_location          | Real Property Description Or City Or Location          | text      | text        |
| No       |                | real_property_date_acquired                            | Real Property Date Acquired                            | date      | date        |
| No       |                | real_property_date_disposed                            | Real Property Date Disposed                            | date      | date        |
| Yes      | numeric metric | real_property_fair_market_value                        | Real Property Fair Market Value                        | money     | money       |
| Yes      | series tag     | real_property_fair_market_value_as_range               | Real Property Fair Market Value As Range               | text      | text        |
| Yes      | series tag     | real_property_nature_of_interest                       | Real Property Nature Of Interest                       | text      | text        |
| Yes      | series tag     | real_property_nature_of_interest_lease_years_remaining | Real Property Nature Of Interest Lease Years Remaining | text      | text        |
| Yes      | series tag     | real_property_nature_of_interest_other_description     | Real Property Nature Of Interest Other Description     | text      | text        |

Time Field

Value = period_start
Format & Zone = seconds

Series Fields

Excluded Fields = period_end,filing_date,id,address,date_acquired,date_disposed,real_property_parcel_address,real_property_date_acquired,real_property_date_disposed

Data Commands

series e:j82c-uj4d d:2016-01-01T08:00:00.000Z t:zip=94123 t:filer_name="Hasz, Karl" t:business_position=President t:transaction_type=ScheduleA2 t:state=CA t:fair_market_value_schedule_a2_as_range="$0 - $1,999" t:position_name=Commissioner t:city="San Francisco" t:entity_name="Hasz Construction, Inc." t:nature_of_investment=Other t:nature_of_investment_other_description=Corporation t:offices="leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Historic Preservation Commission,electionDate:None" t:description="Construction & Construction Management" t:filer_id=SFO-1949 t:business_type="Business Entity" t:department_name="EOBCDH_Historic Preservation Commission" t:gross_income_received_as_range="$10,001 - $100,000" t:filing_id=164610655 m:fair_market_value_schedule_a2=1000 m:gross_income_received=10000 m:real_property_fair_market_value=0

series e:j82c-uj4d d:2016-01-01T08:00:00.000Z t:zip=94117 t:filer_name="Stewart, Pablo" t:transaction_type=ScheduleA2 t:state=CA t:fair_market_value_schedule_a2_as_range=Unset t:position_name=Commissioner t:city="San Francisco" t:entity_name="Uyehara-Stewart Trust" t:nature_of_investment=Unset t:offices="leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Human Services Commission,electionDate:None" t:filer_id=SFO-1350 t:business_type=Trust t:department_name="EOBCDH_Human Services Commission" t:gross_income_received_as_range="$0 - $499" t:filing_id=164599016 m:fair_market_value_schedule_a2=0 m:gross_income_received=250 m:real_property_fair_market_value=0

series e:j82c-uj4d d:2016-01-01T08:00:00.000Z t:zip=94117 t:filer_name="Stewart, Pablo" t:business_position=owner t:transaction_type=ScheduleA2 t:state=CA t:fair_market_value_schedule_a2_as_range="$10,001 - $100,000" t:position_name=Commissioner t:city="San Francisco" t:entity_name="Pablo stewart, M.D." t:nature_of_investment="Sole Proprietorship" t:offices="leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Human Services Commission,electionDate:None" t:description=Consulting t:income_sources="name:MCLAP|name:Maricopa County|name:ACLU|name:RBGG Law Firm|name:District Court Hawaii|name:District Court San Francisco|name:Manatt, Phelps & Phillips,LLP|name:The Institute|name:Kern County|name:Administrative Office Of the Courts|name:Southern Poverty Law Center|name:Pima County|name:District Court, Shreveport, LA" t:filer_id=SFO-1350 t:business_type="Business Entity" t:department_name="EOBCDH_Human Services Commission" t:gross_income_received_as_range="Over $100,000" t:filing_id=164599016 m:fair_market_value_schedule_a2=10000 m:gross_income_received=100000 m:real_property_fair_market_value=0

Meta Commands

metric m:fair_market_value_schedule_a2 p:double l:"Fair Market Value Schedule A2" t:dataTypeName=money

metric m:gross_income_received p:integer l:"Gross Income Received" t:dataTypeName=money

metric m:real_property_fair_market_value p:double l:"Real Property Fair Market Value" t:dataTypeName=money

entity e:j82c-uj4d l:"Form 700 Schedule A2" t:attribution="Ethics Commission" t:url=https://data.sfgov.org/api/views/j82c-uj4d

property e:j82c-uj4d t:meta.view v:id=j82c-uj4d v:category="City Management and Ethics" v:averageRating=0 v:name="Form 700 Schedule A2" v:attribution="Ethics Commission"

property e:j82c-uj4d 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:j82c-uj4d t:meta.view.owner v:id=dbag-6qd9 v:screenName=OpenData v:displayName=OpenData

property e:j82c-uj4d 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 | entity_name                  | address    | city          | state | zip    | business_type   | description                            | fair_market_value_schedule_a2 | fair_market_value_schedule_a2_as_range | date_acquired | date_disposed | nature_of_investment | nature_of_investment_other_description | business_position | gross_income_received | gross_income_received_as_range | income_sources                                                                                                                                                                                                                                                                                                                  | real_property_investment_type | real_property_business_name                     | real_property_parcel_address | real_property_description_or_city_or_location      | real_property_date_acquired | real_property_date_disposed | real_property_fair_market_value | real_property_fair_market_value_as_range | real_property_nature_of_interest | real_property_nature_of_interest_lease_years_remaining | real_property_nature_of_interest_other_description | 
| ================ | =========================================== | ======================= | ======================================================================================================================================================================================================= | ============ | ========== | =========== | ========== | ========= | ================================ | ================ | ============================ | ========== | ============= | ===== | ====== | =============== | ====================================== | ============================= | ====================================== | ============= | ============= | ==================== | ====================================== | ================= | ===================== | ============================== | =============================================================================================================================================================================================================================================================================================================================== | ============================= | =============================================== | ============================ | ================================================== | =========================== | =========================== | =============================== | ======================================== | ================================ | ====================================================== | ================================================== | 
| Hasz, Karl       | EOBCDH_Historic Preservation Commission     | Commissioner            | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Historic Preservation Commission,electionDate:None                | 1451635200   | 1483171200 | 1491501742  | SFO-1949   | 164610655 | ca8bcf89c0b64003b2b6a313aca78056 | ScheduleA2       | Hasz Construction, Inc.      | [REDACTED] | San Francisco | CA    | 94123  | Business Entity | Construction & Construction Management | 1000.0                        | $0 - $1,999                            |               |               | Other                | Corporation                            | President         | 10000                 | $10,001 - $100,000             |                                                                                                                                                                                                                                                                                                                                 |                               |                                                 |                              |                                                    |                             |                             | 0.0                             |                                          |                                  |                                                        |                                                    | 
| Stewart, Pablo   | EOBCDH_Human Services Commission            | Commissioner            | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Human Services Commission,electionDate:None                       | 1451635200   | 1483171200 | 1491418525  | SFO-1350   | 164599016 | f1b073ebdfbe46f382a957f6fdf63e54 | ScheduleA2       | Uyehara-Stewart Trust        | [REDACTED] | San Francisco | CA    | 94117  | Trust           |                                        | 0.0                           | Unset                                  |               |               | Unset                |                                        |                   | 250                   | $0 - $499                      |                                                                                                                                                                                                                                                                                                                                 |                               |                                                 |                              |                                                    |                             |                             | 0.0                             |                                          |                                  |                                                        |                                                    | 
| Stewart, Pablo   | EOBCDH_Human Services Commission            | Commissioner            | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Human Services Commission,electionDate:None                       | 1451635200   | 1483171200 | 1491418525  | SFO-1350   | 164599016 | 8d765901a4ba443aa34c1d074de1c0fc | ScheduleA2       | Pablo stewart, M.D.          | [REDACTED] | San Francisco | CA    | 94117  | Business Entity | Consulting                             | 10000.0                       | $10,001 - $100,000                     |               |               | Sole Proprietorship  |                                        | owner             | 100000                | Over $100,000                  | name:MCLAP|name:Maricopa County|name:ACLU|name:RBGG Law Firm|name:District Court Hawaii|name:District Court San Francisco|name:Manatt, Phelps & Phillips,LLP|name:The Institute|name:Kern County|name:Administrative Office Of the Courts|name:Southern Poverty Law Center|name:Pima County|name:District Court, Shreveport, LA |                               |                                                 |                              |                                                    |                             |                             | 0.0                             |                                          |                                  |                                                        |                                                    | 
| Pugash, Anderson | EOBCDH_Golden Gate Park Concourse Authority | Board Member (Director) | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Board Member (Director),filerDivisionBoardDistrict:Golden Gate Park Concourse Authority,electionDate:None | 1451635200   | 1483171200 | 1491342688  | SFO-151556 | 164584757 | ce70892bf0164cff81b83cf86d643083 | ScheduleA2       | Louies                       | [REDACTED] | San Francisco | CA    | 941111 | Business Entity | Restaurant and Bar                     | 10000.0                       | $10,001 - $100,000                     |               |               | Other                | LLC                                    | Investor          | 10000                 | $10,001 - $100,000             |                                                                                                                                                                                                                                                                                                                                 |                               |                                                 |                              |                                                    |                             |                             | 0.0                             |                                          |                                  |                                                        |                                                    | 
| Pugash, Anderson | EOBCDH_Golden Gate Park Concourse Authority | Board Member (Director) | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Board Member (Director),filerDivisionBoardDistrict:Golden Gate Park Concourse Authority,electionDate:None | 1451635200   | 1483171200 | 1491342688  | SFO-151556 | 164584757 | de9119799b9b49fab5baea4e1f621bb0 | ScheduleA2       | Dorian LLC                   | [REDACTED] | San Francisco | CA    | 94123  | Business Entity | Restaurant                             | 100000.0                      | $100,001 - $1,000,000                  |               |               | Other                | LLC                                    | Owner             | 10000                 | $10,001 - $100,000             |                                                                                                                                                                                                                                                                                                                                 |                               |                                                 |                              |                                                    |                             |                             | 0.0                             |                                          |                                  |                                                        |                                                    | 
| Pugash, Anderson | EOBCDH_Golden Gate Park Concourse Authority | Board Member (Director) | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Board Member (Director),filerDivisionBoardDistrict:Golden Gate Park Concourse Authority,electionDate:None | 1451635200   | 1483171200 | 1491342688  | SFO-151556 | 164584757 | 043d110a8f0f4abf9f54f294b512eaf9 | ScheduleA2       | Blue Plantain LLC            | [REDACTED] | San Francisco | Ca    | 94123  | Business Entity | Restaurant                             | 100000.0                      | $100,001 - $1,000,000                  |               |               | Other                | LLC                                    | CEO               | 10000                 | $10,001 - $100,000             |                                                                                                                                                                                                                                                                                                                                 |                               |                                                 |                              |                                                    |                             |                             | 0.0                             |                                          |                                  |                                                        |                                                    | 
| Pugash, Anderson | EOBCDH_Golden Gate Park Concourse Authority | Board Member (Director) | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Board Member (Director),filerDivisionBoardDistrict:Golden Gate Park Concourse Authority,electionDate:None | 1451635200   | 1483171200 | 1491342688  | SFO-151556 | 164584757 | ea306bda63934e71b95ceaf17b5acad6 | ScheduleA2       | Bergerac/Audio               | [REDACTED] | San Francisco | CA    | 94106  | Business Entity | Bar and restaurant                     | 100000.0                      | $100,001 - $1,000,000                  |               |               | Other                | LLC                                    | CEO               | 10000                 | $10,001 - $100,000             |                                                                                                                                                                                                                                                                                                                                 |                               |                                                 |                              |                                                    |                             |                             | 0.0                             |                                          |                                  |                                                        |                                                    | 
| Semel, Rita      | EOBCDH_Human Services Commission            | Commissioner            | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Human Services Commission,electionDate:None                       | 1451635200   | 1483171200 | 1491341070  | SFO-153285 | 164583456 | 4e33eade65054b39bd421bbcfb64bbfd | ScheduleA2       | Rita Semel Survivor Trust    | [REDACTED] | San Francisco | CA    | 94109  | Trust           |                                        | 0.0                           | Unset                                  |               |               | Unset                |                                        |                   | 500                   | $500 - $1,000                  |                                                                                                                                                                                                                                                                                                                                 | Investment                    | 2190 Washington St. #907San Francisco, CA 94109 | [REDACTED]                   | Personal Trust                                     |                             |                             | 10000.0                         | $10,001 - $100,000                       | Other                            |                                                        | Cash                                               | 
| Semel, Rita      | EOBCDH_Human Services Commission            | Commissioner            | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Commissioner,filerDivisionBoardDistrict:Human Services Commission,electionDate:None                       | 1451635200   | 1483171200 | 1491341070  | SFO-153285 | 164583456 | 28a0efd070d94a509cc8f47b852bcd94 | ScheduleA2       | Max Semel Trust B            | [REDACTED] | San Francisco | CA    | 94109  | Trust           |                                        | 0.0                           | Unset                                  |               |               | Unset                |                                        |                   | 10000                 | $10,001 - $100,000             | name:Charles Schwab                                                                                                                                                                                                                                                                                                             | Investment                    | 2190 Washington St. #907San Francisco, CA 94109 | [REDACTED]                   | Trust (R. Semel, income benef. w/ right to prncpl) |                             |                             | 1000000.0                       | Over $1,000,000                          | Other                            |                                                        | Cash and Bonds                                     | 
| Santos, Rodrigo  | EOBCDH_Workforce Investment Board           | Member                  | leavingDate:None,filerAgency:City and County of San Francisco,assumingDate:None,filerPosition:Member,filerDivisionBoardDistrict:Workforce Investment Board,electionDate:None                            | 1451635200   | 1483171200 | 1491334142  | SFO-1942   | 164578289 | 2234287bcb7846e183127d8c5f59bf3c | ScheduleA2       | Santos & Urrutia Partnership | [REDACTED] | San Francisco | CA    | 94110  | Business Entity | Real Estate/Rental                     | 1000000.0                     | Over $1,000,000                        |               |               | Partnership          |                                        | Partner           | 10000                 | $10,001 - $100,000             | name:Santos & Urrutia Inc|name:Matthew Methner|name:Jennifer Whitmore|name:Gloria Galang|name:Abhishek Agrawal                                                                                                                                                                                                                  | Real Property                 | 374 Guerrero St, SF                             | [REDACTED]                   | Rental                                             |                             |                             | 1000000.0                       | Over $1,000,000                          | Partnership                      |                                                        |                                                    |