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

3,280 rows where hospital_type = "Acute Care Hospitals" sorted by hospital_name

View and edit SQL

Suggested facets: hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, burn_beds, subprovider_oth_beds, nursing_fac_beds, filed_date (date), fy_end_date (date)

hospital_type

  • Acute Care Hospitals · 3,280
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
3472 ABBEVILLE GENERAL HOSPITAL 118 N HOSPITAL DR ABBEVILLE LA 70510 VERMILION (337) 893-5466 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9732500 -92.1069860 0   113 22 22113 29180 Lafayette-Opelousas-Morgan City, LA Outlying Vermilion Parish https://data.medicare.gov/resource/xubh-q36u/row-b6fd-eygy.vwqx 190034 649244 2019-05-31 2018-12-31 38 6         44 16             60
1955 ABBOTT NORTHWESTERN HOSPITAL 800 EAST 28TH STREET MINNEAPOLIS MN 55407 HENNEPIN (612) 863-4457 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.9519540 -93.2622480 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-hjfu-wxhn.rudj 240057 649761 2019-05-23 2018-12-31 537 30         599   39   48       686
4659 ABILENE REGIONAL MEDICAL CENTER 6250 HWY 83/84 ABILENE TX 79606 TAYLOR (325) 428-1000 Acute Care Hospitals Proprietary TRUE 32.3740060 -99.7425950 0   441 48 48441 10180   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-rque_a7mi~an5d 450558 657529 2019-04-12 2018-08-31 160 20         196               196
2968 ABINGTON MEMORIAL HOSPITAL 1200 OLD YORK ROAD ABINGTON PA 19001 MONTGOMERY (215) 481-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1189450 -75.1193820 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-yqgf~xkux~zsam 390231 661639 2019-12-03 2019-06-30 503 33     22   592 23 23           638
566 ABRAZO ARROWHEAD CAMPUS 18701 NORTH 67TH AVENUE GLENDALE AZ 85308 MARICOPA (623) 561-1000 Acute Care Hospitals Proprietary TRUE 33.6550420 -112.2028890 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mbqg~urbx.9rm7 30094 654000 2019-08-29 2019-03-31 224 38         262               262
565 ABRAZO CENTRAL CAMPUS 2000 WEST BETHANY HOME ROAD PHOENIX AZ 85015 MARICOPA (602) 249-0212 Acute Care Hospitals Physician TRUE 33.5241160 -112.1019340 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-apke-ic6r-dws7 30030 654065 2019-08-30 2019-03-31 116 28         144   16           160
549 ABRAZO SCOTTSDALE CAMPUS 3929 EAST BELL ROAD PHOENIX AZ 85032 MARICOPA (602) 923-5000 Acute Care Hospitals Proprietary TRUE 33.6406030 -111.9976920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-3yrx.bcen.wd4a 30083 644698 2019-02-28 2018-09-30 113 14         127               127
577 ABRAZO WEST CAMPUS 13677 WEST MCDOWELL ROAD GOODYEAR AZ 85395 MARICOPA (623) 882-1970 Acute Care Hospitals Proprietary TRUE 33.4642830 -112.3540240 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6kds~arrq.mhdd 30110 654825 2019-09-26 2019-04-30 159 20         179               179
92 ACADIA GENERAL HOSPITAL 1305 CROWLEY RAYNE HIGHWAY CROWLEY LA 70526 ACADIA (337) 783-3222 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2263270 -92.3625430 0   1 22 22001 29180 Lafayette-Opelousas-Morgan City, LA Outlying Acadia Parish https://data.medicare.gov/resource/xubh-q36u/row-uxyh.5msh~3m79 190044 643888 2019-03-01 2018-09-30 136 4         140               140
315 ACMH HOSPITAL ONE NOLTE DRIVE KITTANNING PA 16201 ARMSTRONG (724) 543-8500 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8085788 -79.5614577 1 ROOFTOP 5 42 42005 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Outlying Armstrong County https://data.medicare.gov/resource/xubh-q36u/row-nu27~a8n8_t6km 390163 660863 2019-12-02 2019-06-30 119 12         131   16   17       164
4424 AD HOSPITAL EAST, LLC 12950 EAST FREEWAY, SUITE 100 HOUSTON TX 77015 HARRIS (713) 330-3897 Acute Care Hospitals Proprietary TRUE 29.7711360 -95.2007820 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-g9pj_7cms.hams 670102 649155 2019-05-30 2018-12-31 4           4               4
1083 ADCARE HOSPITAL OF WORCESTER INC 107 LINCOLN STREET WORCESTER MA 1605 WORCESTER (508) 799-9000 Acute Care Hospitals Proprietary FALSE 42.2761820 -71.7955760 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-rnsb.iihy_fs75 220062 645423 2019-03-01 2018-09-30 114           114               114
3923 ADENA REGIONAL MEDICAL CENTER 272 HOSPITAL ROAD CHILLICOTHE OH 45601 ROSS (740) 779-7500 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3945930 -82.9697810 0   141 39 39141 17060 Columbus-Marion-Zanesville, OH Central Ross County https://data.medicare.gov/resource/xubh-q36u/row-t8uy_6z9h-f7fq 360159 648968 2019-05-30 2018-12-31 177 12         189               189
1347 ADIRONDACK MEDICAL CENTER - SARANAC LAKE 2233 STATE ROUTE 86, PO BOX 471 SARANAC LAKE NY 12983 FRANKLIN (518) 891-4141 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.3445480 -74.1445970 0   33 36 36033 31660   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-7ubk-sp7w.3hyq 330079 651024 2019-06-03 2018-12-31 75 8         83 12     60       155
3765 ADMIN DE SERVICIOS MEDICOS PUERTO RIC BO MONACILLO CARR NUM 22 SAN JUAN PR 935 SAN JUAN (787) 777-3535 Acute Care Hospitals Government - Local TRUE 18.4500000 -66.0600000 1 APPROXIMATE 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-gchu_zjdy_292t 400127 660877 2019-11-27 2019-06-30   68         68               68
3730 ADVANCED SURGICAL HOSPITAL 100 TRICH DRIVE WASHINGTON PA 15301 WASHINGTON (724) 884-0710 Acute Care Hospitals Physician FALSE 40.1567230 -80.2805360 0   125 42 42125 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ni2v.da26_jxgn 390323 648978 2019-05-29 2018-12-31 14           14               14
2053 ADVENTHEALTH CARROLLWOOD 7171 N DALE MABRY HWY TAMPA FL 33614 HILLSBOROUGH (813) 932-2222 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.0131020 -82.5049540 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-22he-y9u8_3jua 100069 649181 2019-05-31 2018-12-31 95 8         103               103
1107 ADVENTHEALTH CENTRAL TEXAS 2201 S CLEAR CREEK ROAD KILLEEN TX 76542 BELL (254) 526-7523 Acute Care Hospitals Voluntary non-profit - Church TRUE 31.1133500 -97.7995190 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-d3a2-awra.pykq 450152 656365 2019-10-17 2018-09-30 194 10       4 208               208
3196 ADVENTHEALTH DADE CITY 13100 FT KING RD DADE CITY FL 33525 PASCO (352) 568-3174 Acute Care Hospitals Proprietary TRUE 28.3485870 -82.2016850 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-w886-maw8~uhkt 100211 644709 2019-02-28 2018-09-30 108 12         120               120
3739 ADVENTHEALTH DAYTONA BEACH 301 MEMORIAL MEDICAL PARKWAY DAYTONA BEACH FL 32117 VOLUSIA (386) 676-6000 Acute Care Hospitals Voluntary non-profit - Church FALSE 29.2427500 -81.1093000 0   127 12 12127 19660 Orlando-Deltona-Daytona Beach, FL Central Volusia County https://data.medicare.gov/resource/xubh-q36u/row-7r9b.2c85_ysjw 100068 656267 2019-10-21 2018-12-31 233 46         295   32           327
3742 ADVENTHEALTH DELAND 701 W PLYMOUTH AVE DELAND FL 32720 VOLUSIA (386) 943-4772 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.0426130 -81.3172050 0   127 12 12127 19660 Orlando-Deltona-Daytona Beach, FL Central Volusia County https://data.medicare.gov/resource/xubh-q36u/row-vm7w-sguw.j5as 100045 650676 2019-05-31 2018-12-31 130 24         154 10             164
3741 ADVENTHEALTH FISH MEMORIAL 1055 SAXON BLVD ORANGE CITY FL 32763 VOLUSIA (386) 917-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.9112900 -81.2841220 0   127 12 12127 19660 Orlando-Deltona-Daytona Beach, FL Central Volusia County https://data.medicare.gov/resource/xubh-q36u/row-ieux~5sp5~x27i 100072 654643 2019-09-24 2018-12-31 158 21         179               179
3783 ADVENTHEALTH GORDON 1035 RED BUD ROAD CALHOUN GA 30701 GORDON (706) 629-2895 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.5118780 -84.9253700 0   129 13 13129 15660 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Gordon County https://data.medicare.gov/resource/xubh-q36u/row-jbx7.hnkp.i7n7 110023 649429 2019-05-30 2018-12-31 61 8         69               69
3302 ADVENTHEALTH HEART OF FLORIDA 40100 HWY 27 DAVENPORT FL 33837 POLK (863) 422-4971 Acute Care Hospitals Proprietary TRUE 28.1803340 -81.6399540 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-febs~ded9_jd7n 100137 656903 2018-12-03 2018-06-30 178 15         193               193
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
1901 ADVENTHEALTH MANCHESTER 210 MARIE LANGDON DRIVE MANCHESTER KY 40962 CLAY (606) 598-5104 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.1621540 -83.7613560 0   51 21 21051         https://data.medicare.gov/resource/xubh-q36u/row-vicy-u46v-q8em 180043 644277 2019-03-01 2018-09-30 43 6         49               49
4465 ADVENTHEALTH MURRAY 707 OLD DALTON ELLIJAY ROAD, PO BOX 1406 CHATSWORTH GA 30705 MURRAY (706) 517-2031 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7799510 -84.7821250 0   213 13 13213 19140 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Murray County https://data.medicare.gov/resource/xubh-q36u/row-6we3.tc54~eygq 110050 651268 2019-06-07 2018-12-31 29           29               29
3743 ADVENTHEALTH NEW SMYRNA BEACH 401 PALMETTO ST NEW SMYRNA BEACH FL 32170 VOLUSIA (386) 424-5100 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.0211740 -80.9229030 0   127 12 12127 19660 Orlando-Deltona-Daytona Beach, FL Central Volusia County https://data.medicare.gov/resource/xubh-q36u/row-6zn7-6yd4.hxia 100014 649178 2019-05-30 2018-12-31 98 14         112               112
3257 ADVENTHEALTH NORTH PINELLAS 1395 S PINELLAS AVE TARPON SPRINGS FL 34689 PINELLAS (727) 942-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 28.1331400 -82.7585760 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-fea3-vbec-qidb 100055 649410 2019-05-30 2018-12-31 123 13         136       32       168
2741 ADVENTHEALTH OCALA 1500 SW 1ST AVE OCALA FL 34474 MARION (352) 351-7200 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.1742360 -82.1378340 0   83 12 12083 36100   Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-5mfq.kkk3.z2w9 100062 644236 2019-01-29 2018-07-31 369 44         413               413
3032 ADVENTHEALTH ORLANDO 601 E ROLLINS ST ORLANDO FL 32803 ORANGE (407) 303-1976 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.5734570 -81.3703280 0   95 12 12095 36740 Orlando-Deltona-Daytona Beach, FL Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-4fra_j2em.99x3 100007 648798 2019-05-22 2018-12-31 2256 221 40       2753 43 30           2826
2138 ADVENTHEALTH OTTAWA 1301 S MAIN STREET OTTAWA KS 66067 FRANKLIN (785) 229-8200 Acute Care Hospitals Government - Local FALSE 38.5972850 -95.2687590 0   59 20 20059 36840 Kansas City-Overland Park-Kansas City, MO-KS Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-kk74.krt5~vw4m 170014 654922 2019-10-01 2019-04-30 42 5         47               47
1383 ADVENTHEALTH PALM COAST 60 MEMORIAL MEDICAL PKWY PALM COAST FL 32164 FLAGLER (386) 586-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.4789870 -81.1900890 0   35 12 12035 19660 Orlando-Deltona-Daytona Beach, FL Central Flagler County https://data.medicare.gov/resource/xubh-q36u/row-zkit_irst-fsuv 100118 649415 2019-05-30 2018-12-31 81 18         99           32   131
1996 ADVENTHEALTH SEBRING 4200 SUN N LAKE BLVD SEBRING FL 33871 HIGHLANDS (863) 314-4466 Acute Care Hospitals Voluntary non-profit - Church FALSE 27.5384550 -81.5068810 0   55 12 12055 42700   Central Highlands County https://data.medicare.gov/resource/xubh-q36u/row-kk9t~8fs5~ksmj 100109 661479 2019-11-26 2018-12-31 158 22         180 17             197
2954 ADVENTHEALTH SHAWNEE MISSION 9100 W 74TH STREET SHAWNEE MISSION KS 66204 JOHNSON (913) 676-2152 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.9951370 -94.6920400 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-uk59_btiw.yapj 170104 650698 2019-05-30 2018-12-31 259 28         323 42             365
2051 ADVENTHEALTH TAMPA 3100 E FLETCHER AVE TAMPA FL 33613 HILLSBOROUGH (813) 615-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.0692260 -82.4245250 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-zdje.si2f_dc2y 100173 656268 2019-10-28 2018-12-31 420 58         506   30           536
2394 ADVENTHEALTH WATERMAN 1000 WATERMAN WAY TAVARES FL 32778 LAKE (352) 253-3300 Acute Care Hospitals Voluntary non-profit - Church FALSE 28.8223510 -81.7102100 0   69 12 12069 36740 Orlando-Deltona-Daytona Beach, FL Outlying Lake County https://data.medicare.gov/resource/xubh-q36u/row-mktc_ayyy_878g 100057 650249 2019-05-31 2018-12-31 229   40       269               269
3195 ADVENTHEALTH WESLEY CHAPEL 2600 BRUCE B DOWNS BLVD WESLEY CHAPEL FL 33544 PASCO (813) 929-5490 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.1937180 -82.3534020 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-sagk_8pbp_32tr 100319 649426 2019-05-30 2018-12-31 121 24         145               145
3194 ADVENTHEALTH ZEPHYRHILLS 7050 GALL BLVD ZEPHYRHILLS FL 33541 PASCO (813) 788-0411 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.2609370 -82.1880410 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-5w9q_uu4q-aya6 100046 649408 2019-05-31 2018-12-31 135 14         149               149
4386 ADVENTIST BOLINGBROOK HOSPITAL 500 REMINGTON BOULEVARD BOLINGBROOK IL 60440 WILL (630) 312-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6793880 -88.0838830 0   197 17 17197 16980 Chicago-Naperville, IL-IN-WI Central Will County https://data.medicare.gov/resource/xubh-q36u/row-ymrs-ahsd~teyh 140304 649434 2019-05-31 2018-12-31 98 12         110 24             134
1688 ADVENTIST GLENOAKS 701 WINTHROP AVENUE GLENDALE HEIGHTS IL 60139 DU PAGE (630) 545-8000 Acute Care Hospitals Voluntary non-profit - Other FALSE 41.9151660 -88.0585970 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-x625-ypig_3gjv 140292 650258 2019-05-31 2018-12-31 112 10         122 16             138
3519 ADVENTIST HEALTH AND RIDEOUT 726 4TH ST MARYSVILLE CA 95901 YUBA (530) 749-4300 Acute Care Hospitals Government - Federal TRUE 39.1388320 -121.5936220 0   115 6 6115 49700 Sacramento-Roseville, CA Central Yuba County https://data.medicare.gov/resource/xubh-q36u/row-ena2_rmjt-rgun 50133 660916 2019-11-27 2019-06-30 179 24         209               209
1124 ADVENTIST HEALTH BAKERSFIELD 2615 CHESTER AVENUE BAKERSFIELD CA 93301 KERN (661) 395-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3830560 -119.0188570 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-siqs~heps~67ia 50455 649164 2019-05-31 2018-12-31 211 34         254               254
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
342 ADVENTIST HEALTH FEATHER RIVER 5974 PENTZ ROAD PARADISE CA 95969 BUTTE (530) 877-9361 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7561610 -121.5723050 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-dx3c~3bgg.9vjq 50225 659201 2019-05-31 2018-12-31                              
1200 ADVENTIST HEALTH HANFORD 115 MALL DRIVE HANFORD CA 93230 KINGS (209) 410-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3238770 -119.6690050 0   31 6 6031 25260 Visalia-Porterville-Hanford, CA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-gskm_spqc_qqn6 50121 649537 2019-05-31 2018-12-31 208 22         230               230
2595 ADVENTIST HEALTH LODI MEMORIAL 975 S FAIRMONT AVENUE LODI CA 95240 SAN JOAQUIN (209) 334-3411 Acute Care Hospitals Voluntary non-profit - Other FALSE 38.1216340 -121.2857870 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-ewtc_9ynj_9n73 50336 652390 2019-05-31 2018-12-31 172 10         182   8           190
1920 ADVENTIST HEALTH PORTLAND 10123 SE MARKET STREET PORTLAND OR 97216 MULTNOMAH (503) 257-2500 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.5115370 -122.5590930 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-zb4z~fv5p-q8sy 380060 649341 2019-05-30 2018-12-31 156 12         168 43             211
816 ADVENTIST HEALTH REEDLEY 372 W CYPRESS AVE REEDLEY CA 93654 FRESNO (559) 638-8155 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.6078120 -119.4516950 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-re3j_d2jv_jrs3 50192 659200 2019-05-31 2018-12-31 49           49               49
3417 ADVENTIST HEALTH SIMI VALLEY 2975 N SYCAMORE DR SIMI VALLEY CA 93065 VENTURA (805) 955-6000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2888370 -118.7439600 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-dj8u_rx6h_z8s8 50236 659202 2019-05-31 2018-12-31 112 24       8 144               144
3364 ADVENTIST HEALTH SONORA 1000 GREENLEY ROAD SONORA CA 95370 TUOLUMNE (209) 536-5000 Acute Care Hospitals Voluntary non-profit - Church FALSE 37.9767280 -120.3694420 0   109 6 6109 43760   Central Tuolumne County https://data.medicare.gov/resource/xubh-q36u/row-7tcs_nvgu-e2ik 50335 652417 2019-05-31 2018-12-31 78 6         84       68       152
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
3337 ADVENTIST HEALTH TULARE 869 NORTH CHERRY STREET TULARE CA 93274 TULARE (559) 688-0821 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.2202830 -119.3376690 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-tgyx_3sgg-28ve 50784 655533 2019-10-17 2019-03-14 94 14         108               108
1724 ADVENTIST HEALTH UKIAH VALLEY 275 HOSPITAL DRIVE UKIAH CA 95482 MENDOCINO (707) 462-3111 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1530190 -123.2038000 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-5xip-9esx.8u6b 50301 649538 2019-05-31 2018-12-31 42 6       2 50               50
1269 ADVENTIST HEALTHCARE SHADY GROVE MEDICAL CENTER 9901 MEDICAL CENTER DRIVE ROCKVILLE MD 20850 MONTGOMERY (240) 826-6527 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0980460 -77.2010270 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-z5ai-uwvz~ja8i 210057 649038 2019-05-31 2018-12-31 280 27         338               338
1275 ADVENTIST HEALTHCARE WHITE OAK MEDICAL CENTER 12100 PLUM ORCHARD DRIVE SILVER SPRING MD 20904 MONTGOMERY (301) 891-5651 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0522630 -76.9582320 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-tb4c-cc68.vyas 210016 649036 2019-05-31 2018-12-31 172 26         198               198
1690 ADVENTIST HINSDALE HOSPITAL 120 NORTH OAK ST HINSDALE IL 60521 DU PAGE (630) 856-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8053290 -87.9200620 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-phw9~utfn-hiet 140122 649893 2019-05-30 2018-12-31 186 58         244 17             261
1263 ADVENTIST LA GRANGE MEMORIAL HOSPITAL 5101 S WILLOW SPRINGS RD LA GRANGE IL 60525 COOK (708) 352-1200 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.7973820 -87.8884070 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-7py8-axpr_w3jk 140065 649432 2019-05-30 2018-12-31 132 27         159   17           176
3464 ADVOCATE BROMENN MEDICAL CENTER 1304 FRANKLIN AVENUE NORMAL IL 61761 MC LEAN (309) 454-1400 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.4963320 -88.9909600 0   113 17 17113 14010 Bloomington-Pontiac, IL Central McLean County https://data.medicare.gov/resource/xubh-q36u/row-yyk7.wts2-z6re 140127 650688 2019-05-30 2018-12-31 176 30         206   15           221
1262 ADVOCATE CHRIST HOSPITAL & MEDICAL CENTER 4440 W 95TH STREET OAK LAWN IL 60453 COOK (708) 684-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.7203160 -87.7323640 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-q7d7-qtfa_384z 140208 650691 2019-05-30 2018-12-31 524 123         706 34 37           777
3090 ADVOCATE CONDELL MEDICAL CENTER 801 S MILWAUKEE AVE LIBERTYVILLE IL 60048 LAKE (847) 362-2900 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2745630 -87.9516500 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-ggn7-qxdn_2hfk 140202 650690 2019-05-30 2018-12-31 256 17         273               273
1685 ADVOCATE GOOD SAMARITAN HOSPITAL 3815 HIGHLAND AVENUE DOWNERS GROVE IL 60515 DU PAGE (630) 275-5900 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.8191370 -88.0102200 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-sbtc.2xfq-guy4 140288 649433 2019-06-11 2018-12-31 188 55         243 41             284
3091 ADVOCATE GOOD SHEPHERD HOSPITAL 450 WEST HIGHWAY 22 BARRINGTON IL 60010 LAKE (847) 381-9600 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.1934150 -88.1779590 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-89k4.jid2~5ddd 140291 649723 2019-05-30 2018-12-31 144 32         176               176
1257 ADVOCATE ILLINOIS MASONIC MEDICAL CENTER 836 WEST WELLINGTON AVENUE CHICAGO IL 60657 COOK (773) 975-1600 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9363150 -87.6515540 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-f4m5.ndmq~4y5c 140182 650124 2019-05-31 2018-12-31 137 74 43       254 35 22           311
1260 ADVOCATE LUTHERAN GENERAL HOSPITAL 1775 DEMPSTER ST PARK RIDGE IL 60068 COOK (847) 723-2210 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0397480 -87.8481460 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-d64d-m4ex~7p9f 140223 650693 2019-05-30 2018-12-31 415 33 32       534 50 45           629
1264 ADVOCATE SOUTH SUBURBAN HOSPITAL 17800 S KEDZIE AVE HAZEL CREST IL 60429 COOK (708) 799-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.5669220 -87.6943990 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-qvb6.mvan.67p8 140250 650695 2019-05-30 2018-12-31 213 20         233               233
8 ADVOCATE TRINITY HOSPITAL 2320 E 93RD ST CHICAGO IL 60617 COOK (773) 967-5002 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.7262110 -87.5672500 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-wz9w.j9tr_sabj 140048 650686 2019-05-30 2018-12-31 177 24         201               201
2102 AHMC ANAHEIM REGIONAL MEDICAL CENTER 1111 W LA PALMA AVENUE ANAHEIM CA 92801 ORANGE (714) 774-1450 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8471380 -117.9339340 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-r3zf-f22h~mx8e 50226 661286 2019-12-02 2019-06-30 180 32         223               223
242 AIKEN REGIONAL MEDICAL CENTER 302 UNIVERSITY PARKWAY AIKEN SC 29801 AIKEN (803) 641-5900 Acute Care Hospitals Proprietary TRUE 33.5698900 -81.7650710 0   3 45 45003 12260   Central Aiken County https://data.medicare.gov/resource/xubh-q36u/row-2jsk_ph6i-gvkj 420082 648759 2019-05-29 2018-12-31 169 35         204 48 14           266
4064 AKRON GENERAL MEDICAL CENTER 1 AKRON GENERAL AVENUE AKRON OH 44307 SUMMIT (330) 344-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0778590 -81.5327870 0   153 39 39153 10420 Cleveland-Akron-Canton, OH Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-fwyk~yqdc~my3b 360027 660664 2019-11-25 2018-12-31 315 34 34       383 53             436
115 ALAMANCE REGIONAL MEDICAL CENTER 1240 HUFFMAN MILL RD BURLINGTON NC 27216 ALAMANCE (336) 538-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0637490 -79.5025280 0   1 37 37001 15500 Greensboro--Winston-Salem--High Point, NC Central Alamance County https://data.medicare.gov/resource/xubh-q36u/row-x8vw.bx9c.7dbj 340070 643428 2019-02-27 2018-09-30 144 20         176 36             212
49 ALAMEDA HOSPITAL 2070 CLINTON AVENUE ALAMEDA CA 94501 ALAMEDA (510) 522-3700 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7632300 -122.2535410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-aten_zvra_dnju 50211 662328 2018-12-03 2018-06-30 29   5       34       181       215
873 ALASKA NATIVE MEDICAL CENTER 4315 DIPLOMACY DR ANCHORAGE AK 99508 ANCHORAGE (907) 729-3971 Acute Care Hospitals Government - Federal TRUE 61.1818900 -149.8005780 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-5h7d.5evj.yxgq 20026 651310 2019-07-01 2018-09-30 173         1 174               174
874 ALASKA REGIONAL HOSPITAL 2801 DEBARR ROAD ANCHORAGE AK 99508 ANCHORAGE (907) 276-1131 Acute Care Hospitals Proprietary TRUE 61.2097900 -149.8273790 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-727e.rn52.9kni 20017 662304 2019-12-09 2018-12-31 127 14 13       164   10           174
114 ALBANY MEDICAL CENTER HOSPITAL 43 NEW SCOTLAND AVENUE, MAIL CODE 34 ALBANY NY 12208 ALBANY (518) 262-2400 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6532540 -73.7738600 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-sggw.e236~c5a3 330013 649473 2019-05-29 2018-12-31 585 65 17     60 747 26 20           793
112 ALBANY MEMORIAL HOSPITAL 600 NORTHERN BOULEVARD ALBANY NY 12204 ALBANY (518) 471-3490 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6746850 -73.7488610 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-fbeu-trch-uemx 330003 661359 2019-11-27 2019-06-30 57 16         73               73
3223 ALBERT EINSTEIN MEDICAL CENTER 5501 OLD YORK ROAD PHILADELPHIA PA 19141 PHILADELPHIA (215) 456-6090 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.0369270 -75.1446830 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-y25a_nm4t_83u2 390142 658762 2019-11-12 2019-06-30 336 32 16     23 407 47 199   44       697
1236 ALEXIAN BROTHERS MEDICAL CENTER 1 800 W BIESTERFIELD RD ELK GROVE VILLAGE IL 60007 COOK (847) 437-5500 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0037050 -88.0149960 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-22rs-enea-7d2m 140258 660521 2019-11-27 2019-06-30 221 36         257 25 72       16   370
1518 ALHAMBRA HOSPITAL MEDICAL CENTER 100 S RAYMOND AVE ALHAMBRA CA 91801 LOS ANGELES (626) 570-1606 Acute Care Hospitals Proprietary FALSE 34.0901560 -118.1450170 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-75jx-8uav_n2er 50281 660918 2019-12-02 2019-06-30 88 13         101   17   26       144
1348 ALICE HYDE MEDICAL CENTER 133 PARK STREET MALONE NY 12953 FRANKLIN (518) 483-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.8566580 -74.2919300 0   33 36 36033 31660   Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-493x~ftr5.jry8 330084 651569 2019-06-27 2018-09-30 43 5         48       135   30   213
235 ALLEGHENY GENERAL HOSPITAL 320 EAST NORTH AVENUE PITTSBURGH PA 15212 ALLEGHENY (412) 359-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4561490 -80.0032490 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-8eek-ck8y_3ey7 390050 661092 2019-12-02 2019-06-30 430 28 24   24 24 552               552
224 ALLEGHENY VALLEY HOSPITAL 1301 CARLISLE ST NATRONA PA 15065 ALLEGHENY (412) 224-5100 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.6173780 -79.7371060 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-4dpd~v2eh.sr63 390032 660011 2019-12-02 2019-06-30 127 16         143 40 17           200
601 ALLEN HOSPITAL 1825 LOGAN AVENUE WATERLOO IA 50703 BLACK HAWK (319) 235-3941 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5257530 -92.3377580 0   13 19 19013 47940   Central Black Hawk County https://data.medicare.gov/resource/xubh-q36u/row-ffm4.rxar_ycnb 160110 650262 2019-06-04 2018-12-31 168 12         187   12           199
174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
4047 ALLIANCE COMMUNITY HOSPITAL 200 EAST STATE STREET ALLIANCE OH 44601 STARK (330) 596-7018 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.9016790 -81.1027360 0   151 39 39151 15940 Cleveland-Akron-Canton, OH Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-9pb7.6hrh_xxpz 360131 649642 2019-06-03 2018-12-31 43 12         55 12     78       145
2576 ALLIANCE HEALTH CENTER 5000 HIGHWAY 39 NORTH MERIDIAN MS 39301 LAUDERDALE (601) 483-6211 Acute Care Hospitals Proprietary FALSE 32.4099880 -88.6788110 0   75 28 28075 32940   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-u23i_wk6s_4s84 250151 649279 2019-05-29 2018-12-31 83           83 71         60   214
3000 ALLIANCE HEALTHCARE SYSTEM 1430 HIGHWAY 4 EAST / P O BOX 6000 HOLLY SPRINGS MS 38635 MARSHALL (662) 252-1212 Acute Care Hospitals Physician TRUE 34.7868350 -89.4150270 0   93 28 28093 32820 Memphis-Forrest City, TN-MS-AR Outlying Marshall County https://data.medicare.gov/resource/xubh-q36u/row-zg7w-9rxd.iyxq 250012 648706 2019-06-04 2018-12-31 27           27 13             40
1607 ALLIANCEHEALTH CLINTON 100 NORTH 30TH STREET CLINTON OK 73601 CUSTER (580) 323-2363 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.5147890 -98.9968790 0   39 40 40039 48220   Central Custer County https://data.medicare.gov/resource/xubh-q36u/row-dvix_7ap3~spry 370029 653451 2019-08-30 2019-03-31 41 4         45   11           56
642 ALLIANCEHEALTH DURANT 1800 UNIVERSITY BOULEVARD DURANT OK 74702 BRYAN (405) 924-3080 Acute Care Hospitals Proprietary TRUE 34.0049030 -96.3950550 0   13 40 40013 20460 Dallas-Fort Worth, TX-OK Central Bryan County https://data.medicare.gov/resource/xubh-q36u/row-96gx.9gst_7qhe 370014 646932 2019-04-03 2018-09-30 132 8         140               140
3389 ALLIANCEHEALTH MIDWEST 2825 PARKLAWN DRIVE MIDWEST CITY OK 73110 OKLAHOMA (405) 610-8585 Acute Care Hospitals Proprietary TRUE 35.4665270 -97.3929250 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-sxg9_cifn-7qv9 370094 660692 2019-11-26 2019-06-30 212 24         236 19             255
2482 ALLIANCEHEALTH PONCA CITY 1900 NORTH 14TH STREET PONCA CITY OK 74601 KAY (580) 765-3301 Acute Care Hospitals Proprietary TRUE 36.7240880 -97.0672810 0   71 40 40071 38620   Central Kay County https://data.medicare.gov/resource/xubh-q36u/row-t7iq-uqd6~3p36 370006 656720 2019-11-01 2019-05-31 38 10         48               48
3350 ALLIANCEHEALTH SEMINOLE 2401 WRANGLER BOULEVARD SEMINOLE OK 74868 SEMINOLE (405) 303-4050 Acute Care Hospitals Proprietary TRUE 35.2464640 -96.6990130 0   133 40 40133         https://data.medicare.gov/resource/xubh-q36u/row-t47q~8ahq-97c8 370229 654158 2019-09-13 2019-03-31 32           32               32
4069 ALLIANCEHEALTH WOODWARD 900 17TH STREET WOODWARD OK 73801 WOODWARD (580) 254-8492 Acute Care Hospitals Proprietary TRUE 36.4378610 -99.4009540 0   153 40 40153 49260   Central Woodward County https://data.medicare.gov/resource/xubh-q36u/row-xvc5-zx2v~yrxt 370002 659337 2019-11-07 2019-05-31 34 6         40               40
1650 ALOMERE HEALTH 111 17TH AVENUE EAST ALEXANDRIA MN 56308 DOUGLAS (320) 762-1511 Acute Care Hospitals Government - Local TRUE 45.8726690 -95.3763800 0   41 27 27041 10820   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-psb9.f8hy_pu25 240030 649757 2019-05-30 2018-12-31 91 8         99               99
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
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
1442 ALTA VIEW HOSPITAL 9660 SOUTH 1300 EAST SANDY UT 84094 SALT LAKE (801) 501-2600 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5773600 -111.8531910 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-pdbj~gdsf_6jmr 460044 648659 2019-05-17 2018-12-31 54 4         58               58
1797 ALTA VISTA REGIONAL HOSPITAL 104 LEGION DRIVE LAS VEGAS NM 87701 SAN MIGUEL (505) 426-3930 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.6221500 -105.2098510 0   47 35 35047 29780 Albuquerque-Santa Fe-Las Vegas, NM Central San Miguel County https://data.medicare.gov/resource/xubh-q36u/row-eqjk~u8wz_58xt 320003 657378 2019-08-22 2018-08-31 38 8         46               46
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
1406 ALTRU HOSPITAL 1200 S COLUMBIA RD GRAND FORKS ND 58201 GRAND FORKS (701) 780-5000 Acute Care Hospitals Government - Local TRUE 47.9105352 -97.0681107 1 ROOFTOP 35 38 38035 24220   Central Grand Forks County https://data.medicare.gov/resource/xubh-q36u/row-tfgh.9uft~bxhm 350019 650883 2019-06-03 2018-12-31 245 16     10   271   23           294

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