About this Dataset

SFEC Form 125 - Bundled Contributions Disclosure Report - Filings

Under San Francisco Campaign & Governmental Conduct Code Section 1.125, any committee controlled by a City elective officer or candidate for City elective office that receives contributions totaling $5,000 or more that have been bundled by a single individual shall file Form 125 at the same time that they are required to file semi-annual or pre-election campaign statements until the committee is terminated. Committees shall be required to provide this information following the receipt of the final contribution that makes the cumulative total $5,000 or more. For more information visit www.sfethics.org.

Each row on this table represents the contents of a Form 125 filed with the Ethics Commission. There are two sub-tables of information on "Officers" and "Contributions". The sub-tables are parsed into separate datasets: "SFEC Form 125 - Bundled Contributions Disclosure Report - Officers" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-125-Bundled-Contributions-Disclosure-Rep/x9je-gi3q and "SFEC Form 125 - Bundled Contributions Disclosure Report - Contributions" at https://data.sfgov.org/City-Management-and-Ethics/SFEC-Form-125-Bundled-Contributions-Disclosure-Rep/dzp4-4my5. Join this dataset with the sub-table using the DocuSignID.
Organization: City of San Francisco
Last updated: 2020-11-10T16:57:04.059542

Tables

Table 1

@usgov.city_of_san_francisco_sfec_form_125_bundled_contributi_8400f95f.table_1

22.98 kB
9 rows
24 columns

CREATE TABLE table_1 (
  "docusign_id" VARCHAR,
  "filing_url" VARCHAR,
  "filing_type" VARCHAR,
  "original_filing_date" TIMESTAMP,
  "amendment_description" VARCHAR,
  "statement_period_start_date" TIMESTAMP,
  "statement_period_end_date" TIMESTAMP,
  "bundler_name" VARCHAR,
  "bundler_street" VARCHAR,
  "bundler_zip_code" BIGINT,
  "bundler_city" VARCHAR,
  "bundler_state" VARCHAR,
  "bundler_occupation" VARCHAR,
  "bundler_employer" VARCHAR,
  "fppc_id" BIGINT,
  "committee_name" VARCHAR,
  "controlling_candidate_officer_name" VARCHAR,
  "member_board_commission" VARCHAR,
  "board_commission_name" VARCHAR,
  "date_signed" VARCHAR,
  "signer_name" VARCHAR,
  "officers_sub_table_query_url" VARCHAR,
  "additional_contributors_checkbox" VARCHAR,
  "contributors_sub_table_query_url" VARCHAR
);