hospital_data
Data source: Big Local News · About: big-local-datasette
13 rows where centraloutlyingcounty = "Outlying" and "filed_date" is on date 2019-11-27
This data as json, copyable, CSV (advanced)
Suggested facets: state, county_name, hospital_type, hospital_ownership, emergency_services, countyfips, statefips, csatitle, countyequivalent, acute_beds, icu_beds, subtotal_acute_beds, subprovider_irf_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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1385 | 1385 | WELLSTAR SYLVAN GROVE HOSPITAL | 1050 MCDONOUGH ROAD | JACKSON | GA | 30233 | BUTTS | (770) 775-7861 | Critical Access Hospitals | Government - Hospital District or Authority | FALSE | 33.3030850 | -83.9778230 | 0 | 35 | 13 | 13035 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Outlying | Butts County | https://data.medicare.gov/resource/xubh-q36u/row-uazj.s3pp-ngue | 111319 | 660799 | 2019-11-27 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||
| 1728 | 1728 | ASCENSION SACRED HEART GULF | 3801 E HWY 98 | PORT SAINT JOE | FL | 32456 | GULF | (850) 229-5600 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 29.7765620 | -85.2876050 | 0 | 45 | 12 | 12045 | 37460 | Outlying | Gulf County | https://data.medicare.gov/resource/xubh-q36u/row-2gve.rn5c.g9tq | 100313 | 660196 | 2019-11-27 | 2019-06-30 | 19 | 19 | 19 | ||||||||||||||
| 1899 | 1899 | DAVIS COUNTY HOSPITAL | 509 NORTH MADISON STREET | BLOOMFIELD | IA | 52537 | DAVIS | (641) 664-2145 | Critical Access Hospitals | Government - Local | TRUE | 40.7592230 | -92.4149870 | 0 | 51 | 19 | 19051 | 36900 | Outlying | Davis County | https://data.medicare.gov/resource/xubh-q36u/row-m6yx_jbnt.5nnb | 161327 | 660964 | 2019-11-27 | 2019-06-30 | 25 | 25 | 25 | ||||||||||||||
| 2744 | 2744 | JERSEY COMMUNITY HOSPITAL | 400 MAPLE SUMMIT ROAD | JERSEYVILLE | IL | 62052 | JERSEY | (618) 498-6402 | Acute Care Hospitals | Government - Local | TRUE | 39.1099060 | -90.3416220 | 0 | 83 | 17 | 17083 | 41180 | St. Louis-St. Charles-Farmington, MO-IL | Outlying | Jersey County | https://data.medicare.gov/resource/xubh-q36u/row-4rjp~camg~jz6s | 140059 | 660513 | 2019-11-27 | 2019-06-30 | 42 | 4 | 46 | 46 | ||||||||||||
| 2774 | 2774 | HSHS ST CLARE MEMORIAL HOSPITAL | 855 S MAIN ST | OCONTO FALLS | WI | 54154 | OCONTO | (920) 846-3444 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 44.8658990 | -88.1270840 | 0 | 83 | 55 | 55083 | 24580 | Green Bay-Shawano, WI | Outlying | Oconto County | https://data.medicare.gov/resource/xubh-q36u/row-9z6n_ybyz-m4ye | 521310 | 661444 | 2019-11-27 | 2019-06-30 | 22 | 22 | 22 | |||||||||||||
| 2981 | 2981 | GRAFTON CITY HOSPITAL | 1 HOSPITAL PLAZA | GRAFTON | WV | 26354 | TAYLOR | (304) 265-0400 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 39.3440370 | -80.0244130 | 0 | 91 | 54 | 54091 | 17220 | Outlying | Taylor County | https://data.medicare.gov/resource/xubh-q36u/row-hp88-6y9g.r8fy | 511307 | 661124 | 2019-11-27 | 2019-06-30 | 25 | 25 | 25 | ||||||||||||||
| 2997 | 2997 | SAINT JOSEPH MERCY LIVINGSTON HOSPITAL | 620 BYRON RD | HOWELL | MI | 48843 | LIVINGSTON | (517) 545-6000 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 42.6153720 | -83.9393550 | 0 | 93 | 26 | 26093 | 19820 | Detroit-Warren-Ann Arbor, MI | Outlying | Livingston County | https://data.medicare.gov/resource/xubh-q36u/row-ij59~ym6m-2dbe | 230069 | 660584 | 2019-11-27 | 2019-06-30 | 35 | 8 | 43 | 43 | ||||||||||||
| 3036 | 3036 | ST VINCENT ANDERSON REGIONAL HOSPITAL INC | 2015 JACKSON ST | ANDERSON | IN | 46016 | MADISON | (765) 646-8373 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 40.0962570 | -85.6804670 | 0 | 95 | 18 | 18095 | 26900 | Indianapolis-Carmel-Muncie, IN | Outlying | Madison County | https://data.medicare.gov/resource/xubh-q36u/row-srm2~bbtd-w23d | 150088 | 660941 | 2019-11-27 | 2019-06-30 | 123 | 21 | 144 | 13 | 157 | |||||||||||
| 3585 | 3585 | UCHEALTH PIKES PEAK REGIONAL HOSPITAL | 16420 WEST HIGHWAY 24 | WOODLAND PARK | CO | 80863 | TELLER | (719) 687-9999 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 38.9739320 | -105.0742670 | 0 | 119 | 8 | 8119 | 17820 | Outlying | Teller County | https://data.medicare.gov/resource/xubh-q36u/row-rxec_h64n-ugar | 61326 | 660069 | 2019-11-27 | 2019-06-30 | 15 | 15 | 15 | ||||||||||||||
| 3623 | 3623 | MAURY REGIONAL HOSPITAL | 1224 TROTWOOD AVE | COLUMBIA | TN | 38401 | MAURY | (931) 381-1111 | Acute Care Hospitals | Government - Local | TRUE | 35.6058550 | -87.0658440 | 0 | 119 | 47 | 47119 | 34980 | Nashville-Davidson--Murfreesboro, TN | Outlying | Maury County | https://data.medicare.gov/resource/xubh-q36u/row-p7jv_yp6j.kbu3 | 440073 | 660311 | 2019-11-27 | 2019-06-30 | 200 | 41 | 24 | 265 | 265 | |||||||||||
| 3640 | 3640 | MADISON COUNTY HEALTH CARE SYSTEM | 300 WEST HUTCHINGS STREET | WINTERSET | IA | 50273 | MADISON | (515) 462-2373 | Critical Access Hospitals | Government - Local | TRUE | 41.3288160 | -94.0169630 | 0 | 121 | 19 | 19121 | 19780 | Des Moines-Ames-West Des Moines, IA | Outlying | Madison County | https://data.medicare.gov/resource/xubh-q36u/row-qsgk_v4q5~5yrz | 161326 | 660963 | 2019-11-27 | 2019-06-30 | 25 | 25 | 25 | |||||||||||||
| 3985 | 3985 | MERCY HOSPITAL JOPLIN | 100 MERCY WAY | JOPLIN | MO | 64804 | JASPER | (417) 781-2727 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 37.0346970 | -94.5117990 | 0 | 145 | 29 | 29145 | 27900 | Joplin-Miami, MO-OK | Outlying | Newton County | https://data.medicare.gov/resource/xubh-q36u/row-frdj~355u_c5wj | 260001 | 660619 | 2019-11-27 | 2019-06-30 | 178 | 48 | 240 | 240 | ||||||||||||
| 4550 | 4550 | MEMORIAL MEDICAL CENTER LIVINGSTON | 1717 HWY 59 BYPASS | LIVINGSTON | TX | 77351 | POLK | (936) 327-4381 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 30.3577700 | -95.0857430 | 0 | 291 | 48 | 48291 | 26420 | Houston-The Woodlands, TX | Outlying | Liberty County | https://data.medicare.gov/resource/xubh-q36u/row-tcmj_k2rg-n33n | 450395 | 660888 | 2019-11-27 | 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 );