Readme
Updated 3 days ago
‧ Indexed 4 hours ago
Lobbyist Data - Compensation
Lobbying-related compensation received by registered lobbyists as reported in their quarterly reports.
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.
Columns
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
LOBBYIST_ID | 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. |
COMPENSATION_ID | compensation_id | compensation_id | Number | A unique ID for this record. |
PERIOD_START | period_start | period_start | Calendar date | Start of the reporting period for which this record was created. |
PERIOD_END | period_end | period_end | Calendar date | End of the reporting period for which this record was created |
CLIENT_ID | client_id | client_id | Number | A unique ID for the client that can be used to link to the same column name in other datasets. |
LOBBYIST_LAST_NAME | lobbyist_last_name | lobbyist_last_name | Text | |
LOBBYIST_MIDDLE_INITIAL | lobbyist_middle_initial | lobbyist_middle_initial | Text | |
CREATED_DATE | created_date | created_date | Calendar date | The date the record was created. |
LOBBYIST_FIRST_NAME | lobbyist_first_name | lobbyist_first_name | Text | |
CLIENT_NAME | client_name | client_name | Text | |
COMPENSATION_AMOUNT | compensation_amount | compensation_amount | Number |
Upstream Metadata