Scotland Accident and Emergency

Preview of JSON file

{
  "required": {
    "gatewayId": "82",
    "gatewayPid": "b7c41ee3-3504-49e7-9916-0518e2a3f663",
    "issued": "2024-10-08T11:28:21.108Z",
    "modified": "2024-10-08T11:28:21.108Z",
    "version": "5.0.0",
    "revisions": [
      {
        "version": "5.0.0",
        "url": "https://healthdatagateway.org//dataset/82?version=5.0.0"
      }
    ]
  },
  "summary": {
    "abstract": "This dataset includes data items from the national A&E DataMart, the Community Health Index (CHI) database and derived chronic conditions items based on linked hospital admissions data",
    "contactPoint": "phs.edris@phs.scot",
    "keywords": "Accident & Emergency",
    "datasetType": "Health and disease",
    "datasetSubType": "Not applicable",
    "populationSize": -1,
    "description": "The A&E datamart was established in June 2007 to monitor the compliance of each NHS Board against the 4 hour wait standard. In July 2010 the A&E data mart was extended further to collect items such as diagnosis, several injury fields and an alcohol involved flag, which will be used to identify whether the patient’s alcohol consumption was a factor in the attendance. The collection of the new fields has been driven by a variety of SG policy decisions and interest from a number of organisations. Although there is now the facility to submit these additional fields, completeness and quality of the data is generally poor and further development is needed to improve it. There are two types of data submitted to the A&E datamart: episode and aggregate level data. All hospitals with Emergency Departments submit episode level data containing a detailed record for each patient attendance. Some smaller sites with minor injury units or community hospitals only submit aggregate files containing monthly summary attendance and compliance figures only. This is because they do not have the information systems and support to enable collection of detailed patient based information. Sites that submit episode level data account for around 97% of all attendances at A&E. This linked version of the dataset includes only A&E data submitted at episode level.  Additional items are included to enable further analysis: chronic conditions flags, based on historic hospital admissions data; a care home flag derived from the CHI database",
    "shortTitle": "Scotland Accident and Emergency",
    "title": "Scotland Accident and Emergency",
    "publisher": {
      "name": "Public Health Scotland",
      "gatewayId": "07"
    },
    "inPipeline": "Available"
  },
  "coverage": {
    "pathway": "Secondary care data only",
    "spatial": "United Kingdom,Scotland",
    "followUp": "Other",
    "typicalAgeRange": "0-150",
    "datasetCompleteness": "https://publichealthscotland.scot/our-areas-of-work/acute-and-emergency-services/urgent-and-unscheduled-care/accident-and-emergency/metadata/data-quality/"
  },
  "provenance": {
    "origin": {
      "purpose": "Care",
      "collectionSituation": "Secondary care - Accident and Emergency",
      "imageContrast": "Not stated"
    },
    "temporal": {
      "startDate": "2011-01-01T22:00:00Z",
      "timeLag": "1-2 months",
      "accrualPeriodicity": "Monthly",
      "distributionReleaseDate": "2024-07-28T23:00:00Z"
    }
  },
  "accessibility": {
    "access": {
      "deliveryLeadTime": "Variable",
      "jurisdiction": "GB",
      "dataController": "Public Health Scotland",
      "dataProcessor": "National Services Scotland",
      "accessRights": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/services-we-offer/",
      "accessService": "Scottish National Safe Haven / Trusted Research Environment: https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/national-safe-haven-nsh/",
      "accessRequestCost": "https://publichealthscotland.scot/services/data-research-and-innovation-services/electronic-data-research-and-innovation-service-edris/cost-of-services/",
      "accessServiceCategory": "TRE/SDE"
    },
    "usage": {
      "dataUseLimitation": "General research use",
      "dataUseRequirement": "Collaboration required;,;Institution-specific restrictions;,;Not for profit use",
      "resourceCreator": {
        "name": "National Services Scotland;,;Public Health Scotland"
      }
    },
    "formatAndStandards": {
      "vocabularyEncodingSchemes": "NHS SCOTLAND NATIONAL CODES",
      "languages": "en",
      "formats": "text;,;csv"
    }
  },
  "linkage": {
    "associatedMedia": "https://publichealthscotland.scot/services/national-data-catalogue/national-datasets/search-the-datasets/accident-and-emergency-data-mart-ae2/;,;https://www.researchdata.scot/media/3nhajpvr/scotland-accident-and-emergency-variables_220824.pdf"
  },
  "structuralMetadata": [
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "patient_gender_code",
          "sensitive": false,
          "description": "Gender code for the patient"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "patient_gender_description",
          "sensitive": false,
          "description": "Gender description for the patient"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "patient_date_of_birth",
          "sensitive": false,
          "description": "The date when a person was born or is officially deemed to have been, as recorded on the Birth Certificate."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "arrival_date_time",
          "sensitive": false,
          "description": "The date and time a person arrives at an A&E reception or is received into the A&E department. If the patient arrives by ambulance, this is when the ambulance staff register their arrival, not the (later) time when the patient is brought in."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "discharge_date_time",
          "sensitive": false,
          "description": "The date & time of a patient's discharge from an A&E department."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "arrival_mode_code",
          "sensitive": false,
          "description": "The substantive means by which a patient arrived at an A&E department. For example ambulance, private or public transport."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "arrival_mode_description",
          "sensitive": false,
          "description": "The name of the transportation type by which a patient arrives at an A&E department."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "attendance_category_code",
          "sensitive": false,
          "description": "A record of whether a patient is making a first or follow-up attendance at\na particular A&E department. Codes are further split into planned and unplanned attendances."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "attendance_category_desc",
          "sensitive": false,
          "description": "The name of the type of record of whether a patient is making a first or follow-up attendance at a particular A&E department."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "discharge_destination_code",
          "sensitive": false,
          "description": "The immediate destination of the patient on discharge from the A&E\ndepartment. For example admission to the same hospital, transfer to other hospital or discharge to home."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "discharge_destination_desc",
          "sensitive": false,
          "description": "The name of the type of immediate destination of the patient on discharge from the A&E department."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "diagnosis_code_1",
          "sensitive": false,
          "description": "The working diagnosis, main symptoms or abnormal findings recorded at the time of discharge. Contains free text and Emergency Care Data Set (ECDS) coding. Please note there is poor data completeness for this data item."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "diagnosis_code_2",
          "sensitive": false,
          "description": "As above"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "diagnosis_code_3",
          "sensitive": false,
          "description": "As above"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "disease_icd10_code_1",
          "sensitive": false,
          "description": "The ICD10 code of the working diagnosis, main symptoms or abnormal findings on discharge from A&E. Please note there is poor data completeness for this data item."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "disease_icd10_code_2",
          "sensitive": false,
          "description": "As above"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "disease_icd10_code_3",
          "sensitive": false,
          "description": "As above"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "treatment_location_code",
          "sensitive": false,
          "description": "Location of treatment"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "referral_source_code",
          "sensitive": false,
          "description": "A&E referral source is either the individual, healthcare professional or service (e.g. police) that makes the decision to attend A&E."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "referral_source_desc",
          "sensitive": false,
          "description": "The name of the organisation, professional and other individual who makes a referral to an A&E department."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "patient_flow_code",
          "sensitive": false,
          "description": "This is used to support analysis of the flows of patients throught A&E.  There are five codes measuring the onward journey for patients (e.g. admission to medical or surgical wards).  Coding is derived locally and is not nationally consistent."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "patient_flow_desc",
          "sensitive": false,
          "description": "As above"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "care_home",
          "sensitive": false,
          "description": "Flag indicating whether or not the patient is a resident of a care home, sourced from the CHI database."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "chronic_condition_flags",
          "sensitive": false,
          "description": "All the chronic condition flags encoded as a single binary string  '0001101001011111100' where a 1 is Y and a 0 is N."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "arthritis",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for arthritis based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "asthma",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for asthma based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "atrial_fibrillation",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for atrial_fibrillation based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "cancer",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for cancer based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "cerebrovascular_disease",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for cerebrovascular disease based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "chronic_liver_disease",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for chronic liver disease based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "copd",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for copd based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "dementia",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for dementia based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "diabetes",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for diabetes based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "epilepsy",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for epilepsy based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "heart_disease",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for heart_disease based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "heart_failure",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for heart_failure based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "multiple_sclerosis",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for multiple sclerosis based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "parkinsons_disease",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for parkinsons disease based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "renal_failure",
          "sensitive": false,
          "description": "Identifies patients who have previously had an admission for renal failure based on Hospital Admission data that dates back to 1981"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "cup_marker",
          "sensitive": false,
          "description": "An index of CUPs for each patient. Identifies a unique Continuous Unscheduled Care Pathway (CUP) for a patient. Eg. for all episodes in a patient's first CUP, this will be set to 1. For all episodes in their 2nd CUP, 2 etc."
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "episode_within_cup",
          "sensitive": false,
          "description": "The number of this service contact (episode) within the CUP (1st episode is 1, 2nd episode is set to 2 etc.)"
        }
      ]
    },
    {
      "name": "Accident and Emergency",
      "columns": [
        {
          "name": "episode_within_cup",
          "sensitive": false
        }
      ]
    }
  ],
  "tissuesSampleCollection": [
    {
      "materialType": "None/not available"
    }
  ]
}