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 = 1, is_scheduled = 0 and store_id = 8

✎ 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
28303 8 8 886   Belgium Chocolate Nitro Cold Brew Sweetened smooth coffee topped with creamy chocolate cream and dusted with Belgium chocolate shavings. ["https://static.sbux.mobi/images/mop/20240811/c278bae0-b559-4a61-97ad-905392240ba1/belgium-chocolate-nitro-cold-brew_green_1080x1080.jpg"] 1 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");