item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 67
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 193
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-07-28 7
- 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-10-27 1
store_id 1
- 67 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 15392 | Bagel 15392 | 67 67 | 400 | 430 | 2024-06-28 |
| 15393 | Cookie Crumble Cheesecake 15393 | 67 67 | 720 | 770 | 2024-06-28 |
| 15394 | Good Ol' NY Cheesecake 15394 | 67 67 | 720 | 770 | 2024-06-28 |
| 15395 | Signature Chocolate Cake 15395 | 67 67 | 720 | 770 | 2024-06-28 |
| 15396 | Starbucks® Coffee Tiramisu Cake 15396 | 67 67 | 750 | 800 | 2024-06-28 |
| 15397 | Strawberry Shortcake 15397 | 67 67 | 720 | 770 | 2024-06-28 |
| 15398 | Chocolate Chunk Monster Cookie 15398 | 67 67 | 390 | 440 | 2024-06-28 |
| 15399 | Banana Walnut Muffin 15399 | 67 67 | 450 | 500 | 2024-06-28 |
| 15400 | Blueberry Crumble Muffin 15400 | 67 67 | 450 | 500 | 2024-06-28 |
| 15401 | Chocolate Crumble Muffin 15401 | 67 67 | 450 | 500 | 2024-06-28 |
| 15402 | Pancakes 15402 | 67 67 | 550 | 600 | 2024-06-28 |
| 15403 | Almond Croissant 15403 | 67 67 | 470 | 520 | 2024-06-28 |
| 15404 | Buttery Croissant 15404 | 67 67 | 400 | 430 | 2024-06-28 |
| 15405 | Chocolate Croissant 15405 | 67 67 | 440 | 490 | 2024-06-28 |
| 15406 | Creamy Chicken Foldover 15406 | 67 67 | 550 | 600 | 2024-06-28 |
| 15407 | Sausage Roll 15407 | 67 67 | 550 | 600 | 2024-06-28 |
| 15408 | Buttery Scone 15408 | 67 67 | 400 | 430 | 2024-06-28 |
| 15409 | Country Chicken Pie 15409 | 67 67 | 690 | 740 | 2024-06-28 |
| 15410 | Deep Dish Beef Pie 15410 | 67 67 | 690 | 740 | 2024-06-28 |
| 15411 | Spinach & Mushroom Quiche 15411 | 67 67 | 690 | 740 | 2024-06-28 |
| 15412 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 15412 | 67 67 | 390 | 420 | 2024-06-28 |
| 15413 | Mixed Nuts 15413 | 67 67 | 490 | 540 | 2024-06-28 |
| 15414 | Caramel Waffles 15414 | 67 67 | 390 | 420 | 2024-06-28 |
| 15415 | Chicken Ham & Cheese Panwich 15415 | 67 67 | 690 | 740 | 2024-06-28 |
| 15416 | Egg Mayo & Cheese Multigrain Croissant 15416 | 67 67 | 690 | 740 | 2024-06-28 |
| 15417 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 15417 | 67 67 | 690 | 740 | 2024-06-28 |
| 15418 | Rosemary Chicken & Emmental Cheese Croissant 15418 | 67 67 | 690 | 740 | 2024-06-28 |
| 15419 | Scrambled Egg & Turkey Ham Pita 15419 | 67 67 | 690 | 740 | 2024-06-28 |
| 15420 | Turkey Ham & Triple Cheese Toast 15420 | 67 67 | 690 | 740 | 2024-06-28 |
| 15421 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 15421 | 67 67 | 790 | 840 | 2024-06-28 |
| 15422 | Ham & Cheese Croissant 15422 | 67 67 | 690 | 740 | 2024-06-28 |
| 15423 | Sriracha Chicken Whole Wheat Pita 15423 | 67 67 | 750 | 800 | 2024-06-28 |
| 15424 | Blueberry Acai Yogurt Parfait 15424 | 67 67 | 650 | 700 | 2024-06-28 |
| 15425 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 15425 | 67 67 | 650 | 700 | 2024-06-28 |
| 15426 | Buttery Croissant 15426 | 67 67 | 400 | 450 | 2024-06-28 |
| 15427 | Chocolate Croissant 15427 | 67 67 | 440 | 490 | 2024-06-28 |
| 15428 | Raisin Danish 15428 | 67 67 | 470 | 520 | 2024-06-28 |
| 15429 | Apple Tart 15429 | 67 67 | 620 | 670 | 2024-06-28 |
| 15430 | Lemon Meringue Tart 15430 | 67 67 | 620 | 670 | 2024-06-28 |
| 15431 | Caramel Frappuccino® 15431 | 67 67 | 720 | 770 | 2024-06-28 |
| 15432 | Dark Mocha Frappuccino® 15432 | 67 67 | 780 | 830 | 2024-06-28 |
| 15433 | Java Chip Frappuccino® 15433 | 67 67 | 780 | 830 | 2024-06-28 |
| 15434 | Mocha Frappuccino® 15434 | 67 67 | 720 | 770 | 2024-06-28 |
| 15435 | Caramel Macchiato Frappuccino® 15435 | 67 67 | 780 | 830 | 2024-06-28 |
| 15436 | Espresso Frappuccino® 15436 | 67 67 | 720 | 770 | 2024-06-28 |
| 15437 | White Chocolate Mocha Frappuccino® 15437 | 67 67 | 720 | 770 | 2024-06-28 |
| 15438 | Chocolate Chip Cream Frappuccino® 15438 | 67 67 | 780 | 830 | 2024-06-28 |
| 15439 | Hojicha Tea Cream Frappuccino® 15439 | 67 67 | 760 | 810 | 2024-06-28 |
| 15440 | Vanilla Cream Frappuccino® 15440 | 67 67 | 720 | 770 | 2024-06-28 |
| 15441 | Mango Passion Fruit & Hibiscus 15441 | 67 67 | 720 | 770 | 2024-06-28 |
| 15442 | Raspberry Black Currant & Oolong 15442 | 67 67 | 720 | 770 | 2024-06-28 |
| 15443 | Coffee Traveller 15443 | 67 67 | 3120 | 3170 | 2024-06-28 |
| 15444 | Caffè Americano 15444 | 67 67 | 540 | 590 | 2024-06-28 |
| 15445 | Cappuccino 15445 | 67 67 | 680 | 730 | 2024-06-28 |
| 15446 | Caffè Mocha 15446 | 67 67 | 750 | 800 | 2024-06-28 |
| 15447 | Caramel Macchiato 15447 | 67 67 | 760 | 810 | 2024-06-28 |
| 15448 | Espresso 15448 | 67 67 | 390 | 440 | 2024-06-28 |
| 15449 | Caffè Latte 15449 | 67 67 | 680 | 730 | 2024-06-28 |
| 15450 | Oatmilk Latte 15450 | 67 67 | 760 | 810 | 2024-06-28 |
| 15451 | Vanilla Latte 15451 | 67 67 | 750 | 800 | 2024-06-28 |
| 15452 | White Chocolate Mocha 15452 | 67 67 | 750 | 800 | 2024-06-28 |
| 15453 | Flat White 15453 | 67 67 | 760 | 810 | 2024-06-28 |
| 15454 | Ristretto Bianco 15454 | 67 67 | 760 | 810 | 2024-06-28 |
| 15455 | Iced Caffè Americano 15455 | 67 67 | 540 | 590 | 2024-06-28 |
| 15456 | Iced Cappuccino 15456 | 67 67 | 680 | 730 | 2024-06-28 |
| 15457 | Iced Caffè Mocha 15457 | 67 67 | 750 | 800 | 2024-06-28 |
| 15458 | Iced Caramel Macchiato 15458 | 67 67 | 760 | 810 | 2024-06-28 |
| 15459 | Iced Caffè Latte 15459 | 67 67 | 680 | 730 | 2024-06-28 |
| 15460 | Iced Oatmilk Latte 15460 | 67 67 | 760 | 810 | 2024-06-28 |
| 15461 | Iced Vanilla Latte 15461 | 67 67 | 750 | 800 | 2024-06-28 |
| 15462 | Iced White Chocolate Mocha 15462 | 67 67 | 750 | 800 | 2024-06-28 |
| 15463 | Signature Hot Chocolate 15463 | 67 67 | 720 | 770 | 2024-06-28 |
| 15464 | Signature Iced Chocolate 15464 | 67 67 | 720 | 770 | 2024-06-28 |
| 15465 | Carrot Juice 15465 | 67 67 | 490 | 540 | 2024-06-28 |
| 15466 | Cloudy Apple Juice 15466 | 67 67 | 490 | 540 | 2024-06-28 |
| 15467 | Cranberry Red Grapefruit Juice 15467 | 67 67 | 490 | 540 | 2024-06-28 |
| 15468 | Orange Juice 15468 | 67 67 | 490 | 540 | 2024-06-28 |
| 15469 | Evian 15469 | 67 67 | 350 | 400 | 2024-06-28 |
| 15470 | Sparkling Water 15470 | 67 67 | 450 | 500 | 2024-06-28 |
| 15471 | Chai Tea 15471 | 67 67 | 500 | 550 | 2024-06-28 |
| 15472 | Earl Grey Tea 15472 | 67 67 | 500 | 550 | 2024-06-28 |
| 15473 | English Breakfast Tea 15473 | 67 67 | 500 | 550 | 2024-06-28 |
| 15474 | Emperor’s Clouds & Mist™ Tea 15474 | 67 67 | 500 | 550 | 2024-06-28 |
| 15475 | Mint Blend Tea 15475 | 67 67 | 500 | 550 | 2024-06-28 |
| 15476 | Chamomile Tea 15476 | 67 67 | 500 | 550 | 2024-06-28 |
| 15477 | Pure Matcha Latte 15477 | 67 67 | 740 | 790 | 2024-06-28 |
| 15478 | Chai Tea Latte 15478 | 67 67 | 680 | 730 | 2024-06-28 |
| 15479 | Earl Grey Tea Latte 15479 | 67 67 | 680 | 730 | 2024-06-28 |
| 15480 | English Breakfast Tea Latte 15480 | 67 67 | 680 | 730 | 2024-06-28 |
| 15481 | Hojicha Tea Latte 15481 | 67 67 | 740 | 790 | 2024-06-28 |
| 15482 | Zen Clouds Oolong Tea 15482 | 67 67 | 500 | 550 | 2024-06-28 |
| 15483 | Zen Clouds Oolong with Ruby Grapefruit and Honey 15483 | 67 67 | 630 | 680 | 2024-06-28 |
| 15484 | Youthberry™ Tea 15484 | 67 67 | 500 | 550 | 2024-06-28 |
| 15485 | Iced Shaken Black Tea Lemonade 15485 | 67 67 | 610 | 660 | 2024-06-28 |
| 15486 | Iced Shaken Strawberry Black Tea Lemonade 15486 | 67 67 | 630 | 680 | 2024-06-28 |
| 15487 | Iced Shaken Hibiscus Tea Lemonade 15487 | 67 67 | 610 | 660 | 2024-06-28 |
| 15488 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 15488 | 67 67 | 730 | 780 | 2024-06-28 |
| 15489 | Iced Pure Matcha Latte 15489 | 67 67 | 740 | 790 | 2024-06-28 |
| 15490 | Iced Chai Tea Latte 15490 | 67 67 | 680 | 730 | 2024-06-28 |
| 15491 | Iced Black Tea Latte 15491 | 67 67 | 680 | 730 | 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");