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.

4 rows where hrrname = "HI- HONOLULU" and provider = 121300

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: new_prov, status14, fcntyname, ahabeds, 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
1150 1150 121300   9.OK? Kauai Veterans Memorial Hospital WAIMEA HI 96796 12014 HI- WAIMEA 150 HI- HONOLULU 15007 Kauai County, HI 25 Hawaii Health Systems Corporation 25.0     3.Critical Access Hosp   9.OK?   2014.0         21.9586111 -159.6708333
6320 6320 121300     Kauai Veterans Memorial Hospital WAIMEA HI 96796 12014 HI- WAIMEA 150 HI- HONOLULU 15007 Kauai County, HI 25 Hawaii Health Systems Corporation 25.0     3.Critical Access Hosp   9.OK?   2016.0 9.OK?       21.9586111 -159.6708333
11448 11448 121300 121300   Kauai Veterans Memorial Hospital WAIMEA HI 96796 12014 HI- WAIMEA 150 HI- HONOLULU 15007 HI-Kauai County 25 Hawaii Health Systems Corporation 45.0     3.Critical Access Hosp   9.OK?       9.OK? KAUAI VETERANS MEMORIAL HOSPITAL   21.9586111 -159.6708333
16556 16556 121300 121300   Kauai Veterans Memorial Hospital WAIMEA HI 96796 12014 HI- WAIMEA 150 HI- HONOLULU 15007 HI-Kauai County 25 Hawaii Health Systems Corporation 45.0     3.Critical Access Hosp   9.OK?   2017.0     KAUAI VETERANS MEMORIAL HOSPITAL 9.OK? 21.9586111 -159.6708333

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
);