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 ahabeds = "93.0" and hrrname = "OK- OKLAHOMA CITY"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: new_prov, status14, fcntyname, sysname, 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
3722 3722 372004   1.NonAcute Kindred Hospital- Oklahoma City OKLAHOMA CITY OK 73103 37063 OK- OKLAHOMA CITY 339 OK- OKLAHOMA CITY 40109 Oklahoma County, OK 77 Kindred Healthcare 93.0     5.Longterm/non-acute   1.NonAcute   2014.0         35.4729886 -97.5170536
8864 8864 372004     Kindred Hospital- Oklahoma City OKLAHOMA CITY OK 73103 37063 OK- OKLAHOMA CITY 339 OK- OKLAHOMA CITY 40109 Oklahoma County, OK 77 Kindred Healthcare 93.0     5.Longterm/non-acute   1.NonAcute   2016.0 1.NonAcute       35.4729886 -97.5170536
13978 13978 372004 372004   Kindred Hospital- Oklahoma City OKLAHOMA CITY OK 73103 37063 OK- OKLAHOMA CITY 339 OK- OKLAHOMA CITY 40109 OK-Oklahoma County 77 Curahealth Hospitals 93.0     5.Longterm/non-acute   1.NonAcute       1.NonAcute CURAHEALTH OKLAHOMA   35.4729886 -97.5170536
19060 19060 372004 372004   Kindred Hospital- Oklahoma City OKLAHOMA CITY OK 73103 37063 OK- OKLAHOMA CITY 339 OK- OKLAHOMA CITY 40109 OK-Oklahoma County 77 Curahealth Hospitals 93.0     5.Longterm/non-acute   1.NonAcute   2017.0     CURAHEALTH OKLAHOMA 1.NonAcute 35.4729886 -97.5170536

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