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.

4 rows where hrrname = "IA- DES MOINES" and shortname = "Davis County Hospital"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: new_prov, status14, fcntyname, ahabeds, status15, status16, pname, status17

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
1588 1588 161327   9.OK? Davis County Hospital BLOOMFIELD IA 52537 16008 IA- BLOOMFIELD 192 IA- DES MOINES 19051 Davis County, IA 25   25.0     3.Critical Access Hosp   9.OK? noICUdays 2014.0         40.7510398 -92.4143872
6753 6753 161327     Davis County Hospital BLOOMFIELD IA 52537 16008 IA- BLOOMFIELD 192 IA- DES MOINES 19051 Davis County, IA 25   25.0     3.Critical Access Hosp   9.OK? noICUdays 2016.0 9.OK?       40.7510398 -92.4143872
11877 11877 161327 161327   Davis County Hospital BLOOMFIELD IA 52537 16008 IA- BLOOMFIELD 192 IA- DES MOINES 19051 IA-Davis County 25   13.0     3.Critical Access Hosp   9.OK? noICUdays     9.OK? DAVIS COUNTY HOSPITAL   40.7510398 -92.4143872
16984 16984 161327 161327   Davis County Hospital BLOOMFIELD IA 52537 16008 IA- BLOOMFIELD 192 IA- DES MOINES 19051 IA-Davis County 25   13.0     3.Critical Access Hosp   9.OK? noICUdays 2017.0     DAVIS COUNTY HOSPITAL 9.OK? 40.7510398 -92.4143872

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