Hospital · CCN 240115

Mercy Hospital

4050 Coon Rapids Blvd, Coon Rapids, MN 55433 · Anoka County
Part of Allina Health · 464 beds · 1
Metropolitan area core: primary flow within an urbanized area of 50,000 and greater

125 admission types 58 outpatient services
Billed per dollar paid, all admissions
4.38×
$262.9M billed against $60.0M paid across 4,609 Medicare discharges; the national figure is 5.03×.
0.2%
of adults in Anoka County have medical debt in collections
5.2%
uninsured in the county · state 5.4%
$97K
median household income
4.4×
billed ÷ paid, inpatient, summed over the county's hospitals in the Medicare file (2 in the inpatient or outpatient file)ⓘ
36.2%
obesity in the countyⓘ
10.6%
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
559
$61,917
$15,080
4.1× st 3.3×
291
Heart failure and shock with mcc
302
$44,773
$10,014
4.5× st 3.4×
872
Septicemia or severe sepsis without mv >96 hours without mcc
136
$33,717
$8,144
4.1× st 3.4×
885
Psychoses
127
$92,925
$15,040
6.2× st 4.3×
193
Simple pneumonia and pleurisy with mcc
100
$42,399
$10,899
3.9× st 3.2×
552
Medical back problems without mcc
94
$33,847
$7,620
4.4× st 3.5×
177
Respiratory infections and inflammations with mcc
91
$45,945
$12,327
3.7× st 3.1×
698
Other kidney and urinary tract diagnoses with mcc
86
$45,146
$12,234
3.7× st 3.1×
853
Infectious and parasitic diseases with o.r. procedures with mcc
85
$135,719
$37,295
3.6× st 3.3×
392
Esophagitis, gastroenteritis and miscellaneous digestive disorders without mcc
75
$26,303
$6,376
4.1× st 3.5×
378
Gastrointestinal hemorrhage with cc
75
$35,650
$7,865
4.5× st 3.5×
065
Intracranial hemorrhage or cerebral infarction with cc or tpa in 24 hours
72
$35,468
$7,802
4.5× st 3.7×
322
Percutaneous cardiovascular procedures with intraluminal device without mcc
69
$111,090
$15,533
7.2× st 5.1×
280
Acute myocardial infarction, discharged alive with mcc
67
$54,250
$13,519
4.0× st 3.7×
481
Hip and femur procedures except major joint with cc
65
$77,231
$16,189
4.8× st 3.5×
640
Miscellaneous disorders of nutrition, metabolism, fluids and electrolytes with mcc
65
$38,022
$10,298
3.7× st 3.4×
683
Renal failure with cc
60
$31,439
$6,991
4.5× st 3.4×
312
Syncope and collapse
59
$29,426
$6,843
4.3× st 3.4×
189
Pulmonary edema and respiratory failure
56
$40,171
$9,780
4.1× st 3.6×
522
Hip replacement with principal diagnosis of hip fracture without mcc
50
$69,418
$16,610
4.2× st 3.5×
389
Gastrointestinal obstruction with cc
49
$27,739
$6,678
4.2× st 3.2×
682
Renal failure with mcc
49
$47,100
$11,101
4.2× st 3.5×
470
Major hip and knee joint replacement or reattachment of lower extremity without mcc
48
$53,703
$14,745
3.6× st 3.3×
690
Kidney and urinary tract infections without mcc
46
$27,092
$6,129
4.4× st 3.3×
603
Cellulitis without mcc
45
$24,758
$7,206
3.4× st 3.3×
308
Cardiac arrhythmia and conduction disorders with mcc
45
$50,645
$9,848
5.1× st 3.6×
897
Alcohol, drug abuse or dependence without rehabilitation therapy without mcc
43
$34,459
$7,022
4.9× st 3.4×
194
Simple pneumonia and pleurisy with cc
43
$24,400
$6,282
3.9× st 3.0×
377
Gastrointestinal hemorrhage with mcc
42
$52,674
$13,576
3.9× st 3.5×
641
Miscellaneous disorders of nutrition, metabolism, fluids and electrolytes without mcc
40
$28,239
$6,303
4.5× st 3.7×
699
Other kidney and urinary tract diagnoses with cc
40
$34,253
$7,723
4.4× st 3.4×
267
Endovascular cardiac valve replacement and supplement procedures without mcc
39
$166,693
$35,800
4.7× st 3.5×
064
Intracranial hemorrhage or cerebral infarction with mcc
37
$70,570
$14,783
4.8× st 3.3×
309
Cardiac arrhythmia and conduction disorders with cc
37
$26,929
$5,935
4.5× st 3.3×
321
Percutaneous cardiovascular procedures with intraluminal device with mcc or 4+ arteries/
37
$157,151
$28,623
5.5× st 4.4×
812
Red blood cell disorders without mcc
37
$30,861
$7,392
4.2× st 3.9×
274
Percutaneous and other intracardiac procedures without mcc
36
$112,590
$23,978
4.7× st 3.2×
689
Kidney and urinary tract infections with mcc
34
$33,768
$8,519
4.0× st 3.3×
854
Infectious and parasitic diseases with o.r. procedures with cc
33
$59,223
$15,659
3.8× st 3.5×
314
Other circulatory system diagnoses with mcc
32
$68,039
$17,537
3.9× st 3.3×
391
Esophagitis, gastroenteritis and miscellaneous digestive disorders with mcc
32
$36,632
$9,812
3.7× st 3.4×
057
Degenerative nervous system disorders without mcc
31
$68,273
$12,662
5.4× st 3.3×
563
Fracture, sprain, strain and dislocation except femur, hip, pelvis and thigh without mcc
31
$25,820
$6,867
3.8× st 3.3×
811
Red blood cell disorders with mcc
30
$41,877
$11,118
3.8× st 3.6×
243
Permanent cardiac pacemaker implant with cc
29
$112,766
$20,075
5.6× st 4.1×
286
Circulatory disorders except ami, with cardiac catheterization with mcc
28
$86,644
$17,168
5.0× st 3.8×
493
Lower extremity and humerus procedures except hip, foot and femur with cc
27
$74,622
$18,193
4.1× st 3.2×
948
Signs and symptoms without mcc
26
$33,875
$6,189
5.5× st 3.9×
281
Acute myocardial infarction, discharged alive with cc
25
$32,252
$7,371
4.4× st 4.0×
178
Respiratory infections and inflammations with cc
25
$32,835
$7,848
4.2× st 3.3×
190
Chronic obstructive pulmonary disease with mcc
25
$29,452
$8,483
3.5× st 3.5×
543
Pathological fractures and musculoskeletal and connective tissue malignancy with cc
25
$29,949
$8,002
3.7× st 3.0×
660
Kidney and ureter procedures for non-neoplasm with cc
24
$39,891
$10,822
3.7× st 3.3×
638
Diabetes with cc
24
$27,982
$7,475
3.7× st 3.5×
981
Extensive o.r. procedures unrelated to principal diagnosis with mcc
24
$183,075
$38,991
4.7× st 3.3×
644
Endocrine disorders with cc
23
$35,182
$8,435
4.2× st 3.3×
253
Other vascular procedures with cc
23
$95,512
$19,159
5.0× st 3.8×
070
Other cerebrovascular disorders with mcc
22
$60,622
$12,921
4.7× st 4.2×
884
Organic disturbances and intellectual disability
22
$57,184
$13,026
4.4× st 3.5×
287
Circulatory disorders except ami, with cardiac catheterization without mcc
22
$45,104
$8,431
5.4× st 4.1×
394
Other digestive system diagnoses with cc
22
$25,666
$7,774
3.3× st 3.1×
602
Cellulitis with mcc
22
$49,347
$10,693
4.6× st 3.5×
305
Hypertension without mcc
22
$30,095
$6,017
5.0× st 4.0×
551
Medical back problems with mcc
22
$59,491
$11,978
5.0× st 3.4×
208
Respiratory system diagnosis with ventilator support <=96 hours
22
$105,370
$20,488
5.1× st 3.5×
637
Diabetes with mcc
22
$60,497
$11,569
5.2× st 3.6×
242
Permanent cardiac pacemaker implant with mcc
21
$127,503
$24,549
5.2× st 4.0×
191
Chronic obstructive pulmonary disease with cc
20
$27,458
$6,708
4.1× st 3.3×
092
Other disorders of nervous system with cc
20
$34,817
$8,433
4.1× st 3.5×
184
Major chest trauma with cc
20
$31,105
$8,229
3.8× st 2.7×
330
Major small and large bowel procedures with cc
20
$73,119
$17,771
4.1× st 3.2×
101
Seizures without mcc
19
$24,331
$7,849
3.1× st 3.6×
554
Bone diseases and arthropathies without mcc
18
$30,411
$6,544
4.6× st 3.5×
418
Laparoscopic cholecystectomy without c.d.e. with cc
18
$53,867
$12,501
4.3× st 3.6×
252
Other vascular procedures with mcc
18
$100,862
$25,209
4.0× st 3.4×
100
Seizures with mcc
18
$61,117
$13,185
4.6× st 3.9×
441
Disorders of liver except malignancy, cirrhosis or alcoholic hepatitis with mcc
18
$42,506
$13,737
3.1× st 3.6×
480
Hip and femur procedures except major joint with mcc
17
$97,867
$22,130
4.4× st 3.9×
205
Other respiratory system diagnoses with mcc
17
$62,334
$14,701
4.2× st 3.3×
270
Other major cardiovascular procedures with mcc
17
$249,606
$51,019
4.9× st 3.5×
175
Pulmonary embolism with mcc or acute cor pulmonale
17
$50,337
$11,499
4.4× st 3.4×
071
Other cerebrovascular disorders with cc
17
$41,160
$8,867
4.6× st 4.1×
432
Cirrhosis and alcoholic hepatitis with mcc
17
$52,047
$14,582
3.6× st 3.2×
896
Alcohol, drug abuse or dependence without rehabilitation therapy with mcc
17
$78,000
$15,029
5.2× st 3.5×
386
Inflammatory bowel disease with cc
17
$33,515
$8,000
4.2× st 4.2×
329
Major small and large bowel procedures with mcc
16
$153,095
$37,167
4.1× st 3.0×
374
Digestive malignancy with mcc
15
$67,885
$15,545
4.4× st 3.2×
895
Alcohol, drug abuse or dependence with rehabilitation therapy
15
$58,831
$12,143
4.8× st 4.8×
164
Major chest procedures with cc
15
$88,992
$19,075
4.7× st 3.1×
809
Major hematological and immunological diagnoses except sickle cell crisis and coagulatio
15
$43,480
$9,332
4.7× st 3.4×
536
Fractures of hip and pelvis without mcc
15
$31,248
$6,191
5.0× st 4.4×
066
Intracranial hemorrhage or cerebral infarction without cc/mcc
15
$23,148
$5,534
4.2× st 4.2×
617
Amputation of lower limb for endocrine, nutritional and metabolic disorders with cc
14
$46,530
$16,096
2.9× st 2.9×
661
Kidney and ureter procedures for non-neoplasm without cc/mcc
14
$30,505
$8,119
3.8× st 3.4×
202
Bronchitis and asthma with cc/mcc
14
$32,794
$7,507
4.4× st 3.7×
813
Coagulation disorders
14
$56,510
$11,875
4.8× st 3.1×
393
Other digestive system diagnoses with mcc
14
$50,523
$12,825
3.9× st 3.1×
313
Chest pain
14
$32,128
$5,773
5.6× st 3.4×
467
Revision of hip or knee replacement with cc
14
$97,132
$28,504
3.4× st 2.8×
180
Respiratory neoplasms with mcc
13
$58,405
$12,655
4.6× st 3.1×
673
Other kidney and urinary tract procedures with mcc
13
$116,349
$28,435
4.1× st 3.1×
299
Peripheral vascular disorders with mcc
13
$84,495
$15,328
5.5× st 4.4×
069
Transient ischemia without thrombolytic
12
$27,784
$6,341
4.4× st 3.9×
388
Gastrointestinal obstruction with mcc
12
$52,738
$11,042
4.8× st 3.4×
091
Other disorders of nervous system with mcc
12
$45,963
$13,212
3.5× st 3.1×
417
Laparoscopic cholecystectomy without c.d.e. with mcc
12
$61,686
$17,813
3.5× st 3.5×
324
Coronary intravascular lithotripsy with intraluminal device without mcc
12
$158,599
$22,994
6.9× st 6.1×
372
Major gastrointestinal disorders and peritoneal infections with cc
12
$37,168
$7,652
4.9× st 3.4×
149
Dysequilibrium
12
$29,490
$5,929
5.0× st 3.9×
562
Fracture, sprain, strain and dislocation except femur, hip, pelvis and thigh with mcc
12
$63,582
$13,366
4.8× st 4.4×
176
Pulmonary embolism without mcc
12
$28,764
$7,104
4.0× st 3.6×
183
Major chest trauma with mcc
12
$45,379
$12,023
3.8× st 3.6×
206
Other respiratory system diagnoses without mcc
12
$29,125
$7,048
4.1× st 3.2×
565
Other musculoskeletal system and connective tissue diagnoses with cc
12
$36,237
$9,462
3.8× st 2.7×
315
Other circulatory system diagnoses with cc
11
$37,639
$7,548
5.0× st 3.7×
056
Degenerative nervous system disorders with mcc
11
$49,631
$16,911
2.9× st 3.4×
269
Aortic and heart assist procedures except pulsation balloon without mcc
11
$137,901
$30,827
4.5× st 3.4×
038
Extracranial procedures with cc
11
$66,131
$14,033
4.7× st 3.7×
375
Digestive malignancy with cc
11
$32,943
$9,846
3.3× st 3.0×
883
Disorders of personality and impulse control
11
$91,994
$18,871
4.9× st 2.3×
082
Traumatic stupor and coma >1 hour with mcc
11
$85,540
$17,688
4.8× st 3.3×
083
Traumatic stupor and coma >1 hour with cc
11
$34,993
$10,527
3.3× st 3.7×
086
Traumatic stupor and coma <1 hour with cc
11
$35,714
$10,945
3.3× st 3.4×
181
Respiratory neoplasms with cc
11
$36,787
$8,562
4.3× st 3.2×
219
Cardiac valve and other major cardiothoracic procedures without cardiac catheterization
11
$192,306
$59,343
3.2× st 3.1×
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
552
$16,702
$2,567
6.5×
5072
Level 2 Excision/ Biopsy/ Incision and Drainage
262
$8,224
$1,512
5.4×
5373
Level 3 Urology and Related Services
192
$8,253
$1,866
4.4×
5115
Level 5 Musculoskeletal Procedures
144
$40,122
$12,348
3.2×
5374
Level 4 Urology and Related Services
125
$16,667
$3,311
5.0×
5191
Level 1 Endovascular Procedures
121
$23,167
$3,083
7.5×
5375
Level 5 Urology and Related Services
120
$23,250
$4,920
4.7×
5361
Level 1 Laparoscopy and Related Services
116
$25,805
$5,440
4.7×
5193
Level 3 Endovascular Procedures
111
$88,394
$10,189
8.7×
5183
Level 3 Vascular Procedures
110
$13,959
$3,047
4.6×
5302
Level 2 Upper GI Procedures
99
$6,957
$1,804
3.9×
5213
Level 3 Electrophysiologic Procedures
98
$139,040
$22,429
6.2×
5073
Level 3 Excision/ Biopsy/ Incision and Drainage
92
$10,280
$2,687
3.8×
5194
Level 4 Endovascular Procedures
77
$112,296
$13,251
8.5×
5223
Level 3 Pacemaker and Similar Procedures
68
$57,178
$9,946
5.7×
5362
Level 2 Laparoscopy and Related Services
63
$38,047
$9,702
3.9×
5182
Level 2 Vascular Procedures
46
$6,590
$1,471
4.5×
5112
Level 2 Musculoskeletal Procedures
43
$5,017
$1,293
3.9×
5092
Level 2 Breast/Lymphatic Surgery and Related Procedures
43
$27,736
$6,233
4.5×
5091
Level 1 Breast/Lymphatic Surgery and Related Procedures
37
$15,840
$3,644
4.3×
5116
Level 6 Musculoskeletal Procedures
35
$52,784
$17,313
3.0×
5414
Level 4 Gynecologic Procedures
35
$11,654
$2,920
4.0×
5341
Level 1 Abdominal/Peritoneal/Biliary and Related Procedures
28
$13,356
$3,025
4.4×
5114
Level 4 Musculoskeletal Procedures
28
$29,425
$6,644
4.4×
5192
Level 2 Endovascular Procedures
27
$47,437
$5,464
8.7×
5232
Level 2 ICD and Similar Procedures
25
$116,379
$31,353
3.7×
5372
Level 2 Urology and Related Services
24
$4,809
$626
7.7×
5113
Level 3 Musculoskeletal Procedures
24
$15,742
$2,965
5.3×
5154
Level 4 Airway Endoscopy
21
$14,909
$3,580
4.2×
5222
Level 2 Pacemaker and Similar Procedures
21
$38,373
$8,121
4.7×
5415
Level 5 Gynecologic Procedures
19
$22,101
$4,755
4.6×
5224
Level 4 Pacemaker and Similar Procedures
18
$116,697
$18,583
6.3×
5155
Level 5 Airway Endoscopy
18
$24,654
$6,542
3.8×
5165
Level 5 ENT Procedures
15
$23,520
$5,598
4.2×
5464
Level 4 Neurostimulator and Related Procedures
15
$63,339
$20,858
3.0×
5331
Complex GI Procedures
13
$16,373
$5,029
3.3×
5184
Level 4 Vascular Procedures
12
$55,650
$5,253
10.6×
5376
Level 6 Urology and Related Services
12
$43,359
$8,803
4.9×
5094
Level 4 Breast/Lymphatic Surgery and Related Procedures
11
$88,213
$16,809
5.2×
5431
Level 1 Nerve Procedures
—
—
—
—
5432
Level 2 Nerve Procedures
—
—
—
—
5881
Ancillary Outpatient Services When Patient Dies
—
—
—
—
5465
Level 5 Neurostimulator and Related Procedures
—
—
—
—
5462
Level 2 Neurostimulator and Related Procedures
—
—
—
—
5503
Level 3 Extraocular, Repair, and Plastic Eye Procedures
—
—
—
—
5463
Level 3 Neurostimulator and Related Procedures
—
—
—
—
5093
Level 3 Breast/Lymphatic Surgery and Related Procedures
—
—
—
—
5378
Level 8 Urology and Related Services
—
—
—
—
5212
Level 2 Electrophysiologic Procedures
—
—
—
—
5166
Cochlear Implant Procedure
—
—
—
—
5231
Level 1 ICD and Similar Procedures
—
—
—
—
5303
Level 3 Upper GI Procedures
—
—
—
—
5313
Level 3 Lower GI Procedures
—
—
—
—
5164
Level 4 ENT Procedures
—
—
—
—
5163
Level 3 ENT Procedures
—
—
—
—
5200
Implantation Wireless PA Pressure Monitor
—
—
—
—
5153
Level 3 Airway Endoscopy
—
—
—
—
5461
Level 1 Neurostimulator and Related Procedures
—
—
—
—

Sources for this hospital

the files read, as fetched — not our copy of them
  1. MUP_INP_RY26_P03_V10_DY24_PrvSvc.CSV · 38.0M bytes · fetched 2026-08-21 · sha256 2ab6da15be4c… · publisher's page · public domain (US federal)
  2. 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)
  3. 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
  4. 2020 ZCTA to County relationship file · US Census Bureau · 2020
    tab20_zcta520_county20_natl.txt · 6.8M bytes · fetched 2026-08-21 · sha256 3ed41278d637… · publisher's page · public domain (US federal)

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. CMS, Medicare Inpatient and Outpatient Hospitals by Provider and Service, 2024.