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

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

✎ View and edit SQL

This data as json, copyable, CSV (advanced)

Suggested facets: state, hospital_type, geocode_flag, geocode_accuracy, countyfips, statefips, cbsacode, csatitle, centraloutlyingcounty, countyequivalent, fy_end_date, icu_beds, coronary_beds, surg_icu_beds, oth_spec_beds, subtotal_acute_beds, subprovider_ipf_beds, subprovider_irf_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
119 119 SAINT ALPHONSUS MEDICAL CENTER - BAKER CITY, INC 3325 POCAHONTAS ROAD BAKER CITY OR 97814 BAKER (541) 524-7744 Critical Access Hospitals Voluntary non-profit - Church TRUE 44.7961200 -117.8462850 0   1 41 41001         https://data.medicare.gov/resource/xubh-q36u/row-yt65-wbpr_7cai 381315 661086 2019-12-02 2019-06-30 19 2         21               21
814 814 SAINT AGNES MEDICAL CENTER 1303 E HERNDON AVE FRESNO CA 93710 FRESNO (559) 450-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 36.8371020 -119.7658780 0   19 6 6019 23420 Fresno-Madera, CA Central Fresno County https://data.medicare.gov/resource/xubh-q36u/row-m6yb~w6hh~ku8s 50093 662016 2019-12-02 2019-06-30 345 27     13   385               385
843 843 CHI HEALTH GOOD SAMARITAN P O BOX 1990, 10 EAST 31ST ST KEARNEY NE 68848 BUFFALO (308) 865-7100 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.7076254 -99.0818136 1 ROOFTOP 19 31 31019 28260   Central Buffalo County https://data.medicare.gov/resource/xubh-q36u/row-k4e3_xakc.p7ct 280009 661546 2019-12-02 2019-06-30 201 16       10 227   12           239
1066 1066 SAINT ALPHONSUS MEDICAL CENTER - NAMPA 4300 E FLAMINGO AVE NAMPA ID 83687 CANYON (208) 205-0050 Acute Care Hospitals Voluntary non-profit - Church TRUE 43.5963320 -116.5191740 0   27 16 16027 14260 Boise City-Mountain Home-Ontario, ID-OR Outlying Canyon County https://data.medicare.gov/resource/xubh-q36u/row-ei4u.dihn_gvat 130013 660927 2019-12-02 2019-06-30 74 18       4 96               96
1068 1068 ST JOSEPHS HOSPITAL 9515 HOLY CROSS LN BREESE IL 62230 CLINTON (618) 526-4511 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.6251540 -89.5249440 0   27 17 17027 41180 St. Louis-St. Charles-Farmington, MO-IL Outlying Clinton County https://data.medicare.gov/resource/xubh-q36u/row-pzsx~2awp~chq9 140145 662043 2019-12-02 2019-06-30 46           46               46
1122 1122 CHI ST VINCENT MORRILTON #4 HOSPITAL DRIVE MORRILTON AR 72110 CONWAY (501) 977-2300 Critical Access Hospitals Voluntary non-profit - Church TRUE 35.1699700 -92.7217020 0   29 5 5029         https://data.medicare.gov/resource/xubh-q36u/row-jajp~f47n.nife 41324 660162 2019-12-02 2019-06-30 25           25               25
1243 1243 PRESENCE RESURRECTION MEDICAL CENTER 7435 W TALCOTT AVENUE CHICAGO IL 60631 COOK (773) 774-8000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9884580 -87.8125700 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-pehm~qnk2_vxey 140117 662042 2019-12-02 2019-06-30 186 41         227   47           274
1244 1244 PRESENCE SAINT FRANCIS HOSPITAL 355 RIDGE AVE EVANSTON IL 60202 COOK (847) 316-4000 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0239510 -87.6851590 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-ytv8~95dy~j47j 140080 662040 2019-12-02 2019-06-30 155 16         181               181
1245 1245 PRESENCE SAINT JOSEPH HOSPITAL - CHICAGO 2900 NORTH LAKE SHORE DRIVE CHICAGO IL 60657 COOK (773) 665-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9339280 -87.6364180 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-5jgf-ct8j~vsky 140224 661871 2019-12-02 2019-06-30 258 19         277   10   26       313
1246 1246 PRESENCE SAINTS MARY AND ELIZABETH MEDICAL CENTER 2233 W DIVISION ST CHICAGO IL 60622 COOK (312) 770-2000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.9031040 -87.6832130 0   31 17 17031 16980 Chicago-Naperville, IL-IN-WI Central Cook County https://data.medicare.gov/resource/xubh-q36u/row-zjn9~e8qn.h99n 140180 661868 2019-12-02 2019-06-30 344 26         370 14 15   30       429
1274 1274 HOLY CROSS HOSPITAL 1500 FOREST GLEN ROAD SILVER SPRING MD 20910 MONTGOMERY (301) 754-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.0160550 -77.0341980 0   31 24 24031 47900 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Montgomery County https://data.medicare.gov/resource/xubh-q36u/row-nztz.3ybb.dqym 210004 659967 2019-12-02 2019-06-30 349 46       46 441               441
1324 1324 OUR LADY OF THE LAKE REGIONAL MEDICAL CENTER 5000 HENNESSY BLVD BATON ROUGE LA 70808 E. BATON ROUGE (225) 765-6565 Acute Care Hospitals Voluntary non-profit - Church TRUE 30.4013180 -91.1115280 0   33 22 22033 12940   Central East Baton Rouge Parish https://data.medicare.gov/resource/xubh-q36u/row-fxjt_dffw~6nnz 190064 661187 2019-12-02 2019-06-30 660 43     24   773 70 33           876
1537 1537 MEMORIAL HOSPITAL AND HEALTH CARE CENTER 800 W 9TH ST JASPER IN 47546 DUBOIS (812) 996-2345 Acute Care Hospitals Voluntary non-profit - Church TRUE 38.3937430 -86.9412810 0   37 18 18037 27540   Central Dubois County https://data.medicare.gov/resource/xubh-q36u/row-znqj_58gv~pyf2 150115 660942 2019-12-02 2019-06-30 85 26         111 19 8   14       152
1608 1608 PEACE HARBOR MEDICAL CENTER 400 9TH STREET FLORENCE OR 97439 LANE (541) 997-8412 Critical Access Hospitals Voluntary non-profit - Church TRUE 43.9745890 -124.1174640 0   39 41 41039 21660   Central Lane County https://data.medicare.gov/resource/xubh-q36u/row-3bhj~d2nf.qxkv 381316 662244 2019-12-02 2019-06-30 21           21               21
1753 1753 SAINT ALPHONSUS MEDICAL CENTER - ONTARIO, INC 351 SW 9TH STREET ONTARIO OR 97914 MALHEUR (541) 881-7000 Acute Care Hospitals Voluntary non-profit - Church TRUE 44.0254480 -116.9751330 0   45 41 41045 36620 Boise City-Mountain Home-Ontario, ID-OR Central Malheur County https://data.medicare.gov/resource/xubh-q36u/row-pp3w.967e-e52h 380052 661085 2019-12-02 2019-06-30 36 8         44               44
1834 1834 ST ANTHONYS MEMORIAL HOSPITAL 503 N MAPLE STREET EFFINGHAM IL 62401 EFFINGHAM (217) 342-2121 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.1244960 -88.5492740 0   49 17 17049 20820   Central Effingham County https://data.medicare.gov/resource/xubh-q36u/row-se8h.a4r7-s6mp 140032 661718 2019-12-02 2019-06-30 123 10         133               133
1889 1889 CHI ST. VINCENT HOSPITAL HOT SPRINGS 300 WERNER STREET HOT SPRINGS AR 71903 GARLAND (501) 622-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.4660350 -93.0663960 0   51 5 5051 26300 Hot Springs-Malvern, AR Central Garland County https://data.medicare.gov/resource/xubh-q36u/row-pyjq_z3nz-ckdj 40026 662146 2019-12-02 2019-06-30 204 25         229               229
2023 2023 CHI HEALTH LAKESIDE 16901 LAKESIDE HILLS CT OMAHA NE 68130 DOUGLAS (402) 717-8167 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.2390400 -96.1805320 0   55 31 31055 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Douglas County https://data.medicare.gov/resource/xubh-q36u/row-m36s-dsun.h9q7 280130 661035 2019-12-02 2019-06-30 92 16         108               108
2643 2643 ST VINCENT JENNINGS HOSPITAL INC 301 HENRY ST NORTH VERNON IN 47265 JENNINGS (812) 352-4200 Critical Access Hospitals Voluntary non-profit - Church TRUE 39.0112590 -85.6403740 0   79 18 18079 35860 Indianapolis-Carmel-Muncie, IN Central Jennings County https://data.medicare.gov/resource/xubh-q36u/row-pwb4.5pm6~qqy5 151303 660947 2019-12-02 2019-06-30 25           25               25
2653 2653 CHI HEALTH ST FRANCIS 2620 WEST FAIDLEY AVE GRAND ISLAND NE 68803 HALL (308) 384-4600 Acute Care Hospitals Voluntary non-profit - Church TRUE 40.9242670 -98.3708870 0   79 31 31079 24260   Central Hall County https://data.medicare.gov/resource/xubh-q36u/row-rgs4_gs84~mfkz 280023 661547 2019-12-02 2019-06-30 115 16       9 140   12   34       186
2892 2892 PRESENCE SAINT JOSEPH HOSPITAL - ELGIN 77 N AIRLITE STREET ELGIN IL 60123 KANE (847) 695-3200 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.0362420 -88.3279340 0   89 17 17089 16980 Chicago-Naperville, IL-IN-WI Central Kane County https://data.medicare.gov/resource/xubh-q36u/row-f78t~a38y-jgzx 140217 661870 2019-12-02 2019-06-30 129 15         144   40           184
2893 2893 PRESENCE MERCY MEDICAL CENTER 1325 N HIGHLAND AVENUE AURORA IL 60506 KANE (630) 859-2222 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.7869060 -88.3289090 0   89 17 17089 16980 Chicago-Naperville, IL-IN-WI Central Kane County https://data.medicare.gov/resource/xubh-q36u/row-hbw3.udek.9cfk 140174 662046 2019-12-02 2019-06-30 172 16         188 68             256
3038 3038 ST VINCENT MERCY HOSPITAL 1331 S A ST ELWOOD IN 46036 MADISON (765) 552-4743 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.2760200 -85.8440050 0   95 18 18095 26900 Indianapolis-Carmel-Muncie, IN Outlying Madison County https://data.medicare.gov/resource/xubh-q36u/row-kkqs-e5m3-4c2r 151308 660949 2019-12-02 2019-06-30 25           25               25
3324 3324 CHI ST ALEXIUS HEALTH WILLISTON 1301 15TH AVE W WILLISTON ND 58801 WILLIAMS (701) 774-7400 Critical Access Hospitals Voluntary non-profit - Church TRUE 48.1543320 -103.6454370 0   105 38 38105 48780   Central Williams County https://data.medicare.gov/resource/xubh-q36u/row-2m99~vhsx_qu32 351334 662569 2019-12-02 2019-06-30 25           25               25
3356 3356 AVERA GETTYSBURG HOSPITAL 606 EAST GARFIELD GETTYSBURG SD 57442 POTTER (605) 765-2480 Critical Access Hospitals Voluntary non-profit - Church TRUE 45.0135510 -99.9481280 0   107 46 46107         https://data.medicare.gov/resource/xubh-q36u/row-5ptc-f9a4-vq7p 431302 660878 2019-12-02 2019-06-30 10           10           50   60
3578 3578 ST VINCENT MEDICAL CENTER/NORTH 2215 WILDWOOD AVENUE SHERWOOD AR 72120 PULASKI (501) 552-7100 Acute Care Hospitals Voluntary non-profit - Church TRUE 34.8143780 -92.2075140 0   119 5 5119 30780 Little Rock-North Little Rock, AR Central Pulaski County https://data.medicare.gov/resource/xubh-q36u/row-92it.v7ju~ja3t 40137 659915 2019-12-02 2019-06-30 45 14         59               59
3588 3588 ST JOSEPH'S HOSPITAL 12866 TROXLER AVENUE HIGHLAND IL 62249 MADISON (618) 651-2600 Critical Access Hospitals Voluntary non-profit - Church TRUE 38.7570770 -89.6673580 0   119 17 17119 41180 St. Louis-St. Charles-Farmington, MO-IL Central Madison County https://data.medicare.gov/resource/xubh-q36u/row-9pm4-6ca4.6gzh 141336 661881 2019-12-02 2019-06-30 25           25               25
3814 3814 CHI HEALTH ST MARY'S 1301 GRUNDMAN BLVD NEBRASKA CITY NE 68410 OTOE (402) 873-3321 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.6581520 -95.8621090 0   131 31 31131         https://data.medicare.gov/resource/xubh-q36u/row-6z57~cf6y.zams 281342 661042 2019-12-02 2019-06-30 18           18               18
3897 3897 CHI HEALTH PLAINVIEW P O BOX 489, 704 NORTH THIRD ST PLAINVIEW NE 68769 PIERCE (402) 582-4245 Critical Access Hospitals Voluntary non-profit - Church TRUE 42.3587128 -97.7857721 1 ROOFTOP 139 31 31139 35740   Outlying Pierce County https://data.medicare.gov/resource/xubh-q36u/row-dyfy-rvq7~3hjd 281346 661043 2019-12-02 2019-06-30 15           15               15
4062 4062 CHI HEALTH MIDLANDS 11111 SOUTH 84TH ST PAPILLION NE 68046 SARPY (402) 593-3000 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.1368660 -96.0428250 0   153 31 31153 36540 Omaha-Council Bluffs-Fremont, NE-IA Central Sarpy County https://data.medicare.gov/resource/xubh-q36u/row-kx48-5ytk-a4rz 280105 661550 2019-12-02 2019-06-30 28           28               28
4140 4140 ST JOSEPH MERCY HOSPITAL 5301 E HURON RIVER DR ANN ARBOR MI 48106 WASHTENAW (734) 712-3456 Acute Care Hospitals Voluntary non-profit - Church TRUE 42.2618030 -83.6598190 0   161 26 26161 11460 Detroit-Warren-Ann Arbor, MI Central Washtenaw County https://data.medicare.gov/resource/xubh-q36u/row-2ct6~hcva-wfxq 230156 661012 2019-12-02 2019-06-30 389 20 6   20 15 450 24 33           507
4230 4230 ST VINCENT WILLIAMSPORT HOSPITAL INC 412 N MONROE ST WILLIAMSPORT IN 47993 WARREN (765) 762-4000 Critical Access Hospitals Voluntary non-profit - Church TRUE 40.2904700 -87.2958190 0   171 18 18171         https://data.medicare.gov/resource/xubh-q36u/row-hngk~n78p-82t8 151307 660948 2019-12-02 2019-06-30 16           16               16
4387 4387 PRESENCE SAINT JOSEPH MEDICAL CENTER 333 N MADISON ST JOLIET IL 60435 WILL (815) 725-7133 Acute Care Hospitals Voluntary non-profit - Church TRUE 41.5282480 -88.1346450 0   197 17 17197 16980 Chicago-Naperville, IL-IN-WI Central Will County https://data.medicare.gov/resource/xubh-q36u/row-fsnj.jnbg.2wfj 140007 661717 2019-12-02 2019-06-30 326 33     24   383   41           424
4425 4425 CHI ST LUKE'S HEALTH BAYLOR COLLEGE OF MEDICINE ME 7200 CAMBRIDGE, 11TH FLOOR HOUSTON TX 77030 HARRIS (832) 355-1000 Acute Care Hospitals Voluntary non-profit - Church TRUE 29.6988180 -95.3938620 0   201 48 48201 26420 Houston-The Woodlands, TX Central Harris County https://data.medicare.gov/resource/xubh-q36u/row-77i8-gn8q~45g2 450193 661413 2019-12-02 2019-06-30 475 144 18       637   24           661
4570 4570 MADISON ST JOSEPH HEALTH CENTER 100 WEST CROSS STREET MADISONVILLE TX 77864 MADISON (936) 348-2631 Critical Access Hospitals Voluntary non-profit - Church TRUE 30.9420460 -95.9099560 0   313 48 48313         https://data.medicare.gov/resource/xubh-q36u/row-nns8-bhuk_vxd6 451316 660055 2019-12-02 2019-06-30 15           15               15
4634 4634 TEXAS HEALTH HARRIS METHODIST FORT WORTH 1301 PENNSYLVANIA AVENUE FORT WORTH TX 76104 TARRANT (817) 250-2100 Acute Care Hospitals Voluntary non-profit - Church TRUE 32.7384800 -97.3393130 0   439 48 48439 19100 Dallas-Fort Worth, TX-OK Central Tarrant County https://data.medicare.gov/resource/xubh-q36u/row-5nda.skwh.p2ty 450135 661412 2019-12-02 2018-09-30 500 22 12       662               662
4719 4719 MERCY MEDICAL CENTER INC 301 SAINT PAUL PLACE BALTIMORE MD 21202 BALTIMORE CITY (410) 332-9237 Acute Care Hospitals Voluntary non-profit - Church TRUE 39.2925500 -76.6135500 0   510 24 24510 12580 Washington-Baltimore-Arlington, DC-MD-VA-WV-PA Central Baltimore city https://data.medicare.gov/resource/xubh-q36u/row-xtwd_r83t~vzt6 210008 662123 2019-12-02 2019-06-30 152 22         200       29       229

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