| A | B | C | D | E | F | G | H | I | J | K | L | |
|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | Date | Store ID | Store | State | Country | Region | Product Id | Product Name | Product Category | Product Location | Sales | Cost |
2 | 2001-01-01 12:00 | 15913 | Perundurai | Tamil Nadu | India | Asia | 2 | Cheddar cheese | Dairy | Fridge | 663 | 616 |
3 | 2001-01-01 12:57 | 36723 | Gill | Massachusetts | United States | America | 16 | Honey Almond Flax Cereal | Grain | Pantry | 520 | 488 |
4 | 2001-01-01 13:55 | 7665 | Martigues | Provence-Alpes-Côte-d’Azur | France | Europe | 29 | Rice Pilaf: Roasted Almond Flavor | Grain | Pantry | 517 | 461 |
5 | 2001-01-01 14:38 | 1042 | Alagoinha | Pernambuco | Brazil | America | 26 | Green Bell Peppers | Fruits and Vegetables | Fridge | 181 | 140 |
6 | 2001-01-01 15:50 | 19058 | Rivignano | Friuli–Venezia Giulia | Italy | Europe | 12 | Cinnamon Toast Crunch | Grain | Pantry | 334 | 280 |
7 | 2001-01-01 17:02 | 21258 | Druogno | Piedmont | Italy | Europe | 10 | Peppermint | Staples & Misc. | Pantry | 276 | 203 |
8 | 2001-01-01 17:45 | 2188 | Parkhill | Ontario | Canada | America | 18 | Turkey Breast | Meat | Freezer | 587 | 489 |
9 | 2001-01-01 18:43 | 9930 | Friedland | Brandenburg | Germany | Europe | 1 | Butter | Dairy | Fridge | 717 | 664 |
10 | 2001-01-01 19:40 | 21398 | Marsaglia | Piedmont | Italy | Europe | 21 | Smoked Ham | Meat | Fridge | 641 | 550 |
11 | 2001-01-01 20:24 | 43356 | Marinette | Wisconsin | United States | America | 2 | Cheddar cheese | Dairy | Fridge | 420 | 390 |
12 | 2001-01-01 21:50 | 35937 | Morehead | Kentucky | United States | America | 6 | Sandwich Bread | Pantry | Pantry | 939 | 862 |
13 | 2001-01-01 23:16 | 39492 | Stoneville | North Carolina | United States | America | 9 | Bananas | Fruits and Vegetables | Fridge | 466 | 371 |
14 | 2001-02-01 00:14 | 7947 | Fichtenberg | Baden-Württemberg | Germany | Europe | 9 | Bananas | Fruits and Vegetables | Fridge | 876 | 857 |
15 | 2001-02-01 01:12 | 41022 | Sturgeon | Pennsylvania | United States | America | 30 | Whole Wheat Penne Pasta | Grain | Pantry | 539 | 501 |
16 | 2001-02-01 02:38 | 38018 | Lexington | Nebraska | United States | America | 24 | Beets | Fruits and Vegetables | Fridge | 450 | 410 |
17 | 2001-02-01 03:50 | 20312 | Nicorvo | Lombardy | Italy | Europe | 16 | Honey Almond Flax Cereal | Grain | Pantry | 448 | 386 |
18 | 2001-02-01 05:16 | 23344 | Mure | Veneto | Italy | Europe | 23 | Pinto Beans | Fruits and Vegetables | Pantry | 684 | 594 |
19 | 2001-02-01 06:28 | 33463 | Nipomo | California | United States | America | 4 | Vanilla Yogurt | Dairy | Fridge | 523 | 460 |
20 | 2001-02-01 07:40 | 5901 | Rousies | Hauts-de-France | France | Europe | 20 | Bologna | Meat | Fridge | 531 | 440 |
21 | 2001-02-01 09:07 | 30729 | Langho | England | United Kingdom | Europe | 21 | Smoked Ham | Meat | Fridge | 945 | 922 |
22 | 2001-02-01 10:19 | 41576 | Fairview | Tennessee | United States | America | 11 | Whole Wheat English Muffin | Grain | Pantry | 349 | 292 |
23 | 2001-02-01 11:45 | 20247 | Mezzago | Lombardy | Italy | Europe | 29 | Rice Pilaf: Roasted Almond Flavor | Grain | Pantry | 985 | 956 |
24 | 2001-02-01 13:12 | 37655 | Buckner | Missouri | United States | America | 19 | Raisin Bran Cereal | Grain | Pantry | 429 | 372 |
25 | 2001-02-01 14:24 | 9553 | Stadtprozelten | Bavaria | Germany | Europe | 25 | Sweet Peas | Fruits and Vegetables | Fridge | 528 | 433 |
26 | 2001-02-01 15:50 | 20305 | Navedano | Lombardy | Italy | Europe | 7 | Vinegar | Staples & Misc. | Pantry | 586 | 573 |
27 | 2001-02-01 16:48 | 27229 | Krivyanskaya | Rostov Oblast | Russia | Asia | 14 | Chicken Breast | Meat | Fridge | 680 | 662 |
28 | 2001-02-01 17:45 | 13619 | Vagator | Goa | India | Asia | 19 | Raisin Bran Cereal | Grain | Pantry | 778 | 754 |
29 | 2001-02-01 18:28 | 3414 | Bangjun | Tianjin | China | Asia | 21 | Smoked Ham | Meat | Fridge | 292 | 219 |
30 | 2001-02-01 19:40 | 12570 | Wallhausen | Saxony-Anhalt | Germany | Europe | 13 | Olive Oil | Staples & Misc. | Pantry | 756 | 672 |
31 | 2001-02-01 21:07 | 38421 | Lawrenceville | New Jersey | United States | America | 30 | Whole Wheat Penne Pasta | Grain | Pantry | 784 | 759 |
32 | 2001-02-01 22:19 | 27646 | Golynki | Smolensk Oblast | Russia | Asia | 32 | Peanut Butter | Staples & Misc. | Pantry | 299 | 270 |
33 | 2001-02-01 23:45 | 35660 | Cherryvale | Kansas | United States | America | 16 | Honey Almond Flax Cereal | Grain | Pantry | 858 | 819 |
34 | 2001-03-01 00:28 | 31716 | Wormley | England | United Kingdom | Europe | 31 | Macaroni & Cheese | Grain | Pantry | 624 | 573 |
35 | 2001-03-01 01:12 | 15636 | Pushkar | Rajasthan | India | Asia | 3 | Milk | Dairy | Fridge | 822 | 757 |
36 | 2001-03-01 02:24 | 40711 | Hawley | Pennsylvania | United States | America | 24 | Beets | Fruits and Vegetables | Fridge | 445 | 403 |
37 | 2001-03-01 03:50 | 9376 | Putzbrunn | Bavaria | Germany | Europe | 26 | Green Bell Peppers | Fruits and Vegetables | Fridge | 234 | 220 |
38 | 2001-03-01 05:02 | 440 | Mirador | Maranhão | Brazil | America | 2 | Cheddar cheese | Dairy | Fridge | 414 | 366 |
39 | 2001-03-01 06:14 | 13437 | Koelwar | Bihar | India | Asia | 15 | Tomato Soup | Staples & Misc. | Pantry | 767 | 736 |
40 | 2001-03-01 07:26 | 6352 | Domfront | Normandie | France | Europe | 31 | Macaroni & Cheese | Grain | Pantry | 119 | 74 |
41 | 2001-03-01 08:52 | 7709 | Reillanne | Provence-Alpes-Côte-d’Azur | France | Europe | 2 | Cheddar cheese | Dairy | Fridge | 232 | 214 |
42 | 2001-03-01 09:50 | 38600 | Chimayo | New Mexico | United States | America | 12 | Cinnamon Toast Crunch | Grain | Pantry | 461 | 394 |
43 | 2001-03-01 10:48 | 24476 | Fillan | Trøndelag | Norway | Europe | 23 | Pinto Beans | Fruits and Vegetables | Pantry | 550 | 528 |
44 | 2001-03-01 12:00 | 17776 | Toritto | Apulia | Italy | Europe | 29 | Rice Pilaf: Roasted Almond Flavor | Grain | Pantry | 743 | 656 |
45 | 2001-03-01 13:12 | 17127 | Trucuk | Jawa Tengah | Indonesia | Asia | 24 | Beets | Fruits and Vegetables | Fridge | 14 | -58 |
46 | 2001-03-01 14:24 | 34393 | Hawkinsville | Georgia | United States | America | 15 | Tomato Soup | Staples & Misc. | Pantry | 565 | 482 |
47 | 2001-03-01 15:07 | 32423 | Leeswood | Wales | United Kingdom | Europe | 32 | Peanut Butter | Staples & Misc. | Pantry | 922 | 877 |
48 | 2001-03-01 16:04 | 31053 | Pitstone | England | United Kingdom | Europe | 26 | Green Bell Peppers | Fruits and Vegetables | Fridge | 674 | 622 |
49 | 2001-03-01 17:02 | 323 | Umirim | Ceará | Brazil | America | 21 | Smoked Ham | Meat | Fridge | 270 | 172 |
50 | 2001-03-01 17:45 | 35928 | Massac | Kentucky | United States | America | 34 | Broccoli Florets | Fruits and Vegetables | Fridge | 111 | 28 |
51 | 2001-03-01 18:57 | 20896 | Bojano | Molise | Italy | Europe | 3 | Milk | Dairy | Fridge | 10 | -50 |
52 | 2001-03-01 19:55 | 36051 | Coushatta | Louisiana | United States | America | 11 | Whole Wheat English Muffin | Grain | Pantry | 387 | 363 |
53 | 2001-03-01 20:38 | 30345 | Flimby | England | United Kingdom | Europe | 14 | Chicken Breast | Meat | Fridge | 359 | 324 |
54 | 2001-03-01 21:21 | 6317 | Buchy | Normandie | France | Europe | 12 | Cinnamon Toast Crunch | Grain | Pantry | 102 | 50 |
55 | 2001-03-01 22:19 | 41979 | Groves | Texas | United States | America | 28 | Oats ‘N Honey Crunchy Granola Bars | Snack | Pantry | 359 | 332 |
56 | 2001-03-01 23:45 | 41598 | Harrogate | Tennessee | United States | America | 8 | Horseradish | Staples & Misc. | Pantry | 829 | 789 |
57 | 2001-04-01 00:28 | 1235 | Serrinha | Rio Grande do Norte | Brazil | America | 33 | Green Beans | Fruits and Vegetables | Fridge | 637 | 585 |
58 | 2001-04-01 01:40 | 4334 | Nolay | Bourgogne-Franche-Comté | France | Europe | 7 | Vinegar | Staples & Misc. | Pantry | 615 | 550 |
59 | 2001-04-01 02:38 | 15607 | Mundwa | Rajasthan | India | Asia | 20 | Bologna | Meat | Fridge | 751 | 707 |
60 | 2001-04-01 04:04 | 6323 | Cahagnes | Normandie | France | Europe | 13 | Olive Oil | Staples & Misc. | Pantry | 334 | 318 |
61 | 2001-04-01 04:48 | 36330 | Limington | Maine | United States | America | 19 | Raisin Bran Cereal | Grain | Pantry | 620 | 599 |
62 | 2001-04-01 06:00 | 4086 | Sillingy | Auvergne-Rhône-Alpes | France | Europe | 25 | Sweet Peas | Fruits and Vegetables | Fridge | 448 | 373 |
63 | 2001-04-01 06:43 | 18107 | Petrizzi | Calabria | Italy | Europe | 24 | Beets | Fruits and Vegetables | Fridge | 40 | 2 |
64 | 2001-04-01 07:55 | 9039 | Kolbermoor | Bavaria | Germany | Europe | 21 | Smoked Ham | Meat | Fridge | 283 | 186 |
65 | 2001-04-01 08:52 | 29928 | Camblesforth | England | United Kingdom | Europe | 33 | Green Beans | Fruits and Vegetables | Fridge | 508 | 490 |
66 | 2001-04-01 10:19 | 11513 | Dalheim | Rhineland-Palatinate | Germany | Europe | 13 | Olive Oil | Staples & Misc. | Pantry | 383 | 326 |
67 | 2001-04-01 11:16 | 28367 | Makkaveyevo | Zabaykalsky Krai | Russia | Asia | 25 | Sweet Peas | Fruits and Vegetables | Fridge | 556 | 537 |
68 | 2001-04-01 12:14 | 33627 | Walnut | California | United States | America | 1 | Butter | Dairy | Fridge | 560 | 487 |
69 | 2001-04-01 13:40 | 9751 | Wessobrunn | Bavaria | Germany | Europe | 4 | Vanilla Yogurt | Dairy | Fridge | 691 | 601 |
70 | 2001-04-01 14:38 | 40477 | Bellwood | Pennsylvania | United States | America | 6 | Sandwich Bread | Pantry | Pantry | 317 | 279 |
71 | 2001-04-01 15:36 | 5961 | Verton | Hauts-de-France | France | Europe | 21 | Smoked Ham | Meat | Fridge | 883 | 857 |
72 | 2001-04-01 16:33 | 7494 | Nesmy | Pays-de-la-Loire | France | Europe | 3 | Milk | Dairy | Fridge | 637 | 604 |
73 | 2001-04-01 17:16 | 9333 | Pfeffenhausen | Bavaria | Germany | Europe | 23 | Pinto Beans | Fruits and Vegetables | Pantry | 697 | 676 |
74 | 2001-04-01 18:14 | 11603 | Harxheim | Rhineland-Palatinate | Germany | Europe | 30 | Whole Wheat Penne Pasta | Grain | Pantry | 201 | 148 |
75 | 2001-04-01 19:40 | 30485 | Harwell | England | United Kingdom | Europe | 4 | Vanilla Yogurt | Dairy | Fridge | 224 | 206 |
76 | 2001-04-01 21:07 | 1505 | Americana | São Paulo | Brazil | America | 32 | Peanut Butter | Staples & Misc. | Pantry | 236 | 192 |
77 | 2001-04-01 22:33 | 33702 | Edgewater | Colorado | United States | America | 6 | Sandwich Bread | Pantry | Pantry | 773 | 692 |
78 | 2001-04-01 23:31 | 35450 | Avoca | Iowa | United States | America | 12 | Cinnamon Toast Crunch | Grain | Pantry | 924 | 909 |
79 | 2001-05-01 00:28 | 39781 | Glendale | Ohio | United States | America | 20 | Bologna | Meat | Fridge | 30 | -4 |
80 | 2001-05-01 01:40 | 35983 | Taylorsville | Kentucky | United States | America | 28 | Oats ‘N Honey Crunchy Granola Bars | Snack | Pantry | 888 | 870 |
81 | 2001-05-01 02:24 | 2159 | Madoc | Ontario | Canada | America | 25 | Sweet Peas | Fruits and Vegetables | Fridge | 121 | 58 |
82 | 2001-05-01 03:50 | 9898 | Bensdorf | Brandenburg | Germany | Europe | 8 | Horseradish | Staples & Misc. | Pantry | 470 | 405 |
83 | 2001-05-01 05:16 | 32489 | Pontlliw | Wales | United Kingdom | Europe | 4 | Vanilla Yogurt | Dairy | Fridge | 966 | 879 |
84 | 2001-05-01 06:28 | 4321 | Montenois | Bourgogne-Franche-Comté | France | Europe | 30 | Whole Wheat Penne Pasta | Grain | Pantry | 10 | -33 |
85 | 2001-05-01 07:26 | 1681 | Piacatu | São Paulo | Brazil | America | 11 | Whole Wheat English Muffin | Grain | Pantry | 207 | 149 |
86 | 2001-05-01 08:38 | 6402 | Martinvast | Normandie | France | Europe | 3 | Milk | Dairy | Fridge | 853 | 765 |
87 | 2001-05-01 09:36 | 7798 | Asperg | Baden-Württemberg | Germany | Europe | 23 | Pinto Beans | Fruits and Vegetables | Pantry | 172 | 105 |
88 | 2001-05-01 11:02 | 37233 | Becker | Minnesota | United States | America | 34 | Broccoli Florets | Fruits and Vegetables | Fridge | 556 | 468 |
89 | 2001-05-01 12:28 | 41472 | McIntosh | South Dakota | United States | America | 23 | Pinto Beans | Fruits and Vegetables | Pantry | 343 | 303 |
90 | 2001-05-01 13:12 | 8861 | Grub | Bavaria | Germany | Europe | 21 | Smoked Ham | Meat | Fridge | 222 | 125 |
91 | 2001-05-01 14:38 | 17219 | Banjarmasin | Kalimantan Selatan | Indonesia | Asia | 31 | Macaroni & Cheese | Grain | Pantry | 984 | 943 |
92 | 2001-05-01 15:50 | 12609 | Appen | Schleswig-Holstein | Germany | Europe | 15 | Tomato Soup | Staples & Misc. | Pantry | 427 | 407 |
93 | 2001-05-01 16:48 | 28909 | Rue | Fribourg | Switzerland | Europe | 33 | Green Beans | Fruits and Vegetables | Fridge | 812 | 732 |
94 | 2001-05-01 18:00 | 40150 | Healdton | Oklahoma | United States | America | 21 | Smoked Ham | Meat | Fridge | 684 | 597 |
95 | 2001-05-01 18:57 | 16554 | Pilkhuwa | Uttar Pradesh | India | Asia | 21 | Smoked Ham | Meat | Fridge | 552 | 482 |
96 | 2001-05-01 19:40 | 5472 | Wissembourg | Grand-Est | France | Europe | 13 | Olive Oil | Staples & Misc. | Pantry | 122 | 27 |
97 | 2001-05-01 20:24 | 14755 | Akalkot | Maharashtra | India | Asia | 9 | Bananas | Fruits and Vegetables | Fridge | 459 | 380 |
98 | 2001-05-01 21:36 | 32806 | Ester | Alaska | United States | America | 15 | Tomato Soup | Staples & Misc. | Pantry | 785 | 705 |
99 | 2001-05-01 22:19 | 38830 | Endicott | New York | United States | America | 33 | Green Beans | Fruits and Vegetables | Fridge | 85 | 24 |
100 | 2001-05-01 23:45 | 39965 | Rosemount | Ohio | United States | America | 6 | Sandwich Bread | Pantry | Pantry | 636 | 612 |