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 countyequivalent

✎ 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
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
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
477 477 GUAM MEMORIAL HOSPITAL AUTHORITY 85O GOV CARLOS G CAMACHO ROAD TAMUNING GU 96913 GUAM (671) 647-2552 Acute Care Hospitals Government - Local TRUE 13.5008229 144.7755910 1 GEOMETRIC_CENTER 10 66 66010         https://data.medicare.gov/resource/xubh-q36u/row-4hjs.vy3n_hawy 650001 644079 2019-02-28 2018-09-30 147 14         161       40       201
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
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
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
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
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
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
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
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
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
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
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
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
1810 1810 COLUMBUS REGIONAL HEALTHCARE SYSTEM 500 JEFFERSON ST WHITEVILLE NC 28472 COLUMBUS (910) 642-8011 Acute Care Hospitals Voluntary non-profit - Other TRUE 34.3386570 -78.6936440 0   47 37 37047         https://data.medicare.gov/resource/xubh-q36u/row-ucyn-b8wt_9jnp 340068 645347 2019-02-28 2018-09-30 144   10       154               154
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
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
2045 2045 FAYETTE MEDICAL CENTER 1653 TEMPLE AVENUE NORTH FAYETTE AL 35555 FAYETTE (205) 932-5966 Acute Care Hospitals Voluntary non-profit - Other TRUE 33.7077080 -87.8237060 0   57 1 1057         https://data.medicare.gov/resource/xubh-q36u/row-f7kw.zhbj_gfwf 10045 644692 2019-02-28 2018-09-30 37 8         45       122       167
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
4380 4380 PIKEVILLE MEDICAL CENTER 911 BYPASS ROAD PIKEVILLE KY 41501 PIKE (606) 218-3500 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.4725100 -82.5239500 0   195 21 21195         https://data.medicare.gov/resource/xubh-q36u/row-h2q9~be2e-2gte 180044 643769 2019-02-28 2018-09-30 189 70         268   26           294
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
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
395 395 UNIVERSITY OF VERMONT MEDICAL CENTER 111 COLCHESTER AVE BURLINGTON VT 5401 CHITTENDEN (802) 847-0000 Acute Care Hospitals Voluntary non-profit - Other TRUE 44.4809910 -73.1955180 0   7 50 50007 15540   Central Chittenden County https://data.medicare.gov/resource/xubh-q36u/row-sa3g~qvqf.2559 470003 643744 2019-02-28 2018-09-30 349 21     25   415   35           450
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
885 885 PHYSICIANS REGIONAL MEDICAL CENTER - PINE RIDGE 6101 PINE RIDGE ROAD NAPLES FL 34119 COLLIER (239) 348-4000 Acute Care Hospitals Proprietary TRUE 26.2117640 -81.7307070 0   21 12 12021 34940 Cape Coral-Fort Myers-Naples, FL Central Collier County https://data.medicare.gov/resource/xubh-q36u/row-z54t-v8nq.fk93 100286 643693 2019-02-28 2018-09-30 177 24         201               201
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
1229 1229 NORTHWEST COMMUNITY HOSPITAL 1 800 W CENTRAL ROAD ARLINGTON HEIGHTS IL 60005 COOK (847) 618-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0666040 -87.9929510 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-39t4.gcrd_v8y9 140252 644983 2019-02-28 2018-09-30 328 60       8 396 52 33           481
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
1915 1915 CAPE FEAR VALLEY MEDICAL CENTER 1638 OWEN DRIVE P O BOX 2000 FAYETTEVILLE NC 28302 CUMBERLAND (910) 609-4000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0324120 -78.9310960 0   51 37 37051 22180 Fayetteville-Lumberton-Laurinburg, NC Central Cumberland County https://data.medicare.gov/resource/xubh-q36u/row-9vgu~9uhh_eymv 340028 643815 2019-02-28 2018-09-30 492 48         584   72           656
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
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
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
1210 1210 BAPTIST MEDICAL CENTER JACKSONVILLE 800 PRUDENTIAL DR JACKSONVILLE FL 32207 DUVAL (904) 202-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.3162840 -81.6636090 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-sq6x~c6g4-pdi9 100088 644237 2019-02-28 2018-09-30 665 120         855 48             903
1329 1329 BATON ROUGE GENERAL MEDICAL CENTER 3600 FLORIDA BLVD BATON ROUGE LA 70806 E. BATON ROUGE (225) 387-7767 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4503360 -91.1546380 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-wzk2-7azq.gecu 190065 643777 2019-02-28 2018-09-30 212 24   8   9 253 50 8   54       365
3865 3865 ODESSA REGIONAL MEDICAL CENTER 520 E 6TH STREET ODESSA TX 79761 ECTOR (432) 582-8340 Acute Care Hospitals Proprietary TRUE 31.8514580 -102.3660270 0   135 48 48135 36220 Midland-Odessa, TX Central Ector County https://data.medicare.gov/resource/xubh-q36u/row-62b5_9y3z.qtwf 450661 643964 2019-02-28 2018-09-30 133 10       49 192   14           206
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
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
1316 1316 BAPTIST HOSPITAL 1000 W MORENO ST PENSACOLA FL 32501 ESCAMBIA (850) 434-4011 Acute Care Hospitals Voluntary non-profit - Private TRUE 30.4286760 -87.2320150 0   33 12 12033 37860   Central Escambia County https://data.medicare.gov/resource/xubh-q36u/row-ijyx~shwb.imui 100093 644238 2019-02-28 2018-09-30 229 25     12   266 60             326
62 62 ST VINCENT'S MEDICAL CENTER 2800 MAIN ST BRIDGEPORT CT 6606 FAIRFIELD (203) 576-5551 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.2000830 -73.2024860 0   1 9 9001 14860 New York-Newark, NY-NJ-CT-PA Central Fairfield County https://data.medicare.gov/resource/xubh-q36u/row-fzpd_79fu~rdpp 70028 645052 2019-02-28 2018-09-30 186 14         200 88 10           298
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
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
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
2614 2614 COX MEDICAL CENTERS 3801 SOUTH NATIONAL AVENUE SPRINGFIELD MO 65807 GREENE (417) 269-6000 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.1449660 -93.2780800 0   77 29 29077 44180 Springfield-Branson, MO Central Greene County https://data.medicare.gov/resource/xubh-q36u/row-k4p4_umkj~v498 260040 645428 2019-02-28 2018-09-30 496 74       34 604 14 34   28       680
1759 1759 PRISMA HEALTH GREENVILLE MEMORIAL HOSPITAL 905 VERDAE BLVD SUITE 102 GREENVILLE SC 29605 GREENVILLE (864) 455-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.8291560 -82.3192040 0   45 45 45045 24860 Greenville-Spartanburg-Anderson, SC Central Greenville County https://data.medicare.gov/resource/xubh-q36u/row-rfz9-6mpm-5bj3 420078 643844 2019-02-28 2018-09-30 526 58 28       682 46 53   18       799
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
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
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
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
2801 2801 BETSY JOHNSON REGIONAL HOSPITAL 800 TILGHMAN DR DUNN NC 28334 HARNETT (910) 892-7161 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.3065550 -78.6330880 0   85 37 37085 20380 Raleigh-Durham-Chapel Hill, NC Central Harnett County https://data.medicare.gov/resource/xubh-q36u/row-28jj~ikwb_xihf 340071 643818 2019-02-28 2018-09-30 137 14         151               151
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
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
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
520 520 CATHOLIC MEDICAL CENTER 100 MCGREGOR STREET MANCHESTER NH 3102 HILLSBOROUGH (603) 668-3545 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.9912110 -71.4737900 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-juap.ysfe.wwxy 300034 644142 2019-02-28 2018-09-30 209 20         229   22           251
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
3116 3116 IREDELL MEMORIAL HOSPITAL INC 557 BROOKDALE DR P O BOX 1828 STATESVILLE NC 28677 IREDELL (704) 873-5661 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.7998600 -80.8768170 0   97 37 37097 16740 Charlotte-Concord, NC-SC Central Iredell County https://data.medicare.gov/resource/xubh-q36u/row-tkwc.4vcn-pb6i 340039 645132 2019-02-28 2018-09-30 139 16         155       48       203
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
241 241 KENT COUNTY MEMORIAL HOSPITAL 455 TOLL GATE RD WARWICK RI 2886 KENT (401) 737-7010 Acute Care Hospitals Proprietary TRUE 41.7044780 -71.4779020 0   3 44 44003 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-cxmm.944u~3iqc 410009 644655 2019-02-28 2018-09-30 308 15         323   20           343
2037 2037 KERSHAWHEALTH 1315 ROBERTS STREET CAMDEN SC 29020 KERSHAW (803) 432-4311 Acute Care Hospitals Proprietary TRUE 34.2531640 -80.5895790 0   55 45 45055 17900 Columbia-Orangeburg-Newberry, SC Outlying Kershaw County https://data.medicare.gov/resource/xubh-q36u/row-938m.r575~tkt8 420048 643943 2019-02-28 2018-09-30 113 10         123           55   178
3016 3016 TENNOVA HEALTHCARE-NORTH KNOXVILLE MEDICAL CENTER 7565 DANNAHER WAY POWELL POWELL TN 37849 KNOX (865) 545-8000 Acute Care Hospitals Proprietary TRUE 36.0533300 -83.9965920 0   93 47 47093 28940 Knoxville-Morristown-Sevierville, TN Central Knox County https://data.medicare.gov/resource/xubh-q36u/row-sfi4~bdiw.dy3i 440120 645185 2019-02-28 2018-09-30 282 52 44     15 393 25 22           440
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
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
2449 2449 CAPE CORAL HOSPITAL 636 DEL PRADO BLVD CAPE CORAL FL 33990 LEE (239) 574-2323 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.6393210 -81.9409460 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-h94e-be5i_u37i 100244 644248 2019-02-28 2018-09-30 235 22       23 280               280
2450 2450 GULF COAST MEDICAL CENTER LEE MEM HEALTH SYSTEM 13681 DOCTORS WAY FORT MYERS FL 33912 LEE (239) 768-5000 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.5430160 -81.8485890 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-ey2r_ercs~bbdu 100220 644710 2019-02-28 2018-09-30 320 36         356               356
2452 2452 LEE MEMORIAL HOSPITAL 2776 CLEVELAND AVE FORT MYERS FL 33901 LEE (239) 332-1111 Acute Care Hospitals Government - Hospital District or Authority TRUE 26.6269240 -81.8722950 0   71 12 12071 15980 Cape Coral-Fort Myers-Naples, FL Central Lee County https://data.medicare.gov/resource/xubh-q36u/row-d9mq-v9vy_3733 100012 644229 2019-02-28 2018-09-30 539 75       32 743   60   15       818

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