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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_ownership, emergency_services, geocode_flag, 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
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
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
3519 3519 ADVENTIST HEALTH AND RIDEOUT 726 4TH ST MARYSVILLE CA 95901 YUBA (530) 749-4300 Acute Care Hospitals Government - Federal TRUE 39.1388320 -121.5936220 0   115 6 6115 49700 Sacramento-Roseville, CA Central Yuba County https://data.medicare.gov/resource/xubh-q36u/row-ena2_rmjt-rgun 50133 660916 2019-11-27 2019-06-30 179 24         209               209
4710 4710 GRAHAM REGIONAL MEDICAL CENTER 1301 MONTGOMERY ROAD GRAHAM TX 76450 YOUNG (940) 549-3400 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.0899730 -98.5843560 0   503 48 48503         https://data.medicare.gov/resource/xubh-q36u/row-zgck.cipi_69sb 450085 644359 2019-02-28 2018-09-30 25           25               25
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
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
1268 1268 SOUTHERN MAINE HEALTH CARE 1 MEDICAL CENTER DRIVE BIDDEFORD ME 4005 YORK (207) 283-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.4784360 -70.4921740 0   31 23 23031 38860 Portland-Lewiston-South Portland, ME Central York County https://data.medicare.gov/resource/xubh-q36u/row-am4g_dvue_z9bw 200019 649741 2019-05-30 2018-12-31 131 9         140 12     74   38   264
2977 2977 PIEDMONT MEDICAL CENTER 222 S HERLONG AVE ROCK HILL SC 29730 YORK (803) 329-1234 Acute Care Hospitals Proprietary TRUE 34.9551980 -81.0512500 0   91 45 45091 16740 Charlotte-Concord, NC-SC Outlying York County https://data.medicare.gov/resource/xubh-q36u/row-ut6b.7ida_ci73 420002 655837 2019-10-28 2019-05-31 244 24         268 20             288
3838 3838 OSS ORTHOPAEDIC HOSPITAL 1861 POWDER MILL RD YORK PA 17402 YORK (717) 718-2000 Acute Care Hospitals Proprietary FALSE 39.9166900 -76.6968130 0   133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-9itg-k673_kn2f 390325 659884 2019-11-22 2019-06-30 30           30               30
3839 3839 UPMC MEMORIAL 1701 INNOVATION DRIVE YORK PA 17408 YORK (717) 843-8623 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9815722 -76.7696680 1 ROOFTOP 133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-hmf5.dwfj.9dpf 390101 661097 2019-12-02 2019-06-30 50 10         60               60
3840 3840 WELLSPAN SURGERY AND REHABILITATION HOSPITAL 55 MONUMENT ROAD YORK PA 17403 YORK (717) 812-6100 Acute Care Hospitals Voluntary non-profit - Private FALSE 39.9232770 -76.7168980 0   133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-vz8h~6tdd.rzsw 390327 655835 2018-11-29 2018-06-30 25           25   48           73
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
3842 3842 UPMC PINNACLE HANOVER 300 HIGHLAND AVE HANOVER PA 17331 YORK (717) 637-3711 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8079810 -76.9837310 0   133 42 42133 49620 Harrisburg-York-Lebanon, PA Central York County https://data.medicare.gov/resource/xubh-q36u/row-e6wa_fe6d.4weu 390233 660867 2019-12-02 2019-06-30 72           81               81
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
4329 4329 HENDERSON HEALTH CARE SERVICES 1621 FRONT STREET HENDERSON NE 68371 YORK (402) 723-4512 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7828880 -97.8073610 0   185 31 31185         https://data.medicare.gov/resource/xubh-q36u/row-eqsp-f96h~xhhx 281308 654683 2019-09-20 2019-06-30 13           13           40   53
3457 3457 SUTTER DAVIS HOSPITAL 2000 SUTTER PLACE DAVIS CA 95616 YOLO (530) 756-6440 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.5629230 -121.7725220 0   113 6 6113 40900 Sacramento-Roseville, CA Outlying Yolo County https://data.medicare.gov/resource/xubh-q36u/row-5mwt~twe5~z7f4 50537 650805 2019-06-03 2018-12-31 42 6         48               48
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
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
3439 3439 ST VINCENT HEALTHCARE 1233 N 30TH ST BILLINGS MT 59101 YELLOWSTONE (406) 657-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.7931660 -108.5202810 0   111 30 30111 13740   Central Yellowstone County https://data.medicare.gov/resource/xubh-q36u/row-pej5.abty.c4tn 270049 646627 2019-04-11 2018-12-31 191 17         236   20           256
3440 3440 BILLINGS CLINIC HOSPITAL 2800 10TH AVE N BILLINGS MT 59101 YELLOWSTONE (406) 657-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.7904520 -108.5141500 0   111 30 30111 13740   Central Yellowstone County https://data.medicare.gov/resource/xubh-q36u/row-85ms~9jga.ufat 270004 661355 2019-11-27 2019-06-30 257 24         301               301
4254 4254 MUNICIPAL HOSPITAL AND GRANITE MANOR 345 TENTH AVENUE GRANITE FALLS MN 56241 YELLOW MEDCINE (320) 564-3111 Critical Access Hospitals Government - Local TRUE 44.8087370 -95.5424670 0   173 27 27173         https://data.medicare.gov/resource/xubh-q36u/row-btj8.8k3m-tcy7 241343 649454 2019-05-29 2018-12-31 25           25       48       73
4255 4255 SANFORD CANBY MEDICAL CENTER 112 ST OLAF AVENUE SOUTH CANBY MN 56220 YELLOW MEDCINE (507) 223-7277 Critical Access Hospitals Government - Hospital District or Authority TRUE 44.7078990 -96.2775550 0   173 27 27173         https://data.medicare.gov/resource/xubh-q36u/row-dj3n-ee8i_z8u5 241347 649785 2019-05-30 2018-12-31 22           22       53       75
4010 4010 CHAMBERS MEMORIAL HOSPITAL 719 DETROIT STREET DANVILLE AR 72833 YELL (479) 495-2241 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0548230 -93.3885430 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-d59r_eigs_n4bw 40011 660743 2019-12-03 2019-06-30 30           30 12             42
4011 4011 DARDANELLE HOSPITAL 200 NORTH THIRD STREET DARDANELLE AR 72834 YELL (479) 229-4677 Critical Access Hospitals Proprietary TRUE 35.2209170 -93.1569870 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-u9x6_diim.h7v6 41302 639835 2018-12-26 2018-06-30 25           25 10             35
4176 4176 BAPTIST MEDICAL CENTER-YAZOO 823 GRAND AVENUE YAZOO CITY MS 39194 YAZOO (662) 746-2261 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.8587300 -90.4033210 0   163 28 28163 27140 Jackson-Vicksburg-Brookhaven, MS Outlying Yazoo County https://data.medicare.gov/resource/xubh-q36u/row-i83f-pamk.mfmb 251313 643910 2019-02-28 2018-09-30 25           25               25
991 991 VERDE VALLEY MEDICAL CENTER 269 SOUTH CANDY LANE COTTONWOOD AZ 86326 YAVAPAI (928) 773-2357 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7362010 -112.0317840 0   25 4 4025 39140   Central Yavapai County https://data.medicare.gov/resource/xubh-q36u/row-ijum~m4k2-ih8a 30007 661278 2019-11-27 2019-06-30 74 13         87 11             98
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
4073 4073 HOSPITAL METROPOLITANO DR TITO MATTEI ROAD 128 KM 1.0 YAUCO PR 698 YAUCO (787) 856-1000 Acute Care Hospitals Proprietary TRUE 18.0295606 -66.8571953 1 GEOMETRIC_CENTER 153 72 72153 38660 Ponce-Coamo-Santa Isabel, PR Outlying Yauco Municipio https://data.medicare.gov/resource/xubh-q36u/row-dj5v~4uja-xjvr 400110 650773 2019-05-29 2018-12-31 73 11         84 28             112
3689 3689 SOLDIERS AND SAILORS MEMORIAL HOSPITAL OF YATES 418 NORTH MAIN STREET PENN YAN NY 14527 YATES (315) 787-4175 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.6704680 -77.0595910 0   123 36 36123 40380 Rochester-Batavia-Seneca Falls, NY Outlying Yates County https://data.medicare.gov/resource/xubh-q36u/row-8crr-f6mb_sbwc 331314 650326 2019-06-21 2018-12-31 25           25 10     151       186
3862 3862 AVERA SACRED HEART HOSPITAL 501 SUMMIT ST YANKTON SD 57078 YANKTON (605) 668-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8725730 -97.4069450 0   135 46 46135 49460   Central Yankton County https://data.medicare.gov/resource/xubh-q36u/row-p2ay-ses4.gzui 430012 656749 2018-11-30 2018-06-30 65 10         75       187       262
2483 2483 PROVIDENCE NEWBERG MEDICAL CENTER 1001 PROVIDENCE DRIVE NEWBERG OR 97132 YAMHILL (503) 537-1555 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.3085520 -122.9339130 0   71 41 41071 38900 Portland-Vancouver-Salem, OR-WA Outlying Yamhill County https://data.medicare.gov/resource/xubh-q36u/row-zttx-g4s5_qqvh 380037 648647 2019-05-22 2018-12-31 36 4         40               40
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
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
2632 2632 ASTRIA REGIONAL MEDICAL CENTER 110 SOUTH NINTH AVE YAKIMA WA 98902 YAKIMA (509) 575-5102 Acute Care Hospitals Proprietary TRUE 46.5979850 -120.5210960 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-zbwg.834x-7vgp 500012 651302 2019-06-14 2018-12-31 113           113   15           128
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
2634 2634 ASTRIA TOPPENISH HOSPITAL 502 W FOURTH AVE TOPPENISH WA 98948 YAKIMA (509) 865-1520 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.3713500 -120.3166820 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-pw49~vzsk_k73d 500037 650424 2019-06-04 2018-12-31 18 7         25               25
2635 2635 ASTRIA SUNNYSIDE HOSPITAL 1016 TACOMA AVENUE SUNNYSIDE WA 98944 YAKIMA (509) 837-1500 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.3222180 -120.0069660 0   77 53 53077 49420   Central Yakima County https://data.medicare.gov/resource/xubh-q36u/row-meen.vpbw_8fip 501330 652470 2019-07-22 2018-12-31 18 7         25               25
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
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
3819 3819 TYLER MEMORIAL HOSPITAL 5950 STATE ROUTE 6 WEST TUNKHANNOCK PA 18657 WYOMING (570) 836-2161 Acute Care Hospitals Proprietary TRUE 41.5766510 -75.9698250 0   131 42 42131 42540   Outlying Wyoming County https://data.medicare.gov/resource/xubh-q36u/row-h68k-9niq.fgct 390192 659877 2019-11-26 2019-06-30 38 6         44               44
4456 4456 UNIVERSITY OF KANSAS HOSPITAL 4000 CAMBRIDGE STREET KANSAS CITY KS 66160 WYANDOTTE (913) 588-7332 Acute Care Hospitals Government - Hospital District or Authority TRUE 39.0553950 -94.6082290 0   209 20 20209 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Wyandotte County https://data.medicare.gov/resource/xubh-q36u/row-eypu_w27y~gqr6 170040 654923 2019-09-30 2019-06-30 704 106       32 848 15 29           892
4457 4457 PROVIDENCE MEDICAL CENTER 8929 PARALLEL PARKWAY KANSAS CITY KS 66112 WYANDOTTE (913) 596-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1285820 -94.7863290 0   209 20 20209 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Wyandotte County https://data.medicare.gov/resource/xubh-q36u/row-zk3n_vcvk.j3ej 170146 648830 2019-05-29 2018-12-31 148 23         171       45       216
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
4233 4233 CENTRACARE HEALTH - MONTICELLO 1013 HART BOULEVARD MONTICELLO MN 55362 WRIGHT (763) 295-2945 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3001700 -93.7791070 0   171 27 27171 33460 Minneapolis-St. Paul, MN-WI Central Wright County https://data.medicare.gov/resource/xubh-q36u/row-8yik_ujc7-cau4 241362 660614 2019-11-26 2019-06-30 22 3         25 10     89       124
4234 4234 BUFFALO HOSPITAL 303 CATLIN ST BUFFALO MN 55313 WRIGHT (763) 682-1212 Acute Care Hospitals Voluntary non-profit - Other FALSE 45.1932000 -93.8705300 0   171 27 27171 33460 Minneapolis-St. Paul, MN-WI Central Wright County https://data.medicare.gov/resource/xubh-q36u/row-q8xg_3hph~s44a 240076 649768 2019-05-23 2018-12-31 44           44               44
4389 4389 IOWA SPECIALTY HOSPITAL - BELMOND 403 FIRST STREET SE BELMOND IA 50421 WRIGHT (641) 444-3223 Critical Access Hospitals Government - Local TRUE 42.8449880 -93.6128550 0   197 19 19197         https://data.medicare.gov/resource/xubh-q36u/row-8b8k.b5cg~72n2 161301 659568 2019-11-22 2019-06-30 22           22               22
4390 4390 IOWA SPECIALTY HOSPITAL-CLARION 1316 SOUTH MAIN STREET CLARION IA 50525 WRIGHT (515) 532-2811 Critical Access Hospitals Government - Local TRUE 42.7216250 -93.7326280 0   197 19 19197         https://data.medicare.gov/resource/xubh-q36u/row-qm5h-kjf7~8unb 161302 661176 2019-12-02 2019-06-30 25           25               25
4536 4536 SEARHC WRANGELL MEDICAL CENTER-CAH 310 BENNETT STREET PO BOX 1081 WRANGELL AK 99929 WRANGELL CITY AND BOROUGH (907) 874-7000 Critical Access Hospitals Government - Local FALSE 56.4716460 -132.3764140 0   275 2 2275         https://data.medicare.gov/resource/xubh-q36u/row-n33k~as59_upeg 21305 645317 2019-03-18 2018-10-31 8           8       14       22
4573 4573 PHOEBE WORTH MEDICAL CENTER 807 SOUTH ISABELLA STREET SYLVESTER GA 31791 WORTH (229) 777-3851 Critical Access Hospitals Voluntary non-profit - Private TRUE 31.5123850 -83.8406730 0   321 13 13321 10500   Outlying Worth County https://data.medicare.gov/resource/xubh-q36u/row-kvdr-2fup-rgie 111328 641024 2018-12-28 2018-07-31 25           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
1078 1078 UMASS MEMORIAL MEDICAL CENTER INC 55 LAKE AVENUE NORTH WORCESTER MA 1655 WORCESTER (508) 334-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2785100 -71.7590790 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-t2gz_92wg~829y 220163 643900 2019-03-05 2018-09-30 461 82 30     27 600 40             640
1079 1079 HEYWOOD HOSPITAL - 242 GREEN STREET GARDNER MA 1440 WORCESTER (978) 632-3420 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5865650 -71.9861650 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-vv6z~isen-5p6a 220095 645108 2019-02-28 2018-09-30 103 11         114 20             134
1080 1080 HARRINGTON MEMORIAL HOSPITAL-1 100 SOUTH STREET SOUTHBRIDGE MA 1550 WORCESTER (508) 765-9771 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0771820 -72.0420650 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-gaya~jyei_4bik 220019 645420 2019-03-01 2018-09-30 99 6         105 14             119
1081 1081 ATHOL MEMORIAL HOSPITAL 2033 MAIN STREET ATHOL MA 1331 WORCESTER (978) 249-3511 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.5862730 -72.2087480 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-kb7k~zmz5~v8ji 221303 644288 2019-02-28 2018-09-30 25           25               25
1082 1082 ST VINCENT HOSPITAL 123 SUMMER STREET WORCESTER MA 1608 WORCESTER (508) 363-5000 Acute Care Hospitals Proprietary TRUE 42.2659710 -71.7954900 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-vfu4_exvq.gvbq 220176 651783 2019-06-27 2019-01-31 239       20   259 13             272
1083 1083 ADCARE HOSPITAL OF WORCESTER INC 107 LINCOLN STREET WORCESTER MA 1605 WORCESTER (508) 799-9000 Acute Care Hospitals Proprietary FALSE 42.2761820 -71.7955760 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-rnsb.iihy_fs75 220062 645423 2019-03-01 2018-09-30 114           114               114
1084 1084 HEALTH ALLIANCE - CLINTON HOSPITAL 60 HOSPITAL ROAD LEOMINSTER MA 1453 WORCESTER (978) 466-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.5411930 -71.7630330 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-y6vw_ua5p.gsn5 220001 644639 2019-02-28 2018-09-30 120 10         130 20             150
1782 1782 ATLANTIC GENERAL HOSPITAL 9733 HEALTHWAY DRIVE BERLIN MD 21811 WORCESTER (410) 641-9600 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.3386040 -75.2104720 0   47 24 24047 41540   Outlying Worcester County https://data.medicare.gov/resource/xubh-q36u/row-kz7f~bne7-xch9 210061 660098 2019-12-03 2019-06-30 42 6         48               48
4069 4069 ALLIANCEHEALTH WOODWARD 900 17TH STREET WOODWARD OK 73801 WOODWARD (580) 254-8492 Acute Care Hospitals Proprietary TRUE 36.4378610 -99.4009540 0   153 40 40153 49260   Central Woodward County https://data.medicare.gov/resource/xubh-q36u/row-xvc5-zx2v~yrxt 370002 659337 2019-11-07 2019-05-31 34 6         40               40
32 32 SHARE MEDICAL CENTER 800 SHARE DRIVE ALVA OK 73717 WOODS (580) 327-2800 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.7869690 -98.6700230 0   151 40 40151         https://data.medicare.gov/resource/xubh-q36u/row-gzmq-89k6~9n3d 371341 659863 2019-11-25 2019-06-30 25           25         80     105
4444 4444 ADVOCATE EUREKA HOSPITAL 101 S MAJOR ST EUREKA IL 61530 WOODFORD (309) 467-2371 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.7214050 -89.2716610 0   203 17 17203 37900 Peoria-Canton, IL Central Woodford County https://data.medicare.gov/resource/xubh-q36u/row-4ygy~3sdv-kmqs 141309 649725 2019-05-30 2018-12-31 25           25               25
4507 4507 BLUEGRASS COMMUNITY HOSPITAL 360 AMSDEN AVENUE VERSAILLES KY 40383 WOODFORD (859) 873-3111 Critical Access Hospitals Proprietary TRUE 38.0553430 -84.7234150 0   239 21 21239 30460 Lexington-Fayette--Richmond--Frankfort, KY Outlying Woodford County https://data.medicare.gov/resource/xubh-q36u/row-9aks-4jh9~zwp7 181308 652512 2019-08-01 2019-02-28 25           25               25
4369 4369 ST LUKES REGIONAL MEDICAL CENTER 2720 STONE PARK BOULEVARD SIOUX CITY IA 51104 WOODBURY (712) 279-3500 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.5186000 -96.4060290 0   193 19 19193 43580 Sioux City-Vermillion, IA-SD-NE Central Woodbury County https://data.medicare.gov/resource/xubh-q36u/row-4feb-c43c_8ymx 160146 649580 2019-05-31 2018-12-31 124 15         159   10           169
4370 4370 MERCY MEDICAL CENTER-SIOUX CITY 801 5TH ST SIOUX CITY IA 51101 WOODBURY (712) 279-2010 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.4953290 -96.4000610 0   193 19 19193 43580 Sioux City-Vermillion, IA-SD-NE Central Woodbury County https://data.medicare.gov/resource/xubh-q36u/row-jsi5.3x3k.5jh6 160153 660086 2019-11-26 2019-06-30 138 19         157   20   20       197
3361 3361 CAMDEN CLARK MEDICAL CENTER 800 GARFIELD AVE PARKERSBURG WV 26101 WOOD (304) 424-2111 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.2702090 -81.5604260 0   107 54 54107 37620 Parkersburg-Marietta-Vienna, WV-OH Central Wood County https://data.medicare.gov/resource/xubh-q36u/row-pmmk.a48e.nj6g 510058 648872 2019-05-21 2018-12-31 194 18 18       230 19             249
3936 3936 ASPIRUS RIVERVIEW HOSPITAL & CLINICS INC 410 DEWEY ST WISCONSIN RAPIDS WI 54495 WOOD (715) 423-6060 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.3821990 -89.8295440 0   141 55 55141 49220 Wausau-Stevens Point-Wisconsin Rapids, WI Central Wood County https://data.medicare.gov/resource/xubh-q36u/row-yakd~caj8~y7vv 520033 661271 2019-12-11 2019-06-30 41 4         45               45
3937 3937 MARSHFIELD MEDICAL CENTER 611 ST JOSEPH AVE MARSHFIELD WI 54449 WOOD (715) 387-7850 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.6780444 -90.1770418 1 ROOFTOP 141 55 55141 49220 Wausau-Stevens Point-Wisconsin Rapids, WI Central Wood County https://data.medicare.gov/resource/xubh-q36u/row-skbx~dk6q-qiix 520037 641007 2019-01-08 2018-09-30 181   11   12   230   8           238
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
4708 4708 CHRISTUS MOTHER FRANCES HOSPITAL- WINNSBORO 719 WEST COKE ROAD WINNSBORO TX 75494 WOOD (903) 342-5227 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.9476430 -95.3062300 0   499 48 48499         https://data.medicare.gov/resource/xubh-q36u/row-sujf.kw2i-m7r8 451381 660335 2019-11-26 2019-06-30 23           23               23
4709 4709 UT HEALTH EAST TEXAS QUITMAN HOSPITAL 117 WINNSBORO STREET QUITMAN TX 75783 WOOD (903) 763-4500 Critical Access Hospitals Voluntary non-profit - Private TRUE 32.7961550 -95.4452960 0   499 48 48499         https://data.medicare.gov/resource/xubh-q36u/row-prny-2yw9-g69a 451380 656192 2019-10-29 2019-05-31 25           25               25
4385 4385 LONESOME PINE HOSPITAL 1990 HOLTON AVENUE EAST BIG STONE GAP VA 24219 WISE (276) 523-3111 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.8772840 -82.7556700 0   195 51 51195 13720   Central Wise County https://data.medicare.gov/resource/xubh-q36u/row-ftab_dza7~w44p 490114 661118 2019-11-21 2019-06-30 60 8         68       44       112
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
3823 3823 LAKELAND COMMUNITY HOSPITAL 42024 HIGHWAY 195 E HALEYVILLE AL 35565 WINSTON (205) 485-7117 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2417180 -87.5898570 0   133 1 1133         https://data.medicare.gov/resource/xubh-q36u/row-qzez~be97-dgiz 10125 645811 2019-04-01 2018-12-31 45 4         49 9             58
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
3907 3907 THEDACARE REGIONAL MEDICAL CENTER - NEENAH INC 130 2ND ST NEENAH WI 54956 WINNEBAGO (920) 729-3100 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.1891720 -88.4539070 0   139 55 55139 36780 Appleton-Oshkosh-Neenah, WI Central Winnebago County https://data.medicare.gov/resource/xubh-q36u/row-h77j-5sri.s5sr 520045 650922 2019-06-03 2018-12-31 125 14         139   12           151
3908 3908 CHILDRENS HOSPITAL OF WISCONSIN FOX VALLEY 130 SECOND ST NEENAH WI 54956 WINNEBAGO (920) 969-7900 Childrens Voluntary non-profit - Other TRUE 44.1891720 -88.4539070 0   139 55 55139 36780 Appleton-Oshkosh-Neenah, WI Central Winnebago County https://data.medicare.gov/resource/xubh-q36u/row-qi6n~u89t_ynp5 523302 650555 2019-05-31 2018-12-31 20 22         42               42
3909 3909 AURORA MEDICAL CTR OSHKOSH 855 N WESTHAVEN DRIVE OSHKOSH WI 54904 WINNEBAGO (920) 456-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.0275410 -88.5932910 0   139 55 55139 36780 Appleton-Oshkosh-Neenah, WI Central Winnebago County https://data.medicare.gov/resource/xubh-q36u/row-iuqr~6b9c.rjpw 520198 651109 2019-06-04 2018-12-31 60 12         72               72
4401 4401 MERCYHEALTH HOSPITAL ROCKTON AVENUE 2400 NORTH ROCKTON AVENUE ROCKFORD IL 61103 WINNEBAGO (815) 968-6861 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2984340 -89.0967820 0   201 17 17201 40420 Rockford-Freeport-Rochelle, IL Central Winnebago County https://data.medicare.gov/resource/xubh-q36u/row-kqbu_7e2g-xpdz 140239 660519 2019-11-27 2019-06-30 196 22         278 14             292
4402 4402 SAINT ANTHONY MEDICAL CENTER 5666 EAST STATE STREET ROCKFORD IL 61108 WINNEBAGO (815) 226-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.2657780 -89.0073000 0   201 17 17201 40420 Rockford-Freeport-Rochelle, IL Central Winnebago County https://data.medicare.gov/resource/xubh-q36u/row-ysyd_rgwd_tbfu 140233 659948 2019-11-15 2018-09-30 210 38         248               248
4403 4403 SWEDISH AMERICAN HOSPITAL 1401 EAST STATE STREET ROCKFORD IL 61104 WINNEBAGO (815) 968-4400 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.2669430 -89.0735500 0   201 17 17201 40420 Rockford-Freeport-Rochelle, IL Central Winnebago County https://data.medicare.gov/resource/xubh-q36u/row-wn93~hjbb-ginr 140228 659565 2019-11-19 2019-06-30 263 30         293 20             313
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
1111 1111 MT ASCUTNEY HOSPITAL 289 COUNTY ROAD WINDSOR VT 5089 WINDSOR (802) 674-6711 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4875220 -72.4009100 0   27 50 50027 17200   Central Windsor County https://data.medicare.gov/resource/xubh-q36u/row-wz4v-vria_i3xt 471302 643748 2019-02-25 2018-09-30 25           25   10           35
1112 1112 SPRINGFIELD HOSPITAL PO BOX 2003 SPRINGFIELD VT 5156 WINDSOR (802) 885-2151 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.2981414 -72.4948662 1 ROOFTOP 27 50 50027 17200   Central Windsor County https://data.medicare.gov/resource/xubh-q36u/row-zewq-djn4-pp8m 471306 643749 2019-02-25 2018-09-30 25           25 10             35
676 676 DAY KIMBALL HOSPITAL 320 POMFRET STREET PUTNAM CT 6260 WINDHAM (860) 928-6541 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9077460 -71.9146920 0   15 9 9015 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Windham County https://data.medicare.gov/resource/xubh-q36u/row-wpx5.4hwv_hd6p 70003 645321 2019-02-28 2018-09-30 98 6         104               104
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
1043 1043 BRATTLEBORO MEMORIAL HOSPITAL 17 BELMONT AVE BRATTLEBORO VT 5301 WINDHAM (802) 257-0341 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8420700 -72.5646430 0   25 50 50025         https://data.medicare.gov/resource/xubh-q36u/row-r2kj.qdk8~ae78 470011 644193 2019-02-28 2018-09-30 47           47               47
1044 1044 GRACE COTTAGE HOSPITAL PO BOX 216 TOWNSHEND VT 5353 WINDHAM (802) 365-7920 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.0489148 -72.6682465 1 ROOFTOP 25 50 50025         https://data.medicare.gov/resource/xubh-q36u/row-u9ts~hp4k-kd62 471300 643746 2019-02-22 2018-09-30 19           19               19
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
4360 4360 TENNOVA HEALTHCARE-LEBANON 1411 BADDOUR PARKWAY LEBANON TN 37087 WILSON (615) 444-8262 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.2191730 -86.3283180 0   189 47 47189 34980 Nashville-Davidson--Murfreesboro, TN Central Wilson County https://data.medicare.gov/resource/xubh-q36u/row-ktrn_ki3w-2r7d 440193 646359 2019-03-20 2018-10-31 158 12         170 49 26           245
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
4448 4448 FREDONIA REGIONAL HOSPITAL 1527 MADISON FREDONIA KS 66736 WILSON (620) 378-2121 Critical Access Hospitals Government - Local TRUE 37.5336410 -95.8148160 0   205 20 20205         https://data.medicare.gov/resource/xubh-q36u/row-hjcm.q7qz~2jgr 171374 648113 2019-05-21 2018-12-31 25           25 9             34
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
4705 4705 CONNALLY MEMORIAL MEDICAL CENTER 499 10TH STREET FLORESVILLE TX 78114 WILSON (830) 393-1300 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.1594290 -98.1732050 0   493 48 48493 41700   Outlying Wilson County https://data.medicare.gov/resource/xubh-q36u/row-htdx~r9z4.vrrk 450108 644362 2019-03-08 2018-09-30 40 4         44               44
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
4395 4395 HERRIN HOSPITAL 201 S 14TH ST HERRIN IL 62948 WILLIAMSON (618) 942-2171 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.8016130 -89.0265080 0   199 17 17199 16060   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-haub~x6q9.4zji 140011 653130 2019-08-23 2019-03-31 77 8         85   29           114
4396 4396 HEARTLAND REGIONAL MEDICAL CENTER 3333 W DEYOUNG MARION IL 62959 WILLIAMSON (618) 998-7000 Acute Care Hospitals Proprietary TRUE 37.7448910 -88.9888480 0   199 17 17199 16060   Central Williamson County https://data.medicare.gov/resource/xubh-q36u/row-emxq~znat.w4hm 140184 654916 2019-09-27 2019-04-30 76 18         94               94

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