Pups and Pubs - Brewery Analysis With SQL, Python, and Tableau

Image: Cassie at Hazel Park High School tennis courts. Credit: Emma Weintraub

Name a better combo than dogs, sunny weather, and a cold beverage. That's the goal whenever I'm eager to try out a new brewery with my friends and family. Our dog Cassie loves to come on trips with us, and exploring new breweries is no exception. In Michigan, it's an easy task finding something new to try as breweries have rapidly opened up in the Great Lakes State. While there's never a shortage of breweries to experience, finding dog-friendly breweries is not always as simple. In this project, we'll explore a database full of brewery data to see what insights we can extract. At the end, we'll introduce a second data source to help us locate dog-friendly breweries in Michigan. We'll finish the project by building an interactive map of our dog-friendly breweries.

We'll begin by investigating the database provided by Open Brewery DB. It includes a rich community-driven free dataset of breweries globally. We will populate this data into a new table breweries with columns as highlighted below:

breweries

column	type	description
brewery_id	text	unique brewery id
brewery_name	text	name of brewery
brewery_type	text	type of brewery (brewpub, micro, etc.)
address_1	text	building address
address_2	text	alternative address
address_3	text	alternative address
city	text	city of brewery
state_province	text	state or province of brewery
postal_code	text	postal code of brewery
country	text	country of brewery
phone	text	phone number of brewery
website_url	text	website of brewery
longitude	numeric	longitude coordinates
latitude	numeric	latitude coordinates

We'll use python libraries pandas, psycopg2, and sqlalchemy to retrieve our breweries data from Open Brewery DB's GitHub repository (3) and populate our new breweries table.

import pandas as pd
import psycopg2 as pg2
from sqlalchemy import create_engine

conn = pg2.connect(database=database, user=user,password=password)
cur = conn.cursor()

engine = create_engine(engine_string)

url = ('https://raw.githubusercontent.com/openbrewerydb/openbrewerydb/master/breweries.csv')
df = pd.read_csv(url)

df.to_sql('breweries',con=engine, if_exists='replace')

206

Let's begin by getting a sample of 5 breweries from our breweries table to make sure the data was successfully loaded. We'll then observe the samples to get an idea of what our data looks like.

%%sql

-- Get the first 5 rows from the breweries table
SELECT *
FROM breweries
LIMIT 5

Running query in 'brewery_database'

5 rows affected.

index	id	name	brewery_type	address_1	address_2	address_3	city	state_province	postal_code	country	phone	website_url	longitude	latitude
0	5128df48-79fc-4f0f-8b52-d06be54d0cec	(405) Brewing Co	micro	1716 Topeka St	None	None	Norman	Oklahoma	73069-8224	United States	4058160490	http://www.405brewing.com	-97.46818222	35.25738891
1	9c5a66c8-cc13-416f-a5d9-0a769c87d318	(512) Brewing Co	micro	407 Radam Ln Ste F200	None	None	Austin	Texas	78745-1197	United States	5129211545	http://www.512brewing.com	None	None
2	ef970757-fe42-416f-931d-722451f1f59c	10 Barrel Brewing Co	large	1501 E St	None	None	San Diego	California	92101-6618	United States	6195782311	http://10barrel.com	-117.129593	32.714813
3	6d14b220-8926-4521-8d19-b98a2d6ec3db	10 Barrel Brewing Co	large	62970 18th St	None	None	Bend	Oregon	97701-9847	United States	5415851007	http://www.10barrel.com	-121.281706	44.08683531
4	e2e78bd8-80ff-4a61-a65c-3bfbd9d76ce2	10 Barrel Brewing Co	large	1135 NW Galveston Ave Ste B	None	None	Bend	Oregon	97703-2465	United States	5415851007	None	-121.3288021	44.0575649

Looks like our python script loaded the data into our PostgreSQL database successfully! We can see all columns present as well as 5 sample data points. We can also see that there's null values in our dataset, but that's ok! When creating a new table, we can designate which columns we absolutely will not allow null values. Before loading the data into PostgreSQL, I wrote a query to make sure a table was generated with no null values allowed for brewery_id (primary key), brewery_name, city, state_province, and country. These will be the primary values we'll need. Now, we're ready to explore our data!

1. How many breweries are in the database?

%%sql

-- Get the total count of rows from breweries
SELECT COUNT(*)
FROM breweries

Running query in 'brewery_database'

1 rows affected.

count
8206

Looks like our database has 8206 total breweries listed from around the globe! That's a lot of breweries.

2. How many breweries are there in each country?

%%sql

-- Get all countries and respective brewery counts from breweries in descending order
SELECT country, COUNT(*) as cnt
FROM breweries
GROUP BY country
ORDER BY cnt DESC

Running query in 'brewery_database'

11 rows affected.

country	cnt
United States	7935
Ireland	70
England	62
South Korea	61
Poland	34
Austria	14
Portugal	14
Scotland	10
France	3
Isle of Man	2
United States	1

Wow! The US has over 7935 breweries! That is quite a lead compared to all other countries listed. Another interesting observation is that the database shows two different 'United States' countries listed. Why is that? Let's take a look at the dataframe in python to find out.

df['country'].unique()

array(['United States', 'Ireland', 'England', 'South Korea', 'Portugal',
       'Poland', 'France', 'Isle of Man', 'Scotland', 'Austria',
       ' United States'], dtype=object)

It appears that there is an extra space present in one of the strings. Let's apply a trim function in SQL to clean that column.

%%sql

--remove beginning and ending spaces on each country string
UPDATE breweries
SET country = btrim (country, ' ')

Running query in 'brewery_database'

8206 rows affected.

%%sql

-- Get the US brewery count to check if the cleaning operation was successfull. 7935 -> 7936
SELECT country, COUNT(*)
FROM breweries
WHERE country = 'United States'
GROUP BY country

Running query in 'brewery_database'

1 rows affected.

country	count
United States	7936

3. How many breweries are there in each state in the US?

%%sql

-- get all US states and respective brewery counts from breweries
SELECT state_province, COUNT(*) as cnt
FROM breweries
WHERE country = 'United States'
GROUP BY state_province
ORDER BY cnt DESC

Running query in 'brewery_database'

54 rows affected.

state_province	cnt
California	912
Washington	471
Colorado	431
New York	418
Michigan	375
Texas	352
Pennsylvania	345
Florida	312
North Carolina	307
Ohio	303
Oregon	295
Virginia	254
Illinois	249
Wisconsin	217
Minnesota	182
Massachusetts	163
Indiana	162
Missouri	141
Arizona	124
New Jersey	115
Maine	114
Tennessee	110
Maryland	109
Georgia	100
Connecticut	94
Montana	92
Iowa	91
New Mexico	83
South Carolina	79
New Hampshire	72
Idaho	67
Vermont	59
Kentucky	58
Nebraska	57
Nevada	51
Alaska	51
Kansas	47
Arkansas	45
Alabama	45
South Dakota	45
Oklahoma	44
Utah	44
Louisiana	43
West Virginia	33
Wyoming	32
Rhode Island	31
Delaware	28
North Dakota	26
Hawaii	23
Mississippi	16
District of Columbia	16
Utah	1
MIssouri	1
Washington	1

Look at that! Michigan is in the top 5 states in the US regarding total number of breweries. Michigan is ranked 5th behind New York, Colorado, Washington, and California. Let's dive deeper into the Michigan brewery scene.

4. What are the brewery types in Michigan?

%%sql

-- Get the brewery type and respective count from Michigan, US breweries in descending order
SELECT brewery_type, COUNT(*) AS total_breweries
FROM breweries
WHERE country = 'United States'
AND state_province = 'Michigan'
GROUP BY brewery_type
ORDER BY total_breweries DESC

Running query in 'brewery_database'

5 rows affected.

brewery_type	total_breweries
brewpub	199
micro	143
planning	21
regional	9
contract	3

The majority of breweries in Michigan are brewpubs closely followed by micro breweries. This makes sense if we consider that brewpubs are beer-focused restaurants and micro breweries are what most craft breweries are considered.

5. What cities in Michigan have the most breweries?

%%sql

-- Get the top 5 cities and respective brewery count from Michigan, US breweries in descending order
SELECT city, COUNT(*) AS total_breweries
FROM breweries
WHERE country = 'United States'
AND state_province = 'Michigan'
GROUP BY city
ORDER BY total_breweries DESC
LIMIT 5

Running query in 'brewery_database'

5 rows affected.

city	total_breweries
Grand Rapids	25
Kalamazoo	14
Detroit	13
Traverse City	12
Ann Arbor	11

We can see that the top 5 cities in Michigan with the most breweries includes Grand Rapids, Kalamazoo, Detroit, Traverse City, and Ann Arbor. Grand Rapids appears to be the top city for breweries by a large margin (11 more than the next leading city Kalamazoo).

6. What is the breakdown of brewery types in the top 5 cities in Michigan?

%%sql

-- Get the city, brewery type, and respective brewery total from Michigan breweries grouped by city and type. Query ordered by city and brewery totals.
SELECT city, brewery_type, COUNT(*) AS total_breweries
FROM breweries
WHERE country = 'United States'
AND state_province = 'Michigan'
AND city IN ('Grand Rapids', 'Kalamazoo', 'Detroit', 'Traverse City', 'Ann Arbor')
GROUP BY city, brewery_type
ORDER BY city, total_breweries DESC

Running query in 'brewery_database'

16 rows affected.

city	brewery_type	total_breweries
Ann Arbor	brewpub	8
Ann Arbor	micro	2
Ann Arbor	planning	1
Detroit	brewpub	5
Detroit	micro	3
Detroit	regional	2
Detroit	planning	2
Detroit	contract	1
Grand Rapids	brewpub	21
Grand Rapids	micro	2
Grand Rapids	regional	2
Kalamazoo	brewpub	8
Kalamazoo	micro	5
Kalamazoo	planning	1
Traverse City	micro	7
Traverse City	brewpub	5

We can see that Grand Rapids has the largest concentration of any one brewery type with 21 brewpubs, but detroit has the largest variation including a brewpub, micro, regional, planning, and contract brewery.

7. If we pick a city, can we find which breweries are in a 50 mile radius?

Let's say that we are visiting my home town (Midland, MI), could we find out what the nearest breweries would be? We will use Midland's latitude and longitude coordinates (43.618183 and -84.234238 respectively). Let's first review how to find the distance between 2 points on earth in miles.

The equation (1) is defined as:

$$Distance = 3963 * arccos((sin(latitude_1) * sin(latitude_2)) + cos(latitude_1) * cos(latitude_2) * cos(longitude_2 - longitude_1))$$

%%sql

-- Get the name, city, address, state, postal code, lat and long coordinates where there location is within 50 miles of Midland, MI
SELECT name, city, address_1, state_province AS state, postal_code, latitude, longitude
FROM breweries
WHERE 3963 * ACOS((SIN(radians (43.618183)) * SIN(radians (latitude))) + 
    COS(radians (43.618183)) * COS(radians (latitude)) * COS(radians (longitude) - radians (-84.234238))) 
    <= 50

Running query in 'brewery_database'

12 rows affected.

name	city	address_1	state	postal_code	latitude	longitude
Alma Brewing Co	Alma	208 E Superior St	Michigan	48801-1819	43.37888808	-84.6588719
Cranker's Restaurant & Brewery	Mount Pleasant	1207 E Pickard St	Michigan	48858-1901	43.61176916	-84.76071102
Four Leaf Brewing	Clare	412 N McEwan St	Michigan	48617-1403	43.8256884	-84.7683591
Frankenmuth Brewing Co	Frankenmuth	425 S Main St	Michigan	48734-1615	43.32893336	-83.73929404
Loggers Brewing Company	Saginaw	1215 S River Rd	Michigan	48609-5208	43.40518225	-84.05193542
Midland Brewing Co	Midland	5011 N Saginaw Road	Michigan	48642	43.6408678	-84.2910925
Mountain Town Brewing Co	Mt Pleasant	614 W Pickard St	Michigan	48858-1504	43.61180948	-84.78689552
Mountain Town Station Restaurant & Brew Pub	Mt Pleasant	506 W Broadway St	Michigan	48858-2441	43.604568	-84.7822205
Oracle Brewing Company	Saginaw	122 N Michigan Ave	Michigan	48602-4234	43.417723	-83.96401351
Tenacity Brewing	Flint	119 N Grand Traverse St	Michigan	48503-5620	43.01522788	-83.69663179
The Highway Brewing Co.	West Branch	209 W Houghton Ave	Michigan	48661-1219	44.27635208	-84.23751651
The Maple Grille LLC	Hemlock	13105 Gratiot Rd	Michigan	48626-8444	43.4157758	-84.1741049

8. Which breweries are dog-friendly in Michigan?

What if we wanted to go on a road trip and check out some breweries on the way, but we also wanted to bring our dog? That data is not currently in our brewery database, so we will need to look elsewhere to find the data. Luckily, we can use Kevin McKinney's currated list of dog friendly Michigan breweries (2)! We'll first need to scrape the website and grab the needed data using python's beautifulsoup library. We'll clean the data to remove any trailing spaces or unnecessary characters, then we'll upload the data into a new table in our SQL database.

import requests
import bs4
import re

# Pull the raw html from the website
res = requests.get("https://michiganbreweryreview.com/michigan-dog-friendly-breweries/2018/8/2/the-ever-growing-list-of-k-9-friendly-breweries?format=amp")
soup = bs4.BeautifulSoup(res.text,"lxml")

dog_brewery_list = []
cleaned_soup = []

#parse the html data looking for brewery names and the respective cities. Place the items into a cleaned_soup list
it = iter(soup.select('p')[1].contents)

for item in it:
    if item.text == "" or item.text == " " or item.text == ".":
        next
    else:
        cleaned_soup.append(item)

#iterate through the clean_soup list and remove any unnecessary spaces, dashes, or parenthesis. Place the cleaned items into a dog_brewery_list
it = iter(cleaned_soup)  

for item in it:
    dog_brewery_list.append((item.text.strip(),re.sub("[\(\[].*?[\)\]]", "", next(it).text.split('- ',1)[-1].split('- ',1)[-1].strip().strip())))

#Create a dataframe from dog_brewery_list with columns: 'brewery_name' and 'city'. Send the dataframe to posgresql as a new table
dog_df = pd.DataFrame(dog_brewery_list,columns = ['brewery_name','city'])
dog_df.to_sql('dog_breweries',con=engine, if_exists='replace')

136

We now have two tables in our database. The two tables include:

breweries

column	type	description
brewery_id	text	unique brewery id
brewery_name	text	name of brewery
brewery_type	text	type of brewery (brewpub, micro, etc.)
address_1	text	building address
address_2	text	alternative address
address_3	text	alternative address
city	text	city of brewery
state_province	text	state or province of brewery
postal_code	text	postal code of brewery
country	text	country of brewery
phone	text	phone number of brewery
website_url	text	website of brewery
longitude	numeric	longitude coordinates
latitude	numeric	latitude coordinates

dog_breweries

column	type	description
brewery_name	text	name of brewery
city	text	city of brewery

We need to join our two tables together to determine which breweries are dog-friendly from our original breweries table. Before we conduct our join, we will clean the columns that we'll join on to make sure we can find the proper match in both tables.

%%sql

-- trim both city and name string sides of all spaces and replace any dashes or spaces with empty space on the breweries table
UPDATE breweries
SET name = rtrim (btrim (replace (replace (name, '-', ' '), '.', ''), ' '), '.'), city = btrim (city, ' ')

Running query in 'brewery_database'

8206 rows affected.

%%sql

-- trim both city and name string sides of all spaces and replace any dashes or spaces with empty space on the dog_breweries table
UPDATE dog_breweries
SET brewery_name = rtrim (btrim (replace (replace (brewery_name, '-', ' '), '.', ''), ' '), '.'), city = btrim (city, ' ')

Running query in 'brewery_database'

136 rows affected.

%%sql

-- Replace 'St.' with 'Saint' under the city column in the dog_breweries table
UPDATE dog_breweries
SET city = replace (city, 'St. Clair Shores', 'Saint Clair Shores')

Running query in 'brewery_database'

136 rows affected.

What we want to accomplish is an INNER JOIN between the two tables to only include breweries that both tables share. In doing so, we will only include breweries that are dog friendly while also now having access to their locations. Unfortunately, this is not as easy of a task as it seems. While the breweries table has unique id's for each brewery, the dog_breweries does not. Because of this, we will need to match the tables based on their names. This may seem straight-forward but there's a lot that can go wrong such as mispellings, mix-matched words, additional spaces, etc. Any of these would result in a failed match. Thankfully, we can use fuzzy string matching to help us combat this issue. We'll look for words that are similar to one another instead of perfect matches. For extra accuracy, we'll also only match breweries from both tables if both cities and the first word in the name also match.

%%sql

-- First, select all breweries in Michigan that are not 'TBD'. 
-- Then, grab all breweries in michigan where the names are similar, the cities match, and the first word in each name matches
SELECT *
FROM
   (SELECT *
    FROM breweries
    WHERE breweries.state_province = 'Michigan'
    AND breweries.name <> 'TBD') AS mich_brew
JOIN dog_breweries ON SIMILARITY (mich_brew.name, dog_breweries.brewery_name) > 0.2
and mich_brew.city = dog_breweries.city
and UPPER(SUBSTRING(mich_brew.name, 1, POSITION(' ' IN mich_brew.name))) = 
    UPPER(SUBSTRING(dog_breweries.brewery_name, 1, POSITION(' ' IN dog_breweries.brewery_name)))
ORDER BY mich_brew.name

Running query in 'brewery_database'

98 rows affected.

index	id	name	brewery_type	address_1	address_2	address_3	city	state_province	postal_code	country	phone	website_url	longitude	latitude	index_1	brewery_name	city_1
23	d5cb896d-3e99-4e19-9693-5e06ce987e53	127 Brewing	micro	3090 Shirley Dr	None	None	Jackson	Michigan	49201-7010	United States	5172581346	None	-84.43116792	42.28667212	0	127 Brewing	Jackson
433	ce507918-f969-4d44-a218-daca121c4bd0	Ascension Brewing Company	brewpub	42000 Grand River Ave	None	None	Novi	Michigan	48375-1831	United States	2483082093	http://www.ascension.beer	-83.4609783	42.4783271	5	Ascension Brewing Co	Novi
467	70fc7667-dda2-4cf0-ae7e-cbb43b5c43c4	Atwater Brewing Co	regional	237 Joseph Campau St	None	None	Detroit	Michigan	48207-4107	United States	3138779205	http://www.atwaterbeer.com	-83.072904	42.4190883	6	Atwater Brewery	Detroit
468	14693124-55bc-43e9-817e-b99a85f662ac	Atwater Grand Rapids	brewpub	201 Michigan St NW	None	None	Grand Rapids	Michigan	49503-2323	United States	6166493020	None	-85.672454	42.970463	8	Atwater Brewery	Grand Rapids
469	89d36a6d-1226-4c61-b4c6-22676a55a364	Atwater In the Park Biergarten and Tap House	brewpub	1175 Lakepointe St	None	None	Grosse Pointe Park	Michigan	48230-1319	United States	3133445104	http://www.atwaterbeer.com	-82.9399103	42.3814617	7	Atwater in the Park	Grosse Pointe Park
557	a79c77fa-dd4c-4e3f-bf34-c50ae8032f5c	Baffin Brewing Co	micro	25113 Jefferson Ave	None	None	Saint Clair Shores	Michigan	48081-2303	United States	5862187990	http://baffinbrewing.com	-82.888964	42.472227	9	Baffin Brewing Co	Saint Clair Shores
638	545b51b8-caf4-4c63-aea4-48910ddef4c7	Barn Brewers	brewpub	114 N Main St	None	None	Lawton	Michigan	49065-8634	United States	2692990482	http://www.barnbrewersbrewery.com	-85.84966443	42.16834814	10	Barn Brewery Brewers	Lawton
651	4fc60749-c0d0-4f94-ab92-e5bf566d455e	Barrel and Beam	micro	260 Northwoods RD	None	None	Marquette	Michigan	49855	United States	9062732559	http://www.barrelandbeam.com	-87.4722168	46.54578	11	Barrel + Beam	Marquette
684	e9ce69e2-13cf-48bd-81e2-10235db692aa	Batch Brewing Co	brewpub	1400 Porter St	None	None	Detroit	Michigan	48216-1934	United States	3133388008	http://www.BatchBrewingCompany.com	-83.088689	42.3184806	12	Batch Brewing Co	Detroit
847	71ed116d-2a0c-405f-9595-66b00f37030d	Biere De Mac Brew Works	micro	14277 N Mackinaw Hwy	None	None	Mackinaw City	Michigan	49701-8622	United States	2314277007	http://www.bieredemac.com	None	None	14	Biere De Mac Brew Works	Mackinaw City
1050	7e39a579-8605-49a5-9988-a4d594650d1e	Block Brewing Company	brewpub	1140 S Michigan Ave	None	None	Howell	Michigan	48843-2669	United States	None	http://www.blockbrewingcompany.com	-83.931806	42.603858	15	Block Brewing Co	Howell
1220	2de96915-c8c4-478d-ad67-0c8aa5828ab4	Brass Ring Brewery	brewpub	2404 Eastern Ave SE	None	None	Grand Rapids	Michigan	49507-3632	United States	6164601587	http://www.brassringbrewing.com	-85.64741488	42.91987422	17	Brass Ring Brewing	Grand Rapids
1293	783c1657-bb0f-4718-87eb-676a8094d167	Brewery Becker	brewpub	500 W Main St	None	None	Brighton	Michigan	48116-1471	United States	8108440225	http://www.brauereibecker.us	-83.785481	42.529522	18	Brewery Becker	Brighton
1298	e0bf1313-ecf0-45c9-8b70-8ed121ec6a27	Brewery Faisan	planning	None	None	None	Detroit	Michigan	48207	United States	5867032030	http://www.breweryfaisan.com	None	None	19	Brewery Faison	Detroit
1299	189be7db-796b-40db-87bf-daac88a4fac7	Brewery Ferment	micro	511 S Union St	None	None	Traverse City	Michigan	49684-3246	United States	2317358113	http://www.breweryferment.com	-85.62353552	44.75888715	20	Brewery Terra Firma	Traverse City
1305	b6de3e97-fdec-4ac0-924d-5775fa7006bf	Brewery Terra Firma	micro	2959 Hartman Rd	None	None	Traverse City	Michigan	49685-8838	United States	2319291600	http://www.breweryterrafirma.com	-85.63510581	44.71509875	20	Brewery Terra Firma	Traverse City
1375	0b3fde08-24cd-4523-b824-cf558568a608	Brite Eyes Brewing Co	brewpub	1156 S Burdick St	None	None	Kalamazoo	Michigan	49001-2741	United States	2692205001	None	-85.582846	42.27977268	21	Brite Eye Brewing Co	Kalamazoo
1738	b7f56781-add6-4bba-a3df-62a254f64971	Cheboygan Brewing Co	micro	101 N Main St	None	None	Cheboygan	Michigan	49721-1637	United States	2312683277	http://www.cheboyganbrewing.com	-84.4743633	45.647403	23	Cheboygan Brewing Co	Cheboygan
1791	6812d6f9-b113-48c1-902a-dd2b0f1e5874	City Built Brewing Company	brewpub	820 Monroe Ave NW Ste 155	None	None	Grand Rapids	Michigan	49503-1413	United States	6168055755	http://www.citybuiltbrewing.com	None	None	24	City Built Brewing Co	Grand Rapids
2129	70dbd577-56bb-4480-b51c-6f33123147d3	Dark Horse Brewing Co	micro	511 S Kalamazoo Ave	None	None	Marshall	Michigan	49068-1718	United States	2697819940	http://www.darkhorsebrewery.com	-84.96397652	42.26638824	27	Dark Horse Brewing Co	Marshall
2161	1d6ae265-d8dd-4a19-9524-801019b356c6	Dearborn Brewing	micro	21930 Michigan Ave	None	None	Dearborn	Michigan	48124-2351	United States	3139144187	http://www.dearbornbrewing.com	-83.2433835	42.30664415	28	Dearborn Brewing Co	Dearborn
2263	fd4412ec-311a-4e87-8b55-10dca2b00b94	Dimes Brewhouse	micro	145 N Bridge St	None	None	Dimondale	Michigan	48821-9201	United States	5173032067	http://www.dimesbrewhouse.com	-84.6483014	42.64660055	29	Dimes Brewhouse	Dimondale
2344	51421b18-93e4-4d09-b694-388dcb5df2fe	Downey Brewing Company	micro	13121 Prospect St	None	None	Dearborn	Michigan	48126-3603	United States	3132888442	http://www.downeybrewingcompany.com	-83.17350725	42.31625295	31	Downey Brewing Co	Dearborn
2465	497485a3-1317-450d-894b-0c079b1668b6	EB Coffee and Pub	brewpub	8980 N Rodgers Ct SE	None	None	Caledonia	Michigan	49316-8051	United States	6168917700	http://www.ebcoffeepub.com	-85.50839333	42.80145682	37	EB Coffee & Pub	Caledonia
2438	1996e0fa-b821-4d44-a6ea-d5fda91c7d47	EagleMonk Pub and Brewery	brewpub	4906 W Mount Hope Hwy	None	None	Lansing	Michigan	48917-9588	United States	5177087350	None	-84.662048	42.712054	34	EagleMonk Pub & Brewery	Lansing
2446	21a0d567-e70c-49fa-bb93-a073ed29e93b	Earthen Ales	micro	1371 Gray Dr Ste 200	None	None	Traverse City	Michigan	49684-7805	United States	2312524270	http://www.earthenales.com	-85.6454249	44.755294	35	Earthen Ales	Traverse City
2459	9ef70c89-a7e9-4759-a71e-4adca64c543a	Eastern Market Brewing Company	micro	2515 Riopelle St	None	None	Detroit	Michigan	48207-4526	United States	None	http://www.easternmarket.beer	-83.03876229	42.346625	36	Eastern Market Brewing Co	Detroit
2522	33420b64-b564-4d19-b134-364a4721e50f	Elk Street Brewery	brewpub	3 S Elk St	None	None	Sandusky	Michigan	48471-1353	United States	8103008049	http://www.elkstreetbrewery.com	-82.82977088	43.42036406	38	Elk Street Brewery	Sandusky
2591	b8b99a39-f008-4bde-9824-c5aaf4ba6b61	Eternity Brewing Co	micro	4060 E Grand River Ave	None	None	Howell	Michigan	48843-8583	United States	5172954904	http://www.eternitybrewing.com	-83.9948055	42.63273017	40	Eternity Brewing Co	Howell
2654	b2a43962-9a78-4e6d-882c-d3cb13129327	Farmington Brewing Company LLC	micro	33336 Grand River Ave	None	None	Farmington	Michigan	48336-3124	United States	2489579543	http://fbcbrewing.com	-83.37603742	42.4649541	41	Farmington Brewing Co	Farmington
2655	6cbd8d7c-b5af-4eda-802c-550643b62d42	Farmington Underground Canning and Kegging	micro	None	None	None	Farmington	Michigan	48336	United States	None	None	None	None	41	Farmington Brewing Co	Farmington
2689	2a824990-9f77-4b8a-ae7b-76aba05c5504	Fenton Winery & Brewery	brewpub	1370 N Long Lake Rd	None	None	Fenton	Michigan	48430-8867	United States	8103734194	http://www.fentonwinery.com	-83.70470876	42.85155557	42	Fenton Winery & Brewery	Fenton
3313	aca6e2d8-e3b8-4a29-b77b-f5d91b3179dc	Greenbush Annex	micro	5870 Sawyer Rd	None	None	Sawyer	Michigan	49125	United States	None	None	-86.59404729	41.88540971	49	Greenbush Brewing Co	Sawyer
3314	295e2956-574d-4cf1-a472-2df77d81bbc3	Greenbush Brewing Co	micro	5885 Sawyer Rd	None	None	Sawyer	Michigan	49125-9380	United States	2694051076	http://greenbushbrewing.com	-86.59431314	41.88557686	49	Greenbush Brewing Co	Sawyer
3349	91361172-9875-4337-8a10-e12765e47071	Grizzly Peak Brewing Co	brewpub	120 W Washington St Ste 1	None	None	Ann Arbor	Michigan	48104-1356	United States	7347417325	http://www.grizzlypeak.net	None	None	50	Grizzly Peak Brewing Co	Ann Arbor
3371	c67959ff-a884-4d4a-be84-a194b410b969	Guardian Brewing Company	planning	None	None	None	Saugatuck	Michigan	49453	United States	8125213611	http://www.guardianbrewingco.com	None	None	51	Guardian Brewing Co	Saugatuck
3636	bf32b0e2-4258-4f4a-9b72-744d0582034c	HOMES Brewery	brewpub	2321 Jackson Ave	None	None	Ann Arbor	Michigan	48103-3814	United States	7349546637	http://www.homesbrewery.com	-83.77845211	42.28032635	55	HOMES Brewery	Ann Arbor
3450	063bdb40-056e-489a-b952-0746b4b9e512	Harmony Brewing Co	brewpub	1551 Lake Dr SE	None	None	Grand Rapids	Michigan	49506-2705	United States	6162330063	None	-85.63066846	42.95501346	52	Harmony Brewing Co	Grand Rapids
3451	a3bd0375-cc0f-48cf-82f9-48151f0c411b	Harmony Brewing Company Harmony Hall	brewpub	401 Stocking Ave NW	None	None	Grand Rapids	Michigan	49504-5501	United States	None	None	-85.684118	42.970732	52	Harmony Brewing Co	Grand Rapids
3471	3b737ad4-2770-48e6-8897-644fa1886e7a	Haymarket Brewery and Taproom	micro	9301 Red Arrow Hwy	None	None	Bridgman	Michigan	49106-9558	United States	3126380707	None	-86.55947806	41.94715363	53	Haymarket Taproom	Bridgman
3633	3bc09d93-e165-4c5a-81ee-9228b5e3d54d	HomeGrown Brewing Company	brewpub	28 N Washington St	None	None	Oxford	Michigan	48371-4665	United States	2488918290	http://www.homegrownbrewco.com	-83.26650386	42.82656071	54	HomeGrown Brewing Co	Oxford
3947	9c26b2c6-1017-4c43-876b-17f7a0d1afa5	Jamesport Brewing Co	brewpub	410 S James St	None	None	Ludington	Michigan	49431-2159	United States	2318452522	http://www.jamesportbrewingcompany.com	-86.44787302	43.95168567	56	Jamesport Brewing Co	Ludington
3950	f5951169-a180-4970-aa22-28c534adf3a5	Jamex Brewing Co	micro	21721 Harper Ave	None	None	Saint Clair Shores	Michigan	48080-2213	United States	5869442030	http://www.jamexbrewing.com	-82.8986171	42.5171113	57	Jamex Brewing Co	Saint Clair Shores
4174	8a240e31-0084-4199-9c3b-ae9b40785cfa	Lake Ann Brewing Co	micro	6535 First St	None	None	Lake Ann	Michigan	49650-9549	United States	2316402327	http://www.lakeannbrewing.com	None	None	59	Lake Ann Brewing Co	Lake Ann
4295	e8496c18-2615-4e81-a29f-ea64ea88269c	Les Cheneaux Distillers	brewpub	172 S Meridian St	None	None	Cedarville	Michigan	49719	United States	9064841213	http://www.lescheneauxdistillers.com	-84.36301089	45.99742724	60	Les Cheneaux Distillers	Cedarville
4511	1d395c71-54a6-4af8-a0a3-21f5946f49ee	Ludington Bay Brewing Co	brewpub	515 S James St	None	None	Ludington	Michigan	49431-2325	United States	2312396690	http://ludingtonbaybrewing.com	-86.44763415	43.95070214	63	Ludington Bay Brewing Co	Ludington
4765	b43a8593-0e7e-42dd-b3f1-0c1ec9da44bf	Michigan Brewing Works	brewpub	3435 Dietz Rd	None	None	Williamston	Michigan	48895-9506	United States	5176557777	None	None	None	65	Michigan Brew Works & Garlic Farm	Williamston
4773	146870a5-aad1-4b3a-9b25-c4af2a711f1a	Midland Brewing Co	brewpub	5011 N Saginaw Road	None	None	Midland	Michigan	48642	United States	9892597210	http://www.midlandbrewing.com	-84.2910925	43.6408678	68	Midland Brewing Co	Midland
4943	82718ba8-c506-467b-88e2-5f5b714a4999	Motor City Brewing Works	brewpub	470 W Canfield St	None	None	Detroit	Michigan	48201-1220	United States	3138322700	http://www.motorcitybeer.com	-83.06603733	42.3518156	69	Motor City Brewing Works	Detroit
4944	9a7bc77f-ac7d-4ed8-bb95-3f374523a01f	Motor City Brewing Works Warehouse	micro	441 W Canfield St	None	None	Detroit	Michigan	48201-1231	United States	None	None	-83.06474893	42.35151997	69	Motor City Brewing Works	Detroit
5145	2fe4a822-2435-4f5c-bebf-66a40909e8d4	North Center Brewing Co	brewpub	410 N Center St	None	None	Northville	Michigan	48167-1224	United States	2484447967	http://www.northcenterbrewing.com	-83.48311135	42.43412107	72	North Center Brewing Co	Northville
5146	2983edd7-074e-4a0e-970f-6fc938c07e94	North Channel Brewing Co	brewpub	86 Washington St	None	None	Manistee	Michigan	49660-1231	United States	2312991020	http://www.NorthChannelBrewing.com	-86.32379888	44.24929388	73	North Channel Brewing	Manistee
5162	8e765472-33c8-4e1d-8923-20973d75e6f4	North Pier Brewing	micro	670 N Shore Dr	None	None	Benton Harbor	Michigan	49022-3646	United States	2697577163	http://www.northpierbrewing.com	-86.45499315	42.12454349	75	North Pier Brewing Co	Benton Harbor
5176	e19854be-9a28-4587-b055-90e13fcbd7fb	Northville Winery and Brewery	micro	630 Old Baseline Rd	None	None	Northville	Michigan	48167	United States	2483206507	None	None	None	76	Northville Winery and Brewing Co	Northville
5396	b778b875-6f29-41fc-94f9-23c09e872530	Ore Dock Brewing Co	micro	114 W Spring St	None	None	Marquette	Michigan	49855-4608	United States	9068675309	http://www.oredockbrewingcompany.com	-87.39388593	46.54189135	78	Ore Dock Brewing Co	Marquette
5401	39db40da-0ee5-465d-9a9a-38f9eb51ba09	Original Gravity Brewing Co	brewpub	440 County St	None	None	Milan	Michigan	48160-1504	United States	7344397490	http://www.ogbrewing.com	-83.67523597	42.083974	79	Original Gravity Brewing Co	Milan
5474	6ea02eb4-7386-46bf-ac13-fc452dabc976	Paddle Hard Brewing	brewpub	227 E Michigan Ave	None	None	Grayling	Michigan	49738-1742	United States	9897456388	None	-84.71675164	44.6600473	80	Paddle Hard Brewing	Grayling
5473	4c9cdd7b-ea79-4d81-b629-fbfdf899dce6	Paddle Hard Brewing	micro	118 Michigan Ave	None	None	Grayling	Michigan	49738-1741	United States	9897456388	http://paddlehardbrewing.com	-84.709584	44.66521	80	Paddle Hard Brewing	Grayling
5590	067530c6-4848-4418-9a45-92dd720cc681	Petoskey Brewing	micro	1844 M 119 Harbor-Petoskey Rd	None	None	Petoskey	Michigan	49770-9341	United States	2317532057	http://www.petoskeybrewing.com	None	None	81	Petoskey Brewing Co	Petoskey
5613	88293b57-bdc4-4fb7-afb4-1de24a9e82e9	Pigeon Hill Brewery Production Facility	planning	None	None	None	Muskegon	Michigan	49440-1109	United States	None	None	None	None	82	Pigeon Hill Brewing Co	Muskegon
5614	c7296318-3def-485e-9f58-b76d2db04b25	Pigeon Hill Brewing Co	micro	500 W Western Ave Ste 100	None	None	Muskegon	Michigan	49440-1000	United States	2313755184	http://www.pigeonhillbrew.com	None	None	82	Pigeon Hill Brewing Co	Muskegon
5884	305b584c-df57-4c6f-98d2-491736bbe7e9	Rare Bird Brewpub	brewpub	229 Lake Ave	None	None	Traverse City	Michigan	49684-2532	United States	2319432053	http://rarebirdbrewpub.com	-85.61932337	44.75978039	85	Rare Bird Brewpub	Traverse City
5954	396f0a00-1910-4667-a65d-79ce19556af7	Redline Brewing Company	micro	5470 Lapeer Rd	None	None	Burton	Michigan	48509-2235	United States	8102592009	http://redlinebrewingcompany.com	-83.59795244	43.01100775	86	Redline Brewing Co	Burton
6087	54dbff86-41fe-421c-937e-2903bac3c9f7	Rochester Mills Production Brewery	micro	3275 Lapeer W Rd	None	None	Auburn Hills	Michigan	48326-1723	United States	2483773130	http://www.beercos.com	None	None	88	Rochester Mills Production Brewery	Auburn Hills
6161	bbc83a19-c5a5-44f1-bf6f-969f209cdfc0	Rolling Oak Brewing Co	micro	509 Norway St	None	None	Grayling	Michigan	49738-1719	United States	9897456280	http://rollingoakbrewing.com	-84.716671	44.661765	89	Rolling Oak Brewing Co	Grayling
6188	0654ac67-ff7f-4b63-a876-bbd24a31fb57	Round Barn Brewery & Public House	micro	9151 First St	None	None	Baroda	Michigan	49101-8927	United States	2693267059	http://www.roundbarnbrewery.com	None	None	90	Round Barn Winery, Distillery, Brewery	Baroda
6187	eb65fa0c-3e45-41cb-bcc3-de1a1060b67e	Round Barn Brewery / Round Barn Winery	micro	10983 Hills Rd	None	None	Baroda	Michigan	49101-8742	United States	8007169463	http://www.roundbarnwinery.com	-86.479395	41.950161	90	Round Barn Winery, Distillery, Brewery	Baroda
6236	5bc03c91-fce7-4e14-9aeb-05303d7e6bbb	Rustic Leaf Brewing Company	micro	7200 Highland Rd	None	None	Waterford	Michigan	48327-1506	United States	2485999933	http://www.rusticleafbrewingcompany.com	-83.4048664	42.659901	91	Rustic Leaf Brewing Co	Waterford
6311	75b2ab04-6d86-4928-8953-d60c4b1c172e	Sandhill Crane Vineyards	micro	4724 Walz Rd	None	None	Jackson	Michigan	49201-9613	United States	5177640679	http://www.sandhillcranevineyards.com	None	None	94	Sandhill Crane Vineyards	Jackson
6515	74f8802c-da96-40d7-8e37-3fd4dd2cb381	Silver Harbor Brewing Company	brewpub	721 Pleasant St	None	None	Saint Joseph	Michigan	49085-1241	United States	2692817100	http://silverharborbrewing.com	-86.48027459	42.10893033	99	Silver Harbor Brewing Co	Saint Joseph
6621	3467fc4d-c507-46c1-a962-31d470bb204c	Snowbelt Brewing Company	brewpub	132 W Main St Unit 1	None	None	Gaylord	Michigan	49735-2304	United States	9894487077	None	None	None	101	Snowbelt Brewing Co	Gaylord
6748	e2876f5d-0f50-4cae-8d00-76b8edfe7ba0	St Ambrose Cellars	micro	841 S Pioneer Rd	None	None	Beulah	Michigan	49617	United States	2313834262	http://www.stambrose-mead-wine.com	None	None	102	St Ambrose Cellars	Beulah
6786	481a0ead-5e95-451e-a431-ba8972b7e5ea	Starving Artist Brewing	micro	634 S Stiles Rd	None	None	Ludington	Michigan	49431-9311	United States	2317941399	http://starvingartist.beer	None	None	103	Starving Artist Brewing Co	Ludington
6874	906c9e56-8260-4ea5-ade4-4d73e3dd7246	Stormcloud Brewing Company	brewpub	303 Main St	None	None	Frankfort	Michigan	49635-9047	United States	2316519080	http://www.stormcloudbrewing.com	-86.24100175	44.63290605	105	Stormcloud Brewing Co	Frankfort
6874	906c9e56-8260-4ea5-ade4-4d73e3dd7246	Stormcloud Brewing Company	brewpub	303 Main St	None	None	Frankfort	Michigan	49635-9047	United States	2316519080	http://www.stormcloudbrewing.com	-86.24100175	44.63290605	106	Stormcloud Brewery & Parkview Taproom	Frankfort
6875	3ba0c759-64a6-4c73-8f41-d5d2317ce86d	Stormcloud Brewing Company Production Facility	micro	366 Parkview Ln	None	None	Frankfort	Michigan	49635	United States	None	None	-86.2218117	44.6373933	106	Stormcloud Brewery & Parkview Taproom	Frankfort
6875	3ba0c759-64a6-4c73-8f41-d5d2317ce86d	Stormcloud Brewing Company Production Facility	micro	366 Parkview Ln	None	None	Frankfort	Michigan	49635	United States	None	None	-86.2218117	44.6373933	105	Stormcloud Brewing Co	Frankfort
7046	3bc7477e-6b51-4ec4-9879-106902e23f21	Tecumseh Brewing Company	brewpub	128 W Chicago Blvd	None	None	Tecumseh	Michigan	49286-1553	United States	5178151726	http://www.tecumsehbrewingco.com	-83.946191	42.004052	107	Tecumseh Brewing Co	Tecumseh
7067	00a78d20-3da2-4f63-9270-44b4722f4883	Tenacity Brewing	micro	119 N Grand Traverse St	None	None	Flint	Michigan	48503-5620	United States	8103396676	http://www.tenacitybrewing.com	-83.69663179	43.01522788	108	Tenacity Brewery	Flint
7150	ad43dd25-02a6-4196-b268-afb686787e37	The Distant Whistle Brewhouse	micro	118 S Main St	None	None	Vicksburg	Michigan	49097-1289	United States	2693707549	http://www.distantwhistle.com	-85.53248776	42.11909502	110	The Distant Whistle Brewhouse	Vicksburg
7161	2d83cc3f-3967-41ae-a3b9-7cd75c40edc3	The Filling Station Microbrewery	micro	642 Railroad Pl	None	None	Traverse City	Michigan	49686-3633	United States	2319468168	http://www.thefillingstationmicrobrewery.com	-85.609476	44.7580963	111	The Filling Station Microbrewery	Traverse City
7182	fedd7659-93ad-477b-b1fd-114ea7286a0b	The Highway Brewing Co	brewpub	209 W Houghton Ave	None	None	West Branch	Michigan	48661-1219	United States	9897090716	http://www.highwaybrewingco.com	-84.23751651	44.27635208	112	The Highway Brewing Co	West Branch
7199	81af98d0-0d70-4e84-8b4f-2804dd75e227	The Livery	brewpub	190 5th St	None	None	Benton Harbor	Michigan	49022-3484	United States	2699258760	http://www.liverybrew.com	-86.45330019	42.11813538	113	The Livery	Benton Harbor
7213	7550c372-1e49-49f5-b7d9-764e260fdba5	The Mitten Brewing Company Saugatuck	brewpub	329 Water St	None	None	Saugatuck	Michigan	49453	United States	6166085612	None	-86.20524129	42.65689129	115	The Mitten Brewing Co	Saugatuck
7294	33253e4f-6acd-4cf7-8ed6-2fbabee79b2b	Third Nature Brewing Co	planning	None	None	None	Rockford	Michigan	49341	United States	None	None	None	None	117	Third Nature Brewing Co	Rockford
7373	37cde8b1-1aaf-4181-aee9-e6481769d59c	Tilted Axis Brewing Company	brewpub	303 W Nepessing St	None	None	Lapeer	Michigan	48446-2105	United States	8109694477	http://www.tiltedaxis.beer	-83.31247549	43.05377576	121	Tilted Axis Brewing Co	Lapeer
7438	8e300f8a-fce3-446f-bbb4-aac35ff1a08e	Townies Brewery	brewpub	2350 W Liberty Rd	None	None	Ann Arbor	Michigan	48103	United States	None	None	-83.7891745	42.2730356	122	Townies Brewery	Ann Arbor
7453	9a256c21-3a8b-480b-9cb5-fc52084fedca	Traffic Jam and Snug	brewpub	4268 2nd Ave	None	None	Detroit	Michigan	48201-1706	United States	3138319470	http://www.trafficjamdetroit.com	-83.086546	42.384371	123	Traffic Jam & Snug	Detroit
7456	4ed098f5-5ff6-40b9-b238-538961222e90	Trail Point Brewing Co	micro	6035 Lake Michigan Dr	None	None	Allendale	Michigan	49401-9101	United States	6168952739	http://www.trailpointbrewing.com	-85.93541536	42.97207782	124	Trail Point Brewing Co	Allendale
7458	c9f36d18-efb4-419c-8acf-b4598bbf2326	Transient Artisan Ales	micro	4229 Lake St	None	None	Bridgman	Michigan	49106-9109	United States	None	None	-86.55570937	41.94299804	125	Transient Artisan Ales	Bridgman
7473	100fc1b1-c30f-4aeb-80bd-ab2914e7483a	Tri City Brewing Co	micro	4170 Shrestha Dr	None	None	Bay City	Michigan	48706-2184	United States	9896861340	http://www.tricitybrewing.com	None	None	126	Tri City Brewing Co	Bay City
7657	fe976b5b-744d-4ba8-b9b8-af2c2e249b8b	Upper Hand Brewery	micro	3525 Airport Rd	None	None	Escanaba	Michigan	49829-1096	United States	2693822338	http://www.upperhandbrewery.com	-87.097528	45.7164279	128	Upper Hand Brewery	Escanaba
7683	eae54355-ebca-400e-a9d9-7ce4ce866341	Urbanrest Brewing Company	micro	2615 Wolcott St	None	None	Ferndale	Michigan	48220-1422	United States	None	http://www.urbanrest.com	-83.1274188	42.4679929	130	Urbanrest Brewing Co	Ferndale
7810	86ac6974-4c49-4e84-8d51-47f97fda5ac4	WAR WATER BREWERY	brewpub	201 N Riverside Ave Ste C1-11	None	None	Saint Clair	Michigan	48079-5498	United States	8102893921	http://www.warwaterbrewery.com	None	None	131	War Water Brewery/Distillery	Saint Clair
7835	309cfb01-0cde-4775-91c6-95e492b5eb4b	Watermark Brewing Company	micro	5781 Saint Joseph Ave	None	None	Stevensville	Michigan	49127-1238	United States	2692810872	http://www.watermarkbrewing.com	-86.51963025	42.01286668	132	Watermark Brewing Co	Stevensville
7841	8e46e558-55b6-4c93-bf99-2ba3f2ba2a59	Waypost Brewing Co	planning	None	None	None	Fennville	Michigan	49408	United States	6169162362	http://waypostbeer.com	None	None	133	Waypost Brewing Co	Fennville
8015	fd24f694-6436-458c-a0d5-d35ab5ff4497	Witch's Hat Brewing	micro	601 S Lafayette St	None	None	South Lyon	Michigan	48178-1453	United States	2484862595	http://www.witchshatbrewing.com	-83.65099308	42.45542522	134	Witch's Hat Brewing Co	South Lyon
8027	932f3a05-590e-49dc-bba5-0c6c7c174125	Wolverine State Brewing Co	brewpub	2019 W Stadium Blvd # 103	None	None	Ann Arbor	Michigan	48103-4557	United States	7343692990	http://www.wolverinebeer.com	-83.7745473	42.2694316	135	Wolverine State Brewing	Ann Arbor

Nice! We found 98 matches between the two tables! With a smaller data set such as this, we could alternatively download the dataset into excel and manually check for matching breweries as well.

Now that we have a dataset of dog-friendly breweries, let's create a data viz! We'll first upload the data into a new SQL table, then we'll connect the data to Tableau and build our data viz.

%%sql

CREATE TABLE dog_brewery_join AS
SELECT id, name, brewery_type, address_1, mich_brew.city, state_province, postal_code, country, phone, longitude, latitude
FROM
  (SELECT *
   FROM breweries
   WHERE breweries.state_province = 'Michigan'
   AND breweries.name <> 'TBD'
  )AS mich_brew
JOIN dog_breweries ON SIMILARITY (mich_brew.name, dog_breweries.brewery_name) > 0.2
and mich_brew.city = dog_breweries.city
and UPPER(SUBSTRING(mich_brew.name, 1, POSITION(' ' IN mich_brew.name))) = 
    UPPER(SUBSTRING(dog_breweries.brewery_name, 1, POSITION(' ' IN dog_breweries.brewery_name)))
ORDER BY mich_brew.name

Running query in 'brewery_database'

98 rows affected.

Tableau Dashboard Link: https://public.tableau.com/views/DogFriendlyMichiganBreweries/Dog-FriendlyBreweriesinMichigan?:language=en-US&:display_count=n&:origin=viz_share_link

%%HTML
<div class='tableauPlaceholder' id='viz1689990789504' style='position: relative'><noscript><a href='#'><img alt='Dog-Friendly Breweries in Michigan ' src='https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;Do&#47;DogFriendlyMichiganBreweries&#47;Dog-FriendlyBreweriesinMichigan&#47;1_rss.png' style='border: none' /></a></noscript><object class='tableauViz'  style='display:none;'><param name='host_url' value='https%3A%2F%2Fpublic.tableau.com%2F' /> <param name='embed_code_version' value='3' /> <param name='site_root' value='' /><param name='name' value='DogFriendlyMichiganBreweries&#47;Dog-FriendlyBreweriesinMichigan' /><param name='tabs' value='no' /><param name='toolbar' value='yes' /><param name='static_image' value='https:&#47;&#47;public.tableau.com&#47;static&#47;images&#47;Do&#47;DogFriendlyMichiganBreweries&#47;Dog-FriendlyBreweriesinMichigan&#47;1.png' /> <param name='animate_transition' value='yes' /><param name='display_static_image' value='yes' /><param name='display_spinner' value='yes' /><param name='display_overlay' value='yes' /><param name='display_count' value='yes' /><param name='language' value='en-US' /><param name='filter' value='publish=yes' /></object></div>                <script type='text/javascript'>                    var divElement = document.getElementById('viz1689990789504');                    var vizElement = divElement.getElementsByTagName('object')[0];                    if ( divElement.offsetWidth > 800 ) { vizElement.style.width='100%';vizElement.style.height=(divElement.offsetWidth*0.75)+'px';} else if ( divElement.offsetWidth > 500 ) { vizElement.style.width='100%';vizElement.style.height=(divElement.offsetWidth*0.75)+'px';} else { vizElement.style.width='100%';vizElement.style.height='727px';}                     var scriptElement = document.createElement('script');                    scriptElement.src = 'https://public.tableau.com/javascripts/api/viz_v1.js';                    vizElement.parentNode.insertBefore(scriptElement, vizElement);                </script>

References

1. Bajaj, T. (2023, February 13). Program for distance between two points on earth. GeeksforGeeks. https://www.geeksforgeeks.org/program-distance-two-points-earth/

1. McKinney, K. (2022, July). Dog Friendly Breweries. Review Before Your Next Brew. https://michiganbreweryreview.com/michigan-dog-friendly-breweries/2018/8/2/the-ever-growing-list-of-k-9-friendly-breweries?format=amp

1. Chris Mears. Openbrewerydb. (2023). GitHub repository. https://github.com/openbrewerydb/openbrewerydb