GraphGists

菜单上有什么？

介绍

纽约公共图书馆在其 菜单上有什么？ 集合中拥有 1840 年代至今的超过 45,000 个菜单。这个图列表出了该集合中四个菜单中的菜肴。

架构

c5212c0f 28ed 492e 9214 68ac078bb79e 5M40Mrujs

节点

  • (菜单)

    • name: 餐厅名称

    • event

    • physical_description: 菜单描述

    • notes

    • call_number: 纽约公共图书馆的呼号

    • date: 菜单日期

    • status

    • page_count: 菜单页数

  • (菜肴)

    • name: 菜肴名称

  • (位置)

    • address

    • city

    • state

关系

  • [:SERVES]

    • price: 菜肴价格

  • [:LOCATED_AT]

创建节点和关系

查询

列出所有菜单

ba8d123a 43b3 47e7 ad43 8a26f1b853c7 Gj2M9BQew
图 1. 所有菜单
MATCH (menu: Menu)
RETURN menu.name AS Restaurant, menu.dish_count AS `Dish Count`, menu.call_number AS `Call Number`, menu.date AS Date
ORDER By menu.name

查找一个城市中的所有餐厅

纽约市的所有餐厅

MATCH (location: Location {city:"New York"})<-[:LOCATED_AT]-(menu: Menu)
RETURN menu.name AS Restaurant, location.city AS City, location.state AS State, menu.date AS Date
ORDER BY menu.name
871ac062 2653 4285 ab60 c96440fcad1b 40MKlc2Xa
图 2. 每个城市的菜单

查找提供特定菜肴的餐厅。

所有提供咖啡的餐厅。

MATCH (location: Location)<-[:LOCATED_AT]-(menu: Menu)-[r:SERVES]->(dish: Dish {name: 'Coffee'})
RETURN menu.name AS Restaurant, r.price as price, location.city AS City, location.state AS State, menu.date AS Date
ORDER BY menu.name
a8be4fef 8961 4290 bf05 59a74a862f70 S 0qHbG9L
图 3. 提供咖啡的餐厅

查找一个城市中提供特定菜肴的餐厅。

纽约市中所有提供牛奶的餐厅。

MATCH (location: Location {city:"New York"})<-[:LOCATED_AT]-(menu: Menu)-[r:SERVES]->(dish: Dish {name: 'Milk'})
RETURN menu.name AS Restaurant, r.price as price, location.city AS City, location.state AS State, menu.date AS Date
ORDER BY menu.name

查找特定餐厅提供的菜肴

cc76df9e 8a9f 47f1 b4f1 cbe1e071586c x QWK1EcV
图 4. 维吉尼亚酒店的所有菜肴

全尺寸图像

MATCH (menu: Menu {name: 'Virginia Hotel'})-[r:SERVES]->(dish: Dish)
RETURN dish.name AS Dish, r.price as price, menu.date AS Date
ORDER BY dish.name
613c8496 32ae 4375 8ae4 7ffd73e6dbdf GJTEAouj5

查找最常见的菜肴

MATCH (menu: Menu)-[re:SERVES]->(dish: Dish)
WITH dish, count(menu) AS rels, collect(menu.name) as menus
RETURN dish.name AS Dish, rels AS Count, menus AS Restaurants
ORDER BY rels DESC
LIMIT 5

查找两家餐厅共有的所有菜肴

共和党议会大厦和马尔堡酒店提供的菜肴。

MATCH (menu: Menu {name: 'Republican House'})-[r:SERVES]->(dish: Dish)
RETURN dish, menu
UNION
MATCH (menu: Menu {name: 'Hotel Marlborough'})-[r:SERVES]->(dish: Dish)
RETURN dish, menu
290ef5bc ca85 436c 8b8c 2e828c024e5a wRUmBVnuI

按价格查找菜肴

最贵的菜肴

MATCH (location: Location)<-[:LOCATED_AT]-(menu: Menu)-[r:SERVES]->(dish: Dish)
WHERE r.price > 0
RETURN dish.name, menu.name AS Restaurant, r.price as price, location.city AS City, location.state AS State, menu.date AS Date
ORDER BY price DESC
LIMIT 5

最便宜的菜肴

MATCH (location: Location)<-[:LOCATED_AT]-(menu: Menu)-[r:SERVES]->(dish: Dish)
WHERE r.price > 0
RETURN dish.name, menu.name AS Restaurant, r.price AS Price, location.city AS City, location.state AS State, menu.date AS Date
ORDER BY r.price ASC
LIMIT 5

参考文献

菜单上有什么？ 集合