Temporal filters

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)

  1. Created date - Date and time when the service request was first received
  2. Closed date - Date and time when the service request was closed by responding agency
  3. 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).
  4. 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:

  1. Year - Data set contains service requests from 2010 to 2018
  2. Month - Calendar year lunar months from January to December
  3. Season - Annual North American seasons: winter (December-February); spring (March-May); summer (June-August); fall (September-November)
  4. Weekday vs. weekend - Based on day of the week: weekday (Monday-Friday); weekend (Saturday-Sunday)
  5. 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.

For detailed information about the data set columns, visit the OpenData Data Dictionary or see the expanded One-Stop Shop Data Dictionary.

311 Open Data in US Cities

How are requests resolved?