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.

10 rows where fcntyname = "Shasta County, CA"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, status14, shortname, pcity, pzip, hsa, hsaname, posbeds, sysname, ahabeds, 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
419 419 50280   9.OK? Mercy Med Ctr-Redding REDDING CA 96001 5191 CA- REDDING 73 CA- REDDING 6089 Shasta County, CA 267 Dignity Health 267.0     4.Other acute care hosp   9.OK?   2014.0         40.5863563 -122.391675
549 549 50697   9.OK? Patients' Hospital of Redding REDDING CA 96001 5191 CA- REDDING 73 CA- REDDING 6089 Shasta County, CA 10   10.0     4.Other acute care hosp   9.OK? noICUdays 2014.0         40.5863563 -122.391675
582 582 50764   9.OK? Shasta Regional Medical Center REDDING CA 96001 5191 CA- REDDING 73 CA- REDDING 6089 Shasta County, CA 189 Prime Healthcare Services 120.0     4.Other acute care hosp   9.OK?   2014.0         40.5863563 -122.391675
599 599 51305   9.OK? Mayers Memorial Hosp District FALL RIVER MILLS CA 96028 5069 CA- FALL RIVER MILLS 73 CA- REDDING 6089 Shasta County, CA 22   10.0     3.Critical Access Hosp   9.OK? noICUdays 2014.0         41.0046076 -121.4383139
641 641 52047   1.NonAcute Vibra Hospital of Northern Calif. REDDING CA 96001 5191 CA- REDDING 73 CA- REDDING 6089 Shasta County, CA 56 Vibra Healthcare 56.0     5.Longterm/non-acute   1.NonAcute   2014.0         40.5863563 -122.391675
5589 5589 50280     Mercy Med Ctr-Redding REDDING CA 96001 5191 CA- REDDING 73 CA- REDDING 6089 Shasta County, CA 267 Dignity Health 267.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       40.5863563 -122.391675
5715 5715 50697     Patients' Hospital of Redding REDDING CA 96001 5191 CA- REDDING 73 CA- REDDING 6089 Shasta County, CA 10   10.0     4.Other acute care hosp   9.OK? noICUdays 2016.0 9.OK?       40.5863563 -122.391675
5748 5748 50764     Shasta Regional Medical Center REDDING CA 96001 5191 CA- REDDING 73 CA- REDDING 6089 Shasta County, CA 191 Prime Healthcare Services 113.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       40.5863563 -122.391675
5769 5769 51305     Mayers Memorial Hosp District FALL RIVER MILLS CA 96028 5069 CA- FALL RIVER MILLS 73 CA- REDDING 6089 Shasta County, CA 22   10.0     3.Critical Access Hosp   9.OK? noICUdays 2016.0 9.OK?       41.0046076 -121.4383139
5811 5811 52047     Vibra Hospital of Northern Calif. REDDING CA 96001 5191 CA- REDDING 73 CA- REDDING 6089 Shasta County, CA 56 Vibra Healthcare 56.0     5.Longterm/non-acute   1.NonAcute   2016.0 1.NonAcute       40.5863563 -122.391675

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