Outlets /
Blue Goat Wine and Provisions
Traverse City, MI 49686 · O0ade898d4e04 · first seen 2026-11-03
4 sourcesoff premise · liquor_storealcohol: licensed3 licences
Golden record
One value per field, each taken from one source by a stated precedence (licence and chain locator first for the address, delivery apps for the pin). Where another source says something else, it is listed beside it.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Blue Goat Wine and Provisions 2 other | a source's own spelling of the licence name (record_title.py) | 51-41-31, LLC mi-lcc (legal name) ×3 THE BLUE GOAT ab-inbevvtinfo ×2 |
| Street | 875 E Front St | mi-lcc | no other value |
| City | Traverse City | mi-lcc | no other value |
| State | MI | mi-lcc | no other value |
| ZIP | 49686 | mi-lcc | no other value |
| Pin | 44.76431, -85.60062 map | overture | no other value |
| Phone | 2319419463 | vtinfo | no other value |
| Licences | mi-lcc L-000275153 · mi-lcc L-000454536 · mi-lcc L-000493348 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Ofb2e9f7368dc; Oc3b40c1d5af5; O7e2bf843d29e; O49f657cbbe2a; O1ab364d7c4ca
Carries
Products seen on this outlet’s shelf in store-level catalogs.
No store-level catalog lists this outlet. Shelf data comes from DoorDash, Meijer, Binny’s, ABC and Spec’s store catalogs; most outlets have none yet.
Sources
Every source record folded into this outlet, as the source states it.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | THE BLUE GOAT 2523454 | 875 E FRONT ST, TRAVERSE CITY, MI, 49686 | 44.76425, -85.60084 | 2026-11-11 | 2026-11-12 | |
| mi-lcc | BLUE GOAT WINE AND PROVISIONS legal name: 51-41-31, LLC L-000275153 | 875 E Front St, Traverse City, MI, 49686 | 44.76421, -85.60111 | 2026-11-03 | 2026-11-06 | |
| mi-lcc | BLUE GOAT WINE AND PROVISIONS legal name: 51-41-31, LLC L-000454536 | 875 E Front St, Traverse City, MI, 49686 | 44.76421, -85.60111 | 2026-11-03 | 2026-11-06 | |
| mi-lcc | BLUE GOAT WINE AND PROVISIONS legal name: 51-41-31, LLC L-000493348 | 875 E Front St, Traverse City, MI, 49686 | 44.76421, -85.60111 | 2026-11-03 | 2026-11-06 | |
| overture | Blue Goat Wine and Provisions d90b60e0-245e-427d-9801-0e034c3f87d3 | 875 E Front St, Traverse City, MI, 49686 | 2319419463 | 44.76431, -85.60062 | 2026-11-06 | 2026-11-06 |
| vtinfo | THE BLUE GOAT 0c4db959951ab9d9 | 875 E FRONT ST, TRAVERSE CITY, MI, 49686 | 2319419463 | 44.76429, -85.60060 | 2026-11-16 | 2026-11-17 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev THE BLUE GOAT | vtinfo THE BLUE GOAT | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00 |
| mi-lcc BLUE GOAT WINE AND PROVISIONS | mi-lcc BLUE GOAT WINE AND PROVISIONS | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| mi-lcc BLUE GOAT WINE AND PROVISIONS | mi-lcc BLUE GOAT WINE AND PROVISIONS | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| mi-lcc BLUE GOAT WINE AND PROVISIONS | overture Blue Goat Wine and Provisions | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00 |
| mi-lcc BLUE GOAT WINE AND PROVISIONS | overture Blue Goat Wine and Provisions | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00 |
| mi-lcc BLUE GOAT WINE AND PROVISIONS | overture Blue Goat Wine and Provisions | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00 |
| ab-inbev THE BLUE GOAT | mi-lcc BLUE GOAT WINE AND PROVISIONS | 0.52 | Claude judge: same | merged | Claude Opus 5.5, prompt v9 said same (94% confident; asked as a “near” pair) Same street address and ZIP, with only one business recorded there, and 'The Blue Goat' is the short form of the distinctive name 'Blue Goat Wine and Provisions'. Other Claude answers on this pair:
pair 04b13319161d1948c6cb |
Attributes
- Channel
- off_premise · liquor_store — overture-category
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- 51-41-31, LLC — 1 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off, spirits_on, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant; MI Retail - On Premises/Class C
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
"votes": [
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 101 within 1 mi · 338 within 3 mi
- Off / on premise
- 17 / 50 within 1 mi · 73 / 158 within 3 mi
- Selling alcohol
- 66 within 1 mi · 222 within 3 mi
- Nearest
- same channel 0.28 mi · licensed 0.25 mi
- Setting
- suburban (924 people per sq mi)
- People within 3 mi
- 26,116 (20,574 adults 21+, 12,370 households) from 7 tract(s), tracts within 3 mi
- Income
- per capita $41,417 · median household ~$64,913 (weighted mean of tract medians)
- Age and education
- median age ~42.6 · bachelor's or higher 38%
- Ethnicity
- Hispanic 4% · White 89% · Black 1% · Asian 1%
- Adults per alcohol outlet
- 92
- Alcohol spend within 3 mi
- $6,865,644 a year ($3,271,914 at home, $3,590,629 away) · $30,788 per alcohol outlet — CEX 2023 dollars; an index, not this outlet's sales
Computed 2026-11-17 01:05.
History
Every change to a link of these records, newest first (kept since 2026-11-06; earlier links appear once, as “backfill”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-16 14:56 | insert | ab-inbev 2523454 ↔ vtinfo 0c4db959951ab9d9 | same address and name | merged | 15 |
| 2026-11-12 14:25 | insert | ab-inbev 2523454 ↔ mi-lcc L-000493348 | Claude judge: same | merged | 12 |
| 2026-11-06 18:13 | insert | mi-lcc L-000493348 ↔ overture d90b60e0-245e-427d-9801-0e034c3f87d3 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | mi-lcc L-000275153 ↔ overture d90b60e0-245e-427d-9801-0e034c3f87d3 | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | mi-lcc L-000454536 ↔ overture d90b60e0-245e-427d-9801-0e034c3f87d3 | same address and name | merged | 11 |
| 2026-11-03 13:33 | backfill | mi-lcc L-000275153 ↔ mi-lcc L-000493348 | one store listed twice | merged | |
| 2026-11-03 13:33 | backfill | mi-lcc L-000275153 ↔ mi-lcc L-000454536 | one store listed twice | merged |