Name: Lobbyist Data - Gifts
Creator: US Government
License: https://www.usa.gov/government-works

About this Dataset

Lobbyist Data - Gifts

Every gift made by a registered lobbyist during the reporting period to an official or employee of the City.
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:25.255828
Tags: ethics, lobbyists

Tables

Table 1

@usgov.city_of_chicago_lobbyist_data_gifts.table_1

36.81 kB
650 rows
13 columns

CREATE TABLE table_1 (
  "gift_id" BIGINT,
  "period_start" TIMESTAMP,
  "period_end" TIMESTAMP,
  "gift" VARCHAR,
  "recipient_first_name" VARCHAR,
  "recipient_last_name" VARCHAR,
  "recipient_title" VARCHAR,
  "value" DOUBLE,
  "department" VARCHAR,
  "lobbyist_id" BIGINT,
  "lobbyist_firstname" VARCHAR,
  "lobbyist_lastname" VARCHAR,
  "created_date" TIMESTAMP
);