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

286 rows where "filed_date" is on date 2019-11-27 sorted by acute_beds

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_irf_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date)

  • 2019-11-27 · 286
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
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
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
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 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 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 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
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
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 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
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
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
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 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 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
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
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
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 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 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
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 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
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
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 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 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
3874 ESSENTIA HEALTH NORTHERN PINES MEDICAL CENTER 5211 HIGHWAY 110 AURORA MN 55705 ST. LOUIS (218) 229-4222 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.5172120 -92.2296870 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-shqb_564u.ru74 241340 661024 2019-11-27 2019-06-30 16           16       33       49
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
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
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
2048 TAHOE FOREST HOSPITAL 10121 PINE AVE TRUCKEE CA 96161 NEVADA (530) 587-6011 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.3251630 -120.2013440 0   57 6 6057 46020 Sacramento-Roseville, CA Central Nevada County https://data.medicare.gov/resource/xubh-q36u/row-n6zm-373j_a9uq 51328 661144 2019-11-27 2019-06-30 19 6         25       37       62
3642 BARBOURVILLE ARH HOSPITAL 80 HOSPITAL DRIVE BARBOURVILLE KY 40906 KNOX (606) 546-4175 Critical Access Hospitals Government - Local TRUE 36.8523100 -83.8715200 0   121 21 21121 30940   Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-bv2i-ez4s_feje 181328 660569 2019-11-27 2019-06-30 19 6         25               25
1164 MARY HURLEY HOSPITAL 6 NORTH COVINGTON COALGATE OK 74538 COAL (580) 927-2327 Critical Access Hospitals Proprietary TRUE 34.5392220 -96.2242870 0   29 40 40029         https://data.medicare.gov/resource/xubh-q36u/row-vgqy-nnxi.ph5t 371319 661388 2019-11-27 2019-06-30 20           20               20
2161 ST ANTHONY HOSPITAL 2801 ST ANTHONY WAY PENDLETON OR 97801 UMATILLA (541) 276-5121 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.6482496 -118.8124252 1 ROOFTOP 59 41 41059 25840   Central Umatilla County https://data.medicare.gov/resource/xubh-q36u/row-hwf6-ji7m-72j9 381319 660288 2019-11-27 2019-06-30 20 5         25               25
2184 MERCYONE DYERSVILLE MEDICAL CENTER 1111 3RD STREET SW DYERSVILLE IA 52040 DUBUQUE (563) 875-7101 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4759240 -91.1296320 0   61 19 19061 20220   Central Dubuque County https://data.medicare.gov/resource/xubh-q36u/row-erwi.dcvk.sxse 161378 660547 2019-11-27 2019-06-30 20           20               20
945 REDWOOD MEMORIAL HOSPITAL 3300 RENNER DRIVE FORTUNA CA 95540 HUMBOLDT (707) 445-8121 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.5830710 -124.1359420 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-npjr_8pdg.y2ky 51318 662486 2019-11-27 2019-06-30 21 4         25               25
1553 CHATHAM HOSPITAL INC 475 PROGRESS BLVD SILER CITY NC 27344 CHATHAM (919) 799-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.7235100 -79.4222610 0   37 37 37037 20500 Raleigh-Durham-Chapel Hill, NC Central Chatham County https://data.medicare.gov/resource/xubh-q36u/row-7ygq~q73i.83q4 341311 660655 2019-11-27 2019-06-30 21 4         25               25
2382 ASPIRUS LANGLADE HOSPITAL 112 E FIFTH AVE ANTIGO WI 54409 LANGLADE (715) 623-2331 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.1403190 -89.1402920 0   67 55 55067         https://data.medicare.gov/resource/xubh-q36u/row-fn2s~3kqd.84yg 521350 661688 2019-11-27 2019-06-30 21 4         25               25
2460 MCDOWELL ARH HOSPITAL 9879 KENTUCKY ROUTE 122 MC DOWELL KY 41647 FLOYD (606) 377-3400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.4571740 -82.7472640 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-igz6~ps78.wjtc 181331 661515 2019-11-27 2019-06-30 21 4         25               25
2723 GEISINGER JERSEY SHORE HOSPITAL 1020 THOMPSON STREET JERSEY SHORE PA 17740 LYCOMING (570) 398-3101 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.2016470 -77.2679560 0   81 42 42081 48700 Williamsport-Lock Haven, PA Central Lycoming County https://data.medicare.gov/resource/xubh-q36u/row-hwxb_p5vs~878w 391300 661101 2019-11-27 2019-06-30 21 4         25               25
2920 CHI ST ALEXIUS HEALTH DICKINSON 2500 FAIRWAY STREET DICKINSON ND 58601 STARK (701) 456-4000 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.8872670 -102.8205980 0   89 38 38089 19860   Central Stark County https://data.medicare.gov/resource/xubh-q36u/row-e333-s9qr~xa2s 351336 659599 2019-11-27 2019-06-30 21 4         25               25
4033 SAINT JOSEPH BEREA 305 ESTILL STREET BEREA KY 40403 MADISON (859) 986-6500 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.5747890 -84.2860440 0   151 21 21151 40080 Lexington-Fayette--Richmond--Frankfort, KY Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-j33c~3m68-qb89 181329 660998 2019-11-27 2019-06-30 21 4         25               25
1637 UCHEALTH GRANDVIEW HOSPITAL 5623 PULPIT PEAK VIEW COLORADO SPRINGS CO 80918 EL PASO (719) 272-3623 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9102620 -104.8164360 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-6gec-fw6v-ugx7 60130 660178 2019-11-27 2019-06-30 22           22               22
2160 GOOD SHEPHERD MEDICAL CENTER 610 NW 11TH STREET HERMISTON OR 97838 UMATILLA (541) 667-3400 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8461350 -119.3109500 0   59 41 41059 25840   Central Umatilla County https://data.medicare.gov/resource/xubh-q36u/row-2f95~scvq.xeyd 381325 662577 2019-11-27 2019-06-30 22 3         25               25
2249 AVERA HOLY FAMILY HOSPITAL 826 NORTH 8TH STREET ESTHERVILLE IA 51334 EMMET (712) 362-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.4105960 -94.8339560 0   63 19 19063         https://data.medicare.gov/resource/xubh-q36u/row-gfry-34vq-dsa9 161351 660978 2019-11-27 2019-06-30 22           22               22
2774 HSHS ST CLARE MEMORIAL HOSPITAL 855 S MAIN ST OCONTO FALLS WI 54154 OCONTO (920) 846-3444 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.8658990 -88.1270840 0   83 55 55083 24580 Green Bay-Shawano, WI Outlying Oconto County https://data.medicare.gov/resource/xubh-q36u/row-9z6n_ybyz-m4ye 521310 661444 2019-11-27 2019-06-30 22           22               22
870 ASCENSION OUR LADY OF VICTORY HOSPITAL 1120 PINE ST STANLEY WI 54768 CHIPPEWA (715) 644-5571 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.9553110 -90.9205640 0   19 55 55019         https://data.medicare.gov/resource/xubh-q36u/row-xzzk-sbky-rj53 521311 661445 2019-11-27 2019-06-30 24           24               24
1737 CASEY COUNTY HOSPITAL 187 WOLFORD AVENUE LIBERTY KY 42539 CASEY (606) 787-6275 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3178090 -84.9317170 0   45 21 21045         https://data.medicare.gov/resource/xubh-q36u/row-aju2-kjdy-yhzq 181309 662532 2019-11-27 2019-06-30 24           24               24
3808 NEMAHA VALLEY COMMUNITY HOSPITAL 1600 COMMUNITY DR SENECA KS 66538 NEMAHA (785) 336-6181 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.8378490 -96.0778900 0   131 20 20131         https://data.medicare.gov/resource/xubh-q36u/row-nnw7~3p7y-3e9a 171315 660552 2019-11-27 2019-06-30 24           24               24
3996 PALO ALTO COUNTY HOSPITAL 3201 1ST STREET EMMETSBURG IA 50536 PALO ALTO (712) 852-5500 Critical Access Hospitals Government - Local TRUE 43.1191910 -94.6913430 0   147 19 19147         https://data.medicare.gov/resource/xubh-q36u/row-u98n.v74q-n83i 161357 660981 2019-11-27 2019-06-30 24           24           1   47
12 CLARKE COUNTY HOSPITAL 800 S FILLMORE ST OSCEOLA IA 50213 CLARKE (641) 342-2184 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0257100 -93.7675330 0   39 19 19039         https://data.medicare.gov/resource/xubh-q36u/row-xtat~vhgt.9ane 161348 660976 2019-11-27 2019-06-30 25           25               25
33 RED BUD REGIONAL HOSPITAL 325 SPRING STREET RED BUD IL 62278 RANDOLPH (618) 282-3831 Critical Access Hospitals Proprietary TRUE 38.2096050 -89.9964080 0   157 17 17157         https://data.medicare.gov/resource/xubh-q36u/row-p29n.6wib~fbrj 141348 660526 2019-11-27 2019-06-30 25           25               25
332 CUMBERLAND MEMORIAL HOSPITAL 1110 7TH AVENUE CUMBERLAND WI 54829 BARRON (715) 822-7500 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.5309390 -92.0295920 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-r4fu_4cy5~ir4d 521353 661689 2019-11-27 2019-06-30 25           25               25
452 SPEARE MEMORIAL HOSPITAL 16 HOSPITAL ROAD PLYMOUTH NH 3264 GRAFTON (603) 536-1120 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7578860 -71.6948370 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-tpyx~4vjq_mct4 301311 661929 2019-11-27 2019-06-30 25           25               25
719 ASCENSION CALUMET HOSPITAL 614 MEMORIAL DRIVE CHILTON WI 53014 CALUMET (920) 849-2386 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0254390 -88.1543990 0   15 55 55015 11540 Appleton-Oshkosh-Neenah, WI Central Calumet County https://data.medicare.gov/resource/xubh-q36u/row-q97p-97ns_bxut 521317 661447 2019-11-27 2019-06-30 25           25               25
824 BUCHANAN COUNTY HEALTH CENTER 1600 FIRST ST EAST INDEPENDENCE IA 50644 BUCHANAN (319) 332-0999 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.4687870 -91.8750150 0   19 19 19019         https://data.medicare.gov/resource/xubh-q36u/row-cq2e.inyq-2gxf 161335 660969 2019-11-27 2019-06-30 25           25           39   64
1142 MUNSON HEALTHCARE CHARLEVOIX HOSPITAL 14700 LAKESHORE DRIVE CHARLEVOIX MI 49720 CHARLEVOIX (231) 547-4024 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.3144980 -85.2748510 1 ROOFTOP 29 26 26029         https://data.medicare.gov/resource/xubh-q36u/row-cdsd.f9cx_c7j8 231322 660601 2019-11-27 2019-06-30 25           25               25
1194 POWELL VALLEY HOSPITAL 777 AVENUE H POWELL WY 82435 PARK (307) 754-2267 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7566220 -108.7705470 0   29 56 56029         https://data.medicare.gov/resource/xubh-q36u/row-gs73_h7cj.ibeh 531310 662634 2019-11-27 2019-06-30 25           25       100       125
1344 WILLIAM BEE RIRIE HOSPITAL 1500 AVENUE H ELY NV 89301 WHITE PINE (775) 289-3001 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2560650 -114.8600860 0   33 32 32033         https://data.medicare.gov/resource/xubh-q36u/row-xg87~7vrt.qaws 291302 662548 2019-11-27 2019-06-30 25           25               25
1371 ST ELIZABETH HOSPITAL 1450 BATTERSBY AVENUE ENUMCLAW WA 98022 KING (360) 825-2505 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.2084170 -121.9881570 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-8kts.qr6u-cywi 501335 660477 2019-11-27 2019-06-30 25           25               25
1385 WELLSTAR SYLVAN GROVE HOSPITAL 1050 MCDONOUGH ROAD JACKSON GA 30233 BUTTS (770) 775-7861 Critical Access Hospitals Government - Hospital District or Authority FALSE 33.3030850 -83.9778230 0   35 13 13035 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Butts County https://data.medicare.gov/resource/xubh-q36u/row-uazj.s3pp-ngue 111319 660799 2019-11-27 2019-06-30 25           25               25
1431 GOODALL WITCHER HOSPITAL 101 POSEY AVENUE CLIFTON TX 76634 BOSQUE (254) 675-8322 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7771530 -97.5884310 0   35 48 48035         https://data.medicare.gov/resource/xubh-q36u/row-xqqi.9yb9.h6f2 451385 660476 2019-11-27 2019-06-30 25           25               25
1601 MURPHY MEDICAL CENTER INC 3990 EAST US HIGHWAY 64 ALT MURPHY NC 28906 CHEROKEE (828) 837-8161 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0731600 -83.9654240 0   39 37 37039         https://data.medicare.gov/resource/xubh-q36u/row-6u4n.7ur8_z37n 341328 660656 2019-11-27 2019-06-30 25           25               25
1718 SOUTHWEST HEALTH CENTER 1400 EAST SIDE RD PLATTEVILLE WI 53818 GRANT (608) 348-2331 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.7197810 -90.4557830 0   43 55 55043 38420   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-vwfv~jm7m_6m6b 521354 661836 2019-11-27 2019-06-30 25           25 10     78       113
1899 DAVIS COUNTY HOSPITAL 509 NORTH MADISON STREET BLOOMFIELD IA 52537 DAVIS (641) 664-2145 Critical Access Hospitals Government - Local TRUE 40.7592230 -92.4149870 0   51 19 19051 36900   Outlying Davis County https://data.medicare.gov/resource/xubh-q36u/row-m6yx_jbnt.5nnb 161327 660964 2019-11-27 2019-06-30 25           25               25
1909 HOLMES COUNTY HOSPITAL AND CLINICS 239 BOWLING GREEN ROAD LEXINGTON MS 39095 HOLMES (662) 834-1321 Critical Access Hospitals Government - State TRUE 33.1110770 -90.0297410 0   51 28 28051         https://data.medicare.gov/resource/xubh-q36u/row-bbwk_bsmz-qfyj 251319 660403 2019-11-27 2019-06-30 25           25               25
1912 LIBERTY MEDICAL CENTER 315 W MADISON AVE CHESTER MT 59522 LIBERTY (406) 759-5181 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5104970 -110.9718340 0   51 30 30051         https://data.medicare.gov/resource/xubh-q36u/row-jg4d_ys9s~wecb 271334 662543 2019-11-27 2019-06-30 25           25               25
2147 UNION COUNTY GENERAL HOSPITAL 300 WILSON STREET CLAYTON NM 88415 UNION (575) 374-7001 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.4551690 -103.1932600 0   59 35 35059         https://data.medicare.gov/resource/xubh-q36u/row-ai6a~bn84~9pvi 321304 660831 2019-11-27 2019-06-30 25           25               25
2165 AVERA HAND COUNTY MEMORIAL HOSPITAL AND CLINIC 300 W 5TH ST MILLER SD 57362 HAND (605) 853-2421 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5206230 -98.9920440 0   59 46 46059         https://data.medicare.gov/resource/xubh-q36u/row-cen8-s23k_ktis 431337 662584 2019-11-27 2019-06-30 25           25               25
2350 FLOYD COUNTY MEDICAL CENTER 800 11TH ST CHARLES CITY IA 50616 FLOYD (641) 228-6830 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.0526670 -92.6825050 0   67 19 19067         https://data.medicare.gov/resource/xubh-q36u/row-wh9h~5vd4_p9gh 161347 660975 2019-11-27 2019-06-30 25           25               25
2419 ASCENSION GOOD SAMARITAN HOSPITAL 601 S CENTER AVE MERRILL WI 54452 LINCOLN (715) 536-5511 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.1758580 -89.6830310 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-22bh-e9v4.hnpp 521339 661687 2019-11-27 2019-06-30 25           25               25
2458 ARH OUR LADY OF THE WAY 11203 MAIN STREET MARTIN KY 41649 FLOYD (606) 285-6400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.5791050 -82.7503510 0   71 21 21071         https://data.medicare.gov/resource/xubh-q36u/row-y85x_rrhk~w2dk 181305 660806 2019-11-27 2019-06-30 25           25               25
2857 JANE TODD CRAWFORD HOSPITAL 202-206 MILBY STREET GREENSBURG KY 42743 GREEN (270) 932-4211 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.2421240 -85.4963020 0   87 21 21087         https://data.medicare.gov/resource/xubh-q36u/row-yq9p-j8q9-m4wf 181325 661514 2019-11-27 2019-06-30 25           25               25
2930 SUMMERS COUNTY ARH HOSPITAL 115 SUMMERS HOSPITAL ROAD HINTON WV 25951 SUMMERS (304) 466-1000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.6747140 -80.8914500 0   89 54 54089         https://data.medicare.gov/resource/xubh-q36u/row-9aij.jkuz.8rh8 511310 660729 2019-11-27 2019-06-30 25           25               25
2960 MERCY ST FRANCIS HOSPITAL 100 WEST HIGHWAY 60, PO BOX 82 MOUNTAIN VIEW MO 65548 HOWELL (417) 934-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.0026442 -91.7032057 1 GEOMETRIC_CENTER 91 29 29091 48460   Central Howell County https://data.medicare.gov/resource/xubh-q36u/row-qxd9-2nsp_4gfe 261335 660407 2019-11-27 2019-06-30 25           25               25
2981 GRAFTON CITY HOSPITAL 1 HOSPITAL PLAZA GRAFTON WV 26354 TAYLOR (304) 265-0400 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3440370 -80.0244130 0   91 54 54091 17220   Outlying Taylor County https://data.medicare.gov/resource/xubh-q36u/row-hp88-6y9g.r8fy 511307 661124 2019-11-27 2019-06-30 25           25               25
3113 MERCY HOSPITAL CARTHAGE 3125 DR RUSSELL SMITH WAY CARTHAGE MO 64836 JASPER (417) 358-8121 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1367000 -94.3208720 0   97 29 29097 27900 Joplin-Miami, MO-OK Central Jasper County https://data.medicare.gov/resource/xubh-q36u/row-2yux-b6bx-99ya 261338 660634 2019-11-27 2019-06-30 25           25               25
3569 MARSHALL MEDICAL CENTER 1080 NORTH ELLINGTON PARKWAY LEWISBURG TN 37091 MARSHALL (931) 359-6276 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.4644210 -86.7866520 0   117 47 47117 30280 Nashville-Davidson--Murfreesboro, TN Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-kdp7~w7ma-n6wt 441309 660459 2019-11-27 2019-06-30 25           25               25
3640 MADISON COUNTY HEALTH CARE SYSTEM 300 WEST HUTCHINGS STREET WINTERSET IA 50273 MADISON (515) 462-2373 Critical Access Hospitals Government - Local TRUE 41.3288160 -94.0169630 0   121 19 19121 19780 Des Moines-Ames-West Des Moines, IA Outlying Madison County https://data.medicare.gov/resource/xubh-q36u/row-qsgk_v4q5~5yrz 161326 660963 2019-11-27 2019-06-30 25           25               25
3752 CARRIS HEALTH - REDWOOD, LLC 100 FALLWOOD ROAD REDWOOD FALLS MN 56283 REDWOOD (507) 637-4500 Critical Access Hospitals Government - Local TRUE 44.5370300 -95.1072680 0   127 27 27127         https://data.medicare.gov/resource/xubh-q36u/row-nr7s_ak8r_x54m 241351 661207 2019-11-27 2019-06-30 25           25           4   29
3851 ST FRANCIS HOSPITAL 1215 FRANCISCAN DR LITCHFIELD IL 62056 MONTGOMERY (217) 324-2191 Critical Access Hospitals Voluntary non-profit - Church TRUE 39.1808100 -89.6396360 0   135 17 17135         https://data.medicare.gov/resource/xubh-q36u/row-jacr~k2cc_qv6a 141350 660527 2019-11-27 2019-06-30 25           25               25
3968 MARSHALL BROWNING HOSPITAL 900 NORTH WASHINGTON STREET DU QUOIN IL 62832 PERRY (618) 542-2146 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.0244410 -89.2368000 0   145 17 17145         https://data.medicare.gov/resource/xubh-q36u/row-dkrg~s9bc~qdkt 141331 660524 2019-11-27 2019-06-30 25           25               25
3982 CENTRA CARE HEALTH PAYNESVILLE 200 1ST STREET WEST PAYNESVILLE MN 56362 STEARNS (320) 243-3779 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3748930 -94.7162530 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-ract.vm29~5b9c 241349 661206 2019-11-27 2019-06-30 25           25       51       76
4212 VAN BUREN COUNTY HOSPITAL 304 FRANKLIN STREET KEOSAUQUA IA 52565 VAN BUREN (319) 293-3171 Critical Access Hospitals Government - Local TRUE 40.7358620 -91.9590430 0   177 19 19177         https://data.medicare.gov/resource/xubh-q36u/row-e8fj_uhg7-i98m 161337 660970 2019-11-27 2019-06-30 25           25               25
4324 WAYNE COUNTY HOSPITAL 417 SOUTH EAST STREET CORYDON IA 50060 WAYNE (641) 872-2260 Critical Access Hospitals Government - Local TRUE 40.7544920 -93.3123200 0   185 19 19185         https://data.medicare.gov/resource/xubh-q36u/row-z889-j4w6-dfyd 161358 660982 2019-11-27 2019-06-30 25           25               25
4398 SCOTLAND COUNTY HOSPITAL 450 E SIGLER AVENUE MEMPHIS MO 63555 SCOTLAND (660) 465-8511 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.4660230 -92.1681710 0   199 29 29199         https://data.medicare.gov/resource/xubh-q36u/row-gdbv.rfmr-j5dc 261310 660633 2019-11-27 2019-06-30 25           25               25
4492 METHODIST HOSPITAL UNION COUNTY 4604 US HIGHWAY 60 WEST MORGANFIELD KY 42437 UNION (270) 389-5000 Critical Access Hospitals Voluntary non-profit - Church TRUE 37.6261140 -87.9439180 0   225 21 21225         https://data.medicare.gov/resource/xubh-q36u/row-nfzy.mkzz.8itz 181306 660568 2019-11-27 2019-06-30 25           25               25
4500 POLK MEDICAL CENTER 2360 ROCKMART HIGHWAY CEDARTOWN GA 30125 POLK (770) 748-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.0149270 -85.1950200 0   233 13 13233 16340 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-tk24_dpnr.azsj 111330 660506 2019-11-27 2019-06-30 25           25               25
1439 LONE PEAK HOSPITAL 11925 SOUTH STATE STREET DRAPER UT 84020 SALT LAKE (801) 545-8000 Acute Care Hospitals Proprietary TRUE 40.5352380 -111.8914640 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-3yfr.y4qy.386x 460060 662283 2019-11-27 2019-06-30 26 4         30               30
1668 LAKE CITY COMMUNITY HOSPITAL 258 N RON MCNAIR BLVD LAKE CITY SC 29560 FLORENCE (843) 374-2036 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8803700 -79.7590890 0   41 45 45041 22500   Central Florence County https://data.medicare.gov/resource/xubh-q36u/row-cj23~5qzh.swv8 420066 661103 2019-11-27 2019-06-30 26           26               26
2764 UPMC KANE 4372 ROUTE 6 KANE PA 16735 MC KEAN (814) 837-8585 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6734010 -78.7310250 0   83 42 42083 14620   Central McKean County https://data.medicare.gov/resource/xubh-q36u/row-jyyz.yz7i_3d9d 390104 660442 2019-11-27 2019-06-30 26 5         31               31
460 GREAT PLAINS REGIONAL MEDICAL CENTER 1801 WEST 3RD STREET ELK CITY OK 73644 BECKHAM (580) 225-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4117210 -99.4256540 0   9 40 40009 21120   Central Beckham County https://data.medicare.gov/resource/xubh-q36u/row-ygr6~ifvk~u3j8 370019 660278 2019-11-27 2019-06-30 28 6         34 12 8           54
3556 OUR LADY OF THE ANGELS HOSPITAL 433 PLAZA STREET BOGALUSA LA 70427 WASHINGTON (985) 730-6700 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.7782630 -89.8684550 0   117 22 22117 14220 New Orleans-Metairie-Hammond, LA-MS Central Washington Parish https://data.medicare.gov/resource/xubh-q36u/row-8mem_pdec.p7n5 190312 659960 2019-11-27 2019-06-30 28 8         36 12             48
4188 MUNSON HEALTHCARE CADILLAC HOSPITAL 400 HOBART ST CADILLAC MI 49601 WEXFORD (231) 876-7200 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.2461480 -85.3904560 0   165 26 26165 15620   Central Wexford County https://data.medicare.gov/resource/xubh-q36u/row-3n4e~wz2j_4rnr 230081 660587 2019-11-27 2019-06-30 29 20         49               49
3339 UCHEALTH YAMPA VALLEY MEDICAL CENTER 1024 CENTRAL PARK DR STEAMBOAT SPRINGS CO 80487 ROUTT (970) 879-1322 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4624130 -106.8144200 0   107 8 8107 44460 Steamboat Springs-Craig, CO Central Routt County https://data.medicare.gov/resource/xubh-q36u/row-qfxv.fkcz_vryr 60049 660358 2019-11-27 2019-06-30 30 4       5 39               39
4244 HSHS GOOD SHEPHERD HOSPITAL INC 200 S CEDAR ST SHELBYVILLE IL 62565 SHELBY (217) 774-3961 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4058010 -88.8071130 0   173 17 17173         https://data.medicare.gov/resource/xubh-q36u/row-rw3c-7r3v.5ma9 140019 660512 2019-11-27 2019-06-30 30           30               30
4300 WAYNE MEDICAL CENTER 103 J V MANGUBAT DR WAYNESBORO TN 38485 WAYNE (931) 722-5411 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.3253550 -87.7575330 0   181 47 47181         https://data.medicare.gov/resource/xubh-q36u/row-283m~szqb.wyui 440010 660038 2019-11-27 2019-06-30 30           30               30
19 ASCENSION ST MARYS HOSPITAL 2251 NORTH SHORE DR RHINELANDER WI 54501 ONEIDA (715) 361-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6384820 -89.3111400 0   85 55 55085         https://data.medicare.gov/resource/xubh-q36u/row-zwaq-mmw6_zwbm 520019 661677 2019-11-27 2019-06-30 32 20         52 11             63
1074 CLAIBORNE MEMORIAL MEDICAL CENTER 620 EAST COLLEGE STREET HOMER LA 71040 CLAIBORNE (318) 927-2024 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7943270 -93.0624690 0   27 22 22027         https://data.medicare.gov/resource/xubh-q36u/row-ncph.ugan.rj3n 190114 661188 2019-11-27 2019-06-30 33 4         37 10             47
1425 SAINT FRANCIS HOSPITAL VINITA, INC 735 NORTH FOREMAN STREET VINITA OK 74301 CRAIG (918) 256-7551 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6533720 -95.1556420 0   35 40 40035         https://data.medicare.gov/resource/xubh-q36u/row-bg5g~s52b_99xj 370237 659861 2019-11-27 2019-06-30 35           35 20             55
2997 SAINT JOSEPH MERCY LIVINGSTON HOSPITAL 620 BYRON RD HOWELL MI 48843 LIVINGSTON (517) 545-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.6153720 -83.9393550 0   93 26 26093 19820 Detroit-Warren-Ann Arbor, MI Outlying Livingston County https://data.medicare.gov/resource/xubh-q36u/row-ij59~ym6m-2dbe 230069 660584 2019-11-27 2019-06-30 35 8         43               43

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