Micro-Market Recovery Program - Violations And Inspections by US Government | Finance and Economics

About this Dataset

Micro-Market Recovery Program - Violations And Inspections

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 Violations and Inspections dataset contains Department of Buildings (DOB) Violations and associated Inspections that have occured at properties falling within an 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 and link to Permits APKEY_PERMIT and Cases APKEY_CASE. *Note: Inspections are included only when at least one violation was written. Inspections without violations are not included in this dataset.
Organization: City of Chicago
Last updated: 2020-11-10T16:55:29.595014
Tags: buildings, inspections

Tables

Table 1

@usgov.city_of_chicago_micro_market_recovery_program_violatio_19a8b877.table_1

22.17 MB
264998 rows
43 columns


CREATE TABLE table_1 (
  "template_type" VARCHAR,
  "permit_or_case_type" VARCHAR,
  "permit_or_case_description" VARCHAR,
  "permit_or_case_primary_key" BIGINT,
  "inspection_number" BIGINT,
  "inspection_completed_date_and_time" VARCHAR,
  "inspected_by" VARCHAR,
  "inspection_type" VARCHAR,
  "partial_inspection" VARCHAR,
  "trip_number" BIGINT,
  "inspection_waived" VARCHAR,
  "inspection_waived_date_and_time" TIMESTAMP,
  "inspection_status" VARCHAR,
  "violation_primary_key" DOUBLE,
  "modified_date_time" VARCHAR,
  "violation_complied_date" VARCHAR,
  "violation_comments" VARCHAR,
  "violation_code" VARCHAR,
  "violation_location" VARCHAR,
  "violation_date" VARCHAR,
  "violation_additional_comments" VARCHAR,
  "violation_additional_comments2" VARCHAR,
  "violation_sequence_number" DOUBLE,
  "violation_status" VARCHAR,
  "violation_description" VARCHAR,
  "violation_code_book_text" VARCHAR,
  "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
);