Unofficial. This site is an experimental reformatting of data published by NHS England. It is not endorsed by NHS England. Always check the official Data Uses Register before relying on anything here.

Local Authority Public Health Pseudonymised HES Extract Service

Bracknell Forest Council · Local Authority

In term In term in the September 2026 edition: the latest version runs to 12 February 2029.

Reference
DARS-NIC-09901-F6V6M
Current version
v8.2
Term of current version
13 February 2026 to 12 February 2029
Start date
Before 1 April 2019
Data controller
Sole Data Controller
Commercial purposes
No
Sublicensing
No
Files released to date
484

Why the data was released

Objective for processing

The data provided by the pseudonymised HES Extract service will be used by the Local Authority in fulfilment of its public health function, specifically to support and improve:

1. the local responsiveness, targeting and value for money of commissioned public health services;

2. the statutory ‘core offer’ public health advice and support provided to local NHS commissioners;

3. the local specificity and relevance of the Joint Strategic Needs Assessments and Health and Wellbeing Strategies produced in collaboration with NHS and voluntary sector partners on the Health and Wellbeing Board;

4. the local focus, responsiveness and timeliness of health impact assessments;

5. the capability of the local public health intelligence service to undertake comparative longitudinal analyses of patterns and variations in:

a. the incidence and prevalence of disease and risks to public health;

b. demand for and access to treatment and preventative care services;

c. variations in health outcomes between groups in the population;

d. the level of integration between local health and care services; and

e. the local associations between causal risk factors and health status and outcomes.

The main statutory duties and wider public health responsibilities supporting these processing objectives are as follows:

1. Statutory public health duties that the data will be used to support

a) Duty to improve public health: Analyses of the data will be used to support the duty of the local authorities under Section 12 of the Health and Social Care Act 2012 to take appropriate steps to improve the health of the population, for example by providing information and advice, services and facilities, and incentives and assistance to encourage and enable people to lead healthier lives;

b) Duty to support Health and Wellbeing Boards: Analyses of the data will be used to support the duty of the local authorities and Integrated Care Board (ICB)-led Health and Wellbeing Board under Section 194 of the 2012 Act to improve health and wellbeing, reduce health inequalities, and promote the integration of health and care services. The data will also be used to support the statutory duty of Health and Wellbeing Boards under Section 206 of the 2012 Act to undertake Pharmaceutical Needs Assessments;

c) Duty to produce Joint Strategic Needs Assessments (JSNAs) and Joint local Health and Wellbeing Strategies (JHWBs): Analyses of the data will be used to support the duty of the Local Authority under Sections 192 and 193 of the 2012 Act to consult on and publish JSNAs and JHWSs that assess the current and future health and wellbeing needs of the local population;

d) Duty to commission specific public health services: Analyses of the data will be used to support the Local Authority to discharge its duty under the Local Authorities Regulations 2013 to plan and provide NHS Health Check assessments, the National Child Measurement Programme and open access sexual health services;

e) Duty to provide public health advice to NHS commissioners: Analyses of the data will be used by Local Authorities to discharge its duty under the 2013 Regulations to provide a public health advice service to NHS commissioners;

f) Duty to publish an annual public health report: Analyses of the data will be used by Directors of Public Health to support their duty to prepare and publish an annual report on the health of the local population under Section 31 the 2012 Act;

g) Public Health responses on behalf of the Local Authority to licensing applications and other statutory Local Authority functions requiring public health input: Analyses of the data will be used by the Director of Public Health to support their duty under Part 3 of the National Health Services Act 2006 (as amended by Section 30 of the Health and Social Care Act 2012) to provide the Local Authority’s public health response (as the responsible authority under the Licensing Act 2003, as amended by the Health and Social Care Act 2012 Schedule 5 – Part 1) to licensing applications.

2. Wider public health responsibilities supported by analysis of the data

a) Health impact assessments and equity audits: Analyses of the data will be used to assess the potential impacts on health and the wider social economic and environmental determinants of health of Local Authority strategic plans, policies and services;

b) Local health profiles: Analyses of the data will be used to support the production of locally-commissioned health profiles to improve understanding of the health priorities of local areas and guide strategic commissioning plans by focusing, for example, on:

i. bespoke local geographies (based on the non-standard aggregation of LSOAs);

ii. specific demographic, geographic, ethnic and socio-economic groups in the population;

iii. inequalities in health status, access to treatment and treatment outcomes;

c) Surveillance of trends in health status and health outcomes: Analyses of the data will be used for the longitudinal monitoring of trends in the incidence, prevalence, treatment and outcomes for a wide range of diseases and other risks to public health;

d) Responsive and timely local health intelligence service: Analyses of the data will be used to respond to ad hoc internal and external requests for information and intelligence on the health status and outcomes of the local population generated and received by the Director of Public Health and their team.

These lists of the statutory duties and wider public health responsibilities of local authorities are not exhaustive but set the broad parameters for how the data will be used by the Local Authority to help improve and protect public health, and reduce health inequalities. All such use would be in fulfilment of the public health function of the local authorities.

No identifiable data is requested under this agreement. The data provided would include derived demographic and geographic fields, the standard non-sensitive HES diagnostic and operative fields, and a common (across all Local Authorities) pseudo ID to enable admissions to be linked over time.

Legal Basis - GDPR:

Article 6(1)(e)

(processing is necessary for the performance of a task in the public interest or in the exercise of official authority vested in the controller)

Public Authority: The Data Protection Act 2018 s7(1)(a) defines ‘public bodies’ for the purpose of the GDPR as “a public authority as defined by the Freedom of Information Act 2000”.

The FOI Act 2000 Part 1, section 3 (1)(a)(i) specifies that a public authority means any body which is listed in Schedule 1.

Schedule 1 of the FOI Act 2000 lists Local authorities within the meaning of the Local Government Act 1972 as public authorities.

‘Public Task’

Local Authorities

Local Authorities have a legal responsibility under Section (1)(2)(3)(4)(5)(6)(7) of the Care Act 2014 to conduct tasks that are in the public interest to:

(1) Promoting individual well-being

(2) Preventing needs for care and support

(3) Promoting integration of care and support with health services etc.

(4) Providing information and advice

(5) Promoting diversity and quality in provision of services

(6) Co-operating generally

(7) Co-operating in specific cases

(8) Duty to meet needs for care and support

The task(s) are necessary (but are by no means an exhaustive list), but provides an indication of the many tasks required under Part 1 of the Care Act 2014 as the council has an obligation to the public to deliver services that are a necessity to the local population - from whom funding is provided to deliver these services/tasks in the form of Council Tax.

Local Authorities have a duty under Section 74 (1)(2)(3)(4) of the NHS Act 2006 to supply goods and services:

(1) In the Local Authorities (Goods and Services) Act 1970 (c. 39) the expression “public body” includes—

(a) any Strategic Health Authority, Special Health Authority or Primary Care Trust, and

(b) so far as relates to his functions under this Act, the Secretary of State.

(2) Subsection (1) has effect as if made by an order under section 1(5) of the Local Authorities (Goods and Services) Act 1970 and may be varied or revoked by such an order.

(3) Each local authority must make services available to each NHS body acting in its area, so far as is reasonably necessary and practicable to enable the NHS body to discharge its functions under this Act.

(4) “Services” means the services of persons employed by the local authority for the purposes of its functions under the Local Authority Social Services Act 1970 (c. 42).

As part of the application process, the requirement for the data requested has been assessed and NHS England is content that it is appropriate, necessary and proportionate for the performance of the task described in the Purpose statement.

‘Necessity’: Throughout the application process, the necessity of the processing for the performance of the task has been assessed. This included but was not limited to ensuring appropriate minimisation of the data to ensure that only the minimum amount of data required are processed. During the application process it has been considered whether the information that the processing aims to determine is already available from other sources or whether the task could be performed using publicly available data or data from alternative sources than NHS Engalnd. Consideration has been given to whether the volume of data being requested is proportionate to the expected benefit and, through examination of the expected benefits consideration has been given to whether the task is itself necessary.

Therefore, we are satisfied that this request is appropriate, necessary and proportionate for the performance of the task described in the Purpose statement and that there is no other reasonable means for the data processor to achieve their purpose that is less intrusive to the data subjects.

Article 9(2)(h)

(processing is necessary for the purposes of preventive or occupational medicine, for the assessment of the working capacity of the employee, medical diagnosis, the provision of health or social care or treatment or the management of health or social care systems and services on the basis of Union or Member State law or pursuant to contract with a health professional and subject to the conditions and safeguards referred to in paragraph 3)

• The data are required for the purpose of commissioning.

• The data required by the data controllers is the least intrusive to the data subject possible to be able to conduct their functions.

• The data required for commissioning purposes is pseudonymised by NHS England to minimise the risk of identification.

As part of the standard Data Access Request Service application process:

• the applicant’s technical and organisational measures to safeguard the data have been assessed and meets NHS England’s acceptance criteria;

• the requested data has been assessed as proportionate to the aim pursued;

• respect to the essence of the right to data protection has been assessed (e.g. security assurance, data retention, controls and processing activities, etc.);

• measures to protect the rights and freedoms of data subjects have been assessed including transparency (fair processing) publishing subject’s rights to withdraw consent and/or have their data erased or rectified, etc.

Article 9(3)

(Personal data referred to in paragraph 1 may be processed for the purposes referred to in point (h) of paragraph 2 when those data are processed by or under the responsibility of a professional subject to the obligation of professional secrecy under Union or Member State law or rules established by national competent bodies or by another person also subject to an obligation of secrecy under Union or Member State law or rules established by national competent bodies.)

Director of Public Health is not an employee of this local authority so signatory and IAO in this case is Borough Solicitor. Relevant changes made in the Processing Section

Bracknell Forest Council hosts a shared Public Health Team, as part of a joint agreement with the five other local authorities in Berkshire (Reading Borough Council, Slough Borough Council, West Berkshire Council, Royal Borough of Windsor & Maidenhead and Wokingham Borough Council). The Team includes the Director of Public Health, who has statutory responsibility for public health leadership across Berkshire, as well as a shared Informatics function. Bracknell have confirmed that only aggregate data with small numbers suppressed will be made available to the other local authorities.

Processing activities

Bracknell Forest Council hosts the Berkshire East Public Health Hub, as part of a joint agreement with the two other local authorities in Berkshire East (Slough Borough Council and the Royal Borough of Windsor & Maidenhead). The Team includes the Director of Public Health, who has statutory responsibility for public health leadership across Berkshire East, as well as a shared Informatics function. The Berkshire East Public Health Hub continues to provide some informatics/analytical support to the Berkshire West local authorities (Reading Borough Council, West Berkshire Council and Wokingham Borough Council), which includes the storage and processing of data related to these geographical areas.

The data access agreement between NHS England and Bracknell Forest Council for the pseudonymised HES Extract Service will enable the local authorities to undertake a wide range of locally-determined and locally-specific analyses to support the effective and efficient discharge of the statutory duties in relation to health, and wider public health responsibilities.

Pseudonymised HES data is provided to Bracknell Forest Council only, who act as the data controller and data processor for this access agreement. The data will only be processed by Local Authority employees in the fulfilment of their public health function and only for the health purposes outline above.

Record-level data will be shared with the Berkshire West Hub Informatics Team via a secure and direct link into the dedicated Public Health server that is held by Bracknell Forest Council. This ensures that all six local authority teams have equitable access to the analytics informed by this dataset. Both Hub Teams will ensure that all data are aggregated and small numbers suppressed before sharing any wider, in line with the HES Analysis Guide. The data will only be made available to the Berkshire local authorities for the fulfilment of their public health functions and only for the health purposes outline above.

Data will not be transferred or otherwise made available to any third party, including Commissioning Support Units, Data Services for Commissioners Regional Offices, any organisation for the purposes of health research, or any Business Intelligence company providing analysis and intelligence services (whether under formal contract or not) to / or on behalf of the Local Authority.

The Local Authority will use the data to produce a range of quantitative measures (counts, crude and standardised rates and ratios) that will form the basis for a range of statistical analyses of the fields contained in the supplied data. Typical uses will include:

1. Analyses of disease incidence, prevalence and trends: The age, sex, LSOA, ethnic group, Indices of Deprivation and diagnosis fields typically will be used to produce directly standardised coronary heart disease admission rates for the Local Authority, and for appropriate benchmark and comparator areas. Confidence intervals will then be produced for these rates, and the rates analysed using statistical process control methods, to determine whether there are any significant variations in the prevalence of heart disease with the Local Authority. The data will also be used to analyse changes over time in the prevalence of heart disease. The results of these analyses will then be used to inform the production of local health profiles, JSNAs and JHWSs; support the core offer public health advice provided by the Director of Public Health to NHS commissioners; and advise any enquiries into health inequalities requested by the Health and Wellbeing Board.

2. Analyses of hospital admission rates: The data will also be used, for example, to produce comparative and longitudinal hospital admission rates among children and young people, particularly for injury and self-harm, to support the overarching responsibility of the Local Authority to safeguard and promote the health and welfare of all children and young people under the 1989 and 2004 Children Acts. Statistics based on these analyses will be used by the Director of Public Health to advise the Director of Children’s Services and Lead Member for Children’s Services, and inform and guide the provision of safeguarding services by the Local Authority.

Conditions of supply and controls on use

In addition to those outlined elsewhere within this application, the Local Authority will:

1. only use the HES/ECDS data for the purposes as outlined in this agreement;

2. comply with the requirements of the Code of Practice on Confidential Information, the Caldicott Principles and other relevant statutory requirements and guidance to protect confidentiality;

3. not attempt any record-level linkage of HES/ECDS data with other data sets held by the Local Authority, or attempt to identify any individuals from the HES/ECDS data;

4. not transfer and disseminate record-level HES/ECDS data to anyone outside the Local Authority;

5. not publish the results of any analyses of the HES/ECDS data unless safely de-identified in line with the anonymisation standard; and

6. comply with the guidelines set out in the HES Analysis Guide;

7. ensure role-based control access is in place to manage access to the HES/ECDS data within the Local Authority.

The Borough Solicitor will be the Information Asset Owner for the HES/ECDS data and be responsible on behalf of the Local Authority to NHS England for ensuring that the data supplied is only used in fulfilment of the approved public health purposes as set out in this application. The Local Authority confirms that the Borough Solicitor is a contracted employee to the permanent role within the Local Authority, accountable to the Chief Executive.

Data retention

A maximum of ten years data will be retained at any point, such that as each new data year is received, the oldest year will be deleted (i.e. at any point in time only ten historic years of data plus the current year may be held). The Local Authority will securely destroy the earliest year of data and complete a data destruction certificate to NHS England once deletion has occurred. This will confirm the date the last backup will be destroyed, ensuring no data has been kept longer than the agreed ten year maximum.

Bracknell Forest Council have opted to use Section 8.4 Data Removal from Live Systems, from the NHS England Destruction and Disposal of Sensitive Data, Good Practice Guidelines as the destruction model.

The historic data will be used by the Local Authority in fulfilment of its public health function, and specifically to:

a) recognise and monitor trends in disease incidence and prevalence and other risks to public health;

b) recognise and monitor trends in treatment patterns, particularly hospital readmissions, and outcomes;

c) recognise and monitor trends in access to treatment and care between demographic, geographic, ethnic and socio-economic groups in the population; and

d) recognise and monitor trends in the association between the wider social, economic and environmental determinants of health and health outcomes for the purpose of informing the planning, commissioning and provision of effective health and care services at a local level.

Expected output

The results of the analyses of the data will be used by the Local Authority to support the discharge of its statutory duties in relation to public health, and wider public health responsibilities. Outputs will include (but not be limited to) the routine and ad hoc production of:

a) Joint Strategic Needs Assessments;

b) Joint local Health and Wellbeing Strategies;

c) the annual report of the Director of Public Health;

d) reports commissioned by the Health and Wellbeing Boards;

e) public health and wider Local Authority health and wellbeing commissioning strategies and plans;

f) public health advice to local Integrated Care Boards and Primary Care Networks;

g) responses to licensing applications and other statutory Local Authority functions requiring public health input;

h) local health profiles;

i) health impact assessments and equity audits;

j) health needs assessments, such as the Pharmaceutical Needs Assessment;

k) responses to internal and external requests for information and intelligence on the health and wellbeing of the population.

The specific content of and target dates for these outputs will be for the Local Authority to determine, although it is required to comply with national guidance published by the Department of Health, UK Health Security Agency and others as appropriate, for example, on the timetable for publishing refreshed JSNAs.

All outputs will be of aggregated data with small numbers suppressed in line with the HES Analysis Guide.

Expected measurable benefits

Access to the data will enable the Local Authority to undertake locally-focused and locally-responsive analyses of health status and health outcomes. For example, the data will be used to produce analyses of health inequalities for non-standard geographies and for specific social or ethnic groups in the local population to help ensure that the health challenges facing the local population – particularly the most disadvantaged – have been identified and responded to appropriately by the Local Authority and its partners.

It is recognised that in fulfilling its public health duties using HES data, the Local Authority will deliver significant benefits. The Local Authority therefore commits in any renewal request to providing additional detail on benefits that relate to their local use of the data once implemented.

Benefits reported so far

The local authority now have a data warehouse containing HES Accident and Emergency and Admitted Patient Care data. The HES data has been decoded using look-up tables and the NHS Data Dictionary. This allows the data to be aggregated by a range of different geographies and key demographics in order to understand the health of the local population. The aim is for a timely annual refresh of the data in order to provide responsive local data analysis.

During 2022, the Berkshire East and Berkshire West local authorities relaunched their JSNAs and have reviewed the use of data to inform priority setting. The HES data was used to identify how the rate of admissions had changed by agebands and also cause of admission. Additional work has also continued to understand how hospital admissions vary across sub-LA geographies and communities.

Examples of other analyses include:

- Analysis of admissions for the top ten cause of admissions

- Analysis of patterns in self-harm admissions

- Admissions for mental health conditions for younger people

- Admissions related to the night-time economy

Datasets on the current version

Legal basis for provision: Health and Social Care Act 2012 – s261(2)(a)

Datasets approved under DARS-NIC-09901-F6V6M-v8.2
DatasetType of dataSensitivity FrequencyConfidential data
Emergency Care Data Set (ECDS) Anonymised - ICO Code Compliant Sensitive Ongoing Does not include the flow of confidential data
HES-ID to MPS-ID HES Accident and Emergency Anonymised - ICO Code Compliant Non-Sensitive One-Off Does not include the flow of confidential data
HES-ID to MPS-ID HES Admitted Patient Care Anonymised - ICO Code Compliant Non-Sensitive One-Off Does not include the flow of confidential data
HES-ID to MPS-ID HES Outpatients Anonymised - ICO Code Compliant Non-Sensitive One-Off Does not include the flow of confidential data
Hospital Episode Statistics Accident and Emergency (HES A and E) Anonymised - ICO Code Compliant Non-Sensitive Ongoing Does not include the flow of confidential data
Hospital Episode Statistics Admitted Patient Care (HES APC) Anonymised - ICO Code Compliant Non-Sensitive Ongoing Does not include the flow of confidential data
Hospital Episode Statistics Critical Care (HES Critical Care) Anonymised - ICO Code Compliant Non-Sensitive Ongoing Does not include the flow of confidential data
Hospital Episode Statistics Outpatients (HES OP) Anonymised - ICO Code Compliant Non-Sensitive Ongoing Does not include the flow of confidential data

Files released

Files released counts only files released externally by DARS. Access granted in NHS England's own systems, such as its Secure Data Environment, is not included.

Patient opt-outs were not applied to any of the 484 files released under this agreement, across every version. About opt-outs

Files released against version 8.2 of this agreement, summarised by dataset.

Files released under DARS-NIC-09901-F6V6M-v8.2
DatasetFilesFirst releasedLast releasedOpt-outs applied
Hospital Episode Statistics Admitted Patient Care (HES APC)6 April 2026August 2026No
Hospital Episode Statistics Critical Care (HES Critical Care)6 April 2026August 2026No
Hospital Episode Statistics Outpatients (HES OP)6 April 2026August 2026No
Emergency Care Data Set (ECDS)3 May 2026August 2026No

Version history

The register lists each renewal of this agreement as a separate row. This site has 5 versions — earlier versions existed before this site's records begin.

DARS-NIC-09901-F6V6M-v8.2 13 February 2026 to 12 February 2029
Title
Local Authority Public Health Pseudonymised HES Extract Service
Commercial
No
Sublicensing
No
Datasets
8
Files released
21

Datasets: Emergency Care Data Set (ECDS); HES-ID to MPS-ID HES Accident and Emergency; HES-ID to MPS-ID HES Admitted Patient Care; HES-ID to MPS-ID HES Outpatients; Hospital Episode Statistics Accident and Emergency (HES A and E); Hospital Episode Statistics Admitted Patient Care (HES APC); Hospital Episode Statistics Critical Care (HES Critical Care); Hospital Episode Statistics Outpatients (HES OP)

What changed from DARS-NIC-09901-F6V6M-v7.3

Text removed is struck through; text added is underlined. Unchanged paragraphs are summarised rather than repeated.

Fields changed from DARS-NIC-09901-F6V6M-v7.3
FieldWasBecame
Start date2023-05-012026-02-13
End date2026-04-302029-02-12

Objective for processing

[70 paragraphs unchanged] Legal Basis - Common Law Duty of Confidentiality: The Data disseminated under this agreement is not considered confidential under the Health and Social Care Act 2012 and therefore is not owed a duty of confidence. [2 paragraphs unchanged]

Unchanged: Processing activities, Expected output, Expected measurable benefits, Benefits reported.

DARS-NIC-09901-F6V6M-v7.3 1 May 2023 to 30 April 2026
Title
Local Authority Public Health Pseudonymised HES Extract Service
Commercial
No
Sublicensing
No
Datasets
8
Files released
86

Datasets: Emergency Care Data Set (ECDS); HES-ID to MPS-ID HES Accident and Emergency; HES-ID to MPS-ID HES Admitted Patient Care; HES-ID to MPS-ID HES Outpatients; Hospital Episode Statistics Accident and Emergency (HES A and E); Hospital Episode Statistics Admitted Patient Care (HES APC); Hospital Episode Statistics Critical Care (HES Critical Care); Hospital Episode Statistics Outpatients (HES OP)

What changed from DARS-NIC-09901-F6V6M-v6.5

Text removed is struck through; text added is underlined. Unchanged paragraphs are summarised rather than repeated.

Fields changed from DARS-NIC-09901-F6V6M-v6.5
FieldWasBecame
Start date2021-04-012023-05-01
End date2023-04-302026-04-30
Emergency Care Data Set (ECDS): legal basisHealth and Social Care Act 2012 - s261 - 'Other dissemination of information'Health and Social Care Act 2012 – s261(2)(a)
HES-ID to MPS-ID HES Accident and Emergency: legal basisHealth and Social Care Act 2012 - s261 - 'Other dissemination of information'Health and Social Care Act 2012 – s261(2)(a)
HES-ID to MPS-ID HES Admitted Patient Care: legal basisHealth and Social Care Act 2012 - s261 - 'Other dissemination of information'Health and Social Care Act 2012 – s261(2)(a)
HES-ID to MPS-ID HES Outpatients: legal basisHealth and Social Care Act 2012 - s261 - 'Other dissemination of information'Health and Social Care Act 2012 – s261(2)(a)
Hospital Episode Statistics Accident and Emergency (HES A and E): legal basisHealth and Social Care Act 2012 - s261 - 'Other dissemination of information'Health and Social Care Act 2012 – s261(2)(a)
Hospital Episode Statistics Admitted Patient Care (HES APC): legal basisHealth and Social Care Act 2012 - s261 - 'Other dissemination of information'Health and Social Care Act 2012 – s261(2)(a)
Hospital Episode Statistics Critical Care (HES Critical Care): legal basisHealth and Social Care Act 2012 - s261 - 'Other dissemination of information'Health and Social Care Act 2012 – s261(2)(a)
Hospital Episode Statistics Outpatients (HES OP): legal basisHealth and Social Care Act 2012 - s261 - 'Other dissemination of information'Health and Social Care Act 2012 – s261(2)(a)

Objective for processing

The data provided by the pseudonymised HES Extract service will be used to fulfil by the Local Authority in fulfilment of its public health function of Bracknell Forest County Council, function, specifically to support and improve: [13 paragraphs unchanged] b) Duty to support Health and Wellbeing Boards: Analyses of the data will be used to support the duty of the local authorities and Clinical Commissioning Group (CCG)-led Integrated Care Board (ICB)-led Health and Wellbeing Board under Section 194 of the 2012 Act to [32 words unchanged] under Section 206 of the 2012 Act to undertake Pharmaceutical Needs Assessments; c) Duty to produce Joint Strategic Needs Assessments (JSNAs) and Joint local Health and Wellbeing Strategies (JHWBs): Analyses of the data will be used [27 words unchanged] the current and future health and wellbeing needs of the local population; [6 paragraphs unchanged] b) Local health profiles: Analyses of the data will be used to support the production of locally-commissioned health profiles to improve understand understanding of the health priorities of local areas and guide strategic commissioning plans by focusing, for example, on: [6 paragraphs unchanged] No sensitive identifiable data is requested under this application. agreement. The data provided would include derived demographic and geographic fields, the standard non-sensitive HES diagnostic and operative fields, and a common (across all Local Authorities) pseudoHESID pseudo ID to enable admissions to be linked over time. Legal Basis - GDPR: Article 6(1)(e) (processing is necessary for the performance of a task in the public interest or in the exercise of official authority vested in the controller) Public Authority: The Data Protection Act 2018 s7(1)(a) defines ‘public bodies’ for the purpose of the GDPR as “a public authority as defined by the Freedom of Information Act 2000”. The FOI Act 2000 Part 1, section 3 (1)(a)(i) specifies that a public authority means any body which is listed in Schedule 1. Schedule 1 of the FOI Act 2000 lists Local authorities within the meaning of the Local Government Act 1972 as public authorities. ‘Public Task’ Local Authorities Local Authorities have a legal responsibility under Section (1)(2)(3)(4)(5)(6)(7) of the Care Act 2014 to conduct tasks that are in the public interest to: (1) Promoting individual well-being (2) Preventing needs for care and support (3) Promoting integration of care and support with health services etc. (4) Providing information and advice (5) Promoting diversity and quality in provision of services (6) Co-operating generally (7) Co-operating in specific cases (8) Duty to meet needs for care and support The task(s) are necessary (but are by no means an exhaustive list), but provides an indication of the many tasks required under Part 1 of the Care Act 2014 as the council has an obligation to the public to deliver services that are a necessity to the local population - from whom funding is provided to deliver these services/tasks in the form of Council Tax. Local Authorities have a duty under Section 74 (1)(2)(3)(4) of the NHS Act 2006 to supply goods and services: (1) In the Local Authorities (Goods and Services) Act 1970 (c. 39) the expression “public body” includes— (a) any Strategic Health Authority, Special Health Authority or Primary Care Trust, and (b) so far as relates to his functions under this Act, the Secretary of State. (2) Subsection (1) has effect as if made by an order under section 1(5) of the Local Authorities (Goods and Services) Act 1970 and may be varied or revoked by such an order. (3) Each local authority must make services available to each NHS body acting in its area, so far as is reasonably necessary and practicable to enable the NHS body to discharge its functions under this Act. (4) “Services” means the services of persons employed by the local authority for the purposes of its functions under the Local Authority Social Services Act 1970 (c. 42). As part of the application process, the requirement for the data requested has been assessed and NHS England is content that it is appropriate, necessary and proportionate for the performance of the task described in the Purpose statement. ‘Necessity’: Throughout the application process, the necessity of the processing for the performance of the task has been assessed. This included but was not limited to ensuring appropriate minimisation of the data to ensure that only the minimum amount of data required are processed. During the application process it has been considered whether the information that the processing aims to determine is already available from other sources or whether the task could be performed using publicly available data or data from alternative sources than NHS Engalnd. Consideration has been given to whether the volume of data being requested is proportionate to the expected benefit and, through examination of the expected benefits consideration has been given to whether the task is itself necessary. Therefore, we are satisfied that this request is appropriate, necessary and proportionate for the performance of the task described in the Purpose statement and that there is no other reasonable means for the data processor to achieve their purpose that is less intrusive to the data subjects. Article 9(2)(h) (processing is necessary for the purposes of preventive or occupational medicine, for the assessment of the working capacity of the employee, medical diagnosis, the provision of health or social care or treatment or the management of health or social care systems and services on the basis of Union or Member State law or pursuant to contract with a health professional and subject to the conditions and safeguards referred to in paragraph 3) • The data are required for the purpose of commissioning. • The data required by the data controllers is the least intrusive to the data subject possible to be able to conduct their functions. • The data required for commissioning purposes is pseudonymised by NHS England to minimise the risk of identification. As part of the standard Data Access Request Service application process: • the applicant’s technical and organisational measures to safeguard the data have been assessed and meets NHS England’s acceptance criteria; • the requested data has been assessed as proportionate to the aim pursued; • respect to the essence of the right to data protection has been assessed (e.g. security assurance, data retention, controls and processing activities, etc.); • measures to protect the rights and freedoms of data subjects have been assessed including transparency (fair processing) publishing subject’s rights to withdraw consent and/or have their data erased or rectified, etc. Article 9(3) (Personal data referred to in paragraph 1 may be processed for the purposes referred to in point (h) of paragraph 2 when those data are processed by or under the responsibility of a professional subject to the obligation of professional secrecy under Union or Member State law or rules established by national competent bodies or by another person also subject to an obligation of secrecy under Union or Member State law or rules established by national competent bodies.) Legal Basis - Common Law Duty of Confidentiality: The Data disseminated under this agreement is not considered confidential under the Health and Social Care Act 2012 and therefore is not owed a duty of confidence. Director of Public Health is not an employee of this local authority so signatory and IAO in this case is Borough Solicitor. Relevant changes made in the Processing Section Bracknell Forest Council hosts a shared Public Health Team, as part of a joint agreement with the five other local authorities in Berkshire (Reading Borough Council, Slough Borough Council, West Berkshire Council, Royal Borough of Windsor & Maidenhead and Wokingham Borough Council). The Team includes the Director of Public Health, who has statutory responsibility for public health leadership across Berkshire, as well as a shared Informatics function. Bracknell have confirmed that only aggregate data with small numbers suppressed will be made available to the other local authorities.

Processing activities

Bracknell Forest Council hosts a shared the Berkshire East Public Health Team, Hub, as part of a joint agreement with the five two other local authorities in Berkshire (Reading East (Slough Borough Council, Slough Borough Council, West Berkshire Council, Council and the Royal Borough of Windsor & Maidenhead and Wokingham Borough Council). Maidenhead). The Team includes the Director of Public Health, who has statutory responsibility for public health leadership across Berkshire, Berkshire East, as well as a shared Informatics function. The data access agreement between NHS Digital and Bracknell Forest Council for Berkshire East Public Health Hub continues to provide some informatics/analytical support to the pseudonymised HES Extract Service will enable the Berkshire West local authorities (Reading Borough Council, West Berkshire Council and Wokingham Borough Council), which includes the storage and processing of data related to undertake a wide range of locally-determined and locally-specific analyses to support the effective and efficient discharge of the statutory duties in relation to health, and wider public health responsibilities. these geographical areas. Pseudonymised HES data is provided to Bracknell Forest Council only, who act as the data controller and data processor for this access agreement. The data will only be processed by Local Authority employees in fulfilment of their public health function and only for the health purposes outline above. In addition, aggregated data with small numbers suppressed will also be made available to the other five Berkshire local authorities for the fulfilment of their public health functions and only for the health purposes outline above. Record-level data will not be shared with the other local authorities and all outputs will be of aggregated data with small numbers suppressed in line with the HES Analysis Guide. The data access agreement between NHS England and Bracknell Forest Council for the pseudonymised HES Extract Service will enable the local authorities to undertake a wide range of locally-determined and locally-specific analyses to support the effective and efficient discharge of the statutory duties in relation to health, and wider public health responsibilities. Pseudonymised HES data is provided to Bracknell Forest Council only, who act as the data controller and data processor for this access agreement. The data will only be processed by Local Authority employees in the fulfilment of their public health function and only for the health purposes outline above. Record-level data will be shared with the Berkshire West Hub Informatics Team via a secure and direct link into the dedicated Public Health server that is held by Bracknell Forest Council. This ensures that all six local authority teams have equitable access to the analytics informed by this dataset. Both Hub Teams will ensure that all data are aggregated and small numbers suppressed before sharing any wider, in line with the HES Analysis Guide. The data will only be made available to the Berkshire local authorities for the fulfilment of their public health functions and only for the health purposes outline above. [2 paragraphs unchanged] 1. Analyses of disease incidence, prevalence and trends: The age, sex, LSOA, [95 words unchanged] inform the production of local health profiles, JSNAs and JHWSs; support the ‘core offer’ core offer public health advice provided by the Director of Public Health to NHS commissioners; and advise any enquiries into health inequalities requested by the Health and Wellbeing Board. 2. Analyses of hospital admission rates: Data The data will also be used used, for example, to produce comparative and longitudinal hospital admission rates. An example of this would be rates among children and young people, particularly for injury and self-harm in children and young people self-harm, to support the overarching responsibility of the Local Authority to safeguard and [46 words unchanged] inform and guide the provision of safeguarding services by the Local Authority. [2 paragraphs unchanged] 1. only use the HES HES/ECDS data for the purposes as outlined in this agreement; 2. comply with the requirements of NHS Digital the Code of Practice on Confidential Information, the Caldicott Principles and other relevant statutory requirements and guidance to protect confidentiality; 3. not attempt any record-level linkage of HES HES/ECDS data with other data sets held by the Local Authority, or attempt to identify any individuals from the HES HES/ECDS data; 4. not transfer and disseminate record-level HES HES/ECDS data to anyone outside the Local Authority; 5. not publish the results of any analyses of the HES HES/ECDS data unless safely de-identified in line with the anonymisation standard; and [1 paragraph unchanged] 7. ensure role-based control access is in place to manage access to the HES HES/ECDS data within the Local Authority. The Borough Solicitor will be the Information Asset Owner for the HES HES/ECDS data and be responsible on behalf of the Local Authority to NHS Digital England for ensuring that the data supplied is only used in fulfilment of [24 words unchanged] the permanent role within the Local Authority, accountable to the Chief Executive. [1 paragraph unchanged] A maximum of ten years data will be retained at any point, [41 words unchanged] earliest year of data and complete a data destruction certificate to NHS Digital England once deletion has occurred. This will confirm the date the last backup will be destroyed, ensuring no data has been kept longer than the agreed ten year maximum. Bracknell Forest Council have opted to use Section 8.4 Data Removal from Live Systems, from the NHS Digital England Destruction and Disposal of Sensitive Data, Good Practice Guidelines as the destruction model. [5 paragraphs unchanged]

Expected output

[2 paragraphs unchanged] b) Joint local Health and Wellbeing Strategies; [1 paragraph unchanged] d) reports commissioned by the Health and Wellbeing Board; Boards; [1 paragraph unchanged] f) public health advice to local CCGs, STPs Integrated Care Boards and ICSs; Primary Care Networks; [5 paragraphs unchanged] The specific content of and target dates for these outputs will be [9 words unchanged] required to comply with national guidance published by the Department of Health, Public UK Health England Security Agency and others as appropriate, for example, on the timetable for publishing refreshed JSNAs. [1 paragraph unchanged]

Benefits reported

Feb 2021 [1 paragraph unchanged] During 2020/21, a great deal of analytical time has been spent on the response to the covid-19 pandemic. However, the HES data has been utilized for a number of reports that have enabled local public health teams to ask for more detailed analyses for hospital admission activity and has helped to inform a number of different public health projects. . Examples include a deep-dive in to alcohol related admissions in Bracknell Forest with an emphasis on alcohol-related cancers in females. Other examples include: During 2022, the Berkshire East and Berkshire West local authorities relaunched their JSNAs and have reviewed the use of data to inform priority setting. The HES data was used to identify how the rate of admissions had changed by agebands and also cause of admission. Additional work has also continued to understand how hospital admissions vary across sub-LA geographies and communities. Examples of other analyses include: [2 paragraphs unchanged] - Admissions of falls - Admissions for mental health conditions for younger people - Admissions for mental health conditions - Admissions related to the night-time economy

Unchanged: Expected measurable benefits.

Objective for processing

The data provided by the pseudonymised HES Extract service will be used by the Local Authority in fulfilment of its public health function, specifically to support and improve:

1. the local responsiveness, targeting and value for money of commissioned public health services;

2. the statutory ‘core offer’ public health advice and support provided to local NHS commissioners;

3. the local specificity and relevance of the Joint Strategic Needs Assessments and Health and Wellbeing Strategies produced in collaboration with NHS and voluntary sector partners on the Health and Wellbeing Board;

4. the local focus, responsiveness and timeliness of health impact assessments;

5. the capability of the local public health intelligence service to undertake comparative longitudinal analyses of patterns and variations in:

a. the incidence and prevalence of disease and risks to public health;

b. demand for and access to treatment and preventative care services;

c. variations in health outcomes between groups in the population;

d. the level of integration between local health and care services; and

e. the local associations between causal risk factors and health status and outcomes.

The main statutory duties and wider public health responsibilities supporting these processing objectives are as follows:

1. Statutory public health duties that the data will be used to support

a) Duty to improve public health: Analyses of the data will be used to support the duty of the local authorities under Section 12 of the Health and Social Care Act 2012 to take appropriate steps to improve the health of the population, for example by providing information and advice, services and facilities, and incentives and assistance to encourage and enable people to lead healthier lives;

b) Duty to support Health and Wellbeing Boards: Analyses of the data will be used to support the duty of the local authorities and Integrated Care Board (ICB)-led Health and Wellbeing Board under Section 194 of the 2012 Act to improve health and wellbeing, reduce health inequalities, and promote the integration of health and care services. The data will also be used to support the statutory duty of Health and Wellbeing Boards under Section 206 of the 2012 Act to undertake Pharmaceutical Needs Assessments;

c) Duty to produce Joint Strategic Needs Assessments (JSNAs) and Joint local Health and Wellbeing Strategies (JHWBs): Analyses of the data will be used to support the duty of the Local Authority under Sections 192 and 193 of the 2012 Act to consult on and publish JSNAs and JHWSs that assess the current and future health and wellbeing needs of the local population;

d) Duty to commission specific public health services: Analyses of the data will be used to support the Local Authority to discharge its duty under the Local Authorities Regulations 2013 to plan and provide NHS Health Check assessments, the National Child Measurement Programme and open access sexual health services;

e) Duty to provide public health advice to NHS commissioners: Analyses of the data will be used by Local Authorities to discharge its duty under the 2013 Regulations to provide a public health advice service to NHS commissioners;

f) Duty to publish an annual public health report: Analyses of the data will be used by Directors of Public Health to support their duty to prepare and publish an annual report on the health of the local population under Section 31 the 2012 Act;

g) Public Health responses on behalf of the Local Authority to licensing applications and other statutory Local Authority functions requiring public health input: Analyses of the data will be used by the Director of Public Health to support their duty under Part 3 of the National Health Services Act 2006 (as amended by Section 30 of the Health and Social Care Act 2012) to provide the Local Authority’s public health response (as the responsible authority under the Licensing Act 2003, as amended by the Health and Social Care Act 2012 Schedule 5 – Part 1) to licensing applications.

2. Wider public health responsibilities supported by analysis of the data

a) Health impact assessments and equity audits: Analyses of the data will be used to assess the potential impacts on health and the wider social economic and environmental determinants of health of Local Authority strategic plans, policies and services;

b) Local health profiles: Analyses of the data will be used to support the production of locally-commissioned health profiles to improve understanding of the health priorities of local areas and guide strategic commissioning plans by focusing, for example, on:

i. bespoke local geographies (based on the non-standard aggregation of LSOAs);

ii. specific demographic, geographic, ethnic and socio-economic groups in the population;

iii. inequalities in health status, access to treatment and treatment outcomes;

c) Surveillance of trends in health status and health outcomes: Analyses of the data will be used for the longitudinal monitoring of trends in the incidence, prevalence, treatment and outcomes for a wide range of diseases and other risks to public health;

d) Responsive and timely local health intelligence service: Analyses of the data will be used to respond to ad hoc internal and external requests for information and intelligence on the health status and outcomes of the local population generated and received by the Director of Public Health and their team.

These lists of the statutory duties and wider public health responsibilities of local authorities are not exhaustive but set the broad parameters for how the data will be used by the Local Authority to help improve and protect public health, and reduce health inequalities. All such use would be in fulfilment of the public health function of the local authorities.

No identifiable data is requested under this agreement. The data provided would include derived demographic and geographic fields, the standard non-sensitive HES diagnostic and operative fields, and a common (across all Local Authorities) pseudo ID to enable admissions to be linked over time.

Legal Basis - GDPR:

Article 6(1)(e)

(processing is necessary for the performance of a task in the public interest or in the exercise of official authority vested in the controller)

Public Authority: The Data Protection Act 2018 s7(1)(a) defines ‘public bodies’ for the purpose of the GDPR as “a public authority as defined by the Freedom of Information Act 2000”.

The FOI Act 2000 Part 1, section 3 (1)(a)(i) specifies that a public authority means any body which is listed in Schedule 1.

Schedule 1 of the FOI Act 2000 lists Local authorities within the meaning of the Local Government Act 1972 as public authorities.

‘Public Task’

Local Authorities

Local Authorities have a legal responsibility under Section (1)(2)(3)(4)(5)(6)(7) of the Care Act 2014 to conduct tasks that are in the public interest to:

(1) Promoting individual well-being

(2) Preventing needs for care and support

(3) Promoting integration of care and support with health services etc.

(4) Providing information and advice

(5) Promoting diversity and quality in provision of services

(6) Co-operating generally

(7) Co-operating in specific cases

(8) Duty to meet needs for care and support

The task(s) are necessary (but are by no means an exhaustive list), but provides an indication of the many tasks required under Part 1 of the Care Act 2014 as the council has an obligation to the public to deliver services that are a necessity to the local population - from whom funding is provided to deliver these services/tasks in the form of Council Tax.

Local Authorities have a duty under Section 74 (1)(2)(3)(4) of the NHS Act 2006 to supply goods and services:

(1) In the Local Authorities (Goods and Services) Act 1970 (c. 39) the expression “public body” includes—

(a) any Strategic Health Authority, Special Health Authority or Primary Care Trust, and

(b) so far as relates to his functions under this Act, the Secretary of State.

(2) Subsection (1) has effect as if made by an order under section 1(5) of the Local Authorities (Goods and Services) Act 1970 and may be varied or revoked by such an order.

(3) Each local authority must make services available to each NHS body acting in its area, so far as is reasonably necessary and practicable to enable the NHS body to discharge its functions under this Act.

(4) “Services” means the services of persons employed by the local authority for the purposes of its functions under the Local Authority Social Services Act 1970 (c. 42).

As part of the application process, the requirement for the data requested has been assessed and NHS England is content that it is appropriate, necessary and proportionate for the performance of the task described in the Purpose statement.

‘Necessity’: Throughout the application process, the necessity of the processing for the performance of the task has been assessed. This included but was not limited to ensuring appropriate minimisation of the data to ensure that only the minimum amount of data required are processed. During the application process it has been considered whether the information that the processing aims to determine is already available from other sources or whether the task could be performed using publicly available data or data from alternative sources than NHS Engalnd. Consideration has been given to whether the volume of data being requested is proportionate to the expected benefit and, through examination of the expected benefits consideration has been given to whether the task is itself necessary.

Therefore, we are satisfied that this request is appropriate, necessary and proportionate for the performance of the task described in the Purpose statement and that there is no other reasonable means for the data processor to achieve their purpose that is less intrusive to the data subjects.

Article 9(2)(h)

(processing is necessary for the purposes of preventive or occupational medicine, for the assessment of the working capacity of the employee, medical diagnosis, the provision of health or social care or treatment or the management of health or social care systems and services on the basis of Union or Member State law or pursuant to contract with a health professional and subject to the conditions and safeguards referred to in paragraph 3)

• The data are required for the purpose of commissioning.

• The data required by the data controllers is the least intrusive to the data subject possible to be able to conduct their functions.

• The data required for commissioning purposes is pseudonymised by NHS England to minimise the risk of identification.

As part of the standard Data Access Request Service application process:

• the applicant’s technical and organisational measures to safeguard the data have been assessed and meets NHS England’s acceptance criteria;

• the requested data has been assessed as proportionate to the aim pursued;

• respect to the essence of the right to data protection has been assessed (e.g. security assurance, data retention, controls and processing activities, etc.);

• measures to protect the rights and freedoms of data subjects have been assessed including transparency (fair processing) publishing subject’s rights to withdraw consent and/or have their data erased or rectified, etc.

Article 9(3)

(Personal data referred to in paragraph 1 may be processed for the purposes referred to in point (h) of paragraph 2 when those data are processed by or under the responsibility of a professional subject to the obligation of professional secrecy under Union or Member State law or rules established by national competent bodies or by another person also subject to an obligation of secrecy under Union or Member State law or rules established by national competent bodies.)

Legal Basis - Common Law Duty of Confidentiality:

The Data disseminated under this agreement is not considered confidential under the Health and Social Care Act 2012 and therefore is not owed a duty of confidence.

Director of Public Health is not an employee of this local authority so signatory and IAO in this case is Borough Solicitor. Relevant changes made in the Processing Section

Bracknell Forest Council hosts a shared Public Health Team, as part of a joint agreement with the five other local authorities in Berkshire (Reading Borough Council, Slough Borough Council, West Berkshire Council, Royal Borough of Windsor & Maidenhead and Wokingham Borough Council). The Team includes the Director of Public Health, who has statutory responsibility for public health leadership across Berkshire, as well as a shared Informatics function. Bracknell have confirmed that only aggregate data with small numbers suppressed will be made available to the other local authorities.

Expected output

The results of the analyses of the data will be used by the Local Authority to support the discharge of its statutory duties in relation to public health, and wider public health responsibilities. Outputs will include (but not be limited to) the routine and ad hoc production of:

a) Joint Strategic Needs Assessments;

b) Joint local Health and Wellbeing Strategies;

c) the annual report of the Director of Public Health;

d) reports commissioned by the Health and Wellbeing Boards;

e) public health and wider Local Authority health and wellbeing commissioning strategies and plans;

f) public health advice to local Integrated Care Boards and Primary Care Networks;

g) responses to licensing applications and other statutory Local Authority functions requiring public health input;

h) local health profiles;

i) health impact assessments and equity audits;

j) health needs assessments, such as the Pharmaceutical Needs Assessment;

k) responses to internal and external requests for information and intelligence on the health and wellbeing of the population.

The specific content of and target dates for these outputs will be for the Local Authority to determine, although it is required to comply with national guidance published by the Department of Health, UK Health Security Agency and others as appropriate, for example, on the timetable for publishing refreshed JSNAs.

All outputs will be of aggregated data with small numbers suppressed in line with the HES Analysis Guide.

Benefits reported

The local authority now have a data warehouse containing HES Accident and Emergency and Admitted Patient Care data. The HES data has been decoded using look-up tables and the NHS Data Dictionary. This allows the data to be aggregated by a range of different geographies and key demographics in order to understand the health of the local population. The aim is for a timely annual refresh of the data in order to provide responsive local data analysis.

During 2022, the Berkshire East and Berkshire West local authorities relaunched their JSNAs and have reviewed the use of data to inform priority setting. The HES data was used to identify how the rate of admissions had changed by agebands and also cause of admission. Additional work has also continued to understand how hospital admissions vary across sub-LA geographies and communities.

Examples of other analyses include:

- Analysis of admissions for the top ten cause of admissions

- Analysis of patterns in self-harm admissions

- Admissions for mental health conditions for younger people

- Admissions related to the night-time economy

DARS-NIC-09901-F6V6M-v6.5 1 April 2021 to 30 April 2023
Title
Local Authority Public Health Pseudonymised HES Extract Service
Commercial
No
Sublicensing
No
Datasets
8
Files released
199

Datasets: Emergency Care Data Set (ECDS); HES-ID to MPS-ID HES Accident and Emergency; HES-ID to MPS-ID HES Admitted Patient Care; HES-ID to MPS-ID HES Outpatients; Hospital Episode Statistics Accident and Emergency (HES A and E); Hospital Episode Statistics Admitted Patient Care (HES APC); Hospital Episode Statistics Critical Care (HES Critical Care); Hospital Episode Statistics Outpatients (HES OP)

What changed from DARS-NIC-09901-F6V6M-v5.2

Text removed is struck through; text added is underlined. Unchanged paragraphs are summarised rather than repeated.

Fields changed from DARS-NIC-09901-F6V6M-v5.2
FieldWasBecame
Start date2020-04-012021-04-01
End date2021-03-312023-04-30
Emergency Care Data Set (ECDS): legal basisHealth and Social Care Act 2012 – s261(2)(b)(ii)Health and Social Care Act 2012 - s261 - 'Other dissemination of information'
Hospital Episode Statistics Accident and Emergency (HES A and E): legal basisHealth and Social Care Act 2012 – s261(2)(b)(ii)Health and Social Care Act 2012 - s261 - 'Other dissemination of information'
Hospital Episode Statistics Admitted Patient Care (HES APC): legal basisHealth and Social Care Act 2012 – s261(2)(b)(ii)Health and Social Care Act 2012 - s261 - 'Other dissemination of information'
Hospital Episode Statistics Critical Care (HES Critical Care): legal basisHealth and Social Care Act 2012 – s261(2)(b)(ii)Health and Social Care Act 2012 - s261 - 'Other dissemination of information'
Hospital Episode Statistics Outpatients (HES OP): legal basisHealth and Social Care Act 2012 – s261(2)(b)(ii)Health and Social Care Act 2012 - s261 - 'Other dissemination of information'

Datasets: + HES-ID to MPS-ID HES Accident and Emergency; + HES-ID to MPS-ID HES Admitted Patient Care; + HES-ID to MPS-ID HES Outpatients

Objective for processing

The data provided by the pseudonymised HES Extract will be used to fulfil the public health function of the six Berkshire local authorities, Bracknell Forest County Council, specifically to support and improve: [29 paragraphs unchanged]

Benefits reported

Feb 2021 [1 paragraph unchanged] During 2019/20, 2020/21, a suite great deal of reports and key measures were developed for analytical time has been spent on the response to the covid-19 pandemic. However, the HES data warehouse. This has been utilized for a number of reports that have enabled local public health teams to ask for more detailed analyses for hospital admission activity and has helped to inform a number of different public health projects. . Examples include a deep-dive in to alcohol related admissions in Bracknell Forest with an emphasis on alcohol-related cancers in females. Other examples include: [4 paragraphs unchanged] - Detailed analysis of admissions for key conditions (cancer, circulatory disease, respiratory disease) at a sub-LA level to enhance local JSNA sections. - Informing local School Health Profiles and provide lower-level data on hospital admissions by school catchment area

Changed only in punctuation, spacing or capitalisation: Processing activities.

Unchanged: Expected output, Expected measurable benefits.

Objective for processing

The data provided by the pseudonymised HES Extract will be used to fulfil the public health function of Bracknell Forest County Council, specifically to support and improve:

1. the local responsiveness, targeting and value for money of commissioned public health services;

2. the statutory ‘core offer’ public health advice and support provided to local NHS commissioners;

3. the local specificity and relevance of the Joint Strategic Needs Assessments and Health and Wellbeing Strategies produced in collaboration with NHS and voluntary sector partners on the Health and Wellbeing Board;

4. the local focus, responsiveness and timeliness of health impact assessments;

5. the capability of the local public health intelligence service to undertake comparative longitudinal analyses of patterns and variations in:

a. the incidence and prevalence of disease and risks to public health;

b. demand for and access to treatment and preventative care services;

c. variations in health outcomes between groups in the population;

d. the level of integration between local health and care services; and

e. the local associations between causal risk factors and health status and outcomes.

The main statutory duties and wider public health responsibilities supporting these processing objectives are as follows:

1. Statutory public health duties that the data will be used to support

a) Duty to improve public health: Analyses of the data will be used to support the duty of the local authorities under Section 12 of the Health and Social Care Act 2012 to take appropriate steps to improve the health of the population, for example by providing information and advice, services and facilities, and incentives and assistance to encourage and enable people to lead healthier lives;

b) Duty to support Health and Wellbeing Boards: Analyses of the data will be used to support the duty of the local authorities and Clinical Commissioning Group (CCG)-led Health and Wellbeing Board under Section 194 of the 2012 Act to improve health and wellbeing, reduce health inequalities, and promote the integration of health and care services. The data will also be used to support the statutory duty of Health and Wellbeing Boards under Section 206 of the 2012 Act to undertake Pharmaceutical Needs Assessments;

c) Duty to produce Joint Strategic Needs Assessments (JSNAs) and Joint Health and Wellbeing Strategies (JHWBs): Analyses of the data will be used to support the duty of the Local Authority under Sections 192 and 193 of the 2012 Act to consult on and publish JSNAs and JHWSs that assess the current and future health and wellbeing needs of the local population;

d) Duty to commission specific public health services: Analyses of the data will be used to support the Local Authority to discharge its duty under the Local Authorities Regulations 2013 to plan and provide NHS Health Check assessments, the National Child Measurement Programme and open access sexual health services;

e) Duty to provide public health advice to NHS commissioners: Analyses of the data will be used by Local Authorities to discharge its duty under the 2013 Regulations to provide a public health advice service to NHS commissioners;

f) Duty to publish an annual public health report: Analyses of the data will be used by Directors of Public Health to support their duty to prepare and publish an annual report on the health of the local population under Section 31 the 2012 Act;

g) Public Health responses on behalf of the Local Authority to licensing applications and other statutory Local Authority functions requiring public health input: Analyses of the data will be used by the Director of Public Health to support their duty under Part 3 of the National Health Services Act 2006 (as amended by Section 30 of the Health and Social Care Act 2012) to provide the Local Authority’s public health response (as the responsible authority under the Licensing Act 2003, as amended by the Health and Social Care Act 2012 Schedule 5 – Part 1) to licensing applications.

2. Wider public health responsibilities supported by analysis of the data

a) Health impact assessments and equity audits: Analyses of the data will be used to assess the potential impacts on health and the wider social economic and environmental determinants of health of Local Authority strategic plans, policies and services;

b) Local health profiles: Analyses of the data will be used to support the production of locally-commissioned health profiles to improve understand of the health priorities of local areas and guide strategic commissioning plans by focusing, for example, on:

i. bespoke local geographies (based on the non-standard aggregation of LSOAs);

ii. specific demographic, geographic, ethnic and socio-economic groups in the population;

iii. inequalities in health status, access to treatment and treatment outcomes;

c) Surveillance of trends in health status and health outcomes: Analyses of the data will be used for the longitudinal monitoring of trends in the incidence, prevalence, treatment and outcomes for a wide range of diseases and other risks to public health;

d) Responsive and timely local health intelligence service: Analyses of the data will be used to respond to ad hoc internal and external requests for information and intelligence on the health status and outcomes of the local population generated and received by the Director of Public Health and their team.

These lists of the statutory duties and wider public health responsibilities of local authorities are not exhaustive but set the broad parameters for how the data will be used by the Local Authority to help improve and protect public health, and reduce health inequalities. All such use would be in fulfilment of the public health function of the local authorities.

No sensitive data is requested under this application. The data provided would include derived demographic and geographic fields, the standard non-sensitive HES diagnostic and operative fields, and a common (across all Local Authorities) pseudoHESID to enable admissions to be linked over time.

Expected output

The results of the analyses of the data will be used by the Local Authority to support the discharge of its statutory duties in relation to public health, and wider public health responsibilities. Outputs will include (but not be limited to) the routine and ad hoc production of:

a) Joint Strategic Needs Assessments;

b) Joint Health and Wellbeing Strategies;

c) the annual report of the Director of Public Health;

d) reports commissioned by the Health and Wellbeing Board;

e) public health and wider Local Authority health and wellbeing commissioning strategies and plans;

f) public health advice to local CCGs, STPs and ICSs;

g) responses to licensing applications and other statutory Local Authority functions requiring public health input;

h) local health profiles;

i) health impact assessments and equity audits;

j) health needs assessments, such as the Pharmaceutical Needs Assessment;

k) responses to internal and external requests for information and intelligence on the health and wellbeing of the population.

The specific content of and target dates for these outputs will be for the Local Authority to determine, although it is required to comply with national guidance published by the Department of Health, Public Health England and others as appropriate, for example, on the timetable for publishing refreshed JSNAs.

All outputs will be of aggregated data with small numbers suppressed in line with the HES Analysis Guide.

Benefits reported

Feb 2021

The local authority now have a data warehouse containing HES Accident and Emergency and Admitted Patient Care data. The HES data has been decoded using look-up tables and the NHS Data Dictionary. This allows the data to be aggregated by a range of different geographies and key demographics in order to understand the health of the local population. The aim is for a timely annual refresh of the data in order to provide responsive local data analysis.

During 2020/21, a great deal of analytical time has been spent on the response to the covid-19 pandemic. However, the HES data has been utilized for a number of reports that have enabled local public health teams to ask for more detailed analyses for hospital admission activity and has helped to inform a number of different public health projects. . Examples include a deep-dive in to alcohol related admissions in Bracknell Forest with an emphasis on alcohol-related cancers in females. Other examples include:

- Analysis of admissions for the top ten cause of admissions

- Analysis of patterns in self-harm admissions

- Admissions of falls

- Admissions for mental health conditions

DARS-NIC-09901-F6V6M-v5.2 1 April 2020 to 31 March 2021
Title
Local Authority Public Health Pseudonymised HES Extract Service
Commercial
No
Sublicensing
No
Datasets
5
Files released
80

Datasets: Emergency Care Data Set (ECDS); Hospital Episode Statistics Accident and Emergency (HES A and E); Hospital Episode Statistics Admitted Patient Care (HES APC); Hospital Episode Statistics Critical Care (HES Critical Care); Hospital Episode Statistics Outpatients (HES OP)

What changed from DARS-NIC-09901-F6V6M-v4.2

Text removed is struck through; text added is underlined. Unchanged paragraphs are summarised rather than repeated.

Fields changed from DARS-NIC-09901-F6V6M-v4.2
FieldWasBecame
Start date2019-04-012020-04-01
End date2020-03-312021-03-31

Datasets: + Emergency Care Data Set (ECDS)

Benefits reported

[1 paragraph unchanged] During 2018/19, 2019/20, a suite of reports and key measures were developed for the HES [21 words unchanged] helped to inform a number of different public health projects. Examples include: - Analysis of alcohol-related and alcohol-specific admissions to inform the Berkshire West Alcohol Working Group and the development of appropriate local interventions. This included using the PHOF and LAPE indicator definitions to provide lower-level geographical breakdowns and a more detailed look at the demography of this patient cohort. - Analysis of admissions for the top ten cause of admissions - Analysis of hospital admissions due to injuries from falls to support a cross-Berkshire bid for a new Falls Service. This included a focus on people who were also diagnosed with a UTI at the point of their hospital admission to identify possible patterns. - Analysis of patterns in self-harm admissions - Summary of admissions for mental health conditions to inform Slough Wellbeing Board's campaign on mental health awareness. - Admissions of falls - Summary of admissions for people who have 'no-fixed-abode' to support Slough's Homelessness Needs Assessment. - Admissions for mental health conditions [1 paragraph unchanged] - Currently using HES data to inform Informing local School Health Profiles and provide lower-level data on hospital admissions by school catchment area

Unchanged: Objective for processing, Processing activities, Expected output, Expected measurable benefits.

Objective for processing

The data provided by the pseudonymised HES Extract will be used to fulfil the public health function of the six Berkshire local authorities, specifically to support and improve:

1. the local responsiveness, targeting and value for money of commissioned public health services;

2. the statutory ‘core offer’ public health advice and support provided to local NHS commissioners;

3. the local specificity and relevance of the Joint Strategic Needs Assessments and Health and Wellbeing Strategies produced in collaboration with NHS and voluntary sector partners on the Health and Wellbeing Board;

4. the local focus, responsiveness and timeliness of health impact assessments;

5. the capability of the local public health intelligence service to undertake comparative longitudinal analyses of patterns and variations in:

a. the incidence and prevalence of disease and risks to public health;

b. demand for and access to treatment and preventative care services;

c. variations in health outcomes between groups in the population;

d. the level of integration between local health and care services; and

e. the local associations between causal risk factors and health status and outcomes.

The main statutory duties and wider public health responsibilities supporting these processing objectives are as follows:

1. Statutory public health duties that the data will be used to support

a) Duty to improve public health: Analyses of the data will be used to support the duty of the local authorities under Section 12 of the Health and Social Care Act 2012 to take appropriate steps to improve the health of the population, for example by providing information and advice, services and facilities, and incentives and assistance to encourage and enable people to lead healthier lives;

b) Duty to support Health and Wellbeing Boards: Analyses of the data will be used to support the duty of the local authorities and Clinical Commissioning Group (CCG)-led Health and Wellbeing Board under Section 194 of the 2012 Act to improve health and wellbeing, reduce health inequalities, and promote the integration of health and care services. The data will also be used to support the statutory duty of Health and Wellbeing Boards under Section 206 of the 2012 Act to undertake Pharmaceutical Needs Assessments;

c) Duty to produce Joint Strategic Needs Assessments (JSNAs) and Joint Health and Wellbeing Strategies (JHWBs): Analyses of the data will be used to support the duty of the Local Authority under Sections 192 and 193 of the 2012 Act to consult on and publish JSNAs and JHWSs that assess the current and future health and wellbeing needs of the local population;

d) Duty to commission specific public health services: Analyses of the data will be used to support the Local Authority to discharge its duty under the Local Authorities Regulations 2013 to plan and provide NHS Health Check assessments, the National Child Measurement Programme and open access sexual health services;

e) Duty to provide public health advice to NHS commissioners: Analyses of the data will be used by Local Authorities to discharge its duty under the 2013 Regulations to provide a public health advice service to NHS commissioners;

f) Duty to publish an annual public health report: Analyses of the data will be used by Directors of Public Health to support their duty to prepare and publish an annual report on the health of the local population under Section 31 the 2012 Act;

g) Public Health responses on behalf of the Local Authority to licensing applications and other statutory Local Authority functions requiring public health input: Analyses of the data will be used by the Director of Public Health to support their duty under Part 3 of the National Health Services Act 2006 (as amended by Section 30 of the Health and Social Care Act 2012) to provide the Local Authority’s public health response (as the responsible authority under the Licensing Act 2003, as amended by the Health and Social Care Act 2012 Schedule 5 – Part 1) to licensing applications.

2. Wider public health responsibilities supported by analysis of the data

a) Health impact assessments and equity audits: Analyses of the data will be used to assess the potential impacts on health and the wider social economic and environmental determinants of health of Local Authority strategic plans, policies and services;

b) Local health profiles: Analyses of the data will be used to support the production of locally-commissioned health profiles to improve understand of the health priorities of local areas and guide strategic commissioning plans by focusing, for example, on:

i. bespoke local geographies (based on the non-standard aggregation of LSOAs);

ii. specific demographic, geographic, ethnic and socio-economic groups in the population;

iii. inequalities in health status, access to treatment and treatment outcomes;

c) Surveillance of trends in health status and health outcomes: Analyses of the data will be used for the longitudinal monitoring of trends in the incidence, prevalence, treatment and outcomes for a wide range of diseases and other risks to public health;

d) Responsive and timely local health intelligence service: Analyses of the data will be used to respond to ad hoc internal and external requests for information and intelligence on the health status and outcomes of the local population generated and received by the Director of Public Health and their team.

These lists of the statutory duties and wider public health responsibilities of local authorities are not exhaustive but set the broad parameters for how the data will be used by the Local Authority to help improve and protect public health, and reduce health inequalities. All such use would be in fulfilment of the public health function of the local authorities.

No sensitive data is requested under this application. The data provided would include derived demographic and geographic fields, the standard non-sensitive HES diagnostic and operative fields, and a common (across all Local Authorities) pseudoHESID to enable admissions to be linked over time.

Expected output

The results of the analyses of the data will be used by the Local Authority to support the discharge of its statutory duties in relation to public health, and wider public health responsibilities. Outputs will include (but not be limited to) the routine and ad hoc production of:

a) Joint Strategic Needs Assessments;

b) Joint Health and Wellbeing Strategies;

c) the annual report of the Director of Public Health;

d) reports commissioned by the Health and Wellbeing Board;

e) public health and wider Local Authority health and wellbeing commissioning strategies and plans;

f) public health advice to local CCGs, STPs and ICSs;

g) responses to licensing applications and other statutory Local Authority functions requiring public health input;

h) local health profiles;

i) health impact assessments and equity audits;

j) health needs assessments, such as the Pharmaceutical Needs Assessment;

k) responses to internal and external requests for information and intelligence on the health and wellbeing of the population.

The specific content of and target dates for these outputs will be for the Local Authority to determine, although it is required to comply with national guidance published by the Department of Health, Public Health England and others as appropriate, for example, on the timetable for publishing refreshed JSNAs.

All outputs will be of aggregated data with small numbers suppressed in line with the HES Analysis Guide.

Benefits reported

The local authority now have a data warehouse containing HES Accident and Emergency and Admitted Patient Care data. The HES data has been decoded using look-up tables and the NHS Data Dictionary. This allows the data to be aggregated by a range of different geographies and key demographics in order to understand the health of the local population. The aim is for a timely annual refresh of the data in order to provide responsive local data analysis.

During 2019/20, a suite of reports and key measures were developed for the HES data warehouse. This has enabled local public health teams to ask for more detailed analyses for hospital admission activity and has helped to inform a number of different public health projects. Examples include:

- Analysis of admissions for the top ten cause of admissions

- Analysis of patterns in self-harm admissions

- Admissions of falls

- Admissions for mental health conditions

- Detailed analysis of admissions for key conditions (cancer, circulatory disease, respiratory disease) at a sub-LA level to enhance local JSNA sections.

- Informing local School Health Profiles and provide lower-level data on hospital admissions by school catchment area

DARS-NIC-09901-F6V6M-v4.2 1 April 2019 to 31 March 2020
Title
Local Authority Public Health Pseudonymised HES Extract Service
Commercial
No
Sublicensing
No
Datasets
4
Files released
98

Datasets: Hospital Episode Statistics Accident and Emergency (HES A and E); Hospital Episode Statistics Admitted Patient Care (HES APC); Hospital Episode Statistics Critical Care (HES Critical Care); Hospital Episode Statistics Outpatients (HES OP)

Objective for processing

The data provided by the pseudonymised HES Extract will be used to fulfil the public health function of the six Berkshire local authorities, specifically to support and improve:

1. the local responsiveness, targeting and value for money of commissioned public health services;

2. the statutory ‘core offer’ public health advice and support provided to local NHS commissioners;

3. the local specificity and relevance of the Joint Strategic Needs Assessments and Health and Wellbeing Strategies produced in collaboration with NHS and voluntary sector partners on the Health and Wellbeing Board;

4. the local focus, responsiveness and timeliness of health impact assessments;

5. the capability of the local public health intelligence service to undertake comparative longitudinal analyses of patterns and variations in:

a. the incidence and prevalence of disease and risks to public health;

b. demand for and access to treatment and preventative care services;

c. variations in health outcomes between groups in the population;

d. the level of integration between local health and care services; and

e. the local associations between causal risk factors and health status and outcomes.

The main statutory duties and wider public health responsibilities supporting these processing objectives are as follows:

1. Statutory public health duties that the data will be used to support

a) Duty to improve public health: Analyses of the data will be used to support the duty of the local authorities under Section 12 of the Health and Social Care Act 2012 to take appropriate steps to improve the health of the population, for example by providing information and advice, services and facilities, and incentives and assistance to encourage and enable people to lead healthier lives;

b) Duty to support Health and Wellbeing Boards: Analyses of the data will be used to support the duty of the local authorities and Clinical Commissioning Group (CCG)-led Health and Wellbeing Board under Section 194 of the 2012 Act to improve health and wellbeing, reduce health inequalities, and promote the integration of health and care services. The data will also be used to support the statutory duty of Health and Wellbeing Boards under Section 206 of the 2012 Act to undertake Pharmaceutical Needs Assessments;

c) Duty to produce Joint Strategic Needs Assessments (JSNAs) and Joint Health and Wellbeing Strategies (JHWBs): Analyses of the data will be used to support the duty of the Local Authority under Sections 192 and 193 of the 2012 Act to consult on and publish JSNAs and JHWSs that assess the current and future health and wellbeing needs of the local population;

d) Duty to commission specific public health services: Analyses of the data will be used to support the Local Authority to discharge its duty under the Local Authorities Regulations 2013 to plan and provide NHS Health Check assessments, the National Child Measurement Programme and open access sexual health services;

e) Duty to provide public health advice to NHS commissioners: Analyses of the data will be used by Local Authorities to discharge its duty under the 2013 Regulations to provide a public health advice service to NHS commissioners;

f) Duty to publish an annual public health report: Analyses of the data will be used by Directors of Public Health to support their duty to prepare and publish an annual report on the health of the local population under Section 31 the 2012 Act;

g) Public Health responses on behalf of the Local Authority to licensing applications and other statutory Local Authority functions requiring public health input: Analyses of the data will be used by the Director of Public Health to support their duty under Part 3 of the National Health Services Act 2006 (as amended by Section 30 of the Health and Social Care Act 2012) to provide the Local Authority’s public health response (as the responsible authority under the Licensing Act 2003, as amended by the Health and Social Care Act 2012 Schedule 5 – Part 1) to licensing applications.

2. Wider public health responsibilities supported by analysis of the data

a) Health impact assessments and equity audits: Analyses of the data will be used to assess the potential impacts on health and the wider social economic and environmental determinants of health of Local Authority strategic plans, policies and services;

b) Local health profiles: Analyses of the data will be used to support the production of locally-commissioned health profiles to improve understand of the health priorities of local areas and guide strategic commissioning plans by focusing, for example, on:

i. bespoke local geographies (based on the non-standard aggregation of LSOAs);

ii. specific demographic, geographic, ethnic and socio-economic groups in the population;

iii. inequalities in health status, access to treatment and treatment outcomes;

c) Surveillance of trends in health status and health outcomes: Analyses of the data will be used for the longitudinal monitoring of trends in the incidence, prevalence, treatment and outcomes for a wide range of diseases and other risks to public health;

d) Responsive and timely local health intelligence service: Analyses of the data will be used to respond to ad hoc internal and external requests for information and intelligence on the health status and outcomes of the local population generated and received by the Director of Public Health and their team.

These lists of the statutory duties and wider public health responsibilities of local authorities are not exhaustive but set the broad parameters for how the data will be used by the Local Authority to help improve and protect public health, and reduce health inequalities. All such use would be in fulfilment of the public health function of the local authorities.

No sensitive data is requested under this application. The data provided would include derived demographic and geographic fields, the standard non-sensitive HES diagnostic and operative fields, and a common (across all Local Authorities) pseudoHESID to enable admissions to be linked over time.

Expected output

The results of the analyses of the data will be used by the Local Authority to support the discharge of its statutory duties in relation to public health, and wider public health responsibilities. Outputs will include (but not be limited to) the routine and ad hoc production of:

a) Joint Strategic Needs Assessments;

b) Joint Health and Wellbeing Strategies;

c) the annual report of the Director of Public Health;

d) reports commissioned by the Health and Wellbeing Board;

e) public health and wider Local Authority health and wellbeing commissioning strategies and plans;

f) public health advice to local CCGs, STPs and ICSs;

g) responses to licensing applications and other statutory Local Authority functions requiring public health input;

h) local health profiles;

i) health impact assessments and equity audits;

j) health needs assessments, such as the Pharmaceutical Needs Assessment;

k) responses to internal and external requests for information and intelligence on the health and wellbeing of the population.

The specific content of and target dates for these outputs will be for the Local Authority to determine, although it is required to comply with national guidance published by the Department of Health, Public Health England and others as appropriate, for example, on the timetable for publishing refreshed JSNAs.

All outputs will be of aggregated data with small numbers suppressed in line with the HES Analysis Guide.

Benefits reported

The local authority now have a data warehouse containing HES Accident and Emergency and Admitted Patient Care data. The HES data has been decoded using look-up tables and the NHS Data Dictionary. This allows the data to be aggregated by a range of different geographies and key demographics in order to understand the health of the local population. The aim is for a timely annual refresh of the data in order to provide responsive local data analysis.

During 2018/19, a suite of reports and key measures were developed for the HES data warehouse. This has enabled local public health teams to ask for more detailed analyses for hospital admission activity and has helped to inform a number of different public health projects. Examples include:

- Analysis of alcohol-related and alcohol-specific admissions to inform the Berkshire West Alcohol Working Group and the development of appropriate local interventions. This included using the PHOF and LAPE indicator definitions to provide lower-level geographical breakdowns and a more detailed look at the demography of this patient cohort.

- Analysis of hospital admissions due to injuries from falls to support a cross-Berkshire bid for a new Falls Service. This included a focus on people who were also diagnosed with a UTI at the point of their hospital admission to identify possible patterns.

- Summary of admissions for mental health conditions to inform Slough Wellbeing Board's campaign on mental health awareness.

- Summary of admissions for people who have 'no-fixed-abode' to support Slough's Homelessness Needs Assessment.

- Detailed analysis of admissions for key conditions (cancer, circulatory disease, respiratory disease) at a sub-LA level to enhance local JSNA sections.

- Currently using HES data to inform local School Health Profiles and provide lower-level data on hospital admissions by school catchment area

Register history

When this agreement appeared in, or was edited in, each monthly edition of the register. Built by comparing every edition this site holds, the earliest of which is July 2021.

"Amended in place" means NHS England changed the record without issuing a new version number. The register publishes no changelog for those edits; this site infers them by comparing editions. An edit is attributed to the edition it first appears in, not to the date it was made.

Cite this page

NHS England (2026) Data Uses Register, September 2026 edition, agreement DARS-NIC-09901-F6V6M, “Local Authority Public Health Pseudonymised HES Extract Service”. Read via NHS Data Access Explorer (unofficial), https://healthdatauses.uk/agreements/dars-nic-09901-f6v6m/ (accessed [date]).

This address stays the same, but the page is rebuilt with each monthly edition, so the citation names the edition it shows. Every edition's data is kept in the facts store.

Source: datausesregister_september2026.xlsx, September 2026 edition of the NHS England Data Uses Register. Search that workbook for DARS-NIC-09901-F6V6M to see the original rows.