About this Dataset

Lobbyist Data - Clients

Clients represented by registered lobbyists as reported in their Lobbyist Statements of Registration. Due to requirements for lobbyists to re-register and the importance of showing year for most lobbying-related data, the same client often will have multiple records. See http://www.cityofchicago.org/city/en/depts/ethics/provdrs/lobby.html for more information on the Board of Ethics' role in regulating and reporting on lobbying in Chicago.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:56.263069
Tags: ethics, lobbyists

Tables

Table 1

@usgov.city_of_chicago_lobbyist_data_clients.table_1

562.61 kB
20,492 rows
11 columns

CREATE TABLE table_1 (
  "year" BIGINT,
  "client_id" BIGINT,
  "name" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "country" VARCHAR,
  "created_date" TIMESTAMP,
  "active" VARCHAR
);