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 fcntyname = "Oklahoma County, OK" and status15 = "1.NonAcute"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pcity, hsa, hsaname, latitude, longitude

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
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
8865 8865 372005     AMG Specialty Hospital-Edmond EDMOND OK 73034 37029 OK- EDMOND 339 OK- OKLAHOMA CITY 40109 Oklahoma County, OK 37 AMG Integrated Healthcare Management 37.0     5.Longterm/non-acute   1.NonAcute   2016.0 1.NonAcute       35.6571367 -97.4649038
8867 8867 372009     Select Specialty Hosp-Oklahoma City OKLAHOMA CITY OK 73112 37063 OK- OKLAHOMA CITY 339 OK- OKLAHOMA CITY 40109 Oklahoma County, OK 72 Select Medical Corporation 72.0     5.Longterm/non-acute   1.NonAcute   2016.0 1.NonAcute       35.4729886 -97.5170536
8869 8869 372012     Specialty Hospital of Midwest City MIDWEST CITY OK 73110 37056 OK- MIDWEST CITY 339 OK- OKLAHOMA CITY 40109 Oklahoma County, OK 31 Concord Healthcare Group 31.0     5.Longterm/non-acute   1.NonAcute   2016.0 1.NonAcute       35.4495097 -97.3967025

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