About this Dataset

Lobbyist Data - Expenditures - Small

Expenditures under $250 per transaction, summarized per three-month reporting period. Larger expenditures are itemized in https://data.cityofchicago.org/d/xika-473c. 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:51.161805
Tags: ethics, lobbyists

Tables

Table 1

@usgov.city_of_chicago_lobbyist_data_expenditures_small.table_1

104.25 kB
2,470 rows
16 columns

CREATE TABLE table_1 (
  "compensation_id" BIGINT,
  "period_start" TIMESTAMP,
  "period_end" TIMESTAMP,
  "lobbyist_id" BIGINT,
  "lobbyist_first_name" VARCHAR,
  "lobbyist_middle_initial" VARCHAR,
  "lobbyist_last_name" VARCHAR,
  "compensation_to_others_expense" DOUBLE,
  "office_expense" DOUBLE,
  "personal_sustenance_expense" DOUBLE,
  "public_education_expense" DOUBLE,
  "other_expenses" DOUBLE,
  "total_expenses" DOUBLE,
  "client_id" BIGINT,
  "client_name" VARCHAR,
  "created_date" TIMESTAMP
);