austintexas-gov/lobbyist-report-types-4zpf-72n3
Icon for Socrata external plugin
 
Readme
Updated 12 hours ago
Indexed 2 hours ago

Lobbyist - Report Types

A look up table of each lobbyist report types. 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
ACTIVEactiveactiveText
UPDATE_CORRECTIONupdate_correctionupdate_correctionText
geom (city)geom_citygeom_cityText
geom (state)geom_stategeom_stateText
geom (address)geom_addressgeom_addressText
Zip Codes:@computed_region_a3it_2a2z:@computed_region_a3it_2a2zNumber
Single Member Council Districts:@computed_region_8spj_utxs:@computed_region_8spj_utxsNumber
geom (zip)geom_zipgeom_zipText
geomgeomgeomPoint
TERMINATIONterminationterminationText
QUARTERLY_ACTIVITY_REPORTquarterly_activity_reportquarterly_activity_reportText
NEWnewnewText
REPORT_TYPE_2report_type_2report_type_2Text
REPORT_TYPE_IDreport_type_idreport_type_idText
DISPLAYNAMEdisplaynamedisplaynameText
RENEWALrenewalrenewalText
REPORT_TYPE_1report_type_1report_type_1Text
REPORT_TYPEreport_typereport_typeText
 
Preview
  • lobbyist_report_types
     
Upstream Metadata