Open Prescribing Scotland

The aim of this project is to create an easy-to-use web interface to prescribing data in Scotland.

Deployment

The web application is deployed on Render!
Please click this link to access: https://open-prescribing-scotland.onrender.com/

Datasets

The relevant datasets are:

• Prescribing Data:

  • HBT
  • GPPractice
  • BNFItemCode
  • BNFItemDescription
  • PaidDate
  • ClassOfPreparationCode
  • NumberOfPaidItems
  • PaidQuantity
  • GrossIngredientCost
  • PaidDate

• Glossary of Terms

• Health Boards with their corresponding name and the country code for Scotland

• GP Practices Contact Details and List Sizes

Project Setup

This webpage requires Python3 and uses the webframework Django.

Download python from https://www.python.org/downloads/.

As a suggestion, to install python from the terminal use:

sudo apt-get update
sudo apt-get install python3.8

Python dependencies are managed via pip. It is however advised to install those dependencies into an virtual environment. This can be created with:

python3 -m venv venv

To activate the environment use:

source venv/bin/activate

This needs to be done in every shell that should use our newly created environment.

We suggest installing the Python dependencies from the openprescribingscotland folder through the requirements.txt file:

pip install -r requirements.txt

Once the repository is cloned, the Django Webserver can be started with:

python manage.py runserver