Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

4,766 rows sorted by rowid descending

View and edit SQL

Link rowid ▲ hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
4666 DELL CHILDREN'S MEDICAL CENTER OF CENTRAL TEXAS 4900 MUELLER BLVD AUSTIN TX 78723 TRAVIS (512) 324-0000 Childrens Voluntary non-profit - Private TRUE 30.3025490 -97.7049570 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-2zt9_yffw~gyhs 453310 661423 2019-11-25 2019-06-30 127         76 203               203
4665 SAN ANGELO COMMUNITY MEDICAL CENTER 3501 KNICKERBOCKER ROAD SAN ANGELO TX 76904 TOM GREEN (325) 949-9511 Acute Care Hospitals Proprietary TRUE 31.4200760 -100.4701320 0   451 48 48451 41660   Central Tom Green County https://data.medicare.gov/resource/xubh-q36u/row-m9tt.p6fs.emne 450340 657988 2019-02-01 2018-08-31 113 12         131               131
4664 SHANNON MEDICAL CENTER 120 EAST HARRIS AVENUE SAN ANGELO TX 76903 TOM GREEN (325) 653-6741 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.4644850 -100.4350900 0   451 48 48451 41660   Central Tom Green County https://data.medicare.gov/resource/xubh-q36u/row-mf6f.gvju.vuav 450571 644369 2019-02-28 2018-09-30 292 17         313 14 14   28       369
4663 TITUS REGIONAL MEDICAL CENTER 2001 N JEFFERSON MOUNT PLEASANT TX 75455 TITUS (903) 577-6000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1754020 -94.9704330 0   449 48 48449 34420   Central Titus County https://data.medicare.gov/resource/xubh-q36u/row-aq52.vyrb~qjct 450080 643946 2019-03-01 2018-09-30 41 8         49 11 10           70
4662 THROCKMORTON COUNTY MEMORIAL HOSPITAL 802 N MINTER AVENUE THROCKMORTON TX 76483 THROCKMORTON (940) 849-2151 Critical Access Hospitals Government - Local TRUE 33.1896520 -99.1772780 0   447 48 48447         https://data.medicare.gov/resource/xubh-q36u/row-ckdk-2pw4-m4du 451339 649839 2019-05-31 2018-12-31 14           14               14
4661 BROWNFIELD REGIONAL MEDICAL CENTER 705 EAST FELT STREET BROWNFIELD TX 79316 TERRY (806) 637-3551 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1871020 -102.2677500 0   445 48 48445         https://data.medicare.gov/resource/xubh-q36u/row-k4pi.wjbr~im2m 450399 646766 2019-04-09 2018-09-30 26           26               26
4660 HENDRICK MEDICAL CENTER 1900 PINE ABILENE TX 79601 TAYLOR (325) 670-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4715530 -99.7311800 0   441 48 48441 10180   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-ewhh-9kze-g39u 450229 662437 2019-01-28 2018-08-31 220 46 44     25 335   31   20       386
4659 ABILENE REGIONAL MEDICAL CENTER 6250 HWY 83/84 ABILENE TX 79606 TAYLOR (325) 428-1000 Acute Care Hospitals Proprietary TRUE 32.3740060 -99.7425950 0   441 48 48441 10180   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-rque_a7mi~an5d 450558 657529 2019-04-12 2018-08-31 160 20         196               196
4658 TEXAS HEALTH HARRIS METHODIST HOSPITAL SOUTHLAKE 1545 E SOUTHLAKE BLVD SOUTHLAKE TX 76092 TARRANT (817) 748-8700 Acute Care Hospitals Government - State TRUE 32.9409700 -97.1275780 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-4qpu.5fxr~n8vb 450888 651593 2019-06-21 2018-12-31 17           17               17
4657 BAYLOR SCOTT & WHITE MEDICAL CENTER GRAPEVINE 1650 W COLLEGE ST GRAPEVINE TX 76051 TARRANT (817) 481-1588 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9356000 -97.0938970 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-4uyd~s8jq~x5xx 450563 660327 2019-11-27 2019-06-30 233 20         275   14           289
4656 BAYLOR SCOTT AND WHITE SURGICAL HOSPITAL FORTWORTH 1800 PARK PLACE AVENUE FORT WORTH TX 76110 TARRANT (682) 703-5600 Acute Care Hospitals Physician TRUE 32.7257780 -97.3461850 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-h8e3.3xpq~ecwg 450880 649142 2019-05-28 2018-12-31 26 4         30               30
4655 MEDICAL CITY ARLINGTON 3301 MATLOCK ROAD ARLINGTON TX 76015 TARRANT (817) 465-3241 Acute Care Hospitals Proprietary TRUE 32.6917510 -97.1148000 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-vf2t.urzf.vx7i 450675 656370 2019-10-31 2019-05-31 248 45 6     36 335   16           351
4654 USMD HOSPITAL AT FORT WORTH LP 5900 ALTAMESA BLVD FORT WORTH TX 76132 TARRANT (817) 433-9100 Acute Care Hospitals Proprietary TRUE 32.6455920 -97.4181400 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-dprz_9mav_2zjv 670046 649011 2019-05-31 2018-12-31 8           8               8
4653 SAINT CAMILLUS MEDICAL CENTER 1612 HURST TOWN CENTER DRIVE HURST TX 76054 TARRANT (817) 519-3700 Acute Care Hospitals Proprietary TRUE 32.8424570 -97.1884610 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-xwb8_b64c-b49d 670121 653088 2019-08-23 2018-12-31 23           23               23
4652 METHODIST MANSFIELD MEDICAL CENTER 2700 E BROAD STREET MANSFIELD TX 76063 TARRANT (682) 622-2059 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.5692280 -97.0956410 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-3zhm.gxuz-a5ti 670023 660157 2019-12-03 2019-06-30 224 22         254               254
4651 BAYLOR MEDICAL CENTER AT TROPHY CLUB 2850 E STATE HIGHWAY 114 TROPHY CLUB TX 76262 DENTON (817) 837-4600 Acute Care Hospitals Proprietary TRUE 32.9879840 -97.1750310 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-bh5e.rtcd-d8qv 450883 648165 2019-05-21 2018-12-31 22           22               22
4650 TEXAS HEALTH HEART & VASCULAR HOSPITAL ARLINGTON 811 WRIGHT STREET ARLINGTON TX 76012 TARRANT (817) 960-3500 Acute Care Hospitals Proprietary FALSE 32.7482060 -97.1163900 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-qhpw~99pb.trhs 670071 649388 2019-05-30 2018-12-31 27   20       47               47
4649 JPS HEALTH NETWORK 1500 S MAIN ST FORT WORTH TX 76104 TARRANT (817) 921-3431 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7273350 -97.3264050 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-7dvr-ayce.t7an 450039 644576 2019-03-01 2018-09-30 359 36     35   430 132             562
4648 TEXAS HEALTH HEB 1600 HOSPITAL PARKWAY BEDFORD TX 76022 TARRANT (817) 848-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8335130 -97.1252410 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-x956~rev8~2gtu 450639 644187 2019-03-05 2018-09-30 149 18         183 66             249
4647 TEXAS HEALTH HARRIS METHODIST HOSPITAL ALLIANCE 10864 TEXAS HEALTH TRAIL FORT WORTH TX 76244 TARRANT (682) 212-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9317170 -97.3099870 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-hrkm~j5nw.viir 670085 659912 2019-12-02 2019-06-30 81 12         101               101
4646 BAYLOR SCOTT AND WHITE ORTHOPEDIC AND SPINE HOSPI 707 HIGHLANDER BLVD ARLINGTON TX 76015 TARRANT (817) 549-2364 Acute Care Hospitals Proprietary TRUE 32.6821530 -97.1172180 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-4bwe.2jky-j5da 670067 648584 2019-05-22 2018-12-31 24           24               24
4645 BAYLOR SCOTT AND WHITE ALL SAINTS MEDICAL CENTER 1400 EIGHTH AVE FORT WORTH TX 76104 TARRANT (817) 926-2544 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.7302880 -97.3437290 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-99v8_22t5~zuq2 450137 643849 2019-02-28 2018-09-30 275 39       63 377               377
4644 TEXAS HEALTH ARLINGTON MEMORIAL HOSPITAL 800 W RANDOL MILL RD ARLINGTON TX 76012 TARRANT (817) 548-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.7501260 -97.1160860 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-diaa-f6s5.zvjd 450064 649828 2019-05-29 2018-12-31 163 18       13 194 35             229
4643 BAYLOR SCOTT AND WHITE EMERGENCY HOSPITAL BURLESON 12500 SOUTH FREEWAY SUITE 100 BURLESON TX 76028 JOHNSON (214) 294-6250 Acute Care Hospitals Proprietary TRUE 32.5760100 -97.3207740 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-f6z2_rbym-eqyb 670107 649156 2019-05-30 2018-12-31 24           24               24
4642 TEXAS HEALTH HUGULEY HOSPITAL FORT WORTH SOUTH 11801 SOUTH FREEWAY BURLESON TX 76028 JOHNSON (817) 568-5317 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.5854540 -97.3191020 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-w7e4-rhp3.b5j8 450677 656371 2019-10-10 2018-12-31 185 28         213               213
4641 WISE HEALTH SYSTEM 3200 NORTH TARRANT PARKWAY FORT WORTH TX 76177 TARRANT (817) 502-7300 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8974340 -97.3122990 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-nkp3_nyc5_hqkg 670116 650433 2019-05-30 2018-12-31 36           36               36
4640 USMD HOSPITAL AT ARLINGTON L P 801 W INTERSTATE 20 ARLINGTON TX 76017 TARRANT (817) 472-3400 Acute Care Hospitals Physician TRUE 32.6791510 -97.1159710 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-hc6u~w7qj-g9et 450872 649967 2019-05-31 2018-12-31 30 4         34               34
4639 TEXAS HEALTH HARRIS METHODIST HOSPITAL SOUTHWEST F 6100 HARRIS PKWY FORT WORTH TX 76132 TARRANT (817) 433-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.6585950 -97.4196710 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-jak2~7rcg_zm7n 450779 644583 2019-02-28 2018-09-30 219 18       8 245               245
4638 TEXAS HEALTH HARRIS METHODIST HOSPITAL AZLE 108 DENVER TRAIL AZLE TX 76020 TARRANT (817) 444-8700 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.8811960 -97.5337690 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-jm6x.kyhw.4ivn 450419 643652 2019-02-27 2018-09-30 25 6         31               31
4637 MEDICAL CITY NORTH HILLS 4401 BOOTH CALLOWAY ROAD NORTH RICHLAND HILLS TX 76180 TARRANT (817) 255-1000 Acute Care Hospitals Proprietary TRUE 32.8294760 -97.2122340 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-wubf_54fb_7m6r 450087 655842 2019-10-31 2019-05-31 117 20         137 20             157
4636 MEDICAL CITY ALLIANCE 3101 NORTH TARRANT PARKWAY FORT WORTH TX 76177 TARRANT (817) 639-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8985270 -97.3138140 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-7h4z-bqez~gg2f 670103 650796 2019-06-24 2019-01-31 59 8       8 75               75
4635 MEDICAL CITY FORT WORTH 900 EIGHTH AVENUE FORT WORTH TX 76104 TARRANT (817) 336-2100 Acute Care Hospitals Proprietary TRUE 32.7354810 -97.3437040 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-ur6k~km8p~s2zk 450672 651726 2019-06-28 2019-01-31 156 44         200   18           218
4634 TEXAS HEALTH HARRIS METHODIST FORT WORTH 1301 PENNSYLVANIA AVENUE FORT WORTH TX 76104 TARRANT (817) 250-2100 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.7384800 -97.3393130 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-5nda.skwh.p2ty 450135 661412 2019-12-02 2018-09-30 500 22 12       662               662
4633 COOK CHILDRENS MEDICAL CENTER 801 SEVENTH AVENUE FORT WORTH TX 76104 TARRANT (682) 885-4000 Childrens Voluntary non-profit - Private TRUE 32.7364880 -97.3419750 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-78ag.2jb3-taix 453300 645193 2019-03-05 2018-09-30 255           392               392
4632 SWISHER MEMORIAL HOSPITAL 539 SOUTHEAST 2ND TULIA TX 79088 SWISHER (806) 995-3581 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.5355710 -101.7564100 0   437 48 48437         https://data.medicare.gov/resource/xubh-q36u/row-mwcs~qsjd_wfa3 451349 649506 2019-05-28 2018-12-31 20           20           9   29
4631 LILLIAN M HUDSPETH MEMORIAL HOSPITAL 308 HUDSPETH SONORA TX 76950 SUTTON (325) 387-2521 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.5637580 -100.6348700 0   435 48 48435         https://data.medicare.gov/resource/xubh-q36u/row-i9e9_qde3.um4r 451324 652847 2019-08-21 2018-12-31 12           12               12
4630 STONEWALL MEMORIAL HOSPITAL 821 NORTH BROADWAY ASPERMONT TX 79502 STONEWALL (940) 989-3551 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.1481491 -100.2274452 1 RANGE_INTERPOLATED 433 48 48433         https://data.medicare.gov/resource/xubh-q36u/row-2ftf-f2vh-6a2t 451318 644669 2019-03-01 2018-09-30 20           20               20
4629 STEPHENS MEMORIAL HOSPITAL 200 SOUTH GENEVA STREET BRECKENRIDGE TX 76424 STEPHENS (254) 559-2241 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7540560 -98.8877190 0   429 48 48429         https://data.medicare.gov/resource/xubh-q36u/row-f2c3_a9xb.afpq 450498 643739 2019-02-27 2018-09-30 14           14               14
4628 STARR COUNTY MEMORIAL HOSPITAL 128 N FM RD 3167 RIO GRANDE CITY TX 78582 STARR (956) 487-5561 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.3775400 -98.8598860 0   427 48 48427 40100 McAllen-Edinburg, TX Central Starr County https://data.medicare.gov/resource/xubh-q36u/row-x724_tbx6~dpen 450654 646242 2019-03-19 2018-09-30 48           48               48
4627 GLEN ROSE MEDICAL CENTER 1021 HOLDEN STREET GLEN ROSE TX 76043 SOMERVELL (254) 897-2215 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.2420300 -97.7454000 0   425 48 48425 19100 Dallas-Fort Worth, TX-OK Outlying Somervell County https://data.medicare.gov/resource/xubh-q36u/row-cri5-k66p_vjbz 450451 645798 2019-03-22 2018-09-30 16           16               16
4626 UNIVERSITY OF TEXAS HEALTH SCIENCE CENTER AT TYLER 11937 US HIGHWAY 271 TYLER TX 75708 SMITH (903) 877-7777 Acute Care Hospitals Government - State TRUE 32.4236900 -95.2092910 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-t9fk_pkzk_23zc 450690 662612 2019-02-01 2018-08-31 90 14         104 26             130
4625 BAYLOR SCOTT & WHITE TEXAS SPINE & JOINT HOSPITAL 1814 ROSELAND BOULEVARD TYLER TX 75701 SMITH (903) 525-3300 Acute Care Hospitals Physician TRUE 32.3292480 -95.2994670 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-id2a~8wab-iya8 450864 649358 2019-06-03 2018-12-31 20           20               20
4624 CHRISTUS MOTHER FRANCES HOSPITAL 800 EAST DAWSON TYLER TX 75701 SMITH (903) 593-8441 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.3417000 -95.2909150 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-wt68-yfn8-3txd 450102 660885 2019-11-26 2019-06-30 295 138         433               433
4623 UT HEALTH EAST TEXAS TYLER REGIONAL HOSPITAL 1000 SOUTH BECKHAM AVE TYLER TX 75701 SMITH (903) 597-0351 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.3381020 -95.2918620 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-in8p-wss8_dwt9 450083 646360 2019-04-01 2018-10-31 285 54         339               339
4622 COGDELL MEMORIAL HOSPITAL 1700 COGDELL BLVD SNYDER TX 79549 SCURRY (325) 574-7437 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.6885190 -100.9160210 0   415 48 48415 43660   Central Scurry County https://data.medicare.gov/resource/xubh-q36u/row-5iu8-d6fb-45c3 451384 649145 2019-05-29 2018-12-31 25           25               25
4621 SCHLEICHER COUNTY MEDICAL CENTER 102 NORTH US HIGHWAY 277 ELDORADO TX 76936 SCHLEICHER (325) 853-2507 Critical Access Hospitals Proprietary TRUE 30.8698690 -100.5903930 0   413 48 48413         https://data.medicare.gov/resource/xubh-q36u/row-ukk5-7d2r~gvs8 451304 649143 2019-05-21 2018-12-31 14           14               14
4620 CARE REGIONAL MEDICAL CENTER 1711 W WHEELER AVENUE ARANSAS PASS TX 78336 SAN PATRICIO (361) 758-8585 Acute Care Hospitals Proprietary TRUE 27.9159210 -97.1618290 0   409 48 48409 18580 Corpus Christi-Kingsville-Alice, TX Central San Patricio County https://data.medicare.gov/resource/xubh-q36u/row-g7k6_vy64~c2bf 450605 655598 2018-07-30 2017-12-31 63           63 12             75
4619 CHI ST LUKES HEALTH MEMORIAL SAN AUGUSTINE 511 HOSPITAL ST SAN AUGUSTINE TX 75972 SAN AUGUSTINE (936) 275-3446 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.5322792 -94.1031699 1 ROOFTOP 405 48 48405         https://data.medicare.gov/resource/xubh-q36u/row-d3sm_en2i-92xw 451360 660892 2019-11-27 2019-06-30 9           9               9
4618 SABINE COUNTY HOSPITAL PO BOX 750, 2301 HWY 83 W HEMPHILL TX 75948 SABINE (409) 787-3300 Critical Access Hospitals Proprietary TRUE 31.3407403 -93.8468520 1 APPROXIMATE 403 48 48403         https://data.medicare.gov/resource/xubh-q36u/row-quek_rvd7~v5jz 451361 648996 2019-05-28 2018-12-31 25           25               25
4617 UT HEALTH EAST TEXAS HENDERSON HOSPITAL 300 WILSON STREET HENDERSON TX 75652 RUSK (903) 657-7541 Acute Care Hospitals Voluntary non-profit - Private FALSE 32.1616140 -94.7964330 0   401 48 48401 30980 Longview-Marshall, TX Outlying Rusk County https://data.medicare.gov/resource/xubh-q36u/row-u9e3.sckb-vzcp 450475 643959 2019-03-01 2018-09-30 41           41               41
4616 NORTH RUNNELS HOSPITAL 7821 EAST HIGHWAY 153 WINTERS TX 79567 RUNNELS (325) 754-4553 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.9498620 -99.9598240 0   399 48 48399         https://data.medicare.gov/resource/xubh-q36u/row-hszw.eyaq-hdvd 451315 659073 2019-11-18 2019-06-30 15           15               15
4615 BALLINGER MEMORIAL HOSPITAL 608 AVENUE B BALLINGER TX 76821 RUNNELS (325) 365-2531 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7498220 -99.9623020 0   399 48 48399         https://data.medicare.gov/resource/xubh-q36u/row-nqcy_n2re.zwit 451310 643973 2019-03-04 2018-09-30 16           16               16
4614 BAYLOR SCOTT AND WHITE MEDICAL CENTER LAKE POINTE 6800 SCENIC DR ROWLETT TX 75088 DALLAS (972) 412-2273 Acute Care Hospitals Proprietary TRUE 32.9183510 -96.5095360 0   397 48 48397 19100 Dallas-Fort Worth, TX-OK Central Rockwall County https://data.medicare.gov/resource/xubh-q36u/row-x5ah.rt93-ynam 450742 655847 2019-10-31 2019-05-31 90 14       17 121               121
4613 TEXAS HEALTH PRESBYTERIAN HOSPITAL ROCKWALL 3150 HORIZON ROAD ROCKWALL TX 75032 ROCKWALL (469) 698-1000 Acute Care Hospitals Proprietary TRUE 32.8861320 -96.4647540 0   397 48 48397 19100 Dallas-Fort Worth, TX-OK Central Rockwall County https://data.medicare.gov/resource/xubh-q36u/row-zpnd~t3wy-krmf 670044 651257 2019-06-21 2018-12-31 47 6         53               53
4612 REFUGIO COUNTY MEMORIAL HOSPITAL 107 SWIFT STREET REFUGIO TX 78377 REFUGIO (361) 526-2321 Critical Access Hospitals Government - Hospital District or Authority TRUE 28.3064870 -97.2794390 0   391 48 48391         https://data.medicare.gov/resource/xubh-q36u/row-2im8~3t6u.ez3t 451317 649504 2019-05-29 2018-12-31 20           20               20
4611 REEVES COUNTY HOSPITAL DISTRICT 2323 TEXAS STREET PECOS TX 79772 REEVES (432) 447-3551 Critical Access Hospitals Government - Local TRUE 31.4015750 -103.5128310 0   389 48 48389 37780   Central Reeves County https://data.medicare.gov/resource/xubh-q36u/row-rsmc~hz2u-34n4 451377 656016 2019-10-16 2018-12-31 25           25               25
4610 REAGAN MEMORIAL HOSPITAL 1300 N MAIN AVENUE BIG LAKE TX 76932 REAGAN (325) 844-2561 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2016510 -101.4615870 0   383 48 48383         https://data.medicare.gov/resource/xubh-q36u/row-3fmb~j2vv~wgtn 451301 651298 2019-03-05 2018-09-30 7           7               7
4609 BAPTIST ST ANTHONY'S HOSPITAL 1600 WALLACE BLVD AMARILLO TX 79106 POTTER (806) 212-2000 Acute Care Hospitals Proprietary TRUE 35.1951150 -101.9188500 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-4rbc-ngk8.tb7q 450231 651243 2019-06-24 2018-12-31 282   48       354   24           378
4608 QUAIL CREEK SURGICAL HOSPITAL 6819 PLUM CREEK AMARILLO TX 79124 POTTER (806) 354-6100 Acute Care Hospitals Proprietary TRUE 35.2106750 -101.9135680 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-3fht_yhjz.yec5 450875 648767 2019-05-24 2018-12-31 32           32               32
4607 NORTHWEST TEXAS HOSPITAL 1501 S COULTER ST AMARILLO TX 79106 POTTER (806) 354-1110 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.1997650 -101.9218810 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-n4qk-n2ds.jvw9 450209 649499 2019-05-28 2018-12-31 240 51         347 87 10           444
4606 DHHS USPHS INDIAN HEALTH SERVICES EXIT #102 OFF I-40 1/2 MILE SOUTH SAN FIDEL NM 87049 CIBOLA (505) 552-5300 Acute Care Hospitals Government - Federal TRUE 35.1838274 -101.9279458 1 ROOFTOP 375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-j82y-frp9~f9kp 320070 647921 2019-05-08 2018-09-30 6           6               6
4605 IRAAN GENERAL HOSPITAL 600 HIGHWAY 349 NORTH IRAAN TX 79744 PECOS (432) 639-2575 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.9141890 -101.9066730 0   371 48 48371         https://data.medicare.gov/resource/xubh-q36u/row-gutj.3p8m~9z3e 451307 651245 2019-06-28 2018-12-31 14           14               14
4604 PECOS COUNTY MEMORIAL HOSPITAL 387 WEST I 10 FORT STOCKTON TX 79735 PECOS (432) 336-2004 Critical Access Hospitals Government - Local TRUE 30.9064090 -102.8823510 0   371 48 48371         https://data.medicare.gov/resource/xubh-q36u/row-d6ks_jvwm~jfzs 451389 655476 2019-10-18 2018-12-31 25           25               25
4603 PARMER COUNTY COMMUNITY HOSPITAL 1307 CLEVELAND STREET FRIONA TX 79035 PARMER (806) 250-2754 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6436340 -102.7210880 0   369 48 48369         https://data.medicare.gov/resource/xubh-q36u/row-tza2_si74_zn9j 451300 643654 2019-02-27 2018-09-30 25           25               25
4602 MEDICAL CITY WEATHERFORD 713 E ANDERSON ST WEATHERFORD TX 76086 PARKER (817) 599-1190 Acute Care Hospitals Proprietary TRUE 32.7474720 -97.7853690 0   367 48 48367 19100 Dallas-Fort Worth, TX-OK Outlying Parker County https://data.medicare.gov/resource/xubh-q36u/row-av88-hrcn-mm8c 450203 654603 2019-08-30 2018-09-30 62 20         82               82
4601 UT HEALTH EAST TEXAS CARTHAGE HOSPITAL 409 COTTAGE RD CARTHAGE TX 75633 PANOLA (093) 693-3841 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1671260 -94.3460390 0   365 48 48365         https://data.medicare.gov/resource/xubh-q36u/row-tyuw-zwkq.zq2r 450210 640322 2018-12-28 2018-07-31 42           42               42
4600 PALO PINTO GENERAL HOSPITAL 400 SOUTHWEST 25 AVE MINERAL WELLS TX 76067 PALO PINTO (940) 325-7891 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7995520 -98.1454060 0   363 48 48363 33420 Dallas-Fort Worth, TX-OK Central Palo Pinto County https://data.medicare.gov/resource/xubh-q36u/row-rdr2_vfyr~xwjf 450565 643960 2019-03-01 2018-09-30 40 8         48               48
4599 OCHILTREE GENERAL HOSPITAL 3101 GARRETT DRIVE PERRYTON TX 79070 OCHILTREE (806) 435-3606 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.3696910 -100.7997980 0   357 48 48357         https://data.medicare.gov/resource/xubh-q36u/row-c7ws-qdsc.ahy5 451359 656372 2019-10-29 2018-09-30 25           25               25
4598 DRISCOLL CHILDRENS HOSPITAL 3533 S ALAMEDA BOX 6530 CORPUS CHRISTI TX 78411 NUECES (361) 739-4846 Childrens Voluntary non-profit - Private TRUE 27.7488804 -97.3863616 1 ROOFTOP 355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-q6ns-86wd.av5n 453301 650786 2019-06-25 2018-08-31 101 20       41 162               162
4597 CORPUS CHRISTI MEDICAL CENTER,THE 6629 WOODRIDGE ROAD CORPUS CHRISTI TX 78414 NUECES (361) 761-1501 Acute Care Hospitals Proprietary FALSE 27.6816440 -97.3592840 0   355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-ucbp~a56a_ytw8 450788 662615 2019-08-08 2018-08-31 335 33       16 384 17 15           416
4596 CHRISTUS SPOHN HOSPITAL CORPUS CHRISTI 600 ELIZABETH STREET CORPUS CHRISTI TX 78404 NUECES (361) 902-4103 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.7774890 -97.3951210 0   355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-jjnn-vsf2-rj2w 450046 659894 2019-11-26 2019-06-30 376 52 32       484 33 31   22       570
4595 SOUTH TEXAS SURGICAL HOSPITAL 6130 PARKWAY DRIVE CORPUS CHRISTI TX 78414 NUECES (361) 993-2000 Acute Care Hospitals Proprietary TRUE 27.6869280 -97.3754370 0   355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-cbxw_6hav~c9r6 670061 651496 2019-05-29 2018-12-31 33           33               33
4594 ROLLING PLAINS MEMORIAL HOSPITAL 200 E ARIZONA SWEETWATER TX 79556 NOLAN (325) 235-1701 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4538820 -100.3983140 0   353 48 48353 45020   Central Nolan County https://data.medicare.gov/resource/xubh-q36u/row-jbwn_aebk~78ee 450055 646765 2019-04-16 2018-09-30 34 5         39               39
4593 NAVARRO REGIONAL HOSPITAL 3201 WEST HIGHWAY 22 CORSICANA TX 75110 NAVARRO (903) 654-6800 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.0850830 -96.5035820 0   349 48 48349 18620 Dallas-Fort Worth, TX-OK Central Navarro County https://data.medicare.gov/resource/xubh-q36u/row-5tcd-w9j9-mfc7 450447 655998 2019-10-14 2018-12-31 40 9         49               49
4592 NACOGDOCHES MEDICAL CENTER 4920 NE STALLINGS DRIVE NACOGDOCHES TX 75961 NACOGDOCHES (936) 569-9481 Acute Care Hospitals Physician TRUE 31.6520580 -94.6542650 0   347 48 48347 34860   Central Nacogdoches County https://data.medicare.gov/resource/xubh-q36u/row-m94n-8ys7.xs7q 450656 649673 2019-05-31 2018-12-31 136 11       8 155               155
4591 MEMORIAL HOSPITAL 1204 MOUND ST NACOGDOCHES TX 75961 NACOGDOCHES (936) 564-4611 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6133970 -94.6494550 0   347 48 48347 34860   Central Nacogdoches County https://data.medicare.gov/resource/xubh-q36u/row-uznb.n7zt.xdrg 450508 659737 2019-11-26 2019-06-30 97 16         121   20           141
4590 MEMORIAL HOSPITAL 224 E SECOND STREET DUMAS TX 79029 MOORE (806) 935-7171 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.8642640 -101.9710060 0   341 48 48341 20300   Central Moore County https://data.medicare.gov/resource/xubh-q36u/row-35k5-7dip~y499 451386 659901 2019-11-25 2019-06-30 16 3         19               19
4589 ST LUKE'S THE WOODLANDS HOSPITAL 17200 ST LUKE'S WAY THE WOODLANDS TX 77384 MONTGOMERY (936) 266-4050 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2056600 -95.4607730 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-jjc6.gs28~ctce 450862 661112 2019-12-02 2019-06-30 163 43         216   18           234
4588 MEMORIAL HERMANN SURGICAL HOSPITAL KINGWOOD 300 KINGWOOD MEDICAL DRIVE KINGWOOD TX 77339 HARRIS (281) 312-4000 Acute Care Hospitals Proprietary TRUE 30.0471980 -95.2579490 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-v6he.gqvr.a5ws 670005 648513 2019-05-21 2018-12-31 10           10               10
4587 ASPIRE BEHAVIORAL HEALTH OF CONROE, LLC 2006 SOUTH LOOP 336 WEST, SUITE 500 CONROE TX 77304 MONTGOMERY (936) 647-3500 Acute Care Hospitals Physician FALSE 30.2840690 -95.4801310 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-h7u8.wg6t-a3vd 670093 651497 2019-05-31 2018-12-31 6           6 24             30
4586 EMIL J FREIREICH CANCER CENTER 9201 PINECROFT SHENANDOAH TX 77380 MONTGOMERY (855) 353-2201 Acute Care Hospitals Proprietary TRUE 30.1748330 -95.4562990 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-dgs8~kmnk_pu43                                      
4585 HCA HOUSTON HEALTHCARE CONROE 504 MEDICAL CENTER BLVD CONROE TX 77304 MONTGOMERY (936) 539-1111 Acute Care Hospitals Proprietary TRUE 30.2840220 -95.4687220 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-wuyf_gfkh-wkwb 450222 649957 2019-05-31 2018-12-31 222 38       16 276   20           296
4584 HCA HOUSTON HEALTHCARE KINGWOOD 22999 US HWY 59 KINGWOOD TX 77325 HARRIS (281) 359-7500 Acute Care Hospitals Proprietary TRUE 30.0500599 -95.2552222 1 ROOFTOP 339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-7cnb.g98t-w5nn 450775 654556 2019-09-10 2018-09-30 406 42       24 494   27           521
4583 HOUSTON METHODIST THE WOODLANDS HOSPITAL 17201 INTERSTATE 45 SOUTH THE WOODLANDS TX 77385 MONTGOMERY (936) 270-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2046970 -95.4555100 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-uc2s-vyjm.8c3p 670122 649390 2019-06-03 2018-12-31 130 16         146               146
4582 ST LUKES LAKESIDE HOSPITAL 17400 ST LUKES WAY THE WOODLANDS TX 77384 MONTGOMERY (936) 266-4055 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.2031320 -95.4594820 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-4i3k-4nqm~yxpg 670059 661450 2019-12-02 2019-06-30 30           30               30
4581 NOCONA GENERAL HOSPITAL 100 PARK ROAD NOCONA TX 76255 MONTAGUE (940) 825-3235 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7775590 -97.7315640 0   337 48 48337         https://data.medicare.gov/resource/xubh-q36u/row-f6j5-6zwa-5e54 450641 659541 2019-11-22 2019-06-30 18           18               18
4580 MITCHELL COUNTY HOSPITAL DISTRICT 997 WEST I-20 COLORADO CITY TX 79512 MITCHELL (325) 728-3431 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.3881450 -100.8557360 0   335 48 48335         https://data.medicare.gov/resource/xubh-q36u/row-db55~qgw8.qpyc 451342 643979 2019-03-05 2018-09-30 25           25               25
4579 LITTLE RIVER HEALTHCARE 1700 BRAZOS ROCKDALE TX 76567 MILAM (512) 446-4500 Critical Access Hospitals Proprietary TRUE 30.6503240 -97.0201050 0   331 48 48331         https://data.medicare.gov/resource/xubh-q36u/row-afvn-5pmv_graz 451357 630239 2018-06-01 2017-12-31 25           25               25
4578 MIDLAND MEMORIAL HOSPITAL 400 ROSALIND REDFERN GROVER PARKWAY MIDLAND TX 79701 MIDLAND (432) 685-1111 Acute Care Hospitals Government - Local TRUE 31.9974940 -102.0999760 0   329 48 48329 33260 Midland-Odessa, TX Central Midland County https://data.medicare.gov/resource/xubh-q36u/row-cs6x~ax5d_pb7f 450133 647760 2019-05-16 2018-09-30 180   48       228               228
4577 MEDINA REGIONAL HOSPITAL 3100 AVENUE E HONDO TX 78861 MEDINA (830) 426-7700 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.3352470 -99.1334160 0   325 48 48325 41700   Outlying Medina County https://data.medicare.gov/resource/xubh-q36u/row-i6se_ecqu-nzyr 451330 643655 2019-02-27 2018-09-30 25           25               25
4576 FORT DUNCAN MEDICAL CENTER 3333 N FOSTER MALDONADO BLVD EAGLE PASS TX 78852 MAVERICK (830) 773-5321 Acute Care Hospitals Proprietary TRUE 28.7114180 -100.4541050 0   323 48 48323 20580   Central Maverick County https://data.medicare.gov/resource/xubh-q36u/row-zqqu-eqhh-2cw6 450092 648764 2019-05-28 2018-12-31 76 10         86   15           101
4575 MATAGORDA REGIONAL MEDICAL CENTER 104 7TH STREET BAY CITY TX 77414 MATAGORDA (979) 245-6383 Acute Care Hospitals Government - Hospital District or Authority TRUE 28.9828050 -95.9912900 0   321 48 48321 13060 Houston-The Woodlands, TX Central Matagorda County https://data.medicare.gov/resource/xubh-q36u/row-wsg3_j6n3.vs5r 450465 645734 2019-03-26 2018-09-30 40 6         46 12             58
4574 PALACIOS COMMUNITY MEDICAL CENTER 311 GREEN AVENUE PALACIOS TX 77465 MATAGORDA (361) 972-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.7174570 -96.2127670 0   321 48 48321 13060 Houston-The Woodlands, TX Central Matagorda County https://data.medicare.gov/resource/xubh-q36u/row-e88j_uxba~jujd 451332 650379 2019-06-03 2018-12-31 17           17               17
4573 PHOEBE WORTH MEDICAL CENTER 807 SOUTH ISABELLA STREET SYLVESTER GA 31791 WORTH (229) 777-3851 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.5123850 -83.8406730 0   321 13 13321 10500   Outlying Worth County https://data.medicare.gov/resource/xubh-q36u/row-kvdr-2fup-rgie 111328 641024 2018-12-28 2018-07-31 25           25               25
4572 MARTIN COUNTY HOSPITAL DISTRICT 600 E INTERSTATE 20 PO BOX 640 STANTON TX 79782 MARTIN (432) 756-3345 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.1397988 -101.7870627 1 ROOFTOP 317 48 48317 33260 Midland-Odessa, TX Outlying Martin County https://data.medicare.gov/resource/xubh-q36u/row-b2bs_dpvv_us2e 451333 655474 2019-10-01 2019-04-30 18           18               18
4571 WILLS MEMORIAL HOSPITAL 120 GORDON STREET WASHINGTON GA 30673 WILKES (706) 678-9212 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7293020 -82.7423880 0   317 13 13317         https://data.medicare.gov/resource/xubh-q36u/row-xbea-eh76-aa8t 111325 654422 2019-09-23 2019-04-30 25           25               25
4570 MADISON ST JOSEPH HEALTH CENTER 100 WEST CROSS STREET MADISONVILLE TX 77864 MADISON (936) 348-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 30.9420460 -95.9099560 0   313 48 48313         https://data.medicare.gov/resource/xubh-q36u/row-nns8-bhuk_vxd6 451316 660055 2019-12-02 2019-06-30 15           15               15
4569 HAMILTON MEDICAL CENTER 1200 MEMORIAL DRIVE DALTON GA 30720 WHITFIELD (706) 272-6105 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7888840 -84.9836570 0   313 13 13313 19140 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Whitfield County https://data.medicare.gov/resource/xubh-q36u/row-43qf_bzq5_w6mu 110001 644112 2019-02-28 2018-09-30 212 26     8   246 18             264
4568 PROVIDENCE HEALTH CENTER 6901 MEDICAL PARKWAY WACO TX 76712 MC LENNAN (254) 751-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.5132430 -97.1984310 0   309 48 48309 47380   Central McLennan County https://data.medicare.gov/resource/xubh-q36u/row-vgx2-viz4_yy8e 450042 659893 2019-11-25 2019-06-30 195 30         225 46             271
4567 BAYLOR SCOTT & WHITE MEDICAL CENTER HILLCREST 100 HILLCREST MEDICAL BLVD WACO TX 76712 MC LENNAN (254) 202-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.4892120 -97.1568040 0   309 48 48309 47380   Central McLennan County https://data.medicare.gov/resource/xubh-q36u/row-akp7_94sn-823t 450101 660713 2019-01-30 2018-08-31 158 12 12     30 212   24           236

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options:

CREATE TABLE [hospital_data] (
   [hospital_name] TEXT,
   [address] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip_code] INTEGER,
   [county_name] TEXT,
   [phone_number] TEXT,
   [hospital_type] TEXT,
   [hospital_ownership] TEXT,
   [emergency_services] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [countyfips] INTEGER,
   [statefips] INTEGER,
   [statecountyfips] INTEGER,
   [cbsacode] TEXT,
   [csatitle] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [hosp_lookup_url] TEXT,
   [PRVDR_NUM] INTEGER,
   [RPT_REC_NUM] INTEGER,
   [filed_date] TEXT,
   [fy_end_date] TEXT,
   [acute_beds] INTEGER,
   [icu_beds] TEXT,
   [coronary_beds] TEXT,
   [burn_beds] TEXT,
   [surg_icu_beds] TEXT,
   [oth_spec_beds] TEXT,
   [subtotal_acute_beds] INTEGER,
   [subprovider_ipf_beds] TEXT,
   [subprovider_irf_beds] TEXT,
   [subprovider_oth_beds] TEXT,
   [skilled_nursing_beds] TEXT,
   [nursing_fac_beds] TEXT,
   [oth_longterm_beds] TEXT,
   [hospice_beds] TEXT,
   [all_beds] INTEGER
);