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.
This dataset has the following 37 columns:
Column Name | API Column Name | Data Type | Description | Sample Values |
---|---|---|---|---|
Add Date/Time | add_date_time | calendar_date | Date and Time stamp when record was added to the database | 2014-02-27T10:59:00.000 2015-02-20T12:36:00.000 2020-10-21T09:37:00.000 2018-07-09T14:05:34.000 2007-08-02T12:00:28.000 view top 100 |
Modified Date/Time | modified_date_time | calendar_date | Date and Time stamp when record was last updated in the database | 2010-12-16T11:24:27.000 2010-12-16T11:24:26.000 2010-12-16T11:24:28.000 2010-12-16T11:24:29.000 2010-12-16T11:24:25.000 view top 100 |
Case Type Code | case_type_code | text | Code of CaseType | CN_COMPL BLDG_AH TB_COMPL BLDG_CRT PL_COMPL view top 100 |
Case Type Description | case_type_description | text | Description of CaseType | CONSERVATION COMPLAINT INVSTGN DOB ADMIN HEARING CASE TROUBLED BUILDINGS COMPLAINT DOB CIRCUIT COURT CASE EL WIRING COMPLAINT INVESTIGAT view top 100 |
Case Primary Key | case_primary_key | number | Case Primary Key (unique). Use this key to link to violations and inspections dataset - PERMITORCASEKEY. | 777557 777762 777789 777821 888485 view top 100 |
Additional Case Description | additional_case_description | text | Additional Case Description | FULL COMPLIANCE PROCESSED FOR COURT PENDING STF COURT CASE COMMISSIONER CLOSURE LIFTED CONSENT DECREE view top 100 |
Case Number | case_number | text | Case Number | 100044 100045 100060 100072 100100 view top 100 |
Case Group | case_group | text | Case Group - Additional Categorization | BS BT DC VBR BN view top 100 |
Case Comments | case_comments | text | Case Comments | complaint 311 COMPLAINT STF#50 311 complaint view top 100 |
Additional Case Location | additional_case_location | text | Additional Case Location Information | FRONT - VACANT - OPEN FRONT - VACANT - BOARDED - - REAR - VACANT - OPEN FRONT - VACANT - OPEN - FRONT view top 100 |
Last Case Activity Date/Time | last_case_activity_date_time | calendar_date | Last date and time Case record updated in database | 2004-03-29T10:45:51.000 2005-09-13T05:52:52.000 2005-06-02T22:46:49.000 2007-09-22T09:01:26.000 2008-02-16T09:02:09.000 view top 100 |
Resolution Code | resolution_code | text | Case Resolution Code | CNCL 20 BBA06 BBA10 18 view top 100 |
Resolution Date/Time | resolution_date_time | calendar_date | Case Resolution Date and Time | 2004-03-29T10:45:51.000 2010-12-16T11:24:27.000 2010-12-16T11:24:26.000 2010-12-16T11:24:28.000 2010-12-16T11:24:29.000 view top 100 |
Case Status | case_status | text | Status of Case - O = Open; C = Complete; V = Void | O C view top 100 |
Disposition Code | disposition_code | text | Case Hearing/Court Disposition Code | PRNT 44 20 18 4217 view top 100 |
Disposition Description | disposition_description | text | Case Hearing/Court Disposition Description | AH DOCUMENTS PRINT DATE DOCUMENT PRINT DATE NON SUITED FULL COMPLIANCE FINE ENTERED view top 100 |
Last Hearing/Court Date | last_hearing_court_date | calendar_date | Last Hearing/Court Date | 2006-12-06T00:00:00.000 2005-11-16T00:00:00.000 2007-04-11T00:00:00.000 2007-06-18T00:00:00.000 2006-09-14T00:00:00.000 view top 100 |
Next Hearing/Court Date | next_hearing_court_date | calendar_date | Next Hearing/Court Date | 2006-04-26T00:00:00.000 2020-06-15T00:00:00.000 2006-04-19T00:00:00.000 2007-01-08T00:00:00.000 2006-01-11T00:00:00.000 view top 100 |
Next Hearing/Court Time | next_hearing_court_time | text | Next Hearing/Court Time | 9:30 AM 9:00 AM 1:30 PM 10:30 AM 12:00 PM view top 100 |
Next Hearing/Court Room | next_hearing_court_room | number | Next Hearing/Court Room | 1105 1103 1107 1111 115 view top 100 |
MMRP Zone | mmrp_zone | text | Name of MMRP Zone | West Woodlawn Chatham Englewood Auburn Gresham Humboldt Park view top 100 |
Street Number | street_number | number | Address Street Number | 6131 6414 6400 6425 6125 view top 100 |
Pre-Direction | pre_direction | text | Address Pre-Direction | S W N E view top 100 |
Street Name | street_name | text | Address Street Name | DR MARTIN L KING JR SANGAMON ELLIS EBERHART MARYLAND view top 100 |
Suffix | suffix | text | Address Suffix | AVE ST DR PL BLVD view top 100 |
Post Direction | post_direction | number | Address Post Direction | view top 100 |
Zip Code | zip_code | number | Address Zip Code | 60637 60619 60621 60639 60624 view top 100 |
Community Area | community_area | number | Geography - Community Area | 42 44 68 19 71 view top 100 |
Ward | ward | number | Geography - Ward | 20 8 16 17 27 view top 100 |
X Coord | x_coord | number | X Coord - State Plane Eastern IL 1983 | 1182228.7351163602 1173185.002641102 1184040.38041292 1138987.2525111951 1179985.222012994 view top 100 |
Y Coord | y_coord | number | Y Coord - State Plane Eastern IL 1983 | 1865350.6582684703 1862171.0185648492 1850482.7277047941 1902793.732579811 1862486.807651777 view top 100 |
Latitude | latitude | number | Latitude | 41.78574174363065 41.77722119983977 41.74490054646211 41.88938363832062 41.77793474324029 view top 100 |
Longitude | longitude | number | Longitude | -87.60740121841071 -87.64065355106028 -87.6012229266319 -87.76503865254902 -87.61571455247697 view top 100 |
Central Business District | central_business_district | text | Central Business District as described by Ordinance - "Central Business District" means the district consisting of those streets or parts of streets within the area bounded by a line as follows: beginning at the easternmost point of Division Street extended to Lake Michigan; then west on Division Street to LaSalle Street; then south on LaSalle Street to Chicago Avenue; then west on Chicago Avenue to Halsted Street; then south on Halsted Street to Roosevelt Road; then east on Roosevelt Road to its easternmost point extended to Lake Michigan; including parking spaces on both sides of the above-mentioned streets. | N view top 100 |
Address Key | address_key | number | Address Unique Key (use this column to link cases to MMRP Geographies data set - ADDRKEY) | 425326 444246 498895 80917 441029 view top 100 |
Address Grouping Key | address_grouping_key | number | Address Group Unique Key (use this column to link cases to MMRP Geographies data set - ADDRGRPKEY). An Address Group is a grouping of point addresses (ADDRKEY's) at the same property; example: the Daley Center is located on 4 bounding streets (Washington, Dearborn, Randolph and Clark) and each street has many point addresses for the Daley Center. All point addresses on all four bounding streets are grouped using the same ADDRGRPKEY. This field allows for ALL activity at a building to be grouped into one dataset. | 23240 21001 19382 22563 19692 view top 100 |
Location | location | location | Geocoded Location based on Latitude/Longitude | view top 100 |