Louisville Metro KY - Environmental Health Bulk Data - Complaints by US Government | Healthcare

About this Dataset

Louisville Metro KY - Environmental Health Bulk Data - Complaints

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

Contact:

Gerald Kaforski

gerald.kaforski@louisvilleky.gov
Organization: Louisville Metro Government
Last updated: 2023-04-13T13:30:26.021204
Tags: complaints, environmental-health, health, inspections, jefferson-county, kentucky, louisville, louisville-metro, louisville-metro-ky, metro-health, public-health, public-health-and-wellness, sanitation

Tables

Table 1

@usgov.louisville_metro_government_louisville_metro_ky_enviro_ecbf687c.table_1

539.24 KB
23526 rows
22 columns


CREATE TABLE table_1 (
  "requestcomplaintid" BIGINT,
  "rcode" BIGINT,
  "rcodedescription" VARCHAR,
  "ehs" BIGINT,
  "section" BIGINT,
  "takenby" VARCHAR,
  "method" VARCHAR,
  "duplicate" VARCHAR,
  "estid" DOUBLE,
  "oss_id" VARCHAR,
  "requestdate" VARCHAR,
  "resolveddate" TIMESTAMP,
  "nextinspdate" TIMESTAMP,
  "iscityorcounty" VARCHAR,
  "status" VARCHAR,
  "requesttype" VARCHAR,
  "isfollowup" VARCHAR,
  "ownertype" VARCHAR,
  "personorpremisezip" BIGINT,
  "complaintantzip" DOUBLE,
  "ownerzip" VARCHAR,
  "objectid" BIGINT
);