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

325 rows where "filed_date" is on date 2019-06-03 sorted by emergency_services

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_oth_beds, nursing_fac_beds, fy_end_date (date)

filed_date (date)

  • 2019-06-03 · 325
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
168 THE ORTHOPAEDIC HOSPITAL OF LUTHERAN HEALTH NETWOR 7952 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-2999 Acute Care Hospitals Proprietary FALSE 41.0373520 -85.2459180 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-65sn_hsdz_dbbf 150168 649728 2019-06-03 2018-12-31 39           39               39
216 CUBA MEMORIAL HOSPITAL, INC 140 WEST MAIN STREET CUBA NY 14727 ALLEGANY (585) 961-2000 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.2133410 -78.2881390 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-2ir6~7udp_pyzv 331301 651038 2019-06-03 2018-12-31 20           20       61       81
221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
310 UNIVERSITY HOSPITALS SAMARITAN MEDICAL CENTER 1025 CENTER ST ASHLAND OH 44805 ASHLAND (419) 289-0491 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.8587020 -82.3104130 0   5 39 39005 11740 Mansfield-Ashland-Bucyrus, OH Central Ashland County https://data.medicare.gov/resource/xubh-q36u/row-suim.pydj-jawn 360002 649303 2019-06-03 2018-12-31 33 6         39               39
337 BANNER PAYSON MEDICAL CENTER 807 SOUTH PONDEROSA DRIVE PAYSON AZ 85541 GILA (928) 474-3222 Critical Access Hospitals Voluntary non-profit - Other FALSE 34.2313510 -111.3213610 0   7 4 4007 37740   Central Gila County https://data.medicare.gov/resource/xubh-q36u/row-2gy2.vxfy~pkyq 31318 649532 2019-06-03 2018-12-31 21 4         25               25
425 MAUI MEMORIAL MEDICAL CENTER 221 MAHALANI STREET WAILUKU HI 96793 MAUI (808) 442-5101 Acute Care Hospitals Government - State FALSE 20.8844550 -156.4880870 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-66fd~zrmp.8s5u 120002 649892 2019-06-03 2018-12-31 199 20         219               219
572 BANNER HEART HOSPITAL 6750 EAST BAYWOOD AVENUE MESA AZ 85206 MARICOPA (480) 854-5050 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4103780 -111.6852730 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-tx6q_94yb.s344 30105 651582 2019-06-03 2018-12-31 67   44       111               111
575 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL 7171 SOUTH 51ST AVENUE LAVEEN AZ 85339 MARICOPA (623) 584-5100 Acute Care Hospitals Proprietary FALSE 33.3806770 -112.1682330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6h9g-s46a~aiyi 30136 651169 2019-06-03 2018-12-31 16           16               16
576 CORE INSTITUTE SPECIALTY HOSPITAL, THE 6501 NORTH 19TH AVENUE PHOENIX AZ 85015 MARICOPA (602) 795-6020 Acute Care Hospitals Physician FALSE 33.5318370 -112.0996140 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j 30108 659179 2019-06-03 2018-12-31 32           32               32
582 BANNER BAYWOOD MEDICAL CENTER 6644 EAST BAYWOOD AVENUE MESA AZ 85206 MARICOPA (480) 321-2000 Acute Care Hospitals Voluntary non-profit - Private FALSE 33.4104650 -111.6880450 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-xp3v_96ea.bqwa 30088 649064 2019-06-03 2018-12-31 292 26         318   22           340
656 HALQUIST MEMORIAL INPATIENT CENTER 4715 NORTH 15 STREET ARLINGTON VA 22205 ARLINGTON (703) 525-7070 Acute Care Hospitals Voluntary non-profit - Private FALSE 38.8879410 -77.1216690 0   13 51 51013 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Arlington County https://data.medicare.gov/resource/xubh-q36u/row-vmzf.p4zi.8e5f 490129 651083 2019-06-03 2018-12-31                         36   36
740 SPECIALISTS HOSPITAL SHREVEPORT 1500 LINE AVENUE SHREVEPORT LA 71101 CADDO (318) 213-3800 Acute Care Hospitals Physician FALSE 32.4969260 -93.7460460 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi 190278 649901 2019-06-03 2018-12-31 15           15               15
785 ROTHMAN ORTHOPAEDIC SPECIALTY HOSPITAL LLC 3300 TILLMAN DRIVE BENSALEM PA 19020 BUCKS (215) 244-7400 Acute Care Hospitals Proprietary FALSE 40.1143500 -74.9620930 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-w5gs-9pze-8zau 390322 649490 2019-06-03 2018-12-31 24           24               24
1530 OLYMPIA MEDICAL CENTER 5900 WEST OLYMPIC BOULEVARD LOS ANGELES CA 90036 LOS ANGELES (310) 657-5900 Acute Care Hospitals Proprietary FALSE 34.0575270 -118.3598570 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-h6xu_zz9e_g4g4 50742 649703 2019-06-03 2018-12-31 192   12       204               204
1863 WOODS AT PARKSIDE,THE 349 OLDE RIDENOUR ROAD COLUMBUS OH 43230 FRANKLIN (614) 471-2552 Acute Care Hospitals Proprietary FALSE 40.0268200 -82.8811560 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-4avu~kmf5~3quj 360247 649648 2019-06-03 2018-12-31 12         38 50               50
1905 OMEGA HOSPITAL, LLC 2525 SEVERN AVENUE METAIRIE LA 70002 JEFFERSON (504) 849-4900 Acute Care Hospitals Proprietary FALSE 29.9991620 -90.1595830 0   51 22 22051 35380 New Orleans-Metairie-Hammond, LA-MS Central Jefferson Parish https://data.medicare.gov/resource/xubh-q36u/row-fybn~uix6_hmgd 190302 649030 2019-06-03 2018-12-31 16           16               16
1993 ADVENTIST HEALTH ST HELENA 10 WOODLAND ROAD SAINT HELENA CA 94574 NAPA (707) 963-3611 Acute Care Hospitals Voluntary non-profit - Private FALSE 38.5419600 -122.4753440 0   55 6 6055 34900 San Jose-San Francisco-Oakland, CA Central Napa County https://data.medicare.gov/resource/xubh-q36u/row-v9r8~wyzg.agw4 50013 649700 2019-06-03 2018-12-31 105 12         117 13             130
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
2019 BOYS TOWN NATIONAL RESEARCH HOSPITAL 555 NORTH 30TH ST OMAHA NE 68131 DOUGLAS (531) 355-6510 Childrens Voluntary non-profit - Private FALSE 41.2645120 -95.9565140 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-i7r7~v26j~9e2t 283300 650175 2019-06-03 2018-12-31 61           61               61
2027 MONROE COMMUNITY HOSPITAL 435 EAST HENRIETTA ROAD ROCHESTER NY 14620 MONROE (585) 760-6500 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.1118560 -77.6160780 0   55 36 36055 40380 Rochester-Batavia-Seneca Falls, NY Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-5bf3_hk4u~74wb 330403 651037 2019-06-03 2018-12-31 5           5       566       571
2123 COLLEGE HOSPITAL COSTA MESA 301 VICTORIA STREET COSTA MESA CA 92627 ORANGE (949) 642-2734 Acute Care Hospitals Proprietary FALSE 33.6526050 -117.9119650 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-3tfg-v7t4-p88q 50543 651370 2019-06-03 2018-12-31 122           122               122
2282 MENIFEE GLOBAL MEDICAL CENTER 28400 MCCALL B0ULEVARD SUN CITY CA 92585 RIVERSIDE (951) 679-8888 Acute Care Hospitals Physician FALSE 33.7189772 -117.1681518 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-rqjx-c4v4.2ewv 50684 651179 2019-06-03 2018-12-31 74 10         84               84
2532 MONROE SURGICAL HOSPITAL 2408 BROADMOOR BLVD MONROE LA 71201 OUACHITA (318) 410-0002 Acute Care Hospitals Physician FALSE 32.5367710 -92.1022040 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk 190245 650140 2019-06-03 2018-12-31 10           10               10
2565 CALIFORNIA PACIFIC MEDICAL CTR-DAVIES CAMPUS HOSP 601 DUBOCE AVENUE SAN FRANCISCO CA 94117 SAN FRANCISCO (415) 600-6000 Acute Care Hospitals Voluntary non-profit - Other FALSE 37.7691140 -122.4346960 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-6wq8_65ym~23y8 50008 651170 2019-06-03 2018-12-31 129 8         137   48   38       223
2624 SURGICAL SPECIALTY CENTER AT COORDINATED HEALTH 1503 CEDAR CREST BOULEVARD ALLENTOWN PA 18104 LEHIGH (610) 871-9110 Acute Care Hospitals Physician FALSE 40.6121900 -75.5327500 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-ecs5-8dzv.54i7 390321 650522 2019-06-03 2018-12-31 20           20       12       32
2687 MENLO PARK SURGICAL HOSPITAL 570 WILLOW ROAD MENLO PARK CA 94025 SAN MATEO (650) 324-8500 Acute Care Hospitals Voluntary non-profit - Private FALSE 37.4620430 -122.1595170 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-y26q.aad6_zuz4 50754 650662 2019-06-03 2018-12-31 16           16               16
2845 SUTTER MATERNITY & SURGERY CENTER OF SANTA CRUZ 2900 CHANTICLEER AVENUE SANTA CRUZ CA 95065 SANTA CRUZ (831) 477-2200 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.9878650 -121.9781800 0   87 6 6087 42100 San Jose-San Francisco-Oakland, CA Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-m3f9-8jic~mqpk 50714 650660 2019-06-03 2018-12-31 30           30               30
2950 MINIMALLY INVASIVE SURGERY HOSPITAL 11217 LAKEVIEW AVENUE LENEXA KS 66219 JOHNSON (913) 322-7401 Acute Care Hospitals Proprietary FALSE 38.9243760 -94.7697050 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-jnfx.rz75-i6pf 170199 649588 2019-06-03 2018-12-31 7       2   9               9
3009 UNIVERSITY HOSPITALS - ELYRIA MEDICAL CENTER 630 EAST RIVER STREET ELYRIA OH 44035 LORAIN (440) 329-7500 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.3669350 -82.0977910 0   93 39 39093 17460 Cleveland-Akron-Canton, OH Outlying Lorain County https://data.medicare.gov/resource/xubh-q36u/row-x3rr~9nf4.cgaw 360145 649644 2019-06-03 2018-12-31 159 26 21       206               206
3066 COORDINATED HEALTH ORTHOPEDIC HOSPITAL 2310 HIGHLAND AVENUE BETHLEHEM PA 18017 NORTHAMPTON (610) 691-4300 Acute Care Hospitals Physician FALSE 40.6737620 -75.3654010 0   95 42 42095 10900 New York-Newark, NY-NJ-CT-PA Central Northampton County https://data.medicare.gov/resource/xubh-q36u/row-sc4k-g4c8.mwqt 390314 651057 2019-06-03 2018-12-31 20           20               20
3165 SOUTHEAST MICHIGAN SURGICAL HOSPITAL 21230 DEQUINDRE ROAD WARREN MI 48091 MACOMB (586) 427-1000 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.4513950 -83.0835600 0   99 26 26099 19820 Detroit-Warren-Ann Arbor, MI Central Macomb County https://data.medicare.gov/resource/xubh-q36u/row-n5cw~k8mz~eeh4 230264 650280 2019-06-03 2018-12-31 13           13               13
3191 SUTTER SURGICAL HOSPITAL - NORTH VALLEY 455 PLUMAS BLVD YUBA CITY CA 95991 SUTTER (530) 749-5700 Acute Care Hospitals Physician FALSE 39.1321670 -121.6136030 0   101 6 6101 49700 Sacramento-Roseville, CA Central Sutter County https://data.medicare.gov/resource/xubh-q36u/row-rm5f.jnvd.d3k4 50766 651185 2019-06-03 2018-12-31 14           14               14
3786 PATIENTS CHOICE MEDICAL CENTER 347 MAGNOLIA DRIVE RALEIGH MS 39153 SMITH (601) 782-9997 Acute Care Hospitals Proprietary FALSE 32.0009980 -89.5206670 0   129 28 28129         https://data.medicare.gov/resource/xubh-q36u/row-xqvg.aa4c-5mrs 250163 650165 2019-06-03 2018-12-31 19           19 10             29
21 HORN MEMORIAL HOSPITAL 701 E 2ND ST IDA GROVE IA 51445 IDA (712) 364-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.3393030 -95.4589100 0   93 19 19093         https://data.medicare.gov/resource/xubh-q36u/row-ct62_kkw5_7j35 161354 649735 2019-06-03 2018-12-31 25           25               25
30 SOUTHSIDE COMMUNITY HOSPITAL, INC 800 OAK STREET FARMVILLE VA 23901 PRINCE EDWARD (434) 392-8811 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.3033170 -78.4030580 0   147 51 51147         https://data.medicare.gov/resource/xubh-q36u/row-5efz.zpme_8ei2 490090 650408 2019-06-03 2018-12-31 78 8         86               86
34 FRIO REGIONAL HOSPITAL 200 S IH 35 PEARSALL TX 78061 FRIO (830) 334-3617 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.8970480 -99.1160130 0   163 48 48163         https://data.medicare.gov/resource/xubh-q36u/row-9gys.vgtu~2pyx 451391 650214 2019-06-03 2018-12-31 24           24               24
45 ALTA BATES SUMMIT MEDICAL CENTER 350 HAWTHORNE AVENUE OAKLAND CA 94609 ALAMEDA (510) 655-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8207840 -122.2632800 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-8jij.khwv.ypce 50043 650562 2019-06-03 2018-12-31 260 36         296   58           354
46 EDEN MEDICAL CENTER 20103 LAKE CHABOT ROAD CASTRO VALLEY CA 94546 ALAMEDA (510) 537-1234 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.6982685 -122.0903131 1 ROOFTOP 1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-qpf5_ajfv~drq5 50488 650953 2019-06-03 2018-12-31 106 24         130               130
56 ALTA BATES SUMMIT MEDICAL CENTER - ALTA BATES CAMP 2450 ASHBY AVENUE BERKELEY CA 94705 ALAMEDA (510) 204-4444 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8564880 -122.2573290 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-x8am.fvn9.9rvh 50305 650649 2019-06-03 2018-12-31 252 30       55 337 64             401
93 ST MARY'S REGIONAL MEDICAL CENTER 93 CAMPUS AVENUE - PO BOX 291 LEWISTON ME 4243 ANDROSCOGGIN (207) 777-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1014140 -70.1982160 0   1 23 23001 30340 Portland-Lewiston-South Portland, ME Central Androscoggin County https://data.medicare.gov/resource/xubh-q36u/row-9zvb_vyvi_ykdt 200034 650704 2019-06-03 2018-12-31 126 14         140 31     210       381
198 BOULDER CITY HOSPITAL 901 ADAMS BLVD BOULDER CITY NV 89005 CLARK (702) 293-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9683590 -114.8434860 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-m2cb.9j9h-qmdd 291309 651018 2019-06-03 2018-12-31 25           25 10     47       82
212 BERGEN NEW BRIDGE MEDICAL CENTER 230 EAST RIDGEWOOD AVE PARAMUS NJ 7652 BERGEN (201) 967-4000 Acute Care Hospitals Government - Local TRUE 40.9586020 -74.0621510 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-uajf_w5ak.e5wh 310058 651020 2019-06-03 2018-12-31 118 9         127 319     574       1020
249 TRI-STATE MEMORIAL HOSPITAL 1221 HIGHLAND AVENUE CLARKSTON WA 99403 ASOTIN (509) 758-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4036380 -117.0545070 0   3 53 53003 30300   Central Asotin County https://data.medicare.gov/resource/xubh-q36u/row-i7hs.ad2c-g7gn 501332 649847 2019-06-03 2018-12-31 25           25               25
257 PAGE HOSPITAL 501 NORTH NAVAJO DRIVE PAGE AZ 86040 COCONINO (928) 645-2424 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.9169600 -111.4631860 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 31304 649070 2019-06-03 2018-12-31 25           25               25
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
262 CENTURA HEALTH-LITTLETON ADVENTIST HOSPITAL 7700 S BROADWAY LITTLETON CO 80122 ARAPAHOE (303) 730-8900 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.5765540 -104.9884890 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-xab7~spdz_mmxf 60113 649074 2019-06-03 2018-12-31 121 24         159   17           176
304 MONTEFIORE MEDICAL CENTER 111 EAST 210TH STREET BRONX NY 10467 BRONX (718) 920-4321 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8797770 -73.8799750 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-68wi.jiky_xtpg 330059 650857 2019-06-03 2018-12-31 1300 54 22   16 50 1458 55 16           1529
328 TRIOS 900 SOUTH AUBURN STREET KENNEWICK WA 99336 BENTON (509) 586-6111 Acute Care Hospitals Government - Hospital District or Authority TRUE 46.1988750 -119.1184630 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-hs4k~gp5j~yv74 500053 651430 2019-06-03 2018-12-31 87 14       10 111               111
334 HOSP COMUNITARIO BUEN SAMARITANO CARR.2 KM.1.4 AVE. SEVERIANO CUEVAS #18 AGUADILLA PR 603 AGUADILLA (787) 658-0000 Acute Care Hospitals Voluntary non-profit - Other TRUE 18.4257212 -67.1508997 1 GEOMETRIC_CENTER 5 72 72005 10380   Central Aguadilla Municipio https://data.medicare.gov/resource/xubh-q36u/row-8tsm_vegi.8z9v 400079 649495 2019-06-03 2018-12-31 116 8         124               124
378 UNIVERSITY HOSPITALS CONNEAUT MEDICAL CENTER 158 WEST MAIN ROAD CONNEAUT OH 44030 ASHTABULA (440) 593-1131 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.9369200 -80.5864590 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-j92a_zjx7-y5bm 361308 649653 2019-06-03 2018-12-31 20 5         25               25
379 UHHS MEMORIAL HOSPITAL OF GENEVA 870 WEST MAIN STREET GENEVA OH 44041 ASHTABULA (440) 466-1141 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8002330 -80.9622770 0   7 39 39007 11780 Cleveland-Akron-Canton, OH Central Ashtabula County https://data.medicare.gov/resource/xubh-q36u/row-f7rd~3d3q.5pjc 361307 649652 2019-06-03 2018-12-31 20 5         25               25
387 LANDMARK MEDICAL CENTER 115 CASS AVENUE WOONSOCKET RI 2895 PROVIDENCE (401) 769-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0053200 -71.4962100 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-ywvs_4dtp_6u43 410011 649821 2019-06-03 2018-12-31 107 16         123 18             141
392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
394 CASTLEVIEW HOSPITAL 300 NORTH HOSPITAL DRIVE PRICE UT 84501 CARBON (435) 637-4800 Acute Care Hospitals Proprietary TRUE 39.6054020 -110.8319110 0   7 49 49007 39220   Central Carbon County https://data.medicare.gov/resource/xubh-q36u/row-z6mk.zxuw_qeet 460011 651250 2019-06-03 2018-12-31 33 6         39               39
397 LAKE CHELAN COMMUNITY HOSPITAL 503 EAST HIGHLAND CHELAN WA 98816 CHELAN (509) 682-3300 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8451390 -120.0105110 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-a77p~uq78~jh3e 501334 651089 2019-06-03 2018-12-31 25           25               25
426 LANAI COMMUNITY HOSPITAL 628 7TH STREET LANAI CITY HI 96763 MAUI (808) 565-8450 Critical Access Hospitals Government - State TRUE 20.8267350 -156.9180020 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-keiy_dtd7_smny 121305 648608 2019-06-03 2018-12-31 4           4       10       14
427 KULA HOSPITAL 100 KEOKEA PLACE KULA HI 96790 MAUI (808) 878-1221 Critical Access Hospitals Government - State TRUE 20.7019940 -156.3570990 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-8svz_bunk-n2za 121308 648609 2019-06-03 2018-12-31 9           9       105       123
456 OLEAN GENERAL HOSPITAL 515 MAIN STREET OLEAN NY 14760 CATTARAUGUS (716) 373-2600 Acute Care Hospitals Proprietary TRUE 42.0894480 -78.4269770 0   9 36 36009 36460 Buffalo-Cheektowaga, NY Central Cattaraugus County https://data.medicare.gov/resource/xubh-q36u/row-hkii~eckc~6rgh 330103 650862 2019-06-03 2018-12-31 260           260 14     293       567
524 SOUTHWEST HEALTHCARE SERVICES 802 2ND ST NW BOWMAN ND 58623 BOWMAN (701) 523-5265 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1841910 -103.4067130 0   11 38 38011         https://data.medicare.gov/resource/xubh-q36u/row-wb88_am45~hjt8 351313 651048 2019-06-03 2018-12-31 23           23       40       63
552 BANNER THUNDERBIRD MEDICAL CENTER 5555 WEST THUNDERBIRD ROAD GLENDALE AZ 85306 MARICOPA (602) 865-4470 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.6107310 -112.1786980 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-fmq8_nzm3.7bhy 30089 649065 2019-06-03 2018-12-31 407 40 18       499 56             555
553 BANNER - UNIVERSITY MEDICAL CENTER PHOENIX 1111 EAST MCDOWELL ROAD PHOENIX AZ 85006 MARICOPA (602) 239-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.4657240 -112.0581270 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-f67j.fyep_c3zs 30002 648882 2019-06-03 2018-12-31 455 46 28       622 22 68           712
559 BANNER DESERT MEDICAL CENTER 1400 SOUTH DOBSON ROAD MESA AZ 85202 MARICOPA (480) 412-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.3909100 -111.8746240 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-m5b5-4dvf~smre 30065 649063 2019-06-03 2018-12-31 447 51 31       615               615
571 BANNER GATEWAY MEDICAL CENTER 1900 NORTH HIGLEY ROAD GILBERT AZ 85234 MARICOPA (480) 543-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.3842250 -111.7196340 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-wvqy.pesc-7dbf 30122 649068 2019-06-03 2018-12-31 141 24         165               165
573 WICKENBURG COMMUNITY HOSPITAL 520 ROSE LANE WICKENBURG AZ 85390 MARICOPA (928) 684-5421 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.9780560 -112.7388250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mqi4.ug34.a4ib 31300 649069 2019-06-03 2018-12-31 19           19               19
580 BANNER DEL E. WEBB MEDICAL CENTER 14502 WEST MEEKER BOULEVARD SUN CITY WEST AZ 85375 MARICOPA (623) 524-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6583070 -112.3719390 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-7gp7~thfz~y68d 30093 650940 2019-06-03 2018-12-31 280 34         314 54 26           394
583 BANNER ESTRELLA MEDICAL CENTER 9201 WEST THOMAS ROAD PHOENIX AZ 85037 MARICOPA (623) 327-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.4795580 -112.2579360 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-i5b8~ggf8_jyy9 30115 649067 2019-06-03 2018-12-31 273 24         317               317
588 SUTTER DELTA MEDICAL CENTER 3901 LONE TREE WAY ANTIOCH CA 94509 CONTRA COSTA (925) 779-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9822950 -121.8046810 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-g62s-vt5f~r4p4 50523 650956 2019-06-03 2018-12-31 129 12       4 145               145
591 LONGMONT UNITED HOSPITAL 1950 MOUNTAIN VIEW AVE LONGMONT CO 80501 BOULDER (303) 651-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1813240 -105.1263820 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-46cx.u9fm~wqwb 60003 649707 2019-06-03 2018-12-31 109 16         131               131
592 CENTURA HEALTH-AVISTA ADVENTIST HOSPITAL 100 HEALTH PARK DR LOUISVILLE CO 80027 BOULDER (303) 673-1280 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.9508470 -105.1491540 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-mqpm_6h4w_if8p 60103 649709 2019-06-03 2018-12-31 74 8         108               108
595 GOOD SAMARITAN MEDICAL CENTER 200 EXEMPLA CIRCLE LAFAYETTE CO 80026 BOULDER (303) 689-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9697530 -105.0830650 0   13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-rxs8-5fmc-dv4k 60116 650243 2019-06-03 2018-12-31 147 24         183               183
607 BIENVILLE MEDICAL CENTER 1175 PINE STREET ARCADIA LA 71001 BIENVILLE (318) 263-4700 Critical Access Hospitals Proprietary TRUE 32.5530850 -92.9157770 0   13 22 22013         https://data.medicare.gov/resource/xubh-q36u/row-ui8b~9pic.2t2z 191320 650142 2019-06-03 2018-12-31 21           21               21
620 GREAT FALLS CLINIC HOSPITAL 3010 15TH AVENUE SOUTH GREAT FALLS MT 59405 CASCADE (406) 216-8000 Acute Care Hospitals Proprietary TRUE 47.4877370 -111.2545610 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-zzvw_fvcf~g44t 270086 651217 2019-06-03 2018-12-31 20           20               20
640 EAST OHIO REGIONAL HOSPITAL 90 NORTH FOURTH STREET MARTINS FERRY OH 43935 BELMONT (740) 633-4205 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.0986440 -80.7208890 0   13 39 39013 48540   Central Belmont County https://data.medicare.gov/resource/xubh-q36u/row-h333-qu75_kcna 360080 649318 2019-06-03 2018-12-31 74 10         84       50       134
643 ST CHARLES PRINEVILLE 384 SE COMBS FLAT ROAD PRINEVILLE OR 97754 CROOK (541) 447-6254 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2980930 -120.8269680 0   13 41 41013 39260 Bend-Redmond-Prineville, OR Central Crook County https://data.medicare.gov/resource/xubh-q36u/row-yy7v_qhni~xpgc 381313 651052 2019-06-03 2018-12-31 16           16               16
660 MINNIE HAMILTON HEALTH SYSTEM 186 HOSPITAL DRIVE GRANTSVILLE WV 26147 CALHOUN (304) 354-9244 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9237960 -81.0918910 0   13 54 54013         https://data.medicare.gov/resource/xubh-q36u/row-2x87.vdzq_mgqw 511303 651093 2019-06-03 2018-12-31 25           25       24       49
662 SAGEWEST HEALTH CARE 2100 W SUNSET DR RIVERTON WY 82501 FREMONT (307) 856-4161 Acute Care Hospitals Proprietary TRUE 43.0336670 -108.4186540 0   13 56 56013 40180   Central Fremont County https://data.medicare.gov/resource/xubh-q36u/row-8cgp~ktku_un2q 530008 652129 2019-06-03 2018-12-31 121 12         133 13 8           154
674 SUTTER COAST HOSPITAL 800 E WASHINGTON BLVD CRESCENT CITY CA 95531 DEL NORTE (707) 464-8880 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.7726980 -124.1941440 0   15 6 6015 18860   Central Del Norte County https://data.medicare.gov/resource/xubh-q36u/row-m7v2.npcd-rkyf 50417 650951 2019-06-03 2018-12-31 33 6         39   10           49
679 BAYFRONT HEALTH PORT CHARLOTTE 2500 HARBOR BLVD PORT CHARLOTTE FL 33952 CHARLOTTE (941) 766-4122 Acute Care Hospitals Proprietary TRUE 26.9898400 -82.0966820 0   15 12 12015 39460 North Port-Sarasota, FL Central Charlotte County https://data.medicare.gov/resource/xubh-q36u/row-hxde-mw35~h46w 100077 649183 2019-06-03 2018-12-31 225 22         254               254
682 KANSAS MEDICAL CENTER LLC 1124 WEST 21ST STREET ANDOVER KS 67002 BUTLER (316) 300-4000 Acute Care Hospitals Proprietary TRUE 37.7232400 -97.1464800 0   15 20 20015 48620 Wichita-Arkansas City-Winfield, KS Outlying Butler County https://data.medicare.gov/resource/xubh-q36u/row-nnyh-wp4p~qnyp 170197 649587 2019-06-03 2018-12-31 45 10         55               55
691 SLEEPY EYE MUNICIPAL HOSPITAL 400 FOURTH AVENUE NORTHWEST SLEEPY EYE MN 56085 BROWN (507) 794-3571 Critical Access Hospitals Government - Local TRUE 44.2993190 -94.7273150 0   15 27 27015 35580 Mankato-New Ulm-North Mankato, MN Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-td5y_avnx_gs7p 241327 651011 2019-06-03 2018-12-31 16           16               16
720 COMMUNITY HOSPITAL 2000 CAMPBELL DRIVE TORRINGTON WY 82240 GOSHEN (307) 532-4181 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.0817650 -104.1915090 0   15 56 56015         https://data.medicare.gov/resource/xubh-q36u/row-cdm5.gqxc~vfiz 531307 649980 2019-06-03 2018-12-31 25           25               25
722 SUMMIT HEALTHCARE REGIONAL MEDICAL CENTER 2200 EAST SHOW LOW LAKE ROAD SHOW LOW AZ 85901 NAVAJO (928) 537-6399 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2019670 -110.0183900 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-2xk7_cqaa~gdmz 30062 651168 2019-06-03 2018-12-31 77 12         89               89
761 HOLY ROSARY HEALTHCARE 2600 WILSON ST MILES CITY MT 59301 CUSTER (406) 233-2600 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3973550 -105.8278370 0   17 30 30017         https://data.medicare.gov/resource/xubh-q36u/row-89tn_7hx4-8qhz 271347 649797 2019-06-03 2018-12-31 21 4         25       84       109
766 CAREPOINT HEALTH-HOBOKEN UNIVERSITY MEDICAL CENTER 308 WILLOW AVE HOBOKEN NJ 7030 HUDSON (201) 418-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7412130 -74.0335590 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-64ry-qaxe-vxjm 310040 649624 2019-06-03 2018-12-31 102 15         117 47 11   15       190
767 CAREPOINT HEALTH-CHRIST HOSPITAL 176 PALISADE AVE JERSEY CITY NJ 7306 HUDSON (201) 795-8200 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7348760 -74.0501420 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-zyny.ji2k-c7cs 310016 648953 2019-06-03 2018-12-31 160 18         178               178
770 CAREPOINT HEALTH - BAYONNE MEDICAL CENTER 29 EAST 29TH ST BAYONNE NJ 7002 HUDSON (201) 858-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6675310 -74.1123710 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-mid8_cv5r~b776 310025 651019 2019-06-03 2018-12-31 117 14         131 15     17       163
782 ST CHARLES BEND 2500 NE NEFF ROAD BEND OR 97701 DESCHUTES (541) 382-4321 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0657570 -121.2666610 0   17 41 41017 13460 Bend-Redmond-Prineville, OR Central Deschutes County https://data.medicare.gov/resource/xubh-q36u/row-c338~bvm4~22pp 380047 651050 2019-06-03 2018-12-31 192 30         222 15 13           250
783 ST CHARLES REDMOND 1253 NW CANAL BLVD REDMOND OR 97756 DESCHUTES (541) 548-8131 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.2887030 -121.1685580 0   17 41 41017 13460 Bend-Redmond-Prineville, OR Central Deschutes County https://data.medicare.gov/resource/xubh-q36u/row-hegt-uv48.px87 380040 651049 2019-06-03 2018-12-31 42 6         48               48
806 BANNER - UNIVERSITY MEDICAL CENTER TUCSON CAMPUS 1625 NORTH CAMPBELL AVENUE TUCSON AZ 85724 PIMA (520) 874-4189 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2423620 -110.9440920 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-vwgy.bhrj~yxk9 30064 650939 2019-06-03 2018-12-31 329 90         479               479
808 BANNER-UNIVERSITY MEDICAL CENTER SOUTH CAMPUS 2800 EAST AJO WAY TUCSON AZ 85713 PIMA (520) 874-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1778820 -110.9308910 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-chg3-jijt~hfj8 30111 650941 2019-06-03 2018-12-31 120 12         132 18             150
828 WEST CALCASIEU CAMERON HOSPITAL 701 EAST CYPRESS STREET SULPHUR LA 70663 CALCASIEU (337) 527-7034 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.2310740 -93.3692900 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-swji~irkf_eud2 190013 650585 2019-06-03 2018-12-31 95 12         107               107
834 ST JOSEPH HOSPITAL 360 BROADWAY BANGOR ME 4401 PENOBSCOT (207) 262-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.8145300 -68.7712600 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-ad3u-g4s7-xxty 200001 650700 2019-06-03 2018-12-31 92 7         99               99
837 RIDGEVIEW MEDICAL CENTER 500 SOUTH MAPLE STREET WACONIA MN 55387 CARVER (952) 442-2191 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.8433060 -93.7907720 0   19 27 27019 33460 Minneapolis-St. Paul, MN-WI Central Carver County https://data.medicare.gov/resource/xubh-q36u/row-pv9b_ri9h.z92e 240056 651008 2019-06-03 2018-12-31 87 18 7       112 12             124
866 BEDFORD MEMORIAL HOSPITAL 1613 OAKWOOD STREET BEDFORD VA 24523 BEDFORD (434) 200-6366 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3515630 -79.5164150 0   19 51 51019 31340   Central Bedford County https://data.medicare.gov/resource/xubh-q36u/row-efrt-99vt~8tan 490088 650619 2019-06-03 2018-12-31 28 6         34       111       145
868 MONTGOMERY GENERAL HOSPITAL, INC 401 SIXTH AVENUE MONTGOMERY WV 25136 FAYETTE (304) 442-5151 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.1828780 -81.3247080 0   19 54 54019 13220   Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-3eev_ya4k~dm4q 511318 651094 2019-06-03 2018-12-31 25           25       44       69
881 BANNER CASA GRANDE MEDICAL CENTER 1800 EAST FLORENCE BOULEVARD CASA GRANDE AZ 85122 PINAL (520) 381-6300 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8796080 -111.7092530 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-iqqv.u75b-cmsi 30016 651166 2019-06-03 2018-12-31 119 22         141               141
882 PIGGOTT COMMUNITY HOSPITAL 216 EAST MAIN STREET PIGGOTT AR 72454 CLAY (870) 598-3881 Critical Access Hospitals Government - Local TRUE 36.3820190 -90.1884430 0   21 5 5021         https://data.medicare.gov/resource/xubh-q36u/row-73yu_ywme-uu8m 41330 649163 2019-06-03 2018-12-31 25           25               25
940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
960 H C WATKINS MEMORIAL HOSPITAL INC 605 SOUTH ARCHUSA AVENUE QUITMAN MS 39355 CLARKE (601) 776-6925 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.0312590 -88.7279550 0   23 28 28023 32940   Outlying Clarke County https://data.medicare.gov/resource/xubh-q36u/row-7ipq~zmm9-gyn8 251316 650283 2019-06-03 2018-12-31 25           25               25
989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35

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