item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 86
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
- 86 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 12840 | Bagel 12840 | 86 86 | 400 | 430 | 2024-06-28 |
| 12841 | Cookie Crumble Cheesecake 12841 | 86 86 | 720 | 770 | 2024-06-28 |
| 12842 | Good Ol' NY Cheesecake 12842 | 86 86 | 720 | 770 | 2024-06-28 |
| 12843 | Signature Chocolate Cake 12843 | 86 86 | 720 | 770 | 2024-06-28 |
| 12844 | Starbucks® Coffee Tiramisu Cake 12844 | 86 86 | 750 | 800 | 2024-06-28 |
| 12845 | Strawberry Shortcake 12845 | 86 86 | 720 | 770 | 2024-06-28 |
| 12846 | Chocolate Chunk Monster Cookie 12846 | 86 86 | 390 | 440 | 2024-06-28 |
| 12847 | Banana Walnut Muffin 12847 | 86 86 | 450 | 500 | 2024-06-28 |
| 12848 | Blueberry Crumble Muffin 12848 | 86 86 | 450 | 500 | 2024-06-28 |
| 12849 | Chocolate Crumble Muffin 12849 | 86 86 | 450 | 500 | 2024-06-28 |
| 12850 | Pancakes 12850 | 86 86 | 550 | 600 | 2024-06-28 |
| 12851 | Almond Croissant 12851 | 86 86 | 470 | 520 | 2024-06-28 |
| 12852 | Buttery Croissant 12852 | 86 86 | 400 | 430 | 2024-06-28 |
| 12853 | Chocolate Croissant 12853 | 86 86 | 440 | 490 | 2024-06-28 |
| 12854 | Creamy Chicken Foldover 12854 | 86 86 | 550 | 600 | 2024-06-28 |
| 12855 | Sausage Roll 12855 | 86 86 | 550 | 600 | 2024-06-28 |
| 12856 | Buttery Scone 12856 | 86 86 | 400 | 430 | 2024-06-28 |
| 12857 | Country Chicken Pie 12857 | 86 86 | 690 | 740 | 2024-06-28 |
| 12858 | Deep Dish Beef Pie 12858 | 86 86 | 690 | 740 | 2024-06-28 |
| 12859 | Spinach & Mushroom Quiche 12859 | 86 86 | 690 | 740 | 2024-06-28 |
| 12860 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 12860 | 86 86 | 390 | 420 | 2024-06-28 |
| 12861 | Mixed Nuts 12861 | 86 86 | 490 | 540 | 2024-06-28 |
| 12862 | Caramel Waffles 12862 | 86 86 | 390 | 420 | 2024-06-28 |
| 12863 | Chicken Ham & Cheese Panwich 12863 | 86 86 | 690 | 740 | 2024-06-28 |
| 12864 | Egg Mayo & Cheese Multigrain Croissant 12864 | 86 86 | 690 | 740 | 2024-06-28 |
| 12865 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 12865 | 86 86 | 690 | 740 | 2024-06-28 |
| 12866 | Rosemary Chicken & Emmental Cheese Croissant 12866 | 86 86 | 690 | 740 | 2024-06-28 |
| 12867 | Scrambled Egg & Turkey Ham Pita 12867 | 86 86 | 690 | 740 | 2024-06-28 |
| 12868 | Turkey Ham & Triple Cheese Toast 12868 | 86 86 | 690 | 740 | 2024-06-28 |
| 12869 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 12869 | 86 86 | 790 | 840 | 2024-06-28 |
| 12870 | Ham & Cheese Croissant 12870 | 86 86 | 690 | 740 | 2024-06-28 |
| 12871 | Sriracha Chicken Whole Wheat Pita 12871 | 86 86 | 750 | 800 | 2024-06-28 |
| 12872 | Blueberry Acai Yogurt Parfait 12872 | 86 86 | 650 | 700 | 2024-06-28 |
| 12873 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 12873 | 86 86 | 650 | 700 | 2024-06-28 |
| 12874 | Caramel Frappuccino® 12874 | 86 86 | 720 | 770 | 2024-06-28 |
| 12875 | Dark Mocha Frappuccino® 12875 | 86 86 | 780 | 830 | 2024-06-28 |
| 12876 | Java Chip Frappuccino® 12876 | 86 86 | 780 | 830 | 2024-06-28 |
| 12877 | Mocha Frappuccino® 12877 | 86 86 | 720 | 770 | 2024-06-28 |
| 12878 | Caramel Macchiato Frappuccino® 12878 | 86 86 | 780 | 830 | 2024-06-28 |
| 12879 | Espresso Frappuccino® 12879 | 86 86 | 720 | 770 | 2024-06-28 |
| 12880 | White Chocolate Mocha Frappuccino® 12880 | 86 86 | 720 | 770 | 2024-06-28 |
| 12881 | Chocolate Chip Cream Frappuccino® 12881 | 86 86 | 780 | 830 | 2024-06-28 |
| 12882 | Hojicha Tea Cream Frappuccino® 12882 | 86 86 | 760 | 810 | 2024-06-28 |
| 12883 | Vanilla Cream Frappuccino® 12883 | 86 86 | 720 | 770 | 2024-06-28 |
| 12884 | Mango Passion Fruit & Hibiscus 12884 | 86 86 | 720 | 770 | 2024-06-28 |
| 12885 | Raspberry Black Currant & Oolong 12885 | 86 86 | 720 | 770 | 2024-06-28 |
| 12886 | Coffee Traveller 12886 | 86 86 | 3120 | 3170 | 2024-06-28 |
| 12887 | Caffè Americano 12887 | 86 86 | 540 | 590 | 2024-06-28 |
| 12888 | Cappuccino 12888 | 86 86 | 680 | 730 | 2024-06-28 |
| 12889 | Caffè Mocha 12889 | 86 86 | 750 | 800 | 2024-06-28 |
| 12890 | Caramel Macchiato 12890 | 86 86 | 760 | 810 | 2024-06-28 |
| 12891 | Espresso 12891 | 86 86 | 390 | 440 | 2024-06-28 |
| 12892 | Caffè Latte 12892 | 86 86 | 680 | 730 | 2024-06-28 |
| 12893 | Oatmilk Latte 12893 | 86 86 | 760 | 810 | 2024-06-28 |
| 12894 | Vanilla Latte 12894 | 86 86 | 750 | 800 | 2024-06-28 |
| 12895 | White Chocolate Mocha 12895 | 86 86 | 750 | 800 | 2024-06-28 |
| 12896 | Flat White 12896 | 86 86 | 760 | 810 | 2024-06-28 |
| 12897 | Ristretto Bianco 12897 | 86 86 | 760 | 810 | 2024-06-28 |
| 12898 | Iced Caffè Americano 12898 | 86 86 | 540 | 590 | 2024-06-28 |
| 12899 | Iced Cappuccino 12899 | 86 86 | 680 | 730 | 2024-06-28 |
| 12900 | Iced Caffè Mocha 12900 | 86 86 | 750 | 800 | 2024-06-28 |
| 12901 | Iced Caramel Macchiato 12901 | 86 86 | 760 | 810 | 2024-06-28 |
| 12902 | Iced Caffè Latte 12902 | 86 86 | 680 | 730 | 2024-06-28 |
| 12903 | Iced Oatmilk Latte 12903 | 86 86 | 760 | 810 | 2024-06-28 |
| 12904 | Iced Vanilla Latte 12904 | 86 86 | 750 | 800 | 2024-06-28 |
| 12905 | Iced White Chocolate Mocha 12905 | 86 86 | 750 | 800 | 2024-06-28 |
| 12906 | Signature Hot Chocolate 12906 | 86 86 | 720 | 770 | 2024-06-28 |
| 12907 | Signature Iced Chocolate 12907 | 86 86 | 720 | 770 | 2024-06-28 |
| 12908 | Carrot Juice 12908 | 86 86 | 490 | 540 | 2024-06-28 |
| 12909 | Cloudy Apple Juice 12909 | 86 86 | 490 | 540 | 2024-06-28 |
| 12910 | Cranberry Red Grapefruit Juice 12910 | 86 86 | 490 | 540 | 2024-06-28 |
| 12911 | Orange Juice 12911 | 86 86 | 490 | 540 | 2024-06-28 |
| 12912 | Evian 12912 | 86 86 | 350 | 400 | 2024-06-28 |
| 12913 | Sparkling Water 12913 | 86 86 | 450 | 500 | 2024-06-28 |
| 12914 | Chai Tea 12914 | 86 86 | 500 | 550 | 2024-06-28 |
| 12915 | Earl Grey Tea 12915 | 86 86 | 500 | 550 | 2024-06-28 |
| 12916 | English Breakfast Tea 12916 | 86 86 | 500 | 550 | 2024-06-28 |
| 12917 | Emperor’s Clouds & Mist™ Tea 12917 | 86 86 | 500 | 550 | 2024-06-28 |
| 12918 | Mint Blend Tea 12918 | 86 86 | 500 | 550 | 2024-06-28 |
| 12919 | Chamomile Tea 12919 | 86 86 | 500 | 550 | 2024-06-28 |
| 12920 | Pure Matcha Latte 12920 | 86 86 | 740 | 790 | 2024-06-28 |
| 12921 | Chai Tea Latte 12921 | 86 86 | 680 | 730 | 2024-06-28 |
| 12922 | Earl Grey Tea Latte 12922 | 86 86 | 680 | 730 | 2024-06-28 |
| 12923 | English Breakfast Tea Latte 12923 | 86 86 | 680 | 730 | 2024-06-28 |
| 12924 | Hojicha Tea Latte 12924 | 86 86 | 740 | 790 | 2024-06-28 |
| 12925 | Zen Clouds Oolong Tea 12925 | 86 86 | 500 | 550 | 2024-06-28 |
| 12926 | Zen Clouds Oolong with Ruby Grapefruit and Honey 12926 | 86 86 | 630 | 680 | 2024-06-28 |
| 12927 | Youthberry™ Tea 12927 | 86 86 | 500 | 550 | 2024-06-28 |
| 12928 | Iced Shaken Black Tea Lemonade 12928 | 86 86 | 610 | 660 | 2024-06-28 |
| 12929 | Iced Shaken Strawberry Black Tea Lemonade 12929 | 86 86 | 630 | 680 | 2024-06-28 |
| 12930 | Iced Shaken Hibiscus Tea Lemonade 12930 | 86 86 | 610 | 660 | 2024-06-28 |
| 12931 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 12931 | 86 86 | 730 | 780 | 2024-06-28 |
| 12932 | Iced Pure Matcha Latte 12932 | 86 86 | 740 | 790 | 2024-06-28 |
| 12933 | Iced Chai Tea Latte 12933 | 86 86 | 680 | 730 | 2024-06-28 |
| 12934 | Iced Black Tea Latte 12934 | 86 86 | 680 | 730 | 2024-06-28 |
| 12935 | Iced Hojicha Tea Latte 12935 | 86 86 | 740 | 790 | 2024-06-28 |
| 12936 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 12936 | 86 86 | 630 | 680 | 2024-06-28 |
| 12937 | Iced Shaken Zen Clouds Oolong Lemonade 12937 | 86 86 | 610 | 660 | 2024-06-28 |
| 12938 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 12938 | 86 86 | 630 | 680 | 2024-06-28 |
| 12939 | Origami Pike Place® Roast 12939 | 86 86 | 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");