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 phone_number

✎ 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
2602 2602 POWER COUNTY HOSPITAL DISTRICT 510 ROOSEVELT STREET AMERICAN FALLS ID 83211 POWER (208) 226-3200 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7818580 -112.8490470 0   77 16 16077         https://data.medicare.gov/resource/xubh-q36u/row-jqyn~uieu.hqrg 131304 645328 2019-03-20 2018-09-30 10           10       16       26
271 271 PORTNEUF MEDICAL CENTER 777 HOSPITAL WAY POCATELLO ID 83201 BANNOCK (208) 239-1000 Acute Care Hospitals Proprietary TRUE 42.8726210 -112.4189000 0   5 16 16005 38540   Central Bannock County https://data.medicare.gov/resource/xubh-q36u/row-seur~dy2g.gabs 130028 653172 2019-08-07 2018-12-31 101 20         137 19 9           165
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
950 950 LOST RIVERS MEDICAL CENTER 551 HIGHLAND DRIVE ARCO ID 83213 BUTTE (208) 252-7654 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6405520 -113.2962530 0   23 16 16023 26820 Idaho Falls-Rexburg-Blackfoot, ID Outlying Butte County https://data.medicare.gov/resource/xubh-q36u/row-77px.m9qb~bsww 131324 640856 2019-01-08 2018-09-30 14           14               14
1999 1999 NORTHWEST SPECIALTY HOSPITAL 1593 EAST POLSTON AVENUE POST FALLS ID 83854 KOOTENAI (208) 262-2466 Acute Care Hospitals Proprietary FALSE 47.7144100 -116.9244550 0   55 16 16055 17660 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Kootenai County https://data.medicare.gov/resource/xubh-q36u/row-68rq_3jru~i59y 130066 649721 2019-06-03 2018-12-31 34           34               34
732 732 BONNER GENERAL HOSPITAL 520 NORTH THIRD AVENUE SANDPOINT ID 83864 BONNER (208) 263-1441 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.2774850 -116.5503140 0   17 16 16017 41760   Central Bonner County https://data.medicare.gov/resource/xubh-q36u/row-j4p7~5f43_p5pc 131328 649722 2019-06-11 2018-12-31 21 4         25               25
890 890 BOUNDARY COMMUNITY HOSPITAL 6640 KANIKSU STREET BONNERS FERRY ID 83805 BOUNDARY (208) 267-4850 Critical Access Hospitals Voluntary non-profit - Other TRUE 48.7025700 -116.3220840 0   21 16 16021         https://data.medicare.gov/resource/xubh-q36u/row-7r4n.ssgi~ypas 131301 645892 2019-04-01 2018-12-31 20           20       28       48
2693 2693 TETON VALLEY HOSPITAL 120 EAST HOWARD AVE DRIGGS ID 83422 TETON (208) 354-2383 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7272850 -111.1086080 0   81 16 16081 27220   Outlying Teton County https://data.medicare.gov/resource/xubh-q36u/row-73s3-g6zw_arid 131313 643497 2019-02-27 2018-09-30 13           13               13
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
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
86 86 SAINT ALPHONSUS REGIONAL MEDICAL CENTER 1055 NORTH CURTIS ROAD BOISE ID 83706 ADA (208) 367-2121 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.6140720 -116.2536220 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-bd8k~rga3_kmdd 130007 662193 2019-12-03 2019-06-30 282 42       24 348   30           378
85 85 TREASURE VALLEY HOSPITAL 8800 WEST EMERALD STREET BOISE ID 83704 ADA (208) 373-5000 Acute Care Hospitals Proprietary FALSE 43.6112890 -116.2903320 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-egh2.u29a~s2jf 130063 650684 2019-05-31 2018-12-31 9           9               9
87 87 ST LUKE'S REGIONAL MEDICAL CENTER 190 EAST BANNOCK STREET BOISE ID 83712 ADA (208) 381-2222 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6121570 -116.1922020 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-7i3s_c82d-yek7 130006 651557 2019-06-21 2018-09-30 410 46 17     73 559   19           578
2767 2767 CASCADE MEDICAL CENTER 402 LAKE CASCADE PARKWAY CASCADE ID 83611 VALLEY (208) 382-4242 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.5179210 -116.0489380 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-8r6g.s3au-3yid 131308 644833 2019-03-04 2018-09-30 8           8               8
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
1067 1067 WEST VALLEY MEDICAL CENTER 1717 ARLINGTON STREET CALDWELL ID 83605 CANYON (208) 459-4641 Acute Care Hospitals Proprietary TRUE 43.6542200 -116.6956400 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-q3w9-74rj.ew8y 130014 645072 2019-02-28 2018-09-30 95 13       4 112               112
1386 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
1065 1065 ST LUKE'S NAMPA MEDICAL CENTER 9850 W ST LUKES DRIVE STE 250 NAMPA ID 83687 CANYON (208) 505-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6166180 -116.5907340 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-tbp2_2gqm.s523 130071 651515 2019-06-21 2018-09-30 56 10       4 70               70
820 820 EASTERN IDAHO REGIONAL MEDICAL CENTER 3100 CHANNING WAY IDAHO FALLS ID 83404 BONNEVILLE (208) 529-6210 Acute Care Hospitals Proprietary TRUE 43.4702760 -111.9901590 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-zu9m_rfwy-xxuk 130018 644978 2019-02-28 2018-09-30 165 35         226 28 17       10   310
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
2853 2853 WEISER MEMORIAL HOSPITAL 645 EAST 5TH STREET WEISER ID 83672 WASHINGTON (208) 549-0370 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.2487610 -116.9617350 0   87 16 16087         https://data.medicare.gov/resource/xubh-q36u/row-e9wf-9jnf_cbd3 131307 655768 2019-11-01 2019-06-30 19           19               19
819 819 MOUNTAIN VIEW HOSPITAL 2325 CORONADO STREET IDAHO FALLS ID 83404 BONNEVILLE (208) 557-2700 Acute Care Hospitals Physician FALSE 43.4725240 -111.9887170 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-4xx8-2i4p-wi9n 130065 649556 2019-05-31 2018-12-31 41           41               41
1586 1586 ST LUKE'S ELMORE MEDICAL CENTER 895 NORTH 6TH EAST MOUNTAIN HOME ID 83647 ELMORE (208) 587-8401 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1391990 -115.6924870 0   39 16 16039 34300 Boise City-Mountain Home-Ontario, ID-OR Central Elmore County https://data.medicare.gov/resource/xubh-q36u/row-642u_ypya~t5sn 131311 651827 2019-06-21 2018-09-30 21           21       38       59
1998 1998 KOOTENAI HEALTH 2003 KOOTENAI HEALTH WAY COEUR D'ALENE ID 83814 KOOTENAI (208) 625-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.6945970 -116.7926690 0   55 16 16055 17660 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Kootenai County https://data.medicare.gov/resource/xubh-q36u/row-rqii_d7ee.cxzr 130049 649720 2019-05-31 2018-12-31 228 55       14 297               297
2163 2163 ST LUKE'S MCCALL 1000 STATE STREET BURGDORF ID 83638 VALLEY (208) 630-2395 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9093540 -116.1097030 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-au7a~xb54-snfz 131312 651560 2019-06-21 2018-09-30 15           15               15
1216 1216 CASSIA REGIONAL HOSPITAL 1501 HILAND AVENUE BURLEY ID 83318 CASSIA (208) 678-4444 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.5342040 -113.7834190 0   31 16 16031 15420   Central Cassia County https://data.medicare.gov/resource/xubh-q36u/row-fk3w-rvur-gbdi 131326 658932 2019-11-14 2018-12-31 25 6         31               31
600 600 ST LUKE'S WOOD RIVER MEDICAL CENTER 100 HOSPITAL DRIVE KETCHUM ID 83340 BLAINE (208) 727-8800 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6484730 -114.3490180 0   13 16 16013 25200   Central Blaine County https://data.medicare.gov/resource/xubh-q36u/row-pewx.ysiv~gtnq 131323 651610 2019-06-21 2018-09-30 25           25               25
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
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
499 499 GROVE CREEK MEDICAL CENTER 350 NORTH MERIDIAN STREET BLACKFOOT ID 83221 BINGHAM (208) 782-2900 Acute Care Hospitals Voluntary non-profit - Private FALSE 43.1963010 -112.3561240 0   11 16 16011 13940 Idaho Falls-Rexburg-Blackfoot, ID Central Bingham County https://data.medicare.gov/resource/xubh-q36u/row-ej2j_mw5y_vys8                                      
2642 2642 SHOSHONE MEDICAL CENTER 25 JACOBS GULCH ROAD KELLOGG ID 83837 SHOSHONE (208) 784-1221 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.5471230 -116.1314090 0   79 16 16079         https://data.medicare.gov/resource/xubh-q36u/row-5s2d-murc_kv83 131314 647887 2019-05-02 2018-11-30 21           21               21
500 500 BINGHAM MEMORIAL HOSPITAL 98 POPLAR STREET BLACKFOOT ID 83221 BINGHAM (208) 785-3804 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1929520 -112.3474420 0   11 16 16011 13940 Idaho Falls-Rexburg-Blackfoot, ID Central Bingham County https://data.medicare.gov/resource/xubh-q36u/row-w9a9.cd8a_yjs9 131325 650254 2019-06-24 2018-12-31 20 5         25 10     50       85
2396 2396 ST JOSEPH REGIONAL MEDICAL CENTER 415 SIXTH STREET LEWISTON ID 83501 NEZ PERCE (208) 799-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.4171210 -117.0249970 0   69 16 16069 30300   Central Nez Perce County https://data.medicare.gov/resource/xubh-q36u/row-dyet_gevw~szfb 130003 662190 2019-12-02 2019-06-30 101 9         110 20             130
2743 2743 ST LUKE'S MAGIC VALLEY RMC 801 POLE LINE ROAD WEST TWIN FALLS ID 83301 TWIN FALLS (208) 814-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5915950 -114.4969980 0   83 16 16083 46300   Central Twin Falls County https://data.medicare.gov/resource/xubh-q36u/row-4v7h~2u75~uyrf 130002 652427 2019-06-21 2018-09-30 124 30       18 172 28 14           214
1947 1947 ST LUKE'S JEROME 709 NORTH LINCOLN AVENUE JEROME ID 83338 JEROME (208) 814-9500 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.7302930 -114.5184900 0   53 16 16053 46300   Outlying Jerome County https://data.medicare.gov/resource/xubh-q36u/row-n7f6.zqym~9dzu 131310 651558 2019-06-21 2018-09-30 25           25               25
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
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
2059 2059 GRITMAN MEDICAL CENTER 700 SOUTH MAIN STREET MOSCOW ID 83843 LATAH (208) 882-4511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.7287040 -117.0014060 0   57 16 16057 34140 Pullman-Moscow, WA-ID Central Latah County https://data.medicare.gov/resource/xubh-q36u/row-x6ja_wsrd-c6wh 131327 659244 2019-06-03 2018-12-31 22 3         25               25
1777 1777 NORTH CANYON MEDICAL CENTER 267 NORTH CANYON DR GOODING ID 83330 GOODING (208) 934-4433 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.9218690 -114.7111280 0   47 16 16047         https://data.medicare.gov/resource/xubh-q36u/row-dagw~rfa6-2dqe 131302 642945 2019-02-06 2018-09-30 16           16               16
1833 1833 ST MARY'S HOSPITAL 701 LEWISTON ST COTTONWOOD ID 83522 IDAHO (208) 962-3251 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0503710 -116.3516450 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-u7zv_7y6z_xg8a 131321 661307 2019-11-26 2019-06-30 25           25               25
1832 1832 SYRINGA GENERAL HOSPITAL 607 W MAIN STREET GRANGEVILLE ID 83530 IDAHO (208) 983-1700 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.9267890 -116.1269940 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-9the-4kgt.urhi 131315 642946 2019-02-08 2018-09-30 15           15               15
259 259 SUTTER AMADOR HOSPITAL 200 MISSION BLVD JACKSON CA 95642 AMADOR (209) 223-7500 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3495610 -120.7659050 0   5 6 6005         https://data.medicare.gov/resource/xubh-q36u/row-s5bi-egin.834t 50014 650640 2019-06-03 2018-12-31 46 6         52               52
2595 2595 ADVENTIST HEALTH LODI MEMORIAL 975 S FAIRMONT AVENUE LODI CA 95240 SAN JOAQUIN (209) 334-3411 Acute Care Hospitals Voluntary non-profit - Other FALSE 38.1216340 -121.2857870 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-ewtc_9ynj_9n73 50336 652390 2019-05-31 2018-12-31 172 10         182   8           190
1200 1200 ADVENTIST HEALTH HANFORD 115 MALL DRIVE HANFORD CA 93230 KINGS (209) 410-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3238770 -119.6690050 0   31 6 6031 25260 Visalia-Porterville-Hanford, CA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-gskm_spqc_qqn6 50121 649537 2019-05-31 2018-12-31 208 22         230               230
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
3134 3134 MEMORIAL MEDICAL CENTER 1700 COFFEE RD MODESTO CA 95355 STANISLAUS (209) 526-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6687010 -120.9756740 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-zvpx~t5vq.tt29 50557 650654 2019-06-03 2018-12-31 372 35       12 419               419
3364 3364 ADVENTIST HEALTH SONORA 1000 GREENLEY ROAD SONORA CA 95370 TUOLUMNE (209) 536-5000 Acute Care Hospitals Voluntary non-profit - Church FALSE 37.9767280 -120.3694420 0   109 6 6109 43760   Central Tuolumne County https://data.medicare.gov/resource/xubh-q36u/row-7tcs_nvgu-e2ik 50335 652417 2019-05-31 2018-12-31 78 6         84       68       152
1775 1775 MERCY MEDICAL CENTER 333 MERCY AVENUE MERCED CA 95340 MERCED (209) 564-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3401220 -120.4652140 0   47 6 6047 32900 Modesto-Merced, CA Central Merced County https://data.medicare.gov/resource/xubh-q36u/row-w9t4~7ucu~gmfz 50444 661461 2019-12-03 2019-06-30 166 20         186               186
3136 3136 STANISLAUS SURGICAL HOSPITAL 1421 OAKDALE ROAD MODESTO CA 95355 STANISLAUS (209) 572-2700 Acute Care Hospitals Proprietary FALSE 37.6645580 -120.9575160 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-fsc3.3tg8_b499 50726 649542 2019-05-31 2018-12-31 23           23               23
3133 3133 DOCTORS MEDICAL CENTER 1441 FLORIDA AVENUE MODESTO CA 95350 STANISLAUS (209) 578-1211 Acute Care Hospitals Proprietary TRUE 37.6656660 -120.9962500 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-h4cz~c84j.66ru 50464 655748 2019-10-30 2019-05-31 291 22 14     45 380 67             447
3135 3135 EMANUEL MEDICAL CENTER 825 DELBON AVE TURLOCK CA 95382 STANISLAUS (209) 667-4200 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.5104870 -120.8374910 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-rimp~9bpy.6vfc 50179 649396 2019-05-31 2018-12-31 191 12       6 209               209
406 406 MARK TWAIN MEDICAL CENTER 768 MOUNTAIN RANCH RD SAN ANDREAS CA 95249 CALAVERAS (209) 754-2515 Critical Access Hospitals Voluntary non-profit - Other FALSE 38.1909730 -120.6706610 0   9 6 6009         https://data.medicare.gov/resource/xubh-q36u/row-vzvr.d5an~vpec 51332 660493 2019-12-03 2019-06-30 25           25               25
2591 2591 DOCTORS HOSPITAL OF MANTECA 1205 E NORTH STREET MANTECA CA 95336 SAN JOAQUIN (209) 823-3111 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.8010870 -121.1969100 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-c4b9.uk2v.8fgd 50118 655745 2019-10-28 2019-05-31 65 8         73               73
2596 2596 KAISER FOUNDATION HOSPITAL MANTECA 1777 WEST YOSEMITE AVE MANTECA CA 95337 SAN JOAQUIN (209) 825-3700 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7973710 -121.2461830 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-bijj-mjic.y79k 50748 652235 2019-06-06 2018-12-31 163 26         213       38       251
1774 1774 MEMORIAL HOSPITAL LOS BANOS 520 WEST I ST LOS BANOS CA 93635 MERCED (209) 826-0591 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.0634310 -120.8594070 0   47 6 6047 32900 Modesto-Merced, CA Central Merced County https://data.medicare.gov/resource/xubh-q36u/row-gm4t~nj6b~a4u2 50528 650957 2019-06-03 2018-12-31 36 4         40               40
2592 2592 SUTTER TRACY COMMUNITY HOSPITAL 1420 NORTH TRACY BLVD TRACY CA 95376 SAN JOAQUIN (209) 835-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7442320 -121.4349400 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-fw75_cku3-qat9 50313 650946 2019-06-03 2018-12-31 69 8         77               77
3137 3137 OAK VALLEY HOSPITAL DISTRICT 350 S OAK AVE OAKDALE CA 95361 STANISLAUS (209) 847-3011 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7580980 -120.8603630 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-ehek_q3if-kskp 50067 660166 2019-12-02 2019-06-30 30 5         35       115       150
2590 2590 ST JOSEPH'S MEDICAL CENTER OF STOCKTON 1800 N CALIFORNIA ST STOCKTON CA 95204 SAN JOAQUIN (209) 943-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9707370 -121.2892510 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-6eu4-8z8z~ftzd 50084 662014 2019-12-03 2019-06-30 279 30 9     30 348               348
2593 2593 DAMERON HOSPITAL 525 WEST ACACIA STREET STOCKTON CA 95203 SAN JOAQUIN (209) 944-5550 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.9612010 -121.3006910 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-58ur~4h95-d7n5 50122 653001 2019-08-01 2018-12-31 146 12 12       170               170
1682 1682 JOHN C FREMONT HEALTHCARE DISTRICT 5189 HOSPITAL ROAD MARIPOSA CA 95338 MARIPOSA (209) 966-3631 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.5005310 -119.9769480 0   43 6 6043         https://data.medicare.gov/resource/xubh-q36u/row-fty8~tgqe.f5tj 51304 661465 2019-12-02 2019-06-30 18           18       16   1   35
1176 1176 NIX HEALTH CARE SYSTEM 414 NAVARRO, SUITE 600 SAN ANTONIO TX 78205 BEXAR (210) 271-2188 Acute Care Hospitals Proprietary TRUE 29.4255770 -98.4897180 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-6ir7_mgdd.hab9 450130 648576 2019-05-30 2018-12-31 189 12         201 33 18           252
1179 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
1180 1180 UNIVERSITY HEALTH SYSTEM 4502 MEDICAL DR SAN ANTONIO TX 78229 BEXAR (210) 358-2637 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5094880 -98.5770620 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-a5b3.8n6m-4vq3 450213 651423 2019-05-31 2018-12-31 460 20     44   606   27           633
1189 1189 BAPTIST EMERGENCY HOSPITAL 16088 SAN PEDRO SAN ANTONIO TX 78232 BEXAR (210) 402-4092 Acute Care Hospitals Proprietary TRUE 29.5879550 -98.4741980 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-4y9d~e7dz-wrhw 670078 649389 2019-05-30 2018-12-31 50           50               50
1182 1182 SOUTH TEXAS SPINE AND SURGICAL HOSPITAL 18600 NORTH HARDY OAK BLVD SAN ANTONIO TX 78258 BEXAR (210) 404-0800 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.6132070 -98.4784930 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-hrzf~ehe3.nfy2 450856 648491 2019-05-30 2018-12-31 30           30               30
1190 1190 FOUNDATION SURGICAL HOSPITAL OF SAN ANTONIO 9522 HUEBNER ROAD SAN ANTONIO TX 78240 BEXAR (210) 478-5400 Acute Care Hospitals Proprietary TRUE 29.5310350 -98.5925540 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-pvs4~yydr-y7qv 670054 649387 2019-06-03 2018-12-31 20           20               20
1181 1181 TEXAS CENTER FOR INFECTIOUS DISEASE 2303 SE MILITARY DR P O BOX 23340 SAN ANTONIO TX 78223 BEXAR (210) 534-8857 Acute Care Hospitals Government - State FALSE 29.3519300 -98.4583770 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-suha~2mc2-p7yc                                      
1177 1177 METHODIST HOSPITAL 7700 FLOYD CURL DR SAN ANTONIO TX 78229 BEXAR (210) 575-4000 Acute Care Hospitals Proprietary TRUE 29.5068400 -98.5729760 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-xgb9_6gfp~4v63 450388 659736 2019-11-22 2019-06-30 1223 207       110 1560 10 67           1637
1184 1184 METHODIST AMBULATORY SURGERY HOSPITAL NW 9150 HUEBNER RD SUITE 100 SAN ANTONIO TX 78240 BEXAR (210) 575-5000 Acute Care Hospitals Proprietary TRUE 29.5276050 -98.5959950 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-f26r~6776-r3st 450780 650209 2019-05-31 2018-12-31 22           22               22
1178 1178 METHODIST STONE OAK HOSPITAL 1139 E SONTERRA BLVD, STE 535 SAN ANTONIO TX 78258 BEXAR (210) 638-2100 Acute Care Hospitals Proprietary TRUE 29.6144940 -98.4754590 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-32ag-t8fj-9ybq 670055 652855 2019-07-31 2019-02-28 175 28       24 227   15           242
1187 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
1188 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
1185 1185 Brooke Army Medical Center (FT Sam Houston) 3551 Roger Brooke Drive Fort Sam Houston TX 78234 BEXAR (210) 916-4141 Acute Care - Department of Defense Department of Defense TRUE 29.4604460 -98.4177790 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-9nff_a7kc-xmqq                                      
1183 1183 SOUTHWEST GENERAL HOSPITAL 7400 BARLITE BLVD SAN ANTONIO TX 78224 BEXAR (210) 921-2000 Acute Care Hospitals Physician TRUE 29.3529880 -98.5465890 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-yzdz.2e4a_mcwd 450697 644371 2019-02-28 2018-09-30 143 18       24 185 24 16           225
2205 2205 MOUNT SINAI HOSPITAL ONE GUSTAVE L LEVY PLACE NEW YORK NY 10029 NEW YORK (212) 241-7981 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7897618 -73.9533073 1 ROOFTOP 61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-nwxi~f8k4~kuex 330024 650188 2019-06-14 2018-12-31 943 75 14     35 1067 44 50           1161
2202 2202 NYU LANGONE HOSPITALS 550 FIRST AVENUE NEW YORK NY 10016 NEW YORK (212) 263-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7422600 -73.9746610 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-azm2~9p78_ewq7 330214 655134 2019-10-10 2019-08-31 1166 212       74 1468 57 104           1629
2199 2199 MOUNT SINAI BETH ISRAEL FIRST AVENUE AT 16TH STREET NEW YORK NY 10003 NEW YORK (212) 420-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7326650 -73.9816000 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-87ra-nmtn-zssr 330169 650305 2019-05-31 2018-12-31 449 28 8       485 69             554
2209 2209 METROPOLITAN HOSPITAL CENTER 1901 FIRST AVENUE NEW YORK NY 10029 NEW YORK (212) 423-6262 Acute Care Hospitals Government - Local TRUE 40.7847200 -73.9436360 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-qux6~jv33~mbyj 330199 662131 2019-12-18 2019-06-30 158 24       14 196 122 20           338
2204 2204 LENOX HILL HOSPITAL 100 EAST 77TH STREET NEW YORK NY 10021 NEW YORK (212) 439-2345 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7739640 -73.9606110 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-bw8f_jei6~sfm5 330119 650194 2019-05-30 2018-12-31 348 24 22     28 422 27             449
308 308 NORTH CENTRAL BRONX HOSPITAL 3424 KOSSUTH AVENUE & 210TH STREET BRONX NY 10467 BRONX (212) 519-5000 Acute Care Hospitals Government - Local TRUE 40.8804709 -73.8811305 1 RANGE_INTERPOLATED 5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-kzjb-7xtm_jntx 330385 661753 2019-12-03 2019-06-30 98 20       12 130 70             200
2207 2207 MOUNT SINAI WEST 1000 TENTH AVENUE NEW YORK NY 10019 NEW YORK (212) 523-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7701290 -73.9878460 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-eiz4-mdxh-q9ik 330046 650190 2019-05-30 2018-12-31 515 57 26     35 633 110 40           783
2201 2201 BELLEVUE HOSPITAL CENTER 462 FIRST AVENUE NEW YORK NY 10016 NEW YORK (212) 562-4141 Acute Care Hospitals Government - Local TRUE 40.7400790 -73.9762500 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-9bwr~dxtd~5pcz 330204 662231 2019-12-20 2019-06-30 445 45 12     25 527 339 46           912
2208 2208 ROCKEFELLER UNIVERSITY HOSPITAL 1230 YORK AVENUE NEW YORK NY 10021 NEW YORK (212) 570-8000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.7630490 -73.9565350 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-885m-j6aw~dtmp 330387 652152 2019-05-28 2018-12-31                              
307 307 BRONX-LEBANON HOSPITAL CENTER 1276 FULTON AVENUE BRONX NY 10456 BRONX (212) 588-7000 Acute Care Hospitals Proprietary TRUE 40.8317500 -73.9037560 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-ybqz_42sc_fi95 330009 650853 2019-06-27 2018-12-31 378 31 11     40 460 104             564
2206 2206 HOSPITAL FOR SPECIAL SURGERY 535 EAST 70TH STREET NEW YORK NY 10021 NEW YORK (212) 606-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7648660 -73.9531280 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-mivw~shdd.xqp7 330270 650876 2019-06-03 2018-12-31 215           215               215
2203 2203 NEW YORK-PRESBYTERIAN HOSPITAL-NEW YORK WEILL CORN 525 EAST 68TH STREET NEW YORK NY 10065 NEW YORK (212) 746-5454 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7641500 -73.9543350 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-fniq-8g6c~arqm 330101 650861 2019-06-03 2018-12-31 1792 198 44     146 2272 340 38           2650
2200 2200 HARLEM HOSPITAL CENTER 506 LENOX AVENUE NEW YORK NY 10037 NEW YORK (212) 939-1000 Acute Care Hospitals Government - Local TRUE 40.8144820 -73.9404950 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-ghrr_yxuq.x5j3 330240 662232 2019-12-20 2019-06-30 190 17 6 3   15 231 51             282
303 303 ST BARNABAS HOSPITAL 4422 THIRD AVENUE BRONX NY 10457 BRONX (212) 960-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8527700 -73.8921680 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-3gvt~bki7.kjpu 330399 649478 2019-06-11 2018-12-31 242 26       15 283 49             332
2198 2198 N Y EYE AND EAR INFIRMARY 230 SECOND AVE NEW YORK NY 10003 NEW YORK (212) 979-4000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.7325590 -73.9848160 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-5i5y_hgy2_5sdf 330100 650192 2019-06-14 2018-12-31 16           16               16
1501 1501 SHRINERS HOSPITALS FOR CHILDREN 3160 GENEVA STREET LOS ANGELES CA 90020 LOS ANGELES (213) 388-3151 Childrens Voluntary non-profit - Private FALSE 34.0677080 -118.2863870 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zkfj-xhi2.ce89 53310 655536 2018-05-31 2017-12-31                              
1460 1460 HOLLYWOOD PRESBYTERIAN MEDICAL CENTER 1300 N VERMONT AVE LOS ANGELES CA 90027 LOS ANGELES (213) 413-3000 Acute Care Hospitals Proprietary TRUE 34.0961160 -118.2917530 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8qce_cap7_t65z 50063 651260 2019-07-02 2018-12-31 266 36       15 317   28   89       434
1527 1527 SAINT VINCENT MEDICAL CENTER 2131 W 3RD ST LOS ANGELES CA 90057 LOS ANGELES (213) 484-7111 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.0631900 -118.2736650 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-eg7n_qzjr.u6rm 50502 660171 2019-11-25 2019-06-30 253 67         320   19   27       366
1466 1466 CALIFORNIA HOSPITAL MEDICAL CENTER LA 1401 SOUTH GRAND AVENUE LOS ANGELES CA 90015 LOS ANGELES (213) 748-2411 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.0372120 -118.2653630 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-azik.d4zd~xp8w 50149 659198 2019-11-18 2019-01-31 264 28       26 318               318
1511 1511 KAISER FOUNDATION HOSPITAL - WEST LA 6041 CADILLAC AVE LOS ANGELES CA 90034 LOS ANGELES (213) 857-2201 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.0379900 -118.3762470 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-di5k.pxvz-gest 50561 652225 2019-06-06 2018-12-31 222 31         265               265
1491 1491 GOOD SAMARITAN HOSPITAL 1225 WILSHIRE BOULEVARD LOS ANGELES CA 90017 LOS ANGELES (213) 977-2121 Acute Care Hospitals Proprietary FALSE 34.0532090 -118.2652920 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-bdi4_mszi_g3qn 50471 657674 2019-02-13 2018-08-31 248 39       23 310               310
1512 1512 L A DOWNTOWN MEDICAL CENTER 1711 WEST TEMPLE STREET LOS ANGELES CA 90026 LOS ANGELES (213) 989-6123 Acute Care Hospitals Proprietary FALSE 34.0687900 -118.2635600 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zwwh-h6yb.86z7 50763 650663 2019-05-31 2018-12-31 222 12         234               234
3503 3503 PINE CREEK MEDICAL CENTER LLP 9032 HARRY HINES BLVD DALLAS TX 75235 DALLAS (214) 231-2273 Acute Care Hospitals Proprietary TRUE 32.8401610 -96.8688350 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yjax~idz9_awg3 450894 648768 2019-05-24 2018-12-31 15           15               15
3507 3507 NORTH CENTRAL SURGICAL CENTER LLP 9301 NORTH CENTRAL EXPRESSWAY SUITE 100 DALLAS TX 75231 DALLAS (214) 265-2810 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8751790 -96.7706110 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-ky64~bu6d-5eb4 670049 651495 2019-05-29 2018-12-31 24           24               24
4643 4643 BAYLOR SCOTT AND WHITE EMERGENCY HOSPITAL BURLESON 12500 SOUTH FREEWAY SUITE 100 BURLESON TX 76028 JOHNSON (214) 294-6250 Acute Care Hospitals Proprietary TRUE 32.5760100 -97.3207740 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-f6z2_rbym-eqyb 670107 649156 2019-05-30 2018-12-31 24           24               24
3502 3502 DALLAS REGIONAL MEDICAL CENTER 1011 NORTH GALLOWAY AVENUE MESQUITE TX 75149 DALLAS (214) 320-7000 Acute Care Hospitals Proprietary TRUE 32.7775750 -96.5997200 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-f3bu_fxyn_gxk5 450688 649674 2019-05-30 2018-12-31 178 24         202               202

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