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.

16 rows where fcntyname = "NJ-Essex County"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, new_prov, shortname, pcity, pzip, hsa, hsaname, posbeds, sysname, ahabeds, category, teachstatus, 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
13211 13211 310002 310002   Newark Beth Israel Med Ctr NEWARK NJ 7112 31035 NJ- NEWARK 289 NJ- NEWARK 34013 NJ-Essex County 545     Independent Major Teaching 2.Other teaching hosp   9.OK?       9.OK? NEWARK BETH ISRAEL MEDICAL CENTER   42.008717879518585 -87.80124263370072
13216 13216 310009 310009   Clara Maass Medical Center BELLEVILLE NJ 7109 31003 NJ- BELLEVILLE 289 NJ- NEWARK 34013 NJ-Essex County 396 RWJBarnabas Health 469.0     4.Other acute care hosp   9.OK?       9.OK? CLARA MAASS MEDICAL CENTER   42.25149727203065 -83.48634522988506
13246 13246 310054 310054   Hackensack Umc Mountainside MONTCLAIR NJ 7042 31030 NJ- MONTCLAIR 289 NJ- NEWARK 34013 NJ-Essex County 308 Ardent Health Services 202.0     4.Other acute care hosp   9.OK?       9.OK? HACKENSACK-UMC MOUNTAINSIDE   39.73454314285714 -104.90675928571429
13257 13257 310076 310076   St. Barnabas Medical Center LIVINGSTON NJ 7039 31026 NJ- LIVINGSTON 289 NJ- NEWARK 34013 NJ-Essex County 427     Independent Major Teaching 2.Other teaching hosp   9.OK?       9.OK? SAINT BARNABAS MEDICAL CENTER   30.71791765113827 -83.71278490820121
13259 13259 310083 310083   East Orange General Hospital EAST ORANGE NJ 7018 31038 NJ- ORANGE 289 NJ- NEWARK 34013 NJ-Essex County 174 Prospect Medical Holdings 190.0     4.Other acute care hosp   9.OK?       9.OK? EAST ORANGE GENERAL HOSPITAL   40.767323 -74.2048677
13264 13264 310096 310096   St. Michael's Medical Center NEWARK NJ 7102 31035 NJ- NEWARK 289 NJ- NEWARK 34013 NJ-Essex County 338 Prime Healthcare Services 162.0     4.Other acute care hosp   9.OK?       9.OK? SAINT MICHAEL'S MEDICAL CENTER   42.00857773568986 -87.80123001411425
13272 13272 310119 310119   University Hospital -Newark NEWARK NJ 7101 31035 NJ- NEWARK 289 NJ- NEWARK 34013 NJ-Essex County 483   519.0     4.Other acute care hosp   9.OK?       9.OK? UNIVERSITY HOSPITAL   38.2495 -75.29517
13281 13281 312024 312024   Columbus Hospital Ltach NEWARK NJ 7107 31035 NJ- NEWARK 289 NJ- NEWARK 34013 NJ-Essex County 63         5.Longterm/non-acute   1.NonAcute noICUdays     1.NonAcute COLUMBUS HOSPITAL LTACH   43.023314 -77.04327447325949
18301 18301 310002 310002   Newark Beth Israel Med Ctr NEWARK NJ 7112 31035 NJ- NEWARK 289 NJ- NEWARK 34013 NJ-Essex County 545 RWJBarnabas Health 333.0 Independent Major Teaching 2.Other teaching hosp   9.OK?   2017.0     NEWARK BETH ISRAEL MEDICAL CENTER 9.OK? 42.008717879518585 -87.80124263370072
18306 18306 310009 310009   Clara Maass Medical Center BELLEVILLE NJ 7109 31003 NJ- BELLEVILLE 289 NJ- NEWARK 34013 NJ-Essex County 374 RWJBarnabas Health 364.0     4.Other acute care hosp   9.OK?   2017.0     CLARA MAASS MEDICAL CENTER 9.OK? 42.25149727203065 -83.48634522988506
18336 18336 310054 310054   Hackensack Umc Mountainside MONTCLAIR NJ 7042 31030 NJ- MONTCLAIR 289 NJ- NEWARK 34013 NJ-Essex County 308 Ardent Health Services 202.0     4.Other acute care hosp   9.OK?   2017.0     HACKENSACK-UMC MOUNTAINSIDE 9.OK? 39.73454314285714 -104.90675928571429
18347 18347 310076 310076   St. Barnabas Medical Center LIVINGSTON NJ 7039 31026 NJ- LIVINGSTON 289 NJ- NEWARK 34013 NJ-Essex County 427 RWJBarnabas Health 553.0 Independent Major Teaching 2.Other teaching hosp   9.OK?   2017.0     SAINT BARNABAS MEDICAL CENTER 9.OK? 30.71791765113827 -83.71278490820121
18349 18349 310083 310083   East Orange General Hospital EAST ORANGE NJ 7018 31038 NJ- ORANGE 289 NJ- NEWARK 34013 NJ-Essex County 174 Prospect Medical Holdings 186.0     4.Other acute care hosp   9.OK?   2017.0     EAST ORANGE GENERAL HOSPITAL 9.OK? 40.767323 -74.2048677
18354 18354 310096 310096   St. Michael's Medical Center NEWARK NJ 7102 31035 NJ- NEWARK 289 NJ- NEWARK 34013 NJ-Essex County 338 Prime Healthcare Services 162.0     4.Other acute care hosp   9.OK?   2017.0     SAINT MICHAEL'S MEDICAL CENTER 9.OK? 42.00857773568986 -87.80123001411425
18362 18362 310119 310119   University Hospital -Newark NEWARK NJ 7101 31035 NJ- NEWARK 289 NJ- NEWARK 34013 NJ-Essex County 483   519.0     4.Other acute care hosp   9.OK?   2017.0     UNIVERSITY HOSPITAL 9.OK? 38.2495 -75.29517
18371 18371 312024 312024   Columbus Hospital Ltach NEWARK NJ 7107 31035 NJ- NEWARK 289 NJ- NEWARK 34013 NJ-Essex County 63   63.0     5.Longterm/non-acute   1.NonAcute noICUdays 2017.0     COLUMBUS HOSPITAL LTACH 1.NonAcute 43.023314 -77.04327447325949

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