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 all_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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 ▼
1794 1794 GOTHENBURG MEMORIAL HOSPITAL 910 20TH ST GOTHENBURG NE 69138 DAWSON (308) 537-3661 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9381320 -100.1533520 0   47 31 31047 30420   Central Dawson County https://data.medicare.gov/resource/xubh-q36u/row-dgzd-a44k.k83g 281313 661037 2019-12-02 2019-06-30 12           12               12
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
2341 2341 ANIMAS SURGICAL HOSPITAL, LLC 575 RIVERGATE LN DURANGO CO 81301 LA PLATA (970) 247-3537 Acute Care Hospitals Physician TRUE 37.2488890 -107.8707740 0   67 8 8067 20420   Central La Plata County https://data.medicare.gov/resource/xubh-q36u/row-twp9-b345.bypu 60117 650115 2019-05-31 2018-12-31 12           12               12
2498 2498 UAB CALLAHAN EYE HOSPITAL AUTHORITY 1720 UNIVERSITY BLVD, SUITE 500 BIRMINGHAM AL 35233 JEFFERSON (205) 325-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5031370 -86.8024010 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-txeu_r7zi.ibaa 10018 644082 2019-03-01 2018-09-30 12           12               12
2790 2790 HOLTON COMMUNITY HOSPITAL 1110 COLUMBINE DRIVE HOLTON KS 66436 JACKSON (785) 364-2116 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4794640 -95.7509080 0   85 20 20085 45820   Outlying Jackson County https://data.medicare.gov/resource/xubh-q36u/row-8a8r_8yba-yt3v 171319 653242 2019-08-21 2019-03-31 12           12               12
2802 2802 STANDING ROCK INDIAN HEALTH SERVICE HOSPITAL 10 NORTH RIVER ROAD FORT YATES ND 58538 SIOUX (701) 854-3831 Acute Care Hospitals Government - Federal TRUE 46.0952325 -100.6281136 1 ROOFTOP 85 38 38085 13900   Outlying Sioux County https://data.medicare.gov/resource/xubh-q36u/row-a84q-rj3h~6yed 350064 651228 2019-06-18 2018-09-30 12           12               12
2908 2908 NORTH VALLEY HEALTH CENTER 300 WEST GOOD SAMARITAN DRIVE WARREN MN 56762 MARSHALL (218) 745-4211 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1927360 -96.7743980 0   89 27 27089         https://data.medicare.gov/resource/xubh-q36u/row-5hr9-apeq-pgtf 241337 651012 2019-06-04 2018-12-31 12           12               12
2947 2947 KANSAS CITY ORTHOPAEDIC INSTITUTE 3651 COLLEGE BLVD LEAWOOD KS 66211 JOHNSON (913) 319-7633 Acute Care Hospitals Physician FALSE 38.9275490 -94.6282350 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-s6dg~iufq_ybuc 170188 649225 2019-05-31 2018-12-31 12           12               12
2967 2967 PHYSICIAN'S CARE SURGICAL HOSPITAL 454 ENTERPRISE DRIVE ROYERSFORD PA 19468 MONTGOMERY (610) 495-4793 Acute Care Hospitals Physician FALSE 40.2167860 -75.5537070 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-xf95-5spw~uirp 390324 646044 2019-04-01 2018-10-31 12           12               12
3159 3159 OSWEGO COMMUNITY HOSPITAL 800 BARKER DRIVE OSWEGO KS 67356 LABETTE (620) 795-2921 Critical Access Hospitals Proprietary TRUE 37.1596730 -95.1107700 0   99 20 20099 37660   Central Labette County https://data.medicare.gov/resource/xubh-q36u/row-r8kw_57qd_r6fs 171302 643032 2019-01-29 2018-09-30 12           12               12
3399 3399 SURGICAL HOSPITAL OF OKLAHOMA, LLC 100 SOUTHEAST 59TH STREET OKLAHOMA CITY OK 73129 OKLAHOMA (405) 634-9300 Acute Care Hospitals Physician TRUE 35.4062250 -97.5093160 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-drs8-u5z4.yfq6 370201 649812 2019-05-31 2018-12-31 12           12               12
4058 4058 SCHOOLCRAFT MEMORIAL HOSPITAL 7870W US HIGHWAY 2 MANISTIQUE MI 49854 SCHOOLCRAFT (906) 341-3200 Critical Access Hospitals Government - Local TRUE 45.9449630 -86.2757160 0   153 26 26153         https://data.medicare.gov/resource/xubh-q36u/row-i54k_s479.sfn4 231303 650833 2019-06-06 2018-12-31 12           12               12
4302 4302 BAYLOR SCOTT AND WHITE SURGICAL HOSPITAL AT SHERMA 3601 CALAIS DRIVE SHERMAN TX 75090 GRAYSON (903) 813-3728 Acute Care Hospitals Physician TRUE 33.6768600 -96.6025270 0   181 48 48181 43300 Dallas-Fort Worth, TX-OK Central Grayson County https://data.medicare.gov/resource/xubh-q36u/row-4y3f.tmsq.cez5 670076 648878 2019-05-28 2018-12-31 12           12               12
4426 4426 FIRST TEXAS HOSPITAL 9922 LOUETTA RD HOUSTON TX 77070 HARRIS (844) 264-1435 Acute Care Hospitals Proprietary TRUE 30.0008390 -95.5608680 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-t68p~4ggy.94di 670118 649157 2019-05-30 2018-12-31 12           12               12
4631 4631 LILLIAN M HUDSPETH MEMORIAL HOSPITAL 308 HUDSPETH SONORA TX 76950 SUTTON (325) 387-2521 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.5637580 -100.6348700 0   435 48 48435         https://data.medicare.gov/resource/xubh-q36u/row-i9e9_qde3.um4r 451324 652847 2019-08-21 2018-12-31 12           12               12
1450 1450 OAKLEAF SURGICAL HOSPITAL 1000 OAKLEAF WAY ALTOONA WI 54720 EAU CLAIRE (715) 831-8130 Acute Care Hospitals Physician FALSE 44.8150020 -91.4517640 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-4tiq~2hj5~t8xv 520196 650624 2019-05-30 2018-12-31 13           13               13
1731 1731 VALOR HEALTH 1202 EAST LOCUST STREET EMMETT ID 83617 GEM (208) 365-3561 Critical Access Hospitals Government - Local TRUE 43.8790780 -116.4852550 0   45 16 16045 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Gem County https://data.medicare.gov/resource/xubh-q36u/row-cch8-kmmd-nmhb 131318 644635 2019-02-28 2018-09-30 13           13               13
2081 2081 SAKAKAWEA MEDICAL CENTER - CAH 510 8TH AVENUE NE HAZEN ND 58545 MERCER (701) 748-2225 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2982860 -101.6115600 0   57 38 38057         https://data.medicare.gov/resource/xubh-q36u/row-772i_c662.4xam 351310 660272 2019-11-25 2019-06-30 13           13               13
2693 2693 TETON VALLEY HOSPITAL 120 EAST HOWARD AVE DRIGGS ID 83422 TETON (208) 354-2383 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7272850 -111.1086080 0   81 16 16081 27220   Outlying Teton County https://data.medicare.gov/resource/xubh-q36u/row-73s3-g6zw_arid 131313 643497 2019-02-27 2018-09-30 13           13               13
3165 3165 SOUTHEAST MICHIGAN SURGICAL HOSPITAL 21230 DEQUINDRE ROAD WARREN MI 48091 MACOMB (586) 427-1000 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.4513950 -83.0835600 0   99 26 26099 19820 Detroit-Warren-Ann Arbor, MI Central Macomb County https://data.medicare.gov/resource/xubh-q36u/row-n5cw~k8mz~eeh4 230264 650280 2019-06-03 2018-12-31 13           13               13
4135 4135 MANHATTAN SURGICAL HOSPITAL LLC 1829 COLLEGE AVENUE MANHATTAN KS 66502 RILEY (785) 776-5100 Acute Care Hospitals Physician FALSE 39.2028260 -96.5981830 0   161 20 20161 31740 Manhattan-Junction City, KS Central Riley County https://data.medicare.gov/resource/xubh-q36u/row-5vw9~wxt5.eejp 170190 648618 2019-05-24 2018-12-31 13           13               13
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
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
25 25 ESSENTIA HEALTH ADA 201 9TH STREET WEST ADA MN 56510 NORMAN (218) 784-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2960910 -96.5301900 0   107 27 27107         https://data.medicare.gov/resource/xubh-q36u/row-z63y_de5x~9s9u 241313 660607 2019-11-26 2019-06-30 14           14               14
136 136 COPPER QUEEN COMMUNITY HOSPITAL 101 COLE AVENUE BISBEE AZ 85603 COCHISE (520) 432-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.4172540 -109.8826000 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-3x2q~x9dv.fg6n 31312 659555 2019-11-25 2019-06-30 14           14               14
426 426 LANAI COMMUNITY HOSPITAL 628 7TH STREET LANAI CITY HI 96763 MAUI (808) 565-8450 Critical Access Hospitals Government - State TRUE 20.8267350 -156.9180020 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-keiy_dtd7_smny 121305 648608 2019-06-03 2018-12-31 4           4       10       14
795 795 BATH COMMUNITY HOSPITAL 106 PARK DRIVE- PO DRAWER Z HOT SPRINGS VA 24445 BATH (540) 839-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9938900 -79.8309590 0   17 51 51017         https://data.medicare.gov/resource/xubh-q36u/row-36k3~dwrj~zvyd 491300 650420 2019-05-31 2018-12-31 14           14               14
800 800 SELLS HOSPITAL HIGHWAY 86, AT TOPAWA ROAD SELLS AZ 85634 PIMA (520) 362-7003 Acute Care Hospitals Tribal TRUE 31.9183549 -111.8792747 1 GEOMETRIC_CENTER 19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-57e8_mqp9-5x9d 30074 651599 2019-07-10 2018-09-30 14           14               14
950 950 LOST RIVERS MEDICAL CENTER 551 HIGHLAND DRIVE ARCO ID 83213 BUTTE (208) 252-7654 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6405520 -113.2962530 0   23 16 16023 26820 Idaho Falls-Rexburg-Blackfoot, ID Outlying Butte County https://data.medicare.gov/resource/xubh-q36u/row-77px.m9qb~bsww 131324 640856 2019-01-08 2018-09-30 14           14               14
978 978 BLUE MOUNTAIN HOSPITAL 170 FORD ROAD JOHN DAY OR 97845 GRANT (541) 575-1311 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4176510 -118.9592200 0   23 41 41023         https://data.medicare.gov/resource/xubh-q36u/row-svyy.cxkf.r4qf 381305 662576 2019-11-27 2019-06-30 14           14               14
1161 1161 LINTON HOSPITAL - CAH 518 NORTH BROADWAY LINTON ND 58552 EMMONS (701) 254-4511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.2710630 -100.2328710 0   29 38 38029         https://data.medicare.gov/resource/xubh-q36u/row-zu7c~i74a~kiv4 351328 651912 2019-07-15 2019-03-31 14           14               14
1612 1612 PEACEHEALTH COTTAGE GROVE COMMUNITY MEDICAL CENTER 1515 VILLAGE DRIVE COTTAGE GROVE OR 97424 LANE (541) 767-5202 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.8038370 -123.0386760 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-6buq_rs3k.th8r 381301 640536 2018-11-30 2018-06-30 14           14               14
1619 1619 SWEENY COMMUNITY HOSPITAL 305 NORTH MCKINNEY SWEENY TX 77480 BRAZORIA (979) 548-3311 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.0485140 -95.6913920 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-argn.cnxa-jdss 451311 643974 2019-03-01 2018-09-30 14           14               14
1622 1622 KLICKITAT VALLEY HOSPITAL 310 SOUTH ROOSEVELT GOLDENDALE WA 98620 KLICKITAT (509) 773-4022 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.8202390 -120.8122990 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-hemh_kxtf-bs6t 501316 649846 2019-06-03 2018-12-31 14           14               14
1623 1623 SKYLINE HOSPITAL 211 SKYLINE DRIVE WHITE SALMON WA 98672 KLICKITAT (509) 491-1101 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.7224740 -121.4699210 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-ff7m.q2hb.cpdx 501315 652445 2019-06-27 2018-12-31 14           14               14
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
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
2254 2254 SANFORD JACKSON MEDICAL CENTER 1430 NORTH HIGHWAY JACKSON MN 56143 JACKSON (507) 847-2420 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6237230 -95.0045160 0   63 27 27063         https://data.medicare.gov/resource/xubh-q36u/row-xb4e.uhr4_fqc2 241315 649271 2019-05-28 2018-12-31 14           14               14
2490 2490 BAYSIDE COMMUNITY HOSPITAL 200 HOSPITAL DRIVE ANAHUAC TX 77514 CHAMBERS (409) 267-3143 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.7530120 -94.6868500 0   71 48 48071 26420 Houston-The Woodlands, TX Central Chambers County https://data.medicare.gov/resource/xubh-q36u/row-zszx-nqzy-xwd5 451320 643853 2019-02-28 2018-09-30 14           14               14
2707 2707 HARRISON COUNTY COMMUNITY HOSPITAL 2600 MILLER STREET BETHANY MO 64424 HARRISON (660) 425-0284 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.2652920 -94.0261450 0   81 29 29081         https://data.medicare.gov/resource/xubh-q36u/row-myhp~ktka_u8d3 261312 653250 2019-08-20 2019-03-31 14           14               14
3173 3173 UNITY MEDICAL CENTER 164 W 13TH STREET GRAFTON ND 58237 WALSH (701) 352-1620 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.4114840 -97.4138290 0   99 38 38099         https://data.medicare.gov/resource/xubh-q36u/row-xvyg.2uq7_fcwn 351320 660660 2019-12-03 2019-06-30 14           14               14
3174 3174 FIRST CARE HEALTH CENTER 115 VIVIAN ST PARK RIVER ND 58270 WALSH (701) 284-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3992620 -97.7436790 0   99 38 38099         https://data.medicare.gov/resource/xubh-q36u/row-yjef.zes7.d4mf 351326 647924 2019-05-16 2018-12-31 14           14               14
3191 3191 SUTTER SURGICAL HOSPITAL - NORTH VALLEY 455 PLUMAS BLVD YUBA CITY CA 95991 SUTTER (530) 749-5700 Acute Care Hospitals Physician FALSE 39.1321670 -121.6136030 0   101 6 6101 49700 Sacramento-Roseville, CA Central Sutter County https://data.medicare.gov/resource/xubh-q36u/row-rm5f.jnvd.d3k4 50766 651185 2019-06-03 2018-12-31 14           14               14
3225 3225 KENSINGTON HOSPITAL 136 W DIAMOND STREET PHILADELPHIA PA 19122 PHILADELPHIA (215) 426-8100 Acute Care Hospitals Voluntary non-profit - Other FALSE 39.9817591 -75.1347791 1 ROOFTOP 101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-jdjh_ypv5.y5gj 390025 660289 2019-12-02 2019-06-30 14           14               14
3406 3406 CULBERSON HOSPITAL EISENHOWER ROAD AND FM 2185 VAN HORN TX 79855 CULBERSON (432) 283-2760 Critical Access Hospitals Proprietary FALSE 31.0496690 -104.8283880 0   109 48 48109         https://data.medicare.gov/resource/xubh-q36u/row-g73p-emdj_vjx2 451338 653287 2019-08-29 2019-03-31 14           14               14
3567 3567 CLEVELAND AREA HOSPITAL 1401 WEST PAWNEE CLEVELAND OK 74020 PAWNEE (918) 358-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.3098820 -96.4811210 0   117 40 40117 46140 Tulsa-Muskogee-Bartlesville, OK Outlying Pawnee County https://data.medicare.gov/resource/xubh-q36u/row-mn7t-r33n-bhn9 371320 647932 2019-05-20 2018-12-31 14           14               14
3730 3730 ADVANCED SURGICAL HOSPITAL 100 TRICH DRIVE WASHINGTON PA 15301 WASHINGTON (724) 884-0710 Acute Care Hospitals Physician FALSE 40.1567230 -80.2805360 0   125 42 42125 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ni2v.da26_jxgn 390323 648978 2019-05-29 2018-12-31 14           14               14
3735 3735 ASCENSION EAGLE RIVER HOSPITAL 201 HOSPITAL ROAD EAGLE RIVER WI 54521 VILAS (715) 479-7411 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9275180 -89.2516780 0   125 55 55125         https://data.medicare.gov/resource/xubh-q36u/row-unpa.6ptj.b2ji 521300 661443 2019-11-27 2019-06-30 14           14               14
3915 3915 BAUM HARMON MERCY HOSPITAL 255 N WELCH AVENUE PRIMGHAR IA 51245 OBRIEN (712) 957-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0885970 -95.6227960 0   141 19 19141         https://data.medicare.gov/resource/xubh-q36u/row-jur3.m7q6_c9mz 161300 660546 2019-11-27 2019-06-30 14           14               14
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
4049 4049 FISHER COUNTY HOSPITAL DISTRICT 774 STATE HIGHWAY 70 N ROTAN TX 79546 FISHER (325) 735-2256 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.8343420 -100.4354190 0   151 48 48151         https://data.medicare.gov/resource/xubh-q36u/row-zpz3-mc6s_tqpq 451313 652799 2019-08-21 2018-12-31 14           14               14
4413 4413 ALTUS BAYTOWN HOSPITAL 1404 W BAKER ROAD BAYTOWN TX 77521 HARRIS (281) 837-7600 Acute Care Hospitals Physician TRUE 29.7698160 -94.9801930 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-fa96~fa82_gfbn 670109 650629 2019-06-04 2018-12-31 14           14               14
4474 4474 CORNERSTONE REGIONAL HOSPITAL 2302 CORNERSTONE BOULEVARD EDINBURG TX 78539 HIDALGO (956) 618-4444 Acute Care Hospitals Proprietary TRUE 26.2630960 -98.1991640 0   215 48 48215 32580 McAllen-Edinburg, TX Central Hidalgo County https://data.medicare.gov/resource/xubh-q36u/row-wtje.zqmn.bcn4 450825 649141 2019-05-28 2018-12-31 14           14               14
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
4605 4605 IRAAN GENERAL HOSPITAL 600 HIGHWAY 349 NORTH IRAAN TX 79744 PECOS (432) 639-2575 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.9141890 -101.9066730 0   371 48 48371         https://data.medicare.gov/resource/xubh-q36u/row-gutj.3p8m~9z3e 451307 651245 2019-06-28 2018-12-31 14           14               14
4621 4621 SCHLEICHER COUNTY MEDICAL CENTER 102 NORTH US HIGHWAY 277 ELDORADO TX 76936 SCHLEICHER (325) 853-2507 Critical Access Hospitals Proprietary TRUE 30.8698690 -100.5903930 0   413 48 48413         https://data.medicare.gov/resource/xubh-q36u/row-ukk5-7d2r~gvs8 451304 649143 2019-05-21 2018-12-31 14           14               14
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
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
11 11 CROSSRIDGE COMMUNITY HOSPITAL 310 SOUTH FALLS BOULEVARD WYNNE AR 72396 CROSS (870) 238-3300 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.2203530 -90.7874210 0   37 5 5037         https://data.medicare.gov/resource/xubh-q36u/row-9vam~w7bd~4ivg 41307 644210 2019-02-27 2018-09-30 15           15               15
356 356 ASSUMPTION COMMUNITY HOSPITAL 135 HIGHWAY 402 NAPOLEONVILLE LA 70390 ASSUMPTION (985) 369-3600 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.9575850 -91.0338750 0   7 22 22007         https://data.medicare.gov/resource/xubh-q36u/row-smss_wf6g.wmww 191303 659796 2019-11-27 2019-06-30 15           15               15
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
424 424 MOLOKAI GENERAL HOSPITAL 280 HOME OLU PLACE KAUNAKAKAI HI 96748 MAUI (808) 553-5331 Critical Access Hospitals Voluntary non-profit - Private TRUE 21.0937600 -157.0179820 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-vd6b-yn49_x98y 121303 659777 2019-11-26 2019-06-30 15           15               15
429 429 INDIANA UNIVERSITY HEALTH BLACKFORD HOSPITAL 410 PILGRIM BLVD HARTFORD CITY IN 47348 BLACKFORD (765) 348-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4689050 -85.3720270 0   9 18 18009         https://data.medicare.gov/resource/xubh-q36u/row-whn4~twas.y6i4 151302 648685 2019-05-28 2018-12-31 15           15               15
533 533 SURGICAL INSTITUTE OF READING 2752 CENTURY BOULEVARD WYOMISSING PA 19610 BERKS (717) 999-9999 Acute Care Hospitals Proprietary FALSE 40.3579510 -75.9875770 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-3aqm~vs6z.7ify 390316 651482 2019-06-25 2018-12-31 15           15               15
598 598 CALHOUN-LIBERTY HOSPITAL 20370 NE BURNS AVE BLOUNTSTOWN FL 32424 CALHOUN (850) 674-3493 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.4581280 -85.0495870 0   13 12 12013         https://data.medicare.gov/resource/xubh-q36u/row-sxhi~5k5k~4igt 101304 651800 2019-05-24 2018-12-31 15           15               15
673 673 EUREKA SPRINGS HOSPITAL, LLC 24 NORRIS STREET EUREKA SPRINGS AR 72632 CARROLL (479) 253-7400 Critical Access Hospitals Proprietary TRUE 36.4004330 -93.7446990 0   15 5 5015         https://data.medicare.gov/resource/xubh-q36u/row-fpuw-vbap-fsdb 41304 647643 2019-05-14 2018-12-31 15           15               15
740 740 SPECIALISTS HOSPITAL SHREVEPORT 1500 LINE AVENUE SHREVEPORT LA 71101 CADDO (318) 213-3800 Acute Care Hospitals Physician FALSE 32.4969260 -93.7460460 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi 190278 649901 2019-06-03 2018-12-31 15           15               15
883 883 GLENN MEDICAL CENTER 1133 W SYCAMORE ST WILLOWS CA 95988 GLENN (530) 934-1818 Critical Access Hospitals Government - Federal TRUE 39.5204670 -122.2081200 0   21 6 6021         https://data.medicare.gov/resource/xubh-q36u/row-7nst_26uq.zcvx 51306 662484 2019-12-03 2019-06-30 15           15               15
949 949 BLECKLEY MEMORIAL HOSPITAL 145 PEACOCK STREET COCHRAN GA 31014 BLECKLEY (478) 934-6211 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.3845450 -83.3459270 0   23 13 13023         https://data.medicare.gov/resource/xubh-q36u/row-wjpa_e9pd.p88y 111302 653882 2019-09-05 2019-03-31 15           15               15
1557 1557 DRUMRIGHT REGIONAL HOSPITAL 610 WEST BYPASS DRUMRIGHT OK 74030 CREEK (918) 382-2300 Critical Access Hospitals Proprietary TRUE 35.9981930 -96.6059788 1 ROOFTOP 37 40 40037 46140 Tulsa-Muskogee-Bartlesville, OK Central Creek County https://data.medicare.gov/resource/xubh-q36u/row-7yzz_kwx7_bt4n 371331 641664 2019-01-08 2018-09-30 15           15               15
1587 1587 WARNER HOSPITAL AND HEALTH SERVICES 422 W WHITE ST CLINTON IL 61727 DE WITT (217) 935-9571 Critical Access Hospitals Government - Local TRUE 40.1489530 -88.9646160 0   39 17 17039 14010 Bloomington-Pontiac, IL Outlying De Witt County https://data.medicare.gov/resource/xubh-q36u/row-gzhh-tmyy.cr8h 141303 654575 2019-09-26 2019-04-30 15           15               15
1645 1645 HERINGTON MUNICIPAL HOSPITAL 100 E HELEN STREET HERINGTON KS 67449 DICKINSON (785) 258-2207 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.6795610 -96.9422740 0   41 20 20041         https://data.medicare.gov/resource/xubh-q36u/row-sgwx~evd5.tciy 171340 661326 2019-12-03 2019-06-30 15           15               15
1695 1695 MERCY ONE ELKADER MEDICAL CENTER 901 DAVIDSON STREET NW ELKADER IA 52043 CLAYTON (563) 245-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.8597710 -91.4145360 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-tpbr_taqd~69cu 161319 661725 2019-12-04 2019-06-30 15           15               15
1832 1832 SYRINGA GENERAL HOSPITAL 607 W MAIN STREET GRANGEVILLE ID 83530 IDAHO (208) 983-1700 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.9267890 -116.1269940 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-9the-4kgt.urhi 131315 642946 2019-02-08 2018-09-30 15           15               15
1844 1844 MAYO CLINIC HEALTH SYSTEM-CANNON FALLS 32021 COUNTY 24 BOULEVARD CANNON FALLS MN 55009 GOODHUE (507) 263-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4859000 -92.9032500 0   49 27 27049 39860 Minneapolis-St. Paul, MN-WI Central Goodhue County https://data.medicare.gov/resource/xubh-q36u/row-wnpm.4cz9.5bg4 241346 649783 2019-05-30 2018-12-31 15           15               15
1934 1934 BURLESON ST JOSEPH HEALTH CENTER 1101 WOODSON DRIVE CALDWELL TX 77836 BURLESON (979) 567-3245 Critical Access Hospitals Voluntary non-profit - Church FALSE 30.5203070 -96.7177140 0   51 48 48051 17780   Outlying Burleson County https://data.medicare.gov/resource/xubh-q36u/row-gq4y-tvhz_2h55 451305 660890 2019-11-29 2019-06-30 15           15               15
1971 1971 SALEM HEALTH WEST VALLEY 525 SE WASHINGTON STREET DALLAS OR 97338 POLK (503) 623-8301 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9194040 -123.3103830 0   53 41 41053 41420 Portland-Vancouver-Salem, OR-WA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-urpw.pi4k_vkp4 381308 660286 2019-12-02 2019-06-30 15           15               15
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
2163 2163 ST LUKE'S MCCALL 1000 STATE STREET BURGDORF ID 83638 VALLEY (208) 630-2395 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9093540 -116.1097030 0   85 16 16085         https://data.medicare.gov/resource/xubh-q36u/row-au7a~xb54-snfz 131312 651560 2019-06-21 2018-09-30 15           15               15
2298 2298 CLINCH MEMORIAL HOSPITAL 1050 VALDOSTA HIGHWAY HOMERVILLE GA 31634 CLINCH (912) 487-5211 Critical Access Hospitals Government - Local TRUE 31.0326510 -82.7638580 0   65 13 13065         https://data.medicare.gov/resource/xubh-q36u/row-6x28-ujdc_jsi5 111308 659942 2019-11-27 2019-06-30 15           15               15
2420 2420 ASCENSION SACRED HEART HOSPITAL 401 W MOHAWK DR SUITE 100 TOMAHAWK WI 54487 LINCOLN (715) 453-7700 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.4890060 -89.7335960 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-zubv-e9fv-qs3r 521313 661446 2019-11-27 2019-06-30 15           15               15
2699 2699 ST ELIZABETH GRANT 238 BARNES ROAD WILLIAMSTOWN KY 41097 GRANT (859) 824-8105 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.6478620 -84.5782640 0   81 21 21081 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Outlying Grant County https://data.medicare.gov/resource/xubh-q36u/row-z5ru.drf8.yem5 181311 648696 2019-05-24 2018-12-31 15           15               15
2871 2871 COLLINGSWORTH GENERAL HOSPITAL 1013 15TH ST WELLINGTON TX 79095 COLLINGSWORTH (806) 447-2521 Critical Access Hospitals Proprietary TRUE 34.8491100 -100.2120150 0   87 48 48087         https://data.medicare.gov/resource/xubh-q36u/row-iy62.m34i.p94f 451355 643660 2019-02-27 2018-09-30 15           15               15
3001 3001 IRON COUNTY MEDICAL CENTER 301 NORTH HIGHWAY 21 PILOT KNOB MO 63663 IRON (573) 546-1260 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6087570 -90.6291900 0   93 29 29093         https://data.medicare.gov/resource/xubh-q36u/row-gcg8.69nm~t5ha 261336 660408 2019-11-27 2019-06-30 15           15               15
3027 3027 MELISSA MEMORIAL HOSPITAL 1001 E JOHNSON ST HOLYOKE CO 80734 PHILLIPS (970) 854-2241 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.5784280 -102.2902490 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-6wcd-peh6-fsnb 61305 650244 2019-05-31 2018-12-31 15           15               15
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
3215 3215 ST JAMES MERCY HOSPITAL 411 CANISTEO STREET HORNELL NY 14843 STEUBEN (607) 324-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.3145750 -77.6601420 0   101 36 36101 18500 Elmira-Corning, NY Central Steuben County https://data.medicare.gov/resource/xubh-q36u/row-584q-nx3f-g76t 330151 650302 2019-05-31 2018-12-31 15           15               15
3320 3320 KIMBALL HEALTH SERVICES 505 SOUTH BURG ST KIMBALL NE 69145 KIMBALL (308) 235-1951 Critical Access Hospitals Government - Local TRUE 41.2324380 -103.6672040 0   105 31 31105         https://data.medicare.gov/resource/xubh-q36u/row-3qnf.krtg-ks6w 281305 662400 2019-12-06 2019-06-30 15           15               15
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
3413 3413 TANNER MEDICAL CENTER-EAST ALABAMA 1032 MAIN STREET SOUTH WEDOWEE AL 36278 RANDOLPH (256) 357-2111 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.2966660 -85.4800280 0   111 1 1111         https://data.medicare.gov/resource/xubh-q36u/row-beeg-xgp7.fjvj 11306 659914 2019-11-27 2019-06-30 15           15               15
3433 3433 REEVES MEMORIAL MEDICAL CENTER 409 FIRST STREET BERNICE LA 71222 UNION (318) 285-9066 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.8243620 -92.6567230 0   111 22 22111 33740 Monroe-Ruston-Bastrop, LA Outlying Union Parish https://data.medicare.gov/resource/xubh-q36u/row-4wmt-5uar.t8se 191326 654928 2019-09-23 2018-12-31 15           15               15
3444 3444 ELLENVILLE REGIONAL HOSPITAL 10 HEALTHY WAY ELLENVILLE NY 12428 ULSTER (845) 647-6400 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.7323510 -74.3806240 0   111 36 36111 28740 New York-Newark, NY-NJ-CT-PA Central Ulster County https://data.medicare.gov/resource/xubh-q36u/row-yusu_wb8x.4xxv 331310 655468 2019-10-07 2018-12-31 15           15               15
3486 3486 FAIRFAX COMMUNITY HOSPITAL 40 HOSPITAL ROAD FAIRFAX OK 74637 OSAGE (918) 642-3291 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.5636190 -96.7052620 0   113 40 40113 46140 Tulsa-Muskogee-Bartlesville, OK Central Osage County https://data.medicare.gov/resource/xubh-q36u/row-4i8h_qx3c-d2aw 371318 648066 2019-05-20 2018-09-30 15           15               15
3503 3503 PINE CREEK MEDICAL CENTER LLP 9032 HARRY HINES BLVD DALLAS TX 75235 DALLAS (214) 231-2273 Acute Care Hospitals Proprietary TRUE 32.8401610 -96.8688350 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yjax~idz9_awg3 450894 648768 2019-05-24 2018-12-31 15           15               15
3529 3529 HILLSBORO COMMUNITY HOSPITAL 101 INDUSTRIAL ROAD HILLSBORO KS 67063 MARION (620) 947-3114 Critical Access Hospitals Proprietary FALSE 38.3614950 -97.1875890 0   115 20 20115         https://data.medicare.gov/resource/xubh-q36u/row-ik5a_fj2t_xvzd 171357 645552 2019-03-04 2018-09-30 15           15               15
3585 3585 UCHEALTH PIKES PEAK REGIONAL HOSPITAL 16420 WEST HIGHWAY 24 WOODLAND PARK CO 80863 TELLER (719) 687-9999 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9739320 -105.0742670 0   119 8 8119 17820   Outlying Teller County https://data.medicare.gov/resource/xubh-q36u/row-rxec_h64n-ugar 61326 660069 2019-11-27 2019-06-30 15           15               15
3702 3702 YUMA DISTRICT HOSPITAL 1000 W 8TH AVE YUMA CO 80759 YUMA (970) 848-5405 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1184450 -102.7366540 0   125 8 8125         https://data.medicare.gov/resource/xubh-q36u/row-b6fk_8yss~83cp 61315 649173 2019-05-28 2018-12-31 15           15               15
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
3897 3897 CHI HEALTH PLAINVIEW P O BOX 489, 704 NORTH THIRD ST PLAINVIEW NE 68769 PIERCE (402) 582-4245 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.3587128 -97.7857721 1 ROOFTOP 139 31 31139 35740   Outlying Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dyfy-rvq7~3hjd 281346 661043 2019-12-02 2019-06-30 15           15               15
3943 3943 HIGGINS GENERAL HOSPITAL 200 ALLEN MEMORIAL DRIVE BREMEN GA 30110 HARALSON (770) 812-2000 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7163430 -85.1446230 0   143 13 13143 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Haralson County https://data.medicare.gov/resource/xubh-q36u/row-rd44_uqxz.t5yc 111320 660206 2019-12-02 2019-06-30 15           15               15

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