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

75 rows where "fy_end_date" is on date 2019-05-31

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, statefips, csatitle, centraloutlyingcounty, filed_date, icu_beds, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date)

fy_end_date (date) ✖

  • 2019-05-31 · 75 ✖
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
26 26 CITY HOSPITAL AT WHITE ROCK 9440 POPPY DR DALLAS TX 75218 DALLAS (214) 324-6100 Acute Care Hospitals Proprietary TRUE 32.8355210 -96.7050010 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5mze~mvpw.a56k 450678 655846 2019-10-31 2019-05-31 167 20         187               187
100 100 NORTHEAST REGIONAL MEDICAL CENTER 315 S OSTEOPATHY KIRKSVILLE MO 63501 ADAIR (660) 785-1000 Acute Care Hospitals Proprietary TRUE 40.1925230 -92.5908490 0   1 29 29001 28860   Central Adair County https://data.medicare.gov/resource/xubh-q36u/row-75xb~p5w7-egiy 260022 656302 2019-10-31 2019-05-31 41 10         51               51
167 167 ST JOSEPH HOSPITAL 700 BROADWAY FORT WAYNE IN 46802 ALLEN (260) 425-3000 Acute Care Hospitals Proprietary TRUE 41.0788910 -85.1488730 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kr9f_9zxq-kk6p 150047 655893 2019-10-31 2019-05-31 76     12     88 19     20       127
301 301 EASTERN NEW MEXICO MEDICAL CENTER 405 W COUNTRY CLUB ROAD ROSWELL NM 88201 CHAVES (575) 624-8722 Acute Care Hospitals Proprietary TRUE 33.4233000 -104.5274050 0   5 35 35005 40740   Central Chaves County https://data.medicare.gov/resource/xubh-q36u/row-ddda_ex4p_75h9 320006 656469 2019-11-01 2019-05-31 142 20         162               162
557 557 ST LUKE'S MEDICAL CENTER 1800 EAST VAN BUREN STREET PHOENIX AZ 85006 MARICOPA (602) 251-8156 Acute Care Hospitals Proprietary TRUE 33.4514360 -112.0427670 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-uw3s~cbm4-5jyq 30037 655739 2019-10-31 2019-05-31 141 30         171 55 16           242
585 585 SAN RAMON REGIONAL MEDICAL CENTER 6001 NORRIS CANYON ROAD SAN RAMON CA 94583 CONTRA COSTA (925) 275-9200 Acute Care Hospitals Proprietary TRUE 37.7759880 -121.9592740 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-mpyd~xeiu_s72k 50689 655752 2019-10-28 2019-05-31 109 12       2 123               123
736 736 BOURBON COMMUNITY HOSPITAL 9 LINVILLE DRIVE PARIS KY 40361 BOURBON (859) 987-3600 Acute Care Hospitals Proprietary TRUE 38.2206550 -84.2388960 0   17 21 21017 30460 Lexington-Fayette--Richmond--Frankfort, KY Outlying Bourbon County https://data.medicare.gov/resource/xubh-q36u/row-ihrs-q6mn.wqdz 180046 656078 2019-10-29 2019-05-31 30 4         34 24             58
928 928 TRISTAR ASHLAND CITY MEDICAL CENTER 313 NORTH MAIN ST ASHLAND CITY TN 37015 CHEATHAM (615) 792-3030 Critical Access Hospitals Proprietary TRUE 36.2769740 -87.0659760 0   21 47 47021 34980 Nashville-Davidson--Murfreesboro, TN Outlying Cheatham County https://data.medicare.gov/resource/xubh-q36u/row-dctd_vqeq_ijzv 441311 655652 2019-10-30 2019-05-31 12           12               12
929 929 BAYLOR SCOTT & WHITE MEDICAL CENTER - MARBLE FALLS 810 W HIGHWAY 71 MARBLE FALLS TX 78654 BURNET (830) 201-7308 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1107400 -97.3593810 0   21 48 48021 12420   Outlying Bastrop County https://data.medicare.gov/resource/xubh-q36u/row-jqmz_geif_6mxi 670108 661842 2019-12-16 2019-05-31 38 8         46               46
1086 1086 NORTHWEST MISSISSIPPI REGIONAL MEDICAL CENTER 1970 HOSPITAL DRIVE CLARKSDALE MS 38614 COAHOMA (662) 627-3211 Acute Care Hospitals Proprietary TRUE 34.1971330 -90.5527640 0   27 28 28027 17260   Central Coahoma County https://data.medicare.gov/resource/xubh-q36u/row-y8pt-cm7s-9ruz 250042 656100 2019-11-01 2019-05-31 171 10         181               181
1174 1174 PRAIRIE LAKES HOSPITAL 401 9TH AVENUE NW POST OFFICE BOX 1210 WATERTOWN SD 57201 CODINGTON (605) 882-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.9108370 -97.1208120 0   29 46 46029 47980   Central Codington County https://data.medicare.gov/resource/xubh-q36u/row-s5v8~2qq3.b3sg 430005 656361 2019-11-04 2019-05-31 73 8         81               81
1217 1217 LOUIS A WEISS MEMORIAL HOSPITAL 4646 N MARINE DRIVE CHICAGO IL 60640 COOK (773) 878-8700 Acute Care Hospitals Proprietary TRUE 41.9665210 -87.6488980 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-ygcm-y4qk~h9d2 140082 659247 2019-11-01 2019-05-31 103 16         119 11 14           144
1304 1304 TENNOVA HEALTHCARE-HARTON 1801 N JACKSON ST BOX 460 TULLAHOMA TN 37388 COFFEE (931) 393-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.3829210 -86.2305330 0   31 47 47031 46100   Central Coffee County https://data.medicare.gov/resource/xubh-q36u/row-pzkg-w8h5.tdu3 440144 659368 2019-11-11 2019-05-31 61 13         74               74
1317 1317 WEST FLORIDA HOSPITAL 8383 N DAVIS HWY PENSACOLA FL 32514 ESCAMBIA (850) 494-4000 Acute Care Hospitals Proprietary TRUE 30.5151610 -87.2169200 0   33 12 12033 37860   Central Escambia County https://data.medicare.gov/resource/xubh-q36u/row-pfdy~9csk_a6wz 100231 656066 2019-11-01 2019-05-31 320 26 10       356   41           397
1318 1318 BURKE MEDICAL CENTER 351 SOUTH LIBERTY STREET WAYNESBORO GA 30830 BURKE (706) 554-4435 Acute Care Hospitals Proprietary TRUE 33.0834390 -82.0116030 0   33 13 13033 12260   Outlying Burke County https://data.medicare.gov/resource/xubh-q36u/row-7d8s_n675.nabc 110113 655442 2019-10-24 2019-05-31 40           40               40
1392 1392 EAST CARROLL PARISH HOSPITAL 336 NORTH HOOD STREET LAKE PROVIDENCE LA 71254 EAST CARROLL (318) 559-4023 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8110760 -91.1716560 0   35 22 22035         https://data.medicare.gov/resource/xubh-q36u/row-uef7_f368-ahcn 190208 657138 2019-11-01 2019-05-31 23           23               23
1453 1453 LAKEWOOD REGIONAL MEDICAL CENTER 3700 E SOUTH ST LAKEWOOD CA 90712 LOS ANGELES (562) 602-6751 Acute Care Hospitals Proprietary TRUE 33.8602230 -118.1487490 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-kkpc~5uz9~2td4 50581 655750 2019-10-28 2019-05-31 140 32         172               172
1573 1573 TRISTAR SOUTHERN HILLS MEDICAL CENTER 391 WALLACE RD NASHVILLE TN 37211 DAVIDSON (615) 781-4000 Acute Care Hospitals Proprietary TRUE 36.0778720 -86.7238140 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-hyay~dct4~yy74 440197 655473 2019-10-28 2019-05-31 83 20         103   16           119
1710 1710 DOUGLAS COUNTY MEMORIAL HOSPITAL-CAH 708 8TH ST ARMOUR SD 57313 DOUGLAS (605) 724-2159 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3248250 -98.3448240 0   43 46 46043         https://data.medicare.gov/resource/xubh-q36u/row-pg2t_pahj-3xcd 431305 656756 2019-11-05 2019-05-31 11           11               11
1711 1711 TRISTAR HORIZON MEDICAL CENTER 111 HIGHWAY 70 EAST DICKSON TN 37055 DICKSON (615) 446-0446 Acute Care Hospitals Proprietary TRUE 36.0721200 -87.3748080 0   43 47 47043 34980 Nashville-Davidson--Murfreesboro, TN Outlying Dickson County https://data.medicare.gov/resource/xubh-q36u/row-r3k9-6axa-7yb6 440046 655651 2019-10-25 2019-05-31 85 6         91   12           103
1851 1851 ST PETERS HOSPITAL 2475 BROADWAY HELENA MT 59601 LEWIS AND CLARK (406) 442-2480 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.5834940 -111.9966811 1 ROOFTOP 49 30 30049 25740   Central Lewis and Clark County https://data.medicare.gov/resource/xubh-q36u/row-evvs~mb5j_5wez 270003 656303 2019-11-01 2019-05-31 91 8         101 24             125
2025 2025 HOLY CROSS HOSPITAL A DIV OF TAOS HEALTH SYSTEMS 1397 WEIMER ROAD TAOS NM 87571 TAOS (575) 758-8883 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.3673970 -105.5774580 0   55 35 35055 45340   Central Taos County https://data.medicare.gov/resource/xubh-q36u/row-fzvj-n3hd_7bvs 321310 655934 2019-11-01 2019-05-31 19 6         25               25
2089 2089 OGDEN REGIONAL MEDICAL CENTER 5475 SOUTH 500 EAST OGDEN UT 84405 WEBER (801) 479-2111 Acute Care Hospitals Proprietary TRUE 41.1635020 -111.9686200 0   57 49 49057 36260 Salt Lake City-Provo-Orem, UT Central Weber County https://data.medicare.gov/resource/xubh-q36u/row-5jqt-h3ke-8iym 460005 656017 2019-10-31 2019-05-31 139 14       17 170           12   182
2109 2109 PLACENTIA LINDA HOSPITAL 1301 N ROSE DRIVE PLACENTIA CA 92870 ORANGE (714) 993-2000 Acute Care Hospitals Proprietary TRUE 33.8866120 -117.8420960 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-rjmd~3mmi-4rkc 50589 656051 2019-10-28 2019-05-31 106 8         114               114
2121 2121 LOS ALAMITOS MEDICAL CENTER 3751 KATELLA AVENUE LOS ALAMITOS CA 90720 ORANGE (562) 799-3220 Acute Care Hospitals Proprietary TRUE 33.8031750 -118.0674130 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-gwxq.xhzq.wq3h 50551 655881 2019-10-30 2019-05-31 129 17         146               146
2139 2139 OWENSBORO HEALTH REGIONAL HOSPITAL 1201 PLEASANT VALLEY ROAD OWENSBORO KY 42303 DAVIESS (270) 417-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7772960 -87.0699580 0   59 21 21059 36980   Central Daviess County https://data.medicare.gov/resource/xubh-q36u/row-q3mh~rpxk-qu3q 180038 657828 2019-10-31 2019-05-31 379 32       16 427   20   30       477
2290 2290 DESERT REGIONAL MEDICAL CENTER 1150 NORTH INDIAN CANYON DRIVE PALM SPRINGS CA 92262 RIVERSIDE (760) 323-6511 Acute Care Hospitals Proprietary TRUE 33.8388610 -116.5455980 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-xtgm_w9me.m6e8 50243 659636 2019-11-19 2019-05-31 264 31       30 325   12   32       369
2293 2293 JOHN F KENNEDY MEMORIAL HOSPITAL 47111 MONROE STREET INDIO CA 92201 RIVERSIDE (760) 347-6191 Acute Care Hospitals Proprietary TRUE 33.7063590 -116.2338810 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-5fp5.7ptj~7ga6 50534 655749 2019-10-28 2019-05-31 114 16         130               130
2356 2356 MOREHOUSE GENERAL HOSPITAL 323 W WALNUT BASTROP LA 71220 MOREHOUSE (318) 283-3600 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7748904 -91.9171756 1 ROOFTOP 67 22 22067 12820 Monroe-Ruston-Bastrop, LA Central Morehouse Parish https://data.medicare.gov/resource/xubh-q36u/row-aa6z.6x6h.fdkd 190116 655276 2019-10-16 2019-05-31 33 6         39 10             49
2428 2428 HI-DESERT MEDICAL CENTER 6601 WHITE FEATHER ROAD JOSHUA TREE CA 92252 SAN BERNARDINO (760) 366-3711 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1326760 -116.2767090 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-3mx7_8i2i.7siq 50279 655668 2019-10-30 2019-05-31 51 4         55       95 25     175
2482 2482 ALLIANCEHEALTH PONCA CITY 1900 NORTH 14TH STREET PONCA CITY OK 74601 KAY (580) 765-3301 Acute Care Hospitals Proprietary TRUE 36.7240880 -97.0672810 0   71 40 40071 38620   Central Kay County https://data.medicare.gov/resource/xubh-q36u/row-t7iq-uqd6~3p36 370006 656720 2019-11-01 2019-05-31 38 10         48               48
2525 2525 HAMMOND HENRY HOSPITAL 600 N COLLEGE AVENUE GENESEO IL 61254 HENRY (309) 944-6431 Critical Access Hospitals Government - Hospital District or Authority TRUE 41.4606740 -90.1584050 0   73 17 17073 19340 Davenport-Moline, IA-IL Outlying Henry County https://data.medicare.gov/resource/xubh-q36u/row-vz95-wk65-ceui 141319 659258 2019-10-30 2019-05-31 25           25       37       62
2591 2591 DOCTORS HOSPITAL OF MANTECA 1205 E NORTH STREET MANTECA CA 95336 SAN JOAQUIN (209) 823-3111 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.8010870 -121.1969100 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-c4b9.uk2v.8fgd 50118 655745 2019-10-28 2019-05-31 65 8         73               73
2638 2638 SIERRA VISTA REGIONAL MEDICAL CENTER 1010 MURRAY ST SAN LUIS OBISPO CA 93405 SAN LUIS OBISPO (850) 546-7600 Acute Care Hospitals Proprietary TRUE 35.2909660 -120.6661740 0   79 6 6079 42020   Central San Luis Obispo County https://data.medicare.gov/resource/xubh-q36u/row-tear~ssyb.ychy 50506 656047 2019-10-30 2019-05-31 123 17       22 162               162
2639 2639 TWIN CITIES COMMUNITY HOSPITAL 1100 LAS TABLAS RD TEMPLETON CA 93465 SAN LUIS OBISPO (805) 434-3500 Acute Care Hospitals Proprietary TRUE 35.5543890 -120.7201300 0   79 6 6079 42020   Central San Luis Obispo County https://data.medicare.gov/resource/xubh-q36u/row-9pwz~hbhx_tz4b 50633 655751 2019-10-28 2019-05-31 104 18         122               122
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
2671 2671 RALEIGH GENERAL HOSPITAL 1710 HARPER ROAD BECKLEY WV 25801 RALEIGH (304) 256-4100 Acute Care Hospitals Proprietary TRUE 37.7864580 -81.2031030 0   81 54 54081 13220   Central Raleigh County https://data.medicare.gov/resource/xubh-q36u/row-imqm-cjnw~q5ww 510070 656810 2019-10-31 2019-05-31 268 16 16       300               300
2827 2827 HIALEAH HOSPITAL 651 E 25TH ST HIALEAH FL 33013 MIAMI-DADE (305) 693-6100 Acute Care Hospitals Proprietary TRUE 25.8449310 -80.2688810 0   86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-q4nv.dfh5_bbrg 100053 655760 2019-10-28 2019-05-31 331 21       10 362               362
2836 2836 NORTH SHORE MEDICAL CENTER 1100 NW 95TH ST MIAMI FL 33150 MIAMI-DADE (305) 835-6000 Acute Care Hospitals Proprietary TRUE 25.8616580 -80.2146560 0   86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-9ga8_euvm.dbmz 100029 655759 2019-10-28 2019-05-31 660 58       18 748               748
2936 2936 FORT WALTON BEACH MEDICAL CENTER 1000 MAR-WALT DR FORT WALTON BEACH FL 32547 OKALOOSA (850) 862-1111 Acute Care Hospitals Proprietary TRUE 30.4546760 -86.6320690 0   91 12 12091 18880   Central Okaloosa County https://data.medicare.gov/resource/xubh-q36u/row-g8wf~y48m.bkyy 100223 656065 2019-11-01 2019-05-31 150 23 6       189 48 30           267
2939 2939 TWIN CITIES HOSPITAL 2190 HWY 85 N NICEVILLE FL 32578 OKALOOSA (850) 678-4131 Acute Care Hospitals Proprietary TRUE 30.5335439 -86.4955846 1 ROOFTOP 91 12 12091 18880   Central Okaloosa County https://data.medicare.gov/resource/xubh-q36u/row-xgh2-c9rs.xgvm 100054 656061 2019-11-01 2019-05-31 57 8         65               65
2949 2949 OVERLAND PARK REG MED CTR 10500 QUIVIRA ROAD OVERLAND PARK KS 66215 JOHNSON (913) 541-5000 Acute Care Hospitals Proprietary TRUE 38.9376130 -94.7237260 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-mp9r_9j7w~qbg7 170176 658984 2019-10-31 2019-05-31 182 25         270               270
2951 2951 MENORAH MEDICAL CENTER 5721 WEST 119TH STREET OVERLAND PARK KS 66209 JOHNSON (913) 498-6773 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9128350 -94.6514730 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-6v9u-f9rp_pttn 170182 655771 2019-10-30 2019-05-31 131 16       6 153   11           164
2977 2977 PIEDMONT MEDICAL CENTER 222 S HERLONG AVE ROCK HILL SC 29730 YORK (803) 329-1234 Acute Care Hospitals Proprietary TRUE 34.9551980 -81.0512500 0   91 45 45091 16740 Charlotte-Concord, NC-SC Outlying York County https://data.medicare.gov/resource/xubh-q36u/row-ut6b.7ida_ci73 420002 655837 2019-10-28 2019-05-31 244 24         268 20             288
2980 2980 RESOLUTE HEALTH HOSPITAL 555 CREEKSIDE XING, NEW BRAUNFELS TX 78130 COMAL (469) 839-6778 Acute Care Hospitals Proprietary TRUE 29.7192100 -98.0712120 0   91 48 48091 41700   Central Comal County https://data.medicare.gov/resource/xubh-q36u/row-idje_46pq-7psy 670098 656215 2019-10-31 2019-05-31 80 16       16 112               112
3133 3133 DOCTORS MEDICAL CENTER 1441 FLORIDA AVENUE MODESTO CA 95350 STANISLAUS (209) 578-1211 Acute Care Hospitals Proprietary TRUE 37.6656660 -120.9962500 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-h4cz~c84j.66ru 50464 655748 2019-10-30 2019-05-31 291 22 14     45 380 67             447
3140 3140 PALMS WEST HOSPITAL 13001 SOUTHERN BLVD LOXAHATCHEE FL 33470 PALM BEACH (561) 753-4245 Acute Care Hospitals Proprietary TRUE 26.6819280 -80.2514390 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-467f_6sbi_i63x 100269 656067 2019-11-01 2019-05-31 176 18       10 204               204
3144 3144 GOOD SAMARITAN MEDICAL CENTER 1309 N FLAGLER DR WEST PALM BEACH FL 33401 PALM BEACH (561) 655-5511 Acute Care Hospitals Proprietary TRUE 26.7250620 -80.0499680 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-kt9e~dq2e-y9e2 100287 655762 2019-10-28 2019-05-31 304 22       7 333               333
3146 3146 ST MARY'S MEDICAL CENTER 901 45TH ST WEST PALM BEACH FL 33407 PALM BEACH (561) 840-6202 Acute Care Hospitals Proprietary TRUE 26.7532080 -80.0628030 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-zv5a-4h7d-vvtj 100288 655763 2019-10-30 2019-05-31 299 26       45 370 40 50           460
3461 3461 SANTA ROSA MEDICAL CENTER 6002 BERRYHILL RD MILTON FL 32570 SANTA ROSA (850) 626-7762 Acute Care Hospitals Proprietary TRUE 30.6326160 -87.0682500 0   113 12 12113 37860   Central Santa Rosa County https://data.medicare.gov/resource/xubh-q36u/row-wbam_jv67_bisa 100124 659484 2019-11-13 2019-05-31 100 8         108               108
3489 3489 MEDICAL CITY DALLAS 7777 FOREST LANE DALLAS TX 75230 DALLAS (972) 566-6222 Acute Care Hospitals Proprietary TRUE 32.9094470 -96.7720890 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-3qng_3ekx.a9in 450647 656001 2019-10-31 2019-05-31 576 36 16   16 16 776   17           793
3547 3547 CENTRAL FLORIDA REGIONAL HOSPITAL 1401 W SEMINOLE BLVD SANFORD FL 32771 SEMINOLE (407) 321-4500 Acute Care Hospitals Proprietary TRUE 28.8162020 -81.2835770 0   117 12 12117 36740 Orlando-Deltona-Daytona Beach, FL Central Seminole County https://data.medicare.gov/resource/xubh-q36u/row-ik5y.aie9-tk99 100161 658927 2019-10-31 2019-05-31 180 28         208   13           221
3657 3657 MEDICAL CENTER OF LEWISVILLE 500 WEST MAIN STREET LEWISVILLE TX 75057 DENTON (972) 420-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.0463060 -97.0042070 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-cesk_zvjh_xszd 450669 655845 2019-10-28 2019-05-31 110 12       16 138   18           156
3674 3674 DOCTORS MEMORIAL HOSPITAL INC 333 N BYRON BUTLER PKWY PERRY FL 32348 TAYLOR (850) 584-0800 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1211280 -83.5920090 0   123 12 12123         https://data.medicare.gov/resource/xubh-q36u/row-zuzs_bydp_aath 100106 656062 2019-10-31 2019-05-31 42 6         48               48
3926 3926 SIERRA MEDICAL CENTER 1625 MEDICAL CENTER DR EL PASO TX 79902 EL PASO (915) 747-4000 Acute Care Hospitals Proprietary TRUE 31.7786700 -106.4796500 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-af3f.cjxd.pdpu 450668 655844 2019-10-28 2019-05-31 196 23 7     1 234   24           258
3929 3929 THE HOSPITALS OF PROVIDENCE MEMORIAL CAMPUS 2001 N OREGON ST EL PASO TX 79902 EL PASO (915) 577-6011 Acute Care Hospitals Proprietary TRUE 31.7711610 -106.4993450 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-mwx3.k55z_dt4b 450002 655841 2019-10-28 2019-05-31 238 20       34 308 12             320
4069 4069 ALLIANCEHEALTH WOODWARD 900 17TH STREET WOODWARD OK 73801 WOODWARD (580) 254-8492 Acute Care Hospitals Proprietary TRUE 36.4378610 -99.4009540 0   153 40 40153 49260   Central Woodward County https://data.medicare.gov/resource/xubh-q36u/row-xvc5-zx2v~yrxt 370002 659337 2019-11-07 2019-05-31 34 6         40               40
4105 4105 ST FRANCIS HOSPITAL 5959 PARK AVE MEMPHIS TN 38119 SHELBY (901) 765-1000 Acute Care Hospitals Proprietary TRUE 35.0999010 -89.8645160 0   157 47 47157 32820 Memphis-Forrest City, TN-MS-AR Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-i9be.s6u9_8ayy 440183 655839 2019-10-28 2019-05-31 278   37     10 325 39 29           393
4110 4110 SAINT FRANCIS BARTLETT MEDICAL CENTER 2986 KATE BOND RD BARTLETT TN 38133 SHELBY (901) 820-7050 Acute Care Hospitals Proprietary TRUE 35.2070340 -89.8023470 0   157 47 47157 32820 Memphis-Forrest City, TN-MS-AR Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-gj83-utqb_fg87 440228 655840 2019-10-28 2019-05-31 114 32       10 156               156
4126 4126 BOTHWELL REGIONAL HEALTH CENTER 601 E 14TH ST SEDALIA MO 65302 PETTIS (660) 826-8833 Acute Care Hospitals Government - Local TRUE 38.6990510 -93.2220890 0   159 29 29159 42740   Central Pettis County https://data.medicare.gov/resource/xubh-q36u/row-xpsz_cm4w.4eff 260009 655921 2019-10-31 2019-05-31 99 9         108               108
4146 4146 RUTHERFORD REGIONAL MEDICAL CENTER 288 SOUTH RIDGECREST AVE RUTHERFORDTON NC 28139 RUTHERFORD (828) 286-5000 Acute Care Hospitals Proprietary TRUE 35.3633960 -81.9648420 0   161 37 37161 22580   Central Rutherford County https://data.medicare.gov/resource/xubh-q36u/row-hdjd~ih5k~ucae 340013 656315 2019-11-04 2019-05-31 93 18         111 14             125
4190 4190 MADELIA COMMUNITY HOSPITAL 121 DREW AVENUE SOUTHEAST MADELIA MN 56062 WATONWAN (507) 642-3255 Critical Access Hospitals Voluntary non-profit - Other TRUE 44.0495360 -94.4093650 0   165 27 27165         https://data.medicare.gov/resource/xubh-q36u/row-pdke_8js6.fmgd 241323 656448 2019-11-04 2019-05-31 25           25               25
4208 4208 CITIZENS MEMORIAL HOSPITAL 1500 N OAKLAND BOLIVAR MO 65613 POLK (417) 326-6000 Acute Care Hospitals Government - Hospital District or Authority FALSE 37.6259710 -93.4209150 0   167 29 29167 44180 Springfield-Branson, MO Outlying Polk County https://data.medicare.gov/resource/xubh-q36u/row-sadt.4nd6.53qy 260195 656103 2019-10-31 2019-05-31 44 8         52 20             72
4275 4275 OWENSBORO HEALTH MUHLENBERG COMMUNITY HOSPITAL 440 HOPKINSVILLE STREET GREENVILLE KY 42345 MUHLENBERG (270) 338-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.1969250 -87.1896390 0   177 21 21177         https://data.medicare.gov/resource/xubh-q36u/row-pepy_3pva.mc5a 180004 656076 2019-11-01 2019-05-31 41 6         47       43       90
4327 4327 ELLETT MEMORIAL HOSPITAL 610 N OHIO AVE APPLETON CITY MO 64724 ST. CLAIR (660) 476-2111 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.1927870 -94.0203890 0   185 29 29185         https://data.medicare.gov/resource/xubh-q36u/row-xsca_bp78~35ih 261301 656450 2019-11-04 2019-05-31 25           25               25
4414 4414 HCA HOUSTON HEALTHCARE NORTHWEST 710 CYPRESS CREEK PARKWAY HOUSTON TX 77090 HARRIS (281) 440-1000 Acute Care Hospitals Proprietary TRUE 30.0180990 -95.4397960 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-5gjz_q6bh_rqe9 450638 656000 2019-11-01 2019-05-31 240 38       10 288   24           312
4482 4482 HILL REGIONAL HOSPITAL 101 CIRCLE DRIVE HILLSBORO TX 76645 HILL (254) 580-8500 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.0119120 -97.0991530 0   217 48 48217         https://data.medicare.gov/resource/xubh-q36u/row-fhyv_yp6w~y55f 450192 655994 2019-10-30 2019-05-31 25           25               25
4506 4506 FAITH COMMUNITY HOSPITAL 215 CHISHOLM TRAIL JACKSBORO TX 76458 JACK (940) 567-6633 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2303860 -98.1667320 0   237 48 48237         https://data.medicare.gov/resource/xubh-q36u/row-ptsg.mpeh~6fx2 450241 655843 2019-10-31 2019-05-31 17           17               17
4614 4614 BAYLOR SCOTT AND WHITE MEDICAL CENTER LAKE POINTE 6800 SCENIC DR ROWLETT TX 75088 DALLAS (972) 412-2273 Acute Care Hospitals Proprietary TRUE 32.9183510 -96.5095360 0   397 48 48397 19100 Dallas-Fort Worth, TX-OK Central Rockwall County https://data.medicare.gov/resource/xubh-q36u/row-x5ah.rt93-ynam 450742 655847 2019-10-31 2019-05-31 90 14       17 121               121
4637 4637 MEDICAL CITY NORTH HILLS 4401 BOOTH CALLOWAY ROAD NORTH RICHLAND HILLS TX 76180 TARRANT (817) 255-1000 Acute Care Hospitals Proprietary TRUE 32.8294760 -97.2122340 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-wubf_54fb_7m6r 450087 655842 2019-10-31 2019-05-31 117 20         137 20             157
4655 4655 MEDICAL CITY ARLINGTON 3301 MATLOCK ROAD ARLINGTON TX 76015 TARRANT (817) 465-3241 Acute Care Hospitals Proprietary TRUE 32.6917510 -97.1148000 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-vf2t.urzf.vx7i 450675 656370 2019-10-31 2019-05-31 248 45 6     36 335   16           351
4689 4689 BAYLOR SCOTT & WHITE MEDICAL CENTER- COLLEGE STATI 700 SCOTT & WHITE DRIVE COLLEGE STATION TX 77845 BRAZOS (979) 691-3701 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1538350 -96.3882090 0   477 48 48477 14780 Houston-The Woodlands, TX Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-cqfb_i8ft_nqt3 670088 656214 2019-10-31 2019-05-31 87 16         119               119
4693 4693 PARKVIEW HOSPITAL 901 S. SWEETWATER WHEELER TX 79096 WHEELER (806) 826-5581 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.4393630 -100.2708030 0   483 48 48483         https://data.medicare.gov/resource/xubh-q36u/row-nt4i-f4bk~gj2q 451334 655475 2019-10-22 2019-05-31 16           16               16
4704 4704 SCOTT & WHITE HOSPITAL-ROUND ROCK 300 UNIVERSITY BLVD ROUND ROCK TX 78664 WILLIAMSON (512) 509-0100 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.5602910 -97.6849090 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-styh~upd9_b338 670034 658970 2019-10-31 2019-05-31 123 44         167               167
4709 4709 UT HEALTH EAST TEXAS QUITMAN HOSPITAL 117 WINNSBORO STREET QUITMAN TX 75783 WOOD (903) 763-4500 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.7961550 -95.4452960 0   499 48 48499         https://data.medicare.gov/resource/xubh-q36u/row-prny-2yw9-g69a 451380 656192 2019-10-29 2019-05-31 25           25               25

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