hospital_data

Table actions
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 state

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
3517 3517 ST VINCENT'S ST CLAIR 7063 VETERANS PARKWAY PELL CITY AL 35125 ST. CLAIR (205) 338-3301 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6055680 -86.3023800 0   115 1 1115 13820 Birmingham-Hoover-Talladega, AL Outlying St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-env7.dc7s_bwtg 10130 659400 2019-11-22 2019-06-30 34 6         40               40
3544 3544 SHELBY BAPTIST MEDICAL CENTER 1000 FIRST STREET NORTH ALABASTER AL 35007 SHELBY (205) 620-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2536790 -86.8142610 0   117 1 1117 13820 Birmingham-Hoover-Talladega, AL Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-j68e.5ee5_e79h 10016 651149 2019-05-31 2018-12-31 180 32         212 40             252
3574 3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
3625 3625 COOSA VALLEY MEDICAL CENTER 315 W HICKORY ST SYLACAUGA AL 35150 TALLADEGA (256) 249-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1646660 -86.2545980 0   121 1 1121 45180 Birmingham-Hoover-Talladega, AL Central Talladega County https://data.medicare.gov/resource/xubh-q36u/row-uqj6-bzwc~56ip 10164 659174 2018-12-26 2018-07-31 114 8         122 15     35 50     222
3626 3626 CITIZENS BAPTIST MEDICAL CENTER 604 STONE AVENUE TALLADEGA AL 35161 TALLADEGA (256) 761-4542 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.4398010 -86.0906410 0   121 1 1121 45180 Birmingham-Hoover-Talladega, AL Central Talladega County https://data.medicare.gov/resource/xubh-q36u/row-wfgi.6wxf-zx48 10101 651155 2019-05-30 2018-12-31 79 6         85 13             98
3670 3670 LAKE MARTIN COMMUNITY HOSPITAL 201 MARIARDEN ROAD DADEVILLE AL 36853 TALLAPOOSA (256) 825-7821 Acute Care Hospitals Proprietary TRUE 32.8187000 -85.7417580 0   123 1 1123         https://data.medicare.gov/resource/xubh-q36u/row-7irr_xm4w_yyg3 10052 649861 2019-05-29 2018-12-31 46           46               46
3671 3671 RUSSELL MEDICAL CENTER 3316 HIGHWAY 280 ALEXANDER CITY AL 35010 TALLAPOOSA (256) 329-7100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9310300 -85.9683940 0   123 1 1123         https://data.medicare.gov/resource/xubh-q36u/row-7ugw.v846~xcyn 10065 651308 2019-05-30 2018-12-31 28 6         34               34
3700 3700 D C H REGIONAL MEDICAL CENTER 809 UNIVERSITY BOULEVARD EAST TUSCALOOSA AL 35401 TUSCALOOSA (205) 759-7111 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2061300 -87.5251540 0   125 1 1125 46220   Central Tuscaloosa County https://data.medicare.gov/resource/xubh-q36u/row-zssi.q234-yq7y 10092 644695 2019-02-28 2018-09-30 362 52 32       497 54 42           593
3738 3738 WALKER BAPTIST MEDICAL CENTER 3400 HIGHWAY 78 EAST JASPER AL 35502 WALKER (205) 387-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8411420 -87.2368790 0   127 1 1127 13820 Birmingham-Hoover-Talladega, AL Outlying Walker County https://data.medicare.gov/resource/xubh-q36u/row-kq57-46fi_25ps 10089 651154 2019-05-31 2018-12-31 195 12         207 52             259
3782 3782 WASHINGTON COUNTY HOSPITAL 14600 ST. STEPHENS AVENUE CHATOM AL 36518 WASHINGTON (251) 847-2223 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.4602960 -88.2352910 0   129 1 1129         https://data.medicare.gov/resource/xubh-q36u/row-kzeh_fuyx-rvjh 11300 644204 2019-03-01 2018-09-30 15           15       88       103
3798 3798 J PAUL JONES HOSPITAL 317 MCWILLIAMS AVENUE CAMDEN AL 36726 WILCOX (334) 682-4131 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.9966110 -87.2994240 0   131 1 1131         https://data.medicare.gov/resource/xubh-q36u/row-xkym~x6ui_jjb9 10102 645039 2019-03-04 2018-09-30 21           21               21
3823 3823 LAKELAND COMMUNITY HOSPITAL 42024 HIGHWAY 195 E HALEYVILLE AL 35565 WINSTON (205) 485-7117 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2417180 -87.5898570 0   133 1 1133         https://data.medicare.gov/resource/xubh-q36u/row-qzez~be97-dgiz 10125 645811 2019-04-01 2018-12-31 45 4         49 9             58
1 1 ASHLEY COUNTY MEDICAL CENTER 1015 UNITY ROAD CROSSETT AR 71635 ASHLEY (870) 364-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.1372060 -91.9387800 0   3 5 5003         https://data.medicare.gov/resource/xubh-q36u/row-gq3d.ak25_8qvw 41323 642385 2019-01-15 2018-09-30 19 6         25 10             35
11 11 CROSSRIDGE COMMUNITY HOSPITAL 310 SOUTH FALLS BOULEVARD WYNNE AR 72396 CROSS (870) 238-3300 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.2203530 -90.7874210 0   37 5 5037         https://data.medicare.gov/resource/xubh-q36u/row-9vam~w7bd~4ivg 41307 644210 2019-02-27 2018-09-30 15           15               15
42 42 BAPTIST HEALTH MEDICAL CENTER-STUTTGART 1703 NORTH BUERKLE ST STUTTGART AR 72160 ARKANSAS (870) 673-3511 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5177730 -91.5575720 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-rh96.h2uy.6pb9 40072 649864 2019-05-31 2018-12-31 49           49               49
43 43 DEWITT HOSPITAL & NURSING HOME, INC 1641 WHITEHEAD DRIVE DE WITT AR 72042 ARKANSAS (870) 946-3571 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2795980 -91.3368920 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-m6cy.wkj8_xepc 41314 660746 2019-12-05 2019-06-30 25           25       60       85
258 258 BAXTER REGIONAL MEDICAL CENTER 624 HOSPITAL DRIVE MOUNTAIN HOME AR 72653 BAXTER (870) 508-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3430670 -92.3959050 0   5 5 5005 34260   Central Baxter County https://data.medicare.gov/resource/xubh-q36u/row-pjhy~i9v2.r6ud 40027 650559 2019-05-31 2018-12-31 153 17         170 19 23       12   224
339 339 OZARKS COMMUNITY HOSPITAL OF GRAVETTE 1101 JACKSON STREET SW GRAVETTE AR 72736 BENTON (479) 787-5291 Critical Access Hospitals Proprietary TRUE 36.4085630 -94.4598700 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-snva.mem9_cs94 41331 651314 2019-05-30 2018-12-31 25           25               25
340 340 SILOAM SPRINGS REGIONAL HOSPITAL 603 NORTH PROGRESS AVENUE SILOAM SPRINGS AR 72761 BENTON (479) 524-4141 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.1903770 -94.5096580 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-6neb~fx59-g35b 40001 653533 2019-08-30 2019-03-31 38 6         44               44
341 341 MERCY HOSPITAL NORTHWEST ARKANSAS 2710 SOUTH RIFE MEDICAL LANE ROGERS AR 72758 BENTON (479) 338-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.3095620 -94.1847090 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-3g3b-cs9n_qbhj 40010 660742 2019-12-04 2019-06-30 174 24         206               206
405 405 NORTH ARKANSAS REGIONAL MEDICAL CENTER 620 NORTH MAIN STREET HARRISON AR 72601 BOONE (870) 414-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.2362810 -93.1071480 0   9 5 5009 25460   Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-arky~dirt~vz74 40017 653366 2019-09-03 2019-03-31 96 24         120 14         4   138
481 481 BRADLEY COUNTY MEDICAL CENTER 404 SOUTH BRADLEY STREET WARREN AR 71671 BRADLEY (870) 226-3731 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6105380 -92.0586650 0   11 5 5011         https://data.medicare.gov/resource/xubh-q36u/row-ga7d-t3u8~gykp 41327 644212 2019-03-04 2018-09-30 25           25 10             35
672 672 MERCY HOSPITAL BERRYVILLE 214 CARTER STREET BERRYVILLE AR 72616 CARROLL (870) 423-3355 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.3582250 -93.5519930 0   15 5 5015         https://data.medicare.gov/resource/xubh-q36u/row-dj6g_rn37~rqpp 41329 659917 2019-12-04 2019-06-30 25           25               25
673 673 EUREKA SPRINGS HOSPITAL, LLC 24 NORRIS STREET EUREKA SPRINGS AR 72632 CARROLL (479) 253-7400 Critical Access Hospitals Proprietary TRUE 36.4004330 -93.7446990 0   15 5 5015         https://data.medicare.gov/resource/xubh-q36u/row-fpuw-vbap-fsdb 41304 647643 2019-05-14 2018-12-31 15           15               15
725 725 CHICOT MEMORIAL MEDICAL CENTER 2729 SOUTH HIGHWAY 65 & 82 LAKE VILLAGE AR 71653 CHICOT (870) 265-5351 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.3056420 -91.2903530 0   17 5 5017         https://data.medicare.gov/resource/xubh-q36u/row-n4n3~4tmq_i4ky 41328 660163 2019-11-22 2019-03-31 25           25               25
809 809 BAPTIST HEALTH MEDICAL CENTER-ARKADELPHIA 3050 TWIN RIVERS DRIVE ARKADELPHIA AR 71923 CLARK (870) 245-2622 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1228020 -93.0879700 0   19 5 5019 11660   Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-f8ss.59v5_rxma 41321 649536 2019-05-31 2018-12-31 25           25               25
882 882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
942 942 BAPTIST HEALTH MEDICAL CENTER HEBER SPINGS 1800 BYPASS ROAD HEBER SPRINGS AR 72543 CLEBURNE (501) 887-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5065780 -92.0013190 0   23 5 5023         https://data.medicare.gov/resource/xubh-q36u/row-d26c_x5yu_6fn3 41312 651551 2019-05-31 2018-12-31 25           25               25
1060 1060 MAGNOLIA HOSPITAL 101 HOSPITAL DRIVE MAGNOLIA AR 71754 COLUMBIA (870) 235-3000 Acute Care Hospitals Government - Local TRUE 33.2751230 -93.2400710 0   27 5 5027 31620   Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-ed5b-6fgx_6hyv 40067 644209 2019-03-01 2018-09-30 24 6         30               30
1122 1122 CHI ST VINCENT MORRILTON #4 HOSPITAL DRIVE MORRILTON AR 72110 CONWAY (501) 977-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.1699700 -92.7217020 0   29 5 5029         https://data.medicare.gov/resource/xubh-q36u/row-jajp~f47n.nife 41324 660162 2019-12-02 2019-06-30 25           25               25
1198 1198 NEA BAPTIST MEMORIAL HOSPITAL 4800 EAST JOHNSON AVENUE JONESBORO AR 72401 CRAIGHEAD (870) 972-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8642040 -90.6391070 0   31 5 5031 27860 Jonesboro-Paragould, AR Central Craighead County https://data.medicare.gov/resource/xubh-q36u/row-2xtp-iu4z.fhj9 40118 640739 2018-12-28 2018-09-30 144 36         180   24           204
1199 1199 ST BERNARDS MEDICAL CENTER 225 E JACKSON JONESBORO AR 72401 CRAIGHEAD (870) 972-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8374780 -90.7021420 0   31 5 5031 27860 Jonesboro-Paragould, AR Central Craighead County https://data.medicare.gov/resource/xubh-q36u/row-tdxp_ingv-y9gs 40020 644208 2019-02-27 2018-09-30 287 30         329 24         20   373
1312 1312 SPARKS MEDICAL CENTER - VAN BUREN 211 CRAWFORD MEMORIAL DRIVE VAN BUREN AR 72956 CRAWFORD (479) 474-3401 Acute Care Hospitals Proprietary TRUE 35.4341750 -94.3394510 0   33 5 5033 22900   Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-w5xt~zwtc_2chf 40018 649071 2019-05-31 2018-12-31 31 8         39               39
1378 1378 BAPTIST MEMORIAL HOSPITAL-CRITTENDEN, INC 2100 NORTH SEVENTH STREET WEST MEMPHIS AR 72301 CRITTENDEN (870) 394-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.1679922 -90.1778757 1 ROOFTOP 35 5 5035 32820 Memphis-Forrest City, TN-MS-AR Central Crittenden County https://data.medicare.gov/resource/xubh-q36u/row-v5ug.qa38-7wwe                                      
1581 1581 DALLAS COUNTY MEDICAL CENTER 201 CLIFTON STREET FORDYCE AR 71742 DALLAS (870) 352-6300 Critical Access Hospitals Government - Local TRUE 33.8111580 -92.4250580 0   39 5 5039         https://data.medicare.gov/resource/xubh-q36u/row-vfqi-mtmw~p9xt 41317 646016 2019-04-01 2018-12-31 22           22               22
1632 1632 DELTA MEMORIAL HOSPITAL 811 HIGHWAY 65 SOUTH DUMAS AR 71639 DESHA (870) 382-4303 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8732940 -91.4815000 0   41 5 5041         https://data.medicare.gov/resource/xubh-q36u/row-65hi_7cx4-4bx3 41326 659558 2019-11-22 2019-06-30 25           25               25
1633 1633 MCGEHEE HOSPITAL 900 SOUTH THIRD STREET MCGEHEE AR 71654 DESHA (870) 222-5600 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6182850 -91.3930660 0   41 5 5041         https://data.medicare.gov/resource/xubh-q36u/row-nhnf~w2ph~7zeh 41308 662151 2019-12-12 2019-06-30 25           25               25
1681 1681 DREW MEMORIAL HOSPITAL 778 SCOGIN DRIVE MONTICELLO AR 71655 DREW (870) 367-2411 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6106280 -91.8149780 0   43 5 5043         https://data.medicare.gov/resource/xubh-q36u/row-fv6e_36f4.x8wa 40051 654082 2019-09-03 2019-03-31 44 5         49               49
1721 1721 BAPTIST HEALTH MEDICAL CENTER-CONWAY 1555 EXCHANGE AVENUE CONWAY AR 72032 FAULKNER (501) 585-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0564394 -92.4192706 1 ROOFTOP 45 5 5045 30780 Little Rock-North Little Rock, AR Outlying Faulkner County https://data.medicare.gov/resource/xubh-q36u/row-begn.7uvq~4sez 40154 650111 2019-05-31 2018-12-31 102 8         110               110
1722 1722 CONWAY REGIONAL HEALTH SYSTEM 2302 COLLEGE AVENUE CONWAY AR 72034 FAULKNER (501) 329-3831 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0848260 -92.4571030 0   45 5 5045 30780 Little Rock-North Little Rock, AR Outlying Faulkner County https://data.medicare.gov/resource/xubh-q36u/row-ycii~pfah-qxh7 40029 649018 2019-05-28 2018-12-31 122 17         139 11             150
1773 1773 MERCY HOSPITAL TURNER MEMORIAL 801 WEST RIVER STREET OZARK AR 72949 FRANKLIN (479) 667-4138 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.4861180 -93.8338050 0   47 5 5047         https://data.medicare.gov/resource/xubh-q36u/row-ztbc-aceq_xeqj 41303 660745 2019-12-04 2019-06-30 25           25               25
1827 1827 FULTON COUNTY HOSPITAL 679 NORTH MAIN STREET SALEM AR 72576 FULTON (870) 895-2691 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3833590 -91.8112030 0   49 5 5049         https://data.medicare.gov/resource/xubh-q36u/row-9b6n-wd2m.b7tm 41322 660913 2019-12-02 2019-06-30 25           25               25
1888 1888 LEVI HOSPITAL 300 PROSPECT AVE HOT SPRINGS AR 71901 GARLAND (501) 624-1281 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5099450 -93.0566490 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-assk.a57a-njvy 40132 649865 2019-05-24 2018-12-31 1           1 52             53
1889 1889 CHI ST. VINCENT HOSPITAL HOT SPRINGS 300 WERNER STREET HOT SPRINGS AR 71903 GARLAND (501) 622-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.4660350 -93.0663960 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-pyjq_z3nz-ckdj 40026 662146 2019-12-02 2019-06-30 204 25         229               229
1890 1890 NATIONAL PARK MEDICAL CENTER 1910 MALVERN AVENUE HOT SPRINGS AR 71901 GARLAND (501) 321-1000 Acute Care Hospitals Proprietary TRUE 34.4862390 -93.0335540 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-ecgs.ugv2_gtfu 40078 656864 2019-02-14 2018-08-31 110 16         126 17 20           163
1992 1992 ARKANSAS METHODIST MEDICAL CENTER 900 WEST KINGSHIGHWAY PARAGOULD AR 72450 GREENE (870) 239-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0525930 -90.4990510 0   55 5 5055 37500 Jonesboro-Paragould, AR Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-r7jj_jnzg_y8it 40039 659557 2019-11-21 2019-06-30 106 8         114   15           129
2046 2046 WADLEY REGIONAL MEDICAL CENTER AT HOPE 2001 SOUTH MAIN HOPE AR 71801 HEMPSTEAD (870) 722-3800 Acute Care Hospitals Proprietary TRUE 33.6480080 -93.5870520 0   57 5 5057         https://data.medicare.gov/resource/xubh-q36u/row-zn9u-sntu_5nuw 40153 643865 2019-02-28 2018-09-30 59 8         67 12             79
2100 2100 BAPTIST HEALTH MEDICAL CENTER-HOT SPRINGS COUNTY 1001 SCHNEIDER DRIVE MALVERN AR 72104 HOT SPRING (501) 332-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.3589130 -92.7864180 0   59 5 5059 31680 Hot Springs-Malvern, AR Central Hot Spring County https://data.medicare.gov/resource/xubh-q36u/row-ua4e~kvad.yq4u 40076 648522 2019-05-31 2018-12-31 58 6         64               64
2176 2176 HOWARD MEMORIAL HOSPITAL 130 MEDICAL CIRCLE NASHVILLE AR 71852 HOWARD (870) 845-4400 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.9509260 -93.8807720 0   61 5 5061         https://data.medicare.gov/resource/xubh-q36u/row-943b-exqy.j5es 41311 643866 2019-03-01 2018-09-30 25           25               25
2239 2239 WHITE RIVER MEDICAL CENTER 1710 HARRISON STREET BATESVILLE AR 72503 INDEPENDENCE (870) 262-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7695720 -91.6347210 0   63 5 5063 12900   Central Independence County https://data.medicare.gov/resource/xubh-q36u/row-pk3m_2ypn.k69k 40119 654084 2019-08-30 2018-09-30 172 12         184 16 10   11       221
2261 2261 IZARD COUNTY MEDICAL CENTER, LLC 61 GRASSE STREET CALICO ROCK AR 72519 BAXTER (870) 297-2400 Critical Access Hospitals Proprietary TRUE 36.1263360 -92.1285870 0   65 5 5065         https://data.medicare.gov/resource/xubh-q36u/row-nm2c~hstr_uanu 41306 662150 2019-12-06 2019-06-30 25           25               25
2385 2385 JEFFERSON REGIONAL MEDICAL CENTER 1600 WEST 40TH AVENUE PINE BLUFF AR 71603 JEFFERSON (870) 541-7100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1890660 -92.0184530 0   69 5 5069 38220 Little Rock-North Little Rock, AR Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-cysb.jz8a~paid 40071 662147 2019-12-03 2019-06-30 237 34         271 18 27           316
2426 2426 JOHNSON REGIONAL MEDICAL CENTER 1100 EAST POPLAR STREET CLARKSVILLE AR 72830 JOHNSON (479) 754-5454 Acute Care Hospitals Government - Local TRUE 35.4643840 -93.4457970 0   71 5 5071         https://data.medicare.gov/resource/xubh-q36u/row-uar5.h8rs.rsi2 40002 648883 2019-05-30 2018-12-31 49 8         57 20 12           89
2555 2555 LAWRENCE MEMORIAL HOSPITAL 1309 WEST MAIN STREET WALNUT RIDGE AR 72476 LAWRENCE (870) 886-1200 Critical Access Hospitals Government - Local TRUE 36.0747010 -90.9669820 0   75 5 5075         https://data.medicare.gov/resource/xubh-q36u/row-jpmn_3ec8~urk8 41309 661136 2019-12-03 2019-06-30 25           25               25
2680 2680 LITTLE RIVER MEMORIAL HOSPITAL 451 WEST LOCKE STREET ASHDOWN AR 71822 LITTLE RIVER (870) 898-5011 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6695720 -94.1350250 0   81 5 5081 45500   Outlying Little River County https://data.medicare.gov/resource/xubh-q36u/row-r8e3~m3nn~24fp 41320 658650 2019-11-12 2019-06-30 25           25               25
2733 2733 MERCY HOSPITAL BOONEVILLE 880 WEST MAIN BOONEVILLE AR 72927 LOGAN (479) 675-2800 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.1409790 -93.9347030 0   83 5 5083         https://data.medicare.gov/resource/xubh-q36u/row-jff3_g33y~pc8b 41318 662152 2019-12-04 2019-06-30 24           24               24
2734 2734 NORTH LOGAN MERCY HOSPITAL 500 EAST ACADEMY PARIS AR 72855 LOGAN (479) 963-6101 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.2899880 -93.7254190 0   83 5 5083         https://data.medicare.gov/resource/xubh-q36u/row-6tgs-f8yk-urcu 41300 660744 2019-12-04 2019-06-30 16           16               16
2987 2987 GREAT RIVER MEDICAL CENTER 1520 N DIVISION STREET BLYTHEVILLE AR 72315 MISSISSIPPI (870) 838-7300 Acute Care Hospitals Government - Local TRUE 35.9430110 -89.9189290 0   93 5 5093 14180   Central Mississippi County https://data.medicare.gov/resource/xubh-q36u/row-hp5p.n74y_egzs 40069 650436 2019-06-05 2018-12-31 28 5         33               33
2988 2988 SOUTH MISSISSISSPI COUNTY REGIONAL MEDICAL CENTER 611 WEST LEE AVENUE OSCEOLA AR 72370 MISSISSIPPI (870) 563-7000 Critical Access Hospitals Government - Local TRUE 35.7002490 -89.9749300 0   93 5 5093 14180   Central Mississippi County https://data.medicare.gov/resource/xubh-q36u/row-q7uu-6ehf~4s6v 41316 650798 2019-06-05 2018-12-31 25           25               25
3244 3244 OUACHITA COUNTY MEDICAL CENTER 638 CALIFORNIA AVENUE CAMDEN AR 71701 OUACHITA (870) 836-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5758644 -92.8362602 1 ROOFTOP 103 5 5103 15780   Central Ouachita County https://data.medicare.gov/resource/xubh-q36u/row-yf7w-c43e.mvn6 40050 644010 2019-03-05 2018-09-30 74 8         82           11   93
3334 3334 HELENA REGIONAL MEDICAL CENTER 1801 MARTIN LUTHER KING JR DRIVE HELENA AR 72342 PHILLIPS (870) 338-5800 Acute Care Hospitals Proprietary TRUE 34.5083570 -90.6273300 0   107 5 5107 25760   Central Phillips County https://data.medicare.gov/resource/xubh-q36u/row-wchu_rtin.sqck 40085 654083 2019-08-27 2018-12-31 121 6         127               127
3456 3456 MENA REGIONAL HEALTH SYSTEM 311 NORTH MORROW STREET MENA AR 71953 POLK (479) 394-6100 Acute Care Hospitals Government - Local TRUE 34.5883860 -94.2213830 0   113 5 5113         https://data.medicare.gov/resource/xubh-q36u/row-wwwj_a4gs~ixth 40015 648521 2019-05-22 2018-12-31 35 6         41 12 12           65
3518 3518 ST MARYS REGIONAL MEDICAL CENTER 1808 WEST MAIN STREET RUSSELLVILLE AR 72801 POPE (479) 968-2841 Acute Care Hospitals Proprietary TRUE 35.2828600 -93.1499080 0   115 5 5115 40780   Central Pope County https://data.medicare.gov/resource/xubh-q36u/row-wrry_g52x-fh3u 40041 656860 2019-02-14 2018-08-31 126 11         137   20           157
3575 3575 ARKANSAS HEART HOSPITAL, LLC 1701 S SHACKLEFORD ROAD LITTLE ROCK AR 72211 PULASKI (501) 219-7000 Acute Care Hospitals Proprietary TRUE 34.7391590 -92.3944210 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-jzxu~zre6.ev3c 40134 644703 2019-02-28 2018-09-30 112           112               112
3576 3576 ARKANSAS SURGICAL HOSPITAL 5201 NORTH SHORE DRIVE NO LITTLE ROCK AR 72118 PULASKI (501) 748-8000 Acute Care Hospitals Proprietary TRUE 34.8014580 -92.3476870 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-y6hc~2xha_rqkj 40147 649072 2019-05-31 2018-12-31 49           49               49
3577 3577 UAMS MEDICAL CENTER 4301 WEST MARKHAM STREET MAIL SLOT 612 LITTLE ROCK AR 72205 PULASKI (501) 686-5000 Acute Care Hospitals Government - State TRUE 34.7515830 -92.3209980 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-s6x4~kv5r_9fry 40016 660912 2019-12-03 2019-06-30 389 28 24     64 505               505
3578 3578 ST VINCENT MEDICAL CENTER/NORTH 2215 WILDWOOD AVENUE SHERWOOD AR 72120 PULASKI (501) 552-7100 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.8143780 -92.2075140 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-92it.v7ju~ja3t 40137 659915 2019-12-02 2019-06-30 45 14         59               59
3579 3579 CHI-ST VINCENT INFIRMARY TWO ST VINCENT CIRCLE LITTLE ROCK AR 72205 PULASKI (501) 552-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7502877 -92.3393435 1 ROOFTOP 119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-rvvz~qyi8_5qyq 40007 660911 2019-12-02 2019-06-30 330 23 20     20 393               393
3580 3580 BAPTIST HEALTH MEDICAL CENTER-LITTLE ROCK 9601 INTERSTATE LITTLE ROCK AR 72205 PULASKI (501) 202-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7443211 -92.3806640 1 ROOFTOP 119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-bf2h_7zv8-2ay2 40114 651550 2019-05-31 2018-12-31 513 36 18   18   683 24     27       734
3582 3582 NORTH METRO MEDICAL CENTER 1400 BRADEN STREET JACKSONVILLE AR 72076 PULASKI (501) 985-7000 Acute Care Hospitals Proprietary TRUE 34.8723810 -92.1246970 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-fmp5~srts-kxcs 40074 656863 2018-12-06 2018-06-30 47           47 31             78
3583 3583 ARKANSAS CHILDREN'S HOSPITAL 1 CHILDREN'S WAY, SLOT 301 LITTLE ROCK AR 72202 PULASKI (501) 364-1100 Childrens Voluntary non-profit - Private TRUE 34.7428220 -92.2920060 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-p66z~xhi7.pxk4 43300 660352 2019-12-03 2019-06-30 153 26 30 10   104 336               336
3584 3584 BAPTIST HEALTH MEDICAL CENTER NORTH LITTLE ROCK 3333 SPRINGHILL DRIVE NORTH LITTLE ROCK AR 72117 PULASKI (501) 202-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7840750 -92.2186330 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-kf3z.y9gr-2kzx 40036 649019 2019-05-31 2018-12-31 143 17 17       177   16   12       205
3601 3601 MERCY HOSPITAL WALDRON 1341 WEST SIXTH STREET WALDRON AR 72958 SCOTT (479) 637-4135 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.8967850 -94.1060780 0   127 5 5127         https://data.medicare.gov/resource/xubh-q36u/row-hh5p.qtqy-xetd 41305 662149 2019-12-04 2019-06-30 24           24               24
3627 3627 FIVE RIVERS MEDICAL CENTER 2801 MEDICAL CENTER DRIVE POCAHONTAS AR 72455 RANDOLPH (870) 892-6000 Acute Care Hospitals Government - Local TRUE 36.2899110 -90.9963340 0   121 5 5121         https://data.medicare.gov/resource/xubh-q36u/row-ts7c.8t6h-nknu 40047 649534 2019-06-07 2018-12-31 30 2         32 12             44
3672 3672 FORREST CITY MEDICAL CENTER 1601 NEWCASTLE ROAD FORREST CITY AR 72335 ST. FRANCIS (870) 261-0000 Acute Care Hospitals Proprietary TRUE 35.0392750 -90.7718940 0   123 5 5123 22620 Memphis-Forrest City, TN-MS-AR Central St. Francis County https://data.medicare.gov/resource/xubh-q36u/row-3mpt-bp6e-mmwc 40019 654002 2019-08-28 2018-09-30 50 6         56 14             70
3701 3701 SALINE MEMORIAL HOSPITAL #1 MEDICAL PARK DRIVE BENTON AR 72015 SALINE (501) 776-6000 Acute Care Hospitals Proprietary TRUE 34.5735520 -92.5844050 0   125 5 5125 30780 Little Rock-North Little Rock, AR Central Saline County https://data.medicare.gov/resource/xubh-q36u/row-yg8k~yizr-mxhg 40084 660068 2019-12-04 2019-06-30 114 16         130 19 12       16   177
3799 3799 BAPTIST HEALTH - FORT SMITH 1001 TOWSON AVENUE FORT SMITH AR 72901 SEBASTIAN (479) 441-4000 Acute Care Hospitals Proprietary TRUE 35.3745270 -94.4213110 0   131 5 5131 22900   Central Sebastian County https://data.medicare.gov/resource/xubh-q36u/row-4ynv.ndxe~fmn4 40055 650435 2019-05-31 2018-12-31 289 31         320 23             343
3800 3800 MERCY HOSPITAL FORT SMITH 7301 ROGERS AVE FORT SMITH AR 72903 SEBASTIAN (479) 314-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3536470 -94.3529640 0   131 5 5131 22900   Central Sebastian County https://data.medicare.gov/resource/xubh-q36u/row-2a77_rb9f.j48w 40062 661700 2018-11-30 2018-06-30 280 38         343   42           400
3867 3867 STONE COUNTY MEDICAL CENTER 2106 EAST MAIN STREET MOUNTAIN VIEW AR 72560 STONE (870) 269-4361 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.8555980 -92.0827270 0   137 5 5137         https://data.medicare.gov/resource/xubh-q36u/row-si2m~smq2~k85s 41310 654085 2019-08-30 2018-09-30 25           25               25
3886 3886 MEDICAL CENTER OF SOUTH ARKANSAS 700 WEST GROVE STREET EL DORADO AR 71730 UNION (870) 863-2000 Acute Care Hospitals Proprietary TRUE 33.2183780 -92.6710300 0   139 5 5139 20980   Central Union County https://data.medicare.gov/resource/xubh-q36u/row-rite-ah8v_bzij 40088 659753 2019-11-26 2019-06-30 95 16         111   20           131
3910 3910 OZARK HEALTH 2500 HIGHWAY 65 SOUTH CLINTON AR 72031 VAN BUREN (501) 745-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5593750 -92.4499130 0   141 5 5141         https://data.medicare.gov/resource/xubh-q36u/row-3ppd-9bg7~xqjh 41313 661137 2019-12-02 2019-06-30 25           25       118       143
3939 3939 NORTHWEST HEALTH PHYSICIANS SPECIALTY HOSPITAL 3873 NORTH PARKVIEW DRIVE FAYETTEVILLE AR 72703 WASHINGTON (479) 571-7002 Acute Care Hospitals Proprietary TRUE 36.1213300 -94.1337300 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-dtfa_7iaz.thv8 40152 650236 2019-06-03 2018-12-31 20           20               20
3940 3940 ARKANSAS CHILDREN'S NORTHWEST, INC 2601 GENE GEORGE BOULEVARD SPRINGDALE AR 72762 WASHINGTON (479) 725-6800 Childrens Voluntary non-profit - Private TRUE 36.1633250 -94.1926020 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ancy_ajta_8yhj 43301 660747 2019-12-03 2019-06-30 24           24               24
3941 3941 NORTHWEST MEDICAL CENTER-SPRINGDALE 609 WEST MAPLE AVENUE SPRINGDALE AR 72764 WASHINGTON (479) 751-5711 Acute Care Hospitals Proprietary TRUE 36.1813940 -94.1364640 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-atff~z7gw_d5cc 40022 646013 2019-03-29 2018-10-31 254 21         275   25           300
3942 3942 WASHINGTON REGIONAL MEDICAL CENTER 3215 N NORTH HILLS BOULEVARD FAYETTEVILLE AR 72703 WASHINGTON (479) 463-5113 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1109840 -94.1578620 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-2bs7.twrk_htcb 40004 649161 2019-06-03 2018-12-31 226 40         320           12   332
3967 3967 WHITE COUNTY MEDICAL CENTER 3214 EAST RACE AVENUE SEARCY AR 72143 WHITE (501) 278-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2504460 -91.6967580 0   145 5 5145 42620 Little Rock-North Little Rock, AR Central White County https://data.medicare.gov/resource/xubh-q36u/row-b6nk.pamh_stfx 40014 644701 2019-02-28 2018-09-30 192 13         205 30 37           272
4010 4010 CHAMBERS MEMORIAL HOSPITAL 719 DETROIT STREET DANVILLE AR 72833 YELL (479) 495-2241 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0548230 -93.3885430 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-d59r_eigs_n4bw 40011 660743 2019-12-03 2019-06-30 30           30 12             42
4011 4011 DARDANELLE HOSPITAL 200 NORTH THIRD STREET DARDANELLE AR 72834 YELL (479) 229-4677 Critical Access Hospitals Proprietary TRUE 35.2209170 -93.1569870 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-u9x6_diim.h7v6 41302 639835 2018-12-26 2018-06-30 25           25 10             35
476 476 LBJ TROPICAL MEDICAL CENTER FAGAALU VILLAGE PAGO PAGO AS 96799 EASTERN DISTRICT (684) 633-4590 Acute Care Hospitals Government - Hospital District or Authority TRUE -14.2900610 -170.6847054 1 APPROXIMATE 10 60 60010         https://data.medicare.gov/resource/xubh-q36u/row-6iv4.yudm-sdek                                      
38 38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
39 39 SAGE MEMORIAL HOSPITAL STATE ROUTE 264 SOUTH 191 GANADO AZ 86505 APACHE (928) 755-4541 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7108602 -109.5423597 1 ROOFTOP 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-vmgp-erfi.puty 31309 652060 2019-05-06 2018-09-30 25           25               25
40 40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
41 41 WHITE MOUNTAIN REGIONAL MEDICAL CENTER 118 SOUTH MOUNTAIN AVENUE SPRINGERVILLE AZ 85938 APACHE (928) 333-4368 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1321360 -109.2865450 0   1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-dkxh~vpbb.s52c 31315 652061 2019-05-30 2018-12-31 21           21               21
136 136 COPPER QUEEN COMMUNITY HOSPITAL 101 COLE AVENUE BISBEE AZ 85603 COCHISE (520) 432-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.4172540 -109.8826000 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-3x2q~x9dv.fg6n 31312 659555 2019-11-25 2019-06-30 14           14               14
137 137 BENSON HOSPITAL 450 SOUTH OCOTILLO AVENUE BENSON AZ 85602 COCHISE (520) 586-2261 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9648290 -110.3071230 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-bbyb-3jvj_e7ef 31301 660910 2019-11-25 2019-06-30 22           22               22
138 138 CANYON VISTA MEDICAL CENTER 5700 EAST HIGHWAY 90 SIERRA VISTA AZ 85635 COCHISE (520) 263-3001 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.5546350 -110.2307260 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ghfv-yx8h~hkgn 30043 654824 2019-09-30 2019-04-30 63 12         75 19             94
139 139 NORTHERN COCHISE COMMUNITY HOSPITAL, INC. 901 WEST REX ALLEN DRIVE WILLCOX AZ 85643 COCHISE (520) 384-3541 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2642680 -109.8376130 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ydad~45b6.8t7t 31302 660487 2019-12-02 2019-06-30 24           24       24       48
255 255 FLAGSTAFF MEDICAL CENTER 1200 NORTH BEAVER STREET FLAGSTAFF AZ 86001 COCONINO (928) 779-3366 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2095340 -111.6448350 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-bzd3~hd4v-cg2f 30023 662010 2019-11-27 2019-06-30 183 41       18 242 22             264
256 256 TUBA CITY REGIONAL HEALTH CARE CORPORATION PO BOX 600 TUBA CITY AZ 86045 COCONINO (928) 283-2501 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.1279296 -111.2249984 1 ROOFTOP 5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-hne8.hg7p.2gfd 30073 651368 2019-07-01 2018-09-30 73           73               73
257 257 PAGE HOSPITAL 501 NORTH NAVAJO DRIVE PAGE AZ 86040 COCONINO (928) 645-2424 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.9169600 -111.4631860 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 31304 649070 2019-06-03 2018-12-31 25           25               25

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