From: jmellby@iluvatar.dseg.ti.com (John R. Mellby)
Newsgroups: alt.beer
Subject: Pub (not brewpub) List on sierra.Stanford.EDU
Date: 12 Nov 92 18:40:29 GMT
Organization: TI-DSEG Spring Creek

For those of you who want a listing with more than just brewpubs on it,
I have put up on the Homebrew archive at sierra.Stanford.EDU (courtesy
of Stephen Hansen) the latest version of my listing of beer-related
establishments.  This file contains
        Brewpubs
        Pubs/Bars
        Restaurants
        Beer Stores (Liquor stores and Wine stores)
        Microbreweries
        Breweries (fewer of these)
        Importers (still fewer of these)
        Misc (like the Scotch Whiskey Society)

The file itself is in compressed format
and is in pub/homebrew/incoming (although Stephen will probably
move it to pub/homebrew) named pubs-nov92.Z  
I am still inputting more bars from the latest BarleyCorn, as well as
trying to fix errors I detect in the latest Brewpub listings.

For most of these the database contains names, addresses, city, state,
zip code, area-code and phone number, the type of entry, and notes.
Since some of these are from other people's listings or listing
in the beer magazines (especially the California Celebrator) there is
only the name, address, and type of establishment.

The notes are either my own, notes from Usenet/News, or
Homebrew digest, or things I extracted from reviews in magazines.
The last few years I have tried to attribute the notes or information
to the original poster.  If I missed anyone's name I apologize now.

    I have been keeping this file for some 5 years now.  Major sources of
    input have been various issues of the California Celebrator (I cannot
    recommend this paper enough) and the Cascade Beer News.  I have also put
    in information from reviews in magazines like "All About Beer" and the
    "Whole Beer Review", both good magazines.  This last year I have also
    got copies of "Rocky Mountain Brews" and "BarleyCorn" centered in the
    Rocky Mountain states, and Washington D.C.  I haven't tried  to input 
    information wholesale from books listing pubs because I have an
    underlying feeling that I wouldn't want to cut into their market.  The
    magazines/newspapers have so much other than pub listings to offer that
    I cannot see this impacting their business.

My format is:

COUNTRY
State -- City:
  pub name - address; (areacode)phone
    Type-of-entry   further notes
    Continued notes.

The reason for this format is that I have a (unstable) program to
extract listings in various ways.  My most common usage is to
ask for entries with 30 miles of a given city.  This helps when
you're in the SF Bay Area, which has lots of differently named cities
in close proximity, and a traveller to the area doesn't know which
California cities are really near SF.

John R. Mellby
(214)517-5370 <home>	(214)575-6125 <work>
Texas Instruments	Has no responsibility for this!
jmellby@iluvatar.dseg.ti.com
jmellby@skvax1.ti.com

Special Sources:
California Celebrator
Rocky Mountain Brews
Cascade
All About Beer
World Beer Review
gcw@garage.att.com; Geoffrey Woods
bcstec!tahoma!dgs1300@uunet.UU.NET;
   Don Scheidt, <Lots of corrections, some of my original Belgian notes were
   from an earlier message by Don.  He added and corrected a lot of NW USA
   and some Belgian entries, and added a lot of German notes>