hospital_data
Data source: Big Local News · About: big-local-datasette
5 rows where "filed_date" is on date 2019-06-04 and hospital_ownership = "Voluntary non-profit - Other"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, emergency_services, statefips, csatitle, centraloutlyingcounty, icu_beds, coronary_beds, subprovider_ipf_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1413 | 1413 | SOUTH POINTE HOSPITAL | 20000 HARVARD ROAD | WARRENSVILLE HEIGHTS | OH | 44122 | CUYAHOGA | (216) 491-6000 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 41.4498650 | -81.5378290 | 0 | 35 | 39 | 39035 | 17460 | Cleveland-Akron-Canton, OH | Central | Cuyahoga County | https://data.medicare.gov/resource/xubh-q36u/row-5zhv.iz5f~2jrw | 360144 | 650892 | 2019-06-04 | 2018-12-31 | 106 | 25 | 131 | 131 | ||||||||||||
1855 | 1855 | LEWIS COUNTY GENERAL HOSPITAL | 7785 NORTH STATE STREET | LOWVILLE | NY | 13367 | LEWIS | (315) 376-5200 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 43.7958300 | -75.4981520 | 0 | 49 | 36 | 36049 | https://data.medicare.gov/resource/xubh-q36u/row-t9if.wi94~nbm4 | 331317 | 651041 | 2019-06-04 | 2018-12-31 | 19 | 6 | 25 | 160 | 185 | |||||||||||||||
2266 | 2266 | BLANCHARD VALLEY HOSPITAL | 1900 SOUTH MAIN STREET | FINDLAY | OH | 45840 | HANCOCK | (419) 423-4500 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 41.0172410 | -83.6503390 | 0 | 63 | 39 | 39063 | 22300 | Findlay-Tiffin, OH | Central | Hancock County | https://data.medicare.gov/resource/xubh-q36u/row-yf9x_rfm3.dkgt | 360095 | 650889 | 2019-06-04 | 2018-12-31 | 107 | 34 | 141 | 9 | 150 | |||||||||||
2669 | 2669 | ORTHOPAEDIC HOSPITAL OF WISCONSIN | 475 W RIVER WOODS PKWY | GLENDALE | WI | 53212 | MILWAUKEE | (414) 961-6800 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 43.0982700 | -87.9135790 | 0 | 79 | 55 | 55079 | 33340 | Milwaukee-Racine-Waukesha, WI | Central | Milwaukee County | https://data.medicare.gov/resource/xubh-q36u/row-dfp2~v5qg_35t9 | 520194 | 651108 | 2019-06-04 | 2018-12-31 | 30 | 30 | 30 | |||||||||||||
2961 | 2961 | OZARKS MEDICAL CENTER | 1100 KENTUCKY AVE | WEST PLAINS | MO | 65775 | HOWELL | (417) 256-9111 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 36.7379920 | -91.8755520 | 0 | 91 | 29 | 29091 | 48460 | Central | Howell County | https://data.medicare.gov/resource/xubh-q36u/row-55iu-4su4_aybs | 260078 | 650595 | 2019-06-04 | 2018-12-31 | 91 | 12 | 103 | 103 |
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 );