Hospital General Information from Hospital Compare

In [1]:

    

url <- "https://data.medicare.gov/views/bg9k-emty/files/7825b9e4-e595-4f25-86e0-32a68d7ac7a4?content_type=application%2Fzip%3B%20charset%3Dbinary&filename=Hospital_Revised_Flatfiles.zip"
f <- tempfile()
download.file(url, f, mode="wb")
file.info(f)
unzip(f, list=TRUE)
unzip(f, exdir=tempdir())


    

    
Out[1]:





size
isdir
mode
mtime
ctime
atime
exe

	
C:\Users\chanb\AppData\Local\Temp\RtmpKGofmf\file1114383eed0
14721503
FALSE
666
2016-05-05 12:03:37
2016-05-05 12:03:29
2016-05-05 12:03:29
no









    
Out[1]:





Name
Length
Date

	
1
Ambulatory Surgical Measures-Facility.csv
2101385
2016-02-23 10:13:00
	
2
Ambulatory Surgical Measures-National.csv
846
2016-02-23 10:13:00
	
3
Ambulatory Surgical Measures-State.csv
12334
2016-02-23 10:13:00
	
4
Complications - Hospital.csv
9958509
2016-04-19 13:13:00
	
5
Complications - National.csv
1128
2016-04-19 13:13:00
	
6
Complications - State.csv
52205
2016-04-19 13:13:00
	
7
Footnote Crosswalk.csv
1915
2016-04-19 13:12:00
	
8
FY2014_Distribution_of_Net_Change_in_Base_Op_DRG_Payment_Amt.csv
304
2015-10-19 12:32:00
	
9
FY2014_Net_Change_in_Base_Op_DRG_Payment_Amt.csv
973
2015-10-19 12:32:00
	
10
FY2014_Percent_Change_in_Medicare_Payments.csv
670
2015-10-22 14:54:00
	
11
FY2014_Value_Based_Incentive_Payment_Amount.csv
795
2015-10-19 12:32:00
	
12
HCAHPS - Hospital.csv
102062909
2016-04-19 13:22:00
	
13
HCAHPS - National.csv
6243
2016-04-19 13:22:00
	
14
HCAHPS - State.csv
359444
2016-04-19 13:22:00
	
15
Healthcare Associated Infections - Hospital.csv
62152385
2016-04-19 13:17:00
	
16
Healthcare Associated Infections - National.csv
1092
2016-04-19 13:17:00
	
17
Healthcare Associated Infections - State.csv
149496
2016-04-19 13:17:00
	
18
Hospital General Information.csv
823030
2016-04-19 13:13:00
	
19
Hospital.pdf
2037774
2016-04-18 19:12:00
	
20
HOSPITAL_QUARTERLY_HAC_DOMAIN_HOSPITAL_02_26_2016.csv
416026
2016-02-26 14:37:00
	
21
HOSPITAL_QUARTERLY_IPFQR_MEASURES_HOSPITAL.csv
3011002
2016-03-24 10:17:00
	
22
HOSPITAL_QUARTERLY_IPFQR_MEASURES_NATIONAL.csv
4558
2016-02-23 10:13:00
	
23
HOSPITAL_QUARTERLY_IPFQR_MEASURES_STATE.csv
84454
2016-02-23 10:13:00
	
24
HOSPITAL_QUARTERLY_QUALITYMEASURE_PCH_HOSPITAL.csv
7182
2016-02-28 21:38:00
	
25
hvbp_ami_02_18_2016.csv
541627
2016-02-28 22:20:00
	
26
hvbp_Efficiency_02_18_2016.csv
456755
2016-02-28 22:26:00
	
27
hvbp_hai_02_18_2016.csv
792244
2016-02-28 22:31:00
	
28
hvbp_hcahps_02_18_2016.csv
1335697
2016-02-29 10:45:00
	
29
hvbp_imm2_02_18_2016.csv
467763
2016-02-29 11:01:00
	
30
hvbp_outcome_02_18_2016.csv
1678650
2016-03-10 11:17:00
	
31
hvbp_pn_02_18_2016.csv
471608
2016-02-29 10:05:00
	
32
hvbp_scip_02_18_2016.csv
637965
2016-02-29 10:29:00
	
33
hvbp_tps_02_18_2016.csv
789876
2016-02-29 10:15:00
	
34
Measure Dates.csv
21176
2016-04-19 13:12:00
	
35
Medicare Hospital Spending by Claim.csv
11133022
2016-03-24 17:54:00
	
36
Medicare Hospital Spending per Patient - Hospital.csv
764726
2016-04-19 13:12:00
	
37
Medicare Hospital Spending per Patient - National.csv
282
2016-04-19 13:12:00
	
38
Medicare Hospital Spending per Patient - State.csv
8496
2016-04-19 13:12:00
	
39
Outpatient Imaging Efficiency - Hospital.csv
5542547
2016-04-19 13:12:00
	
40
Outpatient Imaging Efficiency - National.csv
654
2016-04-19 13:12:00
	
41
Outpatient Imaging Efficiency - State.csv
29499
2016-04-19 13:12:00
	
42
Outpatient Procedures - Volume.csv
593119
2016-02-18 10:32:00
	
43
Payment - National.csv
580
2016-04-19 13:13:00
	
44
Payment - State.csv
17300
2016-04-19 13:13:00
	
45
Payment and Value of Care - Hospital.csv
5651287
2016-04-19 13:13:00
	
46
readme.txt
352
2005-05-12 09:01:00
	
47
READMISSION REDUCTION.csv
2327938
2016-02-18 10:32:00
	
48
Readmissions and Deaths - Hospital.csv
19888752
2016-04-19 13:13:00
	
49
Readmissions and Deaths - National.csv
1980
2016-04-19 13:13:00
	
50
Readmissions and Deaths - State.csv
93041
2016-04-19 13:13:00
	
51
Structural Measures - Hospital.csv
6736284
2016-04-19 13:13:00
	
52
Timely and Effective Care - Hospital.csv
54559081
2016-04-19 13:13:00
	
53
Timely and Effective Care - National.csv
17767
2016-04-19 13:13:00
	
54
Timely and Effective Care - State.csv
492128
2016-04-19 13:13:00
	
55
Value of Care - National.csv
5158
2016-04-19 13:13:00

In [2]:

    

library(data.table)
D <- fread(file.path(tempdir(), "Hospital General Information.csv"))
old <- names(D)
new <- gsub("\\s", "", old)
setnames (D, old, new)
str(D)
D[State == "OR", .N, .(State, HospitalType, HospitalOwnership, EmergencyServices)]


    

    




Classes 'data.table' and 'data.frame':	4799 obs. of  11 variables:
 $ ProviderID       : chr  "010001" "010005" "010006" "010007" ...
 $ HospitalName     : chr  "SOUTHEAST ALABAMA MEDICAL CENTER" "MARSHALL MEDICAL CENTER SOUTH" "ELIZA COFFEE MEMORIAL HOSPITAL" "MIZELL MEMORIAL HOSPITAL" ...
 $ Address          : chr  "1108 ROSS CLARK CIRCLE" "2505 U S HIGHWAY 431 NORTH" "205 MARENGO STREET" "702 N MAIN ST" ...
 $ City             : chr  "DOTHAN" "BOAZ" "FLORENCE" "OPP" ...
 $ State            : chr  "AL" "AL" "AL" "AL" ...
 $ ZIPCode          : chr  "36301" "35957" "35631" "36467" ...
 $ CountyName       : chr  "HOUSTON" "MARSHALL" "LAUDERDALE" "COVINGTON" ...
 $ PhoneNumber      : chr  "3347938701" "2565938310" "2567688400" "3344933541" ...
 $ HospitalType     : chr  "Acute Care Hospitals" "Acute Care Hospitals" "Acute Care Hospitals" "Acute Care Hospitals" ...
 $ HospitalOwnership: chr  "Government - Hospital District or Authority" "Government - Hospital District or Authority" "Government - Hospital District or Authority" "Voluntary non-profit - Private" ...
 $ EmergencyServices: chr  "Yes" "Yes" "Yes" "Yes" ...
 - attr(*, ".internal.selfref")=<externalptr> 






    
Out[2]:





State
HospitalType
HospitalOwnership
EmergencyServices
N

	
1
OR
Acute Care Hospitals
Voluntary non-profit - Other
Yes
6
	
2
OR
Acute Care Hospitals
Government - Local
Yes
1
	
3
OR
Acute Care Hospitals
Voluntary non-profit - Private
Yes
18
	
4
OR
Acute Care Hospitals
Voluntary non-profit - Church
Yes
7
	
5
OR
Acute Care Hospitals
Government - Hospital District or Authority
Yes
2
	
6
OR
ACUTE CARE - VETERANS ADMINISTRATION
Government Federal
No
2
	
7
OR
Critical Access Hospitals
Voluntary non-profit - Private
Yes
7
	
8
OR
Critical Access Hospitals
Voluntary non-profit - Church
Yes
7
	
9
OR
Critical Access Hospitals
Government - Hospital District or Authority
Yes
10
	
10
OR
Critical Access Hospitals
Proprietary
Yes
1