inputevents.csv.gz CSV_TABLE OK
- Source path
- icu/inputevents.csv.gz
- Format
- csv.gz
- Files
- 1
- Rows
- 20404
- Detected by
- csv_file
- Processor
- 1.0.0
Schema (26 fields)
| # | Field | Type | Nullable | Partition |
|---|---|---|---|---|
| 0 | subject_id | integer | yes | |
| 1 | hadm_id | integer | yes | |
| 2 | stay_id | integer | yes | |
| 3 | caregiver_id | integer | yes | |
| 4 | starttime | datetime | yes | |
| 5 | endtime | datetime | yes | |
| 6 | storetime | datetime | yes | |
| 7 | itemid | integer | yes | |
| 8 | amount | float | yes | |
| 9 | amountuom | string | yes | |
| 10 | rate | float | yes | |
| 11 | rateuom | string | yes | |
| 12 | orderid | integer | yes | |
| 13 | linkorderid | integer | yes | |
| 14 | ordercategoryname | string | yes | |
| 15 | secondaryordercategoryname | string | yes | |
| 16 | ordercomponenttypedescription | string | yes | |
| 17 | ordercategorydescription | string | yes | |
| 18 | patientweight | integer | yes | |
| 19 | totalamount | integer | yes | |
| 20 | totalamountuom | string | yes | |
| 21 | isopenbag | integer | yes | |
| 22 | continueinnextdept | integer | yes | |
| 23 | statusdescription | string | yes | |
| 24 | originalamount | float | yes | |
| 25 | originalrate | float | yes |
Candidate relationships
Evidence-backed candidates, not authoritative foreign keys.
| Kind | Related asset | Confidence | Evidence |
|---|---|---|---|
| shared_clinical_key | microbiologyevents.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | omr.csv.gz | 0.70 | {'all_shared': ['subject_id'], 'shared_keys': ['subject_id']} |
| shared_clinical_key | patients.csv.gz | 0.70 | {'all_shared': ['subject_id'], 'shared_keys': ['subject_id']} |
| shared_clinical_key | poe_detail.csv.gz | 0.70 | {'all_shared': ['subject_id'], 'shared_keys': ['subject_id']} |
| shared_clinical_key | prescriptions.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'starttime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | procedures_icd.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | chartevents.csv.gz | 0.90 | {'all_shared': ['caregiver_id', 'hadm_id', 'itemid', 'stay_id', 'storetime', 'subject_id'], 'shared_keys': ['caregiver_id', 'hadm_id', 'itemid', 'stay_id', 'subject_id']} |
| shared_clinical_key | procedureevents.csv.gz | 0.90 | {'all_shared': ['caregiver_id', 'continueinnextdept', 'endtime', 'hadm_id', 'isopenbag', 'itemid', 'linkorderid', 'ordercategorydescription', 'ordercategoryname', 'orderid', 'originalamount', 'originalrate', 'patientweight', 'starttime', 'statusdescription', 'stay_id', 'storetime', 'subject_id'], 'shared_keys': ['caregiver_id', 'hadm_id', 'itemid', 'stay_id', 'subject_id']} |
| shared_clinical_key | demo_subject_id.csv | 0.70 | {'all_shared': ['subject_id'], 'shared_keys': ['subject_id']} |
| shared_clinical_key | admissions.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | d_labitems.csv.gz | 0.70 | {'all_shared': ['itemid'], 'shared_keys': ['itemid']} |
| shared_clinical_key | diagnoses_icd.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | drgcodes.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | emar.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | emar_detail.csv.gz | 0.70 | {'all_shared': ['subject_id'], 'shared_keys': ['subject_id']} |
| shared_clinical_key | hcpcsevents.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | labevents.csv.gz | 0.90 | {'all_shared': ['hadm_id', 'itemid', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'itemid', 'subject_id']} |
| shared_clinical_key | pharmacy.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'starttime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | poe.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | services.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | transfers.csv.gz | 0.80 | {'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']} |
| shared_clinical_key | caregiver.csv.gz | 0.70 | {'all_shared': ['caregiver_id'], 'shared_keys': ['caregiver_id']} |
| shared_clinical_key | d_items.csv.gz | 0.70 | {'all_shared': ['itemid'], 'shared_keys': ['itemid']} |
| shared_clinical_key | datetimeevents.csv.gz | 0.90 | {'all_shared': ['caregiver_id', 'hadm_id', 'itemid', 'stay_id', 'storetime', 'subject_id'], 'shared_keys': ['caregiver_id', 'hadm_id', 'itemid', 'stay_id', 'subject_id']} |
| shared_clinical_key | icustays.csv.gz | 0.90 | {'all_shared': ['hadm_id', 'stay_id', 'subject_id'], 'shared_keys': ['hadm_id', 'stay_id', 'subject_id']} |
| shared_clinical_key | ingredientevents.csv.gz | 0.90 | {'all_shared': ['amount', 'amountuom', 'caregiver_id', 'endtime', 'hadm_id', 'itemid', 'linkorderid', 'orderid', 'originalamount', 'originalrate', 'rate', 'rateuom', 'starttime', 'statusdescription', 'stay_id', 'storetime', 'subject_id'], 'shared_keys': ['caregiver_id', 'hadm_id', 'itemid', 'stay_id', 'subject_id']} |
| shared_clinical_key | outputevents.csv.gz | 0.90 | {'all_shared': ['caregiver_id', 'hadm_id', 'itemid', 'stay_id', 'storetime', 'subject_id'], 'shared_keys': ['caregiver_id', 'hadm_id', 'itemid', 'stay_id', 'subject_id']} |
Bounded preview
Your identity does not have preview permission for this dataset. Metadata discovery is still available.
Annotations
PIPELINE_EXTRACTED
enrichment_candidate APPROVED
Selected for summary, tags enrichment.