item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 7
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
- 7 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 1 | Bagel 1 | 7 7 | 400 | 430 | 2024-06-28 |
| 2 | Cookie Crumble Cheesecake 2 | 7 7 | 720 | 770 | 2024-06-28 |
| 3 | Good Ol' NY Cheesecake 3 | 7 7 | 720 | 770 | 2024-06-28 |
| 4 | Signature Chocolate Cake 4 | 7 7 | 720 | 770 | 2024-06-28 |
| 5 | Starbucks® Coffee Tiramisu Cake 5 | 7 7 | 750 | 800 | 2024-06-28 |
| 6 | Strawberry Shortcake 6 | 7 7 | 720 | 770 | 2024-06-28 |
| 7 | Chocolate Chunk Monster Cookie 7 | 7 7 | 390 | 440 | 2024-06-28 |
| 8 | Banana Walnut Muffin 8 | 7 7 | 450 | 500 | 2024-06-28 |
| 9 | Blueberry Crumble Muffin 9 | 7 7 | 450 | 500 | 2024-06-28 |
| 10 | Chocolate Crumble Muffin 10 | 7 7 | 450 | 500 | 2024-06-28 |
| 11 | Pancakes 11 | 7 7 | 550 | 600 | 2024-06-28 |
| 12 | Almond Croissant 12 | 7 7 | 470 | 520 | 2024-06-28 |
| 13 | Buttery Croissant 13 | 7 7 | 400 | 430 | 2024-06-28 |
| 14 | Chocolate Croissant 14 | 7 7 | 440 | 490 | 2024-06-28 |
| 15 | Creamy Chicken Foldover 15 | 7 7 | 550 | 600 | 2024-06-28 |
| 16 | Sausage Roll 16 | 7 7 | 550 | 600 | 2024-06-28 |
| 17 | Buttery Scone 17 | 7 7 | 400 | 430 | 2024-06-28 |
| 18 | Country Chicken Pie 18 | 7 7 | 690 | 740 | 2024-06-28 |
| 19 | Deep Dish Beef Pie 19 | 7 7 | 690 | 740 | 2024-06-28 |
| 20 | Spinach & Mushroom Quiche 20 | 7 7 | 690 | 740 | 2024-06-28 |
| 21 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 21 | 7 7 | 390 | 420 | 2024-06-28 |
| 22 | Mixed Nuts 22 | 7 7 | 490 | 540 | 2024-06-28 |
| 23 | Caramel Waffles 23 | 7 7 | 390 | 420 | 2024-06-28 |
| 24 | Chicken Ham & Cheese Panwich 24 | 7 7 | 690 | 740 | 2024-06-28 |
| 25 | Egg Mayo & Cheese Multigrain Croissant 25 | 7 7 | 690 | 740 | 2024-06-28 |
| 26 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 26 | 7 7 | 690 | 740 | 2024-06-28 |
| 27 | Rosemary Chicken & Emmental Cheese Croissant 27 | 7 7 | 690 | 740 | 2024-06-28 |
| 28 | Scrambled Egg & Turkey Ham Pita 28 | 7 7 | 690 | 740 | 2024-06-28 |
| 29 | Turkey Ham & Triple Cheese Toast 29 | 7 7 | 690 | 740 | 2024-06-28 |
| 30 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 30 | 7 7 | 790 | 840 | 2024-06-28 |
| 31 | Ham & Cheese Croissant 31 | 7 7 | 690 | 740 | 2024-06-28 |
| 32 | Sriracha Chicken Whole Wheat Pita 32 | 7 7 | 750 | 800 | 2024-06-28 |
| 33 | Blueberry Acai Yogurt Parfait 33 | 7 7 | 650 | 700 | 2024-06-28 |
| 34 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 34 | 7 7 | 650 | 700 | 2024-06-28 |
| 35 | Caramel Frappuccino® 35 | 7 7 | 720 | 770 | 2024-06-28 |
| 36 | Dark Mocha Frappuccino® 36 | 7 7 | 780 | 830 | 2024-06-28 |
| 37 | Java Chip Frappuccino® 37 | 7 7 | 780 | 830 | 2024-06-28 |
| 38 | Mocha Frappuccino® 38 | 7 7 | 720 | 770 | 2024-06-28 |
| 39 | Caramel Macchiato Frappuccino® 39 | 7 7 | 780 | 830 | 2024-06-28 |
| 40 | Espresso Frappuccino® 40 | 7 7 | 720 | 770 | 2024-06-28 |
| 41 | White Chocolate Mocha Frappuccino® 41 | 7 7 | 720 | 770 | 2024-06-28 |
| 42 | Chocolate Chip Cream Frappuccino® 42 | 7 7 | 780 | 830 | 2024-06-28 |
| 43 | Hojicha Tea Cream Frappuccino® 43 | 7 7 | 760 | 810 | 2024-06-28 |
| 44 | Vanilla Cream Frappuccino® 44 | 7 7 | 720 | 770 | 2024-06-28 |
| 45 | Mango Passion Fruit & Hibiscus 45 | 7 7 | 720 | 770 | 2024-06-28 |
| 46 | Raspberry Black Currant & Oolong 46 | 7 7 | 720 | 770 | 2024-06-28 |
| 47 | Coffee Traveller 47 | 7 7 | 3120 | 3170 | 2024-06-28 |
| 48 | Caffè Americano 48 | 7 7 | 540 | 590 | 2024-06-28 |
| 49 | Cappuccino 49 | 7 7 | 680 | 730 | 2024-06-28 |
| 50 | Caffè Mocha 50 | 7 7 | 750 | 800 | 2024-06-28 |
| 51 | Caramel Macchiato 51 | 7 7 | 760 | 810 | 2024-06-28 |
| 52 | Espresso 52 | 7 7 | 390 | 440 | 2024-06-28 |
| 53 | Caffè Latte 53 | 7 7 | 680 | 730 | 2024-06-28 |
| 54 | Oatmilk Latte 54 | 7 7 | 760 | 810 | 2024-06-28 |
| 55 | Vanilla Latte 55 | 7 7 | 750 | 800 | 2024-06-28 |
| 56 | White Chocolate Mocha 56 | 7 7 | 750 | 800 | 2024-06-28 |
| 57 | Flat White 57 | 7 7 | 760 | 810 | 2024-06-28 |
| 58 | Ristretto Bianco 58 | 7 7 | 760 | 810 | 2024-06-28 |
| 59 | Iced Caffè Americano 59 | 7 7 | 540 | 590 | 2024-06-28 |
| 60 | Iced Cappuccino 60 | 7 7 | 680 | 730 | 2024-06-28 |
| 61 | Iced Caffè Mocha 61 | 7 7 | 750 | 800 | 2024-06-28 |
| 62 | Iced Caramel Macchiato 62 | 7 7 | 760 | 810 | 2024-06-28 |
| 63 | Iced Caffè Latte 63 | 7 7 | 680 | 730 | 2024-06-28 |
| 64 | Iced Oatmilk Latte 64 | 7 7 | 760 | 810 | 2024-06-28 |
| 65 | Iced Vanilla Latte 65 | 7 7 | 750 | 800 | 2024-06-28 |
| 66 | Iced White Chocolate Mocha 66 | 7 7 | 750 | 800 | 2024-06-28 |
| 67 | Signature Hot Chocolate 67 | 7 7 | 720 | 770 | 2024-06-28 |
| 68 | Signature Iced Chocolate 68 | 7 7 | 720 | 770 | 2024-06-28 |
| 69 | Carrot Juice 69 | 7 7 | 490 | 540 | 2024-06-28 |
| 70 | Cloudy Apple Juice 70 | 7 7 | 490 | 540 | 2024-06-28 |
| 71 | Cranberry Red Grapefruit Juice 71 | 7 7 | 490 | 540 | 2024-06-28 |
| 72 | Orange Juice 72 | 7 7 | 490 | 540 | 2024-06-28 |
| 73 | Evian 73 | 7 7 | 350 | 400 | 2024-06-28 |
| 74 | Sparkling Water 74 | 7 7 | 450 | 500 | 2024-06-28 |
| 75 | Chai Tea 75 | 7 7 | 500 | 550 | 2024-06-28 |
| 76 | Earl Grey Tea 76 | 7 7 | 500 | 550 | 2024-06-28 |
| 77 | English Breakfast Tea 77 | 7 7 | 500 | 550 | 2024-06-28 |
| 78 | Emperor’s Clouds & Mist™ Tea 78 | 7 7 | 500 | 550 | 2024-06-28 |
| 79 | Mint Blend Tea 79 | 7 7 | 500 | 550 | 2024-06-28 |
| 80 | Chamomile Tea 80 | 7 7 | 500 | 550 | 2024-06-28 |
| 81 | Pure Matcha Latte 81 | 7 7 | 740 | 790 | 2024-06-28 |
| 82 | Chai Tea Latte 82 | 7 7 | 680 | 730 | 2024-06-28 |
| 83 | Earl Grey Tea Latte 83 | 7 7 | 680 | 730 | 2024-06-28 |
| 84 | English Breakfast Tea Latte 84 | 7 7 | 680 | 730 | 2024-06-28 |
| 85 | Hojicha Tea Latte 85 | 7 7 | 740 | 790 | 2024-06-28 |
| 86 | Zen Clouds Oolong Tea 86 | 7 7 | 500 | 550 | 2024-06-28 |
| 87 | Zen Clouds Oolong with Ruby Grapefruit and Honey 87 | 7 7 | 630 | 680 | 2024-06-28 |
| 88 | Youthberry™ Tea 88 | 7 7 | 500 | 550 | 2024-06-28 |
| 89 | Iced Shaken Black Tea Lemonade 89 | 7 7 | 610 | 660 | 2024-06-28 |
| 90 | Iced Shaken Strawberry Black Tea Lemonade 90 | 7 7 | 630 | 680 | 2024-06-28 |
| 91 | Iced Shaken Hibiscus Tea Lemonade 91 | 7 7 | 610 | 660 | 2024-06-28 |
| 92 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 92 | 7 7 | 730 | 780 | 2024-06-28 |
| 93 | Iced Pure Matcha Latte 93 | 7 7 | 740 | 790 | 2024-06-28 |
| 94 | Iced Chai Tea Latte 94 | 7 7 | 680 | 730 | 2024-06-28 |
| 95 | Iced Black Tea Latte 95 | 7 7 | 680 | 730 | 2024-06-28 |
| 96 | Iced Hojicha Tea Latte 96 | 7 7 | 740 | 790 | 2024-06-28 |
| 97 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 97 | 7 7 | 630 | 680 | 2024-06-28 |
| 98 | Iced Shaken Zen Clouds Oolong Lemonade 98 | 7 7 | 610 | 660 | 2024-06-28 |
| 99 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 99 | 7 7 | 630 | 680 | 2024-06-28 |
| 100 | Origami Pike Place® Roast 100 | 7 7 | 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");