hospital_data
Data source: Big Local News · About: big-local-datasette
16 rows where "filed_date" is on date 2018-11-30 and "fy_end_date" is on date 2018-06-30
This data as json, copyable, CSV (advanced)
Suggested facets: city, state, county_name, phone_number, hospital_type, hospital_ownership, geocode_flag, geocode_accuracy, countyfips, statefips, statecountyfips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, acute_beds, icu_beds, burn_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 |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
195 | 195 | SAINT ROSE DOMINICAN HOSPITALS - SIENA CAMPUS | 3001 ST ROSE PARKWAY | HENDERSON | NV | 89052 | CLARK | (702) 616-5000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 36.0045271 | -115.1150581 | 1 | ROOFTOP | 3 | 32 | 32003 | 29820 | Las Vegas-Henderson, NV-AZ | Central | Clark County | https://data.medicare.gov/resource/xubh-q36u/row-8dra~5wtd-jnuh | 290045 | 662405 | 2018-11-30 | 2018-06-30 | 244 | 50 | 326 | 326 | |||||||||||
196 | 196 | SAINT ROSE DOMINICAN HOSPITALS - ROSE DE LIMA | 102 E LAKE MEAD DR | HENDERSON | NV | 89015 | CLARK | (702) 616-5000 | Acute Care Hospitals | Voluntary non-profit - Church | TRUE | 36.0388290 | -114.9831920 | 0 | 3 | 32 | 32003 | 29820 | Las Vegas-Henderson, NV-AZ | Central | Clark County | https://data.medicare.gov/resource/xubh-q36u/row-r9pq.jhhc.4qfi | 290012 | 657913 | 2018-11-30 | 2018-06-30 | 72 | 10 | 82 | 28 | 110 | |||||||||||
351 | 351 | SAMUEL MAHELONA MEMORIAL HOSPITAL | 4800 KAWAIHAU ROAD | KAPAA | HI | 96746 | KAUAI | (808) 822-4961 | Critical Access Hospitals | Government - State | TRUE | 22.0876190 | -159.3142040 | 0 | 7 | 15 | 15007 | 28180 | Central | Kauai County | https://data.medicare.gov/resource/xubh-q36u/row-ysve.ycbm-b3qy | 121306 | 640504 | 2018-11-30 | 2018-06-30 | 5 | 5 | 9 | 66 | 80 | ||||||||||||
623 | 623 | HUMBOLDT GENERAL HOSPITAL | 118 EAST HASKELL STREET | WINNEMUCCA | NV | 89445 | HUMBOLDT | (775) 623-5222 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 40.9715810 | -117.7285340 | 0 | 13 | 32 | 32013 | 49080 | Central | Humboldt County | https://data.medicare.gov/resource/xubh-q36u/row-ca7p_4a94-fjt7 | 291308 | 641600 | 2018-11-30 | 2018-06-30 | 22 | 3 | 25 | 42 | 67 | ||||||||||||
798 | 798 | HOT SPRINGS COUNTY MEMORIAL HOSPITAL | 150 EAST ARAPAHOE | THERMOPOLIS | WY | 82443 | HOT SPRINGS | (307) 864-3121 | Critical Access Hospitals | Government - Local | TRUE | 43.6474320 | -108.1995900 | 0 | 17 | 56 | 56017 | https://data.medicare.gov/resource/xubh-q36u/row-ktb5~jtkf~b2ae | 531304 | 640300 | 2018-11-30 | 2018-06-30 | 25 | 25 | 25 | |||||||||||||||||
1459 | 1459 | TORRANCE MEMORIAL MEDICAL CENTER | 3330 LOMITA BLVD | TORRANCE | CA | 90509 | LOS ANGELES | (310) 325-9110 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 33.8126440 | -118.3437500 | 0 | 37 | 6 | 6037 | 31080 | Los Angeles-Long Beach, CA | Central | Los Angeles County | https://data.medicare.gov/resource/xubh-q36u/row-cibe~cfxf_9r58 | 50351 | 640468 | 2018-11-30 | 2018-06-30 | 391 | 44 | 12 | 25 | 472 | 40 | 512 | |||||||||
1612 | 1612 | PEACEHEALTH COTTAGE GROVE COMMUNITY MEDICAL CENTER | 1515 VILLAGE DRIVE | COTTAGE GROVE | OR | 97424 | LANE | (541) 767-5202 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 43.8038370 | -123.0386760 | 0 | 39 | 41 | 41039 | 21660 | Central | Lane County | https://data.medicare.gov/resource/xubh-q36u/row-6buq_rs3k.th8r | 381301 | 640536 | 2018-11-30 | 2018-06-30 | 14 | 14 | 14 | ||||||||||||||
2041 | 2041 | PEACEHEALTH PEACE ISLAND MEDICAL CENTER | 1117 SPRING STREET | FRIDAY HARBOR | WA | 98250 | SAN JUAN | (360) 378-2141 | Critical Access Hospitals | Voluntary non-profit - Private | TRUE | 48.5298570 | -123.0281710 | 0 | 55 | 53 | 53055 | https://data.medicare.gov/resource/xubh-q36u/row-tq94~fpij_9q58 | 501340 | 640562 | 2018-11-30 | 2018-06-30 | 10 | 10 | 10 | |||||||||||||||||
2093 | 2093 | PEACEHEALTH UNITED GENERAL MEDICAL CENTER | 2000 HOSPITAL DRIVE | SEDRO WOOLLEY | WA | 98284 | SKAGIT | (360) 856-6021 | Critical Access Hospitals | Government - Hospital District or Authority | TRUE | 48.4955160 | -122.2752870 | 0 | 57 | 53 | 53057 | 34580 | Seattle-Tacoma, WA | Central | Skagit County | https://data.medicare.gov/resource/xubh-q36u/row-bxir_c4z7.hk8y | 501329 | 640561 | 2018-11-30 | 2018-06-30 | 25 | 25 | 25 | |||||||||||||
2113 | 2113 | CHILDREN'S HOSPITAL AT MISSION | 27700 MEDICAL CENTER RD, 5TH FLOOR | MISSION VIEJO | CA | 92691 | ORANGE | (949) 365-2408 | Childrens | Voluntary non-profit - Private | TRUE | 33.5610153 | -117.6653937 | 1 | ROOFTOP | 59 | 6 | 6059 | 31080 | Los Angeles-Long Beach, CA | Central | Orange County | https://data.medicare.gov/resource/xubh-q36u/row-ux4n.c7cr-d5uw | 53306 | 659086 | 2018-11-30 | 2018-06-30 | |||||||||||||||
2371 | 2371 | TUALITY COMMUNITY HOSPITAL | 335 SE 8TH AVENUE | HILLSBORO | OR | 97123 | WASHINGTON | (503) 681-1111 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 45.5196230 | -122.9773100 | 0 | 67 | 41 | 41067 | 38900 | Portland-Vancouver-Salem, OR-WA | Central | Washington County | https://data.medicare.gov/resource/xubh-q36u/row-x4zr_f9jw.9qwd | 380021 | 662242 | 2018-11-30 | 2018-06-30 | 165 | 29 | 194 | 21 | 215 | |||||||||||
2552 | 2552 | ST JOSEPH HOSPITAL | 2901 SQUALICUM PARKWAY | BELLINGHAM | WA | 98225 | WHATCOM | (360) 734-5400 | Acute Care Hospitals | Voluntary non-profit - Other | TRUE | 48.7722780 | -122.4748780 | 0 | 73 | 53 | 53073 | 13380 | Central | Whatcom County | https://data.medicare.gov/resource/xubh-q36u/row-xf7q~fgxx.c5xi | 500030 | 662286 | 2018-11-30 | 2018-06-30 | 183 | 24 | 207 | 20 | 14 | 241 | |||||||||||
2776 | 2776 | EL CAMINO HOSPITAL | 2500 GRANT ROAD | MOUNTAIN VIEW | CA | 94040 | SANTA CLARA | (650) 940-7000 | Acute Care Hospitals | Government - Hospital District or Authority | TRUE | 37.3693410 | -122.0779330 | 0 | 85 | 6 | 6085 | 41940 | San Jose-San Francisco-Oakland, CA | Central | Santa Clara County | https://data.medicare.gov/resource/xubh-q36u/row-pztm_52rg~xmku | 50308 | 662338 | 2018-11-30 | 2018-06-30 | 303 | 39 | 388 | 25 | 30 | 443 | ||||||||||
3766 | 3766 | UNIVERSITY PEDIATRIC HOSPITAL | PUERTO RICO MEDICAL CENTER IN RIO PIEDRAS | SAN JUAN | PR | 935 | SAN JUAN | (787) 777-3232 | Childrens | Government - State | TRUE | 18.3958646 | -66.0736306 | 1 | GEOMETRIC_CENTER | 127 | 72 | 72127 | 41980 | San Juan-Carolina, PR | Central | San Juan Municipio | https://data.medicare.gov/resource/xubh-q36u/row-aat9~yvnm_fjvd | 403301 | 640173 | 2018-11-30 | 2018-06-30 | |||||||||||||||
3800 | 3800 | MERCY HOSPITAL FORT SMITH | 7301 ROGERS AVE | FORT SMITH | AR | 72903 | SEBASTIAN | (479) 314-6000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 35.3536470 | -94.3529640 | 0 | 131 | 5 | 5131 | 22900 | Central | Sebastian County | https://data.medicare.gov/resource/xubh-q36u/row-2a77_rb9f.j48w | 40062 | 661700 | 2018-11-30 | 2018-06-30 | 280 | 38 | 343 | 42 | 400 | ||||||||||||
3862 | 3862 | AVERA SACRED HEART HOSPITAL | 501 SUMMIT ST | YANKTON | SD | 57078 | YANKTON | (605) 668-8000 | Acute Care Hospitals | Voluntary non-profit - Private | TRUE | 42.8725730 | -97.4069450 | 0 | 135 | 46 | 46135 | 49460 | Central | Yankton County | https://data.medicare.gov/resource/xubh-q36u/row-p2ay-ses4.gzui | 430012 | 656749 | 2018-11-30 | 2018-06-30 | 65 | 10 | 75 | 187 | 262 |
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 );