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

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 22 · 234 ✖
id ▼ item_id store_id base_price delivery_price effective_date
23082 Bagel 23082 22 22 400 430 2024-06-28
23083 Cookie Crumble Cheesecake 23083 22 22 720 770 2024-06-28
23084 Good Ol' NY Cheesecake 23084 22 22 720 770 2024-06-28
23085 Signature Chocolate Cake 23085 22 22 720 770 2024-06-28
23086 Starbucks® Coffee Tiramisu Cake 23086 22 22 750 800 2024-06-28
23087 Strawberry Shortcake 23087 22 22 720 770 2024-06-28
23088 Chocolate Chunk Monster Cookie 23088 22 22 390 440 2024-06-28
23089 Banana Walnut Muffin 23089 22 22 450 500 2024-06-28
23090 Blueberry Crumble Muffin 23090 22 22 450 500 2024-06-28
23091 Chocolate Crumble Muffin 23091 22 22 450 500 2024-06-28
23092 Pancakes 23092 22 22 550 600 2024-06-28
23093 Almond Croissant 23093 22 22 470 520 2024-06-28
23094 Buttery Croissant 23094 22 22 400 430 2024-06-28
23095 Chocolate Croissant 23095 22 22 440 490 2024-06-28
23096 Creamy Chicken Foldover 23096 22 22 550 600 2024-06-28
23097 Sausage Roll 23097 22 22 550 600 2024-06-28
23098 Buttery Scone 23098 22 22 400 430 2024-06-28
23099 Country Chicken Pie 23099 22 22 690 740 2024-06-28
23100 Deep Dish Beef Pie 23100 22 22 690 740 2024-06-28
23101 Spinach & Mushroom Quiche 23101 22 22 690 740 2024-06-28
23102 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 23102 22 22 390 420 2024-06-28
23103 Mixed Nuts 23103 22 22 490 540 2024-06-28
23104 Caramel Waffles 23104 22 22 390 420 2024-06-28
23105 Chicken Ham & Cheese Panwich 23105 22 22 690 740 2024-06-28
23106 Egg Mayo & Cheese Multigrain Croissant 23106 22 22 690 740 2024-06-28
23107 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 23107 22 22 690 740 2024-06-28
23108 Rosemary Chicken & Emmental Cheese Croissant 23108 22 22 690 740 2024-06-28
23109 Scrambled Egg & Turkey Ham Pita 23109 22 22 690 740 2024-06-28
23110 Turkey Ham & Triple Cheese Toast 23110 22 22 690 740 2024-06-28
23111 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 23111 22 22 790 840 2024-06-28
23112 Ham & Cheese Croissant 23112 22 22 690 740 2024-06-28
23113 Sriracha Chicken Whole Wheat Pita 23113 22 22 750 800 2024-06-28
23114 Blueberry Acai Yogurt Parfait 23114 22 22 650 700 2024-06-28
23115 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 23115 22 22 650 700 2024-06-28
23116 Caramel Frappuccino® 23116 22 22 720 770 2024-06-28
23117 Dark Mocha Frappuccino® 23117 22 22 780 830 2024-06-28
23118 Java Chip Frappuccino® 23118 22 22 780 830 2024-06-28
23119 Mocha Frappuccino® 23119 22 22 720 770 2024-06-28
23120 Caramel Macchiato Frappuccino® 23120 22 22 780 830 2024-06-28
23121 Espresso Frappuccino® 23121 22 22 720 770 2024-06-28
23122 White Chocolate Mocha Frappuccino® 23122 22 22 720 770 2024-06-28
23123 Chocolate Chip Cream Frappuccino® 23123 22 22 780 830 2024-06-28
23124 Hojicha Tea Cream Frappuccino® 23124 22 22 760 810 2024-06-28
23125 Vanilla Cream Frappuccino® 23125 22 22 720 770 2024-06-28
23126 Mango Passion Fruit & Hibiscus 23126 22 22 720 770 2024-06-28
23127 Raspberry Black Currant & Oolong 23127 22 22 720 770 2024-06-28
23128 Coffee Traveller 23128 22 22 3120 3170 2024-06-28
23129 Caffè Americano 23129 22 22 540 590 2024-06-28
23130 Cappuccino 23130 22 22 680 730 2024-06-28
23131 Caffè Mocha 23131 22 22 750 800 2024-06-28
23132 Caramel Macchiato 23132 22 22 760 810 2024-06-28
23133 Espresso 23133 22 22 390 440 2024-06-28
23134 Caffè Latte 23134 22 22 680 730 2024-06-28
23135 Oatmilk Latte 23135 22 22 760 810 2024-06-28
23136 Vanilla Latte 23136 22 22 750 800 2024-06-28
23137 White Chocolate Mocha 23137 22 22 750 800 2024-06-28
23138 Flat White 23138 22 22 760 810 2024-06-28
23139 Ristretto Bianco 23139 22 22 760 810 2024-06-28
23140 Iced Caffè Americano 23140 22 22 540 590 2024-06-28
23141 Iced Cappuccino 23141 22 22 680 730 2024-06-28
23142 Iced Caffè Mocha 23142 22 22 750 800 2024-06-28
23143 Iced Caramel Macchiato 23143 22 22 760 810 2024-06-28
23144 Iced Caffè Latte 23144 22 22 680 730 2024-06-28
23145 Iced Oatmilk Latte 23145 22 22 760 810 2024-06-28
23146 Iced Vanilla Latte 23146 22 22 750 800 2024-06-28
23147 Iced White Chocolate Mocha 23147 22 22 750 800 2024-06-28
23148 Signature Hot Chocolate 23148 22 22 720 770 2024-06-28
23149 Signature Iced Chocolate 23149 22 22 720 770 2024-06-28
23150 Carrot Juice 23150 22 22 490 540 2024-06-28
23151 Cloudy Apple Juice 23151 22 22 490 540 2024-06-28
23152 Cranberry Red Grapefruit Juice 23152 22 22 490 540 2024-06-28
23153 Orange Juice 23153 22 22 490 540 2024-06-28
23154 Evian 23154 22 22 350 400 2024-06-28
23155 Sparkling Water 23155 22 22 450 500 2024-06-28
23156 Chai Tea 23156 22 22 500 550 2024-06-28
23157 Earl Grey Tea 23157 22 22 500 550 2024-06-28
23158 English Breakfast Tea 23158 22 22 500 550 2024-06-28
23159 Emperor’s Clouds & Mist™ Tea 23159 22 22 500 550 2024-06-28
23160 Mint Blend Tea 23160 22 22 500 550 2024-06-28
23161 Chamomile Tea 23161 22 22 500 550 2024-06-28
23162 Pure Matcha Latte 23162 22 22 740 790 2024-06-28
23163 Chai Tea Latte 23163 22 22 680 730 2024-06-28
23164 Earl Grey Tea Latte 23164 22 22 680 730 2024-06-28
23165 English Breakfast Tea Latte 23165 22 22 680 730 2024-06-28
23166 Hojicha Tea Latte 23166 22 22 740 790 2024-06-28
23167 Zen Clouds Oolong Tea 23167 22 22 500 550 2024-06-28
23168 Zen Clouds Oolong with Ruby Grapefruit and Honey 23168 22 22 630 680 2024-06-28
23169 Youthberry™ Tea 23169 22 22 500 550 2024-06-28
23170 Iced Shaken Black Tea Lemonade 23170 22 22 610 660 2024-06-28
23171 Iced Shaken Strawberry Black Tea Lemonade 23171 22 22 630 680 2024-06-28
23172 Iced Shaken Hibiscus Tea Lemonade 23172 22 22 610 660 2024-06-28
23173 Iced Shaken Hibiscus Tea with Pomegranate Pearls 23173 22 22 730 780 2024-06-28
23174 Iced Pure Matcha Latte 23174 22 22 740 790 2024-06-28
23175 Iced Chai Tea Latte 23175 22 22 680 730 2024-06-28
23176 Iced Black Tea Latte 23176 22 22 680 730 2024-06-28
23177 Iced Hojicha Tea Latte 23177 22 22 740 790 2024-06-28
23178 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 23178 22 22 630 680 2024-06-28
23179 Iced Shaken Zen Clouds Oolong Lemonade 23179 22 22 610 660 2024-06-28
23180 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 23180 22 22 630 680 2024-06-28
23181 Origami Pike Place® Roast 23181 22 22 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");