item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
376 rows where store_id = 148
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 14
- 2024-06-28 204
- 2024-11-10 118
- 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
- 2024-10-27 1
- 2024-11-17 1
store_id 1
- 148 · 376 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 2391 | Bagel 2391 | 148 148 | 430 | 460 | 2024-06-28 |
| 2392 | Cookie Crumble Cheesecake 2392 | 148 148 | 750 | 800 | 2024-06-28 |
| 2393 | Good Ol' NY Cheesecake 2393 | 148 148 | 750 | 800 | 2024-06-28 |
| 2394 | Signature Chocolate Cake 2394 | 148 148 | 750 | 800 | 2024-06-28 |
| 2395 | Starbucks® Coffee Tiramisu Cake 2395 | 148 148 | 780 | 830 | 2024-06-28 |
| 2396 | Strawberry Shortcake 2396 | 148 148 | 750 | 800 | 2024-06-28 |
| 2397 | Chocolate Chunk Monster Cookie 2397 | 148 148 | 420 | 470 | 2024-06-28 |
| 2398 | Banana Walnut Muffin 2398 | 148 148 | 480 | 530 | 2024-06-28 |
| 2399 | Blueberry Crumble Muffin 2399 | 148 148 | 480 | 530 | 2024-06-28 |
| 2400 | Chocolate Crumble Muffin 2400 | 148 148 | 480 | 530 | 2024-06-28 |
| 2401 | Pancakes 2401 | 148 148 | 580 | 630 | 2024-06-28 |
| 2402 | Almond Croissant 2402 | 148 148 | 500 | 550 | 2024-06-28 |
| 2403 | Buttery Croissant 2403 | 148 148 | 430 | 460 | 2024-06-28 |
| 2404 | Chocolate Croissant 2404 | 148 148 | 470 | 520 | 2024-06-28 |
| 2405 | Creamy Chicken Foldover 2405 | 148 148 | 580 | 630 | 2024-06-28 |
| 2406 | Sausage Roll 2406 | 148 148 | 580 | 630 | 2024-06-28 |
| 2407 | Buttery Scone 2407 | 148 148 | 430 | 460 | 2024-06-28 |
| 2408 | Country Chicken Pie 2408 | 148 148 | 720 | 770 | 2024-06-28 |
| 2409 | Deep Dish Beef Pie 2409 | 148 148 | 720 | 770 | 2024-06-28 |
| 2410 | Spinach & Mushroom Quiche 2410 | 148 148 | 720 | 770 | 2024-06-28 |
| 2411 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 2411 | 148 148 | 420 | 450 | 2024-06-28 |
| 2412 | Mixed Nuts 2412 | 148 148 | 520 | 570 | 2024-06-28 |
| 2413 | Caramel Waffles 2413 | 148 148 | 420 | 450 | 2024-06-28 |
| 2414 | Chicken Ham & Cheese Panwich 2414 | 148 148 | 720 | 770 | 2024-06-28 |
| 2415 | Egg Mayo & Cheese Multigrain Croissant 2415 | 148 148 | 720 | 770 | 2024-06-28 |
| 2416 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 2416 | 148 148 | 720 | 770 | 2024-06-28 |
| 2417 | Rosemary Chicken & Emmental Cheese Croissant 2417 | 148 148 | 720 | 770 | 2024-06-28 |
| 2418 | Scrambled Egg & Turkey Ham Pita 2418 | 148 148 | 720 | 770 | 2024-06-28 |
| 2419 | Turkey Ham & Triple Cheese Toast 2419 | 148 148 | 720 | 770 | 2024-06-28 |
| 2420 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 2420 | 148 148 | 820 | 870 | 2024-06-28 |
| 2421 | Ham & Cheese Croissant 2421 | 148 148 | 720 | 770 | 2024-06-28 |
| 2422 | Sriracha Chicken Whole Wheat Pita 2422 | 148 148 | 780 | 830 | 2024-06-28 |
| 2423 | Blueberry Acai Yogurt Parfait 2423 | 148 148 | 680 | 730 | 2024-06-28 |
| 2424 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 2424 | 148 148 | 680 | 730 | 2024-06-28 |
| 2425 | Caramel Frappuccino® 2425 | 148 148 | 780 | 830 | 2024-06-28 |
| 2426 | Dark Mocha Frappuccino® 2426 | 148 148 | 840 | 890 | 2024-06-28 |
| 2427 | Java Chip Frappuccino® 2427 | 148 148 | 840 | 890 | 2024-06-28 |
| 2428 | Mocha Frappuccino® 2428 | 148 148 | 780 | 830 | 2024-06-28 |
| 2429 | Caramel Macchiato Frappuccino® 2429 | 148 148 | 840 | 890 | 2024-06-28 |
| 2430 | Espresso Frappuccino® 2430 | 148 148 | 780 | 830 | 2024-06-28 |
| 2431 | White Chocolate Mocha Frappuccino® 2431 | 148 148 | 780 | 830 | 2024-06-28 |
| 2432 | Chocolate Chip Cream Frappuccino® 2432 | 148 148 | 840 | 890 | 2024-06-28 |
| 2433 | Hojicha Tea Cream Frappuccino® 2433 | 148 148 | 820 | 870 | 2024-06-28 |
| 2434 | Vanilla Cream Frappuccino® 2434 | 148 148 | 780 | 830 | 2024-06-28 |
| 2435 | Mango Passion Fruit & Hibiscus 2435 | 148 148 | 780 | 830 | 2024-06-28 |
| 2436 | Raspberry Black Currant & Oolong 2436 | 148 148 | 780 | 830 | 2024-06-28 |
| 2437 | Coffee Traveller 2437 | 148 148 | 3600 | 3650 | 2024-06-28 |
| 2438 | Caffè Americano 2438 | 148 148 | 600 | 650 | 2024-06-28 |
| 2439 | Cappuccino 2439 | 148 148 | 740 | 790 | 2024-06-28 |
| 2440 | Caffè Mocha 2440 | 148 148 | 830 | 880 | 2024-06-28 |
| 2441 | Caramel Macchiato 2441 | 148 148 | 840 | 890 | 2024-06-28 |
| 2442 | Espresso 2442 | 148 148 | 450 | 500 | 2024-06-28 |
| 2443 | Caffè Latte 2443 | 148 148 | 740 | 790 | 2024-06-28 |
| 2444 | Oatmilk Latte 2444 | 148 148 | 850 | 900 | 2024-06-28 |
| 2445 | Vanilla Latte 2445 | 148 148 | 830 | 880 | 2024-06-28 |
| 2446 | White Chocolate Mocha 2446 | 148 148 | 830 | 880 | 2024-06-28 |
| 2447 | Flat White 2447 | 148 148 | 840 | 890 | 2024-06-28 |
| 2448 | Ristretto Bianco 2448 | 148 148 | 840 | 890 | 2024-06-28 |
| 2449 | Iced Caffè Americano 2449 | 148 148 | 600 | 650 | 2024-06-28 |
| 2450 | Iced Cappuccino 2450 | 148 148 | 740 | 790 | 2024-06-28 |
| 2451 | Iced Caffè Mocha 2451 | 148 148 | 830 | 880 | 2024-06-28 |
| 2452 | Iced Caramel Macchiato 2452 | 148 148 | 840 | 890 | 2024-06-28 |
| 2453 | Iced Caffè Latte 2453 | 148 148 | 740 | 790 | 2024-06-28 |
| 2454 | Iced Oatmilk Latte 2454 | 148 148 | 850 | 900 | 2024-06-28 |
| 2455 | Iced Vanilla Latte 2455 | 148 148 | 830 | 880 | 2024-06-28 |
| 2456 | Iced White Chocolate Mocha 2456 | 148 148 | 830 | 880 | 2024-06-28 |
| 2457 | Signature Hot Chocolate 2457 | 148 148 | 780 | 830 | 2024-06-28 |
| 2458 | Signature Iced Chocolate 2458 | 148 148 | 780 | 830 | 2024-06-28 |
| 2459 | Carrot Juice 2459 | 148 148 | 550 | 600 | 2024-06-28 |
| 2460 | Cloudy Apple Juice 2460 | 148 148 | 550 | 600 | 2024-06-28 |
| 2461 | Cranberry Red Grapefruit Juice 2461 | 148 148 | 550 | 600 | 2024-06-28 |
| 2462 | Orange Juice 2462 | 148 148 | 550 | 600 | 2024-06-28 |
| 2463 | Evian 2463 | 148 148 | 410 | 460 | 2024-06-28 |
| 2464 | Sparkling Water 2464 | 148 148 | 510 | 560 | 2024-06-28 |
| 2465 | Chai Tea 2465 | 148 148 | 560 | 610 | 2024-06-28 |
| 2466 | Earl Grey Tea 2466 | 148 148 | 560 | 610 | 2024-06-28 |
| 2467 | English Breakfast Tea 2467 | 148 148 | 560 | 610 | 2024-06-28 |
| 2468 | Emperor’s Clouds & Mist™ Tea 2468 | 148 148 | 560 | 610 | 2024-06-28 |
| 2469 | Mint Blend Tea 2469 | 148 148 | 560 | 610 | 2024-06-28 |
| 2470 | Chamomile Tea 2470 | 148 148 | 560 | 610 | 2024-06-28 |
| 2471 | Pure Matcha Latte 2471 | 148 148 | 810 | 860 | 2024-06-28 |
| 2472 | Chai Tea Latte 2472 | 148 148 | 740 | 790 | 2024-06-28 |
| 2473 | Earl Grey Tea Latte 2473 | 148 148 | 740 | 790 | 2024-06-28 |
| 2474 | English Breakfast Tea Latte 2474 | 148 148 | 740 | 790 | 2024-06-28 |
| 2475 | Hojicha Tea Latte 2475 | 148 148 | 810 | 860 | 2024-06-28 |
| 2476 | Zen Clouds Oolong Tea 2476 | 148 148 | 560 | 610 | 2024-06-28 |
| 2477 | Zen Clouds Oolong with Ruby Grapefruit and Honey 2477 | 148 148 | 690 | 740 | 2024-06-28 |
| 2478 | Youthberry™ Tea 2478 | 148 148 | 560 | 610 | 2024-06-28 |
| 2479 | Iced Shaken Black Tea Lemonade 2479 | 148 148 | 670 | 720 | 2024-06-28 |
| 2480 | Iced Shaken Strawberry Black Tea Lemonade 2480 | 148 148 | 690 | 740 | 2024-06-28 |
| 2481 | Iced Shaken Hibiscus Tea Lemonade 2481 | 148 148 | 670 | 720 | 2024-06-28 |
| 2482 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 2482 | 148 148 | 790 | 840 | 2024-06-28 |
| 2483 | Iced Pure Matcha Latte 2483 | 148 148 | 810 | 860 | 2024-06-28 |
| 2484 | Iced Chai Tea Latte 2484 | 148 148 | 740 | 790 | 2024-06-28 |
| 2485 | Iced Black Tea Latte 2485 | 148 148 | 740 | 790 | 2024-06-28 |
| 2486 | Iced Hojicha Tea Latte 2486 | 148 148 | 810 | 860 | 2024-06-28 |
| 2487 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 2487 | 148 148 | 690 | 740 | 2024-06-28 |
| 2488 | Iced Shaken Zen Clouds Oolong Lemonade 2488 | 148 148 | 670 | 720 | 2024-06-28 |
| 2489 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 2489 | 148 148 | 690 | 740 | 2024-06-28 |
| 2490 | Origami Pike Place® Roast 2490 | 148 148 | 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");