Follow this request
There is 1 person following this request
Act on what you've learnt
Similar requests
TRU and TFR data password
To Department of Health by Peter Collingbourne 31 January 2009
Quarterly financial monitoring returns
To Monitor - Independent Regulator of NHS Foundation Trusts by Peter Collingbourne 31 January 2009
FOI & EIR complaints - lack of jurisdiction - not a public authority
To Information Commissioner’s Office by Peter Collingbourne 5 March 2009
Contract with Hospicom for Bedside Services
To King’s College Hospital NHS Foundation Trust by Peter Collingbourne 11 December 2008
Contract with CSC for National ID Scheme
To Identity and Passport Service by Peter Collingbourne 12 May 2009
Unfair terms in EULAs
To Office of Fair Trading by Peter Collingbourne 22 May 2009
Contract with Hospedia for Bedside Services
To The Christie NHS Foundation Trust by Peter Collingbourne 11 December 2008
Pictures on cigarette packets
To Department of Health by Mr Willis 30 January 2009
Contract with Premier Telesolutions for Bedside Services
To Southend University Hospital NHS Foundation Trust by Peter Collingbourne 11 December 2008
Contract with Thales for National ID Scheme
To Identity and Passport Service by Peter Collingbourne 28 November 2008
TFR Spreadsheets
Peter Collingbourne made this Freedom of Information request to Department of Health
The request was partially successful.
From: Peter Collingbourne
11 January 2009
Dear Sir or Madam,
Please disclose the completed TFR financial return spreadsheets
provided by each NHS Trust for the last three financial years
(2007-08, 2006-07, 2005-06).
Pursuant to FOIA section 11(1) I express the preference for you to
provide this information electronically, by email, in the original
(xls) format, or alternatively in a non-proprietary format commonly
used for electronic data exchange (such as csv). However, PDF files
are not acceptable.
Yours faithfully,
Peter Collingbourne
From: Peter Collingbourne
11 January 2009
Dear Sir or Madam,
I wish to withdraw the FOI request made earlier today, 11 January
2008 and substitute it with the following:
According to the "NHS Trust End of Year Letter 2007-08" [1], data
collected from TRU (formerly TAC) and TFR spreadsheets is imported
into a database held by DH. This is evidenced by the following
statement made within the letter: "If this [saving in the correct
format] is not done Quarry House may not be able to open these
files or import them to the database."
I require disclosure, in a non-proprietary electronic format
customarily used for electronic data exchange other than PDF (such
as CSV) of a complete database export from said database of the
database tables containing data collected from TRU (formerly TAC)
and TFR spreadsheets submitted in the financial years 2007-08,
2006-07, 2005-06.
Yours sincerely,
Peter Collingbourne
[1]
http://www.doh.gov.uk/doh/finman.nsf/436...
Department of Health
12 January 2009
Thank you for your enquiry.
We aim to respond within 20 working days.
If there is likely to be any delay we will contact you to let you know.
show quoted sections
Department of Health
12 January 2009
Thank you for your enquiry.
We aim to respond within 20 working days.
If there is likely to be any delay we will contact you to let you know.
show quoted sections
Department of Health
22 January 2009
[1][email address]
DE00000381002
22 January 2009
Dear Mr Collingbourne,
Thank you for your email of 11 January requesting, under the Freedom of
Information Act, data collected from TRU and TFR spreadsheets. Your email
has been passed to me for reply.
I can confirm that the Department holds the information you have
requested. However, the data is being held on a CD due to the size of the
files. I would be grateful if you could respond by 28 January with your
mailing address so that I may forward you the CD by post.
Yours sincerely,
Woraphan Lagkam
Customer Service Centre
Department of Health
show quoted sections
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
References
Visible links
1. mailto:[email address]
Peter Collingbourne left an annotation (30 January 2009)
I have not received anything yet so have resent my address details.
From: Peter Collingbourne
31 January 2009
Your ref: DE00000381002
Dear Sir or Madam,
Please pass this on to the person who conducts Freedom of
Information reviews.
I am writing to request an internal review of Department of
Health's handling of my FOI request 'TFR Spreadsheets'.
I specifically required that you disclose the information in a
non-proprietary format. However the CD I have received contains an
encrypted file, "DE381002.exe". In order to execute this file and
decrypt the contents, it would be necessary to purchase a piece of
proprietary software known as Microsoft Windows. Furthermore, your
letter indicates that Excel spreadsheets are included within the
encrypted file. In order to view these files, it would be necessary
to purchase a piece of proprietary software known as Microsoft
Excel. In summary, your disclosure fails to meet the requirements
of FOIA section 11(1)(a) as you have failed to give effect to the
preferred form of disclosure.
I would furthermore argue that your response does not meet the
requirements of FOIA section 1(1)(b). This section requires that
the information be "communicated" to myself, but because I am
unable to decrypt and therefore access the information requested,
the information has not been "communicated" to me. I do not intend
to contact the individuals you have mentioned in your response
letter in order to obtain the password, as it is not a requirement
for me to do anything other than make a single request for
information to you (see FOIA section 1(1)).
A full history of my FOI request and all correspondence is
available on the Internet at this address:
http://www.whatdotheyknow.com/request/tf...
Yours sincerely,
Peter Collingbourne
Peter Collingbourne left an annotation (31 January 2009)
I made another FOI request asking for the password: http://www.whatdotheyknow.com/request/tr...
Francis Irving left an annotation ( 3 February 2009)
Peter has sent WhatDoTheyknow the two files that were included on the CD that was posted to him. We've uploaded them into our archive.
There is the PDF:
http://www.whatdotheyknow.com/files/requ...
And the Microsoft Windows executable:
http://www.whatdotheyknow.com/files/requ...
Department of Health
5 February 2009
Dear Mr Collinbourne,
Thank you for letter of 31 January 2009 requesting a review of the above
case. The review is underway and we will respond to you within 20 working
days.
Yours sincerely
Sarah Otto
Freedom of Information Unit
Information Services
E-mail: [email address]
Address: Department of Health | Room 334B Skipton House | 80 London Road |
London SE1 6LH
- - Disclaimer - -
This e-mail and any files transmitted with it are confidential. If you are
not the intended recipient, any reading, printing, storage, disclosure,
copying or any other action taken in respect of this e-mail is prohibited
and may be unlawful. If you are not the intended recipient, please notify
the sender immediately by using the reply function and then permanently
delete what you have received.
Incoming and outgoing e-mail messages are routinely monitored for
compliance with the Department of Health's policy on the use of electronic
communications. For more information on the Department of Health's e-mail
policy click here http://www.dh.gov.uk/terms
show quoted sections
From: Peter Collingbourne
10 February 2009
Your ref: DE00000381002
Dear Woraphan Lagkam,
Having now had the opportunity to examine the Department's
disclosure in detail, I note that a small amount of information
appears to be missing from the disclosure, namely the content of
any "freetext" fields. Please ensure that this information is
supplied by return as soon as possible. I would also like the
ongoing internal review to consider the fact that I was not
initially provided with this information.
Yours sincerely,
Peter Collingbourne
Department of Health
10 February 2009
Thank you for your enquiry.
We aim to respond within 20 working days.
If there is likely to be any delay we will contact you to let you know.
show quoted sections
Department of Health
24 February 2009
Email Content stored in attached file 'Long_Email_Body_24_02_2009.html'.
show quoted sections
Communications via the GSi may be automatically logged, monitored and/or
recorded for legal purposes.
Department of Health
24 February 2009
Dear Mr Collingbourne,
We are close to finalising our reply to your request for an internal review
of FOI case 381002.
We are proposing to send the reply to you in pdf format. Could you please
confirm whether this is acceptable or if there is any other format you
would prefer us to use?
Thankyou,
Lynwen Paddy
Librarian FOI Unit
Information Services
Direct Line: 0207 9721121
Email: [email address]
Address: Department of Health | Room 330B Skipton House | 80 London Road |
London SE1 6LE
P Save energy - shut down your PC & switch off your monitor every night.
- - Disclaimer - -
This e-mail and any files transmitted with it are confidential. If you are
not the intended recipient, any reading, printing, storage, disclosure,
copying or any other action taken in respect of this e-mail is prohibited
and may be unlawful. If you are not the intended recipient, please notify
the sender immediately by using the reply function and then permanently
delete what you have received.
Incoming and outgoing e-mail messages are routinely monitored for
compliance with the Department of Health's policy on the use of electronic
communications. For more information on the Department of Health's e-mail
policy click here http://www.dh.gov.uk/terms
show quoted sections
From: Peter Collingbourne
24 February 2009
Dear Lynwen Paddy,
pdf is fine.
Yours sincerely,
Peter Collingbourne
Department of Health
3 March 2009
Dear Mr Collingbourne,
Please find attached our reply to your request for an internal review of
FOI case 381002.
(See attached file: 381002Rreply3march.pdf)
(See attached file: 381002Rreplyannexa.pdf)
Thankyou,
Lynwen Paddy
Librarian FOI Unit
Information Services
Email: [email address]
Address: Department of Health | Room 330B Skipton House | 80 London Road |
London SE1 6LE
- - Disclaimer - -
This e-mail and any files transmitted with it are confidential. If you are
not the intended recipient, any reading, printing, storage, disclosure,
copying or any other action taken in respect of this e-mail is prohibited
and may be unlawful. If you are not the intended recipient, please notify
the sender immediately by using the reply function and then permanently
delete what you have received.
Incoming and outgoing e-mail messages are routinely monitored for
compliance with the Department of Health's policy on the use of electronic
communications. For more information on the Department of Health's e-mail
policy click here http://www.dh.gov.uk/terms
show quoted sections
Francis Irving left an annotation ( 6 March 2009)
Peter has decrypted the data, and you can download it as a zip file here:
http://www.whatdotheyknow.com/files/requ...
Things to do with this request
- Add an annotation (to help the requester or others)
- Download a zip file of all correspondence
Make and explore Freedom of Information requests






Peter Collingbourne left an annotation (22 January 2009)
Link to this