marquette_mscs.hospital_discharge_data

marquette_mscs Updated over 7 years ago

Rows

151,425

Preview

record_id zip u_drg_definition provider_id provider_name provider_street_address provider_city provider_state hospital_referral_region_description total_discharges average_covered_charges average_total_payments average_medicare_payments lat lng
65092.0
38119
309 - CARDIAC ARRHYTHMIA & CONDUCTION DISORDERS W CC
440183.0
ST FRANCIS HOSPITAL
5959 PARK AVE
MEMPHIS
TN
TN - Memphis
47.0
33819.87
5458.19
4414.85
35.079511
-89.845385
31123.0
21229
690 - KIDNEY & URINARY TRACT INFECTIONS W/O MCC
210011.0
SAINT AGNES HOSPITAL
WILKENS & CATON AVENUES
BALTIMORE
MD
MD - Baltimore
189.0
6997.32
6580.76
5620.21
39.284242
-76.691404
132289.0
86401
690 - KIDNEY & URINARY TRACT INFECTIONS W/O MCC
30128.0
HUALAPAI MOUNTAIN MEDICAL CENTER
3801 SANTA ROSA DRIVE
KINGMAN
AZ
AZ - Phoenix
15.0
21148.8
4218.66
3394.93
35.131719
-113.703932
5888.0
5401
897 - ALCOHOL/DRUG ABUSE OR DEPENDENCE W/O REHABILITATION THERAPY W/O MCC
470003.0
FLETCHER ALLEN HOSPITAL OF VERMONT
111 COLCHESTER AVE
BURLINGTON
VT
VT - Burlington
24.0
12392.62
6449.66
5603.33
44.476621
-73.209998
1778.0
2111
698 - OTHER KIDNEY & URINARY TRACT DIAGNOSES W MCC
220116.0
TUFTS MEDICAL CENTER
800 WASHINGTON STREET
BOSTON
MA
MA - Boston
18.0
36060.0
18290.44
17977.72
42.350518
-71.059077
77970.0
46122
871 - SEPTICEMIA OR SEVERE SEPSIS W/O MV 96+ HOURS W MCC
150005.0
HENDRICKS REGIONAL HEALTH
1000 E MAIN ST
DANVILLE
IN
IN - Indianapolis
79.0
25394.48
11382.07
10368.84
39.773312
-86.551134
11770.0
8876
811 - RED BLOOD CELL DISORDERS W MCC
310048.0
SOMERSET MEDICAL CENTER
110 REHILL AVE
SOMERVILLE
NJ
NJ - New Brunswick
13.0
113379.53
12942.46
12190.38
40.589554
-74.685411
132063.0
86001
536 - FRACTURES OF HIP & PELVIS W/O MCC
30023.0
FLAGSTAFF MEDICAL CENTER
1200 NORTH BEAVER STREET
FLAGSTAFF
AZ
AZ - Phoenix
12.0
26392.5
7443.5
6416.5
35.287661
-111.639303
109936.0
70634
392 - ESOPHAGITIS| GASTROENT & MISC DIGEST DISORDERS W/O MCC
190050.0
BEAUREGARD MEMORIAL HOSPITAL
600 S PINE STREET
DERIDDER
LA
LA - Lake Charles
22.0
18401.18
4142.0
3324.54
30.793357
-93.240067
90025.0
53715
286 - CIRCULATORY DISORDERS EXCEPT AMI| W CARD CATH W MCC
520089.0
MERITER HSPTL
202 S PARK ST
MADISON
WI
WI - Madison
18.0
56069.66
17887.38
14839.5
43.06849
-89.401708