item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
238 rows where store_id = 77
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
- 77 · 238 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 14116 | Bagel 14116 | 77 77 | 400 | 430 | 2024-06-28 |
| 14117 | Cookie Crumble Cheesecake 14117 | 77 77 | 720 | 770 | 2024-06-28 |
| 14118 | Good Ol' NY Cheesecake 14118 | 77 77 | 720 | 770 | 2024-06-28 |
| 14119 | Signature Chocolate Cake 14119 | 77 77 | 720 | 770 | 2024-06-28 |
| 14120 | Starbucks® Coffee Tiramisu Cake 14120 | 77 77 | 750 | 800 | 2024-06-28 |
| 14121 | Strawberry Shortcake 14121 | 77 77 | 720 | 770 | 2024-06-28 |
| 14122 | Chocolate Chunk Monster Cookie 14122 | 77 77 | 390 | 440 | 2024-06-28 |
| 14123 | Banana Walnut Muffin 14123 | 77 77 | 450 | 500 | 2024-06-28 |
| 14124 | Blueberry Crumble Muffin 14124 | 77 77 | 450 | 500 | 2024-06-28 |
| 14125 | Chocolate Crumble Muffin 14125 | 77 77 | 450 | 500 | 2024-06-28 |
| 14126 | Pancakes 14126 | 77 77 | 550 | 600 | 2024-06-28 |
| 14127 | Almond Croissant 14127 | 77 77 | 470 | 520 | 2024-06-28 |
| 14128 | Buttery Croissant 14128 | 77 77 | 400 | 430 | 2024-06-28 |
| 14129 | Chocolate Croissant 14129 | 77 77 | 440 | 490 | 2024-06-28 |
| 14130 | Creamy Chicken Foldover 14130 | 77 77 | 550 | 600 | 2024-06-28 |
| 14131 | Sausage Roll 14131 | 77 77 | 550 | 600 | 2024-06-28 |
| 14132 | Buttery Scone 14132 | 77 77 | 400 | 430 | 2024-06-28 |
| 14133 | Country Chicken Pie 14133 | 77 77 | 690 | 740 | 2024-06-28 |
| 14134 | Deep Dish Beef Pie 14134 | 77 77 | 690 | 740 | 2024-06-28 |
| 14135 | Spinach & Mushroom Quiche 14135 | 77 77 | 690 | 740 | 2024-06-28 |
| 14136 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 14136 | 77 77 | 390 | 420 | 2024-06-28 |
| 14137 | Mixed Nuts 14137 | 77 77 | 490 | 540 | 2024-06-28 |
| 14138 | Caramel Waffles 14138 | 77 77 | 390 | 420 | 2024-06-28 |
| 14139 | Chicken Ham & Cheese Panwich 14139 | 77 77 | 690 | 740 | 2024-06-28 |
| 14140 | Egg Mayo & Cheese Multigrain Croissant 14140 | 77 77 | 690 | 740 | 2024-06-28 |
| 14141 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 14141 | 77 77 | 690 | 740 | 2024-06-28 |
| 14142 | Rosemary Chicken & Emmental Cheese Croissant 14142 | 77 77 | 690 | 740 | 2024-06-28 |
| 14143 | Scrambled Egg & Turkey Ham Pita 14143 | 77 77 | 690 | 740 | 2024-06-28 |
| 14144 | Turkey Ham & Triple Cheese Toast 14144 | 77 77 | 690 | 740 | 2024-06-28 |
| 14145 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 14145 | 77 77 | 790 | 840 | 2024-06-28 |
| 14146 | Ham & Cheese Croissant 14146 | 77 77 | 690 | 740 | 2024-06-28 |
| 14147 | Sriracha Chicken Whole Wheat Pita 14147 | 77 77 | 750 | 800 | 2024-06-28 |
| 14148 | Blueberry Acai Yogurt Parfait 14148 | 77 77 | 650 | 700 | 2024-06-28 |
| 14149 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 14149 | 77 77 | 650 | 700 | 2024-06-28 |
| 14150 | Caramel Frappuccino® 14150 | 77 77 | 720 | 770 | 2024-06-28 |
| 14151 | Dark Mocha Frappuccino® 14151 | 77 77 | 780 | 830 | 2024-06-28 |
| 14152 | Java Chip Frappuccino® 14152 | 77 77 | 780 | 830 | 2024-06-28 |
| 14153 | Mocha Frappuccino® 14153 | 77 77 | 720 | 770 | 2024-06-28 |
| 14154 | Caramel Macchiato Frappuccino® 14154 | 77 77 | 780 | 830 | 2024-06-28 |
| 14155 | Espresso Frappuccino® 14155 | 77 77 | 720 | 770 | 2024-06-28 |
| 14156 | White Chocolate Mocha Frappuccino® 14156 | 77 77 | 720 | 770 | 2024-06-28 |
| 14157 | Chocolate Chip Cream Frappuccino® 14157 | 77 77 | 780 | 830 | 2024-06-28 |
| 14158 | Hojicha Tea Cream Frappuccino® 14158 | 77 77 | 760 | 810 | 2024-06-28 |
| 14159 | Vanilla Cream Frappuccino® 14159 | 77 77 | 720 | 770 | 2024-06-28 |
| 14160 | Mango Passion Fruit & Hibiscus 14160 | 77 77 | 720 | 770 | 2024-06-28 |
| 14161 | Raspberry Black Currant & Oolong 14161 | 77 77 | 720 | 770 | 2024-06-28 |
| 14162 | Coffee Traveller 14162 | 77 77 | 3120 | 3170 | 2024-06-28 |
| 14163 | Caffè Americano 14163 | 77 77 | 540 | 590 | 2024-06-28 |
| 14164 | Cappuccino 14164 | 77 77 | 680 | 730 | 2024-06-28 |
| 14165 | Caffè Mocha 14165 | 77 77 | 750 | 800 | 2024-06-28 |
| 14166 | Caramel Macchiato 14166 | 77 77 | 760 | 810 | 2024-06-28 |
| 14167 | Espresso 14167 | 77 77 | 390 | 440 | 2024-06-28 |
| 14168 | Caffè Latte 14168 | 77 77 | 680 | 730 | 2024-06-28 |
| 14169 | Oatmilk Latte 14169 | 77 77 | 760 | 810 | 2024-06-28 |
| 14170 | Vanilla Latte 14170 | 77 77 | 750 | 800 | 2024-06-28 |
| 14171 | White Chocolate Mocha 14171 | 77 77 | 750 | 800 | 2024-06-28 |
| 14172 | Flat White 14172 | 77 77 | 760 | 810 | 2024-06-28 |
| 14173 | Ristretto Bianco 14173 | 77 77 | 760 | 810 | 2024-06-28 |
| 14174 | Iced Caffè Americano 14174 | 77 77 | 540 | 590 | 2024-06-28 |
| 14175 | Iced Cappuccino 14175 | 77 77 | 680 | 730 | 2024-06-28 |
| 14176 | Iced Caffè Mocha 14176 | 77 77 | 750 | 800 | 2024-06-28 |
| 14177 | Iced Caramel Macchiato 14177 | 77 77 | 760 | 810 | 2024-06-28 |
| 14178 | Iced Caffè Latte 14178 | 77 77 | 680 | 730 | 2024-06-28 |
| 14179 | Iced Oatmilk Latte 14179 | 77 77 | 760 | 810 | 2024-06-28 |
| 14180 | Iced Vanilla Latte 14180 | 77 77 | 750 | 800 | 2024-06-28 |
| 14181 | Iced White Chocolate Mocha 14181 | 77 77 | 750 | 800 | 2024-06-28 |
| 14182 | Signature Hot Chocolate 14182 | 77 77 | 720 | 770 | 2024-06-28 |
| 14183 | Signature Iced Chocolate 14183 | 77 77 | 720 | 770 | 2024-06-28 |
| 14184 | Carrot Juice 14184 | 77 77 | 490 | 540 | 2024-06-28 |
| 14185 | Cloudy Apple Juice 14185 | 77 77 | 490 | 540 | 2024-06-28 |
| 14186 | Cranberry Red Grapefruit Juice 14186 | 77 77 | 490 | 540 | 2024-06-28 |
| 14187 | Orange Juice 14187 | 77 77 | 490 | 540 | 2024-06-28 |
| 14188 | Evian 14188 | 77 77 | 350 | 400 | 2024-06-28 |
| 14189 | Sparkling Water 14189 | 77 77 | 450 | 500 | 2024-06-28 |
| 14190 | Chai Tea 14190 | 77 77 | 500 | 550 | 2024-06-28 |
| 14191 | Earl Grey Tea 14191 | 77 77 | 500 | 550 | 2024-06-28 |
| 14192 | English Breakfast Tea 14192 | 77 77 | 500 | 550 | 2024-06-28 |
| 14193 | Emperor’s Clouds & Mist™ Tea 14193 | 77 77 | 500 | 550 | 2024-06-28 |
| 14194 | Mint Blend Tea 14194 | 77 77 | 500 | 550 | 2024-06-28 |
| 14195 | Chamomile Tea 14195 | 77 77 | 500 | 550 | 2024-06-28 |
| 14196 | Pure Matcha Latte 14196 | 77 77 | 740 | 790 | 2024-06-28 |
| 14197 | Chai Tea Latte 14197 | 77 77 | 680 | 730 | 2024-06-28 |
| 14198 | Earl Grey Tea Latte 14198 | 77 77 | 680 | 730 | 2024-06-28 |
| 14199 | English Breakfast Tea Latte 14199 | 77 77 | 680 | 730 | 2024-06-28 |
| 14200 | Hojicha Tea Latte 14200 | 77 77 | 740 | 790 | 2024-06-28 |
| 14201 | Zen Clouds Oolong Tea 14201 | 77 77 | 500 | 550 | 2024-06-28 |
| 14202 | Zen Clouds Oolong with Ruby Grapefruit and Honey 14202 | 77 77 | 630 | 680 | 2024-06-28 |
| 14203 | Youthberry™ Tea 14203 | 77 77 | 500 | 550 | 2024-06-28 |
| 14204 | Iced Shaken Black Tea Lemonade 14204 | 77 77 | 610 | 660 | 2024-06-28 |
| 14205 | Iced Shaken Strawberry Black Tea Lemonade 14205 | 77 77 | 630 | 680 | 2024-06-28 |
| 14206 | Iced Shaken Hibiscus Tea Lemonade 14206 | 77 77 | 610 | 660 | 2024-06-28 |
| 14207 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 14207 | 77 77 | 730 | 780 | 2024-06-28 |
| 14208 | Iced Pure Matcha Latte 14208 | 77 77 | 740 | 790 | 2024-06-28 |
| 14209 | Iced Chai Tea Latte 14209 | 77 77 | 680 | 730 | 2024-06-28 |
| 14210 | Iced Black Tea Latte 14210 | 77 77 | 680 | 730 | 2024-06-28 |
| 14211 | Iced Hojicha Tea Latte 14211 | 77 77 | 740 | 790 | 2024-06-28 |
| 14212 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 14212 | 77 77 | 630 | 680 | 2024-06-28 |
| 14213 | Iced Shaken Zen Clouds Oolong Lemonade 14213 | 77 77 | 610 | 660 | 2024-06-28 |
| 14214 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 14214 | 77 77 | 630 | 680 | 2024-06-28 |
| 14215 | Origami Pike Place® Roast 14215 | 77 77 | 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");