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

286 rows where "filed_date" is on date 2019-11-27 sorted by icu_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, 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
12 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
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
33 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
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
73 73 SIBLEY MEMORIAL HOSPITAL 5255 LOUGHBORO RD NW WASHINGTON DC 20016 THE DISTRICT (202) 537-4680 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9357470 -77.1098890 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-yqpq-7pu8-v5vj 90005 660786 2019-11-27 2019-06-30 150   25   14   189 21     45       255
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
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
332 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
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
452 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
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
719 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
799 799 FLOYD CHEROKEE MEDICAL CENTER 400 NORTHWOOD DR CENTRE AL 35960 CHEROKEE (256) 927-5531 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1627610 -85.6514200 0   19 1 1019         https://data.medicare.gov/resource/xubh-q36u/row-wy8i.rrc6.c8zi 10022 660348 2019-11-27 2019-06-30 45           45               45
824 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
870 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
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
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
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
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
1142 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
1164 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
1194 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
1233 1233 RUSH UNIVERSITY MEDICAL CENTER 1653 WEST CONGRESS PARKWAY CHICAGO IL 60612 COOK (312) 942-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8751660 -87.6685100 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-jhqf.rc36_fwc5 140119 661160 2019-11-27 2019-06-30 387       56 55 576 67 54           697
1344 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 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 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
1393 1393 MIDMICHIGAN MEDICAL CENTER-CLARE 703 N MCEWAN ST CLARE MI 48617 CLARE (989) 802-5000 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.8207240 -84.7683490 0   35 26 26035         https://data.medicare.gov/resource/xubh-q36u/row-x95c-xq2z-tjc4 230180 661013 2019-11-27 2019-06-30 49           49               49
1425 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
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
1431 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 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
1611 1611 SACRED HEART UNIVERSITY DISTRICT 1255 HILYARD STREET EUGENE OR 97401 LANE (541) 686-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0460560 -123.0821050 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-g7vk_mpaz~eeix 380033 662243 2019-11-27 2019-06-30 40           40 35 18           93
1637 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
1668 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
1699 1699 UNIVERSITY OF MISSISSIPPI MEDICAL CENTER- GRENADA 960 AVENT DRIVE GRENADA MS 38901 GRENADA (662) 227-7000 Acute Care Hospitals Government - State TRUE 33.7633070 -89.8175320 0   43 28 28043 24980   Central Grenada County https://data.medicare.gov/resource/xubh-q36u/row-p3dc_vfsq.nigj 250168 659814 2019-11-27 2019-06-30 44   5       49               49
1700 1700 UNM SANDOVAL REGIONAL MEDICAL CENTER 3001 BROADMOOR BLVD NE RIO RANCHO NM 87144 SANDOVAL (505) 994-7402 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3073510 -106.6770030 0   43 35 35043 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Sandoval County https://data.medicare.gov/resource/xubh-q36u/row-nwre-fmi7-2c64 320089 660830 2019-11-27 2019-06-30 48           60               60
1718 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
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
1737 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
1776 1776 CHI MEMORIAL HOSPITAL- GEORGIA 100 GROSS CRESCENT CIRCLE FORT OGLETHORPE GA 30742 CATOOSA (770) 874-5400 Acute Care Hospitals Proprietary TRUE 34.9477700 -85.2627560 0   47 13 13047 16860 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Catoosa County https://data.medicare.gov/resource/xubh-q36u/row-a96y-gfhv_jnf7 110236 659941 2019-11-27 2019-06-30 36           36               36
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
1899 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 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 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
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
2064 2064 ST VINCENT FISHERS HOSPITAL INC 13861 OLIO ROAD FISHERS IN 46037 HAMILTON (317) 415-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9888520 -85.9188440 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-a5mj~2uur-2exn 150181 660945 2019-11-27 2019-06-30 46           46               46
2147 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 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
2184 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
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
2249 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
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
2350 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 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
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
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
2458 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
2510 2510 UC SAN DIEGO HEALTH HILLCREST - HILLCREST MED CTR 200 WEST ARBOR DRIVE SAN DIEGO CA 92103 SAN DIEGO (619) 543-6222 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.7537170 -117.1659140 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-2d2j.kc8f_hnd2 50025 662154 2019-11-27 2019-06-30 513   46 8 50 52 669 32             701
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
2774 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
2857 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 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
2952 2952 CHILDREN'S MERCY HOSPITAL KANSAS 5808 W 110TH STREET OVERLAND PARK KS 66211 JOHNSON (913) 234-3000 Childrens Voluntary non-profit - Private FALSE 38.9293260 -94.6535400 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-knub_mq22.2ryr 173300 660553 2019-11-27 2019-06-30 50           50               50
2960 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 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
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
3019 3019 EAST TENNESSEE CHILDRENS HOSPITAL 2018 CLINCH AVE SW KNOXVILLE TN 37916 KNOX (865) 541-8000 Childrens Voluntary non-profit - Private TRUE 35.9565290 -83.9379200 0   93 47 47093 28940 Knoxville-Morristown-Sevierville, TN Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-ni29-9izu-5p54 443303 660315 2019-11-27 2019-06-30                              
3113 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
3206 3206 MUNSON HEALTHCARE MANISTEE HOSPITAL 1465 E PARKDALE AVE MANISTEE MI 49660 MANISTEE (231) 398-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.2723550 -86.2734390 0   101 26 26101         https://data.medicare.gov/resource/xubh-q36u/row-yvaj-xucr.6ih7 230303 660597 2019-11-27 2019-06-30 45           45               45
3227 3227 PENNSYLVANIA HOSPITAL 800 SPRUCE STREET PHILADELPHIA PA 19107 PHILADELPHIA (215) 829-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9458720 -75.1558810 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-x6qz_wbzv~xjq8 390226 661254 2019-11-27 2019-06-30 324   29       403 42             445
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
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
3569 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
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
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
3640 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
3696 3696 SWEETWATER HOSPITAL ASSOCIATION 304 WRIGHT ST SWEETWATER TN 37874 MONROE (865) 213-8200 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6002500 -84.4642230 0   123 47 47123         https://data.medicare.gov/resource/xubh-q36u/row-5ifh~9uar~z3bc 440084 660313 2019-11-27 2019-06-30 59           59               59
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
3752 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
3808 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
3851 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
3860 3860 UNIVERSITY OF NORTH CAROLINA HOSPITAL 101 MANNING DRIVE CHAPEL HILL NC 27514 ORANGE (919) 966-4141 Acute Care Hospitals Government - State TRUE 35.9035510 -79.0518940 0   135 37 37135 20500 Raleigh-Durham-Chapel Hill, NC Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-pha8_ahwj~xmph 340061 660649 2019-11-27 2019-06-30 676   13       803 104 30       6   943
3874 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
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
3955 3955 SAINT FRANCIS HOSPITAL SOUTH, LLC 10501 EAST 91ST STREET SOUTH TULSA OK 74133 TULSA (918) 307-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0318900 -95.8569200 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-x34w-z8gf_tbim 370218 660431 2019-11-27 2019-06-30 88           88               88
3968 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
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
3982 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
3996 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
4007 4007 JANE PHILLIPS MEMORIAL MEDICAL CENTER, INC 3500 EAST FRANK PHILLIPS BOULEVARD BARTLESVILLE OK 74006 WASHINGTON (918) 333-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7506760 -95.9396980 0   147 40 40147 12780 Tulsa-Muskogee-Bartlesville, OK Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ygj6~udsf_zeiw 370018 659856 2019-11-27 2019-06-30 73   8       81 17 16           114
4111 4111 REGIONAL ONE HEALTH 877 JEFFERSON AVENUE MEMPHIS TN 38103 SHELBY (901) 545-7928 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.1426340 -90.0312970 0   157 47 47157 32820 Memphis-Forrest City, TN-MS-AR Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-s7c8-zbce-azfz 440152 660458 2019-11-27 2019-06-30 164     14   18 288   24   14       326
4184 4184 HARRISBURG MEDICAL CENTER 100 DOCTOR WARREN TUTTLE DR HARRISBURG IL 62946 SALINE (618) 253-7671 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.7310271 -88.5248600 1 ROOFTOP 165 17 17165         https://data.medicare.gov/resource/xubh-q36u/row-8u5r_n3xt~tnqf 140210 660516 2019-11-27 2019-06-30 40           40 30             70
4212 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
4244 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 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
4324 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
4351 4351 RANKEN JORDAN PEDIATRIC BRIDGE HOSPITAL 11365 DORSETT ROAD MARYLAND HEIGHTS MO 63043 ST. LOUIS (314) 872-6400 Childrens Voluntary non-profit - Private FALSE 38.7095000 -90.4158930 0   189 29 29189 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-dvji.ztfu-vequ 263303 660637 2019-11-27 2019-06-30 60           60               60
4398 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 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 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

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