Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

4,766 rows sorted by hosp_lookup_url descending

View and edit SQL

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

Link rowid hospital_name address city state zip_code county_name phone_number hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url ▲ PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
2050 MEMORIAL HOSPITAL OF TAMPA 2901 W SWANN AVE TAMPA FL 33609 HILLSBOROUGH (813) 873-6400 Acute Care Hospitals Proprietary TRUE 27.9374430 -82.4898160 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-zzzr_828w.hedr 100206 659646 2019-11-12 2018-10-31 135 12         147 36             183
3221 TEMPLE UNIVERSITY HOSPITAL 3401 NORTH BROAD STREET PHILADELPHIA PA 19140 PHILADELPHIA (215) 707-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0046670 -75.1522000 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-zzyj_ydxk_mei6 390027 661088 2019-12-02 2019-06-30 473 43 18 10     598 118 16           732
4435 MEMORIAL HERMANN KATY HOSPITAL 23900 KATY FREEWAY KATY TX 77494 FORT BEND (281) 392-1111 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7859180 -95.7856570 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-zzwh.pxe4.wege 450847 649966 2019-06-03 2018-12-31 152 32       24 208               208
620 GREAT FALLS CLINIC HOSPITAL 3010 15TH AVENUE SOUTH GREAT FALLS MT 59405 CASCADE (406) 216-8000 Acute Care Hospitals Proprietary TRUE 47.4877370 -111.2545610 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-zzvw_fvcf~g44t 270086 651217 2019-06-03 2018-12-31 20           20               20
1869 SAINT VINCENT HOSPITAL 232 WEST 25TH STREET ERIE PA 16544 ERIE (814) 452-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1107080 -80.0799320 0   49 42 42049 21500 Erie-Meadville, PA Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-zzmm~9qqm.5743 390009 661964 2019-12-02 2019-06-30 237 20 20     21 298 10 22           330
2080 NOVANT HEALTH THOMASVILLE MEDICAL CENTER 207 OLD LEXINGTON RD BOX 789 THOMASVILLE NC 27360 DAVIDSON (336) 472-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8820290 -80.1113800 0   57 37 37057 49180 Greensboro--Winston-Salem--High Point, NC Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-zzec-ck9p~dm9q 340085 650340 2019-05-31 2018-12-31 61 13         74 45             119
2313 TRI VALLEY HEALTH SYSTEM 1305 WEST HIGHWAY 6/34 CAMBRIDGE NE 69022 FURNAS (308) 697-3329 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.2799040 -100.1796670 0   65 31 31065         https://data.medicare.gov/resource/xubh-q36u/row-zzb6-y5xk.yxhu 281348 654968 2019-10-02 2019-04-30 20           20           34   54
767 CAREPOINT HEALTH-CHRIST HOSPITAL 176 PALISADE AVE JERSEY CITY NJ 7306 HUDSON (201) 795-8200 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7348760 -74.0501420 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-zyny.ji2k-c7cs 310016 648953 2019-06-03 2018-12-31 160 18         178               178
1830 MIDDLE PARK MEDICAL CENTER 214 4TH ST KREMMLING CO 80459 GRAND (970) 724-3442 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0575000 -106.3911830 0   49 8 8049         https://data.medicare.gov/resource/xubh-q36u/row-zyfv.qfrq_5wh2 61318 649174 2019-05-30 2018-12-31 21           21               21
1129 GOOD SAMARITAN HOSPITAL 901 OLIVE DRIVE BAKERSFIELD CA 93308 KERN (661) 399-4461 Acute Care Hospitals Proprietary FALSE 35.4122580 -119.0394980 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-zy4z.wua9.kcip 50257 651798 2019-07-02 2018-12-31 39 4         43 21             64
916 CAPITAL HEALTH SYSTEM-FULD CAMPUS 750 BRUNSWICK AVE TRENTON NJ 8638 MERCER (609) 394-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2359870 -74.7527760 0   21 34 34021 45940 New York-Newark, NY-NJ-CT-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-zxwe~kidn_99ej 310092 650506 2019-05-31 2018-12-31 102 32         134 28             162
2438 COLORADO RIVER MEDICAL CENTER 1401 BAILEY AVE NEEDLES CA 92363 SAN BERNARDINO (760) 326-4531 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.8328360 -114.6183170 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-zxst-kiy5_rq6g 51323 646252 2019-04-08 2018-12-31 25           25               25
1986 PLEASANT VALLEY HOSPITAL 2520 VALLEY DRIVE POINT PLEASANT WV 25550 MASON (304) 675-4340 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8687050 -82.1244030 0   53 54 54053 38580   Central Mason County https://data.medicare.gov/resource/xubh-q36u/row-zxm3-f6hb.227g 510012 648368 2019-05-13 2018-09-30 89 5         94       100       194
3873 MUNSON HEALTHCARE OTSEGO MEMORIAL HOSPITAL 825 N CENTER AVE GAYLORD MI 49735 OTSEGO (989) 731-2100 Acute Care Hospitals Voluntary non-profit - Private FALSE 45.0353320 -84.6738870 0   137 26 26137         https://data.medicare.gov/resource/xubh-q36u/row-zxhp~mryj~sttn 230133 661011 2019-11-27 2019-06-30 42 4         46       34       80
4345 UNIVERSITY HOSPITAL MCDUFFIE 2460 WASHINGTON ROAD THOMSON GA 30824 MC DUFFIE (706) 595-1411 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5232260 -82.5044780 0   189 13 13189 12260   Outlying McDuffie County https://data.medicare.gov/resource/xubh-q36u/row-zx3a.iuqr.6aqx 110111 651197 2019-05-31 2018-12-31 25           25               25
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
83 KOHALA HOSPITAL 54-383 HOSPITAL ROAD KAPAAU HI 96755 HAWAII (808) 889-6211 Critical Access Hospitals Government - State TRUE 20.2317370 -155.7972530 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-zwx4_qya8~b57e 121302 662519 2019-11-29 2019-06-30 6           6       22       28
1512 L A DOWNTOWN MEDICAL CENTER 1711 WEST TEMPLE STREET LOS ANGELES CA 90026 LOS ANGELES (213) 989-6123 Acute Care Hospitals Proprietary FALSE 34.0687900 -118.2635600 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zwwh-h6yb.86z7 50763 650663 2019-05-31 2018-12-31 222 12         234               234
4037 MARLETTE REGIONAL HOSPITAL 2770 MAIN STREET MARLETTE MI 48453 SANILAC (989) 635-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3325790 -83.0801600 0   151 26 26151         https://data.medicare.gov/resource/xubh-q36u/row-zwdj_2e6m-nqmv 231330 661912 2019-12-04 2019-06-30 25           25       39   6   70
19 ASCENSION ST MARYS HOSPITAL 2251 NORTH SHORE DR RHINELANDER WI 54501 ONEIDA (715) 361-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6384820 -89.3111400 0   85 55 55085         https://data.medicare.gov/resource/xubh-q36u/row-zwaq-mmw6_zwbm 520019 661677 2019-11-27 2019-06-30 32 20         52 11             63
3341 EMANUEL MEDICAL CENTER 117 KITE ROAD SWAINSBORO GA 30401 EMANUEL (478) 289-1304 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.5932100 -82.3465520 0   107 13 13107         https://data.medicare.gov/resource/xubh-q36u/row-zwa9.bq43.jmum 110109 659232 2019-11-21 2019-06-30 37 8         45 15     49       109
2869 GEISINGER-LEWISTOWN HOSPITAL 400 HIGHLAND AVENUE LEWISTOWN PA 17044 MIFFLIN (717) 248-5411 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6178530 -77.5674020 0   87 42 42087 30380   Central Mifflin County https://data.medicare.gov/resource/xubh-q36u/row-zvsy_w3uq_vyfu 390048 660438 2019-11-27 2019-06-30 99 10         109 14             123
4724 MEDSTAR GOOD SAMARITAN HOSPITAL 5601 LOCH RAVEN BOULEVARD BALTIMORE MD 21239 BALTIMORE CITY (443) 444-3902 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3593010 -76.5886840 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-zvrw-pxqd~vwry 210056 659805 2019-11-26 2019-06-30 184 17         201               201
3134 MEMORIAL MEDICAL CENTER 1700 COFFEE RD MODESTO CA 95355 STANISLAUS (209) 526-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6687010 -120.9756740 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-zvpx~t5vq.tt29 50557 650654 2019-06-03 2018-12-31 372 35       12 419               419
2966 EAGLEVILLE HOSPITAL 100 EAGLEVILLE RD EAGLEVILLE PA 19408 MONTGOMERY (215) 539-6000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.1558800 -75.4119200 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-zvfs.t6e9.gp6r 390278 660447 2019-12-03 2019-06-30 49           49 34             83
4039 SWIFT COUNTY BENSON HOSPITAL 1815 WISCONSIN AVENUE BENSON MN 56215 SWIFT (320) 843-4232 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.3147570 -95.6089520 0   151 27 27151         https://data.medicare.gov/resource/xubh-q36u/row-zvec-8b67_2ine 241365 651013 2019-06-04 2018-12-31 18           18               18
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
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
2145 MOUNTAINVIEW MEDICAL CENTER 16 W MAIN ST WHITE SULPHUR SPRING MT 59645 MEAGHER (406) 547-3321 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5482070 -110.9042160 0   59 30 30059         https://data.medicare.gov/resource/xubh-q36u/row-zun9~ym5y~9aqt 271306 658907 2019-11-12 2019-06-30 25           25               25
2622 ST LUKE'S HOSPITAL BETHLEHEM 801 OSTRUM STREET BETHLEHEM PA 18015 NORTHAMPTON (610) 954-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6086970 -75.3925070 0   77 42 42077 10900 New York-Newark, NY-NJ-CT-PA Central Lehigh County https://data.medicare.gov/resource/xubh-q36u/row-zugg_buef.dyst 390049 660014 2019-12-02 2019-06-30 423 14 14       482 38 22           542
3175 MH ST ELIZABETH BOARDMAN HOSPITAL 8401 MARKET STREET BOARDMAN OH 44512 MAHONING (330) 729-2929 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.9949560 -80.6627440 0   99 39 39099 49660 Youngstown-Warren, OH-PA Central Mahoning County https://data.medicare.gov/resource/xubh-q36u/row-zues-ehaf-ss3m 360276 648461 2019-05-21 2018-12-31 188 18         206               206
2420 ASCENSION SACRED HEART HOSPITAL 401 W MOHAWK DR SUITE 100 TOMAHAWK WI 54487 LINCOLN (715) 453-7700 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.4890060 -89.7335960 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-zubv-e9fv-qs3r 521313 661446 2019-11-27 2019-06-30 15           15               15
820 EASTERN IDAHO REGIONAL MEDICAL CENTER 3100 CHANNING WAY IDAHO FALLS ID 83404 BONNEVILLE (208) 529-6210 Acute Care Hospitals Proprietary TRUE 43.4702760 -111.9901590 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-zu9m_rfwy-xxuk 130018 644978 2019-02-28 2018-09-30 165 35         226 28 17       10   310
1161 LINTON HOSPITAL - CAH 518 NORTH BROADWAY LINTON ND 58552 EMMONS (701) 254-4511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.2710630 -100.2328710 0   29 38 38029         https://data.medicare.gov/resource/xubh-q36u/row-zu7c~i74a~kiv4 351328 651912 2019-07-15 2019-03-31 14           14               14
1761 SHRINERS HOSPITALS FOR CHILDREN 950 WEST FARIS ROAD GREENVILLE SC 29605 GREENVILLE (864) 271-3444 Childrens Voluntary non-profit - Private FALSE 34.8160620 -82.4129680 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-zu5m.xbpi~47ak 423300 652674 2019-05-30 2018-12-31                              
2483 PROVIDENCE NEWBERG MEDICAL CENTER 1001 PROVIDENCE DRIVE NEWBERG OR 97132 YAMHILL (503) 537-1555 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.3085520 -122.9339130 0   71 41 41071 38900 Portland-Vancouver-Salem, OR-WA Outlying Yamhill County https://data.medicare.gov/resource/xubh-q36u/row-zttx-g4s5_qqvh 380037 648647 2019-05-22 2018-12-31 36 4         40               40
4161 BEAUMONT HOSPITAL - DEARBORN 18101 OAKWOOD BLVD DEARBORN MI 48124 WAYNE (313) 593-7125 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2919120 -83.2119510 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-ztpu-56gx~ymuj 230020 654674 2019-09-23 2018-12-31 486 17 34     30 567               567
463 SOUTH COUNTY HOSPITAL INC 100 KENYON AVE WAKEFIELD RI 2879 WASHINGTON (401) 782-8020 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4318830 -71.4958820 0   9 44 44009 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ztkr.arxn.8ucp 410008 645608 2019-03-01 2018-09-30 71 8         79               79
1773 MERCY HOSPITAL TURNER MEMORIAL 801 WEST RIVER STREET OZARK AR 72949 FRANKLIN (479) 667-4138 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.4861180 -93.8338050 0   47 5 5047         https://data.medicare.gov/resource/xubh-q36u/row-ztbc-aceq_xeqj 41303 660745 2019-12-04 2019-06-30 25           25               25
1864 MOUNT CARMEL ST ANN'S 500 SOUTH CLEVELAND AVENUE WESTERVILLE OH 43081 FRANKLIN (614) 898-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1143740 -82.9489090 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-zt85_iihf.a6ks 360012 660662 2019-11-26 2019-06-30 231 12 30   11   284               284
411 MIDSTATE MEDICAL CENTER 435 LEWIS AVENUE MERIDEN CT 6450 NEW HAVEN (203) 694-8200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5500360 -72.8038780 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-zt5t~v5nn~ebtg 70017 645528 2019-03-14 2018-09-30 143           143               143
2919 MARGARET R PARDEE MEMORIAL HOSPITAL 800 N JUSTICE ST HENDERSONVILLE NC 28791 HENDERSON (828) 696-1000 Acute Care Hospitals Government - Local TRUE 35.3208140 -82.4681530 0   89 37 37089 11700 Asheville-Brevard, NC Central Henderson County https://data.medicare.gov/resource/xubh-q36u/row-zt42_agis.ksd3 340017 658528 2018-11-29 2018-06-30 147 13         160               160
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
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
1957 CHILDREN'S HOSPITALS & CLINICS OF MN 2525 CHICAGO AVENUE SOUTH MINNEAPOLIS MN 55404 HENNEPIN (612) 813-6112 Childrens Voluntary non-profit - Private TRUE 44.9562370 -93.2625880 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-zsi6-wyrh~wxd5 243302 662539 2019-12-06 2018-12-31 151 42 25     196 414               414
389 THE MIRIAM HOSPITAL 164 SUMMIT AVENUE PROVIDENCE RI 2906 PROVIDENCE (401) 793-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8516530 -71.3975620 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-zsdr~jsyr_9q9c 410012 645014 2019-03-19 2018-09-30 202 36 9       247               247
1671 ST JOSEPH REGIONAL HEALTH CENTER 2801 FRANCISCAN DR BRYAN TX 77802 BRAZOS (979) 776-3912 Acute Care Hospitals Voluntary non-profit - Private FALSE 30.6555260 -96.3476380 0   41 48 48041 17780   Central Brazos County https://data.medicare.gov/resource/xubh-q36u/row-zs72.9n7k-uvcg 450011 660049 2019-12-03 2019-06-30 189 20         209               209
295 CARSON VALLEY MEDICAL CENTER 1107 HIGHWAY 395 GARDNERVILLE NV 89410 DOUGLAS (775) 782-1500 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9195628 -119.7189852 1 ROOFTOP 5 32 32005 23820 Reno-Carson City-Fernley, NV Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-zs3t-b2ik_qdz7 291306 650728 2019-05-31 2018-12-31 23           23               23
3959 OKLAHOMA STATE UNIVERSITY MEDICAL CENTER 744 WEST 9TH STREET TULSA OK 74127 TULSA (918) 599-1000 Acute Care Hospitals Government - State TRUE 36.1468360 -96.0001190 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-zrhv~9hmr~mtje 370078 660429 2019-11-29 2019-06-30 138 33         171               171
4002 WALTHALL COUNTY GENERAL HOSPITAL CAH 100 HOSPITAL DRIVE TYLERTOWN MS 39667 WALTHALL (601) 876-2122 Critical Access Hospitals Government - Local TRUE 31.1195830 -90.1556180 0   147 28 28147         https://data.medicare.gov/resource/xubh-q36u/row-zr2m~67zx~8i4c 251324 652148 2019-07-29 2018-09-30 25           25               25
4210 MARIETTA MEMORIAL HOSPITAL 401 MATTHEW STREET MARIETTA OH 45750 WASHINGTON (740) 374-1400 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.4316210 -81.4647170 0   167 39 39167 31930 Parkersburg-Marietta-Vienna, WV-OH Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-zqz7-qien-p9my 360147 653716 2019-08-16 2018-09-30 177 11         188 17             205
4576 FORT DUNCAN MEDICAL CENTER 3333 N FOSTER MALDONADO BLVD EAGLE PASS TX 78852 MAVERICK (830) 773-5321 Acute Care Hospitals Proprietary TRUE 28.7114180 -100.4541050 0   323 48 48323 20580   Central Maverick County https://data.medicare.gov/resource/xubh-q36u/row-zqqu-eqhh-2cw6 450092 648764 2019-05-28 2018-12-31 76 10         86   15           101
563 CHANDLER REGIONAL MEDICAL CENTER 1955 WEST FRYE ROAD CHANDLER AZ 85224 MARICOPA (480) 728-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.2986910 -111.8735080 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-zqcn.hhh2-gsee 30036 659471 2019-11-18 2019-01-31 277 49         338               338
1914 NICHOLAS H NOYES MEMORIAL HOSPITAL 111 CLARA BARTON STREET DANSVILLE NY 14437 LIVINGSTON (585) 335-6001 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5521300 -77.7003560 0   51 36 36051 40380 Rochester-Batavia-Seneca Falls, NY Outlying Livingston County https://data.medicare.gov/resource/xubh-q36u/row-zq8i~t3xi-qed5 330238 650604 2019-06-27 2018-12-31 67           67               67
3719 BEAUMONT HOSPITAL, TROY 44201 DEQUINDRE ROAD TROY MI 48085 OAKLAND (248) 964-8800 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6182284 -83.0926592 1 ROOFTOP 125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-zq26-fgkp_w6se 230269 654849 2019-09-24 2018-12-31 439 56         495   25           520
4049 FISHER COUNTY HOSPITAL DISTRICT 774 STATE HIGHWAY 70 N ROTAN TX 79546 FISHER (325) 735-2256 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.8343420 -100.4354190 0   151 48 48151         https://data.medicare.gov/resource/xubh-q36u/row-zpz3-mc6s_tqpq 451313 652799 2019-08-21 2018-12-31 14           14               14
2389 MEDICAL CENTER OF THE ROCKIES 2500 ROCKY MOUNTAIN AVENUE LOVELAND CO 80538 LARIMER (970) 624-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4151940 -105.0014510 0   69 8 8069 22660   Central Larimer County https://data.medicare.gov/resource/xubh-q36u/row-zpsq-figy~e5ag 60119 659764 2019-11-26 2019-06-30 142 20 12       174               174
4613 TEXAS HEALTH PRESBYTERIAN HOSPITAL ROCKWALL 3150 HORIZON ROAD ROCKWALL TX 75032 ROCKWALL (469) 698-1000 Acute Care Hospitals Proprietary TRUE 32.8861320 -96.4647540 0   397 48 48397 19100 Dallas-Fort Worth, TX-OK Central Rockwall County https://data.medicare.gov/resource/xubh-q36u/row-zpnd~t3wy-krmf 670044 651257 2019-06-21 2018-12-31 47 6         53               53
3494 TEXAS INSTITUTE FOR SURGERY AT PRESBYTERIAN HOSPIT 7115 GREENVILLE AVENUE SUITE 100 DALLAS TX 75231 DALLAS (214) 647-5300 Acute Care Hospitals Proprietary TRUE 32.8763770 -96.7617260 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-zpaw~2v5b-8gcc 450889 646976 2019-04-26 2018-12-31 9           9               9
3790 BERGER HOSPITAL 600 NORTH PICKAWAY STREET CIRCLEVILLE OH 43113 PICKAWAY (740) 420-8020 Acute Care Hospitals Government - Local TRUE 39.6102810 -82.9377470 0   129 39 39129 18140 Columbus-Marion-Zanesville, OH Outlying Pickaway County https://data.medicare.gov/resource/xubh-q36u/row-zp45_7tue~gsqz 360170 655646 2019-10-23 2019-03-31 75 8         83               83
4699 BAYLOR SCOTT & WHITE MEDICAL CENTER -TAYLOR 305 MALLARD TAYLOR TX 76574 WILLIAMSON (512) 352-7611 Critical Access Hospitals Voluntary non-profit - Private TRUE 30.5919310 -97.4152650 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-znyt.enh8-549n 451374 651595 2019-05-31 2018-12-31 25           25               25
2002 REGIONAL MEDICAL CENTER 709 W MAIN STREET MANCHESTER IA 52057 DELAWARE (563) 927-3232 Critical Access Hospitals Proprietary TRUE 42.4839030 -91.4666440 0   55 19 19055         https://data.medicare.gov/resource/xubh-q36u/row-znx9.yjf2.jpru 161343 660219 2019-11-25 2019-06-30 25           25           1   26
1537 MEMORIAL HOSPITAL AND HEALTH CARE CENTER 800 W 9TH ST JASPER IN 47546 DUBOIS (812) 996-2345 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.3937430 -86.9412810 0   37 18 18037 27540   Central Dubois County https://data.medicare.gov/resource/xubh-q36u/row-znqj_58gv~pyf2 150115 660942 2019-12-02 2019-06-30 85 26         111 19 8   14       152
1091 CHILTON MEDICAL CENTER 97 WEST PARKWAY POMPTON PLAINS NJ 7444 MORRIS (973) 831-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9592370 -74.3081020 0   27 34 34027 35620 New York-Newark, NY-NJ-CT-PA Central Morris County https://data.medicare.gov/resource/xubh-q36u/row-znqi_gj8a.dwf2 310017 648954 2019-05-30 2018-12-31 159 12       4 175               175
1331 UNITED MEDICAL CENTER 1310 SOUTHERN AVENUE SE WASHINGTON DC 20032 THE DISTRICT (202) 574-6611 Acute Care Hospitals Proprietary TRUE 38.8341550 -76.9846980 0   33 24 24033 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Prince George's County https://data.medicare.gov/resource/xubh-q36u/row-zng6.qzhh.7sfd 90008 645634 2019-03-01 2018-09-30 180 16         196               196
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
3595 MINDEN MEDICAL CENTER NO 1 MEDICAL PLAZA MINDEN LA 71055 WEBSTER (318) 377-2321 Acute Care Hospitals Proprietary TRUE 32.6172391 -93.2863556 1 ROOFTOP 119 22 22119 43340   Outlying Webster Parish https://data.medicare.gov/resource/xubh-q36u/row-zn8k~yqhx.sjt5 190144 657128 2019-01-03 2018-07-31 113 10         125 20 12           157
3333 PICKENS COUNTY MEDICAL CENTER 241 ROBERT K WILSON DRIVE CARROLLTON AL 35447 PICKENS (205) 367-8111 Acute Care Hospitals Government - Local TRUE 33.2748070 -88.0896730 0   107 1 1107 46220   Outlying Pickens County https://data.medicare.gov/resource/xubh-q36u/row-zn5h.i3rc.njwh 10109 644006 2019-03-01 2018-09-30 36 4         40 10             50
3365 FLAGLER HOSPITAL 400 HEALTH PARK BLVD SAINT AUGUSTINE FL 32086 ST. JOHNS (904) 819-4426 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.8626160 -81.3174800 0   109 12 12109 27260 Jacksonville-St. Marys-Palatka, FL-GA Outlying St. Johns County https://data.medicare.gov/resource/xubh-q36u/row-zn28_9hgz_mr5u 100090 652741 2019-07-31 2018-09-30 281 47       7 335               335
3436 PERHAM HEALTH 1000 CONEY STREET WEST PERHAM MN 56573 OTTER TAIL (218) 347-1301 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.5926850 -95.5951650 0   111 27 27111 22260   Central Otter Tail County https://data.medicare.gov/resource/xubh-q36u/row-zmw6~bp7u-2zf8 241373 643422 2019-02-22 2018-09-30 25           25       96       121
4428 HOUSTON METHODIST WILLOWBROOK HOSPITAL 18220 TOMBALL PARKWAY HOUSTON TX 77070 HARRIS (281) 477-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.9640590 -95.5507890 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-zmvm.hxwj~8hgy 450844 649965 2019-06-03 2018-12-31 281 32         313               313
2700 CHRISTUS COUSHATTA HEALTH CARE CENTER 1635 MARVEL STREET COUSHATTA LA 71019 RED RIVER (318) 932-2000 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0216580 -93.3437340 0   81 22 22081         https://data.medicare.gov/resource/xubh-q36u/row-zmg8-cgqs~6zge 191312 659797 2019-11-26 2019-06-30 25           25               25
3816 ADENA PIKE MEDICAL CENTER 100 DAWN LANE WAVERLY OH 45690 PIKE (740) 947-2186 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1165050 -83.0058270 0   131 39 39131         https://data.medicare.gov/resource/xubh-q36u/row-zm47~vagh-p87t 361334 649331 2019-05-31 2018-12-31 25           25               25
205 ORTHOPEDIC SPECIALTY HOSPITAL OF NEVADA 8656 WEST PATRICK LANE LAS VEGAS NV 89148 CLARK (702) 777-7100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.0778110 -115.2810360 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-zknv_98at.vvbk 290056 645924 2019-03-28 2018-10-31 130           130               130
2297 ST VINCENT GENERAL HOSPITAL DISTRICT 822 W 4TH ST LEADVILLE CO 80461 LAKE (719) 486-0230 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2443920 -106.3033020 0   65 8 8065         https://data.medicare.gov/resource/xubh-q36u/row-zkkb~2fq8_8dib 61319 648894 2019-05-30 2018-12-31 8           8               8
4394 WARM SPRINGS MEDICAL CENTER 5995 SPRING STREET WARM SPRINGS GA 31830 MERIWETHER (706) 655-9351 Critical Access Hospitals Voluntary non-profit - Other TRUE 32.8906520 -84.6829110 0   199 13 13199 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Meriwether County https://data.medicare.gov/resource/xubh-q36u/row-zkjq-ab6q-8vh9 111316 651203 2019-06-03 2018-12-31 25           25       79       104
1383 ADVENTHEALTH PALM COAST 60 MEMORIAL MEDICAL PKWY PALM COAST FL 32164 FLAGLER (386) 586-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.4789870 -81.1900890 0   35 12 12035 19660 Orlando-Deltona-Daytona Beach, FL Central Flagler County https://data.medicare.gov/resource/xubh-q36u/row-zkit_irst-fsuv 100118 649415 2019-05-30 2018-12-31 81 18         99           32   131
1501 SHRINERS HOSPITALS FOR CHILDREN 3160 GENEVA STREET LOS ANGELES CA 90020 LOS ANGELES (213) 388-3151 Childrens Voluntary non-profit - Private FALSE 34.0677080 -118.2863870 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zkfj-xhi2.ce89 53310 655536 2018-05-31 2017-12-31                              
4432 SHRINERS HOSPITALS FOR CHILDREN 6977 MAIN STREET HOUSTON TX 77030 HARRIS (713) 797-1616 Childrens Voluntary non-profit - Other FALSE 29.7047380 -95.4061740 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-zk7z~jazy_wtka 453312 651360 2018-07-12 2017-12-31                              
4457 PROVIDENCE MEDICAL CENTER 8929 PARALLEL PARKWAY KANSAS CITY KS 66112 WYANDOTTE (913) 596-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1285820 -94.7863290 0   209 20 20209 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Wyandotte County https://data.medicare.gov/resource/xubh-q36u/row-zk3n_vcvk.j3ej 170146 648830 2019-05-29 2018-12-31 148 23         171       45       216
309 ALLEGHANY COUNTY MEMORIAL HOSPITAL 617 DOCTORS STREET SPARTA NC 28675 ALLEGHANY (336) 372-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.5095115 -81.1150447 1 RANGE_INTERPOLATED 5 37 37005         https://data.medicare.gov/resource/xubh-q36u/row-zjv8.p46n-e733 341320 645140 2019-03-04 2018-09-30 25           25               25
1246 PRESENCE SAINTS MARY AND ELIZABETH MEDICAL CENTER 2233 W DIVISION ST CHICAGO IL 60622 COOK (312) 770-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9031040 -87.6832130 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-zjn9~e8qn.h99n 140180 661868 2019-12-02 2019-06-30 344 26         370 14 15   30       429
626 NEW LONDON HOSPITAL 273 COUNTY ROAD NEW LONDON NH 3257 MERRIMACK (603) 526-2911 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4209290 -72.0014930 0   13 33 33013 18180 Boston-Worcester-Providence, MA-RI-NH-CT Central Merrimack County https://data.medicare.gov/resource/xubh-q36u/row-ziwd~85nn_5vv5 301304 661553 2019-12-02 2019-06-30 25           25               25
3122 HILLCREST HOSPITAL PRYOR 111 NORTH BAILEY STREET PRYOR OK 74361 MAYES (918) 825-1600 Acute Care Hospitals Proprietary TRUE 36.3082740 -95.3053880 0   97 40 40097         https://data.medicare.gov/resource/xubh-q36u/row-zivh.t584.w3vu 370015 653268 2019-08-30 2019-03-31 24           24               24
1552 UNITED MEMORIAL MEDICAL CENTER 127 NORTH STREET BATAVIA NY 14020 GENESEE (585) 343-6030 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.0039970 -78.1775920 0   37 36 36037 12860 Rochester-Batavia-Seneca Falls, NY Central Genesee County https://data.medicare.gov/resource/xubh-q36u/row-zitz.a8b6_y8c2 330073 651023 2019-06-03 2018-12-31 123 10         133               133
827 CHRISTUS OCHSNER LAKE AREA HOSPITAL 4200 NELSON ROAD LAKE CHARLES LA 70605 CALCASIEU (337) 474-6370 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1820710 -93.2493480 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-ziqv.tyfx-mhvz 190201 660808 2019-11-26 2019-06-30 80 8       20 108               108
1918 WISHEK COMMUNITY HOSPITAL 1007 4TH AVE S WISHEK ND 58495 MCINTOSH (701) 452-2326 Critical Access Hospitals Government - Local TRUE 46.2551230 -99.5515380 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-zinj~5aa6.fhse 351321 648453 2019-05-20 2018-12-31 24           24               24
3197 MORTON PLANT NORTH BAY HOSPITAL 6600 MADISON ST NEW PORT RICHEY FL 34652 PASCO (727) 842-8468 Acute Care Hospitals Voluntary non-profit - Private FALSE 28.2539330 -82.7154780 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-zigd-ajc4_xtbp 100063 649411 2019-05-31 2018-12-31 165 22         187   30           217
3853 ST VINCENT RANDOLPH HOSPITAL INC 473 E GREENVILLE AVE WINCHESTER IN 47394 RANDOLPH (765) 584-0004 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1678770 -84.9703940 0   135 18 18135         https://data.medicare.gov/resource/xubh-q36u/row-ziei~9dqq.tkpr 151301 660946 2019-12-02 2019-06-30 25           25               25
390 WOMEN & INFANTS HOSPITAL OF RHODE ISLAND 101 DUDLEY STREET PROVIDENCE RI 2905 PROVIDENCE (401) 274-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8102000 -71.4115620 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-zi7i_8chg~f7hp 410010 644177 2019-02-28 2018-09-30 167         80 247               247
3345 BAPTIST HEALTH MADISONVILLE 900 HOSPITAL DRIVE MADISONVILLE KY 42431 HOPKINS (270) 825-5100 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3391770 -87.4938450 0   107 21 21107 31580   Central Hopkins County https://data.medicare.gov/resource/xubh-q36u/row-zhzt~n7d3_rubk 180093 655628 2019-10-16 2018-08-31 118 19       6 143 18 12           173
969 JFK MEDICAL CTR - ANTHONY M. YELENCSICS COMMUNITY 65 JAMES STREET EDISON NJ 8818 MIDDLESEX (732) 321-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5578700 -74.3494990 0   23 34 34023 35620 New York-Newark, NY-NJ-CT-PA Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-zhxr.nkau-6xsq 310108 654971 2019-10-11 2018-12-31 319   38       357   90       5   452
3397 ONECORE HEALTH 1044 SW 44TH, SUITE 350 OKLAHOMA CITY OK 73109 OKLAHOMA (405) 631-3085 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.4207290 -97.5338680 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-zhp9.4kgr_ytfs 370220 651480 2019-05-29 2018-12-31 8           8               8
3810 ASPIRUS ONTONAGON HOSPITAL, INC 601 S SEVENTH ST ONTONAGON MI 49953 ONTONAGON (906) 884-8000 Critical Access Hospitals Government - Local TRUE 46.8656350 -89.3029760 0   131 26 26131         https://data.medicare.gov/resource/xubh-q36u/row-zhnw-wptd-d4w4 231309 660103 2019-11-26 2019-06-30 25           25       46       71
3115 JOHNSON COUNTY HOSPITAL 202 HIGH ST TECUMSEH NE 68450 JOHNSON (402) 335-3361 Critical Access Hospitals Government - Local TRUE 40.3791920 -96.1973420 0   97 31 31097         https://data.medicare.gov/resource/xubh-q36u/row-zhkd~ybts_qztb 281350 659707 2019-11-18 2019-06-30 18           18               18
901 MAYO REGIONAL HOSPITAL 897 WEST MAIN STREET DOVER FOXCROFT ME 4426 PISCATAQUIS (207) 564-4251 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.1865560 -69.2377980 0   21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-zhbf-zz89~t9dz 201309 645562 2019-03-04 2018-09-30 25           25               25
1582 MADERA COMMUNITY HOSPITAL 1250 E ALMOND AVE MADERA CA 93637 MADERA (559) 675-5555 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.9454270 -120.0454670 0   39 6 6039 31460 Fresno-Madera, CA Central Madera County https://data.medicare.gov/resource/xubh-q36u/row-zgse.huz6_3uyv 50568 656247 2018-12-12 2018-06-30 96 10         106               106
3659 TEXAS HEALTH PRESBYTERIAN HOSPITAL DENTON 3000 N I-35 DENTON TX 76201 DENTON (940) 898-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2158990 -97.1684090 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-zgka~geeq~8cey 450743 654761 2019-09-30 2019-04-30 166 20       10 196               196
3980 CENTRACARE HEALTH SYSTEM - MELROSE HOSPITAL 525 WEST MAIN STREET MELROSE MN 56352 STEARNS (320) 256-1761 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6749160 -94.8234350 0   145 27 27145 41060 Minneapolis-St. Paul, MN-WI Central Stearns County https://data.medicare.gov/resource/xubh-q36u/row-zgd7-nfj6_jc2g 241330 660610 2019-11-27 2019-06-30 14           14       75       89
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

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