item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
238 rows where store_id = 9
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 184
- 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
- 9 · 238 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 25099 | Bagel 25099 | 9 9 | 400 | 430 | 2024-06-28 |
| 25100 | Cookie Crumble Cheesecake 25100 | 9 9 | 720 | 770 | 2024-06-28 |
| 25101 | Good Ol' NY Cheesecake 25101 | 9 9 | 720 | 770 | 2024-06-28 |
| 25102 | Signature Chocolate Cake 25102 | 9 9 | 720 | 770 | 2024-06-28 |
| 25103 | Starbucks® Coffee Tiramisu Cake 25103 | 9 9 | 750 | 800 | 2024-06-28 |
| 25104 | Strawberry Shortcake 25104 | 9 9 | 720 | 770 | 2024-06-28 |
| 25105 | Chocolate Chunk Monster Cookie 25105 | 9 9 | 390 | 440 | 2024-06-28 |
| 25106 | Banana Walnut Muffin 25106 | 9 9 | 450 | 500 | 2024-06-28 |
| 25107 | Blueberry Crumble Muffin 25107 | 9 9 | 450 | 500 | 2024-06-28 |
| 25108 | Chocolate Crumble Muffin 25108 | 9 9 | 450 | 500 | 2024-06-28 |
| 25109 | Pancakes 25109 | 9 9 | 550 | 600 | 2024-06-28 |
| 25110 | Almond Croissant 25110 | 9 9 | 470 | 520 | 2024-06-28 |
| 25111 | Buttery Croissant 25111 | 9 9 | 400 | 430 | 2024-06-28 |
| 25112 | Chocolate Croissant 25112 | 9 9 | 440 | 490 | 2024-06-28 |
| 25113 | Creamy Chicken Foldover 25113 | 9 9 | 550 | 600 | 2024-06-28 |
| 25114 | Sausage Roll 25114 | 9 9 | 550 | 600 | 2024-06-28 |
| 25115 | Buttery Scone 25115 | 9 9 | 400 | 430 | 2024-06-28 |
| 25116 | Country Chicken Pie 25116 | 9 9 | 690 | 740 | 2024-06-28 |
| 25117 | Deep Dish Beef Pie 25117 | 9 9 | 690 | 740 | 2024-06-28 |
| 25118 | Spinach & Mushroom Quiche 25118 | 9 9 | 690 | 740 | 2024-06-28 |
| 25119 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 25119 | 9 9 | 390 | 420 | 2024-06-28 |
| 25120 | Mixed Nuts 25120 | 9 9 | 490 | 540 | 2024-06-28 |
| 25121 | Caramel Waffles 25121 | 9 9 | 390 | 420 | 2024-06-28 |
| 25122 | Chicken Ham & Cheese Panwich 25122 | 9 9 | 690 | 740 | 2024-06-28 |
| 25123 | Egg Mayo & Cheese Multigrain Croissant 25123 | 9 9 | 690 | 740 | 2024-06-28 |
| 25124 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 25124 | 9 9 | 690 | 740 | 2024-06-28 |
| 25125 | Rosemary Chicken & Emmental Cheese Croissant 25125 | 9 9 | 690 | 740 | 2024-06-28 |
| 25126 | Scrambled Egg & Turkey Ham Pita 25126 | 9 9 | 690 | 740 | 2024-06-28 |
| 25127 | Turkey Ham & Triple Cheese Toast 25127 | 9 9 | 690 | 740 | 2024-06-28 |
| 25128 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 25128 | 9 9 | 790 | 840 | 2024-06-28 |
| 25129 | Ham & Cheese Croissant 25129 | 9 9 | 690 | 740 | 2024-06-28 |
| 25130 | Sriracha Chicken Whole Wheat Pita 25130 | 9 9 | 750 | 800 | 2024-06-28 |
| 25131 | Blueberry Acai Yogurt Parfait 25131 | 9 9 | 650 | 700 | 2024-06-28 |
| 25132 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 25132 | 9 9 | 650 | 700 | 2024-06-28 |
| 25133 | Caramel Frappuccino® 25133 | 9 9 | 720 | 770 | 2024-06-28 |
| 25134 | Dark Mocha Frappuccino® 25134 | 9 9 | 780 | 830 | 2024-06-28 |
| 25135 | Java Chip Frappuccino® 25135 | 9 9 | 780 | 830 | 2024-06-28 |
| 25136 | Mocha Frappuccino® 25136 | 9 9 | 720 | 770 | 2024-06-28 |
| 25137 | Caramel Macchiato Frappuccino® 25137 | 9 9 | 780 | 830 | 2024-06-28 |
| 25138 | Espresso Frappuccino® 25138 | 9 9 | 720 | 770 | 2024-06-28 |
| 25139 | White Chocolate Mocha Frappuccino® 25139 | 9 9 | 720 | 770 | 2024-06-28 |
| 25140 | Chocolate Chip Cream Frappuccino® 25140 | 9 9 | 780 | 830 | 2024-06-28 |
| 25141 | Hojicha Tea Cream Frappuccino® 25141 | 9 9 | 760 | 810 | 2024-06-28 |
| 25142 | Vanilla Cream Frappuccino® 25142 | 9 9 | 720 | 770 | 2024-06-28 |
| 25143 | Mango Passion Fruit & Hibiscus 25143 | 9 9 | 720 | 770 | 2024-06-28 |
| 25144 | Raspberry Black Currant & Oolong 25144 | 9 9 | 720 | 770 | 2024-06-28 |
| 25145 | Coffee Traveller 25145 | 9 9 | 3120 | 3170 | 2024-06-28 |
| 25146 | Caffè Americano 25146 | 9 9 | 540 | 590 | 2024-06-28 |
| 25147 | Cappuccino 25147 | 9 9 | 680 | 730 | 2024-06-28 |
| 25148 | Caffè Mocha 25148 | 9 9 | 750 | 800 | 2024-06-28 |
| 25149 | Caramel Macchiato 25149 | 9 9 | 760 | 810 | 2024-06-28 |
| 25150 | Espresso 25150 | 9 9 | 390 | 440 | 2024-06-28 |
| 25151 | Caffè Latte 25151 | 9 9 | 680 | 730 | 2024-06-28 |
| 25152 | Oatmilk Latte 25152 | 9 9 | 760 | 810 | 2024-06-28 |
| 25153 | Vanilla Latte 25153 | 9 9 | 750 | 800 | 2024-06-28 |
| 25154 | White Chocolate Mocha 25154 | 9 9 | 750 | 800 | 2024-06-28 |
| 25155 | Flat White 25155 | 9 9 | 760 | 810 | 2024-06-28 |
| 25156 | Ristretto Bianco 25156 | 9 9 | 760 | 810 | 2024-06-28 |
| 25157 | Iced Caffè Americano 25157 | 9 9 | 540 | 590 | 2024-06-28 |
| 25158 | Iced Cappuccino 25158 | 9 9 | 680 | 730 | 2024-06-28 |
| 25159 | Iced Caffè Mocha 25159 | 9 9 | 750 | 800 | 2024-06-28 |
| 25160 | Iced Caramel Macchiato 25160 | 9 9 | 760 | 810 | 2024-06-28 |
| 25161 | Iced Caffè Latte 25161 | 9 9 | 680 | 730 | 2024-06-28 |
| 25162 | Iced Oatmilk Latte 25162 | 9 9 | 760 | 810 | 2024-06-28 |
| 25163 | Iced Vanilla Latte 25163 | 9 9 | 750 | 800 | 2024-06-28 |
| 25164 | Iced White Chocolate Mocha 25164 | 9 9 | 750 | 800 | 2024-06-28 |
| 25165 | Signature Hot Chocolate 25165 | 9 9 | 720 | 770 | 2024-06-28 |
| 25166 | Signature Iced Chocolate 25166 | 9 9 | 720 | 770 | 2024-06-28 |
| 25167 | Carrot Juice 25167 | 9 9 | 490 | 540 | 2024-06-28 |
| 25168 | Cloudy Apple Juice 25168 | 9 9 | 490 | 540 | 2024-06-28 |
| 25169 | Cranberry Red Grapefruit Juice 25169 | 9 9 | 490 | 540 | 2024-06-28 |
| 25170 | Orange Juice 25170 | 9 9 | 490 | 540 | 2024-06-28 |
| 25171 | Evian 25171 | 9 9 | 350 | 400 | 2024-06-28 |
| 25172 | Sparkling Water 25172 | 9 9 | 450 | 500 | 2024-06-28 |
| 25173 | Chai Tea 25173 | 9 9 | 500 | 550 | 2024-06-28 |
| 25174 | Earl Grey Tea 25174 | 9 9 | 500 | 550 | 2024-06-28 |
| 25175 | English Breakfast Tea 25175 | 9 9 | 500 | 550 | 2024-06-28 |
| 25176 | Emperor’s Clouds & Mist™ Tea 25176 | 9 9 | 500 | 550 | 2024-06-28 |
| 25177 | Mint Blend Tea 25177 | 9 9 | 500 | 550 | 2024-06-28 |
| 25178 | Chamomile Tea 25178 | 9 9 | 500 | 550 | 2024-06-28 |
| 25179 | Pure Matcha Latte 25179 | 9 9 | 740 | 790 | 2024-06-28 |
| 25180 | Chai Tea Latte 25180 | 9 9 | 680 | 730 | 2024-06-28 |
| 25181 | Earl Grey Tea Latte 25181 | 9 9 | 680 | 730 | 2024-06-28 |
| 25182 | English Breakfast Tea Latte 25182 | 9 9 | 680 | 730 | 2024-06-28 |
| 25183 | Hojicha Tea Latte 25183 | 9 9 | 740 | 790 | 2024-06-28 |
| 25184 | Zen Clouds Oolong Tea 25184 | 9 9 | 500 | 550 | 2024-06-28 |
| 25185 | Zen Clouds Oolong with Ruby Grapefruit and Honey 25185 | 9 9 | 630 | 680 | 2024-06-28 |
| 25186 | Youthberry™ Tea 25186 | 9 9 | 500 | 550 | 2024-06-28 |
| 25187 | Iced Shaken Black Tea Lemonade 25187 | 9 9 | 610 | 660 | 2024-06-28 |
| 25188 | Iced Shaken Strawberry Black Tea Lemonade 25188 | 9 9 | 630 | 680 | 2024-06-28 |
| 25189 | Iced Shaken Hibiscus Tea Lemonade 25189 | 9 9 | 610 | 660 | 2024-06-28 |
| 25190 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 25190 | 9 9 | 730 | 780 | 2024-06-28 |
| 25191 | Iced Pure Matcha Latte 25191 | 9 9 | 740 | 790 | 2024-06-28 |
| 25192 | Iced Chai Tea Latte 25192 | 9 9 | 680 | 730 | 2024-06-28 |
| 25193 | Iced Black Tea Latte 25193 | 9 9 | 680 | 730 | 2024-06-28 |
| 25194 | Iced Hojicha Tea Latte 25194 | 9 9 | 740 | 790 | 2024-06-28 |
| 25195 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 25195 | 9 9 | 630 | 680 | 2024-06-28 |
| 25196 | Iced Shaken Zen Clouds Oolong Lemonade 25196 | 9 9 | 610 | 660 | 2024-06-28 |
| 25197 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 25197 | 9 9 | 630 | 680 | 2024-06-28 |
| 25198 | Origami Pike Place® Roast 25198 | 9 9 | 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");