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

383 rows where "filed_date" is on date 2019-05-31

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, coronary_beds, burn_beds, surg_icu_beds, subprovider_irf_beds, subprovider_oth_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date)

  • 2019-05-31 · 383
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
7 DOWN EAST COMMUNITY HOSPITAL 11 HOSPITAL DRIVE MACHIAS ME 4654 WASHINGTON (207) 255-3356 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7134110 -67.4772030 0   29 23 23029         https://data.medicare.gov/resource/xubh-q36u/row-tmd2.zxhs~phzc 201311 650481 2019-05-31 2018-12-31 25           25               25
42 BAPTIST HEALTH MEDICAL CENTER-STUTTGART 1703 NORTH BUERKLE ST STUTTGART AR 72160 ARKANSAS (870) 673-3511 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5177730 -91.5575720 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-rh96.h2uy.6pb9 40072 649864 2019-05-31 2018-12-31 49           49               49
58 PLATTE VALLEY MEDICAL CENTER 1600 PRAIRIE CENTER PKWY BRIGHTON CO 80601 ADAMS (303) 498-1601 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9654410 -104.7709240 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-nf6e_r5cw.zmhy 60004 648669 2019-05-31 2018-12-31 65 8         89               89
61 NORTH SUBURBAN MEDICAL CENTER 9191 GRANT ST THORNTON CO 80229 ADAMS (303) 451-7800 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8643800 -104.9847830 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-tvxk_43rk.h2qn 60065 649402 2019-05-31 2018-12-31 111 16         127               127
85 TREASURE VALLEY HOSPITAL 8800 WEST EMERALD STREET BOISE ID 83704 ADA (208) 373-5000 Acute Care Hospitals Proprietary FALSE 43.6112890 -116.2903320 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-egh2.u29a~s2jf 130063 650684 2019-05-31 2018-12-31 9           9               9
106 SHORE MEDICAL CENTER 100 MEDICAL CENTER WAY SOMERS POINT NJ 8244 ATLANTIC (609) 653-3545 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3146730 -74.5927720 0   1 34 34001 12100 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Atlantic County https://data.medicare.gov/resource/xubh-q36u/row-yjds-updz~uqtp 310047 650505 2019-05-31 2018-12-31 183 16         199               199
127 RIVERSIDE SHORE MEMORIAL HOSPITAL 20480 MARKET STREET ONANCOCK VA 23417 ACCOMACK (757) 414-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6997120 -75.7209370 0   1 51 51001         https://data.medicare.gov/resource/xubh-q36u/row-w6kr~hh5i_py3g 490037 650393 2019-05-31 2018-12-31 36 10         46               46
129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
130 BROADDUS HOSPITAL ASSOCIATION, INC 1 HEALTHCARE DRIVE MANSFIELD HILL PHILIPPI WV 26416 BARBOUR (304) 457-1760 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1528870 -80.0440910 0   1 54 54001         https://data.medicare.gov/resource/xubh-q36u/row-njqv~ij6d.yec2 511300 650429 2019-05-31 2018-12-31 12           12       60       72
131 MOUNDVIEW MEMORIAL HOSPITAL AND CLINICS 402 W LAKE ST FRIENDSHIP WI 53934 ADAMS (608) 339-3331 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9739950 -89.8210260 0   1 55 55001         https://data.medicare.gov/resource/xubh-q36u/row-b3gp.589m.s6jc 521309 650550 2019-05-31 2018-12-31 25           25               25
176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
203 NORTH VISTA HOSPITAL 1409 EAST LAKE MEAD BLVD NORTH LAS VEGAS NV 89030 CLARK (702) 657-5504 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1957390 -115.1229860 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-in5k~58hj~u63s 290005 649922 2019-05-31 2018-12-31 116 20         136 41             177
213 ENGLEWOOD HOSPITAL AND MEDICAL CENTER 350 ENGLE ST ENGLEWOOD NJ 7631 BERGEN (201) 894-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9028550 -73.9679930 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-veb2-ksdy_macn 310045 650180 2019-05-31 2018-12-31 238 26       11 275 14             289
248 MARTHA JEFFERSON HOSPITAL 500 MARTHA JEFFERSON DRIVE CHARLOTTESVILLE VA 22911 ALBEMARLE (434) 654-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.0251060 -78.4448550 0   3 51 51003 16820   Central Albemarle County https://data.medicare.gov/resource/xubh-q36u/row-wyg5~56zu_3ctd 490077 650406 2019-05-31 2018-12-31 138 12         150               150
258 BAXTER REGIONAL MEDICAL CENTER 624 HOSPITAL DRIVE MOUNTAIN HOME AR 72653 BAXTER (870) 508-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3430670 -92.3959050 0   5 5 5005 34260   Central Baxter County https://data.medicare.gov/resource/xubh-q36u/row-pjhy~i9v2.r6ud 40027 650559 2019-05-31 2018-12-31 153 17         170 19 23       12   224
260 MEDICAL CENTER OF AURORA, THE 1501 S POTOMAC ST AURORA CO 80012 ARAPAHOE (303) 873-5511 Acute Care Hospitals Proprietary TRUE 39.6893460 -104.8311500 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-b8kj.p6xy-3gvh 60100 648892 2019-05-31 2018-12-31 250 45       14 309 20             329
268 ASCENSION SACRED HEART BAY 615 N BONITA AVE PANAMA CITY FL 32401 BAY (850) 769-1511 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.1596810 -85.6470670 0   5 12 12005 37460   Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-sfb2_87vw-qbr7 100026 650248 2019-05-31 2018-12-31 236 57         293               293
273 COLUMBUS REGIONAL HOSPITAL 2400 E 17TH ST COLUMBUS IN 47201 BARTHOLOMEW (812) 379-4441 Acute Care Hospitals Government - Local TRUE 39.2158720 -85.8968540 0   5 18 18005 18020 Indianapolis-Carmel-Muncie, IN Central Bartholomew County https://data.medicare.gov/resource/xubh-q36u/row-u4i5.cqhh_8kd8 150112 649209 2019-05-31 2018-12-31 194 17         211   18           229
287 MORTON HOSPITAL 88 WASHINGTON STREET TAUNTON MA 2780 BRISTOL (508) 828-7000 Acute Care Hospitals Proprietary TRUE 41.9055830 -71.0943500 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-648n_jcsm_qayn 220073 650488 2019-05-31 2018-12-31 81 12         93 19             112
289 SAINT ANNE'S HOSPITAL 795 MIDDLE STREET FALL RIVER MA 2721 BRISTOL (508) 674-5600 Acute Care Hospitals Proprietary TRUE 41.6933210 -71.1636420 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-kxda_mnxm~imp3 220020 650486 2019-05-31 2018-12-31 163 12         175 31             206
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
320 WOODLAND HEIGHTS MEDICAL CENTER 505 SOUTH JOHN REDDITT DRIVE LUFKIN TX 75904 ANGELINA (936) 634-8311 Acute Care Hospitals Proprietary TRUE 31.3277370 -94.7561390 0   5 48 48005 31260   Central Angelina County https://data.medicare.gov/resource/xubh-q36u/row-2twc-7b9d-f8nh 450484 649671 2019-05-31 2018-12-31 115 15         145               145
322 LOGAN REGIONAL HOSPITAL 500 EAST 1400 NORTH LOGAN UT 84341 CACHE (435) 716-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7574610 -111.8228770 0   5 49 49005 30860   Central Cache County https://data.medicare.gov/resource/xubh-q36u/row-248k.jdp3-ibnu 460015 649977 2019-05-31 2018-12-31 83 14       33 130 7     14       151
326 PROSSER MEMORIAL HOSPITAL 723 MEMORIAL STREET PROSSER WA 99350 BENTON (509) 786-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.2076300 -119.7635020 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-jxdy-bhag~5gk3 501312 652444 2019-05-31 2018-12-31 25           25               25
342 ADVENTIST HEALTH FEATHER RIVER 5974 PENTZ ROAD PARADISE CA 95969 BUTTE (530) 877-9361 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7561610 -121.5723050 0   7 6 6007 17020   Central Butte County https://data.medicare.gov/resource/xubh-q36u/row-dx3c~3bgg.9vjq 50225 659201 2019-05-31 2018-12-31                              
357 FRANKLIN MEMORIAL HOSPITAL 111 FRANKLIN HEALTH COMMONS FARMINGTON ME 4938 FRANKLIN (207) 778-6031 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.6251150 -70.1612440 0   7 23 23007         https://data.medicare.gov/resource/xubh-q36u/row-5fiv_edxs-8b6w 200037 650477 2019-05-31 2018-12-31 43 5         48               48
372 COOPER UNIVERSITY HOSPITAL 1 COOPER PLAZA CAMDEN NJ 8103 CAMDEN (856) 342-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9408020 -75.1157570 0   7 34 34007 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Camden County https://data.medicare.gov/resource/xubh-q36u/row-nkr7.hdmt_ja2d 310014 649466 2019-05-31 2018-12-31 483 30 12       574               574
391 ANMED HEALTH 800 N FANT ST ANDERSON SC 29621 ANDERSON (864) 512-2830 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5110710 -82.6473550 0   7 45 45007 24860 Greenville-Spartanburg-Anderson, SC Outlying Anderson County https://data.medicare.gov/resource/xubh-q36u/row-7pgs~6cv2_uh8s 420027 650366 2019-05-31 2018-12-31 327 25 15       367 29             396
396 CONFLUENCE HEALTH- WENATCHEE VALLEY HOSP & CLINICS 820 NORTH CHELAN AVENUE WENATCHEE WA 98801 CHELAN (509) 663-8711 Acute Care Hospitals Voluntary non-profit - Private FALSE 47.4335660 -120.3219830 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-aiqi_mn7n_vecf 500148 650791 2019-05-31 2018-12-31 11           11   9           20
416 STEWARD ROCKLEDGE HOSPITAL 110 LONGWOOD AVE ROCKLEDGE FL 32955 BREVARD (321) 637-2603 Acute Care Hospitals Proprietary TRUE 28.3345400 -80.7231330 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-tbme~t6bb.jqha 100092 649413 2019-05-31 2018-12-31 243 31         274 24             298
417 STEWARD MELBOURNE HOSPITAL 250 NORTH WICKHAM ROAD MELBOURNE FL 32935 BREVARD (321) 752-1200 Acute Care Hospitals Proprietary TRUE 28.1098040 -80.6726100 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-fnh8.cjxx_ncpd 100291 649425 2019-05-31 2018-12-31 101 12         113               113
454 CAPE REGIONAL MEDICAL CENTER INC TWO STONE HARBOR BLVD CAPE MAY COURT HOUSE NJ 8210 CAPE MAY (609) 463-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0875407 -74.8169302 1 ROOFTOP 9 34 34009 36140 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Cape May County https://data.medicare.gov/resource/xubh-q36u/row-rka3_zh3w_qfu4 310011 649928 2019-05-31 2018-12-31 133 16         149               149
486 NORTHWEST MEDICAL CENTER 2801 N STATE RD 7 MARGATE FL 33063 BROWARD (954) 974-0400 Acute Care Hospitals Proprietary TRUE 26.2629030 -80.2019050 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-e825~y5d2-68se 100189 649421 2019-05-31 2018-12-31 193 24       11 228               228
503 WITHAM HEALTH SERVICES 2605 N LEBANON ST LEBANON IN 46052 BOONE (765) 485-8000 Acute Care Hospitals Government - Local TRUE 40.0769090 -86.4752090 0   11 18 18011 26900 Indianapolis-Carmel-Muncie, IN Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-gfq5-5jsq-rtmb 150104 649208 2019-05-31 2018-12-31 60 8         68 10     18       96
519 ST JOSEPH HOSPITAL 172 KINSLEY ST NASHUA NH 3060 HILLSBOROUGH (603) 882-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.7504410 -71.4798860 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-rqfg_z9rq-d57e 300011 650729 2019-05-31 2018-12-31 169 15         184   24           208
522 AUBURN COMMUNITY HOSPITAL 17 LANSING STREET AUBURN NY 13021 CAYUGA (315) 255-7011 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9407610 -76.5646070 0   11 36 36011 12180 Syracuse-Auburn, NY Central Cayuga County https://data.medicare.gov/resource/xubh-q36u/row-7wyc_jst8-xyh7 330235 650319 2019-05-31 2018-12-31 71   14       85 14     80       179
525 GRAND LAKE HEALTH SYSTEM 200 SAINT CLAIR STREET SAINT MARYS OH 45885 AUGLAIZE (419) 394-3335 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5451390 -84.3698360 0   11 39 39011 47540 Lima-Van Wert-Celina, OH Central Auglaize County https://data.medicare.gov/resource/xubh-q36u/row-98z6_ymvq~u2mi 360032 649307 2019-05-31 2018-12-31 30 6         36 12 4   15       67
539 PHOENIX CHILDREN'S HOSPITAL 1919 EAST THOMAS ROAD PHOENIX AZ 85016 MARICOPA (602) 933-1000 Childrens Voluntary non-profit - Private FALSE 33.4802160 -112.0411930 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-feed_vt9a~9ie7 33302 650636 2019-05-31 2018-12-31 352           433               433
550 HONORHEALTH DEER VALLEY MEDICAL CENTER 19829 NORTH 27TH AVENUE PHOENIX AZ 85027 MARICOPA (623) 879-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6664250 -112.1171880 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-npyt_2wmd.v5z4 30092 650232 2019-05-31 2018-12-31 172   32       204               204
551 SCOTTSDALE THOMPSON PEAK MEDICAL CENTER 7400 EAST THOMPSON PEAK PARKWAY SCOTTSDALE AZ 85255 MARICOPA (480) 324-7001 Acute Care Hospitals Proprietary TRUE 33.6697770 -111.9218030 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-y7bn~8g49_tr6b 30123 650235 2019-05-31 2018-12-31 112 8         120               120
555 SCOTTSDALE OSBORN MEDICAL CENTER 7400 EAST OSBORN ROAD SCOTTSDALE AZ 85251 MARICOPA (480) 882-4004 Acute Care Hospitals Proprietary TRUE 33.4876390 -111.9227250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-xncf.ukg7_66e2 30038 650230 2019-05-31 2018-12-31 268 59         327   14           341
558 JOHN C. LINCOLN NORTH MOUNTAIN HOSPITAL 250 EAST DUNLAP AVENUE PHOENIX AZ 85020 MARICOPA (602) 331-5862 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5677540 -112.0706300 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-9bpm.fdh7~5snu 30014 650229 2019-05-31 2018-12-31 218 20 24       262               262
569 SCOTTSDALE SHEA MEDICAL CENTER 9003 EAST SHEA BOULEVARD SCOTTSDALE AZ 85260 MARICOPA (480) 323-3000 Acute Care Hospitals Proprietary TRUE 33.5824670 -111.8860320 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-zegy.nw3j~tfkb 30087 650231 2019-05-31 2018-12-31 378 25       24 427               427
608 PENOBSCOT BAY MEDICAL CENTER 6 GLEN COVE DRIVE ROCKPORT ME 4856 KNOX (207) 921-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1444340 -69.0865370 0   13 23 23013         https://data.medicare.gov/resource/xubh-q36u/row-ahvj_huyh~m44w 200063 650478 2019-05-31 2018-12-31 73 8         81       84       165
637 WESTFIELD MEMORIAL HOSPITAL, INC 189 EAST MAIN STREET WESTFIELD NY 14787 CHAUTAUQUA (716) 326-4921 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3279010 -79.5693970 0   13 36 36013 27460   Central Chautauqua County https://data.medicare.gov/resource/xubh-q36u/row-vwk8~gn4h~53q8 330166 650743 2019-05-31 2018-12-31 4           4               4
648 HILTON HEAD REGIONAL MEDICAL CENTER 25 HOSPITAL CENTER BLVD HILTON HEAD ISLAND SC 29925 BEAUFORT (843) 681-6122 Acute Care Hospitals Proprietary TRUE 32.2193200 -80.7125000 0   13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-twij.hnjd-wm9w 420080 651483 2019-05-31 2018-12-31 81 12         93               93
663 HOSPITAL DR SUSONI INC 55 PALM ST ARECIBO PR 614 ARECIBO (787) 650-1031 Acute Care Hospitals Voluntary non-profit - Private TRUE 18.4726154 -66.7164601 1 APPROXIMATE 13 72 72013 11640 San Juan-Carolina, PR Central Arecibo Municipio https://data.medicare.gov/resource/xubh-q36u/row-sxrh-3iek~wydv 400117 648863 2019-05-31 2018-12-31 114 6         120               120
685 LINCOLN HEALTH 35 MILES STREET DAMARISCOTTA ME 4543 LINCOLN (207) 563-1234 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0261990 -69.5271640 0   15 23 23015         https://data.medicare.gov/resource/xubh-q36u/row-mrex~j496-ppyw 201302 650479 2019-05-31 2018-12-31 21 4         25       42       67
726 BARTON MEMORIAL HOSPITAL 2170 SOUTH AVENUE SOUTH LAKE TAHOE CA 96150 EL DORADO (530) 541-3420 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9123370 -119.9977110 0   17 6 6017 40900 Sacramento-Roseville, CA Central El Dorado County https://data.medicare.gov/resource/xubh-q36u/row-kae2-ekyj_hpjm 50352 652418 2019-05-31 2018-12-31 55 8         63       11 37     111
784 LOWER BUCKS HOSPITAL 501 BATH ROAD BRISTOL PA 19007 BUCKS (215) 785-9200 Acute Care Hospitals Proprietary TRUE 40.1040650 -74.8646260 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-3pai_t2mu_egih 390070 651661 2019-05-31 2018-12-31 108 22         130 45             175
795 BATH COMMUNITY HOSPITAL 106 PARK DRIVE- PO DRAWER Z HOT SPRINGS VA 24445 BATH (540) 839-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9938900 -79.8309590 0   17 51 51017         https://data.medicare.gov/resource/xubh-q36u/row-36k3~dwrj~zvyd 491300 650420 2019-05-31 2018-12-31 14           14               14
809 BAPTIST HEALTH MEDICAL CENTER-ARKADELPHIA 3050 TWIN RIVERS DRIVE ARKADELPHIA AR 71923 CLARK (870) 245-2622 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1228020 -93.0879700 0   19 5 5019 11660   Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-f8ss.59v5_rxma 41321 649536 2019-05-31 2018-12-31 25           25               25
816 ADVENTIST HEALTH REEDLEY 372 W CYPRESS AVE REEDLEY CA 93654 FRESNO (559) 638-8155 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.6078120 -119.4516950 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-re3j_d2jv_jrs3 50192 659200 2019-05-31 2018-12-31 49           49               49
819 MOUNTAIN VIEW HOSPITAL 2325 CORONADO STREET IDAHO FALLS ID 83404 BONNEVILLE (208) 557-2700 Acute Care Hospitals Physician FALSE 43.4725240 -111.9887170 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-4xx8-2i4p-wi9n 130065 649556 2019-05-31 2018-12-31 41           41               41
821 THE CARLE FOUNDATION HOSPITAL 611 WEST PARK STREET URBANA IL 61801 CHAMPAIGN (217) 383-3311 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.1174230 -88.2138880 0   19 17 17019 16580   Central Champaign County https://data.medicare.gov/resource/xubh-q36u/row-irc8~hqw6~45fp 140091 650122 2019-05-31 2018-12-31 328   12   26   391   20           411
833 PENOBSCOT VALLEY HOSPITAL 7 TRANSALPINE ROAD, PO BOX 368 LINCOLN ME 4457 PENOBSCOT (207) 794-3321 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3487330 -68.5162580 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-zcrj.qk59-ua67 201303 650480 2019-05-31 2018-12-31 25           25               25
840 BOONE HOSPITAL CENTER 1600 E BROADWAY COLUMBIA MO 65201 BOONE (573) 815-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9506690 -92.3170390 0   19 29 29019 17860 Columbia-Moberly-Mexico, MO Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-f55k.gvub.hupa 260068 649281 2019-05-31 2018-12-31 282 32       21 335   15           350
846 HUNTERDON MEDICAL CENTER 2100 WESCOTT DRIVE FLEMINGTON NJ 8822 HUNTERDON (908) 788-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5325240 -74.8604100 0   19 34 34019 35620 New York-Newark, NY-NJ-CT-PA Central Hunterdon County https://data.medicare.gov/resource/xubh-q36u/row-9tc8-f958_adu2 310005 649927 2019-05-31 2018-12-31 158 12         170 14             184
849 NOVANT HEALTH BRUNSWICK MEDICAL CENTER 1 MEDICAL CENTER DR PO BOX 139 SUPPLY NC 28462 BRUNSWICK (910) 755-8121 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.0090920 -78.2899230 0   19 37 37019 34820 Myrtle Beach-Conway, SC-NC Central Brunswick County https://data.medicare.gov/resource/xubh-q36u/row-6hdf-qvep.ppy9 340158 650348 2019-05-31 2018-12-31 42 19         61               61
862 EAST COOPER MEDICAL CENTER 2000 HOSPITAL DR MOUNT PLEASANT SC 29464 CHARLESTON (843) 881-0100 Acute Care Hospitals Proprietary TRUE 32.8209970 -79.8496130 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-a8up_sjrm.scy3 420089 648981 2019-05-31 2018-12-31 118 12         130               130
910 CLAIBORNE COUNTY HOSPITAL 123 MCCOMB AVENUE PORT GIBSON MS 39150 CLAIBORNE (601) 437-5141 Critical Access Hospitals Government - Local FALSE 31.9459920 -90.9853950 0   21 28 28021 46980 Jackson-Vicksburg-Brookhaven, MS Outlying Claiborne County https://data.medicare.gov/resource/xubh-q36u/row-wz4r-hvew~et2i 251320 650593 2019-05-31 2018-12-31 22           22 10             32
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
918 CAPITAL HEALTH MEDICAL CENTER - HOPEWELL ONE CAPITAL WAY PENNINGTON NJ 8534 MERCER (609) 303-4000 Acute Care Hospitals Voluntary non-profit - Private FALSE 40.2918008 -74.8041257 1 ROOFTOP 21 34 34021 45940 New York-Newark, NY-NJ-CT-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-57bi.fjhf.mmkn 310044 649048 2019-05-31 2018-12-31 129 16         145               145
919 COLUMBIA MEMORIAL HOSPITAL 71 PROSPECT AVENUE HUDSON NY 12534 COLUMBIA (518) 828-7601 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2462540 -73.7761280 0   21 36 36021 26460 Albany-Schenectady, NY Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-74q4-dwkw.23jn 330094 650741 2019-05-31 2018-12-31 86 9         95 22             117
931 CEDAR CITY HOSPITAL 1303 NORTH MAIN STREET CEDAR CITY UT 84721 IRON (435) 868-5800 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7005910 -113.0639850 0   21 49 49021 16260   Central Iron County https://data.medicare.gov/resource/xubh-q36u/row-v2cb~88mw~jehb 460007 649976 2019-05-31 2018-12-31 42 6         48               48
938 HIMA SAN PABLO BAYAMON 70 CALLE SANTA CRUZ BAYAMON PR 961 BAYAMON (787) 620-4747 Acute Care Hospitals Proprietary TRUE 18.3976640 -66.1496740 0   21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-gt9f-5hpz-5v3k 400109 650772 2019-05-31 2018-12-31 290 39 7       336               336
942 BAPTIST HEALTH MEDICAL CENTER HEBER SPINGS 1800 BYPASS ROAD HEBER SPRINGS AR 72543 CLEBURNE (501) 887-3000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5065780 -92.0013190 0   23 5 5023         https://data.medicare.gov/resource/xubh-q36u/row-d26c_x5yu_6fn3 41312 651551 2019-05-31 2018-12-31 25           25               25
992 O'CONNOR HOSPITAL 460 ANDES ROAD DELHI NY 13753 DELAWARE (607) 746-0300 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.2668700 -74.9168500 0   25 36 36025         https://data.medicare.gov/resource/xubh-q36u/row-we9d-4xh5_rhbv 331305 650323 2019-05-31 2018-12-31 16           16               16
1006 ST ELIZABETH'S MEDICAL CENTER 736 CAMBRIDGE STREET BRIGHTON MA 2135 SUFFOLK (617) 789-3000 Acute Care Hospitals Proprietary TRUE 42.3497730 -71.1481200 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-2h6b~pv8m.4qst 220036 650487 2019-05-31 2018-12-31 166 46         212 62             274
1016 CARNEY HOSPITAL 2100 DORCHESTER AVENUE BOSTON MA 2124 SUFFOLK (617) 506-2000 Acute Care Hospitals Proprietary TRUE 42.2781080 -71.0664420 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-nhy8.nh8q_gagk 220017 650485 2019-05-31 2018-12-31 100 10         110 16             126
1021 FAIRVIEW LAKES MEDICAL CENTER 5200 FAIRVIEW BOULEVARD WYOMING MN 55092 CHISAGO (763) 389-6481 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.3222670 -92.9984660 0   25 27 27025 33460 Minneapolis-St. Paul, MN-WI Outlying Chisago County https://data.medicare.gov/resource/xubh-q36u/row-ikkv.xzb8-j7fx 240050 650496 2019-05-31 2018-12-31 45 10         55               55
1057 HIMA SAN PABLO-CAGUAS AVE LUIS MUNOZ MARIN CAGUAS PR 725 CAGUAS (787) 653-3434 Acute Care Hospitals Proprietary TRUE 18.2270107 -66.0273180 1 GEOMETRIC_CENTER 25 72 72025 41980 San Juan-Carolina, PR Central Caguas Municipio https://data.medicare.gov/resource/xubh-q36u/row-7siz.yb89_3gij 400120 649347 2019-05-31 2018-12-31 394 46         440               440
1075 WALDO COUNTY GENERAL HOSPITAL 118 NORTHPORT AVE BELFAST ME 4915 WALDO (207) 338-2500 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4127590 -68.9951020 0   27 23 23027         https://data.medicare.gov/resource/xubh-q36u/row-9ec9_eza5.9s9p 201312 650482 2019-05-31 2018-12-31 21 4         25               25
1089 MORRISTOWN MEDICAL CENTER 100 MADISON AVE MORRISTOWN NJ 7960 MORRIS (973) 971-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7878960 -74.4648550 0   27 34 34027 35620 New York-Newark, NY-NJ-CT-PA Central Morris County https://data.medicare.gov/resource/xubh-q36u/row-3qig-b9am-x2ij 310015 650178 2019-05-31 2018-12-31 526 44 10     34 614 24 38   17       693
1117 WAUPUN MEMORIAL HOSPITAL 620 W BROWN ST WAUPUN WI 53963 FOND DU LAC (920) 324-6512 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6309680 -88.7459120 0   27 55 55027 13180 Milwaukee-Racine-Waukesha, WI Central Dodge County https://data.medicare.gov/resource/xubh-q36u/row-pzmh.4yzf-teeh 521327 650553 2019-05-31 2018-12-31 25           25               25
1124 ADVENTIST HEALTH BAKERSFIELD 2615 CHESTER AVENUE BAKERSFIELD CA 93301 KERN (661) 395-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3830560 -119.0188570 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-siqs~heps~67ia 50455 649164 2019-05-31 2018-12-31 211 34         254               254
1125 DELANO REGIONAL MEDICAL CENTER 1401 GARCES HIGHWAY DELANO CA 93215 KERN (661) 725-4800 Acute Care Hospitals Proprietary TRUE 35.7614180 -119.2388780 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-6xns.bkw3_m9qr 50608 650656 2019-05-31 2018-12-31 95 10         105       2   49   156
1126 ADVENTIST HEALTH TEHACHAPI VALLEY 1100 MAGELLAN TEHACHAPI CA 93561 KERN (661) 823-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1474419 -118.4504364 1 ROOFTOP 29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-xx6n.a25c~74jx 51301 648598 2019-05-31 2018-12-31 16 4         20               20
1133 DELTA COUNTY MEMORIAL HOSPITAL 1501 E 3RD ST DELTA CO 81416 DELTA (970) 874-7681 Acute Care Hospitals Government - Local TRUE 38.7431660 -108.0475150 0   29 8 8029         https://data.medicare.gov/resource/xubh-q36u/row-wsed.7ysa~nwhq 60071 649875 2019-05-31 2018-12-31 43 6         49               49
1156 KENMORE MERCY HOSPITAL 2950 ELMWOOD AVENUE KENMORE NY 14217 ERIE (716) 447-6100 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.9779000 -78.8786780 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-urys_37cx~tnza 330102 650299 2019-05-31 2018-12-31 148 16         164   20   160       344
1158 KALEIDA HEALTH 100 HIGH STREET BUFFALO NY 14210 ERIE (716) 859-8620 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9003290 -78.8649370 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-xn8m_fv8h.at49 330005 650732 2019-05-31 2018-12-31 750 70 29   31 74 954   34   80       1068
1160 ERIE COUNTY MEDICAL CENTER 462 GRIDER STREET BUFFALO NY 14215 ERIE (716) 898-3936 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9272360 -78.8291510 0   29 36 36029 15380 Buffalo-Cheektowaga, NY Central Erie County https://data.medicare.gov/resource/xubh-q36u/row-6f2k.kya2.7ejd 330219 650316 2019-05-31 2018-12-31 302 30   8     340 136 40   390       906
1180 UNIVERSITY HEALTH SYSTEM 4502 MEDICAL DR SAN ANTONIO TX 78229 BEXAR (210) 358-2637 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5094880 -98.5770620 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-a5b3.8n6m-4vq3 450213 651423 2019-05-31 2018-12-31 460 20     44   606   27           633
1184 METHODIST AMBULATORY SURGERY HOSPITAL NW 9150 HUEBNER RD SUITE 100 SAN ANTONIO TX 78240 BEXAR (210) 575-5000 Acute Care Hospitals Proprietary TRUE 29.5276050 -98.5959950 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-f26r~6776-r3st 450780 650209 2019-05-31 2018-12-31 22           22               22
1192 WHIDBEYHEALTH MEDICAL CENTER 101 NORTH MAIN STREET COUPEVILLE WA 98239 ISLAND (360) 678-5151 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.2142400 -122.6861220 0   29 53 53029 36020 Seattle-Tacoma, WA Central Island County https://data.medicare.gov/resource/xubh-q36u/row-uede_fy5z~txux 501339 649688 2019-05-31 2018-12-31 19 6         25               25
1200 ADVENTIST HEALTH HANFORD 115 MALL DRIVE HANFORD CA 93230 KINGS (209) 410-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3238770 -119.6690050 0   31 6 6031 25260 Visalia-Porterville-Hanford, CA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-gskm_spqc_qqn6 50121 649537 2019-05-31 2018-12-31 208 22         230               230
1204 DENVER HEALTH MEDICAL CENTER 777 BANNOCK ST DENVER CO 80204 DENVER (303) 602-4930 Acute Care Hospitals Government - State TRUE 39.7282300 -104.9900660 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-6si7.z49y~jb56 60011 650437 2019-05-31 2018-12-31 298 32     23 25 378 64 11           453
1214 MEMORIAL HOSPITAL JACKSONVILLE 3625 UNIVERSITY BLVD S JACKSONVILLE FL 32216 DUVAL (904) 702-6111 Acute Care Hospitals Proprietary TRUE 30.2876330 -81.6024050 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-cpb7-vuug-u3fk 100179 650250 2019-05-31 2018-12-31 316 51         377 41             418
1251 COMMUNITY FIRST MEDICAL CENTER 5645 W ADDISON STREET CHICAGO IL 60634 COOK (773) 282-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9458500 -87.7682870 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-f6rv-fc4d~9uyi 140251 650127 2019-05-31 2018-12-31 193       20   213       66       279
1257 ADVOCATE ILLINOIS MASONIC MEDICAL CENTER 836 WEST WELLINGTON AVENUE CHICAGO IL 60657 COOK (773) 975-1600 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9363150 -87.6515540 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-f4m5.ndmq~4y5c 140182 650124 2019-05-31 2018-12-31 137 74 43       254 35 22           311
1265 DECATUR COUNTY MEMORIAL HOSPITAL 720 N LINCOLN ST GREENSBURG IN 47240 DECATUR (812) 663-4331 Critical Access Hospitals Government - Local TRUE 39.3441160 -85.4794040 0   31 18 18031 24700 Indianapolis-Carmel-Muncie, IN Central Decatur County https://data.medicare.gov/resource/xubh-q36u/row-hqis.arxf_g2ap 151332 649101 2019-05-31 2018-12-31 25           25               25
1269 ADVENTIST HEALTHCARE SHADY GROVE MEDICAL CENTER 9901 MEDICAL CENTER DRIVE ROCKVILLE MD 20850 MONTGOMERY (240) 826-6527 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0980460 -77.2010270 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-z5ai-uwvz~ja8i 210057 649038 2019-05-31 2018-12-31 280 27         338               338
1275 ADVENTIST HEALTHCARE WHITE OAK MEDICAL CENTER 12100 PLUM ORCHARD DRIVE SILVER SPRING MD 20904 MONTGOMERY (301) 891-5651 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0522630 -76.9582320 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-tb4c-cc68.vyas 210016 649036 2019-05-31 2018-12-31 172 26         198               198
1280 BOZEMAN HEALTH DEACONESS HOSPITAL 915 HIGHLAND BLVD BOZEMAN MT 59715 GALLATIN (406) 585-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.6702780 -111.0172390 0   31 30 30031 14580   Central Gallatin County https://data.medicare.gov/resource/xubh-q36u/row-avzt.zzb8~xv3b 270057 650725 2019-05-31 2018-12-31 75 8         83               83
1296 COSHOCTON REGIONAL MEDICAL CENTER 1460 ORANGE STREET COSHOCTON OH 43812 COSHOCTON (740) 623-4144 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2704420 -81.8475770 0   31 39 39031 18740   Central Coshocton County https://data.medicare.gov/resource/xubh-q36u/row-kfzq~stzn~vtav 360109 649322 2019-05-31 2018-12-31 49 7         56               56
1312 SPARKS MEDICAL CENTER - VAN BUREN 211 CRAWFORD MEMORIAL DRIVE VAN BUREN AR 72956 CRAWFORD (479) 474-3401 Acute Care Hospitals Proprietary TRUE 35.4341750 -94.3394510 0   33 5 5033 22900   Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-w5xt~zwtc_2chf 40018 649071 2019-05-31 2018-12-31 31 8         39               39
1314 ADVENTIST HEALTH CLEARLAKE 15630 18TH AVE - HWY 53 CLEARLAKE CA 95422 LAKE (707) 994-6486 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.9353458 -122.6200816 1 ROOFTOP 33 6 6033 17340   Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-hud3~fp2e-cmcb 51317 648600 2019-05-31 2018-12-31 21 4         25               25
1326 SURGICAL SPECIALTY CENTER OF BATON ROUGE 8080 BLUEBONNET BLVD BATON ROUGE LA 70810 E. BATON ROUGE (225) 408-8080 Acute Care Hospitals Physician FALSE 30.3765650 -91.0993330 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-vta2_xzya~pwww 190251 648928 2019-05-31 2018-12-31 16           16               16
1337 CHIPPEWA COUNTY WAR MEMORIAL HOSPITAL 500 OSBORN BLVD SAULT SAINTE MARIE MI 49783 CHIPPEWA (906) 635-4460 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.4980990 -84.3495130 0   33 26 26033 42300   Central Chippewa County https://data.medicare.gov/resource/xubh-q36u/row-eftg-z8w4.heur 230239 649610 2019-05-31 2018-12-31 43 6         49 20     51       120
1463 GLENDALE ADVENTIST MEDICAL CENTER 1509 E WILSON TERRACE GLENDALE CA 91206 LOS ANGELES (818) 409-8202 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1491610 -118.2303540 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-9sbg-4wtr.teeu 50239 649399 2019-05-31 2018-12-31 277   20   12 14 323 60 28   40       451

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