Dataset: Example prescription data

Aggregated by: day

Report created on: 2023-07-18 14:38:22.631862 ; daiquiri version 1.1.1 ; R version 4.3.1 (2023-06-16 ucrt)

Field name
Field type
Total values
Missing values
Min value
Max value
Validation warnings
Column position
PrescriptionID
uniqueidentifier
8993
0 (0%)
10000
9999
0
1
PrescriptionDate
timepoint
8993
0 (0%)
2021-01-01
2021-12-31 23:00:00
2
2
AdmissionDate
datetime
4989
4004 (45%)
2020-07-01
2021-12-31
1
3
Drug
freetext
8993
0 (0%)
Abacavir + lamiVUDine
Voriconazole
0
4
Dose
numeric
8984
9 (0.1%)
0.2
7e+05
5
5
DoseUnit
categorical
8964
29 (0.3%)
g
unit(s)
0
6
Location
categorical
8993
0 (0%)
SITE1
SITE4
0
8
Field name
Field type
Column position
PatientID
ignore
7
Field name
Details
Instances
PrescriptionDate
Missing or invalid value in Timepoint field
2
AdmissionDate
expected valid date, but got '2021-06-31'
1
Dose
expected no trailing characters, but got '1.5g'
1
Dose
expected no trailing characters, but got '4.5 grams'
1
Dose
expected a double, but got 'See Instructions'
2
Dose
expected no trailing characters, but got '80/400 mg'
1
Columns in source
8
Columns imported
7
Column used for timepoint
PrescriptionDate
Min timepoint value
2021-01-01
Max timepoint value
2021-12-31 23:00:00
Rows in source
8996
Duplicate rows
1
Rows missing timepoint values
2
Rows imported
8993
Strings interpreted as missing values
"","NA","NULL"
AdmissionDate: "1800-01-01"
Total validation warnings
8

Column used for timepoint
PrescriptionDate
Min timepoint value
2021-01-01
Max timepoint value
2021-12-31
Timepoint aggregation unit
day
Total number of timepoints
365
Number of empty timepoints
32
Number of data fields
9