United States US: Diabetes Prevalence: % of Population Aged 20-79 data was reported at 10.790 % in 2017. United States US: Diabetes Prevalence: % of Population Aged 20-79 data is updated yearly, averaging 10.790 % from Dec 2017 (Median) to 2017, with 1 observations. United States US: Diabetes Prevalence: % of Population Aged 20-79 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s USA – Table US.World Bank: Health Statistics. Diabetes prevalence refers to the percentage of people ages 20-79 who have type 1 or type 2 diabetes.; ; International Diabetes Federation, Diabetes Atlas.; Weighted average;

SUMMARYThis analysis, designed and executed by Ribble Rivers Trust, identifies areas across England with the greatest levels of diabetes mellitus in persons (aged 17+). Please read the below information to gain a full understanding of what the data shows and how it should be interpreted.ANALYSIS METHODOLOGYThe analysis was carried out using Quality and Outcomes Framework (QOF) data, derived from NHS Digital, relating to diabetes mellitus in persons (aged 17+).This information was recorded at the GP practice level. However, GP catchment areas are not mutually exclusive: they overlap, with some areas covered by 30+ GP practices. Therefore, to increase the clarity and usability of the data, the GP-level statistics were converted into statistics based on Middle Layer Super Output Area (MSOA) census boundaries.The percentage of each MSOA’s population (aged 17+) with diabetes mellitus was estimated. This was achieved by calculating a weighted average based on:The percentage of the MSOA area that was covered by each GP practice’s catchment areaOf the GPs that covered part of that MSOA: the percentage of registered patients that have that illness The estimated percentage of each MSOA’s population with diabetes mellitus was then combined with Office for National Statistics Mid-Year Population Estimates (2019) data for MSOAs, to estimate the number of people in each MSOA with depression, within the relevant age range.Each MSOA was assigned a relative score between 1 and 0 (1 = worst, 0 = best) based on:A) the PERCENTAGE of the population within that MSOA who are estimated to have diabetes mellitusB) the NUMBER of people within that MSOA who are estimated to have diabetes mellitusAn average of scores A & B was taken, and converted to a relative score between 1 and 0 (1= worst, 0 = best). The closer to 1 the score, the greater both the number and percentage of the population in the MSOA that are estimated to have diabetes mellitus, compared to other MSOAs. In other words, those are areas where it’s estimated a large number of people suffer from diabetes mellitus, and where those people make up a large percentage of the population, indicating there is a real issue with diabetes mellitus within the population and the investment of resources to address that issue could have the greatest benefits.LIMITATIONS1. GP data for the financial year 1st April 2018 – 31st March 2019 was used in preference to data for the financial year 1st April 2019 – 31st March 2020, as the onset of the COVID19 pandemic during the latter year could have affected the reporting of medical statistics by GPs. However, for 53 GPs (out of 7670) that did not submit data in 2018/19, data from 2019/20 was used instead. Note also that some GPs (997 out of 7670) did not submit data in either year. This dataset should be viewed in conjunction with the ‘Health and wellbeing statistics (GP-level, England): Missing data and potential outliers’ dataset, to determine areas where data from 2019/20 was used, where one or more GPs did not submit data in either year, or where there were large discrepancies between the 2018/19 and 2019/20 data (differences in statistics that were > mean +/- 1 St.Dev.), which suggests erroneous data in one of those years (it was not feasible for this study to investigate this further), and thus where data should be interpreted with caution. Note also that there are some rural areas (with little or no population) that do not officially fall into any GP catchment area (although this will not affect the results of this analysis if there are no people living in those areas).2. Although all of the obesity/inactivity-related illnesses listed can be caused or exacerbated by inactivity and obesity, it was not possible to distinguish from the data the cause of the illnesses in patients: obesity and inactivity are highly unlikely to be the cause of all cases of each illness. By combining the data with data relating to levels of obesity and inactivity in adults and children (see the ‘Levels of obesity, inactivity and associated illnesses: Summary (England)’ dataset), we can identify where obesity/inactivity could be a contributing factor, and where interventions to reduce obesity and increase activity could be most beneficial for the health of the local population.3. It was not feasible to incorporate ultra-fine-scale geographic distribution of populations that are registered with each GP practice or who live within each MSOA. Populations might be concentrated in certain areas of a GP practice’s catchment area or MSOA and relatively sparse in other areas. Therefore, the dataset should be used to identify general areas where there are high levels of diabetes mellitus, rather than interpreting the boundaries between areas as ‘hard’ boundaries that mark definite divisions between areas with differing levels of diabetes mellitus.TO BE VIEWED IN COMBINATION WITH:This dataset should be viewed alongside the following datasets, which highlight areas of missing data and potential outliers in the data:Health and wellbeing statistics (GP-level, England): Missing data and potential outliersLevels of obesity, inactivity and associated illnesses (England): Missing dataDOWNLOADING THIS DATATo access this data on your desktop GIS, download the ‘Levels of obesity, inactivity and associated illnesses: Summary (England)’ dataset.DATA SOURCESThis dataset was produced using:Quality and Outcomes Framework data: Copyright © 2020, Health and Social Care Information Centre. The Health and Social Care Information Centre is a non-departmental body created by statute, also known as NHS Digital.GP Catchment Outlines. Copyright © 2020, Health and Social Care Information Centre. The Health and Social Care Information Centre is a non-departmental body created by statute, also known as NHS Digital. Data was cleaned by Ribble Rivers Trust before use.COPYRIGHT NOTICEThe reproduction of this data must be accompanied by the following statement:© Ribble Rivers Trust 2021. Analysis carried out using data that is: Copyright © 2020, Health and Social Care Information Centre. The Health and Social Care Information Centre is a non-departmental body created by statute, also known as NHS Digital.CaBA HEALTH & WELLBEING EVIDENCE BASEThis dataset forms part of the wider CaBA Health and Wellbeing Evidence Base.

Decrease the percentage of people with Type 2 diabetes from 11.2% in 2014 to 10.1% by 2019.

Population-based county-level estimates for diagnosed (DDP), undiagnosed (UDP), and total diabetes prevalence (TDP) were acquired from the Institute for Health Metrics and Evaluation (IHME) for the years 2004-2012 (Evaluation 2017). Prevalence estimates were calculated using a two-stage approach. The first stage used National Health and Nutrition Examination Survey (NHANES) data to predict high fasting plasma glucose (FPG) levels (≥126 mg/dL) and/or hemoglobin A1C (HbA1C) levels (≥6.5% [48 mmol/mol]) based on self-reported demographic and behavioral characteristics (Dwyer-Lindgren, Mackenbach et al. 2016). This model was then applied to Behavioral Risk Factor Surveillance System (BRFSS) data to impute high FPG and/or A1C status for each BRFSS respondent (Dwyer-Lindgren, Mackenbach et al. 2016). The second stage used the imputed BRFSS data to fit a series of small area models, which were used to predict the county-level prevalence of each of the diabetes-related outcomes (Dwyer-Lindgren, Mackenbach et al. 2016). Diagnosed diabetes was defined as the proportion of adults (age 20+ years) who reported a previous diabetes diagnosis, represented as an age-standardized prevalence percentage. Undiagnosed diabetes was defined as proportion of adults (age 20+ years) who have a high FPG or HbA1C but did not report a previous diagnosis of diabetes. Total diabetes was defined as the proportion of adults (age 20+ years) who reported a previous diabetes diagnosis and/or had a high FPG/HbA1C. The age-standardized diabetes prevalence (%) was used as the outcome. The EQI was constructed for 2000-2005 for all US counties and is composed of five domains (air, water, built, land, and sociodemographic), each composed of variables to represent the environmental quality of that domain. Domain-specific EQIs were developed using principal components analysis (PCA) to reduce these variables within each domain while the overall EQI was constructed from a second PCA from these individual domains (L. C. Messer et al., 2014). To account for differences in environment across rural and urban counties, the overall and domain-specific EQIs were stratified by rural urban continuum codes (RUCCs) (U.S. Department of Agriculture, 2015). This dataset is not publicly accessible because: EPA cannot release personally identifiable information regarding living individuals, according to the Privacy Act and the Freedom of Information Act (FOIA). This dataset contains information about human research subjects. Because there is potential to identify individual participants and disclose personal information, either alone or in combination with other datasets, individual level data are not appropriate to post for public access. Restricted access may be granted to authorized persons by contacting the party listed. It can be accessed through the following means: Human health data are not available publicly. EQI data are available at: https://edg.epa.gov/data/Public/ORD/NHEERL/EQI. Format: Data are stored as csv files. This dataset is associated with the following publication: Jagai, J., A. Krajewski, S. Shaikh, D. Lobdell, and R. Sargis. Association between environmental quality and diabetes in the U.S.A.. Journal of Diabetes Investigation. John Wiley & Sons, Inc., Hoboken, NJ, USA, 11(2): 315-324, (2020).

South Africa ZA: Diabetes Prevalence: % of Population Aged 20-79 data was reported at 5.520 % in 2017. South Africa ZA: Diabetes Prevalence: % of Population Aged 20-79 data is updated yearly, averaging 5.520 % from Dec 2017 (Median) to 2017, with 1 observations. South Africa ZA: Diabetes Prevalence: % of Population Aged 20-79 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s South Africa – Table ZA.World Bank: Health Statistics. Diabetes prevalence refers to the percentage of people ages 20-79 who have type 1 or type 2 diabetes.; ; International Diabetes Federation, Diabetes Atlas.; Weighted average;

Singapore SG: Diabetes Prevalence: % of Population Aged 20-79 data was reported at 10.990 % in 2017. Singapore SG: Diabetes Prevalence: % of Population Aged 20-79 data is updated yearly, averaging 10.990 % from Dec 2017 (Median) to 2017, with 1 observations. Singapore SG: Diabetes Prevalence: % of Population Aged 20-79 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Singapore – Table SG.World Bank.WDI: Health Statistics. Diabetes prevalence refers to the percentage of people ages 20-79 who have type 1 or type 2 diabetes.; ; International Diabetes Federation, Diabetes Atlas.; Weighted average;

NY State Community Health Indicators

Obesity and Diabetes Related Indicators 2008–2012

By Health Data New York [source]

About this dataset

This dataset contains New York State county-level data on obesity and diabetes related indicators from 2008 - 2012. It includes information about counties' population health status, such as the number of events, percentage/rate, 95% confidence interval, measured units and more. Analyzing this data provides insight into how communities across New York State are impacted by these diseases and how we can work together to create healthier living environments for everyone. This dataset is released under a Terms of Service license agreement – make sure to read through and understand the details if you plan to use it in any research or commercial application

More Datasets

For more datasets, click here.

Featured Notebooks

• 🚨 Your notebook can be here! 🚨!

How to use the dataset

This dataset contains county-level data on obesity and diabetes related indicators in New York State. As such, it can be used to research indicators related to general health in various counties of the state.

To use this dataset effectively, first become familiar with the columns included and their meanings: - County Name: The name of the county. (String) - County Code: The code of the county. (Integer) - Region Name: The name of the region. (String) - Indicator Number: The number of the indicator. (Integer) - Total Event Counts: The total number of events related to the indicator.(Integer)
- Denominator: The denominator used to calculate the percentage/rate.(Integer) - Denominator Note: Any additional notes related to the denominator.(String) - Measure Unit :The unit of measure used for this rate/percentage .(String). - Percentage/Rate :The percentage/rate calculated using denominator and observed count data .(Float). - 95% CI :The 95% confidence interval associated with any defined rate or percentage.(Float). - Data Comments :Any additional comments relevant to this data source or indicator .(String ). - Data Years :Years covered by this particular indicator observation .(String ). - Data Sources :Sources from which we have drawn our data for indicators involving counties from different regions .(Strings). - Quartile :Quartiles are derived when all geographic entities are ranked according to a specific metric score ,and are then cut into quartiles based on speed score =0= bottom quarter; =1= middle two quarters combined; =2= top quarter..(Integer). - Mapping Distribution ;A visual representation that includes mapping details regarding how Indicators relating either disease rates or characteristics are positioned across States, regions and counties as well as any trends plus other pertinent mapping information ,such as health resource availability.(In pair plot form form otherwise text will present an informational string.). Location ;Area where distribution around space occurs..e point feature with a single location ID retrieved from geoplanet proxy service.. (string ).

Using these columns, you can find out demographic information about your chosen county such as obesity rate and diabetes incidence etc., enabling you better understand its health situation overall. Additionally,this dataset also provides important comparison features such as quartiles rankings

Research Ideas

• Analysing the geographic distribution of obesity and diabetes related indicators by county in New York State, in order to identify areas which may require greater levels of intervention and preventative health measures.

• Evaluating trends over time for different counties to assess whether policies or programs have had an impact on indicators relating to obesity and diabetes within the given area.

• Using machine learning techniques such as clustering analysis or predictive modelling, to identify patterns within the data which can be used to better inform preventative health interventions across New York State

Acknowledgements

If you use this dataset in your research, please credit the original authors. Data Source

License

See the dataset description for more information.

Columns

File: community-health-obesity-and-diabetes-related-indicators-2008-2012-1.csv | Column name | Description | |:-------------------------|:-----------------------------------------------------------------------------------------| | **Count...

IntroductionType 2 diabetes (T2D) is a growing public health burden throughout the world. Many people looking for information on how to prevent T2D will search on diabetes websites. Multiple dietary factors have a significant association with T2D risk, such as high intake of added sugars, refined carbohydrates, saturated fat, and red meat or processed meat; and decreased intake of dietary fiber, and fruits/vegetables. Despite this dietary information being available in the scientific literature, it is unclear whether this information is available in gray literature (websites).ObjectiveIn this study, we evaluate the use of specific terms from diabetes websites that are significantly associated with causes/risk factors and preventions for T2D from three term categories: (A) dietary factors, (B) nondietary nongenetic (lifestyle-associated) factors, and (C) genetic (non-modifiable) factors. We also evaluate the effect of website type (business, government, nonprofit) on term usage among websites.MethodsWe used web scraping and coding tools to quantify the use of specific terms from 73 diabetes websites. To determine the effect of term category and website type on the usage of specific terms among 73 websites, a repeated measures general linear model was performed.ResultsWe found that dietary risk factors that are significantly associated with T2D (e.g., sugar, processed carbohydrates, dietary fat, fruits/vegetables, fiber, processed meat/red meat) were mentioned in significantly fewer websites than either nondietary nongenetic factors (e.g., obesity, physical activity, dyslipidemia, blood pressure) or genetic factors (age, family history, ethnicity). Among websites that provided “eat healthy” guidance, one third provided zero dietary factors associated with type 2 diabetes, and only 30% provided more than two specific dietary factors associates with type 2 diabetes. We also observed that mean percent usage of all terms associated with T2D causes/risk factors and preventions was significantly lower among government websites compared to business websites and nonprofit websites.ConclusionDiabetes websites need to increase their usage of dietary factors when discussing causes/risk factors and preventions for T2D; as dietary factors are modifiable and strongly associated with all nondietary nongenetic risk factors, in addition to T2D risk.

The percentage of people with diabetes who have received nine care processes. Current version updated: Mar-17 Next version due: Mar-18

Nigeria NG: Diabetes Prevalence: % of Population Aged 20-79 data was reported at 2.420 % in 2017. Nigeria NG: Diabetes Prevalence: % of Population Aged 20-79 data is updated yearly, averaging 2.420 % from Dec 2017 (Median) to 2017, with 1 observations. Nigeria NG: Diabetes Prevalence: % of Population Aged 20-79 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Nigeria – Table NG.World Bank.WDI: Health Statistics. Diabetes prevalence refers to the percentage of people ages 20-79 who have type 1 or type 2 diabetes.; ; International Diabetes Federation, Diabetes Atlas.; Weighted average;

This public health factsheet describes facts, assets, and strategies related to diabetes in Camden.

As per the results of a large scale survey conducted across India, **** percent of the respondents had diabetes in 2021. This was an increase in the share of people with diabetes compared to the previous years of the survey. Overall, lifestyle diseases like diabetes, thyroid and blood pressure were seen to be rising among Indians.

Number and percentage of Canadians aged 20 to 79 with diabetes, prediabetes, as well as diabetes awareness, pharmaceutical treatment and glycemic control among those with diabetes by age group and sex.

Note: This dataset has been archived as of January 2024 after confirmation from NHS Digital that the source dataset is no longer being updated, and there is not a replacement publication for the diabetic ketoacidosis admissions data. This indicator is one measure of the prevention, identification and management of people at risk of developing diabetes and those with the condition. It shows adverse outcomes as annual numbers of emergency hospital admissions for diabetic ketoacidosis and coma. Emergency admissions to hospital can be avoided by identifying people at risk, primary care services interventions, encouraging better diet and exercise, improving self-monitoring and diabetes control and supporting patients and carers in the management of diabetes in the home. It needs local health and care services working effectively together to support people’s health and independence in the community. Type 2 diabetes (around 90 percent of diabetes diagnoses) is partially preventable - it can be prevented or delayed by lifestyle changes (exercise, weight loss, healthy eating). Earlier detection of type 2 diabetes followed by effective treatment reduces the risk of developing diabetic complications. These include cardiovascular, kidney, foot and eye diseases, meaning considerable illness and reduced quality of life. There are some limitations to this data, as raw counts of hospital episodes are subject to population structures (such as numbers of people in older age groups) and other underlying variations. Counts below 5 are removed from the data. The data is updated annually. Sources: NHS Digital (now part of NHS England) - dataset P02177, and commentary from the Office for Health Improvement and Disparities (OHID) Public Health Outcomes Framework (PHOF) indicator 2.17 Recorded Diabetes.

This dataset provides the percentage of individuals aged 40 to 64 who are registered with type 2 diabetes, based on data from GP practices participating in the National Diabetes Audit (NDA). It offers insights into the burden of type 2 diabetes within this age group and supports efforts to monitor and reduce its prevalence through targeted public health interventions.

Rationale The indicator aims to reduce the prevalence of type 2 diabetes among adults aged 40 to 64. Monitoring this age group is critical, as early detection and management of diabetes can significantly reduce the risk of complications and improve long-term health outcomes.

Numerator The numerator is the number of people aged 40 to 64 who are registered with type 2 diabetes at GP practices that participate in the National Diabetes Audit.

Denominator The denominator is the total number of people registered with type 2 diabetes at participating GP practices, regardless of age.

Caveats The data is collected over a 15-month period, from January 1st of the first year to March 31st of the following year. Individuals not registered with a GP practice at the time of data collection are excluded. From 2022–23 onwards, values are not reported where the denominator is 20 or fewer, to protect confidentiality and ensure data reliability.

External references Public Health England - Fingertips: Prevalence of type 2 diabetes

Click here to explore more from the Birmingham and Solihull Integrated Care Partnerships Outcome Framework.

Data Collected from the study of Obese patients who took part in Virtual Chronic Disese intervention (VCDI). Reults were collected on patients experiencing various Health illnesesses, but primarily focused on the intervention program influencing Type 2 Diabetes remission.

The dataset has the total 93 individuals that took part in this research program, with the following description of the collumns provided below:

Patient: Patient ID Age: Age of patient at the beginning of intervetion Gender: Gender code (M,F) TimeInProgramInWeeks: Duration of individual in program in Weeks StartingWeight: Weight at beginning of program AfterProgramWeight: Weight after program WeightLost: Difference of Weight before and after program WeightLostPercentage: Weight Difference as a percent. StartingBMI: Body-Mass-Index at beginning of program AfterProgramBMI: Body-Mass-Index after program CompletedPodcastSession: the number of podcast completed in program CompletedPodcastSessionPercentage: percentage of podcast completed out of 60. CompletedFlag: flag for patients who created over 25 podcasts T2DFlag: flag for Type-2 Diabetes (T2D) patients T2DRemissionFlag: flag for Type-2 Diabetes patients who entered remission DroppedOutFlag: flag for patients who had to drop out of program. T2DDroppedOutFlag: flag for T2D patients who didn't complete program T2DNoncompletedFlag: flag for patients who did not complete 25 podcasts or more during the program. T2DInProgramFlag: flag for T2D individuals in the program T2DCompletedFlag: flag for T2D individuals who completed 25 podcasts or more T2DCompletedInRemissionFlag: flag for T2D individuals who completed 25 podcasts or more and whoes diabetes were in remission T2DNonCompletedInRemissionFlag: flag for T2D individuals who completed 25 podcasts or more and whoes diabetes were in remission

The R coded included Provides a step by step guide to constructed the fishers odds ratio test that was used in this research, as well as providing the average weight loss amongst completers and non-completer groups.

This dataset provides the percentage of individuals aged 40 to 64 who are registered with type 2 diabetes, based on data from GP practices participating in the National Diabetes Audit (NDA). It offers insights into the burden of type 2 diabetes within this age group and supports efforts to monitor and reduce its prevalence through targeted public health interventions.

Rationale The indicator aims to reduce the prevalence of type 2 diabetes among adults aged 40 to 64. Monitoring this age group is critical, as early detection and management of diabetes can significantly reduce the risk of complications and improve long-term health outcomes.

Numerator The numerator is the number of people aged 40 to 64 who are registered with type 2 diabetes at GP practices that participate in the National Diabetes Audit.

Denominator The denominator is the total number of people registered with type 2 diabetes at participating GP practices, regardless of age.

Caveats The data is collected over a 15-month period, from January 1st of the first year to March 31st of the following year. Individuals not registered with a GP practice at the time of data collection are excluded. From 2022–23 onwards, values are not reported where the denominator is 20 or fewer, to protect confidentiality and ensure data reliability.

External references Public Health England - Fingertips: Prevalence of type 2 diabetes

Localities ExplainedThis 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.

Malaysia Diabetes Prevalence: % of Population Aged 20-79 data was reported at 16.740 % in 2017. Malaysia Diabetes Prevalence: % of Population Aged 20-79 data is updated yearly, averaging 16.740 % from Dec 2017 (Median) to 2017, with 1 observations. Malaysia Diabetes Prevalence: % of Population Aged 20-79 data remains active status in CEIC and is reported by World Bank. The data is categorized under Global Database’s Malaysia – Table MY.World Bank.WDI: Health Statistics. Diabetes prevalence refers to the percentage of people ages 20-79 who have type 1 or type 2 diabetes.; ; International Diabetes Federation, Diabetes Atlas.; Weighted average;

This set of files contains public data used to validate the grocery data. All references to the original sources are provided below.CHILD OBESITYPeriodically, the English National Health Service (NHS) publishes statistics about various aspects of the health and habits of people living in England, including obesity. The NHS National Child Measurement (NCMP) measures the height and weight of children in Reception class (aged 4 to 5) and year 6 (aged 10 to 11), to assess overweight and obesity levels in children within primary schools. The program is carried out every year in England and statistics are produced at the level of Local Authority (that corresponds to Boroughs in London). We report the data for the school year 2015-2016 (file: child_obesity_london_borough_2015-2016.csv). For the school year 2013-2014, statistics in London are also available at ward-level (file: child_obesity_london_ward_2013-2014.csv)The files are comma-separated and contain the following fields: area_id: the id of the boroughnumber_reception_measured: number of children in reception year measurednumber_y6_measured: number of children in reception year measuredprevalence_overweight_reception: the prevalence (percentage) of overweight children in reception year prevalence_overweight_y6: the prevalence (percentage) of overweight children in year 6prevalence_obese_reception: the prevalence (percentage) of obese children in reception yearprevalence_obese_y6: the prevalence (percentage) of obese children in year 6ADULT OBESITYThe Active People Survey (APS) was a survey used to measure the number of adults taking part in sport across England and included two questions about the height and weight of participants. We report the results of the APS for the year 2012. Prevalence of underweight, healthy weight, overweight, and obese people at borough level are provided in the file london_obesity_borough_2012.csv.The file is comma-separated and contains the following fields: area_id: the id of the boroughnumber_measured: number of people who participated in the surveyprevalence_healthy_weight: the prevalence (percentage) of healthy-weight peopleprevalence_overweight: the prevalence (percentage) of overweight peopleprevalence_obese: the prevalence (percentage) of obese peopleBARIATRIC HOSPITALIZATIONThe NHS records and publishes an annual compendium report about the number of hospital admissions attributable to obesity or bariatric surgery (i.e., weight loss surgery used as a treatment for people who are very obese), and the number of prescription items provided in primary care for the treatment of obesity. The NHS provides both raw counts at the Local Authority level and numbers normalized by population living in those areas. In the file obesity_hospitalization_borough_2016.csv, we report the statistics for the year 2015 (measurements made between Jan 2015 and March 2016).The file is comma-separated and contains the following fields:area_id: the id of the boroughtotal_hospitalizations: total number of obesity-related hospitalizationstotal_bariatric: total number of hospitalizations for bariatric surgeryprevalence_hospitalizations: prevalence (percentage) of obesity-related hospitalizations prevalence_bariatric: prevalence (percentage) of bariatric surgery hospitalizations DIABETESThrough the Quality and Outcomes Framework, NHS Digital publishes annually the number of people aged 17+ on a register for diabetes at each GP practice in England. NHS also publishes the number of people living in a census area who are registered to any of the GP in England. Based on these two sources, an estimate is produced about the prevalence of diabetes in each area. The data (file diabetes_estimates_osward_2016.csv) was collected in 2016 at LSOA-level and published at ward-level.The file is comma-separated and contains the following fields:area_id: the id of the wardgp_patients: total number of GP patients gp_patients_diabetes: total number of GP patients with a diabetes diagnosisestimated_diabetes_prevalence: prevalence (percentage) of diabetesAREA MAPPINGMapping of Greater London postcodes into larger geographical aggregations. The file is comma-separated and contains the following fields:pcd: postcodelat: latitudelong: longitudeoa11: output arealsoa11: lower super output areamsoa11: medium super output areaosward: wardoslaua: borough

Key Indicators of Heart Disease

2022 annual CDC survey data of 400k+ adults related to their health status

What subject does the dataset cover?

According to the CDC, heart disease is a leading cause of death for people of most races in the U.S. (African Americans, American Indians and Alaska Natives, and whites). About half of all Americans (47%) have at least 1 of 3 major risk factors for heart disease: high blood pressure, high cholesterol, and smoking. Other key indicators include diabetes status, obesity (high BMI), not getting enough physical activity, or drinking too much alcohol. Identifying and preventing the factors that have the greatest impact on heart disease is very important in healthcare. In turn, developments in computing allow the application of machine learning methods to detect "patterns" in the data that can predict a patient's condition.

Where did the data set come from and what treatments has it undergone?

The dataset originally comes from the CDC and is a major part of the Behavioral Risk Factor Surveillance System (BRFSS), which conducts annual telephone surveys to collect data on the health status of U.S. residents. As described by the CDC: "Established in 1984 with 15 states, BRFSS now collects data in all 50 states, the District of Columbia, and three U.S. territories. BRFSS completes more than 400,000 adult interviews each year, making it the largest continuously conducted health survey system in the world. The most recent dataset includes data from 2023. In this dataset, I noticed many factors (questions) that directly or indirectly influence heart disease, so I decided to select the most relevant variables from it. I also decided to share with you two versions of the most recent dataset: with NaNs and without it.

What can you do with this data set?

As described above, the original dataset of nearly 300 variables was reduced to 40variables. In addition to classical EDA, this dataset can be used to apply a number of machine learning methods, especially classifier models (logistic regression, SVM, random forest, etc.). You should treat the variable "HadHeartAttack" as binary ("Yes" - respondent had heart disease; "No" - respondent did not have heart disease). Note, however, that the classes are unbalanced, so the classic approach of applying a model is not advisable. Fixing the weights/undersampling should yield much better results. Based on the data set, I built a logistic regression model and embedded it in an application that might inspire you: https://share.streamlit.io/kamilpytlak/heart-condition-checker/main/app.py. Can you indicate which variables have a significant effect on the likelihood of heart disease?

What steps did you use to convert the dataset?

Check out this notebook in my GitHub repository: https://github.com/kamilpytlak/data-science-projects/blob/main/heart-disease-prediction/2022/notebooks/data_processing.ipynb