search

Trauma-Team-International / Home

Trauma Team International || Autonomio's Coronavirus Task Force
MIT License
4 stars 1 forks source link

Using `hadm_id` as the unique identifier #15

Closed mikkokotila closed 4 years ago

mikkokotila commented 4 years ago

For the analysis table, we must use an approach where hadm_id is unique, which means that if single hadm_id has more than one icustay_id we randomly pick one.

pdey commented 4 years ago

what about keeping all the icustay_id and and adding an icustay_time , instead of picking a random one. This serves two purposes -

  1. analysis phase can choose which specific icu stay they want to look into
  2. random pick may change when a VIEW is dropped and recreated, which may be not desirable if we want to tally analysis done before and after the update.
mikkokotila commented 4 years ago

Let's do last icustay_id per hadm_id.