How the BBC put together the full Murrell shopping listpublished at 11:45 BST
Aimee Stanton
BBC Scotland Data Visualisation team
BBC Scotland's data and visual journalism team sifted through more than 1,000 entries on Peter Murrell's charge sheet to build our own database of his spending habits.
This data-heavy project meant removing hundreds of purchases from a breakdown of the original charge where both defence and prosecution had agreed they were not part of the financial fraud.
We then categorised each entry into a theme, for example home-related buys or food and drink.
Once the database was complete, we were able to build a searchable table to show what Murrell bought, when he bought it and where from.
It also meant we could analyse his spending habits - we looked at purchases around key dates such as birthdays, Christmases and the Covid pandemic, as well as annual trends, price bands, and significant buys.
You can read the full analysis here.












