About this Dataset

Lobbyist Compensation And Expenses By Source

This dataset contains compensation and expense summary records from the monthly reports of lobbying activity. One record is included for each client that paid compensation or incurred expenses during the filing period. If the lobbyist firm themselves incurred any expenses not reimbursed by a client, a record is included summarizing the lobbyist firm's expenses. If a lobbyist reported no compensation or expenses on the report, no records will be in this dataset. Records are included for a period of ten years, beginning in January, 2016. The date is determined as the filing period of the report, not the date received. Records are included for the full year so for example, all 2017 records will be included until the entire year 2017 falls outside the 10 year time span.

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:10.163034
Tags: campaign, contributions, disclosure, elections, political-committee, political-finance

Tables

Table 1

@usgov.state_of_washington_lobbyist_compensation_and_expenses_6db35c98.table_1

10.26 MB
286214 rows
34 columns


CREATE TABLE table_1 (
  "id" VARCHAR,
  "report_number" BIGINT,
  "origin" VARCHAR,
  "filer_id" BIGINT,
  "filer_name" VARCHAR,
  "type" VARCHAR,
  "funding_source_id" BIGINT,
  "funding_source_name" VARCHAR,
  "filing_period" VARCHAR,
  "first_filed_at" VARCHAR,
  "receipt_date" TIMESTAMP,
  "employer_id" DOUBLE,
  "employer_name" VARCHAR,
  "compensation" DOUBLE,
  "sub_lobbyist_compensation" DOUBLE,
  "net_compensation" DOUBLE,
  "personal_expenses" DOUBLE,
  "entertainment" DOUBLE,
  "contributions" DOUBLE,
  "advertising" DOUBLE,
  "political_ads" DOUBLE,
  "independent_expenditures_candidate" DOUBLE,
  "independent_expenditures_ballot" DOUBLE,
  "other" DOUBLE,
  "direct_expenses" DOUBLE,
  "indirect_expenses" DOUBLE,
  "contributions_total" DOUBLE,
  "total_expenses" DOUBLE,
  "net_total" DOUBLE,
  "employment_registration_id" DOUBLE,
  "employment_type" VARCHAR,
  "contractor_id" DOUBLE,
  "contractor_name" VARCHAR,
  "url" VARCHAR
);