Difference between revisions of "Data Description Data Range"

From SICDB Doc
Jump to navigation Jump to search
(Created page with "This table contains, amongst others, data about treatment or invasivities like central lines. Data in this table has a DataID, which refers to d_references.ReferenceGlobalID, a begin offset and an end offset. {| class="wikitable" |+ data_range.csv.gz |- ! Name !! Type !! Description !! Comment |- | id || Integer ||Primary Key || |- | CaseID || Integer || Case identifier |- | DataID || Reference || || |- | Offset || Integer || Time in seconds from admission || |- | O...")
 
 
Line 15: Line 15:
|-
|-
| OffsetEnd || Integer || Time in seconds from admission ||  
| OffsetEnd || Integer || Time in seconds from admission ||  
|-
| Data || Text || May contain a json object containing additional data (i.e. endotracheal tube size, ...) ||
|}
|}
'''Note''': The data field is currently null. It has nevertheless been included for further compatibility, as it is planned to fill this field in next incremental update, which is sheduled March 2023.

Latest revision as of 08:39, 9 November 2022

This table contains, amongst others, data about treatment or invasivities like central lines. Data in this table has a DataID, which refers to d_references.ReferenceGlobalID, a begin offset and an end offset.

data_range.csv.gz
Name Type Description Comment
id Integer Primary Key
CaseID Integer Case identifier
DataID Reference
Offset Integer Time in seconds from admission
OffsetEnd Integer Time in seconds from admission
Data Text May contain a json object containing additional data (i.e. endotracheal tube size, ...)

Note: The data field is currently null. It has nevertheless been included for further compatibility, as it is planned to fill this field in next incremental update, which is sheduled March 2023.