Campaign Finance Summary

State of Washington

@usgov.state_of_washington_campaign_finance_summary

Table List

1 table(7.18 MB)

Table 1

@usgov.state_of_washington_campaign_finance_summary.table_1

7.18 MB
56276 rows
76 columns

id Id	filer_id Filer Id	filer_type Filer Type	election_year Election Year	filer_name Filer Name	committee_address Committee Address	committee_city Committee City	committee_state Committee State	committee_zip Committee Zip	committee_email Committee Email	committee_category Committee Category	political_committee_type Political Committee Type	expenditures_amount Expenditures Amount	url Url	committee_id Committee Id	person_id Person Id	fund_id Fund Id	pac_type Pac Type	continuing Continuing	updated_at Updated At
co-2009-35506	ABBOLE 064	OS	2009	Abbott Laboratories Employee Political Action Committee	100 Abbott Park Rd., D312 AP6D-2	Abbott Park	IL	60064-6028	notifyabbott@ddcpublicaffairs.com	Out-of-state political committee	Out-of-State	5525	https://www.pdc.wa.gov/political-disclosure-reporting-data/browse-search-data/reports?filer_name=ABBOTT%20LABORATORIES%20EMPLOYEES%20PAC&origin=C5%7CC5+AMENDED	35506	44221	22635	out-of-state	true	01/18/2024 10:27:08 AM
co-2010-35506	ABBOLE 064	OS	2010	Abbott Laboratories Employee Political Action Committee	100 Abbott Park Rd., D312 AP6D-2	Abbott Park	IL	60064-6028	notifyabbott@ddcpublicaffairs.com	Out-of-state political committee	Out-of-State	19775	https://www.pdc.wa.gov/political-disclosure-reporting-data/browse-search-data/reports?filer_name=ABBOTT%20LABORATORIES%20EMPLOYEES%20PAC&origin=C5%7CC5+AMENDED	35506	44221	22636	out-of-state	true	01/18/2024 10:27:08 AM
co-2011-35506	ABBOLE 064	OS	2011	Abbott Laboratories Employee Political Action Committee	100 Abbott Park Rd., D312 AP6D-2	Abbott Park	IL	60064-6028	notifyabbott@ddcpublicaffairs.com	Out-of-state political committee	Out-of-State	29400	https://www.pdc.wa.gov/political-disclosure-reporting-data/browse-search-data/reports?filer_name=ABBOTT%20LABORATORIES%20EMPLOYEES%20PAC&origin=C5%7CC5+AMENDED	35506	44221	22637	out-of-state	true	01/18/2024 10:27:08 AM
co-2012-35506	ABBOLE 064	OS	2012	Abbott Laboratories Employee Political Action Committee	100 Abbott Park Rd., D312 AP6D-2	Abbott Park	IL	60064-6028	notifyabbott@ddcpublicaffairs.com	Out-of-state political committee	Out-of-State	19725	https://www.pdc.wa.gov/political-disclosure-reporting-data/browse-search-data/reports?filer_name=ABBOTT%20LABORATORIES%20EMPLOYEES%20PAC&origin=C5%7CC5+AMENDED	35506	44221	22638	out-of-state	true	01/18/2024 10:27:08 AM
co-2014-35506	ABBOLE 064	OS	2014	Abbott Laboratories Employee Political Action Committee	100 Abbott Park Rd., D312 AP6D-2	Abbott Park	IL	60064-6028	notifyabbott@ddcpublicaffairs.com	Out-of-state political committee	Out-of-State	23300	https://www.pdc.wa.gov/political-disclosure-reporting-data/browse-search-data/reports?filer_name=ABBOTT%20LABORATORIES%20EMPLOYEES%20PAC&origin=C5%7CC5+AMENDED	35506	44221	22639	out-of-state	true	01/18/2024 10:27:08 AM
co-2015-35506	ABBOLE 064	OS	2015	Abbott Laboratories Employee Political Action Committee	100 Abbott Park Rd., D312 AP6D-2	Abbott Park	IL	60064-6028	notifyabbott@ddcpublicaffairs.com	Out-of-state political committee	Out-of-State	9350	https://www.pdc.wa.gov/political-disclosure-reporting-data/browse-search-data/reports?filer_name=ABBOTT%20LABORATORIES%20EMPLOYEES%20PAC&origin=C5%7CC5+AMENDED	35506	44221	22640	out-of-state	true	01/18/2024 10:27:08 AM
co-2016-35506	ABBOLE 064	OS	2016	Abbott Laboratories Employee Political Action Committee	100 Abbott Park Rd., D312 AP6D-2	Abbott Park	IL	60064-6028	notifyabbott@ddcpublicaffairs.com	Out-of-state political committee	Out-of-State	10000	https://www.pdc.wa.gov/political-disclosure-reporting-data/browse-search-data/reports?filer_name=ABBOTT%20LABORATORIES%20EMPLOYEES%20PAC&origin=C5%7CC5+AMENDED	35506	44221	22641	out-of-state	true	01/18/2024 10:27:08 AM
co-2017-35506	ABBOLE 064	OS	2017	Abbott Laboratories Employee Political Action Committee	100 Abbott Park Rd., D312 AP6D-2	Abbott Park	IL	60064-6028	notifyabbott@ddcpublicaffairs.com	Out-of-state political committee	Out-of-State	7700	https://www.pdc.wa.gov/political-disclosure-reporting-data/browse-search-data/reports?filer_name=ABBOTT%20LABORATORIES%20EMPLOYEES%20PAC&origin=C5%7CC5+AMENDED	35506	44221	22642	out-of-state	true	01/18/2024 10:27:08 AM
co-2015-35507	ABBVP 064	OS	2015	ABBVIE PAC	1 N WAUKEGAN RD	NORTH CHICAGO	IL	60064		Out-of-state political committee	Out-of-State	16000	https://www.pdc.wa.gov/political-disclosure-reporting-data/browse-search-data/reports?filer_name=ABBVIE%20PAC&origin=C5%7CC5+AMENDED	35507	44222	22643	out-of-state	true	11/07/2024 03:30:44 PM
co-2016-35507	ABBVP 064	OS	2016	ABBVIE PAC	1 N WAUKEGAN RD	NORTH CHICAGO	IL	60064		Out-of-state political committee	Out-of-State	24500	https://www.pdc.wa.gov/political-disclosure-reporting-data/browse-search-data/reports?filer_name=ABBVIE%20PAC&origin=C5%7CC5+AMENDED	35507	44222	22644	out-of-state	true	11/07/2024 03:30:44 PM


CREATE TABLE table_1 (
  "id" VARCHAR,
  "filer_id" VARCHAR,
  "filer_type" VARCHAR,
  "registered" VARCHAR,
  "declared" VARCHAR,
  "withdrew" VARCHAR,
  "discontinued" VARCHAR,
  "filing_type" VARCHAR,
  "receipt_date" TIMESTAMP,
  "election_year" BIGINT,
  "candidate_committee_status" VARCHAR,
  "filer_name" VARCHAR,
  "committee_acronym" VARCHAR,
  "committee_address" VARCHAR,
  "committee_city" VARCHAR,
  "committee_county" VARCHAR,
  "committee_state" VARCHAR,
  "committee_zip" VARCHAR,
  "committee_email" VARCHAR,
  "candidate_email" VARCHAR,
  "candidate_committee_phone" VARCHAR,
  "office" VARCHAR,
  "office_code" DOUBLE,
  "jurisdiction" VARCHAR,
  "jurisdiction_code" DOUBLE,
  "jurisdiction_county" VARCHAR,
  "jurisdiction_type" VARCHAR,
  "jurisdiction_voters" DOUBLE,
  "jurisdiction_reporting_code" VARCHAR,
  "jurisdiction_reporting_requirement" VARCHAR,
  "committee_category" VARCHAR,
  "political_committee_type" VARCHAR,
  "bonafide_committee" VARCHAR,
  "bonafide_type" VARCHAR,
  "position" VARCHAR,
  "party_code" VARCHAR,
  "party" VARCHAR,
  "election_date" TIMESTAMP,
  "reporting_option" VARCHAR,
  "active_candidate" VARCHAR,
  "on_primary_election_ballot" VARCHAR,
  "on_general_election_ballot" VARCHAR,
  "primary_election_status" VARCHAR,
  "general_election_status" VARCHAR,
  "election_status" VARCHAR,
  "exempt_nonexempt" VARCHAR,
  "ballot_committee" VARCHAR,
  "ballot_proposal_count" DOUBLE,
  "ballot_number" VARCHAR,
  "ballot_title" VARCHAR,
  "for_or_against" VARCHAR,
  "ballot_proposal_detail" VARCHAR,
  "other_pac" VARCHAR,
  "treasurer_address" VARCHAR,
  "treasurer_city" VARCHAR,
  "treasurer_state" VARCHAR,
  "treasurer_zip" VARCHAR,
  "treasurer_phone" VARCHAR,
  "contributions_amount" DOUBLE,
  "carryforward_amount" DOUBLE,
  "expenditures_amount" DOUBLE,
  "loans_amount" DOUBLE,
  "pledges_amount" DOUBLE,
  "debts_amount" DOUBLE,
  "independent_expenditures_for_amount" DOUBLE,
  "independent_expenditures_against_amount" DOUBLE,
  "url" VARCHAR,
  "committee_id" DOUBLE,
  "person_id" DOUBLE,
  "candidacy_id" DOUBLE,
  "fund_id" DOUBLE,
  "legislative_district" DOUBLE,
  "treasurer_name" VARCHAR,
  "pac_type" VARCHAR,
  "continuing" VARCHAR,
  "updated_at" VARCHAR
);