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

383 rows where "filed_date" is on date 2019-05-31 sorted by hospital_ownership

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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

filed_date (date) ✖

  • 2019-05-31 · 383 ✖
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
2816 2816 TEXAS HEALTH PRESBYTERIAN HOSPITAL ALLEN 1105 CENTRAL EXPRESSWAY NORTH ALLEN TX 75013 COLLIN (972) 747-6197 Acute Care Hospitals Government - Federal TRUE 33.1154330 -96.6715040 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-v7tw~68xq-fbxm 450840 648765 2019-05-31 2018-12-31 30 8         44               44
129 129 EAST ADAMS RURAL HOSPITAL 903 SOUTH ADAMS RITZVILLE WA 99169 ADAMS (509) 659-1200 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.1209590 -118.3722580 0   1 53 53001 36830 Moses Lake-Othello, WA Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-37up~x54g-vsqq 501311 653086 2019-05-31 2018-12-31 12           12               12
268 268 ASCENSION SACRED HEART BAY 615 N BONITA AVE PANAMA CITY FL 32401 BAY (850) 769-1511 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.1596810 -85.6470670 0   5 12 12005 37460   Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-sfb2_87vw-qbr7 100026 650248 2019-05-31 2018-12-31 236 57         293               293
326 326 PROSSER MEMORIAL HOSPITAL 723 MEMORIAL STREET PROSSER WA 99350 BENTON (509) 786-2222 Critical Access Hospitals Government - Hospital District or Authority TRUE 46.2076300 -119.7635020 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-jxdy-bhag~5gk3 501312 652444 2019-05-31 2018-12-31 25           25               25
1126 1126 ADVENTIST HEALTH TEHACHAPI VALLEY 1100 MAGELLAN TEHACHAPI CA 93561 KERN (661) 823-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 35.1474419 -118.4504364 1 ROOFTOP 29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-xx6n.a25c~74jx 51301 648598 2019-05-31 2018-12-31 16 4         20               20
1180 1180 UNIVERSITY HEALTH SYSTEM 4502 MEDICAL DR SAN ANTONIO TX 78229 BEXAR (210) 358-2637 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.5094880 -98.5770620 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-a5b3.8n6m-4vq3 450213 651423 2019-05-31 2018-12-31 460 20     44   606   27           633
1192 1192 WHIDBEYHEALTH MEDICAL CENTER 101 NORTH MAIN STREET COUPEVILLE WA 98239 ISLAND (360) 678-5151 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.2142400 -122.6861220 0   29 53 53029 36020 Seattle-Tacoma, WA Central Island County https://data.medicare.gov/resource/xubh-q36u/row-uede_fy5z~txux 501339 649688 2019-05-31 2018-12-31 19 6         25               25
1684 1684 CANDLER COUNTY HOSPITAL 400 CEDAR STREET METTER GA 30439 CANDLER (912) 685-5741 Critical Access Hospitals Government - Hospital District or Authority TRUE 32.4070810 -82.0666080 0   43 13 13043         https://data.medicare.gov/resource/xubh-q36u/row-i22u~jvuf~casx 111334 651205 2019-05-31 2018-12-31 19 6         25               25
1767 1767 MASON GENERAL HOSPITAL & FAMILY OF CLINICS 901 MT VIEW DRIVE SHELTON WA 98584 MASON (360) 426-1611 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.2267420 -123.1152790 0   45 53 53045 43220 Seattle-Tacoma, WA Central Mason County https://data.medicare.gov/resource/xubh-q36u/row-hitj-vpec_8dkv 501336 649687 2019-05-31 2018-12-31 19 6         25               25
1902 1902 EAST JEFFERSON GENERAL HOSPITAL 4200 HOUMA BLVD METAIRIE LA 70006 JEFFERSON (504) 454-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.0141620 -90.1814680 0   51 22 22051 35380 New Orleans-Metairie-Hammond, LA-MS Central Jefferson Parish https://data.medicare.gov/resource/xubh-q36u/row-4i6x.birx_qsve 190146 650473 2019-05-31 2018-12-31 251 29 12       309 12 24   49       394
1936 1936 NEWPORT COMMUNITY HOSPITAL 714 WEST PINE STREET NEWPORT WA 99156 PEND OREILLE (509) 447-2441 Critical Access Hospitals Government - Hospital District or Authority TRUE 48.1821700 -117.0484200 0   51 53 53051 44060 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Outlying Pend Oreille County https://data.medicare.gov/resource/xubh-q36u/row-kwpj_pxfj.xt2b 501310 649686 2019-05-31 2018-12-31 20           20       50       70
1998 1998 KOOTENAI HEALTH 2003 KOOTENAI HEALTH WAY COEUR D'ALENE ID 83814 KOOTENAI (208) 625-4000 Acute Care Hospitals Government - Hospital District or Authority TRUE 47.6945970 -116.7926690 0   55 16 16055 17660 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Kootenai County https://data.medicare.gov/resource/xubh-q36u/row-rqii_d7ee.cxzr 130049 649720 2019-05-31 2018-12-31 228 55       14 297               297
2192 2192 BIGFORK VALLEY HOSPITAL 258 PINE TREE DRIVE PO BOX 258 BIGFORK MN 56628 ITASCA (218) 743-3177 Critical Access Hospitals Government - Hospital District or Authority TRUE 47.7468850 -93.6468220 0   61 27 27061         https://data.medicare.gov/resource/xubh-q36u/row-356c-64uf.kf5r 241316 650718 2019-05-31 2018-12-31 20           20       47       67
2858 2858 ST BERNARD PARISH HOSPITAL 8000 WEST JUDGE PEREZ DRIVE CHALMETTE LA 70043 ST. BERNARD (504) 826-9500 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9570430 -89.9884200 0   87 22 22087 35380 New Orleans-Metairie-Hammond, LA-MS Central St. Bernard Parish https://data.medicare.gov/resource/xubh-q36u/row-xkq7~g3m2-5ugh 190308 650141 2019-05-31 2018-12-31 32 8         40               40
3027 3027 MELISSA MEMORIAL HOSPITAL 1001 E JOHNSON ST HOLYOKE CO 80734 PHILLIPS (970) 854-2241 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.5784280 -102.2902490 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-6wcd-peh6-fsnb 61305 650244 2019-05-31 2018-12-31 15           15               15
3028 3028 HAXTUN HOSPITAL DISTRICT 235 W FLETCHER ST HAXTUN CO 80731 PHILLIPS (970) 774-6123 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.6413860 -102.6308660 0   95 8 8095         https://data.medicare.gov/resource/xubh-q36u/row-amj6-3hms~eqap 61304 649172 2019-05-31 2018-12-31 25           25               25
3138 3138 PROWERS MEDICAL CENTER 401 KENDALL DR LAMAR CO 81052 PROWERS (719) 336-4343 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.0709150 -102.6090680 0   99 8 8099         https://data.medicare.gov/resource/xubh-q36u/row-g7ky~tb82~a5bh 61323 650118 2019-05-31 2018-12-31 25           25               25
3247 3247 RANGELY DISTRICT HOSPITAL 225 EAGLE CREST ST RANGELY CO 81648 RIO BLANCO (970) 675-5011 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.0802840 -108.8059100 0   103 8 8103         https://data.medicare.gov/resource/xubh-q36u/row-8932~ad3b_gnnd 61307 650116 2019-05-31 2018-12-31 25           25               25
3288 3288 STILLWATER MEDICAL - PERRY 501 N 14TH ST PERRY OK 73077 NOBLE (580) 336-3541 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.2890830 -97.2992290 0   103 40 40103         https://data.medicare.gov/resource/xubh-q36u/row-tnyg~f2xi.p77c 370139 649663 2019-05-31 2018-12-31 26           26               26
3297 3297 TRINITY HOSPITAL 60 EASTER AVENUE WEAVERVILLE CA 96093 TRINITY (530) 623-5541 Critical Access Hospitals Government - Hospital District or Authority TRUE 40.7375790 -122.9394440 0   105 6 6105         https://data.medicare.gov/resource/xubh-q36u/row-yq5n_hvzx.n2t3 51315 650664 2019-05-31 2018-12-31 25           25       23       48
3472 3472 ABBEVILLE GENERAL HOSPITAL 118 N HOSPITAL DR ABBEVILLE LA 70510 VERMILION (337) 893-5466 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.9732500 -92.1069860 0   113 22 22113 29180 Lafayette-Opelousas-Morgan City, LA Outlying Vermilion Parish https://data.medicare.gov/resource/xubh-q36u/row-b6fd-eygy.vwqx 190034 649244 2019-05-31 2018-12-31 38 6         44 16             60
3899 3899 SENTARA ALBEMARLE MEDICAL CENTER 1144 N ROAD ST ELIZABETH CITY NC 27909 PASQUOTANK (252) 335-0531 Acute Care Hospitals Government - Hospital District or Authority TRUE 36.3215300 -76.2200200 0   139 37 37139 21020 Virginia Beach-Norfolk, VA-NC Central Pasquotank County https://data.medicare.gov/resource/xubh-q36u/row-xfk5~qvx7~6vtj 340109 650342 2019-05-31 2018-12-31 81 10         91               91
4017 4017 THREE RIVERS HEALTH 701 S HEALTH PARKWAY THREE RIVERS MI 49093 ST. JOSEPH (269) 273-9602 Acute Care Hospitals Government - Hospital District or Authority FALSE 41.9349460 -85.6470480 0   149 26 26149 44780 Kalamazoo-Battle Creek-Portage, MI Central St. Joseph County https://data.medicare.gov/resource/xubh-q36u/row-bnfm~w7wq-f8qb 230015 649605 2019-05-31 2018-12-31 44 4         48   12           60
4123 4123 BRONSON SOUTH HAVEN HOSPITAL 955 S BAILEY AVE SOUTH HAVEN MI 49090 VAN BUREN (269) 637-5271 Acute Care Hospitals Government - Hospital District or Authority TRUE 42.3912520 -86.2641300 0   159 26 26159 28020 Kalamazoo-Battle Creek-Portage, MI Outlying Van Buren County https://data.medicare.gov/resource/xubh-q36u/row-zfqy_5w55-vbnk 230085 649607 2019-05-31 2018-12-31 49           49               49
4345 4345 UNIVERSITY HOSPITAL MCDUFFIE 2460 WASHINGTON ROAD THOMSON GA 30824 MC DUFFIE (706) 595-1411 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5232260 -82.5044780 0   189 13 13189 12260   Outlying McDuffie County https://data.medicare.gov/resource/xubh-q36u/row-zx3a.iuqr.6aqx 110111 651197 2019-05-31 2018-12-31 25           25               25
4404 4404 HANOVER HOSPITAL 205 S HANOVER STREET HANOVER KS 66945 WASHINGTON (785) 337-2214 Critical Access Hospitals Government - Hospital District or Authority TRUE 39.8910470 -96.8747710 0   201 20 20201         https://data.medicare.gov/resource/xubh-q36u/row-8nv9.9895.yp5i 171365 649230 2019-05-31 2018-12-31 25           25               25
4511 4511 UNIVERSITY HOSPITAL 1350 WALTON WAY AUGUSTA GA 30901 RICHMOND (706) 722-9011 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.4729890 -81.9813320 0   245 13 13245 12260   Central Richmond County https://data.medicare.gov/resource/xubh-q36u/row-uyz5-fma5.5625 110028 651195 2019-05-31 2018-12-31 417 141         574               574
4546 4546 LAVACA MEDICAL CENTER 1400 NORTH TEXANA STREET HALLETTSVILLE TX 77964 LAVACA (361) 798-3671 Critical Access Hospitals Government - Hospital District or Authority TRUE 29.4571450 -96.9398770 0   285 48 48285         https://data.medicare.gov/resource/xubh-q36u/row-wjtg_etrx~yntz 451376 649677 2019-05-31 2018-12-31 25           25               25
176 176 CARY MEDICAL CENTER 163 VAN BUREN RD, SUITE 1 CARIBOU ME 4736 AROOSTOOK (207) 498-3111 Acute Care Hospitals Government - Local TRUE 46.8782370 -68.0096390 0   3 23 23003         https://data.medicare.gov/resource/xubh-q36u/row-3dpx.x267~9y3n 200031 650153 2019-05-31 2018-12-31 43 6         49               49
273 273 COLUMBUS REGIONAL HOSPITAL 2400 E 17TH ST COLUMBUS IN 47201 BARTHOLOMEW (812) 379-4441 Acute Care Hospitals Government - Local TRUE 39.2158720 -85.8968540 0   5 18 18005 18020 Indianapolis-Carmel-Muncie, IN Central Bartholomew County https://data.medicare.gov/resource/xubh-q36u/row-u4i5.cqhh_8kd8 150112 649209 2019-05-31 2018-12-31 194 17         211   18           229
503 503 WITHAM HEALTH SERVICES 2605 N LEBANON ST LEBANON IN 46052 BOONE (765) 485-8000 Acute Care Hospitals Government - Local TRUE 40.0769090 -86.4752090 0   11 18 18011 26900 Indianapolis-Carmel-Muncie, IN Central Boone County https://data.medicare.gov/resource/xubh-q36u/row-gfq5-5jsq-rtmb 150104 649208 2019-05-31 2018-12-31 60 8         68 10     18       96
910 910 CLAIBORNE COUNTY HOSPITAL 123 MCCOMB AVENUE PORT GIBSON MS 39150 CLAIBORNE (601) 437-5141 Critical Access Hospitals Government - Local FALSE 31.9459920 -90.9853950 0   21 28 28021 46980 Jackson-Vicksburg-Brookhaven, MS Outlying Claiborne County https://data.medicare.gov/resource/xubh-q36u/row-wz4r-hvew~et2i 251320 650593 2019-05-31 2018-12-31 22           22 10             32
1133 1133 DELTA COUNTY MEMORIAL HOSPITAL 1501 E 3RD ST DELTA CO 81416 DELTA (970) 874-7681 Acute Care Hospitals Government - Local TRUE 38.7431660 -108.0475150 0   29 8 8029         https://data.medicare.gov/resource/xubh-q36u/row-wsed.7ysa~nwhq 60071 649875 2019-05-31 2018-12-31 43 6         49               49
1265 1265 DECATUR COUNTY MEMORIAL HOSPITAL 720 N LINCOLN ST GREENSBURG IN 47240 DECATUR (812) 663-4331 Critical Access Hospitals Government - Local TRUE 39.3441160 -85.4794040 0   31 18 18031 24700 Indianapolis-Carmel-Muncie, IN Central Decatur County https://data.medicare.gov/resource/xubh-q36u/row-hqis.arxf_g2ap 151332 649101 2019-05-31 2018-12-31 25           25               25
1480 1480 SAN JUAN HOSPITAL 380 WEST 100 NORTH MONTICELLO UT 84535 SAN JUAN (435) 587-2116 Critical Access Hospitals Government - Local TRUE 37.8738750 -109.3500620 0   37 49 49037         https://data.medicare.gov/resource/xubh-q36u/row-bwvs.75rh_updn 461308 650788 2019-05-31 2018-12-31 20 1         21               21
1697 1697 DICKINSON COUNTY MEMORIAL HOSPITAL 1721 S STEPHENSON AVE IRON MOUNTAIN MI 49801 DICKINSON (906) 774-1313 Acute Care Hospitals Government - Local TRUE 45.8085720 -88.0442680 0   43 26 26043 27020   Central Dickinson County https://data.medicare.gov/resource/xubh-q36u/row-ss3t.epsm-biyy 230055 649262 2019-05-31 2018-12-31 33 6         39               39
1819 1819 FALL RIVER HOSPITAL - CAH 1201 HIGHWAY 71 SOUTH HOT SPRINGS SD 57747 FALL RIVER (605) 745-8910 Critical Access Hospitals Government - Local TRUE 43.4183120 -103.4807830 0   47 46 46047         https://data.medicare.gov/resource/xubh-q36u/row-85xb~ejm9_5eec 431322 650784 2019-05-31 2018-12-31 25           25       48       73
1835 1835 WOODLAWN HOSPITAL 1400 E 9TH ST ROCHESTER IN 46975 FULTON (574) 223-3141 Critical Access Hospitals Government - Local TRUE 41.0617280 -86.1969730 0   49 18 18049         https://data.medicare.gov/resource/xubh-q36u/row-2dgz-xb34_49d2 151313 649096 2019-05-31 2018-12-31 21 4         25               25
1892 1892 GUNNISON VALLEY HOSPITAL 711 NORTH TAYLOR STREET GUNNISON CO 81230 GUNNISON (970) 641-1456 Critical Access Hospitals Government - Local TRUE 38.5510890 -106.9243210 0   51 8 8051         https://data.medicare.gov/resource/xubh-q36u/row-e9p4-pdcf.rn62 61320 650438 2019-05-31 2018-12-31 20           20               20
1959 1959 HENNEPIN COUNTY MEDICAL CENTER 1 701 PARK AVENUE MINNEAPOLIS MN 55415 HENNEPIN (612) 873-3629 Acute Care Hospitals Government - Local TRUE 44.9728500 -93.2627070 0   53 27 27053 33460 Minneapolis-St. Paul, MN-WI Central Hennepin County https://data.medicare.gov/resource/xubh-q36u/row-arc4-988k~teqm 240004 650492 2019-05-31 2018-12-31 235 24   17 24 21 330 108 27           465
2136 2136 HANCOCK REGIONAL HOSPITAL 801 N STATE ST GREENFIELD IN 46140 HANCOCK (317) 462-5544 Acute Care Hospitals Government - Local TRUE 39.7949520 -85.7696040 0   59 18 18059 26900 Indianapolis-Carmel-Muncie, IN Central Hancock County https://data.medicare.gov/resource/xubh-q36u/row-9wnz_ckw6~khmk 150037 649205 2019-05-31 2018-12-31 37 24         61 10         7   78
2246 2246 HENDRICKS REGIONAL HEALTH 1000 E MAIN ST DANVILLE IN 46122 HENDRICKS (317) 745-4451 Acute Care Hospitals Government - Local TRUE 39.7607100 -86.5009950 0   63 18 18063 26900 Indianapolis-Carmel-Muncie, IN Central Hendricks County https://data.medicare.gov/resource/xubh-q36u/row-7pz3-j79y~ybxb 150005 649202 2019-05-31 2018-12-31 121 12         133               133
2572 2572 HAMILTON COUNTY HOSPITAL 700 NORTH HUSER SYRACUSE KS 67878 HAMILTON (620) 384-7461 Critical Access Hospitals Government - Local TRUE 37.9846055 -101.7426286 1 ROOFTOP 75 20 20075         https://data.medicare.gov/resource/xubh-q36u/row-aubk-tw4u-vx2j 171322 649228 2019-05-31 2018-12-31 25           25               25
2696 2696 JOHNSON MEMORIAL HOSPITAL 1125 W JEFFERSON ST FRANKLIN IN 46131 JOHNSON (317) 736-3300 Acute Care Hospitals Government - Local TRUE 39.4805980 -86.0766630 0   81 18 18081 26900 Indianapolis-Carmel-Muncie, IN Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-gz4n-xn3z~kiqn 150001 649201 2019-05-31 2018-12-31 77 6         83   11           94
3178 3178 ARBUCKLE MEMORIAL HOSPITAL AUTHORITY 2011 WEST BROADWAY SULPHUR OK 73086 MURRAY (580) 622-2161 Critical Access Hospitals Government - Local TRUE 34.5063330 -96.9960050 0   99 40 40099         https://data.medicare.gov/resource/xubh-q36u/row-k94n_jt84~krmu 371328 648757 2019-05-31 2018-12-31 25           25               25
3207 3207 MURRAY COUNTY MEMORIAL HOSPITAL 2042 JUNIPER AVENUE SLAYTON MN 56172 MURRAY (507) 836-6111 Critical Access Hospitals Government - Local TRUE 43.9927950 -95.7592260 0   101 27 27101         https://data.medicare.gov/resource/xubh-q36u/row-k8xk~tvdp~cidg 241319 650719 2019-05-31 2018-12-31 20           20               20
3651 3651 WYOMING COUNTY COMMUNITY HOSPITAL 400 NORTH MAIN STREET WARSAW NY 14569 WYOMING (585) 786-2233 Acute Care Hospitals Government - Local TRUE 42.7534470 -78.1325330 0   121 36 36121         https://data.medicare.gov/resource/xubh-q36u/row-4dfp-x42q-zvqb 330008 650734 2019-05-31 2018-12-31 45 5         50 12     138       200
3708 3708 COFFEYVILLE REGIONAL MEDICAL CENTER, INC 1400 W 4TH ST COFFEYVILLE KS 67337 MONTGOMERY (620) 251-1200 Acute Care Hospitals Government - Local TRUE 37.0403990 -95.6383460 0   125 20 20125 17700   Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-jtf8.u9rb_44p3 170145 649224 2019-05-31 2018-12-31 40 7         47       20       67
3753 3753 MAGEE GENERAL HOSPITAL 300 3RD AVE SE MAGEE MS 39111 SIMPSON (601) 849-5070 Acute Care Hospitals Government - Local TRUE 31.8705850 -89.7283890 0   127 28 28127 27140 Jackson-Vicksburg-Brookhaven, MS Outlying Simpson County https://data.medicare.gov/resource/xubh-q36u/row-ncai-7t3m_ee8c 250124 649278 2019-05-31 2018-12-31 44           44               44
3828 3828 NEOSHO MEMORIAL REGIONAL MEDICAL CENTER 629 SOUTH PLUMMER CHANUTE KS 66720 NEOSHO (620) 431-4000 Critical Access Hospitals Government - Local TRUE 37.6751800 -95.4708960 0   133 20 20133         https://data.medicare.gov/resource/xubh-q36u/row-bqsi.4ak9-dfb2 171380 649232 2019-05-31 2018-12-31 17 5         22               22
4129 4129 MEMORIAL HOSPITAL 500 LONDON AVENUE MARYSVILLE OH 43040 UNION (937) 578-2289 Acute Care Hospitals Government - Local TRUE 40.2312910 -83.3688410 0   159 39 39159 18140 Columbus-Marion-Zanesville, OH Outlying Union County https://data.medicare.gov/resource/xubh-q36u/row-ic8f_vxye-c7cu 360092 649320 2019-05-31 2018-12-31 53 7         60               60
4662 4662 THROCKMORTON COUNTY MEMORIAL HOSPITAL 802 N MINTER AVENUE THROCKMORTON TX 76483 THROCKMORTON (940) 849-2151 Critical Access Hospitals Government - Local TRUE 33.1896520 -99.1772780 0   447 48 48447         https://data.medicare.gov/resource/xubh-q36u/row-ckdk-2pw4-m4du 451339 649839 2019-05-31 2018-12-31 14           14               14
1204 1204 DENVER HEALTH MEDICAL CENTER 777 BANNOCK ST DENVER CO 80204 DENVER (303) 602-4930 Acute Care Hospitals Government - State TRUE 39.7282300 -104.9900660 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-6si7.z49y~jb56 60011 650437 2019-05-31 2018-12-31 298 32     23 25 378 64 11           453
2364 2364 UNIVERSITY HOSPITAL S U N Y HEALTH SCIENCE CENTER 750 EAST ADAMS STREET SYRACUSE NY 13210 ONONDAGA (315) 473-4240 Acute Care Hospitals Government - State TRUE 43.0426770 -76.1393230 0   67 36 36067 45060 Syracuse-Auburn, NY Central Onondaga County https://data.medicare.gov/resource/xubh-q36u/row-kv4k~pugk.273s 330241 650320 2019-05-31 2018-12-31 547 65 8 6     641 24 50   20       735
3277 3277 STONY BROOK UNIVERSITY HOSPITAL HEALTH SCIENCES CENTER SUNY STONY BROOK NY 11794 SUFFOLK (631) 444-4000 Acute Care Hospitals Government - State TRUE 40.9097910 -73.1161755 1 ROOFTOP 103 36 36103 35620 New York-Newark, NY-NJ-CT-PA Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-v82y.wvkf-fyvq 330393 650754 2019-05-31 2018-12-31 525 70   6   46 657 38             695
3455 3455 JACK HUGHSTON MEMORIAL HOSPITAL 4401 RIVER CHASE DRIVE PHENIX CITY AL 36867 RUSSELL (334) 732-3000 Acute Care Hospitals Government - State TRUE 32.5090450 -85.0056960 0   113 1 1113 17980 Columbus-Auburn-Opelika, GA-AL Central Russell County https://data.medicare.gov/resource/xubh-q36u/row-6v2c.qrez~vn8e 10168 651160 2019-05-31 2018-12-31 39 8         47               47
3769 3769 DOCTOR CENTER HOSPITAL SAN FERNANDO DE LA CAROLINA EDIF JESUS T PINEIRO AVE FERNANDEZ JUNCOS BO PUEBL CAROLINA PR 979 SAN JUAN (787) 725-6038 Acute Care Hospitals Government - State TRUE 18.4215119 -66.0256637 1 GEOMETRIC_CENTER 127 72 72127 41980 San Juan-Carolina, PR Central San Juan Municipio https://data.medicare.gov/resource/xubh-q36u/row-ngg4_t8sn.3cyg 400132 650363 2019-05-31 2018-12-31 103 6         109               109
819 819 MOUNTAIN VIEW HOSPITAL 2325 CORONADO STREET IDAHO FALLS ID 83404 BONNEVILLE (208) 557-2700 Acute Care Hospitals Physician FALSE 43.4725240 -111.9887170 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-4xx8-2i4p-wi9n 130065 649556 2019-05-31 2018-12-31 41           41               41
1326 1326 SURGICAL SPECIALTY CENTER OF BATON ROUGE 8080 BLUEBONNET BLVD BATON ROUGE LA 70810 E. BATON ROUGE (225) 408-8080 Acute Care Hospitals Physician FALSE 30.3765650 -91.0993330 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-vta2_xzya~pwww 190251 648928 2019-05-31 2018-12-31 16           16               16
1624 1624 CHARLESTON SURGICAL HOSPITAL 1306 KANAWHA BOULEVARD EAST CHARLESTON WV 25301 KANAWHA (304) 343-4371 Acute Care Hospitals Physician FALSE 38.3429910 -81.6306620 0   39 54 54039 16620 Charleston-Huntington-Ashland, WV-OH-KY Central Kanawha County https://data.medicare.gov/resource/xubh-q36u/row-zfdk.i8cn~ciui 510091 650428 2019-05-31 2018-12-31 8           8               8
2341 2341 ANIMAS SURGICAL HOSPITAL, LLC 575 RIVERGATE LN DURANGO CO 81301 LA PLATA (970) 247-3537 Acute Care Hospitals Physician TRUE 37.2488890 -107.8707740 0   67 8 8067 20420   Central La Plata County https://data.medicare.gov/resource/xubh-q36u/row-twp9-b345.bypu 60117 650115 2019-05-31 2018-12-31 12           12               12
2880 2880 PATIENTS' HOSPITAL OF REDDING 2900 EUREKA WAY REDDING CA 96001 SHASTA (530) 225-8700 Acute Care Hospitals Physician FALSE 40.5854900 -122.4162640 0   89 6 6089 39820 Redding-Red Bluff, CA Central Shasta County https://data.medicare.gov/resource/xubh-q36u/row-5vur~pqci_pq3w 50697 650657 2019-05-31 2018-12-31 10           10               10
2900 2900 PINNACLE HOSPITAL 9301 CONNECTICUT DR CROWN POINT IN 46307 LAKE (219) 756-2100 Acute Care Hospitals Physician FALSE 41.4491180 -87.3300690 0   89 18 18089 16980 Chicago-Naperville, IL-IN-WI Central Lake County https://data.medicare.gov/resource/xubh-q36u/row-eygb~yded_6pv4 150166 649212 2019-05-31 2018-12-31 16 2         18               18
2947 2947 KANSAS CITY ORTHOPAEDIC INSTITUTE 3651 COLLEGE BLVD LEAWOOD KS 66211 JOHNSON (913) 319-7633 Acute Care Hospitals Physician FALSE 38.9275490 -94.6282350 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-s6dg~iufq_ybuc 170188 649225 2019-05-31 2018-12-31 12           12               12
3371 3371 PHYSICIANS MEDICAL CENTER 218 CORPORATE DRIVE HOUMA LA 70360 TERREBONNE (985) 853-1390 Acute Care Hospitals Physician FALSE 29.6000530 -90.7502880 0   109 22 22109 26380   Central Terrebonne Parish https://data.medicare.gov/resource/xubh-q36u/row-8tmv-a3a5~7wbn 190241 649597 2019-05-31 2018-12-31 30           30               30
3399 3399 SURGICAL HOSPITAL OF OKLAHOMA, LLC 100 SOUTHEAST 59TH STREET OKLAHOMA CITY OK 73129 OKLAHOMA (405) 634-9300 Acute Care Hospitals Physician TRUE 35.4062250 -97.5093160 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-drs8-u5z4.yfq6 370201 649812 2019-05-31 2018-12-31 12           12               12
3656 3656 THE HEART HOSPITAL BAYLOR DENTON 2801 SOUTH MAYHILL ROAD DENTON TX 76208 DENTON (940) 220-0600 Acute Care Hospitals Physician TRUE 33.1769700 -97.0881990 0   121 48 48121 19100 Dallas-Fort Worth, TX-OK Outlying Denton County https://data.medicare.gov/resource/xubh-q36u/row-rbda~a4ni-iua9 450893 648994 2019-05-31 2018-12-31 22           22               22
4440 4440 HOUSTON PHYSICIANS' HOSPITAL 333 N TEXAS AVENUE WEBSTER TX 77598 HARRIS (281) 335-1700 Acute Care Hospitals Physician TRUE 29.5349020 -95.1257850 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-yxt9~vqzu.mhqf 670008 649528 2019-05-31 2018-12-31 21           21               21
4587 4587 ASPIRE BEHAVIORAL HEALTH OF CONROE, LLC 2006 SOUTH LOOP 336 WEST, SUITE 500 CONROE TX 77304 MONTGOMERY (936) 647-3500 Acute Care Hospitals Physician FALSE 30.2840690 -95.4801310 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-h7u8.wg6t-a3vd 670093 651497 2019-05-31 2018-12-31 6           6 24             30
4592 4592 NACOGDOCHES MEDICAL CENTER 4920 NE STALLINGS DRIVE NACOGDOCHES TX 75961 NACOGDOCHES (936) 569-9481 Acute Care Hospitals Physician TRUE 31.6520580 -94.6542650 0   347 48 48347 34860   Central Nacogdoches County https://data.medicare.gov/resource/xubh-q36u/row-m94n-8ys7.xs7q 450656 649673 2019-05-31 2018-12-31 136 11       8 155               155
4640 4640 USMD HOSPITAL AT ARLINGTON L P 801 W INTERSTATE 20 ARLINGTON TX 76017 TARRANT (817) 472-3400 Acute Care Hospitals Physician TRUE 32.6791510 -97.1159710 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-hc6u~w7qj-g9et 450872 649967 2019-05-31 2018-12-31 30 4         34               34
85 85 TREASURE VALLEY HOSPITAL 8800 WEST EMERALD STREET BOISE ID 83704 ADA (208) 373-5000 Acute Care Hospitals Proprietary FALSE 43.6112890 -116.2903320 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-egh2.u29a~s2jf 130063 650684 2019-05-31 2018-12-31 9           9               9
260 260 MEDICAL CENTER OF AURORA, THE 1501 S POTOMAC ST AURORA CO 80012 ARAPAHOE (303) 873-5511 Acute Care Hospitals Proprietary TRUE 39.6893460 -104.8311500 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-b8kj.p6xy-3gvh 60100 648892 2019-05-31 2018-12-31 250 45       14 309 20             329
287 287 MORTON HOSPITAL 88 WASHINGTON STREET TAUNTON MA 2780 BRISTOL (508) 828-7000 Acute Care Hospitals Proprietary TRUE 41.9055830 -71.0943500 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-648n_jcsm_qayn 220073 650488 2019-05-31 2018-12-31 81 12         93 19             112
289 289 SAINT ANNE'S HOSPITAL 795 MIDDLE STREET FALL RIVER MA 2721 BRISTOL (508) 674-5600 Acute Care Hospitals Proprietary TRUE 41.6933210 -71.1636420 0   5 25 25005 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Bristol County https://data.medicare.gov/resource/xubh-q36u/row-kxda_mnxm~imp3 220020 650486 2019-05-31 2018-12-31 163 12         175 31             206
320 320 WOODLAND HEIGHTS MEDICAL CENTER 505 SOUTH JOHN REDDITT DRIVE LUFKIN TX 75904 ANGELINA (936) 634-8311 Acute Care Hospitals Proprietary TRUE 31.3277370 -94.7561390 0   5 48 48005 31260   Central Angelina County https://data.medicare.gov/resource/xubh-q36u/row-2twc-7b9d-f8nh 450484 649671 2019-05-31 2018-12-31 115 15         145               145
416 416 STEWARD ROCKLEDGE HOSPITAL 110 LONGWOOD AVE ROCKLEDGE FL 32955 BREVARD (321) 637-2603 Acute Care Hospitals Proprietary TRUE 28.3345400 -80.7231330 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-tbme~t6bb.jqha 100092 649413 2019-05-31 2018-12-31 243 31         274 24             298
417 417 STEWARD MELBOURNE HOSPITAL 250 NORTH WICKHAM ROAD MELBOURNE FL 32935 BREVARD (321) 752-1200 Acute Care Hospitals Proprietary TRUE 28.1098040 -80.6726100 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-fnh8.cjxx_ncpd 100291 649425 2019-05-31 2018-12-31 101 12         113               113
486 486 NORTHWEST MEDICAL CENTER 2801 N STATE RD 7 MARGATE FL 33063 BROWARD (954) 974-0400 Acute Care Hospitals Proprietary TRUE 26.2629030 -80.2019050 0   11 12 12011 33100 Miami-Fort Lauderdale-Port St. Lucie, FL Central Broward County https://data.medicare.gov/resource/xubh-q36u/row-e825~y5d2-68se 100189 649421 2019-05-31 2018-12-31 193 24       11 228               228
551 551 SCOTTSDALE THOMPSON PEAK MEDICAL CENTER 7400 EAST THOMPSON PEAK PARKWAY SCOTTSDALE AZ 85255 MARICOPA (480) 324-7001 Acute Care Hospitals Proprietary TRUE 33.6697770 -111.9218030 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-y7bn~8g49_tr6b 30123 650235 2019-05-31 2018-12-31 112 8         120               120
555 555 SCOTTSDALE OSBORN MEDICAL CENTER 7400 EAST OSBORN ROAD SCOTTSDALE AZ 85251 MARICOPA (480) 882-4004 Acute Care Hospitals Proprietary TRUE 33.4876390 -111.9227250 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-xncf.ukg7_66e2 30038 650230 2019-05-31 2018-12-31 268 59         327   14           341
569 569 SCOTTSDALE SHEA MEDICAL CENTER 9003 EAST SHEA BOULEVARD SCOTTSDALE AZ 85260 MARICOPA (480) 323-3000 Acute Care Hospitals Proprietary TRUE 33.5824670 -111.8860320 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-zegy.nw3j~tfkb 30087 650231 2019-05-31 2018-12-31 378 25       24 427               427
648 648 HILTON HEAD REGIONAL MEDICAL CENTER 25 HOSPITAL CENTER BLVD HILTON HEAD ISLAND SC 29925 BEAUFORT (843) 681-6122 Acute Care Hospitals Proprietary TRUE 32.2193200 -80.7125000 0   13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-twij.hnjd-wm9w 420080 651483 2019-05-31 2018-12-31 81 12         93               93
784 784 LOWER BUCKS HOSPITAL 501 BATH ROAD BRISTOL PA 19007 BUCKS (215) 785-9200 Acute Care Hospitals Proprietary TRUE 40.1040650 -74.8646260 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-3pai_t2mu_egih 390070 651661 2019-05-31 2018-12-31 108 22         130 45             175
862 862 EAST COOPER MEDICAL CENTER 2000 HOSPITAL DR MOUNT PLEASANT SC 29464 CHARLESTON (843) 881-0100 Acute Care Hospitals Proprietary TRUE 32.8209970 -79.8496130 0   19 45 45019 16700   Central Charleston County https://data.medicare.gov/resource/xubh-q36u/row-a8up_sjrm.scy3 420089 648981 2019-05-31 2018-12-31 118 12         130               130
938 938 HIMA SAN PABLO BAYAMON 70 CALLE SANTA CRUZ BAYAMON PR 961 BAYAMON (787) 620-4747 Acute Care Hospitals Proprietary TRUE 18.3976640 -66.1496740 0   21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-gt9f-5hpz-5v3k 400109 650772 2019-05-31 2018-12-31 290 39 7       336               336
1006 1006 ST ELIZABETH'S MEDICAL CENTER 736 CAMBRIDGE STREET BRIGHTON MA 2135 SUFFOLK (617) 789-3000 Acute Care Hospitals Proprietary TRUE 42.3497730 -71.1481200 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-2h6b~pv8m.4qst 220036 650487 2019-05-31 2018-12-31 166 46         212 62             274
1016 1016 CARNEY HOSPITAL 2100 DORCHESTER AVENUE BOSTON MA 2124 SUFFOLK (617) 506-2000 Acute Care Hospitals Proprietary TRUE 42.2781080 -71.0664420 0   25 25 25025 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Suffolk County https://data.medicare.gov/resource/xubh-q36u/row-nhy8.nh8q_gagk 220017 650485 2019-05-31 2018-12-31 100 10         110 16             126
1057 1057 HIMA SAN PABLO-CAGUAS AVE LUIS MUNOZ MARIN CAGUAS PR 725 CAGUAS (787) 653-3434 Acute Care Hospitals Proprietary TRUE 18.2270107 -66.0273180 1 GEOMETRIC_CENTER 25 72 72025 41980 San Juan-Carolina, PR Central Caguas Municipio https://data.medicare.gov/resource/xubh-q36u/row-7siz.yb89_3gij 400120 649347 2019-05-31 2018-12-31 394 46         440               440
1125 1125 DELANO REGIONAL MEDICAL CENTER 1401 GARCES HIGHWAY DELANO CA 93215 KERN (661) 725-4800 Acute Care Hospitals Proprietary TRUE 35.7614180 -119.2388780 0   29 6 6029 12540   Central Kern County https://data.medicare.gov/resource/xubh-q36u/row-6xns.bkw3_m9qr 50608 650656 2019-05-31 2018-12-31 95 10         105       2   49   156
1184 1184 METHODIST AMBULATORY SURGERY HOSPITAL NW 9150 HUEBNER RD SUITE 100 SAN ANTONIO TX 78240 BEXAR (210) 575-5000 Acute Care Hospitals Proprietary TRUE 29.5276050 -98.5959950 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-f26r~6776-r3st 450780 650209 2019-05-31 2018-12-31 22           22               22
1214 1214 MEMORIAL HOSPITAL JACKSONVILLE 3625 UNIVERSITY BLVD S JACKSONVILLE FL 32216 DUVAL (904) 702-6111 Acute Care Hospitals Proprietary TRUE 30.2876330 -81.6024050 0   31 12 12031 27260 Jacksonville-St. Marys-Palatka, FL-GA Central Duval County https://data.medicare.gov/resource/xubh-q36u/row-cpb7-vuug-u3fk 100179 650250 2019-05-31 2018-12-31 316 51         377 41             418
1312 1312 SPARKS MEDICAL CENTER - VAN BUREN 211 CRAWFORD MEMORIAL DRIVE VAN BUREN AR 72956 CRAWFORD (479) 474-3401 Acute Care Hospitals Proprietary TRUE 35.4341750 -94.3394510 0   33 5 5033 22900   Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-w5xt~zwtc_2chf 40018 649071 2019-05-31 2018-12-31 31 8         39               39
1486 1486 GLENDORA COMMUNITY HOSPITAL 150 WEST ROUTE 66 GLENDORA CA 91740 LOS ANGELES (626) 335-0231 Acute Care Hospitals Proprietary TRUE 34.1286850 -117.8651930 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-pbt3-vx8t-nmwi 50205 652416 2019-05-31 2018-12-31 97 10         107 21             128
1498 1498 WEST HILLS HOSPITAL & MEDICAL CENTER 7300 MEDICAL CENTER DR WEST HILLS CA 91307 LOS ANGELES (818) 676-4100 Acute Care Hospitals Proprietary FALSE 34.2029310 -118.6285980 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-iyjd_idr8.tn3h 50481 649165 2019-05-31 2018-12-31 192 25       11 228               228
1508 1508 EMANATE HEALTH INTER-COMMUNITY HOSPITAL 210 W SAN BERNARDINO ROAD COVINA CA 91723 LOS ANGELES (626) 814-2468 Acute Care Hospitals Proprietary TRUE 34.0899470 -117.8936660 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-ywn3.ebem-km5h 50382 650652 2019-05-31 2018-12-31 401 20 20     40 481   12   23   10   526
1512 1512 L A DOWNTOWN MEDICAL CENTER 1711 WEST TEMPLE STREET LOS ANGELES CA 90026 LOS ANGELES (213) 989-6123 Acute Care Hospitals Proprietary FALSE 34.0687900 -118.2635600 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zwwh-h6yb.86z7 50763 650663 2019-05-31 2018-12-31 222 12         234               234
1521 1521 SAN DIMAS COMMUNITY HOSPITAL 1350 W COVINA BLVD SAN DIMAS CA 91773 LOS ANGELES (909) 599-6811 Acute Care Hospitals Proprietary TRUE 34.0994230 -117.8350060 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8cu2-sqr5-vidq 50588 649167 2019-05-31 2018-12-31 87 8         95               95
1543 1543 SPARROW CLINTON HOSPITAL 805 S OAKLAND SAINT JOHNS MI 48879 CLINTON (989) 224-6881 Critical Access Hospitals Proprietary TRUE 42.9934350 -84.5558080 0   37 26 26037 29620 Lansing-East Lansing-Owosso, MI Central Clinton County https://data.medicare.gov/resource/xubh-q36u/row-2x5u-xt8b.6eqd 231326 649611 2019-05-31 2018-12-31 23 2         25               25
1566 1566 TRISTAR CENTENNIAL MEDICAL CENTER 2300 PATTERSON STREET NASHVILLE TN 37203 DAVIDSON (615) 342-1000 Acute Care Hospitals Proprietary TRUE 36.1529070 -86.8076460 0   37 47 47037 34980 Nashville-Davidson--Murfreesboro, TN Central Davidson County https://data.medicare.gov/resource/xubh-q36u/row-gz5m_2jcw~23hu 440161 651235 2019-05-31 2018-12-31 322 24     48 60 472 132             604

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