Lobbyist Summary by US Government | Demographics and Population Studies

About this Dataset

Lobbyist Summary

This dataset contains information about lobbyists and the totals from all their L2s for a given year.

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

Tables

Table 1

@usgov.state_of_washington_lobbyist_summary.table_1

600.72 KB
9891 rows
34 columns


CREATE TABLE table_1 (
  "id" VARCHAR,
  "year" DOUBLE,
  "filer_id" BIGINT,
  "lobbyist_name" VARCHAR,
  "lobbyist_email" VARCHAR,
  "lobbyist_phone" VARCHAR,
  "firm_address" VARCHAR,
  "firm_city" VARCHAR,
  "firm_state" VARCHAR,
  "firm_zip" VARCHAR,
  "firm_country" VARCHAR,
  "temp_phone" VARCHAR,
  "temp_address" VARCHAR,
  "temp_city" VARCHAR,
  "temp_state" VARCHAR,
  "temp_zip" VARCHAR,
  "compensation" DOUBLE,
  "sub_lobbyist_compensation" DOUBLE,
  "net_compensation" DOUBLE,
  "personal_expenses" DOUBLE,
  "entertainment" DOUBLE,
  "contributions" DOUBLE,
  "pac_contributions" DOUBLE,
  "advertising" DOUBLE,
  "political_ads" DOUBLE,
  "independent_expenditures_candidate" DOUBLE,
  "independent_expenditures_ballot" DOUBLE,
  "other" DOUBLE,
  "direct_lobbying_expenses" DOUBLE,
  "indirect_lobbying_expenses" DOUBLE,
  "total_expenses" DOUBLE,
  "net_total" DOUBLE,
  "use_categories" VARCHAR,
  "periods" VARCHAR
);