Signal Data

Data Description

Various types of signal data has been included in the SICDb dataset. Signal data is saved in data_float_h table, value reference is found in d_references.

Important note: Data stored in data_float_h is aggregated hourly data.

Predefined Fields (RooDataServer)

Generic Signal

Name	Description	Comment	Type
SignalCountHours	Amount of hours where selected signal data is available		O D
SignalAvg	Average signal value of selected signal		O D
SignalMin	Minimum hourly average signal value of selected signal		O D
SignalMax	Maximum hourly average signal value of selected signal		O D
SignalHoursUnderX	Amount of hours, where the average signal value is under X		O D
SignalHoursOverX	Amount of hours, where the average signal value is >= X		O D
SignalHoursBetweenXY	Amount of hours, where the average signal value is >=Min and <Max		O D
SignalStd	Standard deviation of average hourly values of selected signal		O D

Contains hourly float data associated with a case. If more (minute) data is available, data was aggregated and the corresponding values are stored in rawdata field. Refer to Deserialize Raw Data for more information. Metavision does, in database, not differentiate between qualitative (i.e. blood pressure) and quantitative (i.e. drainage volume) data, this was done programatically saving the sum instead of average. The field cnt indicates the amount of values aggregated.

data_float_h.csv.gz

Name	Type	Description	Comment
CaseID	Integer	Case identifier
DataID	Reference
Offset	Integer	Time in seconds after admission
Val	Float	Value	The unit (if applicable) is found in d_references where data_float_h.DataID is associated to d_references.ReferenceGlobalID
cnt	Integer	Amount of values aggregated
rawdata	Blob	List of 60 floats containing raw data	Due to excessive storage needs minute values have been aggregated.