Details of request “Bid Tabulation Results for Emergency Sewer Main Repairs & Replacement

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
687941  set_embargo    2023-06-20 11:55:22 -0400         
687942  sent    2023-06-20 11:55:23 -0400  waiting_response  waiting_response  2023-06-20 11:55:23 -0400  outgoing  
687943  public_token    2023-06-20 11:55:24 -0400         
690169  response    2023-06-22 16:37:45 -0400    waiting_response  2023-06-22 17:24:04 -0400  incoming  
690216  followup_sent    2023-06-22 17:23:59 -0400        outgoing  
690217  status_update    2023-06-22 17:24:04 -0400  waiting_response  waiting_response  2023-06-22 17:24:04 -0400   
691592  response    2023-06-23 14:25:53 -0400    waiting_response  2023-06-26 09:49:04 -0400  incoming  
695458  followup_sent    2023-06-26 09:49:01 -0400        outgoing  
695459  status_update    2023-06-26 09:49:04 -0400  waiting_response  waiting_response  2023-06-26 09:49:04 -0400   
700209  overdue    2023-06-30 00:00:00 -0400         
713709  very_overdue    2023-07-20 00:00:00 -0400         
956694  embargo_expiring    2024-06-11 00:00:00 -0400         
963860  expire_embargo    2024-06-19 00:00:07 -0400         
964179  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964180  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964181  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964182  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964183  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964184  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964185  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964186  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964187  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964188  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964189  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964190  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
964191  edit metadata  allow_new_responses_from  2024-06-19 03:45:13 -0400         
1313321  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313322  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313323  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313324  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313325  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313326  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313327  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313328  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313329  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313330  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313331  edit metadata  allow_new_responses_from  2025-06-27 03:45:31 -0400         
1313332  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313333  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313334  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313335  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313336  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313337  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313338  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313339  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313340  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313341  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313342  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313343  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313344  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313345  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         
1313346  edit metadata  allow_new_responses_from  2025-06-27 03:45:32 -0400         

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.