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 acute_beds 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
158 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                              
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                                      
191 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                              
234 234 CHILDREN'S HOME OF PITTSBURGH 5324 PENN AVENUE PITTSBURGH PA 15224 ALLEGHENY (412) 441-4884 Childrens Voluntary non-profit - Private FALSE 40.4646370 -79.9376420 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-7vky_uvyh~58pt 393304 659723 2019-10-01 2019-06-30                              
342 342 ADVENTIST HEALTH FEATHER RIVER 5974 PENTZ ROAD PARADISE CA 95969 BUTTE (530) 877-9361 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7561610 -121.5723050 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-dx3c~3bgg.9vjq 50225 659201 2019-05-31 2018-12-31                              
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                                      
560 560 HACIENDA CHILDREN'S HOSPITAL, INC. 610 WEST JEROME AVENUE MESA AZ 85210 MARICOPA (602) 243-4231 Childrens Proprietary FALSE 33.3811280 -111.8448920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-r4wv.uiyn_d6cn 33303 654954 2018-11-26 2018-07-31                              
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                                      
612 612 SHRINERS' HOSPITAL FOR CHILDREN (THE) 516 CAREW STREET SPRINGFIELD MA 1104 HAMPDEN (413) 787-2000 Childrens Voluntary non-profit - Private FALSE 42.1205580 -72.5915680 0   13 25 25013 44140 Springfield-Greenfield Town, MA Central Hampden County https://data.medicare.gov/resource/xubh-q36u/row-xahc-ecbk~n8v6 223303 652750 2019-05-30 2018-12-31                              
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                                      
656 656 HALQUIST MEMORIAL INPATIENT CENTER 4715 NORTH 15 STREET ARLINGTON VA 22205 ARLINGTON (703) 525-7070 Acute Care Hospitals Voluntary non-profit - Private FALSE 38.8879410 -77.1216690 0   13 51 51013 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Arlington County https://data.medicare.gov/resource/xubh-q36u/row-vmzf.p4zi.8e5f 490129 651083 2019-06-03 2018-12-31                         36   36
739 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                              
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                                      
1011 1011 SHRINERS' HOSPITAL FOR CHILDREN - BOSTON, THE 51 BLOSSOM STREET BOSTON MA 2114 SUFFOLK (617) 722-3000 Childrens Proprietary FALSE 42.3630790 -71.0669040 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-pfzw.md7z-rufe 223304 652751 2019-05-30 2018-12-31                              
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                                      
1055 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                              
1097 1097 J D MCCARTY CENTER FOR CHILDREN 2002 EAST ROBINSON NORMAN OK 73071 CLEVELAND (405) 307-2800 Childrens Government - State FALSE 35.2327430 -97.4100160 0   27 40 40027 36420 Oklahoma City-Shawnee, OK Central Cleveland County https://data.medicare.gov/resource/xubh-q36u/row-whuu_e32b-w4sk 373300 655813 2019-10-07 2019-06-30                              
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                                      
1223 1223 SHRINERS HOSPITAL FOR CHILDREN 2211 NORTH OAK PARK AVE CHICAGO IL 60707 COOK (773) 622-5400 Childrens Voluntary non-profit - Private FALSE 41.9167660 -87.7949900 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-4p3m.ksch.3kbj 143302 652647 2019-05-30 2018-12-31                              
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                                      
1409 1409 CLEVELAND CLINIC CHILDREN'S HOSPITAL FOR REHAB 2801 MARTIN LUTHER KING, JR DRIVE CLEVELAND OH 44104 CUYAHOGA (216) 721-6400 Childrens Voluntary non-profit - Private FALSE 41.4827760 -81.6092520 0   35 39 39035 17460 Cleveland-Akron-Canton, OH Central Cuyahoga County https://data.medicare.gov/resource/xubh-q36u/row-hdmr_eyjs_ypqz 363304 651134 2019-05-29 2018-12-31                              
1441 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                              
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                                      
1501 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 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                              
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                                      
1761 1761 SHRINERS HOSPITALS FOR CHILDREN 950 WEST FARIS ROAD GREENVILLE SC 29605 GREENVILLE (864) 271-3444 Childrens Voluntary non-profit - Private FALSE 34.8160620 -82.4129680 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-zu5m.xbpi~47ak 423300 652674 2019-05-30 2018-12-31                              
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                                      
1921 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                              
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                                      
1979 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                              
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                                      
2054 2054 SHRINERS HOSPITALS FOR CHILDREN-TAMPA 12502 USF PINE DR TAMPA FL 33612 HILLSBOROUGH (813) 972-2250 Childrens Voluntary non-profit - Other FALSE 28.0603710 -82.4229680 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-u3s8~6bbc_882j 103303 659465 2019-05-30 2018-12-31                              
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                                      
2113 2113 CHILDREN'S HOSPITAL AT MISSION 27700 MEDICAL CENTER RD, 5TH FLOOR MISSION VIEJO CA 92691 ORANGE (949) 365-2408 Childrens Voluntary non-profit - Private TRUE 33.5610153 -117.6653937 1 ROOFTOP 59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-ux4n.c7cr-d5uw 53306 659086 2018-11-30 2018-06-30                              
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                                      
2208 2208 ROCKEFELLER UNIVERSITY HOSPITAL 1230 YORK AVENUE NEW YORK NY 10021 NEW YORK (212) 570-8000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.7630490 -73.9565350 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-885m-j6aw~dtmp 330387 652152 2019-05-28 2018-12-31                              
2214 2214 SHRINERS HOSPITALS FOR CHILDREN - CINCINNATI 3229 BURNETT AVENUE CINCINNATI OH 45229 HAMILTON (513) 872-6000 Childrens Voluntary non-profit - Private FALSE 39.1376950 -84.5007550 0   61 39 39061 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-qcvj~zayq~x396 363308 650516 2019-05-29 2018-12-31                              
2274 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                              
2333 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                              
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                                      
2731 2731 HOSPITAL GENERAL DE CASTANER CARR 135 KM 64 2 CASTANER PR 631 LARES (787) 829-5010 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.1810502 -66.8331137 1 GEOMETRIC_CENTER 81 72 72081 10380   Central Lares Municipio https://data.medicare.gov/resource/xubh-q36u/row-vfcv~b9rk-xwf7 400010 647686 2019-03-05 2018-09-30                              
2758 2758 THE BURDETT CARE CENTER 2215 BURDETT AVE TROY NY 12180 RENSSELAER (518) 271-3655 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.7333950 -73.6714340 0   83 36 36083 10580 Albany-Schenectady, NY Central Rensselaer County https://data.medicare.gov/resource/xubh-q36u/row-iwvg_hz45~632y 330409 652891 2019-07-03 2018-12-31                              
2864 2864 HELEN HAYES HOSPITAL 51 NORTH ROUTE 9W WEST HAVERSTRAW NY 10993 ROCKLAND (845) 786-4000 Acute Care Hospitals Government - Local FALSE 41.2127790 -73.9857680 0   87 36 36087 35620 New York-Newark, NY-NJ-CT-PA Central Rockland County https://data.medicare.gov/resource/xubh-q36u/row-ye8c.wrcw~884k 330405 653449 2019-09-06 2019-03-31                 106   49       155
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                                      
3019 3019 EAST TENNESSEE CHILDRENS HOSPITAL 2018 CLINCH AVE SW KNOXVILLE TN 37916 KNOX (865) 541-8000 Childrens Voluntary non-profit - Private TRUE 35.9565290 -83.9379200 0   93 47 47093 28940 Knoxville-Morristown-Sevierville, TN Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-ni29-9izu-5p54 443303 660315 2019-11-27 2019-06-30                              
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                                      
3092 3092 LAKE BEHAVIORAL HOSPITAL 2615 W WASHINGTON ST WAUKEGAN IL 60085 LAKE (847) 249-3900 Acute Care Hospitals Proprietary TRUE 42.3594020 -87.8666050 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-t57b.6rbp-musy 140033 654119 2019-09-04 2019-03-31               46             46
3180 3180 LIFESCAPE 2501 W 26TH ST SIOUX FALLS SD 57105 MINNEHAHA (605) 444-9500 Childrens Voluntary non-profit - Private FALSE 43.5294580 -96.7562080 0   99 46 46099 43620   Central Minnehaha County https://data.medicare.gov/resource/xubh-q36u/row-iuzk-vbys_y5he 433300 654864 2018-11-19 2018-06-30                              
3238 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                              
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                                      
3508 3508 TEXAS SCOTTISH RITE HOSPITAL FOR CHILDREN 2222 WELBORN STREET DALLAS TX 75219 DALLAS (214) 559-5000 Childrens Voluntary non-profit - Private FALSE 32.8032510 -96.8133570 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-ks6w_wivi.sen3 453314 645801 2019-02-26 2018-09-30                              
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                                      
3609 3609 BLYTHEDALE CHILDREN'S HOSPITAL 95 BRADHURST AVENUE VALHALLA NY 10595 WESTCHESTER (914) 592-7555 Childrens Voluntary non-profit - Private FALSE 41.0931410 -73.8019980 0   119 36 36119 35620 New York-Newark, NY-NJ-CT-PA Central Westchester County https://data.medicare.gov/resource/xubh-q36u/row-62dd~iivi-vf6j 333301 652661 2019-05-31 2018-12-31                              
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                                      
3765 3765 ADMIN DE SERVICIOS MEDICOS PUERTO RIC BO MONACILLO CARR NUM 22 SAN JUAN PR 935 SAN JUAN (787) 777-3535 Acute Care Hospitals Government - Local TRUE 18.4500000 -66.0600000 1 APPROXIMATE 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-gchu_zjdy_292t 400127 660877 2019-11-27 2019-06-30   68         68               68
3766 3766 UNIVERSITY PEDIATRIC HOSPITAL PUERTO RICO MEDICAL CENTER IN RIO PIEDRAS SAN JUAN PR 935 SAN JUAN (787) 777-3232 Childrens Government - State TRUE 18.3958646 -66.0736306 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-aat9~yvnm_fjvd 403301 640173 2018-11-30 2018-06-30                              
3771 3771 SAN JORGE CHILDRENS HOSPITAL INC 258 SAN JORGE STREET SAN JUAN PR 912 SAN JUAN (787) 727-1000 Acute Care Hospitals Proprietary TRUE 18.4468796 -66.0630394 1 ROOFTOP 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-6qba~ryfi~pqaw 400134 659466 2019-05-01 2018-12-31                              
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                                      
4106 4106 ST JUDE CHILDRENS RESEARCH HOSPITAL 262 DANNY THOMAS PLACE MEMPHIS TN 38105 SHELBY (901) 495-3300 Childrens Voluntary non-profit - Private FALSE 35.1545600 -90.0425300 0   157 47 47157 32820 Memphis-Forrest City, TN-MS-AR Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-8bmc~acqt~mywf 443302 662074 2019-12-02 2019-06-30                              
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                                      
4432 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                              
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                                      
4729 4729 SHRINERS HOSPITALS FOR CHILDREN 4400 CLAYTON AVE SAINT LOUIS MO 63110 ST. LOUIS CITY (314) 432-3600 Childrens Voluntary non-profit - Private FALSE 38.6329890 -90.2578210 0   510 29 29510 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis city https://data.medicare.gov/resource/xubh-q36u/row-wpna.jm3m.trsh 263304 649794 2019-05-30 2018-12-31                              
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                                      
4759 4759 CHILDREN'S HOSP OF RICHMOND OF THE VCU HEALTH SYS 2924 BROOK ROAD RICHMOND VA 23220 RICHMOND CITY (804) 321-7474 Childrens Voluntary non-profit - Private FALSE 37.5702610 -77.4492070 0   760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-3rgk-iaha-6s92 493302 660060 2019-11-26 2019-06-30                              
3032 3032 ADVENTHEALTH ORLANDO 601 E ROLLINS ST ORLANDO FL 32803 ORANGE (407) 303-1976 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.5734570 -81.3703280 0   95 12 12095 36740 Orlando-Deltona-Daytona Beach, FL Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-4fra_j2em.99x3 100007 648798 2019-05-22 2018-12-31 2256 221 40       2753 43 30           2826
2203 2203 NEW YORK-PRESBYTERIAN HOSPITAL-NEW YORK WEILL CORN 525 EAST 68TH STREET NEW YORK NY 10065 NEW YORK (212) 746-5454 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7641500 -73.9543350 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-fniq-8g6c~arqm 330101 650861 2019-06-03 2018-12-31 1792 198 44     146 2272 340 38           2650

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