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 subtotal_acute_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, 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
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
4587 4587 ASPIRE BEHAVIORAL HEALTH OF CONROE, LLC 2006 SOUTH LOOP 336 WEST, SUITE 500 CONROE TX 77304 MONTGOMERY (936) 647-3500 Acute Care Hospitals Physician FALSE 30.2840690 -95.4801310 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-h7u8.wg6t-a3vd 670093 651497 2019-05-31 2018-12-31 6           6 24             30
3976 3976 HEALTHSOURCE SAGINAW 3340 HOSPITAL ROAD SAGINAW MI 48603 SAGINAW (989) 790-7888 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.4564180 -84.0520480 0   145 26 26145 40980 Saginaw-Midland-Bay City, MI Central Saginaw County https://data.medicare.gov/resource/xubh-q36u/row-bnbr~xrkk.p4j7 230275 650491 2019-05-31 2018-12-31 7           7 85 38   213       343
1624 1624 CHARLESTON SURGICAL HOSPITAL 1306 KANAWHA BOULEVARD EAST CHARLESTON WV 25301 KANAWHA (304) 343-4371 Acute Care Hospitals Physician FALSE 38.3429910 -81.6306620 0   39 54 54039 16620 Charleston-Huntington-Ashland, WV-OH-KY Central Kanawha County https://data.medicare.gov/resource/xubh-q36u/row-zfdk.i8cn~ciui 510091 650428 2019-05-31 2018-12-31 8           8               8
4654 4654 USMD HOSPITAL AT FORT WORTH LP 5900 ALTAMESA BLVD FORT WORTH TX 76132 TARRANT (817) 433-9100 Acute Care Hospitals Proprietary TRUE 32.6455920 -97.4181400 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-dprz_9mav_2zjv 670046 649011 2019-05-31 2018-12-31 8           8               8
4669 4669 NORTHWEST HILLS SURGICAL HOSPITAL 6818 AUSTIN CTR BLVD SUITE 100 AUSTIN TX 78731 TRAVIS (512) 346-1994 Acute Care Hospitals Proprietary TRUE 30.3503160 -97.7510260 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-ue4n.z4gb~9nnx 450808 649834 2019-05-31 2018-12-31 8           8               8
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
2649 2649 MINNESOTA VALLEY HEALTH CENTER INC 621 SOUTH FOURTH STREET LE SUEUR MN 56058 LE SUEUR (507) 665-3375 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4541980 -93.9162670 0   79 27 27079 33460 Minneapolis-St. Paul, MN-WI Outlying Le Sueur County https://data.medicare.gov/resource/xubh-q36u/row-n2b6_pqcf_76a2 241375 650723 2019-05-31 2018-12-31 9           9       55       64
2948 2948 DOCTORS HOSPITAL LLC 4901 COLLEGE BLVD LEAWOOD KS 66211 JOHNSON (913) 529-1801 Acute Care Hospitals Proprietary FALSE 38.9274120 -94.6435000 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-g4ct-f4db-d8p3 170194 649586 2019-05-31 2018-12-31 9           9               9
2880 2880 PATIENTS' HOSPITAL OF REDDING 2900 EUREKA WAY REDDING CA 96001 SHASTA (530) 225-8700 Acute Care Hospitals Physician FALSE 40.5854900 -122.4162640 0   89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-5vur~pqci_pq3w 50697 650657 2019-05-31 2018-12-31 10           10               10
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
2736 2736 SANTA YNEZ VALLEY COTTAGE HOSPITAL 2050 VIBORG RD SOLVANG CA 93463 SANTA BARBARA (805) 688-6431 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6024650 -120.1266430 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-crjd-giis~8ixz 51331 648601 2019-05-31 2018-12-31 11           11               11
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
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
2341 2341 ANIMAS SURGICAL HOSPITAL, LLC 575 RIVERGATE LN DURANGO CO 81301 LA PLATA (970) 247-3537 Acute Care Hospitals Physician TRUE 37.2488890 -107.8707740 0   67 8 8067 20420   Central La Plata County https://data.medicare.gov/resource/xubh-q36u/row-twp9-b345.bypu 60117 650115 2019-05-31 2018-12-31 12           12               12
2947 2947 KANSAS CITY ORTHOPAEDIC INSTITUTE 3651 COLLEGE BLVD LEAWOOD KS 66211 JOHNSON (913) 319-7633 Acute Care Hospitals Physician FALSE 38.9275490 -94.6282350 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-s6dg~iufq_ybuc 170188 649225 2019-05-31 2018-12-31 12           12               12
3399 3399 SURGICAL HOSPITAL OF OKLAHOMA, LLC 100 SOUTHEAST 59TH STREET OKLAHOMA CITY OK 73129 OKLAHOMA (405) 634-9300 Acute Care Hospitals Physician TRUE 35.4062250 -97.5093160 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-drs8-u5z4.yfq6 370201 649812 2019-05-31 2018-12-31 12           12               12
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
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
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
3215 3215 ST JAMES MERCY HOSPITAL 411 CANISTEO STREET HORNELL NY 14843 STEUBEN (607) 324-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.3145750 -77.6601420 0   101 36 36101 18500 Elmira-Corning, NY Central Steuben County https://data.medicare.gov/resource/xubh-q36u/row-584q-nx3f-g76t 330151 650302 2019-05-31 2018-12-31 15           15               15
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
1326 1326 SURGICAL SPECIALTY CENTER OF BATON ROUGE 8080 BLUEBONNET BLVD BATON ROUGE LA 70810 E. BATON ROUGE (225) 408-8080 Acute Care Hospitals Physician FALSE 30.3765650 -91.0993330 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-vta2_xzya~pwww 190251 648928 2019-05-31 2018-12-31 16           16               16
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
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
1628 1628 RIPON MEDICAL CENTER 845 PARKSIDE ST RIPON WI 54971 FOND DU LAC (920) 748-3101 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8354510 -88.8176920 0   39 55 55039 22540   Central Fond du Lac County https://data.medicare.gov/resource/xubh-q36u/row-677e~kc7g-58mt 521321 650552 2019-05-31 2018-12-31 15 3         18               18
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
2900 2900 PINNACLE HOSPITAL 9301 CONNECTICUT DR CROWN POINT IN 46307 LAKE (219) 756-2100 Acute Care Hospitals Physician FALSE 41.4491180 -87.3300690 0   89 18 18089 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-eygb~yded_6pv4 150166 649212 2019-05-31 2018-12-31 16 2         18               18
3330 3330 EDGERTON HOSPITAL AND HEALTH SERVICES 11101 N SHERMAN ROAD EDGERTON WI 53534 ROCK (608) 884-3441 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8348720 -89.0430240 0   105 55 55105 27500 Madison-Janesville-Beloit, WI Central Rock County https://data.medicare.gov/resource/xubh-q36u/row-rkcx-pybj.z58v 521319 650551 2019-05-31 2018-12-31 18           18               18
3641 3641 MIAMI COUNTY MEDICAL CENTER 2100 BAPTISTE DRIVE PAOLA KS 66071 MIAMI (913) 557-4385 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5685910 -94.8508490 0   121 20 20121 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Miami County https://data.medicare.gov/resource/xubh-q36u/row-m2fa-y2r7.cfsg 170109 649585 2019-05-31 2018-12-31 18           18               18
1126 1126 ADVENTIST HEALTH TEHACHAPI VALLEY 1100 MAGELLAN TEHACHAPI CA 93561 KERN (661) 823-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1474419 -118.4504364 1 ROOFTOP 29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-xx6n.a25c~74jx 51301 648598 2019-05-31 2018-12-31 16 4         20               20
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
1936 1936 NEWPORT COMMUNITY HOSPITAL 714 WEST PINE STREET NEWPORT WA 99156 PEND OREILLE (509) 447-2441 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.1821700 -117.0484200 0   51 53 53051 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Outlying Pend Oreille County https://data.medicare.gov/resource/xubh-q36u/row-kwpj_pxfj.xt2b 501310 649686 2019-05-31 2018-12-31 20           20       50       70
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
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
3286 3286 LODI COMMUNITY HOSPITAL 225 ELYRIA STREET LODI OH 44254 MEDINA (330) 948-1222 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.0360870 -82.0135160 0   103 39 39103 17460 Cleveland-Akron-Canton, OH Central Medina County https://data.medicare.gov/resource/xubh-q36u/row-48yc_8wc9.28w8 361303 649324 2019-05-31 2018-12-31 20           20               20
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
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
4277 4277 MEMORIAL COMMUNITY HOSPITAL MCH & HEALTH SYSTEM 810 NORTH 22ND ST BLAIR NE 68008 WASHINGTON (402) 426-1502 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5511520 -96.1455190 0   177 31 31177 36540 Omaha-Council Bluffs-Fremont, NE-IA Outlying Washington County https://data.medicare.gov/resource/xubh-q36u/row-76h9-y4cn_piec 281359 649292 2019-05-31 2018-12-31 21           21               21
4440 4440 HOUSTON PHYSICIANS' HOSPITAL 333 N TEXAS AVENUE WEBSTER TX 77598 HARRIS (281) 335-1700 Acute Care Hospitals Physician TRUE 29.5349020 -95.1257850 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-yxt9~vqzu.mhqf 670008 649528 2019-05-31 2018-12-31 21           21               21
4676 4676 ARISE AUSTIN MEDICAL CENTER 3003 BEE CAVES ROAD AUSTIN TX 78746 TRAVIS (512) 347-9888 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.2716640 -97.7954690 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-npkw~aqm5~fref 450871 648766 2019-05-31 2018-12-31 21           21               21
910 910 CLAIBORNE COUNTY HOSPITAL 123 MCCOMB AVENUE PORT GIBSON MS 39150 CLAIBORNE (601) 437-5141 Critical Access Hospitals Government - Local FALSE 31.9459920 -90.9853950 0   21 28 28021 46980 Jackson-Vicksburg-Brookhaven, MS Outlying Claiborne County https://data.medicare.gov/resource/xubh-q36u/row-wz4r-hvew~et2i 251320 650593 2019-05-31 2018-12-31 22           22 10             32
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
2357 2357 SPARROW IONIA HOSPITAL 3565 S STATE ROAD IONIA MI 48846 IONIA (616) 527-4200 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.9356080 -85.0747800 0   67 26 26067 26960 Grand Rapids-Wyoming-Muskegon, MI Central Ionia County https://data.medicare.gov/resource/xubh-q36u/row-wv7h-hrrb.9qa6 231331 649749 2019-05-31 2018-12-31 20 2         22               22
2366 2366 NOVANT HEALTH MEDICAL PARK HOSPITAL 1950 S HAWTHORNE RD WINSTON-SALEM NC 27103 FORSYTH (336) 718-0600 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.0781590 -80.2957150 0   67 37 37067 49180 Greensboro--Winston-Salem--High Point, NC Central Forsyth County https://data.medicare.gov/resource/xubh-q36u/row-ddsg-nw9h-w7fm 340148 650347 2019-05-31 2018-12-31 20 2         22               22
3656 3656 THE HEART HOSPITAL BAYLOR DENTON 2801 SOUTH MAYHILL ROAD DENTON TX 76208 DENTON (940) 220-0600 Acute Care Hospitals Physician TRUE 33.1769700 -97.0881990 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-rbda~a4ni-iua9 450893 648994 2019-05-31 2018-12-31 22           22               22
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
4304 4304 HOOPESTON COMMUNITY MEMORIAL HOSPITAL 701 EAST ORANGE STREET HOOPESTON IL 60942 VERMILION (217) 283-5531 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4591880 -87.6600860 0   183 17 17183 19180   Central Vermilion County https://data.medicare.gov/resource/xubh-q36u/row-g6rh-z4jp-g9a9 141316 650130 2019-05-31 2018-12-31 22           22               22
295 295 CARSON VALLEY MEDICAL CENTER 1107 HIGHWAY 395 GARDNERVILLE NV 89410 DOUGLAS (775) 782-1500 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9195628 -119.7189852 1 ROOFTOP 5 32 32005 23820 Reno-Carson City-Fernley, NV Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-zs3t-b2ik_qdz7 291306 650728 2019-05-31 2018-12-31 23           23               23
3136 3136 STANISLAUS SURGICAL HOSPITAL 1421 OAKDALE ROAD MODESTO CA 95355 STANISLAUS (209) 572-2700 Acute Care Hospitals Proprietary FALSE 37.6645580 -120.9575160 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-fsc3.3tg8_b499 50726 649542 2019-05-31 2018-12-31 23           23               23
4670 4670 THE HOSPITAL AT WESTLAKE MEDICAL CENTER 5656 BEE CAVES ROAD, SUITE M-302 AUSTIN TX 78746 TRAVIS (512) 327-0000 Acute Care Hospitals Proprietary TRUE 30.2947350 -97.8249380 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-k5u5~awt4~rwn8 670006 649981 2019-05-31 2018-12-31 23           23               23
1746 1746 RIVER HOSPITAL CLINICS 4 FULLER STREET ALEXANDRIA BAY NY 13607 JEFFERSON (315) 482-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3372170 -75.9200220 0   45 36 36045 48060   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-7zvs~rszm-n4ux 331309 650324 2019-05-31 2018-12-31 24           24               24
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
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
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
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
809 809 BAPTIST HEALTH MEDICAL CENTER-ARKADELPHIA 3050 TWIN RIVERS DRIVE ARKADELPHIA AR 71923 CLARK (870) 245-2622 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1228020 -93.0879700 0   19 5 5019 11660   Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-f8ss.59v5_rxma 41321 649536 2019-05-31 2018-12-31 25           25               25
833 833 PENOBSCOT VALLEY HOSPITAL 7 TRANSALPINE ROAD, PO BOX 368 LINCOLN ME 4457 PENOBSCOT (207) 794-3321 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3487330 -68.5162580 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-zcrj.qk59-ua67 201303 650480 2019-05-31 2018-12-31 25           25               25
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
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
1117 1117 WAUPUN MEMORIAL HOSPITAL 620 W BROWN ST WAUPUN WI 53963 FOND DU LAC (920) 324-6512 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6309680 -88.7459120 0   27 55 55027 13180 Milwaukee-Racine-Waukesha, WI Central Dodge County https://data.medicare.gov/resource/xubh-q36u/row-pzmh.4yzf-teeh 521327 650553 2019-05-31 2018-12-31 25           25               25
1192 1192 WHIDBEYHEALTH MEDICAL CENTER 101 NORTH MAIN STREET COUPEVILLE WA 98239 ISLAND (360) 678-5151 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.2142400 -122.6861220 0   29 53 53029 36020 Seattle-Tacoma, WA Central Island County https://data.medicare.gov/resource/xubh-q36u/row-uede_fy5z~txux 501339 649688 2019-05-31 2018-12-31 19 6         25               25
1265 1265 DECATUR COUNTY MEMORIAL HOSPITAL 720 N LINCOLN ST GREENSBURG IN 47240 DECATUR (812) 663-4331 Critical Access Hospitals Government - Local TRUE 39.3441160 -85.4794040 0   31 18 18031 24700 Indianapolis-Carmel-Muncie, IN Central Decatur County https://data.medicare.gov/resource/xubh-q36u/row-hqis.arxf_g2ap 151332 649101 2019-05-31 2018-12-31 25           25               25
1314 1314 ADVENTIST HEALTH CLEARLAKE 15630 18TH AVE - HWY 53 CLEARLAKE CA 95422 LAKE (707) 994-6486 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.9353458 -122.6200816 1 ROOFTOP 33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-hud3~fp2e-cmcb 51317 648600 2019-05-31 2018-12-31 21 4         25               25
1543 1543 SPARROW CLINTON HOSPITAL 805 S OAKLAND SAINT JOHNS MI 48879 CLINTON (989) 224-6881 Critical Access Hospitals Proprietary TRUE 42.9934350 -84.5558080 0   37 26 26037 29620 Lansing-East Lansing-Owosso, MI Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-2x5u-xt8b.6eqd 231326 649611 2019-05-31 2018-12-31 23 2         25               25
1604 1604 DEFIANCE REGIONAL MEDICAL CENTER 1200 RALSTON AVENUE DEFIANCE OH 43512 DEFIANCE (419) 783-6955 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.2993920 -84.3734690 0   39 39 39039 19580   Central Defiance County https://data.medicare.gov/resource/xubh-q36u/row-29rw.zsfv.ixin 361328 649330 2019-05-31 2018-12-31 17 8         25 10             35
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
1767 1767 MASON GENERAL HOSPITAL & FAMILY OF CLINICS 901 MT VIEW DRIVE SHELTON WA 98584 MASON (360) 426-1611 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.2267420 -123.1152790 0   45 53 53045 43220 Seattle-Tacoma, WA Central Mason County https://data.medicare.gov/resource/xubh-q36u/row-hitj-vpec_8dkv 501336 649687 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
1967 1967 COMMUNITY MEMORIAL HOSPITAL, INC 150 BROAD STREET HAMILTON NY 13346 MADISON (315) 824-1100 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8139060 -75.5419080 0   53 36 36053 45060 Syracuse-Auburn, NY Outlying Madison County https://data.medicare.gov/resource/xubh-q36u/row-jj4m-8gvf~vi9x 331316 650327 2019-05-31 2018-12-31 25           25               25
2071 2071 OCHSNER ST ANNE GENERAL HOSPITAL 4608 HIGHWAY 1 RACELAND LA 70394 LAFOURCHE (985) 537-8377 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.7034470 -90.5641330 0   57 22 22057 26380   Central Lafourche Parish https://data.medicare.gov/resource/xubh-q36u/row-nye5~c7n8.m9ck 191324 650474 2019-05-31 2018-12-31 22 3         25 10             35
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
2541 2541 MEDINA MEMORIAL HOSPITAL 200 OHIO STREET MEDINA NY 14103 ORLEANS (585) 798-8111 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2237070 -78.3970730 0   73 36 36073 40380 Rochester-Batavia-Seneca Falls, NY Outlying Orleans County https://data.medicare.gov/resource/xubh-q36u/row-qwtv~yivr_4v6h 331319 650329 2019-05-31 2018-12-31 25           25   9   30       64
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
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
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
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
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
3549 3549 COMMUNITY MEMORIAL HOSPITAL 400 N CALDWELL ST STAUNTON IL 62088 MACOUPIN (618) 635-2200 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.0153390 -89.7898900 0   117 17 17117 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Macoupin County https://data.medicare.gov/resource/xubh-q36u/row-matb-c6n4-455m 141306 650129 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
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
3691 3691 MAGRUDER HOSPITAL 615 FULTON ST PORT CLINTON OH 43452 OTTAWA (419) 734-3131 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5055710 -82.9337880 0   123 39 39123 38840 Toledo-Port Clinton, OH Central Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-ikr8~ybw5-9tcj 361314 649327 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
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
4226 4226 AULTMAN ORRVILLE HOSPITAL 832 SOUTH MAIN STREET ORRVILLE OH 44667 WAYNE (330) 682-3010 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8320810 -81.7645780 0   169 39 39169 49300   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-9tpy-nftf.5byd 361323 649328 2019-05-31 2018-12-31 25           25               25
4345 4345 UNIVERSITY HOSPITAL MCDUFFIE 2460 WASHINGTON ROAD THOMSON GA 30824 MC DUFFIE (706) 595-1411 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5232260 -82.5044780 0   189 13 13189 12260   Outlying McDuffie County https://data.medicare.gov/resource/xubh-q36u/row-zx3a.iuqr.6aqx 110111 651197 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

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