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 fy_end_date

View and edit SQL

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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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 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                                      
158 SHRINERS HOSPITAL FOR CHILDREN 1310 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 941-4466 Childrens Voluntary non-profit - Private FALSE 21.3002330 -157.8343650 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-jcn3.53aq~rski 123301 644976 2018-05-31 2017-12-31                              
191 HARMON HOSPITAL 2170 EAST HARMON AVENUE LAS VEGAS NV 89119 CLARK (702) 794-0100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.1073690 -115.1219920 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-qtzp-aczd_sysf 290042 629833 2018-05-31 2017-12-31                              
300 WEISMAN CHILDRENS REHABILITATION HOSPITAL 92 BRICK ROAD, 3RD FLOOR MARLTON NJ 8053 BURLINGTON (856) 489-4520 Childrens Proprietary TRUE 39.8805880 -74.9192090 0   5 34 34005 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Burlington County https://data.medicare.gov/resource/xubh-q36u/row-9nkd_6jvc_38s2 313302 651476 2018-04-12 2017-12-31 18           18               18
739 SHRINERS HOSPITALS FOR CHILDREN 3100 SAMFORD AVENUE SHREVEPORT LA 71103 CADDO (318) 222-5704 Childrens Voluntary non-profit - Private FALSE 32.4812950 -93.7566370 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-yvmb~28rx-rdcg 193301 647125 2018-05-31 2017-12-31                              
1055 SUMMIT MEDICAL CENTER 6350 E 2ND STREET CASPER WY 82609 NATRONA (307) 232-6600 Acute Care Hospitals Physician FALSE 42.8408460 -106.2317960 0   25 56 56025 16220   Central Natrona County https://data.medicare.gov/resource/xubh-q36u/row-8pwp.t3su_b96w 530034 645740 2019-03-04 2017-12-31                              
1441 SHRINERS HOSPITALS FOR CHILDREN - SALT LAKE CITY 1275 EAST FAIRFAX ROAD SALT LAKE CITY UT 84103 SALT LAKE (801) 536-3500 Childrens Voluntary non-profit - Private FALSE 40.7767640 -111.8511170 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-z268_bq8t.wgx8 463302 651875 2018-05-31 2017-12-31                              
1501 SHRINERS HOSPITALS FOR CHILDREN 3160 GENEVA STREET LOS ANGELES CA 90020 LOS ANGELES (213) 388-3151 Childrens Voluntary non-profit - Private FALSE 34.0677080 -118.2863870 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zkfj-xhi2.ce89 53310 655536 2018-05-31 2017-12-31                              
1578 ASPEN MOUNTAIN MEDICAL CENTER 4401 COLLEGE DRIVE ROCK SPRINGS WY 82901 SWEETWATER (307) 448-2758 Acute Care Hospitals Proprietary FALSE 41.6031870 -109.2479170 0   37 56 56037 40540   Central Sweetwater County https://data.medicare.gov/resource/xubh-q36u/row-x9bs.ynhd_upz4 530035 651148 2018-05-29 2017-12-31                              
1921 SHRINERS HOSPITAL FOR CHILDREN-PORTLAND 3101 SW SAM JACKSON PARK ROAD PORTLAND OR 97239 MULTNOMAH (971) 544-3312 Childrens Voluntary non-profit - Private FALSE 45.5001050 -122.6846030 0   51 41 41051 38900 Portland-Vancouver-Salem, OR-WA Central Multnomah County https://data.medicare.gov/resource/xubh-q36u/row-3x85_ztpc_gwzg 383300 645441 2018-05-31 2017-12-31                              
1979 MARY BRIDGE CHILDREN'S HOSPITAL 317 MARTIN LUTHER KING JR W BOX 5299 TACOMA WA 98415 PIERCE (253) 403-1400 Childrens Voluntary non-profit - Other TRUE 47.2587434 -122.4527167 1 ROOFTOP 53 53 53053 42660 Seattle-Tacoma, WA Central Pierce County https://data.medicare.gov/resource/xubh-q36u/row-8c85~gidq~gevc 503301 645385 2018-06-05 2017-12-31                              
2274 SHRINERS HOSPITAL FOR CHILDREN 911 WEST 5TH AVENUE SPOKANE WA 99204 SPOKANE (509) 623-0422 Childrens Voluntary non-profit - Private FALSE 47.6513980 -117.4259570 0   63 53 53063 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Spokane County https://data.medicare.gov/resource/xubh-q36u/row-mctz_2czz-inqw 503302 645453 2018-05-31 2017-12-31                              
2296 DOCTORS HOSPITAL OF RIVERSIDE 3865 JACKSON STREET RIVERSIDE CA 92503 RIVERSIDE (951) 688-2211 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.9256970 -117.4400520 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-sdgf-p94g_256s 50102 654640 2018-05-31 2017-12-31 166 13       12 191               191
2333 SHRINERS HOSPITALS FOR CHILDREN NORTHERN CALIF 2425 STOCKTON BOULEVARD SACRAMENTO CA 95817 SACRAMENTO (916) 453-2000 Childrens Voluntary non-profit - Private FALSE 38.5529930 -121.4562690 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-pctf.xrmj_v2ef 53311 655537 2018-05-31 2017-12-31                              
3238 SHRINERS HOSPITALS FOR CHILDREN - PHILADELPHIA 3551 N BROAD STREET PHILADELPHIA PA 19104 PHILADELPHIA (215) 430-4000 Childrens Voluntary non-profit - Other FALSE 40.0069680 -75.1516990 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-iwpu.igc9.39y9 393309 629311 2018-05-30 2017-12-31                              
4432 SHRINERS HOSPITALS FOR CHILDREN 6977 MAIN STREET HOUSTON TX 77030 HARRIS (713) 797-1616 Childrens Voluntary non-profit - Other FALSE 29.7047380 -95.4061740 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-zk7z~jazy_wtka 453312 651360 2018-07-12 2017-12-31                              
4579 LITTLE RIVER HEALTHCARE 1700 BRAZOS ROCKDALE TX 76567 MILAM (512) 446-4500 Critical Access Hospitals Proprietary TRUE 30.6503240 -97.0201050 0   331 48 48331         https://data.medicare.gov/resource/xubh-q36u/row-afvn-5pmv_graz 451357 630239 2018-06-01 2017-12-31 25           25               25
4620 CARE REGIONAL MEDICAL CENTER 1711 W WHEELER AVENUE ARANSAS PASS TX 78336 SAN PATRICIO (361) 758-8585 Acute Care Hospitals Proprietary TRUE 27.9159210 -97.1618290 0   409 48 48409 18580 Corpus Christi-Kingsville-Alice, TX Central San Patricio County https://data.medicare.gov/resource/xubh-q36u/row-g7k6_vy64~c2bf 450605 655598 2018-07-30 2017-12-31 63           63 12             75
3882 NORTH OAK REGIONAL MEDICAL CENTER 401 GETWELL DR SENATOBIA MS 38668 TATE (662) 562-3100 Acute Care Hospitals Proprietary TRUE 34.6246780 -89.9567440 0   137 28 28137 32820 Memphis-Forrest City, TN-MS-AR Outlying Tate County https://data.medicare.gov/resource/xubh-q36u/row-pcjm~cndq_ygq8 250126 655683 2018-10-10 2018-03-31 29           29 12             41
15 GARRISON MEMORIAL HOSPITAL 407 3RD AVE SE GARRISON ND 58540 MCLEAN (701) 463-2275 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.6483420 -101.4113010 0   55 38 38055         https://data.medicare.gov/resource/xubh-q36u/row-e4ej.ybr6_ritz 351303 640250 2018-12-03 2018-06-30 22           22       28       50
18 HOUSTON COUNTY COMMUNITY HOSPITAL 5001 EAST MAIN STREET ERIN TN 37061 HOUSTON (931) 289-4211 Critical Access Hospitals Government - Local TRUE 36.3195160 -87.6891930 0   83 47 47083         https://data.medicare.gov/resource/xubh-q36u/row-dt3z.s9ya.age2 441322 639931 2018-12-03 2018-06-30 25           25               25
49 ALAMEDA HOSPITAL 2070 CLINTON AVENUE ALAMEDA CA 94501 ALAMEDA (510) 522-3700 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7632300 -122.2535410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-aten_zvra_dnju 50211 662328 2018-12-03 2018-06-30 29   5       34       181       215
51 SAN LEANDRO HOSPITAL 13855 E 14TH STREET SAN LEANDRO CA 94578 ALAMEDA (510) 357-6500 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7146320 -122.1419730 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-whtt-wfgb.a9rb 50773 657702 2018-12-03 2018-06-30 39 6         45               45
80 HILO MEDICAL CENTER 1190 WAIANUENUE AVENUE HILO HI 96720 HAWAII (808) 932-3000 Acute Care Hospitals Government - State TRUE 19.7174670 -155.1135130 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-szpt~f525_222j 120005 657722 2018-12-03 2018-06-30 146 11         157       119       276
81 HALE HO'OLA HAMAKUA 45-547 PLUMERIA STREET HONOKAA HI 96727 HAWAII (808) 932-4100 Critical Access Hospitals Government - State TRUE 20.0762710 -155.4705950 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-z9jm-2idi-sq3z 121307 640366 2018-12-03 2018-06-30 11           11       66       77
147 BIG HORN HOSPITAL 17 N MILES HARDIN MT 59034 BIG HORN (406) 665-2310 Critical Access Hospitals Government - Local TRUE 45.7288560 -107.6170100 0   3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-2cgz.f5s8-gu8f 271338 652087 2018-11-27 2018-06-30 25           25               25
154 KUAKINI MEDICAL CENTER 347 NORTH KUAKINI STREET HONOLULU HI 96817 HONOLULU (808) 536-2236 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3222110 -157.8562110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-haju_ivwx-iwr6 120007 656434 2018-12-26 2018-06-30 146 12 12       170       40 147     357
195 SAINT ROSE DOMINICAN HOSPITALS - SIENA CAMPUS 3001 ST ROSE PARKWAY HENDERSON NV 89052 CLARK (702) 616-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0045271 -115.1150581 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8dra~5wtd-jnuh 290045 662405 2018-11-30 2018-06-30 244 50         326               326
196 SAINT ROSE DOMINICAN HOSPITALS - ROSE DE LIMA 102 E LAKE MEAD DR HENDERSON NV 89015 CLARK (702) 616-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.0388290 -114.9831920 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-r9pq.jhhc.4qfi 290012 657913 2018-11-30 2018-06-30 72 10         82   28           110
333 CAMPBELL COUNTY MEMORIAL HOSPITAL 501 SOUTH BURMA AVENUE GILLETTE WY 82716 CAMPBELL (307) 688-1551 Acute Care Hospitals Government - Hospital District or Authority TRUE 44.2898460 -105.5195570 0   5 56 56005 23940   Central Campbell County https://data.medicare.gov/resource/xubh-q36u/row-ppek.rg99~yqr6 530002 658628 2018-11-29 2018-06-30 52 14         66 6     160       232
344 ORCHARD HOSPITAL 240 SPRUCE STREET GRIDLEY CA 95948 BUTTE (530) 846-5671 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3669740 -121.6897170 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-kvk2_zuau.b3ab 51311 640345 2018-12-03 2018-06-30 24           24       52       76
350 KAUAI VETERANS MEMORIAL HOSPITAL 4643 WAIMEA CANYON DRIVE WAIMEA HI 96796 KAUAI (808) 338-9431 Critical Access Hospitals Government - State TRUE 21.9600790 -159.6700550 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ddrn-xkz9.2xji 121300 655051 2019-09-20 2018-06-30 23 2         25       20       45
351 SAMUEL MAHELONA MEMORIAL HOSPITAL 4800 KAWAIHAU ROAD KAPAA HI 96746 KAUAI (808) 822-4961 Critical Access Hospitals Government - State TRUE 22.0876190 -159.3142040 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-ysve.ycbm-b3qy 121306 640504 2018-11-30 2018-06-30 5           5 9     66       80
448 BEARTOOTH BILLINGS CLINIC 2525 N BROADWAY RED LODGE MT 59068 CARBON (406) 446-2345 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2116970 -109.2430450 0   9 30 30009 13740   Outlying Carbon County https://data.medicare.gov/resource/xubh-q36u/row-i4we~7hxf.sxbf 271326 640232 2018-12-03 2018-06-30 10           10               10
493 HOLY CROSS HOSPITAL 4725 N FEDERAL HWY FORT LAUDERDALE FL 33308 BROWARD (954) 771-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 26.1853780 -80.1176590 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-q8e2.rdpd.9cpi 100073 654519 2019-09-09 2018-06-30 256 44       9 309   48           357
509 ASCENSION STANDISH HOSPITAL 805 W CEDAR ST STANDISH MI 48658 ARENAC (517) 846-4521 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9828300 -83.9693520 0   11 26 26011         https://data.medicare.gov/resource/xubh-q36u/row-3a56-bznt.bz29 231305 639965 2018-12-12 2018-06-30 20 5         25       29       54
545 CROOK COUNTY HOSPITAL 713 OAK STREET SUNDANCE WY 82729 CROOK (307) 283-3501 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4088300 -104.3735960 0   11 56 56011         https://data.medicare.gov/resource/xubh-q36u/row-ikyx-7gnq-abzi 531311 640303 2018-12-04 2018-06-30 16           16       32       48
564 VALLEYWISE HEALTH MEDICAL CENTER 2601 EAST ROOSEVELT STREET PHOENIX AZ 85008 MARICOPA (602) 344-5011 Acute Care Hospitals Government - Local TRUE 33.4585250 -112.0264300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-c5qr_etcr-7dch 30022 661279 2018-12-03 2018-06-30 211 20   19 13   323 241             564
568 ST. JOSEPH'S HOSPITAL AND MEDICAL CENTER 350 WEST THOMAS ROAD PHOENIX AZ 85013 MARICOPA (602) 406-5001 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4802940 -112.0792080 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-kyrc_3hbc_et9k 30024 658638 2019-10-10 2018-06-30 268   24   32   460   52           512
606 PINEVILLE COMMUNITY HEALTH CENTER, INC 850 RIVERVIEW AVENUE PINEVILLE KY 40977 BELL (606) 337-3051 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7630770 -83.7085740 0   13 21 21013 33180   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-fc9h_t8d9~pcu3 180021 651620 2019-07-15 2018-06-30 41           41 12             53
623 HUMBOLDT GENERAL HOSPITAL 118 EAST HASKELL STREET WINNEMUCCA NV 89445 HUMBOLDT (775) 623-5222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9715810 -117.7285340 0   13 32 32013 49080   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-ca7p_4a94-fjt7 291308 641600 2018-11-30 2018-06-30 22 3         25       42       67
655 UINTAH BASIN MEDICAL CENTER 250 WEST 300 NORTH ROOSEVELT UT 84066 DUCHESNE (435) 722-4691 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3027550 -109.9970860 0   13 49 49013         https://data.medicare.gov/resource/xubh-q36u/row-qmgd.dczn~ghmv 460019 658598 2019-01-10 2018-06-30 31 4         35               35
763 GROVER C DILS MEDICAL CENTER 700 N SPRING ST, BOX 1010-C-ADM BLDG CALIENTE NV 89008 LINCOLN (775) 726-3171 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.6222810 -114.5118240 0   17 32 32017         https://data.medicare.gov/resource/xubh-q36u/row-5bun~jms2_227p 291312 654895 2018-12-03 2018-06-30 4           4       16       20
798 HOT SPRINGS COUNTY MEMORIAL HOSPITAL 150 EAST ARAPAHOE THERMOPOLIS WY 82443 HOT SPRINGS (307) 864-3121 Critical Access Hospitals Government - Local TRUE 43.6474320 -108.1995900 0   17 56 56017         https://data.medicare.gov/resource/xubh-q36u/row-ktb5~jtkf~b2ae 531304 640300 2018-11-30 2018-06-30 25           25               25

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