Contributions To Candidates And Political Committees
State of Washington
@usgov.state_of_washington_contributions_to_candidates_and_po_955196cb
State of Washington
@usgov.state_of_washington_contributions_to_candidates_and_po_955196cb
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,
"cash_or_in_kind" VARCHAR,
"receipt_date" VARCHAR,
"description" VARCHAR,
"memo" VARCHAR,
"primary_general" VARCHAR,
"code" VARCHAR,
"contributor_category" VARCHAR,
"contributor_name" VARCHAR,
"contributor_address" VARCHAR,
"contributor_city" VARCHAR,
"contributor_state" VARCHAR,
"contributor_zip" VARCHAR,
"contributor_occupation" VARCHAR,
"contributor_employer_name" VARCHAR,
"contributor_employer_city" VARCHAR,
"contributor_employer_state" VARCHAR,
"url" VARCHAR,
"contributor_location" VARCHAR
);
Anyone who has the link will be able to view this.