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 latitude = "21.0906247"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: new_prov, status14, 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
1153 1153 121303   9.OK? Molokai General Hospital KAUNAKAKAI HI 96748 12003 HI- HONOLULU 150 HI- HONOLULU 15009 Maui County, HI 13 Queen's Health Systems 15.0     3.Critical Access Hosp   9.OK? noICUdays 2014.0         21.0906247 -157.0208436
6323 6323 121303     Molokai General Hospital KAUNAKAKAI HI 96748 12003 HI- HONOLULU 150 HI- HONOLULU 15009 Maui County, HI 13 Queen's Health Systems 15.0     3.Critical Access Hosp   9.OK? noICUdays 2016.0 9.OK?       21.0906247 -157.0208436
11451 11451 121303 121303   Molokai General Hospital KAUNAKAKAI HI 96748 12003 HI- HONOLULU 150 HI- HONOLULU 15009 HI-Maui County 13 Queen's Health Systems 15.0     3.Critical Access Hosp   9.OK? noICUdays     9.OK? MOLOKAI GENERAL HOSPITAL   21.0906247 -157.0208436
16559 16559 121303 121303   Molokai General Hospital KAUNAKAKAI HI 96748 12003 HI- HONOLULU 150 HI- HONOLULU 15009 HI-Maui County 13 Queen's Health Systems 15.0     3.Critical Access Hosp   9.OK? noICUdays 2017.0     MOLOKAI GENERAL HOSPITAL 9.OK? 21.0906247 -157.0208436

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