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

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
3 WEEKS MEDICAL CENTER 173 MIDDLE STREET LANCASTER NH 3584 COOS (603) 788-4911 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4869900 -71.5541560 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-4k9b_taaw_pmup 301303 643920 2019-02-28 2018-09-30 22 3         25               25
62 ST VINCENT'S MEDICAL CENTER 2800 MAIN ST BRIDGEPORT CT 6606 FAIRFIELD (203) 576-5551 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.2000830 -73.2024860 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-fzpd_79fu~rdpp 70028 645052 2019-02-28 2018-09-30 186 14         200 88 10           298
104 LAKES REGION GENERAL HOSPITAL 80 HIGHLAND ST LACONIA NH 3246 BELKNAP (603) 524-3211 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5281030 -71.4607710 0   1 33 33001 29060 Boston-Worcester-Providence, MA-RI-NH-CT Central Belknap County https://data.medicare.gov/resource/xubh-q36u/row-xfbk~rfzq_m6dx 300005 644140 2019-02-28 2018-09-30 76 10         86 10             96
148 HEBREW HOME AND HOSPITAL INC 1 ABRAHMS BOULEVARD WEST HARTFORD CT 6117 HARTFORD (860) 523-3800 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.8027740 -72.7289310 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-eqjh_iqnh-wsnp 70040 645324 2019-02-28 2018-09-30 23           23 22             45
177 NORTHERN MAINE MEDICAL CENTER 194 E MAIN STREET FORT KENT ME 4743 AROOSTOOK (207) 834-3195 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2650680 -68.5911770 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-cr45-cm3b-wfye 200052 645099 2019-02-28 2018-09-30 43           43 6     45       94
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
241 KENT COUNTY MEMORIAL HOSPITAL 455 TOLL GATE RD WARWICK RI 2886 KENT (401) 737-7010 Acute Care Hospitals Proprietary TRUE 41.7044780 -71.4779020 0   3 44 44003 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-cxmm.944u~3iqc 410009 644655 2019-02-28 2018-09-30 308 15         323   20           343
247 SOUTHWESTERN VERMONT MEDICAL CENTER 100 HOSPITAL DRIVE BENNINGTON VT 5201 BENNINGTON (802) 442-6361 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8739110 -73.2043430 0   3 50 50003 13540   Central Bennington County https://data.medicare.gov/resource/xubh-q36u/row-jv4q-u445-esay 470012 644194 2019-02-28 2018-09-30 68 10         78               78
263 SHARON HOSPITAL 50 HOSPITAL HILL ROAD SHARON CT 6069 LITCHFIELD (860) 364-4228 Acute Care Hospitals Proprietary TRUE 41.8796620 -73.4815720 0   5 9 9005 45860 New York-Newark, NY-NJ-CT-PA Central Litchfield County https://data.medicare.gov/resource/xubh-q36u/row-cvhr-qzru_z9ev 70004 658178 2019-02-28 2018-09-30 55 11         66 12             78
264 CHARLOTTE HUNGERFORD HOSPITAL 540 LITCHFIELD ST TORRINGTON CT 6790 LITCHFIELD (860) 496-6666 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7908460 -73.1331430 0   5 9 9005 45860 New York-Newark, NY-NJ-CT-PA Central Litchfield County https://data.medicare.gov/resource/xubh-q36u/row-3jtm_3puv.aqur 70011 645050 2019-02-28 2018-09-30 81 10         91 17             108
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
358 MARTHA'S VINEYARD HOSPITAL INC ONE HOSPITAL ROAD, FIRST FL, WING 5, PO BOX 1477 OAK BLUFFS MA 2557 DUKES (508) 693-0410 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4570063 -70.5517789 1 APPROXIMATE 7 25 25007 47240   Central Dukes County https://data.medicare.gov/resource/xubh-q36u/row-ym84.mbv4~ifss 221300 644287 2019-02-28 2018-09-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
395 UNIVERSITY OF VERMONT MEDICAL CENTER 111 COLCHESTER AVE BURLINGTON VT 5401 CHITTENDEN (802) 847-0000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.4809910 -73.1955180 0   7 50 50007 15540   Central Chittenden County https://data.medicare.gov/resource/xubh-q36u/row-sa3g~qvqf.2559 470003 643744 2019-02-28 2018-09-30 349 21     25   415   35           450
408 SAINT MARY'S HOSPITAL 56 FRANKLIN STEET WATERBURY CT 6706 NEW HAVEN (203) 709-6020 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.5525708 -73.0364301 1 ROOFTOP 9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-ir6v~snu4~uk6s 70016 644222 2019-02-28 2018-09-30 119 16 8       152 12             164
415 MASONICARE HEALTH CENTER 22 MASONIC AVE WALLINGFORD CT 6492 NEW HAVEN (203) 679-5900 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.4606980 -72.8365860 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-qb4p-gu4j_xpz9 70039 645323 2019-02-28 2018-09-30 30           30 29     366   86   511
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
433 ELLINWOOD DISTRICT HOSPITAL 605 N MAIN STREET ELLINWOOD KS 67526 BARTON (620) 564-2548 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3607070 -98.5811930 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-kt5p.cy3y_6d85 171301 661185 2019-02-28 2018-09-30 25           25               25
438 NORTHERN LIGHT BLUE HILL MEMORIAL HOSPITAL 57 WATER STREET BLUE HILL ME 4614 HANCOCK (207) 374-2836 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4114200 -68.5862130 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-ib5k-im2e_vk94 201300 645100 2019-02-28 2018-09-30 25           25               25
453 LITTLETON REGIONAL HEALTHCARE 600 ST JOHNSBURY ROAD LITTLETON NH 3561 GRAFTON (603) 444-9000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3162340 -71.8253160 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-khnu_9dyx-jeeb 301302 644143 2019-02-28 2018-09-30 21 4         25               25
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
482 WILLIAM W BACKUS HOSPITAL 326 WASHINGTON ST NORWICH CT 6360 NEW LONDON (860) 889-8331 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.5434020 -72.0867470 0   11 9 9011 35980 Hartford-West Hartford, CT Central New London County https://data.medicare.gov/resource/xubh-q36u/row-x7iv~8mww_raqd 70024 645051 2019-02-28 2018-09-30 153 12         165 18             183
515 BOONE COUNTY HEALTH CENTER P O BOX 151, 723 WEST FAIRVIEW ST ALBION NE 68620 BOONE (402) 395-2191 Critical Access Hospitals Government - Local TRUE 41.6921113 -98.0002224 1 ROOFTOP 11 31 31011         https://data.medicare.gov/resource/xubh-q36u/row-3j5p_6aw6-77k2 281334 645125 2019-02-28 2018-09-30 25           25               25
520 CATHOLIC MEDICAL CENTER 100 MCGREGOR STREET MANCHESTER NH 3102 HILLSBOROUGH (603) 668-3545 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9912110 -71.4737900 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-juap.ysfe.wwxy 300034 644142 2019-02-28 2018-09-30 209 20         229   22           251
523 CHARLES A CANNON JR MEMORIAL HOSPITAL 434 HOSPITAL DRIVE LINVILLE NC 28646 AVERY (828) 737-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.0674800 -81.8856780 0   11 37 37011         https://data.medicare.gov/resource/xubh-q36u/row-8t8e~pm2z_adds 341323 645351 2019-02-28 2018-09-30 21           21 10             31
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
596 JOHNSON MEMORIAL HOSPITAL 201 CHESTNUT HILL ROAD STAFFORD SPRINGS CT 6076 TOLLAND (860) 684-4251 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9795964 -72.3911022 1 ROOFTOP 13 9 9013 25540 Hartford-West Hartford, CT Central Tolland County https://data.medicare.gov/resource/xubh-q36u/row-teik-3pgv_3z6k 70008 645049 2019-02-28 2018-09-30 43 7         50 20             70
624 CONCORD HOSPITAL 250 PLEASANT ST CONCORD NH 3301 MERRIMACK (603) 225-2711 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1963290 -71.5623660 0   13 33 33013 18180 Boston-Worcester-Providence, MA-RI-NH-CT Central Merrimack County https://data.medicare.gov/resource/xubh-q36u/row-uzp6_t3mc.vwkr 300001 643718 2019-02-28 2018-09-30 188 18         206 15             221
625 FRANKLIN REGIONAL HOSPITAL 15 AIKEN AVENUE FRANKLIN NH 3235 MERRIMACK (603) 934-2060 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4480710 -71.6436840 0   13 33 33013 18180 Boston-Worcester-Providence, MA-RI-NH-CT Central Merrimack County https://data.medicare.gov/resource/xubh-q36u/row-eyhc~86xw.fw5b 301306 644144 2019-02-28 2018-09-30 25           25 10             35
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
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
676 DAY KIMBALL HOSPITAL 320 POMFRET STREET PUTNAM CT 6260 WINDHAM (860) 928-6541 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9077460 -71.9146920 0   15 9 9015 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Windham County https://data.medicare.gov/resource/xubh-q36u/row-wpx5.4hwv_hd6p 70003 645321 2019-02-28 2018-09-30 98 6         104               104
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
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
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
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
756 EMERSON HOSPITAL - 133 OLD ROAD TO 9 ACRE CORNER W CONCORD MA 1742 MIDDLESEX (978) 369-1400 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.4526280 -71.3772310 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-y26k_3nm4~rkj6 220084 644738 2019-02-28 2018-09-30 97 14         111 29     20       160
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
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
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
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
825 KING'S DAUGHTERS' MEDICAL CENTER 2201 LEXINGTON AVENUE ASHLAND KY 41101 BOYD (606) 408-4401 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4704010 -82.6359160 0   19 21 21019 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Boyd County https://data.medicare.gov/resource/xubh-q36u/row-2h99.b8qq_r6h2 180009 643766 2019-02-28 2018-09-30 388 38         439       47       486
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
907 LAKELAND HOSPITAL WATERVLIET 400 MEDICAL PARK DR WATERVLIET MI 49098 BERRIEN (269) 463-3111 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.1848660 -86.2507600 0   21 26 26021 35660 South Bend-Elkhart-Mishawaka, IN-MI Central Berrien County https://data.medicare.gov/resource/xubh-q36u/row-7efk~hcgi~rsxw 230078 645339 2019-02-28 2018-09-30 26           26   18           44
935 COLUMBUS COMMUNITY HOSPITAL 1515 PARK AVE COLUMBUS WI 53925 COLUMBIA (920) 623-2200 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3237980 -89.0361620 0   21 55 55021 31540 Madison-Janesville-Beloit, WI Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-87ws-7evk.39ut 521338 644196 2019-02-28 2018-09-30 21 4         25               25
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
1010 MASSACHUSETTS EYE AND EAR INFIRMARY - 243 CHARLES STREET BOSTON MA 2114 SUFFOLK (617) 523-7900 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3628610 -71.0705210 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-u3e3_hg2x_hi8v 220075 644640 2019-02-28 2018-09-30 41           41               41
1015 TUFTS MEDICAL CENTER 800 WASHINGTON STREET BOSTON MA 2111 SUFFOLK (617) 636-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3494860 -71.0636930 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-bms5~bwa2_vxct 220116 644127 2019-02-28 2018-09-30 266 98         364 20             384
1043 BRATTLEBORO MEMORIAL HOSPITAL 17 BELMONT AVE BRATTLEBORO VT 5301 WINDHAM (802) 257-0341 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8420700 -72.5646430 0   25 50 50025         https://data.medicare.gov/resource/xubh-q36u/row-r2kj.qdk8~ae78 470011 644193 2019-02-28 2018-09-30 47           47               47
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
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
1067 WEST VALLEY MEDICAL CENTER 1717 ARLINGTON STREET CALDWELL ID 83605 CANYON (208) 459-4641 Acute Care Hospitals Proprietary TRUE 43.6542200 -116.6956400 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-q3w9-74rj.ew8y 130014 645072 2019-02-28 2018-09-30 95 13       4 112               112
1079 HEYWOOD HOSPITAL - 242 GREEN STREET GARDNER MA 1440 WORCESTER (978) 632-3420 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5865650 -71.9861650 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-vv6z~isen-5p6a 220095 645108 2019-02-28 2018-09-30 103 11         114 20             134
1081 ATHOL MEMORIAL HOSPITAL 2033 MAIN STREET ATHOL MA 1331 WORCESTER (978) 249-3511 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.5862730 -72.2087480 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-kb7k~zmz5~v8ji 221303 644288 2019-02-28 2018-09-30 25           25               25
1084 HEALTH ALLIANCE - CLINTON HOSPITAL 60 HOSPITAL ROAD LEOMINSTER MA 1453 WORCESTER (978) 466-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.5411930 -71.7630330 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-y6vw_ua5p.gsn5 220001 644639 2019-02-28 2018-09-30 120 10         130 20             150
1134 CARIBOU MEMORIAL HOSPITAL 300 SOUTH 3RD WEST SODA SPRINGS ID 83276 CARIBOU (208) 547-3341 Critical Access Hospitals Government - Local TRUE 42.6522350 -111.6133540 0   29 16 16029         https://data.medicare.gov/resource/xubh-q36u/row-k69a-4kn6-dfne 131309 644028 2019-02-28 2018-09-30 25           25       30       55
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
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
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
1229 NORTHWEST COMMUNITY HOSPITAL 1 800 W CENTRAL ROAD ARLINGTON HEIGHTS IL 60005 COOK (847) 618-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0666040 -87.9929510 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-39t4.gcrd_v8y9 140252 644983 2019-02-28 2018-09-30 328 60       8 396 52 33           481
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
1446 JACKSON GENERAL HOSPITAL 122 PINNELL ST RIPLEY WV 25271 JACKSON (304) 372-2731 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.8235410 -81.7283250 0   35 54 54035         https://data.medicare.gov/resource/xubh-q36u/row-qz6z~eyng~xsxm 511320 645206 2019-02-28 2018-09-30 25           25               25
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
1649 ST FRANCIS HOSPITAL 3401 LUDINGTON ST ESCANABA MI 49829 DELTA (906) 786-3311 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.7457600 -87.0948530 0   41 26 26041 21540   Central Delta County https://data.medicare.gov/resource/xubh-q36u/row-iqyh_xi8k_igyu 231337 645115 2019-02-28 2018-09-30 16 9         25               25
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
1658 VIDANT CHOWAN HOSPITAL 211 VIRGINIA RD EDENTON NC 27932 CHOWAN (252) 482-8451 Critical Access Hospitals Government - Local TRUE 36.0707740 -76.6090930 0   41 37 37041         https://data.medicare.gov/resource/xubh-q36u/row-trbd~xc39_h8ri 341318 644158 2019-02-28 2018-09-30 21 4         25               25
1731 VALOR HEALTH 1202 EAST LOCUST STREET EMMETT ID 83617 GEM (208) 365-3561 Critical Access Hospitals Government - Local TRUE 43.8790780 -116.4852550 0   45 16 16045 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Gem County https://data.medicare.gov/resource/xubh-q36u/row-cch8-kmmd-nmhb 131318 644635 2019-02-28 2018-09-30 13           13               13
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
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
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
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
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
1908 PRAIRIE RIDGE HOSPITAL AND HEALTH SERVICES 1411 HIGHWAY 793 E ELBOW LAKE MN 56531 GRANT (218) 685-7300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9908032 -95.9578947 1 ROOFTOP 51 27 27051         https://data.medicare.gov/resource/xubh-q36u/row-is3f.7a5b~t9ju 241379 644131 2019-02-28 2018-09-30 10           10               10
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
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
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
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
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
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
2075 MADISON VALLEY MEDICAL CENTER 305 N MAIN ENNIS MT 59729 MADISON (406) 682-4222 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.3514000 -111.7325670 0   57 30 30057         https://data.medicare.gov/resource/xubh-q36u/row-djeh_dspp-vwv4 271329 644643 2019-02-28 2018-09-30 10           10               10
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
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
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
2361 BEATRICE COMMUNITY HOSPITAL & HEALTH CENTER, INC P O BOX 278, 4800 HOSPITAL PARKWAY BEATRICE NE 68310 GAGE (402) 228-3344 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3161806 -96.7495665 1 ROOFTOP 67 31 31067 13100 Lincoln-Beatrice, NE Central Gage County https://data.medicare.gov/resource/xubh-q36u/row-hnr5~xngx-6v22 281364 645126 2019-02-28 2018-09-30 22 3         25               25
2417 WHEELING HOSPITAL 1 MEDICAL PARK WHEELING WV 26003 OHIO (304) 243-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.0600740 -80.6840220 0   69 54 54069 48540   Central Ohio County https://data.medicare.gov/resource/xubh-q36u/row-s497_dubq_q36x 510050 645204 2019-02-28 2018-09-30 201 22         223       125       348
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
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
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
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
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
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
2526 OSF SAINT LUKES MEDICAL CENTER 1051 WEST SOUTH STREET KEWANEE IL 61443 HENRY (309) 853-3361 Critical Access Hospitals Voluntary non-profit - Church TRUE 41.2221630 -89.9477690 0   73 17 17073 19340 Davenport-Moline, IA-IL Outlying Henry County https://data.medicare.gov/resource/xubh-q36u/row-9mk3-a2c4_4uh2 141325 645251 2019-02-28 2018-09-30 22 3         25               25
2529 GREENWOOD COUNTY HOSPITAL 100 W 16TH STREET EUREKA KS 67045 GREENWOOD (620) 583-7451 Critical Access Hospitals Government - Local TRUE 37.8353150 -96.2941800 0   73 20 20073         https://data.medicare.gov/resource/xubh-q36u/row-g9zc.t83r_s62e 171339 645085 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
);