item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 75
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 11
- 2024-06-28 182
- 2024-09-15 10
- 2024-11-03 9
- 2024-07-17 7
- 2024-07-28 5
- 2024-08-18 5
- 2024-07-03 4
- 2024-10-06 4
- 2024-10-13 4
- 2024-07-14 2
- 2024-09-29 2
store_id 1
- 75 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 1117 | Bagel 1117 | 75 75 | 400 | 430 | 2024-06-28 |
| 1118 | Cookie Crumble Cheesecake 1118 | 75 75 | 720 | 770 | 2024-06-28 |
| 1119 | Good Ol' NY Cheesecake 1119 | 75 75 | 720 | 770 | 2024-06-28 |
| 1120 | Signature Chocolate Cake 1120 | 75 75 | 720 | 770 | 2024-06-28 |
| 1121 | Starbucks® Coffee Tiramisu Cake 1121 | 75 75 | 750 | 800 | 2024-06-28 |
| 1122 | Strawberry Shortcake 1122 | 75 75 | 720 | 770 | 2024-06-28 |
| 1123 | Chocolate Chunk Monster Cookie 1123 | 75 75 | 390 | 440 | 2024-06-28 |
| 1124 | Banana Walnut Muffin 1124 | 75 75 | 450 | 500 | 2024-06-28 |
| 1125 | Blueberry Crumble Muffin 1125 | 75 75 | 450 | 500 | 2024-06-28 |
| 1126 | Chocolate Crumble Muffin 1126 | 75 75 | 450 | 500 | 2024-06-28 |
| 1127 | Pancakes 1127 | 75 75 | 550 | 600 | 2024-06-28 |
| 1128 | Almond Croissant 1128 | 75 75 | 470 | 520 | 2024-06-28 |
| 1129 | Buttery Croissant 1129 | 75 75 | 400 | 430 | 2024-06-28 |
| 1130 | Chocolate Croissant 1130 | 75 75 | 440 | 490 | 2024-06-28 |
| 1131 | Creamy Chicken Foldover 1131 | 75 75 | 550 | 600 | 2024-06-28 |
| 1132 | Sausage Roll 1132 | 75 75 | 550 | 600 | 2024-06-28 |
| 1133 | Buttery Scone 1133 | 75 75 | 400 | 430 | 2024-06-28 |
| 1134 | Country Chicken Pie 1134 | 75 75 | 690 | 740 | 2024-06-28 |
| 1135 | Deep Dish Beef Pie 1135 | 75 75 | 690 | 740 | 2024-06-28 |
| 1136 | Spinach & Mushroom Quiche 1136 | 75 75 | 690 | 740 | 2024-06-28 |
| 1137 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 1137 | 75 75 | 390 | 420 | 2024-06-28 |
| 1138 | Mixed Nuts 1138 | 75 75 | 490 | 540 | 2024-06-28 |
| 1139 | Caramel Waffles 1139 | 75 75 | 390 | 420 | 2024-06-28 |
| 1140 | Chicken Ham & Cheese Panwich 1140 | 75 75 | 690 | 740 | 2024-06-28 |
| 1141 | Egg Mayo & Cheese Multigrain Croissant 1141 | 75 75 | 690 | 740 | 2024-06-28 |
| 1142 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 1142 | 75 75 | 690 | 740 | 2024-06-28 |
| 1143 | Rosemary Chicken & Emmental Cheese Croissant 1143 | 75 75 | 690 | 740 | 2024-06-28 |
| 1144 | Scrambled Egg & Turkey Ham Pita 1144 | 75 75 | 690 | 740 | 2024-06-28 |
| 1145 | Turkey Ham & Triple Cheese Toast 1145 | 75 75 | 690 | 740 | 2024-06-28 |
| 1146 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 1146 | 75 75 | 790 | 840 | 2024-06-28 |
| 1147 | Ham & Cheese Croissant 1147 | 75 75 | 690 | 740 | 2024-06-28 |
| 1148 | Sriracha Chicken Whole Wheat Pita 1148 | 75 75 | 750 | 800 | 2024-06-28 |
| 1149 | Blueberry Acai Yogurt Parfait 1149 | 75 75 | 650 | 700 | 2024-06-28 |
| 1150 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 1150 | 75 75 | 650 | 700 | 2024-06-28 |
| 1151 | Caramel Frappuccino® 1151 | 75 75 | 720 | 770 | 2024-06-28 |
| 1152 | Dark Mocha Frappuccino® 1152 | 75 75 | 780 | 830 | 2024-06-28 |
| 1153 | Java Chip Frappuccino® 1153 | 75 75 | 780 | 830 | 2024-06-28 |
| 1154 | Mocha Frappuccino® 1154 | 75 75 | 720 | 770 | 2024-06-28 |
| 1155 | Caramel Macchiato Frappuccino® 1155 | 75 75 | 780 | 830 | 2024-06-28 |
| 1156 | Espresso Frappuccino® 1156 | 75 75 | 720 | 770 | 2024-06-28 |
| 1157 | White Chocolate Mocha Frappuccino® 1157 | 75 75 | 720 | 770 | 2024-06-28 |
| 1158 | Chocolate Chip Cream Frappuccino® 1158 | 75 75 | 780 | 830 | 2024-06-28 |
| 1159 | Hojicha Tea Cream Frappuccino® 1159 | 75 75 | 760 | 810 | 2024-06-28 |
| 1160 | Vanilla Cream Frappuccino® 1160 | 75 75 | 720 | 770 | 2024-06-28 |
| 1161 | Mango Passion Fruit & Hibiscus 1161 | 75 75 | 720 | 770 | 2024-06-28 |
| 1162 | Raspberry Black Currant & Oolong 1162 | 75 75 | 720 | 770 | 2024-06-28 |
| 1163 | Coffee Traveller 1163 | 75 75 | 3120 | 3170 | 2024-06-28 |
| 1164 | Caffè Americano 1164 | 75 75 | 540 | 590 | 2024-06-28 |
| 1165 | Cappuccino 1165 | 75 75 | 680 | 730 | 2024-06-28 |
| 1166 | Caffè Mocha 1166 | 75 75 | 750 | 800 | 2024-06-28 |
| 1167 | Caramel Macchiato 1167 | 75 75 | 760 | 810 | 2024-06-28 |
| 1168 | Espresso 1168 | 75 75 | 390 | 440 | 2024-06-28 |
| 1169 | Caffè Latte 1169 | 75 75 | 680 | 730 | 2024-06-28 |
| 1170 | Oatmilk Latte 1170 | 75 75 | 760 | 810 | 2024-06-28 |
| 1171 | Vanilla Latte 1171 | 75 75 | 750 | 800 | 2024-06-28 |
| 1172 | White Chocolate Mocha 1172 | 75 75 | 750 | 800 | 2024-06-28 |
| 1173 | Flat White 1173 | 75 75 | 760 | 810 | 2024-06-28 |
| 1174 | Ristretto Bianco 1174 | 75 75 | 760 | 810 | 2024-06-28 |
| 1175 | Iced Caffè Americano 1175 | 75 75 | 540 | 590 | 2024-06-28 |
| 1176 | Iced Cappuccino 1176 | 75 75 | 680 | 730 | 2024-06-28 |
| 1177 | Iced Caffè Mocha 1177 | 75 75 | 750 | 800 | 2024-06-28 |
| 1178 | Iced Caramel Macchiato 1178 | 75 75 | 760 | 810 | 2024-06-28 |
| 1179 | Iced Caffè Latte 1179 | 75 75 | 680 | 730 | 2024-06-28 |
| 1180 | Iced Oatmilk Latte 1180 | 75 75 | 760 | 810 | 2024-06-28 |
| 1181 | Iced Vanilla Latte 1181 | 75 75 | 750 | 800 | 2024-06-28 |
| 1182 | Iced White Chocolate Mocha 1182 | 75 75 | 750 | 800 | 2024-06-28 |
| 1183 | Signature Hot Chocolate 1183 | 75 75 | 720 | 770 | 2024-06-28 |
| 1184 | Signature Iced Chocolate 1184 | 75 75 | 720 | 770 | 2024-06-28 |
| 1185 | Carrot Juice 1185 | 75 75 | 490 | 540 | 2024-06-28 |
| 1186 | Cloudy Apple Juice 1186 | 75 75 | 490 | 540 | 2024-06-28 |
| 1187 | Cranberry Red Grapefruit Juice 1187 | 75 75 | 490 | 540 | 2024-06-28 |
| 1188 | Orange Juice 1188 | 75 75 | 490 | 540 | 2024-06-28 |
| 1189 | Evian 1189 | 75 75 | 350 | 400 | 2024-06-28 |
| 1190 | Sparkling Water 1190 | 75 75 | 450 | 500 | 2024-06-28 |
| 1191 | Chai Tea 1191 | 75 75 | 500 | 550 | 2024-06-28 |
| 1192 | Earl Grey Tea 1192 | 75 75 | 500 | 550 | 2024-06-28 |
| 1193 | English Breakfast Tea 1193 | 75 75 | 500 | 550 | 2024-06-28 |
| 1194 | Emperor’s Clouds & Mist™ Tea 1194 | 75 75 | 500 | 550 | 2024-06-28 |
| 1195 | Mint Blend Tea 1195 | 75 75 | 500 | 550 | 2024-06-28 |
| 1196 | Chamomile Tea 1196 | 75 75 | 500 | 550 | 2024-06-28 |
| 1197 | Pure Matcha Latte 1197 | 75 75 | 740 | 790 | 2024-06-28 |
| 1198 | Chai Tea Latte 1198 | 75 75 | 680 | 730 | 2024-06-28 |
| 1199 | Earl Grey Tea Latte 1199 | 75 75 | 680 | 730 | 2024-06-28 |
| 1200 | English Breakfast Tea Latte 1200 | 75 75 | 680 | 730 | 2024-06-28 |
| 1201 | Hojicha Tea Latte 1201 | 75 75 | 740 | 790 | 2024-06-28 |
| 1202 | Zen Clouds Oolong Tea 1202 | 75 75 | 500 | 550 | 2024-06-28 |
| 1203 | Zen Clouds Oolong with Ruby Grapefruit and Honey 1203 | 75 75 | 630 | 680 | 2024-06-28 |
| 1204 | Youthberry™ Tea 1204 | 75 75 | 500 | 550 | 2024-06-28 |
| 1205 | Iced Shaken Black Tea Lemonade 1205 | 75 75 | 610 | 660 | 2024-06-28 |
| 1206 | Iced Shaken Strawberry Black Tea Lemonade 1206 | 75 75 | 630 | 680 | 2024-06-28 |
| 1207 | Iced Shaken Hibiscus Tea Lemonade 1207 | 75 75 | 610 | 660 | 2024-06-28 |
| 1208 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 1208 | 75 75 | 730 | 780 | 2024-06-28 |
| 1209 | Iced Pure Matcha Latte 1209 | 75 75 | 740 | 790 | 2024-06-28 |
| 1210 | Iced Chai Tea Latte 1210 | 75 75 | 680 | 730 | 2024-06-28 |
| 1211 | Iced Black Tea Latte 1211 | 75 75 | 680 | 730 | 2024-06-28 |
| 1212 | Iced Hojicha Tea Latte 1212 | 75 75 | 740 | 790 | 2024-06-28 |
| 1213 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 1213 | 75 75 | 630 | 680 | 2024-06-28 |
| 1214 | Iced Shaken Zen Clouds Oolong Lemonade 1214 | 75 75 | 610 | 660 | 2024-06-28 |
| 1215 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 1215 | 75 75 | 630 | 680 | 2024-06-28 |
| 1216 | Origami Pike Place® Roast 1216 | 75 75 | 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");