About this Dataset

Financial Affairs Disclosures

This dataset contains a list of all financial affairs disclosures (formerly F1) for the last 17 years including attached schedules. It only includes the most recent submission for a given filing period, not any prior versions for the same reporting period.
Organization: State of Washington
Last updated: 2020-11-10T17:20:30.588591
Tags: campaign, contributions, disclosure, elections, political-committee, political-finance, public-disclosure

Tables

Table 1

@usgov.state_of_washington_financial_affairs_disclosures.table_1

68.26 MB
129,001 rows
18 columns

CREATE TABLE table_1 (
  "id" BIGINT,
  "submission_id" DOUBLE,
  "report_number" DOUBLE,
  "filer_id" VARCHAR,
  "person_id" BIGINT,
  "name" VARCHAR,
  "receipt_date" VARCHAR,
  "period_start" VARCHAR,
  "period_end" VARCHAR,
  "json" VARCHAR,
  "url" VARCHAR,
  "certification_name" VARCHAR,
  "certification_email" VARCHAR,
  "certification_phone" VARCHAR,
  "candidacies" VARCHAR,
  "offices" VARCHAR,
  "certification" VARCHAR,
  "history" VARCHAR
);