hospital_data

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

363 rows where geocode_flag = 1 sorted by PRVDR_NUM

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

geocode_flag ✖

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
3021 3021 MARSHALL MEDICAL CENTERS SOUTH CAMPUS 2505 U S HIGHWAY 431 NORTH BOAZ AL 35957 MARSHALL (256) 593-8310 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.2216880 -86.1607098 1 ROOFTOP 95 1 1095 10700 Huntsville-Decatur-Albertville, AL Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-qhdt_aeut-3iwd 10005 644081 2019-02-28 2018-09-30 184 20         204               204
1826 1826 DEKALB REGIONAL MEDICAL CENTER 200 MED CENTER DRIVE FORT PAYNE AL 35968 DE KALB (256) 845-3150 Acute Care Hospitals Proprietary TRUE 34.4419753 -85.7550138 1 ROOFTOP 49 1 1049         https://data.medicare.gov/resource/xubh-q36u/row-pt4k~hfcs.k9m2 10012 653737 2019-08-22 2019-03-31 85 12         97 18             115
2878 2878 CRESTWOOD MEDICAL CENTER ONE HOSPITAL DR SE HUNTSVILLE AL 35801 MADISON (256) 882-3100 Acute Care Hospitals Proprietary TRUE 34.6943814 -86.5720291 1 ROOFTOP 89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-tkhv~u3mn_apnu 10131 659468 2019-11-27 2019-06-30 164 16         183               183
940 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
1885 1885 YUKON KUSKOKWIM DELTA REG HOSPITAL PO BOX 287 BETHEL AK 99559 BETHEL (907) 543-6300 Acute Care Hospitals Tribal TRUE 60.7922222 -161.7558334 1 GEOMETRIC_CENTER 50 2 2050         https://data.medicare.gov/resource/xubh-q36u/row-7gdx-n37w_5vx9 20018 651309 2019-07-02 2018-09-30 34           34               34
4529 4529 PROVIDENCE VALDEZ MEDICAL CENTER PO BOX 550 VALDEZ AK 99686 VALDEZ-CORDOVA (907) 835-2249 Critical Access Hospitals Government - Local TRUE 61.1364781 -146.3458866 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-2ygw.872k~d2en 21301 652057 2019-05-30 2018-12-31 11           11       10       21
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27
4530 4530 CORDOVA COMMUNITY MEDICAL CENTER PO BOX 160 - 602 CHASE AVENUE CORDOVA AK 99574 VALDEZ-CORDOVA (907) 424-8000 Critical Access Hospitals Government - Local TRUE 60.5413354 -145.7505310 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-kscp_6dza~rvey 21307 650633 2019-05-30 2018-12-31 13           13       10       23
4294 4294 NORTON SOUND REGIONAL HOSPITAL 1000 GREG KRUSCHEK AVENUE (P O BOX 966) NOME AK 99762 NOME (907) 443-3311 Critical Access Hospitals Tribal TRUE 64.4992304 -165.3784042 1 ROOFTOP 180 2 2180         https://data.medicare.gov/resource/xubh-q36u/row-2xs3~z9eg.fia9 21308 646669 2019-04-15 2018-09-30 18           18       18       36
2424 2424 KANAKANAK HOSPITAL P O BOX 130 DILLINGHAM AK 99576 DILLINGHAM (907) 842-5201 Critical Access Hospitals Voluntary non-profit - Private TRUE 59.0397222 -158.4575000 1 GEOMETRIC_CENTER 70 2 2070         https://data.medicare.gov/resource/xubh-q36u/row-j4d4-bz29~h79d 21309 646376 2019-03-28 2018-09-30 18           18               18
4344 4344 MANIILAQ HEALTH CENTER PO BOX 43 KOTZEBUE AK 99752 NORTHWEST ARTIC BOROUGH (907) 442-3321 Critical Access Hospitals Tribal TRUE 66.8961387 -162.5868698 1 ROOFTOP 188 2 2188         https://data.medicare.gov/resource/xubh-q36u/row-5pbr_yrqg~qkzd 21310 646530 2019-03-29 2018-09-30 17           17               17
38 38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
256 256 TUBA CITY REGIONAL HEALTH CARE CORPORATION PO BOX 600 TUBA CITY AZ 86045 COCONINO (928) 283-2501 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.1279296 -111.2249984 1 ROOFTOP 5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-hne8.hg7p.2gfd 30073 651368 2019-07-01 2018-09-30 73           73               73
800 800 SELLS HOSPITAL HIGHWAY 86, AT TOPAWA ROAD SELLS AZ 85634 PIMA (520) 362-7003 Acute Care Hospitals Tribal TRUE 31.9183549 -111.8792747 1 GEOMETRIC_CENTER 19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-57e8_mqp9-5x9d 30074 651599 2019-07-10 2018-09-30 14           14               14
404 404 SAN CARLOS APACHE HEALTHCARE 103 MEDICINE WAY ROAD PERIDOT AZ 85542 GILA (928) 475-1200 Acute Care Hospitals Government - Federal FALSE 33.2956419 -110.4178011 1 ROOFTOP 9 4 4009 40940   Central Graham County https://data.medicare.gov/resource/xubh-q36u/row-9543-jpqy.dn76 30077 651688 2019-07-01 2018-09-30 8           8               8
40 40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
724 724 HOPI HEALTH CARE CENTER HIGHWAY 264, MILEPOST 388 POLACCA AZ 86042 NAVAJO (928) 737-6000 Critical Access Hospitals Tribal FALSE 35.8022226 -110.4260281 1 GEOMETRIC_CENTER 17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-6zw9_3xdm~7vqp 31305 646377 2019-03-28 2018-09-30 6           6               6
39 39 SAGE MEMORIAL HOSPITAL STATE ROUTE 264 SOUTH 191 GANADO AZ 86505 APACHE (928) 755-4541 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7108602 -109.5423597 1 ROOFTOP 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-vmgp-erfi.puty 31309 652060 2019-05-06 2018-09-30 25           25               25
3579 3579 CHI-ST VINCENT INFIRMARY TWO ST VINCENT CIRCLE LITTLE ROCK AR 72205 PULASKI (501) 552-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7502877 -92.3393435 1 ROOFTOP 119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-rvvz~qyi8_5qyq 40007 660911 2019-12-02 2019-06-30 330 23 20     20 393               393
3244 3244 OUACHITA COUNTY MEDICAL CENTER 638 CALIFORNIA AVENUE CAMDEN AR 71701 OUACHITA (870) 836-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5758644 -92.8362602 1 ROOFTOP 103 5 5103 15780   Central Ouachita County https://data.medicare.gov/resource/xubh-q36u/row-yf7w-c43e.mvn6 40050 644010 2019-03-05 2018-09-30 74 8         82           11   93
3580 3580 BAPTIST HEALTH MEDICAL CENTER-LITTLE ROCK 9601 INTERSTATE LITTLE ROCK AR 72205 PULASKI (501) 202-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7443211 -92.3806640 1 ROOFTOP 119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-bf2h_7zv8-2ay2 40114 651550 2019-05-31 2018-12-31 513 36 18   18   683 24     27       734
1721 1721 BAPTIST HEALTH MEDICAL CENTER-CONWAY 1555 EXCHANGE AVENUE CONWAY AR 72032 FAULKNER (501) 585-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0564394 -92.4192706 1 ROOFTOP 45 5 5045 30780 Little Rock-North Little Rock, AR Outlying Faulkner County https://data.medicare.gov/resource/xubh-q36u/row-begn.7uvq~4sez 40154 650111 2019-05-31 2018-12-31 102 8         110               110
2287 2287 SAN GORGONIO MEMORIAL HOSPITAL 600 NORTH HIGHLAND SPRINGS AVENUE BANNING CA 92220 RIVERSIDE (951) 845-1121 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.9316874 -116.9461472 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-v72w~xz4e~mtkk 50054 660165 2019-12-02 2019-06-30 55 6         61               61
1485 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
1942 1942 COMMUNITY HOSPITAL OF THE MONTEREY PENINSULA 23625 W R HOLMAN HIGHWAY MONTEREY CA 93940 MONTEREY (831) 624-5311 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.5788637 -121.9131591 1 ROOFTOP 53 6 6053 41500   Central Monterey County https://data.medicare.gov/resource/xubh-q36u/row-ctib_v5m9-fnq5 50145 659197 2019-06-18 2018-12-31 199 20         227 18 13   28   4   290
2117 2117 HOAG MEMORIAL HOSPITAL PRESBYTERIAN ONE HOAG DRIVE NEWPORT BEACH CA 92663 ORANGE (949) 764-4624 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6250610 -117.9304162 1 ROOFTOP 59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-bppk_tnhd_ksbx 50224 652293 2019-06-18 2018-12-31 454 31 12     21 518               518
2882 2882 MERCY MEDICAL CENTER REDDING 2175 ROSALINE AVE, CLAIRMONT HGTS REDDING CA 96001 SHASTA (530) 225-6102 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5719533 -122.3952328 1 ROOFTOP 89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-y47u-62yf~3uib 50280 657650 2019-07-01 2018-06-30 202 44       16 262               262
2179 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
46 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
2124 2124 MISSION HOSPITAL REGIONAL MED CENTER 27700 MEDICAL CENTER RD MISSION VIEJO CA 92691 ORANGE (949) 364-1400 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5610153 -117.6653937 1 ROOFTOP 59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-dvr4-2vyx_23n4 50567 662478 2019-11-27 2019-06-30 392 73         465 36 22           523
2282 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
1483 1483 LAC/RANCHO LOS AMIGOS NATIONAL REHABILITATION CTR 7601 EAST IMPERIAL HIGHWAY DOWNEY CA 90242 LOS ANGELES (562) 401-7022 Acute Care Hospitals Government - Local FALSE 33.9293317 -118.1585885 1 ROOFTOP 37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rfj5_pyf7~7bni 50717 662350 2018-12-03 2018-06-30 89 12         101   109           210
1126 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
1314 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
2113 2113 CHILDREN'S HOSPITAL AT MISSION 27700 MEDICAL CENTER RD, 5TH FLOOR MISSION VIEJO CA 92691 ORANGE (949) 365-2408 Childrens Voluntary non-profit - Private TRUE 33.5610153 -117.6653937 1 ROOFTOP 59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-ux4n.c7cr-d5uw 53306 659086 2018-11-30 2018-06-30                              
593 593 LONGS PEAK HOSPITAL 1750 EAST KEN PRATT BOULEVARD LONGMONT CO 80504 BOULDER (720) 718-3005 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1621720 -105.0581160 1 ROOFTOP 13 8 8013 14500 Denver-Aurora, CO Central Boulder County https://data.medicare.gov/resource/xubh-q36u/row-i5b6~xwcd-bndp 60128 661294 2019-12-03 2019-06-30 44 6         50               50
3246 3246 PIONEERS MEDICAL CENTER 100 PIONEERS MEDICAL CENTER DR MEEKER CO 81641 RIO BLANCO (970) 878-5047 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0470026 -107.8822968 1 ROOFTOP 103 8 8103         https://data.medicare.gov/resource/xubh-q36u/row-ygxw-c3bh-9y5d 61325 647603 2019-05-08 2018-12-31 10           10       30       40
63 63 STAMFORD HOSPITAL ONE HOSPITAL PLAZA STAMFORD CT 6904 FAIRFIELD (203) 276-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0544448 -73.5522909 1 ROOFTOP 1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-z4bk-5sz6.bqpu 70006 644101 2019-03-04 2018-09-30 252 36         288   17           305
596 596 JOHNSON MEMORIAL HOSPITAL 201 CHESTNUT HILL ROAD STAFFORD SPRINGS CT 6076 TOLLAND (860) 684-4251 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9795964 -72.3911022 1 ROOFTOP 13 9 9013 25540 Hartford-West Hartford, CT Central Tolland County https://data.medicare.gov/resource/xubh-q36u/row-teik-3pgv_3z6k 70008 645049 2019-02-28 2018-09-30 43 7         50 20             70
408 408 SAINT MARY'S HOSPITAL 56 FRANKLIN STEET WATERBURY CT 6706 NEW HAVEN (203) 709-6020 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.5525708 -73.0364301 1 ROOFTOP 9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-ir6v~snu4~uk6s 70016 644222 2019-02-28 2018-09-30 119 16 8       152 12             164
142 142 BRISTOL HOSPITAL BREWSTER RD BRISTOL CT 6010 HARTFORD (860) 585-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6758208 -72.9314067 1 GEOMETRIC_CENTER 3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-v2rh-5xe4~wrhu 70029 645749 2019-03-25 2018-09-30 92 14         106 15             121
150 150 ST FRANCIS HOSPITAL 7TH AND CLAYTON STS WILMINGTON DE 19805 NEW CASTLE (302) 421-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7498827 -75.5665813 1 ROOFTOP 3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-2uda_n6xn~szp8 80003 660361 2019-12-03 2019-06-30 154 20         180               180
267 267 BAYHEALTH HOSPITAL, SUSSEX CAMPUS 100 WELLNESS WAY MILFORD DE 19963 SUSSEX (302) 422-3311 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8868357 -75.3911438 1 ROOFTOP 5 10 10005 41540   Central Sussex County https://data.medicare.gov/resource/xubh-q36u/row-pqau~nrba-tybq 80009 661150 2019-12-03 2019-06-30 105 9         114   42           156
2939 2939 TWIN CITIES HOSPITAL 2190 HWY 85 N NICEVILLE FL 32578 OKALOOSA (850) 678-4131 Acute Care Hospitals Proprietary TRUE 30.5335439 -86.4955846 1 ROOFTOP 91 12 12091 18880   Central Okaloosa County https://data.medicare.gov/resource/xubh-q36u/row-xgh2-c9rs.xgvm 100054 656061 2019-11-01 2019-05-31 57 8         65               65
2057 2057 ST JOSEPHS HOSPITAL 3001 W MARTIN LUTHER KING JR BLVD TAMPA FL 33677 HILLSBOROUGH (813) 870-4398 Acute Care Hospitals Voluntary non-profit - Church TRUE 27.9822844 -82.4911306 1 ROOFTOP 57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-w8gx-3zfk-n7gh 100075 650969 2019-05-31 2018-12-31 866 106 26     64 1062               1062
2835 2835 CORAL GABLES HOSPITAL 3100 DOUGLAS RD CORAL GABLES FL 33134 MIAMI-DADE (305) 445-8461 Acute Care Hospitals Proprietary TRUE 25.7434206 -80.2547399 1 ROOFTOP 86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-aamf_du99_66z8 100183 649552 2019-05-31 2018-12-31 229 16         245               245
2829 2829 KENDALL REGIONAL MEDICAL CENTER 11750 BIRD RD MIAMI FL 33175 MIAMI-DADE (305) 223-3000 Acute Care Hospitals Proprietary TRUE 25.7319314 -80.3857679 1 ROOFTOP 86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-dsci.kfbc_pykp 100209 649079 2019-05-31 2018-12-31 322 52       13 394 23             417
1831 1831 ADVENTHEALTH WAUCHULA 735 S 5TH AVE WAUCHULA FL 33873 HARDEE (863) 773-0216 Critical Access Hospitals Voluntary non-profit - Private TRUE 27.5394213 -81.8072774 1 ROOFTOP 49 12 12049 48100   Central Hardee County https://data.medicare.gov/resource/xubh-q36u/row-ev8e.32dq-kwq8 101300 649888 2019-05-30 2018-12-31 25           25               25
3628 3628 SHANDS LIVE OAK REGIONAL MEDICAL CENTER 1100 SW 11TH ST LIVE OAK FL 32060 SUWANNEE (904) 362-1413 Critical Access Hospitals Proprietary TRUE 30.2917367 -83.0028124 1 ROOFTOP 121 12 12121         https://data.medicare.gov/resource/xubh-q36u/row-keij_wts9-t8jc 101301 660198 2019-12-02 2019-06-30 25           25               25
680 680 CARTERSVILLE MEDICAL CENTER 960 JOE FRANK HARRIS PARKWAY CARTERSVILLE GA 30120 BARTOW (770) 387-8182 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1995441 -84.7932932 1 ROOFTOP 15 13 13015 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Bartow County https://data.medicare.gov/resource/xubh-q36u/row-w3nk-2vm4_5tut 110030 644712 2019-02-28 2018-09-30 98 21         119               119
4537 4537 JOHN D ARCHBOLD MEMORIAL HOSPITAL 915 GORDON AVENUE & MIMOSA DRIVE THOMASVILLE GA 31792 THOMAS (229) 228-2880 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.8251841 -83.9720565 1 ROOFTOP 275 13 13275 45620   Central Thomas County https://data.medicare.gov/resource/xubh-q36u/row-28di.4fre~auew 110038 651993 2019-06-24 2018-09-30 191 35         226 18 20   64       328
4541 4541 MEADOWS REGIONAL MEDICAL CENTER ONE MEADOWS PARKWAY VIDALIA GA 30474 TOOMBS (912) 535-5828 Acute Care Hospitals Proprietary TRUE 32.2071314 -82.3777520 1 GEOMETRIC_CENTER 279 13 13279 47080   Central Toombs County https://data.medicare.gov/resource/xubh-q36u/row-ifps.um7x~mbjr 110128 659939 2019-12-02 2019-06-30 44 8         52               52
4281 4281 LIBERTY REGIONAL MEDICAL CENTER 462 E G MILES PARKWAY HINESVILLE GA 31310 LIBERTY (912) 369-9438 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8394772 -81.6009755 1 ROOFTOP 179 13 13179 25980 Savannah-Hinesville-Statesboro, GA Central Liberty County https://data.medicare.gov/resource/xubh-q36u/row-3b9g_44yp.xw63 111335 647248 2019-05-01 2018-11-30 25           25       108       133
79 79 NORTH HAWAII COMMUNITY HOSPITAL 67 1125 MAMALAHOA HIGHWAY KAMUELA HI 96743 HAWAII (808) 885-4444 Acute Care Hospitals Voluntary non-profit - Private TRUE 20.0232419 -155.6653736 1 RANGE_INTERPOLATED 1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-ntxy-3z5d.j57p 120028 662518 2019-12-02 2019-06-30 29 4         33               33
3591 3591 ALTON MEMORIAL HOSPITAL ONE MEMORIAL DRIVE ALTON IL 62002 MADISON (618) 463-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8995477 -90.1591567 1 ROOFTOP 119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-45rg.3vzm_7irj 140002 648904 2019-05-30 2018-12-31 120 12         132 20             152
1258 1258 MT SINAI HOSPITAL MEDICAL CENTER 15TH STREET AT CALIFORNIA CHICAGO IL 60608 COOK (773) 542-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8612424 -87.6940679 1 ROOFTOP 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-wcea_tcc2-qg4n 140018 661489 2019-12-02 2019-06-30 182 17 12       236 28             264
3590 3590 OSF SAINT ANTHONY'S HEALTH CENTER ST ANTHONY'S WAY ALTON IL 62002 MADISON (618) 465-2571 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.9073839 -90.1718152 1 GEOMETRIC_CENTER 119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-mu62-iiye-da97 140052 645329 2019-02-28 2018-09-30 68 10         78               78
1255 1255 METROSOUTH MEDICAL CENTER 12935 S GREGORY BLUE ISLAND IL 60406 COOK (708) 597-2000 Acute Care Hospitals Proprietary TRUE 41.6586704 -87.6770674 1 ROOFTOP 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-miqp~tr2i-gj89 140118 653389 2019-08-27 2018-12-31 264 36         300 14             314
1241 1241 FRANCISCAN HEALTH OLYMPIA & CHICAGO HEIGHTS 20201 S CRAWFORD AVENUE OLYMPIA FIELDS IL 60461 COOK (708) 747-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.5232407 -87.7107960 1 ROOFTOP 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-bi35-phvp~9xs3 140172 646257 2019-04-01 2018-12-31 161 31         192   14           206
4152 4152 HSHS ST ELIZABETH'S HOSPITAL ONE ST ELIZABETH BOULEVARD O FALLON IL 62269 ST. CLAIR (618) 234-2120 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.5836880 -89.9322498 1 ROOFTOP 163 17 17163 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-pfxz-kai8~phvk 140187 661498 2019-12-03 2019-06-30 112 16         128   16           144
4184 4184 HARRISBURG MEDICAL CENTER 100 DOCTOR WARREN TUTTLE DR HARRISBURG IL 62946 SALINE (618) 253-7671 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.7310271 -88.5248600 1 ROOFTOP 165 17 17165         https://data.medicare.gov/resource/xubh-q36u/row-8u5r_n3xt~tnqf 140210 660516 2019-11-27 2019-06-30 40           40 30             70
2397 2397 HARDIN COUNTY GENERAL HOSPITAL FERRELL ROAD ROSICLARE IL 62982 HARDIN (618) 285-6634 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.4103431 -88.3558252 1 GEOMETRIC_CENTER 69 17 17069         https://data.medicare.gov/resource/xubh-q36u/row-p9aq.m5aa.6pkb 141328 653315 2019-08-29 2019-03-31 25           25               25
1897 1897 FAYETTE COUNTY HOSPITAL 7TH AND TAYLOR VANDALIA IL 62471 FAYETTE (618) 283-1231 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.9706410 -89.0988780 1 GEOMETRIC_CENTER 51 17 17051         https://data.medicare.gov/resource/xubh-q36u/row-3m36-npvv-f9tn 141346 648907 2019-05-30 2018-12-31 25 4         29       85       114
4091 4091 SPARTA COMMUNITY HOSPITAL 818 E BROADWAY SPARTA IL 62286 RANDOLPH (618) 443-2177 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.1239588 -89.6915364 1 ROOFTOP 157 17 17157         https://data.medicare.gov/resource/xubh-q36u/row-x2d7.jahq~9785 141349 659259 2019-11-06 2019-06-30 25           25               25
1221 1221 LARABIDA CHILDRENS HOSPITAL I E 65TH ST AT LAKE MICHIGAN CHICAGO IL 60649 COOK (773) 363-6700 Childrens Voluntary non-profit - Private FALSE 41.7768110 -87.6015927 1 GEOMETRIC_CENTER 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-cnjg.zfnx-s5dn 143301 659950 2019-11-25 2019-06-30 49           49               49
2943 2943 FRANCISCAN HEALTH MICHIGAN CITY 3500 FRANCISCAN WAY MICHIGAN CITY IN 46360 LA PORTE (219) 879-8511 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.6595891 -86.8986778 1 ROOFTOP 91 18 18091 33140 Chicago-Naperville, IL-IN-WI Central LaPorte County https://data.medicare.gov/resource/xubh-q36u/row-3sxf-2kxc.xexc 150015 660075 2019-11-25 2018-12-31 135 14         149 18 16           183
2605 2605 KING'S DAUGHTERS' HEALTH 1373 EAST SR 62 MADISON IN 47250 JEFFERSON (812) 801-0105 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7926880 -85.3638433 1 ROOFTOP 77 18 18077 31500 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-wgdj~g7f8~hsjz 150069 648817 2019-05-29 2018-12-31 82 6         88           1   89
4286 4286 OTTUMWA REGIONAL HEALTH CENTER 1001 E PENNSYLVANIA OTTUMWA IA 52501 WAPELLO (641) 682-7511 Acute Care Hospitals Proprietary TRUE 41.0288887 -92.3895049 1 ROOFTOP 179 19 19179 36900   Central Wapello County https://data.medicare.gov/resource/xubh-q36u/row-q5qs.dgin-w3wa 160089 654920 2019-10-01 2019-04-30 77 11         88 14 18           120
3593 3593 AVERA MERRILL PIONEER HOSPITAL 1100 S 10TH AVE ROCK RAPIDS IA 51246 LYON (712) 472-2591 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4213815 -96.1757132 1 RANGE_INTERPOLATED 119 19 19119         https://data.medicare.gov/resource/xubh-q36u/row-m3f9-4aqb~x9sv 161321 660960 2019-11-27 2019-06-30 11           11               11
353 353 MERCYONE CENTERVILLE MEDICAL CENTER ONE ST JOSEPH'S DRIVE CENTERVILLE IA 52544 APPANOOSE (641) 437-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7555228 -92.8568047 1 ROOFTOP 7 19 19007         https://data.medicare.gov/resource/xubh-q36u/row-quyx-h8pq.iqb9 161377 660989 2019-12-02 2019-06-30 22 3         25           19   44
28 28 MORTON COUNTY HOSPITAL 445 N HILLTOP ELKHART KS 67950 MORTON (620) 697-2141 Acute Care Hospitals Government - Local TRUE 37.0019009 -101.9053025 1 ROOFTOP 129 20 20129         https://data.medicare.gov/resource/xubh-q36u/row-uv4u~7jpi~swm6 170166 651519 2019-07-09 2018-12-31 26           26               26
3202 3202 LANE COUNTY HOSPITAL 235 WEST VINE PO BOX 969 DIGHTON KS 67839 LANE (620) 397-5321 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.4805486 -100.4690751 1 ROOFTOP 101 20 20101         https://data.medicare.gov/resource/xubh-q36u/row-9e78_nak8_vx8n 171303 647616 2019-05-06 2018-12-31 25           25               25
999 999 ASHLAND HEALTH CENTER 625 SOUTH KENTUCKY ASHLAND KS 67831 CLARK (620) 635-2241 Critical Access Hospitals Voluntary non-profit - Other TRUE 37.1902572 -99.7797746 1 ROOFTOP 25 20 20025         https://data.medicare.gov/resource/xubh-q36u/row-6n24_uu3q.wx9d 171304 655206 2019-10-10 2018-12-31 25           25               25
1322 1322 COMANCHE COUNTY HOSPITAL 2ND & FRISCO STREET COLDWATER KS 67029 COMANCHE (620) 582-2144 Critical Access Hospitals Government - Local TRUE 37.2679460 -99.3321152 1 GEOMETRIC_CENTER 33 20 20033         https://data.medicare.gov/resource/xubh-q36u/row-uexi-7hwn_3fpb 171312 648915 2019-05-29 2018-12-31 12           12               12
2572 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
2698 2698 SATANTA DISTRICT HOSPITAL CHEYENNE & APACHE SATANTA KS 67870 HASKELL (620) 649-2761 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4374237 -100.9856235 1 GEOMETRIC_CENTER 81 20 20081         https://data.medicare.gov/resource/xubh-q36u/row-5zm3-qnsy-hby4 171324 648917 2019-05-28 2018-12-31 13           13           44   57
3807 3807 SABETHA COMMUNITY HOSPITAL 14TH & OREGON SABETHA KS 66534 NEMAHA (785) 284-2121 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.8997686 -95.8071090 1 GEOMETRIC_CENTER 131 20 20131         https://data.medicare.gov/resource/xubh-q36u/row-tatv-27qf.j7tk 171338 650576 2019-06-04 2018-12-31 17           17               17
4449 4449 WILSON MEDICAL CENTER REECE CAMPUS 2600 OTTAWA ROAD NEODESHA KS 66757 WILSON (620) 325-2611 Critical Access Hospitals Government - Local TRUE 37.4085290 -95.7082419 1 ROOFTOP 205 20 20205         https://data.medicare.gov/resource/xubh-q36u/row-fh4a~9srx~xwnp 171344 649229 2019-05-30 2018-12-31 15           15               15
275 275 ATCHISON HOSPITAL 800 RAVIN HILL DRIVE ATCHISON KS 66002 ATCHISON (913) 360-5581 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5366253 -95.1282386 1 ROOFTOP 5 20 20005 11860 Kansas City-Overland Park-Kansas City, MO-KS Central Atchison County https://data.medicare.gov/resource/xubh-q36u/row-fwt4-3qfd~33ue 171382 645412 2019-03-01 2018-09-30 21 4         25               25
2353 2353 SAINT JOSEPH HOSPITAL ONE SAINT JOSEPH DRIVE LEXINGTON KY 40504 FAYETTE (859) 313-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.0332481 -84.5236220 1 ROOFTOP 67 21 21067 30460 Lexington-Fayette--Richmond--Frankfort, KY Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-erie~rwhk.b5ea 180010 660554 2019-11-27 2019-06-30 205 38 12       255               255
4504 4504 BAPTIST HEALTH CORBIN ONE TRILLIUM WAY CORBIN KY 40701 WHITLEY (606) 528-1212 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.9230129 -84.1202609 1 ROOFTOP 235 21 21235 30940   Central Whitley County https://data.medicare.gov/resource/xubh-q36u/row-7vtx-iqza-7wsw 180080 656279 2019-09-26 2018-08-31 238   10       248   20           268
2356 2356 MOREHOUSE GENERAL HOSPITAL 323 W WALNUT BASTROP LA 71220 MOREHOUSE (318) 283-3600 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7748904 -91.9171756 1 ROOFTOP 67 22 22067 12820 Monroe-Ruston-Bastrop, LA Central Morehouse Parish https://data.medicare.gov/resource/xubh-q36u/row-aa6z.6x6h.fdkd 190116 655276 2019-10-16 2019-05-31 33 6         39 10             49
3595 3595 MINDEN MEDICAL CENTER NO 1 MEDICAL PLAZA MINDEN LA 71055 WEBSTER (318) 377-2321 Acute Care Hospitals Proprietary TRUE 32.6172391 -93.2863556 1 ROOFTOP 119 22 22119 43340   Outlying Webster Parish https://data.medicare.gov/resource/xubh-q36u/row-zn8k~yqhx.sjt5 190144 657128 2019-01-03 2018-07-31 113 10         125 20 12           157
2140 2140 LASALLE GENERAL HOSPITAL 187 NINTH ST/HWY 84 WEST JENA LA 71342 LASALLE (318) 992-9200 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6831927 -92.1337360 1 GEOMETRIC_CENTER 59 22 22059         https://data.medicare.gov/resource/xubh-q36u/row-dbin~f8yn~yhkn 190145 644279 2019-03-01 2018-09-30 30           30 16             46
1139 1139 RIVERLAND MEDICAL CENTER 1700 WALLACE BLVD FERRIDAY LA 71334 CONCORDIA (318) 757-6551 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.6469583 -91.5548418 1 ROOFTOP 29 22 22029 35020   Central Concordia Parish https://data.medicare.gov/resource/xubh-q36u/row-v73w.iknw.vmzz 191318 644280 2019-03-01 2018-09-30 20 5         25               25
178 178 NORTHERN LIGHT A R GOULD HOSPITAL PO BOX 151 PRESQUE ISLE ME 4769 AROOSTOOK (207) 768-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.6751494 -67.9985861 1 ROOFTOP 3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-ihck.jhth~929r 200018 650152 2019-05-29 2018-09-30 43 6         49   5   14 50     118
831 831 EASTERN MAINE MEDICAL CENTER PO BOX 404 BANGOR ME 4401 PENOBSCOT (207) 973-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.8080922 -68.7517371 1 ROOFTOP 19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-2mv7_y4vm-bcwh 200033 650703 2019-05-30 2018-09-30 246 44         313   36           349
900 900 CHARLES A DEAN MEMORIAL HOSPITAL PO BOX 1129 GREENVILLE ME 4441 PISCATAQUIS (207) 695-5200 Critical Access Hospitals Voluntary non-profit - Private FALSE 45.4594923 -69.5906060 1 GEOMETRIC_CENTER 21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-e23p-cjiz~ui3t 201301 650155 2019-06-21 2018-09-30 25           25               25
443 443 LAWRENCE GENERAL HOSPITAL ONE GENERAL STREET LAWRENCE MA 1842 ESSEX (978) 683-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7098520 -71.1502191 1 ROOFTOP 9 25 25009 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-gyeg_j37z.qymx 220010 645336 2019-03-07 2018-09-30 170 19         189               189
358 358 MARTHA'S VINEYARD HOSPITAL INC ONE HOSPITAL ROAD, FIRST FL, WING 5, PO BOX 1477 OAK BLUFFS MA 2557 DUKES (508) 693-0410 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4570063 -70.5517789 1 APPROXIMATE 7 25 25007 47240   Central Dukes County https://data.medicare.gov/resource/xubh-q36u/row-ym84.mbv4~ifss 221300 644287 2019-02-28 2018-09-30 25           25               25
3315 3315 SPECTRUM HEALTH LUDINGTON HOSPITAL ONE N ATKINSON DRIVE LUDINGTON MI 49431 MASON (231) 843-2591 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.9582193 -86.4302207 1 ROOFTOP 105 26 26105 31220   Central Mason County https://data.medicare.gov/resource/xubh-q36u/row-4jbc-wihk_b6pr 230110 660590 2019-11-25 2019-06-30 39 6         45               45
1840 1840 HURLEY MEDICAL CENTER ONE HURLEY PLAZA FLINT MI 48503 GENESEE (810) 257-9000 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.0212629 -83.7046814 1 GEOMETRIC_CENTER 49 26 26049 22420 Detroit-Warren-Ann Arbor, MI Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-kud9-8wsb.pvu8 230132 661010 2019-11-27 2019-06-30 256 46 13 11   44 370 35 13           418
1839 1839 ASCENSION GENESYS HOSPITAL ONE GENESYS PARKWAY GRAND BLANC MI 48439 GENESEE (810) 606-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.8903226 -83.6367994 1 ROOFTOP 49 26 26049 22420 Detroit-Warren-Ann Arbor, MI Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-puhx-szv4~kvmj 230197 661015 2019-11-27 2019-06-30 305 45         350   20           370
3719 3719 BEAUMONT HOSPITAL, TROY 44201 DEQUINDRE ROAD TROY MI 48085 OAKLAND (248) 964-8800 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6182284 -83.0926592 1 ROOFTOP 125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-zq26-fgkp_w6se 230269 654849 2019-09-24 2018-12-31 439 56         495   25           520
4159 4159 DETROIT RECEIVING HOSPITAL & UNIV HEALTH CENTER 4201 ST ANTOINE ST - 2C DETROIT MI 48201 WAYNE (313) 745-3104 Acute Care Hospitals Proprietary TRUE 42.3535426 -83.0550940 1 ROOFTOP 163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-niud-7c22~chx9 230273 649265 2019-05-30 2018-12-31 134 28 12 9 12   195 19             214
3716 3716 HURON VALLEY-SINAI HOSPITAL ONE WILLIAM CARLS DRIVE COMMERCE TOWNSHIP MI 48382 OAKLAND (248) 937-3370 Acute Care Hospitals Proprietary TRUE 42.5925502 -83.4988560 1 ROOFTOP 125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-wtwz.wnac-edau 230277 646341 2019-03-21 2018-10-31 118 12         130               130
1142 1142 MUNSON HEALTHCARE CHARLEVOIX HOSPITAL 14700 LAKESHORE DRIVE CHARLEVOIX MI 49720 CHARLEVOIX (231) 547-4024 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.3144980 -85.2748510 1 ROOFTOP 29 26 26029         https://data.medicare.gov/resource/xubh-q36u/row-cdsd.f9cx_c7j8 231322 660601 2019-11-27 2019-06-30 25           25               25
3830 3830 SPECTRUM HEALTH REED CITY HOSPITAL 300 N PATTERSON, PO BOX 75 REED CITY MI 49677 OSCEOLA (231) 832-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8782450 -85.5211907 1 ROOFTOP 133 26 26133         https://data.medicare.gov/resource/xubh-q36u/row-hhgy~8j82.d9qv 231323 660106 2019-11-25 2019-06-30 21 4         25       50       75
362 362 RED LAKE HOSPITAL A PO BOX 497 REDLAKE MN 56671 BELTRAMI (218) 679-3912 Acute Care Hospitals Government - Federal FALSE 47.8763460 -95.0169401 1 GEOMETRIC_CENTER 7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-jefe.tmy8.7dit 240206 649909 2019-06-18 2018-09-30 23           23               23
2860 2860 MAHNOMEN HEALTH CENTER 414 W JEFFERSON PO BOX 396 MAHNOMEN MN 56557 MAHNOMEN (218) 935-2511 Critical Access Hospitals Government - Local TRUE 47.3117925 -95.9729278 1 ROOFTOP 87 27 27087         https://data.medicare.gov/resource/xubh-q36u/row-hmyn_2dwh_mr9t 241300 651009 2019-06-04 2018-12-31 10           10       32       42

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