hospital_data
Data source: Big Local News · About: big-local-datasette
4 rows where "filed_date" is on date 2019-12-02 and geocode_accuracy = "GEOMETRIC_CENTER"
This data as json, copyable, CSV (advanced)
Suggested facets: hospital_type, hospital_ownership, countyfips, csatitle, centraloutlyingcounty, coronary_beds, burn_beds, oth_spec_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
788 | 788 | ST MARY MEDICAL CENTER | LANGHORNE-NEWTOWN RD | LANGHORNE | PA | 19047 | BUCKS | (215) 750-2003 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.1851512 | -74.9214068 | 1 | GEOMETRIC_CENTER | 17 | 42 | 42017 | 37980 | Philadelphia-Reading-Camden, PA-NJ-DE-MD | Central | Bucks County | https://data.medicare.gov/resource/xubh-q36u/row-hzv4-x5tc.gbxp | 390258 | 662138 | 2019-12-02 | 2019-06-30 | 301 | 41 | 6 | 348 | 348 | ||||||||||
2365 | 2365 | NORTH CAROLINA BAPTIST HOSPITAL | MEDICAL CENTER BOULEVARD | WINSTON-SALEM | NC | 27157 | FORSYTH | (336) 716-2011 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 36.0896734 | -80.2713468 | 1 | GEOMETRIC_CENTER | 67 | 37 | 37067 | 49180 | Greensboro--Winston-Salem--High Point, NC | Central | Forsyth County | https://data.medicare.gov/resource/xubh-q36u/row-r4e3-jftf~8jdf | 340047 | 661763 | 2019-12-02 | 2019-06-30 | 565 | 110 | 22 | 16 | 797 | 34 | 39 | 870 | |||||||
2370 | 2370 | JEFFERSON COUNTY HOSPITAL | INTERSECTION HYWS 81 & 70 | WAURIKA | OK | 73573 | JEFFERSON | (580) 228-2344 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 34.1572807 | -97.9795416 | 1 | GEOMETRIC_CENTER | 67 | 40 | 40067 | https://data.medicare.gov/resource/xubh-q36u/row-ph4g-iebq.bzzs | 371311 | 662416 | 2019-12-02 | 2019-06-30 | 25 | 25 | 25 | ||||||||||||||||
4541 | 4541 | MEADOWS REGIONAL MEDICAL CENTER | ONE MEADOWS PARKWAY | VIDALIA | GA | 30474 | TOOMBS | (912) 535-5828 | Acute Care Hospitals | Proprietary | TRUE | 32.2071314 | -82.3777520 | 1 | GEOMETRIC_CENTER | 279 | 13 | 13279 | 47080 | Central | Toombs County | https://data.medicare.gov/resource/xubh-q36u/row-ifps.um7x~mbjr | 110128 | 659939 | 2019-12-02 | 2019-06-30 | 44 | 8 | 52 | 52 |
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 );