This website places cookies on your device to help us improve our service to you. To find out more about the cookies, see our Privacy and Cookies notice
ISD Scotland better information, better decisions, better health

File Listings 2011

Costs

NHS National Services Scotland ISD Scotland & NHS National Services Scotland

File Listings 2011

The following links provide short cuts to the 2011 data files for technical users:

Reports - Excel files designed for viewing (note: some files include macros)
Downloads - Excel files designed for further data analysis
SFRs - Excel files giving access to the source data

For important information about the 2011 data see Summary of Changes Download pdf file [35kb]. File listings for previous years are also available from the Costs Archive.

Reports 2011

The full range of Costs Book tables in MS Excel, designed for on-screen viewing.

Download Zip file All Reports [2.6mb] - use Save option to download ZIP file

Download Excel file R100 - executive summary, for Scotland and each board
Download Excel file R100T - expenditure and activity figures for the last 5 years, for Scotland and each board
Download Excel file R086 - NHS Board operating costs and capital expenditure
Download Excel file R300s - net expenditure, by board of treatment, by care type
Download Excel file R020 - hospital summary (excluding long stay hospitals)
Download Excel file R020LS - hospital summary - long stay hospitals
Download Excel file R025 - board level aggregate of hospital running cost
 
 
 
 
 
 
Download Excel file R04X - specialty summary - all specialties (exc long stay), by patient type, by board
Download Excel file R04LSX - specialty summary - long stay specialties, by patient type, by board
Download Excel file R04opX - total specialty outpatient expenditure and activity summary, by board
Download Excel file R040 - specialty costs and activity - inpatients in all specialties (exc long stay), by hospital
Download Excel file R040X - specialty costs and activity - inpatients in all specialties (exc long stay), by board
Download Excel file R040LS - specialty summary - inpatients in long stay specialties, by patient type, by hospital
Download Excel file R040LSX - specialty summary - inpatients in long stay specialties, by patient type, by board
Download Excel file R042 - specialty costs and activity - daycases, by specialty, by hospital
Download Excel file R042X - specialty costs and activity - daycases, by specialty, by board
Download Excel file R043 - specialty costs and activity - outpatient treatments, by specialty, by hospital
Download Excel file R043X - specialty costs and activity - outpatient treatments, by specialty, by board
Download Excel file R044 - specialty costs and activity - consultant outpatients, by specialty, by hospital
Download Excel file R044X - specialty costs and activity - consultant outpatients, by specialty, by board
Download Excel file R045 - specialty costs and activity - nurse led clinics, by specialty, by hospital
Download Excel file R045X - specialty costs and activity - nurse led clinics, by specialty, by board
Download Excel file R046 - costs and activity at AHP outpatient clinics, by profession, by hospital
Download Excel file R046X - costs and activity at AHP outpatient clinics, by profession, by board
Download Excel file R048 - specialty costs and activity - day patients, by specialty, by hospital
Download Excel file R048X - specialty costs and activity - day patients, by specialty, by board
 
 
 
 
 
 
Download Excel file R060 - expenditure on services provided by AHPs, by hospital
Download Excel file R060X - expenditure on services provided by AHPs, by board
 
 
 
 
 
 
Download Excel file R070 - expenditure on catering, domestic and portering services, by hospital
Download Excel file R070X - expenditure on catering, domestic and portering services, by board
Download Excel file R080 - expenditure on linen services, by hospital
Download Excel file R080X - expenditure on linen services, by board
Download Excel file R090 - expenditure on property overheads, by hospital
Download Excel file R090X - expenditure on property overheads, by board
Download Excel file R110 - expenditure on management & administration expenses, by hospital
Download Excel file R110X - expenditure on management & administration expenses, by board
 
 
 
 
 
 
Download Excel file R120 - expenditure and activity - radiology services, by hospital
Download Excel file R120X - expenditure and activity - radiology services, by board
Download Excel file R130 - expenditure and activity - laboratory services, by hospital
Download Excel file R130X - expenditure and activity - laboratory services, by board
Download Excel file R140 - number of theatres, expenditure and usage, by hospital
Download Excel file R140X - number of theatres, expenditure and usage, by board
Download Excel file R141X - average theatre running costs, by board
Download Excel file R142X - average theatre running costs and usage, by specialty, by board
 
 
 
 
 
 
Download Excel file R500 - summary of expenditure on main community services, by board
Download Excel file R510 - community AHP services by board
Download Excel file R520 - other community services by board
Download Excel file R550 - summary of expenditure on community staff and supplies, by board
 
 
 
 
 
 
Download Excel file R600 - pharmacy drugs expenditure, by NHS sector, by board
Download Excel file R610 - pharmacy drugs expenditure for the hospital sector, by hospital
 
 
 
 
 
 
Download Excel file R700 - staff expenditure summary by sector, by board
Download Excel file R710 - hospital staff profile - expenditure and WTEs by main staff groupings, by board
Download Excel file R720 - hospital staff profile - expenditure and WTEs by specialty
Download Excel file R730 - community staff profile - expenditure and WTEs by main staff groupings, by board
Download Excel file R740 - laboratory staff profile - expenditure and WTEs by main staff groupings, by board
 
 
 
 
 
 
Download Excel file R810 - expenditure on pharmaceutical services, by NHS sector, by board
Download Excel file R820 - expenditure on dental services, by NHS sector, by board
Download Excel file R830 - expenditure on ophthalmic services, by NHS sector, by board
 
 
 
 
 
 
Download Excel file R910 - Scottish Ambulance Service, expenditure and statistics, by board area
Download Excel file R920 - National Services Scotland, expenditure and staff numbers, by division
Download Excel file R921 - Scottish Breast Screening Programme, expenditure and statistics, by region

Note: the links above open MS Excel workbooks, the largest of which is approximately 808 KB.

Back to top

Download Reports 2011

A range of data tables in MS Excel designed for download and further analysis.

Download Zip file All Downloads [1.7mb] - use Save option to download ZIP file

Download Excel file R300s - Provision of Health Care
Download Excel file R020 - Hospital Summary (excluding Long Stay Hospitals)
Download Excel file R020(LS) - Hospital Summary - Long Stay Hospitals
Download Excel file R025 - Hospital Running Costs - Board Level Aggregate
Download Excel file R040 (&LS) - Specialty Group Costs - Inpatients
Download Excel file R042 - Specialty Costs - Day Cases
Download Excel file R043 - Specialty Costs - Consultant Outpatient Treatment Clinics
Download Excel file R044 - Specialty Costs - Consultant Outpatient Clinics
Download Excel file R045 - Specialty Costs - Nurse Led Clinics
Download Excel file R046 - Specialty Costs - AHP Outpatient Clinics
Download Excel file R048 - Specialty Costs - Day Patients
Download Excel file R060 - Expenditure on Services Provided by AHPs
Download Excel file R070-R110 - Overheads
Download Excel file R120 - Radiology
Download Excel file R130 - Laboratories
Download Excel file R140 - Theatres
Download Excel file R500s - Community Health Services

Note: the links above open MS Excel workbooks, the largest of which is approximately 935 KB.

Back to top

Scottish Financial Returns (SFRs) 2011

The source data files in MS Excel for browsing or to download for further analysis.

Download Zip file All SFRs [2.5mb] - use Save option to download ZIP file

Download Excel file SFR 5.1A - hospital summary statistics
Download Excel file SFR 5.1B - hospital staff & pay
Download Excel file SFR 5.2 - hospital running costs
Download Excel file SFR 5.3 - specialty analysis, inpatients
Download Excel file SFR 5.5 - specialty analysis, daycases
Download Excel file SFR 5.6 - specialty analysis, outpatient treatment clinics
Download Excel file SFR 5.7 - specialty analysis, outpatient consult clinics
Download Excel file SFR 5.7n - specialty analysis, nurse led clinics
Download Excel file SFR 5.8 - AHP outpatient clinics, by profession
Download Excel file SFR 5.9 - specialty analysis, day patients
Download Excel file SFR 5.10 - theatres summary
Download Excel file SFR 5.11 - radiology services
 
 
 
 
 
 
Download Excel file SFR 8.1 - community staff & pay
Download Excel file SFR 8.2 - community running costs
Download Excel file SFR 8.3 - community services
Download Excel file SFR 8.4 - family health services
 
 
 
 
 
 
Download Excel file SFR 24.0 - NHS services provided by sub contracting
Download Excel file SFR 27s - laboratory services
 
 
 
 
 
 
Download Excel file SFRs - full list of blank templates for 2010/11

Note: the links above open MS Excel workbooks, the largest of which is approximately 2.8 MB.

Back to top


© ISD Scotland 2010
Information Services Division,
NHS National Services Scotland,
Gyle Square,
1 South Gyle Crescent,
Edinburgh EH12 9EB,
Tel: 0131 275 7050
NSS.isdSHIS@nhs.net  
Contact Us

About Information Services Division | Contact Us | Accessibility | Complaints
Copyright | Terms and Conditions | Privacy | Freedom of Information

ISD is a division of NHS NSS
Working at the very heart of the health service, NSS delivers services critical to frontline patient care and in support of the efficient and effective operation of NHS Scotland. Visit the NSS Website for more information