item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
184 rows where effective_date = "2024-06-28" and store_id = 9
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
---|---|---|---|---|---|
25099 | Bagel 25099 | 9 9 | 400 | 430 | 2024-06-28 |
25100 | Cookie Crumble Cheesecake 25100 | 9 9 | 720 | 770 | 2024-06-28 |
25101 | Good Ol' NY Cheesecake 25101 | 9 9 | 720 | 770 | 2024-06-28 |
25102 | Signature Chocolate Cake 25102 | 9 9 | 720 | 770 | 2024-06-28 |
25103 | Starbucks® Coffee Tiramisu Cake 25103 | 9 9 | 750 | 800 | 2024-06-28 |
25104 | Strawberry Shortcake 25104 | 9 9 | 720 | 770 | 2024-06-28 |
25105 | Chocolate Chunk Monster Cookie 25105 | 9 9 | 390 | 440 | 2024-06-28 |
25106 | Banana Walnut Muffin 25106 | 9 9 | 450 | 500 | 2024-06-28 |
25107 | Blueberry Crumble Muffin 25107 | 9 9 | 450 | 500 | 2024-06-28 |
25108 | Chocolate Crumble Muffin 25108 | 9 9 | 450 | 500 | 2024-06-28 |
25109 | Pancakes 25109 | 9 9 | 550 | 600 | 2024-06-28 |
25110 | Almond Croissant 25110 | 9 9 | 470 | 520 | 2024-06-28 |
25111 | Buttery Croissant 25111 | 9 9 | 400 | 430 | 2024-06-28 |
25112 | Chocolate Croissant 25112 | 9 9 | 440 | 490 | 2024-06-28 |
25113 | Creamy Chicken Foldover 25113 | 9 9 | 550 | 600 | 2024-06-28 |
25114 | Sausage Roll 25114 | 9 9 | 550 | 600 | 2024-06-28 |
25115 | Buttery Scone 25115 | 9 9 | 400 | 430 | 2024-06-28 |
25116 | Country Chicken Pie 25116 | 9 9 | 690 | 740 | 2024-06-28 |
25117 | Deep Dish Beef Pie 25117 | 9 9 | 690 | 740 | 2024-06-28 |
25118 | Spinach & Mushroom Quiche 25118 | 9 9 | 690 | 740 | 2024-06-28 |
25119 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 25119 | 9 9 | 390 | 420 | 2024-06-28 |
25120 | Mixed Nuts 25120 | 9 9 | 490 | 540 | 2024-06-28 |
25121 | Caramel Waffles 25121 | 9 9 | 390 | 420 | 2024-06-28 |
25122 | Chicken Ham & Cheese Panwich 25122 | 9 9 | 690 | 740 | 2024-06-28 |
25123 | Egg Mayo & Cheese Multigrain Croissant 25123 | 9 9 | 690 | 740 | 2024-06-28 |
25124 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 25124 | 9 9 | 690 | 740 | 2024-06-28 |
25125 | Rosemary Chicken & Emmental Cheese Croissant 25125 | 9 9 | 690 | 740 | 2024-06-28 |
25126 | Scrambled Egg & Turkey Ham Pita 25126 | 9 9 | 690 | 740 | 2024-06-28 |
25127 | Turkey Ham & Triple Cheese Toast 25127 | 9 9 | 690 | 740 | 2024-06-28 |
25128 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 25128 | 9 9 | 790 | 840 | 2024-06-28 |
25129 | Ham & Cheese Croissant 25129 | 9 9 | 690 | 740 | 2024-06-28 |
25130 | Sriracha Chicken Whole Wheat Pita 25130 | 9 9 | 750 | 800 | 2024-06-28 |
25131 | Blueberry Acai Yogurt Parfait 25131 | 9 9 | 650 | 700 | 2024-06-28 |
25132 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 25132 | 9 9 | 650 | 700 | 2024-06-28 |
25133 | Caramel Frappuccino® 25133 | 9 9 | 720 | 770 | 2024-06-28 |
25134 | Dark Mocha Frappuccino® 25134 | 9 9 | 780 | 830 | 2024-06-28 |
25135 | Java Chip Frappuccino® 25135 | 9 9 | 780 | 830 | 2024-06-28 |
25136 | Mocha Frappuccino® 25136 | 9 9 | 720 | 770 | 2024-06-28 |
25137 | Caramel Macchiato Frappuccino® 25137 | 9 9 | 780 | 830 | 2024-06-28 |
25138 | Espresso Frappuccino® 25138 | 9 9 | 720 | 770 | 2024-06-28 |
25139 | White Chocolate Mocha Frappuccino® 25139 | 9 9 | 720 | 770 | 2024-06-28 |
25140 | Chocolate Chip Cream Frappuccino® 25140 | 9 9 | 780 | 830 | 2024-06-28 |
25141 | Hojicha Tea Cream Frappuccino® 25141 | 9 9 | 760 | 810 | 2024-06-28 |
25142 | Vanilla Cream Frappuccino® 25142 | 9 9 | 720 | 770 | 2024-06-28 |
25143 | Mango Passion Fruit & Hibiscus 25143 | 9 9 | 720 | 770 | 2024-06-28 |
25144 | Raspberry Black Currant & Oolong 25144 | 9 9 | 720 | 770 | 2024-06-28 |
25145 | Coffee Traveller 25145 | 9 9 | 3120 | 3170 | 2024-06-28 |
25146 | Caffè Americano 25146 | 9 9 | 540 | 590 | 2024-06-28 |
25147 | Cappuccino 25147 | 9 9 | 680 | 730 | 2024-06-28 |
25148 | Caffè Mocha 25148 | 9 9 | 750 | 800 | 2024-06-28 |
25149 | Caramel Macchiato 25149 | 9 9 | 760 | 810 | 2024-06-28 |
25150 | Espresso 25150 | 9 9 | 390 | 440 | 2024-06-28 |
25151 | Caffè Latte 25151 | 9 9 | 680 | 730 | 2024-06-28 |
25152 | Oatmilk Latte 25152 | 9 9 | 760 | 810 | 2024-06-28 |
25153 | Vanilla Latte 25153 | 9 9 | 750 | 800 | 2024-06-28 |
25154 | White Chocolate Mocha 25154 | 9 9 | 750 | 800 | 2024-06-28 |
25155 | Flat White 25155 | 9 9 | 760 | 810 | 2024-06-28 |
25156 | Ristretto Bianco 25156 | 9 9 | 760 | 810 | 2024-06-28 |
25157 | Iced Caffè Americano 25157 | 9 9 | 540 | 590 | 2024-06-28 |
25158 | Iced Cappuccino 25158 | 9 9 | 680 | 730 | 2024-06-28 |
25159 | Iced Caffè Mocha 25159 | 9 9 | 750 | 800 | 2024-06-28 |
25160 | Iced Caramel Macchiato 25160 | 9 9 | 760 | 810 | 2024-06-28 |
25161 | Iced Caffè Latte 25161 | 9 9 | 680 | 730 | 2024-06-28 |
25162 | Iced Oatmilk Latte 25162 | 9 9 | 760 | 810 | 2024-06-28 |
25163 | Iced Vanilla Latte 25163 | 9 9 | 750 | 800 | 2024-06-28 |
25164 | Iced White Chocolate Mocha 25164 | 9 9 | 750 | 800 | 2024-06-28 |
25165 | Signature Hot Chocolate 25165 | 9 9 | 720 | 770 | 2024-06-28 |
25166 | Signature Iced Chocolate 25166 | 9 9 | 720 | 770 | 2024-06-28 |
25167 | Carrot Juice 25167 | 9 9 | 490 | 540 | 2024-06-28 |
25168 | Cloudy Apple Juice 25168 | 9 9 | 490 | 540 | 2024-06-28 |
25169 | Cranberry Red Grapefruit Juice 25169 | 9 9 | 490 | 540 | 2024-06-28 |
25170 | Orange Juice 25170 | 9 9 | 490 | 540 | 2024-06-28 |
25171 | Evian 25171 | 9 9 | 350 | 400 | 2024-06-28 |
25172 | Sparkling Water 25172 | 9 9 | 450 | 500 | 2024-06-28 |
25173 | Chai Tea 25173 | 9 9 | 500 | 550 | 2024-06-28 |
25174 | Earl Grey Tea 25174 | 9 9 | 500 | 550 | 2024-06-28 |
25175 | English Breakfast Tea 25175 | 9 9 | 500 | 550 | 2024-06-28 |
25176 | Emperor’s Clouds & Mist™ Tea 25176 | 9 9 | 500 | 550 | 2024-06-28 |
25177 | Mint Blend Tea 25177 | 9 9 | 500 | 550 | 2024-06-28 |
25178 | Chamomile Tea 25178 | 9 9 | 500 | 550 | 2024-06-28 |
25179 | Pure Matcha Latte 25179 | 9 9 | 740 | 790 | 2024-06-28 |
25180 | Chai Tea Latte 25180 | 9 9 | 680 | 730 | 2024-06-28 |
25181 | Earl Grey Tea Latte 25181 | 9 9 | 680 | 730 | 2024-06-28 |
25182 | English Breakfast Tea Latte 25182 | 9 9 | 680 | 730 | 2024-06-28 |
25183 | Hojicha Tea Latte 25183 | 9 9 | 740 | 790 | 2024-06-28 |
25184 | Zen Clouds Oolong Tea 25184 | 9 9 | 500 | 550 | 2024-06-28 |
25185 | Zen Clouds Oolong with Ruby Grapefruit and Honey 25185 | 9 9 | 630 | 680 | 2024-06-28 |
25186 | Youthberry™ Tea 25186 | 9 9 | 500 | 550 | 2024-06-28 |
25187 | Iced Shaken Black Tea Lemonade 25187 | 9 9 | 610 | 660 | 2024-06-28 |
25188 | Iced Shaken Strawberry Black Tea Lemonade 25188 | 9 9 | 630 | 680 | 2024-06-28 |
25189 | Iced Shaken Hibiscus Tea Lemonade 25189 | 9 9 | 610 | 660 | 2024-06-28 |
25190 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 25190 | 9 9 | 730 | 780 | 2024-06-28 |
25191 | Iced Pure Matcha Latte 25191 | 9 9 | 740 | 790 | 2024-06-28 |
25192 | Iced Chai Tea Latte 25192 | 9 9 | 680 | 730 | 2024-06-28 |
25193 | Iced Black Tea Latte 25193 | 9 9 | 680 | 730 | 2024-06-28 |
25194 | Iced Hojicha Tea Latte 25194 | 9 9 | 740 | 790 | 2024-06-28 |
25195 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 25195 | 9 9 | 630 | 680 | 2024-06-28 |
25196 | Iced Shaken Zen Clouds Oolong Lemonade 25196 | 9 9 | 610 | 660 | 2024-06-28 |
25197 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 25197 | 9 9 | 630 | 680 | 2024-06-28 |
25198 | Origami Pike Place® Roast 25198 | 9 9 | 990 | 1040 | 2024-06-28 |
Advanced export
JSON shape: default, array, newline-delimited, object
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");