About this Dataset

Lobbyist Data - Employers

Employers of registered lobbyists as reported in the Lobbyist Statement of Registration. Due to requirements for lobbyists to re-register, the importance of showing year for most lobbying-related data, and some employers being reported by multiple lobbyists, the same employer 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:48.195515
Tags: ethics, lobbyists

Tables

Table 1

@usgov.city_of_chicago_lobbyist_data_employers.table_1

191.06 KB
6385 rows
13 columns


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