hospital_data

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

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

4,766 rows sorted by zip_code

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
906 906 SOUTH SHORE HOSPITAL 55 FOGG ROAD SOUTH WEYMOUTH MA 2190 NORFOLK (781) 340-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1747200 -70.9540750 0   21 25 25021 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Norfolk County https://data.medicare.gov/resource/xubh-q36u/row-cywc_kz9x_rwwf 220100 645265 2019-02-27 2018-09-30 358 34         392               392
1017 1017 BETH ISRAEL DEACONESS MEDICAL CENTER 330 BROOKLINE AVENUE BOSTON MA 2215 SUFFOLK (617) 667-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3405750 -71.1055040 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-kbwd.yhig.v78j 220086 645107 2019-03-13 2018-09-30 555 77       47 679 25             704
955 955 GOOD SAMARITAN MEDICAL CENTER 235 NORTH PEARL STREET BROCKTON MA 2301 PLYMOUTH (508) 427-3000 Acute Care Hospitals Proprietary TRUE 42.0970700 -71.0656450 0   23 25 25023 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Plymouth County https://data.medicare.gov/resource/xubh-q36u/row-u3jj_w4a9~6ncj 220111 649444 2019-05-29 2018-12-31 231 18         249 16             265
957 957 SIGNATURE HEALTHCARE BROCKTON HOSPITAL 680 CENTER STREET BROCKTON MA 2302 PLYMOUTH (508) 941-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.0862100 -70.9910830 0   23 25 25023 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Plymouth County https://data.medicare.gov/resource/xubh-q36u/row-7ewk.5amj.99ru 220052 645264 2019-03-13 2018-09-30 159 16         175 22             197
956 956 BETH ISRAEL DEACONESS HOSPITAL - PLYMOUTH 275 SANDWICH STREET PLYMOUTH MA 2360 PLYMOUTH (508) 746-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9442460 -70.6447200 0   23 25 25023 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Plymouth County https://data.medicare.gov/resource/xubh-q36u/row-w558~xnb9~x8wu 220060 644736 2019-03-13 2018-09-30 132 13         145 19             164
753 753 NEWTON-WELLESLEY HOSPITAL 2014 WASHINGTON STREET NEWTON MA 2462 MIDDLESEX (617) 243-6000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.3323390 -71.2465920 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-dm6k-cg8i.edgy 220101 646397 2019-04-08 2018-09-30 229 12         241 45             286
905 905 BETH ISRAEL DEACONESS HOSPITAL - NEEDHAM 148 CHESTNUT STREET NEEDHAM MA 2494 NORFOLK (781) 453-3002 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2775740 -71.2373580 0   21 25 25021 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Norfolk County https://data.medicare.gov/resource/xubh-q36u/row-8cdy_uuqt~qywh 220083 645106 2019-03-13 2018-09-30 51 7         58               58
97 97 FALMOUTH HOSPITAL 67 & 100 TER HEUN DRIVE FALMOUTH MA 2540 BARNSTABLE (508) 548-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5649620 -70.6211260 0   1 25 25001 12700 Boston-Worcester-Providence, MA-RI-NH-CT Central Barnstable County https://data.medicare.gov/resource/xubh-q36u/row-ycds_hhnf.xdyd 220135 645109 2019-03-08 2018-09-30 85 10         95               95
835 835 NANTUCKET COTTAGE HOSPITAL 57 PROSPECT STREET NANTUCKET MA 2554 NANTUCKET (508) 228-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2755420 -70.1002610 0   19 25 25019         https://data.medicare.gov/resource/xubh-q36u/row-txca.96ch~wc9s 220177 646153 2019-03-14 2018-09-30 19           19               19
358 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
96 96 CAPE COD HOSPITAL 88 LEWIS BAY ROAD HYANNIS MA 2601 BARNSTABLE (508) 771-1800 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6528230 -70.2748470 0   1 25 25001 12700 Boston-Worcester-Providence, MA-RI-NH-CT Central Barnstable County https://data.medicare.gov/resource/xubh-q36u/row-wu4e-kfxd~b2tt 220012 644735 2019-03-08 2018-09-30 215 11 13       239 20             259
288 288 STURDY MEMORIAL HOSPITAL 211 PARK STREET ATTLEBORO MA 2703 BRISTOL (508) 222-5200 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.9426950 -71.2752790 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-hsm9~94fs~psx5 220008 644033 2019-02-27 2018-09-30 117 14         131               131
286 286 SOUTHCOAST HOSPITAL GROUP, INC 363 HIGHLAND AVENUE FALL RIVER MA 2720 BRISTOL (508) 679-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7105220 -71.1464390 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-veij_kb96-ysvv 220074 643785 2019-02-26 2018-09-30 761 58       16 835   32           867
289 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
287 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
316 316 NEWPORT HOSPITAL 11 FRIENDSHIP STREET NEWPORT RI 2840 NEWPORT (401) 846-6400 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4978090 -71.3061930 0   5 44 44005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Newport County https://data.medicare.gov/resource/xubh-q36u/row-k4vz~qu4j.cscu 410006 644558 2019-03-12 2018-09-30 92 10         102 15 12           129
463 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
241 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
462 462 WESTERLY HOSPITAL 25 WELLS STREET WESTERLY RI 2891 WASHINGTON (401) 596-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3627980 -71.8258140 0   9 44 44009 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-y3gi~mp2b-duy7 410013 644344 2019-03-06 2018-09-30 66 9         75               75
387 387 LANDMARK MEDICAL CENTER 115 CASS AVENUE WOONSOCKET RI 2895 PROVIDENCE (401) 769-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0053200 -71.4962100 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-ywvs_4dtp_6u43 410011 649821 2019-06-03 2018-12-31 107 16         123 18             141
388 388 RHODE ISLAND HOSPITAL 593 EDDY STREET PROVIDENCE RI 2903 PROVIDENCE (401) 444-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8119560 -71.4070490 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-ypz5_k3ny~erpa 410007 645165 2019-03-14 2018-09-30 459 137 10       622 56 13           691
385 385 OUR LADY OF FATIMA HOSPITAL 200 HIGH SERVICE AVENUE NORTH PROVIDENCE RI 2904 PROVIDENCE (401) 456-3000 Acute Care Hospitals Proprietary TRUE 41.8557960 -71.4584980 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-ya2z~83y5.tnki 410005 650779 2019-05-30 2018-12-31 148 15         163 124 25           312
390 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
389 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
386 386 ROGER WILLIAMS MEDICAL CENTER 825 CHALKSTONE AVENUE PROVIDENCE RI 2908 PROVIDENCE (401) 456-2025 Acute Care Hospitals Proprietary TRUE 41.8340150 -71.4345800 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-k87m-wjy5_7p2x 410004 650778 2019-05-30 2018-12-31 134       14   148 12             160
697 697 PARKLAND MEDICAL CENTER 1 PARKLAND DRIVE DERRY NH 3038 ROCKINGHAM (603) 421-2100 Acute Care Hospitals Proprietary TRUE 42.8758250 -71.3175780 0   15 33 33015 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Rockingham County https://data.medicare.gov/resource/xubh-q36u/row-m9nh.dqhg_kjyp 300017 659515 2019-11-07 2018-07-31 60 8         68 18             86
518 518 SOUTHERN NH MEDICAL CENTER 8 PROSPECT STREET NASHUA NH 3060 HILLSBOROUGH (603) 577-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7560610 -71.4612290 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-z29g.nws7.yp8q 300020 659990 2019-11-25 2019-06-30 131 11         142 18             160
519 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
520 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
516 516 ELLIOT HOSPITAL 1 ELLIOT WAY MANCHESTER NH 3103 HILLSBOROUGH (603) 669-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9827950 -71.4357390 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-eaev.u4vg~83e6 300012 661552 2019-12-03 2019-06-30 183 16         199 41             240
625 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
104 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
626 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
452 452 SPEARE MEMORIAL HOSPITAL 16 HOSPITAL ROAD PLYMOUTH NH 3264 GRAFTON (603) 536-1120 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.7578860 -71.6948370 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-tpyx~4vjq_mct4 301311 661929 2019-11-27 2019-06-30 25           25               25
624 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
296 296 CHESHIRE MEDICAL CENTER 580 COURT STREET KEENE NH 3431 CHESHIRE (603) 354-5400 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9498540 -72.2907250 0   5 33 33005 28300   Central Cheshire County https://data.medicare.gov/resource/xubh-q36u/row-xyq5~7j27.ews5 300019 661742 2019-12-03 2019-06-30 59 27         86   24           110
517 517 MONADNOCK COMMUNITY HOSPITAL 452 OLD STREET ROAD PETERBOROUGH NH 3458 HILLSBOROUGH (603) 924-7191 Critical Access Hospitals Proprietary TRUE 42.8934610 -71.9374710 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-mhsm~xuaz.m9jn 301309 645432 2019-03-01 2018-09-30 25           25               25
453 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
367 367 ANDROSCOGGIN VALLEY HOSPITAL 59 PAGE HILL ROAD BERLIN NH 3570 COOS (603) 752-2200 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4870990 -71.1565480 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-fdui.znjf.jm5w 301310 643921 2019-02-26 2018-09-30 25           25               25
368 368 UPPER CONNECTICUT VALLEY HOSPITAL 181 CORLISS LANE COLEBROOK NH 3576 COOS (603) 237-4971 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9044120 -71.4814890 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-5jxk.h2s8~zvc6 301300 644312 2019-02-27 2018-09-30 16           16               16
3 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
845 845 VALLEY REGIONAL HOSPITAL 243 ELM STREET CLAREMONT NH 3743 SULLIVAN (603) 542-7771 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3851430 -72.3424650 0   19 33 33019 17200   Outlying Sullivan County https://data.medicare.gov/resource/xubh-q36u/row-pzan~sayc~gyd3 301308 645431 2019-03-01 2018-09-30 25           25               25
450 450 MARY HITCHCOCK MEMORIAL HOSPITAL 1 MEDICAL CENTER DRIVE LEBANON NH 3756 GRAFTON (603) 650-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6779700 -72.2737460 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-vy5p~59uc_9gzu 300003 661551 2019-12-02 2019-06-30 311 48 12     30 401 21             422
451 451 ALICE PECK DAY MEMORIAL HOSPITAL 10 ALICE PECK DAY DRIVE LEBANON NH 3766 GRAFTON (603) 448-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6402930 -72.2643660 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-t8xb_fse9~ukfj 301305 661743 2019-12-03 2019-06-30 24           24               24
449 449 COTTAGE HOSPITAL 90 SWIFTWATER RD WOODSVILLE NH 3785 GRAFTON (603) 747-9000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.1362340 -72.0222910 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-8qq6_qdvh_tpdv 301301 643282 2019-02-20 2018-09-30 25           25 10             35
696 696 PORTSMOUTH REGIONAL HOSPITAL 333 BORTHWICK AVE PORTSMOUTH NH 3801 ROCKINGHAM (603) 436-5110 Acute Care Hospitals Proprietary TRUE 43.0640930 -70.7877740 0   15 33 33015 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Rockingham County https://data.medicare.gov/resource/xubh-q36u/row-mstp-mc9d-7mre 300029 652758 2019-08-01 2019-02-28 127 16         143 30             173
764 764 WENTWORTH-DOUGLASS HOSPITAL 789 CENTRAL AVE DOVER NH 3820 STRAFFORD (603) 740-2580 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.2124420 -70.8751390 0   17 33 33017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Outlying Strafford County https://data.medicare.gov/resource/xubh-q36u/row-4p72~hzkw.rjnh 300018 643281 2019-02-25 2018-09-30 107 11         118               118
698 698 EXETER HOSPITAL INC 5 ALUMNI DRIVE EXETER NH 3833 ROCKINGHAM (603) 778-7311 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9830660 -70.9343190 0   15 33 33015 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Rockingham County https://data.medicare.gov/resource/xubh-q36u/row-ebwx-bw34~tqbv 300023 643919 2019-03-08 2018-09-30 78 19         97               97
209 209 MEMORIAL HOSPITAL, THE 3073 WHITE MOUNTAIN HIGHWAY NORTH CONWAY NH 3860 CARROLL (603) 356-5461 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0605190 -71.1385100 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-n7xq-6ijr_9ppy 301307 645671 2019-03-01 2018-09-30 21 4         25         45     70
765 765 FRISBIE MEMORIAL HOSPITAL 11 WHITEHALL ROAD ROCHESTER NH 3867 STRAFFORD (603) 332-5211 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.2981890 -70.9611940 0   17 33 33017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Outlying Strafford County https://data.medicare.gov/resource/xubh-q36u/row-6n5x.y352.3bdm 300014 645670 2019-03-01 2018-09-30 58 6         64 20             84
2 2 HUGGINS HOSPITAL 240 SOUTH MAIN STREET WOLFEBORO NH 3894 CARROLL (603) 569-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5809440 -71.2015750 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-u6j2-zv25.9ghd 301312 659991 2019-11-25 2018-09-30 21 4         25               25
1267 1267 YORK HOSPITAL 15 HOSPITAL DRIVE YORK ME 3909 YORK (207) 363-4321 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1427990 -70.6510940 0   31 23 23031 38860 Portland-Lewiston-South Portland, ME Central York County https://data.medicare.gov/resource/xubh-q36u/row-d4r3_kkiu_3jv2 200020 651001 2019-06-03 2018-12-31 61 5         66               66
1268 1268 SOUTHERN MAINE HEALTH CARE 1 MEDICAL CENTER DRIVE BIDDEFORD ME 4005 YORK (207) 283-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.4784360 -70.4921740 0   31 23 23031 38860 Portland-Lewiston-South Portland, ME Central York County https://data.medicare.gov/resource/xubh-q36u/row-am4g_dvue_z9bw 200019 649741 2019-05-30 2018-12-31 131 9         140 12     74   38   264
279 279 BRIDGTON HOSPITAL 10 HOSPITAL DRIVE BRIDGTON ME 4009 CUMBERLAND (207) 647-6000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0472490 -70.7127770 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-xeqw-dspw~ebr9 201310 662214 2019-12-02 2019-06-30 25           25               25
280 280 MID COAST HOSPITAL 123 MEDICAL CENTER DRIVE BRUNSWICK ME 4011 CUMBERLAND (207) 729-0181 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.9056610 -69.8920060 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-aikj.qgnk-5idc 200021 643898 2019-02-26 2018-09-30 81 11         92               92
277 277 NORTHERN LIGHT HEALTH 144 STATE STREET PORTLAND ME 4101 CUMBERLAND (207) 879-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.6520880 -70.2652090 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-9h63~5c2i.9z4j 200008 650701 2019-05-30 2018-09-30 96 7         103               103
278 278 MAINE MEDICAL CENTER 22 BRAMHALL ST PORTLAND ME 4102 CUMBERLAND (207) 662-0111 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6521930 -70.2751040 0   5 23 23005 38860 Portland-Lewiston-South Portland, ME Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-94m6-7spt_ncnf 200009 646265 2019-03-27 2018-09-30 490 32 22       575 21             596
94 94 CENTRAL MAINE MEDICAL CENTER 300 MAIN STREET LEWISTON ME 4240 ANDROSCOGGIN (207) 795-0111 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1009760 -70.2145570 0   1 23 23001 30340 Portland-Lewiston-South Portland, ME Central Androscoggin County https://data.medicare.gov/resource/xubh-q36u/row-xhy6~mapr~umkr 200024 654886 2019-10-01 2019-06-30 170 20 20       221   13           234
93 93 ST MARY'S REGIONAL MEDICAL CENTER 93 CAMPUS AVENUE - PO BOX 291 LEWISTON ME 4243 ANDROSCOGGIN (207) 777-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1014140 -70.1982160 0   1 23 23001 30340 Portland-Lewiston-South Portland, ME Central Androscoggin County https://data.medicare.gov/resource/xubh-q36u/row-9zvb_vyvi_ykdt 200034 650704 2019-06-03 2018-12-31 126 14         140 31     210       381
743 743 STEPHENS MEMORIAL HOSPITAL 181 MAIN STREET NORWAY ME 4268 OXFORD (207) 743-5933 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.2095390 -70.5329780 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-sfne.bccg~sezn 201315 650826 2019-06-28 2018-12-31 21 4         25               25
744 744 RUMFORD HOSPITAL 420 FRANKLIN STREET RUMFORD ME 4276 OXFORD (207) 369-1000 Critical Access Hospitals Proprietary TRUE 44.5517210 -70.5571710 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-923a_kexq.nxfx 201306 662536 2019-12-02 2019-06-30 25           25               25
506 506 MAINEGENERAL MEDICAL CENTER 35 MEDICAL CENTER PARKWAY AUGUSTA ME 4330 KENNEBEC (207) 626-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.3608530 -69.7857180 0   11 23 23011 12300   Central Kennebec County https://data.medicare.gov/resource/xubh-q36u/row-k6q5-wdks.vqnn 200039 659964 2019-11-25 2019-06-30 156 16         172   20           192
831 831 EASTERN MAINE MEDICAL CENTER PO BOX 404 BANGOR ME 4401 PENOBSCOT (207) 973-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.8080922 -68.7517371 1 ROOFTOP 19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-2mv7_y4vm-bcwh 200033 650703 2019-05-30 2018-09-30 246 44         313   36           349
834 834 ST JOSEPH HOSPITAL 360 BROADWAY BANGOR ME 4401 PENOBSCOT (207) 262-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.8145300 -68.7712600 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-ad3u-g4s7-xxty 200001 650700 2019-06-03 2018-12-31 92 7         99               99
901 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
900 900 CHARLES A DEAN MEMORIAL HOSPITAL PO BOX 1129 GREENVILLE ME 4441 PISCATAQUIS (207) 695-5200 Critical Access Hospitals Voluntary non-profit - Private FALSE 45.4594923 -69.5906060 1 GEOMETRIC_CENTER 21 23 23021         https://data.medicare.gov/resource/xubh-q36u/row-e23p-cjiz~ui3t 201301 650155 2019-06-21 2018-09-30 25           25               25
833 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
832 832 MILLINOCKET REGIONAL HOSPITAL 200 SOMERSET STREET MILLINOCKET ME 4462 PENOBSCOT (207) 723-5161 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.6527290 -68.7150760 0   19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-j6pc.k4d7~avr8 201307 659965 2019-11-25 2019-06-30 25           25               25
685 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
439 439 NORTHERN LIGHT MAINE COAST HOSPITAL 50 UNION STREET ELLSWORTH ME 4605 HANCOCK (207) 667-5311 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.5465740 -68.4155260 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-4sb2~q3gq.pkmc 200050 651565 2019-06-26 2018-09-30 42 6         48               48
437 437 MOUNT DESERT ISLAND HOSPITAL 10 WAYMAN LANE, PO BOX 8 BAR HARBOR ME 4609 HANCOCK (207) 288-5081 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3843690 -68.2023310 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-egex~7j5d.98hj 201304 654844 2019-09-30 2019-04-30 25           25               25
438 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
1140 1140 CALAIS REGIONAL HOSPITAL 24 HOSPITAL LANE CALAIS ME 4619 WASHINGTON (207) 454-7521 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.1806390 -67.2705210 0   29 23 23029         https://data.medicare.gov/resource/xubh-q36u/row-dzvd-m85b~mjvj 201305 648833 2019-05-17 2018-12-31 25           25               25
7 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
179 179 HOULTON REGIONAL HOSPITAL 20 HARTFORD STREET HOULTON ME 4730 AROOSTOOK (207) 532-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1329620 -67.8426440 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-tx6y-y4iu-nd9t 201308 645561 2019-03-04 2018-09-30 25           25               25
176 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
177 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
178 178 NORTHERN LIGHT A R GOULD HOSPITAL PO BOX 151 PRESQUE ISLE ME 4769 AROOSTOOK (207) 768-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.6751494 -67.9985861 1 ROOFTOP 3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-ihck.jhth~929r 200018 650152 2019-05-29 2018-09-30 43 6         49   5   14 50     118
608 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
507 507 NORTHERN LIGHT INLAND HOSPITAL 200 KENNEDY MEMORIAL DRIVE WATERVILLE ME 4901 KENNEBEC (207) 861-3000 Acute Care Hospitals Proprietary TRUE 44.5426900 -69.6614050 0   11 23 23011 12300   Central Kennebec County https://data.medicare.gov/resource/xubh-q36u/row-w24b~y2sj-qzhk 200041 650154 2019-05-29 2018-09-30 33           33               33
1075 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
357 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
1002 1002 SEBASTICOOK VALLEY HEALTH 447 NORTH MAIN STREET PITTSFIELD ME 4967 SOMERSET (207) 487-5141 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7908260 -69.3712690 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-rjnr.evru~gjjd 201313 650156 2019-05-29 2018-09-30 25           25               25
1001 1001 REDINGTON FAIRVIEW GENERAL HOSPITAL 46 FAIRVIEW AVE PO BOX 468 SKOWHEGAN ME 4976 SOMERSET (207) 474-5121 Critical Access Hospitals Proprietary TRUE 44.7583360 -69.7134950 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-g9mx~aw3n.5hnn 201314 661526 2019-12-02 2019-06-30 21 4         25               25
794 794 GIFFORD MEDICAL CENTER 44 SOUTH MAIN STREET RANDOLPH VT 5060 ORANGE (802) 728-4441 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9175470 -72.6662550 0   17 50 50017 17200   Outlying Orange County https://data.medicare.gov/resource/xubh-q36u/row-yeuf.js9v_q9as 471301 643747 2019-02-25 2018-09-30 27 2         29               29
1111 1111 MT ASCUTNEY HOSPITAL 289 COUNTY ROAD WINDSOR VT 5089 WINDSOR (802) 674-6711 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4875220 -72.4009100 0   27 50 50027 17200   Central Windsor County https://data.medicare.gov/resource/xubh-q36u/row-wz4v-vria_i3xt 471302 643748 2019-02-25 2018-09-30 25           25   10           35
1112 1112 SPRINGFIELD HOSPITAL PO BOX 2003 SPRINGFIELD VT 5156 WINDSOR (802) 885-2151 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2981414 -72.4948662 1 ROOFTOP 27 50 50027 17200   Central Windsor County https://data.medicare.gov/resource/xubh-q36u/row-zewq-djn4-pp8m 471306 643749 2019-02-25 2018-09-30 25           25 10             35
247 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
1043 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
1044 1044 GRACE COTTAGE HOSPITAL PO BOX 216 TOWNSHEND VT 5353 WINDHAM (802) 365-7920 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0489148 -72.6682465 1 ROOFTOP 25 50 50025         https://data.medicare.gov/resource/xubh-q36u/row-u9ts~hp4k-kd62 471300 643746 2019-02-22 2018-09-30 19           19               19
395 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
540 540 NORTHWESTERN MEDICAL CENTER INC 133 FAIRFIELD STREET SAINT ALBANS VT 5478 FRANKLIN (802) 524-5911 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.8064630 -73.0725490 0   11 50 50011 15540   Outlying Franklin County https://data.medicare.gov/resource/xubh-q36u/row-3i6b-md48~jcq5 470024 643745 2019-02-25 2018-09-30 53           53               53
983 983 CENTRAL VERMONT MEDICAL CENTER BOX 547 BARRE VT 5641 WASHINGTON (802) 371-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1969972 -72.5019392 1 GEOMETRIC_CENTER 23 50 50023 12740   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-q5w8.7vxg_es2c 470001 643309 2019-02-22 2018-09-30 62 14         76               76
716 716 COPLEY HOSPITAL 528 WASHINGTON HIGHWAY MORRISVILLE VT 5661 LAMOILLE (802) 888-4231 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.5541860 -72.5912140 0   15 50 50015         https://data.medicare.gov/resource/xubh-q36u/row-ddkp~wcpj_r9te 471305 645509 2019-03-01 2018-09-30 25           25               25
932 932 RUTLAND REGIONAL MEDICAL CENTER 160 ALLEN ST RUTLAND VT 5701 RUTLAND (802) 775-7111 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5991880 -72.9561950 0   21 50 50021 40860   Central Rutland County https://data.medicare.gov/resource/xubh-q36u/row-fz4h_7zhj_ijvr 470005 644380 2019-03-06 2018-09-30 111 13         124               124
126 126 PORTER HOSPITAL, INC 115 PORTER DRIVE MIDDLEBURY VT 5753 ADDISON (802) 388-4701 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9994700 -73.1698030 0   1 50 50001         https://data.medicare.gov/resource/xubh-q36u/row-xcfu_sc2r.d4bu 471307 653360 2019-08-29 2018-09-30 25           25               25
324 324 NORTHEASTERN VERMONT REGIONAL HOSPITAL 1315 HOSPITAL DRIVE SAINT JOHNSBURY VT 5819 CALEDONIA (802) 748-7400 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4452620 -72.0095160 0   5 50 50005         https://data.medicare.gov/resource/xubh-q36u/row-868v.jqmt-84z2 471303 649002 2019-05-21 2018-09-30 21 4         25               25
865 865 NORTH COUNTRY HOSPITAL AND HEALTH CENTER 189 PROUTY DRIVE NEWPORT VT 5855 ORLEANS (802) 334-7331 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9546140 -72.2003390 0   19 50 50019         https://data.medicare.gov/resource/xubh-q36u/row-ipgf_5jyr.qb5v 471304 645803 2019-03-04 2018-09-30 20 5         25               25
142 142 BRISTOL HOSPITAL BREWSTER RD BRISTOL CT 6010 HARTFORD (860) 585-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6758208 -72.9314067 1 GEOMETRIC_CENTER 3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-v2rh-5xe4~wrhu 70029 645749 2019-03-25 2018-09-30 92 14         106 15             121
145 145 JOHN DEMPSEY HOSPITAL 263 FARMINGTON AVE FARMINGTON CT 6032 HARTFORD (860) 679-1145 Acute Care Hospitals Government - Local TRUE 41.7350900 -72.7958200 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-dhzf~ccfg~faa5 70036 661473 2019-11-27 2019-06-30 118 20         138 18             156

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