About this Dataset

SFEC Departmental Gifts Disclosure Cover Page

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 an overview of each department filing, such as the total number of gifts and gift value, filing period, and amendments. 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 “Envelope Id”. Individual filings from departments can be identified by the columns Filing Month, Filing Year, and DepartmentNameLookup. Amendment filings can be identified by the column TypeOfFiling. E. RELATED DATASETS For detailed information about individual gifts reported by departments, visit the associated dataset, SFEC Departmental Gifts Disclosure List of Gifts. A combined view of both datasets is also available: SFEC Departmental Gifts Disclosure Joined View.
Organization: City of San Francisco
Last updated: 2025-03-29T16:50:27.459210

Tables

Table 1

@usgov.city_of_san_francisco_sfec_departmental_gifts_disclosu_05b739a8.table_1

24.86 KB
90 rows
14 columns


CREATE TABLE table_1 (
  "filingseries" VARCHAR,
  "maininformation_filingmonth" VARCHAR,
  "maininformation_filingyear" BIGINT,
  "maininformation_departmentnamelookup" VARCHAR,
  "maininformation_typeoffiling" VARCHAR,
  "maininformation_amendmentexplained" VARCHAR,
  "maininformation_optionalcomments" VARCHAR,
  "maininformation_calcstartdate" TIMESTAMP,
  "maininformation_calcenddate" TIMESTAMP,
  "giftslist_giftssummary_totalnumberofgifts" BIGINT,
  "giftslist_giftssummary_totalgiftvalue" DOUBLE,
  "envelope_id" VARCHAR,
  "docusign_filing" VARCHAR,
  "date_signed_pacific_time" VARCHAR
);