item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
252 rows where store_id = 58
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 195
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-07-28 7
- 2024-08-18 6
- 2024-10-13 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-07-14 2
- 2024-09-29 2
- 2024-10-27 1
store_id 1
- 58 · 252 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 17041 | Bagel 17041 | 58 58 | 400 | 430 | 2024-06-28 |
| 17042 | Cookie Crumble Cheesecake 17042 | 58 58 | 720 | 770 | 2024-06-28 |
| 17043 | Good Ol' NY Cheesecake 17043 | 58 58 | 720 | 770 | 2024-06-28 |
| 17044 | Signature Chocolate Cake 17044 | 58 58 | 720 | 770 | 2024-06-28 |
| 17045 | Starbucks® Coffee Tiramisu Cake 17045 | 58 58 | 750 | 800 | 2024-06-28 |
| 17046 | Strawberry Shortcake 17046 | 58 58 | 720 | 770 | 2024-06-28 |
| 17047 | Chocolate Chunk Monster Cookie 17047 | 58 58 | 390 | 440 | 2024-06-28 |
| 17048 | Banana Walnut Muffin 17048 | 58 58 | 450 | 500 | 2024-06-28 |
| 17049 | Blueberry Crumble Muffin 17049 | 58 58 | 450 | 500 | 2024-06-28 |
| 17050 | Chocolate Crumble Muffin 17050 | 58 58 | 450 | 500 | 2024-06-28 |
| 17051 | Pancakes 17051 | 58 58 | 550 | 600 | 2024-06-28 |
| 17052 | Almond Croissant 17052 | 58 58 | 470 | 520 | 2024-06-28 |
| 17053 | Buttery Croissant 17053 | 58 58 | 400 | 430 | 2024-06-28 |
| 17054 | Chocolate Croissant 17054 | 58 58 | 440 | 490 | 2024-06-28 |
| 17055 | Creamy Chicken Foldover 17055 | 58 58 | 550 | 600 | 2024-06-28 |
| 17056 | Sausage Roll 17056 | 58 58 | 550 | 600 | 2024-06-28 |
| 17057 | Buttery Scone 17057 | 58 58 | 400 | 430 | 2024-06-28 |
| 17058 | Country Chicken Pie 17058 | 58 58 | 690 | 740 | 2024-06-28 |
| 17059 | Deep Dish Beef Pie 17059 | 58 58 | 690 | 740 | 2024-06-28 |
| 17060 | Spinach & Mushroom Quiche 17060 | 58 58 | 690 | 740 | 2024-06-28 |
| 17061 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 17061 | 58 58 | 390 | 420 | 2024-06-28 |
| 17062 | Mixed Nuts 17062 | 58 58 | 490 | 540 | 2024-06-28 |
| 17063 | Caramel Waffles 17063 | 58 58 | 390 | 420 | 2024-06-28 |
| 17064 | Chicken Ham & Cheese Panwich 17064 | 58 58 | 690 | 740 | 2024-06-28 |
| 17065 | Egg Mayo & Cheese Multigrain Croissant 17065 | 58 58 | 690 | 740 | 2024-06-28 |
| 17066 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 17066 | 58 58 | 690 | 740 | 2024-06-28 |
| 17067 | Rosemary Chicken & Emmental Cheese Croissant 17067 | 58 58 | 690 | 740 | 2024-06-28 |
| 17068 | Scrambled Egg & Turkey Ham Pita 17068 | 58 58 | 690 | 740 | 2024-06-28 |
| 17069 | Turkey Ham & Triple Cheese Toast 17069 | 58 58 | 690 | 740 | 2024-06-28 |
| 17070 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 17070 | 58 58 | 790 | 840 | 2024-06-28 |
| 17071 | Ham & Cheese Croissant 17071 | 58 58 | 690 | 740 | 2024-06-28 |
| 17072 | Sriracha Chicken Whole Wheat Pita 17072 | 58 58 | 750 | 800 | 2024-06-28 |
| 17073 | Blueberry Acai Yogurt Parfait 17073 | 58 58 | 650 | 700 | 2024-06-28 |
| 17074 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 17074 | 58 58 | 650 | 700 | 2024-06-28 |
| 17075 | Buttery Croissant 17075 | 58 58 | 400 | 450 | 2024-06-28 |
| 17076 | Chocolate Croissant 17076 | 58 58 | 440 | 490 | 2024-06-28 |
| 17077 | Raisin Danish 17077 | 58 58 | 470 | 520 | 2024-06-28 |
| 17078 | Apple Tart 17078 | 58 58 | 620 | 670 | 2024-06-28 |
| 17079 | Lemon Meringue Tart 17079 | 58 58 | 620 | 670 | 2024-06-28 |
| 17080 | Caramel Frappuccino® 17080 | 58 58 | 720 | 770 | 2024-06-28 |
| 17081 | Dark Mocha Frappuccino® 17081 | 58 58 | 780 | 830 | 2024-06-28 |
| 17082 | Java Chip Frappuccino® 17082 | 58 58 | 780 | 830 | 2024-06-28 |
| 17083 | Mocha Frappuccino® 17083 | 58 58 | 720 | 770 | 2024-06-28 |
| 17084 | Caramel Macchiato Frappuccino® 17084 | 58 58 | 780 | 830 | 2024-06-28 |
| 17085 | Espresso Frappuccino® 17085 | 58 58 | 720 | 770 | 2024-06-28 |
| 17086 | White Chocolate Mocha Frappuccino® 17086 | 58 58 | 720 | 770 | 2024-06-28 |
| 17087 | Chocolate Chip Cream Frappuccino® 17087 | 58 58 | 780 | 830 | 2024-06-28 |
| 17088 | Hojicha Tea Cream Frappuccino® 17088 | 58 58 | 760 | 810 | 2024-06-28 |
| 17089 | Vanilla Cream Frappuccino® 17089 | 58 58 | 720 | 770 | 2024-06-28 |
| 17090 | Mango Passion Fruit & Hibiscus 17090 | 58 58 | 720 | 770 | 2024-06-28 |
| 17091 | Raspberry Black Currant & Oolong 17091 | 58 58 | 720 | 770 | 2024-06-28 |
| 17092 | Coffee Traveller 17092 | 58 58 | 3120 | 3170 | 2024-06-28 |
| 17093 | Caffè Americano 17093 | 58 58 | 540 | 590 | 2024-06-28 |
| 17094 | Cappuccino 17094 | 58 58 | 680 | 730 | 2024-06-28 |
| 17095 | Caffè Mocha 17095 | 58 58 | 750 | 800 | 2024-06-28 |
| 17096 | Caramel Macchiato 17096 | 58 58 | 760 | 810 | 2024-06-28 |
| 17097 | Espresso 17097 | 58 58 | 390 | 440 | 2024-06-28 |
| 17098 | Caffè Latte 17098 | 58 58 | 680 | 730 | 2024-06-28 |
| 17099 | Oatmilk Latte 17099 | 58 58 | 760 | 810 | 2024-06-28 |
| 17100 | Vanilla Latte 17100 | 58 58 | 750 | 800 | 2024-06-28 |
| 17101 | White Chocolate Mocha 17101 | 58 58 | 750 | 800 | 2024-06-28 |
| 17102 | Flat White 17102 | 58 58 | 760 | 810 | 2024-06-28 |
| 17103 | Ristretto Bianco 17103 | 58 58 | 760 | 810 | 2024-06-28 |
| 17104 | Iced Caffè Americano 17104 | 58 58 | 540 | 590 | 2024-06-28 |
| 17105 | Iced Cappuccino 17105 | 58 58 | 680 | 730 | 2024-06-28 |
| 17106 | Iced Caffè Mocha 17106 | 58 58 | 750 | 800 | 2024-06-28 |
| 17107 | Iced Caramel Macchiato 17107 | 58 58 | 760 | 810 | 2024-06-28 |
| 17108 | Iced Caffè Latte 17108 | 58 58 | 680 | 730 | 2024-06-28 |
| 17109 | Iced Oatmilk Latte 17109 | 58 58 | 760 | 810 | 2024-06-28 |
| 17110 | Iced Vanilla Latte 17110 | 58 58 | 750 | 800 | 2024-06-28 |
| 17111 | Iced White Chocolate Mocha 17111 | 58 58 | 750 | 800 | 2024-06-28 |
| 17112 | Signature Hot Chocolate 17112 | 58 58 | 720 | 770 | 2024-06-28 |
| 17113 | Signature Iced Chocolate 17113 | 58 58 | 720 | 770 | 2024-06-28 |
| 17114 | Carrot Juice 17114 | 58 58 | 490 | 540 | 2024-06-28 |
| 17115 | Cloudy Apple Juice 17115 | 58 58 | 490 | 540 | 2024-06-28 |
| 17116 | Cranberry Red Grapefruit Juice 17116 | 58 58 | 490 | 540 | 2024-06-28 |
| 17117 | Orange Juice 17117 | 58 58 | 490 | 540 | 2024-06-28 |
| 17118 | Evian 17118 | 58 58 | 350 | 400 | 2024-06-28 |
| 17119 | Sparkling Water 17119 | 58 58 | 450 | 500 | 2024-06-28 |
| 17120 | Chai Tea 17120 | 58 58 | 500 | 550 | 2024-06-28 |
| 17121 | Earl Grey Tea 17121 | 58 58 | 500 | 550 | 2024-06-28 |
| 17122 | English Breakfast Tea 17122 | 58 58 | 500 | 550 | 2024-06-28 |
| 17123 | Emperor’s Clouds & Mist™ Tea 17123 | 58 58 | 500 | 550 | 2024-06-28 |
| 17124 | Mint Blend Tea 17124 | 58 58 | 500 | 550 | 2024-06-28 |
| 17125 | Chamomile Tea 17125 | 58 58 | 500 | 550 | 2024-06-28 |
| 17126 | Pure Matcha Latte 17126 | 58 58 | 740 | 790 | 2024-06-28 |
| 17127 | Chai Tea Latte 17127 | 58 58 | 680 | 730 | 2024-06-28 |
| 17128 | Earl Grey Tea Latte 17128 | 58 58 | 680 | 730 | 2024-06-28 |
| 17129 | English Breakfast Tea Latte 17129 | 58 58 | 680 | 730 | 2024-06-28 |
| 17130 | Hojicha Tea Latte 17130 | 58 58 | 740 | 790 | 2024-06-28 |
| 17131 | Zen Clouds Oolong Tea 17131 | 58 58 | 500 | 550 | 2024-06-28 |
| 17132 | Zen Clouds Oolong with Ruby Grapefruit and Honey 17132 | 58 58 | 630 | 680 | 2024-06-28 |
| 17133 | Youthberry™ Tea 17133 | 58 58 | 500 | 550 | 2024-06-28 |
| 17134 | Iced Shaken Black Tea Lemonade 17134 | 58 58 | 610 | 660 | 2024-06-28 |
| 17135 | Iced Shaken Strawberry Black Tea Lemonade 17135 | 58 58 | 630 | 680 | 2024-06-28 |
| 17136 | Iced Shaken Hibiscus Tea Lemonade 17136 | 58 58 | 610 | 660 | 2024-06-28 |
| 17137 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 17137 | 58 58 | 730 | 780 | 2024-06-28 |
| 17138 | Iced Pure Matcha Latte 17138 | 58 58 | 740 | 790 | 2024-06-28 |
| 17139 | Iced Chai Tea Latte 17139 | 58 58 | 680 | 730 | 2024-06-28 |
| 17140 | Iced Black Tea Latte 17140 | 58 58 | 680 | 730 | 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");