This dataset has the following 29 columns:
| Column Name | API Column Name | Data Type | Description |
|---|---|---|---|
| inspection | inspection | number | Inspection number. |
| assignto | assignto | text | ID of the inspector the inspection is assigned to. |
| callby | callby | text | ID of the employee that entered the call. |
| calldttm | calldttm | calendar_date | Call date/time. |
| comments | comments | text | Additional information for the inspection. |
| inspdttm | inspdttm | calendar_date | Inspection date/time. |
| inspby | inspby | text | ID of the inspector that performed the inspection. |
| inspgen | inspgen | text | Indicates if the inspection was generated by the inspector or by the system. |
| insptype | insptype | text | Type of inspection. |
| loc | loc | text | Additional information for the location. |
| odomstart | odomstart | number | Odometer start. |
| odomstop | odomstop | number | Odometer stop. |
| partial | partial | text | Indicates partial inspection. |
| preference | preference | text | Used to set aside the necessary time need for some inspections. |
| schedby | schedby | text | ID of the employee that scheduled the inspection. |
| scheddttm | scheddttm | calendar_date | Scheduled date/time. |
| status | status | text | Status of the inspection. |
| tmpltype | tmpltype | text | Inspection template type. |
| typeno | typeno | number | Number of inspections performed of an inspection type. |
| waived | waived | text | Indicates whether the inspection was waived. |
| waiveddt | waiveddt | calendar_date | Waived date/time. |
| location1 | location1 | location | The property that was inspected. |
| Case Number | case_number | text | The number of the case that the inspection is attached to. |
| commercial | commercial | number | Number of commercial units for the property. |
| ownocc | ownocc | number | Number of owner occupied units for the property. |
| rooms | rooms | number | Number of rooms units for the property. |
| units | units | number | Number of apartment units for the property. |
| apprcvd | apprcvd | calendar_date | The date the CDBG application was received. |
| letsent | letsent | calendar_date | The date the CDBG letter was sent. |