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

212 rows where "filed_date" is on date 2019-11-26 sorted by coronary_beds

View and edit SQL

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date)

  • 2019-11-26 · 212
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
25 ESSENTIA HEALTH ADA 201 9TH STREET WEST ADA MN 56510 NORMAN (218) 784-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2960910 -96.5301900 0   107 27 27107         https://data.medicare.gov/resource/xubh-q36u/row-z63y_de5x~9s9u 241313 660607 2019-11-26 2019-06-30 14           14               14
57 ST ANTHONY NORTH HEALTH CAMPUS 14300 ORCHARD PKWY WESTMINSTER CO 80023 BROOMFIELD (720) 627-0000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9558100 -104.9936710 0   1 8 8001 19740 Denver-Aurora, CO Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-ids9.66gw~rrbq 60104 659640 2019-11-26 2019-06-30 72 20         92               92
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
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
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
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
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
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
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
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
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
285 MEDSTAR FRANKLIN SQUARE MEDICAL CENTER 9000 FRANKLIN SQUARE DRIVE BALTIMORE MD 21237 BALTIMORE (443) 777-7850 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3503350 -76.4810120 0   5 24 24005 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore County https://data.medicare.gov/resource/xubh-q36u/row-qdqy_nadx.4qry 210015 660388 2019-11-26 2019-06-30 321 26         347               347
291 ESSENTIA HEALTH ST MARYS - DETROIT LAKES 1027 WASHINGTON AVE DETROIT LAKES MN 56501 BECKER (218) 847-0888 Acute Care Hospitals Voluntary non-profit - Church FALSE 46.8153070 -95.8454530 0   5 27 27005         https://data.medicare.gov/resource/xubh-q36u/row-my2b~zwif~njdr 240101 660605 2019-11-26 2019-06-30 28 8         36       96       132
293 COMMUNITY HOSPITAL ASSOCIATION 26136 US HIGHWAY 59, PO BOX 107 FAIRFAX MO 64446 ATCHISON (660) 686-2211 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3482150 -95.3973230 0   5 29 29005         https://data.medicare.gov/resource/xubh-q36u/row-kkzi.c85k.9msb 261303 660249 2019-11-26 2019-06-30 16           16               16
299 VIRTUA WILLINGBORO HOSPITAL 218A SUNSET ROAD WILLINGBORO NJ 8046 BURLINGTON (609) 835-2900 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0486320 -74.8819820 0   5 34 34005 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Burlington County https://data.medicare.gov/resource/xubh-q36u/row-4ph9_abjf-fd9w 310061 660414 2019-11-26 2019-06-30 104 20         124 20             144
349 WILCOX MEMORIAL HOSPITAL 3-3420 KUHIO HIGHWAY LIHUE HI 96766 KAUAI (808) 245-1103 Acute Care Hospitals Government - Federal TRUE 21.9870430 -159.3661980 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-9k2j.d4pk.dvnd 120014 662037 2019-11-26 2019-06-30 65 7         72               72
424 MOLOKAI GENERAL HOSPITAL 280 HOME OLU PLACE KAUNAKAKAI HI 96748 MAUI (808) 553-5331 Critical Access Hospitals Voluntary non-profit - Private TRUE 21.0937600 -157.0179820 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-vd6b-yn49_x98y 121303 659777 2019-11-26 2019-06-30 15           15               15
431 UNIVERSITY OF KS HLTH SYSTEM GREAT BEND CAMPUS 514 CLEVELAND STREET GREAT BEND KS 67530 BARTON (620) 792-8833 Acute Care Hospitals Proprietary TRUE 38.3562000 -98.7916190 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-ezt6_4fjw-kpxn 170191 660092 2019-11-26 2019-06-30 29 4         33               33
447 MERCY HOSPITAL CASSVILLE 94 MAIN STREET CASSVILLE MO 65625 BARRY (417) 847-6065 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.6740770 -93.8718860 0   9 29 29009         https://data.medicare.gov/resource/xubh-q36u/row-wswc_mpwv.fwbj 261317 660251 2019-11-26 2019-06-30 18           18               18
461 UPMC BEDFORD MEMORIAL 10455 LINCOLN HIGHWAY EVERETT PA 15537 BEDFORD (814) 623-6161 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0247210 -78.4332550 0   9 42 42009         https://data.medicare.gov/resource/xubh-q36u/row-a7tx_6h63.ijq9 390117 659869 2019-11-26 2019-06-30 36 4         40               40
465 LANDMANN-JUNGMAN MEMORIAL HOSPITAL - CAH 600 BILLARS ST SCOTLAND SD 57059 BON HOMME (605) 583-2226 Critical Access Hospitals Government - Local TRUE 43.1494940 -97.7281040 0   9 46 46009         https://data.medicare.gov/resource/xubh-q36u/row-h5nm-t8q8-ubs6 431317 662141 2019-11-26 2019-06-30 25           25               25
528 SOUTHERN COOS HOSPITAL & HEALTH CENTER 900 11TH STREET SE BANDON OR 97411 COOS (541) 347-2426 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.1132440 -124.4024260 0   11 41 41011 18300   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-gr9r_ty5i_3jqt 381304 660285 2019-11-26 2019-06-30 19           19               19
654 METHODIST HOSPITAL SOUTH 1905 HWY 97 EAST JOURDANTON TX 78026 ATASCOSA (830) 769-3515 Acute Care Hospitals Proprietary TRUE 28.9331124 -98.5260352 1 ROOFTOP 13 48 48013 41700   Outlying Atascosa County https://data.medicare.gov/resource/xubh-q36u/row-5vk8_ecmw.2bzr 450165 660714 2019-11-26 2019-06-30 61 6         67               67
665 UCHEALTH BROOMFIELD HOSPITAL 11820 DESTINATION DRIVE BROOMFIELD CO 80021 JEFFERSON (303) 460-6000 Acute Care Hospitals Proprietary TRUE 39.9105000 -105.0932070 0   14 8 8014 19740 Denver-Aurora, CO Central Broomfield County https://data.medicare.gov/resource/xubh-q36u/row-dvb6-rzzd_er2t 60129 661295 2019-11-26 2019-06-30 22           22               22
701 ARTESIA GENERAL HOSPITAL 702 N 13TH STREET ARTESIA NM 88210 EDDY (575) 748-3333 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.8486030 -104.4127520 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-t6vu-yth8.bk8u 320030 659993 2019-11-26 2019-06-30 34           34 15             49
715 BELLVILLE ST JOSEPH HEALTH CENTER 44 N CUMMINGS ST BELLVILLE TX 77418 AUSTIN (979) 865-3141 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9522650 -96.2607470 0   15 48 48015 26420 Houston-The Woodlands, TX Outlying Austin County https://data.medicare.gov/resource/xubh-q36u/row-dtpr-rvr9.rhky 450253 662602 2019-11-26 2019-06-30 32           32               32
742 CHRISTUS HEALTH SHREVEPORT - BOSSIER 1453 E BERT KOUNS INDUSTRIAL DRIVE SHREVEPORT LA 71105 CADDO (318) 681-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4259620 -93.7189260 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-nnks_h7jb-jcg8 190041 660807 2019-11-26 2019-06-30 151 20       21 192   16           208
772 GILA REGIONAL MEDICAL CENTER 1313 E 32ND ST SILVER CITY NM 88061 GRANT (575) 538-4100 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.7955240 -108.2609080 0   17 35 35017 43500   Central Grant County https://data.medicare.gov/resource/xubh-q36u/row-7frq_jm9p~bbxr 320016 659708 2019-11-26 2019-06-30 26 6         32 10             42
778 MCCULLOUGH-HYDE MEMORIAL HOSPITAL 110 NORTH POPLAR STREET OXFORD OH 45056 BUTLER (513) 524-5640 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.5121800 -84.7408150 0   17 39 39017 17140 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Butler County https://data.medicare.gov/resource/xubh-q36u/row-tm5u.6nm2.a733 360046 660666 2019-11-26 2019-06-30 41 4         45               45
796 ST JOSEPHS HOSPITAL 2661 COUNTY HWY I CHIPPEWA FALLS WI 54729 CHIPPEWA (715) 717-7200 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.9516610 -91.3582170 0   17 55 55017 20740 Eau Claire-Menomonie, WI Central Chippewa County https://data.medicare.gov/resource/xubh-q36u/row-nahq.4tp8_ghi9 520017 661127 2019-11-26 2019-06-30 96 6         102               102
826 CHRISTUS OCHSNER ST PATRICK HOSPITAL 524 DR MICHAEL DEBAKEY STREET LAKE CHARLES LA 70601 CALCASIEU (337) 436-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2154370 -93.2276700 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-574n_fdpb-emzy 190027 659956 2019-11-26 2019-06-30 83 17         100 25 23           148
827 CHRISTUS OCHSNER LAKE AREA HOSPITAL 4200 NELSON ROAD LAKE CHARLES LA 70605 CALCASIEU (337) 474-6370 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1820710 -93.2493480 0   19 22 22019 29340   Central Calcasieu Parish https://data.medicare.gov/resource/xubh-q36u/row-ziqv.tyfx-mhvz 190201 660808 2019-11-26 2019-06-30 80 8       20 108               108
836 PAUL OLIVER MEMORIAL HOSPITAL 224 PARK AVENUE FRANKFORT MI 49635 BENZIE (231) 352-2200 Critical Access Hospitals Government - Local TRUE 44.6373760 -86.2429130 0   19 26 26019 45900   Outlying Benzie County https://data.medicare.gov/resource/xubh-q36u/row-cypk~xgkd.zsnp 231300 660598 2019-11-26 2019-06-30 8           8       36       44
839 UNIVERSITY OF MISSOURI HEALTH CARE ONE HOSPITAL DRIVE COLUMBIA MO 65212 BOONE (573) 882-4141 Acute Care Hospitals Government - State TRUE 38.9386955 -92.3275514 1 ROOFTOP 19 29 29019 17860 Columbia-Moberly-Mexico, MO Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-63ac~57ef~2j52 260141 660405 2019-11-26 2019-06-30 372 82       58 530 61             591
887 COLISEUM NORTHSIDE HOSPITAL 400 CHARTER BOULEVARD MACON GA 31210 BIBB (478) 757-8200 Acute Care Hospitals Proprietary TRUE 32.8698610 -83.6943610 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-qnzt.yc4b~gnii 110201 660371 2019-11-26 2019-06-30 75 10         85               85
888 COLISEUM MEDICAL CENTERS 350 HOSPITAL DRIVE MACON GA 31217 BIBB (478) 765-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8473150 -83.6202700 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-xqcr.fqgq_42i9 110164 660072 2019-11-26 2019-06-30 138 28       13 179 42 29           250
921 CHI OAKES HOSPITAL 1200 N 7TH ST OAKES ND 58474 DICKEY (701) 742-3291 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1507960 -98.0904330 0   21 38 38021         https://data.medicare.gov/resource/xubh-q36u/row-b2w7_uuc8~i52v 351315 659999 2019-11-26 2019-06-30 20           20               20
934 DIVINE SAVIOR HEALTHCARE 2817 NEW PINERY ROAD PORTAGE WI 53901 COLUMBIA (608) 742-4131 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5662780 -89.4694450 0   21 55 55021 31540 Madison-Janesville-Beloit, WI Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-qhad~azvf~jeqw 520041 661128 2019-11-26 2019-06-30 37 6         43       83   40   166
943 ST JOSEPH HOSPITAL 2700 DOLBEER ST EUREKA CA 95501 HUMBOLDT (707) 445-8121 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7831030 -124.1420390 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-2tjd-xmnr-if78 50006 662153 2019-11-26 2019-06-30 117 12       5 134   15           149
947 SHANDS LAKE SHORE REGIONAL MEDICAL CENTER 368 NE FRANKLIN ST LAKE CITY FL 32055 COLUMBIA (386) 292-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1934860 -82.6327040 0   23 12 12023 29380 Gainesville-Lake City, FL Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-vfpa_f8gy-va3h 100102 660791 2019-11-26 2019-06-30 78 9         87               87
1041 CHRISTUS SPOHN HOSPITAL BEEVILLE 1500 E HOUSTON HWY BEEVILLE TX 78102 BEE (361) 354-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.4083530 -97.7319250 0   25 48 48025 13300   Central Bee County https://data.medicare.gov/resource/xubh-q36u/row-i8xs~bawd_cyy5 450082 659895 2019-11-26 2019-06-30 32 8         40               40
1050 UNIVERSITY OF WI HOSPITALS & CLINICS AUTHORITY 600 HIGHLAND AVENUE MADISON WI 53792 DANE (608) 261-0025 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.0772180 -89.4290630 0   25 55 55025 31540 Madison-Janesville-Beloit, WI Central Dane County https://data.medicare.gov/resource/xubh-q36u/row-99mg_w2iz-9z6j 520098 661129 2019-11-26 2019-06-30 498     7     608 18             626
1170 CHESTER COUNTY HOSPITAL 701 EAST MARSHALL STREET WEST CHESTER PA 19380 CHESTER (610) 431-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9718600 -75.6009240 0   29 42 42029 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Chester County https://data.medicare.gov/resource/xubh-q36u/row-w9bi_cvpv_nst8 390179 659876 2019-11-26 2019-06-30 216 14       14 244               244
1179 BAPTIST MEDICAL CENTER 111 DALLAS STREET SAN ANTONIO TX 78205 BEXAR (210) 297-8256 Acute Care Hospitals Proprietary TRUE 29.4328770 -98.4927730 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-9jbx_v3az~nwzz 450058 660466 2019-11-26 2019-06-30 1166 151         1457 38 72           1567
1187 CHRISTUS SANTA ROSA MEDICAL CENTER 2827 BABCOCK ROAD SAN ANTONIO TX 78229 BEXAR (210) 704-3342 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.5129090 -98.5915570 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-332s~bezr_i5q2 450237 660052 2019-11-26 2019-06-30 323 49       5 377               377
1188 CHILDREN'S HOSPITAL OF SAN ANTONIO 333 N SANTA ROSA ST SAN ANTONIO TX 78207 BEXAR (210) 704-3342 Childrens Voluntary non-profit - Private TRUE 29.4277960 -98.4978750 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-v67j_ia2t_8xbm 453315 660057 2019-11-26 2019-06-30 108 26       60 194               194
1249 INGALLS MEMORIAL HOSPITAL 1 INGALLS DRIVE HARVEY IL 60426 COOK (708) 333-2300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6063310 -87.6594840 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-vjp9-dpap-bkr6 140191 660514 2019-11-26 2019-06-30 243 25         268 16 42           326
1250 SAINT ANTHONY HOSPITAL 2875 WEST 19TH STREET CHICAGO IL 60623 COOK (773) 521-1710 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8555380 -87.6982720 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-kqum-g8qm_qy52 140095 660928 2019-11-26 2019-06-30 94 15         109 42             151
1272 MEDSTAR MONTGOMERY MEDICAL CENTER 18101 PRINCE PHILIP DRIVE OLNEY MD 20832 MONTGOMERY (301) 774-8882 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.1538580 -77.0568190 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-kiwa.6j4t~jbpx 210018 659800 2019-11-26 2019-06-30 105 12         117               117
1295 CARRINGTON HEALTH CENTER PO BOX 461 CARRINGTON ND 58421 FOSTER (701) 652-3141 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.4497201 -99.1262234 1 APPROXIMATE 31 38 38031         https://data.medicare.gov/resource/xubh-q36u/row-inkg_zfig.5z7t 351318 662239 2019-11-26 2019-06-30 25           25               25
1309 HOSPITAL UPR, DR FEDERICO TRILLA CARR 3 KM 8 3 AVE 65TH INFANTERIA BOX 6021 CAROLINA PR 984 CAROLINA (787) 757-1800 Acute Care Hospitals Proprietary FALSE 18.3808638 -65.9632825 1 RANGE_INTERPOLATED 31 72 72031 41980 San Juan-Carolina, PR Central Carolina Municipio https://data.medicare.gov/resource/xubh-q36u/row-xbn3-25u3~b8g7 400112 660876 2019-11-26 2019-06-30 210 8         233               233
1321 MERCY MEDICAL CENTER-NORTH IOWA 1000 FOURTH STREET SW MASON CITY IA 50401 CERRO GORDO (641) 428-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1483770 -93.2161020 0   33 19 19033 32380   Central Cerro Gordo County https://data.medicare.gov/resource/xubh-q36u/row-pnyf.wckq.h9kr 160064 660082 2019-11-26 2019-06-30 187 18         205   8   22       235
1380 SKY RIDGE MEDICAL CENTER 10101 RIDGEGATE PARKWAY LONE TREE CO 80124 DOUGLAS (720) 225-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.5293230 -104.8702690 0   35 8 8035 19740 Denver-Aurora, CO Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-qr62~ugzc.jjbq 60112 659642 2019-11-26 2019-06-30 214 30         272               272
1386 CLEARWATER VALLEY HOSPITAL & CLINICS 301 CEDAR STREET OROFINO ID 83544 CLEARWATER (208) 476-4555 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4873150 -116.2599160 0   35 16 16035         https://data.medicare.gov/resource/xubh-q36u/row-4jwp-mz4f-k7tn 131320 659779 2019-11-26 2019-06-30 23           23               23
1429 AVERA QUEEN OF PEACE 525 N FOSTER MITCHELL SD 57301 DAVISON (605) 995-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.7138420 -98.0073250 0   35 46 46035 33580   Central Davison County https://data.medicare.gov/resource/xubh-q36u/row-vs8d.p4rg.tbmc 430013 660030 2019-11-26 2019-06-30 42 8         50       84       134
1432 JORDAN VALLEY MEDICAL CENTER 3580 WEST 9000 SOUTH WEST JORDAN UT 84088 SALT LAKE (801) 561-8888 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.5879580 -111.9752850 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-uwvk-5p5y~xqkd 460051 662282 2019-11-26 2019-06-30 221 46       11 278 26 10           314
1447 SACRED HEART HOSPITAL 900 W CLAIREMONT AVE EAU CLAIRE WI 54701 EAU CLAIRE (715) 717-4121 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.7934620 -91.5106560 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-4e2t_bcw7.5pgk 520013 660730 2019-11-26 2019-06-30 146 14     8   168   24           192
1464 CASA COLINA HOSPITAL 255 E BONITA AVE POMONA CA 91767 LOS ANGELES (909) 596-7733 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.0962420 -117.7468610 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-rhgb.p6kp-nbju 50782 662170 2019-11-26 2019-03-31 25 6         31   68           99
1523 CEDAR-SINAI MARINA DEL REY HOSPITAL 4650 LINCOLN BLVD MARINA DEL REY CA 90291 LOS ANGELES (310) 823-8911 Acute Care Hospitals Proprietary FALSE 33.9817320 -118.4401540 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-izeb-yvf9_zc9q 50740 660492 2019-11-26 2019-06-30 91 12         103               103
1524 SANTA MONICA - UCLA MED CTR & ORTHOPAEDIC HOSPITAL 1250 16TH STREET SANTA MONICA CA 90404 LOS ANGELES (310) 319-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.0277760 -118.4863150 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-j9dj_ewdb-mq29 50112 659559 2019-11-26 2019-06-30 243 22         281               281
1538 MERCY MEDICAL CENTER-NEW HAMPTON 308 NORTH MAPLE AVENUE NEW HAMPTON IA 50659 CHICKASAW (641) 394-4121 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.0626770 -92.3204250 0   37 19 19037         https://data.medicare.gov/resource/xubh-q36u/row-xkj8-v8qa.w84a 161331 660217 2019-11-26 2019-06-30 8           8               8
1542 MEDSTAR SAINT MARY'S HOSPITAL 25500 POINT LOOKOUT ROAD LEONARDTOWN MD 20650 ST. MARYS (301) 475-6001 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.2992390 -76.6403830 0   37 24 24037 15680 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central St. Mary's County https://data.medicare.gov/resource/xubh-q36u/row-hrp5-h6jf_ehik 210028 660390 2019-11-26 2019-06-30 84 12         96               96
1559 ST JOHN SAPULPA, INC 1004 EAST BRYAN SAPULPA OK 74066 CREEK (918) 227-8601 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9933610 -96.1001920 0   37 40 40037 46140 Tulsa-Muskogee-Bartlesville, OK Central Creek County https://data.medicare.gov/resource/xubh-q36u/row-wvjq.he32_w2jq 371312 659718 2019-11-26 2019-06-30 25           25               25
1561 BERWICK HOSPITAL CENTER 701 EAST 16TH STREET BERWICK PA 18603 COLUMBIA (570) 759-5020 Acute Care Hospitals Proprietary TRUE 41.0701590 -76.2308040 0   37 42 42037 14100 Bloomsburg-Berwick-Sunbury, PA Central Columbia County https://data.medicare.gov/resource/xubh-q36u/row-cn25-dn3w-iqqf 390072 660695 2019-11-26 2019-06-30 77 10         87 14     240       341
1571 SAINT THOMAS WEST HOSPITAL 4220 HARDING RD, PO BOX 380 NASHVILLE TN 37205 DAVIDSON (615) 222-2111 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.1290830 -86.8434476 1 ROOFTOP 37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-xfk3~krcg.f39q 440082 660312 2019-11-26 2019-06-30 252 88         340               340
1614 MEADVILLE MEDICAL CENTER 751 LIBERTY STREET MEADVILLE PA 16335 CRAWFORD (814) 333-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6417880 -80.1463360 0   39 42 42039 32740 Erie-Meadville, PA Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-vxk2.xwfb.xf5v 390113 660857 2019-11-26 2019-06-30 133 12         145 28 11   32       216
1638 CENTURA HEALTH-PENROSE-ST FRANCIS HEALTH SERVICES 2222 NORTH NEVADA AVE COLORADO SPRINGS CO 80907 EL PASO (719) 776-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8655680 -104.8201230 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-gqx3~746f~9uqw 60031 659763 2019-11-26 2019-06-30 354 45         445   23           468
1639 UNIVERSITY COLO HEALTH MEMORIAL HOSPITAL CENTRAL 1400 E BOULDER ST COLORADO SPRINGS CO 80909 EL PASO (719) 365-5000 Acute Care Hospitals Government - Local TRUE 38.8388120 -104.7999510 0   41 8 8041 17820   Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-a2ae-uent-g89f 60022 659639 2019-11-26 2019-06-30 385 46         515   22           537
1657 ROOSEVELT GENERAL HOSPITAL 42121 US HIGHWAY 70 PORTALES NM 88130 ROOSEVELT (575) 359-1800 Acute Care Hospitals Government - State TRUE 34.1656650 -103.3681990 0   41 35 35041 38780 Clovis-Portales, NM Central Roosevelt County https://data.medicare.gov/resource/xubh-q36u/row-kycr_dkfp.ev9b 320084 659709 2019-11-26 2019-06-30 20           20               20
1664 GOOD SAMARITAN HOSPITAL FOURTH AND WALNUT STREETS LEBANON PA 17042 LEBANON (717) 270-7500 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.1463530 -77.1285980 0   41 42 42041 25420 Harrisburg-York-Lebanon, PA Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-nqjx-dmqh-mzcz 390066 661094 2019-11-26 2019-06-30 127 18         145   14           159
1680 CULLMAN REGIONAL MEDICAL CENTER 1912 ALABAMA HIGHWAY 157 CULLMAN AL 35058 CULLMAN (256) 737-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1985870 -86.8056410 0   43 1 1043 18980 Birmingham-Hoover-Talladega, AL Central Cullman County https://data.medicare.gov/resource/xubh-q36u/row-25az.bw5t.5dxy 10035 659467 2019-11-26 2019-06-30 133 12         145               145
1735 MERCYONE CLINTON MEDICAL CENTER 1410 NORTH 4TH STREET CLINTON IA 52732 CLINTON (563) 244-5555 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8605430 -90.1881550 0   45 19 19045 17540 Davenport-Moline, IA-IL Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-2kgs.eg5q.xjrv 160080 660084 2019-11-26 2019-06-30 97 10         107               107
1739 PENINSULA REGIONAL MEDICAL CENTER 100 EAST CARROLL AVENUE SALISBURY MD 21801 WICOMICO (410) 543-7111 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3630680 -75.5994890 0   45 24 24045 41540   Central Wicomico County https://data.medicare.gov/resource/xubh-q36u/row-62af-vb87-gfug 210019 659801 2019-11-26 2019-06-30 264 24         288               288
1752 DILEY RIDGE MEDICAL CENTER 7911 DILEY ROAD CANAL WINCHESTER OH 43110 FRANKLIN (614) 838-7910 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8500530 -82.7811000 0   45 39 39045 18140 Columbus-Marion-Zanesville, OH Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-82cy_fgw2.yjpg 360358 660675 2019-11-26 2019-06-30 10           10               10
1785 GARDEN PARK MEDICAL CENTER 15200 COMMUNITY ROAD GULFPORT MS 39503 HARRISON (228) 575-7000 Acute Care Hospitals Proprietary TRUE 30.4420100 -89.0927660 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-mqi3~42hr_6pv9 250123 660823 2019-11-26 2018-12-31 87 13         100 21             121
1833 ST MARY'S HOSPITAL 701 LEWISTON ST COTTONWOOD ID 83522 IDAHO (208) 962-3251 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.0503710 -116.3516450 0   49 16 16049         https://data.medicare.gov/resource/xubh-q36u/row-u7zv_7y6z_xg8a 131321 661307 2019-11-26 2019-06-30 25           25               25
1854 CHRISTUS ST VINCENT REGIONAL MEDICAL CENTER 455 ST MICHAEL'S DRIVE SANTA FE NM 87505 SANTA FE (505) 913-5201 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6577890 -105.9469460 0   49 35 35049 42140 Albuquerque-Santa Fe-Las Vegas, NM Central Santa Fe County https://data.medicare.gov/resource/xubh-q36u/row-ew8z~vnrx_nfua 320002 661060 2019-11-26 2019-06-30 167 18         185 9 20           214
1857 MOUNT CARMEL NEW ALBANY SURGICAL HOSPITAL 7333 SMITH'S MILL ROAD NEW ALBANY OH 43054 FRANKLIN (614) 775-6600 Acute Care Hospitals Proprietary FALSE 40.0863030 -82.7887930 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-ywvf~p2gq~kk8u 360266 660674 2019-11-26 2019-06-30 60           60               60
1932 MILBANK AREA HOSPITAL/AVERA HEALTH 301 FLYNN DRIVE MILBANK SD 57252 GRANT (605) 432-4538 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.2219130 -96.6175485 1 ROOFTOP 51 46 46051         https://data.medicare.gov/resource/xubh-q36u/row-y6xc~czq6~y94b 431326 660034 2019-11-26 2019-06-30 25           25               25
1940 SALINAS VALLEY MEMORIAL HOSPITAL 450 EAST ROMIE LANE SALINAS CA 93901 MONTEREY (831) 757-4333 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.6599790 -121.6463270 0   53 6 6053 41500   Central Monterey County https://data.medicare.gov/resource/xubh-q36u/row-prne.hfxw.8pa4 50334 659756 2019-11-26 2019-06-30 216 13       11 240               240
1954 ASPIRUS IRONWOOD HOSPITAL N10561 GRAND VIEW LANE IRONWOOD MI 49938 GOGEBIC (906) 932-2525 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.4781930 -90.1046890 0   53 26 26053         https://data.medicare.gov/resource/xubh-q36u/row-kai4_hwh9~ugv4 231333 660107 2019-11-26 2019-06-30 20 5         25               25
1970 HOLZER MEDICAL CENTER 100 JACKSON PIKE GALLIPOLIS OH 45631 GALLIA (740) 446-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.8444100 -82.2368020 0   53 39 39053 38580   Central Gallia County https://data.medicare.gov/resource/xubh-q36u/row-g9re~frqh.e6ur 360054 660667 2019-11-26 2019-06-30 143 14         157 14 26       116   313
1974 AVERA GREGORY HOSPITAL 400 PARK STREET POST OFFICE BOX 408 GREGORY SD 57533 GREGORY (605) 835-8394 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2319878 -99.4304377 1 ROOFTOP 53 46 46053         https://data.medicare.gov/resource/xubh-q36u/row-sxnm~ansc_ejzf 431338 662257 2019-11-26 2019-06-30 25           25       55       80
1996 ADVENTHEALTH SEBRING 4200 SUN N LAKE BLVD SEBRING FL 33871 HIGHLANDS (863) 314-4466 Acute Care Hospitals Voluntary non-profit - Church FALSE 27.5384550 -81.5068810 0   55 12 12055 42700   Central Highlands County https://data.medicare.gov/resource/xubh-q36u/row-kk9t~8fs5~ksmj 100109 661479 2019-11-26 2018-12-31 158 22         180 17             197
2000 FRANKLIN HOSPITAL 201 BAILEY LANE BENTON IL 62812 FRANKLIN (618) 439-3161 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.0091370 -88.9171420 0   55 17 17055         https://data.medicare.gov/resource/xubh-q36u/row-a634_xpuq_r7c9 141321 660523 2019-11-26 2019-06-30 25           25               25
2003 ST CATHERINE HOSPITAL 401 EAST SPRUCE GARDEN CITY KS 67846 FINNEY (620) 272-2222 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.9688710 -100.8686150 0   55 20 20055 23780   Central Finney County https://data.medicare.gov/resource/xubh-q36u/row-33tn.4j7w~te3s 170023 660221 2019-11-26 2019-06-30 75 8       7 90   10           100
2007 UNIVERSITY HOSPITAL & CLINICS 2390 WEST CONGRESS LAFAYETTE LA 70506 LAFAYETTE (337) 261-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2157920 -92.0456750 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-4gs6.rn2t.zgkk 190006 659954 2019-11-26 2019-06-30 42 10         52               52
2066 ST VINCENT CARMEL HOSPITAL INC 13500 N MERIDIAN ST CARMEL IN 46032 HAMILTON (317) 582-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.9830650 -86.1471600 0   57 18 18057 26900 Indianapolis-Carmel-Muncie, IN Central Hamilton County https://data.medicare.gov/resource/xubh-q36u/row-tcsr~j74g~5whv 150157 660077 2019-11-26 2019-06-30 128 10       15 153               153
2067 GREAT RIVER MEDICAL CENTER 1221 SOUTH GEAR AVENUE WEST BURLINGTON IA 52655 DES MOINES (319) 768-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8073690 -91.1702780 0   57 19 19057 15460   Central Des Moines County https://data.medicare.gov/resource/xubh-q36u/row-8pkk_2khg-h2nd 160057 660081 2019-11-26 2019-06-30 124 12         136   11   160   6   313
2070 LADY OF THE SEA GENERAL HOSPITAL 200 WEST 134TH PLACE CUT OFF LA 70345 LAFOURCHE (985) 632-6401 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.4567190 -90.3104300 0   57 22 22057 26380   Central Lafourche Parish https://data.medicare.gov/resource/xubh-q36u/row-gtsq-dc99_icfj 191325 659798 2019-11-26 2019-06-30 21 2         23               23
2103 MEMORIALCARE SADDLEBACK MEDICAL CENTER 24451 HEALTH CENTER DRIVE LAGUNA HILLS CA 92653 ORANGE (949) 837-4500 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.6077620 -117.7082580 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-g7nw-ucu9.kxj9 50603 662167 2019-11-26 2019-06-30 207 22       19 248               248
2128 MEMORIALCARE ORANGE COAST MEDICAL CENTER 9920 TALBERT AVENUE FOUNTAIN VALLEY CA 92708 ORANGE (714) 378-7406 Acute Care Hospitals Proprietary TRUE 33.7016590 -117.9561070 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-pc9c.ve2t.j5x8 50678 662101 2019-11-26 2019-06-30 185 21       12 218               218
2129 CENTURA HEALTH-ST ANTHONY HOSPITAL 11600 WEST 2ND PLC LAKEWOOD CO 80228 JEFFERSON (720) 321-0000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.7179560 -105.1274940 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-hs5j-ymh4.6b3z 60015 659760 2019-11-26 2019-06-30 144 28     48   220   17           237
2131 ORTHOCOLORADO HOSPITAL AT ST ANTHONY MED CAMPUS 11650 WEST 2ND PLACE LAKEWOOD CO 80228 JEFFERSON (720) 321-5000 Acute Care Hospitals Proprietary TRUE 39.7179520 -105.1284410 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-b3pw~3vk6_q65v 60124 659765 2019-11-26 2019-06-30 48           48               48
2186 MERCYONE DUBUQUE MEDICAL CENTER 250 MERCY DRIVE DUBUQUE IA 52001 DUBUQUE (563) 589-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.4931450 -90.6743500 0   61 19 19061 20220   Central Dubuque County https://data.medicare.gov/resource/xubh-q36u/row-852u.y47f-95x9 160069 660083 2019-11-26 2019-06-30 142 8         150   9   20       179
2191 ASPIRUS KEWEENAW HOSPITAL 205 OSCEOLA LAURIUM MI 49913 HOUGHTON (906) 337-6500 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.2375380 -88.4440380 0   61 26 26061 26340   Central Houghton County https://data.medicare.gov/resource/xubh-q36u/row-p9jg_yiuy~c7z4 231319 660600 2019-11-26 2019-06-30 20 5         25               25
2194 DEER RIVER HEALTHCARE CENTER 115 10TH AVENUE NORTHEAST DEER RIVER MN 56636 ITASCA (218) 246-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.3435030 -93.7912990 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-run4_u2tc_i8qs 241360 660613 2019-11-26 2019-06-30 20           20       32       52
2320 NELL J REDFIELD MEMORIAL HOSPITAL 150 NORTH 200 WEST MALAD ID 83252 ONEIDA (208) 766-2231 Critical Access Hospitals Government - Local TRUE 42.1896380 -112.2507590 0   71 16 16071         https://data.medicare.gov/resource/xubh-q36u/row-dtun.jgpu~2hmu 131303 662195 2019-11-26 2019-06-30 11           11       33       44
2322 PENN HIGHLANDS BROOKVILLE 100 HOSPITAL ROAD BROOKVILLE PA 15825 JEFFERSON (814) 849-2312 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.1564730 -79.0928840 0   65 42 42065         https://data.medicare.gov/resource/xubh-q36u/row-5dtj-fqtw.9nmm 391312 660451 2019-11-26 2019-06-30 25           25 10             35

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