Scotty's Bar

PALO ALTO, CA 94301 · O2735f54d3e08 · first seen 2026-10-08
4 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.

FieldMaster valueTaken fromWhat other sources say
Name
Scotty's Bar 4 other
a licence name in capitals, cleaned (derived; record_title.py)
PALO ALTO BUSINESS GROUP LLC ca-abc (legal name) ×2
SCOTTY'S inspections
Scotty's Bar & Grill overture
SCOTTYS vtinfo
Street
548 EMERSON ST
ca-abcno other value
City
PALO ALTO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94301
ca-abcno other value
Pin
37.44407, -122.16192 map
overtureno other value
Phone
6505614929
vtinfono other value
Licences
ca-abc 00658224|47|LIC|0 · ca-abc 00658224|77|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of9166a14782d; Oafd2b8d9d236; O5e1d4a20f02e; O3c87bbd559fb

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
ca-abcSCOTTY'S BAR
legal name: PALO ALTO BUSINESS GROUP LLC
00658224|47|LIC|0
548 EMERSON ST, PALO ALTO, CA, 9430137.44426, -122.162212026-10-082026-11-19
ca-abcSCOTTY'S BAR
legal name: PALO ALTO BUSINESS GROUP LLC
00658224|77|LIC|0
548 EMERSON ST, PALO ALTO, CA, 9430137.44426, -122.162212026-10-082026-11-19
inspectionsSCOTTY'S
inspections|scc|PR0387976
548 EMERSON ST, Palo Alto, CA, 9430137.44410, -122.161882026-11-192026-11-19
overtureScotty's Bar & Grill
1b3f2947-a146-42d0-95c0-a07baf053a43
548 Emerson St, Palo Alto, CA, 94301650561492937.44407, -122.161922026-11-062026-11-19
vtinfoSCOTTYS
1f45a3f4a75151d8
548 EMERSON ST, PALO ALTO, CA, 94301650561492937.44387, -122.161912026-11-122026-11-19

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 SCOTTY'S BARca-abc SCOTTY'S BAR1.00one licence filemergedfile: 00658224 · same_address
inspections SCOTTY'Svtinfo SCOTTYS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 25 m apart · name similarity 1.00
ca-abc SCOTTY'S BARoverture Scotty's Bar & Grill0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 33 m apart · name similarity 0.73
ca-abc SCOTTY'S BARoverture Scotty's Bar & Grill0.73same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 33 m apart · name similarity 0.73
ca-abc SCOTTY'S BARinspections SCOTTY'S0.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar · name Jaro-Winkler 0.88 · same street + ZIP · pins 34 m apart · name similarity 0.64
ca-abc SCOTTY'S BARvtinfo SCOTTYS0.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar · name Jaro-Winkler 0.88 · same street + city + state · pins 51 m apart · name similarity 0.64
ca-abc SCOTTY'S BARinspections SCOTTY'S0.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar · name Jaro-Winkler 0.88 · same street + ZIP · pins 34 m apart · name similarity 0.64
ca-abc SCOTTY'S BARvtinfo SCOTTYS0.64same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar · name Jaro-Winkler 0.88 · same street + city + state · pins 51 m apart · name similarity 0.64
inspections SCOTTY'Soverture Scotty's Bar & Grill0.46same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill · name Jaro-Winkler 0.40 · same street + ZIP · pins 4 m apart · name similarity 0.46
overture Scotty's Bar & Grillvtinfo SCOTTYS0.46same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: bar, grill · name Jaro-Winkler 0.40 · same street + city + state · pins 22 m apart · name similarity 0.46 · phone: equal

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
PALO ALTO BUSINESS GROUP LLC — 2 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 77
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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-19 20:37insertinspections inspections|scc|PR0387976 ↔ overture 1b3f2947-a146-42d0-95c0-a07baf053a43same address and namemerged17
2026-11-19 20:37insertca-abc 00658224|77|LIC|0 ↔ inspections inspections|scc|PR0387976same address and namemerged17
2026-11-19 20:37insertca-abc 00658224|47|LIC|0 ↔ inspections inspections|scc|PR0387976same address and namemerged17
2026-11-19 20:37insertinspections inspections|scc|PR0387976 ↔ vtinfo 1f45a3f4a75151d8same address and namemerged17
2026-11-12 17:29insertoverture 1b3f2947-a146-42d0-95c0-a07baf053a43 ↔ vtinfo 1f45a3f4a75151d8same address and namemerged14
2026-11-12 17:29insertca-abc 00658224|77|LIC|0 ↔ vtinfo 1f45a3f4a75151d8same address and namemerged14
2026-11-12 17:29insertca-abc 00658224|47|LIC|0 ↔ vtinfo 1f45a3f4a75151d8same address and namemerged14
2026-11-06 18:13insertca-abc 00658224|77|LIC|0 ↔ overture 1b3f2947-a146-42d0-95c0-a07baf053a43same address and namemerged11
2026-11-06 18:13insertca-abc 00658224|47|LIC|0 ↔ overture 1b3f2947-a146-42d0-95c0-a07baf053a43same address and namemerged11
2026-10-09 13:59backfillca-abc 00658224|47|LIC|0 ↔ ca-abc 00658224|77|LIC|0one licence filemerged