home / us_physician_referral_networks

Menu
  • Dashboards

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.

2 rows where hosptype = "5.Longterm/non-acute" and shortname = "Vibra Hospital of Western Mass"

✎ View and edit SQL

This data as json, CSV (advanced)

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
2210 2210 222046   1.NonAcute Vibra Hospital of Western Mass SPRINGFIELD MA 1109 22058 MA- SPRINGFIELD 230 MA- SPRINGFIELD 25013 Hampden County, MA 174 Vibra Healthcare 202.0     5.Longterm/non-acute   1.NonAcute noICUdays 2014.0         30.16823655 -85.61518249247474
7362 7362 222046     Vibra Hospital of Western Mass SPRINGFIELD MA 1109 22058 MA- SPRINGFIELD 230 MA- SPRINGFIELD 25013 Hampden County, MA 174 Vibra Healthcare 127.0     5.Longterm/non-acute   1.NonAcute noICUdays 2016.0 1.NonAcute       30.16823655 -85.61518249247474

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
);
Powered by Datasette · Queries took 612.155ms · Data license: Please contact the data provider for more information. · Data source: U.S. Census, Dartmouth Atlas of Health Care, NCQA, AIDOS Lab.