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

212 rows where "filed_date" is on date 2019-11-26 sorted by hospital_name

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date)

  • 2019-11-26 · 212
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
1996 ADVENTHEALTH SEBRING 4200 SUN N LAKE BLVD SEBRING FL 33871 HIGHLANDS (863) 314-4466 Acute Care Hospitals Voluntary non-profit - Church FALSE 27.5384550 -81.5068810 0   55 12 12055 42700   Central Highlands County https://data.medicare.gov/resource/xubh-q36u/row-kk9t~8fs5~ksmj 100109 661479 2019-11-26 2018-12-31 158 22         180 17             197
3389 ALLIANCEHEALTH MIDWEST 2825 PARKLAWN DRIVE MIDWEST CITY OK 73110 OKLAHOMA (405) 610-8585 Acute Care Hospitals Proprietary TRUE 35.4665270 -97.3929250 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-sxg9_cifn-7qv9 370094 660692 2019-11-26 2019-06-30 212 24         236 19             255
701 ARTESIA GENERAL HOSPITAL 702 N 13TH STREET ARTESIA NM 88210 EDDY (575) 748-3333 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8486030 -104.4127520 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-t6vu-yth8.bk8u 320030 659993 2019-11-26 2019-06-30 34           34 15             49
2467 ASPIRUS IRON RIVER HOSPITAL & CLINICS, INC 1400 W ICE LAKE ROAD IRON RIVER MI 49935 IRON (906) 265-6121 Critical Access Hospitals Voluntary non-profit - Other TRUE 46.0997200 -88.6202810 0   71 26 26071         https://data.medicare.gov/resource/xubh-q36u/row-5hmu-6w8t_e66h 231318 660105 2019-11-26 2019-06-30 22 3         25               25
1954 ASPIRUS IRONWOOD HOSPITAL N10561 GRAND VIEW LANE IRONWOOD MI 49938 GOGEBIC (906) 932-2525 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4781930 -90.1046890 0   53 26 26053         https://data.medicare.gov/resource/xubh-q36u/row-kai4_hwh9~ugv4 231333 660107 2019-11-26 2019-06-30 20 5         25               25
2191 ASPIRUS KEWEENAW HOSPITAL 205 OSCEOLA LAURIUM MI 49913 HOUGHTON (906) 337-6500 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2375380 -88.4440380 0   61 26 26061 26340   Central Houghton County https://data.medicare.gov/resource/xubh-q36u/row-p9jg_yiuy~c7z4 231319 660600 2019-11-26 2019-06-30 20 5         25               25
3810 ASPIRUS ONTONAGON HOSPITAL, INC 601 S SEVENTH ST ONTONAGON MI 49953 ONTONAGON (906) 884-8000 Critical Access Hospitals Government - Local TRUE 46.8656350 -89.3029760 0   131 26 26131         https://data.medicare.gov/resource/xubh-q36u/row-zhnw-wptd-d4w4 231309 660103 2019-11-26 2019-06-30 25           25       46       71
3181 AVERA DELLS AREA HOSPITAL - CAH 909 N IOWA AVE DELL RAPIDS SD 57022 MINNEHAHA (605) 428-5431 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8285880 -96.7153440 0   99 46 46099 43620   Central Minnehaha County https://data.medicare.gov/resource/xubh-q36u/row-9ckr.kcaf_sjek 431331 660036 2019-11-26 2019-06-30 21           21               21
3239 AVERA FLANDREAU HOSPITAL - CAH 214 NORTH PRAIRIE STREET FLANDREAU SD 57028 MOODY (605) 997-2433 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0505680 -96.5909890 0   101 46 46101         https://data.medicare.gov/resource/xubh-q36u/row-2fiy.k67h.w2yb 431310 660033 2019-11-26 2019-06-30 18           18               18
1974 AVERA GREGORY HOSPITAL 400 PARK STREET POST OFFICE BOX 408 GREGORY SD 57533 GREGORY (605) 835-8394 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2319878 -99.4304377 1 ROOFTOP 53 46 46053         https://data.medicare.gov/resource/xubh-q36u/row-sxnm~ansc_ejzf 431338 662257 2019-11-26 2019-06-30 25           25       55       80
1429 AVERA QUEEN OF PEACE 525 N FOSTER MITCHELL SD 57301 DAVISON (605) 995-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.7138420 -98.0073250 0   35 46 46035 33580   Central Davison County https://data.medicare.gov/resource/xubh-q36u/row-vs8d.p4rg.tbmc 430013 660030 2019-11-26 2019-06-30 42 8         50       84       134
2911 AVERA ST ANTHONY'S HOSPITAL 300 NORTH 2ND ST O' NEILL NE 68763 HOLT (402) 336-5131 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.4603380 -98.6511180 0   89 31 31089         https://data.medicare.gov/resource/xubh-q36u/row-z9z2~5zkd.wkgh 281329 660645 2019-11-26 2019-06-30 25           25               25
2324 AVERA ST MARY'S HOSPITAL 801 E SIOUX PIERRE SD 57501 HUGHES (605) 224-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.3612680 -100.3422350 0   65 46 46065 38180   Central Hughes County https://data.medicare.gov/resource/xubh-q36u/row-y7ep-uymv.yumv 430015 660031 2019-11-26 2019-06-30 44 6         50       80       130
270 BACON COUNTY HOSPITAL 302 SOUTH WAYNE STREET ALMA GA 31510 BACON (912) 632-8961 Critical Access Hospitals Voluntary non-profit - Other TRUE 31.5391100 -82.4596870 0   5 13 13005         https://data.medicare.gov/resource/xubh-q36u/row-fsgt~f6fy~f5qx 111327 659492 2019-11-26 2019-06-30 21 4         25       88       113
1179 BAPTIST MEDICAL CENTER 111 DALLAS STREET SAN ANTONIO TX 78205 BEXAR (210) 297-8256 Acute Care Hospitals Proprietary TRUE 29.4328770 -98.4927730 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-9jbx_v3az~nwzz 450058 660466 2019-11-26 2019-06-30 1166 151         1457 38 72           1567
3539 BARNES-KASSON COUNTY HOSPITAL 2872 TURNPIKE STREET SUSQUEHANNA PA 18847 SUSQUEHANNA (570) 853-3135 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.9473720 -75.5940160 0   115 42 42115         https://data.medicare.gov/resource/xubh-q36u/row-jek6.26ef-dwbb 391309 659886 2019-11-26 2019-06-30 21 4         25       58       83
3905 BAYLOR SCOTT & WHITE MEDICAL CENTER- WAXAHACHIE 2400 N INTERSTATE HIGHWAY 35E WAXAHACHIE TX 75165 ELLIS (972) 923-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4296220 -96.8597360 0   139 48 48139 19100 Dallas-Fort Worth, TX-OK Central Ellis County https://data.medicare.gov/resource/xubh-q36u/row-9ydz_89ap~3znh 450372 659897 2019-11-26 2019-06-30 94 12         106               106
715 BELLVILLE ST JOSEPH HEALTH CENTER 44 N CUMMINGS ST BELLVILLE TX 77418 AUSTIN (979) 865-3141 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9522650 -96.2607470 0   15 48 48015 26420 Houston-The Woodlands, TX Outlying Austin County https://data.medicare.gov/resource/xubh-q36u/row-dtpr-rvr9.rhky 450253 662602 2019-11-26 2019-06-30 32           32               32
1561 BERWICK HOSPITAL CENTER 701 EAST 16TH STREET BERWICK PA 18603 COLUMBIA (570) 759-5020 Acute Care Hospitals Proprietary TRUE 41.0701590 -76.2308040 0   37 42 42037 14100 Bloomsburg-Berwick-Sunbury, PA Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-cn25-dn3w-iqqf 390072 660695 2019-11-26 2019-06-30 77 10         87 14     240       341
2351 BOB WILSON MEMORIAL GRANT COUNTY HOSPITAL 415 N MAIN STREET ULYSSES KS 67880 GRANT (620) 356-1266 Acute Care Hospitals Proprietary TRUE 37.5839920 -101.3580130 0   67 20 20067         https://data.medicare.gov/resource/xubh-q36u/row-8mti_jcxr_myzi 170110 660091 2019-11-26 2019-06-30 26           26               26
894 BUENA VISTA REGIONAL MEDICAL CENTER 1525 WEST 5TH STREET STORM LAKE IA 50588 BUENA VISTA (712) 732-4030 Critical Access Hospitals Government - Local TRUE 42.6443560 -95.2220080 0   21 19 19021 44740   Central Buena Vista County https://data.medicare.gov/resource/xubh-q36u/row-prcs~bkcs~7h4s 161375 660220 2019-11-26 2019-06-30 20   5       25 10             35
1295 CARRINGTON HEALTH CENTER PO BOX 461 CARRINGTON ND 58421 FOSTER (701) 652-3141 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4497201 -99.1262234 1 APPROXIMATE 31 38 38031         https://data.medicare.gov/resource/xubh-q36u/row-inkg_zfig.5z7t 351318 662239 2019-11-26 2019-06-30 25           25               25
1464 CASA COLINA HOSPITAL 255 E BONITA AVE POMONA CA 91767 LOS ANGELES (909) 596-7733 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.0962420 -117.7468610 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rhgb.p6kp-nbju 50782 662170 2019-11-26 2019-03-31 25 6         31   68           99
1523 CEDAR-SINAI MARINA DEL REY HOSPITAL 4650 LINCOLN BLVD MARINA DEL REY CA 90291 LOS ANGELES (310) 823-8911 Acute Care Hospitals Proprietary FALSE 33.9817320 -118.4401540 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-izeb-yvf9_zc9q 50740 660492 2019-11-26 2019-06-30 91 12         103               103
4233 CENTRACARE HEALTH - MONTICELLO 1013 HART BOULEVARD MONTICELLO MN 55362 WRIGHT (763) 295-2945 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3001700 -93.7791070 0   171 27 27171 33460 Minneapolis-St. Paul, MN-WI Central Wright County https://data.medicare.gov/resource/xubh-q36u/row-8yik_ujc7-cau4 241362 660614 2019-11-26 2019-06-30 22 3         25 10     89       124
4060 CENTRACARE HEALTH SYSTEM - LONG PRAIRIE 50 CENTRACARE DRIVE LONG PRAIRIE MN 56347 TODD (320) 732-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9733659 -94.8429923 1 ROOFTOP 153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-auf6_7hb8_cyed 241326 660609 2019-11-26 2019-06-30 14           14       70       84
3979 CENTRACARE HEALTH SYSTEM - SAUK CENTRE 425 NORTH ELM STREET SAUK CENTRE MN 56378 STEARNS (320) 352-2221 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.7458900 -94.9545670 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-u3rf_ytjj_n5bm 241368 660615 2019-11-26 2019-06-30 24           24       60       84
1638 CENTURA HEALTH-PENROSE-ST FRANCIS HEALTH SERVICES 2222 NORTH NEVADA AVE COLORADO SPRINGS CO 80907 EL PASO (719) 776-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8655680 -104.8201230 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-gqx3~746f~9uqw 60031 659763 2019-11-26 2019-06-30 354 45         445   23           468
2129 CENTURA HEALTH-ST ANTHONY HOSPITAL 11600 WEST 2ND PLC LAKEWOOD CO 80228 JEFFERSON (720) 321-0000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7179560 -105.1274940 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-hs5j-ymh4.6b3z 60015 659760 2019-11-26 2019-06-30 144 28     48   220   17           237
3193 CENTURA HEALTH-ST MARY CORWIN MEDICAL CENTER 1008 MINNEQUA AVE PUEBLO CO 81004 PUEBLO (719) 557-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.2332110 -104.6227890 0   101 8 8101 39380 Pueblo-Cañon City, CO Central Pueblo County https://data.medicare.gov/resource/xubh-q36u/row-assn-vs45.2w8w 60012 659638 2019-11-26 2019-06-30 36 6         42               42
1170 CHESTER COUNTY HOSPITAL 701 EAST MARSHALL STREET WEST CHESTER PA 19380 CHESTER (610) 431-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9718600 -75.6009240 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-w9bi_cvpv_nst8 390179 659876 2019-11-26 2019-06-30 216 14       14 244               244
2542 CHI LISBON HEALTH 905 MAIN ST LISBON ND 58054 RANSOM (701) 683-5241 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4370020 -97.6814270 0   73 38 38073         https://data.medicare.gov/resource/xubh-q36u/row-sifi~rypw~xg47 351311 662066 2019-11-26 2019-06-30 25           25               25
218 CHI MERCY HEALTH 570 CHAUTAUQUA BLVD VALLEY CITY ND 58072 BARNES (701) 845-6400 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.9284920 -97.9949080 0   3 38 38003         https://data.medicare.gov/resource/xubh-q36u/row-pmhy~szku-z7nc 351324 662240 2019-11-26 2019-06-30 25           25               25
921 CHI OAKES HOSPITAL 1200 N 7TH ST OAKES ND 58474 DICKEY (701) 742-3291 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1507960 -98.0904330 0   21 38 38021         https://data.medicare.gov/resource/xubh-q36u/row-b2w7_uuc8~i52v 351315 659999 2019-11-26 2019-06-30 20           20               20
4759 CHILDREN'S HOSP OF RICHMOND OF THE VCU HEALTH SYS 2924 BROOK ROAD RICHMOND VA 23220 RICHMOND CITY (804) 321-7474 Childrens Voluntary non-profit - Private FALSE 37.5702610 -77.4492070 0   760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-3rgk-iaha-6s92 493302 660060 2019-11-26 2019-06-30                              
1188 CHILDREN'S HOSPITAL OF SAN ANTONIO 333 N SANTA ROSA ST SAN ANTONIO TX 78207 BEXAR (210) 704-3342 Childrens Voluntary non-profit - Private TRUE 29.4277960 -98.4978750 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-v67j_ia2t_8xbm 453315 660057 2019-11-26 2019-06-30 108 26       60 194               194
3048 CHILDRENS MERCY HOSPITAL 2401 GILLHAM ROAD KANSAS CITY MO 64108 JACKSON (816) 234-3000 Childrens Voluntary non-profit - Private TRUE 39.0827500 -94.5786110 0   95 29 29095 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-gifb-kr87.ze3i 263302 660636 2019-11-26 2019-06-30 186 41       87 314               314
2700 CHRISTUS COUSHATTA HEALTH CARE CENTER 1635 MARVEL STREET COUSHATTA LA 71019 RED RIVER (318) 932-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0216580 -93.3437340 0   81 22 22081         https://data.medicare.gov/resource/xubh-q36u/row-zmg8-cgqs~6zge 191312 659797 2019-11-26 2019-06-30 25           25               25
742 CHRISTUS HEALTH SHREVEPORT - BOSSIER 1453 E BERT KOUNS INDUSTRIAL DRIVE SHREVEPORT LA 71105 CADDO (318) 681-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4259620 -93.7189260 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-nnks_h7jb-jcg8 190041 660807 2019-11-26 2019-06-30 151 20       21 192   16           208
4509 CHRISTUS JASPER MEMORIAL HOSPITAL 1275 MARVIN HANCOCK DRIVE JASPER TX 75951 JASPER (409) 384-5461 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.9076390 -94.0085330 0   241 48 48241         https://data.medicare.gov/resource/xubh-q36u/row-3yge~3w33.2wyx 450573 659898 2019-11-26 2019-06-30 34 6         40               40
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
4490 CHRISTUS MOTHER FRANCES HOSPITAL SULPHUR SPRINGS 115 AIRPORT RD SULPHUR SPRINGS TX 75482 HOPKINS (903) 885-7671 Acute Care Hospitals Proprietary TRUE 33.1562200 -95.5996480 0   223 48 48223 44860 Dallas-Fort Worth, TX-OK Central Hopkins County https://data.medicare.gov/resource/xubh-q36u/row-k5xf.mj66.grqz 450236 660051 2019-11-26 2019-06-30 42 14         56   6           62
2550 CHRISTUS MOTHER FRANCES HOSPITAL- JACKSONVILLE 2026 S JACKSON STREET JACKSONVILLE TX 75766 CHEROKEE (903) 541-4500 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9379540 -95.2494290 0   73 48 48073 27380 Tyler-Jacksonville, TX Central Cherokee County https://data.medicare.gov/resource/xubh-q36u/row-g8ft-d3vt-ebpq 451319 659899 2019-11-26 2019-06-30 23           23               23
4708 CHRISTUS MOTHER FRANCES HOSPITAL- WINNSBORO 719 WEST COKE ROAD WINNSBORO TX 75494 WOOD (903) 342-5227 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.9476430 -95.3062300 0   499 48 48499         https://data.medicare.gov/resource/xubh-q36u/row-sujf.kw2i-m7r8 451381 660335 2019-11-26 2019-06-30 23           23               23
827 CHRISTUS OCHSNER LAKE AREA HOSPITAL 4200 NELSON ROAD LAKE CHARLES LA 70605 CALCASIEU (337) 474-6370 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1820710 -93.2493480 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-ziqv.tyfx-mhvz 190201 660808 2019-11-26 2019-06-30 80 8       20 108               108
826 CHRISTUS OCHSNER ST PATRICK HOSPITAL 524 DR MICHAEL DEBAKEY STREET LAKE CHARLES LA 70601 CALCASIEU (337) 436-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2154370 -93.2276700 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-574n_fdpb-emzy 190027 659956 2019-11-26 2019-06-30 83 17         100 25 23           148
1187 CHRISTUS SANTA ROSA MEDICAL CENTER 2827 BABCOCK ROAD SAN ANTONIO TX 78229 BEXAR (210) 704-3342 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.5129090 -98.5915570 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-332s~bezr_i5q2 450237 660052 2019-11-26 2019-06-30 323 49       5 377               377
4517 CHRISTUS SOUTHEAST TEXAS- ST ELIZABETH 2830 CALDER AVENUE BEAUMONT TX 77702 JEFFERSON (409) 892-7171 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.0855830 -94.1317020 0   245 48 48245 13140   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-mj59_xjsi~hf8e 450034 659730 2019-11-26 2019-06-30 306 39       25 370               370
4519 CHRISTUS SPOHN HOSPITAL ALICE 2500 E MAIN STREET ALICE TX 78332 JIM WELLS (361) 661-8016 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.7655080 -98.0437130 0   249 48 48249 10860 Corpus Christi-Kingsville-Alice, TX Central Jim Wells County https://data.medicare.gov/resource/xubh-q36u/row-b4k9_mqdr~hpfd 450828 660474 2019-11-26 2019-06-30 64 8         72               72
1041 CHRISTUS SPOHN HOSPITAL BEEVILLE 1500 E HOUSTON HWY BEEVILLE TX 78102 BEE (361) 354-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.4083530 -97.7319250 0   25 48 48025 13300   Central Bee County https://data.medicare.gov/resource/xubh-q36u/row-i8xs~bawd_cyy5 450082 659895 2019-11-26 2019-06-30 32 8         40               40
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
4535 CHRISTUS SPOHN HOSPITAL KLEBERG 1311 EAST GENERAL CAVAZOS BLVD KINGSVILLE TX 78363 KLEBERG (361) 595-1661 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.4914160 -97.8498310 0   273 48 48273 28780 Corpus Christi-Kingsville-Alice, TX Central Kleberg County https://data.medicare.gov/resource/xubh-q36u/row-epm5-3z7h_ij8i 450163 659896 2019-11-26 2019-06-30 40 10         50               50
2646 CHRISTUS ST FRANCES CABRINI HOSPITAL 3330 MASONIC DRIVE ALEXANDRIA LA 71301 RAPIDES (318) 487-1122 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.2824010 -92.4608480 0   79 22 22079 10780   Central Rapides Parish https://data.medicare.gov/resource/xubh-q36u/row-tc25-kjhe-hnmq 190019 659683 2019-11-26 2019-06-30 230 26       20 276   25           301
1574 CHRISTUS ST MICHAEL HEALTH SYSTEM 2600 ST MICHAEL DR TEXARKANA TX 75504 BOWIE (903) 614-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4624900 -94.0744480 0   37 48 48037 45500   Central Bowie County https://data.medicare.gov/resource/xubh-q36u/row-ewkv~jnzh~w9wk 450801 659740 2019-11-26 2019-06-30 290 32 16   8 8 354               354
1854 CHRISTUS ST VINCENT REGIONAL MEDICAL CENTER 455 ST MICHAEL'S DRIVE SANTA FE NM 87505 SANTA FE (505) 913-5201 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6577890 -105.9469460 0   49 35 35049 42140 Albuquerque-Santa Fe-Las Vegas, NM Central Santa Fe County https://data.medicare.gov/resource/xubh-q36u/row-ew8z~vnrx_nfua 320002 661060 2019-11-26 2019-06-30 167 18         185 9 20           214
1386 CLEARWATER VALLEY HOSPITAL & CLINICS 301 CEDAR STREET OROFINO ID 83544 CLEARWATER (208) 476-4555 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4873150 -116.2599160 0   35 16 16035         https://data.medicare.gov/resource/xubh-q36u/row-4jwp-mz4f-k7tn 131320 659779 2019-11-26 2019-06-30 23           23               23
888 COLISEUM MEDICAL CENTERS 350 HOSPITAL DRIVE MACON GA 31217 BIBB (478) 765-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8473150 -83.6202700 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-xqcr.fqgq_42i9 110164 660072 2019-11-26 2019-06-30 138 28       13 179 42 29           250
887 COLISEUM NORTHSIDE HOSPITAL 400 CHARTER BOULEVARD MACON GA 31210 BIBB (478) 757-8200 Acute Care Hospitals Proprietary TRUE 32.8698610 -83.6943610 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-qnzt.yc4b~gnii 110201 660371 2019-11-26 2019-06-30 75 10         85               85
293 COMMUNITY HOSPITAL ASSOCIATION 26136 US HIGHWAY 59, PO BOX 107 FAIRFAX MO 64446 ATCHISON (660) 686-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3482150 -95.3973230 0   5 29 29005         https://data.medicare.gov/resource/xubh-q36u/row-kkzi.c85k.9msb 261303 660249 2019-11-26 2019-06-30 16           16               16
3924 COOKEVILLE REGIONAL MEDICAL CENTER 1 MEDICAL CENTER BOULEVARD COOKEVILLE TN 38501 PUTNAM (931) 783-2000 Acute Care Hospitals Government - Local TRUE 36.1699600 -85.5093500 0   141 47 47141 18260   Central Putnam County https://data.medicare.gov/resource/xubh-q36u/row-huvy_sdvh_bsx2 440059 660310 2019-11-26 2019-06-30 173 38         211   20           231
3978 COVENANT MEDICAL CENTER 1447 N HARRISON SAGINAW MI 48602 SAGINAW (989) 583-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.4280970 -83.9555480 0   145 26 26145 40980 Saginaw-Midland-Bay City, MI Central Saginaw County https://data.medicare.gov/resource/xubh-q36u/row-g2ct.d9up~x9t5 230070 660585 2019-11-26 2019-06-30 356 36 41       473   41   20       534
1680 CULLMAN REGIONAL MEDICAL CENTER 1912 ALABAMA HIGHWAY 157 CULLMAN AL 35058 CULLMAN (256) 737-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1985870 -86.8056410 0   43 1 1043 18980 Birmingham-Hoover-Talladega, AL Central Cullman County https://data.medicare.gov/resource/xubh-q36u/row-25az.bw5t.5dxy 10035 659467 2019-11-26 2019-06-30 133 12         145               145
2194 DEER RIVER HEALTHCARE CENTER 115 10TH AVENUE NORTHEAST DEER RIVER MN 56636 ITASCA (218) 246-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.3435030 -93.7912990 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-run4_u2tc_i8qs 241360 660613 2019-11-26 2019-06-30 20           20       32       52
1752 DILEY RIDGE MEDICAL CENTER 7911 DILEY ROAD CANAL WINCHESTER OH 43110 FRANKLIN (614) 838-7910 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8500530 -82.7811000 0   45 39 39045 18140 Columbus-Marion-Zanesville, OH Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-82cy_fgw2.yjpg 360358 660675 2019-11-26 2019-06-30 10           10               10
934 DIVINE SAVIOR HEALTHCARE 2817 NEW PINERY ROAD PORTAGE WI 53901 COLUMBIA (608) 742-4131 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5662780 -89.4694450 0   21 55 55021 31540 Madison-Janesville-Beloit, WI Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-qhad~azvf~jeqw 520041 661128 2019-11-26 2019-06-30 37 6         43       83   40   166
25 ESSENTIA HEALTH ADA 201 9TH STREET WEST ADA MN 56510 NORMAN (218) 784-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2960910 -96.5301900 0   107 27 27107         https://data.medicare.gov/resource/xubh-q36u/row-z63y_de5x~9s9u 241313 660607 2019-11-26 2019-06-30 14           14               14
3597 ESSENTIA HEALTH FOSSTON 900 HILLIGOSS BOULEVARD SE FOSSTON MN 56542 POLK (218) 435-1133 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.5721490 -95.7406070 0   119 27 27119 24220   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-93pp~c6zp.yfzi 241357 660612 2019-11-26 2019-06-30 24           24       50       74
3879 ESSENTIA HEALTH ST MARY'S MEDICAL CENTER 407 EAST THIRD STREET DULUTH MN 55805 ST. LOUIS (218) 786-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.7928430 -92.0963950 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-pkbs_kx6e_rts3 240002 660602 2019-11-26 2019-06-30 179 33 56   11   307               307
291 ESSENTIA HEALTH ST MARYS - DETROIT LAKES 1027 WASHINGTON AVE DETROIT LAKES MN 56501 BECKER (218) 847-0888 Acute Care Hospitals Voluntary non-profit - Church FALSE 46.8153070 -95.8454530 0   5 27 27005         https://data.medicare.gov/resource/xubh-q36u/row-my2b~zwif~njdr 240101 660605 2019-11-26 2019-06-30 28 8         36       96       132
3794 EXCELA HEALTH FRICK HOSPITAL 508 SOUTH CHURCH STREET MOUNT PLEASANT PA 15666 WESTMORELAND (724) 547-1500 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.1463690 -79.5482170 0   129 42 42129 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Westmoreland County https://data.medicare.gov/resource/xubh-q36u/row-duk2-m779~b9mf 390217 659878 2019-11-26 2019-06-30 27   6       33               33
3793 EXCELA HEALTH LATROBE HOSPITAL ONE MELLON WAY LATROBE PA 15650 WESTMORELAND (724) 537-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3209181 -79.3939014 1 ROOFTOP 129 42 42129 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Westmoreland County https://data.medicare.gov/resource/xubh-q36u/row-ciy8-dq9e-fjwc 390219 659879 2019-11-26 2019-06-30 111 11         122               122
3792 EXCELA HEALTH WESTMORELAND HOSPITAL 532 WEST PITTSBURGH STREET GREENSBURG PA 15601 WESTMORELAND (724) 832-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3013170 -79.5555140 0   129 42 42129 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Westmoreland County https://data.medicare.gov/resource/xubh-q36u/row-j9d6.bgu8-2tdc 390145 659872 2019-11-26 2019-06-30 206 22 12     6 246   26           272
2000 FRANKLIN HOSPITAL 201 BAILEY LANE BENTON IL 62812 FRANKLIN (618) 439-3161 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.0091370 -88.9171420 0   55 17 17055         https://data.medicare.gov/resource/xubh-q36u/row-a634_xpuq_r7c9 141321 660523 2019-11-26 2019-06-30 25           25               25
1785 GARDEN PARK MEDICAL CENTER 15200 COMMUNITY ROAD GULFPORT MS 39503 HARRISON (228) 575-7000 Acute Care Hospitals Proprietary TRUE 30.4420100 -89.0927660 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-mqi3~42hr_6pv9 250123 660823 2019-11-26 2018-12-31 87 13         100 21             121
2659 GEISINGER WYOMING VALLEY MEDICAL CENTER 1000 EAST MOUNTAIN BOULEVARD WILKES BARRE PA 18711 LUZERNE (570) 826-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2569970 -75.8117170 0   79 42 42079 42540   Central Luzerne County https://data.medicare.gov/resource/xubh-q36u/row-6vza.ghq5_5nyd 390270 660446 2019-11-26 2019-06-30 228 25         300   20           320
2412 GEISINGER-COMMUNITY MEDICAL CENTER 1822 MULBERRY STREET SCRANTON PA 18510 LACKAWANNA (570) 969-8240 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4007170 -75.6458900 0   69 42 42069 42540   Central Lackawanna County https://data.medicare.gov/resource/xubh-q36u/row-sbiu_ucx9_fnbj 390001 659865 2019-11-26 2019-06-30 237 18         255 24             279
120 GETTYSBURG HOSPITAL 147 GETTYS STREET GETTYSBURG PA 17325 ADAMS (717) 334-2121 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8233170 -77.2340440 0   1 42 42001 23900 Harrisburg-York-Lebanon, PA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-493f.cvfq~sac8 390065 660855 2019-11-26 2019-06-30 68 8         76               76
772 GILA REGIONAL MEDICAL CENTER 1313 E 32ND ST SILVER CITY NM 88061 GRANT (575) 538-4100 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7955240 -108.2609080 0   17 35 35017 43500   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-7frq_jm9p~bbxr 320016 659708 2019-11-26 2019-06-30 26 6         32 10             42
1664 GOOD SAMARITAN HOSPITAL FOURTH AND WALNUT STREETS LEBANON PA 17042 LEBANON (717) 270-7500 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.1463530 -77.1285980 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-nqjx-dmqh-mzcz 390066 661094 2019-11-26 2019-06-30 127 18         145   14           159
2067 GREAT RIVER MEDICAL CENTER 1221 SOUTH GEAR AVENUE WEST BURLINGTON IA 52655 DES MOINES (319) 768-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8073690 -91.1702780 0   57 19 19057 15460   Central Des Moines County https://data.medicare.gov/resource/xubh-q36u/row-8pkk_2khg-h2nd 160057 660081 2019-11-26 2019-06-30 124 12         136   11   160   6   313
3957 HILLCREST MEDICAL CENTER 1120 SOUTH UTICA AVENUE TULSA OK 74104 TULSA (918) 579-1000 Acute Care Hospitals Proprietary TRUE 36.1471640 -95.9671410 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-u9va-2kpb~97hh 370001 660845 2019-11-26 2019-06-30 319 30 44 13   42 448   32           480
1970 HOLZER MEDICAL CENTER 100 JACKSON PIKE GALLIPOLIS OH 45631 GALLIA (740) 446-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8444100 -82.2368020 0   53 39 39053 38580   Central Gallia County https://data.medicare.gov/resource/xubh-q36u/row-g9re~frqh.e6ur 360054 660667 2019-11-26 2019-06-30 143 14         157 14 26       116   313
2657 HOLZER MEDICAL CENTER JACKSON 500 BURLINGTON ROAD JACKSON OH 45640 JACKSON (740) 395-8500 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.0326610 -82.6381800 0   79 39 39079 27160   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-uzg6.66qw~z7aa 361320 660677 2019-11-26 2019-06-30 24           24               24
3230 HOSPITAL OF UNIV OF PENNSYLVANIA 34TH & SPRUCE STS PHILADELPHIA PA 19104 PHILADELPHIA (215) 662-3227 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9504425 -75.1925902 1 GEOMETRIC_CENTER 101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-2v8t-hvbn_kbi7 390111 661968 2019-11-26 2019-06-30 587 32 12   78 2 748   58           806
1309 HOSPITAL UPR, DR FEDERICO TRILLA CARR 3 KM 8 3 AVE 65TH INFANTERIA BOX 6021 CAROLINA PR 984 CAROLINA (787) 757-1800 Acute Care Hospitals Proprietary FALSE 18.3808638 -65.9632825 1 RANGE_INTERPOLATED 31 72 72031 41980 San Juan-Carolina, PR Central Carolina Municipio https://data.medicare.gov/resource/xubh-q36u/row-xbn3-25u3~b8g7 400112 660876 2019-11-26 2019-06-30 210 8         233               233
2945 HUMBOLDT COUNTY MEMORIAL HOSPITAL 1000 NORTH 15TH STREET HUMBOLDT IA 50548 HUMBOLDT (515) 332-4200 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.7318350 -94.2302160 0   91 19 19091         https://data.medicare.gov/resource/xubh-q36u/row-vk9h.9r4x-cbu7 161334 660218 2019-11-26 2019-06-30 17           17           28   45
4078 HUTCHINSON REGIONAL MEDICAL CENTER INC 1701 E 23RD AVENUE HUTCHINSON KS 67502 RENO (620) 665-2001 Acute Care Hospitals Proprietary TRUE 38.0794850 -97.8922750 0   155 20 20155 26740   Central Reno County https://data.medicare.gov/resource/xubh-q36u/row-pvdz.9ewv~qj4w 170020 660089 2019-11-26 2019-06-30 109 18         127 14 11           152
1249 INGALLS MEMORIAL HOSPITAL 1 INGALLS DRIVE HARVEY IL 60426 COOK (708) 333-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6063310 -87.6594840 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-vjp9-dpap-bkr6 140191 660514 2019-11-26 2019-06-30 243 25         268 16 42           326
3390 INTEGRIS SOUTHWEST MEDICAL CENTER 4401 SOUTH WESTERN AVENUE OKLAHOMA CITY OK 73109 OKLAHOMA (405) 636-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4225350 -97.5301960 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-23vu-3nyp~546j 370106 659858 2019-11-26 2019-06-30 165 20         185   67           252
3007 JAMESTOWN REGIONAL MEDICAL CENTER 2422 20TH ST SW JAMESTOWN ND 58401 STUTSMAN (701) 252-1050 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.8879400 -98.7493770 0   93 38 38093 27420   Central Stutsman County https://data.medicare.gov/resource/xubh-q36u/row-592i~zkzj_6zsv 351335 660000 2019-11-26 2019-06-30 19 6         25               25
3326 JANE PHILLIPS NOWATA HOSPITAL, INC 237 SOUTH LOCUST STREET NOWATA OK 74048 NOWATA (918) 273-3102 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.6965140 -95.6305030 0   105 40 40105         https://data.medicare.gov/resource/xubh-q36u/row-rnwc~4b3z-5gvh 371305 660003 2019-11-26 2019-06-30 25           25               25
4713 JOHNS HOPKINS BAYVIEW MEDICAL CENTER 4940 EASTERN AVENUE BALTIMORE MD 21224 BALTIMORE CITY (410) 550-0123 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2872850 -76.5521340 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-tsuu-47er~ackm 210029 661192 2019-11-26 2019-06-30 332 22 12 10 10 25 411               411
1432 JORDAN VALLEY MEDICAL CENTER 3580 WEST 9000 SOUTH WEST JORDAN UT 84088 SALT LAKE (801) 561-8888 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5879580 -111.9752850 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-uwvk-5p5y~xqkd 460051 662282 2019-11-26 2019-06-30 221 46       11 278 26 10           314
156 KAPIOLANI MEDICAL CENTER FOR WOMEN & CHILDREN 1319 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 983-6000 Childrens Voluntary non-profit - Private TRUE 21.3003960 -157.8342460 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-2vss_bgb6-b6d4 123300 659778 2019-11-26 2019-06-30 156 3         253               253
2994 KEARNY COUNTY HOSPITAL 500 THORPE STREET LAKIN KS 67860 KEARNY (620) 355-7111 Critical Access Hospitals Government - Local TRUE 37.9459710 -101.2510360 0   93 20 20093 23780   Outlying Kearny County https://data.medicare.gov/resource/xubh-q36u/row-62du-eigp.wszj 171313 660224 2019-11-26 2019-06-30 25           25         40 35   100
2070 LADY OF THE SEA GENERAL HOSPITAL 200 WEST 134TH PLACE CUT OFF LA 70345 LAFOURCHE (985) 632-6401 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.4567190 -90.3104300 0   57 22 22057 26380   Central Lafourche Parish https://data.medicare.gov/resource/xubh-q36u/row-gtsq-dc99_icfj 191325 659798 2019-11-26 2019-06-30 21 2         23               23
2137 LAKES REGIONAL HEALTHCARE 2301 HIGHWAY 71 SPIRIT LAKE IA 51360 DICKINSON (712) 336-1230 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.4183960 -95.1263120 0   59 19 19059 44020   Central Dickinson County https://data.medicare.gov/resource/xubh-q36u/row-afjd-chpt.x7ew 160124 660085 2019-11-26 2019-06-30 41   3       44               44
2485 LANCASTER GENERAL HOSPITAL 555 NORTH DUKE STREET LANCASTER PA 17604 LANCASTER (717) 299-5511 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.0469750 -76.3053280 0   71 42 42071 29540   Central Lancaster County https://data.medicare.gov/resource/xubh-q36u/row-5fun.iaku_agnn 390100 660294 2019-11-26 2019-06-30 504 48       29 581               581
465 LANDMANN-JUNGMAN MEMORIAL HOSPITAL - CAH 600 BILLARS ST SCOTLAND SD 57059 BON HOMME (605) 583-2226 Critical Access Hospitals Government - Local TRUE 43.1494940 -97.7281040 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-h5nm-t8q8-ubs6 431317 662141 2019-11-26 2019-06-30 25           25               25
2393 LEESBURG REGIONAL MEDICAL CENTER 600 E DIXIE AVE LEESBURG FL 34748 LAKE (352) 323-5762 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.8065790 -81.8691130 0   69 12 12069 36740 Orlando-Deltona-Daytona Beach, FL Outlying Lake County https://data.medicare.gov/resource/xubh-q36u/row-mfzj-wqty_a5mg 100084 659922 2019-11-26 2019-06-30 262 46         308 21             329

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