Details of request “Bid Tabulation Results for 2023 Emergency Sewer Repairs

Event history

This table shows the technical details of the internal events that happened to this request on OPRAmachine. This could be used to generate information about the speed with which authorities respond to requests, the number of requests which require a postal response and much more.

Be careful! To use this data in an honourable way, you will need a good internal knowledge of user behaviour on OPRAmachine. How, why and by whom requests are categorised is not straightforward, and there will be user error and ambiguity. You will also need to understand FOI law, and the way authorities use it. Plus you'll need to be an elite statistician. Please contact us with questions.

id event_type details created_at described_state calculated_state last_described_at link
805414  set_embargo    2023-12-09 05:39:02 -0500         
805415  sent    2023-12-09 05:39:02 -0500  waiting_response  waiting_response  2023-12-09 05:39:02 -0500  outgoing  
805416  public_token    2023-12-09 05:39:04 -0500         
819242  overdue    2023-12-20 00:00:00 -0500         
835431  very_overdue    2024-01-10 00:00:00 -0500         
1004110  followup_sent    2024-08-01 21:18:26 -0400  internal_review  internal_review  2024-08-01 21:18:26 -0400  outgoing  
1004685  response    2024-08-02 08:36:49 -0400        incoming  
1004687  response    2024-08-02 08:45:16 -0400        incoming  
1005696  followup_sent    2024-08-03 23:12:27 -0400        outgoing  
1006696  response    2024-08-05 08:58:31 -0400        incoming  
1099114  embargo_expiring    2024-11-30 00:00:00 -0500         
1105358  expire_embargo    2024-12-08 00:00:06 -0500         
1160264  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160265  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160266  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160267  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160268  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160269  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160270  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160271  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160272  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160273  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160274  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         
1160275  edit metadata  allow_new_responses_from  2025-02-06 03:45:08 -0500         

Here described means when a user selected a status for the request, and the most recent event had its status updated to that value. calculated is then inferred by OPRAmachine for intermediate events, which weren't given an explicit description by a user. See the search tips for description of the states.

You can get this page in computer-readable format as part of the main JSON page for the request. See the API documentation.