About this Dataset

Form 700 Comments

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. Comments about Form 700 schedules Link to Form 700 overview: http://www.fppc.ca.gov/Form700.html This dataset contains records from the comments sections 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:06.203024
Tags: ethics, form-700, schedules, sei, statement-of-economic-interests

Tables

Table 1

@usgov.city_of_san_francisco_form_700_comments.table_1

125.14 kB
631 rows
12 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,
  "comment" VARCHAR,
  "transactiontype" BIGINT
);