item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
248 rows where store_id = 120
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
- 120 · 248 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 6800 | Bagel 6800 | 120 120 | 400 | 430 | 2024-06-28 |
| 6801 | Cookie Crumble Cheesecake 6801 | 120 120 | 720 | 770 | 2024-06-28 |
| 6802 | Good Ol' NY Cheesecake 6802 | 120 120 | 720 | 770 | 2024-06-28 |
| 6803 | Signature Chocolate Cake 6803 | 120 120 | 720 | 770 | 2024-06-28 |
| 6804 | Starbucks® Coffee Tiramisu Cake 6804 | 120 120 | 750 | 800 | 2024-06-28 |
| 6805 | Strawberry Shortcake 6805 | 120 120 | 720 | 770 | 2024-06-28 |
| 6806 | Chocolate Chunk Monster Cookie 6806 | 120 120 | 390 | 440 | 2024-06-28 |
| 6807 | Banana Walnut Muffin 6807 | 120 120 | 450 | 500 | 2024-06-28 |
| 6808 | Blueberry Crumble Muffin 6808 | 120 120 | 450 | 500 | 2024-06-28 |
| 6809 | Chocolate Crumble Muffin 6809 | 120 120 | 450 | 500 | 2024-06-28 |
| 6810 | Pancakes 6810 | 120 120 | 550 | 600 | 2024-06-28 |
| 6811 | Almond Croissant 6811 | 120 120 | 470 | 520 | 2024-06-28 |
| 6812 | Buttery Croissant 6812 | 120 120 | 400 | 430 | 2024-06-28 |
| 6813 | Chocolate Croissant 6813 | 120 120 | 440 | 490 | 2024-06-28 |
| 6814 | Creamy Chicken Foldover 6814 | 120 120 | 550 | 600 | 2024-06-28 |
| 6815 | Sausage Roll 6815 | 120 120 | 550 | 600 | 2024-06-28 |
| 6816 | Buttery Scone 6816 | 120 120 | 400 | 430 | 2024-06-28 |
| 6817 | Country Chicken Pie 6817 | 120 120 | 690 | 740 | 2024-06-28 |
| 6818 | Deep Dish Beef Pie 6818 | 120 120 | 690 | 740 | 2024-06-28 |
| 6819 | Spinach & Mushroom Quiche 6819 | 120 120 | 690 | 740 | 2024-06-28 |
| 6820 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 6820 | 120 120 | 390 | 420 | 2024-06-28 |
| 6821 | Mixed Nuts 6821 | 120 120 | 490 | 540 | 2024-06-28 |
| 6822 | Caramel Waffles 6822 | 120 120 | 390 | 420 | 2024-06-28 |
| 6823 | Chicken Ham & Cheese Panwich 6823 | 120 120 | 690 | 740 | 2024-06-28 |
| 6824 | Egg Mayo & Cheese Multigrain Croissant 6824 | 120 120 | 690 | 740 | 2024-06-28 |
| 6825 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 6825 | 120 120 | 690 | 740 | 2024-06-28 |
| 6826 | Rosemary Chicken & Emmental Cheese Croissant 6826 | 120 120 | 690 | 740 | 2024-06-28 |
| 6827 | Scrambled Egg & Turkey Ham Pita 6827 | 120 120 | 690 | 740 | 2024-06-28 |
| 6828 | Turkey Ham & Triple Cheese Toast 6828 | 120 120 | 690 | 740 | 2024-06-28 |
| 6829 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 6829 | 120 120 | 790 | 840 | 2024-06-28 |
| 6830 | Ham & Cheese Croissant 6830 | 120 120 | 690 | 740 | 2024-06-28 |
| 6831 | Sriracha Chicken Whole Wheat Pita 6831 | 120 120 | 750 | 800 | 2024-06-28 |
| 6832 | Blueberry Acai Yogurt Parfait 6832 | 120 120 | 650 | 700 | 2024-06-28 |
| 6833 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 6833 | 120 120 | 650 | 700 | 2024-06-28 |
| 6834 | Caramel Frappuccino® 6834 | 120 120 | 720 | 770 | 2024-06-28 |
| 6835 | Dark Mocha Frappuccino® 6835 | 120 120 | 780 | 830 | 2024-06-28 |
| 6836 | Java Chip Frappuccino® 6836 | 120 120 | 780 | 830 | 2024-06-28 |
| 6837 | Mocha Frappuccino® 6837 | 120 120 | 720 | 770 | 2024-06-28 |
| 6838 | Caramel Macchiato Frappuccino® 6838 | 120 120 | 780 | 830 | 2024-06-28 |
| 6839 | Espresso Frappuccino® 6839 | 120 120 | 720 | 770 | 2024-06-28 |
| 6840 | White Chocolate Mocha Frappuccino® 6840 | 120 120 | 720 | 770 | 2024-06-28 |
| 6841 | Chocolate Chip Cream Frappuccino® 6841 | 120 120 | 780 | 830 | 2024-06-28 |
| 6842 | Hojicha Tea Cream Frappuccino® 6842 | 120 120 | 760 | 810 | 2024-06-28 |
| 6843 | Vanilla Cream Frappuccino® 6843 | 120 120 | 720 | 770 | 2024-06-28 |
| 6844 | Mango Passion Fruit & Hibiscus 6844 | 120 120 | 720 | 770 | 2024-06-28 |
| 6845 | Raspberry Black Currant & Oolong 6845 | 120 120 | 720 | 770 | 2024-06-28 |
| 6846 | Coffee Traveller 6846 | 120 120 | 3120 | 3170 | 2024-06-28 |
| 6847 | Caffè Americano 6847 | 120 120 | 540 | 590 | 2024-06-28 |
| 6848 | Cappuccino 6848 | 120 120 | 680 | 730 | 2024-06-28 |
| 6849 | Caffè Mocha 6849 | 120 120 | 750 | 800 | 2024-06-28 |
| 6850 | Caramel Macchiato 6850 | 120 120 | 760 | 810 | 2024-06-28 |
| 6851 | Espresso 6851 | 120 120 | 390 | 440 | 2024-06-28 |
| 6852 | Caffè Latte 6852 | 120 120 | 680 | 730 | 2024-06-28 |
| 6853 | Oatmilk Latte 6853 | 120 120 | 760 | 810 | 2024-06-28 |
| 6854 | Vanilla Latte 6854 | 120 120 | 750 | 800 | 2024-06-28 |
| 6855 | White Chocolate Mocha 6855 | 120 120 | 750 | 800 | 2024-06-28 |
| 6856 | Flat White 6856 | 120 120 | 760 | 810 | 2024-06-28 |
| 6857 | Ristretto Bianco 6857 | 120 120 | 760 | 810 | 2024-06-28 |
| 6858 | Iced Caffè Americano 6858 | 120 120 | 540 | 590 | 2024-06-28 |
| 6859 | Iced Cappuccino 6859 | 120 120 | 680 | 730 | 2024-06-28 |
| 6860 | Iced Caffè Mocha 6860 | 120 120 | 750 | 800 | 2024-06-28 |
| 6861 | Iced Caramel Macchiato 6861 | 120 120 | 760 | 810 | 2024-06-28 |
| 6862 | Iced Caffè Latte 6862 | 120 120 | 680 | 730 | 2024-06-28 |
| 6863 | Iced Oatmilk Latte 6863 | 120 120 | 760 | 810 | 2024-06-28 |
| 6864 | Iced Vanilla Latte 6864 | 120 120 | 750 | 800 | 2024-06-28 |
| 6865 | Iced White Chocolate Mocha 6865 | 120 120 | 750 | 800 | 2024-06-28 |
| 6866 | Signature Hot Chocolate 6866 | 120 120 | 720 | 770 | 2024-06-28 |
| 6867 | Signature Iced Chocolate 6867 | 120 120 | 720 | 770 | 2024-06-28 |
| 6868 | Carrot Juice 6868 | 120 120 | 490 | 540 | 2024-06-28 |
| 6869 | Cloudy Apple Juice 6869 | 120 120 | 490 | 540 | 2024-06-28 |
| 6870 | Cranberry Red Grapefruit Juice 6870 | 120 120 | 490 | 540 | 2024-06-28 |
| 6871 | Orange Juice 6871 | 120 120 | 490 | 540 | 2024-06-28 |
| 6872 | Evian 6872 | 120 120 | 350 | 400 | 2024-06-28 |
| 6873 | Sparkling Water 6873 | 120 120 | 450 | 500 | 2024-06-28 |
| 6874 | Chai Tea 6874 | 120 120 | 500 | 550 | 2024-06-28 |
| 6875 | Earl Grey Tea 6875 | 120 120 | 500 | 550 | 2024-06-28 |
| 6876 | English Breakfast Tea 6876 | 120 120 | 500 | 550 | 2024-06-28 |
| 6877 | Emperor’s Clouds & Mist™ Tea 6877 | 120 120 | 500 | 550 | 2024-06-28 |
| 6878 | Mint Blend Tea 6878 | 120 120 | 500 | 550 | 2024-06-28 |
| 6879 | Chamomile Tea 6879 | 120 120 | 500 | 550 | 2024-06-28 |
| 6880 | Pure Matcha Latte 6880 | 120 120 | 740 | 790 | 2024-06-28 |
| 6881 | Chai Tea Latte 6881 | 120 120 | 680 | 730 | 2024-06-28 |
| 6882 | Earl Grey Tea Latte 6882 | 120 120 | 680 | 730 | 2024-06-28 |
| 6883 | English Breakfast Tea Latte 6883 | 120 120 | 680 | 730 | 2024-06-28 |
| 6884 | Hojicha Tea Latte 6884 | 120 120 | 740 | 790 | 2024-06-28 |
| 6885 | Zen Clouds Oolong Tea 6885 | 120 120 | 500 | 550 | 2024-06-28 |
| 6886 | Zen Clouds Oolong with Ruby Grapefruit and Honey 6886 | 120 120 | 630 | 680 | 2024-06-28 |
| 6887 | Youthberry™ Tea 6887 | 120 120 | 500 | 550 | 2024-06-28 |
| 6888 | Iced Shaken Black Tea Lemonade 6888 | 120 120 | 610 | 660 | 2024-06-28 |
| 6889 | Iced Shaken Strawberry Black Tea Lemonade 6889 | 120 120 | 630 | 680 | 2024-06-28 |
| 6890 | Iced Shaken Hibiscus Tea Lemonade 6890 | 120 120 | 610 | 660 | 2024-06-28 |
| 6891 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 6891 | 120 120 | 730 | 780 | 2024-06-28 |
| 6892 | Iced Pure Matcha Latte 6892 | 120 120 | 740 | 790 | 2024-06-28 |
| 6893 | Iced Chai Tea Latte 6893 | 120 120 | 680 | 730 | 2024-06-28 |
| 6894 | Iced Black Tea Latte 6894 | 120 120 | 680 | 730 | 2024-06-28 |
| 6895 | Iced Hojicha Tea Latte 6895 | 120 120 | 740 | 790 | 2024-06-28 |
| 6896 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 6896 | 120 120 | 630 | 680 | 2024-06-28 |
| 6897 | Iced Shaken Zen Clouds Oolong Lemonade 6897 | 120 120 | 610 | 660 | 2024-06-28 |
| 6898 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 6898 | 120 120 | 630 | 680 | 2024-06-28 |
| 6899 | Origami Pike Place® Roast 6899 | 120 120 | 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");