austintexas-gov/lobbyist-clients-7ena-g23u
Icon for Socrata external plugin
 
Preview
  • lobbyist_clients
     
 
Readme
Updated 8 hours ago
Indexed 16 minutes ago

Lobbyist - Clients

This table lists the clients reported by lobbyists. You can recreate the City Clerk's lobbyist database by downloading all lobbyist datasets on the data portal and view the complete data model of the lobbyist database here: https://www.austintexas.gov/edims/document.cfm?id=293053

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
CLIENT_IDclient_idclient_idText
REPORT_IDreport_idreport_idText
REGISTRANT_IDregistrant_idregistrant_idText
CLIENTENTITY_CDcliententity_cdcliententity_cdText
CLIENT_TITLEclient_titleclient_titleText
CLIENT_FIRST_NAMEclient_first_nameclient_first_nameText
CLIENT_MIclient_miclient_miText
CLIENT_LAST_NAMEclient_last_nameclient_last_nameText
CLIENT_SUFFIXclient_suffixclient_suffixText
CLIENT_ADR1client_adr1client_adr1Text
CLIENT_ADR2client_adr2client_adr2Text
CLIENT_CITYclient_cityclient_cityText
CLIENT_STATEclient_stateclient_stateText
CLIENT_ZIPclient_zipclient_zipText
BUSINESS_DESCbusiness_descbusiness_descText
COMP_CATEGORYcomp_categorycomp_categoryNumber
COMP_EXACT_AMOUNTcomp_exact_amountcomp_exact_amountNumber
COMP_COMMENTcomp_commentcomp_commentText
Row_IDrow_idrow_idTexta unique identifier to allow the row to be updated in Socrata - this is not a data type intrinsic to the lobbyist database
Upstream Metadata