User contributions for Salkin
Jump to navigation
Jump to search
- 09:49, 3 November 2022 diff hist −37 Deserialize Raw Data
- 09:48, 3 November 2022 diff hist −12 Deserialize Raw Data
- 09:46, 3 November 2022 diff hist −2 Deserialize Raw Data
- 09:41, 3 November 2022 diff hist +42 SICdb Documentation
- 09:39, 3 November 2022 diff hist −6 Deserialize Raw Data
- 09:38, 3 November 2022 diff hist +1,125 Deserialize Raw Data
- 08:48, 3 November 2022 diff hist +1 Data Description Data Float h
- 08:47, 3 November 2022 diff hist +81 Data Description Data Float h
- 08:46, 3 November 2022 diff hist −39 Data Description Cases
- 08:44, 3 November 2022 diff hist +5 SICdb Documentation
- 10:35, 2 November 2022 diff hist −1 SQL Examples
- 10:30, 2 November 2022 diff hist +560 SQL Examples
- 10:29, 2 November 2022 diff hist +79 SQL Examples
- 10:28, 2 November 2022 diff hist +82 SQL Examples
- 10:26, 2 November 2022 diff hist +19 SICdb Documentation
- 10:26, 2 November 2022 diff hist +19 SICdb Documentation
- 10:21, 2 November 2022 diff hist +38 SQL Examples
- 10:20, 2 November 2022 diff hist +46 N File:ExampleTime.jpg current
- 10:18, 2 November 2022 diff hist +1,532 SQL Examples
- 10:02, 2 November 2022 diff hist +4 SQL Examples
- 10:02, 2 November 2022 diff hist +292 SQL Examples
- 09:53, 2 November 2022 diff hist +7 SQL Examples
- 09:49, 2 November 2022 diff hist +765 SQL Examples
- 09:47, 2 November 2022 diff hist +32 N File:ExampleLab.jpg current
- 09:41, 2 November 2022 diff hist +44 N File:ExampleJoin.jpg current
- 10:32, 1 November 2022 diff hist +344 N 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"
- 10:11, 1 November 2022 diff hist −1 Unitlog →Table Description current
- 10:11, 1 November 2022 diff hist −507 Unitlog Replaced content with "==Table Description== {{:Data Description Unitlog}}" Tag: Replaced
- 10:10, 1 November 2022 diff hist +34 SICdb Documentation
- 10:06, 1 November 2022 diff hist +93 SICdb Documentation
- 10:06, 1 November 2022 diff hist +1,500 Case Description
- 09:41, 1 November 2022 diff hist −73 Data Description Unitlog
- 09:40, 1 November 2022 diff hist +688 N 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 diff hist +528 N 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..." current
- 09:13, 1 November 2022 diff hist −3 File List
- 09:11, 1 November 2022 diff hist +75 SICdb Documentation
- 09:11, 1 November 2022 diff hist +47 Data Description Laboratory
- 09:11, 1 November 2022 diff hist −36 Medication Data current
- 09:10, 1 November 2022 diff hist +631 N 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:59, 1 November 2022 diff hist +187 SICdb Documentation
- 08:59, 1 November 2022 diff hist −552 Laboratory Data current
- 08:58, 1 November 2022 diff hist +109 Data Description Laboratory
- 08:57, 1 November 2022 diff hist +510 N 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:55, 1 November 2022 diff hist −43 Data Description References
- 08:54, 1 November 2022 diff hist −5 Data Description Data Ref
- 08:52, 1 November 2022 diff hist +85 SICdb Documentation
- 08:51, 1 November 2022 diff hist −675 Data ref current
- 08:51, 1 November 2022 diff hist +55 Processed Referenced Fields
- 08:51, 1 November 2022 diff hist +150 Processed Referenced Fields
- 08:48, 1 November 2022 diff hist +806 N 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:45, 1 November 2022 diff hist −20 Data ref
- 08:45, 1 November 2022 diff hist −343 Data ref
- 08:44, 1 November 2022 diff hist +15 Data Description Data Ref
- 08:44, 1 November 2022 diff hist +273 N 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 || || |}"
- 21:14, 31 October 2022 diff hist +90 SICdb Documentation
- 19:52, 31 October 2022 diff hist −1,268 Float Data Hourly Replaced content with "{{:Data Description Data Float h}}" current Tag: Replaced
- 19:52, 31 October 2022 diff hist +1,303 N 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:51, 31 October 2022 diff hist −17 Float Data Hourly
- 19:50, 31 October 2022 diff hist −588 Float Data Hourly
- 19:45, 31 October 2022 diff hist −50 File List →Data Files
- 19:45, 31 October 2022 diff hist −15 File List →Data Files
- 19:43, 31 October 2022 diff hist −141 Main Page current
- 19:42, 31 October 2022 diff hist −150 Main Page
- 19:42, 31 October 2022 diff hist −49 Introduction
- 19:39, 31 October 2022 diff hist −3 Introduction
- 19:39, 31 October 2022 diff hist +129 Introduction
- 19:37, 31 October 2022 diff hist +717 N 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:34, 31 October 2022 diff hist +27 SICdb Documentation
- 19:34, 31 October 2022 diff hist +39 File Description
- 19:33, 31 October 2022 diff hist +30 N File Encoding Salkin moved page File Encoding to File Description current Tag: New redirect
- 19:33, 31 October 2022 diff hist 0 m File Description Salkin moved page File Encoding to File Description
- 19:32, 31 October 2022 diff hist +18 SICdb Documentation
- 19:31, 31 October 2022 diff hist +212 N File Description 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."
- 19:21, 31 October 2022 diff hist +83 Version
- 19:19, 31 October 2022 diff hist −7 SICdb Documentation
- 19:19, 31 October 2022 diff hist +564 SICdb Documentation
- 19:15, 31 October 2022 diff hist 0 Data Description References
- 19:15, 31 October 2022 diff hist −15 Data Description References
- 19:05, 31 October 2022 diff hist +47 Data Description References →Data Description of references.csv.gz
- 19:02, 31 October 2022 diff hist +317 Data Description Cases →Data Description of cases.csv.gz
- 18:57, 31 October 2022 diff hist +32 SICdb Documentation
- 18:56, 31 October 2022 diff hist −1,136 Reference Table
- 18:56, 31 October 2022 diff hist +747 N 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..."
- 18:50, 31 October 2022 diff hist +2 SICdb Documentation
- 18:49, 31 October 2022 diff hist −20 Data Description Cases
- 18:48, 31 October 2022 diff hist −2,588 Case Data
- 18:47, 31 October 2022 diff hist −1 Data Description Cases
- 18:47, 31 October 2022 diff hist +2,422 N Data Description Cases Created page with "== Data Description of cases.csv.gz === === Raw Fields === {| class="wikitable" |+ Caption text |- ! Name !! Description !! Comment |- | CaseID || A randomly assigned identifier || CaseID is unique to each admission. |- | PatientID || A randomly assigned identifier || PatientID is unique to each Patient, useful to identify readmission |- | AdmissionYear || Year of admission || |- | TimeOfStay || Time of stay || Time from primary metavision admission, to last dischar..."
- 18:41, 31 October 2022 diff hist 0 SICdb Documentation
- 18:39, 31 October 2022 diff hist +71 N SICdb Documentation Created page with "== List of files == {{:Case Data:Raw Fields}} {{:Float Data Hourly}}"
- 18:33, 31 October 2022 diff hist −100 Case Data →Raw Fields
- 18:32, 31 October 2022 diff hist −95 Case Data →Raw Fields
- 15:28, 28 October 2022 diff hist −1,038 File List →Data Files
- 15:27, 28 October 2022 diff hist +1,110 File List →Data Files
- 15:22, 28 October 2022 diff hist +443 Case Data
- 09:03, 11 October 2022 diff hist +56 Data Description current
- 09:03, 11 October 2022 diff hist +1 Main Page
- 07:53, 11 October 2022 diff hist −4 Main Page
- 19:30, 10 October 2022 diff hist −30 Case Description →Validation
- 19:28, 10 October 2022 diff hist 0 Case Description →Case Selection