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

177 rows where "filed_date" is on date 2019-02-28 sorted by lat

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, 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, fy_end_date (date)

filed_date (date)

  • 2019-02-28 · 177
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
477 GUAM MEMORIAL HOSPITAL AUTHORITY 85O GOV CARLOS G CAMACHO ROAD TAMUNING GU 96913 GUAM (671) 647-2552 Acute Care Hospitals Government - Local TRUE 13.5008229 144.7755910 1 GEOMETRIC_CENTER 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-4hjs.vy3n_hawy 650001 644079 2019-02-28 2018-09-30 147 14         161       40       201
479 GOV JUAN F LUIS HOSPITAL & MEDICAL CTR #4007 EST DIAMOND RUBY, CHRISTIANSTED ST CROIX VI 820 SAINT CROIX ISLAND (340) 778-6311 Acute Care Hospitals Government - State TRUE 17.7336768 -64.7515758 1 ROOFTOP 10 78 78010         https://data.medicare.gov/resource/xubh-q36u/row-bs2s~9p8n_k2e3 480002 644383 2019-02-28 2018-09-30 66 11         77               77
3515 HOSPITAL SAN CRISTOBAL CARR 506 KM 1 0 COTO LAUREL PR 780 PONCE (787) 848-2100 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.0489279 -66.5531847 1 GEOMETRIC_CENTER 113 72 72113 38660 Ponce-Coamo-Santa Isabel, PR Central Ponce Municipio https://data.medicare.gov/resource/xubh-q36u/row-f3ni_a74v_j5mm 400113 643733 2019-02-28 2018-09-30 110 35         157               157
2851 LOWER KEYS MEDICAL CENTER 5900 COLLEGE ROAD KEY WEST FL 33040 MONROE (305) 294-5531 Acute Care Hospitals Proprietary TRUE 24.5815730 -81.7436880 0   87 12 12087 28580   Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-ygrq~jm9y.gjez 100150 644708 2019-02-28 2018-09-30 90 9         99 21             120
885 PHYSICIANS REGIONAL MEDICAL CENTER - PINE RIDGE 6101 PINE RIDGE ROAD NAPLES FL 34119 COLLIER (239) 348-4000 Acute Care Hospitals Proprietary TRUE 26.2117640 -81.7307070 0   21 12 12021 34940 Cape Coral-Fort Myers-Naples, FL Central Collier County https://data.medicare.gov/resource/xubh-q36u/row-z54t-v8nq.fk93 100286 643693 2019-02-28 2018-09-30 177 24         201               201
2450 GULF COAST MEDICAL CENTER LEE MEM HEALTH SYSTEM 13681 DOCTORS WAY FORT MYERS FL 33912 LEE (239) 768-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.5430160 -81.8485890 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-ey2r_ercs~bbdu 100220 644710 2019-02-28 2018-09-30 320 36         356               356
2452 LEE MEMORIAL HOSPITAL 2776 CLEVELAND AVE FORT MYERS FL 33901 LEE (239) 332-1111 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.6269240 -81.8722950 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-d9mq-v9vy_3733 100012 644229 2019-02-28 2018-09-30 539 75       32 743   60   15       818
2449 CAPE CORAL HOSPITAL 636 DEL PRADO BLVD CAPE CORAL FL 33990 LEE (239) 574-2323 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.6393210 -81.9409460 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-h94e-be5i_u37i 100244 644248 2019-02-28 2018-09-30 235 22       23 280               280
1893 HENDRY REGIONAL MEDICAL CENTER 524 W SAGAMORE AVE CLEWISTON FL 33440 HENDRY (863) 902-3033 Critical Access Hospitals Voluntary non-profit - Other TRUE 26.7532390 -80.9422760 0   51 12 12051 17500   Central Hendry County https://data.medicare.gov/resource/xubh-q36u/row-ati4-fhfd_57wb 101309 643695 2019-02-28 2018-09-30 22 3         25               25
3149 JUPITER MEDICAL CENTER 1210 S OLD DIXIE HWY JUPITER FL 33458 PALM BEACH (561) 747-2234 Acute Care Hospitals Voluntary non-profit - Private TRUE 26.9228240 -80.0945390 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-65xm_emjr~iknq 100253 646027 2019-02-28 2018-09-30 190 17         207               207
3258 PALMS OF PASADENA HOSPITAL 1501 PASADENA AVE S SAINT PETERSBURG FL 33707 PINELLAS (727) 381-1000 Acute Care Hospitals Proprietary TRUE 27.7535170 -82.7381760 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-5brx.ibn9.ivnj 100126 644707 2019-02-28 2018-09-30 149 18         167   20           187
3250 NORTHSIDE HOSPITAL 6000 49TH ST N SAINT PETERSBURG FL 33709 PINELLAS (813) 521-5000 Acute Care Hospitals Proprietary TRUE 27.8260530 -82.7000010 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-9c7k~923g.xenn 100238 645056 2019-02-28 2018-09-30 189 32         221               221
419 HOLMES REGIONAL MEDICAL CENTER 1350 S HICKORY ST MELBOURNE FL 32901 BREVARD (321) 434-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.0869100 -80.6135230 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-vfyd.d5k5.qxkg 100019 646066 2019-02-28 2018-09-30 450 54   10     514               514
420 VIERA HOSPITAL 8745 N WICKHAM RD MELBOURNE FL 32940 BREVARD (321) 434-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.2298120 -80.7294340 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-56fa_2f7u~npx7 100315 646070 2019-02-28 2018-09-30 64 20         84               84
3196 ADVENTHEALTH DADE CITY 13100 FT KING RD DADE CITY FL 33525 PASCO (352) 568-3174 Acute Care Hospitals Proprietary TRUE 28.3485870 -82.2016850 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-w886-maw8~uhkt 100211 644709 2019-02-28 2018-09-30 108 12         120               120
730 BAYFRONT HEALTH SEVEN RIVERS 6201 N SUNCOAST BLVD CRYSTAL RIVER FL 34428 CITRUS (352) 795-6560 Acute Care Hospitals Proprietary TRUE 28.9508960 -82.6258660 0   17 12 12017 26140   Central Citrus County https://data.medicare.gov/resource/xubh-q36u/row-e3ek_i6mx~pzz2 100249 644711 2019-02-28 2018-09-30 112 16         128               128
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
2490 BAYSIDE COMMUNITY HOSPITAL 200 HOSPITAL DRIVE ANAHUAC TX 77514 CHAMBERS (409) 267-3143 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.7530120 -94.6868500 0   71 48 48071 26420 Houston-The Woodlands, TX Central Chambers County https://data.medicare.gov/resource/xubh-q36u/row-zszx-nqzy-xwd5 451320 643853 2019-02-28 2018-09-30 14           14               14
3205 FRANKLIN FOUNDATION HOSPITAL 1097 NORTHWEST BLVD FRANKLIN LA 70538 ST. MARY (337) 828-0760 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.8018700 -91.5252720 0   101 22 22101 34020 Lafayette-Opelousas-Morgan City, LA Central St. Mary Parish https://data.medicare.gov/resource/xubh-q36u/row-72t5.bydx-dr2i 191310 645093 2019-02-28 2018-09-30 20 5         25               25
1210 BAPTIST MEDICAL CENTER JACKSONVILLE 800 PRUDENTIAL DR JACKSONVILLE FL 32207 DUVAL (904) 202-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.3162840 -81.6636090 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-sq6x~c6g4-pdi9 100088 644237 2019-02-28 2018-09-30 665 120         855 48             903
3459 GULF BREEZE HOSPITAL 1110 GULF BREEZE PKWY GULF BREEZE FL 32561 SANTA ROSA (850) 934-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.3586490 -87.1568030 0   113 12 12113 37860   Central Santa Rosa County https://data.medicare.gov/resource/xubh-q36u/row-i236_mnds-pgjj 100266 646028 2019-02-28 2018-09-30 57 8         65               65
1316 BAPTIST HOSPITAL 1000 W MORENO ST PENSACOLA FL 32501 ESCAMBIA (850) 434-4011 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4286760 -87.2320150 0   33 12 12033 37860   Central Escambia County https://data.medicare.gov/resource/xubh-q36u/row-ijyx~shwb.imui 100093 644238 2019-02-28 2018-09-30 229 25     12   266 60             326
1329 BATON ROUGE GENERAL MEDICAL CENTER 3600 FLORIDA BLVD BATON ROUGE LA 70806 E. BATON ROUGE (225) 387-7767 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4503360 -91.1546380 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-wzk2-7azq.gecu 190065 643777 2019-02-28 2018-09-30 212 24   8   9 253 50 8   54       365
3074 UNIVERSITY OF SOUTH ALABAMA MEDICAL CENTER 2451 FILLINGIM STREET MOBILE AL 36617 MOBILE (251) 471-7110 Acute Care Hospitals Government - State TRUE 30.7081210 -88.0994410 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-cmzx-i3i2.bp42 10087 645038 2019-02-28 2018-09-30 117 9   7 16   149               149
1535 GEORGE REGIONAL HEALTH SYSTEM 859 WINTER STREET LUCEDALE MS 39452 GEORGE (601) 947-3161 Acute Care Hospitals Government - Local TRUE 30.9222350 -88.5928530 0   39 28 28039         https://data.medicare.gov/resource/xubh-q36u/row-f75f~mexp.zvtb 250036 643798 2019-02-28 2018-09-30 36 6         42               42
1939 ATMORE COMMUNITY HOSPITAL 401 MEDICAL PARK DRIVE ATMORE AL 36502 ESCAMBIA (251) 368-2500 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0165700 -87.4797350 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-nw85.p2jc-cva6 10169 645521 2019-02-28 2018-09-30 43 6         49               49
292 FIELD HEALTH SYSTEM 178 HIGHWAY 24 CENTREVILLE MS 39631 WILKINSON (601) 890-0500 Critical Access Hospitals Government - Local TRUE 31.0820299 -91.0587631 1 ROOFTOP 5 28 28005 32620   Outlying Amite County https://data.medicare.gov/resource/xubh-q36u/row-d7tp~8xnm~uwen 251309 646102 2019-02-28 2018-09-30 16           16               16
1651 GREENE COUNTY HOSPITAL CAH 1017 JACKSON STREET LEAKESVILLE MS 39451 GREENE (601) 394-4135 Critical Access Hospitals Government - Local TRUE 31.1547640 -88.5626450 0   41 28 28041         https://data.medicare.gov/resource/xubh-q36u/row-w43a~rntf~brjp 251329 643805 2019-02-28 2018-09-30 7           7               7
941 HOLY CROSS HOSPITAL 1171 WEST TARGET RANGE ROAD NOGALES AZ 85621 SANTA CRUZ (520) 285-3000 Critical Access Hospitals Proprietary TRUE 31.3411180 -110.9587340 0   23 4 4023 35700 Tucson-Nogales, AZ Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-datt~k3n6_g682 31313 644092 2019-02-28 2018-09-30 25           25               25
4664 SHANNON MEDICAL CENTER 120 EAST HARRIS AVENUE SAN ANGELO TX 76903 TOM GREEN (325) 653-6741 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.4644850 -100.4350900 0   451 48 48451 41660   Central Tom Green County https://data.medicare.gov/resource/xubh-q36u/row-mf6f.gvju.vuav 450571 644369 2019-02-28 2018-09-30 292 17         313 14 14   28       369
4539 TIFT REGIONAL MEDICAL CENTER 901 E 18TH STREET TIFTON GA 31793 TIFT (229) 382-7120 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.4704020 -83.4910760 0   277 13 13277 45700   Central Tift County https://data.medicare.gov/resource/xubh-q36u/row-ny4q-euja_bk5w 110095 644114 2019-02-28 2018-09-30 161 20         181               181
2795 KING'S DAUGHTERS MEDICAL CENTER-BROOKHAVEN P O BOX 948/427 HIGHWAY 51 NORTH BROOKHAVEN MS 39601 LINCOLN (601) 833-6011 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.5892013 -90.4580392 1 ROOFTOP 85 28 28085 15020 Jackson-Vicksburg-Brookhaven, MS Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-5ntd-ntch~5mxf 250057 643905 2019-02-28 2018-09-30 85 5         90               90
2770 COLEMAN COUNTY MEDICAL CENTER COMPANY 310 SOUTH PECOS STREET COLEMAN TX 76834 COLEMAN (325) 625-2135 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8286260 -99.4252380 0   83 48 48083         https://data.medicare.gov/resource/xubh-q36u/row-arcj.jjrh_hge7 451347 643742 2019-02-28 2018-09-30 25           25               25
4706 WINKLER COUNTY MEMORIAL HOSPITAL 821 JEFFEE DRIVE KERMIT TX 79745 WINKLER (432) 586-5865 Critical Access Hospitals Government - Local TRUE 31.8497390 -103.0899160 0   495 48 48495         https://data.medicare.gov/resource/xubh-q36u/row-qbhw-92m9~uia9 451314 643975 2019-02-28 2018-09-30 19           19               19
3865 ODESSA REGIONAL MEDICAL CENTER 520 E 6TH STREET ODESSA TX 79761 ECTOR (432) 582-8340 Acute Care Hospitals Proprietary TRUE 31.8514580 -102.3660270 0   135 48 48135 36220 Midland-Odessa, TX Central Ector County https://data.medicare.gov/resource/xubh-q36u/row-62b5_9y3z.qtwf 450661 643964 2019-02-28 2018-09-30 133 10       49 192   14           206
3966 TEXAS HEALTH HARRIS METHODIST HOSPITAL STEPHENVILL 411 N BELKNAP ST STEPHENVILLE TX 76401 ERATH (254) 965-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2231630 -98.2048710 0   143 48 48143 44500   Central Erath County https://data.medicare.gov/resource/xubh-q36u/row-3e4m_j29y-qggx 450351 643850 2019-02-28 2018-09-30 45 5         50               50
807 ST JOSEPH'S HOSPITAL 350 NORTH WILMOT ROAD TUCSON AZ 85711 PIMA (520) 873-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.2259460 -110.8578380 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-trzm-jqcs_wpf7 30011 644090 2019-02-28 2018-09-30 377 32       30 451 15 20           486
801 ST. MARY'S HOSPITAL 1601 WEST ST MARY'S ROAD TUCSON AZ 85745 PIMA (520) 872-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2289230 -111.0000320 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-8z3y-kp4a.tw3t 30010 644007 2019-02-28 2018-09-30 300 40   9     349 23 28           400
1215 EAST GEORGIA REGIONAL MEDICAL CENTER 1499 FAIR ROAD STATESBORO GA 30458 BULLOCH (912) 486-1500 Acute Care Hospitals Proprietary TRUE 32.4151710 -81.7686500 0   31 13 13031 44340 Savannah-Hinesville-Statesboro, GA Central Bulloch County https://data.medicare.gov/resource/xubh-q36u/row-xsms-9ix9.jicj 110075 645062 2019-02-28 2018-09-30 118 24         142               142
737 WILLIS KNIGHTON MEDICAL CENTER, INC 2600 GREENWOOD ROAD SHREVEPORT LA 71103 CADDO (318) 212-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4839230 -93.7787480 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-843s.yxjw_fv2n 190111 644278 2019-02-28 2018-09-30 579 74       50 711 34 30   24       799
4639 TEXAS HEALTH HARRIS METHODIST HOSPITAL SOUTHWEST F 6100 HARRIS PKWY FORT WORTH TX 76132 TARRANT (817) 433-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.6585950 -97.4196710 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-jak2~7rcg_zm7n 450779 644583 2019-02-28 2018-09-30 219 18       8 245               245
1059 YUMA REGIONAL MEDICAL CENTER 2400 SOUTH AVENUE A YUMA AZ 85364 YUMA (928) 336-7600 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.6838990 -114.6332380 0   27 4 4027 49740   Central Yuma County https://data.medicare.gov/resource/xubh-q36u/row-vbe2.gm3a_7tw7 30013 644624 2019-02-28 2018-09-30 344 42       20 406               406
4645 BAYLOR SCOTT AND WHITE ALL SAINTS MEDICAL CENTER 1400 EIGHTH AVE FORT WORTH TX 76104 TARRANT (817) 926-2544 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.7302880 -97.3437290 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-99v8_22t5~zuq2 450137 643849 2019-02-28 2018-09-30 275 39       63 377               377
2515 SCRIPPS MERCY HOSPITAL 4077 5TH AVE SAN DIEGO CA 92103 SAN DIEGO (619) 294-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.7512110 -117.1610240 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-4xsr.mwt6-iirn 50077 644214 2019-02-28 2018-09-30 431 56         487 36             523
4176 BAPTIST MEDICAL CENTER-YAZOO 823 GRAND AVENUE YAZOO CITY MS 39194 YAZOO (662) 746-2261 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.8587300 -90.4033210 0   163 28 28163 27140 Jackson-Vicksburg-Brookhaven, MS Outlying Yazoo County https://data.medicare.gov/resource/xubh-q36u/row-i83f-pamk.mfmb 251313 643910 2019-02-28 2018-09-30 25           25               25
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
2513 SCRIPPS GREEN HOSPITAL 10666 NORTH TORREY PINES ROAD LA JOLLA CA 92037 SAN DIEGO (858) 455-9100 Acute Care Hospitals Voluntary non-profit - Other FALSE 32.8971240 -117.2418540 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-k5xn~6853~5e64 50424 644216 2019-02-28 2018-09-30 100 24         150               150
2505 SCRIPPS MEMORIAL HOSPITAL - ENCINITAS 354 SANTA FE DRIVE ENCINITAS CA 92024 SAN DIEGO (760) 753-6501 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.0362720 -117.2842370 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-wtw4-gvxp-bzi9 50503 644217 2019-02-28 2018-09-30 159 12         171   22           193
4710 GRAHAM REGIONAL MEDICAL CENTER 1301 MONTGOMERY ROAD GRAHAM TX 76450 YOUNG (940) 549-3400 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.0899730 -98.5843560 0   503 48 48503         https://data.medicare.gov/resource/xubh-q36u/row-zgck.cipi_69sb 450085 644359 2019-02-28 2018-09-30 25           25               25
3700 D C H REGIONAL MEDICAL CENTER 809 UNIVERSITY BOULEVARD EAST TUSCALOOSA AL 35401 TUSCALOOSA (205) 759-7111 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2061300 -87.5251540 0   125 1 1125 46220   Central Tuscaloosa County https://data.medicare.gov/resource/xubh-q36u/row-zssi.q234-yq7y 10092 644695 2019-02-28 2018-09-30 362 52 32       497 54 42           593
1058 CLAY COUNTY HOSPITAL 83825 HIGHWAY 9 P O BOX 1270 ASHLAND AL 36251 CLAY (256) 354-2131 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2765480 -85.8237890 0   27 1 1027         https://data.medicare.gov/resource/xubh-q36u/row-p2yh_2e24~5sth 10073 644085 2019-02-28 2018-09-30 42 4         46       83       129
2753 GREENWOOD LEFLORE HOSPITAL 1401 RIVER RD GREENWOOD MS 38935 LEFLORE (662) 459-7561 Acute Care Hospitals Government - Local TRUE 33.5182540 -90.2001890 0   83 28 28083 24900   Central Leflore County https://data.medicare.gov/resource/xubh-q36u/row-h4t8-zied.hz4k 250099 644302 2019-02-28 2018-09-30 164 9         173   20           193
4082 WEBSTER GENERAL HOSPITAL/ SWING BED 70 MEDICAL PLAZA EUPORA MS 39744 WEBSTER (662) 258-6221 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.5347360 -89.2669430 0   155 28 28155         https://data.medicare.gov/resource/xubh-q36u/row-a3qx_u9bd-sjek 250020 643797 2019-02-28 2018-09-30 38           38               38
2583 TRMC OF ORANGEBURG & CALHOUN 3000 ST MATTHEWS RD BOX 1806 ORANGEBURG SC 29115 ORANGEBURG (803) 533-2460 Acute Care Hospitals Government - Local FALSE 33.5401756 -80.8306233 1 ROOFTOP 75 45 45075 36700 Columbia-Orangeburg-Newberry, SC Central Orangeburg County https://data.medicare.gov/resource/xubh-q36u/row-n6wq.i5zs_x785 420068 645174 2019-02-28 2018-09-30 231 20         251 15 20           286
549 ABRAZO SCOTTSDALE CAMPUS 3929 EAST BELL ROAD PHOENIX AZ 85032 MARICOPA (602) 923-5000 Acute Care Hospitals Proprietary TRUE 33.6406030 -111.9976920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-3yrx.bcen.wd4a 30083 644698 2019-02-28 2018-09-30 113 14         127               127
2046 WADLEY REGIONAL MEDICAL CENTER AT HOPE 2001 SOUTH MAIN HOPE AR 71801 HEMPSTEAD (870) 722-3800 Acute Care Hospitals Proprietary TRUE 33.6480080 -93.5870520 0   57 5 5057         https://data.medicare.gov/resource/xubh-q36u/row-zn9u-sntu_5nuw 40153 643865 2019-02-28 2018-09-30 59 8         67 12             79
666 NORTHEAST ALABAMA REGIONAL MEDICAL CENTER 400 EAST 10TH STREET ANNISTON AL 36207 CALHOUN (256) 235-5121 Acute Care Hospitals Government - Local TRUE 33.6571230 -85.8233530 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-ima9~p9t8~qh92 10078 644086 2019-02-28 2018-09-30 232 18         250 20             270
667 STRINGFELLOW MEMORIAL HOSPITAL 301 EAST 18TH ST ANNISTON AL 36201 CALHOUN (256) 235-8900 Acute Care Hospitals Proprietary TRUE 33.6677010 -85.8250250 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-2tt8-gqrt.8qr7 10038 644691 2019-02-28 2018-09-30 119 6         125               125
2045 FAYETTE MEDICAL CENTER 1653 TEMPLE AVENUE NORTH FAYETTE AL 35555 FAYETTE (205) 932-5966 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.7077080 -87.8237060 0   57 1 1057         https://data.medicare.gov/resource/xubh-q36u/row-f7kw.zhbj_gfwf 10045 644692 2019-02-28 2018-09-30 37 8         45       122       167
3858 TALLAHATCHIE CRITICAL ACCESS HOSPITAL 201 SOUTH MARKET ST / PO BOX 230 CHARLESTON MS 38921 TALLAHATCHIE (662) 647-5535 Critical Access Hospitals Government - Local TRUE 34.0050790 -90.0581650 0   135 28 28135         https://data.medicare.gov/resource/xubh-q36u/row-avrr~zg9m~xqab 251304 644307 2019-02-28 2018-09-30 9           9               9
2663 PRISMA HEALTH BAPTIST 1330 TAYLOR AT MARION ST COLUMBIA SC 29220 RICHLAND (803) 296-5678 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0072270 -81.0337480 0   79 45 45079 17900 Columbia-Orangeburg-Newberry, SC Central Richland County https://data.medicare.gov/resource/xubh-q36u/row-b6nq~d5kh~rsiv 420086 643944 2019-02-28 2018-09-30 230 18       30 278 57             335
2665 PROVIDENCE HEALTH 120 GATEWAY CORPORATE BLVD COLUMBIA SC 29203 RICHLAND (803) 256-5300 Acute Care Hospitals Proprietary TRUE 34.1044220 -80.9550540 0   79 45 45079 17900 Columbia-Orangeburg-Newberry, SC Central Richland County https://data.medicare.gov/resource/xubh-q36u/row-4vdj-xj4s_we4k 420026 645172 2019-02-28 2018-09-30 273 18 32   9   332               332
2985 MARION REGIONAL MEDICAL CENTER 1256 MILITARY STREET SOUTH HAMILTON AL 35570 MARION (205) 921-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1258520 -87.9898060 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-ak6z-c9hr~7upb 10044 643754 2019-02-28 2018-09-30 32 4         36       79       115
4698 WILBARGER GENERAL HOSPITAL 920 HILLCREST DR VERNON TX 76384 WILBARGER (940) 552-9351 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1594190 -99.3133300 0   487 48 48487 46900   Central Wilbarger County https://data.medicare.gov/resource/xubh-q36u/row-5iha_7mw4.8q3u 450584 643852 2019-02-28 2018-09-30 47           47               47
680 CARTERSVILLE MEDICAL CENTER 960 JOE FRANK HARRIS PARKWAY CARTERSVILLE GA 30120 BARTOW (770) 387-8182 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1995441 -84.7932932 1 ROOFTOP 15 13 13015 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Bartow County https://data.medicare.gov/resource/xubh-q36u/row-w3nk-2vm4_5tut 110030 644712 2019-02-28 2018-09-30 98 21         119               119
792 MULESHOE AREA MEDICAL CENTER 708 S 1ST ST MULESHOE TX 79347 BAILEY (806) 272-4524 Critical Access Hospitals Proprietary TRUE 34.2210290 -102.7284580 0   17 48 48017         https://data.medicare.gov/resource/xubh-q36u/row-2yhf.nyid~b2dz 451372 644191 2019-02-28 2018-09-30 25           25               25
3021 MARSHALL MEDICAL CENTERS SOUTH CAMPUS 2505 U S HIGHWAY 431 NORTH BOAZ AL 35957 MARSHALL (256) 593-8310 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.2216880 -86.1607098 1 ROOFTOP 95 1 1095 10700 Huntsville-Decatur-Albertville, AL Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-qhdt_aeut-3iwd 10005 644081 2019-02-28 2018-09-30 184 20         204               204
3536 PONTOTOC HEALTH SERVICE CAH 176 SOUTH MAIN STREET PONTOTOC MS 38863 PONTOTOC (662) 489-5510 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2428270 -88.9968000 0   115 28 28115 46180   Outlying Pontotoc County https://data.medicare.gov/resource/xubh-q36u/row-cgtx~8fwc-42mt 251308 643801 2019-02-28 2018-09-30 25           25               25
2037 KERSHAWHEALTH 1315 ROBERTS STREET CAMDEN SC 29020 KERSHAW (803) 432-4311 Acute Care Hospitals Proprietary TRUE 34.2531640 -80.5895790 0   55 45 45055 17900 Columbia-Orangeburg-Newberry, SC Outlying Kershaw County https://data.medicare.gov/resource/xubh-q36u/row-938m.r575~tkt8 420048 643943 2019-02-28 2018-09-30 113 10         123           55   178
1810 COLUMBUS REGIONAL HEALTHCARE SYSTEM 500 JEFFERSON ST WHITEVILLE NC 28472 COLUMBUS (910) 642-8011 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.3386570 -78.6936440 0   47 37 37047         https://data.medicare.gov/resource/xubh-q36u/row-ucyn-b8wt_9jnp 340068 645347 2019-02-28 2018-09-30 144   10       154               154
2164 PRISMA HEALTH LAURENS COUNTY HOSPITAL 22725 HIGHWAY 76 EAST CLINTON SC 29325 LAURENS (864) 833-9100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.4797180 -81.9411520 0   59 45 45059 24860 Greenville-Spartanburg-Anderson, SC Outlying Laurens County https://data.medicare.gov/resource/xubh-q36u/row-qum6.2nj9-aisw 420038 643842 2019-02-28 2018-09-30 35   8       43       14       57
2547 PRISMA HEALTH OCONEE MEMORIAL HOSPITAL 102B OMNI DR SENECA SC 29672 OCONEE (864) 482-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.6971200 -82.9843850 0   73 45 45073 42860 Greenville-Spartanburg-Anderson, SC Central Oconee County https://data.medicare.gov/resource/xubh-q36u/row-59an~qtsq_49vv 420009 645167 2019-02-28 2018-09-30 110   12       122       120   15   257
2870 UNION MEDICAL CENTER 322 WEST SOUTH STREET UNION SC 29379 UNION (864) 301-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.7114380 -81.6286680 0   87 45 45087 43900 Greenville-Spartanburg-Anderson, SC Outlying Union County https://data.medicare.gov/resource/xubh-q36u/row-a8su_cikk-4j4z 420108 645181 2019-02-28 2018-09-30 43 6         49               49
1763 PRISMA HEALTH HILLCREST HOSPITAL 741 SOUTH EAST MAIN STREET SIMPSONVILLE SC 29681 GREENVILLE (864) 454-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7181340 -82.2467360 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-7tzq.68bi~s86f 420037 643841 2019-02-28 2018-09-30 37 6         43               43
3575 ARKANSAS HEART HOSPITAL, LLC 1701 S SHACKLEFORD ROAD LITTLE ROCK AR 72211 PULASKI (501) 219-7000 Acute Care Hospitals Proprietary TRUE 34.7391590 -92.3944210 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-jzxu~zre6.ev3c 40134 644703 2019-02-28 2018-09-30 112           112               112
4192 SCOTLAND MEMORIAL HOSPITAL 500 LAUCHWOOD DR LAURINBURG NC 28352 SCOTLAND (910) 291-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7517000 -79.4704200 0   165 37 37165 29900 Fayetteville-Lumberton-Laurinburg, NC Central Scotland County https://data.medicare.gov/resource/xubh-q36u/row-6cnv~bite_rawz 340008 645131 2019-02-28 2018-09-30 89 8         97   7           104
3836 ONSLOW MEMORIAL HOSPITAL 317 WESTERN BOULEVARD JACKSONVILLE NC 28540 ONSLOW (910) 577-2345 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7622850 -77.3825710 0   133 37 37133 27340   Central Onslow County https://data.medicare.gov/resource/xubh-q36u/row-87d3_vsb5~9wx6 340042 645133 2019-02-28 2018-09-30 148 14         162               162
4569 HAMILTON MEDICAL CENTER 1200 MEMORIAL DRIVE DALTON GA 30720 WHITFIELD (706) 272-6105 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7888840 -84.9836570 0   313 13 13313 19140 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Whitfield County https://data.medicare.gov/resource/xubh-q36u/row-43qf_bzq5_w6mu 110001 644112 2019-02-28 2018-09-30 212 26     8   246 18             264
3920 TISHOMINGO HEALTH SERVICES INC 1777 CURTIS DRIVE IUKA MS 38852 TISHOMINGO (662) 423-6051 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.8036860 -88.2092180 0   141 28 28141         https://data.medicare.gov/resource/xubh-q36u/row-8vqy~22mf_tvap 250002 643792 2019-02-28 2018-09-30 48           48               48
1759 PRISMA HEALTH GREENVILLE MEMORIAL HOSPITAL 905 VERDAE BLVD SUITE 102 GREENVILLE SC 29605 GREENVILLE (864) 455-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.8291560 -82.3192040 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-rfz9-6mpm-5bj3 420078 643844 2019-02-28 2018-09-30 526 58 28       682 46 53   18       799
1760 PRISMA HEALTH PATEWOOD HOSPITAL 175 PATEWOOD DRIVE GREENVILLE SC 29615 GREENVILLE (864) 797-1000 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.8527350 -82.3261150 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-6pw3~wdbm.z7ry 420102 643846 2019-02-28 2018-09-30 38           38               38
2766 PELHAM MEDICAL CENTER 250 WESTMORELAND ROAD GREER SC 29651 GREENVILLE (864) 560-6554 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8635100 -82.2176610 0   83 45 45083 43900 Greenville-Spartanburg-Anderson, SC Central Spartanburg County https://data.medicare.gov/resource/xubh-q36u/row-kc6n_96px_662r 420103 645180 2019-02-28 2018-09-30 44 4         48               48
1762 PRISMA HEALTH GREER MEMORIAL HOSPITAL 830 SOUTH BUNCOMBE ROAD GREER SC 29650 GREENVILLE (864) 848-8200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.9193100 -82.2420310 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-xcyi~2q2z~2aqn 420033 643840 2019-02-28 2018-09-30 49 8         57               57
186 MAGNOLIA REGIONAL HEALTH CENTER 611 ALCORN DRIVE CORINTH MS 38834 ALCORN (662) 293-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.9358670 -88.5586480 0   3 28 28003 18420   Central Alcorn County https://data.medicare.gov/resource/xubh-q36u/row-7e2c-erdj.3exa 250009 643795 2019-02-28 2018-09-30 139 24         163 19             182
2210 VIDANT DUPLIN HOSPITAL 401 N MAIN ST KENANSVILLE NC 28349 DUPLIN (910) 296-0941 Acute Care Hospitals Government - Local TRUE 34.9647690 -77.9604790 0   61 37 37061         https://data.medicare.gov/resource/xubh-q36u/row-3z8q-ur44-gq7x 340120 643929 2019-02-28 2018-09-30 40 9         49 25             74
2765 SPARTANBURG MEDICAL CENTER 101 E WOOD ST SPARTANBURG SC 29303 SPARTANBURG (864) 560-6554 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9678520 -81.9399270 0   83 45 45083 43900 Greenville-Spartanburg-Anderson, SC Central Spartanburg County https://data.medicare.gov/resource/xubh-q36u/row-hyp6-4fyv-sawi 420007 645166 2019-02-28 2018-09-30 410 19 20       493               493
4178 SAMPSON REGIONAL MEDICAL CENTER 607 BEAMAN ST CLINTON NC 28328 SAMPSON (910) 592-8511 Acute Care Hospitals Government - Local TRUE 35.0077830 -78.3236350 0   163 37 37163         https://data.medicare.gov/resource/xubh-q36u/row-a9b2_fhm6_47x6 340024 643924 2019-02-28 2018-09-30 63 8         71               71
3006 CAPE FEAR VALLEY HOKE HOSPITAL 210 MEDICAL PAVILION DRIVE RAEFORD NC 28376 HOKE (910) 904-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0314260 -79.1088240 0   93 37 37093 22180 Fayetteville-Lumberton-Laurinburg, NC Central Hoke County https://data.medicare.gov/resource/xubh-q36u/row-awx4~hxxz-7m7w 340188 643820 2019-02-28 2018-09-30 41           41               41
1915 CAPE FEAR VALLEY MEDICAL CENTER 1638 OWEN DRIVE P O BOX 2000 FAYETTEVILLE NC 28302 CUMBERLAND (910) 609-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0324120 -78.9310960 0   51 37 37051 22180 Fayetteville-Lumberton-Laurinburg, NC Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-9vgu~9uhh_eymv 340028 643815 2019-02-28 2018-09-30 492 48         584   72           656
3967 WHITE COUNTY MEDICAL CENTER 3214 EAST RACE AVENUE SEARCY AR 72143 WHITE (501) 278-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2504460 -91.6967580 0   145 5 5145 42620 Little Rock-North Little Rock, AR Central White County https://data.medicare.gov/resource/xubh-q36u/row-b6nk.pamh_stfx 40014 644701 2019-02-28 2018-09-30 192 13         205 30 37           272
2801 BETSY JOHNSON REGIONAL HOSPITAL 800 TILGHMAN DR DUNN NC 28334 HARNETT (910) 892-7161 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3065550 -78.6330880 0   85 37 37085 20380 Raleigh-Durham-Chapel Hill, NC Central Harnett County https://data.medicare.gov/resource/xubh-q36u/row-28jj~ikwb_xihf 340071 643818 2019-02-28 2018-09-30 137 14         151               151
3357 STARR REGIONAL MEDICAL CENTER ATHENS 1114 W MADISON AVE ATHENS TN 37371 MC MINN (423) 745-1411 Acute Care Hospitals Proprietary TRUE 35.4407890 -84.6088230 0   107 47 47107 11940 Chattanooga-Cleveland-Dalton, TN-GA-AL Central McMinn County https://data.medicare.gov/resource/xubh-q36u/row-j9r6~ujtq-iqfx 440068 644180 2019-02-28 2018-09-30 84 4         88 18     13 75     194
639 VIDANT BEAUFORT HOSPITAL 628 E 12TH ST WASHINGTON NC 27889 BEAUFORT (252) 975-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.5486620 -77.0388330 0   13 37 37013 47820 Greenville-Washington, NC Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-reur_4bn8-9x84 340186 644155 2019-02-28 2018-09-30 64 8         72 19             91
4005 VIDANT MEDICAL CENTER 2100 STANTONSBURG RD GREENVILLE NC 27834 PITT (252) 847-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6058100 -77.4009520 0   147 37 37147 24780 Greenville-Washington, NC Central Pitt County https://data.medicare.gov/resource/xubh-q36u/row-7q4f-6u6k_hghr 340040 643816 2019-02-28 2018-09-30 637 71         816 52 75           943
4315 WAKEMED 3000 NEW BERN AVE RALEIGH NC 27610 WAKE (919) 350-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7861390 -78.5890670 0   183 37 37183 39580 Raleigh-Durham-Chapel Hill, NC Central Wake County https://data.medicare.gov/resource/xubh-q36u/row-b29x_tvnt.h38s 340069 643817 2019-02-28 2018-09-30 445 12 38   9 10 585   98           683
3116 IREDELL MEMORIAL HOSPITAL INC 557 BROOKDALE DR P O BOX 1828 STATESVILLE NC 28677 IREDELL (704) 873-5661 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7998600 -80.8768170 0   97 37 37097 16740 Charlotte-Concord, NC-SC Central Iredell County https://data.medicare.gov/resource/xubh-q36u/row-tkwc.4vcn-pb6i 340039 645132 2019-02-28 2018-09-30 139 16         155       48       203
3117 DAVIS REGIONAL MEDICAL CENTER 218 OLD MOCKSBVILLE RD PO BOX 1823 STATESVILLE NC 28687 IREDELL (704) 873-0281 Acute Care Hospitals Proprietary TRUE 35.8186480 -80.8291896 1 ROOFTOP 97 37 37097 16740 Charlotte-Concord, NC-SC Central Iredell County https://data.medicare.gov/resource/xubh-q36u/row-ks69_qbdx-fr95 340144 645138 2019-02-28 2018-09-30 120 8         128 12             140
2317 VIDANT EDGECOMBE HOSPITAL 111 HOSPITAL DR TARBORO NC 27886 EDGECOMBE (252) 641-7700 Acute Care Hospitals Government - Local TRUE 35.9218850 -77.5569940 0   65 37 37065 40580 Rocky Mount-Wilson-Roanoke Rapids, NC Central Edgecombe County https://data.medicare.gov/resource/xubh-q36u/row-9nuq.ij7s_3aca 340107 643926 2019-02-28 2018-09-30 86 15         101   16           117
2031 THE OUTER BANKS HOSPITAL, INC 4800 SOUTH CROATAN HIGHWAY NAGS HEAD NC 27959 DARE (252) 449-4500 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9408620 -75.6169230 0   55 37 37055 28620 Virginia Beach-Norfolk, VA-NC Central Dare County https://data.medicare.gov/resource/xubh-q36u/row-ma9p_9398-dfyr 341324 644159 2019-02-28 2018-09-30 21           21               21
704 VIDANT BERTIE HOSPITAL 1403 SOUTH KINGS STREET WINDSOR NC 27983 BERTIE (252) 794-6600 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9893550 -76.9281830 0   15 37 37015         https://data.medicare.gov/resource/xubh-q36u/row-pwdr-dt5d-exsb 341304 644156 2019-02-28 2018-09-30 6           6               6

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