Pledges Reporting History
State of Washington
@usgov.state_of_washington_pledges_reporting_history
State of Washington
@usgov.state_of_washington_pledges_reporting_history
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,
"receipt_date" TIMESTAMP,
"primary_general" VARCHAR,
"code" 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
);
Anyone who has the link will be able to view this.