hospital_data
Data source: Big Local News · About: big-local-datasette
35 rows where hospital_type = "Acute Care - Department of Defense"
This data as json, copyable, CSV (advanced)
Suggested facets: emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, csatitle, centraloutlyingcounty
state ✖
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 |
Advanced export
JSON shape: default, array, newline-delimited
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 );