About this Dataset

Foreclosed Rental Property

Foreclosed rental properties registered with the Chicago Department of Housing under the Keep Chicago Renting ordinance. Prior to 12/12/2022, Owner and Owner Management Agent addresses could not be registered through the registration site so no City, State, or ZIP columns were present in this dataset. Because all previously existing records had Chicago addresses for Owner and Owner Agent, the City and State columns were populated when added to this dataset but ZIP values are only available from 12/12/2022 forward. The Property Address is always in Chicago.
Organization: City of Chicago
Last updated: 2022-04-28T05:20:51.849957
Tags: housing

Tables

Table 1

@usgov.city_of_chicago_foreclosed_rental_property.table_1

60.56 KB
445 rows
18 columns


CREATE TABLE table_1 (
  "id" BIGINT,
  "property_address" VARCHAR,
  "submission_date" TIMESTAMP,
  "owner_name" VARCHAR,
  "owner_date" VARCHAR,
  "owner_management_agent_name" VARCHAR,
  "owner_notices_agent_name" VARCHAR,
  "owner_notices_agent_phone" VARCHAR,
  "owner_notices_agent_email" VARCHAR,
  "owner_address" VARCHAR,
  "owner_city" VARCHAR,
  "owner_state" VARCHAR,
  "owner_zip" DOUBLE,
  "owner_management_agent_address" VARCHAR,
  "owner_management_agent_city" VARCHAR,
  "owner_management_agent_state" VARCHAR,
  "owner_management_agent_zip" DOUBLE,
  "location" VARCHAR
);