Big Apple Food Store

WINDHAM, ME 04062 · O0ac2ca38734e · first seen 2026-10-08
3 sourcesoff premise · conveniencechain: Big Apple Storesalcohol: 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
Big Apple Food Store 1 other
a licence name in capitals, cleaned (derived; record_title.py)
Big Apple Store overture
Street
809 ROOSEVELT TRL
ab-inbevno other value
City
WINDHAM
ab-inbevno other value
State
ME
ab-inbevno other value
ZIP
04062
ab-inbevno other value
Pin
43.84011, -70.44310 map
overtureno other value
Phone
2078928792
hempno other value
Licences
none on file
every licence and permit record in the outlet
Joined by address+name · absorbed ids: O18dcf9be70df; Od4f54b06db4a

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-inbevBIG APPLE FOOD STORE
184626
809 ROOSEVELT TRL, WINDHAM, ME, 0406243.84013, -70.443102026-11-132026-11-13
hempBIG APPLE FOOD STORE
3f1f98192140b8b0
809 ROOSEVELT TRL, WINDHAM, ME, 04062207892879243.84021, -70.443032026-10-082026-11-06
overtureBig Apple Store
a844844e-3ad2-463e-aea5-2f878ca55958
809 Roosevelt Trl, Windham, ME, 04062207892879243.84011, -70.443102026-11-062026-11-06

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 BIG APPLE FOOD STOREhemp BIG APPLE FOOD STORE1.00same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 10 m apart · name similarity 1.00
ab-inbev BIG APPLE FOOD STOREoverture Big Apple Store0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 2 m apart · name similarity 0.72
hemp BIG APPLE FOOD STOREoverture Big Apple Store0.72same address and namemergedaddress similarity 1.00 · name Jaro-Winkler 0.93 · same street + ZIP · pins 12 m apart · name similarity 0.72 · phone: equal

Attributes

Channel
off_premise · convenience — overture-category
Chain
Big Apple Stores — overture-brand
Alcohol
alcohol — listed as carrying Bud Light (AB InBev), Michelob Ultra (AB InBev) by the supplier's own store finder or locator
Operator
none
Licence privileges
none
Rule version 11, computed 2026-11-19 21:40.
Every vote behind these (raw)
{
 "votes": [
  [
   "overture-category",
   "off_premise",
   "convenience"
  ]
 ]
}

Trade area

Other outlets
65 within 1 mi · 83 within 3 mi
Off / on premise
23 / 27 within 1 mi · 31 / 31 within 3 mi
Selling alcohol
40 within 1 mi · 51 within 3 mi
Nearest
same channel 0.01 mi · licensed 0.10 mi
Setting
rural (273 people per sq mi)
People within 3 mi
7,711 (6,105 adults 21+, 3,268 households) from 2 tract(s), tracts within 3 mi
Income
per capita $50,670 · median household ~$94,456 (weighted mean of tract medians)
Age and education
median age ~43.4 · bachelor's or higher 46%
Ethnicity
Hispanic 2% · White 87% · Black 2% · Asian 2%
Adults per alcohol outlet
117
Alcohol spend within 3 mi
$2,471,973 a year ($1,102,617 at home, $1,368,571 away) · $47,538 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-13 17:47insertab-inbev 184626 ↔ overture a844844e-3ad2-463e-aea5-2f878ca55958same address and namemerged15
2026-11-13 17:47insertab-inbev 184626 ↔ hemp 3f1f98192140b8b0same address and namemerged15
2026-11-06 18:13inserthemp 3f1f98192140b8b0 ↔ overture a844844e-3ad2-463e-aea5-2f878ca55958same address and namemerged11