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 RPT_REC_NUM 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, subprovider_oth_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
159 159 Tripler AMC (FT Shafter) 1 Jarrett White Rd Honolulu HI 96859 HONOLULU (808) 433-2778 Acute Care - Department of Defense Department of Defense TRUE 21.3588670 -157.8887690 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-xb5h~t6w7_qec8                                      
190 190 99th Medical Group (Nellis AFB) 99 MDG 4700 Las Vegas Blvd Nellis AFB NV 89191 CLARK (702) 653-2273 Acute Care - Department of Defense Department of Defense TRUE 36.2457836 -115.0497641 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-dmy4.2nr3_wdjy                                      
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                                      
499 499 GROVE CREEK MEDICAL CENTER 350 NORTH MERIDIAN STREET BLACKFOOT ID 83221 BINGHAM (208) 782-2900 Acute Care Hospitals Voluntary non-profit - Private FALSE 43.1963010 -112.3561240 0   11 16 16011 13940 Idaho Falls-Rexburg-Blackfoot, ID Central Bingham County https://data.medicare.gov/resource/xubh-q36u/row-ej2j_mw5y_vys8                                      
537 537 LAYTON HOSPITAL 201 WEST LAYTON PARKWAY LAYTON UT 84041 DAVIS (801) 543-6703 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0544470 -111.9676100 0   11 49 49011 36260 Salt Lake City-Provo-Orem, UT Central Davis County https://data.medicare.gov/resource/xubh-q36u/row-vhte.3djc_gfvr                                      
562 562 DIGNITY HEALTH ARIZONA GENERAL HOSPITAL 9130 EAST ELLIOT ROAD MESA AZ 85212 MARICOPA (480) 410-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.3504785 -111.6361588 1 ROOFTOP 13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-viy6-jrjj-hix3                                      
578 578 WESTERN REGIONAL MEDICAL CENTER 14200 WEST CELEBRATE LIFE WAY GOODYEAR AZ 85338 MARICOPA (623) 207-3518 Acute Care Hospitals Proprietary FALSE 33.4528040 -112.3625710 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-rhgj.utwd-n4qy                                      
647 647 NH Beaufort 1 Pinckney Blvd Beaufort SC 29902 BEAUFORT (843) 228-5600 Acute Care - Department of Defense Department of Defense FALSE 32.3889769 -80.6825821 1 ROOFTOP 13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-uc4x_u34w~fpt9                                      
875 875 673rd Medical Group (Joint Base Elmendorf-Richardson) 673 MDG 5955 Zeamer Ave JBER AK 99506 ANCHORAGE (907) 384-1110 Acute Care - Department of Defense Department of Defense TRUE 61.2348208 -149.7449348 1 ROOFTOP 20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-pmg3~gpys_qbnx                                      
1037 1037 PALMERTON HOSPITAL 135 LAFAYETTE AVENUE PALMERTON PA 18071 CARBON (610) 826-3141 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.8023150 -75.6148510 0   25 42 42025 10900 New York-Newark, NY-NJ-CT-PA Central Carbon County https://data.medicare.gov/resource/xubh-q36u/row-b6sa~yemt.rcmf                                      
1108 1108 Darnall AMC (FT Hood) 36000 Darnall Loop Fort Hood TX 76544 BELL (254) 288-8000 Acute Care - Department of Defense Department of Defense TRUE 31.1303370 -97.7751320 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-gncy-h9nz~ydxn                                      
1181 1181 TEXAS CENTER FOR INFECTIOUS DISEASE 2303 SE MILITARY DR P O BOX 23340 SAN ANTONIO TX 78223 BEXAR (210) 534-8857 Acute Care Hospitals Government - State FALSE 29.3519300 -98.4583770 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-suha~2mc2-p7yc                                      
1185 1185 Brooke Army Medical Center (FT Sam Houston) 3551 Roger Brooke Drive Fort Sam Houston TX 78234 BEXAR (210) 916-4141 Acute Care - Department of Defense Department of Defense TRUE 29.4604460 -98.4177790 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-9nff_a7kc-xmqq                                      
1191 1191 NH Oak Harbor 3475 North Saratoga Street Oak Harbor WA 98277 ISLAND (360) 257-9500 Acute Care - Department of Defense Department of Defense FALSE 48.3368750 -122.6801420 0   29 53 53029 36020 Seattle-Tacoma, WA Central Island County https://data.medicare.gov/resource/xubh-q36u/row-9p9c~5ra9_8krv                                      
1211 1211 NH Jacksonville 2080 Child Street Jacksonville FL 32212 DUVAL (904) 542-7300 Acute Care - Department of Defense Department of Defense TRUE 30.2094450 -81.6839140 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-s7ka-egpz~sehf                                      
1271 1271 Walter Reed National Military Med Cen 8901 Rockville Pike Bethesda MD 20889 MONTGOMERY (301) 295-4000 Acute Care - Department of Defense Department of Defense TRUE 38.9994900 -77.0968010 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-9f6g_giqd.6t34                                      
1378 1378 BAPTIST MEMORIAL HOSPITAL-CRITTENDEN, INC 2100 NORTH SEVENTH STREET WEST MEMPHIS AR 72301 CRITTENDEN (870) 394-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.1679922 -90.1778757 1 ROOFTOP 35 5 5035 32820 Memphis-Forrest City, TN-MS-AR Central Crittenden County https://data.medicare.gov/resource/xubh-q36u/row-v5ug.qa38-7wwe                                      
1444 1444 NH Bremerton 1 Boone Road Bremerton Bremerton WA 98312 KITSAP (360) 475-4232 Acute Care - Department of Defense Department of Defense FALSE 47.5935710 -122.6929400 0   35 53 53035 14740 Seattle-Tacoma, WA Central Kitsap County https://data.medicare.gov/resource/xubh-q36u/row-u4p2.49ji-8aqj                                      
1449 1449 MARSHFIELD MEDICAL CENTER - EAU CLAIRE 2310 CRAIG RD EAU CLAIRE WI 54701 EAU CLAIRE (833) 883-3262 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.7933180 -91.5190830 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-3peb-cz4e.82m5                                      
1640 1640 Evans ACH (FT Carson) Fort Carson MEDDAC 1650 Cochrane Circle Fort Carson Fort Carson CO 80913 EL PASO (719) 526-7000 Acute Care - Department of Defense Department of Defense TRUE 38.7164981 -104.7934123 1 GEOMETRIC_CENTER 41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-g44u.mbxs_jpjt                                      
1787 1787 81st Medical Group (Keesler AFB) 81 MDG 301 Fisher St. Suite 109 Biloxi MS 39530 HARRISON (228) 377-6393 Acute Care - Department of Defense Department of Defense TRUE 30.4123007 -88.9109802 1 ROOFTOP 47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-a8uk.gq75_wykp                                      
1916 1916 Womack AMC (FT Bragg) 2817 Reilly Road Fort Bragg NC 28307 CUMBERLAND (910) 907-9262 Acute Care - Department of Defense Department of Defense TRUE 35.1473370 -78.9973980 0   51 37 37051 22180 Fayetteville-Lumberton-Laurinburg, NC Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-jzah.iadr~a6gb                                      
1946 1946 Martin ACH (FT Benning) 7950 Martin Loop Fort Benning GA 31905 CHATTAHOOCHEE (762) 408-2604 Acute Care - Department of Defense Department of Defense TRUE 32.3745860 -84.9287900 0   53 13 13053 17980 Columbus-Auburn-Opelika, GA-AL Central Chattahoochee County https://data.medicare.gov/resource/xubh-q36u/row-uvgm~wwn2~h7sr                                      
1980 1980 Madigan AMC (FT Lewis) 9040 Jackson Avenue Tacoma WA 98431 PIERCE (253) 968-1110 Acute Care - Department of Defense Department of Defense TRUE 47.1079300 -122.5485280 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-auzt.nx8p-7ivx                                      
2082 2082 88th Medical Group (Wright-Patterson AFB) 88 MDG 4881 Sugar Maple Dr. Wright-Patterson AFB OH 45433 GREENE (937) 257-9926 Acute Care - Department of Defense Department of Defense TRUE 39.8052276 -84.0370421 1 ROOFTOP 57 39 39057 19380 Dayton-Springfield-Sidney, OH Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-a32h-jkdv-qubw                                      
2118 2118 HEALTHBRIDGE CHILDREN'S HOSPITAL - ORANGE 393 S TUSTIN STREET ORANGE CA 92866 ORANGE (714) 289-2400 Childrens Proprietary FALSE 33.7827720 -117.8357450 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-6j3t.dm9a.bqh8                                      
2169 2169 Fort Belvoir Community Hospital 9300 DeWitt Loop Fort Belvoir VA 22060 FAIRFAX (571) 231-3224 Acute Care - Department of Defense Department of Defense TRUE 38.7058770 -77.1426080 0   59 51 51059 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Fairfax County https://data.medicare.gov/resource/xubh-q36u/row-f5nt-2kfs_crpt                                      
2188 2188 Irwin ACH (FT Riley) 600 Caisson Hill Road Fort Riley KS 66442 GEARY (785) 239-7000 Acute Care - Department of Defense Department of Defense TRUE 39.0782800 -96.7764420 0   61 20 20061 27920 Manhattan-Junction City, KS Central Geary County https://data.medicare.gov/resource/xubh-q36u/row-ntcu~z853~qjr9                                      
2435 2435 NMC San Diego 34800 Bob Wilson Drive San Diego CA 92134 SAN DIEGO (619) 532-6400 Acute Care - Department of Defense Department of Defense TRUE 32.7267230 -117.1430350 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-jjfu_7vcu~58t6                                      
2444 2444 NH Twenty Nine Palms 1145 Sturgis Road Twentynine Palms CA 92278 SAN BERNARDINO (760) 830-2190 Acute Care - Department of Defense Department of Defense TRUE 34.2249980 -116.0485110 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-kx79_zryq~w8f6                                      
2447 2447 Weed ACH (FT Irwin) 166 4th Street Fort Irwin CA 92310 SAN BERNARDINO (866) 957-9224 Acute Care - Department of Defense Department of Defense TRUE 35.2653150 -116.6872950 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-s87n-qicq_idrk                                      
2476 2476 Keller ACH (West Point) 900 Washington Rd West Point NY 10996 ORANGE (845) 938-4034 Acute Care - Department of Defense Department of Defense TRUE 41.4007200 -73.9767670 0   71 36 36071 35620 New York-Newark, NY-NJ-CT-PA Outlying Orange County https://data.medicare.gov/resource/xubh-q36u/row-96r4-63ca~eik6                                      
2511 2511 NH Camp Pendleton 200 Mercy Circle Camp Pendleton Camp Pendleton CA 92055 SAN DIEGO (760) 725-1288 Acute Care - Department of Defense Department of Defense TRUE 33.2213730 -117.3899260 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-xy5j_skjm.tqkx                                      
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                                      
2933 2933 Bassett ACH (FT Wainwright) 4076 Neely Road Fort Wainwright AK 99703 FAIRBANKS NORTH STAR (907) 361-4000 Acute Care - Department of Defense Department of Defense TRUE 64.8277880 -147.6647670 0   90 2 2090 21820   Central Fairbanks North Star Borough https://data.medicare.gov/resource/xubh-q36u/row-rx2u.ys9t~8f9q                                      
2937 2937 96th Medical Group (Eglin AFB) 96 MDG 307 Boatner Rd Suite 114 Eglin AFB FL 32542 OKALOOSA (850) 883-8600 Acute Care - Department of Defense Department of Defense TRUE 30.4505460 -86.5433477 1 ROOFTOP 91 12 12091 18880   Central Okaloosa County https://data.medicare.gov/resource/xubh-q36u/row-4zpw_rzxt_qkvv                                      
2955 2955 PINNACLE REGIONAL HOSPITAL, INC 12850 METCALF AVENUE OVERLAND PARK KS 66213 JOHNSON (913) 220-2866 Acute Care Hospitals Proprietary FALSE 38.8963010 -94.6678760 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-rddh~ajbk-yi9q                                      
3025 3025 60th Medical Group (Travis AFB) 103 Bodin Circle Fairfield Fairfield CA 94533 SOLANO (707) 423-7300 Acute Care - Department of Defense Department of Defense TRUE 38.2679340 -121.9606640 0   95 6 6095 46700 San Jose-San Francisco-Oakland, CA Central Solano County https://data.medicare.gov/resource/xubh-q36u/row-wsxb-mk9r~mdjd                                      
3395 3395 INTEGRIS COMMUNITY HOSPITAL - COUNCIL CROSSING 9417 N COUNCIL ROAD OKLAHOMA CITY OK 73162 OKLAHOMA (405) 550-3280 Acute Care Hospitals Proprietary TRUE 35.5653520 -97.6562570 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-g5rq~p6tq-qier                                      
3532 3532 Bayne-Jones ACH (Ft Polk) 1585 3rd Street Fort Polk Fort Polk LA 71459 VERNON (337) 531-3118 Acute Care - Department of Defense Department of Defense TRUE 31.0632320 -93.2161950 0   115 22 22115 22860 DeRidder-Fort Polk South, LA Central Vernon Parish https://data.medicare.gov/resource/xubh-q36u/row-g488.fsbq_k4yk                                      
3599 3599 QUITMAN COUNTY HOSPITAL CAH 340 GETWELL DRIVE MARKS MS 38646 QUITMAN (662) 326-8031 Critical Access Hospitals Proprietary TRUE 34.2474640 -90.2770590 0   119 28 28119         https://data.medicare.gov/resource/xubh-q36u/row-94fq~mrkf~464e                                      
3733 3733 Blanchfield ACH (FT Campbell) 650 Joel Drive Fort Campbell KY 42223 CHRISTIAN (270) 798-8400 Acute Care - Department of Defense Department of Defense TRUE 36.6373360 -87.4487870 0   125 47 47125 17300   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-44hb~fqi9-9v8q                                      
3761 3761 CUMBERLAND HOSPITAL LLC 9407 CUMBERLAND ROAD NEW KENT VA 23124 NEW KENT (804) 966-2242 Childrens Proprietary FALSE 37.5455310 -76.9792200 0   127 51 51127 40060   Outlying New Kent County https://data.medicare.gov/resource/xubh-q36u/row-2t5p~njzu.inug                                      
3835 3835 NMC Camp Lejeune 100 Brewster Boulevard Camp Lejeune NC 28547 ONSLOW (910) 450-4300 Acute Care - Department of Defense Department of Defense TRUE 34.7167710 -77.3570760 0   133 37 37133 27340   Central Onslow County https://data.medicare.gov/resource/xubh-q36u/row-tu4z~ui2b-p93g                                      
3927 3927 William Beaumont AMG (FT Bliss) 5005 N. Piedras St. El Paso TX 79920 EL PASO (915) 742-2121 Acute Care - Department of Defense Department of Defense TRUE 31.8222270 -106.4614620 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-7ye3-bwem.cixj                                      
4214 4214 SHRINERS HOSPITALS FOR CHILDREN 815 MARKET STREET GALVESTON TX 77550 GALVESTON (409) 770-6600 Childrens Voluntary non-profit - Private FALSE 29.3097470 -94.7771870 0   167 48 48167 26420 Houston-The Woodlands, TX Central Galveston County https://data.medicare.gov/resource/xubh-q36u/row-ftsq~mmvm_77ft                                      
4224 4224 General Leonard Wood ACH (FT Leonard Wood) 126 Missouri Avenue Fort Leonard Wood MO 65473 PULASKI (573) 596-0035 Acute Care - Department of Defense Department of Defense TRUE 37.7664710 -92.1164910 0   169 29 29169 22780   Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-x88s-pvzx~g2id                                      
4282 4282 Winn ACH (FT Stewart) 1061 Harmon Avenue Fort Stewart GA 31314 LIBERTY (912) 435-6633 Acute Care - Department of Defense Department of Defense TRUE 31.8712070 -81.5986720 0   179 13 13179 25980 Savannah-Hinesville-Statesboro, GA Central Liberty County https://data.medicare.gov/resource/xubh-q36u/row-4g37~3e4d.ctk3                                      
4374 4374 HAMILTON GENERAL HOSPITAL 400 N BROWN, BUILDING 1 HAMILTON TX 76531 HAMILTON (254) 386-3151 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.7038520 -98.1134620 0   193 48 48193         https://data.medicare.gov/resource/xubh-q36u/row-u9ir-x2hd-6nbs                                      
4439 4439 HUMBLE SURGICAL HOSPITAL, LLC 1475 FM 1960 BYPASS ROAD EAST HUMBLE TX 77338 HARRIS (281) 964-2100 Acute Care Hospitals Physician TRUE 30.0041830 -95.2529240 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-u2zv_k8rw_6una                                      
4493 4493 CROCKETT MEDICAL CENTER 1100 E LOOP 304 CROCKETT TX 75835 HOUSTON (936) 546-3890 Critical Access Hospitals Proprietary TRUE 31.3236990 -95.4372570 0   225 48 48225         https://data.medicare.gov/resource/xubh-q36u/row-2gki~micg.zrhe                                      
4513 4513 Dwight Eisenhower AMC (FT Gordon) 300 East Hospital Road Fort Gordon GA 30905 RICHMOND (706) 787-5811 Acute Care - Department of Defense Department of Defense TRUE 33.4294030 -82.1260640 0   245 13 13245 12260   Central Richmond County https://data.medicare.gov/resource/xubh-q36u/row-y9pc-3kft_44qr                                      
4586 4586 EMIL J FREIREICH CANCER CENTER 9201 PINECROFT SHENANDOAH TX 77380 MONTGOMERY (855) 353-2201 Acute Care Hospitals Proprietary TRUE 30.1748330 -95.4562990 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-dgs8~kmnk_pu43                                      
4673 4673 BAYLOR SCOTT & WHITE MEDICAL CENTER PFLUGERVILLE 2600 EAST PFLUGERVILLE PARKWAY PFLUGERVILLE TX 78660 TRAVIS (512) 654-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4467390 -97.5844660 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-6zai.ayhx-f9rk                                      
4683 4683 TEXAS GENERAL HOSPITAL- VZRMC LP 707 N WALDRIP ST GRAND SALINE TX 75140 VAN ZANDT (903) 962-5200 Acute Care Hospitals Proprietary TRUE 32.6791930 -95.7217370 0   467 48 48467         https://data.medicare.gov/resource/xubh-q36u/row-6c8j-ja3g-2qcb                                      
4741 4741 1st Medical Group (Langley AFB) 633 MDG 77 Nealy Ave Langley VA 23665 HAMPTON CITY (757) 225-7630 Acute Care - Department of Defense Department of Defense TRUE 37.0738311 -76.3580187 1 ROOFTOP 650 51 51650 47260 Virginia Beach-Norfolk, VA-NC Central Hampton city https://data.medicare.gov/resource/xubh-q36u/row-7sn4-kumh~7wv5                                      
4754 4754 NMC Portsmouth 620 John Paul Jones Circle Portsmouth VA 23708 PORTSMOUTH CITY (757) 953-5008 Acute Care - Department of Defense Department of Defense TRUE 36.8431780 -76.3049740 0   740 51 51740 47260 Virginia Beach-Norfolk, VA-NC Central Portsmouth city https://data.medicare.gov/resource/xubh-q36u/row-esra.nfmh.29au                                      
4700 4700 BAYLOR SCOTT & WHITE EMERGENCY MEDICAL CENTER AT C 900 EAST WHITESTONE BLVD CEDAR PARK TX 78613 WILLIAMSON (512) 684-4911 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.5239510 -97.8201770 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-7m75.eizi~hrs5 670087 662636 2019-12-19 2019-06-30 8           8               8
1194 1194 POWELL VALLEY HOSPITAL 777 AVENUE H POWELL WY 82435 PARK (307) 754-2267 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7566220 -108.7705470 0   29 56 56029         https://data.medicare.gov/resource/xubh-q36u/row-gs73_h7cj.ibeh 531310 662634 2019-11-27 2019-06-30 25           25       100       125
252 252 NORTH BIG HORN HOSPITAL DISTRICT 1115 LANE 12 LOVELL WY 82431 BIG HORN (307) 548-5200 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.8257990 -108.3906880 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-s9vd~bscy-xn2k 531309 662633 2019-11-27 2019-06-30 12           12       85       97
1630 1630 ST JOHNS MEDICAL CENTER 625 EAST BROADWAY JACKSON WY 83001 TETON (307) 733-3636 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.4796950 -110.7499860 0   39 56 56039 27220   Central Teton County https://data.medicare.gov/resource/xubh-q36u/row-vuqt_cw9d-cjux 530015 662632 2019-12-04 2019-06-30 42 6         48       60       108
1054 1054 WYOMING MEDICAL CENTER 1233 EAST 2ND ST CASPER WY 82601 NATRONA (307) 577-7201 Acute Care Hospitals Government - Local TRUE 42.8487180 -106.3087530 0   25 56 56025 16220   Central Natrona County https://data.medicare.gov/resource/xubh-q36u/row-sk2z.s7zk-vge8 530012 662631 2019-11-27 2019-06-30 198 14         212               212
3186 3186 FLAMBEAU HOSPITAL 98 SHERRY AVE PARK FALLS WI 54552 PRICE (715) 762-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9310980 -90.4419720 0   99 55 55099         https://data.medicare.gov/resource/xubh-q36u/row-mtm9~rxnu.g2qc 521325 662628 2019-12-02 2019-06-30 20 4         24           1   25
3624 3624 ASPIRUS MEDFORD HOSPITAL & CLINICS, INC 135 S GIBSON ST MEDFORD WI 54451 TAYLOR (715) 748-8100 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.1358340 -90.3540120 0   119 55 55119         https://data.medicare.gov/resource/xubh-q36u/row-8cup-n67n_55ac 521324 662627 2019-12-23 2019-06-30 25           25       78   10   113
3329 3329 MERCY HEALTH SYSTEM CORP 1000 MINERAL POINT AVE JANESVILLE WI 53548 ROCK (608) 756-6080 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6867440 -89.0327250 0   105 55 55105 27500 Madison-Janesville-Beloit, WI Central Rock County https://data.medicare.gov/resource/xubh-q36u/row-emwb_jdut_5tu2 520066 662626 2019-12-06 2019-06-30 181 15         196   14   27       237
1369 1369 ST FRANCIS COMMUNITY HOSPITAL 34515 9TH AVENUE SOUTH FEDERAL WAY WA 98003 KING (253) 944-8100 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.2921060 -122.3229510 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-26c7~6xv9.c5tp 500141 662625 2019-11-27 2019-06-30 110 14         124               124
1981 1981 ST JOSEPH MEDICAL CENTER 1717 SOUTH J STREET TACOMA WA 98405 PIERCE (253) 627-4101 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.2454690 -122.4487570 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-pud3~63vu~69st 500108 662624 2019-11-27 2019-06-30 292 82         374               374
542 542 PEACEHEALTH SOUTHWEST MEDICAL CENTER 400 NE MOTHER JOSEPH PLACE VANCOUVER WA 98668 CLARK (360) 256-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6234860 -122.5806360 0   11 53 53011 38900 Portland-Vancouver-Salem, OR-WA Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-dpuj-5ndk.kv2i 500050 662623 2019-12-02 2019-06-30 356 80         436   14           450
1985 1985 ST CLARE HOSPITAL 11315 BRIDGEPORT WAY S W LAKEWOOD WA 98499 PIERCE (253) 588-1711 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.1542130 -122.5044950 0   53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dwu9_j2ug-7e7a 500021 662622 2019-11-27 2019-06-30 75 31         106               106
1436 1436 UNIVERSITY OF UTAH HOSPITALS AND CLINICS 50 NORTH MEDICAL DRIVE SALT LAKE CITY UT 84132 SALT LAKE (801) 581-2121 Acute Care Hospitals Government - State TRUE 40.7720190 -111.8370220 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-w86s~b4kw~syc4 460009 662619 2019-11-26 2019-06-30 343 38 42 15 12 25 523 24 38           585
4597 4597 CORPUS CHRISTI MEDICAL CENTER,THE 6629 WOODRIDGE ROAD CORPUS CHRISTI TX 78414 NUECES (361) 761-1501 Acute Care Hospitals Proprietary FALSE 27.6816440 -97.3592840 0   355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-ucbp~a56a_ytw8 450788 662615 2019-08-08 2018-08-31 335 33       16 384 17 15           416
4626 4626 UNIVERSITY OF TEXAS HEALTH SCIENCE CENTER AT TYLER 11937 US HIGHWAY 271 TYLER TX 75708 SMITH (903) 877-7777 Acute Care Hospitals Government - State TRUE 32.4236900 -95.2092910 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-t9fk_pkzk_23zc 450690 662612 2019-02-01 2018-08-31 90 14         104 26             130
2824 2824 MEDICAL CITY MCKINNEY 4500 MEDICAL CENTER DRIVE MCKINNEY TX 75069 COLLIN (972) 547-8000 Acute Care Hospitals Proprietary TRUE 33.1598420 -96.6355030 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-6zuh~kh9r.qkdr 450403 662606 2019-10-16 2018-08-31 133 16       7 156 63 15           234
715 715 BELLVILLE ST JOSEPH HEALTH CENTER 44 N CUMMINGS ST BELLVILLE TX 77418 AUSTIN (979) 865-3141 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9522650 -96.2607470 0   15 48 48015 26420 Houston-The Woodlands, TX Outlying Austin County https://data.medicare.gov/resource/xubh-q36u/row-dtpr-rvr9.rhky 450253 662602 2019-11-26 2019-06-30 32           32               32
3501 3501 UT SOUTHWESTERN UNIVERSITY HOSPITAL 6201 HARRY HINES BLVD DALLAS TX 75390 DALLAS (214) 633-5555 Acute Care Hospitals Government - State TRUE 32.8193657 -96.8488409 1 ROOFTOP 113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-8x4y~icku-nwfq 450044 662594 2019-08-22 2018-08-31 357 72         459               459
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
16 16 AVERA WESKOTA MEMORIAL MEDICAL CENTER - CAH 604 1ST ST NE WESSINGTON SPRINGS SD 57382 JERAULD (605) 539-1201 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0803940 -98.5636820 0   73 46 46073         https://data.medicare.gov/resource/xubh-q36u/row-pcwb-j3y8~f5au 431324 662583 2019-11-27 2019-06-30 16           16               16
2237 2237 PROFESSIONAL HOSPITAL GUAYNABO INC AVE LAS CUMBRES ST 199KM 1 2 ALT DE SANTA PR 969 GUAYNABO (787) 708-6560 Acute Care Hospitals Proprietary TRUE 18.3582970 -66.0726073 1 GEOMETRIC_CENTER 61 72 72061 41980 San Juan-Carolina, PR Central Guaynabo Municipio https://data.medicare.gov/resource/xubh-q36u/row-fwuh~bawf.93i3 400122 662581 2019-12-23 2019-06-30 49           49               49
2625 2625 SACRED HEART HOSPITAL 421 CHEW STREET ALLENTOWN PA 18102 LEHIGH (610) 776-4900 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6079870 -75.4680450 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-fni9_xrev~f329 390197 662579 2019-12-02 2019-06-30 117 12         129 16     22       167
2160 2160 GOOD SHEPHERD MEDICAL CENTER 610 NW 11TH STREET HERMISTON OR 97838 UMATILLA (541) 667-3400 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8461350 -119.3109500 0   59 41 41059 25840   Central Umatilla County https://data.medicare.gov/resource/xubh-q36u/row-2f95~scvq.xeyd 381325 662577 2019-11-27 2019-06-30 22 3         25               25
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
1609 1609 SACRED HEART MEDICAL CENTER - RIVERBEND 3333 RIVERBEND DRIVE SPRINGFIELD OR 97477 LANE (541) 222-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0813120 -123.0286550 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-xqg2~c6as-x5em 380102 662575 2019-11-27 2019-06-30 301 46       36 383               383
3481 3481 SYCAMORE MEDICAL CENTER 4000 MIAMISBURG-CENTERVILLE ROAD MIAMISBURG OH 45342 MONTGOMERY (937) 384-8776 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.6398200 -84.2512600 0   113 39 39113 19380 Dayton-Springfield-Sidney, OH Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-q9y2-ej79-7yp6 360239 662571 2019-12-09 2018-12-31 156 12         168               168
3483 3483 KETTERING MEDICAL CENTER 3535 SOUTHERN BOULEVARD KETTERING OH 45429 MONTGOMERY (937) 395-8165 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.6956030 -84.1909930 0   113 39 39113 19380 Dayton-Springfield-Sidney, OH Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-nep3.488k.vkyf 360079 662570 2019-12-09 2018-12-31 306 12 12   12 10 377   33           410
3324 3324 CHI ST ALEXIUS HEALTH WILLISTON 1301 15TH AVE W WILLISTON ND 58801 WILLIAMS (701) 774-7400 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.1543320 -103.6454370 0   105 38 38105 48780   Central Williams County https://data.medicare.gov/resource/xubh-q36u/row-2m99~vhsx_qu32 351334 662569 2019-12-02 2019-06-30 25           25               25
1088 1088 PERSHING GENERAL HOSPITAL 855 6TH STREET/PO BOX 661 LOVELOCK NV 89419 PERSHING (775) 273-2621 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1766240 -118.4820870 0   27 32 32027         https://data.medicare.gov/resource/xubh-q36u/row-9yyu.vv2v~izhm 291304 662550 2019-11-27 2019-06-30 13           13       25       38
695 695 BATTLE MOUNTAIN GENERAL HOSPITAL 535 SOUTH HUMBOLDT STREET BATTE MTN NV 89820 LANDER (775) 635-2550 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6406520 -116.9388210 0   15 32 32015         https://data.medicare.gov/resource/xubh-q36u/row-w9hj-b8v2_4i43 291303 662549 2019-11-29 2019-06-30 5           5       25       30
1344 1344 WILLIAM BEE RIRIE HOSPITAL 1500 AVENUE H ELY NV 89301 WHITE PINE (775) 289-3001 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2560650 -114.8600860 0   33 32 32033         https://data.medicare.gov/resource/xubh-q36u/row-xg87~7vrt.qaws 291302 662548 2019-11-27 2019-06-30 25           25               25
366 366 NORTHEASTERN NEVADA REGIONAL HOSPITAL 2001 ERRECART BLVD ELKO NV 89801 ELKO (775) 738-5151 Acute Care Hospitals Proprietary TRUE 40.8225080 -115.7290260 0   7 32 32007 21220   Central Elko County https://data.medicare.gov/resource/xubh-q36u/row-q6r2~fn4e-z9r9 290008 662547 2019-11-27 2019-06-30 52 7         59               59
192 192 UNIVERSITY MEDICAL CENTER 1800 W CHARLESTON BLVD LAS VEGAS NV 89102 CLARK (702) 383-2000 Acute Care Hospitals Government - Local TRUE 36.1589410 -115.1659450 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-crh9_6nqs_53ud 290007 662546 2019-11-29 2019-06-30 358 20 24 16 16 14 498               498
1912 1912 LIBERTY MEDICAL CENTER 315 W MADISON AVE CHESTER MT 59522 LIBERTY (406) 759-5181 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.5104970 -110.9718340 0   51 30 30051         https://data.medicare.gov/resource/xubh-q36u/row-jg4d_ys9s~wecb 271334 662543 2019-11-27 2019-06-30 25           25               25
22 22 STILLWATER BILLINGS CLINIC 710 N 11TH ST COLUMBUS MT 59019 STILLWATER (406) 322-5316 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6426860 -109.2431780 0   95 30 30095         https://data.medicare.gov/resource/xubh-q36u/row-feve.dr4z_em5n 271330 662542 2019-11-29 2019-06-30 10           10               10
1957 1957 CHILDREN'S HOSPITALS & CLINICS OF MN 2525 CHICAGO AVENUE SOUTH MINNEAPOLIS MN 55404 HENNEPIN (612) 813-6112 Childrens Voluntary non-profit - Private TRUE 44.9562370 -93.2625880 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-zsi6-wyrh~wxd5 243302 662539 2019-12-06 2018-12-31 151 42 25     196 414               414
181 181 ANNE ARUNDEL MEDICAL CENTER 2001 MEDICAL PARKWAY ANNAPOLIS MD 21401 ANNE ARUNDEL (443) 481-1307 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9911150 -76.5360580 0   3 24 24003 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Anne Arundel County https://data.medicare.gov/resource/xubh-q36u/row-npuw_t7wm.mrix 210023 662537 2019-12-23 2019-06-30 329 20       30 379               379
744 744 RUMFORD HOSPITAL 420 FRANKLIN STREET RUMFORD ME 4276 OXFORD (207) 369-1000 Critical Access Hospitals Proprietary TRUE 44.5517210 -70.5571710 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-923a_kexq.nxfx 201306 662536 2019-12-02 2019-06-30 25           25               25
3313 3313 LALLIE KEMP MEDICAL CENTER 52579 HIGHWAY 51 SOUTH INDEPENDENCE LA 70443 TANGIPAHOA (985) 878-9421 Critical Access Hospitals Government - State TRUE 30.6221940 -90.4969990 0   105 22 22105 25220 New Orleans-Metairie-Hammond, LA-MS Central Tangipahoa Parish https://data.medicare.gov/resource/xubh-q36u/row-iyxe~6sc2-ecgv 191321 662534 2019-12-02 2019-06-30 20 4         24               24
1737 1737 CASEY COUNTY HOSPITAL 187 WOLFORD AVENUE LIBERTY KY 42539 CASEY (606) 787-6275 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3178090 -84.9317170 0   45 21 21045         https://data.medicare.gov/resource/xubh-q36u/row-aju2-kjdy-yhzq 181309 662532 2019-11-27 2019-06-30 24           24               24
4266 4266 MORGAN COUNTY ARH HOSPITAL 476 LIBERTY ROAD WEST LIBERTY KY 41472 MORGAN (606) 743-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9201370 -83.2662760 0   175 21 21175         https://data.medicare.gov/resource/xubh-q36u/row-aia2-xvbh~gtxt 181307 662531 2019-12-03 2019-06-30 25           25               25
4379 4379 TUG VALLEY ARH REGIONAL MEDICAL CENTER 260 HOSPITAL DRIVE SOUTH WILLIAMSON KY 41503 PIKE (606) 237-1700 Acute Care Hospitals Proprietary TRUE 37.6763730 -82.2965810 0   195 21 21195         https://data.medicare.gov/resource/xubh-q36u/row-nrkm~8dtb_x2ee 180069 662529 2019-11-27 2019-06-30 82 6         88       35       123
4253 4253 SAINT JOSEPH MOUNT STERLING 225 FALCON DRIVE MOUNT STERLING KY 40353 MONTGOMERY (859) 497-5018 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.0759100 -83.9469200 0   173 21 21173 34460 Lexington-Fayette--Richmond--Frankfort, KY Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-aibw~dx67_uzdp 180064 662528 2019-11-27 2019-06-30 38 4         42               42

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