About this Dataset

SFEC Form 126f4 - Notification Of Contract Approval - Affiliates And Subcontractors

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/contract-approval-city-officers.

This dataset includes the affiliates and subcontractors on efiled SFEC Form 126 Notification of Contract Approval and SFEC 126f4 Notification of Contract Approval Filings.

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:26.320833

Tables

Table 1

@usgov.city_of_san_francisco_sfec_form_126f4_notification_of__ada83bb9.table_1

2.43 MB
82,371 rows
38 columns

CREATE TABLE table_1 (
  "partytype" VARCHAR,
  "partylastname" VARCHAR,
  "partyfirstname" VARCHAR,
  "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,
  "contractoraddress" VARCHAR,
  "contractoremail" VARCHAR,
  "contractortelephone" VARCHAR,
  "contractthresholdaffirmation" VARCHAR,
  "contractdate" TIMESTAMP,
  "contractfilenumber" VARCHAR,
  "contractdescription" VARCHAR,
  "comments" VARCHAR,
  "contractapprovalcityelectiveofficer" VARCHAR,
  "contractapprovalboardstateagency" VARCHAR,
  "boardstateagency" VARCHAR,
  "contractapprovalboard" VARCHAR,
  "boardname" VARCHAR,
  "supplementalcheck" VARCHAR,
  "signername" VARCHAR,
  "datesigned" VARCHAR,
  "amendmentdescription" VARCHAR,
  "bidrfpnumber" VARCHAR,
  "descriptionofamount" VARCHAR,
  "departmentcontactdepartmentcode" VARCHAR
);