item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
225 rows where store_id = 46
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 10
- 2024-06-28 182
- 2024-09-15 10
- 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
- 46 · 225 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 19063 | Bagel 19063 | 46 46 | 400 | 430 | 2024-06-28 |
| 19064 | Cookie Crumble Cheesecake 19064 | 46 46 | 720 | 770 | 2024-06-28 |
| 19065 | Good Ol' NY Cheesecake 19065 | 46 46 | 720 | 770 | 2024-06-28 |
| 19066 | Signature Chocolate Cake 19066 | 46 46 | 720 | 770 | 2024-06-28 |
| 19067 | Starbucks® Coffee Tiramisu Cake 19067 | 46 46 | 750 | 800 | 2024-06-28 |
| 19068 | Strawberry Shortcake 19068 | 46 46 | 720 | 770 | 2024-06-28 |
| 19069 | Chocolate Chunk Monster Cookie 19069 | 46 46 | 390 | 440 | 2024-06-28 |
| 19070 | Banana Walnut Muffin 19070 | 46 46 | 450 | 500 | 2024-06-28 |
| 19071 | Blueberry Crumble Muffin 19071 | 46 46 | 450 | 500 | 2024-06-28 |
| 19072 | Chocolate Crumble Muffin 19072 | 46 46 | 450 | 500 | 2024-06-28 |
| 19073 | Pancakes 19073 | 46 46 | 550 | 600 | 2024-06-28 |
| 19074 | Almond Croissant 19074 | 46 46 | 470 | 520 | 2024-06-28 |
| 19075 | Buttery Croissant 19075 | 46 46 | 400 | 430 | 2024-06-28 |
| 19076 | Chocolate Croissant 19076 | 46 46 | 440 | 490 | 2024-06-28 |
| 19077 | Creamy Chicken Foldover 19077 | 46 46 | 550 | 600 | 2024-06-28 |
| 19078 | Sausage Roll 19078 | 46 46 | 550 | 600 | 2024-06-28 |
| 19079 | Buttery Scone 19079 | 46 46 | 400 | 430 | 2024-06-28 |
| 19080 | Country Chicken Pie 19080 | 46 46 | 690 | 740 | 2024-06-28 |
| 19081 | Deep Dish Beef Pie 19081 | 46 46 | 690 | 740 | 2024-06-28 |
| 19082 | Spinach & Mushroom Quiche 19082 | 46 46 | 690 | 740 | 2024-06-28 |
| 19083 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 19083 | 46 46 | 390 | 420 | 2024-06-28 |
| 19084 | Mixed Nuts 19084 | 46 46 | 490 | 540 | 2024-06-28 |
| 19085 | Caramel Waffles 19085 | 46 46 | 390 | 420 | 2024-06-28 |
| 19086 | Chicken Ham & Cheese Panwich 19086 | 46 46 | 690 | 740 | 2024-06-28 |
| 19087 | Egg Mayo & Cheese Multigrain Croissant 19087 | 46 46 | 690 | 740 | 2024-06-28 |
| 19088 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 19088 | 46 46 | 690 | 740 | 2024-06-28 |
| 19089 | Rosemary Chicken & Emmental Cheese Croissant 19089 | 46 46 | 690 | 740 | 2024-06-28 |
| 19090 | Scrambled Egg & Turkey Ham Pita 19090 | 46 46 | 690 | 740 | 2024-06-28 |
| 19091 | Turkey Ham & Triple Cheese Toast 19091 | 46 46 | 690 | 740 | 2024-06-28 |
| 19092 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 19092 | 46 46 | 790 | 840 | 2024-06-28 |
| 19093 | Ham & Cheese Croissant 19093 | 46 46 | 690 | 740 | 2024-06-28 |
| 19094 | Sriracha Chicken Whole Wheat Pita 19094 | 46 46 | 750 | 800 | 2024-06-28 |
| 19095 | Blueberry Acai Yogurt Parfait 19095 | 46 46 | 650 | 700 | 2024-06-28 |
| 19096 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 19096 | 46 46 | 650 | 700 | 2024-06-28 |
| 19097 | Caramel Frappuccino® 19097 | 46 46 | 720 | 770 | 2024-06-28 |
| 19098 | Dark Mocha Frappuccino® 19098 | 46 46 | 780 | 830 | 2024-06-28 |
| 19099 | Java Chip Frappuccino® 19099 | 46 46 | 780 | 830 | 2024-06-28 |
| 19100 | Mocha Frappuccino® 19100 | 46 46 | 720 | 770 | 2024-06-28 |
| 19101 | Caramel Macchiato Frappuccino® 19101 | 46 46 | 780 | 830 | 2024-06-28 |
| 19102 | Espresso Frappuccino® 19102 | 46 46 | 720 | 770 | 2024-06-28 |
| 19103 | White Chocolate Mocha Frappuccino® 19103 | 46 46 | 720 | 770 | 2024-06-28 |
| 19104 | Chocolate Chip Cream Frappuccino® 19104 | 46 46 | 780 | 830 | 2024-06-28 |
| 19105 | Hojicha Tea Cream Frappuccino® 19105 | 46 46 | 760 | 810 | 2024-06-28 |
| 19106 | Vanilla Cream Frappuccino® 19106 | 46 46 | 720 | 770 | 2024-06-28 |
| 19107 | Mango Passion Fruit & Hibiscus 19107 | 46 46 | 720 | 770 | 2024-06-28 |
| 19108 | Raspberry Black Currant & Oolong 19108 | 46 46 | 720 | 770 | 2024-06-28 |
| 19109 | Coffee Traveller 19109 | 46 46 | 3120 | 3170 | 2024-06-28 |
| 19110 | Caffè Americano 19110 | 46 46 | 540 | 590 | 2024-06-28 |
| 19111 | Cappuccino 19111 | 46 46 | 680 | 730 | 2024-06-28 |
| 19112 | Caffè Mocha 19112 | 46 46 | 750 | 800 | 2024-06-28 |
| 19113 | Caramel Macchiato 19113 | 46 46 | 760 | 810 | 2024-06-28 |
| 19114 | Espresso 19114 | 46 46 | 390 | 440 | 2024-06-28 |
| 19115 | Caffè Latte 19115 | 46 46 | 680 | 730 | 2024-06-28 |
| 19116 | Oatmilk Latte 19116 | 46 46 | 760 | 810 | 2024-06-28 |
| 19117 | Vanilla Latte 19117 | 46 46 | 750 | 800 | 2024-06-28 |
| 19118 | White Chocolate Mocha 19118 | 46 46 | 750 | 800 | 2024-06-28 |
| 19119 | Flat White 19119 | 46 46 | 760 | 810 | 2024-06-28 |
| 19120 | Ristretto Bianco 19120 | 46 46 | 760 | 810 | 2024-06-28 |
| 19121 | Iced Caffè Americano 19121 | 46 46 | 540 | 590 | 2024-06-28 |
| 19122 | Iced Cappuccino 19122 | 46 46 | 680 | 730 | 2024-06-28 |
| 19123 | Iced Caffè Mocha 19123 | 46 46 | 750 | 800 | 2024-06-28 |
| 19124 | Iced Caramel Macchiato 19124 | 46 46 | 760 | 810 | 2024-06-28 |
| 19125 | Iced Caffè Latte 19125 | 46 46 | 680 | 730 | 2024-06-28 |
| 19126 | Iced Oatmilk Latte 19126 | 46 46 | 760 | 810 | 2024-06-28 |
| 19127 | Iced Vanilla Latte 19127 | 46 46 | 750 | 800 | 2024-06-28 |
| 19128 | Iced White Chocolate Mocha 19128 | 46 46 | 750 | 800 | 2024-06-28 |
| 19129 | Signature Hot Chocolate 19129 | 46 46 | 720 | 770 | 2024-06-28 |
| 19130 | Signature Iced Chocolate 19130 | 46 46 | 720 | 770 | 2024-06-28 |
| 19131 | Carrot Juice 19131 | 46 46 | 490 | 540 | 2024-06-28 |
| 19132 | Cloudy Apple Juice 19132 | 46 46 | 490 | 540 | 2024-06-28 |
| 19133 | Cranberry Red Grapefruit Juice 19133 | 46 46 | 490 | 540 | 2024-06-28 |
| 19134 | Orange Juice 19134 | 46 46 | 490 | 540 | 2024-06-28 |
| 19135 | Evian 19135 | 46 46 | 350 | 400 | 2024-06-28 |
| 19136 | Sparkling Water 19136 | 46 46 | 450 | 500 | 2024-06-28 |
| 19137 | Chai Tea 19137 | 46 46 | 500 | 550 | 2024-06-28 |
| 19138 | Earl Grey Tea 19138 | 46 46 | 500 | 550 | 2024-06-28 |
| 19139 | English Breakfast Tea 19139 | 46 46 | 500 | 550 | 2024-06-28 |
| 19140 | Emperor’s Clouds & Mist™ Tea 19140 | 46 46 | 500 | 550 | 2024-06-28 |
| 19141 | Mint Blend Tea 19141 | 46 46 | 500 | 550 | 2024-06-28 |
| 19142 | Chamomile Tea 19142 | 46 46 | 500 | 550 | 2024-06-28 |
| 19143 | Pure Matcha Latte 19143 | 46 46 | 740 | 790 | 2024-06-28 |
| 19144 | Chai Tea Latte 19144 | 46 46 | 680 | 730 | 2024-06-28 |
| 19145 | Earl Grey Tea Latte 19145 | 46 46 | 680 | 730 | 2024-06-28 |
| 19146 | English Breakfast Tea Latte 19146 | 46 46 | 680 | 730 | 2024-06-28 |
| 19147 | Hojicha Tea Latte 19147 | 46 46 | 740 | 790 | 2024-06-28 |
| 19148 | Zen Clouds Oolong Tea 19148 | 46 46 | 500 | 550 | 2024-06-28 |
| 19149 | Zen Clouds Oolong with Ruby Grapefruit and Honey 19149 | 46 46 | 630 | 680 | 2024-06-28 |
| 19150 | Youthberry™ Tea 19150 | 46 46 | 500 | 550 | 2024-06-28 |
| 19151 | Iced Shaken Black Tea Lemonade 19151 | 46 46 | 610 | 660 | 2024-06-28 |
| 19152 | Iced Shaken Strawberry Black Tea Lemonade 19152 | 46 46 | 630 | 680 | 2024-06-28 |
| 19153 | Iced Shaken Hibiscus Tea Lemonade 19153 | 46 46 | 610 | 660 | 2024-06-28 |
| 19154 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 19154 | 46 46 | 730 | 780 | 2024-06-28 |
| 19155 | Iced Pure Matcha Latte 19155 | 46 46 | 740 | 790 | 2024-06-28 |
| 19156 | Iced Chai Tea Latte 19156 | 46 46 | 680 | 730 | 2024-06-28 |
| 19157 | Iced Black Tea Latte 19157 | 46 46 | 680 | 730 | 2024-06-28 |
| 19158 | Iced Hojicha Tea Latte 19158 | 46 46 | 740 | 790 | 2024-06-28 |
| 19159 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 19159 | 46 46 | 630 | 680 | 2024-06-28 |
| 19160 | Iced Shaken Zen Clouds Oolong Lemonade 19160 | 46 46 | 610 | 660 | 2024-06-28 |
| 19161 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 19161 | 46 46 | 630 | 680 | 2024-06-28 |
| 19162 | Origami Pike Place® Roast 19162 | 46 46 | 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");