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

177 rows where "filed_date" is on date 2019-02-28 sorted by all_beds

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, centraloutlyingcounty, fy_end_date, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_beds, fy_end_date (date)

filed_date (date) ✖

  • 2019-02-28 · 177 ✖
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 ▼
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
1651 1651 GREENE COUNTY HOSPITAL CAH 1017 JACKSON STREET LEAKESVILLE MS 39451 GREENE (601) 394-4135 Critical Access Hospitals Government - Local TRUE 31.1547640 -88.5626450 0   41 28 28041         https://data.medicare.gov/resource/xubh-q36u/row-w43a~rntf~brjp 251329 643805 2019-02-28 2018-09-30 7           7               7
3858 3858 TALLAHATCHIE CRITICAL ACCESS HOSPITAL 201 SOUTH MARKET ST / PO BOX 230 CHARLESTON MS 38921 TALLAHATCHIE (662) 647-5535 Critical Access Hospitals Government - Local TRUE 34.0050790 -90.0581650 0   135 28 28135         https://data.medicare.gov/resource/xubh-q36u/row-avrr~zg9m~xqab 251304 644307 2019-02-28 2018-09-30 9           9               9
1908 1908 PRAIRIE RIDGE HOSPITAL AND HEALTH SERVICES 1411 HIGHWAY 793 E ELBOW LAKE MN 56531 GRANT (218) 685-7300 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.9908032 -95.9578947 1 ROOFTOP 51 27 27051         https://data.medicare.gov/resource/xubh-q36u/row-is3f.7a5b~t9ju 241379 644131 2019-02-28 2018-09-30 10           10               10
2075 2075 MADISON VALLEY MEDICAL CENTER 305 N MAIN ENNIS MT 59729 MADISON (406) 682-4222 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.3514000 -111.7325670 0   57 30 30057         https://data.medicare.gov/resource/xubh-q36u/row-djeh_dspp-vwv4 271329 644643 2019-02-28 2018-09-30 10           10               10
3989 3989 KINGS DAUGHTERS MEDICAL CENTER OHIO 1901 ARGONNE ROAD PORTSMOUTH OH 45662 SCIOTO (740) 991-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 38.7473190 -82.9933540 0   145 39 39145 39020 Charleston-Huntington-Ashland, WV-OH-KY Central Scioto County https://data.medicare.gov/resource/xubh-q36u/row-3hvz~qivd_yj54 360361 644543 2019-02-28 2018-09-30 10           10               10
1731 1731 VALOR HEALTH 1202 EAST LOCUST STREET EMMETT ID 83617 GEM (208) 365-3561 Critical Access Hospitals Government - Local TRUE 43.8790780 -116.4852550 0   45 16 16045 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Gem County https://data.medicare.gov/resource/xubh-q36u/row-cch8-kmmd-nmhb 131318 644635 2019-02-28 2018-09-30 13           13               13
2490 2490 BAYSIDE COMMUNITY HOSPITAL 200 HOSPITAL DRIVE ANAHUAC TX 77514 CHAMBERS (409) 267-3143 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.7530120 -94.6868500 0   71 48 48071 26420 Houston-The Woodlands, TX Central Chambers County https://data.medicare.gov/resource/xubh-q36u/row-zszx-nqzy-xwd5 451320 643853 2019-02-28 2018-09-30 14           14               14
292 292 FIELD HEALTH SYSTEM 178 HIGHWAY 24 CENTREVILLE MS 39631 WILKINSON (601) 890-0500 Critical Access Hospitals Government - Local TRUE 31.0820299 -91.0587631 1 ROOFTOP 5 28 28005 32620   Outlying Amite County https://data.medicare.gov/resource/xubh-q36u/row-d7tp~8xnm~uwen 251309 646102 2019-02-28 2018-09-30 16           16               16
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
2031 2031 THE OUTER BANKS HOSPITAL, INC 4800 SOUTH CROATAN HIGHWAY NAGS HEAD NC 27959 DARE (252) 449-4500 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9408620 -75.6169230 0   55 37 37055 28620 Virginia Beach-Norfolk, VA-NC Central Dare County https://data.medicare.gov/resource/xubh-q36u/row-ma9p_9398-dfyr 341324 644159 2019-02-28 2018-09-30 21           21               21
3470 3470 LINDSBORG COMMUNITY HOSPITAL 605 W LINCOLN STREET LINDSBORG KS 67456 MCPHERSON (785) 227-3308 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.5734350 -97.6835900 0   113 20 20113 32700   Central McPherson County https://data.medicare.gov/resource/xubh-q36u/row-z5m8.2c5c.9xk5 171358 645086 2019-02-28 2018-09-30 23           23               23
3 3 WEEKS MEDICAL CENTER 173 MIDDLE STREET LANCASTER NH 3584 COOS (603) 788-4911 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4869900 -71.5541560 0   7 33 33007 13620   Central Coos County https://data.medicare.gov/resource/xubh-q36u/row-4k9b_taaw_pmup 301303 643920 2019-02-28 2018-09-30 22 3         25               25
358 358 MARTHA'S VINEYARD HOSPITAL INC ONE HOSPITAL ROAD, FIRST FL, WING 5, PO BOX 1477 OAK BLUFFS MA 2557 DUKES (508) 693-0410 Critical Access Hospitals Voluntary non-profit - Private TRUE 41.4570063 -70.5517789 1 APPROXIMATE 7 25 25007 47240   Central Dukes County https://data.medicare.gov/resource/xubh-q36u/row-ym84.mbv4~ifss 221300 644287 2019-02-28 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
438 438 NORTHERN LIGHT BLUE HILL MEMORIAL HOSPITAL 57 WATER STREET BLUE HILL ME 4614 HANCOCK (207) 374-2836 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.4114200 -68.5862130 0   9 23 23009         https://data.medicare.gov/resource/xubh-q36u/row-ib5k-im2e_vk94 201300 645100 2019-02-28 2018-09-30 25           25               25
453 453 LITTLETON REGIONAL HEALTHCARE 600 ST JOHNSBURY ROAD LITTLETON NH 3561 GRAFTON (603) 444-9000 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3162340 -71.8253160 0   9 33 33009 17200   Central Grafton County https://data.medicare.gov/resource/xubh-q36u/row-khnu_9dyx-jeeb 301302 644143 2019-02-28 2018-09-30 21 4         25               25
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
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
935 935 COLUMBUS COMMUNITY HOSPITAL 1515 PARK AVE COLUMBUS WI 53925 COLUMBIA (920) 623-2200 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.3237980 -89.0361620 0   21 55 55021 31540 Madison-Janesville-Beloit, WI Outlying Columbia County https://data.medicare.gov/resource/xubh-q36u/row-87ws-7evk.39ut 521338 644196 2019-02-28 2018-09-30 21 4         25               25
941 941 HOLY CROSS HOSPITAL 1171 WEST TARGET RANGE ROAD NOGALES AZ 85621 SANTA CRUZ (520) 285-3000 Critical Access Hospitals Proprietary TRUE 31.3411180 -110.9587340 0   23 4 4023 35700 Tucson-Nogales, AZ Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-datt~k3n6_g682 31313 644092 2019-02-28 2018-09-30 25           25               25
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
1446 1446 JACKSON GENERAL HOSPITAL 122 PINNELL ST RIPLEY WV 25271 JACKSON (304) 372-2731 Critical Access Hospitals Voluntary non-profit - Other TRUE 38.8235410 -81.7283250 0   35 54 54035         https://data.medicare.gov/resource/xubh-q36u/row-qz6z~eyng~xsxm 511320 645206 2019-02-28 2018-09-30 25           25               25
1649 1649 ST FRANCIS HOSPITAL 3401 LUDINGTON ST ESCANABA MI 49829 DELTA (906) 786-3311 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.7457600 -87.0948530 0   41 26 26041 21540   Central Delta County https://data.medicare.gov/resource/xubh-q36u/row-iqyh_xi8k_igyu 231337 645115 2019-02-28 2018-09-30 16 9         25               25
1658 1658 VIDANT CHOWAN HOSPITAL 211 VIRGINIA RD EDENTON NC 27932 CHOWAN (252) 482-8451 Critical Access Hospitals Government - Local TRUE 36.0707740 -76.6090930 0   41 37 37041         https://data.medicare.gov/resource/xubh-q36u/row-trbd~xc39_h8ri 341318 644158 2019-02-28 2018-09-30 21 4         25               25
1893 1893 HENDRY REGIONAL MEDICAL CENTER 524 W SAGAMORE AVE CLEWISTON FL 33440 HENDRY (863) 902-3033 Critical Access Hospitals Voluntary non-profit - Other TRUE 26.7532390 -80.9422760 0   51 12 12051 17500   Central Hendry County https://data.medicare.gov/resource/xubh-q36u/row-ati4-fhfd_57wb 101309 643695 2019-02-28 2018-09-30 22 3         25               25
2361 2361 BEATRICE COMMUNITY HOSPITAL & HEALTH CENTER, INC P O BOX 278, 4800 HOSPITAL PARKWAY BEATRICE NE 68310 GAGE (402) 228-3344 Critical Access Hospitals Voluntary non-profit - Private TRUE 40.3161806 -96.7495665 1 ROOFTOP 67 31 31067 13100 Lincoln-Beatrice, NE Central Gage County https://data.medicare.gov/resource/xubh-q36u/row-hnr5~xngx-6v22 281364 645126 2019-02-28 2018-09-30 22 3         25               25
2526 2526 OSF SAINT LUKES MEDICAL CENTER 1051 WEST SOUTH STREET KEWANEE IL 61443 HENRY (309) 853-3361 Critical Access Hospitals Voluntary non-profit - Church TRUE 41.2221630 -89.9477690 0   73 17 17073 19340 Davenport-Moline, IA-IL Outlying Henry County https://data.medicare.gov/resource/xubh-q36u/row-9mk3-a2c4_4uh2 141325 645251 2019-02-28 2018-09-30 22 3         25               25
2529 2529 GREENWOOD COUNTY HOSPITAL 100 W 16TH STREET EUREKA KS 67045 GREENWOOD (620) 583-7451 Critical Access Hospitals Government - Local TRUE 37.8353150 -96.2941800 0   73 20 20073         https://data.medicare.gov/resource/xubh-q36u/row-g9zc.t83r_s62e 171339 645085 2019-02-28 2018-09-30 25           25               25
2770 2770 COLEMAN COUNTY MEDICAL CENTER COMPANY 310 SOUTH PECOS STREET COLEMAN TX 76834 COLEMAN (325) 625-2135 Critical Access Hospitals Government - Hospital District or Authority TRUE 31.8286260 -99.4252380 0   83 48 48083         https://data.medicare.gov/resource/xubh-q36u/row-arcj.jjrh_hge7 451347 643742 2019-02-28 2018-09-30 25           25               25
3205 3205 FRANKLIN FOUNDATION HOSPITAL 1097 NORTHWEST BLVD FRANKLIN LA 70538 ST. MARY (337) 828-0760 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.8018700 -91.5252720 0   101 22 22101 34020 Lafayette-Opelousas-Morgan City, LA Central St. Mary Parish https://data.medicare.gov/resource/xubh-q36u/row-72t5.bydx-dr2i 191310 645093 2019-02-28 2018-09-30 20 5         25               25
3536 3536 PONTOTOC HEALTH SERVICE CAH 176 SOUTH MAIN STREET PONTOTOC MS 38863 PONTOTOC (662) 489-5510 Critical Access Hospitals Voluntary non-profit - Private TRUE 34.2428270 -88.9968000 0   115 28 28115 46180   Outlying Pontotoc County https://data.medicare.gov/resource/xubh-q36u/row-cgtx~8fwc-42mt 251308 643801 2019-02-28 2018-09-30 25           25               25
3705 3705 MASON DISTRICT HOSPITAL 615 NORTH PROMENADE STREET,P O BOX 530 HAVANA IL 62644 MASON (309) 543-4431 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.3057130 -90.0561110 0   125 17 17125         https://data.medicare.gov/resource/xubh-q36u/row-sff2~mc9z_hnb5 141313 644984 2019-02-28 2018-09-30 25           25               25
4097 4097 MCLAREN CARO REGION 401 N HOOPER ST CARO MI 48723 TUSCOLA (989) 673-3141 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4931510 -83.4071570 0   157 26 26157         https://data.medicare.gov/resource/xubh-q36u/row-c56z_ysxt_4rjy 231329 645341 2019-02-28 2018-09-30 25           25               25
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
4228 4228 TROUSDALE MEDICAL CENTER 500 CHURCH STREET HARTSVILLE TN 37074 TROUSDALE (615) 374-2221 Critical Access Hospitals Voluntary non-profit - Other TRUE 36.3881360 -86.1676920 0   169 47 47169 34980 Nashville-Davidson--Murfreesboro, TN Outlying Trousdale County https://data.medicare.gov/resource/xubh-q36u/row-b84v_4ggv_qpsn 441301 644183 2019-02-28 2018-09-30 25           25               25
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
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
625 625 FRANKLIN REGIONAL HOSPITAL 15 AIKEN AVENUE FRANKLIN NH 3235 MERRIMACK (603) 934-2060 Critical Access Hospitals Voluntary non-profit - Private TRUE 43.4480710 -71.6436840 0   13 33 33013 18180 Boston-Worcester-Providence, MA-RI-NH-CT Central Merrimack County https://data.medicare.gov/resource/xubh-q36u/row-eyhc~86xw.fw5b 301306 644144 2019-02-28 2018-09-30 25           25 10             35
4012 4012 ILLINI COMMUNITY HOSPITAL 640 W WASHINGTON PITTSFIELD IL 62363 PIKE (217) 285-2113 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.6067930 -90.8150550 0   149 17 17149         https://data.medicare.gov/resource/xubh-q36u/row-pujp_q5tr_5y4p 141315 645075 2019-02-28 2018-09-30 25           25 10             35
1760 1760 PRISMA HEALTH PATEWOOD HOSPITAL 175 PATEWOOD DRIVE GREENVILLE SC 29615 GREENVILLE (864) 797-1000 Acute Care Hospitals Voluntary non-profit - Private FALSE 34.8527350 -82.3261150 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-6pw3~wdbm.z7ry 420102 643846 2019-02-28 2018-09-30 38           38               38
4082 4082 WEBSTER GENERAL HOSPITAL/ SWING BED 70 MEDICAL PLAZA EUPORA MS 39744 WEBSTER (662) 258-6221 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.5347360 -89.2669430 0   155 28 28155         https://data.medicare.gov/resource/xubh-q36u/row-a3qx_u9bd-sjek 250020 643797 2019-02-28 2018-09-30 38           38               38
1010 1010 MASSACHUSETTS EYE AND EAR INFIRMARY - 243 CHARLES STREET BOSTON MA 2114 SUFFOLK (617) 523-7900 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.3628610 -71.0705210 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-u3e3_hg2x_hi8v 220075 644640 2019-02-28 2018-09-30 41           41               41
3006 3006 CAPE FEAR VALLEY HOKE HOSPITAL 210 MEDICAL PAVILION DRIVE RAEFORD NC 28376 HOKE (910) 904-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0314260 -79.1088240 0   93 37 37093 22180 Fayetteville-Lumberton-Laurinburg, NC Central Hoke County https://data.medicare.gov/resource/xubh-q36u/row-awx4~hxxz-7m7w 340188 643820 2019-02-28 2018-09-30 41           41               41
1535 1535 GEORGE REGIONAL HEALTH SYSTEM 859 WINTER STREET LUCEDALE MS 39452 GEORGE (601) 947-3161 Acute Care Hospitals Government - Local TRUE 30.9222350 -88.5928530 0   39 28 28039         https://data.medicare.gov/resource/xubh-q36u/row-f75f~mexp.zvtb 250036 643798 2019-02-28 2018-09-30 36 6         42               42
3306 3306 SAINT JAMES HOSPITAL 2500 WEST REYNOLDS STREET PONTIAC IL 61764 LIVINGSTON (815) 842-2828 Acute Care Hospitals Voluntary non-profit - Church FALSE 40.8734020 -88.6785830 0   105 17 17105 38700 Bloomington-Pontiac, IL Central Livingston County https://data.medicare.gov/resource/xubh-q36u/row-5rfh_kxf8-j7x6 140161 644981 2019-02-28 2018-09-30 37 5         42               42
1763 1763 PRISMA HEALTH HILLCREST HOSPITAL 741 SOUTH EAST MAIN STREET SIMPSONVILLE SC 29681 GREENVILLE (864) 454-6100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7181340 -82.2467360 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-7tzq.68bi~s86f 420037 643841 2019-02-28 2018-09-30 37 6         43               43
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
148 148 HEBREW HOME AND HOSPITAL INC 1 ABRAHMS BOULEVARD WEST HARTFORD CT 6117 HARTFORD (860) 523-3800 Acute Care Hospitals Voluntary non-profit - Private FALSE 41.8027740 -72.7289310 0   3 9 9003 25540 Hartford-West Hartford, CT Central Hartford County https://data.medicare.gov/resource/xubh-q36u/row-eqjh_iqnh-wsnp 70040 645324 2019-02-28 2018-09-30 23           23 22             45
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
4698 4698 WILBARGER GENERAL HOSPITAL 920 HILLCREST DR VERNON TX 76384 WILBARGER (940) 552-9351 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.1594190 -99.3133300 0   487 48 48487 46900   Central Wilbarger County https://data.medicare.gov/resource/xubh-q36u/row-5iha_7mw4.8q3u 450584 643852 2019-02-28 2018-09-30 47           47               47
2766 2766 PELHAM MEDICAL CENTER 250 WESTMORELAND ROAD GREER SC 29651 GREENVILLE (864) 560-6554 Acute Care Hospitals Government - Hospital District or Authority TRUE 34.8635100 -82.2176610 0   83 45 45083 43900 Greenville-Spartanburg-Anderson, SC Central Spartanburg County https://data.medicare.gov/resource/xubh-q36u/row-kc6n_96px_662r 420103 645180 2019-02-28 2018-09-30 44 4         48               48
3920 3920 TISHOMINGO HEALTH SERVICES INC 1777 CURTIS DRIVE IUKA MS 38852 TISHOMINGO (662) 423-6051 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.8036860 -88.2092180 0   141 28 28141         https://data.medicare.gov/resource/xubh-q36u/row-8vqy~22mf_tvap 250002 643792 2019-02-28 2018-09-30 48           48               48
1939 1939 ATMORE COMMUNITY HOSPITAL 401 MEDICAL PARK DRIVE ATMORE AL 36502 ESCAMBIA (251) 368-2500 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.0165700 -87.4797350 0   53 1 1053         https://data.medicare.gov/resource/xubh-q36u/row-nw85.p2jc-cva6 10169 645521 2019-02-28 2018-09-30 43 6         49               49
2870 2870 UNION MEDICAL CENTER 322 WEST SOUTH STREET UNION SC 29379 UNION (864) 301-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.7114380 -81.6286680 0   87 45 45087 43900 Greenville-Spartanburg-Anderson, SC Outlying Union County https://data.medicare.gov/resource/xubh-q36u/row-a8su_cikk-4j4z 420108 645181 2019-02-28 2018-09-30 43 6         49               49
3966 3966 TEXAS HEALTH HARRIS METHODIST HOSPITAL STEPHENVILL 411 N BELKNAP ST STEPHENVILLE TX 76401 ERATH (254) 965-1500 Acute Care Hospitals Voluntary non-profit - Private TRUE 32.2231630 -98.2048710 0   143 48 48143 44500   Central Erath County https://data.medicare.gov/resource/xubh-q36u/row-3e4m_j29y-qggx 450351 643850 2019-02-28 2018-09-30 45 5         50               50
3598 3598 RIVERVIEW HOSPITAL 323 SOUTH MINNESOTA CROOKSTON MN 56716 POLK (218) 281-9200 Critical Access Hospitals Voluntary non-profit - Private TRUE 47.7720830 -96.6181060 0   119 27 27119 24220   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-9ugf.smjx.yquq 241320 644130 2019-02-28 2018-09-30 25 5         30       24       54
1134 1134 CARIBOU MEMORIAL HOSPITAL 300 SOUTH 3RD WEST SODA SPRINGS ID 83276 CARIBOU (208) 547-3341 Critical Access Hospitals Government - Local TRUE 42.6522350 -111.6133540 0   29 16 16029         https://data.medicare.gov/resource/xubh-q36u/row-k69a-4kn6-dfne 131309 644028 2019-02-28 2018-09-30 25           25       30       55
1762 1762 PRISMA HEALTH GREER MEMORIAL HOSPITAL 830 SOUTH BUNCOMBE ROAD GREER SC 29650 GREENVILLE (864) 848-8200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.9193100 -82.2420310 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-xcyi~2q2z~2aqn 420033 643840 2019-02-28 2018-09-30 49 8         57               57
2164 2164 PRISMA HEALTH LAURENS COUNTY HOSPITAL 22725 HIGHWAY 76 EAST CLINTON SC 29325 LAURENS (864) 833-9100 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.4797180 -81.9411520 0   59 45 45059 24860 Greenville-Spartanburg-Anderson, SC Outlying Laurens County https://data.medicare.gov/resource/xubh-q36u/row-qum6.2nj9-aisw 420038 643842 2019-02-28 2018-09-30 35   8       43       14       57
3459 3459 GULF BREEZE HOSPITAL 1110 GULF BREEZE PKWY GULF BREEZE FL 32561 SANTA ROSA (850) 934-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 30.3586490 -87.1568030 0   113 12 12113 37860   Central Santa Rosa County https://data.medicare.gov/resource/xubh-q36u/row-i236_mnds-pgjj 100266 646028 2019-02-28 2018-09-30 57 8         65               65
2874 2874 ROANE GENERAL HOSPITAL 200 HOSPITAL DRIVE SPENCER WV 25276 ROANE (304) 927-4444 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.8136540 -81.3688700 0   87 54 54087         https://data.medicare.gov/resource/xubh-q36u/row-2iwc-6g6k~ur6u 511306 645205 2019-02-28 2018-09-30 25           25       44       69
596 596 JOHNSON MEMORIAL HOSPITAL 201 CHESTNUT HILL ROAD STAFFORD SPRINGS CT 6076 TOLLAND (860) 684-4251 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.9795964 -72.3911022 1 ROOFTOP 13 9 9013 25540 Hartford-West Hartford, CT Central Tolland County https://data.medicare.gov/resource/xubh-q36u/row-teik-3pgv_3z6k 70008 645049 2019-02-28 2018-09-30 43 7         50 20             70
4178 4178 SAMPSON REGIONAL MEDICAL CENTER 607 BEAMAN ST CLINTON NC 28328 SAMPSON (910) 592-8511 Acute Care Hospitals Government - Local TRUE 35.0077830 -78.3236350 0   163 37 37163         https://data.medicare.gov/resource/xubh-q36u/row-a9b2_fhm6_47x6 340024 643924 2019-02-28 2018-09-30 63 8         71               71
2210 2210 VIDANT DUPLIN HOSPITAL 401 N MAIN ST KENANSVILLE NC 28349 DUPLIN (910) 296-0941 Acute Care Hospitals Government - Local TRUE 34.9647690 -77.9604790 0   61 37 37061         https://data.medicare.gov/resource/xubh-q36u/row-3z8q-ur44-gq7x 340120 643929 2019-02-28 2018-09-30 40 9         49 25             74
4079 4079 SPRING VIEW HOSPITAL 320 LORETTO ROAD LEBANON KY 40033 MARION (270) 692-5145 Acute Care Hospitals Proprietary TRUE 37.5703250 -85.2593970 0   155 21 21155         https://data.medicare.gov/resource/xubh-q36u/row-ri6m~j23x~rpdu 180024 643767 2019-02-28 2018-09-30 57 6         63 12             75
479 479 GOV JUAN F LUIS HOSPITAL & MEDICAL CTR #4007 EST DIAMOND RUBY, CHRISTIANSTED ST CROIX VI 820 SAINT CROIX ISLAND (340) 778-6311 Acute Care Hospitals Government - State TRUE 17.7336768 -64.7515758 1 ROOFTOP 10 78 78010         https://data.medicare.gov/resource/xubh-q36u/row-bs2s~9p8n_k2e3 480002 644383 2019-02-28 2018-09-30 66 11         77               77
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
263 263 SHARON HOSPITAL 50 HOSPITAL HILL ROAD SHARON CT 6069 LITCHFIELD (860) 364-4228 Acute Care Hospitals Proprietary TRUE 41.8796620 -73.4815720 0   5 9 9005 45860 New York-Newark, NY-NJ-CT-PA Central Litchfield County https://data.medicare.gov/resource/xubh-q36u/row-cvhr-qzru_z9ev 70004 658178 2019-02-28 2018-09-30 55 11         66 12             78
3590 3590 OSF SAINT ANTHONY'S HEALTH CENTER ST ANTHONY'S WAY ALTON IL 62002 MADISON (618) 465-2571 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.9073839 -90.1718152 1 GEOMETRIC_CENTER 119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-mu62-iiye-da97 140052 645329 2019-02-28 2018-09-30 68 10         78               78
2046 2046 WADLEY REGIONAL MEDICAL CENTER AT HOPE 2001 SOUTH MAIN HOPE AR 71801 HEMPSTEAD (870) 722-3800 Acute Care Hospitals Proprietary TRUE 33.6480080 -93.5870520 0   57 5 5057         https://data.medicare.gov/resource/xubh-q36u/row-zn9u-sntu_5nuw 40153 643865 2019-02-28 2018-09-30 59 8         67 12             79
3034 3034 ST MARY MEDICAL CENTER 3333 NORTH SEMINARY GALESBURG IL 61401 KNOX (309) 344-3161 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.9870200 -90.3636090 0   95 17 17095 23660   Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-qvep_yzhb-cn4g 140064 644980 2019-02-28 2018-09-30 75 6         81               81
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
2795 2795 KING'S DAUGHTERS MEDICAL CENTER-BROOKHAVEN P O BOX 948/427 HIGHWAY 51 NORTH BROOKHAVEN MS 39601 LINCOLN (601) 833-6011 Acute Care Hospitals Voluntary non-profit - Other TRUE 31.5892013 -90.4580392 1 ROOFTOP 85 28 28085 15020 Jackson-Vicksburg-Brookhaven, MS Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-5ntd-ntch~5mxf 250057 643905 2019-02-28 2018-09-30 85 5         90               90
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
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
4359 4359 WATAUGA MEDICAL CENTER 336 DEERFIELD ROAD BOONE NC 28607 WATAUGA (828) 263-1211 Acute Care Hospitals Government - Local TRUE 36.1987530 -81.6524230 0   189 37 37189 14380   Central Watauga County https://data.medicare.gov/resource/xubh-q36u/row-p9id_sdf3_mtw8 340051 645346 2019-02-28 2018-09-30 81 10       4 95               95
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
2964 2964 VIDANT ROANOKE CHOWAN HOSPITAL 500 S ACADEMY ST AHOSKIE NC 27910 HERTFORD (252) 209-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.2851490 -76.9939240 0   91 37 37091         https://data.medicare.gov/resource/xubh-q36u/row-n5pq~6e8d.jjva 340099 643925 2019-02-28 2018-09-30 60 10         70 28             98
3755 3755 HANNIBAL REGIONAL HOSPITAL 6000 HOSPITAL DR HANNIBAL MO 63401 MARION (573) 248-1300 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7105950 -91.4439670 0   127 29 29127 25300 Quincy-Hannibal, IL-MO Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-tm6x~9k2p~5kg6 260025 645343 2019-02-28 2018-09-30 78 8         86   13           99
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
4192 4192 SCOTLAND MEMORIAL HOSPITAL 500 LAUCHWOOD DR LAURINBURG NC 28352 SCOTLAND (910) 291-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.7517000 -79.4704200 0   165 37 37165 29900 Fayetteville-Lumberton-Laurinburg, NC Central Scotland County https://data.medicare.gov/resource/xubh-q36u/row-6cnv~bite_rawz 340008 645131 2019-02-28 2018-09-30 89 8         97   7           104
264 264 CHARLOTTE HUNGERFORD HOSPITAL 540 LITCHFIELD ST TORRINGTON CT 6790 LITCHFIELD (860) 496-6666 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.7908460 -73.1331430 0   5 9 9005 45860 New York-Newark, NY-NJ-CT-PA Central Litchfield County https://data.medicare.gov/resource/xubh-q36u/row-3jtm_3puv.aqur 70011 645050 2019-02-28 2018-09-30 81 10         91 17             108
1067 1067 WEST VALLEY MEDICAL CENTER 1717 ARLINGTON STREET CALDWELL ID 83605 CANYON (208) 459-4641 Acute Care Hospitals Proprietary TRUE 43.6542200 -116.6956400 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-q3w9-74rj.ew8y 130014 645072 2019-02-28 2018-09-30 95 13       4 112               112
3575 3575 ARKANSAS HEART HOSPITAL, LLC 1701 S SHACKLEFORD ROAD LITTLE ROCK AR 72211 PULASKI (501) 219-7000 Acute Care Hospitals Proprietary TRUE 34.7391590 -92.3944210 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-jzxu~zre6.ev3c 40134 644703 2019-02-28 2018-09-30 112           112               112
2985 2985 MARION REGIONAL MEDICAL CENTER 1256 MILITARY STREET SOUTH HAMILTON AL 35570 MARION (205) 921-6200 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1258520 -87.9898060 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-ak6z-c9hr~7upb 10044 643754 2019-02-28 2018-09-30 32 4         36       79       115
2317 2317 VIDANT EDGECOMBE HOSPITAL 111 HOSPITAL DR TARBORO NC 27886 EDGECOMBE (252) 641-7700 Acute Care Hospitals Government - Local TRUE 35.9218850 -77.5569940 0   65 37 37065 40580 Rocky Mount-Wilson-Roanoke Rapids, NC Central Edgecombe County https://data.medicare.gov/resource/xubh-q36u/row-9nuq.ij7s_3aca 340107 643926 2019-02-28 2018-09-30 86 15         101   16           117
3869 3869 PASSAVANT AREA HOSPITAL 1600 W WALNUT ST JACKSONVILLE IL 62650 MORGAN (217) 245-9551 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.7452680 -90.2599120 0   137 17 17137 27300 Springfield-Jacksonville-Lincoln, IL Central Morgan County https://data.medicare.gov/resource/xubh-q36u/row-s6nm~srnx_9kx5 140058 645330 2019-02-28 2018-09-30 84 9         93 10     15       118
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
2851 2851 LOWER KEYS MEDICAL CENTER 5900 COLLEGE ROAD KEY WEST FL 33040 MONROE (305) 294-5531 Acute Care Hospitals Proprietary TRUE 24.5815730 -81.7436880 0   87 12 12087 28580   Central Monroe County https://data.medicare.gov/resource/xubh-q36u/row-ygrq~jm9y.gjez 100150 644708 2019-02-28 2018-09-30 90 9         99 21             120
3196 3196 ADVENTHEALTH DADE CITY 13100 FT KING RD DADE CITY FL 33525 PASCO (352) 568-3174 Acute Care Hospitals Proprietary TRUE 28.3485870 -82.2016850 0   101 12 12101 45300   Central Pasco County https://data.medicare.gov/resource/xubh-q36u/row-w886-maw8~uhkt 100211 644709 2019-02-28 2018-09-30 108 12         120               120
2761 2761 HALIFAX REGIONAL MEDICAL CENTER INC 250 SMITH CHURCH RD ROANOKE RAPIDS NC 27870 HALIFAX (252) 535-8005 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.4353130 -77.6470460 0   83 37 37083 40260 Rocky Mount-Wilson-Roanoke Rapids, NC Central Halifax County https://data.medicare.gov/resource/xubh-q36u/row-kybh.hk82~d7fv 340151 645348 2019-02-28 2018-09-30 90 16         106 18             124
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
549 549 ABRAZO SCOTTSDALE CAMPUS 3929 EAST BELL ROAD PHOENIX AZ 85032 MARICOPA (602) 923-5000 Acute Care Hospitals Proprietary TRUE 33.6406030 -111.9976920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-3yrx.bcen.wd4a 30083 644698 2019-02-28 2018-09-30 113 14         127               127
730 730 BAYFRONT HEALTH SEVEN RIVERS 6201 N SUNCOAST BLVD CRYSTAL RIVER FL 34428 CITRUS (352) 795-6560 Acute Care Hospitals Proprietary TRUE 28.9508960 -82.6258660 0   17 12 12017 26140   Central Citrus County https://data.medicare.gov/resource/xubh-q36u/row-e3ek_i6mx~pzz2 100249 644711 2019-02-28 2018-09-30 112 16         128               128
1058 1058 CLAY COUNTY HOSPITAL 83825 HIGHWAY 9 P O BOX 1270 ASHLAND AL 36251 CLAY (256) 354-2131 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.2765480 -85.8237890 0   27 1 1027         https://data.medicare.gov/resource/xubh-q36u/row-p2yh_2e24~5sth 10073 644085 2019-02-28 2018-09-30 42 4         46       83       129
4406 4406 MISSOURI DELTA MEDICAL CENTER 1008 NORTH MAIN ST SIKESTON MO 63801 SCOTT (573) 471-1600 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.8890480 -89.5843460 0   201 29 29201 43460 Cape Girardeau-Sikeston, MO-IL Central Scott County https://data.medicare.gov/resource/xubh-q36u/row-gnum~mcff-uuan 260113 645121 2019-02-28 2018-09-30 98 12         110 12 11           133
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
3117 3117 DAVIS REGIONAL MEDICAL CENTER 218 OLD MOCKSBVILLE RD PO BOX 1823 STATESVILLE NC 28687 IREDELL (704) 873-0281 Acute Care Hospitals Proprietary TRUE 35.8186480 -80.8291896 1 ROOFTOP 97 37 37097 16740 Charlotte-Concord, NC-SC Central Iredell County https://data.medicare.gov/resource/xubh-q36u/row-ks69_qbdx-fr95 340144 645138 2019-02-28 2018-09-30 120 8         128 12             140
4739 4739 TWIN COUNTY REGIONAL HOSPITAL 200 HOSPITAL DRIVE GALAX VA 24333 GALAX CITY (276) 236-8181 Acute Care Hospitals Proprietary TRUE 36.6718130 -80.9238140 0   640 51 51640         https://data.medicare.gov/resource/xubh-q36u/row-scan.4a2b.zisp 490115 643992 2019-02-28 2018-09-30 131 10         141               141

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