[thcipriani]

Seems like as good of a place as any to post this info.

I've collected the NHC gold medal winners dataset into a sqlite database to allow some rudimentary data science + easy, open, access.

Now answering weird one-off questions about NHC winners over the past decade is simple:

How many winning recipes in the past decade used SafAle yeast?

Code: [Select]

$ sqlite3 nhc.db 'select count(*) from recipes where ingredients like "%safale%"'
  2
What is the most common batch size?

Code: [Select]

sqlite3 nhc.db 'select vol from recipes' | cut -d'(' -f1 | sort | uniq -c | sort -rn | head -5
     77 5 Gallons
     44 6 Gallons
     35 10 Gallons
     24 5.5 Gallons
     14 12 Gallons
You can even use the data to create interesting plots that can answer questions.

Has the average gravity of a batch changed over the years?



All the code and info is available at: https://github.com/thcipriani/nhc-homebrew-data

Enjoy everyone! Cheers!

[brulosopher]

That was pretty interesting. Only 2 past winners have use SafAle yeast? That seems surprising to me.

[homoeccentricus]

Cool, want to have a look. Downloaded the code, but where is the data with the recipes etc.?

[thcipriani]

Cool, want to have a look. Downloaded the code, but where is the data with the recipes etc.?

It's all inside the

Code: [Select]

nhc.db file. You'll need sqlite to read the data: https://www.sqlite.org/download.html

SQLite is a super lightweight database that is way way way easier than something like mysql or postgresql, also the code is Public Domain (https://www.sqlite.org/copyright.html) which is neat

Once you have sqlite installed you can do something like:

Code: [Select]

sqlite3 nhc.db
From then onward you should be able to use simple sql syntax to query the data.

[homoeccentricus]

Ah yes, sorry, I was looking for a larger file. 
I can reproduce the queries, so nice!

The only problem I see is that the recipe field is simply a text field so it would be difficult to get a drill-down of, for instance, all the different types of yeast that have been used.  But I understand it would be quite a bit of (I assume mostly manual) work to get all that information into separate fields.

[morticaixavier]

That was pretty interesting. Only 2 past winners have use SafAle yeast? That seems surprising to me.

More likely only 2 past winkers calmed or SafAle specifically. Look for S-05 and you'll get a lot more hits I suspect.

[homoeccentricus]

Only one, for a Piny The Elder clone (I count 280 recipes in total).

[hopfenundmalz]

That was pretty interesting. Only 2 past winners have use SafAle yeast? That seems surprising to me.

More likely only 2 past winkers calmed or SafAle specifically. Look for S-05 and you'll get a lot more hits I suspect.

Winkers or wankers? I kid.

[morticaixavier]

That was pretty interesting. Only 2 past winners have use SafAle yeast? That seems surprising to me.

More likely only 2 past winkers calmed or SafAle specifically. Look for S-05 and you'll get a lot more hits I suspect.

Winkers or wankers? I kid.

I have got to start paying attention to what autocorrect days I said. Hopefully everyone got the point.

[hopfenundmalz]

That was pretty interesting. Only 2 past winners have use SafAle yeast? That seems surprising to me.

More likely only 2 past winkers calmed or SafAle specifically. Look for S-05 and you'll get a lot more hits I suspect.

Winkers or wankers? I kid.

I have got to start paying attention to what autocorrect days I said. Hopefully everyone got the point.

You have to have noticed some of mine by now, right?