Hospital Atlas Data
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"
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
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 );