Hospital · CCN 050516
Mercy San Juan Medical Center
6501 Coyle Ave, Carmichael, CA 95608 · Sacramento County
Part of CommonSpirit Health · 384 beds · 2
Metropolitan area core: primary flow within an urbanized area of 50,000 and greater
100 admission types 53 outpatient services price file: ok 1 Medicare-file findings
Billed per dollar paid, all admissions
6.53×
$417.3M billed against $63.9M paid across 3,432 Medicare discharges; the national figure is 5.03×.
—
of adults in Sacramento County have medical debt in collections — state bars medical debt from credit reports; the credit-bureau panel cannot see it
5.4%
uninsured in the county · state 7.5%
$90K
median household income
5.4×
billed ÷ paid, inpatient, summed over the county's hospitals in the Medicare file (9 in the inpatient or outpatient file)ⓘ
29.6%
obesity in the countyⓘ
11.2%
diagnosed diabetes (PLACES)
5.7%
coronary heart disease (PLACES)
—
median age · — below poverty (ACS)
01 · Admissions
What it billed Medicare, by admission type
Average charge submitted and average total payment per discharge, 2024. Rows under 11 discharges are suppressed by CMS. The last column is the hospital's ratio against its state's for the same admission.
DRG
Admission
Discharges
Charge
Paid
Billed ÷ paid
871
Septicemia or severe sepsis without mv >96 hours with mcc
400
$121,886
$20,997
5.8× st 6.2×
291
Heart failure and shock with mcc
242
$86,958
$13,990
6.2× st 6.5×
064
Intracranial hemorrhage or cerebral infarction with mcc
108
$161,122
$21,920
7.4× st 7.4×
193
Simple pneumonia and pleurisy with mcc
106
$102,850
$13,902
7.4× st 6.9×
065
Intracranial hemorrhage or cerebral infarction with cc or tpa in 24 hours
78
$110,788
$11,216
9.9× st 7.9×
177
Respiratory infections and inflammations with mcc
78
$107,052
$17,569
6.1× st 6.6×
872
Septicemia or severe sepsis without mv >96 hours without mcc
76
$72,153
$11,337
6.4× st 6.1×
690
Kidney and urinary tract infections without mcc
75
$58,198
$8,929
6.5× st 6.6×
190
Chronic obstructive pulmonary disease with mcc
73
$98,645
$12,191
8.1× st 7.1×
698
Other kidney and urinary tract diagnoses with mcc
70
$81,022
$17,161
4.7× st 6.2×
689
Kidney and urinary tract infections with mcc
68
$89,827
$13,214
6.8× st 6.3×
280
Acute myocardial infarction, discharged alive with mcc
62
$107,220
$16,431
6.5× st 6.6×
392
Esophagitis, gastroenteritis and miscellaneous digestive disorders without mcc
60
$62,155
$8,755
7.1× st 6.8×
682
Renal failure with mcc
60
$117,281
$16,711
7.0× st 6.1×
189
Pulmonary edema and respiratory failure
56
$74,309
$13,404
5.5× st 6.7×
640
Miscellaneous disorders of nutrition, metabolism, fluids and electrolytes with mcc
52
$111,658
$13,525
8.3× st 5.7×
853
Infectious and parasitic diseases with o.r. procedures with mcc
52
$358,218
$53,209
6.7× st 6.2×
603
Cellulitis without mcc
50
$52,022
$9,787
5.3× st 5.9×
378
Gastrointestinal hemorrhage with cc
48
$75,007
$10,821
6.9× st 6.8×
377
Gastrointestinal hemorrhage with mcc
47
$137,515
$21,013
6.5× st 6.4×
683
Renal failure with cc
47
$68,765
$9,879
7.0× st 6.7×
208
Respiratory system diagnosis with ventilator support <=96 hours
38
$229,817
$28,896
8.0× st 7.4×
312
Syncope and collapse
37
$73,726
$9,580
7.7× st 7.2×
308
Cardiac arrhythmia and conduction disorders with mcc
37
$103,180
$12,872
8.0× st 6.9×
309
Cardiac arrhythmia and conduction disorders with cc
36
$57,347
$8,650
6.6× st 7.2×
481
Hip and femur procedures except major joint with cc
35
$153,815
$21,877
7.0× st 6.7×
641
Miscellaneous disorders of nutrition, metabolism, fluids and electrolytes without mcc
35
$60,771
$8,688
7.0× st 6.3×
637
Diabetes with mcc
33
$95,745
$18,835
5.1× st 6.3×
100
Seizures with mcc
31
$202,906
$21,953
9.2× st 6.2×
699
Other kidney and urinary tract diagnoses with cc
30
$71,915
$10,932
6.6× st 6.1×
552
Medical back problems without mcc
30
$84,163
$10,333
8.1× st 7.5×
025
Craniotomy and endovascular intracranial procedures with mcc
30
$248,007
$45,082
5.5× st 6.5×
389
Gastrointestinal obstruction with cc
27
$61,534
$8,795
7.0× st 6.9×
321
Percutaneous cardiovascular procedures with intraluminal device with mcc or 4+ arteries/
26
$238,973
$42,894
5.6× st 7.4×
445
Disorders of the biliary tract with cc
26
$86,902
$11,854
7.3× st 7.0×
391
Esophagitis, gastroenteritis and miscellaneous digestive disorders with mcc
26
$91,265
$13,864
6.6× st 6.5×
286
Circulatory disorders except ami, with cardiac catheterization with mcc
25
$139,276
$22,975
6.1× st 6.6×
522
Hip replacement with principal diagnosis of hip fracture without mcc
24
$149,884
$22,896
6.5× st 6.9×
897
Alcohol, drug abuse or dependence without rehabilitation therapy without mcc
23
$72,331
$9,480
7.6× st 5.7×
638
Diabetes with cc
23
$62,408
$9,999
6.2× st 6.3×
470
Major hip and knee joint replacement or reattachment of lower extremity without mcc
23
$147,072
$20,087
7.3× st 6.4×
322
Percutaneous cardiovascular procedures with intraluminal device without mcc
22
$159,511
$27,579
5.8× st 7.8×
101
Seizures without mcc
22
$81,125
$10,095
8.0× st 6.8×
066
Intracranial hemorrhage or cerebral infarction without cc/mcc
22
$66,331
$7,785
8.5× st 8.8×
811
Red blood cell disorders with mcc
22
$89,657
$15,151
5.9× st 6.4×
194
Simple pneumonia and pleurisy with cc
22
$65,533
$10,882
6.0× st 7.5×
023
Craniotomy with major device implant or acute complex cns principal diagnosis with mcc o
21
$283,361
$53,616
5.3× st 6.2×
305
Hypertension without mcc
21
$62,821
$8,421
7.5× st 7.3×
394
Other digestive system diagnoses with cc
21
$92,081
$13,609
6.8× st 6.9×
617
Amputation of lower limb for endocrine, nutritional and metabolic disorders with cc
21
$112,441
$20,671
5.4× st 5.6×
184
Major chest trauma with cc
21
$137,252
$11,557
11.9× st 8.8×
069
Transient ischemia without thrombolytic
20
$70,149
$8,925
7.9× st 9.5×
472
Cervical spinal fusion with cc
20
$158,305
$36,813
4.3× st 6.1×
314
Other circulatory system diagnoses with mcc
20
$137,403
$20,004
6.9× st 6.1×
252
Other vascular procedures with mcc
19
$170,865
$34,265
5.0× st 5.7×
287
Circulatory disorders except ami, with cardiac catheterization without mcc
19
$97,346
$11,861
8.2× st 7.7×
480
Hip and femur procedures except major joint with mcc
18
$218,985
$31,021
7.1× st 6.8×
444
Disorders of the biliary tract with mcc
18
$92,370
$17,240
5.4× st 7.0×
070
Other cerebrovascular disorders with mcc
18
$127,823
$18,943
6.7× st 5.4×
482
Hip and femur procedures except major joint without cc/mcc
17
$130,792
$17,708
7.4× st 6.7×
917
Poisoning and toxic effects of drugs with mcc
17
$109,134
$16,783
6.5× st 6.2×
175
Pulmonary embolism with mcc or acute cor pulmonale
17
$95,157
$14,311
6.6× st 7.2×
086
Traumatic stupor and coma <1 hour with cc
17
$75,671
$17,209
4.4× st 7.9×
602
Cellulitis with mcc
17
$129,108
$19,701
6.6× st 5.7×
310
Cardiac arrhythmia and conduction disorders without cc/mcc
17
$48,882
$6,404
7.6× st 7.6×
460
Spinal fusion except cervical without mcc
16
$219,901
$37,873
5.8× st 5.6×
233
Coronary bypass with cardiac catheterization or open ablation with mcc
16
$879,304
$108,387
8.1× st 7.0×
207
Respiratory system diagnosis with ventilator support >96 hours
16
$420,867
$70,554
6.0× st 5.7×
563
Fracture, sprain, strain and dislocation except femur, hip, pelvis and thigh without mcc
16
$67,565
$10,481
6.4× st 6.9×
516
Other musculoskeletal system and connective tissue o.r. procedures with cc
16
$172,396
$21,736
7.9× st 6.7×
870
Septicemia or severe sepsis with mv >96 hours
16
$425,008
$74,468
5.7× st 6.2×
313
Chest pain
15
$68,130
$8,137
8.4× st 7.7×
253
Other vascular procedures with cc
15
$207,960
$27,162
7.7× st 6.7×
884
Organic disturbances and intellectual disability
14
$127,311
$18,897
6.7× st 5.3×
264
Other circulatory system o.r. procedures
14
$112,235
$32,086
3.5× st 6.9×
271
Other major cardiovascular procedures with cc
14
$207,231
$36,348
5.7× st 5.8×
281
Acute myocardial infarction, discharged alive with cc
14
$79,226
$10,093
7.9× st 7.8×
493
Lower extremity and humerus procedures except hip, foot and femur with cc
14
$157,377
$24,828
6.3× st 6.5×
854
Infectious and parasitic diseases with o.r. procedures with cc
14
$131,265
$20,520
6.4× st 6.7×
057
Degenerative nervous system disorders without mcc
14
$105,665
$12,669
8.3× st 5.7×
163
Major chest procedures with mcc
13
$262,747
$48,915
5.4× st 6.4×
038
Extracranial procedures with cc
13
$158,885
$17,239
9.2× st 7.3×
054
Nervous system neoplasms with mcc
13
$97,226
$13,842
7.0× st 7.6×
180
Respiratory neoplasms with mcc
13
$121,855
$18,602
6.6× st 6.9×
981
Extensive o.r. procedures unrelated to principal diagnosis with mcc
13
$343,143
$46,420
7.4× st 6.3×
812
Red blood cell disorders without mcc
12
$63,880
$10,024
6.4× st 6.4×
315
Other circulatory system diagnoses with cc
12
$67,689
$10,221
6.6× st 6.7×
390
Gastrointestinal obstruction without cc/mcc
12
$57,590
$6,442
8.9× st 7.0×
454
Combined anterior and posterior spinal fusion with cc
12
$218,517
$63,952
3.4× st 5.5×
164
Major chest procedures with cc
12
$156,604
$29,097
5.4× st 6.3×
092
Other disorders of nervous system with cc
12
$67,199
$11,322
5.9× st 6.8×
082
Traumatic stupor and coma >1 hour with mcc
11
$309,809
$35,560
8.7× st 7.7×
948
Signs and symptoms without mcc
11
$79,514
$8,965
8.9× st 7.3×
551
Medical back problems with mcc
11
$132,284
$17,627
7.5× st 7.0×
191
Chronic obstructive pulmonary disease with cc
11
$81,982
$9,475
8.7× st 7.3×
087
Traumatic stupor and coma <1 hour without cc/mcc
11
$81,099
$9,795
8.3× st 8.5×
432
Cirrhosis and alcoholic hepatitis with mcc
11
$153,525
$20,558
7.5× st 5.6×
684
Renal failure without cc/mcc
11
$41,935
$6,937
6.0× st 8.1×
536
Fractures of hip and pelvis without mcc
11
$66,639
$8,659
7.7× st 7.0×
741
Uterine and adnexa procedures for non-ovarian and non-adnexal malignancy without cc/mcc
11
$114,908
$14,179
8.1× st 11.0×
02 · Outpatient
Outpatient services
Comprehensive APCs, Medicare's outpatient payment groups: submitted charge against what Medicare allowed, per service.
APC
Service
Services
Charge
Allowed
Billed ÷ allowed
8011
Comprehensive Observation Services
568
$36,639
$3,477
10.5×
5183
Level 3 Vascular Procedures
130
$25,802
$4,071
6.3×
5191
Level 1 Endovascular Procedures
121
$53,700
$4,168
12.9×
5115
Level 5 Musculoskeletal Procedures
116
$119,777
$16,773
7.1×
5193
Level 3 Endovascular Procedures
71
$91,290
$14,026
6.5×
5375
Level 5 Urology and Related Services
65
$57,644
$6,608
8.7×
5302
Level 2 Upper GI Procedures
57
$17,240
$2,430
7.1×
5072
Level 2 Excision/ Biopsy/ Incision and Drainage
52
$17,670
$2,071
8.5×
5373
Level 3 Urology and Related Services
47
$17,935
$2,601
6.9×
5192
Level 2 Endovascular Procedures
46
$57,368
$7,300
7.9×
5114
Level 4 Musculoskeletal Procedures
46
$78,480
$8,812
8.9×
5184
Level 4 Vascular Procedures
38
$50,615
$6,649
7.6×
5374
Level 4 Urology and Related Services
38
$37,676
$4,362
8.6×
5341
Level 1 Abdominal/Peritoneal/Biliary and Related Procedures
37
$39,341
$4,325
9.1×
5182
Level 2 Vascular Procedures
35
$17,693
$2,045
8.7×
5154
Level 4 Airway Endoscopy
33
$58,658
$4,783
12.3×
5073
Level 3 Excision/ Biopsy/ Incision and Drainage
31
$24,810
$3,629
6.8×
5194
Level 4 Endovascular Procedures
30
$118,759
$22,336
5.3×
5361
Level 1 Laparoscopy and Related Services
29
$60,138
$7,369
8.2×
5362
Level 2 Laparoscopy and Related Services
28
$85,945
$12,715
6.8×
5092
Level 2 Breast/Lymphatic Surgery and Related Procedures
25
$90,898
$8,327
10.9×
5091
Level 1 Breast/Lymphatic Surgery and Related Procedures
22
$39,862
$4,692
8.5×
5223
Level 3 Pacemaker and Similar Procedures
20
$35,889
$13,615
2.6×
5112
Level 2 Musculoskeletal Procedures
19
$16,016
$1,973
8.1×
5116
Level 6 Musculoskeletal Procedures
18
$131,913
$23,737
5.6×
5222
Level 2 Pacemaker and Similar Procedures
15
$39,114
$10,839
3.6×
5113
Level 3 Musculoskeletal Procedures
12
$44,208
$4,134
10.7×
5153
Level 3 Airway Endoscopy
11
$30,560
$2,168
14.1×
5414
Level 4 Gynecologic Procedures
11
$33,121
$3,993
8.3×
5471
Implantation of Drug Infusion Device
—
—
—
—
5465
Level 5 Neurostimulator and Related Procedures
—
—
—
—
5378
Level 8 Urology and Related Services
—
—
—
—
5415
Level 5 Gynecologic Procedures
—
—
—
—
5416
Level 6 Gynecologic Procedures
—
—
—
—
5431
Level 1 Nerve Procedures
—
—
—
—
5432
Level 2 Nerve Procedures
—
—
—
—
5461
Level 1 Neurostimulator and Related Procedures
—
—
—
—
5464
Level 4 Neurostimulator and Related Procedures
—
—
—
—
5462
Level 2 Neurostimulator and Related Procedures
—
—
—
—
5093
Level 3 Breast/Lymphatic Surgery and Related Procedures
—
—
—
—
5164
Level 4 ENT Procedures
—
—
—
—
5155
Level 5 Airway Endoscopy
—
—
—
—
5224
Level 4 Pacemaker and Similar Procedures
—
—
—
—
5232
Level 2 ICD and Similar Procedures
—
—
—
—
5094
Level 4 Breast/Lymphatic Surgery and Related Procedures
—
—
—
—
5303
Level 3 Upper GI Procedures
—
—
—
—
5313
Level 3 Lower GI Procedures
—
—
—
—
5331
Complex GI Procedures
—
—
—
—
5231
Level 1 ICD and Similar Procedures
—
—
—
—
5342
Level 2 Abdominal/Peritoneal/Biliary and Related Procedures
—
—
—
—
5165
Level 5 ENT Procedures
—
—
—
—
5372
Level 2 Urology and Related Services
—
—
—
—
5376
Level 6 Urology and Related Services
—
—
—
—
03 · Its own price file
What the hospital's price-transparency file says
Found via /cms-hpt.txt, the file itself ↗ read as json, last updated 2026-02-28, template 3.0.0, 30,763 rows scanned, 9,014 distinct code–setting items kept. 2,525 findings against it.
Service
Code
Listed
Cash
Negotiated
Rates
Checks
Showing the first 200 of 9,014 code–setting items in the file, verified codes first — every row as JSON →
Findings
Service
Severity
Rule
Detail
MS-DRG 244/i
error
mrf_negotiated_above_max
a negotiated rate of $31,034 is above the file's own maximum $28,367
MS-DRG 251/i
error
mrf_negotiated_above_max
a negotiated rate of $31,034 is above the file's own maximum $24,696
MS-DRG 259/i
error
mrf_negotiated_above_max
a negotiated rate of $31,034 is above the file's own maximum $27,655
MS-DRG 806/i
error
mrf_negotiated_above_max
a negotiated rate of $14,367 is above the file's own maximum $13,918
MS-DRG 807/i
error
mrf_negotiated_above_max
a negotiated rate of $14,367 is above the file's own maximum $13,918
MS-DRG 261/i
error
mrf_negotiated_above_max
a negotiated rate of $31,034 is above the file's own maximum $29,776
MS-DRG 262/i
error
mrf_negotiated_above_max
a negotiated rate of $31,034 is above the file's own maximum $24,017
MS-DRG 287/i
error
mrf_negotiated_above_max
a negotiated rate of $31,034 is above the file's own maximum $17,525
MS-DRG 322/i
error
mrf_negotiated_above_max
a negotiated rate of $31,034 is above the file's own maximum $28,436
MS-DRG 341/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 955/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 342/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 956/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 343/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 957/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 344/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $17,083
MS-DRG 958/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 345/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,438
MS-DRG 959/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,762
MS-DRG 346/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $7,895
MS-DRG 969/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 347/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $15,006
MS-DRG 970/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,822
MS-DRG 348/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $7,981
MS-DRG 981/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 350/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $15,335
MS-DRG 982/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $15,522
MS-DRG 351/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,539
MS-DRG 983/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,576
MS-DRG 352/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $6,990
MS-DRG 987/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 353/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,595
MS-DRG 988/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,879
MS-DRG 354/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,785
MS-DRG 989/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $7,326
MS-DRG 355/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $8,452
MS-DRG 356/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 357/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $14,278
MS-DRG 358/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $8,591
MS-DRG 405/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 406/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $17,805
MS-DRG 407/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $13,541
MS-DRG 408/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 409/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $13,292
MS-DRG 410/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,834
MS-DRG 411/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $17,349
MS-DRG 412/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $13,514
MS-DRG 413/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,540
MS-DRG 414/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 415/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,541
MS-DRG 416/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $8,687
MS-DRG 417/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $15,067
MS-DRG 418/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,514
MS-DRG 419/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $8,354
MS-DRG 420/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 421/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,382
MS-DRG 422/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,316
MS-DRG 423/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 424/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $14,476
MS-DRG 425/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,800
MS-DRG 453/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 454/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 455/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 456/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 457/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 458/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 459/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 460/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 461/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 462/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,156
MS-DRG 463/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 464/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,694
MS-DRG 465/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,007
MS-DRG 466/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 467/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $21,716
MS-DRG 468/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,632
MS-DRG 469/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $20,724
MS-DRG 470/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,954
MS-DRG 471/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 472/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,368
MS-DRG 473/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $15,009
MS-DRG 474/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 475/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $13,677
MS-DRG 476/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $7,374
MS-DRG 477/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 478/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $14,827
MS-DRG 479/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,259
MS-DRG 480/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,646
MS-DRG 481/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $13,155
MS-DRG 482/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,058
MS-DRG 483/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,156
MS-DRG 485/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 486/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $13,447
MS-DRG 487/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,018
MS-DRG 488/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,461
MS-DRG 489/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $7,851
MS-DRG 492/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,515
MS-DRG 493/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $15,222
MS-DRG 494/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,953
MS-DRG 495/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 496/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,509
MS-DRG 497/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $8,512
MS-DRG 498/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,008
MS-DRG 499/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $7,359
MS-DRG 500/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 501/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,315
MS-DRG 502/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $8,858
MS-DRG 503/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,779
MS-DRG 504/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,127
MS-DRG 505/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,127
MS-DRG 506/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,504
MS-DRG 507/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,288
MS-DRG 508/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $8,182
MS-DRG 509/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,137
MS-DRG 510/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,120
MS-DRG 511/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,434
MS-DRG 512/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,193
MS-DRG 513/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,546
MS-DRG 514/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $6,464
MS-DRG 515/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 516/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,754
MS-DRG 517/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,464
MS-DRG 518/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $22,687
MS-DRG 519/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,502
MS-DRG 520/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,086
MS-DRG 521/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,479
MS-DRG 522/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $13,365
MS-DRG 570/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 571/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,615
MS-DRG 572/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $7,243
MS-DRG 573/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 574/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 575/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,659
MS-DRG 576/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 577/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,882
MS-DRG 001/i
error
mrf_negotiated_below_min
a negotiated rate of $9,580 is below the file's own minimum $22,030
MS-DRG 578/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,717
MS-DRG 002/i
error
mrf_negotiated_below_min
a negotiated rate of $9,580 is below the file's own minimum $22,030
MS-DRG 579/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 003/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 580/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,241
MS-DRG 004/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 581/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,125
MS-DRG 005/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 582/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,103
MS-DRG 006/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 583/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,415
MS-DRG 007/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 584/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,981
MS-DRG 008/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 585/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,586
MS-DRG 010/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 614/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $14,449
MS-DRG 011/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 615/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,085
MS-DRG 012/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 616/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 013/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,801
MS-DRG 617/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,246
MS-DRG 019/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 618/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $7,894
MS-DRG 020/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 619/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $17,286
MS-DRG 021/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 620/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,125
MS-DRG 022/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 621/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,268
MS-DRG 023/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 622/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 024/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 623/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $12,127
MS-DRG 025/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 624/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $6,360
MS-DRG 026/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 625/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,177
MS-DRG 027/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $15,646
MS-DRG 626/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $9,569
MS-DRG 028/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 627/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $8,032
MS-DRG 029/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 628/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 030/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $14,109
MS-DRG 629/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $14,259
MS-DRG 031/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 630/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $8,884
MS-DRG 032/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $13,540
MS-DRG 650/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 033/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,115
MS-DRG 651/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 034/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 652/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 035/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $14,422
MS-DRG 653/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $18,973
MS-DRG 036/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $11,622
MS-DRG 654/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $17,892
MS-DRG 037/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $16,599
MS-DRG 655/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $13,170
MS-DRG 038/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $10,216
MS-DRG 656/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $20,656
MS-DRG 039/i
error
mrf_negotiated_below_min
a negotiated rate of $5,602 is below the file's own minimum $7,216
Showing the first 200 of 2,525 findings, errors first — every finding as JSON →
04 · Checks
Where the Medicare rows do not agree with themselves
Service
Severity
Rule
Detail
MS-DRG 184
info
inp_charge_10x_payment
average charge $137,252 is 11.9× the total payment
Sources for this hospital
the files read, as fetched — not our copy of them- MUP_INP_RY26_P03_V10_DY24_PrvSvc.CSV · 38.0M bytes · fetched 2026-08-21 · sha256 2ab6da15be4c… · publisher's page · public domain (US federal)
- MUP_OUT_RY26_P04_V10_DY24_Prov_Svc.csv · 28.1M bytes · fetched 2026-08-21 · sha256 f293918edbf6… · publisher's page · public domain (US federal)
- chsp-hospital-linkage-2023.csv · 1.5M bytes · fetched 2026-08-21 · sha256 a86146f10c8d… · publisher's page · public; cite AHRQ Compendium of U.S. Health Systems
- 2020 ZCTA to County relationship file · US Census Bureau · 2020tab20_zcta520_county20_natl.txt · 6.8M bytes · fetched 2026-08-21 · sha256 3ed41278d637… · publisher's page · public domain (US federal)
- Mercy San Juan Medical Center — standard charges file · CA · updated 2026-02-28· json · 136.5M bytes · fetched 2026-08-23 · sha256 5d4b66dc5dd8…
Every figure on this page is computed from these files by pipeline/prices/; the same rows are in the API.
Source rows for this hospital as JSON: inpatient · outpatient · price file. CMS, Medicare Inpatient and Outpatient Hospitals by Provider and Service, 2024.