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

4,766 rows sorted by acute_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
2076 2076 RUBY VALLEY MEDICAL CENTER 321 MADISON ST SHERIDAN MT 59749 MADISON (406) 842-5453 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.4525850 -112.1914530 0   57 30 30057         https://data.medicare.gov/resource/xubh-q36u/row-w73r_tdsp_m6z4 271319 647382 2019-04-29 2018-10-31 10           10               10
2240 2240 SENECA DISTRICT HOSPITAL 130 BRENTWOOD DRIVE CHESTER CA 96020 PLUMAS (530) 258-2121 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.3053020 -121.2340180 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-6rw5.c6e6.9puv 51327 661143 2019-12-02 2019-06-30 10           10       16       26
2405 2405 REGIONAL WEST GARDEN COUNTY HOSPITAL 1100 WEST 2ND ST OSHKOSH NE 69154 GARDEN (308) 772-3283 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4124850 -102.3475730 0   69 31 31069         https://data.medicare.gov/resource/xubh-q36u/row-ak6k-74t4-rjik 281310 649128 2019-05-30 2018-12-31 10           10           40   50
2532 2532 MONROE SURGICAL HOSPITAL 2408 BROADMOOR BLVD MONROE LA 71201 OUACHITA (318) 410-0002 Acute Care Hospitals Physician FALSE 32.5367710 -92.1022040 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk 190245 650140 2019-06-03 2018-12-31 10           10               10
2602 2602 POWER COUNTY HOSPITAL DISTRICT 510 ROOSEVELT STREET AMERICAN FALLS ID 83211 POWER (208) 226-3200 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.7818580 -112.8490470 0   77 16 16077         https://data.medicare.gov/resource/xubh-q36u/row-jqyn~uieu.hqrg 131304 645328 2019-03-20 2018-09-30 10           10       16       26
2773 2773 BELLIN HEALTH OCONTO HOSPITAL 820 ARBUTUS AVE OCONTO WI 54153 OCONTO (920) 835-1101 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.8968910 -87.8671870 0   83 55 55083 24580 Green Bay-Shawano, WI Outlying Oconto County https://data.medicare.gov/resource/xubh-q36u/row-txia-if9r.5nnj 521356 645518 2019-03-18 2018-09-30 10           10               10
2806 2806 EDGEWOOD SURGICAL HOSPITAL 239 EDGEWOOD DRIVE EXTENSION TRANSFER PA 16154 MERCER (724) 646-0400 Acute Care Hospitals Physician FALSE 41.3300510 -80.4178550 0   85 42 42085 49660 Youngstown-Warren, OH-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-rh2b~kawm~nsdh 390307 649489 2019-05-30 2018-12-31 10           10               10
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
2880 2880 PATIENTS' HOSPITAL OF REDDING 2900 EUREKA WAY REDDING CA 96001 SHASTA (530) 225-8700 Acute Care Hospitals Physician FALSE 40.5854900 -122.4162640 0   89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-5vur~pqci_pq3w 50697 650657 2019-05-31 2018-12-31 10           10               10
3171 3171 KEARNEY COUNTY HEALTH SERVICES HOSPITAL 727 EAST 1ST ST MINDEN NE 68959 KEARNEY (308) 832-3400 Critical Access Hospitals Government - Local TRUE 40.4957780 -98.9432030 0   99 31 31099 28260   Outlying Kearney County https://data.medicare.gov/resource/xubh-q36u/row-aaj3.vtp7.jy9v 281306 654341 2019-09-09 2019-06-30 10           10               10
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
3268 3268 STERLING SURGICAL HOSPITAL 989 ROBERT BLVD SLIDELL LA 70458 ST. TAMMANY (504) 690-8200 Acute Care Hospitals Proprietary FALSE 30.2907800 -89.7694020 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-w5g7~ffzq.fcn6 190256 647895 2019-05-17 2018-12-31 10           10               10
3310 3310 LINCOLN COUNTY HOSPITAL 624 N SECOND LINCOLN KS 67455 LINCOLN (785) 524-4403 Critical Access Hospitals Government - Local FALSE 39.0451750 -98.1443700 0   105 20 20105         https://data.medicare.gov/resource/xubh-q36u/row-teha_g9nc~sv4a 171360 654126 2019-09-04 2019-03-31 10           10               10
3356 3356 AVERA GETTYSBURG HOSPITAL 606 EAST GARFIELD GETTYSBURG SD 57442 POTTER (605) 765-2480 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.0135510 -99.9481280 0   107 46 46107         https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p 431302 660878 2019-12-02 2019-06-30 10           10           50   60
3402 3402 OKLAHOMA CENTER FOR ORTHOPAEDIC & MULTI-SP 8100 SOUTH WALKER BLDG C OKLAHOMA CITY OK 73139 OKLAHOMA (405) 602-6500 Acute Care Hospitals Proprietary FALSE 35.3856890 -97.5212710 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-nigy_87dp_gajj 370212 650200 2019-06-18 2018-12-31 10           10               10
3424 3424 MERCY HARVARD HOSPITAL 901 S GRANT STREET HARVARD IL 60033 MC HENRY (815) 943-5431 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4259920 -88.6077480 0   111 17 17111 16980 Chicago-Naperville, IL-IN-WI Central McHenry County https://data.medicare.gov/resource/xubh-q36u/row-kww9-q8j9_zquu 141335 661880 2019-12-06 2019-06-30 10 3         13       15   30   58
3530 3530 ST LUKE HOSPITAL & LIVING CENTER 535 SOUTH FREEBORN MARION KS 66861 MARION (620) 382-2177 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3427080 -97.0100140 0   115 20 20115         https://data.medicare.gov/resource/xubh-q36u/row-uqvu-kkp6-ivun 171356 645551 2019-03-05 2018-09-30 10           10           32   42
3815 3815 SYRACUSE AREA HEALTH 2731 HEALTHCARE DR SYRACUSE NE 68446 OTOE (402) 269-2011 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6770233 -96.1814653 1 ROOFTOP 131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-e4xn-76tv~ys3t 281309 658943 2019-11-11 2019-06-30 10           10               10
3989 3989 KINGS DAUGHTERS MEDICAL CENTER OHIO 1901 ARGONNE ROAD PORTSMOUTH OH 45662 SCIOTO (740) 991-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7473190 -82.9933540 0   145 39 39145 39020 Charleston-Huntington-Ashland, WV-OH-KY Central Scioto County https://data.medicare.gov/resource/xubh-q36u/row-3hvz~qivd_yj54 360361 644543 2019-02-28 2018-09-30 10           10               10
4077 4077 SUMMIT SURGICAL, LLC 1818 EAST 23RD AVENUE HUTCHINSON KS 67502 RENO (620) 662-6000 Acute Care Hospitals Physician FALSE 38.0795300 -97.8885950 0   155 20 20155 26740   Central Reno County https://data.medicare.gov/resource/xubh-q36u/row-rrpw.z43u-xa5d 170198 649226 2019-05-30 2018-12-31 10           10               10
4240 4240 UNICOI COUNTY HOSPITAL 2030 TEMPLE HILL ROAD ERWIN TN 37650 UNICOI (423) 743-3141 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1213650 -82.4456210 0   171 47 47171 27740 Johnson City-Kingsport-Bristol, TN-VA Outlying Unicoi County https://data.medicare.gov/resource/xubh-q36u/row-8b8j.szqj-76se 440001 649955 2019-05-28 2018-12-31 10           10       7 39     56
4588 4588 MEMORIAL HERMANN SURGICAL HOSPITAL KINGWOOD 300 KINGWOOD MEDICAL DRIVE KINGWOOD TX 77339 HARRIS (281) 312-4000 Acute Care Hospitals Proprietary TRUE 30.0471980 -95.2579490 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-v6he.gqvr.a5ws 670005 648513 2019-05-21 2018-12-31 10           10               10
81 81 HALE HO'OLA HAMAKUA 45-547 PLUMERIA STREET HONOKAA HI 96727 HAWAII (808) 932-4100 Critical Access Hospitals Government - State TRUE 20.0762710 -155.4705950 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-z9jm-2idi-sq3z 121307 640366 2018-12-03 2018-06-30 11           11       66       77
184 184 MUNISING MEMORIAL HOSPITAL 1500 SAND POINT RD MUNISING MI 49862 ALGER (906) 387-4110 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4238490 -86.6257160 0   3 26 26003         https://data.medicare.gov/resource/xubh-q36u/row-7pqa.fabg.y26z 231308 654139 2019-09-04 2019-03-31 11           11               11
346 346 PAGOSA SPRINGS MEDICAL CENTER 95 SOUTH PAGOSA BOULEVARD PAGOSA SPRINGS CO 81147 ARCHULETA (970) 731-3700 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2527760 -107.0772190 0   7 8 8007         https://data.medicare.gov/resource/xubh-q36u/row-j5fe.jwy4~ejt9 61328 654714 2019-09-26 2018-12-31 11           11               11
396 396 CONFLUENCE HEALTH- WENATCHEE VALLEY HOSP & CLINICS 820 NORTH CHELAN AVENUE WENATCHEE WA 98801 CHELAN (509) 663-8711 Acute Care Hospitals Voluntary non-profit - Private FALSE 47.4335660 -120.3219830 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-aiqi_mn7n_vecf 500148 650791 2019-05-31 2018-12-31 11           11   9           20
728 728 KEEFE MEMORIAL HOSPITAL 602 N 6TH W ST CHEYENNE WELLS CO 80810 CHEYENNE (719) 767-5661 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.8258870 -102.3555830 0   17 8 8017         https://data.medicare.gov/resource/xubh-q36u/row-tagv~57dn~4tm7 61343 649879 2019-05-29 2018-12-31 11           11               11
914 914 MOUNT GRANT GENERAL HOSPITAL 200 SOUTH A ST HAWTHORNE NV 89415 MINERAL (702) 945-2461 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.5166320 -118.6284520 0   21 32 32021         https://data.medicare.gov/resource/xubh-q36u/row-dzph~qsgj~bgaf 291300 652888 2018-12-04 2018-06-30 11           11       24       35
1355 1355 REGIONAL HEALTH CUSTER HOSPITAL 1220 MONTGOMERY STREET CUSTER SD 57730 CUSTER (605) 673-9400 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7728160 -103.5911730 0   33 46 46033 39660 Rapid City-Spearfish, SD Outlying Custer County https://data.medicare.gov/resource/xubh-q36u/row-ce9i_v2bn~dsgz 431323 659361 2019-11-20 2019-06-30 11           11       76       87
1404 1404 BLUE MOUNTAIN HOSPITAL 802 SOUTH 200 WEST BLANDING UT 84511 SAN JUAN (435) 678-3993 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.6144490 -109.4815440 0   37 49 49037         https://data.medicare.gov/resource/xubh-q36u/row-fzdn.n6iq~872c 461310 644671 2019-02-27 2018-09-30 11           11               11
1710 1710 DOUGLAS COUNTY MEMORIAL HOSPITAL-CAH 708 8TH ST ARMOUR SD 57313 DOUGLAS (605) 724-2159 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3248250 -98.3448240 0   43 46 46043         https://data.medicare.gov/resource/xubh-q36u/row-pg2t_pahj-3xcd 431305 656756 2019-11-05 2019-05-31 11           11               11
1913 1913 SIERRA VISTA HOSPITAL 800 EAST 9TH AVENUE T OR C NM 87901 SIERRA (575) 894-2111 Critical Access Hospitals Government - Local TRUE 33.1391040 -107.2419750 0   51 35 35051         https://data.medicare.gov/resource/xubh-q36u/row-4i26.fnpx~4q9x 321300 654972 2019-10-11 2019-06-30 11           11               11
1950 1950 DECATUR COUNTY HOSPITAL 1405 NW CHURCH STREET LEON IA 50144 DECATUR (641) 446-4871 Critical Access Hospitals Government - Local TRUE 40.7503080 -93.7477890 0   53 19 19053         https://data.medicare.gov/resource/xubh-q36u/row-z8pk.dm9q_4faw 161340 660972 2019-12-02 2019-06-30 11           11               11
2211 2211 MOUNTRAIL COUNTY MEDICAL CENTER INC 615 6TH ST SE STANLEY ND 58784 MOUNTRAIL (701) 628-2424 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3125040 -102.3808690 0   61 38 38061         https://data.medicare.gov/resource/xubh-q36u/row-b8p8-yzkh-reuy 351301 659831 2019-11-22 2019-06-30 11           11               11
2320 2320 NELL J REDFIELD MEMORIAL HOSPITAL 150 NORTH 200 WEST MALAD ID 83252 ONEIDA (208) 766-2231 Critical Access Hospitals Government - Local TRUE 42.1896380 -112.2507590 0   71 16 16071         https://data.medicare.gov/resource/xubh-q36u/row-dtun.jgpu~2hmu 131303 662195 2019-11-26 2019-06-30 11           11       33       44
2736 2736 SANTA YNEZ VALLEY COTTAGE HOSPITAL 2050 VIBORG RD SOLVANG CA 93463 SANTA BARBARA (805) 688-6431 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6024650 -120.1266430 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-crjd-giis~8ixz 51331 648601 2019-05-31 2018-12-31 11           11               11
2768 2768 SANFORD CANTON-INWOOD MEDICAL CENTER - CAH 440 NORTH HIAWATHA DRIVE CANTON SD 57013 LINCOLN (605) 764-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3049440 -96.5572490 0   83 46 46083 43620   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-drz2_z7zb-tas3 431333 648483 2019-05-23 2018-12-31 11           11               11
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
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
4679 4679 MCCAMEY HOSPITAL 2500 HWY 305 SOUTH MCCAMEY TX 79752 UPTON (432) 652-8626 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.1145414 -102.2102683 1 ROOFTOP 461 48 48461         https://data.medicare.gov/resource/xubh-q36u/row-ezrc~bqk8~d5gy 451309 643464 2019-02-22 2018-09-30 11           11               11
129 129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
130 130 BROADDUS HOSPITAL ASSOCIATION, INC 1 HEALTHCARE DRIVE MANSFIELD HILL PHILIPPI WV 26416 BARBOUR (304) 457-1760 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1528870 -80.0440910 0   1 54 54001         https://data.medicare.gov/resource/xubh-q36u/row-njqv~ij6d.yec2 511300 650429 2019-05-31 2018-12-31 12           12       60       72
172 172 ANDERSON COUNTY HOSPITAL 421 S MAPLE GARNETT KS 66032 ANDERSON (785) 204-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.2801200 -95.2493000 0   3 20 20003         https://data.medicare.gov/resource/xubh-q36u/row-3ktx.x5ze~zgrj 171316 648620 2019-05-24 2018-12-31 12           12           36   48
221 221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
252 252 NORTH BIG HORN HOSPITAL DISTRICT 1115 LANE 12 LOVELL WY 82431 BIG HORN (307) 548-5200 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.8257990 -108.3906880 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-s9vd~bscy-xn2k 531309 662633 2019-11-27 2019-06-30 12           12       85       97
878 878 HUHU KAM MEMORIAL HOSPITAL 483 WEST SEED FARM ROAD SACATON AZ 85147 PINAL (520) 562-3321 Critical Access Hospitals Government - Federal TRUE 33.0741220 -111.7590800 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-fpem.7xy6-nzbf 31308 645965 2019-03-28 2018-09-30 12           12               12
928 928 TRISTAR ASHLAND CITY MEDICAL CENTER 313 NORTH MAIN ST ASHLAND CITY TN 37015 CHEATHAM (615) 792-3030 Critical Access Hospitals Proprietary TRUE 36.2769740 -87.0659760 0   21 47 47021 34980 Nashville-Davidson--Murfreesboro, TN Outlying Cheatham County https://data.medicare.gov/resource/xubh-q36u/row-dctd_vqeq_ijzv 441311 655652 2019-10-30 2019-05-31 12           12               12
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
1407 1407 NORTHWOOD DEACONESS HEALTH CENTER PO BOX 190 NORTHWOOD ND 58267 GRAND FORKS (701) 587-6060 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.7343845 -97.5683593 1 ROOFTOP 35 38 38035 24220   Central Grand Forks County https://data.medicare.gov/resource/xubh-q36u/row-r4gy_k4h8~nujf 351312 646643 2019-04-15 2018-12-31 12           12       45       57
1654 1654 CALLAWAY DISTRICT HOSPITAL P O BOX 100, 211 E KIMBALL CALLAWAY NE 68825 CUSTER (308) 836-2228 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.2909887 -99.9242095 1 ROOFTOP 41 31 31041         https://data.medicare.gov/resource/xubh-q36u/row-nfg8_ccxm-ja7t 281335 660412 2019-01-02 2018-07-31 12           12               12
1726 1726 GRAND RIVER MEDICAL CENTER 501 AIRPORT RD RIFLE CO 81650 GARFIELD (970) 625-1510 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.5225870 -107.7720100 0   45 8 8045 24060 Edwards-Glenwood Springs, CO Central Garfield County https://data.medicare.gov/resource/xubh-q36u/row-gvuq~c8qg.v3zk 61317 649076 2019-05-23 2018-12-31 12           12       49       61
1764 1764 BOWDLE HOSPITAL - CAH 8001 W 5TH POST OFFICE BOX 556 BOWDLE SD 57428 EDMUNDS (605) 285-6146 Critical Access Hospitals Government - Local TRUE 45.4480531 -99.6609364 1 ROOFTOP 45 46 46045 10100   Outlying Edmunds County https://data.medicare.gov/resource/xubh-q36u/row-q6h5.bajv_fkde 431318 637935 2018-11-26 2018-06-30 12           12       34       46
1770 1770 WESTON COUNTY HEALTH SERVICES 1124 WASHINGTON BOULEVARD NEWCASTLE WY 82701 WESTON (307) 746-4491 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.8487470 -104.1887560 0   45 56 56045         https://data.medicare.gov/resource/xubh-q36u/row-jibn-3jkh~ba9g 531303 640299 2018-12-03 2018-06-30 12           12       58       70
1780 1780 EDWARDS COUNTY HOSPITAL 620 WEST EIGHTH STREET KINSLEY KS 67547 EDWARDS (620) 659-3621 Critical Access Hospitals Government - Local TRUE 37.9207150 -99.4194310 0   47 20 20047         https://data.medicare.gov/resource/xubh-q36u/row-g83e~5vmg-b2c4 171317 648916 2019-05-28 2018-12-31 12           12 10             22
1794 1794 GOTHENBURG MEMORIAL HOSPITAL 910 20TH ST GOTHENBURG NE 69138 DAWSON (308) 537-3661 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9381320 -100.1533520 0   47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dgzd-a44k.k83g 281313 661037 2019-12-02 2019-06-30 12           12               12
1863 1863 WOODS AT PARKSIDE,THE 349 OLDE RIDENOUR ROAD COLUMBUS OH 43230 FRANKLIN (614) 471-2552 Acute Care Hospitals Proprietary FALSE 40.0268200 -82.8811560 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-4avu~kmf5~3quj 360247 649648 2019-06-03 2018-12-31 12         38 50               50
1874 1874 FAULKTON AREA MEDICAL CENTER 1300 OAK STREET POST OFFICE BOX 100 FAULKTON SD 57438 FAULK (605) 598-6262 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.0299990 -99.1315700 0   49 46 46049         https://data.medicare.gov/resource/xubh-q36u/row-9wwa-ei6u.pihr 431301 646881 2019-04-25 2018-12-31 12           12               12
2255 2255 JEFFERSON COUNTY HOSPITAL 870 S MAIN FAYETTE MS 39069 JEFFERSON (601) 786-3401 Acute Care Hospitals Government - Local TRUE 31.7048425 -91.0685345 1 ROOFTOP 63 28 28063         https://data.medicare.gov/resource/xubh-q36u/row-6ixf.trx6_t5pg 250060 644298 2019-03-04 2018-09-30 12           12 18             30
2341 2341 ANIMAS SURGICAL HOSPITAL, LLC 575 RIVERGATE LN DURANGO CO 81301 LA PLATA (970) 247-3537 Acute Care Hospitals Physician TRUE 37.2488890 -107.8707740 0   67 8 8067 20420   Central La Plata County https://data.medicare.gov/resource/xubh-q36u/row-twp9-b345.bypu 60117 650115 2019-05-31 2018-12-31 12           12               12
2498 2498 UAB CALLAHAN EYE HOSPITAL AUTHORITY 1720 UNIVERSITY BLVD, SUITE 500 BIRMINGHAM AL 35233 JEFFERSON (205) 325-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5031370 -86.8024010 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-txeu_r7zi.ibaa 10018 644082 2019-03-01 2018-09-30 12           12               12
2537 2537 MADISON HOSPITAL 820 THIRD AVENUE MADISON MN 56256 LAC QUI PARLE (320) 598-7536 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.0166350 -96.1887820 0   73 27 27073         https://data.medicare.gov/resource/xubh-q36u/row-dn7z_rt9e.ipjw 241372 645272 2019-02-27 2018-09-30 12           12       65       77
2790 2790 HOLTON COMMUNITY HOSPITAL 1110 COLUMBINE DRIVE HOLTON KS 66436 JACKSON (785) 364-2116 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4794640 -95.7509080 0   85 20 20085 45820   Outlying Jackson County https://data.medicare.gov/resource/xubh-q36u/row-8a8r_8yba-yt3v 171319 653242 2019-08-21 2019-03-31 12           12               12
2802 2802 STANDING ROCK INDIAN HEALTH SERVICE HOSPITAL 10 NORTH RIVER ROAD FORT YATES ND 58538 SIOUX (701) 854-3831 Acute Care Hospitals Government - Federal TRUE 46.0952325 -100.6281136 1 ROOFTOP 85 38 38085 13900   Outlying Sioux County https://data.medicare.gov/resource/xubh-q36u/row-a84q-rj3h~6yed 350064 651228 2019-06-18 2018-09-30 12           12               12
2908 2908 NORTH VALLEY HEALTH CENTER 300 WEST GOOD SAMARITAN DRIVE WARREN MN 56762 MARSHALL (218) 745-4211 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1927360 -96.7743980 0   89 27 27089         https://data.medicare.gov/resource/xubh-q36u/row-5hr9-apeq-pgtf 241337 651012 2019-06-04 2018-12-31 12           12               12
2947 2947 KANSAS CITY ORTHOPAEDIC INSTITUTE 3651 COLLEGE BLVD LEAWOOD KS 66211 JOHNSON (913) 319-7633 Acute Care Hospitals Physician FALSE 38.9275490 -94.6282350 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-s6dg~iufq_ybuc 170188 649225 2019-05-31 2018-12-31 12           12               12
2967 2967 PHYSICIAN'S CARE SURGICAL HOSPITAL 454 ENTERPRISE DRIVE ROYERSFORD PA 19468 MONTGOMERY (610) 495-4793 Acute Care Hospitals Physician FALSE 40.2167860 -75.5537070 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-xf95-5spw~uirp 390324 646044 2019-04-01 2018-10-31 12           12               12
3159 3159 OSWEGO COMMUNITY HOSPITAL 800 BARKER DRIVE OSWEGO KS 67356 LABETTE (620) 795-2921 Critical Access Hospitals Proprietary TRUE 37.1596730 -95.1107700 0   99 20 20099 37660   Central Labette County https://data.medicare.gov/resource/xubh-q36u/row-r8kw_57qd_r6fs 171302 643032 2019-01-29 2018-09-30 12           12               12
3399 3399 SURGICAL HOSPITAL OF OKLAHOMA, LLC 100 SOUTHEAST 59TH STREET OKLAHOMA CITY OK 73129 OKLAHOMA (405) 634-9300 Acute Care Hospitals Physician TRUE 35.4062250 -97.5093160 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-drs8-u5z4.yfq6 370201 649812 2019-05-31 2018-12-31 12           12               12
3559 3559 SPECTRUM HEALTH KELSEY HOSPITAL 418 WASHINGTON LAKEVIEW MI 48850 MONTCALM (989) 352-7211 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4411000 -85.2785160 0   117 26 26117 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Montcalm County https://data.medicare.gov/resource/xubh-q36u/row-7fqd_gq5t.eh9k 231317 660104 2019-11-26 2019-06-30 12           12       31       43
3677 3677 MITCHELL COUNTY HOSPITAL HEALTH SYSTEMS 400 W 8TH STREET, P O BOX 399 BELOIT KS 67420 MITCHELL (785) 738-2266 Critical Access Hospitals Government - Local TRUE 39.4664990 -98.1142350 0   123 20 20123         https://data.medicare.gov/resource/xubh-q36u/row-pzzg_8xf8_sq7i 171375 654375 2019-08-30 2019-03-31 12 4         16 10     40       66
3732 3732 PIONEER MEMORIAL HOSPITAL - CAH 315 N WASHINGTON AVE POST OFFICE BOX 368 VIBORG SD 57070 TURNER (605) 326-5161 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1700926 -97.0818666 1 ROOFTOP 125 46 46125 43620   Outlying Turner County https://data.medicare.gov/resource/xubh-q36u/row-eg2b-5945~rjby 431328 652385 2019-07-02 2018-12-31 12           12       52       64
3855 3855 GRISELL MEMORIAL HOSPITAL 210 SOUTH VERMONT AVENUE RANSOM KS 67572 NESS (785) 731-2231 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.6367100 -99.9315460 0   135 20 20135         https://data.medicare.gov/resource/xubh-q36u/row-m6sz.xvcu-brgm 171300 649227 2019-05-28 2018-12-31 12           12           30   42
4058 4058 SCHOOLCRAFT MEMORIAL HOSPITAL 7870W US HIGHWAY 2 MANISTIQUE MI 49854 SCHOOLCRAFT (906) 341-3200 Critical Access Hospitals Government - Local TRUE 45.9449630 -86.2757160 0   153 26 26153         https://data.medicare.gov/resource/xubh-q36u/row-i54k_s479.sfn4 231303 650833 2019-06-06 2018-12-31 12           12               12
4117 4117 JASPER MEMORIAL HOSPITAL 898 COLLEGE STREET MONTICELLO GA 31064 JASPER (706) 468-6411 Critical Access Hospitals Government - Local TRUE 33.3139820 -83.6868770 0   159 13 13159 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Jasper County https://data.medicare.gov/resource/xubh-q36u/row-7m3n_3mxm~mxsc 111303 645064 2019-03-04 2018-09-30 12           12       55       67
4302 4302 BAYLOR SCOTT AND WHITE SURGICAL HOSPITAL AT SHERMA 3601 CALAIS DRIVE SHERMAN TX 75090 GRAYSON (903) 813-3728 Acute Care Hospitals Physician TRUE 33.6768600 -96.6025270 0   181 48 48181 43300 Dallas-Fort Worth, TX-OK Central Grayson County https://data.medicare.gov/resource/xubh-q36u/row-4y3f.tmsq.cez5 670076 648878 2019-05-28 2018-12-31 12           12               12
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
4426 4426 FIRST TEXAS HOSPITAL 9922 LOUETTA RD HOUSTON TX 77070 HARRIS (844) 264-1435 Acute Care Hospitals Proprietary TRUE 30.0008390 -95.5608680 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-t68p~4ggy.94di 670118 649157 2019-05-30 2018-12-31 12           12               12
4484 4484 SITKA COMMUNITY HOSPITAL 209 MOLLER DRIVE SITKA AK 99835 SITKA BOROUGH (907) 747-3241 Critical Access Hospitals Government - Local TRUE 57.0589920 -135.3459290 0   220 2 2220         https://data.medicare.gov/resource/xubh-q36u/row-asew~ba2y_nt2p 21303 638783 2018-12-03 2018-06-30 12           12       15       27
4631 4631 LILLIAN M HUDSPETH MEMORIAL HOSPITAL 308 HUDSPETH SONORA TX 76950 SUTTON (325) 387-2521 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.5637580 -100.6348700 0   435 48 48435         https://data.medicare.gov/resource/xubh-q36u/row-i9e9_qde3.um4r 451324 652847 2019-08-21 2018-12-31 12           12               12
987 987 SOUTH LINCOLN MEDICAL CENTER - CAH 711 ONYX STREET KEMMERER WY 83101 LINCOLN (307) 877-4401 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.7895800 -110.5406070 0   23 56 56023         https://data.medicare.gov/resource/xubh-q36u/row-fvca.ncci~gnkk 531315 661692 2019-11-22 2019-06-30 13           13         24     37
1088 1088 PERSHING GENERAL HOSPITAL 855 6TH STREET/PO BOX 661 LOVELOCK NV 89419 PERSHING (775) 273-2621 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1766240 -118.4820870 0   27 32 32027         https://data.medicare.gov/resource/xubh-q36u/row-9yyu.vv2v~izhm 291304 662550 2019-11-27 2019-06-30 13           13       25       38
1450 1450 OAKLEAF SURGICAL HOSPITAL 1000 OAKLEAF WAY ALTOONA WI 54720 EAU CLAIRE (715) 831-8130 Acute Care Hospitals Physician FALSE 44.8150020 -91.4517640 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-4tiq~2hj5~t8xv 520196 650624 2019-05-30 2018-12-31 13           13               13
1502 1502 WEST COVINA MEDICAL CENTER, INC 725 S ORANGE AVE WEST COVINA CA 91790 LOS ANGELES (626) 338-8481 Acute Care Hospitals Proprietary FALSE 34.0709280 -117.9441660 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-mrqt_jczt_crz9 50096 652580 2019-05-30 2018-12-31 13           13       33       46
1731 1731 VALOR HEALTH 1202 EAST LOCUST STREET EMMETT ID 83617 GEM (208) 365-3561 Critical Access Hospitals Government - Local TRUE 43.8790780 -116.4852550 0   45 16 16045 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Gem County https://data.medicare.gov/resource/xubh-q36u/row-cch8-kmmd-nmhb 131318 644635 2019-02-28 2018-09-30 13           13               13
1734 1734 GENESIS MEDICAL CENTER-DEWITT 1118 11TH STREET DEWITT IA 52742 CLINTON (563) 659-4200 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8259400 -90.5462570 0   45 19 19045 17540 Davenport-Moline, IA-IL Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-buet_jiin-dt28 161313 659569 2019-11-19 2019-06-30 13           13       77       90
2081 2081 SAKAKAWEA MEDICAL CENTER - CAH 510 8TH AVENUE NE HAZEN ND 58545 MERCER (701) 748-2225 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2982860 -101.6115600 0   57 38 38057         https://data.medicare.gov/resource/xubh-q36u/row-772i_c662.4xam 351310 660272 2019-11-25 2019-06-30 13           13               13
2693 2693 TETON VALLEY HOSPITAL 120 EAST HOWARD AVE DRIGGS ID 83422 TETON (208) 354-2383 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7272850 -111.1086080 0   81 16 16081 27220   Outlying Teton County https://data.medicare.gov/resource/xubh-q36u/row-73s3-g6zw_arid 131313 643497 2019-02-27 2018-09-30 13           13               13
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
3080 3080 SONOMA DEVELOPMENTAL CENTER 15000 ARNOLD DRIVE / P O BOX 1493 ELDRIDGE CA 95431 SONOMA (707) 938-6000 Acute Care Hospitals Government - State FALSE 38.3490270 -122.5169100 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-j6wx.73xx-wqrm 50547 638175 2018-11-27 2018-06-30 13           13           963   976
3165 3165 SOUTHEAST MICHIGAN SURGICAL HOSPITAL 21230 DEQUINDRE ROAD WARREN MI 48091 MACOMB (586) 427-1000 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.4513950 -83.0835600 0   99 26 26099 19820 Detroit-Warren-Ann Arbor, MI Central Macomb County https://data.medicare.gov/resource/xubh-q36u/row-n5cw~k8mz~eeh4 230264 650280 2019-06-03 2018-12-31 13           13               13
3911 3911 ROCHELLE COMMUNITY HOSPITAL 900 N 2ND ST ROCHELLE IL 61068 OGLE (815) 562-2181 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.9285730 -89.0628010 0   141 17 17141 40300 Rockford-Freeport-Rochelle, IL Central Ogle County https://data.medicare.gov/resource/xubh-q36u/row-k7rn.qbh3~e5z4 141312 652925 2019-08-09 2019-04-30 13 4         17               17
4135 4135 MANHATTAN SURGICAL HOSPITAL LLC 1829 COLLEGE AVENUE MANHATTAN KS 66502 RILEY (785) 776-5100 Acute Care Hospitals Physician FALSE 39.2028260 -96.5981830 0   161 20 20161 31740 Manhattan-Junction City, KS Central Riley County https://data.medicare.gov/resource/xubh-q36u/row-5vw9~wxt5.eejp 170190 648618 2019-05-24 2018-12-31 13           13               13
4298 4298 WEBSTER COUNTY COMMUNITY HOSPITAL P O BOX 465, 621 N FRANKLIN ST RED CLOUD NE 68970 WEBSTER (402) 746-5600 Critical Access Hospitals Government - Local TRUE 40.0915582 -98.5280755 1 ROOFTOP 181 31 31181         https://data.medicare.gov/resource/xubh-q36u/row-2g3y_shvn~j8h3 281316 660132 2019-11-26 2019-06-30 13           13               13
4329 4329 HENDERSON HEALTH CARE SERVICES 1621 FRONT STREET HENDERSON NE 68371 YORK (402) 723-4512 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7828880 -97.8073610 0   185 31 31185         https://data.medicare.gov/resource/xubh-q36u/row-eqsp-f96h~xhhx 281308 654683 2019-09-20 2019-06-30 13           13           40   53
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
25 25 ESSENTIA HEALTH ADA 201 9TH STREET WEST ADA MN 56510 NORMAN (218) 784-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2960910 -96.5301900 0   107 27 27107         https://data.medicare.gov/resource/xubh-q36u/row-z63y_de5x~9s9u 241313 660607 2019-11-26 2019-06-30 14           14               14
136 136 COPPER QUEEN COMMUNITY HOSPITAL 101 COLE AVENUE BISBEE AZ 85603 COCHISE (520) 432-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.4172540 -109.8826000 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-3x2q~x9dv.fg6n 31312 659555 2019-11-25 2019-06-30 14           14               14
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
795 795 BATH COMMUNITY HOSPITAL 106 PARK DRIVE- PO DRAWER Z HOT SPRINGS VA 24445 BATH (540) 839-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9938900 -79.8309590 0   17 51 51017         https://data.medicare.gov/resource/xubh-q36u/row-36k3~dwrj~zvyd 491300 650420 2019-05-31 2018-12-31 14           14               14
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

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