item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 117
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 182
- 2024-11-10 14
- 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
- 117 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 7346 | Bagel 7346 | 117 117 | 400 | 430 | 2024-06-28 |
| 7347 | Cookie Crumble Cheesecake 7347 | 117 117 | 720 | 770 | 2024-06-28 |
| 7348 | Good Ol' NY Cheesecake 7348 | 117 117 | 720 | 770 | 2024-06-28 |
| 7349 | Signature Chocolate Cake 7349 | 117 117 | 720 | 770 | 2024-06-28 |
| 7350 | Starbucks® Coffee Tiramisu Cake 7350 | 117 117 | 750 | 800 | 2024-06-28 |
| 7351 | Strawberry Shortcake 7351 | 117 117 | 720 | 770 | 2024-06-28 |
| 7352 | Chocolate Chunk Monster Cookie 7352 | 117 117 | 390 | 440 | 2024-06-28 |
| 7353 | Banana Walnut Muffin 7353 | 117 117 | 450 | 500 | 2024-06-28 |
| 7354 | Blueberry Crumble Muffin 7354 | 117 117 | 450 | 500 | 2024-06-28 |
| 7355 | Chocolate Crumble Muffin 7355 | 117 117 | 450 | 500 | 2024-06-28 |
| 7356 | Pancakes 7356 | 117 117 | 550 | 600 | 2024-06-28 |
| 7357 | Almond Croissant 7357 | 117 117 | 470 | 520 | 2024-06-28 |
| 7358 | Buttery Croissant 7358 | 117 117 | 400 | 430 | 2024-06-28 |
| 7359 | Chocolate Croissant 7359 | 117 117 | 440 | 490 | 2024-06-28 |
| 7360 | Creamy Chicken Foldover 7360 | 117 117 | 550 | 600 | 2024-06-28 |
| 7361 | Sausage Roll 7361 | 117 117 | 550 | 600 | 2024-06-28 |
| 7362 | Buttery Scone 7362 | 117 117 | 400 | 430 | 2024-06-28 |
| 7363 | Country Chicken Pie 7363 | 117 117 | 690 | 740 | 2024-06-28 |
| 7364 | Deep Dish Beef Pie 7364 | 117 117 | 690 | 740 | 2024-06-28 |
| 7365 | Spinach & Mushroom Quiche 7365 | 117 117 | 690 | 740 | 2024-06-28 |
| 7366 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 7366 | 117 117 | 390 | 420 | 2024-06-28 |
| 7367 | Mixed Nuts 7367 | 117 117 | 490 | 540 | 2024-06-28 |
| 7368 | Caramel Waffles 7368 | 117 117 | 390 | 420 | 2024-06-28 |
| 7369 | Chicken Ham & Cheese Panwich 7369 | 117 117 | 690 | 740 | 2024-06-28 |
| 7370 | Egg Mayo & Cheese Multigrain Croissant 7370 | 117 117 | 690 | 740 | 2024-06-28 |
| 7371 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 7371 | 117 117 | 690 | 740 | 2024-06-28 |
| 7372 | Rosemary Chicken & Emmental Cheese Croissant 7372 | 117 117 | 690 | 740 | 2024-06-28 |
| 7373 | Scrambled Egg & Turkey Ham Pita 7373 | 117 117 | 690 | 740 | 2024-06-28 |
| 7374 | Turkey Ham & Triple Cheese Toast 7374 | 117 117 | 690 | 740 | 2024-06-28 |
| 7375 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 7375 | 117 117 | 790 | 840 | 2024-06-28 |
| 7376 | Ham & Cheese Croissant 7376 | 117 117 | 690 | 740 | 2024-06-28 |
| 7377 | Sriracha Chicken Whole Wheat Pita 7377 | 117 117 | 750 | 800 | 2024-06-28 |
| 7378 | Blueberry Acai Yogurt Parfait 7378 | 117 117 | 650 | 700 | 2024-06-28 |
| 7379 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 7379 | 117 117 | 650 | 700 | 2024-06-28 |
| 7380 | Caramel Frappuccino® 7380 | 117 117 | 720 | 770 | 2024-06-28 |
| 7381 | Dark Mocha Frappuccino® 7381 | 117 117 | 780 | 830 | 2024-06-28 |
| 7382 | Java Chip Frappuccino® 7382 | 117 117 | 780 | 830 | 2024-06-28 |
| 7383 | Mocha Frappuccino® 7383 | 117 117 | 720 | 770 | 2024-06-28 |
| 7384 | Caramel Macchiato Frappuccino® 7384 | 117 117 | 780 | 830 | 2024-06-28 |
| 7385 | Espresso Frappuccino® 7385 | 117 117 | 720 | 770 | 2024-06-28 |
| 7386 | White Chocolate Mocha Frappuccino® 7386 | 117 117 | 720 | 770 | 2024-06-28 |
| 7387 | Chocolate Chip Cream Frappuccino® 7387 | 117 117 | 780 | 830 | 2024-06-28 |
| 7388 | Hojicha Tea Cream Frappuccino® 7388 | 117 117 | 760 | 810 | 2024-06-28 |
| 7389 | Vanilla Cream Frappuccino® 7389 | 117 117 | 720 | 770 | 2024-06-28 |
| 7390 | Mango Passion Fruit & Hibiscus 7390 | 117 117 | 720 | 770 | 2024-06-28 |
| 7391 | Raspberry Black Currant & Oolong 7391 | 117 117 | 720 | 770 | 2024-06-28 |
| 7392 | Coffee Traveller 7392 | 117 117 | 3120 | 3170 | 2024-06-28 |
| 7393 | Caffè Americano 7393 | 117 117 | 540 | 590 | 2024-06-28 |
| 7394 | Cappuccino 7394 | 117 117 | 680 | 730 | 2024-06-28 |
| 7395 | Caffè Mocha 7395 | 117 117 | 750 | 800 | 2024-06-28 |
| 7396 | Caramel Macchiato 7396 | 117 117 | 760 | 810 | 2024-06-28 |
| 7397 | Espresso 7397 | 117 117 | 390 | 440 | 2024-06-28 |
| 7398 | Caffè Latte 7398 | 117 117 | 680 | 730 | 2024-06-28 |
| 7399 | Oatmilk Latte 7399 | 117 117 | 760 | 810 | 2024-06-28 |
| 7400 | Vanilla Latte 7400 | 117 117 | 750 | 800 | 2024-06-28 |
| 7401 | White Chocolate Mocha 7401 | 117 117 | 750 | 800 | 2024-06-28 |
| 7402 | Flat White 7402 | 117 117 | 760 | 810 | 2024-06-28 |
| 7403 | Ristretto Bianco 7403 | 117 117 | 760 | 810 | 2024-06-28 |
| 7404 | Iced Caffè Americano 7404 | 117 117 | 540 | 590 | 2024-06-28 |
| 7405 | Iced Cappuccino 7405 | 117 117 | 680 | 730 | 2024-06-28 |
| 7406 | Iced Caffè Mocha 7406 | 117 117 | 750 | 800 | 2024-06-28 |
| 7407 | Iced Caramel Macchiato 7407 | 117 117 | 760 | 810 | 2024-06-28 |
| 7408 | Iced Caffè Latte 7408 | 117 117 | 680 | 730 | 2024-06-28 |
| 7409 | Iced Oatmilk Latte 7409 | 117 117 | 760 | 810 | 2024-06-28 |
| 7410 | Iced Vanilla Latte 7410 | 117 117 | 750 | 800 | 2024-06-28 |
| 7411 | Iced White Chocolate Mocha 7411 | 117 117 | 750 | 800 | 2024-06-28 |
| 7412 | Signature Hot Chocolate 7412 | 117 117 | 720 | 770 | 2024-06-28 |
| 7413 | Signature Iced Chocolate 7413 | 117 117 | 720 | 770 | 2024-06-28 |
| 7414 | Carrot Juice 7414 | 117 117 | 490 | 540 | 2024-06-28 |
| 7415 | Cloudy Apple Juice 7415 | 117 117 | 490 | 540 | 2024-06-28 |
| 7416 | Cranberry Red Grapefruit Juice 7416 | 117 117 | 490 | 540 | 2024-06-28 |
| 7417 | Orange Juice 7417 | 117 117 | 490 | 540 | 2024-06-28 |
| 7418 | Evian 7418 | 117 117 | 350 | 400 | 2024-06-28 |
| 7419 | Sparkling Water 7419 | 117 117 | 450 | 500 | 2024-06-28 |
| 7420 | Chai Tea 7420 | 117 117 | 500 | 550 | 2024-06-28 |
| 7421 | Earl Grey Tea 7421 | 117 117 | 500 | 550 | 2024-06-28 |
| 7422 | English Breakfast Tea 7422 | 117 117 | 500 | 550 | 2024-06-28 |
| 7423 | Emperor’s Clouds & Mist™ Tea 7423 | 117 117 | 500 | 550 | 2024-06-28 |
| 7424 | Mint Blend Tea 7424 | 117 117 | 500 | 550 | 2024-06-28 |
| 7425 | Chamomile Tea 7425 | 117 117 | 500 | 550 | 2024-06-28 |
| 7426 | Pure Matcha Latte 7426 | 117 117 | 740 | 790 | 2024-06-28 |
| 7427 | Chai Tea Latte 7427 | 117 117 | 680 | 730 | 2024-06-28 |
| 7428 | Earl Grey Tea Latte 7428 | 117 117 | 680 | 730 | 2024-06-28 |
| 7429 | English Breakfast Tea Latte 7429 | 117 117 | 680 | 730 | 2024-06-28 |
| 7430 | Hojicha Tea Latte 7430 | 117 117 | 740 | 790 | 2024-06-28 |
| 7431 | Zen Clouds Oolong Tea 7431 | 117 117 | 500 | 550 | 2024-06-28 |
| 7432 | Zen Clouds Oolong with Ruby Grapefruit and Honey 7432 | 117 117 | 630 | 680 | 2024-06-28 |
| 7433 | Youthberry™ Tea 7433 | 117 117 | 500 | 550 | 2024-06-28 |
| 7434 | Iced Shaken Black Tea Lemonade 7434 | 117 117 | 610 | 660 | 2024-06-28 |
| 7435 | Iced Shaken Strawberry Black Tea Lemonade 7435 | 117 117 | 630 | 680 | 2024-06-28 |
| 7436 | Iced Shaken Hibiscus Tea Lemonade 7436 | 117 117 | 610 | 660 | 2024-06-28 |
| 7437 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 7437 | 117 117 | 730 | 780 | 2024-06-28 |
| 7438 | Iced Pure Matcha Latte 7438 | 117 117 | 740 | 790 | 2024-06-28 |
| 7439 | Iced Chai Tea Latte 7439 | 117 117 | 680 | 730 | 2024-06-28 |
| 7440 | Iced Black Tea Latte 7440 | 117 117 | 680 | 730 | 2024-06-28 |
| 7441 | Iced Hojicha Tea Latte 7441 | 117 117 | 740 | 790 | 2024-06-28 |
| 7442 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 7442 | 117 117 | 630 | 680 | 2024-06-28 |
| 7443 | Iced Shaken Zen Clouds Oolong Lemonade 7443 | 117 117 | 610 | 660 | 2024-06-28 |
| 7444 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 7444 | 117 117 | 630 | 680 | 2024-06-28 |
| 7445 | Origami Pike Place® Roast 7445 | 117 117 | 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");