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 hospital_ownership

✎ 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                                      
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                                      
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                                      
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                                      
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                                      
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                                      
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                                      
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                                      
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                                      
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                                      
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                                      
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                                      
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                                      
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                                      
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                                      
38 38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
40 40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
187 187 P H S INDIAN HOSPITAL CROW / NORTHERN CHEYENNE 1010 SOUTH 7650 EAST, POST OFFICE BOX 9 CROW AGENCY MT 59022 BIG HORN (406) 638-2626 Critical Access Hospitals Government - Federal TRUE 45.5821958 -107.4488586 1 ROOFTOP 3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-pgmt~4b42~eq7a 271339 646565 2019-03-26 2018-09-30 24           24               24
294 294 P H S INDIAN HOSPITAL-FT BELKNAP AT HARLEM - CAH 456 GROS VENTRE AVE, RR 1 HARLEM MT 59526 BLAINE (406) 353-3100 Critical Access Hospitals Government - Federal TRUE 48.4851890 -108.7670010 0   5 30 30005         https://data.medicare.gov/resource/xubh-q36u/row-sifm_y3g6.gq5p 271315 646038 2019-03-29 2018-09-30 6           6               6
349 349 WILCOX MEMORIAL HOSPITAL 3-3420 KUHIO HIGHWAY LIHUE HI 96766 KAUAI (808) 245-1103 Acute Care Hospitals Government - Federal TRUE 21.9870430 -159.3661980 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-9k2j.d4pk.dvnd 120014 662037 2019-11-26 2019-06-30 65 7         72               72
362 362 RED LAKE HOSPITAL A PO BOX 497 REDLAKE MN 56671 BELTRAMI (218) 679-3912 Acute Care Hospitals Government - Federal FALSE 47.8763460 -95.0169401 1 GEOMETRIC_CENTER 7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-jefe.tmy8.7dit 240206 649909 2019-06-18 2018-09-30 23           23               23
404 404 SAN CARLOS APACHE HEALTHCARE 103 MEDICINE WAY ROAD PERIDOT AZ 85542 GILA (928) 475-1200 Acute Care Hospitals Government - Federal FALSE 33.2956419 -110.4178011 1 ROOFTOP 9 4 4009 40940   Central Graham County https://data.medicare.gov/resource/xubh-q36u/row-9543-jpqy.dn76 30077 651688 2019-07-01 2018-09-30 8           8               8
455 455 PLAINS REGIONAL MEDICAL CENTER 2100 N MARTIN LUTHER KING, JR, BLVD CLOVIS NM 88101 CURRY (575) 769-7155 Acute Care Hospitals Government - Federal TRUE 34.4204900 -103.2317630 0   9 35 35009 17580 Clovis-Portales, NM Central Curry County https://data.medicare.gov/resource/xubh-q36u/row-dvw2.36gg-bpn9 320022 650185 2019-05-30 2018-12-31 98 8         106               106
546 546 PARKER INDIAN HEALTH CENTER 12033 AGENCY ROAD PARKER AZ 85344 LAPAZ (928) 669-2137 Critical Access Hospitals Government - Federal TRUE 34.1464940 -114.3013140 0   12 4 4012         https://data.medicare.gov/resource/xubh-q36u/row-942m-hgdi~yjfy 31307 645964 2019-04-01 2018-09-30 20           20               20
554 554 PHOENIX INDIAN MEDICAL CENTER 4212 NORTH 16TH STREET PHOENIX AZ 85016 MARICOPA (602) 263-1200 Acute Care Hospitals Government - Federal FALSE 33.4970100 -112.0476130 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-gzm7-4h6v-chi5 30078 651313 2019-07-02 2018-09-30 133           133               133
723 723 WHITERIVER PHS INDIAN HOSPITAL 200 WEST HOSPITAL DRIVE (PO BOX 860) WHITERIVER AZ 85941 NAVAJO (928) 338-4911 Acute Care Hospitals Government - Federal FALSE 33.8759760 -109.9595280 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-v5m3-a25g-4tei 30113 650108 2019-06-15 2018-09-30 40           40               40
873 873 ALASKA NATIVE MEDICAL CENTER 4315 DIPLOMACY DR ANCHORAGE AK 99508 ANCHORAGE (907) 729-3971 Acute Care Hospitals Government - Federal TRUE 61.1818900 -149.8005780 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-5h7d.5evj.yxgq 20026 651310 2019-07-01 2018-09-30 173         1 174               174
878 878 HUHU KAM MEMORIAL HOSPITAL 483 WEST SEED FARM ROAD SACATON AZ 85147 PINAL (520) 562-3321 Critical Access Hospitals Government - Federal TRUE 33.0741220 -111.7590800 0   21 4 4021 38060   Central Pinal County https://data.medicare.gov/resource/xubh-q36u/row-fpem.7xy6-nzbf 31308 645965 2019-03-28 2018-09-30 12           12               12
883 883 GLENN MEDICAL CENTER 1133 W SYCAMORE ST WILLOWS CA 95988 GLENN (530) 934-1818 Critical Access Hospitals Government - Federal TRUE 39.5204670 -122.2081200 0   21 6 6021         https://data.medicare.gov/resource/xubh-q36u/row-7nst_26uq.zcvx 51306 662484 2019-12-03 2019-06-30 15           15               15
903 903 BETH ISRAEL DEACONESS HOSPITAL-MILTON INC 199 REEDSDALE ROAD MILTON MA 2186 NORFOLK (617) 696-4600 Acute Care Hospitals Government - Federal TRUE 42.2523520 -71.0752130 0   21 25 25021 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Norfolk County https://data.medicare.gov/resource/xubh-q36u/row-igb2.542k_rxpc 220108 644741 2019-03-13 2018-09-30 94 8         102               102
909 909 CASS LAKE INDIAN HEALTH SERVICES HOSPITAL 425 7TH STREET NW CASS LAKE MN 56633 CASS (218) 335-3200 Critical Access Hospitals Government - Federal TRUE 47.3840940 -94.6095150 0   21 27 27021 14660   Outlying Cass County https://data.medicare.gov/resource/xubh-q36u/row-4suk.s9dt-ycv4 241358 646101 2019-03-29 2018-09-30 5           5               5
1290 1290 GALLUP INDIAN MEDICAL CENTER 516 E NIZHONI BLVD GALLUP NM 87301 MCKINLEY (505) 722-1000 Acute Care Hospitals Government - Federal TRUE 35.5084440 -108.7302260 0   31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-6j78~q67u-hap6 320061 650186 2019-06-06 2018-09-30 74           74               74
1291 1291 CROWNPOINT HEALTHCARE FACILITY JUNCTION OF HWY 371 CROWNPOINT NM 87313 MCKINLEY (505) 786-5291 Acute Care Hospitals Government - Federal TRUE 35.6987639 -108.1396562 1 GEOMETRIC_CENTER 31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-fk7d.f3eh~sfri 320062 647264 2019-05-08 2018-09-30 19           19               19
1292 1292 ZUNI COMPREHENSIVE COMMUNITY HEALTH CENTER ROUTE 301 NORTH B STREET ZUNI NM 87327 MCKINLEY (505) 782-4431 Acute Care Hospitals Government - Federal TRUE 35.0785445 -108.8119284 1 GEOMETRIC_CENTER 31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-bm92~a2re_rnct 320060 647300 2019-05-08 2018-09-30 27           27               27
1298 1298 LAWTON INDIAN HOSPITAL 1515 LAWRIE TATUM ROAD LAWTON OK 73507 COMANCHE (580) 354-5000 Acute Care Hospitals Government - Federal TRUE 34.6274940 -98.3857180 0   31 40 40031 30020   Central Comanche County https://data.medicare.gov/resource/xubh-q36u/row-wxwg-zekm.zah6 370170 648308 2019-05-08 2018-09-30 38           38               38
1398 1398 P H S INDIAN HOSPITAL AT BROWNING - BLACKFEET 760 HOSPITAL CIRCLE, POST OFFICE BOX 760 BROWNING MT 59417 GLACIER (406) 338-6157 Acute Care Hospitals Government - Federal TRUE 48.5657292 -113.0197530 1 ROOFTOP 35 30 30035         https://data.medicare.gov/resource/xubh-q36u/row-6bdm_qidd_w2p9 270074 651216 2019-06-24 2018-09-30 26           26               26
1401 1401 MESCALERO PHS INDIAN HOSPITAL P O BOX 210 MESCALERO NM 88340 OTERO (505) 464-4441 Acute Care Hospitals Government - Federal FALSE 33.1587939 -105.7723979 1 ROOFTOP 35 35 35035 10460   Central Otero County https://data.medicare.gov/resource/xubh-q36u/row-vqii_apfk.3xws 320058 650730 2019-06-22 2018-09-30 6           6               6
1669 1669 PHS INDIAN HOSPITAL AT EAGLE BUTTE 24276 166TH AIRPORT ROAD EAGLE BUTTE SD 57625 DEWEY (605) 964-3005 Acute Care Hospitals Government - Federal TRUE 44.9935681 -101.2421234 1 GEOMETRIC_CENTER 41 46 46041         https://data.medicare.gov/resource/xubh-q36u/row-5fj3.qevg-rb9t 430083 650906 2019-06-24 2018-09-30 8           8               8
1745 1745 NORTHERN NAVAJO MEDICAL CENTER US HWY 491 NORTH SHIPROCK NM 87420 SAN JUAN (505) 368-6001 Acute Care Hospitals Government - Federal TRUE 36.8052353 -108.6914076 1 GEOMETRIC_CENTER 45 35 35045 22140   Central San Juan County https://data.medicare.gov/resource/xubh-q36u/row-92dv_6fd6_m5cs 320059 651387 2019-06-18 2018-09-30 60           60               60
1852 1852 SANTA FE PHS INDIAN HOSPITAL 1700 CERRILLOS ROAD SANTA FE NM 87501 SANTA FE (505) 988-9821 Acute Care Hospitals Government - Federal FALSE 35.6669500 -105.9696650 0   49 35 35049 42140 Albuquerque-Santa Fe-Las Vegas, NM Central Santa Fe County https://data.medicare.gov/resource/xubh-q36u/row-9cut.x6uq_hkie 320057 647086 2019-04-27 2018-09-30 4           4               4
1962 1962 PHILLIPS EYE INSTITUTE 2215 PARK AVENUE SOUTH MINNEAPOLIS MN 55404 HENNEPIN (612) 775-8751 Acute Care Hospitals Government - Federal FALSE 44.9604780 -93.2651060 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-6egw_a4dk~jkf6 240196 662388 2019-12-11 2019-07-31 8           8               8
2655 2655 P H S INDIAN HOSP AT BELCOURT-QUENTIN N BURDICK PO BOX 160 BELCOURT ND 58316 ROLETTE (701) 477-6111 Acute Care Hospitals Government - Federal TRUE 48.8434415 -99.7483567 1 ROOFTOP 79 38 38079         https://data.medicare.gov/resource/xubh-q36u/row-tdmb_245b_qx4d 350063 650356 2019-06-18 2018-09-30 27           27               27
2775 2775 REGIONAL MEDICAL CENTER OF SAN JOSE 225 N JACKSON AVENUE SAN JOSE CA 95116 SANTA CLARA (408) 259-5000 Acute Care Hospitals Government - Federal TRUE 37.3637870 -121.8488230 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-qe98-xids.qirm 50125 648592 2019-05-24 2018-12-31 218 34         258               258
2802 2802 STANDING ROCK INDIAN HEALTH SERVICE HOSPITAL 10 NORTH RIVER ROAD FORT YATES ND 58538 SIOUX (701) 854-3831 Acute Care Hospitals Government - Federal TRUE 46.0952325 -100.6281136 1 ROOFTOP 85 38 38085 13900   Outlying Sioux County https://data.medicare.gov/resource/xubh-q36u/row-a84q-rj3h~6yed 350064 651228 2019-06-18 2018-09-30 12           12               12
2816 2816 TEXAS HEALTH PRESBYTERIAN HOSPITAL ALLEN 1105 CENTRAL EXPRESSWAY NORTH ALLEN TX 75013 COLLIN (972) 747-6197 Acute Care Hospitals Government - Federal TRUE 33.1154330 -96.6715040 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-v7tw~68xq-fbxm 450840 648765 2019-05-31 2018-12-31 30 8         44               44
2957 2957 PROMEDICA HERRICK HOSPITAL 500 E POTTAWATAMIE STREET TECUMSEH MI 49286 LENAWEE (517) 424-3000 Critical Access Hospitals Government - Federal TRUE 42.0029090 -83.9375500 0   91 26 26091 10300 Detroit-Warren-Ann Arbor, MI Central Lenawee County https://data.medicare.gov/resource/xubh-q36u/row-qhbx.76b3_qikh 231334 648847 2019-05-29 2018-12-31 25           25               25
3167 3167 CHOCTAW HEALTH CENTER ROUTE 7 BOX R50 PHILADELPHIA MS 39350 NESHOBA (601) 656-2211 Acute Care Hospitals Government - Federal TRUE 32.7809947 -89.1834058 1 ROOFTOP 99 28 28099         https://data.medicare.gov/resource/xubh-q36u/row-5rfv.qyga.n666 250127 652147 2019-07-02 2018-09-30 20           20               20
3321 3321 CATSKILL REGIONAL MEDICAL CENTER - G HERMANN SITE 8081 ROUTE 97 CALLICOON NY 12723 SULLIVAN (845) 887-5530 Critical Access Hospitals Government - Federal FALSE 41.7354523 -75.0429660 1 RANGE_INTERPOLATED 105 36 36105         https://data.medicare.gov/resource/xubh-q36u/row-exhc-5fn7-r9xs 331303 649479 2019-05-28 2018-12-31 15           15               15
3363 3363 TROY REGIONAL MEDICAL CENTER 1330 HIGHWAY 231 SOUTH TROY AL 36081 PIKE (334) 670-5000 Acute Care Hospitals Government - Federal TRUE 31.7803220 -85.9455290 0   109 1 1109 45980   Central Pike County https://data.medicare.gov/resource/xubh-q36u/row-5ter_pyex-x2fe 10126 654064 2019-08-30 2019-03-31 88 9         97 18             115
3519 3519 ADVENTIST HEALTH AND RIDEOUT 726 4TH ST MARYSVILLE CA 95901 YUBA (530) 749-4300 Acute Care Hospitals Government - Federal TRUE 39.1388320 -121.5936220 0   115 6 6115 49700 Sacramento-Roseville, CA Central Yuba County https://data.medicare.gov/resource/xubh-q36u/row-ena2_rmjt-rgun 50133 660916 2019-11-27 2019-06-30 179 24         209               209
3655 3655 PHS INDIAN HOSPITAL AT ROSEBUD 400 SOLDIER CREEK ROAD ROSEBUD SD 57570 TODD (605) 747-2231 Acute Care Hospitals Government - Federal TRUE 43.2553350 -100.8421210 0   121 46 46121         https://data.medicare.gov/resource/xubh-q36u/row-5qds~56wu-8q7x 430084 650907 2019-06-22 2018-09-30 35           35               35
4258 4258 CHEROKEE INDIAN HOSPITAL AUTHORITY CALLER BOX C268 CHEROKEE NC 28719 SWAIN (704) 497-9163 Acute Care Hospitals Government - Federal TRUE 35.4841903 -83.3232054 1 ROOFTOP 173 37 37173         https://data.medicare.gov/resource/xubh-q36u/row-k27i~9abs_tp2y 340156 649941 2019-06-18 2018-09-30 20           20               20
4321 4321 SAMUEL SIMMONDS MEMORIAL HOSPITAL 7000 UULA ST BARROW AK 99723 NORTH SLOPE BOROUH (907) 852-4611 Critical Access Hospitals Government - Federal TRUE 71.2981350 -156.7273200 0   185 2 2185         https://data.medicare.gov/resource/xubh-q36u/row-5czr-fghi_bwfa 21312 646058 2019-03-29 2018-09-30 20           20               20
4450 4450 ST CLAIRE REGIONAL MEDICAL CENTER 222 MEDICAL CIRCLE MOREHEAD KY 40351 ROWAN (606) 783-6502 Acute Care Hospitals Government - Federal TRUE 38.1800160 -83.4424540 0   205 21 21205         https://data.medicare.gov/resource/xubh-q36u/row-epvn~wthp~wxsz 180018 660556 2019-11-26 2019-06-30 76 14         90 20 10   7   3   130
4606 4606 DHHS USPHS INDIAN HEALTH SERVICES EXIT #102 OFF I-40 1/2 MILE SOUTH SAN FIDEL NM 87049 CIBOLA (505) 552-5300 Acute Care Hospitals Government - Federal TRUE 35.1838274 -101.9279458 1 ROOFTOP 375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-j82y-frp9~f9kp 320070 647921 2019-05-08 2018-09-30 6           6               6
4 4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
5 5 SEYMOUR HOSPITAL 200 STADIUM DRIVE SEYMOUR TX 76380 BAYLOR (940) 889-5572 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5897880 -99.2476970 0   23 48 48023         https://data.medicare.gov/resource/xubh-q36u/row-q4ba-nup8_2wqc 450586 659539 2019-11-20 2019-06-30 27           27               27
9 9 NORTH SHORE HEALTH 515 5TH AVE WEST GRAND MARAIS MN 55604 COOK (218) 387-3040 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7567440 -90.3401790 0   31 27 27031         https://data.medicare.gov/resource/xubh-q36u/row-kcfv-qat3~9wit 241317 649272 2019-05-28 2018-12-31 16           16       37       53
32 32 SHARE MEDICAL CENTER 800 SHARE DRIVE ALVA OK 73717 WOODS (580) 327-2800 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7869690 -98.6700230 0   151 40 40151         https://data.medicare.gov/resource/xubh-q36u/row-gzmq-89k6~9n3d 371341 659863 2019-11-25 2019-06-30 25           25         80     105
37 37 PRATTVILLE BAPTIST HOSPITAL 124 S MEMORIAL DR PRATTVILLE AL 36067 AUTAUGA (334) 361-4267 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4644230 -86.4509360 0   1 1 1001 33860   Central Autauga County https://data.medicare.gov/resource/xubh-q36u/row-62jx-izkm-znx2 10108 660906 2019-12-04 2019-06-30 49 6         55               55
48 48 WASHINGTON HOSPITAL 2000 MOWRY AVE FREMONT CA 94538 ALAMEDA (510) 797-1111 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.5576530 -121.9808700 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-c4xt~2fw2_qi36 50195 659475 2019-11-21 2019-06-30 268 52         320               320
49 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 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
52 52 HIGHLAND HOSPITAL 1411 EAST 31ST STREET OAKLAND CA 94602 ALAMEDA (510) 437-4800 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7992340 -122.2311990 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-j4fu_u24q~7stg 50320 662161 2019-11-27 2019-06-30 137 24         169 69 25   109       372
60 60 UNIVERSITY OF COLORADO HOSPITAL AUTHORITY 12605 E 16TH AVE AURORA CO 80045 ADAMS (720) 848-0000 Acute Care Hospitals Government - Hospital District or Authority TRUE 39.7413640 -104.8412750 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-sx7w-4iik_kiyq 60024 659482 2019-11-25 2019-06-30 432 101   19 24 50 650   12           662
78 78 APPLING HOSPITAL 163 E TOLLISON STREET BAXLEY GA 31513 APPLING (912) 367-9841 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.7687680 -82.3493510 0   1 13 13001         https://data.medicare.gov/resource/xubh-q36u/row-j4qq-twpw~u8jw 110071 658240 2019-03-29 2018-08-31 31 3         34 30     101       165
90 90 T J HEALTH COLUMBIA 901 WESTLAKE DRIVE COLUMBIA KY 42728 ADAIR (270) 384-4753 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.0962890 -85.2949400 0   1 21 21001         https://data.medicare.gov/resource/xubh-q36u/row-7iis-x23i.zsak 180149 640382 2018-12-31 2018-09-30 49           49 20             69
91 91 ACADIA ST LANDRY 810 SOUTH BROADWAY STREET CHURCH POINT LA 70525 ACADIA (337) 684-5435 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.3950170 -92.2118330 0   1 22 22001 29180 Lafayette-Opelousas-Morgan City, LA Outlying Acadia Parish https://data.medicare.gov/resource/xubh-q36u/row-mqb2~y9xg-useh 191319 661189 2019-12-05 2019-06-30 15           15 10             25
101 101 BARRETT HOSPITAL & HEALTHCARE 600 MT HWY 91 S DILLON MT 59725 BEAVERHEAD (406) 683-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.2006540 -112.6460030 0   1 30 30001         https://data.medicare.gov/resource/xubh-q36u/row-2tkn_v7av-d2ep 271318 662223 2019-11-27 2019-06-30 18           18               18
125 125 MILFORD VALLEY MEMORIAL HOSPITAL 850 NORTH MAIN STREET MILFORD UT 84751 BEAVER (435) 387-2411 Critical Access Hospitals Government - Hospital District or Authority FALSE 38.4073080 -113.0095430 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-iet4.f5zs.batz 461305 648782 2019-05-29 2018-12-31 5           5           18   23
128 128 OTHELLO COMMUNITY HOSPITAL 315 NORTH 14TH AVENUE OTHELLO WA 99344 ADAMS (509) 488-2636 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.8303630 -119.1543630 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-5z56.vhnt-5g9t 501318 658624 2019-11-12 2018-12-31 16           16               16
129 129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
132 132 IVINSON MEMORIAL HOSPITAL 255 N 30TH LARAMIE WY 82072 ALBANY (307) 755-4600 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.3113900 -105.5575120 0   1 56 56001 29660   Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-ptq5-c827_j29e 530025 660342 2019-12-03 2019-06-30 62 4         66 10     10       86
139 139 NORTHERN COCHISE COMMUNITY HOSPITAL, INC. 901 WEST REX ALLEN DRIVE WILLCOX AZ 85643 COCHISE (520) 384-3541 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2642680 -109.8376130 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ydad~45b6.8t7t 31302 660487 2019-12-02 2019-06-30 24           24       24       48
174 174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
244 244 PERMIAN REGIONAL MEDICAL CENTER ANDREWS COUNTY HO 720 HOSPITAL DRIVE ANDREWS TX 79714 ANDREWS (432) 523-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3374240 -102.5468660 0   3 48 48003 11380   Central Andrews County https://data.medicare.gov/resource/xubh-q36u/row-juik.55wn.c6fd 450144 643151 2019-02-12 2018-09-30 30           30               30
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
253 253 SOUTH BIG HORN COUNTY CRITICAL ACCESS HOSPITAL 388 US HIGHWAY 20 SOUTH BASIN WY 82410 BIG HORN (307) 568-1500 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4344490 -108.0490070 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-vp99_bama.8nds 531301 661691 2019-11-29 2019-06-30 10           10       37       47
254 254 MEDICAL CENTER BARBOUR 820 W WASHINGTON ST EUFAULA AL 36027 BARBOUR (334) 688-7271 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.8879800 -85.1566130 0   5 1 1005         https://data.medicare.gov/resource/xubh-q36u/row-b9cj~n2ap_7hxj 10069 651152 2019-05-30 2018-12-31 25 5         30 17             47
257 257 PAGE HOSPITAL 501 NORTH NAVAJO DRIVE PAGE AZ 86040 COCONINO (928) 645-2424 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.9169600 -111.4631860 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 31304 649070 2019-06-03 2018-12-31 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
);