item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 106
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 13
- 2024-06-28 182
- 2024-11-10 14
- 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
- 2024-11-17 1
store_id 1
- 106 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 9350 | Bagel 9350 | 106 106 | 400 | 430 | 2024-06-28 |
| 9351 | Cookie Crumble Cheesecake 9351 | 106 106 | 720 | 770 | 2024-06-28 |
| 9352 | Good Ol' NY Cheesecake 9352 | 106 106 | 720 | 770 | 2024-06-28 |
| 9353 | Signature Chocolate Cake 9353 | 106 106 | 720 | 770 | 2024-06-28 |
| 9354 | Starbucks® Coffee Tiramisu Cake 9354 | 106 106 | 750 | 800 | 2024-06-28 |
| 9355 | Strawberry Shortcake 9355 | 106 106 | 720 | 770 | 2024-06-28 |
| 9356 | Chocolate Chunk Monster Cookie 9356 | 106 106 | 390 | 440 | 2024-06-28 |
| 9357 | Banana Walnut Muffin 9357 | 106 106 | 450 | 500 | 2024-06-28 |
| 9358 | Blueberry Crumble Muffin 9358 | 106 106 | 450 | 500 | 2024-06-28 |
| 9359 | Chocolate Crumble Muffin 9359 | 106 106 | 450 | 500 | 2024-06-28 |
| 9360 | Pancakes 9360 | 106 106 | 550 | 600 | 2024-06-28 |
| 9361 | Almond Croissant 9361 | 106 106 | 470 | 520 | 2024-06-28 |
| 9362 | Buttery Croissant 9362 | 106 106 | 400 | 430 | 2024-06-28 |
| 9363 | Chocolate Croissant 9363 | 106 106 | 440 | 490 | 2024-06-28 |
| 9364 | Creamy Chicken Foldover 9364 | 106 106 | 550 | 600 | 2024-06-28 |
| 9365 | Sausage Roll 9365 | 106 106 | 550 | 600 | 2024-06-28 |
| 9366 | Buttery Scone 9366 | 106 106 | 400 | 430 | 2024-06-28 |
| 9367 | Country Chicken Pie 9367 | 106 106 | 690 | 740 | 2024-06-28 |
| 9368 | Deep Dish Beef Pie 9368 | 106 106 | 690 | 740 | 2024-06-28 |
| 9369 | Spinach & Mushroom Quiche 9369 | 106 106 | 690 | 740 | 2024-06-28 |
| 9370 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 9370 | 106 106 | 390 | 420 | 2024-06-28 |
| 9371 | Mixed Nuts 9371 | 106 106 | 490 | 540 | 2024-06-28 |
| 9372 | Caramel Waffles 9372 | 106 106 | 390 | 420 | 2024-06-28 |
| 9373 | Chicken Ham & Cheese Panwich 9373 | 106 106 | 690 | 740 | 2024-06-28 |
| 9374 | Egg Mayo & Cheese Multigrain Croissant 9374 | 106 106 | 690 | 740 | 2024-06-28 |
| 9375 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 9375 | 106 106 | 690 | 740 | 2024-06-28 |
| 9376 | Rosemary Chicken & Emmental Cheese Croissant 9376 | 106 106 | 690 | 740 | 2024-06-28 |
| 9377 | Scrambled Egg & Turkey Ham Pita 9377 | 106 106 | 690 | 740 | 2024-06-28 |
| 9378 | Turkey Ham & Triple Cheese Toast 9378 | 106 106 | 690 | 740 | 2024-06-28 |
| 9379 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 9379 | 106 106 | 790 | 840 | 2024-06-28 |
| 9380 | Ham & Cheese Croissant 9380 | 106 106 | 690 | 740 | 2024-06-28 |
| 9381 | Sriracha Chicken Whole Wheat Pita 9381 | 106 106 | 750 | 800 | 2024-06-28 |
| 9382 | Blueberry Acai Yogurt Parfait 9382 | 106 106 | 650 | 700 | 2024-06-28 |
| 9383 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 9383 | 106 106 | 650 | 700 | 2024-06-28 |
| 9384 | Caramel Frappuccino® 9384 | 106 106 | 720 | 770 | 2024-06-28 |
| 9385 | Dark Mocha Frappuccino® 9385 | 106 106 | 780 | 830 | 2024-06-28 |
| 9386 | Java Chip Frappuccino® 9386 | 106 106 | 780 | 830 | 2024-06-28 |
| 9387 | Mocha Frappuccino® 9387 | 106 106 | 720 | 770 | 2024-06-28 |
| 9388 | Caramel Macchiato Frappuccino® 9388 | 106 106 | 780 | 830 | 2024-06-28 |
| 9389 | Espresso Frappuccino® 9389 | 106 106 | 720 | 770 | 2024-06-28 |
| 9390 | White Chocolate Mocha Frappuccino® 9390 | 106 106 | 720 | 770 | 2024-06-28 |
| 9391 | Chocolate Chip Cream Frappuccino® 9391 | 106 106 | 780 | 830 | 2024-06-28 |
| 9392 | Hojicha Tea Cream Frappuccino® 9392 | 106 106 | 760 | 810 | 2024-06-28 |
| 9393 | Vanilla Cream Frappuccino® 9393 | 106 106 | 720 | 770 | 2024-06-28 |
| 9394 | Mango Passion Fruit & Hibiscus 9394 | 106 106 | 720 | 770 | 2024-06-28 |
| 9395 | Raspberry Black Currant & Oolong 9395 | 106 106 | 720 | 770 | 2024-06-28 |
| 9396 | Coffee Traveller 9396 | 106 106 | 3120 | 3170 | 2024-06-28 |
| 9397 | Caffè Americano 9397 | 106 106 | 540 | 590 | 2024-06-28 |
| 9398 | Cappuccino 9398 | 106 106 | 680 | 730 | 2024-06-28 |
| 9399 | Caffè Mocha 9399 | 106 106 | 750 | 800 | 2024-06-28 |
| 9400 | Caramel Macchiato 9400 | 106 106 | 760 | 810 | 2024-06-28 |
| 9401 | Espresso 9401 | 106 106 | 390 | 440 | 2024-06-28 |
| 9402 | Caffè Latte 9402 | 106 106 | 680 | 730 | 2024-06-28 |
| 9403 | Oatmilk Latte 9403 | 106 106 | 760 | 810 | 2024-06-28 |
| 9404 | Vanilla Latte 9404 | 106 106 | 750 | 800 | 2024-06-28 |
| 9405 | White Chocolate Mocha 9405 | 106 106 | 750 | 800 | 2024-06-28 |
| 9406 | Flat White 9406 | 106 106 | 760 | 810 | 2024-06-28 |
| 9407 | Ristretto Bianco 9407 | 106 106 | 760 | 810 | 2024-06-28 |
| 9408 | Iced Caffè Americano 9408 | 106 106 | 540 | 590 | 2024-06-28 |
| 9409 | Iced Cappuccino 9409 | 106 106 | 680 | 730 | 2024-06-28 |
| 9410 | Iced Caffè Mocha 9410 | 106 106 | 750 | 800 | 2024-06-28 |
| 9411 | Iced Caramel Macchiato 9411 | 106 106 | 760 | 810 | 2024-06-28 |
| 9412 | Iced Caffè Latte 9412 | 106 106 | 680 | 730 | 2024-06-28 |
| 9413 | Iced Oatmilk Latte 9413 | 106 106 | 760 | 810 | 2024-06-28 |
| 9414 | Iced Vanilla Latte 9414 | 106 106 | 750 | 800 | 2024-06-28 |
| 9415 | Iced White Chocolate Mocha 9415 | 106 106 | 750 | 800 | 2024-06-28 |
| 9416 | Signature Hot Chocolate 9416 | 106 106 | 720 | 770 | 2024-06-28 |
| 9417 | Signature Iced Chocolate 9417 | 106 106 | 720 | 770 | 2024-06-28 |
| 9418 | Carrot Juice 9418 | 106 106 | 490 | 540 | 2024-06-28 |
| 9419 | Cloudy Apple Juice 9419 | 106 106 | 490 | 540 | 2024-06-28 |
| 9420 | Cranberry Red Grapefruit Juice 9420 | 106 106 | 490 | 540 | 2024-06-28 |
| 9421 | Orange Juice 9421 | 106 106 | 490 | 540 | 2024-06-28 |
| 9422 | Evian 9422 | 106 106 | 350 | 400 | 2024-06-28 |
| 9423 | Sparkling Water 9423 | 106 106 | 450 | 500 | 2024-06-28 |
| 9424 | Chai Tea 9424 | 106 106 | 500 | 550 | 2024-06-28 |
| 9425 | Earl Grey Tea 9425 | 106 106 | 500 | 550 | 2024-06-28 |
| 9426 | English Breakfast Tea 9426 | 106 106 | 500 | 550 | 2024-06-28 |
| 9427 | Emperor’s Clouds & Mist™ Tea 9427 | 106 106 | 500 | 550 | 2024-06-28 |
| 9428 | Mint Blend Tea 9428 | 106 106 | 500 | 550 | 2024-06-28 |
| 9429 | Chamomile Tea 9429 | 106 106 | 500 | 550 | 2024-06-28 |
| 9430 | Pure Matcha Latte 9430 | 106 106 | 740 | 790 | 2024-06-28 |
| 9431 | Chai Tea Latte 9431 | 106 106 | 680 | 730 | 2024-06-28 |
| 9432 | Earl Grey Tea Latte 9432 | 106 106 | 680 | 730 | 2024-06-28 |
| 9433 | English Breakfast Tea Latte 9433 | 106 106 | 680 | 730 | 2024-06-28 |
| 9434 | Hojicha Tea Latte 9434 | 106 106 | 740 | 790 | 2024-06-28 |
| 9435 | Zen Clouds Oolong Tea 9435 | 106 106 | 500 | 550 | 2024-06-28 |
| 9436 | Zen Clouds Oolong with Ruby Grapefruit and Honey 9436 | 106 106 | 630 | 680 | 2024-06-28 |
| 9437 | Youthberry™ Tea 9437 | 106 106 | 500 | 550 | 2024-06-28 |
| 9438 | Iced Shaken Black Tea Lemonade 9438 | 106 106 | 610 | 660 | 2024-06-28 |
| 9439 | Iced Shaken Strawberry Black Tea Lemonade 9439 | 106 106 | 630 | 680 | 2024-06-28 |
| 9440 | Iced Shaken Hibiscus Tea Lemonade 9440 | 106 106 | 610 | 660 | 2024-06-28 |
| 9441 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 9441 | 106 106 | 730 | 780 | 2024-06-28 |
| 9442 | Iced Pure Matcha Latte 9442 | 106 106 | 740 | 790 | 2024-06-28 |
| 9443 | Iced Chai Tea Latte 9443 | 106 106 | 680 | 730 | 2024-06-28 |
| 9444 | Iced Black Tea Latte 9444 | 106 106 | 680 | 730 | 2024-06-28 |
| 9445 | Iced Hojicha Tea Latte 9445 | 106 106 | 740 | 790 | 2024-06-28 |
| 9446 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 9446 | 106 106 | 630 | 680 | 2024-06-28 |
| 9447 | Iced Shaken Zen Clouds Oolong Lemonade 9447 | 106 106 | 610 | 660 | 2024-06-28 |
| 9448 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 9448 | 106 106 | 630 | 680 | 2024-06-28 |
| 9449 | Origami Pike Place® Roast 9449 | 106 106 | 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");