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 hosp_lookup_url

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, burn_beds, 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
3446 3446 HILLCREST HOSPITAL HENRYETTA 2401 W MAIN HENRYETTA OK 74437 OKMULGEE (918) 650-1511 Acute Care Hospitals Proprietary TRUE 35.4397380 -96.0154960 0   111 40 40111 46140 Tulsa-Muskogee-Bartlesville, OK Outlying Okmulgee County https://data.medicare.gov/resource/xubh-q36u/row-222q_tbcj-2m5z 370183 646973 2019-04-26 2018-11-30 27           27 14             41
2419 2419 ASCENSION GOOD SAMARITAN HOSPITAL 601 S CENTER AVE MERRILL WI 54452 LINCOLN (715) 536-5511 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.1758580 -89.6830310 0   69 55 55069 32980 Wausau-Stevens Point-Wisconsin Rapids, WI Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-22bh-e9v4.hnpp 521339 661687 2019-11-27 2019-06-30 25           25               25
1846 1846 MERIT HEALTH CENTRAL 1850 CHADWICK DR JACKSON MS 39204 HINDS (601) 376-1000 Acute Care Hospitals Proprietary TRUE 32.2869290 -90.2557550 0   49 28 28049 27140 Jackson-Vicksburg-Brookhaven, MS Central Hinds County https://data.medicare.gov/resource/xubh-q36u/row-22cu_evxw_ttrz 250072 644299 2019-02-20 2018-09-30 169 45 13       248 71             319
2053 2053 ADVENTHEALTH CARROLLWOOD 7171 N DALE MABRY HWY TAMPA FL 33614 HILLSBOROUGH (813) 932-2222 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.0131020 -82.5049540 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-22he-y9u8_3jua 100069 649181 2019-05-31 2018-12-31 95 8         103               103
4357 4357 MISSOURI BAPTIST MEDICAL CENTER 3015 N BALLAS RD TOWN AND COUNTRY MO 63131 ST. LOUIS (314) 996-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6355320 -90.4436360 0   189 29 29189 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-22pi-vzza~yq54 260108 661924 2019-12-04 2018-12-31 366 40         406   20           426
1236 1236 ALEXIAN BROTHERS MEDICAL CENTER 1 800 W BIESTERFIELD RD ELK GROVE VILLAGE IL 60007 COOK (847) 437-5500 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0037050 -88.0149960 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-22rs-enea-7d2m 140258 660521 2019-11-27 2019-06-30 221 36         257 25 72       16   370
165 165 LUTHERAN HOSPITAL OF INDIANA 7950 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-7001 Acute Care Hospitals Proprietary TRUE 41.0373740 -85.2458850 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-22sz~6zvg.fbpc 150017 661886 2019-12-03 2019-06-30 254   24       396               396
2777 2777 GOOD SAMARITAN HOSPITAL 2425 SAMARITAN DRIVE SAN JOSE CA 95124 SANTA CLARA (408) 559-2011 Acute Care Hospitals Proprietary TRUE 37.2511040 -121.9465630 0   85 6 6085 41940 San Jose-San Francisco-Oakland, CA Central Santa Clara County https://data.medicare.gov/resource/xubh-q36u/row-22ue_gc2m_q5ju 50380 651600 2019-06-28 2019-01-31 223 24 17       309 18 15           342
4169 4169 BEAUMONT HOSPITAL, GROSSE POINTE 468 CADIEUX RD GROSSE POINTE MI 48230 WAYNE (313) 343-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3841970 -82.9153860 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-23fr~kedq-nuv6 230089 659036 2019-11-06 2019-06-30 249 17         266               266
2540 2540 PONDERA MEDICAL CENTER 805 SUNSET BLVD CONRAD MT 59425 PONDERA (406) 271-3211 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1739170 -111.9586770 0   73 30 30073         https://data.medicare.gov/resource/xubh-q36u/row-23g5-69uu.yhw9 271324 652085 2019-05-30 2018-12-31 20           20       59       79
2759 2759 SAMARITAN HOSPITAL-ST MARY'S CAMPUS 1300 MASSACHUSETTS AVENUE TROY NY 12180 RENSSELAER (518) 268-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.7439770 -73.6764150 0   83 36 36083 10580 Albany-Schenectady, NY Central Rensselaer County https://data.medicare.gov/resource/xubh-q36u/row-23ud-7iuq.i6ww 330232 660842 2019-11-18 2018-06-30 20           20               20
3390 3390 INTEGRIS SOUTHWEST MEDICAL CENTER 4401 SOUTH WESTERN AVENUE OKLAHOMA CITY OK 73109 OKLAHOMA (405) 636-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4225350 -97.5301960 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-23vu-3nyp~546j 370106 659858 2019-11-26 2019-06-30 165 20         185   67           252
322 322 LOGAN REGIONAL HOSPITAL 500 EAST 1400 NORTH LOGAN UT 84341 CACHE (435) 716-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7574610 -111.8228770 0   5 49 49005 30860   Central Cache County https://data.medicare.gov/resource/xubh-q36u/row-248k.jdp3-ibnu 460015 649977 2019-05-31 2018-12-31 83 14       33 130 7     14       151
363 363 BAPTIST MEDICAL CENTER-ATTALA 220 HWY 12 WEST KOSCIUSKO MS 39090 ATTALA (662) 289-4311 Critical Access Hospitals Voluntary non-profit - Other TRUE 33.0655920 -89.5967210 0   7 28 28007         https://data.medicare.gov/resource/xubh-q36u/row-24jy_6div~59c7 251336 644042 2019-03-01 2018-09-30 25           25               25
2706 2706 NORTH MISSISSIPPI MEDICAL CENTER 830 S GLOSTER STREET TUPELO MS 38801 LEE (662) 377-6608 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.2422030 -88.7177580 0   81 28 28081 46180   Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-25aa.vazv.awbj 250004 651337 2019-06-11 2018-09-30 459 24     18 26 527 66 28       10   631
1680 1680 CULLMAN REGIONAL MEDICAL CENTER 1912 ALABAMA HIGHWAY 157 CULLMAN AL 35058 CULLMAN (256) 737-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1985870 -86.8056410 0   43 1 1043 18980 Birmingham-Hoover-Talladega, AL Central Cullman County https://data.medicare.gov/resource/xubh-q36u/row-25az.bw5t.5dxy 10035 659467 2019-11-26 2019-06-30 133 12         145               145
459 459 OHIOHEALTH O'BLENESS HOSPITAL 55 HOSPITAL DRIVE ATHENS OH 45701 ATHENS (740) 593-5551 Acute Care Hospitals Voluntary non-profit - Other TRUE 39.3277410 -82.1141890 0   9 39 39009 11900   Central Athens County https://data.medicare.gov/resource/xubh-q36u/row-25ei.cjhc~kvpd 360014 659834 2019-11-21 2019-06-30 64           64               64
1369 1369 ST FRANCIS COMMUNITY HOSPITAL 34515 9TH AVENUE SOUTH FEDERAL WAY WA 98003 KING (253) 944-8100 Acute Care Hospitals Voluntary non-profit - Church TRUE 47.2921060 -122.3229510 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-26c7~6xv9.c5tp 500141 662625 2019-11-27 2019-06-30 110 14         124               124
4300 4300 WAYNE MEDICAL CENTER 103 J V MANGUBAT DR WAYNESBORO TN 38485 WAYNE (931) 722-5411 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.3253550 -87.7575330 0   181 47 47181         https://data.medicare.gov/resource/xubh-q36u/row-283m~szqb.wyui 440010 660038 2019-11-27 2019-06-30 30           30               30
4021 4021 ROCK COUNTY HOSPITAL 102 EAST SOUTH STREET BASSETT NE 68714 HOLT (402) 684-3366 Critical Access Hospitals Government - Local TRUE 42.5758120 -99.5378910 0   149 31 31149         https://data.medicare.gov/resource/xubh-q36u/row-288b-nrv4_cahh 281333 659705 2019-11-18 2019-06-30 24           24       30       54
4537 4537 JOHN D ARCHBOLD MEMORIAL HOSPITAL 915 GORDON AVENUE & MIMOSA DRIVE THOMASVILLE GA 31792 THOMAS (229) 228-2880 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.8251841 -83.9720565 1 ROOFTOP 275 13 13275 45620   Central Thomas County https://data.medicare.gov/resource/xubh-q36u/row-28di.4fre~auew 110038 651993 2019-06-24 2018-09-30 191 35         226 18 20   64       328
2104 2104 ORANGE COUNTY GLOBAL MEDICAL CENTER 1001 NORTH TUSTIN AVENUE SANTA ANA CA 92705 ORANGE (714) 953-3610 Acute Care Hospitals Proprietary TRUE 33.7536360 -117.8342090 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-28hr-uc2x~4s2a 50746 660777 2019-02-01 2018-08-31 163 42   7   16 228               228
659 659 DAYTON GENERAL HOSPITAL 1012 SOUTH 3RD STREET DAYTON WA 99328 COLUMBIA (509) 382-2531 Critical Access Hospitals Government - Hospital District or Authority FALSE 46.3125640 -117.9688720 0   13 53 53013 47460   Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-28j5-9jsv-a9rd 501302 648506 2019-05-23 2018-12-31 25           25         23     48
2801 2801 BETSY JOHNSON REGIONAL HOSPITAL 800 TILGHMAN DR DUNN NC 28334 HARNETT (910) 892-7161 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3065550 -78.6330880 0   85 37 37085 20380 Raleigh-Durham-Chapel Hill, NC Central Harnett County https://data.medicare.gov/resource/xubh-q36u/row-28jj~ikwb_xihf 340071 643818 2019-02-28 2018-09-30 137 14         151               151
4141 4141 ST JOSEPH MERCY CHELSEA 775 S MAIN ST CHELSEA MI 48118 WASHTENAW (734) 475-3911 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3105940 -84.0165710 0   161 26 26161 11460 Detroit-Warren-Ann Arbor, MI Central Washtenaw County https://data.medicare.gov/resource/xubh-q36u/row-28wr-24ws-jf4t 230259 661019 2019-12-02 2019-06-30 91 6         97 30 6           133
925 925 CONEMAUGH MEMORIAL MEDICAL CENTER 1086 FRANKLIN STREET JOHNSTOWN PA 15905 CAMBRIA (814) 534-9000 Acute Care Hospitals Proprietary TRUE 40.3051980 -78.9182490 0   21 42 42021 27780 Johnstown-Somerset, PA Central Cambria County https://data.medicare.gov/resource/xubh-q36u/row-29hn-pzm2.n5mv 390110 660295 2019-12-03 2019-06-30 313 14 11       354 13 39   30       436
1604 1604 DEFIANCE REGIONAL MEDICAL CENTER 1200 RALSTON AVENUE DEFIANCE OH 43512 DEFIANCE (419) 783-6955 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.2993920 -84.3734690 0   39 39 39039 19580   Central Defiance County https://data.medicare.gov/resource/xubh-q36u/row-29rw.zsfv.ixin 361328 649330 2019-05-31 2018-12-31 17 8         25 10             35
1148 1148 NORTH VALLEY HOSPITAL 1600 HOSPITAL WAY WHITEFISH MT 59937 FLATHEAD (406) 863-3550 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3810320 -114.3313260 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-29tt-ysrs_pnbv 271336 654458 2019-08-28 2019-03-31 21 4         25               25
1077 1077 MILFORD REGIONAL MEDICAL CENTER 14 PROSPECT STREET MILFORD MA 1757 WORCESTER (508) 473-1190 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.1328350 -71.5290140 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-29x2.m737-ktj6 220090 644739 2019-02-27 2018-09-30 135 10         145               145
2004 2004 CRITTENDEN COMMUNITY HOSPITAL 520 WEST GUM STREET MARION KY 42064 CRITTENDEN (270) 965-1001 Acute Care Hospitals Government - Local TRUE 37.3296160 -88.0919450 0   55 21 21055         https://data.medicare.gov/resource/xubh-q36u/row-29y5_rw8y-4sga 180095 643771 2019-03-01 2018-09-30 48           48               48
3800 3800 MERCY HOSPITAL FORT SMITH 7301 ROGERS AVE FORT SMITH AR 72903 SEBASTIAN (479) 314-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3536470 -94.3529640 0   131 5 5131 22900   Central Sebastian County https://data.medicare.gov/resource/xubh-q36u/row-2a77_rb9f.j48w 40062 661700 2018-11-30 2018-06-30 280 38         343   42           400
2305 2305 MARCUM & WALLACE MEMORIAL HOSPITAL 60 MERCY COURT IRVINE KY 40336 ESTILL (606) 723-2115 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.7052670 -83.9777420 0   65 21 21065         https://data.medicare.gov/resource/xubh-q36u/row-2ab6~wg69.6pp4 181301 648695 2019-05-21 2018-12-31 25           25               25
1678 1678 STONEWALL JACKSON MEMORIAL HOSPITAL 230 HOSPITAL PLAZA WESTON WV 26452 LEWIS (304) 269-8080 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.0482850 -80.4927430 0   41 54 54041         https://data.medicare.gov/resource/xubh-q36u/row-2afu_zh5p.j9t2 510038 660725 2019-11-25 2019-06-30 64 6         70               70
3834 3834 PAWNEE COUNTY MEMORIAL HOSPITAL P O BOX 433, 600 I ST PAWNEE CITY NE 68420 PAWNEE (402) 852-2231 Critical Access Hospitals Proprietary TRUE 40.1098396 -96.1532422 1 ROOFTOP 133 31 31133         https://data.medicare.gov/resource/xubh-q36u/row-2ahw-y3eh_6phq 281302 661036 2019-12-02 2019-06-30 17           17               17
3726 3726 PAULDING COUNTY HOSPITAL 1035 WEST WAYNE ST. PAULDING OH 45879 PAULDING (419) 399-1103 Critical Access Hospitals Government - Local TRUE 41.1352900 -84.6004940 0   125 39 39125         https://data.medicare.gov/resource/xubh-q36u/row-2ara~5qbu_gakf 361300 649651 2019-06-03 2018-12-31 25           25               25
3710 3710 WEST FELICIANA PARISH HOSPITAL 5266 COMMERCE STREET, BUILDING B SAINT FRANCISVILLE LA 70775 WEST FELICIANA (225) 635-3811 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.7836100 -91.3656960 0   125 22 22125 12940   Outlying West Feliciana Parish https://data.medicare.gov/resource/xubh-q36u/row-2auk~kxvq-q4u4 191306 660809 2019-11-20 2018-10-31 25           25               25
3280 3280 LONG ISLAND COMMUNITY HOSPITAL 101 HOSPITAL ROAD PATCHOGUE NY 11772 SUFFOLK (631) 654-7100 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7793370 -72.9781470 0   103 36 36103 35620 New York-Newark, NY-NJ-CT-PA Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-2bch-388m.ciy4 330141 650301 2019-05-31 2018-12-31 191 10 14       215 20             235
3942 3942 WASHINGTON REGIONAL MEDICAL CENTER 3215 N NORTH HILLS BOULEVARD FAYETTEVILLE AR 72703 WASHINGTON (479) 463-5113 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1109840 -94.1578620 0   143 5 5143 22220   Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-2bs7.twrk_htcb 40004 649161 2019-06-03 2018-12-31 226 40         320           12   332
442 442 BEVERLY HOSPITAL CORPORATION 85 HERRICK STREET BEVERLY MA 1915 ESSEX (978) 922-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5675920 -70.8762010 0   9 25 25009 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Essex County https://data.medicare.gov/resource/xubh-q36u/row-2c3b_zuwj.rint 220033 644036 2019-02-27 2018-09-30 274 22         296 68             364
147 147 BIG HORN HOSPITAL 17 N MILES HARDIN MT 59034 BIG HORN (406) 665-2310 Critical Access Hospitals Government - Local TRUE 45.7288560 -107.6170100 0   3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-2cgz.f5s8-gu8f 271338 652087 2018-11-27 2018-06-30 25           25               25
2154 2154 ST FRANCIS HOSPITAL, ROSLYN 100 PORT WASHINGTON BOULEVARD ROSLYN NY 11576 NASSAU (516) 562-6000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.8045050 -73.6726690 0   59 36 36059 35620 New York-Newark, NY-NJ-CT-PA Central Nassau County https://data.medicare.gov/resource/xubh-q36u/row-2ciy.ebnz~5w5i 330182 650870 2019-06-25 2018-12-31 288 37 19   20   364               364
1277 1277 SAINT FRANCIS MEDICAL CENTER 211 ST FRANCIS DR CAPE GIRARDEAU MO 63703 CAPE GIRARDEAU (573) 331-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.3034070 -89.5712971 1 ROOFTOP 31 29 29031 16020 Cape Girardeau-Sikeston, MO-IL Central Cape Girardeau County https://data.medicare.gov/resource/xubh-q36u/row-2cqn~hh59_aitm 260183 660119 2019-11-25 2019-06-30 216 31         283   24           307
4140 4140 ST JOSEPH MERCY HOSPITAL 5301 E HURON RIVER DR ANN ARBOR MI 48106 WASHTENAW (734) 712-3456 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.2618030 -83.6598190 0   161 26 26161 11460 Detroit-Warren-Ann Arbor, MI Central Washtenaw County https://data.medicare.gov/resource/xubh-q36u/row-2ct6~hcva-wfxq 230156 661012 2019-12-02 2019-06-30 389 20 6   20 15 450 24 33           507
2354 2354 UNIVERSITY OF KENTUCKY HOSPITAL 800 ROSE STREET LEXINGTON KY 40536 FAYETTE (859) 257-2278 Acute Care Hospitals Government - State TRUE 38.0324480 -84.5073810 0   67 21 21067 30460 Lexington-Fayette--Richmond--Frankfort, KY Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-2d2d_vq4g_m7vt 180067 655316 2019-10-15 2019-06-30 677 146       78 901 31             932
2510 2510 UC SAN DIEGO HEALTH HILLCREST - HILLCREST MED CTR 200 WEST ARBOR DRIVE SAN DIEGO CA 92103 SAN DIEGO (619) 543-6222 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.7537170 -117.1659140 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-2d2j.kc8f_hnd2 50025 662154 2019-11-27 2019-06-30 513   46 8 50 52 669 32             701
3183 3183 SIOUX FALLS SPECIALTY HOSPITAL LLP 910 EAST 20TH STREET SIOUX FALLS SD 57105 MINNEHAHA (605) 334-6730 Acute Care Hospitals Proprietary FALSE 43.5348290 -96.7143880 0   99 46 46099 43620   Central Minnehaha County https://data.medicare.gov/resource/xubh-q36u/row-2d65_8re6_defd 430090 652103 2019-04-22 2018-12-31 26           26               26
2489 2489 HARDIN MEDICAL CENTER 935 WAYNE ROAD SAVANNAH TN 38372 HARDIN (731) 926-8121 Acute Care Hospitals Government - Local TRUE 35.2271300 -88.2303620 0   71 47 47071         https://data.medicare.gov/resource/xubh-q36u/row-2dfc~89p6~kqtc 440109 660709 2019-12-02 2019-06-30 49           49       73       122
1835 1835 WOODLAWN HOSPITAL 1400 E 9TH ST ROCHESTER IN 46975 FULTON (574) 223-3141 Critical Access Hospitals Government - Local TRUE 41.0617280 -86.1969730 0   49 18 18049         https://data.medicare.gov/resource/xubh-q36u/row-2dgz-xb34_49d2 151313 649096 2019-05-31 2018-12-31 21 4         25               25
3962 3962 ST JOHN OWASSO 12451 EAST 100TH STREET NORTH OWASSO OK 74055 TULSA (918) 274-5100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.2988030 -95.8350660 0   143 40 40143 46140 Tulsa-Muskogee-Bartlesville, OK Central Tulsa County https://data.medicare.gov/resource/xubh-q36u/row-2dqm_3zaf.66yg 370227 660002 2019-11-26 2019-06-30 32           32               32
2569 2569 IROQUOIS MEMORIAL HOSPITAL 200 FAIRMAN STREET WATSEKA IL 60970 IROQUOIS (815) 432-5201 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7655410 -87.7326660 0   75 17 17075         https://data.medicare.gov/resource/xubh-q36u/row-2e44.299n~22z8 140167 645541 2019-03-04 2018-09-30 25           25       35   1   61
2661 2661 LEHIGH VALLEY HOSPITAL - HAZLETON 700 EAST BROAD STREET HAZLETON PA 18201 LUZERNE (570) 501-4000 Acute Care Hospitals Government - Local TRUE 40.9504640 -75.9634540 0   79 42 42079 42540   Central Luzerne County https://data.medicare.gov/resource/xubh-q36u/row-2eia_cme8~vh69 390185 660147 2019-11-27 2019-06-30 122 12         134   16           150
4393 4393 WYTHE COUNTY COMMUNITY HOSPITAL 600 WEST RIDGE ROAD WYTHEVILLE VA 24382 WYTHE (276) 228-0200 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.9532970 -81.0950690 0   197 51 51197         https://data.medicare.gov/resource/xubh-q36u/row-2f6p~evdq~actr 490111 645869 2019-04-02 2018-10-31 86 6         92       8       100
2160 2160 GOOD SHEPHERD MEDICAL CENTER 610 NW 11TH STREET HERMISTON OR 97838 UMATILLA (541) 667-3400 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.8461350 -119.3109500 0   59 41 41059 25840   Central Umatilla County https://data.medicare.gov/resource/xubh-q36u/row-2f95~scvq.xeyd 381325 662577 2019-11-27 2019-06-30 22 3         25               25
467 467 FORKS COMMUNITY HOSPITAL 530 BOGACHIEL WAY FORKS WA 98331 CLALLAM (360) 374-6271 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.9463560 -124.3934710 0   9 53 53009 38820   Central Clallam County https://data.medicare.gov/resource/xubh-q36u/row-2fc7-ht3p_rrzf 501325 655431 2019-09-25 2018-12-31 25           25         12     37
3239 3239 AVERA FLANDREAU HOSPITAL - CAH 214 NORTH PRAIRIE STREET FLANDREAU SD 57028 MOODY (605) 997-2433 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0505680 -96.5909890 0   101 46 46101         https://data.medicare.gov/resource/xubh-q36u/row-2fiy.k67h.w2yb 431310 660033 2019-11-26 2019-06-30 18           18               18
4630 4630 STONEWALL MEMORIAL HOSPITAL 821 NORTH BROADWAY ASPERMONT TX 79502 STONEWALL (940) 989-3551 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.1481491 -100.2274452 1 RANGE_INTERPOLATED 433 48 48433         https://data.medicare.gov/resource/xubh-q36u/row-2ftf-f2vh-6a2t 451318 644669 2019-03-01 2018-09-30 20           20               20
748 748 LOWELL GENERAL HOSPITAL 295 VARNUM AVENUE LOWELL MA 1854 MIDDLESEX (978) 937-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.6463070 -71.3413230 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-2fw8.fd6r.2ntv 220063 643784 2019-02-26 2018-09-30 367 40         407               407
4298 4298 WEBSTER COUNTY COMMUNITY HOSPITAL P O BOX 465, 621 N FRANKLIN ST RED CLOUD NE 68970 WEBSTER (402) 746-5600 Critical Access Hospitals Government - Local TRUE 40.0915582 -98.5280755 1 ROOFTOP 181 31 31181         https://data.medicare.gov/resource/xubh-q36u/row-2g3y_shvn~j8h3 281316 660132 2019-11-26 2019-06-30 13           13               13
1506 1506 RONALD REAGAN U C L A MEDICAL CENTER 757 WESTWOOD PLAZA LOS ANGELES CA 90095 LOS ANGELES (310) 825-6301 Acute Care Hospitals Government - State TRUE 34.0639390 -118.4454110 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-2g9a~xstc-im3x 50262 660917 2019-11-26 2019-06-30 291 120 12     22 445               445
4493 4493 CROCKETT MEDICAL CENTER 1100 E LOOP 304 CROCKETT TX 75835 HOUSTON (936) 546-3890 Critical Access Hospitals Proprietary TRUE 31.3236990 -95.4372570 0   225 48 48225         https://data.medicare.gov/resource/xubh-q36u/row-2gki~micg.zrhe                                      
1728 1728 ASCENSION SACRED HEART GULF 3801 E HWY 98 PORT SAINT JOE FL 32456 GULF (850) 229-5600 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.7765620 -85.2876050 0   45 12 12045 37460   Outlying Gulf County https://data.medicare.gov/resource/xubh-q36u/row-2gve.rn5c.g9tq 100313 660196 2019-11-27 2019-06-30 19           19               19
337 337 BANNER PAYSON MEDICAL CENTER 807 SOUTH PONDEROSA DRIVE PAYSON AZ 85541 GILA (928) 474-3222 Critical Access Hospitals Voluntary non-profit - Other FALSE 34.2313510 -111.3213610 0   7 4 4007 37740   Central Gila County https://data.medicare.gov/resource/xubh-q36u/row-2gy2.vxfy~pkyq 31318 649532 2019-06-03 2018-12-31 21 4         25               25
2619 2619 MERCY HEALTH - WILLARD HOSPITAL 1100 NEAL ZICK ROAD WILLARD OH 44890 HURON (419) 964-5000 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.0485890 -82.7240000 0   77 39 39077 35940 Cleveland-Akron-Canton, OH Central Huron County https://data.medicare.gov/resource/xubh-q36u/row-2gzj.rp2x-kr88 361310 648306 2019-05-20 2018-12-31 18 2         20               20
3871 3871 NORTON COUNTY HOSPITAL 102 E HOLME STREET NORTON KS 67654 NORTON (785) 877-3351 Critical Access Hospitals Government - Local TRUE 39.8385290 -99.8887420 0   137 20 20137         https://data.medicare.gov/resource/xubh-q36u/row-2h2e.ibxx~85g5 171348 659681 2019-11-15 2019-06-30 25           25               25
3845 3845 OCONOMOWOC MEMORIAL HOSPITAL 791 E SUMMIT AVE OCONOMOWOC WI 53066 WAUKESHA (262) 569-9400 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1011360 -88.4861090 0   133 55 55133 33340 Milwaukee-Racine-Waukesha, WI Central Waukesha County https://data.medicare.gov/resource/xubh-q36u/row-2h4h-p3qh-q6i3 520062 644387 2019-02-27 2018-09-30 47 11         58               58
1006 1006 ST ELIZABETH'S MEDICAL CENTER 736 CAMBRIDGE STREET BRIGHTON MA 2135 SUFFOLK (617) 789-3000 Acute Care Hospitals Proprietary TRUE 42.3497730 -71.1481200 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-2h6b~pv8m.4qst 220036 650487 2019-05-31 2018-12-31 166 46         212 62             274
825 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
3757 3757 PUSHMATAHA COUNTY TOWN OF ANTLERS HOSPITAL 510 EAST MAIN STREET ANTLERS OK 74523 PUSHMATAHA (580) 298-3341 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.2317170 -95.6156030 0   127 40 40127         https://data.medicare.gov/resource/xubh-q36u/row-2h9r-9buw.dkj2 370083 653854 2019-09-03 2019-03-31 42           42               42
3646 3646 MERIT HEALTH RIVER OAKS 1030 RIVER OAKS DRIVE FLOWOOD MS 39232 RANKIN (601) 932-1030 Acute Care Hospitals Proprietary TRUE 32.3261400 -90.1064470 0   121 28 28121 27140 Jackson-Vicksburg-Brookhaven, MS Central Rankin County https://data.medicare.gov/resource/xubh-q36u/row-2hkw~4rry~9q7r 250138 644305 2019-02-19 2018-09-30 128 10         158               158
2005 2005 LAFAYETTE GENERAL MEDICAL CENTER 1214 COOLIDGE AVENUE LAFAYETTE LA 70503 LAFAYETTE (337) 289-7991 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2023190 -92.0187050 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-2hmz-7r5i_zdte 190002 645416 2019-03-01 2018-09-30 291 40         362 24 13           399
1661 1661 SAMARITAN PACIFIC COMMUNITY HOSPITAL 930 SW ABBEY STREET NEWPORT OR 97365 LINCOLN (541) 265-2244 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.6298580 -124.0591640 0   41 41 41041 35440   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-2hph_npt2~vzq7 381314 650767 2019-05-28 2018-12-31 25           25               25
4747 4747 MARY IMMACULATE HOSPITAL 2 BERNARDINE DRIVE NEWPORT NEWS VA 23602 NEWPORT NEWS CITY (757) 886-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.1430060 -76.5131200 0   700 51 51700 47260 Virginia Beach-Norfolk, VA-NC Central Newport News city https://data.medicare.gov/resource/xubh-q36u/row-2hzs_hzm9_tfgj 490041 655855 2019-01-30 2018-08-31 105 10         115       115       230
1600 1600 PRESBYTERIAN ESPANOLA HOSPITAL 1010 SPRUCE STREET ESPANOLA NM 87532 RIO ARRIBA (505) 753-1502 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.9971010 -106.0866830 0   39 35 35039 21580 Albuquerque-Santa Fe-Las Vegas, NM Central Rio Arriba County https://data.medicare.gov/resource/xubh-q36u/row-2ihe-5knz~yfsj 320011 651477 2019-05-30 2018-12-31 44 8         52               52
4612 4612 REFUGIO COUNTY MEMORIAL HOSPITAL 107 SWIFT STREET REFUGIO TX 78377 REFUGIO (361) 526-2321 Critical Access Hospitals Government - Hospital District or Authority TRUE 28.3064870 -97.2794390 0   391 48 48391         https://data.medicare.gov/resource/xubh-q36u/row-2im8~3t6u.ez3t 451317 649504 2019-05-29 2018-12-31 20           20               20
2603 2603 MEMORIAL HOSPITAL OF CARBONDALE 405 W JACKSON CARBONDALE IL 62901 JACKSON (618) 549-0721 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.7279730 -89.2201210 0   77 17 17077 16060   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-2ipw_2w48-wu9a 140164 653132 2019-08-27 2019-03-31 133 21       13 167               167
216 216 CUBA MEMORIAL HOSPITAL, INC 140 WEST MAIN STREET CUBA NY 14727 ALLEGANY (585) 961-2000 Critical Access Hospitals Voluntary non-profit - Private FALSE 42.2133410 -78.2881390 0   3 36 36003         https://data.medicare.gov/resource/xubh-q36u/row-2ir6~7udp_pyzv 331301 651038 2019-06-03 2018-12-31 20           20       61       81
2874 2874 ROANE GENERAL HOSPITAL 200 HOSPITAL DRIVE SPENCER WV 25276 ROANE (304) 927-4444 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8136540 -81.3688700 0   87 54 54087         https://data.medicare.gov/resource/xubh-q36u/row-2iwc-6g6k~ur6u 511306 645205 2019-02-28 2018-09-30 25           25       44       69
4350 4350 SSM HEALTH ST CLARE HOSPITAL - FENTON 1015 BOWLES FENTON MO 63026 JEFFERSON (636) 496-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5290430 -90.4736250 0   189 29 29189 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-2jeu~8ki6.gqvt 260081 648850 2019-05-29 2018-12-31 141 39         180               180
4711 4711 HAMILTON HOSPITAL 901 WEST HAMILTON OLNEY TX 76374 YOUNG (940) 564-5521 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.3696690 -98.7646300 0   503 48 48503         https://data.medicare.gov/resource/xubh-q36u/row-2jrh~g63r.wnym 451354 652730 2019-07-31 2019-02-28 25           25               25
242 242 AIKEN REGIONAL MEDICAL CENTER 302 UNIVERSITY PARKWAY AIKEN SC 29801 AIKEN (803) 641-5900 Acute Care Hospitals Proprietary TRUE 33.5698900 -81.7650710 0   3 45 45003 12260   Central Aiken County https://data.medicare.gov/resource/xubh-q36u/row-2jsk_ph6i-gvkj 420082 648759 2019-05-29 2018-12-31 169 35         204 48 14           266
1735 1735 MERCYONE CLINTON MEDICAL CENTER 1410 NORTH 4TH STREET CLINTON IA 52732 CLINTON (563) 244-5555 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8605430 -90.1881550 0   45 19 19045 17540 Davenport-Moline, IA-IL Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-2kgs.eg5q.xjrv 160080 660084 2019-11-26 2019-06-30 97 10         107               107
4419 4419 MEMORIAL HERMANN HOSPITAL SYSTEM 1635 NORTH LOOP WEST HOUSTON TX 77008 HARRIS (713) 448-6796 Acute Care Hospitals Voluntary non-profit - Private TRUE 29.8122660 -95.4308990 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-2kjx_z9h3~iiu7 450184 659537 2019-11-25 2019-06-30 1068 157       85 1310   78           1388
3160 3160 LABETTE HEALTH 1902 SOUTH US HWY 59 PARSONS KS 67357 LABETTE (620) 421-4880 Acute Care Hospitals Government - Local TRUE 37.3220120 -95.2665930 0   99 20 20099 37660   Central Labette County https://data.medicare.gov/resource/xubh-q36u/row-2kn5~66bk.y4wq 170120 646556 2019-04-01 2018-12-31 41 5         46   7           53
922 922 MERCY HEALTH - URBANA HOSPITAL 904 SCIOTO STREET URBANA OH 43078 CHAMPAIGN (937) 653-5231 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1067250 -83.7302520 0   21 39 39021 46500 Dayton-Springfield-Sidney, OH Central Champaign County https://data.medicare.gov/resource/xubh-q36u/row-2ktb~7c9h_tz4d 361312 648464 2019-05-21 2018-12-31 25           25 10             35
2535 2535 MCLAREN CENTRAL MICHIGAN 1221 SOUTH DRIVE MOUNT PLEASANT MI 48858 ISABELLA (989) 772-6700 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5985280 -84.7613890 0   73 26 26073 34380 Mount Pleasant-Alma, MI Central Isabella County https://data.medicare.gov/resource/xubh-q36u/row-2kyb_h42d_ribb 230080 644744 2019-02-22 2018-09-30 75 8         83               83
3324 3324 CHI ST ALEXIUS HEALTH WILLISTON 1301 15TH AVE W WILLISTON ND 58801 WILLIAMS (701) 774-7400 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.1543320 -103.6454370 0   105 38 38105 48780   Central Williams County https://data.medicare.gov/resource/xubh-q36u/row-2m99~vhsx_qu32 351334 662569 2019-12-02 2019-06-30 25           25               25
2440 2440 BARSTOW COMMUNITY HOSPITAL 820 E MOUNTAIN VIEW STREET BARSTOW CA 92311 SAN BERNARDINO (760) 256-1761 Acute Care Hospitals Proprietary TRUE 34.8936960 -117.0166000 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-2mmv_xa7g.rdya 50298 654086 2019-08-27 2019-01-31 26 4         30               30
831 831 EASTERN MAINE MEDICAL CENTER PO BOX 404 BANGOR ME 4401 PENOBSCOT (207) 973-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.8080922 -68.7517371 1 ROOFTOP 19 23 23019 12620   Central Penobscot County https://data.medicare.gov/resource/xubh-q36u/row-2mv7_y4vm-bcwh 200033 650703 2019-05-30 2018-09-30 246 44         313   36           349
884 884 SAN LUIS VALLEY HEALTH CONEJOS COUNTY HOSPITAL 19021 US HIGHWAY 285 LA JARA CO 81140 CONEJOS (719) 274-5121 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.2637500 -105.9640950 0   21 8 8021         https://data.medicare.gov/resource/xubh-q36u/row-2ncf.isv7_93r9 61308 662179 2019-12-03 2019-06-30 17           17               17
2891 2891 DELNOR COMMUNITY HOSPITAL 300 RANDALL RD GENEVA IL 60134 KANE (630) 208-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8863450 -88.3404140 0   89 17 17089 16980 Chicago-Naperville, IL-IN-WI Central Kane County https://data.medicare.gov/resource/xubh-q36u/row-2nnq_hi63-xbm2 140211 657805 2019-02-04 2018-08-31 124 20         144               144
1362 1362 VALLEY MEDICAL CENTER 400 S 43RD ST RENTON WA 98055 KING (425) 228-3450 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.4410940 -122.2142510 0   33 53 53033 42660 Seattle-Tacoma, WA Central King County https://data.medicare.gov/resource/xubh-q36u/row-2q75.mwjb_9fau 500088 658621 2019-11-12 2019-06-30 311           311               311
2193 2193 GRAND ITASCA CLINIC AND HOSPITAL 1601 GOLF COURSE ROAD GRAND RAPIDS MN 55744 ITASCA (218) 326-3401 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2210390 -93.5547160 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-2qrv~rfjc~89wf 240064 650497 2019-05-31 2018-12-31 27   9       36               36
4288 4288 FLAGET MEMORIAL HOSPITAL 4305 NEW SHEPHERDSVILLE ROAD BARDSTOWN KY 40004 NELSON (502) 350-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8639950 -85.5237600 0   179 21 21179 12680 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Nelson County https://data.medicare.gov/resource/xubh-q36u/row-2qwd-5iqi~bxhv 180025 660225 2019-11-27 2019-06-30 36 4         40       12       52
3335 3335 KAWEAH DELTA MEDICAL CENTER 400 W MINERAL KING AVE VISALIA CA 93291 TULARE (559) 624-2000 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.3274150 -119.2941720 0   107 6 6107 47300 Visalia-Porterville-Hanford, CA Central Tulare County https://data.medicare.gov/resource/xubh-q36u/row-2rh3~mb6h~sxp4 50057 662013 2019-12-04 2019-06-30 347 41       15 403 63 45   70       581
1560 1560 LAKE DISTRICT HOSPITAL 700 SOUTH J STREET LAKEVIEW OR 97630 LAKE (541) 947-2114 Critical Access Hospitals Government - Hospital District or Authority TRUE 42.1815830 -120.3514370 0   37 41 41037         https://data.medicare.gov/resource/xubh-q36u/row-2rpx~hmxp~n924 381309 640591 2018-12-10 2018-06-30 24           24               24
4438 4438 TEXAS ORTHOPEDIC HOSPITAL 7401 SOUTH MAIN STREET HOUSTON TX 77030 HARRIS (713) 799-8600 Acute Care Hospitals Voluntary non-profit - Other TRUE 29.7003150 -95.4096750 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-2s48_tmnu.5ruc 450804 649501 2019-05-31 2018-12-31 49           49               49
3069 3069 SISTERSVILLE GENERAL HOSPITAL 314 SOUTH WELLS STREET SISTERSVILLE WV 26175 TYLER (304) 652-2611 Critical Access Hospitals Government - Local TRUE 39.5583390 -81.0040670 0   95 54 54095         https://data.medicare.gov/resource/xubh-q36u/row-2s4x~j49z-cdcm 511304 650921 2019-06-04 2018-12-31 25           25           10   35
4171 4171 KARMANOS CANCER CENTER 4100 JOHN R DETROIT MI 48201 WAYNE (800) 576-6266 Acute Care Hospitals Proprietary FALSE 42.3518900 -83.0581920 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-2s9p.6u7q.5vpp 230297 652518 2019-07-15 2018-09-30 117 6         123               123
4668 4668 NORTH AUSTIN MEDICAL CENTER 12221 MOPAC EXPRESSWAY NORTH AUSTIN TX 78758 TRAVIS (512) 901-1000 Acute Care Hospitals Proprietary TRUE 30.4121440 -97.7081130 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-2sap-qyma-ketx 450809 659544 2019-11-22 2019-06-30 290 24       57 377   16           393
1592 1592 MERCY REGIONAL MEDICAL CENTER 800 E MAIN VILLE PLATTE LA 70586 EVANGELINE (337) 363-5684 Acute Care Hospitals Proprietary TRUE 30.6849310 -92.2659730 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-2sdk.fhzr.wwum 190167 645559 2019-03-01 2018-09-30 85 14         99   10           109

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