About this Dataset

Vacant And Abandoned Buildings - Violations

NOTE, 6/28/2021: There are changes and correction in this dataset. See http://dev.cityofchicago.org/open%20data/data%20portal/2021/06/28/vacant-abandoned.html for details. -- Vacant and abandoned building violations issued on properties owned by financial institutions since January 1, 2011. Each violation is tied to a Docket Number. A Docket may have more than one violation associated with it. Fees are assessed based on all violations associated with a particular Docket. This dataset displays the most recent action (disposition description) for each violation, the fees and fines associated with the docket and the amount paid or outstanding for the docket. If the docket is a City Non-Suit or the owner is found to be Not Liable, then no payment is required. Note that multiple addresses may be associated with a violation; in these cases, multiple records will be included in this dataset for a single violation. / Data Owners: Administrative Hearings / Finance / Time Period: January 1, 2011 to present / Update Frequency: Data is updated daily
Organization: City of Chicago
Last updated: 2020-11-10T16:55:05.346904
Tags: violations

Tables

Table 1

@usgov.city_of_chicago_vacant_and_abandoned_buildings_violations.table_1

376.71 KB
5008 rows
20 columns


CREATE TABLE table_1 (
  "docket_number" VARCHAR,
  "violation_number" VARCHAR,
  "issued_date" TIMESTAMP,
  "issuing_department" VARCHAR,
  "last_hearing_date" VARCHAR,
  "property_address" VARCHAR,
  "violation_type" VARCHAR,
  "entity_or_person_s" VARCHAR,
  "disposition_description" VARCHAR,
  "total_fines" DOUBLE,
  "total_administrative_costs" DOUBLE,
  "interest_amount" DOUBLE,
  "collection_costs_or_attorney_fees" DOUBLE,
  "court_cost" DOUBLE,
  "original_total_amount_due" DOUBLE,
  "total_paid" DOUBLE,
  "current_amount_due" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);