Farmer's Table

La Mesa, CA 91942 · O246a056e05ca · first seen 2026-10-08
5 sourceson premise · restaurantchain: Farmer's Tablealcohol: 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
Farmer's Table 3 other
a source's own spelling of the licence name (record_title.py)
FARMERS TABLE ca-abcinspectionsvtinfo ×3
farmer's table la mesa la mesa doordash
LA MESA FARMERS INC ca-abc (legal name)
Street
8141-8147 LA MESA BLVD 2 other
ca-abc
8141 LA MESA BLVD inspectionsoverturevtinfo ×3
8141 La Mesa Boulevard doordash
City
LA MESA
ca-abcno other value
State
CA
ca-abcno other value
ZIP
91941 1 other
ca-abc
91942 doordashinspectionsoverturevtinfo ×4
Pin
32.76380, -117.02153 map
doordashno other value
Phone
6197246465
vtinfono other value
Licences
ca-abc 00575312|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oa470f8ecf0b8; O46dcc6e3bac3; Oc2c01202f024; O62685fba5532

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-abcFARMERS TABLE
legal name: LA MESA FARMERS INC
00575312|47|LIC|0
8141-8147 LA MESA BLVD, LA MESA, CA, 9194132.76370, -117.021962026-10-082026-11-11
doordashfarmer's table la mesa la mesa
106105
8141 La Mesa Boulevard, La Mesa, CA, 9194232.76380, -117.021532026-10-082026-11-10
inspectionsFARMERS TABLE
inspections|sdcounty|DEH2016-FFPP-007101
8141 LA MESA BLVD, La Mesa, CA, 919422026-11-202026-11-20
overtureFarmer's Table
9ab45d46-5382-45f8-9b9b-57384c08b825
8141 La Mesa Blvd, La Mesa, CA, 91942619724646532.76370, -117.021602026-11-092026-11-09
vtinfoFARMERS TABLE
104b92cad04573ce
8141 LA MESA BLVD, LA MESA, CA, 91942619724646532.76369, -117.021542026-11-132026-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 FARMERS TABLEdoordash farmer's table la mesa la mesa1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (93% confident; asked as a “proximity” pair)
The records share a distinctive name (Farmers Table) at the same La Mesa Blvd street number, 0.04 km apart, and only one business is listed at the address; the ZIP difference is minor.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 8141 La Mesa Blvd in La Mesa with coordinates about 40 m apart, and the DoorDash slug 'farmer's table' matches the California ABC trade name FARMERS TABLE (legal entity LA MESA FARMERS INC); the only business at that address is a restaurant with a full-bar licence, which fits a delivery listing for the same restaurant.
  • Claude Haiku 5.5, prompt v7: same, 88% confident — The DoorDash listing 'farmer's table la mesa' at 8141 La Mesa Boulevard matches the California ABC restaurant 'FARMERS TABLE' at 8141-8147 La Mesa Blvd, with coordinates 41 m apart, one business at the address, and a ZIP difference that is plausible within La Mesa.
pair 5528deb6aa951b6145c1
ca-abc FARMERS TABLEvtinfo FARMERS TABLE1.00Claude judge: samemerged
Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “proximity” pair)
Same name Farmers Table, same address
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v9: same, 86% confident — Both records name FARMERS TABLE at 8141 LA MESA BLVD in La Mesa, CA, 39 m apart with one business at the address, and the California restaurant licence fits a venue that carries spirits and beer brands; the ZIP differs (91941 vs 91942), a minor mismatch in the same town.
pair 1a8ba24abc5005c41c11
doordash farmer's table la mesa la mesainspections FARMERS TABLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
doordash farmer's table la mesa la mesaoverture Farmer's Table1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00
doordash farmer's table la mesa la mesavtinfo FARMERS TABLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 12 m apart · name similarity 1.00
inspections FARMERS TABLEoverture Farmer's Table1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
inspections FARMERS TABLEvtinfo FARMERS TABLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Farmer's Tablevtinfo FARMERS TABLE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 5 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
Farmer's Table — overture-brand
Alcohol
licensed — a licence or TTB permit on file
Operator
LA MESA FARMERS INC — 1 outlets in the master under this operator
Licence privileges
beer_on, beer_off, wine_on, wine_off, spirits_on — CA 47
Rule version 11, computed 2026-11-20 23:33.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
151 within 1 mi · 777 within 3 mi
Off / on premise
40 / 90 within 1 mi · 204 / 451 within 3 mi
Selling alcohol
96 within 1 mi · 416 within 3 mi
Nearest
same channel 0.03 mi · licensed 0.04 mi
Setting
urban (6,339 people per sq mi)
People within 3 mi
179,230 (132,261 adults 21+, 65,007 households) from 37 tract(s), tracts within 3 mi
Income
per capita $45,304 · median household ~$97,483 (weighted mean of tract medians)
Age and education
median age ~36.8 · bachelor's or higher 38%
Ethnicity
Hispanic 34% · White 51% · Black 9% · Asian 8%
Adults per alcohol outlet
317
Alcohol spend within 3 mi
$49,221,916 a year ($22,081,630 at home, $27,119,158 away) · $118,038 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-20 22:08insertdoordash 106105 ↔ inspections inspections|sdcounty|DEH2016-FFPP-007101same address and namemerged17
2026-11-20 22:08insertinspections inspections|sdcounty|DEH2016-FFPP-007101 ↔ overture 9ab45d46-5382-45f8-9b9b-57384c08b825same address and namemerged17
2026-11-20 22:08insertinspections inspections|sdcounty|DEH2016-FFPP-007101 ↔ vtinfo 104b92cad04573cesame address and namemerged17
2026-11-19 20:37insertca-abc 00575312|47|LIC|0 ↔ vtinfo 104b92cad04573ceClaude judge: samemerged17
2026-11-13 14:10insertdoordash 106105 ↔ vtinfo 104b92cad04573cesame address and namemerged15
2026-11-13 14:10insertoverture 9ab45d46-5382-45f8-9b9b-57384c08b825 ↔ vtinfo 104b92cad04573cesame address and namemerged15
2026-11-11 12:56insertca-abc 00575312|47|LIC|0 ↔ doordash 106105Claude judge: samemerged12
2026-11-09 15:32insertdoordash 106105 ↔ overture 9ab45d46-5382-45f8-9b9b-57384c08b825same address and namemerged11