About this Dataset

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://services.austintexas.gov/edims/document.cfm?id=293053
Organization: City of Austin
Last updated: 2020-11-12T13:22:58.210150
Tags: city-clerk, ethics, financial, lobbyist

Tables

Table 1

@usgov.city_of_austin_lobbyist_clients.table_1

1.95 MB
106,651 rows
19 columns

CREATE TABLE table_1 (
  "client_id" VARCHAR,
  "report_id" VARCHAR,
  "registrant_id" VARCHAR,
  "cliententity_cd" VARCHAR,
  "client_title" VARCHAR,
  "client_first_name" VARCHAR,
  "client_mi" VARCHAR,
  "client_last_name" VARCHAR,
  "client_suffix" VARCHAR,
  "client_adr1" VARCHAR,
  "client_adr2" VARCHAR,
  "client_city" VARCHAR,
  "client_state" VARCHAR,
  "client_zip" VARCHAR,
  "business_desc" VARCHAR,
  "comp_category" VARCHAR,
  "comp_exact_amount" DOUBLE,
  "comp_comment" VARCHAR,
  "row_id" VARCHAR
);