Contributions To Out-of-state Political Committees
State of Washington
@usgov.state_of_washington_contributions_to_out_of_state_poli_75efe11c
State of Washington
@usgov.state_of_washington_contributions_to_out_of_state_poli_75efe11c
CREATE TABLE table_1 (
"id" BIGINT,
"report_id" BIGINT,
"filer_name" VARCHAR,
"election_year" BIGINT,
"committee_id" BIGINT,
"committee_address" VARCHAR,
"committee_city" VARCHAR,
"committee_state" VARCHAR,
"committee_zip" VARCHAR,
"committee_email" VARCHAR,
"entity_id" BIGINT,
"contribution_date" VARCHAR,
"aggregate_total" DOUBLE,
"amount" DOUBLE,
"resident" BOOLEAN,
"name" VARCHAR,
"address" VARCHAR,
"city" VARCHAR,
"state" VARCHAR,
"postcode" VARCHAR,
"employer" VARCHAR,
"employer_address" VARCHAR,
"employer_city" VARCHAR,
"employer_state" VARCHAR,
"url" VARCHAR
);
Anyone who has the link will be able to view this.