Supermarket Project 2023_B
DDI-KEN-APHRC-SUPERMARKET-B-2023-V1.0
African Population and Health Research Center
2025-07-01
Nesstar Publisher
Version 1.0 (July 2025)
Analysis of Supermarket Grocery Data for Prediction of Nutritional and Health Outcomes at the Population Level - Supermarket B
Not Applicable
DDI-KEN-APHRC-SUPERMARKET-B-2023-V1.0
Agnes Kiragga
Bonface Ingumba
Mambe Shem
Steve Cygu
Maureen Ng’etich
Lindsey English
Reinpeter Momanyi
Elizabeth Kimani
Gershim Asiki
Copyright © APHRC, 2025
Nesstar Publisher
African Populattion and Health Research Center
Demographic and Health Survey [hh/dhs]
Not Applicable
Supermarkets
Ultra-Processed Foods
Processed Foods
Non-communicable Chronic Diseases
Kenya
National coverage: Kiambu, Nyeri, Embu, Murang'a and Nairobi Counties
Individuals and supermarket transaction records.
The survey covers transaction records of individuals who made purchases in supermarkets.
- Transaction Level Data: Food Item Details (Specific products purchased), Quantity, Price, Date of Purchase, Location of Purchase, Customer Demographics (age, gender when collected via loyalty programs), Payment Method( Cash, credit card, digital payment, etc. ), Basket Composition
Not Applicable
Other [oth]
Not Applicable
Not Applicable
Not Applicable
Not Applicable
Not Applicable
African Population and Health Research Center
The user of the data acknowledges that the original collector of the data, the authorized distributor of the data, and the relevant funding agency bear no responsibility for use of the data or for interpretations or inferences based upon such uses.
clean_supermarket_b_sample.NSDstat
1071760
18
Nesstar 200801
Study abstraction
Shopper id
Individuals and supermarket transaction records.
N/A
Shopper id
N/A
N/A
Individuals and supermarket transaction records.
281722
0
This question seeks to get generated ID for the shopper
County acronym
Individuals and supermarket transaction records.
N/A
County acronym
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
This question seeks to get generated County acronym
EMBU
289181
KARATINA
140241
KIAMBU
179040
MURANGA
139828
NRB
202374
NYERI
121096
Gender
Individuals and supermarket transaction records.
N/A
Gender
N/A
N/A
Individuals and supermarket transaction records.
281722
0
This question seeks to get the Gender of the shopper
Female
168769
Male
112953
Product name description
Individuals and supermarket transaction records.
N/A
Product name description
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
This question seeks to get the Product name description of the item the shopper bought.
Unit price of product
Individuals and supermarket transaction records.
N/A
Unit price of product
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
0
10250
124.751
146.294
This question seeks to get the Unit price of product the shopper bought.
Quantity of product purchased
Individuals and supermarket transaction records.
N/A
Quantity of product purchased
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
-50
5600
1.475
6.387
This question seeks to get the Quantity of product purchased by the shopper .
Sales invoice total price
Individuals and supermarket transaction records.
N/A
Sales invoice total price
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
-30839
490038
1134.33
2210.278
This question seeks to get the Sales invoice total price.
Transaction id
Individuals and supermarket transaction records.
N/A
Transaction id
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
29
10162240
5165646.623
2936301.942
This question seeks to get the Transaction id.
Transaction date
Individuals and supermarket transaction records.
N/A
Transaction date
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
1969519120000
2019678115000
1996994337711.43
13661641546.103
This question seeks to get the Transaction date.
Payment mode
Individuals and supermarket transaction records.
N/A
Payment mode
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
This question seeks to get the Payment mode.
Cash
854302
Cheque
12
Credit Card
5963
Credit Note
579
Direct Banking
1162
EFT
13420
LIPA NA MPESA
2663
MPESA
192679
Store Account
490
Voucher
490
Branch id of supermarket
Individuals and supermarket transaction records.
N/A
Branch id of supermarket
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
This question seeks to get the generated Branch id of the supermarket.
002_003
63093
002_004
97038
002_005
139828
002_006
140241
002_007
202374
002_008
61226
002_009
129441
002_010
52023
002_011
24058
002_012
63924
002_013
98514
Supermarket branch transaction id
Individuals and supermarket transaction records.
N/A
Supermarket branch transaction id
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
This question seeks to get the generated Supermarket branch transaction id.
Date of birth of shopper
Individuals and supermarket transaction records.
N/A
Date of birth of shopper
N/A
N/A
Individuals and supermarket transaction records.
217991
1906-11-01
2005-12-12
This question seeks to get the Date of birth of the shopper.
Supermarket name
Individuals and supermarket transaction records.
N/A
Supermarket name
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
This question seeks to get the Supermarket name.
B
1071760
Branch name of supermarket
Individuals and supermarket transaction records.
N/A
Branch name of supermarket
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
B1
63093
B10
63924
B11
98514
B2
97038
B3
139828
B4
140241
B5
202374
B6
61226
B7
129441
B8
52023
B9
24058
County
Individuals and supermarket transaction records.
N/A
County
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
This question seeks to get the County where the supermarket is lcated.
Embu
289181
Kiambu
179040
Murang'a
139828
Nairobi
202374
Nyeri
261337
Sub-county
Individuals and supermarket transaction records.
N/A
Sub-county
N/A
N/A
Individuals and supermarket transaction records.
1071760
0
This question seeks to get the Sub-county where the supermarket is lcated.
Embu West
289181
Mathira East
140241
Murang'a East
139828
Nyeri Central
121096
Starehe
202374
Thika West
179040
Age of shopper
Individuals and supermarket transaction records.
N/A
Age of shopper
N/A
N/A
Individuals and supermarket transaction records.
217991
853769
18
117
40.728
11.994
This question seeks to get the Age of shopper.