item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 138
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 182
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-07-28 5
- 2024-08-18 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-10-13 4
- 2024-07-14 2
- 2024-09-29 2
store_id 1
- 138 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 4066 | Bagel 4066 | 138 138 | 400 | 430 | 2024-06-28 |
| 4067 | Cookie Crumble Cheesecake 4067 | 138 138 | 720 | 770 | 2024-06-28 |
| 4068 | Good Ol' NY Cheesecake 4068 | 138 138 | 720 | 770 | 2024-06-28 |
| 4069 | Signature Chocolate Cake 4069 | 138 138 | 720 | 770 | 2024-06-28 |
| 4070 | Starbucks® Coffee Tiramisu Cake 4070 | 138 138 | 750 | 800 | 2024-06-28 |
| 4071 | Strawberry Shortcake 4071 | 138 138 | 720 | 770 | 2024-06-28 |
| 4072 | Chocolate Chunk Monster Cookie 4072 | 138 138 | 390 | 440 | 2024-06-28 |
| 4073 | Banana Walnut Muffin 4073 | 138 138 | 450 | 500 | 2024-06-28 |
| 4074 | Blueberry Crumble Muffin 4074 | 138 138 | 450 | 500 | 2024-06-28 |
| 4075 | Chocolate Crumble Muffin 4075 | 138 138 | 450 | 500 | 2024-06-28 |
| 4076 | Pancakes 4076 | 138 138 | 550 | 600 | 2024-06-28 |
| 4077 | Almond Croissant 4077 | 138 138 | 470 | 520 | 2024-06-28 |
| 4078 | Buttery Croissant 4078 | 138 138 | 400 | 430 | 2024-06-28 |
| 4079 | Chocolate Croissant 4079 | 138 138 | 440 | 490 | 2024-06-28 |
| 4080 | Creamy Chicken Foldover 4080 | 138 138 | 550 | 600 | 2024-06-28 |
| 4081 | Sausage Roll 4081 | 138 138 | 550 | 600 | 2024-06-28 |
| 4082 | Buttery Scone 4082 | 138 138 | 400 | 430 | 2024-06-28 |
| 4083 | Country Chicken Pie 4083 | 138 138 | 690 | 740 | 2024-06-28 |
| 4084 | Deep Dish Beef Pie 4084 | 138 138 | 690 | 740 | 2024-06-28 |
| 4085 | Spinach & Mushroom Quiche 4085 | 138 138 | 690 | 740 | 2024-06-28 |
| 4086 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 4086 | 138 138 | 390 | 420 | 2024-06-28 |
| 4087 | Mixed Nuts 4087 | 138 138 | 490 | 540 | 2024-06-28 |
| 4088 | Caramel Waffles 4088 | 138 138 | 390 | 420 | 2024-06-28 |
| 4089 | Chicken Ham & Cheese Panwich 4089 | 138 138 | 690 | 740 | 2024-06-28 |
| 4090 | Egg Mayo & Cheese Multigrain Croissant 4090 | 138 138 | 690 | 740 | 2024-06-28 |
| 4091 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 4091 | 138 138 | 690 | 740 | 2024-06-28 |
| 4092 | Rosemary Chicken & Emmental Cheese Croissant 4092 | 138 138 | 690 | 740 | 2024-06-28 |
| 4093 | Scrambled Egg & Turkey Ham Pita 4093 | 138 138 | 690 | 740 | 2024-06-28 |
| 4094 | Turkey Ham & Triple Cheese Toast 4094 | 138 138 | 690 | 740 | 2024-06-28 |
| 4095 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 4095 | 138 138 | 790 | 840 | 2024-06-28 |
| 4096 | Ham & Cheese Croissant 4096 | 138 138 | 690 | 740 | 2024-06-28 |
| 4097 | Sriracha Chicken Whole Wheat Pita 4097 | 138 138 | 750 | 800 | 2024-06-28 |
| 4098 | Blueberry Acai Yogurt Parfait 4098 | 138 138 | 650 | 700 | 2024-06-28 |
| 4099 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 4099 | 138 138 | 650 | 700 | 2024-06-28 |
| 4100 | Caramel Frappuccino® 4100 | 138 138 | 720 | 770 | 2024-06-28 |
| 4101 | Dark Mocha Frappuccino® 4101 | 138 138 | 780 | 830 | 2024-06-28 |
| 4102 | Java Chip Frappuccino® 4102 | 138 138 | 780 | 830 | 2024-06-28 |
| 4103 | Mocha Frappuccino® 4103 | 138 138 | 720 | 770 | 2024-06-28 |
| 4104 | Caramel Macchiato Frappuccino® 4104 | 138 138 | 780 | 830 | 2024-06-28 |
| 4105 | Espresso Frappuccino® 4105 | 138 138 | 720 | 770 | 2024-06-28 |
| 4106 | White Chocolate Mocha Frappuccino® 4106 | 138 138 | 720 | 770 | 2024-06-28 |
| 4107 | Chocolate Chip Cream Frappuccino® 4107 | 138 138 | 780 | 830 | 2024-06-28 |
| 4108 | Hojicha Tea Cream Frappuccino® 4108 | 138 138 | 760 | 810 | 2024-06-28 |
| 4109 | Vanilla Cream Frappuccino® 4109 | 138 138 | 720 | 770 | 2024-06-28 |
| 4110 | Mango Passion Fruit & Hibiscus 4110 | 138 138 | 720 | 770 | 2024-06-28 |
| 4111 | Raspberry Black Currant & Oolong 4111 | 138 138 | 720 | 770 | 2024-06-28 |
| 4112 | Coffee Traveller 4112 | 138 138 | 3120 | 3170 | 2024-06-28 |
| 4113 | Caffè Americano 4113 | 138 138 | 540 | 590 | 2024-06-28 |
| 4114 | Cappuccino 4114 | 138 138 | 680 | 730 | 2024-06-28 |
| 4115 | Caffè Mocha 4115 | 138 138 | 750 | 800 | 2024-06-28 |
| 4116 | Caramel Macchiato 4116 | 138 138 | 760 | 810 | 2024-06-28 |
| 4117 | Espresso 4117 | 138 138 | 390 | 440 | 2024-06-28 |
| 4118 | Caffè Latte 4118 | 138 138 | 680 | 730 | 2024-06-28 |
| 4119 | Oatmilk Latte 4119 | 138 138 | 760 | 810 | 2024-06-28 |
| 4120 | Vanilla Latte 4120 | 138 138 | 750 | 800 | 2024-06-28 |
| 4121 | White Chocolate Mocha 4121 | 138 138 | 750 | 800 | 2024-06-28 |
| 4122 | Flat White 4122 | 138 138 | 760 | 810 | 2024-06-28 |
| 4123 | Ristretto Bianco 4123 | 138 138 | 760 | 810 | 2024-06-28 |
| 4124 | Iced Caffè Americano 4124 | 138 138 | 540 | 590 | 2024-06-28 |
| 4125 | Iced Cappuccino 4125 | 138 138 | 680 | 730 | 2024-06-28 |
| 4126 | Iced Caffè Mocha 4126 | 138 138 | 750 | 800 | 2024-06-28 |
| 4127 | Iced Caramel Macchiato 4127 | 138 138 | 760 | 810 | 2024-06-28 |
| 4128 | Iced Caffè Latte 4128 | 138 138 | 680 | 730 | 2024-06-28 |
| 4129 | Iced Oatmilk Latte 4129 | 138 138 | 760 | 810 | 2024-06-28 |
| 4130 | Iced Vanilla Latte 4130 | 138 138 | 750 | 800 | 2024-06-28 |
| 4131 | Iced White Chocolate Mocha 4131 | 138 138 | 750 | 800 | 2024-06-28 |
| 4132 | Signature Hot Chocolate 4132 | 138 138 | 720 | 770 | 2024-06-28 |
| 4133 | Signature Iced Chocolate 4133 | 138 138 | 720 | 770 | 2024-06-28 |
| 4134 | Carrot Juice 4134 | 138 138 | 490 | 540 | 2024-06-28 |
| 4135 | Cloudy Apple Juice 4135 | 138 138 | 490 | 540 | 2024-06-28 |
| 4136 | Cranberry Red Grapefruit Juice 4136 | 138 138 | 490 | 540 | 2024-06-28 |
| 4137 | Orange Juice 4137 | 138 138 | 490 | 540 | 2024-06-28 |
| 4138 | Evian 4138 | 138 138 | 350 | 400 | 2024-06-28 |
| 4139 | Sparkling Water 4139 | 138 138 | 450 | 500 | 2024-06-28 |
| 4140 | Chai Tea 4140 | 138 138 | 500 | 550 | 2024-06-28 |
| 4141 | Earl Grey Tea 4141 | 138 138 | 500 | 550 | 2024-06-28 |
| 4142 | English Breakfast Tea 4142 | 138 138 | 500 | 550 | 2024-06-28 |
| 4143 | Emperor’s Clouds & Mist™ Tea 4143 | 138 138 | 500 | 550 | 2024-06-28 |
| 4144 | Mint Blend Tea 4144 | 138 138 | 500 | 550 | 2024-06-28 |
| 4145 | Chamomile Tea 4145 | 138 138 | 500 | 550 | 2024-06-28 |
| 4146 | Pure Matcha Latte 4146 | 138 138 | 740 | 790 | 2024-06-28 |
| 4147 | Chai Tea Latte 4147 | 138 138 | 680 | 730 | 2024-06-28 |
| 4148 | Earl Grey Tea Latte 4148 | 138 138 | 680 | 730 | 2024-06-28 |
| 4149 | English Breakfast Tea Latte 4149 | 138 138 | 680 | 730 | 2024-06-28 |
| 4150 | Hojicha Tea Latte 4150 | 138 138 | 740 | 790 | 2024-06-28 |
| 4151 | Zen Clouds Oolong Tea 4151 | 138 138 | 500 | 550 | 2024-06-28 |
| 4152 | Zen Clouds Oolong with Ruby Grapefruit and Honey 4152 | 138 138 | 630 | 680 | 2024-06-28 |
| 4153 | Youthberry™ Tea 4153 | 138 138 | 500 | 550 | 2024-06-28 |
| 4154 | Iced Shaken Black Tea Lemonade 4154 | 138 138 | 610 | 660 | 2024-06-28 |
| 4155 | Iced Shaken Strawberry Black Tea Lemonade 4155 | 138 138 | 630 | 680 | 2024-06-28 |
| 4156 | Iced Shaken Hibiscus Tea Lemonade 4156 | 138 138 | 610 | 660 | 2024-06-28 |
| 4157 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 4157 | 138 138 | 730 | 780 | 2024-06-28 |
| 4158 | Iced Pure Matcha Latte 4158 | 138 138 | 740 | 790 | 2024-06-28 |
| 4159 | Iced Chai Tea Latte 4159 | 138 138 | 680 | 730 | 2024-06-28 |
| 4160 | Iced Black Tea Latte 4160 | 138 138 | 680 | 730 | 2024-06-28 |
| 4161 | Iced Hojicha Tea Latte 4161 | 138 138 | 740 | 790 | 2024-06-28 |
| 4162 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 4162 | 138 138 | 630 | 680 | 2024-06-28 |
| 4163 | Iced Shaken Zen Clouds Oolong Lemonade 4163 | 138 138 | 610 | 660 | 2024-06-28 |
| 4164 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 4164 | 138 138 | 630 | 680 | 2024-06-28 |
| 4165 | Origami Pike Place® Roast 4165 | 138 138 | 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");