menu_items

Starbucks menu items available in Singapore stores

Data license: MIT · Data source: Starbucks Singapore · About: Made by jerrynsh.com

20 rows where is_delivery = 0, is_scheduled = 1 and store_id = 140

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: description, is_inventoried, photo_urls (array)

is_mobile_order_pay 2

  • 1 19
  • 0 1

store_id 1

  • 140 · 20 ✖

is_scheduled 1

is_dine_in 1

  • 1 20

is_delivery 1

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
3728 140 140 76 4500700433 Apple Tart Fuel your day with a flaky and buttery tart filled with juicy apple slices. ["https://static.sbux.mobi/images/mop/20220210/1977cf18-d4c6-4c5e-b9bf-b136ad53b616/apple-tart_1080x1080.jpg"] 1 0 1 0 1 1
3729 140 140 77 4500700432 Lemon Meringue Tart A tangy treat with tart lemons, balanced with the sweetness of meringue. ["https://static.sbux.mobi/images/mop/20220210/c56dd5c1-30a3-4a41-9161-4476f455c112/lemon-meringue-tart_1080x1080.jpg"] 1 0 1 0 1 1
3744 140 140 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
3755 140 140 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
3764 140 140 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
3765 140 140 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
3766 140 140 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
3767 140 140 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
3790 140 140 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
3834 140 140 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
3842 140 140 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
3846 140 140 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
3847 140 140 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
3848 140 140 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
3849 140 140 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
3856 140 140 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
3860 140 140 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
28346 140 140 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
29199 140 140 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
30443 140 140 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

CSV options: 

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");