Derived tables with no queries in repo

[mirkompcr]

Hi LCP-Team

Luca, João and I have seen tables in physionet.eicu_crd_derived without any SQL queries in the repo, i.e. debug_vent_tags, debug_vent_modes, crrt_dataset, diagnosis_categories, sepsis_from_diagnosis, treatment_categories, and ventilation_events. Do you have it somewhere? We need CRRT and ventilation data for a project with Leo and knowing how the columns are defined would not only be helpful to us, but many others as well.

Best,

Tristan

[konstshr]

Dear @mirkompcr, where may I find derived tables for the eICU database (like we have in the MIMIC IV repository)? That would be of great help. I am particularly interested in the Sepsis3 implementation. Best, Konstantin

[mirkompcr]

Dear Konstantin, The LCP Team did not have bandwidth yet to publish those queries. @tompollard and @jraffa is there an easy way to get them published?

best

[SimoneZappa]

Hey LCP Team, I'm eager to dive into ventilator modes in the eICU. Could you confirm if the queries are ready for publication?

Best, Simone