item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
337 rows where store_id = 127
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
effective_date 13
- 2024-06-28 182
- 2024-11-10 102
- 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
- 127 · 337 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 6070 | Bagel 6070 | 127 127 | 430 | 460 | 2024-06-28 |
| 6071 | Cookie Crumble Cheesecake 6071 | 127 127 | 750 | 800 | 2024-06-28 |
| 6072 | Good Ol' NY Cheesecake 6072 | 127 127 | 750 | 800 | 2024-06-28 |
| 6073 | Signature Chocolate Cake 6073 | 127 127 | 750 | 800 | 2024-06-28 |
| 6074 | Starbucks® Coffee Tiramisu Cake 6074 | 127 127 | 780 | 830 | 2024-06-28 |
| 6075 | Strawberry Shortcake 6075 | 127 127 | 750 | 800 | 2024-06-28 |
| 6076 | Chocolate Chunk Monster Cookie 6076 | 127 127 | 420 | 470 | 2024-06-28 |
| 6077 | Banana Walnut Muffin 6077 | 127 127 | 480 | 530 | 2024-06-28 |
| 6078 | Blueberry Crumble Muffin 6078 | 127 127 | 480 | 530 | 2024-06-28 |
| 6079 | Chocolate Crumble Muffin 6079 | 127 127 | 480 | 530 | 2024-06-28 |
| 6080 | Pancakes 6080 | 127 127 | 580 | 630 | 2024-06-28 |
| 6081 | Almond Croissant 6081 | 127 127 | 500 | 550 | 2024-06-28 |
| 6082 | Buttery Croissant 6082 | 127 127 | 430 | 460 | 2024-06-28 |
| 6083 | Chocolate Croissant 6083 | 127 127 | 470 | 520 | 2024-06-28 |
| 6084 | Creamy Chicken Foldover 6084 | 127 127 | 580 | 630 | 2024-06-28 |
| 6085 | Sausage Roll 6085 | 127 127 | 580 | 630 | 2024-06-28 |
| 6086 | Buttery Scone 6086 | 127 127 | 430 | 460 | 2024-06-28 |
| 6087 | Country Chicken Pie 6087 | 127 127 | 720 | 770 | 2024-06-28 |
| 6088 | Deep Dish Beef Pie 6088 | 127 127 | 720 | 770 | 2024-06-28 |
| 6089 | Spinach & Mushroom Quiche 6089 | 127 127 | 720 | 770 | 2024-06-28 |
| 6090 | BE-KIND™ Dark Chocolate Nuts & Sea Salt Bar 6090 | 127 127 | 420 | 450 | 2024-06-28 |
| 6091 | Mixed Nuts 6091 | 127 127 | 520 | 570 | 2024-06-28 |
| 6092 | Caramel Waffles 6092 | 127 127 | 420 | 450 | 2024-06-28 |
| 6093 | Chicken Ham & Cheese Panwich 6093 | 127 127 | 720 | 770 | 2024-06-28 |
| 6094 | Egg Mayo & Cheese Multigrain Croissant 6094 | 127 127 | 720 | 770 | 2024-06-28 |
| 6095 | Egg White, Roasted Pepper, Mushroom & Cheddar Wrap 6095 | 127 127 | 720 | 770 | 2024-06-28 |
| 6096 | Rosemary Chicken & Emmental Cheese Croissant 6096 | 127 127 | 720 | 770 | 2024-06-28 |
| 6097 | Scrambled Egg & Turkey Ham Pita 6097 | 127 127 | 720 | 770 | 2024-06-28 |
| 6098 | Turkey Ham & Triple Cheese Toast 6098 | 127 127 | 720 | 770 | 2024-06-28 |
| 6099 | Meatless Beef, Avocado Omelette, Mushroom & Cheese Wrap 6099 | 127 127 | 820 | 870 | 2024-06-28 |
| 6100 | Ham & Cheese Croissant 6100 | 127 127 | 720 | 770 | 2024-06-28 |
| 6101 | Sriracha Chicken Whole Wheat Pita 6101 | 127 127 | 780 | 830 | 2024-06-28 |
| 6102 | Blueberry Acai Yogurt Parfait 6102 | 127 127 | 680 | 730 | 2024-06-28 |
| 6103 | Peanut Butter Chia Seed Yogurt Parfait with Chocolate & Vanilla Granola 6103 | 127 127 | 680 | 730 | 2024-06-28 |
| 6104 | Caramel Frappuccino® 6104 | 127 127 | 780 | 830 | 2024-06-28 |
| 6105 | Dark Mocha Frappuccino® 6105 | 127 127 | 840 | 890 | 2024-06-28 |
| 6106 | Java Chip Frappuccino® 6106 | 127 127 | 840 | 890 | 2024-06-28 |
| 6107 | Mocha Frappuccino® 6107 | 127 127 | 780 | 830 | 2024-06-28 |
| 6108 | Caramel Macchiato Frappuccino® 6108 | 127 127 | 840 | 890 | 2024-06-28 |
| 6109 | Espresso Frappuccino® 6109 | 127 127 | 780 | 830 | 2024-06-28 |
| 6110 | White Chocolate Mocha Frappuccino® 6110 | 127 127 | 780 | 830 | 2024-06-28 |
| 6111 | Chocolate Chip Cream Frappuccino® 6111 | 127 127 | 840 | 890 | 2024-06-28 |
| 6112 | Hojicha Tea Cream Frappuccino® 6112 | 127 127 | 820 | 870 | 2024-06-28 |
| 6113 | Vanilla Cream Frappuccino® 6113 | 127 127 | 780 | 830 | 2024-06-28 |
| 6114 | Mango Passion Fruit & Hibiscus 6114 | 127 127 | 780 | 830 | 2024-06-28 |
| 6115 | Raspberry Black Currant & Oolong 6115 | 127 127 | 780 | 830 | 2024-06-28 |
| 6116 | Coffee Traveller 6116 | 127 127 | 3600 | 3650 | 2024-06-28 |
| 6117 | Caffè Americano 6117 | 127 127 | 600 | 650 | 2024-06-28 |
| 6118 | Cappuccino 6118 | 127 127 | 740 | 790 | 2024-06-28 |
| 6119 | Caffè Mocha 6119 | 127 127 | 830 | 880 | 2024-06-28 |
| 6120 | Caramel Macchiato 6120 | 127 127 | 840 | 890 | 2024-06-28 |
| 6121 | Espresso 6121 | 127 127 | 450 | 500 | 2024-06-28 |
| 6122 | Caffè Latte 6122 | 127 127 | 740 | 790 | 2024-06-28 |
| 6123 | Oatmilk Latte 6123 | 127 127 | 850 | 900 | 2024-06-28 |
| 6124 | Vanilla Latte 6124 | 127 127 | 830 | 880 | 2024-06-28 |
| 6125 | White Chocolate Mocha 6125 | 127 127 | 830 | 880 | 2024-06-28 |
| 6126 | Flat White 6126 | 127 127 | 840 | 890 | 2024-06-28 |
| 6127 | Ristretto Bianco 6127 | 127 127 | 840 | 890 | 2024-06-28 |
| 6128 | Iced Caffè Americano 6128 | 127 127 | 600 | 650 | 2024-06-28 |
| 6129 | Iced Cappuccino 6129 | 127 127 | 740 | 790 | 2024-06-28 |
| 6130 | Iced Caffè Mocha 6130 | 127 127 | 830 | 880 | 2024-06-28 |
| 6131 | Iced Caramel Macchiato 6131 | 127 127 | 840 | 890 | 2024-06-28 |
| 6132 | Iced Caffè Latte 6132 | 127 127 | 740 | 790 | 2024-06-28 |
| 6133 | Iced Oatmilk Latte 6133 | 127 127 | 850 | 900 | 2024-06-28 |
| 6134 | Iced Vanilla Latte 6134 | 127 127 | 830 | 880 | 2024-06-28 |
| 6135 | Iced White Chocolate Mocha 6135 | 127 127 | 830 | 880 | 2024-06-28 |
| 6136 | Signature Hot Chocolate 6136 | 127 127 | 780 | 830 | 2024-06-28 |
| 6137 | Signature Iced Chocolate 6137 | 127 127 | 780 | 830 | 2024-06-28 |
| 6138 | Carrot Juice 6138 | 127 127 | 550 | 600 | 2024-06-28 |
| 6139 | Cloudy Apple Juice 6139 | 127 127 | 550 | 600 | 2024-06-28 |
| 6140 | Cranberry Red Grapefruit Juice 6140 | 127 127 | 550 | 600 | 2024-06-28 |
| 6141 | Orange Juice 6141 | 127 127 | 550 | 600 | 2024-06-28 |
| 6142 | Evian 6142 | 127 127 | 410 | 460 | 2024-06-28 |
| 6143 | Sparkling Water 6143 | 127 127 | 510 | 560 | 2024-06-28 |
| 6144 | Chai Tea 6144 | 127 127 | 560 | 610 | 2024-06-28 |
| 6145 | Earl Grey Tea 6145 | 127 127 | 560 | 610 | 2024-06-28 |
| 6146 | English Breakfast Tea 6146 | 127 127 | 560 | 610 | 2024-06-28 |
| 6147 | Emperor’s Clouds & Mist™ Tea 6147 | 127 127 | 560 | 610 | 2024-06-28 |
| 6148 | Mint Blend Tea 6148 | 127 127 | 560 | 610 | 2024-06-28 |
| 6149 | Chamomile Tea 6149 | 127 127 | 560 | 610 | 2024-06-28 |
| 6150 | Pure Matcha Latte 6150 | 127 127 | 810 | 860 | 2024-06-28 |
| 6151 | Chai Tea Latte 6151 | 127 127 | 740 | 790 | 2024-06-28 |
| 6152 | Earl Grey Tea Latte 6152 | 127 127 | 740 | 790 | 2024-06-28 |
| 6153 | English Breakfast Tea Latte 6153 | 127 127 | 740 | 790 | 2024-06-28 |
| 6154 | Hojicha Tea Latte 6154 | 127 127 | 810 | 860 | 2024-06-28 |
| 6155 | Zen Clouds Oolong Tea 6155 | 127 127 | 560 | 610 | 2024-06-28 |
| 6156 | Zen Clouds Oolong with Ruby Grapefruit and Honey 6156 | 127 127 | 690 | 740 | 2024-06-28 |
| 6157 | Youthberry™ Tea 6157 | 127 127 | 560 | 610 | 2024-06-28 |
| 6158 | Iced Shaken Black Tea Lemonade 6158 | 127 127 | 670 | 720 | 2024-06-28 |
| 6159 | Iced Shaken Strawberry Black Tea Lemonade 6159 | 127 127 | 690 | 740 | 2024-06-28 |
| 6160 | Iced Shaken Hibiscus Tea Lemonade 6160 | 127 127 | 670 | 720 | 2024-06-28 |
| 6161 | Iced Shaken Hibiscus Tea with Pomegranate Pearls 6161 | 127 127 | 790 | 840 | 2024-06-28 |
| 6162 | Iced Pure Matcha Latte 6162 | 127 127 | 810 | 860 | 2024-06-28 |
| 6163 | Iced Chai Tea Latte 6163 | 127 127 | 740 | 790 | 2024-06-28 |
| 6164 | Iced Black Tea Latte 6164 | 127 127 | 740 | 790 | 2024-06-28 |
| 6165 | Iced Hojicha Tea Latte 6165 | 127 127 | 810 | 860 | 2024-06-28 |
| 6166 | Iced Zen Clouds Oolong with Ruby Grapefruit and Honey 6166 | 127 127 | 690 | 740 | 2024-06-28 |
| 6167 | Iced Shaken Zen Clouds Oolong Lemonade 6167 | 127 127 | 670 | 720 | 2024-06-28 |
| 6168 | Iced Shaken Strawberry Zen Clouds Oolong Lemonade 6168 | 127 127 | 690 | 740 | 2024-06-28 |
| 6169 | Origami Pike Place® Roast 6169 | 127 127 | 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");