About this Dataset

Micro-Market Recovery Program - Cases

The City of Chicago launched the Micro-Market Recovery Program (MMRP), a coordinated effort among the City, not-for-profit intermediaries, and non-profit and for-profit capital sources to improve conditions, strengthen property values, and create environments supportive of private investment in targeted markets throughout the city. The goal of MMRP is to improve conditions, strengthen property values, and create environments supportive of private investment in targeted areas by strategically deploying public and private capital and other tools and resources in well-defined micro-markets. This MMRP Case dataset contains all Department of Buildings (DOB) Cases that have occured at properties falling within any MMRP Zone. Permits, Cases and Violations can be linked to the MMRP Geographies dataset using ADDRKEY or ADDRGRPKEY. To link Violations and Inspections to their Permits and Cases use Violation PERMITORCASEKEY to link to Permits APKEY_PERMIT and Cases APKEY_CASE. For more information on the MMRP program, please see http://www.regionalhopi.org/content/city-chicago-micro-market-recovery-program-overview.
Organization: City of Chicago
Last updated: 2020-11-10T16:54:57.509887
Tags: buildings, inspections

Tables

Table 1

@usgov.city_of_chicago_micro_market_recovery_program_cases.table_1

3.09 MB
26458 rows
37 columns


CREATE TABLE table_1 (
  "add_date_time" VARCHAR,
  "modified_date_time" VARCHAR,
  "case_type_code" VARCHAR,
  "case_type_description" VARCHAR,
  "case_primary_key" BIGINT,
  "additional_case_description" VARCHAR,
  "case_number" VARCHAR,
  "case_group" VARCHAR,
  "case_comments" VARCHAR,
  "additional_case_location" VARCHAR,
  "last_case_activity_date_time" VARCHAR,
  "resolution_code" VARCHAR,
  "resolution_date_time" VARCHAR,
  "case_status" VARCHAR,
  "disposition_code" VARCHAR,
  "disposition_description" VARCHAR,
  "last_hearing_court_date" VARCHAR,
  "next_hearing_court_date" TIMESTAMP,
  "next_hearing_court_time" VARCHAR,
  "next_hearing_court_room" DOUBLE,
  "mmrp_zone" VARCHAR,
  "street_number" BIGINT,
  "pre_direction" VARCHAR,
  "street_name" VARCHAR,
  "suffix" VARCHAR,
  "post_direction" VARCHAR,
  "zip_code" BIGINT,
  "community_area" BIGINT,
  "ward" BIGINT,
  "x_coord" DOUBLE,
  "y_coord" DOUBLE,
  "latitude" DOUBLE,
  "longitude" DOUBLE,
  "central_business_district" VARCHAR,
  "address_key" BIGINT,
  "address_grouping_key" BIGINT,
  "location" VARCHAR
);