MDW - Discover Metadata Catalogue

MDW Discover  > Ambulance Data Set @ 1356

MDW Discover

Browse All

London SDE

West Midlands SDE

Kent, Medway & Sussex SDE

MDW - Discover

https://www.england.nhs.uk/urgent-emergency-care/improving-ambulance-services/ambulance-data-set/

Number of distinct individuals in the dataset

Total number of emergency calls in the dataset

HDR UK

Provider Submitted: An flag for calls that were received from 111, either by manual or automated transfer

111Flag

Provider Submitted: A detailed code to identify the acuity and condition after telephone triage by an ambulance service which use the AMPDS triage system, which is accessible to authorised Ambulance Services through NHS Futures Clinical Coding Webpage

AmpdsTriageDisposition

Provider Submitted: An identifier for calls that should be counting within the NHSE Ambulance Quality Indicator (AQI) standard performance metrics

AqiIncidentFlag

Provider Submitted: The time duration it took to respond to the patient based on the national Ambulance Quality Indicator performance reporting definitions

AqiResponseTime

AGEM Derived: Used to identify which load batch the record belongs to.

AuditId

AGEM Derived: Internal date when the data was processed.

AuditIdLoadDate

NHSE Derived: FHIR key generated by Trust for the whole submission sent to NHSE.

BundleId

Provider Submitted: This is the date the Ambulance Service generates the CALL IDENTIFIER

CallDate

Provider Submitted: An unique identifier for each?call to the ambulance control room

CallIdentifier

Provider Submitted: A code which identifies the origin of the call into the ambulance control room whether 999 was directly dialled or it was transferred from another agency

CallOrigin

Provider Submitted: An identifier for calls that were early identified as a Category 1 call

Cat1EarlyPredictionFlag

Provider Submitted: A code assigned to every postcode in the United Kingdom to identify which Clinical Commissioning Group is responsible for that location

CcgCode

Provider Submitted: The date/time that the clock started for Ambulance Quality Indicator performance reporting and other purposes (ref: AQI Guidance)

ClockStartDateTime

Provider Submitted: The date/time that the first response arrived at the incident location that counts as the arrival time based on the National Ambulance Quality Indicator definitions

ClockStopDateTime

NHSE Derived: From FHIR JSON Bundle. A unique ID for the Communication resource which is the basis for the Call Table.

CommunicationUid

AGEM Derived: Takes the year and month values from the Arrival_Date/Episode_End_Date/Discharge_Date/Appointment_Date.

Der_Activity_Month

AGEM Derived: Derived financial year value based on activity date in the format YYYY/YY.

Der_Financial_Year

AGEM Derived: The code of the CCG where the patient&#039;s postcode of usual address is based, unless the given postcode is ZZ99 3VZ (no fixed abode), ZZ99 3WZ (address not known) or ZZ99 3CZ (England UK - not specified), in which case NULL is given.

Der_Postcode_CCG_Code

AGEM Derived: The code of the constituency where the patient&#039;s postcode of usual address is based, derived by linking on postcode to a postcode geographies table.

Der_Postcode_Constituency_Code

AGEM Derived: The code of the district unitary authority where the patient&#039;s postcode of usual address is based, derived by linking on postcode to a postcode geographies table.

Der_Postcode_DistUnitary_Auth

AGEM Derived: The code of the electoral Ward where the patient&#039;s postcode of usual address is based, derived by linking on postcode to a postcode geographies table.

Der_Postcode_Electoral_Ward

AGEM Derived: The code of the local authority where the patient&#039;s postcode of usual address is based, derived by linking on postcode to a postcode geographies table.

Der_Postcode_Local_Auth

AGEM Derived: The code of the Lower Layer Super Output Area (LSOA) where the patient&#039;s postcode of usual address is based, derived by linking on postcode to a postcode geographies table. Uses the list of LSOAs as of the 2011 census.

Der_Postcode_LSOA_2011_Code

AGEM Derived: The code of the Lower Layer Super Output Area (LSOA) where the patient&#039;s postcode of usual address is based, derived by linking on postcode to a postcode geographies table. Uses the list of LSOAs as of the 2021 census.

Der_Postcode_LSOA_2021_Code

AGEM Derived: The code of the Lower Layer Super Output Area (LSOA) where the patient&#039;s postcode of usual address is based, derived by linking on postcode to a postcode geographies table. Uses the list of LSOAs as of the 2001 census.

Der_Postcode_LSOA_Code

AGEM Derived: The code of the Middle Layer Super Output Area (MSOA) where the patient&#039;s postcode of usual address is based, derived by linking on postcode to a postcode geographies table. Uses the list of MSOAs as of the 2011 census.

Der_Postcode_MSOA_2011_Code

AGEM Derived: The code of the Middle Layer Super Output Area (MSOA) where the patient&#039;s postcode of usual address is based, derived by linking on postcode to a postcode geographies table. Uses the list of MSOAs as of the 2021 census.

Der_Postcode_MSOA_2021_Code

AGEM Derived: The code of the Middle Layer Super Output Area (MSOA) where the patient&#039;s postcode of usual address is based, derived by linking on postcode to a postcode geographies table. Uses the list of MSOAs as of the 2001 census.

Der_Postcode_MSOA_Code

AGEM Derived: Derived postcode sector based upon the patient&#039;s postcode.

Der_Postcode_Sector

Provider Submitted: An identifier for calls that were received from a Health Care Professional for transport

HcpFlag

Provider Submitted: An identifier for calls that were received to request the transport of a patient from one care facility to another (IFT - Inter facility transfer)

IftFlag

NHSE Derived: A key generated by NHSD on receipt of a submission, always unique in the data set

IngestKey

Provider Submitted: A code to identify the initial acuity categorisation based on the early information given during triage by the ambulance control room.

InitialResponseCategory

Provider Submitted: The Category name of the Code from InitialResponseCategory

InitialResponseCategoryDerived

Provider Submitted: This is the ORGANISATION IDENTIFIER of the Ambulance Service which treats the PATIENT

OrganisationIdentifierCodeOfProvider

NHSE Derived: Derived from the first 3 Digits of OrganisationIdentifierCodeOfProvider.

OrgidProv3

Provider Submitted: A detailed code to identify the acuity and condition after telephone triage by an ambulance service which use the Pathways triage system, which is accessible to authorised Ambulance Services through NHS Futures Clinical Coding Webpage

PathwaysTriageDisposition

Provider Submitted: A code to identify the final acuity categorisation based on the full information given during triage by the ambulance control room. The categorisation used for Ambulance Quality Indicator reporting

ReportingResponseCategory

Provider Submitted: The Category name of the Code from ReportingResponseCategory

ReportingResponseCategoryDerived

Provider Submitted: A detailed code to identify the condition after telephone triage by an ambulance service which use the Pathways triage system, which is accessible to authorised Ambulance Services through NHS Futures Clinical Coding Webpage

SdCodeSymptomDiscriminator

Provider Submitted: A summary code to identify the condition following telephone triage by an ambulance service which use the Pathways triage system, which is accessible to authorised Ambulance Services through NHS Futures Clinical Coding Webpage

SgCodeSymptomGroup

Provider Submitted: A code which identifies the reason the call was closed if no face to face response was received from the ambulance service

StopCodes

AGEM Derived: Unique ID for Call data set

StoreCallID

NHSE Derived: Time the submission arrives at NHSD

SubmissionTs

NHSE Derived: Type of submission e.g. daily.

SubmissionType

Provider Submitted: This is the ORGANISATION IDENTIFIER of the organisation submitting the data

SubmittingOrganisationCode

Provider Submitted: The date/time that the call was answered in the ambulance control room

TimeCallAnswered

Provider Submitted: The time that the call was connected to the ambulance control room

TimeCallConnected

Provider Submitted: The date/time that the call ended in the ambulance control room

TimeCallEnded

Provider Submitted: The time that the category 1 was early identified (only applicable to category 1 incidents)

TimeCat1EarlyPredictionEstablished

Provider Submitted: The time that the Pathways Triage Disposition code or AMPDS Triage disposition code is established

TimeDispatchCodeEstablished

Provider Submitted: A code classifying the overall outcome of the call

TreatmentType

NW_DME.Ambulance.Call

AGEM Derived: Age in years derived from patient.date_of_birth and call.call_date. patient.date_of_birth is removed from outputs before dissemination.

Der_Age_At_CallDate

AGEM Derived: Derived CCG (Sub ICB Location) of registration by looking up patient NHS Number in PDS dataset (Patient Demographics Service).

Der_PDS_CCG_of_Registration

AGEM Derived: Derived CCG (Sub ICB Location) of residence by looking up patient NHS Number in PDS dataset (Patient Demographics Service).

Der_PDS_CCG_of_Residence

AGEM Derived: Derived ICB of registration by looking up patient NHS Number in PDS dataset (Patient Demographics Service).

Der_PDS_ICB_of_Registration

AGEM Derived: Derived ICB of resideince by looking up patient NHS Number in PDS dataset (Patient Demographics Service).

Der_PDS_ICB_of_Residence

AGEM Derived: Derived Postcode Sector by looking up patient NHS Number in PDS dataset (Patient Demographics Service). Comprised of all characters to the left of the space in a full 8 character postcode and first character to the right of the space

Der_PDS_Post_Code_Sector

AGEM Derived: Derived GP Practice Code by looking up patient NHS Number in PDS dataset (Patient Demographics Service).

Der_PDS_Practice_Code

AGEM Derived: Client specific Pseudonymised NHS Number derived from patient.nhs_number. If NHS Number is not populated or not valid this will be NULL.

Der_Pseudo_NHS_Number

NHSE Derived: From FHIR JSON Bundle. A unique ID for the Patient resource which is the basis for the Patient ContactTable.

PatientUid

AGEM Derived: Link to the Call data set for the StorePatientID

AGEM Derived: Unique ID for Patient data set

StorePatientID

NW_DME.Ambulance.Patient

Provider Submitted: A unique reference used to identify the response within a Health Care Provider

CallSign

AGEM Derived: Receiving location (e.g. hospital ECDS location) derived from ReceivingLocationSiteCodeCad and checked against reference data.

Der_Receiving_Location_Provider_Code

NHSE Derived: From FHIR JSON Bundle. A unique ID for the Encounter resource which is the basis for the Response Table.

EncounterUid

Provider Submitted: A code to identify the highest clinical skill level on the response (note PractitionerRole is linked from the Encounter as well as the Location that represents the CallSign)

HighestSkillLevelOnVehicle

Provider Submitted: ORGANISATION SITE IDENTIFIER (OF TREATMENT) is the ORGANISATION IDENTIFIER of the Organisation Site where the PATIENT was treated, i.e. it should enable the treating Organisation to be identified REF: https://digital.nhs.uk/services/organisation-data-service/data-downloads/other-nhs-organisations

ReceivingLocationSiteCodeCad

Provider Submitted: The type of destination (Short list) that the patient was conveyed to (Only applicable to See and Convey Patients)

ReceivingLocationTypeCad

Provider Submitted: A code to identify the type of organisation the response belongs to

RespondingOrganisationType

Provider Submitted: A code identifying the type of response that is allocated to a call e.g. an ambulance or a rapid response vehicle for a face to face response

ResponseType

AGEM Derived: Link to the Call dataset for the StoreResponseID

AGEM Derived: Link to the Patient data set for the StoreResponseID

AGEM Derived: Unique ID for Response data set

StoreResponseID

Provider Submitted: The time the resource is clear from a call, and is available to be allocated to another call (either from receiving location or scene if no transport or stood down)

TimeClear

Provider Submitted: The time the conveyed patient is handed over to the receiving location, often a hospital, who take over clinical responsibility for the patient from this time

TimeOfPatientHandover

Provider Submitted: The time the resource is allocated to a call by the ambulance control room requesting them to attend the incident location

TimeResourceAllocated

Provider Submitted: The time the resource arrives with the conveyed patient at the receiving location, often a hospital or other place of care

TimeResourceArrivedAtReceivingLocation

Provider Submitted: The date/time the resource arrives at the incident location they have been requested to attend

TimeResourceArrivedOnScene

Provider Submitted: The date/time the resource leaves the incident location in order to transport the patient to hospital

TimeResourceLeftScene

Provider Submitted: The date time the resource starts moving towards the incident location that has been requested to attend

TimeResourceMobilised

Provider Submitted: The date/time the vehicle was removed from a call whilst travelling towards an incident location if they are no longer required to attend

TimeStoodDown

NW_DME.Ambulance.Response

The Ambulance Data Set (ADS) is intended to provide an improved, consistent level of detail about how ambulance services respond to and treat the thousands of calls that are received by the 999 service every day

Ambulance Data Set

Documentation

Coverage

Provenance

Origin

Temporal

Accessibility

Access

Usage

Format and Standards

Observations

Origin