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.

11 rows where ahabeds = "285.0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, new_prov, status14, shortname, pcity, pstate, pzip, hsa, hsaname, hrr, hrrname, fcounty, fcntyname, posbeds, sysname, year, status15, status16, pname, status17, 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
1255 1255 140118   9.OK? MetroSouth Medical Center BLUE ISLAND IL 60406 14012 IL- BLUE ISLAND 155 IL- BLUE ISLAND 17031 Cook County, IL 295 Community Health Systems, Inc. 285.0     4.Other acute care hosp   9.OK?   2014.0         41.6573014 -87.679871
2117 2117 210044   9.OK? Greater Baltimore Medical Center BALTIMORE MD 21204 21002 MD- BALTIMORE 223 MD- BALTIMORE 24005 Baltimore County, MD 303   285.0     4.Other acute care hosp   9.OK?   2014.0         39.2908816 -76.610759
6425 6425 140118     MetroSouth Medical Center BLUE ISLAND IL 60406 14012 IL- BLUE ISLAND 155 IL- BLUE ISLAND 17031 Cook County, IL 295 Quorum Health 285.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       41.6573014 -87.679871
7257 7257 210019     Peninsula Regional Medical Ctr SALISBURY MD 21801 21029 MD- SALISBURY 225 MD- SALISBURY 24045 Wicomico County, MD 400   285.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       38.366027 -75.6009964
8127 8127 310048     RWJ University Hosp-Somerset SOMERVILLE NJ 8876 31056 NJ- SOMERVILLE 288 NJ- NEW BRUNSWICK 34035 Somerset County, NJ 289 RWJBarnabas Health 285.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       33.09924124489796 -96.74170622448979
11551 11551 140118 140118   Metrosouth Medical Center BLUE ISLAND IL 60406 14012 IL- BLUE ISLAND 155 IL- BLUE ISLAND 17031 IL-Cook County 295 Quorum Health 285.0     4.Other acute care hosp   9.OK?       9.OK? METROSOUTH MEDICAL CENTER   41.6573014 -87.679871
13242 13242 310048 310048   Rwj University Hosp-Somerset SOMERVILLE NJ 8876 31056 NJ- SOMERVILLE 288 NJ- NEW BRUNSWICK 34035 NJ-Somerset County 289 RWJBarnabas Health 285.0     4.Other acute care hosp   9.OK?       9.OK? ROBERT WOOD JOHNSON UNIVERSITY HOSPITAL SOMERSET   33.09924124489796 -96.74170622448979
16659 16659 140118 140118   Metrosouth Medical Center BLUE ISLAND IL 60406 14012 IL- BLUE ISLAND 155 IL- BLUE ISLAND 17031 IL-Cook County 300 Quorum Health 285.0     4.Other acute care hosp   9.OK?   2017.0     METROSOUTH MEDICAL CENTER 9.OK? 41.6573014 -87.679871
18332 18332 310048 310048   Rwj University Hosp-Somerset SOMERVILLE NJ 8876 31056 NJ- SOMERVILLE 288 NJ- NEW BRUNSWICK 34035 NJ-Somerset County 289 RWJBarnabas Health 285.0     4.Other acute care hosp   9.OK?   2017.0     ROBERT WOOD JOHNSON UNIVERSITY HOSPITAL SOMERSET 9.OK? 33.09924124489796 -96.74170622448979
19362 19362 420082 420082   Aiken Regional Medical Centers AIKEN SC 29801 42002 SC- AIKEN 145 GA- AUGUSTA 45003 SC-Aiken County 168 Universal Health Services, Inc. 285.0     4.Other acute care hosp   9.OK?   2017.0     AIKEN REGIONAL MEDICAL CENTER 9.OK? 33.5616173 -81.7224579
19718 19718 450639 450639   Tx Hlth Harris Meth-Hurst-Euless BEDFORD TX 76022 45022 TX- BEDFORD 394 TX- FORT WORTH 48439 TX-Tarrant County 204 Texas Health Resources 285.0     4.Other acute care hosp   9.OK?   2017.0     TEXAS HEALTH HARRIS METHODIST HURST-EULESS-BEDFORD 9.OK? 32.844017 -97.1430671

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