About this Dataset

Form 700 Cover

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. Basic Information about the filing. Link to Form 700 overview: http://www.fppc.ca.gov/Form700.html This dataset contains cover page records 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:48.819293
Tags: ethics, form-700, schedules, sei, statement-of-economic-interests

Tables

Table 1

@usgov.city_of_san_francisco_form_700_cover.table_1

2.69 MB
31,368 rows
42 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,
  "year" BIGINT,
  "annualstartdate" TIMESTAMP,
  "leavingstatementstartdate" TIMESTAMP,
  "dateassumedoffice" TIMESTAMP,
  "dateleftoffice" TIMESTAMP,
  "firstname" VARCHAR,
  "middlename" VARCHAR,
  "lastname" VARCHAR,
  "descriptioncity" VARCHAR,
  "descriptioncounty" VARCHAR,
  "descriptionmulticounty" VARCHAR,
  "descriptionother" VARCHAR,
  "isannual" BOOLEAN,
  "isassuming" BOOLEAN,
  "iscandidate" BOOLEAN,
  "iscity" BOOLEAN,
  "iscounty" BOOLEAN,
  "isjudgeorcourt" BOOLEAN,
  "isleaving" BOOLEAN,
  "ismulticounty" BOOLEAN,
  "isother" BOOLEAN,
  "isstate" BOOLEAN,
  "schedulea1count" BIGINT,
  "schedulea2count" BIGINT,
  "schedulebcount" BIGINT,
  "schedulec1count" BIGINT,
  "schedulec2count" BIGINT,
  "scheduledcount" BIGINT,
  "scheduleecount" BIGINT,
  "commentcount" BIGINT,
  "categories" VARCHAR,
  "form" BIGINT
);