hospital_data

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

4,766 rows sorted by county_name

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
96 96 CAPE COD HOSPITAL 88 LEWIS BAY ROAD HYANNIS MA 2601 BARNSTABLE (508) 771-1800 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.6528230 -70.2748470 0   1 25 25001 12700 Boston-Worcester-Providence, MA-RI-NH-CT Central Barnstable County https://data.medicare.gov/resource/xubh-q36u/row-wu4e-kfxd~b2tt 220012 644735 2019-03-08 2018-09-30 215 11 13       239 20             259
97 97 FALMOUTH HOSPITAL 67 & 100 TER HEUN DRIVE FALMOUTH MA 2540 BARNSTABLE (508) 548-5300 Acute Care Hospitals Voluntary non-profit - Private TRUE 41.5649620 -70.6211260 0   1 25 25001 12700 Boston-Worcester-Providence, MA-RI-NH-CT Central Barnstable County https://data.medicare.gov/resource/xubh-q36u/row-ycds_hhnf.xdyd 220135 645109 2019-03-08 2018-09-30 85 10         95               95
434 434 T J SAMSON COMMUNITY HOSPITAL 1301 NORTH RACE STREET GLASGOW KY 42141 BARREN (270) 651-4159 Acute Care Hospitals Voluntary non-profit - Other TRUE 37.0115660 -85.9038620 0   9 21 21009 23980 Bowling Green-Glasgow, KY Central Barren County https://data.medicare.gov/resource/xubh-q36u/row-ry2c-3t2y_53py 180017 643409 2019-02-14 2018-09-30 94 10       4 108       16   6   130
330 330 MARSHFIELD MEDICAL CENTER - RICE LAKE 1700 WEST STOUT STREET RICE LAKE WI 54868 BARRON (715) 234-1515 Acute Care Hospitals Voluntary non-profit - Private TRUE 45.5080420 -91.7590270 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-skqj~bt33-3hxj 520011 640931 2019-01-10 2018-09-30 35 5         40               40
331 331 MAYO CLINIC HEALTH SYSTEM-NORTHLAND 1222 E WOODLAND AVE BARRON WI 54812 BARRON (715) 537-3186 Critical Access Hospitals Voluntary non-profit - Private TRUE 45.3983690 -91.8406680 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-y236_phpe.9nrq 521315 649524 2019-05-28 2018-12-31 25           25               25
332 332 CUMBERLAND MEMORIAL HOSPITAL 1110 7TH AVENUE CUMBERLAND WI 54829 BARRON (715) 822-7500 Critical Access Hospitals Voluntary non-profit - Other TRUE 45.5309390 -92.0295920 0   5 55 55005         https://data.medicare.gov/resource/xubh-q36u/row-r4fu_4cy5~ir4d 521353 661689 2019-11-27 2019-06-30 25           25               25
599 599 NORTHEAST GEORGIA MEDICAL CENTER BARROW 316 NORTH BROAD STREET WINDER GA 30680 BARROW (770) 848-8611 Acute Care Hospitals Proprietary TRUE 34.0077010 -83.7067060 0   13 13 13013 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Barrow County https://data.medicare.gov/resource/xubh-q36u/row-hr24_ckbz~3ykf 110045 644713 2019-03-01 2018-09-30 50 6         56               56
446 446 COX MONETT HOSPITAL 801 NORTH LINCOLN AVENUE MONETT MO 65708 BARRY (417) 354-1400 Critical Access Hospitals Voluntary non-profit - Private TRUE 36.9266330 -93.9312500 0   9 29 29009         https://data.medicare.gov/resource/xubh-q36u/row-egvf~xwpf-7msx 261329 645668 2019-03-06 2018-09-30 25           25               25
447 447 MERCY HOSPITAL CASSVILLE 94 MAIN STREET CASSVILLE MO 65625 BARRY (417) 847-6065 Critical Access Hospitals Voluntary non-profit - Church TRUE 36.6740770 -93.8718860 0   9 29 29009         https://data.medicare.gov/resource/xubh-q36u/row-wswc_mpwv.fwbj 261317 660251 2019-11-26 2019-06-30 18           18               18
688 688 SPECTRUM HEALTH PENNOCK 1009 W GREEN ST HASTINGS MI 49058 BARRY (269) 945-3451 Critical Access Hospitals Voluntary non-profit - Other TRUE 42.6442000 -85.3021000 0   15 26 26015 24340 Grand Rapids-Wyoming-Muskegon, MI Outlying Barry County https://data.medicare.gov/resource/xubh-q36u/row-7m4u.pz7d~8678 231339 660108 2019-11-25 2019-06-30 19 6         25               25
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
431 431 UNIVERSITY OF KS HLTH SYSTEM GREAT BEND CAMPUS 514 CLEVELAND STREET GREAT BEND KS 67530 BARTON (620) 792-8833 Acute Care Hospitals Proprietary TRUE 38.3562000 -98.7916190 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-ezt6_4fjw-kpxn 170191 660092 2019-11-26 2019-06-30 29 4         33               33
432 432 CLARA BARTON HOSPITAL 250 W 9TH STREET HOISINGTON KS 67544 BARTON (620) 653-2114 Critical Access Hospitals Voluntary non-profit - Private TRUE 38.5215490 -98.7794100 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-fy4c.k945-z7ft 171333 648920 2019-05-28 2018-12-31 18           18               18
433 433 ELLINWOOD DISTRICT HOSPITAL 605 N MAIN STREET ELLINWOOD KS 67526 BARTON (620) 564-2548 Critical Access Hospitals Government - Hospital District or Authority TRUE 38.3607070 -98.5811930 0   9 20 20009 24460   Central Barton County https://data.medicare.gov/resource/xubh-q36u/row-kt5p.cy3y_6d85 171301 661185 2019-02-28 2018-09-30 25           25               25
513 513 COX BARTON COUNTY HOSPITAL 29 NW 1ST LANE LAMAR MO 64759 BARTON (417) 682-6081 Critical Access Hospitals Government - Local TRUE 37.5052820 -94.2994820 0   11 29 29011         https://data.medicare.gov/resource/xubh-q36u/row-8cv5-t4zj_7sig 261325 645577 2019-03-04 2018-09-30 21 4         25               25
680 680 CARTERSVILLE MEDICAL CENTER 960 JOE FRANK HARRIS PARKWAY CARTERSVILLE GA 30120 BARTOW (770) 387-8182 Acute Care Hospitals Voluntary non-profit - Private TRUE 34.1995441 -84.7932932 1 ROOFTOP 15 13 13015 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Outlying Bartow County https://data.medicare.gov/resource/xubh-q36u/row-w3nk-2vm4_5tut 110030 644712 2019-02-28 2018-09-30 98 21         119               119
930 930 SETON SMITHVILLE REGIONAL HOSPITAL 1201 HILL RD SMITHVILLE TX 78957 BASTROP (512) 237-3214 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.0039505 -97.1360218 1 ROOFTOP 21 48 48021 12420   Outlying Bastrop County https://data.medicare.gov/resource/xubh-q36u/row-d2dp~cvuc~gmre 450143 659733 2019-11-25 2019-06-30 8           8               8
619 619 BATES COUNTY MEMORIAL HOSPITAL 615 W NURSERY ST BUTLER MO 64730 BATES (660) 200-7000 Acute Care Hospitals Government - Local TRUE 38.2496110 -94.3433910 0   13 29 29013 28140 Kansas City-Overland Park-Kansas City, MO-KS Outlying Bates County https://data.medicare.gov/resource/xubh-q36u/row-y4pe~pb6c-52i8 260034 648060 2019-05-16 2018-12-31 44           44               44
795 795 BATH COMMUNITY HOSPITAL 106 PARK DRIVE- PO DRAWER Z HOT SPRINGS VA 24445 BATH (540) 839-7000 Critical Access Hospitals Voluntary non-profit - Private TRUE 37.9938900 -79.8309590 0   17 51 51017         https://data.medicare.gov/resource/xubh-q36u/row-36k3~dwrj~zvyd 491300 650420 2019-05-31 2018-12-31 14           14               14
258 258 BAXTER REGIONAL MEDICAL CENTER 624 HOSPITAL DRIVE MOUNTAIN HOME AR 72653 BAXTER (870) 508-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.3430670 -92.3959050 0   5 5 5005 34260   Central Baxter County https://data.medicare.gov/resource/xubh-q36u/row-pjhy~i9v2.r6ud 40027 650559 2019-05-31 2018-12-31 153 17         170 19 23       12   224
2261 2261 IZARD COUNTY MEDICAL CENTER, LLC 61 GRASSE STREET CALICO ROCK AR 72519 BAXTER (870) 297-2400 Critical Access Hospitals Proprietary TRUE 36.1263360 -92.1285870 0   65 5 5065         https://data.medicare.gov/resource/xubh-q36u/row-nm2c~hstr_uanu 41306 662150 2019-12-06 2019-06-30 25           25               25
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
269 269 GULF COAST REGIONAL MEDICAL CENTER 449 W 23RD ST PANAMA CITY FL 32405 BAY (850) 769-8341 Acute Care Hospitals Proprietary TRUE 30.1896820 -85.6661240 0   5 12 12005 37460   Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-7wyf_m6mi-z99k 100242 651510 2019-07-01 2019-01-31 170 20       28 222               222
757 757 MCLAREN BAY REGION 1900 COLUMBUS AVE BAY CITY MI 48708 BAY (989) 894-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 43.5893920 -83.8680890 0   17 26 26017 13020 Saginaw-Midland-Bay City, MI Central Bay County https://data.medicare.gov/resource/xubh-q36u/row-ribz~nm28_niqn 230041 644292 2019-02-21 2018-09-30 265 32         297 23 20           340
937 937 HOSPITAL HERMANOS MELENDEZ INC CARRETERA #2 KM 11 7 BAYAMON PR 960 BAYAMON (787) 620-8181 Acute Care Hospitals Proprietary TRUE 18.3967595 -66.1625647 1 ROOFTOP 21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-qeay~e2ib.ig5b 400032 649346 2019-05-29 2018-12-31 232 21         253               253
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
939 939 HOSPITAL UNIVERSITARIO DR RUIZ ARNAU LAUREL AVE SANTA JUANITA #100 BAYAMON PR 956 BAYAMON (787) 787-5151 Acute Care Hospitals Government - State TRUE 18.3672680 -66.1538110 1 ROOFTOP 21 72 72021 41980 San Juan-Carolina, PR Central Bayamón Municipio https://data.medicare.gov/resource/xubh-q36u/row-ea8w~5nt3-7vuk 400105 661647 2019-12-05 2019-06-30 102           102               102
5 5 SEYMOUR HOSPITAL 200 STADIUM DRIVE SEYMOUR TX 76380 BAYLOR (940) 889-5572 Acute Care Hospitals Government - Hospital District or Authority TRUE 33.5897880 -99.2476970 0   23 48 48023         https://data.medicare.gov/resource/xubh-q36u/row-q4ba-nup8_2wqc 450586 659539 2019-11-20 2019-06-30 27           27               27
318 318 HURON REGIONAL MEDICAL CENTER 172 FOURTH STREET SE HURON SD 57350 BEADLE (605) 353-6200 Critical Access Hospitals Voluntary non-profit - Private TRUE 44.3620350 -98.2107510 0   5 46 46005 26700   Central Beadle County https://data.medicare.gov/resource/xubh-q36u/row-zcx3~7b4g-9rji 431335 662256 2019-11-29 2019-06-30 19 6         25               25
352 352 BEAR LAKE MEMORIAL HOSPITAL 164 SOUTH FIFTH STREET MONTPELIER ID 83254 BEAR LAKE (208) 847-1630 Critical Access Hospitals Government - Local TRUE 42.3162420 -111.3008470 0   7 16 16007         https://data.medicare.gov/resource/xubh-q36u/row-mggi-9epd.588z 131316 647888 2019-05-16 2018-12-31 21           21       36   32   89
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
647 647 NH Beaufort 1 Pinckney Blvd Beaufort SC 29902 BEAUFORT (843) 228-5600 Acute Care - Department of Defense Department of Defense FALSE 32.3889769 -80.6825821 1 ROOFTOP 13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-uc4x_u34w~fpt9                                      
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
649 649 BEAUFORT COUNTY MEMORIAL HOSPITAL 955 RIBAUT RD BEAUFORT SC 29902 BEAUFORT (843) 522-5200 Acute Care Hospitals Government - Local TRUE 32.4172440 -80.6885460 0   13 45 45013 25940   Central Beaufort County https://data.medicare.gov/resource/xubh-q36u/row-simj~c9x8.yqtx 420067 644559 2019-02-25 2018-09-30 155 12         167 14 14           195
505 505 BEAUREGARD MEMORIAL HOSPITAL 600 S PINE STREET DERIDDER LA 70634 BEAUREGARD (337) 462-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 30.8419500 -93.2890560 0   11 22 22011 19760 DeRidder-Fort Polk South, LA Central Beauregard Parish https://data.medicare.gov/resource/xubh-q36u/row-wmc2_46c7-nnig 190050 646211 2019-04-05 2018-10-31 39 6       4 49               49
124 124 BEAVER VALLEY HOSPITAL 1109 NORTH 100 WEST BEAVER UT 84713 BEAVER (435) 438-7100 Critical Access Hospitals Government - State TRUE 38.2892580 -112.6432040 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-x2bw~6dhq.mh7x 461335 659078 2019-11-20 2019-06-30 25           25               25
125 125 MILFORD VALLEY MEMORIAL HOSPITAL 850 NORTH MAIN STREET MILFORD UT 84751 BEAVER (435) 387-2411 Critical Access Hospitals Government - Hospital District or Authority FALSE 38.4073080 -113.0095430 0   1 49 49001         https://data.medicare.gov/resource/xubh-q36u/row-iet4.f5zs.batz 461305 648782 2019-05-29 2018-12-31 5           5           18   23
381 381 BEAVER COUNTY MEMORIAL HOSPITAL 212 EAST 8TH STREET BEAVER OK 73932 BEAVER (580) 625-4551 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.8101950 -100.5164240 0   7 40 40007         https://data.medicare.gov/resource/xubh-q36u/row-97xz.ezcx-saem 371322 659862 2019-11-22 2019-06-30 24           24               24
384 384 HERITAGE VALLEY BEAVER 1000 DUTCH RIDGE ROAD BEAVER PA 15009 BEAVER (412) 728-7000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.7103450 -80.3243520 0   7 42 42007 38300 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Beaver County https://data.medicare.gov/resource/xubh-q36u/row-qcxm.vfmt_it7p 390036 661089 2019-12-02 2019-06-30 174 20         194 28             222
101 101 BARRETT HOSPITAL & HEALTHCARE 600 MT HWY 91 S DILLON MT 59725 BEAVERHEAD (406) 683-3000 Critical Access Hospitals Government - Hospital District or Authority TRUE 45.2006540 -112.6460030 0   1 30 30001         https://data.medicare.gov/resource/xubh-q36u/row-2tkn_v7av-d2ep 271318 662223 2019-11-27 2019-06-30 18           18               18
291 291 ESSENTIA HEALTH ST MARYS - DETROIT LAKES 1027 WASHINGTON AVE DETROIT LAKES MN 56501 BECKER (218) 847-0888 Acute Care Hospitals Voluntary non-profit - Church FALSE 46.8153070 -95.8454530 0   5 27 27005         https://data.medicare.gov/resource/xubh-q36u/row-my2b~zwif~njdr 240101 660605 2019-11-26 2019-06-30 28 8         36       96       132
460 460 GREAT PLAINS REGIONAL MEDICAL CENTER 1801 WEST 3RD STREET ELK CITY OK 73644 BECKHAM (580) 225-2511 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.4117210 -99.4256540 0   9 40 40009 21120   Central Beckham County https://data.medicare.gov/resource/xubh-q36u/row-ygr6~ifvk~u3j8 370019 660278 2019-11-27 2019-06-30 28 6         34 12 8           54
243 243 TENNOVA HEALTHCARE-SHELBYVILLE 2835 HWY 231 NORTH SHELBYVILLE TN 37160 BEDFORD (931) 685-5433 Acute Care Hospitals Proprietary TRUE 35.5632180 -86.4463720 0   3 47 47003 43180 Nashville-Davidson--Murfreesboro, TN Central Bedford County https://data.medicare.gov/resource/xubh-q36u/row-nnwj-ykm6~eviv 440137 654172 2019-09-04 2019-03-31 36 8         44               44
461 461 UPMC BEDFORD MEMORIAL 10455 LINCOLN HIGHWAY EVERETT PA 15537 BEDFORD (814) 623-6161 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.0247210 -78.4332550 0   9 42 42009         https://data.medicare.gov/resource/xubh-q36u/row-a7tx_6h63.ijq9 390117 659869 2019-11-26 2019-06-30 36 4         40               40
866 866 BEDFORD MEMORIAL HOSPITAL 1613 OAKWOOD STREET BEDFORD VA 24523 BEDFORD (434) 200-6366 Acute Care Hospitals Voluntary non-profit - Private TRUE 37.3515630 -79.5164150 0   19 51 51019 31340   Central Bedford County https://data.medicare.gov/resource/xubh-q36u/row-efrt-99vt~8tan 490088 650619 2019-06-03 2018-12-31 28 6         34       111       145
1041 1041 CHRISTUS SPOHN HOSPITAL BEEVILLE 1500 E HOUSTON HWY BEEVILLE TX 78102 BEE (361) 354-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 28.4083530 -97.7319250 0   25 48 48025 13300   Central Bee County https://data.medicare.gov/resource/xubh-q36u/row-i8xs~bawd_cyy5 450082 659895 2019-11-26 2019-06-30 32 8         40               40
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
605 605 MIDDLESBORO APPALACHIAN REGIONAL HEALTHCARE HOSPIT 3600 WEST CUMBERLAND AVENUE MIDDLESBORO KY 40965 BELL (606) 242-1100 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.6051990 -83.7400560 0   13 21 21013 33180   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-ddm7.jenh~wuwk 180020 660557 2019-11-27 2019-06-30 39 7         46               46
606 606 PINEVILLE COMMUNITY HEALTH CENTER, INC 850 RIVERVIEW AVENUE PINEVILLE KY 40977 BELL (606) 337-3051 Acute Care Hospitals Voluntary non-profit - Private TRUE 36.7630770 -83.7085740 0   13 21 21013 33180   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-fc9h_t8d9~pcu3 180021 651620 2019-07-15 2018-06-30 41           41 12             53
1105 1105 BAYLOR SCOTT & WHITE CLINIC - TEMPLE 2401 S 31ST ST TEMPLE TX 76508 BELL (254) 724-2111 Acute Care Hospitals Voluntary non-profit - Private TRUE 31.0786930 -97.3659380 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-pkyb~vug2_qrtf 450054 661257 2019-02-01 2018-08-31 472 70         610 24             634
1106 1106 SETON MEDICAL CENTER HARKER HEIGHTS 850 W CENTRAL TEXAS EXPRESSWAY HARKER HEIGHTS TX 76548 BELL (254) 953-8342 Acute Care Hospitals Proprietary TRUE 31.0742920 -97.6837070 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-qig4_ei54~8nwu 670080 654707 2019-09-27 2019-04-30 56 10         66               66
1107 1107 ADVENTHEALTH CENTRAL TEXAS 2201 S CLEAR CREEK ROAD KILLEEN TX 76542 BELL (254) 526-7523 Acute Care Hospitals Voluntary non-profit - Church TRUE 31.1133500 -97.7995190 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-d3a2-awra.pykq 450152 656365 2019-10-17 2018-09-30 194 10       4 208               208
1108 1108 Darnall AMC (FT Hood) 36000 Darnall Loop Fort Hood TX 76544 BELL (254) 288-8000 Acute Care - Department of Defense Department of Defense TRUE 31.1303370 -97.7751320 0   27 48 48027 28660   Central Bell County https://data.medicare.gov/resource/xubh-q36u/row-gncy-h9nz~ydxn                                      
640 640 EAST OHIO REGIONAL HOSPITAL 90 NORTH FOURTH STREET MARTINS FERRY OH 43935 BELMONT (740) 633-4205 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.0986440 -80.7208890 0   13 39 39013 48540   Central Belmont County https://data.medicare.gov/resource/xubh-q36u/row-h333-qu75_kcna 360080 649318 2019-06-03 2018-12-31 74 10         84       50       134
641 641 BARNESVILLE HOSPITAL ASSOCIATION, INC 639 WEST MAIN STREET BARNESVILLE OH 43713 BELMONT (740) 425-5101 Critical Access Hospitals Voluntary non-profit - Private TRUE 39.9920690 -81.1883940 0   13 39 39013 48540   Central Belmont County https://data.medicare.gov/resource/xubh-q36u/row-h85t.br3v-763v 361321 647575 2019-04-30 2018-12-31 20   5       25               25
360 360 SANFORD BEMIDJI MEDICAL CENTER 1300 ANNE ST NW BEMIDJI MN 56601 BELTRAMI (218) 751-5430 Acute Care Hospitals Voluntary non-profit - Private TRUE 47.5050090 -94.8981250 0   7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-uwkp_7ty3-835f 240100 649770 2019-05-23 2018-12-31 84 10         94 12 12   78       196
362 362 RED LAKE HOSPITAL A PO BOX 497 REDLAKE MN 56671 BELTRAMI (218) 679-3912 Acute Care Hospitals Government - Federal FALSE 47.8763460 -95.0169401 1 GEOMETRIC_CENTER 7 27 27007 13420   Central Beltrami County https://data.medicare.gov/resource/xubh-q36u/row-jefe.tmy8.7dit 240206 649909 2019-06-18 2018-09-30 23           23               23
731 731 DORMINY MEDICAL CENTER 200 PERRY HOUSE ROAD, BOX 1447 FITZGERALD GA 31750 BEN HILL (229) 424-7100 Acute Care Hospitals Government - Local TRUE 31.6979180 -83.2609750 0   17 13 13017 22340   Central Ben Hill County https://data.medicare.gov/resource/xubh-q36u/row-x5tq.yugi-ym8v 110073 658241 2019-01-02 2018-07-31 43 5         48 12             60
428 428 BENEWAH COMMUNITY HOSPITAL 229 SOUTH 7TH STREET ST MARIES ID 83861 BENEWAH (208) 245-5551 Critical Access Hospitals Government - Local TRUE 47.3146130 -116.5666780 0   9 16 16009         https://data.medicare.gov/resource/xubh-q36u/row-3wfv~5stn~5t7d 131317 652074 2019-05-24 2018-12-31 19           19               19
392 392 BENNETT COUNTY HOSPITAL AND NURSING HOME - CAH 102 MAJOR ALLEN POST OFFICE BOX 70D MARTIN SD 57551 BENNETT (605) 685-6622 Critical Access Hospitals Voluntary non-profit - Other TRUE 43.1691630 -101.7266636 1 RANGE_INTERPOLATED 7 46 46007         https://data.medicare.gov/resource/xubh-q36u/row-q2mg~bq2u~fi2w 431314 649823 2019-06-03 2018-12-31 14           14           48   62
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
223 223 GOOD SAMARITAN REGIONAL MEDICAL CENTER 3600 NW SAMARITAN DRIVE CORVALLIS OR 97330 BENTON (541) 768-5111 Acute Care Hospitals Voluntary non-profit - Private TRUE 44.6046240 -123.2511040 0   3 41 41003 18700 Portland-Vancouver-Salem, OR-WA Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-pcfe.3dmp~9puh 380014 650902 2019-05-28 2018-12-31 157 12         169 24             193
319 319 CAMDEN GENERAL HOSPITAL 175 HOSPITAL DRIVE CAMDEN TN 38320 BENTON (731) 584-0109 Critical Access Hospitals Government - Hospital District or Authority TRUE 36.0557800 -88.1075170 0   5 47 47005         https://data.medicare.gov/resource/xubh-q36u/row-rp5g~twzk~kf69 441316 660045 2019-12-03 2019-06-30 25           25               25
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
327 327 KADLEC REGIONAL MEDICAL CENTER 888 SWIFT BLVD RICHLAND WA 99352 BENTON (509) 946-4611 Acute Care Hospitals Voluntary non-profit - Private TRUE 46.2804620 -119.2811210 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-k3yx.t79z-wduq 500058 648786 2019-05-29 2018-12-31 201 30       27 258   12           270
328 328 TRIOS 900 SOUTH AUBURN STREET KENNEWICK WA 99336 BENTON (509) 586-6111 Acute Care Hospitals Government - Hospital District or Authority TRUE 46.1988750 -119.1184630 0   5 53 53005 28420   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-hs4k~gp5j~yv74 500053 651430 2019-06-03 2018-12-31 87 14       10 111               111
339 339 OZARKS COMMUNITY HOSPITAL OF GRAVETTE 1101 JACKSON STREET SW GRAVETTE AR 72736 BENTON (479) 787-5291 Critical Access Hospitals Proprietary TRUE 36.4085630 -94.4598700 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-snva.mem9_cs94 41331 651314 2019-05-30 2018-12-31 25           25               25
340 340 SILOAM SPRINGS REGIONAL HOSPITAL 603 NORTH PROGRESS AVENUE SILOAM SPRINGS AR 72761 BENTON (479) 524-4141 Acute Care Hospitals Voluntary non-profit - Other TRUE 36.1903770 -94.5096580 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-6neb~fx59-g35b 40001 653533 2019-08-30 2019-03-31 38 6         44               44
341 341 MERCY HOSPITAL NORTHWEST ARKANSAS 2710 SOUTH RIFE MEDICAL LANE ROGERS AR 72758 BENTON (479) 338-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.3095620 -94.1847090 0   7 5 5007 22220   Central Benton County https://data.medicare.gov/resource/xubh-q36u/row-3g3b-cs9n_qbhj 40010 660742 2019-12-04 2019-06-30 174 24         206               206
504 504 VIRGINIA GAY HOSPITAL 502 NORTH 9TH AVENUE VINTON IA 52349 BENTON (319) 472-6200 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1736740 -92.0133850 0   11 19 19011 16300 Cedar Rapids-Iowa City, IA Outlying Benton County https://data.medicare.gov/resource/xubh-q36u/row-9sfp.7tdh~i4z3 161349 660977 2019-12-02 2019-06-30 25           25           40   65
836 836 PAUL OLIVER MEMORIAL HOSPITAL 224 PARK AVENUE FRANKFORT MI 49635 BENZIE (231) 352-2200 Critical Access Hospitals Government - Local TRUE 44.6373760 -86.2429130 0   19 26 26019 45900   Outlying Benzie County https://data.medicare.gov/resource/xubh-q36u/row-cypk~xgkd.zsnp 231300 660598 2019-11-26 2019-06-30 8           8       36       44
210 210 HACKENSACK UNIVERSITY MEDICAL CENTER 30 PROSPECT AVE HACKENSACK NJ 7601 BERGEN (551) 996-2000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8840320 -74.0579540 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-3r63~g2k2_j8zj 310001 656108 2019-10-30 2018-12-31 599 35 13     40 687 24             711
211 211 HOLY NAME MEDICAL CENTER 718 TEANECK RD TEANECK NJ 7666 BERGEN (201) 833-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.8823770 -74.0086290 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-xnww.m9j5.svuu 310008 649047 2019-05-30 2018-12-31 265 19         284 23             307
212 212 BERGEN NEW BRIDGE MEDICAL CENTER 230 EAST RIDGEWOOD AVE PARAMUS NJ 7652 BERGEN (201) 967-4000 Acute Care Hospitals Government - Local TRUE 40.9586020 -74.0621510 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-uajf_w5ak.e5wh 310058 651020 2019-06-03 2018-12-31 118 9         127 319     574       1020
213 213 ENGLEWOOD HOSPITAL AND MEDICAL CENTER 350 ENGLE ST ENGLEWOOD NJ 7631 BERGEN (201) 894-3000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9028550 -73.9679930 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-veb2-ksdy_macn 310045 650180 2019-05-31 2018-12-31 238 26       11 275 14             289
214 214 VALLEY HOSPITAL 223 N VAN DIEN AVENUE RIDGEWOOD NJ 7450 BERGEN (201) 447-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 40.9832040 -74.1017610 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-dcmv-g3rd.mciv 310012 648551 2019-05-23 2018-12-31 327 14 22       363               363
215 215 HACKENSACK MERIDIAN HEALTH PASCACK VALLEY MEDICAL 250 OLD HOOK ROAD WESTWOOD NJ 7675 BERGEN (201) 383-1035 Acute Care Hospitals Proprietary TRUE 40.9836580 -74.0141950 0   3 34 34003 35620 New York-Newark, NY-NJ-CT-PA Central Bergen County https://data.medicare.gov/resource/xubh-q36u/row-kwcd-72qg_ygd9 310130 660416 2019-11-25 2019-06-30 64 9         78               78
250 250 BERKELEY MEDICAL CENTER 2500 HOSPITAL DRIVE MARTINSBURG WV 25401 BERKELEY (304) 264-1000 Acute Care Hospitals Voluntary non-profit - Private TRUE 39.4772540 -77.9806190 0   3 54 54003 25180 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Berkeley County https://data.medicare.gov/resource/xubh-q36u/row-faju-yvek_2eqd 510008 648871 2019-05-21 2018-12-31 122 20         146 23             169
531 531 ST JOSEPH MEDICAL CENTER 2500 BERNVILLE ROAD READING PA 19605 BERKS (610) 378-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.3767170 -75.9776610 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-6esh~ksbq.jpve 390096 661397 2019-11-29 2019-06-30 144 30       6 180               180
532 532 READING HOSPITAL 420 S 5TH AVENUE WEST READING PA 19611 BERKS (610) 988-8000 Acute Care Hospitals Voluntary non-profit - Other TRUE 40.3298630 -75.9480590 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-rf2n_5umm~j8bk 390044 659867 2019-11-27 2019-06-30 491 20     21 30 562 50 62   50       724
533 533 SURGICAL INSTITUTE OF READING 2752 CENTURY BOULEVARD WYOMISSING PA 19610 BERKS (717) 999-9999 Acute Care Hospitals Proprietary FALSE 40.3579510 -75.9875770 0   11 42 42011 39740 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Berks County https://data.medicare.gov/resource/xubh-q36u/row-3aqm~vs6z.7ify 390316 651482 2019-06-25 2018-12-31 15           15               15
182 182 FAIRVIEW HOSPITAL 29 LEWIS AVENUE GREAT BARRINGTON MA 1230 BERKSHIRE (413) 528-0790 Critical Access Hospitals Voluntary non-profit - Private TRUE 42.1919820 -73.3725230 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-6zsa~q4z7~nrdp 221302 645425 2019-03-01 2018-09-30 20 4         24               24
183 183 BERKSHIRE MEDICAL CENTER INC - 1 725 NORTH STREET PITTSFIELD MA 1201 BERKSHIRE (413) 447-2000 Acute Care Hospitals Voluntary non-profit - Other TRUE 42.4587480 -73.2490040 0   3 25 25003 38340   Central Berkshire County https://data.medicare.gov/resource/xubh-q36u/row-58b2-r4te.ddyn 220046 661336 2019-12-02 2018-09-30 201 20         221 40 14           275
107 107 LOVELACE WOMEN'S HOSPITAL 4701 MONTGOMERY BOULEVARD NE ALBUQUERQUE NM 87109 BERNALILLO (505) 727-7805 Acute Care Hospitals Government - State TRUE 35.1310050 -106.5910370 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-fycu~sc7u.8im7 320017 655223 2019-10-17 2019-04-30 112 8       42 162               162
108 108 LOVELACE MEDICAL CENTER 601 DR MARTIN LUTHER KING JR AVE NE ALBUQUERQUE NM 87102 BERNALILLO (505) 727-8000 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0856220 -106.6397650 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-kci4.56nf~rfu7 320009 652759 2019-07-29 2019-02-28 245 48         293               293
109 109 LOVELACE WESTSIDE HOSPITAL 10501 GOLF COURSE ROAD NW ALBUQUERQUE NM 87114 BERNALILLO (505) 727-2001 Acute Care Hospitals Proprietary TRUE 35.2075080 -106.6759740 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-t6an-qbnd.nby8 320074 651222 2019-06-28 2019-01-31 62 8         70               70
110 110 UNM HOSPITAL 2211 LOMAS BOULEVARD NE ALBUQUERQUE NM 87106 BERNALILLO (505) 272-2111 Acute Care Hospitals Voluntary non-profit - Other TRUE 35.0874830 -106.6181480 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-ntcm.qi4a~h9yr 320001 661059 2019-11-26 2019-06-30 345           473 82             555
111 111 PRESBYTERIAN HOSPITAL 1100 CENTRAL AVENUE SE ALBUQUERQUE NM 87106 BERNALILLO (505) 724-8386 Acute Care Hospitals Voluntary non-profit - Private TRUE 35.0822950 -106.6345300 0   1 35 35001 10740 Albuquerque-Santa Fe-Las Vegas, NM Central Bernalillo County https://data.medicare.gov/resource/xubh-q36u/row-6ve3~533u~8w78 320021 652598 2019-08-14 2018-12-31 538 47 21       671 45         10   726
4 4 SGMC BERRIEN CAMPUS 1221 E MCPHERSON AVENUE NASHVILLE GA 31639 BERRIEN (229) 543-7100 Acute Care Hospitals Government - Hospital District or Authority TRUE 31.2036290 -83.2383370 0   19 13 13019         https://data.medicare.gov/resource/xubh-q36u/row-nuhh.ufkh.cshr 110234 644717 2019-03-01 2018-09-30 51           51 12             63
907 907 LAKELAND HOSPITAL WATERVLIET 400 MEDICAL PARK DR WATERVLIET MI 49098 BERRIEN (269) 463-3111 Acute Care Hospitals Voluntary non-profit - Private FALSE 42.1848660 -86.2507600 0   21 26 26021 35660 South Bend-Elkhart-Mishawaka, IN-MI Central Berrien County https://data.medicare.gov/resource/xubh-q36u/row-7efk~hcgi~rsxw 230078 645339 2019-02-28 2018-09-30 26           26   18           44
908 908 LAKELAND HOSPITAL, ST JOSEPH 1234 NAPIER AVENUE ST JOSEPH MI 49085 BERRIEN (269) 983-8300 Acute Care Hospitals Voluntary non-profit - Private TRUE 42.0897420 -86.4771940 0   21 26 26021 35660 South Bend-Elkhart-Mishawaka, IN-MI Central Berrien County https://data.medicare.gov/resource/xubh-q36u/row-vr3m_ja72-rybg 230021 645427 2019-03-01 2018-09-30 244 20         264 26             290
704 704 VIDANT BERTIE HOSPITAL 1403 SOUTH KINGS STREET WINDSOR NC 27983 BERTIE (252) 794-6600 Critical Access Hospitals Voluntary non-profit - Private TRUE 35.9893550 -76.9281830 0   15 37 37015         https://data.medicare.gov/resource/xubh-q36u/row-pwdr-dt5d-exsb 341304 644156 2019-02-28 2018-09-30 6           6               6
1885 1885 YUKON KUSKOKWIM DELTA REG HOSPITAL PO BOX 287 BETHEL AK 99559 BETHEL (907) 543-6300 Acute Care Hospitals Tribal TRUE 60.7922222 -161.7558334 1 GEOMETRIC_CENTER 50 2 2050         https://data.medicare.gov/resource/xubh-q36u/row-7gdx-n37w_5vx9 20018 651309 2019-07-02 2018-09-30 34           34               34
1176 1176 NIX HEALTH CARE SYSTEM 414 NAVARRO, SUITE 600 SAN ANTONIO TX 78205 BEXAR (210) 271-2188 Acute Care Hospitals Proprietary TRUE 29.4255770 -98.4897180 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-6ir7_mgdd.hab9 450130 648576 2019-05-30 2018-12-31 189 12         201 33 18           252
1177 1177 METHODIST HOSPITAL 7700 FLOYD CURL DR SAN ANTONIO TX 78229 BEXAR (210) 575-4000 Acute Care Hospitals Proprietary TRUE 29.5068400 -98.5729760 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-xgb9_6gfp~4v63 450388 659736 2019-11-22 2019-06-30 1223 207       110 1560 10 67           1637
1178 1178 METHODIST STONE OAK HOSPITAL 1139 E SONTERRA BLVD, STE 535 SAN ANTONIO TX 78258 BEXAR (210) 638-2100 Acute Care Hospitals Proprietary TRUE 29.6144940 -98.4754590 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-32ag-t8fj-9ybq 670055 652855 2019-07-31 2019-02-28 175 28       24 227   15           242
1179 1179 BAPTIST MEDICAL CENTER 111 DALLAS STREET SAN ANTONIO TX 78205 BEXAR (210) 297-8256 Acute Care Hospitals Proprietary TRUE 29.4328770 -98.4927730 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-9jbx_v3az~nwzz 450058 660466 2019-11-26 2019-06-30 1166 151         1457 38 72           1567
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
1181 1181 TEXAS CENTER FOR INFECTIOUS DISEASE 2303 SE MILITARY DR P O BOX 23340 SAN ANTONIO TX 78223 BEXAR (210) 534-8857 Acute Care Hospitals Government - State FALSE 29.3519300 -98.4583770 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-suha~2mc2-p7yc                                      
1182 1182 SOUTH TEXAS SPINE AND SURGICAL HOSPITAL 18600 NORTH HARDY OAK BLVD SAN ANTONIO TX 78258 BEXAR (210) 404-0800 Acute Care Hospitals Government - Hospital District or Authority TRUE 29.6132070 -98.4784930 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-hrzf~ehe3.nfy2 450856 648491 2019-05-30 2018-12-31 30           30               30

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