NHC SQLite Dataset

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 :slight_smile:

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.  ::slight_smile:
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?  :wink: