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 phone_number

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
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
768 HUDSON REGIONAL HOSPITAL 55 MEADOWLANDS PKWY SECAUCUS NJ 7094 HUDSON (201) 392-3200 Acute Care Hospitals Proprietary TRUE 40.7918050 -74.0720990 0   17 34 34017 35620 New York-Newark, NY-NJ-CT-PA Central Hudson County https://data.medicare.gov/resource/xubh-q36u/row-ndru~dizp-vj9e 310118 654744 2019-09-30 2018-12-31 88 14         102   4           106
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
75 GEORGE WASHINGTON UNIV HOSPITAL 900 23RD ST NW WASHINGTON DC 20037 THE DISTRICT (202) 716-4605 Acute Care Hospitals Proprietary TRUE 38.9011690 -77.0501190 0   1 11 11001 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central District of Columbia https://data.medicare.gov/resource/xubh-q36u/row-y2et_6xjz~rfau 90001 649550 2019-05-29 2018-12-31 255 56         329 20 16           365
413 WATERBURY HOSPITAL 64 ROBBINS ST WATERBURY CT 6721 NEW HAVEN (203) 573-6000 Acute Care Hospitals Proprietary TRUE 41.5582690 -73.0586080 0   9 9 9009 35300 New York-Newark, NY-NJ-CT-PA Central New Haven County https://data.medicare.gov/resource/xubh-q36u/row-na88_kufh.6cuk 70005 650439 2019-05-30 2018-12-31 193 20         213 30             243
2986 NORTHWEST MEDICAL CENTER 1530 U S HIGHWAY 43 WINFIELD AL 35594 FAYETTE (205) 487-7736 Acute Care Hospitals Proprietary TRUE 33.9293160 -87.8245070 0   93 1 1093         https://data.medicare.gov/resource/xubh-q36u/row-r4dk-tpsz_u57n 10086 651153 2019-06-03 2018-12-31 57 4         61 10             71
2501 BROOKWOOD BAPTIST MEDICAL CENTER 2010 BROOKWOOD MEDICAL CENTER DRIVE BIRMINGHAM AL 35209 JEFFERSON (205) 877-1000 Acute Care Hospitals Proprietary TRUE 33.4629100 -86.7768500 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-6yzq-z9kd_9ua7 10139 650228 2019-05-31 2018-12-31 340 26 27     32 425 140 30           595
2504 GRANDVIEW MEDICAL CENTER 3690 GRANDVIEW PARKWAY BIRMINGHAM AL 35243 JEFFERSON (205) 971-1000 Acute Care Hospitals Proprietary TRUE 33.4343630 -86.7204830 0   73 1 1073 13820 Birmingham-Hoover-Talladega, AL Central Jefferson County https://data.medicare.gov/resource/xubh-q36u/row-pwut_di96_m4tu 10104 660349 2019-11-25 2019-06-30 289 72         373 12 17           402
744 RUMFORD HOSPITAL 420 FRANKLIN STREET RUMFORD ME 4276 OXFORD (207) 369-1000 Critical Access Hospitals Proprietary TRUE 44.5517210 -70.5571710 0   17 23 23017         https://data.medicare.gov/resource/xubh-q36u/row-923a_kexq.nxfx 201306 662536 2019-12-02 2019-06-30 25           25               25
1001 REDINGTON FAIRVIEW GENERAL HOSPITAL 46 FAIRVIEW AVE PO BOX 468 SKOWHEGAN ME 4976 SOMERSET (207) 474-5121 Critical Access Hospitals Proprietary TRUE 44.7583360 -69.7134950 0   25 23 23025         https://data.medicare.gov/resource/xubh-q36u/row-g9mx~aw3n.5hnn 201314 661526 2019-12-02 2019-06-30 21 4         25               25
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
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
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
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
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
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
3136 STANISLAUS SURGICAL HOSPITAL 1421 OAKDALE ROAD MODESTO CA 95355 STANISLAUS (209) 572-2700 Acute Care Hospitals Proprietary FALSE 37.6645580 -120.9575160 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-fsc3.3tg8_b499 50726 649542 2019-05-31 2018-12-31 23           23               23
3133 DOCTORS MEDICAL CENTER 1441 FLORIDA AVENUE MODESTO CA 95350 STANISLAUS (209) 578-1211 Acute Care Hospitals Proprietary TRUE 37.6656660 -120.9962500 0   99 6 6099 33700 Modesto-Merced, CA Central Stanislaus County https://data.medicare.gov/resource/xubh-q36u/row-h4cz~c84j.66ru 50464 655748 2019-10-30 2019-05-31 291 22 14     45 380 67             447
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
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
1189 BAPTIST EMERGENCY HOSPITAL 16088 SAN PEDRO SAN ANTONIO TX 78232 BEXAR (210) 402-4092 Acute Care Hospitals Proprietary TRUE 29.5879550 -98.4741980 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-4y9d~e7dz-wrhw 670078 649389 2019-05-30 2018-12-31 50           50               50
1190 FOUNDATION SURGICAL HOSPITAL OF SAN ANTONIO 9522 HUEBNER ROAD SAN ANTONIO TX 78240 BEXAR (210) 478-5400 Acute Care Hospitals Proprietary TRUE 29.5310350 -98.5925540 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-pvs4~yydr-y7qv 670054 649387 2019-06-03 2018-12-31 20           20               20
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
1184 METHODIST AMBULATORY SURGERY HOSPITAL NW 9150 HUEBNER RD SUITE 100 SAN ANTONIO TX 78240 BEXAR (210) 575-5000 Acute Care Hospitals Proprietary TRUE 29.5276050 -98.5959950 0   29 48 48029 41700   Central Bexar County https://data.medicare.gov/resource/xubh-q36u/row-f26r~6776-r3st 450780 650209 2019-05-31 2018-12-31 22           22               22
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
307 BRONX-LEBANON HOSPITAL CENTER 1276 FULTON AVENUE BRONX NY 10456 BRONX (212) 588-7000 Acute Care Hospitals Proprietary TRUE 40.8317500 -73.9037560 0   5 36 36005 35620 New York-Newark, NY-NJ-CT-PA Central Bronx County https://data.medicare.gov/resource/xubh-q36u/row-ybqz_42sc_fi95 330009 650853 2019-06-27 2018-12-31 378 31 11     40 460 104             564
1460 HOLLYWOOD PRESBYTERIAN MEDICAL CENTER 1300 N VERMONT AVE LOS ANGELES CA 90027 LOS ANGELES (213) 413-3000 Acute Care Hospitals Proprietary TRUE 34.0961160 -118.2917530 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-8qce_cap7_t65z 50063 651260 2019-07-02 2018-12-31 266 36       15 317   28   89       434
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
1512 L A DOWNTOWN MEDICAL CENTER 1711 WEST TEMPLE STREET LOS ANGELES CA 90026 LOS ANGELES (213) 989-6123 Acute Care Hospitals Proprietary FALSE 34.0687900 -118.2635600 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-zwwh-h6yb.86z7 50763 650663 2019-05-31 2018-12-31 222 12         234               234
3503 PINE CREEK MEDICAL CENTER LLP 9032 HARRY HINES BLVD DALLAS TX 75235 DALLAS (214) 231-2273 Acute Care Hospitals Proprietary TRUE 32.8401610 -96.8688350 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-yjax~idz9_awg3 450894 648768 2019-05-24 2018-12-31 15           15               15
4643 BAYLOR SCOTT AND WHITE EMERGENCY HOSPITAL BURLESON 12500 SOUTH FREEWAY SUITE 100 BURLESON TX 76028 JOHNSON (214) 294-6250 Acute Care Hospitals Proprietary TRUE 32.5760100 -97.3207740 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-f6z2_rbym-eqyb 670107 649156 2019-05-30 2018-12-31 24           24               24
3502 DALLAS REGIONAL MEDICAL CENTER 1011 NORTH GALLOWAY AVENUE MESQUITE TX 75149 DALLAS (214) 320-7000 Acute Care Hospitals Proprietary TRUE 32.7775750 -96.5997200 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-f3bu_fxyn_gxk5 450688 649674 2019-05-30 2018-12-31 178 24         202               202
26 CITY HOSPITAL AT WHITE ROCK 9440 POPPY DR DALLAS TX 75218 DALLAS (214) 324-6100 Acute Care Hospitals Proprietary TRUE 32.8355210 -96.7050010 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-5mze~mvpw.a56k 450678 655846 2019-10-31 2019-05-31 167 20         187               187
3511 BAYLOR SCOTT AND WHITE MEDICAL CENTER UPTOWN 2727 EAST LEMMON AVENUE BUILDING I DALLAS TX 75204 DALLAS (214) 443-3000 Acute Care Hospitals Proprietary TRUE 32.8045300 -96.7947570 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-udxc_2rw9.sdb8 450422 651244 2019-06-26 2018-12-31 24           24               24
2817 METHODIST MCKINNEY HOSPITAL 8000 W ELDORADO PKWY BLDG C SUITE C MCKINNEY TX 75070 COLLIN (214) 491-5710 Acute Care Hospitals Proprietary TRUE 33.1758090 -96.7243430 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-mnxi-9kbn.uk2u 670069 661131 2019-12-11 2019-07-31 23           23               23
2814 BAYLOR MEDICAL CENTER AT FRISCO 5601 WARREN PARKWAY FRISCO TX 75034 DENTON (214) 618-2000 Acute Care Hospitals Proprietary TRUE 33.1067100 -96.8379190 0   85 48 48085 19100 Dallas-Fort Worth, TX-OK Central Collin County https://data.medicare.gov/resource/xubh-q36u/row-y75i-gkwy-z8z2 450853 649836 2019-05-30 2018-12-31 60         8 68               68
3494 TEXAS INSTITUTE FOR SURGERY AT PRESBYTERIAN HOSPIT 7115 GREENVILLE AVENUE SUITE 100 DALLAS TX 75231 DALLAS (214) 647-5300 Acute Care Hospitals Proprietary TRUE 32.8763770 -96.7617260 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-zpaw~2v5b-8gcc 450889 646976 2019-04-26 2018-12-31 9           9               9
3495 BAYLOR SCOTT AND WHITE HEART AND VASCULAR HOSPITAL 621 NORTH HALL STREET DALLAS TX 75226 DALLAS (214) 820-0670 Acute Care Hospitals Proprietary TRUE 32.7882880 -96.7806630 0   113 48 48113 19100 Dallas-Fort Worth, TX-OK Central Dallas County https://data.medicare.gov/resource/xubh-q36u/row-gher.dgrm-kty6 450851 659614 2019-11-22 2019-06-30 53           53               53
785 ROTHMAN ORTHOPAEDIC SPECIALTY HOSPITAL LLC 3300 TILLMAN DRIVE BENSALEM PA 19020 BUCKS (215) 244-7400 Acute Care Hospitals Proprietary FALSE 40.1143500 -74.9620930 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-w5gs-9pze-8zau 390322 649490 2019-06-03 2018-12-31 24           24               24
3234 CHESTNUT HILL HOSPITAL 8835 GERMANTOWN AVE PHILADELPHIA PA 19118 PHILADELPHIA (215) 248-8200 Acute Care Hospitals Proprietary TRUE 40.0787910 -75.2127520 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-f7vd-4uzw~5mpg 390026 660694 2019-11-27 2019-06-30 114 14         128 20             148
3222 ST CHRISTOPHER'S HOSPITAL FOR CHILDREN 160 EAST ERIE AVE PHILADELPHIA PA 19134 PHILADELPHIA (215) 427-5000 Childrens Proprietary TRUE 40.0074930 -75.1255350 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-z7p6.dkcr_rdax 393307 650206 2019-06-03 2018-12-31 115 44       29 188               188
3237 ROXBOROUGH MEMORIAL HOSPITAL 5800 RIDGE AVE PHILADELPHIA PA 19128 PHILADELPHIA (215) 483-9900 Acute Care Hospitals Proprietary TRUE 40.0285180 -75.2102800 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-4id2.ryz7~sg28 390304 649947 2019-05-31 2018-12-31 89 18         107 24             131
2973 VALLEY FORGE MEDICAL CENTER AND HOSPITAL 1033 W GERMANTOWN PIKE NORRISTOWN PA 19401 MONTGOMERY (215) 539-8500 Acute Care Hospitals Proprietary FALSE 40.1564300 -75.3686840 0   91 42 42091 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-wedb-6d72.5wef 390272 661256 2019-12-02 2019-06-30 50           50               50
3231 HAHNEMANN UNIVERSITY HOSPITAL 230 NORTH BROAD STREET PHILADELPHIA PA 19102 PHILADELPHIA (215) 762-7000 Acute Care Hospitals Proprietary TRUE 39.9573340 -75.1625970 0   101 42 42101 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Philadelphia County https://data.medicare.gov/resource/xubh-q36u/row-vvi6-9wq6-jdxw 390290 649946 2019-06-03 2018-12-31 311 29 14   16 17 387 20             407
784 LOWER BUCKS HOSPITAL 501 BATH ROAD BRISTOL PA 19007 BUCKS (215) 785-9200 Acute Care Hospitals Proprietary TRUE 40.1040650 -74.8646260 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-3pai_t2mu_egih 390070 651661 2019-05-31 2018-12-31 108 22         130 45             175
3746 PORTER REGIONAL HOSPITAL 85 EAST US HWY 6 VALPARAISO IN 46383 PORTER (219) 983-8300 Acute Care Hospitals Proprietary TRUE 41.5500700 -87.0513160 0   127 18 18127 16980 Chicago-Naperville, IL-IN-WI Central Porter County https://data.medicare.gov/resource/xubh-q36u/row-i5mx.x2ra~mmtd 150035 648101 2019-05-22 2018-12-31 192 32         238   14           252
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
1785 GARDEN PARK MEDICAL CENTER 15200 COMMUNITY ROAD GULFPORT MS 39503 HARRISON (228) 575-7000 Acute Care Hospitals Proprietary TRUE 30.4420100 -89.0927660 0   47 28 28047 25060   Central Harrison County https://data.medicare.gov/resource/xubh-q36u/row-mqi3~42hr_6pv9 250123 660823 2019-11-26 2018-12-31 87 13         100 21             121
2568 SOUTHWELL MEDICAL, A CAMPUS OF TRMC 260 MJ TAYLOR ROAD ADEL GA 31620 COOK (229) 896-8077 Acute Care Hospitals Proprietary TRUE 31.1091810 -83.4263720 0   75 13 13075         https://data.medicare.gov/resource/xubh-q36u/row-9kgg_7cj7~n9m2 110101 660504 2019-12-03 2019-06-30 33           33 12     95       140
2453 TURNING POINT HOSPITAL 3015 VETERANS PARKWAY MOULTRIE GA 31788 COLQUITT (229) 985-4815 Acute Care Hospitals Proprietary FALSE 31.1292470 -83.7735500 0   71 13 13071 34220   Central Colquitt County https://data.medicare.gov/resource/xubh-q36u/row-c7wf~kq6n~bukb 110209 649195 2019-05-29 2018-12-31 33           33 26             59
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
3715 SURGEONS CHOICE MEDICAL CENTER 22401 FOSTER WINTER DRIVE SOUTHFIELD MI 48075 OAKLAND (248) 423-5100 Acute Care Hospitals Proprietary FALSE 42.4573160 -83.2026750 0   125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-7w3x.vira.8q74 230301 654031 2019-06-27 2018-12-31 45           45       26       71
3714 PONTIAC GENERAL HOSPITAL 461 W HURON ST PONTIAC MI 48341 OAKLAND (248) 857-7200 Acute Care Hospitals Proprietary FALSE 42.6356790 -83.3094750 0   125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-crex_bj2q~u4f8 230013 655555 2019-10-10 2018-12-31 37 10         47 30 17           94
3716 HURON VALLEY-SINAI HOSPITAL ONE WILLIAM CARLS DRIVE COMMERCE TOWNSHIP MI 48382 OAKLAND (248) 937-3370 Acute Care Hospitals Proprietary TRUE 42.5925502 -83.4988560 1 ROOFTOP 125 26 26125 19820 Detroit-Warren-Ann Arbor, MI Central Oakland County https://data.medicare.gov/resource/xubh-q36u/row-wtwz.wnac-edau 230277 646341 2019-03-21 2018-10-31 118 12         130               130
989 JACKSON MEDICAL CENTER 220 HOSPITAL DRIVE JACKSON AL 36545 CLARKE (251) 246-9021 Acute Care Hospitals Proprietary TRUE 31.5304820 -87.8931800 0   25 1 1025         https://data.medicare.gov/resource/xubh-q36u/row-p276~rdhi_nmej 10128 651157 2019-06-03 2018-12-31 35           35               35
3075 SPRINGHILL MEMORIAL HOSPITAL 3719 DAUPHIN STREET MOBILE AL 36608 MOBILE (251) 344-9630 Acute Care Hospitals Proprietary TRUE 30.6859460 -88.1317190 0   97 1 1097 33660 Mobile-Daphne-Fairhope, AL Central Mobile County https://data.medicare.gov/resource/xubh-q36u/row-qtdz-mr4h-ggd9 10144 648881 2019-05-29 2018-12-31 178 20         198   11           209
1377 EVERGREEN MEDICAL CENTER 101 CRESTVIEW AVENUE EVERGREEN AL 36401 CONECUH (251) 578-2480 Acute Care Hospitals Proprietary TRUE 31.4312600 -86.9420500 0   35 1 1035         https://data.medicare.gov/resource/xubh-q36u/row-f8ut-az4v~dn63 10148 651159 2019-06-03 2018-12-31 44           44               44
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
4299 MARIA PARHAM MEDICAL CENTER PO BOX 59 HENDERSON NC 27536 VANCE (252) 431-3708 Acute Care Hospitals Proprietary TRUE 36.3338756 -78.3955986 1 APPROXIMATE 181 37 37181 25780 Raleigh-Durham-Chapel Hill, NC Central Vance County https://data.medicare.gov/resource/xubh-q36u/row-cv45-zcn2-4te2 340132 646039 2019-04-02 2018-10-31 71 20         91   11           102
4340 WASHINGTON COUNTY HOSP INC 958 US HWY 64 EAST PLYMOUTH NC 27962 WASHINGTON (252) 793-4135 Critical Access Hospitals Proprietary TRUE 35.8479840 -76.7558380 0   187 37 37187         https://data.medicare.gov/resource/xubh-q36u/row-x8x8-fegi-en3k 341314 640726 2019-01-02 2018-09-30 25           25               25
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
4554 PARKVIEW REGIONAL HOSPITAL 600 SOUTH BONHAM STREET MEXIA TX 76667 LIMESTONE (254) 562-5332 Acute Care Hospitals Proprietary TRUE 31.6750590 -96.4800130 0   293 48 48293         https://data.medicare.gov/resource/xubh-q36u/row-eqsz~67zm-42nm 450400 653518 2019-09-05 2019-03-31 43 6         49 9             58
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
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
2099 RUSSELLVILLE HOSPITAL 15155 HIGHWAY 43 RUSSELLVILLE AL 35653 FRANKLIN (256) 332-1611 Acute Care Hospitals Proprietary TRUE 34.5111650 -87.7175850 0   59 1 1059         https://data.medicare.gov/resource/xubh-q36u/row-gwv9.74md~fuic 10158 645962 2019-04-01 2018-12-31 42 7         49               49
1990 GADSDEN REGIONAL MEDICAL CENTER 1007 GOODYEAR AVENUE GADSDEN AL 35903 ETOWAH (256) 494-4000 Acute Care Hospitals Proprietary TRUE 34.0093890 -85.9675200 0   55 1 1055 23460   Central Etowah County https://data.medicare.gov/resource/xubh-q36u/row-bfqk~mdpt-2yrq 10040 644005 2019-02-27 2018-09-30 182 40         222 49             271
1991 RIVERVIEW REGIONAL MEDICAL CENTER 600 SOUTH THIRD STREET GADSDEN AL 35901 ETOWAH (256) 543-5200 Acute Care Hospitals Proprietary TRUE 34.0038110 -86.0040860 0   55 1 1055 23460   Central Etowah County https://data.medicare.gov/resource/xubh-q36u/row-82ed.hku7_uzsa 10046 653738 2019-08-23 2018-12-31 240   16       256 25             281
2589 NORTH ALABAMA MEDICAL CENTER 1701 VETERANS DRIVE FLORENCE AL 35630 LAUDERDALE (256) 768-8400 Acute Care Hospitals Proprietary TRUE 34.8027560 -87.6521910 0   77 1 1077 22520   Central Lauderdale County https://data.medicare.gov/resource/xubh-q36u/row-n9pr_q6au_cg3t 10006 660158 2019-12-02 2019-06-30 181 36 16       233               233
3670 LAKE MARTIN COMMUNITY HOSPITAL 201 MARIARDEN ROAD DADEVILLE AL 36853 TALLAPOOSA (256) 825-7821 Acute Care Hospitals Proprietary TRUE 32.8187000 -85.7417580 0   123 1 1123         https://data.medicare.gov/resource/xubh-q36u/row-7irr_xm4w_yyg3 10052 649861 2019-05-29 2018-12-31 46           46               46
1826 DEKALB REGIONAL MEDICAL CENTER 200 MED CENTER DRIVE FORT PAYNE AL 35968 DE KALB (256) 845-3150 Acute Care Hospitals Proprietary TRUE 34.4419753 -85.7550138 1 ROOFTOP 49 1 1049         https://data.medicare.gov/resource/xubh-q36u/row-pt4k~hfcs.k9m2 10012 653737 2019-08-22 2019-03-31 85 12         97 18             115
2878 CRESTWOOD MEDICAL CENTER ONE HOSPITAL DR SE HUNTSVILLE AL 35801 MADISON (256) 882-3100 Acute Care Hospitals Proprietary TRUE 34.6943814 -86.5720291 1 ROOFTOP 89 1 1089 26620 Huntsville-Decatur-Albertville, AL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-tkhv~u3mn_apnu 10131 659468 2019-11-27 2019-06-30 164 16         183               183
166 DUPONT HOSPITAL LLC 2520 E DUPONT RD FORT WAYNE IN 46825 ALLEN (260) 416-3000 Acute Care Hospitals Proprietary TRUE 41.1786890 -85.1106030 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-q73v-xd2h_rmgd 150150 654122 2019-09-04 2019-03-31 92 10         131               131
167 ST JOSEPH HOSPITAL 700 BROADWAY FORT WAYNE IN 46802 ALLEN (260) 425-3000 Acute Care Hospitals Proprietary TRUE 41.0788910 -85.1488730 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-kr9f_9zxq-kk6p 150047 655893 2019-10-31 2019-05-31 76     12     88 19     20       127
168 THE ORTHOPAEDIC HOSPITAL OF LUTHERAN HEALTH NETWOR 7952 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-2999 Acute Care Hospitals Proprietary FALSE 41.0373520 -85.2459180 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-65sn_hsdz_dbbf 150168 649728 2019-06-03 2018-12-31 39           39               39
165 LUTHERAN HOSPITAL OF INDIANA 7950 W JEFFERSON BLVD FORT WAYNE IN 46804 ALLEN (260) 435-7001 Acute Care Hospitals Proprietary TRUE 41.0373740 -85.2458850 0   3 18 18003 23060 Fort Wayne-Huntington-Auburn, IN Central Allen County https://data.medicare.gov/resource/xubh-q36u/row-22sz~6zvg.fbpc 150017 661886 2019-12-03 2019-06-30 254   24       396               396
4285 BLUFFTON REGIONAL MEDICAL CENTER 303 S MAIN ST BLUFFTON IN 46714 WELLS (260) 824-3210 Acute Care Hospitals Proprietary TRUE 40.7376450 -85.1714940 0   179 18 18179 23060 Fort Wayne-Huntington-Auburn, IN Outlying Wells County https://data.medicare.gov/resource/xubh-q36u/row-7d75-xz4v.txjj 150075 645405 2019-03-01 2018-09-30 55 7         62       13       75
787 BARIX CLINICS OF PENNSYLVANIA 280 MIDDLETOWN ROAD LANGHORNE PA 19047 BUCKS (267) 572-3100 Acute Care Hospitals Proprietary FALSE 40.1818010 -74.8845420 0   17 42 42017 37980 Philadelphia-Reading-Camden, PA-NJ-DE-MD Central Bucks County https://data.medicare.gov/resource/xubh-q36u/row-bu4h.v5rj.beuc 390302 651664 2019-07-03 2018-12-31 23           23               23
1019 BRONSON BATTLE CREEK HOSPITAL 300 NORTH AVENUE BATTLE CREEK MI 49017 CALHOUN (269) 966-8000 Acute Care Hospitals Proprietary TRUE 42.3306180 -85.1804040 0   25 26 26025 12980 Kalamazoo-Battle Creek-Portage, MI Central Calhoun County https://data.medicare.gov/resource/xubh-q36u/row-he35.kjhz.63u8 230075 649448 2019-05-29 2018-12-31 139 20         159 39             198
4309 OHIO COUNTY HOSPITAL 1211 OLD MAIN STREET HARTFORD KY 42347 OHIO (270) 298-7411 Critical Access Hospitals Proprietary TRUE 37.4476490 -86.8964740 0   183 21 21183         https://data.medicare.gov/resource/xubh-q36u/row-jams.uqap-8mmi 181323 645091 2019-03-12 2018-09-30 21 4         25               25
4079 SPRING VIEW HOSPITAL 320 LORETTO ROAD LEBANON KY 40033 MARION (270) 692-5145 Acute Care Hospitals Proprietary TRUE 37.5703250 -85.2593970 0   155 21 21155         https://data.medicare.gov/resource/xubh-q36u/row-ri6m~j23x~rpdu 180024 643767 2019-02-28 2018-09-30 57 6         63 12             75
3918 LOGAN MEMORIAL HOSPITAL 1625 NASHVILLE STREET RUSSELLVILLE KY 42276 LOGAN (270) 726-4011 Acute Care Hospitals Proprietary TRUE 36.8154370 -86.8825930 0   141 21 21141         https://data.medicare.gov/resource/xubh-q36u/row-kw6k-zetw_vziz 180066 652353 2019-08-01 2019-02-28 69 6         75               75
4496 TRISTAR GREENVIEW REGIONAL HOSPITAL 1801 ASHLEY CIRCLE BOWLING GREEN KY 42104 WARREN (270) 793-1000 Acute Care Hospitals Proprietary TRUE 36.9656720 -86.4355990 0   227 21 21227 14540 Bowling Green-Glasgow, KY Central Warren County https://data.medicare.gov/resource/xubh-q36u/row-2zzw_pa4z_rrd4 180124 655448 2019-10-18 2018-09-30 146 16         162               162
4739 TWIN COUNTY REGIONAL HOSPITAL 200 HOSPITAL DRIVE GALAX VA 24333 GALAX CITY (276) 236-8181 Acute Care Hospitals Proprietary TRUE 36.6718130 -80.9238140 0   640 51 51640         https://data.medicare.gov/resource/xubh-q36u/row-scan.4a2b.zisp 490115 643992 2019-02-28 2018-09-30 131 10         141               141
4332 CLINCH VALLEY MEDICAL CENTER 6801 GOVERNOR GC PERRY HIGHWAY RICHLANDS VA 24641 TAZEWELL (276) 596-6000 Acute Care Hospitals Proprietary TRUE 37.0939780 -81.8194440 0   185 51 51185 14140   Central Tazewell County https://data.medicare.gov/resource/xubh-q36u/row-x352_282g.42tv 490060 648023 2019-05-02 2018-11-30 139 12         151       19       170
4442 HEALTHBRIDGE CHILDRENS'S HOSPITAL OF HOUSTON 2929 WOODLAND PARK DRIVE HOUSTON TX 77082 HARRIS (281) 293-7774 Childrens Proprietary FALSE 29.7323170 -95.5805930 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-nwq8.dchf-ph6y 453309 649148 2019-05-31 2018-12-31 40           40               40
4588 MEMORIAL HERMANN SURGICAL HOSPITAL KINGWOOD 300 KINGWOOD MEDICAL DRIVE KINGWOOD TX 77339 HARRIS (281) 312-4000 Acute Care Hospitals Proprietary TRUE 30.0471980 -95.2579490 0   339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-v6he.gqvr.a5ws 670005 648513 2019-05-21 2018-12-31 10           10               10
4415 HCA HOUSTON HEALTHCARE CLEAR LAKE 500 MEDICAL CENTER BLVD WEBSTER TX 77598 HARRIS (281) 332-2511 Acute Care Hospitals Proprietary TRUE 29.5410620 -95.1262740 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-yjyj_jp52-vmf5 450617 662265 2019-12-19 2018-12-31 446 86         532 5 41           578
4417 HCA HOUSTON HEALTHCARE TOMBALL 605 HOLDERRIETH TOMBALL TX 77375 HARRIS (281) 351-1623 Acute Care Hospitals Proprietary TRUE 30.0887030 -95.6239850 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-qwg3~p4ci.ubu8 450670 659543 2019-11-25 2019-06-30 167 20       7 194 21 26           241
4584 HCA HOUSTON HEALTHCARE KINGWOOD 22999 US HWY 59 KINGWOOD TX 77325 HARRIS (281) 359-7500 Acute Care Hospitals Proprietary TRUE 30.0500599 -95.2552222 1 ROOFTOP 339 48 48339 26420 Houston-The Woodlands, TX Outlying Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-7cnb.g98t-w5nn 450775 654556 2019-09-10 2018-09-30 406 42       24 494   27           521
4414 HCA HOUSTON HEALTHCARE NORTHWEST 710 CYPRESS CREEK PARKWAY HOUSTON TX 77090 HARRIS (281) 440-1000 Acute Care Hospitals Proprietary TRUE 30.0180990 -95.4397960 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-5gjz_q6bh_rqe9 450638 656000 2019-11-01 2019-05-31 240 38       10 288   24           312
4427 PROVIDENCE HOSPITAL OF NORTH HOUSTON LLC 16750 RED OAK DRIVE HOUSTON TX 77090 HARRIS (281) 453-7916 Acute Care Hospitals Proprietary TRUE 30.0142780 -95.4409351 1 ROOFTOP 201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-akm5~pcmt~sgnr 670119 648515 2019-05-30 2018-12-31 16           16               16
4423 MEMORIAL HERMANN FIRST COLONY HOSPITAL 24429 TOMBALL PARKWAY, SUITE 100 TOMBALL TX 77375 HARRIS (281) 516-0911 Acute Care Hospitals Proprietary FALSE 30.0371760 -95.6053230 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-wtak~qp2w~qmyj 670095 649016 2019-05-30 2018-12-31 15           15               15
4416 HCA HOUSTON HEALTHCARE WEST 12141 RICHMOND AVE HOUSTON TX 77082 HARRIS (281) 588-8080 Acute Care Hospitals Proprietary TRUE 29.7303140 -95.5947500 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-dji8~3wmy~qmrn 450644 661665 2019-12-11 2018-12-31 202 28         230 14 12           256
4551 CLEVELAND EMERGENCY HOSPITAL 1017 S TRAVIS AVE CLEVELAND TX 77327 LIBERTY (281) 592-5400 Acute Care Hospitals Proprietary TRUE 30.3294340 -95.0960570 0   291 48 48291 26420 Houston-The Woodlands, TX Outlying Liberty County https://data.medicare.gov/resource/xubh-q36u/row-3yf9_ucey-48hx 670115 650933 2019-06-03 2018-12-31 16           16               16
1336 DOCTORS' COMMUNITY HOSPITAL 8118 GOOD LUCK ROAD LANHAM MD 20706 PRINCE GEORGES (301) 552-8118 Acute Care Hospitals Proprietary TRUE 38.9804280 -76.8646410 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-uj8j-wkyg-hv4a 210051 655722 2019-10-25 2019-06-30 168 22         190               190
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
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
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
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
2671 RALEIGH GENERAL HOSPITAL 1710 HARPER ROAD BECKLEY WV 25801 RALEIGH (304) 256-4100 Acute Care Hospitals Proprietary TRUE 37.7864580 -81.2031030 0   81 54 54081 13220   Central Raleigh County https://data.medicare.gov/resource/xubh-q36u/row-imqm-cjnw~q5ww 510070 656810 2019-10-31 2019-05-31 268 16 16       300               300

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