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 = 8
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
---|---|---|---|---|---|
25283 | Bagel 25283 | 8 8 | 400 | 430 | 2024-06-28 |
25284 | Cookie Crumble Cheesecake 25284 | 8 8 | 720 | 770 | 2024-06-28 |
25285 | Good Ol' NY Cheesecake 25285 | 8 8 | 720 | 770 | 2024-06-28 |
25286 | Signature Chocolate Cake 25286 | 8 8 | 720 | 770 | 2024-06-28 |
25287 | Starbucks® Coffee Tiramisu Cake 25287 | 8 8 | 750 | 800 | 2024-06-28 |
25288 | Strawberry Shortcake 25288 | 8 8 | 720 | 770 | 2024-06-28 |
25289 | Chocolate Chunk Monster Cookie 25289 | 8 8 | 390 | 440 | 2024-06-28 |
25290 | Banana Walnut Muffin 25290 | 8 8 | 450 | 500 | 2024-06-28 |
25291 | Blueberry Crumble Muffin 25291 | 8 8 | 450 | 500 | 2024-06-28 |
25292 | Chocolate Crumble Muffin 25292 | 8 8 | 450 | 500 | 2024-06-28 |
25293 | Pancakes 25293 | 8 8 | 550 | 600 | 2024-06-28 |
25294 | Almond Croissant 25294 | 8 8 | 470 | 520 | 2024-06-28 |
25295 | Buttery Croissant 25295 | 8 8 | 400 | 430 | 2024-06-28 |
25296 | Chocolate Croissant 25296 | 8 8 | 440 | 490 | 2024-06-28 |
25297 | Creamy Chicken Foldover 25297 | 8 8 | 550 | 600 | 2024-06-28 |
25298 | Sausage Roll 25298 | 8 8 | 550 | 600 | 2024-06-28 |
25299 | Buttery Scone 25299 | 8 8 | 400 | 430 | 2024-06-28 |
25300 | Country Chicken Pie 25300 | 8 8 | 690 | 740 | 2024-06-28 |
25301 | Deep Dish Beef Pie 25301 | 8 8 | 690 | 740 | 2024-06-28 |
25302 | Spinach & Mushroom Quiche 25302 | 8 8 | 690 | 740 | 2024-06-28 |
25303 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 25303 | 8 8 | 390 | 420 | 2024-06-28 |
25304 | Mixed Nuts 25304 | 8 8 | 490 | 540 | 2024-06-28 |
25305 | Caramel Waffles 25305 | 8 8 | 390 | 420 | 2024-06-28 |
25306 | Chicken Ham & Cheese Panwich 25306 | 8 8 | 690 | 740 | 2024-06-28 |
25307 | Egg Mayo & Cheese Multigrain Croissant 25307 | 8 8 | 690 | 740 | 2024-06-28 |
25308 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 25308 | 8 8 | 690 | 740 | 2024-06-28 |
25309 | Rosemary Chicken & Emmental Cheese Croissant 25309 | 8 8 | 690 | 740 | 2024-06-28 |
25310 | Scrambled Egg & Turkey Ham Pita 25310 | 8 8 | 690 | 740 | 2024-06-28 |
25311 | Turkey Ham & Triple Cheese Toast 25311 | 8 8 | 690 | 740 | 2024-06-28 |
25312 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 25312 | 8 8 | 790 | 840 | 2024-06-28 |
25313 | Ham & Cheese Croissant 25313 | 8 8 | 690 | 740 | 2024-06-28 |
25314 | Sriracha Chicken Whole Wheat Pita 25314 | 8 8 | 750 | 800 | 2024-06-28 |
25315 | Blueberry Acai Yogurt Parfait 25315 | 8 8 | 650 | 700 | 2024-06-28 |
25316 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 25316 | 8 8 | 650 | 700 | 2024-06-28 |
25317 | Caramel Frappuccino® 25317 | 8 8 | 720 | 770 | 2024-06-28 |
25318 | Dark Mocha Frappuccino® 25318 | 8 8 | 780 | 830 | 2024-06-28 |
25319 | Java Chip Frappuccino® 25319 | 8 8 | 780 | 830 | 2024-06-28 |
25320 | Mocha Frappuccino® 25320 | 8 8 | 720 | 770 | 2024-06-28 |
25321 | Caramel Macchiato Frappuccino® 25321 | 8 8 | 780 | 830 | 2024-06-28 |
25322 | Espresso Frappuccino® 25322 | 8 8 | 720 | 770 | 2024-06-28 |
25323 | White Chocolate Mocha Frappuccino® 25323 | 8 8 | 720 | 770 | 2024-06-28 |
25324 | Chocolate Chip Cream Frappuccino® 25324 | 8 8 | 780 | 830 | 2024-06-28 |
25325 | Hojicha Tea Cream Frappuccino® 25325 | 8 8 | 760 | 810 | 2024-06-28 |
25326 | Vanilla Cream Frappuccino® 25326 | 8 8 | 720 | 770 | 2024-06-28 |
25327 | Mango Passion Fruit & Hibiscus 25327 | 8 8 | 720 | 770 | 2024-06-28 |
25328 | Raspberry Black Currant & Oolong 25328 | 8 8 | 720 | 770 | 2024-06-28 |
25329 | Coffee Traveller 25329 | 8 8 | 3120 | 3170 | 2024-06-28 |
25330 | Caffè Americano 25330 | 8 8 | 540 | 590 | 2024-06-28 |
25331 | Cappuccino 25331 | 8 8 | 680 | 730 | 2024-06-28 |
25332 | Caffè Mocha 25332 | 8 8 | 750 | 800 | 2024-06-28 |
25333 | Caramel Macchiato 25333 | 8 8 | 760 | 810 | 2024-06-28 |
25334 | Espresso 25334 | 8 8 | 390 | 440 | 2024-06-28 |
25335 | Caffè Latte 25335 | 8 8 | 680 | 730 | 2024-06-28 |
25336 | Oatmilk Latte 25336 | 8 8 | 760 | 810 | 2024-06-28 |
25337 | Vanilla Latte 25337 | 8 8 | 750 | 800 | 2024-06-28 |
25338 | White Chocolate Mocha 25338 | 8 8 | 750 | 800 | 2024-06-28 |
25339 | Flat White 25339 | 8 8 | 760 | 810 | 2024-06-28 |
25340 | Ristretto Bianco 25340 | 8 8 | 760 | 810 | 2024-06-28 |
25341 | Iced Caffè Americano 25341 | 8 8 | 540 | 590 | 2024-06-28 |
25342 | Iced Cappuccino 25342 | 8 8 | 680 | 730 | 2024-06-28 |
25343 | Iced Caffè Mocha 25343 | 8 8 | 750 | 800 | 2024-06-28 |
25344 | Iced Caramel Macchiato 25344 | 8 8 | 760 | 810 | 2024-06-28 |
25345 | Iced Caffè Latte 25345 | 8 8 | 680 | 730 | 2024-06-28 |
25346 | Iced Oatmilk Latte 25346 | 8 8 | 760 | 810 | 2024-06-28 |
25347 | Iced Vanilla Latte 25347 | 8 8 | 750 | 800 | 2024-06-28 |
25348 | Iced White Chocolate Mocha 25348 | 8 8 | 750 | 800 | 2024-06-28 |
25349 | Signature Hot Chocolate 25349 | 8 8 | 720 | 770 | 2024-06-28 |
25350 | Signature Iced Chocolate 25350 | 8 8 | 720 | 770 | 2024-06-28 |
25351 | Carrot Juice 25351 | 8 8 | 490 | 540 | 2024-06-28 |
25352 | Cloudy Apple Juice 25352 | 8 8 | 490 | 540 | 2024-06-28 |
25353 | Cranberry Red Grapefruit Juice 25353 | 8 8 | 490 | 540 | 2024-06-28 |
25354 | Orange Juice 25354 | 8 8 | 490 | 540 | 2024-06-28 |
25355 | Evian 25355 | 8 8 | 350 | 400 | 2024-06-28 |
25356 | Sparkling Water 25356 | 8 8 | 450 | 500 | 2024-06-28 |
25357 | Chai Tea 25357 | 8 8 | 500 | 550 | 2024-06-28 |
25358 | Earl Grey Tea 25358 | 8 8 | 500 | 550 | 2024-06-28 |
25359 | English Breakfast Tea 25359 | 8 8 | 500 | 550 | 2024-06-28 |
25360 | Emperor’s Clouds & Mist™ Tea 25360 | 8 8 | 500 | 550 | 2024-06-28 |
25361 | Mint Blend Tea 25361 | 8 8 | 500 | 550 | 2024-06-28 |
25362 | Chamomile Tea 25362 | 8 8 | 500 | 550 | 2024-06-28 |
25363 | Pure Matcha Latte 25363 | 8 8 | 740 | 790 | 2024-06-28 |
25364 | Chai Tea Latte 25364 | 8 8 | 680 | 730 | 2024-06-28 |
25365 | Earl Grey Tea Latte 25365 | 8 8 | 680 | 730 | 2024-06-28 |
25366 | English Breakfast Tea Latte 25366 | 8 8 | 680 | 730 | 2024-06-28 |
25367 | Hojicha Tea Latte 25367 | 8 8 | 740 | 790 | 2024-06-28 |
25368 | Zen Clouds Oolong Tea 25368 | 8 8 | 500 | 550 | 2024-06-28 |
25369 | Zen Clouds Oolong with Ruby Grapefruit and Honey 25369 | 8 8 | 630 | 680 | 2024-06-28 |
25370 | Youthberry™ Tea 25370 | 8 8 | 500 | 550 | 2024-06-28 |
25371 | Iced Shaken Black Tea Lemonade 25371 | 8 8 | 610 | 660 | 2024-06-28 |
25372 | Iced Shaken Strawberry Black Tea Lemonade 25372 | 8 8 | 630 | 680 | 2024-06-28 |
25373 | Iced Shaken Hibiscus Tea Lemonade 25373 | 8 8 | 610 | 660 | 2024-06-28 |
25374 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 25374 | 8 8 | 730 | 780 | 2024-06-28 |
25375 | Iced Pure Matcha Latte 25375 | 8 8 | 740 | 790 | 2024-06-28 |
25376 | Iced Chai Tea Latte 25376 | 8 8 | 680 | 730 | 2024-06-28 |
25377 | Iced Black Tea Latte 25377 | 8 8 | 680 | 730 | 2024-06-28 |
25378 | Iced Hojicha Tea Latte 25378 | 8 8 | 740 | 790 | 2024-06-28 |
25379 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 25379 | 8 8 | 630 | 680 | 2024-06-28 |
25380 | Iced Shaken Zen Clouds Oolong Lemonade 25380 | 8 8 | 610 | 660 | 2024-06-28 |
25381 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 25381 | 8 8 | 630 | 680 | 2024-06-28 |
25382 | Origami Pike Place® Roast 25382 | 8 8 | 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");