Ballard Beer Box

SEATTLE, WA 98107 · O0a0d5c81790a · first seen 2026-10-08
4 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
Ballard Beer Box 1 other
a source's own spelling of the licence name (record_title.py)
ballard beer box seattle doordash
Street
2446 NW MARKET ST 1 other
wa-lcb
2446 Northwest Market Street doordash
City
SEATTLE
wa-lcbno other value
State
WA
wa-lcbno other value
ZIP
98107
wa-lcbno other value
Pin
47.66881, -122.38960 map 1 other
ubereats
102 m away wa-lcb
Phone
2062680939 1 other
overture
2064912063 wa-lcb
Licences
wa-lcb WA|433757|BEER/WINE REST - BEER/WINE
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Ofc5aac695e25; Of233f79cf32d; O81a279b3c20e

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
doordashballard beer box seattle
27586980
2446 Northwest Market Street, Seattle, WA, 9810747.66884, -122.389592026-10-082026-11-03
overtureBallard Beer Box
28beba21-2ac7-4a1f-897a-9e4dabc1e2cf
2446 NW Market St, Seattle, WA, 98107206268093947.66894, -122.389672026-11-062026-11-06
ubereatsBALLARD BEER BOX
LhxiKyW8XZS7DHM5u2n7DQ
2446 NW MARKET ST, SEATTLE, WA, 9810747.66881, -122.389602026-10-082026-10-08
wa-lcbBALLARD BEER BOX
WA|433757|BEER/WINE REST - BEER/WINE
2446 NW MARKET ST, SEATTLE, WA, 98107206491206347.66873, -122.388242026-11-152026-11-16

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 ballard beer box seattleoverture Ballard Beer Box1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00
doordash ballard beer box seattleubereats BALLARD BEER BOX1.00Claude judge: samemerged
Claude Opus 5.5, prompt v7 said same (97% confident; asked as a “near” pair)
Same distinctive name (the DoorDash slug with the city appended), the same street address and ZIP, coordinates 4 m apart, and only one business known at the address.
Other Claude answers on this pair:
  • Claude Haiku 5.5, prompt v7: same, 95% confident — Both records give the same name (Ballard Beer Box), the same street address with NW Market St abbreviation, the same city, ZIP, and coordinates within 4 m, and no other business is held at that address.
  • Claude Haiku 5.5, prompt v4: same, 95% confident — Both records name Ballard Beer Box at 2446 NW Market St, Seattle 98107, with matching ZIP and coordinates within about 4 metres, and no other business is held at that address.
pair 1b1f9c0cda9001950761
doordash ballard beer box seattlewa-lcb BALLARD BEER BOX1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00
overture Ballard Beer Boxubereats BALLARD BEER BOX1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 16 m apart · name similarity 1.00
overture Ballard Beer Boxwa-lcb BALLARD BEER BOX1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00 · phone: differs
ubereats BALLARD BEER BOXwa-lcb BALLARD BEER BOX1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · name similarity 1.00

Attributes

Channel
on_premise · restaurant — ubereats-type
Chain
none
Alcohol
licensed — a licence or TTB permit on file
Operator
none
Licence privileges
none — WA BEER/WINE REST - BEER/WINE (not mapped)
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
 "ue_location": [
  "PHYSICAL"
 ],
 "votes": [
  [
   "ubereats-type",
   "on_premise",
   "restaurant"
  ],
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "bar"
  ]
 ]
}

Trade area

Other outlets
263 within 1 mi · 1,044 within 3 mi
Off / on premise
45 / 122 within 1 mi · 179 / 530 within 3 mi
Selling alcohol
184 within 1 mi · 742 within 3 mi
Nearest
same channel 0.02 mi · licensed 0.04 mi
Setting
urban (6,241 people per sq mi)
People within 3 mi
176,472 (145,617 adults 21+, 84,468 households) from 39 tract(s), tracts within 3 mi
Income
per capita $98,538 · median household ~$155,854 (weighted mean of tract medians)
Age and education
median age ~36.7 · bachelor's or higher 77%
Ethnicity
Hispanic 7% · White 73% · Black 2% · Asian 11%
Adults per alcohol outlet
196
Alcohol spend within 3 mi
$85,249,714 a year ($36,217,537 at home, $49,006,807 away) · $114,737 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-15 16:24insertubereats LhxiKyW8XZS7DHM5u2n7DQ ↔ wa-lcb WA|433757|BEER/WINE REST - BEER/WINEsame address and namemerged15
2026-11-15 16:24insertoverture 28beba21-2ac7-4a1f-897a-9e4dabc1e2cf ↔ wa-lcb WA|433757|BEER/WINE REST - BEER/WINEsame address and namemerged15
2026-11-15 16:24insertdoordash 27586980 ↔ wa-lcb WA|433757|BEER/WINE REST - BEER/WINEsame address and namemerged15
2026-11-06 18:13insertdoordash 27586980 ↔ overture 28beba21-2ac7-4a1f-897a-9e4dabc1e2cfsame address and namemerged11
2026-11-06 18:13insertoverture 28beba21-2ac7-4a1f-897a-9e4dabc1e2cf ↔ ubereats LhxiKyW8XZS7DHM5u2n7DQsame address and namemerged11
2026-11-02 23:02backfilldoordash 27586980 ↔ ubereats LhxiKyW8XZS7DHM5u2n7DQClaude judge: samemerged