Every expense made during the reporting period for the benefit of an official or employee of the City. These are different from other expenses or gifts -- other datasets in this series. These expenses are typically those that fall under the “reasonable hosting” provision of the City of Chicago ethics rules. 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.
This dataset has the following 16 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
EXPENDITUREOTHER_ID | expenditureother_id | number | A unique identifier for the expenditure record. | 1322105495 3785416324 93956817 3380174068 3055432649 view top 100 |
PERIOD_START | period_start | calendar_date | Start of the reporting period for which this record was created. | 2023-07-01T00:00:00.000 2024-04-01T00:00:00.000 2023-04-01T00:00:00.000 2021-07-01T00:00:00.000 2022-01-01T00:00:00.000 view top 100 |
PERIOD_END | period_end | calendar_date | End of the reporting period for which this record was created. | 2023-09-30T00:00:00.000 2024-06-30T00:00:00.000 2023-06-30T00:00:00.000 2021-09-30T00:00:00.000 2022-03-31T00:00:00.000 view top 100 |
PURPOSE | purpose | text | The goods or services purchased | IEC ANNUAL DINNER LUNCH FOOD AND BEVERAGE COMPLIMENTARY INVITATION TO A CIVIC EVENT AT WHICH LOBBYING TOOK PLACE FOOD/BEVERAGE PROVIDED AT REASONABLE HOSTING EVENT view top 100 |
RECIPIENT_FIRST_NAME | recipient_first_name | text | ANGELA MICHELLE DANIEL DAVID JULIA view top 100 | |
RECIPIENT_LAST_NAME | recipient_last_name | text | HARRIS TOVAR VASQUEZ MITCHELL RAMIREZ view top 100 | |
RECIPIENT_TITLE | recipient_title | text | ALDERMAN ALDER ALDERPERSON DEPUTY COMMISSIONER CHIEF SUSTAINABILITY OFFICER view top 100 | |
AMOUNT | amount | number | The amount of the expense | 162 85 50 33 40 view top 100 |
DEPARTMENT | department | text | CITY COUNCIL / ALDERMEN CITY COUNCIL/ALDERPERSONS MAYORS OFFICE HOUSING AND ECONOMIC DEVELOPMENT FAMILY AND SUPPORT SERVICES view top 100 | |
LOBBYIST_ID | lobbyist_id | number | A unique identifier for the lobbyist record. This ID can be used to link records in other datasets that contain an ID column with the same name. | 24223 18782 24779 25500 17901 view top 100 |
LOBBYIST_FIRSTNAME | lobbyist_firstname | text | ALLISON JENNIFER IYANA AMY MATTHEW view top 100 | |
LOBBYIST_MIDDLE_INITIAL | lobbyist_middle_initial | text | J J. C E S view top 100 | |
LOBBYIST_LASTNAME | lobbyist_lastname | text | CLEMENTS SIMBA WALLING JOHNSON MASTERS view top 100 | |
CLIENT_ID | client_id | number | A unique ID for the client on whose behalf the lobbying related to this expenditure was done. This ID can be used to link to the same column name in other datasets. | 194495729 4200670289 2877129182 1921653433 1617924557 view top 100 |
CLIENT_NAME | client_name | text | The name of the client on whose behalf the lobbying related to this expenditure was done. | ILLINOIS ENVIRONMENTAL COUNCIL BUILDING OWNERS AND MANAGERS ASSOCIATION OF CHICAGO (BOMA/CHICAGO) APPLE INC. ILLINOIS HOUSING COUNCIL IRONWORKERS LOCAL 63 view top 100 |
CREATED_DATE | created_date | calendar_date | The date the record was created. | 2023-10-19T00:00:00.000 2023-10-20T00:00:00.000 2022-04-01T00:00:00.000 2024-07-19T00:00:00.000 2023-07-20T00:00:00.000 view top 100 |