About this Dataset

Form 700 Schedule D - Income: Gifts

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. Gifts (such as tickets to sporting or entertainment events) Link to Form 700 overview: http://www.fppc.ca.gov/Form700.html In this dataset the "address" field is redacted. This dataset contains records from Schedule D 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:57:06.510642
Tags: ethics, form-700, schedules, sei, statement-of-economic-interests

Tables

Table 1

@usgov.city_of_san_francisco_form_700_schedule_d_income_gifts.table_1

382.82 kB
6,298 rows
19 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,
  "nameofsource" VARCHAR,
  "businessactivity" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "amount" DOUBLE,
  "description" VARCHAR,
  "giftdate" TIMESTAMP
);