hospital_data
Data source: Big Local News · About: big-local-datasette
51 rows where "filed_date" is on date 2019-05-24 and "fy_end_date" is on date 2018-12-31
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, hospital_ownership, emergency_services, statefips, cbsacode, csatitle, centraloutlyingcounty, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, nursing_fac_beds, oth_longterm_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
102 | 102 | MARY LANNING HEALTHCARE | 715 N ST JOSEPH AVE | HASTINGS | NE | 68901 | ADAMS | (402) 461-5108 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 40.5924160 | -98.3874740 | 0 | 1 | 31 | 31001 | 25580 | Central | Adams County | https://data.medicare.gov/resource/xubh-q36u/row-6nbf.h76f_85sy | 280032 | 648632 | 2019-05-24 | 2018-12-31 | 87 | 10 | 97 | 26 | 9 | 11 | 143 | ||||||||||
172 | 172 | ANDERSON COUNTY HOSPITAL | 421 S MAPLE | GARNETT | KS | 66032 | ANDERSON | (785) 204-4000 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 38.2801200 | -95.2493000 | 0 | 3 | 20 | 20003 | https://data.medicare.gov/resource/xubh-q36u/row-3ktx.x5ze~zgrj | 171316 | 648620 | 2019-05-24 | 2018-12-31 | 12 | 12 | 36 | 48 | ||||||||||||||||
428 | 428 | BENEWAH COMMUNITY HOSPITAL | 229 SOUTH 7TH STREET | ST MARIES | ID | 83861 | BENEWAH | (208) 245-5551 | Critical Access Hospitals | Government - Local | TRUE | 47.3146130 | -116.5666780 | 0 | 9 | 16 | 16009 | https://data.medicare.gov/resource/xubh-q36u/row-3wfv~5stn~5t7d | 131317 | 652074 | 2019-05-24 | 2018-12-31 | 19 | 19 | 19 | |||||||||||||||||
598 | 598 | CALHOUN-LIBERTY HOSPITAL | 20370 NE BURNS AVE | BLOUNTSTOWN | FL | 32424 | CALHOUN | (850) 674-3493 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 30.4581280 | -85.0495870 | 0 | 13 | 12 | 12013 | https://data.medicare.gov/resource/xubh-q36u/row-sxhi~5k5k~4igt | 101304 | 651800 | 2019-05-24 | 2018-12-31 | 15 | 15 | 15 | |||||||||||||||||
621 | 621 | BENEFIS HOSPITALS INC | 1101 26TH ST S | GREAT FALLS | MT | 59405 | CASCADE | (406) 455-5000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 47.4918480 | -111.2626150 | 0 | 13 | 30 | 30013 | 24500 | Central | Cascade County | https://data.medicare.gov/resource/xubh-q36u/row-hf5d-meey.a7xt | 270012 | 649795 | 2019-05-24 | 2018-12-31 | 268 | 20 | 312 | 20 | 146 | 20 | 498 | ||||||||||
684 | 684 | ST ELIZABETH FLORENCE | 4900 HOUSTON ROAD | FLORENCE | KY | 41042 | BOONE | (859) 212-5220 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 39.0176150 | -84.6327900 | 0 | 15 | 21 | 21015 | 17140 | Cincinnati-Wilmington-Maysville, OH-KY-IN | Central | Boone County | https://data.medicare.gov/resource/xubh-q36u/row-udck-fezy-tei6 | 180045 | 648693 | 2019-05-24 | 2018-12-31 | 108 | 18 | 126 | 16 | 142 | |||||||||||
734 | 734 | COMMUNITY MEMORIAL HOSPITAL MEDICAL CENTER | 909 WEST FIRST STREET | SUMNER | IA | 50674 | BREMER | (563) 578-3275 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 42.8474220 | -92.1096910 | 0 | 17 | 19 | 19017 | 47940 | Outlying | Bremer County | https://data.medicare.gov/resource/xubh-q36u/row-c7f9.r33q_65gq | 161320 | 649106 | 2019-05-24 | 2018-12-31 | 16 | 16 | 16 | ||||||||||||||
805 | 805 | TUCSON MEDICAL CENTER | 5301 EAST GRANT ROAD | TUCSON | AZ | 85712 | PIMA | (520) 327-5461 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 32.2507490 | -110.8801690 | 0 | 19 | 4 | 4019 | 46060 | Tucson-Nogales, AZ | Central | Pima County | https://data.medicare.gov/resource/xubh-q36u/row-5nrs.x5vc.rfrt | 30006 | 652130 | 2019-05-24 | 2018-12-31 | 351 | 36 | 42 | 441 | 16 | 16 | 473 | |||||||||
986 | 986 | CROSSING RIVERS HEALTH MEDICAL CENTER | 37868 US HWY 18 | PRAIRIE DU CHIEN | WI | 53821 | CRAWFORD | (608) 357-2000 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 43.0139990 | -91.0945020 | 0 | 23 | 55 | 55023 | https://data.medicare.gov/resource/xubh-q36u/row-43cp~si3w~xt56 | 521330 | 649381 | 2019-05-24 | 2018-12-31 | 24 | 24 | 1 | 25 | ||||||||||||||||
1024 | 1024 | CENTRASTATE MEDICAL CENTER | 901 WEST MAIN STREET | FREEHOLD | NJ | 7728 | MONMOUTH | (732) 431-2000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.2356600 | -74.3120250 | 0 | 25 | 34 | 34025 | 35620 | New York-Newark, NY-NJ-CT-PA | Central | Monmouth County | https://data.medicare.gov/resource/xubh-q36u/row-eqm2_fpdf~v3xp | 310111 | 648642 | 2019-05-24 | 2018-12-31 | 239 | 25 | 264 | 264 | ||||||||||||
1166 | 1166 | PROVIDENCE MEDFORD MEDICAL CENTER | 1111 CRATER LAKE AVENUE | MEDFORD | OR | 97504 | JACKSON | (541) 732-5050 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 42.3399710 | -122.8610000 | 0 | 29 | 41 | 41029 | 32780 | Medford-Grants Pass, OR | Central | Jackson County | https://data.medicare.gov/resource/xubh-q36u/row-wq37.tzys-wnax | 380075 | 648649 | 2019-05-24 | 2018-12-31 | 111 | 15 | 126 | 12 | 138 | |||||||||||
1173 | 1173 | COLLETON MEDICAL CENTER | 501 ROBERTSON BOULEVARD | WALTERBORO | SC | 29488 | COLLETON | (843) 782-2000 | Acute Care Hospitals | Proprietary | TRUE | 32.9218550 | -80.6708800 | 0 | 29 | 45 | 45029 | https://data.medicare.gov/resource/xubh-q36u/row-429y~gw6b~pgj2 | 420030 | 648315 | 2019-05-24 | 2018-12-31 | 94 | 8 | 102 | 19 | 14 | 135 | ||||||||||||||
1197 | 1197 | MEDICAL CENTER ENTERPRISE | 400 N EDWARDS STREET | ENTERPRISE | AL | 36330 | COFFEE | (334) 347-0584 | Acute Care Hospitals | Proprietary | TRUE | 31.3181910 | -85.8553080 | 0 | 31 | 1 | 1031 | 21460 | Dothan-Enterprise-Ozark, AL | Central | Coffee County | https://data.medicare.gov/resource/xubh-q36u/row-m58x_64pa.z9zi | 10049 | 648587 | 2019-05-24 | 2018-12-31 | 92 | 7 | 99 | 99 | ||||||||||||
1205 | 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 | |||||||||||
1334 | 1334 | FORT WASHINGTON HOSPITAL | 11711 LIVINGSTON ROAD | FORT WASHINGTON | MD | 20744 | PRINCE GEORGES | (301) 292-7000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.7288130 | -76.9915880 | 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-wn97~mjiu~6g79 | 210060 | 648938 | 2019-05-24 | 2018-12-31 | 25 | 4 | 29 | 29 | ||||||||||||
1418 | 1418 | UH ST JOHN MEDICAL CENTER | 29000 CENTER RIDGE ROAD | WESTLAKE | OH | 44145 | CUYAHOGA | (440) 835-8000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.4358540 | -81.9407040 | 0 | 35 | 39 | 39035 | 17460 | Cleveland-Akron-Canton, OH | Central | Cuyahoga County | https://data.medicare.gov/resource/xubh-q36u/row-fi9g-zaf9.bctx | 360123 | 648738 | 2019-05-24 | 2018-12-31 | 134 | 36 | 170 | 170 | ||||||||||||
1495 | 1495 | PROVIDENCE HOLY CROSS MEDICAL CENTER | 15031 RINALDI ST | MISSION HILLS | CA | 91346 | LOS ANGELES | (818) 365-8051 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 34.2790130 | -118.4594850 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-2tfx_s99b_nbix | 50278 | 648594 | 2019-05-24 | 2018-12-31 | 280 | 24 | 12 | 316 | 13 | 48 | 377 | |||||||||
1499 | 1499 | PROVIDENCE SAINT JOHN'S HEALTH CENTER | 2121 SANTA MONICA BLVD | SANTA MONICA | CA | 90404 | LOS ANGELES | (310) 829-5511 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 34.0300700 | -118.4783050 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-i5rc_6v5d~trdh | 50290 | 648595 | 2019-05-24 | 2018-12-31 | 225 | 23 | 18 | 266 | 266 | |||||||||||
1503 | 1503 | VALLEY PRESBYTERIAN HOSPITAL | 15107 VANOWEN ST | VAN NUYS | CA | 91406 | LOS ANGELES | (818) 782-6600 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 34.1939170 | -118.4632710 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-k5i4-nbwt~csaa | 50126 | 648666 | 2019-05-24 | 2018-12-31 | 271 | 20 | 32 | 333 | 17 | 350 | ||||||||||
1541 | 1541 | ST ELIZABETH FT THOMAS | 85 NORTH GRAND AVENUE | FORT THOMAS | KY | 41075 | CAMPBELL | (859) 572-3100 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 39.0782810 | -84.4646540 | 0 | 37 | 21 | 21037 | 17140 | Cincinnati-Wilmington-Maysville, OH-KY-IN | Central | Campbell County | https://data.medicare.gov/resource/xubh-q36u/row-c5tu~ywst-jxv8 | 180001 | 648692 | 2019-05-24 | 2018-12-31 | 102 | 21 | 123 | 26 | 149 | |||||||||||
1644 | 1644 | MEMORIAL HOSPITAL | 511 NE 10TH ST | ABILENE | KS | 67410 | DICKINSON | (785) 263-6610 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 38.9249610 | -97.2064830 | 0 | 41 | 20 | 20041 | https://data.medicare.gov/resource/xubh-q36u/row-7wyc-bxfb~aagq | 171381 | 648690 | 2019-05-24 | 2018-12-31 | 19 | 19 | 10 | 74 | 103 | |||||||||||||||
1888 | 1888 | LEVI HOSPITAL | 300 PROSPECT AVE | HOT SPRINGS | AR | 71901 | GARLAND | (501) 624-1281 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 34.5099450 | -93.0566490 | 0 | 51 | 5 | 5051 | 26300 | Hot Springs-Malvern, AR | Central | Garland County | https://data.medicare.gov/resource/xubh-q36u/row-assk.a57a-njvy | 40132 | 649865 | 2019-05-24 | 2018-12-31 | 1 | 1 | 52 | 53 | ||||||||||||
1987 | 1987 | BLACK RIVER MEMORIAL HOSPITAL | 711 W ADAMS ST | BLACK RIVER FALLS | WI | 54615 | JACKSON | (715) 284-5361 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 44.3023860 | -90.8557340 | 0 | 53 | 55 | 55053 | https://data.medicare.gov/resource/xubh-q36u/row-jsyv-sp4j-2ajp | 521333 | 649382 | 2019-05-24 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||||||
2250 | 2250 | GOVE COUNTY MEDICAL CENTER | 520 WEST 5TH STREET | QUINTER | KS | 67752 | GOVE | (785) 754-3341 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 39.0671610 | -100.2413110 | 0 | 63 | 20 | 20063 | https://data.medicare.gov/resource/xubh-q36u/row-yfic-b2ck-cmkm | 171367 | 648622 | 2019-05-24 | 2018-12-31 | 21 | 21 | 42 | 63 | ||||||||||||||||
2253 | 2253 | HARBOR BEACH COMMUNITY HOSPITAL | 210 S FIRST ST | HARBOR BEACH | MI | 48441 | HURON | (989) 479-3201 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 43.8424290 | -82.6525270 | 0 | 63 | 26 | 26063 | https://data.medicare.gov/resource/xubh-q36u/row-urdm~wdap~hbdt | 231313 | 648275 | 2019-05-24 | 2018-12-31 | 15 | 15 | 30 | 45 | ||||||||||||||||
2699 | 2699 | ST ELIZABETH GRANT | 238 BARNES ROAD | WILLIAMSTOWN | KY | 41097 | GRANT | (859) 824-8105 | Critical Access Hospitals | Voluntary non-profit - Church | TRUE | 38.6478620 | -84.5782640 | 0 | 81 | 21 | 21081 | 17140 | Cincinnati-Wilmington-Maysville, OH-KY-IN | Outlying | Grant County | https://data.medicare.gov/resource/xubh-q36u/row-z5ru.drf8.yem5 | 181311 | 648696 | 2019-05-24 | 2018-12-31 | 15 | 15 | 15 | |||||||||||||
2775 | 2775 | REGIONAL MEDICAL CENTER OF SAN JOSE | 225 N JACKSON AVENUE | SAN JOSE | CA | 95116 | SANTA CLARA | (408) 259-5000 | Acute Care Hospitals | Government - Federal | TRUE | 37.3637870 | -121.8488230 | 0 | 85 | 6 | 6085 | 41940 | San Jose-San Francisco-Oakland, CA | Central | Santa Clara County | https://data.medicare.gov/resource/xubh-q36u/row-qe98-xids.qirm | 50125 | 648592 | 2019-05-24 | 2018-12-31 | 218 | 34 | 258 | 258 | ||||||||||||
2793 | 2793 | GLENCOE REGIONAL HEALTH SERVICES | 1805 HENNEPIN AVENUE NORTH | GLENCOE | MN | 55336 | MC LEOD | (320) 864-3121 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 44.7775500 | -94.1517140 | 0 | 85 | 27 | 27085 | 26780 | Minneapolis-St. Paul, MN-WI | Central | McLeod County | https://data.medicare.gov/resource/xubh-q36u/row-j3nk_h3k3_6mv6 | 241355 | 649274 | 2019-05-24 | 2018-12-31 | 25 | 25 | 99 | 124 | ||||||||||||
2910 | 2910 | CLARK FORK VALLEY HOSPITAL | 10 KRUGER RD | PLAINS | MT | 59859 | SANDERS | (406) 826-4800 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 47.4695390 | -114.8919080 | 0 | 89 | 30 | 30089 | https://data.medicare.gov/resource/xubh-q36u/row-325u_sses_9br7 | 271323 | 649796 | 2019-05-24 | 2018-12-31 | 16 | 16 | 28 | 44 | ||||||||||||||||
3071 | 3071 | AMERY HOSPITAL & CLINIC | 265 GRIFFIN STREET EAST | AMERY | WI | 54001 | POLK | (715) 268-0300 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 45.2959460 | -92.3606700 | 0 | 95 | 55 | 55095 | https://data.medicare.gov/resource/xubh-q36u/row-nbii-jcut-5ka3 | 521308 | 649379 | 2019-05-24 | 2018-12-31 | 25 | 25 | 10 | 35 | ||||||||||||||||
3127 | 3127 | ST JOSEPH'S HOSPITAL | 1 AMALIA DRIVE | BUCKHANNON | WV | 26201 | UPSHUR | (304) 472-2000 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 38.9912750 | -80.2368240 | 0 | 97 | 54 | 54097 | https://data.medicare.gov/resource/xubh-q36u/row-dwxq.ey9z_ufif | 511321 | 649690 | 2019-05-24 | 2018-12-31 | 21 | 4 | 25 | 10 | 16 | 51 | ||||||||||||||
3264 | 3264 | SAINT LUKE'S CUSHING HOSPITAL | 711 MARSHALL STREET | LEAVENWORTH | KS | 66048 | LEAVENWORTH | (913) 684-1100 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 39.3077730 | -94.9183550 | 0 | 103 | 20 | 20103 | 28140 | Kansas City-Overland Park-Kansas City, MO-KS | Outlying | Leavenworth County | https://data.medicare.gov/resource/xubh-q36u/row-ydtv.9qfe.iqxb | 170133 | 648617 | 2019-05-24 | 2018-12-31 | 20 | 4 | 24 | 24 | ||||||||||||
3270 | 3270 | ST TAMMANY PARISH HOSPITAL | 1202 S TYLER STREET | COVINGTON | LA | 70433 | ST. TAMMANY | (985) 898-4000 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 30.4689550 | -90.1139350 | 0 | 103 | 22 | 22103 | 35380 | New Orleans-Metairie-Hammond, LA-MS | Outlying | St. Tammany Parish | https://data.medicare.gov/resource/xubh-q36u/row-g77w.u6w7-nqad | 190045 | 648263 | 2019-05-24 | 2018-12-31 | 149 | 24 | 188 | 12 | 200 | |||||||||||
3314 | 3314 | CYPRESS POINTE SURGICAL HOSPITAL | 42570 SOUTH AIRPORT RD | HAMMOND | LA | 70403 | TANGIPAHOA | (985) 510-6200 | Acute Care Hospitals | Physician | FALSE | 30.4770420 | -90.4142640 | 0 | 105 | 22 | 22105 | 25220 | New Orleans-Metairie-Hammond, LA-MS | Central | Tangipahoa Parish | https://data.medicare.gov/resource/xubh-q36u/row-hpin~yhn8-9yzq | 190303 | 648698 | 2019-05-24 | 2018-12-31 | 30 | 30 | 30 | |||||||||||||
3332 | 3332 | BELOIT MEMORIAL HOSPITAL | 1969 W HART RD | BELOIT | WI | 53511 | ROCK | (608) 364-5011 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.5467660 | -89.0076160 | 0 | 105 | 55 | 55105 | 27500 | Madison-Janesville-Beloit, WI | Central | Rock County | https://data.medicare.gov/resource/xubh-q36u/row-jfqs_633q~b3um | 520100 | 649378 | 2019-05-24 | 2018-12-31 | 91 | 12 | 103 | 103 | ||||||||||||
3407 | 3407 | WESTFIELDS HOSPITAL AND CLINIC | 535 HOSPITAL RD | NEW RICHMOND | WI | 54017 | ST. CROIX | (715) 243-2600 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 45.1174600 | -92.5532140 | 0 | 109 | 55 | 55109 | 33460 | Minneapolis-St. Paul, MN-WI | Outlying | St. Croix County | https://data.medicare.gov/resource/xubh-q36u/row-v45z.6njd_wida | 521345 | 649384 | 2019-05-24 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||
3410 | 3410 | HUDSON HOSPITAL & CLINIC | 405 STAGELINE ROAD | HUDSON | WI | 54016 | ST. CROIX | (715) 531-6000 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 44.9622890 | -92.7188390 | 0 | 109 | 55 | 55109 | 33460 | Minneapolis-St. Paul, MN-WI | Outlying | St. Croix County | https://data.medicare.gov/resource/xubh-q36u/row-sjw8_yf3z~m67j | 521335 | 649383 | 2019-05-24 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||
3503 | 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 | |||||||||||||
3521 | 3521 | DOCTORS HOSPITAL OF SARASOTA | 5731 BEE RIDGE RD | SARASOTA | FL | 34233 | SARASOTA | (941) 342-1100 | Acute Care Hospitals | Proprietary | TRUE | 27.2989750 | -82.4548480 | 0 | 115 | 12 | 12115 | 35840 | North Port-Sarasota, FL | Central | Sarasota County | https://data.medicare.gov/resource/xubh-q36u/row-5phw~tq29_truf | 100166 | 651508 | 2019-05-24 | 2018-12-31 | 123 | 16 | 139 | 16 | 155 | |||||||||||
3648 | 3648 | MERIT HEALTH RANKIN | 350 CROSSGATES BLVD | BRANDON | MS | 39042 | RANKIN | (601) 825-2811 | Acute Care Hospitals | Proprietary | TRUE | 32.2862140 | -90.0359600 | 0 | 121 | 28 | 28121 | 27140 | Jackson-Vicksburg-Brookhaven, MS | Central | Rankin County | https://data.medicare.gov/resource/xubh-q36u/row-cu6y_iea7.rvw5 | 250096 | 648279 | 2019-05-24 | 2018-12-31 | 106 | 8 | 114 | 20 | 134 | |||||||||||
3682 | 3682 | REGIONS HOSPITAL | 640 JACKSON STREET | SAINT PAUL | MN | 55101 | RAMSEY | (651) 254-1616 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 44.9553380 | -93.0962770 | 0 | 123 | 27 | 27123 | 33460 | Minneapolis-St. Paul, MN-WI | Central | Ramsey County | https://data.medicare.gov/resource/xubh-q36u/row-36zs~9stm-xa4i | 240106 | 649268 | 2019-05-24 | 2018-12-31 | 375 | 16 | 12 | 18 | 10 | 431 | 21 | 452 | ||||||||
3889 | 3889 | TRINITY MUSCATINE | 1518 MULBERRY AVENUE | MUSCATINE | IA | 52761 | MUSCATINE | (563) 264-9100 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.4341730 | -91.0527270 | 0 | 139 | 19 | 19139 | 34700 | Davenport-Moline, IA-IL | Central | Muscatine County | https://data.medicare.gov/resource/xubh-q36u/row-cv94-yyca.ev4v | 160013 | 648246 | 2019-05-24 | 2018-12-31 | 40 | 5 | 45 | 45 | ||||||||||||
4133 | 4133 | TRINITY ROCK ISLAND | 2701 17TH ST | ROCK ISLAND | IL | 61201 | ROCK ISLAND | (309) 779-5000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 41.4836490 | -90.5727990 | 0 | 161 | 17 | 17161 | 19340 | Davenport-Moline, IA-IL | Central | Rock Island County | https://data.medicare.gov/resource/xubh-q36u/row-93v6_urpw.vbnn | 140280 | 648241 | 2019-05-24 | 2018-12-31 | 237 | 20 | 31 | 297 | 22 | 29 | 348 | |||||||||
4135 | 4135 | MANHATTAN SURGICAL HOSPITAL LLC | 1829 COLLEGE AVENUE | MANHATTAN | KS | 66502 | RILEY | (785) 776-5100 | Acute Care Hospitals | Physician | FALSE | 39.2028260 | -96.5981830 | 0 | 161 | 20 | 20161 | 31740 | Manhattan-Junction City, KS | Central | Riley County | https://data.medicare.gov/resource/xubh-q36u/row-5vw9~wxt5.eejp | 170190 | 648618 | 2019-05-24 | 2018-12-31 | 13 | 13 | 13 | |||||||||||||
4157 | 4157 | TRINITY BETTENDORF | 4500 UTICA RIDGE ROAD | BETTENDORF | IA | 52722 | SCOTT | (563) 742-5000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.5661050 | -90.5173600 | 0 | 163 | 19 | 19163 | 19340 | Davenport-Moline, IA-IL | Central | Scott County | https://data.medicare.gov/resource/xubh-q36u/row-nhf5_m4te.4x9j | 160104 | 648247 | 2019-05-24 | 2018-12-31 | 71 | 10 | 87 | 87 | ||||||||||||
4175 | 4175 | LAKEVIEW MEMORIAL HOSPITAL | 927 WEST CHURCHILL STREET | STILLWATER | MN | 55082 | WASHINGTON | (651) 430-5330 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 45.0481260 | -92.8184890 | 0 | 163 | 27 | 27163 | 33460 | Minneapolis-St. Paul, MN-WI | Central | Washington County | https://data.medicare.gov/resource/xubh-q36u/row-wues-hzji_9g79 | 240066 | 649267 | 2019-05-24 | 2018-12-31 | 55 | 13 | 68 | 68 | ||||||||||||
4246 | 4246 | WOMEN'S HOSPITAL THE | 4199 GATEWAY BLVD | NEWBURGH | IN | 47630 | WARRICK | (812) 842-4200 | Acute Care Hospitals | Proprietary | TRUE | 37.9735480 | -87.4491090 | 0 | 173 | 18 | 18173 | 21780 | Central | Warrick County | https://data.medicare.gov/resource/xubh-q36u/row-rn9t.t87t.eat4 | 150149 | 648611 | 2019-05-24 | 2018-12-31 | 50 | 24 | 74 | 74 | |||||||||||||
4251 | 4251 | KANSAS SPINE & SPECIALTY HOSPITAL, LLC | 3333 NORTH WEBB ROAD | WICHITA | KS | 67226 | SEDGWICK | (316) 462-5326 | Acute Care Hospitals | Physician | FALSE | 37.7439660 | -97.2263260 | 0 | 173 | 20 | 20173 | 48620 | Wichita-Arkansas City-Winfield, KS | Central | Sedgwick County | https://data.medicare.gov/resource/xubh-q36u/row-qfsa.vac4~t9rr | 170196 | 648689 | 2019-05-24 | 2018-12-31 | 36 | 36 | 36 | |||||||||||||
4391 | 4391 | HARDEMAN COUNTY MEMORIAL HOSPITAL | 402 MERCER ST | QUANAH | TX | 79252 | HARDEMAN | (940) 663-2795 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 34.2965660 | -99.7410560 | 0 | 197 | 48 | 48197 | https://data.medicare.gov/resource/xubh-q36u/row-u2zf.mvvx_urz7 | 451352 | 648770 | 2019-05-24 | 2018-12-31 | 24 | 24 | 24 | |||||||||||||||||
4608 | 4608 | QUAIL CREEK SURGICAL HOSPITAL | 6819 PLUM CREEK | AMARILLO | TX | 79124 | POTTER | (806) 354-6100 | Acute Care Hospitals | Proprietary | TRUE | 35.2106750 | -101.9135680 | 0 | 375 | 48 | 48375 | 11100 | Amarillo-Borger, TX | Central | Potter County | https://data.medicare.gov/resource/xubh-q36u/row-3fht_yhjz.yec5 | 450875 | 648767 | 2019-05-24 | 2018-12-31 | 32 | 32 | 32 | |||||||||||||
4687 | 4687 | WARD MEMORIAL HOSPITAL | 406 SOUTH GARY ST | MONAHANS | TX | 79756 | WARD | (432) 943-2511 | Critical Access Hospitals | Government - Local | TRUE | 31.5939700 | -102.8845830 | 0 | 475 | 48 | 48475 | https://data.medicare.gov/resource/xubh-q36u/row-sujn~5cdz-gz6m | 451373 | 648492 | 2019-05-24 | 2018-12-31 | 21 | 21 | 21 |
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 );