item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
252 rows where store_id = 6
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 184
- 2024-11-10 14
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-08-18 6
- 2024-07-28 5
- 2024-10-13 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-07-14 2
- 2024-09-29 2
store_id 1
- 6 · 252 ✖
id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
---|---|---|---|---|---|
183 | Bagel 183 | 6 6 | 400 | 430 | 2024-06-28 |
184 | Cookie Crumble Cheesecake 184 | 6 6 | 720 | 770 | 2024-06-28 |
185 | Good Ol' NY Cheesecake 185 | 6 6 | 720 | 770 | 2024-06-28 |
186 | Signature Chocolate Cake 186 | 6 6 | 720 | 770 | 2024-06-28 |
187 | Starbucks® Coffee Tiramisu Cake 187 | 6 6 | 750 | 800 | 2024-06-28 |
188 | Strawberry Shortcake 188 | 6 6 | 720 | 770 | 2024-06-28 |
189 | Chocolate Chunk Monster Cookie 189 | 6 6 | 390 | 440 | 2024-06-28 |
190 | Banana Walnut Muffin 190 | 6 6 | 450 | 500 | 2024-06-28 |
191 | Blueberry Crumble Muffin 191 | 6 6 | 450 | 500 | 2024-06-28 |
192 | Chocolate Crumble Muffin 192 | 6 6 | 450 | 500 | 2024-06-28 |
193 | Pancakes 193 | 6 6 | 550 | 600 | 2024-06-28 |
194 | Almond Croissant 194 | 6 6 | 470 | 520 | 2024-06-28 |
195 | Buttery Croissant 195 | 6 6 | 400 | 430 | 2024-06-28 |
196 | Chocolate Croissant 196 | 6 6 | 440 | 490 | 2024-06-28 |
197 | Creamy Chicken Foldover 197 | 6 6 | 550 | 600 | 2024-06-28 |
198 | Sausage Roll 198 | 6 6 | 550 | 600 | 2024-06-28 |
199 | Buttery Scone 199 | 6 6 | 400 | 430 | 2024-06-28 |
200 | Country Chicken Pie 200 | 6 6 | 690 | 740 | 2024-06-28 |
201 | Deep Dish Beef Pie 201 | 6 6 | 690 | 740 | 2024-06-28 |
202 | Spinach & Mushroom Quiche 202 | 6 6 | 690 | 740 | 2024-06-28 |
203 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 203 | 6 6 | 390 | 420 | 2024-06-28 |
204 | Mixed Nuts 204 | 6 6 | 490 | 540 | 2024-06-28 |
205 | Caramel Waffles 205 | 6 6 | 390 | 420 | 2024-06-28 |
206 | Chicken Ham & Cheese Panwich 206 | 6 6 | 690 | 740 | 2024-06-28 |
207 | Egg Mayo & Cheese Multigrain Croissant 207 | 6 6 | 690 | 740 | 2024-06-28 |
208 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 208 | 6 6 | 690 | 740 | 2024-06-28 |
209 | Rosemary Chicken & Emmental Cheese Croissant 209 | 6 6 | 690 | 740 | 2024-06-28 |
210 | Scrambled Egg & Turkey Ham Pita 210 | 6 6 | 690 | 740 | 2024-06-28 |
211 | Turkey Ham & Triple Cheese Toast 211 | 6 6 | 690 | 740 | 2024-06-28 |
212 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 212 | 6 6 | 790 | 840 | 2024-06-28 |
213 | Ham & Cheese Croissant 213 | 6 6 | 690 | 740 | 2024-06-28 |
214 | Sriracha Chicken Whole Wheat Pita 214 | 6 6 | 750 | 800 | 2024-06-28 |
215 | Blueberry Acai Yogurt Parfait 215 | 6 6 | 650 | 700 | 2024-06-28 |
216 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 216 | 6 6 | 650 | 700 | 2024-06-28 |
217 | Caramel Frappuccino® 217 | 6 6 | 720 | 770 | 2024-06-28 |
218 | Dark Mocha Frappuccino® 218 | 6 6 | 780 | 830 | 2024-06-28 |
219 | Java Chip Frappuccino® 219 | 6 6 | 780 | 830 | 2024-06-28 |
220 | Mocha Frappuccino® 220 | 6 6 | 720 | 770 | 2024-06-28 |
221 | Caramel Macchiato Frappuccino® 221 | 6 6 | 780 | 830 | 2024-06-28 |
222 | Espresso Frappuccino® 222 | 6 6 | 720 | 770 | 2024-06-28 |
223 | White Chocolate Mocha Frappuccino® 223 | 6 6 | 720 | 770 | 2024-06-28 |
224 | Chocolate Chip Cream Frappuccino® 224 | 6 6 | 780 | 830 | 2024-06-28 |
225 | Hojicha Tea Cream Frappuccino® 225 | 6 6 | 760 | 810 | 2024-06-28 |
226 | Vanilla Cream Frappuccino® 226 | 6 6 | 720 | 770 | 2024-06-28 |
227 | Mango Passion Fruit & Hibiscus 227 | 6 6 | 720 | 770 | 2024-06-28 |
228 | Raspberry Black Currant & Oolong 228 | 6 6 | 720 | 770 | 2024-06-28 |
229 | Coffee Traveller 229 | 6 6 | 3120 | 3170 | 2024-06-28 |
230 | Caffè Americano 230 | 6 6 | 540 | 590 | 2024-06-28 |
231 | Cappuccino 231 | 6 6 | 680 | 730 | 2024-06-28 |
232 | Caffè Mocha 232 | 6 6 | 750 | 800 | 2024-06-28 |
233 | Caramel Macchiato 233 | 6 6 | 760 | 810 | 2024-06-28 |
234 | Espresso 234 | 6 6 | 390 | 440 | 2024-06-28 |
235 | Caffè Latte 235 | 6 6 | 680 | 730 | 2024-06-28 |
236 | Oatmilk Latte 236 | 6 6 | 760 | 810 | 2024-06-28 |
237 | Vanilla Latte 237 | 6 6 | 750 | 800 | 2024-06-28 |
238 | White Chocolate Mocha 238 | 6 6 | 750 | 800 | 2024-06-28 |
239 | Flat White 239 | 6 6 | 760 | 810 | 2024-06-28 |
240 | Ristretto Bianco 240 | 6 6 | 760 | 810 | 2024-06-28 |
241 | Iced Caffè Americano 241 | 6 6 | 540 | 590 | 2024-06-28 |
242 | Iced Cappuccino 242 | 6 6 | 680 | 730 | 2024-06-28 |
243 | Iced Caffè Mocha 243 | 6 6 | 750 | 800 | 2024-06-28 |
244 | Iced Caramel Macchiato 244 | 6 6 | 760 | 810 | 2024-06-28 |
245 | Iced Caffè Latte 245 | 6 6 | 680 | 730 | 2024-06-28 |
246 | Iced Oatmilk Latte 246 | 6 6 | 760 | 810 | 2024-06-28 |
247 | Iced Vanilla Latte 247 | 6 6 | 750 | 800 | 2024-06-28 |
248 | Iced White Chocolate Mocha 248 | 6 6 | 750 | 800 | 2024-06-28 |
249 | Signature Hot Chocolate 249 | 6 6 | 720 | 770 | 2024-06-28 |
250 | Signature Iced Chocolate 250 | 6 6 | 720 | 770 | 2024-06-28 |
251 | Carrot Juice 251 | 6 6 | 490 | 540 | 2024-06-28 |
252 | Cloudy Apple Juice 252 | 6 6 | 490 | 540 | 2024-06-28 |
253 | Cranberry Red Grapefruit Juice 253 | 6 6 | 490 | 540 | 2024-06-28 |
254 | Orange Juice 254 | 6 6 | 490 | 540 | 2024-06-28 |
255 | Evian 255 | 6 6 | 350 | 400 | 2024-06-28 |
256 | Sparkling Water 256 | 6 6 | 450 | 500 | 2024-06-28 |
257 | Chai Tea 257 | 6 6 | 500 | 550 | 2024-06-28 |
258 | Earl Grey Tea 258 | 6 6 | 500 | 550 | 2024-06-28 |
259 | English Breakfast Tea 259 | 6 6 | 500 | 550 | 2024-06-28 |
260 | Emperor’s Clouds & Mist™ Tea 260 | 6 6 | 500 | 550 | 2024-06-28 |
261 | Mint Blend Tea 261 | 6 6 | 500 | 550 | 2024-06-28 |
262 | Chamomile Tea 262 | 6 6 | 500 | 550 | 2024-06-28 |
263 | Pure Matcha Latte 263 | 6 6 | 740 | 790 | 2024-06-28 |
264 | Chai Tea Latte 264 | 6 6 | 680 | 730 | 2024-06-28 |
265 | Earl Grey Tea Latte 265 | 6 6 | 680 | 730 | 2024-06-28 |
266 | English Breakfast Tea Latte 266 | 6 6 | 680 | 730 | 2024-06-28 |
267 | Hojicha Tea Latte 267 | 6 6 | 740 | 790 | 2024-06-28 |
268 | Zen Clouds Oolong Tea 268 | 6 6 | 500 | 550 | 2024-06-28 |
269 | Zen Clouds Oolong with Ruby Grapefruit and Honey 269 | 6 6 | 630 | 680 | 2024-06-28 |
270 | Youthberry™ Tea 270 | 6 6 | 500 | 550 | 2024-06-28 |
271 | Iced Shaken Black Tea Lemonade 271 | 6 6 | 610 | 660 | 2024-06-28 |
272 | Iced Shaken Strawberry Black Tea Lemonade 272 | 6 6 | 630 | 680 | 2024-06-28 |
273 | Iced Shaken Hibiscus Tea Lemonade 273 | 6 6 | 610 | 660 | 2024-06-28 |
274 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 274 | 6 6 | 730 | 780 | 2024-06-28 |
275 | Iced Pure Matcha Latte 275 | 6 6 | 740 | 790 | 2024-06-28 |
276 | Iced Chai Tea Latte 276 | 6 6 | 680 | 730 | 2024-06-28 |
277 | Iced Black Tea Latte 277 | 6 6 | 680 | 730 | 2024-06-28 |
278 | Iced Hojicha Tea Latte 278 | 6 6 | 740 | 790 | 2024-06-28 |
279 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 279 | 6 6 | 630 | 680 | 2024-06-28 |
280 | Iced Shaken Zen Clouds Oolong Lemonade 280 | 6 6 | 610 | 660 | 2024-06-28 |
281 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 281 | 6 6 | 630 | 680 | 2024-06-28 |
282 | Origami Pike Place® Roast 282 | 6 6 | 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");