Medicare Number of Cases Measures

These measures describe the number of cases for each procedure. The measures are separated by individual MS-DRG numbers and they can all be grouped under measure group id 2.

Queries

Acquiring data on CMS Median Reimbursements 

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 = 2

measure_iddrgdescription_friendlyauthor_measure_id
10538038Number of cases for Extracranial procedures (MS-DRG 038) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_038
10539039Number of cases for Extracranial procedures (MS-DRG 039) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_039
10540190Number of cases for Chronic obstructive pulmonary disease (MS-DRG 190) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_190
10541191Number of cases for Chronic obstructive pulmonary disease (MS-DRG 191) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_191
10542192Number of cases for Chronic obstructive pulmonary disease (MS-DRG 192) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_192
10543193Number of cases for Simple pneumonia & pleurisy (MS-DRG 193) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_193
10544219Number of cases for Cardiac valve & oth maj cardiothoracic proc w/o card cath (MS-DRG 219) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_219
10545220Number of cases for Cardiac valve & oth maj cardiothoracic proc w/o card cath (MS-DRG 220) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_220
10546221Number of cases for Cardiac valve & oth maj cardiothoracic proc w/o card cath (MS-DRG 221) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_221
10547224Number of cases for Cardiac defib implant w cardiac cath w/o AMI/HF/shock (MS-DRG 224) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_224
10548225Number of cases for Cardiac defib implant w cardiac cath w/o AMI/HF/shock (MS-DRG 225) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_225
10549226Number of cases for Cardiac defibrillator implant w/o cardiac cath (MS-DRG 226) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_226
10550227Number of cases for Cardiac defibrillator implant w/o cardiac cath (MS-DRG 227) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_227
10551235Number of cases for Coronary bypass w/o cardiac cath (MS-DRG 235) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_235
10552236Number of cases for Coronary bypass w/o cardiac cath (MS-DRG 236) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_236
10553237Number of cases for Major cardiovasc procedures (MS-DRG 237) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_237
10554243Number of cases for Permanent cardiac pacemaker implant (MS-DRG 243) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_243
10555244Number of cases for Permanent cardiac pacemaker implant (MS-DRG 244) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_244
10556247Number of cases for Perc cardiovasc proc w drug-eluting stent (MS-DRG 247) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_247
10557280Number of cases for Acute myocardial infarction, discharged alive (MS-DRG 280) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_280
10558281Number of cases for Acute myocardial infarction, discharged alive (MS-DRG 281) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_281
10559282Number of cases for Acute myocardial infarction, discharged alive (MS-DRG 282) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_282
10560291Number of cases for Heart failure & shock (MS-DRG 291) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_291
10561292Number of cases for Heart failure & shock (MS-DRG 292) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_292
10562293Number of cases for Heart failure & shock (MS-DRG 293) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_293
10563313Number of cases for Chest Pain (MS-DRG 313).Medicare_Number_of_Cases_MS_DRG_313
10564328Number of cases for Stomach, esophageal & duodenal proc (MS-DRG 328) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_328
10565329Number of cases for Major small & large bowel procedures (MS-DRG 329) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_329
10566330Number of cases for Major small & large bowel procedures (MS-DRG 330) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_330
10567331Number of cases for Major small & large bowel procedures (MS-DRG 331) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_331
10568353Number of cases for Hernia procedures except inguinal & femoral (MS-DRG 353) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_353
10569354Number of cases for Hernia procedures except inguinal & femoral (MS-DRG 354) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_354
10570355Number of cases for Hernia procedures except inguinal & femoral (MS-DRG 355) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_355
10571414Number of cases for Cholecystectomy except by laparoscope w/o c.d.e. (MS-DRG 414) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_414
10572417Number of cases for Laparoscopic cholecystectomy w/o c.d.e. (MS-DRG 417) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_417
10573418Number of cases for Laparoscopic cholecystectomy w/o c.d.e. (MS-DRG 418) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_418
10574419Number of cases for Laparoscopic cholecystectomy w/o c.d.e. (MS-DRG 419) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_419
10575459Number of cases for Spinal fusion except cervical (MS-DRG 459) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_459
10576460Number of cases for Spinal fusion except cervical (MS-DRG 460) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_460
10577461Number of cases for Bilateral or multiple major joint procs of lower extremity (MS-DRG 461) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_461
10578462Number of cases for Bilateral or multiple major joint procs of lower extremity (MS-DRG 462) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_462
10579466Number of cases for Revision of hip or knee replacement (MS-DRG 466) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_466
10580467Number of cases for Revision of hip or knee replacement (MS-DRG 467) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_467
10581468Number of cases for Revision of hip or knee replacement (MS-DRG 468) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_468
10582469Number of cases for Major joint replacement or reattachment of lower extremity (MS-DRG 469) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_469
10583470Number of cases for Major joint replacement or reattachment of lower extremity (MS-DRG 470) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_470
10584471Number of cases for Cervical spinal fusion (MS-DRG 471) with multiple complications or comorbiditiesMedicare_Number_of_Cases_MS_DRG_471
10585472Number of cases for Cervical spinal fusion (MS-DRG 472) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_472
10586473Number of cases for Cervical spinal fusion (MS-DRG 473) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_473
10587477Number of cases for Biopsies of musculoskeletal system & connective tissue (MS-DRG 477) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_477
10588478Number of cases for Biopsies of musculoskeletal system & connective tissue (MS-DRG 478) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_478
10589479Number of cases for Biopsies of musculoskeletal system & connective tissue (MS-DRG 479) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_479
10590490Number of cases for Back & neck proc exc spinal fusion (MS-DRG 490) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_490
10591491Number of cases for Back & neck proc exc spinal fusion (MS-DRG 491) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_491
10592507Number of cases for Major shoulder or elbow joint procedures (MS-DRG 507) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_507
10593508Number of cases for Major shoulder or elbow joint procedures (MS-DRG 508) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_508
10594515Number of cases for Other musculoskelet sys & conn tiss O.R. proc (MS-DRG 515) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_515
10595637Number of cases for Diabetes (MS-DRG 637) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_637
10596656Number of cases for Kidney & ureter procedures for neoplasm (MS-DRG 656) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_656
10597657Number of cases for Kidney & ureter procedures for neoplasm (MS-DRG 657) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_657
10598658Number of cases for Kidney & ureter procedures for neoplasm (MS-DRG 658) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_658
10599659Number of cases for Kidney & ureter procedures for non-neoplasm (MS-DRG 659) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_659
10600668Number of cases for Transurethral procedures (MS-DRG 668) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_668
10601673Number of cases for Other kidney & urinary tract procedures (MS-DRG 673) with multiple complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_673
10602674Number of cases for Other kidney & urinary tract procedures (MS-DRG 674) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_674
10603675Number of cases for Other kidney & urinary tract procedures (MS-DRG 675) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_675
10604713Number of cases for Transurethral prostatectomy (MS-DRG 713) with complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_713
10605714Number of cases for Transurethral prostatectomy (MS-DRG 714) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_714
10606743Number of cases for Uterine & adnexa proc for non-malignancy (MS-DRG 743) without complications or comorbidities.Medicare_Number_of_Cases_MS_DRG_743
10607748Number of cases for Female reproductive system reconstructive procedures (MS-DRG 748).Medicare_Number_of_Cases_MS_DRG_748