O Mallys

SACRAMENTO, CA 95814 · O18f1b1848ad3 · first seen 2026-10-08
5 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
O Mallys 3 other
a licence name in capitals, cleaned (derived; record_title.py)
O'MALLY'S PUB ca-abc ×2
O'Mally's Irish Pub overture
omallys irish pub sacramento doordash
Street
1109 2ND ST 1 other
ca-abc
1109 2nd Street doordash
City
SACRAMENTO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95814
ca-abcno other value
Pin
38.58167, -121.50454 map 1 other
doordash
70 m away ab-inbev
Phone
9164921230
vtinfono other value
Licences
ca-abc 00654170|47|LIC|0 · ca-abc 00654170|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc3bb52f0e45f; Oebce321804fe; O2818414b6c69; O8c81e3392241; O1e1a0f07c11c

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-inbevO MALLYS
2213519
1109 2ND ST, SACRAMENTO, CA, 9581438.58112, -121.504922026-11-112026-11-12
ca-abcO'MALLY'S PUB
00654170|47|LIC|0
1109 2ND ST, SACRAMENTO, CA, 9581438.58146, -121.504782026-10-082026-11-04
ca-abcO'MALLY'S PUB
00654170|58|LIC|0
1109 2ND ST, SACRAMENTO, CA, 9581438.58146, -121.504782026-10-082026-11-04
doordashomallys irish pub sacramento
24530167
1109 2nd Street, Sacramento, CA, 9581438.58167, -121.504542026-10-082026-11-11
overtureO'Mally's Irish Pub
689b56e2-9589-437c-8998-8052e5130661
1109 2nd St, Sacramento, CA, 95814916492123038.58173, -121.504602026-11-092026-11-11
vtinfoO MALLYS
3990128d13c3b305
1109 2ND ST, SACRAMENTO, CA, 95814916492123038.58162, -121.504502026-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 O MALLYSvtinfo O MALLYS1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 67 m apart · name similarity 1.00
ca-abc O'MALLY'S PUBca-abc O'MALLY'S PUB1.00one licence filemergedfile: 00654170 · same_address
doordash omallys irish pub sacramentooverture O'Mally's Irish Pub1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 8 m apart · name similarity 1.00
ca-abc O'MALLY'S PUBdoordash omallys irish pub sacramento0.73Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The names match: 'O'Mally's Pub' is the same business as the DoorDash slug 'omallys irish pub sacramento' once the city is dropped. Both records give the same street address and ZIP, and only one busi
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 1109 2nd Street, Sacramento 95814 with coordinates about 31 m apart, the only business at that address is in the data, and the names match (O'Mally's Pub vs omallys irish pub); the CA licence is an on-sale eating place (restaurant with full bar), consistent with a pub that serves food.
pair c016a0b387a1ba594899
ca-abc O'MALLY'S PUBdoordash omallys irish pub sacramento0.73Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “near” pair)
The names agree ('O'Mally's Pub' and the 'omallys irish pub' slug with its city appended) at the identical street address, 1109 2nd St, Sacramento 95814, and no other business is recorded at that addr
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 90% confident — Both records sit at 1109 2nd St, Sacramento 95814 with coordinates about 30 m apart, and the names O'Mally's Pub and omallys irish pub are the same bar; the only address-level business is this one, and the CA licence is an active on-sale eating place with an add-on caterer permit, consistent with a pub listed on DoorDash.
pair ebf146830c8dbc7d1c03
ab-inbev O MALLYSca-abc O'MALLY'S PUB0.37Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “same-address” pair)
O Mallys vs O'Mally's Pub, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — The names O MALLYS and O'MALLY'S PUB are essentially the same, and both sit at 1109 2ND ST with coordinates about 0.04 km apart; the CA licence is an on-sale eating place with a full bar, which matches a bar-restaurant account carrying AB InBev brands, so this is one operation even though another business also shares the building.
pair 1922e087637e5839e64f

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47; CA 58 (add-on: follows the base licence)
Rule version 9, computed 2026-11-17 18:20.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
325 within 1 mi · 1,331 within 3 mi
Off / on premise
22 / 241 within 1 mi · 206 / 879 within 3 mi
Selling alcohol
234 within 1 mi · 869 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (4,912 people per sq mi)
People within 3 mi
138,895 (111,984 adults 21+, 64,103 households) from 40 tract(s), tracts within 3 mi
Income
per capita $56,651 · median household ~$93,391 (weighted mean of tract medians)
Age and education
median age ~36.8 · bachelor's or higher 47%
Ethnicity
Hispanic 28% · White 50% · Black 9% · Asian 10%
Adults per alcohol outlet
129
Alcohol spend within 3 mi
$47,472,582 a year ($21,363,715 at home, $26,087,488 away) · $54,566 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-12 17:29insertab-inbev 2213519 ↔ ca-abc 00654170|58|LIC|0Claude judge: samemerged14
2026-11-12 14:25insertab-inbev 2213519 ↔ vtinfo 3990128d13c3b305same address and namemerged12
2026-11-11 12:56insertca-abc 00654170|58|LIC|0 ↔ doordash 24530167Claude judge: samemerged12
2026-11-11 12:56insertca-abc 00654170|47|LIC|0 ↔ doordash 24530167Claude judge: samemerged12
2026-11-09 15:32insertdoordash 24530167 ↔ overture 689b56e2-9589-437c-8998-8052e5130661same address and namemerged11
2026-10-09 13:59backfillca-abc 00654170|47|LIC|0 ↔ ca-abc 00654170|58|LIC|0one licence filemerged