GraphGists

啤酒与啤酒厂 GraphGist

OpenBeerDB.com 包含 1400 多家啤酒厂和 5900 多种啤酒的列表。这里是该列表中前 50 家啤酒厂的图谱。该图谱根据啤酒风格、啤酒类别、位置和酒精含量提供啤酒推荐。

模式

fa2104ed cfdb 4ca3 a2ae 19c7f3dfd187 JHhk d0od

(啤酒)

  • name: 啤酒名称

  • abv: 酒精度

(啤酒厂)

  • name: 啤酒厂名称

  • address1: 地址1

  • city: 城市

  • state: 州/省

  • country: 国家

  • code: 代码

  • latitude: 纬度

  • longitude: 经度

  • phone: 电话

  • website: 网站

(类别)

  • category: 类别

(城市)

  • city: 城市

  • state: 州/省

  • country: 国家

(州/省)

  • state: 州/省

(国家)

  • country: 国家

(啤酒) - [:BREWED_AT] → (啤酒厂) (啤酒) - [:BEER_CATEGORY] → (类别) (啤酒) - [:BEER_STYLE] → (风格) (啤酒厂) - [:LOC_CITY] → (城市) - [:LOC_STATE] → (州/省) - [:LOC_COUNTRY] → (国家)

创建节点和关系

查询:旧金山(加州)的啤酒

7f56d3fe ebeb 41e2 99b2 6d248926f762 zDr32nLGV
MATCH (beer:Beer) - [:BREWED_AT] -> (brewery: Brewery) - [:LOC_CITY] -> (city:City {city: 'San Francisco'}) - [:LOC_STATE] -> (state:State {state: 'California'})
RETURN Distinct(beer.name) as beer, brewery.name as brewery, brewery.address1 as address
order by brewery.name, beer.name

查询:德国拉格啤酒类别的啤酒

MATCH   (category:Category {category: "German Lager"}) <- [:BEER_CATEGORY]- (beer:Beer) - [:BREWED_AT] -> (brewery: Brewery)  - [:LOC_CITY] -> (city:City) - [:LOC_STATE] -> (state:State)  - [:LOC_COUNTRY] -> (country:Country)
RETURN Distinct(beer.name) as beer,  brewery.name as brewery, city.city as city, state.state as state , country.country as country
order by country , beer

特定类别和地点的啤酒:英国的英式爱尔啤酒

188c2526 f3fa 4b3d b2b5 44953d643249 JI 40udKs
MATCH   (category:Category {category: "British Ale"}) <- [:BEER_CATEGORY]- (beer:Beer) - [:BREWED_AT] -> (brewery: Brewery)  - [:LOC_CITY] -> (city:City) - [:LOC_STATE] -> (state:State)  - [:LOC_COUNTRY] -> (country:Country {country: "United Kingdom"})
RETURN Distinct(beer.name) as beer,  brewery.name as brewery, city.city as city
order by city, beer

特定风格的啤酒:波特啤酒

MATCH    (style:Style {style: 'Porter'}) <- [:BEER_STYLE] - (beer:Beer) - [:BREWED_AT] -> (brewery: Brewery)  - [:LOC_CITY] -> (city:City) - [:LOC_STATE] -> (state:State)  - [:LOC_COUNTRY] -> (country:Country)
RETURN Distinct(beer.name) as beer,  brewery.name as brewery, city.city as city, state.state as state , country.country as country
order by country , beer

同一风格的啤酒:例如 IPA 啤酒

552b9d21 2cc6 48dc a93c 7d9cbe41de4e sZphtDcA
MATCH   (:Beer {name: 'IPA'}) - [:BEER_STYLE] - >  (style:Style) <- [:BEER_STYLE] - (beer:Beer)  - [:BREWED_AT] -> (brewery: Brewery)  - [:LOC_CITY] -> (city:City) - [:LOC_STATE] -> (state:State)  - [:LOC_COUNTRY] -> (country:Country)
RETURN  Distinct(beer.name) as beer ,  brewery.name as brewery, city.city as city, state.state as state , country.country as country
order by beer

最烈的啤酒(酒精度最高)

MATCH   (beer:Beer) - [:BREWED_AT] -> (brewery: Brewery)
RETURN  beer.name as beer ,  beer.abv, brewery.name as brewery, brewery.city as city, brewery.state as state , brewery.country as country
order by beer.abv desc
limit 10

最淡的啤酒(酒精含量低)

MATCH   (beer:Beer) - [:BREWED_AT] -> (brewery: Brewery)
where beer.abv > 0
RETURN  beer.name as beer ,  beer.abv, brewery.name as brewery, brewery.city as city, brewery.state as state , brewery.country as country
order by beer.abv
limit 10
© . All rights reserved.