item_prices

Pricing information for Starbucks menu items in Singapore

Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com

234 rows where store_id = 33

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 33 · 234 ✖
id ▼ item_id store_id base_price delivery_price effective_date
21069 Bagel 21069 33 33 400 430 2024-06-28
21070 Cookie Crumble Cheesecake 21070 33 33 720 770 2024-06-28
21071 Good Ol' NY Cheesecake 21071 33 33 720 770 2024-06-28
21072 Signature Chocolate Cake 21072 33 33 720 770 2024-06-28
21073 Starbucks® Coffee Tiramisu Cake 21073 33 33 750 800 2024-06-28
21074 Strawberry Shortcake 21074 33 33 720 770 2024-06-28
21075 Chocolate Chunk Monster Cookie 21075 33 33 390 440 2024-06-28
21076 Banana Walnut Muffin 21076 33 33 450 500 2024-06-28
21077 Blueberry Crumble Muffin 21077 33 33 450 500 2024-06-28
21078 Chocolate Crumble Muffin 21078 33 33 450 500 2024-06-28
21079 Pancakes 21079 33 33 550 600 2024-06-28
21080 Almond Croissant 21080 33 33 470 520 2024-06-28
21081 Buttery Croissant 21081 33 33 400 430 2024-06-28
21082 Chocolate Croissant 21082 33 33 440 490 2024-06-28
21083 Creamy Chicken Foldover 21083 33 33 550 600 2024-06-28
21084 Sausage Roll 21084 33 33 550 600 2024-06-28
21085 Buttery Scone 21085 33 33 400 430 2024-06-28
21086 Country Chicken Pie 21086 33 33 690 740 2024-06-28
21087 Deep Dish Beef Pie 21087 33 33 690 740 2024-06-28
21088 Spinach & Mushroom Quiche 21088 33 33 690 740 2024-06-28
21089 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 21089 33 33 390 420 2024-06-28
21090 Mixed Nuts 21090 33 33 490 540 2024-06-28
21091 Caramel Waffles 21091 33 33 390 420 2024-06-28
21092 Chicken Ham & Cheese Panwich 21092 33 33 690 740 2024-06-28
21093 Egg Mayo & Cheese Multigrain Croissant 21093 33 33 690 740 2024-06-28
21094 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 21094 33 33 690 740 2024-06-28
21095 Rosemary Chicken & Emmental Cheese Croissant 21095 33 33 690 740 2024-06-28
21096 Scrambled Egg & Turkey Ham Pita 21096 33 33 690 740 2024-06-28
21097 Turkey Ham & Triple Cheese Toast 21097 33 33 690 740 2024-06-28
21098 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 21098 33 33 790 840 2024-06-28
21099 Ham & Cheese Croissant 21099 33 33 690 740 2024-06-28
21100 Sriracha Chicken Whole Wheat Pita 21100 33 33 750 800 2024-06-28
21101 Blueberry Acai Yogurt Parfait 21101 33 33 650 700 2024-06-28
21102 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 21102 33 33 650 700 2024-06-28
21103 Caramel Frappuccino® 21103 33 33 720 770 2024-06-28
21104 Dark Mocha Frappuccino® 21104 33 33 780 830 2024-06-28
21105 Java Chip Frappuccino® 21105 33 33 780 830 2024-06-28
21106 Mocha Frappuccino® 21106 33 33 720 770 2024-06-28
21107 Caramel Macchiato Frappuccino® 21107 33 33 780 830 2024-06-28
21108 Espresso Frappuccino® 21108 33 33 720 770 2024-06-28
21109 White Chocolate Mocha Frappuccino® 21109 33 33 720 770 2024-06-28
21110 Chocolate Chip Cream Frappuccino® 21110 33 33 780 830 2024-06-28
21111 Hojicha Tea Cream Frappuccino® 21111 33 33 760 810 2024-06-28
21112 Vanilla Cream Frappuccino® 21112 33 33 720 770 2024-06-28
21113 Mango Passion Fruit & Hibiscus 21113 33 33 720 770 2024-06-28
21114 Raspberry Black Currant & Oolong 21114 33 33 720 770 2024-06-28
21115 Coffee Traveller 21115 33 33 3120 3170 2024-06-28
21116 Caffè Americano 21116 33 33 540 590 2024-06-28
21117 Cappuccino 21117 33 33 680 730 2024-06-28
21118 Caffè Mocha 21118 33 33 750 800 2024-06-28
21119 Caramel Macchiato 21119 33 33 760 810 2024-06-28
21120 Espresso 21120 33 33 390 440 2024-06-28
21121 Caffè Latte 21121 33 33 680 730 2024-06-28
21122 Oatmilk Latte 21122 33 33 760 810 2024-06-28
21123 Vanilla Latte 21123 33 33 750 800 2024-06-28
21124 White Chocolate Mocha 21124 33 33 750 800 2024-06-28
21125 Flat White 21125 33 33 760 810 2024-06-28
21126 Ristretto Bianco 21126 33 33 760 810 2024-06-28
21127 Iced Caffè Americano 21127 33 33 540 590 2024-06-28
21128 Iced Cappuccino 21128 33 33 680 730 2024-06-28
21129 Iced Caffè Mocha 21129 33 33 750 800 2024-06-28
21130 Iced Caramel Macchiato 21130 33 33 760 810 2024-06-28
21131 Iced Caffè Latte 21131 33 33 680 730 2024-06-28
21132 Iced Oatmilk Latte 21132 33 33 760 810 2024-06-28
21133 Iced Vanilla Latte 21133 33 33 750 800 2024-06-28
21134 Iced White Chocolate Mocha 21134 33 33 750 800 2024-06-28
21135 Signature Hot Chocolate 21135 33 33 720 770 2024-06-28
21136 Signature Iced Chocolate 21136 33 33 720 770 2024-06-28
21137 Carrot Juice 21137 33 33 490 540 2024-06-28
21138 Cloudy Apple Juice 21138 33 33 490 540 2024-06-28
21139 Cranberry Red Grapefruit Juice 21139 33 33 490 540 2024-06-28
21140 Orange Juice 21140 33 33 490 540 2024-06-28
21141 Evian 21141 33 33 350 400 2024-06-28
21142 Sparkling Water 21142 33 33 450 500 2024-06-28
21143 Chai Tea 21143 33 33 500 550 2024-06-28
21144 Earl Grey Tea 21144 33 33 500 550 2024-06-28
21145 English Breakfast Tea 21145 33 33 500 550 2024-06-28
21146 Emperor’s Clouds & Mist™ Tea 21146 33 33 500 550 2024-06-28
21147 Mint Blend Tea 21147 33 33 500 550 2024-06-28
21148 Chamomile Tea 21148 33 33 500 550 2024-06-28
21149 Pure Matcha Latte 21149 33 33 740 790 2024-06-28
21150 Chai Tea Latte 21150 33 33 680 730 2024-06-28
21151 Earl Grey Tea Latte 21151 33 33 680 730 2024-06-28
21152 English Breakfast Tea Latte 21152 33 33 680 730 2024-06-28
21153 Hojicha Tea Latte 21153 33 33 740 790 2024-06-28
21154 Zen Clouds Oolong Tea 21154 33 33 500 550 2024-06-28
21155 Zen Clouds Oolong with Ruby Grapefruit and Honey 21155 33 33 630 680 2024-06-28
21156 Youthberry™ Tea 21156 33 33 500 550 2024-06-28
21157 Iced Shaken Black Tea Lemonade 21157 33 33 610 660 2024-06-28
21158 Iced Shaken Strawberry Black Tea Lemonade 21158 33 33 630 680 2024-06-28
21159 Iced Shaken Hibiscus Tea Lemonade 21159 33 33 610 660 2024-06-28
21160 Iced Shaken Hibiscus Tea with Pomegranate Pearls 21160 33 33 730 780 2024-06-28
21161 Iced Pure Matcha Latte 21161 33 33 740 790 2024-06-28
21162 Iced Chai Tea Latte 21162 33 33 680 730 2024-06-28
21163 Iced Black Tea Latte 21163 33 33 680 730 2024-06-28
21164 Iced Hojicha Tea Latte 21164 33 33 740 790 2024-06-28
21165 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 21165 33 33 630 680 2024-06-28
21166 Iced Shaken Zen Clouds Oolong Lemonade 21166 33 33 610 660 2024-06-28
21167 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 21167 33 33 630 680 2024-06-28
21168 Origami Pike Place® Roast 21168 33 33 990 1040 2024-06-28

Next page

Advanced export

JSON shape: default, array, newline-delimited, object

CSV options: 

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");