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.

14 rows where fcntyname = "Bucks County, PA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, status14, shortname, pcity, pzip, hsa, hsaname, hrr, hrrname, posbeds, sysname, ahabeds, 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
3812 3812 390035   9.OK? St. Luke's Quakertown Hospital QUAKERTOWN PA 18951 39102 PA- QUAKERTOWN 346 PA- ALLENTOWN 42017 Bucks County, PA 33 Luke's University Health Network 57.0     4.Other acute care hosp   9.OK?   2014.0         40.4417682 -75.3415667
3827 3827 390057   9.OK? Grand View Hospital SELLERSVILLE PA 18960 39110 PA- SELLERSVILLE 346 PA- ALLENTOWN 42017 Bucks County, PA 175   202.0     4.Other acute care hosp   9.OK?   2014.0         40.3542858 -75.3050079
3836 3836 390070   9.OK? Lower Bucks Hospital BRISTOL PA 19007 39012 PA- BRISTOL 356 PA- PHILADELPHIA 42017 Bucks County, PA 112 Prime Healthcare Services 150.0     4.Other acute care hosp   9.OK?   2014.0         40.122900200000004 -74.86447057681232
3907 3907 390203   9.OK? Doylestown Hospital DOYLESTOWN PA 18901 39033 PA- DOYLESTOWN 356 PA- PHILADELPHIA 42017 Bucks County, PA 115   232.0     4.Other acute care hosp   9.OK?   2014.0         40.3100446 -75.1304588
3923 3923 390258   9.OK? St. Mary Medical Center LANGHORNE PA 19047 39064 PA- LANGHORNE 356 PA- PHILADELPHIA 42017 Bucks County, PA 256 Trinity Health 323.0     4.Other acute care hosp   9.OK?   2014.0         40.1745538 -74.9226665
3931 3931 390302   9.OK? Barix Clinics Of Pennsylvania LANGHORNE PA 19047 39064 PA- LANGHORNE 356 PA- PHILADELPHIA 42017 Bucks County, PA 47         4.Other acute care hosp   9.OK? noICUdays 2014.0         40.1745538 -74.9226665
3938 3938 390322   9.OK? Rothman Specialty Hospital BENSALEM PA 19020 39095 PA- PHILADELPHIA 356 PA- PHILADELPHIA 42017 Bucks County, PA 24   24.0     4.Other acute care hosp   9.OK? noICUdays 2014.0         40.1045549 -74.951279
8954 8954 390035     St. Luke's Quakertown Hospital QUAKERTOWN PA 18951 39102 PA- QUAKERTOWN 346 PA- ALLENTOWN 42017 Bucks County, PA 33 Luke's University Health Network 57.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       40.4417682 -75.3415667
8969 8969 390057     Grand View Hospital SELLERSVILLE PA 18960 39110 PA- SELLERSVILLE 346 PA- ALLENTOWN 42017 Bucks County, PA 175   194.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       40.3542858 -75.3050079
8978 8978 390070     Lower Bucks Hospital BRISTOL PA 19007 39012 PA- BRISTOL 356 PA- PHILADELPHIA 42017 Bucks County, PA 112 Prime Healthcare Services 104.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       40.122900200000004 -74.86447057681232
9048 9048 390203     Doylestown Hospital DOYLESTOWN PA 18901 39033 PA- DOYLESTOWN 356 PA- PHILADELPHIA 42017 Bucks County, PA 115   232.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       40.3100446 -75.1304588
9064 9064 390258     St. Mary Medical Center LANGHORNE PA 19047 39064 PA- LANGHORNE 356 PA- PHILADELPHIA 42017 Bucks County, PA 256 Trinity Health 307.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       40.1745538 -74.9226665
9072 9072 390302     Barix Clinics Of Pennsylvania LANGHORNE PA 19047 39064 PA- LANGHORNE 356 PA- PHILADELPHIA 42017 Bucks County, PA 47         4.Other acute care hosp   9.OK? noICUdays 2016.0 9.OK?       40.1745538 -74.9226665
9079 9079 390322     Rothman Specialty Hospital BENSALEM PA 19020 39095 PA- PHILADELPHIA 356 PA- PHILADELPHIA 42017 Bucks County, PA 24   24.0     4.Other acute care hosp   9.OK? noICUdays 2016.0 9.OK?       40.1045549 -74.951279

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