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 = "Essex County, NJ"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, status14, shortname, pcity, pzip, hsa, hsaname, posbeds, sysname, ahabeds, category, teachstatus, hosptype, excl_flag, icu_flag, year, status15, 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
2947 2947 310002   9.OK? Newark Beth Israel Med Ctr NEWARK NJ 7112 31035 NJ- NEWARK 289 NJ- NEWARK 34013 Essex County, NJ 545 Barnabas Health 355.0 Independent Major Teaching 2.Other teaching hosp   9.OK?   2014.0         42.008717879518585 -87.80124263370072
2952 2952 310009   9.OK? Clara Maass Medical Center BELLEVILLE NJ 7109 31003 NJ- BELLEVILLE 289 NJ- NEWARK 34013 Essex County, NJ 396 Barnabas Health 469.0     4.Other acute care hosp   9.OK?   2014.0         42.25149727203065 -83.48634522988506
2982 2982 310054   9.OK? Hackensack UMC Mountainside MONTCLAIR NJ 7042 31030 NJ- MONTCLAIR 289 NJ- NEWARK 34013 Essex County, NJ 308 LHP Hospital Group 218.0     4.Other acute care hosp   9.OK?   2014.0         39.73454314285714 -104.90675928571429
2993 2993 310076   9.OK? St. Barnabas Medical Center LIVINGSTON NJ 7039 31026 NJ- LIVINGSTON 289 NJ- NEWARK 34013 Essex County, NJ 427 Barnabas Health 523.0 Independent Major Teaching 2.Other teaching hosp   9.OK?   2014.0         30.71791765113827 -83.71278490820121
2995 2995 310083   9.OK? East Orange General Hospital EAST ORANGE NJ 7018 31038 NJ- ORANGE 289 NJ- NEWARK 34013 Essex County, NJ 174   190.0     4.Other acute care hosp   9.OK?   2014.0         40.767323 -74.2048677
3000 3000 310096   9.OK? St. Michael's Medical Center NEWARK NJ 7102 31035 NJ- NEWARK 289 NJ- NEWARK 34013 Essex County, NJ 338 Trinity Health 147.0     4.Other acute care hosp   9.OK?   2014.0         42.00857773568986 -87.80123001411425
3008 3008 310119   9.OK? University Hospital -Newark NEWARK NJ 7103 31035 NJ- NEWARK 289 NJ- NEWARK 34013 Essex County, NJ 483   300.0     4.Other acute care hosp   9.OK?   2014.0         40.33892566666666 -82.46500056410257
3017 3017 312024   1.NonAcute Columbus Hospital LTACH NEWARK NJ 7107 31035 NJ- NEWARK 289 NJ- NEWARK 34013 Essex County, NJ 63         5.Longterm/non-acute   1.NonAcute noICUdays 2014.0         43.023314 -77.04327447325949
8096 8096 310002     Newark Beth Israel Med Ctr NEWARK NJ 7112 31035 NJ- NEWARK 289 NJ- NEWARK 34013 Essex County, NJ 545 RWJBarnabas Health 338.0 Independent Major Teaching 2.Other teaching hosp   9.OK?   2016.0 9.OK?       42.008717879518585 -87.80124263370072
8101 8101 310009     Clara Maass Medical Center BELLEVILLE NJ 7109 31003 NJ- BELLEVILLE 289 NJ- NEWARK 34013 Essex County, NJ 396 RWJBarnabas Health 469.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       42.25149727203065 -83.48634522988506
8131 8131 310054     Hackensack UMC Mountainside MONTCLAIR NJ 7042 31030 NJ- MONTCLAIR 289 NJ- NEWARK 34013 Essex County, NJ 308 LHP Hospital Group 218.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       39.73454314285714 -104.90675928571429
8142 8142 310076     St. Barnabas Medical Center LIVINGSTON NJ 7039 31026 NJ- LIVINGSTON 289 NJ- NEWARK 34013 Essex County, NJ 427 RWJBarnabas Health 545.0 Independent Major Teaching 2.Other teaching hosp   9.OK?   2016.0 9.OK?       30.71791765113827 -83.71278490820121
8144 8144 310083     East Orange General Hospital EAST ORANGE NJ 7018 31038 NJ- ORANGE 289 NJ- NEWARK 34013 Essex County, NJ 174   190.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       40.767323 -74.2048677
8149 8149 310096     St. Michael's Medical Center NEWARK NJ 7102 31035 NJ- NEWARK 289 NJ- NEWARK 34013 Essex County, NJ 338 Prime Healthcare Services 162.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       42.00857773568986 -87.80123001411425
8157 8157 310119     University Hospital -Newark NEWARK NJ 7103 31035 NJ- NEWARK 289 NJ- NEWARK 34013 Essex County, NJ 483   531.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       40.33892566666666 -82.46500056410257
8166 8166 312024     Columbus Hospital LTACH NEWARK NJ 7107 31035 NJ- NEWARK 289 NJ- NEWARK 34013 Essex County, NJ 63         5.Longterm/non-acute   1.NonAcute noICUdays 2016.0 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
);