Form 700 Schedule A1 - Investments: Stocks, Bonds, And Other Interests by US Government | Finance and Economics

About this Dataset

Form 700 Schedule A1 - Investments: Stocks, Bonds, And Other Interests

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 in stocks, bonds, and other interests where ownership interest is less than 10% (including those held in IRA or 401K) Link to Form 700 overview: http://www.fppc.ca.gov/Form700.html This dataset contains records from Schedule A1 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:45.715958
Tags: ethics, form-700, schedules, sei, statement-of-economic-interests

Tables

Table 1

@usgov.city_of_san_francisco_form_700_schedule_a1_investments_3adee87d.table_1

3.4 MB
69643 rows
20 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,
  "businessdescription" VARCHAR,
  "dateacquired" TIMESTAMP,
  "datedisposed" TIMESTAMP,
  "fairmarketvalue" BIGINT,
  "fairmarketvalueasrange" VARCHAR,
  "nameofbusinessentity" VARCHAR,
  "natureofinvestment" VARCHAR,
  "natureofinvestmentotherdescription" VARCHAR,
  "partnershipamount" DOUBLE,
  "partnershipamountasrange" VARCHAR
);