Outlets /
Zerka Food Center
FLINT, MI 48505 · O0c594cf02e60 · first seen 2026-10-08
6 sourcesoff premise · liquor_storechain: Zerka Food Centeralcohol: licensed2 licences
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.
| Field | Master value | Taken from | What other sources say |
|---|---|---|---|
| Name | Zerka Food Center 3 other | a source's own spelling of the licence name (record_title.py) | AVIRAJ, LLC mi-lcc (legal name) ×2 Zerka's Food Center overture zerka's food center flint doordash |
| Street | 523-525 W CARPENTER RD 3 other | mi-lcc | 523 West Carpenter Road doordashubereats ×2 525 W CARPENTER ab-inbevvtinfo ×2 523 W Carpenter Rd overture |
| City | FLINT | mi-lcc | no other value |
| State | MI | mi-lcc | no other value |
| ZIP | 48505 | mi-lcc | no other value |
| Pin | 43.07524, -83.71111 map 3 other | ubereats | 58 m away mi-lcc ×2 67 m away ab-inbev 111 m away vtinfo |
| Phone | 8107873188 2 other | vtinfo | 9172510756 mi-lcc ×2 8107683761 overture |
| Licences | mi-lcc L-000439720 · mi-lcc L-000439721 | every licence and permit record in the outlet |
Joined by address+name · absorbed ids: O9ca398a701bc; Ob41a9fc5257c; O55987e7cccb6; O34fa3150b294; Od9e77e6ff68c; O13ef551402c4
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.
| Source | Name | Address | Phone | Coordinates | First seen | Updated |
|---|---|---|---|---|---|---|
| ab-inbev | ZERKA FOOD CENTER 139470 | 525 W CARPENTER, FLINT, MI, 48505 | 43.07551, -83.71038 | 2026-11-11 | 2026-11-14 | |
| doordash | zerka's food center flint 27857861 | 523 West Carpenter Road, Flint, MI, 48505 | 43.07531, -83.71110 | 2026-10-08 | 2026-11-14 | |
| mi-lcc | ZERKA FOOD CENTER legal name: AVIRAJ, LLC L-000439720 | 523-525 W CARPENTER RD, FLINT, MI, 48505 | 9172510756 | 43.07550, -83.71049 | 2026-11-03 | 2026-11-14 |
| mi-lcc | ZERKA FOOD CENTER legal name: AVIRAJ, LLC L-000439721 | 523-525 W CARPENTER RD, FLINT, MI, 48505 | 9172510756 | 43.07550, -83.71049 | 2026-11-03 | 2026-11-14 |
| overture | Zerka's Food Center ff9d2540-ea36-4bfd-9b0e-7c067c43a387 | 523 W Carpenter Rd, Flint, MI, 48505 | 8107683761 | 43.07542, -83.71111 | 2026-11-06 | 2026-11-14 |
| ubereats | Zerka Food Center _B5bpzONWCu_viA9x61_mw | 523 West Carpenter Road, Flint, MI, 48505 | 43.07524, -83.71111 | 2026-10-29 | 2026-11-14 | |
| vtinfo | ZERKA FOOD CENTER 986c3add72317030 | 525 W CARPENTER, FLINT, MI, 48505 | 8107873188 | 43.07545, -83.70978 | 2026-11-14 | 2026-11-14 |
Matching
Every link between these records: the rule that made it (or the reason the master declined it) and the evidence.
| Record A | Record B | Name match | Rule | Decision | Evidence |
|---|---|---|---|---|---|
| ab-inbev ZERKA FOOD CENTER | mi-lcc ZERKA FOOD CENTER | 1.00 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (95% confident; asked as a “proximity” pair) Identical name, overlapping address Other Claude answers on this pair:
pair 2ec78d6b9f461d7cfd14 |
| ab-inbev ZERKA FOOD CENTER | vtinfo ZERKA FOOD CENTER | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 49 m apart · name similarity 1.00 |
| doordash zerka's food center flint | overture Zerka's Food Center | 1.00 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 1.00 · same street + ZIP · pins 12 m apart · name similarity 1.00 |
| mi-lcc ZERKA FOOD CENTER | mi-lcc ZERKA FOOD CENTER | 1.00 | one store listed twice | merged | same street + ZIP · name: identical |
| mi-lcc ZERKA FOOD CENTER | ubereats Zerka Food Center | 1.00 | Claude judge: same | merged | Claude Opus 5.5, prompt v12 said same (92% confident; asked as a “proximity” pair) Same name, same address Other Claude answers on this pair:
pair 4af952dff3d081f6c835 |
| mi-lcc ZERKA FOOD CENTER | ubereats Zerka Food Center | 1.00 | Claude judge: same | merged | Claude Opus 5.5, prompt v9 said same (95% confident; asked as a “proximity” pair) The two records share the same distinctive name 'Zerka Food Center' at the same address (523 W Carpenter Rd, Flint 48505), with coordinates 58 m apart, so the names agree despite the shared building. Other Claude answers on this pair:
pair a12ca2f1c175a638ff92 |
| doordash zerka's food center flint | ubereats Zerka Food Center | 0.85 | same address and name | merged | address similarity 1.00 · same street + ZIP · pins 8 m apart · name similarity 0.85 |
| overture Zerka's Food Center | ubereats Zerka Food Center | 0.74 | same address and name | merged | address similarity 1.00 · name Jaro-Winkler 0.99 · same street + ZIP · pins 20 m apart · name similarity 0.74 |
Attributes
- Channel
- off_premise · liquor_store — ubereats-type
- Chain
- Zerka Food Center — ubereats-parent
- Alcohol
- licensed — a licence or TTB permit on file
- Operator
- AVIRAJ, LLC — 1 outlets in the master under this operator
- Licence privileges
- beer_off, wine_off, spirits_off — MI Retail - Off Premises/Specially Designated Distributor; MI Retail - Off Premises/Specially Designated Merchant
Rule version 10, computed 2026-11-18 20:34.
Every vote behind these (raw)
{
"ue_location": [
"GROCERY_STORE"
],
"votes": [
[
"ubereats-type",
"off_premise",
"liquor_store"
],
[
"doordash-url",
"off_premise",
null
],
[
"overture-category",
"off_premise",
null
]
]
}Trade area
- Other outlets
- 12 within 1 mi · 129 within 3 mi
- Off / on premise
- 3 / 5 within 1 mi · 43 / 39 within 3 mi
- Selling alcohol
- 7 within 1 mi · 90 within 3 mi
- Nearest
- same channel 0.43 mi · licensed 0.43 mi
- Setting
- suburban (1,607 people per sq mi)
- People within 3 mi
- 45,427 (31,711 adults 21+, 19,137 households) from 23 tract(s), tracts within 3 mi
- Income
- per capita $20,958 · median household ~$36,752 (weighted mean of tract medians)
- Age and education
- median age ~36.6 · bachelor's or higher 8%
- Ethnicity
- Hispanic 5% · White 28% · Black 65% · Asian 0%
- Adults per alcohol outlet
- 348
- Alcohol spend within 3 mi
- $7,099,922 a year ($3,673,538 at home, $3,423,094 away) · $78,021 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”).
| When | Event | Pair | Rule | Decision | Rule version |
|---|---|---|---|---|---|
| 2026-11-14 20:23 | insert | ab-inbev 139470 ↔ vtinfo 986c3add72317030 | same address and name | merged | 15 |
| 2026-11-12 17:29 | insert | mi-lcc L-000439720 ↔ ubereats _B5bpzONWCu_viA9x61_mw | Claude judge: same | merged | 14 |
| 2026-11-12 17:29 | insert | ab-inbev 139470 ↔ mi-lcc L-000439720 | Claude judge: same | merged | 14 |
| 2026-11-12 14:25 | insert | mi-lcc L-000439721 ↔ ubereats _B5bpzONWCu_viA9x61_mw | Claude judge: same | merged | 12 |
| 2026-11-06 18:13 | insert | overture ff9d2540-ea36-4bfd-9b0e-7c067c43a387 ↔ ubereats _B5bpzONWCu_viA9x61_mw | same address and name | merged | 11 |
| 2026-11-06 18:13 | insert | doordash 27857861 ↔ overture ff9d2540-ea36-4bfd-9b0e-7c067c43a387 | same address and name | merged | 11 |
| 2026-11-03 13:33 | backfill | mi-lcc L-000439720 ↔ mi-lcc L-000439721 | one store listed twice | merged | |
| 2026-11-01 21:05 | backfill | doordash 27857861 ↔ ubereats _B5bpzONWCu_viA9x61_mw | same address and name | merged |