About this Dataset

SFEC Departmental Gifts Disclosure List Of Gifts

A. SUMMARY Section 3.217 of the Campaign and Governmental Conduct Code requires each Department Head to disclose payments that their department receives from a source that is not a federal, state, or local government and for which the department does not provide equal or greater consideration. Each department accepting gifts will disclose all gifts received during the calendar month from a source that is not a federal, state, or local government. Departments will be expected to submit one disclosure form covering all gifts received in the preceding calendar month, when applicable. This dataset provides detailed information about individual gifts reported by departments, such as the gift donor name, date of gift receipt, and gift value. For more information, visit the Ethics Commission’s webpage on Gifts to city departments. B. HOW THE DATASET IS CREATED Data for this dataset is created when departments file the gifts disclosure form provided by the Ethics Commission, starting in December 2024. This form is due within 15 calendar days after the end of the month the department received the gift(s). If a department has not received any gifts in a given month, no filing is necessary. C. UPDATE PROCESS The dataset is updated via the Socrata Publisher API as needed when form filings are submitted and signed by city departments. D. HOW TO USE THIS DATASET The unique row identifier for this dataset is “Entry Id”, which is obtained by adding an index to the “Envelope Id”. The “Filing Series” column can be used to identify the filing period (year and month) and department of each gift entry. For full context, this dataset should be joined with the Cover Page dataset by the Envelope Id column. E. RELATED DATASETS For an overview of each department filing and any amendment filings, visit the associated dataset SFEC Departmental Gifts Disclosure Cover Page. A combined view of both datasets is also available: SFEC Departmental Gifts Disclosure Joined View.
Organization: City of San Francisco
Last updated: 2025-03-29T17:14:58.073952

Tables

Table 1

@usgov.city_of_san_francisco_sfec_departmental_gifts_disclosu_ebc50594.table_1

65.67 KB
368 rows
14 columns


CREATE TABLE table_1 (
  "filing_series" VARCHAR,
  "giftslist_listofgifts_donorname" VARCHAR,
  "giftslist_listofgifts_datereceived" TIMESTAMP,
  "giftslist_listofgifts_totaldollarvalue" DOUBLE,
  "giftslist_listofgifts_descriptionofgift" VARCHAR,
  "giftslist_listofgifts_purposeanduse" VARCHAR,
  "giftslist_listofgifts_departmentcontract" VARCHAR,
  "giftslist_listofgifts_licensepermitentitlement" VARCHAR,
  "giftslist_listofgifts_issuedlicensepermitentitlement" VARCHAR,
  "giftslist_listofgifts_financialinterest" VARCHAR,
  "giftslist_listofgifts_additionalinformation" VARCHAR,
  "giftslist_listofgifts_giftreceipients_aggregate" VARCHAR,
  "envelope_id" VARCHAR,
  "entry_id" VARCHAR
);