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

403 rows where hospital_ownership = "Government - Local" sorted by PRVDR_NUM

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_irf_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date), fy_end_date (date)

hospital_ownership ✖

  • Government - Local · 403 ✖
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
2238 2238 GREENE COUNTY HOSPITAL 509 WILSON AVENUE EUTAW AL 35462 GREENE (205) 372-3388 Acute Care Hospitals Government - Local TRUE 32.8447440 -87.8893070 0   63 1 1063         https://data.medicare.gov/resource/xubh-q36u/row-dyit.ypt9~f4e7 10051 645036 2019-03-04 2018-09-30 20           20       72       92
666 666 NORTHEAST ALABAMA REGIONAL MEDICAL CENTER 400 EAST 10TH STREET ANNISTON AL 36207 CALHOUN (256) 235-5121 Acute Care Hospitals Government - Local TRUE 33.6571230 -85.8233530 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-ima9~p9t8~qh92 10078 644086 2019-02-28 2018-09-30 232 18         250 20             270
3333 3333 PICKENS COUNTY MEDICAL CENTER 241 ROBERT K WILSON DRIVE CARROLLTON AL 35447 PICKENS (205) 367-8111 Acute Care Hospitals Government - Local TRUE 33.2748070 -88.0896730 0   107 1 1107 46220   Outlying Pickens County https://data.medicare.gov/resource/xubh-q36u/row-zn5h.i3rc.njwh 10109 644006 2019-03-01 2018-09-30 36 4         40 10             50
3132 3132 MONROE COUNTY HOSPITAL 2016 SOUTH ALABAMA AVENUE MONROEVILLE AL 36460 MONROE (251) 575-3111 Acute Care Hospitals Government - Local TRUE 31.4978390 -87.3194110 0   99 1 1099         https://data.medicare.gov/resource/xubh-q36u/row-4wyz~k8fh_i5ug 10120 645040 2019-03-13 2018-09-30 41 8         49               49
3411 3411 BARTLETT REGIONAL HOSPITAL 3260 HOSPITAL DR JUNEAU AK 99801 JUNEAU (907) 796-8900 Acute Care Hospitals Government - Local TRUE 58.3286960 -134.4668290 0   110 2 2110 27940   Central Juneau City and Borough https://data.medicare.gov/resource/xubh-q36u/row-ceet-msjy~uqhq 20008 659178 2019-11-21 2019-06-30 36 9         45 12             57
4529 4529 PROVIDENCE VALDEZ MEDICAL CENTER PO BOX 550 VALDEZ AK 99686 VALDEZ-CORDOVA (907) 835-2249 Critical Access Hospitals Government - Local TRUE 61.1364781 -146.3458866 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-2ygw.872k~d2en 21301 652057 2019-05-30 2018-12-31 11           11       10       21
3669 3669 PROVIDENCE SEWARD HOSPITAL 417 FIRST AVENUE, PO BOX 365 SEWARD AK 99664 KENAI PENINSULA (907) 224-5205 Critical Access Hospitals Government - Local TRUE 60.1050460 -149.4453830 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-bjag~4kwr.8ihd 21302 652058 2019-05-30 2018-12-31 6           6       40       46
4484 4484 SITKA COMMUNITY HOSPITAL 209 MOLLER DRIVE SITKA AK 99835 SITKA BOROUGH (907) 747-3241 Critical Access Hospitals Government - Local TRUE 57.0589920 -135.3459290 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-asew~ba2y_nt2p 21303 638783 2018-12-03 2018-06-30 12           12       15       27
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27
4536 4536 SEARHC WRANGELL MEDICAL CENTER-CAH 310 BENNETT STREET PO BOX 1081 WRANGELL AK 99929 WRANGELL CITY AND BOROUGH (907) 874-7000 Critical Access Hospitals Government - Local FALSE 56.4716460 -132.3764140 0   275 2 2275         https://data.medicare.gov/resource/xubh-q36u/row-n33k~as59_upeg 21305 645317 2019-03-18 2018-10-31 8           8       14       22
4530 4530 CORDOVA COMMUNITY MEDICAL CENTER PO BOX 160 - 602 CHASE AVENUE CORDOVA AK 99574 VALDEZ-CORDOVA (907) 424-8000 Critical Access Hospitals Government - Local TRUE 60.5413354 -145.7505310 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-kscp_6dza~rvey 21307 650633 2019-05-30 2018-12-31 13           13       10       23
564 564 VALLEYWISE HEALTH MEDICAL CENTER 2601 EAST ROOSEVELT STREET PHOENIX AZ 85008 MARICOPA (602) 344-5011 Acute Care Hospitals Government - Local TRUE 33.4585250 -112.0264300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-c5qr_etcr-7dch 30022 661279 2018-12-03 2018-06-30 211 20   19 13   323 241             564
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
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
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
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
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
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
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
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
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
2780 2780 SANTA CLARA VALLEY MEDICAL CENTER 751 SOUTH BASCOM AVENUE SAN JOSE CA 95128 SANTA CLARA (408) 885-5000 Acute Care Hospitals Government - Local TRUE 37.3137020 -121.9318880 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-uh57.f27a-8g3n 50038 662012 2019-12-04 2019-06-30 728 35 12 8 8 47 852 48 50   24       974
994 994 EL CENTRO REGIONAL MEDICAL CENTER 1415 ROSS AVENUE EL CENTRO CA 92243 IMPERIAL (760) 339-7100 Acute Care Hospitals Government - Local TRUE 32.7814980 -115.5686200 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-35st~i7ay-x3eh 50045 660164 2019-12-02 2019-06-30 141 20         161               161
2683 2683 SAN MATEO MEDICAL CENTER 222 W 39TH AVE SAN MATEO CA 94403 SAN MATEO (650) 573-2222 Acute Care Hospitals Government - Local TRUE 37.5301160 -122.2994060 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-n83i.z2gh_aca4 50113 660755 2018-12-03 2018-06-30 93 7         100 34     374       508
3420 3420 VENTURA COUNTY MEDICAL CENTER 300 HILLMONT AVENUE VENTURA CA 93003 VENTURA (805) 652-6075 Acute Care Hospitals Government - Local TRUE 34.2790550 -119.2543550 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-8hxa_nmwp_zdmb 50159 662323 2018-12-03 2018-06-30 196 52       24 272               272
2594 2594 SAN JOAQUIN GENERAL HOSPITAL 500 W HOSPITAL ROAD FRENCH CAMP CA 95231 SAN JOAQUIN (209) 468-6000 Acute Care Hospitals Government - Local TRUE 37.8864920 -121.2820610 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-imza-7dfi-q9b9 50167 661140 2019-12-02 2019-06-30 155 16       25 196               196
2564 2564 ZUCKERBERG SAN FRANCISCO GENERAL HOSP & TRAUMA CTR 1001 POTRERO AVENUE SAN FRANCISCO CA 94110 SAN FRANCISCO (415) 206-8000 Acute Care Hospitals Government - Local TRUE 37.7561710 -122.4066080 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-zbv8_bttg_wjmw 50228 662022 2019-12-03 2019-06-30 213 58       13 284 83     30       397
2427 2427 ARROWHEAD REGIONAL MEDICAL CENTER 400 NORTH PEPPER AVENUE COLTON CA 92324 SAN BERNARDINO (909) 580-1000 Acute Care Hospitals Government - Local TRUE 34.0728840 -117.3528330 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-w78g-jnyb.b7ix 50245 662024 2019-11-27 2019-06-30 274 32   14 16 30 366 90             456
587 587 CONTRA COSTA REGIONAL MEDICAL CENTER 2500 ALHAMBRA AVENUE MARTINEZ CA 94553 CONTRA COSTA (925) 370-5000 Acute Care Hospitals Government - Local TRUE 38.0064670 -122.1308910 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-iuri_7t24.rw23 50276 660491 2019-12-02 2019-06-30 110 8       6 124 23             147
2286 2286 RIVERSIDE UNIVERSITY HEALTH SYSTEM-MEDICAL CENTER 26520 CACTUS AVENUE MORENO VALLEY CA 92555 RIVERSIDE (951) 486-4000 Acute Care Hospitals Government - Local TRUE 33.9100540 -117.1958240 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-h5qt.qee8.h53s 50292 662336 2018-12-28 2018-06-30 354 45       8 439               439
2125 2125 UNIVERSITY OF CALIFORNIA IRVINE MED CENTER 101 CITY DRIVE SOUTH ORANGE CA 92868 ORANGE (714) 456-6112 Acute Care Hospitals Government - Local TRUE 33.7801110 -117.8943030 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-rbt4-6ucg-c9d4 50348 659757 2019-11-26 2019-06-30 242 50 10 8     352 48 14           414
1636 1636 MARINHEALTH MEDICAL CENTER 250 BON AIR ROAD, PO BOX 8010 GREENBRAE CA 94904 MARIN (415) 925-7900 Acute Care Hospitals Government - Local TRUE 37.9488840 -122.5358970 0   41 6 6041 41860 San Jose-San Francisco-Oakland, CA Central Marin County https://data.medicare.gov/resource/xubh-q36u/row-dkgh~wvb6.ei3e 50360 650650 2019-05-30 2018-12-31 164 10 36     8 218 17             235
1473 1473 LAC+USC MEDICAL CENTER 1200 N STATE ST, ROOM C2K100 LOS ANGELES CA 90033 LOS ANGELES (323) 226-2800 Acute Care Hospitals Government - Local TRUE 34.0598720 -118.2103080 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zb2x~3wn3~q6ug 50373 662473 2019-12-03 2019-06-30 396 128 10 20     594 76             670
1475 1475 LAC/HARBOR-UCLA MED CENTER 1000 W CARSON ST TORRANCE CA 90502 LOS ANGELES (310) 222-2101 Acute Care Hospitals Government - Local TRUE 33.8315830 -118.2945460 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-5whm.24nh_dyri 50376 662474 2019-12-03 2019-06-30 311 46 6       390 38             428
2127 2127 FAIRVIEW DEVELOPMENTAL CENTER 2501 HARBOR BOULEVARD COSTA MESA CA 92626 ORANGE (714) 957-5000 Acute Care Hospitals Government - Local FALSE 33.6649120 -117.9192670 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-gyrb-ji8k_8vsj 50548 638176 2018-11-27 2018-06-30 30           30           1151   1181
2557 2557 LAGUNA HONDA HOSPITAL & REHABILITATION CENTER 375 LAGUNA HONDA BLVD SAN FRANCISCO CA 94116 SAN FRANCISCO (415) 759-2300 Acute Care Hospitals Government - Local FALSE 37.7478240 -122.4586360 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-tz44~vi64-ys8h 50668 662169 2019-12-02 2019-06-30 6           6   5   769       780
1483 1483 LAC/RANCHO LOS AMIGOS NATIONAL REHABILITATION CTR 7601 EAST IMPERIAL HIGHWAY DOWNEY CA 90242 LOS ANGELES (562) 401-7022 Acute Care Hospitals Government - Local FALSE 33.9293317 -118.1585885 1 ROOFTOP 37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rfj5_pyf7~7bni 50717 662350 2018-12-03 2018-06-30 89 12         101   109           210
3085 3085 SONOMA SPECIALTY HOSPITAL 501 PETALUMA AVENUE SEBASTOPOL CA 95472 SONOMA (707) 823-8511 Acute Care Hospitals Government - Local TRUE 38.3971390 -122.8204370 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-57b8_at7i-gjwt 50781 659918 2019-07-26 2019-03-31 32 5         37               37
1829 1829 SURPRISE VALLEY COMMUNITY HOSPITAL 741 NORTH MAIN STREET CEDARVILLE CA 96104 MODOC (530) 279-6111 Critical Access Hospitals Government - Local TRUE 41.5319310 -120.1718990 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-cdww_rq6r_6v4q 51308 662485 2019-12-23 2019-06-30 4           4       22       26
1639 1639 UNIVERSITY COLO HEALTH MEMORIAL HOSPITAL CENTRAL 1400 E BOULDER ST COLORADO SPRINGS CO 80909 EL PASO (719) 365-5000 Acute Care Hospitals Government - Local TRUE 38.8388120 -104.7999510 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-a2ae-uent-g89f 60022 659639 2019-11-26 2019-06-30 385 46         515   22           537
1133 1133 DELTA COUNTY MEMORIAL HOSPITAL 1501 E 3RD ST DELTA CO 81416 DELTA (970) 874-7681 Acute Care Hospitals Government - Local TRUE 38.7431660 -108.0475150 0   29 8 8029         https://data.medicare.gov/resource/xubh-q36u/row-wsed.7ysa~nwhq 60071 649875 2019-05-31 2018-12-31 43 6         49               49
2180 2180 WEISBROD MEMORIAL COUNTY HOSPITAL 1208 LUTHER STREET EADS CO 81036 KIOWA (719) 438-5401 Critical Access Hospitals Government - Local TRUE 38.4801980 -102.7844680 0   61 8 8061         https://data.medicare.gov/resource/xubh-q36u/row-7uhk-bw28_6b9m 61300 647281 2019-05-08 2018-12-31 25           25               25
3520 3520 SEDGWICK COUNTY MEMORIAL HOSPITAL 900 CEDAR ST JULESBURG CO 80737 SEDGWICK (970) 474-3323 Critical Access Hospitals Government - Local FALSE 40.9937430 -102.2692320 0   115 8 8115         https://data.medicare.gov/resource/xubh-q36u/row-ptjm_bmz6~8mzz 61310 649075 2019-05-22 2018-12-31 9           9         32     41
2688 2688 MEMORIAL HOSPITAL, THE 750 HOSPITAL LOOP CRAIG CO 81625 MOFFAT (970) 824-9411 Critical Access Hospitals Government - Local TRUE 40.5182880 -107.5786300 0   81 8 8081 18780 Steamboat Springs-Craig, CO Central Moffat County https://data.medicare.gov/resource/xubh-q36u/row-6iax~u2kg-fk39 61314 647645 2019-05-13 2018-12-31 25           25               25
1892 1892 GUNNISON VALLEY HOSPITAL 711 NORTH TAYLOR STREET GUNNISON CO 81230 GUNNISON (970) 641-1456 Critical Access Hospitals Government - Local TRUE 38.5510890 -106.9243210 0   51 8 8051         https://data.medicare.gov/resource/xubh-q36u/row-e9p4-pdcf.rn62 61320 650438 2019-05-31 2018-12-31 20           20               20
145 145 JOHN DEMPSEY HOSPITAL 263 FARMINGTON AVE FARMINGTON CT 6032 HARTFORD (860) 679-1145 Acute Care Hospitals Government - Local TRUE 41.7350900 -72.7958200 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-dhzf~ccfg~faa5 70036 661473 2019-11-27 2019-06-30 118 20         138 18             156
1533 1533 GEORGE E WEEMS MEMORIAL HOSPITAL 135 AVE G APALACHICOLA FL 32320 FRANKLIN (850) 653-8853 Critical Access Hospitals Government - Local TRUE 29.7244840 -84.9912750 0   37 12 12037         https://data.medicare.gov/resource/xubh-q36u/row-z2w8_ts6n.p4qb 101305 644253 2019-03-04 2018-09-30 25           25               25
3887 3887 NORTHEAST GEORGIA MEDICAL CENTER, INC 743 SPRING STREET GAINESVILLE GA 30501 HALL (770) 535-3553 Acute Care Hospitals Government - Local TRUE 34.3033500 -83.8173700 0   139 13 13139 23580 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Hall County https://data.medicare.gov/resource/xubh-q36u/row-7syr~f3ei~dkan 110029 645060 2019-03-01 2018-09-30 460 85         545 54 24   261       884
731 731 DORMINY MEDICAL CENTER 200 PERRY HOUSE ROAD, BOX 1447 FITZGERALD GA 31750 BEN HILL (229) 424-7100 Acute Care Hospitals Government - Local TRUE 31.6979180 -83.2609750 0   17 13 13017 22340   Central Ben Hill County https://data.medicare.gov/resource/xubh-q36u/row-x5tq.yugi-ym8v 110073 658241 2019-01-02 2018-07-31 43 5         48 12             60
4117 4117 JASPER MEMORIAL HOSPITAL 898 COLLEGE STREET MONTICELLO GA 31064 JASPER (706) 468-6411 Critical Access Hospitals Government - Local TRUE 33.3139820 -83.6868770 0   159 13 13159 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-7m3n_3mxm~mxsc 111303 645064 2019-03-04 2018-09-30 12           12       55       67
2298 2298 CLINCH MEMORIAL HOSPITAL 1050 VALDOSTA HIGHWAY HOMERVILLE GA 31634 CLINCH (912) 487-5211 Critical Access Hospitals Government - Local TRUE 31.0326510 -82.7638580 0   65 13 13065         https://data.medicare.gov/resource/xubh-q36u/row-6x28-ujdc_jsi5 111308 659942 2019-11-27 2019-06-30 15           15               15
2299 2299 MADISON MEMORIAL HOSPITAL 450 EAST MAIN STREET REXBURG ID 83440 MADISON (208) 359-6900 Acute Care Hospitals Government - Local TRUE 43.8260510 -111.7731480 0   65 16 16065 39940 Idaho Falls-Rexburg-Blackfoot, ID Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-x7qh_3ndv.ii77 130025 643024 2019-02-05 2018-09-30 49 4         67               67
2320 2320 NELL J REDFIELD MEMORIAL HOSPITAL 150 NORTH 200 WEST MALAD ID 83252 ONEIDA (208) 766-2231 Critical Access Hospitals Government - Local TRUE 42.1896380 -112.2507590 0   71 16 16071         https://data.medicare.gov/resource/xubh-q36u/row-dtun.jgpu~2hmu 131303 662195 2019-11-26 2019-06-30 11           11       33       44
2135 2135 STEELE MEMORIAL MEDICAL CENTER 203 SOUTH DAISY STREET SALMON ID 83467 LEMHI (208) 756-5600 Critical Access Hospitals Government - Local TRUE 45.1733110 -113.8909180 0   59 16 16059         https://data.medicare.gov/resource/xubh-q36u/row-frkw_jutq_kwk4 131305 645073 2019-03-05 2018-09-30 18           18               18
1134 1134 CARIBOU MEMORIAL HOSPITAL 300 SOUTH 3RD WEST SODA SPRINGS ID 83276 CARIBOU (208) 547-3341 Critical Access Hospitals Government - Local TRUE 42.6522350 -111.6133540 0   29 16 16029         https://data.medicare.gov/resource/xubh-q36u/row-k69a-4kn6-dfne 131309 644028 2019-02-28 2018-09-30 25           25       30       55
352 352 BEAR LAKE MEMORIAL HOSPITAL 164 SOUTH FIFTH STREET MONTPELIER ID 83254 BEAR LAKE (208) 847-1630 Critical Access Hospitals Government - Local TRUE 42.3162420 -111.3008470 0   7 16 16007         https://data.medicare.gov/resource/xubh-q36u/row-mggi-9epd.588z 131316 647888 2019-05-16 2018-12-31 21           21       36   32   89
428 428 BENEWAH COMMUNITY HOSPITAL 229 SOUTH 7TH STREET ST MARIES ID 83861 BENEWAH (208) 245-5551 Critical Access Hospitals Government - Local TRUE 47.3146130 -116.5666780 0   9 16 16009         https://data.medicare.gov/resource/xubh-q36u/row-3wfv~5stn~5t7d 131317 652074 2019-05-24 2018-12-31 19           19               19
1731 1731 VALOR HEALTH 1202 EAST LOCUST STREET EMMETT ID 83617 GEM (208) 365-3561 Critical Access Hospitals Government - Local TRUE 43.8790780 -116.4852550 0   45 16 16045 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Gem County https://data.medicare.gov/resource/xubh-q36u/row-cch8-kmmd-nmhb 131318 644635 2019-02-28 2018-09-30 13           13               13
2345 2345 MINIDOKA MEMORIAL HOSPITAL 1224 8TH STREET RUPERT ID 83350 MINIDOKA (208) 436-0481 Critical Access Hospitals Government - Local TRUE 42.6196250 -113.6853620 0   67 16 16067 15420   Outlying Minidoka County https://data.medicare.gov/resource/xubh-q36u/row-m4t9~2798.xb46 131319 643405 2019-02-26 2018-09-30 16           16       46       62
1641 1641 FRANKLIN COUNTY MEDICAL CENTER 44 NORTH FIRST EAST PRESTON ID 83263 FRANKLIN (208) 852-0137 Critical Access Hospitals Government - Local TRUE 42.0983790 -111.8754670 0   41 16 16041 30860   Outlying Franklin County https://data.medicare.gov/resource/xubh-q36u/row-9du2~qaxa~z8nm 131322 645243 2019-03-08 2018-09-30 20           20       35       55
4376 4376 CGH MEDICAL CENTER 100 EAST LEFEVRE ROAD STERLING IL 61081 WHITESIDE (815) 625-0400 Acute Care Hospitals Government - Local TRUE 41.8015640 -89.6967330 0   195 17 17195 44580 Dixon-Sterling, IL Central Whiteside County https://data.medicare.gov/resource/xubh-q36u/row-r8ij~7z4w-xsmp 140043 654428 2019-09-25 2019-04-30 87 9         96               96
2744 2744 JERSEY COMMUNITY HOSPITAL 400 MAPLE SUMMIT ROAD JERSEYVILLE IL 62052 JERSEY (618) 498-6402 Acute Care Hospitals Government - Local TRUE 39.1099060 -90.3416220 0   83 17 17083 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Jersey County https://data.medicare.gov/resource/xubh-q36u/row-4rjp~camg~jz6s 140059 660513 2019-11-27 2019-06-30 42 4         46               46
1220 1220 JOHN H STROGER JR HOSPITAL 1901 W HARRISON ST CHICAGO IL 60612 COOK (312) 864-6000 Acute Care Hospitals Government - Local TRUE 41.8740410 -87.6743110 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-2ss5~bvsp.bpf4 140124 659251 2019-11-07 2018-11-30 310 32   8 14   448               448
4132 4132 GENESIS HEALTH SYSTEM 801 ILLINI DR SILVIS IL 61282 ROCK ISLAND (309) 281-4000 Acute Care Hospitals Government - Local TRUE 41.4930680 -90.4199970 0   161 17 17161 19340 Davenport-Moline, IA-IL Central Rock Island County https://data.medicare.gov/resource/xubh-q36u/row-wxqw_k6y5~djg4 140275 654836 2019-09-24 2019-06-30 138 7         145       92 28     265
1225 1225 PROVIDENT HOSPITAL OF CHICAGO 500 E 51ST ST CHICAGO IL 60615 COOK (312) 572-2000 Acute Care Hospitals Government - Local TRUE 41.8021580 -87.6141930 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-knkg_mg7f-2emf 140300 659411 2019-11-05 2018-11-30 25           25               25
1587 1587 WARNER HOSPITAL AND HEALTH SERVICES 422 W WHITE ST CLINTON IL 61727 DE WITT (217) 935-9571 Critical Access Hospitals Government - Local TRUE 40.1489530 -88.9646160 0   39 17 17039 14010 Bloomington-Pontiac, IL Outlying De Witt County https://data.medicare.gov/resource/xubh-q36u/row-gzhh-tmyy.cr8h 141303 654575 2019-09-26 2019-04-30 15           15               15
502 502 PERRY MEMORIAL HOSPITAL 530 PARK AVENUE EAST PRINCETON IL 61356 BUREAU (815) 875-2811 Critical Access Hospitals Government - Local TRUE 41.3680100 -89.4559580 0   11 17 17011 36860 Chicago-Naperville, IL-IN-WI Central Bureau County https://data.medicare.gov/resource/xubh-q36u/row-93jr-f3xy_p6h2 141337 654839 2019-09-30 2019-04-30 22 3         25               25
3639 3639 SALEM TOWNSHIP HOSPITAL 1201 RICKER DRIVE SALEM IL 62881 MARION (618) 548-3194 Critical Access Hospitals Government - Local TRUE 38.6408300 -88.9483370 0   121 17 17121 16460 St. Louis-St. Charles-Farmington, MO-IL Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-ha9g~pxnq-kea7 141345 654203 2019-09-09 2019-03-31 25           25               25
996 996 CLAY COUNTY HOSPITAL 911 STACY BURK DRIVE FLORA IL 62839 CLAY (618) 662-2131 Critical Access Hospitals Government - Local TRUE 38.6809170 -88.4703370 0   25 17 17025         https://data.medicare.gov/resource/xubh-q36u/row-waac_79mj~znty 141351 653013 2019-08-02 2019-02-28 20           20               20
2696 2696 JOHNSON MEMORIAL HOSPITAL 1125 W JEFFERSON ST FRANKLIN IN 46131 JOHNSON (317) 736-3300 Acute Care Hospitals Government - Local TRUE 39.4805980 -86.0766630 0   81 18 18081 26900 Indianapolis-Carmel-Muncie, IN Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-gz4n-xn3z~kiqn 150001 649201 2019-05-31 2018-12-31 77 6         83   11           94
2246 2246 HENDRICKS REGIONAL HEALTH 1000 E MAIN ST DANVILLE IN 46122 HENDRICKS (317) 745-4451 Acute Care Hospitals Government - Local TRUE 39.7607100 -86.5009950 0   63 18 18063 26900 Indianapolis-Carmel-Muncie, IN Central Hendricks County https://data.medicare.gov/resource/xubh-q36u/row-7pz3-j79y~ybxb 150005 649202 2019-05-31 2018-12-31 121 12         133               133
1588 1588 ELKHART GENERAL HOSPITAL 600 E BLVD ELKHART IN 46514 ELKHART (574) 294-2621 Acute Care Hospitals Government - Local TRUE 41.6787610 -85.9918330 0   39 18 18039 21140 South Bend-Elkhart-Mishawaka, IN-MI Central Elkhart County https://data.medicare.gov/resource/xubh-q36u/row-xq9p.barv.suqr 150018 649560 2019-06-03 2018-12-31 169 23         200 10 20           230
3099 3099 ESKENAZI HEALTH 720 ESKENAZI AVENUE INDIANAPOLIS IN 46202 MARION (317) 880-4818 Acute Care Hospitals Government - Local TRUE 39.7805300 -86.1734500 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-fv8t.e66e-c8mj 150024 649564 2019-06-03 2018-12-31 192 72   15     316 20             336
2301 2301 HENRY COUNTY MEMORIAL HOSPITAL 1000 N 16TH ST NEW CASTLE IN 47362 HENRY (765) 521-0890 Acute Care Hospitals Government - Local TRUE 39.9424740 -85.3650100 0   65 18 18065 35220 Indianapolis-Carmel-Muncie, IN Central Henry County https://data.medicare.gov/resource/xubh-q36u/row-7hck_n6zg-4n7p 150030 649565 2019-06-03 2018-12-31 38 10         48               48
2136 2136 HANCOCK REGIONAL HOSPITAL 801 N STATE ST GREENFIELD IN 46140 HANCOCK (317) 462-5544 Acute Care Hospitals Government - Local TRUE 39.7949520 -85.7696040 0   59 18 18059 26900 Indianapolis-Carmel-Muncie, IN Central Hancock County https://data.medicare.gov/resource/xubh-q36u/row-9wnz_ckw6~khmk 150037 649205 2019-05-31 2018-12-31 37 24         61 10         7   78
2063 2063 RIVERVIEW HEALTH 395 WESTFIELD RD NOBLESVILLE IN 46060 HAMILTON (317) 773-0760 Acute Care Hospitals Government - Local TRUE 40.0470260 -86.0240810 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-2tme-mzbr.en9s 150059 659262 2019-05-30 2018-12-31 94 15         109   24   25       158
1069 1069 DAVIESS COMMUNITY HOSPITAL 1314 E WALNUT ST WASHINGTON IN 47501 DAVIESS (812) 254-2760 Acute Care Hospitals Government - Local TRUE 38.6586950 -87.1603190 0   27 18 18027 47780   Central Daviess County https://data.medicare.gov/resource/xubh-q36u/row-khjv_h54z-usqa 150061 649895 2019-06-03 2018-12-31 37 5         42 20 12           74
2455 2455 SCHNECK MEDICAL CENTER 411 W TIPTON ST SEYMOUR IN 47274 JACKSON (812) 522-2349 Acute Care Hospitals Government - Local TRUE 38.9567340 -85.8913560 0   71 18 18071 42980 Indianapolis-Carmel-Muncie, IN Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-4xmk-877m-humv 150065 648683 2019-05-28 2018-12-31 84 7         91           2   93
733 733 MEMORIAL HOSPITAL 1101 MICHIGAN AVE LOGANSPORT IN 46947 CASS (574) 753-7541 Acute Care Hospitals Government - Local TRUE 40.7624650 -86.3612460 0   17 18 18017 30900   Central Cass County https://data.medicare.gov/resource/xubh-q36u/row-wqwj~vb9b_viec 150072 646907 2019-04-05 2018-12-31 39 5         44               44
1136 1136 HIGHPOINT HEALTH 600 WILSON CREEK RD LAWRENCEBURG IN 47025 DEARBORN (812) 537-1010 Acute Care Hospitals Government - Local TRUE 39.1129220 -84.8839510 0   29 18 18029 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Outlying Dearborn County https://data.medicare.gov/resource/xubh-q36u/row-ngjg.xy9w~6uaw 150086 649567 2019-06-03 2018-12-31 78 8         86               86
3970 3970 MAJOR HOSPITAL 2451 INTELLIPLEX DR SHELBYVILLE IN 46176 SHELBY (317) 392-3211 Acute Care Hospitals Government - Local TRUE 39.5600170 -85.7839700 0   145 18 18145 26900 Indianapolis-Carmel-Muncie, IN Outlying Shelby County https://data.medicare.gov/resource/xubh-q36u/row-r4ki.27zg-ps3s 150097 659263 2019-05-30 2018-12-31 40 6         46               46
503 503 WITHAM HEALTH SERVICES 2605 N LEBANON ST LEBANON IN 46052 BOONE (765) 485-8000 Acute Care Hospitals Government - Local TRUE 40.0769090 -86.4752090 0   11 18 18011 26900 Indianapolis-Carmel-Muncie, IN Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-gfq5-5jsq-rtmb 150104 649208 2019-05-31 2018-12-31 60 8         68 10     18       96
273 273 COLUMBUS REGIONAL HOSPITAL 2400 E 17TH ST COLUMBUS IN 47201 BARTHOLOMEW (812) 379-4441 Acute Care Hospitals Government - Local TRUE 39.2158720 -85.8968540 0   5 18 18005 18020 Indianapolis-Carmel-Muncie, IN Central Bartholomew County https://data.medicare.gov/resource/xubh-q36u/row-u4i5.cqhh_8kd8 150112 649209 2019-05-31 2018-12-31 194 17         211   18           229
3888 3888 RUSH MEMORIAL HOSPITAL 1300 N MAIN ST RUSHVILLE IN 46173 RUSH (765) 932-7513 Critical Access Hospitals Government - Local TRUE 39.6214420 -85.4447920 0   139 18 18139         https://data.medicare.gov/resource/xubh-q36u/row-bit2.6ykr-x2sd 151304 649573 2019-06-03 2018-12-31 25           25               25
1835 1835 WOODLAWN HOSPITAL 1400 E 9TH ST ROCHESTER IN 46975 FULTON (574) 223-3141 Critical Access Hospitals Government - Local TRUE 41.0617280 -86.1969730 0   49 18 18049         https://data.medicare.gov/resource/xubh-q36u/row-2dgz-xb34_49d2 151313 649096 2019-05-31 2018-12-31 21 4         25               25
2001 2001 GREENE COUNTY GENERAL HOSPITAL 1185 N 1000 W LINTON IN 47441 GREENE (812) 847-2281 Critical Access Hospitals Government - Local TRUE 39.0404960 -87.1291760 0   55 18 18055         https://data.medicare.gov/resource/xubh-q36u/row-9x2i_4s3n~qf9x 151317 652137 2019-07-08 2018-12-31 20 5         25               25
2570 2570 IU HEALTH JAY 500 W VOTAW ST PORTLAND IN 47371 JAY (260) 726-7131 Critical Access Hospitals Government - Local TRUE 40.4393660 -84.9841050 0   75 18 18075         https://data.medicare.gov/resource/xubh-q36u/row-krfy-myt9_8mki 151320 648822 2019-05-28 2018-12-31 25           25 10             35
4052 4052 SULLIVAN COUNTY COMMUNITY HOSPITAL 2200 N SECTION ST SULLIVAN IN 47882 SULLIVAN (812) 268-4311 Critical Access Hospitals Government - Local TRUE 39.1262540 -87.4090830 0   153 18 18153 45460   Outlying Sullivan County https://data.medicare.gov/resource/xubh-q36u/row-3wdp~nzis.krga 151327 659268 2019-10-21 2018-12-31 21 4         25               25
88 88 ADAMS MEMORIAL HOSPITAL 1100 MERCER AVE DECATUR IN 46733 ADAMS (260) 724-2145 Critical Access Hospitals Government - Local TRUE 40.8179660 -84.9125350 0   1 18 18001 19540 Fort Wayne-Huntington-Auburn, IN Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-vdys.bcxa-gdh7 151330 649100 2019-05-30 2018-12-31 21 4         25               25
2183 2183 HARRISON COUNTY HOSPITAL 1141 HOSPITAL DR NW CORYDON IN 47112 HARRISON (812) 738-4251 Critical Access Hospitals Government - Local TRUE 38.2389800 -86.1477400 0   61 18 18061 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Outlying Harrison County https://data.medicare.gov/resource/xubh-q36u/row-thvf-3t8n.6234 151331 651945 2019-07-03 2018-12-31 21 4         25               25
1265 1265 DECATUR COUNTY MEMORIAL HOSPITAL 720 N LINCOLN ST GREENSBURG IN 47240 DECATUR (812) 663-4331 Critical Access Hospitals Government - Local TRUE 39.3441160 -85.4794040 0   31 18 18031 24700 Indianapolis-Carmel-Muncie, IN Central Decatur County https://data.medicare.gov/resource/xubh-q36u/row-hqis.arxf_g2ap 151332 649101 2019-05-31 2018-12-31 25           25               25
3826 3826 PUTNAM COUNTY HOSPITAL 1542 S BLOOMINGTON ST GREENCASTLE IN 46135 PUTNAM (765) 301-7300 Critical Access Hospitals Government - Local TRUE 39.6222050 -86.8459960 0   133 18 18133 26900 Indianapolis-Carmel-Muncie, IN Outlying Putnam County https://data.medicare.gov/resource/xubh-q36u/row-fms7~r4c2~ehse 151333 646332 2019-04-01 2018-12-31 19 6         25               25
4055 4055 BROADLAWNS MEDICAL CENTER 1801 HICKMAN ROAD DES MOINES IA 50314 POLK (515) 282-2200 Acute Care Hospitals Government - Local TRUE 41.6150970 -93.6411550 0   153 19 19153 19780 Des Moines-Ames-West Des Moines, IA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-dzd6.727y_ubfk 160101 659567 2019-11-22 2019-06-30 111 6         117               117
1643 1643 SPENCER MUNICIPAL HOSPITAL 1200 1ST AVENUE EAST SPENCER IA 51301 CLAY (712) 264-8300 Acute Care Hospitals Government - Local TRUE 43.1500090 -95.1438420 0   41 19 19041 43980   Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-nipj.ewp3-j7u2 160112 660216 2019-11-25 2019-06-30 49           49 15             64
4389 4389 IOWA SPECIALTY HOSPITAL - BELMOND 403 FIRST STREET SE BELMOND IA 50421 WRIGHT (641) 444-3223 Critical Access Hospitals Government - Local TRUE 42.8449880 -93.6128550 0   197 19 19197         https://data.medicare.gov/resource/xubh-q36u/row-8b8k.b5cg~72n2 161301 659568 2019-11-22 2019-06-30 22           22               22
4390 4390 IOWA SPECIALTY HOSPITAL-CLARION 1316 SOUTH MAIN STREET CLARION IA 50525 WRIGHT (515) 532-2811 Critical Access Hospitals Government - Local TRUE 42.7216250 -93.7326280 0   197 19 19197         https://data.medicare.gov/resource/xubh-q36u/row-qm5h-kjf7~8unb 161302 661176 2019-12-02 2019-06-30 25           25               25
4031 4031 POCAHONTAS COMMUNITY HOSPITAL 606 N W 7TH STREET POCAHONTAS IA 50574 POCAHONTAS (712) 335-3501 Critical Access Hospitals Government - Local TRUE 42.7408220 -94.6787780 0   151 19 19151         https://data.medicare.gov/resource/xubh-q36u/row-mhbi~vwku-j27n 161305 659787 2019-11-25 2019-06-30 25           25               25
2697 2697 HANCOCK COUNTY HEALTH SYSTEM 532 1ST ST NW BRITT IA 50423 HANCOCK (641) 843-5000 Critical Access Hospitals Government - Local TRUE 43.0978180 -93.8069930 0   81 19 19081         https://data.medicare.gov/resource/xubh-q36u/row-i3sh.fr5p_6qsp 161307 661324 2019-11-29 2019-06-30 25           25               25
2399 2399 FRANKLIN GENERAL HOSPITAL 1720 CENTRAL AVENUE EAST HAMPTON IA 50441 FRANKLIN (641) 456-5000 Critical Access Hospitals Government - Local TRUE 42.7414070 -93.1867630 0   69 19 19069         https://data.medicare.gov/resource/xubh-q36u/row-acr5.brk4.hide 161308 661178 2019-11-29 2019-06-30 25           25         52     77
69 69 ADAIR COUNTY MEMORIAL HOSPITAL 609 SE KENT GREENFIELD IA 50849 ADAIR (641) 743-2123 Critical Access Hospitals Government - Local TRUE 41.3031030 -94.4519270 0   1 19 19001         https://data.medicare.gov/resource/xubh-q36u/row-3dt7_nstz~yhhy 161310 660956 2019-12-02 2019-06-30 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
);