Independent Campaign Expenditures And Electioneering Communications by US Government | Finance and Economics

About this Dataset

Independent Campaign Expenditures And Electioneering Communications

This dataset contains information about independent expenditures, independent expenditure ads, and electioneering communications reported by individuals, businesses, unions, organizations, or any other person as defined in RCW 42.17A for the last 17 years as reported to the PDC on form C6 Independent Expenditure and Electioneering Communications.

Only expenditures meeting the following criteria are reportable (see RCW 42.17A for details):
Independent Expenditures of $100 or more
Independent Expenditure Ads appearing within 21 days of an election costing $1,000 or more
Electioneering Communications appearing within 60 days of an election costing $1,000 or more

This dataset is a best-effort by the PDC to provide a complete set of records as described herewith and may contain incomplete or incorrect information. The PDC provides access to the original reports for the purpose of record verification.
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 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:19:54.357675
Tags: candidates, elections, political-committee, political-finance

Tables

Table 1

@usgov.state_of_washington_independent_campaign_expenditures__f79c632f.table_1

1.93 MB
38478 rows
62 columns


CREATE TABLE table_1 (
  "id" VARCHAR,
  "report_number" BIGINT,
  "origin" VARCHAR,
  "sponsor_entity_id" DOUBLE,
  "sponsor_id" BIGINT,
  "sponsor_name" VARCHAR,
  "sponsor_description" VARCHAR,
  "report_type" VARCHAR,
  "report_date" TIMESTAMP,
  "election_year" BIGINT,
  "sponsor_address" VARCHAR,
  "sponsor_city" VARCHAR,
  "sponsor_state" VARCHAR,
  "sponsor_zip" DOUBLE,
  "sponsor_email" VARCHAR,
  "sponsor_phone" VARCHAR,
  "total_unitemized" DOUBLE,
  "total_cycle" DOUBLE,
  "total_this_report" DOUBLE,
  "expenditure_amount" DOUBLE,
  "expenditure_description" VARCHAR,
  "date_expense_obligated" TIMESTAMP,
  "date_advertising_presented" TIMESTAMP,
  "vendor_name" VARCHAR,
  "vendor_address" VARCHAR,
  "vendor_city" VARCHAR,
  "vendor_state" VARCHAR,
  "vendor_zipcode" VARCHAR,
  "candidate_entity_id" DOUBLE,
  "candidate_candidacy_id" DOUBLE,
  "candidate_committee_id" DOUBLE,
  "candidate_filer_id" VARCHAR,
  "candidate_name" VARCHAR,
  "candidate_last_name" VARCHAR,
  "candidate_first_name" VARCHAR,
  "candidate_office" VARCHAR,
  "candidate_jurisdiction" VARCHAR,
  "candidate_party" VARCHAR,
  "candidate_office_type" VARCHAR,
  "ballot_name" VARCHAR,
  "ballot_number" VARCHAR,
  "ballot_type" VARCHAR,
  "portion_of_amount" DOUBLE,
  "for_or_against" VARCHAR,
  "funders_name" VARCHAR,
  "funders_first_name" VARCHAR,
  "funders_middle_initial" VARCHAR,
  "date_received" TIMESTAMP,
  "amount" DOUBLE,
  "funders_address" VARCHAR,
  "funders_city" VARCHAR,
  "funders_state" VARCHAR,
  "funders_zipcode" DOUBLE,
  "funders_occupation" VARCHAR,
  "funders_employer" VARCHAR,
  "funders_employer_city" VARCHAR,
  "funders_employer_state" VARCHAR,
  "url" VARCHAR,
  "sponsor_location" VARCHAR,
  "vendor_location" VARCHAR,
  "funders_location" VARCHAR,
  "filer_id" VARCHAR
);