Fresco Trettoria & Bar

CARLSBAD, CA 92008 · Od0e3397c59c0 · first seen 2026-11-12
1 sourceon premise · predictedalcohol: alcohol

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
Fresco Trettoria & Bar
a licence name in capitals, cleaned (derived; record_title.py)no other value
Street
264 CARLSBAD VILLAGE DR
vtinfono other value
City
CARLSBAD
vtinfono other value
State
CA
vtinfono other value
ZIP
92008
vtinfono other value
Pin
33.15808, -117.35178 map
vtinfono other value
Phone
7607203737
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by singleton · absorbed ids: none

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
vtinfoFRESCO TRETTORIA & BAR
7ef5ad42fec65148
264 CARLSBAD VILLAGE DR, CARLSBAD, CA, 92008760720373733.15808, -117.351782026-11-122026-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
ca-abc 264 FRESCOvtinfo FRESCO TRETTORIA & BAR0.36one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 1ff6ea77146079b46412 · person: None · rule: names contained at one address · stratum: same-address
ca-abc 264 FRESCOvtinfo FRESCO TRETTORIA & BAR0.36one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 74e7d73ff692a6943e6c · person: None · rule: names contained at one address · stratum: same-address
ca-abc 264 FRESCOvtinfo FRESCO TRETTORIA & BAR0.36one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 9424641b9c788bddd97e · person: None · rule: names contained at one address · stratum: same-address
ca-abc 264 FRESCOvtinfo FRESCO TRETTORIA & BAR0.36one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: ad905c207dea6500a79f · person: None · rule: names contained at one address · stratum: same-address
ca-abc 264 FRESCOvtinfo FRESCO TRETTORIA & BAR0.36one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 62945b7a0442a557a8b0 · person: None · rule: names contained at one address · stratum: same-address
ca-abc 264 FRESCOvtinfo FRESCO TRETTORIA & BAR0.36one name contains the other, same addressheld same-source-conflictjudge: None · pair_id: 5ecb7683ee3aab5aa160 · person: None · rule: names contained at one address · stratum: same-address

Attributes

Channel
unknown
Chain
none
Alcohol
alcohol — listed as carrying Heineken USA, Proximo Spirits (Jose Cuervo), Sazerac +1 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-20 23:35.
Every vote behind these (raw)
{
 "votes": []
}

Trade area

Other outlets
142 within 1 mi · 501 within 3 mi
Off / on premise
16 / 102 within 1 mi · 114 / 318 within 3 mi
Selling alcohol
115 within 1 mi · 326 within 3 mi
Nearest
same channel none within 3 mi · licensed 0.01 mi
Setting
suburban (2,169 people per sq mi)
People within 3 mi
61,320 (48,600 adults 21+, 24,774 households) from 15 tract(s), tracts within 3 mi
Income
per capita $54,695 · median household ~$100,431 (weighted mean of tract medians)
Age and education
median age ~39.8 · bachelor's or higher 47%
Ethnicity
Hispanic 27% · White 63% · Black 2% · Asian 5%
Adults per alcohol outlet
149
Alcohol spend within 3 mi
$19,554,803 a year ($8,695,806 at home, $10,851,362 away) · $59,801 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:56insertca-abc 00357738|47|LIC|0 ↔ vtinfo 7ef5ad42fec65148one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertca-abc 00357738|58|LIC|0 ↔ vtinfo 7ef5ad42fec65148one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertca-abc 00357738|47|LIC|1 ↔ vtinfo 7ef5ad42fec65148one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertca-abc 00669412|47|APP|0 ↔ vtinfo 7ef5ad42fec65148one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertca-abc 00357738|47|APP|0 ↔ vtinfo 7ef5ad42fec65148one name contains the other, same addressheld: same-source-conflict15
2026-11-16 14:56insertca-abc 00357738|58|APP|0 ↔ vtinfo 7ef5ad42fec65148one name contains the other, same addressheld: same-source-conflict15