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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 16 · 234 ✖
id ▼ item_id store_id base_price delivery_price effective_date
24176 Bagel 24176 16 16 400 430 2024-06-28
24177 Cookie Crumble Cheesecake 24177 16 16 720 770 2024-06-28
24178 Good Ol' NY Cheesecake 24178 16 16 720 770 2024-06-28
24179 Signature Chocolate Cake 24179 16 16 720 770 2024-06-28
24180 Starbucks® Coffee Tiramisu Cake 24180 16 16 750 800 2024-06-28
24181 Strawberry Shortcake 24181 16 16 720 770 2024-06-28
24182 Chocolate Chunk Monster Cookie 24182 16 16 390 440 2024-06-28
24183 Banana Walnut Muffin 24183 16 16 450 500 2024-06-28
24184 Blueberry Crumble Muffin 24184 16 16 450 500 2024-06-28
24185 Chocolate Crumble Muffin 24185 16 16 450 500 2024-06-28
24186 Pancakes 24186 16 16 550 600 2024-06-28
24187 Almond Croissant 24187 16 16 470 520 2024-06-28
24188 Buttery Croissant 24188 16 16 400 430 2024-06-28
24189 Chocolate Croissant 24189 16 16 440 490 2024-06-28
24190 Creamy Chicken Foldover 24190 16 16 550 600 2024-06-28
24191 Sausage Roll 24191 16 16 550 600 2024-06-28
24192 Buttery Scone 24192 16 16 400 430 2024-06-28
24193 Country Chicken Pie 24193 16 16 690 740 2024-06-28
24194 Deep Dish Beef Pie 24194 16 16 690 740 2024-06-28
24195 Spinach & Mushroom Quiche 24195 16 16 690 740 2024-06-28
24196 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 24196 16 16 390 420 2024-06-28
24197 Mixed Nuts 24197 16 16 490 540 2024-06-28
24198 Caramel Waffles 24198 16 16 390 420 2024-06-28
24199 Chicken Ham & Cheese Panwich 24199 16 16 690 740 2024-06-28
24200 Egg Mayo & Cheese Multigrain Croissant 24200 16 16 690 740 2024-06-28
24201 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 24201 16 16 690 740 2024-06-28
24202 Rosemary Chicken & Emmental Cheese Croissant 24202 16 16 690 740 2024-06-28
24203 Scrambled Egg & Turkey Ham Pita 24203 16 16 690 740 2024-06-28
24204 Turkey Ham & Triple Cheese Toast 24204 16 16 690 740 2024-06-28
24205 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 24205 16 16 790 840 2024-06-28
24206 Ham & Cheese Croissant 24206 16 16 690 740 2024-06-28
24207 Sriracha Chicken Whole Wheat Pita 24207 16 16 750 800 2024-06-28
24208 Blueberry Acai Yogurt Parfait 24208 16 16 650 700 2024-06-28
24209 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 24209 16 16 650 700 2024-06-28
24210 Caramel Frappuccino® 24210 16 16 720 770 2024-06-28
24211 Dark Mocha Frappuccino® 24211 16 16 780 830 2024-06-28
24212 Java Chip Frappuccino® 24212 16 16 780 830 2024-06-28
24213 Mocha Frappuccino® 24213 16 16 720 770 2024-06-28
24214 Caramel Macchiato Frappuccino® 24214 16 16 780 830 2024-06-28
24215 Espresso Frappuccino® 24215 16 16 720 770 2024-06-28
24216 White Chocolate Mocha Frappuccino® 24216 16 16 720 770 2024-06-28
24217 Chocolate Chip Cream Frappuccino® 24217 16 16 780 830 2024-06-28
24218 Hojicha Tea Cream Frappuccino® 24218 16 16 760 810 2024-06-28
24219 Vanilla Cream Frappuccino® 24219 16 16 720 770 2024-06-28
24220 Mango Passion Fruit & Hibiscus 24220 16 16 720 770 2024-06-28
24221 Raspberry Black Currant & Oolong 24221 16 16 720 770 2024-06-28
24222 Coffee Traveller 24222 16 16 3120 3170 2024-06-28
24223 Caffè Americano 24223 16 16 540 590 2024-06-28
24224 Cappuccino 24224 16 16 680 730 2024-06-28
24225 Caffè Mocha 24225 16 16 750 800 2024-06-28
24226 Caramel Macchiato 24226 16 16 760 810 2024-06-28
24227 Espresso 24227 16 16 390 440 2024-06-28
24228 Caffè Latte 24228 16 16 680 730 2024-06-28
24229 Oatmilk Latte 24229 16 16 760 810 2024-06-28
24230 Vanilla Latte 24230 16 16 750 800 2024-06-28
24231 White Chocolate Mocha 24231 16 16 750 800 2024-06-28
24232 Flat White 24232 16 16 760 810 2024-06-28
24233 Ristretto Bianco 24233 16 16 760 810 2024-06-28
24234 Iced Caffè Americano 24234 16 16 540 590 2024-06-28
24235 Iced Cappuccino 24235 16 16 680 730 2024-06-28
24236 Iced Caffè Mocha 24236 16 16 750 800 2024-06-28
24237 Iced Caramel Macchiato 24237 16 16 760 810 2024-06-28
24238 Iced Caffè Latte 24238 16 16 680 730 2024-06-28
24239 Iced Oatmilk Latte 24239 16 16 760 810 2024-06-28
24240 Iced Vanilla Latte 24240 16 16 750 800 2024-06-28
24241 Iced White Chocolate Mocha 24241 16 16 750 800 2024-06-28
24242 Signature Hot Chocolate 24242 16 16 720 770 2024-06-28
24243 Signature Iced Chocolate 24243 16 16 720 770 2024-06-28
24244 Carrot Juice 24244 16 16 490 540 2024-06-28
24245 Cloudy Apple Juice 24245 16 16 490 540 2024-06-28
24246 Cranberry Red Grapefruit Juice 24246 16 16 490 540 2024-06-28
24247 Orange Juice 24247 16 16 490 540 2024-06-28
24248 Evian 24248 16 16 350 400 2024-06-28
24249 Sparkling Water 24249 16 16 450 500 2024-06-28
24250 Chai Tea 24250 16 16 500 550 2024-06-28
24251 Earl Grey Tea 24251 16 16 500 550 2024-06-28
24252 English Breakfast Tea 24252 16 16 500 550 2024-06-28
24253 Emperor’s Clouds & Mist™ Tea 24253 16 16 500 550 2024-06-28
24254 Mint Blend Tea 24254 16 16 500 550 2024-06-28
24255 Chamomile Tea 24255 16 16 500 550 2024-06-28
24256 Pure Matcha Latte 24256 16 16 740 790 2024-06-28
24257 Chai Tea Latte 24257 16 16 680 730 2024-06-28
24258 Earl Grey Tea Latte 24258 16 16 680 730 2024-06-28
24259 English Breakfast Tea Latte 24259 16 16 680 730 2024-06-28
24260 Hojicha Tea Latte 24260 16 16 740 790 2024-06-28
24261 Zen Clouds Oolong Tea 24261 16 16 500 550 2024-06-28
24262 Zen Clouds Oolong with Ruby Grapefruit and Honey 24262 16 16 630 680 2024-06-28
24263 Youthberry™ Tea 24263 16 16 500 550 2024-06-28
24264 Iced Shaken Black Tea Lemonade 24264 16 16 610 660 2024-06-28
24265 Iced Shaken Strawberry Black Tea Lemonade 24265 16 16 630 680 2024-06-28
24266 Iced Shaken Hibiscus Tea Lemonade 24266 16 16 610 660 2024-06-28
24267 Iced Shaken Hibiscus Tea with Pomegranate Pearls 24267 16 16 730 780 2024-06-28
24268 Iced Pure Matcha Latte 24268 16 16 740 790 2024-06-28
24269 Iced Chai Tea Latte 24269 16 16 680 730 2024-06-28
24270 Iced Black Tea Latte 24270 16 16 680 730 2024-06-28
24271 Iced Hojicha Tea Latte 24271 16 16 740 790 2024-06-28
24272 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 24272 16 16 630 680 2024-06-28
24273 Iced Shaken Zen Clouds Oolong Lemonade 24273 16 16 610 660 2024-06-28
24274 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 24274 16 16 630 680 2024-06-28
24275 Origami Pike Place® Roast 24275 16 16 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");