PvERS: the Pharmacovigilance Electronic Reporting System: Reports

REPORTS
SUSPECTED ADVERSE DRUG REACTIONS
SADR
ADVERSE EVENT FOLLOWING IMMUNIZATION
AEFI
POOR QUALITY HEALTH PRODUCTS AND TECHNOLOGIES
PQHPTs
Medical Devices
Medical devices
Medication Errors
Medications
Blood Transfusion
Transfusion
E2B
E2B

Report Dates-to- clear!	Gender	County
		Clear

Geographical Distribution

County	Medications Errors
Baringo	2
Bungoma	14
Isiolo	3
Kericho	1
Kisii	1
Machakos	1
Mombasa	1
Murang'a	1
Nairobi County	8
Nandi	1
Narok	1
Nyeri	1

Gender Distribution

Sex	Medications Errors
Female	13
Male	22

Age Distribution

Age group	Medications Errors
adult	20
child	9
infant	2
neonate	2
unknown	2

Medications Errors Per Year

Age group	Medications Errors
2022	1
2023	11
2024	16
2025	7

Medications Errors per Month

Month	Medications Errors
Jan 2025	7
Apr 2024	6
Apr 2023	2
May 2023	4
Sep 2023	1
Oct 2023	1
Oct 2024	1
Nov 2024	9
Nov 2022	1
Dec 2023	3

Product Intended vs Error

Product	Intended	Error
-	4	3
Abacavir	1	0
ABC	1	1
ABC+3TC+DTG	4	0
ABC+3TG	1	0
ABC,3TC,DTG	1	0
Abc/3tc/dtg	1	0
Acetominophen	1	1
Acriptega	2	0
Acritega	1	0
Alo	1	0
Artesunate	1	0
B1	1	0
Brand I	3	0
Brandx	1	1
Chlor	1	0
Diamox	1	0
Diethylcarbamazine	1	0
Dinac	1	0
Dolte	1	0
DTG	2	0
Dylantin, Tena Ltd	1	0
Dyzantil	2	0
Epival	1	0
Epivir	1	1
Gg	1	0
Meme	1	0
mionate	15	0
Mylan	1	1
N/A	7	0
Na	5	2
None	1	3
T	1	0
TDF	2	0
TDF+3TC+DTG	1	0
Tenofovit	1	0
TLD	4	2
Unknown	1	0
Ziagen	1	1
1	0	1
B2	0	1
Brand II	0	3
Chlorzine	0	1
D	0	1
DEC	0	1
Epival	0	2
Epival, Landi Ltd	0	1
gold	0	1
Lanoxin	0	1
Mionate	0	4
N/a	0	4
Non	0	1
NS	0	1
Oo	0	1
TDf	0	3
TDF+3TC	0	1
Tdf+3tc+dtg	0	2
TDF+3TC+DTGl	0	1
TDF,3TC,DTG	0	1
TENOFOVIR	0	1
Vera	0	1
Vvb	0	1

Generic Intended vs Error

Product	Intended	Error
-	3	3
-abc3tcdtg	1	0
3TC	3	2
Abacavir	18	0
Abacavir+lamivudine+dolutegravir	1	0
Abacavir, lavivudine,deglutegravir	1	0
Abacavir/Lamivudine/Dolutegravir	3	0
Abacavir/lamovodine/dolutegravir	1	0
Abacavirxh,lamividine,delougatravir	1	0
ABC	12	5
ABC (Abacavir)	1	0
ABC ,3TC DTG	1	0
ABC /3TC/DTG	2	0
ABC 3TC DTG	1	0
ABC+3T	1	0
ABC+3TC+ DTG	1	0
Abc+3tc+dtg	16	0
ABC+3TC+DTG+	1	0
Abc,3tc,dtg	3	0
ABC/3TC	3	0
ABC/3TC , DTG	1	0
ABC/3TC and DTG	1	0
ABC/3TC, DTG	1	0
ABC/3TC/DTG	42	0
ABC/3TC/TDG	2	0
ABC/3TC120/60mg DTG 50mg	1	0
ABC/3TCplus DTG	1	0
ABC/3TG/DTG	1	0
Abc3tcdtg	1	0
ABC_3TC/Dtg	1	0
ABZ 1tab	1	0
Acetazolamide	1	0
ART	1	1
artesunate	13	0
artesunate 60mg vial	1	0
Atenolol	1	0
Azithromycin	1	0
Chlorpheniramine	1	0
correct low albumin levels	1	0
DEC	3	0
Deltagravir	1	0
Diclofenac	1	0
Dolutegraviramivufine/tenofovir	1	0
Dtg	11	0
G	1	0
G1	1	0
Gen I	1	0
Generic name I	2	0
Genx	1	0
H	1	0
Iv artesunate	1	0
measles rubella vaccine	1	1
metformin	1	0
Mionate	1	0
N/A	2	5
Paracetamol	1	0
Sodium Valproate	3	3
Sodium Vaproate	1	0
TDF	4	14
TDF+3TC	1	0
TDF+3TC+ABC	2	0
TDF+3TC+DTC+DTG	1	0
TDF+3TC+DTG	2	19
Tdf+3tc+dtg+	1	0
Tdf,3tc dtg	1	0
Tdf,3tc,dtg	1	0
TDF/3TC/DTG	10	39
Tenofovir	4	13
Tenofovir/Lamivudine/Dolutegravir	1	0
Tenovir,lamuvidine dolutegravir	1	0
TLD	4	9
We	1	0
1	0	10
2	0	2
3	0	1
3TC+TDF+DTG	0	1
400	0	1
400mg	0	1
5mg	0	1
ABC+3tc+dtg	0	1
ABC,3tc,dtg	0	1
ABC/3TC,DTG	0	1
abc/3tc/dtg	0	1
Adult dose given	0	1
Art overdose esunate	0	1
Artesunate	0	5
artesunate inj	0	1
Atenolol	0	1
auronafin	0	1
Azithromycin	0	1
Chlorpromazine	0	1
DEC	0	1
DF/3TC/DTG	0	1
Digoxin	0	1
DTG	0	5
DTG,3TC	0	1
DTG/3TC/DTG	0	1
DTG/TDF/3TC	0	2
Epival	0	1
Error	0	1
frequency error. 0h and 2h	0	1
G2	0	1
Gen II	0	1
Generic name II	0	2
Gennamex	0	1
glibenclamide	0	1
high protein diet	0	1
IV artesunate	0	1
Medical	0	1
Mionate	0	1
Na	0	1
Non	0	1
None	0	4
Oral	0	1
Overdose	0	1
R	0	2
Rdf	0	1
T	0	1
TDF (Tenofovir)	0	1
TDF 3TC DTG	0	2
Tdf+. 3tc+drg	0	1
TDF+3tc	0	1
TDF+3TC+DGG	0	1
Tdf,3tc,Dtg	0	1
Tdf.3tc.dtg	0	1
TDF/33TC/DTG	0	1
Tdf/3tc'dtg	0	1
TDF/3TC/DG	0	1
Tdf3tcdtg	0	1
Tenefovir	0	1
tenofivir	0	1
Tenofoviar	0	1
Tenofovif/lamovodine/dolutegravir	0	1
Tenofovir,dolutegravir,lamuvidine	0	1
Tenofovir/Dulotegravir/Lamivudine	0	1
Tenofovir/lamividine/Dolutegravir	0	1
Tenofovir/lamivudine/dolutegravir	0	1
TenofovirF	0	1
Tenovir	0	1
Tenovovir,lamivudine,deglutegravir	0	1
TFF/3tc/dtg	0	1
TLG	0	1
Vvv	0	1
Wrong drug	0	1
Wrong prescription	0	1
Yes	0	1

History
+
Request History
4 previous requests available
====
Session
+
Session
- 0(null)
====
Request
+
Request

Cake Params
- plugin(null)
- controllerreports
- actionmedications_summary
- named(empty)
- pass(empty)
- isAjax(false)
Post data

No post data.

Query string

No querystring data.

Cookie

To view Cookies, add CookieComponent to Controller

Current Route
- keys(array)
  0controller
  1action
- options(array)
  defaultRoute(true)
- defaults(array)
  plugin(null)
- template/:controller/:action/*
====

Sql Log

+

Sql Logs

default

Total Time: 20 ms
Total Queries: 19 queries

Query	Affected	Num. rows	Took (ms)	Actions
SELECT `County`.`county_name`, COUNT() as cnt, `County`.`id` FROM `pvers`.`medications` AS `Medication` LEFT JOIN `pvers`.`counties` AS `County` ON (`Medication`.`county_id` = `County`.`id`) WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 AND `Medication`.`deleted` = '' AND `Medication`.`archived` = '' AND `Medication`.`reach_patient` = 'Yes' GROUP BY `County`.`county_name`, `County`.`id` HAVING COUNT() > 0	12	12	2	maybe slow
SELECT `County`.`id`, `County`.`county_name` FROM `pvers`.`counties` AS `County` WHERE 1 = 1 ORDER BY `County`.`county_name` ASC	47	47	0
SELECT `Medication`.`gender`, COUNT() as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 AND `Medication`.`deleted` = '' AND `Medication`.`archived` = '' AND `Medication`.`reach_patient` = 'Yes' GROUP BY gender HAVING COUNT() > 0	2	2	1	maybe slow
SELECT ((case when trim(age_years) in ('neonate', 'infant', 'child', 'adolescent', 'adult', 'elderly') then age_years when year(now()) - right(date_of_birth, 4) between 0 and 1 then 'infant' when year(now()) - right(date_of_birth, 4) between 1 and 10 then 'child' when year(now()) - right(date_of_birth, 4) between 18 and 65 then 'adult' when year(now()) - right(date_of_birth, 4) between 10 and 18 then 'adolescent' when year(now()) - right(date_of_birth, 4) between 65 and 155 then 'elderly' else 'unknown' end)) as ager, COUNT() as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 AND `Medication`.`deleted` = '' AND `Medication`.`archived` = '' AND `Medication`.`reach_patient` = 'Yes' GROUP BY ((case when trim(age_years) in ('neonate', 'infant', 'child', 'adolescent', 'adult', 'elderly') then age_years when year(now()) - right(date_of_birth, 4) between 0 and 1 then 'infant' when year(now()) - right(date_of_birth, 4) between 1 and 10 then 'child' when year(now()) - right(date_of_birth, 4) between 18 and 65 then 'adult' when year(now()) - right(date_of_birth, 4) between 10 and 18 then 'adolescent' when year(now()) - right(date_of_birth, 4) between 65 and 155 then 'elderly' else 'unknown' end)) HAVING COUNT() > 0	5	5	1	maybe slow
SELECT year(ifnull(created, created)) as year, COUNT() as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 AND `Medication`.`deleted` = '' AND `Medication`.`archived` = '' AND `Medication`.`reach_patient` = 'Yes' GROUP BY year(ifnull(created, created)) HAVING COUNT() > 0 ORDER BY `year` ASC	4	4	1	maybe slow
SELECT DATE_FORMAT(created, "%b %Y") as month, month(ifnull(created, created)) as salit, COUNT() as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 AND `Medication`.`deleted` = '' AND `Medication`.`archived` = '' AND `Medication`.`reach_patient` = 'Yes' GROUP BY DATE_FORMAT(created, "%b %Y"), salit HAVING COUNT() > 0 ORDER BY `salit` ASC	10	10	1	maybe slow
SELECT `Medication`.`name_of_institution`, COUNT() as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 AND `Medication`.`deleted` = '' AND `Medication`.`archived` = '' AND `Medication`.`reach_patient` = 'Yes' GROUP BY name_of_institution HAVING COUNT() > 0 ORDER BY COUNT(*) DESC	23	23	1
SELECT `Medication`.`process_occur`, COUNT() as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 AND `Medication`.`deleted` = '' AND `Medication`.`archived` = '' AND `Medication`.`reach_patient` = 'Yes' GROUP BY process_occur HAVING COUNT() > 0 ORDER BY COUNT(*) DESC	4	4	1	maybe slow
SELECT ((case when outcome in ('Potential error, circumstances/events have potential to cause incident') then 'NO ERROR' when outcome in ('Treatment /intervention required-caused temporary harm', 'Initial/prolonged hospitalization-caused temporary harm', 'Caused permanent harm', 'Near death event') then 'ERROR, HARM' when outcome in ('Actual error-did not reach patient', 'Actual error-caused no harm', 'Additional monitoring required-caused no harm') then 'ERROR, NO HARM' when outcome in ('Death') then 'ERROR, DEATH' else 'N/A' end)) as error, COUNT() as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 AND `Medication`.`deleted` = '' AND `Medication`.`archived` = '' AND `Medication`.`reach_patient` = 'Yes' GROUP BY ((case when outcome in ('Potential error, circumstances/events have potential to cause incident') then 'NO ERROR' when outcome in ('Treatment /intervention required-caused temporary harm', 'Initial/prolonged hospitalization-caused temporary harm', 'Caused permanent harm', 'Near death event') then 'ERROR, HARM' when outcome in ('Actual error-did not reach patient', 'Actual error-caused no harm', 'Additional monitoring required-caused no harm') then 'ERROR, NO HARM' when outcome in ('Death') then 'ERROR, DEATH' else 'N/A' end)) HAVING COUNT() > 0	5	5	1	maybe slow
SELECT `Designation`.`name`, COUNT() as cnt, `Designation`.`id` FROM `pvers`.`medications` AS `Medication` LEFT JOIN `pvers`.`designations` AS `Designation` ON (`Medication`.`designation_id` = `Designation`.`id`) WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 AND `Medication`.`deleted` = '' AND `Medication`.`archived` = '' AND `Medication`.`reach_patient` = 'Yes' GROUP BY `Designation`.`name`, `Designation`.`id` HAVING COUNT() > 0	11	11	2	maybe slow
SELECT ((case when error_cause_inexperience = 1 or error_cause_knowledge = 1 or error_cause_distraction = 1 then 'Staff factors' when error_cause_medication = 1 or error_cause_packaging = 1 or error_cause_sound = 1 then 'Medication related' when error_cause_workload = 1 or error_cause_peak = 1 or error_cause_stock = 1 then 'Work and environment' when error_cause_procedure = 1 or error_cause_abbreviations = 1 or error_cause_illegible = 1 or error_cause_inaccurate = 1 or error_cause_labelling = 1 or error_cause_computer = 1 or error_cause_other = 1 then 'Task and technology' else 'N/A' end)) as factor, COUNT() as cnt FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` IN (1, 2) AND `Medication`.`copied` != 1 AND `Medication`.`deleted` = '' AND `Medication`.`archived` = '' AND `Medication`.`reach_patient` = 'Yes' GROUP BY ((case when error_cause_inexperience = 1 or error_cause_knowledge = 1 or error_cause_distraction = 1 then 'Staff factors' when error_cause_medication = 1 or error_cause_packaging = 1 or error_cause_sound = 1 then 'Medication related' when error_cause_workload = 1 or error_cause_peak = 1 or error_cause_stock = 1 then 'Work and environment' when error_cause_procedure = 1 or error_cause_abbreviations = 1 or error_cause_illegible = 1 or error_cause_inaccurate = 1 or error_cause_labelling = 1 or error_cause_computer = 1 or error_cause_other = 1 then 'Task and technology' else 'N/A' end)) HAVING COUNT() > 0	5	5	1	maybe slow
SELECT `Medication`.`id` FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` = 2 AND `Medication`.`copied` != 1 AND `Medication`.`report_type` != 'Followup'	206	206	1
SELECT `MedicationProduct`.`product_name_i` AS `product_name_i`, COUNT(distinct MedicationProduct.medication_id) as cnt FROM `pvers`.`medication_products` AS `MedicationProduct` WHERE `MedicationProduct`.`medication_id` IN (3, 6, 47, 52, 71, 83, 88, 104, 106, 122, 142, 145, 146, 148, 152, 153, 157, 165, 172, 186, 187, 189, 192, 193, 196, 221, 222, 223, 224, 232, 234, 235, 237, 238, 241, 247, 249, 252, 253, 262, 263, 273, 280, 283, 284, 299, 341, 384, 387, 390, 439, 463, 469, 471, 473, 476, 482, 483, 486, 487, 488, 490, 497, 499, 501, 503, 508, 514, 519, 520, 522, 525, 526, 529, 532, 546, 553, 557, 562, 563, 565, 574, 576, 577, 579, 580, 581, 584, 585, 586, 590, 592, 593, 594, 595, 596, 597, 599, 602, 605, 608, 610, 614, 616, 623, 664, 665, 666, 668, 672, 673, 674, 680, 683, 741, 778, 780, 781, 783, 785, 786, 791, 792, 793, 794, 796, 805, 808, 811, 812, 813, 814, 817, 818, 819, 821, 824, 827, 828, 829, 831, 832, 833, 835, 838, 845, 847, 849, 852, 853, 855, 869, 870, 871, 873, 876, 882, 886, 900, 901, 911, 912, 913, 914, 915, 916, 917, 919, 921, 922, 939, 943, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 958, 960, 962, 963, 964, 968, 971, 974, 976, 980, 988, 989, 990, 991, 992, 993, 1002, 1004, 1005, 1016, 1017, 1021, 1022, 1056) GROUP BY `MedicationProduct`.`product_name_i` HAVING COUNT(distinct `MedicationProduct`.`medication_id`) > 0	40	40	1
SELECT `Medication`.`id` FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` = 2 AND `Medication`.`copied` != 1 AND `Medication`.`report_type` != 'Followup'	206	206	1
SELECT `MedicationProduct`.`product_name_ii` AS `product_name_ii`, COUNT(distinct MedicationProduct.medication_id) as cnt FROM `pvers`.`medication_products` AS `MedicationProduct` WHERE `MedicationProduct`.`medication_id` IN (3, 6, 47, 52, 71, 83, 88, 104, 106, 122, 142, 145, 146, 148, 152, 153, 157, 165, 172, 186, 187, 189, 192, 193, 196, 221, 222, 223, 224, 232, 234, 235, 237, 238, 241, 247, 249, 252, 253, 262, 263, 273, 280, 283, 284, 299, 341, 384, 387, 390, 439, 463, 469, 471, 473, 476, 482, 483, 486, 487, 488, 490, 497, 499, 501, 503, 508, 514, 519, 520, 522, 525, 526, 529, 532, 546, 553, 557, 562, 563, 565, 574, 576, 577, 579, 580, 581, 584, 585, 586, 590, 592, 593, 594, 595, 596, 597, 599, 602, 605, 608, 610, 614, 616, 623, 664, 665, 666, 668, 672, 673, 674, 680, 683, 741, 778, 780, 781, 783, 785, 786, 791, 792, 793, 794, 796, 805, 808, 811, 812, 813, 814, 817, 818, 819, 821, 824, 827, 828, 829, 831, 832, 833, 835, 838, 845, 847, 849, 852, 853, 855, 869, 870, 871, 873, 876, 882, 886, 900, 901, 911, 912, 913, 914, 915, 916, 917, 919, 921, 922, 939, 943, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 958, 960, 962, 963, 964, 968, 971, 974, 976, 980, 988, 989, 990, 991, 992, 993, 1002, 1004, 1005, 1016, 1017, 1021, 1022, 1056) GROUP BY `MedicationProduct`.`product_name_ii` HAVING COUNT(distinct `MedicationProduct`.`medication_id`) > 0	34	34	1
SELECT `Medication`.`id` FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` = 2 AND `Medication`.`copied` != 1 AND `Medication`.`report_type` != 'Followup'	206	206	1
SELECT `MedicationProduct`.`generic_name_i` AS `generic_name_i`, COUNT(distinct MedicationProduct.medication_id) as cnt FROM `pvers`.`medication_products` AS `MedicationProduct` WHERE `MedicationProduct`.`created` > '2020-04-01 08:08:08' AND `MedicationProduct`.`generic_name_i` > '' AND `MedicationProduct`.`medication_id` IN (3, 6, 47, 52, 71, 83, 88, 104, 106, 122, 142, 145, 146, 148, 152, 153, 157, 165, 172, 186, 187, 189, 192, 193, 196, 221, 222, 223, 224, 232, 234, 235, 237, 238, 241, 247, 249, 252, 253, 262, 263, 273, 280, 283, 284, 299, 341, 384, 387, 390, 439, 463, 469, 471, 473, 476, 482, 483, 486, 487, 488, 490, 497, 499, 501, 503, 508, 514, 519, 520, 522, 525, 526, 529, 532, 546, 553, 557, 562, 563, 565, 574, 576, 577, 579, 580, 581, 584, 585, 586, 590, 592, 593, 594, 595, 596, 597, 599, 602, 605, 608, 610, 614, 616, 623, 664, 665, 666, 668, 672, 673, 674, 680, 683, 741, 778, 780, 781, 783, 785, 786, 791, 792, 793, 794, 796, 805, 808, 811, 812, 813, 814, 817, 818, 819, 821, 824, 827, 828, 829, 831, 832, 833, 835, 838, 845, 847, 849, 852, 853, 855, 869, 870, 871, 873, 876, 882, 886, 900, 901, 911, 912, 913, 914, 915, 916, 917, 919, 921, 922, 939, 943, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 958, 960, 962, 963, 964, 968, 971, 974, 976, 980, 988, 989, 990, 991, 992, 993, 1002, 1004, 1005, 1016, 1017, 1021, 1022, 1056) GROUP BY `MedicationProduct`.`generic_name_i` HAVING COUNT(distinct `MedicationProduct`.`medication_id`) > 0	72	72	1
SELECT `Medication`.`id` FROM `pvers`.`medications` AS `Medication` WHERE `Medication`.`submitted` = 2 AND `Medication`.`copied` != 1 AND `Medication`.`report_type` != 'Followup'	206	206	1
SELECT `MedicationProduct`.`generic_name_ii` AS `generic_name_ii`, COUNT(distinct MedicationProduct.medication_id) as cnt FROM `pvers`.`medication_products` AS `MedicationProduct` WHERE `MedicationProduct`.`created` > '2020-04-01 08:08:08' AND `MedicationProduct`.`generic_name_ii` > '' AND `MedicationProduct`.`medication_id` IN (3, 6, 47, 52, 71, 83, 88, 104, 106, 122, 142, 145, 146, 148, 152, 153, 157, 165, 172, 186, 187, 189, 192, 193, 196, 221, 222, 223, 224, 232, 234, 235, 237, 238, 241, 247, 249, 252, 253, 262, 263, 273, 280, 283, 284, 299, 341, 384, 387, 390, 439, 463, 469, 471, 473, 476, 482, 483, 486, 487, 488, 490, 497, 499, 501, 503, 508, 514, 519, 520, 522, 525, 526, 529, 532, 546, 553, 557, 562, 563, 565, 574, 576, 577, 579, 580, 581, 584, 585, 586, 590, 592, 593, 594, 595, 596, 597, 599, 602, 605, 608, 610, 614, 616, 623, 664, 665, 666, 668, 672, 673, 674, 680, 683, 741, 778, 780, 781, 783, 785, 786, 791, 792, 793, 794, 796, 805, 808, 811, 812, 813, 814, 817, 818, 819, 821, 824, 827, 828, 829, 831, 832, 833, 835, 838, 845, 847, 849, 852, 853, 855, 869, 870, 871, 873, 876, 882, 886, 900, 901, 911, 912, 913, 914, 915, 916, 917, 919, 921, 922, 939, 943, 947, 948, 949, 950, 951, 952, 953, 954, 955, 956, 958, 960, 962, 963, 964, 968, 971, 974, 976, 980, 988, 989, 990, 991, 992, 993, 1002, 1004, 1005, 1016, 1017, 1021, 1022, 1056) GROUP BY `MedicationProduct`.`generic_name_ii` HAVING COUNT(distinct `MedicationProduct`.`medication_id`) > 0	86	86	1

3 duplicate queries run.

Query Explain:

Click an "Explain" link above, to see the query explanation.

====

Log
+

Logs

There were no log entries made this request

====
Variables
+
View Variables
- _serializecomparison
- gecomparison(array)
  -(array)
  generic_name-
  gi_count3
  ge_count3
  -abc3tcdtg(array)
  generic_name-abc3tcdtg
  gi_count1
  ge_count0
  3TC(array)
  generic_name3TC
  gi_count3
  ge_count2
  Abacavir(array)
  generic_nameAbacavir
  gi_count18
  ge_count0
  Abacavir+lamivudine+dolutegravir(array)
  generic_nameAbacavir+lamivudine+dolutegravir
  gi_count1
  ge_count0
  Abacavir, lavivudine,deglutegravir(array)
  generic_nameAbacavir, lavivudine,deglutegravir
  gi_count1
  ge_count0
  Abacavir/Lamivudine/Dolutegravir(array)
  generic_nameAbacavir/Lamivudine/Dolutegravir
  gi_count3
  ge_count0
  Abacavir/lamovodine/dolutegravir(array)
  generic_nameAbacavir/lamovodine/dolutegravir
  gi_count1
  ge_count0
  Abacavirxh,lamividine,delougatravir (array)
  generic_nameAbacavirxh,lamividine,delougatravir
  gi_count1
  ge_count0
  ABC(array)
  generic_nameABC
  gi_count12
  ge_count5
  ABC (Abacavir)(array)
  generic_nameABC (Abacavir)
  gi_count1
  ge_count0
  ABC ,3TC DTG(array)
  generic_nameABC ,3TC DTG
  gi_count1
  ge_count0
  ABC /3TC/DTG(array)
  generic_nameABC /3TC/DTG
  gi_count2
  ge_count0
  ABC 3TC DTG(array)
  generic_nameABC 3TC DTG
  gi_count1
  ge_count0
  ABC+3T(array)
  generic_nameABC+3T
  gi_count1
  ge_count0
  ABC+3TC+ DTG(array)
  generic_nameABC+3TC+ DTG
  gi_count1
  ge_count0
  Abc+3tc+dtg(array)
  generic_nameAbc+3tc+dtg
  gi_count16
  ge_count0
  ABC+3TC+DTG+(array)
  generic_nameABC+3TC+DTG+
  gi_count1
  ge_count0
  Abc,3tc,dtg(array)
  generic_nameAbc,3tc,dtg
  gi_count3
  ge_count0
  ABC/3TC(array)
  generic_nameABC/3TC
  gi_count3
  ge_count0
  ABC/3TC , DTG(array)
  generic_nameABC/3TC , DTG
  gi_count1
  ge_count0
  ABC/3TC and DTG(array)
  generic_nameABC/3TC and DTG
  gi_count1
  ge_count0
  ABC/3TC, DTG(array)
  generic_nameABC/3TC, DTG
  gi_count1
  ge_count0
  ABC/3TC/DTG(array)
  generic_nameABC/3TC/DTG
  gi_count42
  ge_count0
  ABC/3TC/TDG(array)
  generic_nameABC/3TC/TDG
  gi_count2
  ge_count0
  ABC/3TC120/60mg DTG 50mg(array)
  generic_nameABC/3TC120/60mg DTG 50mg
  gi_count1
  ge_count0
  ABC/3TCplus DTG(array)
  generic_nameABC/3TCplus DTG
  gi_count1
  ge_count0
  ABC/3TG/DTG(array)
  generic_nameABC/3TG/DTG
  gi_count1
  ge_count0
  Abc3tcdtg(array)
  generic_nameAbc3tcdtg
  gi_count1
  ge_count0
  ABC_3TC/Dtg(array)
  generic_nameABC_3TC/Dtg
  gi_count1
  ge_count0
  ABZ 1tab(array)
  generic_nameABZ 1tab
  gi_count1
  ge_count0
  Acetazolamide(array)
  generic_nameAcetazolamide
  gi_count1
  ge_count0
  ART(array)
  generic_nameART
  gi_count1
  ge_count1
  artesunate(array)
  generic_nameartesunate
  gi_count13
  ge_count0
  artesunate 60mg vial(array)
  generic_nameartesunate 60mg vial
  gi_count1
  ge_count0
  Atenolol (array)
  generic_nameAtenolol
  gi_count1
  ge_count0
  Azithromycin(array)
  generic_nameAzithromycin
  gi_count1
  ge_count0
  Chlorpheniramine (array)
  generic_nameChlorpheniramine
  gi_count1
  ge_count0
  correct low albumin levels(array)
  generic_namecorrect low albumin levels
  gi_count1
  ge_count0
  DEC(array)
  generic_nameDEC
  gi_count3
  ge_count0
  Deltagravir (array)
  generic_nameDeltagravir
  gi_count1
  ge_count0
  Diclofenac(array)
  generic_nameDiclofenac
  gi_count1
  ge_count0
  Dolutegraviramivufine/tenofovir (array)
  generic_nameDolutegraviramivufine/tenofovir
  gi_count1
  ge_count0
  Dtg(array)
  generic_nameDtg
  gi_count11
  ge_count0
  G(array)
  generic_nameG
  gi_count1
  ge_count0
  G1(array)
  generic_nameG1
  gi_count1
  ge_count0
  Gen I(array)
  generic_nameGen I
  gi_count1
  ge_count0
  Generic name I(array)
  generic_nameGeneric name I
  gi_count2
  ge_count0
  Genx(array)
  generic_nameGenx
  gi_count1
  ge_count0
  H(array)
  generic_nameH
  gi_count1
  ge_count0
  Iv artesunate (array)
  generic_nameIv artesunate
  gi_count1
  ge_count0
  measles rubella vaccine(array)
  generic_namemeasles rubella vaccine
  gi_count1
  ge_count1
  metformin(array)
  generic_namemetformin
  gi_count1
  ge_count0
  Mionate(array)
  generic_nameMionate
  gi_count1
  ge_count0
  N/A(array)
  generic_nameN/A
  gi_count2
  ge_count5
  Paracetamol (array)
  generic_nameParacetamol
  gi_count1
  ge_count0
  Sodium Valproate(array)
  generic_nameSodium Valproate
  gi_count3
  ge_count3
  Sodium Vaproate(array)
  generic_nameSodium Vaproate
  gi_count1
  ge_count0
  TDF(array)
  generic_nameTDF
  gi_count4
  ge_count14
  TDF+3TC(array)
  generic_nameTDF+3TC
  gi_count1
  ge_count0
  TDF+3TC+ABC(array)
  generic_nameTDF+3TC+ABC
  gi_count2
  ge_count0
  TDF+3TC+DTC+DTG(array)
  generic_nameTDF+3TC+DTC+DTG
  gi_count1
  ge_count0
  TDF+3TC+DTG(array)
  generic_nameTDF+3TC+DTG
  gi_count2
  ge_count19
  Tdf+3tc+dtg+(array)
  generic_nameTdf+3tc+dtg+
  gi_count1
  ge_count0
  Tdf,3tc dtg(array)
  generic_nameTdf,3tc dtg
  gi_count1
  ge_count0
  Tdf,3tc,dtg(array)
  generic_nameTdf,3tc,dtg
  gi_count1
  ge_count0
  TDF/3TC/DTG(array)
  generic_nameTDF/3TC/DTG
  gi_count10
  ge_count39
  Tenofovir(array)
  generic_nameTenofovir
  gi_count4
  ge_count13
  Tenofovir/Lamivudine/Dolutegravir(array)
  generic_nameTenofovir/Lamivudine/Dolutegravir
  gi_count1
  ge_count0
  Tenovir,lamuvidine dolutegravir(array)
  generic_nameTenovir,lamuvidine dolutegravir
  gi_count1
  ge_count0
  TLD(array)
  generic_nameTLD
  gi_count4
  ge_count9
  We(array)
  generic_nameWe
  gi_count1
  ge_count0
  1(array)
  generic_name1
  gi_count0
  ge_count10
  2(array)
  generic_name2
  gi_count0
  ge_count2
  3(array)
  generic_name3
  gi_count0
  ge_count1
  3TC+TDF+DTG(array)
  generic_name3TC+TDF+DTG
  gi_count0
  ge_count1
  400(array)
  generic_name400
  gi_count0
  ge_count1
  400mg(array)
  generic_name400mg
  gi_count0
  ge_count1
  5mg(array)
  generic_name5mg
  gi_count0
  ge_count1
  ABC+3tc+dtg(array)
  generic_nameABC+3tc+dtg
  gi_count0
  ge_count1
  ABC,3tc,dtg(array)
  generic_nameABC,3tc,dtg
  gi_count0
  ge_count1
  ABC/3TC,DTG(array)
  generic_nameABC/3TC,DTG
  gi_count0
  ge_count1
  abc/3tc/dtg(array)
  generic_nameabc/3tc/dtg
  gi_count0
  ge_count1
  Adult dose given(array)
  generic_nameAdult dose given
  gi_count0
  ge_count1
  Art overdose esunate (array)
  generic_nameArt overdose esunate
  gi_count0
  ge_count1
  Artesunate(array)
  generic_nameArtesunate
  gi_count0
  ge_count5
  artesunate inj(array)
  generic_nameartesunate inj
  gi_count0
  ge_count1
  Atenolol(array)
  generic_nameAtenolol
  gi_count0
  ge_count1
  auronafin(array)
  generic_nameauronafin
  gi_count0
  ge_count1
  Azithromycin (array)
  generic_nameAzithromycin
  gi_count0
  ge_count1
  Chlorpromazine (array)
  generic_nameChlorpromazine
  gi_count0
  ge_count1
  DEC (array)
  generic_nameDEC
  gi_count0
  ge_count1
  DF/3TC/DTG(array)
  generic_nameDF/3TC/DTG
  gi_count0
  ge_count1
  Digoxin(array)
  generic_nameDigoxin
  gi_count0
  ge_count1
  DTG(array)
  generic_nameDTG
  gi_count0
  ge_count5
  DTG,3TC(array)
  generic_nameDTG,3TC
  gi_count0
  ge_count1
  DTG/3TC/DTG(array)
  generic_nameDTG/3TC/DTG
  gi_count0
  ge_count1
  DTG/TDF/3TC(array)
  generic_nameDTG/TDF/3TC
  gi_count0
  ge_count2
  Epival (array)
  generic_nameEpival
  gi_count0
  ge_count1
  Error (array)
  generic_nameError
  gi_count0
  ge_count1
  frequency error. 0h and 2h(array)
  generic_namefrequency error. 0h and 2h
  gi_count0
  ge_count1
  G2(array)
  generic_nameG2
  gi_count0
  ge_count1
  Gen II(array)
  generic_nameGen II
  gi_count0
  ge_count1
  Generic name II(array)
  generic_nameGeneric name II
  gi_count0
  ge_count2
  Gennamex(array)
  generic_nameGennamex
  gi_count0
  ge_count1
  glibenclamide(array)
  generic_nameglibenclamide
  gi_count0
  ge_count1
  high protein diet(array)
  generic_namehigh protein diet
  gi_count0
  ge_count1
  IV artesunate (array)
  generic_nameIV artesunate
  gi_count0
  ge_count1
  Medical (array)
  generic_nameMedical
  gi_count0
  ge_count1
  Mionate (array)
  generic_nameMionate
  gi_count0
  ge_count1
  Na(array)
  generic_nameNa
  gi_count0
  ge_count1
  Non(array)
  generic_nameNon
  gi_count0
  ge_count1
  None (array)
  generic_nameNone
  gi_count0
  ge_count4
  Oral(array)
  generic_nameOral
  gi_count0
  ge_count1
  Overdose (array)
  generic_nameOverdose
  gi_count0
  ge_count1
  R(array)
  generic_nameR
  gi_count0
  ge_count2
  Rdf(array)
  generic_nameRdf
  gi_count0
  ge_count1
  T(array)
  generic_nameT
  gi_count0
  ge_count1
  TDF (Tenofovir)(array)
  generic_nameTDF (Tenofovir)
  gi_count0
  ge_count1
  TDF 3TC DTG(array)
  generic_nameTDF 3TC DTG
  gi_count0
  ge_count2
  Tdf+. 3tc+drg(array)
  generic_nameTdf+. 3tc+drg
  gi_count0
  ge_count1
  TDF+3tc(array)
  generic_nameTDF+3tc
  gi_count0
  ge_count1
  TDF+3TC+DGG(array)
  generic_nameTDF+3TC+DGG
  gi_count0
  ge_count1
  Tdf,3tc,Dtg(array)
  generic_nameTdf,3tc,Dtg
  gi_count0
  ge_count1
  Tdf.3tc.dtg(array)
  generic_nameTdf.3tc.dtg
  gi_count0
  ge_count1
  TDF/33TC/DTG(array)
  generic_nameTDF/33TC/DTG
  gi_count0
  ge_count1
  Tdf/3tc'dtg(array)
  generic_nameTdf/3tc'dtg
  gi_count0
  ge_count1
  TDF/3TC/DG(array)
  generic_nameTDF/3TC/DG
  gi_count0
  ge_count1
  Tdf3tcdtg(array)
  generic_nameTdf3tcdtg
  gi_count0
  ge_count1
  Tenefovir (array)
  generic_nameTenefovir
  gi_count0
  ge_count1
  tenofivir(array)
  generic_nametenofivir
  gi_count0
  ge_count1
  Tenofoviar(array)
  generic_nameTenofoviar
  gi_count0
  ge_count1
  Tenofovif/lamovodine/dolutegravir(array)
  generic_nameTenofovif/lamovodine/dolutegravir
  gi_count0
  ge_count1
  Tenofovir,dolutegravir,lamuvidine(array)
  generic_nameTenofovir,dolutegravir,lamuvidine
  gi_count0
  ge_count1
  Tenofovir/Dulotegravir/Lamivudine(array)
  generic_nameTenofovir/Dulotegravir/Lamivudine
  gi_count0
  ge_count1
  Tenofovir/lamividine/Dolutegravir(array)
  generic_nameTenofovir/lamividine/Dolutegravir
  gi_count0
  ge_count1
  Tenofovir/lamivudine/dolutegravir (array)
  generic_nameTenofovir/lamivudine/dolutegravir
  gi_count0
  ge_count1
  TenofovirF(array)
  generic_nameTenofovirF
  gi_count0
  ge_count1
  Tenovir(array)
  generic_nameTenovir
  gi_count0
  ge_count1
  Tenovovir,lamivudine,deglutegravir(array)
  generic_nameTenovovir,lamivudine,deglutegravir
  gi_count0
  ge_count1
  TFF/3tc/dtg(array)
  generic_nameTFF/3tc/dtg
  gi_count0
  ge_count1
  TLG(array)
  generic_nameTLG
  gi_count0
  ge_count1
  Vvv(array)
  generic_nameVvv
  gi_count0
  ge_count1
  Wrong drug(array)
  generic_nameWrong drug
  gi_count0
  ge_count1
  Wrong prescription (array)
  generic_nameWrong prescription
  gi_count0
  ge_count1
  Yes(array)
  generic_nameYes
  gi_count0
  ge_count1
- comparison(array)
  -(array)
  product_name-
  pi_count4
  pe_count3
  Abacavir(array)
  product_nameAbacavir
  pi_count1
  pe_count0
  ABC(array)
  product_nameABC
  pi_count1
  pe_count1
  ABC+3TC+DTG(array)
  product_nameABC+3TC+DTG
  pi_count4
  pe_count0
  ABC+3TG(array)
  product_nameABC+3TG
  pi_count1
  pe_count0
  ABC,3TC,DTG(array)
  product_nameABC,3TC,DTG
  pi_count1
  pe_count0
  Abc/3tc/dtg(array)
  product_nameAbc/3tc/dtg
  pi_count1
  pe_count0
  Acetominophen(array)
  product_nameAcetominophen
  pi_count1
  pe_count1
  Acriptega(array)
  product_nameAcriptega
  pi_count2
  pe_count0
  Acritega(array)
  product_nameAcritega
  pi_count1
  pe_count0
  Alo(array)
  product_nameAlo
  pi_count1
  pe_count0
  Artesunate(array)
  product_nameArtesunate
  pi_count1
  pe_count0
  B1(array)
  product_nameB1
  pi_count1
  pe_count0
  Brand I(array)
  product_nameBrand I
  pi_count3
  pe_count0
  Brandx(array)
  product_nameBrandx
  pi_count1
  pe_count1
  Chlor (array)
  product_nameChlor
  pi_count1
  pe_count0
  Diamox(array)
  product_nameDiamox
  pi_count1
  pe_count0
  Diethylcarbamazine(array)
  product_nameDiethylcarbamazine
  pi_count1
  pe_count0
  Dinac (array)
  product_nameDinac
  pi_count1
  pe_count0
  Dolte(array)
  product_nameDolte
  pi_count1
  pe_count0
  DTG(array)
  product_nameDTG
  pi_count2
  pe_count0
  Dylantin, Tena Ltd(array)
  product_nameDylantin, Tena Ltd
  pi_count1
  pe_count0
  Dyzantil(array)
  product_nameDyzantil
  pi_count2
  pe_count0
  Epival (array)
  product_nameEpival
  pi_count1
  pe_count0
  Epivir(array)
  product_nameEpivir
  pi_count1
  pe_count1
  Gg(array)
  product_nameGg
  pi_count1
  pe_count0
  Meme(array)
  product_nameMeme
  pi_count1
  pe_count0
  mionate(array)
  product_namemionate
  pi_count15
  pe_count0
  Mylan(array)
  product_nameMylan
  pi_count1
  pe_count1
  N/A(array)
  product_nameN/A
  pi_count7
  pe_count0
  Na(array)
  product_nameNa
  pi_count5
  pe_count2
  None(array)
  product_nameNone
  pi_count1
  pe_count3
  T(array)
  product_nameT
  pi_count1
  pe_count0
  TDF(array)
  product_nameTDF
  pi_count2
  pe_count0
  TDF+3TC+DTG(array)
  product_nameTDF+3TC+DTG
  pi_count1
  pe_count0
  Tenofovit(array)
  product_nameTenofovit
  pi_count1
  pe_count0
  TLD(array)
  product_nameTLD
  pi_count4
  pe_count2
  Unknown (array)
  product_nameUnknown
  pi_count1
  pe_count0
  Ziagen(array)
  product_nameZiagen
  pi_count1
  pe_count1
  1(array)
  product_name1
  pi_count0
  pe_count1
  B2(array)
  product_nameB2
  pi_count0
  pe_count1
  Brand II(array)
  product_nameBrand II
  pi_count0
  pe_count3
  Chlorzine (array)
  product_nameChlorzine
  pi_count0
  pe_count1
  D(array)
  product_nameD
  pi_count0
  pe_count1
  DEC (array)
  product_nameDEC
  pi_count0
  pe_count1
  Epival(array)
  product_nameEpival
  pi_count0
  pe_count2
  Epival, Landi Ltd(array)
  product_nameEpival, Landi Ltd
  pi_count0
  pe_count1
  gold(array)
  product_namegold
  pi_count0
  pe_count1
  Lanoxin(array)
  product_nameLanoxin
  pi_count0
  pe_count1
  Mionate(array)
  product_nameMionate
  pi_count0
  pe_count4
  N/a(array)
  product_nameN/a
  pi_count0
  pe_count4
  Non(array)
  product_nameNon
  pi_count0
  pe_count1
  NS(array)
  product_nameNS
  pi_count0
  pe_count1
  Oo(array)
  product_nameOo
  pi_count0
  pe_count1
  TDf(array)
  product_nameTDf
  pi_count0
  pe_count3
  TDF+3TC(array)
  product_nameTDF+3TC
  pi_count0
  pe_count1
  Tdf+3tc+dtg(array)
  product_nameTdf+3tc+dtg
  pi_count0
  pe_count2
  TDF+3TC+DTGl(array)
  product_nameTDF+3TC+DTGl
  pi_count0
  pe_count1
  TDF,3TC,DTG(array)
  product_nameTDF,3TC,DTG
  pi_count0
  pe_count1
  TENOFOVIR(array)
  product_nameTENOFOVIR
  pi_count0
  pe_count1
  Vera(array)
  product_nameVera
  pi_count0
  pe_count1
  Vvb(array)
  product_nameVvb
  pi_count0
  pe_count1
- ge(array)
  0(array)
  MedicationProduct(array)
  generic_name_ii-
  0(array)
  cnt3
  1(array)
  MedicationProduct(array)
  generic_name_ii1
  0(array)
  cnt10
  2(array)
  MedicationProduct(array)
  generic_name_ii2
  0(array)
  cnt2
  3(array)
  MedicationProduct(array)
  generic_name_ii3
  0(array)
  cnt1
  4(array)
  MedicationProduct(array)
  generic_name_ii3TC
  0(array)
  cnt2
  5(array)
  MedicationProduct(array)
  generic_name_ii3TC+TDF+DTG
  0(array)
  cnt1
  6(array)
  MedicationProduct(array)
  generic_name_ii400
  0(array)
  cnt1
  7(array)
  MedicationProduct(array)
  generic_name_ii400mg
  0(array)
  cnt1
  8(array)
  MedicationProduct(array)
  generic_name_ii5mg
  0(array)
  cnt1
  9(array)
  MedicationProduct(array)
  generic_name_iiABC
  0(array)
  cnt5
  10(array)
  MedicationProduct(array)
  generic_name_iiABC+3tc+dtg
  0(array)
  cnt1
  11(array)
  MedicationProduct(array)
  generic_name_iiABC,3tc,dtg
  0(array)
  cnt1
  12(array)
  MedicationProduct(array)
  generic_name_iiABC/3TC,DTG
  0(array)
  cnt1
  13(array)
  MedicationProduct(array)
  generic_name_iiabc/3tc/dtg
  0(array)
  cnt1
  14(array)
  MedicationProduct(array)
  generic_name_iiAdult dose given
  0(array)
  cnt1
  15(array)
  MedicationProduct(array)
  generic_name_iiART
  0(array)
  cnt1
  16(array)
  MedicationProduct(array)
  generic_name_iiArt overdose esunate
  0(array)
  cnt1
  17(array)
  MedicationProduct(array)
  generic_name_iiArtesunate
  0(array)
  cnt5
  18(array)
  MedicationProduct(array)
  generic_name_iiartesunate inj
  0(array)
  cnt1
  19(array)
  MedicationProduct(array)
  generic_name_iiAtenolol
  0(array)
  cnt1
  20(array)
  MedicationProduct(array)
  generic_name_iiauronafin
  0(array)
  cnt1
  21(array)
  MedicationProduct(array)
  generic_name_iiAzithromycin
  0(array)
  cnt1
  22(array)
  MedicationProduct(array)
  generic_name_iiChlorpromazine
  0(array)
  cnt1
  23(array)
  MedicationProduct(array)
  generic_name_iiDEC
  0(array)
  cnt1
  24(array)
  MedicationProduct(array)
  generic_name_iiDF/3TC/DTG
  0(array)
  cnt1
  25(array)
  MedicationProduct(array)
  generic_name_iiDigoxin
  0(array)
  cnt1
  26(array)
  MedicationProduct(array)
  generic_name_iiDTG
  0(array)
  cnt5
  27(array)
  MedicationProduct(array)
  generic_name_iiDTG,3TC
  0(array)
  cnt1
  28(array)
  MedicationProduct(array)
  generic_name_iiDTG/3TC/DTG
  0(array)
  cnt1
  29(array)
  MedicationProduct(array)
  generic_name_iiDTG/TDF/3TC
  0(array)
  cnt2
  30(array)
  MedicationProduct(array)
  generic_name_iiEpival
  0(array)
  cnt1
  31(array)
  MedicationProduct(array)
  generic_name_iiError
  0(array)
  cnt1
  32(array)
  MedicationProduct(array)
  generic_name_iifrequency error. 0h and 2h
  0(array)
  cnt1
  33(array)
  MedicationProduct(array)
  generic_name_iiG2
  0(array)
  cnt1
  34(array)
  MedicationProduct(array)
  generic_name_iiGen II
  0(array)
  cnt1
  35(array)
  MedicationProduct(array)
  generic_name_iiGeneric name II
  0(array)
  cnt2
  36(array)
  MedicationProduct(array)
  generic_name_iiGennamex
  0(array)
  cnt1
  37(array)
  MedicationProduct(array)
  generic_name_iiglibenclamide
  0(array)
  cnt1
  38(array)
  MedicationProduct(array)
  generic_name_iihigh protein diet
  0(array)
  cnt1
  39(array)
  MedicationProduct(array)
  generic_name_iiIV artesunate
  0(array)
  cnt1
  40(array)
  MedicationProduct(array)
  generic_name_iimeasles rubella vaccine
  0(array)
  cnt1
  41(array)
  MedicationProduct(array)
  generic_name_iiMedical
  0(array)
  cnt1
  42(array)
  MedicationProduct(array)
  generic_name_iiMionate
  0(array)
  cnt1
  43(array)
  MedicationProduct(array)
  generic_name_iiN/A
  0(array)
  cnt5
  44(array)
  MedicationProduct(array)
  generic_name_iiNa
  0(array)
  cnt1
  45(array)
  MedicationProduct(array)
  generic_name_iiNon
  0(array)
  cnt1
  46(array)
  MedicationProduct(array)
  generic_name_iiNone
  0(array)
  cnt4
  47(array)
  MedicationProduct(array)
  generic_name_iiOral
  0(array)
  cnt1
  48(array)
  MedicationProduct(array)
  generic_name_iiOverdose
  0(array)
  cnt1
  49(array)
  MedicationProduct(array)
  generic_name_iiR
  0(array)
  cnt2
  50(array)
  MedicationProduct(array)
  generic_name_iiRdf
  0(array)
  cnt1
  51(array)
  MedicationProduct(array)
  generic_name_iiSodium Valproate
  0(array)
  cnt3
  52(array)
  MedicationProduct(array)
  generic_name_iiT
  0(array)
  cnt1
  53(array)
  MedicationProduct(array)
  generic_name_iiTDF
  0(array)
  cnt14
  54(array)
  MedicationProduct(array)
  generic_name_iiTDF (Tenofovir)
  0(array)
  cnt1
  55(array)
  MedicationProduct(array)
  generic_name_iiTDF 3TC DTG
  0(array)
  cnt2
  56(array)
  MedicationProduct(array)
  generic_name_iiTdf+. 3tc+drg
  0(array)
  cnt1
  57(array)
  MedicationProduct(array)
  generic_name_iiTDF+3tc
  0(array)
  cnt1
  58(array)
  MedicationProduct(array)
  generic_name_iiTDF+3TC+DGG
  0(array)
  cnt1
  59(array)
  MedicationProduct(array)
  generic_name_iiTDF+3TC+DTG
  0(array)
  cnt19
  60(array)
  MedicationProduct(array)
  generic_name_iiTdf,3tc,Dtg
  0(array)
  cnt1
  61(array)
  MedicationProduct(array)
  generic_name_iiTdf.3tc.dtg
  0(array)
  cnt1
  62(array)
  MedicationProduct(array)
  generic_name_iiTDF/33TC/DTG
  0(array)
  cnt1
  63(array)
  MedicationProduct(array)
  generic_name_iiTdf/3tc'dtg
  0(array)
  cnt1
  64(array)
  MedicationProduct(array)
  generic_name_iiTDF/3TC/DG
  0(array)
  cnt1
  65(array)
  MedicationProduct(array)
  generic_name_iiTDF/3TC/DTG
  0(array)
  cnt39
  66(array)
  MedicationProduct(array)
  generic_name_iiTdf3tcdtg
  0(array)
  cnt1
  67(array)
  MedicationProduct(array)
  generic_name_iiTenefovir
  0(array)
  cnt1
  68(array)
  MedicationProduct(array)
  generic_name_iitenofivir
  0(array)
  cnt1
  69(array)
  MedicationProduct(array)
  generic_name_iiTenofoviar
  0(array)
  cnt1
  70(array)
  MedicationProduct(array)
  generic_name_iiTenofovif/lamovodine/dolutegravir
  0(array)
  cnt1
  71(array)
  MedicationProduct(array)
  generic_name_iiTenofovir
  0(array)
  cnt13
  72(array)
  MedicationProduct(array)
  generic_name_iiTenofovir,dolutegravir,lamuvidine
  0(array)
  cnt1
  73(array)
  MedicationProduct(array)
  generic_name_iiTenofovir/Dulotegravir/Lamivudine
  0(array)
  cnt1
  74(array)
  MedicationProduct(array)
  generic_name_iiTenofovir/lamividine/Dolutegravir
  0(array)
  cnt1
  75(array)
  MedicationProduct(array)
  generic_name_iiTenofovir/lamivudine/dolutegravir
  0(array)
  cnt1
  76(array)
  MedicationProduct(array)
  generic_name_iiTenofovirF
  0(array)
  cnt1
  77(array)
  MedicationProduct(array)
  generic_name_iiTenovir
  0(array)
  cnt1
  78(array)
  MedicationProduct(array)
  generic_name_iiTenovovir,lamivudine,deglutegravir
  0(array)
  cnt1
  79(array)
  MedicationProduct(array)
  generic_name_iiTFF/3tc/dtg
  0(array)
  cnt1
  80(array)
  MedicationProduct(array)
  generic_name_iiTLD
  0(array)
  cnt9
  81(array)
  MedicationProduct(array)
  generic_name_iiTLG
  0(array)
  cnt1
  82(array)
  MedicationProduct(array)
  generic_name_iiVvv
  0(array)
  cnt1
  83(array)
  MedicationProduct(array)
  generic_name_iiWrong drug
  0(array)
  cnt1
  84(array)
  MedicationProduct(array)
  generic_name_iiWrong prescription
  0(array)
  cnt1
  85(array)
  MedicationProduct(array)
  generic_name_iiYes
  0(array)
  cnt1
- gi(array)
  0(array)
  MedicationProduct(array)
  generic_name_i-
  0(array)
  cnt3
  1(array)
  MedicationProduct(array)
  generic_name_i-abc3tcdtg
  0(array)
  cnt1
  2(array)
  MedicationProduct(array)
  generic_name_i3TC
  0(array)
  cnt3
  3(array)
  MedicationProduct(array)
  generic_name_iAbacavir
  0(array)
  cnt18
  4(array)
  MedicationProduct(array)
  generic_name_iAbacavir+lamivudine+dolutegravir
  0(array)
  cnt1
  5(array)
  MedicationProduct(array)
  generic_name_iAbacavir, lavivudine,deglutegravir
  0(array)
  cnt1
  6(array)
  MedicationProduct(array)
  generic_name_iAbacavir/Lamivudine/Dolutegravir
  0(array)
  cnt3
  7(array)
  MedicationProduct(array)
  generic_name_iAbacavir/lamovodine/dolutegravir
  0(array)
  cnt1
  8(array)
  MedicationProduct(array)
  generic_name_iAbacavirxh,lamividine,delougatravir
  0(array)
  cnt1
  9(array)
  MedicationProduct(array)
  generic_name_iABC
  0(array)
  cnt12
  10(array)
  MedicationProduct(array)
  generic_name_iABC (Abacavir)
  0(array)
  cnt1
  11(array)
  MedicationProduct(array)
  generic_name_iABC ,3TC DTG
  0(array)
  cnt1
  12(array)
  MedicationProduct(array)
  generic_name_iABC /3TC/DTG
  0(array)
  cnt2
  13(array)
  MedicationProduct(array)
  generic_name_iABC 3TC DTG
  0(array)
  cnt1
  14(array)
  MedicationProduct(array)
  generic_name_iABC+3T
  0(array)
  cnt1
  15(array)
  MedicationProduct(array)
  generic_name_iABC+3TC+ DTG
  0(array)
  cnt1
  16(array)
  MedicationProduct(array)
  generic_name_iAbc+3tc+dtg
  0(array)
  cnt16
  17(array)
  MedicationProduct(array)
  generic_name_iABC+3TC+DTG+
  0(array)
  cnt1
  18(array)
  MedicationProduct(array)
  generic_name_iAbc,3tc,dtg
  0(array)
  cnt3
  19(array)
  MedicationProduct(array)
  generic_name_iABC/3TC
  0(array)
  cnt3
  20(array)
  MedicationProduct(array)
  generic_name_iABC/3TC , DTG
  0(array)
  cnt1
  21(array)
  MedicationProduct(array)
  generic_name_iABC/3TC and DTG
  0(array)
  cnt1
  22(array)
  MedicationProduct(array)
  generic_name_iABC/3TC, DTG
  0(array)
  cnt1
  23(array)
  MedicationProduct(array)
  generic_name_iABC/3TC/DTG
  0(array)
  cnt42
  24(array)
  MedicationProduct(array)
  generic_name_iABC/3TC/TDG
  0(array)
  cnt2
  25(array)
  MedicationProduct(array)
  generic_name_iABC/3TC120/60mg DTG 50mg
  0(array)
  cnt1
  26(array)
  MedicationProduct(array)
  generic_name_iABC/3TCplus DTG
  0(array)
  cnt1
  27(array)
  MedicationProduct(array)
  generic_name_iABC/3TG/DTG
  0(array)
  cnt1
  28(array)
  MedicationProduct(array)
  generic_name_iAbc3tcdtg
  0(array)
  cnt1
  29(array)
  MedicationProduct(array)
  generic_name_iABC_3TC/Dtg
  0(array)
  cnt1
  30(array)
  MedicationProduct(array)
  generic_name_iABZ 1tab
  0(array)
  cnt1
  31(array)
  MedicationProduct(array)
  generic_name_iAcetazolamide
  0(array)
  cnt1
  32(array)
  MedicationProduct(array)
  generic_name_iART
  0(array)
  cnt1
  33(array)
  MedicationProduct(array)
  generic_name_iartesunate
  0(array)
  cnt13
  34(array)
  MedicationProduct(array)
  generic_name_iartesunate 60mg vial
  0(array)
  cnt1
  35(array)
  MedicationProduct(array)
  generic_name_iAtenolol
  0(array)
  cnt1
  36(array)
  MedicationProduct(array)
  generic_name_iAzithromycin
  0(array)
  cnt1
  37(array)
  MedicationProduct(array)
  generic_name_iChlorpheniramine
  0(array)
  cnt1
  38(array)
  MedicationProduct(array)
  generic_name_icorrect low albumin levels
  0(array)
  cnt1
  39(array)
  MedicationProduct(array)
  generic_name_iDEC
  0(array)
  cnt3
  40(array)
  MedicationProduct(array)
  generic_name_iDeltagravir
  0(array)
  cnt1
  41(array)
  MedicationProduct(array)
  generic_name_iDiclofenac
  0(array)
  cnt1
  42(array)
  MedicationProduct(array)
  generic_name_iDolutegraviramivufine/tenofovir
  0(array)
  cnt1
  43(array)
  MedicationProduct(array)
  generic_name_iDtg
  0(array)
  cnt11
  44(array)
  MedicationProduct(array)
  generic_name_iG
  0(array)
  cnt1
  45(array)
  MedicationProduct(array)
  generic_name_iG1
  0(array)
  cnt1
  46(array)
  MedicationProduct(array)
  generic_name_iGen I
  0(array)
  cnt1
  47(array)
  MedicationProduct(array)
  generic_name_iGeneric name I
  0(array)
  cnt2
  48(array)
  MedicationProduct(array)
  generic_name_iGenx
  0(array)
  cnt1
  49(array)
  MedicationProduct(array)
  generic_name_iH
  0(array)
  cnt1
  50(array)
  MedicationProduct(array)
  generic_name_iIv artesunate
  0(array)
  cnt1
  51(array)
  MedicationProduct(array)
  generic_name_imeasles rubella vaccine
  0(array)
  cnt1
  52(array)
  MedicationProduct(array)
  generic_name_imetformin
  0(array)
  cnt1
  53(array)
  MedicationProduct(array)
  generic_name_iMionate
  0(array)
  cnt1
  54(array)
  MedicationProduct(array)
  generic_name_iN/A
  0(array)
  cnt2
  55(array)
  MedicationProduct(array)
  generic_name_iParacetamol
  0(array)
  cnt1
  56(array)
  MedicationProduct(array)
  generic_name_iSodium Valproate
  0(array)
  cnt3
  57(array)
  MedicationProduct(array)
  generic_name_iSodium Vaproate
  0(array)
  cnt1
  58(array)
  MedicationProduct(array)
  generic_name_iTDF
  0(array)
  cnt4
  59(array)
  MedicationProduct(array)
  generic_name_iTDF+3TC
  0(array)
  cnt1
  60(array)
  MedicationProduct(array)
  generic_name_iTDF+3TC+ABC
  0(array)
  cnt2
  61(array)
  MedicationProduct(array)
  generic_name_iTDF+3TC+DTC+DTG
  0(array)
  cnt1
  62(array)
  MedicationProduct(array)
  generic_name_iTDF+3TC+DTG
  0(array)
  cnt2
  63(array)
  MedicationProduct(array)
  generic_name_iTdf+3tc+dtg+
  0(array)
  cnt1
  64(array)
  MedicationProduct(array)
  generic_name_iTdf,3tc dtg
  0(array)
  cnt1
  65(array)
  MedicationProduct(array)
  generic_name_iTdf,3tc,dtg
  0(array)
  cnt1
  66(array)
  MedicationProduct(array)
  generic_name_iTDF/3TC/DTG
  0(array)
  cnt10
  67(array)
  MedicationProduct(array)
  generic_name_iTenofovir
  0(array)
  cnt4
  68(array)
  MedicationProduct(array)
  generic_name_iTenofovir/Lamivudine/Dolutegravir
  0(array)
  cnt1
  69(array)
  MedicationProduct(array)
  generic_name_iTenovir,lamuvidine dolutegravir
  0(array)
  cnt1
  70(array)
  MedicationProduct(array)
  generic_name_iTLD
  0(array)
  cnt4
  71(array)
  MedicationProduct(array)
  generic_name_iWe
  0(array)
  cnt1
- pe(array)
  0(array)
  MedicationProduct(array)
  product_name_ii
  0(array)
  cnt154
  1(array)
  MedicationProduct(array)
  product_name_ii-
  0(array)
  cnt3
  2(array)
  MedicationProduct(array)
  product_name_ii1
  0(array)
  cnt1
  3(array)
  MedicationProduct(array)
  product_name_iiABC
  0(array)
  cnt1
  4(array)
  MedicationProduct(array)
  product_name_iiAcetominophen
  0(array)
  cnt1
  5(array)
  MedicationProduct(array)
  product_name_iiB2
  0(array)
  cnt1
  6(array)
  MedicationProduct(array)
  product_name_iiBrand II
  0(array)
  cnt3
  7(array)
  MedicationProduct(array)
  product_name_iiBrandx
  0(array)
  cnt1
  8(array)
  MedicationProduct(array)
  product_name_iiChlorzine
  0(array)
  cnt1
  9(array)
  MedicationProduct(array)
  product_name_iiD
  0(array)
  cnt1
  10(array)
  MedicationProduct(array)
  product_name_iiDEC
  0(array)
  cnt1
  11(array)
  MedicationProduct(array)
  product_name_iiEpival
  0(array)
  cnt2
  12(array)
  MedicationProduct(array)
  product_name_iiEpival, Landi Ltd
  0(array)
  cnt1
  13(array)
  MedicationProduct(array)
  product_name_iiEpivir
  0(array)
  cnt1
  14(array)
  MedicationProduct(array)
  product_name_iigold
  0(array)
  cnt1
  15(array)
  MedicationProduct(array)
  product_name_iiLanoxin
  0(array)
  cnt1
  16(array)
  MedicationProduct(array)
  product_name_iiMionate
  0(array)
  cnt4
  17(array)
  MedicationProduct(array)
  product_name_iiMylan
  0(array)
  cnt1
  18(array)
  MedicationProduct(array)
  product_name_iiN/a
  0(array)
  cnt4
  19(array)
  MedicationProduct(array)
  product_name_iiNa
  0(array)
  cnt2
  20(array)
  MedicationProduct(array)
  product_name_iiNon
  0(array)
  cnt1
  21(array)
  MedicationProduct(array)
  product_name_iiNone
  0(array)
  cnt3
  22(array)
  MedicationProduct(array)
  product_name_iiNS
  0(array)
  cnt1
  23(array)
  MedicationProduct(array)
  product_name_iiOo
  0(array)
  cnt1
  24(array)
  MedicationProduct(array)
  product_name_iiTDf
  0(array)
  cnt3
  25(array)
  MedicationProduct(array)
  product_name_iiTDF+3TC
  0(array)
  cnt1
  26(array)
  MedicationProduct(array)
  product_name_iiTdf+3tc+dtg
  0(array)
  cnt2
  27(array)
  MedicationProduct(array)
  product_name_iiTDF+3TC+DTGl
  0(array)
  cnt1
  28(array)
  MedicationProduct(array)
  product_name_iiTDF,3TC,DTG
  0(array)
  cnt1
  29(array)
  MedicationProduct(array)
  product_name_iiTENOFOVIR
  0(array)
  cnt1
  30(array)
  MedicationProduct(array)
  product_name_iiTLD
  0(array)
  cnt2
  31(array)
  MedicationProduct(array)
  product_name_iiVera
  0(array)
  cnt1
  32(array)
  MedicationProduct(array)
  product_name_iiVvb
  0(array)
  cnt1
  33(array)
  MedicationProduct(array)
  product_name_iiZiagen
  0(array)
  cnt1
- pi(array)
  0(array)
  MedicationProduct(array)
  product_name_i
  0(array)
  cnt129
  1(array)
  MedicationProduct(array)
  product_name_i-
  0(array)
  cnt4
  2(array)
  MedicationProduct(array)
  product_name_iAbacavir
  0(array)
  cnt1
  3(array)
  MedicationProduct(array)
  product_name_iABC
  0(array)
  cnt1
  4(array)
  MedicationProduct(array)
  product_name_iABC+3TC+DTG
  0(array)
  cnt4
  5(array)
  MedicationProduct(array)
  product_name_iABC+3TG
  0(array)
  cnt1
  6(array)
  MedicationProduct(array)
  product_name_iABC,3TC,DTG
  0(array)
  cnt1
  7(array)
  MedicationProduct(array)
  product_name_iAbc/3tc/dtg
  0(array)
  cnt1
  8(array)
  MedicationProduct(array)
  product_name_iAcetominophen
  0(array)
  cnt1
  9(array)
  MedicationProduct(array)
  product_name_iAcriptega
  0(array)
  cnt2
  10(array)
  MedicationProduct(array)
  product_name_iAcritega
  0(array)
  cnt1
  11(array)
  MedicationProduct(array)
  product_name_iAlo
  0(array)
  cnt1
  12(array)
  MedicationProduct(array)
  product_name_iArtesunate
  0(array)
  cnt1
  13(array)
  MedicationProduct(array)
  product_name_iB1
  0(array)
  cnt1
  14(array)
  MedicationProduct(array)
  product_name_iBrand I
  0(array)
  cnt3
  15(array)
  MedicationProduct(array)
  product_name_iBrandx
  0(array)
  cnt1
  16(array)
  MedicationProduct(array)
  product_name_iChlor
  0(array)
  cnt1
  17(array)
  MedicationProduct(array)
  product_name_iDiamox
  0(array)
  cnt1
  18(array)
  MedicationProduct(array)
  product_name_iDiethylcarbamazine
  0(array)
  cnt1
  19(array)
  MedicationProduct(array)
  product_name_iDinac
  0(array)
  cnt1
  20(array)
  MedicationProduct(array)
  product_name_iDolte
  0(array)
  cnt1
  21(array)
  MedicationProduct(array)
  product_name_iDTG
  0(array)
  cnt2
  22(array)
  MedicationProduct(array)
  product_name_iDylantin, Tena Ltd
  0(array)
  cnt1
  23(array)
  MedicationProduct(array)
  product_name_iDyzantil
  0(array)
  cnt2
  24(array)
  MedicationProduct(array)
  product_name_iEpival
  0(array)
  cnt1
  25(array)
  MedicationProduct(array)
  product_name_iEpivir
  0(array)
  cnt1
  26(array)
  MedicationProduct(array)
  product_name_iGg
  0(array)
  cnt1
  27(array)
  MedicationProduct(array)
  product_name_iMeme
  0(array)
  cnt1
  28(array)
  MedicationProduct(array)
  product_name_imionate
  0(array)
  cnt15
  29(array)
  MedicationProduct(array)
  product_name_iMylan
  0(array)
  cnt1
  30(array)
  MedicationProduct(array)
  product_name_iN/A
  0(array)
  cnt7
  31(array)
  MedicationProduct(array)
  product_name_iNa
  0(array)
  cnt5
  32(array)
  MedicationProduct(array)
  product_name_iNone
  0(array)
  cnt1
  33(array)
  MedicationProduct(array)
  product_name_iT
  0(array)
  cnt1
  34(array)
  MedicationProduct(array)
  product_name_iTDF
  0(array)
  cnt2
  35(array)
  MedicationProduct(array)
  product_name_iTDF+3TC+DTG
  0(array)
  cnt1
  36(array)
  MedicationProduct(array)
  product_name_iTenofovit
  0(array)
  cnt1
  37(array)
  MedicationProduct(array)
  product_name_iTLD
  0(array)
  cnt4
  38(array)
  MedicationProduct(array)
  product_name_iUnknown
  0(array)
  cnt1
  39(array)
  MedicationProduct(array)
  product_name_iZiagen
  0(array)
  cnt1
- factor(array)
  0(array)
  0(array)
  factorMedication related
  cnt1
  1(array)
  0(array)
  factorN/A
  cnt1
  2(array)
  0(array)
  factorStaff factors
  cnt25
  3(array)
  0(array)
  factorTask and technology
  cnt6
  4(array)
  0(array)
  factorWork and environment
  cnt2
- designation(array)
  0(array)
  Designation(array)
  nameAnaesthetist
  id20
  0(array)
  cnt1
  1(array)
  Designation(array)
  nameBiomedical engineer
  id17
  0(array)
  cnt1
  2(array)
  Designation(array)
  nameClinical officer
  id21
  0(array)
  cnt5
  3(array)
  Designation(array)
  nameLaboratory technologist
  id15
  0(array)
  cnt1
  4(array)
  Designation(array)
  nameMedical officer
  id25
  0(array)
  cnt2
  5(array)
  Designation(array)
  nameNurse
  id8
  0(array)
  cnt2
  6(array)
  Designation(array)
  nameNutritionist
  id16
  0(array)
  cnt5
  7(array)
  Designation(array)
  nameOther Health Care Professional
  id28
  0(array)
  cnt1
  8(array)
  Designation(array)
  namePharmaceutical technologist
  id9
  0(array)
  cnt1
  9(array)
  Designation(array)
  namePharmacist
  id11
  0(array)
  cnt9
  10(array)
  Designation(array)
  namePhysician
  id6
  0(array)
  cnt7
- error(array)
  0(array)
  0(array)
  errorERROR, DEATH
  cnt1
  1(array)
  0(array)
  errorERROR, HARM
  cnt27
  2(array)
  0(array)
  errorERROR, NO HARM
  cnt5
  3(array)
  0(array)
  errorN/A
  cnt1
  4(array)
  0(array)
  errorNO ERROR
  cnt1
- process(array)
  0(array)
  Medication(array)
  process_occurPrescribing
  0(array)
  cnt17
  1(array)
  Medication(array)
  process_occurAdministration
  0(array)
  cnt11
  2(array)
  Medication(array)
  process_occurOthers
  0(array)
  cnt4
  3(array)
  Medication(array)
  process_occurDispensing (includes filling)
  0(array)
  cnt3
- months(array)
  0(array)
  0(array)
  monthJan 2025
  salit1
  cnt7
  1(array)
  0(array)
  monthApr 2024
  salit4
  cnt6
  2(array)
  0(array)
  monthApr 2023
  salit4
  cnt2
  3(array)
  0(array)
  monthMay 2023
  salit5
  cnt4
  4(array)
  0(array)
  monthSep 2023
  salit9
  cnt1
  5(array)
  0(array)
  monthOct 2023
  salit10
  cnt1
  6(array)
  0(array)
  monthOct 2024
  salit10
  cnt1
  7(array)
  0(array)
  monthNov 2024
  salit11
  cnt9
  8(array)
  0(array)
  monthNov 2022
  salit11
  cnt1
  9(array)
  0(array)
  monthDec 2023
  salit12
  cnt3
- facilities(array)
  0(array)
  Medication(array)
  name_of_institutionBaraka county hospital
  0(array)
  cnt11
  1(array)
  Medication(array)
  name_of_institutionMaragua District Hospital
  0(array)
  cnt2
  2(array)
  Medication(array)
  name_of_institutionHeri Medical Center
  0(array)
  cnt2
  3(array)
  Medication(array)
  name_of_institutionbaraka
  0(array)
  cnt1
  4(array)
  Medication(array)
  name_of_institutionMaji Mazuri Dispensary
  0(array)
  cnt1
  5(array)
  Medication(array)
  name_of_institutionGarissa county
  0(array)
  cnt1
  6(array)
  Medication(array)
  name_of_institutioncase1
  0(array)
  cnt1
  7(array)
  Medication(array)
  name_of_institutionBaraka county hosp
  0(array)
  cnt1
  8(array)
  Medication(array)
  name_of_institutionFamily Medical Centre (Kisauni)
  0(array)
  cnt1
  9(array)
  Medication(array)
  name_of_institutionMajomoto
  0(array)
  cnt1
  10(array)
  Medication(array)
  name_of_institutionTimboroa Health Centre
  0(array)
  cnt1
  11(array)
  Medication(array)
  name_of_institutionNew Heri Medical Centre
  0(array)
  cnt1
  12(array)
  Medication(array)
  name_of_institutionBaraka county
  0(array)
  cnt1
  13(array)
  Medication(array)
  name_of_institutionKarura Health Centre(Kiambu Rd)
  0(array)
  cnt1
  14(array)
  Medication(array)
  name_of_institutionBabadogo Health Centre
  0(array)
  cnt1
  15(array)
  Medication(array)
  name_of_institutionMbagathi District Hospital
  0(array)
  cnt1
  16(array)
  Medication(array)
  name_of_institutiongoodwill health centre
  0(array)
  cnt1
  17(array)
  Medication(array)
  name_of_institutionKerugoya County Refferal Hospital
  0(array)
  cnt1
  18(array)
  Medication(array)
  name_of_institutionKisii Campus Dispensary
  0(array)
  cnt1
  19(array)
  Medication(array)
  name_of_institutionChepkemel Health Centre (Kericho)
  0(array)
  cnt1
  20(array)
  Medication(array)
  name_of_institutionPV Hospital
  0(array)
  cnt1
  21(array)
  Medication(array)
  name_of_institutionMaji Moto Dispensary (Narok South)
  0(array)
  cnt1
  22(array)
  Medication(array)
  name_of_institutionHeri Medical Centre
  0(array)
  cnt1
- year(array)
  0(array)
  0(array)
  year2022
  cnt1
  1(array)
  0(array)
  year2023
  cnt11
  2(array)
  0(array)
  year2024
  cnt16
  3(array)
  0(array)
  year2025
  cnt7
- age(array)
  0(array)
  0(array)
  ageradult
  cnt20
  1(array)
  0(array)
  agerchild
  cnt9
  2(array)
  0(array)
  agerinfant
  cnt2
  3(array)
  0(array)
  agerneonate
  cnt2
  4(array)
  0(array)
  agerunknown
  cnt2
- sex(array)
  0(array)
  Medication(array)
  genderFemale
  0(array)
  cnt13
  1(array)
  Medication(array)
  genderMale
  0(array)
  cnt22
- geo(array)
  0(array)
  County(array)
  county_nameBaringo
  id30
  0(array)
  cnt2
  1(array)
  County(array)
  county_nameBungoma
  id39
  0(array)
  cnt14
  2(array)
  County(array)
  county_nameIsiolo
  id11
  0(array)
  cnt3
  3(array)
  County(array)
  county_nameKericho
  id35
  0(array)
  cnt1
  4(array)
  County(array)
  county_nameKisii
  id45
  0(array)
  cnt1
  5(array)
  County(array)
  county_nameMachakos
  id16
  0(array)
  cnt1
  6(array)
  County(array)
  county_nameMombasa
  id1
  0(array)
  cnt1
  7(array)
  County(array)
  county_nameMurang'a
  id21
  0(array)
  cnt1
  8(array)
  County(array)
  county_nameNairobi County
  id47
  0(array)
  cnt8
  9(array)
  County(array)
  county_nameNandi
  id29
  0(array)
  cnt1
  10(array)
  County(array)
  county_nameNarok
  id33
  0(array)
  cnt1
  11(array)
  County(array)
  county_nameNyeri
  id19
  0(array)
  cnt1
- counties(array)
  30Baringo
  36Bomet
  39Bungoma
  40Busia
  28Elgeyo/Marakwet
  14Embu
  7Garissa
  43Homa Bay
  11Isiolo
  34Kajiado
  37Kakamega
  35Kericho
  22Kiambu
  3Kilifi
  20Kirinyaga
  45Kisii
  42Kisumu
  15Kitui
  2Kwale
  31Laikipia
  5Lamu
  16Machakos
  17Makueni
  9Mandera
  10Marsabit
  12Meru
  44Migori
  1Mombasa
  21Murang'a
  47Nairobi County
  32Nakuru
  29Nandi
  33Narok
  46Nyamira
  18Nyandarua
  19Nyeri
  25Samburu
  41Siaya
  6Taita Taveta
  4Tana River
  13Tharaka Nithi
  26Trans Nzoia
  23Turkana
  27Uasin Gishu
  38Vihiga
  8Wajir
  24West Pokot
- is_mobile(false)
- root/
- redirdefault
- $request->data(empty)
- $this->validationErrors(array)
  Permission(empty)
  Aro(empty)
  Aco(empty)
  Sadr(empty)
  Medication(empty)
  County(empty)
  Designation(empty)
  MedicationProduct(empty)
- Loaded Helpers(array)
  0Html
  1Form
  2Session
  3Number
  4SimpleGraph
  5DebugTimer
  6Toolbar
  7Flash
  8HtmlToolbar
====

Message	Memory use
Component initialization	2.53 MB
Controller action start	2.97 MB
Controller render start	4.65 MB
View render complete	5.23 MB

Message	Time in ms	Graph
Core Processing (Derived from $_SERVER["REQUEST_TIME"])	20.85
Event: Controller.initialize	4.50
Event: Controller.startup	0.63
Controller action	44.43
Event: Controller.beforeRender	6.15
» Processing toolbar data	6.01
Rendering View	10.36
» Event: View.beforeRender	0.03
» Rendering APP/View/Reports/upgrade/medications_summary.ctp	1.16
» Rendering APP/View/Reports/upgrade/menu/medications.ctp	7.48
» » Rendering APP/View/Elements/menus/report_public_sidebar.ctp	5.10
» Event: View.afterRender	0.02
» Event: View.beforeLayout	0.02
» Rendering APP/View/Layouts/default.ctp	1.09
Event: View.afterLayout	0.00

Environment

+

App Constants

Constant	Value
CONFIG	'/var/www/pvers/app/Config/'
MEDIA	'/var/www/pvers/app/webroot/media/'
MEDIA_STATIC	'/var/www/pvers/app/webroot/media/static/'
MEDIA_FILTER	'/var/www/pvers/app/webroot/media/filter/'
MEDIA_TRANSFER	'/var/www/pvers/app/webroot/media/transfer/'
MEDIA_UPLOAD_TMP_DIR	'/tmp'
MEDIA_URL	'media/'
MEDIA_STATIC_URL	'media/static/'
MEDIA_FILTER_URL	'media/filter/'
MEDIA_TRANSFER_URL	'media/transfer/'
HTTP_HOST	'45.79.161.190'
HTTP_BASE	'http://45.79.161.190'
HTTP_SELF	'/app/webroot/index.php'
HTTP_URI	'/reports/medications_summary'
CHOWN_PUBLIC	(int) 504
LF	''
NL	''
CR	''
TB	''
BR	' '
WINDOWS	false
FORMAT_DB_DATETIME	'Y-m-d H:i:s'
FORMAT_DB_DATE	'Y-m-d'
FORMAT_DB_TIME	'H:i:s'
DEFAULT_DATETIME	'0000-00-00 00:00:00'
DEFAULT_DATE	'0000-00-00'
DEFAULT_TIME	'00:00:00'
FILES	'/var/www/pvers/app/files/'
LOCALE	'/var/www/pvers/app/locale/'
CLASS_USER	'User'
VALID_ALPHA	'/^[a-zA-Z]+$/'
VALID_ALPHA_UNDERSCORES	'/^[a-zA-Z_]+$/'
VALID_ALPHA_MINUS_UNDERSCORES	'/^[a-zA-Z_-]+$/'
VALID_ALPHA_WHITESPACES	'/^[a-zA-Z ]+$/'
VALID_ALPHANUMERIC_UNDERSCORES	'/^[\da-zA-Z_]+$/'
VALID_ALPHANUMERIC_MINUS_UNDERSCORES	'/^[\da-zA-Z_-]+$/'
VALID_ALPHANUMERIC_WHITESPACES	'/^[\da-zA-Z ]+$/'
VALID_ALPHANUMERIC_WHITESPACES_UNDERSCORES	'/^[\da-zA-Z _]+$/'
VALID_NUMERIC_UNDERSCORES	'/^[\d_]+$/'
VALID_NUMERIC_WHITESPACES	'/^[\d ]+$/'
VALID_NUMERIC_WHITESPACES_UNDERSCORES	'/^[\d _]+$/'
VALID_INTEGERS	'/^[\d]+$/'
FORMAT_NICE_YMDHMS	'd.m.Y, H:i:s'
FORMAT_NICE_YMDHM	'd.m.Y, H:i'
FORMAT_NICE_YM	'm.Y'
FORMAT_NICE_YMD	'd.m.Y'
FORMAT_NICE_MD	'd.m.'
FORMAT_NICE_D	'd'
FORMAT_NICE_W_NUM	'w'
FORMAT_NICE_W_ABBR	'D'
FORMAT_NICE_W_FULL	'l'
FORMAT_NICE_M	'm'
FORMAT_NICE_M_ABBR	'M'
FORMAT_NICE_M_FULL	'F'
FORMAT_NICE_Y_ABBR	'y'
FORMAT_NICE_Y	'Y'
FORMAT_NICE_HM	'H:i'
FORMAT_NICE_HMS	'H:i:s'
FORMAT_LOCAL_WA_YMDHMS	'%a, %d.%m.%Y, %H:%M:%S'
FORMAT_LOCAL_WF_YMDHMS	'%A, %d.%m.%Y, %H:%M:%S'
FORMAT_LOCAL_WA_YMDHM	'%a, %d.%m.%Y, %H:%M'
FORMAT_LOCAL_WF_YMDHM	'%A, %d.%m.%Y, %H:%M'
FORMAT_LOCAL_YMDHMS	'%d.%m.%Y, %H:%M:%S'
FORMAT_LOCAL_YMDHM	'%d.%m.%Y, %H:%M'
FORMAT_LOCAL_YMD	'%d.%m.%Y'
FORMAT_LOCAL_MD	'%d.%m.'
FORMAT_LOCAL_D	'%d'
FORMAT_LOCAL_W_NUM	'%w'
FORMAT_LOCAL_W_ABBR	'%a'
FORMAT_LOCAL_W_FULL	'%A'
FORMAT_LOCAL_M	'%m'
FORMAT_LOCAL_M_ABBR	'%b'
FORMAT_LOCAL_M_FULL	'%B'
FORMAT_LOCAL_Y_ABBR	'%y'
FORMAT_LOCAL_YMS_ABBR	'%d.%m.%y'
FORMAT_LOCAL_Y	'%Y'
FORMAT_LOCAL_H	'%H'
FORMAT_LOCAL_S	'%S'
FORMAT_LOCAL_HM	'%H:%M'
FORMAT_LOCAL_HMS	'%H:%M:%S'
CHAR_LESS	'<'
CHAR_GREATER	'>'
CHAR_QUOTE	'"'
CHAR_APOSTROPHE	'''
CHAR_ARROWS	'»'
CHAR_ARROWS_R	'»'
CHAR_ARROWS_L	'«'
CHAR_AVERAGE	'Ø'
CHAR_INFIN	'∞'
CHAR_MILL	'‰'
CHAR_PLUSMN	'±'
CHAR_HELLIP	'…'
CHAR_CIRCA	'≈'
CHAR_CHECKBOX_EMPTY	'☐]'
CHAR_CHECKBOX_MAKRED	'☑'
CHAR_CHECKMARK	'✓'
CHAR_CHECKMARK_BOLD	'✔'
CHAR_BALLOT	'✗'
CHAR_BALLOT_BOLD	'✘'
CHAR_ABOUT	'≈'
CHAR_RPIME	'′'
CHAR_DOUBLE_RPIME	'″'

CakePHP Constants

Constant	Value
APP	'/var/www/pvers/app/'
APP_DIR	'app'
APPLIBS	'/var/www/pvers/app/Lib/'
CACHE	'/var/www/pvers/app/tmp/cache/'
CAKE	'/var/www/pvers/lib/Cake/'
CAKE_CORE_INCLUDE_PATH	'/var/www/pvers/lib'
CORE_PATH	'/var/www/pvers/lib/'
CAKE_VERSION	'2.10.20'
CSS	'/var/www/pvers/app/webroot/css/'
CSS_URL	'css/'
DS	'/'
FULL_BASE_URL	'http://45.79.161.190'
IMAGES	'/var/www/pvers/app/webroot/img/'
IMAGES_URL	'img/'
JS	'/var/www/pvers/app/webroot/js/'
JS_URL	'js/'
LOGS	'/var/www/pvers/app/tmp/logs/'
ROOT	'/var/www/pvers'
TESTS	'/var/www/pvers/app/Test/'
TMP	'/var/www/pvers/app/tmp/'
VENDORS	'/var/www/pvers/vendors/'
WEBROOT_DIR	'webroot'
WWW_ROOT	'/var/www/pvers/app/webroot/'

PHP Environment

Environment Variable	Value
Php Version	'5.6.40-63+ubuntu18.04.1+deb.sury.org+2'
Redirect Redirect Status	'200'
Redirect Http Authorization	''
Redirect Status	'200'
Http Authorization	''
Http Host	'45.79.161.190'
Http Connection	'keep-alive'
Http Pragma	'no-cache'
Http Cache Control	'no-cache'
Http Upgrade Insecure Requests	'1'
Http User Agent	'Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)'
Http Accept	'text/html,application/xhtml+xml,application/xml;q=0.9,image/avif,image/webp,image/apng,/;q=0.8,application/signed-exchange;v=b3;q=0.7'
Http Accept Encoding	'gzip, deflate'
Path	'/usr/local/sbin:/usr/local/bin:/usr/sbin:/usr/bin:/sbin:/bin:/snap/bin'
Server Signature	' Apache/2.4.29 (Ubuntu) Server at 45.79.161.190 Port 80 '
Server Software	'Apache/2.4.29 (Ubuntu)'
Server Name	'45.79.161.190'
Server Addr	'45.79.161.190'
Server Port	'80'
Remote Addr	'18.222.240.84'
Document Root	'/var/www/pvers'
Request Scheme	'http'
Context Prefix	''
Context Document Root	'/var/www/pvers'
Server Admin	'webmaster@localhost'
Script Filename	'/var/www/pvers/app/webroot/index.php'
Remote Port	'38682'
Redirect Url	'/app/webroot/reports/medications_summary'
Gateway Interface	'CGI/1.1'
Server Protocol	'HTTP/1.1'
Request Method	'GET'
Query String	''
Request Uri	'/reports/medications_summary'
Script Name	'/app/webroot/index.php'
Php Self	'/app/webroot/index.php'
Request Time Float	(float) 1744095273.09
Request Time	(int) 1744095273

====

Include
+
Included Files

Include Paths
- 0/var/www/pvers/app/Plugin/Media/Lib/mm/src
- 1/var/www/pvers/lib
- 3/usr/share/php
- 4-> /var/www/pvers/lib/Cake/
Included Files
- core(array)
  Behavior(array)
  0CORE/Model/Behavior/TreeBehavior.php
  1CORE/Model/Behavior/ContainableBehavior.php
  Cache(array)
  0CORE/Cache/Cache.php
  1CORE/Cache/Engine/FileEngine.php
  2CORE/Cache/CacheEngine.php
  Component(array)
  0CORE/Controller/Component/AclComponent.php
  1CORE/Controller/Component/Acl/DbAcl.php
  2CORE/Controller/Component/Acl/AclInterface.php
  3CORE/Controller/Component/RequestHandlerComponent.php
  4CORE/Controller/Component/SessionComponent.php
  5CORE/Controller/Component/FlashComponent.php
  6CORE/Controller/Component/AuthComponent.php
  7CORE/Controller/Component/Auth/FormAuthenticate.php
  8CORE/Controller/Component/Auth/BaseAuthenticate.php
  Config(array)
  0CORE/Config/routes.php
  1CORE/Config/config.php
  Controller(array)
  0CORE/Controller/Controller.php
  1CORE/Controller/ComponentCollection.php
  2CORE/Controller/Component.php
  Datasource(array)
  0CORE/Model/Datasource/CakeSession.php
  1CORE/Model/Datasource/Database/Mysql.php
  2CORE/Model/Datasource/DboSource.php
  3CORE/Model/Datasource/DataSource.php
  Error(array)
  0CORE/Error/exceptions.php
  1CORE/Error/ErrorHandler.php
  I18n(array)
  0CORE/I18n/I18n.php
  1CORE/I18n/L10n.php
  Log(array)
  0CORE/Log/CakeLog.php
  1CORE/Log/LogEngineCollection.php
  2CORE/Log/Engine/FileLog.php
  3CORE/Log/Engine/BaseLog.php
  4CORE/Log/CakeLogInterface.php
  Model(array)
  0CORE/Model/Permission.php
  1CORE/Model/Model.php
  2CORE/Model/BehaviorCollection.php
  3CORE/Model/Aro.php
  4CORE/Model/AclNode.php
  5CORE/Model/Aco.php
  6CORE/Model/ModelBehavior.php
  7CORE/Model/ConnectionManager.php
  Network(array)
  0CORE/Network/CakeRequest.php
  1CORE/Network/CakeResponse.php
  Other(array)
  0CORE/bootstrap.php
  1CORE/basics.php
  2CORE/Core/App.php
  3CORE/Core/Configure.php
  4CORE/Core/CakePlugin.php
  5CORE/Event/CakeEventListener.php
  6CORE/Event/CakeEvent.php
  7CORE/Event/CakeEventManager.php
  8CORE/Core/CakeObject.php
  Routing(array)
  0CORE/Routing/Dispatcher.php
  1CORE/Routing/Filter/AssetDispatcher.php
  2CORE/Routing/DispatcherFilter.php
  3CORE/Routing/Filter/CacheDispatcher.php
  4CORE/Routing/Router.php
  5CORE/Routing/Route/CakeRoute.php
  6CORE/Routing/Route/PluginShortRoute.php
  Utility(array)
  0CORE/Utility/Hash.php
  1CORE/Utility/Inflector.php
  2CORE/Utility/ObjectCollection.php
  3CORE/Utility/Debugger.php
  4CORE/Utility/CakeText.php
  5CORE/Utility/ClassRegistry.php
  View(array)
  0CORE/View/HelperCollection.php
- app(array)
  Config(array)
  0APP/Config/core.php
  1APP/Config/bootstrap.php
  2APP/Config/routes.php
  3APP/Config/database.php
  Controller(array)
  0APP/Controller/ReportsController.php
  1APP/Controller/AppController.php
  Model(array)
  0APP/Model/AppModel.php
  1APP/Model/Sadr.php
  2APP/Model/Medication.php
  3APP/Model/County.php
  4APP/Model/Designation.php
  5APP/Model/MedicationProduct.php
  Other(array)
  0APP/webroot/index.php
- plugins(array)
  CakePdf(array)
  Config(array)
  0CakePdf/Config/bootstrap.php
  1CakePdf/Config/routes.php
  DebugKit(array)
  Component(array)
  0DebugKit/Controller/Component/ToolbarComponent.php
  Plugin(array)
  0DebugKit/Lib/DebugMemory.php
  1DebugKit/Lib/Panel/HistoryPanel.php
  2DebugKit/Lib/DebugPanel.php
  3DebugKit/Lib/Panel/SessionPanel.php
  4DebugKit/Lib/Panel/RequestPanel.php
  5DebugKit/Lib/Panel/SqlLogPanel.php
  6DebugKit/Lib/Panel/TimerPanel.php
  7DebugKit/Lib/Panel/LogPanel.php
  8DebugKit/Lib/Log/Engine/DebugKitLog.php
  9DebugKit/Lib/Panel/VariablesPanel.php
  10DebugKit/Lib/Panel/EnvironmentPanel.php
  11DebugKit/Lib/Panel/IncludePanel.php
  12DebugKit/Lib/DebugTimer.php
  Media(array)
  Config(array)
  0Media/Config/bootstrap.php
  Plugin(array)
  0Media/Lib/mm/src/Mime/Type.php
  1Media/Lib/mm/src/Mime/Type/Magic/Adapter/Fileinfo.php
  2Media/Lib/mm/src/Mime/Type/Magic/Adapter.php
  3Media/Lib/mm/src/Mime/Type/Glob/Adapter/Memory.php
  4Media/Lib/mm/src/Mime/Type/Glob/Adapter.php
  5Media/Lib/mm/src/Media/Process.php
  6Media/Lib/mm/src/Media/Info.php
  Search(array)
  Component(array)
  0Search/Controller/Component/PrgComponent.php
  Behavior(array)
  0Search/Model/Behavior/SearchableBehavior.php
  Shim(array)
  Config(array)
  0Shim/Config/bootstrap.php
  Tools(array)
  Config(array)
  0Tools/Config/bootstrap.php
====

Geographical Distribution

Gender Distribution

Age Distribution

Medications Errors Per Year

Medications Errors per Month

Product Intended vs Error

Generic Intended vs Error

Request History

Session

Request

Cake Params

Post data

Query string

Cookie

Current Route

Sql Logs

default

Total Time: 20 ms Total Queries: 19 queries

Query Explain:

Memory

Timers

Logs

View Variables

App Constants

CakePHP Constants

PHP Environment

Included Files

Include Paths

Included Files

Total Time: 20 ms
Total Queries: 19 queries