hospital_data

Table actions
Data provided via a collaboration between The Accountability Project and Big Local News. This project provides and joins datasets pertinent to the COVID-19 pandemic: hospital location and number of beds by type, county-level population estimates by age (which can be linked to hospital data) and nursing home location and capacity. See README for additional information.

Data source: Big Local News · About: big-local-datasette

15 rows where "filed_date" is on date 2019-12-03 and hospital_ownership = "Voluntary non-profit - Church"

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, emergency_services, geocode_flag, geocode_accuracy, countyfips, statefips, csatitle, centraloutlyingcounty, acute_beds, icu_beds, coronary_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_beds, skilled_nursing_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
86 86 SAINT ALPHONSUS REGIONAL MEDICAL CENTER 1055 NORTH CURTIS ROAD BOISE ID 83706 ADA (208) 367-2121 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.6140720 -116.2536220 0   1 16 16001 14260 Boise City-Mountain Home-Ontario, ID-OR Central Ada County https://data.medicare.gov/resource/xubh-q36u/row-bd8k~rga3_kmdd 130007 662193 2019-12-03 2019-06-30 282 42       24 348   30           378
199 199 SAINT ROSE DOMINICAN HOSPITALS - SAN MARTIN CAMPUS 8280 W WARM SPRINGS ROAD LAS VEGAS NV 89113 CLARK (702) 492-8509 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.0555450 -115.2713230 0   3 32 32003 29820 Las Vegas-Henderson, NV-AZ Central Clark County https://data.medicare.gov/resource/xubh-q36u/row-sdqu.kd85~4dy8 290053 662224 2019-12-03 2019-06-30 106 24         136               136
561 561 MERCY GILBERT MEDICAL CENTER 3555 SOUTH VAL VISTA DRIVE GILBERT AZ 85297 MARICOPA (480) 728-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.2866610 -111.7553110 0   13 4 4013 38060   Central Maricopa County https://data.medicare.gov/resource/xubh-q36u/row-ab5w_8jiw.5ys7 30119 662011 2019-12-03 2019-06-30 174 24         198               198
705 705 CHI ST ALEXIUS HEALTH 900 E BROADWAY BISMARCK ND 58501 BURLEIGH (701) 530-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 46.8063690 -100.7770750 0   15 38 38015 13900   Central Burleigh County https://data.medicare.gov/resource/xubh-q36u/row-i4ue-xmjd.qmkx 350002 662065 2019-12-03 2019-06-30 142 39         181 25     19       225
1349 1349 GALION COMMUNITY HOSPITAL 269 PORTLAND WAY SOUTH GALION OH 44833 CRAWFORD (419) 468-4841 Critical Access Hospitals Voluntary non-profit - Church FALSE 40.7311430 -82.8032960 0   33 39 39033 15340 Mansfield-Ashland-Bucyrus, OH Central Crawford County https://data.medicare.gov/resource/xubh-q36u/row-5krw_yxr7-22n8 361325 661619 2019-12-03 2019-06-30 22 3         25   10           35
1454 1454 ST MARY MEDICAL CENTER 1050 LINDEN AVE LONG BEACH CA 90813 LOS ANGELES (562) 491-9000 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.7799540 -118.1866830 0   37 6 6037 31080 Los Angeles-Long Beach, CA Central Los Angeles County https://data.medicare.gov/resource/xubh-q36u/row-822b_vkkd-dfpx 50191 662021 2019-12-03 2019-06-30 195 30       25 250   34           284
2429 2429 LOMA LINDA UNIVERSITY CHILDREN'S HOSPITAL 11234 ANDERSON STREET SUITE A LOMA LINDA CA 92354 SAN BERNARDINO (909) 558-8000 Acute Care Hospitals Voluntary non-profit - Church FALSE 34.0494820 -117.2611220 0   71 6 6071 40140 Los Angeles-Long Beach, CA Central San Bernardino County https://data.medicare.gov/resource/xubh-q36u/row-pf24-s78t.y754 50778 662028 2019-12-03 2019-06-30 160         84 343               343
2703 2703 SAINT MARY'S HEALTH CARE 200 JEFFERSON AVENUE SE GRAND RAPIDS MI 49503 KENT (616) 685-5000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.9582520 -85.6641140 0   81 26 26081 24340 Grand Rapids-Wyoming-Muskegon, MI Central Kent County https://data.medicare.gov/resource/xubh-q36u/row-nf3c_wwgn.2t3h 230059 661537 2019-12-03 2019-06-30 228 32       15 275 28             303
3414 3414 ST JOHNS PLEASANT VALLEY HOSPITAL 2309 ANTONIO AVE CAMARILLO CA 93010 VENTURA (805) 389-5800 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.2429650 -119.0183060 0   111 6 6111 37100 Los Angeles-Long Beach, CA Central Ventura County https://data.medicare.gov/resource/xubh-q36u/row-t2cn.wci4_rvdy 50616 662168 2019-12-03 2019-06-30 73 8         81       74       155
3797 3797 KETCHIKAN MEDICAL CENTER 3100 TONGASS AVENUE KETCHIKAN AK 99901 KETCHIKAN GATEWAY (907) 225-5171 Critical Access Hospitals Voluntary non-profit - Church TRUE 55.3527170 -131.6860490 0   130 2 2130 28540   Central Ketchikan Gateway Borough https://data.medicare.gov/resource/xubh-q36u/row-qt33-ugsf~ggm9 21311 661277 2019-12-03 2019-06-30 21 4         25       29       54
4104 4104 TRINITY HOSPITAL TWIN CITY 819 NORTH FIRST STREET DENNISON OH 44621 TUSCARAWAS (740) 922-2800 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.4014640 -81.3358740 0   157 39 39157 35420 Cleveland-Akron-Canton, OH Central Tuscarawas County https://data.medicare.gov/resource/xubh-q36u/row-yjye.hnn5~27ky 361302 661614 2019-12-03 2019-06-30 25           25               25
4152 4152 HSHS ST ELIZABETH'S HOSPITAL ONE ST ELIZABETH BOULEVARD O FALLON IL 62269 ST. CLAIR (618) 234-2120 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.5836880 -89.9322498 1 ROOFTOP 163 17 17163 41180 St. Louis-St. Charles-Farmington, MO-IL Central St. Clair County https://data.medicare.gov/resource/xubh-q36u/row-pfxz-kai8~phvk 140187 661498 2019-12-03 2019-06-30 112 16         128   16           144
4164 4164 ASCENSION ST JOHN HOSPITAL 22101 MOROSS RD DETROIT MI 48236 WAYNE (313) 343-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.4190110 -82.9150080 0   163 26 26163 19820 Detroit-Warren-Ann Arbor, MI Central Wayne County https://data.medicare.gov/resource/xubh-q36u/row-x44u_zj2b.k8t2 230165 661342 2019-12-03 2019-06-30 462 52       35 549 27 36           612
4207 4207 ST FRANCIS MEDICAL CENTER 2400 ST FRANCIS DRIVE BRECKENRIDGE MN 56520 WILKIN (218) 643-3000 Critical Access Hospitals Voluntary non-profit - Church TRUE 46.2913140 -96.5904330 0   167 27 27167 47420 Fargo-Wahpeton, ND-MN Outlying Wilkin County https://data.medicare.gov/resource/xubh-q36u/row-z674~sdts.8mhw 241377 661740 2019-12-03 2019-06-30 25           25       80       105
4560 4560 COVENANT MEDICAL CENTER 3615 19TH STREET LUBBOCK TX 79410 LUBBOCK (806) 725-4431 Acute Care Hospitals Voluntary non-profit - Church TRUE 33.5778670 -101.8923570 0   303 48 48303 31180 Lubbock-Levelland, TX Central Lubbock County https://data.medicare.gov/resource/xubh-q36u/row-itui.bmgg_p92r 450040 660464 2019-12-03 2019-06-30 283 48 49       380               380

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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
);