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.

19 rows where ahabeds = "34.0" and year = "2016.0"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: pstate, posbeds, sysname, hosptype, excl_flag, icu_flag, status15

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
5221 5221 10091     Grove Hill Memorial Hospital GROVE HILL AL 36451 1045 AL- GROVE HILL 6 AL- MOBILE 1025 Clarke County, AL 41   34.0     4.Other acute care hosp   9.OK? noICUdays 2016.0 9.OK?       31.7087681 -87.7772218
5376 5376 32004     Cornerstone Hosp. of SouthEast AZ TUCSON AZ 85710 3032 AZ- TUCSON 15 AZ- TUCSON 4019 Pima County, AZ 34 Cornerstone Healthcare Group 34.0     5.Longterm/non-acute   1.NonAcute   2016.0 1.NonAcute       32.2228765 -110.974847
5455 5455 42006     Select Specialty Hosp-Fort Smith FORT SMITH AR 72901 4029 AR- FORT SMITH 16 AR- FORT SMITH 5131 Sebastian County, AR 34 Select Medical Corporation 34.0     5.Longterm/non-acute   1.NonAcute   2016.0 1.NonAcute       35.3880338 -94.4265011
5768 5768 51304     John C. Fremont Healthcare Dist MARIPOSA CA 95338 5138 CA- MERCED 58 CA- MODESTO 6043 Mariposa County, CA 34   34.0     3.Critical Access Hosp   9.OK? noICUdays 2016.0 9.OK?       37.4849377 -119.966284
5860 5860 60118     St. Anthony Summit Med Ctr FRISCO CO 80443 6016 CO- DENVER 103 CO- DENVER 8117 Summit County, CO 35 Catholic Health Initiatives 34.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       39.5744299 -106.0975196
6341 6341 130066     Northwest Specialty Hospital POST FALLS ID 83854 13009 ID- COEUR D'ALENE 440 WA- SPOKANE 16055 Kootenai County, ID 34 National Surgical Healthcare 34.0     4.Other acute care hosp   9.OK? noICUdays 2016.0 9.OK?       47.7110106 -116.9480877
6937 6937 171374     Fredonia Regional Hospital FREDONIA KS 66736 17032 KS- FREDONIA 201 KS- WICHITA 20205 Wilson County, KS 16 Great Plains Health Alliance, Inc. 34.0     3.Critical Access Hosp   9.OK? noICUdays 2016.0 9.OK?       37.5339386 -95.8266483
7146 7146 190313     New Orleans East Hospital NEW ORLEANS LA 70127 19066 LA- NEW ORLEANS 218 LA- NEW ORLEANS 22071 Orleans Parish, LA 80 LCMC Health 34.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       29.9759983 -90.0782127
7726 7726 251325     Covington County Hospital COLLINS MS 39428 25033 MS- HATTIESBURG 258 MS- HATTIESBURG 28031 Covington County, MS 25   34.0     3.Critical Access Hosp   9.OK? noICUdays 2016.0 9.OK?       31.6457944 -89.5553297
7864 7864 262014     Select Specialty Hosp-Western MO KANSAS CITY MO 64132 26041 MO- KANSAS CITY 268 MO- KANSAS CITY 29095 Jackson County, MO 34 Select Medical Corporation 34.0     5.Longterm/non-acute   1.NonAcute noICUdays 2016.0 1.NonAcute       39.100105 -94.5781416
7956 7956 280133     Nebraska Spine Hospital, LLC OMAHA NE 68122 28056 NE- OMAHA 278 NE- OMAHA 31055 Douglas County, NE 34   34.0     4.Other acute care hosp   9.OK? noICUdays 2016.0 9.OK?       41.2587459 -95.9383758
8385 8385 331319     Medina Memorial Hospital MEDINA NY 14103 33073 NY- MEDINA 299 NY- BUFFALO 36073 Orleans County, NY 25   34.0     3.Critical Access Hosp   9.OK?   2016.0 9.OK?       43.2202828 -78.3866445
8500 8500 342017     Asheville Specialty Hospital ASHEVILLE NC 28802 34005 NC- ASHEVILLE 309 NC- ASHEVILLE 37021 Buncombe County, NC 34 Mission Health System 34.0     5.Longterm/non-acute   1.NonAcute noICUdays 2016.0 1.NonAcute       35.595363 -82.5508407
8803 8803 370178     Memorial Hospital-Stilwell STILWELL OK 74960 37101 OK- STILWELL 340 OK- TULSA 40001 Adair County, OK 40   34.0     4.Other acute care hosp   9.OK? noICUdays 2016.0 9.OK?       35.814431 -94.6286156
8873 8873 372019     Solara Hospital of Shawnee SHAWNEE OK 74801 37080 OK- SHAWNEE 339 OK- OKLAHOMA CITY 40125 Pottawatomie County, OK 34 Cornerstone Healthcare Group 34.0     5.Longterm/non-acute   1.NonAcute   2016.0 1.NonAcute       35.3272928 -96.9253004
9370 9370 441319     Cumberland River Hospital CELINA TN 38551 44007 TN- CELINA 380 TN- NASHVILLE 47027 Clay County, TN 28   34.0     3.Critical Access Hosp   9.OK? noICUdays 2016.0 9.OK?       36.5500611 -85.505247
9623 9623 450872     USMD Hospital at Arlington ARLINGTON TX 76017 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 Tarrant County, TX 34 USMD Health System 34.0     4.Other acute care hosp   9.OK?   2016.0 9.OK?       32.7355816 -97.1071186
9748 9748 452062     Warm Springs Specialty Hosp -Luling LULING TX 78648 45170 TX- LULING 385 TX- AUSTIN 48055 Caldwell County, TX 34 Post Acute Medical, LLC 34.0     5.Longterm/non-acute   1.NonAcute   2016.0 1.NonAcute       29.680314 -97.6473265
10211 10211 522006     Select Specialty Hospital-Milwaukee WEST ALLIS WI 53227 52103 WI- WEST ALLIS 451 WI- MILWAUKEE 55079 Milwaukee County, WI 63 Select Medical Corporation 34.0     5.Longterm/non-acute   1.NonAcute noICUdays 2016.0 1.NonAcute       43.0166806 -88.0070315

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