Price Transparencybeta Hospital negotiated rates

Hospital facility prices. What the hospital charges for the facility side of care — the surgeon’s and anesthesiologist’s fees are billed separately and are not included. How we scope prices →

Export CSV

EDWARD W SPARROW HOSPITAL

Lansing, MI · CCN 230230 · Rates published

You selected 508 (MS_DRG)

Major Shoulder Or Elbow Joint Procedures Without Cc/McC

This hospital’s price: $11,477 across 11 payers · range $6,686-$21,707

Source: https://www.sparrow.org/sites/default/files/2021-12/sparrow-specialty-hospital-machine-readable-file-2022_0.xlsx · observed 2026-07-31

This is the facility’s filed rate for this code. The comparison board’s estimate also adds the surgeon and anesthesia fees, so it is usually higher.

18,353 distinct procedures filed
37 distinct payers
349,039 rate rows
2026-10-12 last MRF observed

326,872 of 349,039 rate rows are consumer-grade (93.6%)

22,167 rows are marked excluded from the consumer medians — these stay visible in the raw drill-down with the same reason shown here, so nothing is silently hidden.

Excluded — reasonRows
exceeds 10× this hospital's gross charge — excluded from medians 11,563
percent-of-billed methodology on a DRG bundle — not comparable to case rates; shown as context only 7,865
no usable negotiated amount (only an out-of-band fallback) — excluded from medians 904
placeholder amount (≤ $0.02) — excluded from medians 867
below 25% of the Medicare reference for this DRG — likely a mislabeled per-diem; excluded from rankings 629
below 25% of the Medicare reference for this code — likely a mislabeled per-diem or placeholder; excluded from medians 195
percent-of-charges filed in the dollar field — excluded from medians 86
per-diem day rate — not a per-procedure price 34
exceeds 3× this hospital's gross charge for a DRG stay — excluded 24
↓ Download audit trail (JSON)
Source MRF file https://www.uofmhealthsparrow.org/sites/default/files/2026-03/um-health-sparrow-st-lawrence-machine-readable-file-03-31-2026.csv
Found on page https://www.uofmhealthsparrow.org/patient-resources/financial-resources/standard-charges
Discovered viaCMS hospital list
Last fetch not_modified · 2026-10-22
Content fingerprint 96d5d97949d3f60e… · 65,923,149 bytes · first seen 2026-05-09

Top 50 most expensive offerings

Outliers are flagged where this hospital's filed rate is ≥2× or ≤0.5× the national median for the same code.

Code Description Payers Min $ Max $ Avg median vs national
9116
OTHER
Antithrombin Iii (human) 500 Units IV Solr 14 $35.07 $1,632,000.00 $332,250.00 nat. median
$1
5884
APR_DRG
Neonate Birth Weight < 1500 Grams With Major Procedure,EXTREME 6 $216,681.61 $238,349.77 $216,681.61 nat. median
$247,815

0.9× median
1
MS_DRG
Heart Transplant Or Implant Of Heart Assist System With McC 25 $1,165.00 $525,013.46 $184,400.66 nat. median
$248,541

0.7× median
5914
APR_DRG
Neonate Birth Weight 500-749 Grams Without Major Procedure,EXTREME 6 $178,549.76 $196,404.74 $178,549.76 nat. median
$163,528

1.1× median
6094
APR_DRG
Neonate Birth Weight 1500-2499 Grams With Major Procedure,EXTREME 6 $167,525.14 $184,277.65 $167,525.14 nat. median
$165,000

1.0× median
5892
APR_DRG
Neonate Birth Weight < 500 Grams, Or Birth Weight 500-999 Grams And Gestational… 6 $140,958.10 $155,053.91 $140,958.10 nat. median
$89,331

1.6× median
3
MS_DRG
Ecmo Or Tracheostomy With Mv >96 Hours Or Principal Diagnosis Except Face, Mouth… 25 $29.25 $402,938.78 $139,664.39 nat. median
$190,359

0.7× median
5913
APR_DRG
Neonate Birth Weight 500-749 Grams Without Major Procedure,MAJOR 6 $139,483.49 $153,431.84 $139,483.49 nat. median
$101,865

1.4× median
5934
APR_DRG
Neonate Birth Weight 750-999 Grams Without Major Procedure,EXTREME 6 $127,146.98 $139,861.68 $127,146.98 nat. median
$151,838

0.8× median
94
APR_DRG
Extracorporeal Membrane Oxygenation (Ecmo),EXTREME 6 $116,893.49 $128,582.84 $116,893.49 nat. median
$163,718

0.7× median
33366
CPT
Hb Trcath Replace Aortic Valve 10 $62,167.07 $143,054.91 $104,906.93 nat. median
$6,020

outlier · 17.4×
231
MS_DRG
Coronary Bypass With Ptca With McC 22 $55,469.76 $221,144.30 $103,384.96 nat. median
$76,979

1.3× median
44
APR_DRG
Tracheostomy With Mv >96 Hours With Extensive Procedure,EXTREME 6 $100,464.19 $110,510.61 $100,464.19 nat. median
$122,016

0.8× median
33364
CPT
Hb Replace Aortic Vavle Open, Iliac 10 $58,211.30 $133,952.13 $98,231.56 nat. median
$6,279

outlier · 15.6×
33363
CPT
Hb Replace Aortic Valve Open Axillary Art 10 $54,704.67 $125,882.91 $92,314.13 nat. median
$6,985

outlier · 13.2×
4
MS_DRG
Tracheostomy With Mv >96 Hours Or Principal Diagnosis Except Face, Mouth And Nec… 25 $29.25 $284,259.20 $91,143.89 nat. median
$126,461

0.7× median
C9293
HCPCS
Glucarpidase 1000 Units IV Solr 12 $392.49 $152,755.65 $90,521.87 nat. median
$30,130

outlier · 3.0×
6024
APR_DRG
Neonate Birth Weight 1000-1249 Grams With Respiratory Distress Syndrome Or Other… 6 $89,918.80 $98,910.68 $89,918.80 nat. median
$118,883

0.8× median
928
MS_DRG
Full Thickness Burn With Skin Graft Or Inhalation Injury With Cc/McC 14 $1,165.00 $415,964.21 $89,165.83 nat. median
$61,263

1.5× median
33365
CPT
Hb Replace Aortic Valve Open 13 $890.34 $147,347.91 $87,317.28 nat. median
$5,843

outlier · 14.9×
5932
APR_DRG
Neonate Birth Weight 750-999 Grams Without Major Procedure,MODERATE 6 $85,322.74 $93,855.01 $85,322.74 nat. median
$86,187

1.0× median
6093
APR_DRG
Neonate Birth Weight 1500-2499 Grams With Major Procedure,MAJOR 6 $80,704.30 $88,774.73 $80,704.30 nat. median
$69,705

1.2× median
33361
CPT
Hb Replace Aortic Valve Perq 13 $756.36 $129,296.25 $76,620.00 nat. median
$9,542

outlier · 8.0×
232
MS_DRG
Coronary Bypass With Ptca Without McC 22 $39,892.64 $162,832.66 $76,124.27 nat. median
$57,798

1.3× median
426
MS_DRG
Multiple Level Combined Anterior And Posterior Spinal Fusion Except Cervical Wit… 13 $72,520.83 $123,979.19 $72,520.83 nat. median
$93,226

0.8× median
33362
CPT
Hb Replace Aortic Valve Open, Femoral 13 $825.38 $121,643.37 $72,084.96 nat. median
$7,871

outlier · 9.2×
212
MS_DRG
Concomitant Aortic And Mitral Valve Procedures 13 $71,552.90 $203,529.21 $71,552.90 nat. median
$97,137

0.7× median
43
APR_DRG
Tracheostomy With Mv >96 Hours With Extensive Procedure,MAJOR 6 $68,393.52 $75,232.87 $68,393.52 nat. median
$74,628

0.9× median
216
MS_DRG
Cardiac Valve And Other Major Cardiothoracic Procedures With Cardiac Catheteriza… 19 $64,372.01 $243,948.26 $67,590.61 nat. median
$90,512

0.7× median
SUP-N52138
CDM
Catheter Impella 5.5 10 $39,600.00 $91,125.00 $66,825.00 nat. median
$69,041

1.0× median
6023
APR_DRG
Neonate Birth Weight 1000-1249 Grams With Respiratory Distress Syndrome Or Other… 6 $66,488.32 $73,137.15 $66,488.32 nat. median
$88,855

0.7× median
6334
APR_DRG
Neonate Birth Weight > 2499 Grams With Major Anomaly,EXTREME 6 $66,254.58 $72,880.04 $66,254.58 nat. median
$59,122

1.1× median
6022
APR_DRG
Neonate Birth Weight 1000-1249 Grams With Respiratory Distress Syndrome Or Other… 6 $65,765.83 $72,342.41 $65,765.83 nat. median
$70,021

0.9× median
54
APR_DRG
Tracheostomy With Mv >96 Hours Without Extensive Procedure,EXTREME 6 $65,711.59 $72,282.75 $65,711.59 nat. median
$81,052

0.8× median
215
MS_DRG
Other Heart Assist System Implant 25 $6.50 $238,565.18 $65,518.27 nat. median
$93,787

0.7× median
PX-27800176
CDM
Hb Edwards Evoque Tricuspid Valve Replacement System (52 Mm Valve) 10 $38,748.16 $89,164.80 $65,387.52 nat. median
$65,388

1.0× median
PX-27800177
CDM
Hb Edwards Evoque Tricuspid Valve Replacement System (56 Mm Valve) 10 $38,748.16 $89,164.80 $65,387.52 nat. median
$65,388

1.0× median
PX-27800174
CDM
Hb Edwards Evoque Tricuspid Valve Replacement System (44 Mm Valve) 10 $38,748.16 $89,164.80 $65,387.52 nat. median
$65,388

1.0× median
PX-27800175
CDM
Hb Edwards Evoque Tricuspid Valve Replacement System (48 Mm Valve) 10 $38,748.16 $89,164.80 $65,387.52 nat. median
$65,388

1.0× median
224
MS_DRG
Cardiac Defibrillator Implant With Cardiac Catheterization Without Ami, Hf Or Sh… 14 $4.23 $315,057.62 $64,746.08 nat. median
$39,601

1.6× median
SUP-M78747
CDM
Valve Tricuspid Evoque 48mm 10 $37,840.00 $87,075.00 $63,855.00 nat. median
$63,855

1.0× median
SUP-M78746
CDM
Valve Tricuspid Evoque 44mm 10 $37,840.00 $87,075.00 $63,855.00 nat. median
$63,855

1.0× median
SUP-M78748
CDM
Valve Tricuspid Evoque 52mm 10 $37,840.00 $87,075.00 $63,855.00 nat. median
$63,855

1.0× median
6124
APR_DRG
Neonate Birth Weight 1500-1999 Grams With Respiratory Distress Syndrome Or Other… 6 $60,096.66 $66,106.33 $60,096.66 nat. median
$66,867

0.9× median
A9543
HCPCS
Hb Yttrium 90 Zevalin 29 $30,457.96 $160,433.46 $58,245.17 nat. median
$63,504

0.9× median
456
MS_DRG
Spinal Fusion Except Cervical With Spinal Curvature, Malignancy, Infection Or Ex… 22 $23,236.69 $163,358.68 $58,060.16 nat. median
$77,487

0.7× median
53
APR_DRG
Tracheostomy With Mv >96 Hours Without Extensive Procedure,MAJOR 6 $58,057.82 $63,863.60 $58,057.82 nat. median
$50,423

1.2× median
Q2043
HCPCS
Sipuleucel-t 50000000 Cells IV Susp 27 $29,625.97 $286,732.35 $58,035.94 nat. median
$65,720

0.9× median
457
MS_DRG
Spinal Fusion Except Cervical With Spinal Curvature, Malignancy, Infection Or Ex… 22 $39,237.92 $151,212.60 $57,752.73 nat. median
$55,110

1.0× median
850
MS_DRG
Acute Leukemia With Other Procedures 13 $56,980.56 $138,771.77 $56,980.56 nat. median
$78,164

0.7× median

Other procedures at this hospital

Browse this hospital's 18,353 published procedures. Use the slice to choose what to show, then sort or filter any column.

Sortable, filterable data table. Use the column headers to sort, the filter row to narrow results.
Code Type Description Rate rows Payers Gross Cash Min $ Max $ Avg median Last observed
             
See an error in this hospital's data? Submit a correction