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?
$ sqlite3 nhc.db 'select count(*) from recipes where ingredients like "%safale%"'
2
What is the most common batch size?
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: GitHub - thcipriani/nhc-homebrew-data: Data about National Homebrew Competition gold medal recipes
Enjoy everyone! Cheers!
That was pretty interesting. Only 2 past winners have use SafAle yeast? That seems surprising to me.
Cool, want to have a look. Downloaded the code, but where is the data with the recipes etc.?
It’s all inside the nhc.db
file. You’ll need sqlite to read the data: SQLite Download Page
SQLite is a super lightweight database that is way way way easier than something like mysql or postgresql, also the code is Public Domain (SQLite Copyright) which is neat 
Once you have sqlite installed you can do something like:
sqlite3 nhc.db
From then onward you should be able to use simple sql syntax to query the data.
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.
More likely only 2 past winkers calmed or SafAle specifically. Look for S-05 and you’ll get a lot more hits I suspect.
Only one, for a Piny The Elder clone (I count 280 recipes in total).
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? 