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

383 rows where "filed_date" is on date 2019-05-31 sorted by lng

View and edit SQL

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

filed_date (date)

  • 2019-05-31 · 383
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
2572 HAMILTON COUNTY HOSPITAL 700 NORTH HUSER SYRACUSE KS 67878 HAMILTON (620) 384-7461 Critical Access Hospitals Government - Local TRUE 37.9846055 -101.7426286 1 ROOFTOP 75 20 20075         https://data.medicare.gov/resource/xubh-q36u/row-aubk-tw4u-vx2j 171322 649228 2019-05-31 2018-12-31 25           25               25
4563 GRACE MEDICAL CENTER 2412 50TH ST LUBBOCK TX 79412 LUBBOCK (806) 788-4100 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.5487860 -101.8690980 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-yk9u_mrt4.dz5d 450162 649351 2019-05-31 2018-12-31 85 7         92               92
4559 LUBBOCK HEART HOSPITAL LP 4810 NORTH LOOP 289 LUBBOCK TX 79416 LUBBOCK (806) 687-7777 Acute Care Hospitals Proprietary TRUE 33.6025270 -101.9142870 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-h2tr.sjsi-mbq3 450876 650210 2019-05-31 2018-12-31 58 15         73               73
3027 MELISSA MEMORIAL HOSPITAL 1001 E JOHNSON ST HOLYOKE CO 80734 PHILLIPS (970) 854-2241 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.5784280 -102.2902490 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-6wcd-peh6-fsnb 61305 650244 2019-05-31 2018-12-31 15           15               15
3138 PROWERS MEDICAL CENTER 401 KENDALL DR LAMAR CO 81052 PROWERS (719) 336-4343 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.0709150 -102.6090680 0   99 8 8099         https://data.medicare.gov/resource/xubh-q36u/row-g7ky~tb82~a5bh 61323 650118 2019-05-31 2018-12-31 25           25               25
3028 HAXTUN HOSPITAL DISTRICT 235 W FLETCHER ST HAXTUN CO 80731 PHILLIPS (970) 774-6123 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6413860 -102.6308660 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-amj6-3hms~eqap 61304 649172 2019-05-31 2018-12-31 25           25               25
1819 FALL RIVER HOSPITAL - CAH 1201 HIGHWAY 71 SOUTH HOT SPRINGS SD 57747 FALL RIVER (605) 745-8910 Critical Access Hospitals Government - Local TRUE 43.4183120 -103.4807830 0   47 46 46047         https://data.medicare.gov/resource/xubh-q36u/row-85xb~ejm9_5eec 431322 650784 2019-05-31 2018-12-31 25           25       48       73
2448 MT SAN RAFAEL HOSPITAL 410 BENEDICTA AVE TRINIDAD CO 81082 LAS ANIMAS (719) 846-9213 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1733800 -104.4887960 0   71 8 8071         https://data.medicare.gov/resource/xubh-q36u/row-wzww_3ykk~yfx8 61321 650245 2019-05-31 2018-12-31 25           25               25
58 PLATTE VALLEY MEDICAL CENTER 1600 PRAIRIE CENTER PKWY BRIGHTON CO 80601 ADAMS (303) 498-1601 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9654410 -104.7709240 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-nf6e_r5cw.zmhy 60004 648669 2019-05-31 2018-12-31 65 8         89               89
260 MEDICAL CENTER OF AURORA, THE 1501 S POTOMAC ST AURORA CO 80012 ARAPAHOE (303) 873-5511 Acute Care Hospitals Proprietary TRUE 39.6893460 -104.8311500 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-b8kj.p6xy-3gvh 60100 648892 2019-05-31 2018-12-31 250 45       14 309 20             329
61 NORTH SUBURBAN MEDICAL CENTER 9191 GRANT ST THORNTON CO 80229 ADAMS (303) 451-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8643800 -104.9847830 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-tvxk_43rk.h2qn 60065 649402 2019-05-31 2018-12-31 111 16         127               127
1204 DENVER HEALTH MEDICAL CENTER 777 BANNOCK ST DENVER CO 80204 DENVER (303) 602-4930 Acute Care Hospitals Government - State TRUE 39.7282300 -104.9900660 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-6si7.z49y~jb56 60011 650437 2019-05-31 2018-12-31 298 32     23 25 378 64 11           453
2130 LUTHERAN MEDICAL CENTER 8300 W 38TH AVE WHEAT RIDGE CO 80033 JEFFERSON (303) 425-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7693280 -105.0892910 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-h45t-vvz5~5dzw 60009 649546 2019-05-31 2018-12-31 148 18         186 96         24   306
3930 THE HOSPITALS OF PROVIDENCE EAST CAMPUS 3280 JOE BATTLE BLVD EL PASO TX 79938 EL PASO (915) 856-7349 Acute Care Hospitals Proprietary TRUE 31.7904350 -106.2676440 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-5s8k_vnib_7trn 670047 648514 2019-05-31 2018-12-31 146 24       12 182               182
3925 THE HOSPITALS OF PROVIDENCE TRANSMOUNTAIN CAMPUS 2000 TRANSMOUNTAIN RD EL PASO TX 79911 EL PASO (915) 877-8136 Acute Care Hospitals Proprietary TRUE 31.9044828 -106.5650394 1 ROOFTOP 141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-8cqi.sqna_eif8 670120 649983 2019-05-31 2018-12-31 94 12         106               106
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
2341 ANIMAS SURGICAL HOSPITAL, LLC 575 RIVERGATE LN DURANGO CO 81301 LA PLATA (970) 247-3537 Acute Care Hospitals Physician TRUE 37.2488890 -107.8707740 0   67 8 8067 20420   Central La Plata County https://data.medicare.gov/resource/xubh-q36u/row-twp9-b345.bypu 60117 650115 2019-05-31 2018-12-31 12           12               12
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
2597 ST MARYS MEDICAL CENTER 2635 N 7TH ST GRAND JUNCTION CO 81502 MESA (970) 298-1950 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.0906040 -108.5614390 0   77 8 8077 24300   Central Mesa County https://data.medicare.gov/resource/xubh-q36u/row-qity~ffvk.qimr 60023 649708 2019-05-31 2018-12-31 195 18 14       257   24           281
2598 COMMUNITY HOSPITAL 2351 'G' ROAD GRAND JUNCTION CO 81505 MESA (970) 256-6201 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.1062970 -108.6153120 0   77 8 8077 24300   Central Mesa County https://data.medicare.gov/resource/xubh-q36u/row-wkps-5qwm~bkr5 60054 649873 2019-05-31 2018-12-31 41 12         53               53
3247 RANGELY DISTRICT HOSPITAL 225 EAGLE CREST ST RANGELY CO 81648 RIO BLANCO (970) 675-5011 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0802840 -108.8059100 0   103 8 8103         https://data.medicare.gov/resource/xubh-q36u/row-8932~ad3b_gnnd 61307 650116 2019-05-31 2018-12-31 25           25               25
1480 SAN JUAN HOSPITAL 380 WEST 100 NORTH MONTICELLO UT 84535 SAN JUAN (435) 587-2116 Critical Access Hospitals Government - Local TRUE 37.8738750 -109.3500620 0   37 49 49037         https://data.medicare.gov/resource/xubh-q36u/row-bwvs.75rh_updn 461308 650788 2019-05-31 2018-12-31 20 1         21               21
1280 BOZEMAN HEALTH DEACONESS HOSPITAL 915 HIGHLAND BLVD BOZEMAN MT 59715 GALLATIN (406) 585-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6702780 -111.0172390 0   31 30 30031 14580   Central Gallatin County https://data.medicare.gov/resource/xubh-q36u/row-avzt.zzb8~xv3b 270057 650725 2019-05-31 2018-12-31 75 8         83               83
1620 SANPETE VALLEY HOSPITAL - CAH 1100 SOUTH MEDICAL DRIVE MOUNT PLEASANT UT 84647 SANPETE (435) 462-4123 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5318030 -111.4611940 0   39 49 49039         https://data.medicare.gov/resource/xubh-q36u/row-44ik~upe5.vztv 461303 649841 2019-05-31 2018-12-31 18           18               18
322 LOGAN REGIONAL HOSPITAL 500 EAST 1400 NORTH LOGAN UT 84341 CACHE (435) 716-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7574610 -111.8228770 0   5 49 49005 30860   Central Cache County https://data.medicare.gov/resource/xubh-q36u/row-248k.jdp3-ibnu 460015 649977 2019-05-31 2018-12-31 83 14       33 130 7     14       151
569 SCOTTSDALE SHEA MEDICAL CENTER 9003 EAST SHEA BOULEVARD SCOTTSDALE AZ 85260 MARICOPA (480) 323-3000 Acute Care Hospitals Proprietary TRUE 33.5824670 -111.8860320 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-zegy.nw3j~tfkb 30087 650231 2019-05-31 2018-12-31 378 25       24 427               427
551 SCOTTSDALE THOMPSON PEAK MEDICAL CENTER 7400 EAST THOMPSON PEAK PARKWAY SCOTTSDALE AZ 85255 MARICOPA (480) 324-7001 Acute Care Hospitals Proprietary TRUE 33.6697770 -111.9218030 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-y7bn~8g49_tr6b 30123 650235 2019-05-31 2018-12-31 112 8         120               120
555 SCOTTSDALE OSBORN MEDICAL CENTER 7400 EAST OSBORN ROAD SCOTTSDALE AZ 85251 MARICOPA (480) 882-4004 Acute Care Hospitals Proprietary TRUE 33.4876390 -111.9227250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-xncf.ukg7_66e2 30038 650230 2019-05-31 2018-12-31 268 59         327   14           341
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
539 PHOENIX CHILDREN'S HOSPITAL 1919 EAST THOMAS ROAD PHOENIX AZ 85016 MARICOPA (602) 933-1000 Childrens Voluntary non-profit - Private FALSE 33.4802160 -112.0411930 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-feed_vt9a~9ie7 33302 650636 2019-05-31 2018-12-31 352           433               433
558 JOHN C. LINCOLN NORTH MOUNTAIN HOSPITAL 250 EAST DUNLAP AVENUE PHOENIX AZ 85020 MARICOPA (602) 331-5862 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5677540 -112.0706300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-9bpm.fdh7~5snu 30014 650229 2019-05-31 2018-12-31 218 20 24       262               262
550 HONORHEALTH DEER VALLEY MEDICAL CENTER 19829 NORTH 27TH AVENUE PHOENIX AZ 85027 MARICOPA (623) 879-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6664250 -112.1171880 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-npyt_2wmd.v5z4 30092 650232 2019-05-31 2018-12-31 172   32       204               204
3170 BENEFIS TETON MEDICAL CENTER 915 4TH ST NW CHOTEAU MT 59422 TETON (406) 466-5763 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.8134200 -112.1924570 0   99 30 30099         https://data.medicare.gov/resource/xubh-q36u/row-f2z3-5ua9~t2zq 271307 650727 2019-05-31 2018-12-31 25           25               25
3002 ST JAMES HEALTHCARE 400 S CLARK ST BUTTE MT 59701 SILVER BOW (406) 723-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.0092800 -112.5460680 0   93 30 30093 15580   Central Silver Bow County https://data.medicare.gov/resource/xubh-q36u/row-spzg~vydz~yvmh 270017 650295 2019-05-31 2018-12-31 60 11         71               71
931 CEDAR CITY HOSPITAL 1303 NORTH MAIN STREET CEDAR CITY UT 84721 IRON (435) 868-5800 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7005910 -113.0639850 0   21 49 49021 16260   Central Iron County https://data.medicare.gov/resource/xubh-q36u/row-v2cb~88mw~jehb 460007 649976 2019-05-31 2018-12-31 42 6         48               48
2257 ST PATRICK HOSPITAL 500 W BROADWAY MISSOULA MT 59806 MISSOULA (406) 543-7271 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.8739050 -113.9998910 0   63 30 30063 33540   Central Missoula County https://data.medicare.gov/resource/xubh-q36u/row-44i5~53xu-fjn4 270014 650294 2019-05-31 2018-12-31 134 24         158 30             188
203 NORTH VISTA HOSPITAL 1409 EAST LAKE MEAD BLVD NORTH LAS VEGAS NV 89030 CLARK (702) 657-5504 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1957390 -115.1229860 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-in5k~58hj~u63s 290005 649922 2019-05-31 2018-12-31 116 20         136 41             177
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
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
1936 NEWPORT COMMUNITY HOSPITAL 714 WEST PINE STREET NEWPORT WA 99156 PEND OREILLE (509) 447-2441 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.1821700 -117.0484200 0   51 53 53051 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Outlying Pend Oreille County https://data.medicare.gov/resource/xubh-q36u/row-kwpj_pxfj.xt2b 501310 649686 2019-05-31 2018-12-31 20           20       50       70
2437 DESERT VALLEY HOSPITAL 16850 BEAR VALLEY RD VICTORVILLE CA 92395 SAN BERNARDINO (760) 241-8000 Acute Care Hospitals Proprietary TRUE 34.4709110 -117.2970990 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-uayf.ig5a-imaz 50709 650659 2019-05-31 2018-12-31 120 18       10 148               148
2436 SAN ANTONIO REGIONAL HOSPITAL 999 SAN BERNARDINO ROAD UPLAND CA 91786 SAN BERNARDINO (714) 985-2811 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.1010790 -117.6368620 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-g5xk-6es3.hraq 50099 650642 2019-05-31 2018-12-31 307 24 12       363               363
2432 CHINO VALLEY MEDICAL CENTER 5451 WALNUT AVE CHINO CA 91710 SAN BERNARDINO (909) 627-6111 Acute Care Hospitals Proprietary TRUE 34.0263510 -117.6859880 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-ktzz.hdbu_ejnf 50586 649539 2019-05-31 2018-12-31 98 14         112               112
2446 MONTCLAIR HOSPITAL MEDICAL CENTER 5000 SAN BERNARDINO ST MONTCLAIR CA 91763 SAN BERNARDINO (909) 625-8300 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0776620 -117.6960980 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-mnmv_8wbu.rs56 50758 651372 2019-05-31 2018-12-31 98 8         106               106
1521 SAN DIMAS COMMUNITY HOSPITAL 1350 W COVINA BLVD SAN DIMAS CA 91773 LOS ANGELES (909) 599-6811 Acute Care Hospitals Proprietary TRUE 34.0994230 -117.8350060 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8cu2-sqr5-vidq 50588 649167 2019-05-31 2018-12-31 87 8         95               95
1486 GLENDORA COMMUNITY HOSPITAL 150 WEST ROUTE 66 GLENDORA CA 91740 LOS ANGELES (626) 335-0231 Acute Care Hospitals Proprietary TRUE 34.1286850 -117.8651930 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-pbt3-vx8t-nmwi 50205 652416 2019-05-31 2018-12-31 97 10         107 21             128
1489 EMANATE HEALTH FOOTHILL PRESBYTERIAN HOSPITAL 250 S GRAND AVE GLENDORA CA 91740 LOS ANGELES (626) 963-8411 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.1331960 -117.8725340 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-n2zj-qczt_8x5z 50597 650655 2019-05-31 2018-12-31 87 18         105               105
1508 EMANATE HEALTH INTER-COMMUNITY HOSPITAL 210 W SAN BERNARDINO ROAD COVINA CA 91723 LOS ANGELES (626) 814-2468 Acute Care Hospitals Proprietary TRUE 34.0899470 -117.8936660 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-ywn3.ebem-km5h 50382 650652 2019-05-31 2018-12-31 401 20 20     40 481   12   23   10   526
2111 FOUNTAIN VALLEY REGIONAL HOSPITAL & MEDICAL CENTER 17100 EUCLID STREET FOUNTAIN VALLEY CA 92708 ORANGE (714) 966-7200 Acute Care Hospitals Proprietary TRUE 33.7154350 -117.9370120 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-tpzf_iuv9-ahdh 50570 651444 2019-05-31 2018-12-31 341 36       23 400               400
1526 METHODIST HOSPITAL OF SOUTHERN CA 300 W HUNTINGTON DR ARCADIA CA 91006 LOS ANGELES (626) 445-4441 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1348620 -118.0424460 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-6kcb_f45p-w2qb 50238 659203 2019-05-31 2018-12-31 252 49         318   30           348
1485 WHITE MEMORIAL MEDICAL CENTER 1720 E CESAR AVENUE LOS ANGELES CA 90033 LOS ANGELES (323) 268-5000 Acute Care Hospitals Voluntary non-profit - Church FALSE 34.0492967 -118.2171632 1 ROOFTOP 37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-n689-ji7q_qdqg 50103 659189 2019-05-31 2018-12-31 243 34       5 310   16   27       353
1463 GLENDALE ADVENTIST MEDICAL CENTER 1509 E WILSON TERRACE GLENDALE CA 91206 LOS ANGELES (818) 409-8202 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1491610 -118.2303540 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-9sbg-4wtr.teeu 50239 649399 2019-05-31 2018-12-31 277   20   12 14 323 60 28   40       451
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
129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
1126 ADVENTIST HEALTH TEHACHAPI VALLEY 1100 MAGELLAN TEHACHAPI CA 93561 KERN (661) 823-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1474419 -118.4504364 1 ROOFTOP 29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-xx6n.a25c~74jx 51301 648598 2019-05-31 2018-12-31 16 4         20               20
1498 WEST HILLS HOSPITAL & MEDICAL CENTER 7300 MEDICAL CENTER DR WEST HILLS CA 91307 LOS ANGELES (818) 676-4100 Acute Care Hospitals Proprietary FALSE 34.2029310 -118.6285980 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-iyjd_idr8.tn3h 50481 649165 2019-05-31 2018-12-31 192 25       11 228               228
3417 ADVENTIST HEALTH SIMI VALLEY 2975 N SYCAMORE DR SIMI VALLEY CA 93065 VENTURA (805) 955-6000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2888370 -118.7439600 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-dj8u_rx6h_z8s8 50236 659202 2019-05-31 2018-12-31 112 24       8 144               144
3416 LOS ROBLES HOSPITAL & MEDICAL CENTER 215 W JANSS RD THOUSAND OAKS CA 91360 VENTURA (805) 497-2727 Acute Care Hospitals Proprietary FALSE 34.2063980 -118.8826240 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-bmvs~zrq2-ffw7 50549 650653 2019-05-31 2018-12-31 241 24 10       287   40           327
1124 ADVENTIST HEALTH BAKERSFIELD 2615 CHESTER AVENUE BAKERSFIELD CA 93301 KERN (661) 395-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3830560 -119.0188570 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-siqs~heps~67ia 50455 649164 2019-05-31 2018-12-31 211 34         254               254
1125 DELANO REGIONAL MEDICAL CENTER 1401 GARCES HIGHWAY DELANO CA 93215 KERN (661) 725-4800 Acute Care Hospitals Proprietary TRUE 35.7614180 -119.2388780 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-6xns.bkw3_m9qr 50608 650656 2019-05-31 2018-12-31 95 10         105       2   49   156
816 ADVENTIST HEALTH REEDLEY 372 W CYPRESS AVE REEDLEY CA 93654 FRESNO (559) 638-8155 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.6078120 -119.4516950 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-re3j_d2jv_jrs3 50192 659200 2019-05-31 2018-12-31 49           49               49
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
295 CARSON VALLEY MEDICAL CENTER 1107 HIGHWAY 395 GARDNERVILLE NV 89410 DOUGLAS (775) 782-1500 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9195628 -119.7189852 1 ROOFTOP 5 32 32005 23820 Reno-Carson City-Fernley, NV Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-zs3t-b2ik_qdz7 291306 650728 2019-05-31 2018-12-31 23           23               23
2735 SANTA BARBARA COTTAGE HOSPITAL 400 WEST PUEBLO SANTA BARBARA CA 93102 SANTA BARBARA (805) 682-7111 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.4294830 -119.7230770 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-tvaw.4z7e-2im9 50396 652419 2019-05-31 2018-12-31 255 20     20 8 325   38           363
326 PROSSER MEMORIAL HOSPITAL 723 MEMORIAL STREET PROSSER WA 99350 BENTON (509) 786-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.2076300 -119.7635020 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-jxdy-bhag~5gk3 501312 652444 2019-05-31 2018-12-31 25           25               25
4731 CARSON TAHOE REGIONAL MEDICAL CENTER 1600 MEDICAL PARKWAY CARSON CITY NV 89703 CARSON CITY (775) 445-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2018990 -119.7817290 0   510 32 32510 16180 Reno-Carson City-Fernley, NV Central Carson City https://data.medicare.gov/resource/xubh-q36u/row-r9kk~qdv6~axip 290019 649923 2019-05-31 2018-12-31 151 24         175 36             211
2737 GOLETA VALLEY COTTAGE HOSPITAL 351 S PATTERSON AVE SANTA BARBARA CA 93111 SANTA BARBARA (805) 681-6446 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.4336990 -119.8093220 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-rh7j_i3k3-gwyy 50357 652391 2019-05-31 2018-12-31 20 8         28               28
726 BARTON MEMORIAL HOSPITAL 2170 SOUTH AVENUE SOUTH LAKE TAHOE CA 96150 EL DORADO (530) 541-3420 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9123370 -119.9977110 0   17 6 6017 40900 Sacramento-Roseville, CA Central El Dorado County https://data.medicare.gov/resource/xubh-q36u/row-kae2-ekyj_hpjm 50352 652418 2019-05-31 2018-12-31 55 8         63       11 37     111
2736 SANTA YNEZ VALLEY COTTAGE HOSPITAL 2050 VIBORG RD SOLVANG CA 93463 SANTA BARBARA (805) 688-6431 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6024650 -120.1266430 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-crjd-giis~8ixz 51331 648601 2019-05-31 2018-12-31 11           11               11
396 CONFLUENCE HEALTH- WENATCHEE VALLEY HOSP & CLINICS 820 NORTH CHELAN AVENUE WENATCHEE WA 98801 CHELAN (509) 663-8711 Acute Care Hospitals Voluntary non-profit - Private FALSE 47.4335660 -120.3219830 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-aiqi_mn7n_vecf 500148 650791 2019-05-31 2018-12-31 11           11   9           20
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
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
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
2321 MID-COLUMBIA MEDICAL CENTER 1700 E 19TH STREET THE DALLES OR 97058 WASCO (541) 296-1111 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.5879480 -121.1654700 0   65 41 41065 45520   Central Wasco County https://data.medicare.gov/resource/xubh-q36u/row-bx62.pzwr_8uvb 380001 649817 2019-05-31 2018-12-31 26 17         43   6           49
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
342 ADVENTIST HEALTH FEATHER RIVER 5974 PENTZ ROAD PARADISE CA 95969 BUTTE (530) 877-9361 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7561610 -121.5723050 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-dx3c~3bgg.9vjq 50225 659201 2019-05-31 2018-12-31                              
1984 MULTICARE GOOD SAMARITAN HOSPITAL 401 15TH AVENUE SE PUYALLUP WA 98372 PIERCE (253) 697-2102 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.1774110 -122.2894680 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-d55j~6ytb~rwq5 500079 649844 2019-05-31 2018-12-31 250 20         283   38           321
2880 PATIENTS' HOSPITAL OF REDDING 2900 EUREKA WAY REDDING CA 96001 SHASTA (530) 225-8700 Acute Care Hospitals Physician FALSE 40.5854900 -122.4162640 0   89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-5vur~pqci_pq3w 50697 650657 2019-05-31 2018-12-31 10           10               10
1314 ADVENTIST HEALTH CLEARLAKE 15630 18TH AVE - HWY 53 CLEARLAKE CA 95422 LAKE (707) 994-6486 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.9353458 -122.6200816 1 ROOFTOP 33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-hud3~fp2e-cmcb 51317 648600 2019-05-31 2018-12-31 21 4         25               25
1192 WHIDBEYHEALTH MEDICAL CENTER 101 NORTH MAIN STREET COUPEVILLE WA 98239 ISLAND (360) 678-5151 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.2142400 -122.6861220 0   29 53 53029 36020 Seattle-Tacoma, WA Central Island County https://data.medicare.gov/resource/xubh-q36u/row-uede_fy5z~txux 501339 649688 2019-05-31 2018-12-31 19 6         25               25
3297 TRINITY HOSPITAL 60 EASTER AVENUE WEAVERVILLE CA 96093 TRINITY (530) 623-5541 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.7375790 -122.9394440 0   105 6 6105         https://data.medicare.gov/resource/xubh-q36u/row-yq5n_hvzx.n2t3 51315 650664 2019-05-31 2018-12-31 25           25       23       48
1767 MASON GENERAL HOSPITAL & FAMILY OF CLINICS 901 MT VIEW DRIVE SHELTON WA 98584 MASON (360) 426-1611 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.2267420 -123.1152790 0   45 53 53045 43220 Seattle-Tacoma, WA Central Mason County https://data.medicare.gov/resource/xubh-q36u/row-hitj-vpec_8dkv 501336 649687 2019-05-31 2018-12-31 19 6         25               25
1724 ADVENTIST HEALTH UKIAH VALLEY 275 HOSPITAL DRIVE UKIAH CA 95482 MENDOCINO (707) 462-3111 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1530190 -123.2038000 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-5xip-9esx.8u6b 50301 649538 2019-05-31 2018-12-31 42 6       2 50               50
1988 HIMA-SAN PABLO FAJARDO GENERAL VALERO AVE#404 FAJARDO PR 738 FAJARDO (787) 655-0505 Acute Care Hospitals Proprietary TRUE 18.3356291 -65.6532034 1 ROOFTOP 53 72 72053 41980 San Juan-Carolina, PR Outlying Fajardo Municipio https://data.medicare.gov/resource/xubh-q36u/row-97wi-8fxd.yjx6 400125 650362 2019-05-31 2018-12-31 163 17         180               180
2421 HIMA SAN PABLO HUMACAO CALLE FONT MARTELO #3 HUMACAO PR 791 HUMACAO (787) 852-2424 Acute Care Hospitals Proprietary TRUE 18.1505887 -65.8266744 1 ROOFTOP 69 72 72069 41980 San Juan-Carolina, PR Central Humacao Municipio https://data.medicare.gov/resource/xubh-q36u/row-qp8j~6s5w~t5hf 400005 650770 2019-05-31 2018-12-31 58 6         64               64
3769 DOCTOR CENTER HOSPITAL SAN FERNANDO DE LA CAROLINA EDIF JESUS T PINEIRO AVE FERNANDEZ JUNCOS BO PUEBL CAROLINA PR 979 SAN JUAN (787) 725-6038 Acute Care Hospitals Government - State TRUE 18.4215119 -66.0256637 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-ngg4_t8sn.3cyg 400132 650363 2019-05-31 2018-12-31 103 6         109               109
1057 HIMA SAN PABLO-CAGUAS AVE LUIS MUNOZ MARIN CAGUAS PR 725 CAGUAS (787) 653-3434 Acute Care Hospitals Proprietary TRUE 18.2270107 -66.0273180 1 GEOMETRIC_CENTER 25 72 72025 41980 San Juan-Carolina, PR Central Caguas Municipio https://data.medicare.gov/resource/xubh-q36u/row-7siz.yb89_3gij 400120 649347 2019-05-31 2018-12-31 394 46         440               440
3767 METROPOLITAN HOSPITAL CARRETERA 21 1785 URB LAS LOMAS SAN JUAN PR 915 SAN JUAN (787) 782-9999 Acute Care Hospitals Proprietary TRUE 18.3896633 -66.0988444 1 ROOFTOP 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-iham_kjk3_hiuu 400106 649952 2019-05-31 2018-12-31 126 6         132     15         147
938 HIMA SAN PABLO BAYAMON 70 CALLE SANTA CRUZ BAYAMON PR 961 BAYAMON (787) 620-4747 Acute Care Hospitals Proprietary TRUE 18.3976640 -66.1496740 0   21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-gt9f-5hpz-5v3k 400109 650772 2019-05-31 2018-12-31 290 39 7       336               336
3994 CENTRO MEDICO WILMA N VAZQUEZ CARR. 2 KM 39.5 ROAD NUMBER 2 BO ALGARROBO VEGA BAJA PR 693 VEGA BAJA (787) 858-1580 Acute Care Hospitals Proprietary TRUE 18.4433265 -66.4180747 1 GEOMETRIC_CENTER 145 72 72145 41980 San Juan-Carolina, PR Central Vega Baja Municipio https://data.medicare.gov/resource/xubh-q36u/row-7zfj_f2en-e6zu 400115 650774 2019-05-31 2018-12-31 124 6         130       20       150
2983 DOCTORS' CENTER HOSPITAL, INC MARGINAL CARRETERA NO 2, KM 47 7 MANATI PR 674 MANATI (787) 853-3322 Acute Care Hospitals Proprietary TRUE 18.4344971 -66.4738542 1 GEOMETRIC_CENTER 91 72 72091 41980 San Juan-Carolina, PR Central Manatí Municipio https://data.medicare.gov/resource/xubh-q36u/row-gyis.f2r7_nau5 400118 650775 2019-05-31 2018-12-31 254 8         262               262
663 HOSPITAL DR SUSONI INC 55 PALM ST ARECIBO PR 614 ARECIBO (787) 650-1031 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.4726154 -66.7164601 1 APPROXIMATE 13 72 72013 11640 San Juan-Carolina, PR Central Arecibo Municipio https://data.medicare.gov/resource/xubh-q36u/row-sxrh-3iek~wydv 400117 648863 2019-05-31 2018-12-31 114 6         120               120
3736 HOSPITAL DE LA CONCEPCION ROAD NUMBER 2 KM 173.4 CAIN ALTO SAN GERMAN PR 683 SAN GERMAN (787) 892-1860 Acute Care Hospitals Voluntary non-profit - Church TRUE 18.0988246 -67.0382886 1 GEOMETRIC_CENTER 125 72 72125 41900 Mayagüez-San Germán, PR Central San Germán Municipio https://data.medicare.gov/resource/xubh-q36u/row-ud6p-v4z7-e8nu 400021 649494 2019-05-31 2018-12-31 143 12       12 167   19           186
3737 HOSPITAL METROPOLITANO SAN GERMAN CALLE JAVILLA #8 AL COSTADO PARQUE DE BOMBAS SAN GERMAN PR 683 SAN GERMAN (787) 892-5300 Acute Care Hospitals Proprietary TRUE 18.0824930 -67.0401082 1 ROOFTOP 125 72 72125 41900 Mayagüez-San Germán, PR Central San Germán Municipio https://data.medicare.gov/resource/xubh-q36u/row-vvsg~hsvv~xuim 400126 649953 2019-05-31 2018-12-31 59 6         65               65
7 DOWN EAST COMMUNITY HOSPITAL 11 HOSPITAL DRIVE MACHIAS ME 4654 WASHINGTON (207) 255-3356 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7134110 -67.4772030 0   29 23 23029         https://data.medicare.gov/resource/xubh-q36u/row-tmd2.zxhs~phzc 201311 650481 2019-05-31 2018-12-31 25           25               25
176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
833 PENOBSCOT VALLEY HOSPITAL 7 TRANSALPINE ROAD, PO BOX 368 LINCOLN ME 4457 PENOBSCOT (207) 794-3321 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3487330 -68.5162580 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-zcrj.qk59-ua67 201303 650480 2019-05-31 2018-12-31 25           25               25
1075 WALDO COUNTY GENERAL HOSPITAL 118 NORTHPORT AVE BELFAST ME 4915 WALDO (207) 338-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4127590 -68.9951020 0   27 23 23027         https://data.medicare.gov/resource/xubh-q36u/row-9ec9_eza5.9s9p 201312 650482 2019-05-31 2018-12-31 21 4         25               25
608 PENOBSCOT BAY MEDICAL CENTER 6 GLEN COVE DRIVE ROCKPORT ME 4856 KNOX (207) 921-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1444340 -69.0865370 0   13 23 23013         https://data.medicare.gov/resource/xubh-q36u/row-ahvj_huyh~m44w 200063 650478 2019-05-31 2018-12-31 73 8         81       84       165
685 LINCOLN HEALTH 35 MILES STREET DAMARISCOTTA ME 4543 LINCOLN (207) 563-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0261990 -69.5271640 0   15 23 23015         https://data.medicare.gov/resource/xubh-q36u/row-mrex~j496-ppyw 201302 650479 2019-05-31 2018-12-31 21 4         25       42       67

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