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 city 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
3096 3096 MIDWESTERN REGION MED CENTER 2520 ELISHA AVENUE ZION IL 60099 LAKE (847) 872-4561 Acute Care Hospitals Proprietary TRUE 42.4489700 -87.8268400 0   97 17 17097 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-wjcc_h9y8~99z6 140100 661493 2019-12-02 2019-06-30 49 24         73               73
3194 3194 ADVENTHEALTH ZEPHYRHILLS 7050 GALL BLVD ZEPHYRHILLS FL 33541 PASCO (813) 788-0411 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.2609370 -82.1880410 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-5w9q_uu4q-aya6 100046 649408 2019-05-31 2018-12-31 135 14         149               149
3891 3891 SPECTRUM HEALTH ZEELAND COMMUNITY HOSPITAL 8333 FELCH ST ZEELAND MI 49464 OTTAWA (616) 772-4644 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.8195390 -85.9881290 0   139 26 26139 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Ottawa County https://data.medicare.gov/resource/xubh-q36u/row-q68w-vf6c.adcb 230003 659580 2019-11-22 2019-06-30 48 7         55               55
3619 3619 GENESIS HOSPITAL 2951 MAPLE AVENUE ZANESVILLE OH 43701 MUSKINGUM (740) 454-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9757310 -82.0142450 0   119 39 39119 49780 Columbus-Marion-Zanesville, OH Central Muskingum County https://data.medicare.gov/resource/xubh-q36u/row-p28m~2s52~jwnm 360039 649309 2019-05-31 2018-12-31 234 24 24       282           7   289
1327 1327 LANE REGIONAL MEDICAL CENTER 6300 MAIN STREET ZACHARY LA 70791 E. BATON ROUGE (225) 658-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.6499570 -91.1367470 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-6rne~rwgc-e8xv 190020 659955 2019-12-03 2019-06-30 95 8       2 113   30   39       182
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
781 781 INTEGRIS CANADIAN VALLEY HOSPITAL 1201 HEALTH CENTER PARKWAY YUKON OK 73099 CANADIAN (405) 717-6800 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4836950 -97.7602420 0   17 40 40017 36420 Oklahoma City-Shawnee, OK Central Canadian County https://data.medicare.gov/resource/xubh-q36u/row-bfap-q9md_hknr 370211 660282 2019-11-27 2019-06-30 66 8         74               74
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
2990 2990 FAIRCHILD MEDICAL CENTER 444 BRUCE STREET YREKA CA 96097 SISKIYOU (530) 842-4121 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.7185790 -122.6454570 0   93 6 6093         https://data.medicare.gov/resource/xubh-q36u/row-wj65.hzqw~ibav 51316 659220 2019-05-28 2018-12-31 21 4         25               25
4139 4139 FOREST HEALTH MEDICAL CENTER 135 S PROSPECT ST YPSILANTI MI 48198 WASHTENAW (734) 547-4700 Acute Care Hospitals Government - Hospital District or Authority TRUE 42.2373830 -83.6019160 0   161 26 26161 11460 Detroit-Warren-Ann Arbor, MI Central Washtenaw County https://data.medicare.gov/resource/xubh-q36u/row-txne-8zg7_uajf 230144 650831 2019-06-05 2018-12-31 24           24               24
3176 3176 MH ST ELIZABETH YOUNGSTOWN HOSPITAL 1044 BELMONT AVENUE YOUNGSTOWN OH 44501 MAHONING (330) 480-3962 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.1143210 -80.6557100 0   99 39 39099 49660 Youngstown-Warren, OH-PA Central Mahoning County https://data.medicare.gov/resource/xubh-q36u/row-wapa_iiqs_cijz 360064 648297 2019-05-20 2018-12-31 251 20 9   20   300 38 26           364
3177 3177 SURGICAL HOSPITAL AT SOUTHWOODS 7630 SOUTHERN BLVD YOUNGSTOWN OH 44512 MAHONING (330) 729-8000 Acute Care Hospitals Proprietary FALSE 41.0153550 -80.6534390 0   99 39 39099 49660 Youngstown-Warren, OH-PA Central Mahoning County https://data.medicare.gov/resource/xubh-q36u/row-422i~a2cq-j6nr 360352 648972 2019-05-30 2018-12-31 24           24               24
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
3574 3574 HILL HOSPITAL OF SUMTER COUNTY 751 DERBY DRIVE YORK AL 36925 SUMTER (205) 392-5263 Acute Care Hospitals Voluntary non-profit - Other TRUE 32.4918250 -88.2960810 0   119 1 1119         https://data.medicare.gov/resource/xubh-q36u/row-hxjd.ga7s.xmvj 10138 651158 2019-06-03 2018-12-31 33           33               33
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
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
3602 3602 ST JOHN'S RIVERSIDE HOSPITAL 976 NORTH BROADWAY YONKERS NY 10701 WESTCHESTER (914) 964-4444 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9678400 -73.8851070 0   119 36 36119 35620 New York-Newark, NY-NJ-CT-PA Central Westchester County https://data.medicare.gov/resource/xubh-q36u/row-8him_4g2z_nyae 330208 650745 2019-05-31 2018-12-31 305 16         321               321
3607 3607 ST JOSEPH'S MEDICAL CENTER 127 SOUTH BROADWAY YONKERS NY 10701 WESTCHESTER (914) 378-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9296140 -73.8970030 0   119 36 36119 35620 New York-Newark, NY-NJ-CT-PA Central Westchester County https://data.medicare.gov/resource/xubh-q36u/row-w4yg~snw9~w2ji 330006 650733 2019-05-31 2018-12-31 116   6       122 149             271
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
844 844 SOUTH LYON MEDICAL CENTER 213 S WHITACRE/PO BOX 940 YERINGTON NV 89447 LYON (775) 781-3761 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.9840873 -119.1669050 1 ROOFTOP 19 32 32019 22280 Reno-Carson City-Fernley, NV Central Lyon County https://data.medicare.gov/resource/xubh-q36u/row-ykja.hnhj~bmpe 291314 653342 2019-08-30 2019-03-31 14           14       49       63
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
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
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
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
2083 2083 GREENE MEMORIAL HOSPITAL 1141 NORTH MONROE DRIVE XENIA OH 45385 GREENE (937) 352-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7002880 -83.9287810 0   57 39 39057 19380 Dayton-Springfield-Sidney, OH Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-j4yw-37x2~3jzu 360026 650885 2019-06-06 2018-12-31 41 8         49               49
2082 2082 88th Medical Group (Wright-Patterson AFB) 88 MDG 4881 Sugar Maple Dr. Wright-Patterson AFB OH 45433 GREENE (937) 257-9926 Acute Care - Department of Defense Department of Defense TRUE 39.8052276 -84.0370421 1 ROOFTOP 57 39 39057 19380 Dayton-Springfield-Sidney, OH Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-a32h-jkdv-qubw                                      
2476 2476 Keller ACH (West Point) 900 Washington Rd West Point NY 10996 ORANGE (845) 938-4034 Acute Care - Department of Defense Department of Defense TRUE 41.4007200 -73.9767670 0   71 36 36071 35620 New York-Newark, NY-NJ-CT-PA Outlying Orange County https://data.medicare.gov/resource/xubh-q36u/row-96r4-63ca~eik6                                      
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
533 533 SURGICAL INSTITUTE OF READING 2752 CENTURY BOULEVARD WYOMISSING PA 19610 BERKS (717) 999-9999 Acute Care Hospitals Proprietary FALSE 40.3579510 -75.9875770 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-3aqm~vs6z.7ify 390316 651482 2019-06-25 2018-12-31 15           15               15
1021 1021 FAIRVIEW LAKES MEDICAL CENTER 5200 FAIRVIEW BOULEVARD WYOMING MN 55092 CHISAGO (763) 389-6481 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.3222670 -92.9984660 0   25 27 27025 33460 Minneapolis-St. Paul, MN-WI Outlying Chisago County https://data.medicare.gov/resource/xubh-q36u/row-ikkv.xzb8-j7fx 240050 650496 2019-05-31 2018-12-31 45 10         55               55
2702 2702 METRO HEALTH HOSPITAL 5900 BYRON CENTER AVENUE, SW WYOMING MI 49519 KENT (616) 252-7200 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8580670 -85.7229370 0   81 26 26081 24340 Grand Rapids-Wyoming-Muskegon, MI Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-hjd9~97p4.t5d2 230236 661017 2019-11-26 2019-06-30 171 16         187           21   208
2975 2975 MAIN LINE HOSPITAL LANKENAU 100 LANCASTER AVE WYNNEWOOD PA 19096 MONTGOMERY (610) 645-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.9885015 -75.2573400 1 ROOFTOP 91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-3n5e-rxti_zaqf 390195 660298 2019-11-27 2019-06-30 302 46         370               370
11 11 CROSSRIDGE COMMUNITY HOSPITAL 310 SOUTH FALLS BOULEVARD WYNNE AR 72396 CROSS (870) 238-3300 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.2203530 -90.7874210 0   37 5 5037         https://data.medicare.gov/resource/xubh-q36u/row-9vam~w7bd~4ivg 41307 644210 2019-02-27 2018-09-30 15           15               15
4170 4170 HENRY FORD WYANDOTTE HOSPITAL 2333 BIDDLE AVE WYANDOTTE MI 48192 WAYNE (734) 246-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.2096940 -83.1487760 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-qx72.w4qi.dfny 230146 650160 2019-06-03 2018-12-31 201 80         281 38 38           357
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
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
3316 3316 SANFORD WORTHINGTON MEDICAL CENTER 1018 SIXTH AVENUE PO BOX 997 WORTHINGTON MN 56187 NOBLES (507) 372-3110 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6218580 -95.5991790 0   105 27 27105 49380   Central Nobles County https://data.medicare.gov/resource/xubh-q36u/row-vkcf_xfj8_fn99 240022 649449 2019-05-23 2018-12-31 48           48               48
1719 1719 WASHAKIE MEDICAL CENTER 400 SOUTH 15TH STREET WORLAND WY 82401 WASHAKIE (307) 347-3221 Critical Access Hospitals Government - Local TRUE 44.0135560 -107.9484090 0   43 56 56043         https://data.medicare.gov/resource/xubh-q36u/row-wgjq-rwdt.3x58 531306 649859 2019-06-03 2018-12-31 18           18               18
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
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
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
387 387 LANDMARK MEDICAL CENTER 115 CASS AVENUE WOONSOCKET RI 2895 PROVIDENCE (401) 769-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0053200 -71.4962100 0   7 44 44007 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Providence County https://data.medicare.gov/resource/xubh-q36u/row-ywvs_4dtp_6u43 410011 649821 2019-06-03 2018-12-31 107 16         123 18             141
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
4678 4678 TYLER COUNTY HOSPITAL 1100 WEST BLUFF WOODVILLE TX 75979 TYLER (409) 283-8141 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.7752870 -94.4282200 0   457 48 48457         https://data.medicare.gov/resource/xubh-q36u/row-xfu9.wq3c~xr3i 450460 660053 2019-11-25 2019-06-30 25           25               25
449 449 COTTAGE HOSPITAL 90 SWIFTWATER RD WOODSVILLE NH 3785 GRAFTON (603) 747-9000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.1362340 -72.0222910 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-8qq6_qdvh_tpdv 301301 643282 2019-02-20 2018-09-30 25           25 10             35
4242 4242 SHENANDOAH MEMORIAL HOSPITAL 759 SOUTH MAIN STREET WOODSTOCK VA 22664 SHENANDOAH (540) 459-1100 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8715860 -78.5139360 0   171 51 51171         https://data.medicare.gov/resource/xubh-q36u/row-quwy~3csn~r6hx 491305 650918 2019-06-07 2018-12-31 25           25               25
2631 2631 HOWARD YOUNG MEDICAL CTR 240 MAPLE ST WOODRUFF WI 54568 VILAS (715) 356-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 45.8943700 -89.7018370 0   85 55 55085         https://data.medicare.gov/resource/xubh-q36u/row-9mxb-vzak_pksq 520091 661681 2019-11-27 2019-06-30 40 10         50               50
3585 3585 UCHEALTH PIKES PEAK REGIONAL HOSPITAL 16420 WEST HIGHWAY 24 WOODLAND PARK CO 80863 TELLER (719) 687-9999 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.9739320 -105.0742670 0   119 8 8119 17820   Outlying Teller County https://data.medicare.gov/resource/xubh-q36u/row-rxec_h64n-ugar 61326 660069 2019-11-27 2019-06-30 15           15               15
1500 1500 KAISER FOUNDATION HOSPITAL - WOODLAND HILLS 5601 DE SOTO AVENUE WOODLAND HILLS CA 91367 LOS ANGELES (818) 719-3800 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.1718520 -118.5881830 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-ezxu_zdi4_3tgf 50677 652228 2019-06-06 2018-12-31 218 22         252               252
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
699 699 INSPIRA MEDICAL CENTER WOODBURY 509 N BROAD ST WOODBURY NJ 8096 GLOUCESTER (856) 845-0100 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.8435560 -75.1490230 0   15 34 34015 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Gloucester County https://data.medicare.gov/resource/xubh-q36u/row-a399.auyf.26ja 310081 649625 2019-05-29 2018-12-31 219 14         233 20             253
714 714 SAINT THOMAS STONES RIVER HOSPITAL 324 DOOLITTLE ROAD WOODBURY TN 37190 CANNON (615) 563-4001 Acute Care Hospitals Proprietary TRUE 35.8328650 -86.0729430 0   15 47 47015 34980 Nashville-Davidson--Murfreesboro, TN Outlying Cannon County https://data.medicare.gov/resource/xubh-q36u/row-cff9_8h9t.y7xa 440200 659459 2019-11-25 2019-06-30 30           30 22             52
4174 4174 HEALTHEAST WOODWINDS HOSPITAL 1925 WOODWINDS DRIVE WOODBURY MN 55125 WASHINGTON (651) 232-0228 Acute Care Hospitals Voluntary non-profit - Private FALSE 44.9235100 -92.9753530 0   163 27 27163 33460 Minneapolis-St. Paul, MN-WI Central Washington County https://data.medicare.gov/resource/xubh-q36u/row-4d9n_j9un-72qy 240213 657898 2019-02-01 2018-08-31 68 18         86               86
4071 4071 SENTARA NORTHERN VIRGINIA MEDICAL CENTER 2300 OPITZ BOULEVARD WOODBRIDGE VA 22191 PRINCE WILLIAM (703) 523-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.6349530 -77.2842110 0   153 51 51153 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Prince William County https://data.medicare.gov/resource/xubh-q36u/row-dxh7~pevv~76cc 490113 650413 2019-05-31 2018-12-31 131 16         147               147
2 2 HUGGINS HOSPITAL 240 SOUTH MAIN STREET WOLFEBORO NH 3894 CARROLL (603) 569-7500 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.5809440 -71.2015750 0   3 33 33003         https://data.medicare.gov/resource/xubh-q36u/row-u6j2-zv25.9ghd 301312 659991 2019-11-25 2018-09-30 21 4         25               25
2797 2797 TRINITY HOSPITAL 315 KNAPP ST WOLF POINT MT 59201 ROOSEVELT (406) 653-6500 Critical Access Hospitals Voluntary non-profit - Private TRUE 48.1008930 -105.6411380 0   85 30 30085         https://data.medicare.gov/resource/xubh-q36u/row-8zsu~ksjh-u24d 271341 659988 2019-11-25 2019-06-30 22           22       60       82
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
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
3640 3640 MADISON COUNTY HEALTH CARE SYSTEM 300 WEST HUTCHINGS STREET WINTERSET IA 50273 MADISON (515) 462-2373 Critical Access Hospitals Government - Local TRUE 41.3288160 -94.0169630 0   121 19 19121 19780 Des Moines-Ames-West Des Moines, IA Outlying Madison County https://data.medicare.gov/resource/xubh-q36u/row-qsgk_v4q5~5yrz 161326 660963 2019-11-27 2019-06-30 25           25               25
4616 4616 NORTH RUNNELS HOSPITAL 7821 EAST HIGHWAY 153 WINTERS TX 79567 RUNNELS (325) 754-4553 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.9498620 -99.9598240 0   399 48 48399         https://data.medicare.gov/resource/xubh-q36u/row-hszw.eyaq-hdvd 451315 659073 2019-11-18 2019-06-30 15           15               15
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
2365 2365 NORTH CAROLINA BAPTIST HOSPITAL MEDICAL CENTER BOULEVARD WINSTON-SALEM NC 27157 FORSYTH (336) 716-2011 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0896734 -80.2713468 1 GEOMETRIC_CENTER 67 37 37067 49180 Greensboro--Winston-Salem--High Point, NC Central Forsyth County https://data.medicare.gov/resource/xubh-q36u/row-r4e3-jftf~8jdf 340047 661763 2019-12-02 2019-06-30 565 110 22 16     797 34 39           870
2366 2366 NOVANT HEALTH MEDICAL PARK HOSPITAL 1950 S HAWTHORNE RD WINSTON-SALEM NC 27103 FORSYTH (336) 718-0600 Acute Care Hospitals Voluntary non-profit - Other FALSE 36.0781590 -80.2957150 0   67 37 37067 49180 Greensboro--Winston-Salem--High Point, NC Central Forsyth County https://data.medicare.gov/resource/xubh-q36u/row-ddsg-nw9h-w7fm 340148 650347 2019-05-31 2018-12-31 20 2         22               22
2367 2367 NOVANT HEALTH FORSYTH MEDICAL CENTER 3333 SILAS CREEK PARKWAY WINSTON-SALEM NC 27103 FORSYTH (336) 718-5000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0739420 -80.2985650 0   67 37 37067 49180 Greensboro--Winston-Salem--High Point, NC Central Forsyth County https://data.medicare.gov/resource/xubh-q36u/row-vqz8-9xk9.j6mf 340014 650332 2019-05-31 2018-12-31 737 68 24       889 12             901
721 721 LITTLE COLORADO MEDICAL CENTER 1501 NORTH WILLIAMSON AVENUE WINSLOW AZ 86047 NAVAJO (928) 289-4691 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0354550 -110.6917420 0   17 4 4017 43320   Central Navajo County https://data.medicare.gov/resource/xubh-q36u/row-wt4g_v5ea_tink 31311 643756 2019-02-27 2018-09-30 25           25               25
3112 3112 TYLER HOLMES MEMORIAL HOSPITAL CAH 409 TYLER HOLMES DRIVE WINONA MS 38967 MONTGOMERY (662) 283-4114 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.4906520 -89.7377480 0   97 28 28097         https://data.medicare.gov/resource/xubh-q36u/row-ynxj~8abv-iadk 251312 643802 2019-03-01 2018-09-30 25           25               25
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
1647 1647 FRANKLIN MEDICAL CENTER 2106 LOOP ROAD WINNSBORO LA 71295 FRANKLIN (318) 435-9411 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.1588800 -91.7052340 0   41 22 22041         https://data.medicare.gov/resource/xubh-q36u/row-pz3b~fmut.fx5c 190140 654726 2019-10-01 2019-04-30 23 6         29   8           37
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
2491 2491 RICELAND MEDICAL CENTER 538 BROADWAY WINNIE TX 77665 CHAMBERS (409) 296-6000 Critical Access Hospitals Proprietary TRUE 29.8205230 -94.3771330 0   71 48 48071 26420 Houston-The Woodlands, TX Central Chambers County https://data.medicare.gov/resource/xubh-q36u/row-wtt6~522f_uuw2 451328 659900 2019-11-08 2018-12-31 25           25               25
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
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
623 623 HUMBOLDT GENERAL HOSPITAL 118 EAST HASKELL STREET WINNEMUCCA NV 89445 HUMBOLDT (775) 623-5222 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.9715810 -117.7285340 0   13 32 32013 49080   Central Humboldt County https://data.medicare.gov/resource/xubh-q36u/row-ca7p_4a94-fjt7 291308 641600 2018-11-30 2018-06-30 22 3         25       42       67
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
1689 1689 CENTRAL DUPAGE HOSPITAL 25 NORTH WINFIELD ROAD WINFIELD IL 60190 DU PAGE (630) 682-1600 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.8737650 -88.1580950 0   43 17 17043 16980 Chicago-Naperville, IL-IN-WI Central DuPage County https://data.medicare.gov/resource/xubh-q36u/row-uk94-fquw~zwsp 140242 661316 2019-02-04 2018-08-31 272 36 16     23 347 48             395
2986 2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
704 704 VIDANT BERTIE HOSPITAL 1403 SOUTH KINGS STREET WINDSOR NC 27983 BERTIE (252) 794-6600 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9893550 -76.9281830 0   15 37 37015         https://data.medicare.gov/resource/xubh-q36u/row-pwdr-dt5d-exsb 341304 644156 2019-02-28 2018-09-30 6           6               6
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
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
599 599 NORTHEAST GEORGIA MEDICAL CENTER BARROW 316 NORTH BROAD STREET WINDER GA 30680 BARROW (770) 848-8611 Acute Care Hospitals Proprietary TRUE 34.0077010 -83.7067060 0   13 13 13013 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Barrow County https://data.medicare.gov/resource/xubh-q36u/row-hr24_ckbz~3ykf 110045 644713 2019-03-01 2018-09-30 50 6         56               56
3449 3449 CHAN SOON- SHIONG MEDICAL CENTER AT WINDBER 600 SOMERSET AVENUE WINDBER PA 15963 SOMERSET (814) 467-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.2421230 -78.8379170 0   111 42 42111 43740 Johnstown-Somerset, PA Central Somerset County https://data.medicare.gov/resource/xubh-q36u/row-fcgp~zjpu~zgnn 390112 660443 2019-11-27 2019-06-30 41 6         47           7   54
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
1837 1837 CLARK REGIONAL MEDICAL CENTER 175 HOSPITAL DRIVE WINCHESTER KY 40391 CLARK (859) 737-8559 Acute Care Hospitals Proprietary TRUE 38.0105110 -84.2145900 0   49 21 21049 30460 Lexington-Fayette--Richmond--Frankfort, KY Outlying Clark County https://data.medicare.gov/resource/xubh-q36u/row-6qnq-q4j6-cjcb 180092 655000 2019-09-30 2019-04-30 46 8         54       25       79
1933 1933 SOUTHERN TENNESSEE REGIONAL HLTH SYSTEM WINCHESTER 185 HOSPITAL ROAD WINCHESTER TN 37398 FRANKLIN (931) 967-8295 Acute Care Hospitals Proprietary TRUE 35.1760230 -86.0910760 0   51 47 47051 46100   Outlying Franklin County https://data.medicare.gov/resource/xubh-q36u/row-au3a_wp3s-29ym 440058 651234 2019-05-30 2018-12-31 118 10         128 12 12   46       198
2856 2856 F W HUSTON MEDICAL CENTER 408 DELAWARE STREET WINCHESTER KS 66097 JEFFERSON (913) 774-4340 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.3252310 -95.2704010 0   87 20 20087 45820   Outlying Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-ms4u_ppxf-axv2 171314 649589 2019-06-03 2018-12-31 25           25         38 6   69
3853 3853 ST VINCENT RANDOLPH HOSPITAL INC 473 E GREENVILLE AVE WINCHESTER IN 47394 RANDOLPH (765) 584-0004 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.1678770 -84.9703940 0   135 18 18135         https://data.medicare.gov/resource/xubh-q36u/row-ziei~9dqq.tkpr 151301 660946 2019-12-02 2019-06-30 25           25               25
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
3805 3805 PULASKI MEMORIAL HOSPITAL 616 E 13TH ST WINAMAC IN 46996 PULASKI (574) 946-2100 Critical Access Hospitals Voluntary non-profit - Other TRUE 41.0573840 -86.5956410 0   131 18 18131         https://data.medicare.gov/resource/xubh-q36u/row-6mwe~ik57~dtx4 151305 653135 2019-08-09 2018-09-30 25           25               25
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
150 150 ST FRANCIS HOSPITAL 7TH AND CLAYTON STS WILMINGTON DE 19805 NEW CASTLE (302) 421-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7498827 -75.5665813 1 ROOFTOP 3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-2uda_n6xn~szp8 80003 660361 2019-12-03 2019-06-30 154 20         180               180
151 151 ALFRED I DUPONT HOSPITAL FOR CHILDREN 1600 ROCKLAND RD PO BOX 269 WILMINGTON DE 19899 NEW CASTLE (302) 651-4000 Childrens Voluntary non-profit - Private TRUE 39.7823370 -75.5552390 0   3 10 10003 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central New Castle County https://data.medicare.gov/resource/xubh-q36u/row-b9cf-cftg-3kpg 83300 659028 2019-11-13 2018-12-31 114         24 208               208
1096 1096 CLINTON MEMORIAL HOSPITAL 610 WEST MAIN STREET WILMINGTON OH 45177 CLINTON (937) 382-6611 Acute Care Hospitals Government - Local TRUE 39.4455420 -83.8394060 0   27 39 39027 48940 Cincinnati-Wilmington-Maysville, OH-KY-IN Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-cuks-2rvh-qwpd 360175 648304 2019-05-21 2018-12-31 69 6         75               75
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

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