hospital_data
Data source: Big Local News · About: big-local-datasette
9 rows where "filed_date" is on date 2019-03-04 and hospital_ownership = "Government - Local"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, subtotal_acute_beds, subprovider_ipf_beds, skilled_nursing_beds, oth_longterm_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
317 | 317 | ALLENDALE COUNTY HOSPITAL | 1787 ALLENDALE FAIRFAX RD | FAIRFAX | SC | 29827 | ALLENDALE | (803) 632-3311 | Critical Access Hospitals | Government - Local | TRUE | 32.9662250 | -81.2477270 | 0 | 5 | 45 | 45005 | https://data.medicare.gov/resource/xubh-q36u/row-bjdu~dq8g.u82d | 421300 | 645444 | 2019-03-04 | 2018-09-30 | 25 | 25 | 44 | 69 | ||||||||||||||||
513 | 513 | COX BARTON COUNTY HOSPITAL | 29 NW 1ST LANE | LAMAR | MO | 64759 | BARTON | (417) 682-6081 | Critical Access Hospitals | Government - Local | TRUE | 37.5052820 | -94.2994820 | 0 | 11 | 29 | 29011 | https://data.medicare.gov/resource/xubh-q36u/row-8cv5-t4zj_7sig | 261325 | 645577 | 2019-03-04 | 2018-09-30 | 21 | 4 | 25 | 25 | ||||||||||||||||
1533 | 1533 | GEORGE E WEEMS MEMORIAL HOSPITAL | 135 AVE G | APALACHICOLA | FL | 32320 | FRANKLIN | (850) 653-8853 | Critical Access Hospitals | Government - Local | TRUE | 29.7244840 | -84.9912750 | 0 | 37 | 12 | 12037 | https://data.medicare.gov/resource/xubh-q36u/row-z2w8_ts6n.p4qb | 101305 | 644253 | 2019-03-04 | 2018-09-30 | 25 | 25 | 25 | |||||||||||||||||
2238 | 2238 | GREENE COUNTY HOSPITAL | 509 WILSON AVENUE | EUTAW | AL | 35462 | GREENE | (205) 372-3388 | Acute Care Hospitals | Government - Local | TRUE | 32.8447440 | -87.8893070 | 0 | 63 | 1 | 1063 | https://data.medicare.gov/resource/xubh-q36u/row-dyit.ypt9~f4e7 | 10051 | 645036 | 2019-03-04 | 2018-09-30 | 20 | 20 | 72 | 92 | ||||||||||||||||
2255 | 2255 | JEFFERSON COUNTY HOSPITAL | 870 S MAIN | FAYETTE | MS | 39069 | JEFFERSON | (601) 786-3401 | Acute Care Hospitals | Government - Local | TRUE | 31.7048425 | -91.0685345 | 1 | ROOFTOP | 63 | 28 | 28063 | https://data.medicare.gov/resource/xubh-q36u/row-6ixf.trx6_t5pg | 250060 | 644298 | 2019-03-04 | 2018-09-30 | 12 | 12 | 18 | 30 | |||||||||||||||
3723 | 3723 | SHARKEY ISSAQUENA COMMUNITY HOSPITAL | 47 SOUTH FOURTH ST | ROLLING FORK | MS | 39159 | SHARKEY | (662) 873-4395 | Acute Care Hospitals | Government - Local | TRUE | 32.9053730 | -90.8849890 | 0 | 125 | 28 | 28125 | https://data.medicare.gov/resource/xubh-q36u/row-xv4d_iffv-iegn | 250079 | 643907 | 2019-03-04 | 2018-09-30 | 19 | 19 | 10 | 54 | 83 | |||||||||||||||
3832 | 3832 | NORTH SUNFLOWER MEDICAL CENTER CAH | 840 NORTH OAK AVENUE | RULEVILLE | MS | 38771 | SUNFLOWER | (662) 756-2711 | Critical Access Hospitals | Government - Local | TRUE | 33.7348390 | -90.5468230 | 0 | 133 | 28 | 28133 | 26940 | Cleveland-Indianola, MS | Central | Sunflower County | https://data.medicare.gov/resource/xubh-q36u/row-aeyn_exnd~v4c3 | 251318 | 644041 | 2019-03-04 | 2018-09-30 | 25 | 25 | 10 | 35 | ||||||||||||
4117 | 4117 | JASPER MEMORIAL HOSPITAL | 898 COLLEGE STREET | MONTICELLO | GA | 31064 | JASPER | (706) 468-6411 | Critical Access Hospitals | Government - Local | TRUE | 33.3139820 | -83.6868770 | 0 | 159 | 13 | 13159 | 12060 | Atlanta--Athens-Clarke County--Sandy Springs, GA | Outlying | Jasper County | https://data.medicare.gov/resource/xubh-q36u/row-7m3n_3mxm~mxsc | 111303 | 645064 | 2019-03-04 | 2018-09-30 | 12 | 12 | 55 | 67 | ||||||||||||
4143 | 4143 | YALOBUSHA GENERAL HOSPITAL | 630 SOUTH MAIN STREET | WATER VALLEY | MS | 38965 | YALOBUSHA | (662) 473-1411 | Acute Care Hospitals | Government - Local | FALSE | 34.1307000 | -89.6410130 | 0 | 161 | 28 | 28161 | https://data.medicare.gov/resource/xubh-q36u/row-f4gk_jx8c-563i | 250061 | 643906 | 2019-03-04 | 2018-09-30 | 26 | 26 | 122 | 148 |
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 );