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.

2 rows where fcntyname = "LA-Calcasieu Parish" and pname = "DEQUINCY MEMORIAL HOSPITAL"

✎ View and edit SQL

This data as json, CSV (advanced)

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
12276 12276 191307 191307   Dequincy Memorial Hospital DEQUINCY LA 70633 19020 LA- DE QUINCY 214 LA- LAKE CHARLES 22019 LA-Calcasieu Parish 15   19.0     3.Critical Access Hosp   9.OK? noICUdays     9.OK? DEQUINCY MEMORIAL HOSPITAL   30.4499652 -93.4341349
17379 17379 191307 191307   Dequincy Memorial Hospital DEQUINCY LA 70633 19020 LA- DE QUINCY 214 LA- LAKE CHARLES 22019 LA-Calcasieu Parish 15   19.0     3.Critical Access Hosp   9.OK? noICUdays 2017.0     DEQUINCY MEMORIAL HOSPITAL 9.OK? 30.4499652 -93.4341349

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