hospital_data

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

4,766 rows sorted by filed_date descending

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_ownership, geocode_flag, geocode_accuracy, subprovider_oth_beds, filed_date (date), fy_end_date (date)

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
1435 1435 ST MARK'S HOSPITAL 1200 EAST 3900 SOUTH SALT LAKE CITY UT 84124 SALT LAKE (801) 268-7700 Acute Care Hospitals Proprietary TRUE 40.6870620 -111.8574460 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-svew-g43x_f7xn 460047 662450 2019-12-24 2019-06-30 183 18       32 233 16 14           263
181 181 ANNE ARUNDEL MEDICAL CENTER 2001 MEDICAL PARKWAY ANNAPOLIS MD 21401 ANNE ARUNDEL (443) 481-1307 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.9911150 -76.5360580 0   3 24 24003 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Anne Arundel County https://data.medicare.gov/resource/xubh-q36u/row-npuw_t7wm.mrix 210023 662537 2019-12-23 2019-06-30 329 20       30 379               379
1234 1234 LOYOLA UNIVERSITY MEDICAL CENTER 2160 S 1ST AVENUE MAYWOOD IL 60153 COOK (708) 216-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8587320 -87.8332100 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-tjbj~st8y~aaxx 140276 662522 2019-12-23 2019-06-30 345 76   10   50 515               515
1829 1829 SURPRISE VALLEY COMMUNITY HOSPITAL 741 NORTH MAIN STREET CEDARVILLE CA 96104 MODOC (530) 279-6111 Critical Access Hospitals Government - Local TRUE 41.5319310 -120.1718990 0   49 6 6049         https://data.medicare.gov/resource/xubh-q36u/row-cdww_rq6r_6v4q 51308 662485 2019-12-23 2019-06-30 4           4       22       26
2237 2237 PROFESSIONAL HOSPITAL GUAYNABO INC AVE LAS CUMBRES ST 199KM 1 2 ALT DE SANTA PR 969 GUAYNABO (787) 708-6560 Acute Care Hospitals Proprietary TRUE 18.3582970 -66.0726073 1 GEOMETRIC_CENTER 61 72 72061 41980 San Juan-Carolina, PR Central Guaynabo Municipio https://data.medicare.gov/resource/xubh-q36u/row-fwuh~bawf.93i3 400122 662581 2019-12-23 2019-06-30 49           49               49
3624 3624 ASPIRUS MEDFORD HOSPITAL & CLINICS, INC 135 S GIBSON ST MEDFORD WI 54451 TAYLOR (715) 748-8100 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.1358340 -90.3540120 0   119 55 55119         https://data.medicare.gov/resource/xubh-q36u/row-8cup-n67n_55ac 521324 662627 2019-12-23 2019-06-30 25           25       78   10   113
4408 4408 HOUSTON METHODIST SAN JACINTO HOSPITAL 4401 GARTH ROAD BAYTOWN TX 77521 HARRIS (281) 420-8600 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7687100 -94.9775480 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-bdxd~39mv.tdkf 450424 662440 2019-12-23 2018-12-31 166 24         190   28           218
4502 4502 PAMPA REGIONAL MEDICAL CENTER 1 MEDICAL PLAZA PAMPA TX 79065 GRAY (806) 665-3721 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.6569910 -101.4079640 0   233 48 48233 14420 Amarillo-Borger, TX Central Hutchinson County https://data.medicare.gov/resource/xubh-q36u/row-vnbp-jjs8.azu9 450099 662430 2019-12-23 2018-12-31 89 8         97 13             110
2200 2200 HARLEM HOSPITAL CENTER 506 LENOX AVENUE NEW YORK NY 10037 NEW YORK (212) 939-1000 Acute Care Hospitals Government - Local TRUE 40.8144820 -73.9404950 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-ghrr_yxuq.x5j3 330240 662232 2019-12-20 2019-06-30 190 17 6 3   15 231 51             282
2201 2201 BELLEVUE HOSPITAL CENTER 462 FIRST AVENUE NEW YORK NY 10016 NEW YORK (212) 562-4141 Acute Care Hospitals Government - Local TRUE 40.7400790 -73.9762500 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-9bwr~dxtd~5pcz 330204 662231 2019-12-20 2019-06-30 445 45 12     25 527 339 46           912
284 284 GREATER BALTIMORE MEDICAL CENTER 6701 NORTH CHARLES STREET BALTIMORE MD 21204 BALTIMORE (443) 849-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.3934970 -76.6280920 0   5 24 24005 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore County https://data.medicare.gov/resource/xubh-q36u/row-4btm~jag6-ezax 210044 662383 2019-12-19 2019-06-30 215 24       30 269       27       296
1231 1231 THE UNIVERSITY OF CHICAGO MEDICAL CENTER 5841 SOUTH MARYLAND CHICAGO IL 60637 COOK (773) 702-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7879560 -87.6049250 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-i6p4_vxuh-wg5y 140088 662041 2019-12-19 2019-06-30 505 79 37 8   53 682               682
1750 1750 ATRIUM HEALTH KINGS MOUNTAIN 706 W KING ST KINGS MOUNTAIN NC 28086 CLEVELAND (704) 739-3601 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2408710 -81.3560170 0   45 37 37045 43140 Charlotte-Concord, NC-SC Central Cleveland County https://data.medicare.gov/resource/xubh-q36u/row-rr2n-is99-qi78 340037 661762 2019-12-19 2019-08-01 45 6         51 11             62
2026 2026 HIGHLAND HOSPITAL 1000 SOUTH AVENUE ROCHESTER NY 14620 MONROE (585) 341-6736 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1359550 -77.6075560 0   55 36 36055 40380 Rochester-Batavia-Seneca Falls, NY Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-6xdj-ttpc-jfna 330164 662130 2019-12-19 2019-06-30 221 14         235               235
4392 4392 CHILLICOTHE HOSPITAL DISTRICT 303 AVENUE I CHILLICOTHE TX 79225 HARDEMAN (940) 852-5131 Critical Access Hospitals Government - Hospital District or Authority TRUE 34.2552390 -99.5159870 0   197 48 48197         https://data.medicare.gov/resource/xubh-q36u/row-za2j_kn4r_u56a 451326 662273 2019-12-19 2019-07-22 21           21               21
4415 4415 HCA HOUSTON HEALTHCARE CLEAR LAKE 500 MEDICAL CENTER BLVD WEBSTER TX 77598 HARRIS (281) 332-2511 Acute Care Hospitals Proprietary TRUE 29.5410620 -95.1262740 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-yjyj_jp52-vmf5 450617 662265 2019-12-19 2018-12-31 446 86         532 5 41           578
4700 4700 BAYLOR SCOTT & WHITE EMERGENCY MEDICAL CENTER AT C 900 EAST WHITESTONE BLVD CEDAR PARK TX 78613 WILLIAMSON (512) 684-4911 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.5239510 -97.8201770 0   491 48 48491 12420   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-7m75.eizi~hrs5 670087 662636 2019-12-19 2019-06-30 8           8               8
113 113 ST PETER'S HOSPITAL 315 SOUTH MANNING BOULEVARD ALBANY NY 12208 ALBANY (518) 525-1550 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6601760 -73.8023820 0   1 36 36001 10580 Albany-Schenectady, NY Central Albany County https://data.medicare.gov/resource/xubh-q36u/row-sq59.k3z9-zynf 330057 662055 2019-12-18 2019-06-30 445   22     15 482               482
335 335 CIBOLA GENERAL HOSPITAL 1016 E ROOSEVELT AVENUE GRANTS NM 87020 CIBOLA (505) 287-5300 Critical Access Hospitals Government - Local TRUE 35.1611680 -107.8265740 0   6 35 35006 24380 Albuquerque-Santa Fe-Las Vegas, NM Central Cibola County https://data.medicare.gov/resource/xubh-q36u/row-ap2g_auck_pm67 321308 662228 2019-12-18 2019-06-30 21 4         25               25
2209 2209 METROPOLITAN HOSPITAL CENTER 1901 FIRST AVENUE NEW YORK NY 10029 NEW YORK (212) 423-6262 Acute Care Hospitals Government - Local TRUE 40.7847200 -73.9436360 0   61 36 36061 35620 New York-Newark, NY-NJ-CT-PA Central New York County https://data.medicare.gov/resource/xubh-q36u/row-qux6~jv33~mbyj 330199 662131 2019-12-18 2019-06-30 158 24       14 196 122 20           338
2400 2400 FLEMING COUNTY HOSPITAL 55 FOUNDATION DRIVE FLEMINGSBURG KY 41041 FLEMING (606) 849-2351 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.4215390 -83.7530940 0   69 21 21069         https://data.medicare.gov/resource/xubh-q36u/row-xzgt-vj27~vpzh 180053 662527 2019-12-18 2019-07-31 49 3         52               52
3612 3612 CAROLINAS MEDICAL CENTER/BEHAV HEALTH 1000 BLYTHE BLVD CHARLOTTE NC 28203 MECKLENBURG (704) 355-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.2049830 -80.8398450 0   119 37 37119 16740 Charlotte-Concord, NC-SC Central Mecklenburg County https://data.medicare.gov/resource/xubh-q36u/row-tjng_gucu-k2vq 340113 661769 2019-12-18 2018-12-31 768 49 20       1112 132 13           1257
847 847 GUADALUPE COUNTY HOSPITAL 117 CAMINO DE VIDA, SUITE 100 SANTA ROSA NM 88435 GUADALUPE (575) 472-3417 Acute Care Hospitals Government - Local TRUE 34.9295040 -104.6942240 0   19 35 35019         https://data.medicare.gov/resource/xubh-q36u/row-es4t_p7gk_ag72 320067 661934 2019-12-17 2019-06-30 10           10               10
1616 1616 DECATUR COUNTY GENERAL HOSPITAL 969 TENNESSEE AVE S PARSONS TN 38363 DECATUR (731) 847-3031 Acute Care Hospitals Government - Local TRUE 35.6357130 -88.1231700 0   39 47 47039         https://data.medicare.gov/resource/xubh-q36u/row-x2m3-qfn9_55w9 440070 661811 2019-12-17 2019-06-30 40           40               40
3067 3067 EASTON HOSPITAL 250 SOUTH 21ST STREET EASTON PA 18042 NORTHAMPTON (610) 250-4076 Acute Care Hospitals Proprietary TRUE 40.6865180 -75.2428970 0   95 42 42095 10900 New York-Newark, NY-NJ-CT-PA Central Northampton County https://data.medicare.gov/resource/xubh-q36u/row-4ff4.q82n-bet5 390162 661636 2019-12-17 2019-06-30 134 24 6       164 16 10           190
929 929 BAYLOR SCOTT & WHITE MEDICAL CENTER - MARBLE FALLS 810 W HIGHWAY 71 MARBLE FALLS TX 78654 BURNET (830) 201-7308 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.1107400 -97.3593810 0   21 48 48021 12420   Outlying Bastrop County https://data.medicare.gov/resource/xubh-q36u/row-jqmz_geif_6mxi 670108 661842 2019-12-16 2019-05-31 38 8         46               46
3478 3478 HIGHLANDS CASHIERS HOSPITAL 190 HOSPITAL DRIVE HIGHLANDS NC 28741 MACON (828) 526-1200 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0856520 -83.1861100 0   113 37 37113         https://data.medicare.gov/resource/xubh-q36u/row-sjsc-r5is_zgk4 341316 661372 2019-12-16 2019-01-31 24           24               24
1931 1931 CONWAY MEDICAL CENTER 300 SINGLETON RIDGE ROAD CONWAY SC 29526 HORRY (843) 347-8037 Acute Care Hospitals Voluntary non-profit - Private TRUE 33.7865240 -79.0028540 0   51 45 45051 34820 Myrtle Beach-Conway, SC-NC Central Horry County https://data.medicare.gov/resource/xubh-q36u/row-a4f9-a2ra~cinu 420049 661401 2019-12-13 2019-09-30 146 20         166               166
2030 2030 STRONG MEMORIAL HOSPITAL 601 ELMWOOD AVE ROCHESTER NY 14642 MONROE (585) 275-2121 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1243940 -77.6236920 0   55 36 36055 40380 Rochester-Batavia-Seneca Falls, NY Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-zbcm_2wiq-86av 330285 661571 2019-12-13 2019-06-30 512 110   17   68 739 93 20           852
3850 3850 NORTHSIDE HOSPITAL GWINNETT 1000 MEDICAL CENTER BOULEVARD LAWRENCEVILLE GA 30045 GWINNETT (678) 312-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.9664550 -84.0130120 0   135 13 13135 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Gwinnett County https://data.medicare.gov/resource/xubh-q36u/row-s7r7-ja6f~94m5 110087 661711 2019-12-13 2019-08-27 367 46       24 437   30   89       556
1633 1633 MCGEHEE HOSPITAL 900 SOUTH THIRD STREET MCGEHEE AR 71654 DESHA (870) 222-5600 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6182850 -91.3930660 0   41 5 5041         https://data.medicare.gov/resource/xubh-q36u/row-nhnf~w2ph~7zeh 41308 662151 2019-12-12 2019-06-30 25           25               25
2020 2020 CHI HEALTH IMMANUEL 6901 NORTH 72ND ST OMAHA NE 68122 DOUGLAS (402) 572-2121 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3218390 -96.0237880 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-asr9_pruj_9z6w 280081 662399 2019-12-12 2019-06-30 153 24         177 20 35       20   252
2648 2648 KALKASKA MEMORIAL HEALTH CENTER 419 S CORAL KALKASKA MI 49646 KALKASKA (231) 258-7500 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7308970 -85.1838370 0   79 26 26079 45900   Outlying Kalkaska County https://data.medicare.gov/resource/xubh-q36u/row-xxgj-5p26_g3uf 231301 662385 2019-12-12 2019-06-30 8           8       102       110
2746 2746 HANSEN FAMILY HOSPITAL 920 SOUTH OAK STREET IOWA FALLS IA 50126 HARDIN (641) 648-4631 Critical Access Hospitals Government - Local TRUE 42.5009390 -93.2623940 0   83 19 19083         https://data.medicare.gov/resource/xubh-q36u/row-ress-cfb5~zt7b 161380 661184 2019-12-12 2019-06-30 19           19               19
4727 4727 SSM HEALTH SAINT LOUIS UNIVERSITY HOSPITAL 3635 VISTA AVE SAINT LOUIS MO 63110 ST. LOUIS CITY (314) 577-8000 Acute Care Hospitals Proprietary TRUE 38.6224590 -90.2390520 0   510 29 29510 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis city https://data.medicare.gov/resource/xubh-q36u/row-d5kj_nm3c-tjii 260105 662395 2019-12-12 2018-12-31 209 79         288 39             327
860 860 BON SECOURS-ST FRANCIS XAVIER HOSPITAL 2095 HENRY TECKLENBURG DRIVE CHARLESTON SC 29414 CHARLESTON (843) 402-1006 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.8107510 -80.0422640 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-iqvc_hqaf-hi8f 420065 661648 2019-12-11 2018-12-31 178 11         189               189
1962 1962 PHILLIPS EYE INSTITUTE 2215 PARK AVENUE SOUTH MINNEAPOLIS MN 55404 HENNEPIN (612) 775-8751 Acute Care Hospitals Government - Federal FALSE 44.9604780 -93.2651060 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-6egw_a4dk~jkf6 240196 662388 2019-12-11 2019-07-31 8           8               8
2817 2817 METHODIST MCKINNEY HOSPITAL 8000 W ELDORADO PKWY BLDG C SUITE C MCKINNEY TX 75070 COLLIN (214) 491-5710 Acute Care Hospitals Proprietary TRUE 33.1758090 -96.7243430 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-mnxi-9kbn.uk2u 670069 661131 2019-12-11 2019-07-31 23           23               23
3936 3936 ASPIRUS RIVERVIEW HOSPITAL & CLINICS INC 410 DEWEY ST WISCONSIN RAPIDS WI 54495 WOOD (715) 423-6060 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.3821990 -89.8295440 0   141 55 55141 49220 Wausau-Stevens Point-Wisconsin Rapids, WI Central Wood County https://data.medicare.gov/resource/xubh-q36u/row-yakd~caj8~y7vv 520033 661271 2019-12-11 2019-06-30 41 4         45               45
3948 3948 OSCEOLA COMMUNITY HOSPITAL 600 9TH AVENUE NORTH SIBLEY IA 51249 OSCEOLA (712) 754-2574 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4100800 -95.7417270 0   143 19 19143         https://data.medicare.gov/resource/xubh-q36u/row-hz68_ij6c-5gfy 161345 662118 2019-12-11 2019-06-30 25           25               25
4177 4177 PIKE COUNTY MEMORIAL HOSPITAL 2305 WEST GEORGIA STREET LOUISIANA MO 63353 PIKE (573) 754-5531 Critical Access Hospitals Government - Local TRUE 39.4416790 -91.0653830 0   163 29 29163         https://data.medicare.gov/resource/xubh-q36u/row-yh6k-r823.ddji 261333 662398 2019-12-11 2019-06-30 25           25               25
4416 4416 HCA HOUSTON HEALTHCARE WEST 12141 RICHMOND AVE HOUSTON TX 77082 HARRIS (281) 588-8080 Acute Care Hospitals Proprietary TRUE 29.7303140 -95.5947500 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dji8~3wmy~qmrn 450644 661665 2019-12-11 2018-12-31 202 28         230 14 12           256
4556 4556 MEMORIAL SATILLA HEALTH 1900 TEBEAU STREET WAYCROSS GA 31501 WARE (912) 287-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.2260070 -82.3492390 0   299 13 13299 48180   Central Ware County https://data.medicare.gov/resource/xubh-q36u/row-ap45-skje_jjhu 110003 661303 2019-12-10 2018-12-31 106 10 12     6 134 15 10           159
435 435 AVOYELLES HOSPITAL 4231 HIGHWAY 1192 MARKSVILLE LA 71351 AVOYELLES (318) 253-8611 Acute Care Hospitals Proprietary TRUE 31.1431270 -92.0644330 0   9 22 22009         https://data.medicare.gov/resource/xubh-q36u/row-yf6k.hf5w.97ar 190099 661332 2019-12-09 2019-06-30 47 2         49               49
693 693 BIG SANDY MEDICAL CENTER 166 MONTANA AVE E BIG SANDY MT 59520 CHOUTEAU (406) 378-2188 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1790800 -110.1082170 0   15 30 30015         https://data.medicare.gov/resource/xubh-q36u/row-9nm3.ugyv-geii 271311 661032 2019-12-09 2019-06-30 8           8       22       30
874 874 ALASKA REGIONAL HOSPITAL 2801 DEBARR ROAD ANCHORAGE AK 99508 ANCHORAGE (907) 276-1131 Acute Care Hospitals Proprietary TRUE 61.2097900 -149.8273790 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-727e.rn52.9kni 20017 662304 2019-12-09 2018-12-31 127 14 13       164   10           174
2074 2074 ST JOSEPHS AREA HEALTH SERVICES 600 PLEASANT AVENUE PARK RAPIDS MN 56470 HUBBARD (218) 732-3311 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.9157000 -95.0615040 0   57 27 27057         https://data.medicare.gov/resource/xubh-q36u/row-486s_44m7-qhbs 241380 662390 2019-12-09 2019-06-30 25           25               25
3259 3259 EFFINGHAM HEALTH SYSTEM 459 GA HIGHWAY 119 SOUTH SPRINGFIELD GA 31329 EFFINGHAM (912) 754-0160 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.3647340 -81.3216640 0   103 13 13103 42340 Savannah-Hinesville-Statesboro, GA Outlying Effingham County https://data.medicare.gov/resource/xubh-q36u/row-z7sk_s77h.2zrg 111306 661153 2019-12-09 2019-06-30 25           25       105       130
3481 3481 SYCAMORE MEDICAL CENTER 4000 MIAMISBURG-CENTERVILLE ROAD MIAMISBURG OH 45342 MONTGOMERY (937) 384-8776 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.6398200 -84.2512600 0   113 39 39113 19380 Dayton-Springfield-Sidney, OH Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-q9y2-ej79-7yp6 360239 662571 2019-12-09 2018-12-31 156 12         168               168
3483 3483 KETTERING MEDICAL CENTER 3535 SOUTHERN BOULEVARD KETTERING OH 45429 MONTGOMERY (937) 395-8165 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.6956030 -84.1909930 0   113 39 39113 19380 Dayton-Springfield-Sidney, OH Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-nep3.488k.vkyf 360079 662570 2019-12-09 2018-12-31 306 12 12   12 10 377   33           410
4481 4481 NEVADA REGIONAL MEDICAL CENTER 800 S ASH ST NEVADA MO 64772 VERNON (417) 667-3355 Acute Care Hospitals Government - Local TRUE 37.8305340 -94.3597030 0   217 29 29217         https://data.medicare.gov/resource/xubh-q36u/row-jdp9.qgha.atw3 260061 662127 2019-12-09 2019-06-30 35 6         41 30             71
972 972 GUTHRIE CORTLAND REGIONAL MEDICAL CENTER 134 HOMER AVENUE CORTLAND NY 13045 CORTLAND (607) 756-3501 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6089970 -76.1861170 0   23 36 36023 18660 Ithaca-Cortland, NY Central Cortland County https://data.medicare.gov/resource/xubh-q36u/row-br3w~352e~gb7g 330175 661938 2019-12-06 2019-06-30 91 12         103 11     80       194
1335 1335 MEDSTAR SOUTHERN MARYLAND HOSPITAL CENTER 7503 SURRATTS ROAD CLINTON MD 20735 PRINCE GEORGES (301) 868-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7502500 -76.8749970 0   33 24 24033 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Prince George's County https://data.medicare.gov/resource/xubh-q36u/row-gmdn~2hr7-2ni6 210062 661528 2019-12-06 2019-06-30 158 18         176               176
1900 1900 HAYS MEDICAL CENTER 2220 CANTERBURY DRIVE HAYS KS 67601 ELLIS (785) 623-5000 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.8796040 -99.2992730 0   51 20 20051 25700   Central Ellis County https://data.medicare.gov/resource/xubh-q36u/row-p3vh.37wj~25bf 170013 662378 2019-12-06 2019-06-30 115 34         149               149
1957 1957 CHILDREN'S HOSPITALS & CLINICS OF MN 2525 CHICAGO AVENUE SOUTH MINNEAPOLIS MN 55404 HENNEPIN (612) 813-6112 Childrens Voluntary non-profit - Private TRUE 44.9562370 -93.2625880 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-zsi6-wyrh~wxd5 243302 662539 2019-12-06 2018-12-31 151 42 25     196 414               414
2261 2261 IZARD COUNTY MEDICAL CENTER, LLC 61 GRASSE STREET CALICO ROCK AR 72519 BAXTER (870) 297-2400 Critical Access Hospitals Proprietary TRUE 36.1263360 -92.1285870 0   65 5 5065         https://data.medicare.gov/resource/xubh-q36u/row-nm2c~hstr_uanu 41306 662150 2019-12-06 2019-06-30 25           25               25
2358 2358 CARRIS HEALTH LLC 301 BECKER AVE SW WILLMAR MN 56201 KANDIYOHI (320) 235-4543 Acute Care Hospitals Government - Local TRUE 45.1205140 -95.0463660 0   67 27 27067 48820   Central Kandiyohi County https://data.medicare.gov/resource/xubh-q36u/row-ypur_bzw7_kp3d 240088 661914 2019-12-06 2019-06-30 73 8         81       78       159
3319 3319 FRANCES MAHON DEACONESS HOSPITAL 621 3RD ST S GLASGOW MT 59230 VALLEY (406) 228-3500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1895710 -106.6363790 0   105 30 30105         https://data.medicare.gov/resource/xubh-q36u/row-h3fb.ey2c_fvhr 271316 661033 2019-12-06 2019-06-30 25           25               25
3320 3320 KIMBALL HEALTH SERVICES 505 SOUTH BURG ST KIMBALL NE 69145 KIMBALL (308) 235-1951 Critical Access Hospitals Government - Local TRUE 41.2324380 -103.6672040 0   105 31 31105         https://data.medicare.gov/resource/xubh-q36u/row-3qnf.krtg-ks6w 281305 662400 2019-12-06 2019-06-30 15           15               15
3329 3329 MERCY HEALTH SYSTEM CORP 1000 MINERAL POINT AVE JANESVILLE WI 53548 ROCK (608) 756-6080 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6867440 -89.0327250 0   105 55 55105 27500 Madison-Janesville-Beloit, WI Central Rock County https://data.medicare.gov/resource/xubh-q36u/row-emwb_jdut_5tu2 520066 662626 2019-12-06 2019-06-30 181 15         196   14   27       237
3424 3424 MERCY HARVARD HOSPITAL 901 S GRANT STREET HARVARD IL 60033 MC HENRY (815) 943-5431 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.4259920 -88.6077480 0   111 17 17111 16980 Chicago-Naperville, IL-IN-WI Central McHenry County https://data.medicare.gov/resource/xubh-q36u/row-kww9-q8j9_zquu 141335 661880 2019-12-06 2019-06-30 10 3         13       15   30   58
3762 3762 MERCY WALWORTH HOSPITAL & MEDICAL CENTER N2950 STATE ROAD 67 LAKE GENEVA WI 53147 WALWORTH (262) 245-0535 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.5978230 -88.5409190 0   127 55 55127 48580 Milwaukee-Racine-Waukesha, WI Central Walworth County https://data.medicare.gov/resource/xubh-q36u/row-8g5d-jph6-c83n 521357 662455 2019-12-06 2019-06-30 21 4         25               25
3875 3875 ESSENTIA HEALTH DULUTH 502 EAST SECOND STREET DULUTH MN 55805 ST. LOUIS (218) 786-2806 Acute Care Hospitals Voluntary non-profit - Private FALSE 46.7930740 -92.0941550 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-92s6-csy7_b973 240019 660603 2019-12-06 2019-06-30 95 8         103   36           139
3973 3973 PAWNEE VALLEY COMMUNITY HOSPITAL 923 CARROLL AVENUE LARNED KS 67550 PAWNEE (620) 285-3162 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.1841610 -99.1065960 0   145 20 20145         https://data.medicare.gov/resource/xubh-q36u/row-si98~suze_dh6c 171345 662379 2019-12-06 2019-06-30 22           22               22
4284 4284 HOPEDALE HOSPITAL 107 TREMONT STREET HOPEDALE IL 61747 TAZEWELL (309) 449-4296 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.4183830 -89.4177290 0   179 17 17179 37900 Peoria-Canton, IL Central Tazewell County https://data.medicare.gov/resource/xubh-q36u/row-xd8s-ubf6_48ka 141330 661879 2019-12-06 2019-06-30 25           25         59 72   156
43 43 DEWITT HOSPITAL & NURSING HOME, INC 1641 WHITEHEAD DRIVE DE WITT AR 72042 ARKANSAS (870) 946-3571 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2795980 -91.3368920 0   1 5 5001         https://data.medicare.gov/resource/xubh-q36u/row-m6cy.wkj8_xepc 41314 660746 2019-12-05 2019-06-30 25           25       60       85
91 91 ACADIA ST LANDRY 810 SOUTH BROADWAY STREET CHURCH POINT LA 70525 ACADIA (337) 684-5435 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.3950170 -92.2118330 0   1 22 22001 29180 Lafayette-Opelousas-Morgan City, LA Outlying Acadia Parish https://data.medicare.gov/resource/xubh-q36u/row-mqb2~y9xg-useh 191319 661189 2019-12-05 2019-06-30 15           15 10             25
472 472 ST VINCENT HOSPITAL 835 S VAN BUREN ST GREEN BAY WI 54301 BROWN (920) 433-0111 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.5010390 -88.0131750 0   9 55 55009 24580 Green Bay-Shawano, WI Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-pxgu.dxxy~hc8w 520075 660732 2019-12-05 2019-06-30 171 24 4     24 223   32           255
939 939 HOSPITAL UNIVERSITARIO DR RUIZ ARNAU LAUREL AVE SANTA JUANITA #100 BAYAMON PR 956 BAYAMON (787) 787-5151 Acute Care Hospitals Government - State TRUE 18.3672680 -66.1538110 1 ROOFTOP 21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-ea8w~5nt3-7vuk 400105 661647 2019-12-05 2019-06-30 102           102               102
1135 1135 SARAH BUSH LINCOLN HEALTH CENTER 1000 HEALTH CENTER DRIVE P O BOX 372 MATTOON IL 61938 COLES (217) 258-2572 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4885430 -88.2757930 0   29 17 17029 16660   Central Coles County https://data.medicare.gov/resource/xubh-q36u/row-dixe-u46h~kure 140189 661869 2019-12-05 2019-06-30 73   9       82 20             102
1218 1218 UNIVERSITY OF ILLINOIS HOSPITAL 1740 WEST TAYLOR ST SUITE 1400 CHICAGO IL 60612 COOK (312) 996-3900 Acute Care Hospitals Government - State TRUE 41.8692240 -87.6705290 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-npx2_ggxf-iku6 140150 662044 2019-12-05 2019-06-30 303 42 19       434 50             484
2225 2225 PENN HIGHLANDS HUNTINDON 1225 WARM SPRINGS AVE HUNTINGDON PA 16652 HUNTINGDON (814) 643-2290 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.4936560 -78.0139080 0   61 42 42061 26500   Central Huntingdon County https://data.medicare.gov/resource/xubh-q36u/row-c6x4.48gy-gw6j 390056 660854 2019-12-05 2019-06-30 50 7         57 14             71
2252 2252 SCHEURER HOSPITAL 170 N CASEVILLE RD PIGEON MI 48755 HURON (989) 453-3223 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.8343290 -83.2795170 0   63 26 26063         https://data.medicare.gov/resource/xubh-q36u/row-9fq3.fww9-p7j9 231310 662386 2019-12-05 2019-06-30 25           25           19   44
2318 2318 HARDIN MEMORIAL HOSPITAL 921 EAST FRANKLIN STREET KENTON OH 43326 HARDIN (419) 673-0761 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.6455780 -83.5956960 0   65 39 39065         https://data.medicare.gov/resource/xubh-q36u/row-sdrq_nbhy_ykmu 361315 661616 2019-12-05 2019-06-30 25           25               25
2837 2837 DOUGLAS GARDENS HOSPITAL 5200 NE 2ND AVE MIAMI FL 33137 MIAMI-DADE (305) 751-8626 Acute Care Hospitals Voluntary non-profit - Private FALSE 25.8229720 -80.1917670 0   86 12 12086 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Miami-Dade County https://data.medicare.gov/resource/xubh-q36u/row-kf87_pfp3.y73g 100277 661484 2019-12-05 2019-06-30 32           32       422       454
2855 2855 HENRY COUNTY HEALTH CENTER 407 S WHITE ST MOUNT PLEASANT IA 52641 HENRY (319) 385-3141 Critical Access Hospitals Government - Local TRUE 40.9631160 -91.5580180 0   87 19 19087         https://data.medicare.gov/resource/xubh-q36u/row-vzbh~3fhi_gk69 161356 662119 2019-12-05 2019-06-30 25           25       74       99
2928 2928 RICE MEDICAL CENTER 600 SOUTH AUSTIN ROAD EAGLE LAKE TX 77434 COLORADO (979) 234-5571 Critical Access Hospitals Proprietary TRUE 29.5880660 -96.3459410 0   89 48 48089         https://data.medicare.gov/resource/xubh-q36u/row-vnik-sqe7~5xri 451312 661825 2019-12-05 2018-12-31 21           21               21
3344 3344 KEOKUK COUNTY HEALTH CENTER 23019 HIGHWAY 149 SIGOURNEY IA 52591 KEOKUK (641) 622-2720 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.3224890 -92.2051250 0   107 19 19107         https://data.medicare.gov/resource/xubh-q36u/row-ngbw_3emk~czhr 161315 662116 2019-12-05 2019-06-30 25           25               25
3779 3779 HOSPITAL ONCOLOGICO DR ISAAC GONZALEZ MARTINEZ BO. MONACILLOS CARR 22 CENTRO MEDICO DE PUERTO RIC SAN JUAN PR 935 SAN JUAN (787) 763-4149 Acute Care Hospitals Voluntary non-profit - Private FALSE 18.3958646 -66.0736306 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-y9yb.2qds_r9bm 400012 661645 2019-12-05 2019-06-30 52 5         57               57
3931 3931 EL PASO LTAC HOSPTIAL 1221 N COTTON ST 3RD FLOOR EL PASO TX 79902 EL PASO (915) 496-9687 Acute Care Hospitals Physician FALSE 31.7836990 -106.4735520 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-wqm3_d2vk.as9x 670127 661274 2019-12-05 2019-06-30 33           33               33
4145 4145 GORDON MEMORIAL HOSPITAL DISTRICT 300 EAST 8TH ST GORDON NE 69343 SHERIDAN (308) 282-0401 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.8118390 -102.1996530 0   161 31 31161         https://data.medicare.gov/resource/xubh-q36u/row-4riz_taj9.4fxw 281358 662402 2019-12-05 2019-06-30 25           25           32   57
4362 4362 FAIRFIELD MEMORIAL HOSPITAL 1 303 N W 11TH STREET FAIRFIELD IL 62837 WAYNE (618) 842-2611 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.3816370 -88.3744220 0   191 17 17191         https://data.medicare.gov/resource/xubh-q36u/row-5p2e-22wu-qqf8 141311 662109 2019-12-05 2019-06-30 21 4         25       30       55
4363 4363 WINNESHIEK MEDICAL CENTER 901 MONTGOMERY STREET DECORAH IA 52101 WINNESHIEK (563) 382-2911 Critical Access Hospitals Government - Local TRUE 43.2946340 -91.7711870 0   191 19 19191         https://data.medicare.gov/resource/xubh-q36u/row-iatu_f8zn~qk5r 161371 662377 2019-12-05 2019-06-30 25           25               25
4501 4501 GOLDEN PLAINS COMMUNITY HOSPITAL 100 MEDICAL DRIVE BORGER TX 79007 HUTCHINSON (806) 273-1100 Critical Access Hospitals Proprietary TRUE 35.6538340 -101.4090410 0   233 48 48233 14420 Amarillo-Borger, TX Central Hutchinson County https://data.medicare.gov/resource/xubh-q36u/row-rtyt.xqrr~9rdj 451369 660153 2019-12-05 2018-12-31 21 4         25               25
37 37 PRATTVILLE BAPTIST HOSPITAL 124 S MEMORIAL DR PRATTVILLE AL 36067 AUTAUGA (334) 361-4267 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.4644230 -86.4509360 0   1 1 1001 33860   Central Autauga County https://data.medicare.gov/resource/xubh-q36u/row-62jx-izkm-znx2 10108 660906 2019-12-04 2019-06-30 49 6         55               55
341 341 MERCY HOSPITAL NORTHWEST ARKANSAS 2710 SOUTH RIFE MEDICAL LANE ROGERS AR 72758 BENTON (479) 338-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.3095620 -94.1847090 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-3g3b-cs9n_qbhj 40010 660742 2019-12-04 2019-06-30 174 24         206               206
490 490 PLANTATION GENERAL HOSPITAL 401 NW 42ND AVE PLANTATION FL 33317 BROWARD (954) 587-5010 Acute Care Hospitals Voluntary non-profit - Private TRUE 26.1264610 -80.2041700 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-k3qn_68yj.yfxn 100167 661481 2019-12-04 2018-08-31 477 61       37 589 56 15           660
498 498 HABERSHAM COUNTY MEDICAL CTR 541 HISTORIC HIGHWAY 441-NORTH DEMOREST GA 30535 HABERSHAM (706) 754-2161 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.4058790 -83.4859890 0   11 13 13011         https://data.medicare.gov/resource/xubh-q36u/row-vwu4-xgbr~5v33 110041 660923 2019-12-04 2019-06-30 49 4         53       84       137
672 672 MERCY HOSPITAL BERRYVILLE 214 CARTER STREET BERRYVILLE AR 72616 CARROLL (870) 423-3355 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.3582250 -93.5519930 0   15 5 5015         https://data.medicare.gov/resource/xubh-q36u/row-dj6g_rn37~rqpp 41329 659917 2019-12-04 2019-06-30 25           25               25
841 841 DANIELS MEMORIAL HOSPITAL 105 5TH AVE E SCOBEY MT 59263 DANIELS (406) 487-2296 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.7886240 -105.4185870 0   19 30 30019         https://data.medicare.gov/resource/xubh-q36u/row-xufw-inrb~p3dx 271342 662053 2019-12-04 2019-06-30 25           25               25
911 911 MOSAIC LIFE CARE AT ST JOSEPH 5325 FARAON STREET SAINT JOSEPH MO 64506 BUCHANAN (816) 271-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7702010 -94.7702470 0   21 29 29021 41140 Kansas City-Overland Park-Kansas City, MO-KS Central Buchanan County https://data.medicare.gov/resource/xubh-q36u/row-3zkc_waie.mgmy 260006 661920 2019-12-04 2019-06-30 331 21         352               352
985 985 GRANT MEMORIAL HOSPITAL 117 HOSPITAL DRIVE PETERSBURG WV 26847 GRANT (304) 257-1026 Critical Access Hospitals Voluntary non-profit - Other TRUE 39.0018410 -79.1379850 0   23 54 54023         https://data.medicare.gov/resource/xubh-q36u/row-czyj.xar4_pg4s 511316 661126 2019-12-04 2019-06-30 22 3         25       20       45
990 990 GROVE HILL MEMORIAL HOSPITAL 295 JACKSON HWY S GROVE HILL AL 36451 CLARKE (251) 275-3191 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.6942130 -87.7772310 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-qwpn-mu4j-e76s 10091 660905 2019-12-04 2019-06-30 21           21 9             30
1071 1071 ST ANTHONY REGIONAL HOSPITAL & NURSING HOME 311 SOUTH CLARK STREET CARROLL IA 51401 CARROLL (712) 792-3581 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0569820 -94.8679810 0   27 19 19027         https://data.medicare.gov/resource/xubh-q36u/row-mmxr_bdg2_23xf 160005 661893 2019-12-04 2019-06-30 43 6         49 14       79     142
1252 1252 WESTLAKE HOSPITAL 1225 LAKE ST MELROSE PARK IL 60160 COOK (708) 938-4000 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.8917940 -87.8489630 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-627u.ykd7_33gx 140240 662200 2019-12-04 2019-01-27 109 12         121 17 20           158
1323 1323 CALDWELL MEDICAL CENTER 100 MEDICAL CENTER DRIVE PRINCETON KY 42445 CALDWELL (270) 365-0300 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.1142150 -87.9076580 0   33 21 21033         https://data.medicare.gov/resource/xubh-q36u/row-8ivi_hkzn.i9ke 181322 661513 2019-12-04 2019-06-30 25           25               25
1342 1342 CARROLL COUNTY MEMORIAL HOSPITAL 1502 NORTH JEFFERSON CARROLLTON MO 64633 CARROLL (660) 542-1695 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3761610 -93.4942180 0   33 29 29033         https://data.medicare.gov/resource/xubh-q36u/row-jxaf~kp9t_wqyd 261332 661925 2019-12-04 2019-06-30 21           21               21
1428 1428 LOCK HAVEN HOSPITAL 24 CREE DRIVE LOCK HAVEN PA 17745 CLINTON (570) 893-5024 Acute Care Hospitals Proprietary TRUE 41.1328120 -77.4701830 0   35 42 42035 30820 Williamsport-Lock Haven, PA Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-i2uu~n4az-hqsg 390071 662135 2019-12-04 2019-06-30 47           47       90       137
1490 1490 CHILDREN'S HOSP OF LOS ANGELES 4650 SUNSET BLVD, MS 108 LOS ANGELES CA 90027 LOS ANGELES (323) 669-2164 Childrens Voluntary non-profit - Private TRUE 34.0981450 -118.2908780 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-unns_mtk9.tbkh 53302 660920 2019-12-04 2019-06-30 273 48         379               379
1630 1630 ST JOHNS MEDICAL CENTER 625 EAST BROADWAY JACKSON WY 83001 TETON (307) 733-3636 Acute Care Hospitals Government - Hospital District or Authority TRUE 43.4796950 -110.7499860 0   39 56 56039 27220   Central Teton County https://data.medicare.gov/resource/xubh-q36u/row-vuqt_cw9d-cjux 530015 662632 2019-12-04 2019-06-30 42 6         48       60       108

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