Lobbyist Data - Lobbyist Registry - 2012 To Present (Deprecated October 2015) by US Government | Demographics and Population Studies

About this Dataset

Lobbyist Data - Lobbyist Registry - 2012 To Present (Deprecated October 2015)

OUTDATED. See similar current data at https://data.cityofchicago.org/d/tq3e-t5yq -- All lobbyist registration filings submitted to the Board of Ethics beginning with the 2012 reporting period. / All lobbyists must register with the City of Chicago Board of Ethics by filing a Statement of Registration within five business days of engaging in lobbying activity and annually thereafter by January 20th. Lobbyist registration information is submitted to the Board of Ethics in paper form and is available in its entirety in the Board's offices. The Board has, since 2000, compiled and posted static lists of all lobbyists and their clients online. Previous policy did not require the Board of Ethics to prioritize the reporting of all data available from paper filings. From this point forward, the Board of Ethics will electronically compile more data about lobbyists and their activities and automatically report this information online.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:38.326469
Tags: deprecated, ethics, lobbyists

Tables

Table 1

@usgov.city_of_chicago_lobbyist_lobbyist_registry_2012_to_pre_85b0f2e5.table_1

1.17 MB
28249 rows
56 columns


CREATE TABLE table_1 (
  "filing_year" BIGINT,
  "lobbyist_id" BIGINT,
  "lobbyist_salutation" VARCHAR,
  "lobbyist_last_name" VARCHAR,
  "lobbyist_first_name" VARCHAR,
  "lobbyist_middle_initial" VARCHAR,
  "lobbyist_address" VARCHAR,
  "lobbyist_address_2" VARCHAR,
  "lobbyist_city" VARCHAR,
  "lobbyist_state" VARCHAR,
  "lobbyist_zip" DOUBLE,
  "lobbyist_country" VARCHAR,
  "lobbyist_phone" VARCHAR,
  "lobbyist_fax" VARCHAR,
  "lobbyist_email" VARCHAR,
  "email" VARCHAR,
  "employer_name" VARCHAR,
  "employer_address" VARCHAR,
  "employer_address_2" VARCHAR,
  "employer_city" VARCHAR,
  "employer_state" VARCHAR,
  "employer_zip" DOUBLE,
  "employer_country" VARCHAR,
  "employer_phone" VARCHAR,
  "employer_fax" VARCHAR,
  "correspondent_salutation" VARCHAR,
  "correspondent_last_name" VARCHAR,
  "correspondent_first_name" VARCHAR,
  "correspondent_middle_initial" VARCHAR,
  "correspondent_address" VARCHAR,
  "correspondent_address_2" VARCHAR,
  "correspondent_city" VARCHAR,
  "correspondent_state" VARCHAR,
  "correspondent_zip" DOUBLE,
  "correspondent_country" VARCHAR,
  "correspondent_phone" VARCHAR,
  "correspondent_fax" VARCHAR,
  "correspondent_email" VARCHAR,
  "client_name" VARCHAR,
  "client_industry" VARCHAR,
  "client_other_industry" VARCHAR,
  "client_address" VARCHAR,
  "client_address_2" VARCHAR,
  "client_city" VARCHAR,
  "client_state" VARCHAR,
  "client_zip" DOUBLE,
  "client_phone" VARCHAR,
  "registration_version" BIGINT,
  "registration_filed_date" TIMESTAMP,
  "lobbyist_terminated_date" VARCHAR,
  "listed_department_name" VARCHAR,
  "other_lobbied_department_name" VARCHAR,
  "client_contract_date" TIMESTAMP,
  "incurred_expenses" VARCHAR,
  "received_compensation" VARCHAR,
  "written_agreement" VARCHAR
);