hospital_data
Data source: Big Local News · About: big-local-datasette
6 rows where "filed_date" is on date 2019-10-01 and hospital_ownership = "Proprietary"
This data as json, copyable, CSV (advanced)
Suggested facets: state, geocode_flag, geocode_accuracy, statefips, csatitle, centraloutlyingcounty, fy_end_date, subtotal_acute_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1679 | 1679 | EVANSTON REGIONAL HOSPITAL | 190 ARROWHEAD DR | EVANSTON | WY | 82930 | UINTA | (307) 789-3636 | Acute Care Hospitals | Proprietary | TRUE | 41.2422140 | -110.9913360 | 0 | 41 | 56 | 56041 | 21740 | Central | Uinta County | https://data.medicare.gov/resource/xubh-q36u/row-7bqu_vhhd.zycd | 530032 | 654952 | 2019-10-01 | 2019-04-30 | 26 | 6 | 32 | 32 | |||||||||||||
2523 | 2523 | CAPITAL REGIONAL MEDICAL CENTER | 2626 CAPITAL MEDICAL BLVD | TALLAHASSEE | FL | 32308 | LEON | (850) 656-5000 | Acute Care Hospitals | Proprietary | TRUE | 30.4753760 | -84.2307280 | 0 | 73 | 12 | 12073 | 45220 | Tallahassee-Bainbridge, FL-GA | Central | Leon County | https://data.medicare.gov/resource/xubh-q36u/row-9js5~veid~7wjn | 100254 | 654879 | 2019-10-01 | 2019-04-30 | 246 | 20 | 266 | 266 | ||||||||||||
3663 | 3663 | LEWISGALE HOSPITAL MONTGOMERY | 3700 SOUTH MAIN STREET | BLACKSBURG | VA | 24060 | MONTGOMERY | (540) 951-1111 | Acute Care Hospitals | Proprietary | TRUE | 37.1856210 | -80.4086120 | 0 | 121 | 51 | 51121 | 13980 | Central | Montgomery County | https://data.medicare.gov/resource/xubh-q36u/row-3des-4erp_ke8h | 490110 | 654901 | 2019-10-01 | 2018-09-30 | 78 | 10 | 88 | 88 | |||||||||||||
4194 | 4194 | SUMNER REGIONAL MEDICAL CENTER | 555 HARTSVILLE PIKE | GALLATIN | TN | 37066 | SUMNER | (615) 452-4210 | Acute Care Hospitals | Proprietary | TRUE | 36.3911170 | -86.4343410 | 0 | 165 | 47 | 47165 | 34980 | Nashville-Davidson--Murfreesboro, TN | Central | Sumner County | https://data.medicare.gov/resource/xubh-q36u/row-5cut-g6dp_ruat | 440003 | 654752 | 2019-10-01 | 2019-04-30 | 108 | 18 | 126 | 12 | 17 | 155 | ||||||||||
4280 | 4280 | SPOTSYLVANIA REGIONAL MEDICAL CENTER | 4600 SPOTSYLVANIA PARKWAY | FREDERICKSBURG | VA | 22408 | SPOTSYLVANIA | (540) 498-4000 | Acute Care Hospitals | Proprietary | TRUE | 38.2194960 | -77.4964500 | 0 | 177 | 51 | 51177 | 47900 | Washington-Baltimore-Arlington, DC-MD-VA-WV-PA | Outlying | Spotsylvania County | https://data.medicare.gov/resource/xubh-q36u/row-vmhu-vfub_yswh | 490141 | 654902 | 2019-10-01 | 2019-04-30 | 93 | 12 | 105 | 28 | 133 | |||||||||||
4286 | 4286 | OTTUMWA REGIONAL HEALTH CENTER | 1001 E PENNSYLVANIA | OTTUMWA | IA | 52501 | WAPELLO | (641) 682-7511 | Acute Care Hospitals | Proprietary | TRUE | 41.0288887 | -92.3895049 | 1 | ROOFTOP | 179 | 19 | 19179 | 36900 | Central | Wapello County | https://data.medicare.gov/resource/xubh-q36u/row-q5qs.dgin-w3wa | 160089 | 654920 | 2019-10-01 | 2019-04-30 | 77 | 11 | 88 | 14 | 18 | 120 |
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 );