Difference between revisions of "File List"

From SICDB Doc
Jump to navigation Jump to search
(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...")
 
 
(15 intermediate revisions by the same user not shown)
Line 1: Line 1:
The SICdb dataset consists from data files, a reference file
The SICdb dataset consists from 7 files. Additional data is found on our [https://github.com/nrodemund/sicdb github repository], refer to [[Get Started]] for usage details.


== Data Files ==
== Data Files ==
Line 5: Line 5:
All data files are gzip compressed RFC4180 comma seperated files.
All data files are gzip compressed RFC4180 comma seperated files.


=== cases.csv.gz ===
{| class="wikitable"
Contains basic data about admissions to icu.  
|+ Files
See [[Case Data]] for table details and [[Case Description]].
|-
! Name !! Short description
|-
| [[Case Data|cases.csv.gz]]  || Contains basic data about admissions to icu. See [[Case Data]] for table details and [[Case Description]].  
|-
| [[d_references|d_references.csv.gz]] ||  Contains the dictionary for all encoded fields in the SICdb dataset.  ||
|-
| [[data_float_h|data_float_h.csv.gz]] || Contains hourly aggregated float data like monitor [[Signal Data|signals]] or respirator settings. Additionally raw minute data is included.See [[data_float_h]] and [[Signal Data]] for further information. ||
|-
|  [[data_ref|data_ref.csv.gz]] || Contains encoded (nominal) data related to an admission. ||
|-
| [[Laboratory Data|laboratory.csv.gz]] || Contains laboratory results. || 
|-
| [[Medication Data|medication.csv.gz]] || Contains data about medication given during ICU stay. || 
|-
| [[Data range|data_range.csv.gz]] || Contains ranged data (from/to) ||
|-
| [[Unitlog|unitlog.csv.gz]] || Information about the patient's stay  || 
|}


== Configuration Files ==


=== d_references.csv.gz ===
This data is found on our [https://github.com/nrodemund/sicdb github repository].


Contains the dictionary for all encoded fields in the SICdb dataset.  
=== docker-compose.yml ===


See [[d_references]] for further information.
This file is needed to install our database software. See [[Software Description]] for further information, and [[Get Started]] for installation instructions.


=== data_float_h.csv.gz ===
=== DatasetConfiguration.conf ===


Contains hourly aggregated float data like monitor signals or repirator settings. Additionally raw minute data is included.
Our database software needs this metadata for building up the database. It contains field data types and SQL table structure, that cannot be saved in .csv files.


See [[data_float_h]] for further information.
== RooData Folder and contents ==


=== data_ref.csv.gz ===
This data is used by our software and contains field and table configurations.
 
Contains encoded (nominal) data related to a case.
 
See [[data_ref]] for further information.
 
=== laboratory.csv.gz ===
 
Contains laboratory results.
 
See [[Laboratory]] for further information.
 
=== medication.csv.gz ===
 
Contains data about medication given during ICU stay.
 
See [[Medication]] for further information.
 
=== treatment.csv.gz ===
 
=== unitlog.csv.gz ===
 
Contains information about changes in patients department.

Latest revision as of 10:31, 9 November 2022

The SICdb dataset consists from 7 files. Additional data is found on our github repository, refer to Get Started for usage details.

Data Files

All data files are gzip compressed RFC4180 comma seperated files.

Files
Name Short description
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.
data_float_h.csv.gz Contains hourly aggregated float data like monitor signals or respirator settings. Additionally raw minute data is included.See data_float_h and Signal Data for further information.
data_ref.csv.gz Contains encoded (nominal) data related to an admission.
laboratory.csv.gz Contains laboratory results.
medication.csv.gz Contains data about medication given during ICU stay.
data_range.csv.gz Contains ranged data (from/to)
unitlog.csv.gz Information about the patient's stay

Configuration Files

This data is found on our github repository.

docker-compose.yml

This file is needed to install our database software. See Software Description for further information, and Get Started for installation instructions.

DatasetConfiguration.conf

Our database software needs this metadata for building up the database. It contains field data types and SQL table structure, that cannot be saved in .csv files.

RooData Folder and contents

This data is used by our software and contains field and table configurations.

Retrieved from "https://www.sicdb.com/wiki/index.php?title=File_List&oldid=338"