Closed Shaun2406 closed 4 years ago
Great, thanks!
Yep and I'd also add to this that you should look at carePlanGeneral - specifically cplgroup
= 'Care Limitation'' - lots of data there:
SELECT cplgroup, cplitemvalue, count(*) FROM `physionet-data.eicu_crd.careplangeneral` group by 1,2 order by 1,2
cplgroup | cplitemvalue | row count |
---|---|---|
Care Limitation | Advance directives | 118 |
Care Limitation | Comfort measures only | 4848 |
Care Limitation | Do not resuscitate | 35679 |
Care Limitation | Full therapy | 177589 |
Care Limitation | No CPR | 8627 |
Care Limitation | No augmentation of care | 1688 |
Care Limitation | No blood draws | 137 |
Care Limitation | No blood products | 265 |
Care Limitation | No cardioversion | 4315 |
Care Limitation | No intubation | 8168 |
That's great thanks Alistair, exactly what I was looking for!
If I wanted to exclude patients who had "do not resuscitate" or "comfort measures only" assigned, is the best way to do this using the 'carePlanEOL' table, and should I exclude all patients who are present in this table or only those who have 'activeupondischarge' as 'true'. I'm unclear as to whether those with 'activeupondischarge' as 'false' had an EOL discussion but decided against EOL care or if they were put into EOL care and then had this revoked when they began to recover.