Derived tables with no queries in repo

MIT-LCP / eicu-code

Code and website related to the eICU Collaborative Research Database

https://eicu-crd.mit.edu

MIT License

320 stars 219 forks source link

Derived tables with no queries in repo #219

Open mirkompcr opened 1 year ago

mirkompcr commented 1 year ago

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 commented 1 year ago

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 commented 1 year ago

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 commented 9 months ago

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