menu_items

Starbucks menu items available in Singapore stores

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

1 row where is_mobile_order_pay = 0, is_scheduled = 1 and store_id = 108

✎ View and edit SQL

This data as json, CSV (advanced)

Suggested facets: photo_urls (array)

store_id 1

is_scheduled 1

is_mobile_order_pay 1

is_dine_in 1

  • 1 1

is_delivery 1

  • 0 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
9078 108 108 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

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