Readme
Updated 3 days ago
‧ Indexed 1 hour ago
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.
Columns
Name | Socrata field name | Column name in sgr mount | Data type | Description |
---|---|---|---|---|
TOTAL_EXPENSES | total_expenses | total_expenses | Number | Sum of the expense columns. |
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. |
CREATED_DATE | created_date | created_date | Calendar date | The date the 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. |
COMPENSATION_ID | compensation_id | compensation_id | Number | A unique identifier for the expenditures record. This ID can be used to link records in other datasets that contain an ID column with the same name, including the compensation dataset because of how small expenditures are reported. |
PUBLIC_EDUCATION_EXPENSE | public_education_expense | public_education_expense | Number | |
PERIOD_END | period_end | period_end | Calendar date | End of the reporting period for which this record was created. |
LOBBYIST_FIRST_NAME | lobbyist_first_name | lobbyist_first_name | Text | |
LOBBYIST_MIDDLE_INITIAL | lobbyist_middle_initial | lobbyist_middle_initial | Text | |
CLIENT_NAME | client_name | client_name | Text | |
LOBBYIST_LAST_NAME | lobbyist_last_name | lobbyist_last_name | Text | |
PERSONAL_SUSTENANCE_EXPENSE | personal_sustenance_expense | personal_sustenance_expense | Number | |
OTHER_EXPENSES | other_expenses | other_expenses | Number | |
OFFICE_EXPENSE | office_expense | office_expense | Number | |
PERIOD_START | period_start | period_start | Calendar date | Start of the reporting period for which this record was created. |
COMPENSATION_TO_OTHERS_EXPENSE | compensation_to_others_expense | compensation_to_others_expense | Number |
Upstream Metadata