FOI-03226 - FOI_03226_Q3 - Open Data Portal

Skip to content

NEW Log in to the Open Data Portal to unlock additional features: find out more.

Alert 29 August 2025

Deployment completed.

The follow-up deployment on the NHSBSA Open Data Portal has now been completed. This release addresses outstanding actions from the previous update and delivers improvements as detailed in this news article.

If you encounter any issues or require support, please contact us at DataServicesSupport@nhsbsa.nhs.uk.

Additional Info

Field	Value
Data last updated	28 October 2025
Metadata last updated	28 October 2025
Created	28 October 2025
Format	text/csv
Licence	Open Government Licence 3.0 (United Kingdom)

Data Dictionary

Column	Title	Type	Description
REPORTING_YEAR	Reporting Year	date	The financial year which the activity relate to. Year-end methodology will include all activity data (including amendments) collected from FP17s scheduled in any of the fifteen schedule months from April to June, where the date of completion is on or between 1 April and 31 March of the year. For example 2019-20 will include all activity data (including amendments) collected from FP17s scheduled in any of the fifteen schedule months from April 2019 to June 2020, where the date of completion is on or between 1 April 2019 and 31 March 2020. Where FP17s do not have a date of completion, e.g. where the patient has failed to return to complete the treatment, the date of acceptance is used.
CONTRACT_NUMBER	Contract Number	integer	This is a unique 10 character number which identifies a contract
10_YEAR_BAND	10 Year Band	string	Age for the patient on the date of acceptance. Derived from patient date of birth and date of acceptance. Split in to 10 year groups.
UNIQUE_PATIENT_COUNT	Unique Patient Count	integer	This is a count of the unique patient identities on forms scheduled. A patient may have attended more than once in the time period and received different treatment, so the total figure has been adjusted for duplicate patient IDs. Patient identities are counted for all valid FP17 transactions – including amendment, deletion and withdrawn records. Therefore, it is possible for the count of patient identities to be greater than the count of FP17s.
UNIQUE_PATIENT_COUNT_ADULT	Unique Patient Count Adult	integer	This is a count of the unique patient identities on forms scheduled for adult patients. A patient may have attended more than once in the time period and received different treatment, so the total figure has been adjusted for duplicate patient IDs. Patient identities are counted for all valid FP17 transactions – including amendment, deletion and withdrawn records. Therefore, it is possible for the count of patient identities to be greater than the count of FP17s.
UNIQUE_PATIENT_COUNT_CHILDREN	Unique Patient Count Children	integer	This is a count of the unique patient identities on forms scheduled for child patients. A patient may have attended more than once in the time period and received different treatment, so the total figure has been adjusted for duplicate patient IDs. Patient identities are counted for all valid FP17 transactions – including amendment, deletion and withdrawn records. Therefore, it is possible for the count of patient identities to be greater than the count of FP17s.