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 phone_number

View and edit SQL

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

Link rowid hospital_name address city state zip_code county_name phone_number ▼ hospital_type hospital_ownership emergency_services lat lng geocode_flag geocode_accuracy countyfips statefips statecountyfips cbsacode csatitle centraloutlyingcounty countyequivalent hosp_lookup_url PRVDR_NUM RPT_REC_NUM filed_date fy_end_date acute_beds icu_beds coronary_beds burn_beds surg_icu_beds oth_spec_beds subtotal_acute_beds subprovider_ipf_beds subprovider_irf_beds subprovider_oth_beds skilled_nursing_beds nursing_fac_beds oth_longterm_beds hospice_beds all_beds
4601 UT HEALTH EAST TEXAS CARTHAGE HOSPITAL 409 COTTAGE RD CARTHAGE TX 75633 PANOLA (093) 693-3841 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.1671260 -94.3460390 0   365 48 48365         https://data.medicare.gov/resource/xubh-q36u/row-tyuw-zwkq.zq2r 450210 640322 2018-12-28 2018-07-31 42           42               42
215 HACKENSACK MERIDIAN HEALTH PASCACK VALLEY MEDICAL 250 OLD HOOK ROAD WESTWOOD NJ 7675 BERGEN (201) 383-1035 Acute Care Hospitals Proprietary TRUE 40.9836580 -74.0141950 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-kwcd-72qg_ygd9 310130 660416 2019-11-25 2019-06-30 64 9         78               78
768 HUDSON REGIONAL HOSPITAL 55 MEADOWLANDS PKWY SECAUCUS NJ 7094 HUDSON (201) 392-3200 Acute Care Hospitals Proprietary TRUE 40.7918050 -74.0720990 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-ndru~dizp-vj9e 310118 654744 2019-09-30 2018-12-31 88 14         102   4           106
766 CAREPOINT HEALTH-HOBOKEN UNIVERSITY MEDICAL CENTER 308 WILLOW AVE HOBOKEN NJ 7030 HUDSON (201) 418-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7412130 -74.0335590 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-64ry-qaxe-vxjm 310040 649624 2019-06-03 2018-12-31 102 15         117 47 11   15       190
214 VALLEY HOSPITAL 223 N VAN DIEN AVENUE RIDGEWOOD NJ 7450 BERGEN (201) 447-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9832040 -74.1017610 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-dcmv-g3rd.mciv 310012 648551 2019-05-23 2018-12-31 327 14 22       363               363
767 CAREPOINT HEALTH-CHRIST HOSPITAL 176 PALISADE AVE JERSEY CITY NJ 7306 HUDSON (201) 795-8200 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7348760 -74.0501420 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-zyny.ji2k-c7cs 310016 648953 2019-06-03 2018-12-31 160 18         178               178
211 HOLY NAME MEDICAL CENTER 718 TEANECK RD TEANECK NJ 7666 BERGEN (201) 833-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8823770 -74.0086290 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-xnww.m9j5.svuu 310008 649047 2019-05-30 2018-12-31 265 19         284 23             307
769 PALISADES MEDICAL CENTER 7600 RIVER RD NORTH BERGEN NJ 7047 HUDSON (201) 854-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7941660 -73.9957650 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-x2iv_i3sd-zsk4 310003 655793 2019-10-30 2018-12-31 192 10         202               202
770 CAREPOINT HEALTH - BAYONNE MEDICAL CENTER 29 EAST 29TH ST BAYONNE NJ 7002 HUDSON (201) 858-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.6675310 -74.1123710 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-mid8_cv5r~b776 310025 651019 2019-06-03 2018-12-31 117 14         131 15     17       163
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
771 JERSEY CITY MEDICAL CENTER 355 GRAND STREET JERSEY CITY NJ 7302 HUDSON (201) 915-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7166660 -74.0499520 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-vsib-vwyd~5p7u 310074 649804 2019-05-30 2018-12-31 197 18 16     41 272 36             308
212 BERGEN NEW BRIDGE MEDICAL CENTER 230 EAST RIDGEWOOD AVE PARAMUS NJ 7652 BERGEN (201) 967-4000 Acute Care Hospitals Government - Local TRUE 40.9586020 -74.0621510 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-uajf_w5ak.e5wh 310058 651020 2019-06-03 2018-12-31 118 9         127 319     574       1020
74 CHILDREN'S HOSPITAL NMC 111 MICHIGAN AVE, NW WASHINGTON DC 20010 THE DISTRICT (202) 476-5000 Childrens Voluntary non-profit - Private TRUE 38.9262730 -77.0138780 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-9kra.5epj-ue89 93300 661151 2019-11-27 2019-06-30 184 73         323               323
73 SIBLEY MEMORIAL HOSPITAL 5255 LOUGHBORO RD NW WASHINGTON DC 20016 THE DISTRICT (202) 537-4680 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9357470 -77.1098890 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-yqpq-7pu8-v5vj 90005 660786 2019-11-27 2019-06-30 150   25   14   189 21     45       255
1331 UNITED MEDICAL CENTER 1310 SOUTHERN AVENUE SE WASHINGTON DC 20032 THE DISTRICT (202) 574-6611 Acute Care Hospitals Proprietary TRUE 38.8341550 -76.9846980 0   33 24 24033 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Prince George's County https://data.medicare.gov/resource/xubh-q36u/row-zng6.qzhh.7sfd 90008 645634 2019-03-01 2018-09-30 180 16         196               196
75 GEORGE WASHINGTON UNIV HOSPITAL 900 23RD ST NW WASHINGTON DC 20037 THE DISTRICT (202) 716-4605 Acute Care Hospitals Proprietary TRUE 38.9011690 -77.0501190 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-y2et_6xjz~rfau 90001 649550 2019-05-29 2018-12-31 255 56         329 20 16           365
71 HOWARD UNIVERSITY HOSPITAL 2041 GEORGIA AVE NW WASHINGTON DC 20060 THE DISTRICT (202) 745-6100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9170110 -77.0218960 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-8v26.mgb3_zc6i 90003 660921 2019-12-02 2019-06-30 164 36         200               200
70 MEDSTAR GEORGETOWN UNIVERSITY HOSPITAL 3800 RESERVOIR RD WASHINGTON DC 20007 THE DISTRICT (202) 784-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9125990 -77.0743880 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-5vf4.uxtf-sv5z 90004 661474 2019-11-27 2019-06-30 289 19     38   393               393
72 MEDSTAR WASHINGTON HOSPITAL CENTER 110 IRVING ST NW WASHINGTON DC 20010 THE DISTRICT (202) 877-7000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9291570 -77.0122680 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-he3p~gtzx-x7j5 90011 660787 2019-11-27 2019-06-30 569 37 16   55   701 46             747
63 STAMFORD HOSPITAL ONE HOSPITAL PLAZA STAMFORD CT 6904 FAIRFIELD (203) 276-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0544448 -73.5522909 1 ROOFTOP 1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-z4bk-5sz6.bqpu 70006 644101 2019-03-04 2018-09-30 252 36         288   17           305
414 CONNECTICUT HOSPICE INC,THE 100 DOUBLE BEACH ROAD BRANFORD CT 6405 NEW HAVEN (203) 315-7500 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.2563050 -72.8333670 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-9pw4-ddrr.eyyi 70038 645241 2019-03-01 2018-09-30 6           6           46   52
65 BRIDGEPORT HOSPITAL 267 GRANT STREET BRIDGEPORT CT 6610 FAIRFIELD (203) 384-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1887760 -73.1660800 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-i2q3_c2gu.vbzu 70010 644221 2019-02-27 2018-09-30 300 16     16   332 39             371
413 WATERBURY HOSPITAL 64 ROBBINS ST WATERBURY CT 6721 NEW HAVEN (203) 573-6000 Acute Care Hospitals Proprietary TRUE 41.5582690 -73.0586080 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-na88_kufh.6cuk 70005 650439 2019-05-30 2018-12-31 193 20         213 30             243
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
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
410 YALE-NEW HAVEN HOSPITAL 20 YORK ST NEW HAVEN CT 6504 NEW HAVEN (203) 688-4242 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3042850 -72.9346890 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-vv7z~adrr_fj28 70022 644224 2019-02-27 2018-09-30 1020 50 30   38 19 1279 118 24   119       1540
411 MIDSTATE MEDICAL CENTER 435 LEWIS AVENUE MERIDEN CT 6450 NEW HAVEN (203) 694-8200 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5500360 -72.8038780 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-zt5t~v5nn~ebtg 70017 645528 2019-03-14 2018-09-30 143           143               143
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
412 GRIFFIN HOSPITAL 130 DIVISION ST DERBY CT 6418 NEW HAVEN (203) 732-7500 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.3359780 -73.0886890 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-ikfk.swi4.hhft 70031 641347 2019-01-22 2018-09-30 87 14         101 16         2   119
64 DANBURY HOSPITAL 24 HOSPITAL AVE DANBURY CT 6810 FAIRFIELD (203) 739-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.4067760 -73.4443390 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-ekru_jpam-gjnq 70033 644104 2019-02-27 2018-09-30 319 41         360 22 14           396
66 NORWALK HOSPITAL 24 STEVENS STREET NORWALK CT 6856 FAIRFIELD (203) 852-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1104150 -73.4212290 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-mbxe~tqkf~is4n 70034 644105 2019-03-05 2018-09-30 195 40       16 251 20             271
67 GREENWICH HOSPITAL ASSOCIATION - 5 PERRYRIDGE RD GREENWICH CT 6830 FAIRFIELD (203) 863-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0343950 -73.6296320 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-z487-bxe7-a8jv 70018 644223 2019-02-27 2018-09-30 161 10       10 181               181
409 MILFORD HOSPITAL, INC 300 SEASIDE AVENUE MILFORD CT 6460 NEW HAVEN (203) 876-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2171410 -73.0643320 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-bk4f-6e95-q9k6 70019 658655 2019-11-06 2019-06-08 96 10         106               106
877 ST VINCENT'S CHILTON 2030 LAY DAM ROAD CLANTON AL 35045 CHILTON (205) 258-4400 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.8765850 -86.6235110 0   21 1 1021 13820 Birmingham-Hoover-Talladega, AL Outlying Chilton County https://data.medicare.gov/resource/xubh-q36u/row-7qdj~999i.xcfe 10173 659401 2019-11-22 2019-06-30 20 6         26               26
402 ST VINCENTS BLOUNT 150 GILBREATH DRIVE ONEONTA AL 35121 BLOUNT (205) 274-3000 Critical Access Hospitals Voluntary non-profit - Private FALSE 33.9325370 -86.4930590 0   9 1 1009 13820 Birmingham-Hoover-Talladega, AL Outlying Blount County https://data.medicare.gov/resource/xubh-q36u/row-nhvc-v4py.tnm6 11305 659402 2019-11-22 2019-06-30 19 6         25               25
2498 UAB CALLAHAN EYE HOSPITAL AUTHORITY 1720 UNIVERSITY BLVD, SUITE 500 BIRMINGHAM AL 35233 JEFFERSON (205) 325-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5031370 -86.8024010 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-txeu_r7zi.ibaa 10018 644082 2019-03-01 2018-09-30 12           12               12
3517 ST VINCENT'S ST CLAIR 7063 VETERANS PARKWAY PELL CITY AL 35125 ST. CLAIR (205) 338-3301 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6055680 -86.3023800 0   115 1 1115 13820 Birmingham-Hoover-Talladega, AL Outlying St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-env7.dc7s_bwtg 10130 659400 2019-11-22 2019-06-30 34 6         40               40
3333 PICKENS COUNTY MEDICAL CENTER 241 ROBERT K WILSON DRIVE CARROLLTON AL 35447 PICKENS (205) 367-8111 Acute Care Hospitals Government - Local TRUE 33.2748070 -88.0896730 0   107 1 1107 46220   Outlying Pickens County https://data.medicare.gov/resource/xubh-q36u/row-zn5h.i3rc.njwh 10109 644006 2019-03-01 2018-09-30 36 4         40 10             50
2238 GREENE COUNTY HOSPITAL 509 WILSON AVENUE EUTAW AL 35462 GREENE (205) 372-3388 Acute Care Hospitals Government - Local TRUE 32.8447440 -87.8893070 0   63 1 1063         https://data.medicare.gov/resource/xubh-q36u/row-dyit.ypt9~f4e7 10051 645036 2019-03-04 2018-09-30 20           20       72       92
3738 WALKER BAPTIST MEDICAL CENTER 3400 HIGHWAY 78 EAST JASPER AL 35502 WALKER (205) 387-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8411420 -87.2368790 0   127 1 1127 13820 Birmingham-Hoover-Talladega, AL Outlying Walker County https://data.medicare.gov/resource/xubh-q36u/row-kq57-46fi_25ps 10089 651154 2019-05-31 2018-12-31 195 12         207 52             259
3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
940 CHOCTAW GENERAL HOSPITAL 401 VANITY FAIR LANE, PO BOX 618 BUTLER AL 36904 CHOCTAW (205) 459-9100 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.0937419 -88.2095888 1 ROOFTOP 23 1 1023         https://data.medicare.gov/resource/xubh-q36u/row-cm2u-i8id~q257 11304 651161 2019-06-03 2018-12-31 25           25               25
2499 MEDICAL WEST, AN AFFILIATE OF UAB HEALTH SYSTEM 995 9TH AVENUE SOUTHWEST BESSEMER AL 35021 JEFFERSON (205) 481-7000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.3730860 -86.9917090 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-4v9u.s38j~rrc7 10114 644202 2019-03-01 2018-09-30 119 21         187 25 19           231
3823 LAKELAND COMMUNITY HOSPITAL 42024 HIGHWAY 195 E HALEYVILLE AL 35565 WINSTON (205) 485-7117 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2417180 -87.5898570 0   133 1 1133         https://data.medicare.gov/resource/xubh-q36u/row-qzez~be97-dgiz 10125 645811 2019-04-01 2018-12-31 45 4         49 9             58
2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
3544 SHELBY BAPTIST MEDICAL CENTER 1000 FIRST STREET NORTH ALABASTER AL 35007 SHELBY (205) 620-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.2536790 -86.8142610 0   117 1 1117 13820 Birmingham-Hoover-Talladega, AL Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-j68e.5ee5_e79h 10016 651149 2019-05-31 2018-12-31 180 32         212 40             252
3700 D C H REGIONAL MEDICAL CENTER 809 UNIVERSITY BOULEVARD EAST TUSCALOOSA AL 35401 TUSCALOOSA (205) 759-7111 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2061300 -87.5251540 0   125 1 1125 46220   Central Tuscaloosa County https://data.medicare.gov/resource/xubh-q36u/row-zssi.q234-yq7y 10092 644695 2019-02-28 2018-09-30 362 52 32       497 54 42           593
2496 PRINCETON BAPTIST MEDICAL CENTER 701 PRINCETON AVENUE SOUTHWEST BIRMINGHAM AL 35211 JEFFERSON (205) 783-3800 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.4991330 -86.8460160 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-hrc7-segv_vve4 10103 651156 2019-05-31 2018-12-31 222 12 12   21 12 279 30             309
2502 ST VINCENT'S EAST 50 MEDICAL PARK EAST DRIVE BIRMINGHAM AL 35235 JEFFERSON (205) 838-3122 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5953510 -86.6651820 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-tfdr.ige8~3px7 10011 659397 2019-11-22 2019-06-30 209 30 56   14   309 20 20           349
2501 BROOKWOOD BAPTIST MEDICAL CENTER 2010 BROOKWOOD MEDICAL CENTER DRIVE BIRMINGHAM AL 35209 JEFFERSON (205) 877-1000 Acute Care Hospitals Proprietary TRUE 33.4629100 -86.7768500 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-6yzq-z9kd_9ua7 10139 650228 2019-05-31 2018-12-31 340 26 27     32 425 140 30           595
2985 MARION REGIONAL MEDICAL CENTER 1256 MILITARY STREET SOUTH HAMILTON AL 35570 MARION (205) 921-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1258520 -87.9898060 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-ak6z-c9hr~7upb 10044 643754 2019-02-28 2018-09-30 32 4         36       79       115
336 BIBB MEDICAL CENTER 208 PIERSON AVE CENTREVILLE AL 35042 BIBB (205) 926-4881 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9511010 -87.1478650 0   7 1 1007 13820 Birmingham-Hoover-Talladega, AL Outlying Bibb County https://data.medicare.gov/resource/xubh-q36u/row-h96v_9sq6~aaj9 10058 644693 2019-03-01 2018-09-30 25           25       131       156
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
2497 UNIVERSITY OF ALABAMA HOSPITAL 619 SOUTH 19TH STREET BIRMINGHAM AL 35233 JEFFERSON (205) 934-4011 Acute Care Hospitals Government - State TRUE 33.5061290 -86.8019220 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-x229.ejr6_kvzz 10033 645809 2019-03-01 2018-09-30 772 37     48   1063 93 49           1205
2500 ST VINCENT'S BIRMINGHAM 810 ST VINCENT'S DRIVE BIRMINGHAM AL 35205 JEFFERSON (205) 939-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.5080150 -86.7887550 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-6naf-9cek~29rm 10056 659398 2019-11-22 2019-06-30 275 83 12     30 400               400
2503 CHILDREN'S HOSPITAL OF ALABAMA 1600 SEVENTH AVENUE SOUTH BIRMINGHAM AL 35233 JEFFERSON (205) 939-9100 Childrens Voluntary non-profit - Private TRUE 33.5032220 -86.8053810 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-nh6w~rxvd~itst 13300 651162 2019-06-03 2018-12-31 193     6     341               341
2504 GRANDVIEW MEDICAL CENTER 3690 GRANDVIEW PARKWAY BIRMINGHAM AL 35243 JEFFERSON (205) 971-1000 Acute Care Hospitals Proprietary TRUE 33.4343630 -86.7204830 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-pwut_di96_m4tu 10104 660349 2019-11-25 2019-06-30 289 72         373 12 17           402
1367 VIRGINIA MASON MEDICAL CENTER 925 SENECA ST SEATTLE WA 98101 KING (206) 223-6600 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.6101790 -122.3278090 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-dt6c_fkxq-9dkg 500005 653934 2019-08-22 2018-12-31 183 28         211       35       246
1370 HIGHLINE MEDICAL CENTER 16251 SYLVESTER ROAD SW BURIEN WA 98166 KING (206) 244-9970 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.4567780 -122.3414550 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-rruu~ixyd~6kv9 500011 662285 2019-11-27 2019-06-30 119 10         129               129
1364 SWEDISH MEDICAL CENTER / CHERRY HILL 500 17TH AVENUE SEATTLE WA 98122 KING (206) 320-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.6062210 -122.3102490 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-wtid~um6d.vshi 500025 649153 2019-05-29 2018-12-31 125 56         181   30           211
1365 KAISER PERMANENTE CENTRAL HOSPITAL 201 - 16TH AVENUE EAST SEATTLE WA 98112 KING (206) 326-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.6197310 -122.3114130 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-phdi-fixy.kk47 500052 649979 2019-06-06 2018-12-31 24           24               24
1372 UW MEDICINE/NORTHWEST HOSPITAL 1550 NORTH 115TH STREET SEATTLE WA 98133 KING (206) 368-1700 Acute Care Hospitals Voluntary non-profit - Other TRUE 47.7122630 -122.3359360 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-drv9~ptgn-5qjd 500001 660337 2019-11-25 2019-06-30 147 32         179 27             206
1359 SWEDISH MEDICAL CENTER 747 BROADWAY SEATTLE WA 98122 KING (206) 386-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.6092400 -122.3207670 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-rnd2~zqb3.hq8w 500027 653165 2019-08-13 2018-12-31 512 54       80 646 22             668
1357 UNIVERSITY OF WASHINGTON MEDICAL CTR 1959 NE PACIFIC ST BOX 356151 SEATTLE WA 98195 KING (206) 598-3300 Acute Care Hospitals Government - State TRUE 47.6505060 -122.3074820 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-gezf_iitw.mxe8 500008 661427 2018-11-29 2018-06-30 209 81       50 408 16 18           442
1366 HARBORVIEW MEDICAL CENTER 325 9TH AVENUE SEATTLE WA 98104 KING (206) 731-3000 Acute Care Hospitals Government - Local TRUE 47.6040840 -122.3233720 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-fu42.79v4.ss25 500064 659621 2019-11-25 2019-06-30 232 89         321 68 24           413
1361 SEATTLE CHILDREN'S HOSPITAL 4800 SAND POINT WAY NE, PO BOX C-5371 SEATTLE WA 98105 KING (206) 987-2000 Childrens Voluntary non-profit - Private TRUE 47.6645040 -122.2831690 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-7um6_3ase-art7 503300 646369 2019-04-05 2018-09-30 270 91         361               361
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
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
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
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
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
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
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
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 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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
1066 SAINT ALPHONSUS MEDICAL CENTER - NAMPA 4300 E FLAMINGO AVE NAMPA ID 83687 CANYON (208) 205-0050 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.5963320 -116.5191740 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-ei4u.dihn_gvat 130013 660927 2019-12-02 2019-06-30 74 18       4 96               96

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