About this Dataset

Lobbyist - Employees

This dataset lists each employee a lobbyist reports. 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:33:05.693047
Tags: city-clerk, employees, ethics, lobbyist

Tables

Table 1

@usgov.city_of_austin_lobbyist_employees.table_1

33.85 kB
772 rows
20 columns

CREATE TABLE table_1 (
  "emp_id" VARCHAR,
  "report_id" VARCHAR,
  "registrant_id" VARCHAR,
  "emp_title" VARCHAR,
  "emp_first_name" VARCHAR,
  "emp_mi" VARCHAR,
  "emp_last_name" VARCHAR,
  "emp_suffix" VARCHAR,
  "emp_adr1" VARCHAR,
  "emp_adr2" VARCHAR,
  "emp_city" VARCHAR,
  "emp_state" VARCHAR,
  "emp_zip" VARCHAR,
  "emp_employer" VARCHAR,
  "emp_occupation" VARCHAR,
  "emp_position_desc" VARCHAR,
  "council_relative_yn" VARCHAR,
  "cm_first_name" VARCHAR,
  "cm_last_name" VARCHAR,
  "row_id" VARCHAR
);