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).

Logs
(newest | oldest) View (newer 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 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...")
  • 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...")
  • 18:47, 31 October 2022 Salkin talk contribs created page 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:39, 31 October 2022 Salkin talk contribs created page SingleFileDocumentation (Created page with "== List of files == {{:Case Data:Raw Fields}} {{:Float Data Hourly}}")
  • 18:59, 10 October 2022 Salkin talk contribs created page Treatment Data (Created page with "== Raw Fields == {| class="wikitable" |+ Caption treatment |- ! Name !! Description !! Comment |- | id || Primary Key || |- | CaseID || || |- | TreatmentID || Refer to d_references for value (d_reference.ReferenceGlobalID = Treatment.TreatmentID || |- | Offset || Time in seconds from admission || |- | OffsetEnd || Time in seconds from admission, end of treatment || |}")
  • 14:58, 10 October 2022 Salkin talk contribs created page Data ref (Created page with "==Table Description== The data_ref table contains one-per-case referenced data. == Predefined Fields (RooDataServer) == {| 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 NIDDM) || || |- | Preconditi...")
  • 14:36, 10 October 2022 Salkin talk contribs created page File:RooDataServer Statistics.png
  • 14:36, 10 October 2022 Salkin talk contribs uploaded File:RooDataServer Statistics.png
  • 14:35, 10 October 2022 Salkin talk contribs deleted page File:RooDataServerStatistics.png
  • 14:34, 10 October 2022 Salkin talk contribs created page RooDataServer (Created page with "== Introduction == RooDataServer is part of the SICdb software package. It is used to build up the database from .csv files, view and browse the data and export == Import == After installing and starting the environment open http://localhost:5000 in your browser. Follow the instructions for installing the dataset. The import may take several hours and can be interrupted. == Query and Export == The Query Manager is used to create extended queries using predefined fie...")
  • 14:31, 10 October 2022 Salkin talk contribs deleted page RooDataServer Statistics (content was: "== Introduction == RooDataServer has an extendable quick statistics system. These statistics are just for quick data analysis and must be recalculated by any validated statistics software. thumb", and the only contributor was "Salkin" (talk))
  • 14:29, 10 October 2022 Salkin talk contribs created page RooDataServer Statistics (Created page with "== Introduction == RooDataServer has an extendable quick statistics system. These statistics are just for quick data analysis and must be recalculated by any validated statistics software. thumb")
  • 14:29, 10 October 2022 Salkin talk contribs uploaded File:RooDataServerStatistics.png
  • 14:29, 10 October 2022 Salkin talk contribs created page File:RooDataServerStatistics.png
  • 12:02, 9 October 2022 Salkin talk contribs created page Unitlog (Created page with "==Table Description== The d_unitlog table contains information of patient transportation. == Raw Fields == {| class="wikitable" |+ Caption unitlog |- ! Name !! Description !! Comment |- | id || Primary Key || |- | CaseID || || |- | PatientID|| || |- | LogState || Internal raw Metavision value || |- | Offset || Time in seconds after admission || |- | HospitalUnit || Encoded unit value, unitlog.HospitalUnit = d_references.ReferenceGlobalID || i.e. C) |}")
  • 11:43, 9 October 2022 Salkin talk contribs deleted page SICdb Environment (content was: "== Introduction == Working with medium sized datasets like SICdb may present a challenge to work with. While it is still possible to access using standard consumer hardware, not all applications are able to load, view, and filter data this size. At more than a billion data entries not even Spreadsheet software like Microsoft Excel will crumble, even importing into a mysql databa...", and the only contributor was "Salkin" (talk))
  • 11:33, 9 October 2022 Salkin talk contribs uploaded File:ReferenceSelection.jpg
  • 11:33, 9 October 2022 Salkin talk contribs created page File:ReferenceSelection.jpg
  • 10:52, 9 October 2022 Salkin talk contribs created page Software Description (Created page with "== Introduction == We provide a software package to simplify building up a database, browsing through data and exporting specific parts of the database in one of the supported file formats. To install our software refer to the Get Started page. == Software Components == === MySQL Server Community Edition === MySQL is an open-source relational database managment system.<ref>https://en.wikipedia.org/wiki/MySQL</ref> === phpMyAdmin === PhpMyAdmin is one of the...")
  • 10:42, 9 October 2022 Salkin talk contribs created page D references (Redirected page to Reference Table) Tag: New redirect
  • 16:25, 8 October 2022 Salkin talk contribs created page Deserialize Raw Data (Created page with "== Theory == The raw data field is a stream of 60 little endian IEEE 754 floats, so it has exactly 240 bytes. The first 4 bytes represent the first minute of the hour and so on. Note that 0x000000 is defined to be NULL (no value). == C# example == public static float?[] GetRawValues(byte[] data) { var elements = data.Length / 4; byte[] buf = new byte[4]; float?[] ret = new float?[elements]; for(int i = 0...")
  • 16:14, 8 October 2022 Salkin talk contribs created page Data float h (Redirected page to Float Data Hourly) Tag: New redirect
  • 16:11, 8 October 2022 Salkin talk contribs created page Float Data Hourly (Created page with "== Raw Fields == {| class="wikitable" |+ Caption text |- ! Name !! Description !! Comment |- | CaseID || Case identifier || |- | DataID || Reference stored in d_references || DataID=ReferenceGlobalID |- | Offset || Time in seconds after admission || |- | Val || Value || |- | cnt || Amount of values aggregated || |- | rawdata || List of 60 floats containing raw data || Due to excessive storage needs minute values have been aggregated. |} == Aggregation Descr...")
  • 16:08, 8 October 2022 Salkin talk contribs created page Laboratory Data (Created page with "== Data Description == All automatically collected laboratory data was included in the SICdb dataset. This includes in many cases pre-admission laboratory. == Predefined Fields (RooDataServer) == {| class="wikitable" |+ Generic Signal |- ! Name !! Description !! Comment !! Type |- | LaboratoryCount || Amount of results of selected laboratory type in given offset || || O D |- | LaboratoryAvg || Average laboratory value of selected labo...")
  • 13:32, 8 October 2022 Salkin talk contribs created page Detailfield (Created page with "A detailfield is a field, that can be seperated into more detailed data. This includes the source data of aggregate fields and the raw data of preprocessed values. == Examples == * Exporting detail from '''LaboratoryMax''' will export all laboratory values of given offset. * Exporting detail from '''MinimumMAPOnFirstDay''' will export all MAP values from the first day.")
  • 13:19, 8 October 2022 Salkin talk contribs created page Offsetable (Created page with "An offsetable field can be filtered for a specific period of time, where 0 is the first second of ICU stay. == Offset Types == * After Admission * After (>=) * Before (<) * Between (>= X and < Y) == Offset Value == The offset value can be one of the following: * A number (time in seconds from ICU admission) * A number and a time identifier")
  • 12:59, 8 October 2022 Salkin talk contribs created page File List (Created page with "The SICdb dataset consists from data files, a reference file == Data Files == All data files are gzip compressed RFC4180 comma seperated files. === cases.csv.gz === Contains basic data about admissions to icu. See Case Data for table details and Case Description. === d_references.csv.gz === Contains the dictionary for all encoded fields in the SICdb dataset. See d_references for further information. === data_float_h.csv.gz === Contains hourly aggre...")
  • 07:21, 7 October 2022 Salkin talk contribs created page Contact us (Created page with "Feel free to contact us for any problems! * Contact form * Discord Chat (You do not necessarily need an account, just close the create account window when it pops up)")
(newest | oldest) View (newer 50 | ) (20 | 50 | 100 | 250 | 500)
Retrieved from "https://www.sicdb.com/Documentation/Special:Log"