About this Dataset

311 Service Requests - Vacant And Abandoned Buildings Reported - Historical

As described in https://data.cityofchicago.org/stories/s/311-Dataset-Changes-12-11-2018/d7nq-5g7t, the function of this dataset was replaced by https://data.cityofchicago.org/d/v6vf-nfxy. This dataset is historical-only.

All 311 calls for open and vacant buildings reported to the City of Chicago since January 1, 2010. The information is updated daily with the previous day's calls added to the records. The data set provides the date of the 311 service request and the unique Service Request # attached to each request. For each request, the following information (as reported by the 311 caller) is available: address location of building; whether building is vacant or occupied; whether the building is open or boarded; entry point if building is open; whether non-residents are occupying or using the building, if the building appears dangerous or hazardous and if the building is vacant due to a fire.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:31.226915
Tags: 311, buildings, historical, service-requests

Tables

Table 1

@usgov.city_of_chicago_311_service_requests_vacant_and_abando_904dc783.table_1

4.58 MB
65,119 rows
23 columns

CREATE TABLE table_1 (
  "service_request_type" VARCHAR,
  "service_request_number" VARCHAR,
  "date_service_request_was_received" TIMESTAMP,
  "location_of_building_on_the_lot_if_garage_change_type__094d34a3" VARCHAR  -- LOCATION OF BUILDING ON THE LOT (IF GARAGE, CHANGE TYPE CODE TO BGD).,
  "is_the_building_dangerous_or_hazardous" VARCHAR  -- IS THE BUILDING DANGEROUS OR HAZARDOUS?,
  "is_building_open_or_boarded" VARCHAR  -- IS BUILDING OPEN OR BOARDED?,
  "if_the_building_is_open_where_is_the_entry_point" VARCHAR  -- IF THE BUILDING IS OPEN, WHERE IS THE ENTRY POINT?,
  "is_the_building_currently_vacant_or_occupied" VARCHAR  -- IS THE BUILDING CURRENTLY VACANT OR OCCUPIED?,
  "is_the_building_vacant_due_to_fire" VARCHAR  -- IS THE BUILDING VACANT DUE TO FIRE?,
  "any_people_using_property_homeless_childen_gangs" VARCHAR  -- ANY PEOPLE USING PROPERTY? (HOMELESS, CHILDEN, GANGS),
  "address_street_number" DOUBLE,
  "address_street_direction" VARCHAR,
  "address_street_name" VARCHAR,
  "address_street_suffix" VARCHAR,
  "zip_code" DOUBLE,
  "x_coordinate" DOUBLE,
  "y_coordinate" DOUBLE,
  "ward" DOUBLE,
  "police_district" DOUBLE,
  "community_area" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "location" VARCHAR
);