| 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 | 24023 | Toyoshina | Nagano Prefecture | Japan | Asia | 1 | Butter | Dairy | Fridge | 845 | 753 |
3 | 2001-01-01 13:12 | 67 | Silves | Amazonas | Brazil | America | 20 | Bologna | Meat | Fridge | 848 | 753 |
4 | 2001-01-01 13:55 | 21849 | Alghero | Sardinia | Italy | Europe | 19 | Raisin Bran Cereal | Grain | Pantry | 822 | 777 |
5 | 2001-01-01 14:38 | 38951 | Levittown | New York | United States | America | 20 | Bologna | Meat | Fridge | 39 | 27 |
6 | 2001-01-01 15:36 | 17041 | Pasarkemis | Jawa Barat | Indonesia | Asia | 11 | Whole Wheat English Muffin | Grain | Pantry | 972 | 942 |
7 | 2001-01-01 16:48 | 15507 | Aklera | Rajasthan | India | Asia | 3 | Milk | Dairy | Fridge | 630 | 557 |
8 | 2001-01-01 17:45 | 3080 | YangZhou | Jiangsu | China | Asia | 1 | Butter | Dairy | Fridge | 173 | 91 |
9 | 2001-01-01 18:28 | 40482 | Berwyn | Pennsylvania | United States | America | 14 | Chicken Breast | Meat | Fridge | 647 | 580 |
10 | 2001-01-01 19:12 | 34283 | Barnesville | Georgia | United States | America | 13 | Olive Oil | Staples & Misc. | Pantry | 84 | 31 |
11 | 2001-01-01 20:24 | 18397 | Luzzano | Campania | Italy | Europe | 18 | Turkey Breast | Meat | Freezer | 848 | 836 |
12 | 2001-01-01 21:36 | 858 | Cajazeirinhas | ParaÃba | Brazil | America | 9 | Bananas | Fruits and Vegetables | Fridge | 711 | 631 |
13 | 2001-01-01 22:48 | 35683 | Eureka | Kansas | United States | America | 27 | Dark Chocolate Bar | Sweets | Pantry | 448 | 404 |
14 | 2001-02-01 00:14 | 40260 | Tonkawa | Oklahoma | United States | America | 16 | Honey Almond Flax Cereal | Grain | Pantry | 266 | 210 |
15 | 2001-02-01 00:57 | 32663 | Hartselle | Alabama | United States | America | 6 | Sandwich Bread | Pantry | Pantry | 498 | 428 |
16 | 2001-02-01 02:09 | 6697 | Idron | Nouvelle-Aquitaine | France | Europe | 7 | Vinegar | Staples & Misc. | Pantry | 973 | 880 |
17 | 2001-02-01 03:36 | 5 | Arapiraca | Alagoas | Brazil | America | 10 | Peppermint | Staples & Misc. | Pantry | 226 | 161 |
18 | 2001-02-01 04:19 | 4832 | Ormes | Centre-Val de Loire | France | Europe | 25 | Sweet Peas | Fruits and Vegetables | Fridge | 825 | 732 |
19 | 2001-02-01 05:31 | 32575 | Blountsville | Alabama | United States | America | 10 | Peppermint | Staples & Misc. | Pantry | 533 | 444 |
20 | 2001-02-01 06:57 | 21946 | Gesturi | Sardinia | Italy | Europe | 31 | Macaroni & Cheese | Grain | Pantry | 779 | 718 |
21 | 2001-02-01 08:24 | 23197 | Cibiana | Veneto | Italy | Europe | 32 | Peanut Butter | Staples & Misc. | Pantry | 311 | 283 |
22 | 2001-02-01 09:36 | 16687 | Bazpur | Uttarakhand | India | Asia | 17 | Three Cheese Tortellini | Grain | Freezer | 295 | 271 |
23 | 2001-02-01 10:33 | 25559 | Agoy | Krasnodar Krai | Russia | Asia | 6 | Sandwich Bread | Pantry | Pantry | 673 | 576 |
24 | 2001-02-01 12:00 | 11901 | Unkel | Rhineland-Palatinate | Germany | Europe | 31 | Macaroni & Cheese | Grain | Pantry | 967 | 902 |
25 | 2001-02-01 12:43 | 28248 | Bobrov | Voronezh Oblast | Russia | Asia | 19 | Raisin Bran Cereal | Grain | Pantry | 223 | 143 |
26 | 2001-02-01 13:40 | 13679 | Delvada | Gujarat | India | Asia | 33 | Green Beans | Fruits and Vegetables | Fridge | 358 | 287 |
27 | 2001-02-01 14:24 | 28778 | Erlach | Bern | Switzerland | Europe | 8 | Horseradish | Staples & Misc. | Pantry | 712 | 636 |
28 | 2001-02-01 15:21 | 4962 | Bergholtz | Grand-Est | France | Europe | 10 | Peppermint | Staples & Misc. | Pantry | 730 | 679 |
29 | 2001-02-01 16:33 | 38214 | Nashua | New Hampshire | United States | America | 9 | Bananas | Fruits and Vegetables | Fridge | 634 | 577 |
30 | 2001-02-01 18:00 | 35895 | Hodgenville | Kentucky | United States | America | 13 | Olive Oil | Staples & Misc. | Pantry | 156 | 142 |
31 | 2001-02-01 19:12 | 31596 | Westcott | England | United Kingdom | Europe | 11 | Whole Wheat English Muffin | Grain | Pantry | 222 | 209 |
32 | 2001-02-01 20:38 | 21686 | Serole | Piedmont | Italy | Europe | 13 | Olive Oil | Staples & Misc. | Pantry | 412 | 349 |
33 | 2001-02-01 21:50 | 28177 | Kotelnikovo | Volgograd Oblast | Russia | Asia | 16 | Honey Almond Flax Cereal | Grain | Pantry | 760 | 716 |
34 | 2001-02-01 22:48 | 11040 | Rambin | Mecklenburg-Vorpommern | Germany | Europe | 9 | Bananas | Fruits and Vegetables | Fridge | 975 | 964 |
35 | 2001-03-01 00:00 | 41716 | Wildwood | Tennessee | United States | America | 2 | Cheddar cheese | Dairy | Fridge | 602 | 550 |
36 | 2001-03-01 01:12 | 3341 | Luzhou | Sichuan | China | Asia | 34 | Broccoli Florets | Fruits and Vegetables | Fridge | 569 | 486 |
37 | 2001-03-01 02:38 | 8200 | Oberboihingen | Baden-Württemberg | Germany | Europe | 24 | Beets | Fruits and Vegetables | Fridge | 361 | 323 |
38 | 2001-03-01 04:04 | 886 | Lastro | ParaÃba | Brazil | America | 26 | Green Bell Peppers | Fruits and Vegetables | Fridge | 679 | 624 |
39 | 2001-03-01 05:31 | 9664 | Vachendorf | Bavaria | Germany | Europe | 24 | Beets | Fruits and Vegetables | Fridge | 96 | 67 |
40 | 2001-03-01 06:28 | 9457 | Sachsenkam | Bavaria | Germany | Europe | 18 | Turkey Breast | Meat | Freezer | 426 | 330 |
41 | 2001-03-01 07:12 | 41439 | Britton | South Dakota | United States | America | 30 | Whole Wheat Penne Pasta | Grain | Pantry | 816 | 779 |
42 | 2001-03-01 08:38 | 41915 | Elmendorf | Texas | United States | America | 19 | Raisin Bran Cereal | Grain | Pantry | 957 | 907 |
43 | 2001-03-01 10:04 | 33132 | Arvin | California | United States | America | 34 | Broccoli Florets | Fruits and Vegetables | Fridge | 95 | 67 |
44 | 2001-03-01 10:48 | 15859 | Nagapattinam | Tamil Nadu | India | Asia | 25 | Sweet Peas | Fruits and Vegetables | Fridge | 920 | 853 |
45 | 2001-03-01 11:31 | 22153 | Villacidro | Sardinia | Italy | Europe | 28 | Oats ‘N Honey Crunchy Granola Bars | Snack | Pantry | 742 | 676 |
46 | 2001-03-01 12:28 | 36627 | Acushnet | Massachusetts | United States | America | 1 | Butter | Dairy | Fridge | 261 | 209 |
47 | 2001-03-01 13:40 | 17418 | Gamberale | Abruzzo | Italy | Europe | 16 | Honey Almond Flax Cereal | Grain | Pantry | 813 | 772 |
48 | 2001-03-01 14:52 | 20383 | Piadena | Lombardy | Italy | Europe | 15 | Tomato Soup | Staples & Misc. | Pantry | 426 | 416 |
49 | 2001-03-01 15:50 | 3622 | Ambert | Auvergne-Rhône-Alpes | France | Europe | 23 | Pinto Beans | Fruits and Vegetables | Pantry | 419 | 343 |
50 | 2001-03-01 16:33 | 24015 | Matsumoto | Nagano Prefecture | Japan | Asia | 27 | Dark Chocolate Bar | Sweets | Pantry | 202 | 185 |
51 | 2001-03-01 17:31 | 3198 | Delingha | Qinghai | China | Asia | 7 | Vinegar | Staples & Misc. | Pantry | 795 | 722 |
52 | 2001-03-01 18:28 | 21458 | Montemarzino | Piedmont | Italy | Europe | 23 | Pinto Beans | Fruits and Vegetables | Pantry | 408 | 395 |
53 | 2001-03-01 19:26 | 19746 | Bulgarograsso | Lombardy | Italy | Europe | 2 | Cheddar cheese | Dairy | Fridge | 366 | 348 |
54 | 2001-03-01 20:38 | 13655 | Bhildi | Gujarat | India | Asia | 7 | Vinegar | Staples & Misc. | Pantry | 306 | 265 |
55 | 2001-03-01 21:50 | 7761 | Villeneuve | Provence-Alpes-Côte-d’Azur | France | Europe | 20 | Bologna | Meat | Fridge | 100 | 50 |
56 | 2001-03-01 22:33 | 40600 | Dravosburg | Pennsylvania | United States | America | 12 | Cinnamon Toast Crunch | Grain | Pantry | 629 | 615 |
57 | 2001-03-01 23:16 | 41130 | Bajadero | Puerto Rico | United States | America | 26 | Green Bell Peppers | Fruits and Vegetables | Fridge | 28 | 14 |
58 | 2001-04-01 00:43 | 20395 | Pieve | Lombardy | Italy | Europe | 2 | Cheddar cheese | Dairy | Fridge | 354 | 288 |
59 | 2001-04-01 01:26 | 35071 | Roxana | Illinois | United States | America | 7 | Vinegar | Staples & Misc. | Pantry | 579 | 559 |
60 | 2001-04-01 02:38 | 14899 | Girgaon | Maharashtra | India | Asia | 8 | Horseradish | Staples & Misc. | Pantry | 940 | 883 |
61 | 2001-04-01 03:21 | 27280 | Volgodonsk | Rostov Oblast | Russia | Asia | 3 | Milk | Dairy | Fridge | 155 | 85 |
62 | 2001-04-01 04:33 | 23849 | Yokohama | Kanagawa Prefecture | Japan | Asia | 22 | Apple Juice | Beverages | Fridge | 747 | 721 |
63 | 2001-04-01 06:00 | 16601 | Salempur | Uttar Pradesh | India | Asia | 15 | Tomato Soup | Staples & Misc. | Pantry | 685 | 623 |
64 | 2001-04-01 06:57 | 5036 | Darney | Grand-Est | France | Europe | 9 | Bananas | Fruits and Vegetables | Fridge | 267 | 195 |
65 | 2001-04-01 08:09 | 27882 | Morshansk | Tambov Oblast | Russia | Asia | 5 | Chocolate Ice Cream | Sweets | Freezer | 192 | 145 |
66 | 2001-04-01 09:21 | 41927 | Falfurrias | Texas | United States | America | 1 | Butter | Dairy | Fridge | 299 | 225 |
67 | 2001-04-01 10:19 | 27251 | Persianovka | Rostov Oblast | Russia | Asia | 17 | Three Cheese Tortellini | Grain | Freezer | 406 | 352 |
68 | 2001-04-01 11:45 | 6034 | Brunoy | ÃŽle-de-France | France | Europe | 21 | Smoked Ham | Meat | Fridge | 299 | 221 |
69 | 2001-04-01 12:28 | 34056 | Gibsonia | Florida | United States | America | 6 | Sandwich Bread | Pantry | Pantry | 254 | 222 |
70 | 2001-04-01 13:40 | 166 | Jaguaripe | Bahia | Brazil | America | 33 | Green Beans | Fruits and Vegetables | Fridge | 23 | -2 |
71 | 2001-04-01 14:52 | 1444 | Itapema | Santa Catarina | Brazil | America | 1 | Butter | Dairy | Fridge | 80 | 70 |
72 | 2001-04-01 15:36 | 20924 | Fossalto | Molise | Italy | Europe | 3 | Milk | Dairy | Fridge | 267 | 223 |
73 | 2001-04-01 17:02 | 3614 | Alissas | Auvergne-Rhône-Alpes | France | Europe | 18 | Turkey Breast | Meat | Freezer | 848 | 784 |
74 | 2001-04-01 18:14 | 36073 | Ferriday | Louisiana | United States | America | 27 | Dark Chocolate Bar | Sweets | Pantry | 66 | -24 |
75 | 2001-04-01 19:26 | 10961 | Dersekow | Mecklenburg-Vorpommern | Germany | Europe | 19 | Raisin Bran Cereal | Grain | Pantry | 785 | 773 |
76 | 2001-04-01 20:09 | 43379 | Montello | Wisconsin | United States | America | 7 | Vinegar | Staples & Misc. | Pantry | 229 | 179 |
77 | 2001-04-01 21:36 | 6468 | Troarn | Normandie | France | Europe | 4 | Vanilla Yogurt | Dairy | Fridge | 656 | 608 |
78 | 2001-04-01 22:19 | 34523 | Talbotton | Georgia | United States | America | 31 | Macaroni & Cheese | Grain | Pantry | 265 | 201 |
79 | 2001-04-01 23:31 | 37593 | Shannon | Mississippi | United States | America | 22 | Apple Juice | Beverages | Fridge | 767 | 738 |
80 | 2001-05-01 00:43 | 24348 | Vanylven | Møre og Romsdal | Norway | Europe | 27 | Dark Chocolate Bar | Sweets | Pantry | 582 | 483 |
81 | 2001-05-01 01:26 | 19638 | Barbianello | Lombardy | Italy | Europe | 5 | Chocolate Ice Cream | Sweets | Freezer | 874 | 814 |
82 | 2001-05-01 02:52 | 32868 | Encanto | Arizona | United States | America | 10 | Peppermint | Staples & Misc. | Pantry | 628 | 610 |
83 | 2001-05-01 04:04 | 1979 | Brandon | Manitoba | Canada | America | 16 | Honey Almond Flax Cereal | Grain | Pantry | 196 | 99 |
84 | 2001-05-01 04:48 | 28888 | Corminboeuf | Fribourg | Switzerland | Europe | 22 | Apple Juice | Beverages | Fridge | 20 | -76 |
85 | 2001-05-01 06:14 | 25729 | Vardane | Krasnodar Krai | Russia | Asia | 27 | Dark Chocolate Bar | Sweets | Pantry | 878 | 791 |
86 | 2001-05-01 06:57 | 42665 | Dumbarton | Virginia | United States | America | 26 | Green Bell Peppers | Fruits and Vegetables | Fridge | 888 | 819 |
87 | 2001-05-01 08:09 | 22704 | Vallarsa | Trentino-South Tyrol | Italy | Europe | 7 | Vinegar | Staples & Misc. | Pantry | 240 | 192 |
88 | 2001-05-01 09:36 | 13253 | Tadepalle | Andhra Pradesh | India | Asia | 20 | Bologna | Meat | Fridge | 413 | 399 |
89 | 2001-05-01 10:33 | 34525 | Temple | Georgia | United States | America | 21 | Smoked Ham | Meat | Fridge | 725 | 708 |
90 | 2001-05-01 11:31 | 38208 | Mason | New Hampshire | United States | America | 33 | Green Beans | Fruits and Vegetables | Fridge | 258 | 183 |
91 | 2001-05-01 12:28 | 1203 | Acari | Rio Grande do Norte | Brazil | America | 21 | Smoked Ham | Meat | Fridge | 99 | 26 |
92 | 2001-05-01 13:12 | 15761 | Gobichettipalayam | Tamil Nadu | India | Asia | 30 | Whole Wheat Penne Pasta | Grain | Pantry | 300 | 261 |
93 | 2001-05-01 13:55 | 23666 | Mino | Gifu Prefecture | Japan | Asia | 11 | Whole Wheat English Muffin | Grain | Pantry | 145 | 73 |
94 | 2001-05-01 14:38 | 3736 | Chavanay | Auvergne-Rhône-Alpes | France | Europe | 24 | Beets | Fruits and Vegetables | Fridge | 660 | 576 |
95 | 2001-05-01 16:04 | 9969 | Meyenburg | Brandenburg | Germany | Europe | 15 | Tomato Soup | Staples & Misc. | Pantry | 817 | 758 |
96 | 2001-05-01 17:02 | 9005 | Kemnath | Bavaria | Germany | Europe | 13 | Olive Oil | Staples & Misc. | Pantry | 917 | 842 |
97 | 2001-05-01 18:00 | 14243 | Ilkal | Karnataka | India | Asia | 13 | Olive Oil | Staples & Misc. | Pantry | 346 | 278 |
98 | 2001-05-01 19:12 | 15322 | Bhawanipatna | Odisha | India | Asia | 6 | Sandwich Bread | Pantry | Pantry | 209 | 145 |
99 | 2001-05-01 20:38 | 29194 | Uzwil | St. Gallen | Switzerland | Europe | 23 | Pinto Beans | Fruits and Vegetables | Pantry | 616 | 570 |
100 | 2001-05-01 21:50 | 37993 | Elwood | Nebraska | United States | America | 34 | Broccoli Florets | Fruits and Vegetables | Fridge | 403 | 306 |