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 subprovider_ipf_beds

✎ 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
133 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 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
136 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 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
139 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 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
143 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
147 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
150 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 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
153 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 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 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 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 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 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 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 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 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 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 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 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 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 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
168 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
170 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 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 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 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
175 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 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
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
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
180 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 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 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
184 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
187 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 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 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 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 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 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
194 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 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 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 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
199 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 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
201 201 HENDERSON HOSPITAL 1050 WEST GALLERIA DRIVE HENDERSON NV 89011 CLARK (318) 290-4395 Acute Care Hospitals Proprietary TRUE 36.0728432 -115.0304734 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-duqr_nix9.a8cp 290057 648718 2019-05-29 2018-12-31 120 16         140               140
204 204 CENTENNIAL HILLS HOSPITAL MEDICAL CENTER 6900 N DURANGO DR LAS VEGAS NV 89149 CLARK (702) 835-9700 Acute Care Hospitals Proprietary TRUE 36.2860140 -115.2877300 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-mxjv~899t-ww8w 290054 648952 2019-05-30 2018-12-31 217 16         248               248
205 205 ORTHOPEDIC SPECIALTY HOSPITAL OF NEVADA 8656 WEST PATRICK LANE LAS VEGAS NV 89148 CLARK (702) 777-7100 Acute Care Hospitals Voluntary non-profit - Private FALSE 36.0778110 -115.2810360 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-zknv_98at.vvbk 290056 645924 2019-03-28 2018-10-31 130           130               130
206 206 SUNRISE HOSPITAL AND MEDICAL CENTER 3186 S MARYLAND PKWY LAS VEGAS NV 89109 CLARK (702) 731-8000 Acute Care Hospitals Proprietary TRUE 36.1345860 -115.1368830 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-9gwr_6ph4-9w5i 290003 652435 2019-08-01 2019-01-31 376 64     20 72 554   42           596
207 207 SPRING VALLEY HOSPITAL MEDICAL CENTER 5400 SOUTH RAINBOW BLVD LAS VEGAS NV 89118 CLARK (702) 853-3000 Acute Care Hospitals Proprietary TRUE 36.0897140 -115.2428820 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-e224~h6nw_3cd4 290046 649465 2019-05-29 2018-12-31 279 28         337   22           359
208 208 SUMMERLIN HOSPITAL MEDICAL CENTER 657 TOWN CENTER DRIVE LAS VEGAS NV 89144 CLARK (702) 233-7500 Acute Care Hospitals Proprietary TRUE 36.1796380 -115.3157760 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-bs37~asjj.ux8i 290041 649924 2019-05-29 2018-12-31 248 59         370   31           401
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
214 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
215 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
216 216 CUBA MEMORIAL HOSPITAL, INC 140 WEST MAIN STREET CUBA NY 14727 ALLEGANY (585) 961-2000 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.2133410 -78.2881390 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-2ir6~7udp_pyzv 331301 651038 2019-06-03 2018-12-31 20           20       61       81
217 217 JONES MEMORIAL HOSPITAL 191 NORTH MAIN STREET WELLSVILLE NY 14895 ALLEGANY (585) 593-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.1228780 -77.9497840 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-nxxz~ksxe.5xk3 330096 662230 2019-12-02 2019-06-30 43 6         49               49
218 218 CHI MERCY HEALTH 570 CHAUTAUQUA BLVD VALLEY CITY ND 58072 BARNES (701) 845-6400 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.9284920 -97.9949080 0   3 38 38003         https://data.medicare.gov/resource/xubh-q36u/row-pmhy~szku-z7nc 351324 662240 2019-11-26 2019-06-30 25           25               25
219 219 LIMA MEMORIAL HEALTH SYSTEM 1001 BELLEFONTAINE AVENUE LIMA OH 45804 ALLEN (419) 226-3335 Acute Care Hospitals Voluntary non-profit - Other FALSE 40.7356020 -84.0877130 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-p8qs-v8mw~whtd 360009 648963 2019-05-30 2018-12-31 123 16 16       155   17           172
220 220 MERCY HEALTH-ST RITA'S MEDICAL CENTER 730 WEST MARKET STREET LIMA OH 45801 ALLEN (419) 227-3361 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7399980 -84.1174500 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-ewvf-fmc3-mgzs 360066 648298 2019-05-20 2018-12-31 281 18 12       311   18   18   10   357
221 221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
222 222 BLUFFTON HOSPITAL 139 GARAU STREET BLUFFTON OH 45817 ALLEN (419) 358-9010 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8875780 -83.8981490 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-manx~srzz-7qqn 361322 650898 2019-06-04 2018-12-31 25           25               25
225 225 UPMC MCKEESPORT 1500 FIFTH AVENUE MC KEESPORT PA 15132 ALLEGHENY (412) 664-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3523000 -79.8492180 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-vm5i_92bf_4vwi 390002 659604 2019-11-21 2019-06-30 174   12       186   9   18       213
227 227 MAGEE WOMENS HOSPITAL OF UPMC HEALTH SYSTEM 300 HALKET STREET PITTSBURGH PA 15213 ALLEGHENY (412) 641-4010 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.4370770 -79.9595460 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-tusn~f4sz~kzrq 390114 660858 2019-11-27 2019-06-30 220 18         315       20       335
229 229 WEST PENN HOSPITAL 4800 FRIENDSHIP AVENUE PITTSBURGH PA 15224 ALLEGHENY (412) 578-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4624190 -79.9464350 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-yf26.8cka~e7ru 390090 661633 2019-12-02 2019-06-30 124 34   14   20 260   33           293
233 233 UPMC EAST 2775 MOSSIDE BOULEVARD MONROEVILLE PA 15146 ALLEGHENY (412) 357-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4370140 -79.7584580 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-dmwf~khzy.9g9v 390328 659885 2019-11-26 2019-06-30 128 8         136   20           156
234 234 CHILDREN'S HOME OF PITTSBURGH 5324 PENN AVENUE PITTSBURGH PA 15224 ALLEGHENY (412) 441-4884 Childrens Voluntary non-profit - Private FALSE 40.4646370 -79.9376420 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-7vky_uvyh~58pt 393304 659723 2019-10-01 2019-06-30                              
235 235 ALLEGHENY GENERAL HOSPITAL 320 EAST NORTH AVENUE PITTSBURGH PA 15212 ALLEGHENY (412) 359-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4561490 -80.0032490 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-8eek-ck8y_3ey7 390050 661092 2019-12-02 2019-06-30 430 28 24   24 24 552               552
236 236 UPMC CHILDREN'S HOSPITAL OF PITTSBURGH ONE CHILDREN'S HOSPITAL DRIVE PITTSBURGH PA 15224 ALLEGHENY (412) 692-5325 Childrens Voluntary non-profit - Other TRUE 40.4664773 -79.9522935 1 GEOMETRIC_CENTER 3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-ifxe~erpm.ccc7 393302 659888 2019-11-21 2019-06-30 212 36 12       315               315
237 237 UPMC ST MARGARET 815 FREEPORT ROAD PITTSBURGH PA 15215 ALLEGHENY (412) 784-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4874720 -79.8960380 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-iz5k~fx5f.72zy 390102 660441 2019-11-22 2019-06-30 208 14         222   28           250
239 239 UPMC PASSAVANT 9100 BABCOCK BOULEVARD PITTSBURGH PA 15237 ALLEGHENY (412) 367-6700 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.5682350 -80.0165180 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-tred.86gw-r9r3 390107 660016 2019-11-26 2019-06-30 333 32         365   24           389
240 240 UPMC MERCY 1400 LOCUST STREET PITTSBURGH PA 15219 ALLEGHENY (412) 232-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.4368310 -79.9856230 0   3 42 42003 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Allegheny County https://data.medicare.gov/resource/xubh-q36u/row-csxe~5v2n_c3hc 390028 660436 2019-12-02 2019-06-30 307 20       24 369   76           445
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
243 243 TENNOVA HEALTHCARE-SHELBYVILLE 2835 HWY 231 NORTH SHELBYVILLE TN 37160 BEDFORD (931) 685-5433 Acute Care Hospitals Proprietary TRUE 35.5632180 -86.4463720 0   3 47 47003 43180 Nashville-Davidson--Murfreesboro, TN Central Bedford County https://data.medicare.gov/resource/xubh-q36u/row-nnwj-ykm6~eviv 440137 654172 2019-09-04 2019-03-31 36 8         44               44
244 244 PERMIAN REGIONAL MEDICAL CENTER ANDREWS COUNTY HO 720 HOSPITAL DRIVE ANDREWS TX 79714 ANDREWS (432) 523-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3374240 -102.5468660 0   3 48 48003 11380   Central Andrews County https://data.medicare.gov/resource/xubh-q36u/row-juik.55wn.c6fd 450144 643151 2019-02-12 2018-09-30 30           30               30
245 245 BRIGHAM CITY COMMUNITY HOSPITAL 950 SOUTH MEDICAL DRIVE BRIGHAM CITY UT 84302 BOX ELDER (435) 734-9471 Acute Care Hospitals Proprietary TRUE 41.4910700 -112.0244410 0   3 49 49003 36260 Salt Lake City-Provo-Orem, UT Central Box Elder County https://data.medicare.gov/resource/xubh-q36u/row-nuu9~e5qc.3jxf 460017 657558 2019-01-17 2018-08-31 40           40               40
246 246 BEAR RIVER VALLEY HOSPITAL 905 NORTH 1000 WEST TREMONTON UT 84337 BOX ELDER (435) 207-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7237680 -112.1819790 0   3 49 49003 36260 Salt Lake City-Provo-Orem, UT Central Box Elder County https://data.medicare.gov/resource/xubh-q36u/row-dbs5_2pqd_mjjc 460039 647593 2019-05-10 2018-12-31 16           16               16
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
248 248 MARTHA JEFFERSON HOSPITAL 500 MARTHA JEFFERSON DRIVE CHARLOTTESVILLE VA 22911 ALBEMARLE (434) 654-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.0251060 -78.4448550 0   3 51 51003 16820   Central Albemarle County https://data.medicare.gov/resource/xubh-q36u/row-wyg5~56zu_3ctd 490077 650406 2019-05-31 2018-12-31 138 12         150               150
249 249 TRI-STATE MEMORIAL HOSPITAL 1221 HIGHLAND AVENUE CLARKSTON WA 99403 ASOTIN (509) 758-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4036380 -117.0545070 0   3 53 53003 30300   Central Asotin County https://data.medicare.gov/resource/xubh-q36u/row-i7hs.ad2c-g7gn 501332 649847 2019-06-03 2018-12-31 25           25               25
252 252 NORTH BIG HORN HOSPITAL DISTRICT 1115 LANE 12 LOVELL WY 82431 BIG HORN (307) 548-5200 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.8257990 -108.3906880 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-s9vd~bscy-xn2k 531309 662633 2019-11-27 2019-06-30 12           12       85       97
253 253 SOUTH BIG HORN COUNTY CRITICAL ACCESS HOSPITAL 388 US HIGHWAY 20 SOUTH BASIN WY 82410 BIG HORN (307) 568-1500 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.4344490 -108.0490070 0   3 56 56003         https://data.medicare.gov/resource/xubh-q36u/row-vp99_bama.8nds 531301 661691 2019-11-29 2019-06-30 10           10       37       47
256 256 TUBA CITY REGIONAL HEALTH CARE CORPORATION PO BOX 600 TUBA CITY AZ 86045 COCONINO (928) 283-2501 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.1279296 -111.2249984 1 ROOFTOP 5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-hne8.hg7p.2gfd 30073 651368 2019-07-01 2018-09-30 73           73               73
257 257 PAGE HOSPITAL 501 NORTH NAVAJO DRIVE PAGE AZ 86040 COCONINO (928) 645-2424 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.9169600 -111.4631860 0   5 4 4005 22380   Central Coconino County https://data.medicare.gov/resource/xubh-q36u/row-pwtm.vez8_t2h2 31304 649070 2019-06-03 2018-12-31 25           25               25
259 259 SUTTER AMADOR HOSPITAL 200 MISSION BLVD JACKSON CA 95642 AMADOR (209) 223-7500 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3495610 -120.7659050 0   5 6 6005         https://data.medicare.gov/resource/xubh-q36u/row-s5bi-egin.834t 50014 650640 2019-06-03 2018-12-31 46 6         52               52
261 261 SWEDISH MEDICAL CENTER 501 E HAMPDEN AVE ENGLEWOOD CO 80113 ARAPAHOE (303) 788-5000 Acute Care Hospitals Proprietary TRUE 39.6531360 -104.9817100 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-3yvr.y5p2.2bay 60034 643574 2019-02-26 2018-09-30 281 58       17 356   16           372
262 262 CENTURA HEALTH-LITTLETON ADVENTIST HOSPITAL 7700 S BROADWAY LITTLETON CO 80122 ARAPAHOE (303) 730-8900 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.5765540 -104.9884890 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-xab7~spdz_mmxf 60113 649074 2019-06-03 2018-12-31 121 24         159   17           176
265 265 BEEBE MEDICAL CENTER 424 SAVANNAH RD LEWES DE 19958 SUSSEX (302) 645-3300 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7774130 -75.1358600 0   5 10 10005 41540   Central Sussex County https://data.medicare.gov/resource/xubh-q36u/row-h6ng.bwzj-5t95 80007 659769 2019-12-02 2019-06-30 175   20       195               195
266 266 NANTICOKE MEMORIAL HOSPITAL 801 MIDDLEFORD RD SEAFORD DE 19973 SUSSEX (302) 629-6611 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6423320 -75.6053250 0   5 10 10005 41540   Central Sussex County https://data.medicare.gov/resource/xubh-q36u/row-daqn-dq9w~qe8k 80006 659920 2019-12-02 2019-06-30 85 9         94               94
267 267 BAYHEALTH HOSPITAL, SUSSEX CAMPUS 100 WELLNESS WAY MILFORD DE 19963 SUSSEX (302) 422-3311 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8868357 -75.3911438 1 ROOFTOP 5 10 10005 41540   Central Sussex County https://data.medicare.gov/resource/xubh-q36u/row-pqau~nrba-tybq 80009 661150 2019-12-03 2019-06-30 105 9         114   42           156
268 268 ASCENSION SACRED HEART BAY 615 N BONITA AVE PANAMA CITY FL 32401 BAY (850) 769-1511 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.1596810 -85.6470670 0   5 12 12005 37460   Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-sfb2_87vw-qbr7 100026 650248 2019-05-31 2018-12-31 236 57         293               293
269 269 GULF COAST REGIONAL MEDICAL CENTER 449 W 23RD ST PANAMA CITY FL 32405 BAY (850) 769-8341 Acute Care Hospitals Proprietary TRUE 30.1896820 -85.6661240 0   5 12 12005 37460   Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-7wyf_m6mi-z99k 100242 651510 2019-07-01 2019-01-31 170 20       28 222               222
270 270 BACON COUNTY HOSPITAL 302 SOUTH WAYNE STREET ALMA GA 31510 BACON (912) 632-8961 Critical Access Hospitals Voluntary non-profit - Other TRUE 31.5391100 -82.4596870 0   5 13 13005         https://data.medicare.gov/resource/xubh-q36u/row-fsgt~f6fy~f5qx 111327 659492 2019-11-26 2019-06-30 21 4         25       88       113
273 273 COLUMBUS REGIONAL HOSPITAL 2400 E 17TH ST COLUMBUS IN 47201 BARTHOLOMEW (812) 379-4441 Acute Care Hospitals Government - Local TRUE 39.2158720 -85.8968540 0   5 18 18005 18020 Indianapolis-Carmel-Muncie, IN Central Bartholomew County https://data.medicare.gov/resource/xubh-q36u/row-u4i5.cqhh_8kd8 150112 649209 2019-05-31 2018-12-31 194 17         211   18           229
274 274 VETERANS MEMORIAL HOSPITAL 40 1ST STREET SE WAUKON IA 52172 ALLAMAKEE (563) 568-3411 Critical Access Hospitals Government - Local TRUE 43.2680920 -91.4744460 0   5 19 19005         https://data.medicare.gov/resource/xubh-q36u/row-kmrq-g36y.pe5i 161318 660959 2019-12-02 2019-06-30 25           25               25
275 275 ATCHISON HOSPITAL 800 RAVIN HILL DRIVE ATCHISON KS 66002 ATCHISON (913) 360-5581 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5366253 -95.1282386 1 ROOFTOP 5 20 20005 11860 Kansas City-Overland Park-Kansas City, MO-KS Central Atchison County https://data.medicare.gov/resource/xubh-q36u/row-fwt4-3qfd~33ue 171382 645412 2019-03-01 2018-09-30 21 4         25               25
276 276 PREVOST MEMORIAL HOSPITAL 301 MEMORIAL DR DONALDSONVILLE LA 70346 ASCENSION (225) 474-2133 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.0879510 -91.0029040 0   5 22 22005 12940   Central Ascension Parish https://data.medicare.gov/resource/xubh-q36u/row-e567~vwui.ed3h 191308 642472 2019-02-01 2018-08-31 25           25               25

Next page

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE [hospital_data] (
   [hospital_name] TEXT,
   [address] TEXT,
   [city] TEXT,
   [state] TEXT,
   [zip_code] INTEGER,
   [county_name] TEXT,
   [phone_number] TEXT,
   [hospital_type] TEXT,
   [hospital_ownership] TEXT,
   [emergency_services] TEXT,
   [lat] TEXT,
   [lng] TEXT,
   [geocode_flag] INTEGER,
   [geocode_accuracy] TEXT,
   [countyfips] INTEGER,
   [statefips] INTEGER,
   [statecountyfips] INTEGER,
   [cbsacode] TEXT,
   [csatitle] TEXT,
   [centraloutlyingcounty] TEXT,
   [countyequivalent] TEXT,
   [hosp_lookup_url] TEXT,
   [PRVDR_NUM] INTEGER,
   [RPT_REC_NUM] INTEGER,
   [filed_date] TEXT,
   [fy_end_date] TEXT,
   [acute_beds] INTEGER,
   [icu_beds] TEXT,
   [coronary_beds] TEXT,
   [burn_beds] TEXT,
   [surg_icu_beds] TEXT,
   [oth_spec_beds] TEXT,
   [subtotal_acute_beds] INTEGER,
   [subprovider_ipf_beds] TEXT,
   [subprovider_irf_beds] TEXT,
   [subprovider_oth_beds] TEXT,
   [skilled_nursing_beds] TEXT,
   [nursing_fac_beds] TEXT,
   [oth_longterm_beds] TEXT,
   [hospice_beds] TEXT,
   [all_beds] INTEGER
);