item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
252 rows where store_id = 107
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 184
- 2024-11-10 14
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-08-18 6
- 2024-07-28 5
- 2024-10-13 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-07-14 2
- 2024-09-29 2
store_id 1
- 107 · 252 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 9166 | Bagel 9166 | 107 107 | 400 | 430 | 2024-06-28 |
| 9167 | Cookie Crumble Cheesecake 9167 | 107 107 | 720 | 770 | 2024-06-28 |
| 9168 | Good Ol' NY Cheesecake 9168 | 107 107 | 720 | 770 | 2024-06-28 |
| 9169 | Signature Chocolate Cake 9169 | 107 107 | 720 | 770 | 2024-06-28 |
| 9170 | Starbucks® Coffee Tiramisu Cake 9170 | 107 107 | 750 | 800 | 2024-06-28 |
| 9171 | Strawberry Shortcake 9171 | 107 107 | 720 | 770 | 2024-06-28 |
| 9172 | Chocolate Chunk Monster Cookie 9172 | 107 107 | 390 | 440 | 2024-06-28 |
| 9173 | Banana Walnut Muffin 9173 | 107 107 | 450 | 500 | 2024-06-28 |
| 9174 | Blueberry Crumble Muffin 9174 | 107 107 | 450 | 500 | 2024-06-28 |
| 9175 | Chocolate Crumble Muffin 9175 | 107 107 | 450 | 500 | 2024-06-28 |
| 9176 | Pancakes 9176 | 107 107 | 550 | 600 | 2024-06-28 |
| 9177 | Almond Croissant 9177 | 107 107 | 470 | 520 | 2024-06-28 |
| 9178 | Buttery Croissant 9178 | 107 107 | 400 | 430 | 2024-06-28 |
| 9179 | Chocolate Croissant 9179 | 107 107 | 440 | 490 | 2024-06-28 |
| 9180 | Creamy Chicken Foldover 9180 | 107 107 | 550 | 600 | 2024-06-28 |
| 9181 | Sausage Roll 9181 | 107 107 | 550 | 600 | 2024-06-28 |
| 9182 | Buttery Scone 9182 | 107 107 | 400 | 430 | 2024-06-28 |
| 9183 | Country Chicken Pie 9183 | 107 107 | 690 | 740 | 2024-06-28 |
| 9184 | Deep Dish Beef Pie 9184 | 107 107 | 690 | 740 | 2024-06-28 |
| 9185 | Spinach & Mushroom Quiche 9185 | 107 107 | 690 | 740 | 2024-06-28 |
| 9186 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 9186 | 107 107 | 390 | 420 | 2024-06-28 |
| 9187 | Mixed Nuts 9187 | 107 107 | 490 | 540 | 2024-06-28 |
| 9188 | Caramel Waffles 9188 | 107 107 | 390 | 420 | 2024-06-28 |
| 9189 | Chicken Ham & Cheese Panwich 9189 | 107 107 | 690 | 740 | 2024-06-28 |
| 9190 | Egg Mayo & Cheese Multigrain Croissant 9190 | 107 107 | 690 | 740 | 2024-06-28 |
| 9191 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 9191 | 107 107 | 690 | 740 | 2024-06-28 |
| 9192 | Rosemary Chicken & Emmental Cheese Croissant 9192 | 107 107 | 690 | 740 | 2024-06-28 |
| 9193 | Scrambled Egg & Turkey Ham Pita 9193 | 107 107 | 690 | 740 | 2024-06-28 |
| 9194 | Turkey Ham & Triple Cheese Toast 9194 | 107 107 | 690 | 740 | 2024-06-28 |
| 9195 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 9195 | 107 107 | 790 | 840 | 2024-06-28 |
| 9196 | Ham & Cheese Croissant 9196 | 107 107 | 690 | 740 | 2024-06-28 |
| 9197 | Sriracha Chicken Whole Wheat Pita 9197 | 107 107 | 750 | 800 | 2024-06-28 |
| 9198 | Blueberry Acai Yogurt Parfait 9198 | 107 107 | 650 | 700 | 2024-06-28 |
| 9199 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 9199 | 107 107 | 650 | 700 | 2024-06-28 |
| 9200 | Caramel Frappuccino® 9200 | 107 107 | 720 | 770 | 2024-06-28 |
| 9201 | Dark Mocha Frappuccino® 9201 | 107 107 | 780 | 830 | 2024-06-28 |
| 9202 | Java Chip Frappuccino® 9202 | 107 107 | 780 | 830 | 2024-06-28 |
| 9203 | Mocha Frappuccino® 9203 | 107 107 | 720 | 770 | 2024-06-28 |
| 9204 | Caramel Macchiato Frappuccino® 9204 | 107 107 | 780 | 830 | 2024-06-28 |
| 9205 | Espresso Frappuccino® 9205 | 107 107 | 720 | 770 | 2024-06-28 |
| 9206 | White Chocolate Mocha Frappuccino® 9206 | 107 107 | 720 | 770 | 2024-06-28 |
| 9207 | Chocolate Chip Cream Frappuccino® 9207 | 107 107 | 780 | 830 | 2024-06-28 |
| 9208 | Hojicha Tea Cream Frappuccino® 9208 | 107 107 | 760 | 810 | 2024-06-28 |
| 9209 | Vanilla Cream Frappuccino® 9209 | 107 107 | 720 | 770 | 2024-06-28 |
| 9210 | Mango Passion Fruit & Hibiscus 9210 | 107 107 | 720 | 770 | 2024-06-28 |
| 9211 | Raspberry Black Currant & Oolong 9211 | 107 107 | 720 | 770 | 2024-06-28 |
| 9212 | Coffee Traveller 9212 | 107 107 | 3120 | 3170 | 2024-06-28 |
| 9213 | Caffè Americano 9213 | 107 107 | 540 | 590 | 2024-06-28 |
| 9214 | Cappuccino 9214 | 107 107 | 680 | 730 | 2024-06-28 |
| 9215 | Caffè Mocha 9215 | 107 107 | 750 | 800 | 2024-06-28 |
| 9216 | Caramel Macchiato 9216 | 107 107 | 760 | 810 | 2024-06-28 |
| 9217 | Espresso 9217 | 107 107 | 390 | 440 | 2024-06-28 |
| 9218 | Caffè Latte 9218 | 107 107 | 680 | 730 | 2024-06-28 |
| 9219 | Oatmilk Latte 9219 | 107 107 | 760 | 810 | 2024-06-28 |
| 9220 | Vanilla Latte 9220 | 107 107 | 750 | 800 | 2024-06-28 |
| 9221 | White Chocolate Mocha 9221 | 107 107 | 750 | 800 | 2024-06-28 |
| 9222 | Flat White 9222 | 107 107 | 760 | 810 | 2024-06-28 |
| 9223 | Ristretto Bianco 9223 | 107 107 | 760 | 810 | 2024-06-28 |
| 9224 | Iced Caffè Americano 9224 | 107 107 | 540 | 590 | 2024-06-28 |
| 9225 | Iced Cappuccino 9225 | 107 107 | 680 | 730 | 2024-06-28 |
| 9226 | Iced Caffè Mocha 9226 | 107 107 | 750 | 800 | 2024-06-28 |
| 9227 | Iced Caramel Macchiato 9227 | 107 107 | 760 | 810 | 2024-06-28 |
| 9228 | Iced Caffè Latte 9228 | 107 107 | 680 | 730 | 2024-06-28 |
| 9229 | Iced Oatmilk Latte 9229 | 107 107 | 760 | 810 | 2024-06-28 |
| 9230 | Iced Vanilla Latte 9230 | 107 107 | 750 | 800 | 2024-06-28 |
| 9231 | Iced White Chocolate Mocha 9231 | 107 107 | 750 | 800 | 2024-06-28 |
| 9232 | Signature Hot Chocolate 9232 | 107 107 | 720 | 770 | 2024-06-28 |
| 9233 | Signature Iced Chocolate 9233 | 107 107 | 720 | 770 | 2024-06-28 |
| 9234 | Carrot Juice 9234 | 107 107 | 490 | 540 | 2024-06-28 |
| 9235 | Cloudy Apple Juice 9235 | 107 107 | 490 | 540 | 2024-06-28 |
| 9236 | Cranberry Red Grapefruit Juice 9236 | 107 107 | 490 | 540 | 2024-06-28 |
| 9237 | Orange Juice 9237 | 107 107 | 490 | 540 | 2024-06-28 |
| 9238 | Evian 9238 | 107 107 | 350 | 400 | 2024-06-28 |
| 9239 | Sparkling Water 9239 | 107 107 | 450 | 500 | 2024-06-28 |
| 9240 | Chai Tea 9240 | 107 107 | 500 | 550 | 2024-06-28 |
| 9241 | Earl Grey Tea 9241 | 107 107 | 500 | 550 | 2024-06-28 |
| 9242 | English Breakfast Tea 9242 | 107 107 | 500 | 550 | 2024-06-28 |
| 9243 | Emperor’s Clouds & Mist™ Tea 9243 | 107 107 | 500 | 550 | 2024-06-28 |
| 9244 | Mint Blend Tea 9244 | 107 107 | 500 | 550 | 2024-06-28 |
| 9245 | Chamomile Tea 9245 | 107 107 | 500 | 550 | 2024-06-28 |
| 9246 | Pure Matcha Latte 9246 | 107 107 | 740 | 790 | 2024-06-28 |
| 9247 | Chai Tea Latte 9247 | 107 107 | 680 | 730 | 2024-06-28 |
| 9248 | Earl Grey Tea Latte 9248 | 107 107 | 680 | 730 | 2024-06-28 |
| 9249 | English Breakfast Tea Latte 9249 | 107 107 | 680 | 730 | 2024-06-28 |
| 9250 | Hojicha Tea Latte 9250 | 107 107 | 740 | 790 | 2024-06-28 |
| 9251 | Zen Clouds Oolong Tea 9251 | 107 107 | 500 | 550 | 2024-06-28 |
| 9252 | Zen Clouds Oolong with Ruby Grapefruit and Honey 9252 | 107 107 | 630 | 680 | 2024-06-28 |
| 9253 | Youthberry™ Tea 9253 | 107 107 | 500 | 550 | 2024-06-28 |
| 9254 | Iced Shaken Black Tea Lemonade 9254 | 107 107 | 610 | 660 | 2024-06-28 |
| 9255 | Iced Shaken Strawberry Black Tea Lemonade 9255 | 107 107 | 630 | 680 | 2024-06-28 |
| 9256 | Iced Shaken Hibiscus Tea Lemonade 9256 | 107 107 | 610 | 660 | 2024-06-28 |
| 9257 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 9257 | 107 107 | 730 | 780 | 2024-06-28 |
| 9258 | Iced Pure Matcha Latte 9258 | 107 107 | 740 | 790 | 2024-06-28 |
| 9259 | Iced Chai Tea Latte 9259 | 107 107 | 680 | 730 | 2024-06-28 |
| 9260 | Iced Black Tea Latte 9260 | 107 107 | 680 | 730 | 2024-06-28 |
| 9261 | Iced Hojicha Tea Latte 9261 | 107 107 | 740 | 790 | 2024-06-28 |
| 9262 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 9262 | 107 107 | 630 | 680 | 2024-06-28 |
| 9263 | Iced Shaken Zen Clouds Oolong Lemonade 9263 | 107 107 | 610 | 660 | 2024-06-28 |
| 9264 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 9264 | 107 107 | 630 | 680 | 2024-06-28 |
| 9265 | Origami Pike Place® Roast 9265 | 107 107 | 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");