Data Oddities

Service request that has a "closed" datetime before its "requested" datetime: http://servicetracker.cityofchicago.org/requests/13-00782355

Pothole is patched, but the request is still open: http://servicetracker.cityofchicago.org/requests/13-00722732

Restaurant complaint is status = "open" but the notes indicate it has been closed:

[
  {
    "service_request_id": "13-00575277",
    "status": "open",
    "status_notes": "Failed/Citations Issued",
    "service_name": "Restaurant Complaint",
    "service_code": "4fd6e4ece750840569000019",
    "agency_responsible": "Health - Food Protection",
    "requested_datetime": "2013-05-14T09:02:29-05:00",
    "updated_datetime": "2013-06-19T11:23:39-05:00",
    "address": "1143 N LAVERGNE AVE, CHICAGO, IL, 60651",
    "lat": 41.90126402377569,
    "long": -87.75084884900936,
    "notes": [
      {
        "datetime": "2013-05-14T08:48:29-05:00",
        "summary": "Request opened",
        "type": "opened"
      },
      {
        "datetime": "2013-05-16T11:22:00-05:00",
        "summary": "Assign To Field Supervisor",
        "description": "Failed/Citations Issued",
        "type": "activity"
      },
      {
        "datetime": "2013-05-17T11:23:19-05:00",
        "summary": "Request closed",
        "type": "closed"
      },
      {
        "datetime": "2013-05-22T11:48:44-05:00",
        "summary": "Request reopened",
        "type": "closed"
      },
      {
        "datetime": "2013-05-24T12:30:00-05:00",
        "summary": "Send Letter",
        "description": "Pass",
        "type": "activity"
      }
    ],
    "extended_attributes": {
      "channel": "phone",
      "ward": "37",
      "police_district": "15"
    }
  }
]