item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 70
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
- 70 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 15028 | Bagel 15028 | 70 70 | 400 | 430 | 2024-06-28 |
| 15029 | Cookie Crumble Cheesecake 15029 | 70 70 | 720 | 770 | 2024-06-28 |
| 15030 | Good Ol' NY Cheesecake 15030 | 70 70 | 720 | 770 | 2024-06-28 |
| 15031 | Signature Chocolate Cake 15031 | 70 70 | 720 | 770 | 2024-06-28 |
| 15032 | Starbucks® Coffee Tiramisu Cake 15032 | 70 70 | 750 | 800 | 2024-06-28 |
| 15033 | Strawberry Shortcake 15033 | 70 70 | 720 | 770 | 2024-06-28 |
| 15034 | Chocolate Chunk Monster Cookie 15034 | 70 70 | 390 | 440 | 2024-06-28 |
| 15035 | Banana Walnut Muffin 15035 | 70 70 | 450 | 500 | 2024-06-28 |
| 15036 | Blueberry Crumble Muffin 15036 | 70 70 | 450 | 500 | 2024-06-28 |
| 15037 | Chocolate Crumble Muffin 15037 | 70 70 | 450 | 500 | 2024-06-28 |
| 15038 | Pancakes 15038 | 70 70 | 550 | 600 | 2024-06-28 |
| 15039 | Almond Croissant 15039 | 70 70 | 470 | 520 | 2024-06-28 |
| 15040 | Buttery Croissant 15040 | 70 70 | 400 | 430 | 2024-06-28 |
| 15041 | Chocolate Croissant 15041 | 70 70 | 440 | 490 | 2024-06-28 |
| 15042 | Creamy Chicken Foldover 15042 | 70 70 | 550 | 600 | 2024-06-28 |
| 15043 | Sausage Roll 15043 | 70 70 | 550 | 600 | 2024-06-28 |
| 15044 | Buttery Scone 15044 | 70 70 | 400 | 430 | 2024-06-28 |
| 15045 | Country Chicken Pie 15045 | 70 70 | 690 | 740 | 2024-06-28 |
| 15046 | Deep Dish Beef Pie 15046 | 70 70 | 690 | 740 | 2024-06-28 |
| 15047 | Spinach & Mushroom Quiche 15047 | 70 70 | 690 | 740 | 2024-06-28 |
| 15048 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 15048 | 70 70 | 390 | 420 | 2024-06-28 |
| 15049 | Mixed Nuts 15049 | 70 70 | 490 | 540 | 2024-06-28 |
| 15050 | Caramel Waffles 15050 | 70 70 | 390 | 420 | 2024-06-28 |
| 15051 | Chicken Ham & Cheese Panwich 15051 | 70 70 | 690 | 740 | 2024-06-28 |
| 15052 | Egg Mayo & Cheese Multigrain Croissant 15052 | 70 70 | 690 | 740 | 2024-06-28 |
| 15053 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 15053 | 70 70 | 690 | 740 | 2024-06-28 |
| 15054 | Rosemary Chicken & Emmental Cheese Croissant 15054 | 70 70 | 690 | 740 | 2024-06-28 |
| 15055 | Scrambled Egg & Turkey Ham Pita 15055 | 70 70 | 690 | 740 | 2024-06-28 |
| 15056 | Turkey Ham & Triple Cheese Toast 15056 | 70 70 | 690 | 740 | 2024-06-28 |
| 15057 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 15057 | 70 70 | 790 | 840 | 2024-06-28 |
| 15058 | Ham & Cheese Croissant 15058 | 70 70 | 690 | 740 | 2024-06-28 |
| 15059 | Sriracha Chicken Whole Wheat Pita 15059 | 70 70 | 750 | 800 | 2024-06-28 |
| 15060 | Blueberry Acai Yogurt Parfait 15060 | 70 70 | 650 | 700 | 2024-06-28 |
| 15061 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 15061 | 70 70 | 650 | 700 | 2024-06-28 |
| 15062 | Caramel Frappuccino® 15062 | 70 70 | 720 | 770 | 2024-06-28 |
| 15063 | Dark Mocha Frappuccino® 15063 | 70 70 | 780 | 830 | 2024-06-28 |
| 15064 | Java Chip Frappuccino® 15064 | 70 70 | 780 | 830 | 2024-06-28 |
| 15065 | Mocha Frappuccino® 15065 | 70 70 | 720 | 770 | 2024-06-28 |
| 15066 | Caramel Macchiato Frappuccino® 15066 | 70 70 | 780 | 830 | 2024-06-28 |
| 15067 | Espresso Frappuccino® 15067 | 70 70 | 720 | 770 | 2024-06-28 |
| 15068 | White Chocolate Mocha Frappuccino® 15068 | 70 70 | 720 | 770 | 2024-06-28 |
| 15069 | Chocolate Chip Cream Frappuccino® 15069 | 70 70 | 780 | 830 | 2024-06-28 |
| 15070 | Hojicha Tea Cream Frappuccino® 15070 | 70 70 | 760 | 810 | 2024-06-28 |
| 15071 | Vanilla Cream Frappuccino® 15071 | 70 70 | 720 | 770 | 2024-06-28 |
| 15072 | Mango Passion Fruit & Hibiscus 15072 | 70 70 | 720 | 770 | 2024-06-28 |
| 15073 | Raspberry Black Currant & Oolong 15073 | 70 70 | 720 | 770 | 2024-06-28 |
| 15074 | Coffee Traveller 15074 | 70 70 | 3120 | 3170 | 2024-06-28 |
| 15075 | Caffè Americano 15075 | 70 70 | 540 | 590 | 2024-06-28 |
| 15076 | Cappuccino 15076 | 70 70 | 680 | 730 | 2024-06-28 |
| 15077 | Caffè Mocha 15077 | 70 70 | 750 | 800 | 2024-06-28 |
| 15078 | Caramel Macchiato 15078 | 70 70 | 760 | 810 | 2024-06-28 |
| 15079 | Espresso 15079 | 70 70 | 390 | 440 | 2024-06-28 |
| 15080 | Caffè Latte 15080 | 70 70 | 680 | 730 | 2024-06-28 |
| 15081 | Oatmilk Latte 15081 | 70 70 | 760 | 810 | 2024-06-28 |
| 15082 | Vanilla Latte 15082 | 70 70 | 750 | 800 | 2024-06-28 |
| 15083 | White Chocolate Mocha 15083 | 70 70 | 750 | 800 | 2024-06-28 |
| 15084 | Flat White 15084 | 70 70 | 760 | 810 | 2024-06-28 |
| 15085 | Ristretto Bianco 15085 | 70 70 | 760 | 810 | 2024-06-28 |
| 15086 | Iced Caffè Americano 15086 | 70 70 | 540 | 590 | 2024-06-28 |
| 15087 | Iced Cappuccino 15087 | 70 70 | 680 | 730 | 2024-06-28 |
| 15088 | Iced Caffè Mocha 15088 | 70 70 | 750 | 800 | 2024-06-28 |
| 15089 | Iced Caramel Macchiato 15089 | 70 70 | 760 | 810 | 2024-06-28 |
| 15090 | Iced Caffè Latte 15090 | 70 70 | 680 | 730 | 2024-06-28 |
| 15091 | Iced Oatmilk Latte 15091 | 70 70 | 760 | 810 | 2024-06-28 |
| 15092 | Iced Vanilla Latte 15092 | 70 70 | 750 | 800 | 2024-06-28 |
| 15093 | Iced White Chocolate Mocha 15093 | 70 70 | 750 | 800 | 2024-06-28 |
| 15094 | Signature Hot Chocolate 15094 | 70 70 | 720 | 770 | 2024-06-28 |
| 15095 | Signature Iced Chocolate 15095 | 70 70 | 720 | 770 | 2024-06-28 |
| 15096 | Carrot Juice 15096 | 70 70 | 490 | 540 | 2024-06-28 |
| 15097 | Cloudy Apple Juice 15097 | 70 70 | 490 | 540 | 2024-06-28 |
| 15098 | Cranberry Red Grapefruit Juice 15098 | 70 70 | 490 | 540 | 2024-06-28 |
| 15099 | Orange Juice 15099 | 70 70 | 490 | 540 | 2024-06-28 |
| 15100 | Evian 15100 | 70 70 | 350 | 400 | 2024-06-28 |
| 15101 | Sparkling Water 15101 | 70 70 | 450 | 500 | 2024-06-28 |
| 15102 | Chai Tea 15102 | 70 70 | 500 | 550 | 2024-06-28 |
| 15103 | Earl Grey Tea 15103 | 70 70 | 500 | 550 | 2024-06-28 |
| 15104 | English Breakfast Tea 15104 | 70 70 | 500 | 550 | 2024-06-28 |
| 15105 | Emperor’s Clouds & Mist™ Tea 15105 | 70 70 | 500 | 550 | 2024-06-28 |
| 15106 | Mint Blend Tea 15106 | 70 70 | 500 | 550 | 2024-06-28 |
| 15107 | Chamomile Tea 15107 | 70 70 | 500 | 550 | 2024-06-28 |
| 15108 | Pure Matcha Latte 15108 | 70 70 | 740 | 790 | 2024-06-28 |
| 15109 | Chai Tea Latte 15109 | 70 70 | 680 | 730 | 2024-06-28 |
| 15110 | Earl Grey Tea Latte 15110 | 70 70 | 680 | 730 | 2024-06-28 |
| 15111 | English Breakfast Tea Latte 15111 | 70 70 | 680 | 730 | 2024-06-28 |
| 15112 | Hojicha Tea Latte 15112 | 70 70 | 740 | 790 | 2024-06-28 |
| 15113 | Zen Clouds Oolong Tea 15113 | 70 70 | 500 | 550 | 2024-06-28 |
| 15114 | Zen Clouds Oolong with Ruby Grapefruit and Honey 15114 | 70 70 | 630 | 680 | 2024-06-28 |
| 15115 | Youthberry™ Tea 15115 | 70 70 | 500 | 550 | 2024-06-28 |
| 15116 | Iced Shaken Black Tea Lemonade 15116 | 70 70 | 610 | 660 | 2024-06-28 |
| 15117 | Iced Shaken Strawberry Black Tea Lemonade 15117 | 70 70 | 630 | 680 | 2024-06-28 |
| 15118 | Iced Shaken Hibiscus Tea Lemonade 15118 | 70 70 | 610 | 660 | 2024-06-28 |
| 15119 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 15119 | 70 70 | 730 | 780 | 2024-06-28 |
| 15120 | Iced Pure Matcha Latte 15120 | 70 70 | 740 | 790 | 2024-06-28 |
| 15121 | Iced Chai Tea Latte 15121 | 70 70 | 680 | 730 | 2024-06-28 |
| 15122 | Iced Black Tea Latte 15122 | 70 70 | 680 | 730 | 2024-06-28 |
| 15123 | Iced Hojicha Tea Latte 15123 | 70 70 | 740 | 790 | 2024-06-28 |
| 15124 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 15124 | 70 70 | 630 | 680 | 2024-06-28 |
| 15125 | Iced Shaken Zen Clouds Oolong Lemonade 15125 | 70 70 | 610 | 660 | 2024-06-28 |
| 15126 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 15126 | 70 70 | 630 | 680 | 2024-06-28 |
| 15127 | Origami Pike Place® Roast 15127 | 70 70 | 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");