hospital_data
Data source: Big Local News · About: big-local-datasette
4 rows where "filed_date" is on date 2018-11-28 and "fy_end_date" is on date 2018-06-30
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, hospital_ownership, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, oth_longterm_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
851 | 851 | CAVALIER COUNTY MEMORIAL HOSPITAL ASSOCIATION | 909 2ND ST | LANGDON | ND | 58249 | CAVALIER | (701) 256-6100 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 48.7612430 | -98.3666610 | 0 | 19 | 38 | 38019 | https://data.medicare.gov/resource/xubh-q36u/row-m8nv.tvsx-unkm | 351323 | 638003 | 2018-11-28 | 2018-06-30 | 20 | 20 | 20 | |||||||||||||||||
2288 | 2288 | PALO VERDE HOSPITAL | 250 NORTH FIRST STREET | BLYTHE | CA | 92225 | RIVERSIDE | (760) 922-4115 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 33.6124500 | -114.5954790 | 0 | 65 | 6 | 6065 | 40140 | Los Angeles-Long Beach, CA | Central | Riverside County | https://data.medicare.gov/resource/xubh-q36u/row-ekup.vqie~g6zn | 50423 | 658138 | 2018-11-28 | 2018-06-30 | 47 | 4 | 51 | 51 | ||||||||||||
3058 | 3058 | TOWNER COUNTY MEDICAL CENTER | HWY 281 N | CANDO | ND | 58324 | TOWNER | (701) 968-4411 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 48.4931522 | -99.2110430 | 1 | ROOFTOP | 95 | 38 | 38095 | https://data.medicare.gov/resource/xubh-q36u/row-8pd6_eppf-kx3r | 351331 | 638004 | 2018-11-28 | 2018-06-30 | 20 | 20 | 30 | 5 | 55 | ||||||||||||||
3192 | 3192 | PARKVIEW MEDICAL CENTER, INC | 400 W 16TH ST | PUEBLO | CO | 81003 | PUEBLO | (719) 584-4000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 38.2816780 | -104.6121230 | 0 | 101 | 8 | 8101 | 39380 | Pueblo-Cañon City, CO | Central | Pueblo County | https://data.medicare.gov/resource/xubh-q36u/row-6kae.fdwt~txeq | 60020 | 656879 | 2018-11-28 | 2018-06-30 | 233 | 12 | 11 | 276 | 35 | 15 | 326 |
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 );