We also mapped out the known addresses to allow readers to find personal connections to the past sacrifices.

But the above shows only a portion of the 1,883 people who died in Dundee. Each poppy represents a name on the Second World War honour roll, shown alphabetically. The poppy size indicates year of death and the stem length shows the age. #dataviz #datajournalism

The 80th anniversary of VE Day is around the corner - so it is a good time to pay respect to the sacrifice of thousands of men and women in the Second World War. I took a look at roll of honour data for Dundee and Aberdeen. To emphasise the scale of loss I built a memorial garden using D3.js

"You must comprehend a great deal in your idea of an accomplished woman,” Jane Austen wrote in 1813 and I feel that sentiment persists. That is why I chose to use embroidery - deemed simply "fancy work" during Jane Austen's time despite often taking a lot more skill than this simple #dataviz

I decided to join this month's Journal Dataviz Challenge and visualise the Women in The Nobel Prize with a slightly different format. Each pair of petals represents a single woman who won the prize from 1901 to 2024. The more women winning a year, the flower grows fuller. #dataviz

🎼Or which pop girlie has sung her way into the hearts of recent parents?
Read the full story including the list of all names used in Scotland in 2024: www.thecourier.co.uk/fp/news/5204...

Olivia is back to the top of the list of baby names for girls in Scotland - for the seventh time. Scotland's annual baby name data has been released for 2024 and we dove into the naming trends, including...
📉Is it the end of the line for Colin?
📈Maeve hits the trends list
#ddj #datajournalism

The article also takes a closer look at how many crashes happen in rural versus urban sections of the road. Once again QGIS was use to find all the crashes overlapping with or immediately adjacent to settlements defined by Scottish Government Spatial Data on Localities. 3/4

The heatmap is based on the density of crashes within a one-kilometre radius. Larger numbers or more closely clustered crashes within that radius appear with a darker shade, like this one found near Morgan McVeighs restaurant in Insch with three crashes. 2/4 #ddj #datajournalism

We have analysed when crashes happen on the A96, but today we want to provide a better answer for the question of where they happen. Using QGIS I created a heatmap along the road from Aberdeen to Inverness showing clustered accident blackspots. 1/4 #dataviz

Fourteen fatal crashes, 89 serious crashes and 76 slight collisions. That is the breakdown of the 179 accidents on the A96 between 2019 and 2023 as we launch our latest investigation. Throughout the week we will have exclusive analysis on the road running between Aberdeen & Inverness. #dataviz 1/3

But what about Hogmanay itself? A station in Orkney comes first with 49mm in a single day. The map below shows all the stations that had more than 30mm of rain on Hogmanay. I used R to access and compare the data for all stations on the SEPA API.

We have a racquet heatmap, tennis ball scatter plots, hand drawn Top Trump cards of his top competitors, and a court Sankey - in other words we needed to showcase the UK tennis legend's career in style and we, like Andy, brought our A game. #dataviz #tennis #ddj

After a 19-year career, Andy Murray officially retired this year and we could think of no better way to celebrate his legacy but through #dataviz. So from his rise through the ranks to world No 1 to the speed of his serve, we look at the data on his achievements #AndyMurray.

Some hand drawn #dataviz I made in October📊 . The sun will set in Glasgow at 3.45pm today but we are in the last stretch of the nights getting longer. In just over two weeks the minutes of light will start to creep up again ☀

As we look at the changes over the course of the year, we decided to focus on the two most occupied streets - George Street and St John's Place. The latter has remained fully occupied the entire year. #dataviz

We have been tracking Perth's high streets for a year now. But how has the Fair City changed over the course of 12 months? The average vacancy rate in Perth increased slightly since 2023, but fell or remained at 0% for five out of nine tracked streets. #dataviz #ddj #datajournalism

Our care home and childcare trackers have recently been updated with the latest data. We analyse the grades of hundreds of care services to allow readers to evaluate services in their area. #ddj #dataviz