Skip to content

SPARQLing Scottish history

Aspects of Scottish history and culture using Wikidata and SPARQL

  • Home
  • Topical Query Resources

Tag: SPARQL

Tracing epidemics

Adding basic Wikidata info for "Edinburgh plague of 1585" got me looking at the level of data for other infectious outbreaks, and finding it a wee bit bare. Even the relatively recent "1964 Aberdeen Read more
adminAuthor admin Posted on 19 April 2026 Category ScottishHistory Tags Wikidata SPARQL

Hydro-electric and wind power stations

Hydro-electric and wind power stations
I began looking at the Wikidata information on hydro-electric power stations, whose development was a feature of 20th century Scotland. Some of the date information is scant, and some is Read more
adminAuthor admin Posted on 25 September 2024 Category ScottishInfrastructure Tags Wikidata SPARQL energy-charts OpenStreetMap

Industrial past

Seeking the extent to which Wikidata holds location traces of industrial locations (factories, mills, energy centres, distribution points), while trying to separate slightly from the HES Listed Read more
adminAuthor admin Posted on 28 May 2024 Category ScottishHistory Tags SPARQL

Theatre groups and people

Theatre groups and people
Attempting to diagram theatre groups, with their founders and associated people where these can be identified. Still a work-in-progress. It may be that once more data are populated, this view becomes Read more
adminAuthor admin Posted on 08 May 2024 Category ScottishCulture Tags SPARQL Civics

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
adminAuthor admin Posted on 08 April 2024 Category ScottishHistory Tags Events ScottishHistory Wikidata SPARQL

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
adminAuthor admin Posted on 24 March 2024 Category ScottishHistory Tags SPARQL Wikidata map

Industrial past

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
adminAuthor admin Posted on 13 March 2024 Category ScottishHistory Tags SPARQL Wikidata map DataProblems

Scottish foods (again)

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
adminAuthor admin Posted on 07 March 2024 Category ScottishCulture Tags Wikidata SPARQL food

Co-operative societies

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
adminAuthor admin Posted on 27 February 2024 Category ScottishHistory Tags SPARQL Wikidata Wikipedia Civics

Observatories

Observatories
Another visualisation using Wikidata to show aspects of Scottish Culture. This map highlights the various Observatory buildings around Scotland. Query Read more
adminAuthor admin Posted on 19 February 2024 Category ScottishHistory Tags SPARQL Wikidata Civics map
Page 1 of 3 ยป

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