311 Citizen Requests for Service

data.brla.gov | Last Updated 27 Apr 2018

This dataset includes all requests for service received from the City-Parish 311 Call Center, including requests for service submitted online and through the Red Stick 311 mobile application, dating back to January 1, 2016. Submitter names, phone numbers, and e-mail addresses are redacted for privacy purposes. Data is updated daily from the Public Works Business Office and 311 Call Center. Phone numbers are redacted to protect the contact information and privacy of citizens by replacing raw digits with XXX-XXX-XXXX. For any questions about this process, please contact opendata@brgov.com.

Tags: request, service, 311, public works

This dataset has the following 23 columns:

Column NameAPI Column NameData TypeDescriptionSample Values
SERVICE REQUEST IDidtextUnique identifier assigned to each citizen request for service for tracking and resolution purposes.
STATUSstatusdesctextMatches Status ID - Open, Closed, or In Progress.
CREATE DATEcreatedatecalendar_dateThe date the service request was created within the City-Parish's 311 service request and complaint tracking system, either by phone, online, or via web app.
CLOSE DATEcloseddatecalendar_dateThe date the service request was closed due to the request as being addressed or the issue being resolved, confirmed by the responding department/division.
LAST ACTION DATElastactioncalendar_dateThe date of the most recent adjustment or notation to this service request, as noted by the responding department/division. Typically, this field will match that of the closed date if a request has been resolved or closed.
PARENT TYPEparenttypetextThe parent type of service request - matches that of the ParentID field.
TYPEtypenametextA description of the type of service request represented by the request ID - matches that of the TypeID field.
COMMENTScommentstextAny comments submitted by the reporting citizen associated with the request for service or issue to be resolved.
STREET NUMBERstreetnumtextThe street number of the address where services are needed or issues need to be resolved.
STREET NAMEstreetnametextThe name of the street where services are needed or issues need to be resolved.
FULL ADDRESSstreetaddresstextThe full street address where service are needed or issues need to be resolved.
CROSS STREETcrossnametextAny cross street information available as reported by the submitting citizen (for example, at an intersection).
CITYcitynametextThe city of the reported issue - Baton Rouge, Baker, Zachary, or Central. Issues reported in the unincorporated areas of East Baton Rouge Parish or without city information are reported as East Baton Rouge.
DEPARTMENTdepartmenttextThe City-Parish department with oversight over the requested service or reported issue.
DIVISIONdivisiontextThe City-Parish division responsible for responding to the requested service or reported issue, which is a division of the department noted in the Department field.
LATITUDElatitudenumberThe latitude coordinates of the issue or request for service for geocoding purposes.
LONGITUDElongitudenumberThe longitude coordinates of the issue or request for service for geocoding purposes.
GEOLOCATIONgeolocationlocation
TYPEI DtypeidtextThe specific type of service request represented by the request ID.
PARENT IDparentidtextThe parent category ID of the type of service request (typename) as organized within the City-Parish 311 Citizen Request system.
DEPTDIV IDdeptdividtextThe ID of the City-Parish department and division responsible for responding to the requested service or reported issue.
DEPARTMENT-DIVISION NAMEdeptdivtextThe City-Parish department and division responsible for responding to the requested service or reported issue - matches that of the DeptDivID field.
STATUS IDstatustextStatus of service request 0 = Open, 1 = Closed, 3 = In Progress.