About this Dataset

Loans To Candidates And Political Committees

This data set contains candidate and political committee loan information for the last 17 years.

Data includes loans received, loan repayments, interest payments, and loans forgiven.

Descriptions attached to this dataset do not constitute legal definitions; please consult RCW 42.17A and WAC Title 390 for legal definitions and additional information regarding political finance disclosure requirements.

CONDITION OF RELEASE: This publication and or referenced documents constitutes a list of individuals prepared by the Washington State Public Disclosure Commission and may not be used for commercial purposes. This list is provided on the condition and with the understanding that the persons receiving it agree to this statutorily imposed limitation on its use. See RCW 42.56.070(9) and AGO 1975 No. 15.
Organization: State of Washington
Last updated: 2020-11-10T17:20:24.785481
Tags: campaign, contributions, disclosure, elections, political-committee, political-finance

Tables

Table 1

@usgov.state_of_washington_loans_to_candidates_and_political__82faa245.table_1

1.1 MB
22952 rows
36 columns


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,
  "jurisdiction" VARCHAR,
  "jurisdiction_county" VARCHAR,
  "jurisdiction_type" VARCHAR,
  "election_year" BIGINT,
  "cash_or_in_kind" VARCHAR,
  "receipt_date" TIMESTAMP,
  "repayment_schedule" VARCHAR,
  "loan_due_date" TIMESTAMP,
  "lender_or_endorser" VARCHAR,
  "transaction_type" VARCHAR,
  "amount" DOUBLE,
  "endorser_liable_amount" DOUBLE,
  "primary_general" VARCHAR,
  "lenders_name" VARCHAR,
  "lenders_address" VARCHAR,
  "lenders_city" VARCHAR,
  "lenders_state" VARCHAR,
  "lenders_zip" VARCHAR,
  "lenders_occupation" VARCHAR,
  "lenders_employer" VARCHAR,
  "employers_city" VARCHAR,
  "employers_state" VARCHAR,
  "url" VARCHAR,
  "carry_forward_loan" VARCHAR,
  "description" VARCHAR
);