Skip to content

SPARQLing Scottish history

Aspects of Scottish history and culture using Wikidata and SPARQL

  • Home
  • Topical Query Resources

Filling empty Wikidata item

The Petscan described here helped diminish the Scotland-related Wikidata items without any properties down to a manageable size. Taking the category query down to a depth of 4 resulted in a Read more
adminAuthor admin Posted on 17 August 2025 Category ScottishCulture Tags Wikidata Petscan

Merry-go-round

From time to time, I have noticed that Wikidata records for Scottish Football teams are often wildly out of date about the manager. Sometimes an item's P286 property has only the name of someone who Read more
adminAuthor admin Posted on 07 July 2025 Category ScottishHistory Tags Wikidata Wikipedia

Canmore Trove

Now that Canmore has been replaced by trove.scot, as previewed here, the result looks unfortunate. Although HES have retained the same index number for items, they have not provided a soft-landing Read more
adminAuthor admin Posted on 25 June 2025 Category ScottishHistory Tags Wikipedia

Public art again

I previously wrote about a tabular query on public art in Scotland which I placed on Wikimedia Commons. While developing more data content, I discovered a Wikidata list/Gallery with creator row Read more
adminAuthor admin Posted on 07 June 2025 Category ScottishCulture Tags WikimediaCommons Listeria

After Canmore

This announcement changes the territory for references common across Wikipedia and Wikidata. In terms of English Wikipedia, there are templated references for both Canmore and HES, which can be Read more
adminAuthor admin Posted on 24 May 2025 Category SPARQL Tags ScottishHistory

Pub crawl

Pub crawl
Seeing in the Wikidata update that CAMRA Pub IDs had now been loaded as an identifier, I queried for those with the ID in Scotland. It is quite a detailed map, with colour-coding often designating Read more
adminAuthor admin Posted on 09 May 2025 Category ScottishInfrastructure Tags Civics

Local museums

Local museums
The Easter weekend is when some volunteer-run local museums in Scotland open for the summer, so I generated a map to see which are on Wikidata This is a clickable map of local and specialist museums Read more
adminAuthor admin Posted on 23 April 2025 Category ScottishCulture Tags Wikidata

Art spaces

After adding Glasgow Sculpture Studio to Wikidata I began looking at the extent to which it contains data items on other arts initiatives in Scotland. The map view is useful for seeing and fixing Read more
adminAuthor admin Posted on 15 April 2025 Category ScottishCulture Tags Wikidata

Filling the gaps

Using Petscan to look for Scotland-related Wikidata items which lack any properties (query link) gave a large number of cases. These were alleviated using Quickstatements to add basic properties: Read more
adminAuthor admin Posted on 07 March 2025 Category ScottishHistory Tags Wikidata Petscan Quickstatements

Small languages vs. large language model churn

The problem of out-of-office email replies from translation services being copy-pasted as the sought translation has been seen in Welsh street signs and Scandinavian hospital signage. Rote Read more
adminAuthor admin Posted on 15 February 2025 Category ScottishCulture Tags Language
« Page 2 of 7 »

About

This blog provides Wikidata and SPARQL views of aspects of Scottish history and culture. These have usually been previously posted to Mastodon (through which comments are welcome).
RSS notification of new posts is available using https://allyd.co.uk/scotdata/feed/rss

Recent posts

  • Tracing epidemics
  • Memory loss
  • Detriment to the built environment
  • Neeps and tatties
  • Disentangle and expand

Archives

  • ▼ 2026 (5)
    • April (2)
    • March (1)
    • January (2)
  • ► 2025 (17)
    • December (1)
    • October (1)
    • September (2)
    • August (2)
    • July (1)
    • June (2)
    • May (2)
    • April (2)
    • March (1)
    • February (2)
    • January (1)
  • ► 2024 (34)
    • December (1)
    • November (5)
    • October (1)
    • September (3)
    • August (1)
    • July (2)
    • June (2)
    • May (2)
    • April (2)
    • March (5)
    • February (6)
    • January (4)
  • ► 2023 (6)
    • December (6)

Categories

  • Fediverse
  • ScottishCulture
  • ScottishHistory
  • ScottishInfrastructure
  • SPARQL
  • Uncategorized
  • Visualisation

Tags

Archiving bot Botsinspace C18 chartscss Civics DataProblems Desktop migration energy-charts Events fediverse food Gaidhlig Glasgow Language Leaflet Listeria map Mastodon migration newspapers OpenStreetMap Petscan Quickstatements ScottishHistory societies SPARQL Wikidata WikimediaCommons Wikipedia
  • Home
  • Topical Query Resources
  • Twitter
SPARQLing Scottish history CC by NC No AI bots - respect robots.txt Powered by HTMLy