microbiologyevents.csv.gz

microbiologyevents.csv.gz CSV_TABLE OK

Source path: hosp/microbiologyevents.csv.gz
Format: csv.gz
Files: 1
Rows: 2899
Detected by: csv_file
Processor: 1.0.0

Schema (25 fields)

#	Field	Type	Nullable
0	microevent_id	integer	yes
1	subject_id	integer	yes
2	hadm_id	integer	yes
3	micro_specimen_id	integer	yes
4	order_provider_id	string	yes
5	chartdate	datetime	yes
6	charttime	datetime	yes
7	spec_itemid	integer	yes
8	spec_type_desc	string	yes
9	test_seq	integer	yes
10	storedate	datetime	yes
11	storetime	datetime	yes
12	test_itemid	integer	yes
13	test_name	string	yes
14	org_itemid	integer	yes
15	org_name	string	yes
16	isolate_num	integer	yes
17	quantity	string	yes
18	ab_itemid	integer	yes
19	ab_name	string	yes
20	dilution_text	string	yes
21	dilution_comparison	string	yes
22	dilution_value	float	yes
23	interpretation	string	yes
24	comments	string	yes

Field

Type

Nullable

Partition

microevent_id

integer

yes

subject_id

integer

yes

hadm_id

integer

yes

micro_specimen_id

integer

yes

order_provider_id

string

yes

chartdate

datetime

yes

charttime

datetime

yes

spec_itemid

integer

yes

spec_type_desc

string

yes

test_seq

integer

yes

storedate

datetime

yes

storetime

datetime

yes

test_itemid

integer

yes

test_name

string

yes

org_itemid

integer

yes

org_name

string

yes

isolate_num

integer

yes

quantity

string

yes

ab_itemid

integer

yes

ab_name

string

yes

dilution_text

string

yes

dilution_comparison

string

yes

dilution_value

float

yes

interpretation

string

yes

comments

string

yes

Candidate relationships

Evidence-backed candidates, not authoritative foreign keys.

Kind	Related asset	Confidence	Evidence
shared_clinical_key	omr.csv.gz	0.70	{'all_shared': ['chartdate', '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', 'order_provider_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	procedures_icd.csv.gz	0.80	{'all_shared': ['chartdate', 'hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	chartevents.csv.gz	0.80	{'all_shared': ['charttime', 'hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	procedureevents.csv.gz	0.80	{'all_shared': ['hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_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	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': ['charttime', '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': ['chartdate', 'hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	labevents.csv.gz	0.80	{'all_shared': ['charttime', 'comments', 'hadm_id', 'order_provider_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	pharmacy.csv.gz	0.80	{'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	poe.csv.gz	0.80	{'all_shared': ['hadm_id', 'order_provider_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	datetimeevents.csv.gz	0.80	{'all_shared': ['charttime', 'hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	icustays.csv.gz	0.80	{'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	ingredientevents.csv.gz	0.80	{'all_shared': ['hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	inputevents.csv.gz	0.80	{'all_shared': ['hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	outputevents.csv.gz	0.80	{'all_shared': ['charttime', 'hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

Kind

Related asset

Confidence

Evidence

shared_clinical_key

omr.csv.gz

0.70

{'all_shared': ['chartdate', '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', 'order_provider_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

procedures_icd.csv.gz

0.80

{'all_shared': ['chartdate', 'hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

chartevents.csv.gz

0.80

{'all_shared': ['charttime', 'hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

procedureevents.csv.gz

0.80

{'all_shared': ['hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_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

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': ['charttime', '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': ['chartdate', 'hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

labevents.csv.gz

0.80

{'all_shared': ['charttime', 'comments', 'hadm_id', 'order_provider_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

pharmacy.csv.gz

0.80

{'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

poe.csv.gz

0.80

{'all_shared': ['hadm_id', 'order_provider_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

datetimeevents.csv.gz

0.80

{'all_shared': ['charttime', 'hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

icustays.csv.gz

0.80

{'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

ingredientevents.csv.gz

0.80

{'all_shared': ['hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

inputevents.csv.gz

0.80

{'all_shared': ['hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

outputevents.csv.gz

0.80

{'all_shared': ['charttime', 'hadm_id', 'storetime', 'subject_id'], 'shared_keys': ['hadm_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.