Customer service requests, with resolution time

Requests for service logged by members of the public relating to waste, graffiti, parking,\r\nroads and traffic, parks and trees and assets in a public space.\r\n\r\nREQUEST_STATUS - The current status of the request. This can be a combination of: CLOSED (completed/resolved), WIP (work in progress), REASSIGNED (This request has been moved to another work unit), NEW (This request has been logged and will be allocated to the appropriate officer), ACTIONED (The work has been assigned to a unit).\r\n\r\nDATE_RECEIVED - The date that the customer service request was received.\r\n\r\nDATE_COMPLETED - The date that the request was finalized/resolved.\r\n\r\nSUBURB - The suburb of the request (confidential requests have been removed). Some suburb values will be blank because they do not have a location assigned. \r\n\r\nCATEGORY - The high level category of the request.\r\n\r\nSERVICE_DESC - A more detailed description of the request.\r\n\r\nDAYS_TO_COMPLETE - Indicates numbers of days between DATE_RECEIVED and DATE_COMPLETED. This does not include time taken when referring to other authorities or waiting for more information from the customer.