Skip to content

Prescribing

Summary

Abstract

Community-dispensed primary care prescription data.

Keywords

Publisher

  • Name
    Health Informatics Centre - University of Dundee
  • Logo

    Not available

  • Description
    Not available
  • Contact point
    Not available

Documentation

Description

Primary care prescriptions for patients in the Tayside and Fife regions in Scotland. The data contains granular information such as drug strength, unit and dose. Tayside 1989 – Current; Fife 2009 – onwards. The data is coded using the BNF standard but can also be provided with SNOMED/DM+D codes, or in the OMOP format.

Coverage

Spatial

  • Spatial coverage

    United Kingdom, Scotland, Tayside Region, United Kingdom, Scotland, Fife

  • Geographic levels
    Not available

Temporal

  • Start date
    01/01/1988
  • End date
    Not available
  • Frequency
    Irregular
  • Distribution release date
    01/07/2021

Provenance

  • Purpose
    Care
  • Source
    Epr
  • Collection situation
    Primary care - Clinic

Access and governance

  • Conditions of access
    General research use

Requesting access to this data

This is a secure dataset that can only be accessed by researchers from approved organisations.

Find out how to apply to access this dataset

Usage

  • Conditions of use
    Disclosure control
  • Resource creator
    NHS Tayside and fife
  • Is referenced by
    Not available

Access

  • Access rights
  • Access service
    HIC has implemented a remote-access Trusted Research Environment to protect data confidentiality, satisfy public concerns about data loss and reassure Data Controllers about HIC’s secure management and processing of their data. Data is not released externally to data users for analysis on their own computers but placed on a server at HIC, within a restricted, secure IT environment, where the data user is given secure remote access to carry out their analysis. Full details are available via the following link: https://www.dundee.ac.uk/hic/safe-haven
  • Jurisdiction
    GB-SCT
  • Data controller
    Local NHS boards
  • Data processor
    University of Dundee, Health Informatics Centre

Format and standards

  • Language
    English
  • Format
    Csv, database

Enrichment and linkage

  • Related datasets
    • Not available
  • Linkage opportunity
    Not available
  • Tools
    • Not available

Synthetic data

Synthetic data is not yet available for this dataset. 

Technical information

A JSON file is available with further technical information. This can include details of variables and data classes contained in the dataset.

Preview of JSON file

{
  "summary": {
    "title": "Prescribing",
    "abstract": "Community-dispensed primary care prescription data.",
    "keywords": "medicine;,;Prescribing;,;Prescriptions;,;drugs;,;Scotland;,;Tayside;,;Fife;,;HIC",
    "publisher": {
      "name": "Health Informatics Centre - University of Dundee",
      "gatewayId": "5baa31c1-0280-4482-b8b7-a4953869f184"
    },
    "inPipeline": "Not available",
    "shortTitle": "Prescribing",
    "datasetType": "Health and disease",
    "description": "Primary care prescriptions for patients in the Tayside and Fife regions in Scotland. The data contains granular information such as drug strength, unit and dose.\nTayside 1989 – Current; Fife 2009 – onwards.\nThe data is coded using the BNF standard but can also be provided with SNOMED/DM+D codes, or in the OMOP format.",
    "contactPoint": "hicsupport@dundee.ac.uk",
    "datasetSubType": "Not applicable",
    "populationSize": 1431000
  },
  "coverage": {
    "pathway": "Primary care prescription data limited to Tayside and Fife regions in Scotland only.",
    "spatial": "United Kingdom,Scotland,Tayside Region;,;United Kingdom,Scotland,Fife",
    "followUp": "Unknown",
    "typicalAgeRange": "0-150"
  },
  "required": {
    "issued": "2024-10-08T11:28:28.524771Z",
    "version": "4.0.0",
    "modified": "2024-10-08T11:28:28.524785Z",
    "gatewayId": "104",
    "revisions": [
      {
        "url": "https://web.prod.hdruk.cloud//dataset/104?version=1.0.0",
        "version": "1.0.0"
      }
    ],
    "gatewayPid": "4fa734bf-64dc-44f0-ba1f-0176d371dd03"
  },
  "provenance": {
    "origin": {
      "source": "EPR",
      "purpose": "Care",
      "imageContrast": "Not stated",
      "collectionSituation": "Primary care - Clinic"
    },
    "temporal": {
      "timeLag": "2-6 months",
      "startDate": "1988-01-01",
      "accrualPeriodicity": "Irregular",
      "distributionReleaseDate": "2021-07-01"
    }
  },
  "observations": [
    {
      "observedNode": "Persons",
      "measuredValue": 1431000,
      "observationDate": "2021-11-12",
      "measuredProperty": "Prescriptions",
      "disambiguatingDescription": "1,431,000 patients in the dataset"
    },
    {
      "observedNode": "Events",
      "measuredValue": 246630000,
      "observationDate": "2021-11-12",
      "measuredProperty": "Count",
      "disambiguatingDescription": "246,630,000 records in the dataset"
    }
  ],
  "accessibility": {
    "usage": {
      "resourceCreator": {
        "name": "NHS Tayside and fife"
      },
      "dataUseLimitation": "General research use",
      "dataUseRequirement": "Disclosure control"
    },
    "access": {
      "accessRights": "https://www.dundee.ac.uk/hic/governance-service",
      "jurisdiction": "GB-SCT",
      "accessService": "HIC has implemented a remote-access Trusted Research Environment to protect data confidentiality, satisfy public concerns about data loss and reassure Data Controllers about HIC’s secure management and processing of their data.\n\nData is not released externally to data users for analysis on their own computers but placed on a server at HIC, within a restricted, secure IT environment, where the data user is given secure remote access to carry out their analysis.\n\nFull details are available via the following link:\nhttps://www.dundee.ac.uk/hic/safe-haven",
      "dataProcessor": "University of Dundee, Health Informatics Centre",
      "dataController": "Local NHS boards",
      "deliveryLeadTime": "2-4 weeks",
      "accessRequestCost": "Quotation available on request",
      "accessServiceCategory": "TRE/SDE"
    },
    "formatAndStandards": {
      "formats": "CSV;,;Database",
      "languages": "en",
      "vocabularyEncodingSchemes": "LOCAL"
    }
  },
  "structuralMetadata": [
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "CHI",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "SCAN_REF_NO",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "corrected_PRESCRIBED_DATE",
          "dataType": "datetime",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "hb_code",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "directions",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "FRM_ID",
          "dataType": "int",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "hic_validFrom",
          "dataType": "datetime",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "PRESCRIBED_DATE",
          "dataType": "datetime",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "no_of_packs",
          "dataType": "int",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "dataMonth",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "quantity",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "FT_CODE",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "res_seqno",
          "dataType": "int",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "dtUpdated",
          "dataType": "datetime",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "PRESCRIBER_CODE",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "age",
          "dataType": "int",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "script_id",
          "dataType": "int",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "dtCreated",
          "dataType": "datetime",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "ANOCHI",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "Pharmacy",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "id",
          "dataType": "int",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Scripts",
      "columns": [
        {
          "name": "line_no",
          "dataType": "int",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Scripts'"
    },
    {
      "name": "dbo.BO_Item",
      "columns": [
        {
          "name": "Approved_Name",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Item'"
    },
    {
      "name": "dbo.BO_Item",
      "columns": [
        {
          "name": "BNF_Code",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Item'"
    },
    {
      "name": "dbo.BO_Item",
      "columns": [
        {
          "name": "formatted_BNF_Code",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Item'"
    },
    {
      "name": "dbo.BO_Item",
      "columns": [
        {
          "name": "BNF_Description",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Item'"
    },
    {
      "name": "dbo.BO_Item",
      "columns": [
        {
          "name": "res_seqno",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Item'"
    },
    {
      "name": "dbo.BO_Item",
      "columns": [
        {
          "name": "orig_strength",
          "dataType": "numeric",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Item'"
    },
    {
      "name": "dbo.BO_Item",
      "columns": [
        {
          "name": "Name",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Item'"
    },
    {
      "name": "dbo.BO_Item",
      "columns": [
        {
          "name": "measure_code",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Item'"
    },
    {
      "name": "dbo.BO_Item",
      "columns": [
        {
          "name": "Formulation_code",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Item'"
    },
    {
      "name": "dbo.BO_Item",
      "columns": [
        {
          "name": "Strength",
          "dataType": "varchar",
          "sensitive": false
        }
      ],
      "description": "This class was created from the White Rabbit profile data in 'dbo.BO_Item'"
    }
  ]
}

Copied to clipboard