File Listings 2013
Revision Note: The 2013 Primary Medical Services figures for NHS Lothian and NHS Greater Glasgow and Clyde have been restated due to accounting changes (further details on this are provided on the R100 notes page); the figures in relation to this were revised on 24th November 2015.
The following links provide short cuts to the 2013 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 2013 data see Summary of Changes 
[35kb]. File listings for previous years are also available from the Costs Archive.
Reports 2013
The full range of Costs Book tables in MS Excel, designed for on-screen viewing.
All Reports 
[2.6mb] - use Save option to download ZIP file
 |
R100 |
- executive summary, for Scotland and each board |
|
R100T |
- expenditure and activity figures for the last 5 years, for Scotland and each board |
|
R086 | - NHS Board operating costs and capital expenditure |
|
R300s |
- net expenditure, by board of treatment, by care type |
|
R020 | - hospital summary (excluding long stay hospitals) |
|
R020LS | - hospital summary - long stay hospitals |
|
R025 | - board level aggregate of hospital running cost |
| |
|
|
|
R04X | - specialty summary - all specialties (exc long stay), by patient type, by board |
|
R04LSX | - specialty summary - long stay specialties, by patient type, by board |
|
R04opX | - total specialty outpatient expenditure and activity summary, by board |
|
R040 | - specialty costs and activity - inpatients in all specialties (exc long stay), by hospital |
|
R040X | - specialty costs and activity - inpatients in all specialties (exc long stay), by board |
|
R040LS | - specialty summary - inpatients in long stay specialties, by patient type, by hospital |
|
R040LSX | - specialty summary - inpatients in long stay specialties, by patient type, by board |
|
R042 | - specialty costs and activity - daycases, by specialty, by hospital |
|
R042X | - specialty costs and activity - daycases, by specialty, by board |
|
R044 | - specialty costs and activity - consultant outpatients, by specialty, by hospital |
|
R044X | - specialty costs and activity - consultant outpatients, by specialty, by board |
|
R045 | - specialty costs and activity - nurse led clinics, by specialty, by hospital |
|
R045X | - specialty costs and activity - nurse led clinics, by specialty, by board |
|
R046 | - costs and activity at AHP outpatient clinics, by profession, by hospital |
|
R046X | - costs and activity at AHP outpatient clinics, by profession, by board |
|
R048 | - specialty costs and activity - day patients, by specialty, by hospital |
|
R048X | - specialty costs and activity - day patients, by specialty, by board |
| |
|
|
|
R060 | - expenditure on services provided by AHPs, by hospital |
|
R060X | - expenditure on services provided by AHPs, by board |
| |
|
|
|
R070 | - expenditure on catering, domestic and portering services, by hospital |
|
R070X | - expenditure on catering, domestic and portering services, by board |
|
R080 | - expenditure on linen services, by hospital |
|
R080X | - expenditure on linen services, by board |
|
R090 | - expenditure on property overheads, by hospital |
|
R090X | - expenditure on property overheads, by board |
|
R110 | - expenditure on management & administration expenses, by hospital |
|
R110X | - expenditure on management & administration expenses, by board |
| |
|
|
|
R120 | - expenditure and activity - radiology services, by hospital |
|
R120X | - expenditure and activity - radiology services, by board |
|
R130 | - expenditure and activity - laboratory services, by hospital |
|
R130X | - expenditure and activity - laboratory services, by board |
|
R140 | - number of theatres, expenditure and usage, by hospital |
|
R140X | - number of theatres, expenditure and usage, by board |
|
R141X | - average theatre running costs, by board |
|
R142X | - average theatre running costs and usage, by specialty, by board |
| |
|
|
|
R500 | - summary of expenditure on main community services, by board |
|
R510 | - community AHP services by board |
|
R520 | - other community services by board |
|
R550 | - summary of expenditure on community staff and supplies, by board |
| |
|
|
|
R600 |
- pharmacy drugs expenditure, by NHS sector, by board |
|
R610 | - pharmacy drugs expenditure for the hospital sector, by hospital |
| |
|
|
|
R700 | - staff expenditure summary by sector, by board |
|
R710 | - hospital staff profile - expenditure and WTEs by main staff groupings, by board |
|
R720 | - hospital staff profile - expenditure and WTEs by specialty |
|
R730 | - community staff profile - expenditure and WTEs by main staff groupings, by board |
|
R740 | - laboratory staff profile - expenditure and WTEs by main staff groupings, by board |
| |
|
|
|
R810 | - expenditure on pharmaceutical services, by NHS sector, by board |
|
R820 | - expenditure on dental services, by NHS sector, by board |
|
R830 | - expenditure on ophthalmic services, by NHS sector, by board |
| |
|
|
|
R910 | - Scottish Ambulance Service, expenditure and statistics, by board area |
|
R920 | - National Services Scotland, expenditure and staff numbers, by division |
|
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.
Download Reports 2013
A range of data tables in MS Excel designed for download and further analysis.
All Downloads [1.7mb] - use Save option to download ZIP file
| |
R300s |
- Provision of Health Care |
|
R020 | - Hospital Summary (excluding Long Stay Hospitals) |
|
R020(LS) | - Hospital Summary - Long Stay Hospitals |
|
R025 | - Hospital Running Costs - Board Level Aggregate |
|
R040 (&LS) | - Specialty Group Costs - Inpatients |
|
R042 | - Specialty Costs - Day Cases | |
R044 | - Specialty Costs - Consultant Outpatient Clinics |
|
R045 | - Specialty Costs - Nurse Led Clinics |
|
R046 | - Specialty Costs - AHP Outpatient Clinics |
|
R048 | - Specialty Costs - Day Patients |
|
R060 | - Expenditure on Services Provided by AHPs |
|
R070-R110 | - Overheads |
|
R120 | - Radiology |
|
R130 | - Laboratories |
|
R140 | - Theatres |
|
R500s | - Community Health Services |
Note: the links above open MS Excel workbooks, the largest of which is approximately 935 KB.
Scottish Financial Returns (SFRs) 2013
The source data files in MS Excel for browsing or to download for further analysis.
All SFRs [2.5mb] - use Save option to download ZIP file
|
SFR 5.1A | - hospital summary statistics |
|
SFR 5.1B | - hospital staff & pay |
|
SFR 5.2 | - hospital running costs |
|
SFR 5.3 | - specialty analysis, inpatients |
|
SFR 5.5 | - specialty analysis, daycases | |
SFR 5.7 | - specialty analysis, outpatient consult clinics |
|
SFR 5.7n | - specialty analysis, nurse led clinics |
|
SFR 5.8 | - AHP outpatient clinics, by profession |
|
SFR 5.9 | - specialty analysis, day patients |
|
SFR 5.10 | - theatres summary |
|
SFR 5.11 | - radiology services |
| |
|
|
|
SFR 8.1 | - community staff & pay |
|
SFR 8.2 | - community running costs |
|
SFR 8.3 | - community services |
|
SFR 8.4 |
- family health services |
| |
|
|
|
SFR 24.0 | - NHS services provided by sub contracting |
|
SFR 27s | - laboratory services |
| |
|
|
|
SFRs | - full list of blank templates for 2012/13 |
Note: the links above open MS Excel workbooks, the largest of which is approximately 2.8 MB.
