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

807 rows where "fy_end_date" is on date 2018-09-30 sorted by county_name

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, burn_beds, surg_icu_beds, nursing_fac_beds, oth_longterm_beds, filed_date (date)

fy_end_date (date) ✖

  • 2018-09-30 · 807 ✖
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
121 121 ABBEVILLE AREA MEDICAL CENTER 420 THOMSON CIRCLE ABBEVILLE SC 29620 ABBEVILLE (864) 366-5011 Critical Access Hospitals Government - Local TRUE 34.1561250 -82.3801740 0   1 45 45001 24940 Greenville-Spartanburg-Anderson, SC Outlying Abbeville County https://data.medicare.gov/resource/xubh-q36u/row-v8xu.2huz_ubxe 421301 645182 2019-02-25 2018-09-30 19 6         25               25
92 92 ACADIA GENERAL HOSPITAL 1305 CROWLEY RAYNE HIGHWAY CROWLEY LA 70526 ACADIA (337) 783-3222 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.2263270 -92.3625430 0   1 22 22001 29180 Lafayette-Opelousas-Morgan City, LA Outlying Acadia Parish https://data.medicare.gov/resource/xubh-q36u/row-uxyh.5msh~3m79 190044 643888 2019-03-01 2018-09-30 136 4         140               140
87 87 ST LUKE'S REGIONAL MEDICAL CENTER 190 EAST BANNOCK STREET BOISE ID 83712 ADA (208) 381-2222 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6121570 -116.1922020 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-7i3s_c82d-yek7 130006 651557 2019-06-21 2018-09-30 410 46 17     73 559   19           578
90 90 T J HEALTH COLUMBIA 901 WESTLAKE DRIVE COLUMBIA KY 42728 ADAIR (270) 384-4753 Acute Care Hospitals Government - Hospital District or Authority TRUE 37.0962890 -85.2949400 0   1 21 21001         https://data.medicare.gov/resource/xubh-q36u/row-7iis-x23i.zsak 180149 640382 2018-12-31 2018-09-30 49           49 20             69
99 99 MERIT HEALTH NATCHEZ 52 SERGEANT PRENTISS DRIVE NATCHEZ MS 39120 ADAMS (601) 443-2100 Acute Care Hospitals Proprietary TRUE 31.5279831 -91.3884516 1 RANGE_INTERPOLATED 1 28 28001 35020   Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-36cp~uwxv-3duz 250084 643800 2019-02-27 2018-09-30 132 15         147 12 20           179
2346 2346 BLESSING HOSPITAL BROADWAY ST & N 11TH ST QUINCY IL 62305 ADAMS (217) 223-1200 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.3930840 -91.3440810 0   67 17 17067 22800   Outlying Hancock County https://data.medicare.gov/resource/xubh-q36u/row-pfrr.qnhm.x236 140015 645244 2019-02-27 2018-09-30 223 25         248 41 18   20       327
126 126 PORTER HOSPITAL, INC 115 PORTER DRIVE MIDDLEBURY VT 5753 ADDISON (802) 388-4701 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.9994700 -73.1698030 0   1 50 50001         https://data.medicare.gov/resource/xubh-q36u/row-xcfu_sc2r.d4bu 471307 653360 2019-08-29 2018-09-30 25           25               25
98 98 RIVERWOOD HEALTHCARE CENTER 200 BUNKER HILL DRIVE AITKIN MN 56431 AITKIN (218) 927-5501 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5292020 -93.6968080 0   1 27 27001         https://data.medicare.gov/resource/xubh-q36u/row-ybgp~gnb5~d4ww 241305 655456 2019-10-08 2018-09-30 21 4         25               25
115 115 ALAMANCE REGIONAL MEDICAL CENTER 1240 HUFFMAN MILL RD BURLINGTON NC 27216 ALAMANCE (336) 538-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.0637490 -79.5025280 0   1 37 37001 15500 Greensboro--Winston-Salem--High Point, NC Central Alamance County https://data.medicare.gov/resource/xubh-q36u/row-x8vw.bx9c.7dbj 340070 643428 2019-02-27 2018-09-30 144 20         176 36             212
47 47 ST ROSE HOSPITAL 27200 CALAROGA AVE HAYWARD CA 94545 ALAMEDA (510) 782-6200 Acute Care Hospitals Voluntary non-profit - Church TRUE 37.6329100 -122.0897420 0   1 6 6001 41860 San Jose-San Francisco-Oakland, CA Central Alameda County https://data.medicare.gov/resource/xubh-q36u/row-mad2-q4zt.hret 50002 644971 2019-03-06 2018-09-30 180 15         195               195
186 186 MAGNOLIA REGIONAL HEALTH CENTER 611 ALCORN DRIVE CORINTH MS 38834 ALCORN (662) 293-1000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.9358670 -88.5586480 0   3 28 28003 18420   Central Alcorn County https://data.medicare.gov/resource/xubh-q36u/row-7e2c-erdj.3exa 250009 643795 2019-02-28 2018-09-30 139 24         163 19             182
309 309 ALLEGHANY COUNTY MEMORIAL HOSPITAL 617 DOCTORS STREET SPARTA NC 28675 ALLEGHANY (336) 372-5511 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.5095115 -81.1150447 1 RANGE_INTERPOLATED 5 37 37005         https://data.medicare.gov/resource/xubh-q36u/row-zjv8.p46n-e733 341320 645140 2019-03-04 2018-09-30 25           25               25
317 317 ALLENDALE COUNTY HOSPITAL 1787 ALLENDALE FAIRFAX RD FAIRFAX SC 29827 ALLENDALE (803) 632-3311 Critical Access Hospitals Government - Local TRUE 32.9662250 -81.2477270 0   5 45 45005         https://data.medicare.gov/resource/xubh-q36u/row-bjdu~dq8g.u82d 421300 645444 2019-03-04 2018-09-30 25           25       44       69
873 873 ALASKA NATIVE MEDICAL CENTER 4315 DIPLOMACY DR ANCHORAGE AK 99508 ANCHORAGE (907) 729-3971 Acute Care Hospitals Government - Federal TRUE 61.1818900 -149.8005780 0   20 2 2020 11260   Central Anchorage Municipality https://data.medicare.gov/resource/xubh-q36u/row-5h7d.5evj.yxgq 20026 651310 2019-07-01 2018-09-30 173         1 174               174
244 244 PERMIAN REGIONAL MEDICAL CENTER ANDREWS COUNTY HO 720 HOSPITAL DRIVE ANDREWS TX 79714 ANDREWS (432) 523-2200 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.3374240 -102.5468660 0   3 48 48003 11380   Central Andrews County https://data.medicare.gov/resource/xubh-q36u/row-juik.55wn.c6fd 450144 643151 2019-02-12 2018-09-30 30           30               30
38 38 FORT DEFIANCE INDIAN HOSPITAL PO BOX 649 FORT DEFIANCE AZ 86504 APACHE (928) 729-8000 Acute Care Hospitals Government - Federal TRUE 35.7593170 -109.0483992 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-ss8d_atq6.7xb3 30071 651311 2019-07-02 2018-09-30 56           56               56
39 39 SAGE MEMORIAL HOSPITAL STATE ROUTE 264 SOUTH 191 GANADO AZ 86505 APACHE (928) 755-4541 Critical Access Hospitals Voluntary non-profit - Private FALSE 35.7108602 -109.5423597 1 ROOFTOP 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-vmgp-erfi.puty 31309 652060 2019-05-06 2018-09-30 25           25               25
40 40 CHINLE COMPREHENSIVE HEALTH CARE FACILITY US HWY 191, HOSPITAL ROAD CHINLE AZ 86503 APACHE (928) 674-7001 Acute Care Hospitals Government - Federal TRUE 36.1575812 -109.6076963 1 GEOMETRIC_CENTER 1 4 4001         https://data.medicare.gov/resource/xubh-q36u/row-u7kj_iqgg.38d9 30084 649393 2019-06-12 2018-09-30 60           60               60
261 261 SWEDISH MEDICAL CENTER 501 E HAMPDEN AVE ENGLEWOOD CO 80113 ARAPAHOE (303) 788-5000 Acute Care Hospitals Proprietary TRUE 39.6531360 -104.9817100 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-3yvr.y5p2.2bay 60034 643574 2019-02-26 2018-09-30 281 58       17 356   16           372
177 177 NORTHERN MAINE MEDICAL CENTER 194 E MAIN STREET FORT KENT ME 4743 AROOSTOOK (207) 834-3195 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.2650680 -68.5911770 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-cr45-cm3b-wfye 200052 645099 2019-02-28 2018-09-30 43           43 6     45       94
178 178 NORTHERN LIGHT A R GOULD HOSPITAL PO BOX 151 PRESQUE ISLE ME 4769 AROOSTOOK (207) 768-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.6751494 -67.9985861 1 ROOFTOP 3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-ihck.jhth~929r 200018 650152 2019-05-29 2018-09-30 43 6         49   5   14 50     118
179 179 HOULTON REGIONAL HOSPITAL 20 HARTFORD STREET HOULTON ME 4730 AROOSTOOK (207) 532-2900 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.1329620 -67.8426440 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-tx6y-y4iu-nd9t 201308 645561 2019-03-04 2018-09-30 25           25               25
251 251 MEMORIAL MEDICAL CENTER 1615 MAPLE LANE ASHLAND WI 54806 ASHLAND (715) 685-5500 Critical Access Hospitals Voluntary non-profit - Private TRUE 46.5668870 -90.8879780 0   3 55 55003         https://data.medicare.gov/resource/xubh-q36u/row-d5tf.6nqz~nbsb 521359 645519 2019-03-01 2018-09-30 25           25 10             35
1 1 ASHLEY COUNTY MEDICAL CENTER 1015 UNITY ROAD CROSSETT AR 71635 ASHLEY (870) 364-4111 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.1372060 -91.9387800 0   3 5 5003         https://data.medicare.gov/resource/xubh-q36u/row-gq3d.ak25_8qvw 41323 642385 2019-01-15 2018-09-30 19 6         25 10             35
275 275 ATCHISON HOSPITAL 800 RAVIN HILL DRIVE ATCHISON KS 66002 ATCHISON (913) 360-5581 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.5366253 -95.1282386 1 ROOFTOP 5 20 20005 11860 Kansas City-Overland Park-Kansas City, MO-KS Central Atchison County https://data.medicare.gov/resource/xubh-q36u/row-fwt4-3qfd~33ue 171382 645412 2019-03-01 2018-09-30 21 4         25               25
363 363 BAPTIST MEDICAL CENTER-ATTALA 220 HWY 12 WEST KOSCIUSKO MS 39090 ATTALA (662) 289-4311 Critical Access Hospitals Voluntary non-profit - Other TRUE 33.0655920 -89.5967210 0   7 28 28007         https://data.medicare.gov/resource/xubh-q36u/row-24jy_6div~59c7 251336 644042 2019-03-01 2018-09-30 25           25               25
523 523 CHARLES A CANNON JR MEMORIAL HOSPITAL 434 HOSPITAL DRIVE LINVILLE NC 28646 AVERY (828) 737-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.0674800 -81.8856780 0   11 37 37011         https://data.medicare.gov/resource/xubh-q36u/row-8t8e~pm2z_adds 341323 645351 2019-02-28 2018-09-30 21           21 10             31
792 792 MULESHOE AREA MEDICAL CENTER 708 S 1ST ST MULESHOE TX 79347 BAILEY (806) 272-4524 Critical Access Hospitals Proprietary TRUE 34.2210290 -102.7284580 0   17 48 48017         https://data.medicare.gov/resource/xubh-q36u/row-2yhf.nyid~b2dz 451372 644191 2019-02-28 2018-09-30 25           25               25
153 153 ED FRASER MEMORIAL HOSPITAL 159 N 3RD ST MACCLENNY FL 32063 BAKER (904) 259-3151 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.2855500 -82.1195500 0   3 12 12003 27260 Jacksonville-St. Marys-Palatka, FL-GA Outlying Baker County https://data.medicare.gov/resource/xubh-q36u/row-bder~g3nx~udyj 100134 644243 2019-03-01 2018-09-30 21           21       68       89
133 133 SOUTH BALDWIN REGIONAL MEDICAL CENTER 1613 NORTH MCKENZIE STREET FOLEY AL 36535 BALDWIN (251) 949-3400 Acute Care Hospitals Proprietary TRUE 30.4261090 -87.6831870 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-pyt4.i3a3.r8cm 10083 645389 2019-03-01 2018-09-30 82 30         112               112
423 423 NAVICENT HEALTH BALDWIN 821 NORTH COBB STREET MILLEDGEVILLE GA 31061 BALDWIN (478) 454-3550 Acute Care Hospitals Proprietary TRUE 33.0884310 -83.2451450 0   9 13 13009 33300   Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-4c5x-vuf4-z6uq 110150 655099 2019-10-10 2018-09-30 86 12         98       15       113
616 616 BARAGA COUNTY MEMORIAL HOSPITAL 18341 US HIGHWAY 41 L' ANSE MI 49946 BARAGA (906) 524-3300 Critical Access Hospitals Government - Local TRUE 46.7344600 -88.4280420 0   13 26 26013         https://data.medicare.gov/resource/xubh-q36u/row-kzgx-j54h-paej 231307 645568 2019-03-05 2018-09-30 24           24               24
96 96 CAPE COD HOSPITAL 88 LEWIS BAY ROAD HYANNIS MA 2601 BARNSTABLE (508) 771-1800 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6528230 -70.2748470 0   1 25 25001 12700 Boston-Worcester-Providence, MA-RI-NH-CT Central Barnstable County https://data.medicare.gov/resource/xubh-q36u/row-wu4e-kfxd~b2tt 220012 644735 2019-03-08 2018-09-30 215 11 13       239 20             259
97 97 FALMOUTH HOSPITAL 67 & 100 TER HEUN DRIVE FALMOUTH MA 2540 BARNSTABLE (508) 548-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5649620 -70.6211260 0   1 25 25001 12700 Boston-Worcester-Providence, MA-RI-NH-CT Central Barnstable County https://data.medicare.gov/resource/xubh-q36u/row-ycds_hhnf.xdyd 220135 645109 2019-03-08 2018-09-30 85 10         95               95
434 434 T J SAMSON COMMUNITY HOSPITAL 1301 NORTH RACE STREET GLASGOW KY 42141 BARREN (270) 651-4159 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.0115660 -85.9038620 0   9 21 21009 23980 Bowling Green-Glasgow, KY Central Barren County https://data.medicare.gov/resource/xubh-q36u/row-ry2c-3t2y_53py 180017 643409 2019-02-14 2018-09-30 94 10       4 108       16   6   130
330 330 MARSHFIELD MEDICAL CENTER - RICE LAKE 1700 WEST STOUT STREET RICE LAKE WI 54868 BARRON (715) 234-1515 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5080420 -91.7590270 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-skqj~bt33-3hxj 520011 640931 2019-01-10 2018-09-30 35 5         40               40
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
446 446 COX MONETT HOSPITAL 801 NORTH LINCOLN AVENUE MONETT MO 65708 BARRY (417) 354-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.9266330 -93.9312500 0   9 29 29009         https://data.medicare.gov/resource/xubh-q36u/row-egvf~xwpf-7msx 261329 645668 2019-03-06 2018-09-30 25           25               25
433 433 ELLINWOOD DISTRICT HOSPITAL 605 N MAIN STREET ELLINWOOD KS 67526 BARTON (620) 564-2548 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3607070 -98.5811930 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-kt5p.cy3y_6d85 171301 661185 2019-02-28 2018-09-30 25           25               25
513 513 COX BARTON COUNTY HOSPITAL 29 NW 1ST LANE LAMAR MO 64759 BARTON (417) 682-6081 Critical Access Hospitals Government - Local TRUE 37.5052820 -94.2994820 0   11 29 29011         https://data.medicare.gov/resource/xubh-q36u/row-8cv5-t4zj_7sig 261325 645577 2019-03-04 2018-09-30 21 4         25               25
680 680 CARTERSVILLE MEDICAL CENTER 960 JOE FRANK HARRIS PARKWAY CARTERSVILLE GA 30120 BARTOW (770) 387-8182 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1995441 -84.7932932 1 ROOFTOP 15 13 13015 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Bartow County https://data.medicare.gov/resource/xubh-q36u/row-w3nk-2vm4_5tut 110030 644712 2019-02-28 2018-09-30 98 21         119               119
757 757 MCLAREN BAY REGION 1900 COLUMBUS AVE BAY CITY MI 48708 BAY (989) 894-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5893920 -83.8680890 0   17 26 26017 13020 Saginaw-Midland-Bay City, MI Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-ribz~nm28_niqn 230041 644292 2019-02-21 2018-09-30 265 32         297 23 20           340
639 639 VIDANT BEAUFORT HOSPITAL 628 E 12TH ST WASHINGTON NC 27889 BEAUFORT (252) 975-4100 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.5486620 -77.0388330 0   13 37 37013 47820 Greenville-Washington, NC Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-reur_4bn8-9x84 340186 644155 2019-02-28 2018-09-30 64 8         72 19             91
649 649 BEAUFORT COUNTY MEMORIAL HOSPITAL 955 RIBAUT RD BEAUFORT SC 29902 BEAUFORT (843) 522-5200 Acute Care Hospitals Government - Local TRUE 32.4172440 -80.6885460 0   13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-simj~c9x8.yqtx 420067 644559 2019-02-25 2018-09-30 155 12         167 14 14           195
104 104 LAKES REGION GENERAL HOSPITAL 80 HIGHLAND ST LACONIA NH 3246 BELKNAP (603) 524-3211 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5281030 -71.4607710 0   1 33 33001 29060 Boston-Worcester-Providence, MA-RI-NH-CT Central Belknap County https://data.medicare.gov/resource/xubh-q36u/row-xfbk~rfzq_m6dx 300005 644140 2019-02-28 2018-09-30 76 10         86 10             96
1107 1107 ADVENTHEALTH CENTRAL TEXAS 2201 S CLEAR CREEK ROAD KILLEEN TX 76542 BELL (254) 526-7523 Acute Care Hospitals Voluntary non-profit - Church TRUE 31.1133500 -97.7995190 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-d3a2-awra.pykq 450152 656365 2019-10-17 2018-09-30 194 10       4 208               208
362 362 RED LAKE HOSPITAL A PO BOX 497 REDLAKE MN 56671 BELTRAMI (218) 679-3912 Acute Care Hospitals Government - Federal FALSE 47.8763460 -95.0169401 1 GEOMETRIC_CENTER 7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-jefe.tmy8.7dit 240206 649909 2019-06-18 2018-09-30 23           23               23
247 247 SOUTHWESTERN VERMONT MEDICAL CENTER 100 HOSPITAL DRIVE BENNINGTON VT 5201 BENNINGTON (802) 442-6361 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.8739110 -73.2043430 0   3 50 50003 13540   Central Bennington County https://data.medicare.gov/resource/xubh-q36u/row-jv4q-u445-esay 470012 644194 2019-02-28 2018-09-30 68 10         78               78
182 182 FAIRVIEW HOSPITAL 29 LEWIS AVENUE GREAT BARRINGTON MA 1230 BERKSHIRE (413) 528-0790 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1919820 -73.3725230 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-6zsa~q4z7~nrdp 221302 645425 2019-03-01 2018-09-30 20 4         24               24
183 183 BERKSHIRE MEDICAL CENTER INC - 1 725 NORTH STREET PITTSFIELD MA 1201 BERKSHIRE (413) 447-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.4587480 -73.2490040 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-58b2-r4te.ddyn 220046 661336 2019-12-02 2018-09-30 201 20         221 40 14           275
4 4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
907 907 LAKELAND HOSPITAL WATERVLIET 400 MEDICAL PARK DR WATERVLIET MI 49098 BERRIEN (269) 463-3111 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.1848660 -86.2507600 0   21 26 26021 35660 South Bend-Elkhart-Mishawaka, IN-MI Central Berrien County https://data.medicare.gov/resource/xubh-q36u/row-7efk~hcgi~rsxw 230078 645339 2019-02-28 2018-09-30 26           26   18           44
908 908 LAKELAND HOSPITAL, ST JOSEPH 1234 NAPIER AVENUE ST JOSEPH MI 49085 BERRIEN (269) 983-8300 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0897420 -86.4771940 0   21 26 26021 35660 South Bend-Elkhart-Mishawaka, IN-MI Central Berrien County https://data.medicare.gov/resource/xubh-q36u/row-vr3m_ja72-rybg 230021 645427 2019-03-01 2018-09-30 244 20         264 26             290
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
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
1183 1183 SOUTHWEST GENERAL HOSPITAL 7400 BARLITE BLVD SAN ANTONIO TX 78224 BEXAR (210) 921-2000 Acute Care Hospitals Physician TRUE 29.3529880 -98.5465890 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-yzdz.2e4a_mcwd 450697 644371 2019-02-28 2018-09-30 143 18       24 185 24 16           225
336 336 BIBB MEDICAL CENTER 208 PIERSON AVE CENTREVILLE AL 35042 BIBB (205) 926-4881 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.9511010 -87.1478650 0   7 1 1007 13820 Birmingham-Hoover-Talladega, AL Outlying Bibb County https://data.medicare.gov/resource/xubh-q36u/row-h96v_9sq6~aaj9 10058 644693 2019-03-01 2018-09-30 25           25       131       156
889 889 MEDICAL CENTER, NAVICENT HEALTH (THE) 777 HEMLOCK STREET MACON GA 31201 BIBB (478) 633-1000 Acute Care Hospitals Government - Hospital District or Authority TRUE 32.8332020 -83.6365530 0   21 13 13021 31420 Macon-Warner Robins, GA Central Bibb County https://data.medicare.gov/resource/xubh-q36u/row-qa2j~4dhx.y2zw 110107 645712 2019-03-04 2018-09-30 453 77       64 594 16             610
187 187 P H S INDIAN HOSPITAL CROW / NORTHERN CHEYENNE 1010 SOUTH 7650 EAST, POST OFFICE BOX 9 CROW AGENCY MT 59022 BIG HORN (406) 638-2626 Critical Access Hospitals Government - Federal TRUE 45.5821958 -107.4488586 1 ROOFTOP 3 30 30003         https://data.medicare.gov/resource/xubh-q36u/row-pgmt~4b42~eq7a 271339 646565 2019-03-26 2018-09-30 24           24               24
510 510 ORTONVILLE AREA HEALTH SERVICES 450 EASTVOLD AVE ORTONVILLE MN 56278 BIG STONE (320) 839-2505 Critical Access Hospitals Government - Local TRUE 45.3147690 -96.4465630 0   11 27 27011         https://data.medicare.gov/resource/xubh-q36u/row-jt8y~id78.iwpi 241342 645770 2019-03-28 2018-09-30 25           25       51       76
774 774 CAPE FEAR VALLEY-BLADEN COUNTY HOSPITAL 501 SOUTH POPLAR STREET ELIZABETHTOWN NC 28337 BLADEN (910) 862-5100 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.6234740 -78.6082980 0   17 37 37017         https://data.medicare.gov/resource/xubh-q36u/row-t5uc~43ax~cbx3 341315 645438 2019-03-01 2018-09-30 21 4         25               25
294 294 P H S INDIAN HOSPITAL-FT BELKNAP AT HARLEM - CAH 456 GROS VENTRE AVE, RR 1 HARLEM MT 59526 BLAINE (406) 353-3100 Critical Access Hospitals Government - Federal TRUE 48.4851890 -108.7670010 0   5 30 30005         https://data.medicare.gov/resource/xubh-q36u/row-sifm_y3g6.gq5p 271315 646038 2019-03-29 2018-09-30 6           6               6
600 600 ST LUKE'S WOOD RIVER MEDICAL CENTER 100 HOSPITAL DRIVE KETCHUM ID 83340 BLAINE (208) 727-8800 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.6484730 -114.3490180 0   13 16 16013 25200   Central Blaine County https://data.medicare.gov/resource/xubh-q36u/row-pewx.ysiv~gtnq 131323 651610 2019-06-21 2018-09-30 25           25               25
820 820 EASTERN IDAHO REGIONAL MEDICAL CENTER 3100 CHANNING WAY IDAHO FALLS ID 83404 BONNEVILLE (208) 529-6210 Acute Care Hospitals Proprietary TRUE 43.4702760 -111.9901590 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-zu9m_rfwy-xxuk 130018 644978 2019-02-28 2018-09-30 165 35         226 28 17       10   310
515 515 BOONE COUNTY HEALTH CENTER P O BOX 151, 723 WEST FAIRVIEW ST ALBION NE 68620 BOONE (402) 395-2191 Critical Access Hospitals Government - Local TRUE 41.6921113 -98.0002224 1 ROOFTOP 11 31 31011         https://data.medicare.gov/resource/xubh-q36u/row-3j5p_6aw6-77k2 281334 645125 2019-02-28 2018-09-30 25           25               25
458 458 ST ANDREWS HEALTH CENTER - CAH 316 OHMER STREET BOTTINEAU ND 58318 BOTTINEAU (701) 228-9300 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.8291900 -100.4490790 0   9 38 38009         https://data.medicare.gov/resource/xubh-q36u/row-srt8.v5j2-m5pz 351307 645009 2019-03-05 2018-09-30 25           25               25
825 825 KING'S DAUGHTERS' MEDICAL CENTER 2201 LEXINGTON AVENUE ASHLAND KY 41101 BOYD (606) 408-4401 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4704010 -82.6359160 0   19 21 21019 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Boyd County https://data.medicare.gov/resource/xubh-q36u/row-2h99.b8qq_r6h2 180009 643766 2019-02-28 2018-09-30 388 38         439       47       486
897 897 EPHRAIM MCDOWELL REGIONAL MEDICAL CENTER 217 SOUTH THIRD STREET DANVILLE KY 40422 BOYLE (859) 239-2409 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.6438180 -84.7726380 0   21 21 21021 19220   Central Boyle County https://data.medicare.gov/resource/xubh-q36u/row-umsp-afi7~cb4h 180048 643770 2019-03-01 2018-09-30 148 22         170 27     25       222
481 481 BRADLEY COUNTY MEDICAL CENTER 404 SOUTH BRADLEY STREET WARREN AR 71671 BRADLEY (870) 226-3731 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.6105380 -92.0586650 0   11 5 5011         https://data.medicare.gov/resource/xubh-q36u/row-ga7d-t3u8~gykp 41327 644212 2019-03-04 2018-09-30 25           25 10             35
1619 1619 SWEENY COMMUNITY HOSPITAL 305 NORTH MCKINNEY SWEENY TX 77480 BRAZORIA (979) 548-3311 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.0485140 -95.6913920 0   39 48 48039 26420 Houston-The Woodlands, TX Central Brazoria County https://data.medicare.gov/resource/xubh-q36u/row-argn.cnxa-jdss 451311 643974 2019-03-01 2018-09-30 14           14               14
1672 1672 COLLEGE STATION MEDICAL CENTER 1604 ROCK PRAIRIE ROAD COLLEGE STATION TX 77842 BRAZOS (979) 764-5151 Acute Care Hospitals Proprietary TRUE 30.5826260 -96.2910140 0   41 48 48041 17780   Central Brazos County https://data.medicare.gov/resource/xubh-q36u/row-kw5b_vp92-tdms 450299 645732 2019-03-01 2018-09-30 102 12         114               114
418 418 PARRISH MEDICAL CENTER 951 N WASHINGTON AVE TITUSVILLE FL 32796 BREVARD (321) 268-6111 Acute Care Hospitals Government - Hospital District or Authority TRUE 28.6290680 -80.8249430 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-md6z.znz4~w9v4 100028 645533 2019-03-05 2018-09-30 202 8         210               210
419 419 HOLMES REGIONAL MEDICAL CENTER 1350 S HICKORY ST MELBOURNE FL 32901 BREVARD (321) 434-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.0869100 -80.6135230 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-vfyd.d5k5.qxkg 100019 646066 2019-02-28 2018-09-30 450 54   10     514               514
420 420 VIERA HOSPITAL 8745 N WICKHAM RD MELBOURNE FL 32940 BREVARD (321) 434-9000 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.2298120 -80.7294340 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-56fa_2f7u~npx7 100315 646070 2019-02-28 2018-09-30 64 20         84               84
421 421 CAPE CANAVERAL HOSPITAL 701 W COCOA BEACH CAUSEWAY COCOA BEACH FL 32932 BREVARD (321) 799-7111 Acute Care Hospitals Voluntary non-profit - Private TRUE 28.3578790 -80.6227330 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-x5ei~t9en-75k9 100177 643691 2019-02-27 2018-09-30 138 12         150               150
422 422 PALM BAY HOSPITAL 1425 MALABAR RD, NE PALM BAY FL 32907 BREVARD (321) 434-8000 Acute Care Hospitals Proprietary TRUE 27.9983300 -80.6120800 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-a9fd-uaut~kpyk 100316 646071 2019-02-27 2018-09-30 108 12         120 18             138
1712 1712 BIG BEND REGIONAL MEDICAL CENTER 2600 HIGHWAY 118 NORTH ALPINE TX 79830 BREWSTER (432) 837-3447 Critical Access Hospitals Proprietary TRUE 30.3838110 -103.6721400 0   43 48 48043         https://data.medicare.gov/resource/xubh-q36u/row-snt8.6tvq~cxi3 451378 654056 2019-08-28 2018-09-30 22 3         25               25
286 286 SOUTHCOAST HOSPITAL GROUP, INC 363 HIGHLAND AVENUE FALL RIVER MA 2720 BRISTOL (508) 679-3131 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7105220 -71.1464390 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-veij_kb96-ysvv 220074 643785 2019-02-26 2018-09-30 761 58       16 835   32           867
288 288 STURDY MEMORIAL HOSPITAL 211 PARK STREET ATTLEBORO MA 2703 BRISTOL (508) 222-5200 Acute Care Hospitals Voluntary non-profit - Other TRUE 41.9426950 -71.2752790 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-hsm9~94fs~psx5 220008 644033 2019-02-27 2018-09-30 117 14         131               131
1064 1064 BROOKS COUNTY HOSPITAL 903 N COURT STREET QUITMAN GA 31643 BROOKS (912) 263-4171 Critical Access Hospitals Government - Hospital District or Authority TRUE 30.7950120 -83.5595000 0   27 13 13027 46660   Outlying Brooks County https://data.medicare.gov/resource/xubh-q36u/row-yfqz_ezxu_56q8 111332 645068 2019-02-25 2018-09-30 25           25               25
470 470 BELLIN MEMORIAL HOSPITAL 744 S WEBSTER AVE GREEN BAY WI 54305 BROWN (920) 433-3500 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.5020010 -88.0106310 0   9 55 55009 24580 Green Bay-Shawano, WI Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-5c2p.w2dh~8dvr 520049 645514 2019-03-15 2018-09-30 145         16 161   14           175
1875 1875 BROWNWOOD REGIONAL MEDICAL CENTER 1501 BURNET DR BROWNWOOD TX 76801 BROWN (325) 646-8541 Acute Care Hospitals Proprietary TRUE 31.6802110 -98.9881580 0   49 48 48049 15220   Central Brown County https://data.medicare.gov/resource/xubh-q36u/row-mwhq-a826-mmad 450587 645612 2019-03-01 2018-09-30 65 12         77               77
850 850 J ARTHUR DOSHER MEMORIAL HOSPITAL 924 HOWE ST SOUTHPORT NC 28461 BRUNSWICK (910) 457-3800 Critical Access Hospitals Voluntary non-profit - Other TRUE 33.9290380 -78.0221940 0   19 37 37019 34820 Myrtle Beach-Conway, SC-NC Central Brunswick County https://data.medicare.gov/resource/xubh-q36u/row-6aha~5azi-guhu 341327 643001 2019-02-07 2018-09-30 25           25               25
642 642 ALLIANCEHEALTH DURANT 1800 UNIVERSITY BOULEVARD DURANT OK 74702 BRYAN (405) 924-3080 Acute Care Hospitals Proprietary TRUE 34.0049030 -96.3950550 0   13 40 40013 20460 Dallas-Fort Worth, TX-OK Central Bryan County https://data.medicare.gov/resource/xubh-q36u/row-96gx.9gst_7qhe 370014 646932 2019-04-03 2018-09-30 132 8         140               140
1215 1215 EAST GEORGIA REGIONAL MEDICAL CENTER 1499 FAIR ROAD STATESBORO GA 30458 BULLOCH (912) 486-1500 Acute Care Hospitals Proprietary TRUE 32.4151710 -81.7686500 0   31 13 13031 44340 Savannah-Hinesville-Statesboro, GA Central Bulloch County https://data.medicare.gov/resource/xubh-q36u/row-xsms-9ix9.jicj 110075 645062 2019-02-28 2018-09-30 118 24         142               142
501 501 ST MARGARETS HOSPITAL 600 E 1ST ST SPRING VALLEY IL 61362 BUREAU (815) 664-1176 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.3284090 -89.1926330 0   11 17 17011 36860 Chicago-Naperville, IL-IN-WI Central Bureau County https://data.medicare.gov/resource/xubh-q36u/row-p63h_huey-3vfg 140143 645248 2019-03-01 2018-09-30 38 6         44               44
661 661 BURNETT MEDICAL CENTER 257 W ST GEORGE AVE GRANTSBURG WI 54840 BURNETT (715) 463-5353 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.7755460 -92.6871820 0   13 55 55013         https://data.medicare.gov/resource/xubh-q36u/row-zayf~pj6y.5spk 521331 641418 2019-01-24 2018-09-30 25           25       50       75
548 548 REGIONAL MEDICAL CENTER OF CENTRAL ALABAMA 29 L V STABLER DRIVE GREENVILLE AL 36037 BUTLER (334) 382-2200 Acute Care Hospitals Proprietary TRUE 31.8294500 -86.6458600 0   13 1 1013         https://data.medicare.gov/resource/xubh-q36u/row-ca8j-ucpx~zp9d 10150 645390 2019-03-01 2018-09-30 37 7         44 13             57
950 950 LOST RIVERS MEDICAL CENTER 551 HIGHLAND DRIVE ARCO ID 83213 BUTTE (208) 252-7654 Critical Access Hospitals Government - Hospital District or Authority TRUE 43.6405520 -113.2962530 0   23 16 16023 26820 Idaho Falls-Rexburg-Blackfoot, ID Outlying Butte County https://data.medicare.gov/resource/xubh-q36u/row-77px.m9qb~bsww 131324 640856 2019-01-08 2018-09-30 14           14               14
543 543 CABELL HUNTINGTON HOSPITAL INC 1340 HAL GREER BOULEVARD HUNTINGTON WV 25701 CABELL (304) 526-2192 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.4100220 -82.4284110 0   11 54 54011 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Cabell County https://data.medicare.gov/resource/xubh-q36u/row-yhap.a3pm.rgzf 510055 639552 2018-12-14 2018-09-30 225 20   6 18   330               330
544 544 ST MARY'S MEDICAL CENTER 2900 1ST AVENUE HUNTINGTON WV 25702 CABELL (304) 526-1234 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.4318330 -82.4013350 0   11 54 54011 26580 Charleston-Huntington-Ashland, WV-OH-KY Central Cabell County https://data.medicare.gov/resource/xubh-q36u/row-cgcv-7ue3.g3gg 510007 640146 2018-12-26 2018-09-30 306 12 12   20   350 10     19       379
708 708 THE PHYSICIANS' HOSPITAL IN ANADARKO 1002 E CENTRAL BLVD ANADARKO OK 73005 CADDO (405) 247-8236 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.0722700 -98.2279900 0   15 40 40015         https://data.medicare.gov/resource/xubh-q36u/row-p7ys.d7q7.puqw 371314 644773 2019-03-01 2018-09-30 25           25               25
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
324 324 NORTHEASTERN VERMONT REGIONAL HOSPITAL 1315 HOSPITAL DRIVE SAINT JOHNSBURY VT 5819 CALEDONIA (802) 748-7400 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4452620 -72.0095160 0   5 50 50005         https://data.medicare.gov/resource/xubh-q36u/row-868v.jqmt-84z2 471303 649002 2019-05-21 2018-09-30 21 4         25               25
618 618 BMH-CALHOUN 140 BURKE-CALHOUN CITY ROAD CALHOUN CITY MS 38916 CALHOUN (662) 628-6611 Critical Access Hospitals Voluntary non-profit - Private TRUE 33.8696650 -89.3171760 0   13 28 28013         https://data.medicare.gov/resource/xubh-q36u/row-583j-immm~hxvr 251331 643806 2019-03-01 2018-09-30 25           25               25
666 666 NORTHEAST ALABAMA REGIONAL MEDICAL CENTER 400 EAST 10TH STREET ANNISTON AL 36207 CALHOUN (256) 235-5121 Acute Care Hospitals Government - Local TRUE 33.6571230 -85.8233530 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-ima9~p9t8~qh92 10078 644086 2019-02-28 2018-09-30 232 18         250 20             270
667 667 STRINGFELLOW MEMORIAL HOSPITAL 301 EAST 18TH ST ANNISTON AL 36201 CALHOUN (256) 235-8900 Acute Care Hospitals Proprietary TRUE 33.6677010 -85.8250250 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-2tt8-gqrt.8qr7 10038 644691 2019-02-28 2018-09-30 119 6         125               125
1391 1391 MURRAY-CALLOWAY COUNTY HOSPITAL 803 POPLAR STREET MURRAY KY 42071 CALLOWAY (270) 762-1100 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.6086600 -88.3094980 0   35 21 21035 34660   Central Calloway County https://data.medicare.gov/resource/xubh-q36u/row-m7pf.9rnr~pkib 180027 643768 2019-02-25 2018-09-30 89 10         99 12 12   154       277
652 652 TENNOVA HEALTHCARE-LAFOLLETT MEDICAL CENTER 923 EAST CENTRAL AVENUE LA FOLLETTE TN 37766 CAMPBELL (423) 907-1200 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.3879670 -84.1113650 0   13 47 47013 28940 Knoxville-Morristown-Sevierville, TN Outlying Campbell County https://data.medicare.gov/resource/xubh-q36u/row-fetd_k94i.ub5n 440033 645499 2019-03-01 2018-09-30 41 6         47 10     21 77     155
1065 1065 ST LUKE'S NAMPA MEDICAL CENTER 9850 W ST LUKES DRIVE STE 250 NAMPA ID 83687 CANYON (208) 505-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.6166180 -116.5907340 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-tbp2_2gqm.s523 130071 651515 2019-06-21 2018-09-30 56 10       4 70               70

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