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_id	drg	description_friendly	author_measure_id
10538	038	Number of cases for Extracranial procedures (MS-DRG 038) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_038
10539	039	Number of cases for Extracranial procedures (MS-DRG 039) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_039
10540	190	Number of cases for Chronic obstructive pulmonary disease (MS-DRG 190) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_190
10541	191	Number of cases for Chronic obstructive pulmonary disease (MS-DRG 191) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_191
10542	192	Number of cases for Chronic obstructive pulmonary disease (MS-DRG 192) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_192
10543	193	Number of cases for Simple pneumonia & pleurisy (MS-DRG 193) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_193
10544	219	Number 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
10545	220	Number 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
10546	221	Number 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
10547	224	Number 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
10548	225	Number 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
10549	226	Number 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
10550	227	Number of cases for Cardiac defibrillator implant w/o cardiac cath (MS-DRG 227) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_227
10551	235	Number of cases for Coronary bypass w/o cardiac cath (MS-DRG 235) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_235
10552	236	Number of cases for Coronary bypass w/o cardiac cath (MS-DRG 236) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_236
10553	237	Number of cases for Major cardiovasc procedures (MS-DRG 237) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_237
10554	243	Number of cases for Permanent cardiac pacemaker implant (MS-DRG 243) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_243
10555	244	Number of cases for Permanent cardiac pacemaker implant (MS-DRG 244) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_244
10556	247	Number of cases for Perc cardiovasc proc w drug-eluting stent (MS-DRG 247) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_247
10557	280	Number of cases for Acute myocardial infarction, discharged alive (MS-DRG 280) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_280
10558	281	Number of cases for Acute myocardial infarction, discharged alive (MS-DRG 281) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_281
10559	282	Number of cases for Acute myocardial infarction, discharged alive (MS-DRG 282) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_282
10560	291	Number of cases for Heart failure & shock (MS-DRG 291) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_291
10561	292	Number of cases for Heart failure & shock (MS-DRG 292) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_292
10562	293	Number of cases for Heart failure & shock (MS-DRG 293) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_293
10563	313	Number of cases for Chest Pain (MS-DRG 313).	Medicare_Number_of_Cases_MS_DRG_313
10564	328	Number of cases for Stomach, esophageal & duodenal proc (MS-DRG 328) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_328
10565	329	Number of cases for Major small & large bowel procedures (MS-DRG 329) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_329
10566	330	Number of cases for Major small & large bowel procedures (MS-DRG 330) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_330
10567	331	Number of cases for Major small & large bowel procedures (MS-DRG 331) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_331
10568	353	Number of cases for Hernia procedures except inguinal & femoral (MS-DRG 353) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_353
10569	354	Number of cases for Hernia procedures except inguinal & femoral (MS-DRG 354) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_354
10570	355	Number of cases for Hernia procedures except inguinal & femoral (MS-DRG 355) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_355
10571	414	Number 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
10572	417	Number 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
10573	418	Number of cases for Laparoscopic cholecystectomy w/o c.d.e. (MS-DRG 418) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_418
10574	419	Number of cases for Laparoscopic cholecystectomy w/o c.d.e. (MS-DRG 419) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_419
10575	459	Number of cases for Spinal fusion except cervical (MS-DRG 459) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_459
10576	460	Number of cases for Spinal fusion except cervical (MS-DRG 460) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_460
10577	461	Number 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
10578	462	Number 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
10579	466	Number of cases for Revision of hip or knee replacement (MS-DRG 466) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_466
10580	467	Number of cases for Revision of hip or knee replacement (MS-DRG 467) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_467
10581	468	Number of cases for Revision of hip or knee replacement (MS-DRG 468) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_468
10582	469	Number 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
10583	470	Number 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
10584	471	Number of cases for Cervical spinal fusion (MS-DRG 471) with multiple complications or comorbidities	Medicare_Number_of_Cases_MS_DRG_471
10585	472	Number of cases for Cervical spinal fusion (MS-DRG 472) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_472
10586	473	Number of cases for Cervical spinal fusion (MS-DRG 473) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_473
10587	477	Number of cases for Biopsies of musculoskeletal system & connective tissue (MS-DRG 477) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_477
10588	478	Number of cases for Biopsies of musculoskeletal system & connective tissue (MS-DRG 478) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_478
10589	479	Number of cases for Biopsies of musculoskeletal system & connective tissue (MS-DRG 479) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_479
10590	490	Number of cases for Back & neck proc exc spinal fusion (MS-DRG 490) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_490
10591	491	Number of cases for Back & neck proc exc spinal fusion (MS-DRG 491) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_491
10592	507	Number of cases for Major shoulder or elbow joint procedures (MS-DRG 507) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_507
10593	508	Number of cases for Major shoulder or elbow joint procedures (MS-DRG 508) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_508
10594	515	Number 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
10595	637	Number of cases for Diabetes (MS-DRG 637) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_637
10596	656	Number of cases for Kidney & ureter procedures for neoplasm (MS-DRG 656) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_656
10597	657	Number of cases for Kidney & ureter procedures for neoplasm (MS-DRG 657) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_657
10598	658	Number of cases for Kidney & ureter procedures for neoplasm (MS-DRG 658) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_658
10599	659	Number of cases for Kidney & ureter procedures for non-neoplasm (MS-DRG 659) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_659
10600	668	Number of cases for Transurethral procedures (MS-DRG 668) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_668
10601	673	Number of cases for Other kidney & urinary tract procedures (MS-DRG 673) with multiple complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_673
10602	674	Number of cases for Other kidney & urinary tract procedures (MS-DRG 674) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_674
10603	675	Number of cases for Other kidney & urinary tract procedures (MS-DRG 675) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_675
10604	713	Number of cases for Transurethral prostatectomy (MS-DRG 713) with complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_713
10605	714	Number of cases for Transurethral prostatectomy (MS-DRG 714) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_714
10606	743	Number of cases for Uterine & adnexa proc for non-malignancy (MS-DRG 743) without complications or comorbidities.	Medicare_Number_of_Cases_MS_DRG_743
10607	748	Number of cases for Female reproductive system reconstructive procedures (MS-DRG 748).	Medicare_Number_of_Cases_MS_DRG_748

Browser not supported