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.

7 rows where ahabeds = "579.0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: new_prov, status14, pstate, hrr, hrrname, sysname, category, teachstatus, hosptype, year, 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
143 143 30065   9.OK? Banner Desert Medical Center MESA AZ 85202 3016 AZ- MESA 11 AZ- MESA 4013 Maricopa County, AZ 577 Banner Health 579.0     4.Other acute care hosp   9.OK?   2014.0         33.4151005 -111.831455
2629 2629 260077   9.OK? St. Anthony's Medical Center SAINT LOUIS MO 63128 26082 MO- ST LOUIS 273 MO- ST LOUIS 29189 St Louis County, MO 644   579.0     4.Other acute care hosp   9.OK?   2014.0         38.6280278 -90.1910154
8763 8763 370037     St. Anthony Hospital OKLAHOMA CITY OK 73101 37063 OK- OKLAHOMA CITY 339 OK- OKLAHOMA CITY 40109 Oklahoma County, OK 511 SSM Health 579.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       35.4729886 -97.5170536
13220 13220 310014 310014   Cooper University Health Care CAMDEN NJ 8103 31005 NJ- CAMDEN 283 NJ- CAMDEN 34007 NJ-Camden County 522   579.0 Integrated Major Teaching 1.Integrated AMC   9.OK?       9.OK? COOPER UNIVERSITY HOSPITAL   33.8500678309478 -84.8375810429396
14616 14616 450431 450431   St. David's Medical Center AUSTIN TX 78705 45016 TX- AUSTIN 385 TX- AUSTIN 48453 TX-Travis County 487 HCA Healthcare 579.0     4.Other acute care hosp   9.OK?       9.OK? ST DAVID'S MEDICAL CENTER   30.2711286 -97.7436995
18344 18344 310073 310073   Jersey Shore University Med Ctr NEPTUNE NJ 7754 31033 NJ- NEPTUNE 283 NJ- CAMDEN 34025 NJ-Monmouth County 460 Hackensack Meridian Health 579.0 Independent Other Teaching 2.Other teaching hosp   9.OK?   2017.0     JERSEY SHORE UNIVERSITY MEDICAL CENTER 9.OK? 35.27663902636019 -111.51399647005597
19452 19452 440006 440006   Tristar Skyline Medical Center NASHVILLE TN 37207 44063 TN- NASHVILLE 380 TN- NASHVILLE 47037 TN-Davidson County 340 HCA Healthcare 579.0     4.Other acute care hosp   9.OK?   2017.0     TRISTAR SKYLINE MEDICAL CENTER 9.OK? 36.1622767 -86.7742984

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