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 = 27

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 27 · 249 ✖
id ▼ item_id store_id base_price delivery_price effective_date
22169 Bagel 22169 27 27 400 430 2024-06-28
22170 Cookie Crumble Cheesecake 22170 27 27 720 770 2024-06-28
22171 Good Ol' NY Cheesecake 22171 27 27 720 770 2024-06-28
22172 Signature Chocolate Cake 22172 27 27 720 770 2024-06-28
22173 Starbucks® Coffee Tiramisu Cake 22173 27 27 750 800 2024-06-28
22174 Strawberry Shortcake 22174 27 27 720 770 2024-06-28
22175 Chocolate Chunk Monster Cookie 22175 27 27 390 440 2024-06-28
22176 Banana Walnut Muffin 22176 27 27 450 500 2024-06-28
22177 Blueberry Crumble Muffin 22177 27 27 450 500 2024-06-28
22178 Chocolate Crumble Muffin 22178 27 27 450 500 2024-06-28
22179 Pancakes 22179 27 27 550 600 2024-06-28
22180 Almond Croissant 22180 27 27 470 520 2024-06-28
22181 Buttery Croissant 22181 27 27 400 430 2024-06-28
22182 Chocolate Croissant 22182 27 27 440 490 2024-06-28
22183 Creamy Chicken Foldover 22183 27 27 550 600 2024-06-28
22184 Sausage Roll 22184 27 27 550 600 2024-06-28
22185 Buttery Scone 22185 27 27 400 430 2024-06-28
22186 Country Chicken Pie 22186 27 27 690 740 2024-06-28
22187 Deep Dish Beef Pie 22187 27 27 690 740 2024-06-28
22188 Spinach & Mushroom Quiche 22188 27 27 690 740 2024-06-28
22189 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 22189 27 27 390 420 2024-06-28
22190 Mixed Nuts 22190 27 27 490 540 2024-06-28
22191 Caramel Waffles 22191 27 27 390 420 2024-06-28
22192 Chicken Ham & Cheese Panwich 22192 27 27 690 740 2024-06-28
22193 Egg Mayo & Cheese Multigrain Croissant 22193 27 27 690 740 2024-06-28
22194 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 22194 27 27 690 740 2024-06-28
22195 Rosemary Chicken & Emmental Cheese Croissant 22195 27 27 690 740 2024-06-28
22196 Scrambled Egg & Turkey Ham Pita 22196 27 27 690 740 2024-06-28
22197 Turkey Ham & Triple Cheese Toast 22197 27 27 690 740 2024-06-28
22198 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 22198 27 27 790 840 2024-06-28
22199 Ham & Cheese Croissant 22199 27 27 690 740 2024-06-28
22200 Sriracha Chicken Whole Wheat Pita 22200 27 27 750 800 2024-06-28
22201 Blueberry Acai Yogurt Parfait 22201 27 27 650 700 2024-06-28
22202 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 22202 27 27 650 700 2024-06-28
22203 Caramel Frappuccino® 22203 27 27 720 770 2024-06-28
22204 Dark Mocha Frappuccino® 22204 27 27 780 830 2024-06-28
22205 Java Chip Frappuccino® 22205 27 27 780 830 2024-06-28
22206 Mocha Frappuccino® 22206 27 27 720 770 2024-06-28
22207 Caramel Macchiato Frappuccino® 22207 27 27 780 830 2024-06-28
22208 Espresso Frappuccino® 22208 27 27 720 770 2024-06-28
22209 White Chocolate Mocha Frappuccino® 22209 27 27 720 770 2024-06-28
22210 Chocolate Chip Cream Frappuccino® 22210 27 27 780 830 2024-06-28
22211 Hojicha Tea Cream Frappuccino® 22211 27 27 760 810 2024-06-28
22212 Vanilla Cream Frappuccino® 22212 27 27 720 770 2024-06-28
22213 Mango Passion Fruit & Hibiscus 22213 27 27 720 770 2024-06-28
22214 Raspberry Black Currant & Oolong 22214 27 27 720 770 2024-06-28
22215 Coffee Traveller 22215 27 27 3120 3170 2024-06-28
22216 Caffè Americano 22216 27 27 540 590 2024-06-28
22217 Cappuccino 22217 27 27 680 730 2024-06-28
22218 Caffè Mocha 22218 27 27 750 800 2024-06-28
22219 Caramel Macchiato 22219 27 27 760 810 2024-06-28
22220 Espresso 22220 27 27 390 440 2024-06-28
22221 Caffè Latte 22221 27 27 680 730 2024-06-28
22222 Oatmilk Latte 22222 27 27 760 810 2024-06-28
22223 Vanilla Latte 22223 27 27 750 800 2024-06-28
22224 White Chocolate Mocha 22224 27 27 750 800 2024-06-28
22225 Flat White 22225 27 27 760 810 2024-06-28
22226 Ristretto Bianco 22226 27 27 760 810 2024-06-28
22227 Iced Caffè Americano 22227 27 27 540 590 2024-06-28
22228 Iced Cappuccino 22228 27 27 680 730 2024-06-28
22229 Iced Caffè Mocha 22229 27 27 750 800 2024-06-28
22230 Iced Caramel Macchiato 22230 27 27 760 810 2024-06-28
22231 Iced Caffè Latte 22231 27 27 680 730 2024-06-28
22232 Iced Oatmilk Latte 22232 27 27 760 810 2024-06-28
22233 Iced Vanilla Latte 22233 27 27 750 800 2024-06-28
22234 Iced White Chocolate Mocha 22234 27 27 750 800 2024-06-28
22235 Signature Hot Chocolate 22235 27 27 720 770 2024-06-28
22236 Signature Iced Chocolate 22236 27 27 720 770 2024-06-28
22237 Carrot Juice 22237 27 27 490 540 2024-06-28
22238 Cloudy Apple Juice 22238 27 27 490 540 2024-06-28
22239 Cranberry Red Grapefruit Juice 22239 27 27 490 540 2024-06-28
22240 Orange Juice 22240 27 27 490 540 2024-06-28
22241 Evian 22241 27 27 350 400 2024-06-28
22242 Sparkling Water 22242 27 27 450 500 2024-06-28
22243 Chai Tea 22243 27 27 500 550 2024-06-28
22244 Earl Grey Tea 22244 27 27 500 550 2024-06-28
22245 English Breakfast Tea 22245 27 27 500 550 2024-06-28
22246 Emperor’s Clouds & Mist™ Tea 22246 27 27 500 550 2024-06-28
22247 Mint Blend Tea 22247 27 27 500 550 2024-06-28
22248 Chamomile Tea 22248 27 27 500 550 2024-06-28
22249 Pure Matcha Latte 22249 27 27 740 790 2024-06-28
22250 Chai Tea Latte 22250 27 27 680 730 2024-06-28
22251 Earl Grey Tea Latte 22251 27 27 680 730 2024-06-28
22252 English Breakfast Tea Latte 22252 27 27 680 730 2024-06-28
22253 Hojicha Tea Latte 22253 27 27 740 790 2024-06-28
22254 Zen Clouds Oolong Tea 22254 27 27 500 550 2024-06-28
22255 Zen Clouds Oolong with Ruby Grapefruit and Honey 22255 27 27 630 680 2024-06-28
22256 Youthberry™ Tea 22256 27 27 500 550 2024-06-28
22257 Iced Shaken Black Tea Lemonade 22257 27 27 610 660 2024-06-28
22258 Iced Shaken Strawberry Black Tea Lemonade 22258 27 27 630 680 2024-06-28
22259 Iced Shaken Hibiscus Tea Lemonade 22259 27 27 610 660 2024-06-28
22260 Iced Shaken Hibiscus Tea with Pomegranate Pearls 22260 27 27 730 780 2024-06-28
22261 Iced Pure Matcha Latte 22261 27 27 740 790 2024-06-28
22262 Iced Chai Tea Latte 22262 27 27 680 730 2024-06-28
22263 Iced Black Tea Latte 22263 27 27 680 730 2024-06-28
22264 Iced Hojicha Tea Latte 22264 27 27 740 790 2024-06-28
22265 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 22265 27 27 630 680 2024-06-28
22266 Iced Shaken Zen Clouds Oolong Lemonade 22266 27 27 610 660 2024-06-28
22267 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 22267 27 27 630 680 2024-06-28
22268 Origami Pike Place® Roast 22268 27 27 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");