Rosie Ogrady

SAN DIEGO, CA 92116 · O5cae0113a9ca · first seen 2026-10-08
4 sourceson premise · baralcohol: 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
Rosie Ogrady 3 other
a licence name in capitals, cleaned (derived; record_title.py)
Rosie O'Grady's overture
ROSIE OGRADYS ca-abc
UNICORN LOUNGE LLC ca-abc (legal name)
Street
3402 ADAMS AVE
ca-abcno other value
City
SAN DIEGO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
92116
ca-abcno other value
Pin
32.76352, -117.12058 map
overtureno other value
Phone
6192847666
vtinfono other value
Licences
ca-abc 00612491|48|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O90f58b97dfbc; Of2509e0c01a4; O7591645fcb79

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-inbevROSIE OGRADY
42810
3402 ADAMS AVE, SAN DIEGO, CA, 9211632.76358, -117.120092026-11-112026-11-11
ca-abcROSIE OGRADYS
legal name: UNICORN LOUNGE LLC
00612491|48|LIC|0
3402 ADAMS AVE, SAN DIEGO, CA, 9211632.76340, -117.120502026-10-082026-11-11
overtureRosie O'Grady's
3b4c6a95-33a4-4b0f-9d46-fe89905940f8
3402 Adams Ave, San Diego, CA, 92116619284766632.76352, -117.120582026-11-062026-11-11
vtinfoROSIE OGRADY
e2b08c71cbc6bdb6
3402 ADAMS AVE, SAN DIEGO, CA, 92116619284766632.76359, -117.120382026-11-112026-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 ROSIE OGRADYvtinfo ROSIE OGRADY1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 28 m apart · name similarity 1.00
ca-abc ROSIE OGRADYSoverture Rosie O'Grady's1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 15 m apart · name similarity 1.00
ab-inbev ROSIE OGRADYca-abc ROSIE OGRADYS0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 43 m apart · name similarity 0.65
ab-inbev ROSIE OGRADYoverture Rosie O'Grady's0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + ZIP · pins 47 m apart · name similarity 0.65
ca-abc ROSIE OGRADYSvtinfo ROSIE OGRADY0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + city + state · pins 23 m apart · name similarity 0.65
overture Rosie O'Grady'svtinfo ROSIE OGRADY0.65same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.95 · same street + city + state · pins 20 m apart · name similarity 0.65 · phone: equal

Attributes

Channel
on_premise · bar — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
UNICORN LOUNGE LLC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 48
Rule version 10, computed 2026-11-18 20:36.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "bar"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
232 within 1 mi · 1,467 within 3 mi
Off / on premise
45 / 136 within 1 mi · 313 / 870 within 3 mi
Selling alcohol
159 within 1 mi · 899 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.02 mi
Setting
urban (9,179 people per sq mi)
People within 3 mi
259,528 (206,782 adults 21+, 111,701 households) from 60 tract(s), tracts within 3 mi
Income
per capita $51,774 · median household ~$95,114 (weighted mean of tract medians)
Age and education
median age ~34.9 · bachelor's or higher 47%
Ethnicity
Hispanic 34% · White 45% · Black 7% · Asian 13%
Adults per alcohol outlet
230
Alcohol spend within 3 mi
$81,937,686 a year ($36,910,112 at home, $44,991,409 away) · $91,042 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-11 12:56insertoverture 3b4c6a95-33a4-4b0f-9d46-fe89905940f8 ↔ vtinfo e2b08c71cbc6bdb6same address and namemerged12
2026-11-11 12:56insertca-abc 00612491|48|LIC|0 ↔ vtinfo e2b08c71cbc6bdb6same address and namemerged12
2026-11-11 12:56insertab-inbev 42810 ↔ overture 3b4c6a95-33a4-4b0f-9d46-fe89905940f8same address and namemerged12
2026-11-11 12:56insertab-inbev 42810 ↔ ca-abc 00612491|48|LIC|0same address and namemerged12
2026-11-11 12:56insertab-inbev 42810 ↔ vtinfo e2b08c71cbc6bdb6same address and namemerged12
2026-11-06 18:13insertca-abc 00612491|48|LIC|0 ↔ overture 3b4c6a95-33a4-4b0f-9d46-fe89905940f8same address and namemerged11