item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 81
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 12
- 2024-06-28 182
- 2024-11-10 14
- 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
- 81 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 1299 | Bagel 1299 | 81 81 | 400 | 430 | 2024-06-28 |
| 1300 | Cookie Crumble Cheesecake 1300 | 81 81 | 720 | 770 | 2024-06-28 |
| 1301 | Good Ol' NY Cheesecake 1301 | 81 81 | 720 | 770 | 2024-06-28 |
| 1302 | Signature Chocolate Cake 1302 | 81 81 | 720 | 770 | 2024-06-28 |
| 1303 | Starbucks® Coffee Tiramisu Cake 1303 | 81 81 | 750 | 800 | 2024-06-28 |
| 1304 | Strawberry Shortcake 1304 | 81 81 | 720 | 770 | 2024-06-28 |
| 1305 | Chocolate Chunk Monster Cookie 1305 | 81 81 | 390 | 440 | 2024-06-28 |
| 1306 | Banana Walnut Muffin 1306 | 81 81 | 450 | 500 | 2024-06-28 |
| 1307 | Blueberry Crumble Muffin 1307 | 81 81 | 450 | 500 | 2024-06-28 |
| 1308 | Chocolate Crumble Muffin 1308 | 81 81 | 450 | 500 | 2024-06-28 |
| 1309 | Pancakes 1309 | 81 81 | 550 | 600 | 2024-06-28 |
| 1310 | Almond Croissant 1310 | 81 81 | 470 | 520 | 2024-06-28 |
| 1311 | Buttery Croissant 1311 | 81 81 | 400 | 430 | 2024-06-28 |
| 1312 | Chocolate Croissant 1312 | 81 81 | 440 | 490 | 2024-06-28 |
| 1313 | Creamy Chicken Foldover 1313 | 81 81 | 550 | 600 | 2024-06-28 |
| 1314 | Sausage Roll 1314 | 81 81 | 550 | 600 | 2024-06-28 |
| 1315 | Buttery Scone 1315 | 81 81 | 400 | 430 | 2024-06-28 |
| 1316 | Country Chicken Pie 1316 | 81 81 | 690 | 740 | 2024-06-28 |
| 1317 | Deep Dish Beef Pie 1317 | 81 81 | 690 | 740 | 2024-06-28 |
| 1318 | Spinach & Mushroom Quiche 1318 | 81 81 | 690 | 740 | 2024-06-28 |
| 1319 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 1319 | 81 81 | 390 | 420 | 2024-06-28 |
| 1320 | Mixed Nuts 1320 | 81 81 | 490 | 540 | 2024-06-28 |
| 1321 | Caramel Waffles 1321 | 81 81 | 390 | 420 | 2024-06-28 |
| 1322 | Chicken Ham & Cheese Panwich 1322 | 81 81 | 690 | 740 | 2024-06-28 |
| 1323 | Egg Mayo & Cheese Multigrain Croissant 1323 | 81 81 | 690 | 740 | 2024-06-28 |
| 1324 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 1324 | 81 81 | 690 | 740 | 2024-06-28 |
| 1325 | Rosemary Chicken & Emmental Cheese Croissant 1325 | 81 81 | 690 | 740 | 2024-06-28 |
| 1326 | Scrambled Egg & Turkey Ham Pita 1326 | 81 81 | 690 | 740 | 2024-06-28 |
| 1327 | Turkey Ham & Triple Cheese Toast 1327 | 81 81 | 690 | 740 | 2024-06-28 |
| 1328 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 1328 | 81 81 | 790 | 840 | 2024-06-28 |
| 1329 | Ham & Cheese Croissant 1329 | 81 81 | 690 | 740 | 2024-06-28 |
| 1330 | Sriracha Chicken Whole Wheat Pita 1330 | 81 81 | 750 | 800 | 2024-06-28 |
| 1331 | Blueberry Acai Yogurt Parfait 1331 | 81 81 | 650 | 700 | 2024-06-28 |
| 1332 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 1332 | 81 81 | 650 | 700 | 2024-06-28 |
| 1333 | Caramel Frappuccino® 1333 | 81 81 | 720 | 770 | 2024-06-28 |
| 1334 | Dark Mocha Frappuccino® 1334 | 81 81 | 780 | 830 | 2024-06-28 |
| 1335 | Java Chip Frappuccino® 1335 | 81 81 | 780 | 830 | 2024-06-28 |
| 1336 | Mocha Frappuccino® 1336 | 81 81 | 720 | 770 | 2024-06-28 |
| 1337 | Caramel Macchiato Frappuccino® 1337 | 81 81 | 780 | 830 | 2024-06-28 |
| 1338 | Espresso Frappuccino® 1338 | 81 81 | 720 | 770 | 2024-06-28 |
| 1339 | White Chocolate Mocha Frappuccino® 1339 | 81 81 | 720 | 770 | 2024-06-28 |
| 1340 | Chocolate Chip Cream Frappuccino® 1340 | 81 81 | 780 | 830 | 2024-06-28 |
| 1341 | Hojicha Tea Cream Frappuccino® 1341 | 81 81 | 760 | 810 | 2024-06-28 |
| 1342 | Vanilla Cream Frappuccino® 1342 | 81 81 | 720 | 770 | 2024-06-28 |
| 1343 | Mango Passion Fruit & Hibiscus 1343 | 81 81 | 720 | 770 | 2024-06-28 |
| 1344 | Raspberry Black Currant & Oolong 1344 | 81 81 | 720 | 770 | 2024-06-28 |
| 1345 | Coffee Traveller 1345 | 81 81 | 3120 | 3170 | 2024-06-28 |
| 1346 | Caffè Americano 1346 | 81 81 | 540 | 590 | 2024-06-28 |
| 1347 | Cappuccino 1347 | 81 81 | 680 | 730 | 2024-06-28 |
| 1348 | Caffè Mocha 1348 | 81 81 | 750 | 800 | 2024-06-28 |
| 1349 | Caramel Macchiato 1349 | 81 81 | 760 | 810 | 2024-06-28 |
| 1350 | Espresso 1350 | 81 81 | 390 | 440 | 2024-06-28 |
| 1351 | Caffè Latte 1351 | 81 81 | 680 | 730 | 2024-06-28 |
| 1352 | Oatmilk Latte 1352 | 81 81 | 760 | 810 | 2024-06-28 |
| 1353 | Vanilla Latte 1353 | 81 81 | 750 | 800 | 2024-06-28 |
| 1354 | White Chocolate Mocha 1354 | 81 81 | 750 | 800 | 2024-06-28 |
| 1355 | Flat White 1355 | 81 81 | 760 | 810 | 2024-06-28 |
| 1356 | Ristretto Bianco 1356 | 81 81 | 760 | 810 | 2024-06-28 |
| 1357 | Iced Caffè Americano 1357 | 81 81 | 540 | 590 | 2024-06-28 |
| 1358 | Iced Cappuccino 1358 | 81 81 | 680 | 730 | 2024-06-28 |
| 1359 | Iced Caffè Mocha 1359 | 81 81 | 750 | 800 | 2024-06-28 |
| 1360 | Iced Caramel Macchiato 1360 | 81 81 | 760 | 810 | 2024-06-28 |
| 1361 | Iced Caffè Latte 1361 | 81 81 | 680 | 730 | 2024-06-28 |
| 1362 | Iced Oatmilk Latte 1362 | 81 81 | 760 | 810 | 2024-06-28 |
| 1363 | Iced Vanilla Latte 1363 | 81 81 | 750 | 800 | 2024-06-28 |
| 1364 | Iced White Chocolate Mocha 1364 | 81 81 | 750 | 800 | 2024-06-28 |
| 1365 | Signature Hot Chocolate 1365 | 81 81 | 720 | 770 | 2024-06-28 |
| 1366 | Signature Iced Chocolate 1366 | 81 81 | 720 | 770 | 2024-06-28 |
| 1367 | Carrot Juice 1367 | 81 81 | 490 | 540 | 2024-06-28 |
| 1368 | Cloudy Apple Juice 1368 | 81 81 | 490 | 540 | 2024-06-28 |
| 1369 | Cranberry Red Grapefruit Juice 1369 | 81 81 | 490 | 540 | 2024-06-28 |
| 1370 | Orange Juice 1370 | 81 81 | 490 | 540 | 2024-06-28 |
| 1371 | Evian 1371 | 81 81 | 350 | 400 | 2024-06-28 |
| 1372 | Sparkling Water 1372 | 81 81 | 450 | 500 | 2024-06-28 |
| 1373 | Chai Tea 1373 | 81 81 | 500 | 550 | 2024-06-28 |
| 1374 | Earl Grey Tea 1374 | 81 81 | 500 | 550 | 2024-06-28 |
| 1375 | English Breakfast Tea 1375 | 81 81 | 500 | 550 | 2024-06-28 |
| 1376 | Emperor’s Clouds & Mist™ Tea 1376 | 81 81 | 500 | 550 | 2024-06-28 |
| 1377 | Mint Blend Tea 1377 | 81 81 | 500 | 550 | 2024-06-28 |
| 1378 | Chamomile Tea 1378 | 81 81 | 500 | 550 | 2024-06-28 |
| 1379 | Pure Matcha Latte 1379 | 81 81 | 740 | 790 | 2024-06-28 |
| 1380 | Chai Tea Latte 1380 | 81 81 | 680 | 730 | 2024-06-28 |
| 1381 | Earl Grey Tea Latte 1381 | 81 81 | 680 | 730 | 2024-06-28 |
| 1382 | English Breakfast Tea Latte 1382 | 81 81 | 680 | 730 | 2024-06-28 |
| 1383 | Hojicha Tea Latte 1383 | 81 81 | 740 | 790 | 2024-06-28 |
| 1384 | Zen Clouds Oolong Tea 1384 | 81 81 | 500 | 550 | 2024-06-28 |
| 1385 | Zen Clouds Oolong with Ruby Grapefruit and Honey 1385 | 81 81 | 630 | 680 | 2024-06-28 |
| 1386 | Youthberry™ Tea 1386 | 81 81 | 500 | 550 | 2024-06-28 |
| 1387 | Iced Shaken Black Tea Lemonade 1387 | 81 81 | 610 | 660 | 2024-06-28 |
| 1388 | Iced Shaken Strawberry Black Tea Lemonade 1388 | 81 81 | 630 | 680 | 2024-06-28 |
| 1389 | Iced Shaken Hibiscus Tea Lemonade 1389 | 81 81 | 610 | 660 | 2024-06-28 |
| 1390 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 1390 | 81 81 | 730 | 780 | 2024-06-28 |
| 1391 | Iced Pure Matcha Latte 1391 | 81 81 | 740 | 790 | 2024-06-28 |
| 1392 | Iced Chai Tea Latte 1392 | 81 81 | 680 | 730 | 2024-06-28 |
| 1393 | Iced Black Tea Latte 1393 | 81 81 | 680 | 730 | 2024-06-28 |
| 1394 | Iced Hojicha Tea Latte 1394 | 81 81 | 740 | 790 | 2024-06-28 |
| 1395 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 1395 | 81 81 | 630 | 680 | 2024-06-28 |
| 1396 | Iced Shaken Zen Clouds Oolong Lemonade 1396 | 81 81 | 610 | 660 | 2024-06-28 |
| 1397 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 1397 | 81 81 | 630 | 680 | 2024-06-28 |
| 1398 | Origami Pike Place® Roast 1398 | 81 81 | 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");