Activity by Health Board of Residence and ...

URL: https://www.opendata.nhs.scot/dataset/d57ceb20-4449-4c3b-b07c-d2affe9b8dc0/resource/1abb3f58-bf37-4a6c-80fd-32c0580087f9/download/outpatient_by_nhs_board_of_residence_specialty.csv

Specialty breakdown for new outpatient appointments and 'Did Not Attends' by health board of residence of the patients.

Size: 911KB

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

AppointmentType text
AppointmentTypeQF text
HB text 9-digit code for NHS board of residence 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

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

Attendances numeric
AttendancesQF text
AttendancesRate numeric
AttendancesRateQF text
NewReturn numeric
NewReturnQF text
DNA numeric Number of patients who did not attend appointments.
DNAQF text Qualifier for DNA

Qualifier information

DNARate numeric New did not attends as a percentage of the number of new outpatient attendances
DNARateQF text Qualifier for DNARate

Qualifier information

Patients numeric
PatientsQF text
PatientsRate numeric
PatientsRateQF text

Additional Information

Field Value
Data last updated September 30, 2025
Metadata last updated September 28, 2020
Created September 28, 2020
Format text/csv
License UK Open Government Licence (OGL)
createdover 5 years ago
datastore activeTrue
formatCSV
has viewsTrue
id1abb3f58-bf37-4a6c-80fd-32c0580087f9
last modified4 days ago
mimetypetext/csv
on same domainTrue
package idd57ceb20-4449-4c3b-b07c-d2affe9b8dc0
position8
revision ide9078279-461d-40ee-af88-a3bdfb636d9a
size2.5 MiB
stateactive
url typeupload