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.

12 rows where fcntyname = "NJ-Middlesex 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, nci_center, 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
13217 13217 310010 310010   Univ Med Ctr Princeton - Plainsboro PLAINSBORO NJ 8536 31047 NJ- PRINCETON 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 262   355.0     4.Other acute care hosp   9.OK?       9.OK? UNIV MEDICAL CENTER OF PRINCETON AT PLAINSBORO   40.3334409 -74.6004341
13235 13235 310038 310038   Rwj University Hosp-New Brunswick NEW BRUNSWICK NJ 8901 31034 NJ- NEW BRUNSWICK 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 610     Integrated Major Teaching 1.Integrated AMC 1.NCI-CCC 9.OK?       9.OK? ROBERT WOOD JOHNSON UNIVERSITY HOSPITAL   40.4862174 -74.4518173
13236 13236 310039 310039   Raritan Bay Medical Center PERTH AMBOY NJ 8861 31042 NJ- PERTH AMBOY 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 500 Hackensack Meridian Health 282.0     4.Other acute care hosp   9.OK?       9.OK? RARITAN BAY MEDICAL CENTER PERTH AMBOY DIVISION   40.5200187 -74.2745215
13253 13253 310070 310070   St. Peter's University Hosp NEW BRUNSWICK NJ 8901 31034 NJ- NEW BRUNSWICK 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 416   350.0 Independent Major Teaching 2.Other teaching hosp   9.OK?       9.OK? SAINT PETER'S UNIVERSITY HOSPITAL   40.4862174 -74.4518173
13265 13265 310108 310108   Jfk Medical Center EDISON NJ 8818 31010 NJ- EDISON 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 457 JFK Health 345.0     4.Other acute care hosp   9.OK?       9.OK? JFK MEDICAL CTR - ANTHONY M. YELENCSICS COMMUNITY   38.76166053061225 -76.85469732653061
13276 13276 312018 312018   Care One At Raritan Bay Medical Ctr PERTH AMBOY NJ 8861 31042 NJ- PERTH AMBOY 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 51   30.0     5.Longterm/non-acute   1.NonAcute noICUdays     1.NonAcute CARE ONE AT RARITAN BAY MEDICAL CENTER, LLC   40.5200187 -74.2745215
18307 18307 310010 310010   Univ Med Ctr Princeton - Plainsboro PLAINSBORO NJ 8536 31047 NJ- PRINCETON 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 262 University of Pennsylvania Health System 355.0     4.Other acute care hosp   9.OK?   2017.0     PENN MEDICINE PRINCETON MEDICAL CENTER 9.OK? 40.3334409 -74.6004341
18325 18325 310038 310038   Rwj University Hosp-New Brunswick NEW BRUNSWICK NJ 8901 31034 NJ- NEW BRUNSWICK 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 610 RWJBarnabas Health 610.0 Integrated Major Teaching 1.Integrated AMC 1.NCI-CCC 9.OK?   2017.0     ROBERT WOOD JOHNSON UNIVERSITY HOSPITAL 9.OK? 40.4862174 -74.4518173
18326 18326 310039 310039   Raritan Bay Medical Center PERTH AMBOY NJ 8861 31042 NJ- PERTH AMBOY 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 500 Hackensack Meridian Health 282.0     4.Other acute care hosp   9.OK?   2017.0     RARITAN BAY MEDICAL CENTER PERTH AMBOY DIVISION 9.OK? 40.5200187 -74.2745215
18343 18343 310070 310070   St. Peter's University Hosp NEW BRUNSWICK NJ 8901 31034 NJ- NEW BRUNSWICK 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 416   361.0 Independent Major Teaching 2.Other teaching hosp   9.OK?   2017.0     SAINT PETER'S UNIVERSITY HOSPITAL 9.OK? 40.4862174 -74.4518173
18355 18355 310108 310108   Jfk Medical Center EDISON NJ 8818 31010 NJ- EDISON 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 457 JFK Health 388.0     4.Other acute care hosp   9.OK?   2017.0     JFK MEDICAL CTR - ANTHONY M. YELENCSICS COMMUNITY 9.OK? 38.76166053061225 -76.85469732653061
18366 18366 312018 312018   Care One At Raritan Bay Medical Ctr PERTH AMBOY NJ 8861 31042 NJ- PERTH AMBOY 288 NJ- NEW BRUNSWICK 34023 NJ-Middlesex County 51   30.0     5.Longterm/non-acute   1.NonAcute noICUdays 2017.0     CARE ONE AT RARITAN BAY MEDICAL CENTER, LLC 1.NonAcute 40.5200187 -74.2745215

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