item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
336 rows where store_id = 85
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 182
- 2024-11-10 102
- 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
- 85 · 336 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 13022 | Bagel 13022 | 85 85 | 430 | 460 | 2024-06-28 |
| 13023 | Cookie Crumble Cheesecake 13023 | 85 85 | 750 | 800 | 2024-06-28 |
| 13024 | Good Ol' NY Cheesecake 13024 | 85 85 | 750 | 800 | 2024-06-28 |
| 13025 | Signature Chocolate Cake 13025 | 85 85 | 750 | 800 | 2024-06-28 |
| 13026 | Starbucks® Coffee Tiramisu Cake 13026 | 85 85 | 780 | 830 | 2024-06-28 |
| 13027 | Strawberry Shortcake 13027 | 85 85 | 750 | 800 | 2024-06-28 |
| 13028 | Chocolate Chunk Monster Cookie 13028 | 85 85 | 420 | 470 | 2024-06-28 |
| 13029 | Banana Walnut Muffin 13029 | 85 85 | 480 | 530 | 2024-06-28 |
| 13030 | Blueberry Crumble Muffin 13030 | 85 85 | 480 | 530 | 2024-06-28 |
| 13031 | Chocolate Crumble Muffin 13031 | 85 85 | 480 | 530 | 2024-06-28 |
| 13032 | Pancakes 13032 | 85 85 | 580 | 630 | 2024-06-28 |
| 13033 | Almond Croissant 13033 | 85 85 | 500 | 550 | 2024-06-28 |
| 13034 | Buttery Croissant 13034 | 85 85 | 430 | 460 | 2024-06-28 |
| 13035 | Chocolate Croissant 13035 | 85 85 | 470 | 520 | 2024-06-28 |
| 13036 | Creamy Chicken Foldover 13036 | 85 85 | 580 | 630 | 2024-06-28 |
| 13037 | Sausage Roll 13037 | 85 85 | 580 | 630 | 2024-06-28 |
| 13038 | Buttery Scone 13038 | 85 85 | 430 | 460 | 2024-06-28 |
| 13039 | Country Chicken Pie 13039 | 85 85 | 720 | 770 | 2024-06-28 |
| 13040 | Deep Dish Beef Pie 13040 | 85 85 | 720 | 770 | 2024-06-28 |
| 13041 | Spinach & Mushroom Quiche 13041 | 85 85 | 720 | 770 | 2024-06-28 |
| 13042 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 13042 | 85 85 | 420 | 450 | 2024-06-28 |
| 13043 | Mixed Nuts 13043 | 85 85 | 520 | 570 | 2024-06-28 |
| 13044 | Caramel Waffles 13044 | 85 85 | 420 | 450 | 2024-06-28 |
| 13045 | Chicken Ham & Cheese Panwich 13045 | 85 85 | 720 | 770 | 2024-06-28 |
| 13046 | Egg Mayo & Cheese Multigrain Croissant 13046 | 85 85 | 720 | 770 | 2024-06-28 |
| 13047 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 13047 | 85 85 | 720 | 770 | 2024-06-28 |
| 13048 | Rosemary Chicken & Emmental Cheese Croissant 13048 | 85 85 | 720 | 770 | 2024-06-28 |
| 13049 | Scrambled Egg & Turkey Ham Pita 13049 | 85 85 | 720 | 770 | 2024-06-28 |
| 13050 | Turkey Ham & Triple Cheese Toast 13050 | 85 85 | 720 | 770 | 2024-06-28 |
| 13051 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 13051 | 85 85 | 820 | 870 | 2024-06-28 |
| 13052 | Ham & Cheese Croissant 13052 | 85 85 | 720 | 770 | 2024-06-28 |
| 13053 | Sriracha Chicken Whole Wheat Pita 13053 | 85 85 | 780 | 830 | 2024-06-28 |
| 13054 | Blueberry Acai Yogurt Parfait 13054 | 85 85 | 680 | 730 | 2024-06-28 |
| 13055 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 13055 | 85 85 | 680 | 730 | 2024-06-28 |
| 13056 | Caramel Frappuccino® 13056 | 85 85 | 780 | 830 | 2024-06-28 |
| 13057 | Dark Mocha Frappuccino® 13057 | 85 85 | 840 | 890 | 2024-06-28 |
| 13058 | Java Chip Frappuccino® 13058 | 85 85 | 840 | 890 | 2024-06-28 |
| 13059 | Mocha Frappuccino® 13059 | 85 85 | 780 | 830 | 2024-06-28 |
| 13060 | Caramel Macchiato Frappuccino® 13060 | 85 85 | 840 | 890 | 2024-06-28 |
| 13061 | Espresso Frappuccino® 13061 | 85 85 | 780 | 830 | 2024-06-28 |
| 13062 | White Chocolate Mocha Frappuccino® 13062 | 85 85 | 780 | 830 | 2024-06-28 |
| 13063 | Chocolate Chip Cream Frappuccino® 13063 | 85 85 | 840 | 890 | 2024-06-28 |
| 13064 | Hojicha Tea Cream Frappuccino® 13064 | 85 85 | 820 | 870 | 2024-06-28 |
| 13065 | Vanilla Cream Frappuccino® 13065 | 85 85 | 780 | 830 | 2024-06-28 |
| 13066 | Mango Passion Fruit & Hibiscus 13066 | 85 85 | 780 | 830 | 2024-06-28 |
| 13067 | Raspberry Black Currant & Oolong 13067 | 85 85 | 780 | 830 | 2024-06-28 |
| 13068 | Coffee Traveller 13068 | 85 85 | 3600 | 3650 | 2024-06-28 |
| 13069 | Caffè Americano 13069 | 85 85 | 600 | 650 | 2024-06-28 |
| 13070 | Cappuccino 13070 | 85 85 | 740 | 790 | 2024-06-28 |
| 13071 | Caffè Mocha 13071 | 85 85 | 830 | 880 | 2024-06-28 |
| 13072 | Caramel Macchiato 13072 | 85 85 | 840 | 890 | 2024-06-28 |
| 13073 | Espresso 13073 | 85 85 | 450 | 500 | 2024-06-28 |
| 13074 | Caffè Latte 13074 | 85 85 | 740 | 790 | 2024-06-28 |
| 13075 | Oatmilk Latte 13075 | 85 85 | 850 | 900 | 2024-06-28 |
| 13076 | Vanilla Latte 13076 | 85 85 | 830 | 880 | 2024-06-28 |
| 13077 | White Chocolate Mocha 13077 | 85 85 | 830 | 880 | 2024-06-28 |
| 13078 | Flat White 13078 | 85 85 | 840 | 890 | 2024-06-28 |
| 13079 | Ristretto Bianco 13079 | 85 85 | 840 | 890 | 2024-06-28 |
| 13080 | Iced Caffè Americano 13080 | 85 85 | 600 | 650 | 2024-06-28 |
| 13081 | Iced Cappuccino 13081 | 85 85 | 740 | 790 | 2024-06-28 |
| 13082 | Iced Caffè Mocha 13082 | 85 85 | 830 | 880 | 2024-06-28 |
| 13083 | Iced Caramel Macchiato 13083 | 85 85 | 840 | 890 | 2024-06-28 |
| 13084 | Iced Caffè Latte 13084 | 85 85 | 740 | 790 | 2024-06-28 |
| 13085 | Iced Oatmilk Latte 13085 | 85 85 | 850 | 900 | 2024-06-28 |
| 13086 | Iced Vanilla Latte 13086 | 85 85 | 830 | 880 | 2024-06-28 |
| 13087 | Iced White Chocolate Mocha 13087 | 85 85 | 830 | 880 | 2024-06-28 |
| 13088 | Signature Hot Chocolate 13088 | 85 85 | 780 | 830 | 2024-06-28 |
| 13089 | Signature Iced Chocolate 13089 | 85 85 | 780 | 830 | 2024-06-28 |
| 13090 | Carrot Juice 13090 | 85 85 | 550 | 600 | 2024-06-28 |
| 13091 | Cloudy Apple Juice 13091 | 85 85 | 550 | 600 | 2024-06-28 |
| 13092 | Cranberry Red Grapefruit Juice 13092 | 85 85 | 550 | 600 | 2024-06-28 |
| 13093 | Orange Juice 13093 | 85 85 | 550 | 600 | 2024-06-28 |
| 13094 | Evian 13094 | 85 85 | 410 | 460 | 2024-06-28 |
| 13095 | Sparkling Water 13095 | 85 85 | 510 | 560 | 2024-06-28 |
| 13096 | Chai Tea 13096 | 85 85 | 560 | 610 | 2024-06-28 |
| 13097 | Earl Grey Tea 13097 | 85 85 | 560 | 610 | 2024-06-28 |
| 13098 | English Breakfast Tea 13098 | 85 85 | 560 | 610 | 2024-06-28 |
| 13099 | Emperor’s Clouds & Mist™ Tea 13099 | 85 85 | 560 | 610 | 2024-06-28 |
| 13100 | Mint Blend Tea 13100 | 85 85 | 560 | 610 | 2024-06-28 |
| 13101 | Chamomile Tea 13101 | 85 85 | 560 | 610 | 2024-06-28 |
| 13102 | Pure Matcha Latte 13102 | 85 85 | 810 | 860 | 2024-06-28 |
| 13103 | Chai Tea Latte 13103 | 85 85 | 740 | 790 | 2024-06-28 |
| 13104 | Earl Grey Tea Latte 13104 | 85 85 | 740 | 790 | 2024-06-28 |
| 13105 | English Breakfast Tea Latte 13105 | 85 85 | 740 | 790 | 2024-06-28 |
| 13106 | Hojicha Tea Latte 13106 | 85 85 | 810 | 860 | 2024-06-28 |
| 13107 | Zen Clouds Oolong Tea 13107 | 85 85 | 560 | 610 | 2024-06-28 |
| 13108 | Zen Clouds Oolong with Ruby Grapefruit and Honey 13108 | 85 85 | 690 | 740 | 2024-06-28 |
| 13109 | Youthberry™ Tea 13109 | 85 85 | 560 | 610 | 2024-06-28 |
| 13110 | Iced Shaken Black Tea Lemonade 13110 | 85 85 | 670 | 720 | 2024-06-28 |
| 13111 | Iced Shaken Strawberry Black Tea Lemonade 13111 | 85 85 | 690 | 740 | 2024-06-28 |
| 13112 | Iced Shaken Hibiscus Tea Lemonade 13112 | 85 85 | 670 | 720 | 2024-06-28 |
| 13113 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 13113 | 85 85 | 790 | 840 | 2024-06-28 |
| 13114 | Iced Pure Matcha Latte 13114 | 85 85 | 810 | 860 | 2024-06-28 |
| 13115 | Iced Chai Tea Latte 13115 | 85 85 | 740 | 790 | 2024-06-28 |
| 13116 | Iced Black Tea Latte 13116 | 85 85 | 740 | 790 | 2024-06-28 |
| 13117 | Iced Hojicha Tea Latte 13117 | 85 85 | 810 | 860 | 2024-06-28 |
| 13118 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 13118 | 85 85 | 690 | 740 | 2024-06-28 |
| 13119 | Iced Shaken Zen Clouds Oolong Lemonade 13119 | 85 85 | 670 | 720 | 2024-06-28 |
| 13120 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 13120 | 85 85 | 690 | 740 | 2024-06-28 |
| 13121 | Origami Pike Place® Roast 13121 | 85 85 | 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");