hospital_data
Data source: Big Local News · About: big-local-datasette
17 rows where "filed_date" is on date 2019-02-28 and hospital_ownership = "Voluntary non-profit - Other"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_beds, all_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
186 | 186 | MAGNOLIA REGIONAL HEALTH CENTER | 611 ALCORN DRIVE | CORINTH | MS | 38834 | ALCORN | (662) 293-1000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 34.9358670 | -88.5586480 | 0 | 3 | 28 | 28003 | 18420 | Central | Alcorn County | https://data.medicare.gov/resource/xubh-q36u/row-7e2c-erdj.3exa | 250009 | 643795 | 2019-02-28 | 2018-09-30 | 139 | 24 | 163 | 19 | 182 | ||||||||||||
395 | 395 | UNIVERSITY OF VERMONT MEDICAL CENTER | 111 COLCHESTER AVE | BURLINGTON | VT | 5401 | CHITTENDEN | (802) 847-0000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 44.4809910 | -73.1955180 | 0 | 7 | 50 | 50007 | 15540 | Central | Chittenden County | https://data.medicare.gov/resource/xubh-q36u/row-sa3g~qvqf.2559 | 470003 | 643744 | 2019-02-28 | 2018-09-30 | 349 | 21 | 25 | 415 | 35 | 450 | |||||||||||
482 | 482 | WILLIAM W BACKUS HOSPITAL | 326 WASHINGTON ST | NORWICH | CT | 6360 | NEW LONDON | (860) 889-8331 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 41.5434020 | -72.0867470 | 0 | 11 | 9 | 9011 | 35980 | Hartford-West Hartford, CT | Central | New London County | https://data.medicare.gov/resource/xubh-q36u/row-x7iv~8mww_raqd | 70024 | 645051 | 2019-02-28 | 2018-09-30 | 153 | 12 | 165 | 18 | 183 | |||||||||||
807 | 807 | ST JOSEPH'S HOSPITAL | 350 NORTH WILMOT ROAD | TUCSON | AZ | 85711 | PIMA | (520) 873-3000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 32.2259460 | -110.8578380 | 0 | 19 | 4 | 4019 | 46060 | Tucson-Nogales, AZ | Central | Pima County | https://data.medicare.gov/resource/xubh-q36u/row-trzm-jqcs_wpf7 | 30011 | 644090 | 2019-02-28 | 2018-09-30 | 377 | 32 | 30 | 451 | 15 | 20 | 486 | |||||||||
1084 | 1084 | HEALTH ALLIANCE - CLINTON HOSPITAL | 60 HOSPITAL ROAD | LEOMINSTER | MA | 1453 | WORCESTER | (978) 466-2000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 42.5411930 | -71.7630330 | 0 | 27 | 25 | 25027 | 49340 | Boston-Worcester-Providence, MA-RI-NH-CT | Central | Worcester County | https://data.medicare.gov/resource/xubh-q36u/row-y6vw_ua5p.gsn5 | 220001 | 644639 | 2019-02-28 | 2018-09-30 | 120 | 10 | 130 | 20 | 150 | |||||||||||
1446 | 1446 | JACKSON GENERAL HOSPITAL | 122 PINNELL ST | RIPLEY | WV | 25271 | JACKSON | (304) 372-2731 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 38.8235410 | -81.7283250 | 0 | 35 | 54 | 54035 | https://data.medicare.gov/resource/xubh-q36u/row-qz6z~eyng~xsxm | 511320 | 645206 | 2019-02-28 | 2018-09-30 | 25 | 25 | 25 | |||||||||||||||||
1810 | 1810 | COLUMBUS REGIONAL HEALTHCARE SYSTEM | 500 JEFFERSON ST | WHITEVILLE | NC | 28472 | COLUMBUS | (910) 642-8011 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 34.3386570 | -78.6936440 | 0 | 47 | 37 | 37047 | https://data.medicare.gov/resource/xubh-q36u/row-ucyn-b8wt_9jnp | 340068 | 645347 | 2019-02-28 | 2018-09-30 | 144 | 10 | 154 | 154 | ||||||||||||||||
1893 | 1893 | HENDRY REGIONAL MEDICAL CENTER | 524 W SAGAMORE AVE | CLEWISTON | FL | 33440 | HENDRY | (863) 902-3033 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 26.7532390 | -80.9422760 | 0 | 51 | 12 | 12051 | 17500 | Central | Hendry County | https://data.medicare.gov/resource/xubh-q36u/row-ati4-fhfd_57wb | 101309 | 643695 | 2019-02-28 | 2018-09-30 | 22 | 3 | 25 | 25 | |||||||||||||
2045 | 2045 | FAYETTE MEDICAL CENTER | 1653 TEMPLE AVENUE NORTH | FAYETTE | AL | 35555 | FAYETTE | (205) 932-5966 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 33.7077080 | -87.8237060 | 0 | 57 | 1 | 1057 | https://data.medicare.gov/resource/xubh-q36u/row-f7kw.zhbj_gfwf | 10045 | 644692 | 2019-02-28 | 2018-09-30 | 37 | 8 | 45 | 122 | 167 | |||||||||||||||
2513 | 2513 | SCRIPPS GREEN HOSPITAL | 10666 NORTH TORREY PINES ROAD | LA JOLLA | CA | 92037 | SAN DIEGO | (858) 455-9100 | Acute Care Hospitals | Voluntary non-profit - Other | FALSE | 32.8971240 | -117.2418540 | 0 | 73 | 6 | 6073 | 41740 | Central | San Diego County | https://data.medicare.gov/resource/xubh-q36u/row-k5xn~6853~5e64 | 50424 | 644216 | 2019-02-28 | 2018-09-30 | 100 | 24 | 150 | 150 | |||||||||||||
2795 | 2795 | KING'S DAUGHTERS MEDICAL CENTER-BROOKHAVEN | P O BOX 948/427 HIGHWAY 51 NORTH | BROOKHAVEN | MS | 39601 | LINCOLN | (601) 833-6011 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 31.5892013 | -90.4580392 | 1 | ROOFTOP | 85 | 28 | 28085 | 15020 | Jackson-Vicksburg-Brookhaven, MS | Central | Lincoln County | https://data.medicare.gov/resource/xubh-q36u/row-5ntd-ntch~5mxf | 250057 | 643905 | 2019-02-28 | 2018-09-30 | 85 | 5 | 90 | 90 | |||||||||||
2870 | 2870 | UNION MEDICAL CENTER | 322 WEST SOUTH STREET | UNION | SC | 29379 | UNION | (864) 301-2000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 34.7114380 | -81.6286680 | 0 | 87 | 45 | 45087 | 43900 | Greenville-Spartanburg-Anderson, SC | Outlying | Union County | https://data.medicare.gov/resource/xubh-q36u/row-a8su_cikk-4j4z | 420108 | 645181 | 2019-02-28 | 2018-09-30 | 43 | 6 | 49 | 49 | ||||||||||||
3459 | 3459 | GULF BREEZE HOSPITAL | 1110 GULF BREEZE PKWY | GULF BREEZE | FL | 32561 | SANTA ROSA | (850) 934-2000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 30.3586490 | -87.1568030 | 0 | 113 | 12 | 12113 | 37860 | Central | Santa Rosa County | https://data.medicare.gov/resource/xubh-q36u/row-i236_mnds-pgjj | 100266 | 646028 | 2019-02-28 | 2018-09-30 | 57 | 8 | 65 | 65 | |||||||||||||
4082 | 4082 | WEBSTER GENERAL HOSPITAL/ SWING BED | 70 MEDICAL PLAZA | EUPORA | MS | 39744 | WEBSTER | (662) 258-6221 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 33.5347360 | -89.2669430 | 0 | 155 | 28 | 28155 | https://data.medicare.gov/resource/xubh-q36u/row-a3qx_u9bd-sjek | 250020 | 643797 | 2019-02-28 | 2018-09-30 | 38 | 38 | 38 | |||||||||||||||||
4228 | 4228 | TROUSDALE MEDICAL CENTER | 500 CHURCH STREET | HARTSVILLE | TN | 37074 | TROUSDALE | (615) 374-2221 | Critical Access Hospitals | Voluntary non-profit - Other | TRUE | 36.3881360 | -86.1676920 | 0 | 169 | 47 | 47169 | 34980 | Nashville-Davidson--Murfreesboro, TN | Outlying | Trousdale County | https://data.medicare.gov/resource/xubh-q36u/row-b84v_4ggv_qpsn | 441301 | 644183 | 2019-02-28 | 2018-09-30 | 25 | 25 | 25 | |||||||||||||
4343 | 4343 | WARREN MEMORIAL HOSPITAL | 1000 NORTH SHENANDOAH AVE | FRONT ROYAL | VA | 22630 | WARREN | (703) 636-0300 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 38.9304150 | -78.1989300 | 0 | 187 | 51 | 51187 | 47900 | Washington-Baltimore-Arlington, DC-MD-VA-WV-PA | Outlying | Warren County | https://data.medicare.gov/resource/xubh-q36u/row-6zt4-iv48_jqpm | 490033 | 645197 | 2019-02-28 | 2018-09-30 | 38 | 8 | 46 | 120 | 166 | |||||||||||
4406 | 4406 | MISSOURI DELTA MEDICAL CENTER | 1008 NORTH MAIN ST | SIKESTON | MO | 63801 | SCOTT | (573) 471-1600 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 36.8890480 | -89.5843460 | 0 | 201 | 29 | 29201 | 43460 | Cape Girardeau-Sikeston, MO-IL | Central | Scott County | https://data.medicare.gov/resource/xubh-q36u/row-gnum~mcff-uuan | 260113 | 645121 | 2019-02-28 | 2018-09-30 | 98 | 12 | 110 | 12 | 11 | 133 |
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 );