item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
752 rows where effective_date = "2024-07-03"
This data as json, CSV (advanced)
Suggested facets: effective_date (date)
store_id >30
effective_date 1
- 2024-07-03 · 752 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 26035 | Cookie Crumble Cheesecake 22901 | 23 23 | 750 | 800 | 2024-07-03 |
| 26036 | Good Ol' NY Cheesecake 22902 | 23 23 | 750 | 800 | 2024-07-03 |
| 26037 | Signature Chocolate Cake 22903 | 23 23 | 750 | 800 | 2024-07-03 |
| 26038 | Strawberry Shortcake 22905 | 23 23 | 750 | 800 | 2024-07-03 |
| 26039 | Cookie Crumble Cheesecake 23083 | 22 22 | 750 | 800 | 2024-07-03 |
| 26040 | Good Ol' NY Cheesecake 23084 | 22 22 | 750 | 800 | 2024-07-03 |
| 26041 | Signature Chocolate Cake 23085 | 22 22 | 750 | 800 | 2024-07-03 |
| 26042 | Strawberry Shortcake 23087 | 22 22 | 750 | 800 | 2024-07-03 |
| 26043 | Cookie Crumble Cheesecake 23265 | 21 21 | 750 | 800 | 2024-07-03 |
| 26044 | Good Ol' NY Cheesecake 23266 | 21 21 | 750 | 800 | 2024-07-03 |
| 26045 | Signature Chocolate Cake 23267 | 21 21 | 750 | 800 | 2024-07-03 |
| 26046 | Strawberry Shortcake 23269 | 21 21 | 750 | 800 | 2024-07-03 |
| 26047 | Cookie Crumble Cheesecake 23447 | 20 20 | 670 | 720 | 2024-07-03 |
| 26048 | Good Ol' NY Cheesecake 23448 | 20 20 | 670 | 720 | 2024-07-03 |
| 26049 | Signature Chocolate Cake 23449 | 20 20 | 670 | 720 | 2024-07-03 |
| 26050 | Strawberry Shortcake 23451 | 20 20 | 670 | 720 | 2024-07-03 |
| 26051 | Cookie Crumble Cheesecake 23631 | 19 19 | 750 | 800 | 2024-07-03 |
| 26052 | Good Ol' NY Cheesecake 23632 | 19 19 | 750 | 800 | 2024-07-03 |
| 26053 | Signature Chocolate Cake 23633 | 19 19 | 750 | 800 | 2024-07-03 |
| 26054 | Strawberry Shortcake 23635 | 19 19 | 750 | 800 | 2024-07-03 |
| 26055 | Cookie Crumble Cheesecake 23813 | 18 18 | 750 | 800 | 2024-07-03 |
| 26056 | Good Ol' NY Cheesecake 23814 | 18 18 | 750 | 800 | 2024-07-03 |
| 26057 | Signature Chocolate Cake 23815 | 18 18 | 750 | 800 | 2024-07-03 |
| 26058 | Strawberry Shortcake 23817 | 18 18 | 750 | 800 | 2024-07-03 |
| 26059 | Cookie Crumble Cheesecake 23995 | 17 17 | 750 | 800 | 2024-07-03 |
| 26060 | Good Ol' NY Cheesecake 23996 | 17 17 | 750 | 800 | 2024-07-03 |
| 26061 | Signature Chocolate Cake 23997 | 17 17 | 750 | 800 | 2024-07-03 |
| 26062 | Strawberry Shortcake 23999 | 17 17 | 750 | 800 | 2024-07-03 |
| 26063 | Cookie Crumble Cheesecake 24177 | 16 16 | 750 | 800 | 2024-07-03 |
| 26064 | Good Ol' NY Cheesecake 24178 | 16 16 | 750 | 800 | 2024-07-03 |
| 26065 | Signature Chocolate Cake 24179 | 16 16 | 750 | 800 | 2024-07-03 |
| 26066 | Strawberry Shortcake 24181 | 16 16 | 750 | 800 | 2024-07-03 |
| 26067 | Cookie Crumble Cheesecake 24359 | 15 15 | 670 | 720 | 2024-07-03 |
| 26068 | Good Ol' NY Cheesecake 24360 | 15 15 | 670 | 720 | 2024-07-03 |
| 26069 | Signature Chocolate Cake 24361 | 15 15 | 670 | 720 | 2024-07-03 |
| 26070 | Strawberry Shortcake 24363 | 15 15 | 670 | 720 | 2024-07-03 |
| 26071 | Cookie Crumble Cheesecake 24543 | 14 14 | 750 | 800 | 2024-07-03 |
| 26072 | Good Ol' NY Cheesecake 24544 | 14 14 | 750 | 800 | 2024-07-03 |
| 26073 | Signature Chocolate Cake 24545 | 14 14 | 750 | 800 | 2024-07-03 |
| 26074 | Strawberry Shortcake 24547 | 14 14 | 750 | 800 | 2024-07-03 |
| 26075 | Cookie Crumble Cheesecake 24725 | 11 11 | 750 | 800 | 2024-07-03 |
| 26076 | Good Ol' NY Cheesecake 24726 | 11 11 | 750 | 800 | 2024-07-03 |
| 26077 | Signature Chocolate Cake 24727 | 11 11 | 750 | 800 | 2024-07-03 |
| 26078 | Strawberry Shortcake 24729 | 11 11 | 750 | 800 | 2024-07-03 |
| 26079 | Cookie Crumble Cheesecake 24907 | 10 10 | 750 | 800 | 2024-07-03 |
| 26080 | Good Ol' NY Cheesecake 24908 | 10 10 | 750 | 800 | 2024-07-03 |
| 26081 | Signature Chocolate Cake 24909 | 10 10 | 750 | 800 | 2024-07-03 |
| 26082 | Strawberry Shortcake 24911 | 10 10 | 750 | 800 | 2024-07-03 |
| 26083 | Cookie Crumble Cheesecake 25100 | 9 9 | 750 | 800 | 2024-07-03 |
| 26084 | Good Ol' NY Cheesecake 25101 | 9 9 | 750 | 800 | 2024-07-03 |
| 26085 | Signature Chocolate Cake 25102 | 9 9 | 750 | 800 | 2024-07-03 |
| 26086 | Strawberry Shortcake 25104 | 9 9 | 750 | 800 | 2024-07-03 |
| 26087 | Cookie Crumble Cheesecake 25284 | 8 8 | 750 | 800 | 2024-07-03 |
| 26088 | Good Ol' NY Cheesecake 25285 | 8 8 | 750 | 800 | 2024-07-03 |
| 26089 | Signature Chocolate Cake 25286 | 8 8 | 750 | 800 | 2024-07-03 |
| 26090 | Strawberry Shortcake 25288 | 8 8 | 750 | 800 | 2024-07-03 |
| 26091 | Cookie Crumble Cheesecake 2392 | 148 148 | 780 | 830 | 2024-07-03 |
| 26092 | Good Ol' NY Cheesecake 2393 | 148 148 | 780 | 830 | 2024-07-03 |
| 26093 | Signature Chocolate Cake 2394 | 148 148 | 780 | 830 | 2024-07-03 |
| 26094 | Strawberry Shortcake 2396 | 148 148 | 780 | 830 | 2024-07-03 |
| 26095 | Cookie Crumble Cheesecake 2596 | 147 147 | 750 | 800 | 2024-07-03 |
| 26096 | Good Ol' NY Cheesecake 2597 | 147 147 | 750 | 800 | 2024-07-03 |
| 26097 | Signature Chocolate Cake 2598 | 147 147 | 750 | 800 | 2024-07-03 |
| 26098 | Strawberry Shortcake 2600 | 147 147 | 750 | 800 | 2024-07-03 |
| 26099 | Cookie Crumble Cheesecake 2780 | 146 146 | 750 | 800 | 2024-07-03 |
| 26100 | Good Ol' NY Cheesecake 2781 | 146 146 | 750 | 800 | 2024-07-03 |
| 26101 | Signature Chocolate Cake 2782 | 146 146 | 750 | 800 | 2024-07-03 |
| 26102 | Strawberry Shortcake 2784 | 146 146 | 750 | 800 | 2024-07-03 |
| 26103 | Cookie Crumble Cheesecake 2962 | 145 145 | 750 | 800 | 2024-07-03 |
| 26104 | Good Ol' NY Cheesecake 2963 | 145 145 | 750 | 800 | 2024-07-03 |
| 26105 | Signature Chocolate Cake 2964 | 145 145 | 750 | 800 | 2024-07-03 |
| 26106 | Strawberry Shortcake 2966 | 145 145 | 750 | 800 | 2024-07-03 |
| 26107 | Cookie Crumble Cheesecake 3146 | 144 144 | 750 | 800 | 2024-07-03 |
| 26108 | Good Ol' NY Cheesecake 3147 | 144 144 | 750 | 800 | 2024-07-03 |
| 26109 | Signature Chocolate Cake 3148 | 144 144 | 750 | 800 | 2024-07-03 |
| 26110 | Strawberry Shortcake 3150 | 144 144 | 750 | 800 | 2024-07-03 |
| 26111 | Cookie Crumble Cheesecake 3328 | 143 143 | 750 | 800 | 2024-07-03 |
| 26112 | Good Ol' NY Cheesecake 3329 | 143 143 | 750 | 800 | 2024-07-03 |
| 26113 | Signature Chocolate Cake 3330 | 143 143 | 750 | 800 | 2024-07-03 |
| 26114 | Strawberry Shortcake 3332 | 143 143 | 750 | 800 | 2024-07-03 |
| 26115 | Cookie Crumble Cheesecake 3510 | 142 142 | 750 | 800 | 2024-07-03 |
| 26116 | Good Ol' NY Cheesecake 3511 | 142 142 | 750 | 800 | 2024-07-03 |
| 26117 | Signature Chocolate Cake 3512 | 142 142 | 750 | 800 | 2024-07-03 |
| 26118 | Strawberry Shortcake 3514 | 142 142 | 750 | 800 | 2024-07-03 |
| 26119 | Cookie Crumble Cheesecake 2210 | 141 141 | 750 | 800 | 2024-07-03 |
| 26120 | Good Ol' NY Cheesecake 2211 | 141 141 | 750 | 800 | 2024-07-03 |
| 26121 | Signature Chocolate Cake 2212 | 141 141 | 750 | 800 | 2024-07-03 |
| 26122 | Strawberry Shortcake 2214 | 141 141 | 750 | 800 | 2024-07-03 |
| 26123 | Cookie Crumble Cheesecake 3692 | 140 140 | 750 | 800 | 2024-07-03 |
| 26124 | Good Ol' NY Cheesecake 3693 | 140 140 | 750 | 800 | 2024-07-03 |
| 26125 | Signature Chocolate Cake 3694 | 140 140 | 750 | 800 | 2024-07-03 |
| 26126 | Strawberry Shortcake 3696 | 140 140 | 750 | 800 | 2024-07-03 |
| 26127 | Cookie Crumble Cheesecake 3885 | 139 139 | 750 | 800 | 2024-07-03 |
| 26128 | Good Ol' NY Cheesecake 3886 | 139 139 | 750 | 800 | 2024-07-03 |
| 26129 | Signature Chocolate Cake 3887 | 139 139 | 750 | 800 | 2024-07-03 |
| 26130 | Strawberry Shortcake 3889 | 139 139 | 750 | 800 | 2024-07-03 |
| 26131 | Cookie Crumble Cheesecake 4067 | 138 138 | 750 | 800 | 2024-07-03 |
| 26132 | Good Ol' NY Cheesecake 4068 | 138 138 | 750 | 800 | 2024-07-03 |
| 26133 | Signature Chocolate Cake 4069 | 138 138 | 750 | 800 | 2024-07-03 |
| 26134 | Strawberry Shortcake 4071 | 138 138 | 750 | 800 | 2024-07-03 |
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");