Farmstead Restaurant

SAINT HELENA, CA 94574 · O02dca6f31670 · 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
Farmstead Restaurant 4 other
a licence name in capitals, cleaned (derived; record_title.py)
Farmstead overturevtinfo ×2
FARMSTEAD LLC ca-abc (legal name) ×2
Farmstead At Long Meadow Ranch ubereats
farmstead at long meadow ranch st. helena doordash
Street
738 MAIN ST 1 other
ca-abc
738 Main Street doordashubereats ×2
City
SAINT HELENA 1 other
ca-abc
St. Helena doordashoverture ×2
State
CA
ca-abcno other value
ZIP
94574
ca-abcno other value
Pin
38.50108, -122.46307 map
ubereatsno other value
Phone
7079634555
vtinfono other value
Licences
ca-abc 00553809|47|LIC|0 · ca-abc 00553809|47|LIC|1
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oed1ff2808419; O97ee35dff782; O86a317ca86af; O7273c7a661ab; O6407fc512726

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-abcFARMSTEAD RESTAURANT
legal name: FARMSTEAD LLC
00553809|47|LIC|0
738 MAIN ST, SAINT HELENA, CA, 945742026-10-082026-11-17
ca-abcFARMSTEAD RESTAURANT
legal name: FARMSTEAD LLC
00553809|47|LIC|1
738 MAIN ST, SAINT HELENA, CA, 945742026-10-082026-11-17
doordashfarmstead at long meadow ranch st. helena
24851145
738 Main Street, St. Helena, CA, 94574
ZIP lookup: Saint Helena, CA
38.50109, -122.463052026-10-082026-11-17
overtureFarmstead
33cbe865-1def-414c-b1c0-9b8dfb3c9e3d
738 Main St, St Helena, CA, 94574
ZIP lookup: Saint Helena, CA
707963455538.50131, -122.463192026-11-062026-11-17
ubereatsFarmstead At Long Meadow Ranch
Pr5c81zoQE2lXb3GDEUHzA
738 Main Street, Saint Helena, CA, 9457438.50108, -122.463072026-10-132026-11-17
vtinfoFARMSTEAD
0119bfccbfb61910
738 MAIN ST, SAINT HELENA, CA, 94574707963455538.50086, -122.463282026-11-122026-11-17

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 FARMSTEAD RESTAURANTca-abc FARMSTEAD RESTAURANT1.00one licence filemergedfile: 00553809 · same_address
ca-abc FARMSTEAD RESTAURANToverture Farmstead1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: FARMSTEAD LLC · name similarity 1.00
ca-abc FARMSTEAD RESTAURANTvtinfo FARMSTEAD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · matched through the licence's legal name: FARMSTEAD LLC · name similarity 1.00
ca-abc FARMSTEAD RESTAURANToverture Farmstead1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · matched through the licence's legal name: FARMSTEAD LLC · name similarity 1.00
ca-abc FARMSTEAD RESTAURANTvtinfo FARMSTEAD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · matched through the licence's legal name: FARMSTEAD LLC · name similarity 1.00
overture Farmsteadvtinfo FARMSTEAD1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 50 m apart · name similarity 1.00 · phone: equal
doordash farmstead at long meadow ranch st. helenaubereats Farmstead At Long Meadow Ranch0.89same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.98 · same street + ZIP · pins 2 m apart · name similarity 0.89
ca-abc FARMSTEAD RESTAURANTubereats Farmstead At Long Meadow Ranch0.38Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (90% confident; asked as a “same-address” pair)
Same street address and ZIP, a single business at that address, and the names agree: 'Farmstead Restaurant' and 'Farmstead At Long Meadow Ranch' are one restaurant, consistent with A's restaurant lice
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 92% confident — Farmstead restaurant same address, trade name variant
  • Claude Haiku 5.5, prompt v9: same, 85% confident — Both records sit at 738 Main Street, Saint Helena CA 94574, with businesses_at_address of 1, and the name 'Farmstead' matches across the California licence's legal entity FARMSTEAD LLC and the Uber Eats listing 'Farmstead At Long Meadow Ranch'; the restaurant licence fits a restaurant storefront, so this is one operation.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records sit at 738 Main Street, Saint Helena 94574, and are the only business at that address in the data. The distinctive name 'Farmstead' matches, and the California licence is an eating-place restaurant licence, consistent with a restaurant listed on Uber Eats.
  • Claude Haiku 5.5, prompt v4: same, 85% confident — Both records give 738 Main Street, Saint Helena, CA 94574, the only business in our data at that address, and both name a Farmstead restaurant, which matches the on-sale eating place licence in record A; the trade name adds 'At Long Meadow Ranch' but the core name and premises agree.
pair 0aec00233f9d1c7aead6
ca-abc FARMSTEAD RESTAURANTubereats Farmstead At Long Meadow Ranch0.38Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (92% confident; asked as a “same-address” pair)
Both records share the same street address and ZIP, and both carry the distinctive name 'Farmstead', which is the restaurant at Long Meadow Ranch; our data holds only one business at that address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records give the same street address, city and ZIP (738 Main St, Saint Helena 94574), only one business is held at that address, and the shared name 'Farmstead' with a restaurant licence matches an Uber Eats restaurant listing.
pair cd3aa75ee8400acee738
doordash farmstead at long meadow ranch st. helenavtinfo FARMSTEAD0.30one name contains the other, same addressmergedjudge: None · pair_id: 03d373b9b1a3205c7ed0 · 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
FARMSTEAD LLC — 1 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)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
322 within 1 mi · 563 within 3 mi
Off / on premise
104 / 33 within 1 mi · 183 / 39 within 3 mi
Selling alcohol
314 within 1 mi · 554 within 3 mi
Nearest
same channel 0.00 mi · licensed 0.00 mi
Setting
rural (240 people per sq mi)
People within 3 mi
6,788 (5,351 adults 21+, 3,014 households) from 3 tract(s), tracts within 3 mi
Income
per capita $120,418 · median household ~$140,027 (weighted mean of tract medians)
Age and education
median age ~52.1 · bachelor's or higher 56%
Ethnicity
Hispanic 29% · White 68% · Black 0% · Asian 1%
Adults per alcohol outlet
10
Alcohol spend within 3 mi
$2,937,158 a year ($1,255,600 at home, $1,680,708 away) · $5,302 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-17 17:19insertdoordash 24851145 ↔ vtinfo 0119bfccbfb61910one name contains the other, same addressmerged15
2026-11-17 17:19insertdoordash 24851145 ↔ ubereats Pr5c81zoQE2lXb3GDEUHzAsame address and namemerged15
2026-11-14 20:23insertoverture 33cbe865-1def-414c-b1c0-9b8dfb3c9e3d ↔ vtinfo 0119bfccbfb61910same address and namemerged15
2026-11-12 14:25insertca-abc 00553809|47|LIC|1 ↔ vtinfo 0119bfccbfb61910same address and namemerged12
2026-11-12 14:25insertca-abc 00553809|47|LIC|0 ↔ vtinfo 0119bfccbfb61910same address and namemerged12
2026-11-06 18:13insertca-abc 00553809|47|LIC|0 ↔ overture 33cbe865-1def-414c-b1c0-9b8dfb3c9e3dsame address and namemerged11
2026-11-06 18:13insertca-abc 00553809|47|LIC|1 ↔ overture 33cbe865-1def-414c-b1c0-9b8dfb3c9e3dsame address and namemerged11
2026-11-02 23:02backfillca-abc 00553809|47|LIC|1 ↔ ubereats Pr5c81zoQE2lXb3GDEUHzAClaude judge: samemerged
2026-11-02 23:02backfillca-abc 00553809|47|LIC|0 ↔ ubereats Pr5c81zoQE2lXb3GDEUHzAClaude judge: samemerged
2026-10-09 13:59backfillca-abc 00553809|47|LIC|0 ↔ ca-abc 00553809|47|LIC|1one licence filemerged