US Breweries

List of Breweries Across US States

@kaggle.brkurzawa_us_breweries

Table List

1 table(126.63 KB)

Breweries Us

@kaggle.brkurzawa_us_breweries.breweries_us

126.63 KB
2407 rows
6 columns

brewery_name Brewery Name	type Type	address Address	website Website	state State	state_breweries State Breweries
Valley Brewing Co.	Brewpub	PO Box 4653, Stockton, California, 95204	http://www.valleybrew.com/	california	284
Valley Brewing Co.	Brewpub	157 Adams St., Stockton, California, 95204	http://www.valleybrew.com/	california	284
Valley Brewing Co	Microbrewery	1950 W Freemont, Stockton, California, 95203	http://www.valleybrew.com/	california	284
Ukiah Brewing Company	Brewpub	102 S. State St., Ukiah, California, 95482	http://www.ukiahbrewingco.com/	california	284
Tustin Brewing Co.	Brewpub	13011 Newport Ave. #100, Tustin, California, 92780	http://www.tustinbrewery.com/	california	284
Trumer Brauerei	Microbrewery	1404 4th St., Berkeley, California, 94608	http://www.trumer-international.com/	california	284
Trumer Brauerei	RegionalBrewery	1404 Fourth St., Berkeley, California, 94710	http://www.trumer-international.com/	california	284
Triple Rock Brewing Co.	Brewpub	1920 Shattuck Ave, Berkeley, California, 94704	http://www.triplerock.com/	california	284
Tied House Cafe & Brewery (San Jose)	Brewpub	65 N. San Pedro, San Jose, California, 95110	http://www.tiedhouse.com/	california	284
Tied House Cafe & Brewery (Mt. View)	Brewpub	954 Villa St., Mountain View, California, 94041	http://www.tiedhouse.com/	california	284


CREATE TABLE breweries_us (
  "brewery_name" VARCHAR,
  "type" VARCHAR,
  "address" VARCHAR,
  "website" VARCHAR,
  "state" VARCHAR,
  "state_breweries" BIGINT
);