item_prices

Pricing information for Starbucks menu items in Singapore

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

249 rows where store_id = 118

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 118 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
7164 Bagel 7164 118 118 400 430 2024-06-28
7165 Cookie Crumble Cheesecake 7165 118 118 720 770 2024-06-28
7166 Good Ol' NY Cheesecake 7166 118 118 720 770 2024-06-28
7167 Signature Chocolate Cake 7167 118 118 720 770 2024-06-28
7168 Starbucks® Coffee Tiramisu Cake 7168 118 118 750 800 2024-06-28
7169 Strawberry Shortcake 7169 118 118 720 770 2024-06-28
7170 Chocolate Chunk Monster Cookie 7170 118 118 390 440 2024-06-28
7171 Banana Walnut Muffin 7171 118 118 450 500 2024-06-28
7172 Blueberry Crumble Muffin 7172 118 118 450 500 2024-06-28
7173 Chocolate Crumble Muffin 7173 118 118 450 500 2024-06-28
7174 Pancakes 7174 118 118 550 600 2024-06-28
7175 Almond Croissant 7175 118 118 470 520 2024-06-28
7176 Buttery Croissant 7176 118 118 400 430 2024-06-28
7177 Chocolate Croissant 7177 118 118 440 490 2024-06-28
7178 Creamy Chicken Foldover 7178 118 118 550 600 2024-06-28
7179 Sausage Roll 7179 118 118 550 600 2024-06-28
7180 Buttery Scone 7180 118 118 400 430 2024-06-28
7181 Country Chicken Pie 7181 118 118 690 740 2024-06-28
7182 Deep Dish Beef Pie 7182 118 118 690 740 2024-06-28
7183 Spinach & Mushroom Quiche 7183 118 118 690 740 2024-06-28
7184 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 7184 118 118 390 420 2024-06-28
7185 Mixed Nuts 7185 118 118 490 540 2024-06-28
7186 Caramel Waffles 7186 118 118 390 420 2024-06-28
7187 Chicken Ham & Cheese Panwich 7187 118 118 690 740 2024-06-28
7188 Egg Mayo & Cheese Multigrain Croissant 7188 118 118 690 740 2024-06-28
7189 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 7189 118 118 690 740 2024-06-28
7190 Rosemary Chicken & Emmental Cheese Croissant 7190 118 118 690 740 2024-06-28
7191 Scrambled Egg & Turkey Ham Pita 7191 118 118 690 740 2024-06-28
7192 Turkey Ham & Triple Cheese Toast 7192 118 118 690 740 2024-06-28
7193 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 7193 118 118 790 840 2024-06-28
7194 Ham & Cheese Croissant 7194 118 118 690 740 2024-06-28
7195 Sriracha Chicken Whole Wheat Pita 7195 118 118 750 800 2024-06-28
7196 Blueberry Acai Yogurt Parfait 7196 118 118 650 700 2024-06-28
7197 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 7197 118 118 650 700 2024-06-28
7198 Caramel Frappuccino® 7198 118 118 720 770 2024-06-28
7199 Dark Mocha Frappuccino® 7199 118 118 780 830 2024-06-28
7200 Java Chip Frappuccino® 7200 118 118 780 830 2024-06-28
7201 Mocha Frappuccino® 7201 118 118 720 770 2024-06-28
7202 Caramel Macchiato Frappuccino® 7202 118 118 780 830 2024-06-28
7203 Espresso Frappuccino® 7203 118 118 720 770 2024-06-28
7204 White Chocolate Mocha Frappuccino® 7204 118 118 720 770 2024-06-28
7205 Chocolate Chip Cream Frappuccino® 7205 118 118 780 830 2024-06-28
7206 Hojicha Tea Cream Frappuccino® 7206 118 118 760 810 2024-06-28
7207 Vanilla Cream Frappuccino® 7207 118 118 720 770 2024-06-28
7208 Mango Passion Fruit & Hibiscus 7208 118 118 720 770 2024-06-28
7209 Raspberry Black Currant & Oolong 7209 118 118 720 770 2024-06-28
7210 Coffee Traveller 7210 118 118 3120 3170 2024-06-28
7211 Caffè Americano 7211 118 118 540 590 2024-06-28
7212 Cappuccino 7212 118 118 680 730 2024-06-28
7213 Caffè Mocha 7213 118 118 750 800 2024-06-28
7214 Caramel Macchiato 7214 118 118 760 810 2024-06-28
7215 Espresso 7215 118 118 390 440 2024-06-28
7216 Caffè Latte 7216 118 118 680 730 2024-06-28
7217 Oatmilk Latte 7217 118 118 760 810 2024-06-28
7218 Vanilla Latte 7218 118 118 750 800 2024-06-28
7219 White Chocolate Mocha 7219 118 118 750 800 2024-06-28
7220 Flat White 7220 118 118 760 810 2024-06-28
7221 Ristretto Bianco 7221 118 118 760 810 2024-06-28
7222 Iced Caffè Americano 7222 118 118 540 590 2024-06-28
7223 Iced Cappuccino 7223 118 118 680 730 2024-06-28
7224 Iced Caffè Mocha 7224 118 118 750 800 2024-06-28
7225 Iced Caramel Macchiato 7225 118 118 760 810 2024-06-28
7226 Iced Caffè Latte 7226 118 118 680 730 2024-06-28
7227 Iced Oatmilk Latte 7227 118 118 760 810 2024-06-28
7228 Iced Vanilla Latte 7228 118 118 750 800 2024-06-28
7229 Iced White Chocolate Mocha 7229 118 118 750 800 2024-06-28
7230 Signature Hot Chocolate 7230 118 118 720 770 2024-06-28
7231 Signature Iced Chocolate 7231 118 118 720 770 2024-06-28
7232 Carrot Juice 7232 118 118 490 540 2024-06-28
7233 Cloudy Apple Juice 7233 118 118 490 540 2024-06-28
7234 Cranberry Red Grapefruit Juice 7234 118 118 490 540 2024-06-28
7235 Orange Juice 7235 118 118 490 540 2024-06-28
7236 Evian 7236 118 118 350 400 2024-06-28
7237 Sparkling Water 7237 118 118 450 500 2024-06-28
7238 Chai Tea 7238 118 118 500 550 2024-06-28
7239 Earl Grey Tea 7239 118 118 500 550 2024-06-28
7240 English Breakfast Tea 7240 118 118 500 550 2024-06-28
7241 Emperor’s Clouds & Mist™ Tea 7241 118 118 500 550 2024-06-28
7242 Mint Blend Tea 7242 118 118 500 550 2024-06-28
7243 Chamomile Tea 7243 118 118 500 550 2024-06-28
7244 Pure Matcha Latte 7244 118 118 740 790 2024-06-28
7245 Chai Tea Latte 7245 118 118 680 730 2024-06-28
7246 Earl Grey Tea Latte 7246 118 118 680 730 2024-06-28
7247 English Breakfast Tea Latte 7247 118 118 680 730 2024-06-28
7248 Hojicha Tea Latte 7248 118 118 740 790 2024-06-28
7249 Zen Clouds Oolong Tea 7249 118 118 500 550 2024-06-28
7250 Zen Clouds Oolong with Ruby Grapefruit and Honey 7250 118 118 630 680 2024-06-28
7251 Youthberry™ Tea 7251 118 118 500 550 2024-06-28
7252 Iced Shaken Black Tea Lemonade 7252 118 118 610 660 2024-06-28
7253 Iced Shaken Strawberry Black Tea Lemonade 7253 118 118 630 680 2024-06-28
7254 Iced Shaken Hibiscus Tea Lemonade 7254 118 118 610 660 2024-06-28
7255 Iced Shaken Hibiscus Tea with Pomegranate Pearls 7255 118 118 730 780 2024-06-28
7256 Iced Pure Matcha Latte 7256 118 118 740 790 2024-06-28
7257 Iced Chai Tea Latte 7257 118 118 680 730 2024-06-28
7258 Iced Black Tea Latte 7258 118 118 680 730 2024-06-28
7259 Iced Hojicha Tea Latte 7259 118 118 740 790 2024-06-28
7260 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 7260 118 118 630 680 2024-06-28
7261 Iced Shaken Zen Clouds Oolong Lemonade 7261 118 118 610 660 2024-06-28
7262 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 7262 118 118 630 680 2024-06-28
7263 Origami Pike Place® Roast 7263 118 118 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");