item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
37,902 rows
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
store_id >30
effective_date 16
- 2024-06-28 26,034
- 2024-11-10 3,265
- 2024-11-03 1,488
- 2024-09-15 1,430
- 2024-07-17 1,001
- 2024-07-03 752
- 2024-08-18 738
- 2024-07-28 727
- 2024-10-13 595
- 2024-10-06 572
- 2024-12-07 432
- 2024-07-14 286
- 2024-09-29 286
- 2024-11-17 144
- 2024-10-20 142
- 2024-10-27 10
id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
---|---|---|---|---|---|
1 | Bagel 1 | 7 7 | 400 | 430 | 2024-06-28 |
2 | Cookie Crumble Cheesecake 2 | 7 7 | 720 | 770 | 2024-06-28 |
3 | Good Ol' NY Cheesecake 3 | 7 7 | 720 | 770 | 2024-06-28 |
4 | Signature Chocolate Cake 4 | 7 7 | 720 | 770 | 2024-06-28 |
5 | Starbucks® Coffee Tiramisu Cake 5 | 7 7 | 750 | 800 | 2024-06-28 |
6 | Strawberry Shortcake 6 | 7 7 | 720 | 770 | 2024-06-28 |
7 | Chocolate Chunk Monster Cookie 7 | 7 7 | 390 | 440 | 2024-06-28 |
8 | Banana Walnut Muffin 8 | 7 7 | 450 | 500 | 2024-06-28 |
9 | Blueberry Crumble Muffin 9 | 7 7 | 450 | 500 | 2024-06-28 |
10 | Chocolate Crumble Muffin 10 | 7 7 | 450 | 500 | 2024-06-28 |
11 | Pancakes 11 | 7 7 | 550 | 600 | 2024-06-28 |
12 | Almond Croissant 12 | 7 7 | 470 | 520 | 2024-06-28 |
13 | Buttery Croissant 13 | 7 7 | 400 | 430 | 2024-06-28 |
14 | Chocolate Croissant 14 | 7 7 | 440 | 490 | 2024-06-28 |
15 | Creamy Chicken Foldover 15 | 7 7 | 550 | 600 | 2024-06-28 |
16 | Sausage Roll 16 | 7 7 | 550 | 600 | 2024-06-28 |
17 | Buttery Scone 17 | 7 7 | 400 | 430 | 2024-06-28 |
18 | Country Chicken Pie 18 | 7 7 | 690 | 740 | 2024-06-28 |
19 | Deep Dish Beef Pie 19 | 7 7 | 690 | 740 | 2024-06-28 |
20 | Spinach & Mushroom Quiche 20 | 7 7 | 690 | 740 | 2024-06-28 |
21 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 21 | 7 7 | 390 | 420 | 2024-06-28 |
22 | Mixed Nuts 22 | 7 7 | 490 | 540 | 2024-06-28 |
23 | Caramel Waffles 23 | 7 7 | 390 | 420 | 2024-06-28 |
24 | Chicken Ham & Cheese Panwich 24 | 7 7 | 690 | 740 | 2024-06-28 |
25 | Egg Mayo & Cheese Multigrain Croissant 25 | 7 7 | 690 | 740 | 2024-06-28 |
26 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 26 | 7 7 | 690 | 740 | 2024-06-28 |
27 | Rosemary Chicken & Emmental Cheese Croissant 27 | 7 7 | 690 | 740 | 2024-06-28 |
28 | Scrambled Egg & Turkey Ham Pita 28 | 7 7 | 690 | 740 | 2024-06-28 |
29 | Turkey Ham & Triple Cheese Toast 29 | 7 7 | 690 | 740 | 2024-06-28 |
30 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 30 | 7 7 | 790 | 840 | 2024-06-28 |
31 | Ham & Cheese Croissant 31 | 7 7 | 690 | 740 | 2024-06-28 |
32 | Sriracha Chicken Whole Wheat Pita 32 | 7 7 | 750 | 800 | 2024-06-28 |
33 | Blueberry Acai Yogurt Parfait 33 | 7 7 | 650 | 700 | 2024-06-28 |
34 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 34 | 7 7 | 650 | 700 | 2024-06-28 |
35 | Caramel Frappuccino® 35 | 7 7 | 720 | 770 | 2024-06-28 |
36 | Dark Mocha Frappuccino® 36 | 7 7 | 780 | 830 | 2024-06-28 |
37 | Java Chip Frappuccino® 37 | 7 7 | 780 | 830 | 2024-06-28 |
38 | Mocha Frappuccino® 38 | 7 7 | 720 | 770 | 2024-06-28 |
39 | Caramel Macchiato Frappuccino® 39 | 7 7 | 780 | 830 | 2024-06-28 |
40 | Espresso Frappuccino® 40 | 7 7 | 720 | 770 | 2024-06-28 |
41 | White Chocolate Mocha Frappuccino® 41 | 7 7 | 720 | 770 | 2024-06-28 |
42 | Chocolate Chip Cream Frappuccino® 42 | 7 7 | 780 | 830 | 2024-06-28 |
43 | Hojicha Tea Cream Frappuccino® 43 | 7 7 | 760 | 810 | 2024-06-28 |
44 | Vanilla Cream Frappuccino® 44 | 7 7 | 720 | 770 | 2024-06-28 |
45 | Mango Passion Fruit & Hibiscus 45 | 7 7 | 720 | 770 | 2024-06-28 |
46 | Raspberry Black Currant & Oolong 46 | 7 7 | 720 | 770 | 2024-06-28 |
47 | Coffee Traveller 47 | 7 7 | 3120 | 3170 | 2024-06-28 |
48 | Caffè Americano 48 | 7 7 | 540 | 590 | 2024-06-28 |
49 | Cappuccino 49 | 7 7 | 680 | 730 | 2024-06-28 |
50 | Caffè Mocha 50 | 7 7 | 750 | 800 | 2024-06-28 |
51 | Caramel Macchiato 51 | 7 7 | 760 | 810 | 2024-06-28 |
52 | Espresso 52 | 7 7 | 390 | 440 | 2024-06-28 |
53 | Caffè Latte 53 | 7 7 | 680 | 730 | 2024-06-28 |
54 | Oatmilk Latte 54 | 7 7 | 760 | 810 | 2024-06-28 |
55 | Vanilla Latte 55 | 7 7 | 750 | 800 | 2024-06-28 |
56 | White Chocolate Mocha 56 | 7 7 | 750 | 800 | 2024-06-28 |
57 | Flat White 57 | 7 7 | 760 | 810 | 2024-06-28 |
58 | Ristretto Bianco 58 | 7 7 | 760 | 810 | 2024-06-28 |
59 | Iced Caffè Americano 59 | 7 7 | 540 | 590 | 2024-06-28 |
60 | Iced Cappuccino 60 | 7 7 | 680 | 730 | 2024-06-28 |
61 | Iced Caffè Mocha 61 | 7 7 | 750 | 800 | 2024-06-28 |
62 | Iced Caramel Macchiato 62 | 7 7 | 760 | 810 | 2024-06-28 |
63 | Iced Caffè Latte 63 | 7 7 | 680 | 730 | 2024-06-28 |
64 | Iced Oatmilk Latte 64 | 7 7 | 760 | 810 | 2024-06-28 |
65 | Iced Vanilla Latte 65 | 7 7 | 750 | 800 | 2024-06-28 |
66 | Iced White Chocolate Mocha 66 | 7 7 | 750 | 800 | 2024-06-28 |
67 | Signature Hot Chocolate 67 | 7 7 | 720 | 770 | 2024-06-28 |
68 | Signature Iced Chocolate 68 | 7 7 | 720 | 770 | 2024-06-28 |
69 | Carrot Juice 69 | 7 7 | 490 | 540 | 2024-06-28 |
70 | Cloudy Apple Juice 70 | 7 7 | 490 | 540 | 2024-06-28 |
71 | Cranberry Red Grapefruit Juice 71 | 7 7 | 490 | 540 | 2024-06-28 |
72 | Orange Juice 72 | 7 7 | 490 | 540 | 2024-06-28 |
73 | Evian 73 | 7 7 | 350 | 400 | 2024-06-28 |
74 | Sparkling Water 74 | 7 7 | 450 | 500 | 2024-06-28 |
75 | Chai Tea 75 | 7 7 | 500 | 550 | 2024-06-28 |
76 | Earl Grey Tea 76 | 7 7 | 500 | 550 | 2024-06-28 |
77 | English Breakfast Tea 77 | 7 7 | 500 | 550 | 2024-06-28 |
78 | Emperor’s Clouds & Mist™ Tea 78 | 7 7 | 500 | 550 | 2024-06-28 |
79 | Mint Blend Tea 79 | 7 7 | 500 | 550 | 2024-06-28 |
80 | Chamomile Tea 80 | 7 7 | 500 | 550 | 2024-06-28 |
81 | Pure Matcha Latte 81 | 7 7 | 740 | 790 | 2024-06-28 |
82 | Chai Tea Latte 82 | 7 7 | 680 | 730 | 2024-06-28 |
83 | Earl Grey Tea Latte 83 | 7 7 | 680 | 730 | 2024-06-28 |
84 | English Breakfast Tea Latte 84 | 7 7 | 680 | 730 | 2024-06-28 |
85 | Hojicha Tea Latte 85 | 7 7 | 740 | 790 | 2024-06-28 |
86 | Zen Clouds Oolong Tea 86 | 7 7 | 500 | 550 | 2024-06-28 |
87 | Zen Clouds Oolong with Ruby Grapefruit and Honey 87 | 7 7 | 630 | 680 | 2024-06-28 |
88 | Youthberry™ Tea 88 | 7 7 | 500 | 550 | 2024-06-28 |
89 | Iced Shaken Black Tea Lemonade 89 | 7 7 | 610 | 660 | 2024-06-28 |
90 | Iced Shaken Strawberry Black Tea Lemonade 90 | 7 7 | 630 | 680 | 2024-06-28 |
91 | Iced Shaken Hibiscus Tea Lemonade 91 | 7 7 | 610 | 660 | 2024-06-28 |
92 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 92 | 7 7 | 730 | 780 | 2024-06-28 |
93 | Iced Pure Matcha Latte 93 | 7 7 | 740 | 790 | 2024-06-28 |
94 | Iced Chai Tea Latte 94 | 7 7 | 680 | 730 | 2024-06-28 |
95 | Iced Black Tea Latte 95 | 7 7 | 680 | 730 | 2024-06-28 |
96 | Iced Hojicha Tea Latte 96 | 7 7 | 740 | 790 | 2024-06-28 |
97 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 97 | 7 7 | 630 | 680 | 2024-06-28 |
98 | Iced Shaken Zen Clouds Oolong Lemonade 98 | 7 7 | 610 | 660 | 2024-06-28 |
99 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 99 | 7 7 | 630 | 680 | 2024-06-28 |
100 | Origami Pike Place® Roast 100 | 7 7 | 990 | 1040 | 2024-06-28 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "item_prices" ("id" INTEGER NOT NULL PRIMARY KEY, "item_id" INTEGER NOT NULL, "store_id" INTEGER NOT NULL, "base_price" INTEGER NOT NULL, "delivery_price" INTEGER NOT NULL, "effective_date" DATE NOT NULL, FOREIGN KEY ("item_id") REFERENCES "menu_items" ("id"), FOREIGN KEY ("store_id") REFERENCES "stores" ("id")); CREATE INDEX "price_item_id" ON "item_prices" ("item_id"); CREATE INDEX "price_store_id" ON "item_prices" ("store_id"); CREATE UNIQUE INDEX "price_item_id_store_id_effective_date" ON "item_prices" ("item_id", "store_id", "effective_date");