About this Dataset

Lobbyist Data - Lobbyists

Lobbyists registered with the Chicago Board of Ethics since 2012. Due to requirements for lobbyists to re-register and the importance of showing year for most lobbying-related data, the same lobbyist 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:55:27.233652
Tags: ethics, lobbyists

Tables

Table 1

@usgov.city_of_chicago_lobbyist_data_lobbyists.table_1

447.58 KB
11054 rows
19 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "lobbyist_id" BIGINT,
  "salutation" VARCHAR,
  "first_name" VARCHAR,
  "middle_initial" VARCHAR,
  "last_name" VARCHAR,
  "suffix" VARCHAR,
  "address_1" VARCHAR,
  "address_2" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip" VARCHAR,
  "country" VARCHAR,
  "email" VARCHAR,
  "phone" VARCHAR,
  "fax" VARCHAR,
  "employer_id" BIGINT,
  "employer_name" VARCHAR,
  "created_date" TIMESTAMP
);