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

383 rows where "filed_date" is on date 2019-05-31 sorted by countyequivalent

✎ 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, subprovider_irf_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-05-31 · 383 ✖
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
7 7 DOWN EAST COMMUNITY HOSPITAL 11 HOSPITAL DRIVE MACHIAS ME 4654 WASHINGTON (207) 255-3356 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7134110 -67.4772030 0   29 23 23029         https://data.medicare.gov/resource/xubh-q36u/row-tmd2.zxhs~phzc 201311 650481 2019-05-31 2018-12-31 25           25               25
42 42 BAPTIST HEALTH MEDICAL CENTER-STUTTGART 1703 NORTH BUERKLE ST STUTTGART AR 72160 ARKANSAS (870) 673-3511 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5177730 -91.5575720 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-rh96.h2uy.6pb9 40072 649864 2019-05-31 2018-12-31 49           49               49
127 127 RIVERSIDE SHORE MEMORIAL HOSPITAL 20480 MARKET STREET ONANCOCK VA 23417 ACCOMACK (757) 414-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6997120 -75.7209370 0   1 51 51001         https://data.medicare.gov/resource/xubh-q36u/row-w6kr~hh5i_py3g 490037 650393 2019-05-31 2018-12-31 36 10         46               46
130 130 BROADDUS HOSPITAL ASSOCIATION, INC 1 HEALTHCARE DRIVE MANSFIELD HILL PHILIPPI WV 26416 BARBOUR (304) 457-1760 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1528870 -80.0440910 0   1 54 54001         https://data.medicare.gov/resource/xubh-q36u/row-njqv~ij6d.yec2 511300 650429 2019-05-31 2018-12-31 12           12       60       72
131 131 MOUNDVIEW MEMORIAL HOSPITAL AND CLINICS 402 W LAKE ST FRIENDSHIP WI 53934 ADAMS (608) 339-3331 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9739950 -89.8210260 0   1 55 55001         https://data.medicare.gov/resource/xubh-q36u/row-b3gp.589m.s6jc 521309 650550 2019-05-31 2018-12-31 25           25               25
176 176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
357 357 FRANKLIN MEMORIAL HOSPITAL 111 FRANKLIN HEALTH COMMONS FARMINGTON ME 4938 FRANKLIN (207) 778-6031 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.6251150 -70.1612440 0   7 23 23007         https://data.medicare.gov/resource/xubh-q36u/row-5fiv_edxs-8b6w 200037 650477 2019-05-31 2018-12-31 43 5         48               48
608 608 PENOBSCOT BAY MEDICAL CENTER 6 GLEN COVE DRIVE ROCKPORT ME 4856 KNOX (207) 921-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1444340 -69.0865370 0   13 23 23013         https://data.medicare.gov/resource/xubh-q36u/row-ahvj_huyh~m44w 200063 650478 2019-05-31 2018-12-31 73 8         81       84       165
685 685 LINCOLN HEALTH 35 MILES STREET DAMARISCOTTA ME 4543 LINCOLN (207) 563-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0261990 -69.5271640 0   15 23 23015         https://data.medicare.gov/resource/xubh-q36u/row-mrex~j496-ppyw 201302 650479 2019-05-31 2018-12-31 21 4         25       42       67
795 795 BATH COMMUNITY HOSPITAL 106 PARK DRIVE- PO DRAWER Z HOT SPRINGS VA 24445 BATH (540) 839-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9938900 -79.8309590 0   17 51 51017         https://data.medicare.gov/resource/xubh-q36u/row-36k3~dwrj~zvyd 491300 650420 2019-05-31 2018-12-31 14           14               14
942 942 BAPTIST HEALTH MEDICAL CENTER HEBER SPINGS 1800 BYPASS ROAD HEBER SPRINGS AR 72543 CLEBURNE (501) 887-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5065780 -92.0013190 0   23 5 5023         https://data.medicare.gov/resource/xubh-q36u/row-d26c_x5yu_6fn3 41312 651551 2019-05-31 2018-12-31 25           25               25
992 992 O'CONNOR HOSPITAL 460 ANDES ROAD DELHI NY 13753 DELAWARE (607) 746-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.2668700 -74.9168500 0   25 36 36025         https://data.medicare.gov/resource/xubh-q36u/row-we9d-4xh5_rhbv 331305 650323 2019-05-31 2018-12-31 16           16               16
1075 1075 WALDO COUNTY GENERAL HOSPITAL 118 NORTHPORT AVE BELFAST ME 4915 WALDO (207) 338-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4127590 -68.9951020 0   27 23 23027         https://data.medicare.gov/resource/xubh-q36u/row-9ec9_eza5.9s9p 201312 650482 2019-05-31 2018-12-31 21 4         25               25
1133 1133 DELTA COUNTY MEMORIAL HOSPITAL 1501 E 3RD ST DELTA CO 81416 DELTA (970) 874-7681 Acute Care Hospitals Government - Local TRUE 38.7431660 -108.0475150 0   29 8 8029         https://data.medicare.gov/resource/xubh-q36u/row-wsed.7ysa~nwhq 60071 649875 2019-05-31 2018-12-31 43 6         49               49
1480 1480 SAN JUAN HOSPITAL 380 WEST 100 NORTH MONTICELLO UT 84535 SAN JUAN (435) 587-2116 Critical Access Hospitals Government - Local TRUE 37.8738750 -109.3500620 0   37 49 49037         https://data.medicare.gov/resource/xubh-q36u/row-bwvs.75rh_updn 461308 650788 2019-05-31 2018-12-31 20 1         21               21
1620 1620 SANPETE VALLEY HOSPITAL - CAH 1100 SOUTH MEDICAL DRIVE MOUNT PLEASANT UT 84647 SANPETE (435) 462-4123 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5318030 -111.4611940 0   39 49 49039         https://data.medicare.gov/resource/xubh-q36u/row-44ik~upe5.vztv 461303 649841 2019-05-31 2018-12-31 18           18               18
1684 1684 CANDLER COUNTY HOSPITAL 400 CEDAR STREET METTER GA 30439 CANDLER (912) 685-5741 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.4070810 -82.0666080 0   43 13 13043         https://data.medicare.gov/resource/xubh-q36u/row-i22u~jvuf~casx 111334 651205 2019-05-31 2018-12-31 19 6         25               25
1819 1819 FALL RIVER HOSPITAL - CAH 1201 HIGHWAY 71 SOUTH HOT SPRINGS SD 57747 FALL RIVER (605) 745-8910 Critical Access Hospitals Government - Local TRUE 43.4183120 -103.4807830 0   47 46 46047         https://data.medicare.gov/resource/xubh-q36u/row-85xb~ejm9_5eec 431322 650784 2019-05-31 2018-12-31 25           25       48       73
1835 1835 WOODLAWN HOSPITAL 1400 E 9TH ST ROCHESTER IN 46975 FULTON (574) 223-3141 Critical Access Hospitals Government - Local TRUE 41.0617280 -86.1969730 0   49 18 18049         https://data.medicare.gov/resource/xubh-q36u/row-2dgz-xb34_49d2 151313 649096 2019-05-31 2018-12-31 21 4         25               25
1892 1892 GUNNISON VALLEY HOSPITAL 711 NORTH TAYLOR STREET GUNNISON CO 81230 GUNNISON (970) 641-1456 Critical Access Hospitals Government - Local TRUE 38.5510890 -106.9243210 0   51 8 8051         https://data.medicare.gov/resource/xubh-q36u/row-e9p4-pdcf.rn62 61320 650438 2019-05-31 2018-12-31 20           20               20
2034 2034 MANGUM REGIONAL MEDICAL CENTER 1 WICKERSHAM DRIVE MANGUM OK 73554 GREER (580) 782-3353 Critical Access Hospitals Proprietary TRUE 34.8918230 -99.5023410 0   55 40 40055         https://data.medicare.gov/resource/xubh-q36u/row-irnc.n45b.ecpm 371330 649816 2019-05-31 2018-12-31 18           18               18
2091 2091 RIVERSIDE TAPPAHANNOCK HOSPITAL 618 HOSPITAL ROAD TAPPAHANNOCK VA 22560 ESSEX (804) 443-6189 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9006680 -76.8776140 0   57 51 51057         https://data.medicare.gov/resource/xubh-q36u/row-hr4y.gpmz.tmm2 490084 650407 2019-05-31 2018-12-31 60 7         67               67
2192 2192 BIGFORK VALLEY HOSPITAL 258 PINE TREE DRIVE PO BOX 258 BIGFORK MN 56628 ITASCA (218) 743-3177 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7468850 -93.6468220 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-356c-64uf.kf5r 241316 650718 2019-05-31 2018-12-31 20           20       47       67
2193 2193 GRAND ITASCA CLINIC AND HOSPITAL 1601 GOLF COURSE ROAD GRAND RAPIDS MN 55744 ITASCA (218) 326-3401 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2210390 -93.5547160 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-2qrv~rfjc~89wf 240064 650497 2019-05-31 2018-12-31 27   9       36               36
2303 2303 GUNDERSEN PALMER LUTHERAN HOSPITAL AND CLINICS 112 JEFFERSON STREET WEST UNION IA 52175 FAYETTE (563) 422-3811 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.9676800 -91.8094770 0   65 19 19065         https://data.medicare.gov/resource/xubh-q36u/row-ybws.vtki-rsbf 161316 649581 2019-05-31 2018-12-31 25           25               25
2369 2369 HARRISON COMMUNITY HOSPITAL 951 EAST MARKET STREET CADIZ OH 43907 HARRISON (740) 942-4631 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.2572950 -80.9786400 0   67 39 39067         https://data.medicare.gov/resource/xubh-q36u/row-mhu5~ezn4.9tdn 361311 649326 2019-05-31 2018-12-31 25           25               25
2448 2448 MT SAN RAFAEL HOSPITAL 410 BENEDICTA AVE TRINIDAD CO 81082 LAS ANIMAS (719) 846-9213 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.1733800 -104.4887960 0   71 8 8071         https://data.medicare.gov/resource/xubh-q36u/row-wzww_3ykk~yfx8 61321 650245 2019-05-31 2018-12-31 25           25               25
2479 2479 GREENFIELD AREA MEDICAL CENTER 550 MIRABEAU STREET GREENFIELD OH 45123 HIGHLAND (937) 981-9400 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3493150 -83.3880080 0   71 39 39071         https://data.medicare.gov/resource/xubh-q36u/row-nrr2~cens-ua4p 361304 649325 2019-05-31 2018-12-31 25           25               25
2572 2572 HAMILTON COUNTY HOSPITAL 700 NORTH HUSER SYRACUSE KS 67878 HAMILTON (620) 384-7461 Critical Access Hospitals Government - Local TRUE 37.9846055 -101.7426286 1 ROOFTOP 75 20 20075         https://data.medicare.gov/resource/xubh-q36u/row-aubk-tw4u-vx2j 171322 649228 2019-05-31 2018-12-31 25           25               25
2651 2651 WRIGHT MEMORIAL HOSPITAL 191 IOWA BOULEVARD TRENTON MO 64683 GRUNDY (660) 359-5621 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0682750 -93.5799360 0   79 29 29079         https://data.medicare.gov/resource/xubh-q36u/row-ewb5-qskq-99ee 261309 650289 2019-05-31 2018-12-31 21           21               21
2810 2810 THREE RIVERS HOSPITAL 451 HIGHWAY 13 SOUTH WAVERLY TN 37185 HUMPHREYS (931) 296-4203 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.0750570 -87.7927410 0   85 47 47085         https://data.medicare.gov/resource/xubh-q36u/row-8juw_5v9k.hvwi 441303 651236 2019-05-31 2018-12-31 25           25               25
3027 3027 MELISSA MEMORIAL HOSPITAL 1001 E JOHNSON ST HOLYOKE CO 80734 PHILLIPS (970) 854-2241 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.5784280 -102.2902490 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-6wcd-peh6-fsnb 61305 650244 2019-05-31 2018-12-31 15           15               15
3028 3028 HAXTUN HOSPITAL DISTRICT 235 W FLETCHER ST HAXTUN CO 80731 PHILLIPS (970) 774-6123 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6413860 -102.6308660 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-amj6-3hms~eqap 61304 649172 2019-05-31 2018-12-31 25           25               25
3138 3138 PROWERS MEDICAL CENTER 401 KENDALL DR LAMAR CO 81052 PROWERS (719) 336-4343 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.0709150 -102.6090680 0   99 8 8099         https://data.medicare.gov/resource/xubh-q36u/row-g7ky~tb82~a5bh 61323 650118 2019-05-31 2018-12-31 25           25               25
3170 3170 BENEFIS TETON MEDICAL CENTER 915 4TH ST NW CHOTEAU MT 59422 TETON (406) 466-5763 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.8134200 -112.1924570 0   99 30 30099         https://data.medicare.gov/resource/xubh-q36u/row-f2z3-5ua9~t2zq 271307 650727 2019-05-31 2018-12-31 25           25               25
3178 3178 ARBUCKLE MEMORIAL HOSPITAL AUTHORITY 2011 WEST BROADWAY SULPHUR OK 73086 MURRAY (580) 622-2161 Critical Access Hospitals Government - Local TRUE 34.5063330 -96.9960050 0   99 40 40099         https://data.medicare.gov/resource/xubh-q36u/row-k94n_jt84~krmu 371328 648757 2019-05-31 2018-12-31 25           25               25
3207 3207 MURRAY COUNTY MEMORIAL HOSPITAL 2042 JUNIPER AVENUE SLAYTON MN 56172 MURRAY (507) 836-6111 Critical Access Hospitals Government - Local TRUE 43.9927950 -95.7592260 0   101 27 27101         https://data.medicare.gov/resource/xubh-q36u/row-k8xk~tvdp~cidg 241319 650719 2019-05-31 2018-12-31 20           20               20
3247 3247 RANGELY DISTRICT HOSPITAL 225 EAGLE CREST ST RANGELY CO 81648 RIO BLANCO (970) 675-5011 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0802840 -108.8059100 0   103 8 8103         https://data.medicare.gov/resource/xubh-q36u/row-8932~ad3b_gnnd 61307 650116 2019-05-31 2018-12-31 25           25               25
3288 3288 STILLWATER MEDICAL - PERRY 501 N 14TH ST PERRY OK 73077 NOBLE (580) 336-3541 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.2890830 -97.2992290 0   103 40 40103         https://data.medicare.gov/resource/xubh-q36u/row-tnyg~f2xi.p77c 370139 649663 2019-05-31 2018-12-31 26           26               26
3297 3297 TRINITY HOSPITAL 60 EASTER AVENUE WEAVERVILLE CA 96093 TRINITY (530) 623-5541 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.7375790 -122.9394440 0   105 6 6105         https://data.medicare.gov/resource/xubh-q36u/row-yq5n_hvzx.n2t3 51315 650664 2019-05-31 2018-12-31 25           25       23       48
3540 3540 ENDLESS MOUNTAINS HEALTH SYSTEMS 100 HOSPITAL DRIVE MONTROSE PA 18801 SUSQUEHANNA (570) 278-3801 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.8357300 -75.8369780 0   115 42 42115         https://data.medicare.gov/resource/xubh-q36u/row-h7jz~8upv_p2yw 391306 650204 2019-05-31 2018-12-31 25           25               25
3563 3563 HEDRICK MEDICAL CENTER 2799 NORTH WASHINGTON STREET CHILLICOTHE MO 64601 LIVINGSTON (660) 646-1480 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.8161250 -93.5527810 0   117 29 29117         https://data.medicare.gov/resource/xubh-q36u/row-n2xy~itzh-95bc 261321 650290 2019-05-31 2018-12-31 25           25               25
3651 3651 WYOMING COUNTY COMMUNITY HOSPITAL 400 NORTH MAIN STREET WARSAW NY 14569 WYOMING (585) 786-2233 Acute Care Hospitals Government - Local TRUE 42.7534470 -78.1325330 0   121 36 36121         https://data.medicare.gov/resource/xubh-q36u/row-4dfp-x42q-zvqb 330008 650734 2019-05-31 2018-12-31 45 5         50 12     138       200
3675 3675 PERRY COUNTY MEMORIAL HOSPITAL 8885 SR 237 TELL CITY IN 47586 PERRY (812) 547-7011 Critical Access Hospitals Voluntary non-profit - Other TRUE 37.9686500 -86.7295610 0   123 18 18123         https://data.medicare.gov/resource/xubh-q36u/row-pe53_e9y4-bfgv 151322 649098 2019-05-31 2018-12-31 21 4         25               25
3699 3699 GUNDERSEN ST JOSEPHS HOSPITAL AND CLINICS 400 WATER AVE HILLSBORO WI 54634 VERNON (608) 489-8000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6488140 -90.3444700 0   123 55 55123         https://data.medicare.gov/resource/xubh-q36u/row-a2cr_aphd.sds7 521304 650549 2019-05-31 2018-12-31 25           25               25
3704 3704 LAKE BUTLER HOSPITAL 850 E MAIN ST LAKE BUTLER FL 32054 UNION (386) 496-2323 Critical Access Hospitals Proprietary TRUE 30.0236030 -82.3274330 0   125 12 12125         https://data.medicare.gov/resource/xubh-q36u/row-rej7-beh4~2wb4 101303 651512 2019-05-31 2018-12-31 25           25               25
3816 3816 ADENA PIKE MEDICAL CENTER 100 DAWN LANE WAVERLY OH 45690 PIKE (740) 947-2186 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1165050 -83.0058270 0   131 39 39131         https://data.medicare.gov/resource/xubh-q36u/row-zm47~vagh-p87t 361334 649331 2019-05-31 2018-12-31 25           25               25
3828 3828 NEOSHO MEMORIAL REGIONAL MEDICAL CENTER 629 SOUTH PLUMMER CHANUTE KS 66720 NEOSHO (620) 431-4000 Critical Access Hospitals Government - Local TRUE 37.6751800 -95.4708960 0   133 20 20133         https://data.medicare.gov/resource/xubh-q36u/row-bqsi.4ak9-dfb2 171380 649232 2019-05-31 2018-12-31 17 5         22               22
4118 4118 RICHLAND MEMORIAL HOSPITAL 800 EAST LOCUST OLNEY IL 62450 RICHLAND (618) 395-2131 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7350210 -88.0771250 0   159 17 17159         https://data.medicare.gov/resource/xubh-q36u/row-eyzt.rcvc_7m7k 140147 650123 2019-05-31 2018-12-31 39 8         47       34   1   82
4119 4119 INDIANA UNIVERSITY HEALTH TIPTON HOSPITAL INC 1000 S MAIN ST TIPTON IN 46072 TIPTON (765) 675-8500 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.2722160 -86.0411020 0   159 18 18159         https://data.medicare.gov/resource/xubh-q36u/row-ftnn_v67c-ywr5 151311 649095 2019-05-31 2018-12-31 25           25               25
4404 4404 HANOVER HOSPITAL 205 S HANOVER STREET HANOVER KS 66945 WASHINGTON (785) 337-2214 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.8910470 -96.8747710 0   201 20 20201         https://data.medicare.gov/resource/xubh-q36u/row-8nv9.9895.yp5i 171365 649230 2019-05-31 2018-12-31 25           25               25
4520 4520 OPTIM MEDICAL CENTER - SCREVEN 215 MIMS ROAD SYLVANIA GA 30467 SCREVEN (912) 564-7426 Critical Access Hospitals Proprietary TRUE 32.7501600 -81.6459370 0   251 13 13251         https://data.medicare.gov/resource/xubh-q36u/row-aesx-wury_ra8f 111312 651202 2019-05-31 2018-12-31 25           25               25
4533 4533 OPTIM MEDICAL CENTER - TATTNALL 247 S MAIN STREET REIDSVILLE GA 30453 TATTNALL (912) 557-1000 Critical Access Hospitals Proprietary TRUE 32.0806490 -82.1110420 0   267 13 13267         https://data.medicare.gov/resource/xubh-q36u/row-g732.aahv_uv3n 111323 651204 2019-05-31 2018-12-31 25           25               25
4546 4546 LAVACA MEDICAL CENTER 1400 NORTH TEXANA STREET HALLETTSVILLE TX 77964 LAVACA (361) 798-3671 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.4571450 -96.9398770 0   285 48 48285         https://data.medicare.gov/resource/xubh-q36u/row-wjtg_etrx~yntz 451376 649677 2019-05-31 2018-12-31 25           25               25
4662 4662 THROCKMORTON COUNTY MEMORIAL HOSPITAL 802 N MINTER AVENUE THROCKMORTON TX 76483 THROCKMORTON (940) 849-2151 Critical Access Hospitals Government - Local TRUE 33.1896520 -99.1772780 0   447 48 48447         https://data.medicare.gov/resource/xubh-q36u/row-ckdk-2pw4-m4du 451339 649839 2019-05-31 2018-12-31 14           14               14
85 85 TREASURE VALLEY HOSPITAL 8800 WEST EMERALD STREET BOISE ID 83704 ADA (208) 373-5000 Acute Care Hospitals Proprietary FALSE 43.6112890 -116.2903320 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-egh2.u29a~s2jf 130063 650684 2019-05-31 2018-12-31 9           9               9
58 58 PLATTE VALLEY MEDICAL CENTER 1600 PRAIRIE CENTER PKWY BRIGHTON CO 80601 ADAMS (303) 498-1601 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9654410 -104.7709240 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-nf6e_r5cw.zmhy 60004 648669 2019-05-31 2018-12-31 65 8         89               89
61 61 NORTH SUBURBAN MEDICAL CENTER 9191 GRANT ST THORNTON CO 80229 ADAMS (303) 451-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8643800 -104.9847830 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-tvxk_43rk.h2qn 60065 649402 2019-05-31 2018-12-31 111 16         127               127
129 129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
248 248 MARTHA JEFFERSON HOSPITAL 500 MARTHA JEFFERSON DRIVE CHARLOTTESVILLE VA 22911 ALBEMARLE (434) 654-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.0251060 -78.4448550 0   3 51 51003 16820   Central Albemarle County https://data.medicare.gov/resource/xubh-q36u/row-wyg5~56zu_3ctd 490077 650406 2019-05-31 2018-12-31 138 12         150               150
391 391 ANMED HEALTH 800 N FANT ST ANDERSON SC 29621 ANDERSON (864) 512-2830 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5110710 -82.6473550 0   7 45 45007 24860 Greenville-Spartanburg-Anderson, SC Outlying Anderson County https://data.medicare.gov/resource/xubh-q36u/row-7pgs~6cv2_uh8s 420027 650366 2019-05-31 2018-12-31 327 25 15       367 29             396
320 320 WOODLAND HEIGHTS MEDICAL CENTER 505 SOUTH JOHN REDDITT DRIVE LUFKIN TX 75904 ANGELINA (936) 634-8311 Acute Care Hospitals Proprietary TRUE 31.3277370 -94.7561390 0   5 48 48005 31260   Central Angelina County https://data.medicare.gov/resource/xubh-q36u/row-2twc-7b9d-f8nh 450484 649671 2019-05-31 2018-12-31 115 15         145               145
260 260 MEDICAL CENTER OF AURORA, THE 1501 S POTOMAC ST AURORA CO 80012 ARAPAHOE (303) 873-5511 Acute Care Hospitals Proprietary TRUE 39.6893460 -104.8311500 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-b8kj.p6xy-3gvh 60100 648892 2019-05-31 2018-12-31 250 45       14 309 20             329
663 663 HOSPITAL DR SUSONI INC 55 PALM ST ARECIBO PR 614 ARECIBO (787) 650-1031 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.4726154 -66.7164601 1 APPROXIMATE 13 72 72013 11640 San Juan-Carolina, PR Central Arecibo Municipio https://data.medicare.gov/resource/xubh-q36u/row-sxrh-3iek~wydv 400117 648863 2019-05-31 2018-12-31 114 6         120               120
106 106 SHORE MEDICAL CENTER 100 MEDICAL CENTER WAY SOMERS POINT NJ 8244 ATLANTIC (609) 653-3545 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3146730 -74.5927720 0   1 34 34001 12100 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Atlantic County https://data.medicare.gov/resource/xubh-q36u/row-yjds-updz~uqtp 310047 650505 2019-05-31 2018-12-31 183 16         199               199
525 525 GRAND LAKE HEALTH SYSTEM 200 SAINT CLAIR STREET SAINT MARYS OH 45885 AUGLAIZE (419) 394-3335 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5451390 -84.3698360 0   11 39 39011 47540 Lima-Van Wert-Celina, OH Central Auglaize County https://data.medicare.gov/resource/xubh-q36u/row-98z6_ymvq~u2mi 360032 649307 2019-05-31 2018-12-31 30 6         36 12 4   15       67
273 273 COLUMBUS REGIONAL HOSPITAL 2400 E 17TH ST COLUMBUS IN 47201 BARTHOLOMEW (812) 379-4441 Acute Care Hospitals Government - Local TRUE 39.2158720 -85.8968540 0   5 18 18005 18020 Indianapolis-Carmel-Muncie, IN Central Bartholomew County https://data.medicare.gov/resource/xubh-q36u/row-u4i5.cqhh_8kd8 150112 649209 2019-05-31 2018-12-31 194 17         211   18           229
258 258 BAXTER REGIONAL MEDICAL CENTER 624 HOSPITAL DRIVE MOUNTAIN HOME AR 72653 BAXTER (870) 508-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3430670 -92.3959050 0   5 5 5005 34260   Central Baxter County https://data.medicare.gov/resource/xubh-q36u/row-pjhy~i9v2.r6ud 40027 650559 2019-05-31 2018-12-31 153 17         170 19 23       12   224
268 268 ASCENSION SACRED HEART BAY 615 N BONITA AVE PANAMA CITY FL 32401 BAY (850) 769-1511 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.1596810 -85.6470670 0   5 12 12005 37460   Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-sfb2_87vw-qbr7 100026 650248 2019-05-31 2018-12-31 236 57         293               293
938 938 HIMA SAN PABLO BAYAMON 70 CALLE SANTA CRUZ BAYAMON PR 961 BAYAMON (787) 620-4747 Acute Care Hospitals Proprietary TRUE 18.3976640 -66.1496740 0   21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-gt9f-5hpz-5v3k 400109 650772 2019-05-31 2018-12-31 290 39 7       336               336
648 648 HILTON HEAD REGIONAL MEDICAL CENTER 25 HOSPITAL CENTER BLVD HILTON HEAD ISLAND SC 29925 BEAUFORT (843) 681-6122 Acute Care Hospitals Proprietary TRUE 32.2193200 -80.7125000 0   13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-twij.hnjd-wm9w 420080 651483 2019-05-31 2018-12-31 81 12         93               93
326 326 PROSSER MEMORIAL HOSPITAL 723 MEMORIAL STREET PROSSER WA 99350 BENTON (509) 786-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.2076300 -119.7635020 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-jxdy-bhag~5gk3 501312 652444 2019-05-31 2018-12-31 25           25               25
213 213 ENGLEWOOD HOSPITAL AND MEDICAL CENTER 350 ENGLE ST ENGLEWOOD NJ 7631 BERGEN (201) 894-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9028550 -73.9679930 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-veb2-ksdy_macn 310045 650180 2019-05-31 2018-12-31 238 26       11 275 14             289
1180 1180 UNIVERSITY HEALTH SYSTEM 4502 MEDICAL DR SAN ANTONIO TX 78229 BEXAR (210) 358-2637 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5094880 -98.5770620 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-a5b3.8n6m-4vq3 450213 651423 2019-05-31 2018-12-31 460 20     44   606   27           633
1184 1184 METHODIST AMBULATORY SURGERY HOSPITAL NW 9150 HUEBNER RD SUITE 100 SAN ANTONIO TX 78240 BEXAR (210) 575-5000 Acute Care Hospitals Proprietary TRUE 29.5276050 -98.5959950 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-f26r~6776-r3st 450780 650209 2019-05-31 2018-12-31 22           22               22
819 819 MOUNTAIN VIEW HOSPITAL 2325 CORONADO STREET IDAHO FALLS ID 83404 BONNEVILLE (208) 557-2700 Acute Care Hospitals Physician FALSE 43.4725240 -111.9887170 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-4xx8-2i4p-wi9n 130065 649556 2019-05-31 2018-12-31 41           41               41
503 503 WITHAM HEALTH SERVICES 2605 N LEBANON ST LEBANON IN 46052 BOONE (765) 485-8000 Acute Care Hospitals Government - Local TRUE 40.0769090 -86.4752090 0   11 18 18011 26900 Indianapolis-Carmel-Muncie, IN Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-gfq5-5jsq-rtmb 150104 649208 2019-05-31 2018-12-31 60 8         68 10     18       96
840 840 BOONE HOSPITAL CENTER 1600 E BROADWAY COLUMBIA MO 65201 BOONE (573) 815-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9506690 -92.3170390 0   19 29 29019 17860 Columbia-Moberly-Mexico, MO Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-f55k.gvub.hupa 260068 649281 2019-05-31 2018-12-31 282 32       21 335   15           350
1673 1673 PHYSICIANS CENTRE,THE 3131 UNIVERSITY DRIVE EAST BRYAN TX 77802 BRAZOS (979) 731-3100 Acute Care Hospitals Proprietary TRUE 30.6495850 -96.2965150 0   41 48 48041 17780   Central Brazos County https://data.medicare.gov/resource/xubh-q36u/row-hv3y_nxcx-fin2 450834 649964 2019-05-31 2018-12-31 16           16               16
416 416 STEWARD ROCKLEDGE HOSPITAL 110 LONGWOOD AVE ROCKLEDGE FL 32955 BREVARD (321) 637-2603 Acute Care Hospitals Proprietary TRUE 28.3345400 -80.7231330 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-tbme~t6bb.jqha 100092 649413 2019-05-31 2018-12-31 243 31         274 24             298
417 417 STEWARD MELBOURNE HOSPITAL 250 NORTH WICKHAM ROAD MELBOURNE FL 32935 BREVARD (321) 752-1200 Acute Care Hospitals Proprietary TRUE 28.1098040 -80.6726100 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-fnh8.cjxx_ncpd 100291 649425 2019-05-31 2018-12-31 101 12         113               113
287 287 MORTON HOSPITAL 88 WASHINGTON STREET TAUNTON MA 2780 BRISTOL (508) 828-7000 Acute Care Hospitals Proprietary TRUE 41.9055830 -71.0943500 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-648n_jcsm_qayn 220073 650488 2019-05-31 2018-12-31 81 12         93 19             112
289 289 SAINT ANNE'S HOSPITAL 795 MIDDLE STREET FALL RIVER MA 2721 BRISTOL (508) 674-5600 Acute Care Hospitals Proprietary TRUE 41.6933210 -71.1636420 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-kxda_mnxm~imp3 220020 650486 2019-05-31 2018-12-31 163 12         175 31             206
486 486 NORTHWEST MEDICAL CENTER 2801 N STATE RD 7 MARGATE FL 33063 BROWARD (954) 974-0400 Acute Care Hospitals Proprietary TRUE 26.2629030 -80.2019050 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-e825~y5d2-68se 100189 649421 2019-05-31 2018-12-31 193 24       11 228               228
849 849 NOVANT HEALTH BRUNSWICK MEDICAL CENTER 1 MEDICAL CENTER DR PO BOX 139 SUPPLY NC 28462 BRUNSWICK (910) 755-8121 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.0090920 -78.2899230 0   19 37 37019 34820 Myrtle Beach-Conway, SC-NC Central Brunswick County https://data.medicare.gov/resource/xubh-q36u/row-6hdf-qvep.ppy9 340158 650348 2019-05-31 2018-12-31 42 19         61               61
784 784 LOWER BUCKS HOSPITAL 501 BATH ROAD BRISTOL PA 19007 BUCKS (215) 785-9200 Acute Care Hospitals Proprietary TRUE 40.1040650 -74.8646260 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-3pai_t2mu_egih 390070 651661 2019-05-31 2018-12-31 108 22         130 45             175
342 342 ADVENTIST HEALTH FEATHER RIVER 5974 PENTZ ROAD PARADISE CA 95969 BUTTE (530) 877-9361 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7561610 -121.5723050 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-dx3c~3bgg.9vjq 50225 659201 2019-05-31 2018-12-31                              
322 322 LOGAN REGIONAL HOSPITAL 500 EAST 1400 NORTH LOGAN UT 84341 CACHE (435) 716-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7574610 -111.8228770 0   5 49 49005 30860   Central Cache County https://data.medicare.gov/resource/xubh-q36u/row-248k.jdp3-ibnu 460015 649977 2019-05-31 2018-12-31 83 14       33 130 7     14       151
1057 1057 HIMA SAN PABLO-CAGUAS AVE LUIS MUNOZ MARIN CAGUAS PR 725 CAGUAS (787) 653-3434 Acute Care Hospitals Proprietary TRUE 18.2270107 -66.0273180 1 GEOMETRIC_CENTER 25 72 72025 41980 San Juan-Carolina, PR Central Caguas Municipio https://data.medicare.gov/resource/xubh-q36u/row-7siz.yb89_3gij 400120 649347 2019-05-31 2018-12-31 394 46         440               440
372 372 COOPER UNIVERSITY HOSPITAL 1 COOPER PLAZA CAMDEN NJ 8103 CAMDEN (856) 342-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9408020 -75.1157570 0   7 34 34007 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Camden County https://data.medicare.gov/resource/xubh-q36u/row-nkr7.hdmt_ja2d 310014 649466 2019-05-31 2018-12-31 483 30 12       574               574
454 454 CAPE REGIONAL MEDICAL CENTER INC TWO STONE HARBOR BLVD CAPE MAY COURT HOUSE NJ 8210 CAPE MAY (609) 463-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0875407 -74.8169302 1 ROOFTOP 9 34 34009 36140 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Cape May County https://data.medicare.gov/resource/xubh-q36u/row-rka3_zh3w_qfu4 310011 649928 2019-05-31 2018-12-31 133 16         149               149
4731 4731 CARSON TAHOE REGIONAL MEDICAL CENTER 1600 MEDICAL PARKWAY CARSON CITY NV 89703 CARSON CITY (775) 445-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2018990 -119.7817290 0   510 32 32510 16180 Reno-Carson City-Fernley, NV Central Carson City https://data.medicare.gov/resource/xubh-q36u/row-r9kk~qdv6~axip 290019 649923 2019-05-31 2018-12-31 151 24         175 36             211
522 522 AUBURN COMMUNITY HOSPITAL 17 LANSING STREET AUBURN NY 13021 CAYUGA (315) 255-7011 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9407610 -76.5646070 0   11 36 36011 12180 Syracuse-Auburn, NY Central Cayuga County https://data.medicare.gov/resource/xubh-q36u/row-7wyc_jst8-xyh7 330235 650319 2019-05-31 2018-12-31 71   14       85 14     80       179
821 821 THE CARLE FOUNDATION HOSPITAL 611 WEST PARK STREET URBANA IL 61801 CHAMPAIGN (217) 383-3311 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1174230 -88.2138880 0   19 17 17019 16580   Central Champaign County https://data.medicare.gov/resource/xubh-q36u/row-irc8~hqw6~45fp 140091 650122 2019-05-31 2018-12-31 328   12   26   391   20           411
862 862 EAST COOPER MEDICAL CENTER 2000 HOSPITAL DR MOUNT PLEASANT SC 29464 CHARLESTON (843) 881-0100 Acute Care Hospitals Proprietary TRUE 32.8209970 -79.8496130 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-a8up_sjrm.scy3 420089 648981 2019-05-31 2018-12-31 118 12         130               130
637 637 WESTFIELD MEMORIAL HOSPITAL, INC 189 EAST MAIN STREET WESTFIELD NY 14787 CHAUTAUQUA (716) 326-4921 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3279010 -79.5693970 0   13 36 36013 27460   Central Chautauqua County https://data.medicare.gov/resource/xubh-q36u/row-vwk8~gn4h~53q8 330166 650743 2019-05-31 2018-12-31 4           4               4
396 396 CONFLUENCE HEALTH- WENATCHEE VALLEY HOSP & CLINICS 820 NORTH CHELAN AVENUE WENATCHEE WA 98801 CHELAN (509) 663-8711 Acute Care Hospitals Voluntary non-profit - Private FALSE 47.4335660 -120.3219830 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-aiqi_mn7n_vecf 500148 650791 2019-05-31 2018-12-31 11           11   9           20
1337 1337 CHIPPEWA COUNTY WAR MEMORIAL HOSPITAL 500 OSBORN BLVD SAULT SAINTE MARIE MI 49783 CHIPPEWA (906) 635-4460 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.4980990 -84.3495130 0   33 26 26033 42300   Central Chippewa County https://data.medicare.gov/resource/xubh-q36u/row-eftg-z8w4.heur 230239 649610 2019-05-31 2018-12-31 43 6         49 20     51       120
1021 1021 FAIRVIEW LAKES MEDICAL CENTER 5200 FAIRVIEW BOULEVARD WYOMING MN 55092 CHISAGO (763) 389-6481 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.3222670 -92.9984660 0   25 27 27025 33460 Minneapolis-St. Paul, MN-WI Outlying Chisago County https://data.medicare.gov/resource/xubh-q36u/row-ikkv.xzb8-j7fx 240050 650496 2019-05-31 2018-12-31 45 10         55               55
1781 1781 JENNIE STUART MEDICAL CENTER 320 WEST 18TH STREET HOPKINSVILLE KY 42240 CHRISTIAN (270) 887-0100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8604430 -87.4956680 0   47 21 21047 17300   Outlying Christian County https://data.medicare.gov/resource/xubh-q36u/row-ej5h.uz4s.tihd 180051 649237 2019-05-31 2018-12-31 111 18         133               133

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