hospital_data
Data source: Big Local News · About: big-local-datasette
18 rows where centraloutlyingcounty = "Central" and "filed_date" is on date 2019-05-22
This data as json, copyable, CSV (advanced)
Suggested facets: city, state, county_name, hospital_type, hospital_ownership, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, countyequivalent, fy_end_date, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, all_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
302 | 302 | LOVELACE REGIONAL HOSPITAL - ROSWELL | 117 EAST 19TH STREET | ROSWELL | NM | 88201 | CHAVES | (575) 625-3345 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 33.4159760 | -104.5217540 | 0 | 5 | 35 | 35005 | 40740 | Central | Chaves County | https://data.medicare.gov/resource/xubh-q36u/row-y4jq.pkc3~jyui | 320086 | 648014 | 2019-05-22 | 2018-12-31 | 23 | 4 | 27 | 27 | |||||||||||||
312 | 312 | PROVIDENCE WILLAMETTE FALLS MEDICAL CENTER | 1500 DIVISION STREET | OREGON CITY | OR | 97045 | CLACKAMAS | (503) 657-6915 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 45.3566470 | -122.5883710 | 0 | 5 | 41 | 41005 | 38900 | Portland-Vancouver-Salem, OR-WA | Central | Clackamas County | https://data.medicare.gov/resource/xubh-q36u/row-4zvi_yd6d-6gyq | 380038 | 648648 | 2019-05-22 | 2018-12-31 | 103 | 8 | 111 | 111 | ||||||||||||
556 | 556 | ARIZONA SPECIALTY HOSPITAL | 2905 WEST WARNER ROAD, SUITE 1 | CHANDLER | AZ | 85224 | MARICOPA | (480) 603-9000 | Acute Care Hospitals | Proprietary | FALSE | 33.3348400 | -111.8911330 | 0 | 13 | 4 | 4013 | 38060 | Central | Maricopa County | https://data.medicare.gov/resource/xubh-q36u/row-z5xq-7gkm.mjtq | 30112 | 649698 | 2019-05-22 | 2018-12-31 | 24 | 24 | 24 | ||||||||||||||
611 | 611 | HOLYOKE MEDICAL CENTER | 575 BEECH STREET | HOLYOKE | MA | 1040 | HAMPDEN | (413) 534-2500 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.1996160 | -72.6270870 | 0 | 13 | 25 | 25013 | 44140 | Springfield-Greenfield Town, MA | Central | Hampden County | https://data.medicare.gov/resource/xubh-q36u/row-qqxc_2ssq-uqu2 | 220024 | 648388 | 2019-05-22 | 2018-09-30 | 147 | 12 | 6 | 165 | 20 | 185 | ||||||||||
1207 | 1207 | MAYO CLINIC | 4500 SAN PABLO RD | JACKSONVILLE | FL | 32224 | DUVAL | (904) 953-2000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 30.2637020 | -81.4375330 | 0 | 31 | 12 | 12031 | 27260 | Jacksonville-St. Marys-Palatka, FL-GA | Central | Duval County | https://data.medicare.gov/resource/xubh-q36u/row-5qpc-23s6_wtm9 | 100151 | 649417 | 2019-05-22 | 2018-12-31 | 223 | 54 | 277 | 277 | ||||||||||||
1419 | 1419 | ST VINCENT CHARITY MEDICAL CENTER | 2351 EAST 22ND STREET | CLEVELAND | OH | 44115 | CUYAHOGA | (216) 861-6200 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 41.4956950 | -81.6742750 | 0 | 35 | 39 | 39035 | 17460 | Cleveland-Akron-Canton, OH | Central | Cuyahoga County | https://data.medicare.gov/resource/xubh-q36u/row-gmvk-ge5g_hqfc | 360037 | 648454 | 2019-05-22 | 2018-12-31 | 106 | 10 | 10 | 126 | 71 | 197 | ||||||||||
1433 | 1433 | THE ORTHOPEDIC SPECIALTY HOSPITAL | 5848 SOUTH 300 EAST | MURRAY | UT | 84107 | SALT LAKE | (801) 314-4100 | Acute Care Hospitals | Voluntary non-profit - Private | FALSE | 40.6441568 | -111.8834631 | 1 | ROOFTOP | 35 | 49 | 49035 | 41620 | Salt Lake City-Provo-Orem, UT | Central | Salt Lake County | https://data.medicare.gov/resource/xubh-q36u/row-q8pf_69d4-hzq3 | 460049 | 648660 | 2019-05-22 | 2018-12-31 | 40 | 40 | 40 | ||||||||||||
1440 | 1440 | LDS HOSPITAL | 8TH AVENUE AND C STREET | SALT LAKE CITY | UT | 84143 | SALT LAKE | (801) 408-1100 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.7785090 | -111.8805760 | 0 | 35 | 49 | 49035 | 41620 | Salt Lake City-Provo-Orem, UT | Central | Salt Lake County | https://data.medicare.gov/resource/xubh-q36u/row-ts9q.8fzp.3p9n | 460006 | 649001 | 2019-05-22 | 2018-12-31 | 188 | 28 | 216 | 34 | 250 | |||||||||||
1570 | 1570 | SAINT THOMAS HOSPITAL FOR SPECIALTY SURGERY | 2011 MURPHY AVENUE | NASHVILLE | TN | 37203 | DAVIDSON | (615) 515-8200 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 36.1557640 | -86.8038890 | 0 | 37 | 47 | 47037 | 34980 | Nashville-Davidson--Murfreesboro, TN | Central | Davidson County | https://data.medicare.gov/resource/xubh-q36u/row-utm3-5xwp_5vj4 | 440218 | 648763 | 2019-05-22 | 2018-12-31 | 23 | 23 | 23 | |||||||||||||
1879 | 1879 | AMERICAN FORK HOSPITAL | 170 NORTH 1100 EAST | AMERICAN FORK | UT | 84003 | UTAH | (801) 855-3305 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.3805060 | -111.7690940 | 0 | 49 | 49 | 49049 | 39340 | Salt Lake City-Provo-Orem, UT | Central | Utah County | https://data.medicare.gov/resource/xubh-q36u/row-s7aj~ypv9~6tcc | 460023 | 648658 | 2019-05-22 | 2018-12-31 | 73 | 18 | 91 | 91 | ||||||||||||
1935 | 1935 | HEBER VALLEY HOSPITAL | 1485 SOUTH HIGHWAY 40 | HEBER CITY | UT | 84032 | WASATCH | (435) 654-2500 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 40.4890470 | -111.4092180 | 0 | 51 | 49 | 49051 | 25720 | Salt Lake City-Provo-Orem, UT | Central | Wasatch County | https://data.medicare.gov/resource/xubh-q36u/row-8mif.5tu6.xu7b | 461307 | 648498 | 2019-05-22 | 2018-12-31 | 19 | 19 | 19 | |||||||||||||
3030 | 3030 | NEMOURS CHILDREN'S HOSPITAL | 13535 NEMOURS PKWY | ORLANDO | FL | 32827 | ORANGE | (407) 567-4000 | Childrens | Voluntary non-profit - Private | TRUE | 28.3749080 | -81.2766940 | 0 | 95 | 12 | 12095 | 36740 | Orlando-Deltona-Daytona Beach, FL | Central | Orange County | https://data.medicare.gov/resource/xubh-q36u/row-7q2m-thri-ffzb | 103304 | 648095 | 2019-05-22 | 2018-12-31 | 49 | 28 | 18 | 100 | 100 | |||||||||||
3032 | 3032 | ADVENTHEALTH ORLANDO | 601 E ROLLINS ST | ORLANDO | FL | 32803 | ORANGE | (407) 303-1976 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 28.5734570 | -81.3703280 | 0 | 95 | 12 | 12095 | 36740 | Orlando-Deltona-Daytona Beach, FL | Central | Orange County | https://data.medicare.gov/resource/xubh-q36u/row-4fra_j2em.99x3 | 100007 | 648798 | 2019-05-22 | 2018-12-31 | 2256 | 221 | 40 | 2753 | 43 | 30 | 2826 | |||||||||
3328 | 3328 | FORT LOUDON MEDICAL CENTER | 550 FORT LOUDON MEDICAL CENTER DR | LENOIR CITY | TN | 37772 | LOUDON | (865) 271-6000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 35.8271080 | -84.2717520 | 0 | 105 | 47 | 47105 | 28940 | Knoxville-Morristown-Sevierville, TN | Central | Loudon County | https://data.medicare.gov/resource/xubh-q36u/row-dzf9.pf9q_tv6s | 440110 | 648209 | 2019-05-22 | 2018-12-31 | 25 | 5 | 30 | 30 | ||||||||||||
3746 | 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 | |||||||||||
3951 | 3951 | BELLEVUE HOSPITAL | 1400 WEST MAIN STREET | BELLEVUE | OH | 44811 | SANDUSKY | (419) 483-4040 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 41.2850800 | -82.8825590 | 0 | 143 | 39 | 39143 | 23380 | Central | Sandusky County | https://data.medicare.gov/resource/xubh-q36u/row-dxdd_2hgt.meqt | 360107 | 648967 | 2019-05-22 | 2018-12-31 | 40 | 10 | 50 | 50 | |||||||||||||
4046 | 4046 | MERCY MEDICAL CENTER | 1320 MERCY DRIVE NW | CANTON | OH | 44708 | STARK | (330) 489-1080 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.8123210 | -81.3970690 | 0 | 151 | 39 | 39151 | 15940 | Cleveland-Akron-Canton, OH | Central | Stark County | https://data.medicare.gov/resource/xubh-q36u/row-wtxu~2u95.qas6 | 360070 | 648455 | 2019-05-22 | 2018-12-31 | 257 | 36 | 16 | 317 | 21 | 338 | ||||||||||
4646 | 4646 | BAYLOR SCOTT AND WHITE ORTHOPEDIC AND SPINE HOSPI | 707 HIGHLANDER BLVD | ARLINGTON | TX | 76015 | TARRANT | (817) 549-2364 | Acute Care Hospitals | Proprietary | TRUE | 32.6821530 | -97.1172180 | 0 | 439 | 48 | 48439 | 19100 | Dallas-Fort Worth, TX-OK | Central | Tarrant County | https://data.medicare.gov/resource/xubh-q36u/row-4bwe.2jky-j5da | 670067 | 648584 | 2019-05-22 | 2018-12-31 | 24 | 24 | 24 |
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 );