item_prices

Pricing information for Starbucks menu items in Singapore

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

238 rows where store_id = 90

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: effective_date (date)

store_id 1

  • 90 · 238 ✖
id ▼ item_id store_id base_price delivery_price effective_date
12086 Bagel 12086 90 90 400 430 2024-06-28
12087 Cookie Crumble Cheesecake 12087 90 90 720 770 2024-06-28
12088 Good Ol' NY Cheesecake 12088 90 90 720 770 2024-06-28
12089 Signature Chocolate Cake 12089 90 90 720 770 2024-06-28
12090 Starbucks® Coffee Tiramisu Cake 12090 90 90 750 800 2024-06-28
12091 Strawberry Shortcake 12091 90 90 720 770 2024-06-28
12092 Chocolate Chunk Monster Cookie 12092 90 90 390 440 2024-06-28
12093 Banana Walnut Muffin 12093 90 90 450 500 2024-06-28
12094 Blueberry Crumble Muffin 12094 90 90 450 500 2024-06-28
12095 Chocolate Crumble Muffin 12095 90 90 450 500 2024-06-28
12096 Pancakes 12096 90 90 550 600 2024-06-28
12097 Almond Croissant 12097 90 90 470 520 2024-06-28
12098 Buttery Croissant 12098 90 90 400 430 2024-06-28
12099 Chocolate Croissant 12099 90 90 440 490 2024-06-28
12100 Creamy Chicken Foldover 12100 90 90 550 600 2024-06-28
12101 Sausage Roll 12101 90 90 550 600 2024-06-28
12102 Buttery Scone 12102 90 90 400 430 2024-06-28
12103 Country Chicken Pie 12103 90 90 690 740 2024-06-28
12104 Deep Dish Beef Pie 12104 90 90 690 740 2024-06-28
12105 Spinach & Mushroom Quiche 12105 90 90 690 740 2024-06-28
12106 BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 12106 90 90 390 420 2024-06-28
12107 Mixed Nuts 12107 90 90 490 540 2024-06-28
12108 Caramel Waffles 12108 90 90 390 420 2024-06-28
12109 Chicken Ham & Cheese Panwich 12109 90 90 690 740 2024-06-28
12110 Egg Mayo & Cheese Multigrain Croissant 12110 90 90 690 740 2024-06-28
12111 Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 12111 90 90 690 740 2024-06-28
12112 Rosemary Chicken & Emmental Cheese Croissant 12112 90 90 690 740 2024-06-28
12113 Scrambled Egg & Turkey Ham Pita 12113 90 90 690 740 2024-06-28
12114 Turkey Ham & Triple Cheese Toast 12114 90 90 690 740 2024-06-28
12115 Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 12115 90 90 790 840 2024-06-28
12116 Ham & Cheese Croissant 12116 90 90 690 740 2024-06-28
12117 Sriracha Chicken Whole Wheat Pita 12117 90 90 750 800 2024-06-28
12118 Blueberry Acai Yogurt Parfait 12118 90 90 650 700 2024-06-28
12119 Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 12119 90 90 650 700 2024-06-28
12120 Caramel Frappuccino® 12120 90 90 720 770 2024-06-28
12121 Dark Mocha Frappuccino® 12121 90 90 780 830 2024-06-28
12122 Java Chip Frappuccino® 12122 90 90 780 830 2024-06-28
12123 Mocha Frappuccino® 12123 90 90 720 770 2024-06-28
12124 Caramel Macchiato Frappuccino® 12124 90 90 780 830 2024-06-28
12125 Espresso Frappuccino® 12125 90 90 720 770 2024-06-28
12126 White Chocolate Mocha Frappuccino® 12126 90 90 720 770 2024-06-28
12127 Chocolate Chip Cream Frappuccino® 12127 90 90 780 830 2024-06-28
12128 Hojicha Tea Cream Frappuccino® 12128 90 90 760 810 2024-06-28
12129 Vanilla Cream Frappuccino® 12129 90 90 720 770 2024-06-28
12130 Mango Passion Fruit & Hibiscus 12130 90 90 720 770 2024-06-28
12131 Raspberry Black Currant & Oolong 12131 90 90 720 770 2024-06-28
12132 Coffee Traveller 12132 90 90 3120 3170 2024-06-28
12133 Caffè Americano 12133 90 90 540 590 2024-06-28
12134 Cappuccino 12134 90 90 680 730 2024-06-28
12135 Caffè Mocha 12135 90 90 750 800 2024-06-28
12136 Caramel Macchiato 12136 90 90 760 810 2024-06-28
12137 Espresso 12137 90 90 390 440 2024-06-28
12138 Caffè Latte 12138 90 90 680 730 2024-06-28
12139 Oatmilk Latte 12139 90 90 760 810 2024-06-28
12140 Vanilla Latte 12140 90 90 750 800 2024-06-28
12141 White Chocolate Mocha 12141 90 90 750 800 2024-06-28
12142 Flat White 12142 90 90 760 810 2024-06-28
12143 Ristretto Bianco 12143 90 90 760 810 2024-06-28
12144 Iced Caffè Americano 12144 90 90 540 590 2024-06-28
12145 Iced Cappuccino 12145 90 90 680 730 2024-06-28
12146 Iced Caffè Mocha 12146 90 90 750 800 2024-06-28
12147 Iced Caramel Macchiato 12147 90 90 760 810 2024-06-28
12148 Iced Caffè Latte 12148 90 90 680 730 2024-06-28
12149 Iced Oatmilk Latte 12149 90 90 760 810 2024-06-28
12150 Iced Vanilla Latte 12150 90 90 750 800 2024-06-28
12151 Iced White Chocolate Mocha 12151 90 90 750 800 2024-06-28
12152 Signature Hot Chocolate 12152 90 90 720 770 2024-06-28
12153 Signature Iced Chocolate 12153 90 90 720 770 2024-06-28
12154 Carrot Juice 12154 90 90 490 540 2024-06-28
12155 Cloudy Apple Juice 12155 90 90 490 540 2024-06-28
12156 Cranberry Red Grapefruit Juice 12156 90 90 490 540 2024-06-28
12157 Orange Juice 12157 90 90 490 540 2024-06-28
12158 Evian 12158 90 90 350 400 2024-06-28
12159 Sparkling Water 12159 90 90 450 500 2024-06-28
12160 Chai Tea 12160 90 90 500 550 2024-06-28
12161 Earl Grey Tea 12161 90 90 500 550 2024-06-28
12162 English Breakfast Tea 12162 90 90 500 550 2024-06-28
12163 Emperor’s Clouds & Mist™ Tea 12163 90 90 500 550 2024-06-28
12164 Mint Blend Tea 12164 90 90 500 550 2024-06-28
12165 Chamomile Tea 12165 90 90 500 550 2024-06-28
12166 Pure Matcha Latte 12166 90 90 740 790 2024-06-28
12167 Chai Tea Latte 12167 90 90 680 730 2024-06-28
12168 Earl Grey Tea Latte 12168 90 90 680 730 2024-06-28
12169 English Breakfast Tea Latte 12169 90 90 680 730 2024-06-28
12170 Hojicha Tea Latte 12170 90 90 740 790 2024-06-28
12171 Zen Clouds Oolong Tea 12171 90 90 500 550 2024-06-28
12172 Zen Clouds Oolong with Ruby Grapefruit and Honey 12172 90 90 630 680 2024-06-28
12173 Youthberry™ Tea 12173 90 90 500 550 2024-06-28
12174 Iced Shaken Black Tea Lemonade 12174 90 90 610 660 2024-06-28
12175 Iced Shaken Strawberry Black Tea Lemonade 12175 90 90 630 680 2024-06-28
12176 Iced Shaken Hibiscus Tea Lemonade 12176 90 90 610 660 2024-06-28
12177 Iced Shaken Hibiscus Tea with Pomegranate Pearls 12177 90 90 730 780 2024-06-28
12178 Iced Pure Matcha Latte 12178 90 90 740 790 2024-06-28
12179 Iced Chai Tea Latte 12179 90 90 680 730 2024-06-28
12180 Iced Black Tea Latte 12180 90 90 680 730 2024-06-28
12181 Iced Hojicha Tea Latte 12181 90 90 740 790 2024-06-28
12182 Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 12182 90 90 630 680 2024-06-28
12183 Iced Shaken Zen Clouds Oolong Lemonade 12183 90 90 610 660 2024-06-28
12184 Iced Shaken Strawberry Zen Clouds Oolong Lemonade 12184 90 90 630 680 2024-06-28
12185 Origami Pike Place® Roast 12185 90 90 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");