emar_detail.csv.gz

emar_detail.csv.gz CSV_TABLE OK

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

Schema (33 fields)

#	Field	Type	Nullable
0	subject_id	integer	yes
1	emar_id	string	yes
2	emar_seq	integer	yes
3	parent_field_ordinal	float	yes
4	administration_type	string	yes
5	pharmacy_id	integer	yes
6	barcode_type	string	yes
7	reason_for_no_barcode	string	yes
8	complete_dose_not_given	string	yes
9	dose_due	string	yes
10	dose_due_unit	string	yes
11	dose_given	string	yes
12	dose_given_unit	string	yes
13	will_remainder_of_dose_be_given	string	yes
14	product_amount_given	integer	yes
15	product_unit	string	yes
16	product_code	string	yes
17	product_description	string	yes
18	product_description_other	string	yes
19	prior_infusion_rate	float	yes
20	infusion_rate	float	yes
21	infusion_rate_adjustment	string	yes
22	infusion_rate_adjustment_amount	string	yes
23	infusion_rate_unit	string	yes
24	route	string	yes
25	infusion_complete	string	yes
26	completion_interval	string	yes
27	new_iv_bag_hung	string	yes
28	continued_infusion_in_other_location	string	yes
29	restart_interval	string	yes
30	side	string	yes
31	site	string	yes
32	non_formulary_visual_verification	string	yes

Field

Type

Nullable

Partition

subject_id

integer

yes

emar_id

string

yes

emar_seq

integer

yes

parent_field_ordinal

float

yes

administration_type

string

yes

pharmacy_id

integer

yes

barcode_type

string

yes

reason_for_no_barcode

string

yes

complete_dose_not_given

string

yes

dose_due

string

yes

dose_due_unit

string

yes

dose_given

string

yes

dose_given_unit

string

yes

will_remainder_of_dose_be_given

string

yes

product_amount_given

integer

yes

product_unit

string

yes

product_code

string

yes

product_description

string

yes

product_description_other

string

yes

prior_infusion_rate

float

yes

infusion_rate

float

yes

infusion_rate_adjustment

string

yes

infusion_rate_adjustment_amount

string

yes

infusion_rate_unit

string

yes

route

string

yes

infusion_complete

string

yes

completion_interval

string

yes

new_iv_bag_hung

string

yes

continued_infusion_in_other_location

string

yes

restart_interval

string

yes

side

string

yes

site

string

yes

non_formulary_visual_verification

string

yes

Candidate relationships

Evidence-backed candidates, not authoritative foreign keys.

Kind	Related asset	Confidence	Evidence
shared_clinical_key	microbiologyevents.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['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.70	{'all_shared': ['pharmacy_id', 'route', 'subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	procedures_icd.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	chartevents.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	procedureevents.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['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.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	diagnoses_icd.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	drgcodes.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	emar.csv.gz	0.70	{'all_shared': ['emar_id', 'emar_seq', 'pharmacy_id', 'subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	hcpcsevents.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	labevents.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	pharmacy.csv.gz	0.70	{'all_shared': ['pharmacy_id', 'route', 'subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	poe.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	services.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	transfers.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	datetimeevents.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	icustays.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	ingredientevents.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	inputevents.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	outputevents.csv.gz	0.70	{'all_shared': ['subject_id'], 'shared_keys': ['subject_id']}

Kind

Related asset

Confidence

Evidence

shared_clinical_key

microbiologyevents.csv.gz

0.70

{'all_shared': ['subject_id'], 'shared_keys': ['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.70

{'all_shared': ['pharmacy_id', 'route', 'subject_id'], 'shared_keys': ['subject_id']}

shared_clinical_key

procedures_icd.csv.gz

0.70

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

shared_clinical_key

chartevents.csv.gz

0.70

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

shared_clinical_key

procedureevents.csv.gz

0.70

{'all_shared': ['subject_id'], 'shared_keys': ['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.70

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

shared_clinical_key

diagnoses_icd.csv.gz

0.70

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

shared_clinical_key

drgcodes.csv.gz

0.70

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

shared_clinical_key

emar.csv.gz

0.70

{'all_shared': ['emar_id', 'emar_seq', 'pharmacy_id', 'subject_id'], 'shared_keys': ['subject_id']}

shared_clinical_key

hcpcsevents.csv.gz

0.70

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

shared_clinical_key

labevents.csv.gz

0.70

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

shared_clinical_key

pharmacy.csv.gz

0.70

{'all_shared': ['pharmacy_id', 'route', 'subject_id'], 'shared_keys': ['subject_id']}

shared_clinical_key

poe.csv.gz

0.70

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

shared_clinical_key

services.csv.gz

0.70

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

shared_clinical_key

transfers.csv.gz

0.70

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

shared_clinical_key

datetimeevents.csv.gz

0.70

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

shared_clinical_key

icustays.csv.gz

0.70

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

shared_clinical_key

ingredientevents.csv.gz

0.70

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

shared_clinical_key

inputevents.csv.gz

0.70

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

shared_clinical_key

outputevents.csv.gz

0.70

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