cityofchicago/lobbyist-data-compensation-dw2f-w78u
Icon for Socrata external plugin
 
Preview
  • lobbyist_data_compensation
     
 
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

NameSocrata field nameColumn name in sgr mountData typeDescription
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.
COMPENSATION_IDcompensation_idcompensation_idNumberA unique ID for this record.
PERIOD_STARTperiod_startperiod_startCalendar dateStart of the reporting period for which this record was created.
PERIOD_ENDperiod_endperiod_endCalendar dateEnd of the reporting period for which this 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.
LOBBYIST_LAST_NAMElobbyist_last_namelobbyist_last_nameText
LOBBYIST_MIDDLE_INITIALlobbyist_middle_initiallobbyist_middle_initialText
CREATED_DATEcreated_datecreated_dateCalendar dateThe date the record was created.
LOBBYIST_FIRST_NAMElobbyist_first_namelobbyist_first_nameText
CLIENT_NAMEclient_nameclient_nameText
COMPENSATION_AMOUNTcompensation_amountcompensation_amountNumber
Upstream Metadata