item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 130
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
- 130 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 5524 | Bagel 5524 | 130 130 | 400 | 430 | 2024-06-28 |
| 5525 | Cookie Crumble Cheesecake 5525 | 130 130 | 720 | 770 | 2024-06-28 |
| 5526 | Good Ol' NY Cheesecake 5526 | 130 130 | 720 | 770 | 2024-06-28 |
| 5527 | Signature Chocolate Cake 5527 | 130 130 | 720 | 770 | 2024-06-28 |
| 5528 | Starbucks® Coffee Tiramisu Cake 5528 | 130 130 | 750 | 800 | 2024-06-28 |
| 5529 | Strawberry Shortcake 5529 | 130 130 | 720 | 770 | 2024-06-28 |
| 5530 | Chocolate Chunk Monster Cookie 5530 | 130 130 | 390 | 440 | 2024-06-28 |
| 5531 | Banana Walnut Muffin 5531 | 130 130 | 450 | 500 | 2024-06-28 |
| 5532 | Blueberry Crumble Muffin 5532 | 130 130 | 450 | 500 | 2024-06-28 |
| 5533 | Chocolate Crumble Muffin 5533 | 130 130 | 450 | 500 | 2024-06-28 |
| 5534 | Pancakes 5534 | 130 130 | 550 | 600 | 2024-06-28 |
| 5535 | Almond Croissant 5535 | 130 130 | 470 | 520 | 2024-06-28 |
| 5536 | Buttery Croissant 5536 | 130 130 | 400 | 430 | 2024-06-28 |
| 5537 | Chocolate Croissant 5537 | 130 130 | 440 | 490 | 2024-06-28 |
| 5538 | Creamy Chicken Foldover 5538 | 130 130 | 550 | 600 | 2024-06-28 |
| 5539 | Sausage Roll 5539 | 130 130 | 550 | 600 | 2024-06-28 |
| 5540 | Buttery Scone 5540 | 130 130 | 400 | 430 | 2024-06-28 |
| 5541 | Country Chicken Pie 5541 | 130 130 | 690 | 740 | 2024-06-28 |
| 5542 | Deep Dish Beef Pie 5542 | 130 130 | 690 | 740 | 2024-06-28 |
| 5543 | Spinach & Mushroom Quiche 5543 | 130 130 | 690 | 740 | 2024-06-28 |
| 5544 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 5544 | 130 130 | 390 | 420 | 2024-06-28 |
| 5545 | Mixed Nuts 5545 | 130 130 | 490 | 540 | 2024-06-28 |
| 5546 | Caramel Waffles 5546 | 130 130 | 390 | 420 | 2024-06-28 |
| 5547 | Chicken Ham & Cheese Panwich 5547 | 130 130 | 690 | 740 | 2024-06-28 |
| 5548 | Egg Mayo & Cheese Multigrain Croissant 5548 | 130 130 | 690 | 740 | 2024-06-28 |
| 5549 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 5549 | 130 130 | 690 | 740 | 2024-06-28 |
| 5550 | Rosemary Chicken & Emmental Cheese Croissant 5550 | 130 130 | 690 | 740 | 2024-06-28 |
| 5551 | Scrambled Egg & Turkey Ham Pita 5551 | 130 130 | 690 | 740 | 2024-06-28 |
| 5552 | Turkey Ham & Triple Cheese Toast 5552 | 130 130 | 690 | 740 | 2024-06-28 |
| 5553 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 5553 | 130 130 | 790 | 840 | 2024-06-28 |
| 5554 | Ham & Cheese Croissant 5554 | 130 130 | 690 | 740 | 2024-06-28 |
| 5555 | Sriracha Chicken Whole Wheat Pita 5555 | 130 130 | 750 | 800 | 2024-06-28 |
| 5556 | Blueberry Acai Yogurt Parfait 5556 | 130 130 | 650 | 700 | 2024-06-28 |
| 5557 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 5557 | 130 130 | 650 | 700 | 2024-06-28 |
| 5558 | Caramel Frappuccino® 5558 | 130 130 | 720 | 770 | 2024-06-28 |
| 5559 | Dark Mocha Frappuccino® 5559 | 130 130 | 780 | 830 | 2024-06-28 |
| 5560 | Java Chip Frappuccino® 5560 | 130 130 | 780 | 830 | 2024-06-28 |
| 5561 | Mocha Frappuccino® 5561 | 130 130 | 720 | 770 | 2024-06-28 |
| 5562 | Caramel Macchiato Frappuccino® 5562 | 130 130 | 780 | 830 | 2024-06-28 |
| 5563 | Espresso Frappuccino® 5563 | 130 130 | 720 | 770 | 2024-06-28 |
| 5564 | White Chocolate Mocha Frappuccino® 5564 | 130 130 | 720 | 770 | 2024-06-28 |
| 5565 | Chocolate Chip Cream Frappuccino® 5565 | 130 130 | 780 | 830 | 2024-06-28 |
| 5566 | Hojicha Tea Cream Frappuccino® 5566 | 130 130 | 760 | 810 | 2024-06-28 |
| 5567 | Vanilla Cream Frappuccino® 5567 | 130 130 | 720 | 770 | 2024-06-28 |
| 5568 | Mango Passion Fruit & Hibiscus 5568 | 130 130 | 720 | 770 | 2024-06-28 |
| 5569 | Raspberry Black Currant & Oolong 5569 | 130 130 | 720 | 770 | 2024-06-28 |
| 5570 | Coffee Traveller 5570 | 130 130 | 3120 | 3170 | 2024-06-28 |
| 5571 | Caffè Americano 5571 | 130 130 | 540 | 590 | 2024-06-28 |
| 5572 | Cappuccino 5572 | 130 130 | 680 | 730 | 2024-06-28 |
| 5573 | Caffè Mocha 5573 | 130 130 | 750 | 800 | 2024-06-28 |
| 5574 | Caramel Macchiato 5574 | 130 130 | 760 | 810 | 2024-06-28 |
| 5575 | Espresso 5575 | 130 130 | 390 | 440 | 2024-06-28 |
| 5576 | Caffè Latte 5576 | 130 130 | 680 | 730 | 2024-06-28 |
| 5577 | Oatmilk Latte 5577 | 130 130 | 760 | 810 | 2024-06-28 |
| 5578 | Vanilla Latte 5578 | 130 130 | 750 | 800 | 2024-06-28 |
| 5579 | White Chocolate Mocha 5579 | 130 130 | 750 | 800 | 2024-06-28 |
| 5580 | Flat White 5580 | 130 130 | 760 | 810 | 2024-06-28 |
| 5581 | Ristretto Bianco 5581 | 130 130 | 760 | 810 | 2024-06-28 |
| 5582 | Iced Caffè Americano 5582 | 130 130 | 540 | 590 | 2024-06-28 |
| 5583 | Iced Cappuccino 5583 | 130 130 | 680 | 730 | 2024-06-28 |
| 5584 | Iced Caffè Mocha 5584 | 130 130 | 750 | 800 | 2024-06-28 |
| 5585 | Iced Caramel Macchiato 5585 | 130 130 | 760 | 810 | 2024-06-28 |
| 5586 | Iced Caffè Latte 5586 | 130 130 | 680 | 730 | 2024-06-28 |
| 5587 | Iced Oatmilk Latte 5587 | 130 130 | 760 | 810 | 2024-06-28 |
| 5588 | Iced Vanilla Latte 5588 | 130 130 | 750 | 800 | 2024-06-28 |
| 5589 | Iced White Chocolate Mocha 5589 | 130 130 | 750 | 800 | 2024-06-28 |
| 5590 | Signature Hot Chocolate 5590 | 130 130 | 720 | 770 | 2024-06-28 |
| 5591 | Signature Iced Chocolate 5591 | 130 130 | 720 | 770 | 2024-06-28 |
| 5592 | Carrot Juice 5592 | 130 130 | 490 | 540 | 2024-06-28 |
| 5593 | Cloudy Apple Juice 5593 | 130 130 | 490 | 540 | 2024-06-28 |
| 5594 | Cranberry Red Grapefruit Juice 5594 | 130 130 | 490 | 540 | 2024-06-28 |
| 5595 | Orange Juice 5595 | 130 130 | 490 | 540 | 2024-06-28 |
| 5596 | Evian 5596 | 130 130 | 350 | 400 | 2024-06-28 |
| 5597 | Sparkling Water 5597 | 130 130 | 450 | 500 | 2024-06-28 |
| 5598 | Chai Tea 5598 | 130 130 | 500 | 550 | 2024-06-28 |
| 5599 | Earl Grey Tea 5599 | 130 130 | 500 | 550 | 2024-06-28 |
| 5600 | English Breakfast Tea 5600 | 130 130 | 500 | 550 | 2024-06-28 |
| 5601 | Emperor’s Clouds & Mist™ Tea 5601 | 130 130 | 500 | 550 | 2024-06-28 |
| 5602 | Mint Blend Tea 5602 | 130 130 | 500 | 550 | 2024-06-28 |
| 5603 | Chamomile Tea 5603 | 130 130 | 500 | 550 | 2024-06-28 |
| 5604 | Pure Matcha Latte 5604 | 130 130 | 740 | 790 | 2024-06-28 |
| 5605 | Chai Tea Latte 5605 | 130 130 | 680 | 730 | 2024-06-28 |
| 5606 | Earl Grey Tea Latte 5606 | 130 130 | 680 | 730 | 2024-06-28 |
| 5607 | English Breakfast Tea Latte 5607 | 130 130 | 680 | 730 | 2024-06-28 |
| 5608 | Hojicha Tea Latte 5608 | 130 130 | 740 | 790 | 2024-06-28 |
| 5609 | Zen Clouds Oolong Tea 5609 | 130 130 | 500 | 550 | 2024-06-28 |
| 5610 | Zen Clouds Oolong with Ruby Grapefruit and Honey 5610 | 130 130 | 630 | 680 | 2024-06-28 |
| 5611 | Youthberry™ Tea 5611 | 130 130 | 500 | 550 | 2024-06-28 |
| 5612 | Iced Shaken Black Tea Lemonade 5612 | 130 130 | 610 | 660 | 2024-06-28 |
| 5613 | Iced Shaken Strawberry Black Tea Lemonade 5613 | 130 130 | 630 | 680 | 2024-06-28 |
| 5614 | Iced Shaken Hibiscus Tea Lemonade 5614 | 130 130 | 610 | 660 | 2024-06-28 |
| 5615 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 5615 | 130 130 | 730 | 780 | 2024-06-28 |
| 5616 | Iced Pure Matcha Latte 5616 | 130 130 | 740 | 790 | 2024-06-28 |
| 5617 | Iced Chai Tea Latte 5617 | 130 130 | 680 | 730 | 2024-06-28 |
| 5618 | Iced Black Tea Latte 5618 | 130 130 | 680 | 730 | 2024-06-28 |
| 5619 | Iced Hojicha Tea Latte 5619 | 130 130 | 740 | 790 | 2024-06-28 |
| 5620 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 5620 | 130 130 | 630 | 680 | 2024-06-28 |
| 5621 | Iced Shaken Zen Clouds Oolong Lemonade 5621 | 130 130 | 610 | 660 | 2024-06-28 |
| 5622 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 5622 | 130 130 | 630 | 680 | 2024-06-28 |
| 5623 | Origami Pike Place® Roast 5623 | 130 130 | 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");