item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 62
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
- 62 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 16313 | Bagel 16313 | 62 62 | 400 | 430 | 2024-06-28 |
| 16314 | Cookie Crumble Cheesecake 16314 | 62 62 | 720 | 770 | 2024-06-28 |
| 16315 | Good Ol' NY Cheesecake 16315 | 62 62 | 720 | 770 | 2024-06-28 |
| 16316 | Signature Chocolate Cake 16316 | 62 62 | 720 | 770 | 2024-06-28 |
| 16317 | Starbucks® Coffee Tiramisu Cake 16317 | 62 62 | 750 | 800 | 2024-06-28 |
| 16318 | Strawberry Shortcake 16318 | 62 62 | 720 | 770 | 2024-06-28 |
| 16319 | Chocolate Chunk Monster Cookie 16319 | 62 62 | 390 | 440 | 2024-06-28 |
| 16320 | Banana Walnut Muffin 16320 | 62 62 | 450 | 500 | 2024-06-28 |
| 16321 | Blueberry Crumble Muffin 16321 | 62 62 | 450 | 500 | 2024-06-28 |
| 16322 | Chocolate Crumble Muffin 16322 | 62 62 | 450 | 500 | 2024-06-28 |
| 16323 | Pancakes 16323 | 62 62 | 550 | 600 | 2024-06-28 |
| 16324 | Almond Croissant 16324 | 62 62 | 470 | 520 | 2024-06-28 |
| 16325 | Buttery Croissant 16325 | 62 62 | 400 | 430 | 2024-06-28 |
| 16326 | Chocolate Croissant 16326 | 62 62 | 440 | 490 | 2024-06-28 |
| 16327 | Creamy Chicken Foldover 16327 | 62 62 | 550 | 600 | 2024-06-28 |
| 16328 | Sausage Roll 16328 | 62 62 | 550 | 600 | 2024-06-28 |
| 16329 | Buttery Scone 16329 | 62 62 | 400 | 430 | 2024-06-28 |
| 16330 | Country Chicken Pie 16330 | 62 62 | 690 | 740 | 2024-06-28 |
| 16331 | Deep Dish Beef Pie 16331 | 62 62 | 690 | 740 | 2024-06-28 |
| 16332 | Spinach & Mushroom Quiche 16332 | 62 62 | 690 | 740 | 2024-06-28 |
| 16333 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 16333 | 62 62 | 390 | 420 | 2024-06-28 |
| 16334 | Mixed Nuts 16334 | 62 62 | 490 | 540 | 2024-06-28 |
| 16335 | Caramel Waffles 16335 | 62 62 | 390 | 420 | 2024-06-28 |
| 16336 | Chicken Ham & Cheese Panwich 16336 | 62 62 | 690 | 740 | 2024-06-28 |
| 16337 | Egg Mayo & Cheese Multigrain Croissant 16337 | 62 62 | 690 | 740 | 2024-06-28 |
| 16338 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 16338 | 62 62 | 690 | 740 | 2024-06-28 |
| 16339 | Rosemary Chicken & Emmental Cheese Croissant 16339 | 62 62 | 690 | 740 | 2024-06-28 |
| 16340 | Scrambled Egg & Turkey Ham Pita 16340 | 62 62 | 690 | 740 | 2024-06-28 |
| 16341 | Turkey Ham & Triple Cheese Toast 16341 | 62 62 | 690 | 740 | 2024-06-28 |
| 16342 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 16342 | 62 62 | 790 | 840 | 2024-06-28 |
| 16343 | Ham & Cheese Croissant 16343 | 62 62 | 690 | 740 | 2024-06-28 |
| 16344 | Sriracha Chicken Whole Wheat Pita 16344 | 62 62 | 750 | 800 | 2024-06-28 |
| 16345 | Blueberry Acai Yogurt Parfait 16345 | 62 62 | 650 | 700 | 2024-06-28 |
| 16346 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 16346 | 62 62 | 650 | 700 | 2024-06-28 |
| 16347 | Caramel Frappuccino® 16347 | 62 62 | 720 | 770 | 2024-06-28 |
| 16348 | Dark Mocha Frappuccino® 16348 | 62 62 | 780 | 830 | 2024-06-28 |
| 16349 | Java Chip Frappuccino® 16349 | 62 62 | 780 | 830 | 2024-06-28 |
| 16350 | Mocha Frappuccino® 16350 | 62 62 | 720 | 770 | 2024-06-28 |
| 16351 | Caramel Macchiato Frappuccino® 16351 | 62 62 | 780 | 830 | 2024-06-28 |
| 16352 | Espresso Frappuccino® 16352 | 62 62 | 720 | 770 | 2024-06-28 |
| 16353 | White Chocolate Mocha Frappuccino® 16353 | 62 62 | 720 | 770 | 2024-06-28 |
| 16354 | Chocolate Chip Cream Frappuccino® 16354 | 62 62 | 780 | 830 | 2024-06-28 |
| 16355 | Hojicha Tea Cream Frappuccino® 16355 | 62 62 | 760 | 810 | 2024-06-28 |
| 16356 | Vanilla Cream Frappuccino® 16356 | 62 62 | 720 | 770 | 2024-06-28 |
| 16357 | Mango Passion Fruit & Hibiscus 16357 | 62 62 | 720 | 770 | 2024-06-28 |
| 16358 | Raspberry Black Currant & Oolong 16358 | 62 62 | 720 | 770 | 2024-06-28 |
| 16359 | Coffee Traveller 16359 | 62 62 | 3120 | 3170 | 2024-06-28 |
| 16360 | Caffè Americano 16360 | 62 62 | 540 | 590 | 2024-06-28 |
| 16361 | Cappuccino 16361 | 62 62 | 680 | 730 | 2024-06-28 |
| 16362 | Caffè Mocha 16362 | 62 62 | 750 | 800 | 2024-06-28 |
| 16363 | Caramel Macchiato 16363 | 62 62 | 760 | 810 | 2024-06-28 |
| 16364 | Espresso 16364 | 62 62 | 390 | 440 | 2024-06-28 |
| 16365 | Caffè Latte 16365 | 62 62 | 680 | 730 | 2024-06-28 |
| 16366 | Oatmilk Latte 16366 | 62 62 | 760 | 810 | 2024-06-28 |
| 16367 | Vanilla Latte 16367 | 62 62 | 750 | 800 | 2024-06-28 |
| 16368 | White Chocolate Mocha 16368 | 62 62 | 750 | 800 | 2024-06-28 |
| 16369 | Flat White 16369 | 62 62 | 760 | 810 | 2024-06-28 |
| 16370 | Ristretto Bianco 16370 | 62 62 | 760 | 810 | 2024-06-28 |
| 16371 | Iced Caffè Americano 16371 | 62 62 | 540 | 590 | 2024-06-28 |
| 16372 | Iced Cappuccino 16372 | 62 62 | 680 | 730 | 2024-06-28 |
| 16373 | Iced Caffè Mocha 16373 | 62 62 | 750 | 800 | 2024-06-28 |
| 16374 | Iced Caramel Macchiato 16374 | 62 62 | 760 | 810 | 2024-06-28 |
| 16375 | Iced Caffè Latte 16375 | 62 62 | 680 | 730 | 2024-06-28 |
| 16376 | Iced Oatmilk Latte 16376 | 62 62 | 760 | 810 | 2024-06-28 |
| 16377 | Iced Vanilla Latte 16377 | 62 62 | 750 | 800 | 2024-06-28 |
| 16378 | Iced White Chocolate Mocha 16378 | 62 62 | 750 | 800 | 2024-06-28 |
| 16379 | Signature Hot Chocolate 16379 | 62 62 | 720 | 770 | 2024-06-28 |
| 16380 | Signature Iced Chocolate 16380 | 62 62 | 720 | 770 | 2024-06-28 |
| 16381 | Carrot Juice 16381 | 62 62 | 490 | 540 | 2024-06-28 |
| 16382 | Cloudy Apple Juice 16382 | 62 62 | 490 | 540 | 2024-06-28 |
| 16383 | Cranberry Red Grapefruit Juice 16383 | 62 62 | 490 | 540 | 2024-06-28 |
| 16384 | Orange Juice 16384 | 62 62 | 490 | 540 | 2024-06-28 |
| 16385 | Evian 16385 | 62 62 | 350 | 400 | 2024-06-28 |
| 16386 | Sparkling Water 16386 | 62 62 | 450 | 500 | 2024-06-28 |
| 16387 | Chai Tea 16387 | 62 62 | 500 | 550 | 2024-06-28 |
| 16388 | Earl Grey Tea 16388 | 62 62 | 500 | 550 | 2024-06-28 |
| 16389 | English Breakfast Tea 16389 | 62 62 | 500 | 550 | 2024-06-28 |
| 16390 | Emperor’s Clouds & Mist™ Tea 16390 | 62 62 | 500 | 550 | 2024-06-28 |
| 16391 | Mint Blend Tea 16391 | 62 62 | 500 | 550 | 2024-06-28 |
| 16392 | Chamomile Tea 16392 | 62 62 | 500 | 550 | 2024-06-28 |
| 16393 | Pure Matcha Latte 16393 | 62 62 | 740 | 790 | 2024-06-28 |
| 16394 | Chai Tea Latte 16394 | 62 62 | 680 | 730 | 2024-06-28 |
| 16395 | Earl Grey Tea Latte 16395 | 62 62 | 680 | 730 | 2024-06-28 |
| 16396 | English Breakfast Tea Latte 16396 | 62 62 | 680 | 730 | 2024-06-28 |
| 16397 | Hojicha Tea Latte 16397 | 62 62 | 740 | 790 | 2024-06-28 |
| 16398 | Zen Clouds Oolong Tea 16398 | 62 62 | 500 | 550 | 2024-06-28 |
| 16399 | Zen Clouds Oolong with Ruby Grapefruit and Honey 16399 | 62 62 | 630 | 680 | 2024-06-28 |
| 16400 | Youthberry™ Tea 16400 | 62 62 | 500 | 550 | 2024-06-28 |
| 16401 | Iced Shaken Black Tea Lemonade 16401 | 62 62 | 610 | 660 | 2024-06-28 |
| 16402 | Iced Shaken Strawberry Black Tea Lemonade 16402 | 62 62 | 630 | 680 | 2024-06-28 |
| 16403 | Iced Shaken Hibiscus Tea Lemonade 16403 | 62 62 | 610 | 660 | 2024-06-28 |
| 16404 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 16404 | 62 62 | 730 | 780 | 2024-06-28 |
| 16405 | Iced Pure Matcha Latte 16405 | 62 62 | 740 | 790 | 2024-06-28 |
| 16406 | Iced Chai Tea Latte 16406 | 62 62 | 680 | 730 | 2024-06-28 |
| 16407 | Iced Black Tea Latte 16407 | 62 62 | 680 | 730 | 2024-06-28 |
| 16408 | Iced Hojicha Tea Latte 16408 | 62 62 | 740 | 790 | 2024-06-28 |
| 16409 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 16409 | 62 62 | 630 | 680 | 2024-06-28 |
| 16410 | Iced Shaken Zen Clouds Oolong Lemonade 16410 | 62 62 | 610 | 660 | 2024-06-28 |
| 16411 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 16411 | 62 62 | 630 | 680 | 2024-06-28 |
| 16412 | Origami Pike Place® Roast 16412 | 62 62 | 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");