Authoritative Hospital Database from CarePrecise

Field Name Description Data Type Field Size
CCN Number assigned by Medicare to hospitals Text 6
NPI Number assigned to all HIPAA-covered providers Text 10
EIN Employer Identification Number (tax number/TIN) Text 20
HospitalName Hospital’s name Text 255
Address1 Hospital’s address, line 1 Text 100
Address2 Hospital’s address, line 2 Text 100
City Hospital’s City Text 100
State Hospital State Text 2
ZIP Code Hospital Zip Code Text 5
County Hospital County Text 25
Phone Hospital Phone Text 10
Fax Hospital Fax Text 20
Beds Number of beds Long Integer
BedDaysAvail Number of bed days available Long Integer
InternsAndResidents Number of interns and residents Double
PayrollEmployees Number of employees on payroll Double
NonPaidWorkers Number of non-paid workers Double
TotalDischarges Number of discharges/year Double
MedicareDischarges Number of Medicare discharges/year Double
MedicaidDischarges Number of Medicaid discharges/year Double
Vol_Gastrointestinal Procedure volume: Gastrointestinal Text 20
Vol_Eye Procedure volume: Eye Text 20
Vol_Nervous_system Procedure volume: Nervous system Text 20
Vol_Musculoskeletal Procedure volume: Musculoskeletal Text 20
Vol_Skin Procedure volume: Skin Text 20
Vol_Genitourinary Procedure volume: Genitourinary Text 20
Vol_Cardiovascular Procedure volume: Cardiovascular Text 20
PN Contact name prefix Text 5
FN Contact first name Text 20
MN Contact middle name Text 20
LN Contact last name Text 35
SN Contact name suffix Text 5
Title Contact title Text 35
Cred Contact credentials Text 50
Teaching Hospital Y = this is a teaching hospital Text 1
HospitalType Type of hospital Text 50
HospitalOwnership Type of hospital ownership Text 100
ParentOrgLBN Name of parent system Text 100
EmergencyService Does have emergency service? Text 50
CoLoCode Algorithmically derived from location data Text 40
Bathroom cleanliness Patient satisfaction 1-5 stars Long Integer
Communication from Nurses Patient satisfaction 1-5 stars Long Integer
Communication from Doctors Patient satisfaction 1-5 stars Long Integer
Patient received help quickly on request Patient satisfaction 1-5 stars Long Integer
Quality of pain control Patient satisfaction 1-5 stars Long Integer
Medications were explained before giving Patient satisfaction 1-5 stars Long Integer
Patient received instruction on at home recovery Patient satisfaction 1-5 stars Long Integer
Patient understood care when leaving hospital Patient satisfaction 1-5 stars Long Integer
Patient’s overall hospital rating Patient satisfaction 1-5 stars Long Integer
Area around room was quiet at night Patient satisfaction 1-5 stars Long Integer
Patient would recommend hospital Patient satisfaction 1-5 stars Long Integer
Hospital summary star rating Patient satisfaction 1-5 stars Long Integer