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 hospital_name descending

✎ 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
1292 1292 ZUNI COMPREHENSIVE COMMUNITY HEALTH CENTER ROUTE 301 NORTH B STREET ZUNI NM 87327 MCKINLEY (505) 782-4431 Acute Care Hospitals Government - Federal TRUE 35.0785445 -108.8119284 1 GEOMETRIC_CENTER 31 35 35031 23700   Central McKinley County https://data.medicare.gov/resource/xubh-q36u/row-bm92~a2re_rnct 320060 647300 2019-05-08 2018-09-30 27           27               27
2564 2564 ZUCKERBERG SAN FRANCISCO GENERAL HOSP & TRAUMA CTR 1001 POTRERO AVENUE SAN FRANCISCO CA 94110 SAN FRANCISCO (415) 206-8000 Acute Care Hospitals Government - Local TRUE 37.7561710 -122.4066080 0   75 6 6075 41860 San Jose-San Francisco-Oakland, CA Central San Francisco County https://data.medicare.gov/resource/xubh-q36u/row-zbv8_bttg_wjmw 50228 662022 2019-12-03 2019-06-30 213 58       13 284 83     30       397
1059 1059 YUMA REGIONAL MEDICAL CENTER 2400 SOUTH AVENUE A YUMA AZ 85364 YUMA (928) 336-7600 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.6838990 -114.6332380 0   27 4 4027 49740   Central Yuma County https://data.medicare.gov/resource/xubh-q36u/row-vbe2.gm3a_7tw7 30013 644624 2019-02-28 2018-09-30 344 42       20 406               406
3702 3702 YUMA DISTRICT HOSPITAL 1000 W 8TH AVE YUMA CO 80759 YUMA (970) 848-5405 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.1184450 -102.7366540 0   125 8 8125         https://data.medicare.gov/resource/xubh-q36u/row-b6fk_8yss~83cp 61315 649173 2019-05-28 2018-12-31 15           15               15
1885 1885 YUKON KUSKOKWIM DELTA REG HOSPITAL PO BOX 287 BETHEL AK 99559 BETHEL (907) 543-6300 Acute Care Hospitals Tribal TRUE 60.7922222 -161.7558334 1 GEOMETRIC_CENTER 50 2 2050         https://data.medicare.gov/resource/xubh-q36u/row-7gdx-n37w_5vx9 20018 651309 2019-07-02 2018-09-30 34           34               34
1267 1267 YORK HOSPITAL 15 HOSPITAL DRIVE YORK ME 3909 YORK (207) 363-4321 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.1427990 -70.6510940 0   31 23 23031 38860 Portland-Lewiston-South Portland, ME Central York County https://data.medicare.gov/resource/xubh-q36u/row-d4r3_kkiu_3jv2 200020 651001 2019-06-03 2018-12-31 61 5         66               66
3841 3841 YORK HOSPITAL 1001 SOUTH GEORGE STREET YORK PA 17403 YORK (717) 851-2345 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9466680 -76.7205350 0   133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-ki4m.53di-kxjd 390046 660013 2019-11-26 2019-06-30 418 60         522 63             585
4328 4328 YORK GENERAL HOSPITAL 2222 LINCOLN AVE YORK NE 68467 YORK (402) 362-6671 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.8824760 -97.5921090 1 ROOFTOP 185 31 31185         https://data.medicare.gov/resource/xubh-q36u/row-dn5r-dnwm.i2as 281336 642099 2019-01-22 2018-09-30 25           25       129       154
4431 4431 YOAKUM COUNTY HOSPITAL 412 MUSTANG AVENUE DENVER CITY TX 79323 YOAKUM (806) 592-2121 Critical Access Hospitals Government - Local TRUE 32.9683780 -102.8363910 0   501 48 48501         https://data.medicare.gov/resource/xubh-q36u/row-f6vr_y9ce-af6k 451308 659741 2019-11-25 2018-12-31 24           24               24
4547 4547 YOAKUM COMMUNITY HOSPITAL 1200 CARL RAMERT DRIVE YOAKUM TX 77995 LAVACA (361) 293-2321 Critical Access Hospitals Voluntary non-profit - Private TRUE 29.3066200 -97.1303060 0   285 48 48285         https://data.medicare.gov/resource/xubh-q36u/row-fd62_5vyv.n9wj 451346 660056 2019-11-21 2019-06-30 22 3         25               25
993 993 YAVAPAI REGIONAL MEDICAL CENTER 1003 WILLOW CREEK ROAD PRESCOTT AZ 86301 YAVAPAI (928) 445-2700 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.5593800 -112.4820650 0   25 4 4025 39140   Central Yavapai County https://data.medicare.gov/resource/xubh-q36u/row-rugm_x4ib~bga9 30012 647851 2019-05-15 2018-12-31 180 26         206               206
4143 4143 YALOBUSHA GENERAL HOSPITAL 630 SOUTH MAIN STREET WATER VALLEY MS 38965 YALOBUSHA (662) 473-1411 Acute Care Hospitals Government - Local FALSE 34.1307000 -89.6410130 0   161 28 28161         https://data.medicare.gov/resource/xubh-q36u/row-f4gk_jx8c-563i 250061 643906 2019-03-04 2018-09-30 26           26           122   148
410 410 YALE-NEW HAVEN HOSPITAL 20 YORK ST NEW HAVEN CT 6504 NEW HAVEN (203) 688-4242 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3042850 -72.9346890 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-vv7z~adrr_fj28 70022 644224 2019-02-27 2018-09-30 1020 50 30   38 19 1279 118 24   119       1540
2633 2633 YAKIMA VALLEY MEMORIAL HOSPITAL 2811 TIETON DRIVE YAKIMA WA 98902 YAKIMA (509) 575-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.5927270 -120.5503960 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-ctqg~gce3-w285 500036 651084 2019-06-03 2018-12-31 170 38         208 18         20   246
1916 1916 Womack AMC (FT Bragg) 2817 Reilly Road Fort Bragg NC 28307 CUMBERLAND (910) 907-9262 Acute Care - Department of Defense Department of Defense TRUE 35.1473370 -78.9973980 0   51 37 37051 22180 Fayetteville-Lumberton-Laurinburg, NC Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-jzah.iadr~a6gb                                      
4282 4282 Winn ACH (FT Stewart) 1061 Harmon Avenue Fort Stewart GA 31314 LIBERTY (912) 435-6633 Acute Care - Department of Defense Department of Defense TRUE 31.8712070 -81.5986720 0   179 13 13179 25980 Savannah-Hinesville-Statesboro, GA Central Liberty County https://data.medicare.gov/resource/xubh-q36u/row-4g37~3e4d.ctk3                                      
3927 3927 William Beaumont AMG (FT Bliss) 5005 N. Piedras St. El Paso TX 79920 EL PASO (915) 742-2121 Acute Care - Department of Defense Department of Defense TRUE 31.8222270 -106.4614620 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-7ye3-bwem.cixj                                      
2447 2447 Weed ACH (FT Irwin) 166 4th Street Fort Irwin CA 92310 SAN BERNARDINO (866) 957-9224 Acute Care - Department of Defense Department of Defense TRUE 35.2653150 -116.6872950 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-s87n-qicq_idrk                                      
1271 1271 Walter Reed National Military Med Cen 8901 Rockville Pike Bethesda MD 20889 MONTGOMERY (301) 295-4000 Acute Care - Department of Defense Department of Defense TRUE 38.9994900 -77.0968010 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-9f6g_giqd.6t34                                      
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
1054 1054 WYOMING MEDICAL CENTER 1233 EAST 2ND ST CASPER WY 82601 NATRONA (307) 577-7201 Acute Care Hospitals Government - Local TRUE 42.8487180 -106.3087530 0   25 56 56025 16220   Central Natrona County https://data.medicare.gov/resource/xubh-q36u/row-sk2z.s7zk-vge8 530012 662631 2019-11-27 2019-06-30 198 14         212               212
3651 3651 WYOMING COUNTY COMMUNITY HOSPITAL 400 NORTH MAIN STREET WARSAW NY 14569 WYOMING (585) 786-2233 Acute Care Hospitals Government - Local TRUE 42.7534470 -78.1325330 0   121 36 36121         https://data.medicare.gov/resource/xubh-q36u/row-4dfp-x42q-zvqb 330008 650734 2019-05-31 2018-12-31 45 5         50 12     138       200
1798 1798 WYCKOFF HEIGHTS MEDICAL CENTER 374 STOCKHOLM STREET BROOKLYN NY 11237 KINGS (718) 963-7272 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7046990 -73.9176480 0   47 36 36047 35620 New York-Newark, NY-NJ-CT-PA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-qdj3.2dnc_rxqm 330221 650874 2019-06-26 2018-12-31 231 16       10 257               257
4270 4270 WYANDOT MEMORIAL HOSPITAL 885 NORTH SANDUSKY AVENUE UPPER SANDUSKY OH 43351 WYANDOT (419) 294-4991 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.8418840 -83.2807200 0   175 39 39175         https://data.medicare.gov/resource/xubh-q36u/row-7m8m~3eqa_t4vr 361329 649655 2019-06-03 2018-12-31 19   5       24               24
2651 2651 WRIGHT MEMORIAL HOSPITAL 191 IOWA BOULEVARD TRENTON MO 64683 GRUNDY (660) 359-5621 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.0682750 -93.5799360 0   79 29 29079         https://data.medicare.gov/resource/xubh-q36u/row-ewb5-qskq-99ee 261309 650289 2019-05-31 2018-12-31 21           21               21
3703 3703 WRAY COMMUNITY DISTRICT HOSPITAL 1017 WEST 7TH ST WRAY CO 80758 YUMA (970) 332-4811 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0754050 -102.2346600 0   125 8 8125         https://data.medicare.gov/resource/xubh-q36u/row-jpdk~yrgm-qq54 61309 649710 2019-06-03 2018-12-31 16           16               16
4227 4227 WOOSTER COMMUNITY HOSPITAL 1761 BEALL AVENUE WOOSTER OH 44691 WAYNE (330) 263-8100 Acute Care Hospitals Government - Local TRUE 40.8207130 -81.9342470 0   169 39 39169 49300   Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-bh63_heg3-ryxh 360036 649308 2019-06-03 2018-12-31 90 14         104   10   22       136
1863 1863 WOODS AT PARKSIDE,THE 349 OLDE RIDENOUR ROAD COLUMBUS OH 43230 FRANKLIN (614) 471-2552 Acute Care Hospitals Proprietary FALSE 40.0268200 -82.8811560 0   49 39 39049 18140 Columbus-Marion-Zanesville, OH Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-4avu~kmf5~3quj 360247 649648 2019-06-03 2018-12-31 12         38 50               50
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
3458 3458 WOODLAND MEMORIAL HOSPITAL 1325 COTTONWOOD STREET WOODLAND CA 95695 YOLO (530) 662-3961 Acute Care Hospitals Voluntary non-profit - Other TRUE 38.6643440 -121.7934030 0   113 6 6113 40900 Sacramento-Roseville, CA Outlying Yolo County https://data.medicare.gov/resource/xubh-q36u/row-d6ip_hh3b.rimz 50127 659473 2019-11-18 2019-01-31 69 8         77 31             108
320 320 WOODLAND HEIGHTS MEDICAL CENTER 505 SOUTH JOHN REDDITT DRIVE LUFKIN TX 75904 ANGELINA (936) 634-8311 Acute Care Hospitals Proprietary TRUE 31.3277370 -94.7561390 0   5 48 48005 31260   Central Angelina County https://data.medicare.gov/resource/xubh-q36u/row-2twc-7b9d-f8nh 450484 649671 2019-05-31 2018-12-31 115 15         145               145
1805 1805 WOODHULL MEDICAL & MENTAL HEALTH CENTER 760 BROADWAY BROOKLYN NY 11206 KINGS (718) 963-8100 Acute Care Hospitals Government - Local TRUE 40.7005120 -73.9415570 0   47 36 36047 35620 New York-Newark, NY-NJ-CT-PA Central Kings County https://data.medicare.gov/resource/xubh-q36u/row-dr4w~e5x7-guxp 330396 661754 2019-12-03 2019-06-30 204 24       10 238 133             371
4260 4260 WOOD COUNTY HOSPITAL 950 WEST WOOSTER STREET BOWLING GREEN OH 43402 WOOD (419) 354-8900 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3738870 -83.6656340 0   173 39 39173 45780 Toledo-Port Clinton, OH Central Wood County https://data.medicare.gov/resource/xubh-q36u/row-k7h7-cmi9~sjc4 360029 661587 2019-12-02 2019-06-30 93 10         103               103
4246 4246 WOMEN'S HOSPITAL THE 4199 GATEWAY BLVD NEWBURGH IN 47630 WARRICK (812) 842-4200 Acute Care Hospitals Proprietary TRUE 37.9735480 -87.4491090 0   173 18 18173 21780   Central Warrick County https://data.medicare.gov/resource/xubh-q36u/row-rn9t.t87t.eat4 150149 648611 2019-05-24 2018-12-31 50 24         74               74
390 390 WOMEN & INFANTS HOSPITAL OF RHODE ISLAND 101 DUDLEY STREET PROVIDENCE RI 2905 PROVIDENCE (401) 274-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8102000 -71.4115620 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-zi7i_8chg~f7hp 410010 644177 2019-02-28 2018-09-30 167         80 247               247
4437 4437 WOMANS HOSPITAL OF TEXAS,THE 7600 FANNIN HOUSTON TX 77054 HARRIS (713) 790-1234 Acute Care Hospitals Proprietary TRUE 29.6929770 -95.4010900 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-pvha_dpmv~q2t2 450674 652609 2019-07-31 2019-02-28 253 4         257               257
1330 1330 WOMANS HOSPITAL 100 WOMAN'S WAY BATON ROUGE LA 70817 E. BATON ROUGE (225) 927-1300 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4088600 -91.0310200 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-n9vu.wxmz_qfwr 190128 644733 2019-03-04 2018-09-30 140 4       84 228               228
503 503 WITHAM HEALTH SERVICES 2605 N LEBANON ST LEBANON IN 46052 BOONE (765) 485-8000 Acute Care Hospitals Government - Local TRUE 40.0769090 -86.4752090 0   11 18 18011 26900 Indianapolis-Carmel-Muncie, IN Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-gfq5-5jsq-rtmb 150104 649208 2019-05-31 2018-12-31 60 8         68 10     18       96
1918 1918 WISHEK COMMUNITY HOSPITAL 1007 4TH AVE S WISHEK ND 58495 MCINTOSH (701) 452-2326 Critical Access Hospitals Government - Local TRUE 46.2551230 -99.5515380 0   51 38 38051         https://data.medicare.gov/resource/xubh-q36u/row-zinj~5aa6.fhse 351321 648453 2019-05-20 2018-12-31 24           24               24
4707 4707 WISE REGIONAL HEALTH SYSTEM 609 MEDICAL CENTER DRIVE DECATUR TX 76234 WISE (940) 627-5921 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2202630 -97.5931070 0   497 48 48497 19100 Dallas-Fort Worth, TX-OK Outlying Wise County https://data.medicare.gov/resource/xubh-q36u/row-cn54-zrya.j3rq 450271 649353 2019-05-30 2018-12-31 60 21         81 20 15           116
4641 4641 WISE HEALTH SYSTEM 3200 NORTH TARRANT PARKWAY FORT WORTH TX 76177 TARRANT (817) 502-7300 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8974340 -97.3122990 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-nkp3_nyc5_hqkg 670116 650433 2019-05-30 2018-12-31 36           36               36
2175 2175 WIREGRASS MEDICAL CENTER 1200 W MAPLE AVENUE GENEVA AL 36340 GENEVA (334) 684-3655 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0480630 -85.8908370 0   61 1 1061 20020 Dothan-Enterprise-Ozark, AL Outlying Geneva County https://data.medicare.gov/resource/xubh-q36u/row-6zer-5ewe_shgk 10062 644199 2019-03-01 2018-09-30 67 6         73 16     96       185
3299 3299 WINTER HAVEN HOSPITAL 200 AVE F NE WINTER HAVEN FL 33881 POLK (863) 293-1121 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.0276690 -81.7267460 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-v7nh_nrtk.gdm4 100052 649883 2019-05-31 2018-12-31 417 44       15 476               476
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
4223 4223 WINONA HEALTH SERVICES 855 MANKATO AVENUE WINONA MN 55987 WINONA (507) 454-3650 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0330160 -91.6221360 0   169 27 27169 49100   Central Winona County https://data.medicare.gov/resource/xubh-q36u/row-krgn_vcn8~g9tk 240044 641593 2019-01-28 2018-09-30 33 8         41               41
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
3695 3695 WINNER REGIONAL HEALTHCARE CENTER - CAH 745 EAST 8TH STREET WINNER SD 57580 TRIPP (605) 842-7100 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3709470 -99.8476170 0   123 46 46123         https://data.medicare.gov/resource/xubh-q36u/row-8vjy-k644_c637 431334 650611 2019-05-30 2018-12-31 25           25       80       105
3750 3750 WINN PARISH MEDICAL CENTER 301 W BOUNDARY AVE WINNFIELD LA 71483 WINN (318) 648-3000 Acute Care Hospitals Proprietary TRUE 31.9249790 -92.6451390 0   127 22 22127         https://data.medicare.gov/resource/xubh-q36u/row-tecb_9uuz_3xte 190090 653892 2019-09-09 2019-03-31 41 5         46               46
4706 4706 WINKLER COUNTY MEMORIAL HOSPITAL 821 JEFFEE DRIVE KERMIT TX 79745 WINKLER (432) 586-5865 Critical Access Hospitals Government - Local TRUE 31.8497390 -103.0899160 0   495 48 48495         https://data.medicare.gov/resource/xubh-q36u/row-qbhw-92m9~uia9 451314 643975 2019-02-28 2018-09-30 19           19               19
1338 1338 WINDOM AREA HEALTH 2150 HOSPITAL DRIVE, PO BOX 339 WINDOM MN 56101 COTTONWOOD (507) 831-2400 Critical Access Hospitals Government - Local TRUE 43.8785870 -95.1136590 0   33 27 27033         https://data.medicare.gov/resource/xubh-q36u/row-9bd7-ibcv.unjw 241332 654451 2019-09-27 2019-04-30 18           18               18
677 677 WINDHAM COMM MEM HOSP & HATCH HOSP 112 MANSFIELD AVENUE WILLIMANTIC CT 6226 WINDHAM (860) 456-9116 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7165690 -72.2240680 0   15 9 9015 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Windham County https://data.medicare.gov/resource/xubh-q36u/row-b3g5_mb4h~7bid 70021 645238 2019-03-01 2018-09-30 44           44               44
4766 4766 WINCHESTER MEDICAL CENTER 1840 AMHERST ST WINCHESTER VA 22601 WINCHESTER CITY (540) 536-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.1916000 -78.1930880 0   840 51 51840 49020 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Winchester city https://data.medicare.gov/resource/xubh-q36u/row-t2dw.tazy_6ahh 490005 645196 2019-02-28 2018-09-30 341 48         389 36 30           455
749 749 WINCHESTER HOSPITAL 41 HIGHLAND AVENUE WINCHESTER MA 1890 MIDDLESEX (781) 729-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.4654960 -71.1214080 0   17 25 25017 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Middlesex County https://data.medicare.gov/resource/xubh-q36u/row-q8fw-g6i4-ywa7 220105 644740 2019-02-27 2018-09-30 179 10         205               205
4303 4303 WILSON N JONES REGIONAL MEDICAL CENTER 500 N HIGHLAND AVENUE SHERMAN TX 75091 GRAYSON (903) 870-4611 Acute Care Hospitals Proprietary TRUE 33.6356360 -96.6228510 0   181 48 48181 43300 Dallas-Fort Worth, TX-OK Central Grayson County https://data.medicare.gov/resource/xubh-q36u/row-6xh6~585b.48af 450469 649833 2019-06-03 2018-12-31 204 10         214 12             226
4023 4023 WILSON MEMORIAL HOSPITAL 915 WEST MICHIGAN STREET SIDNEY OH 45365 SHELBY (937) 498-5405 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2879320 -84.1690350 0   149 39 39149 43380 Dayton-Springfield-Sidney, OH Central Shelby County https://data.medicare.gov/resource/xubh-q36u/row-s76w-rug3_cgsv 360013 649305 2019-06-03 2018-12-31 54 7         61 10             71
4383 4383 WILSON MEDICAL CENTER 1705 S TARBORO ST WILSON NC 27893 WILSON (252) 399-8040 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7205240 -77.9440470 0   195 37 37195 48980 Rocky Mount-Wilson-Roanoke Rapids, NC Central Wilson County https://data.medicare.gov/resource/xubh-q36u/row-674m.zg3x~pbew 340126 652665 2019-08-02 2019-02-28 256 14         270 24             294
4449 4449 WILSON MEDICAL CENTER REECE CAMPUS 2600 OTTAWA ROAD NEODESHA KS 66757 WILSON (620) 325-2611 Critical Access Hospitals Government - Local TRUE 37.4085290 -95.7082419 1 ROOFTOP 205 20 20205         https://data.medicare.gov/resource/xubh-q36u/row-fh4a~9srx~xwnp 171344 649229 2019-05-30 2018-12-31 15           15               15
3788 3788 WILMINGTON TREATMENT CENTER 2520 TROY DRIVE WILMINGTON NC 28401 NEW HANOVER (910) 762-2727 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.1949000 -77.9285490 0   129 37 37129 48900   Central New Hanover County https://data.medicare.gov/resource/xubh-q36u/row-bs3v-r4pw_3qk9 340168 646450 2019-04-15 2018-12-31 92           92               92
4571 4571 WILLS MEMORIAL HOSPITAL 120 GORDON STREET WASHINGTON GA 30673 WILKES (706) 678-9212 Critical Access Hospitals Government - Hospital District or Authority TRUE 33.7293020 -82.7423880 0   317 13 13317         https://data.medicare.gov/resource/xubh-q36u/row-xbea-eh76-aa8t 111325 654422 2019-09-23 2019-04-30 25           25               25
3233 3233 WILLS EYE HOSPITAL 840 WALNUT STREET PHILADELPHIA PA 19107 PHILADELPHIA (215) 440-3100 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9482710 -75.1557000 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-nxn5~vwjj_bn3j 390331 660449 2019-12-03 2019-06-30 4           4               4
737 737 WILLIS KNIGHTON MEDICAL CENTER, INC 2600 GREENWOOD ROAD SHREVEPORT LA 71103 CADDO (318) 212-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.4839230 -93.7787480 0   17 22 22017 43340   Central Caddo Parish https://data.medicare.gov/resource/xubh-q36u/row-843s.yxjw_fv2n 190111 644278 2019-02-28 2018-09-30 579 74       50 711 34 30   24       799
2724 2724 WILLIAMSPORT REGIONAL MEDICAL CENTER 700 HIGH STREET WILLIAMSPORT PA 17701 LYCOMING (570) 321-2389 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.2454700 -77.0144320 0   81 42 42081 48700 Williamsport-Lock Haven, PA Central Lycoming County https://data.medicare.gov/resource/xubh-q36u/row-r8vh~rwtx.ueje 390045 660853 2019-12-04 2019-06-30 199 28         227   28           255
2172 2172 WILLIAMSON MEMORIAL HOSPITAL 859 ALDERSON STREET WILLIAMSON WV 25661 MINGO (304) 235-2500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6782370 -82.2720310 0   59 54 54059         https://data.medicare.gov/resource/xubh-q36u/row-ieg8-kqsx_5d2s 510077 645804 2019-03-06 2018-09-30 21 6         27               27
4341 4341 WILLIAMSON MEDICAL CENTER 4321 CAROTHERS PARKWAY FRANKLIN TN 37067 WILLIAMSON (615) 435-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 35.9166840 -86.8170470 0   187 47 47187 34980 Nashville-Davidson--Murfreesboro, TN Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-56fd~fukj-xja8 440029 654600 2019-09-30 2019-06-30 157 28         185               185
2925 2925 WILLIAMSBURG REGIONAL HOSPITAL 500 NELSON BOULEVARD KINGSTREE SC 29556 WILLIAMSBURG (843) 355-8888 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6606660 -79.8202390 0   89 45 45089         https://data.medicare.gov/resource/xubh-q36u/row-7x78.i9ew-8k26 421303 645445 2019-03-04 2018-09-30 21 4         25               25
482 482 WILLIAM W BACKUS HOSPITAL 326 WASHINGTON ST NORWICH CT 6360 NEW LONDON (860) 889-8331 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.5434020 -72.0867470 0   11 9 9011 35980 Hartford-West Hartford, CT Central New London County https://data.medicare.gov/resource/xubh-q36u/row-x7iv~8mww_raqd 70024 645051 2019-02-28 2018-09-30 153 12         165 18             183
1389 1389 WILLIAM NEWTON HOSPITAL 1300 EAST FIFTH AVENUE WINFIELD KS 67156 COWLEY (620) 221-2300 Critical Access Hospitals Government - Local TRUE 37.2446490 -96.9824700 0   35 20 20035 11680 Wichita-Arkansas City-Winfield, KS Central Cowley County https://data.medicare.gov/resource/xubh-q36u/row-m266-eq4z.krik 171383 650583 2019-06-04 2018-12-31 19 2         21               21
1344 1344 WILLIAM BEE RIRIE HOSPITAL 1500 AVENUE H ELY NV 89301 WHITE PINE (775) 289-3001 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.2560650 -114.8600860 0   33 32 32033         https://data.medicare.gov/resource/xubh-q36u/row-xg87~7vrt.qaws 291302 662548 2019-11-27 2019-06-30 25           25               25
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
2484 2484 WILLAMETTE VALLEY MEDICAL CENTER 2700 SE STRATUS AVE. MCMINNVILLE OR 97128 YAMHILL (503) 472-6131 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.2003100 -123.1652300 0   71 41 41071 38900 Portland-Vancouver-Salem, OR-WA Outlying Yamhill County https://data.medicare.gov/resource/xubh-q36u/row-uqc6-c9i9_jkxa 380071 648975 2019-05-29 2018-12-31 43 7         50 10             60
2660 2660 WILKES-BARRE GENERAL HOSPITAL 575 NORTH RIVER STREET WILKES-BARRE PA 18764 LUZERNE (570) 829-8111 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.2582610 -75.8681650 0   79 42 42079 42540   Central Luzerne County https://data.medicare.gov/resource/xubh-q36u/row-jy6y.9gqv-dbyu 390137 659527 2019-11-25 2019-06-30 228 30         258   19           277
4373 4373 WILKES REGIONAL MEDICAL CENTER 1370 WEST D ST NORTH WILKESBORO NC 28659 WILKES (336) 651-8100 Acute Care Hospitals Government - Local TRUE 36.1584650 -81.1570130 0   193 37 37193 35900   Central Wilkes County https://data.medicare.gov/resource/xubh-q36u/row-mugx~rcjs~9jqq 340064 661369 2019-12-02 2019-06-30 85 8         93       10       103
349 349 WILCOX MEMORIAL HOSPITAL 3-3420 KUHIO HIGHWAY LIHUE HI 96766 KAUAI (808) 245-1103 Acute Care Hospitals Government - Federal TRUE 21.9870430 -159.3661980 0   7 15 15007 28180   Central Kauai County https://data.medicare.gov/resource/xubh-q36u/row-9k2j.d4pk.dvnd 120014 662037 2019-11-26 2019-06-30 65 7         72               72
4698 4698 WILBARGER GENERAL HOSPITAL 920 HILLCREST DR VERNON TX 76384 WILBARGER (940) 552-9351 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1594190 -99.3133300 0   487 48 48487 46900   Central Wilbarger County https://data.medicare.gov/resource/xubh-q36u/row-5iha_7mw4.8q3u 450584 643852 2019-02-28 2018-09-30 47           47               47
573 573 WICKENBURG COMMUNITY HOSPITAL 520 ROSE LANE WICKENBURG AZ 85390 MARICOPA (928) 684-5421 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.9780560 -112.7388250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mqi4.ug34.a4ib 31300 649069 2019-06-03 2018-12-31 19           19               19
4445 4445 WICHITA COUNTY HEALTH CENTER 211 E EARL STREET LEOTI KS 67861 WICHITA (620) 375-2233 Critical Access Hospitals Government - Local TRUE 38.4761960 -101.3556100 0   203 20 20203         https://data.medicare.gov/resource/xubh-q36u/row-eaqz.qgdk-wv8z 171306 651274 2019-06-11 2018-12-31 25           25           15   40
1479 1479 WHITTIER HOSPITAL MEDICAL CENTER 9080 COLIMA RD WHITTIER CA 90605 LOS ANGELES (562) 945-3561 Acute Care Hospitals Proprietary TRUE 33.9507480 -118.0051140 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-4rmv_824x.pbwt 50735 657693 2018-12-03 2018-06-30 140 16         156       22       178
2585 2585 WHITMAN HOSPITAL AND MEDICAL CENTER 1200 WEST FAIRVIEW COLFAX WA 99111 WHITMAN (509) 397-3435 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.8689190 -117.3750120 0   75 53 53075 39420 Pullman-Moscow, WA-ID Central Whitman County https://data.medicare.gov/resource/xubh-q36u/row-rc2f_yynj.hvxs 501327 652125 2019-05-30 2018-12-31 25           25               25
3645 3645 WHITFIELD MEDICAL SURGICAL HOSPITAL 3550 HWY 468 W, BLDG 60 WHITFIELD MS 39193 RANKIN (601) 351-8023 Acute Care Hospitals Government - State FALSE 32.2418381 -90.0709905 1 ROOFTOP 121 28 28121 27140 Jackson-Vicksburg-Brookhaven, MS Central Rankin County https://data.medicare.gov/resource/xubh-q36u/row-h6gx_kf5u~ce53 250134 660110 2019-12-02 2019-06-30 32           32               32
3829 3829 WHITESBURG ARH HOSPITAL 240 HOSPITAL ROAD WHITESBURG KY 41858 LETCHER (606) 633-3500 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.1118200 -82.8136120 0   133 21 21133         https://data.medicare.gov/resource/xubh-q36u/row-pqne.4qjx-j597 180002 662525 2019-12-03 2019-06-30 84 6         90               90
723 723 WHITERIVER PHS INDIAN HOSPITAL 200 WEST HOSPITAL DRIVE (PO BOX 860) WHITERIVER AZ 85941 NAVAJO (928) 338-4911 Acute Care Hospitals Government - Federal FALSE 33.8759760 -109.9595280 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-v5m3-a25g-4tei 30113 650108 2019-06-15 2018-09-30 40           40               40
2239 2239 WHITE RIVER MEDICAL CENTER 1710 HARRISON STREET BATESVILLE AR 72503 INDEPENDENCE (870) 262-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7695720 -91.6347210 0   63 5 5063 12900   Central Independence County https://data.medicare.gov/resource/xubh-q36u/row-pk3m_2ypn.k69k 40119 654084 2019-08-30 2018-09-30 172 12         184 16 10   11       221
3603 3603 WHITE PLAINS HOSPITAL CENTER 41 EAST POST R0AD WHITE PLAINS NY 10601 WESTCHESTER (914) 681-0600 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.0260327 -73.7689860 1 ROOFTOP 119 36 36119 35620 New York-Newark, NY-NJ-CT-PA Central Westchester County https://data.medicare.gov/resource/xubh-q36u/row-yd8d~pbyh~69gt 330304 651034 2019-06-03 2018-12-31 261 8 8     15 292               292
41 41 WHITE MOUNTAIN REGIONAL MEDICAL CENTER 118 SOUTH MOUNTAIN AVENUE SPRINGERVILLE AZ 85938 APACHE (928) 333-4368 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.1321360 -109.2865450 0   1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-dkxh~vpbb.s52c 31315 652061 2019-05-30 2018-12-31 21           21               21
1485 1485 WHITE MEMORIAL MEDICAL CENTER 1720 E CESAR AVENUE LOS ANGELES CA 90033 LOS ANGELES (323) 268-5000 Acute Care Hospitals Voluntary non-profit - Church FALSE 34.0492967 -118.2171632 1 ROOFTOP 37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-n689-ji7q_qdqg 50103 659189 2019-05-31 2018-12-31 243 34       5 310   16   27       353
3967 3967 WHITE COUNTY MEDICAL CENTER 3214 EAST RACE AVENUE SEARCY AR 72143 WHITE (501) 278-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.2504460 -91.6967580 0   145 5 5145 42620 Little Rock-North Little Rock, AR Central White County https://data.medicare.gov/resource/xubh-q36u/row-b6nk.pamh_stfx 40014 644701 2019-02-28 2018-09-30 192 13         205 30 37           272
1192 1192 WHIDBEYHEALTH MEDICAL CENTER 101 NORTH MAIN STREET COUPEVILLE WA 98239 ISLAND (360) 678-5151 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.2142400 -122.6861220 0   29 53 53029 36020 Seattle-Tacoma, WA Central Island County https://data.medicare.gov/resource/xubh-q36u/row-uede_fy5z~txux 501339 649688 2019-05-31 2018-12-31 19 6         25               25
2417 2417 WHEELING HOSPITAL 1 MEDICAL PARK WHEELING WV 26003 OHIO (304) 243-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.0600740 -80.6840220 0   69 54 54069 48540   Central Ohio County https://data.medicare.gov/resource/xubh-q36u/row-s497_dubq_q36x 510050 645204 2019-02-28 2018-09-30 201 22         223       125       348
3349 3349 WHEATLAND MEMORIAL HOSPITAL 530 3RD ST NW HARLOWTON MT 59036 WHEATLAND (406) 632-4351 Critical Access Hospitals Government - Local TRUE 46.4370010 -109.8405050 0   107 30 30107         https://data.medicare.gov/resource/xubh-q36u/row-ttwx.8piz~nq2c 271321 651017 2019-06-03 2018-12-31 25           25               25
3295 3295 WETZEL COUNTY HOSPITAL #3 EAST BENJAMIN DRIVE NEW MARTINSVILLE WV 26155 WETZEL (304) 455-8000 Acute Care Hospitals Government - Local TRUE 39.6810712 -80.8501977 1 ROOFTOP 103 54 54103         https://data.medicare.gov/resource/xubh-q36u/row-v7h8~v92p-92tq 510072 661438 2019-12-02 2019-06-30 43 5         48               48
494 494 WESTSIDE REGIONAL MEDICAL CENTER 8201 W BROWARD BLVD PLANTATION FL 33324 BROWARD (954) 473-6600 Acute Care Hospitals Proprietary FALSE 26.1208820 -80.2584290 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-nnuu-rs8x~9yxs 100228 651509 2019-06-28 2019-01-31 192 32         224               224
1770 1770 WESTON COUNTY HEALTH SERVICES 1124 WASHINGTON BOULEVARD NEWCASTLE WY 82701 WESTON (307) 746-4491 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.8487470 -104.1887560 0   45 56 56045         https://data.medicare.gov/resource/xubh-q36u/row-jibn-3jkh~ba9g 531303 640299 2018-12-03 2018-06-30 12           12       58       70
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
3407 3407 WESTFIELDS HOSPITAL AND CLINIC 535 HOSPITAL RD NEW RICHMOND WI 54017 ST. CROIX (715) 243-2600 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.1174600 -92.5532140 0   109 55 55109 33460 Minneapolis-St. Paul, MN-WI Outlying St. Croix County https://data.medicare.gov/resource/xubh-q36u/row-v45z.6njd_wida 521345 649384 2019-05-24 2018-12-31 25           25               25
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
3409 3409 WESTERN WISCONSIN HEALTH 1100 BERGSLIEN ST BALDWIN WI 54002 ST. CROIX (715) 684-1111 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.9412820 -92.3760280 0   109 55 55109 33460 Minneapolis-St. Paul, MN-WI Outlying St. Croix County https://data.medicare.gov/resource/xubh-q36u/row-a6vz_52c3-apfq 521347 644391 2019-02-27 2018-09-30 25           25               25
578 578 WESTERN REGIONAL MEDICAL CENTER 14200 WEST CELEBRATE LIFE WAY GOODYEAR AZ 85338 MARICOPA (623) 207-3518 Acute Care Hospitals Proprietary FALSE 33.4528040 -112.3625710 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-rhgj.utwd-n4qy                                      
2068 2068 WESTERN PLAINS MEDICAL COMPLEX 3001 AVENUE A DODGE CITY KS 67801 FORD (620) 225-8400 Acute Care Hospitals Proprietary TRUE 37.7854870 -100.0149750 0   57 20 20057 19980   Central Ford County https://data.medicare.gov/resource/xubh-q36u/row-w4ff.nykp.gqd4 170175 652748 2019-08-01 2019-02-28 50 10         60               60
3209 3209 WESTERN MISSOURI MEDICAL CENTER 403 BURKARTH ROAD WARRENSBURG MO 64093 JOHNSON (660) 747-2500 Acute Care Hospitals Government - Hospital District or Authority TRUE 38.7664740 -93.7237010 0   101 29 29101 47660 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-74d6_q73a.h7xv 260097 650167 2019-06-03 2018-12-31 46           46 12             58
95 95 WESTERN MARYLAND REGIONAL MEDICAL CENTER 12500 WILLOWBROOK ROAD CUMBERLAND MD 21502 ALLEGANY (240) 964-8001 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.6500910 -78.7327770 0   1 24 24001 19060   Central Allegany County https://data.medicare.gov/resource/xubh-q36u/row-x4yg.qijv.37uc 210027 661004 2019-12-02 2019-06-30 186 14         200   13           213

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