SFEC Form 124 - Contributions Made By Business Entities - Filings by US Government | Demographics and Population Studies

About this Dataset

SFEC Form 124 - Contributions Made By Business Entities - Filings

Under San Francisco Campaign & Governmental Conduct Code Section 1.124, any committee required to file campaign statements with the Ethics Commission must disclose certain additional information no later than the deadline for filing semi-annual or pre-election statements any contribution(s) that, in the aggregate, total $10,000 or more from a single business entity in a single election cycle. For the purposes of this disclosure, the committee must disclose one of the business entity’s principal officers, including but not limited to the Chair of the Board of Directors, President, Vice President, CEO, CFO, COO, Executive Director, Deputy Director, or equivalent positions. The committee must also disclose whether, within the 24 months prior to the date the entity’s contributions to the committee totaled $10,000 or more, the business entity received funds through a contract or grant from any City agency for a project within the jurisdiction of the City and County of San Francisco. If such contract or grant exists, the committee must disclose the name of the agency and the value of the contract or grant. For more information visit www.sfethics.org.

Each row on this table represents the contents of a Form 124 filed with the Ethics Commission. There is one sub-tables of information on Form 124: Contracts and Grants. The sub-table is available in a separate dataset: "SFEC Form 124 - Contributions Made by Business Entities - Contracts and Grants" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-124-Contributions-Made-by-Business-Entit/ssx6-3d9r. Join this dataset with the sub-table using the DocuSignID.
Organization: City of San Francisco
Last updated: 2020-11-10T16:56:56.145696

Tables

Table 1

@usgov.city_of_san_francisco_sfec_form_124_contributions_made_9c751658.table_1

83.9 KB
317 rows
23 columns


CREATE TABLE table_1 (
  "docusign_id" VARCHAR,
  "filing_type" VARCHAR,
  "filing_url" VARCHAR,
  "original_filing_date" TIMESTAMP,
  "amendment_description" VARCHAR,
  "date_signed" VARCHAR,
  "signer_name" VARCHAR,
  "contracts_and_grants_subtable_query_url" VARCHAR,
  "committee_name" VARCHAR,
  "fppc_id" VARCHAR,
  "designated_contact_person" VARCHAR,
  "contact_person_phone" VARCHAR,
  "contact_person_email" VARCHAR,
  "business_entity_name" VARCHAR,
  "principal_officer_name" VARCHAR,
  "principal_officer_title" VARCHAR,
  "business_entity_street_address" VARCHAR,
  "business_entity_city" VARCHAR,
  "business_entity_state" VARCHAR,
  "business_entity_zip_code" BIGINT,
  "total_contributions" DOUBLE,
  "date_threshold_reached" TIMESTAMP,
  "supplemental_check" VARCHAR
);