Fratello's Italian Family Restaurant

SAN CLEMENTE, CA 92673 · O062d01b63019 · 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
Fratello's Italian Family Restaurant 4 other
a licence name in capitals, cleaned (derived; record_title.py)
FRATELLOS ITALIAN FAMILY RESTAURANT ab-inbevca-abcvtinfo ×3
Madison & Sons Inc overtureca-abc (legal name) ×2
Fratello's ubereats
fratello's italian restaurant san clemente doordash
Street
647 CAMINO DE LOS MARES 2 other
ca-abc
647 CAMINO LOS MARES STE 126 ab-inbevvtinfo ×2
647 Camino De Los Mares Ste 126 overture
City
SAN CLEMENTE
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92673 1 other
ca-abc
92672 ab-inbev
Pin
33.45850, -117.64972 map 1 other
ubereats
108 m away ca-abc
Phone
9496615200
vtinfono other value
Licences
ca-abc 00579775|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of3cf57ec7a67; Oaa9a66d70e04; Obd58ab478392; O6b1577e1e48a; Od6c65d12c02f

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-inbevFRATELLOS ITALIAN FAMILY RESTAURANT
4049083
647 CAMINO LOS MARES STE 126, SAN CLEMENTE, CA, 9267233.45851, -117.649722026-11-112026-11-11
ca-abcFRATELLOS ITALIAN FAMILY RESTAURANT
legal name: MADISON & SONS INC
00579775|47|LIC|0
647 CAMINO DE LOS MARES, SAN CLEMENTE, CA, 9267333.45873, -117.650862026-10-082026-11-11
doordashfratello's italian restaurant san clemente
11907
647 Camino De Los Mares, San Clemente, CA, 9267333.45886, -117.649682026-10-082026-11-11
overtureMadison & Sons Inc
66e812f0-f431-4c96-81e3-57b35595a46f
647 Camino De Los Mares Ste 126, San Clemente, CA, 9267333.45851, -117.649772026-11-062026-11-11
ubereatsFratello's
T7dvDYbgR12AsnCCQo2J5w
647 Camino de Los Mares, San Clemente, CA, 9267333.45850, -117.649722026-10-182026-11-11
vtinfoFRATELLOS ITALIAN FAMILY RESTAURANT
3d1e1241b3d52eae
647 CAMINO LOS MARES STE 126, SAN CLEMENTE, CA, 92673949661520033.45851, -117.649772026-11-152026-11-15

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 FRATELLOS ITALIAN FAMILY RESTAURANTca-abc FRATELLOS ITALIAN FAMILY RESTAURANT1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on city · pins 108 m apart · name similarity 1.00 · street similarity 0.91
ab-inbev FRATELLOS ITALIAN FAMILY RESTAURANTvtinfo FRATELLOS ITALIAN FAMILY RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00
ca-abc FRATELLOS ITALIAN FAMILY RESTAURANToverture Madison & Sons Inc1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 104 m apart · matched through the licence's legal name: MADISON & SONS INC · name similarity 1.00
ca-abc FRATELLOS ITALIAN FAMILY RESTAURANTvtinfo FRATELLOS ITALIAN FAMILY RESTAURANT1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 104 m apart · name similarity 1.00 · street similarity 0.91
ab-inbev FRATELLOS ITALIAN FAMILY RESTAURANTdoordash fratello's italian restaurant san clemente0.82street written two waysmergedname Jaro-Winkler 0.81 · matched on city · pins 40 m apart · name similarity 0.82 · street similarity 0.91
doordash fratello's italian restaurant san clementevtinfo FRATELLOS ITALIAN FAMILY RESTAURANT0.82street written two waysmergedname Jaro-Winkler 0.81 · matched on zip · pins 40 m apart · name similarity 0.82 · street similarity 0.91
ca-abc FRATELLOS ITALIAN FAMILY RESTAURANTdoordash fratello's italian restaurant san clemente0.82same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.81 · same street + city + state · pins 110 m apart · name similarity 0.82
doordash fratello's italian restaurant san clementeubereats Fratello's0.41Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “same-address” pair)
Both records carry the distinctive name 'Fratello's' at the identical street address and ZIP, so the names agree despite the shared building, with no unit conflict.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records name Fratello's at 647 Camino de Los Mares, San Clemente 92673, with coordinates about 40 m apart; the DoorDash slug just appends the city to the same restaurant name, though the building houses four businesses so the name match is the deciding evidence.
pair a9083c7ccfdecfb99319
ca-abc FRATELLOS ITALIAN FAMILY RESTAURANTubereats Fratello's0.20Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (88% confident; asked as a “same-address” pair)
The names agree, 'Fratello's' being the trade name of Fratellos Italian Family Restaurant, at the identical street address and ZIP, so the shared building (4 businesses) does not separate them.
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 92% confident — Fratello's name and address match.
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 647 Camino de Los Mares, San Clemente 92673, and the names match as a restaurant (Fratello's / Fratelli's Italian Family Restaurant); the California licence is an on-sale eating-place licence, which fits the Uber Eats restaurant listing as the same operation, though the address is shared by four businesses.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records give the same street address, ZIP and city, and the names are near-identical (Fratellos Italian Family Restaurant vs Uber Eats' Fratello's); the CA licence is an eating-place restaurant, consistent with the delivery listing, and the names agree despite the building holding three businesses.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records give the same street address, city and ZIP, and the distinctive name 'Fratellos' matches ('Fratello's'), with the ABC licence being an on-sale restaurant that fits the Uber Eats listing; the shared building (4 businesses) is offset by the name agreement.
pair 44edfafecb00920da5f0

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MADISON & SONS 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 10, computed 2026-11-18 20:34.
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
52 within 1 mi · 492 within 3 mi
Off / on premise
15 / 23 within 1 mi · 101 / 275 within 3 mi
Selling alcohol
34 within 1 mi · 297 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.03 mi
Setting
suburban (2,259 people per sq mi)
People within 3 mi
63,858 (50,493 adults 21+, 25,236 households) from 12 tract(s), tracts within 3 mi
Income
per capita $69,923 · median household ~$130,367 (weighted mean of tract medians)
Age and education
median age ~46.1 · bachelor's or higher 50%
Ethnicity
Hispanic 21% · White 73% · Black 1% · Asian 4%
Adults per alcohol outlet
169
Alcohol spend within 3 mi
$23,373,209 a year ($10,063,472 at home, $13,301,435 away) · $78,434 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-15 16:24insertdoordash 11907 ↔ vtinfo 3d1e1241b3d52eaestreet written two waysmerged15
2026-11-15 16:24insertca-abc 00579775|47|LIC|0 ↔ vtinfo 3d1e1241b3d52eaestreet written two waysmerged15
2026-11-15 16:24insertab-inbev 4049083 ↔ vtinfo 3d1e1241b3d52eaesame address and namemerged15
2026-11-11 12:56insertdoordash 11907 ↔ ubereats T7dvDYbgR12AsnCCQo2J5wClaude judge: samemerged12
2026-11-11 12:56insertab-inbev 4049083 ↔ doordash 11907street written two waysmerged12
2026-11-11 12:56insertab-inbev 4049083 ↔ ca-abc 00579775|47|LIC|0street written two waysmerged12
2026-11-06 18:13insertca-abc 00579775|47|LIC|0 ↔ overture 66e812f0-f431-4c96-81e3-57b35595a46fsame address and namemerged11
2026-11-04 18:12backfillca-abc 00579775|47|LIC|0 ↔ doordash 11907same address and namemerged
2026-11-02 23:02backfillca-abc 00579775|47|LIC|0 ↔ ubereats T7dvDYbgR12AsnCCQo2J5wClaude judge: samemerged