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.

8 rows where fcntyname = "TX-Grayson County"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, new_prov, shortname, pcity, pzip, hsa, hsaname, posbeds, sysname, ahabeds, 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
14593 14593 450324 450324   Texoma Medical Center DENISON TX 75020 45072 TX- DENISON 391 TX- DALLAS 48181 TX-Grayson County 277 Universal Health Services, Inc. 326.0     4.Other acute care hosp   9.OK?       9.OK? TEXOMA MEDICAL CENTER   33.7556593 -96.536658
14622 14622 450469 450469   Wilson N. Jones Regional Med Ctr SHERMAN TX 75091 45237 TX- SHERMAN 391 TX- DALLAS 48181 TX-Grayson County 201 Alecto Healthcare 108.0     4.Other acute care hosp   9.OK?       9.OK? WILSON N JONES REGIONAL MEDICAL CENTER   33.6398609 -96.6089146
14843 14843 452041 452041   Carrus Specialty Hospital SHERMAN TX 75092 45237 TX- SHERMAN 391 TX- DALLAS 48181 TX-Grayson County 16 Carrus Hospitals 16.0     5.Longterm/non-acute   1.NonAcute       1.NonAcute CARRUS SPECIALTY HOSPITAL   33.6398609 -96.6089146
15381 15381 670076 670076   Heritage Park Surgical Hospital SHERMAN TX 75090 45237 TX- SHERMAN 391 TX- DALLAS 48181 TX-Grayson County 14 Foundation Surgical Hospital Affiliates 12.0     4.Other acute care hosp   9.OK? noICUdays     9.OK? BAYLOR SCOTT AND WHITE SURGICAL HOSPITAL AT SHERMA   33.6398609 -96.6089146
19660 19660 450324 450324   Texoma Medical Center DENISON TX 75020 45072 TX- DENISON 391 TX- DALLAS 48181 TX-Grayson County 289 Universal Health Services, Inc. 326.0     4.Other acute care hosp   9.OK?   2017.0     TEXOMA MEDICAL CENTER 9.OK? 33.7556593 -96.536658
19689 19689 450469 450469   Wilson N. Jones Regional Med Ctr SHERMAN TX 75091 45237 TX- SHERMAN 391 TX- DALLAS 48181 TX-Grayson County 201 Alecto Healthcare 108.0     4.Other acute care hosp   9.OK?   2017.0     WILSON N JONES REGIONAL MEDICAL CENTER 9.OK? 33.6398609 -96.6089146
19913 19913 452041 452041   Carrus Specialty Hospital SHERMAN TX 75092 45237 TX- SHERMAN 391 TX- DALLAS 48181 TX-Grayson County 16 Carrus Hospitals 16.0     5.Longterm/non-acute   1.NonAcute   2017.0     CARRUS SPECIALTY HOSPITAL 1.NonAcute 33.6398609 -96.6089146
20445 20445 670076 670076   Heritage Park Surgical Hospital SHERMAN TX 75090 45237 TX- SHERMAN 391 TX- DALLAS 48181 TX-Grayson County 14 Foundation Surgical Hospital Affiliates 12.0     4.Other acute care hosp   9.OK? noICUdays 2017.0     BAYLOR SCOTT AND WHITE SURGICAL HOSPITAL AT SHERMA 9.OK? 33.6398609 -96.6089146

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