The Blue Fish Kitchen

Redwood City, CA 94063 · Ob439e9b9b288 · first seen 2026-10-08
3 sourceson premise · restaurantalcohol: unknown

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 Blue Fish Kitchen 2 other
the most common name a source states
the blue fish kitchen 1700 middlefield rd redwood city doordash
the blue fish kitchen redwood city doordash
Street
1603 Broadway St 1 other
ubereats
1603 Broadway overture
City
Redwood City
ubereatsno other value
State
CA
ubereatsno other value
ZIP
94063
ubereatsno other value
Pin
37.48666, -122.21883 map
ubereatsno other value
Phone
6692478589
overtureno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Of53b11c487c2; Obf6ff0c3f6d1; Oea13feab8a9e

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
doordashthe blue fish kitchen 1700 middlefield rd redwood city
34149575
1603 Broadway St, Redwood City, CA, 9406337.48665, -122.218932026-10-082026-10-23
doordashthe blue fish kitchen redwood city
34716551
1603 Broadway St, Redwood City, CA, 9406337.48665, -122.218932026-10-082026-11-18
overtureThe Blue Fish Kitchen
bad84472-13f4-427f-8b7a-8bcab564adcd
1603 Broadway, Redwood City, CA, 94063669247858937.48667, -122.218832026-11-182026-11-18
ubereatsThe Blue Fish Kitchen
KBDrmXZNWJ2ksUrQHTDxhg
1603 Broadway St, Redwood City, CA, 9406337.48666, -122.218832026-10-142026-11-02

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
doordash the blue fish kitchen redwood cityoverture The Blue Fish Kitchen1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 9 m apart · name similarity 1.00 · street similarity 0.84
doordash the blue fish kitchen redwood cityubereats The Blue Fish Kitchen1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
overture The Blue Fish Kitchenubereats The Blue Fish Kitchen1.00street written two waysmergedname Jaro-Winkler 1.00 · matched on zip · pins 1 m apart · name similarity 1.00 · street similarity 0.84
doordash the blue fish kitchen 1700 middlefield rd redwood cityubereats The Blue Fish Kitchen0.56Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (80% confident; asked as a “near” pair)
Both records carry the same distinctive name, The Blue Fish Kitchen, at the same street address, 1603 Broadway St, Redwood City, 0.01 km apart, so the names agree despite the shared building; the Midd
Other Claude answers on this pair:
  • Claude Opus 5.5, prompt v12: same, 85% confident — Same restaurant name and address
  • Claude Opus 5.5, prompt v9: same, 85% confident — Both records name The Blue Fish Kitchen at 1603 Broadway St, Redwood City, about 10 m apart; the DoorDash slug carries an extra address, 1700 Middlefield Rd, but its fetched page gives the same street address.
  • Claude Haiku 5.5, prompt v9: same, 80% confident — Both records name The Blue Fish Kitchen at the same street address (1603 Broadway St, Redwood City, 94063) with coordinates 0.01 km apart, though DoorDash's slug carries a different street number (1700 Middlefield Rd) that leaves some doubt.
  • Claude Haiku 5.5, prompt v7: same, 85% confident — Both records name The Blue Fish Kitchen at 1603 Broadway St, Redwood City 94063, with coordinates about 10 m apart and the same name, so they are one restaurant's two delivery listings; the stray '1700 middlefield rd' in DoorDash's slug is the only conflict and is outweighed by the matching street address and coordinates.
  • Claude Haiku 5.5, prompt v4: same, 80% confident — Both records carry the same name, The Blue Fish Kitchen, at 1603 Broadway St, Redwood City, ZIP 94063, with coordinates 0.01 km apart; the only conflict is a 1700 Middlefield Rd street number embedded in A's URL slug, which may be a stale or secondary listing, so confidence is moderate.
pair 06e41a9c5f017beab6fe

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
unknown — no licence on file and no chain evidence
Operator
none
Licence privileges
none
Rule version 10, computed 2026-11-18 20:37.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
281 within 1 mi · 720 within 3 mi
Off / on premise
45 / 189 within 1 mi · 136 / 456 within 3 mi
Selling alcohol
161 within 1 mi · 450 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.03 mi
Setting
urban (4,045 people per sq mi)
People within 3 mi
114,360 (85,860 adults 21+, 40,059 households) from 28 tract(s), tracts within 3 mi
Income
per capita $91,884 · median household ~$170,644 (weighted mean of tract medians)
Age and education
median age ~38.6 · bachelor's or higher 53%
Ethnicity
Hispanic 38% · White 43% · Black 3% · Asian 14%
Adults per alcohol outlet
191
Alcohol spend within 3 mi
$41,554,359 a year ($17,543,133 at home, $24,000,951 away) · $92,343 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:58insertoverture bad84472-13f4-427f-8b7a-8bcab564adcd ↔ ubereats KBDrmXZNWJ2ksUrQHTDxhgstreet written two waysmerged15
2026-11-18 18:58insertdoordash 34716551 ↔ overture bad84472-13f4-427f-8b7a-8bcab564adcdstreet written two waysmerged15
2026-11-18 18:58updatedoordash 34716551 ↔ ubereats KBDrmXZNWJ2ksUrQHTDxhgsame address and namemerged15
2026-11-16 14:56insertdoordash 34716551 ↔ ubereats KBDrmXZNWJ2ksUrQHTDxhgsame address and nameheld: same-source-conflict15
2026-11-02 23:02backfilldoordash 34149575 ↔ ubereats KBDrmXZNWJ2ksUrQHTDxhgClaude judge: samemerged