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

76 rows where hospital_ownership = "Physician"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, statefips, centraloutlyingcounty, filed_date, fy_end_date, icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, filed_date (date), fy_end_date (date)

hospital_ownership ✖

  • Physician · 76 ✖
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
565 565 ABRAZO CENTRAL CAMPUS 2000 WEST BETHANY HOME ROAD PHOENIX AZ 85015 MARICOPA (602) 249-0212 Acute Care Hospitals Physician TRUE 33.5241160 -112.1019340 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-apke-ic6r-dws7 30030 654065 2019-08-30 2019-03-31 116 28         144   16           160
576 576 CORE INSTITUTE SPECIALTY HOSPITAL, THE 6501 NORTH 19TH AVENUE PHOENIX AZ 85015 MARICOPA (602) 795-6020 Acute Care Hospitals Physician FALSE 33.5318370 -112.0996140 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ymwb.kuwb~xe6j 30108 659179 2019-06-03 2018-12-31 32           32               32
581 581 ARIZONA SPINE AND JOINT HOSPITAL 4620 EAST BASELINE ROAD MESA AZ 85206 MARICOPA (480) 832-4770 Acute Care Hospitals Physician FALSE 33.3792060 -111.7346950 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ijxi~2kwd~swq9 30107 650233 2019-05-29 2018-12-31 23           23               23
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
819 819 MOUNTAIN VIEW HOSPITAL 2325 CORONADO STREET IDAHO FALLS ID 83404 BONNEVILLE (208) 557-2700 Acute Care Hospitals Physician FALSE 43.4725240 -111.9887170 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-4xx8-2i4p-wi9n 130065 649556 2019-05-31 2018-12-31 41           41               41
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                              
1104 1104 (CLOSED) CUMBERLAND RIVER HOSPITAL 100 OLD JEFFERSON ST CELINA TN 38551 CLAY (931) 243-3581 Critical Access Hospitals Physician TRUE 36.5447360 -85.5011730 0   27 47 47027         https://data.medicare.gov/resource/xubh-q36u/row-ejr4.nfrj.jxid 441319 655653 2019-10-28 2019-03-01 25           25 8             33
1183 1183 SOUTHWEST GENERAL HOSPITAL 7400 BARLITE BLVD SAN ANTONIO TX 78224 BEXAR (210) 921-2000 Acute Care Hospitals Physician TRUE 29.3529880 -98.5465890 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-yzdz.2e4a_mcwd 450697 644371 2019-02-28 2018-09-30 143 18       24 185 24 16           225
1305 1305 UNITY MEDICAL CENTER 481 INTERSTATE DRIVE MANCHESTER TN 37355 COFFEE (931) 728-6354 Acute Care Hospitals Physician TRUE 35.4979320 -86.0781410 0   31 47 47031 46100   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-7ihq-cddj~pgik 440007 651231 2019-06-03 2018-12-31 49           49               49
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
1384 1384 WADLEY REGIONAL MEDICAL CENTER 1000 PINE STREET TEXARKANA TX 75501 BOWIE (903) 798-8000 Acute Care Hospitals Physician TRUE 33.4284820 -94.0471880 0   37 48 48037 45500   Central Bowie County https://data.medicare.gov/resource/xubh-q36u/row-tvfa~q5ve.ejfb 450200 650527 2019-05-30 2018-12-31 159 26         185 14             199
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
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
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
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
2015 2015 ORTHONEBRASKA HOSPITAL 2808 SOUTH 143RD PLZ OMAHA NE 68144 DOUGLAS (402) 609-1600 Acute Care Hospitals Physician TRUE 41.2320010 -96.1353960 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-dfvh.t4xg.6i7f 280129 648950 2019-05-29 2018-12-31 24           24               24
2018 2018 MIDWEST SURGICAL HOSPITAL LLC 7915 FARNAM DRIVE OMAHA NE 68114 DOUGLAS (402) 399-1900 Acute Care Hospitals Physician FALSE 41.2581550 -96.0368910 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-xw6r.3ppq~b8p6 280131 647298 2019-04-25 2018-12-31 19           19               19
2282 2282 MENIFEE GLOBAL MEDICAL CENTER 28400 MCCALL B0ULEVARD SUN CITY CA 92585 RIVERSIDE (951) 679-8888 Acute Care Hospitals Physician FALSE 33.7189772 -117.1681518 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-rqjx-c4v4.2ewv 50684 651179 2019-06-03 2018-12-31 74 10         84               84
2285 2285 HEMET VALLEY MEDICAL CENTER 1117 EAST DEVONSHIRE HEMET CA 92543 RIVERSIDE (951) 652-2811 Acute Care Hospitals Physician TRUE 33.7512200 -116.9598590 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-nd99_qqgq_fexi 50390 650949 2019-06-03 2018-12-31 286 18         304       113       417
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
2463 2463 ST CHARLES SURGICAL HOSPITAL LLC 1717 ST CHARLES AVE NEW ORLEANS LA 70130 ORLEANS (504) 529-6600 Acute Care Hospitals Physician FALSE 29.9373710 -90.0768800 0   71 22 22071 35380 New Orleans-Metairie-Hammond, LA-MS Central Orleans Parish https://data.medicare.gov/resource/xubh-q36u/row-bm2i-2rpj_kw3b 190300 649438 2019-05-30 2018-12-31 39           39               39
2509 2509 SCRIPPS MEMORIAL HOSPITAL LA JOLLA 9888 GENESEE AVENUE LA JOLLA CA 92037 SAN DIEGO (858) 626-4123 Acute Care Hospitals Physician TRUE 32.8855000 -117.2230220 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-dpzj.qr7c.gnws 50324 644215 2019-02-28 2018-09-30 306 59         365               365
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
2624 2624 SURGICAL SPECIALTY CENTER AT COORDINATED HEALTH 1503 CEDAR CREST BOULEVARD ALLENTOWN PA 18104 LEHIGH (610) 871-9110 Acute Care Hospitals Physician FALSE 40.6121900 -75.5327500 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-ecs5-8dzv.54i7 390321 650522 2019-06-03 2018-12-31 20           20       12       32
2647 2647 CENTRAL LOUISIANA SURGICAL HOSPITAL 651 NORTH BOLTON AVE ALEXANDRIA LA 71301 RAPIDES (318) 449-6400 Acute Care Hospitals Physician FALSE 31.3152360 -92.4674780 0   79 22 22079 10780   Central Rapides Parish https://data.medicare.gov/resource/xubh-q36u/row-m9k4.j7wi.48hz 190298 655908 2019-10-31 2019-05-31 24           24               24
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
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
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
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
3000 3000 ALLIANCE HEALTHCARE SYSTEM 1430 HIGHWAY 4 EAST / P O BOX 6000 HOLLY SPRINGS MS 38635 MARSHALL (662) 252-1212 Acute Care Hospitals Physician TRUE 34.7868350 -89.4150270 0   93 28 28093 32820 Memphis-Forrest City, TN-MS-AR Outlying Marshall County https://data.medicare.gov/resource/xubh-q36u/row-zg7w-9rxd.iyxq 250012 648706 2019-06-04 2018-12-31 27           27 13             40
3066 3066 COORDINATED HEALTH ORTHOPEDIC HOSPITAL 2310 HIGHLAND AVENUE BETHLEHEM PA 18017 NORTHAMPTON (610) 691-4300 Acute Care Hospitals Physician FALSE 40.6737620 -75.3654010 0   95 42 42095 10900 New York-Newark, NY-NJ-CT-PA Central Northampton County https://data.medicare.gov/resource/xubh-q36u/row-sc4k-g4c8.mwqt 390314 651057 2019-06-03 2018-12-31 20           20               20
3102 3102 ORTHOINDY HOSPITAL 8400 NORTHWEST BLVD INDIANAPOLIS IN 46278 MARION (317) 956-1000 Acute Care Hospitals Physician FALSE 39.9067020 -86.2662580 0   97 18 18097 26900 Indianapolis-Carmel-Muncie, IN Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-sa8x~jqdx_zkr2 150160 660543 2019-11-25 2018-12-31 38           38               38
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
3266 3266 SOUTHERN SURGICAL HOSPITAL 1700 W LINDBERG DRIVE SLIDELL LA 70458 ST. TAMMANY (985) 641-0600 Acute Care Hospitals Physician FALSE 30.2737790 -89.7544980 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-vzji.d7ed.ev4j 190270 648267 2019-05-21 2018-12-31 32 5         37               37
3267 3267 AVALA 67252 INDUSTRY LANE COVINGTON LA 70433 ST. TAMMANY (985) 801-3010 Acute Care Hospitals Physician FALSE 30.4087130 -90.0829430 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-rabs-2sar-uqwy 190267 648930 2019-05-22 2018-12-31 21           21               21
3314 3314 CYPRESS POINTE SURGICAL HOSPITAL 42570 SOUTH AIRPORT RD HAMMOND LA 70403 TANGIPAHOA (985) 510-6200 Acute Care Hospitals Physician FALSE 30.4770420 -90.4142640 0   105 22 22105 25220 New Orleans-Metairie-Hammond, LA-MS Central Tangipahoa Parish https://data.medicare.gov/resource/xubh-q36u/row-hpin~yhn8-9yzq 190303 648698 2019-05-24 2018-12-31 30           30               30
3371 3371 PHYSICIANS MEDICAL CENTER 218 CORPORATE DRIVE HOUMA LA 70360 TERREBONNE (985) 853-1390 Acute Care Hospitals Physician FALSE 29.6000530 -90.7502880 0   109 22 22109 26380   Central Terrebonne Parish https://data.medicare.gov/resource/xubh-q36u/row-8tmv-a3a5~7wbn 190241 649597 2019-05-31 2018-12-31 30           30               30
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
3391 3391 COMMUNITY HOSPITAL, LLC 3100 SOUTHWEST 89TH STREET OKLAHOMA CITY OK 73159 OKLAHOMA (405) 602-8100 Acute Care Hospitals Physician TRUE 35.3771130 -97.5704530 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-ftkm_6raj-yxui 370203 649480 2019-05-30 2018-12-31 42 3         45               45
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
3396 3396 OKLAHOMA HEART HOSPITAL, LLC 4050 WEST MEMORIAL ROAD OKLAHOMA CITY OK 73120 OKLAHOMA (405) 608-3200 Acute Care Hospitals Physician TRUE 35.6090350 -97.5962010 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-mfev-kw93~8mw6 370215 649338 2019-05-29 2018-12-31 99           99               99
3398 3398 OKLAHOMA HEART HOSPITAL SOUTH, LLC 5200 EAST I-240 SERVICE ROAD OKLAHOMA CITY OK 73135 OKLAHOMA (405) 628-6000 Acute Care Hospitals Physician TRUE 35.3902550 -97.4269990 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-qef8_575c-adkz 370234 649481 2019-05-29 2018-12-31 44           44               44
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
3401 3401 OKLAHOMA SPINE HOSPITAL 14101 PARKWAY COMMONS DRIVE OKLAHOMA CITY OK 73134 OKLAHOMA (405) 749-2700 Acute Care Hospitals Physician TRUE 35.6141370 -97.5821240 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-g6tz_y8sg_qryk 370206 648756 2019-06-03 2018-12-31 23           23               23
3403 3403 LAKESIDE WOMEN'S HOSPITAL, A MEMBER OF INTEGRIS HE 11200 NORTH PORTLAND AVENUE OKLAHOMA CITY OK 73120 OKLAHOMA (405) 936-1500 Acute Care Hospitals Physician TRUE 35.5836510 -97.5850190 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-aw3a.amzg.7s3y 370199 659103 2019-11-20 2019-06-30 23           23               23
3404 3404 MCBRIDE ORTHOPEDIC HOSPITAL 9600 NORTH BROADWAY EXTENSION OKLAHOMA CITY OK 73114 OKLAHOMA (405) 486-2100 Acute Care Hospitals Physician TRUE 35.5675720 -97.5128020 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-hsg4~n2rn-4uw4 370222 647302 2019-05-01 2018-12-31 64           64               64
3505 3505 CRESCENT MEDICAL CENTER LANCASTER 2600 WEST PLEASANT RUN ROAD LANCASTER TX 75146 DALLAS (972) 230-8888 Acute Care Hospitals Physician TRUE 32.6041280 -96.8144830 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-idy9.ih28~dnum 670090 649860 2019-06-04 2018-12-31 76 8         84               84
3656 3656 THE HEART HOSPITAL BAYLOR DENTON 2801 SOUTH MAYHILL ROAD DENTON TX 76208 DENTON (940) 220-0600 Acute Care Hospitals Physician TRUE 33.1769700 -97.0881990 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-rbda~a4ni-iua9 450893 648994 2019-05-31 2018-12-31 22           22               22
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
3914 3914 UNITY MEDICAL AND SURGICAL HOSPITAL 4455 EDISON LAKES PKWY MISHAWAKA IN 46545 ST. JOSEPH (574) 231-6800 Acute Care Hospitals Physician FALSE 41.7007230 -86.1767810 0   141 18 18141 43780 South Bend-Elkhart-Mishawaka, IN-MI Central St. Joseph County https://data.medicare.gov/resource/xubh-q36u/row-ezgx~i6vb_t9ti 150177 649092 2019-05-30 2018-12-31 29           29               29
3931 3931 EL PASO LTAC HOSPTIAL 1221 N COTTON ST 3RD FLOOR EL PASO TX 79902 EL PASO (915) 496-9687 Acute Care Hospitals Physician FALSE 31.7836990 -106.4735520 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-wqm3_d2vk.as9x 670127 661274 2019-12-05 2019-06-30 33           33               33
3964 3964 OKLAHOMA SURGICAL HOSPITAL, LLC 2408 EAST 81ST STREET, SUITE 300 TULSA OK 74137 TULSA (918) 477-5095 Acute Care Hospitals Physician TRUE 36.0463220 -95.9551800 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-8m5y-qnga_t4wb 370210 649664 2019-05-28 2018-12-31 69 6         75               75
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
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
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
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
4251 4251 KANSAS SPINE & SPECIALTY HOSPITAL, LLC 3333 NORTH WEBB ROAD WICHITA KS 67226 SEDGWICK (316) 462-5326 Acute Care Hospitals Physician FALSE 37.7439660 -97.2263260 0   173 20 20173 48620 Wichita-Arkansas City-Winfield, KS Central Sedgwick County https://data.medicare.gov/resource/xubh-q36u/row-qfsa.vac4~t9rr 170196 648689 2019-05-24 2018-12-31 36           36               36
4252 4252 KANSAS SURGERY & RECOVERY CENTER 2770 NORTH WEBB ROAD WICHITA KS 67226 SEDGWICK (316) 634-0090 Acute Care Hospitals Physician FALSE 37.7329110 -97.2262560 0   173 20 20173 48620 Wichita-Arkansas City-Winfield, KS Central Sedgwick County https://data.medicare.gov/resource/xubh-q36u/row-pkr4.7tue~t7mc 170183 655205 2019-10-10 2019-06-30 32           32               32
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
4410 4410 UNITED MEMORIAL MEDICAL CENTER 510 W TIDWELL HOUSTON TX 77091 HARRIS (713) 691-1111 Acute Care Hospitals Physician TRUE 29.8472220 -95.4079910 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-asfk~qaea.f3zr 450803 651295 2019-06-14 2018-12-31 97           97               97
4412 4412 ST LUKE'S PATIENTS MEDICAL CENTER 4600 EAST SAM HOUSTON PARKWAY SOUTH PASADENA TX 77505 HARRIS (281) 487-0700 Acute Care Hospitals Physician TRUE 29.6402610 -95.1607140 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-mh9z-apzq_zueh 670031 660343 2019-12-02 2019-06-30 53 8         61               61
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
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
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                                      
4440 4440 HOUSTON PHYSICIANS' HOSPITAL 333 N TEXAS AVENUE WEBSTER TX 77598 HARRIS (281) 335-1700 Acute Care Hospitals Physician TRUE 29.5349020 -95.1257850 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-yxt9~vqzu.mhqf 670008 649528 2019-05-31 2018-12-31 21           21               21
4475 4475 DOCTORS HOSPITAL AT RENAISSANCE 5501 SOUTH MCCOLL EDINBURG TX 78539 HIDALGO (956) 362-8677 Acute Care Hospitals Physician TRUE 26.2524240 -98.2041090 0   215 48 48215 32580 McAllen-Edinburg, TX Central Hidalgo County https://data.medicare.gov/resource/xubh-q36u/row-ie54-gr3x-shm2 450869 649837 2019-06-03 2018-12-31 287 58         394 87 38           519
4516 4516 THE MEDICAL CENTER OF SOUTHEAST TEXAS 2555 JIMMY JOHNSON BLVD PORT ARTHUR TX 77640 JEFFERSON (409) 853-5900 Acute Care Hospitals Physician TRUE 29.9349520 -93.9850070 0   245 48 48245 13140   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-adz2.98gm-mm6a 450518 647059 2019-04-26 2018-11-30 151 24       10 185 20 11           216
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
4592 4592 NACOGDOCHES MEDICAL CENTER 4920 NE STALLINGS DRIVE NACOGDOCHES TX 75961 NACOGDOCHES (936) 569-9481 Acute Care Hospitals Physician TRUE 31.6520580 -94.6542650 0   347 48 48347 34860   Central Nacogdoches County https://data.medicare.gov/resource/xubh-q36u/row-m94n-8ys7.xs7q 450656 649673 2019-05-31 2018-12-31 136 11       8 155               155
4625 4625 BAYLOR SCOTT & WHITE TEXAS SPINE & JOINT HOSPITAL 1814 ROSELAND BOULEVARD TYLER TX 75701 SMITH (903) 525-3300 Acute Care Hospitals Physician TRUE 32.3292480 -95.2994670 0   423 48 48423 46340 Tyler-Jacksonville, TX Central Smith County https://data.medicare.gov/resource/xubh-q36u/row-id2a~8wab-iya8 450864 649358 2019-06-03 2018-12-31 20           20               20
4640 4640 USMD HOSPITAL AT ARLINGTON L P 801 W INTERSTATE 20 ARLINGTON TX 76017 TARRANT (817) 472-3400 Acute Care Hospitals Physician TRUE 32.6791510 -97.1159710 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-hc6u~w7qj-g9et 450872 649967 2019-05-31 2018-12-31 30 4         34               34
4656 4656 BAYLOR SCOTT AND WHITE SURGICAL HOSPITAL FORTWORTH 1800 PARK PLACE AVENUE FORT WORTH TX 76110 TARRANT (682) 703-5600 Acute Care Hospitals Physician TRUE 32.7257780 -97.3461850 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-h8e3.3xpq~ecwg 450880 649142 2019-05-28 2018-12-31 26 4         30               30
4674 4674 ASCENSION SETON MEDICAL CENTER AUSTIN 1201 W 38TH ST AUSTIN TX 78705 TRAVIS (512) 324-1000 Acute Care Hospitals Physician TRUE 30.3061540 -97.7452180 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-qf7b-dsjj.a9dv 450056 659731 2019-11-25 2019-06-30 304 83       43 430               430

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