item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
182 rows where effective_date = "2024-06-28" and store_id = 70
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
---|---|---|---|---|---|
15028 | Bagel 15028 | 70 70 | 400 | 430 | 2024-06-28 |
15029 | Cookie Crumble Cheesecake 15029 | 70 70 | 720 | 770 | 2024-06-28 |
15030 | Good Ol' NY Cheesecake 15030 | 70 70 | 720 | 770 | 2024-06-28 |
15031 | Signature Chocolate Cake 15031 | 70 70 | 720 | 770 | 2024-06-28 |
15032 | Starbucks® Coffee Tiramisu Cake 15032 | 70 70 | 750 | 800 | 2024-06-28 |
15033 | Strawberry Shortcake 15033 | 70 70 | 720 | 770 | 2024-06-28 |
15034 | Chocolate Chunk Monster Cookie 15034 | 70 70 | 390 | 440 | 2024-06-28 |
15035 | Banana Walnut Muffin 15035 | 70 70 | 450 | 500 | 2024-06-28 |
15036 | Blueberry Crumble Muffin 15036 | 70 70 | 450 | 500 | 2024-06-28 |
15037 | Chocolate Crumble Muffin 15037 | 70 70 | 450 | 500 | 2024-06-28 |
15038 | Pancakes 15038 | 70 70 | 550 | 600 | 2024-06-28 |
15039 | Almond Croissant 15039 | 70 70 | 470 | 520 | 2024-06-28 |
15040 | Buttery Croissant 15040 | 70 70 | 400 | 430 | 2024-06-28 |
15041 | Chocolate Croissant 15041 | 70 70 | 440 | 490 | 2024-06-28 |
15042 | Creamy Chicken Foldover 15042 | 70 70 | 550 | 600 | 2024-06-28 |
15043 | Sausage Roll 15043 | 70 70 | 550 | 600 | 2024-06-28 |
15044 | Buttery Scone 15044 | 70 70 | 400 | 430 | 2024-06-28 |
15045 | Country Chicken Pie 15045 | 70 70 | 690 | 740 | 2024-06-28 |
15046 | Deep Dish Beef Pie 15046 | 70 70 | 690 | 740 | 2024-06-28 |
15047 | Spinach & Mushroom Quiche 15047 | 70 70 | 690 | 740 | 2024-06-28 |
15048 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 15048 | 70 70 | 390 | 420 | 2024-06-28 |
15049 | Mixed Nuts 15049 | 70 70 | 490 | 540 | 2024-06-28 |
15050 | Caramel Waffles 15050 | 70 70 | 390 | 420 | 2024-06-28 |
15051 | Chicken Ham & Cheese Panwich 15051 | 70 70 | 690 | 740 | 2024-06-28 |
15052 | Egg Mayo & Cheese Multigrain Croissant 15052 | 70 70 | 690 | 740 | 2024-06-28 |
15053 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 15053 | 70 70 | 690 | 740 | 2024-06-28 |
15054 | Rosemary Chicken & Emmental Cheese Croissant 15054 | 70 70 | 690 | 740 | 2024-06-28 |
15055 | Scrambled Egg & Turkey Ham Pita 15055 | 70 70 | 690 | 740 | 2024-06-28 |
15056 | Turkey Ham & Triple Cheese Toast 15056 | 70 70 | 690 | 740 | 2024-06-28 |
15057 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 15057 | 70 70 | 790 | 840 | 2024-06-28 |
15058 | Ham & Cheese Croissant 15058 | 70 70 | 690 | 740 | 2024-06-28 |
15059 | Sriracha Chicken Whole Wheat Pita 15059 | 70 70 | 750 | 800 | 2024-06-28 |
15060 | Blueberry Acai Yogurt Parfait 15060 | 70 70 | 650 | 700 | 2024-06-28 |
15061 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 15061 | 70 70 | 650 | 700 | 2024-06-28 |
15062 | Caramel Frappuccino® 15062 | 70 70 | 720 | 770 | 2024-06-28 |
15063 | Dark Mocha Frappuccino® 15063 | 70 70 | 780 | 830 | 2024-06-28 |
15064 | Java Chip Frappuccino® 15064 | 70 70 | 780 | 830 | 2024-06-28 |
15065 | Mocha Frappuccino® 15065 | 70 70 | 720 | 770 | 2024-06-28 |
15066 | Caramel Macchiato Frappuccino® 15066 | 70 70 | 780 | 830 | 2024-06-28 |
15067 | Espresso Frappuccino® 15067 | 70 70 | 720 | 770 | 2024-06-28 |
15068 | White Chocolate Mocha Frappuccino® 15068 | 70 70 | 720 | 770 | 2024-06-28 |
15069 | Chocolate Chip Cream Frappuccino® 15069 | 70 70 | 780 | 830 | 2024-06-28 |
15070 | Hojicha Tea Cream Frappuccino® 15070 | 70 70 | 760 | 810 | 2024-06-28 |
15071 | Vanilla Cream Frappuccino® 15071 | 70 70 | 720 | 770 | 2024-06-28 |
15072 | Mango Passion Fruit & Hibiscus 15072 | 70 70 | 720 | 770 | 2024-06-28 |
15073 | Raspberry Black Currant & Oolong 15073 | 70 70 | 720 | 770 | 2024-06-28 |
15074 | Coffee Traveller 15074 | 70 70 | 3120 | 3170 | 2024-06-28 |
15075 | Caffè Americano 15075 | 70 70 | 540 | 590 | 2024-06-28 |
15076 | Cappuccino 15076 | 70 70 | 680 | 730 | 2024-06-28 |
15077 | Caffè Mocha 15077 | 70 70 | 750 | 800 | 2024-06-28 |
15078 | Caramel Macchiato 15078 | 70 70 | 760 | 810 | 2024-06-28 |
15079 | Espresso 15079 | 70 70 | 390 | 440 | 2024-06-28 |
15080 | Caffè Latte 15080 | 70 70 | 680 | 730 | 2024-06-28 |
15081 | Oatmilk Latte 15081 | 70 70 | 760 | 810 | 2024-06-28 |
15082 | Vanilla Latte 15082 | 70 70 | 750 | 800 | 2024-06-28 |
15083 | White Chocolate Mocha 15083 | 70 70 | 750 | 800 | 2024-06-28 |
15084 | Flat White 15084 | 70 70 | 760 | 810 | 2024-06-28 |
15085 | Ristretto Bianco 15085 | 70 70 | 760 | 810 | 2024-06-28 |
15086 | Iced Caffè Americano 15086 | 70 70 | 540 | 590 | 2024-06-28 |
15087 | Iced Cappuccino 15087 | 70 70 | 680 | 730 | 2024-06-28 |
15088 | Iced Caffè Mocha 15088 | 70 70 | 750 | 800 | 2024-06-28 |
15089 | Iced Caramel Macchiato 15089 | 70 70 | 760 | 810 | 2024-06-28 |
15090 | Iced Caffè Latte 15090 | 70 70 | 680 | 730 | 2024-06-28 |
15091 | Iced Oatmilk Latte 15091 | 70 70 | 760 | 810 | 2024-06-28 |
15092 | Iced Vanilla Latte 15092 | 70 70 | 750 | 800 | 2024-06-28 |
15093 | Iced White Chocolate Mocha 15093 | 70 70 | 750 | 800 | 2024-06-28 |
15094 | Signature Hot Chocolate 15094 | 70 70 | 720 | 770 | 2024-06-28 |
15095 | Signature Iced Chocolate 15095 | 70 70 | 720 | 770 | 2024-06-28 |
15096 | Carrot Juice 15096 | 70 70 | 490 | 540 | 2024-06-28 |
15097 | Cloudy Apple Juice 15097 | 70 70 | 490 | 540 | 2024-06-28 |
15098 | Cranberry Red Grapefruit Juice 15098 | 70 70 | 490 | 540 | 2024-06-28 |
15099 | Orange Juice 15099 | 70 70 | 490 | 540 | 2024-06-28 |
15100 | Evian 15100 | 70 70 | 350 | 400 | 2024-06-28 |
15101 | Sparkling Water 15101 | 70 70 | 450 | 500 | 2024-06-28 |
15102 | Chai Tea 15102 | 70 70 | 500 | 550 | 2024-06-28 |
15103 | Earl Grey Tea 15103 | 70 70 | 500 | 550 | 2024-06-28 |
15104 | English Breakfast Tea 15104 | 70 70 | 500 | 550 | 2024-06-28 |
15105 | Emperor’s Clouds & Mist™ Tea 15105 | 70 70 | 500 | 550 | 2024-06-28 |
15106 | Mint Blend Tea 15106 | 70 70 | 500 | 550 | 2024-06-28 |
15107 | Chamomile Tea 15107 | 70 70 | 500 | 550 | 2024-06-28 |
15108 | Pure Matcha Latte 15108 | 70 70 | 740 | 790 | 2024-06-28 |
15109 | Chai Tea Latte 15109 | 70 70 | 680 | 730 | 2024-06-28 |
15110 | Earl Grey Tea Latte 15110 | 70 70 | 680 | 730 | 2024-06-28 |
15111 | English Breakfast Tea Latte 15111 | 70 70 | 680 | 730 | 2024-06-28 |
15112 | Hojicha Tea Latte 15112 | 70 70 | 740 | 790 | 2024-06-28 |
15113 | Zen Clouds Oolong Tea 15113 | 70 70 | 500 | 550 | 2024-06-28 |
15114 | Zen Clouds Oolong with Ruby Grapefruit and Honey 15114 | 70 70 | 630 | 680 | 2024-06-28 |
15115 | Youthberry™ Tea 15115 | 70 70 | 500 | 550 | 2024-06-28 |
15116 | Iced Shaken Black Tea Lemonade 15116 | 70 70 | 610 | 660 | 2024-06-28 |
15117 | Iced Shaken Strawberry Black Tea Lemonade 15117 | 70 70 | 630 | 680 | 2024-06-28 |
15118 | Iced Shaken Hibiscus Tea Lemonade 15118 | 70 70 | 610 | 660 | 2024-06-28 |
15119 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 15119 | 70 70 | 730 | 780 | 2024-06-28 |
15120 | Iced Pure Matcha Latte 15120 | 70 70 | 740 | 790 | 2024-06-28 |
15121 | Iced Chai Tea Latte 15121 | 70 70 | 680 | 730 | 2024-06-28 |
15122 | Iced Black Tea Latte 15122 | 70 70 | 680 | 730 | 2024-06-28 |
15123 | Iced Hojicha Tea Latte 15123 | 70 70 | 740 | 790 | 2024-06-28 |
15124 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 15124 | 70 70 | 630 | 680 | 2024-06-28 |
15125 | Iced Shaken Zen Clouds Oolong Lemonade 15125 | 70 70 | 610 | 660 | 2024-06-28 |
15126 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 15126 | 70 70 | 630 | 680 | 2024-06-28 |
15127 | Origami Pike Place® Roast 15127 | 70 70 | 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");