Housing Code Cases 1/1/2011 to Current. Updated Nightly
This dataset has the following 14 columns:
| Column Name | API Column Name | Data Type | Sample Values |
|---|---|---|---|
| Case Number | case_number | text | 18651 18654 18658 18660 18670 view top 100 |
| Parcel ID | parcel_id | text | 153181001 223279007 295564001 154181090 238057023 view top 100 |
| Location | location | text | 280 COLLINS ST 600 ASYLUM AV 141 WOODLAND ST 105 SHERBROOKE AV 887 ASYLUM AV view top 100 |
| Location Description | location_description | text | B1 A1 A2 B2 303 view top 100 |
| Title | title | text | Housing Code Inspector Program Supervisor Public Health Inspector Sealer of Weights & Measures Housing Code Enforce Spv view top 100 |
| Type | complaintviolation | text | Housing Code Enforcement Certificate of Apartment Occupancy Essential Services Bed Bugs (HCE) Rodent (HCE) view top 100 |
| Open Date | reported | calendar_date | 2014-09-23T00:00:00.000 2014-09-03T00:00:00.000 2015-09-18T00:00:00.000 2014-08-25T00:00:00.000 2011-11-30T00:00:00.000 view top 100 |
| Closed Date | statusclosedate | calendar_date | 2014-08-29T00:00:00.000 2013-08-09T00:00:00.000 2014-07-17T00:00:00.000 2014-08-14T00:00:00.000 2017-09-08T00:00:00.000 view top 100 |
| Global Entity Name | department | text | CP FEE LLC HARTFORD HOUSING AUTHORITY GARDEN HILL APARTMENTS LLC ST FRANCIS HOSPITAL OF HTFD AH MIN HOLDING LLC view top 100 |
| First Name | zone | text | VALERIE MICHAEL JOHN MICHELLE ABRAHAM view top 100 |
| Last Name | ownername | text | ZULLO WILLIAMS MARCH KU STEINMETZ view top 100 |
| Inspector First Name | complianceinspector | text | Rochelle Albi Elisha Shawn Tonja view top 100 |
| Inspector Last Name | holdpermits | text | Little Sako Barrows Holloway Nelson view top 100 |
| geom | geom | location | view top 100 |