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

363 rows where geocode_flag = 1 sorted by centraloutlyingcounty

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

geocode_flag ✖

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
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
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
39 39 SAGE MEMORIAL HOSPITAL STATE ROUTE 264 SOUTH 191 GANADO AZ 86505 APACHE (928) 755-4541 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7108602 -109.5423597 1 ROOFTOP 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-vmgp-erfi.puty 31309 652060 2019-05-06 2018-09-30 25           25               25
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
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
187 187 P H S INDIAN HOSPITAL CROW / NORTHERN CHEYENNE 1010 SOUTH 7650 EAST, POST OFFICE BOX 9 CROW AGENCY MT 59022 BIG HORN (406) 638-2626 Critical Access Hospitals Government - Federal TRUE 45.5821958 -107.4488586 1 ROOFTOP 3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-pgmt~4b42~eq7a 271339 646565 2019-03-26 2018-09-30 24           24               24
188 188 ANTELOPE MEMORIAL HOSPITAL P O BOX 229, 102 WEST 9TH ST NELIGH NE 68756 ANTELOPE (402) 887-4151 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1336539 -98.0299847 1 ROOFTOP 3 31 31003         https://data.medicare.gov/resource/xubh-q36u/row-uv86-cr3r-pfws 281326 661040 2019-12-02 2019-06-30 23           23               23
309 309 ALLEGHANY COUNTY MEMORIAL HOSPITAL 617 DOCTORS STREET SPARTA NC 28675 ALLEGHANY (336) 372-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.5095115 -81.1150447 1 RANGE_INTERPOLATED 5 37 37005         https://data.medicare.gov/resource/xubh-q36u/row-zjv8.p46n-e733 341320 645140 2019-03-04 2018-09-30 25           25               25
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
353 353 MERCYONE CENTERVILLE MEDICAL CENTER ONE ST JOSEPH'S DRIVE CENTERVILLE IA 52544 APPANOOSE (641) 437-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7555228 -92.8568047 1 ROOFTOP 7 19 19007         https://data.medicare.gov/resource/xubh-q36u/row-quyx-h8pq.iqb9 161377 660989 2019-12-02 2019-06-30 22 3         25           19   44
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
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
515 515 BOONE COUNTY HEALTH CENTER P O BOX 151, 723 WEST FAIRVIEW ST ALBION NE 68620 BOONE (402) 395-2191 Critical Access Hospitals Government - Local TRUE 41.6921113 -98.0002224 1 ROOFTOP 11 31 31011         https://data.medicare.gov/resource/xubh-q36u/row-3j5p_6aw6-77k2 281334 645125 2019-02-28 2018-09-30 25           25               25
622 622 BOX BUTTE GENERAL HOSPITAL P O BOX 810, 2101 BOX BUTTE AVE ALLIANCE NE 69301 BOX BUTTE (308) 762-6660 Critical Access Hospitals Government - Local TRUE 42.0984344 -102.8703880 1 ROOFTOP 13 31 31013         https://data.medicare.gov/resource/xubh-q36u/row-gsu6_furw.wta3 281360 661047 2019-12-02 2019-06-30 25           25               25
692 692 MISSOURI RIVER MEDICAL CENTER 1501 ST CHARLES ST FORT BENTON MT 59442 CHOUTEAU (406) 622-3331 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8203555 -110.6722100 1 ROOFTOP 15 30 30015         https://data.medicare.gov/resource/xubh-q36u/row-ibbr.ff9i-ncwz 271304 656304 2019-11-04 2019-06-30 25           25               25
694 694 NIOBRARA VALLEY HOSPITAL P O BOX 118, 401 SOUTH 5TH STREET LYNCH NE 68746 BOYD (402) 569-2451 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8245631 -98.4684820 1 ROOFTOP 15 31 31015         https://data.medicare.gov/resource/xubh-q36u/row-34qy.5xrg_j9e4 281303 658942 2018-11-19 2018-08-31 20           20               20
900 900 CHARLES A DEAN MEMORIAL HOSPITAL PO BOX 1129 GREENVILLE ME 4441 PISCATAQUIS (207) 695-5200 Critical Access Hospitals Voluntary non-profit - Private FALSE 45.4594923 -69.5906060 1 GEOMETRIC_CENTER 21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-e23p-cjiz~ui3t 201301 650155 2019-06-21 2018-09-30 25           25               25
940 940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
999 999 ASHLAND HEALTH CENTER 625 SOUTH KENTUCKY ASHLAND KS 67831 CLARK (620) 635-2241 Critical Access Hospitals Voluntary non-profit - Other TRUE 37.1902572 -99.7797746 1 ROOFTOP 25 20 20025         https://data.medicare.gov/resource/xubh-q36u/row-6n24_uu3q.wx9d 171304 655206 2019-10-10 2018-12-31 25           25               25
1044 1044 GRACE COTTAGE HOSPITAL PO BOX 216 TOWNSHEND VT 5353 WINDHAM (802) 365-7920 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0489148 -72.6682465 1 ROOFTOP 25 50 50025         https://data.medicare.gov/resource/xubh-q36u/row-u9ts~hp4k-kd62 471300 643746 2019-02-22 2018-09-30 19           19               19
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
1142 1142 MUNSON HEALTHCARE CHARLEVOIX HOSPITAL 14700 LAKESHORE DRIVE CHARLEVOIX MI 49720 CHARLEVOIX (231) 547-4024 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.3144980 -85.2748510 1 ROOFTOP 29 26 26029         https://data.medicare.gov/resource/xubh-q36u/row-cdsd.f9cx_c7j8 231322 660601 2019-11-27 2019-06-30 25           25               25
1149 1149 CHASE COUNTY COMMUNITY HOSPITAL P O BOX 819, 600 W 12TH ST IMPERIAL NE 69033 CHASE (308) 882-7111 Critical Access Hospitals Government - Local TRUE 40.5163553 -101.6419049 1 ROOFTOP 29 31 31029         https://data.medicare.gov/resource/xubh-q36u/row-nwms~eext-vthe 281351 655132 2019-10-04 2019-06-30 20           20               20
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
1281 1281 CHERRY COUNTY HOSPITAL P O BOX 410, 510 NORTH GREEN ST VALENTINE NE 69201 CHERRY (402) 376-2525 Critical Access Hospitals Government - Local TRUE 42.8790786 -100.5384010 1 ROOFTOP 31 31 31031         https://data.medicare.gov/resource/xubh-q36u/row-fpwc_rzae.e38t 281344 652757 2019-07-23 2019-03-31 25           25               25
1295 1295 CARRINGTON HEALTH CENTER PO BOX 461 CARRINGTON ND 58421 FOSTER (701) 652-3141 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4497201 -99.1262234 1 APPROXIMATE 31 38 38031         https://data.medicare.gov/resource/xubh-q36u/row-inkg_zfig.5z7t 351318 662239 2019-11-26 2019-06-30 25           25               25
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
1322 1322 COMANCHE COUNTY HOSPITAL 2ND & FRISCO STREET COLDWATER KS 67029 COMANCHE (620) 582-2144 Critical Access Hospitals Government - Local TRUE 37.2679460 -99.3321152 1 GEOMETRIC_CENTER 33 20 20033         https://data.medicare.gov/resource/xubh-q36u/row-uexi-7hwn_3fpb 171312 648915 2019-05-29 2018-12-31 12           12               12
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
1654 1654 CALLAWAY DISTRICT HOSPITAL P O BOX 100, 211 E KIMBALL CALLAWAY NE 68825 CUSTER (308) 836-2228 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.2909887 -99.9242095 1 ROOFTOP 41 31 31041         https://data.medicare.gov/resource/xubh-q36u/row-nfg8_ccxm-ja7t 281335 660412 2019-01-02 2018-07-31 12           12               12
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
1715 1715 LINCOLN HOSPITAL 10 NICHOLS STREET DAVENPORT WA 99122 LINCOLN (509) 725-7101 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.6571949 -118.1462384 1 RANGE_INTERPOLATED 43 53 53043         https://data.medicare.gov/resource/xubh-q36u/row-3c5v_e33f-mmva 501305 647597 2019-05-13 2018-12-31 25           25               25
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
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
1897 1897 FAYETTE COUNTY HOSPITAL 7TH AND TAYLOR VANDALIA IL 62471 FAYETTE (618) 283-1231 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.9706410 -89.0988780 1 GEOMETRIC_CENTER 51 17 17051         https://data.medicare.gov/resource/xubh-q36u/row-3m36-npvv-f9tn 141346 648907 2019-05-30 2018-12-31 25 4         29       85       114
1908 1908 PRAIRIE RIDGE HOSPITAL AND HEALTH SERVICES 1411 HIGHWAY 793 E ELBOW LAKE MN 56531 GRANT (218) 685-7300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9908032 -95.9578947 1 ROOFTOP 51 27 27051         https://data.medicare.gov/resource/xubh-q36u/row-is3f.7a5b~t9ju 241379 644131 2019-02-28 2018-09-30 10           10               10
1932 1932 MILBANK AREA HOSPITAL/AVERA HEALTH 301 FLYNN DRIVE MILBANK SD 57252 GRANT (605) 432-4538 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2219130 -96.6175485 1 ROOFTOP 51 46 46051         https://data.medicare.gov/resource/xubh-q36u/row-y6xc~czq6~y94b 431326 660034 2019-11-26 2019-06-30 25           25               25
1973 1973 COMMUNITY MEMORIAL HOSPITAL 809 JACKSON POST OFFICE BOX 319 BURKE SD 57523 GREGORY (605) 775-2621 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1817666 -99.2925606 1 ROOFTOP 53 46 46053         https://data.medicare.gov/resource/xubh-q36u/row-sb5r_k2dt_an8q 431309 646936 2019-04-25 2018-12-31 16           16               16
1974 1974 AVERA GREGORY HOSPITAL 400 PARK STREET POST OFFICE BOX 408 GREGORY SD 57533 GREGORY (605) 835-8394 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2319878 -99.4304377 1 ROOFTOP 53 46 46053         https://data.medicare.gov/resource/xubh-q36u/row-sxnm~ansc_ejzf 431338 662257 2019-11-26 2019-06-30 25           25       55       80
1976 1976 SETON HIGHLAND LAKES HIGHWAY 281 SOUTH BURNET TX 78611 BURNET (512) 715-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.7113209 -98.2467221 1 GEOMETRIC_CENTER 53 48 48053         https://data.medicare.gov/resource/xubh-q36u/row-khw5~6jgp-v7pk 451365 659615 2019-11-25 2019-06-30 21 4         25               25
2038 2038 HANS P PETERSON MEMORIAL HOSPITAL - CAH 503 W PINE POST OFFICE BOX 790 PHILIP SD 57567 HAAKON (605) 859-2511 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0392471 -101.6628240 1 ROOFTOP 55 46 46055         https://data.medicare.gov/resource/xubh-q36u/row-5652-vpwn_wmme 431319 651668 2019-07-01 2018-12-31 18           18         30     48
2077 2077 DUNDY COUNTY HOSPITAL P O BOX 626, 1313 NORTH CHEYENNE ST BENKELMAN NE 69021 DUNDY (308) 423-2204 Critical Access Hospitals Government - Local TRUE 40.0565540 -101.5374470 1 ROOFTOP 57 31 31057         https://data.medicare.gov/resource/xubh-q36u/row-pych_p5gr-xzj5 281340 652885 2019-08-05 2019-02-28 14           14               14
2140 2140 LASALLE GENERAL HOSPITAL 187 NINTH ST/HWY 84 WEST JENA LA 71342 LASALLE (318) 992-9200 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6831927 -92.1337360 1 GEOMETRIC_CENTER 59 22 22059         https://data.medicare.gov/resource/xubh-q36u/row-dbin~f8yn~yhkn 190145 644279 2019-03-01 2018-09-30 30           30 16             46
2146 2146 FILLMORE COUNTY HOSPITAL P O BOX 193, 1900 F STREET GENEVA NE 68361 FILLMORE (402) 759-3167 Critical Access Hospitals Government - Local TRUE 40.5243546 -97.5877126 1 ROOFTOP 59 31 31059         https://data.medicare.gov/resource/xubh-q36u/row-h8d4~72pk-88se 281301 659702 2019-11-18 2019-06-30 20           20 10             30
2255 2255 JEFFERSON COUNTY HOSPITAL 870 S MAIN FAYETTE MS 39069 JEFFERSON (601) 786-3401 Acute Care Hospitals Government - Local TRUE 31.7048425 -91.0685345 1 ROOFTOP 63 28 28063         https://data.medicare.gov/resource/xubh-q36u/row-6ixf.trx6_t5pg 250060 644298 2019-03-04 2018-09-30 12           12 18             30
2311 2311 SALEM MEMORIAL DISTRICT HOSPITAL PO BOX 774, SALEM MO 65560 DENT (573) 729-6626 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6604402 -91.5692851 1 ROOFTOP 65 29 29065         https://data.medicare.gov/resource/xubh-q36u/row-wiw4-tpja~sz74 261318 661354 2019-12-03 2019-06-30 25           25           18   43
2368 2368 PEMBINA COUNTY MEMORIAL HOSPITAL BOX 380 CAVALIER ND 58220 PEMBINA (701) 265-8461 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7938813 -97.6223098 1 APPROXIMATE 67 38 38067         https://data.medicare.gov/resource/xubh-q36u/row-nr5r_iafj-hv8d 351319 645788 2019-03-27 2018-12-31 20           20       50       70
2370 2370 JEFFERSON COUNTY HOSPITAL INTERSECTION HYWS 81 & 70 WAURIKA OK 73573 JEFFERSON (580) 228-2344 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1572807 -97.9795416 1 GEOMETRIC_CENTER 67 40 40067         https://data.medicare.gov/resource/xubh-q36u/row-ph4g-iebq.bzzs 371311 662416 2019-12-02 2019-06-30 25           25               25
2397 2397 HARDIN COUNTY GENERAL HOSPITAL FERRELL ROAD ROSICLARE IL 62982 HARDIN (618) 285-6634 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.4103431 -88.3558252 1 GEOMETRIC_CENTER 69 17 17069         https://data.medicare.gov/resource/xubh-q36u/row-p9aq.m5aa.6pkb 141328 653315 2019-08-29 2019-03-31 25           25               25
2424 2424 KANAKANAK HOSPITAL P O BOX 130 DILLINGHAM AK 99576 DILLINGHAM (907) 842-5201 Critical Access Hospitals Voluntary non-profit - Private TRUE 59.0397222 -158.4575000 1 GEOMETRIC_CENTER 70 2 2070         https://data.medicare.gov/resource/xubh-q36u/row-j4d4-bz29~h79d 21309 646376 2019-03-28 2018-09-30 18           18               18
2544 2544 MERCY HOSPITAL KINGFISHER, INC 1000 KINGFISHER HOSPITAL DRIVE KINGFISHER OK 73750 KINGFISHER (405) 375-3141 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.8100746 -97.9449387 1 ROOFTOP 73 40 40073         https://data.medicare.gov/resource/xubh-q36u/row-h8q6~j6ue-y5ca 371313 660141 2019-11-25 2019-06-30 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
2584 2584 CHILDRESS REGIONAL MEDICAL CENTER HWY 83 NORTH CHILDRESS TX 79201 CHILDRESS (940) 937-6371 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4304911 -100.2265235 1 GEOMETRIC_CENTER 75 48 48075         https://data.medicare.gov/resource/xubh-q36u/row-vkgv.sxvw_zc6g 450369 646306 2019-03-08 2018-09-30 39           39               39
2628 2628 AVERA DE SMET MEMORIAL HOSPITAL - CAH 306 PRAIRIE AVENUE SW POST OFFICE BOX 160 DE SMET SD 57231 KINGSBURY (605) 854-3329 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3860427 -97.5611172 1 GEOMETRIC_CENTER 77 46 46077         https://data.medicare.gov/resource/xubh-q36u/row-q65a~ny3z~nsyr 431332 662255 2019-11-27 2019-06-30 6           6               6
2655 2655 P H S INDIAN HOSP AT BELCOURT-QUENTIN N BURDICK PO BOX 160 BELCOURT ND 58316 ROLETTE (701) 477-6111 Acute Care Hospitals Government - Federal TRUE 48.8434415 -99.7483567 1 ROOFTOP 79 38 38079         https://data.medicare.gov/resource/xubh-q36u/row-tdmb_245b_qx4d 350063 650356 2019-06-18 2018-09-30 27           27               27
2698 2698 SATANTA DISTRICT HOSPITAL CHEYENNE & APACHE SATANTA KS 67870 HASKELL (620) 649-2761 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4374237 -100.9856235 1 GEOMETRIC_CENTER 81 20 20081         https://data.medicare.gov/resource/xubh-q36u/row-5zm3-qnsy-hby4 171324 648917 2019-05-28 2018-12-31 13           13           44   57
2730 2730 TOMAH MEMORIAL HOSPITAL 501 GOPHER DR TOMAH WI 54660 MONROE (608) 372-2181 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9585209 -90.5124608 1 ROOFTOP 81 55 55081         https://data.medicare.gov/resource/xubh-q36u/row-k2zz~hrus_4u53 521320 645871 2019-03-06 2018-09-30 25           25               25
2756 2756 HARLAN COUNTY HEALTH SYSTEM P O BOX 836, 717 NORTH BROWN ST ALMA NE 68920 HARLAN (308) 928-2151 Critical Access Hospitals Government - Local TRUE 40.0981797 -99.3631677 1 ROOFTOP 83 31 31083         https://data.medicare.gov/resource/xubh-q36u/row-yvs4.45jj.87ms 281300 647189 2019-04-23 2018-12-31 19           19               19
2860 2860 MAHNOMEN HEALTH CENTER 414 W JEFFERSON PO BOX 396 MAHNOMEN MN 56557 MAHNOMEN (218) 935-2511 Critical Access Hospitals Government - Local TRUE 47.3117925 -95.9729278 1 ROOFTOP 87 27 27087         https://data.medicare.gov/resource/xubh-q36u/row-hmyn_2dwh_mr9t 241300 651009 2019-06-04 2018-12-31 10           10       32       42
2922 2922 MCCURTAIN MEMORIAL HOSPITAL 1301 LINCOLN ROAD IDABEL OK 74745 MCCURTAIN (580) 286-7623 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8827686 -94.8112299 1 ROOFTOP 89 40 40089         https://data.medicare.gov/resource/xubh-q36u/row-pgd6-5hq6_fe4r                                      
3056 3056 JEFFERSON COMMUNITY HEALTH & LIFE P O BOX 277, 2200 H ST FAIRBURY NE 68352 JEFFERSON (402) 729-3351 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1364252 -97.1816307 1 ROOFTOP 95 31 31095         https://data.medicare.gov/resource/xubh-q36u/row-uhie_h8g7.ayhp 281319 644763 2019-02-26 2018-09-30 17           17       40       57
3058 3058 TOWNER COUNTY MEDICAL CENTER HWY 281 N CANDO ND 58324 TOWNER (701) 968-4411 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4931522 -99.2110430 1 ROOFTOP 95 38 38095         https://data.medicare.gov/resource/xubh-q36u/row-8pd6_eppf-kx3r 351331 638004 2018-11-28 2018-06-30 20           20       30   5   55
3167 3167 CHOCTAW HEALTH CENTER ROUTE 7 BOX R50 PHILADELPHIA MS 39350 NESHOBA (601) 656-2211 Acute Care Hospitals Government - Federal TRUE 32.7809947 -89.1834058 1 ROOFTOP 99 28 28099         https://data.medicare.gov/resource/xubh-q36u/row-5rfv.qyga.n666 250127 652147 2019-07-02 2018-09-30 20           20               20
3202 3202 LANE COUNTY HOSPITAL 235 WEST VINE PO BOX 969 DIGHTON KS 67839 LANE (620) 397-5321 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.4805486 -100.4690751 1 ROOFTOP 101 20 20101         https://data.medicare.gov/resource/xubh-q36u/row-9e78_nak8_vx8n 171303 647616 2019-05-06 2018-12-31 25           25               25
3214 3214 AVERA CREIGHTON HOSPITAL P O BOX 186, 1503 MAIN ST CREIGHTON NE 68729 KNOX (402) 358-5700 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4664016 -97.9072475 1 ROOFTOP 107 31 31107         https://data.medicare.gov/resource/xubh-q36u/row-7tv3_vise~cn54 281331 660258 2019-11-25 2019-06-30 23           23       47       70
3246 3246 PIONEERS MEDICAL CENTER 100 PIONEERS MEDICAL CENTER DR MEEKER CO 81641 RIO BLANCO (970) 878-5047 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0470026 -107.8822968 1 ROOFTOP 103 8 8103         https://data.medicare.gov/resource/xubh-q36u/row-ygxw-c3bh-9y5d 61325 647603 2019-05-08 2018-12-31 10           10       30       40
3275 3275 NOXUBEE GENERAL CRITICAL ACCESS HOSP 78 HOSPITAL ROAD MACON MS 39341 NOXUBEE (662) 726-4231 Critical Access Hospitals Government - Local TRUE 33.1220867 -88.5588576 1 ROOFTOP 103 28 28103         https://data.medicare.gov/resource/xubh-q36u/row-j554~em5b.ies8 251307 645005 2019-03-05 2018-09-30 25           25               25
3295 3295 WETZEL COUNTY HOSPITAL #3 EAST BENJAMIN DRIVE NEW MARTINSVILLE WV 26155 WETZEL (304) 455-8000 Acute Care Hospitals Government - Local TRUE 39.6810712 -80.8501977 1 ROOFTOP 103 54 54103         https://data.medicare.gov/resource/xubh-q36u/row-v7h8~v92p-92tq 510072 661438 2019-12-02 2019-06-30 43 5         48               48
3321 3321 CATSKILL REGIONAL MEDICAL CENTER - G HERMANN SITE 8081 ROUTE 97 CALLICOON NY 12723 SULLIVAN (845) 887-5530 Critical Access Hospitals Government - Federal FALSE 41.7354523 -75.0429660 1 RANGE_INTERPOLATED 105 36 36105         https://data.medicare.gov/resource/xubh-q36u/row-exhc-5fn7-r9xs 331303 649479 2019-05-28 2018-12-31 15           15               15
3412 3412 COMMONWEALTH HEALTH CENTER 1 LOWER NAVY HILL ROAD (PO BOX 409CK) GARAPAN MP 96950 SAIPAN (670) 234-8950 Acute Care Hospitals Proprietary TRUE 15.2086299 145.7303467 1 GEOMETRIC_CENTER 110 69 69110         https://data.medicare.gov/resource/xubh-q36u/row-z8uz.de7b_sx86 660001 644688 2019-03-01 2018-09-30 70 4         74               74
3593 3593 AVERA MERRILL PIONEER HOSPITAL 1100 S 10TH AVE ROCK RAPIDS IA 51246 LYON (712) 472-2591 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4213815 -96.1757132 1 RANGE_INTERPOLATED 119 19 19119         https://data.medicare.gov/resource/xubh-q36u/row-m3f9-4aqb~x9sv 161321 660960 2019-11-27 2019-06-30 11           11               11
3628 3628 SHANDS LIVE OAK REGIONAL MEDICAL CENTER 1100 SW 11TH ST LIVE OAK FL 32060 SUWANNEE (904) 362-1413 Critical Access Hospitals Proprietary TRUE 30.2917367 -83.0028124 1 ROOFTOP 121 12 12121         https://data.medicare.gov/resource/xubh-q36u/row-keij_wts9-t8jc 101301 660198 2019-12-02 2019-06-30 25           25               25
3724 3724 GENOA COMMUNITY HOSPITAL P O BOX 310, 706 EWING AVE GENOA NE 68640 PLATTE (402) 993-2283 Critical Access Hospitals Government - Local TRUE 41.4438882 -97.7325043 1 ROOFTOP 125 31 31125         https://data.medicare.gov/resource/xubh-q36u/row-c2af.d7kh~u8nh 281312 657908 2019-10-30 2019-06-30 19           19           39   58
3785 3785 RENVILLE COUNTY HOSPITAL AND CLINICS 100 HEALTHY WAY OLIVIA MN 56277 RENVILLE (320) 523-1261 Critical Access Hospitals Government - Local TRUE 44.7747296 -94.9724885 1 ROOFTOP 129 27 27129         https://data.medicare.gov/resource/xubh-q36u/row-9bry_ub3h~y6xn 241306 652484 2019-07-29 2018-12-31 16           16           16   32
3787 3787 BRODSTONE MEMORIAL HOSP P O BOX 187, 520 EAST 10TH ST SUPERIOR NE 68978 NUCKOLLS (402) 879-3281 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0266410 -98.0661260 1 ROOFTOP 129 31 31129         https://data.medicare.gov/resource/xubh-q36u/row-w2de_bhr4_4ftq 281315 653977 2019-08-27 2019-04-30 25           25               25
3796 3796 SPOONER HEALTH SYSTEM 1280 CHANDLER DR SPOONER WI 54801 WASHBURN (715) 635-2111 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8414373 -91.8703438 1 ROOFTOP 129 55 55129         https://data.medicare.gov/resource/xubh-q36u/row-y5vj~v6dk_vfyv 521332 653362 2019-08-30 2019-03-31 20           20               20
3807 3807 SABETHA COMMUNITY HOSPITAL 14TH & OREGON SABETHA KS 66534 NEMAHA (785) 284-2121 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.8997686 -95.8071090 1 GEOMETRIC_CENTER 131 20 20131         https://data.medicare.gov/resource/xubh-q36u/row-tatv-27qf.j7tk 171338 650576 2019-06-04 2018-12-31 17           17               17
3815 3815 SYRACUSE AREA HEALTH 2731 HEALTHCARE DR SYRACUSE NE 68446 OTOE (402) 269-2011 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6770233 -96.1814653 1 ROOFTOP 131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-e4xn-76tv~ys3t 281309 658943 2019-11-11 2019-06-30 10           10               10
3830 3830 SPECTRUM HEALTH REED CITY HOSPITAL 300 N PATTERSON, PO BOX 75 REED CITY MI 49677 OSCEOLA (231) 832-3271 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8782450 -85.5211907 1 ROOFTOP 133 26 26133         https://data.medicare.gov/resource/xubh-q36u/row-hhgy~8j82.d9qv 231323 660106 2019-11-25 2019-06-30 21 4         25       50       75
3834 3834 PAWNEE COUNTY MEMORIAL HOSPITAL P O BOX 433, 600 I ST PAWNEE CITY NE 68420 PAWNEE (402) 852-2231 Critical Access Hospitals Proprietary TRUE 40.1098396 -96.1532422 1 ROOFTOP 133 31 31133         https://data.medicare.gov/resource/xubh-q36u/row-2ahw-y3eh_6phq 281302 661036 2019-12-02 2019-06-30 17           17               17
3950 3950 ANNIE JEFFREY MEMORIAL COUNTY HEALTH CENTER P O BOX 428, 531 BEEBE ST OSCEOLA NE 68651 POLK (402) 747-2031 Critical Access Hospitals Government - Local TRUE 41.1697878 -97.5490124 1 ROOFTOP 143 31 31143         https://data.medicare.gov/resource/xubh-q36u/row-tmyd~dpec-xnwq 281314 655636 2019-10-21 2019-06-30 16           16               16
3983 3983 BAPTIST MEMORIAL HOSPITAL UNION COUNTY 200 HWY 30 WEST NEW ALBANY MS 38652 UNION (662) 538-7631 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.4969900 -89.0279582 1 ROOFTOP 145 28 28145         https://data.medicare.gov/resource/xubh-q36u/row-f3mh-shgd-bs86 250006 644038 2019-02-26 2018-09-30 84 8         92               92
3987 3987 COMMUNITY HOSPITAL P O BOX 1328, 1301 EAST H ST MCCOOK NE 69001 RED WILLOW (308) 344-2650 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.2004042 -100.6317977 1 ROOFTOP 145 31 31145         https://data.medicare.gov/resource/xubh-q36u/row-b3ww-n6dr.gmwh 281363 661048 2019-12-02 2019-06-30 25           25               25
4004 4004 COMMUNITY MEDICAL CENTER, INC P O BOX 399, 3307 BARADA ST FALLS CITY NE 68355 RICHARDSON (402) 245-2428 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0778770 -95.6075970 1 ROOFTOP 147 31 31147         https://data.medicare.gov/resource/xubh-q36u/row-xcna_pb8z-kjhc 281352 640654 2018-12-28 2018-07-31 24           24               24
4043 4043 CRETE AREA MEDICAL CENTER P O BOX 220, 2910 BETTEN DR CRETE NE 68333 SALINE (402) 826-2101 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.6407290 -96.9377207 1 ROOFTOP 151 31 31151         https://data.medicare.gov/resource/xubh-q36u/row-r9d7_ysji.sjzi 281354 649921 2019-06-03 2018-12-31 24           24               24
4060 4060 CENTRACARE HEALTH SYSTEM - LONG PRAIRIE 50 CENTRACARE DRIVE LONG PRAIRIE MN 56347 TODD (320) 732-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9733659 -94.8429923 1 ROOFTOP 153 27 27153         https://data.medicare.gov/resource/xubh-q36u/row-auf6_7hb8_cyed 241326 660609 2019-11-26 2019-06-30 14           14       70       84
4091 4091 SPARTA COMMUNITY HOSPITAL 818 E BROADWAY SPARTA IL 62286 RANDOLPH (618) 443-2177 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.1239588 -89.6915364 1 ROOFTOP 157 17 17157         https://data.medicare.gov/resource/xubh-q36u/row-x2d7.jahq~9785 141349 659259 2019-11-06 2019-06-30 25           25               25
4184 4184 HARRISBURG MEDICAL CENTER 100 DOCTOR WARREN TUTTLE DR HARRISBURG IL 62946 SALINE (618) 253-7671 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.7310271 -88.5248600 1 ROOFTOP 165 17 17165         https://data.medicare.gov/resource/xubh-q36u/row-8u5r_n3xt~tnqf 140210 660516 2019-11-27 2019-06-30 40           40 30             70
4256 4256 PENDER COMMUNITY HOSPITAL P O BOX 100, 100 HOSPITAL DRIVE PENDER NE 68047 THURSTON (402) 385-3083 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1055877 -96.7110334 1 ROOFTOP 173 31 31173         https://data.medicare.gov/resource/xubh-q36u/row-iane_yp36_h5j2 281349 661213 2019-12-02 2019-06-30 21           21               21
4258 4258 CHEROKEE INDIAN HOSPITAL AUTHORITY CALLER BOX C268 CHEROKEE NC 28719 SWAIN (704) 497-9163 Acute Care Hospitals Government - Federal TRUE 35.4841903 -83.3232054 1 ROOFTOP 173 37 37173         https://data.medicare.gov/resource/xubh-q36u/row-k27i~9abs_tp2y 340156 649941 2019-06-18 2018-09-30 20           20               20
4294 4294 NORTON SOUND REGIONAL HOSPITAL 1000 GREG KRUSCHEK AVENUE (P O BOX 966) NOME AK 99762 NOME (907) 443-3311 Critical Access Hospitals Tribal TRUE 64.4992304 -165.3784042 1 ROOFTOP 180 2 2180         https://data.medicare.gov/resource/xubh-q36u/row-2xs3~z9eg.fia9 21308 646669 2019-04-15 2018-09-30 18           18       18       36
4298 4298 WEBSTER COUNTY COMMUNITY HOSPITAL P O BOX 465, 621 N FRANKLIN ST RED CLOUD NE 68970 WEBSTER (402) 746-5600 Critical Access Hospitals Government - Local TRUE 40.0915582 -98.5280755 1 ROOFTOP 181 31 31181         https://data.medicare.gov/resource/xubh-q36u/row-2g3y_shvn~j8h3 281316 660132 2019-11-26 2019-06-30 13           13               13
4328 4328 YORK GENERAL HOSPITAL 2222 LINCOLN AVE YORK NE 68467 YORK (402) 362-6671 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8824760 -97.5921090 1 ROOFTOP 185 31 31185         https://data.medicare.gov/resource/xubh-q36u/row-dn5r-dnwm.i2as 281336 642099 2019-01-22 2018-09-30 25           25       129       154
4344 4344 MANIILAQ HEALTH CENTER PO BOX 43 KOTZEBUE AK 99752 NORTHWEST ARTIC BOROUGH (907) 442-3321 Critical Access Hospitals Tribal TRUE 66.8961387 -162.5868698 1 ROOFTOP 188 2 2188         https://data.medicare.gov/resource/xubh-q36u/row-5pbr_yrqg~qkzd 21310 646530 2019-03-29 2018-09-30 17           17               17
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27

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