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

4,766 rows sorted by lng descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

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
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
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
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
2409 2409 HEART OF AMERICA MEDICAL CENTER 800 S MAIN AVE RUGBY ND 58368 PIERCE (701) 776-5261 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3635110 -99.9961110 0   69 38 38069         https://data.medicare.gov/resource/xubh-q36u/row-qi8i~9ssv.ufv2 351332 654478 2019-08-30 2019-03-31 25           25       55       80
1796 1796 COZAD COMMUNITY HOSPITAL P O BOX 108, 300 EAST 12TH ST COZAD NE 69130 DAWSON (308) 784-2261 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8608215 -99.9856389 1 ROOFTOP 47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-kmiy~67m8-urj8 281327 654099 2019-09-03 2019-04-30 20           20               20
4615 4615 BALLINGER MEMORIAL HOSPITAL 608 AVENUE B BALLINGER TX 76821 RUNNELS (325) 365-2531 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7498220 -99.9623020 0   399 48 48399         https://data.medicare.gov/resource/xubh-q36u/row-nqcy_n2re.zwit 451310 643973 2019-03-04 2018-09-30 16           16               16
4616 4616 NORTH RUNNELS HOSPITAL 7821 EAST HIGHWAY 153 WINTERS TX 79567 RUNNELS (325) 754-4553 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.9498620 -99.9598240 0   399 48 48399         https://data.medicare.gov/resource/xubh-q36u/row-hszw.eyaq-hdvd 451315 659073 2019-11-18 2019-06-30 15           15               15
3356 3356 AVERA GETTYSBURG HOSPITAL 606 EAST GARFIELD GETTYSBURG SD 57442 POTTER (605) 765-2480 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.0135510 -99.9481280 0   107 46 46107         https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p 431302 660878 2019-12-02 2019-06-30 10           10           50   60
24 24 ST ALOISIUS MEDICAL CENTER 325 E BREWSTER ST HARVEY ND 58341 WELLS (701) 324-4651 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7676870 -99.9330890 0   103 38 38103         https://data.medicare.gov/resource/xubh-q36u/row-u657.4sxp.u7ix 351327 644053 2019-02-27 2018-09-30 25           25       91       116
3855 3855 GRISELL MEMORIAL HOSPITAL 210 SOUTH VERMONT AVENUE RANSOM KS 67572 NESS (785) 731-2231 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.6367100 -99.9315460 0   135 20 20135         https://data.medicare.gov/resource/xubh-q36u/row-m6sz.xvcu-brgm 171300 649227 2019-05-28 2018-12-31 12           12           30   42
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
2085 2085 HARMON MEMORIAL HOSPITAL 400 EAST CHESTNUT STREET HOLLIS OK 73550 HARMON (580) 688-3363 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.6915370 -99.9143660 0   57 40 40057         https://data.medicare.gov/resource/xubh-q36u/row-uie3-brwx.iwxd 371338 661083 2019-12-02 2019-06-30 22           22               22
3856 3856 NESS COUNTY HOSPITAL DISTRICT #2 312 CUSTER STREET NESS CITY KS 67560 NESS (785) 798-2291 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.4578110 -99.9009320 0   135 20 20135         https://data.medicare.gov/resource/xubh-q36u/row-45c5~w9n7~gmam 171336 647293 2019-04-25 2018-12-31 25           25           30   55
4523 4523 ANSON GENERAL HOSPITAL 101 AVENUE J ANSON TX 79501 JONES (325) 823-3231 Acute Care Hospitals Government - Local TRUE 32.7681010 -99.8955140 0   253 48 48253 10180   Outlying Jones County https://data.medicare.gov/resource/xubh-q36u/row-yt33_gjz7-gmyy 450078 653860 2019-09-03 2019-03-31 7           7           6   13
3871 3871 NORTON COUNTY HOSPITAL 102 E HOLME STREET NORTON KS 67654 NORTON (785) 877-3351 Critical Access Hospitals Government - Local TRUE 39.8385290 -99.8887420 0   137 20 20137         https://data.medicare.gov/resource/xubh-q36u/row-2h2e.ibxx~85g5 171348 659681 2019-11-15 2019-06-30 25           25               25
2747 2747 HODGEMAN COUNTY HEALTH CENTER 809 BRAMLEY JETMORE KS 67854 HODGEMAN (620) 357-8361 Critical Access Hospitals Government - Local TRUE 38.0835500 -99.8817850 0   83 20 20083         https://data.medicare.gov/resource/xubh-q36u/row-t9gy-6zw5_ar92 171369 647620 2019-05-06 2018-12-31 25           25               25
1694 1694 NEWMAN MEMORIAL HOSPITAL 905 SOUTH MAIN STREET SHATTUCK OK 73858 ELLIS (580) 938-2551 Critical Access Hospitals Government - Local TRUE 36.2681320 -99.8815380 0   45 40 40045         https://data.medicare.gov/resource/xubh-q36u/row-7tme~3s76_iax8 371336 649132 2019-05-30 2018-12-31 25           25               25
4378 4378 TREGO COUNTY LEMKE MEMORIAL HOSPITAL 320 THIRTEENTH ST WA KEENEY KS 67672 TREGO (785) 743-2182 Critical Access Hospitals Government - Local TRUE 39.0272190 -99.8716200 0   195 20 20195         https://data.medicare.gov/resource/xubh-q36u/row-y4gc.24zy.c8cd 171355 649596 2019-06-03 2018-12-31 25           25           37   62
3760 3760 DIMMIT REGIONAL HOSPITAL 704 HOSPITAL DRIVE CARRIZO SPRINGS TX 78834 DIMMIT (830) 876-2424 Critical Access Hospitals Voluntary non-profit - Other TRUE 28.5199740 -99.8620980 0   127 48 48127         https://data.medicare.gov/resource/xubh-q36u/row-f4ys-ri9j-kfns 451390 643855 2019-03-01 2018-09-30 25           25               25
762 762 BROWN COUNTY HOSPITAL 945 EAST ZERO ST AINSWORTH NE 69210 BROWN (402) 387-2800 Critical Access Hospitals Government - Local TRUE 42.5449340 -99.8500450 0   17 31 31017         https://data.medicare.gov/resource/xubh-q36u/row-7ya9_7bjz.6vjk 281325 659704 2019-11-18 2019-06-30 23           23               23
3068 3068 CONCHO COUNTY HOSPITAL 614 EAKER STREET EDEN TX 76837 CONCHO (915) 869-5911 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.2208850 -99.8478320 0   95 48 48095         https://data.medicare.gov/resource/xubh-q36u/row-gyb7_xqfh_6ezj 451325 643976 2019-03-04 2018-09-30 16           16               16
3695 3695 WINNER REGIONAL HEALTHCARE CENTER - CAH 745 EAST 8TH STREET WINNER SD 57580 TRIPP (605) 842-7100 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3709470 -99.8476170 0   123 46 46123         https://data.medicare.gov/resource/xubh-q36u/row-8vjy-k644_c637 431334 650611 2019-05-30 2018-12-31 25           25       80       105
2304 2304 GRAHAM COUNTY HOSPITAL 304 WEST PROUT STREET HILL CITY KS 67642 GRAHAM (785) 421-2121 Critical Access Hospitals Government - Local TRUE 39.3717760 -99.8450750 0   65 20 20065         https://data.medicare.gov/resource/xubh-q36u/row-6pnf-hu89-upev 171325 648831 2019-05-28 2018-12-31 20           20               20
4538 4538 KNOX COUNTY HOSPITAL 701 SOUTHEAST 5TH STREET KNOX CITY TX 79529 KNOX (940) 657-3535 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.4141070 -99.8114510 0   275 48 48275         https://data.medicare.gov/resource/xubh-q36u/row-7yyt-3mtc_a7wb 450746 652728 2019-08-01 2019-02-28 28           28               28
4534 4534 KIMBLE HOSPITAL 349 REID ROAD JUNCTION TX 76849 KIMBLE (325) 446-3321 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.4991940 -99.7802540 0   267 48 48267         https://data.medicare.gov/resource/xubh-q36u/row-k7bm_txp3.mutf 451306 643379 2019-02-20 2018-09-30 15           15               15
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
4681 4681 UVALDE MEMORIAL HOSPITAL 1025 GARNER FIELD ROAD UVALDE TX 78801 UVALDE (830) 278-6251 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.2151260 -99.7686680 0   463 48 48463 46620   Central Uvalde County https://data.medicare.gov/resource/xubh-q36u/row-v3yf_upph.s38x 451387 660893 2019-11-29 2019-06-30 15 6         21               21
1795 1795 LEXINGTON REGIONAL HEALTH CENTER P O BOX 980, 1201 NORTH ERIE ST LEXINGTON NE 68850 DAWSON (308) 324-5651 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.7858157 -99.7587068 1 ROOFTOP 47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dbaj_tjsz.ntkv 281361 655216 2019-10-02 2019-06-30 25           25               25
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
4455 4455 HASKELL MEMORIAL HOSPITAL 1 NORTH AVENUE N PO BOX 1117 HASKELL TX 79521 HASKELL (940) 864-2621 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.1572901 -99.7446581 1 ROOFTOP 207 48 48207         https://data.medicare.gov/resource/xubh-q36u/row-66f3~mect.vjwe 451341 644375 2019-03-01 2018-09-30 25           25               25
4659 4659 ABILENE REGIONAL MEDICAL CENTER 6250 HWY 83/84 ABILENE TX 79606 TAYLOR (325) 428-1000 Acute Care Hospitals Proprietary TRUE 32.3740060 -99.7425950 0   441 48 48441 10180   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-rque_a7mi~an5d 450558 657529 2019-04-12 2018-08-31 160 20         196               196
4391 4391 HARDEMAN COUNTY MEMORIAL HOSPITAL 402 MERCER ST QUANAH TX 79252 HARDEMAN (940) 663-2795 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.2965660 -99.7410560 0   197 48 48197         https://data.medicare.gov/resource/xubh-q36u/row-u2zf.mvvx_urz7 451352 648770 2019-05-24 2018-12-31 24           24               24
4660 4660 HENDRICK MEDICAL CENTER 1900 PINE ABILENE TX 79601 TAYLOR (325) 670-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4715530 -99.7311800 0   441 48 48441 10180   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-ewhh-9kze-g39u 450229 662437 2019-01-28 2018-08-31 220 46 44     25 335   31   20       386
3791 3791 ROGER MILLS MEMORIAL HOSPITAL 501 SOUTH L L MALES AVENUE CHEYENNE OK 73628 ROGER MILLS (580) 497-3336 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.6092050 -99.6719970 0   129 40 40129         https://data.medicare.gov/resource/xubh-q36u/row-6ptj~4g4e-4ctv 371303 653453 2019-09-04 2019-04-30 15           15               15
1764 1764 BOWDLE HOSPITAL - CAH 8001 W 5TH POST OFFICE BOX 556 BOWDLE SD 57428 EDMUNDS (605) 285-6146 Critical Access Hospitals Government - Local TRUE 45.4480531 -99.6609364 1 ROOFTOP 45 46 46045 10100   Outlying Edmunds County https://data.medicare.gov/resource/xubh-q36u/row-q6h5.bajv_fkde 431318 637935 2018-11-26 2018-06-30 12           12       34       46
1653 1653 JENNIE M MELHAM MEMORIAL MEDICAL CENTER 145 MEMORIAL DRIVE BROKEN BOW NE 68822 CUSTER (308) 872-4100 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4090540 -99.6322620 0   41 31 31041         https://data.medicare.gov/resource/xubh-q36u/row-j4ps~9hc7.f4ta 281365 643047 2019-01-30 2018-09-30 23           23               23
2159 2159 HARPER COUNTY COMMUNITY HOSPITAL 1003 US HIGHWAY 64 NORTH BUFFALO OK 73834 HARPER (580) 735-2555 Critical Access Hospitals Government - Local TRUE 36.8449660 -99.6293020 0   59 40 40059         https://data.medicare.gov/resource/xubh-q36u/row-ubpf.zpwz~4xju 371324 643003 2019-02-11 2018-09-30 15           15               15
2656 2656 PRESENTATION MEDICAL CENTER 213 SECOND AVE NE ROLLA ND 58367 ROLETTE (701) 477-3161 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.8615620 -99.6155150 0   79 38 38079         https://data.medicare.gov/resource/xubh-q36u/row-e43c~yjqv.3ca8 351316 643363 2019-02-22 2018-09-30 25           25               25
2926 2926 EUREKA COMMUNITY HEALTH SERVICES - CAH 200 J AVE POST OFFICE BOX 517 EUREKA SD 57437 MC PHERSON (605) 284-2661 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.7671960 -99.6144530 0   89 46 46089         https://data.medicare.gov/resource/xubh-q36u/row-63d5-93ah~nnd5 431308 658588 2019-11-12 2019-06-30 4           4               4
1918 1918 WISHEK COMMUNITY HOSPITAL 1007 4TH AVE S WISHEK ND 58495 MCINTOSH (701) 452-2326 Critical Access Hospitals Government - Local TRUE 46.2551230 -99.5515380 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-zinj~5aa6.fhse 351321 648453 2019-05-20 2018-12-31 24           24               24
4021 4021 ROCK COUNTY HOSPITAL 102 EAST SOUTH STREET BASSETT NE 68714 HOLT (402) 684-3366 Critical Access Hospitals Government - Local TRUE 42.5758120 -99.5378910 0   149 31 31149         https://data.medicare.gov/resource/xubh-q36u/row-288b-nrv4_cahh 281333 659705 2019-11-18 2019-06-30 24           24       30       54
4392 4392 CHILLICOTHE HOSPITAL DISTRICT 303 AVENUE I CHILLICOTHE TX 79225 HARDEMAN (940) 852-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.2552390 -99.5159870 0   197 48 48197         https://data.medicare.gov/resource/xubh-q36u/row-za2j_kn4r_u56a 451326 662273 2019-12-19 2019-07-22 21           21               21
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
4691 4691 LAREDO MEDICAL CENTER 1700 EAST SAUNDERS LAREDO TX 78044 WEBB (956) 796-5000 Acute Care Hospitals Proprietary TRUE 27.5306000 -99.4785710 0   479 48 48479 29700   Central Webb County https://data.medicare.gov/resource/xubh-q36u/row-qxph_4v72_5xf8 450029 645610 2019-03-01 2018-09-30 235 32         284       18       302
4690 4690 DOCTORS HOSPITAL OF LAREDO 10700 MCPHERSON ROAD LAREDO TX 78041 WEBB (956) 523-2000 Acute Care Hospitals Proprietary TRUE 27.6070900 -99.4762810 0   479 48 48479 29700   Central Webb County https://data.medicare.gov/resource/xubh-q36u/row-6c8y.r68k.t52s 450643 648988 2019-05-28 2018-12-31 135 24         171   12           183
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
460 460 GREAT PLAINS REGIONAL MEDICAL CENTER 1801 WEST 3RD STREET ELK CITY OK 73644 BECKHAM (580) 225-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4117210 -99.4256540 0   9 40 40009 21120   Central Beckham County https://data.medicare.gov/resource/xubh-q36u/row-ygr6~ifvk~u3j8 370019 660278 2019-11-27 2019-06-30 28 6         34 12 8           54
2770 2770 COLEMAN COUNTY MEDICAL CENTER COMPANY 310 SOUTH PECOS STREET COLEMAN TX 76834 COLEMAN (325) 625-2135 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8286260 -99.4252380 0   83 48 48083         https://data.medicare.gov/resource/xubh-q36u/row-arcj.jjrh_hge7 451347 643742 2019-02-28 2018-09-30 25           25               25
1780 1780 EDWARDS COUNTY HOSPITAL 620 WEST EIGHTH STREET KINSLEY KS 67547 EDWARDS (620) 659-3621 Critical Access Hospitals Government - Local TRUE 37.9207150 -99.4194310 0   47 20 20047         https://data.medicare.gov/resource/xubh-q36u/row-g83e~5vmg-b2c4 171317 648916 2019-05-28 2018-12-31 12           12 10             22
4069 4069 ALLIANCEHEALTH WOODWARD 900 17TH STREET WOODWARD OK 73801 WOODWARD (580) 254-8492 Acute Care Hospitals Proprietary TRUE 36.4378610 -99.4009540 0   153 40 40153 49260   Central Woodward County https://data.medicare.gov/resource/xubh-q36u/row-xvc5-zx2v~yrxt 370002 659337 2019-11-07 2019-05-31 34 6         40               40
3883 3883 PHELPS MEMORIAL HEALTH CENTER 1215 TIBBALS ST HOLDREGE NE 68949 PHELPS (308) 995-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4476550 -99.3820050 0   137 31 31137         https://data.medicare.gov/resource/xubh-q36u/row-uc3e.tz6g-km24 281362 647628 2019-05-02 2018-12-31 25           25               25
1917 1917 ASHLEY MEDICAL CENTER 612 CENTER AVENUE N ASHLEY ND 58413 MCINTOSH (701) 288-3433 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0401880 -99.3717150 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-ecd4.9q4x_twgv 351322 661581 2019-12-02 2019-06-30 20           20       40       60
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
4566 4566 HEART OF TEXAS MEMORIAL HOSPITAL 2008 NINE ROAD BRADY TX 76825 MC CULLOCH (325) 597-2901 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.1163340 -99.3466000 0   307 48 48307         https://data.medicare.gov/resource/xubh-q36u/row-kqsv.fye9_9h3c 451348 653867 2019-09-03 2019-03-31 14           14               14
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
713 713 SANFORD CHAMBERLAIN MEDICAL CENTER 300 S BYRON CHAMBERLAIN SD 57325 BRULE (605) 234-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7851100 -99.3261340 0   15 46 46015         https://data.medicare.gov/resource/xubh-q36u/row-cv97_2b3i.ibpd 431329 652106 2019-05-30 2018-12-31 25           25         44     69
2319 2319 JACKSON COUNTY MEMORIAL HOSPITAL AUTHORITY 1200 EAST PECAN ST ALTUS OK 73521 JACKSON (580) 379-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6352730 -99.3191190 0   65 40 40065 11060   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-grzh.mrwf.u2yy 370022 660425 2019-11-27 2019-06-30 43 6         49               49
4187 4187 RUSH COUNTY MEMORIAL HOSPITAL 801 LOCUST ST LA CROSSE KS 67548 RUSH (785) 222-2545 Critical Access Hospitals Government - Local FALSE 38.5305970 -99.3165720 0   165 20 20165         https://data.medicare.gov/resource/xubh-q36u/row-kzd7-vdnf-jix7 171342 650577 2019-06-04 2018-12-31 16           16               16
3997 3997 PHILLIPS COUNTY HEALTH SYSTEMS 1150 STATE STREET PHILLIPSBURG KS 67661 PHILLIPS (785) 543-5226 Critical Access Hospitals Government - Local TRUE 39.7558850 -99.3135760 0   147 20 20147         https://data.medicare.gov/resource/xubh-q36u/row-e4xe_bqr9-weeq 171353 654090 2019-09-03 2019-03-31 25           25               25
4698 4698 WILBARGER GENERAL HOSPITAL 920 HILLCREST DR VERNON TX 76384 WILBARGER (940) 552-9351 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1594190 -99.3133300 0   487 48 48487 46900   Central Wilbarger County https://data.medicare.gov/resource/xubh-q36u/row-5iha_7mw4.8q3u 450584 643852 2019-02-28 2018-09-30 47           47               47
3107 3107 KIOWA COUNTY MEMORIAL HOSPITAL 721 WEST KANSAS GREENSBURG KS 67054 KIOWA (620) 723-3341 Critical Access Hospitals Government - Local FALSE 37.6061670 -99.3017740 0   97 20 20097         https://data.medicare.gov/resource/xubh-q36u/row-n4kk~wxaj~msuf 171332 648919 2019-05-28 2018-12-31 15           15               15
1900 1900 HAYS MEDICAL CENTER 2220 CANTERBURY DRIVE HAYS KS 67601 ELLIS (785) 623-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.8796040 -99.2992730 0   51 20 20051 25700   Central Ellis County https://data.medicare.gov/resource/xubh-q36u/row-p3vh.37wj~25bf 170013 662378 2019-12-06 2019-06-30 115 34         149               149
4158 4158 ROOKS COUNTY HEALTH CENTER 1210 NORTH WASHINGTON PLAINVILLE KS 67663 ROOKS (785) 434-4553 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2479670 -99.2982030 0   163 20 20163         https://data.medicare.gov/resource/xubh-q36u/row-y4ci.d2n6.6wdh 171311 651275 2019-06-12 2018-12-31 16           16               16
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
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
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
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
4532 4532 PETERSON REGIONAL MEDICAL CENTER 551 HILL COUNTRY DRIVE KERRVILLE TX 78028 KERR (830) 896-4200 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.0449440 -99.1518570 0   265 48 48265 28500   Central Kerr County https://data.medicare.gov/resource/xubh-q36u/row-3z7r_z2w3~jek6 450007 662258 2019-12-02 2019-06-30 72 12         84   26           110
4577 4577 MEDINA REGIONAL HOSPITAL 3100 AVENUE E HONDO TX 78861 MEDINA (830) 426-7700 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.3352470 -99.1334160 0   325 48 48325 41700   Outlying Medina County https://data.medicare.gov/resource/xubh-q36u/row-i6se_ecqu-nzyr 451330 643655 2019-02-27 2018-09-30 25           25               25
1874 1874 FAULKTON AREA MEDICAL CENTER 1300 OAK STREET POST OFFICE BOX 100 FAULKTON SD 57438 FAULK (605) 598-6262 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.0299990 -99.1315700 0   49 46 46049         https://data.medicare.gov/resource/xubh-q36u/row-9wwa-ei6u.pihr 431301 646881 2019-04-25 2018-12-31 12           12               12
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
34 34 FRIO REGIONAL HOSPITAL 200 S IH 35 PEARSALL TX 78061 FRIO (830) 334-3617 Critical Access Hospitals Voluntary non-profit - Private TRUE 28.8970480 -99.1160130 0   163 48 48163         https://data.medicare.gov/resource/xubh-q36u/row-9gys.vgtu~2pyx 451391 650214 2019-06-03 2018-12-31 24           24               24
3973 3973 PAWNEE VALLEY COMMUNITY HOSPITAL 923 CARROLL AVENUE LARNED KS 67550 PAWNEE (620) 285-3162 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.1841610 -99.1065960 0   145 20 20145         https://data.medicare.gov/resource/xubh-q36u/row-si98~suze_dh6c 171345 662379 2019-12-06 2019-06-30 22           22               22
2582 2582 ELKVIEW GENERAL HOSPITAL 429 WEST ELM STREET HOBART OK 73651 KIOWA (580) 726-3324 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.0368290 -99.0983400 0   75 40 40075         https://data.medicare.gov/resource/xubh-q36u/row-gdd4_6kz4-h5ey 370153 659714 2019-11-25 2019-06-30 38           38               38
842 842 KEARNEY REGIONAL MEDICAL CENTER 804 22ND AVENUE KEARNEY NE 68845 BUFFALO (308) 455-3600 Acute Care Hospitals Proprietary TRUE 40.6975000 -99.0931000 0   19 31 31019 28260   Central Buffalo County https://data.medicare.gov/resource/xubh-q36u/row-3996-74wm-rsdj 280134 650297 2019-06-04 2018-12-31 68 18         94               94
843 843 CHI HEALTH GOOD SAMARITAN P O BOX 1990, 10 EAST 31ST ST KEARNEY NE 68848 BUFFALO (308) 865-7100 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7076254 -99.0818136 1 ROOFTOP 19 31 31019 28260   Central Buffalo County https://data.medicare.gov/resource/xubh-q36u/row-k4e3_xakc.p7ct 280009 661546 2019-12-02 2019-06-30 201 16       10 227   12           239
1607 1607 ALLIANCEHEALTH CLINTON 100 NORTH 30TH STREET CLINTON OK 73601 CUSTER (580) 323-2363 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.5147890 -98.9968790 0   39 40 40039 48220   Central Custer County https://data.medicare.gov/resource/xubh-q36u/row-dvix_7ap3~spry 370029 653451 2019-08-30 2019-03-31 41 4         45   11           56
2165 2165 AVERA HAND COUNTY MEMORIAL HOSPITAL AND CLINIC 300 W 5TH ST MILLER SD 57362 HAND (605) 853-2421 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5206230 -98.9920440 0   59 46 46059         https://data.medicare.gov/resource/xubh-q36u/row-cen8-s23k_ktis 431337 662584 2019-11-27 2019-06-30 25           25               25
1875 1875 BROWNWOOD REGIONAL MEDICAL CENTER 1501 BURNET DR BROWNWOOD TX 76801 BROWN (325) 646-8541 Acute Care Hospitals Proprietary TRUE 31.6802110 -98.9881580 0   49 48 48049 15220   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-mwhq-a826-mmad 450587 645612 2019-03-01 2018-09-30 65 12         77               77
4024 4024 CORDELL MEMORIAL HOSPITAL 1220 NORTH GLENN ENGLISH STREET CORDELL OK 73632 WASHITA (580) 832-3339 Critical Access Hospitals Government - Local TRUE 35.3025240 -98.9875950 0   149 40 40149         https://data.medicare.gov/resource/xubh-q36u/row-k6qa-iqdm.jnj9 371325 660005 2019-12-03 2019-06-30 14           14               14
2912 2912 WEST HOLT MEMORIAL HOSPITAL 406 W NEELY ST ATKINSON NE 68713 HOLT (402) 925-2811 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.5285300 -98.9823600 0   89 31 31089         https://data.medicare.gov/resource/xubh-q36u/row-4yu8_vi3f~x2qc 281343 659706 2019-11-21 2019-06-30 17           17               17
2197 2197 FRANKLIN COUNTY MEMORIAL HOSPITAL 1406 Q ST FRANKLIN NE 68939 FRANKLIN (308) 425-6221 Critical Access Hospitals Government - Local TRUE 40.1015520 -98.9543530 0   61 31 31061         https://data.medicare.gov/resource/xubh-q36u/row-7jps~ae6v.42rk 281311 656707 2019-11-05 2019-06-30 14           14               14
3171 3171 KEARNEY COUNTY HEALTH SERVICES HOSPITAL 727 EAST 1ST ST MINDEN NE 68959 KEARNEY (308) 832-3400 Critical Access Hospitals Government - Local TRUE 40.4957780 -98.9432030 0   99 31 31099 28260   Outlying Kearney County https://data.medicare.gov/resource/xubh-q36u/row-aaj3.vtp7.jy9v 281306 654341 2019-09-09 2019-06-30 10           10               10
4268 4268 VALLEY COUNTY HEALTH SYSTEM 2707 L STREET ORD NE 68862 VALLEY (308) 728-4200 Critical Access Hospitals Government - Local TRUE 41.6032130 -98.9426760 0   175 31 31175         https://data.medicare.gov/resource/xubh-q36u/row-y2qv_7x4q_v7xu 281353 661044 2019-12-02 2019-06-30 16           16               16
4697 4697 ELECTRA MEMORIAL HOSPITAL 1207 S BAILEY STREET ELECTRA TX 76360 WICHITA (940) 495-3981 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.0184550 -98.9238740 0   485 48 48485 48660   Central Wichita County https://data.medicare.gov/resource/xubh-q36u/row-cvz8.wx35~2ua3 451343 643657 2019-02-25 2018-09-30 19           19               19
1703 1703 SEILING MUNICIPAL HOSPITAL 809 NE HIGHWAY 60 SEILING OK 73663 DEWEY (580) 922-7361 Critical Access Hospitals Government - Local TRUE 36.1574590 -98.9207150 0   43 40 40043         https://data.medicare.gov/resource/xubh-q36u/row-79bz~vfcy-sppu 371332 660432 2019-11-29 2019-06-30 18           18               18
4629 4629 STEPHENS MEMORIAL HOSPITAL 200 SOUTH GENEVA STREET BRECKENRIDGE TX 76424 STEPHENS (254) 559-2241 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7540560 -98.8877190 0   429 48 48429         https://data.medicare.gov/resource/xubh-q36u/row-f2c3_a9xb.afpq 450498 643739 2019-02-27 2018-09-30 14           14               14
4241 4241 HILL COUNTRY MEMORIAL HOSPITAL INC 1020 SOUTH STATE HIGHWAY 16 FREDERICKSBURG TX 78624 GILLESPIE (830) 997-4353 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2621870 -98.8804910 0   171 48 48171 23240   Central Gillespie County https://data.medicare.gov/resource/xubh-q36u/row-68bj-cvh3~s9pp 450604 654758 2019-10-03 2018-12-31 47 10         57               57
4628 4628 STARR COUNTY MEMORIAL HOSPITAL 128 N FM RD 3167 RIO GRANDE CITY TX 78582 STARR (956) 487-5561 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.3775400 -98.8598860 0   427 48 48427 40100 McAllen-Edinburg, TX Central Starr County https://data.medicare.gov/resource/xubh-q36u/row-x724_tbx6~dpen 450654 646242 2019-03-19 2018-09-30 48           48               48
4205 4205 RUSSELL REGIONAL HOSPITAL 200 S MAIN STREET RUSSELL KS 67665 RUSSELL (785) 483-3131 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8832620 -98.8598360 0   167 20 20167         https://data.medicare.gov/resource/xubh-q36u/row-jqcp-w49x~7w2h 171350 640712 2019-01-03 2018-07-31 19           19           22   41
2478 2478 CHI ST ALEXIUS HEALTH DEVILS LAKE 1031 7TH ST NE DEVILS LAKE ND 58301 RAMSEY (701) 662-2131 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1147740 -98.8503450 0   71 38 38071         https://data.medicare.gov/resource/xubh-q36u/row-i8ea.ub9b_eqnm 351333 662067 2019-12-02 2019-06-30 25           25               25
981 981 PLATTE HEALTH CENTER - CAH 601 E 7TH ST POST OFFICE BOX 200 PLATTE SD 57369 CHARLES MIX (605) 337-3364 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3841820 -98.8363950 0   23 46 46023         https://data.medicare.gov/resource/xubh-q36u/row-xvc7~qr28~rnsw 431306 656513 2019-11-05 2019-06-30 17           17           48   65
3844 3844 EASTLAND MEMORIAL HOSPITAL 304 S DAUGHERTY EASTLAND TX 76448 EASTLAND (254) 629-2601 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4004390 -98.8216360 0   133 48 48133         https://data.medicare.gov/resource/xubh-q36u/row-uts8~dkzz-h488 450411 660325 2019-12-02 2019-06-30 36           36               36
431 431 UNIVERSITY OF KS HLTH SYSTEM GREAT BEND CAMPUS 514 CLEVELAND STREET GREAT BEND KS 67530 BARTON (620) 792-8833 Acute Care Hospitals Proprietary TRUE 38.3562000 -98.7916190 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-ezt6_4fjw-kpxn 170191 660092 2019-11-26 2019-06-30 29 4         33               33
432 432 CLARA BARTON HOSPITAL 250 W 9TH STREET HOISINGTON KS 67544 BARTON (620) 653-2114 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.5215490 -98.7794100 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-fy4c.k945-z7ft 171333 648920 2019-05-28 2018-12-31 18           18               18
4308 4308 SMITH COUNTY MEMORIAL HOSPITAL 921 E. HIGHWAY 36 SMITH CENTER KS 66967 SMITH (785) 282-6845 Critical Access Hospitals Government - Local TRUE 39.7852490 -98.7727680 0   183 20 20183         https://data.medicare.gov/resource/xubh-q36u/row-2xcp~xm86-a2da 171377 654020 2019-08-29 2019-03-31 16           16               16
4711 4711 HAMILTON HOSPITAL 901 WEST HAMILTON OLNEY TX 76374 YOUNG (940) 564-5521 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.3696690 -98.7646300 0   503 48 48503         https://data.medicare.gov/resource/xubh-q36u/row-2jrh~g63r.wnym 451354 652730 2019-07-31 2019-02-28 25           25               25
3007 3007 JAMESTOWN REGIONAL MEDICAL CENTER 2422 20TH ST SW JAMESTOWN ND 58401 STUTSMAN (701) 252-1050 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.8879400 -98.7493770 0   93 38 38093 27420   Central Stutsman County https://data.medicare.gov/resource/xubh-q36u/row-592i~zkzj_6zsv 351335 660000 2019-11-26 2019-06-30 19 6         25               25
4032 4032 PRATT REGIONAL MEDICAL CENTER 200 COMMODORE ST PRATT KS 67124 PRATT (620) 450-1160 Acute Care Hospitals Proprietary TRUE 37.6453650 -98.7293670 0   151 20 20151         https://data.medicare.gov/resource/xubh-q36u/row-7vie.23jw-s3kw 170027 643206 2019-02-11 2018-09-30 29 6         35       46       81
3917 3917 OSBORNE COUNTY MEMORIAL HOSPITAL 424 W NEW HAMPSHIRE STREET OSBORNE KS 67473 OSBORNE (785) 346-2121 Critical Access Hospitals Government - Local TRUE 39.4366820 -98.7011590 0   141 20 20141         https://data.medicare.gov/resource/xubh-q36u/row-fbsc.wavi.k36j 171364 648924 2019-05-30 2018-12-31 24           24               24

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