AndreaBozzo/ceres-open-data-index huggingface dataset:
Birmingham Sex Workers Analysis of Health Needs

## Birmingham Sex Workers Analysis of Health Needs (2024) The Sex Worker Analysis of Health Needs (SWAN) report offers a comprehensive picture of sex workers in Birmingham, the West Midlands and the UK.>The study that took place in 2023, highlights the health and wellbeing needs of sex workers and the degree to which these needs are being met. The findings have major implications for health policy and provision across the country.The SWAN study provides evidence for how sex workers experience significant health inequalities because of their line of work. Barriers to accessing services include stigma, concerns about safety and potential legal ramifications of disclosing their occupation. However, sex workers want and need the same level of access to services as everyone else. Indeed, sex workers are at higher risk of many health problems in comparison to non-sex workers, both with regards to sexual health and many health conditions.It is hoped that the findings and recommendations in this report will be used to inform the design and delivery of health services in Birmingham, and more widely in the UK, to better meet the health needs of sex workers. For further details, please visit: [https://www.birmingham.gov.uk/info/50342/public_health_reports/2955/inclusion_health/2] ## Viewing and downloading This dataset contains unstructured files such as documents, PDF's and images. To view and download the files click on the Table tab at the top and select the desired file in the File name column. You may use the filters to further refine your selection. ℹ️ Note The Export and API will only download the table of contents.
Diabetics (Type 2) receiving all 8 care processes - ICP Outcomes Framework - Registered Locality

This dataset presents the percentage of individuals with type 2 diabetes who have received all eight recommended care processes as defined by the National Diabetes Audit (NDA). These care processes are essential checks and tests that support effective monitoring and management of diabetes. They include measurements and assessments such as body mass index (BMI), blood pressure, smoking status, HbA1c, cholesterol, urine albumin, serum creatinine, and foot examination for nerve and circulation health. The dataset provides a comprehensive view of how well healthcare providers are delivering routine diabetes care. ## Rationale Receiving all eight care processes is associated with improved monitoring and early detection of complications in people with type 2 diabetes. This indicator helps evaluate the consistency and quality of routine diabetes care and supports efforts to enhance patient outcomes through comprehensive clinical assessments. ## Numerator The numerator includes the number of individuals with type 2 diabetes who received all eight care processes within the audit period. These processes are: BMI measurement, blood pressure check, smoking status recording, HbA1c test, cholesterol test, urine albumin test, serum creatinine test, and foot examination for nerve and circulation health. Data is sourced from the National Diabetes Audit (NDA) and NHS England. ## Denominator The denominator includes all individuals registered with type 2 diabetes at GP practices participating in the National Diabetes Audit. This ensures a consistent and representative population base for calculating the indicator. ## Caveats Data is collected over a 15-month period ## Localities Explained This dataset contains data based on either the resident locality or registered locality of the patient, a distinction is made between resident locality and registered locality populations: * Resident Locality refers to individuals who live within the defined geographic boundaries of the locality. These boundaries are aligned with official administrative areas such as wards and Lower Layer Super Output Areas (LSOAs). * Registered Locality refers to individuals who are registered with GP practices that are assigned to a locality based on the Primary Care Network (PCN) they belong to. These assignments are approximate—PCNs are mapped to a locality based on the location of most of their GP surgeries. As a result, locality-registered patients may live outside the locality, sometimes even in different towns or cities. This distinction is important because some health indicators are only available at GP practice level, without information on where patients actually reside. In such cases, data is attributed to the locality based on GP registration, not residential address. [Click here] to explore more from the Birmingham and Solihull Integrated Care Partnerships Outcome Framework.
Diabetics (Type 2) receiving all 8 care processes - ICP Outcomes Framework - Birmingham and Solihull

This dataset presents the percentage of individuals with type 2 diabetes who have received all eight recommended care processes as defined by the National Diabetes Audit (NDA). These care processes are essential checks and tests that support effective monitoring and management of diabetes. They include measurements and assessments such as body mass index (BMI), blood pressure, smoking status, HbA1c, cholesterol, urine albumin, serum creatinine, and foot examination for nerve and circulation health. The dataset provides a comprehensive view of how well healthcare providers are delivering routine diabetes care. ## Rationale Receiving all eight care processes is associated with improved monitoring and early detection of complications in people with type 2 diabetes. This indicator helps evaluate the consistency and quality of routine diabetes care and supports efforts to enhance patient outcomes through comprehensive clinical assessments. ## Numerator The numerator includes the number of individuals with type 2 diabetes who received all eight care processes within the audit period. These processes are: BMI measurement, blood pressure check, smoking status recording, HbA1c test, cholesterol test, urine albumin test, serum creatinine test, and foot examination for nerve and circulation health. Data is sourced from the National Diabetes Audit (NDA) and NHS England. [Click here] to explore more from the Birmingham and Solihull Integrated Care Partnerships Outcome Framework.
Census 2021 Age by Tenure

This dataset provides Census 2021 estimates that classify usual residents in Birmingham by tenure and single year of age. The estimates are as at Census Day, 21 March 2021. Tenure is whether a household owns or rents the accommodation it occupies. # Coverage This dataset is focused on the data for Birmingham at city level. About the 2021 Census The Census takes place every 10 years and gives us a picture of all the people and households in England and Wales. Protecting personal data The ONS sometimes need to make changes to data if it is possible to identify individuals. This is known as statistical disclosure control. In Census 2021, they: * Swapped records (targeted record swapping), for example, if a household was likely to be identified in datasets because it has unusual characteristics, they swapped the record with a similar one from a nearby small area. Very unusual households could be swapped with one in a nearby local authority. * Added small changes to some counts (cell key perturbation), for example, we might change a count of four to a three or a five. This might make small differences between tables depending on how the data are broken down when they applied perturbation. For more geographies, aggregations or topics see the link in the Reference below. Or, to create a custom dataset with multiple variables use the ONS [Create a custom dataset tool].
Fingertips GP to Ward Lookup Matrix for Birmingham and Solihull

A weighted matrix to convert fingertips GP practice code data into Birmingham and Solihull wards. The matrix uses the GP census data to allocate a percentage of their patients to each ward based on the citizens home address. ## How to use 1. Using a BI tool such as Power Query merge this with your GP Fingertips data based on the practice code. 2. Expand the merged query to new rows 3. Calculate the new count value using following formula: Count * Weighted Value 4. Calculate the new denominator value using the following formula: Denominator * Weighted Value 5. Group the Fingertips data by Indicator ID, Indicator name, Local authority. Ward code, Ward, Time period, Sex, Age with the aggregation of SUM on the New count and New denominator columns 6. Calculate the new value with the following formula: new count / new denominator *100 ## Useful information The matrix is based on a recent GP census. It is therefore advisable to only work with the latest Fingertips data as historical information will be inaccurate. To view previous versions see the Snapshots section on the Export tab. ℹ️ Release September 2025
Emergency admissions for coronary heart disease - ICP Outcomes Framework - Birmingham and Solihull

This dataset presents the age-standardised rate of emergency hospital admissions for coronary heart disease (CHD) across England. It provides insight into the burden of acute cardiovascular events requiring urgent care, helping to inform public health strategies and healthcare planning. The indicator focuses on unplanned hospital admissions where CHD is the primary diagnosis, offering a measure of both disease prevalence and healthcare system responsiveness. ## Rationale Reducing emergency admissions for coronary heart disease is a key public health objective. High rates of emergency admissions may indicate poor disease management in the community or delayed access to preventative care. Monitoring this indicator supports efforts to improve cardiovascular health outcomes and reduce strain on emergency services. ## Numerator The numerator is the count of emergency hospital admissions where the primary diagnosis is coronary heart disease, identified using ICD-10 codes I20 to I25. Admissions are included if they meet specific criteria: admission method codes ('21', '22', '23', '24', '25', '28', '2A', '2B', '2C', '2D'), patient classification as 'ordinary' (1 or 2), episode status equal to 3, and episode order equal to 1. These values are derived from Secondary Uses Service (SUS) data. ## Denominator The denominator is the expected number of admissions, calculated by applying England's age-specific rates to the local registered population. Population estimates are based on Census 2021 data. ## Caveats There are known data quality issues affecting Hospital Episode Statistics (HES) data for Nottingham University Hospitals Trust during the 2016–2017 financial year. Over 30% of records lacked valid geographic information, and as a result, Public Health England (PHE) has not published a value for this trust. Additionally, due to disclosure control, some values have not been published. ## External References [Fingertips Public Health Profiles – Coronary Heart Disease Indicator] [Click here] to explore more from the Birmingham and Solihull Integrated Care Partnerships Outcome Framework.
Emergency admissions for diabetes (under 19yrs) - ICP Outcomes Framework - Resident Locality

This dataset presents the crude rate of emergency hospital admissions for insulin-dependent diabetes mellitus (Type 1 diabetes) among children and young people aged under 19. It provides insight into the burden of acute diabetic complications requiring urgent care and supports the evaluation of diabetes management in paediatric populations. ## Rationale Reducing emergency admissions for diabetes in children is a key public health objective. High admission rates may indicate challenges in managing the condition, such as poor glycaemic control, lack of access to specialist care, or gaps in education and support for families. Monitoring this indicator helps inform strategies to improve diabetes care and reduce preventable hospitalisations. ## Numerator The numerator is the number of emergency hospital admissions for individuals aged under 19 with a primary diagnosis of insulin-dependent diabetes mellitus, identified using ICD-10 code E10. Data are sourced from NHS England’s Secondary Uses Service (SUS). ## Denominator The denominator is the total resident population aged under 19, based on the 2021 Census. ## Caveats No specific caveats were noted for this dataset. However, as with all hospital admission indicators, local variations in clinical coding, referral practices, and healthcare access may influence the results. ## External References [Fingertips Public Health Profiles – Diabetes Admissions (Under 19)] ## Localities Explained This dataset contains data based on either the resident locality or registered locality of the patient, a distinction is made between resident locality and registered locality populations: * Resident Locality refers to individuals who live within the defined geographic boundaries of the locality. These boundaries are aligned with official administrative areas such as wards and Lower Layer Super Output Areas (LSOAs). * Registered Locality refers to individuals who are registered with GP practices that are assigned to a locality based on the Primary Care Network (PCN) they belong to. These assignments are approximate—PCNs are mapped to a locality based on the location of most of their GP surgeries. As a result, locality-registered patients may live outside the locality, sometimes even in different towns or cities. This distinction is important because some health indicators are only available at GP practice level, without information on where patients actually reside. In such cases, data is attributed to the locality based on GP registration, not residential address. [Click here] to explore more from the Birmingham and Solihull Integrated Care Partnerships Outcome Framework.
Emergency admissions for coronary heart disease - ICP Outcomes Framework - Birmingham and Solihull Wards

This dataset presents the age-standardised rate of emergency hospital admissions for coronary heart disease (CHD) across England. It provides insight into the burden of acute cardiovascular events requiring urgent care, helping to inform public health strategies and healthcare planning. The indicator focuses on unplanned hospital admissions where CHD is the primary diagnosis, offering a measure of both disease prevalence and healthcare system responsiveness. ## Rationale Reducing emergency admissions for coronary heart disease is a key public health objective. High rates of emergency admissions may indicate poor disease management in the community or delayed access to preventative care. Monitoring this indicator supports efforts to improve cardiovascular health outcomes and reduce strain on emergency services. ## Numerator The numerator is the count of emergency hospital admissions where the primary diagnosis is coronary heart disease, identified using ICD-10 codes I20 to I25. Admissions are included if they meet specific criteria: admission method codes ('21', '22', '23', '24', '25', '28', '2A', '2B', '2C', '2D'), patient classification as 'ordinary' (1 or 2), episode status equal to 3, and episode order equal to 1. These values are derived from Secondary Uses Service (SUS) data. ## Denominator The denominator is the expected number of admissions, calculated by applying England's age-specific rates to the local registered population. Population estimates are based on Census 2021 data. ## Caveats There are known data quality issues affecting Hospital Episode Statistics (HES) data for Nottingham University Hospitals Trust during the 2016–2017 financial year. Over 30% of records lacked valid geographic information, and as a result, Public Health England (PHE) has not published a value for this trust. Additionally, due to disclosure control, some values have not been published. ## External References [Fingertips Public Health Profiles – Coronary Heart Disease Indicator] [Click here] to explore more from the Birmingham and Solihull Integrated Care Partnerships Outcome Framework.
Census 2021 Overcrowding (Bedrooms) by Age

This metric provides a measure of whether a household's accommodation is overcrowded or under occupied, by age, for Birmingham. This occupancy rating is calculated by comparing the number of bedrooms the household requires to the number of available bedrooms. An occupancy rating of -1 implies that a household has one fewer bedroom than required, whereas +1 implies that they have one more bedroom than the standard requirement. Coverage This dataset is focused on the data for Birmingham at city level. About the 2021 Census The Census takes place every 10 years and gives us a picture of all the people and households in England and Wales. Protecting personal data The ONS sometimes need to make changes to data if it is possible to identify individuals. This is known as statistical disclosure control. In Census 2021, they: * Swapped records (targeted record swapping), for example, if a household was likely to be identified in datasets because it has unusual characteristics, they swapped the record with a similar one from a nearby small area. Very unusual households could be swapped with one in a nearby local authority. * Added small changes to some counts (cell key perturbation), for example, we might change a count of four to a three or a five. This might make small differences between tables depending on how the data are broken down when they applied perturbation. For more geographies, aggregations or topics see the link in the Reference below. Or, to create a custom dataset with multiple variables use the ONS [Create a custom dataset tool].
Overcrowded households (Percentage) - WMCA Wards (2025)

This metric provides a measure of whether a household's accommodation is overcrowded or under occupied. It is calculated by summing households with one room too few and households with two or more rooms too few, as a percentage of all households. The ages of the household members and their relationships to each other are used to derive the number of rooms/bedrooms they require, based on a standard formula. The number of rooms/bedrooms required is subtracted from the number of rooms/bedrooms in the household's accommodation to obtain the occupancy rating. An occupancy rating of -1 implies that a household has one fewer room/bedroom than required, whereas +1 implies that they have one more room/bedroom than the standard requirement. Statistical Disclosure Control: In order to protect against disclosure of personal information from the Census, there has been swapping of records in the Census database between different geographic areas, and so some counts will be affected. In the main, the greatest effects will be at the lowest geographies, since the record swapping is targeted towards those households with unusual characteristics in small areas. Data is [Powered by LG Inform Plus] and automatically checked for new data on the 4th of each month.
Trade union facility time data

This data contains details of Trade Union Facility time since 2013 and covers reporting requirements for the Data Transparency Code 2015. This provides details of the number of employees within the Education Function Birmingham City Council including schools who were relevant union representatives officials during the relevant period, and their FTE; the number of union representatives and FTE who spend 50% and above of their working hours on TU duties; a basic estimate of spending on unions (calculated as the number of full time equivalent days spent on union duties by staff that spend the majority of their time on union duties multiplied by the average salary); a basic estimate of spending on unions as a percentage of the total pay bill (calculated as the number of full time equivalent days spent on union duties by staff that spend the majority of their time on union duties multiplied by the average salary and divided by the total pay bill).
Boundaries - Birmingham and Solihull NHS Proxy Locality

This file contains the digital vector boundaries for the Birmingham and Solihull NHS Integrated Care Partnership Localities. Localities can overlap but for the purpose of mapping they are assigned a location based on a constituency. The mapping is as follows; ──────────────────────┬──────── PCON21NM │Locality ──────────────────────┼──────── Birmingham, Hall Green│Central ──────────────────────┼──────── Birmingham, Selly Oak │Central ──────────────────────┼──────── Birmingham, Hodge Hill│East ──────────────────────┼──────── Birmingham, Yardley │East ──────────────────────┼──────── Birmingham, Erdington │North ──────────────────────┼──────── Sutton Coldfield │North ──────────────────────┼──────── Meriden │Solihull ──────────────────────┼──────── Solihull │Solihull ──────────────────────┼──────── Birmingham, Edgbaston │South ──────────────────────┼──────── Birmingham, Northfield│South ──────────────────────┼──────── Birmingham, Ladywood │West ──────────────────────┼──────── Birmingham, Perry Barr│West ──────────────────────┴──────── Contains both Ordnance Survey and ONS Intellectual Property Rights. ## TopoJSON Shapefile for Power BI On the Export tab you will find a file under the Alternative exports. This file is in TopoJSON format and is ready for use in compatible visualisation tools such as Power BI or Mapbox.
Emergency admissions for diabetes (under 19yrs) - ICP Outcomes Framework - Birmingham and Solihull Wards

This dataset presents the crude rate of emergency hospital admissions for insulin-dependent diabetes mellitus (Type 1 diabetes) among children and young people aged under 19. It provides insight into the burden of acute diabetic complications requiring urgent care and supports the evaluation of diabetes management in paediatric populations. ## Rationale Reducing emergency admissions for diabetes in children is a key public health objective. High admission rates may indicate challenges in managing the condition, such as poor glycaemic control, lack of access to specialist care, or gaps in education and support for families. Monitoring this indicator helps inform strategies to improve diabetes care and reduce preventable hospitalisations. ## Numerator The numerator is the number of emergency hospital admissions for individuals aged under 19 with a primary diagnosis of insulin-dependent diabetes mellitus, identified using ICD-10 code E10. Data are sourced from NHS England’s Secondary Uses Service (SUS). ## Denominator The denominator is the total resident population aged under 19, based on the 2021 Census. ## Caveats No specific caveats were noted for this dataset. However, as with all hospital admission indicators, local variations in clinical coding, referral practices, and healthcare access may influence the results. ## External References [Fingertips Public Health Profiles – Diabetes Admissions (Under 19)] [Click here] to explore more from the Birmingham and Solihull Integrated Care Partnerships Outcome Framework.