menu_items

Starbucks menu items available in Singapore stores

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

6 rows where is_dine_in = 1, is_mobile_order_pay = 0 and store_id = 69

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: photo_urls (array)

is_scheduled 2

store_id 1

is_mobile_order_pay 1

is_dine_in 1

is_delivery 1

  • 0 6
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
782 69 69 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
825 69 69 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
869 69 69 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
873 69 69 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
874 69 69 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
884 69 69 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

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