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.

12 rows where fcntyname = "TX-Tarrant County" and pcity = "ARLINGTON"

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: provider, new_prov, shortname, pzip, posbeds, sysname, ahabeds, hosptype, excl_flag, icu_flag, year, 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
14520 14520 450064 450064   Texas Health Arlington Mem Hosp ARLINGTON TX 76012 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 334 Texas Health Resources 242.0     4.Other acute care hosp   9.OK?       9.OK? TEXAS HEALTH ARLINGTON MEMORIAL HOSPITAL   32.7355816 -97.1071186
14669 14669 450675 450675   Medical Center Of Arlington ARLINGTON TX 76015 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 258 HCA Healthcare 289.0     4.Other acute care hosp   9.OK?       9.OK? MEDICAL CITY ARLINGTON   32.7355816 -97.1071186
14731 14731 450872 450872   Usmd Hospital At Arlington ARLINGTON TX 76017 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 34 USMD Health System 34.0     4.Other acute care hosp   9.OK?       9.OK? USMD HOSPITAL AT ARLINGTON L P   32.7355816 -97.1071186
14833 14833 452028 452028   Kindred Hosp Tarrant Cnty-Arlington ARLINGTON TX 76011 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 80 Kindred Healthcare 55.0     5.Longterm/non-acute   1.NonAcute       1.NonAcute KINDRED HOSPITAL-TARRANT COUNTY   32.7355816 -97.1071186
15375 15375 670067 670067   Baylor Ortho & Spine Hospital ARLINGTON TX 76015 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 24   20.0     4.Other acute care hosp   9.OK? noICUdays     9.OK? BAYLOR ORTHOPEDIC AND SPINE HOSPITAL AT ARLINGTON   32.7355816 -97.1071186
15378 15378 670071 670071   Texas Health Heart & Vascular Hosp ARLINGTON TX 76012 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 48   32.0     4.Other acute care hosp   9.OK?       9.OK? TEXAS HEALTH HEART & VASCULAR HOSPITAL ARLINGTON   32.7355816 -97.1071186
19590 19590 450064 450064   Texas Health Arlington Mem Hosp ARLINGTON TX 76012 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 334 Texas Health Resources 269.0     4.Other acute care hosp   9.OK?   2017.0     TEXAS HEALTH ARLINGTON MEMORIAL HOSPITAL 9.OK? 32.7355816 -97.1071186
19736 19736 450675 450675   Medical Center Of Arlington ARLINGTON TX 76015 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 272 HCA Healthcare 309.0     4.Other acute care hosp   9.OK?   2017.0     MEDICAL CITY ARLINGTON 9.OK? 32.7355816 -97.1071186
19798 19798 450872 450872   Usmd Hospital At Arlington ARLINGTON TX 76017 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 34 USMD Health System 34.0     4.Other acute care hosp   9.OK?   2017.0     USMD HOSPITAL AT ARLINGTON L P 9.OK? 32.7355816 -97.1071186
19903 19903 452028 452028   Kindred Hosp Tarrant Cnty-Arlington ARLINGTON TX 76011 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 80 Kindred Healthcare 55.0     5.Longterm/non-acute   1.NonAcute   2017.0     KINDRED HOSPITAL-TARRANT COUNTY 1.NonAcute 32.7355816 -97.1071186
20439 20439 670067 670067   Baylor Ortho & Spine Hospital ARLINGTON TX 76015 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 24   20.0     4.Other acute care hosp   9.OK? noICUdays 2017.0     BAYLOR ORTHOPEDIC AND SPINE HOSPITAL AT ARLINGTON 9.OK? 32.7355816 -97.1071186
20442 20442 670071 670071   Texas Health Heart & Vascular Hosp ARLINGTON TX 76012 45012 TX- ARLINGTON 394 TX- FORT WORTH 48439 TX-Tarrant County 48   32.0     4.Other acute care hosp   9.OK?   2017.0     TEXAS HEALTH HEART & VASCULAR HOSPITAL ARLINGTON 9.OK? 32.7355816 -97.1071186

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