pharmacy.csv.gz · Protege

pharmacy.csv.gz CSV_TABLE OK

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

Schema (27 fields)

#	Field	Type	Nullable
0	subject_id	integer	yes
1	hadm_id	integer	yes
2	pharmacy_id	integer	yes
3	poe_id	string	yes
4	starttime	datetime	yes
5	stoptime	datetime	yes
6	medication	string	yes
7	proc_type	string	yes
8	status	string	yes
9	entertime	datetime	yes
10	verifiedtime	datetime	yes
11	route	string	yes
12	frequency	string	yes
13	disp_sched	integer	yes
14	infusion_type	string	yes
15	sliding_scale	string	yes
16	lockout_interval	string	yes
17	basal_rate	string	yes
18	one_hr_max	string	yes
19	doses_per_24_hrs	integer	yes
20	duration	integer	yes
21	duration_interval	string	yes
22	expiration_value	integer	yes
23	expiration_unit	string	yes
24	expirationdate	string	yes
25	dispensation	string	yes
26	fill_quantity	string	yes

Field

Type

Nullable

Partition

subject_id

integer

yes

hadm_id

integer

yes

pharmacy_id

integer

yes

poe_id

string

yes

starttime

datetime

yes

stoptime

datetime

yes

medication

string

yes

proc_type

string

yes

status

string

yes

entertime

datetime

yes

verifiedtime

datetime

yes

route

string

yes

frequency

string

yes

disp_sched

integer

yes

infusion_type

string

yes

sliding_scale

string

yes

lockout_interval

string

yes

basal_rate

string

yes

one_hr_max

string

yes

doses_per_24_hrs

integer

yes

duration

integer

yes

duration_interval

string

yes

expiration_value

integer

yes

expiration_unit

string

yes

expirationdate

string

yes

dispensation

string

yes

fill_quantity

string

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', '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': ['poe_id', 'subject_id'], 'shared_keys': ['subject_id']}
shared_clinical_key	prescriptions.csv.gz	0.80	{'all_shared': ['doses_per_24_hrs', 'hadm_id', 'pharmacy_id', 'poe_id', 'route', 'starttime', 'stoptime', '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.80	{'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	procedureevents.csv.gz	0.80	{'all_shared': ['hadm_id', 'starttime', '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': ['hadm_id', 'medication', 'pharmacy_id', 'poe_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	emar_detail.csv.gz	0.70	{'all_shared': ['pharmacy_id', 'route', '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.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', 'poe_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': ['hadm_id', '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', 'starttime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	inputevents.csv.gz	0.80	{'all_shared': ['hadm_id', 'starttime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}
shared_clinical_key	outputevents.csv.gz	0.80	{'all_shared': ['hadm_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

Kind

Related asset

Confidence

Evidence

shared_clinical_key

microbiologyevents.csv.gz

0.80

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

shared_clinical_key

prescriptions.csv.gz

0.80

{'all_shared': ['doses_per_24_hrs', 'hadm_id', 'pharmacy_id', 'poe_id', 'route', 'starttime', 'stoptime', '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.80

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

shared_clinical_key

procedureevents.csv.gz

0.80

{'all_shared': ['hadm_id', 'starttime', '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': ['hadm_id', 'medication', 'pharmacy_id', 'poe_id', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

emar_detail.csv.gz

0.70

{'all_shared': ['pharmacy_id', 'route', '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.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', 'poe_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': ['hadm_id', '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', 'starttime', 'subject_id'], 'shared_keys': ['hadm_id', 'subject_id']}

shared_clinical_key

inputevents.csv.gz

0.80

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

shared_clinical_key

outputevents.csv.gz

0.80

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