hospital_data
Data source: Big Local News · About: big-local-datasette
5 rows where "filed_date" is on date 2019-02-25 and hospital_ownership = "Voluntary non-profit - Other"
This data as json, copyable, CSV (advanced)
Suggested facets: hospital_type, geocode_flag, geocode_accuracy, csatitle, centraloutlyingcounty, icu_beds, subprovider_ipf_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
540 | 540 | NORTHWESTERN MEDICAL CENTER INC | 133 FAIRFIELD STREET | SAINT ALBANS | VT | 5478 | FRANKLIN | (802) 524-5911 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 44.8064630 | -73.0725490 | 0 | 11 | 50 | 50011 | 15540 | Outlying | Franklin County | https://data.medicare.gov/resource/xubh-q36u/row-3i6b-md48~jcq5 | 470024 | 643745 | 2019-02-25 | 2018-09-30 | 53 | 53 | 53 | ||||||||||||||
1222 | 1222 | NORTHSHORE UNIVERSITY HEALTHSYSTEM EVANSTON HOSP | 2650 RIDGE AVE | EVANSTON | IL | 60201 | COOK | (847) 432-8000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 42.0653000 | -87.6832930 | 0 | 31 | 17 | 17031 | 16980 | Chicago-Naperville, IL-IN-WI | Central | Cook County | https://data.medicare.gov/resource/xubh-q36u/row-emix~ri9w-scyq | 140010 | 643702 | 2019-02-25 | 2018-09-30 | 583 | 71 | 698 | 33 | 20 | 751 | ||||||||||
1391 | 1391 | MURRAY-CALLOWAY COUNTY HOSPITAL | 803 POPLAR STREET | MURRAY | KY | 42071 | CALLOWAY | (270) 762-1100 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 36.6086600 | -88.3094980 | 0 | 35 | 21 | 21035 | 34660 | Central | Calloway County | https://data.medicare.gov/resource/xubh-q36u/row-m7pf.9rnr~pkib | 180027 | 643768 | 2019-02-25 | 2018-09-30 | 89 | 10 | 99 | 12 | 12 | 154 | 277 | ||||||||||
4016 | 4016 | WAMEGO HEALTH CENTER | 711 GENN DRIVE | WAMEGO | KS | 66547 | POTTAWATOMIE | (785) 456-2295 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 39.2055110 | -96.3181930 | 0 | 149 | 20 | 20149 | 31740 | Manhattan-Junction City, KS | Outlying | Pottawatomie County | https://data.medicare.gov/resource/xubh-q36u/row-i7fc.5e2b.jxvz | 171337 | 644276 | 2019-02-25 | 2018-09-30 | 18 | 18 | 18 | |||||||||||||
4333 | 4333 | CARILION TAZEWELL COMMUNITY HOSPITAL | 388 BEN BOLT AVENUE | TAZEWELL | VA | 24651 | TAZEWELL | (276) 988-8700 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 37.1238621 | -81.4891016 | 1 | ROOFTOP | 185 | 51 | 51185 | 14140 | Central | Tazewell County | https://data.medicare.gov/resource/xubh-q36u/row-nfhr-p46d_vtsj | 490117 | 644594 | 2019-02-25 | 2018-09-30 | 56 | 56 | 56 |
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 );