somervillema-gov/311-service-requests-and-work-orders-4pyi-uqq6
 
Readme
Updated 1 day ago
Indexed 17 hours ago

311 Service Requests and Work Orders

Contains work order, service request, and 311 data dating from 2015 to the present. Data is used in the City's dashboard which can be found at https://www.somervilledata.farm/.

Columns

NameSocrata field nameColumn name in sgr mountData typeDescription
categorycategorycategoryTextType of 311 entry
deptdeptdeptTextDepartment
statusstatusstatusTextStatus of ticket
originoriginoriginTextTicket origination information
ancestorancestorancestorNumberNumerical categorization level between department and request type. Matches ancestor_id in 311 Service Types dataset
latitudelatitudelatitudeNumberLatitude of location relevant to the ticket, if provided
idididNumberTicket ID
typetypetypeNumberRequest type ID
last_modifiedlast_modifiedlast_modifiedCalendar dateDate/time ticket was last modified
longitudelongitudelongitudeNumberLongitude of location relevant to the ticket, if provided
created_oncreated_oncreated_onCalendar dateDate/time of ticket creation