About this Dataset

Last Minute Contributions To Candidates And Political Committees

This data set contains a list of contributions reported within 7 days of the primary election or within 21 days of the general election. This dataset contains cash and in-kind contributions made to Washington State Candidates and Political Committees since the general election 2013.
Organization: State of Washington
Last updated: 2023-08-19T01:25:43.264683
Tags: campaign, elections, political-committee, political-finance

Tables

Table 1

@usgov.state_of_washington_last_minute_contributions_to_candi_bef67ec0.table_1

291.95 kB
844 rows
40 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "amended_by" DOUBLE,
  "amends" DOUBLE,
  "committee_id" DOUBLE,
  "candidacy_id" DOUBLE,
  "election_year" BIGINT,
  "primary_general" VARCHAR,
  "aggregate" DOUBLE,
  "filer_type" VARCHAR,
  "filer_name" VARCHAR,
  "filer_id" VARCHAR,
  "reported_by" VARCHAR,
  "amount" DOUBLE,
  "cash_or_in_kind" VARCHAR,
  "contribution_date" TIMESTAMP,
  "description" VARCHAR,
  "contributor_name" VARCHAR,
  "contributor_address" VARCHAR,
  "contributor_city" VARCHAR,
  "contributor_state" VARCHAR,
  "contributor_zip" VARCHAR,
  "recipient_name" VARCHAR,
  "recipient_address" VARCHAR,
  "recipient_city" VARCHAR,
  "recipient_state" VARCHAR,
  "recipient_zip" VARCHAR,
  "office" VARCHAR,
  "legislative_district" DOUBLE,
  "position" VARCHAR,
  "party" VARCHAR,
  "for_or_against" VARCHAR,
  "initiative_type" VARCHAR,
  "ballot_number" VARCHAR,
  "jurisdiction" VARCHAR,
  "jurisdiction_type" VARCHAR,
  "jurisdiction_county" VARCHAR,
  "pdc_report_url" VARCHAR,
  "user_data" VARCHAR,
  "receipt_date" VARCHAR,
  "conduit" VARCHAR
);