Laboratory Data
Jump to navigation
Jump to search
Data Description laboratory.csv.gz
The laboratory table contains all available lab data, in many cases including the pre-admission labs.
Like all "Reference" fields additional data like name and unit of measurement is found in d_references. See SQL Examples to learn how to connect them using a relational database system.
To simplify lookup for labs of previous stays PatientID was added to this table.
| Name | Type | Description | Comment |
|---|---|---|---|
| id | Integer | Primary Key | |
| CaseID | Integer | Case identifier | |
| PatientID | Integer | Patient identifier | |
| DrugID | Reference | ||
| Offset | Integer | Time in seconds after admission | |
| LaboratoryValue | Float | Value | Unity of measurement can be found in d_references |
| LaboratoryType | Reference | Used for special laboratory types, i.e. arterial blood gas. |
Predefined Fields (RooDataServer)
| Name | Description | Comment | Type |
|---|---|---|---|
| LaboratoryCount | Amount of results of selected laboratory type in given offset | O D | |
| LaboratoryAvg | Average laboratory value of selected laboratory type in given offset | O D | |
| LaboratoryMin | Minimum laboratory value of selected laboratory type in given offset | O D | |
| LaboratoryMax | Maximum laboratory value of selected laboratory type in given offset | O D | |
| LaboratoryFirstInOffset | First laboratory value of selected laboratory type in given offset | O D | |
| LaboratoryXInOffset | X (0=first, 1=second,...) laboratory value of selected laboratory type in given offset | O D | |
| LaboratoryXInOffset | Time (offset) of x laboratory value of selected laboratory type in given offset | O D | |
| SignalStd | Standard deviation of average hourly values of selected signal | O D |