item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
252 rows where store_id = 119
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 14
- 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-12-07 3
- 2024-07-14 2
- 2024-09-29 2
- 2024-11-17 1
store_id 1
- 119 · 252 ✖
id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
---|---|---|---|---|---|
6982 | Bagel 6982 | 119 119 | 400 | 430 | 2024-06-28 |
6983 | Cookie Crumble Cheesecake 6983 | 119 119 | 720 | 770 | 2024-06-28 |
6984 | Good Ol' NY Cheesecake 6984 | 119 119 | 720 | 770 | 2024-06-28 |
6985 | Signature Chocolate Cake 6985 | 119 119 | 720 | 770 | 2024-06-28 |
6986 | Starbucks® Coffee Tiramisu Cake 6986 | 119 119 | 750 | 800 | 2024-06-28 |
6987 | Strawberry Shortcake 6987 | 119 119 | 720 | 770 | 2024-06-28 |
6988 | Chocolate Chunk Monster Cookie 6988 | 119 119 | 390 | 440 | 2024-06-28 |
6989 | Banana Walnut Muffin 6989 | 119 119 | 450 | 500 | 2024-06-28 |
6990 | Blueberry Crumble Muffin 6990 | 119 119 | 450 | 500 | 2024-06-28 |
6991 | Chocolate Crumble Muffin 6991 | 119 119 | 450 | 500 | 2024-06-28 |
6992 | Pancakes 6992 | 119 119 | 550 | 600 | 2024-06-28 |
6993 | Almond Croissant 6993 | 119 119 | 470 | 520 | 2024-06-28 |
6994 | Buttery Croissant 6994 | 119 119 | 400 | 430 | 2024-06-28 |
6995 | Chocolate Croissant 6995 | 119 119 | 440 | 490 | 2024-06-28 |
6996 | Creamy Chicken Foldover 6996 | 119 119 | 550 | 600 | 2024-06-28 |
6997 | Sausage Roll 6997 | 119 119 | 550 | 600 | 2024-06-28 |
6998 | Buttery Scone 6998 | 119 119 | 400 | 430 | 2024-06-28 |
6999 | Country Chicken Pie 6999 | 119 119 | 690 | 740 | 2024-06-28 |
7000 | Deep Dish Beef Pie 7000 | 119 119 | 690 | 740 | 2024-06-28 |
7001 | Spinach & Mushroom Quiche 7001 | 119 119 | 690 | 740 | 2024-06-28 |
7002 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 7002 | 119 119 | 390 | 420 | 2024-06-28 |
7003 | Mixed Nuts 7003 | 119 119 | 490 | 540 | 2024-06-28 |
7004 | Caramel Waffles 7004 | 119 119 | 390 | 420 | 2024-06-28 |
7005 | Chicken Ham & Cheese Panwich 7005 | 119 119 | 690 | 740 | 2024-06-28 |
7006 | Egg Mayo & Cheese Multigrain Croissant 7006 | 119 119 | 690 | 740 | 2024-06-28 |
7007 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 7007 | 119 119 | 690 | 740 | 2024-06-28 |
7008 | Rosemary Chicken & Emmental Cheese Croissant 7008 | 119 119 | 690 | 740 | 2024-06-28 |
7009 | Scrambled Egg & Turkey Ham Pita 7009 | 119 119 | 690 | 740 | 2024-06-28 |
7010 | Turkey Ham & Triple Cheese Toast 7010 | 119 119 | 690 | 740 | 2024-06-28 |
7011 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 7011 | 119 119 | 790 | 840 | 2024-06-28 |
7012 | Ham & Cheese Croissant 7012 | 119 119 | 690 | 740 | 2024-06-28 |
7013 | Sriracha Chicken Whole Wheat Pita 7013 | 119 119 | 750 | 800 | 2024-06-28 |
7014 | Blueberry Acai Yogurt Parfait 7014 | 119 119 | 650 | 700 | 2024-06-28 |
7015 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 7015 | 119 119 | 650 | 700 | 2024-06-28 |
7016 | Caramel Frappuccino® 7016 | 119 119 | 720 | 770 | 2024-06-28 |
7017 | Dark Mocha Frappuccino® 7017 | 119 119 | 780 | 830 | 2024-06-28 |
7018 | Java Chip Frappuccino® 7018 | 119 119 | 780 | 830 | 2024-06-28 |
7019 | Mocha Frappuccino® 7019 | 119 119 | 720 | 770 | 2024-06-28 |
7020 | Caramel Macchiato Frappuccino® 7020 | 119 119 | 780 | 830 | 2024-06-28 |
7021 | Espresso Frappuccino® 7021 | 119 119 | 720 | 770 | 2024-06-28 |
7022 | White Chocolate Mocha Frappuccino® 7022 | 119 119 | 720 | 770 | 2024-06-28 |
7023 | Chocolate Chip Cream Frappuccino® 7023 | 119 119 | 780 | 830 | 2024-06-28 |
7024 | Hojicha Tea Cream Frappuccino® 7024 | 119 119 | 760 | 810 | 2024-06-28 |
7025 | Vanilla Cream Frappuccino® 7025 | 119 119 | 720 | 770 | 2024-06-28 |
7026 | Mango Passion Fruit & Hibiscus 7026 | 119 119 | 720 | 770 | 2024-06-28 |
7027 | Raspberry Black Currant & Oolong 7027 | 119 119 | 720 | 770 | 2024-06-28 |
7028 | Coffee Traveller 7028 | 119 119 | 3120 | 3170 | 2024-06-28 |
7029 | Caffè Americano 7029 | 119 119 | 540 | 590 | 2024-06-28 |
7030 | Cappuccino 7030 | 119 119 | 680 | 730 | 2024-06-28 |
7031 | Caffè Mocha 7031 | 119 119 | 750 | 800 | 2024-06-28 |
7032 | Caramel Macchiato 7032 | 119 119 | 760 | 810 | 2024-06-28 |
7033 | Espresso 7033 | 119 119 | 390 | 440 | 2024-06-28 |
7034 | Caffè Latte 7034 | 119 119 | 680 | 730 | 2024-06-28 |
7035 | Oatmilk Latte 7035 | 119 119 | 760 | 810 | 2024-06-28 |
7036 | Vanilla Latte 7036 | 119 119 | 750 | 800 | 2024-06-28 |
7037 | White Chocolate Mocha 7037 | 119 119 | 750 | 800 | 2024-06-28 |
7038 | Flat White 7038 | 119 119 | 760 | 810 | 2024-06-28 |
7039 | Ristretto Bianco 7039 | 119 119 | 760 | 810 | 2024-06-28 |
7040 | Iced Caffè Americano 7040 | 119 119 | 540 | 590 | 2024-06-28 |
7041 | Iced Cappuccino 7041 | 119 119 | 680 | 730 | 2024-06-28 |
7042 | Iced Caffè Mocha 7042 | 119 119 | 750 | 800 | 2024-06-28 |
7043 | Iced Caramel Macchiato 7043 | 119 119 | 760 | 810 | 2024-06-28 |
7044 | Iced Caffè Latte 7044 | 119 119 | 680 | 730 | 2024-06-28 |
7045 | Iced Oatmilk Latte 7045 | 119 119 | 760 | 810 | 2024-06-28 |
7046 | Iced Vanilla Latte 7046 | 119 119 | 750 | 800 | 2024-06-28 |
7047 | Iced White Chocolate Mocha 7047 | 119 119 | 750 | 800 | 2024-06-28 |
7048 | Signature Hot Chocolate 7048 | 119 119 | 720 | 770 | 2024-06-28 |
7049 | Signature Iced Chocolate 7049 | 119 119 | 720 | 770 | 2024-06-28 |
7050 | Carrot Juice 7050 | 119 119 | 490 | 540 | 2024-06-28 |
7051 | Cloudy Apple Juice 7051 | 119 119 | 490 | 540 | 2024-06-28 |
7052 | Cranberry Red Grapefruit Juice 7052 | 119 119 | 490 | 540 | 2024-06-28 |
7053 | Orange Juice 7053 | 119 119 | 490 | 540 | 2024-06-28 |
7054 | Evian 7054 | 119 119 | 350 | 400 | 2024-06-28 |
7055 | Sparkling Water 7055 | 119 119 | 450 | 500 | 2024-06-28 |
7056 | Chai Tea 7056 | 119 119 | 500 | 550 | 2024-06-28 |
7057 | Earl Grey Tea 7057 | 119 119 | 500 | 550 | 2024-06-28 |
7058 | English Breakfast Tea 7058 | 119 119 | 500 | 550 | 2024-06-28 |
7059 | Emperor’s Clouds & Mist™ Tea 7059 | 119 119 | 500 | 550 | 2024-06-28 |
7060 | Mint Blend Tea 7060 | 119 119 | 500 | 550 | 2024-06-28 |
7061 | Chamomile Tea 7061 | 119 119 | 500 | 550 | 2024-06-28 |
7062 | Pure Matcha Latte 7062 | 119 119 | 740 | 790 | 2024-06-28 |
7063 | Chai Tea Latte 7063 | 119 119 | 680 | 730 | 2024-06-28 |
7064 | Earl Grey Tea Latte 7064 | 119 119 | 680 | 730 | 2024-06-28 |
7065 | English Breakfast Tea Latte 7065 | 119 119 | 680 | 730 | 2024-06-28 |
7066 | Hojicha Tea Latte 7066 | 119 119 | 740 | 790 | 2024-06-28 |
7067 | Zen Clouds Oolong Tea 7067 | 119 119 | 500 | 550 | 2024-06-28 |
7068 | Zen Clouds Oolong with Ruby Grapefruit and Honey 7068 | 119 119 | 630 | 680 | 2024-06-28 |
7069 | Youthberry™ Tea 7069 | 119 119 | 500 | 550 | 2024-06-28 |
7070 | Iced Shaken Black Tea Lemonade 7070 | 119 119 | 610 | 660 | 2024-06-28 |
7071 | Iced Shaken Strawberry Black Tea Lemonade 7071 | 119 119 | 630 | 680 | 2024-06-28 |
7072 | Iced Shaken Hibiscus Tea Lemonade 7072 | 119 119 | 610 | 660 | 2024-06-28 |
7073 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 7073 | 119 119 | 730 | 780 | 2024-06-28 |
7074 | Iced Pure Matcha Latte 7074 | 119 119 | 740 | 790 | 2024-06-28 |
7075 | Iced Chai Tea Latte 7075 | 119 119 | 680 | 730 | 2024-06-28 |
7076 | Iced Black Tea Latte 7076 | 119 119 | 680 | 730 | 2024-06-28 |
7077 | Iced Hojicha Tea Latte 7077 | 119 119 | 740 | 790 | 2024-06-28 |
7078 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 7078 | 119 119 | 630 | 680 | 2024-06-28 |
7079 | Iced Shaken Zen Clouds Oolong Lemonade 7079 | 119 119 | 610 | 660 | 2024-06-28 |
7080 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 7080 | 119 119 | 630 | 680 | 2024-06-28 |
7081 | Origami Pike Place® Roast 7081 | 119 119 | 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");