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 all_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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
2615 2615 DEER LODGE MEDICAL CENTER 1100 HOLLENBACK LN DEER LODGE MT 59722 POWELL (406) 846-2212 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4126340 -112.7263300 0   77 30 30077         https://data.medicare.gov/resource/xubh-q36u/row-4c8x-nuk8~9qhn 271314 656305 2019-11-04 2019-06-30 16           16               16
2734 2734 NORTH LOGAN MERCY HOSPITAL 500 EAST ACADEMY PARIS AR 72855 LOGAN (479) 963-6101 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.2899880 -93.7254190 0   83 5 5083         https://data.medicare.gov/resource/xubh-q36u/row-6tgs-f8yk-urcu 41300 660744 2019-12-04 2019-06-30 16           16               16
3003 3003 HOWARD COUNTY MEDICAL CENTER P O BOX 406, 1113 SHERMAN ST ST PAUL NE 68873 HOWARD (308) 754-4421 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.2145463 -98.4583381 1 ROOFTOP 93 31 31093 24260   Outlying Howard County https://data.medicare.gov/resource/xubh-q36u/row-dnv4.v747-tfbf 281338 655322 2019-10-18 2019-06-30 16           16               16
3950 3950 ANNIE JEFFREY MEMORIAL COUNTY HEALTH CENTER P O BOX 428, 531 BEEBE ST OSCEOLA NE 68651 POLK (402) 747-2031 Critical Access Hospitals Government - Local TRUE 41.1697878 -97.5490124 1 ROOFTOP 143 31 31143         https://data.medicare.gov/resource/xubh-q36u/row-tmyd~dpec-xnwq 281314 655636 2019-10-21 2019-06-30 16           16               16
3995 3995 KIRBY MEDICAL CENTER 1000 MEDICAL CENTER DRIVE MONTICELLO IL 61856 PIATT (217) 762-2115 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0601630 -88.5637700 0   147 17 17147 16580   Outlying Piatt County https://data.medicare.gov/resource/xubh-q36u/row-cyx9_rxkq~v7gg 141301 659780 2019-11-22 2019-06-30 16           16               16
4120 4120 RINGGOLD COUNTY HOSPITAL 504 NORTH CLEVELAND STREET MOUNT AYR IA 50854 RINGGOLD (641) 464-3226 Critical Access Hospitals Government - Local TRUE 40.7183300 -94.2236130 0   159 19 19159         https://data.medicare.gov/resource/xubh-q36u/row-wph7-7anh~da9v 161373 661898 2019-12-04 2019-06-30 16           16               16
4230 4230 ST VINCENT WILLIAMSPORT HOSPITAL INC 412 N MONROE ST WILLIAMSPORT IN 47993 WARREN (765) 762-4000 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.2904700 -87.2958190 0   171 18 18171         https://data.medicare.gov/resource/xubh-q36u/row-hngk~n78p-82t8 151307 660948 2019-12-02 2019-06-30 16           16               16
4268 4268 VALLEY COUNTY HEALTH SYSTEM 2707 L STREET ORD NE 68862 VALLEY (308) 728-4200 Critical Access Hospitals Government - Local TRUE 41.6032130 -98.9426760 0   175 31 31175         https://data.medicare.gov/resource/xubh-q36u/row-y2qv_7x4q_v7xu 281353 661044 2019-12-02 2019-06-30 16           16               16
526 526 OKEENE MUNICIPAL HOSPITAL 207 EAST F STREET OKEENE OK 73763 BLAINE (580) 822-4417 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.1170980 -98.3157260 0   11 40 40011         https://data.medicare.gov/resource/xubh-q36u/row-53s2_kxwz~vvkc 371327 659105 2019-11-20 2019-06-30 17           17               17
530 530 COQUILLE VALLEY HOSPITAL DISTRICT 940 EAST 5TH STREET COQUILLE OR 97423 COOS (541) 396-3101 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1789820 -124.1791430 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-qh6s~rn9z.ntit 381312 660287 2019-12-02 2019-06-30 17           17               17
884 884 SAN LUIS VALLEY HEALTH CONEJOS COUNTY HOSPITAL 19021 US HIGHWAY 285 LA JARA CO 81140 CONEJOS (719) 274-5121 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.2637500 -105.9640950 0   21 8 8021         https://data.medicare.gov/resource/xubh-q36u/row-2ncf.isv7_93r9 61308 662179 2019-12-03 2019-06-30 17           17               17
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
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
2912 2912 WEST HOLT MEMORIAL HOSPITAL 406 W NEELY ST ATKINSON NE 68713 HOLT (402) 925-2811 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.5285300 -98.9823600 0   89 31 31089         https://data.medicare.gov/resource/xubh-q36u/row-4yu8_vi3f~x2qc 281343 659706 2019-11-21 2019-06-30 17           17               17
3834 3834 PAWNEE COUNTY MEMORIAL HOSPITAL P O BOX 433, 600 I ST PAWNEE CITY NE 68420 PAWNEE (402) 852-2231 Critical Access Hospitals Proprietary TRUE 40.1098396 -96.1532422 1 ROOFTOP 133 31 31133         https://data.medicare.gov/resource/xubh-q36u/row-2ahw-y3eh_6phq 281302 661036 2019-12-02 2019-06-30 17           17               17
101 101 BARRETT HOSPITAL & HEALTHCARE 600 MT HWY 91 S DILLON MT 59725 BEAVERHEAD (406) 683-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.2006540 -112.6460030 0   1 30 30001         https://data.medicare.gov/resource/xubh-q36u/row-2tkn_v7av-d2ep 271318 662223 2019-11-27 2019-06-30 18           18               18
447 447 MERCY HOSPITAL CASSVILLE 94 MAIN STREET CASSVILLE MO 65625 BARRY (417) 847-6065 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.6740770 -93.8718860 0   9 29 29009         https://data.medicare.gov/resource/xubh-q36u/row-wswc_mpwv.fwbj 261317 660251 2019-11-26 2019-06-30 18           18               18
1602 1602 COOPERSTOWN MEDICAL CENTER 1200 ROBERTS AVE NE COOPERSTOWN ND 58425 GRIGGS (701) 797-2221 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4456240 -98.1185500 0   39 38 38039         https://data.medicare.gov/resource/xubh-q36u/row-qi2g~gwic_kc3w 351306 660659 2019-11-25 2019-06-30 18           18               18
1703 1703 SEILING MUNICIPAL HOSPITAL 809 NE HIGHWAY 60 SEILING OK 73663 DEWEY (580) 922-7361 Critical Access Hospitals Government - Local TRUE 36.1574590 -98.9207150 0   43 40 40043         https://data.medicare.gov/resource/xubh-q36u/row-79bz~vfcy-sppu 371332 660432 2019-11-29 2019-06-30 18           18               18
1951 1951 ELLSWORTH COUNTY MEDICAL CENTER 1604 AYLWARD AVENUE ELLSWORTH KS 67439 ELLSWORTH (785) 472-3111 Critical Access Hospitals Proprietary TRUE 38.7419690 -98.2188920 0   53 20 20053         https://data.medicare.gov/resource/xubh-q36u/row-gj2d~qekt_mg63 171327 659792 2019-11-18 2019-06-30 18           18               18
2157 2157 DAVIE MEDICAL CENTER 223 HOSPITAL STREET MOCKSVILLE NC 27028 DAVIE (336) 751-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9000100 -80.5700970 0   59 37 37059 49180 Greensboro--Winston-Salem--High Point, NC Central Davie County https://data.medicare.gov/resource/xubh-q36u/row-6uy2-xp88~p8f2 340187 661371 2019-12-02 2019-06-30 18           18               18
2725 2725 REGIONAL HEALTH LEAD-DEADWOOD HOSPITAL 61 CHARLES STREET DEADWOOD SD 57732 LAWRENCE (605) 717-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3700480 -103.7283480 0   81 46 46081 43940 Rapid City-Spearfish, SD Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-y22w.5f36-z9aq 431320 658589 2019-11-12 2019-06-30 16 2         18               18
3115 3115 JOHNSON COUNTY HOSPITAL 202 HIGH ST TECUMSEH NE 68450 JOHNSON (402) 335-3361 Critical Access Hospitals Government - Local TRUE 40.3791920 -96.1973420 0   97 31 31097         https://data.medicare.gov/resource/xubh-q36u/row-zhkd~ybts_qztb 281350 659707 2019-11-18 2019-06-30 18           18               18
3126 3126 MUENSTER MEMORIAL HOSPITAL 605 N MAPLE STREET MUENSTER TX 76252 COOKE (940) 759-2271 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.6538650 -97.3798350 0   97 48 48097 23620 Dallas-Fort Worth, TX-OK Central Cooke County https://data.medicare.gov/resource/xubh-q36u/row-tkmv_gjc7.fa5r 451335 660475 2019-12-02 2019-06-30 18           18               18
3239 3239 AVERA FLANDREAU HOSPITAL - CAH 214 NORTH PRAIRIE STREET FLANDREAU SD 57028 MOODY (605) 997-2433 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0505680 -96.5909890 0   101 46 46101         https://data.medicare.gov/resource/xubh-q36u/row-2fiy.k67h.w2yb 431310 660033 2019-11-26 2019-06-30 18           18               18
3561 3561 PIPESTONE COUNTY MEDICAL CENTER 916 4TH AVENUE SOUTHWEST PIPESTONE MN 56164 PIPESTONE (507) 825-5811 Critical Access Hospitals Government - Local TRUE 43.9910820 -96.3221070 0   117 27 27117         https://data.medicare.gov/resource/xubh-q36u/row-pzdb_wxvr-4ugg 241374 659508 2019-11-25 2019-06-30 18           18               18
3814 3814 CHI HEALTH ST MARY'S 1301 GRUNDMAN BLVD NEBRASKA CITY NE 68410 OTOE (402) 873-3321 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.6581520 -95.8621090 0   131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-6z57~cf6y.zams 281342 661042 2019-12-02 2019-06-30 18           18               18
4331 4331 GRIMES ST JOSEPH HEALTH CENTER 210 JUDSON ST NAVASOTA TX 77868 GRIMES (936) 825-6585 Critical Access Hospitals Voluntary non-profit - Church TRUE 30.3928950 -96.0771680 0   185 48 48185         https://data.medicare.gov/resource/xubh-q36u/row-ng26_s56i-assy 451322 661419 2019-11-29 2019-06-30 18           18               18
4581 4581 NOCONA GENERAL HOSPITAL 100 PARK ROAD NOCONA TX 76255 MONTAGUE (940) 825-3235 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7775590 -97.7315640 0   337 48 48337         https://data.medicare.gov/resource/xubh-q36u/row-f6j5-6zwa-5e54 450641 659541 2019-11-22 2019-06-30 18           18               18
36 36 THAYER COUNTY HEALTH SERVICES 120 PARK AVE HEBRON NE 68370 THAYER (402) 768-6041 Critical Access Hospitals Government - Local TRUE 40.1601230 -97.5932670 0   169 31 31169         https://data.medicare.gov/resource/xubh-q36u/row-b26e~mfmy~67qg 281304 660643 2019-11-27 2019-06-30 19           19               19
528 528 SOUTHERN COOS HOSPITAL & HEALTH CENTER 900 11TH STREET SE BANDON OR 97411 COOS (541) 347-2426 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1132440 -124.4024260 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-gr9r_ty5i_3jqt 381304 660285 2019-11-26 2019-06-30 19           19               19
1035 1035 HARNEY DISTRICT HOSPITAL 557 W WASHINGTON STREET BURNS OR 97720 HARNEY (541) 573-7281 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.5887230 -119.0605700 0   25 41 41025         https://data.medicare.gov/resource/xubh-q36u/row-8hhx~g735.b7ph 381307 659055 2019-11-19 2019-06-30 17 2         19               19
1728 1728 ASCENSION SACRED HEART GULF 3801 E HWY 98 PORT SAINT JOE FL 32456 GULF (850) 229-5600 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7765620 -85.2876050 0   45 12 12045 37460   Outlying Gulf County https://data.medicare.gov/resource/xubh-q36u/row-2gve.rn5c.g9tq 100313 660196 2019-11-27 2019-06-30 19           19               19
2746 2746 HANSEN FAMILY HOSPITAL 920 SOUTH OAK STREET IOWA FALLS IA 50126 HARDIN (641) 648-4631 Critical Access Hospitals Government - Local TRUE 42.5009390 -93.2623940 0   83 19 19083         https://data.medicare.gov/resource/xubh-q36u/row-ress-cfb5~zt7b 161380 661184 2019-12-12 2019-06-30 19           19               19
2853 2853 WEISER MEMORIAL HOSPITAL 645 EAST 5TH STREET WEISER ID 83672 WASHINGTON (208) 549-0370 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.2487610 -116.9617350 0   87 16 16087         https://data.medicare.gov/resource/xubh-q36u/row-e9wf-9jnf_cbd3 131307 655768 2019-11-01 2019-06-30 19           19               19
2904 2904 REGIONAL HEALTH SERVICES OF HOWARD COUNTY 235 8TH AVENUE WEST CRESCO IA 52136 HOWARD (563) 547-2101 Critical Access Hospitals Government - Local TRUE 43.3818910 -92.1177640 0   89 19 19089         https://data.medicare.gov/resource/xubh-q36u/row-cg3w~i3hb_y7gu 161328 660965 2019-12-02 2019-06-30 18           18           1   19
4590 4590 MEMORIAL HOSPITAL 224 E SECOND STREET DUMAS TX 79029 MOORE (806) 935-7171 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.8642640 -101.9710060 0   341 48 48341 20300   Central Moore County https://data.medicare.gov/resource/xubh-q36u/row-35k5-7dip~y499 451386 659901 2019-11-25 2019-06-30 16 3         19               19
921 921 CHI OAKES HOSPITAL 1200 N 7TH ST OAKES ND 58474 DICKEY (701) 742-3291 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1507960 -98.0904330 0   21 38 38021         https://data.medicare.gov/resource/xubh-q36u/row-b2w7_uuc8~i52v 351315 659999 2019-11-26 2019-06-30 20           20               20

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