Service Requests since 2016

data.memphistn.gov | Last Updated 23 Sep 2022

This dataset contains all service requests that were created since 01-January-2016

Tags: 311

This dataset has the following 48 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
ADDRESS1address1textService request address
ADDRESS2address2textService request address2
ADDRESS3address3textService request address3
AREAareatextService request area
CATEGORYcategorytextIncident category
CE_CATEGORYce_categorytextCode enforcement category
CITYcitytextCity (Memphis)
CLOSE_DATEclose_datecalendar_dateDate service request status changed to "Closed"
COLLECTION_DAYcollection_daytextScheduled collection day
CREATED_BYcreated_bytext-
CREATED_BY_USERcreated_by_usertextUser who created service request
CREATION_DATEcreation_datecalendar_dateAuto-generated service request creation date (may be after user-reported REPORTED_DATE if person waited to submit request)
DEPARTMENTdepartmenttextCity department responsible for service request (departments fall within divisions)
DISTRICTdistricttextCity council district in which SR incident address is located
DIVISIONdivisiontextCity division responsible for service request
FOLLOWUP_DATEfollowup_datecalendar_dateFollowup date
FULL_ADDRESSfull_addresstextFull service request address with city, state and zip code
GROUP_NAMEgroup_nametextGroup responsible for service request (similar to Division/Department)
INCIDENT_IDincident_idtextUnique incident ID
INCIDENT_NUMBERincident_numbertextUnique incident number
INCIDENT_RESOLVED_DATEincident_resolved_datecalendar_dateDate service request status changed to "Resolved"
INCIDENT_TYPE_IDincident_type_idtextIncident type ID
LAST_MODIFIED_DATElast_modified_datecalendar_dateDate service request last modified (user-generated)
LAST_UPDATE_DATElast_update_datecalendar_dateDate service request last updated (auto-generated)
LAST_UPDATE_LOGINlast_update_logintext-
LAST_UPDATED_BYlast_updated_bytext-
Location 1location_1textIncident location
MAP_PAGEmap_pagetext-
NEXT_OPEN_TASK_DATEnext_open_task_datecalendar_dateNext open task date
NUMBER_OF_TASKSnumber_of_taskstextNumber of tasks
OWNER_NAMEowner_nametextOwner name
PARCEL_IDparcel_idtext-
POSTAL_CODEpostal_codetextService request zip code
REPORTED_DATEreported_datecalendar_dateUser-submitted service request report date
REQUEST_PRIORITYrequest_prioritytextRequest priority: High, Medium, or Low
REQUEST_STATUSrequest_statustextRequest status: Open, In Progress, Closed, etc.
REQUEST_TYPErequest_typetextRequest type (acronyms correspond to department: SWM = Solid Waste Management, EMI = Environmental Maintenance, CE = Code Enforcement, etc.)
RESOLUTION_CODEresolution_codetextCode indicating how the incident was resolved and/or actions taken to address the service request
RESOLUTION_CODE_MEANINGresolution_code_meaningtextResolution code meaning
RESOLUTION_SUMMARYresolution_summarytextSummary of incident resolution/actions taken
SR_CREATION_CHANNELsr_creation_channeltextService request creation channel (phone or web)
STATEstatetextSR state (TN)
STREET_NAMEstreet_nametextSR street name
SUB_DISTRICTsub_districttextCouncil sub-district in which SR incident is located
SWM_CODEswm_codetextSolid Waste Management code
TARGET_BLOCKtarget_blocktext
ZONEzonetext
location1location1point