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

View and edit SQL

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
101 BARRETT HOSPITAL & HEALTHCARE 600 MT HWY 91 S DILLON MT 59725 BEAVERHEAD (406) 683-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.2006540 -112.6460030 0   1 30 30001         https://data.medicare.gov/resource/xubh-q36u/row-2tkn_v7av-d2ep 271318 662223 2019-11-27 2019-06-30 18           18               18
102 MARY LANNING HEALTHCARE 715 N ST JOSEPH AVE HASTINGS NE 68901 ADAMS (402) 461-5108 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5924160 -98.3874740 0   1 31 31001 25580   Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-6nbf.h76f_85sy 280032 648632 2019-05-24 2018-12-31 87 10         97 26 9   11       143
103 BANNER CHURCHILL COMMUNITY HOSPITAL 801 EAST WILLIAMS AVENUE FALLON NV 89406 CHURCHILL (775) 423-3151 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.4748760 -118.7651800 0   1 32 32001 21980   Central Churchill County https://data.medicare.gov/resource/xubh-q36u/row-2y58~2j5s~r7uz 291313 654684 2019-09-18 2018-12-31 25           25               25
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
105 ATLANTICARE REGIONAL MEDICAL CENTER - CITY CAMPUS 1925 PACIFIC AVENUE ATLANTIC CITY NJ 8401 ATLANTIC (609) 441-8020 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3577910 -74.4339420 0   1 34 34001 12100 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Atlantic County https://data.medicare.gov/resource/xubh-q36u/row-bp79~7q24_hctk 310064 661933 2019-11-29 2019-06-30 470 38 10       540               540
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
107 LOVELACE WOMEN'S HOSPITAL 4701 MONTGOMERY BOULEVARD NE ALBUQUERQUE NM 87109 BERNALILLO (505) 727-7805 Acute Care Hospitals Government - State TRUE 35.1310050 -106.5910370 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-fycu~sc7u.8im7 320017 655223 2019-10-17 2019-04-30 112 8       42 162               162
108 LOVELACE MEDICAL CENTER 601 DR MARTIN LUTHER KING JR AVE NE ALBUQUERQUE NM 87102 BERNALILLO (505) 727-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0856220 -106.6397650 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-kci4.56nf~rfu7 320009 652759 2019-07-29 2019-02-28 245 48         293               293
109 LOVELACE WESTSIDE HOSPITAL 10501 GOLF COURSE ROAD NW ALBUQUERQUE NM 87114 BERNALILLO (505) 727-2001 Acute Care Hospitals Proprietary TRUE 35.2075080 -106.6759740 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-t6an-qbnd.nby8 320074 651222 2019-06-28 2019-01-31 62 8         70               70
110 UNM HOSPITAL 2211 LOMAS BOULEVARD NE ALBUQUERQUE NM 87106 BERNALILLO (505) 272-2111 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.0874830 -106.6181480 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-ntcm.qi4a~h9yr 320001 661059 2019-11-26 2019-06-30 345           473 82             555
111 PRESBYTERIAN HOSPITAL 1100 CENTRAL AVENUE SE ALBUQUERQUE NM 87106 BERNALILLO (505) 724-8386 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0822950 -106.6345300 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-6ve3~533u~8w78 320021 652598 2019-08-14 2018-12-31 538 47 21       671 45         10   726
112 ALBANY MEMORIAL HOSPITAL 600 NORTHERN BOULEVARD ALBANY NY 12204 ALBANY (518) 471-3490 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6746850 -73.7488610 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-fbeu-trch-uemx 330003 661359 2019-11-27 2019-06-30 57 16         73               73
113 ST PETER'S HOSPITAL 315 SOUTH MANNING BOULEVARD ALBANY NY 12208 ALBANY (518) 525-1550 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6601760 -73.8023820 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-sq59.k3z9-zynf 330057 662055 2019-12-18 2019-06-30 445   22     15 482               482
114 ALBANY MEDICAL CENTER HOSPITAL 43 NEW SCOTLAND AVENUE, MAIL CODE 34 ALBANY NY 12208 ALBANY (518) 262-2400 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6532540 -73.7738600 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-sggw.e236~c5a3 330013 649473 2019-05-29 2018-12-31 585 65 17     60 747 26 20           793
115 ALAMANCE REGIONAL MEDICAL CENTER 1240 HUFFMAN MILL RD BURLINGTON NC 27216 ALAMANCE (336) 538-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0637490 -79.5025280 0   1 37 37001 15500 Greensboro--Winston-Salem--High Point, NC Central Alamance County https://data.medicare.gov/resource/xubh-q36u/row-x8vw.bx9c.7dbj 340070 643428 2019-02-27 2018-09-30 144 20         176 36             212
116 WEST RIVER REGIONAL MEDICAL CENTER-CAH 1000 HIGHWAY 12 HETTINGER ND 58639 ADAMS (701) 567-4561 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0013230 -102.6282390 0   1 38 38001         https://data.medicare.gov/resource/xubh-q36u/row-kpck-85x6-gtvw 351330 654546 2019-08-29 2019-03-31 25           25               25
117 ADAMS COUNTY REGIONAL MEDICAL CENTER 230 MEDICAL CENTER DRIVE SEAMAN OH 45679 ADAMS (937) 386-3400 Critical Access Hospitals Government - Local TRUE 38.9338480 -83.5856120 0   1 39 39001         https://data.medicare.gov/resource/xubh-q36u/row-wb9j-jzwz-2xmu 361326 649329 2019-05-30 2018-12-31 25           25               25
118 MEMORIAL HOSPITAL 1401 WEST LOCUST STILWELL OK 74960 ADAIR (918) 696-3101 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.8085290 -94.6430100 0   1 40 40001         https://data.medicare.gov/resource/xubh-q36u/row-7atr.sncy~icbf 370178 660001 2019-12-02 2019-06-30 30           30 10             40
119 SAINT ALPHONSUS MEDICAL CENTER - BAKER CITY, INC 3325 POCAHONTAS ROAD BAKER CITY OR 97814 BAKER (541) 524-7744 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.7961200 -117.8462850 0   1 41 41001         https://data.medicare.gov/resource/xubh-q36u/row-yt65-wbpr_7cai 381315 661086 2019-12-02 2019-06-30 19 2         21               21
120 GETTYSBURG HOSPITAL 147 GETTYS STREET GETTYSBURG PA 17325 ADAMS (717) 334-2121 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.8233170 -77.2340440 0   1 42 42001 23900 Harrisburg-York-Lebanon, PA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-493f.cvfq~sac8 390065 660855 2019-11-26 2019-06-30 68 8         76               76
121 ABBEVILLE AREA MEDICAL CENTER 420 THOMSON CIRCLE ABBEVILLE SC 29620 ABBEVILLE (864) 366-5011 Critical Access Hospitals Government - Local TRUE 34.1561250 -82.3801740 0   1 45 45001 24940 Greenville-Spartanburg-Anderson, SC Outlying Abbeville County https://data.medicare.gov/resource/xubh-q36u/row-v8xu.2huz_ubxe 421301 645182 2019-02-25 2018-09-30 19 6         25               25
122 METHODIST MEDICAL CENTER OF OAK RIDGE 990 OAK RIDGE TURNPIKE BOX 529 OAK RIDGE TN 37830 ANDERSON (865) 835-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0233970 -84.2439000 0   1 47 47001 28940 Knoxville-Morristown-Sevierville, TN Central Anderson County https://data.medicare.gov/resource/xubh-q36u/row-9qg8-3nhv.xeq4 440034 648762 2019-05-28 2018-12-31 179 25         204               204
123 PALESTINE REGIONAL MEDICAL CENTER 2900 S LOOP 256 PALESTINE TX 75801 ANDERSON (903) 731-1000 Acute Care Hospitals Proprietary TRUE 31.7333740 -95.6253070 0   1 48 48001 37300   Central Anderson County https://data.medicare.gov/resource/xubh-q36u/row-ymbb~yh2p_i5c8 450747 649500 2019-06-04 2018-12-31 106 10         116 19 17           152
124 BEAVER VALLEY HOSPITAL 1109 NORTH 100 WEST BEAVER UT 84713 BEAVER (435) 438-7100 Critical Access Hospitals Government - State TRUE 38.2892580 -112.6432040 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-x2bw~6dhq.mh7x 461335 659078 2019-11-20 2019-06-30 25           25               25
125 MILFORD VALLEY MEMORIAL HOSPITAL 850 NORTH MAIN STREET MILFORD UT 84751 BEAVER (435) 387-2411 Critical Access Hospitals Government - Hospital District or Authority FALSE 38.4073080 -113.0095430 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-iet4.f5zs.batz 461305 648782 2019-05-29 2018-12-31 5           5           18   23
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
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
128 OTHELLO COMMUNITY HOSPITAL 315 NORTH 14TH AVENUE OTHELLO WA 99344 ADAMS (509) 488-2636 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.8303630 -119.1543630 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-5z56.vhnt-5g9t 501318 658624 2019-11-12 2018-12-31 16           16               16
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
132 IVINSON MEMORIAL HOSPITAL 255 N 30TH LARAMIE WY 82072 ALBANY (307) 755-4600 Acute Care Hospitals Government - Hospital District or Authority TRUE 41.3113900 -105.5575120 0   1 56 56001 29660   Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-ptq5-c827_j29e 530025 660342 2019-12-03 2019-06-30 62 4         66 10     10       86
133 SOUTH BALDWIN REGIONAL MEDICAL CENTER 1613 NORTH MCKENZIE STREET FOLEY AL 36535 BALDWIN (251) 949-3400 Acute Care Hospitals Proprietary TRUE 30.4261090 -87.6831870 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-pyt4.i3a3.r8cm 10083 645389 2019-03-01 2018-09-30 82 30         112               112
134 THOMAS HOSPITAL 750 MORPHY AVENUE FAIRHOPE AL 36532 BALDWIN (251) 928-2375 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.5199990 -87.8903330 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-47ke~57kn.r69r 10100 653821 2019-08-30 2019-03-31 112 10     7   129   12           141
135 NORTH BALDWIN INFIRMARY 1815 HAND AVENUE BAY MINETTE AL 36507 BALDWIN (251) 937-5521 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.9024920 -87.7833180 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-vac9~xsmg.2gg8 10129 653823 2019-08-30 2019-03-31 51 4         55 15             70
136 COPPER QUEEN COMMUNITY HOSPITAL 101 COLE AVENUE BISBEE AZ 85603 COCHISE (520) 432-6401 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.4172540 -109.8826000 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-3x2q~x9dv.fg6n 31312 659555 2019-11-25 2019-06-30 14           14               14
137 BENSON HOSPITAL 450 SOUTH OCOTILLO AVENUE BENSON AZ 85602 COCHISE (520) 586-2261 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.9648290 -110.3071230 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-bbyb-3jvj_e7ef 31301 660910 2019-11-25 2019-06-30 22           22               22
138 CANYON VISTA MEDICAL CENTER 5700 EAST HIGHWAY 90 SIERRA VISTA AZ 85635 COCHISE (520) 263-3001 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.5546350 -110.2307260 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ghfv-yx8h~hkgn 30043 654824 2019-09-30 2019-04-30 63 12         75 19             94
139 NORTHERN COCHISE COMMUNITY HOSPITAL, INC. 901 WEST REX ALLEN DRIVE WILLCOX AZ 85643 COCHISE (520) 384-3541 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.2642680 -109.8376130 0   3 4 4003 43420   Central Cochise County https://data.medicare.gov/resource/xubh-q36u/row-ydad~45b6.8t7t 31302 660487 2019-12-02 2019-06-30 24           24       24       48
140 SAN LUIS VALLEY HEALTH 106 BLANCA AVE ALAMOSA CO 81101 ALAMOSA (719) 589-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4723600 -105.8837120 0   3 8 8003         https://data.medicare.gov/resource/xubh-q36u/row-bztx~k7ma~ri7p 60008 661701 2019-12-03 2019-06-30 43 6         49               49
141 HARTFORD HOSPITAL 80 SEYMOUR STREET HARTFORD CT 6102 HARTFORD (860) 545-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7541230 -72.6808200 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-rks5-ncpa-u5sg 70025 645239 2019-03-20 2018-09-30 645 84         729 105     104       938
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
143 CONNECTICUT CHILDRENS MEDICAL CENTER 282 WASHINGTON STREET HARTFORD CT 6106 HARTFORD (860) 545-9000 Childrens Voluntary non-profit - Private TRUE 41.7534820 -72.6828120 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-ew6z.c4u9~qxnc 73300 645529 2019-03-25 2018-09-30 97           187               187
144 MANCHESTER MEMORIAL HOSPITAL 71 HAYNES ST MANCHESTER CT 6040 HARTFORD (860) 647-4780 Acute Care Hospitals Proprietary TRUE 41.7810870 -72.5252210 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-shzd.8q5k_ybhg 70027 650673 2019-05-30 2018-12-31 108 32         140 31             171
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
146 HOSPITAL OF CENTRAL CONNECTICUT, THE 100 GRAND STREET NEW BRITAIN CT 6050 HARTFORD (860) 224-5011 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.6620150 -72.7877990 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-wbxc-gjw3~i99u 70035 645240 2019-03-01 2018-09-30 222 24         246 32             278
147 BIG HORN HOSPITAL 17 N MILES HARDIN MT 59034 BIG HORN (406) 665-2310 Critical Access Hospitals Government - Local TRUE 45.7288560 -107.6170100 0   3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-2cgz.f5s8-gu8f 271338 652087 2018-11-27 2018-06-30 25           25               25
148 HEBREW HOME AND HOSPITAL INC 1 ABRAHMS BOULEVARD WEST HARTFORD CT 6117 HARTFORD (860) 523-3800 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.8027740 -72.7289310 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-eqjh_iqnh-wsnp 70040 645324 2019-02-28 2018-09-30 23           23 22             45
149 ST FRANCIS HOSPITAL & MEDICAL CENTER 114 WOODLAND STREET HARTFORD CT 6105 HARTFORD (860) 714-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.7750800 -72.6994680 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-hefq_uhkr~b49c 70002 645633 2019-03-28 2018-09-30 425 42         495 77             572
150 ST FRANCIS HOSPITAL 7TH AND CLAYTON STS WILMINGTON DE 19805 NEW CASTLE (302) 421-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7498827 -75.5665813 1 ROOFTOP 3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-2uda_n6xn~szp8 80003 660361 2019-12-03 2019-06-30 154 20         180               180
151 ALFRED I DUPONT HOSPITAL FOR CHILDREN 1600 ROCKLAND RD PO BOX 269 WILMINGTON DE 19899 NEW CASTLE (302) 651-4000 Childrens Voluntary non-profit - Private TRUE 39.7823370 -75.5552390 0   3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-b9cf-cftg-3kpg 83300 659028 2019-11-13 2018-12-31 114         24 208               208
152 CHRISTIANA CARE HEALTH SERVICES, INC. 4755 OGLETOWN-STANTON ROAD NEWARK DE 19718 NEW CASTLE (302) 733-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6899090 -75.6732280 0   3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-4npa_3h9a~qmvr 80001 659768 2019-11-27 2019-06-30 920 73 35       1097 30 39           1166
153 ED FRASER MEMORIAL HOSPITAL 159 N 3RD ST MACCLENNY FL 32063 BAKER (904) 259-3151 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.2855500 -82.1195500 0   3 12 12003 27260 Jacksonville-St. Marys-Palatka, FL-GA Outlying Baker County https://data.medicare.gov/resource/xubh-q36u/row-bder~g3nx~udyj 100134 644243 2019-03-01 2018-09-30 21           21       68       89
154 KUAKINI MEDICAL CENTER 347 NORTH KUAKINI STREET HONOLULU HI 96817 HONOLULU (808) 536-2236 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3222110 -157.8562110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-haju_ivwx-iwr6 120007 656434 2018-12-26 2018-06-30 146 12 12       170       40 147     357
155 PALI MOMI MEDICAL CENTER 98-1079 MOANALUA ROAD AIEA HI 96701 HONOLULU (808) 486-6000 Acute Care Hospitals Proprietary TRUE 21.3839880 -157.9376750 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-gvhj-d3a6.ypz3 120026 659776 2019-11-26 2019-06-30 110 8         118               118
156 KAPIOLANI MEDICAL CENTER FOR WOMEN & CHILDREN 1319 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 983-6000 Childrens Voluntary non-profit - Private TRUE 21.3003960 -157.8342460 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-2vss_bgb6-b6d4 123300 659778 2019-11-26 2019-06-30 156 3         253               253
157 KAISER FOUNDATION HOSPITAL 3288 MOANALUA RD HONOLULU HI 96819 HONOLULU (808) 432-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3622920 -157.9001390 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-58ey-5yy7~4xmg 120011 652244 2019-06-06 2018-12-31 252 25         295               295
158 SHRINERS HOSPITAL FOR CHILDREN 1310 PUNAHOU STREET HONOLULU HI 96826 HONOLULU (808) 941-4466 Childrens Voluntary non-profit - Private FALSE 21.3002330 -157.8343650 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-jcn3.53aq~rski 123301 644976 2018-05-31 2017-12-31                              
159 Tripler AMC (FT Shafter) 1 Jarrett White Rd Honolulu HI 96859 HONOLULU (808) 433-2778 Acute Care - Department of Defense Department of Defense TRUE 21.3588670 -157.8887690 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-xb5h~t6w7_qec8                                      
160 THE QUEENS MEDICAL CENTER 1301 PUNCHBOWL ST HONOLULU HI 96813 HONOLULU (808) 538-9011 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.3083070 -157.8549650 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-miez-e8mq~vhab 120001 662517 2019-11-29 2019-06-30 592 58         650               650
161 ADVENTIST HEALTH CASTLE 640 ULUKAHIKI ST KAILUA HI 96734 HONOLULU (808) 263-5500 Acute Care Hospitals Voluntary non-profit - Church TRUE 21.3815020 -157.7572290 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-5zcn.p8qz~eqqf 120006 655891 2019-10-07 2018-12-31 152 8         160               160
162 STRAUB CLINIC AND HOSPITAL 888 SO KING STREET HONOLULU HI 96813 HONOLULU (808) 522-4000 Acute Care Hospitals Proprietary TRUE 21.3022680 -157.8509210 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-j69k-r5cq-9v28 120022 659775 2019-11-26 2019-06-30 140 16   3     159               159
163 KAHUKU MEDICAL CENTER 56-117 PUALALEA STREET KAHUKU HI 96731 HONOLULU (808) 293-9221 Critical Access Hospitals Voluntary non-profit - Other TRUE 21.6764400 -157.9522110 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-gwji.69dv_68xy 121304 661306 2019-12-02 2019-06-30 15           15       6       21
164 WAHIAWA GENERAL HOSPITAL 128 LEHUA STREET WAHIAWA HI 96786 HONOLULU (808) 621-8411 Acute Care Hospitals Voluntary non-profit - Private TRUE 21.4985110 -158.0272990 0   3 15 15003 46520   Central Honolulu County https://data.medicare.gov/resource/xubh-q36u/row-tmp7_2wk5_m9wr 120004 662186 2019-11-26 2019-06-30 37 6         43       107       150
165 LUTHERAN HOSPITAL OF INDIANA 7950 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-7001 Acute Care Hospitals Proprietary TRUE 41.0373740 -85.2458850 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-22sz~6zvg.fbpc 150017 661886 2019-12-03 2019-06-30 254   24       396               396
166 DUPONT HOSPITAL LLC 2520 E DUPONT RD FORT WAYNE IN 46825 ALLEN (260) 416-3000 Acute Care Hospitals Proprietary TRUE 41.1786890 -85.1106030 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-q73v-xd2h_rmgd 150150 654122 2019-09-04 2019-03-31 92 10         131               131
167 ST JOSEPH HOSPITAL 700 BROADWAY FORT WAYNE IN 46802 ALLEN (260) 425-3000 Acute Care Hospitals Proprietary TRUE 41.0788910 -85.1488730 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kr9f_9zxq-kk6p 150047 655893 2019-10-31 2019-05-31 76     12     88 19     20       127
168 THE ORTHOPAEDIC HOSPITAL OF LUTHERAN HEALTH NETWOR 7952 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-2999 Acute Care Hospitals Proprietary FALSE 41.0373520 -85.2459180 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-65sn_hsdz_dbbf 150168 649728 2019-06-03 2018-12-31 39           39               39
169 PARKVIEW REGIONAL MEDICAL CENTER 11109 PARKVIEW PLAZA DRIVE FORT WAYNE IN 46845 ALLEN (260) 266-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1870630 -85.0994600 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-exxr.2nie.5hvd 150021 649561 2019-05-30 2018-12-31 404 124         566 74 31   41       712
170 ORTHOPAEDIC HOSPITAL AT PARKVIEW NORTH LLC 11130 PARKVIEW CIRCLE DR FORT WAYNE IN 46845 ALLEN (260) 672-4050 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.1886620 -85.1032920 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-eyta.fsu8.cmma 150167 654435 2019-05-29 2018-12-31 37           37               37
171 CHI HEALTH - MERCY CORNING 603 ROSARY DRIVE CORNING IA 50841 ADAMS (641) 322-3121 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.9883750 -94.7479140 0   3 19 19003         https://data.medicare.gov/resource/xubh-q36u/row-bgwm_q3kt_uw3g 161304 661177 2019-12-02 2019-06-30 22           22               22
172 ANDERSON COUNTY HOSPITAL 421 S MAPLE GARNETT KS 66032 ANDERSON (785) 204-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.2801200 -95.2493000 0   3 20 20003         https://data.medicare.gov/resource/xubh-q36u/row-3ktx.x5ze~zgrj 171316 648620 2019-05-24 2018-12-31 12           12           36   48
173 THE MEDICAL CENTER AT SCOTTSVILLE 456 BURNLEY ROAD SCOTTSVILLE KY 42164 ALLEN (270) 622-2800 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.7597650 -86.2162120 0   3 21 21003 14540 Bowling Green-Glasgow, KY Outlying Allen County https://data.medicare.gov/resource/xubh-q36u/row-v9hf~phby-c7vz 181324 654252 2019-09-03 2019-03-31 25           25       110       135
174 ALLEN PARISH HOSPITAL 108 6TH AVENUE KINDER LA 70648 ALLEN (337) 738-2527 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.4914530 -92.8556480 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-572u~e5cv~bbuy 190133 659958 2019-12-02 2019-06-30 25           25 24             49
175 OAKDALE COMMUNITY HOSPITAL 130 N HOSPITAL DR OAKDALE LA 71463 ALLEN (318) 335-3700 Acute Care Hospitals Proprietary TRUE 30.8162640 -92.6445450 0   3 22 22003         https://data.medicare.gov/resource/xubh-q36u/row-7xwr-vazc_74w6 190106 654443 2019-09-09 2019-03-31 46 3         49               49
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 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 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
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
180 UMD BALTIMORE WASHINGTON MEDICAL CENTER 301 HOSPITAL DRIVE GLEN BURNIE MD 21061 ANNE ARUNDEL (410) 595-1967 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.1387840 -76.6222470 0   3 24 24003 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Anne Arundel County https://data.medicare.gov/resource/xubh-q36u/row-ny53_dgkn_gitj 210043 659804 2019-12-02 2019-06-30 242 30         272               272
181 ANNE ARUNDEL MEDICAL CENTER 2001 MEDICAL PARKWAY ANNAPOLIS MD 21401 ANNE ARUNDEL (443) 481-1307 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9911150 -76.5360580 0   3 24 24003 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Anne Arundel County https://data.medicare.gov/resource/xubh-q36u/row-npuw_t7wm.mrix 210023 662537 2019-12-23 2019-06-30 329 20       30 379               379
182 FAIRVIEW HOSPITAL 29 LEWIS AVENUE GREAT BARRINGTON MA 1230 BERKSHIRE (413) 528-0790 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1919820 -73.3725230 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-6zsa~q4z7~nrdp 221302 645425 2019-03-01 2018-09-30 20 4         24               24
183 BERKSHIRE MEDICAL CENTER INC - 1 725 NORTH STREET PITTSFIELD MA 1201 BERKSHIRE (413) 447-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.4587480 -73.2490040 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-58b2-r4te.ddyn 220046 661336 2019-12-02 2018-09-30 201 20         221 40 14           275
184 MUNISING MEMORIAL HOSPITAL 1500 SAND POINT RD MUNISING MI 49862 ALGER (906) 387-4110 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4238490 -86.6257160 0   3 26 26003         https://data.medicare.gov/resource/xubh-q36u/row-7pqa.fabg.y26z 231308 654139 2019-09-04 2019-03-31 11           11               11
185 MERCY HOSPITAL 4050 COON RAPIDS BLVD COON RAPIDS MN 55433 ANOKA (762) 236-8100 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.1838420 -93.3682210 0   3 27 27003 33460 Minneapolis-St. Paul, MN-WI Central Anoka County https://data.medicare.gov/resource/xubh-q36u/row-5tcm_8mvh-id9x 240115 651903 2019-07-09 2018-12-31 431 35         466 15             481
186 MAGNOLIA REGIONAL HEALTH CENTER 611 ALCORN DRIVE CORINTH MS 38834 ALCORN (662) 293-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.9358670 -88.5586480 0   3 28 28003 18420   Central Alcorn County https://data.medicare.gov/resource/xubh-q36u/row-7e2c-erdj.3exa 250009 643795 2019-02-28 2018-09-30 139 24         163 19             182
187 P H S INDIAN HOSPITAL CROW / NORTHERN CHEYENNE 1010 SOUTH 7650 EAST, POST OFFICE BOX 9 CROW AGENCY MT 59022 BIG HORN (406) 638-2626 Critical Access Hospitals Government - Federal TRUE 45.5821958 -107.4488586 1 ROOFTOP 3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-pgmt~4b42~eq7a 271339 646565 2019-03-26 2018-09-30 24           24               24
188 ANTELOPE MEMORIAL HOSPITAL P O BOX 229, 102 WEST 9TH ST NELIGH NE 68756 ANTELOPE (402) 887-4151 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1336539 -98.0299847 1 ROOFTOP 3 31 31003         https://data.medicare.gov/resource/xubh-q36u/row-uv86-cr3r-pfws 281326 661040 2019-12-02 2019-06-30 23           23               23
189 VALLEY HOSPITAL MEDICAL CENTER 620 SHADOW LANE LAS VEGAS NV 89106 CLARK (702) 388-4000 Acute Care Hospitals Proprietary TRUE 36.1639140 -115.1654630 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-h9xh~nrzf.p42d 290021 649464 2019-05-29 2018-12-31 229 20 25       274   16           290
190 99th Medical Group (Nellis AFB) 99 MDG 4700 Las Vegas Blvd Nellis AFB NV 89191 CLARK (702) 653-2273 Acute Care - Department of Defense Department of Defense TRUE 36.2457836 -115.0497641 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-dmy4.2nr3_wdjy                                      
191 HARMON HOSPITAL 2170 EAST HARMON AVENUE LAS VEGAS NV 89119 CLARK (702) 794-0100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.1073690 -115.1219920 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-qtzp-aczd_sysf 290042 629833 2018-05-31 2017-12-31                              
192 UNIVERSITY MEDICAL CENTER 1800 W CHARLESTON BLVD LAS VEGAS NV 89102 CLARK (702) 383-2000 Acute Care Hospitals Government - Local TRUE 36.1589410 -115.1659450 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-crh9_6nqs_53ud 290007 662546 2019-11-29 2019-06-30 358 20 24 16 16 14 498               498
193 DESERT SPRINGS HOSPITAL 2075 EAST FLAMINGO ROAD LAS VEGAS NV 89119 CLARK (702) 369-7600 Acute Care Hospitals Proprietary TRUE 36.1145610 -115.1255480 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-h6f4_d5w8_jhfe 290022 649621 2019-05-29 2018-12-31 215 34         249 32 12           293
194 MOUNTAINVIEW HOSPITAL 3100 N TENAYA WAY LAS VEGAS NV 89128 CLARK (702) 255-5065 Acute Care Hospitals Proprietary TRUE 36.2156000 -115.2507950 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-ifwz~wzbs.p5xc 290039 650298 2019-05-28 2018-12-31 277 47       24 348   36           384
195 SAINT ROSE DOMINICAN HOSPITALS - SIENA CAMPUS 3001 ST ROSE PARKWAY HENDERSON NV 89052 CLARK (702) 616-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0045271 -115.1150581 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8dra~5wtd-jnuh 290045 662405 2018-11-30 2018-06-30 244 50         326               326
196 SAINT ROSE DOMINICAN HOSPITALS - ROSE DE LIMA 102 E LAKE MEAD DR HENDERSON NV 89015 CLARK (702) 616-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.0388290 -114.9831920 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-r9pq.jhhc.4qfi 290012 657913 2018-11-30 2018-06-30 72 10         82   28           110
197 MESA VIEW REGIONAL HOSPITAL 1299 BERTHA HOWE AVENUE MESQUITE NV 89027 CLARK (702) 346-8040 Critical Access Hospitals Proprietary TRUE 36.8088590 -114.1144560 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8rk4-cq3s_fa8n 291307 640239 2018-12-18 2018-07-31 21 4         25               25
198 BOULDER CITY HOSPITAL 901 ADAMS BLVD BOULDER CITY NV 89005 CLARK (702) 293-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9683590 -114.8434860 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-m2cb.9j9h-qmdd 291309 651018 2019-06-03 2018-12-31 25           25 10     47       82
199 SAINT ROSE DOMINICAN HOSPITALS - SAN MARTIN CAMPUS 8280 W WARM SPRINGS ROAD LAS VEGAS NV 89113 CLARK (702) 492-8509 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.0555450 -115.2713230 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-sdqu.kd85~4dy8 290053 662224 2019-12-03 2019-06-30 106 24         136               136
200 DIGNITY HEALTH ST ROSE DOMINICAN N L V CAMPUS 1550 W CRAIG RANCH NORTH LAS VEGAS NV 89031 CLARK (702) 777-3615 Acute Care Hospitals Proprietary TRUE 36.2434428 -115.1500008 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-u3b3_a37u-466v 290058 652436 2019-05-30 2018-12-31 32           32               32

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