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 fcounty = 48053, hrr = 385 and shortname = "Seton Highland Lakes"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: new_prov, status14, fcntyname, sysname, ahabeds, 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
4571 4571 451365   9.OK? Seton Highland Lakes BURNET TX 78611 45038 TX- BURNET 385 TX- AUSTIN 48053 Burnet County, TX 25 Ascension Health 23.0     3.Critical Access Hosp   9.OK?   2014.0         30.7608552 -98.2239954
9699 9699 451365     Seton Highland Lakes BURNET TX 78611 45038 TX- BURNET 385 TX- AUSTIN 48053 Burnet County, TX 25 Ascension Health 19.0     3.Critical Access Hosp   9.OK?   2016.0 9.OK?       30.7608552 -98.2239954
14806 14806 451365 451365   Seton Highland Lakes BURNET TX 78611 45038 TX- BURNET 385 TX- AUSTIN 48053 TX-Burnet County 25 Ascension Healthcare 19.0     3.Critical Access Hosp   9.OK?       9.OK? SETON HIGHLAND LAKES   30.7608552 -98.2239954
19873 19873 451365 451365   Seton Highland Lakes BURNET TX 78611 45038 TX- BURNET 385 TX- AUSTIN 48053 TX-Burnet County 25 Ascension Healthcare 19.0     3.Critical Access Hosp   9.OK?   2017.0     SETON HIGHLAND LAKES 9.OK? 30.7608552 -98.2239954

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