Expenditures By Candidates And Political Committees
State of Washington
@usgov.state_of_washington_expenditures_by_candidates_and_pol_13963846
State of Washington
@usgov.state_of_washington_expenditures_by_candidates_and_pol_13963846
CREATE TABLE table_1 (
"id" BIGINT,
"report_number" BIGINT,
"origin" VARCHAR,
"committee_id" BIGINT,
"filer_id" VARCHAR,
"type" VARCHAR,
"filer_name" VARCHAR,
"office" VARCHAR,
"legislative_district" DOUBLE,
"position" VARCHAR,
"party" VARCHAR,
"ballot_number" VARCHAR,
"for_or_against" VARCHAR,
"jurisdiction" VARCHAR,
"jurisdiction_county" VARCHAR,
"jurisdiction_type" VARCHAR,
"election_year" BIGINT,
"amount" DOUBLE,
"itemized_or_non_itemized" VARCHAR,
"expenditure_date" TIMESTAMP,
"description" VARCHAR,
"code" VARCHAR,
"recipient_name" VARCHAR,
"recipient_address" VARCHAR,
"recipient_city" VARCHAR,
"recipient_state" VARCHAR,
"recipient_zip" VARCHAR,
"url" VARCHAR,
"recipient_location" VARCHAR,
"payee" VARCHAR,
"creditor" VARCHAR
);
Anyone who has the link will be able to view this.