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_id | author_measure_id | name_friendly |
12093 | COUNT_MSDRG_885_PED | Number of Patients: Psychoses (Pediatric) |
12086 | COUNT_MSDRG_203_PED | Number of Patients: Bronchitis and Asthma (Pediatric) |
12085 | COUNT_MSDRG_775_PED | Number of Patients: Vaginal Birth (Pediatric) |
10664 | COUNT_MSDRG_743 | Number of Patients: Uterine Procedures for Nonmalignancy without Multiple Complications |
10663 | COUNT_MSDRG_292 | Number of Patients: Heart Failure with Complications |
10662 | COUNT_MSDRG_291 | Number of Patients: Heart Failure with Multiple Complications |
10661 | COUNT_MSDRG_765 | Number of Patients: Cesarean with Multiple Complications |
10660 | COUNT_MSDRG_690 | Number of Patients: Urinary Tract Infections |
10659 | COUNT_MSDRG_945 | Number of Patients: Rehabilitation Multiple Complications |
10658 | COUNT_MSDRG_871 | Number of Patients: Septicemia with Multiple Complications |
10657 | COUNT_MSDRG_641 | Number of Patients: Metabolic Disorders |
10656 | COUNT_MSDRG_603 | Number of Patients: Cellulitis |
10655 | COUNT_MSDRG_794 | Number of Patients: Neonate with Other Significant Problems |
10654 | COUNT_MSDRG_897 | Number of Patients: Alcohol/Drug Abuse |
10653 | COUNT_MSDRG_470 | Number of Patients: Major Joint Replacement |
10652 | COUNT_MSDRG_392 | Number of Patients: Digestive Disorders |
10651 | COUNT_MSDRG_885 | Number of Patients: Psychoses |
10451 | COUNT_MSDRG_192 | Number of Patients: Chronic Obstructive Pulmonary Disease |
10448 | COUNT_MSDRG_795 | Number of Patients: Normal Newborn |
10406 | COUNT_MSDRG_203 | Number of Patients: Bronchitis and Asthma |
10405 | COUNT_MSDRG_775 | Number of Patients: Vaginal Birth |
10404 | COUNT_MSDRG_766 | Number of Patients: Caesarian Section |
10403 | COUNT_MSDRG_343 | Number of Patients: Appendectomy |
10110 | COUNT_MSDRG_419 | Number of Patients: Gallbladder Removal |
10099 | COUNT_MSDRG_639 | Number of Patients: Diabetes |
10091 | COUNT_MSDRG_313 | Number of Patients: Chest Pain |
10090 | COUNT_MSDRG_293 | Number of Patients: Heart Failure |
10086 | COUNT_MSDRG_195 | Number of Patients: Pneumonia |