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

3,280 rows where hospital_type = "Acute Care Hospitals" sorted by acute_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, burn_beds, subprovider_oth_beds, nursing_fac_beds, filed_date (date), fy_end_date (date)

hospital_type ✖

  • Acute Care Hospitals · 3,280 ✖
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
1888 1888 LEVI HOSPITAL 300 PROSPECT AVE HOT SPRINGS AR 71901 GARLAND (501) 624-1281 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5099450 -93.0566490 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-assk.a57a-njvy 40132 649865 2019-05-24 2018-12-31 1           1 52             53
1593 1593 EDWARD MCCREADY MEMORIAL HOSPITAL 201 HALL HIGHWAY CRISFIELD MD 21817 SOMERSET (410) 726-9496 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9960110 -75.8523660 0   39 24 24039 41540   Outlying Somerset County https://data.medicare.gov/resource/xubh-q36u/row-cmnn-hhsq~qwjh 210045 657148 2019-11-07 2019-06-30 3           3               3
637 637 WESTFIELD MEMORIAL HOSPITAL, INC 189 EAST MAIN STREET WESTFIELD NY 14787 CHAUTAUQUA (716) 326-4921 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3279010 -79.5693970 0   13 36 36013 27460   Central Chautauqua County https://data.medicare.gov/resource/xubh-q36u/row-vwk8~gn4h~53q8 330166 650743 2019-05-31 2018-12-31 4           4               4
1279 1279 BIG SKY MEDICAL CENTER 334 TOWN CENTER AVE BIG SKY MT 59716 GALLATIN (406) 995-6995 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.2608000 -111.3007380 0   31 30 30031 14580   Central Gallatin County https://data.medicare.gov/resource/xubh-q36u/row-ibsg~9p6y.87cb 270089 655563 2019-10-17 2019-05-16 4           4               4
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
1978 1978 HIRAM W DAVIS MEDICAL CENTER P O BOX 4030 PETERSBURG VA 23803 PETERSBURG CITY (804) 524-7344 Acute Care Hospitals Government - State FALSE 37.2098658 -77.4509355 1 ROOFTOP 53 51 51053 40060   Central Dinwiddie County https://data.medicare.gov/resource/xubh-q36u/row-xvn2.38q5-2xg5 490104 661117 2019-11-27 2019-06-30 4           4       50 30 277   361
3233 3233 WILLS EYE HOSPITAL 840 WALNUT STREET PHILADELPHIA PA 19107 PHILADELPHIA (215) 440-3100 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9482710 -75.1557000 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-nxn5~vwjj_bn3j 390331 660449 2019-12-03 2019-06-30 4           4               4
3581 3581 MAYHILL HOSPITAL 2809 SOUTH MAYHILL ROAD DENTON TX 76208 DENTON (940) 239-3000 Acute Care Hospitals Proprietary FALSE 33.1758420 -97.0882930 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-m8he-msb6~66b2 670010 647842 2019-05-15 2018-12-31 4           4 55             59
4424 4424 AD HOSPITAL EAST, LLC 12950 EAST FREEWAY, SUITE 100 HOUSTON TX 77015 HARRIS (713) 330-3897 Acute Care Hospitals Proprietary TRUE 29.7711360 -95.2007820 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-g9pj_7cms.hams 670102 649155 2019-05-30 2018-12-31 4           4               4
2027 2027 MONROE COMMUNITY HOSPITAL 435 EAST HENRIETTA ROAD ROCHESTER NY 14620 MONROE (585) 760-6500 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.1118560 -77.6160780 0   55 36 36055 40380 Rochester-Batavia-Seneca Falls, NY Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-5bf3_hk4u~74wb 330403 651037 2019-06-03 2018-12-31 5           5       566       571
414 414 CONNECTICUT HOSPICE INC,THE 100 DOUBLE BEACH ROAD BRANFORD CT 6405 NEW HAVEN (203) 315-7500 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.2563050 -72.8333670 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-9pw4-ddrr.eyyi 70038 645241 2019-03-01 2018-09-30 6           6           46   52
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
2557 2557 LAGUNA HONDA HOSPITAL & REHABILITATION CENTER 375 LAGUNA HONDA BLVD SAN FRANCISCO CA 94116 SAN FRANCISCO (415) 759-2300 Acute Care Hospitals Government - Local FALSE 37.7478240 -122.4586360 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-tz44~vi64-ys8h 50668 662169 2019-12-02 2019-06-30 6           6   5   769       780
3290 3290 SAME DAY SURGERY CENTER LLC 651 CATHEDRAL DRIVE RAPID CITY SD 57701 PENNINGTON (605) 755-9900 Acute Care Hospitals Proprietary FALSE 44.0591900 -103.2291020 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-9hcp~bs9i-drqz 430093 658957 2019-11-18 2019-06-30 6           6               6
4116 4116 SUGAR LAND SURGICAL HOSPITAL LLP 16906 SOUTHWEST FREEWAY SUGAR LAND TX 77479 FORT BEND (281) 243-1000 Acute Care Hospitals Physician TRUE 29.5906090 -95.6366960 0   157 48 48157 26420 Houston-The Woodlands, TX Central Fort Bend County https://data.medicare.gov/resource/xubh-q36u/row-9avs-knbp-aret 450860 651075 2019-06-21 2018-12-31 6           6               6
4587 4587 ASPIRE BEHAVIORAL HEALTH OF CONROE, LLC 2006 SOUTH LOOP 336 WEST, SUITE 500 CONROE TX 77304 MONTGOMERY (936) 647-3500 Acute Care Hospitals Physician FALSE 30.2840690 -95.4801310 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-h7u8.wg6t-a3vd 670093 651497 2019-05-31 2018-12-31 6           6 24             30
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
962 962 BLACK RIVER COMMUNITY MEDICAL CENTER 217 PHYSICIANS PARK DRIVE POPLAR BLUFF MO 63901 BUTLER (573) 686-6001 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7708820 -90.4564450 0   23 29 29023 38740   Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-unng~jvuf.99dx 260227 660121 2019-11-15 2019-08-11 7           7               7
2950 2950 MINIMALLY INVASIVE SURGERY HOSPITAL 11217 LAKEVIEW AVENUE LENEXA KS 66219 JOHNSON (913) 322-7401 Acute Care Hospitals Proprietary FALSE 38.9243760 -94.7697050 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-jnfx.rz75-i6pf 170199 649588 2019-06-03 2018-12-31 7       2   9               9
3938 3938 HOSPITAL METROPOLITANO DE LA MONTANA CALLE ISAAC GONZALEZ ESQUINA LEDESMA BDA NUEVA PR 641 UTUADO (787) 933-1100 Acute Care Hospitals Proprietary TRUE 18.2675675 -66.7013424 1 GEOMETRIC_CENTER 141 72 72141 10380   Central Utuado Municipio https://data.medicare.gov/resource/xubh-q36u/row-8n9a.kpfm-bvb9 400130 650777 2019-05-28 2018-12-31 7           7 40             47
3976 3976 HEALTHSOURCE SAGINAW 3340 HOSPITAL ROAD SAGINAW MI 48603 SAGINAW (989) 790-7888 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.4564180 -84.0520480 0   145 26 26145 40980 Saginaw-Midland-Bay City, MI Central Saginaw County https://data.medicare.gov/resource/xubh-q36u/row-bnbr~xrkk.p4j7 230275 650491 2019-05-31 2018-12-31 7           7 85 38   213       343
4523 4523 ANSON GENERAL HOSPITAL 101 AVENUE J ANSON TX 79501 JONES (325) 823-3231 Acute Care Hospitals Government - Local TRUE 32.7681010 -99.8955140 0   253 48 48253 10180   Outlying Jones County https://data.medicare.gov/resource/xubh-q36u/row-yt33_gjz7-gmyy 450078 653860 2019-09-03 2019-03-31 7           7           6   13
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
930 930 SETON SMITHVILLE REGIONAL HOSPITAL 1201 HILL RD SMITHVILLE TX 78957 BASTROP (512) 237-3214 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.0039505 -97.1360218 1 ROOFTOP 21 48 48021 12420   Outlying Bastrop County https://data.medicare.gov/resource/xubh-q36u/row-d2dp~cvuc~gmre 450143 659733 2019-11-25 2019-06-30 8           8               8
1624 1624 CHARLESTON SURGICAL HOSPITAL 1306 KANAWHA BOULEVARD EAST CHARLESTON WV 25301 KANAWHA (304) 343-4371 Acute Care Hospitals Physician FALSE 38.3429910 -81.6306620 0   39 54 54039 16620 Charleston-Huntington-Ashland, WV-OH-KY Central Kanawha County https://data.medicare.gov/resource/xubh-q36u/row-zfdk.i8cn~ciui 510091 650428 2019-05-31 2018-12-31 8           8               8
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
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
2867 2867 THREE GABLES SURGERY CENTER 5897 COUNTY ROAD 107 PROCTORVILLE OH 45669 LAWRENCE (740) 886-9911 Acute Care Hospitals Proprietary FALSE 38.4407480 -82.3932980 0   87 39 39087 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-9r4y.f6ba-vqwk 360261 648744 2019-05-23 2018-12-31 8           8               8
3397 3397 ONECORE HEALTH 1044 SW 44TH, SUITE 350 OKLAHOMA CITY OK 73109 OKLAHOMA (405) 631-3085 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.4207290 -97.5338680 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-zhp9.4kgr_ytfs 370220 651480 2019-05-29 2018-12-31 8           8               8
4654 4654 USMD HOSPITAL AT FORT WORTH LP 5900 ALTAMESA BLVD FORT WORTH TX 76132 TARRANT (817) 433-9100 Acute Care Hospitals Proprietary TRUE 32.6455920 -97.4181400 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-dprz_9mav_2zjv 670046 649011 2019-05-31 2018-12-31 8           8               8
4669 4669 NORTHWEST HILLS SURGICAL HOSPITAL 6818 AUSTIN CTR BLVD SUITE 100 AUSTIN TX 78731 TRAVIS (512) 346-1994 Acute Care Hospitals Proprietary TRUE 30.3503160 -97.7510260 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-ue4n.z4gb~9nnx 450808 649834 2019-05-31 2018-12-31 8           8               8
4700 4700 BAYLOR SCOTT & WHITE EMERGENCY MEDICAL CENTER AT C 900 EAST WHITESTONE BLVD CEDAR PARK TX 78613 WILLIAMSON (512) 684-4911 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.5239510 -97.8201770 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-7m75.eizi~hrs5 670087 662636 2019-12-19 2019-06-30 8           8               8
85 85 TREASURE VALLEY HOSPITAL 8800 WEST EMERALD STREET BOISE ID 83704 ADA (208) 373-5000 Acute Care Hospitals Proprietary FALSE 43.6112890 -116.2903320 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-egh2.u29a~s2jf 130063 650684 2019-05-31 2018-12-31 9           9               9
2948 2948 DOCTORS HOSPITAL LLC 4901 COLLEGE BLVD LEAWOOD KS 66211 JOHNSON (913) 529-1801 Acute Care Hospitals Proprietary FALSE 38.9274120 -94.6435000 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-g4ct-f4db-d8p3 170194 649586 2019-05-31 2018-12-31 9           9               9
3386 3386 NORTHWEST SURGICAL HOSPITAL 9204 NORTH MAY AVENUE OKLAHOMA CITY OK 73120 OKLAHOMA (405) 848-1918 Acute Care Hospitals Physician TRUE 35.5641660 -97.5671590 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-a9dt_8msh-9ahb 370192 650519 2019-05-30 2018-12-31 9           9               9
3394 3394 SUMMIT MEDICAL CENTER, LLC 1800 SOUTH RENAISSANCE BOULEVARD EDMOND OK 73013 OKLAHOMA (405) 359-2400 Acute Care Hospitals Physician TRUE 35.6355210 -97.4994350 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-4vbg.5jhj-wsm8 370225 648353 2019-05-20 2018-12-31 9           9               9
3494 3494 TEXAS INSTITUTE FOR SURGERY AT PRESBYTERIAN HOSPIT 7115 GREENVILLE AVENUE SUITE 100 DALLAS TX 75231 DALLAS (214) 647-5300 Acute Care Hospitals Proprietary TRUE 32.8763770 -96.7617260 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-zpaw~2v5b-8gcc 450889 646976 2019-04-26 2018-12-31 9           9               9
3933 3933 THE HOSPITALS OF PROVIDENCE HORIZON CITY CAMPUS 13600 HORIZON STREET, SUITE 100 HORIZON CITY TX 79928 EL PASO (915) 407-7878 Acute Care Hospitals Proprietary TRUE 31.6827230 -106.2073480 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-m5db~xjiy~dvv3 670124 649391 2019-05-30 2018-12-31 9           9               9
847 847 GUADALUPE COUNTY HOSPITAL 117 CAMINO DE VIDA, SUITE 100 SANTA ROSA NM 88435 GUADALUPE (575) 472-3417 Acute Care Hospitals Government - Local TRUE 34.9295040 -104.6942240 0   19 35 35019         https://data.medicare.gov/resource/xubh-q36u/row-es4t_p7gk_ag72 320067 661934 2019-12-17 2019-06-30 10           10               10
1691 1691 PHYSICIANS' MEDICAL CENTER LLC 4023 REAS LN NEW ALBANY IN 47150 FLOYD (812) 206-7660 Acute Care Hospitals Physician FALSE 38.3400320 -85.8270640 0   43 18 18043 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Floyd County https://data.medicare.gov/resource/xubh-q36u/row-bawj-eke8.ffq3 150172 650260 2019-06-04 2018-12-31 10           10               10
1752 1752 DILEY RIDGE MEDICAL CENTER 7911 DILEY ROAD CANAL WINCHESTER OH 43110 FRANKLIN (614) 838-7910 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8500530 -82.7811000 0   45 39 39045 18140 Columbus-Marion-Zanesville, OH Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-82cy_fgw2.yjpg 360358 660675 2019-11-26 2019-06-30 10           10               10
2008 2008 LAFAYETTE GENERAL SURGICAL HOSPITAL 1000 W PINHOOK RD SUITE 100 LAFAYETTE LA 70503 LAFAYETTE (337) 289-8095 Acute Care Hospitals Physician FALSE 30.2042530 -92.0134680 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-i7bm~9svd~q42h 190268 649248 2019-05-30 2018-12-31 10           10               10
2009 2009 PARK PLACE SURGICAL HOSPITAL 4811 AMBASSADOR CAFFERY PARKWAY LAFAYETTE LA 70508 LAFAYETTE (337) 237-8119 Acute Care Hospitals Physician FALSE 30.1497980 -92.0401140 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-pekc_yry2_bpdk 190255 649246 2019-05-30 2018-12-31 10           10               10
2532 2532 MONROE SURGICAL HOSPITAL 2408 BROADMOOR BLVD MONROE LA 71201 OUACHITA (318) 410-0002 Acute Care Hospitals Physician FALSE 32.5367710 -92.1022040 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk 190245 650140 2019-06-03 2018-12-31 10           10               10
2806 2806 EDGEWOOD SURGICAL HOSPITAL 239 EDGEWOOD DRIVE EXTENSION TRANSFER PA 16154 MERCER (724) 646-0400 Acute Care Hospitals Physician FALSE 41.3300510 -80.4178550 0   85 42 42085 49660 Youngstown-Warren, OH-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-rh2b~kawm~nsdh 390307 649489 2019-05-30 2018-12-31 10           10               10
2880 2880 PATIENTS' HOSPITAL OF REDDING 2900 EUREKA WAY REDDING CA 96001 SHASTA (530) 225-8700 Acute Care Hospitals Physician FALSE 40.5854900 -122.4162640 0   89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-5vur~pqci_pq3w 50697 650657 2019-05-31 2018-12-31 10           10               10
3268 3268 STERLING SURGICAL HOSPITAL 989 ROBERT BLVD SLIDELL LA 70458 ST. TAMMANY (504) 690-8200 Acute Care Hospitals Proprietary FALSE 30.2907800 -89.7694020 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-w5g7~ffzq.fcn6 190256 647895 2019-05-17 2018-12-31 10           10               10
3402 3402 OKLAHOMA CENTER FOR ORTHOPAEDIC & MULTI-SP 8100 SOUTH WALKER BLDG C OKLAHOMA CITY OK 73139 OKLAHOMA (405) 602-6500 Acute Care Hospitals Proprietary FALSE 35.3856890 -97.5212710 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-nigy_87dp_gajj 370212 650200 2019-06-18 2018-12-31 10           10               10
3989 3989 KINGS DAUGHTERS MEDICAL CENTER OHIO 1901 ARGONNE ROAD PORTSMOUTH OH 45662 SCIOTO (740) 991-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7473190 -82.9933540 0   145 39 39145 39020 Charleston-Huntington-Ashland, WV-OH-KY Central Scioto County https://data.medicare.gov/resource/xubh-q36u/row-3hvz~qivd_yj54 360361 644543 2019-02-28 2018-09-30 10           10               10
4077 4077 SUMMIT SURGICAL, LLC 1818 EAST 23RD AVENUE HUTCHINSON KS 67502 RENO (620) 662-6000 Acute Care Hospitals Physician FALSE 38.0795300 -97.8885950 0   155 20 20155 26740   Central Reno County https://data.medicare.gov/resource/xubh-q36u/row-rrpw.z43u-xa5d 170198 649226 2019-05-30 2018-12-31 10           10               10
4240 4240 UNICOI COUNTY HOSPITAL 2030 TEMPLE HILL ROAD ERWIN TN 37650 UNICOI (423) 743-3141 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1213650 -82.4456210 0   171 47 47171 27740 Johnson City-Kingsport-Bristol, TN-VA Outlying Unicoi County https://data.medicare.gov/resource/xubh-q36u/row-8b8j.szqj-76se 440001 649955 2019-05-28 2018-12-31 10           10       7 39     56
4588 4588 MEMORIAL HERMANN SURGICAL HOSPITAL KINGWOOD 300 KINGWOOD MEDICAL DRIVE KINGWOOD TX 77339 HARRIS (281) 312-4000 Acute Care Hospitals Proprietary TRUE 30.0471980 -95.2579490 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-v6he.gqvr.a5ws 670005 648513 2019-05-21 2018-12-31 10           10               10
396 396 CONFLUENCE HEALTH- WENATCHEE VALLEY HOSP & CLINICS 820 NORTH CHELAN AVENUE WENATCHEE WA 98801 CHELAN (509) 663-8711 Acute Care Hospitals Voluntary non-profit - Private FALSE 47.4335660 -120.3219830 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-aiqi_mn7n_vecf 500148 650791 2019-05-31 2018-12-31 11           11   9           20
221 221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
1863 1863 WOODS AT PARKSIDE,THE 349 OLDE RIDENOUR ROAD COLUMBUS OH 43230 FRANKLIN (614) 471-2552 Acute Care Hospitals Proprietary FALSE 40.0268200 -82.8811560 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-4avu~kmf5~3quj 360247 649648 2019-06-03 2018-12-31 12         38 50               50
2255 2255 JEFFERSON COUNTY HOSPITAL 870 S MAIN FAYETTE MS 39069 JEFFERSON (601) 786-3401 Acute Care Hospitals Government - Local TRUE 31.7048425 -91.0685345 1 ROOFTOP 63 28 28063         https://data.medicare.gov/resource/xubh-q36u/row-6ixf.trx6_t5pg 250060 644298 2019-03-04 2018-09-30 12           12 18             30
2341 2341 ANIMAS SURGICAL HOSPITAL, LLC 575 RIVERGATE LN DURANGO CO 81301 LA PLATA (970) 247-3537 Acute Care Hospitals Physician TRUE 37.2488890 -107.8707740 0   67 8 8067 20420   Central La Plata County https://data.medicare.gov/resource/xubh-q36u/row-twp9-b345.bypu 60117 650115 2019-05-31 2018-12-31 12           12               12
2498 2498 UAB CALLAHAN EYE HOSPITAL AUTHORITY 1720 UNIVERSITY BLVD, SUITE 500 BIRMINGHAM AL 35233 JEFFERSON (205) 325-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5031370 -86.8024010 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-txeu_r7zi.ibaa 10018 644082 2019-03-01 2018-09-30 12           12               12
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
2947 2947 KANSAS CITY ORTHOPAEDIC INSTITUTE 3651 COLLEGE BLVD LEAWOOD KS 66211 JOHNSON (913) 319-7633 Acute Care Hospitals Physician FALSE 38.9275490 -94.6282350 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-s6dg~iufq_ybuc 170188 649225 2019-05-31 2018-12-31 12           12               12
2967 2967 PHYSICIAN'S CARE SURGICAL HOSPITAL 454 ENTERPRISE DRIVE ROYERSFORD PA 19468 MONTGOMERY (610) 495-4793 Acute Care Hospitals Physician FALSE 40.2167860 -75.5537070 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-xf95-5spw~uirp 390324 646044 2019-04-01 2018-10-31 12           12               12
3399 3399 SURGICAL HOSPITAL OF OKLAHOMA, LLC 100 SOUTHEAST 59TH STREET OKLAHOMA CITY OK 73129 OKLAHOMA (405) 634-9300 Acute Care Hospitals Physician TRUE 35.4062250 -97.5093160 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-drs8-u5z4.yfq6 370201 649812 2019-05-31 2018-12-31 12           12               12
4302 4302 BAYLOR SCOTT AND WHITE SURGICAL HOSPITAL AT SHERMA 3601 CALAIS DRIVE SHERMAN TX 75090 GRAYSON (903) 813-3728 Acute Care Hospitals Physician TRUE 33.6768600 -96.6025270 0   181 48 48181 43300 Dallas-Fort Worth, TX-OK Central Grayson County https://data.medicare.gov/resource/xubh-q36u/row-4y3f.tmsq.cez5 670076 648878 2019-05-28 2018-12-31 12           12               12
4426 4426 FIRST TEXAS HOSPITAL 9922 LOUETTA RD HOUSTON TX 77070 HARRIS (844) 264-1435 Acute Care Hospitals Proprietary TRUE 30.0008390 -95.5608680 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-t68p~4ggy.94di 670118 649157 2019-05-30 2018-12-31 12           12               12
1450 1450 OAKLEAF SURGICAL HOSPITAL 1000 OAKLEAF WAY ALTOONA WI 54720 EAU CLAIRE (715) 831-8130 Acute Care Hospitals Physician FALSE 44.8150020 -91.4517640 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-4tiq~2hj5~t8xv 520196 650624 2019-05-30 2018-12-31 13           13               13
1502 1502 WEST COVINA MEDICAL CENTER, INC 725 S ORANGE AVE WEST COVINA CA 91790 LOS ANGELES (626) 338-8481 Acute Care Hospitals Proprietary FALSE 34.0709280 -117.9441660 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-mrqt_jczt_crz9 50096 652580 2019-05-30 2018-12-31 13           13       33       46
3080 3080 SONOMA DEVELOPMENTAL CENTER 15000 ARNOLD DRIVE / P O BOX 1493 ELDRIDGE CA 95431 SONOMA (707) 938-6000 Acute Care Hospitals Government - State FALSE 38.3490270 -122.5169100 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-j6wx.73xx-wqrm 50547 638175 2018-11-27 2018-06-30 13           13           963   976
3165 3165 SOUTHEAST MICHIGAN SURGICAL HOSPITAL 21230 DEQUINDRE ROAD WARREN MI 48091 MACOMB (586) 427-1000 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.4513950 -83.0835600 0   99 26 26099 19820 Detroit-Warren-Ann Arbor, MI Central Macomb County https://data.medicare.gov/resource/xubh-q36u/row-n5cw~k8mz~eeh4 230264 650280 2019-06-03 2018-12-31 13           13               13
4135 4135 MANHATTAN SURGICAL HOSPITAL LLC 1829 COLLEGE AVENUE MANHATTAN KS 66502 RILEY (785) 776-5100 Acute Care Hospitals Physician FALSE 39.2028260 -96.5981830 0   161 20 20161 31740 Manhattan-Junction City, KS Central Riley County https://data.medicare.gov/resource/xubh-q36u/row-5vw9~wxt5.eejp 170190 648618 2019-05-24 2018-12-31 13           13               13
800 800 SELLS HOSPITAL HIGHWAY 86, AT TOPAWA ROAD SELLS AZ 85634 PIMA (520) 362-7003 Acute Care Hospitals Tribal TRUE 31.9183549 -111.8792747 1 GEOMETRIC_CENTER 19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-57e8_mqp9-5x9d 30074 651599 2019-07-10 2018-09-30 14           14               14
3191 3191 SUTTER SURGICAL HOSPITAL - NORTH VALLEY 455 PLUMAS BLVD YUBA CITY CA 95991 SUTTER (530) 749-5700 Acute Care Hospitals Physician FALSE 39.1321670 -121.6136030 0   101 6 6101 49700 Sacramento-Roseville, CA Central Sutter County https://data.medicare.gov/resource/xubh-q36u/row-rm5f.jnvd.d3k4 50766 651185 2019-06-03 2018-12-31 14           14               14
3225 3225 KENSINGTON HOSPITAL 136 W DIAMOND STREET PHILADELPHIA PA 19122 PHILADELPHIA (215) 426-8100 Acute Care Hospitals Voluntary non-profit - Other FALSE 39.9817591 -75.1347791 1 ROOFTOP 101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-jdjh_ypv5.y5gj 390025 660289 2019-12-02 2019-06-30 14           14               14
3730 3730 ADVANCED SURGICAL HOSPITAL 100 TRICH DRIVE WASHINGTON PA 15301 WASHINGTON (724) 884-0710 Acute Care Hospitals Physician FALSE 40.1567230 -80.2805360 0   125 42 42125 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ni2v.da26_jxgn 390323 648978 2019-05-29 2018-12-31 14           14               14
4013 4013 STARKE HOSPITAL 102 E CULVER RD KNOX IN 46534 STARKE (574) 772-1102 Acute Care Hospitals Proprietary TRUE 41.2880640 -86.6219370 0   149 18 18149         https://data.medicare.gov/resource/xubh-q36u/row-4bwp-v7bt.62f6 150102 649569 2019-06-03 2018-12-31 14 1         15               15
4125 4125 WINSTON MEDICAL CENTER & SWINGBED 17550 EAST MAIN STREET LOUISVILLE MS 39339 WINSTON (662) 779-5124 Acute Care Hospitals Proprietary TRUE 33.1242910 -89.0366710 0   159 28 28159         https://data.medicare.gov/resource/xubh-q36u/row-rwwj.hj8g_k82s 250027 649619 2019-05-29 2018-12-31 14           14 10     120       144
4413 4413 ALTUS BAYTOWN HOSPITAL 1404 W BAKER ROAD BAYTOWN TX 77521 HARRIS (281) 837-7600 Acute Care Hospitals Physician TRUE 29.7698160 -94.9801930 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-fa96~fa82_gfbn 670109 650629 2019-06-04 2018-12-31 14           14               14
4474 4474 CORNERSTONE REGIONAL HOSPITAL 2302 CORNERSTONE BOULEVARD EDINBURG TX 78539 HIDALGO (956) 618-4444 Acute Care Hospitals Proprietary TRUE 26.2630960 -98.1991640 0   215 48 48215 32580 McAllen-Edinburg, TX Central Hidalgo County https://data.medicare.gov/resource/xubh-q36u/row-wtje.zqmn.bcn4 450825 649141 2019-05-28 2018-12-31 14           14               14
4629 4629 STEPHENS MEMORIAL HOSPITAL 200 SOUTH GENEVA STREET BRECKENRIDGE TX 76424 STEPHENS (254) 559-2241 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7540560 -98.8877190 0   429 48 48429         https://data.medicare.gov/resource/xubh-q36u/row-f2c3_a9xb.afpq 450498 643739 2019-02-27 2018-09-30 14           14               14
376 376 ATRIUM HEALTH ANSON 2301 US HIGHWAY 74 WEST WADESBORO NC 28170 ANSON (704) 694-5131 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9785320 -80.1096790 0   7 37 37007         https://data.medicare.gov/resource/xubh-q36u/row-mv5j_iuia_xbie 340084 650339 2019-05-30 2018-12-31 15           15               15
533 533 SURGICAL INSTITUTE OF READING 2752 CENTURY BOULEVARD WYOMISSING PA 19610 BERKS (717) 999-9999 Acute Care Hospitals Proprietary FALSE 40.3579510 -75.9875770 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-3aqm~vs6z.7ify 390316 651482 2019-06-25 2018-12-31 15           15               15
740 740 SPECIALISTS HOSPITAL SHREVEPORT 1500 LINE AVENUE SHREVEPORT LA 71101 CADDO (318) 213-3800 Acute Care Hospitals Physician FALSE 32.4969260 -93.7460460 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-kr9t-dd8q-wfhi 190278 649901 2019-06-03 2018-12-31 15           15               15
1141 1141 UMD SHORE MEDICAL CTR AT CHESTERTOWN 100 BROWN STREET CHESTERTOWN MD 21620 KENT (410) 778-7668 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2168450 -76.0644920 0   29 24 24029         https://data.medicare.gov/resource/xubh-q36u/row-9gun.f2aw-guni 210030 660229 2019-12-02 2019-06-30 15 6         21               21
3213 3213 IRA DAVENPORT MEMORIAL HOSPITAL, INC 7571 STATE ROUTE 54 BATH NY 14810 STEUBEN (607) 776-8500 Acute Care Hospitals Voluntary non-profit - Other FALSE 42.3729700 -77.2785530 0   101 36 36101 18500 Elmira-Corning, NY Central Steuben County https://data.medicare.gov/resource/xubh-q36u/row-wide.txin.tuvc 330144 649631 2019-05-29 2018-12-31 15           15       120       135
3215 3215 ST JAMES MERCY HOSPITAL 411 CANISTEO STREET HORNELL NY 14843 STEUBEN (607) 324-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.3145750 -77.6601420 0   101 36 36101 18500 Elmira-Corning, NY Central Steuben County https://data.medicare.gov/resource/xubh-q36u/row-584q-nx3f-g76t 330151 650302 2019-05-31 2018-12-31 15           15               15
3503 3503 PINE CREEK MEDICAL CENTER LLP 9032 HARRY HINES BLVD DALLAS TX 75235 DALLAS (214) 231-2273 Acute Care Hospitals Proprietary TRUE 32.8401610 -96.8688350 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yjax~idz9_awg3 450894 648768 2019-05-24 2018-12-31 15           15               15
4423 4423 MEMORIAL HERMANN FIRST COLONY HOSPITAL 24429 TOMBALL PARKWAY, SUITE 100 TOMBALL TX 77375 HARRIS (281) 516-0911 Acute Care Hospitals Proprietary FALSE 30.0371760 -95.6053230 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-wtak~qp2w~qmyj 670095 649016 2019-05-30 2018-12-31 15           15               15
4464 4464 HEMPHILL COUNTY HOSPITAL 1020 S 4TH ST CANADIAN TX 79014 HEMPHILL (806) 323-6622 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.9037920 -100.3873990 0   211 48 48211         https://data.medicare.gov/resource/xubh-q36u/row-86yy_5s2m-up8r 450578 646584 2019-04-17 2018-09-30 15           15           2   17
246 246 BEAR RIVER VALLEY HOSPITAL 905 NORTH 1000 WEST TREMONTON UT 84337 BOX ELDER (435) 207-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7237680 -112.1819790 0   3 49 49003 36260 Salt Lake City-Provo-Orem, UT Central Box Elder County https://data.medicare.gov/resource/xubh-q36u/row-dbs5_2pqd_mjjc 460039 647593 2019-05-10 2018-12-31 16           16               16
575 575 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL 7171 SOUTH 51ST AVENUE LAVEEN AZ 85339 MARICOPA (623) 584-5100 Acute Care Hospitals Proprietary FALSE 33.3806770 -112.1682330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6h9g-s46a~aiyi 30136 651169 2019-06-03 2018-12-31 16           16               16
1326 1326 SURGICAL SPECIALTY CENTER OF BATON ROUGE 8080 BLUEBONNET BLVD BATON ROUGE LA 70810 E. BATON ROUGE (225) 408-8080 Acute Care Hospitals Physician FALSE 30.3765650 -91.0993330 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-vta2_xzya~pwww 190251 648928 2019-05-31 2018-12-31 16           16               16
1673 1673 PHYSICIANS CENTRE,THE 3131 UNIVERSITY DRIVE EAST BRYAN TX 77802 BRAZOS (979) 731-3100 Acute Care Hospitals Proprietary TRUE 30.6495850 -96.2965150 0   41 48 48041 17780   Central Brazos County https://data.medicare.gov/resource/xubh-q36u/row-hv3y_nxcx-fin2 450834 649964 2019-05-31 2018-12-31 16           16               16
1905 1905 OMEGA HOSPITAL, LLC 2525 SEVERN AVENUE METAIRIE LA 70002 JEFFERSON (504) 849-4900 Acute Care Hospitals Proprietary FALSE 29.9991620 -90.1595830 0   51 22 22051 35380 New Orleans-Metairie-Hammond, LA-MS Central Jefferson Parish https://data.medicare.gov/resource/xubh-q36u/row-fybn~uix6_hmgd 190302 649030 2019-06-03 2018-12-31 16           16               16
2198 2198 N Y EYE AND EAR INFIRMARY 230 SECOND AVE NEW YORK NY 10003 NEW YORK (212) 979-4000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.7325590 -73.9848160 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-5i5y_hgy2_5sdf 330100 650192 2019-06-14 2018-12-31 16           16               16
2673 2673 MIDWEST ORTHOPEDIC SPECIALTY HOSPITAL 10101 SOUTH 27TH ST 2ND FLOOR FRANKLIN WI 53132 MILWAUKEE (414) 817-5800 Acute Care Hospitals Physician FALSE 42.8601290 -87.9517230 0   79 55 55079 33340 Milwaukee-Racine-Waukesha, WI Central Milwaukee County https://data.medicare.gov/resource/xubh-q36u/row-vd6g-bsfm.ynmv 520205 647206 2019-05-01 2018-12-31 16           16               16
2687 2687 MENLO PARK SURGICAL HOSPITAL 570 WILLOW ROAD MENLO PARK CA 94025 SAN MATEO (650) 324-8500 Acute Care Hospitals Voluntary non-profit - Private FALSE 37.4620430 -122.1595170 0   81 6 6081 41860 San Jose-San Francisco-Oakland, CA Central San Mateo County https://data.medicare.gov/resource/xubh-q36u/row-y26q.aad6_zuz4 50754 650662 2019-06-03 2018-12-31 16           16               16
2900 2900 PINNACLE HOSPITAL 9301 CONNECTICUT DR CROWN POINT IN 46307 LAKE (219) 756-2100 Acute Care Hospitals Physician FALSE 41.4491180 -87.3300690 0   89 18 18089 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-eygb~yded_6pv4 150166 649212 2019-05-31 2018-12-31 16 2         18               18
3265 3265 SAINT JOHN HOSPITAL 3500 SOUTH 4TH STREET LEAVENWORTH KS 66048 LEAVENWORTH (913) 680-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.2836830 -94.9034720 0   103 20 20103 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Leavenworth County https://data.medicare.gov/resource/xubh-q36u/row-gwye-2cdu~ejt9 170009 648910 2019-05-29 2018-12-31 16 6         22 30             52
4222 4222 SALINA SURGICAL HOSPITAL 401 SOUTH SANTA FE AVENUE SALINA KS 67401 SALINE (785) 827-0610 Acute Care Hospitals Physician FALSE 38.8343460 -97.6091620 0   169 20 20169 41460   Central Saline County https://data.medicare.gov/resource/xubh-q36u/row-a8k6_5z4m~icmv 170187 648111 2019-05-20 2018-12-31 16           16               16
4418 4418 TOPS SURGICAL SPECIALTY HOSPITAL 17080 RED OAK DRIVE HOUSTON TX 77090 HARRIS (281) 539-2900 Acute Care Hospitals Physician TRUE 30.0185420 -95.4448460 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-zx2w_9w8g_bm8e 450774 650378 2019-06-20 2018-12-31 16           16               16
4427 4427 PROVIDENCE HOSPITAL OF NORTH HOUSTON LLC 16750 RED OAK DRIVE HOUSTON TX 77090 HARRIS (281) 453-7916 Acute Care Hospitals Proprietary TRUE 30.0142780 -95.4409351 1 ROOFTOP 201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-akm5~pcmt~sgnr 670119 648515 2019-05-30 2018-12-31 16           16               16

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