Public Agency Lobbying Totals by US Government | Demographics and Population Studies

About this Dataset

Public Agency Lobbying Totals

This dataset contains the quarterly totals reported by public agencies on Form L5. The data are presents in a year format (a row represents a year and a year can contain up to 4 quarterly reports). The columns are represented as Q1, Q2, Q3, and Q4 for the four quarters and the year_total column is the sum of the four quarters.

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:21:05.166973
Tags: l5, lobbying, public-agency

Tables

Table 1

@usgov.state_of_washington_public_agency_lobbying_totals.table_1

230.28 KB
2450 rows
24 columns


CREATE TABLE table_1 (
  "id" VARCHAR,
  "filer_id" VARCHAR,
  "name" VARCHAR,
  "address" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" VARCHAR,
  "contact" VARCHAR,
  "email_address" VARCHAR,
  "phone" VARCHAR,
  "year" BIGINT,
  "q1_report_num" VARCHAR,
  "q1" DOUBLE,
  "q2_report_num" VARCHAR,
  "q2" DOUBLE,
  "q3_report_num" VARCHAR,
  "q3" DOUBLE,
  "q4_report_num" VARCHAR,
  "q4" DOUBLE,
  "year_total" DOUBLE,
  "q1_url" VARCHAR,
  "q2_url" VARCHAR,
  "q3_url" VARCHAR,
  "q4_url" VARCHAR
);