Aj's Bar

SAN FRANCISCO, CA 94102 · O24fae5efba34 · first seen 2026-10-08
4 sourceson premise · baralcohol: 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
Aj's Bar 2 other
a source's own spelling of the licence name (record_title.py)
AJS BAR ab-inbevvtinfo ×2
CLUB ALLURE INC ca-abc (legal name) ×2
Street
1250 MARKET ST 2 other
ca-abc
1250 Market St #101 overture
1250 MARKET ST STE 101 vtinfo
City
SAN FRANCISCO
ca-abcno other value
State
CA
ca-abcno other value
ZIP
94102
ca-abcno other value
Pin
37.77822, -122.41573 map
overtureno other value
Phone
6502709597
vtinfono other value
Licences
ca-abc 00661666|48|LIC|0 · ca-abc 00661666|58|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O87c731393662; Ofa9db4e94fef; O5ffa88457780; Oebc6531e16ae

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-inbevAJS BAR
4824837
1250 MARKET ST, SAN FRANCISCO, CA, 9410237.77818, -122.415572026-11-132026-11-13
ca-abcAJ'S BAR
legal name: CLUB ALLURE INC
00661666|48|LIC|0
1250 MARKET ST, SAN FRANCISCO, CA, 9410237.77829, -122.415462026-10-082026-11-11
ca-abcAJ'S BAR
legal name: CLUB ALLURE INC
00661666|58|LIC|0
1250 MARKET ST, SAN FRANCISCO, CA, 9410237.77829, -122.415462026-10-082026-11-11
overtureAj's Bar
b1a245e4-46ff-4971-888d-a9ebdba63262
1250 Market St #101, San Francisco, CA, 9410237.77822, -122.415732026-11-062026-11-11
vtinfoAJS BAR
c143a4112c3550f1
1250 MARKET ST STE 101, SAN FRANCISCO, CA, 94102650270959737.77826, -122.415592026-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 AJS BARca-abc AJ'S BAR1.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 AJS BARca-abc AJ'S BAR1.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 AJS BARoverture Aj's Bar1.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 AJS BARvtinfo AJS BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 9 m apart · name similarity 1.00
ca-abc AJ'S BARca-abc AJ'S BAR1.00one licence filemergedfile: 00661666 · same_address
ca-abc AJ'S BARoverture Aj's Bar1.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 AJ'S BARvtinfo AJS BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00
ca-abc AJ'S BARoverture Aj's Bar1.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 AJ'S BARvtinfo AJS BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00
overture Aj's Barvtinfo AJS BAR1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 13 m apart · name similarity 1.00

Attributes

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

Trade area

Other outlets
1,942 within 1 mi · 6,122 within 3 mi
Off / on premise
238 / 1,220 within 1 mi · 813 / 3,857 within 3 mi
Selling alcohol
1,148 within 1 mi · 3,787 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.02 mi
Setting
urban (16,970 people per sq mi)
People within 3 mi
479,825 (417,687 adults 21+, 239,958 households) from 155 tract(s), tracts within 3 mi
Income
per capita $109,243 · median household ~$155,407 (weighted mean of tract medians)
Age and education
median age ~39.5 · bachelor's or higher 67%
Ethnicity
Hispanic 15% · White 48% · Black 5% · Asian 27%
Adults per alcohol outlet
110
Alcohol spend within 3 mi
$231,093,189 a year ($98,066,089 at home, $132,957,279 away) · $61,007 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 4824837 ↔ vtinfo c143a4112c3550f1same address and namemerged15
2026-11-13 17:47insertab-inbev 4824837 ↔ ca-abc 00661666|58|LIC|0same address and namemerged15
2026-11-13 17:47insertab-inbev 4824837 ↔ overture b1a245e4-46ff-4971-888d-a9ebdba63262same address and namemerged15
2026-11-13 17:47insertab-inbev 4824837 ↔ ca-abc 00661666|48|LIC|0same address and namemerged15
2026-11-11 12:56insertoverture b1a245e4-46ff-4971-888d-a9ebdba63262 ↔ vtinfo c143a4112c3550f1same address and namemerged12
2026-11-11 12:56insertca-abc 00661666|58|LIC|0 ↔ vtinfo c143a4112c3550f1same address and namemerged12
2026-11-11 12:56insertca-abc 00661666|48|LIC|0 ↔ vtinfo c143a4112c3550f1same address and namemerged12
2026-11-06 18:13insertca-abc 00661666|58|LIC|0 ↔ overture b1a245e4-46ff-4971-888d-a9ebdba63262same address and namemerged11
2026-11-06 18:13insertca-abc 00661666|48|LIC|0 ↔ overture b1a245e4-46ff-4971-888d-a9ebdba63262same address and namemerged11
2026-10-09 13:59backfillca-abc 00661666|48|LIC|0 ↔ ca-abc 00661666|58|LIC|0one licence filemerged