item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
229 rows where store_id = 6
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 10
- 2024-06-28 184
- 2024-09-15 10
- 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
- 6 · 229 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 183 | Bagel 183 | 6 6 | 400 | 430 | 2024-06-28 |
| 184 | Cookie Crumble Cheesecake 184 | 6 6 | 720 | 770 | 2024-06-28 |
| 185 | Good Ol' NY Cheesecake 185 | 6 6 | 720 | 770 | 2024-06-28 |
| 186 | Signature Chocolate Cake 186 | 6 6 | 720 | 770 | 2024-06-28 |
| 187 | Starbucks® Coffee Tiramisu Cake 187 | 6 6 | 750 | 800 | 2024-06-28 |
| 188 | Strawberry Shortcake 188 | 6 6 | 720 | 770 | 2024-06-28 |
| 189 | Chocolate Chunk Monster Cookie 189 | 6 6 | 390 | 440 | 2024-06-28 |
| 190 | Banana Walnut Muffin 190 | 6 6 | 450 | 500 | 2024-06-28 |
| 191 | Blueberry Crumble Muffin 191 | 6 6 | 450 | 500 | 2024-06-28 |
| 192 | Chocolate Crumble Muffin 192 | 6 6 | 450 | 500 | 2024-06-28 |
| 193 | Pancakes 193 | 6 6 | 550 | 600 | 2024-06-28 |
| 194 | Almond Croissant 194 | 6 6 | 470 | 520 | 2024-06-28 |
| 195 | Buttery Croissant 195 | 6 6 | 400 | 430 | 2024-06-28 |
| 196 | Chocolate Croissant 196 | 6 6 | 440 | 490 | 2024-06-28 |
| 197 | Creamy Chicken Foldover 197 | 6 6 | 550 | 600 | 2024-06-28 |
| 198 | Sausage Roll 198 | 6 6 | 550 | 600 | 2024-06-28 |
| 199 | Buttery Scone 199 | 6 6 | 400 | 430 | 2024-06-28 |
| 200 | Country Chicken Pie 200 | 6 6 | 690 | 740 | 2024-06-28 |
| 201 | Deep Dish Beef Pie 201 | 6 6 | 690 | 740 | 2024-06-28 |
| 202 | Spinach & Mushroom Quiche 202 | 6 6 | 690 | 740 | 2024-06-28 |
| 203 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 203 | 6 6 | 390 | 420 | 2024-06-28 |
| 204 | Mixed Nuts 204 | 6 6 | 490 | 540 | 2024-06-28 |
| 205 | Caramel Waffles 205 | 6 6 | 390 | 420 | 2024-06-28 |
| 206 | Chicken Ham & Cheese Panwich 206 | 6 6 | 690 | 740 | 2024-06-28 |
| 207 | Egg Mayo & Cheese Multigrain Croissant 207 | 6 6 | 690 | 740 | 2024-06-28 |
| 208 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 208 | 6 6 | 690 | 740 | 2024-06-28 |
| 209 | Rosemary Chicken & Emmental Cheese Croissant 209 | 6 6 | 690 | 740 | 2024-06-28 |
| 210 | Scrambled Egg & Turkey Ham Pita 210 | 6 6 | 690 | 740 | 2024-06-28 |
| 211 | Turkey Ham & Triple Cheese Toast 211 | 6 6 | 690 | 740 | 2024-06-28 |
| 212 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 212 | 6 6 | 790 | 840 | 2024-06-28 |
| 213 | Ham & Cheese Croissant 213 | 6 6 | 690 | 740 | 2024-06-28 |
| 214 | Sriracha Chicken Whole Wheat Pita 214 | 6 6 | 750 | 800 | 2024-06-28 |
| 215 | Blueberry Acai Yogurt Parfait 215 | 6 6 | 650 | 700 | 2024-06-28 |
| 216 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 216 | 6 6 | 650 | 700 | 2024-06-28 |
| 217 | Caramel Frappuccino® 217 | 6 6 | 720 | 770 | 2024-06-28 |
| 218 | Dark Mocha Frappuccino® 218 | 6 6 | 780 | 830 | 2024-06-28 |
| 219 | Java Chip Frappuccino® 219 | 6 6 | 780 | 830 | 2024-06-28 |
| 220 | Mocha Frappuccino® 220 | 6 6 | 720 | 770 | 2024-06-28 |
| 221 | Caramel Macchiato Frappuccino® 221 | 6 6 | 780 | 830 | 2024-06-28 |
| 222 | Espresso Frappuccino® 222 | 6 6 | 720 | 770 | 2024-06-28 |
| 223 | White Chocolate Mocha Frappuccino® 223 | 6 6 | 720 | 770 | 2024-06-28 |
| 224 | Chocolate Chip Cream Frappuccino® 224 | 6 6 | 780 | 830 | 2024-06-28 |
| 225 | Hojicha Tea Cream Frappuccino® 225 | 6 6 | 760 | 810 | 2024-06-28 |
| 226 | Vanilla Cream Frappuccino® 226 | 6 6 | 720 | 770 | 2024-06-28 |
| 227 | Mango Passion Fruit & Hibiscus 227 | 6 6 | 720 | 770 | 2024-06-28 |
| 228 | Raspberry Black Currant & Oolong 228 | 6 6 | 720 | 770 | 2024-06-28 |
| 229 | Coffee Traveller 229 | 6 6 | 3120 | 3170 | 2024-06-28 |
| 230 | Caffè Americano 230 | 6 6 | 540 | 590 | 2024-06-28 |
| 231 | Cappuccino 231 | 6 6 | 680 | 730 | 2024-06-28 |
| 232 | Caffè Mocha 232 | 6 6 | 750 | 800 | 2024-06-28 |
| 233 | Caramel Macchiato 233 | 6 6 | 760 | 810 | 2024-06-28 |
| 234 | Espresso 234 | 6 6 | 390 | 440 | 2024-06-28 |
| 235 | Caffè Latte 235 | 6 6 | 680 | 730 | 2024-06-28 |
| 236 | Oatmilk Latte 236 | 6 6 | 760 | 810 | 2024-06-28 |
| 237 | Vanilla Latte 237 | 6 6 | 750 | 800 | 2024-06-28 |
| 238 | White Chocolate Mocha 238 | 6 6 | 750 | 800 | 2024-06-28 |
| 239 | Flat White 239 | 6 6 | 760 | 810 | 2024-06-28 |
| 240 | Ristretto Bianco 240 | 6 6 | 760 | 810 | 2024-06-28 |
| 241 | Iced Caffè Americano 241 | 6 6 | 540 | 590 | 2024-06-28 |
| 242 | Iced Cappuccino 242 | 6 6 | 680 | 730 | 2024-06-28 |
| 243 | Iced Caffè Mocha 243 | 6 6 | 750 | 800 | 2024-06-28 |
| 244 | Iced Caramel Macchiato 244 | 6 6 | 760 | 810 | 2024-06-28 |
| 245 | Iced Caffè Latte 245 | 6 6 | 680 | 730 | 2024-06-28 |
| 246 | Iced Oatmilk Latte 246 | 6 6 | 760 | 810 | 2024-06-28 |
| 247 | Iced Vanilla Latte 247 | 6 6 | 750 | 800 | 2024-06-28 |
| 248 | Iced White Chocolate Mocha 248 | 6 6 | 750 | 800 | 2024-06-28 |
| 249 | Signature Hot Chocolate 249 | 6 6 | 720 | 770 | 2024-06-28 |
| 250 | Signature Iced Chocolate 250 | 6 6 | 720 | 770 | 2024-06-28 |
| 251 | Carrot Juice 251 | 6 6 | 490 | 540 | 2024-06-28 |
| 252 | Cloudy Apple Juice 252 | 6 6 | 490 | 540 | 2024-06-28 |
| 253 | Cranberry Red Grapefruit Juice 253 | 6 6 | 490 | 540 | 2024-06-28 |
| 254 | Orange Juice 254 | 6 6 | 490 | 540 | 2024-06-28 |
| 255 | Evian 255 | 6 6 | 350 | 400 | 2024-06-28 |
| 256 | Sparkling Water 256 | 6 6 | 450 | 500 | 2024-06-28 |
| 257 | Chai Tea 257 | 6 6 | 500 | 550 | 2024-06-28 |
| 258 | Earl Grey Tea 258 | 6 6 | 500 | 550 | 2024-06-28 |
| 259 | English Breakfast Tea 259 | 6 6 | 500 | 550 | 2024-06-28 |
| 260 | Emperor’s Clouds & Mist™ Tea 260 | 6 6 | 500 | 550 | 2024-06-28 |
| 261 | Mint Blend Tea 261 | 6 6 | 500 | 550 | 2024-06-28 |
| 262 | Chamomile Tea 262 | 6 6 | 500 | 550 | 2024-06-28 |
| 263 | Pure Matcha Latte 263 | 6 6 | 740 | 790 | 2024-06-28 |
| 264 | Chai Tea Latte 264 | 6 6 | 680 | 730 | 2024-06-28 |
| 265 | Earl Grey Tea Latte 265 | 6 6 | 680 | 730 | 2024-06-28 |
| 266 | English Breakfast Tea Latte 266 | 6 6 | 680 | 730 | 2024-06-28 |
| 267 | Hojicha Tea Latte 267 | 6 6 | 740 | 790 | 2024-06-28 |
| 268 | Zen Clouds Oolong Tea 268 | 6 6 | 500 | 550 | 2024-06-28 |
| 269 | Zen Clouds Oolong with Ruby Grapefruit and Honey 269 | 6 6 | 630 | 680 | 2024-06-28 |
| 270 | Youthberry™ Tea 270 | 6 6 | 500 | 550 | 2024-06-28 |
| 271 | Iced Shaken Black Tea Lemonade 271 | 6 6 | 610 | 660 | 2024-06-28 |
| 272 | Iced Shaken Strawberry Black Tea Lemonade 272 | 6 6 | 630 | 680 | 2024-06-28 |
| 273 | Iced Shaken Hibiscus Tea Lemonade 273 | 6 6 | 610 | 660 | 2024-06-28 |
| 274 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 274 | 6 6 | 730 | 780 | 2024-06-28 |
| 275 | Iced Pure Matcha Latte 275 | 6 6 | 740 | 790 | 2024-06-28 |
| 276 | Iced Chai Tea Latte 276 | 6 6 | 680 | 730 | 2024-06-28 |
| 277 | Iced Black Tea Latte 277 | 6 6 | 680 | 730 | 2024-06-28 |
| 278 | Iced Hojicha Tea Latte 278 | 6 6 | 740 | 790 | 2024-06-28 |
| 279 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 279 | 6 6 | 630 | 680 | 2024-06-28 |
| 280 | Iced Shaken Zen Clouds Oolong Lemonade 280 | 6 6 | 610 | 660 | 2024-06-28 |
| 281 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 281 | 6 6 | 630 | 680 | 2024-06-28 |
| 282 | Origami Pike Place® Roast 282 | 6 6 | 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");