item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
249 rows where store_id = 122
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 13
- 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
- 2024-11-17 1
store_id 1
- 122 · 249 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 2027 | Bagel 2027 | 122 122 | 400 | 430 | 2024-06-28 |
| 2028 | Cookie Crumble Cheesecake 2028 | 122 122 | 720 | 770 | 2024-06-28 |
| 2029 | Good Ol' NY Cheesecake 2029 | 122 122 | 720 | 770 | 2024-06-28 |
| 2030 | Signature Chocolate Cake 2030 | 122 122 | 720 | 770 | 2024-06-28 |
| 2031 | Starbucks® Coffee Tiramisu Cake 2031 | 122 122 | 750 | 800 | 2024-06-28 |
| 2032 | Strawberry Shortcake 2032 | 122 122 | 720 | 770 | 2024-06-28 |
| 2033 | Chocolate Chunk Monster Cookie 2033 | 122 122 | 390 | 440 | 2024-06-28 |
| 2034 | Banana Walnut Muffin 2034 | 122 122 | 450 | 500 | 2024-06-28 |
| 2035 | Blueberry Crumble Muffin 2035 | 122 122 | 450 | 500 | 2024-06-28 |
| 2036 | Chocolate Crumble Muffin 2036 | 122 122 | 450 | 500 | 2024-06-28 |
| 2037 | Pancakes 2037 | 122 122 | 550 | 600 | 2024-06-28 |
| 2038 | Almond Croissant 2038 | 122 122 | 470 | 520 | 2024-06-28 |
| 2039 | Buttery Croissant 2039 | 122 122 | 400 | 430 | 2024-06-28 |
| 2040 | Chocolate Croissant 2040 | 122 122 | 440 | 490 | 2024-06-28 |
| 2041 | Creamy Chicken Foldover 2041 | 122 122 | 550 | 600 | 2024-06-28 |
| 2042 | Sausage Roll 2042 | 122 122 | 550 | 600 | 2024-06-28 |
| 2043 | Buttery Scone 2043 | 122 122 | 400 | 430 | 2024-06-28 |
| 2044 | Country Chicken Pie 2044 | 122 122 | 690 | 740 | 2024-06-28 |
| 2045 | Deep Dish Beef Pie 2045 | 122 122 | 690 | 740 | 2024-06-28 |
| 2046 | Spinach & Mushroom Quiche 2046 | 122 122 | 690 | 740 | 2024-06-28 |
| 2047 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 2047 | 122 122 | 390 | 420 | 2024-06-28 |
| 2048 | Mixed Nuts 2048 | 122 122 | 490 | 540 | 2024-06-28 |
| 2049 | Caramel Waffles 2049 | 122 122 | 390 | 420 | 2024-06-28 |
| 2050 | Chicken Ham & Cheese Panwich 2050 | 122 122 | 690 | 740 | 2024-06-28 |
| 2051 | Egg Mayo & Cheese Multigrain Croissant 2051 | 122 122 | 690 | 740 | 2024-06-28 |
| 2052 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 2052 | 122 122 | 690 | 740 | 2024-06-28 |
| 2053 | Rosemary Chicken & Emmental Cheese Croissant 2053 | 122 122 | 690 | 740 | 2024-06-28 |
| 2054 | Scrambled Egg & Turkey Ham Pita 2054 | 122 122 | 690 | 740 | 2024-06-28 |
| 2055 | Turkey Ham & Triple Cheese Toast 2055 | 122 122 | 690 | 740 | 2024-06-28 |
| 2056 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 2056 | 122 122 | 790 | 840 | 2024-06-28 |
| 2057 | Ham & Cheese Croissant 2057 | 122 122 | 690 | 740 | 2024-06-28 |
| 2058 | Sriracha Chicken Whole Wheat Pita 2058 | 122 122 | 750 | 800 | 2024-06-28 |
| 2059 | Blueberry Acai Yogurt Parfait 2059 | 122 122 | 650 | 700 | 2024-06-28 |
| 2060 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 2060 | 122 122 | 650 | 700 | 2024-06-28 |
| 2061 | Caramel Frappuccino® 2061 | 122 122 | 720 | 770 | 2024-06-28 |
| 2062 | Dark Mocha Frappuccino® 2062 | 122 122 | 780 | 830 | 2024-06-28 |
| 2063 | Java Chip Frappuccino® 2063 | 122 122 | 780 | 830 | 2024-06-28 |
| 2064 | Mocha Frappuccino® 2064 | 122 122 | 720 | 770 | 2024-06-28 |
| 2065 | Caramel Macchiato Frappuccino® 2065 | 122 122 | 780 | 830 | 2024-06-28 |
| 2066 | Espresso Frappuccino® 2066 | 122 122 | 720 | 770 | 2024-06-28 |
| 2067 | White Chocolate Mocha Frappuccino® 2067 | 122 122 | 720 | 770 | 2024-06-28 |
| 2068 | Chocolate Chip Cream Frappuccino® 2068 | 122 122 | 780 | 830 | 2024-06-28 |
| 2069 | Hojicha Tea Cream Frappuccino® 2069 | 122 122 | 760 | 810 | 2024-06-28 |
| 2070 | Vanilla Cream Frappuccino® 2070 | 122 122 | 720 | 770 | 2024-06-28 |
| 2071 | Mango Passion Fruit & Hibiscus 2071 | 122 122 | 720 | 770 | 2024-06-28 |
| 2072 | Raspberry Black Currant & Oolong 2072 | 122 122 | 720 | 770 | 2024-06-28 |
| 2073 | Coffee Traveller 2073 | 122 122 | 3120 | 3170 | 2024-06-28 |
| 2074 | Caffè Americano 2074 | 122 122 | 540 | 590 | 2024-06-28 |
| 2075 | Cappuccino 2075 | 122 122 | 680 | 730 | 2024-06-28 |
| 2076 | Caffè Mocha 2076 | 122 122 | 750 | 800 | 2024-06-28 |
| 2077 | Caramel Macchiato 2077 | 122 122 | 760 | 810 | 2024-06-28 |
| 2078 | Espresso 2078 | 122 122 | 390 | 440 | 2024-06-28 |
| 2079 | Caffè Latte 2079 | 122 122 | 680 | 730 | 2024-06-28 |
| 2080 | Oatmilk Latte 2080 | 122 122 | 760 | 810 | 2024-06-28 |
| 2081 | Vanilla Latte 2081 | 122 122 | 750 | 800 | 2024-06-28 |
| 2082 | White Chocolate Mocha 2082 | 122 122 | 750 | 800 | 2024-06-28 |
| 2083 | Flat White 2083 | 122 122 | 760 | 810 | 2024-06-28 |
| 2084 | Ristretto Bianco 2084 | 122 122 | 760 | 810 | 2024-06-28 |
| 2085 | Iced Caffè Americano 2085 | 122 122 | 540 | 590 | 2024-06-28 |
| 2086 | Iced Cappuccino 2086 | 122 122 | 680 | 730 | 2024-06-28 |
| 2087 | Iced Caffè Mocha 2087 | 122 122 | 750 | 800 | 2024-06-28 |
| 2088 | Iced Caramel Macchiato 2088 | 122 122 | 760 | 810 | 2024-06-28 |
| 2089 | Iced Caffè Latte 2089 | 122 122 | 680 | 730 | 2024-06-28 |
| 2090 | Iced Oatmilk Latte 2090 | 122 122 | 760 | 810 | 2024-06-28 |
| 2091 | Iced Vanilla Latte 2091 | 122 122 | 750 | 800 | 2024-06-28 |
| 2092 | Iced White Chocolate Mocha 2092 | 122 122 | 750 | 800 | 2024-06-28 |
| 2093 | Signature Hot Chocolate 2093 | 122 122 | 720 | 770 | 2024-06-28 |
| 2094 | Signature Iced Chocolate 2094 | 122 122 | 720 | 770 | 2024-06-28 |
| 2095 | Carrot Juice 2095 | 122 122 | 490 | 540 | 2024-06-28 |
| 2096 | Cloudy Apple Juice 2096 | 122 122 | 490 | 540 | 2024-06-28 |
| 2097 | Cranberry Red Grapefruit Juice 2097 | 122 122 | 490 | 540 | 2024-06-28 |
| 2098 | Orange Juice 2098 | 122 122 | 490 | 540 | 2024-06-28 |
| 2099 | Evian 2099 | 122 122 | 350 | 400 | 2024-06-28 |
| 2100 | Sparkling Water 2100 | 122 122 | 450 | 500 | 2024-06-28 |
| 2101 | Chai Tea 2101 | 122 122 | 500 | 550 | 2024-06-28 |
| 2102 | Earl Grey Tea 2102 | 122 122 | 500 | 550 | 2024-06-28 |
| 2103 | English Breakfast Tea 2103 | 122 122 | 500 | 550 | 2024-06-28 |
| 2104 | Emperor’s Clouds & Mist™ Tea 2104 | 122 122 | 500 | 550 | 2024-06-28 |
| 2105 | Mint Blend Tea 2105 | 122 122 | 500 | 550 | 2024-06-28 |
| 2106 | Chamomile Tea 2106 | 122 122 | 500 | 550 | 2024-06-28 |
| 2107 | Pure Matcha Latte 2107 | 122 122 | 740 | 790 | 2024-06-28 |
| 2108 | Chai Tea Latte 2108 | 122 122 | 680 | 730 | 2024-06-28 |
| 2109 | Earl Grey Tea Latte 2109 | 122 122 | 680 | 730 | 2024-06-28 |
| 2110 | English Breakfast Tea Latte 2110 | 122 122 | 680 | 730 | 2024-06-28 |
| 2111 | Hojicha Tea Latte 2111 | 122 122 | 740 | 790 | 2024-06-28 |
| 2112 | Zen Clouds Oolong Tea 2112 | 122 122 | 500 | 550 | 2024-06-28 |
| 2113 | Zen Clouds Oolong with Ruby Grapefruit and Honey 2113 | 122 122 | 630 | 680 | 2024-06-28 |
| 2114 | Youthberry™ Tea 2114 | 122 122 | 500 | 550 | 2024-06-28 |
| 2115 | Iced Shaken Black Tea Lemonade 2115 | 122 122 | 610 | 660 | 2024-06-28 |
| 2116 | Iced Shaken Strawberry Black Tea Lemonade 2116 | 122 122 | 630 | 680 | 2024-06-28 |
| 2117 | Iced Shaken Hibiscus Tea Lemonade 2117 | 122 122 | 610 | 660 | 2024-06-28 |
| 2118 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 2118 | 122 122 | 730 | 780 | 2024-06-28 |
| 2119 | Iced Pure Matcha Latte 2119 | 122 122 | 740 | 790 | 2024-06-28 |
| 2120 | Iced Chai Tea Latte 2120 | 122 122 | 680 | 730 | 2024-06-28 |
| 2121 | Iced Black Tea Latte 2121 | 122 122 | 680 | 730 | 2024-06-28 |
| 2122 | Iced Hojicha Tea Latte 2122 | 122 122 | 740 | 790 | 2024-06-28 |
| 2123 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 2123 | 122 122 | 630 | 680 | 2024-06-28 |
| 2124 | Iced Shaken Zen Clouds Oolong Lemonade 2124 | 122 122 | 610 | 660 | 2024-06-28 |
| 2125 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 2125 | 122 122 | 630 | 680 | 2024-06-28 |
| 2126 | Origami Pike Place® Roast 2126 | 122 122 | 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");