item_prices

Pricing information for Starbucks menu items in Singapore

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

229 rows where store_id = 77

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 77 · 229 ✖
id ▼ item_id store_id base_price delivery_price effective_date
14116 Bagel 14116 77 77 400 430 2024-06-28
14117 Cookie Crumble Cheesecake 14117 77 77 720 770 2024-06-28
14118 Good Ol' NY Cheesecake 14118 77 77 720 770 2024-06-28
14119 Signature Chocolate Cake 14119 77 77 720 770 2024-06-28
14120 Starbucks® Coffee Tiramisu Cake 14120 77 77 750 800 2024-06-28
14121 Strawberry Shortcake 14121 77 77 720 770 2024-06-28
14122 Chocolate Chunk Monster Cookie 14122 77 77 390 440 2024-06-28
14123 Banana Walnut Muffin 14123 77 77 450 500 2024-06-28
14124 Blueberry Crumble Muffin 14124 77 77 450 500 2024-06-28
14125 Chocolate Crumble Muffin 14125 77 77 450 500 2024-06-28
14126 Pancakes 14126 77 77 550 600 2024-06-28
14127 Almond Croissant 14127 77 77 470 520 2024-06-28
14128 Buttery Croissant 14128 77 77 400 430 2024-06-28
14129 Chocolate Croissant 14129 77 77 440 490 2024-06-28
14130 Creamy Chicken Foldover 14130 77 77 550 600 2024-06-28
14131 Sausage Roll 14131 77 77 550 600 2024-06-28
14132 Buttery Scone 14132 77 77 400 430 2024-06-28
14133 Country Chicken Pie 14133 77 77 690 740 2024-06-28
14134 Deep Dish Beef Pie 14134 77 77 690 740 2024-06-28
14135 Spinach & Mushroom Quiche 14135 77 77 690 740 2024-06-28
14136 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 14136 77 77 390 420 2024-06-28
14137 Mixed Nuts 14137 77 77 490 540 2024-06-28
14138 Caramel Waffles 14138 77 77 390 420 2024-06-28
14139 Chicken Ham & Cheese Panwich 14139 77 77 690 740 2024-06-28
14140 Egg Mayo & Cheese Multigrain Croissant 14140 77 77 690 740 2024-06-28
14141 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 14141 77 77 690 740 2024-06-28
14142 Rosemary Chicken & Emmental Cheese Croissant 14142 77 77 690 740 2024-06-28
14143 Scrambled Egg & Turkey Ham Pita 14143 77 77 690 740 2024-06-28
14144 Turkey Ham & Triple Cheese Toast 14144 77 77 690 740 2024-06-28
14145 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 14145 77 77 790 840 2024-06-28
14146 Ham & Cheese Croissant 14146 77 77 690 740 2024-06-28
14147 Sriracha Chicken Whole Wheat Pita 14147 77 77 750 800 2024-06-28
14148 Blueberry Acai Yogurt Parfait 14148 77 77 650 700 2024-06-28
14149 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 14149 77 77 650 700 2024-06-28
14150 Caramel Frappuccino® 14150 77 77 720 770 2024-06-28
14151 Dark Mocha Frappuccino® 14151 77 77 780 830 2024-06-28
14152 Java Chip Frappuccino® 14152 77 77 780 830 2024-06-28
14153 Mocha Frappuccino® 14153 77 77 720 770 2024-06-28
14154 Caramel Macchiato Frappuccino® 14154 77 77 780 830 2024-06-28
14155 Espresso Frappuccino® 14155 77 77 720 770 2024-06-28
14156 White Chocolate Mocha Frappuccino® 14156 77 77 720 770 2024-06-28
14157 Chocolate Chip Cream Frappuccino® 14157 77 77 780 830 2024-06-28
14158 Hojicha Tea Cream Frappuccino® 14158 77 77 760 810 2024-06-28
14159 Vanilla Cream Frappuccino® 14159 77 77 720 770 2024-06-28
14160 Mango Passion Fruit & Hibiscus 14160 77 77 720 770 2024-06-28
14161 Raspberry Black Currant & Oolong 14161 77 77 720 770 2024-06-28
14162 Coffee Traveller 14162 77 77 3120 3170 2024-06-28
14163 Caffè Americano 14163 77 77 540 590 2024-06-28
14164 Cappuccino 14164 77 77 680 730 2024-06-28
14165 Caffè Mocha 14165 77 77 750 800 2024-06-28
14166 Caramel Macchiato 14166 77 77 760 810 2024-06-28
14167 Espresso 14167 77 77 390 440 2024-06-28
14168 Caffè Latte 14168 77 77 680 730 2024-06-28
14169 Oatmilk Latte 14169 77 77 760 810 2024-06-28
14170 Vanilla Latte 14170 77 77 750 800 2024-06-28
14171 White Chocolate Mocha 14171 77 77 750 800 2024-06-28
14172 Flat White 14172 77 77 760 810 2024-06-28
14173 Ristretto Bianco 14173 77 77 760 810 2024-06-28
14174 Iced Caffè Americano 14174 77 77 540 590 2024-06-28
14175 Iced Cappuccino 14175 77 77 680 730 2024-06-28
14176 Iced Caffè Mocha 14176 77 77 750 800 2024-06-28
14177 Iced Caramel Macchiato 14177 77 77 760 810 2024-06-28
14178 Iced Caffè Latte 14178 77 77 680 730 2024-06-28
14179 Iced Oatmilk Latte 14179 77 77 760 810 2024-06-28
14180 Iced Vanilla Latte 14180 77 77 750 800 2024-06-28
14181 Iced White Chocolate Mocha 14181 77 77 750 800 2024-06-28
14182 Signature Hot Chocolate 14182 77 77 720 770 2024-06-28
14183 Signature Iced Chocolate 14183 77 77 720 770 2024-06-28
14184 Carrot Juice 14184 77 77 490 540 2024-06-28
14185 Cloudy Apple Juice 14185 77 77 490 540 2024-06-28
14186 Cranberry Red Grapefruit Juice 14186 77 77 490 540 2024-06-28
14187 Orange Juice 14187 77 77 490 540 2024-06-28
14188 Evian 14188 77 77 350 400 2024-06-28
14189 Sparkling Water 14189 77 77 450 500 2024-06-28
14190 Chai Tea 14190 77 77 500 550 2024-06-28
14191 Earl Grey Tea 14191 77 77 500 550 2024-06-28
14192 English Breakfast Tea 14192 77 77 500 550 2024-06-28
14193 Emperor’s Clouds & Mist™ Tea 14193 77 77 500 550 2024-06-28
14194 Mint Blend Tea 14194 77 77 500 550 2024-06-28
14195 Chamomile Tea 14195 77 77 500 550 2024-06-28
14196 Pure Matcha Latte 14196 77 77 740 790 2024-06-28
14197 Chai Tea Latte 14197 77 77 680 730 2024-06-28
14198 Earl Grey Tea Latte 14198 77 77 680 730 2024-06-28
14199 English Breakfast Tea Latte 14199 77 77 680 730 2024-06-28
14200 Hojicha Tea Latte 14200 77 77 740 790 2024-06-28
14201 Zen Clouds Oolong Tea 14201 77 77 500 550 2024-06-28
14202 Zen Clouds Oolong with Ruby Grapefruit and Honey 14202 77 77 630 680 2024-06-28
14203 Youthberry™ Tea 14203 77 77 500 550 2024-06-28
14204 Iced Shaken Black Tea Lemonade 14204 77 77 610 660 2024-06-28
14205 Iced Shaken Strawberry Black Tea Lemonade 14205 77 77 630 680 2024-06-28
14206 Iced Shaken Hibiscus Tea Lemonade 14206 77 77 610 660 2024-06-28
14207 Iced Shaken Hibiscus Tea with Pomegranate Pearls 14207 77 77 730 780 2024-06-28
14208 Iced Pure Matcha Latte 14208 77 77 740 790 2024-06-28
14209 Iced Chai Tea Latte 14209 77 77 680 730 2024-06-28
14210 Iced Black Tea Latte 14210 77 77 680 730 2024-06-28
14211 Iced Hojicha Tea Latte 14211 77 77 740 790 2024-06-28
14212 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 14212 77 77 630 680 2024-06-28
14213 Iced Shaken Zen Clouds Oolong Lemonade 14213 77 77 610 660 2024-06-28
14214 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 14214 77 77 630 680 2024-06-28
14215 Origami Pike Place® Roast 14215 77 77 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");