menu_items
Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com
26 rows where is_delivery = 0, is_featured = 0 and store_id = 3
This data as json, CSV (advanced)
Suggested facets: description, is_inventoried, photo_urls (array)
id ▼ | store_id | item_id | item_code | name | description | photo_urls | is_mobile_order_pay | is_delivery | is_inventoried | is_featured | is_scheduled | is_dine_in |
---|---|---|---|---|---|---|---|---|---|---|---|---|
25515 | 3 3 | 103 | Cappuccino | Dark, rich espresso lies in wait under a smoothed and stretched layer of thick foam. It's truly the height of our baristas' craft. | ["https://static.sbux.mobi/images/mop/20231226/c64b8126-90a1-4b98-b3d0-84a5505787b8/app 1080 cappuccino c0.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 | |
25518 | 3 3 | 106 | Espresso | Our smooth signature Espresso Roast with rich flavor and caramelly sweetness is at the very heart of everything we do. Drinks endorsed no added sugar by Health Promotion Board. | ["https://static.sbux.mobi/images/mop/20231226/5ab5f36d-b44a-4f82-83aa-f14fadb6412e/app 1080 espresso a0.jpg"] | 0 | 0 | 0 | 0 | 0 | 1 | |
25526 | 3 3 | 120 | Iced Cappuccino | With less milk than a latte, Iced Cappuccino offers a stronger espresso flavor, a luxurious texture and a velvety, frothy foam with a crisp, cool undercurrent. | ["https://static.sbux.mobi/images/mop/20231226/ba5f0e66-c2cf-4693-a533-db72457d79b4/app 1080 iced cappuccino c0.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 | |
25535 | 3 3 | 141 | 4500550043 | Carrot Juice | Bottled Carrot Juice, available in 350 ml. | ["https://static.sbux.mobi/images/mop/20231228/ab7ec021-2ef2-4929-9671-20c2e46551df/carrot-juice_1080x1080.jpg"] | 1 | 0 | 1 | 0 | 1 | 1 |
25536 | 3 3 | 142 | 4500550042 | Cloudy Apple Juice | Bottled Cloudy Apple juice, available in 350 ml. | ["https://static.sbux.mobi/images/mop/20231227/a3a34caf-3da9-44da-b7a1-10cea385af79/cloudy-apple-juice_1080x1080.jpg"] | 1 | 0 | 1 | 0 | 1 | 1 |
25537 | 3 3 | 143 | 4500550130 | Cranberry Red Grapefruit Juice | Bottled Cranberry Red Grapefruit juice, available in 350 ml. | ["https://static.sbux.mobi/images/mop/20231227/e57d7c49-9cd7-41ea-a65b-d604940486c8/cranberry-red-grapefruit-juice_1080x1080.jpg"] | 1 | 0 | 1 | 0 | 1 | 1 |
25538 | 3 3 | 144 | 4500550041 | Orange Juice | Bottled Orange juice, available in 350 ml. | ["https://static.sbux.mobi/images/mop/20231227/f4c35f2e-0486-4f19-aa16-a42cae4a5218/orange-juice_1080x1080.jpg"] | 1 | 0 | 1 | 0 | 1 | 1 |
25561 | 3 3 | 178 | Iced Black Tea Latte | Black tea with cocoa undertones combined with milk for comforting sips. | ["https://static.sbux.mobi/images/mop/20240102/bf47ef30-3435-494b-9d4e-8c6acb6f24b1/app 1080 iced black tea latte b4.jpg"] | 0 | 0 | 0 | 0 | 1 | 1 | |
25603 | 3 3 | 285 | Starbucks Reserve™ Cappuccino | Exclusive Starbucks Reserve™ espresso with dense, creamy foamed milk. | ["https://static.sbux.mobi/images/mop/20231226/9fb77523-e951-49a0-a0b6-bd3bb0e1f1e3/app reserve cappuccino c0.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 | |
25605 | 3 3 | 287 | Starbucks Reserve™ Espresso | Freshly pulled Starbucks Reserve™ espresso. | ["https://static.sbux.mobi/images/mop/20231226/4ecad45a-79a5-4567-8e06-b4db9bfb1a1d/app reserve espresso a0.jpg"] | 0 | 0 | 0 | 0 | 0 | 1 | |
25607 | 3 3 | 291 | Starbucks Reserve™ Piccolo Latte | Each cup is made with a modest serving of milk with extra bold small-lot Starbucks Reserve™ ristretto shots - the most concentrated form of espresso. | ["https://static.sbux.mobi/images/mop/20231226/9be49ae8-94c3-4592-bc00-ad2ac75d694e/app reserve piccolo latte c0.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 | |
25609 | 3 3 | 294 | Starbucks Reserve™ Classic Affogato | Kick back with a scoop of creamy vanilla ice cream served with a shot of Starbucks Reserve™ espresso. | ["https://static.sbux.mobi/images/mop/20231226/45bf6268-d5b6-44d1-b216-1f04f6732293/app reserve classic affogato d11.jpg"] | 0 | 0 | 0 | 0 | 0 | 1 | |
25610 | 3 3 | 295 | Starbucks Reserve™ House Affogato | Kick back with a scoop of creamy vanilla ice cream with a hint of demerara syrup, served with a shot of Starbucks Reserve™ espresso and finished with cinnamon dusting. | ["https://static.sbux.mobi/images/mop/20231226/956bf051-a93c-4d78-a64d-4a1e95c544a0/app reserve house affogato d15.jpg"] | 0 | 0 | 0 | 0 | 0 | 1 | |
25617 | 3 3 | 303 | Starbucks Reserve™ The Lookout | Our Starbucks Reserve™ Espresso is shaken with a hint of demerara syrup before being topped with sparkling water. | ["https://static.sbux.mobi/images/mop/20231226/a1d527a6-495a-4052-8fd7-108b6ce9d602/app reserve the lookout b2.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 | |
25620 | 3 3 | 514 | Starbucks Reserve™ Nitro Cold Brew | Starbucks Reserve™ cold brew slow-steeped and infused with nitrogen for a naturally sweet flavor and cascading, velvety crema. | ["https://static.sbux.mobi/images/mop/20231226/d155a3a6-e90e-4a60-8d20-082f5e9a242c/app 1080 nitro cold brew a0.jpg"] | 0 | 0 | 0 | 0 | 0 | 1 | |
25623 | 3 3 | 728 | Frozen Honey Ruby Grapefruit Black Tea | A smooth and malty black tea blended with tangy ruby grapefruit sauce and ice, then topped with honey grapefruit peel for an oh-so-refreshing goodness. | ["https://static.sbux.mobi/images/mop/20231226/f72b13c7-b360-4611-9ac2-5f3e2ffbb8e5/app 1080 frozen ruby grapefruit and honey c7.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 | |
25631 | 3 3 | 870 | 4500990190 | Add Paper Shopper Bag | Please only add one bag per transaction and your order will be packed accordingly. | ["https://static.sbux.mobi/images/mop/20231101/3e18152a-8a33-4a30-a24a-d93c99304ddd/SBX20210405_SirenShopperBag.avif"] | 1 | 0 | 0 | 0 | 1 | 1 |
25634 | 3 3 | 888 | 4500950828 | Reusable Bag (Large) | Your order will be packed into this reusable bag if added to cart. Comes with a hard base. Recommended for larger purchases. Fits: • Up to 8 beverages of any size • 2 venti-sized beverages, and 1 Dessert Box Items that are unable to fit into this reusable bag will not be bagged and disposable shopper bag charges will apply accordingly. Please choose a reusable bag that can fit your order. | ["https://static.sbux.mobi/images/mop/20230414/9396386c-f191-4195-bab1-b298f5107a44/13.png"] | 1 | 0 | 0 | 0 | 1 | 1 |
25635 | 3 3 | 889 | 4500950827 | Reusable Bag (Small) | Your order will be packed into this reusable bag if added to cart. Comes with two built-in pockets and a hard base. Fits: • 2 beverages of any size, and 1 pastry box • 4 tall-sized beverages Items that are unable to fit into this reusable bag will not be bagged and disposable shopper bag charges will apply accordingly. Please choose a reusable bag that can fit your order. | ["https://static.sbux.mobi/images/mop/20230414/8217d266-5145-4946-9601-c7fe603ee487/12.png"] | 1 | 0 | 0 | 0 | 1 | 1 |
25636 | 3 3 | 892 | 4500853089 | Starbucks Reusable Cold Cup 20z | Suitable for drinks up to the size of Venti 20oz (591ml) 9.5cm length x 9.5cm width x 23cm height Suitable for cold beverages only Your order will not be served in the cup and will be packed separately. No disposable packaging will be provided. This item is not eligible for a 'Free Drink with tumbler purchase’ digital voucher. | ["https://static.sbux.mobi/images/mop/20230503/99b5fae2-0bbb-4d54-afcc-9b7b6c4d0e0d/reusable-cold-cup-750x750.png"] | 1 | 0 | 0 | 0 | 1 | 1 |
25637 | 3 3 | 893 | 4500853088 | Starbucks Reusable Hot Cup 20z | Suitable for drinks up to the size of Venti 20oz (591ml) 9.5cm length x 9.5cm width x 18cm height Suitable for hot and cold beverages Your order will not be served in the cup and will be packed separately. No disposable packaging will be provided. This item is not eligible for a 'Free Drink with tumbler purchase' digital voucher. | ["https://static.sbux.mobi/images/mop/20230503/2eb790c8-2476-4b4d-a959-d4784dd2f6e9/reusable-hot-cup-750x750.png"] | 1 | 0 | 0 | 0 | 1 | 1 |
25643 | 3 3 | 1023 | Low-Fat Cappuccino | With less low-fat milk than a latte, Iced Cappuccino offers a stronger espresso flavor, a luxurious texture and a velvety, frothy foam with a crisp, cool undercurrent. | ["https://static.sbux.mobi/images/mop/20231226/279c1cf7-e617-4a11-b8af-af0ad9fba59d/app 540 low-fat cappuccino b0.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 | |
25647 | 3 3 | 1027 | Iced Low-fat Cappuccino | With less low-fat milk than a latte, Iced Cappuccino offers a stronger espresso flavor, a luxurious texture and a velvety, frothy foam with a crisp, cool undercurrent. | ["https://static.sbux.mobi/images/mop/20231226/71507f61-5643-42ea-9d69-5a6dd3e241b4/app 1080 iced low-fat cappuccino b0.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 | |
28954 | 3 3 | 1091 | Strawberry Truffle Cream Frappuccino® (Less Sweet) | Strawberry and dark mocha bended with milk and ice, topped with whipped cream and freeze-dried strawberry crumbs. | ["https://static.sbux.mobi/images/mop/20240811/92d7b6e0-27b3-4f59-b99c-43a7528db146/strawberry-truffle-cream-frap_green_1080x1080.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 | |
30379 | 3 3 | 1101 | Red Apple Frozen Tea (Less Sweet) | Teavana® Zen Clouds Oolong Tea, ice and chunky apple sauce with a hint of sugar cane syrup. Adorned with a bow-shaped chocolate. | ["https://static.sbux.mobi/images/mop/20240909/bdb2283e-c500-485f-b232-5982c433eb69/red-apple-frozen-tea_green_1080x1080.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 | |
30679 | 3 3 | 1108 | Salted Maple Oatmilk Espresso Affogato-Style Frappuccino® | Salted maple syrup with oatmilk and ice, topped with whipped cream and smoked maple flakes. | ["https://static.sbux.mobi/images/mop/20240924/cf71b5cc-8f4f-4f1c-abc4-3541258bb711/salted-maple-oatmilk-espresso-affogato-frap_green_1080x1080.jpg"] | 1 | 0 | 0 | 0 | 1 | 1 |
Advanced export
JSON shape: default, array, newline-delimited, object
CREATE TABLE "menu_items" ("id" INTEGER NOT NULL PRIMARY KEY, "store_id" INTEGER NOT NULL, "item_id" VARCHAR(255) NOT NULL, "item_code" VARCHAR(255), "name" VARCHAR(255) NOT NULL, "description" VARCHAR(255) NOT NULL, "photo_urls" JSON NOT NULL, "is_mobile_order_pay" INTEGER NOT NULL, "is_delivery" INTEGER NOT NULL, "is_inventoried" INTEGER NOT NULL, "is_featured" INTEGER NOT NULL, "is_scheduled" INTEGER NOT NULL, "is_dine_in" INTEGER NOT NULL, FOREIGN KEY ("store_id") REFERENCES "stores" ("id")); CREATE INDEX "item_store_id" ON "menu_items" ("store_id"); CREATE UNIQUE INDEX "item_store_id_item_id" ON "menu_items" ("store_id", "item_id"); CREATE INDEX "item_store_id_name" ON "menu_items" ("store_id", "name");