item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 63
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
- 63 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 16131 | Bagel 16131 | 63 63 | 400 | 430 | 2024-06-28 |
| 16132 | Cookie Crumble Cheesecake 16132 | 63 63 | 720 | 770 | 2024-06-28 |
| 16133 | Good Ol' NY Cheesecake 16133 | 63 63 | 720 | 770 | 2024-06-28 |
| 16134 | Signature Chocolate Cake 16134 | 63 63 | 720 | 770 | 2024-06-28 |
| 16135 | Starbucks® Coffee Tiramisu Cake 16135 | 63 63 | 750 | 800 | 2024-06-28 |
| 16136 | Strawberry Shortcake 16136 | 63 63 | 720 | 770 | 2024-06-28 |
| 16137 | Chocolate Chunk Monster Cookie 16137 | 63 63 | 390 | 440 | 2024-06-28 |
| 16138 | Banana Walnut Muffin 16138 | 63 63 | 450 | 500 | 2024-06-28 |
| 16139 | Blueberry Crumble Muffin 16139 | 63 63 | 450 | 500 | 2024-06-28 |
| 16140 | Chocolate Crumble Muffin 16140 | 63 63 | 450 | 500 | 2024-06-28 |
| 16141 | Pancakes 16141 | 63 63 | 550 | 600 | 2024-06-28 |
| 16142 | Almond Croissant 16142 | 63 63 | 470 | 520 | 2024-06-28 |
| 16143 | Buttery Croissant 16143 | 63 63 | 400 | 430 | 2024-06-28 |
| 16144 | Chocolate Croissant 16144 | 63 63 | 440 | 490 | 2024-06-28 |
| 16145 | Creamy Chicken Foldover 16145 | 63 63 | 550 | 600 | 2024-06-28 |
| 16146 | Sausage Roll 16146 | 63 63 | 550 | 600 | 2024-06-28 |
| 16147 | Buttery Scone 16147 | 63 63 | 400 | 430 | 2024-06-28 |
| 16148 | Country Chicken Pie 16148 | 63 63 | 690 | 740 | 2024-06-28 |
| 16149 | Deep Dish Beef Pie 16149 | 63 63 | 690 | 740 | 2024-06-28 |
| 16150 | Spinach & Mushroom Quiche 16150 | 63 63 | 690 | 740 | 2024-06-28 |
| 16151 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 16151 | 63 63 | 390 | 420 | 2024-06-28 |
| 16152 | Mixed Nuts 16152 | 63 63 | 490 | 540 | 2024-06-28 |
| 16153 | Caramel Waffles 16153 | 63 63 | 390 | 420 | 2024-06-28 |
| 16154 | Chicken Ham & Cheese Panwich 16154 | 63 63 | 690 | 740 | 2024-06-28 |
| 16155 | Egg Mayo & Cheese Multigrain Croissant 16155 | 63 63 | 690 | 740 | 2024-06-28 |
| 16156 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 16156 | 63 63 | 690 | 740 | 2024-06-28 |
| 16157 | Rosemary Chicken & Emmental Cheese Croissant 16157 | 63 63 | 690 | 740 | 2024-06-28 |
| 16158 | Scrambled Egg & Turkey Ham Pita 16158 | 63 63 | 690 | 740 | 2024-06-28 |
| 16159 | Turkey Ham & Triple Cheese Toast 16159 | 63 63 | 690 | 740 | 2024-06-28 |
| 16160 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 16160 | 63 63 | 790 | 840 | 2024-06-28 |
| 16161 | Ham & Cheese Croissant 16161 | 63 63 | 690 | 740 | 2024-06-28 |
| 16162 | Sriracha Chicken Whole Wheat Pita 16162 | 63 63 | 750 | 800 | 2024-06-28 |
| 16163 | Blueberry Acai Yogurt Parfait 16163 | 63 63 | 650 | 700 | 2024-06-28 |
| 16164 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 16164 | 63 63 | 650 | 700 | 2024-06-28 |
| 16165 | Caramel Frappuccino® 16165 | 63 63 | 720 | 770 | 2024-06-28 |
| 16166 | Dark Mocha Frappuccino® 16166 | 63 63 | 780 | 830 | 2024-06-28 |
| 16167 | Java Chip Frappuccino® 16167 | 63 63 | 780 | 830 | 2024-06-28 |
| 16168 | Mocha Frappuccino® 16168 | 63 63 | 720 | 770 | 2024-06-28 |
| 16169 | Caramel Macchiato Frappuccino® 16169 | 63 63 | 780 | 830 | 2024-06-28 |
| 16170 | Espresso Frappuccino® 16170 | 63 63 | 720 | 770 | 2024-06-28 |
| 16171 | White Chocolate Mocha Frappuccino® 16171 | 63 63 | 720 | 770 | 2024-06-28 |
| 16172 | Chocolate Chip Cream Frappuccino® 16172 | 63 63 | 780 | 830 | 2024-06-28 |
| 16173 | Hojicha Tea Cream Frappuccino® 16173 | 63 63 | 760 | 810 | 2024-06-28 |
| 16174 | Vanilla Cream Frappuccino® 16174 | 63 63 | 720 | 770 | 2024-06-28 |
| 16175 | Mango Passion Fruit & Hibiscus 16175 | 63 63 | 720 | 770 | 2024-06-28 |
| 16176 | Raspberry Black Currant & Oolong 16176 | 63 63 | 720 | 770 | 2024-06-28 |
| 16177 | Coffee Traveller 16177 | 63 63 | 3120 | 3170 | 2024-06-28 |
| 16178 | Caffè Americano 16178 | 63 63 | 540 | 590 | 2024-06-28 |
| 16179 | Cappuccino 16179 | 63 63 | 680 | 730 | 2024-06-28 |
| 16180 | Caffè Mocha 16180 | 63 63 | 750 | 800 | 2024-06-28 |
| 16181 | Caramel Macchiato 16181 | 63 63 | 760 | 810 | 2024-06-28 |
| 16182 | Espresso 16182 | 63 63 | 390 | 440 | 2024-06-28 |
| 16183 | Caffè Latte 16183 | 63 63 | 680 | 730 | 2024-06-28 |
| 16184 | Oatmilk Latte 16184 | 63 63 | 760 | 810 | 2024-06-28 |
| 16185 | Vanilla Latte 16185 | 63 63 | 750 | 800 | 2024-06-28 |
| 16186 | White Chocolate Mocha 16186 | 63 63 | 750 | 800 | 2024-06-28 |
| 16187 | Flat White 16187 | 63 63 | 760 | 810 | 2024-06-28 |
| 16188 | Ristretto Bianco 16188 | 63 63 | 760 | 810 | 2024-06-28 |
| 16189 | Iced Caffè Americano 16189 | 63 63 | 540 | 590 | 2024-06-28 |
| 16190 | Iced Cappuccino 16190 | 63 63 | 680 | 730 | 2024-06-28 |
| 16191 | Iced Caffè Mocha 16191 | 63 63 | 750 | 800 | 2024-06-28 |
| 16192 | Iced Caramel Macchiato 16192 | 63 63 | 760 | 810 | 2024-06-28 |
| 16193 | Iced Caffè Latte 16193 | 63 63 | 680 | 730 | 2024-06-28 |
| 16194 | Iced Oatmilk Latte 16194 | 63 63 | 760 | 810 | 2024-06-28 |
| 16195 | Iced Vanilla Latte 16195 | 63 63 | 750 | 800 | 2024-06-28 |
| 16196 | Iced White Chocolate Mocha 16196 | 63 63 | 750 | 800 | 2024-06-28 |
| 16197 | Signature Hot Chocolate 16197 | 63 63 | 720 | 770 | 2024-06-28 |
| 16198 | Signature Iced Chocolate 16198 | 63 63 | 720 | 770 | 2024-06-28 |
| 16199 | Carrot Juice 16199 | 63 63 | 490 | 540 | 2024-06-28 |
| 16200 | Cloudy Apple Juice 16200 | 63 63 | 490 | 540 | 2024-06-28 |
| 16201 | Cranberry Red Grapefruit Juice 16201 | 63 63 | 490 | 540 | 2024-06-28 |
| 16202 | Orange Juice 16202 | 63 63 | 490 | 540 | 2024-06-28 |
| 16203 | Evian 16203 | 63 63 | 350 | 400 | 2024-06-28 |
| 16204 | Sparkling Water 16204 | 63 63 | 450 | 500 | 2024-06-28 |
| 16205 | Chai Tea 16205 | 63 63 | 500 | 550 | 2024-06-28 |
| 16206 | Earl Grey Tea 16206 | 63 63 | 500 | 550 | 2024-06-28 |
| 16207 | English Breakfast Tea 16207 | 63 63 | 500 | 550 | 2024-06-28 |
| 16208 | Emperor’s Clouds & Mist™ Tea 16208 | 63 63 | 500 | 550 | 2024-06-28 |
| 16209 | Mint Blend Tea 16209 | 63 63 | 500 | 550 | 2024-06-28 |
| 16210 | Chamomile Tea 16210 | 63 63 | 500 | 550 | 2024-06-28 |
| 16211 | Pure Matcha Latte 16211 | 63 63 | 740 | 790 | 2024-06-28 |
| 16212 | Chai Tea Latte 16212 | 63 63 | 680 | 730 | 2024-06-28 |
| 16213 | Earl Grey Tea Latte 16213 | 63 63 | 680 | 730 | 2024-06-28 |
| 16214 | English Breakfast Tea Latte 16214 | 63 63 | 680 | 730 | 2024-06-28 |
| 16215 | Hojicha Tea Latte 16215 | 63 63 | 740 | 790 | 2024-06-28 |
| 16216 | Zen Clouds Oolong Tea 16216 | 63 63 | 500 | 550 | 2024-06-28 |
| 16217 | Zen Clouds Oolong with Ruby Grapefruit and Honey 16217 | 63 63 | 630 | 680 | 2024-06-28 |
| 16218 | Youthberry™ Tea 16218 | 63 63 | 500 | 550 | 2024-06-28 |
| 16219 | Iced Shaken Black Tea Lemonade 16219 | 63 63 | 610 | 660 | 2024-06-28 |
| 16220 | Iced Shaken Strawberry Black Tea Lemonade 16220 | 63 63 | 630 | 680 | 2024-06-28 |
| 16221 | Iced Shaken Hibiscus Tea Lemonade 16221 | 63 63 | 610 | 660 | 2024-06-28 |
| 16222 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 16222 | 63 63 | 730 | 780 | 2024-06-28 |
| 16223 | Iced Pure Matcha Latte 16223 | 63 63 | 740 | 790 | 2024-06-28 |
| 16224 | Iced Chai Tea Latte 16224 | 63 63 | 680 | 730 | 2024-06-28 |
| 16225 | Iced Black Tea Latte 16225 | 63 63 | 680 | 730 | 2024-06-28 |
| 16226 | Iced Hojicha Tea Latte 16226 | 63 63 | 740 | 790 | 2024-06-28 |
| 16227 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 16227 | 63 63 | 630 | 680 | 2024-06-28 |
| 16228 | Iced Shaken Zen Clouds Oolong Lemonade 16228 | 63 63 | 610 | 660 | 2024-06-28 |
| 16229 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 16229 | 63 63 | 630 | 680 | 2024-06-28 |
| 16230 | Origami Pike Place® Roast 16230 | 63 63 | 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");