Week 5 was extremely fast with my university graduation in the middle of the week and having lots of small tasks to do. However, a large amount of progress has still been made with the project. By the end of this week I now have the location for over 3000 accused witches recorded on the Wikidata Query Map.

View the basic map with genders here: https://w.wiki/5Kf.

Narrowing down the list of unfound places

Last week I contacted the Scottish Place-Names Society in the hope that they would be able to offer some advice on my unfound locations of accused witches residence. The society replied almost instantly with an interest in the project. Members of the society used the sources of Gilbert Márkus, The place-names of Bute (2012) (which directly mentions the recorded place names from historical records about witches) and local knowledge to help narrow down my list. While I have had other helpers using sources such as The Berwickshire Place-Names Resource to also aid in reducing the unfound places list. I now have just 84 places to be found!

Uploading new settlement entries onto Wikidata

An issue with Wikidata is that it is still a working progress with many settlements and people yet to be added to Wikidata. Therefore, I had to add many of the accused witches’ residence locations as new items on Wikidata so that the coordinate location and place name could be recorded on Wikidata. These locations can be added manually as new items onto Wikidata with a description and coordinate location which is a relatively fast process. However, as there were 100 new items that had to be created for these items I decided that a bulk upload would be easier using Google Sheets and QuickStatements. I received help in this process by Navino Evans (co-founder of Histropedia) which made the upload a lot easier.

I found that this link was useful at helping explain how to add information in bulk to Wikidata with QuickStatements.

The power of OpenRefine

Now that I had all of the found locations of the accused witches residences uploaded onto Wikidata, I was then ready to establish the connection between the accused witches and their geographical residence location on Wikidata. I plan to  then upload the locations of the unfound places as they are uploaded in the future.

I had received a tutorial in using OpenRefine last week but now it was my chance to put these now skills into practice and try to upload my data into Wikidata using this new software.

OpenRefine is an open sourced software which can be used to manipulate spreadsheets and the online aspect of the software makes it very useful for adding data to Wikidata.

I thought that the process of using OpenRefine would benefit from being a separate post so expect a tutorial on using OpenRefine soon!

Adding accused witches location into Wikidata

Although the full dataset of accused witches residency is not yet complete, it seemed time to add the point locations onto Wikidata for the accused witches. This allowed for the upload of the residence location for 3025 accused witches which is the majority of the witches mentioned in the Scottish Witchcraft Database. Each one of the accused witches residency is also referenced to their database page on the Scottish Witchcraft Database website making a simple link between the map and the original database.

As a result of this upload there is now a wealth of geographical information about the accused witches. This is the first time that this amount of geographical information has been located for the accused Scottish witches!

I was then able to use the Wikidata Query Service to write a query which would show the residence of each accused witch in Scotland. This allowed for all 3025 accused witches residence to appear on a map of Scotland which is amazing for being able to visualise accusations of witchcraft over this period.

See the map here: https://w.wiki/5Kf.

The next step is to play with query service to understand the different ways to display this data and what other useful data can be added to enrich the data.