We have detected that you are using Internet Explorer to visit this website. Internet Explorer is now being phased out by Microsoft. As a result, NHS Digital no longer supports any version of Internet Explorer for our web-based products, as it involves considerable extra effort and expense, which cannot be justified from public funds. Some features on this site will not work. You should use a modern browser such as Edge, Chrome, Firefox, or Safari. If you have difficulty installing or accessing a different browser, contact your IT support team.
EBSX reports
Extracts are data files that can be can be downloaded from the NHS e-Referral Service (e-RS). After being downloaded, extracts can be unzipped and imported into data analysis software.
We recommend you use a suitable application to open and analyse the reports, such as a relational database (for example, MS Access), as this will simplify creating the relationships between extracts. Excel spreadsheets may not be able to handle the amount of data in a report.
The supporting files below provide information on the extracts available and how to gain meaningful information. Included is a high level coding document to support information analysts in obtaining advice and guidance data required for the e-RS CQUIN (Commissioning for Quality and Innovation).
Find out further information about the extracts from the e-RS Help (N3/HSCN connection required).
Download EBSX05 reports
-
asset
ebsx05 March 2021 [zip, size: 5.4 MB]
-
asset
ebsx05 February 2021 [zip, size: 5.3 MB]
-
asset
ebsx05 January 2021 [zip, size: 5.3 MB]
-
asset
ebsx05 December 2020 [zip, size: 5.3 MB]
-
asset
ebsx05 November 2020 [zip, size: 6.1 MB]
-
asset
ebsx05 October 2020 [zip, size: 6.0 MB]
-
asset
ebsx05 September 2020 [zip, size: 5.2 MB]
-
asset
ebsx05 August 2020 [zip, size: 5.1 MB]
-
asset
ebsx05 July 2020 [zip, size: 5.1 MB]
-
asset
ebsx05 June 2020 [zip, size: 5.0 MB]
-
asset
ebsx05 May 2020 [zip, size: 4.9 MB]
-
asset
ebsx05 April 2020 [zip, size: 4.9 MB]
-
asset
ebsx05 March 2020 [zip, size: 4.9 MB]
-
asset
ebsx05 February 2020 [zip, size: 4.8 MB]
-
asset
ebsx05 January 2020 [zip, size: 4.6 MB]
-
asset
ebsx05 December 2019 [zip, size: 4.5 MB]
-
asset
ebsx05 November 2019 [zip, size: 4.5 MB]
-
asset
ebsx05 October 2019 [zip, size: 4.5 MB]
-
asset
ebsx05 September 2019 [zip, size: 4.4 MB]
-
asset
ebsx05 August 2019 [zip, size: 4.4 MB]
-
asset
ebsx05 July 2019 [zip, size: 4.4 MB]
-
asset
ebsx05 June 2019 [zip, size: 4.4 MB]
-
asset
ebsx05 May 2019 [zip, size: 4.3 MB]
-
asset
ebsx05 March 2019 [zip, size: 4.3 MB]
-
asset
ebsx05 April 2019 [zip, size: 4.3 MB]
-
asset
ebsx05 January 2019 [zip, size: 3.6 MB]
-
asset
ebsx05 February 2019 [zip, size: 3.7 MB]
-
asset
ebsx05 December 2018 [zip, size: 3.6 MB]
Download EBSX04 reports
-
asset
ebsx04 March 2021 [zip, size: 4.6 MB]
-
asset
ebsx04 February 2021 [zip, size: 4.5 MB]
-
asset
ebsx04 January 2021 [zip, size: 4.5 MB]
-
asset
ebsx04 December 2020 [zip, size: 4.5 MB]
-
asset
ebsx04 November 2020 [zip, size: 4.6 MB]
-
asset
ebsx04 October 2020 [zip, size: 4.6 MB]
-
asset
ebsx04 September 2020 [zip, size: 4.4 MB]
-
asset
ebsx04 August 2020 [zip, size: 4.4 MB]
-
asset
ebsx04 July 2020 [zip, size: 4.4 MB]
-
asset
ebsx04 June 2020 [zip, size: 4.4 MB]
-
asset
ebsx04 May 2020 [zip, size: 4.4 MB]
-
asset
ebsx04 April 2020 [zip, size: 4.4 MB]
-
asset
ebsx04 March 2020 [zip, size: 4.3 MB]
-
asset
ebsx04 February 2020 [zip, size: 4.3 MB]
-
asset
ebsx04 January 2020 [zip, size: 4.4 MB]
-
asset
ebsx04 December 2019 [zip, size: 3.7 MB]
-
asset
ebsx04 November 2019 [zip, size: 4.0 MB]
-
asset
ebsx04 October 2019 [zip, size: 4.3 MB]
-
asset
ebsx04 September 2019 [zip, size: 4.3 MB]
-
asset
ebsx04 August 2019 [zip, size: 4.3 MB]
-
asset
ebsx04 July 2019 [zip, size: 4.4 MB]
-
asset
ebsx04 June 2019 [zip, size: 4.4 MB]
-
asset
ebsx04 May 2019 [zip, size: 3.8 MB]
-
asset
ebsx04 April 2019 [zip, size: 3.8 MB]
-
asset
ebsx04 March 2019 [zip, size: 3.4 MB]
-
asset
ebsx04 February 2019 [zip, size: 3.8 MB]
-
asset
ebsx04 January 2019 [zip, size: 3.8 MB]
-
asset
ebsx04 December 2018 [zip, size: 3.8 MB]
Download other EBSX03 reports
-
asset
ebsx03 March 2021 [zip, size: 13.6 kB]
-
asset
ebsx03 February 2021 [zip, size: 13.6 kB]
-
asset
ebsx03 January 2021 [zip, size: 13.6 kB]
-
asset
ebsx03 December 2020 [zip, size: 13.5 kB]
-
asset
ebsx03 November 2020 [zip, size: 13.7 kB]
-
asset
ebsx03 October 2020 [zip, size: 13.7 kB]
-
asset
EBSX03 September 2020 [zip, size: 13.5 kB]
-
asset
EBSX03 August 2020 [zip, size: 13.5 kB]
-
asset
EBSX03 July 2020 [zip, size: 13.5 kB]
-
asset
EBSX03 June 2020 [zip, size: 13.5 kB]
-
asset
EBSX03 May 2020 [zip, size: 13.5 kB]
-
asset
EBSX03 April 2020 [zip, size: 13.5 kB]
-
asset
EBSX03 March 2020 [zip, size: 13.4 kB]
-
asset
EBSX03 February 2020 [zip, size: 13.4 kB]
-
asset
EBSX03 January 2020 [zip, size: 13.4 kB]
-
asset
EBSX03 December 2019 [zip, size: 13.4 kB]
-
asset
EBSX03 November 2019 [zip, size: 13.4 kB]
Visit our archive to see older reports.
Download our earlier reports through the national archive.
There are also further links to earlier reports from the national archive pages.
-
external
EBSX04 and EBSX05 for 2016 - 2018
EBSX04 and EBSX05 reports for 2016 - 2018.
-
external
EBSX03, EBSX04 and EBSX05 for 2015 and 2016.
Download links to earlier EBSX0s between 2015 - 2016
-
external
EBSX03, EBSX04 and EBSX05 for 2015 -2016
Provides a link to earlier EBSX03, EBSX04 and EBSX05 between 2015 -2016
Translating extracts
Our translating extracts instructions shows how to decode extract information to make it more meaningful. This is done using a VLOOKUP function within MS Excel. In this example, we're using the EBSX05, generally known as the directory of services (DoS) extract, but the same principles would apply to any of the extracts in the system.
Extracting advice and guidance information
Our extracting advice and guidance (A&G) information is aimed at information analysts and covers instructions and coding to extract A&G data from the EBSX02.
Users with the information analyst role have the ability to request information instantly from e-RS. Find out more in this advice and guidance enhanced reporting information.
Information can also be accessed from the system help function (N3/HSCN connection is required).
Extracts available
The following extracts are available to users with the information analyst role on their smartcards. They can be found on the reports section in e-RS. To view extracts in e-RS please use Internet Explorer 9, 10 or 11, Google Chrome or Mozilla Firefox.
- Up-to-date EBSX03, 04 and 05 extracts which do not contain any Personal Identifiable Data are published on this page
- EBSX02 UBRN action extract - daily and monthly CSV extract of ANY action on a UBRN within a reporting period - available at organisational level and as a national view
- EBSX03 codified fields extract - calendar monthly CSV extract which contains sufficient e-RS reference data for the reporting period that has just ended
- EBSX04 organisational extract - extract of all active organisations within a reporting period
- EBSX05 service extract - extract of all active services within a reporting period
- EBSX06 user extract - extract of all active users within a reporting period
- EBSX08 role profile extract - extract of all active unique user roles within a reporting period
- EBSX12 worklist drop offs - extract of all referrals, from the previous reporting week, that have dropped off the appointment slot issue and appointment for booking worklists, after 180 days of no activity