Pietro's 2 Restaurant

VACAVILLE, CA 95688 · O3c0c9224fb9c · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: licensed1 licence

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
Pietro's 2 Restaurant 4 other
a licence name in capitals, cleaned (derived; record_title.py)
PIETROS 2 RESTAURANT ab-inbevvtinfo ×2
PIETROS NO. 2 ca-abctoast ×2
Pietro's No. 2 overture
pietros no. 2 vacaville doordash
Street
679 MERCHANT ST 1 other
ca-abc
679 Merchant Street doordash
City
VACAVILLE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95688
ca-abcno other value
Pin
38.40443, -121.93689 map 5 other
toast
7.7 km away ab-inbev
7.8 km away ca-abc
7.8 km away doordash
7.8 km away overture
7.8 km away vtinfo
Phone
7074484588
vtinfono other value
Licences
ca-abc 00650861|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O85723a715989; Od5671e837e2a; Oed95303b17b6; Of96ab799f23b; O9714fdcae4e7

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-inbevPIETROS 2 RESTAURANT
1346095
679 MERCHANT ST, VACAVILLE, CA, 9568838.35123, -121.992972026-11-112026-11-12
ca-abcPIETROS NO. 2
00650861|47|LIC|0
679 MERCHANT ST, VACAVILLE, CA, 9568838.35070, -121.993952026-10-082026-11-04
doordashpietros no. 2 vacaville
724913
679 Merchant Street, Vacaville, CA, 9568838.35064, -121.993722026-10-082026-11-13
overturePietro's No. 2
12df7937-c57e-48b7-866e-2dc9b843055e
679 Merchant St, Vacaville, CA, 95688707448458838.35077, -121.993822026-11-062026-11-06
toastPietros No 2
ab9eeae7-1a37-430e-ae05-e679fa570066
679 Merchant St, Vacaville, CA, 95688707448458838.40443, -121.936892026-11-062026-11-14
vtinfoPIETROS 2 RESTAURANT
5deae49097b0c077
679 MERCHANT ST, VACAVILLE, CA, 95688707448458838.35067, -121.993832026-11-142026-11-14

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 PIETROS 2 RESTAURANTvtinfo PIETROS 2 RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 97 m apart · name similarity 1.00
ca-abc PIETROS NO. 2doordash pietros no. 2 vacaville1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 21 m apart · name similarity 1.00
ca-abc PIETROS NO. 2overture Pietro's No. 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00
ca-abc PIETROS NO. 2toast Pietros No 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7773 m apart · name similarity 1.00
doordash pietros no. 2 vacavilleoverture Pietro's No. 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 17 m apart · name similarity 1.00
doordash pietros no. 2 vacavilletoast Pietros No 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7766 m apart · name similarity 1.00
overture Pietro's No. 2toast Pietros No 21.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 7760 m apart · name similarity 1.00 · phone: equal
ab-inbev PIETROS 2 RESTAURANTca-abc PIETROS NO. 20.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.89 · same street + ZIP · pins 103 m apart · name similarity 0.64
ab-inbev PIETROS 2 RESTAURANTdoordash pietros no. 2 vacaville0.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.89 · same street + city + state · pins 92 m apart · name similarity 0.64
ab-inbev PIETROS 2 RESTAURANToverture Pietro's No. 20.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.89 · same street + ZIP · pins 90 m apart · name similarity 0.64
ab-inbev PIETROS 2 RESTAURANTtoast Pietros No 20.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.89 · same street + city + state · pins 7674 m apart · name similarity 0.64
ca-abc PIETROS NO. 2vtinfo PIETROS 2 RESTAURANT0.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.89 · same street + ZIP · pins 11 m apart · name similarity 0.64
doordash pietros no. 2 vacavillevtinfo PIETROS 2 RESTAURANT0.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.89 · same street + ZIP · pins 10 m apart · name similarity 0.64
overture Pietro's No. 2vtinfo PIETROS 2 RESTAURANT0.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.89 · same street + ZIP · pins 11 m apart · name similarity 0.64 · phone: equal
toast Pietros No 2vtinfo PIETROS 2 RESTAURANT0.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant · name Jaro-Winkler 0.89 · same street + ZIP · pins 7769 m apart · name similarity 0.64 · phone: equal

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 9, computed 2026-11-17 18:21.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
1 within 1 mi · 138 within 3 mi
Off / on premise
1 / 0 within 1 mi · 43 / 79 within 3 mi
Selling alcohol
0 within 1 mi · 55 within 3 mi
Nearest
same channel 1.01 mi · licensed 1.03 mi
Setting
suburban (755 people per sq mi)
People within 3 mi
21,360 (16,367 adults 21+, 8,250 households) from 4 tract(s), tracts within 3 mi
Income
per capita $52,842 · median household ~$103,535 (weighted mean of tract medians)
Age and education
median age ~42.9 · bachelor's or higher 35%
Ethnicity
Hispanic 22% · White 58% · Black 5% · Asian 18%
Adults per alcohol outlet
292
Alcohol spend within 3 mi
$6,741,246 a year ($2,976,941 at home, $3,761,509 away) · $120,379 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-14 20:23insertca-abc 00650861|47|LIC|0 ↔ vtinfo 5deae49097b0c077same address and namemerged15
2026-11-14 20:23insertoverture 12df7937-c57e-48b7-866e-2dc9b843055e ↔ vtinfo 5deae49097b0c077same address and namemerged15
2026-11-14 20:23inserttoast ab9eeae7-1a37-430e-ae05-e679fa570066 ↔ vtinfo 5deae49097b0c077same address and namemerged15
2026-11-14 20:23insertdoordash 724913 ↔ vtinfo 5deae49097b0c077same address and namemerged15
2026-11-14 20:23insertab-inbev 1346095 ↔ vtinfo 5deae49097b0c077same address and namemerged15
2026-11-12 17:29insertab-inbev 1346095 ↔ toast ab9eeae7-1a37-430e-ae05-e679fa570066same address and namemerged14
2026-11-12 17:29insertab-inbev 1346095 ↔ doordash 724913same address and namemerged14
2026-11-12 17:29insertab-inbev 1346095 ↔ ca-abc 00650861|47|LIC|0same address and namemerged14
2026-11-12 17:29insertab-inbev 1346095 ↔ overture 12df7937-c57e-48b7-866e-2dc9b843055esame address and namemerged14
2026-11-12 14:25insertca-abc 00650861|47|LIC|0 ↔ doordash 724913same address and namemerged12
2026-11-12 14:25insertdoordash 724913 ↔ overture 12df7937-c57e-48b7-866e-2dc9b843055esame address and namemerged12
2026-11-12 14:25insertdoordash 724913 ↔ toast ab9eeae7-1a37-430e-ae05-e679fa570066same address and namemerged12
2026-11-06 18:13insertoverture 12df7937-c57e-48b7-866e-2dc9b843055e ↔ toast ab9eeae7-1a37-430e-ae05-e679fa570066same address and namemerged11
2026-11-06 18:13insertca-abc 00650861|47|LIC|0 ↔ toast ab9eeae7-1a37-430e-ae05-e679fa570066same address and namemerged11
2026-11-06 18:13insertca-abc 00650861|47|LIC|0 ↔ overture 12df7937-c57e-48b7-866e-2dc9b843055esame address and namemerged11