What to expect in the original NYC311 data set
NYC311 data contains four key date attributes described below: (All in the format of MM/DD/YY HH:MM:SS AM/PM)
- Created date - Date and time when the service request was first received
- Closed date - Date and time when the service request was closed by responding agency
- Due date - Date when responding agency is expected to update the service request. This is based on the Complaint Type and internal Service Level Agreements (SLAs).
- Resolution action updated date - Date when responding agency last updated the service request
Attributes We've added to the One-Stop Shop data set
Using the created date field, the following temporal filters were found to be most relevant for analysis based on user interviews:
- Year - Data set contains service requests from 2010 to 2018
- Month - Calendar year lunar months from January to December
- Season - Annual North American seasons: winter (December-February); spring (March-May); summer (June-August); fall (September-November)
- Weekday vs. weekend - Based on day of the week: weekday (Monday-Friday); weekend (Saturday-Sunday)
- Day vs Night - Based on time service request was received: day (6AM-6PM); night (6PM-6AM)
See our post on How are requests resolved? for data considerations when using these temporal filters.