item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
234 rows where store_id = 76
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
- 76 · 234 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 935 | Bagel 935 | 76 76 | 400 | 430 | 2024-06-28 |
| 936 | Cookie Crumble Cheesecake 936 | 76 76 | 720 | 770 | 2024-06-28 |
| 937 | Good Ol' NY Cheesecake 937 | 76 76 | 720 | 770 | 2024-06-28 |
| 938 | Signature Chocolate Cake 938 | 76 76 | 720 | 770 | 2024-06-28 |
| 939 | Starbucks® Coffee Tiramisu Cake 939 | 76 76 | 750 | 800 | 2024-06-28 |
| 940 | Strawberry Shortcake 940 | 76 76 | 720 | 770 | 2024-06-28 |
| 941 | Chocolate Chunk Monster Cookie 941 | 76 76 | 390 | 440 | 2024-06-28 |
| 942 | Banana Walnut Muffin 942 | 76 76 | 450 | 500 | 2024-06-28 |
| 943 | Blueberry Crumble Muffin 943 | 76 76 | 450 | 500 | 2024-06-28 |
| 944 | Chocolate Crumble Muffin 944 | 76 76 | 450 | 500 | 2024-06-28 |
| 945 | Pancakes 945 | 76 76 | 550 | 600 | 2024-06-28 |
| 946 | Almond Croissant 946 | 76 76 | 470 | 520 | 2024-06-28 |
| 947 | Buttery Croissant 947 | 76 76 | 400 | 430 | 2024-06-28 |
| 948 | Chocolate Croissant 948 | 76 76 | 440 | 490 | 2024-06-28 |
| 949 | Creamy Chicken Foldover 949 | 76 76 | 550 | 600 | 2024-06-28 |
| 950 | Sausage Roll 950 | 76 76 | 550 | 600 | 2024-06-28 |
| 951 | Buttery Scone 951 | 76 76 | 400 | 430 | 2024-06-28 |
| 952 | Country Chicken Pie 952 | 76 76 | 690 | 740 | 2024-06-28 |
| 953 | Deep Dish Beef Pie 953 | 76 76 | 690 | 740 | 2024-06-28 |
| 954 | Spinach & Mushroom Quiche 954 | 76 76 | 690 | 740 | 2024-06-28 |
| 955 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 955 | 76 76 | 390 | 420 | 2024-06-28 |
| 956 | Mixed Nuts 956 | 76 76 | 490 | 540 | 2024-06-28 |
| 957 | Caramel Waffles 957 | 76 76 | 390 | 420 | 2024-06-28 |
| 958 | Chicken Ham & Cheese Panwich 958 | 76 76 | 690 | 740 | 2024-06-28 |
| 959 | Egg Mayo & Cheese Multigrain Croissant 959 | 76 76 | 690 | 740 | 2024-06-28 |
| 960 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 960 | 76 76 | 690 | 740 | 2024-06-28 |
| 961 | Rosemary Chicken & Emmental Cheese Croissant 961 | 76 76 | 690 | 740 | 2024-06-28 |
| 962 | Scrambled Egg & Turkey Ham Pita 962 | 76 76 | 690 | 740 | 2024-06-28 |
| 963 | Turkey Ham & Triple Cheese Toast 963 | 76 76 | 690 | 740 | 2024-06-28 |
| 964 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 964 | 76 76 | 790 | 840 | 2024-06-28 |
| 965 | Ham & Cheese Croissant 965 | 76 76 | 690 | 740 | 2024-06-28 |
| 966 | Sriracha Chicken Whole Wheat Pita 966 | 76 76 | 750 | 800 | 2024-06-28 |
| 967 | Blueberry Acai Yogurt Parfait 967 | 76 76 | 650 | 700 | 2024-06-28 |
| 968 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 968 | 76 76 | 650 | 700 | 2024-06-28 |
| 969 | Caramel Frappuccino® 969 | 76 76 | 720 | 770 | 2024-06-28 |
| 970 | Dark Mocha Frappuccino® 970 | 76 76 | 780 | 830 | 2024-06-28 |
| 971 | Java Chip Frappuccino® 971 | 76 76 | 780 | 830 | 2024-06-28 |
| 972 | Mocha Frappuccino® 972 | 76 76 | 720 | 770 | 2024-06-28 |
| 973 | Caramel Macchiato Frappuccino® 973 | 76 76 | 780 | 830 | 2024-06-28 |
| 974 | Espresso Frappuccino® 974 | 76 76 | 720 | 770 | 2024-06-28 |
| 975 | White Chocolate Mocha Frappuccino® 975 | 76 76 | 720 | 770 | 2024-06-28 |
| 976 | Chocolate Chip Cream Frappuccino® 976 | 76 76 | 780 | 830 | 2024-06-28 |
| 977 | Hojicha Tea Cream Frappuccino® 977 | 76 76 | 760 | 810 | 2024-06-28 |
| 978 | Vanilla Cream Frappuccino® 978 | 76 76 | 720 | 770 | 2024-06-28 |
| 979 | Mango Passion Fruit & Hibiscus 979 | 76 76 | 720 | 770 | 2024-06-28 |
| 980 | Raspberry Black Currant & Oolong 980 | 76 76 | 720 | 770 | 2024-06-28 |
| 981 | Coffee Traveller 981 | 76 76 | 3120 | 3170 | 2024-06-28 |
| 982 | Caffè Americano 982 | 76 76 | 540 | 590 | 2024-06-28 |
| 983 | Cappuccino 983 | 76 76 | 680 | 730 | 2024-06-28 |
| 984 | Caffè Mocha 984 | 76 76 | 750 | 800 | 2024-06-28 |
| 985 | Caramel Macchiato 985 | 76 76 | 760 | 810 | 2024-06-28 |
| 986 | Espresso 986 | 76 76 | 390 | 440 | 2024-06-28 |
| 987 | Caffè Latte 987 | 76 76 | 680 | 730 | 2024-06-28 |
| 988 | Oatmilk Latte 988 | 76 76 | 760 | 810 | 2024-06-28 |
| 989 | Vanilla Latte 989 | 76 76 | 750 | 800 | 2024-06-28 |
| 990 | White Chocolate Mocha 990 | 76 76 | 750 | 800 | 2024-06-28 |
| 991 | Flat White 991 | 76 76 | 760 | 810 | 2024-06-28 |
| 992 | Ristretto Bianco 992 | 76 76 | 760 | 810 | 2024-06-28 |
| 993 | Iced Caffè Americano 993 | 76 76 | 540 | 590 | 2024-06-28 |
| 994 | Iced Cappuccino 994 | 76 76 | 680 | 730 | 2024-06-28 |
| 995 | Iced Caffè Mocha 995 | 76 76 | 750 | 800 | 2024-06-28 |
| 996 | Iced Caramel Macchiato 996 | 76 76 | 760 | 810 | 2024-06-28 |
| 997 | Iced Caffè Latte 997 | 76 76 | 680 | 730 | 2024-06-28 |
| 998 | Iced Oatmilk Latte 998 | 76 76 | 760 | 810 | 2024-06-28 |
| 999 | Iced Vanilla Latte 999 | 76 76 | 750 | 800 | 2024-06-28 |
| 1000 | Iced White Chocolate Mocha 1000 | 76 76 | 750 | 800 | 2024-06-28 |
| 1001 | Signature Hot Chocolate 1001 | 76 76 | 720 | 770 | 2024-06-28 |
| 1002 | Signature Iced Chocolate 1002 | 76 76 | 720 | 770 | 2024-06-28 |
| 1003 | Carrot Juice 1003 | 76 76 | 490 | 540 | 2024-06-28 |
| 1004 | Cloudy Apple Juice 1004 | 76 76 | 490 | 540 | 2024-06-28 |
| 1005 | Cranberry Red Grapefruit Juice 1005 | 76 76 | 490 | 540 | 2024-06-28 |
| 1006 | Orange Juice 1006 | 76 76 | 490 | 540 | 2024-06-28 |
| 1007 | Evian 1007 | 76 76 | 350 | 400 | 2024-06-28 |
| 1008 | Sparkling Water 1008 | 76 76 | 450 | 500 | 2024-06-28 |
| 1009 | Chai Tea 1009 | 76 76 | 500 | 550 | 2024-06-28 |
| 1010 | Earl Grey Tea 1010 | 76 76 | 500 | 550 | 2024-06-28 |
| 1011 | English Breakfast Tea 1011 | 76 76 | 500 | 550 | 2024-06-28 |
| 1012 | Emperor’s Clouds & Mist™ Tea 1012 | 76 76 | 500 | 550 | 2024-06-28 |
| 1013 | Mint Blend Tea 1013 | 76 76 | 500 | 550 | 2024-06-28 |
| 1014 | Chamomile Tea 1014 | 76 76 | 500 | 550 | 2024-06-28 |
| 1015 | Pure Matcha Latte 1015 | 76 76 | 740 | 790 | 2024-06-28 |
| 1016 | Chai Tea Latte 1016 | 76 76 | 680 | 730 | 2024-06-28 |
| 1017 | Earl Grey Tea Latte 1017 | 76 76 | 680 | 730 | 2024-06-28 |
| 1018 | English Breakfast Tea Latte 1018 | 76 76 | 680 | 730 | 2024-06-28 |
| 1019 | Hojicha Tea Latte 1019 | 76 76 | 740 | 790 | 2024-06-28 |
| 1020 | Zen Clouds Oolong Tea 1020 | 76 76 | 500 | 550 | 2024-06-28 |
| 1021 | Zen Clouds Oolong with Ruby Grapefruit and Honey 1021 | 76 76 | 630 | 680 | 2024-06-28 |
| 1022 | Youthberry™ Tea 1022 | 76 76 | 500 | 550 | 2024-06-28 |
| 1023 | Iced Shaken Black Tea Lemonade 1023 | 76 76 | 610 | 660 | 2024-06-28 |
| 1024 | Iced Shaken Strawberry Black Tea Lemonade 1024 | 76 76 | 630 | 680 | 2024-06-28 |
| 1025 | Iced Shaken Hibiscus Tea Lemonade 1025 | 76 76 | 610 | 660 | 2024-06-28 |
| 1026 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 1026 | 76 76 | 730 | 780 | 2024-06-28 |
| 1027 | Iced Pure Matcha Latte 1027 | 76 76 | 740 | 790 | 2024-06-28 |
| 1028 | Iced Chai Tea Latte 1028 | 76 76 | 680 | 730 | 2024-06-28 |
| 1029 | Iced Black Tea Latte 1029 | 76 76 | 680 | 730 | 2024-06-28 |
| 1030 | Iced Hojicha Tea Latte 1030 | 76 76 | 740 | 790 | 2024-06-28 |
| 1031 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 1031 | 76 76 | 630 | 680 | 2024-06-28 |
| 1032 | Iced Shaken Zen Clouds Oolong Lemonade 1032 | 76 76 | 610 | 660 | 2024-06-28 |
| 1033 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 1033 | 76 76 | 630 | 680 | 2024-06-28 |
| 1034 | Origami Pike Place® Roast 1034 | 76 76 | 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");