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 = "FL-Lee County"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, new_prov, shortname, pcity, pzip, hsa, hsaname, posbeds, sysname, ahabeds, hosptype, excl_flag, year, status16, pname, status17, 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
11083 11083 100012 100012   Lee Memorial Hospital FORT MYERS FL 33901 10037 FL- FORT MYERS 119 FL- FORT MYERS 12071 FL-Lee County 708 Lee Health 779.0     4.Other acute care hosp   9.OK?       9.OK? LEE MEMORIAL HOSPITAL   26.640628 -81.8723084
11140 11140 100107 100107   Lehigh Regional Medical Center LEHIGH ACRES FL 33936 10064 FL- LEHIGH ACRES 119 FL- FORT MYERS 12071 FL-Lee County 88 Prime Healthcare Services 88.0     4.Other acute care hosp   9.OK?       9.OK? LEHIGH REGIONAL MEDICAL CENTER   26.6091509 -81.652407
11189 11189 100220 100220   Gulf Coast Med Ctr-Fort Myers FORT MYERS FL 33912 10037 FL- FORT MYERS 119 FL- FORT MYERS 12071 FL-Lee County 349 Lee Health 356.0     4.Other acute care hosp   9.OK?       9.OK? GULF COAST MEDICAL CENTER LEE MEM HEALTH SYSTEM   26.640628 -81.8723084
11203 11203 100244 100244   Cape Coral Hospital CAPE CORAL FL 33990 10016 FL- CAPE CORAL 119 FL- FORT MYERS 12071 FL-Lee County 291 Lee Health 291.0     4.Other acute care hosp   9.OK?       9.OK? CAPE CORAL HOSPITAL   26.5625742 -81.9438802
11283 11283 102029 102029   Promise Hospital Of Fort Myers FORT MYERS FL 33905 10037 FL- FORT MYERS 119 FL- FORT MYERS 12071 FL-Lee County 60 Promise Healthcare 60.0     5.Longterm/non-acute   1.NonAcute       1.NonAcute PROMISE HOSPITAL OF FORT MYERS   26.640628 -81.8723084
16195 16195 100012 100012   Lee Memorial Hospital FORT MYERS FL 33901 10037 FL- FORT MYERS 119 FL- FORT MYERS 12071 FL-Lee County 708 Lee Health 812.0     4.Other acute care hosp   9.OK?   2017.0     LEE MEMORIAL HOSPITAL 9.OK? 26.640628 -81.8723084
16252 16252 100107 100107   Lehigh Regional Medical Center LEHIGH ACRES FL 33936 10064 FL- LEHIGH ACRES 119 FL- FORT MYERS 12071 FL-Lee County 88 Prime Healthcare Services 88.0     4.Other acute care hosp   9.OK?   2017.0     LEHIGH REGIONAL MEDICAL CENTER 9.OK? 26.6091509 -81.652407
16301 16301 100220 100220   Gulf Coast Med Ctr-Fort Myers FORT MYERS FL 33912 10037 FL- FORT MYERS 119 FL- FORT MYERS 12071 FL-Lee County 349 Lee Health 349.0     4.Other acute care hosp   9.OK?   2017.0     GULF COAST MEDICAL CENTER LEE MEM HEALTH SYSTEM 9.OK? 26.640628 -81.8723084
16314 16314 100244 100244   Cape Coral Hospital CAPE CORAL FL 33990 10016 FL- CAPE CORAL 119 FL- FORT MYERS 12071 FL-Lee County 291 Lee Health 291.0     4.Other acute care hosp   9.OK?   2017.0     CAPE CORAL HOSPITAL 9.OK? 26.5625742 -81.9438802
16393 16393 102029 102029   Promise Hospital Of Fort Myers FORT MYERS FL 33905 10037 FL- FORT MYERS 119 FL- FORT MYERS 12071 FL-Lee County 60 Promise Healthcare 60.0     5.Longterm/non-acute   1.NonAcute   2017.0     PROMISE HOSPITAL OF FORT MYERS 1.NonAcute 26.640628 -81.8723084

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