item_prices
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
144 rows where effective_date = "2024-11-17"
This data as json, CSV (advanced)
Suggested facets: base_price, effective_date (date)
store_id >30
effective_date 1
- 2024-11-17 · 144 ✖
| id ▼ | item_id | store_id | base_price | delivery_price | effective_date |
|---|---|---|---|---|---|
| 37327 | Freshly Brewed Coffee 23031 | 23 23 | 390 | 50 | 2024-11-17 |
| 37328 | Freshly Brewed Coffee 23395 | 21 21 | 390 | 50 | 2024-11-17 |
| 37329 | Freshly Brewed Coffee 23577 | 20 20 | 350 | 50 | 2024-11-17 |
| 37330 | Freshly Brewed Coffee 23213 | 22 22 | 390 | 50 | 2024-11-17 |
| 37331 | Freshly Brewed Coffee 23761 | 19 19 | 390 | 50 | 2024-11-17 |
| 37332 | Freshly Brewed Coffee 23943 | 18 18 | 390 | 50 | 2024-11-17 |
| 37333 | Freshly Brewed Coffee 24125 | 17 17 | 390 | 50 | 2024-11-17 |
| 37334 | Freshly Brewed Coffee 24307 | 16 16 | 390 | 50 | 2024-11-17 |
| 37335 | Freshly Brewed Coffee 24489 | 15 15 | 350 | 50 | 2024-11-17 |
| 37336 | Freshly Brewed Coffee 24673 | 14 14 | 390 | 50 | 2024-11-17 |
| 37337 | Freshly Brewed Coffee 24855 | 11 11 | 390 | 50 | 2024-11-17 |
| 37338 | Freshly Brewed Coffee 25042 | 10 10 | 390 | 50 | 2024-11-17 |
| 37339 | Freshly Brewed Coffee 25230 | 9 9 | 390 | 50 | 2024-11-17 |
| 37340 | Freshly Brewed Coffee 25414 | 8 8 | 390 | 50 | 2024-11-17 |
| 37341 | Freshly Brewed Coffee 2522 | 148 148 | 470 | 50 | 2024-11-17 |
| 37342 | Freshly Brewed Coffee 2910 | 146 146 | 390 | 50 | 2024-11-17 |
| 37343 | Freshly Brewed Coffee 3092 | 145 145 | 420 | 50 | 2024-11-17 |
| 37344 | Freshly Brewed Coffee 3276 | 144 144 | 390 | 50 | 2024-11-17 |
| 37345 | Freshly Brewed Coffee 3458 | 143 143 | 390 | 50 | 2024-11-17 |
| 37346 | Freshly Brewed Coffee 2726 | 147 147 | 390 | 50 | 2024-11-17 |
| 37347 | Freshly Brewed Coffee 3640 | 142 142 | 390 | 50 | 2024-11-17 |
| 37348 | Freshly Brewed Coffee 3827 | 140 140 | 390 | 50 | 2024-11-17 |
| 37349 | Freshly Brewed Coffee 4015 | 139 139 | 390 | 50 | 2024-11-17 |
| 37350 | Freshly Brewed Coffee 4197 | 138 138 | 390 | 50 | 2024-11-17 |
| 37351 | Freshly Brewed Coffee 4379 | 137 137 | 390 | 50 | 2024-11-17 |
| 37352 | Freshly Brewed Coffee 2340 | 141 141 | 390 | 50 | 2024-11-17 |
| 37353 | Freshly Brewed Coffee 4561 | 136 136 | 420 | 50 | 2024-11-17 |
| 37354 | Freshly Brewed Coffee 4743 | 135 135 | 390 | 50 | 2024-11-17 |
| 37355 | Freshly Brewed Coffee 5107 | 133 133 | 390 | 50 | 2024-11-17 |
| 37356 | Freshly Brewed Coffee 5289 | 132 132 | 390 | 50 | 2024-11-17 |
| 37357 | Freshly Brewed Coffee 5471 | 131 131 | 390 | 50 | 2024-11-17 |
| 37358 | Freshly Brewed Coffee 5655 | 130 130 | 390 | 50 | 2024-11-17 |
| 37359 | Freshly Brewed Coffee 4925 | 134 134 | 390 | 50 | 2024-11-17 |
| 37360 | Freshly Brewed Coffee 5837 | 129 129 | 390 | 50 | 2024-11-17 |
| 37361 | Freshly Brewed Coffee 6019 | 128 128 | 390 | 50 | 2024-11-17 |
| 37362 | Freshly Brewed Coffee 6201 | 127 127 | 470 | 50 | 2024-11-17 |
| 37363 | Freshly Brewed Coffee 6383 | 126 126 | 390 | 50 | 2024-11-17 |
| 37364 | Freshly Brewed Coffee 6567 | 125 125 | 390 | 50 | 2024-11-17 |
| 37365 | Freshly Brewed Coffee 1794 | 124 124 | 390 | 50 | 2024-11-17 |
| 37366 | Freshly Brewed Coffee 1976 | 123 123 | 390 | 50 | 2024-11-17 |
| 37367 | Freshly Brewed Coffee 2158 | 122 122 | 390 | 50 | 2024-11-17 |
| 37368 | Freshly Brewed Coffee 6749 | 121 121 | 390 | 50 | 2024-11-17 |
| 37369 | Freshly Brewed Coffee 6931 | 120 120 | 390 | 50 | 2024-11-17 |
| 37370 | Freshly Brewed Coffee 7113 | 119 119 | 390 | 50 | 2024-11-17 |
| 37371 | Freshly Brewed Coffee 7295 | 118 118 | 390 | 50 | 2024-11-17 |
| 37372 | Freshly Brewed Coffee 7477 | 117 117 | 390 | 50 | 2024-11-17 |
| 37373 | Freshly Brewed Coffee 7841 | 115 115 | 390 | 50 | 2024-11-17 |
| 37374 | Freshly Brewed Coffee 8023 | 114 114 | 390 | 50 | 2024-11-17 |
| 37375 | Freshly Brewed Coffee 8205 | 113 113 | 390 | 50 | 2024-11-17 |
| 37376 | Freshly Brewed Coffee 8387 | 112 112 | 390 | 50 | 2024-11-17 |
| 37377 | Freshly Brewed Coffee 7659 | 116 116 | 390 | 50 | 2024-11-17 |
| 37378 | Freshly Brewed Coffee 8569 | 111 111 | 390 | 50 | 2024-11-17 |
| 37379 | Freshly Brewed Coffee 8751 | 110 110 | 390 | 50 | 2024-11-17 |
| 37380 | Freshly Brewed Coffee 8933 | 109 109 | 390 | 50 | 2024-11-17 |
| 37381 | Freshly Brewed Coffee 9115 | 108 108 | 390 | 50 | 2024-11-17 |
| 37382 | Freshly Brewed Coffee 9481 | 106 106 | 390 | 50 | 2024-11-17 |
| 37383 | Freshly Brewed Coffee 9297 | 107 107 | 390 | 50 | 2024-11-17 |
| 37384 | Freshly Brewed Coffee 9663 | 105 105 | 390 | 50 | 2024-11-17 |
| 37385 | Freshly Brewed Coffee 9845 | 104 104 | 390 | 50 | 2024-11-17 |
| 37386 | Freshly Brewed Coffee 1612 | 103 103 | 390 | 50 | 2024-11-17 |
| 37387 | Freshly Brewed Coffee 10027 | 102 102 | 390 | 50 | 2024-11-17 |
| 37388 | Freshly Brewed Coffee 10209 | 101 101 | 390 | 50 | 2024-11-17 |
| 37389 | Freshly Brewed Coffee 10391 | 100 100 | 390 | 50 | 2024-11-17 |
| 37390 | Freshly Brewed Coffee 10573 | 99 99 | 390 | 50 | 2024-11-17 |
| 37391 | Freshly Brewed Coffee 10755 | 98 98 | 390 | 50 | 2024-11-17 |
| 37392 | Freshly Brewed Coffee 10939 | 97 97 | 390 | 50 | 2024-11-17 |
| 37393 | Freshly Brewed Coffee 11121 | 96 96 | 390 | 50 | 2024-11-17 |
| 37394 | Freshly Brewed Coffee 11485 | 94 94 | 390 | 50 | 2024-11-17 |
| 37395 | Freshly Brewed Coffee 11303 | 95 95 | 390 | 50 | 2024-11-17 |
| 37396 | Freshly Brewed Coffee 11667 | 93 93 | 390 | 50 | 2024-11-17 |
| 37397 | Freshly Brewed Coffee 11849 | 92 92 | 390 | 50 | 2024-11-17 |
| 37398 | Freshly Brewed Coffee 12033 | 91 91 | 390 | 50 | 2024-11-17 |
| 37399 | Freshly Brewed Coffee 12217 | 90 90 | 390 | 50 | 2024-11-17 |
| 37400 | Freshly Brewed Coffee 12401 | 89 89 | 390 | 50 | 2024-11-17 |
| 37401 | Freshly Brewed Coffee 26166 | 149 149 | 350 | 50 | 2024-11-17 |
| 37402 | Freshly Brewed Coffee 12588 | 88 88 | 390 | 50 | 2024-11-17 |
| 37403 | Freshly Brewed Coffee 12783 | 87 87 | 390 | 50 | 2024-11-17 |
| 37404 | Freshly Brewed Coffee 12971 | 86 86 | 390 | 50 | 2024-11-17 |
| 37405 | Freshly Brewed Coffee 13153 | 85 85 | 470 | 50 | 2024-11-17 |
| 37406 | Freshly Brewed Coffee 13335 | 84 84 | 390 | 50 | 2024-11-17 |
| 37407 | Freshly Brewed Coffee 13517 | 83 83 | 390 | 50 | 2024-11-17 |
| 37408 | Freshly Brewed Coffee 1430 | 81 81 | 390 | 50 | 2024-11-17 |
| 37409 | Freshly Brewed Coffee 13699 | 80 80 | 470 | 50 | 2024-11-17 |
| 37410 | Freshly Brewed Coffee 13881 | 79 79 | 390 | 50 | 2024-11-17 |
| 37411 | Freshly Brewed Coffee 14065 | 78 78 | 390 | 50 | 2024-11-17 |
| 37412 | Freshly Brewed Coffee 14247 | 77 77 | 420 | 50 | 2024-11-17 |
| 37413 | Freshly Brewed Coffee 1248 | 75 75 | 390 | 50 | 2024-11-17 |
| 37414 | Freshly Brewed Coffee 32788 | 150 150 | 390 | 50 | 2024-11-17 |
| 37415 | Freshly Brewed Coffee 14431 | 74 74 | 390 | 50 | 2024-11-17 |
| 37416 | Freshly Brewed Coffee 14613 | 73 73 | 470 | 50 | 2024-11-17 |
| 37417 | Freshly Brewed Coffee 1066 | 76 76 | 390 | 50 | 2024-11-17 |
| 37418 | Freshly Brewed Coffee 14977 | 71 71 | 390 | 50 | 2024-11-17 |
| 37419 | Freshly Brewed Coffee 15159 | 70 70 | 390 | 50 | 2024-11-17 |
| 37420 | Freshly Brewed Coffee 862 | 69 69 | 390 | 50 | 2024-11-17 |
| 37421 | Freshly Brewed Coffee 14795 | 72 72 | 390 | 50 | 2024-11-17 |
| 37422 | Freshly Brewed Coffee 15716 | 66 66 | 390 | 50 | 2024-11-17 |
| 37423 | Freshly Brewed Coffee 15898 | 65 65 | 390 | 50 | 2024-11-17 |
| 37424 | Freshly Brewed Coffee 16080 | 64 64 | 390 | 50 | 2024-11-17 |
| 37425 | Freshly Brewed Coffee 16262 | 63 63 | 390 | 50 | 2024-11-17 |
| 37426 | Freshly Brewed Coffee 15341 | 68 68 | 390 | 50 | 2024-11-17 |
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");