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

1,832 rows where "fy_end_date" is on date 2018-12-31 sorted by subtotal_acute_beds

✎ 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, surg_icu_beds, subprovider_oth_beds, nursing_fac_beds, filed_date (date)

fy_end_date (date) ✖

  • 2018-12-31 · 1,832 ✖
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
1888 1888 LEVI HOSPITAL 300 PROSPECT AVE HOT SPRINGS AR 71901 GARLAND (501) 624-1281 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5099450 -93.0566490 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-assk.a57a-njvy 40132 649865 2019-05-24 2018-12-31 1           1 52             53
4338 4338 PARKLAND HEALTH CENTER - BONNE TERRE 7245 RAIDER ROAD BONNE TERRE MO 63628 ST. FRANCOIS (573) 358-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9092860 -90.5252970 0   187 29 29187 22100 St. Louis-St. Charles-Farmington, MO-IL Central St. Francois County https://data.medicare.gov/resource/xubh-q36u/row-qfh6_b86g_9np8 261315 662397 2019-12-04 2018-12-31 3           3               3
426 426 LANAI COMMUNITY HOSPITAL 628 7TH STREET LANAI CITY HI 96763 MAUI (808) 565-8450 Critical Access Hospitals Government - State TRUE 20.8267350 -156.9180020 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-keiy_dtd7_smny 121305 648608 2019-06-03 2018-12-31 4           4       10       14
637 637 WESTFIELD MEMORIAL HOSPITAL, INC 189 EAST MAIN STREET WESTFIELD NY 14787 CHAUTAUQUA (716) 326-4921 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3279010 -79.5693970 0   13 36 36013 27460   Central Chautauqua County https://data.medicare.gov/resource/xubh-q36u/row-vwk8~gn4h~53q8 330166 650743 2019-05-31 2018-12-31 4           4               4
3581 3581 MAYHILL HOSPITAL 2809 SOUTH MAYHILL ROAD DENTON TX 76208 DENTON (940) 239-3000 Acute Care Hospitals Proprietary FALSE 33.1758420 -97.0882930 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-m8he-msb6~66b2 670010 647842 2019-05-15 2018-12-31 4           4 55             59
4424 4424 AD HOSPITAL EAST, LLC 12950 EAST FREEWAY, SUITE 100 HOUSTON TX 77015 HARRIS (713) 330-3897 Acute Care Hospitals Proprietary TRUE 29.7711360 -95.2007820 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-g9pj_7cms.hams 670102 649155 2019-05-30 2018-12-31 4           4               4
125 125 MILFORD VALLEY MEMORIAL HOSPITAL 850 NORTH MAIN STREET MILFORD UT 84751 BEAVER (435) 387-2411 Critical Access Hospitals Government - Hospital District or Authority FALSE 38.4073080 -113.0095430 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-iet4.f5zs.batz 461305 648782 2019-05-29 2018-12-31 5           5           18   23
2027 2027 MONROE COMMUNITY HOSPITAL 435 EAST HENRIETTA ROAD ROCHESTER NY 14620 MONROE (585) 760-6500 Acute Care Hospitals Voluntary non-profit - Other FALSE 43.1118560 -77.6160780 0   55 36 36055 40380 Rochester-Batavia-Seneca Falls, NY Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-5bf3_hk4u~74wb 330403 651037 2019-06-03 2018-12-31 5           5       566       571
3669 3669 PROVIDENCE SEWARD HOSPITAL 417 FIRST AVENUE, PO BOX 365 SEWARD AK 99664 KENAI PENINSULA (907) 224-5205 Critical Access Hospitals Government - Local TRUE 60.1050460 -149.4453830 0   122 2 2122         https://data.medicare.gov/resource/xubh-q36u/row-bjag~4kwr.8ihd 21302 652058 2019-05-30 2018-12-31 6           6       40       46
4116 4116 SUGAR LAND SURGICAL HOSPITAL LLP 16906 SOUTHWEST FREEWAY SUGAR LAND TX 77479 FORT BEND (281) 243-1000 Acute Care Hospitals Physician TRUE 29.5906090 -95.6366960 0   157 48 48157 26420 Houston-The Woodlands, TX Central Fort Bend County https://data.medicare.gov/resource/xubh-q36u/row-9avs-knbp-aret 450860 651075 2019-06-21 2018-12-31 6           6               6
4587 4587 ASPIRE BEHAVIORAL HEALTH OF CONROE, LLC 2006 SOUTH LOOP 336 WEST, SUITE 500 CONROE TX 77304 MONTGOMERY (936) 647-3500 Acute Care Hospitals Physician FALSE 30.2840690 -95.4801310 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-h7u8.wg6t-a3vd 670093 651497 2019-05-31 2018-12-31 6           6 24             30
3938 3938 HOSPITAL METROPOLITANO DE LA MONTANA CALLE ISAAC GONZALEZ ESQUINA LEDESMA BDA NUEVA PR 641 UTUADO (787) 933-1100 Acute Care Hospitals Proprietary TRUE 18.2675675 -66.7013424 1 GEOMETRIC_CENTER 141 72 72141 10380   Central Utuado Municipio https://data.medicare.gov/resource/xubh-q36u/row-8n9a.kpfm-bvb9 400130 650777 2019-05-28 2018-12-31 7           7 40             47
3976 3976 HEALTHSOURCE SAGINAW 3340 HOSPITAL ROAD SAGINAW MI 48603 SAGINAW (989) 790-7888 Acute Care Hospitals Voluntary non-profit - Other TRUE 43.4564180 -84.0520480 0   145 26 26145 40980 Saginaw-Midland-Bay City, MI Central Saginaw County https://data.medicare.gov/resource/xubh-q36u/row-bnbr~xrkk.p4j7 230275 650491 2019-05-31 2018-12-31 7           7 85 38   213       343
1339 1339 SANFORD WESTBROOK MEDICAL CENTER 920 BELL AVENUE PO BOX 188 WESTBROOK MN 56183 COTTONWOOD (507) 274-1119 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.0452850 -95.4388910 0   33 27 27033         https://data.medicare.gov/resource/xubh-q36u/row-enjn~dps2_zg3d 241302 649270 2019-05-28 2018-12-31 8           8               8
1624 1624 CHARLESTON SURGICAL HOSPITAL 1306 KANAWHA BOULEVARD EAST CHARLESTON WV 25301 KANAWHA (304) 343-4371 Acute Care Hospitals Physician FALSE 38.3429910 -81.6306620 0   39 54 54039 16620 Charleston-Huntington-Ashland, WV-OH-KY Central Kanawha County https://data.medicare.gov/resource/xubh-q36u/row-zfdk.i8cn~ciui 510091 650428 2019-05-31 2018-12-31 8           8               8
2297 2297 ST VINCENT GENERAL HOSPITAL DISTRICT 822 W 4TH ST LEADVILLE CO 80461 LAKE (719) 486-0230 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2443920 -106.3033020 0   65 8 8065         https://data.medicare.gov/resource/xubh-q36u/row-zkkb~2fq8_8dib 61319 648894 2019-05-30 2018-12-31 8           8               8
2867 2867 THREE GABLES SURGERY CENTER 5897 COUNTY ROAD 107 PROCTORVILLE OH 45669 LAWRENCE (740) 886-9911 Acute Care Hospitals Proprietary FALSE 38.4407480 -82.3932980 0   87 39 39087 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-9r4y.f6ba-vqwk 360261 648744 2019-05-23 2018-12-31 8           8               8
3397 3397 ONECORE HEALTH 1044 SW 44TH, SUITE 350 OKLAHOMA CITY OK 73109 OKLAHOMA (405) 631-3085 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.4207290 -97.5338680 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-zhp9.4kgr_ytfs 370220 651480 2019-05-29 2018-12-31 8           8               8
4654 4654 USMD HOSPITAL AT FORT WORTH LP 5900 ALTAMESA BLVD FORT WORTH TX 76132 TARRANT (817) 433-9100 Acute Care Hospitals Proprietary TRUE 32.6455920 -97.4181400 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-dprz_9mav_2zjv 670046 649011 2019-05-31 2018-12-31 8           8               8
4669 4669 NORTHWEST HILLS SURGICAL HOSPITAL 6818 AUSTIN CTR BLVD SUITE 100 AUSTIN TX 78731 TRAVIS (512) 346-1994 Acute Care Hospitals Proprietary TRUE 30.3503160 -97.7510260 0   453 48 48453 12420   Central Travis County https://data.medicare.gov/resource/xubh-q36u/row-ue4n.z4gb~9nnx 450808 649834 2019-05-31 2018-12-31 8           8               8
85 85 TREASURE VALLEY HOSPITAL 8800 WEST EMERALD STREET BOISE ID 83704 ADA (208) 373-5000 Acute Care Hospitals Proprietary FALSE 43.6112890 -116.2903320 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-egh2.u29a~s2jf 130063 650684 2019-05-31 2018-12-31 9           9               9
399 399 CASCADE MEDICAL CENTER 817 COMMERCIAL STREET LEAVENWORTH WA 98826 CHELAN (509) 548-5815 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.5944570 -120.6615030 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-y32v.qfkm-6i3p 501313 659387 2019-05-29 2018-12-31 9           9               9
427 427 KULA HOSPITAL 100 KEOKEA PLACE KULA HI 96790 MAUI (808) 878-1221 Critical Access Hospitals Government - State TRUE 20.7019940 -156.3570990 0   9 15 15009 27980   Central Maui County https://data.medicare.gov/resource/xubh-q36u/row-8svz_bunk-n2za 121308 648609 2019-06-03 2018-12-31 9           9       105       123
2649 2649 MINNESOTA VALLEY HEALTH CENTER INC 621 SOUTH FOURTH STREET LE SUEUR MN 56058 LE SUEUR (507) 665-3375 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4541980 -93.9162670 0   79 27 27079 33460 Minneapolis-St. Paul, MN-WI Outlying Le Sueur County https://data.medicare.gov/resource/xubh-q36u/row-n2b6_pqcf_76a2 241375 650723 2019-05-31 2018-12-31 9           9       55       64
2948 2948 DOCTORS HOSPITAL LLC 4901 COLLEGE BLVD LEAWOOD KS 66211 JOHNSON (913) 529-1801 Acute Care Hospitals Proprietary FALSE 38.9274120 -94.6435000 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-g4ct-f4db-d8p3 170194 649586 2019-05-31 2018-12-31 9           9               9
2950 2950 MINIMALLY INVASIVE SURGERY HOSPITAL 11217 LAKEVIEW AVENUE LENEXA KS 66219 JOHNSON (913) 322-7401 Acute Care Hospitals Proprietary FALSE 38.9243760 -94.7697050 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-jnfx.rz75-i6pf 170199 649588 2019-06-03 2018-12-31 7       2   9               9
3386 3386 NORTHWEST SURGICAL HOSPITAL 9204 NORTH MAY AVENUE OKLAHOMA CITY OK 73120 OKLAHOMA (405) 848-1918 Acute Care Hospitals Physician TRUE 35.5641660 -97.5671590 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-a9dt_8msh-9ahb 370192 650519 2019-05-30 2018-12-31 9           9               9
3394 3394 SUMMIT MEDICAL CENTER, LLC 1800 SOUTH RENAISSANCE BOULEVARD EDMOND OK 73013 OKLAHOMA (405) 359-2400 Acute Care Hospitals Physician TRUE 35.6355210 -97.4994350 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-4vbg.5jhj-wsm8 370225 648353 2019-05-20 2018-12-31 9           9               9
3494 3494 TEXAS INSTITUTE FOR SURGERY AT PRESBYTERIAN HOSPIT 7115 GREENVILLE AVENUE SUITE 100 DALLAS TX 75231 DALLAS (214) 647-5300 Acute Care Hospitals Proprietary TRUE 32.8763770 -96.7617260 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-zpaw~2v5b-8gcc 450889 646976 2019-04-26 2018-12-31 9           9               9
3520 3520 SEDGWICK COUNTY MEMORIAL HOSPITAL 900 CEDAR ST JULESBURG CO 80737 SEDGWICK (970) 474-3323 Critical Access Hospitals Government - Local FALSE 40.9937430 -102.2692320 0   115 8 8115         https://data.medicare.gov/resource/xubh-q36u/row-ptjm_bmz6~8mzz 61310 649075 2019-05-22 2018-12-31 9           9         32     41
3933 3933 THE HOSPITALS OF PROVIDENCE HORIZON CITY CAMPUS 13600 HORIZON STREET, SUITE 100 HORIZON CITY TX 79928 EL PASO (915) 407-7878 Acute Care Hospitals Proprietary TRUE 31.6827230 -106.2073480 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-m5db~xjiy~dvv3 670124 649391 2019-05-30 2018-12-31 9           9               9
355 355 KIOWA DISTRICT HOSPITAL 1002 SOUTH 4TH STREET KIOWA KS 67070 BARBER (620) 825-4131 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.0085470 -98.4897950 0   7 20 20007         https://data.medicare.gov/resource/xubh-q36u/row-cbxd_2s68-tihe 171331 648918 2019-05-29 2018-12-31 10           10               10
1114 1114 SUMMIT PACIFIC MEDICAL CENTER-SWING BED UNIT 600 EAST MAIN STREET ELMA WA 98541 GRAYS HARBOR (360) 346-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.0066230 -123.3910220 0   27 53 53027 10140   Central Grays Harbor County https://data.medicare.gov/resource/xubh-q36u/row-9u5u_f83c.s8u4 501304 651087 2019-06-05 2018-12-31 10           10               10
1615 1615 SANFORD CLEAR LAKE MEDICAL CENTER 701 THIRD AVENUE SOUTH CLEAR LAKE SD 57226 DEUEL (605) 874-2141 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.7526780 -96.6825600 0   39 46 46039         https://data.medicare.gov/resource/xubh-q36u/row-tyxz_xmhj~kyxp 431307 652104 2019-05-30 2018-12-31 10           10               10
1691 1691 PHYSICIANS' MEDICAL CENTER LLC 4023 REAS LN NEW ALBANY IN 47150 FLOYD (812) 206-7660 Acute Care Hospitals Physician FALSE 38.3400320 -85.8270640 0   43 18 18043 31140 Louisville/Jefferson County--Elizabethtown--Madison, KY-IN Central Floyd County https://data.medicare.gov/resource/xubh-q36u/row-bawj-eke8.ffq3 150172 650260 2019-06-04 2018-12-31 10           10               10
1882 1882 WILLAPA HARBOR HOSPITAL 800 ALDER STREET SOUTH BEND WA 98586 PACIFIC (360) 875-5526 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.6621640 -123.8123170 0   49 53 53049         https://data.medicare.gov/resource/xubh-q36u/row-yp34-4iya_m78d 501303 647986 2019-05-14 2018-12-31 10           10               10
2008 2008 LAFAYETTE GENERAL SURGICAL HOSPITAL 1000 W PINHOOK RD SUITE 100 LAFAYETTE LA 70503 LAFAYETTE (337) 289-8095 Acute Care Hospitals Physician FALSE 30.2042530 -92.0134680 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-i7bm~9svd~q42h 190268 649248 2019-05-30 2018-12-31 10           10               10
2009 2009 PARK PLACE SURGICAL HOSPITAL 4811 AMBASSADOR CAFFERY PARKWAY LAFAYETTE LA 70508 LAFAYETTE (337) 237-8119 Acute Care Hospitals Physician FALSE 30.1497980 -92.0401140 0   55 22 22055 29180 Lafayette-Opelousas-Morgan City, LA Central Lafayette Parish https://data.medicare.gov/resource/xubh-q36u/row-pekc_yry2_bpdk 190255 649246 2019-05-30 2018-12-31 10           10               10
2405 2405 REGIONAL WEST GARDEN COUNTY HOSPITAL 1100 WEST 2ND ST OSHKOSH NE 69154 GARDEN (308) 772-3283 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4124850 -102.3475730 0   69 31 31069         https://data.medicare.gov/resource/xubh-q36u/row-ak6k-74t4-rjik 281310 649128 2019-05-30 2018-12-31 10           10           40   50
2532 2532 MONROE SURGICAL HOSPITAL 2408 BROADMOOR BLVD MONROE LA 71201 OUACHITA (318) 410-0002 Acute Care Hospitals Physician FALSE 32.5367710 -92.1022040 0   73 22 22073 33740 Monroe-Ruston-Bastrop, LA Central Ouachita Parish https://data.medicare.gov/resource/xubh-q36u/row-2viy_tht4-abuk 190245 650140 2019-06-03 2018-12-31 10           10               10
2806 2806 EDGEWOOD SURGICAL HOSPITAL 239 EDGEWOOD DRIVE EXTENSION TRANSFER PA 16154 MERCER (724) 646-0400 Acute Care Hospitals Physician FALSE 41.3300510 -80.4178550 0   85 42 42085 49660 Youngstown-Warren, OH-PA Central Mercer County https://data.medicare.gov/resource/xubh-q36u/row-rh2b~kawm~nsdh 390307 649489 2019-05-30 2018-12-31 10           10               10
2860 2860 MAHNOMEN HEALTH CENTER 414 W JEFFERSON PO BOX 396 MAHNOMEN MN 56557 MAHNOMEN (218) 935-2511 Critical Access Hospitals Government - Local TRUE 47.3117925 -95.9729278 1 ROOFTOP 87 27 27087         https://data.medicare.gov/resource/xubh-q36u/row-hmyn_2dwh_mr9t 241300 651009 2019-06-04 2018-12-31 10           10       32       42
2880 2880 PATIENTS' HOSPITAL OF REDDING 2900 EUREKA WAY REDDING CA 96001 SHASTA (530) 225-8700 Acute Care Hospitals Physician FALSE 40.5854900 -122.4162640 0   89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-5vur~pqci_pq3w 50697 650657 2019-05-31 2018-12-31 10           10               10
3246 3246 PIONEERS MEDICAL CENTER 100 PIONEERS MEDICAL CENTER DR MEEKER CO 81641 RIO BLANCO (970) 878-5047 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0470026 -107.8822968 1 ROOFTOP 103 8 8103         https://data.medicare.gov/resource/xubh-q36u/row-ygxw-c3bh-9y5d 61325 647603 2019-05-08 2018-12-31 10           10       30       40
3268 3268 STERLING SURGICAL HOSPITAL 989 ROBERT BLVD SLIDELL LA 70458 ST. TAMMANY (504) 690-8200 Acute Care Hospitals Proprietary FALSE 30.2907800 -89.7694020 0   103 22 22103 35380 New Orleans-Metairie-Hammond, LA-MS Outlying St. Tammany Parish https://data.medicare.gov/resource/xubh-q36u/row-w5g7~ffzq.fcn6 190256 647895 2019-05-17 2018-12-31 10           10               10
3402 3402 OKLAHOMA CENTER FOR ORTHOPAEDIC & MULTI-SP 8100 SOUTH WALKER BLDG C OKLAHOMA CITY OK 73139 OKLAHOMA (405) 602-6500 Acute Care Hospitals Proprietary FALSE 35.3856890 -97.5212710 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-nigy_87dp_gajj 370212 650200 2019-06-18 2018-12-31 10           10               10
4077 4077 SUMMIT SURGICAL, LLC 1818 EAST 23RD AVENUE HUTCHINSON KS 67502 RENO (620) 662-6000 Acute Care Hospitals Physician FALSE 38.0795300 -97.8885950 0   155 20 20155 26740   Central Reno County https://data.medicare.gov/resource/xubh-q36u/row-rrpw.z43u-xa5d 170198 649226 2019-05-30 2018-12-31 10           10               10
4240 4240 UNICOI COUNTY HOSPITAL 2030 TEMPLE HILL ROAD ERWIN TN 37650 UNICOI (423) 743-3141 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.1213650 -82.4456210 0   171 47 47171 27740 Johnson City-Kingsport-Bristol, TN-VA Outlying Unicoi County https://data.medicare.gov/resource/xubh-q36u/row-8b8j.szqj-76se 440001 649955 2019-05-28 2018-12-31 10           10       7 39     56
4588 4588 MEMORIAL HERMANN SURGICAL HOSPITAL KINGWOOD 300 KINGWOOD MEDICAL DRIVE KINGWOOD TX 77339 HARRIS (281) 312-4000 Acute Care Hospitals Proprietary TRUE 30.0471980 -95.2579490 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-v6he.gqvr.a5ws 670005 648513 2019-05-21 2018-12-31 10           10               10
346 346 PAGOSA SPRINGS MEDICAL CENTER 95 SOUTH PAGOSA BOULEVARD PAGOSA SPRINGS CO 81147 ARCHULETA (970) 731-3700 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.2527760 -107.0772190 0   7 8 8007         https://data.medicare.gov/resource/xubh-q36u/row-j5fe.jwy4~ejt9 61328 654714 2019-09-26 2018-12-31 11           11               11
396 396 CONFLUENCE HEALTH- WENATCHEE VALLEY HOSP & CLINICS 820 NORTH CHELAN AVENUE WENATCHEE WA 98801 CHELAN (509) 663-8711 Acute Care Hospitals Voluntary non-profit - Private FALSE 47.4335660 -120.3219830 0   7 53 53007 48300   Central Chelan County https://data.medicare.gov/resource/xubh-q36u/row-aiqi_mn7n_vecf 500148 650791 2019-05-31 2018-12-31 11           11   9           20
728 728 KEEFE MEMORIAL HOSPITAL 602 N 6TH W ST CHEYENNE WELLS CO 80810 CHEYENNE (719) 767-5661 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.8258870 -102.3555830 0   17 8 8017         https://data.medicare.gov/resource/xubh-q36u/row-tagv~57dn~4tm7 61343 649879 2019-05-29 2018-12-31 11           11               11
2736 2736 SANTA YNEZ VALLEY COTTAGE HOSPITAL 2050 VIBORG RD SOLVANG CA 93463 SANTA BARBARA (805) 688-6431 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6024650 -120.1266430 0   83 6 6083 42200   Central Santa Barbara County https://data.medicare.gov/resource/xubh-q36u/row-crjd-giis~8ixz 51331 648601 2019-05-31 2018-12-31 11           11               11
2768 2768 SANFORD CANTON-INWOOD MEDICAL CENTER - CAH 440 NORTH HIAWATHA DRIVE CANTON SD 57013 LINCOLN (605) 764-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3049440 -96.5572490 0   83 46 46083 43620   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-drz2_z7zb-tas3 431333 648483 2019-05-23 2018-12-31 11           11               11
4529 4529 PROVIDENCE VALDEZ MEDICAL CENTER PO BOX 550 VALDEZ AK 99686 VALDEZ-CORDOVA (907) 835-2249 Critical Access Hospitals Government - Local TRUE 61.1364781 -146.3458866 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-2ygw.872k~d2en 21301 652057 2019-05-30 2018-12-31 11           11       10       21
129 129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
130 130 BROADDUS HOSPITAL ASSOCIATION, INC 1 HEALTHCARE DRIVE MANSFIELD HILL PHILIPPI WV 26416 BARBOUR (304) 457-1760 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.1528870 -80.0440910 0   1 54 54001         https://data.medicare.gov/resource/xubh-q36u/row-njqv~ij6d.yec2 511300 650429 2019-05-31 2018-12-31 12           12       60       72
172 172 ANDERSON COUNTY HOSPITAL 421 S MAPLE GARNETT KS 66032 ANDERSON (785) 204-4000 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.2801200 -95.2493000 0   3 20 20003         https://data.medicare.gov/resource/xubh-q36u/row-3ktx.x5ze~zgrj 171316 648620 2019-05-24 2018-12-31 12           12           36   48
221 221 INSTITUTE FOR ORTHOPAEDIC SURGERY 801 MEDICAL DRIVE, SUITE B LIMA OH 45804 ALLEN (419) 224-7586 Acute Care Hospitals Proprietary FALSE 40.6985860 -84.0864770 0   3 39 39003 30620 Lima-Van Wert-Celina, OH Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kbua_iifb.k5nj 360263 649649 2019-06-03 2018-12-31 12           12               12
1322 1322 COMANCHE COUNTY HOSPITAL 2ND & FRISCO STREET COLDWATER KS 67029 COMANCHE (620) 582-2144 Critical Access Hospitals Government - Local TRUE 37.2679460 -99.3321152 1 GEOMETRIC_CENTER 33 20 20033         https://data.medicare.gov/resource/xubh-q36u/row-uexi-7hwn_3fpb 171312 648915 2019-05-29 2018-12-31 12           12               12
1407 1407 NORTHWOOD DEACONESS HEALTH CENTER PO BOX 190 NORTHWOOD ND 58267 GRAND FORKS (701) 587-6060 Critical Access Hospitals Voluntary non-profit - Church TRUE 47.7343845 -97.5683593 1 ROOFTOP 35 38 38035 24220   Central Grand Forks County https://data.medicare.gov/resource/xubh-q36u/row-r4gy_k4h8~nujf 351312 646643 2019-04-15 2018-12-31 12           12       45       57
1726 1726 GRAND RIVER MEDICAL CENTER 501 AIRPORT RD RIFLE CO 81650 GARFIELD (970) 625-1510 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.5225870 -107.7720100 0   45 8 8045 24060 Edwards-Glenwood Springs, CO Central Garfield County https://data.medicare.gov/resource/xubh-q36u/row-gvuq~c8qg.v3zk 61317 649076 2019-05-23 2018-12-31 12           12       49       61
1780 1780 EDWARDS COUNTY HOSPITAL 620 WEST EIGHTH STREET KINSLEY KS 67547 EDWARDS (620) 659-3621 Critical Access Hospitals Government - Local TRUE 37.9207150 -99.4194310 0   47 20 20047         https://data.medicare.gov/resource/xubh-q36u/row-g83e~5vmg-b2c4 171317 648916 2019-05-28 2018-12-31 12           12 10             22
1874 1874 FAULKTON AREA MEDICAL CENTER 1300 OAK STREET POST OFFICE BOX 100 FAULKTON SD 57438 FAULK (605) 598-6262 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.0299990 -99.1315700 0   49 46 46049         https://data.medicare.gov/resource/xubh-q36u/row-9wwa-ei6u.pihr 431301 646881 2019-04-25 2018-12-31 12           12               12
2341 2341 ANIMAS SURGICAL HOSPITAL, LLC 575 RIVERGATE LN DURANGO CO 81301 LA PLATA (970) 247-3537 Acute Care Hospitals Physician TRUE 37.2488890 -107.8707740 0   67 8 8067 20420   Central La Plata County https://data.medicare.gov/resource/xubh-q36u/row-twp9-b345.bypu 60117 650115 2019-05-31 2018-12-31 12           12               12
2908 2908 NORTH VALLEY HEALTH CENTER 300 WEST GOOD SAMARITAN DRIVE WARREN MN 56762 MARSHALL (218) 745-4211 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1927360 -96.7743980 0   89 27 27089         https://data.medicare.gov/resource/xubh-q36u/row-5hr9-apeq-pgtf 241337 651012 2019-06-04 2018-12-31 12           12               12
2947 2947 KANSAS CITY ORTHOPAEDIC INSTITUTE 3651 COLLEGE BLVD LEAWOOD KS 66211 JOHNSON (913) 319-7633 Acute Care Hospitals Physician FALSE 38.9275490 -94.6282350 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-s6dg~iufq_ybuc 170188 649225 2019-05-31 2018-12-31 12           12               12
3399 3399 SURGICAL HOSPITAL OF OKLAHOMA, LLC 100 SOUTHEAST 59TH STREET OKLAHOMA CITY OK 73129 OKLAHOMA (405) 634-9300 Acute Care Hospitals Physician TRUE 35.4062250 -97.5093160 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-drs8-u5z4.yfq6 370201 649812 2019-05-31 2018-12-31 12           12               12
3732 3732 PIONEER MEMORIAL HOSPITAL - CAH 315 N WASHINGTON AVE POST OFFICE BOX 368 VIBORG SD 57070 TURNER (605) 326-5161 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.1700926 -97.0818666 1 ROOFTOP 125 46 46125 43620   Outlying Turner County https://data.medicare.gov/resource/xubh-q36u/row-eg2b-5945~rjby 431328 652385 2019-07-02 2018-12-31 12           12       52       64
3855 3855 GRISELL MEMORIAL HOSPITAL 210 SOUTH VERMONT AVENUE RANSOM KS 67572 NESS (785) 731-2231 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.6367100 -99.9315460 0   135 20 20135         https://data.medicare.gov/resource/xubh-q36u/row-m6sz.xvcu-brgm 171300 649227 2019-05-28 2018-12-31 12           12           30   42
4058 4058 SCHOOLCRAFT MEMORIAL HOSPITAL 7870W US HIGHWAY 2 MANISTIQUE MI 49854 SCHOOLCRAFT (906) 341-3200 Critical Access Hospitals Government - Local TRUE 45.9449630 -86.2757160 0   153 26 26153         https://data.medicare.gov/resource/xubh-q36u/row-i54k_s479.sfn4 231303 650833 2019-06-06 2018-12-31 12           12               12
4302 4302 BAYLOR SCOTT AND WHITE SURGICAL HOSPITAL AT SHERMA 3601 CALAIS DRIVE SHERMAN TX 75090 GRAYSON (903) 813-3728 Acute Care Hospitals Physician TRUE 33.6768600 -96.6025270 0   181 48 48181 43300 Dallas-Fort Worth, TX-OK Central Grayson County https://data.medicare.gov/resource/xubh-q36u/row-4y3f.tmsq.cez5 670076 648878 2019-05-28 2018-12-31 12           12               12
4426 4426 FIRST TEXAS HOSPITAL 9922 LOUETTA RD HOUSTON TX 77070 HARRIS (844) 264-1435 Acute Care Hospitals Proprietary TRUE 30.0008390 -95.5608680 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-t68p~4ggy.94di 670118 649157 2019-05-30 2018-12-31 12           12               12
4631 4631 LILLIAN M HUDSPETH MEMORIAL HOSPITAL 308 HUDSPETH SONORA TX 76950 SUTTON (325) 387-2521 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.5637580 -100.6348700 0   435 48 48435         https://data.medicare.gov/resource/xubh-q36u/row-i9e9_qde3.um4r 451324 652847 2019-08-21 2018-12-31 12           12               12
1450 1450 OAKLEAF SURGICAL HOSPITAL 1000 OAKLEAF WAY ALTOONA WI 54720 EAU CLAIRE (715) 831-8130 Acute Care Hospitals Physician FALSE 44.8150020 -91.4517640 0   35 55 55035 20740 Eau Claire-Menomonie, WI Central Eau Claire County https://data.medicare.gov/resource/xubh-q36u/row-4tiq~2hj5~t8xv 520196 650624 2019-05-30 2018-12-31 13           13               13
1502 1502 WEST COVINA MEDICAL CENTER, INC 725 S ORANGE AVE WEST COVINA CA 91790 LOS ANGELES (626) 338-8481 Acute Care Hospitals Proprietary FALSE 34.0709280 -117.9441660 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-mrqt_jczt_crz9 50096 652580 2019-05-30 2018-12-31 13           13       33       46
2698 2698 SATANTA DISTRICT HOSPITAL CHEYENNE & APACHE SATANTA KS 67870 HASKELL (620) 649-2761 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4374237 -100.9856235 1 GEOMETRIC_CENTER 81 20 20081         https://data.medicare.gov/resource/xubh-q36u/row-5zm3-qnsy-hby4 171324 648917 2019-05-28 2018-12-31 13           13           44   57
3165 3165 SOUTHEAST MICHIGAN SURGICAL HOSPITAL 21230 DEQUINDRE ROAD WARREN MI 48091 MACOMB (586) 427-1000 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.4513950 -83.0835600 0   99 26 26099 19820 Detroit-Warren-Ann Arbor, MI Central Macomb County https://data.medicare.gov/resource/xubh-q36u/row-n5cw~k8mz~eeh4 230264 650280 2019-06-03 2018-12-31 13           13               13
4135 4135 MANHATTAN SURGICAL HOSPITAL LLC 1829 COLLEGE AVENUE MANHATTAN KS 66502 RILEY (785) 776-5100 Acute Care Hospitals Physician FALSE 39.2028260 -96.5981830 0   161 20 20161 31740 Manhattan-Junction City, KS Central Riley County https://data.medicare.gov/resource/xubh-q36u/row-5vw9~wxt5.eejp 170190 648618 2019-05-24 2018-12-31 13           13               13
4530 4530 CORDOVA COMMUNITY MEDICAL CENTER PO BOX 160 - 602 CHASE AVENUE CORDOVA AK 99574 VALDEZ-CORDOVA (907) 424-8000 Critical Access Hospitals Government - Local TRUE 60.5413354 -145.7505310 1 ROOFTOP 261 2 2261         https://data.medicare.gov/resource/xubh-q36u/row-kscp_6dza~rvey 21307 650633 2019-05-30 2018-12-31 13           13       10       23
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
795 795 BATH COMMUNITY HOSPITAL 106 PARK DRIVE- PO DRAWER Z HOT SPRINGS VA 24445 BATH (540) 839-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9938900 -79.8309590 0   17 51 51017         https://data.medicare.gov/resource/xubh-q36u/row-36k3~dwrj~zvyd 491300 650420 2019-05-31 2018-12-31 14           14               14
998 998 MINNEOLA DISTRICT HOSPITAL NBR 2 212 MAIN MINNEOLA KS 67865 FORD (620) 885-4264 Critical Access Hospitals Government - Hospital District or Authority TRUE 37.4415040 -100.0138120 0   25 20 20025         https://data.medicare.gov/resource/xubh-q36u/row-qfsy_k4qi-ia9b 171368 651617 2019-06-24 2018-12-31 14           14           36   50
1116 1116 HAMPSHIRE MEMORIAL HOSPITAL 363 SUNRISE BOULEVARD ROMNEY WV 26757 HAMPSHIRE (304) 822-4561 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3320570 -78.6999130 0   27 54 54027 49020 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Outlying Hampshire County https://data.medicare.gov/resource/xubh-q36u/row-hrq8-hhfd_c47u 511311 648371 2019-05-09 2018-12-31 14           14       30       44
1622 1622 KLICKITAT VALLEY HOSPITAL 310 SOUTH ROOSEVELT GOLDENDALE WA 98620 KLICKITAT (509) 773-4022 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.8202390 -120.8122990 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-hemh_kxtf-bs6t 501316 649846 2019-06-03 2018-12-31 14           14               14
1623 1623 SKYLINE HOSPITAL 211 SKYLINE DRIVE WHITE SALMON WA 98672 KLICKITAT (509) 491-1101 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.7224740 -121.4699210 0   39 53 53039         https://data.medicare.gov/resource/xubh-q36u/row-ff7m.q2hb.cpdx 501315 652445 2019-06-27 2018-12-31 14           14               14
2254 2254 SANFORD JACKSON MEDICAL CENTER 1430 NORTH HIGHWAY JACKSON MN 56143 JACKSON (507) 847-2420 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6237230 -95.0045160 0   63 27 27063         https://data.medicare.gov/resource/xubh-q36u/row-xb4e.uhr4_fqc2 241315 649271 2019-05-28 2018-12-31 14           14               14
3174 3174 FIRST CARE HEALTH CENTER 115 VIVIAN ST PARK RIVER ND 58270 WALSH (701) 284-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.3992620 -97.7436790 0   99 38 38099         https://data.medicare.gov/resource/xubh-q36u/row-yjef.zes7.d4mf 351326 647924 2019-05-16 2018-12-31 14           14               14
3191 3191 SUTTER SURGICAL HOSPITAL - NORTH VALLEY 455 PLUMAS BLVD YUBA CITY CA 95991 SUTTER (530) 749-5700 Acute Care Hospitals Physician FALSE 39.1321670 -121.6136030 0   101 6 6101 49700 Sacramento-Roseville, CA Central Sutter County https://data.medicare.gov/resource/xubh-q36u/row-rm5f.jnvd.d3k4 50766 651185 2019-06-03 2018-12-31 14           14               14
3567 3567 CLEVELAND AREA HOSPITAL 1401 WEST PAWNEE CLEVELAND OK 74020 PAWNEE (918) 358-2501 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.3098820 -96.4811210 0   117 40 40117 46140 Tulsa-Muskogee-Bartlesville, OK Outlying Pawnee County https://data.medicare.gov/resource/xubh-q36u/row-mn7t-r33n-bhn9 371320 647932 2019-05-20 2018-12-31 14           14               14
3730 3730 ADVANCED SURGICAL HOSPITAL 100 TRICH DRIVE WASHINGTON PA 15301 WASHINGTON (724) 884-0710 Acute Care Hospitals Physician FALSE 40.1567230 -80.2805360 0   125 42 42125 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-ni2v.da26_jxgn 390323 648978 2019-05-29 2018-12-31 14           14               14
3877 3877 COOK HOSPITAL 10 SE FIFTH ST COOK MN 55723 ST. LOUIS (218) 666-5945 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.8534680 -92.6800320 0   137 27 27137 20260   Central St. Louis County https://data.medicare.gov/resource/xubh-q36u/row-buxd.3b5c~u3h4 241312 649042 2019-05-21 2018-12-31 14           14       28       42
4049 4049 FISHER COUNTY HOSPITAL DISTRICT 774 STATE HIGHWAY 70 N ROTAN TX 79546 FISHER (325) 735-2256 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.8343420 -100.4354190 0   151 48 48151         https://data.medicare.gov/resource/xubh-q36u/row-zpz3-mc6s_tqpq 451313 652799 2019-08-21 2018-12-31 14           14               14
4125 4125 WINSTON MEDICAL CENTER & SWINGBED 17550 EAST MAIN STREET LOUISVILLE MS 39339 WINSTON (662) 779-5124 Acute Care Hospitals Proprietary TRUE 33.1242910 -89.0366710 0   159 28 28159         https://data.medicare.gov/resource/xubh-q36u/row-rwwj.hj8g_k82s 250027 649619 2019-05-29 2018-12-31 14           14 10     120       144
4413 4413 ALTUS BAYTOWN HOSPITAL 1404 W BAKER ROAD BAYTOWN TX 77521 HARRIS (281) 837-7600 Acute Care Hospitals Physician TRUE 29.7698160 -94.9801930 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-fa96~fa82_gfbn 670109 650629 2019-06-04 2018-12-31 14           14               14
4474 4474 CORNERSTONE REGIONAL HOSPITAL 2302 CORNERSTONE BOULEVARD EDINBURG TX 78539 HIDALGO (956) 618-4444 Acute Care Hospitals Proprietary TRUE 26.2630960 -98.1991640 0   215 48 48215 32580 McAllen-Edinburg, TX Central Hidalgo County https://data.medicare.gov/resource/xubh-q36u/row-wtje.zqmn.bcn4 450825 649141 2019-05-28 2018-12-31 14           14               14
4605 4605 IRAAN GENERAL HOSPITAL 600 HIGHWAY 349 NORTH IRAAN TX 79744 PECOS (432) 639-2575 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.9141890 -101.9066730 0   371 48 48371         https://data.medicare.gov/resource/xubh-q36u/row-gutj.3p8m~9z3e 451307 651245 2019-06-28 2018-12-31 14           14               14
4621 4621 SCHLEICHER COUNTY MEDICAL CENTER 102 NORTH US HIGHWAY 277 ELDORADO TX 76936 SCHLEICHER (325) 853-2507 Critical Access Hospitals Proprietary TRUE 30.8698690 -100.5903930 0   413 48 48413         https://data.medicare.gov/resource/xubh-q36u/row-ukk5-7d2r~gvs8 451304 649143 2019-05-21 2018-12-31 14           14               14
4662 4662 THROCKMORTON COUNTY MEMORIAL HOSPITAL 802 N MINTER AVENUE THROCKMORTON TX 76483 THROCKMORTON (940) 849-2151 Critical Access Hospitals Government - Local TRUE 33.1896520 -99.1772780 0   447 48 48447         https://data.medicare.gov/resource/xubh-q36u/row-ckdk-2pw4-m4du 451339 649839 2019-05-31 2018-12-31 14           14               14
376 376 ATRIUM HEALTH ANSON 2301 US HIGHWAY 74 WEST WADESBORO NC 28170 ANSON (704) 694-5131 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.9785320 -80.1096790 0   7 37 37007         https://data.medicare.gov/resource/xubh-q36u/row-mv5j_iuia_xbie 340084 650339 2019-05-30 2018-12-31 15           15               15

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