All public logs
Jump to navigation
Jump to search
Combined display of all available logs of SICDB Doc. You can narrow down the view by selecting a log type, the username (case-sensitive), or the affected page (also case-sensitive).
(newest | oldest) View (newer 50 | older 50) (20 | 50 | 100 | 250 | 500)- 09:35, 5 February 2023 Salkin talk contribs created page Mortality (Created page with "The "OffsetOfDeath" field denotes the elapsed time, in seconds, from admission to death, taking into account any subsequent hospital stays and out-of-hospital mortality data. The data was gathered from various sources, including government data. It is set to null if the death occurs more than one year after admission, since it is defined to 1-year mortality. For technical reasons observation time is only 6 month for some patients, field "EstimatedSurvivalObservationTime"...")
- 08:42, 9 November 2022 Salkin talk contribs created page File:Logo1HD.png
- 08:42, 9 November 2022 Salkin talk contribs uploaded File:Logo1HD.png
- 08:40, 9 November 2022 Salkin talk contribs moved page SingleFileDocumentation to SICdb Documentation
- 16:24, 8 November 2022 Salkin talk contribs created page Data range (Created page with " {{:Data Description data range}}")
- 15:33, 8 November 2022 Salkin talk contribs created page Data Description Data Range (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...")
- 10:20, 2 November 2022 Salkin talk contribs created page File:ExampleTime.jpg
- 10:20, 2 November 2022 Salkin talk contribs uploaded File:ExampleTime.jpg
- 09:47, 2 November 2022 Salkin talk contribs created page File:ExampleLab.jpg
- 09:47, 2 November 2022 Salkin talk contribs uploaded File:ExampleLab.jpg
- 09:41, 2 November 2022 Salkin talk contribs created page File:ExampleJoin.jpg
- 09:41, 2 November 2022 Salkin talk contribs uploaded File:ExampleJoin.jpg
- 10:32, 1 November 2022 Salkin talk contribs created page SQL Examples (Created page with "While the SICdb dataset is provided as csv raw data, it is designed to be used in a a relational database management system. Refer to Get Started for further information building up the database and corresponding software. == Using Referenced Fields == One of the most important tasks is decoding the referenced fields. While our Software")
- 09:40, 1 November 2022 Salkin talk contribs created page Data Description Unitlog (Created page with "The unitlog table contains information of patient transportation. Note that in many cases Metavision creates multiple entries and this data is difficult to interpret. == Raw Fields == {| class="wikitable" |+ Caption unitlog |- ! Name !! Type !! Description !! Comment |- | id || Integer || Primary Key || |- | CaseID || Integer || || |- | PatientID || Integer || || |- | LogState || Integer || Internal Metavision value. Note that in this version of the dataset th...")
- 09:34, 1 November 2022 Salkin talk contribs created page Data Description Treatment (Created page with "The treatment table contains time range data, i.e. ECMO or CRRT. {| class="wikitable" |+ treatment.csv.gz |- ! Name !! Type !! Description !! Comment |- | id || Integer || PrimaryKey || |- | CaseID || Integer || || |- | TreatmentID || Reference || || |- | Offset || Integer || Seconds from admission || || |- | OffsetEnd || Integer || End of item, Seconds from admission || || |- | TreatmentValue || Float || Value, if applicable || || |- | TreatmentData || Text...")
- 09:10, 1 November 2022 Salkin talk contribs created page Data Description Medication (Created page with "{| class="wikitable" |+ medication.csv.gz |- ! Name !! Type !! Description !! Comment |- | id || Integer || Primary Key || |- | CaseID || Integer || Case identifier || |- | LaboratoryID || Reference || || |- | Offset || Integer || Time in seconds after admission || |- | OffsetDrugEnd || Integer || If drug was given continuously refers to end of application. Field is set to 60 seconds on bolus application. || |- | Amount || Float || Full amount given regardles...")
- 08:57, 1 November 2022 Salkin talk contribs created page Data Description Laboratory (Created page with " {| class="wikitable" |+ Caption text |- ! Name !! Type !! Description !! Comment |- | id || Integer || Primary Key || |- | CaseID || Integer || Case identifier || |- | LaboratoryID || 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. Relates to d_...")
- 08:48, 1 November 2022 Salkin talk contribs created page Processed Referenced Fields (Created page with "Several fields have been preprocessed and added to the database. This includes peprocessed-for-convenience and preprocessed-for-anonymization elements. {| class="wikitable" |+ Fields |- ! Name !! Description !! Comment !! Type |- | PremedicationBetablocker || Yes/No || || |- | PremedicationACEInhibitor || Yes/No || || |- | PremedicationStatin || Yes/No || || |- | PremedicationDiuretic || Yes/No || || |- | PreconditionDiabetes || Any type of diabetes (IDDM or NI...")
- 08:44, 1 November 2022 Salkin talk contribs created page Data Description Data Ref (Created page with "data_ref.csv.gz contains referenced (nominal) data and is unique per icu admission. {| class="wikitable" |+ Caption d_references |- ! Name !! Type !! Description !! Comment |- | id || Integer ||Primary Key || |- | CaseID || Integer || |- | RefID || Reference || || |}")
- 19:52, 31 October 2022 Salkin talk contribs created page Data Description Data Float h (Created page with " {| class="wikitable" |+ Caption text |- ! 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 |- | cnt || Integer || Amount of values aggregated || |- | rawdata || Blob || List of 60 floats containing raw data || Due to excessive storage needs minute values ha...")
- 19:37, 31 October 2022 Salkin talk contribs created page Introduction (Created page with "The SICdb dataset provides insight to over 27 thousand intensive care admissions, including therapy and data of their preceding surgery. Data was collected between 2013 and 2021 from 4 of the intensive care units at the University Hospital Salzburg, having more than 3 thousand intensive care admissions per year on 37 beds. The dataset is deidentified and contains, amongst others, case information, laboratory, medication, monitor and respirator signal data.SICdb provides...")
- 19:33, 31 October 2022 Salkin talk contribs moved page File Encoding to File Description
- 19:31, 31 October 2022 Salkin talk contribs created page File Encoding (Created page with "All data files in the SICdb dataset are provided as comma seperated files (.csv) using the RFC 4180 standard. Additionally all files are compressed with gzip, an commonly used openly available compression method.")
- 18:56, 31 October 2022 Salkin talk contribs created page Data Description References (Created page with "== Data Description of references.csv.gz == The d_references table contains information on all encoded data fields of the SICDB dataset. To simplify JOIN and other types of subqueries each reference value has an unique global identifier. {| class="wikitable" |+ Caption d_references |- ! Name !! Description !! Comment |- | ReferenceGlobalID || The unique ID for the reference || Use this identifier as dictionary for alle encoded fields |- | ReferenceValue || Reference...")
