About this Dataset

Lobbyist Data - Lobbyist, Employer, Client Combinations

Each unique combination of a lobbyist, his/her employer, and a client of that employer. This dataset can be used to see relationships between these three entities. Each has a separate dataset with more detailed information about each lobbyist, employer, or client. 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:16.113389
Tags: ethics, lobbyists

Tables

Table 1

@usgov.city_of_chicago_lobbyist_lobbyist_employer_client_combinations.table_1

617.72 KB
31453 rows
11 columns


CREATE TABLE table_1 (
  "year" BIGINT,
  "lobbyist_id" BIGINT,
  "employer_id" BIGINT,
  "client_id" BIGINT,
  "lobbyist_salutation" VARCHAR,
  "lobbyist_first_name" VARCHAR,
  "lobbyist_middle_initial" VARCHAR,
  "lobbyist_last_name" VARCHAR,
  "lobbyist_suffix" VARCHAR,
  "employer_name" VARCHAR,
  "client_name" VARCHAR
);