McGrail Vineyards and Winery

LIVERMORE, CA 94550 · O002e8fb0e8ee · first seen 2026-10-08
3 sourcesproducer · produceralcohol: 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
McGrail Vineyards and Winery 1 other
a source's own spelling of the licence name (record_title.py)
MCGRAIL VINEYARDS AND WINERY, LLC ttb
Street
5600 GREENVILLE RD
ca-abcno other value
City
LIVERMORE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94550
ca-abcno other value
Pin
37.65044, -121.69508 map 2 other
overture
129 m away ca-abc ×2
129 m away ttb
Phone
9252150717
overtureno other value
Licences
ca-abc 00527497|02|LIC|0 · ca-abc 00527497|81|LIC|0 · ttb CA-W-20500
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of49ffddce216; O2f36272e3963; Oe71ae35ee678; O6af44a11c89f; O2df0372d5ac3; O823e40f13340

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
ca-abcMCGRAIL VINEYARDS AND WINERY
00527497|02|LIC|0
5600 GREENVILLE RD, LIVERMORE, CA, 9455037.65054, -121.696532026-10-082026-11-03
ca-abcMCGRAIL VINEYARDS AND WINERY
00527497|81|LIC|0
5600 GREENVILLE RD, LIVERMORE, CA, 9455037.65054, -121.696532026-10-082026-11-03
overtureMcGrail Vineyards and Winery
f544f9f5-a779-49da-9d82-3e1c31aa9590
5600 Greenville Rd, Livermore, CA, 94550925215071737.65044, -121.695082026-11-062026-11-06
ttbMCGRAIL VINEYARDS AND WINERY, LLC
CA-W-20500
5600 GREENVILLE RD, LIVERMORE, CA, 9455037.65054, -121.696532026-11-032026-11-04

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
ca-abc MCGRAIL VINEYARDS AND WINERYca-abc MCGRAIL VINEYARDS AND WINERY1.00one licence filemergedfile: 00527497 · same_address
ca-abc MCGRAIL VINEYARDS AND WINERYmi-lcc L-0002701021.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc MCGRAIL VINEYARDS AND WINERYoverture McGrail Vineyards and Winery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 129 m apart · name similarity 1.00
ca-abc MCGRAIL VINEYARDS AND WINERYttb MCGRAIL VINEYARDS AND WINERY, LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc MCGRAIL VINEYARDS AND WINERYtx-tabc 1065705241.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc MCGRAIL VINEYARDS AND WINERYtx-tabc 2001491391.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc MCGRAIL VINEYARDS AND WINERYmi-lcc L-0002701021.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc MCGRAIL VINEYARDS AND WINERYoverture McGrail Vineyards and Winery1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 129 m apart · name similarity 1.00
ca-abc MCGRAIL VINEYARDS AND WINERYttb MCGRAIL VINEYARDS AND WINERY, LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc MCGRAIL VINEYARDS AND WINERYtx-tabc 1065705241.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ca-abc MCGRAIL VINEYARDS AND WINERYtx-tabc 2001491391.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
mi-lcc L-000270102ttb MCGRAIL VINEYARDS AND WINERY, LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture McGrail Vineyards and Wineryttb MCGRAIL VINEYARDS AND WINERY, LLC1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 129 m apart · name similarity 1.00
ttb MCGRAIL VINEYARDS AND WINERY, LLCtx-tabc 1065705241.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
ttb MCGRAIL VINEYARDS AND WINERY, LLCtx-tabc 2001491391.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00

Attributes

Channel
producer · producer — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MCGRAIL VINEYARDS AND WINERY, LLC — 1 outlets in the master under this operator
Licence privileges
wine_off — CA 02; CA 81
Rule version 11, computed 2026-11-20 23:31.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "producer",
   "producer"
  ]
 ]
}

Trade area

Other outlets
9 within 1 mi · 75 within 3 mi
Off / on premise
1 / 1 within 1 mi · 20 / 3 within 3 mi
Selling alcohol
9 within 1 mi · 74 within 3 mi
Nearest
same channel 0.13 mi · licensed 0.13 mi
Setting
rural (328 people per sq mi)
People within 3 mi
9,261 (6,744 adults 21+, 3,133 households) from 3 tract(s), tracts within 3 mi
Income
per capita $73,177 · median household ~$168,243 (weighted mean of tract medians)
Age and education
median age ~40.2 · bachelor's or higher 53%
Ethnicity
Hispanic 22% · White 57% · Black 4% · Asian 18%
Adults per alcohol outlet
90
Alcohol spend within 3 mi
$3,312,626 a year ($1,404,682 at home, $1,906,961 away) · $44,168 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-06 18:13insertoverture f544f9f5-a779-49da-9d82-3e1c31aa9590 ↔ ttb CA-W-20500same address and namemerged11
2026-11-06 18:13insertca-abc 00527497|81|LIC|0 ↔ overture f544f9f5-a779-49da-9d82-3e1c31aa9590same address and namemerged11
2026-11-06 18:13insertca-abc 00527497|02|LIC|0 ↔ overture f544f9f5-a779-49da-9d82-3e1c31aa9590same address and namemerged11
2026-11-03 13:33backfillmi-lcc L-000270102 ↔ ttb CA-W-20500same address and namemerged
2026-11-03 13:33backfillttb CA-W-20500 ↔ tx-tabc 200149139same address and namemerged
2026-11-03 13:33backfillttb CA-W-20500 ↔ tx-tabc 106570524same address and namemerged
2026-11-03 13:33backfillca-abc 00527497|81|LIC|0 ↔ ttb CA-W-20500same address and namemerged
2026-11-03 13:33backfillca-abc 00527497|81|LIC|0 ↔ mi-lcc L-000270102same address and namemerged
2026-11-03 13:33backfillca-abc 00527497|81|LIC|0 ↔ tx-tabc 200149139same address and namemerged
2026-11-03 13:33backfillca-abc 00527497|81|LIC|0 ↔ tx-tabc 106570524same address and namemerged
2026-11-03 13:33backfillca-abc 00527497|02|LIC|0 ↔ ttb CA-W-20500same address and namemerged
2026-11-03 13:33backfillca-abc 00527497|02|LIC|0 ↔ mi-lcc L-000270102same address and namemerged
2026-11-03 13:33backfillca-abc 00527497|02|LIC|0 ↔ tx-tabc 200149139same address and namemerged
2026-11-03 13:33backfillca-abc 00527497|02|LIC|0 ↔ tx-tabc 106570524same address and namemerged
2026-10-09 13:59backfillca-abc 00527497|02|LIC|0 ↔ ca-abc 00527497|81|LIC|0one licence filemerged