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 20 | older 20) (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 uploaded File:Logo1HD.png
- 08:42, 9 November 2022 Salkin talk contribs created page 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 uploaded File:ExampleTime.jpg
- 10:20, 2 November 2022 Salkin talk contribs created page File:ExampleTime.jpg
- 09:47, 2 November 2022 Salkin talk contribs uploaded File:ExampleLab.jpg
- 09:47, 2 November 2022 Salkin talk contribs created page File:ExampleLab.jpg
- 09:41, 2 November 2022 Salkin talk contribs uploaded File:ExampleJoin.jpg
- 09:41, 2 November 2022 Salkin talk contribs created page 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...")