hospital_data
Data source: Big Local News · About: big-local-datasette
9 rows where "filed_date" is on date 2019-05-22 and hospital_type = "Critical Access Hospitals"
This data as json, copyable, CSV (advanced)
Suggested facets: state, hospital_ownership, emergency_services, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, subtotal_acute_beds, subprovider_ipf_beds, nursing_fac_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
311 | 311 | ATOKA COUNTY MEDICAL CENTER | 1590 WEST LIBERTY ROAD | ATOKA | OK | 74525 | ATOKA | (580) 889-3333 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 34.3952620 | -96.1594880 | 0 | 5 | 40 | 40005 | https://data.medicare.gov/resource/xubh-q36u/row-qvh3-hh93~canr | 371300 | 649482 | 2019-05-22 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||||||
1110 | 1110 | FILLMORE COMMUNITY HOSPITAL | 674 SOUTH HIGHWAY 99 | FILLMORE | UT | 84631 | MILLARD | (435) 743-5591 | Critical Access Hospitals | Voluntary non-profit - Private | FALSE | 38.9541610 | -112.3394550 | 0 | 27 | 49 | 49027 | https://data.medicare.gov/resource/xubh-q36u/row-qrf9_kxm9-tj3a | 461301 | 648497 | 2019-05-22 | 2018-12-31 | 19 | 19 | 19 | |||||||||||||||||
1143 | 1143 | SANFORD BAGLEY MEDICAL CENTER | 203 4TH STREET NORTHWEST | BAGLEY | MN | 56621 | CLEARWATER | (218) 694-6501 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 47.5258370 | -95.4016760 | 0 | 29 | 27 | 27029 | https://data.medicare.gov/resource/xubh-q36u/row-n7dg.2zvq~dkw4 | 241328 | 649453 | 2019-05-22 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||||||
1576 | 1576 | JEFFERSON MEDICAL CENTER | 300 SOUTH PRESTON STREET | RANSON | WV | 25438 | JEFFERSON | (304) 728-1600 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 39.2959710 | -77.8582650 | 0 | 37 | 54 | 54037 | 47900 | Washington-Baltimore-Arlington, DC-MD-VA-WV-PA | Outlying | Jefferson County | https://data.medicare.gov/resource/xubh-q36u/row-ix2t~enbf.ekjg | 511319 | 649005 | 2019-05-22 | 2018-12-31 | 20 | 5 | 25 | 25 | ||||||||||||
1935 | 1935 | HEBER VALLEY HOSPITAL | 1485 SOUTH HIGHWAY 40 | HEBER CITY | UT | 84032 | WASATCH | (435) 654-2500 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 40.4890470 | -111.4092180 | 0 | 51 | 49 | 49051 | 25720 | Salt Lake City-Provo-Orem, UT | Central | Wasatch County | https://data.medicare.gov/resource/xubh-q36u/row-8mif.5tu6.xu7b | 461307 | 648498 | 2019-05-22 | 2018-12-31 | 19 | 19 | 19 | |||||||||||||
2306 | 2306 | MADISON PARISH HOSPITAL | 900 JOHNSON STREET | TALLULAH | LA | 71282 | MADISON | (318) 574-2374 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 32.4037340 | -91.1855030 | 0 | 65 | 22 | 22065 | https://data.medicare.gov/resource/xubh-q36u/row-5rgc_wpty_n97z | 191314 | 648538 | 2019-05-22 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||||||
2331 | 2331 | MEMORIAL HOSPITAL OF LAFAYETTE COUNTY | 800 CLAY ST | DARLINGTON | WI | 53530 | LAFAYETTE | (608) 776-4466 | Critical Access Hospitals | Government - Local | TRUE | 42.6839700 | -90.1104190 | 0 | 65 | 55 | 55065 | https://data.medicare.gov/resource/xubh-q36u/row-9ib5-tfyn~k464 | 521312 | 649522 | 2019-05-22 | 2018-12-31 | 25 | 25 | 25 | |||||||||||||||||
2480 | 2480 | HIGHLAND DISTRICT HOSPITAL | 1275 NORTH HIGH STREET | HILLSBORO | OH | 45133 | HIGHLAND | (937) 393-6100 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 39.2215760 | -83.6087710 | 0 | 71 | 39 | 39071 | https://data.medicare.gov/resource/xubh-q36u/row-8tax-6wz7_d86d | 361332 | 648465 | 2019-05-22 | 2018-12-31 | 25 | 25 | 10 | 35 | ||||||||||||||||
3520 | 3520 | SEDGWICK COUNTY MEMORIAL HOSPITAL | 900 CEDAR ST | JULESBURG | CO | 80737 | SEDGWICK | (970) 474-3323 | Critical Access Hospitals | Government - Local | FALSE | 40.9937430 | -102.2692320 | 0 | 115 | 8 | 8115 | https://data.medicare.gov/resource/xubh-q36u/row-ptjm_bmz6~8mzz | 61310 | 649075 | 2019-05-22 | 2018-12-31 | 9 | 9 | 32 | 41 |
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 );