hospital_data
Data source: Big Local News · About: big-local-datasette
5 rows where "filed_date" is on date 2019-12-04 and "fy_end_date" is on date 2018-12-31
This data as json, copyable, CSV (advanced)
Suggested facets: state, county_name, hospital_type, hospital_ownership, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, icu_beds, subprovider_ipf_beds, subprovider_irf_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
2013 | 2013 | MISSOURI BAPTIST SULLIVAN HOSPITAL | 751 SAPPINGTON BRIDGE RD | SULLIVAN | MO | 63080 | FRANKLIN | (573) 468-4186 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 38.1955740 | -91.1692880 | 0 | 55 | 29 | 29055 | https://data.medicare.gov/resource/xubh-q36u/row-tm3p_uhvr.kmvz | 261337 | 662222 | 2019-12-04 | 2018-12-31 | 25 | 25 | 10 | 35 | ||||||||||||||||
3490 | 3490 | BAYLOR SCOTT AND WHITE MEDICAL CENTER SUNNYVALE | 231 SOUTH COLLINS ROAD | SUNNYVALE | TX | 75182 | DALLAS | (972) 892-3000 | Acute Care Hospitals | Proprietary | TRUE | 32.7783400 | -96.5671780 | 0 | 113 | 48 | 48113 | 19100 | Dallas-Fort Worth, TX-OK | Central | Dallas County | https://data.medicare.gov/resource/xubh-q36u/row-xs7f_5svn~da2r | 670060 | 661839 | 2019-12-04 | 2018-12-31 | 62 | 8 | 70 | 70 | ||||||||||||
4338 | 4338 | PARKLAND HEALTH CENTER - BONNE TERRE | 7245 RAIDER ROAD | BONNE TERRE | MO | 63628 | ST. FRANCOIS | (573) 358-1400 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 37.9092860 | -90.5252970 | 0 | 187 | 29 | 29187 | 22100 | St. Louis-St. Charles-Farmington, MO-IL | Central | St. Francois County | https://data.medicare.gov/resource/xubh-q36u/row-qfh6_b86g_9np8 | 261315 | 662397 | 2019-12-04 | 2018-12-31 | 3 | 3 | 3 | |||||||||||||
4339 | 4339 | PARKLAND HEALTH CENTER | 1101 W LIBERTY | FARMINGTON | MO | 63640 | ST. FRANCOIS | (573) 431-6005 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 37.7806240 | -90.4381950 | 0 | 187 | 29 | 29187 | 22100 | St. Louis-St. Charles-Farmington, MO-IL | Central | St. Francois County | https://data.medicare.gov/resource/xubh-q36u/row-m5zi.8uca_6c7z | 260163 | 662396 | 2019-12-04 | 2018-12-31 | 82 | 10 | 92 | 16 | 108 | |||||||||||
4357 | 4357 | MISSOURI BAPTIST MEDICAL CENTER | 3015 N BALLAS RD | TOWN AND COUNTRY | MO | 63131 | ST. LOUIS | (314) 996-5000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 38.6355320 | -90.4436360 | 0 | 189 | 29 | 29189 | 41180 | St. Louis-St. Charles-Farmington, MO-IL | Central | St. Louis County | https://data.medicare.gov/resource/xubh-q36u/row-22pi-vzza~yq54 | 260108 | 661924 | 2019-12-04 | 2018-12-31 | 366 | 40 | 406 | 20 | 426 |
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 );