Details of request 'Schema for COINS database'

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
123675	sent	Wed Dec 23 12:41:44 UTC 2009	waiting_response	Wed Dec 23 12:41:44 UTC 2009	waiting_response	outgoing
124898	response	Thu Dec 31 11:18:00 UTC 2009	waiting_response	Mon Jan 04 16:04:52 UTC 2010	waiting_response	incoming
134982	response	Mon Jan 25 21:24:27 UTC 2010	not_held	Fri Apr 09 10:16:13 UTC 2010	partially_successful	incoming
135615	comment	Wed Jan 27 08:59:22 UTC 2010
149847	comment	Wed Mar 10 00:32:17 UTC 2010
159014	comment	Wed Apr 07 16:16:42 UTC 2010	partially_successful
161355	comment	Wed Apr 14 15:16:53 UTC 2010

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.