hospital_data
Data source: Big Local News · About: big-local-datasette
53 rows where "filed_date" is on date 2019-05-30 and hospital_ownership = "Proprietary"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, icu_beds, coronary_beds, burn_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, filed_date (date), fy_end_date (date)
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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
144 | 144 | MANCHESTER MEMORIAL HOSPITAL | 71 HAYNES ST | MANCHESTER | CT | 6040 | HARTFORD | (860) 647-4780 | Acute Care Hospitals | Proprietary | TRUE | 41.7810870 | -72.5252210 | 0 | 3 | 9 | 9003 | 25540 | Hartford-West Hartford, CT | Central | Hartford County | https://data.medicare.gov/resource/xubh-q36u/row-shzd.8q5k_ybhg | 70027 | 650673 | 2019-05-30 | 2018-12-31 | 108 | 32 | 140 | 31 | 171 | |||||||||||
200 | 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 | ||||||||||||
204 | 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 | ||||||||||||
339 | 339 | OZARKS COMMUNITY HOSPITAL OF GRAVETTE | 1101 JACKSON STREET SW | GRAVETTE | AR | 72736 | BENTON | (479) 787-5291 | Critical Access Hospitals | Proprietary | TRUE | 36.4085630 | -94.4598700 | 0 | 7 | 5 | 5007 | 22220 | Central | Benton County | https://data.medicare.gov/resource/xubh-q36u/row-snva.mem9_cs94 | 41331 | 651314 | 2019-05-30 | 2018-12-31 | 25 | 25 | 25 | ||||||||||||||
385 | 385 | OUR LADY OF FATIMA HOSPITAL | 200 HIGH SERVICE AVENUE | NORTH PROVIDENCE | RI | 2904 | PROVIDENCE | (401) 456-3000 | Acute Care Hospitals | Proprietary | TRUE | 41.8557960 | -71.4584980 | 0 | 7 | 44 | 44007 | 39300 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Providence County | https://data.medicare.gov/resource/xubh-q36u/row-ya2z~83y5.tnki | 410005 | 650779 | 2019-05-30 | 2018-12-31 | 148 | 15 | 163 | 124 | 25 | 312 | ||||||||||
386 | 386 | ROGER WILLIAMS MEDICAL CENTER | 825 CHALKSTONE AVENUE | PROVIDENCE | RI | 2908 | PROVIDENCE | (401) 456-2025 | Acute Care Hospitals | Proprietary | TRUE | 41.8340150 | -71.4345800 | 0 | 7 | 44 | 44007 | 39300 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Providence County | https://data.medicare.gov/resource/xubh-q36u/row-k87m-wjy5_7p2x | 410004 | 650778 | 2019-05-30 | 2018-12-31 | 134 | 14 | 148 | 12 | 160 | |||||||||||
413 | 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 | |||||||||||
597 | 597 | ROCKVILLE GENERAL HOSPITAL | 31 UNION ST | ROCKVILLE | CT | 6066 | TOLLAND | (860) 872-5160 | Acute Care Hospitals | Proprietary | TRUE | 41.8669620 | -72.4509880 | 0 | 13 | 9 | 9013 | 25540 | Hartford-West Hartford, CT | Central | Tolland County | https://data.medicare.gov/resource/xubh-q36u/row-fjuu~c5fd_6w23 | 70012 | 650672 | 2019-05-30 | 2018-12-31 | 93 | 9 | 102 | 130 | 232 | |||||||||||
953 | 953 | SOUTH CAMERON MEMORIAL HOSPITAL | 5360 WEST CREOLE HWY | CAMERON | LA | 70631 | CAMERON | (337) 542-4111 | Acute Care Hospitals | Proprietary | TRUE | 29.8071730 | -93.1652450 | 0 | 23 | 22 | 22023 | 29340 | Outlying | Cameron Parish | https://data.medicare.gov/resource/xubh-q36u/row-59pq~i76h_a9yh | 190307 | 648537 | 2019-05-30 | 2018-12-31 | 25 | 25 | 24 | 49 | |||||||||||||
961 | 961 | POPLAR BLUFF REGIONAL MEDICAL CENTER | 3100 OAK GROVE ROAD | POPLAR BLUFF | MO | 63901 | BUTLER | (573) 785-7721 | Acute Care Hospitals | Proprietary | TRUE | 36.7889870 | -90.4432870 | 0 | 23 | 29 | 29023 | 38740 | Central | Butler County | https://data.medicare.gov/resource/xubh-q36u/row-ats4-xdcp~iw65 | 260119 | 649121 | 2019-05-30 | 2018-12-31 | 206 | 14 | 220 | 12 | 232 | ||||||||||||
1011 | 1011 | SHRINERS' HOSPITAL FOR CHILDREN - BOSTON, THE | 51 BLOSSOM STREET | BOSTON | MA | 2114 | SUFFOLK | (617) 722-3000 | Childrens | Proprietary | FALSE | 42.3630790 | -71.0669040 | 0 | 25 | 25 | 25025 | 14460 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Suffolk County | https://data.medicare.gov/resource/xubh-q36u/row-pfzw.md7z-rufe | 223304 | 652751 | 2019-05-30 | 2018-12-31 | ||||||||||||||||
1030 | 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 | |||||||||||
1090 | 1090 | SAINT CLARE'S HOSPITAL/ DENVILLE CAMPUS | 25 POCONO ROAD | DENVILLE | NJ | 7834 | MORRIS | (973) 983-5569 | Acute Care Hospitals | Proprietary | TRUE | 40.8943760 | -74.4644790 | 0 | 27 | 34 | 34027 | 35620 | New York-Newark, NY-NJ-CT-PA | Central | Morris County | https://data.medicare.gov/resource/xubh-q36u/row-esnm_pmpi~hgpj | 310050 | 651221 | 2019-05-30 | 2018-12-31 | 284 | 25 | 16 | 325 | 42 | 367 | ||||||||||
1109 | 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 | |||||||||||||||||
1176 | 1176 | NIX HEALTH CARE SYSTEM | 414 NAVARRO, SUITE 600 | SAN ANTONIO | TX | 78205 | BEXAR | (210) 271-2188 | Acute Care Hospitals | Proprietary | TRUE | 29.4255770 | -98.4897180 | 0 | 29 | 48 | 48029 | 41700 | Central | Bexar County | https://data.medicare.gov/resource/xubh-q36u/row-6ir7_mgdd.hab9 | 450130 | 648576 | 2019-05-30 | 2018-12-31 | 189 | 12 | 201 | 33 | 18 | 252 | |||||||||||
1189 | 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 | ||||||||||||||
1288 | 1288 | ST MARY'S GENERAL HOSPITAL | 350 BOULEVARD | PASSAIC | NJ | 7055 | PASSAIC | (973) 365-4300 | Acute Care Hospitals | Proprietary | TRUE | 40.8582800 | -74.1372100 | 0 | 31 | 34 | 34031 | 35620 | New York-Newark, NY-NJ-CT-PA | Central | Passaic County | https://data.medicare.gov/resource/xubh-q36u/row-aiiy.n2qz_h3vu | 310006 | 648719 | 2019-05-30 | 2018-12-31 | 120 | 25 | 145 | 145 | ||||||||||||
1455 | 1455 | SOUTHERN CALIFORNIA HOSPITAL AT HOLLYWOOD | 6245 DE LONGPRE AVE | HOLLYWOOD | CA | 90028 | LOS ANGELES | (323) 462-2271 | Acute Care Hospitals | Proprietary | TRUE | 34.0961920 | -118.3253710 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-k6q2.64iy.buw8 | 50135 | 652414 | 2019-05-30 | 2018-12-31 | 531 | 15 | 13 | 559 | 32 | 21 | 612 | |||||||||
1462 | 1462 | LOS ANGELES COMMUNITY HOSPITAL | 4081 E OLYMPIC BLVD | LOS ANGELES | CA | 90023 | LOS ANGELES | (323) 267-0477 | Acute Care Hospitals | Proprietary | TRUE | 34.0188740 | -118.1864610 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-rprf_mcdz_p4qe | 50663 | 649540 | 2019-05-30 | 2018-12-31 | 263 | 22 | 285 | 39 | 324 | |||||||||||
1502 | 1502 | WEST COVINA MEDICAL CENTER, INC | 725 S ORANGE AVE | WEST COVINA | CA | 91790 | LOS ANGELES | (626) 338-8481 | Acute Care Hospitals | Proprietary | FALSE | 34.0709280 | -117.9441660 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-mrqt_jczt_crz9 | 50096 | 652580 | 2019-05-30 | 2018-12-31 | 13 | 13 | 33 | 46 | ||||||||||||
1519 | 1519 | ENCINO HOSPITAL MEDICAL CENTER | 16237 VENTURA BLVD | ENCINO | CA | 91436 | LOS ANGELES | (818) 995-5000 | Acute Care Hospitals | Proprietary | FALSE | 34.1568260 | -118.4869480 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-9gh4~7pmm-pjtp | 50158 | 652415 | 2019-05-30 | 2018-12-31 | 60 | 22 | 82 | 13 | 25 | 28 | 148 | |||||||||
1713 | 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 | ||||||||||||
1933 | 1933 | SOUTHERN TENNESSEE REGIONAL HLTH SYSTEM WINCHESTER | 185 HOSPITAL ROAD | WINCHESTER | TN | 37398 | FRANKLIN | (931) 967-8295 | Acute Care Hospitals | Proprietary | TRUE | 35.1760230 | -86.0910760 | 0 | 51 | 47 | 47051 | 46100 | Outlying | Franklin County | https://data.medicare.gov/resource/xubh-q36u/row-au3a_wp3s-29ym | 440058 | 651234 | 2019-05-30 | 2018-12-31 | 118 | 10 | 128 | 12 | 12 | 46 | 198 | ||||||||||
2120 | 2120 | FOOTHILL REGIONAL MEDICAL CENTER | 14662 NEWPORT AVE | TUSTIN | CA | 92780 | ORANGE | (714) 619-7700 | Acute Care Hospitals | Proprietary | FALSE | 33.7307730 | -117.8294850 | 0 | 59 | 6 | 6059 | 31080 | Los Angeles-Long Beach, CA | Central | Orange County | https://data.medicare.gov/resource/xubh-q36u/row-sm2c.wjav~dxth | 50780 | 648890 | 2019-05-30 | 2018-12-31 | 120 | 15 | 135 | 42 | 177 | |||||||||||
2229 | 2229 | HARLINGEN MEDICAL CENTER | 5501 SOUTH EXPRESSWAY 77 | HARLINGEN | TX | 78550 | CAMERON | (956) 365-1000 | Acute Care Hospitals | Proprietary | TRUE | 26.1573230 | -97.6769680 | 0 | 61 | 48 | 48061 | 15180 | Brownsville-Harlingen-Raymondville, TX | Central | Cameron County | https://data.medicare.gov/resource/xubh-q36u/row-y5xq.uxm4~ujtf | 450855 | 648991 | 2019-05-30 | 2018-12-31 | 80 | 14 | 112 | 112 | ||||||||||||
2264 | 2264 | NORTH CAROLINA SPECIALTY HOSPITAL | 3916 BEN FRANKLIN BOULEVARD | DURHAM | NC | 27704 | DURHAM | (919) 956-9300 | Acute Care Hospitals | Proprietary | FALSE | 36.0428650 | -78.8975480 | 0 | 63 | 37 | 37063 | 20500 | Raleigh-Durham-Chapel Hill, NC | Central | Durham County | https://data.medicare.gov/resource/xubh-q36u/row-qk28.yf4v-b8w5 | 340049 | 650337 | 2019-05-30 | 2018-12-31 | 18 | 18 | 18 | |||||||||||||
2517 | 2517 | ALVARADO HOSPITAL MEDICAL CENTER | 6655 ALVARADO ROAD | SAN DIEGO | CA | 92120 | SAN DIEGO | (619) 229-3172 | Acute Care Hospitals | Proprietary | TRUE | 32.7771360 | -117.0566020 | 0 | 73 | 6 | 6073 | 41740 | Central | San Diego County | https://data.medicare.gov/resource/xubh-q36u/row-nt9q.cx94-9sbi | 50757 | 648888 | 2019-05-30 | 2018-12-31 | 226 | 28 | 254 | 50 | 304 | ||||||||||||
2691 | 2691 | MANATEE MEMORIAL HOSPITAL | 206 2ND ST E | BRADENTON | FL | 34208 | MANATEE | (941) 746-5111 | Acute Care Hospitals | Proprietary | TRUE | 27.4972090 | -82.5612410 | 0 | 81 | 12 | 12081 | 35840 | North Port-Sarasota, FL | Central | Manatee County | https://data.medicare.gov/resource/xubh-q36u/row-8dn6~8qtb.vm5v | 100035 | 649713 | 2019-05-30 | 2018-12-31 | 254 | 35 | 295 | 295 | ||||||||||||
2814 | 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 | ||||||||||||
2828 | 2828 | WESTCHESTER GENERAL HOSPITAL | 2500 SW 75TH AVE | MIAMI | FL | 33155 | MIAMI-DADE | (305) 263-9270 | Acute Care Hospitals | Proprietary | TRUE | 25.7480400 | -80.3172240 | 0 | 86 | 12 | 12086 | 33100 | Miami-Fort Lauderdale-Port St. Lucie, FL | Central | Miami-Dade County | https://data.medicare.gov/resource/xubh-q36u/row-c5ca_542y.hxzz | 100284 | 651511 | 2019-05-30 | 2018-12-31 | 90 | 8 | 98 | 27 | 125 | |||||||||||
2883 | 2883 | SHASTA REGIONAL MEDICAL CENTER | 1100 BUTTE ST | REDDING | CA | 96001 | SHASTA | (530) 244-5454 | Acute Care Hospitals | Proprietary | TRUE | 40.5853760 | -122.3866830 | 0 | 89 | 6 | 6089 | 39820 | Redding-Red Bluff, CA | Central | Shasta County | https://data.medicare.gov/resource/xubh-q36u/row-444t_kxts-infi | 50764 | 648889 | 2019-05-30 | 2018-12-31 | 168 | 37 | 205 | 21 | 226 | |||||||||||
3055 | 3055 | ST JOSEPH MEDICAL CENTER | 1000 CARONDELET DR | KANSAS CITY | MO | 64114 | JACKSON | (816) 942-4400 | Acute Care Hospitals | Proprietary | TRUE | 38.9344710 | -94.6053420 | 0 | 95 | 29 | 29095 | 28140 | Kansas City-Overland Park-Kansas City, MO-KS | Central | Jackson County | https://data.medicare.gov/resource/xubh-q36u/row-risq_3sj8-p556 | 260085 | 649119 | 2019-05-30 | 2018-12-31 | 111 | 16 | 127 | 14 | 141 | |||||||||||
3177 | 3177 | SURGICAL HOSPITAL AT SOUTHWOODS | 7630 SOUTHERN BLVD | YOUNGSTOWN | OH | 44512 | MAHONING | (330) 729-8000 | Acute Care Hospitals | Proprietary | FALSE | 41.0153550 | -80.6534390 | 0 | 99 | 39 | 39099 | 49660 | Youngstown-Warren, OH-PA | Central | Mahoning County | https://data.medicare.gov/resource/xubh-q36u/row-422i~a2cq-j6nr | 360352 | 648972 | 2019-05-30 | 2018-12-31 | 24 | 24 | 24 | |||||||||||||
3488 | 3488 | MEDICAL CITY LAS COLINAS | 6800 N MACARTHUR BLVD | IRVING | TX | 75039 | DALLAS | (972) 969-2000 | Acute Care Hospitals | Proprietary | TRUE | 32.9020470 | -96.9586790 | 0 | 113 | 48 | 48113 | 19100 | Dallas-Fort Worth, TX-OK | Central | Dallas County | https://data.medicare.gov/resource/xubh-q36u/row-wvh9-krw7~fy64 | 450822 | 649140 | 2019-05-30 | 2018-12-31 | 66 | 8 | 6 | 80 | 80 | |||||||||||
3499 | 3499 | DALLAS MEDICAL CENTER | 7 MEDICAL PARKWAY | DALLAS | TX | 75234 | DALLAS | (972) 247-1000 | Acute Care Hospitals | Proprietary | TRUE | 32.9143350 | -96.8730980 | 0 | 113 | 48 | 48113 | 19100 | Dallas-Fort Worth, TX-OK | Central | Dallas County | https://data.medicare.gov/resource/xubh-q36u/row-hw8i~2d9s~wysi | 450379 | 650528 | 2019-05-30 | 2018-12-31 | 107 | 12 | 119 | 119 | ||||||||||||
3502 | 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 | ||||||||||||
3510 | 3510 | FIRST TEXAS HOSPITAL CARROLLTON LLC | 1401 E TRINITY MILLS ROAD | CARROLLTON | TX | 75006 | DALLAS | (972) 810-0700 | Acute Care Hospitals | Proprietary | TRUE | 32.9850010 | -96.8982210 | 0 | 113 | 48 | 48113 | 19100 | Dallas-Fort Worth, TX-OK | Central | Dallas County | https://data.medicare.gov/resource/xubh-q36u/row-pssx_vyvi-xhzt | 670110 | 651438 | 2019-05-30 | 2018-12-31 | 18 | 18 | 18 | |||||||||||||
3658 | 3658 | BAYLOR SCOTT AND WHITE EMERGENCY HOSPITAL AUBREY | 26791 HIGHWAY 380 | AUBREY | TX | 76227 | DENTON | (972) 347-2525 | Acute Care Hospitals | Proprietary | TRUE | 33.2206581 | -96.9135249 | 1 | ROOFTOP | 121 | 48 | 48121 | 19100 | Dallas-Fort Worth, TX-OK | Outlying | Denton County | https://data.medicare.gov/resource/xubh-q36u/row-9pb6.v6ys-8mdu | 670062 | 649013 | 2019-05-30 | 2018-12-31 | 40 | 40 | 40 | ||||||||||||
3661 | 3661 | TEXAS HEALTH PRESBYTERIAN HOSPITAL FLOWER MOUND | 4400 LONG PRAIRIE ROAD | FLOWER MOUND | TX | 75028 | DENTON | (972) 419-1530 | Acute Care Hospitals | Proprietary | TRUE | 33.0452270 | -97.0693310 | 0 | 121 | 48 | 48121 | 19100 | Dallas-Fort Worth, TX-OK | Outlying | Denton County | https://data.medicare.gov/resource/xubh-q36u/row-cv43_dzrr_v22n | 670068 | 650226 | 2019-05-30 | 2018-12-31 | 91 | 8 | 99 | 99 | ||||||||||||
3759 | 3759 | DUNES SURGICAL HOSPITAL | 600 N SIOUX POINT ROAD | DAKOTA DUNES | SD | 57049 | UNION | (605) 232-3332 | Acute Care Hospitals | Proprietary | FALSE | 42.5047530 | -96.4968160 | 0 | 127 | 46 | 46127 | 43580 | Sioux City-Vermillion, IA-SD-NE | Central | Union County | https://data.medicare.gov/resource/xubh-q36u/row-c5z7~7eiv-hfta | 430089 | 650781 | 2019-05-30 | 2018-12-31 | 38 | 38 | 38 | |||||||||||||
3777 | 3777 | INDIANHEAD MEDICAL CENTER SHELL LAKE | 113 4TH AVE | SHELL LAKE | WI | 54871 | WASHBURN | (715) 468-7833 | Critical Access Hospitals | Proprietary | TRUE | 45.7421020 | -91.9257800 | 0 | 129 | 55 | 55129 | https://data.medicare.gov/resource/xubh-q36u/row-kcr4.6q2e-4e5f | 521342 | 650795 | 2019-05-30 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||||||
3781 | 3781 | DOCTORS' CENTER HOSPITAL SAN JUAN | PDA. 20 C/ SAN RAFAEL # 1395 | FERNANDEZ JUNCOS | PR | 909 | SAN JUAN | (787) 723-2950 | Acute Care Hospitals | Proprietary | TRUE | 18.4446749 | -66.0761443 | 1 | RANGE_INTERPOLATED | 127 | 72 | 72127 | 41980 | San Juan-Carolina, PR | Central | San Juan Municipio | https://data.medicare.gov/resource/xubh-q36u/row-u5ha_su64_x3jd | 400006 | 649492 | 2019-05-30 | 2018-12-31 | 123 | 6 | 129 | 129 | |||||||||||
3933 | 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 | |||||||||||||
4159 | 4159 | DETROIT RECEIVING HOSPITAL & UNIV HEALTH CENTER | 4201 ST ANTOINE ST - 2C | DETROIT | MI | 48201 | WAYNE | (313) 745-3104 | Acute Care Hospitals | Proprietary | TRUE | 42.3535426 | -83.0550940 | 1 | ROOFTOP | 163 | 26 | 26163 | 19820 | Detroit-Warren-Ann Arbor, MI | Central | Wayne County | https://data.medicare.gov/resource/xubh-q36u/row-niud-7c22~chx9 | 230273 | 649265 | 2019-05-30 | 2018-12-31 | 134 | 28 | 12 | 9 | 12 | 195 | 19 | 214 | |||||||
4162 | 4162 | CHILDREN'S HOSPITAL OF MICHIGAN | 3901 BEAUBIEN STREET | DETROIT | MI | 48201 | WAYNE | (313) 745-5437 | Childrens | Proprietary | TRUE | 42.3518160 | -83.0537500 | 0 | 163 | 26 | 26163 | 19820 | Detroit-Warren-Ann Arbor, MI | Central | Wayne County | https://data.medicare.gov/resource/xubh-q36u/row-z5kc-2ncc~crci | 233300 | 649116 | 2019-05-30 | 2018-12-31 | 122 | 48 | 19 | 39 | 228 | 228 | ||||||||||
4168 | 4168 | SINAI-GRACE HOSPITAL | 6071 W OUTER DRIVE | DETROIT | MI | 48235 | WAYNE | (313) 966-3300 | Acute Care Hospitals | Proprietary | TRUE | 42.4201020 | -83.1814710 | 0 | 163 | 26 | 26163 | 19820 | Detroit-Warren-Ann Arbor, MI | Central | Wayne County | https://data.medicare.gov/resource/xubh-q36u/row-xx67-s2aj_ub5i | 230024 | 649114 | 2019-05-30 | 2018-12-31 | 296 | 39 | 3 | 19 | 357 | 21 | 12 | 390 | ||||||||
4248 | 4248 | WESLEY MEDICAL CENTER | 550 N HILLSIDE STREET | WICHITA | KS | 67214 | SEDGWICK | (316) 962-2000 | Acute Care Hospitals | Proprietary | TRUE | 37.6954890 | -97.2990580 | 0 | 173 | 20 | 20173 | 48620 | Wichita-Arkansas City-Winfield, KS | Central | Sedgwick County | https://data.medicare.gov/resource/xubh-q36u/row-fncw-tisj.5akn | 170123 | 649109 | 2019-05-30 | 2018-12-31 | 435 | 93 | 26 | 593 | 593 | |||||||||||
4423 | 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 | |||||||||||||
4424 | 4424 | AD HOSPITAL EAST, LLC | 12950 EAST FREEWAY, SUITE 100 | HOUSTON | TX | 77015 | HARRIS | (713) 330-3897 | Acute Care Hospitals | Proprietary | TRUE | 29.7711360 | -95.2007820 | 0 | 201 | 48 | 48201 | 26420 | Houston-The Woodlands, TX | Central | Harris County | https://data.medicare.gov/resource/xubh-q36u/row-g9pj_7cms.hams | 670102 | 649155 | 2019-05-30 | 2018-12-31 | 4 | 4 | 4 | |||||||||||||
4426 | 4426 | FIRST TEXAS HOSPITAL | 9922 LOUETTA RD | HOUSTON | TX | 77070 | HARRIS | (844) 264-1435 | Acute Care Hospitals | Proprietary | TRUE | 30.0008390 | -95.5608680 | 0 | 201 | 48 | 48201 | 26420 | Houston-The Woodlands, TX | Central | Harris County | https://data.medicare.gov/resource/xubh-q36u/row-t68p~4ggy.94di | 670118 | 649157 | 2019-05-30 | 2018-12-31 | 12 | 12 | 12 | |||||||||||||
4427 | 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 | ||||||||||||
4643 | 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 | |||||||||||||
4650 | 4650 | TEXAS HEALTH HEART & VASCULAR HOSPITAL ARLINGTON | 811 WRIGHT STREET | ARLINGTON | TX | 76012 | TARRANT | (817) 960-3500 | Acute Care Hospitals | Proprietary | FALSE | 32.7482060 | -97.1163900 | 0 | 439 | 48 | 48439 | 19100 | Dallas-Fort Worth, TX-OK | Central | Tarrant County | https://data.medicare.gov/resource/xubh-q36u/row-qhpw~99pb.trhs | 670071 | 649388 | 2019-05-30 | 2018-12-31 | 27 | 20 | 47 | 47 |
Advanced export
JSON shape: default, array, newline-delimited
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 );