Using the opendata.scot data

Metadata for datasets listed on opendata.scot can be accessed in

Some variable names are different between the two versions but the content is the same

Daily JSON file dumps of our Analytics data can be accessed at https://github.com/OpenDataScotland/opendata.scot_analytics

To learn more about how the data is processed see the Tools & Tech section of our Wiki


Projects using Open Data - Scotland

Travelling Tabby Scotland Coronavirus Tracker

https://www.travellingtabby.com/scotland-coronavirus-tracker/local

source data: Public Health Scotland

John is a student at the University of the Highlands and Islands (Argyll College) and made a very useful dashboard over lockdown which has been very successfully received and relied on by thousands of individuals. This is a very well-laid project and the section on additional information at the bottom of the dashboard is well worth a visit on its own.

Street Art Aberdeen

https://streetartaberdeen.org/

A collaborative project created by Andy Gaskell which collects and display locations of street art in Aberdeen, helping the public find the artworks so they can be appreciated as they were intended - in real life

The Courier: King David and the death of Karen: Scotland’s baby name trends for past 50 years

https://www.thecourier.co.uk/fp/courier-investigations/3135287/baby-names-scotland/

source data: National Records Scotland/ The Courier Github Repo

An excellent (and entertaining) example of data storytelling by the data team at The Courier

Interactive SIMD Map

https://simd.scot/#/simd2016/BTTTFTT/9/-4.0000/55.9000/

source data: Scottish Government

Explore the Scottish Index of Multiple Deprivation (SIMD) for 2012, 2016 and 2020 by geography. Map created and maintained by Scottish Government.

SIMD Visualised by Local Authority

https://twitter.com/northernjamie/status/1225484162263547905?s=21

source data: Scottish Government

A effective and eye-catching single-page visual by Jamie Whyte displaying the distribution of the deprivation index, within and across Local Authorities

Survey of Scottish Witchcraft (1563 - 1736)

http://www.shca.ed.ac.uk/Research/witches/

source data: Wikidata

A queryable database of all indicviduals in Scotland accused of Witchcraft, compiled by researchers at Edinburgh University, and using data stored in Wikidata.

Aberdeen Harbour Ship Arrivals 1914 to 1920

https://community.powerbi.com/t5/Data-Stories-Gallery/Aberdeen-Harbour-Ship-Arrivals-1914-to-1920/m-p/1993897

source data: Aberdeen City and Aberdeenshire Archives

A community project which transcribed historical physical records from Aberdeen Harbour 1914-1920 into digital data, then visualised in PowerBI for the public to explore and use.

Data Commons Scotland

https://campuspress.stir.ac.uk/datacommonsscotland

Running out of the University of Stirling, the Data Commons Scotland project is protoyping an open data sharing platform, starting with open data related to waste management and processing in Scotland

ALISS (A Local Information System for Scotland)

https://www.aliss.org/

An information service in Scotland for people living with long term conditions, disabled people and unpaid carers.

Scotmaps

https://fozy81.github.io/scotmaps/index.html

source data: Scottish Government

An R package of spatial map layers for Scotland. Provides access to various spatial layers of Scotland, such as administrative boundaries, natural resource management boundaries etc.

Data Science Scotland

https://github.com/DataScienceScotland

Github repos for analysts across Scotland’s public sector to code and collaborate in the open


Projects using Open Data - Worldwide

Open Waste Map (UK)

https://openwastemap.uk/

OpenWasteMap is a web app which uses data from OpenStreetMap to display recycling centre locations, their accepted materials, materials specifically banned, and opening hours.

Democracy Club

https://democracyclub.org.uk/projects/

source data: community curated and scraped

Decocracy Club provide a number of tools, via website and APIs to make voting and the electoral process easier. They have a large, and active, userbase who crowd-source data on candidates, election, and where to vote.

Sensor.Community (formerly Luftdaten) (Worldwide)

https://sensor.community/en/

A citizen-science project using sensors to collect data about air quality around the world. The community is headquartered in Germany but with sensors worlwide including some maintained by the Air Aberdeen group

Open Plaques (UK)

https://openplaques.org/

Documenting the historical links between people and places as recorded by commemorative plaques

Marine Debris Tracker (Worldwide)

https://www.debristracker.org/data

An open data citizen scientist movement collecting and sharing data on marine debris around the world

Open Benches (Worldwide)

https://openbenches.org/#54.97364/-8.076762/5

A site dedicated to memorial benches, snap, share and browse around the world

Gender Pay Gap Bot (UK)

https://genderpaygap.app/ and Twitter @PayGapApp

source data: https://gender-pay-gap.service.gov.uk/

This twitter bot created by Francesca Lawson and Ali Fensome caused a frenzy on International Womens Day 2022, creating both awareness and real impact as many organisations scrambled to react to being called out for their pay gaps. Read about the story on Yahoo News

Visual Maps of UK's 2020 Rainfall, Sunshine and Temperature (UK)

https://twitter.com/owenboswarva/status/1515034983852916741?s=20&t=juYQOf2XFP5kkYpRC71xAQ

source data: Met Office

3 examples of cartographic visuals (maps) created by Owen Boswarva

Open Data Daily (Norway)

https://opendata.no/#/tag-opendata

source data: Various

A collection of daily media around Open Data

UK Government on WikiData (UK)

https://www.wikidata.org/wiki/Wikidata:WikiProject_Govdirectory/United_Kingdom

Listing of UK Government entities in WikiData

DataPortals.org (Worldwide)

http://dataportals.org/

A comprehensive list of open data portals from around the world


Using Open Data


Other resources