Spreadsheets

[DoctorStrangelove]

I just learnt today - according to the Prime Minister - that a manual error isn't also an excel error.

Did the PM ever have a job?

He's certainly been sacked a lot.

Oddly enough, only sometimes for lying.

 

[Old Greg]

He's certainly been sacked a lot.

Oddly enough, only sometimes for lying.

Unless he's lying about what the other reasons were.

 

[mallisarealperson]

So if it was Serco that was processing the results of the test/s using excel.

What information was contained in that data set?

I am assuming person name, nhs number, dob, test result, dates etc. What else.

And where in the world did it go? I hope it stayed in the UK? SC cleared personnel.

I think maybe a public enquiry might help.

Complete ##### mess.

 

[Old Greg]

So if it was Serco that was processing the results of the test/s using excel.

What information was contained in that data set?

I am assuming person name, nhs number, dob, test result, dates etc. What else.

And where in the world did it go? I hope it stayed in the UK? SC cleared personnel.

I think maybe a public enquiry might help.

Complete ##### mess.

My guess:

First name
Surname
DoB
Gender
Mobile phone no.
Possibly address
NHS No
Other random IDs
Request date
Requesting clinician
Location of care if relevant
Test date
Test location
Laboratory ID
Result date
Result

 

[fullyautomatix]

So if it was Serco that was processing the results of the test/s using excel.

What information was contained in that data set?

I am assuming person name, nhs number, dob, test result, dates etc. What else.

And where in the world did it go? I hope it stayed in the UK? SC cleared personnel.

I think maybe a public enquiry might help.

Complete ##### mess.

All this data protection and privacy gooble de kook does not apply to the government, its just red tape for the private companies.

 

[Old Greg]

All this data protection and privacy gooble de kook does not apply to the government, its just red tape for the private companies.

That's nonsense.

 

[WTFH]

My guess:

First name
Surname
DoB
Gender
Priority
Risk Group
Mobile phone no.
NHS App Installed? Y/N
Possibly address
Post Code
NHS No
Other random IDs: Last check in(s) prior to test
Request date
Requesting clinician
Location of care if relevant
Test date
Test location
Laboratory ID
Result date
Result

Good guesses.

 

[SueEllen]

All this data protection and privacy gooble de kook does not apply to the government, its just red tape for the private companies.

Lose a government laptop with a spreadsheet on it with people's names and addresses and find out.

 

[NotAllThere]

The cool kids use XML now

Or zipped XML. Like XLSX...

 

[minestrone]

The land registry download is a 3.7 gig CSV.

It's a delight to work with a flat file that size.