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

757 rows where hospital_ownership = "Proprietary" sorted by fy_end_date

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

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
578 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                                      
2118 2118 HEALTHBRIDGE CHILDREN'S HOSPITAL - ORANGE 393 S TUSTIN STREET ORANGE CA 92866 ORANGE (714) 289-2400 Childrens Proprietary FALSE 33.7827720 -117.8357450 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-6j3t.dm9a.bqh8                                      
2955 2955 PINNACLE REGIONAL HOSPITAL, INC 12850 METCALF AVENUE OVERLAND PARK KS 66213 JOHNSON (913) 220-2866 Acute Care Hospitals Proprietary FALSE 38.8963010 -94.6678760 0   91 20 20091 28140 Kansas City-Overland Park-Kansas City, MO-KS Central Johnson County https://data.medicare.gov/resource/xubh-q36u/row-rddh~ajbk-yi9q                                      
3395 3395 INTEGRIS COMMUNITY HOSPITAL - COUNCIL CROSSING 9417 N COUNCIL ROAD OKLAHOMA CITY OK 73162 OKLAHOMA (405) 550-3280 Acute Care Hospitals Proprietary TRUE 35.5653520 -97.6562570 0   109 40 40109 36420 Oklahoma City-Shawnee, OK Central Oklahoma County https://data.medicare.gov/resource/xubh-q36u/row-g5rq~p6tq-qier                                      
3599 3599 QUITMAN COUNTY HOSPITAL CAH 340 GETWELL DRIVE MARKS MS 38646 QUITMAN (662) 326-8031 Critical Access Hospitals Proprietary TRUE 34.2474640 -90.2770590 0   119 28 28119         https://data.medicare.gov/resource/xubh-q36u/row-94fq~mrkf~464e                                      
3761 3761 CUMBERLAND HOSPITAL LLC 9407 CUMBERLAND ROAD NEW KENT VA 23124 NEW KENT (804) 966-2242 Childrens Proprietary FALSE 37.5455310 -76.9792200 0   127 51 51127 40060   Outlying New Kent County https://data.medicare.gov/resource/xubh-q36u/row-2t5p~njzu.inug                                      
4493 4493 CROCKETT MEDICAL CENTER 1100 E LOOP 304 CROCKETT TX 75835 HOUSTON (936) 546-3890 Critical Access Hospitals Proprietary TRUE 31.3236990 -95.4372570 0   225 48 48225         https://data.medicare.gov/resource/xubh-q36u/row-2gki~micg.zrhe                                      
4586 4586 EMIL J FREIREICH CANCER CENTER 9201 PINECROFT SHENANDOAH TX 77380 MONTGOMERY (855) 353-2201 Acute Care Hospitals Proprietary TRUE 30.1748330 -95.4562990 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-dgs8~kmnk_pu43                                      
4683 4683 TEXAS GENERAL HOSPITAL- VZRMC LP 707 N WALDRIP ST GRAND SALINE TX 75140 VAN ZANDT (903) 962-5200 Acute Care Hospitals Proprietary TRUE 32.6791930 -95.7217370 0   467 48 48467         https://data.medicare.gov/resource/xubh-q36u/row-6c8j-ja3g-2qcb                                      
300 300 WEISMAN CHILDRENS REHABILITATION HOSPITAL 92 BRICK ROAD, 3RD FLOOR MARLTON NJ 8053 BURLINGTON (856) 489-4520 Childrens Proprietary TRUE 39.8805880 -74.9192090 0   5 34 34005 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Burlington County https://data.medicare.gov/resource/xubh-q36u/row-9nkd_6jvc_38s2 313302 651476 2018-04-12 2017-12-31 18           18               18
1578 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                              
4579 4579 LITTLE RIVER HEALTHCARE 1700 BRAZOS ROCKDALE TX 76567 MILAM (512) 446-4500 Critical Access Hospitals Proprietary TRUE 30.6503240 -97.0201050 0   331 48 48331         https://data.medicare.gov/resource/xubh-q36u/row-afvn-5pmv_graz 451357 630239 2018-06-01 2017-12-31 25           25               25
4620 4620 CARE REGIONAL MEDICAL CENTER 1711 W WHEELER AVENUE ARANSAS PASS TX 78336 SAN PATRICIO (361) 758-8585 Acute Care Hospitals Proprietary TRUE 27.9159210 -97.1618290 0   409 48 48409 18580 Corpus Christi-Kingsville-Alice, TX Central San Patricio County https://data.medicare.gov/resource/xubh-q36u/row-g7k6_vy64~c2bf 450605 655598 2018-07-30 2017-12-31 63           63 12             75
3882 3882 NORTH OAK REGIONAL MEDICAL CENTER 401 GETWELL DR SENATOBIA MS 38668 TATE (662) 562-3100 Acute Care Hospitals Proprietary TRUE 34.6246780 -89.9567440 0   137 28 28137 32820 Memphis-Forrest City, TN-MS-AR Outlying Tate County https://data.medicare.gov/resource/xubh-q36u/row-pcjm~cndq_ygq8 250126 655683 2018-10-10 2018-03-31 29           29 12             41
1479 1479 WHITTIER HOSPITAL MEDICAL CENTER 9080 COLIMA RD WHITTIER CA 90605 LOS ANGELES (562) 945-3561 Acute Care Hospitals Proprietary TRUE 33.9507480 -118.0051140 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-4rmv_824x.pbwt 50735 657693 2018-12-03 2018-06-30 140 16         156       22       178
2546 2546 ELLWOOD CITY MEDICAL CENTER 724 PERSHING STREET ELLWOOD CITY PA 16117 LAWRENCE (724) 752-0081 Acute Care Hospitals Proprietary TRUE 40.8693490 -80.2744790 0   73 42 42073 35260 Pittsburgh-New Castle-Weirton, PA-OH-WV Central Lawrence County https://data.medicare.gov/resource/xubh-q36u/row-k638_yc9y~2hzs 390008 640799 2019-01-10 2018-06-30 46 6         52 10             62
2769 2769 AVERA HEART HOSPITAL OF SOUTH DAKOTA 4500 W 69TH ST SIOUX FALLS SD 57108 LINCOLN (605) 977-7000 Acute Care Hospitals Proprietary TRUE 43.4899220 -96.7809060 0   83 46 46083 43620   Central Lincoln County https://data.medicare.gov/resource/xubh-q36u/row-rh7v_8wee~ws72 430095 658587 2018-12-03 2018-06-30 53           53               53
3302 3302 ADVENTHEALTH HEART OF FLORIDA 40100 HWY 27 DAVENPORT FL 33837 POLK (863) 422-4971 Acute Care Hospitals Proprietary TRUE 28.1803340 -81.6399540 0   105 12 12105 29460   Central Polk County https://data.medicare.gov/resource/xubh-q36u/row-febs~ded9_jd7n 100137 656903 2018-12-03 2018-06-30 178 15         193               193
3582 3582 NORTH METRO MEDICAL CENTER 1400 BRADEN STREET JACKSONVILLE AR 72076 PULASKI (501) 985-7000 Acute Care Hospitals Proprietary TRUE 34.8723810 -92.1246970 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-fmp5~srts-kxcs 40074 656863 2018-12-06 2018-06-30 47           47 31             78
4011 4011 DARDANELLE HOSPITAL 200 NORTH THIRD STREET DARDANELLE AR 72834 YELL (479) 229-4677 Critical Access Hospitals Proprietary TRUE 35.2209170 -93.1569870 0   149 5 5149 40780   Outlying Yell County https://data.medicare.gov/resource/xubh-q36u/row-u9x6_diim.h7v6 41302 639835 2018-12-26 2018-06-30 25           25 10             35
197 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
560 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                              
697 697 PARKLAND MEDICAL CENTER 1 PARKLAND DRIVE DERRY NH 3038 ROCKINGHAM (603) 421-2100 Acute Care Hospitals Proprietary TRUE 42.8758250 -71.3175780 0   15 33 33015 14460 Boston-Worcester-Providence, MA-RI-NH-CT Central Rockingham County https://data.medicare.gov/resource/xubh-q36u/row-m9nh.dqhg_kjyp 300017 659515 2019-11-07 2018-07-31 60 8         68 18             86
2530 2530 FRANKFORT REGIONAL MEDICAL CENTER 299 KINGS DAUGHTERS DRIVE FRANKFORT KY 40601 FRANKLIN (502) 875-5240 Acute Care Hospitals Proprietary TRUE 38.1597740 -84.9057530 0   73 21 21073 23180 Lexington-Fayette--Richmond--Frankfort, KY Central Franklin County https://data.medicare.gov/resource/xubh-q36u/row-iiuj~fp2r_ghys 180127 657103 2019-06-24 2018-07-31 102 10       4 116 12             128
2844 2844 WATSONVILLE COMMUNITY HOSPITAL 75 NIELSON STREET WATSONVILLE CA 95076 SANTA CRUZ (831) 724-4741 Acute Care Hospitals Proprietary TRUE 36.9282800 -121.7937210 0   87 6 6087 42100 San Jose-San Francisco-Oakland, CA Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-wbga.ap2u-4y8h 50194 656871 2019-08-22 2018-07-31 90 6         106               106
3172 3172 HARRIS REGIONAL HOSPITAL 68 HOSPITAL RD SYLVA NC 28779 JACKSON (828) 586-7000 Acute Care Hospitals Proprietary TRUE 35.3839230 -83.2027900 0   99 37 37099 19000   Central Jackson County https://data.medicare.gov/resource/xubh-q36u/row-xxmc~xtb8_wjsz 340016 658527 2019-05-09 2018-07-31 73 9         82               82
3533 3533 BYRD REGIONAL HOSPITAL 1020 FERTITTA BLVD LEESVILLE LA 71446 VERNON (337) 239-9041 Acute Care Hospitals Proprietary TRUE 31.1373240 -93.2687910 0   115 22 22115 22860 DeRidder-Fort Polk South, LA Central Vernon Parish https://data.medicare.gov/resource/xubh-q36u/row-strz-rejf.3ijm 190164 643212 2019-02-11 2018-07-31 45 7         52               52
3595 3595 MINDEN MEDICAL CENTER NO 1 MEDICAL PLAZA MINDEN LA 71055 WEBSTER (318) 377-2321 Acute Care Hospitals Proprietary TRUE 32.6172391 -93.2863556 1 ROOFTOP 119 22 22119 43340   Outlying Webster Parish https://data.medicare.gov/resource/xubh-q36u/row-zn8k~yqhx.sjt5 190144 657128 2019-01-03 2018-07-31 113 10         125 20 12           157
3928 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
4130 4130 RIVERVIEW REGIONAL MEDICAL CENTER 158 HOSPITAL DRIVE CARTHAGE TN 37030 SMITH (615) 735-9815 Critical Access Hospitals Proprietary TRUE 36.2636070 -85.9485560 0   159 47 47159 34980 Nashville-Davidson--Murfreesboro, TN Outlying Smith County https://data.medicare.gov/resource/xubh-q36u/row-rt2i~krrj-iike 441307 641882 2019-01-02 2018-07-31 23 2         25 10             35
4421 4421 PARK PLAZA HOSPITAL 1313 HERMANN DR HOUSTON TX 77004 HARRIS (713) 527-5019 Acute Care Hospitals Proprietary TRUE 29.7223750 -95.3880450 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dstj_s4k4.df5s 450659 657538 2019-08-26 2018-07-31 119 14         133               133
245 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
535 535 TENNOVA HEALTHCARE-CLEVELAND 2305 CHAMBLISS AVE NW CLEVELAND TN 37311 BRADLEY (423) 339-4132 Acute Care Hospitals Proprietary TRUE 35.1767430 -84.8685910 0   11 47 47011 17420 Chattanooga-Cleveland-Dalton, TN-GA-AL Central Bradley County https://data.medicare.gov/resource/xubh-q36u/row-yct2-mv92~dmuc 440185 657498 2019-01-29 2018-08-31 156 27         183               183
668 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
669 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
700 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
1186 1186 LEGENT ORTHOPEDIC + SPINE 5330 NORTH LOOP 1604 WEST SAN ANTONIO TX 78249 BEXAR (717) 620-2424 Acute Care Hospitals Proprietary TRUE 29.5914810 -98.5904380 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-gmp5~zjwe~7e5z 670112 656038 2019-01-30 2018-08-31 26           26               26
1437 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
1491 1491 GOOD SAMARITAN HOSPITAL 1225 WILSHIRE BOULEVARD LOS ANGELES CA 90017 LOS ANGELES (213) 977-2121 Acute Care Hospitals Proprietary FALSE 34.0532090 -118.2652920 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-bdi4_mszi_g3qn 50471 657674 2019-02-13 2018-08-31 248 39       23 310               310
1880 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
1890 1890 NATIONAL PARK MEDICAL CENTER 1910 MALVERN AVENUE HOT SPRINGS AR 71901 GARLAND (501) 321-1000 Acute Care Hospitals Proprietary TRUE 34.4862390 -93.0335540 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-ecgs.ugv2_gtfu 40078 656864 2019-02-14 2018-08-31 110 16         126 17 20           163
2056 2056 SOUTH BAY HOSPITAL 4016 SUN CITY CENTER BLVD SUN CITY CENTER FL 33573 HILLSBOROUGH (813) 634-3301 Acute Care Hospitals Proprietary TRUE 27.7123900 -82.3651680 0   57 12 12057 45300   Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-t2n2.68x7~rif4 100259 642087 2019-01-25 2018-08-31 126 12         138               138
2101 2101 CHAPMAN GLOBAL MEDICAL CENTER 2601 E CHAPMAN AVE ORANGE CA 92869 ORANGE (714) 633-0011 Acute Care Hospitals Proprietary TRUE 33.7878780 -117.8270580 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-d6nk-icx9_sprw 50745 656258 2019-02-01 2018-08-31 63 12         75 12     27       114
2104 2104 ORANGE COUNTY GLOBAL MEDICAL CENTER 1001 NORTH TUSTIN AVENUE SANTA ANA CA 92705 ORANGE (714) 953-3610 Acute Care Hospitals Proprietary TRUE 33.7536360 -117.8342090 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-28hr-uc2x~4s2a 50746 660777 2019-02-01 2018-08-31 163 42   7   16 228               228
2115 2115 SOUTH COAST GLOBAL MEDICAL CENTER 2701 S BRISTOL ST SANTA ANA CA 92704 ORANGE (714) 754-5454 Acute Care Hospitals Proprietary TRUE 33.7106920 -117.8854100 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-h474-fx88_e6is 50747 658163 2019-02-01 2018-08-31 100 9         109 23     46       178
2116 2116 ANAHEIM GLOBAL MEDICAL CENTER 1025 S ANAHEIM BLVD ANAHEIM CA 92805 ORANGE (714) 533-6220 Acute Care Hospitals Proprietary FALSE 33.8205660 -117.9090020 0   59 6 6059 31080 Los Angeles-Long Beach, CA Central Orange County https://data.medicare.gov/resource/xubh-q36u/row-nd9d.35tv~sptu 50744 658161 2019-02-01 2018-08-31 81 22         103 80             183
2226 2226 VHS HARLINGEN HOSPITAL COMPANY LLC 2101 PEASE ST HARLINGEN TX 78550 CAMERON (956) 389-1100 Acute Care Hospitals Proprietary TRUE 26.1734140 -97.6706660 0   61 48 48061 15180 Brownsville-Harlingen-Raymondville, TX Central Cameron County https://data.medicare.gov/resource/xubh-q36u/row-p8qk_8m5j~s6fq 450033 662428 2019-08-05 2018-08-31 294 40 8     32 374 12 18           404
2567 2567 REGIONAL GENERAL HOSPITAL WILLISTON 125 SW 7TH ST WILLISTON FL 32696 LEVY (352) 528-2801 Acute Care Hospitals Proprietary TRUE 29.3843540 -82.4557930 0   75 12 12075         https://data.medicare.gov/resource/xubh-q36u/row-tm6t.5fgm.s5u5 100322 642986 2019-02-04 2018-08-31 20           20               20
2742 2742 OCALA REGIONAL MEDICAL CENTER 1431 SW 1ST AVE OCALA FL 34478 MARION (352) 401-1000 Acute Care Hospitals Proprietary TRUE 29.1747440 -82.1378390 0   83 12 12083 36100   Central Marion County https://data.medicare.gov/resource/xubh-q36u/row-bsti-f9jn_qiab 100212 660499 2019-11-12 2018-08-31 294 66         360               360
2824 2824 MEDICAL CITY MCKINNEY 4500 MEDICAL CENTER DRIVE MCKINNEY TX 75069 COLLIN (972) 547-8000 Acute Care Hospitals Proprietary TRUE 33.1598420 -96.6355030 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-6zuh~kh9r.qkdr 450403 662606 2019-10-16 2018-08-31 133 16       7 156 63 15           234
3340 3340 PUTNAM COMMUNITY MEDICAL CENTER 611 ZEAGLER DR PALATKA FL 32177 PUTNAM (386) 326-8500 Acute Care Hospitals Proprietary TRUE 29.6423780 -81.6935180 0   107 12 12107 37260 Jacksonville-St. Marys-Palatka, FL-GA Central Putnam County https://data.medicare.gov/resource/xubh-q36u/row-vwvn~hmhe~b5i4 100232 656921 2019-02-01 2018-08-31 89 10         99               99
3518 3518 ST MARYS REGIONAL MEDICAL CENTER 1808 WEST MAIN STREET RUSSELLVILLE AR 72801 POPE (479) 968-2841 Acute Care Hospitals Proprietary TRUE 35.2828600 -93.1499080 0   115 5 5115 40780   Central Pope County https://data.medicare.gov/resource/xubh-q36u/row-wrry_g52x-fh3u 40041 656860 2019-02-14 2018-08-31 126 11         137   20           157
3636 3636 EMORY JOHNS CREEK HOSPITAL 6325 HOSPITAL PARKWAY JOHNS CREEK GA 30097 GWINNETT (678) 474-7000 Acute Care Hospitals Proprietary TRUE 34.0674660 -84.1751870 0   121 13 13121 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Fulton County https://data.medicare.gov/resource/xubh-q36u/row-g5cz~zdac~u2t5 110230 658280 2019-01-30 2018-08-31 96 14       8 118               118
3849 3849 EASTSIDE MEDICAL CENTER 1700 MEDICAL WAY SNELLVILLE GA 30078 GWINNETT (770) 736-2498 Acute Care Hospitals Proprietary TRUE 33.8772590 -84.0196450 0   135 13 13135 12060 Atlanta--Athens-Clarke County--Sandy Springs, GA Central Gwinnett County https://data.medicare.gov/resource/xubh-q36u/row-4b4x~z63q.ucqr 110192 660204 2019-01-29 2018-08-31 164 24       18 206 61 20           287
4089 4089 LEWISGALE HOSPITAL PULASKI 2400 LEE HIGHWAY PULASKI VA 24301 PULASKI (540) 994-8100 Acute Care Hospitals Proprietary TRUE 37.0687440 -80.7588070 0   155 51 51155 13980   Outlying Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-kn6x.gevb~kfhb 490116 655700 2019-02-01 2018-08-31 84 8         92               92
4195 4195 TRISTAR HENDERSONVILLE MEDICAL CENTER 355 NEW SHACKLE ISLAND RD HENDERSONVILLE TN 37075 SUMNER (615) 338-1000 Acute Care Hospitals Proprietary TRUE 36.3241560 -86.6201980 0   165 47 47165 34980 Nashville-Davidson--Murfreesboro, TN Central Sumner County https://data.medicare.gov/resource/xubh-q36u/row-9pfc.sfpa.n6zn 440194 658858 2019-02-01 2018-08-31 103 20       6 129               129
4201 4201 TERRE HAUTE REGIONAL HOSPITAL 3901 S SEVENTH ST TERRE HAUTE IN 47802 VIGO (812) 232-0021 Acute Care Hospitals Proprietary TRUE 39.4196240 -87.4068370 0   167 18 18167 45460   Central Vigo County https://data.medicare.gov/resource/xubh-q36u/row-q7vh~papa_4cqp 150046 656971 2019-01-31 2018-08-31 146 18         164 19 12           195
4441 4441 SURGERY SPECIALTY HOSPITALS OF AMERICA SE HOUSTON 4301 B VISTA PASADENA TX 77504 HARRIS (713) 378-3000 Acute Care Hospitals Proprietary TRUE 29.6587170 -95.1781610 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-kay2.vjuc_4mr7 450831 656004 2019-02-01 2018-08-31 37           37               37
4597 4597 CORPUS CHRISTI MEDICAL CENTER,THE 6629 WOODRIDGE ROAD CORPUS CHRISTI TX 78414 NUECES (361) 761-1501 Acute Care Hospitals Proprietary FALSE 27.6816440 -97.3592840 0   355 48 48355 18580 Corpus Christi-Kingsville-Alice, TX Central Nueces County https://data.medicare.gov/resource/xubh-q36u/row-ucbp~a56a_ytw8 450788 662615 2019-08-08 2018-08-31 335 33       16 384 17 15           416
4659 4659 ABILENE REGIONAL MEDICAL CENTER 6250 HWY 83/84 ABILENE TX 79606 TAYLOR (325) 428-1000 Acute Care Hospitals Proprietary TRUE 32.3740060 -99.7425950 0   441 48 48441 10180   Central Taylor County https://data.medicare.gov/resource/xubh-q36u/row-rque_a7mi~an5d 450558 657529 2019-04-12 2018-08-31 160 20         196               196
4665 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
4757 4757 CJW MEDICAL CENTER 7101 JAHNKE ROAD RICHMOND VA 23235 CHESTERFIELD (804) 320-3911 Acute Care Hospitals Proprietary TRUE 37.5158320 -77.5248800 0   760 51 51760 40060   Central Richmond city https://data.medicare.gov/resource/xubh-q36u/row-56mf_jbhx~d74w 490112 659017 2019-02-01 2018-08-31 487 78 12     35 612 137 44           793
99 99 MERIT HEALTH NATCHEZ 52 SERGEANT PRENTISS DRIVE NATCHEZ MS 39120 ADAMS (601) 443-2100 Acute Care Hospitals Proprietary TRUE 31.5279831 -91.3884516 1 RANGE_INTERPOLATED 1 28 28001 35020   Central Adams County https://data.medicare.gov/resource/xubh-q36u/row-36cp~uwxv-3duz 250084 643800 2019-02-27 2018-09-30 132 15         147 12 20           179
133 133 SOUTH BALDWIN REGIONAL MEDICAL CENTER 1613 NORTH MCKENZIE STREET FOLEY AL 36535 BALDWIN (251) 949-3400 Acute Care Hospitals Proprietary TRUE 30.4261090 -87.6831870 0   3 1 1003 19300 Mobile-Daphne-Fairhope, AL Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-pyt4.i3a3.r8cm 10083 645389 2019-03-01 2018-09-30 82 30         112               112
241 241 KENT COUNTY MEMORIAL HOSPITAL 455 TOLL GATE RD WARWICK RI 2886 KENT (401) 737-7010 Acute Care Hospitals Proprietary TRUE 41.7044780 -71.4779020 0   3 44 44003 39300 Boston-Worcester-Providence, MA-RI-NH-CT Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-cxmm.944u~3iqc 410009 644655 2019-02-28 2018-09-30 308 15         323   20           343
261 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
263 263 SHARON HOSPITAL 50 HOSPITAL HILL ROAD SHARON CT 6069 LITCHFIELD (860) 364-4228 Acute Care Hospitals Proprietary TRUE 41.8796620 -73.4815720 0   5 9 9005 45860 New York-Newark, NY-NJ-CT-PA Central Litchfield County https://data.medicare.gov/resource/xubh-q36u/row-cvhr-qzru_z9ev 70004 658178 2019-02-28 2018-09-30 55 11         66 12             78
422 422 PALM BAY HOSPITAL 1425 MALABAR RD, NE PALM BAY FL 32907 BREVARD (321) 434-8000 Acute Care Hospitals Proprietary TRUE 27.9983300 -80.6120800 0   9 12 12009 37340   Central Brevard County https://data.medicare.gov/resource/xubh-q36u/row-a9fd-uaut~kpyk 100316 646071 2019-02-27 2018-09-30 108 12         120 18             138
423 423 NAVICENT HEALTH BALDWIN 821 NORTH COBB STREET MILLEDGEVILLE GA 31061 BALDWIN (478) 454-3550 Acute Care Hospitals Proprietary TRUE 33.0884310 -83.2451450 0   9 13 13009 33300   Central Baldwin County https://data.medicare.gov/resource/xubh-q36u/row-4c5x-vuf4-z6uq 110150 655099 2019-10-10 2018-09-30 86 12         98       15       113
507 507 NORTHERN LIGHT INLAND HOSPITAL 200 KENNEDY MEMORIAL DRIVE WATERVILLE ME 4901 KENNEBEC (207) 861-3000 Acute Care Hospitals Proprietary TRUE 44.5426900 -69.6614050 0   11 23 23011 12300   Central Kennebec County https://data.medicare.gov/resource/xubh-q36u/row-w24b~y2sj-qzhk 200041 650154 2019-05-29 2018-09-30 33           33               33
517 517 MONADNOCK COMMUNITY HOSPITAL 452 OLD STREET ROAD PETERBOROUGH NH 3458 HILLSBOROUGH (603) 924-7191 Critical Access Hospitals Proprietary TRUE 42.8934610 -71.9374710 0   11 33 33011 31700 Boston-Worcester-Providence, MA-RI-NH-CT Central Hillsborough County https://data.medicare.gov/resource/xubh-q36u/row-mhsm~xuaz.m9jn 301309 645432 2019-03-01 2018-09-30 25           25               25
548 548 REGIONAL MEDICAL CENTER OF CENTRAL ALABAMA 29 L V STABLER DRIVE GREENVILLE AL 36037 BUTLER (334) 382-2200 Acute Care Hospitals Proprietary TRUE 31.8294500 -86.6458600 0   13 1 1013         https://data.medicare.gov/resource/xubh-q36u/row-ca8j-ucpx~zp9d 10150 645390 2019-03-01 2018-09-30 37 7         44 13             57
549 549 ABRAZO SCOTTSDALE CAMPUS 3929 EAST BELL ROAD PHOENIX AZ 85032 MARICOPA (602) 923-5000 Acute Care Hospitals Proprietary TRUE 33.6406030 -111.9976920 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-3yrx.bcen.wd4a 30083 644698 2019-02-28 2018-09-30 113 14         127               127
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
634 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
642 642 ALLIANCEHEALTH DURANT 1800 UNIVERSITY BOULEVARD DURANT OK 74702 BRYAN (405) 924-3080 Acute Care Hospitals Proprietary TRUE 34.0049030 -96.3950550 0   13 40 40013 20460 Dallas-Fort Worth, TX-OK Central Bryan County https://data.medicare.gov/resource/xubh-q36u/row-96gx.9gst_7qhe 370014 646932 2019-04-03 2018-09-30 132 8         140               140
657 657 BAYFRONT HEALTH PUNTA GORDA 809 E MARION AVE PUNTA GORDA FL 33950 CHARLOTTE (941) 639-3131 Acute Care Hospitals Proprietary TRUE 26.9406820 -82.0417880 0   15 12 12015 39460 North Port-Sarasota, FL Central Charlotte County https://data.medicare.gov/resource/xubh-q36u/row-9zqr-j2tf~pweh 100047 645396 2019-03-01 2018-09-30 114 10         124 52             176
667 667 STRINGFELLOW MEMORIAL HOSPITAL 301 EAST 18TH ST ANNISTON AL 36201 CALHOUN (256) 235-8900 Acute Care Hospitals Proprietary TRUE 33.6677010 -85.8250250 0   15 1 1015 11500   Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-2tt8-gqrt.8qr7 10038 644691 2019-02-28 2018-09-30 119 6         125               125
730 730 BAYFRONT HEALTH SEVEN RIVERS 6201 N SUNCOAST BLVD CRYSTAL RIVER FL 34428 CITRUS (352) 795-6560 Acute Care Hospitals Proprietary TRUE 28.9508960 -82.6258660 0   17 12 12017 26140   Central Citrus County https://data.medicare.gov/resource/xubh-q36u/row-e3ek_i6mx~pzz2 100249 644711 2019-02-28 2018-09-30 112 16         128               128
792 792 MULESHOE AREA MEDICAL CENTER 708 S 1ST ST MULESHOE TX 79347 BAILEY (806) 272-4524 Critical Access Hospitals Proprietary TRUE 34.2210290 -102.7284580 0   17 48 48017         https://data.medicare.gov/resource/xubh-q36u/row-2yhf.nyid~b2dz 451372 644191 2019-02-28 2018-09-30 25           25               25
802 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
803 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
820 820 EASTERN IDAHO REGIONAL MEDICAL CENTER 3100 CHANNING WAY IDAHO FALLS ID 83404 BONNEVILLE (208) 529-6210 Acute Care Hospitals Proprietary TRUE 43.4702760 -111.9901590 0   19 16 16019 26820 Idaho Falls-Rexburg-Blackfoot, ID Central Bonneville County https://data.medicare.gov/resource/xubh-q36u/row-zu9m_rfwy-xxuk 130018 644978 2019-02-28 2018-09-30 165 35         226 28 17       10   310
885 885 PHYSICIANS REGIONAL MEDICAL CENTER - PINE RIDGE 6101 PINE RIDGE ROAD NAPLES FL 34119 COLLIER (239) 348-4000 Acute Care Hospitals Proprietary TRUE 26.2117640 -81.7307070 0   21 12 12021 34940 Cape Coral-Fort Myers-Naples, FL Central Collier County https://data.medicare.gov/resource/xubh-q36u/row-z54t-v8nq.fk93 100286 643693 2019-02-28 2018-09-30 177 24         201               201
941 941 HOLY CROSS HOSPITAL 1171 WEST TARGET RANGE ROAD NOGALES AZ 85621 SANTA CRUZ (520) 285-3000 Critical Access Hospitals Proprietary TRUE 31.3411180 -110.9587340 0   23 4 4023 35700 Tucson-Nogales, AZ Central Santa Cruz County https://data.medicare.gov/resource/xubh-q36u/row-datt~k3n6_g682 31313 644092 2019-02-28 2018-09-30 25           25               25
1067 1067 WEST VALLEY MEDICAL CENTER 1717 ARLINGTON STREET CALDWELL ID 83605 CANYON (208) 459-4641 Acute Care Hospitals Proprietary TRUE 43.6542200 -116.6956400 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-q3w9-74rj.ew8y 130014 645072 2019-02-28 2018-09-30 95 13       4 112               112
1083 1083 ADCARE HOSPITAL OF WORCESTER INC 107 LINCOLN STREET WORCESTER MA 1605 WORCESTER (508) 799-9000 Acute Care Hospitals Proprietary FALSE 42.2761820 -71.7955760 0   27 25 25027 49340 Boston-Worcester-Providence, MA-RI-NH-CT Central Worcester County https://data.medicare.gov/resource/xubh-q36u/row-rnsb.iihy_fs75 220062 645423 2019-03-01 2018-09-30 114           114               114
1215 1215 EAST GEORGIA REGIONAL MEDICAL CENTER 1499 FAIR ROAD STATESBORO GA 30458 BULLOCH (912) 486-1500 Acute Care Hospitals Proprietary TRUE 32.4151710 -81.7686500 0   31 13 13031 44340 Savannah-Hinesville-Statesboro, GA Central Bulloch County https://data.medicare.gov/resource/xubh-q36u/row-xsms-9ix9.jicj 110075 645062 2019-02-28 2018-09-30 118 24         142               142
1294 1294 CARTERET GENERAL HOSPITAL 3500 ARENDELL ST MOREHEAD CITY NC 28557 CARTERET (252) 808-6000 Acute Care Hospitals Proprietary TRUE 34.7248140 -76.7541300 0   31 37 37031 33980 New Bern-Morehead City, NC Central Carteret County https://data.medicare.gov/resource/xubh-q36u/row-uiyb~9g3i~mjnw 340142 645137 2019-03-01 2018-09-30 91 8         99               99
1302 1302 CAROLINA PINES REGIONAL MEDICAL CENTER 1304 W BOBO NEWSOM HWY HARTSVILLE SC 29550 DARLINGTON (864) 339-2100 Acute Care Hospitals Proprietary TRUE 34.3486750 -80.1057670 0   31 45 45031 22500   Outlying Darlington County https://data.medicare.gov/resource/xubh-q36u/row-mysv_x577-nb3h 420010 654657 2019-09-13 2018-09-30 104 12         116               116
1331 1331 UNITED MEDICAL CENTER 1310 SOUTHERN AVENUE SE WASHINGTON DC 20032 THE DISTRICT (202) 574-6611 Acute Care Hospitals Proprietary TRUE 38.8341550 -76.9846980 0   33 24 24033 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Prince George's County https://data.medicare.gov/resource/xubh-q36u/row-zng6.qzhh.7sfd 90008 645634 2019-03-01 2018-09-30 180 16         196               196
1405 1405 FRYE REGIONAL MEDICAL CENTER 420 N CENTER ST HICKORY NC 28601 CATAWBA (828) 322-6070 Acute Care Hospitals Proprietary TRUE 35.7371750 -81.3377780 0   35 37 37035 25860 Hickory-Lenoir, NC Central Catawba County https://data.medicare.gov/resource/xubh-q36u/row-h6s5_yv38.x5zx 340116 643928 2019-03-04 2018-09-30 196 24       6 226 100 29           355
1557 1557 DRUMRIGHT REGIONAL HOSPITAL 610 WEST BYPASS DRUMRIGHT OK 74030 CREEK (918) 382-2300 Critical Access Hospitals Proprietary TRUE 35.9981930 -96.6059788 1 ROOFTOP 37 40 40037 46140 Tulsa-Muskogee-Bartlesville, OK Central Creek County https://data.medicare.gov/resource/xubh-q36u/row-7yzz_kwx7_bt4n 371331 641664 2019-01-08 2018-09-30 15           15               15
1592 1592 MERCY REGIONAL MEDICAL CENTER 800 E MAIN VILLE PLATTE LA 70586 EVANGELINE (337) 363-5684 Acute Care Hospitals Proprietary TRUE 30.6849310 -92.2659730 0   39 22 22039         https://data.medicare.gov/resource/xubh-q36u/row-2sdk.fhzr.wwum 190167 645559 2019-03-01 2018-09-30 85 14         99   10           109
1626 1626 ST FRANCIS HOSPITAL 333 LAIDLEY ST CHARLESTON WV 25301 KANAWHA (304) 347-6500 Acute Care Hospitals Proprietary TRUE 38.3533640 -81.6325800 0   39 54 54039 16620 Charleston-Huntington-Ashland, WV-OH-KY Central Kanawha County https://data.medicare.gov/resource/xubh-q36u/row-snvq.hpwk.4wwh 510031 640147 2018-12-31 2018-09-30 27 5         32       12       44
1642 1642 FAYETTE REGIONAL HEALTH SYSTEM 1941 VIRGINIA AVE CONNERSVILLE IN 47331 FAYETTE (765) 825-5131 Acute Care Hospitals Proprietary TRUE 39.6559200 -85.1319840 0   41 18 18041 18220 Richmond-Connersville, IN Central Fayette County https://data.medicare.gov/resource/xubh-q36u/row-eksi_yzpc.5837 150064 645404 2019-03-01 2018-09-30 25 20         45 12             57
1672 1672 COLLEGE STATION MEDICAL CENTER 1604 ROCK PRAIRIE ROAD COLLEGE STATION TX 77842 BRAZOS (979) 764-5151 Acute Care Hospitals Proprietary TRUE 30.5826260 -96.2910140 0   41 48 48041 17780   Central Brazos County https://data.medicare.gov/resource/xubh-q36u/row-kw5b_vp92-tdms 450299 645732 2019-03-01 2018-09-30 102 12         114               114
1712 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
1768 1768 LOGAN REGIONAL MEDICAL CENTER 20 HOSPITAL DRIVE LOGAN WV 25601 LOGAN (304) 831-1101 Acute Care Hospitals Proprietary TRUE 37.8463180 -81.9942840 0   45 54 54045 30880 Charleston-Huntington-Ashland, WV-OH-KY Central Logan County https://data.medicare.gov/resource/xubh-q36u/row-ey8g_hbxf.f7mj 510048 652853 2019-08-16 2018-09-30 120 12         132   8           140
1786 1786 MERIT HEALTH BILOXI 150 REYNOIR STREET BILOXI MS 39530 HARRISON (228) 436-1104 Acute Care Hospitals Proprietary TRUE 30.3961120 -88.8904380 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-had8.h2gv_r2ex 250007 645573 2019-03-01 2018-09-30 147 18         165 12             177

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