Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

follow up time #48

Open
XiangBu opened this issue Nov 2, 2021 · 3 comments
Open

follow up time #48

XiangBu opened this issue Nov 2, 2021 · 3 comments

Comments

@XiangBu
Copy link

XiangBu commented Nov 2, 2021

hi, I want to calculate survival days like 90-day or longer mortality from the date of ICU admission. I didn't find related information about follow-up time after discharge. And also I find in this paper 1-year mortality was calculated.
Sharing ICU Patient Data Responsibly Under the Society of Critical Care Medicine/European Society of Intensive Care Medicine Joint Data Science Collaboration: The Amsterdam University Medical Centers Database (AmsterdamUMCdb) Example.
Could you please clarify this? Thx a lot!
image

@patrickthoral
Copy link
Member

Hello @XiangBu, the dateofdeath field specifies the date on which the patient died calculated as the number of milliseconds since the first admission, if applicable (non-null). For patients that died in either the ICU or our hospital we are 100% sure that this information is correct. For billing purposes, for a proportion of patients we also have that data while a care path (Dutch: DBC) is active with the hospital. Typically those care paths will be finalized within the year when no chronic care is provided. However, currently the database does not contain information to be completely sure what the follow-up time was for a specific patient.

@XiangBu
Copy link
Author

XiangBu commented Nov 24, 2021

Thanks for your reply! So you mean AmsterdamUMCdb contains all patients' outcomes within ICU or hospital and DBC only contains part of patients' outcomes within one year?

@wubuyun1987
Copy link

wubuyun1987 commented Sep 21, 2024

with tempo as (
SELECT patientid,admissionid,
(dateofdeath-admittedat)/(60000 * 1440.0) as survivaldays,
case when destination='Overleden' then 1 else 0 end as mort_hosp,
case when (dateofdeath-dischargedat)/(60000 * 1440.0)<=365 then 1 else 0 end as mort_1year,
case when dateofdeath is not null then 1 else 0 end as mort_followup
FROM admissions
)
select count(admissionid) as admission_count,count(distinct patientid) as patient_count,
sum(mort_hosp) as mort_hosp_count,sum(mort_1year) as mort_1year_count
from tempo

then we can get 2,288 deaths at unit discharge and 4,730 deaths <1 year after discharge.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

3 participants