Campaign Finance - Local Non-Primarily Formed Comittees
City of San Francisco
@usgov.city_of_san_francisco_campaign_finance_local_non_prima_b109c65b
City of San Francisco
@usgov.city_of_san_francisco_campaign_finance_local_non_prima_b109c65b
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
);
Anyone who has the link will be able to view this.