Hospital Atlas Data

Includes information about hospitals such as provider details, location, teaching status, and bed counts. This data is essential for understanding the distribution and capacity of healthcare facilities within local networks.

Data license: Please contact the data provider for more information. · Data source: U.S. Census, Dartmouth Atlas of Health Care, NCQA, AIDOS Lab.

3 rows where pstate = "AZ" and sysname = "RCCH HealthCare Partners"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: new_prov, fcntyname, status15, status16, pname, status17

Link rowid ▼ provider new_prov status14 shortname pcity pstate pzip hsa hsaname hrr hrrname fcounty fcntyname posbeds sysname ahabeds category teachstatus hosptype nci_center excl_flag icu_flag year status15 status16 pname status17 latitude longitude
5312 5312 30043     Canyon Vista Medical Center SIERRA VISTA AZ 85635 3027 AZ- SIERRA VISTA 15 AZ- TUCSON 4003 Cochise County, AZ 69 RCCH HealthCare Partners 100.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       31.5545973 -110.2997756
10443 10443 30043 030043   Canyon Vista Medical Center SIERRA VISTA AZ 85635 3027 AZ- SIERRA VISTA 15 AZ- TUCSON 4003 AZ-Cochise County 69 RCCH HealthCare Partners 100.0     4.Other acute care hosp   9.OK?       9.OK? CANYON VISTA MEDICAL CENTER   31.5545973 -110.2997756
15553 15553 30043 030043   Canyon Vista Medical Center SIERRA VISTA AZ 85635 3027 AZ- SIERRA VISTA 15 AZ- TUCSON 4003 AZ-Cochise County 69 RCCH HealthCare Partners 100.0     4.Other acute care hosp   9.OK?   2017.0     CANYON VISTA MEDICAL CENTER 9.OK? 31.5545973 -110.2997756

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE "hospital_atlas_data" (
   [provider] INTEGER,
   [new_prov] TEXT,
   [status14] TEXT,
   [shortname] TEXT,
   [pcity] TEXT,
   [pstate] TEXT,
   [pzip] INTEGER,
   [hsa] INTEGER,
   [hsaname] TEXT,
   [hrr] INTEGER,
   [hrrname] TEXT,
   [fcounty] INTEGER,
   [fcntyname] TEXT,
   [posbeds] INTEGER,
   [sysname] TEXT,
   [ahabeds] FLOAT,
   [category] TEXT,
   [teachstatus] TEXT,
   [hosptype] TEXT,
   [nci_center] TEXT,
   [excl_flag] TEXT,
   [icu_flag] TEXT,
   [year] FLOAT,
   [status15] TEXT,
   [status16] TEXT,
   [pname] TEXT,
   [status17] TEXT,
   [latitude] FLOAT,
   [longitude] FLOAT
);