Average Covered Charges Measures

These measures describe the average covered charge for a medical or surgical inpatient admission billed to Medicare. The measures are separated by individual MS-DRG numbers and they can all be grouped under measure group id 55.

Queries

Acquiring data on CMS Average Covered Charges

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

measure_id	drg	description_friendly	author_measure_id
14164	039	Average Covered Charges for Extracranial procedures w/o CC/MCC	AVGcovCHARGE_MSDRG_039
14165	057	Average Covered Charges for Degenerative nervous system disorders w/o MCC	AVGcovCHARGE_MSDRG_057
14166	064	Average Covered Charges for Intracranial hemorrhage or cerebral infarction w MCC	AVGcovCHARGE_MSDRG_064
14167	065	Average Covered Charges for Intracranial hemorrhage or cerebral infarction w CC	AVGcovCHARGE_MSDRG_065
14168	066	Average Covered Charges for Intracranial hemorrhage or cerebral infarction w/o CC/MCC	AVGcovCHARGE_MSDRG_066
14169	069	Average Covered Charges for Transient ischemia	AVGcovCHARGE_MSDRG_069
14170	074	Average Covered Charges for Cranial & peripheral nerve disorders w/o MCC	AVGcovCHARGE_MSDRG_074
14171	101	Average Covered Charges for Seizures w/o MCC	AVGcovCHARGE_MSDRG_101
14172	176	Average Covered Charges for Pulmonary embolism w/o MCC	AVGcovCHARGE_MSDRG_176
14173	177	Average Covered Charges for Respiratory infections & inflammations w MCC	AVGcovCHARGE_MSDRG_177
14174	178	Average Covered Charges for Respiratory infections & inflammations w CC	AVGcovCHARGE_MSDRG_178
14175	189	Average Covered Charges for Pulmonary edema & respiratory failure	AVGcovCHARGE_MSDRG_189
14176	190	Average Covered Charges for Chronic Obstructive pulmonary disease w MCC	AVGcovCHARGE_MSDRG_190
14177	191	Average Covered Charges for Chronic Obstructive pulmonary disease w CC	AVGcovCHARGE_MSDRG_191
14178	192	Average Covered Charges for MS-DRG 192, Chronic Obstructive Pulmonary Disease without complications or comorbidities	AVGcovCHARGE_MSDRG_192
14179	193	Average Covered Charges for Simple pneumonia & pleurisy w MCC	AVGcovCHARGE_MSDRG_193
14180	194	Average Covered Charges for Simple pneumonia & pleurisy w CC	AVGcovCHARGE_MSDRG_194
14181	195	Average Covered Charges for MS-DRG 195, Pneumonia without complications or comorbidities	AVGcovCHARGE_MSDRG_195
14182	202	Average Covered Charges for Bronchitis & asthma w CC/MCC	AVGcovCHARGE_MSDRG_202
14183	207	Average Covered Charges for Respiratory system diagnosis w ventilator support 96+ hours	AVGcovCHARGE_MSDRG_207
14184	208	Average Covered Charges for Respiratory system diagnosis w ventilator support <96 hours	AVGcovCHARGE_MSDRG_208
14185	238	Average Covered Charges for Major cardiovasc procedures w/o MCC	AVGcovCHARGE_MSDRG_238
14186	243	Average Covered Charges for Permanent cardiac pacemaker implant w CC	AVGcovCHARGE_MSDRG_243
14187	244	Average Covered Charges for Permanent cardiac pacemaker implant w/o CC/MCC	AVGcovCHARGE_MSDRG_244
14188	246	Average Covered Charges for Perc cardiovasc proc w drug-eluting stent w MCC or 4+ vessels/stents	AVGcovCHARGE_MSDRG_246
14189	247	Average Covered Charges for Perc cardiovasc proc w drug-eluting stent w/o MCC	AVGcovCHARGE_MSDRG_247
14190	249	Average Covered Charges for Perc cardiovasc proc w non-drug-eluting stent w/o MCC	AVGcovCHARGE_MSDRG_249
14191	251	Average Covered Charges for Perc cardiovasc proc w/o coronary artery stent w/o MCC	AVGcovCHARGE_MSDRG_251
14192	252	Average Covered Charges for Other vascular procedures w MCC	AVGcovCHARGE_MSDRG_252
14193	253	Average Covered Charges for Other vascular procedures w CC	AVGcovCHARGE_MSDRG_253
14194	254	Average Covered Charges for Other vascular procedures w/o CC/MCC	AVGcovCHARGE_MSDRG_254
14195	280	Average Covered Charges for Acute myocardial infarction, discharged alive w MCC	AVGcovCHARGE_MSDRG_280
14196	281	Average Covered Charges for Acute myocardial infarction, discharged alive w CC	AVGcovCHARGE_MSDRG_281
14197	282	Average Covered Charges for Acute myocardial infarction, discharged alive w/o CC/MCC	AVGcovCHARGE_MSDRG_282
14198	286	Average Covered Charges for Circulatory disorders except AMI, w card cath w MCC	AVGcovCHARGE_MSDRG_286
14199	287	Average Covered Charges for Circulatory disorders except AMI, w card cath w/o MCC	AVGcovCHARGE_MSDRG_287
14200	291	Average Covered Charges for MS-DRG 291, Heart Failure with Multiple Complications	AVGcovCHARGE_MSDRG_291
14201	292	Average Covered Charges for MS-DRG 292, Heart Failure with Complications	AVGcovCHARGE_MSDRG_292
14202	293	Average Covered Charges for MS-DRG 293, Heart Failure without complications or comorbidities	AVGcovCHARGE_MSDRG_293
14203	300	Average Covered Charges for Peripheral vascular disorders w CC	AVGcovCHARGE_MSDRG_300
14204	301	Average Covered Charges for Peripheral vascular disorders w/o CC/MCC	AVGcovCHARGE_MSDRG_301
14205	303	Average Covered Charges for Atherosclerosis w/o MCC	AVGcovCHARGE_MSDRG_303
14206	308	Average Covered Charges for Cardiac arrhythmia & conduction disorders w MCC	AVGcovCHARGE_MSDRG_308
14207	309	Average Covered Charges for Cardiac arrhythmia & conduction disorders w CC	AVGcovCHARGE_MSDRG_309
14208	310	Average Covered Charges for Cardiac arrhythmia & conduction disorders w/o CC/MCC	AVGcovCHARGE_MSDRG_310
14209	312	Average Covered Charges for Syncope & collapse	AVGcovCHARGE_MSDRG_312
14210	313	Average Covered Charges for MS-DRG 313, Chest Pain without complications or comorbidities	AVGcovCHARGE_MSDRG_313
14211	314	Average Covered Charges for Other circulatory system diagnoses w MCC	AVGcovCHARGE_MSDRG_314
14212	315	Average Covered Charges for Other circulatory system diagnoses w CC	AVGcovCHARGE_MSDRG_315
14213	329	Average Covered Charges for Major small & large bowel procedures w MCC	AVGcovCHARGE_MSDRG_329
14214	330	Average Covered Charges for Major small & large bowel procedures w CC	AVGcovCHARGE_MSDRG_330
14215	372	Average Covered Charges for Major gastrointestinal disorders & peritoneal infections w CC	AVGcovCHARGE_MSDRG_372
14216	377	Average Covered Charges for G.I. hemorrhage w MCC	AVGcovCHARGE_MSDRG_377
14217	378	Average Covered Charges for G.I. hemorrhage w CC	AVGcovCHARGE_MSDRG_378
14218	389	Average Covered Charges for G.I. obstruction w CC	AVGcovCHARGE_MSDRG_389
14219	390	Average Covered Charges for G.I. obstruction w/o CC/MCC	AVGcovCHARGE_MSDRG_390
14220	391	Average Covered Charges for Esophagitis, gastroent & misc digest disorders w MCC	AVGcovCHARGE_MSDRG_391
14221	392	Average Covered Charges for MS-DRG 392, Digestive Disorders	AVGcovCHARGE_MSDRG_392
14222	394	Average Covered Charges for Other digestive system diagnoses w CC	AVGcovCHARGE_MSDRG_394
14223	418	Average Covered Charges for Laparoscopic cholecystectomy w/o c.d.e. w CC	AVGcovCHARGE_MSDRG_418
14224	419	Average Covered Charges for MS-DRG 419, Gallbladder Removal By Laparoscope without complications or comorbidities	AVGcovCHARGE_MSDRG_419
14225	460	Average Covered Charges for Spinal fusion except cervical w/o MCC	AVGcovCHARGE_MSDRG_460
14226	469	Average Covered Charges for Major joint replacement or reattachment of lower extremity w MCC	AVGcovCHARGE_MSDRG_469
14227	470	Average Covered Charges for MS-DRG 470, Major Joint Replacement	AVGcovCHARGE_MSDRG_470
14228	473	Average Covered Charges for Cervical spinal fusion w/o CC/MCC	AVGcovCHARGE_MSDRG_473
14229	480	Average Covered Charges for Hip & femur procedures except major joint w MCC	AVGcovCHARGE_MSDRG_480
14230	481	Average Covered Charges for Hip & femur procedures except major joint w CC	AVGcovCHARGE_MSDRG_481
14231	491	Average Covered Charges for Back & neck proc exc spinal fusion w/o CC/MCC	AVGcovCHARGE_MSDRG_491
14232	552	Average Covered Charges for Medical back problems w/o MCC	AVGcovCHARGE_MSDRG_552
14233	602	Average Covered Charges for Cellulitis w MCC	AVGcovCHARGE_MSDRG_602
14234	603	Average Covered Charges for MS-DRG 603, Cellulitis w/o MCC	AVGcovCHARGE_MSDRG_603
14235	638	Average Covered Charges for Diabetes w CC	AVGcovCHARGE_MSDRG_638
14236	640	Average Covered Charges for Nutritional & misc metabolic disorders w MCC	AVGcovCHARGE_MSDRG_640
14237	641	Average Covered Charges for MS-DRG 641, Metabolic Disorders	AVGcovCHARGE_MSDRG_641
14238	682	Average Covered Charges for Renal failure w MCC	AVGcovCHARGE_MSDRG_682
14239	683	Average Covered Charges for Renal failure w CC	AVGcovCHARGE_MSDRG_683
14240	684	Average Covered Charges for Renal failure w/o CC/MCC	AVGcovCHARGE_MSDRG_684
14241	689	Average Covered Charges for Kidney & urinary tract infections w MCC	AVGcovCHARGE_MSDRG_689
14242	690	Average Covered Charges for MS-DRG 690, Urinary Tract Infections	AVGcovCHARGE_MSDRG_690
14243	698	Average Covered Charges for Other kidney & urinary tract diagnoses w MCC	AVGcovCHARGE_MSDRG_698
14244	699	Average Covered Charges for Other kidney & urinary tract diagnoses w CC	AVGcovCHARGE_MSDRG_699
14245	811	Average Covered Charges for Red blood cell disorders w MCC	AVGcovCHARGE_MSDRG_811
14246	812	Average Covered Charges for Red blood cell disorders w/o MCC	AVGcovCHARGE_MSDRG_812
14247	853	Average Covered Charges for Infectious & parasitic diseases w O.R. procedure w MCC	AVGcovCHARGE_MSDRG_853
14248	870	Average Covered Charges for Septicemia or severe sepsis w MV 96+ hours	AVGcovCHARGE_MSDRG_870
14249	871	Average Covered Charges for MS-DRG 871, Septicemia with Multiple Complications	AVGcovCHARGE_MSDRG_871
14250	872	Average Covered Charges for Septicemia or severe sepsis w/o MV 96+ hours w/o MCC	AVGcovCHARGE_MSDRG_872
14251	885	Average Covered Charges for MS-DRG 885, Psychoses	AVGcovCHARGE_MSDRG_885
14252	897	Average Covered Charges for MS-DRG 897, Alcohol/Drug Abuse	AVGcovCHARGE_MSDRG_897
14253	917	Average Covered Charges for Poisoning & toxic effects of drugs w MCC	AVGcovCHARGE_MSDRG_917
14254	918	Average Covered Charges for Poisoning & toxic effects of drugs w/o MCC	AVGcovCHARGE_MSDRG_918
14255	948	Average Covered Charges for Signs & symptoms w/o MCC	AVGcovCHARGE_MSDRG_948
14256	439	Average Covered Charges for Disorders of pancreas except malignancy w CC	AVGcovCHARGE_MSDRG_439
14257	203	Average Covered Charges for MS-DRG 203, Bronchitis and Asthma without complications or comorbidities	AVGcovCHARGE_MSDRG_203
14258	379	Average Covered Charges for G.I. hemorrhage w/o CC/MCC	AVGcovCHARGE_MSDRG_379
14259	563	Average Covered Charges for Fx, sprn, strn & disl except femur, hip, pelvis & thigh w/o MCC	AVGcovCHARGE_MSDRG_563
14260	482	Average Covered Charges for Hip & femur procedures except major joint w/o CC/MCC	AVGcovCHARGE_MSDRG_482
14261	536	Average Covered Charges for Fractures of hip & pelvis w/o MCC	AVGcovCHARGE_MSDRG_536
14262	305	Average Covered Charges for Hypertension w/o MCC	AVGcovCHARGE_MSDRG_305
14263	149	Average Covered Charges for Dysequilibrium	AVGcovCHARGE_MSDRG_149