Dataset: Austin Code Complaint Cases

About this Dataset

Austin Code Complaint Cases

City of Austin Open Data Terms of Use
https://data.austintexas.gov/stories/s/ranj-cccq

This data represents Austin Code Department complaint cases.
Organization: City of Austin
Last updated: 2020-11-12T13:22:41.706921
Tags: code, complaints

Tables

Table 1

@usgov.city_of_austin_austin_code_complaint_cases.table_1

5.37 MB
82615 rows
27 columns


CREATE TABLE table_1 (
  "case_id" VARCHAR,
  "priority" DOUBLE,
  "status" VARCHAR,
  "address_long" VARCHAR,
  "house_number" VARCHAR,
  "street_name" VARCHAR,
  "city" VARCHAR,
  "state" VARCHAR,
  "zip_code" DOUBLE,
  "opened_date" TIMESTAMP,
  "closed_date" TIMESTAMP,
  "department" VARCHAR,
  "case_type" VARCHAR,
  "description" VARCHAR,
  "inspector" VARCHAR,
  "date_updated" VARCHAR,
  "last_update" VARCHAR,
  "violationcasenumber" VARCHAR,
  "violationcaselink" VARCHAR,
  "parcelid" VARCHAR,
  "location" VARCHAR,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "repeatoffenderrelated" VARCHAR,
  "shorttermrentalrelated" VARCHAR,
  "servicerequestnumber" VARCHAR,
  "reportedby" VARCHAR
);