I extracted vital signs data (blood pressure, heart rate, oxygen saturation, respiratory rate, and temperature) for neonatal patients. Initially, I extracted the IDs of vital signs from the CHARTEVENTS table. Then, I calculated the ages of neonatal patients and applied a filter to select those aged less than one year. Subsequently, I extracted the vital signs data into five separate CSV files, one for each vital sign. However, upon inspection, I noticed that the CSV files for blood pressure and oxygen saturation are empty, while the other vital sign data appears to be intact.
For age calculation, I employed the formula: admittime - dob. Neonates are typically identified as having an age of less than 1 year. This often results in an age of 0 days, as they are admitted immediately after birth.
Hello @alistairewj!
I extracted vital signs data (blood pressure, heart rate, oxygen saturation, respiratory rate, and temperature) for neonatal patients. Initially, I extracted the IDs of vital signs from the CHARTEVENTS table. Then, I calculated the ages of neonatal patients and applied a filter to select those aged less than one year. Subsequently, I extracted the vital signs data into five separate CSV files, one for each vital sign. However, upon inspection, I noticed that the CSV files for blood pressure and oxygen saturation are empty, while the other vital sign data appears to be intact.
For age calculation, I employed the formula: admittime - dob. Neonates are typically identified as having an age of less than 1 year. This often results in an age of 0 days, as they are admitted immediately after birth.