Posts tagged Wikidata - SPARQLing Scottish history

Capital punishment

Adjusting the Wikidata records for those executed after the 1820 Radical War led me to a broader query on the grim topic of people in Scotland who were subjected to judicial killing. Here is a map Read more

Rail disasters

The Wikipedia article about Wormit station mentioned a rail crash there in 1955. I looked at other crash articles and their corresponding Wikidata items to obtain the data items appropriate for one Read more

Sundials

There is a Wikipedia page here which indicates that sundials in Scotland had features distinct from those elsewhere. Here is a query which maps sundials across the country. Read more

Paintings in Scottish galleries

I remembered a page I previously created on Commons, which provides a view of paintings in Scottish public galleries: link. It is based on a Wikidata SPARQL query, which ListeriaBot runs every few Read more

Industrial past

From the 1750s until around 40 years ago, Scotland was marked by clusters of iron, steel and manufacturing heavy industries. Little remains. Attempting to map these using Wikidata and SPARQL shows Read more

Scottish foods (again)

Since my previous post and graphic about Scottish foodstuffs, I noticed that Camp Coffee was missing - and having noticed that, realised that Irn Bru was also missing. Such important parts of the Read more

Tolbooths

Last July I looked at Tolbooths in Scottish towns, including some Wikidata adjustments to distinguish them, as the data had become fankled with Tollbooths, which are not the same thing. I posted this Read more

Co-operative societies

Attempting to visualise how Co-operative Societies spread then consolidated through the 19th and 20th centuries was only partially successful. The data available were rather lacking. For example, Read more

Observatories

Another visualisation using Wikidata to show aspects of Scottish Culture. This map highlights the various Observatory buildings around Scotland. Query Read more

Road and railway bridges

A SPARQL query to map category A & B listed road and rail bridges in Scotland: SELECT DISTINCT (?showLabel as ?layer) ?loc ?pic ?picLabel ?picURI ?herlistLabel ?cooncilLabel WHERE { SERVICE Read more