Primary tabs

Complaints Bulk Data

Attributes of Public Health related complaints reported by the public and investigated by Louisville Metro Department of Public Health and Wellness. Personal/identifying data has been removed. EstID column can be joined to the EstablishmentID column in the Establishments table to show attributes of the establishment when a regulated establishment is involved.
Data Dictionary:
RequestComplaintID-System ID
Rcode-Code for Type of Complaint or Request
RCodeDescription-Text of type of complaint or request
EHS-the license number of the technician investigating
section-complaint section
TakenBy-who took the complaint or service request
Method-how the complaint or service request was taken in
Duplicate-is this a duplicate request? System notation
EstID-Associated permitted facility if applicable
oss_id-associated onsite sewage file if applicable
RequestDate-date of request or complaint
ResolvedDate-date request or complaint was resolved
NextInspDate-scheduled next inspection date
IsCityorCounty-is this a city or county request?
Status-is the request open or resolved?
RequestType-request type
IsFollowUp-is this a folowo up entry to an already open request
OwnerType- Owner or agent? If applicable
PersonOrPremiseZip-zip code of subject person
ComplaintantZip-zip code of person making the complaint
OwnerZip-zip code of the owner of the premises if applicable

Data Preview: Note that by default the preview only displays up to 100 records. Use the pager to flip through more records or adjust the start and end fields to display the number of records you wish to see.

Additional Information

FieldValue
mimetypetext/csv
filesize3.78 MB
resource typefile upload
timestampOct 07, 2019