About this Dataset

Lobbyist Employers Summary

This dataset is a list of all lobbyist employers and shows compensation/expenses totals for each year they employed lobbyists.

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 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:18.735309
Tags: employer-expense-reports, lobbying, lobbyist-employer

Tables

Table 1

@usgov.state_of_washington_lobbyist_employers_summary.table_1

903.59 KB
16048 rows
29 columns


CREATE TABLE table_1 (
  "id" VARCHAR,
  "year" BIGINT,
  "employer_name" VARCHAR,
  "employer_email" VARCHAR,
  "employer_phone" VARCHAR,
  "employer_address" VARCHAR,
  "employer_city" VARCHAR,
  "employer_state" VARCHAR,
  "employer_zip" VARCHAR,
  "employer_country" VARCHAR,
  "compensation" DOUBLE,
  "expenditures" DOUBLE,
  "agg_contrib" DOUBLE,
  "ballot_prop" DOUBLE,
  "entertain" DOUBLE,
  "vendor" DOUBLE,
  "expert_retain" DOUBLE,
  "inform_material" DOUBLE,
  "lobbying_comm" DOUBLE,
  "ie_in_support" DOUBLE,
  "itemized_exp" DOUBLE,
  "other_l3_exp" DOUBLE,
  "political" DOUBLE,
  "corr_compensation" DOUBLE,
  "corr_expend" DOUBLE,
  "total_exp" DOUBLE,
  "l3_nid" DOUBLE,
  "employer_nid" DOUBLE,
  "url" VARCHAR
);