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

757 rows where hospital_ownership = "Proprietary" sorted by lng

View and edit SQL

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

hospital_ownership

  • Proprietary · 757
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
2068 WESTERN PLAINS MEDICAL COMPLEX 3001 AVENUE A DODGE CITY KS 67801 FORD (620) 225-8400 Acute Care Hospitals Proprietary TRUE 37.7854870 -100.0149750 0   57 20 20057 19980   Central Ford County https://data.medicare.gov/resource/xubh-q36u/row-w4ff.nykp.gqd4 170175 652748 2019-08-01 2019-02-28 50 10         60               60
2871 COLLINGSWORTH GENERAL HOSPITAL 1013 15TH ST WELLINGTON TX 79095 COLLINGSWORTH (806) 447-2521 Critical Access Hospitals Proprietary TRUE 34.8491100 -100.2120150 0   87 48 48087         https://data.medicare.gov/resource/xubh-q36u/row-iy62.m34i.p94f 451355 643660 2019-02-27 2018-09-30 15           15               15
4576 FORT DUNCAN MEDICAL CENTER 3333 N FOSTER MALDONADO BLVD EAGLE PASS TX 78852 MAVERICK (830) 773-5321 Acute Care Hospitals Proprietary TRUE 28.7114180 -100.4541050 0   323 48 48323 20580   Central Maverick County https://data.medicare.gov/resource/xubh-q36u/row-zqqu-eqhh-2cw6 450092 648764 2019-05-28 2018-12-31 76 10         86   15           101
4665 SAN ANGELO COMMUNITY MEDICAL CENTER 3501 KNICKERBOCKER ROAD SAN ANGELO TX 76904 TOM GREEN (325) 949-9511 Acute Care Hospitals Proprietary TRUE 31.4200760 -100.4701320 0   451 48 48451 41660   Central Tom Green County https://data.medicare.gov/resource/xubh-q36u/row-m9tt.p6fs.emne 450340 657988 2019-02-01 2018-08-31 113 12         131               131
4621 SCHLEICHER COUNTY MEDICAL CENTER 102 NORTH US HIGHWAY 277 ELDORADO TX 76936 SCHLEICHER (325) 853-2507 Critical Access Hospitals Proprietary TRUE 30.8698690 -100.5903930 0   413 48 48413         https://data.medicare.gov/resource/xubh-q36u/row-ukk5-7d2r~gvs8 451304 649143 2019-05-21 2018-12-31 14           14               14
4682 VAL VERDE REGIONAL MEDICAL CENTER 801 BEDELL AVE DEL RIO TX 78840 VAL VERDE (830) 775-8566 Acute Care Hospitals Proprietary TRUE 29.3744250 -100.8930340 0   465 48 48465 19620   Central Val Verde County https://data.medicare.gov/resource/xubh-q36u/row-vvbk~jkwv.nw4c 450154 660322 2019-12-03 2019-06-30 40 7         47           1   48
2351 BOB WILSON MEMORIAL GRANT COUNTY HOSPITAL 415 N MAIN STREET ULYSSES KS 67880 GRANT (620) 356-1266 Acute Care Hospitals Proprietary TRUE 37.5839920 -101.3580130 0   67 20 20067         https://data.medicare.gov/resource/xubh-q36u/row-8mti_jcxr_myzi 170110 660091 2019-11-26 2019-06-30 26           26               26
4501 GOLDEN PLAINS COMMUNITY HOSPITAL 100 MEDICAL DRIVE BORGER TX 79007 HUTCHINSON (806) 273-1100 Critical Access Hospitals Proprietary TRUE 35.6538340 -101.4090410 0   233 48 48233 14420 Amarillo-Borger, TX Central Hutchinson County https://data.medicare.gov/resource/xubh-q36u/row-rtyt.xqrr~9rdj 451369 660153 2019-12-05 2018-12-31 21 4         25               25
4497 SCENIC MOUNTAIN MEDICAL CENTER, A STEWARD FAMILY H 1601 W 11TH PLACE BIG SPRING TX 79720 HOWARD (432) 263-1211 Acute Care Hospitals Proprietary TRUE 32.2400150 -101.4924120 0   227 48 48227 13700   Central Howard County https://data.medicare.gov/resource/xubh-q36u/row-qsv2-q6dr_r7bx 450653 653861 2019-08-27 2018-12-31 67 8         75 17             92
4608 QUAIL CREEK SURGICAL HOSPITAL 6819 PLUM CREEK AMARILLO TX 79124 POTTER (806) 354-6100 Acute Care Hospitals Proprietary TRUE 35.2106750 -101.9135680 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-3fht_yhjz.yec5 450875 648767 2019-05-24 2018-12-31 32           32               32
4559 LUBBOCK HEART HOSPITAL LP 4810 NORTH LOOP 289 LUBBOCK TX 79416 LUBBOCK (806) 687-7777 Acute Care Hospitals Proprietary TRUE 33.6025270 -101.9142870 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-h2tr.sjsi-mbq3 450876 650210 2019-05-31 2018-12-31 58 15         73               73
4609 BAPTIST ST ANTHONY'S HOSPITAL 1600 WALLACE BLVD AMARILLO TX 79106 POTTER (806) 212-2000 Acute Care Hospitals Proprietary TRUE 35.1951150 -101.9188500 0   375 48 48375 11100 Amarillo-Borger, TX Central Potter County https://data.medicare.gov/resource/xubh-q36u/row-4rbc-ngk8.tb7q 450231 651243 2019-06-24 2018-12-31 282   48       354   24           378
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
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
1030 LEA REGIONAL MEDICAL CENTER 5419 N LOVINGTON HIGHWAY HOBBS NM 88240 LEA (575) 492-5000 Acute Care Hospitals Proprietary TRUE 32.7659880 -103.1860340 0   25 35 35025 26020   Central Lea County https://data.medicare.gov/resource/xubh-q36u/row-86mj-st3t_222u 320065 649297 2019-05-30 2018-12-31 53 8         61 15     16       92
3291 BLACK HILLS SURGICAL HOSPITAL LLP 216 ANAMARIA DR RAPID CITY SD 57703 PENNINGTON (605) 721-4700 Acute Care Hospitals Proprietary FALSE 44.0460350 -103.2229120 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-g4ad-2arx~xwzj 430091 650609 2019-05-28 2018-12-31 26           26               26
3290 SAME DAY SURGERY CENTER LLC 651 CATHEDRAL DRIVE RAPID CITY SD 57701 PENNINGTON (605) 755-9900 Acute Care Hospitals Proprietary FALSE 44.0591900 -103.2291020 0   103 46 46103 39660 Rapid City-Spearfish, SD Central Pennington County https://data.medicare.gov/resource/xubh-q36u/row-9hcp~bs9i-drqz 430093 658957 2019-11-18 2019-06-30 6           6               6
1712 BIG BEND REGIONAL MEDICAL CENTER 2600 HIGHWAY 118 NORTH ALPINE TX 79830 BREWSTER (432) 837-3447 Critical Access Hospitals Proprietary TRUE 30.3838110 -103.6721400 0   43 48 48043         https://data.medicare.gov/resource/xubh-q36u/row-snt8.6tvq~cxi3 451378 654056 2019-08-28 2018-09-30 22 3         25               25
700 CARLSBAD MEDICAL CENTER 2430 WEST PIERCE STREET CARLSBAD NM 88220 EDDY (575) 887-4570 Acute Care Hospitals Proprietary FALSE 32.4418400 -104.2586420 0   15 35 35015 16100   Central Eddy County https://data.medicare.gov/resource/xubh-q36u/row-5km2_nhcx~29i4 320063 655571 2019-02-27 2018-08-31 84 12         96   10   15       121
301 EASTERN NEW MEXICO MEDICAL CENTER 405 W COUNTRY CLUB ROAD ROSWELL NM 88201 CHAVES (575) 624-8722 Acute Care Hospitals Proprietary TRUE 33.4233000 -104.5274050 0   5 35 35005 40740   Central Chaves County https://data.medicare.gov/resource/xubh-q36u/row-ddda_ex4p_75h9 320006 656469 2019-11-01 2019-05-31 142 20         162               162
3406 CULBERSON HOSPITAL EISENHOWER ROAD AND FM 2185 VAN HORN TX 79855 CULBERSON (432) 283-2760 Critical Access Hospitals Proprietary FALSE 31.0496690 -104.8283880 0   109 48 48109         https://data.medicare.gov/resource/xubh-q36u/row-g73p-emdj_vjx2 451338 653287 2019-08-29 2019-03-31 14           14               14
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
1205 ROSE MEDICAL CENTER 4567 E 9TH AVE DENVER CO 80220 DENVER (303) 320-2121 Acute Care Hospitals Proprietary TRUE 39.7310760 -104.9340110 0   31 8 8031 19740 Denver-Aurora, CO Central Denver County https://data.medicare.gov/resource/xubh-q36u/row-d89y.4k32_5asy 60032 649400 2019-05-24 2018-12-31 167 35       24 226               226
261 SWEDISH MEDICAL CENTER 501 E HAMPDEN AVE ENGLEWOOD CO 80113 ARAPAHOE (303) 788-5000 Acute Care Hospitals Proprietary TRUE 39.6531360 -104.9817100 0   5 8 8005 19740 Denver-Aurora, CO Central Arapahoe County https://data.medicare.gov/resource/xubh-q36u/row-3yvr.y5p2.2bay 60034 643574 2019-02-26 2018-09-30 281 58       17 356   16           372
665 UCHEALTH BROOMFIELD HOSPITAL 11820 DESTINATION DRIVE BROOMFIELD CO 80021 JEFFERSON (303) 460-6000 Acute Care Hospitals Proprietary TRUE 39.9105000 -105.0932070 0   14 8 8014 19740 Denver-Aurora, CO Central Broomfield County https://data.medicare.gov/resource/xubh-q36u/row-dvb6-rzzd_er2t 60129 661295 2019-11-26 2019-06-30 22           22               22
2131 ORTHOCOLORADO HOSPITAL AT ST ANTHONY MED CAMPUS 11650 WEST 2ND PLACE LAKEWOOD CO 80228 JEFFERSON (720) 321-5000 Acute Care Hospitals Proprietary TRUE 39.7179520 -105.1284410 0   59 8 8059 19740 Denver-Aurora, CO Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-b3pw~3vk6_q65v 60124 659765 2019-11-26 2019-06-30 48           48               48
3933 THE HOSPITALS OF PROVIDENCE HORIZON CITY CAMPUS 13600 HORIZON STREET, SUITE 100 HORIZON CITY TX 79928 EL PASO (915) 407-7878 Acute Care Hospitals Proprietary TRUE 31.6827230 -106.2073480 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-m5db~xjiy~dvv3 670124 649391 2019-05-30 2018-12-31 9           9               9
3930 THE HOSPITALS OF PROVIDENCE EAST CAMPUS 3280 JOE BATTLE BLVD EL PASO TX 79938 EL PASO (915) 856-7349 Acute Care Hospitals Proprietary TRUE 31.7904350 -106.2676440 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-5s8k_vnib_7trn 670047 648514 2019-05-31 2018-12-31 146 24       12 182               182
3934 FOUNDATION SURGICAL HOSPITAL OF EL PASO 1416 GEORGE DIETER EL PASO TX 79936 EL PASO (915) 598-4240 Acute Care Hospitals Proprietary TRUE 31.7349850 -106.3015780 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-g287~fiuj-x8p5 450877 649675 2019-06-14 2018-12-31 40           40               40
1121 LOS ALAMOS MEDICAL CENTER 3917 WEST ROAD LOS ALAMOS NM 87544 LOS ALAMOS (505) 662-4201 Acute Care Hospitals Proprietary TRUE 35.8821650 -106.3197650 0   28 35 35028 31060 Albuquerque-Santa Fe-Las Vegas, NM Central Los Alamos County https://data.medicare.gov/resource/xubh-q36u/row-xbyr.qb4x-n5ph 320033 648013 2019-05-21 2018-12-31 41 6         47               47
3926 SIERRA MEDICAL CENTER 1625 MEDICAL CENTER DR EL PASO TX 79902 EL PASO (915) 747-4000 Acute Care Hospitals Proprietary TRUE 31.7786700 -106.4796500 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-af3f.cjxd.pdpu 450668 655844 2019-10-28 2019-05-31 196 23 7     1 234   24           258
3928 LAS PALMAS MEDICAL CENTER 1801 NORTH OREGON STREET EL PASO TX 79902 EL PASO (915) 521-1200 Acute Care Hospitals Proprietary TRUE 31.7704830 -106.4987530 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-ay4n-jgmd_mzpr 450107 662079 2019-08-29 2018-07-31 377 64       55 496   63           559
3929 THE HOSPITALS OF PROVIDENCE MEMORIAL CAMPUS 2001 N OREGON ST EL PASO TX 79902 EL PASO (915) 577-6011 Acute Care Hospitals Proprietary TRUE 31.7711610 -106.4993450 0   141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-mwx3.k55z_dt4b 450002 655841 2019-10-28 2019-05-31 238 20       34 308 12             320
3925 THE HOSPITALS OF PROVIDENCE TRANSMOUNTAIN CAMPUS 2000 TRANSMOUNTAIN RD EL PASO TX 79911 EL PASO (915) 877-8136 Acute Care Hospitals Proprietary TRUE 31.9044828 -106.5650394 1 ROOFTOP 141 48 48141 21340 El Paso-Las Cruces, TX-NM Central El Paso County https://data.medicare.gov/resource/xubh-q36u/row-8cqi.sqna_eif8 670120 649983 2019-05-31 2018-12-31 94 12         106               106
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
635 MOUNTAIN VIEW REGIONAL MEDICAL CENTER 4311 EAST LOHMAN AVENUE LAS CRUCES NM 88011 DONA ANA (575) 556-7610 Acute Care Hospitals Proprietary TRUE 32.3226390 -106.7282970 0   13 35 35013 29740 El Paso-Las Cruces, TX-NM Central Doña Ana County https://data.medicare.gov/resource/xubh-q36u/row-6m6j-xb3y-q4ig 320085 654343 2019-08-30 2019-03-31 145 23         180               180
634 MEMORIAL MEDICAL CENTER 2450 SOUTH TELSHOR BLVD LAS CRUCES NM 88011 DONA ANA (575) 522-8641 Acute Care Hospitals Proprietary TRUE 32.2919930 -106.7350180 0   13 35 35013 29740 El Paso-Las Cruces, TX-NM Central Doña Ana County https://data.medicare.gov/resource/xubh-q36u/row-ecy9~459r.3ez3 320018 646297 2019-03-01 2018-09-30 171 28         199               199
1733 SOCORRO GENERAL HOSPITAL 1202 HIGHWAY 60 WEST SOCORRO NM 87801 SOCORRO (575) 835-1140 Critical Access Hospitals Proprietary TRUE 34.0387210 -106.9120140 0   53 35 35053         https://data.medicare.gov/resource/xubh-q36u/row-93zp~dbrk.vq66 321301 651646 2019-06-27 2018-12-31 24           24               24
1154 MIMBRES MEMORIAL HOSPITAL 900 W ASH DEMING NM 88031 LUNA (575) 546-5803 Critical Access Hospitals Proprietary TRUE 32.2603723 -107.7678531 1 ROOFTOP 29 35 35029 19700   Central Luna County https://data.medicare.gov/resource/xubh-q36u/row-vtah.tqch.7v58 321309 653912 2019-08-27 2018-12-31 19 6         25               25
662 SAGEWEST HEALTH CARE 2100 W SUNSET DR RIVERTON WY 82501 FREMONT (307) 856-4161 Acute Care Hospitals Proprietary TRUE 43.0336670 -108.4186540 0   13 56 56013 40180   Central Fremont County https://data.medicare.gov/resource/xubh-q36u/row-8cgp~ktku_un2q 530008 652129 2019-06-03 2018-12-31 121 12         133 13 8           154
1578 ASPEN MOUNTAIN MEDICAL CENTER 4401 COLLEGE DRIVE ROCK SPRINGS WY 82901 SWEETWATER (307) 448-2758 Acute Care Hospitals Proprietary FALSE 41.6031870 -109.2479170 0   37 56 56037 40540   Central Sweetwater County https://data.medicare.gov/resource/xubh-q36u/row-x9bs.ynhd_upz4 530035 651148 2018-05-29 2017-12-31                              
1820 ASHLEY REGIONAL MEDICAL CENTER 150 WEST 100 NORTH VERNAL UT 84078 UINTAH (435) 789-3342 Acute Care Hospitals Proprietary TRUE 40.4577900 -109.5304640 0   47 49 49047 46860   Central Uintah County https://data.medicare.gov/resource/xubh-q36u/row-ydws.ihn5-urcm 460030 651729 2019-07-03 2019-01-31 35 4         39               39
394 CASTLEVIEW HOSPITAL 300 NORTH HOSPITAL DRIVE PRICE UT 84501 CARBON (435) 637-4800 Acute Care Hospitals Proprietary TRUE 39.6054020 -110.8319110 0   7 49 49007 39220   Central Carbon County https://data.medicare.gov/resource/xubh-q36u/row-z6mk.zxuw_qeet 460011 651250 2019-06-03 2018-12-31 33 6         39               39
802 ORO VALLEY HOSPITAL 1551 EAST TANGERINE ROAD ORO VALLEY AZ 85755 PIMA (520) 901-3549 Acute Care Hospitals Proprietary TRUE 32.4271830 -110.9495400 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-mmb4.ma8p-hv7h 30114 644207 2019-02-27 2018-09-30 75 36         111 17 18           146
941 HOLY CROSS HOSPITAL 1171 WEST TARGET RANGE ROAD NOGALES AZ 85621 SANTA CRUZ (520) 285-3000 Critical Access Hospitals Proprietary TRUE 31.3411180 -110.9587340 0   23 4 4023 35700 Tucson-Nogales, AZ Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-datt~k3n6_g682 31313 644092 2019-02-28 2018-09-30 25           25               25
1679 EVANSTON REGIONAL HOSPITAL 190 ARROWHEAD DR EVANSTON WY 82930 UINTA (307) 789-3636 Acute Care Hospitals Proprietary TRUE 41.2422140 -110.9913360 0   41 56 56041 21740   Central Uinta County https://data.medicare.gov/resource/xubh-q36u/row-7bqu_vhhd.zycd 530032 654952 2019-10-01 2019-04-30 26 6         32               32
804 SANTA CRUZ VALLEY REGIONAL HOSPITAL 4455 SOUTH I-19 FRONTAGE ROAD GREEN VALLEY AZ 85614 PIMA (520) 393-4700 Acute Care Hospitals Proprietary TRUE 31.8079430 -111.0109660 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-td2s-wa4r_529q 30137 650635 2019-05-28 2018-12-31 43 6         49               49
803 NORTHWEST MEDICAL CENTER 6200 NORTH LA CHOLLA BOULEVARD TUCSON AZ 85741 PIMA (520) 469-8100 Acute Care Hospitals Proprietary TRUE 32.3195810 -111.0120540 0   19 4 4019 46060 Tucson-Nogales, AZ Central Pima County https://data.medicare.gov/resource/xubh-q36u/row-yv8p.eeec-pmxw 30085 646415 2019-03-28 2018-09-30 231 35         281   13           294
620 GREAT FALLS CLINIC HOSPITAL 3010 15TH AVENUE SOUTH GREAT FALLS MT 59405 CASCADE (406) 216-8000 Acute Care Hospitals Proprietary TRUE 47.4877370 -111.2545610 0   13 30 30013 24500   Central Cascade County https://data.medicare.gov/resource/xubh-q36u/row-zzvw_fvcf~g44t 270086 651217 2019-06-03 2018-12-31 20           20               20
1713 PARK CITY HOSPITAL 900 ROUND VALLEY DRIVE PARK CITY UT 84060 SUMMIT (435) 658-6700 Acute Care Hospitals Proprietary TRUE 40.6876970 -111.4689520 0   43 49 49043 44920 Salt Lake City-Provo-Orem, UT Central Summit County https://data.medicare.gov/resource/xubh-q36u/row-ecxv.jm7a~8gnk 460057 652113 2019-05-30 2018-12-31 33 4         37               37
570 MOUNTAIN VISTA MEDICAL CENTER, LP 1301 SOUTH CRISMON ROAD MESA AZ 85209 MARICOPA (480) 358-6100 Acute Care Hospitals Proprietary TRUE 33.3911000 -111.6153290 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-aus8~8k4g-9a4c 30121 659181 2019-11-21 2019-06-30 112 30         142 20             162
1878 TIMPANOGOS REGIONAL HOSPITAL 750 WEST 800 NORTH OREM UT 84057 UTAH (801) 714-6800 Acute Care Hospitals Proprietary TRUE 40.3121730 -111.7149900 0   49 49 49049 39340 Salt Lake City-Provo-Orem, UT Central Utah County https://data.medicare.gov/resource/xubh-q36u/row-gve8_aynp_383h 460052 648781 2019-05-28 2018-12-31 68 20       29 117               117
1880 MOUNTAIN VIEW HOSPITAL 1000 EAST 100 NORTH PAYSON UT 84651 UTAH (801) 465-7100 Acute Care Hospitals Proprietary TRUE 40.0446330 -111.7152570 0   49 49 49049 39340 Salt Lake City-Provo-Orem, UT Central Utah County https://data.medicare.gov/resource/xubh-q36u/row-gwva_dch9_3jcr 460013 657556 2019-01-29 2018-08-31 100 12       12 124               124
1621 GUNNISON VALLEY HOSPITAL 64 EAST 100 NORTH GUNNISON UT 84634 SANPETE (435) 528-7246 Critical Access Hospitals Proprietary TRUE 39.1566610 -111.8170140 0   39 49 49039         https://data.medicare.gov/resource/xubh-q36u/row-rqkf~i25u_knq8 461306 659077 2019-11-20 2019-06-30 25           25               25
323 CACHE VALLEY HOSPITAL 2380 NORTH 400 EAST NORTH LOGAN UT 84341 CACHE (435) 713-9580 Acute Care Hospitals Proprietary TRUE 41.7757140 -111.8230920 0   5 49 49005 30860   Central Cache County https://data.medicare.gov/resource/xubh-q36u/row-quy7.rbde-cdcc 460054 653289 2019-08-22 2019-03-31 28           28               28
560 HACIENDA CHILDREN'S HOSPITAL, INC. 610 WEST JEROME AVENUE MESA AZ 85210 MARICOPA (602) 243-4231 Childrens Proprietary FALSE 33.3811280 -111.8448920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-r4wv.uiyn_d6cn 33303 654954 2018-11-26 2018-07-31                              
1435 ST MARK'S HOSPITAL 1200 EAST 3900 SOUTH SALT LAKE CITY UT 84124 SALT LAKE (801) 268-7700 Acute Care Hospitals Proprietary TRUE 40.6870620 -111.8574460 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-svew-g43x_f7xn 460047 662450 2019-12-24 2019-06-30 183 18       32 233 16 14           263
1437 SALT LAKE REGIONAL MEDICAL CENTER 1050 EAST SOUTH TEMPLE SALT LAKE CITY UT 84102 SALT LAKE (801) 350-4111 Acute Care Hospitals Proprietary TRUE 40.7693480 -111.8611750 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-4ivx_nzga-ke3c 460003 658871 2019-01-29 2018-08-31 87 20         107 20 16           143
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
556 ARIZONA SPECIALTY HOSPITAL 2905 WEST WARNER ROAD, SUITE 1 CHANDLER AZ 85224 MARICOPA (480) 603-9000 Acute Care Hospitals Proprietary FALSE 33.3348400 -111.8911330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-z5xq-7gkm.mjtq 30112 649698 2019-05-22 2018-12-31 24           24               24
1439 LONE PEAK HOSPITAL 11925 SOUTH STATE STREET DRAPER UT 84020 SALT LAKE (801) 545-8000 Acute Care Hospitals Proprietary TRUE 40.5352380 -111.8914640 0   35 49 49035 41620 Salt Lake City-Provo-Orem, UT Central Salt Lake County https://data.medicare.gov/resource/xubh-q36u/row-3yfr.y4qy.386x 460060 662283 2019-11-27 2019-06-30 26 4         30               30
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 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
2089 OGDEN REGIONAL MEDICAL CENTER 5475 SOUTH 500 EAST OGDEN UT 84405 WEBER (801) 479-2111 Acute Care Hospitals Proprietary TRUE 41.1635020 -111.9686200 0   57 49 49057 36260 Salt Lake City-Provo-Orem, UT Central Weber County https://data.medicare.gov/resource/xubh-q36u/row-5jqt-h3ke-8iym 460005 656017 2019-10-31 2019-05-31 139 14       17 170           12   182
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
538 DAVIS HOSPITAL AND MEDICAL CENTER 1600 WEST ANTELOPE DRIVE LAYTON UT 84041 DAVIS (801) 807-7001 Acute Care Hospitals Proprietary TRUE 41.0892420 -111.9954710 0   11 49 49011 36260 Salt Lake City-Provo-Orem, UT Central Davis County https://data.medicare.gov/resource/xubh-q36u/row-wuqr~ebyx-f6ny 460041 653359 2019-08-30 2019-03-31 141 14       15 170 25 10           205
549 ABRAZO SCOTTSDALE CAMPUS 3929 EAST BELL ROAD PHOENIX AZ 85032 MARICOPA (602) 923-5000 Acute Care Hospitals Proprietary TRUE 33.6406030 -111.9976920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-3yrx.bcen.wd4a 30083 644698 2019-02-28 2018-09-30 113 14         127               127
245 BRIGHAM CITY COMMUNITY HOSPITAL 950 SOUTH MEDICAL DRIVE BRIGHAM CITY UT 84302 BOX ELDER (435) 734-9471 Acute Care Hospitals Proprietary TRUE 41.4910700 -112.0244410 0   3 49 49003 36260 Salt Lake City-Provo-Orem, UT Central Box Elder County https://data.medicare.gov/resource/xubh-q36u/row-nuu9~e5qc.3jxf 460017 657558 2019-01-17 2018-08-31 40           40               40
557 ST LUKE'S MEDICAL CENTER 1800 EAST VAN BUREN STREET PHOENIX AZ 85006 MARICOPA (602) 251-8156 Acute Care Hospitals Proprietary TRUE 33.4514360 -112.0427670 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-uw3s~cbm4-5jyq 30037 655739 2019-10-31 2019-05-31 141 30         171 55 16           242
575 DIGNITY HEALTH - ARIZONA GENERAL HOSPITAL 7171 SOUTH 51ST AVENUE LAVEEN AZ 85339 MARICOPA (623) 584-5100 Acute Care Hospitals Proprietary FALSE 33.3806770 -112.1682330 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6h9g-s46a~aiyi 30136 651169 2019-06-03 2018-12-31 16           16               16
566 ABRAZO ARROWHEAD CAMPUS 18701 NORTH 67TH AVENUE GLENDALE AZ 85308 MARICOPA (623) 561-1000 Acute Care Hospitals Proprietary TRUE 33.6550420 -112.2028890 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-mbqg~urbx.9rm7 30094 654000 2019-08-29 2019-03-31 224 38         262               262
1766 MOUNTAIN WEST MEDICAL CENTER 2055 NORTH MAIN STREET TOOELE UT 84074 TOOELE (435) 843-3700 Acute Care Hospitals Proprietary TRUE 40.5663676 -112.2978893 1 ROOFTOP 45 49 49045 41620 Salt Lake City-Provo-Orem, UT Outlying Tooele County https://data.medicare.gov/resource/xubh-q36u/row-c6yc_xi6t-5yr5 460014 653932 2019-08-27 2018-12-31 32 4         36               36
577 ABRAZO WEST CAMPUS 13677 WEST MCDOWELL ROAD GOODYEAR AZ 85395 MARICOPA (623) 882-1970 Acute Care Hospitals Proprietary TRUE 33.4642830 -112.3540240 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-6kds~arrq.mhdd 30110 654825 2019-09-26 2019-04-30 159 20         179               179
578 WESTERN REGIONAL MEDICAL CENTER 14200 WEST CELEBRATE LIFE WAY GOODYEAR AZ 85338 MARICOPA (623) 207-3518 Acute Care Hospitals Proprietary FALSE 33.4528040 -112.3625710 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-rhgj.utwd-n4qy                                      
271 PORTNEUF MEDICAL CENTER 777 HOSPITAL WAY POCATELLO ID 83201 BANNOCK (208) 239-1000 Acute Care Hospitals Proprietary TRUE 42.8726210 -112.4189000 0   5 16 16005 38540   Central Bannock County https://data.medicare.gov/resource/xubh-q36u/row-seur~dy2g.gabs 130028 653172 2019-08-07 2018-12-31 101 20         137 19 9           165
1109 DELTA COMMUNITY HOSPITAL 126 SOUTH WHITE SAGE AVENUE DELTA UT 84624 MILLARD (435) 864-5591 Critical Access Hospitals Proprietary TRUE 39.3502940 -112.5600230 0   27 49 49027         https://data.medicare.gov/resource/xubh-q36u/row-drqc-aprc.hcpi 461300 652115 2019-05-30 2018-12-31 18           18               18
197 MESA VIEW REGIONAL HOSPITAL 1299 BERTHA HOWE AVENUE MESQUITE NV 89027 CLARK (702) 346-8040 Critical Access Hospitals Proprietary TRUE 36.8088590 -114.1144560 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-8rk4-cq3s_fa8n 291307 640239 2018-12-18 2018-07-31 21 4         25               25
1146 THE HEALTHCENTER 320 SUNNYVIEW LANE KALISPELL MT 59901 FLATHEAD (406) 756-4720 Acute Care Hospitals Proprietary FALSE 48.2162080 -114.3240470 0   29 30 30029 28060   Central Flathead County https://data.medicare.gov/resource/xubh-q36u/row-q8tk.6pjn~75zu 270087 653252 2019-08-26 2019-03-31 17           17   10           27
669 HAVASU REGIONAL MEDICAL CENTER 101 CIVIC CENTER LANE LAKE HAVASU CITY AZ 86403 MOHAVE (928) 855-8185 Acute Care Hospitals Proprietary TRUE 34.4799800 -114.3385370 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-kbv6-rmcu~b79y 30069 661849 2019-02-04 2018-08-31 128 16         144       19       163
668 WESTERN ARIZONA REGIONAL MEDICAL CENTER 2735 SILVER CREEK ROAD BULLHEAD CITY AZ 86442 MOHAVE (928) 763-2273 Acute Care Hospitals Proprietary TRUE 35.1098530 -114.5551460 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-95sy-y45e~48d6 30101 656846 2019-01-31 2018-08-31 107 32         139               139
671 VALLEY VIEW MEDICAL CENTER 5330 SOUTH HIGHWAY 95 FORT MOHAVE AZ 86426 MOHAVE (928) 788-2273 Acute Care Hospitals Proprietary TRUE 35.0023630 -114.5979540 0   15 4 4015 29420 Las Vegas-Henderson, NV-AZ Central Mohave County https://data.medicare.gov/resource/xubh-q36u/row-8tpg-vtcr.3uy5 30117 652034 2019-05-02 2018-11-30 60 12         72   12           84
201 HENDERSON HOSPITAL 1050 WEST GALLERIA DRIVE HENDERSON NV 89011 CLARK (318) 290-4395 Acute Care Hospitals Proprietary TRUE 36.0728432 -115.0304734 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-duqr_nix9.a8cp 290057 648718 2019-05-29 2018-12-31 120 16         140               140
193 DESERT SPRINGS HOSPITAL 2075 EAST FLAMINGO ROAD LAS VEGAS NV 89119 CLARK (702) 369-7600 Acute Care Hospitals Proprietary TRUE 36.1145610 -115.1255480 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-h6f4_d5w8_jhfe 290022 649621 2019-05-29 2018-12-31 215 34         249 32 12           293
206 SUNRISE HOSPITAL AND MEDICAL CENTER 3186 S MARYLAND PKWY LAS VEGAS NV 89109 CLARK (702) 731-8000 Acute Care Hospitals Proprietary TRUE 36.1345860 -115.1368830 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-9gwr_6ph4-9w5i 290003 652435 2019-08-01 2019-01-31 376 64     20 72 554   42           596
200 DIGNITY HEALTH ST ROSE DOMINICAN N L V CAMPUS 1550 W CRAIG RANCH NORTH LAS VEGAS NV 89031 CLARK (702) 777-3615 Acute Care Hospitals Proprietary TRUE 36.2434428 -115.1500008 1 ROOFTOP 3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-u3b3_a37u-466v 290058 652436 2019-05-30 2018-12-31 32           32               32
189 VALLEY HOSPITAL MEDICAL CENTER 620 SHADOW LANE LAS VEGAS NV 89106 CLARK (702) 388-4000 Acute Care Hospitals Proprietary TRUE 36.1639140 -115.1654630 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-h9xh~nrzf.p42d 290021 649464 2019-05-29 2018-12-31 229 20 25       274   16           290
207 SPRING VALLEY HOSPITAL MEDICAL CENTER 5400 SOUTH RAINBOW BLVD LAS VEGAS NV 89118 CLARK (702) 853-3000 Acute Care Hospitals Proprietary TRUE 36.0897140 -115.2428820 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-e224~h6nw_3cd4 290046 649465 2019-05-29 2018-12-31 279 28         337   22           359
194 MOUNTAINVIEW HOSPITAL 3100 N TENAYA WAY LAS VEGAS NV 89128 CLARK (702) 255-5065 Acute Care Hospitals Proprietary TRUE 36.2156000 -115.2507950 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-ifwz~wzbs.p5xc 290039 650298 2019-05-28 2018-12-31 277 47       24 348   36           384
204 CENTENNIAL HILLS HOSPITAL MEDICAL CENTER 6900 N DURANGO DR LAS VEGAS NV 89149 CLARK (702) 835-9700 Acute Care Hospitals Proprietary TRUE 36.2860140 -115.2877300 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-mxjv~899t-ww8w 290054 648952 2019-05-30 2018-12-31 217 16         248               248
208 SUMMERLIN HOSPITAL MEDICAL CENTER 657 TOWN CENTER DRIVE LAS VEGAS NV 89144 CLARK (702) 233-7500 Acute Care Hospitals Proprietary TRUE 36.1796380 -115.3157760 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-bs37~asjj.ux8i 290041 649924 2019-05-29 2018-12-31 248 59         370   31           401
366 NORTHEASTERN NEVADA REGIONAL HOSPITAL 2001 ERRECART BLVD ELKO NV 89801 ELKO (775) 738-5151 Acute Care Hospitals Proprietary TRUE 40.8225080 -115.7290260 0   7 32 32007 21220   Central Elko County https://data.medicare.gov/resource/xubh-q36u/row-q6r2~fn4e-z9r9 290008 662547 2019-11-27 2019-06-30 52 7         59               59
965 DESERT VIEW HOSPITAL 360 SOUTH LOLA LANE PAHRUMP NV 89048 NYE (775) 751-7500 Critical Access Hospitals Proprietary TRUE 36.2143760 -116.0233810 0   23 32 32023 37220 Las Vegas-Henderson, NV-AZ Central Nye County https://data.medicare.gov/resource/xubh-q36u/row-tvhx.ef9u_jqa6 291311 654936 2019-09-20 2018-12-31 25           25               25
2293 JOHN F KENNEDY MEMORIAL HOSPITAL 47111 MONROE STREET INDIO CA 92201 RIVERSIDE (760) 347-6191 Acute Care Hospitals Proprietary TRUE 33.7063590 -116.2338810 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-5fp5.7ptj~7ga6 50534 655749 2019-10-28 2019-05-31 114 16         130               130
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
2284 EISENHOWER MEDICAL CENTER 39-000 BOB HOPE DRIVE RANCHO MIRAGE CA 92270 RIVERSIDE (760) 340-3911 Acute Care Hospitals Proprietary TRUE 33.7648520 -116.4080850 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-8rsp~gqw9-ukc2 50573 662165 2019-11-27 2019-06-30 311 34         345   23           368
2290 DESERT REGIONAL MEDICAL CENTER 1150 NORTH INDIAN CANYON DRIVE PALM SPRINGS CA 92262 RIVERSIDE (760) 323-6511 Acute Care Hospitals Proprietary TRUE 33.8388610 -116.5455980 0   65 6 6065 40140 Los Angeles-Long Beach, CA Central Riverside County https://data.medicare.gov/resource/xubh-q36u/row-xtgm_w9me.m6e8 50243 659636 2019-11-19 2019-05-31 264 31       30 325   12   32       369
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
1999 NORTHWEST SPECIALTY HOSPITAL 1593 EAST POLSTON AVENUE POST FALLS ID 83854 KOOTENAI (208) 262-2466 Acute Care Hospitals Proprietary FALSE 47.7144100 -116.9244550 0   55 16 16055 17660 Spokane-Spokane Valley-Coeur d'Alene, WA-ID Central Kootenai County https://data.medicare.gov/resource/xubh-q36u/row-68rq_3jru~i59y 130066 649721 2019-06-03 2018-12-31 34           34               34
2440 BARSTOW COMMUNITY HOSPITAL 820 E MOUNTAIN VIEW STREET BARSTOW CA 92311 SAN BERNARDINO (760) 256-1761 Acute Care Hospitals Proprietary TRUE 34.8936960 -117.0166000 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-2mmv_xa7g.rdya 50298 654086 2019-08-27 2019-01-31 26 4         30               30
2508 SHARP CHULA VISTA MEDICAL CENTER 751 MEDICAL CENTER COURT CHULA VISTA CA 91911 SAN DIEGO (619) 502-5800 Acute Care Hospitals Proprietary TRUE 32.6184480 -117.0239900 0   73 6 6073 41740   Central San Diego County https://data.medicare.gov/resource/xubh-q36u/row-75gp_4nzp_4ubq 50222 643329 2019-02-25 2018-09-30 199 35         243       50 50     343

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