Baselight

Campaign Finance - Local Non-Primarily Formed Comittees

City of San Francisco

@usgov.city_of_san_francisco_campaign_finance_local_non_prima_b109c65b

Loading...
Loading...

About this Dataset

Campaign Finance - Local Non-Primarily Formed Comittees

A. SUMMARY This dataset contains data from financial statements of campaign committees that file with the San Francisco Ethics Commission and (1) contribute to or (2) receive funds from a San Francisco committee which was Primarily Formed for a local election, or (3) filed a Late Reporting Period statement with the SFEC. Financial statements are included for a committee if they meet any of the three criteria for each election included in the search parameters and are not primarily formed for the election. The search period for financial statements begins two years before an election and runs through the next semi-annual filing deadline. The dataset currently filters by the elections of 2024-03-05 and 2024-11-05. B. HOW THE DATASET IS CREATED During an election period an automated script runs nightly to examine filings by Primarily Formed San Francisco committees. If a primarily formed committee reports accepting money from or giving money to a second committee, that second committee's ID number is added to a filter list. If a committee electronically files a late reporting period form with the San Francisco Ethics Commission, the committee's ID number is also included in the filter list. The filter list is used in a second step that looks for filings by committees that file with the San Francisco Ethics Commission or the California Secretary of State. This dataset shows the output of the second step for committees that file with the San Francisco Ethics Commission. The data comes from a nightly search of the Ethics Commission campaign database. A second dataset includes committees that file with the Secretary of State. C. UPDATE PROCESS This dataset is rewritten nightly and is based on data derived from campaign filings. The update script runs automatically on a timer during the 90 days before an election. Refer to the "Data Last Updated" date in the section "About This Dataset" on the landing page to see when the script last ran successfully. D. HOW TO USE THIS DATASET Transactions from all FPPC Form 460 schedules are presented together, refer to the Form Type to differentiate. Transactions from FPPC Form 461 and Form 465 filings are presented together, refer to the Form Type to differentiate. Transactions with a Form Type of D, E, F, G, H, F461P5, F465P3, F496, or F497P2 represent expenditures, or money spent by the committee. Transactions with Form Type A, B1, C, I, F496P3, and F497P1 represent receipts, or money taken in by the committee. Refer to the instructions for Forms 460, 496, and 497 for more details. Transactions on Form 460 Schedules D, F, G, and H are also reported on Schedule E. When doing summary statistics use care not to double count expenditures. Transactions from FPPC Form 496 and Form 497 filings are presented in this dataset. Transactions that were reported on these forms are also reported on the Form 460 at the next filing deadline. If a 460 filing deadline has passed and the committee has filed a campaign statement, transactions on 496/497 filings from the late reporting period should be disregarded. This dataset only shows transactions from the most recent filing version. Committee amendments overwrite filings which come before in sequence. Campaign Committees are required to file statements according to a schedule set out by the [C
Organization: City of San Francisco
Last updated: 2025-03-29T17:09:27.590917
Tags: campaign-finance, ethics

Tables

Table 1

@usgov.city_of_san_francisco_campaign_finance_local_non_prima_b109c65b.table_1
  • 1.17 MB
  • 24144 rows
  • 53 columns
Loading...

CREATE TABLE table_1 (
  "filing_id" DOUBLE,
  "form_type" VARCHAR,
  "transaction" VARCHAR,
  "filing_type" VARCHAR,
  "filer_id" VARCHAR,
  "committee_name" VARCHAR,
  "short_committee_name" VARCHAR,
  "filing_datetime" TIMESTAMP,
  "transaction_id" VARCHAR,
  "transaction_amount" DOUBLE,
  "transaction_date" TIMESTAMP,
  "transaction_name" VARCHAR,
  "transaction_first_name" VARCHAR,
  "transaction_last_name" VARCHAR,
  "transaction_description" VARCHAR,
  "entity_code" VARCHAR,
  "transaction_code" VARCHAR,
  "transaction_employer" VARCHAR,
  "transaction_occupation" VARCHAR,
  "transaction_city" VARCHAR,
  "transaction_state" VARCHAR,
  "transaction_zip" VARCHAR,
  "committee_id" VARCHAR,
  "expn_amount_incurred" DOUBLE,
  "expn_amount_paid" DOUBLE,
  "expn_beginning_balance" DOUBLE,
  "expn_ending_balance" DOUBLE,
  "loan_amount_1" DOUBLE,
  "loan_amount_2" DOUBLE,
  "loan_amount_3" DOUBLE,
  "loan_amount_4" DOUBLE,
  "loan_amount_5" DOUBLE,
  "loan_amount_6" DOUBLE,
  "loan_amount_7" DOUBLE,
  "loan_amount_8" DOUBLE,
  "loan_date_1" TIMESTAMP,
  "loan_date_2" TIMESTAMP,
  "district_number" DOUBLE,
  "ballot_jurisdiction" VARCHAR,
  "ballot_name" VARCHAR,
  "ballot_number" VARCHAR,
  "candidate_first_name" VARCHAR,
  "candidate_last_name" VARCHAR,
  "office_code" VARCHAR,
  "office_description" VARCHAR,
  "support_oppose_code" VARCHAR,
  "jurisdiction_code" VARCHAR,
  "jurisdiction_description" VARCHAR,
  "intermediary_first_name" VARCHAR,
  "intermediary_last_name" VARCHAR,
  "data_loaded_at" TIMESTAMP,
  "data_as_of" TIMESTAMP,
  "update_id" VARCHAR
);

Share link

Anyone who has the link will be able to view this.