hospital_data
Data source: Big Local News · About: big-local-datasette
4,766 rows sorted by icu_beds descending
This data as json, copyable, CSV (advanced)
Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, burn_beds, subprovider_oth_beds, filed_date (date), fy_end_date (date)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2308 | 2308 | EDWARD W SPARROW HOSPITAL | 1215 E MICHIGAN AVENUE | LANSING | MI | 48912 | INGHAM | (517) 364-1000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 42.7336090 | -84.5348160 | 0 | 65 | 26 | 26065 | 29620 | Lansing-East Lansing-Owosso, MI | Central | Ingham County | https://data.medicare.gov/resource/xubh-q36u/row-9z74.56x8-gaaq | 230230 | 650161 | 2019-06-03 | 2018-12-31 | 297 | 99 | 104 | 33 | 533 | 59 | 40 | 632 | ||||||||
| 1015 | 1015 | TUFTS MEDICAL CENTER | 800 WASHINGTON STREET | BOSTON | MA | 2111 | SUFFOLK | (617) 636-5000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.3494860 | -71.0636930 | 0 | 25 | 25 | 25025 | 14460 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Suffolk County | https://data.medicare.gov/resource/xubh-q36u/row-bms5~bwa2_vxct | 220116 | 644127 | 2019-02-28 | 2018-09-30 | 266 | 98 | 364 | 20 | 384 | |||||||||||
| 1866 | 1866 | OHIO STATE UNIVERSITY HOSPITALS | 410 WEST 10TH AVENUE | COLUMBUS | OH | 43210 | FRANKLIN | (614) 293-9700 | Acute Care Hospitals | Government - State | TRUE | 39.9948840 | -83.0176860 | 0 | 49 | 39 | 39049 | 18140 | Columbus-Marion-Zanesville, OH | Central | Franklin County | https://data.medicare.gov/resource/xubh-q36u/row-fagn.mmer_2f8n | 360085 | 660671 | 2019-11-25 | 2019-06-30 | 885 | 97 | 982 | 91 | 60 | 1133 | ||||||||||
| 1504 | 1504 | KAISER FOUNDATION HOSPITAL - LOS ANGELES | 4867 SUNSET BLVD | LOS ANGELES | CA | 90027 | LOS ANGELES | (323) 783-4011 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 34.0981410 | -118.2948250 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-jegr-tvwi-erqu | 50138 | 649027 | 2019-06-06 | 2018-12-31 | 299 | 96 | 32 | 460 | 68 | 528 | ||||||||||
| 1625 | 1625 | CHARLESTON AREA MEDICAL CENTER | 501 MORRIS STREET | CHARLESTON | WV | 25301 | KANAWHA | (304) 388-5432 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 38.3471200 | -81.6261830 | 0 | 39 | 54 | 54039 | 16620 | Charleston-Huntington-Ashland, WV-OH-KY | Central | Kanawha County | https://data.medicare.gov/resource/xubh-q36u/row-rbtm_p3yy~dsn7 | 510022 | 656020 | 2019-10-31 | 2018-12-31 | 661 | 95 | 40 | 26 | 822 | 18 | 24 | 864 | ||||||||
| 2701 | 2701 | SPECTRUM HEALTH - BUTTERWORTH CAMPUS | 100 MICHIGAN ST NE | GRAND RAPIDS | MI | 49503 | KENT | (616) 391-1774 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.9705270 | -85.6653190 | 0 | 81 | 26 | 26081 | 24340 | Grand Rapids-Wyoming-Muskegon, MI | Central | Kent County | https://data.medicare.gov/resource/xubh-q36u/row-wvf2~fzgf.ud23 | 230038 | 660580 | 2019-11-26 | 2019-06-30 | 897 | 94 | 8 | 1095 | 42 | 250 | 1387 | |||||||||
| 4248 | 4248 | WESLEY MEDICAL CENTER | 550 N HILLSIDE STREET | WICHITA | KS | 67214 | SEDGWICK | (316) 962-2000 | Acute Care Hospitals | Proprietary | TRUE | 37.6954890 | -97.2990580 | 0 | 173 | 20 | 20173 | 48620 | Wichita-Arkansas City-Winfield, KS | Central | Sedgwick County | https://data.medicare.gov/resource/xubh-q36u/row-fncw-tisj.5akn | 170123 | 649109 | 2019-05-30 | 2018-12-31 | 435 | 93 | 26 | 593 | 593 | |||||||||||
| 487 | 487 | MEMORIAL REGIONAL HOSPITAL | 3501 JOHNSON ST | HOLLYWOOD | FL | 33021 | BROWARD | (954) 265-5814 | Acute Care Hospitals | Government - Hospital District or Authority | FALSE | 26.0182620 | -80.1788650 | 0 | 11 | 12 | 12011 | 33100 | Miami-Fort Lauderdale-Port St. Lucie, FL | Central | Broward County | https://data.medicare.gov/resource/xubh-q36u/row-4ubz~aqu5.47ug | 100038 | 654989 | 2019-10-01 | 2019-04-30 | 694 | 92 | 84 | 870 | 54 | 89 | 1013 | |||||||||
| 1361 | 1361 | SEATTLE CHILDREN'S HOSPITAL | 4800 SAND POINT WAY NE, PO BOX C-5371 | SEATTLE | WA | 98105 | KING | (206) 987-2000 | Childrens | Voluntary non-profit - Private | TRUE | 47.6645040 | -122.2831690 | 0 | 33 | 53 | 53033 | 42660 | Seattle-Tacoma, WA | Central | King County | https://data.medicare.gov/resource/xubh-q36u/row-7um6_3ase-art7 | 503300 | 646369 | 2019-04-05 | 2018-09-30 | 270 | 91 | 361 | 361 | ||||||||||||
| 806 | 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 | ||||||||||||
| 82 | 82 | KONA COMMUNITY HOSPITAL | 79-1019 HAUKAPILA STREET | KEALAKEKUA | HI | 96750 | HAWAII | (808) 322-9311 | Acute Care Hospitals | Government - State | TRUE | 19.5192370 | -155.9177190 | 0 | 1 | 15 | 15001 | 25900 | Central | Hawaii County | https://data.medicare.gov/resource/xubh-q36u/row-j5zq.9y53_j6as | 120019 | 662187 | 2019-12-02 | 2019-06-30 | 74 | 9 | 83 | 11 | 94 | ||||||||||||
| 212 | 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 | ||||||||||
| 215 | 215 | HACKENSACK MERIDIAN HEALTH PASCACK VALLEY MEDICAL | 250 OLD HOOK ROAD | WESTWOOD | NJ | 7675 | BERGEN | (201) 383-1035 | Acute Care Hospitals | Proprietary | TRUE | 40.9836580 | -74.0141950 | 0 | 3 | 34 | 34003 | 35620 | New York-Newark, NY-NJ-CT-PA | Central | Bergen County | https://data.medicare.gov/resource/xubh-q36u/row-kwcd-72qg_ygd9 | 310130 | 660416 | 2019-11-25 | 2019-06-30 | 64 | 9 | 78 | 78 | ||||||||||||
| 266 | 266 | NANTICOKE MEMORIAL HOSPITAL | 801 MIDDLEFORD RD | SEAFORD | DE | 19973 | SUSSEX | (302) 629-6611 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 38.6423320 | -75.6053250 | 0 | 5 | 10 | 10005 | 41540 | Central | Sussex County | https://data.medicare.gov/resource/xubh-q36u/row-daqn-dq9w~qe8k | 80006 | 659920 | 2019-12-02 | 2019-06-30 | 85 | 9 | 94 | 94 | |||||||||||||
| 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 | |||||||||||
| 359 | 359 | MIDMICHIGAN MEDICAL CENTER - ALPENA | 1501 W CHISHOLM ST | ALPENA | MI | 49707 | ALPENA | (989) 356-7390 | Acute Care Hospitals | Proprietary | TRUE | 45.0768570 | -83.4506720 | 0 | 7 | 26 | 26007 | 10980 | Central | Alpena County | https://data.medicare.gov/resource/xubh-q36u/row-3cst~3hfe~ssf7 | 230036 | 660579 | 2019-11-25 | 2019-06-30 | 119 | 9 | 128 | 11 | 139 | ||||||||||||
| 380 | 380 | ASHTABULA COUNTY MEDICAL CENTER | 2420 LAKE AVENUE | ASHTABULA | OH | 44004 | ASHTABULA | (440) 997-2262 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.8801480 | -80.7956740 | 0 | 7 | 39 | 39007 | 11780 | Cleveland-Akron-Canton, OH | Central | Ashtabula County | https://data.medicare.gov/resource/xubh-q36u/row-8yrr-xpbs~arq8 | 360125 | 648739 | 2019-05-29 | 2018-12-31 | 95 | 9 | 104 | 17 | 16 | 137 | ||||||||||
| 462 | 462 | WESTERLY HOSPITAL | 25 WELLS STREET | WESTERLY | RI | 2891 | WASHINGTON | (401) 596-6000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.3627980 | -71.8258140 | 0 | 9 | 44 | 44009 | 39300 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Washington County | https://data.medicare.gov/resource/xubh-q36u/row-y3gi~mp2b-duy7 | 410013 | 644344 | 2019-03-06 | 2018-09-30 | 66 | 9 | 75 | 75 | ||||||||||||
| 597 | 597 | ROCKVILLE GENERAL HOSPITAL | 31 UNION ST | ROCKVILLE | CT | 6066 | TOLLAND | (860) 872-5160 | Acute Care Hospitals | Proprietary | TRUE | 41.8669620 | -72.4509880 | 0 | 13 | 9 | 9013 | 25540 | Hartford-West Hartford, CT | Central | Tolland County | https://data.medicare.gov/resource/xubh-q36u/row-fjuu~c5fd_6w23 | 70012 | 650672 | 2019-05-30 | 2018-12-31 | 93 | 9 | 102 | 130 | 232 | |||||||||||
| 919 | 919 | COLUMBIA MEMORIAL HOSPITAL | 71 PROSPECT AVENUE | HUDSON | NY | 12534 | COLUMBIA | (518) 828-7601 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.2462540 | -73.7761280 | 0 | 21 | 36 | 36021 | 26460 | Albany-Schenectady, NY | Central | Columbia County | https://data.medicare.gov/resource/xubh-q36u/row-74q4-dwkw.23jn | 330094 | 650741 | 2019-05-31 | 2018-12-31 | 86 | 9 | 95 | 22 | 117 | |||||||||||
| 947 | 947 | SHANDS LAKE SHORE REGIONAL MEDICAL CENTER | 368 NE FRANKLIN ST | LAKE CITY | FL | 32055 | COLUMBIA | (386) 292-8000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 30.1934860 | -82.6327040 | 0 | 23 | 12 | 12023 | 29380 | Gainesville-Lake City, FL | Central | Columbia County | https://data.medicare.gov/resource/xubh-q36u/row-vfpa_f8gy-va3h | 100102 | 660791 | 2019-11-26 | 2019-06-30 | 78 | 9 | 87 | 87 | ||||||||||||
| 1098 | 1098 | GRADY MEMORIAL HOSPITAL | 2220 IOWA STREET | CHICKASHA | OK | 73018 | GRADY | (405) 224-2300 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 35.2245090 | -97.4739230 | 0 | 27 | 40 | 40027 | 36420 | Oklahoma City-Shawnee, OK | Central | Cleveland County | https://data.medicare.gov/resource/xubh-q36u/row-iy73_c264_932j | 370054 | 648755 | 2019-05-23 | 2018-12-31 | 40 | 9 | 49 | 49 | ||||||||||||
| 1232 | 1232 | METHODIST HOSPITAL OF CHICAGO | 5025 N PAULINA STREET | CHICAGO | IL | 60640 | COOK | (773) 271-9040 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.9732620 | -87.6711410 | 0 | 31 | 17 | 17031 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Cook County | https://data.medicare.gov/resource/xubh-q36u/row-iv7k_hinv.nxvu | 140197 | 645542 | 2019-03-04 | 2018-09-30 | 136 | 9 | 145 | 145 | ||||||||||||
| 1268 | 1268 | SOUTHERN MAINE HEALTH CARE | 1 MEDICAL CENTER DRIVE | BIDDEFORD | ME | 4005 | YORK | (207) 283-7000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 43.4784360 | -70.4921740 | 0 | 31 | 23 | 23031 | 38860 | Portland-Lewiston-South Portland, ME | Central | York County | https://data.medicare.gov/resource/xubh-q36u/row-am4g_dvue_z9bw | 200019 | 649741 | 2019-05-30 | 2018-12-31 | 131 | 9 | 140 | 12 | 74 | 38 | 264 | |||||||||
| 1649 | 1649 | ST FRANCIS HOSPITAL | 3401 LUDINGTON ST | ESCANABA | MI | 49829 | DELTA | (906) 786-3311 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 45.7457600 | -87.0948530 | 0 | 41 | 26 | 26041 | 21540 | Central | Delta County | https://data.medicare.gov/resource/xubh-q36u/row-iqyh_xi8k_igyu | 231337 | 645115 | 2019-02-28 | 2018-09-30 | 16 | 9 | 25 | 25 | |||||||||||||
| 1937 | 1937 | REYNOLDS MEMORIAL HOSPITAL | 800 WHEELING AVE | GLEN DALE | WV | 26038 | MARSHALL | (304) 843-3230 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 39.9461690 | -80.7542700 | 0 | 51 | 54 | 54051 | 48540 | Central | Marshall County | https://data.medicare.gov/resource/xubh-q36u/row-7unr_6kec-aba4 | 510013 | 650222 | 2019-05-28 | 2018-12-31 | 50 | 9 | 59 | 20 | 79 | ||||||||||||
| 2115 | 2115 | SOUTH COAST GLOBAL MEDICAL CENTER | 2701 S BRISTOL ST | SANTA ANA | CA | 92704 | ORANGE | (714) 754-5454 | Acute Care Hospitals | Proprietary | TRUE | 33.7106920 | -117.8854100 | 0 | 59 | 6 | 6059 | 31080 | Los Angeles-Long Beach, CA | Central | Orange County | https://data.medicare.gov/resource/xubh-q36u/row-h474-fx88_e6is | 50747 | 658163 | 2019-02-01 | 2018-08-31 | 100 | 9 | 109 | 23 | 46 | 178 | ||||||||||
| 2210 | 2210 | VIDANT DUPLIN HOSPITAL | 401 N MAIN ST | KENANSVILLE | NC | 28349 | DUPLIN | (910) 296-0941 | Acute Care Hospitals | Government - Local | TRUE | 34.9647690 | -77.9604790 | 0 | 61 | 37 | 37061 | https://data.medicare.gov/resource/xubh-q36u/row-3z8q-ur44-gq7x | 340120 | 643929 | 2019-02-28 | 2018-09-30 | 40 | 9 | 49 | 25 | 74 | |||||||||||||||
| 2396 | 2396 | ST JOSEPH REGIONAL MEDICAL CENTER | 415 SIXTH STREET | LEWISTON | ID | 83501 | NEZ PERCE | (208) 799-5300 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 46.4171210 | -117.0249970 | 0 | 69 | 16 | 16069 | 30300 | Central | Nez Perce County | https://data.medicare.gov/resource/xubh-q36u/row-dyet_gevw~szfb | 130003 | 662190 | 2019-12-02 | 2019-06-30 | 101 | 9 | 110 | 20 | 130 | ||||||||||||
| 2753 | 2753 | GREENWOOD LEFLORE HOSPITAL | 1401 RIVER RD | GREENWOOD | MS | 38935 | LEFLORE | (662) 459-7561 | Acute Care Hospitals | Government - Local | TRUE | 33.5182540 | -90.2001890 | 0 | 83 | 28 | 28083 | 24900 | Central | Leflore County | https://data.medicare.gov/resource/xubh-q36u/row-h4t8-zied.hz4k | 250099 | 644302 | 2019-02-28 | 2018-09-30 | 164 | 9 | 173 | 20 | 193 | ||||||||||||
| 2851 | 2851 | LOWER KEYS MEDICAL CENTER | 5900 COLLEGE ROAD | KEY WEST | FL | 33040 | MONROE | (305) 294-5531 | Acute Care Hospitals | Proprietary | TRUE | 24.5815730 | -81.7436880 | 0 | 87 | 12 | 12087 | 28580 | Central | Monroe County | https://data.medicare.gov/resource/xubh-q36u/row-ygrq~jm9y.gjez | 100150 | 644708 | 2019-02-28 | 2018-09-30 | 90 | 9 | 99 | 21 | 120 | ||||||||||||
| 2897 | 2897 | FRANCISCAN HEALTH MUNSTER | 701 SUPERIOR AVE | MUNSTER | IN | 46321 | LAKE | (219) 922-4200 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.5372580 | -87.5123280 | 0 | 89 | 18 | 18089 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Lake County | https://data.medicare.gov/resource/xubh-q36u/row-4w5v-bey2.ne8p | 150165 | 649898 | 2019-06-03 | 2018-12-31 | 54 | 9 | 63 | 63 | ||||||||||||
| 2958 | 2958 | PROMEDICA BIXBY HOSPITAL | 818 RIVERSIDE AVENUE | ADRIAN | MI | 49221 | LENAWEE | (517) 265-0900 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.9127130 | -84.0495550 | 0 | 91 | 26 | 26091 | 10300 | Detroit-Warren-Ann Arbor, MI | Central | Lenawee County | https://data.medicare.gov/resource/xubh-q36u/row-j6wy-ry6d_k6pn | 230005 | 659288 | 2019-05-29 | 2018-12-31 | 79 | 9 | 88 | 88 | ||||||||||||
| 3044 | 3044 | NORTH MISSISSIPPI MEDICAL CENTER-GILMORE AMORY | 1105 EARL FRYE BLVD | AMORY | MS | 38821 | MONROE | (662) 256-7111 | Acute Care Hospitals | Proprietary | TRUE | 33.9775510 | -88.4776250 | 0 | 95 | 28 | 28095 | https://data.medicare.gov/resource/xubh-q36u/row-mseb-a3c5-hfq8 | 250025 | 649915 | 2019-06-03 | 2018-12-31 | 80 | 9 | 6 | 95 | 95 | |||||||||||||||
| 3074 | 3074 | UNIVERSITY OF SOUTH ALABAMA MEDICAL CENTER | 2451 FILLINGIM STREET | MOBILE | AL | 36617 | MOBILE | (251) 471-7110 | Acute Care Hospitals | Government - State | TRUE | 30.7081210 | -88.0994410 | 0 | 97 | 1 | 1097 | 33660 | Mobile-Daphne-Fairhope, AL | Central | Mobile County | https://data.medicare.gov/resource/xubh-q36u/row-cmzx-i3i2.bp42 | 10087 | 645038 | 2019-02-28 | 2018-09-30 | 117 | 9 | 7 | 16 | 149 | 149 | ||||||||||
| 3081 | 3081 | PETALUMA VALLEY HOSPITAL | 400 N MCDOWELL BLVD | PETALUMA | CA | 94954 | SONOMA | (707) 778-1111 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.2531830 | -122.6328600 | 0 | 97 | 6 | 6097 | 42220 | San Jose-San Francisco-Oakland, CA | Central | Sonoma County | https://data.medicare.gov/resource/xubh-q36u/row-bfnf_4u5r~hdm4 | 50136 | 662019 | 2019-11-27 | 2019-06-30 | 71 | 9 | 80 | 80 | ||||||||||||
| 3129 | 3129 | BELLA VISTA HOSPITAL | CARR 349 KM 2 7 CERRO LAS MESAS | MAYAGUEZ | PR | 681 | MAYAGUEZ | (787) 652-6045 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 18.1868275 | -67.1192192 | 1 | GEOMETRIC_CENTER | 97 | 72 | 72097 | 32420 | Mayagüez-San Germán, PR | Central | Mayagüez Municipio | https://data.medicare.gov/resource/xubh-q36u/row-3qj8-u7h6~eihq | 400014 | 650360 | 2019-06-03 | 2018-12-31 | 149 | 9 | 158 | 25 | 183 | ||||||||||
| 3172 | 3172 | HARRIS REGIONAL HOSPITAL | 68 HOSPITAL RD | SYLVA | NC | 28779 | JACKSON | (828) 586-7000 | Acute Care Hospitals | Proprietary | TRUE | 35.3839230 | -83.2027900 | 0 | 99 | 37 | 37099 | 19000 | Central | Jackson County | https://data.medicare.gov/resource/xubh-q36u/row-xxmc~xtb8_wjsz | 340016 | 658527 | 2019-05-09 | 2018-07-31 | 73 | 9 | 82 | 82 | |||||||||||||
| 3363 | 3363 | TROY REGIONAL MEDICAL CENTER | 1330 HIGHWAY 231 SOUTH | TROY | AL | 36081 | PIKE | (334) 670-5000 | Acute Care Hospitals | Government - Federal | TRUE | 31.7803220 | -85.9455290 | 0 | 109 | 1 | 1109 | 45980 | Central | Pike County | https://data.medicare.gov/resource/xubh-q36u/row-5ter_pyex-x2fe | 10126 | 654064 | 2019-08-30 | 2019-03-31 | 88 | 9 | 97 | 18 | 115 | ||||||||||||
| 3411 | 3411 | BARTLETT REGIONAL HOSPITAL | 3260 HOSPITAL DR | JUNEAU | AK | 99801 | JUNEAU | (907) 796-8900 | Acute Care Hospitals | Government - Local | TRUE | 58.3286960 | -134.4668290 | 0 | 110 | 2 | 2110 | 27940 | Central | Juneau City and Borough | https://data.medicare.gov/resource/xubh-q36u/row-ceet-msjy~uqhq | 20008 | 659178 | 2019-11-21 | 2019-06-30 | 36 | 9 | 45 | 12 | 57 | ||||||||||||
| 3445 | 3445 | MISSION HOSPITAL MCDOWELL | 430 RANKIN DRIVE P O BOX 730 | MARION | NC | 28752 | MC DOWELL | (828) 659-5000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 35.6651870 | -82.0217720 | 0 | 111 | 37 | 37111 | 32000 | Hickory-Lenoir, NC | Central | McDowell County | https://data.medicare.gov/resource/xubh-q36u/row-k2nj~ckkt.k7ui | 340087 | 660651 | 2019-12-02 | 2019-01-31 | 40 | 9 | 49 | 49 | ||||||||||||
| 3538 | 3538 | INTEGRIS MIAMI HOSPITAL | 200 SECOND AVENUE SOUTHWEST | MIAMI | OK | 74355 | OTTAWA | (918) 542-6611 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 36.8721540 | -94.8797720 | 0 | 115 | 40 | 40115 | 33060 | Joplin-Miami, MO-OK | Central | Ottawa County | https://data.medicare.gov/resource/xubh-q36u/row-juye_fwj7_x4b6 | 370004 | 660423 | 2019-11-27 | 2019-06-30 | 85 | 9 | 94 | 20 | 114 | |||||||||||
| 3638 | 3638 | SSM HEALTH ST MARY'S HOSPITAL -CENTRALIA | 400 NORTH PLEASANT AVENUE | CENTRALIA | IL | 62801 | MARION | (618) 436-8000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 38.5308090 | -89.1159990 | 0 | 121 | 17 | 17121 | 16460 | St. Louis-St. Charles-Farmington, MO-IL | Central | Marion County | https://data.medicare.gov/resource/xubh-q36u/row-328q~u4tz_dprn | 140034 | 649431 | 2019-05-29 | 2018-12-31 | 73 | 9 | 82 | 24 | 106 | |||||||||||
| 3679 | 3679 | SPECTRUM HEALTH GERBER MEMORIAL | 212 S SULLIVAN ST | FREMONT | MI | 49412 | NEWAYGO | (231) 924-3300 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 43.4643830 | -85.9507630 | 0 | 123 | 26 | 26123 | https://data.medicare.gov/resource/xubh-q36u/row-hx3e~pnt6_cpqb | 231338 | 659581 | 2019-11-22 | 2019-06-30 | 16 | 9 | 25 | 25 | ||||||||||||||||
| 3712 | 3712 | MCLAREN OAKLAND | 50 N PERRY ST | PONTIAC | MI | 48342 | OAKLAND | (248) 338-5000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.6383940 | -83.2910950 | 0 | 125 | 26 | 26125 | 19820 | Detroit-Warren-Ann Arbor, MI | Central | Oakland County | https://data.medicare.gov/resource/xubh-q36u/row-3bzu-t8bq_ne8q | 230207 | 644748 | 2019-02-27 | 2018-09-30 | 99 | 9 | 108 | 27 | 16 | 151 | ||||||||||
| 3768 | 3768 | HIMA SAN PABLO CUPEY | CARR 844 KM 5 CUPEY BAJO | SAN JUAN | PR | 928 | SAN JUAN | (787) 761-8383 | Acute Care Hospitals | Proprietary | TRUE | 18.3551846 | -66.0400062 | 1 | GEOMETRIC_CENTER | 127 | 72 | 72127 | 41980 | San Juan-Carolina, PR | Central | San Juan Municipio | https://data.medicare.gov/resource/xubh-q36u/row-dfqg_xf6v~mrae | 400133 | 660027 | 2019-11-08 | 2018-12-31 | 42 | 9 | 51 | 19 | 70 | ||||||||||
| 3869 | 3869 | PASSAVANT AREA HOSPITAL | 1600 W WALNUT ST | JACKSONVILLE | IL | 62650 | MORGAN | (217) 245-9551 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 39.7452680 | -90.2599120 | 0 | 137 | 17 | 17137 | 27300 | Springfield-Jacksonville-Lincoln, IL | Central | Morgan County | https://data.medicare.gov/resource/xubh-q36u/row-s6nm~srnx_9kx5 | 140058 | 645330 | 2019-02-28 | 2018-09-30 | 84 | 9 | 93 | 10 | 15 | 118 | ||||||||||
| 3884 | 3884 | DUNCAN REGIONAL HOSPITAL, INC | 1407 WHISENANT DRIVE | DUNCAN | OK | 73533 | STEPHENS | (580) 252-5300 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 34.5200140 | -97.9749780 | 0 | 137 | 40 | 40137 | 20340 | Central | Stephens County | https://data.medicare.gov/resource/xubh-q36u/row-dpp7.xywm-n53y | 370023 | 654693 | 2019-09-30 | 2019-06-30 | 77 | 9 | 86 | 12 | 12 | 110 | |||||||||||
| 4102 | 4102 | UNC ROCKINGHAM | 117 E KINGS HIGHWAY | EDEN | NC | 27288 | ROCKINGHAM | (336) 623-9711 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 36.4932100 | -79.7401120 | 0 | 157 | 37 | 37157 | 24660 | Greensboro--Winston-Salem--High Point, NC | Outlying | Rockingham County | https://data.medicare.gov/resource/xubh-q36u/row-gcjs~fh4y~diu3 | 340060 | 659595 | 2019-11-21 | 2019-06-30 | 99 | 9 | 108 | 121 | 229 | |||||||||||
| 4126 | 4126 | BOTHWELL REGIONAL HEALTH CENTER | 601 E 14TH ST | SEDALIA | MO | 65302 | PETTIS | (660) 826-8833 | Acute Care Hospitals | Government - Local | TRUE | 38.6990510 | -93.2220890 | 0 | 159 | 29 | 29159 | 42740 | Central | Pettis County | https://data.medicare.gov/resource/xubh-q36u/row-xpsz_cm4w.4eff | 260009 | 655921 | 2019-10-31 | 2019-05-31 | 99 | 9 | 108 | 108 | |||||||||||||
| 4312 | 4312 | SSM HEALTH SAINT JOSEPH HOSPITAL-LAKE SAINT LOUIS | 100 MEDICAL PLAZA | LAKE SAINT LOUIS | MO | 63367 | ST. CHARLES | (636) 625-5200 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 38.8037420 | -90.7744230 | 0 | 183 | 29 | 29183 | 41180 | St. Louis-St. Charles-Farmington, MO-IL | Central | St. Charles County | https://data.medicare.gov/resource/xubh-q36u/row-g7uu~2fcj-5jcn | 260200 | 648945 | 2019-05-29 | 2018-12-31 | 190 | 9 | 199 | 199 | ||||||||||||
| 4342 | 4342 | GUADALUPE REGIONAL MEDICAL CENTER | 1215 E COURT ST | SEGUIN | TX | 78155 | GUADALUPE | (830) 379-2411 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 29.5690430 | -97.9483340 | 0 | 187 | 48 | 48187 | 41700 | Central | Guadalupe County | https://data.medicare.gov/resource/xubh-q36u/row-gyz4_fre4.eqtq | 450104 | 643647 | 2019-02-26 | 2018-09-30 | 108 | 9 | 117 | 22 | 139 | ||||||||||||
| 4376 | 4376 | CGH MEDICAL CENTER | 100 EAST LEFEVRE ROAD | STERLING | IL | 61081 | WHITESIDE | (815) 625-0400 | Acute Care Hospitals | Government - Local | TRUE | 41.8015640 | -89.6967330 | 0 | 195 | 17 | 17195 | 44580 | Dixon-Sterling, IL | Central | Whiteside County | https://data.medicare.gov/resource/xubh-q36u/row-r8ij~7z4w-xsmp | 140043 | 654428 | 2019-09-25 | 2019-04-30 | 87 | 9 | 96 | 96 | ||||||||||||
| 4593 | 4593 | NAVARRO REGIONAL HOSPITAL | 3201 WEST HIGHWAY 22 | CORSICANA | TX | 75110 | NAVARRO | (903) 654-6800 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 32.0850830 | -96.5035820 | 0 | 349 | 48 | 48349 | 18620 | Dallas-Fort Worth, TX-OK | Central | Navarro County | https://data.medicare.gov/resource/xubh-q36u/row-5tcd-w9j9-mfc7 | 450447 | 655998 | 2019-10-14 | 2018-12-31 | 40 | 9 | 49 | 49 | ||||||||||||
| 1366 | 1366 | HARBORVIEW MEDICAL CENTER | 325 9TH AVENUE | SEATTLE | WA | 98104 | KING | (206) 731-3000 | Acute Care Hospitals | Government - Local | TRUE | 47.6040840 | -122.3233720 | 0 | 33 | 53 | 53033 | 42660 | Seattle-Tacoma, WA | Central | King County | https://data.medicare.gov/resource/xubh-q36u/row-fu42.79v4.ss25 | 500064 | 659621 | 2019-11-25 | 2019-06-30 | 232 | 89 | 321 | 68 | 24 | 413 | ||||||||||
| 1571 | 1571 | SAINT THOMAS WEST HOSPITAL | 4220 HARDING RD, PO BOX 380 | NASHVILLE | TN | 37205 | DAVIDSON | (615) 222-2111 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 36.1290830 | -86.8434476 | 1 | ROOFTOP | 37 | 47 | 47037 | 34980 | Nashville-Davidson--Murfreesboro, TN | Central | Davidson County | https://data.medicare.gov/resource/xubh-q36u/row-xfk3~krcg.f39q | 440082 | 660312 | 2019-11-26 | 2019-06-30 | 252 | 88 | 340 | 340 | |||||||||||
| 1862 | 1862 | RIVERSIDE METHODIST HOSPITAL | 3535 OLENTANGY RIVER RD | COLUMBUS | OH | 43214 | FRANKLIN | (614) 566-5000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.0319620 | -83.0312940 | 0 | 49 | 39 | 39049 | 18140 | Columbus-Marion-Zanesville, OH | Central | Franklin County | https://data.medicare.gov/resource/xubh-q36u/row-3863-kqrj_7sqc | 360006 | 659832 | 2019-11-21 | 2019-06-30 | 577 | 88 | 30 | 695 | 39 | 734 | ||||||||||
| 3224 | 3224 | CHILDREN'S HOSPITAL OF PHILADELPHIA | 34TH ST & CIVIC CENTER BLVD | PHILADELPHIA | PA | 19104 | PHILADELPHIA | (215) 590-3745 | Childrens | Voluntary non-profit - Private | TRUE | 39.9486690 | -75.1929060 | 0 | 101 | 42 | 42101 | 37980 | Philadelphia-Reading-Camden, PA-NJ-DE-MD | Central | Philadelphia County | https://data.medicare.gov/resource/xubh-q36u/row-p6rn~t7a3.ngvz | 393303 | 661971 | 2019-11-27 | 2019-06-30 | 369 | 88 | 98 | 555 | 555 | |||||||||||
| 3429 | 3429 | JEWISH HOSPITAL & ST MARY'S HEALTHCARE | 200 ABRAHAM FLEXNER WAY | LOUISVILLE | KY | 40202 | JEFFERSON | (502) 587-4011 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 38.2493280 | -85.7511370 | 0 | 111 | 21 | 21111 | 31140 | Louisville/Jefferson County--Elizabethtown--Madison, KY-IN | Central | Jefferson County | https://data.medicare.gov/resource/xubh-q36u/row-gura~be7g-xjry | 180040 | 657829 | 2019-11-01 | 2019-06-30 | 423 | 88 | 135 | 731 | 90 | 821 | ||||||||||
| 2623 | 2623 | LEHIGH VALLEY HOSPITAL | 1200 SOUTH CEDAR CREST BOULEVARD | ALLENTOWN | PA | 18105 | LEHIGH | (610) 402-2273 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.5667720 | -75.5186720 | 0 | 77 | 42 | 42077 | 10900 | New York-Newark, NY-NJ-CT-PA | Central | Lehigh County | https://data.medicare.gov/resource/xubh-q36u/row-5fzf-faw4~6h9r | 390133 | 659871 | 2019-11-26 | 2019-06-30 | 830 | 86 | 14 | 18 | 11 | 42 | 1023 | 52 | 62 | 52 | 10 | 1199 | ||||
| 4415 | 4415 | HCA HOUSTON HEALTHCARE CLEAR LAKE | 500 MEDICAL CENTER BLVD | WEBSTER | TX | 77598 | HARRIS | (281) 332-2511 | Acute Care Hospitals | Proprietary | TRUE | 29.5410620 | -95.1262740 | 0 | 201 | 48 | 48201 | 26420 | Houston-The Woodlands, TX | Central | Harris County | https://data.medicare.gov/resource/xubh-q36u/row-yjyj_jp52-vmf5 | 450617 | 662265 | 2019-12-19 | 2018-12-31 | 446 | 86 | 532 | 5 | 41 | 578 | ||||||||||
| 574 | 574 | BANNER BOSWELL MEDICAL CENTER | 10401 WEST THUNDERBIRD BOULEVARD | SUN CITY | AZ | 85351 | MARICOPA | (623) 832-4000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 33.6047980 | -112.2825380 | 0 | 13 | 4 | 4013 | 38060 | Central | Maricopa County | https://data.medicare.gov/resource/xubh-q36u/row-jqxq_rtvy~eb3s | 30061 | 654709 | 2019-09-18 | 2018-12-31 | 325 | 85 | 410 | 24 | 91 | 525 | |||||||||||
| 3887 | 3887 | NORTHEAST GEORGIA MEDICAL CENTER, INC | 743 SPRING STREET | GAINESVILLE | GA | 30501 | HALL | (770) 535-3553 | Acute Care Hospitals | Government - Local | TRUE | 34.3033500 | -83.8173700 | 0 | 139 | 13 | 13139 | 23580 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Hall County | https://data.medicare.gov/resource/xubh-q36u/row-7syr~f3ei~dkan | 110029 | 645060 | 2019-03-01 | 2018-09-30 | 460 | 85 | 545 | 54 | 24 | 261 | 884 | |||||||||
| 141 | 141 | HARTFORD HOSPITAL | 80 SEYMOUR STREET | HARTFORD | CT | 6102 | HARTFORD | (860) 545-5000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.7541230 | -72.6808200 | 0 | 3 | 9 | 9003 | 25540 | Hartford-West Hartford, CT | Central | Hartford County | https://data.medicare.gov/resource/xubh-q36u/row-rks5-ncpa-u5sg | 70025 | 645239 | 2019-03-20 | 2018-09-30 | 645 | 84 | 729 | 105 | 104 | 938 | ||||||||||
| 2326 | 2326 | ERLANGER MEDICAL CENTER | 975 E 3RD ST | CHATTANOOGA | TN | 37403 | HAMILTON | (423) 778-7000 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 35.0478990 | -85.2908530 | 0 | 65 | 47 | 47065 | 16860 | Chattanooga-Cleveland-Dalton, TN-GA-AL | Central | Hamilton County | https://data.medicare.gov/resource/xubh-q36u/row-5dss-8gth.uas3 | 440104 | 660457 | 2019-11-27 | 2019-06-30 | 462 | 84 | 8 | 18 | 64 | 674 | 674 | |||||||||
| 2676 | 2676 | AURORA ST LUKES MEDICAL CENTER | 2900 W OKLAHOMA AVE | MILWAUKEE | WI | 53215 | MILWAUKEE | (414) 649-6000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.9886120 | -87.9493460 | 0 | 79 | 55 | 55079 | 33340 | Milwaukee-Racine-Waukesha, WI | Central | Milwaukee County | https://data.medicare.gov/resource/xubh-q36u/row-qcnh-udu6_8sdp | 520138 | 651103 | 2019-06-04 | 2018-12-31 | 675 | 84 | 66 | 868 | 65 | 933 | ||||||||||
| 2500 | 2500 | ST VINCENT'S BIRMINGHAM | 810 ST VINCENT'S DRIVE | BIRMINGHAM | AL | 35205 | JEFFERSON | (205) 939-7000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 33.5080150 | -86.7887550 | 0 | 73 | 1 | 1073 | 13820 | Birmingham-Hoover-Talladega, AL | Central | Jefferson County | https://data.medicare.gov/resource/xubh-q36u/row-6naf-9cek~29rm | 10056 | 659398 | 2019-11-22 | 2019-06-30 | 275 | 83 | 12 | 30 | 400 | 400 | ||||||||||
| 4674 | 4674 | ASCENSION SETON MEDICAL CENTER AUSTIN | 1201 W 38TH ST | AUSTIN | TX | 78705 | TRAVIS | (512) 324-1000 | Acute Care Hospitals | Physician | TRUE | 30.3061540 | -97.7452180 | 0 | 453 | 48 | 48453 | 12420 | Central | Travis County | https://data.medicare.gov/resource/xubh-q36u/row-qf7b-dsjj.a9dv | 450056 | 659731 | 2019-11-25 | 2019-06-30 | 304 | 83 | 43 | 430 | 430 | ||||||||||||
| 839 | 839 | UNIVERSITY OF MISSOURI HEALTH CARE | ONE HOSPITAL DRIVE | COLUMBIA | MO | 65212 | BOONE | (573) 882-4141 | Acute Care Hospitals | Government - State | TRUE | 38.9386955 | -92.3275514 | 1 | ROOFTOP | 19 | 29 | 29019 | 17860 | Columbia-Moberly-Mexico, MO | Central | Boone County | https://data.medicare.gov/resource/xubh-q36u/row-63ac~57ef~2j52 | 260141 | 660405 | 2019-11-26 | 2019-06-30 | 372 | 82 | 58 | 530 | 61 | 591 | |||||||||
| 1078 | 1078 | UMASS MEMORIAL MEDICAL CENTER INC | 55 LAKE AVENUE NORTH | WORCESTER | MA | 1655 | WORCESTER | (508) 334-1000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.2785100 | -71.7590790 | 0 | 27 | 25 | 25027 | 49340 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Worcester County | https://data.medicare.gov/resource/xubh-q36u/row-t2gz_92wg~829y | 220163 | 643900 | 2019-03-05 | 2018-09-30 | 461 | 82 | 30 | 27 | 600 | 40 | 640 | |||||||||
| 1981 | 1981 | ST JOSEPH MEDICAL CENTER | 1717 SOUTH J STREET | TACOMA | WA | 98405 | PIERCE | (253) 627-4101 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 47.2454690 | -122.4487570 | 0 | 53 | 53 | 53053 | 42660 | Seattle-Tacoma, WA | Central | Pierce County | https://data.medicare.gov/resource/xubh-q36u/row-pud3~63vu~69st | 500108 | 662624 | 2019-11-27 | 2019-06-30 | 292 | 82 | 374 | 374 | ||||||||||||
| 1357 | 1357 | UNIVERSITY OF WASHINGTON MEDICAL CTR | 1959 NE PACIFIC ST BOX 356151 | SEATTLE | WA | 98195 | KING | (206) 598-3300 | Acute Care Hospitals | Government - State | TRUE | 47.6505060 | -122.3074820 | 0 | 33 | 53 | 53033 | 42660 | Seattle-Tacoma, WA | Central | King County | https://data.medicare.gov/resource/xubh-q36u/row-gezf_iitw.mxe8 | 500008 | 661427 | 2018-11-29 | 2018-06-30 | 209 | 81 | 50 | 408 | 16 | 18 | 442 | |||||||||
| 4477 | 4477 | SOUTH TEXAS HEALTH SYSTEM | 1102 W TRENTON ROAD | EDINBURG | TX | 78539 | HIDALGO | (956) 632-4484 | Acute Care Hospitals | Proprietary | TRUE | 26.2633410 | -98.1828490 | 0 | 215 | 48 | 48215 | 32580 | McAllen-Edinburg, TX | Central | Hidalgo County | https://data.medicare.gov/resource/xubh-q36u/row-ueuk_wahb_mxys | 450119 | 651355 | 2019-05-28 | 2018-12-31 | 601 | 81 | 60 | 788 | 28 | 22 | 838 | |||||||||
| 542 | 542 | PEACEHEALTH SOUTHWEST MEDICAL CENTER | 400 NE MOTHER JOSEPH PLACE | VANCOUVER | WA | 98668 | CLARK | (360) 256-2000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 45.6234860 | -122.5806360 | 0 | 11 | 53 | 53011 | 38900 | Portland-Vancouver-Salem, OR-WA | Central | Clark County | https://data.medicare.gov/resource/xubh-q36u/row-dpuj-5ndk.kv2i | 500050 | 662623 | 2019-12-02 | 2019-06-30 | 356 | 80 | 436 | 14 | 450 | |||||||||||
| 1212 | 1212 | UF HEALTH JACKSONVILLE | 655 W 8TH ST | JACKSONVILLE | FL | 32209 | DUVAL | (904) 244-0411 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 30.3467990 | -81.6642280 | 0 | 31 | 12 | 12031 | 27260 | Jacksonville-St. Marys-Palatka, FL-GA | Central | Duval County | https://data.medicare.gov/resource/xubh-q36u/row-ku4k~xtjd~bra7 | 100001 | 661475 | 2019-11-27 | 2019-06-30 | 348 | 80 | 49 | 8 | 533 | 56 | 589 | |||||||||
| 2336 | 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 | ||||||||||
| 2439 | 2439 | KAISER FOUNDATION HOSPITAL FONTANA | 9961 SIERRA AVE | FONTANA | CA | 92335 | SAN BERNARDINO | (909) 427-5500 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 34.0722710 | -117.4334580 | 0 | 71 | 6 | 6071 | 40140 | Los Angeles-Long Beach, CA | Central | San Bernardino County | https://data.medicare.gov/resource/xubh-q36u/row-brke.g9vc_t49y | 50140 | 651689 | 2019-07-08 | 2018-12-31 | 510 | 80 | 626 | 626 | ||||||||||||
| 4170 | 4170 | HENRY FORD WYANDOTTE HOSPITAL | 2333 BIDDLE AVE | WYANDOTTE | MI | 48192 | WAYNE | (734) 246-6000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.2096940 | -83.1487760 | 0 | 163 | 26 | 26163 | 19820 | Detroit-Warren-Ann Arbor, MI | Central | Wayne County | https://data.medicare.gov/resource/xubh-q36u/row-qx72.w4qi.dfny | 230146 | 650160 | 2019-06-03 | 2018-12-31 | 201 | 80 | 281 | 38 | 38 | 357 | ||||||||||
| 30 | 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 | ||||||||||||||||
| 58 | 58 | PLATTE VALLEY MEDICAL CENTER | 1600 PRAIRIE CENTER PKWY | BRIGHTON | CO | 80601 | ADAMS | (303) 498-1601 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 39.9654410 | -104.7709240 | 0 | 1 | 8 | 8001 | 19740 | Denver-Aurora, CO | Central | Adams County | https://data.medicare.gov/resource/xubh-q36u/row-nf6e_r5cw.zmhy | 60004 | 648669 | 2019-05-31 | 2018-12-31 | 65 | 8 | 89 | 89 | ||||||||||||
| 107 | 107 | LOVELACE WOMEN'S HOSPITAL | 4701 MONTGOMERY BOULEVARD NE | ALBUQUERQUE | NM | 87109 | BERNALILLO | (505) 727-7805 | Acute Care Hospitals | Government - State | TRUE | 35.1310050 | -106.5910370 | 0 | 1 | 35 | 35001 | 10740 | Albuquerque-Santa Fe-Las Vegas, NM | Central | Bernalillo County | https://data.medicare.gov/resource/xubh-q36u/row-fycu~sc7u.8im7 | 320017 | 655223 | 2019-10-17 | 2019-04-30 | 112 | 8 | 42 | 162 | 162 | |||||||||||
| 109 | 109 | LOVELACE WESTSIDE HOSPITAL | 10501 GOLF COURSE ROAD NW | ALBUQUERQUE | NM | 87114 | BERNALILLO | (505) 727-2001 | Acute Care Hospitals | Proprietary | TRUE | 35.2075080 | -106.6759740 | 0 | 1 | 35 | 35001 | 10740 | Albuquerque-Santa Fe-Las Vegas, NM | Central | Bernalillo County | https://data.medicare.gov/resource/xubh-q36u/row-t6an-qbnd.nby8 | 320074 | 651222 | 2019-06-28 | 2019-01-31 | 62 | 8 | 70 | 70 | ||||||||||||
| 120 | 120 | GETTYSBURG HOSPITAL | 147 GETTYS STREET | GETTYSBURG | PA | 17325 | ADAMS | (717) 334-2121 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 39.8233170 | -77.2340440 | 0 | 1 | 42 | 42001 | 23900 | Harrisburg-York-Lebanon, PA | Central | Adams County | https://data.medicare.gov/resource/xubh-q36u/row-493f.cvfq~sac8 | 390065 | 660855 | 2019-11-26 | 2019-06-30 | 68 | 8 | 76 | 76 | ||||||||||||
| 155 | 155 | PALI MOMI MEDICAL CENTER | 98-1079 MOANALUA ROAD | AIEA | HI | 96701 | HONOLULU | (808) 486-6000 | Acute Care Hospitals | Proprietary | TRUE | 21.3839880 | -157.9376750 | 0 | 3 | 15 | 15003 | 46520 | Central | Honolulu County | https://data.medicare.gov/resource/xubh-q36u/row-gvhj-d3a6.ypz3 | 120026 | 659776 | 2019-11-26 | 2019-06-30 | 110 | 8 | 118 | 118 | |||||||||||||
| 161 | 161 | ADVENTIST HEALTH CASTLE | 640 ULUKAHIKI ST | KAILUA | HI | 96734 | HONOLULU | (808) 263-5500 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 21.3815020 | -157.7572290 | 0 | 3 | 15 | 15003 | 46520 | Central | Honolulu County | https://data.medicare.gov/resource/xubh-q36u/row-5zcn.p8qz~eqqf | 120006 | 655891 | 2019-10-07 | 2018-12-31 | 152 | 8 | 160 | 160 | |||||||||||||
| 233 | 233 | UPMC EAST | 2775 MOSSIDE BOULEVARD | MONROEVILLE | PA | 15146 | ALLEGHENY | (412) 357-3000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.4370140 | -79.7584580 | 0 | 3 | 42 | 42003 | 38300 | Pittsburgh-New Castle-Weirton, PA-OH-WV | Central | Allegheny County | https://data.medicare.gov/resource/xubh-q36u/row-dmwf~khzy.9g9v | 390328 | 659885 | 2019-11-26 | 2019-06-30 | 128 | 8 | 136 | 20 | 156 | |||||||||||
| 243 | 243 | TENNOVA HEALTHCARE-SHELBYVILLE | 2835 HWY 231 NORTH | SHELBYVILLE | TN | 37160 | BEDFORD | (931) 685-5433 | Acute Care Hospitals | Proprietary | TRUE | 35.5632180 | -86.4463720 | 0 | 3 | 47 | 47003 | 43180 | Nashville-Davidson--Murfreesboro, TN | Central | Bedford County | https://data.medicare.gov/resource/xubh-q36u/row-nnwj-ykm6~eviv | 440137 | 654172 | 2019-09-04 | 2019-03-31 | 36 | 8 | 44 | 44 | ||||||||||||
| 291 | 291 | ESSENTIA HEALTH ST MARYS - DETROIT LAKES | 1027 WASHINGTON AVE | DETROIT LAKES | MN | 56501 | BECKER | (218) 847-0888 | Acute Care Hospitals | Voluntary non-profit - Church | FALSE | 46.8153070 | -95.8454530 | 0 | 5 | 27 | 27005 | https://data.medicare.gov/resource/xubh-q36u/row-my2b~zwif~njdr | 240101 | 660605 | 2019-11-26 | 2019-06-30 | 28 | 8 | 36 | 96 | 132 | |||||||||||||||
| 312 | 312 | PROVIDENCE WILLAMETTE FALLS MEDICAL CENTER | 1500 DIVISION STREET | OREGON CITY | OR | 97045 | CLACKAMAS | (503) 657-6915 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 45.3566470 | -122.5883710 | 0 | 5 | 41 | 41005 | 38900 | Portland-Vancouver-Salem, OR-WA | Central | Clackamas County | https://data.medicare.gov/resource/xubh-q36u/row-4zvi_yd6d-6gyq | 380038 | 648648 | 2019-05-22 | 2018-12-31 | 103 | 8 | 111 | 111 | ||||||||||||
| 334 | 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 | ||||||||||||
| 418 | 418 | PARRISH MEDICAL CENTER | 951 N WASHINGTON AVE | TITUSVILLE | FL | 32796 | BREVARD | (321) 268-6111 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 28.6290680 | -80.8249430 | 0 | 9 | 12 | 12009 | 37340 | Central | Brevard County | https://data.medicare.gov/resource/xubh-q36u/row-md6z.znz4~w9v4 | 100028 | 645533 | 2019-03-05 | 2018-09-30 | 202 | 8 | 210 | 210 | |||||||||||||
| 444 | 444 | ANNA JAQUES HOSPITAL | 25 HIGHLAND AVENUE | NEWBURYPORT | MA | 1950 | ESSEX | (978) 463-1000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.8143580 | -70.8897830 | 0 | 9 | 25 | 25009 | 14460 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Essex County | https://data.medicare.gov/resource/xubh-q36u/row-rfgc.9n4j-t573 | 220029 | 644035 | 2019-03-05 | 2018-09-30 | 112 | 8 | 120 | 20 | 140 | |||||||||||
| 455 | 455 | PLAINS REGIONAL MEDICAL CENTER | 2100 N MARTIN LUTHER KING, JR, BLVD | CLOVIS | NM | 88101 | CURRY | (575) 769-7155 | Acute Care Hospitals | Government - Federal | TRUE | 34.4204900 | -103.2317630 | 0 | 9 | 35 | 35009 | 17580 | Clovis-Portales, NM | Central | Curry County | https://data.medicare.gov/resource/xubh-q36u/row-dvw2.36gg-bpn9 | 320022 | 650185 | 2019-05-30 | 2018-12-31 | 98 | 8 | 106 | 106 | ||||||||||||
| 463 | 463 | SOUTH COUNTY HOSPITAL INC | 100 KENYON AVE | WAKEFIELD | RI | 2879 | WASHINGTON | (401) 782-8020 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.4318830 | -71.4958820 | 0 | 9 | 44 | 44009 | 39300 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Washington County | https://data.medicare.gov/resource/xubh-q36u/row-ztkr.arxn.8ucp | 410008 | 645608 | 2019-03-01 | 2018-09-30 | 71 | 8 | 79 | 79 | ||||||||||||
| 466 | 466 | BLOUNT MEMORIAL HOSPITAL | 907 E LAMAR ALEXANDER PARKWAY | MARYVILLE | TN | 37804 | BLOUNT | (865) 983-7211 | Acute Care Hospitals | Government - Local | TRUE | 35.7549750 | -83.9586020 | 0 | 9 | 47 | 47009 | 28940 | Knoxville-Morristown-Sevierville, TN | Central | Blount County | https://data.medicare.gov/resource/xubh-q36u/row-q2u9.xgek.22ux | 440011 | 659450 | 2019-11-25 | 2019-06-30 | 177 | 8 | 8 | 193 | 10 | 76 | 279 | |||||||||
| 471 | 471 | ST MARYS HOSPITAL MEDICAL CTR | 1726 SHAWANO AVE | GREEN BAY | WI | 54303 | BROWN | (920) 498-4200 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 44.5321840 | -88.0665610 | 0 | 9 | 55 | 55009 | 24580 | Green Bay-Shawano, WI | Central | Brown County | https://data.medicare.gov/resource/xubh-q36u/row-kt4k-sbbe~w8n6 | 520097 | 660733 | 2019-11-25 | 2019-06-30 | 75 | 8 | 83 | 83 | ||||||||||||
| 503 | 503 | WITHAM HEALTH SERVICES | 2605 N LEBANON ST | LEBANON | IN | 46052 | BOONE | (765) 485-8000 | Acute Care Hospitals | Government - Local | TRUE | 40.0769090 | -86.4752090 | 0 | 11 | 18 | 18011 | 26900 | Indianapolis-Carmel-Muncie, IN | Central | Boone County | https://data.medicare.gov/resource/xubh-q36u/row-gfq5-5jsq-rtmb | 150104 | 649208 | 2019-05-31 | 2018-12-31 | 60 | 8 | 68 | 10 | 18 | 96 | ||||||||||
| 512 | 512 | BOLIVAR MEDICAL CENTER | 901 E SUNFLOWER RD | CLEVELAND | MS | 38732 | BOLIVAR | (662) 846-0061 | Acute Care Hospitals | Proprietary | TRUE | 33.7474710 | -90.7081280 | 0 | 11 | 28 | 28011 | 17380 | Cleveland-Indianola, MS | Central | Bolivar County | https://data.medicare.gov/resource/xubh-q36u/row-6ymk.r4nx_mhwx | 250093 | 653424 | 2019-09-03 | 2019-03-31 | 144 | 8 | 152 | 12 | 35 | 199 | ||||||||||
| 536 | 536 | LAKEVIEW HOSPITAL | 630 EAST MEDICAL DRIVE | BOUNTIFUL | UT | 84010 | DAVIS | (801) 299-2200 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 40.8868550 | -111.8686180 | 0 | 11 | 49 | 49011 | 36260 | Salt Lake City-Provo-Orem, UT | Central | Davis County | https://data.medicare.gov/resource/xubh-q36u/row-day8~4ris~x974 | 460042 | 659016 | 2019-11-07 | 2018-09-30 | 73 | 8 | 81 | 8 | 89 | |||||||||||
| 551 | 551 | SCOTTSDALE THOMPSON PEAK MEDICAL CENTER | 7400 EAST THOMPSON PEAK PARKWAY | SCOTTSDALE | AZ | 85255 | MARICOPA | (480) 324-7001 | Acute Care Hospitals | Proprietary | TRUE | 33.6697770 | -111.9218030 | 0 | 13 | 4 | 4013 | 38060 | Central | Maricopa County | https://data.medicare.gov/resource/xubh-q36u/row-y7bn~8g49_tr6b | 30123 | 650235 | 2019-05-31 | 2018-12-31 | 112 | 8 | 120 | 120 |
Advanced export
JSON shape: default, array, newline-delimited
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 );