item_prices

Pricing information for Starbucks menu items in Singapore

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

248 rows where store_id = 113

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 113 · 248 ✖
id ▼ item_id store_id base_price delivery_price effective_date
8074 Bagel 8074 113 113 400 430 2024-06-28
8075 Cookie Crumble Cheesecake 8075 113 113 720 770 2024-06-28
8076 Good Ol' NY Cheesecake 8076 113 113 720 770 2024-06-28
8077 Signature Chocolate Cake 8077 113 113 720 770 2024-06-28
8078 Starbucks® Coffee Tiramisu Cake 8078 113 113 750 800 2024-06-28
8079 Strawberry Shortcake 8079 113 113 720 770 2024-06-28
8080 Chocolate Chunk Monster Cookie 8080 113 113 390 440 2024-06-28
8081 Banana Walnut Muffin 8081 113 113 450 500 2024-06-28
8082 Blueberry Crumble Muffin 8082 113 113 450 500 2024-06-28
8083 Chocolate Crumble Muffin 8083 113 113 450 500 2024-06-28
8084 Pancakes 8084 113 113 550 600 2024-06-28
8085 Almond Croissant 8085 113 113 470 520 2024-06-28
8086 Buttery Croissant 8086 113 113 400 430 2024-06-28
8087 Chocolate Croissant 8087 113 113 440 490 2024-06-28
8088 Creamy Chicken Foldover 8088 113 113 550 600 2024-06-28
8089 Sausage Roll 8089 113 113 550 600 2024-06-28
8090 Buttery Scone 8090 113 113 400 430 2024-06-28
8091 Country Chicken Pie 8091 113 113 690 740 2024-06-28
8092 Deep Dish Beef Pie 8092 113 113 690 740 2024-06-28
8093 Spinach & Mushroom Quiche 8093 113 113 690 740 2024-06-28
8094 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 8094 113 113 390 420 2024-06-28
8095 Mixed Nuts 8095 113 113 490 540 2024-06-28
8096 Caramel Waffles 8096 113 113 390 420 2024-06-28
8097 Chicken Ham & Cheese Panwich 8097 113 113 690 740 2024-06-28
8098 Egg Mayo & Cheese Multigrain Croissant 8098 113 113 690 740 2024-06-28
8099 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 8099 113 113 690 740 2024-06-28
8100 Rosemary Chicken & Emmental Cheese Croissant 8100 113 113 690 740 2024-06-28
8101 Scrambled Egg & Turkey Ham Pita 8101 113 113 690 740 2024-06-28
8102 Turkey Ham & Triple Cheese Toast 8102 113 113 690 740 2024-06-28
8103 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 8103 113 113 790 840 2024-06-28
8104 Ham & Cheese Croissant 8104 113 113 690 740 2024-06-28
8105 Sriracha Chicken Whole Wheat Pita 8105 113 113 750 800 2024-06-28
8106 Blueberry Acai Yogurt Parfait 8106 113 113 650 700 2024-06-28
8107 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 8107 113 113 650 700 2024-06-28
8108 Caramel Frappuccino® 8108 113 113 720 770 2024-06-28
8109 Dark Mocha Frappuccino® 8109 113 113 780 830 2024-06-28
8110 Java Chip Frappuccino® 8110 113 113 780 830 2024-06-28
8111 Mocha Frappuccino® 8111 113 113 720 770 2024-06-28
8112 Caramel Macchiato Frappuccino® 8112 113 113 780 830 2024-06-28
8113 Espresso Frappuccino® 8113 113 113 720 770 2024-06-28
8114 White Chocolate Mocha Frappuccino® 8114 113 113 720 770 2024-06-28
8115 Chocolate Chip Cream Frappuccino® 8115 113 113 780 830 2024-06-28
8116 Hojicha Tea Cream Frappuccino® 8116 113 113 760 810 2024-06-28
8117 Vanilla Cream Frappuccino® 8117 113 113 720 770 2024-06-28
8118 Mango Passion Fruit & Hibiscus 8118 113 113 720 770 2024-06-28
8119 Raspberry Black Currant & Oolong 8119 113 113 720 770 2024-06-28
8120 Coffee Traveller 8120 113 113 3120 3170 2024-06-28
8121 Caffè Americano 8121 113 113 540 590 2024-06-28
8122 Cappuccino 8122 113 113 680 730 2024-06-28
8123 Caffè Mocha 8123 113 113 750 800 2024-06-28
8124 Caramel Macchiato 8124 113 113 760 810 2024-06-28
8125 Espresso 8125 113 113 390 440 2024-06-28
8126 Caffè Latte 8126 113 113 680 730 2024-06-28
8127 Oatmilk Latte 8127 113 113 760 810 2024-06-28
8128 Vanilla Latte 8128 113 113 750 800 2024-06-28
8129 White Chocolate Mocha 8129 113 113 750 800 2024-06-28
8130 Flat White 8130 113 113 760 810 2024-06-28
8131 Ristretto Bianco 8131 113 113 760 810 2024-06-28
8132 Iced Caffè Americano 8132 113 113 540 590 2024-06-28
8133 Iced Cappuccino 8133 113 113 680 730 2024-06-28
8134 Iced Caffè Mocha 8134 113 113 750 800 2024-06-28
8135 Iced Caramel Macchiato 8135 113 113 760 810 2024-06-28
8136 Iced Caffè Latte 8136 113 113 680 730 2024-06-28
8137 Iced Oatmilk Latte 8137 113 113 760 810 2024-06-28
8138 Iced Vanilla Latte 8138 113 113 750 800 2024-06-28
8139 Iced White Chocolate Mocha 8139 113 113 750 800 2024-06-28
8140 Signature Hot Chocolate 8140 113 113 720 770 2024-06-28
8141 Signature Iced Chocolate 8141 113 113 720 770 2024-06-28
8142 Carrot Juice 8142 113 113 490 540 2024-06-28
8143 Cloudy Apple Juice 8143 113 113 490 540 2024-06-28
8144 Cranberry Red Grapefruit Juice 8144 113 113 490 540 2024-06-28
8145 Orange Juice 8145 113 113 490 540 2024-06-28
8146 Evian 8146 113 113 350 400 2024-06-28
8147 Sparkling Water 8147 113 113 450 500 2024-06-28
8148 Chai Tea 8148 113 113 500 550 2024-06-28
8149 Earl Grey Tea 8149 113 113 500 550 2024-06-28
8150 English Breakfast Tea 8150 113 113 500 550 2024-06-28
8151 Emperor’s Clouds & Mist™ Tea 8151 113 113 500 550 2024-06-28
8152 Mint Blend Tea 8152 113 113 500 550 2024-06-28
8153 Chamomile Tea 8153 113 113 500 550 2024-06-28
8154 Pure Matcha Latte 8154 113 113 740 790 2024-06-28
8155 Chai Tea Latte 8155 113 113 680 730 2024-06-28
8156 Earl Grey Tea Latte 8156 113 113 680 730 2024-06-28
8157 English Breakfast Tea Latte 8157 113 113 680 730 2024-06-28
8158 Hojicha Tea Latte 8158 113 113 740 790 2024-06-28
8159 Zen Clouds Oolong Tea 8159 113 113 500 550 2024-06-28
8160 Zen Clouds Oolong with Ruby Grapefruit and Honey 8160 113 113 630 680 2024-06-28
8161 Youthberry™ Tea 8161 113 113 500 550 2024-06-28
8162 Iced Shaken Black Tea Lemonade 8162 113 113 610 660 2024-06-28
8163 Iced Shaken Strawberry Black Tea Lemonade 8163 113 113 630 680 2024-06-28
8164 Iced Shaken Hibiscus Tea Lemonade 8164 113 113 610 660 2024-06-28
8165 Iced Shaken Hibiscus Tea with Pomegranate Pearls 8165 113 113 730 780 2024-06-28
8166 Iced Pure Matcha Latte 8166 113 113 740 790 2024-06-28
8167 Iced Chai Tea Latte 8167 113 113 680 730 2024-06-28
8168 Iced Black Tea Latte 8168 113 113 680 730 2024-06-28
8169 Iced Hojicha Tea Latte 8169 113 113 740 790 2024-06-28
8170 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 8170 113 113 630 680 2024-06-28
8171 Iced Shaken Zen Clouds Oolong Lemonade 8171 113 113 610 660 2024-06-28
8172 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 8172 113 113 630 680 2024-06-28
8173 Origami Pike Place® Roast 8173 113 113 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");