cityofchicago/lobbyist-data-expenditures-large-xika-473c
Icon for Socrata external plugin
 
Readme
Updated 15 days ago
Indexed 5 hours ago

Lobbyist Data - Expenditures - Large

Expenditures of $250 or more. smaller expenditures are summarized in https://data.cityofchicago.org/d/eqdx-4qxd. 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
PURPOSEpurposepurposeTextThe type of expenditure.
PERIOD_STARTperiod_startperiod_startCalendar dateStart of the reporting period for which this record was created.
CREATED_DATEcreated_datecreated_dateCalendar dateThe date the record was created.
LOBBYIST_FIRST_NAMElobbyist_first_namelobbyist_first_nameText
EXPENDITURE_DATEexpenditure_dateexpenditure_dateCalendar date
EXPENDITURE_IDexpenditure_idexpenditure_idNumberA unique identifier for the expenditure record.
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.
AMOUNTamountamountNumber
CLIENT_NAMEclient_nameclient_nameTextThe name of the client on whose behalf the lobbying related to this expenditure was done.
PERIOD_ENDperiod_endperiod_endCalendar dateEnd of the reporting period for which this record was created.
LOBBYIST_MIDDLE_INITIALlobbyist_middle_initiallobbyist_middle_initialText
RECIPIENTrecipientrecipientTextThe party to whom the expense was paid.
ACTIONactionactionTextThe purpose of the lobbying for which this expenditure was made.
CLIENT_IDclient_idclient_idNumberA 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.
LOBBYIST_LAST_NAMElobbyist_last_namelobbyist_last_nameText
 
Preview
  • lobbyist_data_expenditures_large
     
Upstream Metadata