hospital_data
Data source: Big Local News · About: big-local-datasette
5 rows where burn_beds = 7
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_ownership, countyfips, statefips, fy_end_date, coronary_beds, surg_icu_beds, oth_spec_beds, subprovider_ipf_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1009 | 1009 | MASSACHUSETTS GENERAL HOSPITAL | 55 FRUIT STREET | BOSTON | MA | 2114 | SUFFOLK | (617) 726-2000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.3624000 | -71.0687770 | 0 | 25 | 25 | 25025 | 14460 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Suffolk County | https://data.medicare.gov/resource/xubh-q36u/row-6ivy_gyjc~gmvb | 220071 | 645105 | 2019-03-14 | 2018-09-30 | 841 | 20 | 16 | 7 | 18 | 987 | 24 | 1011 | ||||||||
1050 | 1050 | UNIVERSITY OF WI HOSPITALS & CLINICS AUTHORITY | 600 HIGHLAND AVENUE | MADISON | WI | 53792 | DANE | (608) 261-0025 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 43.0772180 | -89.4290630 | 0 | 25 | 55 | 55025 | 31540 | Madison-Janesville-Beloit, WI | Central | Dane County | https://data.medicare.gov/resource/xubh-q36u/row-99mg_w2iz-9z6j | 520098 | 661129 | 2019-11-26 | 2019-06-30 | 498 | 7 | 608 | 18 | 626 | |||||||||||
1128 | 1128 | BAKERSFIELD MEMORIAL HOSPITAL | 420 34TH ST | BAKERSFIELD | CA | 93301 | KERN | (661) 327-1792 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 35.3904740 | -119.0068360 | 0 | 29 | 6 | 6029 | 12540 | Central | Kern County | https://data.medicare.gov/resource/xubh-q36u/row-yg5p.buuv_2y73 | 50036 | 661282 | 2019-12-03 | 2019-06-30 | 342 | 41 | 7 | 31 | 421 | 421 | |||||||||||
2104 | 2104 | ORANGE COUNTY GLOBAL MEDICAL CENTER | 1001 NORTH TUSTIN AVENUE | SANTA ANA | CA | 92705 | ORANGE | (714) 953-3610 | Acute Care Hospitals | Proprietary | TRUE | 33.7536360 | -117.8342090 | 0 | 59 | 6 | 6059 | 31080 | Los Angeles-Long Beach, CA | Central | Orange County | https://data.medicare.gov/resource/xubh-q36u/row-28hr-uc2x~4s2a | 50746 | 660777 | 2019-02-01 | 2018-08-31 | 163 | 42 | 7 | 16 | 228 | 228 | ||||||||||
3074 | 3074 | UNIVERSITY OF SOUTH ALABAMA MEDICAL CENTER | 2451 FILLINGIM STREET | MOBILE | AL | 36617 | MOBILE | (251) 471-7110 | Acute Care Hospitals | Government - State | TRUE | 30.7081210 | -88.0994410 | 0 | 97 | 1 | 1097 | 33660 | Mobile-Daphne-Fairhope, AL | Central | Mobile County | https://data.medicare.gov/resource/xubh-q36u/row-cmzx-i3i2.bp42 | 10087 | 645038 | 2019-02-28 | 2018-09-30 | 117 | 9 | 7 | 16 | 149 | 149 |
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 );