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.

20 rows where fcntyname = "LA-St. Tammany Parish"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, new_prov, shortname, pcity, pzip, hsa, hsaname, hrr, hrrname, 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
12196 12196 190040 190040   Slidell Memorial Hospital SLIDELL LA 70458 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 199 Ochsner Health System 175.0     4.Other acute care hosp   9.OK?       9.OK? SLIDELL MEMORIAL HOSPITAL   30.2751945 -89.7811745
12199 12199 190045 190045   St. Tammany Parish Hospital COVINGTON LA 70433 19018 LA- COVINGTON 216 LA- METAIRIE 22103 LA-St. Tammany Parish 218   218.0     4.Other acute care hosp   9.OK?       9.OK? ST TAMMANY PARISH HOSPITAL   30.4753525 -90.1010474
12232 12232 190177 190177   Lakeview Regional Medical Center COVINGTON LA 70433 19018 LA- COVINGTON 216 LA- METAIRIE 22103 LA-St. Tammany Parish 143         4.Other acute care hosp   9.OK?       9.OK? LAKEVIEW REGIONAL MEDICAL CENTER   30.4753525 -90.1010474
12239 12239 190204 190204   Ochsner Med Ctr-North Shore SLIDELL LA 70461 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 150 Ochsner Health System 165.0     4.Other acute care hosp   9.OK?       9.OK? OCHSNER MEDICAL CENTER - NORTHSHORE, L L C   30.2751945 -89.7811745
12248 12248 190250 190250   Louisiana Heart Hosp LACOMBE LA 70445 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 134         4.Other acute care hosp   9.OK?       9.OK? LOUISIANA HEART HOSPITAL   30.3135288 -89.9431264
12251 12251 190256 190256   Sterling Surgical Hospital SLIDELL LA 70458 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 10   10.0     4.Other acute care hosp   9.OK? noICUdays     9.OK? STERLING SURGICAL HOSPITAL   30.2751945 -89.7811745
12255 12255 190267 190267   Fairway Medical Surgical Hospital COVINGTON LA 70433 19018 LA- COVINGTON 216 LA- METAIRIE 22103 LA-St. Tammany Parish 21   21.0     4.Other acute care hosp   9.OK? noICUdays     9.OK? FAIRWAY MEDICAL CENTER   30.4753525 -90.1010474
12257 12257 190270 190270   Southern Surgical Hospital SLIDELL LA 70458 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 37   37.0     4.Other acute care hosp   9.OK?       9.OK? SOUTHERN SURGICAL HOSPITAL   30.2751945 -89.7811745
12323 12323 192046 Closed   Amg Specialty Hospital-Slidell SLIDELL LA 70458 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 40         5.Longterm/non-acute   1.NonAcute noICUdays     1.NonAcute SLIDELL - A M G SPECIALTY HOSPITAL   30.2751945 -89.7811745
12324 12324 192048 192048   Post Acute Northshore Specialty Hos COVINGTON LA 70433 19018 LA- COVINGTON 216 LA- METAIRIE 22103 LA-St. Tammany Parish 58 Post Acute Medical, LLC 58.0     5.Longterm/non-acute   1.NonAcute       1.NonAcute P A M SPECIALTY HOSPITAL OF COVINGTON   30.4753525 -90.1010474
12326 12326 192051 192051   Regency Hospital Of Covington COVINGTON LA 70433 19018 LA- COVINGTON 216 LA- METAIRIE 22103 LA-St. Tammany Parish 38         5.Longterm/non-acute   1.NonAcute       1.NonAcute COVINGTON - A M G SPECIALTY HOSPITAL   30.4753525 -90.1010474
17300 17300 190040 190040   Slidell Memorial Hospital SLIDELL LA 70458 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 199 Ochsner Health System 175.0     4.Other acute care hosp   9.OK?   2017.0     SLIDELL MEMORIAL HOSPITAL 9.OK? 30.2751945 -89.7811745
17303 17303 190045 190045   St. Tammany Parish Hospital COVINGTON LA 70433 19018 LA- COVINGTON 216 LA- METAIRIE 22103 LA-St. Tammany Parish 218   218.0     4.Other acute care hosp   9.OK?   2017.0     ST TAMMANY PARISH HOSPITAL 9.OK? 30.4753525 -90.1010474
17336 17336 190177 190176   Lakeview Regional Medical Center COVINGTON LA 70433 19018 LA- COVINGTON 216 LA- METAIRIE 22103 LA-St. Tammany Parish 143         4.Other acute care hosp   6.Transit.<=2017 noICUdays 2017.0     LAKEVIEW REGIONAL MEDICAL CENTER 6.Switch 30.4753525 -90.1010474
17343 17343 190204 190204   Ochsner Med Ctr-North Shore SLIDELL LA 70461 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 150 Ochsner Health System 168.0     4.Other acute care hosp   9.OK?   2017.0     OCHSNER MEDICAL CENTER - NORTHSHORE, L L C 9.OK? 30.2751945 -89.7811745
17352 17352 190250 Closed   Louisiana Heart Hosp LACOMBE LA 70445 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 134         4.Other acute care hosp   5.Closed   2017.0     LOUISIANA HEART HOSPITAL 5.Closed 30.3135288 -89.9431264
17355 17355 190256 190256   Sterling Surgical Hospital SLIDELL LA 70458 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 10   10.0     4.Other acute care hosp   9.OK? noICUdays 2017.0     STERLING SURGICAL HOSPITAL 9.OK? 30.2751945 -89.7811745
17359 17359 190267 190267   Fairway Medical Surgical Hospital COVINGTON LA 70433 19018 LA- COVINGTON 216 LA- METAIRIE 22103 LA-St. Tammany Parish 21   21.0     4.Other acute care hosp   9.OK? noICUdays 2017.0     AVALA 9.OK? 30.4753525 -90.1010474
17361 17361 190270 190270   Southern Surgical Hospital SLIDELL LA 70458 19081 LA- SLIDELL 220 LA- SLIDELL 22103 LA-St. Tammany Parish 37   37.0     4.Other acute care hosp   9.OK?   2017.0     SOUTHERN SURGICAL HOSPITAL 9.OK? 30.2751945 -89.7811745
17426 17426 192048 192048   Post Acute Northshore Specialty Hos COVINGTON LA 70433 19018 LA- COVINGTON 216 LA- METAIRIE 22103 LA-St. Tammany Parish 58 Post Acute Medical, LLC 58.0     5.Longterm/non-acute   1.NonAcute   2017.0     P A M SPECIALTY HOSPITAL OF COVINGTON 1.NonAcute 30.4753525 -90.1010474

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