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

1,434 rows where "fy_end_date" is on date 2019-06-30 sorted by acute_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

fy_end_date (date) ✖

  • 2019-06-30 · 1,434 ✖
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
2979 2979 JOHNSON COUNTY COMMUNITY HOSPITAL 1901 S SHADY ST MOUNTAIN CITY TN 37683 JOHNSON (423) 727-1110 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.4537830 -81.7987220 0   91 47 47091         https://data.medicare.gov/resource/xubh-q36u/row-48iq_hv6w-z7xq 441304 660044 2019-11-22 2019-06-30 2           2               2
1593 1593 EDWARD MCCREADY MEMORIAL HOSPITAL 201 HALL HIGHWAY CRISFIELD MD 21817 SOMERSET (410) 726-9496 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9960110 -75.8523660 0   39 24 24039 41540   Outlying Somerset County https://data.medicare.gov/resource/xubh-q36u/row-cmnn-hhsq~qwjh 210045 657148 2019-11-07 2019-06-30 3           3               3
10 10 GARFIELD COUNTY HEALTH CENTER 332 LEAVITT AVE JORDAN MT 59337 GARFIELD (406) 557-2500 Critical Access Hospitals Government - Local TRUE 47.3185240 -106.9113280 0   33 30 30033         https://data.medicare.gov/resource/xubh-q36u/row-xbp8~mipq.32d8 271310 659309 2019-11-18 2019-06-30 4           4       24       28
1062 1062 SOUTHERN INYO HOSPITAL 501 EAST LOCUST STREET LONE PINE CA 93545 INYO (760) 876-5501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.6083740 -118.0581590 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-wcp4_jkw5.du53 51302 659919 2019-12-02 2019-06-30 4           4       33       37
1283 1283 INCLINE VILLAGE HEALTH CENTER 880 ALDER STREET INCLINE VILLAGE NV 89451 WASHOE (775) 833-4100 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2509450 -119.9538610 0   31 32 32031 39900 Reno-Carson City-Fernley, NV Central Washoe County https://data.medicare.gov/resource/xubh-q36u/row-xavt.4jau_b7jd 291301 660260 2019-12-02 2019-06-30 4           4               4
1829 1829 SURPRISE VALLEY COMMUNITY HOSPITAL 741 NORTH MAIN STREET CEDARVILLE CA 96104 MODOC (530) 279-6111 Critical Access Hospitals Government - Local TRUE 41.5319310 -120.1718990 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-cdww_rq6r_6v4q 51308 662485 2019-12-23 2019-06-30 4           4       22       26
1978 1978 HIRAM W DAVIS MEDICAL CENTER P O BOX 4030 PETERSBURG VA 23803 PETERSBURG CITY (804) 524-7344 Acute Care Hospitals Government - State FALSE 37.2098658 -77.4509355 1 ROOFTOP 53 51 51053 40060   Central Dinwiddie County https://data.medicare.gov/resource/xubh-q36u/row-xvn2.38q5-2xg5 490104 661117 2019-11-27 2019-06-30 4           4       50 30 277   361
2850 2850 FISHERMEN'S COMMUNITY HOSPITAL 3301 OVERSEAS HWY MARATHON FL 33050 MONROE (305) 743-5533 Critical Access Hospitals Voluntary non-profit - Private TRUE 24.7111300 -81.0947200 0   87 12 12087 28580   Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-3mjy.7a5u.ezdd 101312 659771 2019-11-25 2019-06-30 4 1         5               5
2926 2926 EUREKA COMMUNITY HEALTH SERVICES - CAH 200 J AVE POST OFFICE BOX 517 EUREKA SD 57437 MC PHERSON (605) 284-2661 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.7671960 -99.6144530 0   89 46 46089         https://data.medicare.gov/resource/xubh-q36u/row-63d5-93ah~nnd5 431308 658588 2019-11-12 2019-06-30 4           4               4
3233 3233 WILLS EYE HOSPITAL 840 WALNUT STREET PHILADELPHIA PA 19107 PHILADELPHIA (215) 440-3100 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9482710 -75.1557000 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-nxn5~vwjj_bn3j 390331 660449 2019-12-03 2019-06-30 4           4               4
695 695 BATTLE MOUNTAIN GENERAL HOSPITAL 535 SOUTH HUMBOLDT STREET BATTE MTN NV 89820 LANDER (775) 635-2550 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6406520 -116.9388210 0   15 32 32015         https://data.medicare.gov/resource/xubh-q36u/row-w9hj-b8v2_4i43 291303 662549 2019-11-29 2019-06-30 5           5       25       30
83 83 KOHALA HOSPITAL 54-383 HOSPITAL ROAD KAPAAU HI 96755 HAWAII (808) 889-6211 Critical Access Hospitals Government - State TRUE 20.2317370 -155.7972530 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-zwx4_qya8~b57e 121302 662519 2019-11-29 2019-06-30 6           6       22       28
84 84 KAU HOSPITAL 1 KAMANI STREET PAHALA HI 96777 HAWAII (808) 928-8331 Critical Access Hospitals Government - State TRUE 19.2005710 -155.4720970 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-jcnf-fhnk_q5i3 121301 662188 2019-12-02 2019-06-30 6           6               6
2557 2557 LAGUNA HONDA HOSPITAL & REHABILITATION CENTER 375 LAGUNA HONDA BLVD SAN FRANCISCO CA 94116 SAN FRANCISCO (415) 759-2300 Acute Care Hospitals Government - Local FALSE 37.7478240 -122.4586360 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-tz44~vi64-ys8h 50668 662169 2019-12-02 2019-06-30 6           6   5   769       780
2628 2628 AVERA DE SMET MEMORIAL HOSPITAL - CAH 306 PRAIRIE AVENUE SW POST OFFICE BOX 160 DE SMET SD 57231 KINGSBURY (605) 854-3329 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3860427 -97.5611172 1 GEOMETRIC_CENTER 77 46 46077         https://data.medicare.gov/resource/xubh-q36u/row-q65a~ny3z~nsyr 431332 662255 2019-11-27 2019-06-30 6           6               6
3290 3290 SAME DAY SURGERY CENTER LLC 651 CATHEDRAL DRIVE RAPID CITY SD 57701 PENNINGTON (605) 755-9900 Acute Care Hospitals Proprietary FALSE 44.0591900 -103.2291020 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-9hcp~bs9i-drqz 430093 658957 2019-11-18 2019-06-30 6           6               6
693 693 BIG SANDY MEDICAL CENTER 166 MONTANA AVE E BIG SANDY MT 59520 CHOUTEAU (406) 378-2188 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1790800 -110.1082170 0   15 30 30015         https://data.medicare.gov/resource/xubh-q36u/row-9nm3.ugyv-geii 271311 661032 2019-12-09 2019-06-30 8           8       22       30
836 836 PAUL OLIVER MEMORIAL HOSPITAL 224 PARK AVENUE FRANKFORT MI 49635 BENZIE (231) 352-2200 Critical Access Hospitals Government - Local TRUE 44.6373760 -86.2429130 0   19 26 26019 45900   Outlying Benzie County https://data.medicare.gov/resource/xubh-q36u/row-cypk~xgkd.zsnp 231300 660598 2019-11-26 2019-06-30 8           8       36       44
930 930 SETON SMITHVILLE REGIONAL HOSPITAL 1201 HILL RD SMITHVILLE TX 78957 BASTROP (512) 237-3214 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.0039505 -97.1360218 1 ROOFTOP 21 48 48021 12420   Outlying Bastrop County https://data.medicare.gov/resource/xubh-q36u/row-d2dp~cvuc~gmre 450143 659733 2019-11-25 2019-06-30 8           8               8
1538 1538 MERCY MEDICAL CENTER-NEW HAMPTON 308 NORTH MAPLE AVENUE NEW HAMPTON IA 50659 CHICKASAW (641) 394-4121 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0626770 -92.3204250 0   37 19 19037         https://data.medicare.gov/resource/xubh-q36u/row-xkj8-v8qa.w84a 161331 660217 2019-11-26 2019-06-30 8           8               8
2648 2648 KALKASKA MEMORIAL HEALTH CENTER 419 S CORAL KALKASKA MI 49646 KALKASKA (231) 258-7500 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7308970 -85.1838370 0   79 26 26079 45900   Outlying Kalkaska County https://data.medicare.gov/resource/xubh-q36u/row-xxgj-5p26_g3uf 231301 662385 2019-12-12 2019-06-30 8           8       102       110
4700 4700 BAYLOR SCOTT & WHITE EMERGENCY MEDICAL CENTER AT C 900 EAST WHITESTONE BLVD CEDAR PARK TX 78613 WILLIAMSON (512) 684-4911 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.5239510 -97.8201770 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-7m75.eizi~hrs5 670087 662636 2019-12-19 2019-06-30 8           8               8
946 946 JEROLD PHELPS COMMUNITY HOSPITAL 733 CEDAR ST GARBERVILLE CA 95542 HUMBOLDT (707) 923-3921 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1014910 -123.7927560 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-xasy~ndp2-8fte 51309 662173 2019-11-29 2019-06-30 9           9       8       17
2221 2221 EASTERN PLUMAS HOSPITAL - PORTOLA CAMPUS 500 FIRST AVENUE PORTOLA CA 96122 PLUMAS (530) 832-4277 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.8061440 -120.4631290 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-4uid-vtd8_6vsi 51300 662171 2019-11-27 2019-06-30 9           9       66       75
2430 2430 BEAR VALLEY COMMUNITY HOSPITAL 41870 GARSTIN DR BIG BEAR LAKE CA 92315 SAN BERNARDINO (909) 866-6501 Critical Access Hospitals Government - Hospital District or Authority FALSE 34.2460230 -116.8883430 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-4ruv_6zyd-x27y 51335 662176 2019-11-27 2019-06-30 9           9       21       30
3535 3535 ESSENTIA HEALTH SANDSTONE 705 LUNDORFF DRIVE SOUTH SANDSTONE MN 55072 PINE (320) 245-2212 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1184080 -92.8829670 0   115 27 27115         https://data.medicare.gov/resource/xubh-q36u/row-krja~dcyt_wwi3 241309 660606 2019-11-27 2019-06-30 9           9               9
4619 4619 CHI ST LUKES HEALTH MEMORIAL SAN AUGUSTINE 511 HOSPITAL ST SAN AUGUSTINE TX 75972 SAN AUGUSTINE (936) 275-3446 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.5322792 -94.1031699 1 ROOFTOP 405 48 48405         https://data.medicare.gov/resource/xubh-q36u/row-d3sm_en2i-92xw 451360 660892 2019-11-27 2019-06-30 9           9               9
22 22 STILLWATER BILLINGS CLINIC 710 N 11TH ST COLUMBUS MT 59019 STILLWATER (406) 322-5316 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6426860 -109.2431780 0   95 30 30095         https://data.medicare.gov/resource/xubh-q36u/row-feve.dr4z_em5n 271330 662542 2019-11-29 2019-06-30 10           10               10
253 253 SOUTH BIG HORN COUNTY CRITICAL ACCESS HOSPITAL 388 US HIGHWAY 20 SOUTH BASIN WY 82410 BIG HORN (307) 568-1500 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4344490 -108.0490070 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-vp99_bama.8nds 531301 661691 2019-11-29 2019-06-30 10           10       37       47
847 847 GUADALUPE COUNTY HOSPITAL 117 CAMINO DE VIDA, SUITE 100 SANTA ROSA NM 88435 GUADALUPE (575) 472-3417 Acute Care Hospitals Government - Local TRUE 34.9295040 -104.6942240 0   19 35 35019         https://data.medicare.gov/resource/xubh-q36u/row-es4t_p7gk_ag72 320067 661934 2019-12-17 2019-06-30 10           10               10
895 895 MERCY HOSPITAL COLUMBUS 220 N PENNSYLVANIA AVENUE COLUMBUS KS 66725 CHEROKEE (620) 429-2545 Critical Access Hospitals Voluntary non-profit - Church TRUE 37.1720640 -94.8438050 0   21 20 20021         https://data.medicare.gov/resource/xubh-q36u/row-sn95~jvt2.e2ep 171308 660551 2019-11-27 2019-06-30 10           10               10
1040 1040 HANCOCK COUNTY HOSPITAL 1519 MAIN STREET HWY 33 SNEEDVILLE TN 37869 HANCOCK (423) 733-5001 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.4302660 -83.4627660 0   25 47 47025         https://data.medicare.gov/resource/xubh-q36u/row-vwp6~bn89_wdkx 441313 659461 2019-11-20 2019-06-30 10           10               10
1752 1752 DILEY RIDGE MEDICAL CENTER 7911 DILEY ROAD CANAL WINCHESTER OH 43110 FRANKLIN (614) 838-7910 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8500530 -82.7811000 0   45 39 39045 18140 Columbus-Marion-Zanesville, OH Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-82cy_fgw2.yjpg 360358 660675 2019-11-26 2019-06-30 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
978 978 BLUE MOUNTAIN HOSPITAL 170 FORD ROAD JOHN DAY OR 97845 GRANT (541) 575-1311 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4176510 -118.9592200 0   23 41 41023         https://data.medicare.gov/resource/xubh-q36u/row-svyy.cxkf.r4qf 381305 662576 2019-11-27 2019-06-30 14           14               14
2197 2197 FRANKLIN COUNTY MEMORIAL HOSPITAL 1406 Q ST FRANKLIN NE 68939 FRANKLIN (308) 425-6221 Critical Access Hospitals Government - Local TRUE 40.1015520 -98.9543530 0   61 31 31061         https://data.medicare.gov/resource/xubh-q36u/row-7jps~ae6v.42rk 281311 656707 2019-11-05 2019-06-30 14           14               14
3173 3173 UNITY MEDICAL CENTER 164 W 13TH STREET GRAFTON ND 58237 WALSH (701) 352-1620 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4114840 -97.4138290 0   99 38 38099         https://data.medicare.gov/resource/xubh-q36u/row-xvyg.2uq7_fcwn 351320 660660 2019-12-03 2019-06-30 14           14               14
3225 3225 KENSINGTON HOSPITAL 136 W DIAMOND STREET PHILADELPHIA PA 19122 PHILADELPHIA (215) 426-8100 Acute Care Hospitals Voluntary non-profit - Other FALSE 39.9817591 -75.1347791 1 ROOFTOP 101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-jdjh_ypv5.y5gj 390025 660289 2019-12-02 2019-06-30 14           14               14
3735 3735 ASCENSION EAGLE RIVER HOSPITAL 201 HOSPITAL ROAD EAGLE RIVER WI 54521 VILAS (715) 479-7411 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9275180 -89.2516780 0   125 55 55125         https://data.medicare.gov/resource/xubh-q36u/row-unpa.6ptj.b2ji 521300 661443 2019-11-27 2019-06-30 14           14               14
3915 3915 BAUM HARMON MERCY HOSPITAL 255 N WELCH AVENUE PRIMGHAR IA 51245 OBRIEN (712) 957-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0885970 -95.6227960 0   141 19 19141         https://data.medicare.gov/resource/xubh-q36u/row-jur3.m7q6_c9mz 161300 660546 2019-11-27 2019-06-30 14           14               14
3980 3980 CENTRACARE HEALTH SYSTEM - MELROSE HOSPITAL 525 WEST MAIN STREET MELROSE MN 56352 STEARNS (320) 256-1761 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6749160 -94.8234350 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-zgd7-nfj6_jc2g 241330 660610 2019-11-27 2019-06-30 14           14       75       89
4024 4024 CORDELL MEMORIAL HOSPITAL 1220 NORTH GLENN ENGLISH STREET CORDELL OK 73632 WASHITA (580) 832-3339 Critical Access Hospitals Government - Local TRUE 35.3025240 -98.9875950 0   149 40 40149         https://data.medicare.gov/resource/xubh-q36u/row-k6qa-iqdm.jnj9 371325 660005 2019-12-03 2019-06-30 14           14               14
4060 4060 CENTRACARE HEALTH SYSTEM - LONG PRAIRIE 50 CENTRACARE DRIVE LONG PRAIRIE MN 56347 TODD (320) 732-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9733659 -94.8429923 1 ROOFTOP 153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-auf6_7hb8_cyed 241326 660609 2019-11-26 2019-06-30 14           14       70       84
4099 4099 ST ELIZABETH MEDICAL CENTER 1200 GRANT BLVD W WABASHA MN 55981 WABASHA (651) 565-4531 Critical Access Hospitals Proprietary TRUE 44.3864160 -92.0491400 0   157 27 27157 40340 Rochester-Austin, MN Outlying Wabasha County https://data.medicare.gov/resource/xubh-q36u/row-diq7.k9ja_4m53 241335 661737 2019-12-03 2019-06-30 14           14       100       114
91 91 ACADIA ST LANDRY 810 SOUTH BROADWAY STREET CHURCH POINT LA 70525 ACADIA (337) 684-5435 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.3950170 -92.2118330 0   1 22 22001 29180 Lafayette-Opelousas-Morgan City, LA Outlying Acadia Parish https://data.medicare.gov/resource/xubh-q36u/row-mqb2~y9xg-useh 191319 661189 2019-12-05 2019-06-30 15           15 10             25
163 163 KAHUKU MEDICAL CENTER 56-117 PUALALEA STREET KAHUKU HI 96731 HONOLULU (808) 293-9221 Critical Access Hospitals Voluntary non-profit - Other TRUE 21.6764400 -157.9522110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-gwji.69dv_68xy 121304 661306 2019-12-02 2019-06-30 15           15       6       21
356 356 ASSUMPTION COMMUNITY HOSPITAL 135 HIGHWAY 402 NAPOLEONVILLE LA 70390 ASSUMPTION (985) 369-3600 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.9575850 -91.0338750 0   7 22 22007         https://data.medicare.gov/resource/xubh-q36u/row-smss_wf6g.wmww 191303 659796 2019-11-27 2019-06-30 15           15               15
424 424 MOLOKAI GENERAL HOSPITAL 280 HOME OLU PLACE KAUNAKAKAI HI 96748 MAUI (808) 553-5331 Critical Access Hospitals Voluntary non-profit - Private TRUE 21.0937600 -157.0179820 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-vd6b-yn49_x98y 121303 659777 2019-11-26 2019-06-30 15           15               15
511 511 ESSENTIA HEALTH HOLY TRINITY HOSPITAL 115 SECOND STREET WEST, BOX 157 GRACEVILLE MN 56240 BIG STONE (320) 748-8200 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.5624100 -96.4334520 0   11 27 27011         https://data.medicare.gov/resource/xubh-q36u/row-crzd_579y.ukdv 241321 660608 2019-11-27 2019-06-30 15           15       40       55
883 883 GLENN MEDICAL CENTER 1133 W SYCAMORE ST WILLOWS CA 95988 GLENN (530) 934-1818 Critical Access Hospitals Government - Federal TRUE 39.5204670 -122.2081200 0   21 6 6021         https://data.medicare.gov/resource/xubh-q36u/row-7nst_26uq.zcvx 51306 662484 2019-12-03 2019-06-30 15           15               15
1141 1141 UMD SHORE MEDICAL CTR AT CHESTERTOWN 100 BROWN STREET CHESTERTOWN MD 21620 KENT (410) 778-7668 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2168450 -76.0644920 0   29 24 24029         https://data.medicare.gov/resource/xubh-q36u/row-9gun.f2aw-guni 210030 660229 2019-12-02 2019-06-30 15 6         21               21
1645 1645 HERINGTON MUNICIPAL HOSPITAL 100 E HELEN STREET HERINGTON KS 67449 DICKINSON (785) 258-2207 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.6795610 -96.9422740 0   41 20 20041         https://data.medicare.gov/resource/xubh-q36u/row-sgwx~evd5.tciy 171340 661326 2019-12-03 2019-06-30 15           15               15
1695 1695 MERCY ONE ELKADER MEDICAL CENTER 901 DAVIDSON STREET NW ELKADER IA 52043 CLAYTON (563) 245-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8597710 -91.4145360 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-tpbr_taqd~69cu 161319 661725 2019-12-04 2019-06-30 15           15               15
1891 1891 MAMMOTH HOSPITAL 85 SIERRA PARK ROAD PO BOX 660 MAMMOTH LAKES CA 93546 MONO (760) 934-3311 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6450710 -118.9639110 0   51 6 6051         https://data.medicare.gov/resource/xubh-q36u/row-rfxr_qrfx~jtdt 51303 659023 2019-11-19 2019-06-30 15 2         17               17
1934 1934 BURLESON ST JOSEPH HEALTH CENTER 1101 WOODSON DRIVE CALDWELL TX 77836 BURLESON (979) 567-3245 Critical Access Hospitals Voluntary non-profit - Church FALSE 30.5203070 -96.7177140 0   51 48 48051 17780   Outlying Burleson County https://data.medicare.gov/resource/xubh-q36u/row-gq4y-tvhz_2h55 451305 660890 2019-11-29 2019-06-30 15           15               15
1971 1971 SALEM HEALTH WEST VALLEY 525 SE WASHINGTON STREET DALLAS OR 97338 POLK (503) 623-8301 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9194040 -123.3103830 0   53 41 41053 41420 Portland-Vancouver-Salem, OR-WA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-urpw.pi4k_vkp4 381308 660286 2019-12-02 2019-06-30 15           15               15
2298 2298 CLINCH MEMORIAL HOSPITAL 1050 VALDOSTA HIGHWAY HOMERVILLE GA 31634 CLINCH (912) 487-5211 Critical Access Hospitals Government - Local TRUE 31.0326510 -82.7638580 0   65 13 13065         https://data.medicare.gov/resource/xubh-q36u/row-6x28-ujdc_jsi5 111308 659942 2019-11-27 2019-06-30 15           15               15
2420 2420 ASCENSION SACRED HEART HOSPITAL 401 W MOHAWK DR SUITE 100 TOMAHAWK WI 54487 LINCOLN (715) 453-7700 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.4890060 -89.7335960 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-zubv-e9fv-qs3r 521313 661446 2019-11-27 2019-06-30 15           15               15
2611 2611 LAKEWOOD HEALTH CENTER 600 MAIN AVE S BAUDETTE MN 56623 LAKE OF WOODS (218) 634-2120 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.7074270 -94.6011720 0   77 27 27077         https://data.medicare.gov/resource/xubh-q36u/row-x2n8-qsfh.99ps 241301 661915 2019-12-04 2019-06-30 15           15       44       59
3001 3001 IRON COUNTY MEDICAL CENTER 301 NORTH HIGHWAY 21 PILOT KNOB MO 63663 IRON (573) 546-1260 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6087570 -90.6291900 0   93 29 29093         https://data.medicare.gov/resource/xubh-q36u/row-gcg8.69nm~t5ha 261336 660408 2019-11-27 2019-06-30 15           15               15
3320 3320 KIMBALL HEALTH SERVICES 505 SOUTH BURG ST KIMBALL NE 69145 KIMBALL (308) 235-1951 Critical Access Hospitals Government - Local TRUE 41.2324380 -103.6672040 0   105 31 31105         https://data.medicare.gov/resource/xubh-q36u/row-3qnf.krtg-ks6w 281305 662400 2019-12-06 2019-06-30 15           15               15
3413 3413 TANNER MEDICAL CENTER-EAST ALABAMA 1032 MAIN STREET SOUTH WEDOWEE AL 36278 RANDOLPH (256) 357-2111 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.2966660 -85.4800280 0   111 1 1111         https://data.medicare.gov/resource/xubh-q36u/row-beeg-xgp7.fjvj 11306 659914 2019-11-27 2019-06-30 15           15               15
3585 3585 UCHEALTH PIKES PEAK REGIONAL HOSPITAL 16420 WEST HIGHWAY 24 WOODLAND PARK CO 80863 TELLER (719) 687-9999 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9739320 -105.0742670 0   119 8 8119 17820   Outlying Teller County https://data.medicare.gov/resource/xubh-q36u/row-rxec_h64n-ugar 61326 660069 2019-11-27 2019-06-30 15           15               15
3897 3897 CHI HEALTH PLAINVIEW P O BOX 489, 704 NORTH THIRD ST PLAINVIEW NE 68769 PIERCE (402) 582-4245 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.3587128 -97.7857721 1 ROOFTOP 139 31 31139 35740   Outlying Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dyfy-rvq7~3hjd 281346 661043 2019-12-02 2019-06-30 15           15               15
3943 3943 HIGGINS GENERAL HOSPITAL 200 ALLEN MEMORIAL DRIVE BREMEN GA 30110 HARALSON (770) 812-2000 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7163430 -85.1446230 0   143 13 13143 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Haralson County https://data.medicare.gov/resource/xubh-q36u/row-rd44_uqxz.t5yc 111320 660206 2019-12-02 2019-06-30 15           15               15
4036 4036 DECKERVILLE COMMUNITY HOSPITAL 3559 PINE ST DECKERVILLE MI 48427 SANILAC (810) 376-2835 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5281610 -82.7337730 0   151 26 26151         https://data.medicare.gov/resource/xubh-q36u/row-kq5w_x6ix-cx98 231311 660599 2019-11-25 2019-06-30 15           15               15
4057 4057 RAWLINS COUNTY HEALTH CENTER 707 GRANT ST ATWOOD KS 67730 RAWLINS (785) 626-3211 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.8132640 -101.0385000 0   153 20 20153         https://data.medicare.gov/resource/xubh-q36u/row-aajh-f5t2_nat3 171307 659791 2019-11-25 2019-06-30 15           15               15
4235 4235 PUTNAM COUNTY MEMORIAL HOSPITAL 1926 OAK STREET, PO BOX 389 UNIONVILLE MO 63565 PUTNAM (660) 947-2411 Critical Access Hospitals Government - Local TRUE 40.4820250 -93.0059870 0   171 29 29171         https://data.medicare.gov/resource/xubh-q36u/row-ygkd_dijw_ng7v 261305 661212 2019-12-02 2019-06-30 15           15               15
4570 4570 MADISON ST JOSEPH HEALTH CENTER 100 WEST CROSS STREET MADISONVILLE TX 77864 MADISON (936) 348-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 30.9420460 -95.9099560 0   313 48 48313         https://data.medicare.gov/resource/xubh-q36u/row-nns8-bhuk_vxd6 451316 660055 2019-12-02 2019-06-30 15           15               15
4616 4616 NORTH RUNNELS HOSPITAL 7821 EAST HIGHWAY 153 WINTERS TX 79567 RUNNELS (325) 754-4553 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.9498620 -99.9598240 0   399 48 48399         https://data.medicare.gov/resource/xubh-q36u/row-hszw.eyaq-hdvd 451315 659073 2019-11-18 2019-06-30 15           15               15
4681 4681 UVALDE MEMORIAL HOSPITAL 1025 GARNER FIELD ROAD UVALDE TX 78801 UVALDE (830) 278-6251 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.2151260 -99.7686680 0   463 48 48463 46620   Central Uvalde County https://data.medicare.gov/resource/xubh-q36u/row-v3yf_upph.s38x 451387 660893 2019-11-29 2019-06-30 15 6         21               21
16 16 AVERA WESKOTA MEMORIAL MEDICAL CENTER - CAH 604 1ST ST NE WESSINGTON SPRINGS SD 57382 JERAULD (605) 539-1201 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0803940 -98.5636820 0   73 46 46073         https://data.medicare.gov/resource/xubh-q36u/row-pcwb-j3y8~f5au 431324 662583 2019-11-27 2019-06-30 16           16               16
293 293 COMMUNITY HOSPITAL ASSOCIATION 26136 US HIGHWAY 59, PO BOX 107 FAIRFAX MO 64446 ATCHISON (660) 686-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3482150 -95.3973230 0   5 29 29005         https://data.medicare.gov/resource/xubh-q36u/row-kkzi.c85k.9msb 261303 660249 2019-11-26 2019-06-30 16           16               16
709 709 CURRY GENERAL HOSPITAL 94220 FOURTH STREET GOLD BEACH OR 97444 CURRY (541) 247-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.4116590 -124.4186580 0   15 41 41015 15060   Central Curry County https://data.medicare.gov/resource/xubh-q36u/row-9rud.6rf5~it7z 381322 659603 2019-11-25 2019-06-30 16           16               16
854 854 LOWER UMPQUA HOSPITAL DISTRICT 600 RANCH ROAD REEDSPORT OR 97467 DOUGLAS (541) 271-2171 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6953240 -124.1355710 0   19 41 41019 40700   Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-nysc.rhhn_bb99 381311 659602 2019-11-25 2019-06-30 16           16               16
913 913 MERCYONE OAKLAND MEDICAL CENTER 601 EAST SECOND ST OAKLAND NE 68045 BURT (402) 685-5601 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8345710 -96.4591970 0   21 31 31021         https://data.medicare.gov/resource/xubh-q36u/row-bi44_haku_5d9v 281321 660644 2019-11-27 2019-06-30 16           16               16
1427 1427 BUCKTAIL MEDICAL CENTER 1001 PINE STREET RENOVO PA 17764 CLINTON (570) 923-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.3269380 -77.7374450 0   35 42 42035 30820 Williamsport-Lock Haven, PA Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-vesv-my7y~edhc 391304 660870 2019-11-27 2019-06-30 16           16       43       59
1828 1828 MODOC MEDICAL CENTER 228 W MCDOWELL AVE ALTURAS CA 96101 MODOC (530) 233-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.4799490 -120.5455030 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-kyq6~7b5b.wgww 51330 662175 2019-11-27 2019-06-30 16           16       71       87

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