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

3,280 rows where hospital_type = "Acute Care Hospitals" sorted by cbsacode

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, burn_beds, subprovider_oth_beds, nursing_fac_beds, filed_date (date), fy_end_date (date)

hospital_type ✖

  • Acute Care Hospitals · 3,280 ✖
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
4 4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
5 5 SEYMOUR HOSPITAL 200 STADIUM DRIVE SEYMOUR TX 76380 BAYLOR (940) 889-5572 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5897880 -99.2476970 0   23 48 48023         https://data.medicare.gov/resource/xubh-q36u/row-q4ba-nup8_2wqc 450586 659539 2019-11-20 2019-06-30 27           27               27
19 19 ASCENSION ST MARYS HOSPITAL 2251 NORTH SHORE DR RHINELANDER WI 54501 ONEIDA (715) 361-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6384820 -89.3111400 0   85 55 55085         https://data.medicare.gov/resource/xubh-q36u/row-zwaq-mmw6_zwbm 520019 661677 2019-11-27 2019-06-30 32 20         52 11             63
20 20 MAYO CLINIC HEALTH SYSTEM - FAIRMONT 800 MEDICAL CENTER DRIVE, PO BOX 800 FAIRMONT MN 56031 MARTIN (507) 238-8101 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6376880 -94.4517280 0   91 27 27091         https://data.medicare.gov/resource/xubh-q36u/row-ifmr-5ze5~ircm 240166 649773 2019-05-30 2018-12-31 55           55               55
28 28 MORTON COUNTY HOSPITAL 445 N HILLTOP ELKHART KS 67950 MORTON (620) 697-2141 Acute Care Hospitals Government - Local TRUE 37.0019009 -101.9053025 1 ROOFTOP 129 20 20129         https://data.medicare.gov/resource/xubh-q36u/row-uv4u~7jpi~swm6 170166 651519 2019-07-09 2018-12-31 26           26               26
30 30 SOUTHSIDE COMMUNITY HOSPITAL, INC 800 OAK STREET FARMVILLE VA 23901 PRINCE EDWARD (434) 392-8811 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.3033170 -78.4030580 0   147 51 51147         https://data.medicare.gov/resource/xubh-q36u/row-5efz.zpme_8ei2 490090 650408 2019-06-03 2018-12-31 78 8         86               86
31 31 ST MARKS MEDICAL CENTER ONE ST MARK'S PLACE LA GRANGE TX 78945 FAYETTE (979) 242-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.9353227 -96.8763382 1 ROOFTOP 149 48 48149         https://data.medicare.gov/resource/xubh-q36u/row-sffi-gqgq~nh45 670004 660902 2019-12-02 2019-06-30 38           38               38
38 38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
40 40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
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
78 78 APPLING HOSPITAL 163 E TOLLISON STREET BAXLEY GA 31513 APPLING (912) 367-9841 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7687680 -82.3493510 0   1 13 13001         https://data.medicare.gov/resource/xubh-q36u/row-j4qq-twpw~u8jw 110071 658240 2019-03-29 2018-08-31 31 3         34 30     101       165
90 90 T J HEALTH COLUMBIA 901 WESTLAKE DRIVE COLUMBIA KY 42728 ADAIR (270) 384-4753 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.0962890 -85.2949400 0   1 21 21001         https://data.medicare.gov/resource/xubh-q36u/row-7iis-x23i.zsak 180149 640382 2018-12-31 2018-09-30 49           49 20             69
118 118 MEMORIAL HOSPITAL 1401 WEST LOCUST STILWELL OK 74960 ADAIR (918) 696-3101 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8085290 -94.6430100 0   1 40 40001         https://data.medicare.gov/resource/xubh-q36u/row-7atr.sncy~icbf 370178 660001 2019-12-02 2019-06-30 30           30 10             40
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
140 140 SAN LUIS VALLEY HEALTH 106 BLANCA AVE ALAMOSA CO 81101 ALAMOSA (719) 589-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4723600 -105.8837120 0   3 8 8003         https://data.medicare.gov/resource/xubh-q36u/row-bztx~k7ma~ri7p 60008 661701 2019-12-03 2019-06-30 43 6         49               49
174 174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
175 175 OAKDALE COMMUNITY HOSPITAL 130 N HOSPITAL DR OAKDALE LA 71463 ALLEN (318) 335-3700 Acute Care Hospitals Proprietary TRUE 30.8162640 -92.6445450 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-7xwr-vazc_74w6 190106 654443 2019-09-09 2019-03-31 46 3         49               49
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
177 177 NORTHERN MAINE MEDICAL CENTER 194 E MAIN STREET FORT KENT ME 4743 AROOSTOOK (207) 834-3195 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2650680 -68.5911770 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-cr45-cm3b-wfye 200052 645099 2019-02-28 2018-09-30 43           43 6     45       94
178 178 NORTHERN LIGHT A R GOULD HOSPITAL PO BOX 151 PRESQUE ISLE ME 4769 AROOSTOOK (207) 768-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.6751494 -67.9985861 1 ROOFTOP 3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-ihck.jhth~929r 200018 650152 2019-05-29 2018-09-30 43 6         49   5   14 50     118
217 217 JONES MEMORIAL HOSPITAL 191 NORTH MAIN STREET WELLSVILLE NY 14895 ALLEGANY (585) 593-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1228780 -77.9497840 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-nxxz~ksxe.5xk3 330096 662230 2019-12-02 2019-06-30 43 6         49               49
254 254 MEDICAL CENTER BARBOUR 820 W WASHINGTON ST EUFAULA AL 36027 BARBOUR (334) 688-7271 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.8879800 -85.1566130 0   5 1 1005         https://data.medicare.gov/resource/xubh-q36u/row-b9cj~n2ap_7hxj 10069 651152 2019-05-30 2018-12-31 25 5         30 17             47
259 259 SUTTER AMADOR HOSPITAL 200 MISSION BLVD JACKSON CA 95642 AMADOR (209) 223-7500 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3495610 -120.7659050 0   5 6 6005         https://data.medicare.gov/resource/xubh-q36u/row-s5bi-egin.834t 50014 650640 2019-06-03 2018-12-31 46 6         52               52
291 291 ESSENTIA HEALTH ST MARYS - DETROIT LAKES 1027 WASHINGTON AVE DETROIT LAKES MN 56501 BECKER (218) 847-0888 Acute Care Hospitals Voluntary non-profit - Church FALSE 46.8153070 -95.8454530 0   5 27 27005         https://data.medicare.gov/resource/xubh-q36u/row-my2b~zwif~njdr 240101 660605 2019-11-26 2019-06-30 28 8         36       96       132
325 325 LEWISGALE HOSPITAL ALLEGHANY ONE ARH LANE - PO BOX 7 LOW MOOR VA 24457 ALLEGHANY (540) 862-6011 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7917929 -79.8809172 1 ROOFTOP 5 51 51005         https://data.medicare.gov/resource/xubh-q36u/row-fp3a~xuin-uu4c 490126 652979 2019-08-02 2019-02-28 85 10         95 15             110
330 330 MARSHFIELD MEDICAL CENTER - RICE LAKE 1700 WEST STOUT STREET RICE LAKE WI 54868 BARRON (715) 234-1515 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5080420 -91.7590270 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-skqj~bt33-3hxj 520011 640931 2019-01-10 2018-09-30 35 5         40               40
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
361 361 COLUSA MEDICAL CENTER 199 E WEBSTER STREET COLUSA CA 95932 COLUSA (530) 619-0800 Acute Care Hospitals Proprietary TRUE 39.2072860 -121.9999740 0   11 6 6011         https://data.medicare.gov/resource/xubh-q36u/row-gpbh.sehb~v3mr 50783 656264 2019-11-01 2018-12-31 36 6         42       6       48
376 376 ATRIUM HEALTH ANSON 2301 US HIGHWAY 74 WEST WADESBORO NC 28170 ANSON (704) 694-5131 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9785320 -80.1096790 0   7 37 37007         https://data.medicare.gov/resource/xubh-q36u/row-mv5j_iuia_xbie 340084 650339 2019-05-30 2018-12-31 15           15               15
435 435 AVOYELLES HOSPITAL 4231 HIGHWAY 1192 MARKSVILLE LA 71351 AVOYELLES (318) 253-8611 Acute Care Hospitals Proprietary TRUE 31.1431270 -92.0644330 0   9 22 22009         https://data.medicare.gov/resource/xubh-q36u/row-yf6k.hf5w.97ar 190099 661332 2019-12-09 2019-06-30 47 2         49               49
439 439 NORTHERN LIGHT MAINE COAST HOSPITAL 50 UNION STREET ELLSWORTH ME 4605 HANCOCK (207) 667-5311 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.5465740 -68.4155260 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-4sb2~q3gq.pkmc 200050 651565 2019-06-26 2018-09-30 42 6         48               48
461 461 UPMC BEDFORD MEMORIAL 10455 LINCOLN HIGHWAY EVERETT PA 15537 BEDFORD (814) 623-6161 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0247210 -78.4332550 0   9 42 42009         https://data.medicare.gov/resource/xubh-q36u/row-a7tx_6h63.ijq9 390117 659869 2019-11-26 2019-06-30 36 4         40               40
476 476 LBJ TROPICAL MEDICAL CENTER FAGAALU VILLAGE PAGO PAGO AS 96799 EASTERN DISTRICT (684) 633-4590 Acute Care Hospitals Government - Hospital District or Authority TRUE -14.2900610 -170.6847054 1 APPROXIMATE 10 60 60010         https://data.medicare.gov/resource/xubh-q36u/row-6iv4.yudm-sdek                                      
477 477 GUAM MEMORIAL HOSPITAL AUTHORITY 85O GOV CARLOS G CAMACHO ROAD TAMUNING GU 96913 GUAM (671) 647-2552 Acute Care Hospitals Government - Local TRUE 13.5008229 144.7755910 1 GEOMETRIC_CENTER 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-4hjs.vy3n_hawy 650001 644079 2019-02-28 2018-09-30 147 14         161       40       201
478 478 GUAM REGIONAL MEDICAL CITY 133 ROUTE 3 DEDEDO GU 96929 GUAM (671) 645-5500 Acute Care Hospitals Voluntary non-profit - Private TRUE 13.5248362 144.8232653 1 ROOFTOP 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-ikxi.yahy_8xvd 650003 651493 2019-06-04 2018-12-31 88 17         105               105
479 479 GOV JUAN F LUIS HOSPITAL & MEDICAL CTR #4007 EST DIAMOND RUBY, CHRISTIANSTED ST CROIX VI 820 SAINT CROIX ISLAND (340) 778-6311 Acute Care Hospitals Government - State TRUE 17.7336768 -64.7515758 1 ROOFTOP 10 78 78010         https://data.medicare.gov/resource/xubh-q36u/row-bs2s~9p8n_k2e3 480002 644383 2019-02-28 2018-09-30 66 11         77               77
480 480 BULLOCK COUNTY HOSPITAL 102 WEST CONECUH AVENUE UNION SPRINGS AL 36089 BULLOCK (334) 738-2140 Acute Care Hospitals Proprietary TRUE 32.1461820 -85.7163800 0   11 1 1011         https://data.medicare.gov/resource/xubh-q36u/row-te44-k6fz_rhpp 10110 648174 2019-05-15 2018-12-31 30           30 24             54
498 498 HABERSHAM COUNTY MEDICAL CTR 541 HISTORIC HIGHWAY 441-NORTH DEMOREST GA 30535 HABERSHAM (706) 754-2161 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4058790 -83.4859890 0   11 13 13011         https://data.medicare.gov/resource/xubh-q36u/row-vwu4-xgbr~5v33 110041 660923 2019-12-04 2019-06-30 49 4         53       84       137
548 548 REGIONAL MEDICAL CENTER OF CENTRAL ALABAMA 29 L V STABLER DRIVE GREENVILLE AL 36037 BUTLER (334) 382-2200 Acute Care Hospitals Proprietary TRUE 31.8294500 -86.6458600 0   13 1 1013         https://data.medicare.gov/resource/xubh-q36u/row-ca8j-ucpx~zp9d 10150 645390 2019-03-01 2018-09-30 37 7         44 13             57
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
655 655 UINTAH BASIN MEDICAL CENTER 250 WEST 300 NORTH ROOSEVELT UT 84066 DUCHESNE (435) 722-4691 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3027550 -109.9970860 0   13 49 49013         https://data.medicare.gov/resource/xubh-q36u/row-qmgd.dczn~ghmv 460019 658598 2019-01-10 2018-06-30 31 4         35               35
760 760 TRACE REGIONAL HOSP AND SWING BED 1002 EAST MADISON STREET HOUSTON MS 38851 CHICKASAW (662) 456-3700 Acute Care Hospitals Proprietary FALSE 33.8947900 -88.9850850 0   17 28 28017         https://data.medicare.gov/resource/xubh-q36u/row-kmgr_friv-daby 250017 659509 2019-11-22 2019-06-30 39           39 15     66       120
773 773 CHENANGO MEMORIAL HOSPITAL 179 NORTH BROAD STREET NORWICH NY 13815 CHENANGO (607) 337-4111 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5420380 -75.5247240 0   17 36 36017         https://data.medicare.gov/resource/xubh-q36u/row-9jfe-nh8q_gain 330033 649474 2019-06-11 2018-12-31 51 7         58       80       138
791 791 BAPTIST MEMORIAL HOSPITAL - CARROLL COUNTY 631 RB WILSON DR HUNTINGDON TN 38344 CARROLL (731) 986-4461 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0230410 -88.4134920 0   17 47 47017         https://data.medicare.gov/resource/xubh-q36u/row-xcqt-svm2~s3iu 440016 644064 2019-02-26 2018-09-30 36   6       42 12             54
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
835 835 NANTUCKET COTTAGE HOSPITAL 57 PROSPECT STREET NANTUCKET MA 2554 NANTUCKET (508) 228-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2755420 -70.1002610 0   19 25 25019         https://data.medicare.gov/resource/xubh-q36u/row-txca.96ch~wc9s 220177 646153 2019-03-14 2018-09-30 19           19               19
847 847 GUADALUPE COUNTY HOSPITAL 117 CAMINO DE VIDA, SUITE 100 SANTA ROSA NM 88435 GUADALUPE (575) 472-3417 Acute Care Hospitals Government - Local TRUE 34.9295040 -104.6942240 0   19 35 35019         https://data.medicare.gov/resource/xubh-q36u/row-es4t_p7gk_ag72 320067 661934 2019-12-17 2019-06-30 10           10               10
896 896 PREMIER SURGICAL INSTITUTE 1619 K 66 GALENA KS 66739 CHEROKEE (620) 783-1732 Acute Care Hospitals Government - Local FALSE 37.0766240 -94.6218020 0   21 20 20021         https://data.medicare.gov/resource/xubh-q36u/row-rere_4r4a~kxmn 170203 648913 2019-05-28 2018-12-31 36           36               36
898 898 CITIZENS MEDICAL CENTER 7939 U S HWY 165 SOUTH COLUMBIA LA 71418 CALDWELL (318) 649-6106 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.0778710 -92.0952180 0   21 22 22021         https://data.medicare.gov/resource/xubh-q36u/row-ivth~mw7c.ra49 190184 653245 2019-08-30 2019-03-31 40           40               40
899 899 CALDWELL MEMORIAL HOSPITAL, INC 411 MAIN STREET COLUMBIA LA 71418 CALDWELL (318) 649-6111 Acute Care Hospitals Voluntary non-profit - Private FALSE 32.1041420 -92.0761550 0   21 22 22021         https://data.medicare.gov/resource/xubh-q36u/row-tzge.ni5n-rwic 190190 649740 2019-05-30 2018-12-31 37           37   10           47
954 954 GARRETT COUNTY MEMORIAL HOSPITAL 251 NORTH FOURTH STREET OAKLAND MD 21550 GARRETT (301) 533-4173 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4133250 -79.4027300 0   23 24 24023         https://data.medicare.gov/resource/xubh-q36u/row-t8h3.7jnz_zwmx 210017 660818 2019-12-02 2019-06-30 25 2         27       10       37
977 977 CHOCTAW MEMORIAL HOSPITAL 1405 EAST KIRK ROAD HUGO OK 74743 CHOCTAW (580) 317-9500 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.0116380 -95.4970220 0   23 40 40023         https://data.medicare.gov/resource/xubh-q36u/row-qqxy-asg7-7esi 370100 658911 2019-11-13 2019-06-30 34           34               34
989 989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
990 990 GROVE HILL MEMORIAL HOSPITAL 295 JACKSON HWY S GROVE HILL AL 36451 CLARKE (251) 275-3191 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6942130 -87.7772310 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-qwpn-mu4j-e76s 10091 660905 2019-12-04 2019-06-30 21           21 9             30
1000 1000 KENTUCKY RIVER MEDICAL CENTER 540 JETT DRIVE JACKSON KY 41339 BREATHITT (606) 666-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.5654340 -83.3701110 0   25 21 21025         https://data.medicare.gov/resource/xubh-q36u/row-ewjp.xkmp_edhx 180139 657105 2019-08-21 2018-08-31 45 4         49               49
1022 1022 NORTH MISSISSIPPI MEDICAL CENTER-WEST POINT 150 MEDICAL CENTER DRIVE WEST POINT MS 39773 CLAY (662) 495-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6186160 -88.6615490 0   25 28 28025         https://data.medicare.gov/resource/xubh-q36u/row-q5e6.mhes~upsp 250067 655015 2019-10-02 2018-09-30 43 6         49               49
1038 1038 MCLEOD HEALTH CHERAW 711 CHESTERFIELD HIGHWAY CHERAW SC 29520 CHESTERFIELD (843) 537-7881 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.6953720 -79.9180960 0   25 45 45025         https://data.medicare.gov/resource/xubh-q36u/row-gcbc~ig8b~ej5u 420107 645362 2019-03-01 2018-09-30 42 6         48               48
1039 1039 CLAIBORNE MEDICAL CENTER 1850 OLD KNOXVILLE HIGHWAY TAZEWELL TN 37879 CLAIBORNE (423) 626-4211 Acute Care Hospitals Government - Local TRUE 36.4533410 -83.5719720 0   25 47 47025         https://data.medicare.gov/resource/xubh-q36u/row-vk5j.mjgd~i76d 440057 658958 2019-11-18 2019-06-30 28 5         33       95       128
1043 1043 BRATTLEBORO MEMORIAL HOSPITAL 17 BELMONT AVE BRATTLEBORO VT 5301 WINDHAM (802) 257-0341 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8420700 -72.5646430 0   25 50 50025         https://data.medicare.gov/resource/xubh-q36u/row-r2kj.qdk8~ae78 470011 644193 2019-02-28 2018-09-30 47           47               47
1049 1049 GREENBRIER VALLEY MEDICAL CENTER 1320 MAPLEWOOD AVENUE RONCEVERTE WV 24970 GREENBRIER (304) 647-4411 Acute Care Hospitals Proprietary TRUE 37.7683729 -80.4652400 1 ROOFTOP 25 54 54025         https://data.medicare.gov/resource/xubh-q36u/row-bajh.9uz3-qmwc 510002 655663 2019-10-11 2019-04-30 80 12         92               92
1058 1058 CLAY COUNTY HOSPITAL 83825 HIGHWAY 9 P O BOX 1270 ASHLAND AL 36251 CLAY (256) 354-2131 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2765480 -85.8237890 0   27 1 1027         https://data.medicare.gov/resource/xubh-q36u/row-p2yh_2e24~5sth 10073 644085 2019-02-28 2018-09-30 42 4         46       83       129
1071 1071 ST ANTHONY REGIONAL HOSPITAL & NURSING HOME 311 SOUTH CLARK STREET CARROLL IA 51401 CARROLL (712) 792-3581 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0569820 -94.8679810 0   27 19 19027         https://data.medicare.gov/resource/xubh-q36u/row-mmxr_bdg2_23xf 160005 661893 2019-12-04 2019-06-30 43 6         49 14       79     142
1074 1074 CLAIBORNE MEMORIAL MEDICAL CENTER 620 EAST COLLEGE STREET HOMER LA 71040 CLAIBORNE (318) 927-2024 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7943270 -93.0624690 0   27 22 22027         https://data.medicare.gov/resource/xubh-q36u/row-ncph.ugan.rj3n 190114 661188 2019-11-27 2019-06-30 33 4         37 10             47
1102 1102 MCLEOD HEALTH CLARENDON 10 EAST HOSPITAL STREET MANNING SC 29102 CLARENDON (803) 435-8463 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6878660 -80.2117670 0   27 45 45027         https://data.medicare.gov/resource/xubh-q36u/row-vf43_k4z3~k3q8 420109 645363 2019-03-01 2018-09-30 43 6         49               49
1113 1113 BUCHANAN GENERAL HOSPITAL 1535 SLATE CREEK ROAD GRUNDY VA 24614 BUCHANAN (276) 935-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.2855060 -82.0678170 0   27 51 51027         https://data.medicare.gov/resource/xubh-q36u/row-fxtx.a9g4-8ec6 490127 660724 2019-11-27 2019-06-30 37 12         49               49
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
1141 1141 UMD SHORE MEDICAL CTR AT CHESTERTOWN 100 BROWN STREET CHESTERTOWN MD 21620 KENT (410) 778-7668 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2168450 -76.0644920 0   29 24 24029         https://data.medicare.gov/resource/xubh-q36u/row-9gun.f2aw-guni 210030 660229 2019-12-02 2019-06-30 15 6         21               21
1145 1145 LAKE REGIONAL HEALTH SYSTEM 54 HOSPITAL DRIVE OSAGE BEACH MO 65065 CAMDEN (573) 348-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.1184860 -92.6810850 0   29 29 29029         https://data.medicare.gov/resource/xubh-q36u/row-dyab~fgyi.56gt 260186 654682 2019-09-20 2019-04-30 82 18         100       16       116
1173 1173 COLLETON MEDICAL CENTER 501 ROBERTSON BOULEVARD WALTERBORO SC 29488 COLLETON (843) 782-2000 Acute Care Hospitals Proprietary TRUE 32.9218550 -80.6708800 0   29 45 45029         https://data.medicare.gov/resource/xubh-q36u/row-429y~gw6b~pgj2 420030 648315 2019-05-24 2018-12-31 94 8         102 19 14           135
1196 1196 ROY LESTER SCHNEIDER HOSPITAL,THE 9048 SUGAR ESTATE ST THOMAS VI 801 SAINT THOMAS ISLAND (809) 776-8311 Acute Care Hospitals Government - Local TRUE 18.3403280 -64.9146707 1 ROOFTOP 30 78 78030         https://data.medicare.gov/resource/xubh-q36u/row-smqm-6qpj_ky9s 480001 644382 2019-03-01 2018-09-30 99 8         107               107
1301 1301 CLARION HOSPITAL ONE HOSPITAL DRIVE CLARION PA 16214 CLARION (814) 226-9500 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.1927583 -79.3976930 1 ROOFTOP 31 42 42031         https://data.medicare.gov/resource/xubh-q36u/row-5n3x.3zm2.8hqq 390093 660440 2019-11-25 2019-06-30 50 7         57   8           65
1354 1354 MCLEOD MEDICAL CENTER - DILLON 301 E JACKSON STREET PO BOX 1327 DILLON SC 29536 DILLON (843) 774-4111 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.4212660 -79.3661070 0   33 45 45033         https://data.medicare.gov/resource/xubh-q36u/row-6w6y-vqzn-x943 420005 645356 2019-03-01 2018-09-30 66 6         72               72
1377 1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
1392 1392 EAST CARROLL PARISH HOSPITAL 336 NORTH HOOD STREET LAKE PROVIDENCE LA 71254 EAST CARROLL (318) 559-4023 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8110760 -91.1716560 0   35 22 22035         https://data.medicare.gov/resource/xubh-q36u/row-uef7_f368-ahcn 190208 657138 2019-11-01 2019-05-31 23           23               23
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
1398 1398 P H S INDIAN HOSPITAL AT BROWNING - BLACKFEET 760 HOSPITAL CIRCLE, POST OFFICE BOX 760 BROWNING MT 59417 GLACIER (406) 338-6157 Acute Care Hospitals Government - Federal TRUE 48.5657292 -113.0197530 1 ROOFTOP 35 30 30035         https://data.medicare.gov/resource/xubh-q36u/row-6bdm_qidd_w2p9 270074 651216 2019-06-24 2018-09-30 26           26               26
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
1535 1535 GEORGE REGIONAL HEALTH SYSTEM 859 WINTER STREET LUCEDALE MS 39452 GEORGE (601) 947-3161 Acute Care Hospitals Government - Local TRUE 30.9222350 -88.5928530 0   39 28 28039         https://data.medicare.gov/resource/xubh-q36u/row-f75f~mexp.zvtb 250036 643798 2019-02-28 2018-09-30 36 6         42               42
1579 1579 MIZELL MEMORIAL HOSPITAL 702 N MAIN ST OPP AL 36467 COVINGTON (334) 493-3541 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.2919720 -86.2554150 0   39 1 1039         https://data.medicare.gov/resource/xubh-q36u/row-syeg~nab9~7ee4 10007 644003 2019-02-27 2018-09-30 40 5         45 14             59
1580 1580 ANDALUSIA HEALTH 849 SOUTH THREE NOTCH STREET ANDALUSIA AL 36420 COVINGTON (334) 222-8466 Acute Care Hospitals Proprietary TRUE 31.2974620 -86.4955990 0   39 1 1039         https://data.medicare.gov/resource/xubh-q36u/row-5sky_nfni.vnsr 10036 653819 2019-08-30 2019-03-31 75 8         83               83
1591 1591 SAVOY MEDICAL CENTER 801 POINCIANA AVENUE MAMOU LA 70554 EVANGELINE (337) 468-5261 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.6410320 -92.4176050 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-53wc.63uu-ebuh 190025 650138 2019-06-03 2018-12-31 118 10         128 38 10           176
1592 1592 MERCY REGIONAL MEDICAL CENTER 800 E MAIN VILLE PLATTE LA 70586 EVANGELINE (337) 363-5684 Acute Care Hospitals Proprietary TRUE 30.6849310 -92.2659730 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-2sdk.fhzr.wwum 190167 645559 2019-03-01 2018-09-30 85 14         99   10           109
1594 1594 MUNSON HEALTHCARE GRAYLING HOSPITAL 1100 E MICHIGAN AVE GRAYLING MI 49738 CRAWFORD (989) 348-5461 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.6672510 -84.7079390 0   39 26 26039         https://data.medicare.gov/resource/xubh-q36u/row-unnq.cpq3.chrb 230058 660583 2019-11-27 2019-06-30 43 6         49       39       88
1616 1616 DECATUR COUNTY GENERAL HOSPITAL 969 TENNESSEE AVE S PARSONS TN 38363 DECATUR (731) 847-3031 Acute Care Hospitals Government - Local TRUE 35.6357130 -88.1231700 0   39 47 47039         https://data.medicare.gov/resource/xubh-q36u/row-x2m3-qfn9_55w9 440070 661811 2019-12-17 2019-06-30 40           40               40
1631 1631 CRENSHAW COMMUNITY HOSPITAL 101 HOSPITAL CIRCLE LUVERNE AL 36049 CRENSHAW (334) 335-3374 Acute Care Hospitals Proprietary TRUE 31.6925950 -86.2661560 0   41 1 1041         https://data.medicare.gov/resource/xubh-q36u/row-7kz6.2gr2.w3cp 10008 647847 2019-05-15 2018-12-31 29           29 20             49
1647 1647 FRANKLIN MEDICAL CENTER 2106 LOOP ROAD WINNSBORO LA 71295 FRANKLIN (318) 435-9411 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.1588800 -91.7052340 0   41 22 22041         https://data.medicare.gov/resource/xubh-q36u/row-pz3b~fmut.fx5c 190140 654726 2019-10-01 2019-04-30 23 6         29   8           37
1652 1652 NORTHERN MONTANA HOSPITAL 30 13TH ST HAVRE MT 59501 HILL (406) 265-2211 Acute Care Hospitals Voluntary non-profit - Private TRUE 48.5393260 -109.6863630 0   41 30 30041         https://data.medicare.gov/resource/xubh-q36u/row-8qcs_chz3.vw49 270032 659042 2019-11-19 2019-06-30 43 6         49       135       184
1660 1660 INTEGRIS GROVE HOSPITAL 1001 EAST 18TH STREET GROVE OK 74344 DELAWARE (918) 786-2243 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.5800860 -94.7572590 0   41 40 40041         https://data.medicare.gov/resource/xubh-q36u/row-sxxq.2snt_q3gw 370113 660140 2019-12-02 2019-06-30 52 6         58               58
1669 1669 PHS INDIAN HOSPITAL AT EAGLE BUTTE 24276 166TH AIRPORT ROAD EAGLE BUTTE SD 57625 DEWEY (605) 964-3005 Acute Care Hospitals Government - Federal TRUE 44.9935681 -101.2421234 1 GEOMETRIC_CENTER 41 46 46041         https://data.medicare.gov/resource/xubh-q36u/row-5fj3.qevg-rb9t 430083 650906 2019-06-24 2018-09-30 8           8               8
1670 1670 SAINT THOMAS DEKALB HOSPITAL 520 W MAIN ST SMITHVILLE TN 37166 DE KALB (615) 215-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 35.9594030 -85.8298410 0   41 47 47041         https://data.medicare.gov/resource/xubh-q36u/row-vj84-zvtf.4wg9 440148 659457 2019-11-25 2019-06-30 48 4         52               52
1674 1674 SEVIER VALLEY HOSPITAL 1000 NORTH MAIN STREET RICHFIELD UT 84701 SEVIER (435) 893-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7832750 -112.0846630 0   41 49 49041         https://data.medicare.gov/resource/xubh-q36u/row-mpgf-u9qb_jjy4 460026 646470 2019-04-15 2018-12-31 24           24               24
1678 1678 STONEWALL JACKSON MEMORIAL HOSPITAL 230 HOSPITAL PLAZA WESTON WV 26452 LEWIS (304) 269-8080 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0482850 -80.4927430 0   41 54 54041         https://data.medicare.gov/resource/xubh-q36u/row-2afu_zh5p.j9t2 510038 660725 2019-11-25 2019-06-30 64 6         70               70
1681 1681 DREW MEMORIAL HOSPITAL 778 SCOGIN DRIVE MONTICELLO AR 71655 DREW (870) 367-2411 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6106280 -91.8149780 0   43 5 5043         https://data.medicare.gov/resource/xubh-q36u/row-fv6e_36f4.x8wa 40051 654082 2019-09-03 2019-03-31 44 5         49               49
1783 1783 MCLAREN NORTHERN MICHIGAN 416 CONNABLE AVE PETOSKEY MI 49770 EMMET (231) 487-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 45.3734770 -84.9691520 0   47 26 26047         https://data.medicare.gov/resource/xubh-q36u/row-fcnu-j4f4.fztp 230105 648840 2019-05-28 2018-09-30 129 18 40       187   15           202
1810 1810 COLUMBUS REGIONAL HEALTHCARE SYSTEM 500 JEFFERSON ST WHITEVILLE NC 28472 COLUMBUS (910) 642-8011 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.3386570 -78.6936440 0   47 37 37047         https://data.medicare.gov/resource/xubh-q36u/row-ucyn-b8wt_9jnp 340068 645347 2019-02-28 2018-09-30 144   10       154               154
1824 1824 WELCH COMMUNITY HOSPITAL 454 MCDOWELL STREET WELCH WV 24801 MC DOWELL (304) 436-8461 Acute Care Hospitals Government - State TRUE 37.4388220 -81.5892950 0   47 54 54047         https://data.medicare.gov/resource/xubh-q36u/row-y7rn~73h2.fggs 510086 661439 2019-12-02 2019-06-30 42 7         49         59     108
1826 1826 DEKALB REGIONAL MEDICAL CENTER 200 MED CENTER DRIVE FORT PAYNE AL 35968 DE KALB (256) 845-3150 Acute Care Hospitals Proprietary TRUE 34.4419753 -85.7550138 1 ROOFTOP 49 1 1049         https://data.medicare.gov/resource/xubh-q36u/row-pt4k~hfcs.k9m2 10012 653737 2019-08-22 2019-03-31 85 12         97 18             115
1867 1867 LINDSAY MUNICIPAL HOSPITAL 1305 W CHEROKEE STREET - HIGHWAY 19 WEST LINDSAY OK 73052 GARVIN (405) 756-1404 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8391179 -97.6263761 1 ROOFTOP 49 40 40049         https://data.medicare.gov/resource/xubh-q36u/row-qvm4-iqce~99wn 370214 657437 2019-10-31 2019-06-30 26           26               26
1873 1873 HAMPTON REGIONAL MEDICAL CENTER 595 WEST CAROLINA AVENUE VARNVILLE SC 29944 HAMPTON (803) 943-2771 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8552580 -81.0876920 0   49 45 45049         https://data.medicare.gov/resource/xubh-q36u/row-fqdk-8968-57an 420072 643373 2019-02-20 2018-09-30 26 6         32               32
1885 1885 YUKON KUSKOKWIM DELTA REG HOSPITAL PO BOX 287 BETHEL AK 99559 BETHEL (907) 543-6300 Acute Care Hospitals Tribal TRUE 60.7922222 -161.7558334 1 GEOMETRIC_CENTER 50 2 2050         https://data.medicare.gov/resource/xubh-q36u/row-7gdx-n37w_5vx9 20018 651309 2019-07-02 2018-09-30 34           34               34

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