Outlets /
Pietro's
VACAVILLE, CA 95688 · O1f3f25091924 · first seen 2026-10-08
6 sourceson premise · restaurantalcohol: licensed2 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 | Pietro's 4 other | a licence name in capitals, cleaned (derived; record_title.py) | Pietro's No. 1 overtureubereats ×2 PIETROS ab-inbevvtinfo ×2 PIETROS NO 1 INC ca-abc ×2 pietro's no. 1 vacaville doordash |
| Street | 407 CERNON ST 1 other | ca-abc | 407 Cernon Street doordash |
| City | VACAVILLE | ca-abc | no other value |
| State | CA | ca-abc | no other value |
| ZIP | 95688 | ca-abc | no other value |
| Pin | 38.35475, -121.99085 map | ubereats | no other value |
| Phone | 7074461771 | vtinfo | no other value |
| Licences | ca-abc 00107248|47|APP|0 · ca-abc 00107248|47|LIC|0 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: Oa3e527245515; O56146b3f847e; Obe4cd18e9035; Of8c3f77ad4ed; Oc9cb00248da9; O4bdb393bfcaa
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 | PIETROS 1346094 | 407 CERNON ST, VACAVILLE, CA, 95688 | 38.35442, -121.99092 | 2026-11-11 | 2026-11-14 | |
| ca-abc | PIETROS NO 1 INC 00107248|47|APP|0 | 407 CERNON ST, VACAVILLE, CA, 95688 | 38.35481, -121.99096 | 2026-10-08 | 2026-11-14 | |
| ca-abc | PIETROS NO 1 INC 00107248|47|LIC|0 | 407 CERNON ST, VACAVILLE, CA, 95688 | 38.35481, -121.99096 | 2026-10-08 | 2026-11-14 | |
| doordash | pietro's no. 1 vacaville 803502 | 407 Cernon Street, Vacaville, CA, 95688 | 38.35469, -121.99091 | 2026-10-08 | 2026-11-14 | |
| overture | Pietro's No. 1 deb9f5b9-3f6b-421b-915f-736732c285bd | 407 Cernon St, Vacaville, CA, 95688 | 7074461771 | 38.35473, -121.99090 | 2026-11-06 | 2026-11-14 |
| ubereats | Pietro's No 1 uAbzTTxGTmubv1jGd5__7w | 407 Cernon St, Vacaville, CA, 95688 | 38.35475, -121.99085 | 2026-10-13 | 2026-11-14 | |
| vtinfo | PIETROS 3d4fe0996a4bfbb1 | 407 CERNON ST, VACAVILLE, CA, 95688 | 7074461771 | 38.35472, -121.99086 | 2026-11-14 | 2026-11-14 |
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 PIETROS | vtinfo PIETROS | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 33 m apart · name similarity 1.00 |
| ca-abc PIETROS NO 1 INC | ca-abc PIETROS NO 1 INC | 1.00 | one licence file | merged | file: 00107248 · same_address |
| ca-abc PIETROS NO 1 INC | doordash pietro's no. 1 vacaville | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 |
| ca-abc PIETROS NO 1 INC | overture Pietro's No. 1 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00 |
| ca-abc PIETROS NO 1 INC | doordash pietro's no. 1 vacaville | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 13 m apart · name similarity 1.00 |
| ca-abc PIETROS NO 1 INC | overture Pietro's No. 1 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00 |
| doordash pietro's no. 1 vacaville | overture Pietro's No. 1 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00 |
| doordash pietro's no. 1 vacaville | ubereats Pietro's No 1 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 8 m apart · name similarity 1.00 |
| overture Pietro's No. 1 | ubereats Pietro's No 1 | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 4 m apart · name similarity 1.00 |
| ab-inbev PIETROS | ca-abc PIETROS NO 1 INC | 0.69 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 43 m apart · name similarity 0.69 |
| ab-inbev PIETROS | ca-abc PIETROS NO 1 INC | 0.69 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 43 m apart · name similarity 0.69 |
| ab-inbev PIETROS | doordash pietro's no. 1 vacaville | 0.69 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 31 m apart · name similarity 0.69 |
| ab-inbev PIETROS | overture Pietro's No. 1 | 0.69 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 35 m apart · name similarity 0.69 |
| ab-inbev PIETROS | ubereats Pietro's No 1 | 0.69 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 37 m apart · name similarity 0.69 |
| ca-abc PIETROS NO 1 INC | vtinfo PIETROS | 0.69 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 13 m apart · name similarity 0.69 |
| ca-abc PIETROS NO 1 INC | vtinfo PIETROS | 0.69 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 13 m apart · name similarity 0.69 |
| doordash pietro's no. 1 vacaville | vtinfo PIETROS | 0.69 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 4 m apart · name similarity 0.69 |
| overture Pietro's No. 1 | vtinfo PIETROS | 0.69 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 4 m apart · name similarity 0.69 · phone: equal |
| ubereats Pietro's No 1 | vtinfo PIETROS | 0.69 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 4 m apart · name similarity 0.69 |
| ca-abc PIETROS NO 1 INC | ubereats Pietro's No 1 | 0.60 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “near” pair) The legal entity 'PIETROS NO 1 INC' and the trade name 'Pietro's No 1' match exactly, at the same street address and ZIP, so it is one restaurant despite the shared building. Other Claude answers on this pair:
pair 2d3ecce88d4437115840 |
| ca-abc PIETROS NO 1 INC | ubereats Pietro's No 1 | 0.60 | Claude judge: same | merged | Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “near” pair) The legal entity 'PIETROS NO 1 INC' and the trade name 'Pietro's No 1' are at the identical street address and ZIP, and the matching distinctive name confirms one restaurant despite the shared buildin Other Claude answers on this pair:
pair 5dd892632a24d2e545b2 |
Attributes
- Channel
- on_premise · restaurant — ca-licence
- Chain
- none
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- PIETROS NO 1 INC — 1 outlets in the master under this operator
- Licence privileges
- beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
"ue_location": [
"DEFAULT"
],
"votes": [
[
"ca-licence",
"on_premise",
"restaurant"
],
[
"doordash-url",
"on_premise",
"restaurant"
],
[
"overture-category",
"on_premise",
"restaurant"
]
]
}Trade area
- Other outlets
- 156 within 1 mi · 401 within 3 mi
- Off / on premise
- 44 / 95 within 1 mi · 115 / 242 within 3 mi
- Selling alcohol
- 107 within 1 mi · 218 within 3 mi
- Nearest
- same channel 0.07 mi · licensed 0.02 mi
- Setting
- suburban (2,822 people per sq mi)
- People within 3 mi
- 79,781 (60,390 adults 21+, 27,221 households) from 17 tract(s), tracts within 3 mi
- Income
- per capita $43,286 · median household ~$104,475 (weighted mean of tract medians)
- Age and education
- median age ~40.1 · bachelor's or higher 25%
- Ethnicity
- Hispanic 30% · White 54% · Black 9% · Asian 8%
- Adults per alcohol outlet
- 276
- Alcohol spend within 3 mi
- $21,472,247 a year ($9,544,881 at home, $11,918,268 away) · $98,047 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-14 20:23 | insert | ca-abc 00107248|47|LIC|0 ↔ vtinfo 3d4fe0996a4bfbb1 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | ca-abc 00107248|47|APP|0 ↔ vtinfo 3d4fe0996a4bfbb1 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | doordash 803502 ↔ vtinfo 3d4fe0996a4bfbb1 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | overture deb9f5b9-3f6b-421b-915f-736732c285bd ↔ vtinfo 3d4fe0996a4bfbb1 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | ubereats uAbzTTxGTmubv1jGd5__7w ↔ vtinfo 3d4fe0996a4bfbb1 | same address and name | merged | 15 |
| 2026-11-14 20:23 | insert | ab-inbev 1346094 ↔ vtinfo 3d4fe0996a4bfbb1 | same address and name | merged | 15 |
| 2026-11-11 12:56 | insert | ab-inbev 1346094 ↔ overture deb9f5b9-3f6b-421b-915f-736732c285bd | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 1346094 ↔ doordash 803502 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 1346094 ↔ ubereats uAbzTTxGTmubv1jGd5__7w | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 1346094 ↔ ca-abc 00107248|47|LIC|0 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ab-inbev 1346094 ↔ ca-abc 00107248|47|APP|0 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | doordash 803502 ↔ overture deb9f5b9-3f6b-421b-915f-736732c285bd | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | doordash 803502 ↔ ubereats uAbzTTxGTmubv1jGd5__7w | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00107248|47|LIC|0 ↔ doordash 803502 | same address and name | merged | 12 |
| 2026-11-11 12:56 | insert | ca-abc 00107248|47|APP|0 ↔ doordash 803502 | same address and name | merged | 12 |
| 2026-11-06 18:13 | insert | overture deb9f5b9-3f6b-421b-915f-736732c285bd ↔ ubereats uAbzTTxGTmubv1jGd5__7w | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00107248|47|LIC|0 ↔ overture deb9f5b9-3f6b-421b-915f-736732c285bd | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | ca-abc 00107248|47|APP|0 ↔ overture deb9f5b9-3f6b-421b-915f-736732c285bd | same address and name | merged | 11 |
| 2026-11-02 23:02 | backfill | ca-abc 00107248|47|LIC|0 ↔ ubereats uAbzTTxGTmubv1jGd5__7w | Claude judge: same | merged | |
| 2026-11-02 23:02 | backfill | ca-abc 00107248|47|APP|0 ↔ ubereats uAbzTTxGTmubv1jGd5__7w | Claude judge: same | merged | |
| 2026-10-09 13:59 | backfill | ca-abc 00107248|47|APP|0 ↔ ca-abc 00107248|47|LIC|0 | one licence file | merged |