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.

16 rows where fcntyname = "SC-Greenville County"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, new_prov, shortname, pcity, pzip, hsa, hsaname, posbeds, sysname, ahabeds, category, teachstatus, hosptype, excl_flag, icu_flag, year, 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
14261 14261 420023 420023   Bon Secours St. Francis-Greenville GREENVILLE SC 29601 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 319 Bon Secours Health System, Inc. 396.0     4.Other acute care hosp   9.OK?       9.OK? ST FRANCIS-DOWNTOWN   34.851354 -82.3984882
14265 14265 420033 420033   Ghs Greer Memorial Hospital GREER SC 29650 42026 SC- GREER 368 SC- GREENVILLE 45045 SC-Greenville County 82 Greenville Health System 70.0     4.Other acute care hosp   9.OK?       9.OK? GHS GREER MEMORIAL HOSPITAL   34.9381361 -82.2272119
14267 14267 420037 420037   Ghs Hillcrest Memorial Hospital SIMPSONVILLE SC 29681 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 43 Greenville Health System 43.0     4.Other acute care hosp   9.OK?       9.OK? GHS HILLCREST MEMORIAL HOSPITAL   34.7370639 -82.2542834
14285 14285 420078 420078   Ghs Greenville Memorial Hospital GREENVILLE SC 29605 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 746 Greenville Health System 754.0 Integrated Other Teaching 1.Integrated AMC   9.OK?       9.OK? GHS GREENVILLE MEMORIAL HOSPITAL   34.851354 -82.3984882
14297 14297 420102 420102   Patewood Memorial Hospital GREENVILLE SC 29615 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 72 Greenville Health System 72.0     4.Other acute care hosp   9.OK? noICUdays     9.OK? GHS PATEWOOD MEMORIAL HOSPITAL   34.8550021 -82.3356457
14298 14298 420103 420103   Pelham Medical Center GREER SC 29651 42026 SC- GREER 368 SC- GREENVILLE 45045 SC-Greenville County 48 Spartanburg Regional Healthcare System 46.0     4.Other acute care hosp   9.OK?       9.OK? PELHAM MEDICAL CENTER   34.9381361 -82.2272119
14314 14314 422008 422008   North Greenville Hospital TRAVELERS REST SC 29690 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 45   28.0     5.Longterm/non-acute   1.NonAcute       1.NonAcute GHS NORTH GREENVILLE LTACH   34.9676167 -82.4434548
14315 14315 422009 422009   Regency Hospital Of Greenville GREENVILLE SC 29601 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 32 Select Medical Corporation 32.0     5.Longterm/non-acute   1.NonAcute noICUdays     1.NonAcute REGENCY HOSPITAL OF GREENVILLE   34.851354 -82.3984882
19336 19336 420023 420023   Bon Secours St. Francis-Greenville GREENVILLE SC 29601 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 226 Bon Secours Health System, Inc. 352.0     4.Other acute care hosp   9.OK?   2017.0     ST FRANCIS-DOWNTOWN 9.OK? 34.851354 -82.3984882
19340 19340 420033 420033   Ghs Greer Memorial Hospital GREER SC 29650 42026 SC- GREER 368 SC- GREENVILLE 45045 SC-Greenville County 82 Greenville Health System 70.0     4.Other acute care hosp   9.OK?   2017.0     GHS GREER MEMORIAL HOSPITAL 9.OK? 34.9381361 -82.2272119
19342 19342 420037 420037   Ghs Hillcrest Memorial Hospital SIMPSONVILLE SC 29681 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 43 Greenville Health System 43.0     4.Other acute care hosp   9.OK?   2017.0     GHS HILLCREST MEMORIAL HOSPITAL 9.OK? 34.7370639 -82.2542834
19359 19359 420078 420078   Ghs Greenville Memorial Hospital GREENVILLE SC 29605 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 746 Greenville Health System 807.0 Integrated Other Teaching 1.Integrated AMC   9.OK?   2017.0     GHS GREENVILLE MEMORIAL HOSPITAL 9.OK? 34.851354 -82.3984882
19371 19371 420102 420102   Patewood Memorial Hospital GREENVILLE SC 29615 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 72 Greenville Health System 72.0     4.Other acute care hosp   9.OK? noICUdays 2017.0     GHS PATEWOOD MEMORIAL HOSPITAL 9.OK? 34.8550021 -82.3356457
19372 19372 420103 420103   Pelham Medical Center GREER SC 29651 42026 SC- GREER 368 SC- GREENVILLE 45045 SC-Greenville County 48 Spartanburg Regional Healthcare System 48.0     4.Other acute care hosp   9.OK?   2017.0     PELHAM MEDICAL CENTER 9.OK? 34.9381361 -82.2272119
19388 19388 422008 422008   North Greenville Hospital TRAVELERS REST SC 29690 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 45   28.0     5.Longterm/non-acute   1.NonAcute   2017.0     GHS NORTH GREENVILLE LTACH 1.NonAcute 34.9676167 -82.4434548
19389 19389 422009 422009   Regency Hospital Of Greenville GREENVILLE SC 29601 42024 SC- GREENVILLE 368 SC- GREENVILLE 45045 SC-Greenville County 32 Select Medical Corporation 32.0     5.Longterm/non-acute   1.NonAcute noICUdays 2017.0     REGENCY HOSPITAL OF GREENVILLE 1.NonAcute 34.851354 -82.3984882

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