hospital_data
Data source: Big Local News · About: big-local-datasette
7 rows where "filed_date" is on date 2019-05-28 and hospital_ownership = "Voluntary non-profit - Other"
This data as json, copyable, CSV (advanced)
Suggested facets: hospital_type, countyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, icu_beds, coronary_beds, subprovider_irf_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1783 | 1783 | MCLAREN NORTHERN MICHIGAN | 416 CONNABLE AVE | PETOSKEY | MI | 49770 | EMMET | (231) 487-4000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 45.3734770 | -84.9691520 | 0 | 47 | 26 | 26047 | https://data.medicare.gov/resource/xubh-q36u/row-fcnu-j4f4.fztp | 230105 | 648840 | 2019-05-28 | 2018-09-30 | 129 | 18 | 40 | 187 | 15 | 202 | ||||||||||||||
2946 | 2946 | SAINT LUKE'S SOUTH HOSPITAL | 12300 METCALF AVENUE | OVERLAND PARK | KS | 66213 | JOHNSON | (913) 317-7904 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.9055830 | -94.6678470 | 0 | 91 | 20 | 20091 | 28140 | Kansas City-Overland Park-Kansas City, MO-KS | Central | Johnson County | https://data.medicare.gov/resource/xubh-q36u/row-e3mi-imz9-8jhg | 170185 | 648912 | 2019-05-28 | 2018-12-31 | 75 | 8 | 83 | 12 | 95 | |||||||||||
2990 | 2990 | FAIRCHILD MEDICAL CENTER | 444 BRUCE STREET | YREKA | CA | 96097 | SISKIYOU | (530) 842-4121 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 41.7185790 | -122.6454570 | 0 | 93 | 6 | 6093 | https://data.medicare.gov/resource/xubh-q36u/row-wj65.hzqw~ibav | 51316 | 659220 | 2019-05-28 | 2018-12-31 | 21 | 4 | 25 | 25 | ||||||||||||||||
3634 | 3634 | CHILDREN'S HEALTHCARE OF ATLANTA AT SCOTTISH RITE | 1001 JOHNSON FERRY ROAD | ATLANTA | GA | 30342 | FULTON | (404) 785-5252 | Childrens | Voluntary non-profit - Other | TRUE | 33.9079000 | -84.3544260 | 0 | 121 | 13 | 13121 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Central | Fulton County | https://data.medicare.gov/resource/xubh-q36u/row-9wgb.g8f7-d9n3 | 113301 | 649891 | 2019-05-28 | 2018-12-31 | 217 | 102 | 319 | 319 | ||||||||||||
3665 | 3665 | MAYO CLINIC HEALTH SYSTEM-OAKRIDGE | 13025 8TH ST | OSSEO | WI | 54758 | TREMPEALEAU | (715) 597-3121 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 44.5779110 | -91.2163510 | 0 | 121 | 55 | 55121 | https://data.medicare.gov/resource/xubh-q36u/row-vcjc-izvc_f2he | 521302 | 649520 | 2019-05-28 | 2018-12-31 | 18 | 18 | 18 | |||||||||||||||||
4088 | 4088 | LECONTE MEDICAL CENTER | 742 MIDDLECREEK ROAD | SEVIERVILLE | TN | 37862 | SEVIER | (865) 446-7500 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 35.8538550 | -83.5369650 | 0 | 155 | 47 | 47155 | 42940 | Knoxville-Morristown-Sevierville, TN | Central | Sevier County | https://data.medicare.gov/resource/xubh-q36u/row-e253~p4xt.4gx7 | 440081 | 648984 | 2019-05-28 | 2018-12-31 | 42 | 16 | 58 | 51 | 109 | |||||||||||
4259 | 4259 | BAY PARK COMMUNITY HOSPITAL | 2801 BAY PARK DRIVE | OREGON | OH | 43616 | LUCAS | (419) 690-7700 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 41.6183000 | -83.4787000 | 0 | 173 | 39 | 39173 | 45780 | Toledo-Port Clinton, OH | Central | Wood County | https://data.medicare.gov/resource/xubh-q36u/row-7sqh_8nj6.k327 | 360259 | 648743 | 2019-05-28 | 2018-12-31 | 69 | 8 | 77 | 77 |
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 );