About this Dataset

SFEC Form 126f4 - Notification Of Contract Approval - Filings

Each City elective officer who approves a contract that has a total anticipated or actual value of $100,000 or more must file this form with the Ethics Commission within five business days of approval by: (a) the City elective officer, (b) any board on which the City elective officer serves, or (c) the board of any state agency on which an appointee of the City elective officer serves. For more information, see: https://sfethics.org/compliance/city-officers/city-contracts/contract-approval-by-city-elective-officers.

This dataset includes paper SFEC Form 126 Notification of Contract Approval Filings from 2002 to November 2018, electronic SFEC Form 126 Notification of Contract Approval Filings between mid-October 2018 to December 31, 2018 and SFEC Form 126f4 Notification of Contract Approval Filings beginning January 1, 2019.

A copy of legacy filings without a url in the "Filing" column can be found archived on the Ethics Commission website: https://sfethics.org/ethics/category/contracts

The Affiliates and Subcontractors dataset (https://data.sfgov.org/d/czjm-dat8/) must be joined with the parent dataset (https://data.sfgov.org/d/ite2-5y3b) using the DocuSignID to connect affiliates and subcontractors to the approved contract.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:39.970752

Tables

Table 1

@usgov.city_of_san_francisco_sfec_form_126f4_notification_of__49b71c8f.table_1

1.93 MB
10,956 rows
37 columns

CREATE TABLE table_1 (
  "contractdate" TIMESTAMP,
  "docusignid" VARCHAR,
  "filing" VARCHAR,
  "filingtype" VARCHAR,
  "originalfilingdate" TIMESTAMP,
  "filercontactname" VARCHAR,
  "filercontactdepartmentname" VARCHAR,
  "filercontactemail" VARCHAR,
  "filercontacttelephone" VARCHAR,
  "departmentcontactname" VARCHAR,
  "departmentcontactdepartmentname" VARCHAR,
  "departmentcontactemail" VARCHAR,
  "departmentcontacttelephone" VARCHAR,
  "electiveofficername" VARCHAR,
  "electiveofficeroffice" VARCHAR,
  "contractorname" VARCHAR,
  "contractortelephone" VARCHAR,
  "contractoraddress" VARCHAR,
  "contractoremail" VARCHAR,
  "contractthresholdaffirmation" VARCHAR,
  "contractfilenumber" VARCHAR,
  "contractdescription" VARCHAR,
  "comments" VARCHAR,
  "contractapprovalcityelectiveofficer" VARCHAR,
  "contractapprovalboardstateagency" VARCHAR,
  "boardstateagency" VARCHAR,
  "contractapprovalboard" VARCHAR,
  "boardname" VARCHAR,
  "partiessubtablequery" VARCHAR,
  "supplementalcheck" VARCHAR,
  "signername" VARCHAR,
  "datesigned" VARCHAR,
  "amendmentdescription" VARCHAR,
  "bidrfpnumber" VARCHAR,
  "uploadeddate" TIMESTAMP,
  "descriptionofamount" VARCHAR,
  "departmentcontactdepartmentcode" VARCHAR
);