PDA

View Full Version : Got databases?



GreggB
11-30-2008, 14:44
Have you created any type of bourbon-related databases?

If so, what type of information have you collected?

Do you have any you would be willing to share?

The only one I have is a spreadsheet of prices for stores in the St. Louis area, presumably of limited interest.

Please share what you've got.

Gregg

shoshani
11-30-2008, 15:12
I'd love to see a database of distilleries and their mashbills, cooking methods, distillation proof, barrelling proof, DSP numbers, etc. Both Jim Murray and the Regans had such information in their books; I don't have Murray's Whisk(e)y Bible so I don't know if he keeps current.

However, I do know that both Buffalo Trace and Heaven Hill started wheated bourbon production after both authors' major books on the subject, so while we know that Pappy was adamant about not cooking under pressure (corn is cheap), not using city water, barrelling at around 107 proof or so and bottling at no less than 100 proof (why ship water?), These practices were not followed by BT and HH for their rye recipe bourbon. Are they following Pappy's guidelines for their wheat recipe bourbon? It would be interesting to see.

So far as I know, Maker's Mark pretty much follows all of Pappy's principles except for bottling at 90 proof.

An up-to-date spreadsheet, or even a table within a web page (say, on SB) would be excellent, but I don't know how many would want to contribute all their information to such a project...

kickert
11-30-2008, 16:26
A friend and I keep a database of our tasting notes and ratings for various whiskies. We also keep up with type, cost, distiller, proof, age, designation, and mashbill/region.

We use google docs which is great for multiple editors. You can view the page here:

http://spreadsheets.google.com/ccc?key=pEniGQvvhfZZNMYM1sV3DeQ

ggilbertva
11-30-2008, 18:16
I've kept an Excel spreadsheet of every bottle I've purchased. I have the tabs broken down between Bourbon; Rye; Scotch; Dusty's; Other.

On each sheet it lists the name, age, dsp, upc, distillery, date purchased, purchase price, bottling date, age, proof, comments.

If you're interested, I can send you a blank copy.

Slob
11-30-2008, 18:46
You know what would be really nice? A bourbon wiki. Distilleries, brands, master distillers, distillation techniques. Anything and everything bourbon-related.

kickert
11-30-2008, 19:17
You know what would be really nice? A bourbon wiki. Distilleries, brands, master distillers, distillation techniques. Anything and everything bourbon-related.

you mean like http://whiskipedia.org/

Rughi
12-01-2008, 23:09
I'd love to see a database of distilleries and their mashbills, cooking methods, distillation proof, barrelling proof, DSP numbers, etc. Both Jim Murray and the Regans had such information in their books; I don't have Murray's Whisk(e)y Bible so I don't know if he keeps current.

I once compared mashbills (http://www.straightbourbon.com/forums/showpost.php?p=53183&postcount=69) as told by distillery people to Regan, Murray and Cowdery - they weren't all told the same thing.

One gets the sense that any of the tech talk told to journalists and enthusiasts is done with a twinkle in their eye. I would trust the data sheets that come with the BTACs, though.

For those who use Excel, I put together a database (http://www.straightbourbon.com/forums/showthread.php?t=8339&highlight=cecil) of some distillery info in Sam Cecil's book. This is pretty useful in finding DSP's (which he lists as RD's), but it's not always correct or complete.

Roger

barturtle
12-02-2008, 06:04
For those who use Excel, I put together a database (http://www.straightbourbon.com/forums/showthread.php?t=8339&highlight=cecil) of some distillery info in Sam Cecil's book. This is pretty useful in finding DSP's (which he lists as RD's), but it's not always correct or complete.

Roger

For those who don't use Excel, give this Viewer (http://www.microsoft.com/Downloads/details.aspx?familyid=1CD6ACF9-CE06-4E1C-8DCF-F33F669DBC3A&displaylang=en) a shot (I've not used it, but thought it may be handy for those who might need it)

Vange
12-02-2008, 07:41
I keep a self made database of my entire inventory of wine, spirits, cigars, and special beers and even capture a wishlist with a 1-6 rating of how much I want a certain item on the wishlist. I partly do this since I insure my stash , but mainly its a great because its a good way to keep track of everything. I also keep tasting notes and ratings on everything I have tried. It has become a bit of an OCD thing for me though. If I goto a restaurant and order a bottle of wine I take a picture of the label and text myself tasting notes and a rating and then go home and enter it into my database. Someone help me....

BourbonJoe
12-02-2008, 10:19
I use a Microsoft Access Database. I once used Excel but I find that Access is much better and easier to sort.
Joe :usflag:

shoshani
12-02-2008, 11:39
I use a Microsoft Access Database. I once used Excel but I find that Access is much better and easier to sort.
Joe :usflag:

Absolutely. Excel is a spreadsheet; its primary function is accounting. Databases belong in Access, where tables can have columns resorted without destroying relational information (try re-ordering an Excel column and you will discover that the rows don't follow. EEEP.) You can also build queries and reports to sift and filter and present the tabular data any way you please.

Rughi
12-02-2008, 13:07
This thread spurred a memory about a book that Chet Zoeller was writing. I've inquired about this in the History forum.

GreggB
12-02-2008, 19:59
Someone help me....


Well, if it's your ONLY vice, I wouldn't worry about it.