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

177 rows where "filed_date" is on date 2019-02-28 sorted by statecountyfips

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, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date)

  • 2019-02-28 · 177
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
666 NORTHEAST ALABAMA REGIONAL MEDICAL CENTER 400 EAST 10TH STREET ANNISTON AL 36207 CALHOUN (256) 235-5121 Acute Care Hospitals Government - Local TRUE 33.6571230 -85.8233530 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-ima9~p9t8~qh92 10078 644086 2019-02-28 2018-09-30 232 18         250 20             270
667 STRINGFELLOW MEMORIAL HOSPITAL 301 EAST 18TH ST ANNISTON AL 36201 CALHOUN (256) 235-8900 Acute Care Hospitals Proprietary TRUE 33.6677010 -85.8250250 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-2tt8-gqrt.8qr7 10038 644691 2019-02-28 2018-09-30 119 6         125               125
1058 CLAY COUNTY HOSPITAL 83825 HIGHWAY 9 P O BOX 1270 ASHLAND AL 36251 CLAY (256) 354-2131 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2765480 -85.8237890 0   27 1 1027         https://data.medicare.gov/resource/xubh-q36u/row-p2yh_2e24~5sth 10073 644085 2019-02-28 2018-09-30 42 4         46       83       129
1939 ATMORE COMMUNITY HOSPITAL 401 MEDICAL PARK DRIVE ATMORE AL 36502 ESCAMBIA (251) 368-2500 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0165700 -87.4797350 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-nw85.p2jc-cva6 10169 645521 2019-02-28 2018-09-30 43 6         49               49
2045 FAYETTE MEDICAL CENTER 1653 TEMPLE AVENUE NORTH FAYETTE AL 35555 FAYETTE (205) 932-5966 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.7077080 -87.8237060 0   57 1 1057         https://data.medicare.gov/resource/xubh-q36u/row-f7kw.zhbj_gfwf 10045 644692 2019-02-28 2018-09-30 37 8         45       122       167
2985 MARION REGIONAL MEDICAL CENTER 1256 MILITARY STREET SOUTH HAMILTON AL 35570 MARION (205) 921-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1258520 -87.9898060 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-ak6z-c9hr~7upb 10044 643754 2019-02-28 2018-09-30 32 4         36       79       115
3021 MARSHALL MEDICAL CENTERS SOUTH CAMPUS 2505 U S HIGHWAY 431 NORTH BOAZ AL 35957 MARSHALL (256) 593-8310 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.2216880 -86.1607098 1 ROOFTOP 95 1 1095 10700 Huntsville-Decatur-Albertville, AL Central Marshall County https://data.medicare.gov/resource/xubh-q36u/row-qhdt_aeut-3iwd 10005 644081 2019-02-28 2018-09-30 184 20         204               204
3074 UNIVERSITY OF SOUTH ALABAMA MEDICAL CENTER 2451 FILLINGIM STREET MOBILE AL 36617 MOBILE (251) 471-7110 Acute Care Hospitals Government - State TRUE 30.7081210 -88.0994410 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-cmzx-i3i2.bp42 10087 645038 2019-02-28 2018-09-30 117 9   7 16   149               149
3700 D C H REGIONAL MEDICAL CENTER 809 UNIVERSITY BOULEVARD EAST TUSCALOOSA AL 35401 TUSCALOOSA (205) 759-7111 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2061300 -87.5251540 0   125 1 1125 46220   Central Tuscaloosa County https://data.medicare.gov/resource/xubh-q36u/row-zssi.q234-yq7y 10092 644695 2019-02-28 2018-09-30 362 52 32       497 54 42           593
549 ABRAZO SCOTTSDALE CAMPUS 3929 EAST BELL ROAD PHOENIX AZ 85032 MARICOPA (602) 923-5000 Acute Care Hospitals Proprietary TRUE 33.6406030 -111.9976920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-3yrx.bcen.wd4a 30083 644698 2019-02-28 2018-09-30 113 14         127               127
801 ST. MARY'S HOSPITAL 1601 WEST ST MARY'S ROAD TUCSON AZ 85745 PIMA (520) 872-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2289230 -111.0000320 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-8z3y-kp4a.tw3t 30010 644007 2019-02-28 2018-09-30 300 40   9     349 23 28           400
807 ST JOSEPH'S HOSPITAL 350 NORTH WILMOT ROAD TUCSON AZ 85711 PIMA (520) 873-3000 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.2259460 -110.8578380 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-trzm-jqcs_wpf7 30011 644090 2019-02-28 2018-09-30 377 32       30 451 15 20           486
941 HOLY CROSS HOSPITAL 1171 WEST TARGET RANGE ROAD NOGALES AZ 85621 SANTA CRUZ (520) 285-3000 Critical Access Hospitals Proprietary TRUE 31.3411180 -110.9587340 0   23 4 4023 35700 Tucson-Nogales, AZ Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-datt~k3n6_g682 31313 644092 2019-02-28 2018-09-30 25           25               25
1059 YUMA REGIONAL MEDICAL CENTER 2400 SOUTH AVENUE A YUMA AZ 85364 YUMA (928) 336-7600 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.6838990 -114.6332380 0   27 4 4027 49740   Central Yuma County https://data.medicare.gov/resource/xubh-q36u/row-vbe2.gm3a_7tw7 30013 644624 2019-02-28 2018-09-30 344 42       20 406               406
2046 WADLEY REGIONAL MEDICAL CENTER AT HOPE 2001 SOUTH MAIN HOPE AR 71801 HEMPSTEAD (870) 722-3800 Acute Care Hospitals Proprietary TRUE 33.6480080 -93.5870520 0   57 5 5057         https://data.medicare.gov/resource/xubh-q36u/row-zn9u-sntu_5nuw 40153 643865 2019-02-28 2018-09-30 59 8         67 12             79
3575 ARKANSAS HEART HOSPITAL, LLC 1701 S SHACKLEFORD ROAD LITTLE ROCK AR 72211 PULASKI (501) 219-7000 Acute Care Hospitals Proprietary TRUE 34.7391590 -92.3944210 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-jzxu~zre6.ev3c 40134 644703 2019-02-28 2018-09-30 112           112               112
3967 WHITE COUNTY MEDICAL CENTER 3214 EAST RACE AVENUE SEARCY AR 72143 WHITE (501) 278-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2504460 -91.6967580 0   145 5 5145 42620 Little Rock-North Little Rock, AR Central White County https://data.medicare.gov/resource/xubh-q36u/row-b6nk.pamh_stfx 40014 644701 2019-02-28 2018-09-30 192 13         205 30 37           272
2505 SCRIPPS MEMORIAL HOSPITAL - ENCINITAS 354 SANTA FE DRIVE ENCINITAS CA 92024 SAN DIEGO (760) 753-6501 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.0362720 -117.2842370 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-wtw4-gvxp-bzi9 50503 644217 2019-02-28 2018-09-30 159 12         171   22           193
2509 SCRIPPS MEMORIAL HOSPITAL LA JOLLA 9888 GENESEE AVENUE LA JOLLA CA 92037 SAN DIEGO (858) 626-4123 Acute Care Hospitals Physician TRUE 32.8855000 -117.2230220 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-dpzj.qr7c.gnws 50324 644215 2019-02-28 2018-09-30 306 59         365               365
2513 SCRIPPS GREEN HOSPITAL 10666 NORTH TORREY PINES ROAD LA JOLLA CA 92037 SAN DIEGO (858) 455-9100 Acute Care Hospitals Voluntary non-profit - Other FALSE 32.8971240 -117.2418540 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-k5xn~6853~5e64 50424 644216 2019-02-28 2018-09-30 100 24         150               150
2515 SCRIPPS MERCY HOSPITAL 4077 5TH AVE SAN DIEGO CA 92103 SAN DIEGO (619) 294-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.7512110 -117.1610240 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-4xsr.mwt6-iirn 50077 644214 2019-02-28 2018-09-30 431 56         487 36             523
2779 LUCILE SALTER PACKARD CHILDREN'S HSP AT STANFORD 725 WELCH ROAD PALO ALTO CA 94304 SANTA CLARA (650) 497-8000 Childrens Voluntary non-profit - Private FALSE 37.4373820 -122.1750610 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-kerk.q8n2_pjvp 53305 644220 2019-02-28 2018-08-31 178         44 302               302
62 ST VINCENT'S MEDICAL CENTER 2800 MAIN ST BRIDGEPORT CT 6606 FAIRFIELD (203) 576-5551 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.2000830 -73.2024860 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-fzpd_79fu~rdpp 70028 645052 2019-02-28 2018-09-30 186 14         200 88 10           298
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
263 SHARON HOSPITAL 50 HOSPITAL HILL ROAD SHARON CT 6069 LITCHFIELD (860) 364-4228 Acute Care Hospitals Proprietary TRUE 41.8796620 -73.4815720 0   5 9 9005 45860 New York-Newark, NY-NJ-CT-PA Central Litchfield County https://data.medicare.gov/resource/xubh-q36u/row-cvhr-qzru_z9ev 70004 658178 2019-02-28 2018-09-30 55 11         66 12             78
264 CHARLOTTE HUNGERFORD HOSPITAL 540 LITCHFIELD ST TORRINGTON CT 6790 LITCHFIELD (860) 496-6666 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7908460 -73.1331430 0   5 9 9005 45860 New York-Newark, NY-NJ-CT-PA Central Litchfield County https://data.medicare.gov/resource/xubh-q36u/row-3jtm_3puv.aqur 70011 645050 2019-02-28 2018-09-30 81 10         91 17             108
408 SAINT MARY'S HOSPITAL 56 FRANKLIN STEET WATERBURY CT 6706 NEW HAVEN (203) 709-6020 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.5525708 -73.0364301 1 ROOFTOP 9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-ir6v~snu4~uk6s 70016 644222 2019-02-28 2018-09-30 119 16 8       152 12             164
415 MASONICARE HEALTH CENTER 22 MASONIC AVE WALLINGFORD CT 6492 NEW HAVEN (203) 679-5900 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.4606980 -72.8365860 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-qb4p-gu4j_xpz9 70039 645323 2019-02-28 2018-09-30 30           30 29     366   86   511
482 WILLIAM W BACKUS HOSPITAL 326 WASHINGTON ST NORWICH CT 6360 NEW LONDON (860) 889-8331 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.5434020 -72.0867470 0   11 9 9011 35980 Hartford-West Hartford, CT Central New London County https://data.medicare.gov/resource/xubh-q36u/row-x7iv~8mww_raqd 70024 645051 2019-02-28 2018-09-30 153 12         165 18             183
596 JOHNSON MEMORIAL HOSPITAL 201 CHESTNUT HILL ROAD STAFFORD SPRINGS CT 6076 TOLLAND (860) 684-4251 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9795964 -72.3911022 1 ROOFTOP 13 9 9013 25540 Hartford-West Hartford, CT Central Tolland County https://data.medicare.gov/resource/xubh-q36u/row-teik-3pgv_3z6k 70008 645049 2019-02-28 2018-09-30 43 7         50 20             70
676 DAY KIMBALL HOSPITAL 320 POMFRET STREET PUTNAM CT 6260 WINDHAM (860) 928-6541 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9077460 -71.9146920 0   15 9 9015 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Windham County https://data.medicare.gov/resource/xubh-q36u/row-wpx5.4hwv_hd6p 70003 645321 2019-02-28 2018-09-30 98 6         104               104
419 HOLMES REGIONAL MEDICAL CENTER 1350 S HICKORY ST MELBOURNE FL 32901 BREVARD (321) 434-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.0869100 -80.6135230 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-vfyd.d5k5.qxkg 100019 646066 2019-02-28 2018-09-30 450 54   10     514               514
420 VIERA HOSPITAL 8745 N WICKHAM RD MELBOURNE FL 32940 BREVARD (321) 434-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.2298120 -80.7294340 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-56fa_2f7u~npx7 100315 646070 2019-02-28 2018-09-30 64 20         84               84
730 BAYFRONT HEALTH SEVEN RIVERS 6201 N SUNCOAST BLVD CRYSTAL RIVER FL 34428 CITRUS (352) 795-6560 Acute Care Hospitals Proprietary TRUE 28.9508960 -82.6258660 0   17 12 12017 26140   Central Citrus County https://data.medicare.gov/resource/xubh-q36u/row-e3ek_i6mx~pzz2 100249 644711 2019-02-28 2018-09-30 112 16         128               128
885 PHYSICIANS REGIONAL MEDICAL CENTER - PINE RIDGE 6101 PINE RIDGE ROAD NAPLES FL 34119 COLLIER (239) 348-4000 Acute Care Hospitals Proprietary TRUE 26.2117640 -81.7307070 0   21 12 12021 34940 Cape Coral-Fort Myers-Naples, FL Central Collier County https://data.medicare.gov/resource/xubh-q36u/row-z54t-v8nq.fk93 100286 643693 2019-02-28 2018-09-30 177 24         201               201
1210 BAPTIST MEDICAL CENTER JACKSONVILLE 800 PRUDENTIAL DR JACKSONVILLE FL 32207 DUVAL (904) 202-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.3162840 -81.6636090 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-sq6x~c6g4-pdi9 100088 644237 2019-02-28 2018-09-30 665 120         855 48             903
1316 BAPTIST HOSPITAL 1000 W MORENO ST PENSACOLA FL 32501 ESCAMBIA (850) 434-4011 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4286760 -87.2320150 0   33 12 12033 37860   Central Escambia County https://data.medicare.gov/resource/xubh-q36u/row-ijyx~shwb.imui 100093 644238 2019-02-28 2018-09-30 229 25     12   266 60             326
1893 HENDRY REGIONAL MEDICAL CENTER 524 W SAGAMORE AVE CLEWISTON FL 33440 HENDRY (863) 902-3033 Critical Access Hospitals Voluntary non-profit - Other TRUE 26.7532390 -80.9422760 0   51 12 12051 17500   Central Hendry County https://data.medicare.gov/resource/xubh-q36u/row-ati4-fhfd_57wb 101309 643695 2019-02-28 2018-09-30 22 3         25               25
2449 CAPE CORAL HOSPITAL 636 DEL PRADO BLVD CAPE CORAL FL 33990 LEE (239) 574-2323 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.6393210 -81.9409460 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-h94e-be5i_u37i 100244 644248 2019-02-28 2018-09-30 235 22       23 280               280
2450 GULF COAST MEDICAL CENTER LEE MEM HEALTH SYSTEM 13681 DOCTORS WAY FORT MYERS FL 33912 LEE (239) 768-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.5430160 -81.8485890 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-ey2r_ercs~bbdu 100220 644710 2019-02-28 2018-09-30 320 36         356               356
2452 LEE MEMORIAL HOSPITAL 2776 CLEVELAND AVE FORT MYERS FL 33901 LEE (239) 332-1111 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.6269240 -81.8722950 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-d9mq-v9vy_3733 100012 644229 2019-02-28 2018-09-30 539 75       32 743   60   15       818
2851 LOWER KEYS MEDICAL CENTER 5900 COLLEGE ROAD KEY WEST FL 33040 MONROE (305) 294-5531 Acute Care Hospitals Proprietary TRUE 24.5815730 -81.7436880 0   87 12 12087 28580   Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-ygrq~jm9y.gjez 100150 644708 2019-02-28 2018-09-30 90 9         99 21             120
3149 JUPITER MEDICAL CENTER 1210 S OLD DIXIE HWY JUPITER FL 33458 PALM BEACH (561) 747-2234 Acute Care Hospitals Voluntary non-profit - Private TRUE 26.9228240 -80.0945390 0   99 12 12099 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Palm Beach County https://data.medicare.gov/resource/xubh-q36u/row-65xm_emjr~iknq 100253 646027 2019-02-28 2018-09-30 190 17         207               207
3196 ADVENTHEALTH DADE CITY 13100 FT KING RD DADE CITY FL 33525 PASCO (352) 568-3174 Acute Care Hospitals Proprietary TRUE 28.3485870 -82.2016850 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-w886-maw8~uhkt 100211 644709 2019-02-28 2018-09-30 108 12         120               120
3250 NORTHSIDE HOSPITAL 6000 49TH ST N SAINT PETERSBURG FL 33709 PINELLAS (813) 521-5000 Acute Care Hospitals Proprietary TRUE 27.8260530 -82.7000010 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-9c7k~923g.xenn 100238 645056 2019-02-28 2018-09-30 189 32         221               221
3258 PALMS OF PASADENA HOSPITAL 1501 PASADENA AVE S SAINT PETERSBURG FL 33707 PINELLAS (727) 381-1000 Acute Care Hospitals Proprietary TRUE 27.7535170 -82.7381760 0   103 12 12103 45300   Central Pinellas County https://data.medicare.gov/resource/xubh-q36u/row-5brx.ibn9.ivnj 100126 644707 2019-02-28 2018-09-30 149 18         167   20           187
3459 GULF BREEZE HOSPITAL 1110 GULF BREEZE PKWY GULF BREEZE FL 32561 SANTA ROSA (850) 934-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.3586490 -87.1568030 0   113 12 12113 37860   Central Santa Rosa County https://data.medicare.gov/resource/xubh-q36u/row-i236_mnds-pgjj 100266 646028 2019-02-28 2018-09-30 57 8         65               65
680 CARTERSVILLE MEDICAL CENTER 960 JOE FRANK HARRIS PARKWAY CARTERSVILLE GA 30120 BARTOW (770) 387-8182 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1995441 -84.7932932 1 ROOFTOP 15 13 13015 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Bartow County https://data.medicare.gov/resource/xubh-q36u/row-w3nk-2vm4_5tut 110030 644712 2019-02-28 2018-09-30 98 21         119               119
1215 EAST GEORGIA REGIONAL MEDICAL CENTER 1499 FAIR ROAD STATESBORO GA 30458 BULLOCH (912) 486-1500 Acute Care Hospitals Proprietary TRUE 32.4151710 -81.7686500 0   31 13 13031 44340 Savannah-Hinesville-Statesboro, GA Central Bulloch County https://data.medicare.gov/resource/xubh-q36u/row-xsms-9ix9.jicj 110075 645062 2019-02-28 2018-09-30 118 24         142               142
4539 TIFT REGIONAL MEDICAL CENTER 901 E 18TH STREET TIFTON GA 31793 TIFT (229) 382-7120 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.4704020 -83.4910760 0   277 13 13277 45700   Central Tift County https://data.medicare.gov/resource/xubh-q36u/row-ny4q-euja_bk5w 110095 644114 2019-02-28 2018-09-30 161 20         181               181
4569 HAMILTON MEDICAL CENTER 1200 MEMORIAL DRIVE DALTON GA 30720 WHITFIELD (706) 272-6105 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7888840 -84.9836570 0   313 13 13313 19140 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Whitfield County https://data.medicare.gov/resource/xubh-q36u/row-43qf_bzq5_w6mu 110001 644112 2019-02-28 2018-09-30 212 26     8   246 18             264
820 EASTERN IDAHO REGIONAL MEDICAL CENTER 3100 CHANNING WAY IDAHO FALLS ID 83404 BONNEVILLE (208) 529-6210 Acute Care Hospitals Proprietary TRUE 43.4702760 -111.9901590 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-zu9m_rfwy-xxuk 130018 644978 2019-02-28 2018-09-30 165 35         226 28 17       10   310
1067 WEST VALLEY MEDICAL CENTER 1717 ARLINGTON STREET CALDWELL ID 83605 CANYON (208) 459-4641 Acute Care Hospitals Proprietary TRUE 43.6542200 -116.6956400 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-q3w9-74rj.ew8y 130014 645072 2019-02-28 2018-09-30 95 13       4 112               112
1134 CARIBOU MEMORIAL HOSPITAL 300 SOUTH 3RD WEST SODA SPRINGS ID 83276 CARIBOU (208) 547-3341 Critical Access Hospitals Government - Local TRUE 42.6522350 -111.6133540 0   29 16 16029         https://data.medicare.gov/resource/xubh-q36u/row-k69a-4kn6-dfne 131309 644028 2019-02-28 2018-09-30 25           25       30       55
1731 VALOR HEALTH 1202 EAST LOCUST STREET EMMETT ID 83617 GEM (208) 365-3561 Critical Access Hospitals Government - Local TRUE 43.8790780 -116.4852550 0   45 16 16045 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Gem County https://data.medicare.gov/resource/xubh-q36u/row-cch8-kmmd-nmhb 131318 644635 2019-02-28 2018-09-30 13           13               13
1229 NORTHWEST COMMUNITY HOSPITAL 1 800 W CENTRAL ROAD ARLINGTON HEIGHTS IL 60005 COOK (847) 618-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0666040 -87.9929510 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-39t4.gcrd_v8y9 140252 644983 2019-02-28 2018-09-30 328 60       8 396 52 33           481
2526 OSF SAINT LUKES MEDICAL CENTER 1051 WEST SOUTH STREET KEWANEE IL 61443 HENRY (309) 853-3361 Critical Access Hospitals Voluntary non-profit - Church TRUE 41.2221630 -89.9477690 0   73 17 17073 19340 Davenport-Moline, IA-IL Outlying Henry County https://data.medicare.gov/resource/xubh-q36u/row-9mk3-a2c4_4uh2 141325 645251 2019-02-28 2018-09-30 22 3         25               25
3034 ST MARY MEDICAL CENTER 3333 NORTH SEMINARY GALESBURG IL 61401 KNOX (309) 344-3161 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.9870200 -90.3636090 0   95 17 17095 23660   Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-qvep_yzhb-cn4g 140064 644980 2019-02-28 2018-09-30 75 6         81               81
3306 SAINT JAMES HOSPITAL 2500 WEST REYNOLDS STREET PONTIAC IL 61764 LIVINGSTON (815) 842-2828 Acute Care Hospitals Voluntary non-profit - Church FALSE 40.8734020 -88.6785830 0   105 17 17105 38700 Bloomington-Pontiac, IL Central Livingston County https://data.medicare.gov/resource/xubh-q36u/row-5rfh_kxf8-j7x6 140161 644981 2019-02-28 2018-09-30 37 5         42               42
3463 ST JOSEPH MEDICAL CENTER 2200 E WASHINGTON BLOOMINGTON IL 61701 MC LEAN (309) 662-3311 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.4801180 -88.9553850 0   113 17 17113 14010 Bloomington-Pontiac, IL Central McLean County https://data.medicare.gov/resource/xubh-q36u/row-4en5_gfet-j24n 140162 644982 2019-02-28 2018-09-30 137           137       12       149
3590 OSF SAINT ANTHONY'S HEALTH CENTER ST ANTHONY'S WAY ALTON IL 62002 MADISON (618) 465-2571 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.9073839 -90.1718152 1 GEOMETRIC_CENTER 119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-mu62-iiye-da97 140052 645329 2019-02-28 2018-09-30 68 10         78               78
3705 MASON DISTRICT HOSPITAL 615 NORTH PROMENADE STREET,P O BOX 530 HAVANA IL 62644 MASON (309) 543-4431 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.3057130 -90.0561110 0   125 17 17125         https://data.medicare.gov/resource/xubh-q36u/row-sff2~mc9z_hnb5 141313 644984 2019-02-28 2018-09-30 25           25               25
3869 PASSAVANT AREA HOSPITAL 1600 W WALNUT ST JACKSONVILLE IL 62650 MORGAN (217) 245-9551 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7452680 -90.2599120 0   137 17 17137 27300 Springfield-Jacksonville-Lincoln, IL Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-s6nm~srnx_9kx5 140058 645330 2019-02-28 2018-09-30 84 9         93 10     15       118
4012 ILLINI COMMUNITY HOSPITAL 640 W WASHINGTON PITTSFIELD IL 62363 PIKE (217) 285-2113 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.6067930 -90.8150550 0   149 17 17149         https://data.medicare.gov/resource/xubh-q36u/row-pujp_q5tr_5y4p 141315 645075 2019-02-28 2018-09-30 25           25 10             35
433 ELLINWOOD DISTRICT HOSPITAL 605 N MAIN STREET ELLINWOOD KS 67526 BARTON (620) 564-2548 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3607070 -98.5811930 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-kt5p.cy3y_6d85 171301 661185 2019-02-28 2018-09-30 25           25               25
2529 GREENWOOD COUNTY HOSPITAL 100 W 16TH STREET EUREKA KS 67045 GREENWOOD (620) 583-7451 Critical Access Hospitals Government - Local TRUE 37.8353150 -96.2941800 0   73 20 20073         https://data.medicare.gov/resource/xubh-q36u/row-g9zc.t83r_s62e 171339 645085 2019-02-28 2018-09-30 25           25               25
3470 LINDSBORG COMMUNITY HOSPITAL 605 W LINCOLN STREET LINDSBORG KS 67456 MCPHERSON (785) 227-3308 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.5734350 -97.6835900 0   113 20 20113 32700   Central McPherson County https://data.medicare.gov/resource/xubh-q36u/row-z5m8.2c5c.9xk5 171358 645086 2019-02-28 2018-09-30 23           23               23
4250 ASCENSION VIA CHRISTI HOSPITALS WICHITA, INC. 929 NORTH ST FRANCIS STREET WICHITA KS 67214 SEDGWICK (316) 268-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.7006270 -97.3316940 0   173 20 20173 48620 Wichita-Arkansas City-Winfield, KS Central Sedgwick County https://data.medicare.gov/resource/xubh-q36u/row-mnyb~p2im~px9n 170122 644990 2019-02-28 2018-09-30 491 40 55   16 28 630 28             658
825 KING'S DAUGHTERS' MEDICAL CENTER 2201 LEXINGTON AVENUE ASHLAND KY 41101 BOYD (606) 408-4401 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4704010 -82.6359160 0   19 21 21019 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Boyd County https://data.medicare.gov/resource/xubh-q36u/row-2h99.b8qq_r6h2 180009 643766 2019-02-28 2018-09-30 388 38         439       47       486
4079 SPRING VIEW HOSPITAL 320 LORETTO ROAD LEBANON KY 40033 MARION (270) 692-5145 Acute Care Hospitals Proprietary TRUE 37.5703250 -85.2593970 0   155 21 21155         https://data.medicare.gov/resource/xubh-q36u/row-ri6m~j23x~rpdu 180024 643767 2019-02-28 2018-09-30 57 6         63 12             75
4380 PIKEVILLE MEDICAL CENTER 911 BYPASS ROAD PIKEVILLE KY 41501 PIKE (606) 218-3500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4725100 -82.5239500 0   195 21 21195         https://data.medicare.gov/resource/xubh-q36u/row-h2q9~be2e-2gte 180044 643769 2019-02-28 2018-09-30 189 70         268   26           294
737 WILLIS KNIGHTON MEDICAL CENTER, INC 2600 GREENWOOD ROAD SHREVEPORT LA 71103 CADDO (318) 212-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4839230 -93.7787480 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-843s.yxjw_fv2n 190111 644278 2019-02-28 2018-09-30 579 74       50 711 34 30   24       799
1329 BATON ROUGE GENERAL MEDICAL CENTER 3600 FLORIDA BLVD BATON ROUGE LA 70806 E. BATON ROUGE (225) 387-7767 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4503360 -91.1546380 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-wzk2-7azq.gecu 190065 643777 2019-02-28 2018-09-30 212 24   8   9 253 50 8   54       365
3205 FRANKLIN FOUNDATION HOSPITAL 1097 NORTHWEST BLVD FRANKLIN LA 70538 ST. MARY (337) 828-0760 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.8018700 -91.5252720 0   101 22 22101 34020 Lafayette-Opelousas-Morgan City, LA Central St. Mary Parish https://data.medicare.gov/resource/xubh-q36u/row-72t5.bydx-dr2i 191310 645093 2019-02-28 2018-09-30 20 5         25               25
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
438 NORTHERN LIGHT BLUE HILL MEMORIAL HOSPITAL 57 WATER STREET BLUE HILL ME 4614 HANCOCK (207) 374-2836 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4114200 -68.5862130 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-ib5k-im2e_vk94 201300 645100 2019-02-28 2018-09-30 25           25               25
358 MARTHA'S VINEYARD HOSPITAL INC ONE HOSPITAL ROAD, FIRST FL, WING 5, PO BOX 1477 OAK BLUFFS MA 2557 DUKES (508) 693-0410 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4570063 -70.5517789 1 APPROXIMATE 7 25 25007 47240   Central Dukes County https://data.medicare.gov/resource/xubh-q36u/row-ym84.mbv4~ifss 221300 644287 2019-02-28 2018-09-30 25           25               25
756 EMERSON HOSPITAL - 133 OLD ROAD TO 9 ACRE CORNER W CONCORD MA 1742 MIDDLESEX (978) 369-1400 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.4526280 -71.3772310 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-y26k_3nm4~rkj6 220084 644738 2019-02-28 2018-09-30 97 14         111 29     20       160
1010 MASSACHUSETTS EYE AND EAR INFIRMARY - 243 CHARLES STREET BOSTON MA 2114 SUFFOLK (617) 523-7900 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3628610 -71.0705210 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-u3e3_hg2x_hi8v 220075 644640 2019-02-28 2018-09-30 41           41               41
1015 TUFTS MEDICAL CENTER 800 WASHINGTON STREET BOSTON MA 2111 SUFFOLK (617) 636-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3494860 -71.0636930 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-bms5~bwa2_vxct 220116 644127 2019-02-28 2018-09-30 266 98         364 20             384
1079 HEYWOOD HOSPITAL - 242 GREEN STREET GARDNER MA 1440 WORCESTER (978) 632-3420 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5865650 -71.9861650 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-vv6z~isen-5p6a 220095 645108 2019-02-28 2018-09-30 103 11         114 20             134
1081 ATHOL MEMORIAL HOSPITAL 2033 MAIN STREET ATHOL MA 1331 WORCESTER (978) 249-3511 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.5862730 -72.2087480 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-kb7k~zmz5~v8ji 221303 644288 2019-02-28 2018-09-30 25           25               25
1084 HEALTH ALLIANCE - CLINTON HOSPITAL 60 HOSPITAL ROAD LEOMINSTER MA 1453 WORCESTER (978) 466-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.5411930 -71.7630330 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-y6vw_ua5p.gsn5 220001 644639 2019-02-28 2018-09-30 120 10         130 20             150
907 LAKELAND HOSPITAL WATERVLIET 400 MEDICAL PARK DR WATERVLIET MI 49098 BERRIEN (269) 463-3111 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.1848660 -86.2507600 0   21 26 26021 35660 South Bend-Elkhart-Mishawaka, IN-MI Central Berrien County https://data.medicare.gov/resource/xubh-q36u/row-7efk~hcgi~rsxw 230078 645339 2019-02-28 2018-09-30 26           26   18           44
1649 ST FRANCIS HOSPITAL 3401 LUDINGTON ST ESCANABA MI 49829 DELTA (906) 786-3311 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.7457600 -87.0948530 0   41 26 26041 21540   Central Delta County https://data.medicare.gov/resource/xubh-q36u/row-iqyh_xi8k_igyu 231337 645115 2019-02-28 2018-09-30 16 9         25               25
4097 MCLAREN CARO REGION 401 N HOOPER ST CARO MI 48723 TUSCOLA (989) 673-3141 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4931510 -83.4071570 0   157 26 26157         https://data.medicare.gov/resource/xubh-q36u/row-c56z_ysxt_4rjy 231329 645341 2019-02-28 2018-09-30 25           25               25
1908 PRAIRIE RIDGE HOSPITAL AND HEALTH SERVICES 1411 HIGHWAY 793 E ELBOW LAKE MN 56531 GRANT (218) 685-7300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9908032 -95.9578947 1 ROOFTOP 51 27 27051         https://data.medicare.gov/resource/xubh-q36u/row-is3f.7a5b~t9ju 241379 644131 2019-02-28 2018-09-30 10           10               10
3598 RIVERVIEW HOSPITAL 323 SOUTH MINNESOTA CROOKSTON MN 56716 POLK (218) 281-9200 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7720830 -96.6181060 0   119 27 27119 24220   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-9ugf.smjx.yquq 241320 644130 2019-02-28 2018-09-30 25 5         30       24       54
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
292 FIELD HEALTH SYSTEM 178 HIGHWAY 24 CENTREVILLE MS 39631 WILKINSON (601) 890-0500 Critical Access Hospitals Government - Local TRUE 31.0820299 -91.0587631 1 ROOFTOP 5 28 28005 32620   Outlying Amite County https://data.medicare.gov/resource/xubh-q36u/row-d7tp~8xnm~uwen 251309 646102 2019-02-28 2018-09-30 16           16               16
1535 GEORGE REGIONAL HEALTH SYSTEM 859 WINTER STREET LUCEDALE MS 39452 GEORGE (601) 947-3161 Acute Care Hospitals Government - Local TRUE 30.9222350 -88.5928530 0   39 28 28039         https://data.medicare.gov/resource/xubh-q36u/row-f75f~mexp.zvtb 250036 643798 2019-02-28 2018-09-30 36 6         42               42
1651 GREENE COUNTY HOSPITAL CAH 1017 JACKSON STREET LEAKESVILLE MS 39451 GREENE (601) 394-4135 Critical Access Hospitals Government - Local TRUE 31.1547640 -88.5626450 0   41 28 28041         https://data.medicare.gov/resource/xubh-q36u/row-w43a~rntf~brjp 251329 643805 2019-02-28 2018-09-30 7           7               7
2753 GREENWOOD LEFLORE HOSPITAL 1401 RIVER RD GREENWOOD MS 38935 LEFLORE (662) 459-7561 Acute Care Hospitals Government - Local TRUE 33.5182540 -90.2001890 0   83 28 28083 24900   Central Leflore County https://data.medicare.gov/resource/xubh-q36u/row-h4t8-zied.hz4k 250099 644302 2019-02-28 2018-09-30 164 9         173   20           193
2795 KING'S DAUGHTERS MEDICAL CENTER-BROOKHAVEN P O BOX 948/427 HIGHWAY 51 NORTH BROOKHAVEN MS 39601 LINCOLN (601) 833-6011 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.5892013 -90.4580392 1 ROOFTOP 85 28 28085 15020 Jackson-Vicksburg-Brookhaven, MS Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-5ntd-ntch~5mxf 250057 643905 2019-02-28 2018-09-30 85 5         90               90
3536 PONTOTOC HEALTH SERVICE CAH 176 SOUTH MAIN STREET PONTOTOC MS 38863 PONTOTOC (662) 489-5510 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2428270 -88.9968000 0   115 28 28115 46180   Outlying Pontotoc County https://data.medicare.gov/resource/xubh-q36u/row-cgtx~8fwc-42mt 251308 643801 2019-02-28 2018-09-30 25           25               25
3858 TALLAHATCHIE CRITICAL ACCESS HOSPITAL 201 SOUTH MARKET ST / PO BOX 230 CHARLESTON MS 38921 TALLAHATCHIE (662) 647-5535 Critical Access Hospitals Government - Local TRUE 34.0050790 -90.0581650 0   135 28 28135         https://data.medicare.gov/resource/xubh-q36u/row-avrr~zg9m~xqab 251304 644307 2019-02-28 2018-09-30 9           9               9
3920 TISHOMINGO HEALTH SERVICES INC 1777 CURTIS DRIVE IUKA MS 38852 TISHOMINGO (662) 423-6051 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.8036860 -88.2092180 0   141 28 28141         https://data.medicare.gov/resource/xubh-q36u/row-8vqy~22mf_tvap 250002 643792 2019-02-28 2018-09-30 48           48               48
4082 WEBSTER GENERAL HOSPITAL/ SWING BED 70 MEDICAL PLAZA EUPORA MS 39744 WEBSTER (662) 258-6221 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.5347360 -89.2669430 0   155 28 28155         https://data.medicare.gov/resource/xubh-q36u/row-a3qx_u9bd-sjek 250020 643797 2019-02-28 2018-09-30 38           38               38
4176 BAPTIST MEDICAL CENTER-YAZOO 823 GRAND AVENUE YAZOO CITY MS 39194 YAZOO (662) 746-2261 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.8587300 -90.4033210 0   163 28 28163 27140 Jackson-Vicksburg-Brookhaven, MS Outlying Yazoo County https://data.medicare.gov/resource/xubh-q36u/row-i83f-pamk.mfmb 251313 643910 2019-02-28 2018-09-30 25           25               25
2614 COX MEDICAL CENTERS 3801 SOUTH NATIONAL AVENUE SPRINGFIELD MO 65807 GREENE (417) 269-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.1449660 -93.2780800 0   77 29 29077 44180 Springfield-Branson, MO Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-k4p4_umkj~v498 260040 645428 2019-02-28 2018-09-30 496 74       34 604 14 34   28       680

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