Alistair Johnson

No worries. If you come up with logic that was solid in whatever programming language you prefer I could write it in SQL - but no pressure.

Yeah it's a viable approach. I think it's worth investigating cases where they are only charting UO every 12-24 hours as I'm unsure how well it would work in those...

What version of `sed` do you use? I think I use GNU `sed` and if I recall BSD `sed` has different quirks..

Hrm, didn't anticipate that. There's no other source of it. We'll probably need to add it to the ED database somewhere.

Not at the moment, sorry!

The NDC is available in the hospital database and exists in MIMIC exactly as it does in the hospital data. I'm not sure how NDC is determined but likely the...

It is possible - but the process is a little bit complex and involves joining to a few NDC tables. We are continuing to work on normalizing MIMIC but it's...

I think my main concern is that it is confusing to have two urine output queries. Sorry to ask for more work, but could you summarize the differences, mainly for...

Yes what I mean is, ultimately we would have two queries for urine output. What makes more sense in my mind is a derived view from the current UO query...

What operating system are you running? The file is a shell script, and so will only work on Mac OS X or Linux. If you are on Windows, then I'm...