Mayflower Seafood Restaurant

Milpitas, CA 95035 · O12d434d558f7 · first seen 2026-10-08
5 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
Mayflower Seafood Restaurant 2 other
a source's own spelling of the licence name (record_title.py)
mayflower milpitas doordash
MAYFLOWER SOUTH BAY INC ca-abc (legal name)
Street
428 BARBER LN 1 other
ca-abc
428 Barber Lane doordash
City
MILPITAS
ca-abcno other value
State
CA
ca-abcno other value
ZIP
95035
ca-abcno other value
Pin
37.42159, -121.91630 map 2 other
doordash
122 m away ca-abc
114 m away inspections
Phone
4089222700
vtinfono other value
Licences
ca-abc 00399703|47|LIC|0
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Od106751e29ad; Ob3be458fe8b9; O59dbf6f7d8db; O41cc0105a420

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-abcMAYFLOWER SEAFOOD RESTAURANT
legal name: MAYFLOWER SOUTH BAY INC
00399703|47|LIC|0
428 BARBER LN, MILPITAS, CA, 9503537.42128, -121.917632026-10-082026-11-19
doordashmayflower milpitas
1151217
428 Barber Lane, Milpitas, CA, 9503537.42159, -121.916302026-10-082026-11-19
inspectionsMAYFLOWER SEAFOOD RESTAURANT
inspections|scc|PR0330084
428 BARBER LN, Milpitas, CA, 9503537.42127, -121.917532026-11-192026-11-19
overtureMayflower Seafood Restaurant
a41df8f7-1148-4368-be07-e8ff919e14fe
428 Barber Ln, Milpitas, CA, 95035408922270037.42167, -121.916182026-11-062026-11-19
vtinfoMAYFLOWER SEAFOOD RESTAURANT
ff239f9c01805823
428 BARBER LN, MILPITAS, CA, 95035408922270037.42166, -121.916392026-11-122026-11-19

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 MAYFLOWER SEAFOOD RESTAURANTinspections MAYFLOWER SEAFOOD RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 9 m apart · name similarity 1.00
ca-abc MAYFLOWER SEAFOOD RESTAURANToverture Mayflower Seafood Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 135 m apart · name similarity 1.00
ca-abc MAYFLOWER SEAFOOD RESTAURANTvtinfo MAYFLOWER SEAFOOD RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 117 m apart · name similarity 1.00
inspections MAYFLOWER SEAFOOD RESTAURANToverture Mayflower Seafood Restaurant1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 127 m apart · name similarity 1.00
inspections MAYFLOWER SEAFOOD RESTAURANTvtinfo MAYFLOWER SEAFOOD RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 109 m apart · name similarity 1.00
overture Mayflower Seafood Restaurantvtinfo MAYFLOWER SEAFOOD RESTAURANT1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 19 m apart · name similarity 1.00 · phone: equal
ca-abc MAYFLOWER SEAFOOD RESTAURANTdoordash mayflower milpitas0.49same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant, seafood · name Jaro-Winkler 0.86 · same street + city + state · pins 122 m apart · matched through the licence's legal name: MAYFLOWER SOUTH BAY INC · name similarity 0.49
doordash mayflower milpitasinspections MAYFLOWER SEAFOOD RESTAURANT0.41same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant, seafood · name Jaro-Winkler 0.86 · same street + ZIP · pins 114 m apart · name similarity 0.41
doordash mayflower milpitasoverture Mayflower Seafood Restaurant0.41same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant, seafood · name Jaro-Winkler 0.86 · same street + city + state · pins 14 m apart · name similarity 0.41
doordash mayflower milpitasvtinfo MAYFLOWER SEAFOOD RESTAURANT0.41same address and namemergedaddress similarity 1.00 · names match with these kind-of-place words set aside: restaurant, seafood · name Jaro-Winkler 0.86 · same street + city + state · pins 12 m apart · name similarity 0.41

Attributes

Channel
on_premise · restaurant — ca-licence
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
MAYFLOWER SOUTH BAY 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:32.
Every vote behind these (raw)
{
 "votes": [
  [
   "ca-licence",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

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-19 20:37insertdoordash 1151217 ↔ inspections inspections|scc|PR0330084same address and namemerged17
2026-11-19 20:37insertca-abc 00399703|47|LIC|0 ↔ inspections inspections|scc|PR0330084same address and namemerged17
2026-11-19 20:37insertinspections inspections|scc|PR0330084 ↔ overture a41df8f7-1148-4368-be07-e8ff919e14fesame address and namemerged17
2026-11-19 20:37insertinspections inspections|scc|PR0330084 ↔ vtinfo ff239f9c01805823same address and namemerged17
2026-11-14 20:23insertdoordash 1151217 ↔ overture a41df8f7-1148-4368-be07-e8ff919e14fesame address and namemerged15
2026-11-14 20:23insertdoordash 1151217 ↔ vtinfo ff239f9c01805823same address and namemerged15
2026-11-14 20:23insertca-abc 00399703|47|LIC|0 ↔ doordash 1151217same address and namemerged15
2026-11-12 14:25insertca-abc 00399703|47|LIC|0 ↔ vtinfo ff239f9c01805823same address and namemerged12
2026-11-12 14:25insertoverture a41df8f7-1148-4368-be07-e8ff919e14fe ↔ vtinfo ff239f9c01805823same address and namemerged12
2026-11-06 18:13insertca-abc 00399703|47|LIC|0 ↔ overture a41df8f7-1148-4368-be07-e8ff919e14fesame address and namemerged11