Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

These measures describe the average covered charge for a procedure 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_iddrgdescription_friendlyauthor_measure_id
14164039Average Covered Charges for Extracranial procedures w/o CC/MCCAVGcovCHARGE_MSDRG_039
14165057Average Covered Charges for Degenerative nervous system disorders w/o MCCAVGcovCHARGE_MSDRG_057
14166064Average Covered Charges for Intracranial hemorrhage or cerebral infarction w MCCAVGcovCHARGE_MSDRG_064
14167065Average Covered Charges for Intracranial hemorrhage or cerebral infarction w CCAVGcovCHARGE_MSDRG_065
14168066Average Covered Charges for Intracranial hemorrhage or cerebral infarction w/o CC/MCCAVGcovCHARGE_MSDRG_066
14169069Average Covered Charges for Transient ischemiaAVGcovCHARGE_MSDRG_069
14170074Average Covered Charges for Cranial & peripheral nerve disorders w/o MCCAVGcovCHARGE_MSDRG_074
14171101Average Covered Charges for Seizures w/o MCCAVGcovCHARGE_MSDRG_101
14172176Average Covered Charges for Pulmonary embolism w/o MCCAVGcovCHARGE_MSDRG_176
14173177Average Covered Charges for Respiratory infections & inflammations w MCCAVGcovCHARGE_MSDRG_177
14174178Average Covered Charges for Respiratory infections & inflammations w CCAVGcovCHARGE_MSDRG_178
14175189Average Covered Charges for Pulmonary edema & respiratory failureAVGcovCHARGE_MSDRG_189
14176190Average Covered Charges for Chronic obstructive pulmonary disease w MCCAVGcovCHARGE_MSDRG_190
14177191Average Covered Charges for Chronic obstructive pulmonary disease w CCAVGcovCHARGE_MSDRG_191
14178192Average Covered Charges for DRG 192, bstructive Pulmonary Disease without complications or comorbidities (MS-DRG 192). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_192
14179193Average Covered Charges for Simple pneumonia & pleurisy w MCCAVGcovCHARGE_MSDRG_193
14180194Average Covered Charges for Simple pneumonia & pleurisy w CCAVGcovCHARGE_MSDRG_194
14181195Average Covered Charges for DRG 195, without complications or comorbidities (MS-DRG 195). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_195
14182202Average Covered Charges for Bronchitis & asthma w CC/MCCAVGcovCHARGE_MSDRG_202
14183207Average Covered Charges for Respiratory system diagnosis w ventilator support 96+ hoursAVGcovCHARGE_MSDRG_207
14184208Average Covered Charges for Respiratory system diagnosis w ventilator support <96 hoursAVGcovCHARGE_MSDRG_208
14185238Average Covered Charges for Major cardiovasc procedures w/o MCCAVGcovCHARGE_MSDRG_238
14186243Average Covered Charges for Permanent cardiac pacemaker implant w CCAVGcovCHARGE_MSDRG_243
14187244Average Covered Charges for Permanent cardiac pacemaker implant w/o CC/MCCAVGcovCHARGE_MSDRG_244
14188246Average Covered Charges for Perc cardiovasc proc w drug-eluting stent w MCC or 4+ vessels/stentsAVGcovCHARGE_MSDRG_246
14189247Average Covered Charges for Perc cardiovasc proc w drug-eluting stent w/o MCCAVGcovCHARGE_MSDRG_247
14190249Average Covered Charges for Perc cardiovasc proc w non-drug-eluting stent w/o MCCAVGcovCHARGE_MSDRG_249
14191251Average Covered Charges for Perc cardiovasc proc w/o coronary artery stent w/o MCCAVGcovCHARGE_MSDRG_251
14192252Average Covered Charges for Other vascular procedures w MCCAVGcovCHARGE_MSDRG_252
14193253Average Covered Charges for Other vascular procedures w CCAVGcovCHARGE_MSDRG_253
14194254Average Covered Charges for Other vascular procedures w/o CC/MCCAVGcovCHARGE_MSDRG_254
14195280Average Covered Charges for Acute myocardial infarction, discharged alive w MCCAVGcovCHARGE_MSDRG_280
14196281Average Covered Charges for Acute myocardial infarction, discharged alive w CCAVGcovCHARGE_MSDRG_281
14197282Average Covered Charges for Acute myocardial infarction, discharged alive w/o CC/MCCAVGcovCHARGE_MSDRG_282
14198286Average Covered Charges for Circulatory disorders except AMI, w card cath w MCCAVGcovCHARGE_MSDRG_286
14199287Average Covered Charges for Circulatory disorders except AMI, w card cath w/o MCCAVGcovCHARGE_MSDRG_287
14200291Average Covered Charges for DRG 291, lure with Multiple Complications (MS-DRG 291). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_291
14201292Average Covered Charges for DRG 292, lure with Complications (MS-DRG 292). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_292
14202293Average Covered Charges for DRG 293, lure without complications or comorbidities (MS-DRG 293). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_293
14203300Average Covered Charges for Peripheral vascular disorders w CCAVGcovCHARGE_MSDRG_300
14204301Average Covered Charges for Peripheral vascular disorders w/o CC/MCCAVGcovCHARGE_MSDRG_301
14205303Average Covered Charges for Atherosclerosis w/o MCCAVGcovCHARGE_MSDRG_303
14206308Average Covered Charges for Cardiac arrhythmia & conduction disorders w MCCAVGcovCHARGE_MSDRG_308
14207309Average Covered Charges for Cardiac arrhythmia & conduction disorders w CCAVGcovCHARGE_MSDRG_309
14208310Average Covered Charges for Cardiac arrhythmia & conduction disorders w/o CC/MCCAVGcovCHARGE_MSDRG_310
14209312Average Covered Charges for Syncope & collapseAVGcovCHARGE_MSDRG_312
14210313Average Covered Charges for DRG 313, n without complications or comorbidities (MS-DRG 313). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_313
14211314Average Covered Charges for Other circulatory system diagnoses w MCCAVGcovCHARGE_MSDRG_314
14212315Average Covered Charges for Other circulatory system diagnoses w CCAVGcovCHARGE_MSDRG_315
14213329Average Covered Charges for Major small & large bowel procedures w MCCAVGcovCHARGE_MSDRG_329
14214330Average Covered Charges for Major small & large bowel procedures w CCAVGcovCHARGE_MSDRG_330
14215372Average Covered Charges for Major gastrointestinal disorders & peritoneal infections w CCAVGcovCHARGE_MSDRG_372
14216377Average Covered Charges for G.I. hemorrhage w MCCAVGcovCHARGE_MSDRG_377
14217378Average Covered Charges for G.I. hemorrhage w CCAVGcovCHARGE_MSDRG_378
14218389Average Covered Charges for G.I. obstruction w CCAVGcovCHARGE_MSDRG_389
14219390Average Covered Charges for G.I. obstruction w/o CC/MCCAVGcovCHARGE_MSDRG_390
14220391Average Covered Charges for Esophagitis, gastroent & misc digest disorders w MCCAVGcovCHARGE_MSDRG_391
14221392Average Covered Charges for DRG 392, Disorders (MS-DRG 392). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_392
14222394Average Covered Charges for Other digestive system diagnoses w CCAVGcovCHARGE_MSDRG_394
14223418Average Covered Charges for Laparoscopic cholecystectomy w/o c.d.e. w CCAVGcovCHARGE_MSDRG_418
14224419Average Covered Charges for DRG 419, er Removal By Laparoscope without complications or comorbidities (MS-DRG 419). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_419
14225460Average Covered Charges for Spinal fusion except cervical w/o MCCAVGcovCHARGE_MSDRG_460
14226469Average Covered Charges for Major joint replacement or reattachment of lower extremity w MCCAVGcovCHARGE_MSDRG_469
14227470Average Covered Charges for DRG 470, nt Replacement (MS-DRG 470). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_470
14228473Average Covered Charges for Cervical spinal fusion w/o CC/MCCAVGcovCHARGE_MSDRG_473
14229480Average Covered Charges for Hip & femur procedures except major joint w MCCAVGcovCHARGE_MSDRG_480
14230481Average Covered Charges for Hip & femur procedures except major joint w CCAVGcovCHARGE_MSDRG_481
14231491Average Covered Charges for Back & neck proc exc spinal fusion w/o CC/MCCAVGcovCHARGE_MSDRG_491
14232552Average Covered Charges for Medical back problems w/o MCCAVGcovCHARGE_MSDRG_552
14233602Average Covered Charges for Cellulitis w MCCAVGcovCHARGE_MSDRG_602
14234603Average Covered Charges for DRG 603, s (MS-DRG 603). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_603
14235638Average Covered Charges for Diabetes w CCAVGcovCHARGE_MSDRG_638
14236640Average Covered Charges for Nutritional & misc metabolic disorders w MCCAVGcovCHARGE_MSDRG_640
14237641Average Covered Charges for DRG 641, Disorders (MS-DRG 641). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_641
14238682Average Covered Charges for Renal failure w MCCAVGcovCHARGE_MSDRG_682
14239683Average Covered Charges for Renal failure w CCAVGcovCHARGE_MSDRG_683
14240684Average Covered Charges for Renal failure w/o CC/MCCAVGcovCHARGE_MSDRG_684
14241689Average Covered Charges for Kidney & urinary tract infections w MCCAVGcovCHARGE_MSDRG_689
14242690Average Covered Charges for DRG 690, ract Infections (MS-DRG 690). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_690
14243698Average Covered Charges for Other kidney & urinary tract diagnoses w MCCAVGcovCHARGE_MSDRG_698
14244699Average Covered Charges for Other kidney & urinary tract diagnoses w CCAVGcovCHARGE_MSDRG_699
14245811Average Covered Charges for Red blood cell disorders w MCCAVGcovCHARGE_MSDRG_811
14246812Average Covered Charges for Red blood cell disorders w/o MCCAVGcovCHARGE_MSDRG_812
14247853Average Covered Charges for Infectious & parasitic diseases w O.R. procedure w MCCAVGcovCHARGE_MSDRG_853
14248870Average Covered Charges for Septicemia or severe sepsis w MV 96+ hoursAVGcovCHARGE_MSDRG_870
14249871Average Covered Charges for DRG 871, a with Multiple Complications (MS-DRG 871). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_871
14250872Average Covered Charges for Septicemia or severe sepsis w/o MV 96+ hours w/o MCCAVGcovCHARGE_MSDRG_872
14251885Average Covered Charges for DRG 885, (MS-DRG 885). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_885
14252897Average Covered Charges for DRG 897, rug Abuse (MS-DRG 897). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_897
14253917Average Covered Charges for Poisoning & toxic effects of drugs w MCCAVGcovCHARGE_MSDRG_917
14254918Average Covered Charges for Poisoning & toxic effects of drugs w/o MCCAVGcovCHARGE_MSDRG_918
14255948Average Covered Charges for Signs & symptoms w/o MCCAVGcovCHARGE_MSDRG_948
14256439Average Covered Charges for Disorders of pancreas except malignancy w CCAVGcovCHARGE_MSDRG_439
14257203Average Covered Charges for DRG 203, s and Asthma without complications or comorbidities (MS-DRG 203). Hospital list prices (more commonly referred to as gross charges) are standard prices established by hospitals each year for all services. All patients are charged the same list price for the same service before applying discounts. The median refers to the midpoint of all charges. Charges are for facility services and accommodation and may not include physician or surgeon fees.AVGcovCHARGE_MSDRG_203
14258379Average Covered Charges for G.I. hemorrhage w/o CC/MCCAVGcovCHARGE_MSDRG_379
14259563Average Covered Charges for Fx, sprn, strn & disl except femur, hip, pelvis & thigh w/o MCCAVGcovCHARGE_MSDRG_563
14260482Average Covered Charges for Hip & femur procedures except major joint w/o CC/MCCAVGcovCHARGE_MSDRG_482
14261536Average Covered Charges for Fractures of hip & pelvis w/o MCCAVGcovCHARGE_MSDRG_536
14262305Average Covered Charges for Hypertension w/o MCCAVGcovCHARGE_MSDRG_305
14263149Average Covered Charges for DysequilibriumAVGcovCHARGE_MSDRG_149