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

305 rows where "filed_date" is on date 2019-12-02 sorted by state

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, geocode_accuracy, fy_end_date, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_irf_beds, nursing_fac_beds, oth_longterm_beds

filed_date (date) ✖

  • 2019-12-02 · 305 ✖
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
3668 3668 CENTRAL PENINSULA GENERAL HOSPITAL 250 HOSPITAL PLACE SOLDOTNA AK 99669 KENAI PENINSULA (907) 262-4404 Acute Care Hospitals Voluntary non-profit - Other TRUE 60.4938650 -151.0776580 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-kgwk-j25h-z8m3 20024 661276 2019-12-02 2019-06-30 43 6         49       60       109
4375 4375 PETERSBURG MEDICAL CENTER PO BOX 589 PETERSBURG AK 99833 PETERSBURG BOROUGH (907) 772-4291 Critical Access Hospitals Government - Local TRUE 56.8128691 -132.9554619 1 ROOFTOP 195 2 2195         https://data.medicare.gov/resource/xubh-q36u/row-ky7y_b72j_698p 21304 660160 2019-12-02 2019-06-30 12           12       15       27
1772 1772 VAUGHAN REGIONAL MEDICAL CENTER PARKWAY CAMPUS 1015 MEDICAL CENTER PARKWAY SELMA AL 36701 DALLAS (334) 418-4100 Acute Care Hospitals Proprietary TRUE 32.4302480 -87.0551740 0   47 1 1047 42820   Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yhen~7fx5~f9rk 10118 660350 2019-12-02 2019-06-30 86 23         109               109
2589 2589 NORTH ALABAMA MEDICAL CENTER 1701 VETERANS DRIVE FLORENCE AL 35630 LAUDERDALE (256) 768-8400 Acute Care Hospitals Proprietary TRUE 34.8027560 -87.6521910 0   77 1 1077 22520   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-n9pr_q6au_cg3t 10006 660158 2019-12-02 2019-06-30 181 36 16       233               233
2732 2732 ATHENS LIMESTONE HOSPITAL 700 WEST MARKET STREET ATHENS AL 35611 LIMESTONE (256) 233-9292 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8034990 -86.9778030 0   83 1 1083 26620 Huntsville-Decatur-Albertville, AL Outlying Limestone County https://data.medicare.gov/resource/xubh-q36u/row-nzdh.hdic_txkm 10079 660159 2019-12-02 2019-06-30 56 10         66               66
2879 2879 HUNTSVILLE HOSPITAL 101 SIVLEY RD HUNTSVILLE AL 35801 MADISON (256) 265-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.7212260 -86.5815470 0   89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-srfb_s9fq-erqf 10039 660063 2019-12-02 2019-06-30 713 42 20   25   877 35             912
1122 1122 CHI ST VINCENT MORRILTON #4 HOSPITAL DRIVE MORRILTON AR 72110 CONWAY (501) 977-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.1699700 -92.7217020 0   29 5 5029         https://data.medicare.gov/resource/xubh-q36u/row-jajp~f47n.nife 41324 660162 2019-12-02 2019-06-30 25           25               25
1827 1827 FULTON COUNTY HOSPITAL 679 NORTH MAIN STREET SALEM AR 72576 FULTON (870) 895-2691 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3833590 -91.8112030 0   49 5 5049         https://data.medicare.gov/resource/xubh-q36u/row-9b6n-wd2m.b7tm 41322 660913 2019-12-02 2019-06-30 25           25               25
1889 1889 CHI ST. VINCENT HOSPITAL HOT SPRINGS 300 WERNER STREET HOT SPRINGS AR 71903 GARLAND (501) 622-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.4660350 -93.0663960 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-pyjq_z3nz-ckdj 40026 662146 2019-12-02 2019-06-30 204 25         229               229
3578 3578 ST VINCENT MEDICAL CENTER/NORTH 2215 WILDWOOD AVENUE SHERWOOD AR 72120 PULASKI (501) 552-7100 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.8143780 -92.2075140 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-92it.v7ju~ja3t 40137 659915 2019-12-02 2019-06-30 45 14         59               59
3579 3579 CHI-ST VINCENT INFIRMARY TWO ST VINCENT CIRCLE LITTLE ROCK AR 72205 PULASKI (501) 552-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7502877 -92.3393435 1 ROOFTOP 119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-rvvz~qyi8_5qyq 40007 660911 2019-12-02 2019-06-30 330 23 20     20 393               393
3910 3910 OZARK HEALTH 2500 HIGHWAY 65 SOUTH CLINTON AR 72031 VAN BUREN (501) 745-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.5593750 -92.4499130 0   141 5 5141         https://data.medicare.gov/resource/xubh-q36u/row-3ppd-9bg7~xqjh 41313 661137 2019-12-02 2019-06-30 25           25       118       143
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
55 55 CHILDREN'S HOSPITAL & RESEARCH CENTER OAKLAND 747 52ND STREET OAKLAND CA 94609 ALAMEDA (510) 428-3000 Childrens Voluntary non-profit - Private TRUE 37.8373260 -122.2677410 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-n7ad_497y.9ize 53301 661145 2019-12-02 2019-06-30 123 23       44 190               190
587 587 CONTRA COSTA REGIONAL MEDICAL CENTER 2500 ALHAMBRA AVENUE MARTINEZ CA 94553 CONTRA COSTA (925) 370-5000 Acute Care Hospitals Government - Local TRUE 38.0064670 -122.1308910 0   13 6 6013 41860 San Jose-San Francisco-Oakland, CA Outlying Contra Costa County https://data.medicare.gov/resource/xubh-q36u/row-iuri_7t24.rw23 50276 660491 2019-12-02 2019-06-30 110 8       6 124 23             147
814 814 SAINT AGNES MEDICAL CENTER 1303 E HERNDON AVE FRESNO CA 93710 FRESNO (559) 450-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.8371020 -119.7658780 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-m6yb~w6hh~ku8s 50093 662016 2019-12-02 2019-06-30 345 27     13   385               385
944 944 MAD RIVER COMMUNITY HOSPITAL 3800 JANES RD ARCATA CA 95521 HUMBOLDT (707) 822-3621 Acute Care Hospitals Proprietary TRUE 40.9033090 -124.0908470 0   23 6 6023 21700   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-qduv~9itb_454t 50028 661454 2019-12-02 2019-06-30 41 8         49               49
994 994 EL CENTRO REGIONAL MEDICAL CENTER 1415 ROSS AVENUE EL CENTRO CA 92243 IMPERIAL (760) 339-7100 Acute Care Hospitals Government - Local TRUE 32.7814980 -115.5686200 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-35st~i7ay-x3eh 50045 660164 2019-12-02 2019-06-30 141 20         161               161
995 995 PIONEERS MEMORIAL HEALTHCARE DISTRICT 207 WEST LEGION ROAD BRAWLEY CA 92227 IMPERIAL (760) 351-3333 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9599470 -115.5527230 0   25 6 6025 20940   Central Imperial County https://data.medicare.gov/resource/xubh-q36u/row-9jqy.yukk~78kt 50342 662026 2019-12-02 2019-06-30 99 8         107               107
1061 1061 NORTHERN INYO HOSPITAL 150 PIONEER LANE BISHOP CA 93514 INYO (760) 873-5811 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.3621080 -118.4073620 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-mi4n-bdvc~nrpd 51324 661291 2019-12-02 2019-06-30 21 4         25               25
1062 1062 SOUTHERN INYO HOSPITAL 501 EAST LOCUST STREET LONE PINE CA 93545 INYO (760) 876-5501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.6083740 -118.0581590 0   27 6 6027         https://data.medicare.gov/resource/xubh-q36u/row-wcp4_jkw5.du53 51302 659919 2019-12-02 2019-06-30 4           4       33       37
1127 1127 KERN MEDICAL CENTER 1700 MOUNT VERNON AVENUE BAKERSFIELD CA 93306 KERN (661) 326-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.3809640 -118.9675460 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-jv3w_f89d_ies4 50315 662025 2019-12-02 2019-06-30 182 12       28 222               222
1516 1516 USC VERDUGO HILLS HOSPITAL 1812 VERDUGO BLVD GLENDALE CA 91209 LOS ANGELES (818) 790-7100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2056140 -118.2160480 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-wr7c_jjf9_hfgj 50124 661285 2019-12-02 2019-06-30 104 12         123 24     18       165
1517 1517 SAN GABRIEL VALLEY MEDICAL CENTER 438 W LAS TUNAS DRIVE SAN GABRIEL CA 91776 LOS ANGELES (626) 289-5454 Acute Care Hospitals Proprietary TRUE 34.1024610 -118.1055720 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-vsyy.e66v~akjm 50132 660490 2019-12-02 2019-06-30 156 19         187 42     44       273
1518 1518 ALHAMBRA HOSPITAL MEDICAL CENTER 100 S RAYMOND AVE ALHAMBRA CA 91801 LOS ANGELES (626) 570-1606 Acute Care Hospitals Proprietary FALSE 34.0901560 -118.1450170 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-75jx-8uav_n2er 50281 660918 2019-12-02 2019-06-30 88 13         101   17   26       144
1520 1520 ANTELOPE VALLEY HOSPITAL 1600 W AVE J LANCASTER CA 93534 LOS ANGELES (661) 949-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6893710 -118.1584760 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-jtig~5whv~hgpp 50056 660914 2019-12-02 2019-06-30 345 21         393               393
1682 1682 JOHN C FREMONT HEALTHCARE DISTRICT 5189 HOSPITAL ROAD MARIPOSA CA 95338 MARIPOSA (209) 966-3631 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.5005310 -119.9769480 0   43 6 6043         https://data.medicare.gov/resource/xubh-q36u/row-fty8~tgqe.f5tj 51304 661465 2019-12-02 2019-06-30 18           18       16   1   35
1725 1725 MENDOCINO COAST DISTRICT HOSPITAL 700 RIVER DR FORT BRAGG CA 95437 MENDOCINO (707) 961-1234 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.4326130 -123.8007970 0   45 6 6045 46380   Central Mendocino County https://data.medicare.gov/resource/xubh-q36u/row-rw6t.w3x2~jyq9 51325 661292 2019-12-02 2019-06-30 21 4         25               25
2102 2102 AHMC ANAHEIM REGIONAL MEDICAL CENTER 1111 W LA PALMA AVENUE ANAHEIM CA 92801 ORANGE (714) 774-1450 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.8471380 -117.9339340 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-r3zf-f22h~mx8e 50226 661286 2019-12-02 2019-06-30 180 32         223               223
2119 2119 CHILDREN'S HOSPITAL OF ORANGE COUNTY 1201 W LA VETA AVE ORANGE CA 92868 ORANGE (714) 997-3000 Childrens Voluntary non-profit - Other FALSE 33.7803300 -117.8649600 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-tabq.iupn-ad4g 53304 661466 2019-12-02 2019-06-30 176 24         334               334
2240 2240 SENECA DISTRICT HOSPITAL 130 BRENTWOOD DRIVE CHESTER CA 96020 PLUMAS (530) 258-2121 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.3053020 -121.2340180 0   63 6 6063         https://data.medicare.gov/resource/xubh-q36u/row-6rw5.c6e6.9puv 51327 661143 2019-12-02 2019-06-30 10           10       16       26
2287 2287 SAN GORGONIO MEMORIAL HOSPITAL 600 NORTH HIGHLAND SPRINGS AVENUE BANNING CA 92220 RIVERSIDE (951) 845-1121 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.9316874 -116.9461472 1 ROOFTOP 65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-v72w~xz4e~mtkk 50054 660165 2019-12-02 2019-06-30 55 6         61               61
2335 2335 UNIVERSITY OF CALIFORNIA DAVIS MEDICAL CENTER 2315 STOCKTON BOULEVARD SACRAMENTO CA 95817 SACRAMENTO (916) 734-2011 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.5543750 -121.4575350 0   67 6 6067 40900 Sacramento-Roseville, CA Central Sacramento County https://data.medicare.gov/resource/xubh-q36u/row-xgsz_gz6f-5jxx 50599 662166 2019-12-02 2019-06-30 441 34   12 28 24 598   19           617
2386 2386 HAZEL HAWKINS MEMORIAL HOSPITAL 911 SUNSET DRIVE HOLLISTER CA 95023 SAN BENITO (831) 637-5711 Acute Care Hospitals Government - Hospital District or Authority FALSE 36.8351220 -121.3866200 0   69 6 6069 41940 San Jose-San Francisco-Oakland, CA Outlying San Benito County https://data.medicare.gov/resource/xubh-q36u/row-z5mt_ehjz~v7xh 50296 661288 2019-12-02 2019-06-30 41 8         49       119       168
2506 2506 PALOMAR HEALTH DOWNTOWN CAMPUS 555 EAST VALLEY PARKWAY ESCONDIDO CA 92025 SAN DIEGO (760) 739-3000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1259370 -117.0761860 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-75ug~bcqe_4ycp 50115 660353 2019-12-02 2019-06-30 238 48         286 25 18           329
2512 2512 RADY CHILDREN'S HOSPITAL - SAN DIEGO 3020 CHILDRENS WAY SAN DIEGO CA 92123 SAN DIEGO (858) 576-1700 Childrens Voluntary non-profit - Other FALSE 32.7982600 -117.1508210 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-g946~ee4n.abkv 53303 660172 2019-12-02 2019-06-30 193 54       24 401         24 19   444
2518 2518 POMERADO HOSPITAL 15615 POMERADO ROAD POWAY CA 92064 SAN DIEGO (858) 485-6511 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9968020 -117.0578520 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-4898.b6y5.nvpq 50636 660919 2019-12-02 2019-06-30 79 12       4 95 12     129       236
2519 2519 TRI-CITY MEDICAL CENTER 4002 VISTA WAY OCEANSIDE CA 92056 SAN DIEGO (760) 724-8411 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.1837830 -117.2909180 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-hngp~yjnr~dx2a 50128 662018 2019-12-02 2019-06-30 242 28       20 290 5 10           305
2557 2557 LAGUNA HONDA HOSPITAL & REHABILITATION CENTER 375 LAGUNA HONDA BLVD SAN FRANCISCO CA 94116 SAN FRANCISCO (415) 759-2300 Acute Care Hospitals Government - Local FALSE 37.7478240 -122.4586360 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-tz44~vi64-ys8h 50668 662169 2019-12-02 2019-06-30 6           6   5   769       780
2594 2594 SAN JOAQUIN GENERAL HOSPITAL 500 W HOSPITAL ROAD FRENCH CAMP CA 95231 SAN JOAQUIN (209) 468-6000 Acute Care Hospitals Government - Local TRUE 37.8864920 -121.2820610 0   77 6 6077 44700 San Jose-San Francisco-Oakland, CA Central San Joaquin County https://data.medicare.gov/resource/xubh-q36u/row-imza-7dfi-q9b9 50167 661140 2019-12-02 2019-06-30 155 16       25 196               196
2738 2738 LOMPOC VALLEY MEDICAL CENTER 1515 E OCEAN AVENUE LOMPOC CA 93436 SANTA BARBARA (805) 737-3300 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.6406390 -120.4398990 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-9waa-2p9w-xqwe 50110 660915 2019-12-02 2019-06-30 54 6         60       110       170
3078 3078 SONOMA VALLEY HOSPITAL 347 ANDRIEUX ST SONOMA CA 95476 SONOMA (707) 935-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 38.2885640 -122.4658500 0   97 6 6097 42220 San Jose-San Francisco-Oakland, CA Central Sonoma County https://data.medicare.gov/resource/xubh-q36u/row-qdpm~37ez~79pv 50090 662015 2019-12-02 2019-06-30 42 6         48       27       75
3137 3137 OAK VALLEY HOSPITAL DISTRICT 350 S OAK AVE OAKDALE CA 95361 STANISLAUS (209) 847-3011 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.7580980 -120.8603630 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-ehek_q3if-kskp 50067 660166 2019-12-02 2019-06-30 30 5         35       115       150
71 71 HOWARD UNIVERSITY HOSPITAL 2041 GEORGIA AVE NW WASHINGTON DC 20060 THE DISTRICT (202) 745-6100 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.9170110 -77.0218960 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-8v26.mgb3_zc6i 90003 660921 2019-12-02 2019-06-30 164 36         200               200
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
348 348 SHANDS STARKE REGIONAL MEDICAL CENTER 922 E CALL ST STARKE FL 32091 BRADFORD (904) 368-2300 Critical Access Hospitals Proprietary TRUE 29.9419070 -82.1016500 0   7 12 12007         https://data.medicare.gov/resource/xubh-q36u/row-463i.u2z5-p3cq 101310 660199 2019-12-02 2019-06-30 25           25               25
817 817 ASCENSION ST VINCENT'S CLAY COUNTY 1670 ST VINCENTS WAY MIDDLEBURG FL 32068 CLAY (904) 602-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1111350 -81.8312980 0   19 12 12019 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Clay County https://data.medicare.gov/resource/xubh-q36u/row-twtd-d5g9-nqdi 100321 660793 2019-12-02 2019-06-30 98 8         106               106
1208 1208 ASCENSION ST VINCENT'S RIVERSIDE 1 SHIRCLIFF WAY JACKSONVILLE FL 32204 DUVAL (904) 308-7300 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.3078910 -81.6891540 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-6ygg.pivg~t9br 100040 660790 2019-12-02 2019-06-30 418 29 14   8 10 479               479
1213 1213 ASCENSION ST VINCENT'S SOUTHSIDE 4201 BELFORT RD JACKSONVILLE FL 32216 DUVAL (904) 296-3700 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2530960 -81.5841260 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-wzcx_jtb2.mgyj 100307 660195 2019-12-02 2019-06-30 233 17       10 260               260
1584 1584 FLORIDA STATE HOSPITAL UNIT 31 MED 100 N MAIN ST CHATTAHOOCHEE FL 32324 GADSDEN (850) 663-7536 Acute Care Hospitals Government - State FALSE 30.7068990 -84.8425840 0   39 12 12039 45220 Tallahassee-Bainbridge, FL-GA Outlying Gadsden County https://data.medicare.gov/resource/xubh-q36u/row-kyk8-9a3q-5siu 100298 660194 2019-12-02 2019-06-30 24           24 34         1172   1230
3628 3628 SHANDS LIVE OAK REGIONAL MEDICAL CENTER 1100 SW 11TH ST LIVE OAK FL 32060 SUWANNEE (904) 362-1413 Critical Access Hospitals Proprietary TRUE 30.2917367 -83.0028124 1 ROOFTOP 121 12 12121         https://data.medicare.gov/resource/xubh-q36u/row-keij_wts9-t8jc 101301 660198 2019-12-02 2019-06-30 25           25               25
2886 2886 EMORY DECATUR HOSPITAL 2701 N DECATUR ROAD DECATUR GA 30033 DE KALB (404) 501-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.7921600 -84.2826790 0   89 13 13089 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-pp7m~b3m9-dt6m 110076 661305 2019-12-02 2019-06-30 318 32       42 392   30           422
2888 2888 EMORY HILLANDALE HOSPITAL 2801 DEKALB MEDICAL PARKWAY LITHONIA GA 30058 DE KALB (404) 501-8040 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.7054880 -84.1469270 0   89 13 13089 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central DeKalb County https://data.medicare.gov/resource/xubh-q36u/row-mkqk.2abm~442s 110226 660924 2019-12-02 2019-06-30 82 8         90               90
3943 3943 HIGGINS GENERAL HOSPITAL 200 ALLEN MEMORIAL DRIVE BREMEN GA 30110 HARALSON (770) 812-2000 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7163430 -85.1446230 0   143 13 13143 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Haralson County https://data.medicare.gov/resource/xubh-q36u/row-rd44_uqxz.t5yc 111320 660206 2019-12-02 2019-06-30 15           15               15
4541 4541 MEADOWS REGIONAL MEDICAL CENTER ONE MEADOWS PARKWAY VIDALIA GA 30474 TOOMBS (912) 535-5828 Acute Care Hospitals Proprietary TRUE 32.2071314 -82.3777520 1 GEOMETRIC_CENTER 279 13 13279 47080   Central Toombs County https://data.medicare.gov/resource/xubh-q36u/row-ifps.um7x~mbjr 110128 659939 2019-12-02 2019-06-30 44 8         52               52
4564 4564 WAYNE MEMORIAL HOSPITAL 865 SOUTH FIRST STREET JESUP GA 31545 WAYNE (912) 530-3302 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6029520 -81.8990940 0   305 13 13305 27700   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-de2e.7sgx-hidy 110124 660369 2019-12-02 2019-06-30 76 12         88               88
79 79 NORTH HAWAII COMMUNITY HOSPITAL 67 1125 MAMALAHOA HIGHWAY KAMUELA HI 96743 HAWAII (808) 885-4444 Acute Care Hospitals Voluntary non-profit - Private TRUE 20.0232419 -155.6653736 1 RANGE_INTERPOLATED 1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-ntxy-3z5d.j57p 120028 662518 2019-12-02 2019-06-30 29 4         33               33
82 82 KONA COMMUNITY HOSPITAL 79-1019 HAUKAPILA STREET KEALAKEKUA HI 96750 HAWAII (808) 322-9311 Acute Care Hospitals Government - State TRUE 19.5192370 -155.9177190 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-j5zq.9y53_j6as 120019 662187 2019-12-02 2019-06-30 74 9         83 11             94
84 84 KAU HOSPITAL 1 KAMANI STREET PAHALA HI 96777 HAWAII (808) 928-8331 Critical Access Hospitals Government - State TRUE 19.2005710 -155.4720970 0   1 15 15001 25900   Central Hawaii County https://data.medicare.gov/resource/xubh-q36u/row-jcnf-fhnk_q5i3 121301 662188 2019-12-02 2019-06-30 6           6               6
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
17 17 VAN DIEST MEDICAL CENTER 2350 HOSPITAL DRIVE WEBSTER CITY IA 50595 HAMILTON (515) 832-9400 Critical Access Hospitals Government - Local TRUE 42.4529630 -93.8134850 0   79 19 19079         https://data.medicare.gov/resource/xubh-q36u/row-89tb_yu6c_zwc4 161361 660984 2019-12-02 2019-06-30 25           25               25
35 35 HAWARDEN REGIONAL HEALTHCARE 1111 11TH STREET HAWARDEN IA 51023 SIOUX (712) 551-3100 Critical Access Hospitals Government - Local TRUE 42.9980080 -96.4794270 0   167 19 19167         https://data.medicare.gov/resource/xubh-q36u/row-i52u~xknc.njpg 161311 660957 2019-12-02 2019-06-30 25           25               25
69 69 ADAIR COUNTY MEMORIAL HOSPITAL 609 SE KENT GREENFIELD IA 50849 ADAIR (641) 743-2123 Critical Access Hospitals Government - Local TRUE 41.3031030 -94.4519270 0   1 19 19001         https://data.medicare.gov/resource/xubh-q36u/row-3dt7_nstz~yhhy 161310 660956 2019-12-02 2019-06-30 25           25               25
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
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
353 353 MERCYONE CENTERVILLE MEDICAL CENTER ONE ST JOSEPH'S DRIVE CENTERVILLE IA 52544 APPANOOSE (641) 437-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7555228 -92.8568047 1 ROOFTOP 7 19 19007         https://data.medicare.gov/resource/xubh-q36u/row-quyx-h8pq.iqb9 161377 660989 2019-12-02 2019-06-30 22 3         25           19   44
504 504 VIRGINIA GAY HOSPITAL 502 NORTH 9TH AVENUE VINTON IA 52349 BENTON (319) 472-6200 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1736740 -92.0133850 0   11 19 19011 16300 Cedar Rapids-Iowa City, IA Outlying Benton County https://data.medicare.gov/resource/xubh-q36u/row-9sfp.7tdh~i4z3 161349 660977 2019-12-02 2019-06-30 25           25           40   65
681 681 BOONE COUNTY HOSPITAL 1015 UNION STREET BOONE IA 50036 BOONE (515) 432-3140 Critical Access Hospitals Government - Local TRUE 42.0555830 -93.8770370 0   15 19 19015 14340 Des Moines-Ames-West Des Moines, IA Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-6zpe~cgwm_xs5p 161372 660987 2019-12-02 2019-06-30 25           25               25
1070 1070 MANNING REGIONAL HEALTHCARE CENTER 1550 SIXTH STREET MANNING IA 51455 CARROLL (712) 655-2072 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.9066500 -95.0750130 0   27 19 19027         https://data.medicare.gov/resource/xubh-q36u/row-guzz_e3r6~bpt6 161332 660967 2019-12-02 2019-06-30 17           17           46   63
1693 1693 GUTTENBERG MUNICIPAL HOSPITAL 200 MAIN STREET GUTTENBERG IA 52052 CLAYTON (563) 252-1121 Critical Access Hospitals Government - Local TRUE 42.7855480 -91.0999540 0   43 19 19043         https://data.medicare.gov/resource/xubh-q36u/row-9vtm.kuer.r3a9 161312 660958 2019-12-02 2019-06-30 25           25               25
1779 1779 CRAWFORD COUNTY MEMORIAL HOSPITAL 100 MEDICAL PARKWAY DENISON IA 51442 CRAWFORD (712) 265-2500 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.0232570 -95.3770860 0   47 19 19047         https://data.medicare.gov/resource/xubh-q36u/row-9ydn-ts52-gjkc 161369 660986 2019-12-02 2019-06-30 25           25               25
1836 1836 DALLAS COUNTY HOSPITAL 610 TENTH STREET PERRY IA 50220 DALLAS (515) 465-3547 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.8339590 -94.0944690 0   49 19 19049 19780 Des Moines-Ames-West Des Moines, IA Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5ca8_jqfe~mw9b 161322 660961 2019-12-02 2019-06-30 25           25               25
1950 1950 DECATUR COUNTY HOSPITAL 1405 NW CHURCH STREET LEON IA 50144 DECATUR (641) 446-4871 Critical Access Hospitals Government - Local TRUE 40.7503080 -93.7477890 0   53 19 19053         https://data.medicare.gov/resource/xubh-q36u/row-z8pk.dm9q_4faw 161340 660972 2019-12-02 2019-06-30 11           11               11
2528 2528 GREENE COUNTY MEDICAL CENTER 1000 WEST LINCOLNWAY JEFFERSON IA 50129 GREENE (515) 386-2114 Critical Access Hospitals Government - Local TRUE 42.0152170 -94.3890600 0   73 19 19073         https://data.medicare.gov/resource/xubh-q36u/row-ekvn-6v3z_68bn 161325 660962 2019-12-02 2019-06-30 21   4       25               25
2789 2789 CHI HEALTH MISSOURI VALLEY 631 N 8TH ST MISSOURI VALLEY IA 51555 HARRISON (712) 642-2784 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.5629770 -95.8850960 0   85 19 19085 36540 Omaha-Council Bluffs-Fremont, NE-IA Outlying Harrison County https://data.medicare.gov/resource/xubh-q36u/row-nied-xbd5_n6bv 161309 661179 2019-12-02 2019-06-30 25           25               25
2904 2904 REGIONAL HEALTH SERVICES OF HOWARD COUNTY 235 8TH AVENUE WEST CRESCO IA 52136 HOWARD (563) 547-2101 Critical Access Hospitals Government - Local TRUE 43.3818910 -92.1177640 0   89 19 19089         https://data.medicare.gov/resource/xubh-q36u/row-cg3w~i3hb_y7gu 161328 660965 2019-12-02 2019-06-30 18           18           1   19
3106 3106 JACKSON COUNTY REGIONAL HEALTH CENTER 700 W GROVE ST MAQUOKETA IA 52060 JACKSON (563) 652-2474 Critical Access Hospitals Government - Local TRUE 42.0737150 -90.6731320 0   97 19 19097         https://data.medicare.gov/resource/xubh-q36u/row-cqwp_hqw2.ikei 161329 660966 2019-12-02 2019-06-30 25           25               25
3201 3201 JEFFERSON COUNTY HEALTH CENTER 2000 S MAIN FAIRFIELD IA 52556 JEFFERSON (641) 472-4111 Critical Access Hospitals Government - Local TRUE 40.9856350 -91.9631180 0   101 19 19101 21840   Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-cksn~64fu_7y3h 161364 660985 2019-12-02 2019-06-30 25           25               25
3552 3552 LUCAS COUNTY HEALTH CENTER 1200 NORTH 7TH STREET CHARITON IA 50049 LUCAS (641) 774-3000 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0276930 -93.3034210 0   117 19 19117         https://data.medicare.gov/resource/xubh-q36u/row-6kae-djtk-d35x 161341 660973 2019-12-02 2019-06-30 25           25               25
3676 3676 MAHASKA HEALTH PARTNERSHIP 1229 C AVENUE EAST OSKALOOSA IA 52577 MAHASKA (641) 672-3100 Critical Access Hospitals Government - Local TRUE 41.2985620 -92.6301310 0   123 19 19123 36820   Central Mahaska County https://data.medicare.gov/resource/xubh-q36u/row-r6q8.mtiy.cvna 161379 660990 2019-12-02 2019-06-30 25           25           1   26
3706 3706 KNOXVILLE HOSPITAL & CLINICS 1002 SOUTH LINCOLN STREET KNOXVILLE IA 50138 MARION (641) 842-2151 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.3109860 -93.1095110 0   125 19 19125         https://data.medicare.gov/resource/xubh-q36u/row-6isd~id7e-3xdw 161355 660980 2019-12-02 2019-06-30 25           25               25
3827 3827 BURGESS HEALTH CENTER 1600 DIAMOND STREET ONAWA IA 51040 MONONA (712) 423-2311 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.0257390 -96.1055860 0   133 19 19133         https://data.medicare.gov/resource/xubh-q36u/row-hw7j.7dfu.cqug 161359 660983 2019-12-02 2019-06-30 25           25               25
3854 3854 MONROE COUNTY HOSPITAL 6580 165TH STREET ALBIA IA 52531 MONROE (641) 932-2134 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0448380 -92.7964750 0   135 19 19135         https://data.medicare.gov/resource/xubh-q36u/row-wtqj-qihw~wgcb 161342 660974 2019-12-02 2019-06-30 25           25               25
3972 3972 CLARINDA REGIONAL HEALTH CENTER 220 ESSIE DAVISON DRIVE CLARINDA IA 51632 PAGE (712) 542-2176 Critical Access Hospitals Voluntary non-profit - Other TRUE 40.7231160 -95.0414060 0   145 19 19145         https://data.medicare.gov/resource/xubh-q36u/row-e24e-jv8q.avua 161352 661182 2019-12-02 2019-06-30 25           25               25
4053 4053 IOWA METHODIST MEDICAL CENTER 1200 PLEASANT STREET DES MOINES IA 50309 POLK (515) 241-6212 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5907770 -93.6331310 0   153 19 19153 19780 Des Moines-Ames-West Des Moines, IA Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-wepf-7msb.hqzp 160082 661323 2019-12-02 2018-12-31 372 36         455   29           484
4076 4076 CHI HEALTH MERCY COUNCIL BLUFFS 800 MERCY DRIVE COUNCIL BLUFFS IA 51503 POTTAWATTAMIE (712) 328-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2696360 -95.8382010 0   155 19 19155 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Pottawattamie County https://data.medicare.gov/resource/xubh-q36u/row-abwm_b2ah-p5iq 160028 661174 2019-12-02 2019-06-30 129 16         145               145
4186 4186 MYRTUE MEDICAL CENTER 1213 GARFIELD AVENUE HARLAN IA 51537 SHELBY (712) 755-5161 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.6474730 -95.3262020 0   165 19 19165         https://data.medicare.gov/resource/xubh-q36u/row-cvsd.wj8m_w54b 161374 660988 2019-12-02 2019-06-30 25           25               25
4390 4390 IOWA SPECIALTY HOSPITAL-CLARION 1316 SOUTH MAIN STREET CLARION IA 50525 WRIGHT (515) 532-2811 Critical Access Hospitals Government - Local TRUE 42.7216250 -93.7326280 0   197 19 19197         https://data.medicare.gov/resource/xubh-q36u/row-qm5h-kjf7~8unb 161302 661176 2019-12-02 2019-06-30 25           25               25
1066 1066 SAINT ALPHONSUS MEDICAL CENTER - NAMPA 4300 E FLAMINGO AVE NAMPA ID 83687 CANYON (208) 205-0050 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.5963320 -116.5191740 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-ei4u.dihn_gvat 130013 660927 2019-12-02 2019-06-30 74 18       4 96               96
2396 2396 ST JOSEPH REGIONAL MEDICAL CENTER 415 SIXTH STREET LEWISTON ID 83501 NEZ PERCE (208) 799-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.4171210 -117.0249970 0   69 16 16069 30300   Central Nez Perce County https://data.medicare.gov/resource/xubh-q36u/row-dyet_gevw~szfb 130003 662190 2019-12-02 2019-06-30 101 9         110 20             130
272 272 GREENVILLE REGIONAL HOSPITAL 200 HEALTH CARE DR GREENVILLE IL 62246 BOND (618) 664-1230 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9018800 -89.4086770 0   5 17 17005 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Bond County https://data.medicare.gov/resource/xubh-q36u/row-byrn_qvzg.2pup 140137 660929 2019-12-02 2019-06-30 32           32 10             42
1068 1068 ST JOSEPHS HOSPITAL 9515 HOLY CROSS LN BREESE IL 62230 CLINTON (618) 526-4511 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.6251540 -89.5249440 0   27 17 17027 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Clinton County https://data.medicare.gov/resource/xubh-q36u/row-pzsx~2awp~chq9 140145 662043 2019-12-02 2019-06-30 46           46               46
1227 1227 WEST SUBURBAN MEDICAL CENTER 3 ERIE COURT OAK PARK IL 60302 COOK (708) 383-6200 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.8918400 -87.7774710 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-inku-rcmb~ijb5 140049 662038 2019-12-02 2019-04-30 114 21         135       39       174
1242 1242 HOLY CROSS HOSPITAL 2701 W 68TH STREET CHICAGO IL 60629 COOK (773) 884-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7700080 -87.6919090 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-vax2-3b3r_ksyr 140133 661496 2019-12-02 2019-06-30 201 20         221               221
1243 1243 PRESENCE RESURRECTION MEDICAL CENTER 7435 W TALCOTT AVENUE CHICAGO IL 60631 COOK (773) 774-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9884580 -87.8125700 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-pehm~qnk2_vxey 140117 662042 2019-12-02 2019-06-30 186 41         227   47           274
1244 1244 PRESENCE SAINT FRANCIS HOSPITAL 355 RIDGE AVE EVANSTON IL 60202 COOK (847) 316-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0239510 -87.6851590 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-ytv8~95dy~j47j 140080 662040 2019-12-02 2019-06-30 155 16         181               181
1245 1245 PRESENCE SAINT JOSEPH HOSPITAL - CHICAGO 2900 NORTH LAKE SHORE DRIVE CHICAGO IL 60657 COOK (773) 665-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9339280 -87.6364180 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-5jgf-ct8j~vsky 140224 661871 2019-12-02 2019-06-30 258 19         277   10   26       313
1246 1246 PRESENCE SAINTS MARY AND ELIZABETH MEDICAL CENTER 2233 W DIVISION ST CHICAGO IL 60622 COOK (312) 770-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9031040 -87.6832130 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-zjn9~e8qn.h99n 140180 661868 2019-12-02 2019-06-30 344 26         370 14 15   30       429
1258 1258 MT SINAI HOSPITAL MEDICAL CENTER 15TH STREET AT CALIFORNIA CHICAGO IL 60608 COOK (773) 542-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8612424 -87.6940679 1 ROOFTOP 31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-wcea_tcc2-qg4n 140018 661489 2019-12-02 2019-06-30 182 17 12       236 28             264

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