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 PRVDR_NUM

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_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
2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
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
3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
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
2503 CHILDREN'S HOSPITAL OF ALABAMA 1600 SEVENTH AVENUE SOUTH BIRMINGHAM AL 35233 JEFFERSON (205) 939-9100 Childrens Voluntary non-profit - Private TRUE 33.5032220 -86.8053810 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-nh6w~rxvd~itst 13300 651162 2019-06-03 2018-12-31 193     6     341               341
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
3942 WASHINGTON REGIONAL MEDICAL CENTER 3215 N NORTH HILLS BOULEVARD FAYETTEVILLE AR 72703 WASHINGTON (479) 463-5113 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1109840 -94.1578620 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-2bs7.twrk_htcb 40004 649161 2019-06-03 2018-12-31 226 40         320           12   332
3939 NORTHWEST HEALTH PHYSICIANS SPECIALTY HOSPITAL 3873 NORTH PARKVIEW DRIVE FAYETTEVILLE AR 72703 WASHINGTON (479) 571-7002 Acute Care Hospitals Proprietary TRUE 36.1213300 -94.1337300 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-dtfa_7iaz.thv8 40152 650236 2019-06-03 2018-12-31 20           20               20
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
2684 MILLS-PENINSULA MEDICAL CENTER 1501 TROUSDALE DRIVE BURLINGAME CA 94010 SAN MATEO (650) 696-5270 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.5943980 -122.3833560 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-mjdg-hhht-nzgz 50007 652413 2019-06-03 2018-12-31 205 24       12 241 60             301
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
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
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
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
2559 CALIFORNIA PACIFIC MEDICAL CENTER- VAN NESS CAMPUS 1101 VAN NESS AVENUE SAN FRANCISCO CA 94109 SAN FRANCISCO (415) 600-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7861520 -122.4215440 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-iwfw.uikw.39fb 50047 651369 2019-06-03 2018-12-31 384 36     8 36 464 16             480
2561 CALIFORNIA PACIFIC MEDICAL CENTER - MISSION BERNAL 3555 CESAR CHAVEZ STREET SAN FRANCISCO CA 94110 SAN FRANCISCO (415) 641-6562 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.7480500 -122.4209870 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-9ens-9k58_jhkp 50055 650944 2019-06-03 2018-12-31 110 10         120               120
3022 SUTTER SOLANO MEDICAL CENTER 300 HOSPITAL DR VALLEJO CA 94589 SOLANO (707) 554-5280 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.1308930 -122.2381050 0   95 6 6095 46700 San Jose-San Francisco-Oakland, CA Central Solano County https://data.medicare.gov/resource/xubh-q36u/row-ybyu-aysd-2pz8 50101 650643 2019-06-03 2018-12-31 94 12         106               106
2336 SUTTER MEDICAL CENTER, SACRAMENTO 2825 CAPITOL AVENUE SACRAMENTO CA 95816 SACRAMENTO (916) 733-8999 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5702580 -121.4696820 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-qwjh~w7s4_ndbp 50108 650644 2019-06-03 2018-12-31 314 80 48     61 523               523
1635 NOVATO COMMUNITY HOSPITAL 180 ROWLAND WAY NOVATO CA 94945 MARIN (415) 209-1300 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.0980770 -122.5596600 0   41 6 6041 41860 San Jose-San Francisco-Oakland, CA Central Marin County https://data.medicare.gov/resource/xubh-q36u/row-cbru_uws8_9g6e 50131 650646 2019-06-03 2018-12-31 39 8         47               47
1515 POMONA VALLEY HOSPITAL MEDICAL CENTER 1798 N GAREY AVE POMONA CA 91767 LOS ANGELES (909) 865-9500 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0776390 -117.7523290 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-qbck.67td_hi65 50231 650800 2019-06-03 2018-12-31 309 40 10       412               412
3079 SUTTER SANTA ROSA REGIONAL HOSPITAL 30 MARK WEST SPRINGS ROAD SANTA ROSA CA 95403 SONOMA (707) 576-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.4963060 -122.7507070 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-cm5t.k3eb~48rb 50291 650648 2019-06-03 2018-12-31 60 12       12 84               84
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
2179 SUTTER ROSEVILLE MEDICAL CENTER ONE MEDICAL PLAZA ROSEVILLE CA 95661 PLACER (916) 781-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7656350 -121.2495341 1 ROOFTOP 61 6 6061 40900 Sacramento-Roseville, CA Central Placer County https://data.medicare.gov/resource/xubh-q36u/row-7pqk_vf4j.mujz 50309 650945 2019-06-03 2018-12-31 225 32       16 273   55           328
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
1493 BEVERLY HOSPITAL 309 W BEVERLY BLVD MONTEBELLO CA 90640 LOS ANGELES (323) 726-1222 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0160320 -118.1005260 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-5h7f-wtvj_bpxn 50350 650947 2019-06-03 2018-12-31 189 25       10 224               224
1469 PACIFICA HOSPITAL OF THE VALLEY 9449 SAN FERNANDO RD SUN VALLEY CA 91352 LOS ANGELES (818) 767-3310 Acute Care Hospitals Proprietary TRUE 34.2411340 -118.3956690 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-dhg6-n9an_6w25 50378 650948 2019-06-03 2018-12-31 126   7       133       98       231
2285 HEMET VALLEY MEDICAL CENTER 1117 EAST DEVONSHIRE HEMET CA 92543 RIVERSIDE (951) 652-2811 Acute Care Hospitals Physician TRUE 33.7512200 -116.9598590 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-nd99_qqgq_fexi 50390 650949 2019-06-03 2018-12-31 286 18         304       113       417
2562 CHINESE HOSPITAL 845 JACKSON ST SAN FRANCISCO CA 94133 SAN FRANCISCO (415) 982-2400 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7956950 -122.4092500 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-5vx5.sxsv.i4wy 50407 650950 2019-06-03 2018-12-31 59 6         65               65
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
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
2177 SUTTER AUBURN FAITH HOSPITAL 11815 EDUCATION STREET AUBURN CA 95603 PLACER (530) 888-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9443170 -121.0994230 0   61 6 6061 40900 Sacramento-Roseville, CA Central Placer County https://data.medicare.gov/resource/xubh-q36u/row-z26g.4uvw-2fvu 50498 650954 2019-06-03 2018-12-31 56 8         64               64
2441 VICTOR VALLEY GLOBAL MEDICAL CENTER 15248 11TH ST VICTORVILLE CA 92392 SAN BERNARDINO (760) 245-8691 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5289700 -117.2925180 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-n839~npwh~jde4 50517 650955 2019-06-03 2018-12-31 89 10       2 101               101
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
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
3457 SUTTER DAVIS HOSPITAL 2000 SUTTER PLACE DAVIS CA 95616 YOLO (530) 756-6440 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5629230 -121.7725220 0   113 6 6113 40900 Sacramento-Roseville, CA Outlying Yolo County https://data.medicare.gov/resource/xubh-q36u/row-5mwt~twe5~z7f4 50537 650805 2019-06-03 2018-12-31 42 6         48               48
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
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
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
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
1130 BAKERSFIELD HEART HOSPITAL 3001 SILLECT AVENUE BAKERSFIELD CA 93308 KERN (661) 316-6000 Acute Care Hospitals Proprietary TRUE 35.3861060 -119.0408470 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-e89i~sm2j_vijv 50724 651182 2019-06-03 2018-12-31 47           47               47
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
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
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
1472 COLLEGE MEDICAL CENTER 2776 PACIFIC AVENUE LONG BEACH CA 90806 LOS ANGELES (562) 595-1911 Acute Care Hospitals Proprietary TRUE 33.8072010 -118.1937210 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-sybg_fugk_i72x 50776 650806 2019-06-03 2018-12-31 213 8         221               221
1313 SUTTER LAKESIDE HOSPITAL 5176 HILL ROAD EAST LAKEPORT CA 95453 LAKE (707) 262-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1051750 -122.9082380 0   33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-eiws_bxxs~n9dn 51329 650960 2019-06-03 2018-12-31 21 4         25               25
3673 NORTH COLORADO MEDICAL CENTER 1801 - 16TH ST GREELEY CO 80631 WELD (970) 810-4121 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4138340 -104.7094290 0   123 8 8123 24540 Denver-Aurora, CO Central Weld County https://data.medicare.gov/resource/xubh-q36u/row-b7wk~gizs_ie2f 60001 649545 2019-06-03 2018-12-31 199 16   10     225               225
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
2390 MCKEE MEDICAL CENTER 2000 BOISE AVE LOVELAND CO 80538 LARIMER (970) 669-4640 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4136790 -105.0535990 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-33js.ddiw.t8wg 60030 649547 2019-06-03 2018-12-31 104 11         115               115
1201 CENTURA HEALTH-PORTER ADVENTIST HOSPITAL 2525 S DOWNING ST DENVER CO 80210 DENVER (303) 778-1955 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6706400 -104.9734820 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-7qah~g3t4-w829 60064 649874 2019-06-03 2018-12-31 140 36         176 44 13           233
1727 VALLEY VIEW HOSPITAL ASSOCIATION 1906 BLAKE AVE GLENWOOD SPRINGS CO 81601 GARFIELD (970) 945-6535 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5328590 -107.3227940 0   45 8 8045 24060 Edwards-Glenwood Springs, CO Central Garfield County https://data.medicare.gov/resource/xubh-q36u/row-5apg-mrvs~tb5q 60075 650965 2019-06-03 2018-12-31 24 5         41               41
2566 STERLING REGIONAL MEDCENTER 615 FAIRHURST ST STERLING CO 80751 LOGAN (970) 522-0122 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6136840 -103.2205240 0   75 8 8075 44540   Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-9a6c-t2v5_2d88 60076 652859 2019-06-03 2018-12-31 21 4         25               25
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
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
1381 PARKER ADVENTIST HOSPITAL 9395 CROWN CREST BLVD PARKER CO 80138 DOUGLAS (303) 269-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5500580 -104.7734330 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-5jf2-ad3k~8xxe 60114 649876 2019-06-03 2018-12-31 137 16         165               165
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
1382 CASTLE ROCK ADVENTIST HOSPITAL 2350 MEADOWS BLVD CASTLE ROCK CO 80109 DOUGLAS (720) 455-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4041120 -104.8861460 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-k43v-w5np~b8ck 60125 649877 2019-06-03 2018-12-31 41 8         53               53
2387 BANNER FORT COLLINS MEDICAL CENTER 4700 LADY MOON DRIVE FORT COLLINS CO 80528 LARIMER (970) 821-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5211170 -105.0108850 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-t2c3_t3mg_dfjd 60126 652186 2019-06-03 2018-12-31 23           23               23
2848 EAST MORGAN COUNTY HOSPITAL 2400 WEST EDISON STREET BRUSH CO 80723 MORGAN (970) 842-6222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.2547380 -103.6491780 0   87 8 8087 22820   Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-33cv-duhz_he5u 61303 649171 2019-06-03 2018-12-31 25           25               25
2522 LINCOLN COMMUNITY HOSPITAL 111 6TH ST HUGO CO 80821 LINCOLN (719) 743-2421 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.1376600 -103.4731590 0   73 8 8073         https://data.medicare.gov/resource/xubh-q36u/row-ur8w~xce7~5xe9 61306 651191 2019-06-03 2018-12-31 15           15       35       50
3703 WRAY COMMUNITY DISTRICT HOSPITAL 1017 WEST 7TH ST WRAY CO 80758 YUMA (970) 332-4811 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0754050 -102.2346600 0   125 8 8125         https://data.medicare.gov/resource/xubh-q36u/row-jpdk~yrgm-qq54 61309 649710 2019-06-03 2018-12-31 16           16               16
2388 ESTES PARK MEDICAL CENTER 555 PROSPECT AVE ESTES PARK CO 80517 LARIMER (970) 577-4470 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.3722590 -105.5140880 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-3yeq~tw3h-6ggv 61312 649878 2019-06-03 2018-12-31 25           25       60   6   91
2242 KIT CARSON COUNTY MEMORIAL HOSPITAL 286 16TH ST BURLINGTON CO 80807 KIT CARSON (719) 346-5311 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3023780 -102.2707110 0   63 8 8063         https://data.medicare.gov/resource/xubh-q36u/row-xqzu-2pvu-xrfj 61313 648525 2019-06-03 2018-12-31 19           19               19
2786 CLEVELAND CLINIC MARTIN NORTH HOSPITAL 200 SE HOSPITAL AVE STUART FL 34995 MARTIN (772) 287-5200 Acute Care Hospitals Voluntary non-profit - Private TRUE 27.1994410 -80.2430340 0   85 12 12085 38940 Miami-Fort Lauderdale-Port St. Lucie, FL Central Martin County https://data.medicare.gov/resource/xubh-q36u/row-bfv6_fpnd-ukab 100044 649407 2019-06-03 2018-12-31 447 57 8   9   521               521
3522 VENICE REGIONAL MEDICAL CENTER - BAYFRONT HEALTH 540 THE RIALTO VENICE FL 34285 SARASOTA (941) 485-7711 Acute Care Hospitals Proprietary TRUE 27.0896830 -82.4444450 0   115 12 12115 35840 North Port-Sarasota, FL Central Sarasota County https://data.medicare.gov/resource/xubh-q36u/row-7d9m~y97s_nqjv 100070 649182 2019-06-03 2018-12-31 197 32         229               229
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
3303 ADVENTHEALTH LAKE WALES 410 S 11TH ST LAKE WALES FL 33853 POLK (863) 676-1433 Acute Care Hospitals Proprietary TRUE 27.8965330 -81.5646660 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-qtf7.zzcz~qpg5 100099 649186 2019-06-03 2018-12-31 85 8         93 38             131
3088 ST CLOUD REGIONAL MEDICAL CENTER 2906 17TH STREET SAINT CLOUD FL 34769 OSCEOLA (407) 498-3432 Acute Care Hospitals Proprietary TRUE 28.2424140 -81.3026580 0   97 12 12097 36740 Orlando-Deltona-Daytona Beach, FL Outlying Osceola County https://data.medicare.gov/resource/xubh-q36u/row-we5j.muyn.k764 100302 649887 2019-06-03 2018-12-31 76 8         84               84
1895 MEMORIAL HEALTH UNIVERSITY MEDICAL CENTER 4700 WATERS AVENUE SAVANNAH GA 31404 CHATHAM (912) 350-3691 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.0317850 -81.0918270 0   51 13 13051 42340 Savannah-Hinesville-Statesboro, GA Central Chatham County https://data.medicare.gov/resource/xubh-q36u/row-amaq_j44a_mqc4 110036 651266 2019-06-03 2018-12-31 381 20       10 525 10             535
2395 COFFEE REGIONAL MEDICAL CENTER, INC 1101 OCILLA ROAD DOUGLAS GA 31533 COFFEE (912) 383-5620 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.5095890 -82.8634600 0   69 13 13069 20060   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-d473_ue4x.74tq 110089 652866 2019-06-03 2018-12-31 76 10         86               86
4471 ST FRANCIS HOSPITAL 2122 MANCHESTER EXPRESSWAY COLUMBUS GA 31995 MUSCOGEE (706) 596-4020 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.5069270 -84.9613780 0   215 13 13215 17980 Columbus-Auburn-Opelika, GA-AL Central Muscogee County https://data.medicare.gov/resource/xubh-q36u/row-ym8p~a9n6~uy7b 110129 651198 2019-06-03 2018-12-31 284 28         312 13             325
4182 JENKINS COUNTY HOSPITAL 931 EAST WINTHROPE AVENUE MILLEN GA 30442 JENKINS (478) 982-4221 Critical Access Hospitals Proprietary TRUE 32.8036780 -81.9340740 0   165 13 13165         https://data.medicare.gov/resource/xubh-q36u/row-wabu-mgcf_ujg3 111311 651201 2019-06-03 2018-12-31 15           15               15
4394 WARM SPRINGS MEDICAL CENTER 5995 SPRING STREET WARM SPRINGS GA 31830 MERIWETHER (706) 655-9351 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.8906520 -84.6829110 0   199 13 13199 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Meriwether County https://data.medicare.gov/resource/xubh-q36u/row-zkjq-ab6q-8vh9 111316 651203 2019-06-03 2018-12-31 25           25       79       104
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
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
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
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
3260 KATHERINE SHAW BETHEA HOSPITAL 403 E 1ST ST DIXON IL 61021 LEE (815) 288-5531 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8442300 -89.4801310 0   103 17 17103 19940 Dixon-Sterling, IL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-6yju~cunb.8jpf 140012 650986 2019-06-03 2018-12-31 60 6         66 14             80
2245 MORRIS HOSPITAL & HEALTHCARE CENTERS 150 W HIGH ST MORRIS IL 60450 GRUNDY (815) 942-2932 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3689070 -88.4260160 0   63 17 17063 16980 Chicago-Naperville, IL-IN-WI Outlying Grundy County https://data.medicare.gov/resource/xubh-q36u/row-ppby~a88z-i4tu 140101 650988 2019-06-03 2018-12-31 81 8         89               89
4283 PEKIN MEMORIAL HOSPITAL 600 SOUTH 13TH STREET PEKIN IL 61554 TAZEWELL (309) 347-1151 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5631420 -89.6331910 0   179 17 17179 37900 Peoria-Canton, IL Central Tazewell County https://data.medicare.gov/resource/xubh-q36u/row-rch2~a4u2_rhpb 140120 650990 2019-06-03 2018-12-31 99 8         107               107
1261 SOUTH SHORE HOSPITAL 8012 SOUTH CRANDON AVENUE CHICAGO IL 60617 COOK (773) 356-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7494960 -87.5686230 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-9q83~u6ff_gcv4 140181 650991 2019-06-03 2018-12-31 114 8         122 15             137
2942 RIVERSIDE MEDICAL CENTER 350 N WALL ST KANKAKEE IL 60901 KANKAKEE (815) 933-1671 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1241480 -87.8826510 0   91 17 17091 28100 Chicago-Naperville, IL-IN-WI Central Kankakee County https://data.medicare.gov/resource/xubh-q36u/row-cxfa_zzps~tbq7 140186 650992 2019-06-03 2018-12-31 260 18 13       291 14 30           335
3589 ANDERSON HOSPITAL 6800 STATE ROUTE 162 MARYVILLE IL 62062 MADISON (618) 288-5711 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7381270 -89.9464220 0   119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-36x2~e4v5.43qg 140289 650994 2019-06-03 2018-12-31 106 24         130   24           154

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