Name: L7 - Employment Of Legislators And State Officials
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

L7 - Employment Of Legislators And State Officials

Discloses a lobbyist's or lobbyist employer's employment of a member of the legislature, an employee of the legislature, a member of a state board or commission, or a full-time state employee, if the employee remains partially employed by the state. RCW 42.17A.645*
Organization: State of Washington
Last updated: 2023-10-29T20:31:17.909691
Tags: report

Tables

Table 1

@usgov.state_of_washington_draft_pre_l7.table_1

26.42 KB
14 rows
19 columns


CREATE TABLE table_1 (
  "id" BIGINT,
  "report_number" BIGINT,
  "amended_by" DOUBLE,
  "amends" DOUBLE,
  "receipt_date" VARCHAR,
  "firm_id" DOUBLE,
  "client_id" DOUBLE,
  "filer_type" VARCHAR,
  "filer_name" VARCHAR,
  "filer_address" VARCHAR,
  "filer_city" VARCHAR,
  "filer_state" VARCHAR,
  "filer_postcode" VARCHAR,
  "employee_name" VARCHAR,
  "filer_employment_compensation" VARCHAR,
  "filer_employment_description" VARCHAR,
  "public_employment_description" VARCHAR,
  "user_data" VARCHAR,
  "pdc_report_url" VARCHAR
);