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 PRVDR_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                                      
3931 3931 EL PASO LTAC HOSPTIAL 1221 N COTTON ST 3RD FLOOR EL PASO TX 79902 EL PASO (915) 496-9687 Acute Care Hospitals Physician FALSE 31.7836990 -106.4735520 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-wqm3_d2vk.as9x 670127 661274 2019-12-05 2019-06-30 33           33               33
3933 3933 THE HOSPITALS OF PROVIDENCE HORIZON CITY CAMPUS 13600 HORIZON STREET, SUITE 100 HORIZON CITY TX 79928 EL PASO (915) 407-7878 Acute Care Hospitals Proprietary TRUE 31.6827230 -106.2073480 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-m5db~xjiy~dvv3 670124 649391 2019-05-30 2018-12-31 9           9               9
4583 4583 HOUSTON METHODIST THE WOODLANDS HOSPITAL 17201 INTERSTATE 45 SOUTH THE WOODLANDS TX 77385 MONTGOMERY (936) 270-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2046970 -95.4555100 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-uc2s-vyjm.8c3p 670122 649390 2019-06-03 2018-12-31 130 16         146               146
4653 4653 SAINT CAMILLUS MEDICAL CENTER 1612 HURST TOWN CENTER DRIVE HURST TX 76054 TARRANT (817) 519-3700 Acute Care Hospitals Proprietary TRUE 32.8424570 -97.1884610 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-xwb8_b64c-b49d 670121 653088 2019-08-23 2018-12-31 23           23               23
3925 3925 THE HOSPITALS OF PROVIDENCE TRANSMOUNTAIN CAMPUS 2000 TRANSMOUNTAIN RD EL PASO TX 79911 EL PASO (915) 877-8136 Acute Care Hospitals Proprietary TRUE 31.9044828 -106.5650394 1 ROOFTOP 141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-8cqi.sqna_eif8 670120 649983 2019-05-31 2018-12-31 94 12         106               106
4427 4427 PROVIDENCE HOSPITAL OF NORTH HOUSTON LLC 16750 RED OAK DRIVE HOUSTON TX 77090 HARRIS (281) 453-7916 Acute Care Hospitals Proprietary TRUE 30.0142780 -95.4409351 1 ROOFTOP 201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-akm5~pcmt~sgnr 670119 648515 2019-05-30 2018-12-31 16           16               16
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
4641 4641 WISE HEALTH SYSTEM 3200 NORTH TARRANT PARKWAY FORT WORTH TX 76177 TARRANT (817) 502-7300 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8974340 -97.3122990 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-nkp3_nyc5_hqkg 670116 650433 2019-05-30 2018-12-31 36           36               36
4551 4551 CLEVELAND EMERGENCY HOSPITAL 1017 S TRAVIS AVE CLEVELAND TX 77327 LIBERTY (281) 592-5400 Acute Care Hospitals Proprietary TRUE 30.3294340 -95.0960570 0   291 48 48291 26420 Houston-The Woodlands, TX Outlying Liberty County https://data.medicare.gov/resource/xubh-q36u/row-3yf9_ucey-48hx 670115 650933 2019-06-03 2018-12-31 16           16               16
1186 1186 LEGENT ORTHOPEDIC + SPINE 5330 NORTH LOOP 1604 WEST SAN ANTONIO TX 78249 BEXAR (717) 620-2424 Acute Care Hospitals Proprietary TRUE 29.5914810 -98.5904380 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-gmp5~zjwe~7e5z 670112 656038 2019-01-30 2018-08-31 26           26               26
3510 3510 FIRST TEXAS HOSPITAL CARROLLTON LLC 1401 E TRINITY MILLS ROAD CARROLLTON TX 75006 DALLAS (972) 810-0700 Acute Care Hospitals Proprietary TRUE 32.9850010 -96.8982210 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-pssx_vyvi-xhzt 670110 651438 2019-05-30 2018-12-31 18           18               18
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
929 929 BAYLOR SCOTT & WHITE MEDICAL CENTER - MARBLE FALLS 810 W HIGHWAY 71 MARBLE FALLS TX 78654 BURNET (830) 201-7308 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1107400 -97.3593810 0   21 48 48021 12420   Outlying Bastrop County https://data.medicare.gov/resource/xubh-q36u/row-jqmz_geif_6mxi 670108 661842 2019-12-16 2019-05-31 38 8         46               46
4643 4643 BAYLOR SCOTT AND WHITE EMERGENCY HOSPITAL BURLESON 12500 SOUTH FREEWAY SUITE 100 BURLESON TX 76028 JOHNSON (214) 294-6250 Acute Care Hospitals Proprietary TRUE 32.5760100 -97.3207740 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-f6z2_rbym-eqyb 670107 649156 2019-05-30 2018-12-31 24           24               24
1618 1618 HCA HOUSTON HEALTHCARE PEARLAND 11100 SHADOW CREEK PARKWAY PEARLAND TX 77584 BRAZORIA (713) 770-7000 Acute Care Hospitals Proprietary TRUE 29.5799940 -95.3919110 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-z9yc-krd4-cpqc 670106 651121 2019-06-27 2019-01-31 41 8         49               49
4636 4636 MEDICAL CITY ALLIANCE 3101 NORTH TARRANT PARKWAY FORT WORTH TX 76177 TARRANT (817) 639-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8985270 -97.3138140 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-7h4z-bqez~gg2f 670103 650796 2019-06-24 2019-01-31 59 8       8 75               75
4424 4424 AD HOSPITAL EAST, LLC 12950 EAST FREEWAY, SUITE 100 HOUSTON TX 77015 HARRIS (713) 330-3897 Acute Care Hospitals Proprietary TRUE 29.7711360 -95.2007820 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-g9pj_7cms.hams 670102 649155 2019-05-30 2018-12-31 4           4               4
2980 2980 RESOLUTE HEALTH HOSPITAL 555 CREEKSIDE XING, NEW BRAUNFELS TX 78130 COMAL (469) 839-6778 Acute Care Hospitals Proprietary TRUE 29.7192100 -98.0712120 0   91 48 48091 41700   Central Comal County https://data.medicare.gov/resource/xubh-q36u/row-idje_46pq-7psy 670098 656215 2019-10-31 2019-05-31 80 16       16 112               112
4423 4423 MEMORIAL HERMANN FIRST COLONY HOSPITAL 24429 TOMBALL PARKWAY, SUITE 100 TOMBALL TX 77375 HARRIS (281) 516-0911 Acute Care Hospitals Proprietary FALSE 30.0371760 -95.6053230 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-wtak~qp2w~qmyj 670095 649016 2019-05-30 2018-12-31 15           15               15
4587 4587 ASPIRE BEHAVIORAL HEALTH OF CONROE, LLC 2006 SOUTH LOOP 336 WEST, SUITE 500 CONROE TX 77304 MONTGOMERY (936) 647-3500 Acute Care Hospitals Physician FALSE 30.2840690 -95.4801310 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-h7u8.wg6t-a3vd 670093 651497 2019-05-31 2018-12-31 6           6 24             30
3505 3505 CRESCENT MEDICAL CENTER LANCASTER 2600 WEST PLEASANT RUN ROAD LANCASTER TX 75146 DALLAS (972) 230-8888 Acute Care Hospitals Physician TRUE 32.6041280 -96.8144830 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-idy9.ih28~dnum 670090 649860 2019-06-04 2018-12-31 76 8         84               84
4689 4689 BAYLOR SCOTT & WHITE MEDICAL CENTER- COLLEGE STATI 700 SCOTT & WHITE DRIVE COLLEGE STATION TX 77845 BRAZOS (979) 691-3701 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1538350 -96.3882090 0   477 48 48477 14780 Houston-The Woodlands, TX Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-cqfb_i8ft_nqt3 670088 656214 2019-10-31 2019-05-31 87 16         119               119
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
4647 4647 TEXAS HEALTH HARRIS METHODIST HOSPITAL ALLIANCE 10864 TEXAS HEALTH TRAIL FORT WORTH TX 76244 TARRANT (682) 212-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.9317170 -97.3099870 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-hrkm~j5nw.viir 670085 659912 2019-12-02 2019-06-30 81 12         101               101
2815 2815 BAYLOR SCOTT AND WHITE MEDICAL CENTER MCKINNEY 5252 WEST UNIVERSITY DRIVE MC KINNEY TX 75071 COLLIN (469) 764-2200 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2184040 -96.6810200 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-z87n_qjyy.khsy 670082 660482 2019-11-27 2019-06-30 114 16       13 143               143
1106 1106 SETON MEDICAL CENTER HARKER HEIGHTS 850 W CENTRAL TEXAS EXPRESSWAY HARKER HEIGHTS TX 76548 BELL (254) 953-8342 Acute Care Hospitals Proprietary TRUE 31.0742920 -97.6837070 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-qig4_ei54~8nwu 670080 654707 2019-09-27 2019-04-30 56 10         66               66
1189 1189 BAPTIST EMERGENCY HOSPITAL 16088 SAN PEDRO SAN ANTONIO TX 78232 BEXAR (210) 402-4092 Acute Care Hospitals Proprietary TRUE 29.5879550 -98.4741980 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-4y9d~e7dz-wrhw 670078 649389 2019-05-30 2018-12-31 50           50               50
4430 4430 HOUSTON METHODIST WEST HOSPITAL 18500 KATY FREEWAY HOUSTON TX 77094 HARRIS (832) 522-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7855310 -95.6972400 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-prwh_2axu.e5m3 670077 651258 2019-07-01 2018-12-31 168 25         193               193
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
4422 4422 ST LUKE'S HOSPITAL AT THE VINTAGE 20171 CHASEWOOD PARK DRIVE HOUSTON TX 77070 HARRIS (832) 534-5000 Acute Care Hospitals Proprietary TRUE 29.9894890 -95.5702480 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-68e3-j3wm_u7j8 670075 661132 2019-12-03 2019-06-30 70 12         86               86
3500 3500 METHODIST HOSPITAL FOR SURGERY 17101 DALLAS PARKWAY ADDISON TX 75001 DALLAS (469) 248-3900 Acute Care Hospitals Proprietary TRUE 32.9851310 -96.8288180 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-ge4u~ywgg~r953 670073 647316 2019-04-29 2018-11-30 28 4         32               32
4650 4650 TEXAS HEALTH HEART & VASCULAR HOSPITAL ARLINGTON 811 WRIGHT STREET ARLINGTON TX 76012 TARRANT (817) 960-3500 Acute Care Hospitals Proprietary FALSE 32.7482060 -97.1163900 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-qhpw~99pb.trhs 670071 649388 2019-05-30 2018-12-31 27   20       47               47
2817 2817 METHODIST MCKINNEY HOSPITAL 8000 W ELDORADO PKWY BLDG C SUITE C MCKINNEY TX 75070 COLLIN (214) 491-5710 Acute Care Hospitals Proprietary TRUE 33.1758090 -96.7243430 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-mnxi-9kbn.uk2u 670069 661131 2019-12-11 2019-07-31 23           23               23
3661 3661 TEXAS HEALTH PRESBYTERIAN HOSPITAL FLOWER MOUND 4400 LONG PRAIRIE ROAD FLOWER MOUND TX 75028 DENTON (972) 419-1530 Acute Care Hospitals Proprietary TRUE 33.0452270 -97.0693310 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-cv43_dzrr_v22n 670068 650226 2019-05-30 2018-12-31 91 8         99               99
4646 4646 BAYLOR SCOTT AND WHITE ORTHOPEDIC AND SPINE HOSPI 707 HIGHLANDER BLVD ARLINGTON TX 76015 TARRANT (817) 549-2364 Acute Care Hospitals Proprietary TRUE 32.6821530 -97.1172180 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-4bwe.2jky-j5da 670067 648584 2019-05-22 2018-12-31 24           24               24
3658 3658 BAYLOR SCOTT AND WHITE EMERGENCY HOSPITAL AUBREY 26791 HIGHWAY 380 AUBREY TX 76227 DENTON (972) 347-2525 Acute Care Hospitals Proprietary TRUE 33.2206581 -96.9135249 1 ROOFTOP 121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-9pb6.v6ys-8mdu 670062 649013 2019-05-30 2018-12-31 40           40               40
4595 4595 SOUTH TEXAS SURGICAL HOSPITAL 6130 PARKWAY DRIVE CORPUS CHRISTI TX 78414 NUECES (361) 993-2000 Acute Care Hospitals Proprietary TRUE 27.6869280 -97.3754370 0   355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-cbxw_6hav~c9r6 670061 651496 2019-05-29 2018-12-31 33           33               33
3490 3490 BAYLOR SCOTT AND WHITE MEDICAL CENTER SUNNYVALE 231 SOUTH COLLINS ROAD SUNNYVALE TX 75182 DALLAS (972) 892-3000 Acute Care Hospitals Proprietary TRUE 32.7783400 -96.5671780 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-xs7f_5svn~da2r 670060 661839 2019-12-04 2018-12-31 62 8         70               70
4582 4582 ST LUKES LAKESIDE HOSPITAL 17400 ST LUKES WAY THE WOODLANDS TX 77384 MONTGOMERY (936) 266-4055 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.2031320 -95.4594820 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-4i3k-4nqm~yxpg 670059 661450 2019-12-02 2019-06-30 30           30               30
4460 4460 SETON MEDICAL CENTER HAYS 6001 KYLE PKWY KYLE TX 78640 HAYS (512) 324-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.0077340 -97.8552800 0   209 48 48209 12420   Central Hays County https://data.medicare.gov/resource/xubh-q36u/row-2smr~t9jf_xa5x 670056 660903 2019-11-26 2019-06-30 106 32       4 142               142
1178 1178 METHODIST STONE OAK HOSPITAL 1139 E SONTERRA BLVD, STE 535 SAN ANTONIO TX 78258 BEXAR (210) 638-2100 Acute Care Hospitals Proprietary TRUE 29.6144940 -98.4754590 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-32ag-t8fj-9ybq 670055 652855 2019-07-31 2019-02-28 175 28       24 227   15           242
1190 1190 FOUNDATION SURGICAL HOSPITAL OF SAN ANTONIO 9522 HUEBNER ROAD SAN ANTONIO TX 78240 BEXAR (210) 478-5400 Acute Care Hospitals Proprietary TRUE 29.5310350 -98.5925540 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-pvs4~yydr-y7qv 670054 649387 2019-06-03 2018-12-31 20           20               20
4113 4113 ST LUKE'S SUGAR LAND HOSPITAL 1317 LAKE POINTE PARKWAY SUGAR LAND TX 77478 FORT BEND (281) 637-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.6049600 -95.6213280 0   157 48 48157 26420 Houston-The Woodlands, TX Central Fort Bend County https://data.medicare.gov/resource/xubh-q36u/row-n44e-qpxd~fkk8 670053 660061 2019-12-02 2019-06-30 79 16         100               100

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