Surgical Outcomes

**Overview** This data package shows the Incidence & Surgical Procedures for Diabetes and PAD HRR Level, Readmission of Diabetic Patients Post Bariatric Surgery HRR Level and Revascularization HRR Level for the year 2014. **Description** This report from the Dartmouth Atlas series on variation in the care of surgical conditions carefully details the scope of the problem of diabetes and peripheral arterial disease and, as in previous Atlas analyses, emphasizes geographic practice variation in both preventive services and in surgical treatment rates. This Dartmouth Atlas of Health Care series reports on unwarranted regional variation in the care of several conditions for which surgery is one important treatment option. **Benefits** - Useful to compare the surgical interventions for diabetes complications. useful to analyze the impact of factors like age, gender and race/ethnicity on the utilization of surgical healthcare services for diabetes complications. useful for preventive and curative healthcare resources management. **License Information** The use of John Snow Labs datasets is free for personal and research purposes. For commercial use please subscribe to the [Data Library](https://www.johnsnowlabs.com/marketplace/) on John Snow Labs website. The subscription will allow you to use all John Snow Labs datasets and data packages for commercial purposes. **Included Datasets** - [Incidence and Surgical Procedures for Diabetes and PAD HRR Level 2014](https://www.johnsnowlabs.com/marketplace/incidence-and-surgical-procedures-for-diabetes-and-pad-hrr-level-2014) - This report from the Dartmouth Atlas series on variation in the care of surgical conditions carefully details the scope of the problem of diabetes and peripheral arterial disease and, as in previous Atlas analyses, emphasizes geographic practice variation in both preventive services and in surgical treatment rates. - [Readmission of Diabetic Patients Post Bariatric Surgery HRR Level 2014](https://www.johnsnowlabs.com/marketplace/readmission-of-diabetic-patients-post-bariatric-surgery-hrr-level-2014) - This report from The Dartmouth Atlas series in support by The Michigan Bariatric Surgery Collaborative (MBSC) carefully details the scope of the ever-increasing problem of obesity and, as in previous Atlas analyses, emphasizes geographic practice variation in surgical treatment rates. However, the report also takes a more longitudinal view. - [Readmission of Diabetic Patients Post Revascularization HRR Level 2014](https://www.johnsnowlabs.com/marketplace/readmission-of-diabetic-patients-post-revascularization-hrr-level-2014) - This report from the Dartmouth Atlas series on variation in the care of surgical conditions carefully details the scope of the problem of diabetes and peripheral arterial disease and, as in previous Atlas analyses, emphasizes geographic practice variation in both preventive services and in surgical treatment rates. **Data Engineering Overview** **We deliver high-quality data** - Each dataset goes through 3 levels of quality review - 2 Manual reviews are done by domain experts - Then, an automated set of 60+ validations enforces every datum matches metadata & defined constraints - Data is normalized into one unified type system - All dates, unites, codes, currencies look the same - All null values are normalized to the same value - All dataset and field names are SQL and Hive compliant - Data and Metadata - Data is available in both CSV and Apache Parquet format, optimized for high read performance on distributed Hadoop, Spark & MPP clusters - Metadata is provided in the open Frictionless Data standard, and its every field is normalized & validated - Data Updates - Data updates support replace-on-update: outdated foreign keys are deprecated, not deleted **Our data is curated and enriched by domain experts** Each dataset is manually curated by our team of doctors, pharmacists, public health & medical billing experts: - Field names, descriptions, and normalized values are chosen by people who actually understand their meaning - Healthcare & life science experts add categories, search keywords, descriptions and more to each dataset - Both manual and automated data enrichment supported for clinical codes, providers, drugs, and geo-locations - The data is always kept up to date – even when the source requires manual effort to get updates - Support for data subscribers is provided directly by the domain experts who curated the data sets - Every data source’s license is manually verified to allow for royalty-free commercial use and redistribution. **Need Help?** If you have questions about our products, contact us at [[e-mail]](mailto:[e-mail]).**概述** 本数据包涵盖2014年三个维度的数据集：糖尿病与外周动脉疾病（PAD, Peripheral Arterial Disease）医院转诊区域（HRR, Hospital Referral Region）发病率及外科手术情况、糖尿病患者减重外科手术后再入院率（医院转诊区域维度）以及血运重建术（医院转诊区域维度）数据。 **数据集详情** 本报告隶属于达特茅斯卫生保健地图集（Dartmouth Atlas of Health Care）系列，聚焦外科疾病诊疗的地域差异，详细阐释了糖尿病与外周动脉疾病的问题范畴，且如既往地图集分析那般，着重强调了预防服务与外科手术治疗率两方面的地域诊疗实践差异。本系列报告旨在揭示多种需以手术作为重要治疗手段的疾病所存在的不合理区域诊疗差异。 **数据集价值** - 可用于对比糖尿病并发症的外科干预方案； - 可用于分析年龄、性别、种族/族裔等因素对糖尿病并发症外科医疗服务使用率的影响； - 可用于预防性与治疗性医疗资源的管理规划。 **授权信息** 约翰·斯诺实验室（John Snow Labs）的数据集可免费用于个人学习与科研用途。若需商用，请前往约翰·斯诺实验室官网的[数据资源库](https://www.johnsnowlabs.com/marketplace/)订阅相关服务。订阅后即可商用使用约翰·斯诺实验室旗下所有数据集与数据包。 **包含数据集** 1. [2014年糖尿病与外周动脉疾病医院转诊区域发病率及外科手术情况](https://www.johnsnowlabs.com/marketplace/incidence-and-surgical-procedures-for-diabetes-and-pad-hrr-level-2014) - 本报告隶属于达特茅斯卫生保健地图集系列，聚焦外科疾病诊疗的地域差异，详细阐释了糖尿病与外周动脉疾病的问题范畴，且如既往地图集分析那般，着重强调了预防服务与外科手术治疗率两方面的地域诊疗实践差异。 2. [2014年糖尿病患者减重外科手术后再入院率（医院转诊区域维度）](https://www.johnsnowlabs.com/marketplace/readmission-of-diabetic-patients-post-bariatric-surgery-hrr-level-2014) - 本报告隶属于达特茅斯卫生保健地图集系列，由密歇根减重外科协作组（MBSC, Michigan Bariatric Surgery Collaborative）支持，详细阐释了日益严峻的肥胖问题范畴，且如既往地图集分析那般，着重强调了外科手术治疗率的地域差异。此外，本报告还采用了更长期的纵向研究视角。 3. [2014年糖尿病患者血运重建术后再入院率（医院转诊区域维度）](https://www.johnsnowlabs.com/marketplace/readmission-of-diabetic-patients-post-revascularization-hrr-level-2014) - 本报告隶属于达特茅斯卫生保健地图集系列，聚焦外科疾病诊疗的地域差异，详细阐释了糖尿病与外周动脉疾病的问题范畴，且如既往地图集分析那般，着重强调了预防服务与外科手术治疗率两方面的地域诊疗实践差异。 **数据工程概览** **我们提供高质量数据** - 每份数据集均经过三级质量审核： 1. 由领域专家完成2次人工审核； 2. 随后通过包含60余项校验规则的自动化流程，确保所有数据均符合元数据定义与预设约束条件。 - 数据已归一化至统一类型体系： - 所有日期、单位、编码、货币格式均保持统一； - 所有空值均归一化为统一标准值； - 所有数据集与字段名称均符合SQL与Hive语法规范。 - 数据与元数据： - 数据以CSV与Apache Parquet两种格式提供，针对分布式Hadoop、Spark及大规模并行处理（MPP, Massively Parallel Processing）集群的高读取性能进行了优化； - 元数据采用开放的无摩擦数据（Frictionless Data）标准，所有字段均经过归一化与校验。 - 数据更新： - 数据更新采用替换式更新策略：过时的外键将被标记为废弃，而非直接删除。 **数据集由领域专家精心甄选与富集** 每份数据集均由我们的医生、药剂师、公共卫生与医疗计费专家团队手动整理： - 字段名称、描述与归一化值均由真正理解其含义的专业人员选定； - 医疗健康与生命科学领域专家为每份数据集添加分类、搜索关键词、描述等补充信息； - 针对临床编码、服务提供者、药品及地理位置信息，同时支持人工与自动化富集流程； - 始终保持数据更新时效性，即便数据源需要手动操作才能获取更新； - 为数据订阅者提供的支持由负责整理该数据集的领域专家直接提供； - 所有数据源的授权协议均经过人工验证，确保可免版税商用并重新分发。 **获取帮助？** 若您对我们的产品有任何疑问，请发送邮件至[[e-mail]](mailto:[e-mail]).

搜集汇总

背景与挑战

背景概述

该数据集收录了2014年糖尿病及周围动脉疾病的手术治疗数据，重点分析不同地区在预防服务和手术治疗率方面的差异。包含三个子数据集，分别涉及糖尿病并发症手术、减肥手术后患者再入院率及血运重建手术数据，适用于医疗资源管理和手术效果比较研究。