GraphGists

OpenBeerDB.com 列出了 1400 多家酿酒厂和 5900 多种啤酒。以下是该列表中前 50 家酿酒厂的图表。该图表根据啤酒风格、啤酒类别、位置和酒精含量推荐啤酒。

模式

fa2104ed cfdb 4ca3 a2ae 19c7f3dfd187 JHhk d0od

(啤酒)

  • name: 啤酒名称

  • abv: 酒精含量

(酿酒厂)

  • name: 酿酒厂名称

  • address1

  • 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