About this Dataset

Lobbyist - Reports

This dataset lists each report submitted by a lobbyist. 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:24:23.982820
Tags: city-clerk, ethics, financial, lobbyist

Tables

Table 1

@usgov.city_of_austin_lobbyist_reports.table_1

198.74 kB
5,349 rows
31 columns

CREATE TABLE table_1 (
  "report_id" VARCHAR,
  "registrant_id" VARCHAR,
  "reported_by" VARCHAR,
  "report_type1" VARCHAR,
  "report_type2" VARCHAR,
  "report_date" TIMESTAMP,
  "report_year" BIGINT,
  "registrant_bus_adr1" VARCHAR,
  "registrant_bus_adr2" VARCHAR,
  "registrant_bus_city" VARCHAR,
  "registrant_bus_state" VARCHAR,
  "registrant_bus_zip" VARCHAR,
  "registrant_mail_adr1" VARCHAR,
  "registrant_mail_adr2" VARCHAR,
  "registrant_mail_city" VARCHAR,
  "registrant_mail_state" VARCHAR,
  "registrant_mail_zip" VARCHAR,
  "total_reimbothers" DOUBLE,
  "total_foodbev" DOUBLE,
  "total_translodg" DOUBLE,
  "total_gifts" DOUBLE,
  "total_entertainment" DOUBLE,
  "total_awards" DOUBLE,
  "total_honorariums" DOUBLE,
  "total_eventfees" DOUBLE,
  "total_media" DOUBLE,
  "total_mediasupport" DOUBLE,
  "edims_docnumber" VARCHAR,
  "no_act" VARCHAR,
  "emp_501c3_yn" VARCHAR,
  "no_client" VARCHAR
);