The Lincoln Pub & Grub

CLOVIS, CA 93612 · O053c65ce6117 · first seen 2026-10-08
3 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
The Lincoln Pub & Grub 2 other
a licence name in capitals, cleaned (derived; record_title.py)
MORFIX LLC ca-abc (legal name)
THE LINCOLN CLOVIS ca-abc
Street
401 CLOVIS AVE 1 other
ca-abc
401 CLOVIS AVE STE 106 ab-inbevvtinfo ×2
City
CLOVIS
ca-abcno other value
State
CA
ca-abcno other value
ZIP
93612
ca-abcno other value
Pin
36.82519, -119.70054 map
ca-abcno other value
Phone
5593553533
vtinfono other value
Licences
ca-abc 00669843|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oc19292c3dcad; O45120e444ab9

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-inbevTHE LINCOLN PUB & GRUB
4866846
401 CLOVIS AVE STE 106, CLOVIS, CA, 9361236.82521, -119.700342026-11-112026-11-11
ca-abcTHE LINCOLN CLOVIS
legal name: MORFIX LLC
00669843|47|LIC|0
401 CLOVIS AVE, CLOVIS, CA, 9361236.82519, -119.700542026-10-082026-11-16
vtinfoTHE LINCOLN PUB & GRUB
7a33fbccf5789e13
401 CLOVIS AVE STE 106, CLOVIS, CA, 93612559355353336.82493, -119.700352026-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
ca-abc THE LINCOLN CLOVISdoordash the local clovis0.55same address and nameheld same-source-conflictaddress similarity 1.00 · name Jaro-Winkler 0.92 · same street + ZIP · pins 21 m apart · name similarity 0.55
ab-inbev THE LINCOLN PUB & GRUBvtinfo THE LINCOLN PUB & GRUB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 32 m apart · name similarity 1.00
ab-inbev THE LINCOLN PUB & GRUBca-abc THE LINCOLN CLOVIS0.39one name contains the other, same addressmergedjudge: None · pair_id: df21b977458c8ef89835 · person: None · rule: names contained at one address · stratum: same-address
ca-abc THE LINCOLN CLOVISvtinfo THE LINCOLN PUB & GRUB0.39one name contains the other, same addressmergedjudge: None · pair_id: b8539741dd75b8a5c414 · person: None · rule: names contained at one address · stratum: same-address

Attributes

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

Trade area

Other outlets
128 within 1 mi · 600 within 3 mi
Off / on premise
32 / 81 within 1 mi · 156 / 386 within 3 mi
Selling alcohol
79 within 1 mi · 303 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.01 mi
Setting
urban (4,239 people per sq mi)
People within 3 mi
119,863 (82,476 adults 21+, 41,355 households) from 27 tract(s), tracts within 3 mi
Income
per capita $40,736 · median household ~$95,772 (weighted mean of tract medians)
Age and education
median age ~36.2 · bachelor's or higher 34%
Ethnicity
Hispanic 35% · White 53% · Black 3% · Asian 12%
Adults per alcohol outlet
271
Alcohol spend within 3 mi
$30,044,103 a year ($13,553,746 at home, $16,478,347 away) · $98,829 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-18 18:58updateca-abc 00669843|47|LIC|0 ↔ doordash 905679same address and nameheld: same-source-conflict15
2026-11-16 14:56insertca-abc 00669843|47|LIC|0 ↔ vtinfo 7a33fbccf5789e13one name contains the other, same addressmerged15
2026-11-16 14:56insertab-inbev 4866846 ↔ ca-abc 00669843|47|LIC|0one name contains the other, same addressmerged15
2026-11-16 14:56updateca-abc 00669843|47|LIC|0 ↔ doordash 905679same address and nameheld: same-source-conflict15
2026-11-14 20:23updateca-abc 00669843|47|LIC|0 ↔ doordash 905679same address and nameheld: same-source-conflict15
2026-11-12 14:25insertca-abc 00669843|47|LIC|0 ↔ doordash 905679same address and nameheld: same-source-conflict12
2026-11-12 14:25insertab-inbev 4866846 ↔ vtinfo 7a33fbccf5789e13same address and namemerged12