Covid 19 Accident and Emergency Statistics

Preview of JSON file

{
  "summary": {
    "title": "Covid 19 Accident and Emergency Statistics",
    "abstract": "Contains data on episode level new and unscheduled attendances at Emergency Departments and some smaller community hospitals and minor injury units (MIUs).",
    "keywords": "COVID-19;,;Accident and Emergency;,;HIC;,;SCOTLAND",
    "publisher": {
      "name": "Health Informatics Centre - University of Dundee",
      "gatewayId": "5baa31c1-0280-4482-b8b7-a4953869f184"
    },
    "inPipeline": "Not available",
    "shortTitle": "Covid 19 Accident and Emergency Statistics",
    "datasetType": "Health and disease",
    "description": "Contains data on episode level new and unscheduled attendances at Emergency Departments and some smaller community hospitals and minor injury units (MIUs).",
    "contactPoint": "hicsupport@dundee.ac.uk",
    "datasetSubType": "Not applicable",
    "populationSize": 378367
  },
  "coverage": {
    "pathway": "Secondary care records for Tayside and Fife",
    "spatial": "United Kingdom,Scotland",
    "followUp": "Unknown",
    "typicalAgeRange": "0-150"
  },
  "required": {
    "issued": "2024-10-08T11:28:28.586143Z",
    "version": "1.0.0",
    "modified": "2024-10-08T11:28:28.586159Z",
    "gatewayId": "106",
    "revisions": [
      {
        "url": "https://web.prod.hdruk.cloud//dataset/106?version=1.0.0",
        "version": "1.0.0"
      }
    ],
    "gatewayPid": "eee9342a-f180-4c49-b61f-f904cb824a7a"
  },
  "provenance": {
    "origin": {
      "source": "Other",
      "purpose": "Disease registry",
      "imageContrast": "Not stated",
      "collectionSituation": "Secondary care - Accident and Emergency"
    },
    "temporal": {
      "timeLag": "Other",
      "startDate": "2018-01-01",
      "accrualPeriodicity": "Continuous",
      "distributionReleaseDate": "2022-05-19"
    }
  },
  "observations": [
    {
      "observedNode": "Persons",
      "measuredValue": 378367,
      "observationDate": "2022-05-19",
      "measuredProperty": "COUNT",
      "disambiguatingDescription": "378,367 persons in this dataset"
    }
  ],
  "accessibility": {
    "usage": {
      "resourceCreator": {
        "name": "NHS Fife and Tayside"
      },
      "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": "Not applicable",
      "accessRequestCost": "Quotation available on request",
      "accessServiceCategory": "TRE/SDE"
    },
    "formatAndStandards": {
      "formats": "Database",
      "languages": "en",
      "vocabularyEncodingSchemes": "LOCAL"
    }
  },
  "structuralMetadata": [
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "treatment_location_code_Desc",
          "dataType": "nvarchar(255)",
          "sensitive": false,
          "description": "This field represents the treatment location based on the location code."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "chi_number",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "record_id",
          "dataType": "varchar(15)",
          "sensitive": false,
          "description": "This field represents the accident and emergency record number. this is anonymised on release."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "patient_gender_code",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "patient_gender_description",
          "dataType": "varchar(6)",
          "sensitive": false,
          "description": "This field represents Gender and is defined Male or Female."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "patient_date_of_birth",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "arrival_date_time",
          "dataType": "varchar(15)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "discharge_date_time",
          "dataType": "varchar(15)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "arrival_mode_code",
          "dataType": "varchar(2)",
          "sensitive": false,
          "description": "This field represents the substantive means by which a patient arrived at an A&E department.    01 Ambulance (road)  02 Ambulance (air)  03 Ambulance + A&E retrieval team  04 Out of hours transport  05 Private transport  06 Public transport  07 Walking  08 Police/prison transport  98 Other  99 Not known."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "arrival_mode_description",
          "dataType": "varchar(30)",
          "sensitive": false,
          "description": "This field represents the description for the arrival code:   Ambulance (air)   Ambulance (road)   Ambulance + A&E retrieval team   Not known   Other   Out of hours transport   Police/prison transport   Private transport   Public transport   Walking   ."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "attendance_category_code",
          "dataType": "varchar(2)",
          "sensitive": false,
          "description": "This field represents a record of whether a patient is making a first or follow-up attendance at a particular A&E department.  01 New  02 Return - planned  03 Return - unplanned  04 Recall."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "attendance_category_desc",
          "dataType": "varchar(18)",
          "sensitive": false,
          "description": "This field represents the description to accompany the attendance category code."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "discharge_destination_code",
          "dataType": "varchar(3)",
          "sensitive": false,
          "description": "This field represents the immediate destination of the patient on discharge from the A&E department.  00      Death  01      Private Residence  01A   Usual place of residence    01B   Not usual place of residence e.g. staying with relatives or friends   02     Residential institution   02A   Usual place of residence    02B   Not usual place of residence  03     Temporary residence  03A   Holiday accommodation    03B    Student accommodation    03C    Legal establishment /prison    03D    No fixed abode    03Z    Other temporary residence    04       Admission to same NHS healthcare provider / hospital  04A    A&E Ward Includes A&E observation ward, A&E short stay ward, etc   04B    Assessment unit    04C    Medical Ward Includes medical admissions unit, coronary care unit   04D   Surgical Ward Includes surgical admissions unit, orthopaedic ward   04Z    Other Ward    05     Transfer to same/other hospital  05A   Psychiatric hospital    05B   Other specialist centre e.g. eye hospital, paediatric hospital   05C   Community hospital   05D   Transferred to Out of Hours (triaged in A&E)  05E   Transferred to Out of Hours (not triaged in A&E)  05F   Advised to attend GP/Primary Care  05G   A&E  05H   NHS24   05Z   Other NHS hospital    06     Private healthcare provider  98     Other  99     Other."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "discharge_destination_desc",
          "dataType": "varchar(93)",
          "sensitive": false,
          "description": "This field represents the description for the discharge code. This specifies where the patient was discharged to for example: Death, Private Healthcare, Private Residence."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "diagnosis_code_1",
          "dataType": "varchar(2)",
          "sensitive": false,
          "description": "This field represents the diagnosis code. This is a numerical field 1 -14 and 99."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "ecds_diagnosis_desc_1",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "This field represents the diagnostic description."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "treatment_location_code",
          "dataType": "varchar(5)",
          "sensitive": false,
          "description": "This field represents the location where treatment was carried out.  Each location in Scotland, at which events pertinent to the Scottish Health Service take place, is allocated a location code.   The code is a five character code and is maintained jointly by ISD and General Register Office (Scotland).  F704H VICTORIA HOSPITAL  F805H QUEEN MARGARET HOSPITAL  T101H NINEWELLS HOSPITAL  T202H PERTH ROYAL INFIRMARY  T205H ST MARGARET'S HOSPITAL  T207H ABERFELDY COTTAGE HOSPITAL  T208H IRVINE MEMORIAL HOSPITAL  T209H BLAIRGOWRIE & RATTRAY COTTAGE HOSPITAL  T304H ARBROATH INFIRMARY  T305H BRECHIN INFIRMARY  T316H CRIEFF COMMUNITY HOSPITAL  T319H WHITEHILLS HEALTH AND COMMUNITY CARE CENTRE  T320H PITLOCHRY COMMUNITY HOSPITAL  T357C LINKS HEALTH CENTRE."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "patient_postcode",
          "dataType": "varchar(7)",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "referral_source_code",
          "dataType": "varchar(3)",
          "sensitive": false,
          "description": "This field represents the source of referral by code."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "referral_source_desc",
          "dataType": "varchar(76)",
          "sensitive": false,
          "description": "This field is the descriptive value relating to the referral source code."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "patient_flow_code",
          "dataType": "int",
          "sensitive": false,
          "description": "This field represents the patients’ predominant need for ongoing assessment to determine the next step in their care pathways.  NULL NULL  1 Flow 1: Minor Injury & Illness  2 Flow 2: Acute assessment - includes major injuries  3 Flow 3: Medical Admissions  4 Flow 4: Surgical Admissions  5 Flow 5: Out of Hospital Care."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "patient_flow_desc",
          "dataType": "varchar(50)",
          "sensitive": false,
          "description": "This field is the descriptive value relating to the patient flow code."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "presenting_complaint",
          "dataType": "varchar(100)",
          "sensitive": false,
          "description": "This field represents how the patient reported his or her injury to A&E reception on arrival (e.g., CHEST PAIN, wrist injury, LEFT EYE INJURY).  It is a free-format text field.  chest pain  unwell  HEAD INJURY  ABDO PAIN."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "PROCHI",
          "dataType": "varchar(10)",
          "sensitive": false,
          "description": "Anonymised patient identifier"
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "date_time_arrival",
          "dataType": "datetime",
          "sensitive": false,
          "description": "This field represents the date and time of arrival."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "date_time_discharged",
          "dataType": "datetime",
          "sensitive": false,
          "description": "This field represents the data and time of discharge."
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "hic_dataLoadRunID",
          "dataType": "int",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Accident and Emergency Statistics."
    },
    {
      "name": "COVID19 - Accident and Emergency",
      "columns": [
        {
          "name": "hic_validFrom",
          "dataType": "datetime2",
          "sensitive": false,
          "description": "No Column Description Available"
        }
      ],
      "description": "Accident and Emergency Statistics."
    }
  ]
}