Details of request 'What formats to you store what data in,'

Event history

This table shows the technical details of the internal events that happened to this request on WhatDoTheyKnow. 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.

Caveat emptor! To use this data in an honourable way, you will need a good internal knowledge of user behaviour on WhatDoTheyKnow. 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 created_at described_state last_described_at calculated_state link
118326 sent Sun Dec 06 11:26:55 UTC 2009 waiting_response Sun Dec 06 11:26:55 UTC 2009 waiting_response outgoing
119295 response Wed Dec 09 11:03:50 UTC 2009 waiting_response Wed Dec 09 16:40:32 UTC 2009 waiting_response incoming
120664 response Mon Dec 14 14:53:12 UTC 2009 incoming
120730 followup_sent Mon Dec 14 16:15:04 UTC 2009 internal_review Mon Dec 14 16:15:04 UTC 2009 internal_review outgoing
122905 followup_sent Mon Dec 21 13:55:05 UTC 2009 internal_review Mon Dec 21 13:55:05 UTC 2009 internal_review outgoing
132193 response Mon Jan 18 16:12:37 UTC 2010 internal_review Mon Jan 18 16:30:27 UTC 2010 internal_review incoming
132350 followup_sent Tue Jan 19 10:00:05 UTC 2010 outgoing
135108 followup_sent Tue Jan 26 09:41:51 UTC 2010 outgoing
162856 response Mon Apr 19 14:11:57 UTC 2010 successful Tue Apr 20 20:36:27 UTC 2010 successful incoming

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 WhatDoTheyKnow 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.