THE CRAFTY CRAB

FAIRVIEW HEIGHTS, IL 62208 · O0fe84ab62b17 · first seen 2026-10-08
4 sourceson premise · restaurantalcohol: alcohol

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 CRAFTY CRAB 2 other
the most common name a source states
Crafty Crab overture
crafty crab fairview heights doordash
Street
51 Ludwig Drive 1 other
doordash
51 LUDWIG DR ab-inbevoverturevtinfo ×3
City
Fairview Heights
doordashno other value
State
IL
doordashno other value
ZIP
62208
doordashno other value
Pin
38.60109, -89.98972 map
doordashno other value
Phone
6184891153
vtinfono other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: Oe02a71b73509; O9d219783050d; Occ0b8912a294

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
ab-inbevTHE CRAFTY CRAB
4817829
51 LUDWIG DR, FAIRVIEW HEIGHTS, IL, 6220838.60116, -89.989912026-11-132026-11-13
doordashcrafty crab fairview heights
1917211
51 Ludwig Drive, Fairview Heights, IL, 6220838.60109, -89.989722026-10-082026-11-15
overtureCrafty Crab
549226a9-3ab0-4bd6-a085-8dcb69a63b63
51 Ludwig Dr, Fairview Heights, IL, 62208618489115338.60107, -89.989692026-11-132026-11-13
vtinfoTHE CRAFTY CRAB
80fa3fe977b9e292
51 LUDWIG DR, FAIRVIEW HEIGHTS, IL, 62208618489115338.60116, -89.989642026-11-152026-11-15

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
ab-inbev THE CRAFTY CRABdoordash crafty crab fairview heights1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 18 m apart · name similarity 1.00
ab-inbev THE CRAFTY CRABoverture Crafty Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 22 m apart · name similarity 1.00
ab-inbev THE CRAFTY CRABvtinfo THE CRAFTY CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 23 m apart · name similarity 1.00
doordash crafty crab fairview heightsoverture Crafty Crab1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + city + state · pins 4 m apart · name similarity 1.00
doordash crafty crab fairview heightsvtinfo THE CRAFTY CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
overture Crafty Crabvtinfo THE CRAFTY CRAB1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 11 m apart · name similarity 1.00 · phone: equal

Attributes

Channel
on_premise · restaurant — doordash-url
Chain
none
Alcohol
alcohol — listed as carrying Bacardi USA, Boston Beer, Bud Light (AB InBev) +3 more by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 7, computed 2026-11-16 17:14.
Every vote behind these (raw)
{
 "votes": [
  [
   "doordash-url",
   "on_premise",
   "restaurant"
  ],
  [
   "overture-category",
   "on_premise",
   "restaurant"
  ]
 ]
}

Trade area

Other outlets
100 within 1 mi · 210 within 3 mi
Off / on premise
42 / 46 within 1 mi · 73 / 107 within 3 mi
Selling alcohol
31 within 1 mi · 87 within 3 mi
Nearest
same channel 0.06 mi · licensed 0.44 mi
Setting
suburban (1,248 people per sq mi)
People within 3 mi
35,273 (25,797 adults 21+, 14,370 households) from 7 tract(s), tracts within 3 mi
Income
per capita $46,403 · median household ~$91,124 (weighted mean of tract medians)
Age and education
median age ~38.8 · bachelor's or higher 39%
Ethnicity
Hispanic 6% · White 63% · Black 23% · Asian 3%
Adults per alcohol outlet
293
Alcohol spend within 3 mi
$10,089,992 a year ($4,592,166 at home, $5,493,563 away) · $114,659 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:24insertoverture 549226a9-3ab0-4bd6-a085-8dcb69a63b63 ↔ vtinfo 80fa3fe977b9e292same address and namemerged15
2026-11-15 16:24insertab-inbev 4817829 ↔ vtinfo 80fa3fe977b9e292same address and namemerged15
2026-11-15 16:24insertdoordash 1917211 ↔ vtinfo 80fa3fe977b9e292same address and namemerged15
2026-11-14 20:23insertdoordash 1917211 ↔ overture 549226a9-3ab0-4bd6-a085-8dcb69a63b63same address and namemerged15
2026-11-14 20:23insertab-inbev 4817829 ↔ doordash 1917211same address and namemerged15
2026-11-13 19:03insertab-inbev 4817829 ↔ overture 549226a9-3ab0-4bd6-a085-8dcb69a63b63same address and namemerged15