Activity by Location of Treatment and Specialty

URL: https://www.opendata.nhs.scot/dataset/d57ceb20-4449-4c3b-b07c-d2affe9b8dc0/resource/4e72be27-bec3-41ca-a0df-24417909d143/download/outpatient_by_location_of_treatment_specialty.csv

Specialty breakdown for new outpatient appointments and 'Did Not Attends' by location of treatment.

Size: 2.59MB

This resource view is not available at the moment. Click here for more information.

Download resource

Data Dictionary

Column Type Label Description
FinancialYear text The reference period as financial year (YYYY/YY)
FinancialYearQF text Qualifier for FinancialYear

Qualifier information

HB text 9-digit code for NHS board of treatment based on boundaries as at 1st April 2019, country code for Scotland and 6-digit codes for other residential categories

Health board labels

Country labels

Residential Categories

HBQF text Qualifier for HB

Qualifier information

Location text 5-digit code for location of treatment and country code for Scotland

Location Lookup

Country labels

LocationQF text Qualifier for Location

Qualifier information

Specialty text Specialty

Specialties

SpecialtyQF text Qualifier for Specialty

Qualifier information

SpecialtyName text The name of the Specialty

Specialties

SpecialtyNameQF text Qualifier for SpecialtyName

Qualifier information

SpecialtyGrouping text Specialty Grouping. The "All Acute Specialties" grouping includes the medical and surgery groupings combined.

[Specialty Groupings] (https://www.publichealthscotland.scot/media/13029/specialty-groupings.xlsx)

SpecialtyGroupingQF text Qualifier for SpecialtyGrouping

Qualifier information

TotalAttendances numeric Number of Total Attendances
TotalAttendancesQF text Qualifier for TotalAttendances

Qualifier information

NewAttendances numeric Number of New Attendances
NewAttendancesQF text Qualifier for NewAttendances

Qualifier information

ReturnAttendances numeric Number of Return Attendances
ReturnAttendancesQF text Qualifier for ReturnAttendances

Qualifier information

NewReturn numeric Ratio of New Attendances to Return Attendances
NewReturnQF text Qualifier for NewReturn

Qualifier information

DNA numeric Number of patients who did not attend appointments.
DNAQF text Qualifier for DNA

Qualifier information

NewPatients numeric Number of New Patients
NewPatientsQF text Qualifier for NewPatients

Qualifier information

Additional Information

Field Value
Data last updated September 26, 2023
Metadata last updated September 28, 2020
Created September 28, 2020
Format text/csv
License UK Open Government Licence (OGL)
createdover 3 years ago
datastore activeTrue
formatCSV
has viewsTrue
id4e72be27-bec3-41ca-a0df-24417909d143
last modified6 months ago
mimetypetext/csv
on same domainTrue
package idd57ceb20-4449-4c3b-b07c-d2affe9b8dc0
position5
revision id63c8b86f-4459-4628-b9f7-adb1f213e821
size2.5 MiB
stateactive
url typeupload