Number of Patients (MS-DRG)

This section shows the number of patients visiting this facility for certain conditions or procedures.

SQL to acquire these measures is as follows:

Acquiring data on Number of Patients

select a.* from entity_values as a, measure_groups_measures as b
where a.measure_id = b.measure_id 
and a.entity_id = ######
and b.measure_group_id = 17

Measures: 

measure_idauthor_measure_idname_friendly
12093COUNT_MSDRG_885_PEDNumber of Patients: Psychoses (Pediatric)
12086COUNT_MSDRG_203_PEDNumber of Patients: Bronchitis and Asthma (Pediatric)
12085COUNT_MSDRG_775_PEDNumber of Patients: Vaginal Birth (Pediatric)
10664COUNT_MSDRG_743Number of Patients: Uterine Procedures for Nonmalignancy without Multiple Complications
10663COUNT_MSDRG_292Number of Patients: Heart Failure with Complications
10662COUNT_MSDRG_291Number of Patients: Heart Failure with Multiple Complications
10661COUNT_MSDRG_765Number of Patients: Cesarean with Multiple Complications
10660COUNT_MSDRG_690Number of Patients: Urinary Tract Infections
10659COUNT_MSDRG_945Number of Patients: Rehabilitation Multiple Complications
10658COUNT_MSDRG_871Number of Patients: Septicemia with Multiple Complications
10657COUNT_MSDRG_641Number of Patients: Metabolic Disorders
10656COUNT_MSDRG_603Number of Patients: Cellulitis
10655COUNT_MSDRG_794Number of Patients: Neonate with Other Significant Problems
10654COUNT_MSDRG_897Number of Patients: Alcohol/Drug Abuse
10653COUNT_MSDRG_470Number of Patients: Major Joint Replacement
10652COUNT_MSDRG_392Number of Patients: Digestive Disorders
10651COUNT_MSDRG_885Number of Patients: Psychoses
10451COUNT_MSDRG_192Number of Patients: Chronic Obstructive Pulmonary Disease
10448COUNT_MSDRG_795Number of Patients: Normal Newborn
10406COUNT_MSDRG_203Number of Patients: Bronchitis and Asthma
10405COUNT_MSDRG_775Number of Patients: Vaginal Birth
10404COUNT_MSDRG_766Number of Patients: Caesarian Section
10403COUNT_MSDRG_343Number of Patients: Appendectomy
10110COUNT_MSDRG_419Number of Patients: Gallbladder Removal
10099COUNT_MSDRG_639Number of Patients: Diabetes
10091COUNT_MSDRG_313Number of Patients: Chest Pain
10090COUNT_MSDRG_293Number of Patients: Heart Failure
10086COUNT_MSDRG_195Number of Patients: Pneumonia