All public logs

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

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)")
07:14, 7 October 2022 Salkin talk contribs created page Navigate to data folder (Created page with "To navigate in commandline (windows) you need the following commands: '''cd''' and the change drive command. If you have your data in D:/Data so the following: - Execute "D:" (will change to correct drive) - Execute "cd Data" (will change to correct folder)")
07:10, 7 October 2022 Salkin talk contribs created page Open commandline (Created page with "To open the commandline on a windows machine click onto the Windows symbol (or press Windows key) and enter "cmd". You may need to start as administrator (right click, Run as Administrator).")
06:45, 7 October 2022 Salkin talk contribs moved page QuickStart to Get Started
06:45, 7 October 2022 Salkin talk contribs deleted page Get Started (content was: "== Simple Quick Start == There is an uncountable amount of ways to use medical datasets. Everyone, who has worked with raw .csv data knows, that it can take weeks to analyze, convert, filter and export data to use in statistical software. The SICDb Team therefore provides a fully configured environment, including a set of examples to get started as quick as possible. == System...", and the only contributor was "Salkin" (talk))
06:41, 7 October 2022 Salkin talk contribs created page MediaWiki:Sidebar (Created page with " * navigation ** mainpage|mainpage-description ** recentchanges-url|recentchanges ** helppage|help-mediawiki * SEARCH * TOOLBOX * LANGUAGES")
15:36, 18 September 2022 Salkin talk contribs created page Data Description (Created page with "The SICdb dataset consists of X tables. The main tables are cases, d_references,")
22:11, 17 September 2022 Salkin talk contribs created page Template:Beta Version (Created page with "SICdb dataset, the documentation and SICdb Environment are, as of 09/22, in active development. We try to improve our project as fast as we can! We'd love to find some motivated researchers attain as much as possible from our dataset. Contact us on [https://discord.gg/pUTMPN9X Discord]")
19:19, 17 September 2022 Salkin talk contribs created page SICdb Environment (Created page with "== 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 database may cause problems. As we faced the issue that even mysqldump/msyqlimport on a 40gb machin...")
16:09, 17 September 2022 Salkin talk contribs created page QuickStart (Created page with "== Introduction == The SICdb dataset is provided in compressed .csv files, the minute values are even more consolidated. Refer to the Main Page for detailed description of files. The SICdb dataset contains billions of entries, therefore building up a database may present a challenge. Therefore a 'as simple as possible' solution is provided. Refer to the Quick Start chapter if you know how the commandline and docker is working, skip to the Detailed Instructions fo...")
10:43, 11 September 2022 Salkin talk contribs created page Table: Cases (Redirected page to Case Data) Tag: New redirect
10:37, 11 September 2022 Salkin talk contribs created page Signal Data (Created page with "== Data Description == Various types of signal data has been included in the SICDb dataset. Signal data is saved in == Aggregation Description == Most signal data is averaged. The field data_float_h.cnt describes the amount of values aggregated. It is to be expected that the first signal values have less than 60 data points, as it is quite unlikely (1:60) that signal starts on minute 0. Raw values are saved in field data_float_h.rawdata, being a list of bytes. (IEEE...")
13:08, 10 September 2022 Salkin talk contribs created page Generated Field (Created page with "In development of SICDb several fields have been computed using machine learning methods, rules and manual edits. In many cases this had been necessary due to anonymization. If not noted otherwise, it is expected that all published generated fields have more than 95% validity. As for the whole dataset no warranty for correctnes can be provided.")
07:36, 8 September 2022 Salkin talk contribs created page Reference Table (Created page with "==Table Description== 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. To reduce the amount of tables there is no table describing references published as there is no significant gain of information expected. This may change in later versions of dataset. To enumerate a reference use table d_references.ReferenceName, which is a...")
14:32, 19 February 2022 Salkin talk contribs created page MediaWiki:Common.js (Created page with "Any JavaScript here will be loaded for all users on every page load.: var _paq = window._paq = window._paq || []; tracker methods like "setCustomDimension" should be called before "trackPageView": _paq.push(['trackPageView']); _paq.push(['enableLinkTracking']); (function() { var u="//rodemund.net/sicdb/matomo/"; _paq.push(['setTrackerUrl', u+'matomo.php']); _paq.push(['setSiteId', '2']); var d=document, g=d.createElement('script'), s...")
10:44, 16 February 2022 Salkin talk contribs created page Version (Created page with "== General Information == The SICDB dataset uses a versioning system. It contains 3 numbers major, minor and patch. A suffix may be added for changes, the do not necessarily needs to be applied. A major version change generally occurs when the database was incrementally updated and more cases are included. A minor version change occurs when data was altered that will likely change most study data. (i.e. removal of a significant amount of invalid cases) A minor update...")
10:33, 16 February 2022 Salkin talk contribs created page Case Description (Created page with "== Case Selection == With Version 1.0.0 all admissions to participating intensiv care units are included, as long as following conditions do not apply: * Less the 10 Minutes of Stay * Missing mandatory admission data * No monitor signals * No medication data * hospital number mismatch == Unit Description == The participating metavision enabled wards are CWIN, INBD, INIC, and INIC. INCV and CWCV are used for cases associated with SARS-COV-2, this includes...")
14:26, 6 February 2022 Salkin talk contribs created page Extension Troubleshooting and Tipps (Created page with "== How to include nuget packages to Extension? == You may include nuget packages to your extension. The easiest way is adding following to your .csproj: ::<PropertyGroup><CopyLocalLockFileAssemblies>true</CopyLocalLockFileAssemblies></PropertyGroup>")
13:29, 1 February 2022 Salkin talk contribs created page Case Data (Created page with "== Data Description == The cases table contains unique intensive care admissions and case related data. The case starts with startin a new Metavision case, which may be created for the anaesthesia preceding the intensive care stay. == Predefined Fields (RoDataServer) == == Known Limitations == The cases data is generally considered as being widely valid. Nevertheless there are some limitations to be stated. === Time of stay === In most cases at a readmission in sam...")
11:13, 1 February 2022 Salkin talk contribs created page Extend RoDataServer (Created page with "Extending RoDataServer needs significant programming skills. RoDataServer can be extended by creating a [https://en.wikipedia.org/wiki/.NET .NET] library. == Modules == RoDataServer provides several possibilites to extend its functionalities. To ensure high extendability most default modules are loaded as extensions and are open source. Most modules can be loaded and configured in default RoDataServer User Interface. === Export Module === Export modules can use full...")
10:58, 1 February 2022 Salkin talk contribs created page RoDataServer (Created page with "RoDataServer is a software to browse and export ICU Data developed for the SICDB project. It provides a potent query manager to select, preview and export queries. Hundreds of predefined and parameterizable subquery fields are added for convenience and to serve as examples. Several quick statistic and charts modules are included to predict study outcome. RoDataServer is highly extensible, learn here how to Extend RoDataServer.")
10:49, 1 February 2022 Salkin talk contribs created page Get Started (Created page with "== Environment Description == The Database environmen contains several modules * MySQL 8.x Server * RoDataServer * (optional) Apache, PHP, phpMyAdmin == Install == As the database is of significant size and tables are indexed and optimized it may be difficult to restore database from a dumpfile.")
10:18, 1 February 2022 Salkin talk contribs created page Medication Data (Created page with "== Data Description == The medication table contains data == Predefined Fields (RoDataServer) == == Known Limitations == The medication data is generally considered as being widely valid. Nevertheless there are some limitations to be stated: === Offsets and Times === The offset is the documented time of drug application. As the observed intensive care unity do not use perfusor telemetry all values are entered manually. Following inaccuracies of of time give may be...")
10:09, 1 February 2022 Salkin talk contribs created page Main Page (Created page with "== Welcome to SICDB Documentation == The SICDB Dataset contains intensive care data form over 25.000 admissions from 2013-2021, admitted to University Hospital Salzburg. === The Dataset === The Dataset contains amongst others following data: * Case Data (Time of stay, ICD10, ...) * Monitor Signal Data * Respiratory Care Data * Laboratory Data * Medication Data * Event data All nominal fields are referenced in table d_references. === The Database ==...")
09:19, 1 February 2022 MediaWiki default talk contribs created page Hauptseite

All public logs

Navigation menu

Search