About this Dataset

Lobbyist - Expenditures

This dataset lists each expenditure reported 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:29:45.109634
Tags: city-clerk, ethics, expenditures, financial, lobbyist

Tables

Table 1

@usgov.city_of_austin_lobbyist_expenditures.table_1

19.84 kB
29 rows
24 columns

CREATE TABLE table_1 (
  "report_id" VARCHAR,
  "transaction_id" VARCHAR,
  "registrant_id" VARCHAR,
  "entity_cd" VARCHAR,
  "payee_title" VARCHAR,
  "payee_first_name" VARCHAR,
  "payee_mi" VARCHAR,
  "payee_last_name" VARCHAR,
  "payee_suffix" VARCHAR,
  "payee_adr1" VARCHAR,
  "payee_adr2" VARCHAR,
  "payee_city" VARCHAR,
  "payee_state" VARCHAR,
  "payee_zip" BIGINT,
  "payment_date" VARCHAR,
  "payment_amount" DOUBLE,
  "expn_category" VARCHAR,
  "expn_desc" VARCHAR,
  "city_official_bus_yn" VARCHAR,
  "city_official_first_name" VARCHAR,
  "city_official_last_name" VARCHAR,
  "city_official_job_title" VARCHAR,
  "city_official_dept" VARCHAR,
  "row_id" VARCHAR
);