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.

FieldMaster valueTaken fromWhat 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-lccno other value
City
Traverse City
mi-lccno other value
State
MI
mi-lccno other value
ZIP
49686
mi-lccno other value
Pin
44.76431, -85.60062 map
overtureno other value
Phone
2319419463
vtinfono 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.

SourceNameAddressPhoneCoordinatesFirst seenUpdated
ab-inbevTHE BLUE GOAT
2523454
875 E FRONT ST, TRAVERSE CITY, MI, 4968644.76425, -85.600842026-11-112026-11-12
mi-lccBLUE GOAT WINE AND PROVISIONS
legal name: 51-41-31, LLC
L-000275153
875 E Front St, Traverse City, MI, 4968644.76421, -85.601112026-11-032026-11-06
mi-lccBLUE GOAT WINE AND PROVISIONS
legal name: 51-41-31, LLC
L-000454536
875 E Front St, Traverse City, MI, 4968644.76421, -85.601112026-11-032026-11-06
mi-lccBLUE GOAT WINE AND PROVISIONS
legal name: 51-41-31, LLC
L-000493348
875 E Front St, Traverse City, MI, 4968644.76421, -85.601112026-11-032026-11-06
overtureBlue Goat Wine and Provisions
d90b60e0-245e-427d-9801-0e034c3f87d3
875 E Front St, Traverse City, MI, 49686231941946344.76431, -85.600622026-11-062026-11-06
vtinfoTHE BLUE GOAT
0c4db959951ab9d9
875 E FRONT ST, TRAVERSE CITY, MI, 49686231941946344.76429, -85.600602026-11-162026-11-17

Matching

Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.

Record ARecord BName matchRuleDecisionEvidence
ab-inbev THE BLUE GOATvtinfo THE BLUE GOAT1.00same address and namemergedaddress 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 PROVISIONSmi-lcc BLUE GOAT WINE AND PROVISIONS1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc BLUE GOAT WINE AND PROVISIONSmi-lcc BLUE GOAT WINE AND PROVISIONS1.00one store listed twicemergedsame street + ZIP · name: identical
mi-lcc BLUE GOAT WINE AND PROVISIONSoverture Blue Goat Wine and Provisions1.00same address and namemergedaddress 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 PROVISIONSoverture Blue Goat Wine and Provisions1.00same address and namemergedaddress 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 PROVISIONSoverture Blue Goat Wine and Provisions1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 40 m apart · name similarity 1.00
ab-inbev THE BLUE GOATmi-lcc BLUE GOAT WINE AND PROVISIONS0.52Claude judge: samemerged
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:
  • Claude Opus 5.5, prompt v12: same, 90% confident — Blue Goat names match at same address
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records give the same street address in Traverse City (875 E Front St, ZIP 49686) with coordinates 0.022 km apart, and the only business at that address is 'The Blue Goat' / 'Blue Goat Wine and Provisions', so the distinctive shared name 'Blue Goat' points to one outlet.
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”).
WhenEventPairRuleDecisionRule version
2026-11-16 14:56insertab-inbev 2523454 ↔ vtinfo 0c4db959951ab9d9same address and namemerged15
2026-11-12 14:25insertab-inbev 2523454 ↔ mi-lcc L-000493348Claude judge: samemerged12
2026-11-06 18:13insertmi-lcc L-000493348 ↔ overture d90b60e0-245e-427d-9801-0e034c3f87d3same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000275153 ↔ overture d90b60e0-245e-427d-9801-0e034c3f87d3same address and namemerged11
2026-11-06 18:13insertmi-lcc L-000454536 ↔ overture d90b60e0-245e-427d-9801-0e034c3f87d3same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000275153 ↔ mi-lcc L-000493348one store listed twicemerged
2026-11-03 13:33backfillmi-lcc L-000275153 ↔ mi-lcc L-000454536one store listed twicemerged