About this Dataset

Form 700 Schedule A2 - Investments, Income, And Assets Of Business Entities/Trusts

This dataset is updated weekly. For more up-to-date filings, refer to the "View Filed Statements" or "Search Within Statements" links on the Ethics Commission webpage. Investments, income, and assets of business entities/trusts where ownership interest is 10% or greater. Business entities (including certain independent contracting), sole proprietorships, partnerships, LLCs, corporations, and trusts. Link to Form 700 overview: http://www.fppc.ca.gov/Form700.html In this dataset the fields "address" and "realProperty_parcelAddress" are redacted. This dataset contains records from Schedule A2 across electronic Form 700 filings with the SFEC since January 1, 2014. To see all the data from a specific filing, you should search all the datasets listed on this page and filter by the filingId of the specific filing. Prior to the start of e-filing for all in 2022, elected officials, department heads, and members of boards and Commissions filed the Form 700 with the Ethics Commission; designated employees filed the Form 700 on paper with their department's designated filing officer.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:13.494830
Tags: ethics, form-700, schedules, sei, statement-of-economic-interests

Tables

Table 1

@usgov.city_of_san_francisco_form_700_schedule_a2_investments_786588dd.table_1

694.67 kB
10,889 rows
38 columns

CREATE TABLE table_1 (
  "id" VARCHAR,
  "filerid" VARCHAR,
  "filingid" BIGINT,
  "filername" VARCHAR,
  "filingdate" VARCHAR,
  "departmentname" VARCHAR,
  "positionname" VARCHAR,
  "offices" VARCHAR,
  "periodstart" TIMESTAMP,
  "periodend" TIMESTAMP,
  "entityname" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "businesstype" VARCHAR,
  "description" VARCHAR,
  "natureofinvestment" VARCHAR,
  "natureofinvestment_otherdescription" VARCHAR,
  "businessposition" VARCHAR,
  "dateacquired" TIMESTAMP,
  "datedisposed" TIMESTAMP,
  "fairmarketvalueschedulea2" DOUBLE,
  "fairmarketvalueschedulea2asrange" VARCHAR,
  "grossincomereceived" BIGINT,
  "grossincomereceivedasrange" VARCHAR,
  "incomesources" VARCHAR,
  "realproperty_investmenttype" VARCHAR,
  "realproperty_businessname" VARCHAR,
  "realproperty_parceladdress" VARCHAR,
  "realproperty_descriptionorcityorlocation" VARCHAR,
  "realproperty_dateacquired" TIMESTAMP,
  "realproperty_datedisposed" TIMESTAMP,
  "realproperty_fairmarketvalue" DOUBLE,
  "realproperty_fairmarketvalueasrange" VARCHAR,
  "realproperty_natureofinterest" VARCHAR,
  "realproperty_natureofinterest_leaseyearsremaining" VARCHAR,
  "realproperty_natureofinterest_otherdescription" VARCHAR
);