home / us_physician_referral_networks

Menu
  • Dashboards

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.

16 rows where fcntyname = "TX-Fort Bend 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, icu_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
14594 14594 450330 450330   Oakbend Medical Center RICHMOND TX 77469 45221 TX- RICHMOND 397 TX- HOUSTON 48157 TX-Fort Bend County 227   186.0     4.Other acute care hosp   9.OK?       9.OK? OAKBEND MEDICAL CENTER   29.5821811 -95.7607832
14707 14707 450820 450820   Houston Methodist Sugar Land Hosp SUGAR LAND TX 77479 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 319 Houston Methodist 305.0     4.Other acute care hosp   9.OK?       9.OK? HOUSTON METHODIST SUGARLAND HOSPITAL   29.6196787 -95.6349463
14719 14719 450848 450848   Memorial Hermann Sugar Land Hosp SUGAR LAND TX 77479 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 71 Memorial Hermann Health System 87.0     4.Other acute care hosp   9.OK?       9.OK? MEMORIAL HERMANN SUGAR LAND HOSPITAL   29.6196787 -95.6349463
14724 14724 450860 450860   Memorial Hermann Surgical Hosp SUGAR LAND TX 77479 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 6         4.Other acute care hosp   9.OK? noICUdays     9.OK? SUGAR LAND SURGICAL HOSPITAL LLP   29.6196787 -95.6349463
14868 14868 452080 452080   Kindred Hospital Sugar Land SUGAR LAND TX 77479 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 151 Kindred Healthcare 171.0     5.Longterm/non-acute   1.NonAcute       1.NonAcute KINDRED HOSPITAL SUGAR LAND   29.6196787 -95.6349463
14895 14895 452114 452114   Atrium Medical Center-Stafford STAFFORD TX 77477 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 68   68.0     5.Longterm/non-acute   1.NonAcute       1.NonAcute ATRIUM MEDICAL CENTER   29.6160671 -95.5577221
15366 15366 670053 670053   St. Luke's Sugar Land Hospital SUGAR LAND TX 77478 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 100 Catholic Health Initiatives 96.0     4.Other acute care hosp   9.OK?       9.OK? ST LUKE'S SUGAR LAND HOSPITAL   29.6196787 -95.6349463
15370 15370 670058 670058   Emerus Hospital -Sugar Land SUGAR LAND TX 77479 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 7 Emerus 7.0     4.Other acute care hosp   8.Small N -keep? noICUdays     9.OK? MEMORIAL HERMANN FIRST COLONY HOSPITAL   29.6196787 -95.6349463
19661 19661 450330 450330   Oakbend Medical Center RICHMOND TX 77469 45221 TX- RICHMOND 397 TX- HOUSTON 48157 TX-Fort Bend County 219   164.0     4.Other acute care hosp   9.OK?   2017.0     OAKBEND MEDICAL CENTER 9.OK? 29.5821811 -95.7607832
19774 19774 450820 450820   Houston Methodist Sugar Land Hosp SUGAR LAND TX 77479 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 319 Houston Methodist 305.0     4.Other acute care hosp   9.OK?   2017.0     HOUSTON METHODIST SUGARLAND HOSPITAL 9.OK? 29.6196787 -95.6349463
19786 19786 450848 450848   Memorial Hermann Sugar Land Hosp SUGAR LAND TX 77479 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 71 Memorial Hermann Health System 149.0     4.Other acute care hosp   9.OK?   2017.0     MEMORIAL HERMANN SUGAR LAND HOSPITAL 9.OK? 29.6196787 -95.6349463
19791 19791 450860 450860   Memorial Hermann Surgical Hosp SUGAR LAND TX 77479 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 6         4.Other acute care hosp   9.OK? noICUdays 2017.0     SUGAR LAND SURGICAL HOSPITAL LLP 9.OK? 29.6196787 -95.6349463
19935 19935 452080 452080   Kindred Hospital Sugar Land SUGAR LAND TX 77479 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 151 Kindred Healthcare 105.0     5.Longterm/non-acute   1.NonAcute   2017.0     KINDRED HOSPITAL SUGAR LAND 1.NonAcute 29.6196787 -95.6349463
19960 19960 452114 452114   Atrium Medical Center-Stafford STAFFORD TX 77477 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 68   68.0     5.Longterm/non-acute   1.NonAcute   2017.0     ATRIUM MEDICAL CENTER 1.NonAcute 29.6160671 -95.5577221
20430 20430 670053 670053   St. Luke's Sugar Land Hospital SUGAR LAND TX 77478 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 100 Catholic Health Initiatives 96.0     4.Other acute care hosp   9.OK?   2017.0     ST LUKE'S SUGAR LAND HOSPITAL 9.OK? 29.6196787 -95.6349463
20434 20434 670058 670058   Emerus Hospital -Sugar Land SUGAR LAND TX 77479 45131 TX- HOUSTON 397 TX- HOUSTON 48157 TX-Fort Bend County 7 Emerus 7.0     4.Other acute care hosp   9.OK? noICUdays 2017.0     MEMORIAL HERMANN FIRST COLONY HOSPITAL 9.OK? 29.6196787 -95.6349463

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
);
Powered by Datasette · Queries took 1031.29ms · Data license: Please contact the data provider for more information. · Data source: U.S. Census, Dartmouth Atlas of Health Care, NCQA, AIDOS Lab.