ICD-9 ICD-10 and Clinical Classification Codes

**Overview**
This data package includes information regarding Clinical Classification Software (CCS) for Diagnosis and Procedure Codes for International Classification of Diseases for Clinical Modification as well as Procedure Classification System. It also comprises of data about CCS for Mortality Reporting Program. It contains information regarding single level CCS for ICD-9 diagnosis and procedure codes.

**Description**
This data package contains the Agency for Healthcare Research and Quality (AHRQ) developed the Clinical Classifications Software (CCS), a tool for clustering patient diagnoses and procedures into a manageable number of clinically meaningful categories. CCS offers researchers the ability to group conditions and procedures without having to sort through thousands of codes and makes it easier to quickly understand patterns of diagnoses and procedures so that health plans, policymakers, and researchers can analyze costs, utilization, and outcomes associated with particular illnesses and procedures. CCS for ICD-10-CM and Procedure Classification System (PCS) is a diagnosis and procedure categorization scheme that can be employed in many types of projects analyzing data on diagnoses and procedures. CCS is based on the International Classification of Diseases, 10th Revision (ICD-10), a uniform and standardized coding system. CCS consists of two related classification systems, single-level and multi-level, which are designed to meet different needs. Single-level CCS is most useful for ranking of diagnoses and procedures and for direct integration into risk adjustment and other software. Multi-level CCS is ideal for evaluating larger aggregations of conditions and procedures or exploring these groupings in greater detail.

**Benefits**
- Useful for medical health planners, policymakers and medical research groups and medical students. clinical classifications software (ccs) for icd-10-cm database is available on hcup website in raw form, whereas a john snow labs(jsl) customer gets it in a clean and normalized form ready to use and create his own custom reports. easy to comprehend for the customers who are unfamiliar with the medical terminologies as all abbreviated terms are replaced with full form, unlike healthcare cost and utilization project (hcup) original datasets which are full of abbreviations. recent dataset for 2018 is available for use.

**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**
- [Clinical Classification Software Refined for ICD-10 CM](https://www.johnsnowlabs.com/marketplace/clinical-classification-software-refined-for-icd-10-cm)
- The Clinical Classifications Software Refined (CCSR) is one in a family of databases and software tools developed as part of the Healthcare Cost and Utilization Project (HCUP), a Federal-State-Industry partnership sponsored by the Agency for Healthcare Research and Quality (AHRQ). HCUP databases, tools, and software inform decision making at the national, state and community levels.
- [Clinical Classification Software for ICD-10 CM](https://www.johnsnowlabs.com/marketplace/clinical-classification-software-for-icd-10-cm)
- Clinical Classifications Software for ICD-10-CM Codes provides a way to classify diagnoses into a limited number of categories by aggregating individual ICD-10-CM codes into broad diagnosis groups to facilitate statistical analysis and reporting.
- [Clinical Classification Software for ICD-10 PCS](https://www.johnsnowlabs.com/marketplace/clinical-classification-software-for-icd-10-pcs)
- Clinical Classifications Software for ICD-10-PCS Codes provides a way to classify procedures into a limited number of categories by aggregating individual codes into broad diagnosis groups to facilitate statistical analysis and reporting.
- [Clinical Classification Software for Mortality Reporting Program](https://www.johnsnowlabs.com/marketplace/clinical-classification-software-for-mortality-reporting-program)
- The Clinical Classifications Software (CCS) for Mortality Reporting is a diagnosis categorization scheme that can be employed in many types of projects analyzing data on diagnoses. This tool is based on the International Classification of Diseases, 10th Revision (ICD-10), a uniform and standardized coding system, which has been used in the U.S. for mortality reporting since 1999.
- [Multi-Level Clinical Classification Software ICD-10 CM and PCS Codes](https://www.johnsnowlabs.com/marketplace/multi-level-clinical-classification-software-icd-10-cm-and-pcs-codes)
- Clinical Classifications Software for ICD-10-Clinical Modification (CM) and Procedural Classification System (PCS) Codes provides a way to classify diagnoses into a limited number of categories by aggregating multi-level ICD-10-CM and PCS codes into broad diagnosis groups to facilitate statistical analysis and reporting.
- [Single Level Clinical Classification Software ICD-9 Diagnosis Codes](https://www.johnsnowlabs.com/marketplace/single-level-clinical-classification-software-icd-9-diagnosis-codes)
- Clinical Classifications Software for ICD-9 Diagnosis Codes provides a way to classify diagnosis and procedures into a limited number of categories by aggregating individual ICD-9-CM codes into broad diagnosis and procedure groups to facilitate statistical analysis and reporting.
- [Single Level Clinical Classification Software ICD-9 Procedure Codes](https://www.johnsnowlabs.com/marketplace/single-level-clinical-classification-software-icd-9-procedure-codes)
- Clinical Classifications Software for ICD-9 Procedure Codes provides a way to classify diagnosis and procedures into a limited number of categories by aggregating individual ICD-9-CM codes into broad diagnosis and procedure groups to facilitate statistical analysis and reporting.

**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]).

**概述**
本数据包涵盖面向临床修改版国际疾病分类（International Classification of Diseases for Clinical Modification, ICD-10-CM）与手术分类系统（Procedure Classification System, PCS）的诊断及手术编码临床分类软件（Clinical Classification Software, CCS）相关信息，同时包含死亡报告项目专用CCS数据集，以及ICD-9诊断与手术编码的单层级CCS相关内容。

**数据集说明**
本数据包包含美国医疗保健研究与质量局（Agency for Healthcare Research and Quality, AHRQ）开发的临床分类软件（Clinical Classifications Software, CCS）相关内容：该工具可将患者诊断与手术编码聚类为数量可控且具备临床意义的分类组别。CCS可为研究人员提供将病症与手术进行分组的能力，无需逐一梳理数千条编码，同时便于快速理解诊断与手术的分布模式，助力健康保险机构、政策制定者及研究人员分析特定疾病与手术相关的成本、使用情况及转归。
面向ICD-10-CM与手术分类系统（PCS）的CCS是一套诊断与手术编码分类方案，可广泛应用于各类诊断及手术数据的分析项目。CCS基于统一标准化的编码系统——第10版国际疾病分类（International Classification of Diseases, 10th Revision, ICD-10）开发。CCS包含两个相互关联的分类体系：单层级与多层级，分别适配不同的应用需求。单层级CCS最适用于诊断与手术编码的排序，以及直接集成至风险调整及其他软件中；多层级CCS则更适合对大规模病症与手术分组进行评估，或对这些组别展开更细致的探索。

**优势**
本数据集适用于医疗规划者、政策制定者、医学研究团队及医学生。HCUP官网提供的ICD-10-CM临床分类软件数据库为原始格式，而约翰·斯诺实验室（John Snow Labs, JSL）的用户可获取经过清洗与标准化处理、可直接用于创建自定义报告的成品数据集。由于所有缩写术语均已替换为全称，即便不熟悉医学术语的用户也能轻松理解，这与充满缩写的医疗成本与利用项目（Healthcare Cost and Utilization Project, HCUP）原始数据集形成鲜明对比。目前已提供2018年的最新数据集供使用。

**授权信息**
约翰·斯诺实验室（John Snow Labs）的数据集可免费用于个人及研究用途。若需商业使用，请前往约翰·斯诺实验室官网订阅[数据资源库](https://www.johnsnowlabs.com/marketplace/)，订阅后可将所有约翰·斯诺实验室的数据集及数据包用于商业场景。

**包含数据集**
- [ICD-10 CM 精炼版临床分类软件](https://www.johnsnowlabs.com/marketplace/clinical-classification-software-refined-for-icd-10-cm)
- 临床分类精炼软件（Clinical Classifications Software Refined, CCSR）是美国医疗成本与利用项目（Healthcare Cost and Utilization Project, HCUP）旗下的数据库与软件工具系列之一，该项目是由美国医疗保健研究与质量局（AHRQ）资助的联邦-州-行业合作计划。HCUP的数据库、工具及软件可辅助国家、州级及社区层面的决策制定。
- [ICD-10 CM 临床分类软件](https://www.johnsnowlabs.com/marketplace/clinical-classification-software-for-icd-10-cm)
- ICD-10-CM临床分类软件可通过将单个ICD-10-CM编码聚合为宽泛的诊断组别，将诊断分类为有限数量的类别，以助力统计分析与报告工作。
- [ICD-10 PCS 临床分类软件](https://www.johnsnowlabs.com/marketplace/clinical-classification-software-for-icd-10-pcs)
- ICD-10-PCS临床分类软件可通过将单个手术编码聚合为宽泛的手术组别，将手术分类为有限数量的类别，以助力统计分析与报告工作。
- [死亡报告项目临床分类软件](https://www.johnsnowlabs.com/marketplace/clinical-classification-software-for-mortality-reporting-program)
- 死亡报告项目专用临床分类软件（CCS）是一套诊断分类方案，可广泛应用于各类诊断数据分析项目。该工具基于第10版国际疾病分类（ICD-10）这一统一标准化编码系统开发，美国自1999年起将其用于死亡报告工作。
- [ICD-10 CM与PCS编码多层级临床分类软件](https://www.johnsnowlabs.com/marketplace/multi-level-clinical-classification-software-icd-10-cm-and-pcs-codes)
- ICD-10临床修改版（ICD-10-CM）与手术分类系统（PCS）编码多层级临床分类软件，可通过将多层级ICD-10-CM与PCS编码聚合为宽泛的诊断组别，将诊断与手术分类为有限数量的类别，以助力统计分析与报告工作。
- [ICD-9诊断编码单层级临床分类软件](https://www.johnsnowlabs.com/marketplace/single-level-clinical-classification-software-icd-9-diagnosis-codes)
- ICD-9诊断编码临床分类软件可通过将单个ICD-9-CM诊断与手术编码聚合为宽泛的诊断及手术组别，将诊断与手术分类为有限数量的类别，以助力统计分析与报告工作。
- [ICD-9手术编码单层级临床分类软件](https://www.johnsnowlabs.com/marketplace/single-level-clinical-classification-software-icd-9-procedure-codes)
- ICD-9手术编码临床分类软件可通过将单个ICD-9-CM诊断与手术编码聚合为宽泛的诊断及手术组别，将诊断与手术分类为有限数量的类别，以助力统计分析与报告工作。

**数据工程概览**
**我们提供高质量数据**
- 每份数据集均经过三级质量审核：
- 2次人工审核由领域专家完成
- 随后通过60余项自动化验证流程，确保所有数据均符合元数据及预设约束条件
- 数据已标准化为统一的类型体系：
- 所有日期、单位、编码及货币格式均保持统一
- 所有空值均被标准化为统一格式
- 所有数据集及字段名称均符合SQL与Hive语法规范
- 数据与元数据：
- 数据提供CSV与Apache Parquet两种格式，针对分布式Hadoop、Spark及大规模并行处理（Massively Parallel Processing, MPP）集群的高读取性能进行了优化
- 元数据采用开放的Frictionless Data标准，所有字段均经过标准化与验证
- 数据更新：
- 数据更新采用替换更新模式：过时的外键将被标记为弃用而非直接删除

**我们的数据集均由领域专家进行整理与增强**
每份数据集均由我们的医生、药剂师、公共卫生及医疗计费专家团队进行人工整理：
- 字段名称、描述及标准化值均由真正理解其含义的专业人员选定
- 医疗与生命科学领域专家会为每份数据集添加分类、搜索关键词、描述等额外信息
- 针对临床编码、服务提供者、药品及地理定位信息，同时支持人工与自动化的数据增强流程
- 即便数据源需要手动操作才能完成更新，我们也会确保数据始终保持最新状态
- 数据订阅者可直接获得整理该数据集的领域专家提供的技术支持
- 所有数据源的授权均经过人工验证，确保可免版税用于商业用途及再分发

**需要帮助？**
若您对我们的产品有任何疑问，请发送邮件至[[e-mail]](mailto:[e-mail])。

搜集汇总

背景与挑战

背景概述

该数据集提供临床分类软件（CCS）工具，用于将ICD-9和ICD-10等国际疾病分类系统的诊断和程序代码聚类为临床有意义的类别，便于医疗健康研究和分析。它包含多个子数据集，涵盖诊断、程序及死亡率报告分类，并经过质量审查和规范化处理，适用于医疗规划、政策制定和学术研究。