OLD SPAGHETTI FACTORY

SAN DIEGO, CA 92101 · O401fc20ebeb7 · first seen 2026-10-08
5 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
OLD SPAGHETTI FACTORY 4 other
the most common name a source states
OLD SPAGHETTI FACTORY THE ca-abc
OSF INTERNATIONAL INC ca-abc (legal name)
The Old Spaghetti Factory overture
the old spaghetti factory san diego doordash
Street
275 5TH AVE 2 other
ca-abc
275 Fifth Ave overture
275 Fifth Avenue doordash
City
SAN DIEGO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92101
ca-abcno other value
Pin
32.70822, -117.15995 map
doordashno other value
Phone
6192334323
vtinfono other value
Licences
ca-abc 00198901|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa3c89970d36d; Ob8710d5341a1; O7d04b7168583; O41bc71ea724c

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-inbevOLD SPAGHETTI FACTORY
42458
275 5TH AVE, SAN DIEGO, CA, 9210132.70818, -117.160042026-11-132026-11-13
ca-abcOLD SPAGHETTI FACTORY THE
legal name: OSF INTERNATIONAL INC
00198901|47|LIC|0
275 5TH AVE, SAN DIEGO, CA, 9210132.70804, -117.160022026-10-082026-11-05
doordashthe old spaghetti factory san diego
18156
275 Fifth Avenue, San Diego, CA, 9210132.70822, -117.159952026-10-082026-11-03
overtureThe Old Spaghetti Factory
e072ba0f-3f77-4cf3-8d8f-16eee8f80870
275 Fifth Ave, San Diego, CA, 92101619233432332.70824, -117.160002026-11-062026-11-06
vtinfoOLD SPAGHETTI FACTORY
e0c6177ac243129e
275 5TH AVE, SAN DIEGO, CA, 92101619233432332.70812, -117.159812026-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
ab-inbev OLD SPAGHETTI FACTORYca-abc OLD SPAGHETTI FACTORY THE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
ab-inbev OLD SPAGHETTI FACTORYdoordash the old spaghetti factory san diego1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ab-inbev OLD SPAGHETTI FACTORYoverture The Old Spaghetti Factory1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 7 m apart · name similarity 1.00
ab-inbev OLD SPAGHETTI FACTORYvtinfo OLD SPAGHETTI FACTORY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00
ca-abc OLD SPAGHETTI FACTORY THEdoordash the old spaghetti factory san diego1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (95% confident; asked as a “near” pair)
Same restaurant name (DoorDash slug with city appended) at the same street address (5th Ave = Fifth Avenue) and ZIP, with only one business recorded at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records give the same street address, city and ZIP at 275 Fifth Avenue, San Diego, and the names match (Old Spaghetti Factory); the only business at that address in the data is this restaurant, so the DoorDash listing is the same outlet as the ABC restaurant licence.
pair fed6481ff1238560a4bb
ca-abc OLD SPAGHETTI FACTORY THEoverture The Old Spaghetti Factory1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ca-abc OLD SPAGHETTI FACTORY THEvtinfo OLD SPAGHETTI FACTORY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 22 m apart · name similarity 1.00
doordash the old spaghetti factory san diegooverture The Old Spaghetti Factory1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 6 m apart · name similarity 1.00
doordash the old spaghetti factory san diegovtinfo OLD SPAGHETTI FACTORY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00
overture The Old Spaghetti Factoryvtinfo OLD SPAGHETTI FACTORY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 23 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
OSF INTERNATIONAL INC — 4 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 7, computed 2026-11-16 17:16.
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
764 within 1 mi · 1,831 within 3 mi
Off / on premise
76 / 472 within 1 mi · 226 / 1,083 within 3 mi
Selling alcohol
544 within 1 mi · 1,266 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.02 mi
Setting
urban (5,762 people per sq mi)
People within 3 mi
162,906 (138,385 adults 21+, 74,938 households) from 51 tract(s), tracts within 3 mi
Income
per capita $62,909 · median household ~$97,521 (weighted mean of tract medians)
Age and education
median age ~37.4 · bachelor's or higher 50%
Ethnicity
Hispanic 38% · White 52% · Black 7% · Asian 6%
Adults per alcohol outlet
109
Alcohol spend within 3 mi
$57,186,010 a year ($25,465,726 at home, $31,696,106 away) · $45,135 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-13 17:47insertab-inbev 42458 ↔ vtinfo e0c6177ac243129esame address and namemerged15
2026-11-13 17:47insertab-inbev 42458 ↔ overture e072ba0f-3f77-4cf3-8d8f-16eee8f80870same address and namemerged15
2026-11-13 17:47insertab-inbev 42458 ↔ ca-abc 00198901|47|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 42458 ↔ doordash 18156same address and namemerged15
2026-11-12 14:25insertoverture e072ba0f-3f77-4cf3-8d8f-16eee8f80870 ↔ vtinfo e0c6177ac243129esame address and namemerged12
2026-11-12 14:25insertca-abc 00198901|47|LIC|0 ↔ vtinfo e0c6177ac243129esame address and namemerged12
2026-11-12 14:25insertdoordash 18156 ↔ vtinfo e0c6177ac243129esame address and namemerged12
2026-11-06 18:13insertca-abc 00198901|47|LIC|0 ↔ overture e072ba0f-3f77-4cf3-8d8f-16eee8f80870same address and namemerged11
2026-11-06 18:13insertdoordash 18156 ↔ overture e072ba0f-3f77-4cf3-8d8f-16eee8f80870same address and namemerged11
2026-11-02 23:02backfillca-abc 00198901|47|LIC|0 ↔ doordash 18156Claude judge: samemerged