cityofchicago/lobbyist-data-expenditures-small-eqdx-4qxd
Icon for Socrata external plugin
 
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

NameSocrata field nameColumn name in sgr mountData typeDescription
TOTAL_EXPENSEStotal_expensestotal_expensesNumberSum of the expense columns.
LOBBYIST_IDlobbyist_idlobbyist_idNumberA 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_DATEcreated_datecreated_dateCalendar dateThe date the record was created.
CLIENT_IDclient_idclient_idNumberA unique ID for the client that can be used to link to the same column name in other datasets.
COMPENSATION_IDcompensation_idcompensation_idNumberA 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_EXPENSEpublic_education_expensepublic_education_expenseNumber
PERIOD_ENDperiod_endperiod_endCalendar dateEnd of the reporting period for which this record was created.
LOBBYIST_FIRST_NAMElobbyist_first_namelobbyist_first_nameText
LOBBYIST_MIDDLE_INITIALlobbyist_middle_initiallobbyist_middle_initialText
CLIENT_NAMEclient_nameclient_nameText
LOBBYIST_LAST_NAMElobbyist_last_namelobbyist_last_nameText
PERSONAL_SUSTENANCE_EXPENSEpersonal_sustenance_expensepersonal_sustenance_expenseNumber
OTHER_EXPENSESother_expensesother_expensesNumber
OFFICE_EXPENSEoffice_expenseoffice_expenseNumber
PERIOD_STARTperiod_startperiod_startCalendar dateStart of the reporting period for which this record was created.
COMPENSATION_TO_OTHERS_EXPENSEcompensation_to_others_expensecompensation_to_others_expenseNumber
 
Preview
  • lobbyist_data_expenditures_small
     
Upstream Metadata